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_LIQ_TRAN dependencies on FND_API

Line 93: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

89: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_begin');
90:
91: enc_batch_begin(p_payroll_action_id, p_payroll_id, p_action_type, l_return_status);
92:
93: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
97: / ******* No control record found. Exiting from the program successfully ******* /

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90:
91: enc_batch_begin(p_payroll_action_id, p_payroll_id, p_action_type, l_return_status);
92:
93: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
97: / ******* No control record found. Exiting from the program successfully ******* /
98: IF g_control_rec_found = 'FALSE'

Line 103: retcode := FND_API.G_RET_STS_SUCCESS;

99: THEN
100: --insert into psp_Stout values(99, 'no control rec found');
101: fnd_message.set_name('PSP','PSP_ENC_NO_LIQ_REC_FOUND');
102: fnd_msg_pub.add;
103: retcode := FND_API.G_RET_STS_SUCCESS;
104:
105: -- Added code for error message handler by Bijoy , 27-Jul-1999
106:
107: / *psp_message_s.print_error(p_mode => FND_FILE.LOG,

Line 108: p_print_header => FND_API.G_TRUE);* /

104:
105: -- Added code for error message handler by Bijoy , 27-Jul-1999
106:
107: / *psp_message_s.print_error(p_mode => FND_FILE.LOG,
108: p_print_header => FND_API.G_TRUE);* /
109: if p_action_type IN ('L', 'T') then
110: PSP_MESSAGE_S.Print_success;
111: end if;
112: return;

Line 122: If l_return_status <>FND_API.G_RET_STS_SUCCESS THEN

118: IF p_action_type in ('U','Q') then
119: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then
120: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
121: pqh_psp_integration.relieve_budget_commitments('L', l_return_status);
122: If l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
123: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
124: fnd_msg_pub.add;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126:

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: pqh_psp_integration.relieve_budget_commitments('L', l_return_status);
122: If l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
123: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
124: fnd_msg_pub.add;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126:
127:
128: end if;
129: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');

Line 144: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

140: p_action_type,
141: l_return_status
142: );
143:
144: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: --insert into psp_stout values(11,'unex error in gl_enc');
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_gl_enc_liq_lines');

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: );
143:
144: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
145: --insert into psp_stout values(11,'unex error in gl_enc');
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_gl_enc_liq_lines');
149: l_phase_status := 11 ; / * gl enc liq lines created in ist run * /
150: -- insert into psp_stout values( 'l_phase '||l_phase_status );

Line 170: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

166: p_action_type, -- Added for Restart Update Enh.
167: l_return_status
168: );
169:
170: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int
174: Calling create_gms_enc_liq_lines');

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: l_return_status
168: );
169:
170: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int
174: Calling create_gms_enc_liq_lines');
175:

Line 186: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

182: p_action_type,
183: l_return_status
184: );
185:
186: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_gms_enc_liq_lines');
190:

Line 187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

183: l_return_status
184: );
185:
186: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
188: END IF;
189: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_gms_enc_liq_lines');
190:
191: l_phase_status := 13 ; / * gms enc liq lines created in ist run * /

Line 216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

212: l_return_status
213: );
214:
215:
216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219: -- end if;
220: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213: );
214:
215:
216: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219: -- end if;
220: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
221:

Line 236: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

232: tr_to_gl_int (p_payroll_id,
233: p_action_type,
234: l_return_status);
235:
236: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
240:

Line 237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

233: p_action_type,
234: l_return_status);
235:
236: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
240:
241: l_phase_status := 16 ; / * gl transfer success in 2nd run * /

Line 253: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

249: p_action_type,
250: l_return_status
251: );
252:
253: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: l_phase_status := 15 ; / * gl enc liq lines created in 2nd run * /

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: l_return_status
251: );
252:
253: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256:
257: l_phase_status := 15 ; / * gl enc liq lines created in 2nd run * /
258: --insert_into_psp_stout( 'l_phase '||l_phase_status );

Line 275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

271: p_action_type, -- Added for Restart Update Enh.
272: l_return_status
273: );
274:
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: l_phase_status := 16 ; / * gl transfer success in 2nd run * /

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272: l_return_status
273: );
274:
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: l_phase_status := 16 ; / * gl transfer success in 2nd run * /
280: --insert_into_psp_stout( 'l_phase '||l_phase_status );

Line 288: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

284: p_action_type,
285: l_return_status
286: );
287:
288: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291:
292: l_phase_status := 17 ; / * gms enc liq lines created in 2nd run * /

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: l_return_status
286: );
287:
288: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291:
292: l_phase_status := 17 ; / * gms enc liq lines created in 2nd run * /
293: --insert_into_psp_stout( 'l_phase '||l_phase_status );

Line 312: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

308: p_action_type, -- Added for Restart Update Enh.
309: l_return_status
310: );
311:
312: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315: -- end if;
316:

Line 313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: l_return_status
310: );
311:
312: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315: -- end if;
316:
317: l_phase_status := 18 ; / * gms transfer success 2nd run * /

Line 333: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

329: g_sob_id,
330: l_return_status
331: );
332:
333: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
337: -- retcode := FND_API.G_RET_STS_SUCCESS;

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

330: l_return_status
331: );
332:
333: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
337: -- retcode := FND_API.G_RET_STS_SUCCESS;
338: -- Replaced default successful return status with warning / success based on failed transactions check

Line 337: -- retcode := FND_API.G_RET_STS_SUCCESS;

333: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
337: -- retcode := FND_API.G_RET_STS_SUCCESS;
338: -- Replaced default successful return status with warning / success based on failed transactions check
339: IF (g_liq_has_failed_transactions) THEN
340: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: TRUE');
341: retcode := fnd_api.g_ret_sts_error;

Line 341: retcode := fnd_api.g_ret_sts_error;

337: -- retcode := FND_API.G_RET_STS_SUCCESS;
338: -- Replaced default successful return status with warning / success based on failed transactions check
339: IF (g_liq_has_failed_transactions) THEN
340: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: TRUE');
341: retcode := fnd_api.g_ret_sts_error;
342: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');
343: fnd_msg_pub.add;
344: psp_message_s.print_error(p_mode => FND_FILE.LOG,
345: p_print_header => FND_API.G_TRUE);

Line 345: p_print_header => FND_API.G_TRUE);

341: retcode := fnd_api.g_ret_sts_error;
342: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');
343: fnd_msg_pub.add;
344: psp_message_s.print_error(p_mode => FND_FILE.LOG,
345: p_print_header => FND_API.G_TRUE);
346: ELSE
347: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: FALSE');
348: retcode := FND_API.G_RET_STS_SUCCESS;
349: END IF;

Line 348: retcode := FND_API.G_RET_STS_SUCCESS;

344: psp_message_s.print_error(p_mode => FND_FILE.LOG,
345: p_print_header => FND_API.G_TRUE);
346: ELSE
347: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: FALSE');
348: retcode := FND_API.G_RET_STS_SUCCESS;
349: END IF;
350: -- End of changes for Enh. removal of suspense posting in liquidation.
351:
352: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');

Line 356: p_print_header => FND_API.G_TRUE);* /

352: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
353: -- Added code for error message handler by Bijoy , 27-Jul-1999
354:
355: / *psp_message_s.print_error(p_mode => FND_FILE.LOG,
356: p_print_header => FND_API.G_TRUE);* /
357: if p_action_type ='L' then
358: PSP_MESSAGE_S.Print_success;
359: end if;
360: EXCEPTION

Line 361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

357: if p_action_type ='L' then
358: PSP_MESSAGE_S.Print_success;
359: end if;
360: EXCEPTION
361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
362: / * Bug 20393936: commented call to batch_end proc and introduced ROLLBACK * /
363: ROLLBACK;
364: / *
365: enc_batch_end( p_payroll_id,

Line 370: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

366: p_Action_type,
367: l_return_status
368: );
369:
370: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF; * /
373:
374: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;

Line 371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

367: l_return_status
368: );
369:
370: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: END IF; * /
373:
374: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
375: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');

Line 381: p_print_header => FND_API.G_TRUE);

377: -- Added code for error message handler by Bijoy , 27-Jul-1999
378:
379: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
380: psp_message_s.print_error(p_mode => FND_FILE.LOG,
381: p_print_header => FND_API.G_TRUE);
382: return;
383: WHEN OTHERS THEN
384: / * Bug 20393936: commented call to batch_end proc and introduced ROLLBACK * /
385: ROLLBACK;

Line 392: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

388: p_Action_type,
389: l_return_status
390: );
391:
392: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF; * /
395:
396: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;

Line 393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

389: l_return_status
390: );
391:
392: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF; * /
395:
396: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
397: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');

Line 403: p_print_header => FND_API.G_TRUE);

399: -- Added code for error message handler by Bijoy , 27-Jul-1999
400:
401: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
402: psp_message_s.print_error(p_mode => FND_FILE.LOG,
403: p_print_header => FND_API.G_TRUE);
404: return;
405: END enc_liq_trans;
406: End of comment for create and update multi thread enh. *****/
407:

Line 451: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

447: g_g_liq_has_failed_transactions: FALSE');
448:
449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_begin');
450: enc_batch_begin(p_payroll_action_id, l_return_status);
451: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
455:

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

448:
449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_begin');
450: enc_batch_begin(p_payroll_action_id, l_return_status);
451: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
455:
456: IF (g_control_rec_found = 'FALSE') THEN

Line 459: p_return_status := FND_API.G_RET_STS_SUCCESS;

455:
456: IF (g_control_rec_found = 'FALSE') THEN
457: fnd_message.set_name('PSP','PSP_ENC_NO_LIQ_REC_FOUND');
458: fnd_msg_pub.add;
459: p_return_status := FND_API.G_RET_STS_SUCCESS;
460: RETURN;
461: END IF;
462:
463: IF (fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y') THEN

Line 467: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

463: IF (fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y') THEN
464: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
465: pqh_psp_integration.relieve_budget_commitments('L', l_return_status);
466:
467: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
468: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
469: fnd_msg_pub.add;
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;

Line 470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

466:
467: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
468: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
469: fnd_msg_pub.add;
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');
473: END IF;
474:

Line 484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

480:
481: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
482: tr_to_gl_int(p_payroll_action_id, l_return_status);
483:
484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
488:

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

481: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
482: tr_to_gl_int(p_payroll_action_id, l_return_status);
483:
484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
488:
489: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

Line 498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

494:
495: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
496: tr_to_gms_int(p_payroll_action_id, l_return_status);
497:
498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
500: END IF;
501: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
502:

Line 499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

495: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
496: tr_to_gms_int(p_payroll_action_id, l_return_status);
497:
498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
500: END IF;
501: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
502:
503: IF (g_gl_run) THEN

Line 507: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

503: IF (g_gl_run) THEN
504: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
505: tr_to_gl_int (p_payroll_action_id, l_return_status);
506:
507: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
511: END IF;

Line 508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

504: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
505: tr_to_gl_int (p_payroll_action_id, l_return_status);
506:
507: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
509: END IF;
510: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
511: END IF;
512:

Line 517: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

513: IF (g_liq_has_failed_transactions) THEN
514: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: TRUE');
515: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');
516: fnd_msg_pub.add;
517: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
518: p_return_status := fnd_api.g_ret_sts_error;
519: ELSE
520: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: FALSE');
521: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 518: p_return_status := fnd_api.g_ret_sts_error;

514: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: TRUE');
515: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');
516: fnd_msg_pub.add;
517: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
518: p_return_status := fnd_api.g_ret_sts_error;
519: ELSE
520: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: FALSE');
521: p_return_status := FND_API.G_RET_STS_SUCCESS;
522: END IF;

Line 521: p_return_status := FND_API.G_RET_STS_SUCCESS;

517: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
518: p_return_status := fnd_api.g_ret_sts_error;
519: ELSE
520: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: FALSE');
521: p_return_status := FND_API.G_RET_STS_SUCCESS;
522: END IF;
523:
524: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
525: enc_batch_end(p_payroll_action_id, p_business_group_id, p_set_of_books_id, l_return_status);

Line 526: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

522: END IF;
523:
524: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
525: enc_batch_end(p_payroll_action_id, p_business_group_id, p_set_of_books_id, l_return_status);
526: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
530: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LIQ_TRANS');

Line 527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

523:
524: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
525: enc_batch_end(p_payroll_action_id, p_business_group_id, p_set_of_books_id, l_return_status);
526: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
528: END IF;
529: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
530: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LIQ_TRANS');
531: EXCEPTION

Line 532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

528: END IF;
529: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
530: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LIQ_TRANS');
531: EXCEPTION
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
534: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
535: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
536: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

Line 536: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
534: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
535: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
536: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
537: p_return_status := fnd_api.g_ret_sts_unexp_error;
538: WHEN OTHERS THEN
539: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
540: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');

Line 537: p_return_status := fnd_api.g_ret_sts_unexp_error;

533: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
534: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
535: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
536: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
537: p_return_status := fnd_api.g_ret_sts_unexp_error;
538: WHEN OTHERS THEN
539: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
540: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');

Line 542: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);

538: WHEN OTHERS THEN
539: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
540: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
542: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
543: p_return_status := fnd_api.g_ret_sts_unexp_error;
544: END enc_liq_trans;
545: -- End of changes for Create and update multi thread enh.
546: -- #######################################################################

Line 543: p_return_status := fnd_api.g_ret_sts_unexp_error;

539: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
540: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
542: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
543: p_return_status := fnd_api.g_ret_sts_unexp_error;
544: END enc_liq_trans;
545: -- End of changes for Create and update multi thread enh.
546: -- #######################################################################
547: -- This procedure begins the encumbrance liquidation process

Line 927: p_return_status := fnd_api.g_ret_sts_success;

923: FETCH enc_control_cur1 INTO enc_control_rec1;
924: IF enc_control_cur1%rowcount = 0
925: then
926: g_control_rec_found := 'FALSE';
927: p_return_status := fnd_api.g_ret_sts_success;
928: EXIT;
929: end if;
930: IF enc_control_cur1%NOTFOUND THEN
931: CLOSE enc_control_cur1;

Line 953: p_return_status := fnd_api.g_ret_sts_success;

949: FETCH enc_control_cur2 INTO enc_control_rec2;
950: IF enc_control_cur2%rowcount = 0
951: then
952: g_control_rec_found := 'FALSE';
953: p_return_status := fnd_api.g_ret_sts_success;
954: EXIT;
955: end if;
956: IF enc_control_cur2%NOTFOUND THEN
957: CLOSE enc_control_cur2;

Line 980: p_return_status := fnd_api.g_ret_sts_success;

976: FETCH enc_control_cur3 INTO enc_control_rec3;
977: IF enc_control_cur3%rowcount = 0
978: then
979: g_control_rec_found := 'FALSE';
980: p_return_status := fnd_api.g_ret_sts_success;
981: EXIT;
982: end if;
983: IF enc_control_cur3%NOTFOUND THEN
984: CLOSE enc_control_cur3;

Line 1216: p_return_status := fnd_api.g_ret_sts_success;

1212: LPAD(r_summary_lines.summary_lines_count(recno), 15, ' '));
1213: END LOOP;
1214:
1215: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_BATCH_BEGIN');
1216: p_return_status := fnd_api.g_ret_sts_success;
1217: END enc_batch_begin;
1218:
1219: -- ##########################################################################
1220: -- This procedure ends the encumbrance liquidation process

Line 1509: IF p_return_status <> fnd_api.g_ret_sts_success THEN

1505: p_set_of_books_id,
1506: p_return_status);
1507: END IF;
1508:
1509: IF p_return_status <> fnd_api.g_ret_sts_success THEN
1510: RAISE fnd_api.g_exc_unexpected_error;
1511: END IF;
1512: END IF;
1513: End of comment for Create and Update multi thread *****/

Line 1510: RAISE fnd_api.g_exc_unexpected_error;

1506: p_return_status);
1507: END IF;
1508:
1509: IF p_return_status <> fnd_api.g_ret_sts_success THEN
1510: RAISE fnd_api.g_exc_unexpected_error;
1511: END IF;
1512: END IF;
1513: End of comment for Create and Update multi thread *****/
1514:

Line 1548: p_return_status := fnd_api.g_ret_sts_success;

1544: AND pesl.status_code = 'N'
1545: AND pesl.superceded_line_id IS NOT NULL);
1546:
1547: COMMIT;
1548: p_return_status := fnd_api.g_ret_sts_success;
1549:
1550: OPEN summary_lines_cur;
1551: FETCH summary_lines_cur BULK COLLECT INTO r_summary_lines.person_id, r_summary_lines.full_name,
1552: r_summary_lines.employee_number, r_summary_lines.assignment_id,

Line 1846: IF p_return_status = fnd_api.g_ret_sts_success THEN

1842: p_business_group_id,
1843: p_set_of_books_id,
1844: p_return_status);
1845: end if;
1846: IF p_return_status = fnd_api.g_ret_sts_success THEN
1847: COMMIT;
1848: ELSE
1849: RAISE fnd_api.g_exc_unexpected_error;
1850: END IF;

Line 1849: RAISE fnd_api.g_exc_unexpected_error;

1845: end if;
1846: IF p_return_status = fnd_api.g_ret_sts_success THEN
1847: COMMIT;
1848: ELSE
1849: RAISE fnd_api.g_exc_unexpected_error;
1850: END IF;
1851: end if;
1852: ---END IF;
1853:

Line 1855: p_return_status := fnd_api.g_ret_sts_success;/ * pulled this line from below commit * /

1851: end if;
1852: ---END IF;
1853:
1854: / * Added For Restart Update/Quick Update Encumbrance Lines Enh. * /
1855: p_return_status := fnd_api.g_ret_sts_success;/ * pulled this line from below commit * /
1856: ---IF p_mode = 'N' THEN / * Call the house keeping step only in normal mode * /
1857:
1858: / * Commented for Restart Update/Quick Update Encumbrance Lines Enh.
1859: and the same code is moved to PSPENUPB

Line 1902: IF (l_status_code <> fnd_api.g_ret_sts_success) THEN

1898: p_action_type,
1899: p_business_group_id,
1900: p_set_of_books_id,
1901: l_status_code);
1902: IF (l_status_code <> fnd_api.g_ret_sts_success) THEN
1903: g_error_api_path := 'MOVE_QKUPD_REC_TO_HIST: ' || g_error_api_path;
1904: RAISE fnd_api.g_exc_unexpected_error;
1905: END IF;
1906: END IF;

Line 1904: RAISE fnd_api.g_exc_unexpected_error;

1900: p_set_of_books_id,
1901: l_status_code);
1902: IF (l_status_code <> fnd_api.g_ret_sts_success) THEN
1903: g_error_api_path := 'MOVE_QKUPD_REC_TO_HIST: ' || g_error_api_path;
1904: RAISE fnd_api.g_exc_unexpected_error;
1905: END IF;
1906: END IF;
1907: COMMIT;
1908: END IF;

Line 1911: p_return_status := fnd_api.g_ret_sts_success;

1907: COMMIT;
1908: END IF;
1909: -- End of Enh. fix 2143723
1910:
1911: p_return_status := fnd_api.g_ret_sts_success;
1912: * /
1913: END enc_batch_end;
1914: End of comment for bug fix 4625734 ****/
1915:

Line 2236: p_return_status := fnd_api.g_ret_sts_success;

2232: WHERE enc_control_id = r_liq_lines.enc_control_id(recno);
2233:
2234: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gl_phase to ''Summarize'' in psp_enc_controls');
2235:
2236: p_return_status := fnd_api.g_ret_sts_success;
2237:
2238: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2239: EXCEPTION
2240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2236: p_return_status := fnd_api.g_ret_sts_success;
2237:
2238: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2239: EXCEPTION
2240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2241: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2242: p_return_status := fnd_api.g_ret_sts_unexp_error;
2243: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2244: WHEN OTHERS THEN

Line 2242: p_return_status := fnd_api.g_ret_sts_unexp_error;

2238: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2239: EXCEPTION
2240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2241: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2242: p_return_status := fnd_api.g_ret_sts_unexp_error;
2243: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2244: WHEN OTHERS THEN
2245: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2246: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');

Line 2247: p_return_status := fnd_api.g_ret_sts_unexp_error;

2243: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2244: WHEN OTHERS THEN
2245: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2246: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');
2247: p_return_status := fnd_api.g_ret_sts_unexp_error;
2248: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2249: END create_gl_enc_liq_lines;
2250: -- End of changes for bg fix 4625734
2251:

Line 2400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2396: enc_liq_rec.attribute10,
2397: NULL, -- Bug 4068182
2398: l_return_status);
2399:
2400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402: END IF;
2403:
2404: / * Flag the original line as Superceded* /

Line 2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2397: NULL, -- Bug 4068182
2398: l_return_status);
2399:
2400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2402: END IF;
2403:
2404: / * Flag the original line as Superceded* /
2405: update psp_enc_summary_lines set status_code='S'

Line 2420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2416: where enc_control_id = enc_control_rec.enc_control_id;
2417: l_count := 0;
2418: end if;
2419:
2420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2422: END IF;
2423: END LOOP;
2424: --COMMIT;

Line 2421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2417: l_count := 0;
2418: end if;
2419:
2420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2422: END IF;
2423: END LOOP;
2424: --COMMIT;
2425: p_return_status := fnd_api.g_ret_sts_success;

Line 2425: p_return_status := fnd_api.g_ret_sts_success;

2421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2422: END IF;
2423: END LOOP;
2424: --COMMIT;
2425: p_return_status := fnd_api.g_ret_sts_success;
2426:
2427: EXCEPTION
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;

Line 2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2424: --COMMIT;
2425: p_return_status := fnd_api.g_ret_sts_success;
2426:
2427: EXCEPTION
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2430: p_return_status := fnd_api.g_ret_sts_unexp_error;
2431: WHEN OTHERS THEN
2432: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;

Line 2430: p_return_status := fnd_api.g_ret_sts_unexp_error;

2426:
2427: EXCEPTION
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2430: p_return_status := fnd_api.g_ret_sts_unexp_error;
2431: WHEN OTHERS THEN
2432: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2433: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');
2434: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2434: p_return_status := fnd_api.g_ret_sts_unexp_error;

2430: p_return_status := fnd_api.g_ret_sts_unexp_error;
2431: WHEN OTHERS THEN
2432: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2433: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');
2434: p_return_status := fnd_api.g_ret_sts_unexp_error;
2435: END create_gl_enc_liq_lines;
2436: End of comment for bug fix 4625734 *****/
2437:
2438: /***** Commented the following procedure as it is no longer used (for bug fix 4625734)

Line 2570: p_return_status := fnd_api.g_ret_sts_success;

2566: FND_GLOBAL.USER_ID,
2567: FND_GLOBAL.LOGIN_ID,
2568: FND_GLOBAL.USER_ID,
2569: SYSDATE);
2570: p_return_status := fnd_api.g_ret_sts_success;
2571:
2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: --dbms_output.put_line('Insert into psp_enc_summary_lines failed');

Line 2577: p_return_status := fnd_api.g_ret_sts_unexp_error;

2573: WHEN OTHERS THEN
2574: --dbms_output.put_line('Insert into psp_enc_summary_lines failed');
2575: g_error_api_path := 'insert_into_enc_sum_lines:'||g_error_api_path;
2576: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','INSERT_INTO_ENC_SUM_LINES');
2577: p_return_status := fnd_api.g_ret_sts_unexp_error;
2578: END insert_into_enc_sum_lines;
2579: End of comment for bug fix 4625734 *****/
2580:
2581: -- ##########################################################################

Line 2748: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2744: -- gl_tie_tab.delete; Commented for bug fix 4625734
2745:
2746: gl_je_source( l_user_je_source,
2747: l_return_status);
2748: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751:
2752: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);

Line 2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2745:
2746: gl_je_source( l_user_je_source,
2747: l_return_status);
2748: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751:
2752: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);
2753:

Line 2756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2752: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);
2753:
2754: gl_je_cat( l_user_je_cat,
2755: l_return_status);
2756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2758: END IF;
2759:
2760: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);

Line 2757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2753:
2754: gl_je_cat( l_user_je_cat,
2755: l_return_status);
2756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2758: END IF;
2759:
2760: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);
2761:

Line 2764: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2760: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);
2761:
2762: enc_type( l_enc_type_id,
2763: l_return_status);
2764: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2766: END IF;
2767:
2768: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);

Line 2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2761:
2762: enc_type( l_enc_type_id,
2763: l_return_status);
2764: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2766: END IF;
2767:
2768: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2769:

Line 2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2873: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2874: fnd_message.set_token('VALUE','l_value');
2875: fnd_message.set_token('TABLE','l_table');
2876: fnd_msg_pub.add;
2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2878: END;
2879: If enc_control_rec.gl_phase = 'Summarize' then --- added for 2444657
2880: UPDATE psp_enc_summary_lines
2881: SET group_id = l_group_id

Line 2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2913: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2914: fnd_message.set_token('ERROR','l_error');
2915: fnd_message.set_token('PRODUCT','l_product');
2916: fnd_msg_pub.add;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END;* /
2919: -- End of Comments for bug 2478000
2920:
2921:

Line 2986: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2982: INT_REC.ATTRIBUTE29,
2983: INT_REC.ATTRIBUTE30,
2984: L_RETURN_STATUS);
2985:
2986: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2987: --dbms_output.put_line('Insert into gl_interface failed');
2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2989: END IF;
2990:

Line 2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2984: L_RETURN_STATUS);
2985:
2986: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2987: --dbms_output.put_line('Insert into gl_interface failed');
2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2989: END IF;
2990:
2991: END LOOP; --int_cur loop
2992: end if; --- phase = 'Summarize' ... for 2444657

Line 3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3062: -- insert into psp_stout values(0, 'req did not get submitted');
3063:
3064: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3065: fnd_msg_pub.add;
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: ELSE
3069: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Journal Import (req_id: ' || req_id || ')');
3070: -- insert into psp_stout values(94, 'transfer in Gl');

Line 3111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3107: IF call_status = FALSE then
3108: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
3109: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3110: fnd_msg_pub.add;
3111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3112: END IF;
3113: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');
3114: END IF;
3115: END IF; -- l_rec_count > 0 moved this from below tie back for 2444657 (checks interface.COUNT bug 4625734)

Line 3129: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN --- moved this stmnt inside loop

3125: g_sob_id,
3126: 'N', -- Bug 2039196: new parameter.
3127: p_action_type, -- Added for Restart Update Enh.
3128: l_return_status);
3129: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN --- moved this stmnt inside loop
3130: l_tie_back_failed := 'Y'; -- 2479579
3131: END IF;
3132: end loop;
3133: end of comment for bug fix 4625734 *****/

Line 3155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3151: 'N',
3152: NULL, --p_action_type,
3153: l_return_status);
3154:
3155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gl_enc_tie_back failed for group_id: ' || r_groups.group_id(recno));
3158: ELSE
3159: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gl_enc_tie_back successful for group_id: ' || r_groups.group_id(recno));

Line 3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3152: NULL, --p_action_type,
3153: l_return_status);
3154:
3155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3157: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gl_enc_tie_back failed for group_id: ' || r_groups.group_id(recno));
3158: ELSE
3159: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gl_enc_tie_back successful for group_id: ' || r_groups.group_id(recno));
3160: END IF;

Line 3206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3202:
3203: /***** commented for Enh. 2768298 Removal of suspense posting in liquidation
3204: if g_invalid_suspense = 'Y' then -- introduced this IF-ELSE for 2479579
3205: enc_batch_end(g_payroll_id,p_action_type,'N',g_bg_id,g_sob_id,l_return_status);
3206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3207: end if;
3208: End of comment for Enh. 2768298 Removal of suspense posting in Liquidation *****/
3209:
3210: p_return_status := fnd_api.g_ret_sts_success;

Line 3210: p_return_status := fnd_api.g_ret_sts_success;

3206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3207: end if;
3208: End of comment for Enh. 2768298 Removal of suspense posting in Liquidation *****/
3209:
3210: p_return_status := fnd_api.g_ret_sts_success;
3211: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
3212: EXCEPTION
3213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3214: --dbms_output.put_line('Gone to one level top ..................');

Line 3213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3209:
3210: p_return_status := fnd_api.g_ret_sts_success;
3211: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
3212: EXCEPTION
3213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3214: --dbms_output.put_line('Gone to one level top ..................');
3215: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
3216: p_return_status := fnd_api.g_ret_sts_unexp_error;
3217: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');

Line 3216: p_return_status := fnd_api.g_ret_sts_unexp_error;

3212: EXCEPTION
3213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3214: --dbms_output.put_line('Gone to one level top ..................');
3215: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
3216: p_return_status := fnd_api.g_ret_sts_unexp_error;
3217: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
3218: /***** Commented for bug fix 4625734
3219: WHEN RETURN_BACK THEN
3220: p_return_status := fnd_api.g_ret_sts_success;

Line 3220: p_return_status := fnd_api.g_ret_sts_success;

3216: p_return_status := fnd_api.g_ret_sts_unexp_error;
3217: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
3218: /***** Commented for bug fix 4625734
3219: WHEN RETURN_BACK THEN
3220: p_return_status := fnd_api.g_ret_sts_success;
3221: End of comment for bug fix 4625734 *****/
3222: WHEN OTHERS THEN
3223: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
3224: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GL_INT');

Line 3225: p_return_status := fnd_api.g_ret_sts_unexp_error;

3221: End of comment for bug fix 4625734 *****/
3222: WHEN OTHERS THEN
3223: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
3224: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GL_INT');
3225: p_return_status := fnd_api.g_ret_sts_unexp_error;
3226: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
3227: END tr_to_gl_int;
3228:
3229: -- ##########################################################################

Line 3250: p_return_status := fnd_api.g_ret_sts_unexp_error;

3246: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3247: fnd_message.set_token('ERROR',l_error);
3248: fnd_message.set_token('PRODUCT',l_product);
3249: fnd_msg_pub.add;
3250: p_return_status := fnd_api.g_ret_sts_unexp_error;
3251: WHEN OTHERS THEN
3252: g_error_api_path := 'gl_je_source:'||g_error_api_path;
3253: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_source');
3254: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3254: p_return_status := fnd_api.g_ret_sts_unexp_error;

3250: p_return_status := fnd_api.g_ret_sts_unexp_error;
3251: WHEN OTHERS THEN
3252: g_error_api_path := 'gl_je_source:'||g_error_api_path;
3253: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_source');
3254: p_return_status := fnd_api.g_ret_sts_unexp_error;
3255: END gl_je_source;
3256:
3257: -- ##########################################################################
3258: -- This procedure retrieves the user_je_category_name from gl_je_categories

Line 3278: p_return_status := fnd_api.g_ret_sts_unexp_error;

3274: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3275: fnd_message.set_token('ERROR',l_error);
3276: fnd_message.set_token('PRODUCT',l_product);
3277: fnd_msg_pub.add;
3278: p_return_status := fnd_api.g_ret_sts_unexp_error;
3279: WHEN OTHERS THEN
3280: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
3281: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_cat');
3282: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3282: p_return_status := fnd_api.g_ret_sts_unexp_error;

3278: p_return_status := fnd_api.g_ret_sts_unexp_error;
3279: WHEN OTHERS THEN
3280: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
3281: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_cat');
3282: p_return_status := fnd_api.g_ret_sts_unexp_error;
3283: END gl_je_cat;
3284:
3285: -- ##########################################################################
3286: -- This procedure retrieves the encumbrance_type_id from gl_encumbrance_types

Line 3309: p_return_status := fnd_api.g_ret_sts_unexp_error;

3305: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3306: fnd_message.set_token('ERROR',l_error);
3307: fnd_message.set_token('PRODUCT',l_product);
3308: fnd_msg_pub.add;
3309: p_return_status := fnd_api.g_ret_sts_unexp_error;
3310: WHEN OTHERS THEN
3311: g_error_api_path := 'enc_type:'||g_error_api_path;
3312: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','enc_type');
3313: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3313: p_return_status := fnd_api.g_ret_sts_unexp_error;

3309: p_return_status := fnd_api.g_ret_sts_unexp_error;
3310: WHEN OTHERS THEN
3311: g_error_api_path := 'enc_type:'||g_error_api_path;
3312: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','enc_type');
3313: p_return_status := fnd_api.g_ret_sts_unexp_error;
3314:
3315: END enc_type;
3316:
3317: -- ##########################################################################

Line 3965: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3961: l_award_id,
3962: l_task_id,
3963: l_effective_date,
3964: l_return_status);
3965: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3966: --insert_into_psp_stout( 'poeta call failed ');
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END IF;
3969:

Line 3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3963: l_effective_date,
3964: l_return_status);
3965: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3966: --insert_into_psp_stout( 'poeta call failed ');
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3968: END IF;
3969:
3970: END IF;
3971:

Line 4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4030: IF l_reversal_ac_failed = 'Y' THEN
4031: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
4032: fnd_message.set_token('GLCCID',x_lines_glccid);
4033: fnd_msg_pub.add;
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: END IF; * /
4036:
4037: / ***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
4038: IF l_suspense_ac_failed = 'Y' THEN

Line 4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4061: fnd_msg_pub.add;
4062: -- Bug 2039196: Introduced the if condn.
4063: if p_mode = 'N' then
4064: enc_batch_end(g_payroll_id,p_action_type, 'N',g_bg_id, g_sob_id,l_return_status);
4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4066: end if;
4067: END IF;
4068: * /
4069:

Line 4136: p_return_status := fnd_api.g_ret_sts_success;

4132:
4133: --
4134: END IF; -- IF (PROCESS_COMPLETE)
4135:
4136: p_return_status := fnd_api.g_ret_sts_success;
4137: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
4138: EXCEPTION
4139:
4140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4136: p_return_status := fnd_api.g_ret_sts_success;
4137: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
4138: EXCEPTION
4139:
4140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4141: --dbms_output.put_line('Gone to one level top ..................');
4142: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
4143: p_return_status := fnd_api.g_ret_sts_unexp_error;
4144: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');

Line 4143: p_return_status := fnd_api.g_ret_sts_unexp_error;

4139:
4140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4141: --dbms_output.put_line('Gone to one level top ..................');
4142: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
4143: p_return_status := fnd_api.g_ret_sts_unexp_error;
4144: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
4145: /***** Commented the following as part of bug fix 4625734
4146: / * Added Exceptions for bug 2056877 * /
4147: WHEN NO_PROFILE_EXISTS THEN

Line 4151: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579

4147: WHEN NO_PROFILE_EXISTS THEN
4148: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4149: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
4150: fnd_msg_pub.add;
4151: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4152:
4153: WHEN NO_VAL_DATE_MATCHES THEN
4154: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4155: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

Line 4159: p_return_status := fnd_api.g_ret_sts_unexp_error;

4155: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4156: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4157: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4158: fnd_msg_pub.add;
4159: p_return_status := fnd_api.g_ret_sts_unexp_error;
4160: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4161:
4162: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4163: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 4160: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579

4156: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4157: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4158: fnd_msg_pub.add;
4159: p_return_status := fnd_api.g_ret_sts_unexp_error;
4160: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4161:
4162: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4163: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4164: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

Line 4168: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.

4164: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4165: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4166: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4167: fnd_msg_pub.add;
4168: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.
4169: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4170: end of comment for bug fix 4625734 *****/
4171:
4172: WHEN OTHERS THEN

Line 4169: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579

4165: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4166: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4167: fnd_msg_pub.add;
4168: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.
4169: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4170: end of comment for bug fix 4625734 *****/
4171:
4172: WHEN OTHERS THEN
4173: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;

Line 4175: p_return_status := fnd_api.g_ret_sts_unexp_error;

4171:
4172: WHEN OTHERS THEN
4173: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
4174: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','GL_ENC_TIE_BACK');
4175: p_return_status := fnd_api.g_ret_sts_unexp_error;
4176: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
4177:
4178: END gl_enc_tie_back;
4179:

Line 4336: p_return_status := fnd_api.g_ret_sts_success;

4332: P_ATTRIBUTE29,
4333: P_ATTRIBUTE30);
4334: --dbms_output.put_line('Insert into gl_interface successful.................');
4335:
4336: p_return_status := fnd_api.g_ret_sts_success;
4337:
4338: EXCEPTION
4339: WHEN OTHERS THEN
4340: --dbms_output.put_line('Error while inserting into gl_interface..........');

Line 4343: p_return_status := fnd_api.g_ret_sts_unexp_error;

4339: WHEN OTHERS THEN
4340: --dbms_output.put_line('Error while inserting into gl_interface..........');
4341: g_error_api_path := 'insert_into_gl_int:'||g_error_api_path;
4342: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','insert_into_gl_int');
4343: p_return_status := fnd_api.g_ret_sts_unexp_error;
4344:
4345:
4346: END insert_into_gl_int;
4347: End of comment for bug fix 4625734 *****/

Line 4718: p_return_status := fnd_api.g_ret_sts_success;

4714: WHERE enc_control_id = r_liq_lines.enc_control_id(recno);
4715:
4716: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated gms_phase to ''Summarize'' in psp_enc_controls');
4717:
4718: p_return_status := fnd_api.g_ret_sts_success;
4719:
4720: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4721: EXCEPTION
4722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4718: p_return_status := fnd_api.g_ret_sts_success;
4719:
4720: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4721: EXCEPTION
4722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4723: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4724: p_return_status := fnd_api.g_ret_sts_unexp_error;
4725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4726: WHEN OTHERS THEN

Line 4724: p_return_status := fnd_api.g_ret_sts_unexp_error;

4720: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4721: EXCEPTION
4722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4723: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4724: p_return_status := fnd_api.g_ret_sts_unexp_error;
4725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4726: WHEN OTHERS THEN
4727: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4728: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');

Line 4729: p_return_status := fnd_api.g_ret_sts_unexp_error;

4725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4726: WHEN OTHERS THEN
4727: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4728: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');
4729: p_return_status := fnd_api.g_ret_sts_unexp_error;
4730: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4731: END create_gms_enc_liq_lines;
4732: -- End of changes for bug fix 4625734
4733:

Line 4905: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4901: enc_liq_rec.attribute9,
4902: enc_liq_rec.attribute10,
4903: enc_liq_rec.expenditure_item_id, -- Introduced for bug 4068182
4904: p_return_status);
4905: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4907: END IF;
4908:
4909: / * Flag the original line as Superceded* /

Line 4906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4902: enc_liq_rec.attribute10,
4903: enc_liq_rec.expenditure_item_id, -- Introduced for bug 4068182
4904: p_return_status);
4905: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4907: END IF;
4908:
4909: / * Flag the original line as Superceded* /
4910: update psp_enc_summary_lines set status_code='S'

Line 4916: p_return_status := fnd_api.g_ret_sts_success;

4912: END LOOP;
4913:
4914: END LOOP;
4915:
4916: p_return_status := fnd_api.g_ret_sts_success;
4917: EXCEPTION
4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4920: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4914: END LOOP;
4915:
4916: p_return_status := fnd_api.g_ret_sts_success;
4917: EXCEPTION
4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4920: p_return_status := fnd_api.g_ret_sts_unexp_error;
4921: WHEN OTHERS THEN
4922: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;

Line 4920: p_return_status := fnd_api.g_ret_sts_unexp_error;

4916: p_return_status := fnd_api.g_ret_sts_success;
4917: EXCEPTION
4918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4919: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4920: p_return_status := fnd_api.g_ret_sts_unexp_error;
4921: WHEN OTHERS THEN
4922: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4923: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');
4924: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4924: p_return_status := fnd_api.g_ret_sts_unexp_error;

4920: p_return_status := fnd_api.g_ret_sts_unexp_error;
4921: WHEN OTHERS THEN
4922: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4923: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');
4924: p_return_status := fnd_api.g_ret_sts_unexp_error;
4925: END create_gms_enc_liq_lines;
4926: End of comment for bug fix 4625734 *****/
4927:
4928: -- ##########################################################################

Line 5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5202: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5203: fnd_message.set_token('ERROR',l_error);
5204: fnd_message.set_token('PRODUCT',l_product);
5205: fnd_msg_pub.add;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END;
5208: End of comment for bug fix 4625734 *****/
5209: OPEN transaction_source_cur;
5210: FETCH transaction_source_cur INTO l_gms_transaction_source;

Line 5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5214: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5215: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5216: fnd_message.set_token('PRODUCT','GMS');
5217: fnd_msg_pub.add;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5219: END IF;
5220: end if;
5221:
5222: /***** Commented as part of bug fix 4625734

Line 5225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5221:
5222: /***** Commented as part of bug fix 4625734
5223: enc_type( l_enc_type_id,
5224: l_return_status);
5225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5227: END IF;
5228: --dbms_output.put_line('enc type='||l_enc_type_id);
5229: End of comment for bg fix 4625734 *****/

Line 5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5222: /***** Commented as part of bug fix 4625734
5223: enc_type( l_enc_type_id,
5224: l_return_status);
5225: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5227: END IF;
5228: --dbms_output.put_line('enc type='||l_enc_type_id);
5229: End of comment for bg fix 4625734 *****/
5230:

Line 5355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5351: END LOOP;
5352:
5353: IF l_raise_error THEN
5354: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Interface records have errors');
5355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5356: END IF;
5357:
5358: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed interface records for errors');
5359: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Computing PA week ending date(s)');

Line 5446: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5442: GMS_REC.ORIGINAL_ENCUMBRANCE_ITEM_ID := l_expenditure_item_id; --Bug 6062628
5443:
5444: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5445:
5446: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5447: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5448: fnd_msg_pub.add;
5449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5450: END IF;

Line 5449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5445:
5446: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5447: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5448: fnd_msg_pub.add;
5449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5450: END IF;
5451: END LOOP;
5452: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all');
5453:

Line 5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5504: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5505: fnd_message.set_token('VALUE',l_value);
5506: fnd_message.set_token('TABLE',l_table);
5507: fnd_msg_pub.add;
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: END;
5510: --dbms_output.put_line('emp num='||l_emp_num);
5511:
5512: BEGIN

Line 5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5521: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5522: fnd_message.set_token('VALUE',l_value);
5523: fnd_message.set_token('TABLE',l_table);
5524: fnd_msg_pub.add;
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: END;
5527: --dbms_output.put_line('org name='||l_org_name);
5528:
5529: BEGIN

Line 5542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5538: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5539: fnd_message.set_token('VALUE',l_value);
5540: fnd_message.set_token('TABLE',l_table);
5541: fnd_msg_pub.add;
5542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5543: END;
5544:
5545: BEGIN
5546: SELECT segment1

Line 5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5554: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5555: fnd_message.set_token('VALUE',l_value);
5556: fnd_message.set_token('TABLE',l_table);
5557: fnd_msg_pub.add;
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: END;
5560: --dbms_output.put_line('seg1='||l_seg1);
5561:
5562: BEGIN

Line 5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5571: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5572: fnd_message.set_token('VALUE',l_value);
5573: fnd_message.set_token('TABLE',l_table);
5574: fnd_msg_pub.add;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5576: END;
5577: --dbms_output.put_line('task='||l_task_number);
5578: l_rec_count := l_rec_count + 1;
5579:

Line 5654: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5650: int_rec.attribute10,
5651: g_bg_id, -- Introduced for Bug 2935850
5652: l_return_status);
5653:
5654: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5656: END IF;
5657: end if; --- If award id is not null
5658:

Line 5655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5651: g_bg_id, -- Introduced for Bug 2935850
5652: l_return_status);
5653:
5654: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5656: END IF;
5657: end if; --- If award id is not null
5658:
5659: -- insert into gms_interface table if there are awards..

Line 5685: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5681: GMS_REC.ORIGINAL_ENCUMBRANCE_ITEM_ID:= int_rec.expenditure_item_id; -- Introduced for bug fix 4033329
5682:
5683: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5684:
5685: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5686: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5687: fnd_msg_pub.add;
5688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5689: END IF;

Line 5688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5684:
5685: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5686: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5687: fnd_msg_pub.add;
5688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5689: END IF;
5690:
5691: end if;
5692:

Line 5743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5739: IF req_id_tab(request_counter) = 0 THEN
5740: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
5741: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5742: fnd_msg_pub.add;
5743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5744: ELSE
5745: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');
5746:
5747: /***** Modified teh following update to BULK UPDATE for R12 performance fixes (bug 4507892)

Line 5789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5785: IF call_status = FALSE then
5786: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
5787: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5788: fnd_msg_pub.add;
5789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5790: END IF;
5791: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');
5792: END LOOP;
5793: END IF; --record_count > 0 ...move this line from below delete xface...for 2444657

Line 5815: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5811: 'N', ---Bug 2039196: introduced this param
5812: p_action_type, -- Added for Restart Update Enh.
5813: l_return_status);
5814: -- moved this check into the loop for 2479579
5815: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5816: l_tie_back_failed := 'Y'; --- introduced for 2479579
5817: END IF;
5818: end loop;
5819: End of comment for bug fix 4625734 *****/

Line 5840: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5836: 'N',
5837: NULL, --p_action_type,
5838: l_return_status);
5839:
5840: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5841: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gms_enc_tie_back failed for gms_batch_name: ' || r_gms_batch.gms_batch_name(recno));
5842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5843: END IF;
5844: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gms_enc_tie_back successful for gms_batch_name: ' || r_gms_batch.gms_batch_name(recno));

Line 5842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5838: l_return_status);
5839:
5840: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5841: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gms_enc_tie_back failed for gms_batch_name: ' || r_gms_batch.gms_batch_name(recno));
5842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5843: END IF;
5844: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gms_enc_tie_back successful for gms_batch_name: ' || r_gms_batch.gms_batch_name(recno));
5845: END LOOP;
5846: -- End of changes for bug fix 4625734

Line 5898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5894:
5895: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
5896: if g_invalid_suspense = 'Y' then -- introduced this IF-ELSE for 2479579
5897: enc_batch_end(g_payroll_id,p_action_type,'N',g_bg_id,g_sob_id,l_return_status);
5898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5899: end if;
5900: End of somment for Enh. Removal of suspense posting in Liquidation *****/
5901:
5902:

Line 5903: p_return_status := fnd_api.g_ret_sts_success;

5899: end if;
5900: End of somment for Enh. Removal of suspense posting in Liquidation *****/
5901:
5902:
5903: p_return_status := fnd_api.g_ret_sts_success;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5907: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5901:
5902:
5903: p_return_status := fnd_api.g_ret_sts_success;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5907: p_return_status := fnd_api.g_ret_sts_unexp_error;
5908:
5909: WHEN RETURN_BACK THEN

Line 5907: p_return_status := fnd_api.g_ret_sts_unexp_error;

5903: p_return_status := fnd_api.g_ret_sts_success;
5904: EXCEPTION
5905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5906: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5907: p_return_status := fnd_api.g_ret_sts_unexp_error;
5908:
5909: WHEN RETURN_BACK THEN
5910: p_return_status := fnd_api.g_ret_sts_success;
5911:

Line 5910: p_return_status := fnd_api.g_ret_sts_success;

5906: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5907: p_return_status := fnd_api.g_ret_sts_unexp_error;
5908:
5909: WHEN RETURN_BACK THEN
5910: p_return_status := fnd_api.g_ret_sts_success;
5911:
5912: WHEN OTHERS THEN
5913: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5914: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GMS_INT');

Line 5915: p_return_status := fnd_api.g_ret_sts_unexp_error;

5911:
5912: WHEN OTHERS THEN
5913: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5914: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GMS_INT');
5915: p_return_status := fnd_api.g_ret_sts_unexp_error;
5916:
5917: END tr_to_gms_int;
5918:
5919: -- ##########################################################################

Line 6611: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6607: l_award_id,
6608: l_task_id,
6609: l_effective_date,
6610: l_return_status);
6611: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6613: END IF;
6614:
6615:

Line 6612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6608: l_task_id,
6609: l_effective_date,
6610: l_return_status);
6611: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6613: END IF;
6614:
6615:
6616: END IF;

Line 6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6694: fnd_msg_pub.add;
6695: -- Bug 2039196: Introduced the if condn.
6696: if p_mode = 'N' then
6697: enc_batch_end(g_payroll_id,g_action_type, 'N',g_bg_id, g_sob_id,l_return_status);
6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6699: end if;
6700: END IF;
6701: */
6702: ELSIF l_cnt_gms_interface = 0 THEN

Line 6811: p_return_status := fnd_api.g_ret_sts_success;

6807: END IF;
6808: --
6809: END IF; -- IF (PROCESS_COMPLETE)
6810:
6811: p_return_status := fnd_api.g_ret_sts_success;
6812: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6813: EXCEPTION
6814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6815: --dbms_output.put_line('Gone to one level top ..................');

Line 6814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6810:
6811: p_return_status := fnd_api.g_ret_sts_success;
6812: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6813: EXCEPTION
6814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6815: --dbms_output.put_line('Gone to one level top ..................');
6816: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6817: p_return_status := fnd_api.g_ret_sts_unexp_error;
6818: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');

Line 6817: p_return_status := fnd_api.g_ret_sts_unexp_error;

6813: EXCEPTION
6814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6815: --dbms_output.put_line('Gone to one level top ..................');
6816: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6817: p_return_status := fnd_api.g_ret_sts_unexp_error;
6818: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6819:
6820: /* Added Exceptions for Bug 2056877 */
6821: /***** Commented the following for bgu fix 4625734

Line 6826: --p_return_status := fnd_api.g_ret_sts_unexp_error;

6822: WHEN NO_PROFILE_EXISTS THEN
6823: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6824: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
6825: fnd_msg_pub.add;
6826: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6827: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6828:
6829: WHEN NO_VAL_DATE_MATCHES THEN
6830: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 6827: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579

6823: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6824: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
6825: fnd_msg_pub.add;
6826: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6827: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6828:
6829: WHEN NO_VAL_DATE_MATCHES THEN
6830: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6831: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

Line 6835: --p_return_status := fnd_api.g_ret_sts_unexp_error;

6831: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6832: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6833: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6834: fnd_msg_pub.add;
6835: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6836: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6837:
6838: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6839: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 6836: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579

6832: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6833: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6834: fnd_msg_pub.add;
6835: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6836: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6837:
6838: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6839: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6840: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

Line 6844: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.

6840: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6841: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6842: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6843: fnd_msg_pub.add;
6844: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
6845: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6846: End of comment for bug fix 4625734 *****/
6847:
6848: WHEN OTHERS THEN

Line 6845: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579

6841: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6842: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6843: fnd_msg_pub.add;
6844: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
6845: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6846: End of comment for bug fix 4625734 *****/
6847:
6848: WHEN OTHERS THEN
6849: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;

Line 6851: p_return_status := fnd_api.g_ret_sts_unexp_error;

6847:
6848: WHEN OTHERS THEN
6849: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6850: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','GMS_ENC_TIE_BACK');
6851: p_return_status := fnd_api.g_ret_sts_unexp_error;
6852: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6853:
6854: END gms_enc_tie_back;
6855:

Line 6992: p_print_header => FND_API.G_FALSE);

6988: fnd_message.set_name('PSP','PSP_ENC_NUM_ASG');
6989: fnd_message.set_token('NUM_ASG',no_of_asg);
6990: fnd_msg_pub.add;
6991: psp_message_s.print_error (p_mode => FND_FILE.LOG,
6992: p_print_header => FND_API.G_FALSE);
6993: END IF;
6994:
6995: p_return_status := FND_API.G_RET_STS_SUCCESS;
6996:

Line 6995: p_return_status := FND_API.G_RET_STS_SUCCESS;

6991: psp_message_s.print_error (p_mode => FND_FILE.LOG,
6992: p_print_header => FND_API.G_FALSE);
6993: END IF;
6994:
6995: p_return_status := FND_API.G_RET_STS_SUCCESS;
6996:
6997: EXCEPTION
6998: WHEN OTHERS THEN
6999: g_error_api_path := SUBSTR('MOVE_QKUPD_REC_TO_HIST:'||g_error_api_path,1,230);

Line 7001: p_return_status := fnd_api.g_ret_sts_unexp_error;

6997: EXCEPTION
6998: WHEN OTHERS THEN
6999: g_error_api_path := SUBSTR('MOVE_QKUPD_REC_TO_HIST:'||g_error_api_path,1,230);
7000: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','MOVE_QKUPD_REC_TO_HIST');
7001: p_return_status := fnd_api.g_ret_sts_unexp_error;
7002: END move_qkupd_rec_to_hist;
7003: */
7004:
7005: --- Bug 3413373: Created a new wrapper procedure

Line 7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7129: fnd_message.set_token('PERSON2', l_full_name2);
7130: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7131: fnd_msg_pub.add;
7132:
7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7134: END IF;
7135:
7136: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_liq_trans');
7137:

Line 7146: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

7142: p_payroll_id => l_payroll_id,
7143: p_action_type => 'T' ,
7144: p_business_group_id => p_business_group_id,
7145: p_set_of_books_id => p_set_of_books_id);
7146: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
7147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7148: END IF;
7149: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_liq_trans');
7150: end loop;

Line 7147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7143: p_action_type => 'T' ,
7144: p_business_group_id => p_business_group_id,
7145: p_set_of_books_id => p_set_of_books_id);
7146: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
7147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7148: END IF;
7149: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_liq_trans');
7150: end loop;
7151:

Line 7240: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

7236: p_payroll_id => l_payroll_id,
7237: p_action_type => 'T' ,
7238: p_business_group_id => p_business_group_id,
7239: p_set_of_books_id => p_set_of_books_id);
7240: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
7241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7242: END IF;
7243: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_liq_trans');
7244: END LOOP;

Line 7241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7237: p_action_type => 'T' ,
7238: p_business_group_id => p_business_group_id,
7239: p_set_of_books_id => p_set_of_books_id);
7240: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
7241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7242: END IF;
7243: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_liq_trans');
7244: END LOOP;
7245: END IF;

Line 7252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7248:
7249: retcode := 0;
7250: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LIQUIDATE_EMP_TERM');
7251: exception
7252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7253: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7254: fnd_msg_pub.add;
7255: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7256: p_print_header => FND_API.G_TRUE);

Line 7256: p_print_header => FND_API.G_TRUE);

7252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7253: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7254: fnd_msg_pub.add;
7255: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7256: p_print_header => FND_API.G_TRUE);
7257: ROLLBACK;
7258: retcode := 2;
7259:
7260: when others then

Line 7264: p_print_header => FND_API.G_TRUE);

7260: when others then
7261: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7262: fnd_msg_pub.add;
7263: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7264: p_print_header => FND_API.G_TRUE);
7265: ROLLBACK;
7266: errbuf := sqlerrm;
7267: retcode := 2;
7268: end;