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_WKS_ERROR_CHK dependencies on HR_UTILITY

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

152:
153:
154: BEGIN
155:
156: hr_utility.set_location('Entering: '||l_proc, 5);
157:
158: -- populate the globals
159: populate_globals
160: (

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

455: -- populate the out param
456: p_status := g_batch_status;
457:
458:
459: hr_utility.set_location('Leaving:'||l_proc, 1000);
460:
461: EXCEPTION
462: WHEN g_error_exception THEN
463: -- update the out varchar

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

537: WHERE table_alias = p_table_alias;
538:
539: BEGIN
540:
541: hr_utility.set_location('Entering:'||l_proc, 5);
542:
543: -- get budget units
544: OPEN csr_budget_rec;
545: FETCH csr_budget_rec INTO l_budgets_rec;

Line 563: hr_utility.set_location('budget_unit1: '||g_budget_unit1_id, 11);

559: g_budget_unit3_aggregate := l_budgets_rec.budget_unit3_aggregate;
560: g_budget_style_cd := l_budgets_rec.budget_style_cd;
561:
562:
563: hr_utility.set_location('budget_unit1: '||g_budget_unit1_id, 11);
564: hr_utility.set_location('budget_unit2: '||g_budget_unit2_id, 15);
565: hr_utility.set_location('budget_unit3: '||g_budget_unit3_id, 20);
566: hr_utility.set_location('budgeted_entity_cd: '||g_budgeted_entity_cd, 21);
567:

Line 564: hr_utility.set_location('budget_unit2: '||g_budget_unit2_id, 15);

560: g_budget_style_cd := l_budgets_rec.budget_style_cd;
561:
562:
563: hr_utility.set_location('budget_unit1: '||g_budget_unit1_id, 11);
564: hr_utility.set_location('budget_unit2: '||g_budget_unit2_id, 15);
565: hr_utility.set_location('budget_unit3: '||g_budget_unit3_id, 20);
566: hr_utility.set_location('budgeted_entity_cd: '||g_budgeted_entity_cd, 21);
567:
568:

Line 565: hr_utility.set_location('budget_unit3: '||g_budget_unit3_id, 20);

561:
562:
563: hr_utility.set_location('budget_unit1: '||g_budget_unit1_id, 11);
564: hr_utility.set_location('budget_unit2: '||g_budget_unit2_id, 15);
565: hr_utility.set_location('budget_unit3: '||g_budget_unit3_id, 20);
566: hr_utility.set_location('budgeted_entity_cd: '||g_budgeted_entity_cd, 21);
567:
568:
569: -- get worksheet mode

Line 566: hr_utility.set_location('budgeted_entity_cd: '||g_budgeted_entity_cd, 21);

562:
563: hr_utility.set_location('budget_unit1: '||g_budget_unit1_id, 11);
564: hr_utility.set_location('budget_unit2: '||g_budget_unit2_id, 15);
565: hr_utility.set_location('budget_unit3: '||g_budget_unit3_id, 20);
566: hr_utility.set_location('budgeted_entity_cd: '||g_budgeted_entity_cd, 21);
567:
568:
569: -- get worksheet mode
570: OPEN csr_worksheet_rec;

Line 578: hr_utility.set_location('worksheet_mode_cd: '||g_worksheet_mode_cd, 25);

574: g_worksheet_mode_cd := l_worksheets_rec.worksheet_mode_cd;
575: g_worksheet_name := l_worksheets_rec.worksheet_name;
576: g_worksheet_id := l_worksheets_rec.worksheet_id;
577:
578: hr_utility.set_location('worksheet_mode_cd: '||g_worksheet_mode_cd, 25);
579: hr_utility.set_location('worksheet_name: '||g_worksheet_name, 30);
580: hr_utility.set_location('worksheet_id: '||g_worksheet_id, 40);
581:
582: -- check if p_worksheet_detail_id is valid. If p_worksheet_detail_id is INVALID then

Line 579: hr_utility.set_location('worksheet_name: '||g_worksheet_name, 30);

575: g_worksheet_name := l_worksheets_rec.worksheet_name;
576: g_worksheet_id := l_worksheets_rec.worksheet_id;
577:
578: hr_utility.set_location('worksheet_mode_cd: '||g_worksheet_mode_cd, 25);
579: hr_utility.set_location('worksheet_name: '||g_worksheet_name, 30);
580: hr_utility.set_location('worksheet_id: '||g_worksheet_id, 40);
581:
582: -- check if p_worksheet_detail_id is valid. If p_worksheet_detail_id is INVALID then
583: -- no worksheet record would be fetched . So abort

Line 580: hr_utility.set_location('worksheet_id: '||g_worksheet_id, 40);

576: g_worksheet_id := l_worksheets_rec.worksheet_id;
577:
578: hr_utility.set_location('worksheet_mode_cd: '||g_worksheet_mode_cd, 25);
579: hr_utility.set_location('worksheet_name: '||g_worksheet_name, 30);
580: hr_utility.set_location('worksheet_id: '||g_worksheet_id, 40);
581:
582: -- check if p_worksheet_detail_id is valid. If p_worksheet_detail_id is INVALID then
583: -- no worksheet record would be fetched . So abort
584:

Line 618: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);

614: OPEN csr_table_route (p_table_alias => 'WFS');
615: FETCH csr_table_route INTO g_table_route_id_wfs;
616: CLOSE csr_table_route;
617:
618: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
619: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
620: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
621: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
622: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);

Line 619: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);

615: FETCH csr_table_route INTO g_table_route_id_wfs;
616: CLOSE csr_table_route;
617:
618: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
619: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
620: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
621: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
622: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
623:

Line 620: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);

616: CLOSE csr_table_route;
617:
618: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
619: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
620: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
621: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
622: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
623:
624: hr_utility.set_location('Leaving:'||l_proc, 1000);

Line 621: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);

617:
618: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
619: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
620: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
621: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
622: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
623:
624: hr_utility.set_location('Leaving:'||l_proc, 1000);
625:

Line 622: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);

618: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
619: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
620: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
621: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
622: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
623:
624: hr_utility.set_location('Leaving:'||l_proc, 1000);
625:
626: EXCEPTION

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

620: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
621: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
622: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
623:
624: hr_utility.set_location('Leaving:'||l_proc, 1000);
625:
626: EXCEPTION
627: WHEN OTHERS THEN
628: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

624: hr_utility.set_location('Leaving:'||l_proc, 1000);
625:
626: EXCEPTION
627: WHEN OTHERS THEN
628: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
629: hr_utility.set_message_token('ROUTINE', l_proc);
630: hr_utility.set_message_token('REASON', SQLERRM);
631: hr_utility.raise_error;
632: END populate_globals;

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

625:
626: EXCEPTION
627: WHEN OTHERS THEN
628: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
629: hr_utility.set_message_token('ROUTINE', l_proc);
630: hr_utility.set_message_token('REASON', SQLERRM);
631: hr_utility.raise_error;
632: END populate_globals;
633:

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

626: EXCEPTION
627: WHEN OTHERS THEN
628: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
629: hr_utility.set_message_token('ROUTINE', l_proc);
630: hr_utility.set_message_token('REASON', SQLERRM);
631: hr_utility.raise_error;
632: END populate_globals;
633:
634:

Line 631: hr_utility.raise_error;

627: WHEN OTHERS THEN
628: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
629: hr_utility.set_message_token('ROUTINE', l_proc);
630: hr_utility.set_message_token('REASON', SQLERRM);
631: hr_utility.raise_error;
632: END populate_globals;
633:
634:
635:

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

693: FOR UPDATE OF budget_unit1_available,budget_unit2_available,budget_unit3_available;
694:
695: BEGIN
696:
697: hr_utility.set_location('Entering:'||l_proc, 5);
698:
699: OPEN csr_level1_rows;
700: LOOP
701: FETCH csr_level1_rows INTO l_worksheet_details_rec;

Line 822: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);

818: END IF; -- budget_style_cd
819:
820:
821:
822: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);
823:
824:
825: /*
826: -- insert error message if l_error_flag is Y

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

840: END LOOP;
841: CLOSE csr_level1_rows;
842:
843:
844: hr_utility.set_location('Leaving:'||l_proc, 1000);
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

844: hr_utility.set_location('Leaving:'||l_proc, 1000);
845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
849: hr_utility.set_message_token('ROUTINE', l_proc);
850: hr_utility.set_message_token('REASON', SQLERRM);
851: -- end log and halt the program here
852: raise g_error_exception;

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

845:
846: EXCEPTION
847: WHEN OTHERS THEN
848: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
849: hr_utility.set_message_token('ROUTINE', l_proc);
850: hr_utility.set_message_token('REASON', SQLERRM);
851: -- end log and halt the program here
852: raise g_error_exception;
853: END check_level1_rows;

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

846: EXCEPTION
847: WHEN OTHERS THEN
848: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
849: hr_utility.set_message_token('ROUTINE', l_proc);
850: hr_utility.set_message_token('REASON', SQLERRM);
851: -- end log and halt the program here
852: raise g_error_exception;
853: END check_level1_rows;
854:

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

904:
905:
906: BEGIN
907:
908: hr_utility.set_location('Entering:'||l_proc, 5);
909:
910: OPEN csr_wks_details;
911: FETCH csr_wks_details INTO l_worksheet_details_rec;
912: CLOSE csr_wks_details;

Line 937: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);

933: -- set l_error_flag to Y
934: l_error_flag := 'Y';
935:
936:
937: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);
938:
939:
940: END IF; -- CHECK # 1
941:

Line 973: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);

969:
970: -- set l_error_flag to Y
971: l_error_flag := 'Y';
972:
973: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);
974:
975:
976:
977: ELSIF ( g_budget_unit2_id IS NOT NULL ) AND

Line 997: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);

993:
994: -- set l_error_flag to Y
995: l_error_flag := 'Y';
996:
997: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);
998:
999:
1000: ELSIF ( g_budget_unit3_id IS NOT NULL ) AND
1001: ( NVL(l_worksheet_details_rec.budget_unit3_value,0) < 0 ) THEN

Line 1020: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);

1016:
1017: -- set l_error_flag to Y
1018: l_error_flag := 'Y';
1019:
1020: hr_utility.set_location('Error in Txn : '||l_worksheet_details_rec.worksheet_detail_id, 10);
1021:
1022:
1023:
1024: END IF;

Line 1041: hr_utility.set_location('WKS Detail Error 3 PQH_WKS_NO_PERIODS '||l_worksheet_details_rec.worksheet_detail_id,10);

1037: CLOSE csr_wks_periods_count;
1038:
1039: IF NVL(l_count,0) = 0 THEN
1040:
1041: hr_utility.set_location('WKS Detail Error 3 PQH_WKS_NO_PERIODS '||l_worksheet_details_rec.worksheet_detail_id,10);
1042:
1043: -- get message text for PQH_WKS_NO_PERIODS
1044: -- message : No Periods Defined for the budgeted entity
1045: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_PERIODS');

Line 1104: hr_utility.set_location('WKS Detail Error 3.1 PQH_PC_POSN_INVALID '||l_worksheet_details_rec.position_id,11);

1100: p_status => l_pc_posn_status
1101: );
1102:
1103: IF l_pc_posn_status = 'ERROR' THEN
1104: hr_utility.set_location('WKS Detail Error 3.1 PQH_PC_POSN_INVALID '||l_worksheet_details_rec.position_id,11);
1105: -- get message text for PQH_PC_POSN_INVALID
1106: -- message : Position is already budgeted in another budget for the same Fiscal period
1107: FND_MESSAGE.SET_NAME('PQH','PQH_PC_POSN_INVALID');
1108: l_message_text_out := FND_MESSAGE.GET;

Line 1135: hr_utility.set_location('WKS Detail Error 4 PQH_WKS_DEL_ALL_AMT '||l_worksheet_details_rec.worksheet_detail_id,10);

1131: IF ( NVL(l_worksheet_details_rec.budget_unit1_available,0) < 0 ) OR
1132: ( NVL(l_worksheet_details_rec.budget_unit2_available,0) < 0 ) OR
1133: ( NVL(l_worksheet_details_rec.budget_unit3_available,0) < 0 ) THEN
1134:
1135: hr_utility.set_location('WKS Detail Error 4 PQH_WKS_DEL_ALL_AMT '||l_worksheet_details_rec.worksheet_detail_id,10);
1136:
1137: -- get message text for PQH_WKS_DEL_ALL_AMT
1138: -- message : Budget Amount in the delegated organization exceeds the allocated amount
1139: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_ALL_AMT');

Line 1164: hr_utility.set_location('WKS Detail Error 5 PQH_WKS_NO_POSITION '||l_worksheet_details_rec.worksheet_detail_id,10);

1160:
1161: IF l_worksheet_details_rec.position_transaction_id IS NOT NULL THEN
1162: -- posn txn id exists, check if position id exists
1163: IF l_worksheet_details_rec.position_id IS NULL THEN
1164: hr_utility.set_location('WKS Detail Error 5 PQH_WKS_NO_POSITION '||l_worksheet_details_rec.worksheet_detail_id,10);
1165:
1166: -- get message text for PQH_WKS_NO_POSITION
1167: -- message : Position is not created for this position transaction
1168: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_POSITION');

Line 1190: hr_utility.set_location('Error Flag : '||l_error_flag,10);

1186:
1187: END IF; -- CHECK # 5 budgeted record
1188:
1189:
1190: hr_utility.set_location('Error Flag : '||l_error_flag,10);
1191:
1192: -- insert error message if l_error_flag is Y
1193: IF l_error_flag = 'Y' THEN
1194: pqh_process_batch_log.insert_log

Line 1203: hr_utility.set_location('Leaving:'||l_proc, 10);

1199: END IF; -- insert error message if l_error_flag is Y
1200:
1201:
1202:
1203: hr_utility.set_location('Leaving:'||l_proc, 10);
1204:
1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

1203: hr_utility.set_location('Leaving:'||l_proc, 10);
1204:
1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1208: hr_utility.set_message_token('ROUTINE', l_proc);
1209: hr_utility.set_message_token('REASON', SQLERRM);
1210: -- end log and halt the program here
1211: raise g_error_exception;

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

1204:
1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1208: hr_utility.set_message_token('ROUTINE', l_proc);
1209: hr_utility.set_message_token('REASON', SQLERRM);
1210: -- end log and halt the program here
1211: raise g_error_exception;
1212: END check_wks_details;

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

1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1208: hr_utility.set_message_token('ROUTINE', l_proc);
1209: hr_utility.set_message_token('REASON', SQLERRM);
1210: -- end log and halt the program here
1211: raise g_error_exception;
1212: END check_wks_details;
1213:

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

1258:
1259:
1260: BEGIN
1261:
1262: hr_utility.set_location('Entering:'||l_proc, 5);
1263:
1264:
1265: OPEN csr_wks_periods;
1266: FETCH csr_wks_periods INTO l_worksheet_periods_rec;

Line 1354: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);

1350: p_message_text => l_message_text
1351: );
1352: ELSE
1353: -- this is ignore
1354: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);
1355: END IF;
1356:
1357:
1358: /* -- added configurable rule on 10/13/2000

Line 1397: hr_utility.set_location('Leaving:'||l_proc, 10);

1393:
1394:
1395:
1396:
1397: hr_utility.set_location('Leaving:'||l_proc, 10);
1398:
1399: EXCEPTION
1400: WHEN OTHERS THEN
1401: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

1397: hr_utility.set_location('Leaving:'||l_proc, 10);
1398:
1399: EXCEPTION
1400: WHEN OTHERS THEN
1401: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1402: hr_utility.set_message_token('ROUTINE', l_proc);
1403: hr_utility.set_message_token('REASON', SQLERRM);
1404: -- end log and halt the program here
1405: raise g_error_exception;

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

1398:
1399: EXCEPTION
1400: WHEN OTHERS THEN
1401: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1402: hr_utility.set_message_token('ROUTINE', l_proc);
1403: hr_utility.set_message_token('REASON', SQLERRM);
1404: -- end log and halt the program here
1405: raise g_error_exception;
1406: END check_wks_periods;

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

1399: EXCEPTION
1400: WHEN OTHERS THEN
1401: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1402: hr_utility.set_message_token('ROUTINE', l_proc);
1403: hr_utility.set_message_token('REASON', SQLERRM);
1404: -- end log and halt the program here
1405: raise g_error_exception;
1406: END check_wks_periods;
1407:

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

1457:
1458:
1459: BEGIN
1460:
1461: hr_utility.set_location('Entering:'||l_proc, 5);
1462:
1463: -- get the details for the current period
1464: OPEN csr_wks_worksheet_periods;
1465: FETCH csr_wks_worksheet_periods INTO l_worksheet_periods_rec;

Line 1511: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);

1507: p_message_text => l_message_text
1508: );
1509: ELSE
1510: -- this is ignore
1511: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);
1512: END IF; -- message_type
1513:
1514:
1515:

Line 1571: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);

1567: p_message_text => l_message_text
1568: );
1569: ELSE
1570: -- this is ignore
1571: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);
1572: END IF; -- message_type
1573:
1574:
1575:

Line 1633: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);

1629: p_message_text => l_message_text
1630: );
1631: ELSE
1632: -- this is ignore
1633: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);
1634: END IF; -- message_type
1635:
1636:
1637:

Line 1661: hr_utility.set_location('Leaving:'||l_proc, 10);

1657:
1658:
1659:
1660:
1661: hr_utility.set_location('Leaving:'||l_proc, 10);
1662:
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

1661: hr_utility.set_location('Leaving:'||l_proc, 10);
1662:
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1666: hr_utility.set_message_token('ROUTINE', l_proc);
1667: hr_utility.set_message_token('REASON', SQLERRM);
1668: -- end log and halt the program here
1669: raise g_error_exception;

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

1662:
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1666: hr_utility.set_message_token('ROUTINE', l_proc);
1667: hr_utility.set_message_token('REASON', SQLERRM);
1668: -- end log and halt the program here
1669: raise g_error_exception;
1670: END check_wks_budget_sets;

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

1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1666: hr_utility.set_message_token('ROUTINE', l_proc);
1667: hr_utility.set_message_token('REASON', SQLERRM);
1668: -- end log and halt the program here
1669: raise g_error_exception;
1670: END check_wks_budget_sets;
1671:

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

1712:
1713:
1714: BEGIN
1715:
1716: hr_utility.set_location('Entering:'||l_proc, 5);
1717:
1718:
1719: -- CHECK # 1 check if SUM of percentage = 100
1720:

Line 1731: hr_utility.set_location('Message Set ',6);

1727: -- get message text for PQH_WKS_INVALID_ELMNT_SUM
1728: -- message : For Budget elements total of percentage under a budget set cannot exceed 100
1729: pqh_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM',g_context_organization_id);
1730:
1731: hr_utility.set_location('Message Set ',6);
1732:
1733: l_message_text_out := pqh_utility.get_message;
1734:
1735: hr_utility.set_location('Get Message Text : '||l_message_text_out,7);

Line 1735: hr_utility.set_location('Get Message Text : '||l_message_text_out,7);

1731: hr_utility.set_location('Message Set ',6);
1732:
1733: l_message_text_out := pqh_utility.get_message;
1734:
1735: hr_utility.set_location('Get Message Text : '||l_message_text_out,7);
1736:
1737: l_message_type := pqh_utility.get_message_type_cd;
1738:
1739: hr_utility.set_location('Get Message Type : '||l_message_type,8);

Line 1739: hr_utility.set_location('Get Message Type : '||l_message_type,8);

1735: hr_utility.set_location('Get Message Text : '||l_message_text_out,7);
1736:
1737: l_message_type := pqh_utility.get_message_type_cd;
1738:
1739: hr_utility.set_location('Get Message Type : '||l_message_type,8);
1740:
1741: -- assign warning message
1742: l_message_text := l_message_text_out;
1743:

Line 1763: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);

1759: p_message_text => l_message_text
1760: );
1761: ELSE
1762: -- this is ignore
1763: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);
1764: END IF;
1765:
1766: /*
1767:

Line 1810: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);

1806: p_message_text => l_message_text
1807: );
1808: ELSE
1809: -- this is ignore
1810: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);
1811: END IF;
1812:
1813:
1814:

Line 1831: hr_utility.set_location('After check 1 ',10);

1827:
1828: END IF; -- CHECK # 1 check if SUM of percentage = 100
1829:
1830:
1831: hr_utility.set_location('After check 1 ',10);
1832:
1833:
1834: /*
1835: THIS IS DONE IN WORKSHEET DETAILS API

Line 1882: hr_utility.set_location('Leaving:'||l_proc, 10);

1878:
1879:
1880:
1881:
1882: hr_utility.set_location('Leaving:'||l_proc, 10);
1883:
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

1882: hr_utility.set_location('Leaving:'||l_proc, 10);
1883:
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1887: hr_utility.set_message_token('ROUTINE', l_proc);
1888: hr_utility.set_message_token('REASON', SQLERRM);
1889: -- end log and halt the program here
1890: raise g_error_exception;

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

1883:
1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1887: hr_utility.set_message_token('ROUTINE', l_proc);
1888: hr_utility.set_message_token('REASON', SQLERRM);
1889: -- end log and halt the program here
1890: raise g_error_exception;
1891: END check_wks_budget_elements;

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

1884: EXCEPTION
1885: WHEN OTHERS THEN
1886: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
1887: hr_utility.set_message_token('ROUTINE', l_proc);
1888: hr_utility.set_message_token('REASON', SQLERRM);
1889: -- end log and halt the program here
1890: raise g_error_exception;
1891: END check_wks_budget_elements;
1892:

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

1932:
1933:
1934: BEGIN
1935:
1936: hr_utility.set_location('Entering:'||l_proc, 5);
1937:
1938:
1939: -- CHECK # 1 check if SUM of percentage = 100
1940:

Line 1975: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);

1971: p_message_text => l_message_text
1972: );
1973: ELSE
1974: -- this is ignore
1975: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);
1976: END IF;
1977:
1978: ELSIF NVL(l_percentage_sum,0) < 100 THEN
1979:

Line 2008: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);

2004: p_message_text => l_message_text
2005: );
2006: ELSE
2007: -- this is ignore
2008: hr_utility.set_location('Message Type in wks Periods is : '||l_message_type,6);
2009: END IF;
2010:
2011: END IF; -- CHECK # 1 check if SUM of percentage = 100
2012:

Line 2083: hr_utility.set_location('Leaving:'||l_proc, 10);

2079:
2080:
2081:
2082:
2083: hr_utility.set_location('Leaving:'||l_proc, 10);
2084:
2085: EXCEPTION
2086: WHEN OTHERS THEN
2087: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

2083: hr_utility.set_location('Leaving:'||l_proc, 10);
2084:
2085: EXCEPTION
2086: WHEN OTHERS THEN
2087: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2088: hr_utility.set_message_token('ROUTINE', l_proc);
2089: hr_utility.set_message_token('REASON', SQLERRM);
2090: -- end log and halt the program here
2091: raise g_error_exception;

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

2084:
2085: EXCEPTION
2086: WHEN OTHERS THEN
2087: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2088: hr_utility.set_message_token('ROUTINE', l_proc);
2089: hr_utility.set_message_token('REASON', SQLERRM);
2090: -- end log and halt the program here
2091: raise g_error_exception;
2092: END check_wks_fund_srcs;

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

2085: EXCEPTION
2086: WHEN OTHERS THEN
2087: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2088: hr_utility.set_message_token('ROUTINE', l_proc);
2089: hr_utility.set_message_token('REASON', SQLERRM);
2090: -- end log and halt the program here
2091: raise g_error_exception;
2092: END check_wks_fund_srcs;
2093:

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

2135: WHERE position_transaction_id = p_position_transaction_id;
2136:
2137: BEGIN
2138:
2139: hr_utility.set_location('Entering:'||l_proc, 5);
2140:
2141: OPEN csr_wks_detail_rec;
2142: FETCH csr_wks_detail_rec INTO l_worksheet_details_rec;
2143: CLOSE csr_wks_detail_rec;

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

2189:
2190:
2191:
2192:
2193: hr_utility.set_location('Log Context : '||p_log_context, 100);
2194:
2195:
2196:
2197: hr_utility.set_location('Leaving:'||l_proc, 1000);

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

2193: hr_utility.set_location('Log Context : '||p_log_context, 100);
2194:
2195:
2196:
2197: hr_utility.set_location('Leaving:'||l_proc, 1000);
2198:
2199: EXCEPTION
2200: WHEN OTHERS THEN
2201: p_log_context := 'When others exception in pqwkserr.pkb.set_wks_log_context';

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

2198:
2199: EXCEPTION
2200: WHEN OTHERS THEN
2201: p_log_context := 'When others exception in pqwkserr.pkb.set_wks_log_context';
2202: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2203: hr_utility.set_message_token('ROUTINE', l_proc);
2204: hr_utility.set_message_token('REASON', SQLERRM);
2205: -- end log and halt the program here
2206: raise g_error_exception;

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

2199: EXCEPTION
2200: WHEN OTHERS THEN
2201: p_log_context := 'When others exception in pqwkserr.pkb.set_wks_log_context';
2202: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2203: hr_utility.set_message_token('ROUTINE', l_proc);
2204: hr_utility.set_message_token('REASON', SQLERRM);
2205: -- end log and halt the program here
2206: raise g_error_exception;
2207: END set_wks_log_context;

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

2200: WHEN OTHERS THEN
2201: p_log_context := 'When others exception in pqwkserr.pkb.set_wks_log_context';
2202: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2203: hr_utility.set_message_token('ROUTINE', l_proc);
2204: hr_utility.set_message_token('REASON', SQLERRM);
2205: -- end log and halt the program here
2206: raise g_error_exception;
2207: END set_wks_log_context;
2208:

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

2248: WHERE time_period_id = p_time_period_id ;
2249:
2250: BEGIN
2251:
2252: hr_utility.set_location('Entering:'||l_proc, 5);
2253:
2254: OPEN csr_wks_periods_rec;
2255: FETCH csr_wks_periods_rec INTO l_worksheet_periods_rec;
2256: CLOSE csr_wks_periods_rec;

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

2276: p_log_context := l_start_date||' - '||l_end_date;
2277:
2278:
2279:
2280: hr_utility.set_location('Log Context : '||p_log_context, 101);
2281: hr_utility.set_location('Leaving:'||l_proc, 1000);
2282:
2283: EXCEPTION
2284: WHEN OTHERS THEN

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

2277:
2278:
2279:
2280: hr_utility.set_location('Log Context : '||p_log_context, 101);
2281: hr_utility.set_location('Leaving:'||l_proc, 1000);
2282:
2283: EXCEPTION
2284: WHEN OTHERS THEN
2285: p_log_context := 'pqwkserr.pkb.set_wpr_log_context failed in when others';

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

2282:
2283: EXCEPTION
2284: WHEN OTHERS THEN
2285: p_log_context := 'pqwkserr.pkb.set_wpr_log_context failed in when others';
2286: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2287: hr_utility.set_message_token('ROUTINE', l_proc);
2288: hr_utility.set_message_token('REASON', SQLERRM);
2289: -- end log and halt the program here
2290: raise g_error_exception;

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

2283: EXCEPTION
2284: WHEN OTHERS THEN
2285: p_log_context := 'pqwkserr.pkb.set_wpr_log_context failed in when others';
2286: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2287: hr_utility.set_message_token('ROUTINE', l_proc);
2288: hr_utility.set_message_token('REASON', SQLERRM);
2289: -- end log and halt the program here
2290: raise g_error_exception;
2291: END set_wpr_log_context;

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

2284: WHEN OTHERS THEN
2285: p_log_context := 'pqwkserr.pkb.set_wpr_log_context failed in when others';
2286: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2287: hr_utility.set_message_token('ROUTINE', l_proc);
2288: hr_utility.set_message_token('REASON', SQLERRM);
2289: -- end log and halt the program here
2290: raise g_error_exception;
2291: END set_wpr_log_context;
2292:

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

2328: WHERE dflt_budget_set_id = p_dflt_budget_set_id;
2329:
2330: BEGIN
2331:
2332: hr_utility.set_location('Entering:'||l_proc, 5);
2333:
2334: OPEN csr_wks_budget_sets_rec;
2335: FETCH csr_wks_budget_sets_rec INTO l_worksheet_budget_sets_rec;
2336: CLOSE csr_wks_budget_sets_rec;

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

2341:
2342:
2343: p_log_context := l_dflt_budget_sets_rec.dflt_budget_set_name;
2344:
2345: hr_utility.set_location('Log Context : '||p_log_context, 101);
2346: hr_utility.set_location('Leaving:'||l_proc, 1000);
2347:
2348: EXCEPTION
2349: WHEN OTHERS THEN

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

2342:
2343: p_log_context := l_dflt_budget_sets_rec.dflt_budget_set_name;
2344:
2345: hr_utility.set_location('Log Context : '||p_log_context, 101);
2346: hr_utility.set_location('Leaving:'||l_proc, 1000);
2347:
2348: EXCEPTION
2349: WHEN OTHERS THEN
2350: p_log_context := 'pqwkserr.pkb.set_wst_log_context failed in when others';

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

2347:
2348: EXCEPTION
2349: WHEN OTHERS THEN
2350: p_log_context := 'pqwkserr.pkb.set_wst_log_context failed in when others';
2351: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2352: hr_utility.set_message_token('ROUTINE', l_proc);
2353: hr_utility.set_message_token('REASON', SQLERRM);
2354: -- end log and halt the program here
2355: raise g_error_exception;

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

2348: EXCEPTION
2349: WHEN OTHERS THEN
2350: p_log_context := 'pqwkserr.pkb.set_wst_log_context failed in when others';
2351: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2352: hr_utility.set_message_token('ROUTINE', l_proc);
2353: hr_utility.set_message_token('REASON', SQLERRM);
2354: -- end log and halt the program here
2355: raise g_error_exception;
2356: END set_wst_log_context;

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

2349: WHEN OTHERS THEN
2350: p_log_context := 'pqwkserr.pkb.set_wst_log_context failed in when others';
2351: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2352: hr_utility.set_message_token('ROUTINE', l_proc);
2353: hr_utility.set_message_token('REASON', SQLERRM);
2354: -- end log and halt the program here
2355: raise g_error_exception;
2356: END set_wst_log_context;
2357:

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

2412:
2413:
2414: BEGIN
2415:
2416: hr_utility.set_location('Entering:'||l_proc, 5);
2417:
2418: OPEN csr_wks_bdgt_elmnts_rec;
2419: FETCH csr_wks_bdgt_elmnts_rec INTO l_worksheet_bdgt_elmnts_rec;
2420: CLOSE csr_wks_bdgt_elmnts_rec;

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

2437: p_log_context := l_dflt_budget_sets_rec.dflt_budget_set_name;
2438:
2439: -- p_log_context := l_pay_element_types_rec.element_name;
2440:
2441: hr_utility.set_location('Log Context : '||p_log_context, 101);
2442: hr_utility.set_location('Leaving:'||l_proc, 1000);
2443:
2444: EXCEPTION
2445: WHEN OTHERS THEN

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

2438:
2439: -- p_log_context := l_pay_element_types_rec.element_name;
2440:
2441: hr_utility.set_location('Log Context : '||p_log_context, 101);
2442: hr_utility.set_location('Leaving:'||l_proc, 1000);
2443:
2444: EXCEPTION
2445: WHEN OTHERS THEN
2446: p_log_context := 'pqwkserr.pkb.set_wel_log_context failed in when others';

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

2443:
2444: EXCEPTION
2445: WHEN OTHERS THEN
2446: p_log_context := 'pqwkserr.pkb.set_wel_log_context failed in when others';
2447: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2448: hr_utility.set_message_token('ROUTINE', l_proc);
2449: hr_utility.set_message_token('REASON', SQLERRM);
2450: -- end log and halt the program here
2451: raise g_error_exception;

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

2444: EXCEPTION
2445: WHEN OTHERS THEN
2446: p_log_context := 'pqwkserr.pkb.set_wel_log_context failed in when others';
2447: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2448: hr_utility.set_message_token('ROUTINE', l_proc);
2449: hr_utility.set_message_token('REASON', SQLERRM);
2450: -- end log and halt the program here
2451: raise g_error_exception;
2452: END set_wel_log_context;

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

2445: WHEN OTHERS THEN
2446: p_log_context := 'pqwkserr.pkb.set_wel_log_context failed in when others';
2447: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2448: hr_utility.set_message_token('ROUTINE', l_proc);
2449: hr_utility.set_message_token('REASON', SQLERRM);
2450: -- end log and halt the program here
2451: raise g_error_exception;
2452: END set_wel_log_context;
2453:

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

2509:
2510:
2511: BEGIN
2512:
2513: hr_utility.set_location('Entering:'||l_proc, 5);
2514:
2515: OPEN csr_wks_bdgt_fund_srcs_rec;
2516: FETCH csr_wks_bdgt_fund_srcs_rec INTO l_worksheet_fund_srcs_rec;
2517: CLOSE csr_wks_bdgt_fund_srcs_rec;

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

2536:
2537: -- p_log_context := l_pay_cost_allocation_kf_rec.concatenated_segments;
2538:
2539:
2540: hr_utility.set_location('Log Context : '||p_log_context, 101);
2541: hr_utility.set_location('Leaving:'||l_proc, 1000);
2542:
2543: EXCEPTION
2544: WHEN OTHERS THEN

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

2537: -- p_log_context := l_pay_cost_allocation_kf_rec.concatenated_segments;
2538:
2539:
2540: hr_utility.set_location('Log Context : '||p_log_context, 101);
2541: hr_utility.set_location('Leaving:'||l_proc, 1000);
2542:
2543: EXCEPTION
2544: WHEN OTHERS THEN
2545: p_log_context := 'pqwkserr.pkb.set_wfs_log_context failed in when others';

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

2542:
2543: EXCEPTION
2544: WHEN OTHERS THEN
2545: p_log_context := 'pqwkserr.pkb.set_wfs_log_context failed in when others';
2546: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2547: hr_utility.set_message_token('ROUTINE', l_proc);
2548: hr_utility.set_message_token('REASON', SQLERRM);
2549: -- end log and halt the program here
2550: raise g_error_exception;

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

2543: EXCEPTION
2544: WHEN OTHERS THEN
2545: p_log_context := 'pqwkserr.pkb.set_wfs_log_context failed in when others';
2546: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2547: hr_utility.set_message_token('ROUTINE', l_proc);
2548: hr_utility.set_message_token('REASON', SQLERRM);
2549: -- end log and halt the program here
2550: raise g_error_exception;
2551: END set_wfs_log_context;

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

2544: WHEN OTHERS THEN
2545: p_log_context := 'pqwkserr.pkb.set_wfs_log_context failed in when others';
2546: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2547: hr_utility.set_message_token('ROUTINE', l_proc);
2548: hr_utility.set_message_token('REASON', SQLERRM);
2549: -- end log and halt the program here
2550: raise g_error_exception;
2551: END set_wfs_log_context;
2552:

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

2601:
2602:
2603: BEGIN
2604:
2605: hr_utility.set_location('Entering:'||l_proc, 5);
2606:
2607: OPEN csr_wks_details;
2608: FETCH csr_wks_details INTO l_worksheet_details_rec;
2609: CLOSE csr_wks_details;

Line 2621: hr_utility.set_location('WKS Detail Error 3 PQH_WKS_NO_PERIODS '||l_worksheet_details_rec.worksheet_detail_id,10);

2617: CLOSE csr_wks_periods_count;
2618:
2619: IF NVL(l_count,0) = 0 THEN
2620:
2621: hr_utility.set_location('WKS Detail Error 3 PQH_WKS_NO_PERIODS '||l_worksheet_details_rec.worksheet_detail_id,10);
2622:
2623: -- get message text for PQH_WKS_NO_PERIODS
2624: -- message : No Periods Defined for the budgeted entity
2625: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_NO_PERIODS');

Line 2650: hr_utility.set_location('WKS Detail Error 4 PQH_WKS_DEL_ALL_AMT '||l_worksheet_details_rec.worksheet_detail_id,10);

2646: IF ( NVL(l_worksheet_details_rec.budget_unit1_available,0) < 0 ) OR
2647: ( NVL(l_worksheet_details_rec.budget_unit2_available,0) < 0 ) OR
2648: ( NVL(l_worksheet_details_rec.budget_unit3_available,0) < 0 ) THEN
2649:
2650: hr_utility.set_location('WKS Detail Error 4 PQH_WKS_DEL_ALL_AMT '||l_worksheet_details_rec.worksheet_detail_id,10);
2651:
2652: -- get message text for PQH_WKS_DEL_ALL_AMT
2653: -- message : Budget Amount in the delegated organization exceeds the allocated amount
2654: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_DEL_ALL_AMT');

Line 2699: hr_utility.set_location('Error Flag : '||l_error_flag,10);

2695: l_error_flag := 'Y';
2696:
2697: END IF; -- End CHECK # 3 check if atleast one record under the input node is Budgeted
2698:
2699: hr_utility.set_location('Error Flag : '||l_error_flag,10);
2700:
2701: -- insert error message if l_error_flag is Y
2702: IF l_error_flag = 'Y' THEN
2703:

Line 2725: hr_utility.set_location('Leaving:'||l_proc, 10);

2721:
2722: END IF; -- insert error message if l_error_flag is Y
2723:
2724:
2725: hr_utility.set_location('Leaving:'||l_proc, 10);
2726:
2727: EXCEPTION
2728: WHEN OTHERS THEN
2729: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

2725: hr_utility.set_location('Leaving:'||l_proc, 10);
2726:
2727: EXCEPTION
2728: WHEN OTHERS THEN
2729: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2730: hr_utility.set_message_token('ROUTINE', l_proc);
2731: hr_utility.set_message_token('REASON', SQLERRM);
2732: hr_utility.raise_error;
2733: END check_input_wks_details;

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

2726:
2727: EXCEPTION
2728: WHEN OTHERS THEN
2729: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2730: hr_utility.set_message_token('ROUTINE', l_proc);
2731: hr_utility.set_message_token('REASON', SQLERRM);
2732: hr_utility.raise_error;
2733: END check_input_wks_details;
2734:

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

2727: EXCEPTION
2728: WHEN OTHERS THEN
2729: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2730: hr_utility.set_message_token('ROUTINE', l_proc);
2731: hr_utility.set_message_token('REASON', SQLERRM);
2732: hr_utility.raise_error;
2733: END check_input_wks_details;
2734:
2735:

Line 2732: hr_utility.raise_error;

2728: WHEN OTHERS THEN
2729: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2730: hr_utility.set_message_token('ROUTINE', l_proc);
2731: hr_utility.set_message_token('REASON', SQLERRM);
2732: hr_utility.raise_error;
2733: END check_input_wks_details;
2734:
2735:
2736:

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

2768:
2769:
2770: BEGIN
2771:
2772: hr_utility.set_location('Entering: '||l_proc, 5);
2773:
2774: /*
2775: Compute the status of the batch. If there exists any record in the batch with
2776: message_type_cd = 'ERROR' then the batch_status = 'ERROR'

Line 2810: hr_utility.set_location('Batch Status : '||l_status,100);

2806: END IF;
2807:
2808: END IF;
2809:
2810: hr_utility.set_location('Batch Status : '||l_status,100);
2811:
2812: /*
2813: update the 'start' record for this batch with message_type_cd = 'COMPLETE' and
2814: update the batch_end_date with current date time

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

2837: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2838: END IF;
2839:
2840:
2841: hr_utility.set_location('Leaving:'||l_proc, 1000);
2842:
2843: /*
2844: commit the transaction
2845: */

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

2848:
2849:
2850: EXCEPTION
2851: WHEN OTHERS THEN
2852: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2853: hr_utility.set_message_token('ROUTINE', l_proc);
2854: hr_utility.set_message_token('REASON', SQLERRM);
2855: hr_utility.raise_error;
2856: END end_log;

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

2849:
2850: EXCEPTION
2851: WHEN OTHERS THEN
2852: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2853: hr_utility.set_message_token('ROUTINE', l_proc);
2854: hr_utility.set_message_token('REASON', SQLERRM);
2855: hr_utility.raise_error;
2856: END end_log;
2857:

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

2850: EXCEPTION
2851: WHEN OTHERS THEN
2852: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2853: hr_utility.set_message_token('ROUTINE', l_proc);
2854: hr_utility.set_message_token('REASON', SQLERRM);
2855: hr_utility.raise_error;
2856: END end_log;
2857:
2858:

Line 2855: hr_utility.raise_error;

2851: WHEN OTHERS THEN
2852: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2853: hr_utility.set_message_token('ROUTINE', l_proc);
2854: hr_utility.set_message_token('REASON', SQLERRM);
2855: hr_utility.raise_error;
2856: END end_log;
2857:
2858:
2859:

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

2876: PRAGMA AUTONOMOUS_TRANSACTION;
2877:
2878: BEGIN
2879:
2880: hr_utility.set_location('Entering: '||l_proc, 5);
2881:
2882:
2883: UPDATE pqh_process_log
2884: SET message_type_cd = 'ERROR',

Line 2897: hr_utility.set_location('Leaving: '||l_proc, 100);

2893: */
2894:
2895: commit;
2896:
2897: hr_utility.set_location('Leaving: '||l_proc, 100);
2898:
2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

2897: hr_utility.set_location('Leaving: '||l_proc, 100);
2898:
2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2902: hr_utility.set_message_token('ROUTINE', l_proc);
2903: hr_utility.set_message_token('REASON', SQLERRM);
2904: hr_utility.raise_error;
2905: END updt_batch;

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

2898:
2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2902: hr_utility.set_message_token('ROUTINE', l_proc);
2903: hr_utility.set_message_token('REASON', SQLERRM);
2904: hr_utility.raise_error;
2905: END updt_batch;
2906:

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

2899: EXCEPTION
2900: WHEN OTHERS THEN
2901: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2902: hr_utility.set_message_token('ROUTINE', l_proc);
2903: hr_utility.set_message_token('REASON', SQLERRM);
2904: hr_utility.raise_error;
2905: END updt_batch;
2906:
2907:

Line 2904: hr_utility.raise_error;

2900: WHEN OTHERS THEN
2901: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2902: hr_utility.set_message_token('ROUTINE', l_proc);
2903: hr_utility.set_message_token('REASON', SQLERRM);
2904: hr_utility.raise_error;
2905: END updt_batch;
2906:
2907:
2908:

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

2953: WHERE budget_id = p_budget_id ;
2954:
2955: BEGIN
2956:
2957: hr_utility.set_location('Entering: '||l_proc, 5);
2958:
2959: OPEN csr_worksheet_rec;
2960: FETCH csr_worksheet_rec INTO l_worksheets_rec;
2961: CLOSE csr_worksheet_rec;

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

2988: p_status := 'SUCCESS';
2989:
2990: END IF;
2991:
2992: hr_utility.set_location('Leaving:'||l_proc, 1000);
2993:
2994: EXCEPTION
2995: WHEN OTHERS THEN
2996: p_status := 'ERROR';

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

2994: EXCEPTION
2995: WHEN OTHERS THEN
2996: p_status := 'ERROR';
2997: p_message := 'Erroring out in pqwkserr.pkb.check_wks_dates';
2998: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2999: hr_utility.set_message_token('ROUTINE', l_proc);
3000: hr_utility.set_message_token('REASON', SQLERRM);
3001: hr_utility.raise_error;
3002: END check_wks_dates;

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

2995: WHEN OTHERS THEN
2996: p_status := 'ERROR';
2997: p_message := 'Erroring out in pqwkserr.pkb.check_wks_dates';
2998: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2999: hr_utility.set_message_token('ROUTINE', l_proc);
3000: hr_utility.set_message_token('REASON', SQLERRM);
3001: hr_utility.raise_error;
3002: END check_wks_dates;
3003:

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

2996: p_status := 'ERROR';
2997: p_message := 'Erroring out in pqwkserr.pkb.check_wks_dates';
2998: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2999: hr_utility.set_message_token('ROUTINE', l_proc);
3000: hr_utility.set_message_token('REASON', SQLERRM);
3001: hr_utility.raise_error;
3002: END check_wks_dates;
3003:
3004:

Line 3001: hr_utility.raise_error;

2997: p_message := 'Erroring out in pqwkserr.pkb.check_wks_dates';
2998: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2999: hr_utility.set_message_token('ROUTINE', l_proc);
3000: hr_utility.set_message_token('REASON', SQLERRM);
3001: hr_utility.raise_error;
3002: END check_wks_dates;
3003:
3004:
3005: /*----------------------------------------------------------------

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

3051:
3052:
3053: BEGIN
3054:
3055: hr_utility.set_location('Entering: '||l_proc, 5);
3056:
3057: -- start with success and mark error if found
3058: p_status := 'SUCCESS';
3059:

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

3114: END LOOP;
3115: CLOSE csr_budget_id;
3116:
3117:
3118: hr_utility.set_location('Leaving:'||l_proc, 1000);
3119:
3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: p_status := 'ERROR';

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

3119:
3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: p_status := 'ERROR';
3123: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3124: hr_utility.set_message_token('ROUTINE', l_proc);
3125: hr_utility.set_message_token('REASON', SQLERRM);
3126: hr_utility.raise_error;
3127: END check_pc_posn;

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

3120: EXCEPTION
3121: WHEN OTHERS THEN
3122: p_status := 'ERROR';
3123: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3124: hr_utility.set_message_token('ROUTINE', l_proc);
3125: hr_utility.set_message_token('REASON', SQLERRM);
3126: hr_utility.raise_error;
3127: END check_pc_posn;
3128:

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

3121: WHEN OTHERS THEN
3122: p_status := 'ERROR';
3123: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3124: hr_utility.set_message_token('ROUTINE', l_proc);
3125: hr_utility.set_message_token('REASON', SQLERRM);
3126: hr_utility.raise_error;
3127: END check_pc_posn;
3128:
3129:

Line 3126: hr_utility.raise_error;

3122: p_status := 'ERROR';
3123: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3124: hr_utility.set_message_token('ROUTINE', l_proc);
3125: hr_utility.set_message_token('REASON', SQLERRM);
3126: hr_utility.raise_error;
3127: END check_pc_posn;
3128:
3129:
3130: