APPS.AHL_VISIT_TYPE_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_VISIT_TYPE_PVT AS
2: /* $Header: AHLVVTPB.pls 120.2.12020000.2 2012/12/11 05:39:21 prakkum noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VISIT_TYPE_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: -- constants for WHO Columns
8: G_LAST_UPDATE_DATE DATE := SYSDATE;
9: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;

Line 134: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In g_exc_unexpected_error block ' || ' x_msg_count ' || x_msg_count );

130: Fnd_Msg_Pub.count_and_get (
131: p_encoded => Fnd_Api.g_false,
132: p_count => x_msg_count,
133: p_data => x_msg_data);
134: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In g_exc_unexpected_error block ' || ' x_msg_count ' || x_msg_count );
135:
136: WHEN Fnd_Api.g_exc_unexpected_error THEN
137: ROLLBACK TO Delete_Visit_Type;
138: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

Line 143: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In g_exc_unexpected_error block ' || ' x_msg_count ' || x_msg_count );

139: Fnd_Msg_Pub.count_and_get (
140: p_encoded => Fnd_Api.g_false,
141: p_count => x_msg_count,
142: p_data => x_msg_data);
143: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In g_exc_unexpected_error block ' || ' x_msg_count ' || x_msg_count );
144:
145:
146: WHEN OTHERS THEN
147: ROLLBACK TO Delete_Visit_Type;

Line 157: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In OTHERS block ' || ' x_msg_count ' || x_msg_count );

153: Fnd_Msg_Pub.count_and_get (
154: p_encoded => Fnd_Api.g_false,
155: p_count => x_msg_count,
156: p_data => x_msg_data);
157: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In OTHERS block ' || ' x_msg_count ' || x_msg_count );
158:
159: END Delete_Visit_Type;
160:
161: -------------------------------------------------------------------

Line 336: AHL_DEBUG_PUB.debug(L_DEBUG || ': p_visit_type_id-' || p_visit_type_id || ': About to Complete visit type');

332:
333: --If Return Status is successful, there has been no error in deleting the record already in complete status
334: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
335:
336: AHL_DEBUG_PUB.debug(L_DEBUG || ': p_visit_type_id-' || p_visit_type_id || ': About to Complete visit type');
337:
338: UPDATE AHL_VISIT_TYPES_B
339: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
340: LAST_UPDATE_DATE = G_LAST_UPDATE_DATE,

Line 376: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In g_exc_error block ' || ' x_msg_count ' || x_msg_count );

372: Fnd_Msg_Pub.count_and_get (
373: p_encoded => Fnd_Api.g_false,
374: p_count => x_msg_count,
375: p_data => x_msg_data);
376: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In g_exc_error block ' || ' x_msg_count ' || x_msg_count );
377:
378: WHEN Fnd_Api.g_exc_unexpected_error THEN
379: ROLLBACK TO Complete_Visit_Type;
380: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;

Line 385: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In G_EXC_UNEXPECTED_ERROR block ' || ' x_msg_count ' || x_msg_count );

381: Fnd_Msg_Pub.count_and_get (
382: p_encoded => Fnd_Api.g_false,
383: p_count => x_msg_count,
384: p_data => x_msg_data);
385: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In G_EXC_UNEXPECTED_ERROR block ' || ' x_msg_count ' || x_msg_count );
386:
387:
388: WHEN OTHERS THEN
389: ROLLBACK TO Complete_Visit_Type;

Line 399: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In OTHERS block ' || ' x_msg_count ' || x_msg_count );

395: Fnd_Msg_Pub.count_and_get (
396: p_encoded => Fnd_Api.g_false,
397: p_count => x_msg_count,
398: p_data => x_msg_data);
399: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In OTHERS block ' || ' x_msg_count ' || x_msg_count );
400:
401: END Complete_Visit_Type;
402:
403: -------------------------------------------------------------------