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: -- Common constants and variables --
29: ------------------------------------
30: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

Line 281: AHL_DEBUG_PUB.enable_debug;

277: SAVEPOINT Get_Stages_Details;
278:
279: -- Check if API is called in debug mode. If yes, enable debug.
280: IF G_DEBUG='Y' THEN
281: AHL_DEBUG_PUB.enable_debug;
282: END IF;
283:
284: -- Debug info.
285: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

Line 285: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

281: AHL_DEBUG_PUB.enable_debug;
282: END IF;
283:
284: -- Debug info.
285: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
286: IF G_DEBUG='Y' THEN
287: AHL_DEBUG_PUB.debug( l_full_name ||':*****Start*****');
288: END IF;
289: END IF;

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

283:
284: -- Debug info.
285: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
286: IF G_DEBUG='Y' THEN
287: AHL_DEBUG_PUB.debug( l_full_name ||':*****Start*****');
288: END IF;
289: END IF;
290:
291: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 424: AHL_DEBUG_PUB.enable_debug;

420: p_encoded => Fnd_Api.g_false);
421:
422: -- Check if API is called in debug mode. If yes, enable debug.
423: IF G_DEBUG='Y' THEN
424: AHL_DEBUG_PUB.enable_debug;
425: END IF;
426:
427: -- Debug info.
428: -- Commented by amagrawa as per review comments.

Line 429: -- IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

425: END IF;
426:
427: -- Debug info.
428: -- Commented by amagrawa as per review comments.
429: -- IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
430: IF G_DEBUG='Y' THEN
431: AHL_DEBUG_PUB.debug(L_FULL_NAME||'AHL_VWP_Tasks_PVT - End');
432: END IF;
433: -- END IF;

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

427: -- Debug info.
428: -- Commented by amagrawa as per review comments.
429: -- IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
430: IF G_DEBUG='Y' THEN
431: AHL_DEBUG_PUB.debug(L_FULL_NAME||'AHL_VWP_Tasks_PVT - End');
432: END IF;
433: -- END IF;
434:
435: -- Check if API is called in debug mode. If yes, disable debug.

Line 437: AHL_DEBUG_PUB.disable_debug;

433: -- END IF;
434:
435: -- Check if API is called in debug mode. If yes, disable debug.
436: IF G_DEBUG='Y' THEN
437: AHL_DEBUG_PUB.disable_debug;
438: END IF;
439: RETURN;
440:
441: EXCEPTION

Line 551: Ahl_Debug_Pub.enable_debug;

547: SAVEPOINT Create_Stage;
548:
549: -- Check if API is called in debug mode. If yes, enable debug.
550: IF G_DEBUG='Y' THEN
551: Ahl_Debug_Pub.enable_debug;
552: END IF;
553:
554: -- Debug info.
555: IF G_DEBUG='Y' THEN

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

552: END IF;
553:
554: -- Debug info.
555: IF G_DEBUG='Y' THEN
556: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');
557: END IF;
558:
559: -- Initialize message list if p_init_msg_list is set to TRUE.
560: IF Fnd_Api.to_boolean(p_init_msg_list)

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

586:
587: -------------------------------- Validate -----------------------------------------
588:
589: IF G_DEBUG='Y' THEN
590: AHL_DEBUG_PUB.Debug( l_full_name ||':START VALIDATE');
591: END IF;
592:
593: --
594: -- Check for the ID.

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

599: Fnd_Msg_Pub.ADD;
600: END IF;
601:
602: IF G_DEBUG='Y' THEN
603: AHL_DEBUG_PUB.Debug( l_full_name ||':END VALIDATE');
604: END IF;
605:
606: -- Cursor to find visit start time
607: OPEN c_visit (p_visit_id);

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

615:
616:
617: -------------------------- Insert --------------------------
618: IF G_DEBUG='Y' THEN
619: AHL_DEBUG_PUB.Debug( l_full_name ||':Insert');
620: END IF;
621:
622: IF l_is_old_visit = 'Y' THEN
623: Fnd_Message.SET_NAME('AHL','AHL_VWP_OVST_CRT_VST_INV');

Line 658: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage ID choosen =' || l_stages_tbl(i).STAGE_ID);

654:
655: END IF;
656:
657: IF G_DEBUG='Y' THEN
658: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage ID choosen =' || l_stages_tbl(i).STAGE_ID);
659: END IF;
660:
661: -- Check for the Num.
662: IF (l_stages_tbl(i).STAGE_NUM = Fnd_Api.g_miss_num OR l_stages_tbl(i).STAGE_NUM IS Null) THEN

Line 671: AHL_DEBUG_PUB.Debug( l_full_name ||':l_dummy =' || l_dummy);

667: FETCH c_stagenum_exists INTO l_dummy;
668: CLOSE c_stagenum_exists;
669:
670: IF G_DEBUG='Y' THEN
671: AHL_DEBUG_PUB.Debug( l_full_name ||':l_dummy =' || l_dummy);
672: END IF;
673:
674: -- If the value for the ID already exists, then
675: -- l_dummy would be populated with '1', otherwise, it receives NULL.

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

774: END IF;
775: END IF;
776:
777: IF G_DEBUG='Y' THEN
778: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);
779: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' || l_stages_tbl(i).Stage_Num);
780: END IF;
781: END LOOP;
782:

Line 779: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' || l_stages_tbl(i).Stage_Num);

775: END IF;
776:
777: IF G_DEBUG='Y' THEN
778: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);
779: AHL_DEBUG_PUB.Debug( l_full_name ||': Stage Number =' || l_stages_tbl(i).Stage_Num);
780: END IF;
781: END LOOP;
782:
783: IF l_isValidationFailed THEN

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

798: COMMIT;
799: END IF;
800:
801: IF G_DEBUG='Y' THEN
802: AHL_DEBUG_PUB.Debug( l_full_name ||':End');
803: END IF;
804:
805: -- Check if API is called in debug mode. If yes, disable debug.
806: IF G_DEBUG='Y' THEN

Line 807: Ahl_Debug_Pub.disable_debug;

803: END IF;
804:
805: -- Check if API is called in debug mode. If yes, disable debug.
806: IF G_DEBUG='Y' THEN
807: Ahl_Debug_Pub.disable_debug;
808: END IF;
809: EXCEPTION
810: WHEN Fnd_Api.g_exc_error THEN
811: ROLLBACK TO Create_Stage;

Line 959: Ahl_Debug_Pub.enable_debug;

955: SAVEPOINT Update_Stages;
956:
957: -- Check if API is called in debug mode. If yes, enable debug.
958: IF G_DEBUG='Y' THEN
959: Ahl_Debug_Pub.enable_debug;
960: END IF;
961:
962: -- Debug info.
963: IF G_DEBUG='Y' THEN

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

960: END IF;
961:
962: -- Debug info.
963: IF G_DEBUG='Y' THEN
964: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');
965: END IF;
966:
967: -- Initialize message list if p_init_msg_list is set to TRUE.
968: IF Fnd_Api.to_boolean(p_init_msg_list)

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

1020: END IF;
1021: */
1022: -------------------------- Update --------------------------
1023: IF G_DEBUG='Y' THEN
1024: AHL_DEBUG_PUB.Debug( l_full_name ||':Insert');
1025: END IF;
1026:
1027: --VWPE 12730539:: PRAKKUM :: 08-JUL-2011
1028: OPEN c_visit (p_visit_id);

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

1037: FOR i IN 1..l_stages_count
1038: loop
1039:
1040: IF G_DEBUG='Y' THEN
1041: AHL_DEBUG_PUB.Debug( l_full_name ||':START VALIDATE');
1042: END IF;
1043:
1044: l_is_planned_end_date_updated := false;--PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063
1045: l_is_earliest_date_updated := false;--PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063

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

1061: RAISE Fnd_Api.G_EXC_ERROR;
1062: END IF;
1063:
1064: IF G_DEBUG='Y' THEN
1065: AHL_DEBUG_PUB.Debug( l_full_name ||':END VALIDATE');
1066: END IF;
1067:
1068: -- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063 :: START
1069: OPEN C_get_stage_data(p_x_stages_tbl(i).STAGE_ID);

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

1195:
1196: -- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063 :: END
1197:
1198: IF G_DEBUG='Y' THEN
1199: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);
1200: AHL_DEBUG_PUB.Debug( l_full_name ||': STAGE Number =' || p_x_stages_tbl(i).stage_num);
1201: END IF;
1202: -- Added by amagrawa after review comments.
1203: ELSE -- If validate_status is <> 'S'

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

1196: -- PRAKKUM :: 15/03/2011 :: VWPE :: ER 12424063 :: END
1197:
1198: IF G_DEBUG='Y' THEN
1199: AHL_DEBUG_PUB.Debug( l_full_name ||': Visit ID =' || P_VISIT_ID);
1200: AHL_DEBUG_PUB.Debug( l_full_name ||': STAGE Number =' || p_x_stages_tbl(i).stage_num);
1201: END IF;
1202: -- Added by amagrawa after review comments.
1203: ELSE -- If validate_status is <> 'S'
1204: RAISE Fnd_Api.G_EXC_ERROR;

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

1303: COMMIT;
1304: END IF;
1305:
1306: IF G_DEBUG='Y' THEN
1307: AHL_DEBUG_PUB.Debug( l_full_name ||':End');
1308: END IF;
1309:
1310: -- Check if API is called in debug mode. If yes, disable debug.
1311: IF G_DEBUG='Y' THEN

Line 1312: Ahl_Debug_Pub.disable_debug;

1308: END IF;
1309:
1310: -- Check if API is called in debug mode. If yes, disable debug.
1311: IF G_DEBUG='Y' THEN
1312: Ahl_Debug_Pub.disable_debug;
1313: END IF;
1314: EXCEPTION
1315: WHEN Fnd_Api.g_exc_error THEN
1316: ROLLBACK TO Update_Stages;

Line 1700: Ahl_Debug_Pub.enable_debug;

1696: SAVEPOINT Delete_All_Stages;
1697:
1698: -- Check if API is called in debug mode. If yes, enable debug.
1699: IF G_DEBUG='Y' THEN
1700: Ahl_Debug_Pub.enable_debug;
1701: END IF;
1702:
1703: -- Debug info.
1704: IF G_DEBUG='Y' THEN

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

1701: END IF;
1702:
1703: -- Debug info.
1704: IF G_DEBUG='Y' THEN
1705: AHL_DEBUG_PUB.Debug( l_full_name ||': Start');
1706: END IF;
1707:
1708: --Initialize API return status to success
1709: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

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

1765: COMMIT;
1766: END IF;
1767:
1768: IF G_DEBUG='Y' THEN
1769: AHL_DEBUG_PUB.Debug( l_full_name ||':End');
1770: END IF;
1771:
1772: -- Check if API is called in debug mode. If yes, disable debug.
1773: IF G_DEBUG='Y' THEN

Line 1774: Ahl_Debug_Pub.disable_debug;

1770: END IF;
1771:
1772: -- Check if API is called in debug mode. If yes, disable debug.
1773: IF G_DEBUG='Y' THEN
1774: Ahl_Debug_Pub.disable_debug;
1775: END IF;
1776: EXCEPTION
1777: WHEN Fnd_Api.g_exc_error THEN
1778: ROLLBACK TO Delete_All_Stages;

Line 1860: AHL_DEBUG_PUB.enable_debug;

1856:
1857: /* --------------------- initialize -----------------------
1858: -- Check if API is called in debug mode. If yes, enable debug.
1859: IF G_DEBUG='Y' THEN
1860: AHL_DEBUG_PUB.enable_debug;
1861: END IF;
1862:
1863: -- Debug info.
1864: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

Line 1864: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

1860: AHL_DEBUG_PUB.enable_debug;
1861: END IF;
1862:
1863: -- Debug info.
1864: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
1865: IF G_DEBUG='Y' THEN
1866: AHL_DEBUG_PUB.debug( l_full_name ||'********************************START******************************* ');
1867: END IF;
1868: END IF;

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

1862:
1863: -- Debug info.
1864: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
1865: IF G_DEBUG='Y' THEN
1866: AHL_DEBUG_PUB.debug( l_full_name ||'********************************START******************************* ');
1867: END IF;
1868: END IF;
1869:
1870: IF Fnd_Api.to_boolean (p_init_msg_list) THEN

Line 2122: AHL_DEBUG_PUB.enable_debug;

2118:
2119: --------------------- initialize -----------------------
2120: -- Check if API is called in debug mode. If yes, enable debug.
2121: IF G_DEBUG='Y' THEN
2122: AHL_DEBUG_PUB.enable_debug;
2123: END IF;
2124:
2125: -- Debug info.
2126: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

Line 2126: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

2122: AHL_DEBUG_PUB.enable_debug;
2123: END IF;
2124:
2125: -- Debug info.
2126: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
2127: IF G_DEBUG='Y' THEN
2128: AHL_DEBUG_PUB.debug( l_full_name ||'********************************START******************************* ');
2129: END IF;
2130: END IF;

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

2124:
2125: -- Debug info.
2126: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
2127: IF G_DEBUG='Y' THEN
2128: AHL_DEBUG_PUB.debug( l_full_name ||'********************************START******************************* ');
2129: END IF;
2130: END IF;
2131:
2132: -- Initialize message list if p_init_msg_list is set to TRUE.

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

2300:
2301: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2302: -- Debug info.
2303: IF G_DEBUG='Y' THEN
2304: Ahl_Debug_Pub.debug( 'API Return Status = ' ||L_FULL_NAME||':'|| x_return_status);
2305: END IF;
2306:
2307: EXCEPTION
2308: WHEN NO_DATA_FOUND THEN