eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ENC_LIQ_TRAN dependencies on FND_MSG_PUB

Line 58: fnd_msg_pub.initialize;

54: p_action_type: ' || p_action_type || '
55: p_business_group_id: ' || p_business_group_id || '
56: p_set_of_books_id: ' || p_set_of_books_id);
57: g_error_api_path := '';
58: fnd_msg_pub.initialize;
59: psp_general.TRANSACTION_CHANGE_PURGEBLE; -- 2431917
60: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' PA Transaction Purgeble Flag set');
61: g_bg_id := p_business_group_id;
62: g_sob_id := p_set_of_books_id;

Line 103: fnd_msg_pub.add;

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

Line 125: fnd_msg_pub.add;

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

Line 344: fnd_msg_pub.add;

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

Line 376: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');

372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF; * /
374:
375: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
376: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
377: retcode := 2;
378: -- Added code for error message handler by Bijoy , 27-Jul-1999
379:
380: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');

Line 398: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');

394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
395: END IF; * /
396:
397: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
398: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
399: retcode := 2;
400: -- Added code for error message handler by Bijoy , 27-Jul-1999
401:
402: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');

Line 459: fnd_msg_pub.add;

455: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
456:
457: IF (g_control_rec_found = 'FALSE') THEN
458: fnd_message.set_name('PSP','PSP_ENC_NO_LIQ_REC_FOUND');
459: fnd_msg_pub.add;
460: p_return_status := FND_API.G_RET_STS_SUCCESS;
461: RETURN;
462: END IF;
463:

Line 470: fnd_msg_pub.add;

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

Line 517: fnd_msg_pub.add;

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

Line 535: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');

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

Line 542: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');

538: p_return_status := fnd_api.g_ret_sts_unexp_error;
539: WHEN OTHERS THEN
540: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
541: g_error_api_path := 'ENC_LIQ_TRANS:'||g_error_api_path;
542: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','ENC_LIQ_TRANS');
543: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_LIQ_TRANS');
544: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
545: p_return_status := fnd_api.g_ret_sts_unexp_error;
546: END enc_liq_trans;

Line 2299: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');

2295: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2296: WHEN OTHERS THEN
2297: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2298: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2299: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');
2300: p_return_status := fnd_api.g_ret_sts_unexp_error;
2301: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2302: END create_gl_enc_liq_lines;
2303: -- End of changes for bg fix 4625734

Line 2486: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');

2482: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2483: p_return_status := fnd_api.g_ret_sts_unexp_error;
2484: WHEN OTHERS THEN
2485: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2486: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');
2487: p_return_status := fnd_api.g_ret_sts_unexp_error;
2488: END create_gl_enc_liq_lines;
2489: End of comment for bug fix 4625734 *****/
2490:

Line 2629: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','INSERT_INTO_ENC_SUM_LINES');

2625: EXCEPTION
2626: WHEN OTHERS THEN
2627: --dbms_output.put_line('Insert into psp_enc_summary_lines failed');
2628: g_error_api_path := 'insert_into_enc_sum_lines:'||g_error_api_path;
2629: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','INSERT_INTO_ENC_SUM_LINES');
2630: p_return_status := fnd_api.g_ret_sts_unexp_error;
2631: END insert_into_enc_sum_lines;
2632: End of comment for bug fix 4625734 *****/
2633:

Line 2929: fnd_msg_pub.add;

2925: l_table := 'PER_TIME_PERIODS';
2926: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2927: fnd_message.set_token('VALUE','l_value');
2928: fnd_message.set_token('TABLE','l_table');
2929: fnd_msg_pub.add;
2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2931: END;
2932: If enc_control_rec.gl_phase = 'Summarize' then --- added for 2444657
2933: UPDATE psp_enc_summary_lines

Line 2969: fnd_msg_pub.add;

2965: l_product := 'GL';
2966: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2967: fnd_message.set_token('ERROR','l_error');
2968: fnd_message.set_token('PRODUCT','l_product');
2969: fnd_msg_pub.add;
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END;* /
2972: -- End of Comments for bug 2478000
2973:

Line 3118: fnd_msg_pub.add;

3114: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import submission failed');
3115: -- insert into psp_stout values(0, 'req did not get submitted');
3116:
3117: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3118: fnd_msg_pub.add;
3119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3120:
3121: ELSE
3122: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Journal Import (req_id: ' || req_id || ')');

Line 3163: fnd_msg_pub.add;

3159:
3160: IF call_status = FALSE then
3161: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
3162: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3163: fnd_msg_pub.add;
3164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3165: END IF;
3166: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');
3167: END IF;

Line 3278: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GL_INT');

3274: End of comment for bug fix 4625734 *****/
3275: WHEN OTHERS THEN
3276: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3277: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
3278: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GL_INT');
3279: p_return_status := fnd_api.g_ret_sts_unexp_error;
3280: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
3281: END tr_to_gl_int;
3282:

Line 3303: fnd_msg_pub.add;

3299: l_product := 'GL';
3300: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3301: fnd_message.set_token('ERROR',l_error);
3302: fnd_message.set_token('PRODUCT',l_product);
3303: fnd_msg_pub.add;
3304: p_return_status := fnd_api.g_ret_sts_unexp_error;
3305: WHEN OTHERS THEN
3306: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3307: g_error_api_path := 'gl_je_source:'||g_error_api_path;

Line 3308: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_source');

3304: p_return_status := fnd_api.g_ret_sts_unexp_error;
3305: WHEN OTHERS THEN
3306: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3307: g_error_api_path := 'gl_je_source:'||g_error_api_path;
3308: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_source');
3309: p_return_status := fnd_api.g_ret_sts_unexp_error;
3310: END gl_je_source;
3311:
3312: -- ##########################################################################

Line 3332: fnd_msg_pub.add;

3328: l_product := 'GL';
3329: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3330: fnd_message.set_token('ERROR',l_error);
3331: fnd_message.set_token('PRODUCT',l_product);
3332: fnd_msg_pub.add;
3333: p_return_status := fnd_api.g_ret_sts_unexp_error;
3334: WHEN OTHERS THEN
3335: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3336: g_error_api_path := 'gl_je_cat:'||g_error_api_path;

Line 3337: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_cat');

3333: p_return_status := fnd_api.g_ret_sts_unexp_error;
3334: WHEN OTHERS THEN
3335: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3336: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
3337: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_cat');
3338: p_return_status := fnd_api.g_ret_sts_unexp_error;
3339: END gl_je_cat;
3340:
3341: -- ##########################################################################

Line 3364: fnd_msg_pub.add;

3360: l_product := 'GL';
3361: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3362: fnd_message.set_token('ERROR',l_error);
3363: fnd_message.set_token('PRODUCT',l_product);
3364: fnd_msg_pub.add;
3365: p_return_status := fnd_api.g_ret_sts_unexp_error;
3366: WHEN OTHERS THEN
3367: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3368: g_error_api_path := 'enc_type:'||g_error_api_path;

Line 3369: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','enc_type');

3365: p_return_status := fnd_api.g_ret_sts_unexp_error;
3366: WHEN OTHERS THEN
3367: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3368: g_error_api_path := 'enc_type:'||g_error_api_path;
3369: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','enc_type');
3370: p_return_status := fnd_api.g_ret_sts_unexp_error;
3371:
3372: END enc_type;
3373:

Line 4096: fnd_msg_pub.add;

4092: / * commented: Bug 2039196
4093: IF l_reversal_ac_failed = 'Y' THEN
4094: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
4095: fnd_message.set_token('GLCCID',x_lines_glccid);
4096: fnd_msg_pub.add;
4097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4098: END IF; * /
4099:
4100: / ***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation

Line 4113: fnd_msg_pub.add;

4109: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4110: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4111: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4112: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4113: fnd_msg_pub.add;
4114: -- removed call enc_batch_end from here moved it to tr_to_gl for 2479579
4115: END IF;
4116: End of comment for Enh. Removal of suspense posting in Liquidation ***** /
4117:

Line 4124: fnd_msg_pub.add;

4120: IF l_suspense_ac_not_found = 'Y' THEN
4121: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4122: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4123: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4124: fnd_msg_pub.add;
4125: -- Bug 2039196: Introduced the if condn.
4126: if p_mode = 'N' then
4127: enc_batch_end(g_payroll_id,p_action_type, 'N',g_bg_id, g_sob_id,l_return_status);
4128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4213: fnd_msg_pub.add;

4209: / * Added Exceptions for bug 2056877 * /
4210: WHEN NO_PROFILE_EXISTS THEN
4211: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4212: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
4213: fnd_msg_pub.add;
4214: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4215:
4216: WHEN NO_VAL_DATE_MATCHES THEN
4217: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 4221: fnd_msg_pub.add;

4217: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4218: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4219: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4220: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4221: fnd_msg_pub.add;
4222: p_return_status := fnd_api.g_ret_sts_unexp_error;
4223: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4224:
4225: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 4230: fnd_msg_pub.add;

4226: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4227: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4228: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4229: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4230: fnd_msg_pub.add;
4231: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.
4232: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4233: end of comment for bug fix 4625734 *****/
4234:

Line 4238: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','GL_ENC_TIE_BACK');

4234:
4235: WHEN OTHERS THEN
4236: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4237: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
4238: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','GL_ENC_TIE_BACK');
4239: p_return_status := fnd_api.g_ret_sts_unexp_error;
4240: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
4241:
4242: END gl_enc_tie_back;

Line 4406: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','insert_into_gl_int');

4402: EXCEPTION
4403: WHEN OTHERS THEN
4404: --dbms_output.put_line('Error while inserting into gl_interface..........');
4405: g_error_api_path := 'insert_into_gl_int:'||g_error_api_path;
4406: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','insert_into_gl_int');
4407: p_return_status := fnd_api.g_ret_sts_unexp_error;
4408:
4409:
4410: END insert_into_gl_int;

Line 4793: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');

4789: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4790: WHEN OTHERS THEN
4791: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4792: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4793: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');
4794: p_return_status := fnd_api.g_ret_sts_unexp_error;
4795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4796: END create_gms_enc_liq_lines;
4797: -- End of changes for bug fix 4625734

Line 4988: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');

4984: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4985: p_return_status := fnd_api.g_ret_sts_unexp_error;
4986: WHEN OTHERS THEN
4987: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4988: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');
4989: p_return_status := fnd_api.g_ret_sts_unexp_error;
4990: END create_gms_enc_liq_lines;
4991: End of comment for bug fix 4625734 *****/
4992:

Line 5270: fnd_msg_pub.add;

5266: l_product := 'GMS';
5267: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5268: fnd_message.set_token('ERROR',l_error);
5269: fnd_message.set_token('PRODUCT',l_product);
5270: fnd_msg_pub.add;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5272: END;
5273: End of comment for bug fix 4625734 *****/
5274: OPEN transaction_source_cur;

Line 5284: fnd_msg_pub.add;

5280: IF (l_gms_transaction_source IS NULL) THEN
5281: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5282: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5283: fnd_message.set_token('PRODUCT','GMS');
5284: fnd_msg_pub.add;
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: END IF;
5287: end if;
5288:

Line 5397: fnd_msg_pub.add;

5393: IF r_interface.employee_number(recno) IS NULL THEN
5394: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5395: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5396: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5397: fnd_msg_pub.add;
5398: l_raise_error := TRUE;
5399: END IF;
5400:
5401: IF r_interface.exp_org_name(recno) IS NULL THEN

Line 5405: fnd_msg_pub.add;

5401: IF r_interface.exp_org_name(recno) IS NULL THEN
5402: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5403: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5404: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5405: fnd_msg_pub.add;
5406: l_raise_error := TRUE;
5407: END IF;
5408:
5409: IF r_interface.operating_unit(recno) IS NULL THEN

Line 5413: fnd_msg_pub.add;

5409: IF r_interface.operating_unit(recno) IS NULL THEN
5410: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5411: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5412: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5413: fnd_msg_pub.add;
5414: l_raise_error := TRUE;
5415: END IF;
5416:
5417: IF r_interface.project_number(recno) IS NULL THEN

Line 5421: fnd_msg_pub.add;

5417: IF r_interface.project_number(recno) IS NULL THEN
5418: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5419: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5420: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5421: fnd_msg_pub.add;
5422: l_raise_error := TRUE;
5423: END IF;
5424:
5425: IF r_interface.task_number(recno) IS NULL THEN

Line 5429: fnd_msg_pub.add;

5425: IF r_interface.task_number(recno) IS NULL THEN
5426: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5427: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5428: fnd_message.set_token('TABLE', 'PA_TASKS');
5429: fnd_msg_pub.add;
5430: l_raise_error := TRUE;
5431: END IF;
5432: END LOOP;
5433:

Line 5543: fnd_msg_pub.add;

5539: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5540:
5541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5542: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5543: fnd_msg_pub.add;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END IF;
5546: END LOOP;
5547: 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 5602: fnd_msg_pub.add;

5598: l_table := 'PER_PEOPLE_F';
5599: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5600: fnd_message.set_token('VALUE',l_value);
5601: fnd_message.set_token('TABLE',l_table);
5602: fnd_msg_pub.add;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END;
5605: --dbms_output.put_line('emp num='||l_emp_num);
5606:

Line 5619: fnd_msg_pub.add;

5615: l_table := 'HR_ORGANIZATION_UNITS';
5616: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5617: fnd_message.set_token('VALUE',l_value);
5618: fnd_message.set_token('TABLE',l_table);
5619: fnd_msg_pub.add;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: END;
5622: --dbms_output.put_line('org name='||l_org_name);
5623:

Line 5636: fnd_msg_pub.add;

5632: l_table := 'PA_PROJECTS_ALL';
5633: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5634: fnd_message.set_token('VALUE',l_value);
5635: fnd_message.set_token('TABLE',l_table);
5636: fnd_msg_pub.add;
5637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5638: END;
5639:
5640: BEGIN

Line 5652: fnd_msg_pub.add;

5648: l_table := 'PA_PROJECTS_ALL';
5649: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5650: fnd_message.set_token('VALUE',l_value);
5651: fnd_message.set_token('TABLE',l_table);
5652: fnd_msg_pub.add;
5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5654: END;
5655: --dbms_output.put_line('seg1='||l_seg1);
5656:

Line 5669: fnd_msg_pub.add;

5665: l_table := 'PA_TASKS';
5666: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5667: fnd_message.set_token('VALUE',l_value);
5668: fnd_message.set_token('TABLE',l_table);
5669: fnd_msg_pub.add;
5670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5671: END;
5672: --dbms_output.put_line('task='||l_task_number);
5673: l_rec_count := l_rec_count + 1;

Line 5782: fnd_msg_pub.add;

5778: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5779:
5780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5781: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5782: fnd_msg_pub.add;
5783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5784: END IF;
5785:
5786: end if;

Line 5838: fnd_msg_pub.add;

5834:
5835: IF req_id_tab(request_counter) = 0 THEN
5836: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
5837: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5838: fnd_msg_pub.add;
5839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5840: ELSE
5841: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');
5842:

Line 5893: fnd_msg_pub.add;

5889:
5890: IF call_status = FALSE then
5891: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
5892: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5893: fnd_msg_pub.add;
5894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5895: END IF;
5896: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');
5897: END LOOP;

Line 6047: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GMS_INT');

6043:
6044: WHEN OTHERS THEN
6045: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6046: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
6047: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GMS_INT');
6048: p_return_status := fnd_api.g_ret_sts_unexp_error;
6049:
6050: END tr_to_gms_int;
6051:

Line 6893: fnd_msg_pub.add;

6889: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6890: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6891: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6892: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6893: fnd_msg_pub.add;
6894: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /
6895: IF p_action_type IN ('Q','U') THEN
6896: UPDATE psp_enc_controls
6897: SET gms_phase = 'INVALID_SUSPENSE'

Line 6911: fnd_msg_pub.add;

6907: IF l_suspense_ac_not_found = 'Y' THEN
6908: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
6909: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
6910: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
6911: fnd_msg_pub.add;
6912: -- Bug 2039196: Introduced the if condn.
6913: if p_mode = 'N' then
6914: enc_batch_end(g_payroll_id,g_action_type, 'N',g_bg_id, g_sob_id,l_return_status);
6915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7062: fnd_msg_pub.add;

7058: /***** Commented the following for bgu fix 4625734
7059: WHEN NO_PROFILE_EXISTS THEN
7060: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7061: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
7062: fnd_msg_pub.add;
7063: --p_return_status := fnd_api.g_ret_sts_unexp_error;
7064: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
7065:
7066: WHEN NO_VAL_DATE_MATCHES THEN

Line 7071: fnd_msg_pub.add;

7067: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7068: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
7069: fnd_message.set_token('ORG_NAME',l_orig_org_name);
7070: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
7071: fnd_msg_pub.add;
7072: --p_return_status := fnd_api.g_ret_sts_unexp_error;
7073: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
7074:
7075: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 7080: fnd_msg_pub.add;

7076: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
7078: fnd_message.set_token('ORG_NAME',l_orig_org_name);
7079: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
7080: fnd_msg_pub.add;
7081: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
7082: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
7083: End of comment for bug fix 4625734 *****/
7084:

Line 7088: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','GMS_ENC_TIE_BACK');

7084:
7085: WHEN OTHERS THEN
7086: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
7087: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
7088: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','GMS_ENC_TIE_BACK');
7089: p_return_status := fnd_api.g_ret_sts_unexp_error;
7090: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
7091:
7092: END gms_enc_tie_back;

Line 7228: fnd_msg_pub.add;

7224:
7225: IF p_action_type = 'Q' THEN
7226: fnd_message.set_name('PSP','PSP_ENC_NUM_ASG');
7227: fnd_message.set_token('NUM_ASG',no_of_asg);
7228: fnd_msg_pub.add;
7229: psp_message_s.print_error (p_mode => FND_FILE.LOG,
7230: p_print_header => FND_API.G_FALSE);
7231: END IF;
7232:

Line 7238: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','MOVE_QKUPD_REC_TO_HIST');

7234:
7235: EXCEPTION
7236: WHEN OTHERS THEN
7237: g_error_api_path := SUBSTR('MOVE_QKUPD_REC_TO_HIST:'||g_error_api_path,1,230);
7238: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','MOVE_QKUPD_REC_TO_HIST');
7239: p_return_status := fnd_api.g_ret_sts_unexp_error;
7240: END move_qkupd_rec_to_hist;
7241: */
7242:

Line 7369: fnd_msg_pub.add;

7365: fnd_message.set_token('PERSON1', l_full_name1);
7366: fnd_message.set_token('TERMDATE1', l_termination_date1);
7367: fnd_message.set_token('PERSON2', l_full_name2);
7368: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7369: fnd_msg_pub.add;
7370:
7371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7372: END IF;
7373:

Line 7491: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');

7487: retcode := 0;
7488: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LIQUIDATE_EMP_TERM');
7489: exception
7490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7491: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7492: fnd_msg_pub.add;
7493: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7494: p_print_header => FND_API.G_TRUE);
7495: ROLLBACK;

Line 7492: fnd_msg_pub.add;

7488: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LIQUIDATE_EMP_TERM');
7489: exception
7490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7491: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7492: fnd_msg_pub.add;
7493: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7494: p_print_header => FND_API.G_TRUE);
7495: ROLLBACK;
7496: retcode := 2;

Line 7499: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');

7495: ROLLBACK;
7496: retcode := 2;
7497:
7498: when others then
7499: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7500: fnd_msg_pub.add;
7501: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7502: p_print_header => FND_API.G_TRUE);
7503: ROLLBACK;

Line 7500: fnd_msg_pub.add;

7496: retcode := 2;
7497:
7498: when others then
7499: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7500: fnd_msg_pub.add;
7501: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7502: p_print_header => FND_API.G_TRUE);
7503: ROLLBACK;
7504: errbuf := sqlerrm;