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.PQH_BUDGET_DATA_MIGRATION dependencies on HR_UTILITY

Line 76: hr_utility.set_location('Entering: '||l_proc, 5);

72:
73:
74: BEGIN
75:
76: hr_utility.set_location('Entering: '||l_proc, 5);
77:
78: -- check input params
79: check_params
80: (

Line 272: hr_utility.set_location('Leaving:'||l_proc, 1000);

268: populate_empty_budget_versions;
269:
270: -- commit the work;
271: commit;
272: hr_utility.set_location('Leaving:'||l_proc, 1000);
273:
274: EXCEPTION
275: WHEN g_error_exception THEN
276: -- call the end log and stop

Line 349: hr_utility.set_location('Entering: '||l_proc, 5);

345:
346:
347: BEGIN
348:
349: hr_utility.set_location('Entering: '||l_proc, 5);
350:
351: IF p_valid = 'Y' THEN
352:
353: -- compute the budget start and end date

Line 371: hr_utility.set_location('Per Budget Id: '||p_per_budgets_rec.budget_id, 10);

367: FETCH budget_cal_cur INTO l_budget_start_date, l_budget_end_date;
368: CLOSE budget_cal_cur;
369: END IF;
370:
371: hr_utility.set_location('Per Budget Id: '||p_per_budgets_rec.budget_id, 10);
372: hr_utility.set_location('Start Date: '||l_budget_start_date, 15);
373: hr_utility.set_location('End Date: '||l_budget_end_date, 20);
374:
375: -- get the shared_type_id for UOM

Line 372: hr_utility.set_location('Start Date: '||l_budget_start_date, 15);

368: CLOSE budget_cal_cur;
369: END IF;
370:
371: hr_utility.set_location('Per Budget Id: '||p_per_budgets_rec.budget_id, 10);
372: hr_utility.set_location('Start Date: '||l_budget_start_date, 15);
373: hr_utility.set_location('End Date: '||l_budget_end_date, 20);
374:
375: -- get the shared_type_id for UOM
376:

Line 373: hr_utility.set_location('End Date: '||l_budget_end_date, 20);

369: END IF;
370:
371: hr_utility.set_location('Per Budget Id: '||p_per_budgets_rec.budget_id, 10);
372: hr_utility.set_location('Start Date: '||l_budget_start_date, 15);
373: hr_utility.set_location('End Date: '||l_budget_end_date, 20);
374:
375: -- get the shared_type_id for UOM
376:
377: l_shared_type_id := get_shared_type_id (p_unit => p_per_budgets_rec.unit );

Line 387: hr_utility.set_location('Shared Id : '||l_shared_type_id, 25);

383: ELSE
384: l_status := 'FROZEN';
385: END IF;
386:
387: hr_utility.set_location('Shared Id : '||l_shared_type_id, 25);
388:
389: -- compute total budget value
390: OPEN tot_unit1_val_cur;
391: FETCH tot_unit1_val_cur INTO l_tot_budget_val;

Line 395: hr_utility.set_location('l_budget_unit1_aggregate : '||l_budget_unit1_aggregate,26);

391: FETCH tot_unit1_val_cur INTO l_tot_budget_val;
392: p_tot_budget_val_o := l_tot_budget_val;
393: CLOSE tot_unit1_val_cur;
394:
395: hr_utility.set_location('l_budget_unit1_aggregate : '||l_budget_unit1_aggregate,26);
396:
397: -- call insert API
398: pqh_budgets_api.create_budget
399: (

Line 427: hr_utility.set_location('PQH Budget ID OUT NOCOPY : '||p_budget_id_o, 100);

423:
424:
425: END IF; -- p_valid = Y
426:
427: hr_utility.set_location('PQH Budget ID OUT NOCOPY : '||p_budget_id_o, 100);
428:
429: hr_utility.set_location('Leaving:'||l_proc, 1000);
430:
431: EXCEPTION

Line 429: hr_utility.set_location('Leaving:'||l_proc, 1000);

425: END IF; -- p_valid = Y
426:
427: hr_utility.set_location('PQH Budget ID OUT NOCOPY : '||p_budget_id_o, 100);
428:
429: hr_utility.set_location('Leaving:'||l_proc, 1000);
430:
431: EXCEPTION
432: WHEN others THEN
433:

Line 473: hr_utility.set_location('Entering: '||l_proc, 5);

469: WHERE budget_version_id = p_per_budget_ver_rec.budget_version_id);
470:
471: BEGIN
472:
473: hr_utility.set_location('Entering: '||l_proc, 5);
474:
475: IF p_budget_id IS NOT NULL THEN
476:
477: -- compute unit1

Line 502: hr_utility.set_location('PQH Budget Version out '||p_budget_version_id_o, 15);

498:
499:
500: END IF; -- p_budget_id not null
501:
502: hr_utility.set_location('PQH Budget Version out '||p_budget_version_id_o, 15);
503: hr_utility.set_location('Leaving:'||l_proc, 1000);
504:
505: EXCEPTION
506: WHEN others THEN

Line 503: hr_utility.set_location('Leaving:'||l_proc, 1000);

499:
500: END IF; -- p_budget_id not null
501:
502: hr_utility.set_location('PQH Budget Version out '||p_budget_version_id_o, 15);
503: hr_utility.set_location('Leaving:'||l_proc, 1000);
504:
505: EXCEPTION
506: WHEN others THEN
507: p_budget_version_id_o := null;

Line 545: hr_utility.set_location('Entering: '||l_proc, 5);

541:
542:
543: BEGIN
544:
545: hr_utility.set_location('Entering: '||l_proc, 5);
546:
547: IF p_budget_version_id IS NOT NULL THEN
548:
549: -- compute l_budget_unit1_value

Line 585: hr_utility.set_location('PQH Budget Detail ID out '||p_budget_detail_id_o, 100);

581: );
582:
583: END IF; -- p_budget_version_id is not null
584:
585: hr_utility.set_location('PQH Budget Detail ID out '||p_budget_detail_id_o, 100);
586: hr_utility.set_location('Leaving:'||l_proc, 1000);
587:
588: EXCEPTION
589: WHEN others THEN

Line 586: hr_utility.set_location('Leaving:'||l_proc, 1000);

582:
583: END IF; -- p_budget_version_id is not null
584:
585: hr_utility.set_location('PQH Budget Detail ID out '||p_budget_detail_id_o, 100);
586: hr_utility.set_location('Leaving:'||l_proc, 1000);
587:
588: EXCEPTION
589: WHEN others THEN
590: p_budget_detail_id_o := null;

Line 627: hr_utility.set_location('Entering: '||l_proc, 5);

623:
624:
625: BEGIN
626:
627: hr_utility.set_location('Entering: '||l_proc, 5);
628:
629: IF p_budget_detail_id IS NOT NULL THEN
630:
631: -- compute l_budget_unit1_percent

Line 660: hr_utility.set_location('Leaving:'||l_proc, 1000);

656:
657:
658: END IF; -- p_budget_detail_id is not null
659:
660: hr_utility.set_location('Leaving:'||l_proc, 1000);
661:
662: EXCEPTION
663: WHEN others THEN
664: p_budget_period_id_o := null;

Line 693: hr_utility.set_location('Entering: '||l_proc, 5);

689: l_shared_type_id number;
690:
691: BEGIN
692:
693: hr_utility.set_location('Entering: '||l_proc, 5);
694:
695: hr_utility.set_location('Unit : '||p_unit,10);
696:
697: IF p_unit IS NULL THEN

Line 695: hr_utility.set_location('Unit : '||p_unit,10);

691: BEGIN
692:
693: hr_utility.set_location('Entering: '||l_proc, 5);
694:
695: hr_utility.set_location('Unit : '||p_unit,10);
696:
697: IF p_unit IS NULL THEN
698:
699: hr_utility.set_location('Unit is NULL ',10);

Line 699: hr_utility.set_location('Unit is NULL ',10);

695: hr_utility.set_location('Unit : '||p_unit,10);
696:
697: IF p_unit IS NULL THEN
698:
699: hr_utility.set_location('Unit is NULL ',10);
700: hr_utility.set_location('Leaving:'||l_proc, 1000);
701:
702: RETURN NULL;
703:

Line 700: hr_utility.set_location('Leaving:'||l_proc, 1000);

696:
697: IF p_unit IS NULL THEN
698:
699: hr_utility.set_location('Unit is NULL ',10);
700: hr_utility.set_location('Leaving:'||l_proc, 1000);
701:
702: RETURN NULL;
703:
704: END IF;

Line 710: hr_utility.set_location('Shared Type ID :'||l_shared_type_id, 100);

706: OPEN uom_csr;
707: FETCH uom_csr INTO l_shared_type_id;
708: CLOSE uom_csr;
709:
710: hr_utility.set_location('Shared Type ID :'||l_shared_type_id, 100);
711: hr_utility.set_location('Leaving:'||l_proc, 1000);
712:
713: RETURN l_shared_type_id;
714:

Line 711: hr_utility.set_location('Leaving:'||l_proc, 1000);

707: FETCH uom_csr INTO l_shared_type_id;
708: CLOSE uom_csr;
709:
710: hr_utility.set_location('Shared Type ID :'||l_shared_type_id, 100);
711: hr_utility.set_location('Leaving:'||l_proc, 1000);
712:
713: RETURN l_shared_type_id;
714:
715: EXCEPTION

Line 747: hr_utility.set_location('Entering: '||l_proc, 5);

743: WHERE lookup_type = 'BUDGET_MEASUREMENT_TYPE' );
744:
745: BEGIN
746:
747: hr_utility.set_location('Entering: '||l_proc, 5);
748:
749: OPEN pop_uom_csr;
750: LOOP
751:

Line 766: hr_utility.set_location('Ins Per Shared Types '||l_lookup_code,10);

762: ,p_lookup_type => 'BUDGET_MEASUREMENT_TYPE'
763: ,p_effective_date => sysdate
764: );
765:
766: hr_utility.set_location('Ins Per Shared Types '||l_lookup_code,10);
767:
768: END LOOP;
769:
770: CLOSE pop_uom_csr;

Line 772: hr_utility.set_location('Leaving:'||l_proc, 1000);

768: END LOOP;
769:
770: CLOSE pop_uom_csr;
771:
772: hr_utility.set_location('Leaving:'||l_proc, 1000);
773:
774:
775: EXCEPTION
776: WHEN others THEN

Line 803: hr_utility.set_location('Entering: '||l_proc, 5);

799: FROM pqh_budget_versions );
800:
801: BEGIN
802:
803: hr_utility.set_location('Entering: '||l_proc, 5);
804:
805: OPEN budgets_csr;
806: LOOP
807:

Line 830: hr_utility.set_location('Leaving:'||l_proc, 1000);

826: END LOOP;
827:
828: CLOSE budgets_csr;
829:
830: hr_utility.set_location('Leaving:'||l_proc, 1000);
831:
832:
833: EXCEPTION
834: WHEN others THEN

Line 887: hr_utility.set_location('Entering: '||l_proc, 5);

883:
884:
885: BEGIN
886:
887: hr_utility.set_location('Entering: '||l_proc, 5);
888:
889: IF p_budget_period_id IS NOT NULL THEN
890:
891: OPEN budget_periods_csr;

Line 950: hr_utility.set_location('Leaving:'||l_proc, 1000);

946:
947:
948: END IF; -- p_budget_period_id is not null
949:
950: hr_utility.set_location('Leaving:'||l_proc, 1000);
951:
952:
953: EXCEPTION
954: WHEN others THEN

Line 988: hr_utility.set_location('Entering: '||l_proc, 5);

984:
985:
986: BEGIN
987:
988: hr_utility.set_location('Entering: '||l_proc, 5);
989:
990: IF p_budget_period_id IS NOT NULL THEN
991:
992: OPEN budget_periods_csr;

Line 1031: hr_utility.set_location('PQH Budget Set ID out '||p_budget_set_id_o, 100);

1027:
1028:
1029: END IF; -- p_budget_period_id is not null
1030:
1031: hr_utility.set_location('PQH Budget Set ID out '||p_budget_set_id_o, 100);
1032: hr_utility.set_location('Leaving:'||l_proc, 1000);
1033:
1034: EXCEPTION
1035: WHEN others THEN

Line 1032: hr_utility.set_location('Leaving:'||l_proc, 1000);

1028:
1029: END IF; -- p_budget_period_id is not null
1030:
1031: hr_utility.set_location('PQH Budget Set ID out '||p_budget_set_id_o, 100);
1032: hr_utility.set_location('Leaving:'||l_proc, 1000);
1033:
1034: EXCEPTION
1035: WHEN others THEN
1036: p_budget_set_id_o := null;

Line 1056: hr_utility.set_location('Entering: '||l_proc, 5);

1052: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1053:
1054: BEGIN
1055:
1056: hr_utility.set_location('Entering: '||l_proc, 5);
1057:
1058: IF p_budget_set_id IS NOT NULL THEN
1059:
1060: -- call insert API

Line 1073: hr_utility.set_location('PQH Budget Element ID out '||p_budget_element_id_o, 100);

1069: );
1070:
1071: END IF; -- p_budget_set_id is not null
1072:
1073: hr_utility.set_location('PQH Budget Element ID out '||p_budget_element_id_o, 100);
1074: hr_utility.set_location('Leaving:'||l_proc, 1000);
1075:
1076: EXCEPTION
1077: WHEN others THEN

Line 1074: hr_utility.set_location('Leaving:'||l_proc, 1000);

1070:
1071: END IF; -- p_budget_set_id is not null
1072:
1073: hr_utility.set_location('PQH Budget Element ID out '||p_budget_element_id_o, 100);
1074: hr_utility.set_location('Leaving:'||l_proc, 1000);
1075:
1076: EXCEPTION
1077: WHEN others THEN
1078: p_budget_element_id_o := null;

Line 1097: hr_utility.set_location('Entering: '||l_proc, 5);

1093: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1094:
1095: BEGIN
1096:
1097: hr_utility.set_location('Entering: '||l_proc, 5);
1098:
1099: IF p_budget_element_id IS NOT NULL THEN
1100:
1101: -- call insert API

Line 1114: hr_utility.set_location('PQH Budget Fund Src ID out '||p_budget_fund_src_id_o, 100);

1110: );
1111:
1112: END IF; -- p_budget_element_id is not null
1113:
1114: hr_utility.set_location('PQH Budget Fund Src ID out '||p_budget_fund_src_id_o, 100);
1115: hr_utility.set_location('Leaving:'||l_proc, 1000);
1116:
1117: EXCEPTION
1118: WHEN others THEN

Line 1115: hr_utility.set_location('Leaving:'||l_proc, 1000);

1111:
1112: END IF; -- p_budget_element_id is not null
1113:
1114: hr_utility.set_location('PQH Budget Fund Src ID out '||p_budget_fund_src_id_o, 100);
1115: hr_utility.set_location('Leaving:'||l_proc, 1000);
1116:
1117: EXCEPTION
1118: WHEN others THEN
1119: p_budget_fund_src_id_o := null;

Line 1141: hr_utility.set_location('Entering:'||l_proc, 5);

1137: WHERE table_alias = p_table_alias;
1138:
1139: BEGIN
1140:
1141: hr_utility.set_location('Entering:'||l_proc, 5);
1142:
1143:
1144: -- get table_route_id for all the tables
1145:

Line 1181: hr_utility.set_location('g_table_route_id_p_bgt: '||g_table_route_id_p_bgt, 50);

1177: OPEN csr_table_route (p_table_alias => 'DFS');
1178: FETCH csr_table_route INTO g_table_route_id_dfs;
1179: CLOSE csr_table_route;
1180:
1181: hr_utility.set_location('g_table_route_id_p_bgt: '||g_table_route_id_p_bgt, 50);
1182: hr_utility.set_location('g_table_route_id_p_bvr: '||g_table_route_id_p_bvr, 60);
1183: hr_utility.set_location('g_table_route_id_p_bdt: '||g_table_route_id_p_bdt, 70);
1184: hr_utility.set_location('g_table_route_id_p_bpr: '||g_table_route_id_p_bpr, 80);
1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);

Line 1182: hr_utility.set_location('g_table_route_id_p_bvr: '||g_table_route_id_p_bvr, 60);

1178: FETCH csr_table_route INTO g_table_route_id_dfs;
1179: CLOSE csr_table_route;
1180:
1181: hr_utility.set_location('g_table_route_id_p_bgt: '||g_table_route_id_p_bgt, 50);
1182: hr_utility.set_location('g_table_route_id_p_bvr: '||g_table_route_id_p_bvr, 60);
1183: hr_utility.set_location('g_table_route_id_p_bdt: '||g_table_route_id_p_bdt, 70);
1184: hr_utility.set_location('g_table_route_id_p_bpr: '||g_table_route_id_p_bpr, 80);
1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);
1186: hr_utility.set_location('g_table_route_id_del: '||g_table_route_id_del, 95);

Line 1183: hr_utility.set_location('g_table_route_id_p_bdt: '||g_table_route_id_p_bdt, 70);

1179: CLOSE csr_table_route;
1180:
1181: hr_utility.set_location('g_table_route_id_p_bgt: '||g_table_route_id_p_bgt, 50);
1182: hr_utility.set_location('g_table_route_id_p_bvr: '||g_table_route_id_p_bvr, 60);
1183: hr_utility.set_location('g_table_route_id_p_bdt: '||g_table_route_id_p_bdt, 70);
1184: hr_utility.set_location('g_table_route_id_p_bpr: '||g_table_route_id_p_bpr, 80);
1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);
1186: hr_utility.set_location('g_table_route_id_del: '||g_table_route_id_del, 95);
1187: hr_utility.set_location('g_table_route_id_dfs: '||g_table_route_id_dfs, 96);

Line 1184: hr_utility.set_location('g_table_route_id_p_bpr: '||g_table_route_id_p_bpr, 80);

1180:
1181: hr_utility.set_location('g_table_route_id_p_bgt: '||g_table_route_id_p_bgt, 50);
1182: hr_utility.set_location('g_table_route_id_p_bvr: '||g_table_route_id_p_bvr, 60);
1183: hr_utility.set_location('g_table_route_id_p_bdt: '||g_table_route_id_p_bdt, 70);
1184: hr_utility.set_location('g_table_route_id_p_bpr: '||g_table_route_id_p_bpr, 80);
1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);
1186: hr_utility.set_location('g_table_route_id_del: '||g_table_route_id_del, 95);
1187: hr_utility.set_location('g_table_route_id_dfs: '||g_table_route_id_dfs, 96);
1188:

Line 1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);

1181: hr_utility.set_location('g_table_route_id_p_bgt: '||g_table_route_id_p_bgt, 50);
1182: hr_utility.set_location('g_table_route_id_p_bvr: '||g_table_route_id_p_bvr, 60);
1183: hr_utility.set_location('g_table_route_id_p_bdt: '||g_table_route_id_p_bdt, 70);
1184: hr_utility.set_location('g_table_route_id_p_bpr: '||g_table_route_id_p_bpr, 80);
1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);
1186: hr_utility.set_location('g_table_route_id_del: '||g_table_route_id_del, 95);
1187: hr_utility.set_location('g_table_route_id_dfs: '||g_table_route_id_dfs, 96);
1188:
1189: hr_utility.set_location('Leaving:'||l_proc, 1000);

Line 1186: hr_utility.set_location('g_table_route_id_del: '||g_table_route_id_del, 95);

1182: hr_utility.set_location('g_table_route_id_p_bvr: '||g_table_route_id_p_bvr, 60);
1183: hr_utility.set_location('g_table_route_id_p_bdt: '||g_table_route_id_p_bdt, 70);
1184: hr_utility.set_location('g_table_route_id_p_bpr: '||g_table_route_id_p_bpr, 80);
1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);
1186: hr_utility.set_location('g_table_route_id_del: '||g_table_route_id_del, 95);
1187: hr_utility.set_location('g_table_route_id_dfs: '||g_table_route_id_dfs, 96);
1188:
1189: hr_utility.set_location('Leaving:'||l_proc, 1000);
1190:

Line 1187: hr_utility.set_location('g_table_route_id_dfs: '||g_table_route_id_dfs, 96);

1183: hr_utility.set_location('g_table_route_id_p_bdt: '||g_table_route_id_p_bdt, 70);
1184: hr_utility.set_location('g_table_route_id_p_bpr: '||g_table_route_id_p_bpr, 80);
1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);
1186: hr_utility.set_location('g_table_route_id_del: '||g_table_route_id_del, 95);
1187: hr_utility.set_location('g_table_route_id_dfs: '||g_table_route_id_dfs, 96);
1188:
1189: hr_utility.set_location('Leaving:'||l_proc, 1000);
1190:
1191: EXCEPTION

Line 1189: hr_utility.set_location('Leaving:'||l_proc, 1000);

1185: hr_utility.set_location('g_table_route_id_dst: '||g_table_route_id_dst, 90);
1186: hr_utility.set_location('g_table_route_id_del: '||g_table_route_id_del, 95);
1187: hr_utility.set_location('g_table_route_id_dfs: '||g_table_route_id_dfs, 96);
1188:
1189: hr_utility.set_location('Leaving:'||l_proc, 1000);
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

Line 1193: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1189: hr_utility.set_location('Leaving:'||l_proc, 1000);
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1194: hr_utility.set_message_token('ROUTINE', l_proc);
1195: hr_utility.set_message_token('REASON', SQLERRM);
1196: -- end log and halt the program here
1197: raise g_error_exception;

Line 1194: hr_utility.set_message_token('ROUTINE', l_proc);

1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1194: hr_utility.set_message_token('ROUTINE', l_proc);
1195: hr_utility.set_message_token('REASON', SQLERRM);
1196: -- end log and halt the program here
1197: raise g_error_exception;
1198:

Line 1195: hr_utility.set_message_token('REASON', SQLERRM);

1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1194: hr_utility.set_message_token('ROUTINE', l_proc);
1195: hr_utility.set_message_token('REASON', SQLERRM);
1196: -- end log and halt the program here
1197: raise g_error_exception;
1198:
1199: END populate_globals;

Line 1222: hr_utility.set_location('Entering:'||l_proc, 5);

1218: WHERE budget_id = p_budget_id;
1219:
1220: BEGIN
1221:
1222: hr_utility.set_location('Entering:'||l_proc, 5);
1223:
1224: OPEN bdg_name_csr;
1225: FETCH bdg_name_csr INTO l_bdg_name;
1226: CLOSE bdg_name_csr;

Line 1234: hr_utility.set_location('Log Context : '||p_log_context, 101);

1230: p_log_context := l_bdg_name;
1231:
1232:
1233:
1234: hr_utility.set_location('Log Context : '||p_log_context, 101);
1235: hr_utility.set_location('Leaving:'||l_proc, 1000);
1236:
1237: EXCEPTION
1238: WHEN OTHERS THEN

Line 1235: hr_utility.set_location('Leaving:'||l_proc, 1000);

1231:
1232:
1233:
1234: hr_utility.set_location('Log Context : '||p_log_context, 101);
1235: hr_utility.set_location('Leaving:'||l_proc, 1000);
1236:
1237: EXCEPTION
1238: WHEN OTHERS THEN
1239: p_log_context := null;

Line 1240: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1236:
1237: EXCEPTION
1238: WHEN OTHERS THEN
1239: p_log_context := null;
1240: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1241: hr_utility.set_message_token('ROUTINE', l_proc);
1242: hr_utility.set_message_token('REASON', SQLERRM);
1243: -- end log and halt the program here
1244: raise g_error_exception;

Line 1241: hr_utility.set_message_token('ROUTINE', l_proc);

1237: EXCEPTION
1238: WHEN OTHERS THEN
1239: p_log_context := null;
1240: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1241: hr_utility.set_message_token('ROUTINE', l_proc);
1242: hr_utility.set_message_token('REASON', SQLERRM);
1243: -- end log and halt the program here
1244: raise g_error_exception;
1245: END set_p_bgt_log_context;

Line 1242: hr_utility.set_message_token('REASON', SQLERRM);

1238: WHEN OTHERS THEN
1239: p_log_context := null;
1240: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1241: hr_utility.set_message_token('ROUTINE', l_proc);
1242: hr_utility.set_message_token('REASON', SQLERRM);
1243: -- end log and halt the program here
1244: raise g_error_exception;
1245: END set_p_bgt_log_context;
1246:

Line 1273: hr_utility.set_location('Entering:'||l_proc, 5);

1269: WHERE budget_version_id = p_budget_version_id;
1270:
1271: BEGIN
1272:
1273: hr_utility.set_location('Entering:'||l_proc, 5);
1274:
1275: OPEN bdg_ver_csr;
1276: FETCH bdg_ver_csr INTO l_bdg_ver_number;
1277: CLOSE bdg_ver_csr;

Line 1285: hr_utility.set_location('Log Context : '||p_log_context, 101);

1281: p_log_context := l_bdg_ver_number;
1282:
1283:
1284:
1285: hr_utility.set_location('Log Context : '||p_log_context, 101);
1286: hr_utility.set_location('Leaving:'||l_proc, 1000);
1287:
1288: EXCEPTION
1289: WHEN OTHERS THEN

Line 1286: hr_utility.set_location('Leaving:'||l_proc, 1000);

1282:
1283:
1284:
1285: hr_utility.set_location('Log Context : '||p_log_context, 101);
1286: hr_utility.set_location('Leaving:'||l_proc, 1000);
1287:
1288: EXCEPTION
1289: WHEN OTHERS THEN
1290: p_log_context := null;

Line 1291: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1287:
1288: EXCEPTION
1289: WHEN OTHERS THEN
1290: p_log_context := null;
1291: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1292: hr_utility.set_message_token('ROUTINE', l_proc);
1293: hr_utility.set_message_token('REASON', SQLERRM);
1294: -- end log and halt the program here
1295: raise g_error_exception;

Line 1292: hr_utility.set_message_token('ROUTINE', l_proc);

1288: EXCEPTION
1289: WHEN OTHERS THEN
1290: p_log_context := null;
1291: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1292: hr_utility.set_message_token('ROUTINE', l_proc);
1293: hr_utility.set_message_token('REASON', SQLERRM);
1294: -- end log and halt the program here
1295: raise g_error_exception;
1296: END set_p_bvr_log_context;

Line 1293: hr_utility.set_message_token('REASON', SQLERRM);

1289: WHEN OTHERS THEN
1290: p_log_context := null;
1291: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1292: hr_utility.set_message_token('ROUTINE', l_proc);
1293: hr_utility.set_message_token('REASON', SQLERRM);
1294: -- end log and halt the program here
1295: raise g_error_exception;
1296: END set_p_bvr_log_context;
1297:

Line 1324: hr_utility.set_location('Entering:'||l_proc, 5);

1320: WHERE budget_element_id = p_budget_element_id ;
1321:
1322: BEGIN
1323:
1324: hr_utility.set_location('Entering:'||l_proc, 5);
1325:
1326: OPEN csr_bdg_elmnt_rec;
1327: FETCH csr_bdg_elmnt_rec INTO l_budget_elements_rec;
1328: CLOSE csr_bdg_elmnt_rec;

Line 1350: hr_utility.set_location('Log Context : '||p_log_context, 100);

1346: p_log_context := 'Budget Element';
1347: END IF;
1348:
1349:
1350: hr_utility.set_location('Log Context : '||p_log_context, 100);
1351:
1352:
1353: hr_utility.set_location('Leaving:'||l_proc, 1000);
1354:

Line 1353: hr_utility.set_location('Leaving:'||l_proc, 1000);

1349:
1350: hr_utility.set_location('Log Context : '||p_log_context, 100);
1351:
1352:
1353: hr_utility.set_location('Leaving:'||l_proc, 1000);
1354:
1355: EXCEPTION
1356: WHEN OTHERS THEN
1357: p_log_context := null;

Line 1358: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1354:
1355: EXCEPTION
1356: WHEN OTHERS THEN
1357: p_log_context := null;
1358: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1359: hr_utility.set_message_token('ROUTINE', l_proc);
1360: hr_utility.set_message_token('REASON', SQLERRM);
1361: -- end log and halt the program here
1362: raise g_error_exception;

Line 1359: hr_utility.set_message_token('ROUTINE', l_proc);

1355: EXCEPTION
1356: WHEN OTHERS THEN
1357: p_log_context := null;
1358: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1359: hr_utility.set_message_token('ROUTINE', l_proc);
1360: hr_utility.set_message_token('REASON', SQLERRM);
1361: -- end log and halt the program here
1362: raise g_error_exception;
1363: END set_p_bdt_log_context;

Line 1360: hr_utility.set_message_token('REASON', SQLERRM);

1356: WHEN OTHERS THEN
1357: p_log_context := null;
1358: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1359: hr_utility.set_message_token('ROUTINE', l_proc);
1360: hr_utility.set_message_token('REASON', SQLERRM);
1361: -- end log and halt the program here
1362: raise g_error_exception;
1363: END set_p_bdt_log_context;
1364:

Line 1392: hr_utility.set_location('Entering:'||l_proc, 5);

1388:
1389:
1390: BEGIN
1391:
1392: hr_utility.set_location('Entering:'||l_proc, 5);
1393:
1394: OPEN csr_bpr_periods_rec;
1395: FETCH csr_bpr_periods_rec INTO l_per_budget_values_rec;
1396: CLOSE csr_bpr_periods_rec;

Line 1408: hr_utility.set_location('Log Context : '||p_log_context, 101);

1404: p_log_context := l_per_time_periods_rec.period_name;
1405:
1406:
1407:
1408: hr_utility.set_location('Log Context : '||p_log_context, 101);
1409: hr_utility.set_location('Leaving:'||l_proc, 1000);
1410:
1411: EXCEPTION
1412: WHEN OTHERS THEN

Line 1409: hr_utility.set_location('Leaving:'||l_proc, 1000);

1405:
1406:
1407:
1408: hr_utility.set_location('Log Context : '||p_log_context, 101);
1409: hr_utility.set_location('Leaving:'||l_proc, 1000);
1410:
1411: EXCEPTION
1412: WHEN OTHERS THEN
1413: p_log_context := null;

Line 1414: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

1410:
1411: EXCEPTION
1412: WHEN OTHERS THEN
1413: p_log_context := null;
1414: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1415: hr_utility.set_message_token('ROUTINE', l_proc);
1416: hr_utility.set_message_token('REASON', SQLERRM);
1417: -- end log and halt the program here
1418: raise g_error_exception;

Line 1415: hr_utility.set_message_token('ROUTINE', l_proc);

1411: EXCEPTION
1412: WHEN OTHERS THEN
1413: p_log_context := null;
1414: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1415: hr_utility.set_message_token('ROUTINE', l_proc);
1416: hr_utility.set_message_token('REASON', SQLERRM);
1417: -- end log and halt the program here
1418: raise g_error_exception;
1419: END set_p_bpr_log_context;

Line 1416: hr_utility.set_message_token('REASON', SQLERRM);

1412: WHEN OTHERS THEN
1413: p_log_context := null;
1414: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1415: hr_utility.set_message_token('ROUTINE', l_proc);
1416: hr_utility.set_message_token('REASON', SQLERRM);
1417: -- end log and halt the program here
1418: raise g_error_exception;
1419: END set_p_bpr_log_context;
1420:

Line 1457: hr_utility.set_location('Entering:'||l_proc, 5);

1453: WHERE dflt_budget_set_name = p_budget_set_name;
1454:
1455: BEGIN
1456:
1457: hr_utility.set_location('Entering:'||l_proc, 5);
1458:
1459: -- count budgets
1460: OPEN cnt_budgets_csr;
1461: FETCH cnt_budgets_csr INTO l_bdg_cnt;

Line 1483: hr_utility.set_location('Leaving:'||l_proc, 1000);

1479: APP_EXCEPTION.RAISE_EXCEPTION;
1480:
1481: END IF;
1482:
1483: hr_utility.set_location('Leaving:'||l_proc, 1000);
1484:
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: raise;

Line 1534: hr_utility.set_location('Entering:'||l_proc, 5);

1530:
1531:
1532: BEGIN
1533:
1534: hr_utility.set_location('Entering:'||l_proc, 5);
1535:
1536: OPEN cnt_elements;
1537: FETCH cnt_elements INTO l_cnt_elements;
1538: CLOSE cnt_elements;

Line 1567: hr_utility.set_location('Leaving:'||l_proc, 1000);

1563: p_valid := 'Y';
1564: END IF;
1565:
1566:
1567: hr_utility.set_location('Leaving:'||l_proc, 1000);
1568: exception
1569: when others then
1570: p_valid := null;
1571: raise;