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

Line 246: IF l_return_status NOT IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success) THEN

242: IF (l_liq_check > 0) THEN
243: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling psp_enc_liq_tran.enc_liq_trans');
244: psp_enc_liq_tran.enc_liq_trans(p_payroll_action_id, p_business_group_id, p_set_of_books_id, l_return_status);
245:
246: IF l_return_status NOT IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After psp_enc_liq_tran.enc_liq_trans');
250: END IF;

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling psp_enc_liq_tran.enc_liq_trans');
244: psp_enc_liq_tran.enc_liq_trans(p_payroll_action_id, p_business_group_id, p_set_of_books_id, l_return_status);
245:
246: IF l_return_status NOT IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After psp_enc_liq_tran.enc_liq_trans');
250: END IF;
251:

Line 255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

251:
252: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_begin');
253: enc_batch_begin(p_payroll_action_id, l_return_status);
254:
255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
259:

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_begin');
253: enc_batch_begin(p_payroll_action_id, l_return_status);
254:
255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
259:
260: IF g_control_rec_found = 'FALSE' THEN

Line 264: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

260: IF g_control_rec_found = 'FALSE' THEN
261: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
262: enc_batch_end(p_payroll_action_id, l_return_status);
263:
264: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
268: retcode := FND_API.G_RET_STS_SUCCESS;

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
262: enc_batch_end(p_payroll_action_id, l_return_status);
263:
264: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
268: retcode := FND_API.G_RET_STS_SUCCESS;
269:

Line 268: retcode := FND_API.G_RET_STS_SUCCESS;

264: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
268: retcode := FND_API.G_RET_STS_SUCCESS;
269:
270: psp_message_s.print_error(p_mode=>FND_FILE.log,
271: p_print_header=>FND_API.G_FALSE);
272: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving enc_sum_trans p_payroll_action_id: ' || p_payroll_action_id || '

Line 271: p_print_header=>FND_API.G_FALSE);

267: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
268: retcode := FND_API.G_RET_STS_SUCCESS;
269:
270: psp_message_s.print_error(p_mode=>FND_FILE.log,
271: p_print_header=>FND_API.G_FALSE);
272: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving enc_sum_trans p_payroll_action_id: ' || p_payroll_action_id || '
273: p_business_group_id: ' || p_business_group_id || '
274: p_set_of_books_id: ' || p_set_of_books_id);
275: PSP_MESSAGE_S.Print_success;

Line 284: If l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

280:
281: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then
282: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
283: pqh_psp_integration.relieve_budget_commitments( 'S', l_return_status);
284: If l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
285: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
286: fnd_msg_pub.add;
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: end if;

Line 287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

283: pqh_psp_integration.relieve_budget_commitments( 'S', l_return_status);
284: If l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
285: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
286: fnd_msg_pub.add;
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: end if;
289: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');
290: end if;
291:

Line 313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

309: IF (l_gl_check > 0) THEN
310: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
311: tr_to_gl_int(p_payroll_action_id, l_return_status);
312:
313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
317: END IF;

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
311: tr_to_gl_int(p_payroll_action_id, l_return_status);
312:
313: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
317: END IF;
318:

Line 339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

335: IF (l_gms_check > 0) THEN
336: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
337: tr_to_gms_int(p_payroll_action_id, l_return_status);
338:
339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
343: END IF;

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
337: tr_to_gms_int(p_payroll_action_id, l_return_status);
338:
339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
343: END IF;
344:

Line 350: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

346: -- initiate the suspense lines summarization
347: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_sum_lines');
348: create_sum_lines(p_payroll_action_id, l_return_status);
349:
350: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_sum_lines');
354:

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_sum_lines');
348: create_sum_lines(p_payroll_action_id, l_return_status);
349:
350: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_sum_lines');
354:
355: -- call the user extension to populate attribute1 through attribute30

Line 374: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

370: IF (l_gl_check > 0) THEN
371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
372: tr_to_gl_int(p_payroll_action_id, l_return_status);
373:
374: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
378: END IF;

Line 375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
372: tr_to_gl_int(p_payroll_action_id, l_return_status);
373:
374: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
378: END IF;
379:

Line 399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

395: IF (l_gms_check > 0) THEN
396: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
397: tr_to_gms_int(p_payroll_action_id, l_return_status);
398:
399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
403: END IF;

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
397: tr_to_gms_int(p_payroll_action_id, l_return_status);
398:
399: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
403: END IF;
404:

Line 440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

436:
437: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_sum_lines');
438: create_sum_lines(p_payroll_action_id, l_return_status);
439:
440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_sum_lines');
444:

Line 441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

437: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_sum_lines');
438: create_sum_lines(p_payroll_action_id, l_return_status);
439:
440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_sum_lines');
444:
445: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');

Line 448: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

444:
445: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
446: enc_batch_end(p_payroll_action_id, l_return_status);
447:
448: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
452: retcode := FND_API.G_RET_STS_SUCCESS;

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
446: enc_batch_end(p_payroll_action_id, l_return_status);
447:
448: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
452: retcode := FND_API.G_RET_STS_SUCCESS;
453:

Line 452: retcode := FND_API.G_RET_STS_SUCCESS;

448: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
452: retcode := FND_API.G_RET_STS_SUCCESS;
453:
454: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving enc_sum_trans p_payroll_action_id: ' || p_payroll_action_id || '
455: p_business_group_id: ' || p_business_group_id || '
456: p_set_of_books_id: ' || p_set_of_books_id);

Line 459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

455: p_business_group_id: ' || p_business_group_id || '
456: p_set_of_books_id: ' || p_set_of_books_id);
457: PSP_MESSAGE_S.Print_success;
458: EXCEPTION
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK; --Introduced as part of bug fix 1776606
461: g_error_api_path := 'ENC_SUM_TRANS:'||g_error_api_path;
462: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
463: retcode := 2;

Line 469: p_print_header => FND_API.G_TRUE);

465: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving enc_sum_trans p_payroll_action_id: ' || p_payroll_action_id || '
466: p_business_group_id: ' || p_business_group_id || '
467: p_set_of_books_id: ' || p_set_of_books_id);
468: psp_message_s.print_error(p_mode => FND_FILE.LOG,
469: p_print_header => FND_API.G_TRUE);
470: return;
471:
472: WHEN OTHERS THEN
473: ROLLBACK; --Introduced as part of bug fix 1776606

Line 482: p_print_header => FND_API.G_TRUE);

478: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving enc_sum_trans p_payroll_action_id: ' || p_payroll_action_id || '
479: p_business_group_id: ' || p_business_group_id || '
480: p_set_of_books_id: ' || p_set_of_books_id);
481: psp_message_s.print_error(p_mode => FND_FILE.LOG,
482: p_print_header => FND_API.G_TRUE);
483: return;
484: END;
485:
486: -- ##########################################################################

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

519: IF enc_control_cur%rowcount = 0 THEN
520: g_control_rec_found := 'FALSE';
521: fnd_message.set_name('PSP','PSP_ENC_NO_SUMM_REC_FOUND');
522: fnd_msg_pub.add;
523: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
524: -- for bug fix 1868338 -- Subha
525: p_return_status := fnd_api.g_ret_sts_success;
526: CLOSE enc_control_cur;
527: EXIT;

Line 525: p_return_status := fnd_api.g_ret_sts_success;

521: fnd_message.set_name('PSP','PSP_ENC_NO_SUMM_REC_FOUND');
522: fnd_msg_pub.add;
523: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
524: -- for bug fix 1868338 -- Subha
525: p_return_status := fnd_api.g_ret_sts_success;
526: CLOSE enc_control_cur;
527: EXIT;
528: END IF;
529: IF enc_control_cur%NOTFOUND THEN

Line 531: p_return_status := fnd_api.g_ret_sts_success;

527: EXIT;
528: END IF;
529: IF enc_control_cur%NOTFOUND THEN
530: CLOSE enc_control_cur;
531: p_return_status := fnd_api.g_ret_sts_success;
532: EXIT;
533: END IF;
534:
535: UPDATE psp_enc_controls

Line 546: p_return_status := fnd_api.g_ret_sts_unexp_error;

542: /* Introduced as part of bug fix #1776606 */
543: when others then
544: g_error_api_path := 'ENC_BATCH_BEGIN:'||g_error_api_path;
545: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_BEGIN');
546: p_return_status := fnd_api.g_ret_sts_unexp_error;
547: RAISE;
548: END;
549: -- ##########################################################################
550: -- This procedure ends the encumbrance summarization process

Line 582: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

578: BEGIN
579: update_hierarchy_dates(p_payroll_action_id => p_payroll_action_id,
580: p_return_status => l_return_status);
581:
582: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
583: RAISE fnd_api.g_exc_unexpected_error;
584: END IF;
585:
586: log_st_warnings;

Line 583: RAISE fnd_api.g_exc_unexpected_error;

579: update_hierarchy_dates(p_payroll_action_id => p_payroll_action_id,
580: p_return_status => l_return_status);
581:
582: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
583: RAISE fnd_api.g_exc_unexpected_error;
584: END IF;
585:
586: log_st_warnings;
587:

Line 698: RAISE fnd_api.g_exc_unexpected_error;

694: CLOSE pending_line_cur;
695:
696: IF (l_pending_line_count > 0) THEN
697: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Need to re-process');
698: RAISE fnd_api.g_exc_unexpected_error;
699: END IF;
700: p_return_status := fnd_api.g_ret_sts_success;
701: EXCEPTION
702: WHEN OTHERS THEN

Line 700: p_return_status := fnd_api.g_ret_sts_success;

696: IF (l_pending_line_count > 0) THEN
697: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Need to re-process');
698: RAISE fnd_api.g_exc_unexpected_error;
699: END IF;
700: p_return_status := fnd_api.g_ret_sts_success;
701: EXCEPTION
702: WHEN OTHERS THEN
703: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;
704: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');

Line 705: p_return_status := fnd_api.g_ret_sts_unexp_error;

701: EXCEPTION
702: WHEN OTHERS THEN
703: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;
704: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');
705: p_return_status := fnd_api.g_ret_sts_unexp_error;
706: END enc_batch_end;
707:
708: /***** Commented for Create and Update multi thread enh.
709: PROCEDURE enc_batch_end(p_payroll_action_id IN NUMBER,

Line 867: p_return_status := fnd_api.g_ret_sts_success;

863: AND pesl.superceded_line_id IS NOT NULL);
864: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to liquidate for liqduidation re-processing');
865:
866: COMMIT;
867: p_return_status := fnd_api.g_ret_sts_success;
868: EXCEPTION
869: / * Introduced as part of Bug fix #1776606 * /
870: WHEN others then
871: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;

Line 873: p_return_status := fnd_api.g_ret_sts_unexp_error;

869: / * Introduced as part of Bug fix #1776606 * /
870: WHEN others then
871: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;
872: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');
873: p_return_status := fnd_api.g_ret_sts_unexp_error;
874: END;
875: End of comment for Create and Update multi thread enh. *****/
876:
877: -- ##########################################################################

Line 1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1198: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1199: fnd_message.set_token('ERROR',l_error);
1200: fnd_message.set_token('PRODUCT',l_product);
1201: fnd_msg_pub.add;
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203: END;
1204:
1205: BEGIN
1206: SELECT parameter_value

Line 1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1215: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1216: fnd_message.set_token('ERROR',l_error);
1217: fnd_message.set_token('PRODUCT',l_product);
1218: fnd_msg_pub.add;
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: END;
1221:
1222: IF l_time_para_value = '1' and l_gl_para_value = '3' THEN
1223:

Line 1283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1279: enc_sum_lines_p1_rec.attribute9,
1280: enc_sum_lines_p1_rec.attribute10,
1281: l_return_status);
1282:
1283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: END IF;
1286:
1287: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859

Line 1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1280: enc_sum_lines_p1_rec.attribute10,
1281: l_return_status);
1282:
1283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: END IF;
1286:
1287: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859
1288: UPDATE psp_enc_lines

Line 1403: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1399: NULL,
1400: enc_sum_lines_p2_rec.gl_project_flag,
1401: l_return_status);
1402:
1403: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1405: END IF;
1406:
1407: UPDATE psp_enc_lines

Line 1404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1400: enc_sum_lines_p2_rec.gl_project_flag,
1401: l_return_status);
1402:
1403: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1405: END IF;
1406:
1407: UPDATE psp_enc_lines
1408: SET enc_summary_line_id = l_enc_summary_line_id

Line 1468: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1464: NULL,
1465: enc_sum_lines_p3_rec.gl_project_flag,
1466: l_return_status);
1467:
1468: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471:
1472: UPDATE psp_enc_lines

Line 1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1465: enc_sum_lines_p3_rec.gl_project_flag,
1466: l_return_status);
1467:
1468: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1470: END IF;
1471:
1472: UPDATE psp_enc_lines
1473: SET enc_summary_line_id = l_enc_summary_line_id

Line 1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1531: NULL,
1532: enc_sum_lines_g1_rec.gl_project_flag,
1533: l_return_status);
1534:
1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;
1538:
1539: UPDATE psp_enc_lines

Line 1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1532: enc_sum_lines_g1_rec.gl_project_flag,
1533: l_return_status);
1534:
1535: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;
1538:
1539: UPDATE psp_enc_lines
1540: SET enc_summary_line_id = l_enc_summary_line_id

Line 1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1595: NULL,
1596: enc_sum_lines_g2_rec.gl_project_flag,
1597: l_return_status);
1598:
1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1601: END IF;
1602:
1603: UPDATE psp_enc_lines

Line 1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1596: enc_sum_lines_g2_rec.gl_project_flag,
1597: l_return_status);
1598:
1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1601: END IF;
1602:
1603: UPDATE psp_enc_lines
1604: SET enc_summary_line_id = l_enc_summary_line_id

Line 1662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1658: NULL,
1659: enc_sum_lines_g3_rec.gl_project_flag,
1660: l_return_status);
1661:
1662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664: END IF;
1665:
1666: UPDATE psp_enc_lines

Line 1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1659: enc_sum_lines_g3_rec.gl_project_flag,
1660: l_return_status);
1661:
1662: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1664: END IF;
1665:
1666: UPDATE psp_enc_lines
1667: SET enc_summary_line_id = l_enc_summary_line_id

Line 1682: p_return_status := fnd_api.g_ret_sts_success;

1678:
1679: END IF; -- Commented this END IF as part of Enh. 2143723
1680: *************************************************************************************************** /
1681:
1682: p_return_status := fnd_api.g_ret_sts_success;
1683:
1684: EXCEPTION
1685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1686: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;

Line 1685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1681:
1682: p_return_status := fnd_api.g_ret_sts_success;
1683:
1684: EXCEPTION
1685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1686: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1687: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
1688: p_return_status := fnd_api.g_ret_sts_unexp_error;
1689: WHEN OTHERS THEN

Line 1688: p_return_status := fnd_api.g_ret_sts_unexp_error;

1684: EXCEPTION
1685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1686: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1687: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
1688: p_return_status := fnd_api.g_ret_sts_unexp_error;
1689: WHEN OTHERS THEN
1690: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1691: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GL_ENC_SUM_LINES');
1692: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1692: p_return_status := fnd_api.g_ret_sts_unexp_error;

1688: p_return_status := fnd_api.g_ret_sts_unexp_error;
1689: WHEN OTHERS THEN
1690: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1691: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GL_ENC_SUM_LINES');
1692: p_return_status := fnd_api.g_ret_sts_unexp_error;
1693: END;
1694: End of comment for Create and Update enh. *****/
1695:
1696: -- ##########################################################################

Line 1812: p_return_status := fnd_api.g_ret_sts_success;

1808: FND_GLOBAL.USER_ID,
1809: FND_GLOBAL.LOGIN_ID,
1810: FND_GLOBAL.USER_ID,
1811: SYSDATE);
1812: p_return_status := fnd_api.g_ret_sts_success;
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: g_error_api_path := 'INSERT_INTO_ENC_SUM_LINES:'||g_error_api_path;
1816: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','INSERT_INTO_ENC_SUM_LINES');

Line 1817: p_return_status := fnd_api.g_ret_sts_unexp_error;

1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: g_error_api_path := 'INSERT_INTO_ENC_SUM_LINES:'||g_error_api_path;
1816: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','INSERT_INTO_ENC_SUM_LINES');
1817: p_return_status := fnd_api.g_ret_sts_unexp_error;
1818: END;
1819:
1820: -- ##########################################################################
1821: -- This procedure transfers the summarized lines from psp_enc_summary_lines

Line 1963: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1959: gl_tie_tab.delete;
1960:
1961: gl_je_source( l_user_je_source,
1962: l_return_status);
1963: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1965: END IF;
1966:
1967: gl_je_cat( l_user_je_cat,

Line 1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1960:
1961: gl_je_source( l_user_je_source,
1962: l_return_status);
1963: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1965: END IF;
1966:
1967: gl_je_cat( l_user_je_cat,
1968: l_return_status);

Line 1969: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1965: END IF;
1966:
1967: gl_je_cat( l_user_je_cat,
1968: l_return_status);
1969: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1971: END IF;
1972:
1973: enc_type( l_enc_type_id,

Line 1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1966:
1967: gl_je_cat( l_user_je_cat,
1968: l_return_status);
1969: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1971: END IF;
1972:
1973: enc_type( l_enc_type_id,
1974: l_return_status);

Line 1975: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1971: END IF;
1972:
1973: enc_type( l_enc_type_id,
1974: l_return_status);
1975: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1977: END IF;
1978:
1979: SELECT gl_interface_control_s.nextval

Line 1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1972:
1973: enc_type( l_enc_type_id,
1974: l_return_status);
1975: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1977: END IF;
1978:
1979: SELECT gl_interface_control_s.nextval
1980: INTO l_group_id

Line 2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2016: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2017: fnd_message.set_token('ERROR',l_error);
2018: fnd_message.set_token('PRODUCT',l_product);
2019: fnd_msg_pub.add;
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END; * /
2022:
2023: --End of bug 2478000
2024:

Line 2038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2034: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2035: fnd_message.set_token('VALUE','l_value');
2036: fnd_message.set_token('TABLE','l_table');
2037: fnd_msg_pub.add;
2038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2039: END;
2040:
2041: ---l_rec_count := 0; -- commented for 2444657
2042: if enc_control_rec.gl_phase = 'Summarize' then ---2444657

Line 2115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2111: INT_REC.ATTRIBUTE29,
2112: INT_REC.ATTRIBUTE30,
2113: L_RETURN_STATUS);
2114:
2115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2117: END IF;
2118: END LOOP; --int_cur loop
2119: end if; --- 2444657

Line 2116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2112: INT_REC.ATTRIBUTE30,
2113: L_RETURN_STATUS);
2114:
2115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2117: END IF;
2118: END LOOP; --int_cur loop
2119: end if; --- 2444657
2120: / * Commented out as part of bug fix #2142865

Line 2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2186: IF req_id = 0 THEN
2187:
2188: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2189: fnd_msg_pub.add;
2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2191:
2192: ELSE
2193: / ***** Converted the following UPDATE to BULK for R12 performance fixes
2194: UPDATE psp_enc_controls

Line 2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2217:
2218: IF call_status = FALSE then
2219: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2220: fnd_msg_pub.add;
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: END IF;
2223: END IF;
2224: END IF; -- l_rec_count > 0 --- moved from below ... for 2444657
2225:

Line 2238: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2234: gl_tie_tab(i).r_end_date,
2235: gl_tie_tab(i).r_group_id, --- replaced l_group_id for 2444657,
2236: g_business_group_id, g_set_of_books_id, 'N',
2237: l_return_status);
2238: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241:
2242: end loop;

Line 2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2235: gl_tie_tab(i).r_group_id, --- replaced l_group_id for 2444657,
2236: g_business_group_id, g_set_of_books_id, 'N',
2237: l_return_status);
2238: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241:
2242: end loop;
2243: / *

Line 2244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2240: END IF;
2241:
2242: end loop;
2243: / *
2244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;
2247: -- moved inside the loop
2248:

Line 2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2241:
2242: end loop;
2243: / *
2244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;
2247: -- moved inside the loop
2248:
2249: For Bug fix 1776606

Line 2278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2274: COMMIT; -- moved the commit from above for 2479579
2275: if g_susp_prob = 'Y' then -- introduced this IF stmnt for 2479579
2276: enc_batch_end(g_payroll_action_id,
2277: l_return_status);
2278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2279: end if;
2280:
2281: p_return_status := fnd_api.g_ret_sts_success;
2282:

Line 2281: p_return_status := fnd_api.g_ret_sts_success;

2277: l_return_status);
2278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2279: end if;
2280:
2281: p_return_status := fnd_api.g_ret_sts_success;
2282:
2283: EXCEPTION
2284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2285: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;

Line 2284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2280:
2281: p_return_status := fnd_api.g_ret_sts_success;
2282:
2283: EXCEPTION
2284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2285: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2286: p_return_status := fnd_api.g_ret_sts_unexp_error;
2287:
2288: WHEN RETURN_BACK THEN

Line 2286: p_return_status := fnd_api.g_ret_sts_unexp_error;

2282:
2283: EXCEPTION
2284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2285: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2286: p_return_status := fnd_api.g_ret_sts_unexp_error;
2287:
2288: WHEN RETURN_BACK THEN
2289: p_return_status := fnd_api.g_ret_sts_success;
2290:

Line 2289: p_return_status := fnd_api.g_ret_sts_success;

2285: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2286: p_return_status := fnd_api.g_ret_sts_unexp_error;
2287:
2288: WHEN RETURN_BACK THEN
2289: p_return_status := fnd_api.g_ret_sts_success;
2290:
2291: WHEN OTHERS THEN
2292: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2293: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');

Line 2294: p_return_status := fnd_api.g_ret_sts_unexp_error;

2290:
2291: WHEN OTHERS THEN
2292: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2293: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');
2294: p_return_status := fnd_api.g_ret_sts_unexp_error;
2295: END;
2296: End of comment for Create and Update multi thread enh. *****/
2297:
2298: -- Introduced the following modified tr_to_gl_int procedure for Create and Update multi thread enh.

Line 2349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2345:
2346: gl_je_source( l_user_je_source,
2347: l_return_status);
2348:
2349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;
2352:
2353: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);

Line 2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2346: gl_je_source( l_user_je_source,
2347: l_return_status);
2348:
2349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;
2352:
2353: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);
2354:

Line 2357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2353: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);
2354:
2355: gl_je_cat( l_user_je_cat,
2356: l_return_status);
2357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2359: END IF;
2360:
2361: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);

Line 2358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2354:
2355: gl_je_cat( l_user_je_cat,
2356: l_return_status);
2357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2359: END IF;
2360:
2361: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);
2362:

Line 2365: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2361: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);
2362:
2363: enc_type( l_enc_type_id,
2364: l_return_status);
2365: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: END IF;
2368:
2369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);

Line 2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2362:
2363: enc_type( l_enc_type_id,
2364: l_return_status);
2365: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2367: END IF;
2368:
2369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2370:

Line 2476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2472: IF req_id = 0 THEN
2473: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import submission failed');
2474: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2475: fnd_msg_pub.add;
2476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2477: ELSE
2478: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Journal Import (req_id: ' || req_id || ')');
2479: OPEN enc_control_id_cur;
2480: FETCH enc_control_id_cur BULK COLLECT INTO r_enc_controls.enc_control_id;

Line 2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2504: IF call_status = FALSE THEN
2505: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
2506: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2507: fnd_msg_pub.add;
2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2509: END IF;
2510: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');
2511: END IF;
2512: END IF;

Line 2531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2527: g_set_of_books_id,
2528: 'N',
2529: l_return_status);
2530:
2531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: 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));
2534: ELSE
2535: 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 2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2528: 'N',
2529: l_return_status);
2530:
2531: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2533: 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));
2534: ELSE
2535: 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));
2536: END IF;

Line 2558: p_return_status := fnd_api.g_ret_sts_success;

2554:
2555: COMMIT;
2556: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' COMMITted gl_enc_tie_back');
2557:
2558: p_return_status := fnd_api.g_ret_sts_success;
2559: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2560: EXCEPTION
2561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2562: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;

Line 2561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2557:
2558: p_return_status := fnd_api.g_ret_sts_success;
2559: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2560: EXCEPTION
2561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2562: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2563: p_return_status := fnd_api.g_ret_sts_unexp_error;
2564: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2565: WHEN OTHERS THEN

Line 2563: p_return_status := fnd_api.g_ret_sts_unexp_error;

2559: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2560: EXCEPTION
2561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2562: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2563: p_return_status := fnd_api.g_ret_sts_unexp_error;
2564: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2565: WHEN OTHERS THEN
2566: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2567: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');

Line 2568: p_return_status := fnd_api.g_ret_sts_unexp_error;

2564: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2565: WHEN OTHERS THEN
2566: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2567: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');
2568: p_return_status := fnd_api.g_ret_sts_unexp_error;
2569: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2570: END tr_to_gl_int;
2571: -- End of changes for Create and Update multi thread enh.
2572:

Line 2594: p_return_status := fnd_api.g_ret_sts_unexp_error;

2590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2591: fnd_message.set_token('ERROR',l_error);
2592: fnd_message.set_token('PRODUCT',l_product);
2593: fnd_msg_pub.add;
2594: p_return_status := fnd_api.g_ret_sts_unexp_error;
2595: WHEN OTHERS THEN
2596: g_error_api_path := 'gl_je_source:'||g_error_api_path;
2597: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');
2598: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2598: p_return_status := fnd_api.g_ret_sts_unexp_error;

2594: p_return_status := fnd_api.g_ret_sts_unexp_error;
2595: WHEN OTHERS THEN
2596: g_error_api_path := 'gl_je_source:'||g_error_api_path;
2597: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');
2598: p_return_status := fnd_api.g_ret_sts_unexp_error;
2599: END;
2600:
2601: -- ##########################################################################
2602: -- This procedure retrieves the user_je_category_name from gl_je_categories

Line 2622: p_return_status := fnd_api.g_ret_sts_unexp_error;

2618: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2619: fnd_message.set_token('ERROR',l_error);
2620: fnd_message.set_token('PRODUCT',l_product);
2621: fnd_msg_pub.add;
2622: p_return_status := fnd_api.g_ret_sts_unexp_error;
2623: WHEN OTHERS THEN
2624: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
2625: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');
2626: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2626: p_return_status := fnd_api.g_ret_sts_unexp_error;

2622: p_return_status := fnd_api.g_ret_sts_unexp_error;
2623: WHEN OTHERS THEN
2624: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
2625: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');
2626: p_return_status := fnd_api.g_ret_sts_unexp_error;
2627: END;
2628:
2629: -- ##########################################################################
2630: -- This procedure retrieves the encumbrance_type_id from gl_encumbrance_types

Line 2653: p_return_status := fnd_api.g_ret_sts_unexp_error;

2649: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2650: fnd_message.set_token('ERROR',l_error);
2651: fnd_message.set_token('PRODUCT',l_product);
2652: fnd_msg_pub.add;
2653: p_return_status := fnd_api.g_ret_sts_unexp_error;
2654: WHEN OTHERS THEN
2655: g_error_api_path := 'enc_type:'||g_error_api_path;
2656: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','enc_type');
2657: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2657: p_return_status := fnd_api.g_ret_sts_unexp_error;

2653: p_return_status := fnd_api.g_ret_sts_unexp_error;
2654: WHEN OTHERS THEN
2655: g_error_api_path := 'enc_type:'||g_error_api_path;
2656: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','enc_type');
2657: p_return_status := fnd_api.g_ret_sts_unexp_error;
2658:
2659: END;
2660:
2661: -- ##########################################################################

Line 3065: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3061: l_award_id,
3062: l_task_id,
3063: l_effective_date,
3064: l_return_status);
3065: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3066: --dbms_output.put_line('poeta call failed ');
3067: --insert_into_psp_stout( 'poeta call failed ');
3068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3069: END IF;

Line 3068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3064: l_return_status);
3065: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3066: --dbms_output.put_line('poeta call failed ');
3067: --insert_into_psp_stout( 'poeta call failed ');
3068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3069: END IF;
3070:
3071: END IF;
3072:

Line 3118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3114: fnd_message.set_token('GLCCID',x_lines_glccid);
3115: fnd_msg_pub.add;
3116: -- Included the following check as part of Bug fix #1776606 --
3117: IF p_mode = 'N' THEN
3118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3119: END IF;
3120: END IF;
3121: * /
3122:

Line 3256: p_return_status := fnd_api.g_ret_sts_success;

3252: l_rec_cnt := 0;
3253: END IF;
3254: -- END LOOP; -- ENC_CONTROL_CUR
3255: END IF; -- If (PROCESS_COMPLETE)
3256: p_return_status := fnd_api.g_ret_sts_success;
3257: EXCEPTION
3258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3259: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3260: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3254: -- END LOOP; -- ENC_CONTROL_CUR
3255: END IF; -- If (PROCESS_COMPLETE)
3256: p_return_status := fnd_api.g_ret_sts_success;
3257: EXCEPTION
3258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3259: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3260: p_return_status := fnd_api.g_ret_sts_unexp_error;
3261:
3262: / * Added Exceptions for bug 2056877 * /

Line 3260: p_return_status := fnd_api.g_ret_sts_unexp_error;

3256: p_return_status := fnd_api.g_ret_sts_success;
3257: EXCEPTION
3258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3259: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3260: p_return_status := fnd_api.g_ret_sts_unexp_error;
3261:
3262: / * Added Exceptions for bug 2056877 * /
3263: WHEN NO_PROFILE_EXISTS THEN
3264: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 3267: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

3263: WHEN NO_PROFILE_EXISTS THEN
3264: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3265: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3266: fnd_msg_pub.add;
3267: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3268: p_return_status := fnd_api.g_ret_sts_success;
3269:
3270: WHEN NO_VAL_DATE_MATCHES THEN
3271: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 3268: p_return_status := fnd_api.g_ret_sts_success;

3264: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3265: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3266: fnd_msg_pub.add;
3267: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3268: p_return_status := fnd_api.g_ret_sts_success;
3269:
3270: WHEN NO_VAL_DATE_MATCHES THEN
3271: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3272: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

Line 3276: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

3272: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3273: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3274: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3275: fnd_msg_pub.add;
3276: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3277: p_return_status := fnd_api.g_ret_sts_success;
3278:
3279: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3280: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 3277: p_return_status := fnd_api.g_ret_sts_success;

3273: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3274: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3275: fnd_msg_pub.add;
3276: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3277: p_return_status := fnd_api.g_ret_sts_success;
3278:
3279: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3280: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3281: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

Line 3285: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

3281: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3282: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3283: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3284: fnd_msg_pub.add;
3285: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3286: p_return_status := fnd_api.g_ret_sts_success;
3287:
3288: WHEN OTHERS THEN
3289: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;

Line 3286: p_return_status := fnd_api.g_ret_sts_success;

3282: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3283: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3284: fnd_msg_pub.add;
3285: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3286: p_return_status := fnd_api.g_ret_sts_success;
3287:
3288: WHEN OTHERS THEN
3289: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3290: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');

Line 3291: p_return_status := fnd_api.g_ret_sts_unexp_error;

3287:
3288: WHEN OTHERS THEN
3289: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3290: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');
3291: p_return_status := fnd_api.g_ret_sts_unexp_error;
3292:
3293: END;
3294: End of comment for Create and Update multi thread enh. *****/
3295:

Line 3610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3606: l_gl_project_flag := 'P';
3607: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
3608: l_project_id, l_award_id, l_task_id, l_effective_date,
3609: l_return_status);
3610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: END IF;
3614:

Line 3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3607: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
3608: l_project_id, l_award_id, l_task_id, l_effective_date,
3609: l_return_status);
3610: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: END IF;
3614:
3615: UPDATE psp_enc_lines

Line 3784: p_return_status := fnd_api.g_ret_sts_success;

3780: ELSE
3781: g_process_complete := FALSE;
3782: END IF;
3783:
3784: p_return_status := fnd_api.g_ret_sts_success;
3785: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3786: EXCEPTION
3787: WHEN NO_PROFILE_EXISTS THEN
3788: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 3791: p_return_status := fnd_api.g_ret_sts_success;

3787: WHEN NO_PROFILE_EXISTS THEN
3788: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3789: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3790: fnd_msg_pub.add;
3791: p_return_status := fnd_api.g_ret_sts_success;
3792: WHEN NO_VAL_DATE_MATCHES THEN
3793: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3794: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3795: fnd_message.set_token('ORG_NAME',l_orig_org_name);

Line 3798: p_return_status := fnd_api.g_ret_sts_success;

3794: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3795: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3796: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3797: fnd_msg_pub.add;
3798: p_return_status := fnd_api.g_ret_sts_success;
3799: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3800: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3801: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3802: fnd_message.set_token('ORG_NAME',l_orig_org_name);

Line 3805: p_return_status := fnd_api.g_ret_sts_success;

3801: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3802: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3803: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3804: fnd_msg_pub.add;
3805: p_return_status := fnd_api.g_ret_sts_success;
3806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3807: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3808: p_return_status := fnd_api.g_ret_sts_unexp_error;
3809: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');

Line 3806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3802: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3803: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3804: fnd_msg_pub.add;
3805: p_return_status := fnd_api.g_ret_sts_success;
3806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3807: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3808: p_return_status := fnd_api.g_ret_sts_unexp_error;
3809: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3810: WHEN OTHERS THEN

Line 3808: p_return_status := fnd_api.g_ret_sts_unexp_error;

3804: fnd_msg_pub.add;
3805: p_return_status := fnd_api.g_ret_sts_success;
3806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3807: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3808: p_return_status := fnd_api.g_ret_sts_unexp_error;
3809: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3810: WHEN OTHERS THEN
3811: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3812: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');

Line 3813: p_return_status := fnd_api.g_ret_sts_unexp_error;

3809: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3810: WHEN OTHERS THEN
3811: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3812: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');
3813: p_return_status := fnd_api.g_ret_sts_unexp_error;
3814: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3815: END gl_enc_tie_back;
3816: -- End of changes for Create and Update multi thread enh.
3817:

Line 3973: p_return_status := fnd_api.g_ret_sts_success;

3969: P_ATTRIBUTE28,
3970: P_ATTRIBUTE29,
3971: P_ATTRIBUTE30);
3972:
3973: p_return_status := fnd_api.g_ret_sts_success;
3974:
3975: EXCEPTION
3976: WHEN OTHERS THEN
3977: -- dbms_output.put_line('Error while inserting into gl_interface..........');

Line 3980: p_return_status := fnd_api.g_ret_sts_unexp_error;

3976: WHEN OTHERS THEN
3977: -- dbms_output.put_line('Error while inserting into gl_interface..........');
3978: g_error_api_path := 'insert_into_gl_int:'||g_error_api_path;
3979: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','insert_into_gl_int');
3980: p_return_status := fnd_api.g_ret_sts_unexp_error;
3981:
3982:
3983: END;
3984:

Line 4186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4182: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4183: fnd_message.set_token('ERROR',l_error);
4184: fnd_message.set_token('PRODUCT',l_product);
4185: fnd_msg_pub.add;
4186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4187: END;
4188:
4189: BEGIN
4190: SELECT parameter_value

Line 4203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4199: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4200: fnd_message.set_token('ERROR',l_error);
4201: fnd_message.set_token('PRODUCT',l_product);
4202: fnd_msg_pub.add;
4203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4204: END;
4205:
4206: IF l_time_para_value = '1' and l_ogm_para_value = '1' THEN
4207: End of Enh. fix 2143723 * /

Line 4268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4264: enc_sum_lines_p_rec.attribute8,
4265: enc_sum_lines_p_rec.attribute9,
4266: enc_sum_lines_p_rec.attribute10,
4267: p_return_status);
4268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4270: END IF;
4271:
4272: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859

Line 4269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4265: enc_sum_lines_p_rec.attribute9,
4266: enc_sum_lines_p_rec.attribute10,
4267: p_return_status);
4268: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4270: END IF;
4271:
4272: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859
4273: UPDATE psp_enc_lines

Line 4408: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4404: enc_control_rec.payroll_id,
4405: NULL,
4406: enc_sum_lines_g_rec.gl_project_flag,
4407: l_return_status);
4408: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4410: END IF;
4411:
4412: UPDATE psp_enc_lines

Line 4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4405: NULL,
4406: enc_sum_lines_g_rec.gl_project_flag,
4407: l_return_status);
4408: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4410: END IF;
4411:
4412: UPDATE psp_enc_lines
4413: SET enc_summary_line_id = l_enc_summary_line_id

Line 4432: p_return_status := fnd_api.g_ret_sts_success;

4428: END IF; Commented this END IF as part of Enh. 2143723
4429: ********************************************************************************** /
4430:
4431: --COMMIT;
4432: p_return_status := fnd_api.g_ret_sts_success;
4433:
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4436: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;

Line 4435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4431: --COMMIT;
4432: p_return_status := fnd_api.g_ret_sts_success;
4433:
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4436: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4437: p_return_status := fnd_api.g_ret_sts_unexp_error;
4438:
4439: WHEN OTHERS THEN

Line 4437: p_return_status := fnd_api.g_ret_sts_unexp_error;

4433:
4434: EXCEPTION
4435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4436: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4437: p_return_status := fnd_api.g_ret_sts_unexp_error;
4438:
4439: WHEN OTHERS THEN
4440: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4441: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GMS_ENC_SUM_LINES');

Line 4442: p_return_status := fnd_api.g_ret_sts_unexp_error;

4438:
4439: WHEN OTHERS THEN
4440: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4441: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GMS_ENC_SUM_LINES');
4442: p_return_status := fnd_api.g_ret_sts_unexp_error;
4443:
4444: END;
4445: End of comment for Create and Update multi thread *****/
4446:

Line 4673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4669: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4670: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4671: fnd_message.set_token('PRODUCT','GMS');
4672: fnd_msg_pub.add;
4673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4674: END IF;
4675: END IF;
4676:
4677: -- R12 MOAC Uptake

Line 4807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4803: END LOOP;
4804:
4805: IF l_raise_error THEN
4806: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Interface records have errors');
4807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4808: END IF;
4809:
4810: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed interface records for errors');
4811: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Computing PA week ending date(s)');

Line 4889: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4885: GMS_REC.ORIGINAL_ENCUMBRANCE_ITEM_ID := r_interface.expenditure_item_id(recno);
4886:
4887: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
4888:
4889: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4890: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
4891: fnd_msg_pub.add;
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: END IF;

Line 4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4888:
4889: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4890: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
4891: fnd_msg_pub.add;
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: END IF;
4894: END LOOP;
4895: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all');
4896: IF r_interface.txn_interface_id.COUNT > 0 THEN

Line 4917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4913: IF req_id_tab(request_counter) = 0 THEN
4914: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
4915: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4916: fnd_msg_pub.add;
4917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4918: ELSE
4919: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');
4920:
4921: OPEN enc_control_id_cur;

Line 4952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4948: IF call_status = FALSE then
4949: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
4950: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4951: fnd_msg_pub.add;
4952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4953: END IF;
4954: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');
4955: END LOOP;
4956: END IF;

Line 4973: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4969: g_business_group_id,
4970: g_set_of_books_id,
4971: l_return_status);
4972:
4973: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4974: 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));
4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4976: END IF;
4977: 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 4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4971: l_return_status);
4972:
4973: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4974: 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));
4975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4976: END IF;
4977: 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));
4978: END LOOP;
4979:

Line 5012: p_return_status := fnd_api.g_ret_sts_success;

5008: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Set the un-imported summary lines to New status');
5009:
5010: COMMIT;
5011:
5012: p_return_status := fnd_api.g_ret_sts_success;
5013: EXCEPTION
5014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5015: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5016: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5010: COMMIT;
5011:
5012: p_return_status := fnd_api.g_ret_sts_success;
5013: EXCEPTION
5014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5015: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5016: p_return_status := fnd_api.g_ret_sts_unexp_error;
5017:
5018: WHEN RETURN_BACK THEN

Line 5016: p_return_status := fnd_api.g_ret_sts_unexp_error;

5012: p_return_status := fnd_api.g_ret_sts_success;
5013: EXCEPTION
5014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5015: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5016: p_return_status := fnd_api.g_ret_sts_unexp_error;
5017:
5018: WHEN RETURN_BACK THEN
5019: p_return_status := fnd_api.g_ret_sts_success;
5020:

Line 5019: p_return_status := fnd_api.g_ret_sts_success;

5015: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5016: p_return_status := fnd_api.g_ret_sts_unexp_error;
5017:
5018: WHEN RETURN_BACK THEN
5019: p_return_status := fnd_api.g_ret_sts_success;
5020:
5021: WHEN OTHERS THEN
5022: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5023: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GMS_INT');

Line 5024: p_return_status := fnd_api.g_ret_sts_unexp_error;

5020:
5021: WHEN OTHERS THEN
5022: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5023: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GMS_INT');
5024: p_return_status := fnd_api.g_ret_sts_unexp_error;
5025: END tr_to_gms_int;
5026: -- End of comment for Create and Update multi thread
5027:
5028: -- ##########################################################################

Line 5496: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5492: l_award_id,
5493: l_task_id,
5494: l_effective_date,
5495: l_return_status);
5496: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5498: END IF;
5499:
5500: END IF;

Line 5497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5493: l_task_id,
5494: l_effective_date,
5495: l_return_status);
5496: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5498: END IF;
5499:
5500: END IF;
5501: / * For Bug fix 3194807 * /

Line 5693: p_return_status := fnd_api.g_ret_sts_success;

5689:
5690: END IF;
5691: END IF; -- IF (PROCESS_COMPLETE)
5692:
5693: p_return_status := fnd_api.g_ret_sts_success;
5694: EXCEPTION
5695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5696: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5697: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5691: END IF; -- IF (PROCESS_COMPLETE)
5692:
5693: p_return_status := fnd_api.g_ret_sts_success;
5694: EXCEPTION
5695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5696: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5697: p_return_status := fnd_api.g_ret_sts_unexp_error;
5698:
5699: / * Added Exceptions for bug 2056877 * /

Line 5697: p_return_status := fnd_api.g_ret_sts_unexp_error;

5693: p_return_status := fnd_api.g_ret_sts_success;
5694: EXCEPTION
5695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5696: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5697: p_return_status := fnd_api.g_ret_sts_unexp_error;
5698:
5699: / * Added Exceptions for bug 2056877 * /
5700: WHEN NO_PROFILE_EXISTS THEN
5701: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 5704: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

5700: WHEN NO_PROFILE_EXISTS THEN
5701: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5702: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5703: fnd_msg_pub.add;
5704: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5705: p_return_status := fnd_api.g_ret_sts_success;
5706:
5707: WHEN NO_VAL_DATE_MATCHES THEN
5708: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 5705: p_return_status := fnd_api.g_ret_sts_success;

5701: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5702: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5703: fnd_msg_pub.add;
5704: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5705: p_return_status := fnd_api.g_ret_sts_success;
5706:
5707: WHEN NO_VAL_DATE_MATCHES THEN
5708: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5709: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

Line 5713: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

5709: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5710: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5711: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5712: fnd_msg_pub.add;
5713: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5714: p_return_status := fnd_api.g_ret_sts_success;
5715:
5716: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5717: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 5714: p_return_status := fnd_api.g_ret_sts_success;

5710: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5711: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5712: fnd_msg_pub.add;
5713: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5714: p_return_status := fnd_api.g_ret_sts_success;
5715:
5716: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5717: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5718: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

Line 5722: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

5718: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5719: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5720: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5721: fnd_msg_pub.add;
5722: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5723: p_return_status := fnd_api.g_ret_sts_success;
5724:
5725: WHEN OTHERS THEN
5726: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;

Line 5723: p_return_status := fnd_api.g_ret_sts_success;

5719: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5720: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5721: fnd_msg_pub.add;
5722: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5723: p_return_status := fnd_api.g_ret_sts_success;
5724:
5725: WHEN OTHERS THEN
5726: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5727: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');

Line 5728: p_return_status := fnd_api.g_ret_sts_unexp_error;

5724:
5725: WHEN OTHERS THEN
5726: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5727: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');
5728: p_return_status := fnd_api.g_ret_sts_unexp_error;
5729:
5730: END;
5731: End of comment for Create and Update multi thread enh. *****/
5732: -- Introduced the following modified gms_enc_tie_back procedure for Create and Update multi thread enh.

Line 6178: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

6174: ret_expenditure_type => l_new_expenditure_type,
6175: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6176: retcode => l_autopop_status);
6177:
6178: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6179: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6180: l_susp_exception := 'AUTOPOP';
6181: l_suspense_ac_not_found := 'Y';
6182: l_autopop_error := 'AUTO_POP_EXP_ERROR';

Line 6179: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

6175: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6176: retcode => l_autopop_status);
6177:
6178: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6179: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6180: l_susp_exception := 'AUTOPOP';
6181: l_suspense_ac_not_found := 'Y';
6182: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6183: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

Line 6183: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

6179: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6180: l_susp_exception := 'AUTOPOP';
6181: l_suspense_ac_not_found := 'Y';
6182: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6183: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6184: l_autopop_error := 'AUTO_POP_NO_VALUE';
6185: END IF;
6186: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6187: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');

Line 6203: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6199: l_gl_project_flag := 'P';
6200: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
6201: l_project_id, l_award_id, l_task_id, l_effective_date,
6202: l_return_status);
6203: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6205: END IF;
6206: IF (g_sa_autopop) THEN
6207: psp_autopop.main(p_acct_type => 'E',

Line 6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6200: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
6201: l_project_id, l_award_id, l_task_id, l_effective_date,
6202: l_return_status);
6203: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6205: END IF;
6206: IF (g_sa_autopop) THEN
6207: psp_autopop.main(p_acct_type => 'E',
6208: p_person_id => r_suspense_ac.person_id(recno),

Line 6224: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR

6220: ret_expenditure_type => l_new_expenditure_type,
6221: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6222: retcode => l_autopop_status);
6223:
6224: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6225: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6226: l_susp_exception := 'AUTOPOP';
6227: l_suspense_ac_not_found := 'Y';
6228: l_autopop_error := 'AUTO_POP_EXP_ERROR';

Line 6225: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

6221: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6222: retcode => l_autopop_status);
6223:
6224: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6225: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6226: l_susp_exception := 'AUTOPOP';
6227: l_suspense_ac_not_found := 'Y';
6228: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6229: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

Line 6229: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

6225: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6226: l_susp_exception := 'AUTOPOP';
6227: l_suspense_ac_not_found := 'Y';
6228: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6229: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6230: l_autopop_error := 'AUTO_POP_NO_VALUE';
6231: END IF;
6232: OPEN project_number_cur;
6233: FETCH project_number_cur INTO l_project_number;

Line 6446: p_return_status := fnd_api.g_ret_sts_success;

6442: ELSE
6443: g_process_complete := FALSE;
6444: END IF;
6445:
6446: p_return_status := fnd_api.g_ret_sts_success;
6447: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6448: EXCEPTION
6449: WHEN NO_PROFILE_EXISTS THEN
6450: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 6453: p_return_status := fnd_api.g_ret_sts_success;

6449: WHEN NO_PROFILE_EXISTS THEN
6450: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6451: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
6452: fnd_msg_pub.add;
6453: p_return_status := fnd_api.g_ret_sts_success;
6454: WHEN NO_VAL_DATE_MATCHES THEN
6455: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6456: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6457: fnd_message.set_token('ORG_NAME',l_orig_org_name);

Line 6460: p_return_status := fnd_api.g_ret_sts_success;

6456: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6457: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6458: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6459: fnd_msg_pub.add;
6460: p_return_status := fnd_api.g_ret_sts_success;
6461: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6462: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6463: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6464: fnd_message.set_token('ORG_NAME',l_orig_org_name);

Line 6467: p_return_status := fnd_api.g_ret_sts_success;

6463: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6464: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6465: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6466: fnd_msg_pub.add;
6467: p_return_status := fnd_api.g_ret_sts_success;
6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6469: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6470: p_return_status := fnd_api.g_ret_sts_unexp_error;
6471: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');

Line 6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6464: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6465: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6466: fnd_msg_pub.add;
6467: p_return_status := fnd_api.g_ret_sts_success;
6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6469: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6470: p_return_status := fnd_api.g_ret_sts_unexp_error;
6471: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6472: WHEN OTHERS THEN

Line 6470: p_return_status := fnd_api.g_ret_sts_unexp_error;

6466: fnd_msg_pub.add;
6467: p_return_status := fnd_api.g_ret_sts_success;
6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6469: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6470: p_return_status := fnd_api.g_ret_sts_unexp_error;
6471: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6472: WHEN OTHERS THEN
6473: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6474: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');

Line 6475: p_return_status := fnd_api.g_ret_sts_unexp_error;

6471: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6472: WHEN OTHERS THEN
6473: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6474: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');
6475: p_return_status := fnd_api.g_ret_sts_unexp_error;
6476: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6477: END gms_enc_tie_back;
6478: -- End of changes for Create and Update multi thread enh.
6479:

Line 6684: p_return_status := fnd_api.g_ret_sts_success;

6680: AND NVL(pel.expenditure_organization_id, -99) = NVL(t_sum_lines.expenditure_organization_id(recno), -99)
6681: AND pel.dr_cr_flag = t_sum_lines.dr_cr_flag(recno)
6682: AND pel.gl_project_flag = t_sum_lines.gl_project_flag(recno);
6683: END IF;
6684: p_return_status := fnd_api.g_ret_sts_success;
6685: EXCEPTION
6686: WHEN OTHERS THEN
6687: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
6688: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', 'CREATE_SUM_LINES');

Line 6689: p_return_status := fnd_api.g_ret_sts_unexp_error;

6685: EXCEPTION
6686: WHEN OTHERS THEN
6687: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
6688: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', 'CREATE_SUM_LINES');
6689: p_return_status := fnd_api.g_ret_sts_unexp_error;
6690: END create_sum_lines;
6691:
6692: PROCEDURE update_hierarchy_dates (p_payroll_action_id IN NUMBER,
6693: p_return_status OUT NOCOPY VARCHAR2) IS

Line 6834: p_return_status := fnd_api.g_ret_sts_success;

6830: AND expenditure_type = t_enc_nlines.exp_type(recno)))
6831: AND enc_start_date <= t_enc_nlines.enc_end_date(recno)
6832: AND enc_end_date >= t_enc_nlines.enc_start_date(recno);
6833:
6834: p_return_status := fnd_api.g_ret_sts_success;
6835: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
6836: EXCEPTION
6837: WHEN OTHERS THEN
6838: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);

Line 6840: p_return_status := fnd_api.g_ret_sts_unexp_error;

6836: EXCEPTION
6837: WHEN OTHERS THEN
6838: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
6839: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', ' UPDATE_HIERARCHY_DATES');
6840: p_return_status := fnd_api.g_ret_sts_unexp_error;
6841: fnd_file.put_line(fnd_file.log, 'SQLCODE: ' || SQLCODE || ' SQLERRM: ' || SQLERRM);
6842: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
6843: END update_hierarchy_dates;
6844: