eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on AHL_DEBUG_PUB

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

22: -----------------------------------------------------------------
23: -- Define Global CONSTANTS --
24: -----------------------------------------------------------------
25: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_VWP_VISIT_STAGES_PVT';
26: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
27: ---------------------------------------------------------------------
28: -- Define Record Types for record structures needed by the APIs --
29: ---------------------------------------------------------------------
30: -- NO RECORD TYPES *************

Line 160: AHL_DEBUG_PUB.enable_debug;

156: SAVEPOINT Get_Stages_Details;
157:
158: -- Check if API is called in debug mode. If yes, enable debug.
159: IF G_DEBUG='Y' THEN
160: AHL_DEBUG_PUB.enable_debug;
161: END IF;
162:
163: -- Debug info.
164: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

Line 164: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

160: AHL_DEBUG_PUB.enable_debug;
161: END IF;
162:
163: -- Debug info.
164: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
165: IF G_DEBUG='Y' THEN
166: AHL_DEBUG_PUB.debug( l_full_name ||':*****Start*****');
167: END IF;
168: END IF;

Line 166: AHL_DEBUG_PUB.debug( l_full_name ||':Start');

162:
163: -- Debug info.
164: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
165: IF G_DEBUG='Y' THEN
166: AHL_DEBUG_PUB.debug( l_full_name ||':*****Start*****');
167: END IF;
168: END IF;
169:
170: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 265: AHL_DEBUG_PUB.enable_debug;

261: p_encoded => Fnd_Api.g_false);
262:
263: -- Check if API is called in debug mode. If yes, enable debug.
264: IF G_DEBUG='Y' THEN
265: AHL_DEBUG_PUB.enable_debug;
266: END IF;
267:
268: -- Debug info.
269: -- Commented by amagrawa as per review comments.

Line 270: -- IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

266: END IF;
267:
268: -- Debug info.
269: -- Commented by amagrawa as per review comments.
270: -- IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
271: IF G_DEBUG='Y' THEN
272: AHL_DEBUG_PUB.debug(L_FULL_NAME||'AHL_VWP_Tasks_PVT - End');
273: END IF;
274: -- END IF;

Line 272: AHL_DEBUG_PUB.debug(L_FULL_NAME||'AHL_VWP_Tasks_PVT - End');

268: -- Debug info.
269: -- Commented by amagrawa as per review comments.
270: -- IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
271: IF G_DEBUG='Y' THEN
272: AHL_DEBUG_PUB.debug(L_FULL_NAME||'AHL_VWP_Tasks_PVT - End');
273: END IF;
274: -- END IF;
275:
276: -- Check if API is called in debug mode. If yes, disable debug.

Line 278: AHL_DEBUG_PUB.disable_debug;

274: -- END IF;
275:
276: -- Check if API is called in debug mode. If yes, disable debug.
277: IF G_DEBUG='Y' THEN
278: AHL_DEBUG_PUB.disable_debug;
279: END IF;
280: RETURN;
281:
282: EXCEPTION

Line 351: Ahl_Debug_Pub.enable_debug;

347: SAVEPOINT Create_Stage;
348:
349: -- Check if API is called in debug mode. If yes, enable debug.
350: IF G_DEBUG='Y' THEN
351: Ahl_Debug_Pub.enable_debug;
352: END IF;
353:
354: -- Debug info.
355: IF G_DEBUG='Y' THEN

Line 356: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');

352: END IF;
353:
354: -- Debug info.
355: IF G_DEBUG='Y' THEN
356: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');
357: END IF;
358:
359: -- Initialize message list if p_init_msg_list is set to TRUE.
360: IF Fnd_Api.to_boolean(p_init_msg_list)

Line 389: AHL_DEBUG_PUB.Debug( l_full_name ||':START VALIDATE');

385:
386: -------------------------------- Validate -----------------------------------------
387:
388: IF G_DEBUG='Y' THEN
389: AHL_DEBUG_PUB.Debug( l_full_name ||':START VALIDATE');
390: END IF;
391:
392: --
393: -- Check for the ID.

Line 437: AHL_DEBUG_PUB.Debug( l_full_name ||':END VALIDATE');

433: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
434: END IF;
435: */
436: IF G_DEBUG='Y' THEN
437: AHL_DEBUG_PUB.Debug( l_full_name ||':END VALIDATE');
438: END IF;
439:
440: -------------------------- Insert --------------------------
441: IF G_DEBUG='Y' THEN

Line 442: AHL_DEBUG_PUB.Debug( l_full_name ||':Insert');

438: END IF;
439:
440: -------------------------- Insert --------------------------
441: IF G_DEBUG='Y' THEN
442: AHL_DEBUG_PUB.Debug( l_full_name ||':Insert');
443: END IF;
444:
445:
446: FOR I IN 1..L_STAGE_COUNT

Line 485: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);

481: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
482: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
483:
484: IF G_DEBUG='Y' THEN
485: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);
486: AHL_DEBUG_PUB.Debug( l_full_name ||': STAGE Number =' || I);
487: END IF;
488: END LOOP;
489:

Line 486: AHL_DEBUG_PUB.Debug( l_full_name ||': STAGE Number =' || I);

482: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID);
483:
484: IF G_DEBUG='Y' THEN
485: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);
486: AHL_DEBUG_PUB.Debug( l_full_name ||': STAGE Number =' || I);
487: END IF;
488: END LOOP;
489:
490: ---------------------------End of API Body---------------------------------------

Line 506: AHL_DEBUG_PUB.Debug( l_full_name ||':End');

502: COMMIT;
503: END IF;
504:
505: IF G_DEBUG='Y' THEN
506: AHL_DEBUG_PUB.Debug( l_full_name ||':End');
507: END IF;
508:
509: -- Check if API is called in debug mode. If yes, disable debug.
510: IF G_DEBUG='Y' THEN

Line 511: Ahl_Debug_Pub.disable_debug;

507: END IF;
508:
509: -- Check if API is called in debug mode. If yes, disable debug.
510: IF G_DEBUG='Y' THEN
511: Ahl_Debug_Pub.disable_debug;
512: END IF;
513: EXCEPTION
514: WHEN Fnd_Api.g_exc_error THEN
515: ROLLBACK TO Create_Stage;

Line 610: Ahl_Debug_Pub.enable_debug;

606: SAVEPOINT Update_Stages;
607:
608: -- Check if API is called in debug mode. If yes, enable debug.
609: IF G_DEBUG='Y' THEN
610: Ahl_Debug_Pub.enable_debug;
611: END IF;
612:
613: -- Debug info.
614: IF G_DEBUG='Y' THEN

Line 615: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');

611: END IF;
612:
613: -- Debug info.
614: IF G_DEBUG='Y' THEN
615: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');
616: END IF;
617:
618: -- Initialize message list if p_init_msg_list is set to TRUE.
619: IF Fnd_Api.to_boolean(p_init_msg_list)

Line 674: AHL_DEBUG_PUB.Debug( l_full_name ||':Insert');

670: END IF;
671: */
672: -------------------------- Update --------------------------
673: IF G_DEBUG='Y' THEN
674: AHL_DEBUG_PUB.Debug( l_full_name ||':Insert');
675: END IF;
676:
677:
678: FOR i IN p_x_stages_tbl.FIRST..p_x_stages_tbl.LAST

Line 682: AHL_DEBUG_PUB.Debug( l_full_name ||':START VALIDATE');

678: FOR i IN p_x_stages_tbl.FIRST..p_x_stages_tbl.LAST
679: loop
680:
681: IF G_DEBUG='Y' THEN
682: AHL_DEBUG_PUB.Debug( l_full_name ||':START VALIDATE');
683: END IF;
684:
685: -------------------------------- Validate -----------------------------------------
686: l_validate_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 705: AHL_DEBUG_PUB.Debug( l_full_name ||':END VALIDATE');

701: RAISE Fnd_Api.G_EXC_ERROR;
702: END IF;
703:
704: IF G_DEBUG='Y' THEN
705: AHL_DEBUG_PUB.Debug( l_full_name ||':END VALIDATE');
706: END IF;
707:
708: -- Commented by amagrawa based on review comments
709: /* -- VALIDATE IF JOB IN SUBSEQUENT STAGE IS FIRMED OR RELEASED

Line 758: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);

754: X_LAST_UPDATED_BY => Fnd_Global.USER_ID,
755: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
756:
757: IF G_DEBUG='Y' THEN
758: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);
759: AHL_DEBUG_PUB.Debug( l_full_name ||': STAGE Number =' || p_x_stages_tbl(i).stage_num);
760: END IF;
761: -- Added by amagrawa after review comments.
762: ELSE -- If validate_status is <> 'S'

Line 759: AHL_DEBUG_PUB.Debug( l_full_name ||': STAGE Number =' || p_x_stages_tbl(i).stage_num);

755: X_LAST_UPDATE_LOGIN => Fnd_Global.LOGIN_ID );
756:
757: IF G_DEBUG='Y' THEN
758: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);
759: AHL_DEBUG_PUB.Debug( l_full_name ||': STAGE Number =' || p_x_stages_tbl(i).stage_num);
760: END IF;
761: -- Added by amagrawa after review comments.
762: ELSE -- If validate_status is <> 'S'
763: RAISE Fnd_Api.G_EXC_ERROR;

Line 837: AHL_DEBUG_PUB.Debug( l_full_name ||':End');

833: COMMIT;
834: END IF;
835:
836: IF G_DEBUG='Y' THEN
837: AHL_DEBUG_PUB.Debug( l_full_name ||':End');
838: END IF;
839:
840: -- Check if API is called in debug mode. If yes, disable debug.
841: IF G_DEBUG='Y' THEN

Line 842: Ahl_Debug_Pub.disable_debug;

838: END IF;
839:
840: -- Check if API is called in debug mode. If yes, disable debug.
841: IF G_DEBUG='Y' THEN
842: Ahl_Debug_Pub.disable_debug;
843: END IF;
844: EXCEPTION
845: WHEN Fnd_Api.g_exc_error THEN
846: ROLLBACK TO Update_Stages;

Line 910: Ahl_Debug_Pub.enable_debug;

906: SAVEPOINT Delete_Stages;
907:
908: -- Check if API is called in debug mode. If yes, enable debug.
909: IF G_DEBUG='Y' THEN
910: Ahl_Debug_Pub.enable_debug;
911: END IF;
912:
913: -- Debug info.
914: IF G_DEBUG='Y' THEN

Line 915: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');

911: END IF;
912:
913: -- Debug info.
914: IF G_DEBUG='Y' THEN
915: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');
916: END IF;
917:
918: -- Initialize message list if p_init_msg_list is set to TRUE.
919: IF Fnd_Api.to_boolean(p_init_msg_list)

Line 964: AHL_DEBUG_PUB.Debug( l_full_name ||':End');

960: COMMIT;
961: END IF;
962:
963: IF G_DEBUG='Y' THEN
964: AHL_DEBUG_PUB.Debug( l_full_name ||':End');
965: END IF;
966:
967: -- Check if API is called in debug mode. If yes, disable debug.
968: IF G_DEBUG='Y' THEN

Line 969: Ahl_Debug_Pub.disable_debug;

965: END IF;
966:
967: -- Check if API is called in debug mode. If yes, disable debug.
968: IF G_DEBUG='Y' THEN
969: Ahl_Debug_Pub.disable_debug;
970: END IF;
971: EXCEPTION
972: WHEN Fnd_Api.g_exc_error THEN
973: ROLLBACK TO Delete_Stages;

Line 1055: AHL_DEBUG_PUB.enable_debug;

1051:
1052: /* --------------------- initialize -----------------------
1053: -- Check if API is called in debug mode. If yes, enable debug.
1054: IF G_DEBUG='Y' THEN
1055: AHL_DEBUG_PUB.enable_debug;
1056: END IF;
1057:
1058: -- Debug info.
1059: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

Line 1059: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

1055: AHL_DEBUG_PUB.enable_debug;
1056: END IF;
1057:
1058: -- Debug info.
1059: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
1060: IF G_DEBUG='Y' THEN
1061: AHL_DEBUG_PUB.debug( l_full_name ||'********************************START******************************* ');
1062: END IF;
1063: END IF;

Line 1061: AHL_DEBUG_PUB.debug( l_full_name ||'**START* ');

1057:
1058: -- Debug info.
1059: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
1060: IF G_DEBUG='Y' THEN
1061: AHL_DEBUG_PUB.debug( l_full_name ||'********************************START******************************* ');
1062: END IF;
1063: END IF;
1064:
1065: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 1294: AHL_DEBUG_PUB.enable_debug;

1290:
1291: --------------------- initialize -----------------------
1292: -- Check if API is called in debug mode. If yes, enable debug.
1293: IF G_DEBUG='Y' THEN
1294: AHL_DEBUG_PUB.enable_debug;
1295: END IF;
1296:
1297: -- Debug info.
1298: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

Line 1298: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

1294: AHL_DEBUG_PUB.enable_debug;
1295: END IF;
1296:
1297: -- Debug info.
1298: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
1299: IF G_DEBUG='Y' THEN
1300: AHL_DEBUG_PUB.debug( l_full_name ||'********************************START******************************* ');
1301: END IF;
1302: END IF;

Line 1300: AHL_DEBUG_PUB.debug( l_full_name ||'**START* ');

1296:
1297: -- Debug info.
1298: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
1299: IF G_DEBUG='Y' THEN
1300: AHL_DEBUG_PUB.debug( l_full_name ||'********************************START******************************* ');
1301: END IF;
1302: END IF;
1303:
1304: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 1420: Ahl_Debug_Pub.debug( 'API Return Status = ' ||L_FULL_NAME||':'|| x_return_status);

1416:
1417: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1418: -- Debug info.
1419: IF G_DEBUG='Y' THEN
1420: Ahl_Debug_Pub.debug( 'API Return Status = ' ||L_FULL_NAME||':'|| x_return_status);
1421: END IF;
1422:
1423: EXCEPTION
1424: WHEN NO_DATA_FOUND THEN