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 253: IF l_return_status NOT IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success) THEN

249: IF (l_liq_check > 0) THEN
250: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling psp_enc_liq_tran.enc_liq_trans');
251: psp_enc_liq_tran.enc_liq_trans(p_payroll_action_id, p_business_group_id, p_set_of_books_id, l_return_status);
252:
253: IF l_return_status NOT IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success) THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After psp_enc_liq_tran.enc_liq_trans');
257: END IF;

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling psp_enc_liq_tran.enc_liq_trans');
251: psp_enc_liq_tran.enc_liq_trans(p_payroll_action_id, p_business_group_id, p_set_of_books_id, l_return_status);
252:
253: IF l_return_status NOT IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success) THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After psp_enc_liq_tran.enc_liq_trans');
257: END IF;
258:

Line 262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

258:
259: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_begin');
260: enc_batch_begin(p_payroll_action_id, l_return_status);
261:
262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
266:

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

267: IF g_control_rec_found = 'FALSE' THEN
268: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
269: enc_batch_end(p_payroll_action_id, l_return_status);
270:
271: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
275: retcode := FND_API.G_RET_STS_SUCCESS;

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
269: enc_batch_end(p_payroll_action_id, l_return_status);
270:
271: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
275: retcode := FND_API.G_RET_STS_SUCCESS;
276:

Line 275: retcode := FND_API.G_RET_STS_SUCCESS;

271: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
275: retcode := FND_API.G_RET_STS_SUCCESS;
276:
277: psp_message_s.print_error(p_mode=>FND_FILE.log,
278: p_print_header=>FND_API.G_FALSE);
279: 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 278: p_print_header=>FND_API.G_FALSE);

274: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
275: retcode := FND_API.G_RET_STS_SUCCESS;
276:
277: psp_message_s.print_error(p_mode=>FND_FILE.log,
278: p_print_header=>FND_API.G_FALSE);
279: 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 || '
280: p_business_group_id: ' || p_business_group_id || '
281: p_set_of_books_id: ' || p_set_of_books_id);
282: PSP_MESSAGE_S.Print_success;

Line 291: If l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

287:
288: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then
289: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
290: pqh_psp_integration.relieve_budget_commitments( 'S', l_return_status);
291: If l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
292: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
293: fnd_msg_pub.add;
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: end if;

Line 294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

290: pqh_psp_integration.relieve_budget_commitments( 'S', l_return_status);
291: If l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
292: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
293: fnd_msg_pub.add;
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: end if;
296: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');
297: end if;
298:

Line 321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

317: IF (l_gl_check > 0) THEN
318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
319: tr_to_gl_int(p_payroll_action_id, l_return_status);
320:
321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
325: END IF;

Line 322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
319: tr_to_gl_int(p_payroll_action_id, l_return_status);
320:
321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
325: END IF;
326:

Line 347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

343: IF (l_gms_check > 0) THEN
344: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
345: tr_to_gms_int(p_payroll_action_id, l_return_status);
346:
347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;
350: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
351: END IF;

Line 348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

344: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
345: tr_to_gms_int(p_payroll_action_id, l_return_status);
346:
347: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;
350: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
351: END IF;
352:

Line 358: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

354: -- initiate the suspense lines summarization
355: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_sum_lines');
356: create_sum_lines(p_payroll_action_id, l_return_status);
357:
358: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: END IF;
361: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_sum_lines');
362:

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_sum_lines');
356: create_sum_lines(p_payroll_action_id, l_return_status);
357:
358: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: END IF;
361: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After create_sum_lines');
362:
363: -- call the user extension to populate attribute1 through attribute30

Line 382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

378: IF (l_gl_check > 0) THEN
379: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
380: tr_to_gl_int(p_payroll_action_id, l_return_status);
381:
382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
386: END IF;

Line 383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

379: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gl_int');
380: tr_to_gl_int(p_payroll_action_id, l_return_status);
381:
382: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gl_int');
386: END IF;
387:

Line 407: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

403: IF (l_gms_check > 0) THEN
404: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
405: tr_to_gms_int(p_payroll_action_id, l_return_status);
406:
407: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
411: END IF;

Line 408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

404: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling tr_to_gms_int');
405: tr_to_gms_int(p_payroll_action_id, l_return_status);
406:
407: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After tr_to_gms_int');
411: END IF;
412:

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 create_sum_lines');
446: create_sum_lines(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 create_sum_lines');
452:

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling create_sum_lines');
446: create_sum_lines(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 create_sum_lines');
452:
453: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');

Line 456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

452:
453: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
454: enc_batch_end(p_payroll_action_id, l_return_status);
455:
456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
460: retcode := FND_API.G_RET_STS_SUCCESS;

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_batch_end');
454: enc_batch_end(p_payroll_action_id, l_return_status);
455:
456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
460: retcode := FND_API.G_RET_STS_SUCCESS;
461:

Line 460: retcode := FND_API.G_RET_STS_SUCCESS;

456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_end');
460: retcode := FND_API.G_RET_STS_SUCCESS;
461:
462: 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 || '
463: p_business_group_id: ' || p_business_group_id || '
464: p_set_of_books_id: ' || p_set_of_books_id);

Line 467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

463: p_business_group_id: ' || p_business_group_id || '
464: p_set_of_books_id: ' || p_set_of_books_id);
465: PSP_MESSAGE_S.Print_success;
466: EXCEPTION
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: ROLLBACK; --Introduced as part of bug fix 1776606
469: g_error_api_path := 'ENC_SUM_TRANS:'||g_error_api_path;
470: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
471: retcode := 2;

Line 477: p_print_header => FND_API.G_TRUE);

473: 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 || '
474: p_business_group_id: ' || p_business_group_id || '
475: p_set_of_books_id: ' || p_set_of_books_id);
476: psp_message_s.print_error(p_mode => FND_FILE.LOG,
477: p_print_header => FND_API.G_TRUE);
478: return;
479:
480: WHEN OTHERS THEN
481: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 491: p_print_header => FND_API.G_TRUE);

487: 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 || '
488: p_business_group_id: ' || p_business_group_id || '
489: p_set_of_books_id: ' || p_set_of_books_id);
490: psp_message_s.print_error(p_mode => FND_FILE.LOG,
491: p_print_header => FND_API.G_TRUE);
492: return;
493: END;
494:
495: -- ##########################################################################

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

530: IF enc_control_cur%rowcount = 0 THEN
531: g_control_rec_found := 'FALSE';
532: fnd_message.set_name('PSP','PSP_ENC_NO_SUMM_REC_FOUND');
533: fnd_msg_pub.add;
534: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
535: -- for bug fix 1868338 -- Subha
536: p_return_status := fnd_api.g_ret_sts_success;
537: CLOSE enc_control_cur;
538: EXIT;

Line 536: p_return_status := fnd_api.g_ret_sts_success;

532: fnd_message.set_name('PSP','PSP_ENC_NO_SUMM_REC_FOUND');
533: fnd_msg_pub.add;
534: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
535: -- for bug fix 1868338 -- Subha
536: p_return_status := fnd_api.g_ret_sts_success;
537: CLOSE enc_control_cur;
538: EXIT;
539: END IF;
540: IF enc_control_cur%NOTFOUND THEN

Line 542: p_return_status := fnd_api.g_ret_sts_success;

538: EXIT;
539: END IF;
540: IF enc_control_cur%NOTFOUND THEN
541: CLOSE enc_control_cur;
542: p_return_status := fnd_api.g_ret_sts_success;
543: EXIT;
544: END IF;
545:
546: UPDATE psp_enc_controls

Line 560: p_return_status := fnd_api.g_ret_sts_unexp_error;

556: when others then
557: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
558: g_error_api_path := 'ENC_BATCH_BEGIN:'||g_error_api_path;
559: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_BEGIN');
560: p_return_status := fnd_api.g_ret_sts_unexp_error;
561: RAISE;
562: END;
563: -- ##########################################################################
564: -- This procedure ends the encumbrance summarization process

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

592: BEGIN
593: update_hierarchy_dates(p_payroll_action_id => p_payroll_action_id,
594: p_return_status => l_return_status);
595:
596: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
597: RAISE fnd_api.g_exc_unexpected_error;
598: END IF;
599:
600: log_st_warnings;

Line 597: RAISE fnd_api.g_exc_unexpected_error;

593: update_hierarchy_dates(p_payroll_action_id => p_payroll_action_id,
594: p_return_status => l_return_status);
595:
596: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
597: RAISE fnd_api.g_exc_unexpected_error;
598: END IF;
599:
600: log_st_warnings;
601:

Line 717: RAISE fnd_api.g_exc_unexpected_error;

713: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_pending_line_count'||l_pending_line_count);
714:
715: IF (l_pending_line_count > 0) THEN
716: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Need to re-process');
717: RAISE fnd_api.g_exc_unexpected_error;
718: END IF;
719: p_return_status := fnd_api.g_ret_sts_success;
720: EXCEPTION
721: WHEN OTHERS THEN

Line 719: p_return_status := fnd_api.g_ret_sts_success;

715: IF (l_pending_line_count > 0) THEN
716: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Need to re-process');
717: RAISE fnd_api.g_exc_unexpected_error;
718: END IF;
719: p_return_status := fnd_api.g_ret_sts_success;
720: EXCEPTION
721: WHEN OTHERS THEN
722: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
723: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;

Line 725: p_return_status := fnd_api.g_ret_sts_unexp_error;

721: WHEN OTHERS THEN
722: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
723: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;
724: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');
725: p_return_status := fnd_api.g_ret_sts_unexp_error;
726: END enc_batch_end;
727:
728: /***** Commented for Create and Update multi thread enh.
729: PROCEDURE enc_batch_end(p_payroll_action_id IN NUMBER,

Line 887: p_return_status := fnd_api.g_ret_sts_success;

883: AND pesl.superceded_line_id IS NOT NULL);
884: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to liquidate for liqduidation re-processing');
885:
886: COMMIT;
887: p_return_status := fnd_api.g_ret_sts_success;
888: EXCEPTION
889: / * Introduced as part of Bug fix #1776606 * /
890: WHEN others then
891: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;

Line 893: p_return_status := fnd_api.g_ret_sts_unexp_error;

889: / * Introduced as part of Bug fix #1776606 * /
890: WHEN others then
891: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;
892: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');
893: p_return_status := fnd_api.g_ret_sts_unexp_error;
894: END;
895: End of comment for Create and Update multi thread enh. *****/
896:
897: -- ##########################################################################

Line 1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1218: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1219: fnd_message.set_token('ERROR',l_error);
1220: fnd_message.set_token('PRODUCT',l_product);
1221: fnd_msg_pub.add;
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223: END;
1224:
1225: BEGIN
1226: SELECT parameter_value

Line 1239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1235: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1236: fnd_message.set_token('ERROR',l_error);
1237: fnd_message.set_token('PRODUCT',l_product);
1238: fnd_msg_pub.add;
1239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1240: END;
1241:
1242: IF l_time_para_value = '1' and l_gl_para_value = '3' THEN
1243:

Line 1303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1299: enc_sum_lines_p1_rec.attribute9,
1300: enc_sum_lines_p1_rec.attribute10,
1301: l_return_status);
1302:
1303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306:
1307: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859

Line 1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1300: enc_sum_lines_p1_rec.attribute10,
1301: l_return_status);
1302:
1303: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END IF;
1306:
1307: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859
1308: UPDATE psp_enc_lines

Line 1423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1419: NULL,
1420: enc_sum_lines_p2_rec.gl_project_flag,
1421: l_return_status);
1422:
1423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1425: END IF;
1426:
1427: UPDATE psp_enc_lines

Line 1424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1420: enc_sum_lines_p2_rec.gl_project_flag,
1421: l_return_status);
1422:
1423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1425: END IF;
1426:
1427: UPDATE psp_enc_lines
1428: SET enc_summary_line_id = l_enc_summary_line_id

Line 1488: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1484: NULL,
1485: enc_sum_lines_p3_rec.gl_project_flag,
1486: l_return_status);
1487:
1488: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1490: END IF;
1491:
1492: UPDATE psp_enc_lines

Line 1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1485: enc_sum_lines_p3_rec.gl_project_flag,
1486: l_return_status);
1487:
1488: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1490: END IF;
1491:
1492: UPDATE psp_enc_lines
1493: SET enc_summary_line_id = l_enc_summary_line_id

Line 1555: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1551: NULL,
1552: enc_sum_lines_g1_rec.gl_project_flag,
1553: l_return_status);
1554:
1555: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1557: END IF;
1558:
1559: UPDATE psp_enc_lines

Line 1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1552: enc_sum_lines_g1_rec.gl_project_flag,
1553: l_return_status);
1554:
1555: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1557: END IF;
1558:
1559: UPDATE psp_enc_lines
1560: SET enc_summary_line_id = l_enc_summary_line_id

Line 1619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1615: NULL,
1616: enc_sum_lines_g2_rec.gl_project_flag,
1617: l_return_status);
1618:
1619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1621: END IF;
1622:
1623: UPDATE psp_enc_lines

Line 1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1616: enc_sum_lines_g2_rec.gl_project_flag,
1617: l_return_status);
1618:
1619: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1621: END IF;
1622:
1623: UPDATE psp_enc_lines
1624: SET enc_summary_line_id = l_enc_summary_line_id

Line 1682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1678: NULL,
1679: enc_sum_lines_g3_rec.gl_project_flag,
1680: l_return_status);
1681:
1682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1684: END IF;
1685:
1686: UPDATE psp_enc_lines

Line 1683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1679: enc_sum_lines_g3_rec.gl_project_flag,
1680: l_return_status);
1681:
1682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1684: END IF;
1685:
1686: UPDATE psp_enc_lines
1687: SET enc_summary_line_id = l_enc_summary_line_id

Line 1702: p_return_status := fnd_api.g_ret_sts_success;

1698:
1699: END IF; -- Commented this END IF as part of Enh. 2143723
1700: *************************************************************************************************** /
1701:
1702: p_return_status := fnd_api.g_ret_sts_success;
1703:
1704: EXCEPTION
1705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1706: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;

Line 1705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1701:
1702: p_return_status := fnd_api.g_ret_sts_success;
1703:
1704: EXCEPTION
1705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1706: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1707: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
1708: p_return_status := fnd_api.g_ret_sts_unexp_error;
1709: WHEN OTHERS THEN

Line 1708: p_return_status := fnd_api.g_ret_sts_unexp_error;

1704: EXCEPTION
1705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1706: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1707: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
1708: p_return_status := fnd_api.g_ret_sts_unexp_error;
1709: WHEN OTHERS THEN
1710: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1711: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GL_ENC_SUM_LINES');
1712: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1712: p_return_status := fnd_api.g_ret_sts_unexp_error;

1708: p_return_status := fnd_api.g_ret_sts_unexp_error;
1709: WHEN OTHERS THEN
1710: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1711: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GL_ENC_SUM_LINES');
1712: p_return_status := fnd_api.g_ret_sts_unexp_error;
1713: END;
1714: End of comment for Create and Update enh. *****/
1715:
1716: -- ##########################################################################

Line 1832: p_return_status := fnd_api.g_ret_sts_success;

1828: FND_GLOBAL.USER_ID,
1829: FND_GLOBAL.LOGIN_ID,
1830: FND_GLOBAL.USER_ID,
1831: SYSDATE);
1832: p_return_status := fnd_api.g_ret_sts_success;
1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1836: g_error_api_path := 'INSERT_INTO_ENC_SUM_LINES:'||g_error_api_path;

Line 1838: p_return_status := fnd_api.g_ret_sts_unexp_error;

1834: WHEN OTHERS THEN
1835: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1836: g_error_api_path := 'INSERT_INTO_ENC_SUM_LINES:'||g_error_api_path;
1837: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','INSERT_INTO_ENC_SUM_LINES');
1838: p_return_status := fnd_api.g_ret_sts_unexp_error;
1839: END;
1840:
1841: -- ##########################################################################
1842: -- This procedure transfers the summarized lines from psp_enc_summary_lines

Line 1984: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1980: gl_tie_tab.delete;
1981:
1982: gl_je_source( l_user_je_source,
1983: l_return_status);
1984: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1986: END IF;
1987:
1988: gl_je_cat( l_user_je_cat,

Line 1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1981:
1982: gl_je_source( l_user_je_source,
1983: l_return_status);
1984: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1986: END IF;
1987:
1988: gl_je_cat( l_user_je_cat,
1989: l_return_status);

Line 1990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1986: END IF;
1987:
1988: gl_je_cat( l_user_je_cat,
1989: l_return_status);
1990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: END IF;
1993:
1994: enc_type( l_enc_type_id,

Line 1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1987:
1988: gl_je_cat( l_user_je_cat,
1989: l_return_status);
1990: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: END IF;
1993:
1994: enc_type( l_enc_type_id,
1995: l_return_status);

Line 1996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1992: END IF;
1993:
1994: enc_type( l_enc_type_id,
1995: l_return_status);
1996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: END IF;
1999:
2000: SELECT gl_interface_control_s.nextval

Line 1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1993:
1994: enc_type( l_enc_type_id,
1995: l_return_status);
1996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1998: END IF;
1999:
2000: SELECT gl_interface_control_s.nextval
2001: INTO l_group_id

Line 2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2037: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2038: fnd_message.set_token('ERROR',l_error);
2039: fnd_message.set_token('PRODUCT',l_product);
2040: fnd_msg_pub.add;
2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2042: END; * /
2043:
2044: --End of bug 2478000
2045:

Line 2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2055: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2056: fnd_message.set_token('VALUE','l_value');
2057: fnd_message.set_token('TABLE','l_table');
2058: fnd_msg_pub.add;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END;
2061:
2062: ---l_rec_count := 0; -- commented for 2444657
2063: if enc_control_rec.gl_phase = 'Summarize' then ---2444657

Line 2136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2132: INT_REC.ATTRIBUTE29,
2133: INT_REC.ATTRIBUTE30,
2134: L_RETURN_STATUS);
2135:
2136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2138: END IF;
2139: END LOOP; --int_cur loop
2140: end if; --- 2444657

Line 2137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2133: INT_REC.ATTRIBUTE30,
2134: L_RETURN_STATUS);
2135:
2136: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2138: END IF;
2139: END LOOP; --int_cur loop
2140: end if; --- 2444657
2141: / * Commented out as part of bug fix #2142865

Line 2211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2207: IF req_id = 0 THEN
2208:
2209: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2210: fnd_msg_pub.add;
2211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2212:
2213: ELSE
2214: / ***** Converted the following UPDATE to BULK for R12 performance fixes
2215: UPDATE psp_enc_controls

Line 2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2238:
2239: IF call_status = FALSE then
2240: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2241: fnd_msg_pub.add;
2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2243: END IF;
2244: END IF;
2245: END IF; -- l_rec_count > 0 --- moved from below ... for 2444657
2246:

Line 2259: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2255: gl_tie_tab(i).r_end_date,
2256: gl_tie_tab(i).r_group_id, --- replaced l_group_id for 2444657,
2257: g_business_group_id, g_set_of_books_id, 'N',
2258: l_return_status);
2259: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2261: END IF;
2262:
2263: end loop;

Line 2260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2256: gl_tie_tab(i).r_group_id, --- replaced l_group_id for 2444657,
2257: g_business_group_id, g_set_of_books_id, 'N',
2258: l_return_status);
2259: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2261: END IF;
2262:
2263: end loop;
2264: / *

Line 2265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2261: END IF;
2262:
2263: end loop;
2264: / *
2265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2267: END IF;
2268: -- moved inside the loop
2269:

Line 2266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2262:
2263: end loop;
2264: / *
2265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2267: END IF;
2268: -- moved inside the loop
2269:
2270: For Bug fix 1776606

Line 2299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2295: COMMIT; -- moved the commit from above for 2479579
2296: if g_susp_prob = 'Y' then -- introduced this IF stmnt for 2479579
2297: enc_batch_end(g_payroll_action_id,
2298: l_return_status);
2299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2300: end if;
2301:
2302: p_return_status := fnd_api.g_ret_sts_success;
2303:

Line 2302: p_return_status := fnd_api.g_ret_sts_success;

2298: l_return_status);
2299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2300: end if;
2301:
2302: p_return_status := fnd_api.g_ret_sts_success;
2303:
2304: EXCEPTION
2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2306: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;

Line 2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2301:
2302: p_return_status := fnd_api.g_ret_sts_success;
2303:
2304: EXCEPTION
2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2306: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2307: p_return_status := fnd_api.g_ret_sts_unexp_error;
2308:
2309: WHEN RETURN_BACK THEN

Line 2307: p_return_status := fnd_api.g_ret_sts_unexp_error;

2303:
2304: EXCEPTION
2305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2306: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2307: p_return_status := fnd_api.g_ret_sts_unexp_error;
2308:
2309: WHEN RETURN_BACK THEN
2310: p_return_status := fnd_api.g_ret_sts_success;
2311:

Line 2310: p_return_status := fnd_api.g_ret_sts_success;

2306: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2307: p_return_status := fnd_api.g_ret_sts_unexp_error;
2308:
2309: WHEN RETURN_BACK THEN
2310: p_return_status := fnd_api.g_ret_sts_success;
2311:
2312: WHEN OTHERS THEN
2313: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2314: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');

Line 2315: p_return_status := fnd_api.g_ret_sts_unexp_error;

2311:
2312: WHEN OTHERS THEN
2313: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2314: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');
2315: p_return_status := fnd_api.g_ret_sts_unexp_error;
2316: END;
2317: End of comment for Create and Update multi thread enh. *****/
2318:
2319: -- Introduced the following modified tr_to_gl_int procedure for Create and Update multi thread enh.

Line 2370: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2366:
2367: gl_je_source( l_user_je_source,
2368: l_return_status);
2369:
2370: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2372: END IF;
2373:
2374: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);

Line 2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2367: gl_je_source( l_user_je_source,
2368: l_return_status);
2369:
2370: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2372: END IF;
2373:
2374: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);
2375:

Line 2378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2374: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_source: ' || l_user_je_source);
2375:
2376: gl_je_cat( l_user_je_cat,
2377: l_return_status);
2378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2380: END IF;
2381:
2382: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);

Line 2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2375:
2376: gl_je_cat( l_user_je_cat,
2377: l_return_status);
2378: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2380: END IF;
2381:
2382: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);
2383:

Line 2386: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2382: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_user_je_cat: ' || l_user_je_cat);
2383:
2384: enc_type( l_enc_type_id,
2385: l_return_status);
2386: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2388: END IF;
2389:
2390: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);

Line 2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2383:
2384: enc_type( l_enc_type_id,
2385: l_return_status);
2386: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2388: END IF;
2389:
2390: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_enc_type_id: ' || l_enc_type_id);
2391:

Line 2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2491: IF req_id = 0 THEN
2492: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import submission failed');
2493: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2494: fnd_msg_pub.add;
2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496: ELSE
2497: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Journal Import (req_id: ' || req_id || ')');
2498: OPEN enc_control_id_cur;
2499: FETCH enc_control_id_cur BULK COLLECT INTO r_enc_controls.enc_control_id;

Line 2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2530: IF call_status = FALSE THEN
2531: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
2532: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2533: fnd_msg_pub.add;
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');
2537: END IF;
2538: END IF;

Line 2557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2553: g_set_of_books_id,
2554: 'N',
2555: l_return_status);
2556:
2557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: 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));
2560: ELSE
2561: 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 2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2554: 'N',
2555: l_return_status);
2556:
2557: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: 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));
2560: ELSE
2561: 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));
2562: END IF;

Line 2596: p_return_status := fnd_api.g_ret_sts_success;

2592:
2593: COMMIT;
2594: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' COMMITted gl_enc_tie_back');
2595:
2596: p_return_status := fnd_api.g_ret_sts_success;
2597: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2598: EXCEPTION
2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2600: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;

Line 2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2595:
2596: p_return_status := fnd_api.g_ret_sts_success;
2597: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2598: EXCEPTION
2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2600: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2601: p_return_status := fnd_api.g_ret_sts_unexp_error;
2602: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2603: WHEN OTHERS THEN

Line 2601: p_return_status := fnd_api.g_ret_sts_unexp_error;

2597: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2598: EXCEPTION
2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2600: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2601: p_return_status := fnd_api.g_ret_sts_unexp_error;
2602: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2603: WHEN OTHERS THEN
2604: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2605: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;

Line 2607: p_return_status := fnd_api.g_ret_sts_unexp_error;

2603: WHEN OTHERS THEN
2604: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2605: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2606: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');
2607: p_return_status := fnd_api.g_ret_sts_unexp_error;
2608: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2609: END tr_to_gl_int;
2610: -- End of changes for Create and Update multi thread enh.
2611:

Line 2633: p_return_status := fnd_api.g_ret_sts_unexp_error;

2629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2630: fnd_message.set_token('ERROR',l_error);
2631: fnd_message.set_token('PRODUCT',l_product);
2632: fnd_msg_pub.add;
2633: p_return_status := fnd_api.g_ret_sts_unexp_error;
2634: WHEN OTHERS THEN
2635: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2636: g_error_api_path := 'gl_je_source:'||g_error_api_path;
2637: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');

Line 2638: p_return_status := fnd_api.g_ret_sts_unexp_error;

2634: WHEN OTHERS THEN
2635: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2636: g_error_api_path := 'gl_je_source:'||g_error_api_path;
2637: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');
2638: p_return_status := fnd_api.g_ret_sts_unexp_error;
2639: END;
2640:
2641: -- ##########################################################################
2642: -- This procedure retrieves the user_je_category_name from gl_je_categories

Line 2662: p_return_status := fnd_api.g_ret_sts_unexp_error;

2658: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2659: fnd_message.set_token('ERROR',l_error);
2660: fnd_message.set_token('PRODUCT',l_product);
2661: fnd_msg_pub.add;
2662: p_return_status := fnd_api.g_ret_sts_unexp_error;
2663: WHEN OTHERS THEN
2664: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2665: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
2666: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');

Line 2667: p_return_status := fnd_api.g_ret_sts_unexp_error;

2663: WHEN OTHERS THEN
2664: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2665: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
2666: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');
2667: p_return_status := fnd_api.g_ret_sts_unexp_error;
2668: END;
2669:
2670: -- ##########################################################################
2671: -- This procedure retrieves the encumbrance_type_id from gl_encumbrance_types

Line 2694: p_return_status := fnd_api.g_ret_sts_unexp_error;

2690: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2691: fnd_message.set_token('ERROR',l_error);
2692: fnd_message.set_token('PRODUCT',l_product);
2693: fnd_msg_pub.add;
2694: p_return_status := fnd_api.g_ret_sts_unexp_error;
2695: WHEN OTHERS THEN
2696: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2697: g_error_api_path := 'enc_type:'||g_error_api_path;
2698: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','enc_type');

Line 2699: p_return_status := fnd_api.g_ret_sts_unexp_error;

2695: WHEN OTHERS THEN
2696: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2697: g_error_api_path := 'enc_type:'||g_error_api_path;
2698: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','enc_type');
2699: p_return_status := fnd_api.g_ret_sts_unexp_error;
2700:
2701: END;
2702:
2703: -- ##########################################################################

Line 3107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3103: l_award_id,
3104: l_task_id,
3105: l_effective_date,
3106: l_return_status);
3107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3108: --dbms_output.put_line('poeta call failed ');
3109: --insert_into_psp_stout( 'poeta call failed ');
3110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3111: END IF;

Line 3110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3106: l_return_status);
3107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3108: --dbms_output.put_line('poeta call failed ');
3109: --insert_into_psp_stout( 'poeta call failed ');
3110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3111: END IF;
3112:
3113: END IF;
3114:

Line 3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3156: fnd_message.set_token('GLCCID',x_lines_glccid);
3157: fnd_msg_pub.add;
3158: -- Included the following check as part of Bug fix #1776606 --
3159: IF p_mode = 'N' THEN
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3161: END IF;
3162: END IF;
3163: * /
3164:

Line 3298: p_return_status := fnd_api.g_ret_sts_success;

3294: l_rec_cnt := 0;
3295: END IF;
3296: -- END LOOP; -- ENC_CONTROL_CUR
3297: END IF; -- If (PROCESS_COMPLETE)
3298: p_return_status := fnd_api.g_ret_sts_success;
3299: EXCEPTION
3300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3301: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3302: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3296: -- END LOOP; -- ENC_CONTROL_CUR
3297: END IF; -- If (PROCESS_COMPLETE)
3298: p_return_status := fnd_api.g_ret_sts_success;
3299: EXCEPTION
3300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3301: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3302: p_return_status := fnd_api.g_ret_sts_unexp_error;
3303:
3304: / * Added Exceptions for bug 2056877 * /

Line 3302: p_return_status := fnd_api.g_ret_sts_unexp_error;

3298: p_return_status := fnd_api.g_ret_sts_success;
3299: EXCEPTION
3300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3301: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3302: p_return_status := fnd_api.g_ret_sts_unexp_error;
3303:
3304: / * Added Exceptions for bug 2056877 * /
3305: WHEN NO_PROFILE_EXISTS THEN
3306: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

3305: WHEN NO_PROFILE_EXISTS THEN
3306: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3307: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3308: fnd_msg_pub.add;
3309: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3310: p_return_status := fnd_api.g_ret_sts_success;
3311:
3312: WHEN NO_VAL_DATE_MATCHES THEN
3313: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 3310: p_return_status := fnd_api.g_ret_sts_success;

3306: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3307: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3308: fnd_msg_pub.add;
3309: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3310: p_return_status := fnd_api.g_ret_sts_success;
3311:
3312: WHEN NO_VAL_DATE_MATCHES THEN
3313: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3314: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

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

3314: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3315: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3316: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3317: fnd_msg_pub.add;
3318: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3319: p_return_status := fnd_api.g_ret_sts_success;
3320:
3321: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3322: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 3319: p_return_status := fnd_api.g_ret_sts_success;

3315: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3316: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3317: fnd_msg_pub.add;
3318: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3319: p_return_status := fnd_api.g_ret_sts_success;
3320:
3321: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3322: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3323: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

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

3323: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3324: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3325: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3326: fnd_msg_pub.add;
3327: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3328: p_return_status := fnd_api.g_ret_sts_success;
3329:
3330: WHEN OTHERS THEN
3331: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;

Line 3328: p_return_status := fnd_api.g_ret_sts_success;

3324: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3325: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3326: fnd_msg_pub.add;
3327: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3328: p_return_status := fnd_api.g_ret_sts_success;
3329:
3330: WHEN OTHERS THEN
3331: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3332: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');

Line 3333: p_return_status := fnd_api.g_ret_sts_unexp_error;

3329:
3330: WHEN OTHERS THEN
3331: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3332: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');
3333: p_return_status := fnd_api.g_ret_sts_unexp_error;
3334:
3335: END;
3336: End of comment for Create and Update multi thread enh. *****/
3337:

Line 3660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3656: l_gl_project_flag := 'P';
3657: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
3658: l_project_id, l_award_id, l_task_id, l_effective_date,
3659: l_return_status);
3660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3662: END IF;
3663: END IF;
3664:

Line 3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3657: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
3658: l_project_id, l_award_id, l_task_id, l_effective_date,
3659: l_return_status);
3660: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3662: END IF;
3663: END IF;
3664:
3665: UPDATE psp_enc_lines

Line 3886: p_return_status := fnd_api.g_ret_sts_success;

3882: ELSE
3883: g_process_complete := FALSE;
3884: END IF;
3885:
3886: p_return_status := fnd_api.g_ret_sts_success;
3887: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3888: EXCEPTION
3889: WHEN NO_PROFILE_EXISTS THEN
3890: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 3893: p_return_status := fnd_api.g_ret_sts_success;

3889: WHEN NO_PROFILE_EXISTS THEN
3890: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3891: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3892: fnd_msg_pub.add;
3893: p_return_status := fnd_api.g_ret_sts_success;
3894: WHEN NO_VAL_DATE_MATCHES THEN
3895: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3896: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3897: fnd_message.set_token('ORG_NAME',l_orig_org_name);

Line 3900: p_return_status := fnd_api.g_ret_sts_success;

3896: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3897: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3898: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3899: fnd_msg_pub.add;
3900: p_return_status := fnd_api.g_ret_sts_success;
3901: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3902: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3903: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3904: fnd_message.set_token('ORG_NAME',l_orig_org_name);

Line 3907: p_return_status := fnd_api.g_ret_sts_success;

3903: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3904: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3905: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3906: fnd_msg_pub.add;
3907: p_return_status := fnd_api.g_ret_sts_success;
3908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3909: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3910: p_return_status := fnd_api.g_ret_sts_unexp_error;
3911: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');

Line 3908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3904: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3905: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3906: fnd_msg_pub.add;
3907: p_return_status := fnd_api.g_ret_sts_success;
3908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3909: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3910: p_return_status := fnd_api.g_ret_sts_unexp_error;
3911: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3912: WHEN OTHERS THEN

Line 3910: p_return_status := fnd_api.g_ret_sts_unexp_error;

3906: fnd_msg_pub.add;
3907: p_return_status := fnd_api.g_ret_sts_success;
3908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3909: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3910: p_return_status := fnd_api.g_ret_sts_unexp_error;
3911: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3912: WHEN OTHERS THEN
3913: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3914: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;

Line 3916: p_return_status := fnd_api.g_ret_sts_unexp_error;

3912: WHEN OTHERS THEN
3913: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3914: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3915: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');
3916: p_return_status := fnd_api.g_ret_sts_unexp_error;
3917: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3918: END gl_enc_tie_back;
3919: -- End of changes for Create and Update multi thread enh.
3920:

Line 4076: p_return_status := fnd_api.g_ret_sts_success;

4072: P_ATTRIBUTE28,
4073: P_ATTRIBUTE29,
4074: P_ATTRIBUTE30);
4075:
4076: p_return_status := fnd_api.g_ret_sts_success;
4077:
4078: EXCEPTION
4079: WHEN OTHERS THEN
4080: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 4084: p_return_status := fnd_api.g_ret_sts_unexp_error;

4080: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4081: -- dbms_output.put_line('Error while inserting into gl_interface..........');
4082: g_error_api_path := 'insert_into_gl_int:'||g_error_api_path;
4083: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','insert_into_gl_int');
4084: p_return_status := fnd_api.g_ret_sts_unexp_error;
4085:
4086:
4087: END;
4088:

Line 4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4286: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4287: fnd_message.set_token('ERROR',l_error);
4288: fnd_message.set_token('PRODUCT',l_product);
4289: fnd_msg_pub.add;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END;
4292:
4293: BEGIN
4294: SELECT parameter_value

Line 4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4303: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4304: fnd_message.set_token('ERROR',l_error);
4305: fnd_message.set_token('PRODUCT',l_product);
4306: fnd_msg_pub.add;
4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4308: END;
4309:
4310: IF l_time_para_value = '1' and l_ogm_para_value = '1' THEN
4311: End of Enh. fix 2143723 * /

Line 4372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4368: enc_sum_lines_p_rec.attribute8,
4369: enc_sum_lines_p_rec.attribute9,
4370: enc_sum_lines_p_rec.attribute10,
4371: p_return_status);
4372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4374: END IF;
4375:
4376: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859

Line 4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4369: enc_sum_lines_p_rec.attribute9,
4370: enc_sum_lines_p_rec.attribute10,
4371: p_return_status);
4372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4374: END IF;
4375:
4376: IF (g_dff_grouping_option = 'N') THEN -- Introduced for bug fix 2908859
4377: UPDATE psp_enc_lines

Line 4512: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4508: enc_control_rec.payroll_id,
4509: NULL,
4510: enc_sum_lines_g_rec.gl_project_flag,
4511: l_return_status);
4512: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4514: END IF;
4515:
4516: UPDATE psp_enc_lines

Line 4513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4509: NULL,
4510: enc_sum_lines_g_rec.gl_project_flag,
4511: l_return_status);
4512: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4514: END IF;
4515:
4516: UPDATE psp_enc_lines
4517: SET enc_summary_line_id = l_enc_summary_line_id

Line 4536: p_return_status := fnd_api.g_ret_sts_success;

4532: END IF; Commented this END IF as part of Enh. 2143723
4533: ********************************************************************************** /
4534:
4535: --COMMIT;
4536: p_return_status := fnd_api.g_ret_sts_success;
4537:
4538: EXCEPTION
4539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4540: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;

Line 4539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4535: --COMMIT;
4536: p_return_status := fnd_api.g_ret_sts_success;
4537:
4538: EXCEPTION
4539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4540: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4541: p_return_status := fnd_api.g_ret_sts_unexp_error;
4542:
4543: WHEN OTHERS THEN

Line 4541: p_return_status := fnd_api.g_ret_sts_unexp_error;

4537:
4538: EXCEPTION
4539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4540: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4541: p_return_status := fnd_api.g_ret_sts_unexp_error;
4542:
4543: WHEN OTHERS THEN
4544: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4545: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GMS_ENC_SUM_LINES');

Line 4546: p_return_status := fnd_api.g_ret_sts_unexp_error;

4542:
4543: WHEN OTHERS THEN
4544: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4545: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GMS_ENC_SUM_LINES');
4546: p_return_status := fnd_api.g_ret_sts_unexp_error;
4547:
4548: END;
4549: End of comment for Create and Update multi thread *****/
4550:

Line 4782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4778: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4779: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4780: fnd_message.set_token('PRODUCT','GMS');
4781: fnd_msg_pub.add;
4782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4783: END IF;
4784: END IF;
4785:
4786: -- R12 MOAC Uptake

Line 4931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4927: END LOOP;
4928:
4929: IF l_raise_error THEN
4930: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Interface records have errors');
4931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4932: END IF;
4933:
4934: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed interface records for errors');
4935: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Computing PA week ending date(s)');

Line 5025: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5021: GMS_REC.ORIGINAL_ENCUMBRANCE_ITEM_ID := r_interface.expenditure_item_id(recno);
5022:
5023: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5024:
5025: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5026: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5027: fnd_msg_pub.add;
5028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5029: END IF;

Line 5028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5024:
5025: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5026: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5027: fnd_msg_pub.add;
5028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5029: END IF;
5030: END LOOP;
5031: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all by calling gms_transactions_pub.LOAD_GMS_XFACE_API');
5032: IF r_interface.txn_interface_id.COUNT > 0 THEN

Line 5053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5049: IF req_id_tab(request_counter) = 0 THEN
5050: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
5051: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5052: fnd_msg_pub.add;
5053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5054: ELSE
5055: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');
5056:
5057: OPEN enc_control_id_cur;

Line 5094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5090: IF call_status = FALSE then
5091: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
5092: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5093: fnd_msg_pub.add;
5094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5095: END IF;
5096: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');
5097: END LOOP;
5098: END IF;

Line 5115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5111: g_business_group_id,
5112: g_set_of_books_id,
5113: l_return_status);
5114:
5115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5116: 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));
5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5118: END IF;
5119: 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 5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5113: l_return_status);
5114:
5115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5116: 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));
5117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5118: END IF;
5119: 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));
5120: END LOOP;
5121:

Line 5194: p_return_status := fnd_api.g_ret_sts_success;

5190:
5191: COMMIT;
5192: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Committing');
5193:
5194: p_return_status := fnd_api.g_ret_sts_success;
5195: EXCEPTION
5196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5197: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5198: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5192: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Committing');
5193:
5194: p_return_status := fnd_api.g_ret_sts_success;
5195: EXCEPTION
5196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5197: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5198: p_return_status := fnd_api.g_ret_sts_unexp_error;
5199:
5200: WHEN RETURN_BACK THEN

Line 5198: p_return_status := fnd_api.g_ret_sts_unexp_error;

5194: p_return_status := fnd_api.g_ret_sts_success;
5195: EXCEPTION
5196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5197: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5198: p_return_status := fnd_api.g_ret_sts_unexp_error;
5199:
5200: WHEN RETURN_BACK THEN
5201: p_return_status := fnd_api.g_ret_sts_success;
5202:

Line 5201: p_return_status := fnd_api.g_ret_sts_success;

5197: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5198: p_return_status := fnd_api.g_ret_sts_unexp_error;
5199:
5200: WHEN RETURN_BACK THEN
5201: p_return_status := fnd_api.g_ret_sts_success;
5202:
5203: WHEN OTHERS THEN
5204: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5205: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;

Line 5207: p_return_status := fnd_api.g_ret_sts_unexp_error;

5203: WHEN OTHERS THEN
5204: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5205: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5206: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GMS_INT');
5207: p_return_status := fnd_api.g_ret_sts_unexp_error;
5208: END tr_to_gms_int;
5209: -- End of comment for Create and Update multi thread
5210:
5211: -- ##########################################################################

Line 5679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5675: l_award_id,
5676: l_task_id,
5677: l_effective_date,
5678: l_return_status);
5679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5681: END IF;
5682:
5683: END IF;

Line 5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5676: l_task_id,
5677: l_effective_date,
5678: l_return_status);
5679: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5681: END IF;
5682:
5683: END IF;
5684: / * For Bug fix 3194807 * /

Line 5876: p_return_status := fnd_api.g_ret_sts_success;

5872:
5873: END IF;
5874: END IF; -- IF (PROCESS_COMPLETE)
5875:
5876: p_return_status := fnd_api.g_ret_sts_success;
5877: EXCEPTION
5878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5879: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5880: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5874: END IF; -- IF (PROCESS_COMPLETE)
5875:
5876: p_return_status := fnd_api.g_ret_sts_success;
5877: EXCEPTION
5878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5879: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5880: p_return_status := fnd_api.g_ret_sts_unexp_error;
5881:
5882: / * Added Exceptions for bug 2056877 * /

Line 5880: p_return_status := fnd_api.g_ret_sts_unexp_error;

5876: p_return_status := fnd_api.g_ret_sts_success;
5877: EXCEPTION
5878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5879: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5880: p_return_status := fnd_api.g_ret_sts_unexp_error;
5881:
5882: / * Added Exceptions for bug 2056877 * /
5883: WHEN NO_PROFILE_EXISTS THEN
5884: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

5883: WHEN NO_PROFILE_EXISTS THEN
5884: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5885: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5886: fnd_msg_pub.add;
5887: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5888: p_return_status := fnd_api.g_ret_sts_success;
5889:
5890: WHEN NO_VAL_DATE_MATCHES THEN
5891: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 5888: p_return_status := fnd_api.g_ret_sts_success;

5884: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5885: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5886: fnd_msg_pub.add;
5887: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5888: p_return_status := fnd_api.g_ret_sts_success;
5889:
5890: WHEN NO_VAL_DATE_MATCHES THEN
5891: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5892: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

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

5892: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5893: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5894: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5895: fnd_msg_pub.add;
5896: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5897: p_return_status := fnd_api.g_ret_sts_success;
5898:
5899: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5900: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 5897: p_return_status := fnd_api.g_ret_sts_success;

5893: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5894: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5895: fnd_msg_pub.add;
5896: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5897: p_return_status := fnd_api.g_ret_sts_success;
5898:
5899: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5900: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5901: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

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

5901: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5902: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5903: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5904: fnd_msg_pub.add;
5905: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5906: p_return_status := fnd_api.g_ret_sts_success;
5907:
5908: WHEN OTHERS THEN
5909: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;

Line 5906: p_return_status := fnd_api.g_ret_sts_success;

5902: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5903: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5904: fnd_msg_pub.add;
5905: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5906: p_return_status := fnd_api.g_ret_sts_success;
5907:
5908: WHEN OTHERS THEN
5909: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5910: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');

Line 5911: p_return_status := fnd_api.g_ret_sts_unexp_error;

5907:
5908: WHEN OTHERS THEN
5909: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5910: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');
5911: p_return_status := fnd_api.g_ret_sts_unexp_error;
5912:
5913: END;
5914: End of comment for Create and Update multi thread enh. *****/
5915: -- Introduced the following modified gms_enc_tie_back procedure for Create and Update multi thread enh.

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

6375: ret_expenditure_type => l_new_expenditure_type,
6376: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6377: retcode => l_autopop_status);
6378:
6379: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6380: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6381: l_susp_exception := 'AUTOPOP';
6382: l_suspense_ac_not_found := 'Y';
6383: l_autopop_error := 'AUTO_POP_EXP_ERROR';

Line 6380: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

6376: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6377: retcode => l_autopop_status);
6378:
6379: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6380: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6381: l_susp_exception := 'AUTOPOP';
6382: l_suspense_ac_not_found := 'Y';
6383: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6384: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

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

6380: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6381: l_susp_exception := 'AUTOPOP';
6382: l_suspense_ac_not_found := 'Y';
6383: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6384: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6385: l_autopop_error := 'AUTO_POP_NO_VALUE';
6386: END IF;
6387: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6388: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');

Line 6404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

6400: l_gl_project_flag := 'P';
6401: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
6402: l_project_id, l_award_id, l_task_id, l_effective_date,
6403: l_return_status);
6404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: END IF;
6407: IF (g_sa_autopop) THEN
6408: psp_autopop.main(p_acct_type => 'E',

Line 6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6401: psp_general.poeta_effective_date(r_suspense_ac.encumbrance_date(recno),
6402: l_project_id, l_award_id, l_task_id, l_effective_date,
6403: l_return_status);
6404: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: END IF;
6407: IF (g_sa_autopop) THEN
6408: psp_autopop.main(p_acct_type => 'E',
6409: p_person_id => r_suspense_ac.person_id(recno),

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

6421: ret_expenditure_type => l_new_expenditure_type,
6422: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6423: retcode => l_autopop_status);
6424:
6425: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6426: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6427: l_susp_exception := 'AUTOPOP';
6428: l_suspense_ac_not_found := 'Y';
6429: l_autopop_error := 'AUTO_POP_EXP_ERROR';

Line 6426: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

6422: ret_gl_code_combination_id => l_new_gl_code_combination_id,
6423: retcode => l_autopop_status);
6424:
6425: IF (l_autopop_status = FND_API.G_RET_STS_UNEXP_ERROR) OR
6426: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6427: l_susp_exception := 'AUTOPOP';
6428: l_suspense_ac_not_found := 'Y';
6429: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6430: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN

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

6426: (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6427: l_susp_exception := 'AUTOPOP';
6428: l_suspense_ac_not_found := 'Y';
6429: l_autopop_error := 'AUTO_POP_EXP_ERROR';
6430: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6431: l_autopop_error := 'AUTO_POP_NO_VALUE';
6432: END IF;
6433: OPEN project_number_cur;
6434: FETCH project_number_cur INTO l_project_number;

Line 6679: p_return_status := fnd_api.g_ret_sts_success;

6675: ELSE
6676: g_process_complete := FALSE;
6677: END IF;
6678:
6679: p_return_status := fnd_api.g_ret_sts_success;
6680: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6681: EXCEPTION
6682: WHEN NO_PROFILE_EXISTS THEN
6683: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 6686: p_return_status := fnd_api.g_ret_sts_success;

6682: WHEN NO_PROFILE_EXISTS THEN
6683: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6684: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
6685: fnd_msg_pub.add;
6686: p_return_status := fnd_api.g_ret_sts_success;
6687: WHEN NO_VAL_DATE_MATCHES THEN
6688: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6689: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6690: fnd_message.set_token('ORG_NAME',l_orig_org_name);

Line 6693: p_return_status := fnd_api.g_ret_sts_success;

6689: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6690: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6691: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6692: fnd_msg_pub.add;
6693: p_return_status := fnd_api.g_ret_sts_success;
6694: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6695: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6696: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6697: fnd_message.set_token('ORG_NAME',l_orig_org_name);

Line 6700: p_return_status := fnd_api.g_ret_sts_success;

6696: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6697: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6698: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6699: fnd_msg_pub.add;
6700: p_return_status := fnd_api.g_ret_sts_success;
6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6702: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6703: p_return_status := fnd_api.g_ret_sts_unexp_error;
6704: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');

Line 6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6697: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6698: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6699: fnd_msg_pub.add;
6700: p_return_status := fnd_api.g_ret_sts_success;
6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6702: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6703: p_return_status := fnd_api.g_ret_sts_unexp_error;
6704: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6705: WHEN OTHERS THEN

Line 6703: p_return_status := fnd_api.g_ret_sts_unexp_error;

6699: fnd_msg_pub.add;
6700: p_return_status := fnd_api.g_ret_sts_success;
6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6702: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6703: p_return_status := fnd_api.g_ret_sts_unexp_error;
6704: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6705: WHEN OTHERS THEN
6706: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6707: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;

Line 6709: p_return_status := fnd_api.g_ret_sts_unexp_error;

6705: WHEN OTHERS THEN
6706: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6707: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6708: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');
6709: p_return_status := fnd_api.g_ret_sts_unexp_error;
6710: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6711: END gms_enc_tie_back;
6712: -- End of changes for Create and Update multi thread enh.
6713:

Line 6918: p_return_status := fnd_api.g_ret_sts_success;

6914: AND NVL(pel.expenditure_organization_id, -99) = NVL(t_sum_lines.expenditure_organization_id(recno), -99)
6915: AND pel.dr_cr_flag = t_sum_lines.dr_cr_flag(recno)
6916: AND pel.gl_project_flag = t_sum_lines.gl_project_flag(recno);
6917: END IF;
6918: p_return_status := fnd_api.g_ret_sts_success;
6919: EXCEPTION
6920: WHEN OTHERS THEN
6921: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6922: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);

Line 6924: p_return_status := fnd_api.g_ret_sts_unexp_error;

6920: WHEN OTHERS THEN
6921: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6922: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
6923: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', 'CREATE_SUM_LINES');
6924: p_return_status := fnd_api.g_ret_sts_unexp_error;
6925: END create_sum_lines;
6926:
6927: PROCEDURE update_hierarchy_dates (p_payroll_action_id IN NUMBER,
6928: p_return_status OUT NOCOPY VARCHAR2) IS

Line 7069: p_return_status := fnd_api.g_ret_sts_success;

7065: AND expenditure_type = t_enc_nlines.exp_type(recno)))
7066: AND enc_start_date <= t_enc_nlines.enc_end_date(recno)
7067: AND enc_end_date >= t_enc_nlines.enc_start_date(recno);
7068:
7069: p_return_status := fnd_api.g_ret_sts_success;
7070: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
7071: EXCEPTION
7072: WHEN OTHERS THEN
7073: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 7076: p_return_status := fnd_api.g_ret_sts_unexp_error;

7072: WHEN OTHERS THEN
7073: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
7074: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
7075: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', ' UPDATE_HIERARCHY_DATES');
7076: p_return_status := fnd_api.g_ret_sts_unexp_error;
7077: fnd_file.put_line(fnd_file.log, 'SQLCODE: ' || SQLCODE || ' SQLERRM: ' || SQLERRM);
7078: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
7079: END update_hierarchy_dates;
7080: