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_MSG_PUB

Line 175: fnd_msg_pub.initialize;

171: p_business_group_id: ' || p_business_group_id || '
172: p_set_of_books_id: ' || p_set_of_books_id);
173:
174: g_error_api_path := '';
175: fnd_msg_pub.initialize;
176: psp_general.TRANSACTION_CHANGE_PURGEBLE; --2431917
177: g_business_group_id := p_business_group_id;
178: g_set_of_books_id := p_set_of_books_id;
179: g_payroll_action_id := p_payroll_action_id; /* for Bug 2030232 */

Line 293: fnd_msg_pub.add;

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;
296: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');
297: end if;

Line 470: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');

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;
472:
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 || '

Line 484: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');

480: WHEN OTHERS THEN
481: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
482: ROLLBACK; --Introduced as part of bug fix 1776606
483: g_error_api_path := 'ENC_SUM_TRANS:'||g_error_api_path;
484: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
485: retcode := 2;
486:
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 || '

Line 533: fnd_msg_pub.add;

529:
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;

Line 559: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_BEGIN');

555: /* Introduced as part of bug fix #1776606 */
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: -- ##########################################################################

Line 724: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');

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;
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.

Line 892: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');

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;
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:

Line 1221: fnd_msg_pub.add;

1217: l_product := 'PSP';
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

Line 1238: fnd_msg_pub.add;

1234: l_product := 'PSP';
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

Line 1707: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');

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
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');

Line 1711: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GL_ENC_SUM_LINES');

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;
1713: END;
1714: End of comment for Create and Update enh. *****/
1715:

Line 1837: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','INSERT_INTO_ENC_SUM_LINES');

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;
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: -- ##########################################################################

Line 2040: fnd_msg_pub.add;

2036: l_product := 'GL';
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

Line 2058: fnd_msg_pub.add;

2054: l_table := 'PER_TIME_PERIODS';
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

Line 2210: fnd_msg_pub.add;

2206:
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

Line 2241: fnd_msg_pub.add;

2237: rphase, rstatus, dphase, dstatus, message);
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

Line 2314: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');

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');
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:

Line 2494: fnd_msg_pub.add;

2490:
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;

Line 2533: fnd_msg_pub.add;

2529:
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;

Line 2606: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');

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;
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.

Line 2632: fnd_msg_pub.add;

2628: l_product := 'GL';
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;

Line 2637: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');

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');
2638: p_return_status := fnd_api.g_ret_sts_unexp_error;
2639: END;
2640:
2641: -- ##########################################################################

Line 2661: fnd_msg_pub.add;

2657: l_product := 'GL';
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;

Line 2666: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');

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');
2667: p_return_status := fnd_api.g_ret_sts_unexp_error;
2668: END;
2669:
2670: -- ##########################################################################

Line 2693: fnd_msg_pub.add;

2689: l_product := 'GL';
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;

Line 2698: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','enc_type');

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');
2699: p_return_status := fnd_api.g_ret_sts_unexp_error;
2700:
2701: END;
2702:

Line 3157: fnd_msg_pub.add;

3153: / * GL encumbrance does not have reversal lines: bug 2030232
3154: IF l_reversal_ac_failed = 'Y' THEN
3155: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
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;

Line 3171: fnd_msg_pub.add;

3167: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3168: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3169: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3170: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3171: fnd_msg_pub.add;
3172:
3173:
3174: / * Added the following for Bug 3194807 * /
3175:

Line 3198: fnd_msg_pub.add; * /

3194: / * commented this message stack for 2479579
3195: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
3196: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
3197: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
3198: fnd_msg_pub.add; * /
3199: ---added following if stmnt for 2479579
3200: IF l_susp_exception = 'NO_G_AC' then
3201: RAISE no_global_acct_exists;
3202: ELSIF l_susp_exception = 'NO_DT_MCH' then

Line 3308: fnd_msg_pub.add;

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);
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

Line 3317: fnd_msg_pub.add;

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');
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

Line 3326: fnd_msg_pub.add;

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');
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

Line 3332: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');

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');
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. *****/

Line 3604: fnd_msg_pub.add;

3600: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3601: fnd_message.set_token('ORG_NAME', l_organization_name);
3602: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3603: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3604: fnd_msg_pub.add;
3605: ELSE
3606: l_susp_ac_found := 'TRUE';
3607:
3608: OPEN get_org_id_cur(r_suspense_ac.row_id(recno));

Line 3892: fnd_msg_pub.add;

3888: EXCEPTION
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');

Line 3899: fnd_msg_pub.add;

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);
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');

Line 3906: fnd_msg_pub.add;

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);
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;

Line 3915: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');

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;
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.

Line 4083: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','insert_into_gl_int');

4079: WHEN OTHERS THEN
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;

Line 4289: fnd_msg_pub.add;

4285: l_product := 'PSP';
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

Line 4306: fnd_msg_pub.add;

4302: l_product := 'PSP';
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

Line 4545: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GMS_ENC_SUM_LINES');

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');
4546: p_return_status := fnd_api.g_ret_sts_unexp_error;
4547:
4548: END;
4549: End of comment for Create and Update multi thread *****/

Line 4781: fnd_msg_pub.add;

4777: IF (l_gms_transaction_source IS NULL) THEN
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:

Line 4892: fnd_msg_pub.add;

4888: IF r_interface.employee_number(recno) IS NULL THEN
4889: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4890: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
4891: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
4892: fnd_msg_pub.add;
4893: l_raise_error := TRUE;
4894: END IF;
4895:
4896: IF r_interface.exp_org_name(recno) IS NULL THEN

Line 4900: fnd_msg_pub.add;

4896: IF r_interface.exp_org_name(recno) IS NULL THEN
4897: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4898: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4899: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4900: fnd_msg_pub.add;
4901: l_raise_error := TRUE;
4902: END IF;
4903:
4904: IF r_interface.operating_unit(recno) IS NULL THEN

Line 4908: fnd_msg_pub.add;

4904: IF r_interface.operating_unit(recno) IS NULL THEN
4905: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4906: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4907: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4908: fnd_msg_pub.add;
4909: l_raise_error := TRUE;
4910: END IF;
4911:
4912: IF r_interface.project_number(recno) IS NULL THEN

Line 4916: fnd_msg_pub.add;

4912: IF r_interface.project_number(recno) IS NULL THEN
4913: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4914: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4915: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4916: fnd_msg_pub.add;
4917: l_raise_error := TRUE;
4918: END IF;
4919:
4920: IF r_interface.task_number(recno) IS NULL THEN

Line 4924: fnd_msg_pub.add;

4920: IF r_interface.task_number(recno) IS NULL THEN
4921: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4922: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4923: fnd_message.set_token('TABLE', 'PA_TASKS');
4924: fnd_msg_pub.add;
4925: l_raise_error := TRUE;
4926: END IF;
4927: END LOOP;
4928:

Line 5027: fnd_msg_pub.add;

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;
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');

Line 5052: fnd_msg_pub.add;

5048:
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:

Line 5093: fnd_msg_pub.add;

5089:
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;

Line 5206: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GMS_INT');

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;
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:

Line 5732: fnd_msg_pub.add;

5728: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5729: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5730: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5731: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5732: fnd_msg_pub.add;
5733:
5734:
5735: / * Added the following for Bug 3194807 * /
5736:

Line 5761: fnd_msg_pub.add; * /

5757: / * commented this message stack for 2479579
5758: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5759: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5760: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5761: fnd_msg_pub.add; * /
5762: / * Included the following check as part of Bug fix #1776606 * /
5763: ---added following if stmnt for 2479579
5764: IF l_susp_exception = 'NO_G_AC' then
5765: RAISE no_global_acct_exists;

Line 5886: fnd_msg_pub.add;

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);
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

Line 5895: fnd_msg_pub.add;

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');
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

Line 5904: fnd_msg_pub.add;

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');
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

Line 5910: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');

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');
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. *****/

Line 6311: fnd_msg_pub.add;

6307: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6308: fnd_message.set_token('ORG_NAME', l_organization_name);
6309: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6310: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6311: fnd_msg_pub.add;
6312: ELSE
6313: l_susp_ac_found := 'TRUE';
6314:
6315: OPEN get_org_id_cur(r_suspense_ac.row_id(recno));

Line 6685: fnd_msg_pub.add;

6681: EXCEPTION
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');

Line 6692: fnd_msg_pub.add;

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);
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');

Line 6699: fnd_msg_pub.add;

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);
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;

Line 6708: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');

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;
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.

Line 6923: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', 'CREATE_SUM_LINES');

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);
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,

Line 7075: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', ' UPDATE_HIERARCHY_DATES');

7071: EXCEPTION
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;