DBA Data[Home] [Help]

APPS.AHL_WF_MAPPING_PVT dependencies on AHL_DEBUG_PUB

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

19: -----------------------------------------------------------
20: --
21: -- Global CONSTANTS
22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_Wf_Mapping_PVT';
23: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
24: G_VALID_NAME CONSTANT NUMBER:= 50;
25:
26: -- Check_Wf_Mapping_Req_Items
27: PROCEDURE Check_Wf_Mapping_Req_Items (

Line 93: Ahl_Debug_Pub.enable_debug;

89: --------------------- initialize -----------------------
90: SAVEPOINT Process_Wf_Mapping;
91: -- Check if API is called in debug mode. If yes, enable debug.
92: IF G_DEBUG='Y' THEN
93: Ahl_Debug_Pub.enable_debug;
94: END IF;
95: -- Debug info.
96: IF G_DEBUG='Y' THEN
97: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 97: Ahl_Debug_Pub.debug( l_full_name ||':Start');

93: Ahl_Debug_Pub.enable_debug;
94: END IF;
95: -- Debug info.
96: IF G_DEBUG='Y' THEN
97: Ahl_Debug_Pub.debug( l_full_name ||':Start');
98: END IF;
99:
100: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
101: Fnd_Msg_Pub.initialize;

Line 115: Ahl_Debug_Pub.debug( l_full_name ||':Validate');

111: x_return_status := Fnd_Api.g_ret_sts_success;
112:
113: ----------------------- validate -----------------------
114: IF G_DEBUG='Y' THEN
115: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
116: END IF;
117:
118: IF (l_x_Wf_Mapping_tbl.COUNT > 0) THEN
119: FOR i IN l_x_Wf_Mapping_tbl.FIRST..l_x_Wf_Mapping_tbl.LAST LOOP

Line 183: Ahl_Debug_Pub.debug( l_full_name ||':End');

179: p_count => x_msg_count,
180: p_data => x_msg_data
181: );
182: IF G_DEBUG='Y' THEN
183: Ahl_Debug_Pub.debug( l_full_name ||':End');
184: END IF;
185: -- Check if API is called in debug mode. If yes, disable debug.
186: IF G_DEBUG='Y' THEN
187: Ahl_Debug_Pub.disable_debug;

Line 187: Ahl_Debug_Pub.disable_debug;

183: Ahl_Debug_Pub.debug( l_full_name ||':End');
184: END IF;
185: -- Check if API is called in debug mode. If yes, disable debug.
186: IF G_DEBUG='Y' THEN
187: Ahl_Debug_Pub.disable_debug;
188: END IF;
189:
190: EXCEPTION
191: WHEN Fnd_Api.g_exc_error THEN

Line 283: Ahl_Debug_Pub.enable_debug;

279: --------------------- initialize -----------------------
280: SAVEPOINT Create_Wf_Mapping;
281: -- Check if API is called in debug mode. If yes, enable debug.
282: IF G_DEBUG='Y' THEN
283: Ahl_Debug_Pub.enable_debug;
284: END IF;
285: -- Debug info.
286: IF G_DEBUG='Y' THEN
287: Ahl_Debug_Pub.debug( l_full_name ||':Start');

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

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

Line 304: Ahl_Debug_Pub.debug( l_full_name ||':Validate');

300: END IF;
301: x_return_status := Fnd_Api.g_ret_sts_success;
302: ----------------------- validate -----------------------
303: IF G_DEBUG='Y' THEN
304: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
305: END IF;
306:
307: -- Check for default approval obeject in default workflow process
308: --

Line 410: Ahl_Debug_Pub.debug( l_full_name ||':Insert');

406: END IF;
407: */
408: -------------------------- insert --------------------------
409: IF G_DEBUG='Y' THEN
410: Ahl_Debug_Pub.debug( l_full_name ||':Insert');
411: END IF;
412:
413: -- Invoke the table handler to create a record
414: --

Line 448: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN

444: p_encoded => Fnd_Api.g_false,
445: p_count => x_msg_count,
446: p_data => x_msg_data
447: );
448: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
449: Ahl_Debug_Pub.debug( l_full_name ||':End');
450: END IF;
451: -- Check if API is called in debug mode. If yes, disable debug.
452: Ahl_Debug_Pub.disable_debug;

Line 449: Ahl_Debug_Pub.debug( l_full_name ||':End');

445: p_count => x_msg_count,
446: p_data => x_msg_data
447: );
448: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
449: Ahl_Debug_Pub.debug( l_full_name ||':End');
450: END IF;
451: -- Check if API is called in debug mode. If yes, disable debug.
452: Ahl_Debug_Pub.disable_debug;
453:

Line 452: Ahl_Debug_Pub.disable_debug;

448: IF Ahl_Debug_Pub.G_FILE_DEBUG THEN
449: Ahl_Debug_Pub.debug( l_full_name ||':End');
450: END IF;
451: -- Check if API is called in debug mode. If yes, disable debug.
452: Ahl_Debug_Pub.disable_debug;
453:
454: EXCEPTION
455: WHEN Fnd_Api.g_exc_error THEN
456: ROLLBACK TO Create_Wf_Mapping;

Line 529: Ahl_Debug_Pub.enable_debug;

525: --------------------- initialize -----------------------
526: SAVEPOINT Update_Wf_Mapping;
527: -- Check if API is called in debug mode. If yes, enable debug.
528: IF G_DEBUG='Y' THEN
529: Ahl_Debug_Pub.enable_debug;
530: END IF;
531: -- Debug info.
532: IF G_DEBUG='Y' THEN
533: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 533: Ahl_Debug_Pub.debug( l_full_name ||':Start');

529: Ahl_Debug_Pub.enable_debug;
530: END IF;
531: -- Debug info.
532: IF G_DEBUG='Y' THEN
533: Ahl_Debug_Pub.debug( l_full_name ||':Start');
534: END IF;
535: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
536: Fnd_Msg_Pub.initialize;
537: END IF;

Line 549: Ahl_Debug_Pub.debug( l_full_name ||':Validate');

545: END IF;
546: x_return_status := Fnd_Api.g_ret_sts_success;
547: ----------------------- validate ----------------------
548: IF G_DEBUG='Y' THEN
549: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
550: END IF;
551:
552: --Check for default approval obeject in default workflow process
553: --

Line 632: Ahl_Debug_Pub.debug( l_full_name ||':Update');

628: END IF;
629: */
630: -------------------------- update --------------------
631: IF G_DEBUG='Y' THEN
632: Ahl_Debug_Pub.debug( l_full_name ||':Update');
633: END IF;
634:
635: --l_process_name := UPPER(l_Wf_Mapping_rec.WF_PROCESS_NAME);
636: Ahl_Wf_Mapping_Pkg. UPDATE_ROW (

Line 659: Ahl_Debug_Pub.debug( l_full_name ||':End');

655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );
658: IF G_DEBUG='Y' THEN
659: Ahl_Debug_Pub.debug( l_full_name ||':End');
660: END IF;
661: -- Check if API is called in debug mode. If yes, disable debug.
662: IF G_DEBUG='Y' THEN
663: Ahl_Debug_Pub.disable_debug;

Line 663: Ahl_Debug_Pub.disable_debug;

659: Ahl_Debug_Pub.debug( l_full_name ||':End');
660: END IF;
661: -- Check if API is called in debug mode. If yes, disable debug.
662: IF G_DEBUG='Y' THEN
663: Ahl_Debug_Pub.disable_debug;
664: END IF;
665: EXCEPTION
666: WHEN Fnd_Api.g_exc_error THEN
667: ROLLBACK TO Update_Wf_Mapping;

Line 748: Ahl_Debug_Pub.debug('inside check_process_name LANG = '||USERENV('LANG')||

744: cur_process_name_rec cur_process_name%rowtype;
745:
746: BEGIN
747: IF G_DEBUG='Y' THEN
748: Ahl_Debug_Pub.debug('inside check_process_name LANG = '||USERENV('LANG')||
749: ' p_wf_mapping_rec.wf_display_name = '||p_wf_mapping_rec.wf_display_name||
750: ' p_wf_mapping_rec.item_type = '||p_wf_mapping_rec.item_type||
751: ' p_wf_mapping_rec.wf_process_name = '||p_wf_mapping_rec.wf_process_name);
752: END IF;

Line 880: Ahl_Debug_Pub.enable_debug;

876: --------------------- initialize -----------------------
877: SAVEPOINT Delete_wf_mapping;
878: -- Check if API is called in debug mode. If yes, enable debug.
879: IF G_DEBUG='Y' THEN
880: Ahl_Debug_Pub.enable_debug;
881: END IF;
882: -- Debug info.
883: IF G_DEBUG='Y' THEN
884: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 884: Ahl_Debug_Pub.debug( l_full_name ||':Start');

880: Ahl_Debug_Pub.enable_debug;
881: END IF;
882: -- Debug info.
883: IF G_DEBUG='Y' THEN
884: Ahl_Debug_Pub.debug( l_full_name ||':Start');
885: END IF;
886: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
887: Fnd_Msg_Pub.initialize;
888: END IF;

Line 901: Ahl_Debug_Pub.debug( l_full_name ||':Delete');

897: x_return_status := Fnd_Api.g_ret_sts_success;
898:
899: ------------------------ delete ------------------------
900: IF G_DEBUG='Y' THEN
901: Ahl_Debug_Pub.debug( l_full_name ||':Delete');
902: END IF;
903:
904: OPEN c_wf_mapping;
905: FETCH c_wf_mapping INTO l_wf_mapping_rec;

Line 938: Ahl_Debug_Pub.debug( l_full_name ||':End');

934: p_count => x_msg_count,
935: p_data => x_msg_data
936: );
937: IF G_DEBUG='Y' THEN
938: Ahl_Debug_Pub.debug( l_full_name ||':End');
939: END IF;
940: -- Check if API is called in debug mode. If yes, disable debug.
941: IF G_DEBUG='Y' THEN
942: Ahl_Debug_Pub.disable_debug;

Line 942: Ahl_Debug_Pub.disable_debug;

938: Ahl_Debug_Pub.debug( l_full_name ||':End');
939: END IF;
940: -- Check if API is called in debug mode. If yes, disable debug.
941: IF G_DEBUG='Y' THEN
942: Ahl_Debug_Pub.disable_debug;
943: END IF;
944: EXCEPTION
945: WHEN Fnd_Api.g_exc_error THEN
946: ROLLBACK TO Delete_wf_mapping;

Line 1000: Ahl_Debug_Pub.enable_debug;

996: BEGIN
997: --------------------- initialize -----------------------
998: -- Check if API is called in debug mode. If yes, enable debug.
999: IF G_DEBUG='Y' THEN
1000: Ahl_Debug_Pub.enable_debug;
1001: END IF;
1002: -- Debug info.
1003: IF G_DEBUG='Y' THEN
1004: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 1004: Ahl_Debug_Pub.debug( l_full_name ||':Start');

1000: Ahl_Debug_Pub.enable_debug;
1001: END IF;
1002: -- Debug info.
1003: IF G_DEBUG='Y' THEN
1004: Ahl_Debug_Pub.debug( l_full_name ||':Start');
1005: END IF;
1006: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1007: Fnd_Msg_Pub.initialize;
1008: END IF;

Line 1020: Ahl_Debug_Pub.debug( l_full_name ||':Check items');

1016: END IF;
1017: x_return_status := Fnd_Api.g_ret_sts_success;
1018: ---------------------- validate ------------------------
1019: IF G_DEBUG='Y' THEN
1020: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
1021: END IF;
1022:
1023: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1024: Check_Wf_Mapping_Items (

Line 1036: Ahl_Debug_Pub.debug( l_full_name ||':Check record');

1032: RAISE Fnd_Api.g_exc_error;
1033: END IF;
1034: END IF;
1035: IF G_DEBUG='Y' THEN
1036: Ahl_Debug_Pub.debug( l_full_name ||':Check record');
1037: END IF;
1038:
1039: -------------------- finish --------------------------
1040: Fnd_Msg_Pub.count_and_get (

Line 1046: Ahl_Debug_Pub.debug( l_full_name ||':End');

1042: p_count => x_msg_count,
1043: p_data => x_msg_data
1044: );
1045: IF G_DEBUG='Y' THEN
1046: Ahl_Debug_Pub.debug( l_full_name ||':End');
1047: END IF;
1048: -- Check if API is called in debug mode. If yes, disable debug.
1049: IF G_DEBUG='Y' THEN
1050: Ahl_Debug_Pub.disable_debug;

Line 1050: Ahl_Debug_Pub.disable_debug;

1046: Ahl_Debug_Pub.debug( l_full_name ||':End');
1047: END IF;
1048: -- Check if API is called in debug mode. If yes, disable debug.
1049: IF G_DEBUG='Y' THEN
1050: Ahl_Debug_Pub.disable_debug;
1051: END IF;
1052: EXCEPTION
1053: WHEN Fnd_Api.g_exc_error THEN
1054: x_return_status := Fnd_Api.g_ret_sts_error;