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_LTP_SPACE_SCHEDULE_PVT dependencies on AHL_DEBUG_PUB

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

1: PACKAGE BODY AHL_LTP_SPACE_SCHEDULE_PVT AS
2: /* $Header: AHLVSPSB.pls 120.2 2006/05/25 09:51:23 anraj noship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_SPACE_SCHEDULE_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: --
8: -- PACKAGE
9: -- AHL_LTP_SPACE_SCHEDULE_PVT

Line 36: Ahl_Debug_Pub.debug( 'Inside open for cursor');

32: IS
33: BEGIN
34: --
35: IF G_DEBUG='Y' THEN
36: Ahl_Debug_Pub.debug( 'Inside open for cursor');
37: END IF;
38:
39: IF p_search_query_tbl.COUNT = 0 THEN
40: OPEN p_x_ref_csr FOR p_sql_str;

Line 82: Ahl_Debug_Pub.debug( 'End of open for cursor');

78: null;
79: END IF;
80: --
81: IF G_DEBUG='Y' THEN
82: Ahl_Debug_Pub.debug( 'End of open for cursor');
83: END IF;
84: --
85: END OPEN_FOR_CURSOR;
86: -- To get number of visits for Days

Line 179: Ahl_Debug_Pub.debug( 'afetr simul:'||l_count);

175:
176: ELSE
177: --
178: IF G_DEBUG='Y' THEN
179: Ahl_Debug_Pub.debug( 'afetr simul:'||l_count);
180: END IF;
181: -- simulation visits
182: OPEN number_of_prim_visits_cur(p_plan_id, p_space_id,l_visit_id,l_start_date,
183: TRUNC(NVL(l_visit_end_date,l_visit_start_date)));

Line 194: Ahl_Debug_Pub.debug( 'INSIDE COUNT 3:'||l_count);

190: FETCH number_of_sim_visits_cur INTO l_count;
191: CLOSE number_of_sim_visits_cur;
192:
193: IF G_DEBUG='Y' THEN
194: Ahl_Debug_Pub.debug( 'INSIDE COUNT 3:'||l_count);
195: END IF;
196: --
197: END IF;
198: l_ctr:=l_ctr+l_count+l_dummy;

Line 299: Ahl_Debug_Pub.debug( 'after plan flag visit id :'||l_visit_id);

295:
296: IF p_plan_flag = 'Y' THEN
297: --
298: IF G_DEBUG='Y' THEN
299: Ahl_Debug_Pub.debug( 'after plan flag visit id :'||l_visit_id);
300: Ahl_Debug_Pub.debug( 'after plan flag start date:'||l_start_date);
301: Ahl_Debug_Pub.debug( 'after plan flag visit start date:'||l_visit_start_date);
302: Ahl_Debug_Pub.debug( 'after plan flag visit end date:'||l_visit_end_date);
303: END IF;

Line 300: Ahl_Debug_Pub.debug( 'after plan flag start date:'||l_start_date);

296: IF p_plan_flag = 'Y' THEN
297: --
298: IF G_DEBUG='Y' THEN
299: Ahl_Debug_Pub.debug( 'after plan flag visit id :'||l_visit_id);
300: Ahl_Debug_Pub.debug( 'after plan flag start date:'||l_start_date);
301: Ahl_Debug_Pub.debug( 'after plan flag visit start date:'||l_visit_start_date);
302: Ahl_Debug_Pub.debug( 'after plan flag visit end date:'||l_visit_end_date);
303: END IF;
304: --

Line 301: Ahl_Debug_Pub.debug( 'after plan flag visit start date:'||l_visit_start_date);

297: --
298: IF G_DEBUG='Y' THEN
299: Ahl_Debug_Pub.debug( 'after plan flag visit id :'||l_visit_id);
300: Ahl_Debug_Pub.debug( 'after plan flag start date:'||l_start_date);
301: Ahl_Debug_Pub.debug( 'after plan flag visit start date:'||l_visit_start_date);
302: Ahl_Debug_Pub.debug( 'after plan flag visit end date:'||l_visit_end_date);
303: END IF;
304: --
305: OPEN number_of_prim_visits_cur(p_plan_id, l_visit_id,l_start_date,

Line 302: Ahl_Debug_Pub.debug( 'after plan flag visit end date:'||l_visit_end_date);

298: IF G_DEBUG='Y' THEN
299: Ahl_Debug_Pub.debug( 'after plan flag visit id :'||l_visit_id);
300: Ahl_Debug_Pub.debug( 'after plan flag start date:'||l_start_date);
301: Ahl_Debug_Pub.debug( 'after plan flag visit start date:'||l_visit_start_date);
302: Ahl_Debug_Pub.debug( 'after plan flag visit end date:'||l_visit_end_date);
303: END IF;
304: --
305: OPEN number_of_prim_visits_cur(p_plan_id, l_visit_id,l_start_date,
306: TRUNC(NVL(l_visit_end_date,l_visit_start_date)),p_department_id);

Line 309: Ahl_Debug_Pub.debug( 'after primary :'||l_count);

305: OPEN number_of_prim_visits_cur(p_plan_id, l_visit_id,l_start_date,
306: TRUNC(NVL(l_visit_end_date,l_visit_start_date)),p_department_id);
307: FETCH number_of_prim_visits_cur INTO l_count;
308: CLOSE number_of_prim_visits_cur;
309: Ahl_Debug_Pub.debug( 'after primary :'||l_count);
310: ELSE
311: --
312: IF G_DEBUG='Y' THEN
313: Ahl_Debug_Pub.debug( 'afetr simul:'||l_visit_id);

Line 313: Ahl_Debug_Pub.debug( 'afetr simul:'||l_visit_id);

309: Ahl_Debug_Pub.debug( 'after primary :'||l_count);
310: ELSE
311: --
312: IF G_DEBUG='Y' THEN
313: Ahl_Debug_Pub.debug( 'afetr simul:'||l_visit_id);
314: END IF;
315: -- simulation visits
316: OPEN number_of_prim_visits_cur(p_plan_id, l_visit_id,l_start_date,
317: TRUNC(NVL(l_visit_end_date,l_visit_start_date)),p_department_id);

Line 327: Ahl_Debug_Pub.debug( 'INSIDE COUNT 3:'||l_count);

323: FETCH number_of_sim_visits_cur INTO l_count;
324: CLOSE number_of_sim_visits_cur;
325:
326: IF G_DEBUG='Y' THEN
327: Ahl_Debug_Pub.debug( 'INSIDE COUNT 3:'||l_count);
328: END IF;
329: --
330: END IF;
331: l_ctr:=l_ctr+l_count+l_dummy;

Line 336: Ahl_Debug_Pub.debug( 'l_ctr:'||l_ctr);

332: END LOOP;
333: CLOSE get_visit_cur;
334:
335: IF G_DEBUG='Y' THEN
336: Ahl_Debug_Pub.debug( 'l_ctr:'||l_ctr);
337: END IF;
338: RETURN l_ctr;
339: END Get_assigned_dept_Visits;
340: --

Line 417: Ahl_Debug_Pub.debug( 'plan id:'||p_plan_id);

413: FETCH get_visit_cur INTO l_visit_id,l_visit_start_date,l_visit_close_date;
414: EXIT WHEN get_visit_cur%NOTFOUND;
415: --
416: IF G_DEBUG='Y' THEN
417: Ahl_Debug_Pub.debug( 'plan id:'||p_plan_id);
418: Ahl_Debug_Pub.debug( 'visit id:'||l_visit_id);
419: END IF;
420: --Assign when close date time exists
421: IF l_visit_close_date IS NOT NULL THEN

Line 418: Ahl_Debug_Pub.debug( 'visit id:'||l_visit_id);

414: EXIT WHEN get_visit_cur%NOTFOUND;
415: --
416: IF G_DEBUG='Y' THEN
417: Ahl_Debug_Pub.debug( 'plan id:'||p_plan_id);
418: Ahl_Debug_Pub.debug( 'visit id:'||l_visit_id);
419: END IF;
420: --Assign when close date time exists
421: IF l_visit_close_date IS NOT NULL THEN
422: l_visit_end_date := l_visit_close_date;

Line 435: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_prim_visits_cur%ROWCOUNT);

431: TRUNC(NVL(l_visit_end_date,l_visit_start_date)),
432: p_plan_id);
433: FETCH number_of_prim_visits_cur INTO l_count;
434: IF G_DEBUG='Y' THEN
435: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_prim_visits_cur%ROWCOUNT);
436: END IF;
437: CLOSE number_of_prim_visits_cur;
438: --
439: ELSE

Line 448: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_sim_visits_cur%ROWCOUNT);

444: TRUNC(NVL(l_visit_end_date,l_visit_start_date)),
445: p_plan_id);
446: FETCH number_of_sim_visits_cur INTO l_count;
447: IF G_DEBUG='Y' THEN
448: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_sim_visits_cur%ROWCOUNT);
449: END IF;
450: --
451: CLOSE number_of_sim_visits_cur;
452: -- Primary visits

Line 461: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_prim_visits_cur%ROWCOUNT);

457: p_plan_id);
458: FETCH number_of_prim_visits_cur INTO l_dummy;
459: --
460: IF G_DEBUG='Y' THEN
461: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_prim_visits_cur%ROWCOUNT);
462: END IF;
463: CLOSE number_of_prim_visits_cur;
464: END IF;
465: l_ctr:=l_ctr+l_count+l_dummy;

Line 560: Ahl_Debug_Pub.debug( 'plan id:'||p_plan_id);

556: FETCH get_visit_cur INTO l_visit_id,l_visit_start_date,l_visit_close_date;
557: EXIT WHEN get_visit_cur%NOTFOUND;
558: --
559: IF G_DEBUG='Y' THEN
560: Ahl_Debug_Pub.debug( 'plan id:'||p_plan_id);
561: Ahl_Debug_Pub.debug( 'visit id:'||l_visit_id);
562: END IF;
563: --Assign when close date time exists
564: IF l_visit_close_date IS NOT NULL THEN

Line 561: Ahl_Debug_Pub.debug( 'visit id:'||l_visit_id);

557: EXIT WHEN get_visit_cur%NOTFOUND;
558: --
559: IF G_DEBUG='Y' THEN
560: Ahl_Debug_Pub.debug( 'plan id:'||p_plan_id);
561: Ahl_Debug_Pub.debug( 'visit id:'||l_visit_id);
562: END IF;
563: --Assign when close date time exists
564: IF l_visit_close_date IS NOT NULL THEN
565: l_visit_end_date := l_visit_close_date;

Line 581: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_prim_visits_cur%ROWCOUNT);

577: p_plan_id);
578: FETCH number_of_prim_visits_cur INTO l_count;
579: IF G_DEBUG='Y' THEN
580: --
581: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_prim_visits_cur%ROWCOUNT);
582: --
583: END IF;
584: CLOSE number_of_prim_visits_cur;
585: --

Line 597: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_sim_visits_cur%ROWCOUNT);

593: p_plan_id);
594: FETCH number_of_sim_visits_cur INTO l_count;
595: IF G_DEBUG='Y' THEN
596: --
597: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_sim_visits_cur%ROWCOUNT);
598: END IF;
599: --
600: CLOSE number_of_sim_visits_cur;
601: -- Primary visits

Line 612: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_prim_visits_cur%ROWCOUNT);

608: FETCH number_of_prim_visits_cur INTO l_dummy;
609: --
610: IF G_DEBUG='Y' THEN
611: --
612: Ahl_Debug_Pub.debug( 'ROWCOUNT 2:'||number_of_prim_visits_cur%ROWCOUNT);
613: END IF;
614: --
615: CLOSE number_of_prim_visits_cur;
616: --

Line 833: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);

829: END IF;
830:
831:
832: --
833: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
834: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
835: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
836: --Space info
837:

Line 834: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);

830:
831:
832: --
833: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
834: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
835: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
836: --Space info
837:
838: --SELECT Clause

Line 835: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);

831:
832: --
833: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
834: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
835: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
836: --Space info
837:
838: --SELECT Clause
839: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';

Line 886: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);

882:
883:
884:
885: --
886: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);
887: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
888: AHL_DEBUG_PUB.debug( 'p_space_category:'||p_space_category);
889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
890: -- Department details

Line 887: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);

883:
884:
885: --
886: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);
887: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
888: AHL_DEBUG_PUB.debug( 'p_space_category:'||p_space_category);
889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
890: -- Department details
891: OPEN_FOR_CURSOR(p_x_ref_csr => l_dept_cur,

Line 888: AHL_DEBUG_PUB.debug( 'p_space_category:'||p_space_category);

884:
885: --
886: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);
887: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
888: AHL_DEBUG_PUB.debug( 'p_space_category:'||p_space_category);
889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
890: -- Department details
891: OPEN_FOR_CURSOR(p_x_ref_csr => l_dept_cur,
892: p_search_query_tbl => l_tempbind_tbl,

Line 889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);

885: --
886: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);
887: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
888: AHL_DEBUG_PUB.debug( 'p_space_category:'||p_space_category);
889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
890: -- Department details
891: OPEN_FOR_CURSOR(p_x_ref_csr => l_dept_cur,
892: p_search_query_tbl => l_tempbind_tbl,
893: p_sql_str => l_sql_string);

Line 911: AHL_DEBUG_PUB.debug( 'l_count:'||l_count);

907: p_plan_flag,
908: l_department_id,
909: l_start_date);
910:
911: AHL_DEBUG_PUB.debug( 'l_count:'||l_count);
912:
913: IF l_count = 1 THEN
914: x_scheduled_visits_tbl(l_idx).value_1 := 'S';
915: ELSIF l_count > 1 THEN

Line 925: AHL_DEBUG_PUB.debug( 'space ID:'||x_scheduled_visits_tbl(l_idx).space_id);

921: x_display_rec.start_period_1 := l_start_date;
922: x_display_rec.end_period_1 := l_start_date;
923: END IF;
924: IF G_DEBUG='Y' THEN
925: AHL_DEBUG_PUB.debug( 'space ID:'||x_scheduled_visits_tbl(l_idx).space_id);
926: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);
927: --
928: END IF;
929: --

Line 926: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);

922: x_display_rec.end_period_1 := l_start_date;
923: END IF;
924: IF G_DEBUG='Y' THEN
925: AHL_DEBUG_PUB.debug( 'space ID:'||x_scheduled_visits_tbl(l_idx).space_id);
926: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);
927: --
928: END IF;
929: --
930: IF l_start_date+1 IS NOT NULL THEN

Line 933: AHL_DEBUG_PUB.debug( 'before count 2:'||l_count);

929: --
930: IF l_start_date+1 IS NOT NULL THEN
931: --Initialize count value
932: l_count := 0;
933: AHL_DEBUG_PUB.debug( 'before count 2:'||l_count);
934: --
935: l_count := Get_assigned_dept_Visits(p_simulation_plan_id,
936: p_plan_flag,
937: l_department_id,

Line 942: AHL_DEBUG_PUB.debug( 'count 2:'||l_count);

938: l_start_date+1);
939:
940: IF G_DEBUG='Y' THEN
941: --
942: AHL_DEBUG_PUB.debug( 'count 2:'||l_count);
943: --
944: END IF;
945: IF l_count = 1 THEN
946: x_scheduled_visits_tbl(l_idx).value_2 := 'S';

Line 967: AHL_DEBUG_PUB.debug( 'count 3:'||l_count);

963: l_department_id,
964: l_start_date+2);
965:
966: IF G_DEBUG='Y' THEN
967: AHL_DEBUG_PUB.debug( 'count 3:'||l_count);
968: END IF;
969:
970: IF l_count = 1 THEN
971: x_scheduled_visits_tbl(l_idx).value_3 := 'S';

Line 983: AHL_DEBUG_PUB.debug( 'value 3:'||x_scheduled_visits_tbl(l_idx).value_3);

979: x_display_rec.end_period_3 := l_start_date + 2;
980: END IF;
981: --
982: IF G_DEBUG='Y' THEN
983: AHL_DEBUG_PUB.debug( 'value 3:'||x_scheduled_visits_tbl(l_idx).value_3);
984: END IF;
985: --
986: IF l_start_date+3 IS NOT NULL THEN
987: --Initialize count value

Line 989: AHL_DEBUG_PUB.debug( 'before count 4:'||l_count);

985: --
986: IF l_start_date+3 IS NOT NULL THEN
987: --Initialize count value
988: l_count := 0;
989: AHL_DEBUG_PUB.debug( 'before count 4:'||l_count);
990: --
991: l_count := Get_assigned_dept_Visits(p_simulation_plan_id,
992: p_plan_flag,
993: l_department_id,

Line 998: AHL_DEBUG_PUB.debug( 'count 4:'||l_count);

994: l_start_date+3);
995:
996:
997: IF G_DEBUG='Y' THEN
998: AHL_DEBUG_PUB.debug( 'count 4:'||l_count);
999: END IF;
1000:
1001: IF l_count = 1 THEN
1002: x_scheduled_visits_tbl(l_idx).value_4 := 'S';

Line 1014: AHL_DEBUG_PUB.debug( 'value 4:'||x_scheduled_visits_tbl(l_idx).value_4);

1010: x_display_rec.end_period_4 := l_start_date + 3;
1011: END IF;
1012: --
1013: IF G_DEBUG='Y' THEN
1014: AHL_DEBUG_PUB.debug( 'value 4:'||x_scheduled_visits_tbl(l_idx).value_4);
1015: END IF;
1016: --
1017: IF l_start_date+4 IS NOT NULL THEN
1018: --Initialize count value

Line 1028: AHL_DEBUG_PUB.debug( 'count 5:'||l_count);

1024: l_department_id,
1025: l_start_date+4);
1026:
1027: IF G_DEBUG='Y' THEN
1028: AHL_DEBUG_PUB.debug( 'count 5:'||l_count);
1029: END IF;
1030:
1031: IF l_count = 1 THEN
1032: x_scheduled_visits_tbl(l_idx).value_5 := 'S';

Line 1044: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);

1040: x_display_rec.end_period_5 := l_start_date + 4;
1041: END IF;
1042: --
1043: IF G_DEBUG='Y' THEN
1044: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);
1045: END IF;
1046: --
1047: IF l_start_date+5 IS NOT NULL THEN
1048: --Initialize count value

Line 1057: AHL_DEBUG_PUB.debug( 'count 6:'||l_count);

1053: l_department_id,
1054: l_start_date+5);
1055:
1056: IF G_DEBUG='Y' THEN
1057: AHL_DEBUG_PUB.debug( 'count 6:'||l_count);
1058: END IF;
1059:
1060: IF l_count = 1 THEN
1061: x_scheduled_visits_tbl(l_idx).value_6 := 'S';

Line 1073: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);

1069: x_display_rec.end_period_6 := l_start_date + 5;
1070: END IF;
1071: --
1072: IF G_DEBUG='Y' THEN
1073: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);
1074: END IF;
1075: --
1076: IF l_start_date+6 IS NOT NULL THEN
1077: --Initialize count value

Line 1086: AHL_DEBUG_PUB.debug( 'count 7:'||l_count);

1082: l_department_id,
1083: l_start_date+6);
1084:
1085: IF G_DEBUG='Y' THEN
1086: AHL_DEBUG_PUB.debug( 'count 7:'||l_count);
1087: END IF;
1088:
1089: IF l_count = 1 THEN
1090: x_scheduled_visits_tbl(l_idx).value_7 := 'S';

Line 1102: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);

1098: x_display_rec.end_period_7 := l_start_date + 6;
1099: END IF;
1100: --
1101: IF G_DEBUG='Y' THEN
1102: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);
1103: END IF;
1104: --
1105: IF l_start_date+7 IS NOT NULL THEN
1106: --Initialize count value

Line 1115: AHL_DEBUG_PUB.debug( 'count 8:'||l_count);

1111: l_department_id,
1112: l_start_date+7);
1113:
1114: IF G_DEBUG='Y' THEN
1115: AHL_DEBUG_PUB.debug( 'count 8:'||l_count);
1116: END IF;
1117:
1118: IF l_count = 1 THEN
1119: x_scheduled_visits_tbl(l_idx).value_8 := 'S';

Line 1131: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);

1127: x_display_rec.end_period_8 := l_start_date + 7;
1128: END IF;
1129: --
1130: IF G_DEBUG='Y' THEN
1131: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);
1132: END IF;
1133: --
1134: IF l_start_date+8 IS NOT NULL THEN
1135: --Initialize count value

Line 1145: AHL_DEBUG_PUB.debug( 'count 9:'||l_count);

1141: l_start_date+8);
1142:
1143:
1144: IF G_DEBUG='Y' THEN
1145: AHL_DEBUG_PUB.debug( 'count 9:'||l_count);
1146: END IF;
1147:
1148: IF l_count = 1 THEN
1149: x_scheduled_visits_tbl(l_idx).value_9 := 'S';

Line 1161: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);

1157: x_display_rec.end_period_9 := l_start_date + 8;
1158: END IF;
1159: --
1160: IF G_DEBUG='Y' THEN
1161: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);
1162: END IF;
1163: --
1164: IF l_start_date+9 IS NOT NULL THEN
1165: --Initialize count value

Line 1174: AHL_DEBUG_PUB.debug( 'count 10:'||l_count);

1170: l_department_id,
1171: l_start_date+9);
1172:
1173: IF G_DEBUG='Y' THEN
1174: AHL_DEBUG_PUB.debug( 'count 10:'||l_count);
1175: END IF;
1176:
1177: IF l_count = 1 THEN
1178: x_scheduled_visits_tbl(l_idx).value_10 := 'S';

Line 1190: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);

1186: x_display_rec.end_period_10 := l_start_date + 9;
1187: END IF;
1188: --
1189: IF G_DEBUG='Y' THEN
1190: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);
1191: END IF;
1192: --
1193: IF l_start_date+10 IS NOT NULL THEN
1194: --Initialize count value

Line 1203: AHL_DEBUG_PUB.debug( 'count 11:'||l_count);

1199: l_department_id,
1200: l_start_date+10);
1201:
1202: IF G_DEBUG='Y' THEN
1203: AHL_DEBUG_PUB.debug( 'count 11:'||l_count);
1204: END IF;
1205:
1206: IF l_count = 1 THEN
1207: x_scheduled_visits_tbl(l_idx).value_11 := 'S';

Line 1219: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);

1215: x_display_rec.end_period_11 := l_start_date + 10;
1216: END IF;
1217: --
1218: IF G_DEBUG='Y' THEN
1219: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);
1220: END IF;
1221: --
1222: IF l_start_date+11 IS NOT NULL THEN
1223: --Initialize count value

Line 1232: AHL_DEBUG_PUB.debug( 'count 12:'||l_count);

1228: l_department_id,
1229: l_start_date+11);
1230:
1231: IF G_DEBUG='Y' THEN
1232: AHL_DEBUG_PUB.debug( 'count 12:'||l_count);
1233: END IF;
1234:
1235: IF l_count = 1 THEN
1236: x_scheduled_visits_tbl(l_idx).value_12 := 'S';

Line 1248: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);

1244: x_display_rec.end_period_12 := l_start_date + 11;
1245: END IF;
1246: --
1247: IF G_DEBUG='Y' THEN
1248: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);
1249: END IF;
1250: --
1251: IF l_start_date+12 IS NOT NULL THEN
1252: --Initialize count value

Line 1261: AHL_DEBUG_PUB.debug( 'count 13:'||l_count);

1257: l_department_id,
1258: l_start_date+12);
1259:
1260: IF G_DEBUG='Y' THEN
1261: AHL_DEBUG_PUB.debug( 'count 13:'||l_count);
1262: END IF;
1263:
1264: IF l_count = 1 THEN
1265: x_scheduled_visits_tbl(l_idx).value_13 := 'S';

Line 1277: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);

1273: x_display_rec.end_period_13 := l_start_date + 12;
1274: END IF;
1275: --
1276: IF G_DEBUG='Y' THEN
1277: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);
1278: END IF;
1279: --
1280: IF l_start_date+13 IS NOT NULL THEN
1281: --Initialize count value

Line 1291: AHL_DEBUG_PUB.debug( 'count 14:'||l_count);

1287: l_department_id,
1288: l_start_date+13);
1289:
1290: IF G_DEBUG='Y' THEN
1291: AHL_DEBUG_PUB.debug( 'count 14:'||l_count);
1292: END IF;
1293:
1294: IF l_count = 1 THEN
1295: x_scheduled_visits_tbl(l_idx).value_14 := 'S';

Line 1307: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);

1303: x_display_rec.end_period_14 := l_start_date + 13;
1304: END IF;
1305: --
1306: IF G_DEBUG='Y' THEN
1307: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);
1308: END IF;
1309: x_scheduled_visits_tbl(l_idx).space_id := null;
1310: x_scheduled_visits_tbl(l_idx).space_name := null;
1311: x_scheduled_visits_tbl(l_idx).department_code := l_dept_code;

Line 1365: AHL_DEBUG_PUB.debug( 'space ID:'||x_scheduled_visits_tbl(l_idx).space_id);

1361: x_display_rec.end_period_1 := l_start_date;
1362: END IF;
1363: IF G_DEBUG='Y' THEN
1364: --
1365: AHL_DEBUG_PUB.debug( 'space ID:'||x_scheduled_visits_tbl(l_idx).space_id);
1366: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);
1367: --
1368: END IF;
1369: --

Line 1366: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);

1362: END IF;
1363: IF G_DEBUG='Y' THEN
1364: --
1365: AHL_DEBUG_PUB.debug( 'space ID:'||x_scheduled_visits_tbl(l_idx).space_id);
1366: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);
1367: --
1368: END IF;
1369: --
1370: IF l_start_date+1 IS NOT NULL THEN

Line 1376: AHL_DEBUG_PUB.debug( 'count 2:'||l_count);

1372: l_count := Get_number_of_Visits(p_simulation_plan_id,
1373: p_plan_flag,l_space_id,l_start_date+1);
1374: IF G_DEBUG='Y' THEN
1375: --
1376: AHL_DEBUG_PUB.debug( 'count 2:'||l_count);
1377: --
1378: END IF;
1379: IF l_count = 1 THEN
1380: x_scheduled_visits_tbl(l_idx).value_2 := 'S';

Line 1400: AHL_DEBUG_PUB.debug( 'value 2:'||x_scheduled_visits_tbl(l_idx).value_2);

1396: END IF;
1397: --
1398: IF G_DEBUG='Y' THEN
1399: --
1400: AHL_DEBUG_PUB.debug( 'value 2:'||x_scheduled_visits_tbl(l_idx).value_2);
1401: --
1402: END IF;
1403: --
1404: IF l_start_date+2 IS NOT NULL THEN

Line 1430: AHL_DEBUG_PUB.debug( 'value 3:'||x_scheduled_visits_tbl(l_idx).value_3);

1426: x_display_rec.end_period_3 := l_start_date + 2;
1427: END IF;
1428: --
1429: IF G_DEBUG='Y' THEN
1430: AHL_DEBUG_PUB.debug( 'value 3:'||x_scheduled_visits_tbl(l_idx).value_3);
1431: END IF;
1432: --
1433: IF l_start_date+3 IS NOT NULL THEN
1434: --

Line 1459: AHL_DEBUG_PUB.debug( 'value 4:'||x_scheduled_visits_tbl(l_idx).value_4);

1455: x_display_rec.end_period_4 := l_start_date + 3;
1456: END IF;
1457: --
1458: IF G_DEBUG='Y' THEN
1459: AHL_DEBUG_PUB.debug( 'value 4:'||x_scheduled_visits_tbl(l_idx).value_4);
1460: END IF;
1461: --
1462: IF l_start_date+4 IS NOT NULL THEN
1463: --

Line 1487: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);

1483: x_display_rec.end_period_5 := l_start_date + 4;
1484: END IF;
1485: --
1486: IF G_DEBUG='Y' THEN
1487: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);
1488: END IF;
1489: --
1490: IF l_start_date+5 IS NOT NULL THEN
1491: --

Line 1516: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);

1512: x_display_rec.end_period_6 := l_start_date + 5;
1513: END IF;
1514: --
1515: IF G_DEBUG='Y' THEN
1516: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);
1517: END IF;
1518: --
1519: IF l_start_date+6 IS NOT NULL THEN
1520: --

Line 1545: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);

1541: END IF;
1542: --
1543: IF G_DEBUG='Y' THEN
1544: --
1545: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);
1546: --
1547: END IF;
1548: --
1549: IF l_start_date+7 IS NOT NULL THEN

Line 1574: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);

1570: x_display_rec.end_period_8 := l_start_date + 7;
1571: END IF;
1572: --
1573: IF G_DEBUG='Y' THEN
1574: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);
1575: END IF;
1576: --
1577: IF l_start_date+8 IS NOT NULL THEN
1578: --

Line 1603: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);

1599: x_display_rec.end_period_9 := l_start_date + 8;
1600: END IF;
1601: --
1602: IF G_DEBUG='Y' THEN
1603: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);
1604: END IF;
1605: --
1606: IF l_start_date+9 IS NOT NULL THEN
1607: --

Line 1631: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);

1627: x_display_rec.end_period_10 := l_start_date + 9;
1628: END IF;
1629: --
1630: IF G_DEBUG='Y' THEN
1631: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);
1632: END IF;
1633: --
1634: IF l_start_date+10 IS NOT NULL THEN
1635: --

Line 1659: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);

1655: x_display_rec.end_period_11 := l_start_date + 10;
1656: END IF;
1657: --
1658: IF G_DEBUG='Y' THEN
1659: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);
1660: END IF;
1661: --
1662: IF l_start_date+11 IS NOT NULL THEN
1663: --

Line 1687: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);

1683: x_display_rec.end_period_12 := l_start_date + 11;
1684: END IF;
1685: --
1686: IF G_DEBUG='Y' THEN
1687: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);
1688: END IF;
1689: --
1690: IF l_start_date+12 IS NOT NULL THEN
1691: --

Line 1715: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);

1711: x_display_rec.end_period_13 := l_start_date + 12;
1712: END IF;
1713: --
1714: IF G_DEBUG='Y' THEN
1715: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);
1716: END IF;
1717: --
1718: IF l_start_date+13 IS NOT NULL THEN
1719: --

Line 1743: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);

1739: x_display_rec.end_period_14 := l_start_date + 13;
1740: END IF;
1741: --
1742: IF G_DEBUG='Y' THEN
1743: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);
1744: END IF;
1745: --
1746: x_scheduled_visits_tbl(l_idx).space_id := l_space_id;
1747: x_scheduled_visits_tbl(l_idx).space_name := l_space_name;

Line 1887: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);

1883: END IF; -- category code null
1884:
1885:
1886: --
1887: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
1888: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
1889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
1890: --Space info
1891:

Line 1888: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);

1884:
1885:
1886: --
1887: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
1888: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
1889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
1890: --Space info
1891:
1892: --SELECT Clause

Line 1889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);

1885:
1886: --
1887: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
1888: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
1889: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
1890: --Space info
1891:
1892: --SELECT Clause
1893: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';

Line 1940: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);

1936: l_bind_index := l_bind_index + 1;
1937:
1938: END IF;
1939:
1940: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);
1941:
1942: -- Department details
1943: OPEN_FOR_CURSOR(p_x_ref_csr => l_dept_cur,
1944: p_search_query_tbl => l_tempbind_tbl,

Line 1964: AHL_DEBUG_PUB.debug( 'count W1:'||l_count);

1960: p_plan_flag,
1961: x_display_rec.start_period_1,
1962: x_display_rec.end_period_1);
1963: IF G_DEBUG='Y' THEN
1964: AHL_DEBUG_PUB.debug( 'count W1:'||l_count);
1965: END IF;
1966: IF l_count = 1 THEN
1967: x_scheduled_visits_tbl(l_idx).value_1 := 'S';
1968: ELSIF l_count > 1 THEN

Line 1979: AHL_DEBUG_PUB.debug( 'SPACE ID:'||x_scheduled_visits_tbl(l_idx).space_id);

1975: x_display_rec.end_period_1 := x_display_rec.end_period_1;
1976: END IF;
1977:
1978: IF G_DEBUG='Y' THEN
1979: AHL_DEBUG_PUB.debug( 'SPACE ID:'||x_scheduled_visits_tbl(l_idx).space_id);
1980: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);
1981: END IF;
1982: --
1983: IF x_display_rec.end_period_1 IS NOT NULL THEN

Line 1980: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);

1976: END IF;
1977:
1978: IF G_DEBUG='Y' THEN
1979: AHL_DEBUG_PUB.debug( 'SPACE ID:'||x_scheduled_visits_tbl(l_idx).space_id);
1980: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);
1981: END IF;
1982: --
1983: IF x_display_rec.end_period_1 IS NOT NULL THEN
1984: x_display_rec.start_period_2 := x_display_rec.end_period_1;

Line 2006: AHL_DEBUG_PUB.debug( 'value 2:'||x_scheduled_visits_tbl(l_idx).value_2);

2002: x_display_rec.end_period_2 := x_display_rec.end_period_2;
2003: END IF;
2004: --
2005: IF G_DEBUG='Y' THEN
2006: AHL_DEBUG_PUB.debug( 'value 2:'||x_scheduled_visits_tbl(l_idx).value_2);
2007: END IF;
2008: --
2009: IF x_display_rec.end_period_2 IS NOT NULL THEN
2010: x_display_rec.start_period_3 := x_display_rec.end_period_2;

Line 2032: AHL_DEBUG_PUB.debug( 'value 3:'||x_scheduled_visits_tbl(l_idx).value_3);

2028: x_display_rec.end_period_3 := x_display_rec.end_period_3;
2029: END IF;
2030: --
2031: IF G_DEBUG='Y' THEN
2032: AHL_DEBUG_PUB.debug( 'value 3:'||x_scheduled_visits_tbl(l_idx).value_3);
2033: END IF;
2034: --
2035: IF x_display_rec.end_period_3 IS NOT NULL THEN
2036: x_display_rec.start_period_4 := x_display_rec.end_period_3;

Line 2058: AHL_DEBUG_PUB.debug( 'value 4:'||x_scheduled_visits_tbl(l_idx).value_4);

2054: x_display_rec.end_period_4 := x_display_rec.end_period_4;
2055: END IF;
2056: --
2057: IF G_DEBUG='Y' THEN
2058: AHL_DEBUG_PUB.debug( 'value 4:'||x_scheduled_visits_tbl(l_idx).value_4);
2059: END IF;
2060: --
2061: IF x_display_rec.end_period_4 IS NOT NULL THEN
2062: x_display_rec.start_period_5 := x_display_rec.end_period_4;

Line 2086: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);

2082: x_display_rec.end_period_5 := x_display_rec.end_period_5;
2083: END IF;
2084: --
2085: IF G_DEBUG='Y' THEN
2086: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);
2087: END IF;
2088: --
2089: IF x_display_rec.end_period_5 IS NOT NULL THEN
2090: x_display_rec.start_period_6 := x_display_rec.end_period_5;

Line 2113: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);

2109: x_display_rec.end_period_6 := x_display_rec.end_period_6;
2110: END IF;
2111: --
2112: IF G_DEBUG='Y' THEN
2113: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);
2114: END IF;
2115: --
2116: IF x_display_rec.end_period_6 IS NOT NULL THEN
2117: x_display_rec.start_period_7 := x_display_rec.end_period_6;

Line 2140: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);

2136: x_display_rec.end_period_7 := x_display_rec.end_period_7;
2137: END IF;
2138: --
2139: IF G_DEBUG='Y' THEN
2140: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);
2141: END IF;
2142: --
2143: IF x_display_rec.end_period_7 IS NOT NULL THEN
2144: x_display_rec.start_period_8 := x_display_rec.end_period_7;

Line 2167: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);

2163: x_display_rec.end_period_8 := x_display_rec.end_period_8;
2164: END IF;
2165: --
2166: IF G_DEBUG='Y' THEN
2167: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);
2168: END IF;
2169: --
2170: IF x_display_rec.end_period_8 IS NOT NULL THEN
2171: x_display_rec.start_period_9 := x_display_rec.end_period_8;

Line 2194: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);

2190: x_display_rec.end_period_9 := x_display_rec.end_period_9;
2191: END IF;
2192: --
2193: IF G_DEBUG='Y' THEN
2194: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);
2195: END IF;
2196: --
2197: IF x_display_rec.end_period_9 IS NOT NULL THEN
2198: x_display_rec.start_period_10 := x_display_rec.end_period_9;

Line 2220: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);

2216: x_display_rec.end_period_10 := x_display_rec.end_period_10;
2217: END IF;
2218: --
2219: IF G_DEBUG='Y' THEN
2220: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);
2221: END IF;
2222: --
2223: IF x_display_rec.end_period_10 IS NOT NULL THEN
2224: x_display_rec.start_period_11 := x_display_rec.end_period_10;

Line 2246: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);

2242: x_display_rec.end_period_11 := x_display_rec.end_period_11;
2243: END IF;
2244: --
2245: IF G_DEBUG='Y' THEN
2246: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);
2247: END IF;
2248: --
2249: IF x_display_rec.end_period_11 IS NOT NULL THEN
2250: x_display_rec.start_period_12 := x_display_rec.end_period_11;

Line 2272: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);

2268: x_display_rec.end_period_12 := x_display_rec.end_period_12;
2269: END IF;
2270: --
2271: IF G_DEBUG='Y' THEN
2272: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);
2273: END IF;
2274: --
2275: IF x_display_rec.end_period_12 IS NOT NULL THEN
2276: x_display_rec.start_period_13 := x_display_rec.end_period_12;

Line 2298: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);

2294: x_display_rec.end_period_13 := x_display_rec.end_period_13;
2295: END IF;
2296: --
2297: IF G_DEBUG='Y' THEN
2298: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);
2299: END IF;
2300: --
2301: IF x_display_rec.end_period_13 IS NOT NULL THEN
2302: x_display_rec.start_period_14 := x_display_rec.end_period_13;

Line 2324: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);

2320: x_display_rec.end_period_14 := x_display_rec.end_period_14;
2321: END IF;
2322: --
2323: IF G_DEBUG='Y' THEN
2324: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);
2325: END IF;
2326: x_scheduled_visits_tbl(l_idx).space_id := null;
2327: x_scheduled_visits_tbl(l_idx).space_name := null;
2328: x_scheduled_visits_tbl(l_idx).department_code := l_dept_code;

Line 2368: AHL_DEBUG_PUB.debug( 'count W1:'||l_count);

2364: x_display_rec.start_period_1,
2365: x_display_rec.end_period_1);
2366:
2367: IF G_DEBUG='Y' THEN
2368: AHL_DEBUG_PUB.debug( 'count W1:'||l_count);
2369: END IF;
2370: IF l_count = 1 THEN
2371: x_scheduled_visits_tbl(l_idx).value_1 := 'S';
2372: ELSIF l_count > 1 THEN

Line 2389: AHL_DEBUG_PUB.debug( 'SPACE ID:'||x_scheduled_visits_tbl(l_idx).space_id);

2385: x_display_rec.end_period_1 := x_display_rec.end_period_1;
2386: END IF;
2387:
2388: IF G_DEBUG='Y' THEN
2389: AHL_DEBUG_PUB.debug( 'SPACE ID:'||x_scheduled_visits_tbl(l_idx).space_id);
2390: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);
2391: END IF;
2392: --
2393: IF x_display_rec.end_period_1 IS NOT NULL THEN

Line 2390: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);

2386: END IF;
2387:
2388: IF G_DEBUG='Y' THEN
2389: AHL_DEBUG_PUB.debug( 'SPACE ID:'||x_scheduled_visits_tbl(l_idx).space_id);
2390: AHL_DEBUG_PUB.debug( 'value 1:'||x_scheduled_visits_tbl(l_idx).value_1);
2391: END IF;
2392: --
2393: IF x_display_rec.end_period_1 IS NOT NULL THEN
2394: x_display_rec.start_period_2 := x_display_rec.end_period_1;

Line 2423: AHL_DEBUG_PUB.debug( 'value 2:'||x_scheduled_visits_tbl(l_idx).value_2);

2419: x_display_rec.end_period_2 := x_display_rec.end_period_2;
2420: END IF;
2421: --
2422: IF G_DEBUG='Y' THEN
2423: AHL_DEBUG_PUB.debug( 'value 2:'||x_scheduled_visits_tbl(l_idx).value_2);
2424: END IF;
2425: --
2426: IF x_display_rec.end_period_2 IS NOT NULL THEN
2427: x_display_rec.start_period_3 := x_display_rec.end_period_2;

Line 2455: AHL_DEBUG_PUB.debug( 'value 3:'||x_scheduled_visits_tbl(l_idx).value_3);

2451: x_display_rec.end_period_3 := x_display_rec.end_period_3;
2452: END IF;
2453: --
2454: IF G_DEBUG='Y' THEN
2455: AHL_DEBUG_PUB.debug( 'value 3:'||x_scheduled_visits_tbl(l_idx).value_3);
2456: END IF;
2457: --
2458: IF x_display_rec.end_period_3 IS NOT NULL THEN
2459: x_display_rec.start_period_4 := x_display_rec.end_period_3;

Line 2487: AHL_DEBUG_PUB.debug( 'value 4:'||x_scheduled_visits_tbl(l_idx).value_4);

2483: x_display_rec.end_period_4 := x_display_rec.end_period_4;
2484: END IF;
2485: --
2486: IF G_DEBUG='Y' THEN
2487: AHL_DEBUG_PUB.debug( 'value 4:'||x_scheduled_visits_tbl(l_idx).value_4);
2488: END IF;
2489: --
2490: IF x_display_rec.end_period_4 IS NOT NULL THEN
2491: x_display_rec.start_period_5 := x_display_rec.end_period_4;

Line 2520: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);

2516: x_display_rec.end_period_5 := x_display_rec.end_period_5;
2517: END IF;
2518: --
2519: IF G_DEBUG='Y' THEN
2520: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);
2521: END IF;
2522: --
2523: IF x_display_rec.end_period_5 IS NOT NULL THEN
2524: x_display_rec.start_period_6 := x_display_rec.end_period_5;

Line 2552: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);

2548: x_display_rec.end_period_6 := x_display_rec.end_period_6;
2549: END IF;
2550: --
2551: IF G_DEBUG='Y' THEN
2552: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);
2553: END IF;
2554: --
2555: IF x_display_rec.end_period_6 IS NOT NULL THEN
2556: x_display_rec.start_period_7 := x_display_rec.end_period_6;

Line 2585: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);

2581: x_display_rec.end_period_7 := x_display_rec.end_period_7;
2582: END IF;
2583: --
2584: IF G_DEBUG='Y' THEN
2585: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);
2586: END IF;
2587: --
2588: IF x_display_rec.end_period_7 IS NOT NULL THEN
2589: x_display_rec.start_period_8 := x_display_rec.end_period_7;

Line 2618: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);

2614: x_display_rec.end_period_8 := x_display_rec.end_period_8;
2615: END IF;
2616: --
2617: IF G_DEBUG='Y' THEN
2618: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);
2619: END IF;
2620: --
2621: IF x_display_rec.end_period_8 IS NOT NULL THEN
2622: x_display_rec.start_period_9 := x_display_rec.end_period_8;

Line 2651: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);

2647: x_display_rec.end_period_9 := x_display_rec.end_period_9;
2648: END IF;
2649: --
2650: IF G_DEBUG='Y' THEN
2651: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);
2652: END IF;
2653: --
2654: IF x_display_rec.end_period_9 IS NOT NULL THEN
2655: x_display_rec.start_period_10 := x_display_rec.end_period_9;

Line 2683: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);

2679: x_display_rec.end_period_10 := x_display_rec.end_period_10;
2680: END IF;
2681: --
2682: IF G_DEBUG='Y' THEN
2683: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);
2684: END IF;
2685: --
2686: IF x_display_rec.end_period_10 IS NOT NULL THEN
2687: x_display_rec.start_period_11 := x_display_rec.end_period_10;

Line 2715: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);

2711: x_display_rec.end_period_11 := x_display_rec.end_period_11;
2712: END IF;
2713: --
2714: IF G_DEBUG='Y' THEN
2715: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);
2716: END IF;
2717: --
2718: IF x_display_rec.end_period_11 IS NOT NULL THEN
2719: x_display_rec.start_period_12 := x_display_rec.end_period_11;

Line 2747: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);

2743: x_display_rec.end_period_12 := x_display_rec.end_period_12;
2744: END IF;
2745: --
2746: IF G_DEBUG='Y' THEN
2747: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);
2748: END IF;
2749: --
2750: IF x_display_rec.end_period_12 IS NOT NULL THEN
2751: x_display_rec.start_period_13 := x_display_rec.end_period_12;

Line 2779: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);

2775: x_display_rec.end_period_13 := x_display_rec.end_period_13;
2776: END IF;
2777: --
2778: IF G_DEBUG='Y' THEN
2779: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);
2780: END IF;
2781: --
2782: IF x_display_rec.end_period_13 IS NOT NULL THEN
2783: x_display_rec.start_period_14 := x_display_rec.end_period_13;

Line 2811: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);

2807: x_display_rec.end_period_14 := x_display_rec.end_period_14;
2808: END IF;
2809: --
2810: IF G_DEBUG='Y' THEN
2811: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);
2812: END IF;
2813: x_scheduled_visits_tbl(l_idx).space_id := l_space_id;
2814: x_scheduled_visits_tbl(l_idx).space_name := l_space_name;
2815: x_scheduled_visits_tbl(l_idx).department_code := l_dept_code;

Line 2933: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);

2929: l_tempbind_tbl(l_bind_idx) := p_space_category;
2930: l_bind_idx := l_bind_idx + 1;
2931: END IF;
2932: --
2933: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
2934: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
2935: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
2936: --Space info
2937:

Line 2934: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);

2930: l_bind_idx := l_bind_idx + 1;
2931: END IF;
2932: --
2933: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
2934: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
2935: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
2936: --Space info
2937:
2938: --SELECT Clause

Line 2935: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);

2931: END IF;
2932: --
2933: AHL_DEBUG_PUB.debug( 'l_sql_string:'||l_sql_string);
2934: AHL_DEBUG_PUB.debug( 'p_org_id:'||p_org_id);
2935: AHL_DEBUG_PUB.debug( 'p_dept_name:'||p_dept_name);
2936: --Space info
2937:
2938: --SELECT Clause
2939: l_sql_string1 := ' SELECT distinct(a.space_id), space_name, space_category, meaning,';

Line 3020: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);

3016: l_sql_string := l_sql_string || ' and exists ( SELECT ''x'' FROM AHL_DEPARTMENT_SHIFTS WHERE DEPARTMENT_ID = B.DEPARTMENT_ID) ' ;
3017: END IF;
3018:
3019:
3020: AHL_DEBUG_PUB.debug( 'l_sql_string1:'||l_sql_string1);
3021:
3022: -- Department details
3023: OPEN_FOR_CURSOR(p_x_ref_csr => l_dept_cur,
3024: p_search_query_tbl => l_tempbind_tbl,

Line 3060: AHL_DEBUG_PUB.debug( 'value 1:'||x_display_rec.field_1);

3056: x_display_rec.end_period_1 := x_display_rec.end_period_1;
3057: END IF;
3058: --
3059: IF G_DEBUG='Y' THEN
3060: AHL_DEBUG_PUB.debug( 'value 1:'||x_display_rec.field_1);
3061: AHL_DEBUG_PUB.debug( 'start 1:'||x_display_rec.start_period_1);
3062: AHL_DEBUG_PUB.debug( 'end 1:'||x_display_rec.end_period_1);
3063: END IF;
3064: --

Line 3061: AHL_DEBUG_PUB.debug( 'start 1:'||x_display_rec.start_period_1);

3057: END IF;
3058: --
3059: IF G_DEBUG='Y' THEN
3060: AHL_DEBUG_PUB.debug( 'value 1:'||x_display_rec.field_1);
3061: AHL_DEBUG_PUB.debug( 'start 1:'||x_display_rec.start_period_1);
3062: AHL_DEBUG_PUB.debug( 'end 1:'||x_display_rec.end_period_1);
3063: END IF;
3064: --
3065: IF x_display_rec.end_period_1 IS NOT NULL THEN

Line 3062: AHL_DEBUG_PUB.debug( 'end 1:'||x_display_rec.end_period_1);

3058: --
3059: IF G_DEBUG='Y' THEN
3060: AHL_DEBUG_PUB.debug( 'value 1:'||x_display_rec.field_1);
3061: AHL_DEBUG_PUB.debug( 'start 1:'||x_display_rec.start_period_1);
3062: AHL_DEBUG_PUB.debug( 'end 1:'||x_display_rec.end_period_1);
3063: END IF;
3064: --
3065: IF x_display_rec.end_period_1 IS NOT NULL THEN
3066: x_display_rec.start_period_2:= x_display_rec.end_period_1;

Line 3090: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);

3086: x_display_rec.end_period_2 := x_display_rec.end_period_2;
3087: END IF;
3088: --
3089: IF G_DEBUG='Y' THEN
3090: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);
3091: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);
3092: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);
3093: END IF;
3094: --

Line 3091: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);

3087: END IF;
3088: --
3089: IF G_DEBUG='Y' THEN
3090: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);
3091: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);
3092: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);
3093: END IF;
3094: --
3095: IF x_display_rec.end_period_2 IS NOT NULL THEN

Line 3092: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);

3088: --
3089: IF G_DEBUG='Y' THEN
3090: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);
3091: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);
3092: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);
3093: END IF;
3094: --
3095: IF x_display_rec.end_period_2 IS NOT NULL THEN
3096: x_display_rec.start_period_3:= x_display_rec.end_period_2;

Line 3120: AHL_DEBUG_PUB.debug( 'value 3:'||x_display_rec.field_3);

3116: x_display_rec.end_period_3 := x_display_rec.end_period_3;
3117: END IF;
3118: --
3119: IF G_DEBUG='Y' THEN
3120: AHL_DEBUG_PUB.debug( 'value 3:'||x_display_rec.field_3);
3121: AHL_DEBUG_PUB.debug( 'start 3:'||x_display_rec.start_period_3);
3122: AHL_DEBUG_PUB.debug( 'end 3:'||x_display_rec.end_period_3);
3123: END IF;
3124: --

Line 3121: AHL_DEBUG_PUB.debug( 'start 3:'||x_display_rec.start_period_3);

3117: END IF;
3118: --
3119: IF G_DEBUG='Y' THEN
3120: AHL_DEBUG_PUB.debug( 'value 3:'||x_display_rec.field_3);
3121: AHL_DEBUG_PUB.debug( 'start 3:'||x_display_rec.start_period_3);
3122: AHL_DEBUG_PUB.debug( 'end 3:'||x_display_rec.end_period_3);
3123: END IF;
3124: --
3125: IF x_display_rec.end_period_3 IS NOT NULL THEN

Line 3122: AHL_DEBUG_PUB.debug( 'end 3:'||x_display_rec.end_period_3);

3118: --
3119: IF G_DEBUG='Y' THEN
3120: AHL_DEBUG_PUB.debug( 'value 3:'||x_display_rec.field_3);
3121: AHL_DEBUG_PUB.debug( 'start 3:'||x_display_rec.start_period_3);
3122: AHL_DEBUG_PUB.debug( 'end 3:'||x_display_rec.end_period_3);
3123: END IF;
3124: --
3125: IF x_display_rec.end_period_3 IS NOT NULL THEN
3126: x_display_rec.start_period_4:= x_display_rec.end_period_3;

Line 3150: AHL_DEBUG_PUB.debug( 'value 4:'||x_display_rec.field_4);

3146: x_display_rec.end_period_4 := x_display_rec.end_period_4;
3147: END IF;
3148: --
3149: IF G_DEBUG='Y' THEN
3150: AHL_DEBUG_PUB.debug( 'value 4:'||x_display_rec.field_4);
3151: AHL_DEBUG_PUB.debug( 'start 4:'||x_display_rec.start_period_4);
3152: AHL_DEBUG_PUB.debug( 'end 4:'||x_display_rec.end_period_4);
3153: END IF;
3154: --

Line 3151: AHL_DEBUG_PUB.debug( 'start 4:'||x_display_rec.start_period_4);

3147: END IF;
3148: --
3149: IF G_DEBUG='Y' THEN
3150: AHL_DEBUG_PUB.debug( 'value 4:'||x_display_rec.field_4);
3151: AHL_DEBUG_PUB.debug( 'start 4:'||x_display_rec.start_period_4);
3152: AHL_DEBUG_PUB.debug( 'end 4:'||x_display_rec.end_period_4);
3153: END IF;
3154: --
3155: IF x_display_rec.end_period_4 IS NOT NULL THEN

Line 3152: AHL_DEBUG_PUB.debug( 'end 4:'||x_display_rec.end_period_4);

3148: --
3149: IF G_DEBUG='Y' THEN
3150: AHL_DEBUG_PUB.debug( 'value 4:'||x_display_rec.field_4);
3151: AHL_DEBUG_PUB.debug( 'start 4:'||x_display_rec.start_period_4);
3152: AHL_DEBUG_PUB.debug( 'end 4:'||x_display_rec.end_period_4);
3153: END IF;
3154: --
3155: IF x_display_rec.end_period_4 IS NOT NULL THEN
3156: x_display_rec.start_period_5:= x_display_rec.end_period_4;

Line 3180: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);

3176: x_display_rec.end_period_5 := x_display_rec.end_period_5;
3177: END IF;
3178: --
3179: IF G_DEBUG='Y' THEN
3180: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);
3181: END IF;
3182: --
3183: IF x_display_rec.end_period_5 IS NOT NULL THEN
3184: x_display_rec.start_period_6:= x_display_rec.end_period_5;

Line 3208: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);

3204: x_display_rec.end_period_6 := x_display_rec.end_period_6;
3205: END IF;
3206: --
3207: IF G_DEBUG='Y' THEN
3208: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);
3209: END IF;
3210: --
3211: IF x_display_rec.end_period_6 IS NOT NULL THEN
3212: x_display_rec.start_period_7:= x_display_rec.end_period_6;

Line 3236: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);

3232: x_display_rec.end_period_7 := x_display_rec.end_period_7;
3233: END IF;
3234: --
3235: IF G_DEBUG='Y' THEN
3236: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);
3237: END IF;
3238: --
3239: IF x_display_rec.end_period_7 IS NOT NULL THEN
3240: x_display_rec.start_period_8:= x_display_rec.end_period_7;

Line 3264: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);

3260: x_display_rec.end_period_8 := x_display_rec.end_period_8;
3261: END IF;
3262: --
3263: IF G_DEBUG='Y' THEN
3264: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);
3265: END IF;
3266: --
3267: IF x_display_rec.end_period_8 IS NOT NULL THEN
3268: x_display_rec.start_period_9:= x_display_rec.end_period_8;

Line 3292: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);

3288: x_display_rec.end_period_9 := x_display_rec.end_period_9;
3289: END IF;
3290: --
3291: IF G_DEBUG='Y' THEN
3292: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);
3293: END IF;
3294: --
3295: IF x_display_rec.end_period_9 IS NOT NULL THEN
3296: x_display_rec.start_period_10:= x_display_rec.end_period_9;

Line 3320: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);

3316: x_display_rec.end_period_10 := x_display_rec.end_period_10;
3317: END IF;
3318: --
3319: IF G_DEBUG='Y' THEN
3320: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);
3321: END IF;
3322: --
3323: IF x_display_rec.end_period_10 IS NOT NULL THEN
3324: x_display_rec.start_period_11:= x_display_rec.end_period_10;

Line 3348: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);

3344: x_display_rec.end_period_11 := x_display_rec.end_period_11;
3345: END IF;
3346: --
3347: IF G_DEBUG='Y' THEN
3348: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);
3349: END IF;
3350: --
3351: IF x_display_rec.end_period_11 IS NOT NULL THEN
3352: x_display_rec.start_period_12:= x_display_rec.end_period_11;

Line 3376: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);

3372: x_display_rec.end_period_12 := x_display_rec.end_period_12;
3373: END IF;
3374: --
3375: IF G_DEBUG='Y' THEN
3376: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);
3377: END IF;
3378: --
3379: IF x_display_rec.end_period_12 IS NOT NULL THEN
3380: x_display_rec.start_period_13:= x_display_rec.end_period_12;

Line 3404: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);

3400: x_display_rec.end_period_13 := x_display_rec.end_period_13;
3401: END IF;
3402: --
3403: IF G_DEBUG='Y' THEN
3404: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);
3405: END IF;
3406: --
3407: IF x_display_rec.end_period_13 IS NOT NULL THEN
3408: x_display_rec.start_period_14:= x_display_rec.end_period_13;

Line 3432: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);

3428: x_display_rec.end_period_14 := x_display_rec.end_period_14;
3429: END IF;
3430: --
3431: IF G_DEBUG='Y' THEN
3432: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);
3433: END IF;
3434: --
3435: x_scheduled_visits_tbl(l_idx).space_id := null;
3436: x_scheduled_visits_tbl(l_idx).space_name := null;

Line 3499: AHL_DEBUG_PUB.debug( 'value 1:'||x_display_rec.field_1);

3495: x_display_rec.end_period_1 := x_display_rec.end_period_1;
3496: END IF;
3497: --
3498: IF G_DEBUG='Y' THEN
3499: AHL_DEBUG_PUB.debug( 'value 1:'||x_display_rec.field_1);
3500: AHL_DEBUG_PUB.debug( 'start 1:'||x_display_rec.start_period_1);
3501: AHL_DEBUG_PUB.debug( 'end 1:'||x_display_rec.end_period_1);
3502: END IF;
3503: --

Line 3500: AHL_DEBUG_PUB.debug( 'start 1:'||x_display_rec.start_period_1);

3496: END IF;
3497: --
3498: IF G_DEBUG='Y' THEN
3499: AHL_DEBUG_PUB.debug( 'value 1:'||x_display_rec.field_1);
3500: AHL_DEBUG_PUB.debug( 'start 1:'||x_display_rec.start_period_1);
3501: AHL_DEBUG_PUB.debug( 'end 1:'||x_display_rec.end_period_1);
3502: END IF;
3503: --
3504: IF x_display_rec.end_period_1 IS NOT NULL THEN

Line 3501: AHL_DEBUG_PUB.debug( 'end 1:'||x_display_rec.end_period_1);

3497: --
3498: IF G_DEBUG='Y' THEN
3499: AHL_DEBUG_PUB.debug( 'value 1:'||x_display_rec.field_1);
3500: AHL_DEBUG_PUB.debug( 'start 1:'||x_display_rec.start_period_1);
3501: AHL_DEBUG_PUB.debug( 'end 1:'||x_display_rec.end_period_1);
3502: END IF;
3503: --
3504: IF x_display_rec.end_period_1 IS NOT NULL THEN
3505: x_display_rec.start_period_2:= x_display_rec.end_period_1;

Line 3535: AHL_DEBUG_PUB.debug( 'SPACE ID:'||l_space_id);

3531: x_display_rec.end_period_2 := x_display_rec.end_period_2;
3532: END IF;
3533: --
3534: IF G_DEBUG='Y' THEN
3535: AHL_DEBUG_PUB.debug( 'SPACE ID:'||l_space_id);
3536: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);
3537: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);
3538: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);
3539: END IF;

Line 3536: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);

3532: END IF;
3533: --
3534: IF G_DEBUG='Y' THEN
3535: AHL_DEBUG_PUB.debug( 'SPACE ID:'||l_space_id);
3536: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);
3537: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);
3538: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);
3539: END IF;
3540: --

Line 3537: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);

3533: --
3534: IF G_DEBUG='Y' THEN
3535: AHL_DEBUG_PUB.debug( 'SPACE ID:'||l_space_id);
3536: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);
3537: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);
3538: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);
3539: END IF;
3540: --
3541: IF x_display_rec.end_period_2 IS NOT NULL THEN

Line 3538: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);

3534: IF G_DEBUG='Y' THEN
3535: AHL_DEBUG_PUB.debug( 'SPACE ID:'||l_space_id);
3536: AHL_DEBUG_PUB.debug( 'value 2:'||x_display_rec.field_2);
3537: AHL_DEBUG_PUB.debug( 'start 2:'||x_display_rec.start_period_2);
3538: AHL_DEBUG_PUB.debug( 'end 2:'||x_display_rec.end_period_2);
3539: END IF;
3540: --
3541: IF x_display_rec.end_period_2 IS NOT NULL THEN
3542: x_display_rec.start_period_3:= x_display_rec.end_period_2;

Line 3572: AHL_DEBUG_PUB.debug( 'value 3:'||x_display_rec.field_3);

3568: x_display_rec.end_period_3 := x_display_rec.end_period_3;
3569: END IF;
3570: --
3571: IF G_DEBUG='Y' THEN
3572: AHL_DEBUG_PUB.debug( 'value 3:'||x_display_rec.field_3);
3573: AHL_DEBUG_PUB.debug( 'start 3:'||x_display_rec.start_period_3);
3574: AHL_DEBUG_PUB.debug( 'end 3:'||x_display_rec.end_period_3);
3575: END IF;
3576: --

Line 3573: AHL_DEBUG_PUB.debug( 'start 3:'||x_display_rec.start_period_3);

3569: END IF;
3570: --
3571: IF G_DEBUG='Y' THEN
3572: AHL_DEBUG_PUB.debug( 'value 3:'||x_display_rec.field_3);
3573: AHL_DEBUG_PUB.debug( 'start 3:'||x_display_rec.start_period_3);
3574: AHL_DEBUG_PUB.debug( 'end 3:'||x_display_rec.end_period_3);
3575: END IF;
3576: --
3577: IF x_display_rec.end_period_3 IS NOT NULL THEN

Line 3574: AHL_DEBUG_PUB.debug( 'end 3:'||x_display_rec.end_period_3);

3570: --
3571: IF G_DEBUG='Y' THEN
3572: AHL_DEBUG_PUB.debug( 'value 3:'||x_display_rec.field_3);
3573: AHL_DEBUG_PUB.debug( 'start 3:'||x_display_rec.start_period_3);
3574: AHL_DEBUG_PUB.debug( 'end 3:'||x_display_rec.end_period_3);
3575: END IF;
3576: --
3577: IF x_display_rec.end_period_3 IS NOT NULL THEN
3578: x_display_rec.start_period_4:= x_display_rec.end_period_3;

Line 3608: AHL_DEBUG_PUB.debug( 'value 4:'||x_display_rec.field_4);

3604: x_display_rec.end_period_4 := x_display_rec.end_period_4;
3605: END IF;
3606: --
3607: IF G_DEBUG='Y' THEN
3608: AHL_DEBUG_PUB.debug( 'value 4:'||x_display_rec.field_4);
3609: AHL_DEBUG_PUB.debug( 'start 4:'||x_display_rec.start_period_4);
3610: AHL_DEBUG_PUB.debug( 'end 4:'||x_display_rec.end_period_4);
3611: END IF;
3612: --

Line 3609: AHL_DEBUG_PUB.debug( 'start 4:'||x_display_rec.start_period_4);

3605: END IF;
3606: --
3607: IF G_DEBUG='Y' THEN
3608: AHL_DEBUG_PUB.debug( 'value 4:'||x_display_rec.field_4);
3609: AHL_DEBUG_PUB.debug( 'start 4:'||x_display_rec.start_period_4);
3610: AHL_DEBUG_PUB.debug( 'end 4:'||x_display_rec.end_period_4);
3611: END IF;
3612: --
3613: IF x_display_rec.end_period_4 IS NOT NULL THEN

Line 3610: AHL_DEBUG_PUB.debug( 'end 4:'||x_display_rec.end_period_4);

3606: --
3607: IF G_DEBUG='Y' THEN
3608: AHL_DEBUG_PUB.debug( 'value 4:'||x_display_rec.field_4);
3609: AHL_DEBUG_PUB.debug( 'start 4:'||x_display_rec.start_period_4);
3610: AHL_DEBUG_PUB.debug( 'end 4:'||x_display_rec.end_period_4);
3611: END IF;
3612: --
3613: IF x_display_rec.end_period_4 IS NOT NULL THEN
3614: x_display_rec.start_period_5:= x_display_rec.end_period_4;

Line 3644: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);

3640: x_display_rec.end_period_5 := x_display_rec.end_period_5;
3641: END IF;
3642: --
3643: IF G_DEBUG='Y' THEN
3644: AHL_DEBUG_PUB.debug( 'value 5:'||x_scheduled_visits_tbl(l_idx).value_5);
3645: END IF;
3646: --
3647: IF x_display_rec.end_period_5 IS NOT NULL THEN
3648: x_display_rec.start_period_6:= x_display_rec.end_period_5;

Line 3678: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);

3674: x_display_rec.end_period_6 := x_display_rec.end_period_6;
3675: END IF;
3676: --
3677: IF G_DEBUG='Y' THEN
3678: AHL_DEBUG_PUB.debug( 'value 6:'||x_scheduled_visits_tbl(l_idx).value_6);
3679: END IF;
3680: --
3681: IF x_display_rec.end_period_6 IS NOT NULL THEN
3682: x_display_rec.start_period_7:= x_display_rec.end_period_6;

Line 3712: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);

3708: x_display_rec.end_period_7 := x_display_rec.end_period_7;
3709: END IF;
3710: --
3711: IF G_DEBUG='Y' THEN
3712: AHL_DEBUG_PUB.debug( 'value 7:'||x_scheduled_visits_tbl(l_idx).value_7);
3713: END IF;
3714: --
3715: IF x_display_rec.end_period_7 IS NOT NULL THEN
3716: x_display_rec.start_period_8:= x_display_rec.end_period_7;

Line 3746: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);

3742: x_display_rec.end_period_8 := x_display_rec.end_period_8;
3743: END IF;
3744: --
3745: IF G_DEBUG='Y' THEN
3746: AHL_DEBUG_PUB.debug( 'value 8:'||x_scheduled_visits_tbl(l_idx).value_8);
3747: END IF;
3748: --
3749: IF x_display_rec.end_period_8 IS NOT NULL THEN
3750: x_display_rec.start_period_9:= x_display_rec.end_period_8;

Line 3780: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);

3776: x_display_rec.end_period_9 := x_display_rec.end_period_9;
3777: END IF;
3778: --
3779: IF G_DEBUG='Y' THEN
3780: AHL_DEBUG_PUB.debug( 'value 9:'||x_scheduled_visits_tbl(l_idx).value_9);
3781: END IF;
3782: --
3783: IF x_display_rec.end_period_9 IS NOT NULL THEN
3784: x_display_rec.start_period_10:= x_display_rec.end_period_9;

Line 3814: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);

3810: x_display_rec.end_period_10 := x_display_rec.end_period_10;
3811: END IF;
3812: --
3813: IF G_DEBUG='Y' THEN
3814: AHL_DEBUG_PUB.debug( 'value 10:'||x_scheduled_visits_tbl(l_idx).value_10);
3815: END IF;
3816: --
3817: IF x_display_rec.end_period_10 IS NOT NULL THEN
3818: x_display_rec.start_period_11:= x_display_rec.end_period_10;

Line 3848: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);

3844: x_display_rec.end_period_11 := x_display_rec.end_period_11;
3845: END IF;
3846: --
3847: IF G_DEBUG='Y' THEN
3848: AHL_DEBUG_PUB.debug( 'value 11:'||x_scheduled_visits_tbl(l_idx).value_11);
3849: END IF;
3850: --
3851: IF x_display_rec.end_period_11 IS NOT NULL THEN
3852: x_display_rec.start_period_12:= x_display_rec.end_period_11;

Line 3882: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);

3878: x_display_rec.end_period_12 := x_display_rec.end_period_12;
3879: END IF;
3880: --
3881: IF G_DEBUG='Y' THEN
3882: AHL_DEBUG_PUB.debug( 'value 12:'||x_scheduled_visits_tbl(l_idx).value_12);
3883: END IF;
3884: --
3885: IF x_display_rec.end_period_12 IS NOT NULL THEN
3886: x_display_rec.start_period_13:= x_display_rec.end_period_12;

Line 3916: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);

3912: x_display_rec.end_period_13 := x_display_rec.end_period_13;
3913: END IF;
3914: --
3915: IF G_DEBUG='Y' THEN
3916: AHL_DEBUG_PUB.debug( 'value 13:'||x_scheduled_visits_tbl(l_idx).value_13);
3917: END IF;
3918: --
3919: IF x_display_rec.end_period_13 IS NOT NULL THEN
3920: x_display_rec.start_period_14:= x_display_rec.end_period_13;

Line 3950: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);

3946: x_display_rec.end_period_14 := x_display_rec.end_period_14;
3947: END IF;
3948: --
3949: IF G_DEBUG='Y' THEN
3950: AHL_DEBUG_PUB.debug( 'value 14:'||x_scheduled_visits_tbl(l_idx).value_14);
3951: END IF;
3952: x_scheduled_visits_tbl(l_idx).space_id := l_space_id;
3953: x_scheduled_visits_tbl(l_idx).space_name := l_space_name;
3954: x_scheduled_visits_tbl(l_idx).department_code := l_dept_code;

Line 4084: AHL_DEBUG_PUB.enable_debug;

4080: -- Standard Start of API savepoint
4081: SAVEPOINT Search_Scheduled_Visits;
4082: -- Check if API is called in debug mode. If yes, enable debug.
4083: IF G_DEBUG='Y' THEN
4084: AHL_DEBUG_PUB.enable_debug;
4085: END IF;
4086: -- Debug info.
4087: IF G_DEBUG='Y' THEN
4088: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt. Search Scheduled Visits','+SPANT+');

Line 4088: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt. Search Scheduled Visits','+SPANT+');

4084: AHL_DEBUG_PUB.enable_debug;
4085: END IF;
4086: -- Debug info.
4087: IF G_DEBUG='Y' THEN
4088: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt. Search Scheduled Visits','+SPANT+');
4089: END IF;
4090: -- Standard call to check for call compatibility.
4091: IF FND_API.to_boolean(p_init_msg_list)
4092: THEN

Line 4106: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.start_date'||l_search_visits_Rec.start_date);

4102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4103: END IF;
4104: --
4105: IF G_DEBUG='Y' THEN
4106: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.start_date'||l_search_visits_Rec.start_date);
4107: END IF;
4108: --
4109: ---------------------start API Body------------------------------------
4110: -- Get org id from org name or vice versa

Line 4243: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_id'||l_search_visits_Rec.plan_id);

4239: END IF;
4240: END IF;
4241: --
4242: IF G_DEBUG='Y' THEN
4243: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_id'||l_search_visits_Rec.plan_id);
4244: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_name'||l_search_visits_Rec.plan_name);
4245: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.item_id'||l_search_visits_Rec.item_id);
4246: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.visit_type'||l_search_visits_Rec.visit_type_code);
4247: END IF;

Line 4244: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_name'||l_search_visits_Rec.plan_name);

4240: END IF;
4241: --
4242: IF G_DEBUG='Y' THEN
4243: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_id'||l_search_visits_Rec.plan_id);
4244: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_name'||l_search_visits_Rec.plan_name);
4245: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.item_id'||l_search_visits_Rec.item_id);
4246: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.visit_type'||l_search_visits_Rec.visit_type_code);
4247: END IF;
4248: --Get plan id

Line 4245: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.item_id'||l_search_visits_Rec.item_id);

4241: --
4242: IF G_DEBUG='Y' THEN
4243: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_id'||l_search_visits_Rec.plan_id);
4244: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_name'||l_search_visits_Rec.plan_name);
4245: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.item_id'||l_search_visits_Rec.item_id);
4246: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.visit_type'||l_search_visits_Rec.visit_type_code);
4247: END IF;
4248: --Get plan id
4249: OPEN get_plan_id_cur(l_search_visits_Rec.plan_id);

Line 4246: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.visit_type'||l_search_visits_Rec.visit_type_code);

4242: IF G_DEBUG='Y' THEN
4243: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_id'||l_search_visits_Rec.plan_id);
4244: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.plan_name'||l_search_visits_Rec.plan_name);
4245: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.item_id'||l_search_visits_Rec.item_id);
4246: AHL_DEBUG_PUB.debug( 'l_search_visits_Rec.visit_type'||l_search_visits_Rec.visit_type_code);
4247: END IF;
4248: --Get plan id
4249: OPEN get_plan_id_cur(l_search_visits_Rec.plan_id);
4250: FETCH get_plan_id_cur INTO l_simulation_plan_id,l_plan_flag;

Line 4264: AHL_DEBUG_PUB.debug( 'l_simulation_plan_id:'||l_simulation_plan_id);

4260:
4261: -- l_start_date := TO_CHAR(l_search_visits_Rec.start_date, 'DD-MM-YYYY ');
4262: --
4263: IF G_DEBUG='Y' THEN
4264: AHL_DEBUG_PUB.debug( 'l_simulation_plan_id:'||l_simulation_plan_id);
4265: AHL_DEBUG_PUB.debug( 'l_plan_flag:'||l_plan_flag);
4266: AHL_DEBUG_PUB.debug( 'l_start_date:'||l_start_date);
4267:
4268: END IF;

Line 4265: AHL_DEBUG_PUB.debug( 'l_plan_flag:'||l_plan_flag);

4261: -- l_start_date := TO_CHAR(l_search_visits_Rec.start_date, 'DD-MM-YYYY ');
4262: --
4263: IF G_DEBUG='Y' THEN
4264: AHL_DEBUG_PUB.debug( 'l_simulation_plan_id:'||l_simulation_plan_id);
4265: AHL_DEBUG_PUB.debug( 'l_plan_flag:'||l_plan_flag);
4266: AHL_DEBUG_PUB.debug( 'l_start_date:'||l_start_date);
4267:
4268: END IF;
4269: --

Line 4266: AHL_DEBUG_PUB.debug( 'l_start_date:'||l_start_date);

4262: --
4263: IF G_DEBUG='Y' THEN
4264: AHL_DEBUG_PUB.debug( 'l_simulation_plan_id:'||l_simulation_plan_id);
4265: AHL_DEBUG_PUB.debug( 'l_plan_flag:'||l_plan_flag);
4266: AHL_DEBUG_PUB.debug( 'l_start_date:'||l_start_date);
4267:
4268: END IF;
4269: --
4270: IF l_search_visits_Rec.display_period_code = 'DAYS' THEN

Line 4526: Ahl_Debug_Pub.debug( 'End of private api Search Scheduled Visits','+SPANT+');

4522: COMMIT;
4523: END IF;
4524: -- Debug info
4525: IF G_DEBUG='Y' THEN
4526: Ahl_Debug_Pub.debug( 'End of private api Search Scheduled Visits','+SPANT+');
4527: -- Check if API is called in debug mode. If yes, disable debug.
4528: Ahl_Debug_Pub.disable_debug;
4529: END IF;
4530:

Line 4528: Ahl_Debug_Pub.disable_debug;

4524: -- Debug info
4525: IF G_DEBUG='Y' THEN
4526: Ahl_Debug_Pub.debug( 'End of private api Search Scheduled Visits','+SPANT+');
4527: -- Check if API is called in debug mode. If yes, disable debug.
4528: Ahl_Debug_Pub.disable_debug;
4529: END IF;
4530:
4531: EXCEPTION
4532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4540: AHL_DEBUG_PUB.log_app_messages (

4536: p_count => x_msg_count,
4537: p_data => x_msg_data);
4538:
4539: IF G_DEBUG='Y' THEN
4540: AHL_DEBUG_PUB.log_app_messages (
4541: x_msg_count, x_msg_data, 'ERROR' );
4542: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4543: -- Check if API is called in debug mode. If yes, disable debug.
4544: AHL_DEBUG_PUB.disable_debug;

Line 4542: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');

4538:
4539: IF G_DEBUG='Y' THEN
4540: AHL_DEBUG_PUB.log_app_messages (
4541: x_msg_count, x_msg_data, 'ERROR' );
4542: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4543: -- Check if API is called in debug mode. If yes, disable debug.
4544: AHL_DEBUG_PUB.disable_debug;
4545: END IF;
4546: WHEN FND_API.G_EXC_ERROR THEN

Line 4544: AHL_DEBUG_PUB.disable_debug;

4540: AHL_DEBUG_PUB.log_app_messages (
4541: x_msg_count, x_msg_data, 'ERROR' );
4542: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4543: -- Check if API is called in debug mode. If yes, disable debug.
4544: AHL_DEBUG_PUB.disable_debug;
4545: END IF;
4546: WHEN FND_API.G_EXC_ERROR THEN
4547: ROLLBACK TO Search_Scheduled_Visits;
4548: X_return_status := FND_API.G_RET_STS_ERROR;

Line 4555: AHL_DEBUG_PUB.log_app_messages (

4551: p_data => X_msg_data);
4552: IF G_DEBUG='Y' THEN
4553:
4554: -- Debug info.
4555: AHL_DEBUG_PUB.log_app_messages (
4556: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4557: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4558: -- Check if API is called in debug mode. If yes, disable debug.
4559: AHL_DEBUG_PUB.disable_debug;

Line 4557: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');

4553:
4554: -- Debug info.
4555: AHL_DEBUG_PUB.log_app_messages (
4556: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4557: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4558: -- Check if API is called in debug mode. If yes, disable debug.
4559: AHL_DEBUG_PUB.disable_debug;
4560: END IF;
4561: WHEN OTHERS THEN

Line 4559: AHL_DEBUG_PUB.disable_debug;

4555: AHL_DEBUG_PUB.log_app_messages (
4556: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4557: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4558: -- Check if API is called in debug mode. If yes, disable debug.
4559: AHL_DEBUG_PUB.disable_debug;
4560: END IF;
4561: WHEN OTHERS THEN
4562: ROLLBACK TO Search_Scheduled_Visits;
4563: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4576: AHL_DEBUG_PUB.log_app_messages (

4572: p_data => X_msg_data);
4573: IF G_DEBUG='Y' THEN
4574:
4575: -- Debug info.
4576: AHL_DEBUG_PUB.log_app_messages (
4577: x_msg_count, x_msg_data, 'SQL ERROR' );
4578: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4579: -- Check if API is called in debug mode. If yes, disable debug.
4580: AHL_DEBUG_PUB.disable_debug;

Line 4578: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');

4574:
4575: -- Debug info.
4576: AHL_DEBUG_PUB.log_app_messages (
4577: x_msg_count, x_msg_data, 'SQL ERROR' );
4578: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4579: -- Check if API is called in debug mode. If yes, disable debug.
4580: AHL_DEBUG_PUB.disable_debug;
4581: END IF;
4582:

Line 4580: AHL_DEBUG_PUB.disable_debug;

4576: AHL_DEBUG_PUB.log_app_messages (
4577: x_msg_count, x_msg_data, 'SQL ERROR' );
4578: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Search Scheduled Visits','+SPANT+');
4579: -- Check if API is called in debug mode. If yes, disable debug.
4580: AHL_DEBUG_PUB.disable_debug;
4581: END IF;
4582:
4583: END Search_Scheduled_Visits;
4584:

Line 4627: AHL_DEBUG_PUB.enable_debug;

4623: -- Standard Start of API savepoint
4624: SAVEPOINT get_visit_duration;
4625: -- Check if API is called in debug mode. If yes, enable debug.
4626: IF G_DEBUG='Y' THEN
4627: AHL_DEBUG_PUB.enable_debug;
4628: END IF;
4629: -- Debug info.
4630: IF G_DEBUG='Y' THEN
4631: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_duration','+SPSL+');

Line 4631: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_duration','+SPSL+');

4627: AHL_DEBUG_PUB.enable_debug;
4628: END IF;
4629: -- Debug info.
4630: IF G_DEBUG='Y' THEN
4631: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_duration','+SPSL+');
4632: END IF;
4633: -- Standard call to check for call compatibility.
4634: IF FND_API.to_boolean(l_init_msg_list)
4635: THEN

Line 4649: AHL_DEBUG_PUB.debug( 'inside get visit duration :'||p_visit_id);

4645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4646: END IF;
4647: --
4648: IF G_DEBUG='Y' THEN
4649: AHL_DEBUG_PUB.debug( 'inside get visit duration :'||p_visit_id);
4650: --
4651: AHL_DEBUG_PUB.debug( 'before call'||p_visit_id);
4652: END IF;
4653: --

Line 4651: AHL_DEBUG_PUB.debug( 'before call'||p_visit_id);

4647: --
4648: IF G_DEBUG='Y' THEN
4649: AHL_DEBUG_PUB.debug( 'inside get visit duration :'||p_visit_id);
4650: --
4651: AHL_DEBUG_PUB.debug( 'before call'||p_visit_id);
4652: END IF;
4653: --
4654: IF p_visit_id IS NOT NULL THEN
4655: --Visit Start date

Line 4669: AHL_DEBUG_PUB.debug( 'visit start time :'||to_char(l_visit_start_time, 'dd/mm/yy hh:mi:ss:'));

4665: END IF;
4666: END IF;
4667:
4668: IF G_DEBUG='Y' THEN
4669: AHL_DEBUG_PUB.debug( 'visit start time :'||to_char(l_visit_start_time, 'dd/mm/yy hh:mi:ss:'));
4670: AHL_DEBUG_PUB.debug( 'visit end time :'||to_char(l_visit_end_time,'dd/mm/yy hh:mi:ss:'));
4671: END IF;
4672:
4673: IF (l_visit_start_time IS NOT NULL AND l_visit_end_time IS NOT NULL) THEN

Line 4670: AHL_DEBUG_PUB.debug( 'visit end time :'||to_char(l_visit_end_time,'dd/mm/yy hh:mi:ss:'));

4666: END IF;
4667:
4668: IF G_DEBUG='Y' THEN
4669: AHL_DEBUG_PUB.debug( 'visit start time :'||to_char(l_visit_start_time, 'dd/mm/yy hh:mi:ss:'));
4670: AHL_DEBUG_PUB.debug( 'visit end time :'||to_char(l_visit_end_time,'dd/mm/yy hh:mi:ss:'));
4671: END IF;
4672:
4673: IF (l_visit_start_time IS NOT NULL AND l_visit_end_time IS NOT NULL) THEN
4674:

Line 4678: AHL_DEBUG_PUB.debug( 'l_visit time :'||to_char(l_visit_time, 'dd/mm/yy hh:mi:ss'));

4674:
4675: l_visit_time := l_visit_start_time;
4676:
4677: IF G_DEBUG='Y' THEN
4678: AHL_DEBUG_PUB.debug( 'l_visit time :'||to_char(l_visit_time, 'dd/mm/yy hh:mi:ss'));
4679: AHL_DEBUG_PUB.debug( 'l_visit end time :'||to_char(l_visit_end_time, 'dd/mm/yy hh:mi:ss'));
4680: END IF;
4681: l_due_time := l_visit_end_time - l_visit_time;
4682: IF G_DEBUG='Y' THEN

Line 4679: AHL_DEBUG_PUB.debug( 'l_visit end time :'||to_char(l_visit_end_time, 'dd/mm/yy hh:mi:ss'));

4675: l_visit_time := l_visit_start_time;
4676:
4677: IF G_DEBUG='Y' THEN
4678: AHL_DEBUG_PUB.debug( 'l_visit time :'||to_char(l_visit_time, 'dd/mm/yy hh:mi:ss'));
4679: AHL_DEBUG_PUB.debug( 'l_visit end time :'||to_char(l_visit_end_time, 'dd/mm/yy hh:mi:ss'));
4680: END IF;
4681: l_due_time := l_visit_end_time - l_visit_time;
4682: IF G_DEBUG='Y' THEN
4683: AHL_DEBUG_PUB.debug( 'l_due_time :'||l_due_time);

Line 4683: AHL_DEBUG_PUB.debug( 'l_due_time :'||l_due_time);

4679: AHL_DEBUG_PUB.debug( 'l_visit end time :'||to_char(l_visit_end_time, 'dd/mm/yy hh:mi:ss'));
4680: END IF;
4681: l_due_time := l_visit_end_time - l_visit_time;
4682: IF G_DEBUG='Y' THEN
4683: AHL_DEBUG_PUB.debug( 'l_due_time :'||l_due_time);
4684: END IF;
4685: /* Changes made by mpothuku on 01/24/05 for bug #4137916 */
4686: --l_duration := 24* trunc(l_due_time) + abs(to_char(l_visit_end_time, 'hh24')- to_char(l_visit_time, 'hh24'));
4687: l_duration := trunc(24 * l_due_time) ;

Line 4691: AHL_DEBUG_PUB.debug( 'l_due_time :'||l_duration);

4687: l_duration := trunc(24 * l_due_time) ;
4688:
4689: /* mpothuku End */
4690: IF G_DEBUG='Y' THEN
4691: AHL_DEBUG_PUB.debug( 'l_due_time :'||l_duration);
4692: END IF;
4693: --End of modification
4694:
4695: IF G_DEBUG='Y' THEN

Line 4697: AHL_DEBUG_PUB.debug( 'duration :'||l_duration);

4693: --End of modification
4694:
4695: IF G_DEBUG='Y' THEN
4696: --
4697: AHL_DEBUG_PUB.debug( 'duration :'||l_duration);
4698: --
4699: END IF;
4700: --
4701:

Line 4707: Ahl_Debug_Pub.debug( 'End of private api Get visit duration','+SPSL+');

4703: x_visit_duration := abs(l_duration);
4704: --
4705: -- Debug info
4706: IF G_DEBUG='Y' THEN
4707: Ahl_Debug_Pub.debug( 'End of private api Get visit duration','+SPSL+');
4708: -- Check if API is called in debug mode. If yes, disable debug.
4709: Ahl_Debug_Pub.disable_debug;
4710: END IF;
4711: EXCEPTION

Line 4709: Ahl_Debug_Pub.disable_debug;

4705: -- Debug info
4706: IF G_DEBUG='Y' THEN
4707: Ahl_Debug_Pub.debug( 'End of private api Get visit duration','+SPSL+');
4708: -- Check if API is called in debug mode. If yes, disable debug.
4709: Ahl_Debug_Pub.disable_debug;
4710: END IF;
4711: EXCEPTION
4712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4713: ROLLBACK TO get_visit_duration;

Line 4720: AHL_DEBUG_PUB.log_app_messages (

4716: p_count => x_msg_count,
4717: p_data => x_msg_data);
4718: IF G_DEBUG='Y' THEN
4719:
4720: AHL_DEBUG_PUB.log_app_messages (
4721: x_msg_count, x_msg_data, 'ERROR' );
4722: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit duration','+SPSL+');
4723: -- Check if API is called in debug mode. If yes, disable debug.
4724: AHL_DEBUG_PUB.disable_debug;

Line 4722: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit duration','+SPSL+');

4718: IF G_DEBUG='Y' THEN
4719:
4720: AHL_DEBUG_PUB.log_app_messages (
4721: x_msg_count, x_msg_data, 'ERROR' );
4722: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit duration','+SPSL+');
4723: -- Check if API is called in debug mode. If yes, disable debug.
4724: AHL_DEBUG_PUB.disable_debug;
4725: END IF;
4726:

Line 4724: AHL_DEBUG_PUB.disable_debug;

4720: AHL_DEBUG_PUB.log_app_messages (
4721: x_msg_count, x_msg_data, 'ERROR' );
4722: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit duration','+SPSL+');
4723: -- Check if API is called in debug mode. If yes, disable debug.
4724: AHL_DEBUG_PUB.disable_debug;
4725: END IF;
4726:
4727: WHEN FND_API.G_EXC_ERROR THEN
4728: ROLLBACK TO get_visit_duration;

Line 4736: AHL_DEBUG_PUB.log_app_messages (

4732: p_data => X_msg_data);
4733: IF G_DEBUG='Y' THEN
4734:
4735: -- Debug info.
4736: AHL_DEBUG_PUB.log_app_messages (
4737: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4738: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');
4739: -- Check if API is called in debug mode. If yes, disable debug.
4740: AHL_DEBUG_PUB.disable_debug;

Line 4738: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');

4734:
4735: -- Debug info.
4736: AHL_DEBUG_PUB.log_app_messages (
4737: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4738: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');
4739: -- Check if API is called in debug mode. If yes, disable debug.
4740: AHL_DEBUG_PUB.disable_debug;
4741: END IF;
4742:

Line 4740: AHL_DEBUG_PUB.disable_debug;

4736: AHL_DEBUG_PUB.log_app_messages (
4737: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4738: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');
4739: -- Check if API is called in debug mode. If yes, disable debug.
4740: AHL_DEBUG_PUB.disable_debug;
4741: END IF;
4742:
4743: WHEN OTHERS THEN
4744: ROLLBACK TO get_visit_duration;

Line 4758: AHL_DEBUG_PUB.log_app_messages (

4754: p_data => X_msg_data);
4755: IF G_DEBUG='Y' THEN
4756:
4757: -- Debug info.
4758: AHL_DEBUG_PUB.log_app_messages (
4759: x_msg_count, x_msg_data, 'SQL ERROR' );
4760: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');
4761: -- Check if API is called in debug mode. If yes, disable debug.
4762: AHL_DEBUG_PUB.disable_debug;

Line 4760: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');

4756:
4757: -- Debug info.
4758: AHL_DEBUG_PUB.log_app_messages (
4759: x_msg_count, x_msg_data, 'SQL ERROR' );
4760: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');
4761: -- Check if API is called in debug mode. If yes, disable debug.
4762: AHL_DEBUG_PUB.disable_debug;
4763: END IF;
4764: END Get_Visit_Duration;

Line 4762: AHL_DEBUG_PUB.disable_debug;

4758: AHL_DEBUG_PUB.log_app_messages (
4759: x_msg_count, x_msg_data, 'SQL ERROR' );
4760: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit duration','+SPSL+');
4761: -- Check if API is called in debug mode. If yes, disable debug.
4762: AHL_DEBUG_PUB.disable_debug;
4763: END IF;
4764: END Get_Visit_Duration;
4765: --
4766: PROCEDURE Get_Visit_End_Date

Line 4802: AHL_DEBUG_PUB.enable_debug;

4798: -- Standard Start of API savepoint
4799: SAVEPOINT get_visit_end_date;
4800: -- Check if API is called in debug mode. If yes, enable debug.
4801: IF G_DEBUG='Y' THEN
4802: AHL_DEBUG_PUB.enable_debug;
4803: END IF;
4804: -- Debug info.
4805: IF G_DEBUG='Y' THEN
4806: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_end_date','+SUAVL+');

Line 4806: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_end_date','+SUAVL+');

4802: AHL_DEBUG_PUB.enable_debug;
4803: END IF;
4804: -- Debug info.
4805: IF G_DEBUG='Y' THEN
4806: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_end_date','+SUAVL+');
4807: END IF;
4808: -- Standard call to check for call compatibility.
4809: IF FND_API.to_boolean(l_init_msg_list)
4810: THEN

Line 4824: AHL_DEBUG_PUB.debug( 'inside get visit end date :'||p_visit_id);

4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: END IF;
4822: --
4823: IF G_DEBUG='Y' THEN
4824: AHL_DEBUG_PUB.debug( 'inside get visit end date :'||p_visit_id);
4825: END IF;
4826: --
4827: IF (p_visit_id IS NOT NULL AND p_visit_id <> FND_API.G_MISS_NUM )THEN
4828: OPEN get_visit_cur(p_visit_id);

Line 4842: AHL_DEBUG_PUB.debug( 'after start date proc isit end date :'||l_visit_end_time);

4838: END IF;
4839:
4840: IF G_DEBUG='Y' THEN
4841: --
4842: AHL_DEBUG_PUB.debug( 'after start date proc isit end date :'||l_visit_end_time);
4843: AHL_DEBUG_PUB.debug( 'after start date proc isit start time :'||l_visit_start_time);
4844: END IF;
4845: --
4846: IF l_visit_end_time IS NOT NULL THEN

Line 4843: AHL_DEBUG_PUB.debug( 'after start date proc isit start time :'||l_visit_start_time);

4839:
4840: IF G_DEBUG='Y' THEN
4841: --
4842: AHL_DEBUG_PUB.debug( 'after start date proc isit end date :'||l_visit_end_time);
4843: AHL_DEBUG_PUB.debug( 'after start date proc isit start time :'||l_visit_start_time);
4844: END IF;
4845: --
4846: IF l_visit_end_time IS NOT NULL THEN
4847: x_visit_end_date := l_visit_end_time;

Line 4850: AHL_DEBUG_PUB.debug( 'x_visit_end_date:'||x_visit_end_date);

4846: IF l_visit_end_time IS NOT NULL THEN
4847: x_visit_end_date := l_visit_end_time;
4848: END IF;
4849: IF G_DEBUG='Y' THEN
4850: AHL_DEBUG_PUB.debug( 'x_visit_end_date:'||x_visit_end_date);
4851: END IF;
4852:
4853: --Standard check to count messages
4854: IF G_DEBUG='Y' THEN

Line 4856: Ahl_Debug_Pub.debug( 'End of private api Get visit end date','+SPSL+');

4852:
4853: --Standard check to count messages
4854: IF G_DEBUG='Y' THEN
4855: -- Debug info
4856: Ahl_Debug_Pub.debug( 'End of private api Get visit end date','+SPSL+');
4857: -- Check if API is called in debug mode. If yes, disable debug.
4858: Ahl_Debug_Pub.disable_debug;
4859: END IF;
4860:

Line 4858: Ahl_Debug_Pub.disable_debug;

4854: IF G_DEBUG='Y' THEN
4855: -- Debug info
4856: Ahl_Debug_Pub.debug( 'End of private api Get visit end date','+SPSL+');
4857: -- Check if API is called in debug mode. If yes, disable debug.
4858: Ahl_Debug_Pub.disable_debug;
4859: END IF;
4860:
4861: EXCEPTION
4862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4870: AHL_DEBUG_PUB.log_app_messages (

4866: p_count => x_msg_count,
4867: p_data => x_msg_data);
4868: IF G_DEBUG='Y' THEN
4869:
4870: AHL_DEBUG_PUB.log_app_messages (
4871: x_msg_count, x_msg_data, 'ERROR' );
4872: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit end date','+SPSL+');
4873: -- Check if API is called in debug mode. If yes, disable debug.
4874: AHL_DEBUG_PUB.disable_debug;

Line 4872: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit end date','+SPSL+');

4868: IF G_DEBUG='Y' THEN
4869:
4870: AHL_DEBUG_PUB.log_app_messages (
4871: x_msg_count, x_msg_data, 'ERROR' );
4872: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit end date','+SPSL+');
4873: -- Check if API is called in debug mode. If yes, disable debug.
4874: AHL_DEBUG_PUB.disable_debug;
4875: END IF;
4876:

Line 4874: AHL_DEBUG_PUB.disable_debug;

4870: AHL_DEBUG_PUB.log_app_messages (
4871: x_msg_count, x_msg_data, 'ERROR' );
4872: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit end date','+SPSL+');
4873: -- Check if API is called in debug mode. If yes, disable debug.
4874: AHL_DEBUG_PUB.disable_debug;
4875: END IF;
4876:
4877: WHEN FND_API.G_EXC_ERROR THEN
4878: ROLLBACK TO get_visit_end_date;

Line 4885: AHL_DEBUG_PUB.log_app_messages (

4881: p_count => x_msg_count,
4882: p_data => X_msg_data);
4883: IF G_DEBUG='Y' THEN
4884: -- Debug info.
4885: AHL_DEBUG_PUB.log_app_messages (
4886: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4887: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');
4888: -- Check if API is called in debug mode. If yes, disable debug.
4889: AHL_DEBUG_PUB.disable_debug;

Line 4887: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');

4883: IF G_DEBUG='Y' THEN
4884: -- Debug info.
4885: AHL_DEBUG_PUB.log_app_messages (
4886: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4887: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');
4888: -- Check if API is called in debug mode. If yes, disable debug.
4889: AHL_DEBUG_PUB.disable_debug;
4890: END IF;
4891:

Line 4889: AHL_DEBUG_PUB.disable_debug;

4885: AHL_DEBUG_PUB.log_app_messages (
4886: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
4887: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');
4888: -- Check if API is called in debug mode. If yes, disable debug.
4889: AHL_DEBUG_PUB.disable_debug;
4890: END IF;
4891:
4892: WHEN OTHERS THEN
4893: ROLLBACK TO get_visit_end_date;

Line 4907: AHL_DEBUG_PUB.log_app_messages (

4903: p_data => X_msg_data);
4904: IF G_DEBUG='Y' THEN
4905:
4906: -- Debug info.
4907: AHL_DEBUG_PUB.log_app_messages (
4908: x_msg_count, x_msg_data, 'SQL ERROR' );
4909: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');
4910: -- Check if API is called in debug mode. If yes, disable debug.
4911: AHL_DEBUG_PUB.disable_debug;

Line 4909: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');

4905:
4906: -- Debug info.
4907: AHL_DEBUG_PUB.log_app_messages (
4908: x_msg_count, x_msg_data, 'SQL ERROR' );
4909: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');
4910: -- Check if API is called in debug mode. If yes, disable debug.
4911: AHL_DEBUG_PUB.disable_debug;
4912: END IF;
4913:

Line 4911: AHL_DEBUG_PUB.disable_debug;

4907: AHL_DEBUG_PUB.log_app_messages (
4908: x_msg_count, x_msg_data, 'SQL ERROR' );
4909: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit end date','+SPSL+');
4910: -- Check if API is called in debug mode. If yes, disable debug.
4911: AHL_DEBUG_PUB.disable_debug;
4912: END IF;
4913:
4914: END Get_Visit_End_Date;
4915: ---

Line 4960: AHL_DEBUG_PUB.enable_debug;

4956: -- Standard Start of API savepoint
4957: SAVEPOINT get_visit_due_by_date;
4958: -- Check if API is called in debug mode. If yes, enable debug.
4959: IF G_DEBUG='Y' THEN
4960: AHL_DEBUG_PUB.enable_debug;
4961: -- Debug info.
4962: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_due_by_date','+SPSL+');
4963: --
4964: END IF;

Line 4962: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_due_by_date','+SPSL+');

4958: -- Check if API is called in debug mode. If yes, enable debug.
4959: IF G_DEBUG='Y' THEN
4960: AHL_DEBUG_PUB.enable_debug;
4961: -- Debug info.
4962: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt.get_visit_due_by_date','+SPSL+');
4963: --
4964: END IF;
4965: -- Standard call to check for call compatibility.
4966: IF FND_API.to_boolean(l_init_msg_list)

Line 4981: AHL_DEBUG_PUB.debug( 'inside visit id due by date :'||p_visit_id);

4977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4978: END IF;
4979: --
4980: IF G_DEBUG='Y' THEN
4981: AHL_DEBUG_PUB.debug( 'inside visit id due by date :'||p_visit_id);
4982: --
4983: END IF;
4984: OPEN c_visit(p_visit_id);
4985: FETCH c_visit INTO l_count1;

Line 5004: AHL_DEBUG_PUB.debug( 'inside visit due by date :'||x_due_by_date);

5000: ELSE
5001: CLOSE c_visit;
5002: END IF;
5003: IF G_DEBUG='Y' THEN
5004: AHL_DEBUG_PUB.debug( 'inside visit due by date :'||x_due_by_date);
5005: END IF;
5006:
5007: --Standard check to count messages
5008: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 5017: Ahl_Debug_Pub.debug( 'End of private api Get visit due by date','+SPSL+');

5013: RAISE Fnd_Api.G_EXC_ERROR;
5014: END IF;
5015: -- Debug info
5016: IF G_DEBUG='Y' THEN
5017: Ahl_Debug_Pub.debug( 'End of private api Get visit due by date','+SPSL+');
5018: -- Check if API is called in debug mode. If yes, disable debug.
5019: Ahl_Debug_Pub.disable_debug;
5020: END IF;
5021: EXCEPTION

Line 5019: Ahl_Debug_Pub.disable_debug;

5015: -- Debug info
5016: IF G_DEBUG='Y' THEN
5017: Ahl_Debug_Pub.debug( 'End of private api Get visit due by date','+SPSL+');
5018: -- Check if API is called in debug mode. If yes, disable debug.
5019: Ahl_Debug_Pub.disable_debug;
5020: END IF;
5021: EXCEPTION
5022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5023: ROLLBACK TO get_visit_due_by_date;

Line 5029: AHL_DEBUG_PUB.log_app_messages (

5025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5026: p_count => x_msg_count,
5027: p_data => x_msg_data);
5028: IF G_DEBUG='Y' THEN
5029: AHL_DEBUG_PUB.log_app_messages (
5030: x_msg_count, x_msg_data, 'ERROR' );
5031: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit due by date','+SPSL+');
5032: -- Check if API is called in debug mode. If yes, disable debug.
5033: AHL_DEBUG_PUB.disable_debug;

Line 5031: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit due by date','+SPSL+');

5027: p_data => x_msg_data);
5028: IF G_DEBUG='Y' THEN
5029: AHL_DEBUG_PUB.log_app_messages (
5030: x_msg_count, x_msg_data, 'ERROR' );
5031: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit due by date','+SPSL+');
5032: -- Check if API is called in debug mode. If yes, disable debug.
5033: AHL_DEBUG_PUB.disable_debug;
5034: END IF;
5035: WHEN FND_API.G_EXC_ERROR THEN

Line 5033: AHL_DEBUG_PUB.disable_debug;

5029: AHL_DEBUG_PUB.log_app_messages (
5030: x_msg_count, x_msg_data, 'ERROR' );
5031: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt.Get visit due by date','+SPSL+');
5032: -- Check if API is called in debug mode. If yes, disable debug.
5033: AHL_DEBUG_PUB.disable_debug;
5034: END IF;
5035: WHEN FND_API.G_EXC_ERROR THEN
5036: ROLLBACK TO get_visit_due_by_date;
5037: X_return_status := FND_API.G_RET_STS_ERROR;

Line 5044: AHL_DEBUG_PUB.log_app_messages (

5040: p_data => X_msg_data);
5041: IF G_DEBUG='Y' THEN
5042:
5043: -- Debug info.
5044: AHL_DEBUG_PUB.log_app_messages (
5045: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5046: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');
5047: -- Check if API is called in debug mode. If yes, disable debug.
5048: AHL_DEBUG_PUB.disable_debug;

Line 5046: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');

5042:
5043: -- Debug info.
5044: AHL_DEBUG_PUB.log_app_messages (
5045: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5046: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');
5047: -- Check if API is called in debug mode. If yes, disable debug.
5048: AHL_DEBUG_PUB.disable_debug;
5049: END IF;
5050: WHEN OTHERS THEN

Line 5048: AHL_DEBUG_PUB.disable_debug;

5044: AHL_DEBUG_PUB.log_app_messages (
5045: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5046: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');
5047: -- Check if API is called in debug mode. If yes, disable debug.
5048: AHL_DEBUG_PUB.disable_debug;
5049: END IF;
5050: WHEN OTHERS THEN
5051: ROLLBACK TO get_visit_due_by_date;
5052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5065: AHL_DEBUG_PUB.log_app_messages (

5061: p_data => X_msg_data);
5062: IF G_DEBUG='Y' THEN
5063:
5064: -- Debug info.
5065: AHL_DEBUG_PUB.log_app_messages (
5066: x_msg_count, x_msg_data, 'SQL ERROR' );
5067: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');
5068: -- Check if API is called in debug mode. If yes, disable debug.
5069: AHL_DEBUG_PUB.disable_debug;

Line 5067: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');

5063:
5064: -- Debug info.
5065: AHL_DEBUG_PUB.log_app_messages (
5066: x_msg_count, x_msg_data, 'SQL ERROR' );
5067: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');
5068: -- Check if API is called in debug mode. If yes, disable debug.
5069: AHL_DEBUG_PUB.disable_debug;
5070: END IF;
5071:

Line 5069: AHL_DEBUG_PUB.disable_debug;

5065: AHL_DEBUG_PUB.log_app_messages (
5066: x_msg_count, x_msg_data, 'SQL ERROR' );
5067: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit due by date','+SPSL+');
5068: -- Check if API is called in debug mode. If yes, disable debug.
5069: AHL_DEBUG_PUB.disable_debug;
5070: END IF;
5071:
5072: END Get_Visit_Due_by_Date;
5073: --

Line 5095: AHL_DEBUG_PUB.enable_debug;

5091: -- Standard Start of API savepoint
5092: SAVEPOINT Derive_visit_end_date;
5093: -- Check if API is called in debug mode. If yes, enable debug.
5094: IF G_DEBUG='Y' THEN
5095: AHL_DEBUG_PUB.enable_debug;
5096: --
5097: END IF;
5098: -- Debug info.
5099: IF G_DEBUG='Y' THEN

Line 5101: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');

5097: END IF;
5098: -- Debug info.
5099: IF G_DEBUG='Y' THEN
5100: --
5101: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');
5102: --
5103: END IF;
5104: -- Standard call to check for call compatibility.
5105: IF FND_API.to_boolean(l_init_msg_list)

Line 5120: AHL_DEBUG_PUB.debug( 'inside derieve visit end date :');

5116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5117: END IF;
5118: --
5119: IF G_DEBUG='Y' THEN
5120: AHL_DEBUG_PUB.debug( 'inside derieve visit end date :');
5121: END IF;
5122:
5123: IF (p_visits_end_date_tbl.COUNT > 0) THEN
5124: FOR i IN p_visits_end_date_tbl.FIRST..p_visits_end_date_tbl.LAST

Line 5149: Ahl_Debug_Pub.debug( 'End of private api Derive visit end date','+SPSL+');

5145: END IF;
5146:
5147: -- Debug info
5148: IF G_DEBUG='Y' THEN
5149: Ahl_Debug_Pub.debug( 'End of private api Derive visit end date','+SPSL+');
5150: -- Check if API is called in debug mode. If yes, disable debug.
5151: Ahl_Debug_Pub.disable_debug;
5152: END IF;
5153:

Line 5151: Ahl_Debug_Pub.disable_debug;

5147: -- Debug info
5148: IF G_DEBUG='Y' THEN
5149: Ahl_Debug_Pub.debug( 'End of private api Derive visit end date','+SPSL+');
5150: -- Check if API is called in debug mode. If yes, disable debug.
5151: Ahl_Debug_Pub.disable_debug;
5152: END IF;
5153:
5154: EXCEPTION
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5163: AHL_DEBUG_PUB.log_app_messages (

5159: p_count => x_msg_count,
5160: p_data => x_msg_data);
5161: IF G_DEBUG='Y' THEN
5162:
5163: AHL_DEBUG_PUB.log_app_messages (
5164: x_msg_count, x_msg_data, 'ERROR' );
5165: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
5166: -- Check if API is called in debug mode. If yes, disable debug.
5167: AHL_DEBUG_PUB.disable_debug;

Line 5165: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');

5161: IF G_DEBUG='Y' THEN
5162:
5163: AHL_DEBUG_PUB.log_app_messages (
5164: x_msg_count, x_msg_data, 'ERROR' );
5165: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
5166: -- Check if API is called in debug mode. If yes, disable debug.
5167: AHL_DEBUG_PUB.disable_debug;
5168: END IF;
5169:

Line 5167: AHL_DEBUG_PUB.disable_debug;

5163: AHL_DEBUG_PUB.log_app_messages (
5164: x_msg_count, x_msg_data, 'ERROR' );
5165: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
5166: -- Check if API is called in debug mode. If yes, disable debug.
5167: AHL_DEBUG_PUB.disable_debug;
5168: END IF;
5169:
5170: WHEN FND_API.G_EXC_ERROR THEN
5171: ROLLBACK TO Derive_visit_end_date;

Line 5179: AHL_DEBUG_PUB.log_app_messages (

5175: p_data => X_msg_data);
5176: IF G_DEBUG='Y' THEN
5177:
5178: -- Debug info.
5179: AHL_DEBUG_PUB.log_app_messages (
5180: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5181: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
5182: -- Check if API is called in debug mode. If yes, disable debug.
5183: AHL_DEBUG_PUB.disable_debug;

Line 5181: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');

5177:
5178: -- Debug info.
5179: AHL_DEBUG_PUB.log_app_messages (
5180: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5181: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
5182: -- Check if API is called in debug mode. If yes, disable debug.
5183: AHL_DEBUG_PUB.disable_debug;
5184: END IF;
5185:

Line 5183: AHL_DEBUG_PUB.disable_debug;

5179: AHL_DEBUG_PUB.log_app_messages (
5180: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
5181: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
5182: -- Check if API is called in debug mode. If yes, disable debug.
5183: AHL_DEBUG_PUB.disable_debug;
5184: END IF;
5185:
5186: WHEN OTHERS THEN
5187: ROLLBACK TO Derive_visit_end_date;

Line 5201: AHL_DEBUG_PUB.log_app_messages (

5197: p_data => X_msg_data);
5198: IF G_DEBUG='Y' THEN
5199:
5200: -- Debug info.
5201: AHL_DEBUG_PUB.log_app_messages (
5202: x_msg_count, x_msg_data, 'SQL ERROR' );
5203: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');
5204: -- Check if API is called in debug mode. If yes, disable debug.
5205: AHL_DEBUG_PUB.disable_debug;

Line 5203: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');

5199:
5200: -- Debug info.
5201: AHL_DEBUG_PUB.log_app_messages (
5202: x_msg_count, x_msg_data, 'SQL ERROR' );
5203: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');
5204: -- Check if API is called in debug mode. If yes, disable debug.
5205: AHL_DEBUG_PUB.disable_debug;
5206: END IF;
5207:

Line 5205: AHL_DEBUG_PUB.disable_debug;

5201: AHL_DEBUG_PUB.log_app_messages (
5202: x_msg_count, x_msg_data, 'SQL ERROR' );
5203: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Derive visit end date','+SPSL+');
5204: -- Check if API is called in debug mode. If yes, disable debug.
5205: AHL_DEBUG_PUB.disable_debug;
5206: END IF;
5207:
5208: END Derive_Visit_End_Date;
5209: --

Line 5489: AHL_DEBUG_PUB.enable_debug;

5485: -- Standard Start of API savepoint
5486: SAVEPOINT Get_visit_details;
5487: -- Check if API is called in debug mode. If yes, enable debug.
5488: IF G_DEBUG='Y' THEN
5489: AHL_DEBUG_PUB.enable_debug;
5490: END IF;
5491: -- Debug info.
5492: IF G_DEBUG='Y' THEN
5493: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');

Line 5493: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');

5489: AHL_DEBUG_PUB.enable_debug;
5490: END IF;
5491: -- Debug info.
5492: IF G_DEBUG='Y' THEN
5493: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');
5494: END IF;
5495: -- Standard call to check for call compatibility.
5496: IF FND_API.to_boolean(p_init_msg_list)
5497: THEN

Line 5512: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);

5508: END IF;
5509: --
5510: --
5511: IF G_DEBUG='Y' THEN
5512: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);
5513: AHL_DEBUG_PUB.debug( 'get visit details ONA:'||l_search_visits_Rec.org_name);
5514: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5515: AHL_DEBUG_PUB.debug( 'inside visit detailsSP :'||l_search_visits_Rec.space_id);
5516: AHL_DEBUG_PUB.debug( 'inside visit detailsITEM :'||l_search_visits_Rec.item_id);

Line 5513: AHL_DEBUG_PUB.debug( 'get visit details ONA:'||l_search_visits_Rec.org_name);

5509: --
5510: --
5511: IF G_DEBUG='Y' THEN
5512: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);
5513: AHL_DEBUG_PUB.debug( 'get visit details ONA:'||l_search_visits_Rec.org_name);
5514: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5515: AHL_DEBUG_PUB.debug( 'inside visit detailsSP :'||l_search_visits_Rec.space_id);
5516: AHL_DEBUG_PUB.debug( 'inside visit detailsITEM :'||l_search_visits_Rec.item_id);
5517: AHL_DEBUG_PUB.debug( 'inside visit detailsITEMDES :'||l_search_visits_Rec.item_description);

Line 5514: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);

5510: --
5511: IF G_DEBUG='Y' THEN
5512: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);
5513: AHL_DEBUG_PUB.debug( 'get visit details ONA:'||l_search_visits_Rec.org_name);
5514: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5515: AHL_DEBUG_PUB.debug( 'inside visit detailsSP :'||l_search_visits_Rec.space_id);
5516: AHL_DEBUG_PUB.debug( 'inside visit detailsITEM :'||l_search_visits_Rec.item_id);
5517: AHL_DEBUG_PUB.debug( 'inside visit detailsITEMDES :'||l_search_visits_Rec.item_description);
5518: END IF;

Line 5515: AHL_DEBUG_PUB.debug( 'inside visit detailsSP :'||l_search_visits_Rec.space_id);

5511: IF G_DEBUG='Y' THEN
5512: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);
5513: AHL_DEBUG_PUB.debug( 'get visit details ONA:'||l_search_visits_Rec.org_name);
5514: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5515: AHL_DEBUG_PUB.debug( 'inside visit detailsSP :'||l_search_visits_Rec.space_id);
5516: AHL_DEBUG_PUB.debug( 'inside visit detailsITEM :'||l_search_visits_Rec.item_id);
5517: AHL_DEBUG_PUB.debug( 'inside visit detailsITEMDES :'||l_search_visits_Rec.item_description);
5518: END IF;
5519: -- Get org id from org name or vice versa

Line 5516: AHL_DEBUG_PUB.debug( 'inside visit detailsITEM :'||l_search_visits_Rec.item_id);

5512: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);
5513: AHL_DEBUG_PUB.debug( 'get visit details ONA:'||l_search_visits_Rec.org_name);
5514: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5515: AHL_DEBUG_PUB.debug( 'inside visit detailsSP :'||l_search_visits_Rec.space_id);
5516: AHL_DEBUG_PUB.debug( 'inside visit detailsITEM :'||l_search_visits_Rec.item_id);
5517: AHL_DEBUG_PUB.debug( 'inside visit detailsITEMDES :'||l_search_visits_Rec.item_description);
5518: END IF;
5519: -- Get org id from org name or vice versa
5520: IF (l_search_visits_Rec.ORG_ID IS NOT NULL AND

Line 5517: AHL_DEBUG_PUB.debug( 'inside visit detailsITEMDES :'||l_search_visits_Rec.item_description);

5513: AHL_DEBUG_PUB.debug( 'get visit details ONA:'||l_search_visits_Rec.org_name);
5514: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5515: AHL_DEBUG_PUB.debug( 'inside visit detailsSP :'||l_search_visits_Rec.space_id);
5516: AHL_DEBUG_PUB.debug( 'inside visit detailsITEM :'||l_search_visits_Rec.item_id);
5517: AHL_DEBUG_PUB.debug( 'inside visit detailsITEMDES :'||l_search_visits_Rec.item_description);
5518: END IF;
5519: -- Get org id from org name or vice versa
5520: IF (l_search_visits_Rec.ORG_ID IS NOT NULL AND
5521: l_search_visits_Rec.ORG_ID <> FND_API.G_MISS_NUM) OR

Line 5540: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);

5536: CLOSE l_org_id_cur;
5537: --
5538: END IF;
5539: IF G_DEBUG='Y' THEN
5540: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);
5541: AHL_DEBUG_PUB.debug( 'get visit details DNA:'||l_search_visits_Rec.department_name);
5542: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5543: END IF;
5544:

Line 5541: AHL_DEBUG_PUB.debug( 'get visit details DNA:'||l_search_visits_Rec.department_name);

5537: --
5538: END IF;
5539: IF G_DEBUG='Y' THEN
5540: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);
5541: AHL_DEBUG_PUB.debug( 'get visit details DNA:'||l_search_visits_Rec.department_name);
5542: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5543: END IF;
5544:
5545: -- Get Dept id from dept name or vice versa

Line 5542: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);

5538: END IF;
5539: IF G_DEBUG='Y' THEN
5540: AHL_DEBUG_PUB.debug( 'get visit details DID:'||l_search_visits_Rec.department_id);
5541: AHL_DEBUG_PUB.debug( 'get visit details DNA:'||l_search_visits_Rec.department_name);
5542: AHL_DEBUG_PUB.debug( 'get visit details OID:'||l_search_visits_Rec.org_id);
5543: END IF;
5544:
5545: -- Get Dept id from dept name or vice versa
5546: IF ((l_search_visits_Rec.DEPARTMENT_ID IS NOT NULL AND

Line 5718: AHL_DEBUG_PUB.debug( ' SPACEID:'||l_search_visits_Rec.space_id);

5714: l_start_period := trunc(l_search_visits_Rec.start_period);
5715: l_end_period := trunc(l_search_visits_Rec.end_period);
5716: --
5717: IF G_DEBUG='Y' THEN
5718: AHL_DEBUG_PUB.debug( ' SPACEID:'||l_search_visits_Rec.space_id);
5719: AHL_DEBUG_PUB.debug( ' ORGID:'||l_search_visits_Rec.org_id);
5720: AHL_DEBUG_PUB.debug( ' DEPTID:'||l_search_visits_Rec.department_id);
5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);
5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);

Line 5719: AHL_DEBUG_PUB.debug( ' ORGID:'||l_search_visits_Rec.org_id);

5715: l_end_period := trunc(l_search_visits_Rec.end_period);
5716: --
5717: IF G_DEBUG='Y' THEN
5718: AHL_DEBUG_PUB.debug( ' SPACEID:'||l_search_visits_Rec.space_id);
5719: AHL_DEBUG_PUB.debug( ' ORGID:'||l_search_visits_Rec.org_id);
5720: AHL_DEBUG_PUB.debug( ' DEPTID:'||l_search_visits_Rec.department_id);
5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);
5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);
5723: AHL_DEBUG_PUB.debug( ' PLANID:'||l_search_visits_Rec.plan_id);

Line 5720: AHL_DEBUG_PUB.debug( ' DEPTID:'||l_search_visits_Rec.department_id);

5716: --
5717: IF G_DEBUG='Y' THEN
5718: AHL_DEBUG_PUB.debug( ' SPACEID:'||l_search_visits_Rec.space_id);
5719: AHL_DEBUG_PUB.debug( ' ORGID:'||l_search_visits_Rec.org_id);
5720: AHL_DEBUG_PUB.debug( ' DEPTID:'||l_search_visits_Rec.department_id);
5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);
5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);
5723: AHL_DEBUG_PUB.debug( ' PLANID:'||l_search_visits_Rec.plan_id);
5724: AHL_DEBUG_PUB.debug( 'STARTPERIOD:'||l_start_period);

Line 5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);

5717: IF G_DEBUG='Y' THEN
5718: AHL_DEBUG_PUB.debug( ' SPACEID:'||l_search_visits_Rec.space_id);
5719: AHL_DEBUG_PUB.debug( ' ORGID:'||l_search_visits_Rec.org_id);
5720: AHL_DEBUG_PUB.debug( ' DEPTID:'||l_search_visits_Rec.department_id);
5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);
5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);
5723: AHL_DEBUG_PUB.debug( ' PLANID:'||l_search_visits_Rec.plan_id);
5724: AHL_DEBUG_PUB.debug( 'STARTPERIOD:'||l_start_period);
5725: AHL_DEBUG_PUB.debug( 'ENDPERIOD:'||l_end_period);

Line 5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);

5718: AHL_DEBUG_PUB.debug( ' SPACEID:'||l_search_visits_Rec.space_id);
5719: AHL_DEBUG_PUB.debug( ' ORGID:'||l_search_visits_Rec.org_id);
5720: AHL_DEBUG_PUB.debug( ' DEPTID:'||l_search_visits_Rec.department_id);
5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);
5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);
5723: AHL_DEBUG_PUB.debug( ' PLANID:'||l_search_visits_Rec.plan_id);
5724: AHL_DEBUG_PUB.debug( 'STARTPERIOD:'||l_start_period);
5725: AHL_DEBUG_PUB.debug( 'ENDPERIOD:'||l_end_period);
5726: END IF;

Line 5723: AHL_DEBUG_PUB.debug( ' PLANID:'||l_search_visits_Rec.plan_id);

5719: AHL_DEBUG_PUB.debug( ' ORGID:'||l_search_visits_Rec.org_id);
5720: AHL_DEBUG_PUB.debug( ' DEPTID:'||l_search_visits_Rec.department_id);
5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);
5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);
5723: AHL_DEBUG_PUB.debug( ' PLANID:'||l_search_visits_Rec.plan_id);
5724: AHL_DEBUG_PUB.debug( 'STARTPERIOD:'||l_start_period);
5725: AHL_DEBUG_PUB.debug( 'ENDPERIOD:'||l_end_period);
5726: END IF;
5727: ----------------- To get the visit If space id is available

Line 5724: AHL_DEBUG_PUB.debug( 'STARTPERIOD:'||l_start_period);

5720: AHL_DEBUG_PUB.debug( ' DEPTID:'||l_search_visits_Rec.department_id);
5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);
5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);
5723: AHL_DEBUG_PUB.debug( ' PLANID:'||l_search_visits_Rec.plan_id);
5724: AHL_DEBUG_PUB.debug( 'STARTPERIOD:'||l_start_period);
5725: AHL_DEBUG_PUB.debug( 'ENDPERIOD:'||l_end_period);
5726: END IF;
5727: ----------------- To get the visit If space id is available
5728: IF l_search_visits_Rec.SPACE_ID IS NOT NULL

Line 5725: AHL_DEBUG_PUB.debug( 'ENDPERIOD:'||l_end_period);

5721: AHL_DEBUG_PUB.debug( ' VISITTYPE:'||l_search_visits_Rec.visit_type_code);
5722: AHL_DEBUG_PUB.debug( ' ITEMID:'||l_search_visits_Rec.item_id);
5723: AHL_DEBUG_PUB.debug( ' PLANID:'||l_search_visits_Rec.plan_id);
5724: AHL_DEBUG_PUB.debug( 'STARTPERIOD:'||l_start_period);
5725: AHL_DEBUG_PUB.debug( 'ENDPERIOD:'||l_end_period);
5726: END IF;
5727: ----------------- To get the visit If space id is available
5728: IF l_search_visits_Rec.SPACE_ID IS NOT NULL
5729: THEN

Line 5751: AHL_DEBUG_PUB.debug( 'after plan flag y visit id:'||l_get_visit_detail_rec.visit_id ||'-'||i);

5747:
5748: IF l_plan_flag = 'Y' THEN
5749:
5750: IF G_DEBUG='Y' THEN
5751: AHL_DEBUG_PUB.debug( 'after plan flag y visit id:'||l_get_visit_detail_rec.visit_id ||'-'||i);
5752: AHL_DEBUG_PUB.debug( 'after plan flag y start period:'||l_start_period ||'-'||i);
5753: AHL_DEBUG_PUB.debug( 'after plan flag y end period:'||l_end_period ||'-'||i);
5754: AHL_DEBUG_PUB.debug( 'after plan flag y visit end date:'||l_visit_end_date ||'-'||i);
5755: AHL_DEBUG_PUB.debug( 'after plan flag y visit start date:'||l_get_visit_detail_rec.start_date_time ||'-'||i);

Line 5752: AHL_DEBUG_PUB.debug( 'after plan flag y start period:'||l_start_period ||'-'||i);

5748: IF l_plan_flag = 'Y' THEN
5749:
5750: IF G_DEBUG='Y' THEN
5751: AHL_DEBUG_PUB.debug( 'after plan flag y visit id:'||l_get_visit_detail_rec.visit_id ||'-'||i);
5752: AHL_DEBUG_PUB.debug( 'after plan flag y start period:'||l_start_period ||'-'||i);
5753: AHL_DEBUG_PUB.debug( 'after plan flag y end period:'||l_end_period ||'-'||i);
5754: AHL_DEBUG_PUB.debug( 'after plan flag y visit end date:'||l_visit_end_date ||'-'||i);
5755: AHL_DEBUG_PUB.debug( 'after plan flag y visit start date:'||l_get_visit_detail_rec.start_date_time ||'-'||i);
5756:

Line 5753: AHL_DEBUG_PUB.debug( 'after plan flag y end period:'||l_end_period ||'-'||i);

5749:
5750: IF G_DEBUG='Y' THEN
5751: AHL_DEBUG_PUB.debug( 'after plan flag y visit id:'||l_get_visit_detail_rec.visit_id ||'-'||i);
5752: AHL_DEBUG_PUB.debug( 'after plan flag y start period:'||l_start_period ||'-'||i);
5753: AHL_DEBUG_PUB.debug( 'after plan flag y end period:'||l_end_period ||'-'||i);
5754: AHL_DEBUG_PUB.debug( 'after plan flag y visit end date:'||l_visit_end_date ||'-'||i);
5755: AHL_DEBUG_PUB.debug( 'after plan flag y visit start date:'||l_get_visit_detail_rec.start_date_time ||'-'||i);
5756:
5757: END IF;

Line 5754: AHL_DEBUG_PUB.debug( 'after plan flag y visit end date:'||l_visit_end_date ||'-'||i);

5750: IF G_DEBUG='Y' THEN
5751: AHL_DEBUG_PUB.debug( 'after plan flag y visit id:'||l_get_visit_detail_rec.visit_id ||'-'||i);
5752: AHL_DEBUG_PUB.debug( 'after plan flag y start period:'||l_start_period ||'-'||i);
5753: AHL_DEBUG_PUB.debug( 'after plan flag y end period:'||l_end_period ||'-'||i);
5754: AHL_DEBUG_PUB.debug( 'after plan flag y visit end date:'||l_visit_end_date ||'-'||i);
5755: AHL_DEBUG_PUB.debug( 'after plan flag y visit start date:'||l_get_visit_detail_rec.start_date_time ||'-'||i);
5756:
5757: END IF;
5758:

Line 5755: AHL_DEBUG_PUB.debug( 'after plan flag y visit start date:'||l_get_visit_detail_rec.start_date_time ||'-'||i);

5751: AHL_DEBUG_PUB.debug( 'after plan flag y visit id:'||l_get_visit_detail_rec.visit_id ||'-'||i);
5752: AHL_DEBUG_PUB.debug( 'after plan flag y start period:'||l_start_period ||'-'||i);
5753: AHL_DEBUG_PUB.debug( 'after plan flag y end period:'||l_end_period ||'-'||i);
5754: AHL_DEBUG_PUB.debug( 'after plan flag y visit end date:'||l_visit_end_date ||'-'||i);
5755: AHL_DEBUG_PUB.debug( 'after plan flag y visit start date:'||l_get_visit_detail_rec.start_date_time ||'-'||i);
5756:
5757: END IF;
5758:
5759: OPEN visit_wd_detail_cur(l_search_visits_Rec.plan_id,

Line 5810: AHL_DEBUG_PUB.debug( 'visit details start period:'||l_start_period||'-'||i);

5806: FETCH get_visit_detail_cur INTO l_get_visit_detail_rec;
5807: EXIT WHEN get_visit_detail_cur%NOTFOUND;
5808: IF get_visit_detail_cur%FOUND THEN
5809: IF G_DEBUG='Y' THEN
5810: AHL_DEBUG_PUB.debug( 'visit details start period:'||l_start_period||'-'||i);
5811: AHL_DEBUG_PUB.debug( 'visit details end period:'||l_end_period||'-'||i);
5812: END IF;
5813: IF l_get_visit_detail_rec.close_date_time IS NOT NULL THEN
5814: l_visit_end_date := l_get_visit_detail_rec.close_date_time;

Line 5811: AHL_DEBUG_PUB.debug( 'visit details end period:'||l_end_period||'-'||i);

5807: EXIT WHEN get_visit_detail_cur%NOTFOUND;
5808: IF get_visit_detail_cur%FOUND THEN
5809: IF G_DEBUG='Y' THEN
5810: AHL_DEBUG_PUB.debug( 'visit details start period:'||l_start_period||'-'||i);
5811: AHL_DEBUG_PUB.debug( 'visit details end period:'||l_end_period||'-'||i);
5812: END IF;
5813: IF l_get_visit_detail_rec.close_date_time IS NOT NULL THEN
5814: l_visit_end_date := l_get_visit_detail_rec.close_date_time;
5815: ELSE

Line 5892: AHL_DEBUG_PUB.debug( 'visit number:'||l_visit_wd1_detail_rec.visit_number);

5888: END IF;
5889: CLOSE visit_wd_detail_cur;
5890: --
5891: IF G_DEBUG='Y' THEN
5892: AHL_DEBUG_PUB.debug( 'visit number:'||l_visit_wd1_detail_rec.visit_number);
5893: END IF;
5894: --
5895: END IF;
5896: i := i+1;

Line 5924: AHL_DEBUG_PUB.debug( 'after plan flag y dept.plan_id:'||l_search_visits_Rec.plan_id ||'-'||i);

5920:
5921: IF l_plan_flag = 'Y' THEN
5922: --
5923: IF G_DEBUG='Y' THEN
5924: AHL_DEBUG_PUB.debug( 'after plan flag y dept.plan_id:'||l_search_visits_Rec.plan_id ||'-'||i);
5925: AHL_DEBUG_PUB.debug( 'after plan flag y dept.visit_id:'||l_visit_dept_rec.visit_id ||'-'||i);
5926: AHL_DEBUG_PUB.debug( 'after plan flag y dept display start_period:'||l_start_period ||'-'||i);
5927: AHL_DEBUG_PUB.debug( 'after plan flag y dept diaplay end_period:'||l_end_period ||'-'||i);
5928: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit_end_date:'||l_visit_end_date ||'-'||i);

Line 5925: AHL_DEBUG_PUB.debug( 'after plan flag y dept.visit_id:'||l_visit_dept_rec.visit_id ||'-'||i);

5921: IF l_plan_flag = 'Y' THEN
5922: --
5923: IF G_DEBUG='Y' THEN
5924: AHL_DEBUG_PUB.debug( 'after plan flag y dept.plan_id:'||l_search_visits_Rec.plan_id ||'-'||i);
5925: AHL_DEBUG_PUB.debug( 'after plan flag y dept.visit_id:'||l_visit_dept_rec.visit_id ||'-'||i);
5926: AHL_DEBUG_PUB.debug( 'after plan flag y dept display start_period:'||l_start_period ||'-'||i);
5927: AHL_DEBUG_PUB.debug( 'after plan flag y dept diaplay end_period:'||l_end_period ||'-'||i);
5928: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit_end_date:'||l_visit_end_date ||'-'||i);
5929: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit start_date:'||l_visit_dept_rec.start_date_time ||'-'||i);

Line 5926: AHL_DEBUG_PUB.debug( 'after plan flag y dept display start_period:'||l_start_period ||'-'||i);

5922: --
5923: IF G_DEBUG='Y' THEN
5924: AHL_DEBUG_PUB.debug( 'after plan flag y dept.plan_id:'||l_search_visits_Rec.plan_id ||'-'||i);
5925: AHL_DEBUG_PUB.debug( 'after plan flag y dept.visit_id:'||l_visit_dept_rec.visit_id ||'-'||i);
5926: AHL_DEBUG_PUB.debug( 'after plan flag y dept display start_period:'||l_start_period ||'-'||i);
5927: AHL_DEBUG_PUB.debug( 'after plan flag y dept diaplay end_period:'||l_end_period ||'-'||i);
5928: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit_end_date:'||l_visit_end_date ||'-'||i);
5929: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit start_date:'||l_visit_dept_rec.start_date_time ||'-'||i);
5930: END IF;

Line 5927: AHL_DEBUG_PUB.debug( 'after plan flag y dept diaplay end_period:'||l_end_period ||'-'||i);

5923: IF G_DEBUG='Y' THEN
5924: AHL_DEBUG_PUB.debug( 'after plan flag y dept.plan_id:'||l_search_visits_Rec.plan_id ||'-'||i);
5925: AHL_DEBUG_PUB.debug( 'after plan flag y dept.visit_id:'||l_visit_dept_rec.visit_id ||'-'||i);
5926: AHL_DEBUG_PUB.debug( 'after plan flag y dept display start_period:'||l_start_period ||'-'||i);
5927: AHL_DEBUG_PUB.debug( 'after plan flag y dept diaplay end_period:'||l_end_period ||'-'||i);
5928: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit_end_date:'||l_visit_end_date ||'-'||i);
5929: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit start_date:'||l_visit_dept_rec.start_date_time ||'-'||i);
5930: END IF;
5931:

Line 5928: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit_end_date:'||l_visit_end_date ||'-'||i);

5924: AHL_DEBUG_PUB.debug( 'after plan flag y dept.plan_id:'||l_search_visits_Rec.plan_id ||'-'||i);
5925: AHL_DEBUG_PUB.debug( 'after plan flag y dept.visit_id:'||l_visit_dept_rec.visit_id ||'-'||i);
5926: AHL_DEBUG_PUB.debug( 'after plan flag y dept display start_period:'||l_start_period ||'-'||i);
5927: AHL_DEBUG_PUB.debug( 'after plan flag y dept diaplay end_period:'||l_end_period ||'-'||i);
5928: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit_end_date:'||l_visit_end_date ||'-'||i);
5929: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit start_date:'||l_visit_dept_rec.start_date_time ||'-'||i);
5930: END IF;
5931:
5932: --

Line 5929: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit start_date:'||l_visit_dept_rec.start_date_time ||'-'||i);

5925: AHL_DEBUG_PUB.debug( 'after plan flag y dept.visit_id:'||l_visit_dept_rec.visit_id ||'-'||i);
5926: AHL_DEBUG_PUB.debug( 'after plan flag y dept display start_period:'||l_start_period ||'-'||i);
5927: AHL_DEBUG_PUB.debug( 'after plan flag y dept diaplay end_period:'||l_end_period ||'-'||i);
5928: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit_end_date:'||l_visit_end_date ||'-'||i);
5929: AHL_DEBUG_PUB.debug( 'after plan flag y dept visit start_date:'||l_visit_dept_rec.start_date_time ||'-'||i);
5930: END IF;
5931:
5932: --
5933:

Line 5978: AHL_DEBUG_PUB.debug( 'visit details start period:'||l_start_period||'-'||i);

5974: FETCH get_visit_dept_cur INTO l_get_visit_dept_rec;
5975: EXIT WHEN get_visit_dept_cur%NOTFOUND;
5976: IF get_visit_dept_cur%FOUND THEN
5977: IF G_DEBUG='Y' THEN
5978: AHL_DEBUG_PUB.debug( 'visit details start period:'||l_start_period||'-'||i);
5979: AHL_DEBUG_PUB.debug( 'visit details end period:'||l_end_period||'-'||i);
5980: END IF;
5981:
5982: IF l_get_visit_dept_rec.close_date_time IS NOT NULL THEN

Line 5979: AHL_DEBUG_PUB.debug( 'visit details end period:'||l_end_period||'-'||i);

5975: EXIT WHEN get_visit_dept_cur%NOTFOUND;
5976: IF get_visit_dept_cur%FOUND THEN
5977: IF G_DEBUG='Y' THEN
5978: AHL_DEBUG_PUB.debug( 'visit details start period:'||l_start_period||'-'||i);
5979: AHL_DEBUG_PUB.debug( 'visit details end period:'||l_end_period||'-'||i);
5980: END IF;
5981:
5982: IF l_get_visit_dept_rec.close_date_time IS NOT NULL THEN
5983: l_visit_end_date := l_get_visit_dept_rec.close_date_time;

Line 6043: AHL_DEBUG_PUB.debug( 'visit number:'||l_visit_wd1_detail_rec.visit_number);

6039: END IF;
6040: CLOSE visit_wd_detail_cur;
6041: --
6042: IF G_DEBUG='Y' THEN
6043: AHL_DEBUG_PUB.debug( 'visit number:'||l_visit_wd1_detail_rec.visit_number);
6044: END IF;
6045: --
6046: END IF;
6047: i := i+1;

Line 6056: AHL_DEBUG_PUB.debug( 'total records:'||x_visit_details_tbl.count);

6052: END IF;
6053: -----
6054:
6055: IF G_DEBUG='Y' THEN
6056: AHL_DEBUG_PUB.debug( 'total records:'||x_visit_details_tbl.count);
6057: END IF;
6058:
6059: --Standard check to count messages
6060: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 6069: Ahl_Debug_Pub.debug( 'End of private api Get visit details','+SPSL+');

6065: RAISE Fnd_Api.G_EXC_ERROR;
6066: END IF;
6067: -- Debug info
6068: IF G_DEBUG='Y' THEN
6069: Ahl_Debug_Pub.debug( 'End of private api Get visit details','+SPSL+');
6070: -- Check if API is called in debug mode. If yes, disable debug.
6071: Ahl_Debug_Pub.disable_debug;
6072: --
6073: END IF;

Line 6071: Ahl_Debug_Pub.disable_debug;

6067: -- Debug info
6068: IF G_DEBUG='Y' THEN
6069: Ahl_Debug_Pub.debug( 'End of private api Get visit details','+SPSL+');
6070: -- Check if API is called in debug mode. If yes, disable debug.
6071: Ahl_Debug_Pub.disable_debug;
6072: --
6073: END IF;
6074:
6075: EXCEPTION

Line 6084: AHL_DEBUG_PUB.log_app_messages (

6080: p_count => x_msg_count,
6081: p_data => x_msg_data);
6082: IF G_DEBUG='Y' THEN
6083:
6084: AHL_DEBUG_PUB.log_app_messages (
6085: x_msg_count, x_msg_data, 'ERROR' );
6086: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit details','+SPSL+');
6087: -- Check if API is called in debug mode. If yes, disable debug.
6088: AHL_DEBUG_PUB.disable_debug;

Line 6086: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit details','+SPSL+');

6082: IF G_DEBUG='Y' THEN
6083:
6084: AHL_DEBUG_PUB.log_app_messages (
6085: x_msg_count, x_msg_data, 'ERROR' );
6086: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit details','+SPSL+');
6087: -- Check if API is called in debug mode. If yes, disable debug.
6088: AHL_DEBUG_PUB.disable_debug;
6089: END IF;
6090:

Line 6088: AHL_DEBUG_PUB.disable_debug;

6084: AHL_DEBUG_PUB.log_app_messages (
6085: x_msg_count, x_msg_data, 'ERROR' );
6086: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Get visit details','+SPSL+');
6087: -- Check if API is called in debug mode. If yes, disable debug.
6088: AHL_DEBUG_PUB.disable_debug;
6089: END IF;
6090:
6091: WHEN FND_API.G_EXC_ERROR THEN
6092: ROLLBACK TO Get_visit_details;

Line 6100: AHL_DEBUG_PUB.log_app_messages (

6096: p_data => X_msg_data);
6097: IF G_DEBUG='Y' THEN
6098:
6099: -- Debug info.
6100: AHL_DEBUG_PUB.log_app_messages (
6101: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
6102: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
6103: -- Check if API is called in debug mode. If yes, disable debug.
6104: AHL_DEBUG_PUB.disable_debug;

Line 6102: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');

6098:
6099: -- Debug info.
6100: AHL_DEBUG_PUB.log_app_messages (
6101: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
6102: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
6103: -- Check if API is called in debug mode. If yes, disable debug.
6104: AHL_DEBUG_PUB.disable_debug;
6105: END IF;
6106: WHEN OTHERS THEN

Line 6104: AHL_DEBUG_PUB.disable_debug;

6100: AHL_DEBUG_PUB.log_app_messages (
6101: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
6102: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt. Derive visit end date','+SPSL+');
6103: -- Check if API is called in debug mode. If yes, disable debug.
6104: AHL_DEBUG_PUB.disable_debug;
6105: END IF;
6106: WHEN OTHERS THEN
6107: ROLLBACK TO Get_visit_details;
6108: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6121: AHL_DEBUG_PUB.log_app_messages (

6117: p_data => X_msg_data);
6118: IF G_DEBUG='Y' THEN
6119:
6120: -- Debug info.
6121: AHL_DEBUG_PUB.log_app_messages (
6122: x_msg_count, x_msg_data, 'SQL ERROR' );
6123: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');
6124: -- Check if API is called in debug mode. If yes, disable debug.
6125: AHL_DEBUG_PUB.disable_debug;

Line 6123: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');

6119:
6120: -- Debug info.
6121: AHL_DEBUG_PUB.log_app_messages (
6122: x_msg_count, x_msg_data, 'SQL ERROR' );
6123: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');
6124: -- Check if API is called in debug mode. If yes, disable debug.
6125: AHL_DEBUG_PUB.disable_debug;
6126:
6127: END IF;

Line 6125: AHL_DEBUG_PUB.disable_debug;

6121: AHL_DEBUG_PUB.log_app_messages (
6122: x_msg_count, x_msg_data, 'SQL ERROR' );
6123: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_schedule_pvt Get visit details','+SPSL+');
6124: -- Check if API is called in debug mode. If yes, disable debug.
6125: AHL_DEBUG_PUB.disable_debug;
6126:
6127: END IF;
6128: END Get_Visit_Details;
6129: --To Get derived end date

Line 6153: AHL_DEBUG_PUB.enable_debug;

6149: --
6150: BEGIN
6151: --
6152: IF G_DEBUG='Y' THEN
6153: AHL_DEBUG_PUB.enable_debug;
6154: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get derived end date','+SPSL+');
6155: END IF;
6156: --
6157: IF (p_visit_id IS NOT NULL AND p_visit_id <> FND_API.G_MISS_NUM )THEN

Line 6154: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get derived end date','+SPSL+');

6150: BEGIN
6151: --
6152: IF G_DEBUG='Y' THEN
6153: AHL_DEBUG_PUB.enable_debug;
6154: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_space_schedule_pvt Get derived end date','+SPSL+');
6155: END IF;
6156: --
6157: IF (p_visit_id IS NOT NULL AND p_visit_id <> FND_API.G_MISS_NUM )THEN
6158: OPEN get_visit_cur(p_visit_id);

Line 6170: AHL_DEBUG_PUB.debug( 'visit end time'||l_visit_end_time);

6166: END IF;
6167: END IF;
6168:
6169: IF G_DEBUG='Y' THEN
6170: AHL_DEBUG_PUB.debug( 'visit end time'||l_visit_end_time);
6171: END IF;
6172: --
6173: RETURN l_visit_end_time;
6174: --