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.PSP_ENC_PRE_PROCESS dependencies on FND_API

Line 135: p_return_status := fnd_api.g_ret_sts_success;

131: l_operating_unit,
132: l_pa_gms_install_option);
133:
134: IF l_pa_gms_install_option <>'PA_GMS' THEN
135: p_return_status := fnd_api.g_ret_sts_success;
136: RETURN;
137: END IF;
138:
139: -- Introduced the following for bug fix 3434626

Line 182: IF p_return_status <> fnd_api.g_ret_sts_success THEN

178: p_set_of_books_id => p_set_of_books_id,
179: p_max_pay_date => l_max_pay_date,
180: p_return_status => p_return_status);
181:
182: IF p_return_status <> fnd_api.g_ret_sts_success THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:
186: l_proc_step := 40; -- Introduced for bug fix 3434626

Line 183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

179: p_max_pay_date => l_max_pay_date,
180: p_return_status => p_return_status);
181:
182: IF p_return_status <> fnd_api.g_ret_sts_success THEN
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: END IF;
185:
186: l_proc_step := 40; -- Introduced for bug fix 3434626
187:

Line 195: IF p_return_status <> fnd_api.g_ret_sts_success THEN

191: p_set_of_books_id => p_set_of_books_id,
192: p_max_pay_date => l_max_pay_date,
193: p_return_status => p_return_status);
194:
195: IF p_return_status <> fnd_api.g_ret_sts_success THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;
198:
199: l_proc_step := 50; -- Introduced for bug fix 3434626

Line 196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

192: p_max_pay_date => l_max_pay_date,
193: p_return_status => p_return_status);
194:
195: IF p_return_status <> fnd_api.g_ret_sts_success THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;
198:
199: l_proc_step := 50; -- Introduced for bug fix 3434626
200:

Line 208: IF p_return_status <> fnd_api.g_ret_sts_success THEN

204: p_set_of_books_id => p_set_of_books_id,
205: p_max_pay_date => l_max_pay_date,
206: p_return_status => p_return_status);
207:
208: IF p_return_status <> fnd_api.g_ret_sts_success THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: l_proc_step := 60; -- Introduced for bug fix 3434626

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

205: p_max_pay_date => l_max_pay_date,
206: p_return_status => p_return_status);
207:
208: IF p_return_status <> fnd_api.g_ret_sts_success THEN
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: l_proc_step := 60; -- Introduced for bug fix 3434626
213:

Line 221: IF p_return_status <> fnd_api.g_ret_sts_success THEN

217: p_set_of_books_id => p_set_of_books_id,
218: p_max_pay_date => l_max_pay_date,
219: p_return_status => p_return_status);
220:
221: IF p_return_status <> fnd_api.g_ret_sts_success THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224:
225: l_proc_step := 70; -- Introduced for bug fix 3434626

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: p_max_pay_date => l_max_pay_date,
219: p_return_status => p_return_status);
220:
221: IF p_return_status <> fnd_api.g_ret_sts_success THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224:
225: l_proc_step := 70; -- Introduced for bug fix 3434626
226:

Line 228: p_return_status := fnd_api.g_ret_sts_success;

224:
225: l_proc_step := 70; -- Introduced for bug fix 3434626
226:
227: COMMIT;
228: p_return_status := fnd_api.g_ret_sts_success;
229:
230:
231: -- Introduced the following for bug fix 3434626
232: hr_utility.trace('Leaving ' || l_proc_name);

Line 239: p_print_header=>FND_API.G_TRUE);

235: WHEN OTHERS THEN
236: g_error_api_path := SUBSTR(g_error_api_path,1,30);
237: fnd_msg_pub.add_exc_msg('PSP_ENC_PRE_PROCESS',g_error_api_path);
238: psp_message_s.print_error(p_mode=>FND_FILE.LOG,
239: p_print_header=>FND_API.G_TRUE);
240: -- bug fix 2597666
241: p_return_status := fnd_api.g_ret_sts_unexp_error;
242: -- Introduced the following for bug fix 3434626
243: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);

Line 241: p_return_status := fnd_api.g_ret_sts_unexp_error;

237: fnd_msg_pub.add_exc_msg('PSP_ENC_PRE_PROCESS',g_error_api_path);
238: psp_message_s.print_error(p_mode=>FND_FILE.LOG,
239: p_print_header=>FND_API.G_TRUE);
240: -- bug fix 2597666
241: p_return_status := fnd_api.g_ret_sts_unexp_error;
242: -- Introduced the following for bug fix 3434626
243: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
244: hr_utility.trace('Leaving ' || l_proc_name);
245: -- End of changed for bug fix 3434626

Line 381: IF p_return_status <> fnd_api.g_ret_sts_success THEN

377: p_payroll_id => p_payroll_id,
378: p_start_date => g_final_start_date,
379: p_end_date => g_final_end_date,
380: p_return_status => p_return_status);
381: IF p_return_status <> fnd_api.g_ret_sts_success THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384:
385: -- Introduced for bug fix 3434626

Line 382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

378: p_start_date => g_final_start_date,
379: p_end_date => g_final_end_date,
380: p_return_status => p_return_status);
381: IF p_return_status <> fnd_api.g_ret_sts_success THEN
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: END IF;
384:
385: -- Introduced for bug fix 3434626
386: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

Line 422: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

418: are changed) into psp_enc_changed_assignments */
419: IF r_asg_id_array.r_asg_id.count<>0 THEN
420: insert_changed_assignments (p_change_type => 'PT',
421: p_return_status => p_return_status);
422: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425: END IF;
426: END IF;

Line 423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

419: IF r_asg_id_array.r_asg_id.count<>0 THEN
420: insert_changed_assignments (p_change_type => 'PT',
421: p_return_status => p_return_status);
422: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424: END IF;
425: END IF;
426: END IF;
427: ELSE

Line 435: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

431: validate_transaction_controls
432: (p_project_id => r_global_control_rec.r_project_id(i),
433: p_payroll_id => p_payroll_id,
434: p_return_status => p_return_status);
435: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438: l_prev_tx_project_id := r_global_control_rec.r_project_id(i);
439: END IF;

Line 436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

432: (p_project_id => r_global_control_rec.r_project_id(i),
433: p_payroll_id => p_payroll_id,
434: p_return_status => p_return_status);
435: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438: l_prev_tx_project_id := r_global_control_rec.r_project_id(i);
439: END IF;
440: END IF;

Line 454: p_return_status := fnd_api.g_ret_sts_success;

450: SET poeta_start_date = r_global_control_rec.r_poeta_start_date(i),
451: poeta_end_date = r_global_control_rec.r_poeta_end_date(i)
452: WHERE element_account_id = r_global_control_rec.r_global_line_id(i);
453:
454: p_return_status := fnd_api.g_ret_sts_success;
455:
456: -- Introduced for bug fix 3434626
457: hr_utility.trace('Leaving ' || l_proc_name);
458: -- End of bug fix 3434626

Line 463: p_return_status := fnd_api.g_ret_sts_unexp_error;

459: EXCEPTION
460: WHEN OTHERS THEN
461: g_error_api_path := SUBSTR('UPDT_GLBL:'||g_error_api_path,1,30);
462: -- bug fix 2597666
463: p_return_status := fnd_api.g_ret_sts_unexp_error;
464: -- Introduced for bug fix 3434626
465: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
466: hr_utility.trace('Leaving ' || l_proc_name);
467: -- End of bug fix 3434626

Line 616: IF p_return_status <> fnd_api.g_ret_sts_success THEN

612: p_start_date => g_final_start_date,
613: p_end_date => g_final_end_date,
614: p_return_status => p_return_status);
615:
616: IF p_return_status <> fnd_api.g_ret_sts_success THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: -- Introduced for bug fix 3434626

Line 617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

613: p_end_date => g_final_end_date,
614: p_return_status => p_return_status);
615:
616: IF p_return_status <> fnd_api.g_ret_sts_success THEN
617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
618: END IF;
619:
620: -- Introduced for bug fix 3434626
621: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

Line 659: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

655:
656: IF j>1 then
657: insert_changed_assignments (p_change_type => 'PT',
658: p_return_status => p_return_status);
659: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662: j:=1;
663:

Line 660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

656: IF j>1 then
657: insert_changed_assignments (p_change_type => 'PT',
658: p_return_status => p_return_status);
659: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662: j:=1;
663:
664: END IF; -- bug fix 2597666

Line 674: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

670: validate_transaction_controls
671: (p_project_id => r_schedule_control_rec.r_project_id(i),
672: p_payroll_id => p_payroll_id,
673: p_return_status => p_return_status);
674: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
676: END IF;
677: l_prev_tx_project_id := r_schedule_control_rec.r_project_id(i);
678: END IF;

Line 675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

671: (p_project_id => r_schedule_control_rec.r_project_id(i),
672: p_payroll_id => p_payroll_id,
673: p_return_status => p_return_status);
674: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
676: END IF;
677: l_prev_tx_project_id := r_schedule_control_rec.r_project_id(i);
678: END IF;
679: END IF;

Line 703: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

699: /* Inserting into psp_enc_changed_assignments */
700: IF j> 1 then -- bug fix 2597666
701: insert_changed_assignments (p_change_type => 'PT',
702: p_return_status => p_return_status);
703: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
705: END IF;
706: END IF;
707: END IF;

Line 704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

700: IF j> 1 then -- bug fix 2597666
701: insert_changed_assignments (p_change_type => 'PT',
702: p_return_status => p_return_status);
703: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
705: END IF;
706: END IF;
707: END IF;
708:

Line 709: p_return_status := fnd_api.g_ret_sts_success;

705: END IF;
706: END IF;
707: END IF;
708:
709: p_return_status := fnd_api.g_ret_sts_success;
710:
711: -- Introduced for bug fix 3434626
712: l_proc_step := 80;
713: hr_utility.trace('Leaving ' || l_proc_name);

Line 719: p_return_status := fnd_api.g_ret_sts_unexp_error;

715: EXCEPTION
716: WHEN OTHERS THEN
717: g_error_api_path := SUBSTR('UPDT_SCHDLS:'||g_error_api_path,1,30);
718: -- bug fix 2597666
719: p_return_status := fnd_api.g_ret_sts_unexp_error;
720: -- Introduced for bug fix 3434626
721: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
722: hr_utility.trace('Leaving ' || l_proc_name);
723: -- End of bug fix 3434626

Line 861: IF p_return_status <> fnd_api.g_ret_sts_success THEN

857: p_start_date => g_final_start_date,
858: p_end_date => g_final_end_date,
859: p_return_status => p_return_status);
860:
861: IF p_return_status <> fnd_api.g_ret_sts_success THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864:
865: -- Introduced for bug fix 3434626

Line 862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

858: p_end_date => g_final_end_date,
859: p_return_status => p_return_status);
860:
861: IF p_return_status <> fnd_api.g_ret_sts_success THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864:
865: -- Introduced for bug fix 3434626
866: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

Line 901: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

897: changed) into psp_enc_changed_assignments table*/
898: IF r_asg_id_array.r_asg_id.count<>0 THEN
899: insert_changed_assignments (p_change_type => 'PT',
900: p_return_status => p_return_status);
901: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: END IF;
904: END IF;
905: END IF;

Line 902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

898: IF r_asg_id_array.r_asg_id.count<>0 THEN
899: insert_changed_assignments (p_change_type => 'PT',
900: p_return_status => p_return_status);
901: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
903: END IF;
904: END IF;
905: END IF;
906: ELSE

Line 916: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

912: validate_transaction_controls
913: (p_project_id => r_ls_control_rec.r_project_id(i),
914: p_payroll_id => p_payroll_id,
915: p_return_status => p_return_status);
916: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
918: END IF;
919: l_prev_tx_project_id := r_ls_control_rec.r_project_id(i);
920: END IF;

Line 917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

913: (p_project_id => r_ls_control_rec.r_project_id(i),
914: p_payroll_id => p_payroll_id,
915: p_return_status => p_return_status);
916: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
918: END IF;
919: l_prev_tx_project_id := r_ls_control_rec.r_project_id(i);
920: END IF;
921: END IF;

Line 936: p_return_status := fnd_api.g_ret_sts_success;

932: SET poeta_end_date = r_ls_control_rec.r_poeta_end_date(i),
933: poeta_start_date = r_ls_control_rec.r_poeta_start_date(i)
934: WHERE org_schedule_id = r_ls_control_rec.r_org_schedule_id(i);
935:
936: p_return_status := fnd_api.g_ret_sts_success;
937:
938: -- Introduced for bug fix 3434626
939: l_proc_step := 70;
940: hr_utility.trace('Leaving ' || l_proc_name);

Line 946: p_return_status := fnd_api.g_ret_sts_unexp_error;

942: EXCEPTION
943: WHEN OTHERS THEN
944: g_error_api_path := SUBSTR('UPDT_DFLT_LBR_SCHD:'||g_error_api_path,1,30);
945: -- bug fix 2597666
946: p_return_status := fnd_api.g_ret_sts_unexp_error;
947: -- Introduced for bug fix 3434626
948: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
949: hr_utility.trace('Leaving ' || l_proc_name);
950: -- End of bug fix 3434626

Line 1086: IF p_return_status <> fnd_api.g_ret_sts_success THEN

1082: p_start_date => g_final_start_date,
1083: p_end_date => g_final_end_date,
1084: p_return_status => p_return_status);
1085:
1086: IF p_return_status <> fnd_api.g_ret_sts_success THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: -- Introduced for bug fix 3434626

Line 1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1083: p_end_date => g_final_end_date,
1084: p_return_status => p_return_status);
1085:
1086: IF p_return_status <> fnd_api.g_ret_sts_success THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: -- Introduced for bug fix 3434626
1091: hr_utility.trace('l_poeta_start_date: ' || fnd_date.date_to_canonical(g_final_start_date) ||

Line 1128: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1124: changed) into psp_enc_changed_assignments table */
1125: IF r_asg_id_array.r_asg_id.count<>0 THEN
1126: insert_changed_assignments (p_change_type => 'PT',
1127: p_return_status => p_return_status);
1128: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: END IF;
1131: END IF;
1132: END IF;

Line 1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1125: IF r_asg_id_array.r_asg_id.count<>0 THEN
1126: insert_changed_assignments (p_change_type => 'PT',
1127: p_return_status => p_return_status);
1128: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1130: END IF;
1131: END IF;
1132: END IF;
1133: ELSE

Line 1144: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1140: validate_transaction_controls
1141: (p_project_id => r_susp_control_rec.r_project_id(i),
1142: p_payroll_id => p_payroll_id,
1143: p_return_status => p_return_status);
1144: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1146: END IF;
1147: l_prev_tx_project_id := r_susp_control_rec.r_project_id(i);
1148: END IF;

Line 1145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1141: (p_project_id => r_susp_control_rec.r_project_id(i),
1142: p_payroll_id => p_payroll_id,
1143: p_return_status => p_return_status);
1144: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1146: END IF;
1147: l_prev_tx_project_id := r_susp_control_rec.r_project_id(i);
1148: END IF;
1149: END IF;

Line 1164: p_return_status := fnd_api.g_ret_sts_success;

1160: SET poeta_end_date = r_susp_control_rec.r_poeta_end_date(i),
1161: poeta_start_date = r_susp_control_rec.r_poeta_start_date(i)
1162: WHERE organization_account_id = r_susp_control_rec.r_organization_account_id(i);
1163:
1164: p_return_status := fnd_api.g_ret_sts_success;
1165:
1166: -- Introduced for bug fix 3434626
1167: l_proc_step := 70;
1168: hr_utility.trace('Leaving ' || l_proc_name);

Line 1174: p_return_status := fnd_api.g_ret_sts_unexp_error;

1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: g_error_api_path := SUBSTR('UPDT_DFLT_SSP_ACCNT:'||g_error_api_path,1,30);
1173: -- bug fix 2597666
1174: p_return_status := fnd_api.g_ret_sts_unexp_error;
1175: -- Introduced for bug fix 3434626
1176: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1177: hr_utility.trace('Leaving ' || l_proc_name);
1178: -- End of bug fix 3434626

Line 1304: p_return_status := fnd_api.g_ret_sts_success;

1300:
1301: l_proc_step := 10;
1302: -- End of bug fix 3434626
1303:
1304: p_return_status := fnd_api.g_ret_sts_success;
1305: OPEN project_info_cur ;
1306: FETCH project_info_cur into l_proj_status_code,
1307: l_proj_start_date,l_proj_end_date,l_task_start_date,l_task_end_date;
1308: IF project_info_cur%NOTFOUND THEN

Line 1445: p_return_status := fnd_api.g_ret_sts_success;

1441:
1442: l_proc_step := 120;
1443: -- End of bug fix 3434626
1444:
1445: p_return_status := fnd_api.g_ret_sts_success;
1446:
1447: -- Introduced for bug fix 3434626
1448: hr_utility.trace('Leaving ' || l_proc_name);
1449: -- End of bug fix 3434626

Line 1454: p_return_status := fnd_api.g_ret_sts_unexp_error;

1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: g_error_api_path := SUBSTR('VALIDATE_POETA:'||g_error_api_path,1,30);
1453: -- bug fix 2597666
1454: p_return_status := fnd_api.g_ret_sts_unexp_error;
1455: -- Introduced for bug fix 3434626
1456: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1457: hr_utility.trace('Leaving ' || l_proc_name);
1458: -- End of bug fix 3434626

Line 1557: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1553:
1554: IF r_asg_id_array.r_asg_id.count<>0 THEN
1555: insert_changed_assignments (p_change_type => 'TC',
1556: p_return_status => p_return_status);
1557: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559: END IF;
1560: END IF;
1561: END IF;

Line 1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1554: IF r_asg_id_array.r_asg_id.count<>0 THEN
1555: insert_changed_assignments (p_change_type => 'TC',
1556: p_return_status => p_return_status);
1557: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559: END IF;
1560: END IF;
1561: END IF;
1562: END IF;

Line 1568: p_return_status := fnd_api.g_ret_sts_success;

1564: -- Introduced the following for bug fix 3434626
1565: l_proc_step := 50;
1566: -- End of bug fix 3434626
1567:
1568: p_return_status := fnd_api.g_ret_sts_success;
1569:
1570: -- Introduced the following for bug fix 3434626
1571: hr_utility.trace('Leaving ' || l_proc_name);
1572: -- End of bug fix 3434626

Line 1578: p_return_status := fnd_api.g_ret_sts_unexp_error;

1574: EXCEPTION
1575: WHEN OTHERS THEN
1576: g_error_api_path := SUBSTR('VLDT_TRNSCTN_CNTRLS:'||g_error_api_path,1,30);
1577: -- bug fix 2597666
1578: p_return_status := fnd_api.g_ret_sts_unexp_error;
1579: -- Introduced the following for bug fix 3434626
1580: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1581: hr_utility.trace('Leaving ' || l_proc_name);
1582: -- End of changed for bug fix 3434626

Line 1618: p_return_status := fnd_api.g_ret_sts_success;

1614:
1615: r_asg_id_array.r_asg_id.delete; -- clear the array
1616: r_asg_id_array.r_payroll_id.delete;
1617:
1618: p_return_status := fnd_api.g_ret_sts_success;
1619: -- Introduced the following for bug fix 3434626
1620: hr_utility.trace('Leaving ' || l_proc_name);
1621: -- End of changed for bug fix 3434626
1622: EXCEPTION

Line 1626: p_return_status := fnd_api.g_ret_sts_unexp_error;

1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: g_error_api_path := SUBSTR('INSERT_CHANGED_ASSIGNMENTS:'||g_error_api_path,1,30);
1625: -- bug fix 2597666
1626: p_return_status := fnd_api.g_ret_sts_unexp_error;
1627: -- Introduced the following for bug fix 3434626
1628: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1629: hr_utility.trace('Leaving ' || l_proc_name);
1630: -- End of changed for bug fix 3434626

Line 1837: p_return_status := fnd_api.g_ret_sts_success;

1833: SET request_id = g_request_id
1834: WHERE peca.payroll_id = p_payroll_id
1835: AND change_type IN ('AS', 'ET', 'LS', 'QU');
1836:
1837: p_return_status := fnd_api.g_ret_sts_success;
1838: -- Introduced the following for bug fix 3434626
1839: hr_utility.trace('Leaving: ' || l_proc_name);
1840: -- End of changed for bug fix 3434626
1841:

Line 1901: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1897: insert_changed_assignments(p_change_type => 'DA',
1898: p_reference_id => r_reference_id_array.r_reference_id(i),
1899: p_action_type => r_reference_id_array.r_action_type(i),
1900: p_return_status => p_return_status);
1901: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1902: RAISE fnd_api.g_exc_unexpected_error;
1903: END IF;
1904: END IF;
1905: /* Verifying Org. Default Account Inserts */

Line 1902: RAISE fnd_api.g_exc_unexpected_error;

1898: p_reference_id => r_reference_id_array.r_reference_id(i),
1899: p_action_type => r_reference_id_array.r_action_type(i),
1900: p_return_status => p_return_status);
1901: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1902: RAISE fnd_api.g_exc_unexpected_error;
1903: END IF;
1904: END IF;
1905: /* Verifying Org. Default Account Inserts */
1906: ELSIF (r_reference_id_array.r_change_type(i) = 'DA') AND

Line 1925: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1921: insert_changed_assignments(p_change_type => 'DA',
1922: p_reference_id => r_reference_id_array.r_reference_id(i),
1923: p_action_type => r_reference_id_array.r_action_type(i),
1924: p_return_status => p_return_status);
1925: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1926: RAISE fnd_api.g_exc_unexpected_error;
1927: END IF;
1928: END IF;
1929:

Line 1926: RAISE fnd_api.g_exc_unexpected_error;

1922: p_reference_id => r_reference_id_array.r_reference_id(i),
1923: p_action_type => r_reference_id_array.r_action_type(i),
1924: p_return_status => p_return_status);
1925: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1926: RAISE fnd_api.g_exc_unexpected_error;
1927: END IF;
1928: END IF;
1929:
1930: /* Verifying assignments affected by Org Suspense Account Changes

Line 1949: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1945: insert_changed_assignments(p_change_type => r_reference_id_array.r_change_type(i),
1946: p_reference_id => r_reference_id_array.r_reference_id(i),
1947: p_action_type => r_reference_id_array.r_action_type(i),
1948: p_return_status => p_return_status);
1949: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1950: RAISE fnd_api.g_exc_unexpected_error;
1951: END IF;
1952:
1953: /* Verifying Org. Suspense Account Inserts */

Line 1950: RAISE fnd_api.g_exc_unexpected_error;

1946: p_reference_id => r_reference_id_array.r_reference_id(i),
1947: p_action_type => r_reference_id_array.r_action_type(i),
1948: p_return_status => p_return_status);
1949: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1950: RAISE fnd_api.g_exc_unexpected_error;
1951: END IF;
1952:
1953: /* Verifying Org. Suspense Account Inserts */
1954: ELSIF (r_reference_id_array.r_change_type(i) = 'SA') AND

Line 1971: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1967: insert_changed_assignments(p_change_type => 'SA',
1968: p_reference_id => r_reference_id_array.r_reference_id(i),
1969: p_action_type => r_reference_id_array.r_action_type(i),
1970: p_return_status => p_return_status);
1971: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1972: RAISE fnd_api.g_exc_unexpected_error;
1973: END IF;
1974:
1975: /* Verifying assignments affected by Org Default LS Changes */

Line 1972: RAISE fnd_api.g_exc_unexpected_error;

1968: p_reference_id => r_reference_id_array.r_reference_id(i),
1969: p_action_type => r_reference_id_array.r_action_type(i),
1970: p_return_status => p_return_status);
1971: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1972: RAISE fnd_api.g_exc_unexpected_error;
1973: END IF;
1974:
1975: /* Verifying assignments affected by Org Default LS Changes */
1976: ELSIF (r_reference_id_array.r_change_type(i) = 'DS') AND

Line 1993: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

1989: insert_changed_assignments(p_change_type => 'DS',
1990: p_reference_id => r_reference_id_array.r_reference_id(i),
1991: p_action_type => r_reference_id_array.r_action_type(i),
1992: p_return_status => p_return_status);
1993: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1994: RAISE fnd_api.g_exc_unexpected_error;
1995: END IF;
1996: END IF;
1997:

Line 1994: RAISE fnd_api.g_exc_unexpected_error;

1990: p_reference_id => r_reference_id_array.r_reference_id(i),
1991: p_action_type => r_reference_id_array.r_action_type(i),
1992: p_return_status => p_return_status);
1993: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
1994: RAISE fnd_api.g_exc_unexpected_error;
1995: END IF;
1996: END IF;
1997:
1998: /* Verifying Org Default LS Inserts */

Line 2017: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2013: insert_changed_assignments(p_change_type => 'DS',
2014: p_reference_id => r_reference_id_array.r_reference_id(i),
2015: p_action_type => r_reference_id_array.r_action_type(i),
2016: p_return_status => p_return_status);
2017: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2018: RAISE fnd_api.g_exc_unexpected_error;
2019: END IF;
2020: END IF;
2021:

Line 2018: RAISE fnd_api.g_exc_unexpected_error;

2014: p_reference_id => r_reference_id_array.r_reference_id(i),
2015: p_action_type => r_reference_id_array.r_action_type(i),
2016: p_return_status => p_return_status);
2017: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2018: RAISE fnd_api.g_exc_unexpected_error;
2019: END IF;
2020: END IF;
2021:
2022: /* Verifying assignments affected by Global Earning Elements Changes */

Line 2039: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2035: insert_changed_assignments(p_change_type => 'GE',
2036: p_reference_id => r_reference_id_array.r_reference_id(i),
2037: p_action_type => r_reference_id_array.r_action_type(i),
2038: p_return_status => p_return_status);
2039: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2040: RAISE fnd_api.g_exc_unexpected_error;
2041: END IF;
2042:
2043: /* Verifying Global Earning Elements Inserts */

Line 2040: RAISE fnd_api.g_exc_unexpected_error;

2036: p_reference_id => r_reference_id_array.r_reference_id(i),
2037: p_action_type => r_reference_id_array.r_action_type(i),
2038: p_return_status => p_return_status);
2039: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2040: RAISE fnd_api.g_exc_unexpected_error;
2041: END IF;
2042:
2043: /* Verifying Global Earning Elements Inserts */
2044: ELSIF (r_reference_id_array.r_change_type(i) = 'GE') AND

Line 2060: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2056: insert_changed_assignments(p_change_type => 'GE',
2057: p_reference_id => r_reference_id_array.r_reference_id(i),
2058: p_action_type => r_reference_id_array.r_action_type(i),
2059: p_return_status => p_return_status);
2060: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2061: RAISE fnd_api.g_exc_unexpected_error;
2062: END IF;
2063:
2064: /* Verifying assignments affected by Enc Payroll Assignments Changes */

Line 2061: RAISE fnd_api.g_exc_unexpected_error;

2057: p_reference_id => r_reference_id_array.r_reference_id(i),
2058: p_action_type => r_reference_id_array.r_action_type(i),
2059: p_return_status => p_return_status);
2060: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2061: RAISE fnd_api.g_exc_unexpected_error;
2062: END IF;
2063:
2064: /* Verifying assignments affected by Enc Payroll Assignments Changes */
2065: ELSIF (r_reference_id_array.r_change_type(i) = 'EX') THEN

Line 2080: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2076: insert_changed_assignments(p_change_type => 'EX',
2077: p_reference_id => r_reference_id_array.r_reference_id(i),
2078: p_action_type => r_reference_id_array.r_action_type(i),
2079: p_return_status => p_return_status);
2080: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2081: RAISE fnd_api.g_exc_unexpected_error;
2082: END IF;
2083:
2084: /* Verifying assignments affected by Default Org End Date Changes */

Line 2081: RAISE fnd_api.g_exc_unexpected_error;

2077: p_reference_id => r_reference_id_array.r_reference_id(i),
2078: p_action_type => r_reference_id_array.r_action_type(i),
2079: p_return_status => p_return_status);
2080: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2081: RAISE fnd_api.g_exc_unexpected_error;
2082: END IF;
2083:
2084: /* Verifying assignments affected by Default Org End Date Changes */
2085: ELSIF (r_reference_id_array.r_change_type(i) = 'OE') THEN

Line 2116: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2112: insert_changed_assignments(p_change_type => 'OE',
2113: p_reference_id => r_reference_id_array.r_reference_id(i),
2114: p_action_type => r_reference_id_array.r_action_type(i),
2115: p_return_status => p_return_status);
2116: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2117: RAISE fnd_api.g_exc_unexpected_error;
2118: END IF;
2119:
2120: ---For Bug fix:2370841-Verifying assignments affected by Element Selection Changes

Line 2117: RAISE fnd_api.g_exc_unexpected_error;

2113: p_reference_id => r_reference_id_array.r_reference_id(i),
2114: p_action_type => r_reference_id_array.r_action_type(i),
2115: p_return_status => p_return_status);
2116: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2117: RAISE fnd_api.g_exc_unexpected_error;
2118: END IF;
2119:
2120: ---For Bug fix:2370841-Verifying assignments affected by Element Selection Changes
2121: ELSIF (r_reference_id_array.r_change_type(i) = 'ED') THEN

Line 2137: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

2133: insert_changed_assignments(p_change_type => 'ED',
2134: p_reference_id => r_reference_id_array.r_reference_id(i),
2135: p_action_type => r_reference_id_array.r_action_type(i),
2136: p_return_status => p_return_status);
2137: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2138: RAISE fnd_api.g_exc_unexpected_error;
2139: END IF;
2140: --End of Changes for the bug fix
2141: END IF;

Line 2138: RAISE fnd_api.g_exc_unexpected_error;

2134: p_reference_id => r_reference_id_array.r_reference_id(i),
2135: p_action_type => r_reference_id_array.r_action_type(i),
2136: p_return_status => p_return_status);
2137: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
2138: RAISE fnd_api.g_exc_unexpected_error;
2139: END IF;
2140: --End of Changes for the bug fix
2141: END IF;
2142: END LOOP; -- End of Enc Change Schedules loop

Line 2170: p_return_status := fnd_api.g_ret_sts_success;

2166: COMMIT;
2167:
2168: l_proc_step := 200; -- Introduced for bug fix 3434626
2169:
2170: p_return_status := fnd_api.g_ret_sts_success;
2171: -- Introduced the following for bug fix 3434626
2172: hr_utility.trace('Leaving: ' || l_proc_name);
2173: -- End of changed for bug fix 3434626
2174: EXCEPTION

Line 2179: p_return_status := fnd_api.g_ret_sts_unexp_error;

2175: WHEN OTHERS THEN
2176: g_error_api_path := 'PSP_ENC_PRE_PROCESS : LABOR_SCHEDULE_PRE_PROCESS';
2177: fnd_msg_pub.add_exc_msg('PSP_ENC_PRE_PROCESS', 'LABOR_SCHEDULE_PRE_PROCESS');
2178: ROLLBACK;
2179: p_return_status := fnd_api.g_ret_sts_unexp_error;
2180: -- Introduced the following for bug fix 3434626
2181: hr_utility.trace(fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
2182: hr_utility.trace('Leaving: ' || l_proc_name);
2183: -- End of changed for bug fix 3434626