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 173: fnd_msg_pub.initialize;

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

Line 286: fnd_msg_pub.add;

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

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

458: EXCEPTION
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK; --Introduced as part of bug fix 1776606
461: g_error_api_path := 'ENC_SUM_TRANS:'||g_error_api_path;
462: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
463: retcode := 2;
464:
465: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving enc_sum_trans p_payroll_action_id: ' || p_payroll_action_id || '
466: p_business_group_id: ' || p_business_group_id || '

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

471:
472: WHEN OTHERS THEN
473: ROLLBACK; --Introduced as part of bug fix 1776606
474: g_error_api_path := 'ENC_SUM_TRANS:'||g_error_api_path;
475: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
476: retcode := 2;
477:
478: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving enc_sum_trans p_payroll_action_id: ' || p_payroll_action_id || '
479: p_business_group_id: ' || p_business_group_id || '

Line 522: fnd_msg_pub.add;

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

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

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

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

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

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

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

Line 1201: fnd_msg_pub.add;

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

Line 1218: fnd_msg_pub.add;

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

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

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

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

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

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

1812: p_return_status := fnd_api.g_ret_sts_success;
1813: EXCEPTION
1814: WHEN OTHERS THEN
1815: g_error_api_path := 'INSERT_INTO_ENC_SUM_LINES:'||g_error_api_path;
1816: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','INSERT_INTO_ENC_SUM_LINES');
1817: p_return_status := fnd_api.g_ret_sts_unexp_error;
1818: END;
1819:
1820: -- ##########################################################################

Line 2019: fnd_msg_pub.add;

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

Line 2037: fnd_msg_pub.add;

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

Line 2189: fnd_msg_pub.add;

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

Line 2220: fnd_msg_pub.add;

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

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

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

Line 2475: fnd_msg_pub.add;

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

Line 2507: fnd_msg_pub.add;

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

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

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

Line 2593: fnd_msg_pub.add;

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

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

2593: fnd_msg_pub.add;
2594: p_return_status := fnd_api.g_ret_sts_unexp_error;
2595: WHEN OTHERS THEN
2596: g_error_api_path := 'gl_je_source:'||g_error_api_path;
2597: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');
2598: p_return_status := fnd_api.g_ret_sts_unexp_error;
2599: END;
2600:
2601: -- ##########################################################################

Line 2621: fnd_msg_pub.add;

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

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

2621: fnd_msg_pub.add;
2622: p_return_status := fnd_api.g_ret_sts_unexp_error;
2623: WHEN OTHERS THEN
2624: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
2625: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');
2626: p_return_status := fnd_api.g_ret_sts_unexp_error;
2627: END;
2628:
2629: -- ##########################################################################

Line 2652: fnd_msg_pub.add;

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

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

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

Line 3115: fnd_msg_pub.add;

3111: / * GL encumbrance does not have reversal lines: bug 2030232
3112: IF l_reversal_ac_failed = 'Y' THEN
3113: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
3114: fnd_message.set_token('GLCCID',x_lines_glccid);
3115: fnd_msg_pub.add;
3116: -- Included the following check as part of Bug fix #1776606 --
3117: IF p_mode = 'N' THEN
3118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3119: END IF;

Line 3129: fnd_msg_pub.add;

3125: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3126: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3127: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3128: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3129: fnd_msg_pub.add;
3130:
3131:
3132: / * Added the following for Bug 3194807 * /
3133:

Line 3156: fnd_msg_pub.add; * /

3152: / * commented this message stack for 2479579
3153: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
3154: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
3155: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
3156: fnd_msg_pub.add; * /
3157: ---added following if stmnt for 2479579
3158: IF l_susp_exception = 'NO_G_AC' then
3159: RAISE no_global_acct_exists;
3160: ELSIF l_susp_exception = 'NO_DT_MCH' then

Line 3266: fnd_msg_pub.add;

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

Line 3275: fnd_msg_pub.add;

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

Line 3284: fnd_msg_pub.add;

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

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

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

Line 3556: fnd_msg_pub.add;

3552: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3553: fnd_message.set_token('ORG_NAME', l_organization_name);
3554: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3555: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3556: fnd_msg_pub.add;
3557: ELSE
3558: l_susp_ac_found := 'TRUE';
3559:
3560: OPEN get_org_id_cur(r_suspense_ac.row_id(recno));

Line 3790: fnd_msg_pub.add;

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

Line 3797: fnd_msg_pub.add;

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

Line 3804: fnd_msg_pub.add;

3800: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3801: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3802: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3803: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3804: fnd_msg_pub.add;
3805: p_return_status := fnd_api.g_ret_sts_success;
3806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3807: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3808: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

Line 4185: fnd_msg_pub.add;

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

Line 4202: fnd_msg_pub.add;

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

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

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

Line 4672: fnd_msg_pub.add;

4668: IF (l_gms_transaction_source IS NULL) THEN
4669: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4670: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4671: fnd_message.set_token('PRODUCT','GMS');
4672: fnd_msg_pub.add;
4673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4674: END IF;
4675: END IF;
4676:

Line 4768: fnd_msg_pub.add;

4764: IF r_interface.employee_number(recno) IS NULL THEN
4765: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4766: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
4767: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
4768: fnd_msg_pub.add;
4769: l_raise_error := TRUE;
4770: END IF;
4771:
4772: IF r_interface.exp_org_name(recno) IS NULL THEN

Line 4776: fnd_msg_pub.add;

4772: IF r_interface.exp_org_name(recno) IS NULL THEN
4773: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4774: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4775: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4776: fnd_msg_pub.add;
4777: l_raise_error := TRUE;
4778: END IF;
4779:
4780: IF r_interface.operating_unit(recno) IS NULL THEN

Line 4784: fnd_msg_pub.add;

4780: IF r_interface.operating_unit(recno) IS NULL THEN
4781: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4782: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4783: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4784: fnd_msg_pub.add;
4785: l_raise_error := TRUE;
4786: END IF;
4787:
4788: IF r_interface.project_number(recno) IS NULL THEN

Line 4792: fnd_msg_pub.add;

4788: IF r_interface.project_number(recno) IS NULL THEN
4789: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4790: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4791: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4792: fnd_msg_pub.add;
4793: l_raise_error := TRUE;
4794: END IF;
4795:
4796: IF r_interface.task_number(recno) IS NULL THEN

Line 4800: fnd_msg_pub.add;

4796: IF r_interface.task_number(recno) IS NULL THEN
4797: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4798: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4799: fnd_message.set_token('TABLE', 'PA_TASKS');
4800: fnd_msg_pub.add;
4801: l_raise_error := TRUE;
4802: END IF;
4803: END LOOP;
4804:

Line 4891: fnd_msg_pub.add;

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

Line 4916: fnd_msg_pub.add;

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

Line 4951: fnd_msg_pub.add;

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

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

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

Line 5549: fnd_msg_pub.add;

5545: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5546: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5547: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5548: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5549: fnd_msg_pub.add;
5550:
5551:
5552: / * Added the following for Bug 3194807 * /
5553:

Line 5578: fnd_msg_pub.add; * /

5574: / * commented this message stack for 2479579
5575: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5576: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5577: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5578: fnd_msg_pub.add; * /
5579: / * Included the following check as part of Bug fix #1776606 * /
5580: ---added following if stmnt for 2479579
5581: IF l_susp_exception = 'NO_G_AC' then
5582: RAISE no_global_acct_exists;

Line 5703: fnd_msg_pub.add;

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

Line 5712: fnd_msg_pub.add;

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

Line 5721: fnd_msg_pub.add;

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

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

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

Line 6110: fnd_msg_pub.add;

6106: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6107: fnd_message.set_token('ORG_NAME', l_organization_name);
6108: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6109: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6110: fnd_msg_pub.add;
6111: ELSE
6112: l_susp_ac_found := 'TRUE';
6113:
6114: OPEN get_org_id_cur(r_suspense_ac.row_id(recno));

Line 6452: fnd_msg_pub.add;

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

Line 6459: fnd_msg_pub.add;

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

Line 6466: fnd_msg_pub.add;

6462: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6463: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6464: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6465: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6466: fnd_msg_pub.add;
6467: p_return_status := fnd_api.g_ret_sts_success;
6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6469: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6470: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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