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

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

49:
50: l_wkd_rec pqh_worksheet_details%ROWTYPE;
51: l_wkd_ovn pqh_worksheet_details.object_version_number%TYPE;
52: BEGIN
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: open csr_wkd;
55: fetch csr_wkd into l_wkd_rec;
56: CLOSE csr_wkd;
57: l_wkd_ovn := l_wkd_rec.object_version_number;

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

61: ,p_object_version_number => l_wkd_ovn
62: ,p_status => p_status
63: ,p_effective_date => sysdate
64: );
65: hr_utility.set_location('Leaving:'||l_proc, 1000);
66: EXCEPTION
67: WHEN OTHERS THEN
68: hr_utility.set_location('error:'||substr(sqlerrm,1,55), 1000);
69: hr_utility.set_location('error:'||substr(sqlerrm,56,55), 1000);

Line 68: hr_utility.set_location('error:'||substr(sqlerrm,1,55), 1000);

64: );
65: hr_utility.set_location('Leaving:'||l_proc, 1000);
66: EXCEPTION
67: WHEN OTHERS THEN
68: hr_utility.set_location('error:'||substr(sqlerrm,1,55), 1000);
69: hr_utility.set_location('error:'||substr(sqlerrm,56,55), 1000);
70: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
71: hr_utility.set_message_token('ROUTINE', l_proc);
72: hr_utility.set_message_token('REASON', SQLERRM);

Line 69: hr_utility.set_location('error:'||substr(sqlerrm,56,55), 1000);

65: hr_utility.set_location('Leaving:'||l_proc, 1000);
66: EXCEPTION
67: WHEN OTHERS THEN
68: hr_utility.set_location('error:'||substr(sqlerrm,1,55), 1000);
69: hr_utility.set_location('error:'||substr(sqlerrm,56,55), 1000);
70: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
71: hr_utility.set_message_token('ROUTINE', l_proc);
72: hr_utility.set_message_token('REASON', SQLERRM);
73: hr_utility.raise_error;

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

66: EXCEPTION
67: WHEN OTHERS THEN
68: hr_utility.set_location('error:'||substr(sqlerrm,1,55), 1000);
69: hr_utility.set_location('error:'||substr(sqlerrm,56,55), 1000);
70: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
71: hr_utility.set_message_token('ROUTINE', l_proc);
72: hr_utility.set_message_token('REASON', SQLERRM);
73: hr_utility.raise_error;
74: END updt_wkd_status;

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

67: WHEN OTHERS THEN
68: hr_utility.set_location('error:'||substr(sqlerrm,1,55), 1000);
69: hr_utility.set_location('error:'||substr(sqlerrm,56,55), 1000);
70: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
71: hr_utility.set_message_token('ROUTINE', l_proc);
72: hr_utility.set_message_token('REASON', SQLERRM);
73: hr_utility.raise_error;
74: END updt_wkd_status;
75:

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

68: hr_utility.set_location('error:'||substr(sqlerrm,1,55), 1000);
69: hr_utility.set_location('error:'||substr(sqlerrm,56,55), 1000);
70: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
71: hr_utility.set_message_token('ROUTINE', l_proc);
72: hr_utility.set_message_token('REASON', SQLERRM);
73: hr_utility.raise_error;
74: END updt_wkd_status;
75:
76: --------------------------------------------------------------------------------------------------------------

Line 73: hr_utility.raise_error;

69: hr_utility.set_location('error:'||substr(sqlerrm,56,55), 1000);
70: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
71: hr_utility.set_message_token('ROUTINE', l_proc);
72: hr_utility.set_message_token('REASON', SQLERRM);
73: hr_utility.raise_error;
74: END updt_wkd_status;
75:
76: --------------------------------------------------------------------------------------------------------------
77: PROCEDURE apply_budget

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

92: l_log_context pqh_process_log.log_context%TYPE;
93:
94: BEGIN
95:
96: hr_utility.set_location('Entering: '||l_proc, 5);
97:
98: -- check the mode for the current worksheet is valid
99: -- and populate the global mode_cd variable
100: -- check that the worksheet has not been already applied

Line 118: hr_utility.set_location('Worksheet Mode : '||g_worksheet_mode_cd, 6);

114: p_worksheet_id => p_worksheet_id
115: );
116:
117:
118: hr_utility.set_location('Worksheet Mode : '||g_worksheet_mode_cd, 6);
119: hr_utility.set_location('Budget ID : '||g_budget_id, 7);
120:
121: -- Start the Log Process
122: pqh_process_batch_log.start_log

Line 119: hr_utility.set_location('Budget ID : '||g_budget_id, 7);

115: );
116:
117:
118: hr_utility.set_location('Worksheet Mode : '||g_worksheet_mode_cd, 6);
119: hr_utility.set_location('Budget ID : '||g_budget_id, 7);
120:
121: -- Start the Log Process
122: pqh_process_batch_log.start_log
123: (

Line 182: hr_utility.set_location('Invalid Worksheet Mode : '||g_worksheet_mode_cd, 7);

178: );
179:
180: ELSE
181: -- invalid mode code
182: hr_utility.set_location('Invalid Worksheet Mode : '||g_worksheet_mode_cd, 7);
183: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');
184: hr_utility.raise_error;
185: END IF;
186:

Line 183: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');

179:
180: ELSE
181: -- invalid mode code
182: hr_utility.set_location('Invalid Worksheet Mode : '||g_worksheet_mode_cd, 7);
183: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');
184: hr_utility.raise_error;
185: END IF;
186:
187: -- update the worksheet status flag to 'APPLIED

Line 184: hr_utility.raise_error;

180: ELSE
181: -- invalid mode code
182: hr_utility.set_location('Invalid Worksheet Mode : '||g_worksheet_mode_cd, 7);
183: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');
184: hr_utility.raise_error;
185: END IF;
186:
187: -- update the worksheet status flag to 'APPLIED
188: -- and updt budget_version_id

Line 195: hr_utility.set_location('worksheet updated with Applied'||l_proc, 8);

191: (
192: p_worksheet_id => p_worksheet_id ,
193: p_status => 'APPLIED'
194: );
195: hr_utility.set_location('worksheet updated with Applied'||l_proc, 8);
196:
197: updt_wkd_status
198: (
199: p_worksheet_id => p_worksheet_id ,

Line 202: hr_utility.set_location('wkd updated with Applied'||l_proc, 9);

198: (
199: p_worksheet_id => p_worksheet_id ,
200: p_status => 'APPLIED'
201: );
202: hr_utility.set_location('wkd updated with Applied'||l_proc, 9);
203:
204: -- update the status in pqh_budgets to FROZEN
205:
206:

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

218:
219: -- commit the work;
220: -- commit;
221:
222: hr_utility.set_location('Leaving:'||l_proc, 1000);
223:
224: EXCEPTION
225: WHEN g_error_exception THEN
226: -- call the end log and stop

Line 229: hr_utility.set_location('txn_cat :'||g_transaction_category_id||l_proc, 10);

225: WHEN g_error_exception THEN
226: -- call the end log and stop
227: pqh_process_batch_log.end_log;
228: -- call the wf error
229: hr_utility.set_location('txn_cat :'||g_transaction_category_id||l_proc, 10);
230: hr_utility.set_location('txn_id :'||g_root_wks_dtl_id||l_proc, 10);
231: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,
232: p_transaction_id => g_root_wks_dtl_id,
233: p_apply_error_mesg => SQLERRM,

Line 230: hr_utility.set_location('txn_id :'||g_root_wks_dtl_id||l_proc, 10);

226: -- call the end log and stop
227: pqh_process_batch_log.end_log;
228: -- call the wf error
229: hr_utility.set_location('txn_cat :'||g_transaction_category_id||l_proc, 10);
230: hr_utility.set_location('txn_id :'||g_root_wks_dtl_id||l_proc, 10);
231: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,
232: p_transaction_id => g_root_wks_dtl_id,
233: p_apply_error_mesg => SQLERRM,
234: p_apply_error_num => SQLCODE);

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

302: l_log_context pqh_process_log.log_context%TYPE;
303:
304: BEGIN
305:
306: hr_utility.set_location('Entering: '||l_proc, 5);
307: -- open the pqh_worksheets_cur
308: OPEN pqh_worksheets_cur(p_worksheet_id => p_worksheet_id);
309: LOOP -- loop 1
310: FETCH pqh_worksheets_cur INTO l_pqh_worksheets_rec;

Line 328: hr_utility.set_location('Called Apply Budget in Update Mode: '||p_mode, 6);

324:
325: ELSE
326: -- no new record in the pqh_budget_versions as this is update mode
327: -- get the current version_id
328: hr_utility.set_location('Called Apply Budget in Update Mode: '||p_mode, 6);
329: OPEN current_version_cur(p_worksheet_id => p_worksheet_id);
330: FETCH current_version_cur INTO l_curr_budget_version_id;
331: CLOSE current_version_cur;
332:

Line 338: hr_utility.set_location('Budget Version: '||g_budget_version_id, 6);

334: g_budget_version_id := l_curr_budget_version_id;
335:
336: END IF;
337:
338: hr_utility.set_location('Budget Version: '||g_budget_version_id, 6);
339:
340:
341: -- open pqh_worksheet_details_cur
342: OPEN pqh_worksheet_details_cur(p_worksheet_id => l_pqh_worksheets_rec.worksheet_id );

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

511: END LOOP; -- loop 1
512: CLOSE pqh_worksheets_cur;
513:
514:
515: hr_utility.set_location('Leaving:'||l_proc, 1000);
516:
517: EXCEPTION
518: WHEN others THEN
519: raise;

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

532: l_proc varchar2(72) := g_package||'edit_create_new_budget';
533:
534: BEGIN
535:
536: hr_utility.set_location('Entering: '||l_proc, 5);
537:
538: -- apply the existing records from worksheet tables to budget tables
539: apply_new_budget
540: (

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

553: );
554:
555: */
556:
557: hr_utility.set_location('Leaving:'||l_proc, 1000);
558:
559: EXCEPTION
560: WHEN others THEN
561: raise;

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

576: l_proc varchar2(72) := g_package||'edit_update_budget';
577:
578: BEGIN
579:
580: hr_utility.set_location('Entering: '||l_proc, 5);
581:
582: -- delete the rows from budget tables
583: /*
584: delete_child_rows

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

597: p_worksheet_id => p_worksheet_id,
598: p_mode => 'U'
599: );
600:
601: hr_utility.set_location('Leaving:'||l_proc, 1000);
602:
603: EXCEPTION
604: WHEN others THEN
605: raise;

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

657:
658:
659: BEGIN
660:
661: hr_utility.set_location('Entering: '||l_proc, 5);
662:
663: -- compute max version number
664: OPEN version_number_cur;
665: FETCH version_number_cur INTO l_max_version_number;

Line 769: hr_utility.set_location('Current Version Number : '||l_version_number, 6);

765:
766:
767: END IF;
768:
769: hr_utility.set_location('Current Version Number : '||l_version_number, 6);
770: hr_utility.set_location('Worksheet Id : '||p_worksheets_rec.worksheet_id, 7);
771: hr_utility.set_location('PQH Budget Version out nocopy '||p_budget_version_id_o, 15);
772:
773:

Line 770: hr_utility.set_location('Worksheet Id : '||p_worksheets_rec.worksheet_id, 7);

766:
767: END IF;
768:
769: hr_utility.set_location('Current Version Number : '||l_version_number, 6);
770: hr_utility.set_location('Worksheet Id : '||p_worksheets_rec.worksheet_id, 7);
771: hr_utility.set_location('PQH Budget Version out nocopy '||p_budget_version_id_o, 15);
772:
773:
774: hr_utility.set_location('Leaving:'||l_proc, 1000);

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

767: END IF;
768:
769: hr_utility.set_location('Current Version Number : '||l_version_number, 6);
770: hr_utility.set_location('Worksheet Id : '||p_worksheets_rec.worksheet_id, 7);
771: hr_utility.set_location('PQH Budget Version out nocopy '||p_budget_version_id_o, 15);
772:
773:
774: hr_utility.set_location('Leaving:'||l_proc, 1000);
775:

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

770: hr_utility.set_location('Worksheet Id : '||p_worksheets_rec.worksheet_id, 7);
771: hr_utility.set_location('PQH Budget Version out nocopy '||p_budget_version_id_o, 15);
772:
773:
774: hr_utility.set_location('Leaving:'||l_proc, 1000);
775:
776: EXCEPTION
777: WHEN others THEN
778: p_budget_version_id_o := null;

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

820: AND nvl(action_cd,'X') = 'B' ;
821:
822: BEGIN
823:
824: hr_utility.set_location('Entering: '||l_proc, 5);
825: hr_utility.set_location('Global Worksheet Mode : '||g_worksheet_mode_cd, 6);
826:
827: -- compute the unit values
828: OPEN units_csr;

Line 825: hr_utility.set_location('Global Worksheet Mode : '||g_worksheet_mode_cd, 6);

821:
822: BEGIN
823:
824: hr_utility.set_location('Entering: '||l_proc, 5);
825: hr_utility.set_location('Global Worksheet Mode : '||g_worksheet_mode_cd, 6);
826:
827: -- compute the unit values
828: OPEN units_csr;
829: FETCH units_csr INTO l_version_unit1_value, l_version_unit2_value, l_version_unit3_value;

Line 852: hr_utility.set_location('Budget Detail Id : '||p_worksheet_details_rec.budget_detail_id, 7);

848: IF g_worksheet_mode_cd = 'O' THEN
849: -- this is update to the same version
850: IF p_worksheet_details_rec.budget_detail_id IS NOT NULL THEN
851: -- update rows where p_worksheet_details_rec.budget_detail_id IS NOT NULL
852: hr_utility.set_location('Budget Detail Id : '||p_worksheet_details_rec.budget_detail_id, 7);
853:
854: -- get the object_version_number for this budget_detail_id and pass to update API
855: OPEN l_object_version_number_cur;
856: FETCH l_object_version_number_cur INTO l_object_version_number;

Line 859: hr_utility.set_location('Update API OVN : '||l_object_version_number, 8);

855: OPEN l_object_version_number_cur;
856: FETCH l_object_version_number_cur INTO l_object_version_number;
857: CLOSE l_object_version_number_cur;
858:
859: hr_utility.set_location('Update API OVN : '||l_object_version_number, 8);
860:
861: pqh_budget_details_api.update_budget_detail
862: (
863: p_validate => false

Line 890: hr_utility.set_location('Create API in update mode : ', 9);

886:
887: ELSE
888: -- for others i.e new rows call the insert API
889:
890: hr_utility.set_location('Create API in update mode : ', 9);
891:
892: pqh_budget_details_api.create_budget_detail
893: (
894: p_validate => false

Line 919: hr_utility.set_location('Create API in INSERT Mode : ', 10);

915:
916: END IF;
917: ELSE -- i.e not update mode
918: -- call insert API
919: hr_utility.set_location('Create API in INSERT Mode : ', 10);
920:
921: pqh_budget_details_api.create_budget_detail
922: (
923: p_validate => false

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

945: END IF;
946:
947: END IF; -- p_budget_version_id is not null
948:
949: hr_utility.set_location('PQH Budget Detail ID out nocopy '||p_budget_detail_id_o, 100);
950: hr_utility.set_location('Leaving:'||l_proc, 1000);
951:
952: EXCEPTION
953: WHEN others THEN

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

946:
947: END IF; -- p_budget_version_id is not null
948:
949: hr_utility.set_location('PQH Budget Detail ID out nocopy '||p_budget_detail_id_o, 100);
950: hr_utility.set_location('Leaving:'||l_proc, 1000);
951:
952: EXCEPTION
953: WHEN others THEN
954:

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

976: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
977:
978: BEGIN
979:
980: hr_utility.set_location('Entering: '||l_proc, 5);
981:
982: IF p_budget_detail_id IS NOT NULL THEN
983:
984: -- call insert API

Line 1010: hr_utility.set_location('PQH Budget Period ID out nocopy '||p_budget_period_id_o, 100);

1006:
1007:
1008: END IF; -- p_budget_detail_id is not null
1009:
1010: hr_utility.set_location('PQH Budget Period ID out nocopy '||p_budget_period_id_o, 100);
1011: hr_utility.set_location('Leaving:'||l_proc, 1000);
1012:
1013: EXCEPTION
1014: WHEN others THEN

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

1007:
1008: END IF; -- p_budget_detail_id is not null
1009:
1010: hr_utility.set_location('PQH Budget Period ID out nocopy '||p_budget_period_id_o, 100);
1011: hr_utility.set_location('Leaving:'||l_proc, 1000);
1012:
1013: EXCEPTION
1014: WHEN others THEN
1015:

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

1038: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1039:
1040: BEGIN
1041:
1042: hr_utility.set_location('Entering: '||l_proc, 5);
1043:
1044: IF p_budget_period_id IS NOT NULL THEN
1045:
1046: -- call insert API

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

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

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

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

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

1100: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1101:
1102: BEGIN
1103:
1104: hr_utility.set_location('Entering: '||l_proc, 5);
1105:
1106: IF p_budget_set_id IS NOT NULL THEN
1107:
1108: -- call insert API

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

1117: );
1118:
1119: END IF; -- p_budget_set_id is not null
1120:
1121: hr_utility.set_location('PQH Budget Element ID out nocopy '||p_budget_element_id_o, 100);
1122: hr_utility.set_location('Leaving:'||l_proc, 1000);
1123:
1124: EXCEPTION
1125: WHEN others THEN

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

1118:
1119: END IF; -- p_budget_set_id is not null
1120:
1121: hr_utility.set_location('PQH Budget Element ID out nocopy '||p_budget_element_id_o, 100);
1122: hr_utility.set_location('Leaving:'||l_proc, 1000);
1123:
1124: EXCEPTION
1125: WHEN others THEN
1126:

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

1147: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1148:
1149: BEGIN
1150:
1151: hr_utility.set_location('Entering: '||l_proc, 5);
1152:
1153: IF p_budget_element_id IS NOT NULL THEN
1154:
1155: -- call insert API

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

1169: );
1170:
1171: END IF; -- p_budget_element_id is not null
1172:
1173: hr_utility.set_location('PQH Budget Fund Src ID out nocopy '||p_budget_fund_src_id_o, 100);
1174: hr_utility.set_location('Leaving:'||l_proc, 1000);
1175:
1176: EXCEPTION
1177: WHEN others THEN

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

1170:
1171: END IF; -- p_budget_element_id is not null
1172:
1173: hr_utility.set_location('PQH Budget Fund Src ID out nocopy '||p_budget_fund_src_id_o, 100);
1174: hr_utility.set_location('Leaving:'||l_proc, 1000);
1175:
1176: EXCEPTION
1177: WHEN others THEN
1178:

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

1253: l_curr_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1254:
1255: BEGIN
1256:
1257: hr_utility.set_location('Entering: '||l_proc, 5);
1258:
1259: -- get the current version number
1260: OPEN current_version_cur(p_worksheet_id => p_worksheet_id );
1261: FETCH current_version_cur INTO l_curr_budget_version_id;

Line 1264: hr_utility.set_location('Current Version : '||l_curr_budget_version_id, 6);

1260: OPEN current_version_cur(p_worksheet_id => p_worksheet_id );
1261: FETCH current_version_cur INTO l_curr_budget_version_id;
1262: CLOSE current_version_cur;
1263:
1264: hr_utility.set_location('Current Version : '||l_curr_budget_version_id, 6);
1265:
1266: -- open the pqh_worksheets_cur
1267: OPEN pqh_worksheets_cur(p_worksheet_id => p_worksheet_id);
1268: LOOP -- loop 1

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

1354: END LOOP; -- loop 1
1355: CLOSE pqh_worksheets_cur;
1356:
1357:
1358: hr_utility.set_location('Leaving:'||l_proc, 1000);
1359:
1360: EXCEPTION
1361: WHEN others THEN
1362: raise;

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

1378:
1379:
1380: BEGIN
1381:
1382: hr_utility.set_location('Entering: '||l_proc, 5);
1383:
1384: IF p_budget_version_id IS NOT NULL THEN
1385:
1386: -- call insert API

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

1410:
1411:
1412: END IF; -- p_budget_version_id is not null
1413:
1414: hr_utility.set_location('PQH Budget Detail ID out nocopy '||p_budget_detail_id_o, 100);
1415: hr_utility.set_location('Leaving:'||l_proc, 1000);
1416:
1417: EXCEPTION
1418: WHEN others THEN

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

1411:
1412: END IF; -- p_budget_version_id is not null
1413:
1414: hr_utility.set_location('PQH Budget Detail ID out nocopy '||p_budget_detail_id_o, 100);
1415: hr_utility.set_location('Leaving:'||l_proc, 1000);
1416:
1417: EXCEPTION
1418: WHEN others THEN
1419: p_budget_detail_id_o := null;

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

1434: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1435:
1436: BEGIN
1437:
1438: hr_utility.set_location('Entering: '||l_proc, 5);
1439:
1440: IF p_budget_detail_id IS NOT NULL THEN
1441:
1442: -- call insert API

Line 1468: hr_utility.set_location('PQH Budget Period ID out nocopy '||p_budget_period_id_o, 100);

1464:
1465:
1466: END IF; -- p_budget_detail_id is not null
1467:
1468: hr_utility.set_location('PQH Budget Period ID out nocopy '||p_budget_period_id_o, 100);
1469: hr_utility.set_location('Leaving:'||l_proc, 1000);
1470:
1471: EXCEPTION
1472: WHEN others THEN

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

1465:
1466: END IF; -- p_budget_detail_id is not null
1467:
1468: hr_utility.set_location('PQH Budget Period ID out nocopy '||p_budget_period_id_o, 100);
1469: hr_utility.set_location('Leaving:'||l_proc, 1000);
1470:
1471: EXCEPTION
1472: WHEN others THEN
1473: p_budget_period_id_o := null;

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

1489: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1490:
1491: BEGIN
1492:
1493: hr_utility.set_location('Entering: '||l_proc, 5);
1494:
1495: IF p_budget_period_id IS NOT NULL THEN
1496:
1497: -- call insert API

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

1518: );
1519:
1520: END IF; -- p_budget_period_id is not null
1521:
1522: hr_utility.set_location('PQH Budget Set ID out nocopy '||p_budget_set_id_o, 100);
1523: hr_utility.set_location('Leaving:'||l_proc, 1000);
1524:
1525: EXCEPTION
1526: WHEN others THEN

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

1519:
1520: END IF; -- p_budget_period_id is not null
1521:
1522: hr_utility.set_location('PQH Budget Set ID out nocopy '||p_budget_set_id_o, 100);
1523: hr_utility.set_location('Leaving:'||l_proc, 1000);
1524:
1525: EXCEPTION
1526: WHEN others THEN
1527: p_budget_set_id_o := null;

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

1543: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1544:
1545: BEGIN
1546:
1547: hr_utility.set_location('Entering: '||l_proc, 5);
1548:
1549: IF p_budget_set_id IS NOT NULL THEN
1550:
1551: -- call insert API

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

1560: );
1561:
1562: END IF; -- p_budget_set_id is not null
1563:
1564: hr_utility.set_location('PQH Budget Element ID out nocopy '||p_budget_element_id_o, 100);
1565: hr_utility.set_location('Leaving:'||l_proc, 1000);
1566:
1567: EXCEPTION
1568: WHEN others THEN

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

1561:
1562: END IF; -- p_budget_set_id is not null
1563:
1564: hr_utility.set_location('PQH Budget Element ID out nocopy '||p_budget_element_id_o, 100);
1565: hr_utility.set_location('Leaving:'||l_proc, 1000);
1566:
1567: EXCEPTION
1568: WHEN others THEN
1569: p_budget_element_id_o := null;

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

1584: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
1585:
1586: BEGIN
1587:
1588: hr_utility.set_location('Entering: '||l_proc, 5);
1589:
1590: IF p_budget_element_id IS NOT NULL THEN
1591:
1592: -- call insert API

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

1606: );
1607:
1608: END IF; -- p_budget_element_id is not null
1609:
1610: hr_utility.set_location('PQH Budget Fund Src ID out nocopy '||p_budget_fund_src_id_o, 100);
1611: hr_utility.set_location('Leaving:'||l_proc, 1000);
1612:
1613: EXCEPTION
1614: WHEN others THEN

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

1607:
1608: END IF; -- p_budget_element_id is not null
1609:
1610: hr_utility.set_location('PQH Budget Fund Src ID out nocopy '||p_budget_fund_src_id_o, 100);
1611: hr_utility.set_location('Leaving:'||l_proc, 1000);
1612:
1613: EXCEPTION
1614: WHEN others THEN
1615: p_budget_fund_src_id_o := null;

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

1677:
1678:
1679: BEGIN
1680:
1681: hr_utility.set_location('Entering: '||l_proc, 5);
1682:
1683: -- delete from pqh_budget_fund_srcs
1684:
1685: OPEN budget_fund_src_id_cur;

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

1736: AND NVL(wdt.action_cd,'X') = 'B'
1737: AND wks.worksheet_id = p_worksheet_id
1738: );
1739: */
1740: hr_utility.set_location('Leaving:'||l_proc, 1000);
1741:
1742: EXCEPTION
1743: WHEN others THEN
1744: raise;

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

1778: l_worksheet_status pqh_worksheets.transaction_status%TYPE;
1779:
1780:
1781: BEGIN
1782: hr_utility.set_location('Entering: '||l_proc, 5);
1783:
1784: hr_utility.set_location('Worksheet ID: '||p_worksheet_id, 5);
1785:
1786: -- open pqh_worksheets_cur

Line 1784: hr_utility.set_location('Worksheet ID: '||p_worksheet_id, 5);

1780:
1781: BEGIN
1782: hr_utility.set_location('Entering: '||l_proc, 5);
1783:
1784: hr_utility.set_location('Worksheet ID: '||p_worksheet_id, 5);
1785:
1786: -- open pqh_worksheets_cur
1787: OPEN pqh_worksheets_cur (p_worksheet_id => p_worksheet_id);
1788: FETCH pqh_worksheets_cur INTO l_pqh_worksheets_rec;

Line 1797: hr_utility.set_message(8302,'PQH_WKS_APPLIED');

1793:
1794: -- check if wks already applied then abort the program
1795: l_worksheet_status := l_pqh_worksheets_rec.transaction_status;
1796: IF nvl(l_worksheet_status,'X') = 'APPLIED' THEN
1797: hr_utility.set_message(8302,'PQH_WKS_APPLIED');
1798: hr_utility.raise_error;
1799: END IF;
1800:
1801: hr_utility.set_location('Worksheet Mode : '||g_worksheet_mode_cd, 6);

Line 1798: hr_utility.raise_error;

1794: -- check if wks already applied then abort the program
1795: l_worksheet_status := l_pqh_worksheets_rec.transaction_status;
1796: IF nvl(l_worksheet_status,'X') = 'APPLIED' THEN
1797: hr_utility.set_message(8302,'PQH_WKS_APPLIED');
1798: hr_utility.raise_error;
1799: END IF;
1800:
1801: hr_utility.set_location('Worksheet Mode : '||g_worksheet_mode_cd, 6);
1802:

Line 1801: hr_utility.set_location('Worksheet Mode : '||g_worksheet_mode_cd, 6);

1797: hr_utility.set_message(8302,'PQH_WKS_APPLIED');
1798: hr_utility.raise_error;
1799: END IF;
1800:
1801: hr_utility.set_location('Worksheet Mode : '||g_worksheet_mode_cd, 6);
1802:
1803: IF l_pqh_worksheets_rec.worksheet_mode_cd = 'S' THEN
1804: -- first version no carry forward i.e NEW or
1805: -- existing version with no carry forward i.e W

Line 1831: hr_utility.set_message(8302,'PQH_INVALID_NEW_MODE');

1827: /*
1828: incorrect mode passed , give error
1829: New mode cannot have budget_detail records
1830:
1831: hr_utility.set_message(8302,'PQH_INVALID_NEW_MODE');
1832: hr_utility.raise_error;
1833: */
1834:
1835: END IF;

Line 1832: hr_utility.raise_error;

1828: incorrect mode passed , give error
1829: New mode cannot have budget_detail records
1830:
1831: hr_utility.set_message(8302,'PQH_INVALID_NEW_MODE');
1832: hr_utility.raise_error;
1833: */
1834:
1835: END IF;
1836:

Line 1856: hr_utility.set_message(8302,'PQH_INVALID_OVERRIDE_MODE');

1852: incorrect mode passed , give error
1853: New override mode must have budget_detail records
1854: */
1855:
1856: hr_utility.set_message(8302,'PQH_INVALID_OVERRIDE_MODE');
1857: hr_utility.raise_error;
1858:
1859: ELSE
1860:

Line 1857: hr_utility.raise_error;

1853: New override mode must have budget_detail records
1854: */
1855:
1856: hr_utility.set_message(8302,'PQH_INVALID_OVERRIDE_MODE');
1857: hr_utility.raise_error;
1858:
1859: ELSE
1860:
1861: g_worksheet_mode_cd := 'W';

Line 1883: hr_utility.set_message(8302,'PQH_INVALID_CARRY_MODE');

1879: incorrect mode passed , give error
1880: Carry forward mode must have budget_detail records
1881: */
1882:
1883: hr_utility.set_message(8302,'PQH_INVALID_CARRY_MODE');
1884: hr_utility.raise_error;
1885:
1886: ELSE
1887:

Line 1884: hr_utility.raise_error;

1880: Carry forward mode must have budget_detail records
1881: */
1882:
1883: hr_utility.set_message(8302,'PQH_INVALID_CARRY_MODE');
1884: hr_utility.raise_error;
1885:
1886: ELSE
1887:
1888: g_worksheet_mode_cd := 'N';

Line 1911: hr_utility.set_message(8302,'PQH_INVALID_UPDATE_MODE');

1907: incorrect mode passed , give error
1908: Carry forward mode must have budget_detail records
1909: */
1910:
1911: hr_utility.set_message(8302,'PQH_INVALID_UPDATE_MODE');
1912: hr_utility.raise_error;
1913:
1914: ELSE
1915:

Line 1912: hr_utility.raise_error;

1908: Carry forward mode must have budget_detail records
1909: */
1910:
1911: hr_utility.set_message(8302,'PQH_INVALID_UPDATE_MODE');
1912: hr_utility.raise_error;
1913:
1914: ELSE
1915:
1916: g_worksheet_mode_cd := 'O';

Line 1922: hr_utility.set_location('Invalid Worksheet Mode : '||g_worksheet_mode_cd, 7);

1918: END IF;
1919:
1920: ELSE
1921: -- invalid mode code
1922: hr_utility.set_location('Invalid Worksheet Mode : '||g_worksheet_mode_cd, 7);
1923: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');
1924: hr_utility.raise_error;
1925: END IF;
1926:

Line 1923: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');

1919:
1920: ELSE
1921: -- invalid mode code
1922: hr_utility.set_location('Invalid Worksheet Mode : '||g_worksheet_mode_cd, 7);
1923: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');
1924: hr_utility.raise_error;
1925: END IF;
1926:
1927: hr_utility.set_location('Leaving:'||l_proc, 1000);

Line 1924: hr_utility.raise_error;

1920: ELSE
1921: -- invalid mode code
1922: hr_utility.set_location('Invalid Worksheet Mode : '||g_worksheet_mode_cd, 7);
1923: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');
1924: hr_utility.raise_error;
1925: END IF;
1926:
1927: hr_utility.set_location('Leaving:'||l_proc, 1000);
1928:

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

1923: hr_utility.set_message(8302,'PQH_INVALID_WORKSHEET_MODE_CD');
1924: hr_utility.raise_error;
1925: END IF;
1926:
1927: hr_utility.set_location('Leaving:'||l_proc, 1000);
1928:
1929: EXCEPTION
1930: WHEN others THEN
1931: raise;

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

1966: WHERE table_alias = p_table_alias;
1967:
1968: BEGIN
1969:
1970: hr_utility.set_location('Entering:'||l_proc, 5);
1971:
1972: -- get budget units
1973: OPEN csr_budget_rec;
1974: FETCH csr_budget_rec INTO l_budgets_rec;

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

1975: CLOSE csr_budget_rec;
1976:
1977: g_budgeted_entity_cd := l_budgets_rec.budgeted_entity_cd;
1978:
1979: hr_utility.set_location('budgeted_entity_cd: '||g_budgeted_entity_cd, 21);
1980:
1981:
1982: -- get worksheet mode
1983: OPEN csr_worksheet_rec;

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

1987: g_worksheet_name := l_worksheets_rec.worksheet_name;
1988: g_worksheet_id := p_worksheet_id;
1989: g_transaction_category_id := l_worksheets_rec.wf_transaction_category_id;
1990:
1991: hr_utility.set_location('worksheet_name: '||g_worksheet_name, 30);
1992: hr_utility.set_location('worksheet_id: '||g_worksheet_id, 40);
1993: hr_utility.set_location('g_transaction_category_id: '||g_transaction_category_id, 45);
1994:
1995: -- get table_route_id for all the 7 worksheet tables

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

1988: g_worksheet_id := p_worksheet_id;
1989: g_transaction_category_id := l_worksheets_rec.wf_transaction_category_id;
1990:
1991: hr_utility.set_location('worksheet_name: '||g_worksheet_name, 30);
1992: hr_utility.set_location('worksheet_id: '||g_worksheet_id, 40);
1993: hr_utility.set_location('g_transaction_category_id: '||g_transaction_category_id, 45);
1994:
1995: -- get table_route_id for all the 7 worksheet tables
1996:

Line 1993: hr_utility.set_location('g_transaction_category_id: '||g_transaction_category_id, 45);

1989: g_transaction_category_id := l_worksheets_rec.wf_transaction_category_id;
1990:
1991: hr_utility.set_location('worksheet_name: '||g_worksheet_name, 30);
1992: hr_utility.set_location('worksheet_id: '||g_worksheet_id, 40);
1993: hr_utility.set_location('g_transaction_category_id: '||g_transaction_category_id, 45);
1994:
1995: -- get table_route_id for all the 7 worksheet tables
1996:
1997: -- table_route_id for pqh_worksheets

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

2023: OPEN csr_table_route (p_table_alias => 'WFS');
2024: FETCH csr_table_route INTO g_table_route_id_wfs;
2025: CLOSE csr_table_route;
2026:
2027: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
2028: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
2029: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
2030: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
2031: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);

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

2024: FETCH csr_table_route INTO g_table_route_id_wfs;
2025: CLOSE csr_table_route;
2026:
2027: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
2028: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
2029: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
2030: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
2031: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
2032:

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

2025: CLOSE csr_table_route;
2026:
2027: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
2028: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
2029: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
2030: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
2031: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
2032:
2033: hr_utility.set_location('Leaving:'||l_proc, 1000);

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

2026:
2027: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
2028: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
2029: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
2030: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
2031: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
2032:
2033: hr_utility.set_location('Leaving:'||l_proc, 1000);
2034:

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

2027: hr_utility.set_location('g_table_route_id_wdt: '||g_table_route_id_wdt, 50);
2028: hr_utility.set_location('g_table_route_id_wpr: '||g_table_route_id_wpr, 60);
2029: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
2030: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
2031: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
2032:
2033: hr_utility.set_location('Leaving:'||l_proc, 1000);
2034:
2035: EXCEPTION

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

2029: hr_utility.set_location('g_table_route_id_wst: '||g_table_route_id_wst, 70);
2030: hr_utility.set_location('g_table_route_id_wel: '||g_table_route_id_wel, 80);
2031: hr_utility.set_location('g_table_route_id_wfs: '||g_table_route_id_wfs, 90);
2032:
2033: hr_utility.set_location('Leaving:'||l_proc, 1000);
2034:
2035: EXCEPTION
2036: WHEN OTHERS THEN
2037: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

2033: hr_utility.set_location('Leaving:'||l_proc, 1000);
2034:
2035: EXCEPTION
2036: WHEN OTHERS THEN
2037: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2038: hr_utility.set_message_token('ROUTINE', l_proc);
2039: hr_utility.set_message_token('REASON', SQLERRM);
2040: -- end log and halt the program here
2041: raise g_error_exception;

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

2034:
2035: EXCEPTION
2036: WHEN OTHERS THEN
2037: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2038: hr_utility.set_message_token('ROUTINE', l_proc);
2039: hr_utility.set_message_token('REASON', SQLERRM);
2040: -- end log and halt the program here
2041: raise g_error_exception;
2042:

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

2035: EXCEPTION
2036: WHEN OTHERS THEN
2037: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2038: hr_utility.set_message_token('ROUTINE', l_proc);
2039: hr_utility.set_message_token('REASON', SQLERRM);
2040: -- end log and halt the program here
2041: raise g_error_exception;
2042:
2043: END populate_globals;

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

2070: WHERE worksheet_detail_id = p_worksheet_detail_id ;
2071:
2072: BEGIN
2073:
2074: hr_utility.set_location('Entering:'||l_proc, 5);
2075:
2076: OPEN csr_wks_detail_rec;
2077: FETCH csr_wks_detail_rec INTO l_worksheet_details_rec;
2078: CLOSE csr_wks_detail_rec;

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

2113:
2114: END IF;
2115: END IF;
2116:
2117: hr_utility.set_location('Log Context : '||p_log_context, 100);
2118: hr_utility.set_location('Leaving:'||l_proc, 1000);
2119:
2120: EXCEPTION
2121: WHEN OTHERS THEN

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

2114: END IF;
2115: END IF;
2116:
2117: hr_utility.set_location('Log Context : '||p_log_context, 100);
2118: hr_utility.set_location('Leaving:'||l_proc, 1000);
2119:
2120: EXCEPTION
2121: WHEN OTHERS THEN
2122:

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

2120: EXCEPTION
2121: WHEN OTHERS THEN
2122:
2123: p_log_context := null;
2124: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2125: hr_utility.set_message_token('ROUTINE', l_proc);
2126: hr_utility.set_message_token('REASON', SQLERRM);
2127: -- end log and halt the program here
2128: raise g_error_exception;

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

2121: WHEN OTHERS THEN
2122:
2123: p_log_context := null;
2124: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2125: hr_utility.set_message_token('ROUTINE', l_proc);
2126: hr_utility.set_message_token('REASON', SQLERRM);
2127: -- end log and halt the program here
2128: raise g_error_exception;
2129: END set_wks_log_context;

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

2122:
2123: p_log_context := null;
2124: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2125: hr_utility.set_message_token('ROUTINE', l_proc);
2126: hr_utility.set_message_token('REASON', SQLERRM);
2127: -- end log and halt the program here
2128: raise g_error_exception;
2129: END set_wks_log_context;
2130: --------------------------------------------------------------------------------------------------------------

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

2159: WHERE time_period_id = p_time_period_id ;
2160:
2161: BEGIN
2162:
2163: hr_utility.set_location('Entering:'||l_proc, 5);
2164:
2165: OPEN csr_wks_periods_rec;
2166: FETCH csr_wks_periods_rec INTO l_worksheet_periods_rec;
2167: CLOSE csr_wks_periods_rec;

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

2185: -- set log context
2186:
2187: p_log_context := l_start_date||' - '||l_end_date;
2188:
2189: hr_utility.set_location('Log Context : '||p_log_context, 101);
2190: hr_utility.set_location('Leaving:'||l_proc, 1000);
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN

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

2186:
2187: p_log_context := l_start_date||' - '||l_end_date;
2188:
2189: hr_utility.set_location('Log Context : '||p_log_context, 101);
2190: hr_utility.set_location('Leaving:'||l_proc, 1000);
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194:

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

2192: EXCEPTION
2193: WHEN OTHERS THEN
2194:
2195: p_log_context := null;
2196: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2197: hr_utility.set_message_token('ROUTINE', l_proc);
2198: hr_utility.set_message_token('REASON', SQLERRM);
2199: -- end log and halt the program here
2200: raise g_error_exception;

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

2193: WHEN OTHERS THEN
2194:
2195: p_log_context := null;
2196: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2197: hr_utility.set_message_token('ROUTINE', l_proc);
2198: hr_utility.set_message_token('REASON', SQLERRM);
2199: -- end log and halt the program here
2200: raise g_error_exception;
2201: END set_wpr_log_context;

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

2194:
2195: p_log_context := null;
2196: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2197: hr_utility.set_message_token('ROUTINE', l_proc);
2198: hr_utility.set_message_token('REASON', SQLERRM);
2199: -- end log and halt the program here
2200: raise g_error_exception;
2201: END set_wpr_log_context;
2202:

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

2231: WHERE dflt_budget_set_id = p_dflt_budget_set_id;
2232:
2233: BEGIN
2234:
2235: hr_utility.set_location('Entering:'||l_proc, 5);
2236:
2237: OPEN csr_wks_budget_sets_rec;
2238: FETCH csr_wks_budget_sets_rec INTO l_worksheet_budget_sets_rec;
2239: CLOSE csr_wks_budget_sets_rec;

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

2243: CLOSE csr_dflt_budget_sets_rec;
2244:
2245: p_log_context := l_dflt_budget_sets_rec.dflt_budget_set_name;
2246:
2247: hr_utility.set_location('Log Context : '||p_log_context, 101);
2248: hr_utility.set_location('Leaving:'||l_proc, 1000);
2249:
2250: EXCEPTION
2251: WHEN OTHERS THEN

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

2244:
2245: p_log_context := l_dflt_budget_sets_rec.dflt_budget_set_name;
2246:
2247: hr_utility.set_location('Log Context : '||p_log_context, 101);
2248: hr_utility.set_location('Leaving:'||l_proc, 1000);
2249:
2250: EXCEPTION
2251: WHEN OTHERS THEN
2252: p_log_context := null;

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

2249:
2250: EXCEPTION
2251: WHEN OTHERS THEN
2252: p_log_context := null;
2253: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2254: hr_utility.set_message_token('ROUTINE', l_proc);
2255: hr_utility.set_message_token('REASON', SQLERRM);
2256: -- end log and halt the program here
2257: raise g_error_exception;

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

2250: EXCEPTION
2251: WHEN OTHERS THEN
2252: p_log_context := null;
2253: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2254: hr_utility.set_message_token('ROUTINE', l_proc);
2255: hr_utility.set_message_token('REASON', SQLERRM);
2256: -- end log and halt the program here
2257: raise g_error_exception;
2258: END set_wst_log_context;

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

2251: WHEN OTHERS THEN
2252: p_log_context := null;
2253: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2254: hr_utility.set_message_token('ROUTINE', l_proc);
2255: hr_utility.set_message_token('REASON', SQLERRM);
2256: -- end log and halt the program here
2257: raise g_error_exception;
2258: END set_wst_log_context;
2259:

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

2289: l_pay_element_types_rec csr_pay_element_types_rec%ROWTYPE;
2290:
2291: BEGIN
2292:
2293: hr_utility.set_location('Entering:'||l_proc, 5);
2294:
2295: OPEN csr_wks_bdgt_elmnts_rec;
2296: FETCH csr_wks_bdgt_elmnts_rec INTO l_worksheet_bdgt_elmnts_rec;
2297: CLOSE csr_wks_bdgt_elmnts_rec;

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

2301: CLOSE csr_pay_element_types_rec;
2302:
2303: p_log_context := l_pay_element_types_rec.element_name;
2304:
2305: hr_utility.set_location('Log Context : '||p_log_context, 101);
2306: hr_utility.set_location('Leaving:'||l_proc, 1000);
2307:
2308:
2309: EXCEPTION

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

2302:
2303: p_log_context := l_pay_element_types_rec.element_name;
2304:
2305: hr_utility.set_location('Log Context : '||p_log_context, 101);
2306: hr_utility.set_location('Leaving:'||l_proc, 1000);
2307:
2308:
2309: EXCEPTION
2310: WHEN OTHERS THEN

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

2308:
2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: p_log_context := null;
2312: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2313: hr_utility.set_message_token('ROUTINE', l_proc);
2314: hr_utility.set_message_token('REASON', SQLERRM);
2315: -- end log and halt the program here
2316: raise g_error_exception;

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

2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: p_log_context := null;
2312: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2313: hr_utility.set_message_token('ROUTINE', l_proc);
2314: hr_utility.set_message_token('REASON', SQLERRM);
2315: -- end log and halt the program here
2316: raise g_error_exception;
2317: END set_wel_log_context;

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

2310: WHEN OTHERS THEN
2311: p_log_context := null;
2312: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2313: hr_utility.set_message_token('ROUTINE', l_proc);
2314: hr_utility.set_message_token('REASON', SQLERRM);
2315: -- end log and halt the program here
2316: raise g_error_exception;
2317: END set_wel_log_context;
2318:

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

2347: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
2348:
2349: BEGIN
2350:
2351: hr_utility.set_location('Entering:'||l_proc, 5);
2352:
2353: OPEN csr_wks_bdgt_fund_srcs_rec;
2354: FETCH csr_wks_bdgt_fund_srcs_rec INTO l_worksheet_fund_srcs_rec;
2355: CLOSE csr_wks_bdgt_fund_srcs_rec;

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

2361:
2362: p_log_context := l_pay_cost_allocation_kf_rec.concatenated_segments;
2363:
2364:
2365: hr_utility.set_location('Log Context : '||p_log_context, 101);
2366: hr_utility.set_location('Leaving:'||l_proc, 1000);
2367:
2368: EXCEPTION
2369: WHEN OTHERS THEN

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

2362: p_log_context := l_pay_cost_allocation_kf_rec.concatenated_segments;
2363:
2364:
2365: hr_utility.set_location('Log Context : '||p_log_context, 101);
2366: hr_utility.set_location('Leaving:'||l_proc, 1000);
2367:
2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: p_log_context := null;

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

2367:
2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: p_log_context := null;
2371: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2372: hr_utility.set_message_token('ROUTINE', l_proc);
2373: hr_utility.set_message_token('REASON', SQLERRM);
2374: -- end log and halt the program here
2375: raise g_error_exception;

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

2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: p_log_context := null;
2371: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2372: hr_utility.set_message_token('ROUTINE', l_proc);
2373: hr_utility.set_message_token('REASON', SQLERRM);
2374: -- end log and halt the program here
2375: raise g_error_exception;
2376: END set_wfs_log_context;

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

2369: WHEN OTHERS THEN
2370: p_log_context := null;
2371: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2372: hr_utility.set_message_token('ROUTINE', l_proc);
2373: hr_utility.set_message_token('REASON', SQLERRM);
2374: -- end log and halt the program here
2375: raise g_error_exception;
2376: END set_wfs_log_context;
2377:

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

2442: and wkd.worksheet_detail_id = p_transaction_id;
2443:
2444: BEGIN
2445:
2446: hr_utility.set_location('Entering:'||l_proc, 5);
2447:
2448: -- populate global variable g_root_wks_dtl_id and g_transaction_category_id
2449: g_root_wks_dtl_id := p_transaction_id;
2450:

Line 2468: hr_utility.set_location('Chk Wks Status : '||l_status,10);

2464: p_worksheet_detail_id => p_transaction_id,
2465: p_status => l_status
2466: );
2467:
2468: hr_utility.set_location('Chk Wks Status : '||l_status,10);
2469: hr_utility.set_location('Validate Only flag : '||p_validate_only,15);
2470:
2471: -- if p_validate_only = 'NO' and the above chk was successful i.e
2472: -- l_status = SUCCESS then call apply budget

Line 2469: hr_utility.set_location('Validate Only flag : '||p_validate_only,15);

2465: p_status => l_status
2466: );
2467:
2468: hr_utility.set_location('Chk Wks Status : '||l_status,10);
2469: hr_utility.set_location('Validate Only flag : '||p_validate_only,15);
2470:
2471: -- if p_validate_only = 'NO' and the above chk was successful i.e
2472: -- l_status = SUCCESS then call apply budget
2473:

Line 2487: hr_utility.set_location('Changing WKS Status with WKS ID : '||l_wks_detail_rec.worksheet_id,20);

2483: OPEN csr_wks_dtl_rec;
2484: FETCH csr_wks_dtl_rec INTO l_wks_detail_rec;
2485: CLOSE csr_wks_dtl_rec;
2486:
2487: hr_utility.set_location('Changing WKS Status with WKS ID : '||l_wks_detail_rec.worksheet_id,20);
2488:
2489: -- this is done by Sumit in PQHWSWKS form for txn state = 'I'
2490: -- if txn state = 'D' then update here
2491:

Line 2513: hr_utility.set_location('wks changed with approved '||l_proc,23);

2509: p_worksheet_id => l_wks_detail_rec.worksheet_id,
2510: p_status => 'APPROVED'
2511: );
2512:
2513: hr_utility.set_location('wks changed with approved '||l_proc,23);
2514: updt_wkd_status
2515: (
2516: p_worksheet_id => l_wks_detail_rec.worksheet_id,
2517: p_status => 'APPROVED'

Line 2519: hr_utility.set_location('wkd changed with approved '||l_proc,26);

2515: (
2516: p_worksheet_id => l_wks_detail_rec.worksheet_id,
2517: p_status => 'APPROVED'
2518: );
2519: hr_utility.set_location('wkd changed with approved '||l_proc,26);
2520: END IF; -- for defered txn state
2521:
2522:
2523: END IF; -- not in validate mode and errors

Line 2532: hr_utility.set_location('dberror returned ',18);

2528: p_transaction_id => g_root_wks_dtl_id,
2529: p_apply_error_mesg => 'PQH_WKS_CHK_ERRORS',
2530: p_apply_error_num => '1');
2531:
2532: hr_utility.set_location('dberror returned ',18);
2533: RETURN 'FAILURE';
2534:
2535: END IF;
2536:

Line 2546: hr_utility.set_location('Calling Apply Budget with WKS ID : '||l_wks_detail_rec.worksheet_id,20);

2542: OPEN csr_wks_dtl_rec;
2543: FETCH csr_wks_dtl_rec INTO l_wks_detail_rec;
2544: CLOSE csr_wks_dtl_rec;
2545:
2546: hr_utility.set_location('Calling Apply Budget with WKS ID : '||l_wks_detail_rec.worksheet_id,20);
2547:
2548: -- create savepoint
2549:
2550: savepoint s1;

Line 2558: hr_utility.set_location('Called Apply Budget, Budget Version ID is '||l_budget_version_id,20);

2554: p_worksheet_id => l_wks_detail_rec.worksheet_id,
2555: p_budget_version_id => l_budget_version_id
2556: );
2557:
2558: hr_utility.set_location('Called Apply Budget, Budget Version ID is '||l_budget_version_id,20);
2559:
2560: --
2561: -- check if the budget can be transfered to GL , if so POST the budget to GL
2562: --

Line 2570: hr_utility.set_location('Budget ID is '||l_budget_id, 21);

2566: CLOSE csr_wks;
2567:
2568: l_budget_id := l_pqh_worksheets_rec.budget_id;
2569:
2570: hr_utility.set_location('Budget ID is '||l_budget_id, 21);
2571:
2572: -- get the budget characteristics
2573: OPEN csr_budget_rec(p_budget_id => l_budget_id);
2574: FETCH csr_budget_rec INTO l_budget_rec;

Line 2581: hr_utility.set_location('Calling GL Posting Validate Budget Version ID : '||l_budget_version_id,25);

2577: -- if the budget can be transfered to GL then validate do the validations before posting
2578: -- budget should be marked for transfer to GL and it should not be marked as psb_budget
2579: IF NVL(l_budget_rec.transfer_to_gl_flag,'N') = 'Y' and l_budget_rec.psb_budget_flag<> 'Y' THEN
2580:
2581: hr_utility.set_location('Calling GL Posting Validate Budget Version ID : '||l_budget_version_id,25);
2582: pqh_gl_posting.post_budget
2583: ( p_budget_version_id => l_budget_version_id,
2584: p_validate => true ,
2585: p_status => l_gl_validation

Line 2591: hr_utility.set_location('Calling GL Posting Conc Program ',26);

2587:
2588: -- if the validations are successful call the gl posting program
2589: IF NVL(l_gl_validation,'ERROR') = 'SUCCESS' THEN
2590:
2591: hr_utility.set_location('Calling GL Posting Conc Program ',26);
2592: l_req := fnd_request.submit_request
2593: (application => 'PQH',
2594: program => 'PQHGLPOST' ,
2595: argument1 => l_budget_version_id

Line 2602: hr_utility.set_location('Conc Program could not be submittted '||l_req, 27);

2598: IF NVL(l_req,0) = 0 THEN
2599: -- conc program could not be submitted
2600: -- ROLLBACK HERE up to Savepoint s1 AND THEN PASS CONTROL TO FORM
2601: rollback to s1;
2602: hr_utility.set_location('Conc Program could not be submittted '||l_req, 27);
2603: -- set the error message to see the process log
2604: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,
2605: p_transaction_id => g_root_wks_dtl_id,
2606: p_apply_error_mesg => 'PQH_CONC_GL_PGM',

Line 2609: hr_utility.set_location('dberror returned ',27);

2605: p_transaction_id => g_root_wks_dtl_id,
2606: p_apply_error_mesg => 'PQH_CONC_GL_PGM',
2607: p_apply_error_num => '3');
2608:
2609: hr_utility.set_location('dberror returned ',27);
2610: l_return := 'FAILURE';
2611: ELSE
2612: hr_utility.set_location('Submitted GL Post Conc Pgm Request '||l_req, 27);
2613: END IF; -- conc program submit failed

Line 2612: hr_utility.set_location('Submitted GL Post Conc Pgm Request '||l_req, 27);

2608:
2609: hr_utility.set_location('dberror returned ',27);
2610: l_return := 'FAILURE';
2611: ELSE
2612: hr_utility.set_location('Submitted GL Post Conc Pgm Request '||l_req, 27);
2613: END IF; -- conc program submit failed
2614: ELSE
2615: -- there were errors in gl validation, return error for rollback
2616: -- ROLLBACK HERE up to Savepoint s1 AND THEN PASS CONTROL TO FORM

Line 2618: hr_utility.set_location('GL Validation Failed ',26);

2614: ELSE
2615: -- there were errors in gl validation, return error for rollback
2616: -- ROLLBACK HERE up to Savepoint s1 AND THEN PASS CONTROL TO FORM
2617: rollback to s1;
2618: hr_utility.set_location('GL Validation Failed ',26);
2619: -- set the error message to see the process log
2620: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,
2621: p_transaction_id => g_root_wks_dtl_id,
2622: p_apply_error_mesg => 'PQH_GL_VAL_ERR',

Line 2625: hr_utility.set_location('dberror returned ',27);

2621: p_transaction_id => g_root_wks_dtl_id,
2622: p_apply_error_mesg => 'PQH_GL_VAL_ERR',
2623: p_apply_error_num => '3');
2624:
2625: hr_utility.set_location('dberror returned ',27);
2626: l_return := 'FAILURE';
2627: END IF;
2628: END IF; -- transfer_to_gl_flag is Y or psb_budget
2629:

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

2627: END IF;
2628: END IF; -- transfer_to_gl_flag is Y or psb_budget
2629:
2630: END IF; -- p_validate_only = 'NO' AND l_status = 'SUCCESS'
2631: hr_utility.set_location('Leaving:'||l_proc, 1000);
2632: return l_return;
2633:
2634: EXCEPTION
2635: WHEN OTHERS THEN

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

2632: return l_return;
2633:
2634: EXCEPTION
2635: WHEN OTHERS THEN
2636: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2637: hr_utility.set_message_token('ROUTINE', l_proc);
2638: hr_utility.set_message_token('REASON', SQLERRM);
2639: -- rollback to s1;
2640: return 'FAILURE';

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

2633:
2634: EXCEPTION
2635: WHEN OTHERS THEN
2636: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2637: hr_utility.set_message_token('ROUTINE', l_proc);
2638: hr_utility.set_message_token('REASON', SQLERRM);
2639: -- rollback to s1;
2640: return 'FAILURE';
2641: hr_utility.raise_error;

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

2634: EXCEPTION
2635: WHEN OTHERS THEN
2636: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2637: hr_utility.set_message_token('ROUTINE', l_proc);
2638: hr_utility.set_message_token('REASON', SQLERRM);
2639: -- rollback to s1;
2640: return 'FAILURE';
2641: hr_utility.raise_error;
2642: END apply_transaction;

Line 2641: hr_utility.raise_error;

2637: hr_utility.set_message_token('ROUTINE', l_proc);
2638: hr_utility.set_message_token('REASON', SQLERRM);
2639: -- rollback to s1;
2640: return 'FAILURE';
2641: hr_utility.raise_error;
2642: END apply_transaction;
2643:
2644: --------------------------------------------------------------------------------------------------------------
2645: PROCEDURE comp_bgt_ver_unit_val

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

2682: l_pqh_worksheets_rec pqh_worksheets%ROWTYPE;
2683:
2684:
2685: BEGIN
2686: hr_utility.set_location('Entering:'||l_proc, 5);
2687:
2688: -- compute the unit values
2689: OPEN units_csr;
2690: FETCH units_csr INTO l_budget_unit1_value, l_budget_unit2_value, l_budget_unit3_value;

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

2724: ,p_effective_date => sysdate
2725: );
2726:
2727:
2728: hr_utility.set_location('Leaving:'||l_proc, 1000);
2729:
2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

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

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

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

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

2730: EXCEPTION
2731: WHEN OTHERS THEN
2732: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2733: hr_utility.set_message_token('ROUTINE', l_proc);
2734: hr_utility.set_message_token('REASON', SQLERRM);
2735: hr_utility.raise_error;
2736: END comp_bgt_ver_unit_val;
2737: --------------------------------------------------------------------------------------------------------------
2738:

Line 2735: hr_utility.raise_error;

2731: WHEN OTHERS THEN
2732: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2733: hr_utility.set_message_token('ROUTINE', l_proc);
2734: hr_utility.set_message_token('REASON', SQLERRM);
2735: hr_utility.raise_error;
2736: END comp_bgt_ver_unit_val;
2737: --------------------------------------------------------------------------------------------------------------
2738:
2739: PROCEDURE updt_budget_status

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

2756: l_budget_rec pqh_budgets%ROWTYPE;
2757: l_object_version_number pqh_budgets.object_version_number%TYPE;
2758:
2759: BEGIN
2760: hr_utility.set_location('Entering:'||l_proc, 5);
2761:
2762: OPEN csr_budget;
2763: LOOP
2764: FETCH csr_budget INTO l_budget_rec;

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

2780: END LOOP;
2781: CLOSE csr_budget;
2782:
2783:
2784: hr_utility.set_location('Leaving:'||l_proc, 1000);
2785:
2786: EXCEPTION
2787: WHEN OTHERS THEN
2788: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

2784: hr_utility.set_location('Leaving:'||l_proc, 1000);
2785:
2786: EXCEPTION
2787: WHEN OTHERS THEN
2788: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2789: hr_utility.set_message_token('ROUTINE', l_proc);
2790: hr_utility.set_message_token('REASON', SQLERRM);
2791: hr_utility.raise_error;
2792: END updt_budget_status;

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

2785:
2786: EXCEPTION
2787: WHEN OTHERS THEN
2788: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2789: hr_utility.set_message_token('ROUTINE', l_proc);
2790: hr_utility.set_message_token('REASON', SQLERRM);
2791: hr_utility.raise_error;
2792: END updt_budget_status;
2793:

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

2786: EXCEPTION
2787: WHEN OTHERS THEN
2788: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2789: hr_utility.set_message_token('ROUTINE', l_proc);
2790: hr_utility.set_message_token('REASON', SQLERRM);
2791: hr_utility.raise_error;
2792: END updt_budget_status;
2793:
2794:

Line 2791: hr_utility.raise_error;

2787: WHEN OTHERS THEN
2788: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2789: hr_utility.set_message_token('ROUTINE', l_proc);
2790: hr_utility.set_message_token('REASON', SQLERRM);
2791: hr_utility.raise_error;
2792: END updt_budget_status;
2793:
2794:
2795:

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

2819: l_wks_rec pqh_worksheets%ROWTYPE;
2820: l_wks_ovn pqh_worksheets.object_version_number%TYPE;
2821:
2822: BEGIN
2823: hr_utility.set_location('Entering:'||l_proc, 5);
2824:
2825: OPEN csr_wks;
2826: LOOP
2827: FETCH csr_wks INTO l_wks_rec;

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

2858: END LOOP;
2859: CLOSE csr_wks;
2860:
2861:
2862: hr_utility.set_location('Leaving:'||l_proc, 1000);
2863:
2864: EXCEPTION
2865: WHEN OTHERS THEN
2866: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

2862: hr_utility.set_location('Leaving:'||l_proc, 1000);
2863:
2864: EXCEPTION
2865: WHEN OTHERS THEN
2866: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2867: hr_utility.set_message_token('ROUTINE', l_proc);
2868: hr_utility.set_message_token('REASON', SQLERRM);
2869: hr_utility.raise_error;
2870: END updt_wks_status;

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

2863:
2864: EXCEPTION
2865: WHEN OTHERS THEN
2866: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2867: hr_utility.set_message_token('ROUTINE', l_proc);
2868: hr_utility.set_message_token('REASON', SQLERRM);
2869: hr_utility.raise_error;
2870: END updt_wks_status;
2871:

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

2864: EXCEPTION
2865: WHEN OTHERS THEN
2866: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2867: hr_utility.set_message_token('ROUTINE', l_proc);
2868: hr_utility.set_message_token('REASON', SQLERRM);
2869: hr_utility.raise_error;
2870: END updt_wks_status;
2871:
2872: --------------------------------------------------------------------------------------------------------------

Line 2869: hr_utility.raise_error;

2865: WHEN OTHERS THEN
2866: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2867: hr_utility.set_message_token('ROUTINE', l_proc);
2868: hr_utility.set_message_token('REASON', SQLERRM);
2869: hr_utility.raise_error;
2870: END updt_wks_status;
2871:
2872: --------------------------------------------------------------------------------------------------------------
2873: FUNCTION get_txn_state

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

2921: WHERE transaction_category_id = p_transaction_category_id;
2922:
2923:
2924: BEGIN
2925: hr_utility.set_location('Entering:'||l_proc, 5);
2926:
2927: OPEN csr_txn_cat_id;
2928: FETCH csr_txn_cat_id INTO l_transaction_categories_rec;
2929: CLOSE csr_txn_cat_id;

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

2944: END IF;
2945:
2946:
2947:
2948: hr_utility.set_location('Leaving:'||l_proc, 1000);
2949:
2950: RETURN 'D';
2951:
2952: EXCEPTION

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

2950: RETURN 'D';
2951:
2952: EXCEPTION
2953: WHEN OTHERS THEN
2954: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2955: hr_utility.set_message_token('ROUTINE', l_proc);
2956: hr_utility.set_message_token('REASON', SQLERRM);
2957: hr_utility.raise_error;
2958: END get_txn_state;

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

2951:
2952: EXCEPTION
2953: WHEN OTHERS THEN
2954: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2955: hr_utility.set_message_token('ROUTINE', l_proc);
2956: hr_utility.set_message_token('REASON', SQLERRM);
2957: hr_utility.raise_error;
2958: END get_txn_state;
2959: --------------------------------------------------------------------------------------------------------------

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

2952: EXCEPTION
2953: WHEN OTHERS THEN
2954: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2955: hr_utility.set_message_token('ROUTINE', l_proc);
2956: hr_utility.set_message_token('REASON', SQLERRM);
2957: hr_utility.raise_error;
2958: END get_txn_state;
2959: --------------------------------------------------------------------------------------------------------------
2960:

Line 2957: hr_utility.raise_error;

2953: WHEN OTHERS THEN
2954: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
2955: hr_utility.set_message_token('ROUTINE', l_proc);
2956: hr_utility.set_message_token('REASON', SQLERRM);
2957: hr_utility.raise_error;
2958: END get_txn_state;
2959: --------------------------------------------------------------------------------------------------------------
2960:
2961:

Line 3009: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');

3005: BEGIN
3006: open c1;
3007: fetch c1 into l_parent_id;
3008: if c1%notfound then
3009: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');
3010: hr_utility.raise_error;
3011: end if;
3012: close c1;
3013: if l_parent_id is null then

Line 3010: hr_utility.raise_error;

3006: open c1;
3007: fetch c1 into l_parent_id;
3008: if c1%notfound then
3009: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');
3010: hr_utility.raise_error;
3011: end if;
3012: close c1;
3013: if l_parent_id is null then
3014: l_result := 'ROOT' ;

Line 3054: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');

3050: update pqh_worksheet_details
3051: set status = 'APPROVED'
3052: where current of c1;
3053: else
3054: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');
3055: hr_utility.raise_error;
3056: end if;
3057: end loop;
3058: EXCEPTION

Line 3055: hr_utility.raise_error;

3051: set status = 'APPROVED'
3052: where current of c1;
3053: else
3054: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');
3055: hr_utility.raise_error;
3056: end if;
3057: end loop;
3058: EXCEPTION
3059: WHEN others THEN

Line 3060: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');

3056: end if;
3057: end loop;
3058: EXCEPTION
3059: WHEN others THEN
3060: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');
3061: hr_utility.raise_error;
3062: END delegate_approve;
3063: procedure build_wks_notice(p_transaction_id in number,
3064: p_worksheet_name out nocopy varchar2,

Line 3061: hr_utility.raise_error;

3057: end loop;
3058: EXCEPTION
3059: WHEN others THEN
3060: hr_utility.set_message(8302,'PQH_INVALID_WKS_TXN_ID');
3061: hr_utility.raise_error;
3062: END delegate_approve;
3063: procedure build_wks_notice(p_transaction_id in number,
3064: p_worksheet_name out nocopy varchar2,
3065: p_budget_name out nocopy varchar2,

Line 3099: hr_utility.set_location('inside build_wks_notice '||l_proc,10);

3095: cursor c4 is select name from hr_all_organization_units_tl
3096: where organization_id = l_organization_id
3097: and language = userenv('LANG');
3098: BEGIN
3099: hr_utility.set_location('inside build_wks_notice '||l_proc,10);
3100: open c0;
3101: fetch c0 into l_worksheet_id,l_organization_id;
3102: close c0;
3103: hr_utility.set_location('worksheet detail fetched '||l_proc,20);

Line 3103: hr_utility.set_location('worksheet detail fetched '||l_proc,20);

3099: hr_utility.set_location('inside build_wks_notice '||l_proc,10);
3100: open c0;
3101: fetch c0 into l_worksheet_id,l_organization_id;
3102: close c0;
3103: hr_utility.set_location('worksheet detail fetched '||l_proc,20);
3104: open c1;
3105: fetch c1 into l_budget_id,p_worksheet_name,p_budget_version,l_worksheet_mode_cd,p_wks_start_date,p_wks_end_date,l_tran_cat_id;
3106: close c1;
3107: hr_utility.set_location('worksheet fetched '||l_proc,30);

Line 3107: hr_utility.set_location('worksheet fetched '||l_proc,30);

3103: hr_utility.set_location('worksheet detail fetched '||l_proc,20);
3104: open c1;
3105: fetch c1 into l_budget_id,p_worksheet_name,p_budget_version,l_worksheet_mode_cd,p_wks_start_date,p_wks_end_date,l_tran_cat_id;
3106: close c1;
3107: hr_utility.set_location('worksheet fetched '||l_proc,30);
3108: open c2;
3109: fetch c2 into p_budget_name,l_budget_entity_cd,l_budget_style_cd,p_bgt_start_date,p_bgt_end_date;
3110: close c2;
3111: hr_utility.set_location('budget fetched'||l_proc,40);

Line 3111: hr_utility.set_location('budget fetched'||l_proc,40);

3107: hr_utility.set_location('worksheet fetched '||l_proc,30);
3108: open c2;
3109: fetch c2 into p_budget_name,l_budget_entity_cd,l_budget_style_cd,p_bgt_start_date,p_bgt_end_date;
3110: close c2;
3111: hr_utility.set_location('budget fetched'||l_proc,40);
3112: open c3;
3113: fetch c3 into p_tran_cat_name;
3114: close c3;
3115: hr_utility.set_location('tran_cat fetched'||l_proc,50);

Line 3115: hr_utility.set_location('tran_cat fetched'||l_proc,50);

3111: hr_utility.set_location('budget fetched'||l_proc,40);
3112: open c3;
3113: fetch c3 into p_tran_cat_name;
3114: close c3;
3115: hr_utility.set_location('tran_cat fetched'||l_proc,50);
3116: if l_organization_id is not null then
3117: open c4;
3118: fetch c4 into p_organization_name;
3119: close c4;

Line 3120: hr_utility.set_location('organization fetched'||l_proc,60);

3116: if l_organization_id is not null then
3117: open c4;
3118: fetch c4 into p_organization_name;
3119: close c4;
3120: hr_utility.set_location('organization fetched'||l_proc,60);
3121: end if;
3122: p_budget_style := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_STYLE',
3123: p_lookup_code => l_budget_style_cd);
3124: p_budget_entity := hr_general.decode_lookup(p_lookup_type => 'PQH_BUDGET_ENTITY',

Line 3161: hr_utility.set_location('inside fyi notification'||l_proc,10);

3157: l_bgt_end_date date;
3158: l_wks_start_date date;
3159: l_wks_end_date date;
3160: BEGIN
3161: hr_utility.set_location('inside fyi notification'||l_proc,10);
3162: build_wks_notice(p_transaction_id => p_transaction_id,
3163: p_worksheet_name => l_worksheet_name,
3164: p_budget_name => l_budget_name,
3165: p_tran_cat_name => l_tran_cat_name,

Line 3175: hr_utility.set_message(8302,'PQH_WORKFLOW_FYI_NOTICE');

3171: p_worksheet_mode => l_worksheet_mode,
3172: p_budget_style => l_budget_style,
3173: p_budget_entity => l_budget_entity,
3174: p_budget_version => l_budget_version);
3175: hr_utility.set_message(8302,'PQH_WORKFLOW_FYI_NOTICE');
3176: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3177: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

Line 3176: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);

3172: p_budget_style => l_budget_style,
3173: p_budget_entity => l_budget_entity,
3174: p_budget_version => l_budget_version);
3175: hr_utility.set_message(8302,'PQH_WORKFLOW_FYI_NOTICE');
3176: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3177: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

Line 3177: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);

3173: p_budget_entity => l_budget_entity,
3174: p_budget_version => l_budget_version);
3175: hr_utility.set_message(8302,'PQH_WORKFLOW_FYI_NOTICE');
3176: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3177: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

Line 3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);

3174: p_budget_version => l_budget_version);
3175: hr_utility.set_message(8302,'PQH_WORKFLOW_FYI_NOTICE');
3176: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3177: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

Line 3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

3175: hr_utility.set_message(8302,'PQH_WORKFLOW_FYI_NOTICE');
3176: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3177: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

Line 3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

3176: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3177: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

Line 3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

3177: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

Line 3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

3178: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3186: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

Line 3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

3179: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3186: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3187: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

Line 3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

3180: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3186: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3187: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3188: l_document := hr_utility.get_message;

Line 3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

3181: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3186: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3187: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3188: l_document := hr_utility.get_message;
3189: return l_document;

Line 3186: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

3182: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3186: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3187: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3188: l_document := hr_utility.get_message;
3189: return l_document;
3190: exception

Line 3187: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

3183: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3186: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3187: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3188: l_document := hr_utility.get_message;
3189: return l_document;
3190: exception
3191: when others then

Line 3188: l_document := hr_utility.get_message;

3184: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3185: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3186: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3187: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3188: l_document := hr_utility.get_message;
3189: return l_document;
3190: exception
3191: when others then
3192: hr_utility.set_message(8302,'PQH_WF_FYI_NOTICE_FAIL');

Line 3192: hr_utility.set_message(8302,'PQH_WF_FYI_NOTICE_FAIL');

3188: l_document := hr_utility.get_message;
3189: return l_document;
3190: exception
3191: when others then
3192: hr_utility.set_message(8302,'PQH_WF_FYI_NOTICE_FAIL');
3193: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3194: l_document := hr_utility.get_message;
3195: return l_document;
3196: END fyi_notification;

Line 3193: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

3189: return l_document;
3190: exception
3191: when others then
3192: hr_utility.set_message(8302,'PQH_WF_FYI_NOTICE_FAIL');
3193: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3194: l_document := hr_utility.get_message;
3195: return l_document;
3196: END fyi_notification;
3197:

Line 3194: l_document := hr_utility.get_message;

3190: exception
3191: when others then
3192: hr_utility.set_message(8302,'PQH_WF_FYI_NOTICE_FAIL');
3193: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3194: l_document := hr_utility.get_message;
3195: return l_document;
3196: END fyi_notification;
3197:
3198: FUNCTION back_notification (p_transaction_id in number) RETURN varchar2

Line 3216: hr_utility.set_location('inside back notification'||l_proc,10);

3212: l_bgt_end_date date;
3213: l_wks_start_date date;
3214: l_wks_end_date date;
3215: BEGIN
3216: hr_utility.set_location('inside back notification'||l_proc,10);
3217: build_wks_notice(p_transaction_id => p_transaction_id,
3218: p_worksheet_name => l_worksheet_name,
3219: p_budget_name => l_budget_name,
3220: p_tran_cat_name => l_tran_cat_name,

Line 3230: hr_utility.set_message(8302,'PQH_WORKFLOW_BACK_NOTICE');

3226: p_worksheet_mode => l_worksheet_mode,
3227: p_budget_style => l_budget_style,
3228: p_budget_entity => l_budget_entity,
3229: p_budget_version => l_budget_version);
3230: hr_utility.set_message(8302,'PQH_WORKFLOW_BACK_NOTICE');
3231: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3232: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

Line 3231: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);

3227: p_budget_style => l_budget_style,
3228: p_budget_entity => l_budget_entity,
3229: p_budget_version => l_budget_version);
3230: hr_utility.set_message(8302,'PQH_WORKFLOW_BACK_NOTICE');
3231: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3232: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

Line 3232: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);

3228: p_budget_entity => l_budget_entity,
3229: p_budget_version => l_budget_version);
3230: hr_utility.set_message(8302,'PQH_WORKFLOW_BACK_NOTICE');
3231: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3232: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

Line 3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);

3229: p_budget_version => l_budget_version);
3230: hr_utility.set_message(8302,'PQH_WORKFLOW_BACK_NOTICE');
3231: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3232: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

Line 3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

3230: hr_utility.set_message(8302,'PQH_WORKFLOW_BACK_NOTICE');
3231: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3232: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

Line 3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

3231: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3232: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

Line 3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

3232: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

Line 3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

3233: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3241: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

Line 3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

3234: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3241: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3242: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

Line 3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

3235: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3241: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3242: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3243: l_document := hr_utility.get_message;

Line 3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

3236: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3241: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3242: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3243: l_document := hr_utility.get_message;
3244: return l_document;

Line 3241: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

3237: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3241: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3242: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3243: l_document := hr_utility.get_message;
3244: return l_document;
3245: exception

Line 3242: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

3238: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3241: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3242: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3243: l_document := hr_utility.get_message;
3244: return l_document;
3245: exception
3246: when others then

Line 3243: l_document := hr_utility.get_message;

3239: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3240: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3241: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3242: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3243: l_document := hr_utility.get_message;
3244: return l_document;
3245: exception
3246: when others then
3247: hr_utility.set_message(8302,'PQH_WF_BACK_NOTICE_FAIL');

Line 3247: hr_utility.set_message(8302,'PQH_WF_BACK_NOTICE_FAIL');

3243: l_document := hr_utility.get_message;
3244: return l_document;
3245: exception
3246: when others then
3247: hr_utility.set_message(8302,'PQH_WF_BACK_NOTICE_FAIL');
3248: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3249: l_document := hr_utility.get_message;
3250: return l_document;
3251: END back_notification;

Line 3248: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

3244: return l_document;
3245: exception
3246: when others then
3247: hr_utility.set_message(8302,'PQH_WF_BACK_NOTICE_FAIL');
3248: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3249: l_document := hr_utility.get_message;
3250: return l_document;
3251: END back_notification;
3252: FUNCTION override_notification (p_transaction_id in number) RETURN varchar2

Line 3249: l_document := hr_utility.get_message;

3245: exception
3246: when others then
3247: hr_utility.set_message(8302,'PQH_WF_BACK_NOTICE_FAIL');
3248: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3249: l_document := hr_utility.get_message;
3250: return l_document;
3251: END back_notification;
3252: FUNCTION override_notification (p_transaction_id in number) RETURN varchar2
3253: is

Line 3270: hr_utility.set_location('inside override notification'||l_proc,10);

3266: l_bgt_end_date date;
3267: l_wks_start_date date;
3268: l_wks_end_date date;
3269: BEGIN
3270: hr_utility.set_location('inside override notification'||l_proc,10);
3271: build_wks_notice(p_transaction_id => p_transaction_id,
3272: p_worksheet_name => l_worksheet_name,
3273: p_budget_name => l_budget_name,
3274: p_tran_cat_name => l_tran_cat_name,

Line 3284: hr_utility.set_message(8302,'PQH_WORKFLOW_OVERRIDE_NOTICE');

3280: p_worksheet_mode => l_worksheet_mode,
3281: p_budget_style => l_budget_style,
3282: p_budget_entity => l_budget_entity,
3283: p_budget_version => l_budget_version);
3284: hr_utility.set_message(8302,'PQH_WORKFLOW_OVERRIDE_NOTICE');
3285: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3286: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

Line 3285: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);

3281: p_budget_style => l_budget_style,
3282: p_budget_entity => l_budget_entity,
3283: p_budget_version => l_budget_version);
3284: hr_utility.set_message(8302,'PQH_WORKFLOW_OVERRIDE_NOTICE');
3285: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3286: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

Line 3286: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);

3282: p_budget_entity => l_budget_entity,
3283: p_budget_version => l_budget_version);
3284: hr_utility.set_message(8302,'PQH_WORKFLOW_OVERRIDE_NOTICE');
3285: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3286: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

Line 3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);

3283: p_budget_version => l_budget_version);
3284: hr_utility.set_message(8302,'PQH_WORKFLOW_OVERRIDE_NOTICE');
3285: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3286: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

Line 3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

3284: hr_utility.set_message(8302,'PQH_WORKFLOW_OVERRIDE_NOTICE');
3285: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3286: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

Line 3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

3285: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3286: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

Line 3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

3286: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

Line 3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

3287: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3295: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

Line 3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

3288: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3295: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3296: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

Line 3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

3289: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3295: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3296: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3297: l_document := hr_utility.get_message;

Line 3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

3290: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3295: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3296: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3297: l_document := hr_utility.get_message;
3298: return l_document;

Line 3295: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

3291: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3295: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3296: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3297: l_document := hr_utility.get_message;
3298: return l_document;
3299: exception

Line 3296: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

3292: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3295: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3296: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3297: l_document := hr_utility.get_message;
3298: return l_document;
3299: exception
3300: when others then

Line 3297: l_document := hr_utility.get_message;

3293: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3294: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3295: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3296: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3297: l_document := hr_utility.get_message;
3298: return l_document;
3299: exception
3300: when others then
3301: hr_utility.set_message(8302,'PQH_WF_OVERRIDE_NOTICE_FAIL');

Line 3301: hr_utility.set_message(8302,'PQH_WF_OVERRIDE_NOTICE_FAIL');

3297: l_document := hr_utility.get_message;
3298: return l_document;
3299: exception
3300: when others then
3301: hr_utility.set_message(8302,'PQH_WF_OVERRIDE_NOTICE_FAIL');
3302: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3303: l_document := hr_utility.get_message;
3304: return l_document;
3305: END override_notification;

Line 3302: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

3298: return l_document;
3299: exception
3300: when others then
3301: hr_utility.set_message(8302,'PQH_WF_OVERRIDE_NOTICE_FAIL');
3302: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3303: l_document := hr_utility.get_message;
3304: return l_document;
3305: END override_notification;
3306: FUNCTION apply_notification (p_transaction_id in number) RETURN varchar2

Line 3303: l_document := hr_utility.get_message;

3299: exception
3300: when others then
3301: hr_utility.set_message(8302,'PQH_WF_OVERRIDE_NOTICE_FAIL');
3302: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3303: l_document := hr_utility.get_message;
3304: return l_document;
3305: END override_notification;
3306: FUNCTION apply_notification (p_transaction_id in number) RETURN varchar2
3307: is

Line 3324: hr_utility.set_location('inside apply notification'||l_proc,10);

3320: l_bgt_end_date date;
3321: l_wks_start_date date;
3322: l_wks_end_date date;
3323: BEGIN
3324: hr_utility.set_location('inside apply notification'||l_proc,10);
3325: build_wks_notice(p_transaction_id => p_transaction_id,
3326: p_worksheet_name => l_worksheet_name,
3327: p_budget_name => l_budget_name,
3328: p_tran_cat_name => l_tran_cat_name,

Line 3338: hr_utility.set_message(8302,'PQH_WORKFLOW_APPLY_NOTICE');

3334: p_worksheet_mode => l_worksheet_mode,
3335: p_budget_style => l_budget_style,
3336: p_budget_entity => l_budget_entity,
3337: p_budget_version => l_budget_version);
3338: hr_utility.set_message(8302,'PQH_WORKFLOW_APPLY_NOTICE');
3339: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3340: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

Line 3339: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);

3335: p_budget_style => l_budget_style,
3336: p_budget_entity => l_budget_entity,
3337: p_budget_version => l_budget_version);
3338: hr_utility.set_message(8302,'PQH_WORKFLOW_APPLY_NOTICE');
3339: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3340: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

Line 3340: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);

3336: p_budget_entity => l_budget_entity,
3337: p_budget_version => l_budget_version);
3338: hr_utility.set_message(8302,'PQH_WORKFLOW_APPLY_NOTICE');
3339: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3340: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

Line 3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);

3337: p_budget_version => l_budget_version);
3338: hr_utility.set_message(8302,'PQH_WORKFLOW_APPLY_NOTICE');
3339: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3340: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

Line 3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

3338: hr_utility.set_message(8302,'PQH_WORKFLOW_APPLY_NOTICE');
3339: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3340: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

Line 3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

3339: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3340: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

Line 3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

3340: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

Line 3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

3341: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3349: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

Line 3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

3342: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3349: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3350: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

Line 3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

3343: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3349: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3350: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3351: l_document := hr_utility.get_message;

Line 3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

3344: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3349: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3350: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3351: l_document := hr_utility.get_message;
3352: return l_document;

Line 3349: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

3345: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3349: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3350: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3351: l_document := hr_utility.get_message;
3352: return l_document;
3353: exception

Line 3350: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

3346: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3349: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3350: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3351: l_document := hr_utility.get_message;
3352: return l_document;
3353: exception
3354: when others then

Line 3351: l_document := hr_utility.get_message;

3347: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3348: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3349: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3350: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3351: l_document := hr_utility.get_message;
3352: return l_document;
3353: exception
3354: when others then
3355: hr_utility.set_message(8302,'PQH_WF_APPLY_NOTICE_FAIL');

Line 3355: hr_utility.set_message(8302,'PQH_WF_APPLY_NOTICE_FAIL');

3351: l_document := hr_utility.get_message;
3352: return l_document;
3353: exception
3354: when others then
3355: hr_utility.set_message(8302,'PQH_WF_APPLY_NOTICE_FAIL');
3356: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3357: l_document := hr_utility.get_message;
3358: return l_document;
3359: END apply_notification;

Line 3356: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

3352: return l_document;
3353: exception
3354: when others then
3355: hr_utility.set_message(8302,'PQH_WF_APPLY_NOTICE_FAIL');
3356: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3357: l_document := hr_utility.get_message;
3358: return l_document;
3359: END apply_notification;
3360: FUNCTION reject_notification (p_transaction_id in number) RETURN varchar2

Line 3357: l_document := hr_utility.get_message;

3353: exception
3354: when others then
3355: hr_utility.set_message(8302,'PQH_WF_APPLY_NOTICE_FAIL');
3356: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3357: l_document := hr_utility.get_message;
3358: return l_document;
3359: END apply_notification;
3360: FUNCTION reject_notification (p_transaction_id in number) RETURN varchar2
3361: is

Line 3378: hr_utility.set_location('inside reject notification'||l_proc,10);

3374: l_bgt_end_date date;
3375: l_wks_start_date date;
3376: l_wks_end_date date;
3377: BEGIN
3378: hr_utility.set_location('inside reject notification'||l_proc,10);
3379: build_wks_notice(p_transaction_id => p_transaction_id,
3380: p_worksheet_name => l_worksheet_name,
3381: p_budget_name => l_budget_name,
3382: p_tran_cat_name => l_tran_cat_name,

Line 3392: hr_utility.set_message(8302,'PQH_WORKFLOW_REJECT_NOTICE');

3388: p_worksheet_mode => l_worksheet_mode,
3389: p_budget_style => l_budget_style,
3390: p_budget_entity => l_budget_entity,
3391: p_budget_version => l_budget_version);
3392: hr_utility.set_message(8302,'PQH_WORKFLOW_REJECT_NOTICE');
3393: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3394: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

Line 3393: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);

3389: p_budget_style => l_budget_style,
3390: p_budget_entity => l_budget_entity,
3391: p_budget_version => l_budget_version);
3392: hr_utility.set_message(8302,'PQH_WORKFLOW_REJECT_NOTICE');
3393: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3394: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

Line 3394: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);

3390: p_budget_entity => l_budget_entity,
3391: p_budget_version => l_budget_version);
3392: hr_utility.set_message(8302,'PQH_WORKFLOW_REJECT_NOTICE');
3393: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3394: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

Line 3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);

3391: p_budget_version => l_budget_version);
3392: hr_utility.set_message(8302,'PQH_WORKFLOW_REJECT_NOTICE');
3393: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3394: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

Line 3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

3392: hr_utility.set_message(8302,'PQH_WORKFLOW_REJECT_NOTICE');
3393: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3394: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

Line 3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

3393: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3394: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

Line 3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

3394: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

Line 3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

3395: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3403: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

Line 3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

3396: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3403: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3404: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

Line 3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

3397: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3403: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3404: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3405: l_document := hr_utility.get_message;

Line 3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

3398: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3403: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3404: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3405: l_document := hr_utility.get_message;
3406: return l_document;

Line 3403: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

3399: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3403: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3404: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3405: l_document := hr_utility.get_message;
3406: return l_document;
3407: exception

Line 3404: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

3400: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3403: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3404: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3405: l_document := hr_utility.get_message;
3406: return l_document;
3407: exception
3408: when others then

Line 3405: l_document := hr_utility.get_message;

3401: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3402: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3403: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3404: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3405: l_document := hr_utility.get_message;
3406: return l_document;
3407: exception
3408: when others then
3409: hr_utility.set_message(8302,'PQH_WF_REJECT_NOTICE_FAIL');

Line 3409: hr_utility.set_message(8302,'PQH_WF_REJECT_NOTICE_FAIL');

3405: l_document := hr_utility.get_message;
3406: return l_document;
3407: exception
3408: when others then
3409: hr_utility.set_message(8302,'PQH_WF_REJECT_NOTICE_FAIL');
3410: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3411: l_document := hr_utility.get_message;
3412: return l_document;
3413: END reject_notification;

Line 3410: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

3406: return l_document;
3407: exception
3408: when others then
3409: hr_utility.set_message(8302,'PQH_WF_REJECT_NOTICE_FAIL');
3410: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3411: l_document := hr_utility.get_message;
3412: return l_document;
3413: END reject_notification;
3414: FUNCTION warning_notification (p_transaction_id in number) RETURN varchar2

Line 3411: l_document := hr_utility.get_message;

3407: exception
3408: when others then
3409: hr_utility.set_message(8302,'PQH_WF_REJECT_NOTICE_FAIL');
3410: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3411: l_document := hr_utility.get_message;
3412: return l_document;
3413: END reject_notification;
3414: FUNCTION warning_notification (p_transaction_id in number) RETURN varchar2
3415: is

Line 3432: hr_utility.set_location('inside warning notification'||l_proc,10);

3428: l_bgt_end_date date;
3429: l_wks_start_date date;
3430: l_wks_end_date date;
3431: BEGIN
3432: hr_utility.set_location('inside warning notification'||l_proc,10);
3433: build_wks_notice(p_transaction_id => p_transaction_id,
3434: p_worksheet_name => l_worksheet_name,
3435: p_budget_name => l_budget_name,
3436: p_tran_cat_name => l_tran_cat_name,

Line 3446: hr_utility.set_message(8302,'PQH_WORKFLOW_WARNING_NOTICE');

3442: p_worksheet_mode => l_worksheet_mode,
3443: p_budget_style => l_budget_style,
3444: p_budget_entity => l_budget_entity,
3445: p_budget_version => l_budget_version);
3446: hr_utility.set_message(8302,'PQH_WORKFLOW_WARNING_NOTICE');
3447: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3448: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

Line 3447: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);

3443: p_budget_style => l_budget_style,
3444: p_budget_entity => l_budget_entity,
3445: p_budget_version => l_budget_version);
3446: hr_utility.set_message(8302,'PQH_WORKFLOW_WARNING_NOTICE');
3447: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3448: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

Line 3448: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);

3444: p_budget_entity => l_budget_entity,
3445: p_budget_version => l_budget_version);
3446: hr_utility.set_message(8302,'PQH_WORKFLOW_WARNING_NOTICE');
3447: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3448: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

Line 3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);

3445: p_budget_version => l_budget_version);
3446: hr_utility.set_message(8302,'PQH_WORKFLOW_WARNING_NOTICE');
3447: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3448: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

Line 3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

3446: hr_utility.set_message(8302,'PQH_WORKFLOW_WARNING_NOTICE');
3447: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3448: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

Line 3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

3447: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3448: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

Line 3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

3448: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

Line 3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

3449: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3457: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

Line 3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

3450: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3457: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3458: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

Line 3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

3451: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3457: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3458: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3459: l_document := hr_utility.get_message;

Line 3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

3452: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3457: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3458: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3459: l_document := hr_utility.get_message;
3460: return l_document;

Line 3457: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

3453: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3457: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3458: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3459: l_document := hr_utility.get_message;
3460: return l_document;
3461: exception

Line 3458: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

3454: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3457: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3458: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3459: l_document := hr_utility.get_message;
3460: return l_document;
3461: exception
3462: when others then

Line 3459: l_document := hr_utility.get_message;

3455: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3456: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3457: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3458: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3459: l_document := hr_utility.get_message;
3460: return l_document;
3461: exception
3462: when others then
3463: hr_utility.set_message(8302,'PQH_WF_WARNING_NOTICE_FAIL');

Line 3463: hr_utility.set_message(8302,'PQH_WF_WARNING_NOTICE_FAIL');

3459: l_document := hr_utility.get_message;
3460: return l_document;
3461: exception
3462: when others then
3463: hr_utility.set_message(8302,'PQH_WF_WARNING_NOTICE_FAIL');
3464: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3465: l_document := hr_utility.get_message;
3466: return l_document;
3467: END warning_notification;

Line 3464: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

3460: return l_document;
3461: exception
3462: when others then
3463: hr_utility.set_message(8302,'PQH_WF_WARNING_NOTICE_FAIL');
3464: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3465: l_document := hr_utility.get_message;
3466: return l_document;
3467: END warning_notification;
3468: FUNCTION respond_notification (p_transaction_id in number) RETURN varchar2

Line 3465: l_document := hr_utility.get_message;

3461: exception
3462: when others then
3463: hr_utility.set_message(8302,'PQH_WF_WARNING_NOTICE_FAIL');
3464: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3465: l_document := hr_utility.get_message;
3466: return l_document;
3467: END warning_notification;
3468: FUNCTION respond_notification (p_transaction_id in number) RETURN varchar2
3469: is

Line 3486: hr_utility.set_location('inside respond notification'||l_proc,10);

3482: l_bgt_end_date date;
3483: l_wks_start_date date;
3484: l_wks_end_date date;
3485: BEGIN
3486: hr_utility.set_location('inside respond notification'||l_proc,10);
3487: build_wks_notice(p_transaction_id => p_transaction_id,
3488: p_worksheet_name => l_worksheet_name,
3489: p_budget_name => l_budget_name,
3490: p_tran_cat_name => l_tran_cat_name,

Line 3500: hr_utility.set_message(8302,'PQH_WORKFLOW_RESPOND_NOTICE');

3496: p_worksheet_mode => l_worksheet_mode,
3497: p_budget_style => l_budget_style,
3498: p_budget_entity => l_budget_entity,
3499: p_budget_version => l_budget_version);
3500: hr_utility.set_message(8302,'PQH_WORKFLOW_RESPOND_NOTICE');
3501: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3502: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

Line 3501: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);

3497: p_budget_style => l_budget_style,
3498: p_budget_entity => l_budget_entity,
3499: p_budget_version => l_budget_version);
3500: hr_utility.set_message(8302,'PQH_WORKFLOW_RESPOND_NOTICE');
3501: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3502: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

Line 3502: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);

3498: p_budget_entity => l_budget_entity,
3499: p_budget_version => l_budget_version);
3500: hr_utility.set_message(8302,'PQH_WORKFLOW_RESPOND_NOTICE');
3501: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3502: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

Line 3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);

3499: p_budget_version => l_budget_version);
3500: hr_utility.set_message(8302,'PQH_WORKFLOW_RESPOND_NOTICE');
3501: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3502: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

Line 3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);

3500: hr_utility.set_message(8302,'PQH_WORKFLOW_RESPOND_NOTICE');
3501: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3502: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

Line 3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);

3501: hr_utility.set_message_token('WORKSHEET_NAME',l_worksheet_name);
3502: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

Line 3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);

3502: hr_utility.set_message_token('BUDGET_NAME',l_budget_name);
3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

Line 3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);

3503: hr_utility.set_message_token('TRANSACTION_CATEGORY',l_tran_cat_name);
3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3511: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

Line 3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);

3504: hr_utility.set_message_token('BUDGET_VERSION',l_budget_version);
3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3511: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3512: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

Line 3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);

3505: hr_utility.set_message_token('BUDGET_STYLE',l_budget_style);
3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3511: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3512: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3513: l_document := hr_utility.get_message;

Line 3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);

3506: hr_utility.set_message_token('BUDGET_ENTITY',l_budget_entity);
3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3511: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3512: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3513: l_document := hr_utility.get_message;
3514: return l_document;

Line 3511: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);

3507: hr_utility.set_message_token('WORKSHEET_MODE',l_worksheet_mode);
3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3511: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3512: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3513: l_document := hr_utility.get_message;
3514: return l_document;
3515: exception

Line 3512: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);

3508: hr_utility.set_message_token('ORGANIZATION_NAME',l_organization_name);
3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3511: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3512: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3513: l_document := hr_utility.get_message;
3514: return l_document;
3515: exception
3516: when others then

Line 3513: l_document := hr_utility.get_message;

3509: hr_utility.set_message_token('BUDGET_START_DATE',l_bgt_start_date);
3510: hr_utility.set_message_token('BUDGET_END_DATE',l_bgt_end_date);
3511: hr_utility.set_message_token('WORKSHEET_START_DATE',l_wks_start_date);
3512: hr_utility.set_message_token('WORKSHEET_END_DATE',l_wks_end_date);
3513: l_document := hr_utility.get_message;
3514: return l_document;
3515: exception
3516: when others then
3517: hr_utility.set_message(8302,'PQH_WF_RESPOND_NOTICE_FAIL');

Line 3517: hr_utility.set_message(8302,'PQH_WF_RESPOND_NOTICE_FAIL');

3513: l_document := hr_utility.get_message;
3514: return l_document;
3515: exception
3516: when others then
3517: hr_utility.set_message(8302,'PQH_WF_RESPOND_NOTICE_FAIL');
3518: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3519: l_document := hr_utility.get_message;
3520: return l_document;
3521: END respond_notification;

Line 3518: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);

3514: return l_document;
3515: exception
3516: when others then
3517: hr_utility.set_message(8302,'PQH_WF_RESPOND_NOTICE_FAIL');
3518: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3519: l_document := hr_utility.get_message;
3520: return l_document;
3521: END respond_notification;
3522: --------------------------------------------------------------------------------------------------------------

Line 3519: l_document := hr_utility.get_message;

3515: exception
3516: when others then
3517: hr_utility.set_message(8302,'PQH_WF_RESPOND_NOTICE_FAIL');
3518: hr_utility.set_message_token('TRANSACTION_ID',p_transaction_id);
3519: l_document := hr_utility.get_message;
3520: return l_document;
3521: END respond_notification;
3522: --------------------------------------------------------------------------------------------------------------
3523: -- end added by Sumit Goyal

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

3578: l_do_action boolean := FALSE;
3579: l_return_status varchar2(20);
3580:
3581: BEGIN
3582: hr_utility.set_location('Entering:'||p_transaction_id||l_proc, 5);
3583: for i in c1 loop
3584: hr_utility.set_location('calling:'||i.transaction_id||l_proc, 10);
3585: l_return_status := set_status(p_transaction_category_id => p_transaction_category_id,
3586: p_transaction_id => i.transaction_id,

Line 3584: hr_utility.set_location('calling:'||i.transaction_id||l_proc, 10);

3580:
3581: BEGIN
3582: hr_utility.set_location('Entering:'||p_transaction_id||l_proc, 5);
3583: for i in c1 loop
3584: hr_utility.set_location('calling:'||i.transaction_id||l_proc, 10);
3585: l_return_status := set_status(p_transaction_category_id => p_transaction_category_id,
3586: p_transaction_id => i.transaction_id,
3587: p_status => p_status );
3588: end loop; -- for loop

Line 3601: hr_utility.set_location('changing just stat'||l_proc, 10);

3597: l_do_action := FALSE;
3598: end if;
3599: if l_do_action then
3600: if l_wdt_rec.parent_worksheet_detail_id is not null and l_wdt_rec.status ='PENDING' then
3601: hr_utility.set_location('changing just stat'||l_proc, 10);
3602: else
3603: BEGIN
3604: wf_engine.AbortProcess
3605: (itemtype => 'PQHGEN',

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

3635: ,p_effective_date => sysdate
3636: );
3637: end if;
3638: end if;
3639: hr_utility.set_location('Leaving:'||l_proc, 1000);
3640: RETURN 'SUCCESS';
3641: EXCEPTION
3642: WHEN OTHERS THEN
3643: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

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

3639: hr_utility.set_location('Leaving:'||l_proc, 1000);
3640: RETURN 'SUCCESS';
3641: EXCEPTION
3642: WHEN OTHERS THEN
3643: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3644: hr_utility.set_message_token('ROUTINE', l_proc);
3645: hr_utility.set_message_token('REASON', SQLERRM);
3646: hr_utility.raise_error;
3647: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);

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

3640: RETURN 'SUCCESS';
3641: EXCEPTION
3642: WHEN OTHERS THEN
3643: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3644: hr_utility.set_message_token('ROUTINE', l_proc);
3645: hr_utility.set_message_token('REASON', SQLERRM);
3646: hr_utility.raise_error;
3647: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);
3648: RETURN 'FAILURE';

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

3641: EXCEPTION
3642: WHEN OTHERS THEN
3643: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3644: hr_utility.set_message_token('ROUTINE', l_proc);
3645: hr_utility.set_message_token('REASON', SQLERRM);
3646: hr_utility.raise_error;
3647: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);
3648: RETURN 'FAILURE';
3649: END set_status;

Line 3646: hr_utility.raise_error;

3642: WHEN OTHERS THEN
3643: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3644: hr_utility.set_message_token('ROUTINE', l_proc);
3645: hr_utility.set_message_token('REASON', SQLERRM);
3646: hr_utility.raise_error;
3647: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);
3648: RETURN 'FAILURE';
3649: END set_status;
3650:

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

3643: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
3644: hr_utility.set_message_token('ROUTINE', l_proc);
3645: hr_utility.set_message_token('REASON', SQLERRM);
3646: hr_utility.raise_error;
3647: hr_utility.set_location('Leaving: EXCEPTION '||l_proc, 1000);
3648: RETURN 'FAILURE';
3649: END set_status;
3650:
3651: