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

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

Line 102: fnd_msg_pub.add;

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

Line 124: fnd_msg_pub.add;

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

Line 343: fnd_msg_pub.add;

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

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

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

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

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

Line 458: fnd_msg_pub.add;

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

Line 469: fnd_msg_pub.add;

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

Line 516: fnd_msg_pub.add;

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

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

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

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

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

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

2242: p_return_status := fnd_api.g_ret_sts_unexp_error;
2243: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2244: WHEN OTHERS THEN
2245: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2246: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');
2247: p_return_status := fnd_api.g_ret_sts_unexp_error;
2248: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GL_ENC_LIQ_LINES');
2249: END create_gl_enc_liq_lines;
2250: -- End of changes for bg fix 4625734

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

2429: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2430: p_return_status := fnd_api.g_ret_sts_unexp_error;
2431: WHEN OTHERS THEN
2432: g_error_api_path := 'CREATE_GL_ENC_LIQ_LINES:'||g_error_api_path;
2433: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GL_ENC_LIQ_LINES');
2434: p_return_status := fnd_api.g_ret_sts_unexp_error;
2435: END create_gl_enc_liq_lines;
2436: End of comment for bug fix 4625734 *****/
2437:

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

2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: --dbms_output.put_line('Insert into psp_enc_summary_lines failed');
2575: g_error_api_path := 'insert_into_enc_sum_lines:'||g_error_api_path;
2576: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','INSERT_INTO_ENC_SUM_LINES');
2577: p_return_status := fnd_api.g_ret_sts_unexp_error;
2578: END insert_into_enc_sum_lines;
2579: End of comment for bug fix 4625734 *****/
2580:

Line 2876: fnd_msg_pub.add;

2872: l_table := 'PER_TIME_PERIODS';
2873: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2874: fnd_message.set_token('VALUE','l_value');
2875: fnd_message.set_token('TABLE','l_table');
2876: fnd_msg_pub.add;
2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2878: END;
2879: If enc_control_rec.gl_phase = 'Summarize' then --- added for 2444657
2880: UPDATE psp_enc_summary_lines

Line 2916: fnd_msg_pub.add;

2912: l_product := 'GL';
2913: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2914: fnd_message.set_token('ERROR','l_error');
2915: fnd_message.set_token('PRODUCT','l_product');
2916: fnd_msg_pub.add;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END;* /
2919: -- End of Comments for bug 2478000
2920:

Line 3065: fnd_msg_pub.add;

3061: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import submission failed');
3062: -- insert into psp_stout values(0, 'req did not get submitted');
3063:
3064: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3065: fnd_msg_pub.add;
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: ELSE
3069: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Journal Import (req_id: ' || req_id || ')');

Line 3110: fnd_msg_pub.add;

3106:
3107: IF call_status = FALSE then
3108: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
3109: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3110: fnd_msg_pub.add;
3111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3112: END IF;
3113: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');
3114: END IF;

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

3220: p_return_status := fnd_api.g_ret_sts_success;
3221: End of comment for bug fix 4625734 *****/
3222: WHEN OTHERS THEN
3223: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
3224: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GL_INT');
3225: p_return_status := fnd_api.g_ret_sts_unexp_error;
3226: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
3227: END tr_to_gl_int;
3228:

Line 3249: fnd_msg_pub.add;

3245: l_product := 'GL';
3246: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3247: fnd_message.set_token('ERROR',l_error);
3248: fnd_message.set_token('PRODUCT',l_product);
3249: fnd_msg_pub.add;
3250: p_return_status := fnd_api.g_ret_sts_unexp_error;
3251: WHEN OTHERS THEN
3252: g_error_api_path := 'gl_je_source:'||g_error_api_path;
3253: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_source');

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

3249: fnd_msg_pub.add;
3250: p_return_status := fnd_api.g_ret_sts_unexp_error;
3251: WHEN OTHERS THEN
3252: g_error_api_path := 'gl_je_source:'||g_error_api_path;
3253: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_source');
3254: p_return_status := fnd_api.g_ret_sts_unexp_error;
3255: END gl_je_source;
3256:
3257: -- ##########################################################################

Line 3277: fnd_msg_pub.add;

3273: l_product := 'GL';
3274: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3275: fnd_message.set_token('ERROR',l_error);
3276: fnd_message.set_token('PRODUCT',l_product);
3277: fnd_msg_pub.add;
3278: p_return_status := fnd_api.g_ret_sts_unexp_error;
3279: WHEN OTHERS THEN
3280: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
3281: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_cat');

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

3277: fnd_msg_pub.add;
3278: p_return_status := fnd_api.g_ret_sts_unexp_error;
3279: WHEN OTHERS THEN
3280: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
3281: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','gl_je_cat');
3282: p_return_status := fnd_api.g_ret_sts_unexp_error;
3283: END gl_je_cat;
3284:
3285: -- ##########################################################################

Line 3308: fnd_msg_pub.add;

3304: l_product := 'GL';
3305: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3306: fnd_message.set_token('ERROR',l_error);
3307: fnd_message.set_token('PRODUCT',l_product);
3308: fnd_msg_pub.add;
3309: p_return_status := fnd_api.g_ret_sts_unexp_error;
3310: WHEN OTHERS THEN
3311: g_error_api_path := 'enc_type:'||g_error_api_path;
3312: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','enc_type');

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

3308: fnd_msg_pub.add;
3309: p_return_status := fnd_api.g_ret_sts_unexp_error;
3310: WHEN OTHERS THEN
3311: g_error_api_path := 'enc_type:'||g_error_api_path;
3312: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','enc_type');
3313: p_return_status := fnd_api.g_ret_sts_unexp_error;
3314:
3315: END enc_type;
3316:

Line 4033: fnd_msg_pub.add;

4029: / * commented: Bug 2039196
4030: IF l_reversal_ac_failed = 'Y' THEN
4031: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
4032: fnd_message.set_token('GLCCID',x_lines_glccid);
4033: fnd_msg_pub.add;
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: END IF; * /
4036:
4037: / ***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation

Line 4050: fnd_msg_pub.add;

4046: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4047: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4048: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4049: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4050: fnd_msg_pub.add;
4051: -- removed call enc_batch_end from here moved it to tr_to_gl for 2479579
4052: END IF;
4053: End of comment for Enh. Removal of suspense posting in Liquidation ***** /
4054:

Line 4061: fnd_msg_pub.add;

4057: IF l_suspense_ac_not_found = 'Y' THEN
4058: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4059: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4060: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4061: fnd_msg_pub.add;
4062: -- Bug 2039196: Introduced the if condn.
4063: if p_mode = 'N' then
4064: enc_batch_end(g_payroll_id,p_action_type, 'N',g_bg_id, g_sob_id,l_return_status);
4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4150: fnd_msg_pub.add;

4146: / * Added Exceptions for bug 2056877 * /
4147: WHEN NO_PROFILE_EXISTS THEN
4148: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4149: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
4150: fnd_msg_pub.add;
4151: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4152:
4153: WHEN NO_VAL_DATE_MATCHES THEN
4154: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

Line 4158: fnd_msg_pub.add;

4154: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4155: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4156: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4157: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4158: fnd_msg_pub.add;
4159: p_return_status := fnd_api.g_ret_sts_unexp_error;
4160: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4161:
4162: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 4167: fnd_msg_pub.add;

4163: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4164: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4165: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4166: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4167: fnd_msg_pub.add;
4168: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.
4169: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4170: end of comment for bug fix 4625734 *****/
4171:

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

4170: end of comment for bug fix 4625734 *****/
4171:
4172: WHEN OTHERS THEN
4173: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
4174: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','GL_ENC_TIE_BACK');
4175: p_return_status := fnd_api.g_ret_sts_unexp_error;
4176: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
4177:
4178: END gl_enc_tie_back;

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

4338: EXCEPTION
4339: WHEN OTHERS THEN
4340: --dbms_output.put_line('Error while inserting into gl_interface..........');
4341: g_error_api_path := 'insert_into_gl_int:'||g_error_api_path;
4342: fnd_msg_pub.add_exc_msg('psp_enc_liq_tran','insert_into_gl_int');
4343: p_return_status := fnd_api.g_ret_sts_unexp_error;
4344:
4345:
4346: END insert_into_gl_int;

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

4724: p_return_status := fnd_api.g_ret_sts_unexp_error;
4725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4726: WHEN OTHERS THEN
4727: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4728: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');
4729: p_return_status := fnd_api.g_ret_sts_unexp_error;
4730: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CREATE_GMS_ENC_LIQ_LINES');
4731: END create_gms_enc_liq_lines;
4732: -- End of changes for bug fix 4625734

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

4919: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4920: p_return_status := fnd_api.g_ret_sts_unexp_error;
4921: WHEN OTHERS THEN
4922: g_error_api_path := 'CREATE_GMS_ENC_LIQ_LINES:'||g_error_api_path;
4923: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','CREATE_GMS_ENC_LIQ_LINES');
4924: p_return_status := fnd_api.g_ret_sts_unexp_error;
4925: END create_gms_enc_liq_lines;
4926: End of comment for bug fix 4625734 *****/
4927:

Line 5205: fnd_msg_pub.add;

5201: l_product := 'GMS';
5202: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5203: fnd_message.set_token('ERROR',l_error);
5204: fnd_message.set_token('PRODUCT',l_product);
5205: fnd_msg_pub.add;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END;
5208: End of comment for bug fix 4625734 *****/
5209: OPEN transaction_source_cur;

Line 5217: fnd_msg_pub.add;

5213: IF (l_gms_transaction_source IS NULL) THEN
5214: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5215: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5216: fnd_message.set_token('PRODUCT','GMS');
5217: fnd_msg_pub.add;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5219: END IF;
5220: end if;
5221:

Line 5316: fnd_msg_pub.add;

5312: IF r_interface.employee_number(recno) IS NULL THEN
5313: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5314: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5315: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5316: fnd_msg_pub.add;
5317: l_raise_error := TRUE;
5318: END IF;
5319:
5320: IF r_interface.exp_org_name(recno) IS NULL THEN

Line 5324: fnd_msg_pub.add;

5320: IF r_interface.exp_org_name(recno) IS NULL THEN
5321: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5322: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5323: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5324: fnd_msg_pub.add;
5325: l_raise_error := TRUE;
5326: END IF;
5327:
5328: IF r_interface.operating_unit(recno) IS NULL THEN

Line 5332: fnd_msg_pub.add;

5328: IF r_interface.operating_unit(recno) IS NULL THEN
5329: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5330: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5331: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5332: fnd_msg_pub.add;
5333: l_raise_error := TRUE;
5334: END IF;
5335:
5336: IF r_interface.project_number(recno) IS NULL THEN

Line 5340: fnd_msg_pub.add;

5336: IF r_interface.project_number(recno) IS NULL THEN
5337: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5338: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5339: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5340: fnd_msg_pub.add;
5341: l_raise_error := TRUE;
5342: END IF;
5343:
5344: IF r_interface.task_number(recno) IS NULL THEN

Line 5348: fnd_msg_pub.add;

5344: IF r_interface.task_number(recno) IS NULL THEN
5345: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5346: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5347: fnd_message.set_token('TABLE', 'PA_TASKS');
5348: fnd_msg_pub.add;
5349: l_raise_error := TRUE;
5350: END IF;
5351: END LOOP;
5352:

Line 5448: fnd_msg_pub.add;

5444: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5445:
5446: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5447: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5448: fnd_msg_pub.add;
5449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5450: END IF;
5451: END LOOP;
5452: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted into gms_transaction_interface_all');

Line 5507: fnd_msg_pub.add;

5503: l_table := 'PER_PEOPLE_F';
5504: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5505: fnd_message.set_token('VALUE',l_value);
5506: fnd_message.set_token('TABLE',l_table);
5507: fnd_msg_pub.add;
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: END;
5510: --dbms_output.put_line('emp num='||l_emp_num);
5511:

Line 5524: fnd_msg_pub.add;

5520: l_table := 'HR_ORGANIZATION_UNITS';
5521: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5522: fnd_message.set_token('VALUE',l_value);
5523: fnd_message.set_token('TABLE',l_table);
5524: fnd_msg_pub.add;
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: END;
5527: --dbms_output.put_line('org name='||l_org_name);
5528:

Line 5541: fnd_msg_pub.add;

5537: l_table := 'PA_PROJECTS_ALL';
5538: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5539: fnd_message.set_token('VALUE',l_value);
5540: fnd_message.set_token('TABLE',l_table);
5541: fnd_msg_pub.add;
5542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5543: END;
5544:
5545: BEGIN

Line 5557: fnd_msg_pub.add;

5553: l_table := 'PA_PROJECTS_ALL';
5554: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5555: fnd_message.set_token('VALUE',l_value);
5556: fnd_message.set_token('TABLE',l_table);
5557: fnd_msg_pub.add;
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: END;
5560: --dbms_output.put_line('seg1='||l_seg1);
5561:

Line 5574: fnd_msg_pub.add;

5570: l_table := 'PA_TASKS';
5571: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5572: fnd_message.set_token('VALUE',l_value);
5573: fnd_message.set_token('TABLE',l_table);
5574: fnd_msg_pub.add;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5576: END;
5577: --dbms_output.put_line('task='||l_task_number);
5578: l_rec_count := l_rec_count + 1;

Line 5687: fnd_msg_pub.add;

5683: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5684:
5685: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5686: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5687: fnd_msg_pub.add;
5688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5689: END IF;
5690:
5691: end if;

Line 5742: fnd_msg_pub.add;

5738:
5739: IF req_id_tab(request_counter) = 0 THEN
5740: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
5741: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5742: fnd_msg_pub.add;
5743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5744: ELSE
5745: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');
5746:

Line 5788: fnd_msg_pub.add;

5784:
5785: IF call_status = FALSE then
5786: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
5787: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5788: fnd_msg_pub.add;
5789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5790: END IF;
5791: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');
5792: END LOOP;

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

5910: p_return_status := fnd_api.g_ret_sts_success;
5911:
5912: WHEN OTHERS THEN
5913: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5914: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','TR_TO_GMS_INT');
5915: p_return_status := fnd_api.g_ret_sts_unexp_error;
5916:
5917: END tr_to_gms_int;
5918:

Line 6676: fnd_msg_pub.add;

6672: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6673: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6674: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6675: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6676: fnd_msg_pub.add;
6677: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /
6678: IF p_action_type IN ('Q','U') THEN
6679: UPDATE psp_enc_controls
6680: SET gms_phase = 'INVALID_SUSPENSE'

Line 6694: fnd_msg_pub.add;

6690: IF l_suspense_ac_not_found = 'Y' THEN
6691: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
6692: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
6693: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
6694: fnd_msg_pub.add;
6695: -- Bug 2039196: Introduced the if condn.
6696: if p_mode = 'N' then
6697: enc_batch_end(g_payroll_id,g_action_type, 'N',g_bg_id, g_sob_id,l_return_status);
6698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6825: fnd_msg_pub.add;

6821: /***** Commented the following for bgu fix 4625734
6822: WHEN NO_PROFILE_EXISTS THEN
6823: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6824: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
6825: fnd_msg_pub.add;
6826: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6827: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6828:
6829: WHEN NO_VAL_DATE_MATCHES THEN

Line 6834: fnd_msg_pub.add;

6830: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6831: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6832: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6833: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6834: fnd_msg_pub.add;
6835: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6836: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6837:
6838: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 6843: fnd_msg_pub.add;

6839: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6840: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6841: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6842: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6843: fnd_msg_pub.add;
6844: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
6845: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6846: End of comment for bug fix 4625734 *****/
6847:

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

6846: End of comment for bug fix 4625734 *****/
6847:
6848: WHEN OTHERS THEN
6849: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6850: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','GMS_ENC_TIE_BACK');
6851: p_return_status := fnd_api.g_ret_sts_unexp_error;
6852: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6853:
6854: END gms_enc_tie_back;

Line 6990: fnd_msg_pub.add;

6986:
6987: IF p_action_type = 'Q' THEN
6988: fnd_message.set_name('PSP','PSP_ENC_NUM_ASG');
6989: fnd_message.set_token('NUM_ASG',no_of_asg);
6990: fnd_msg_pub.add;
6991: psp_message_s.print_error (p_mode => FND_FILE.LOG,
6992: p_print_header => FND_API.G_FALSE);
6993: END IF;
6994:

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

6996:
6997: EXCEPTION
6998: WHEN OTHERS THEN
6999: g_error_api_path := SUBSTR('MOVE_QKUPD_REC_TO_HIST:'||g_error_api_path,1,230);
7000: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','MOVE_QKUPD_REC_TO_HIST');
7001: p_return_status := fnd_api.g_ret_sts_unexp_error;
7002: END move_qkupd_rec_to_hist;
7003: */
7004:

Line 7131: fnd_msg_pub.add;

7127: fnd_message.set_token('PERSON1', l_full_name1);
7128: fnd_message.set_token('TERMDATE1', l_termination_date1);
7129: fnd_message.set_token('PERSON2', l_full_name2);
7130: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7131: fnd_msg_pub.add;
7132:
7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7134: END IF;
7135:

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

7249: retcode := 0;
7250: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LIQUIDATE_EMP_TERM');
7251: exception
7252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7253: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7254: fnd_msg_pub.add;
7255: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7256: p_print_header => FND_API.G_TRUE);
7257: ROLLBACK;

Line 7254: fnd_msg_pub.add;

7250: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LIQUIDATE_EMP_TERM');
7251: exception
7252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7253: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7254: fnd_msg_pub.add;
7255: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7256: p_print_header => FND_API.G_TRUE);
7257: ROLLBACK;
7258: retcode := 2;

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

7257: ROLLBACK;
7258: retcode := 2;
7259:
7260: when others then
7261: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7262: fnd_msg_pub.add;
7263: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7264: p_print_header => FND_API.G_TRUE);
7265: ROLLBACK;

Line 7262: fnd_msg_pub.add;

7258: retcode := 2;
7259:
7260: when others then
7261: fnd_msg_pub.add_exc_msg('PSP_ENC_LIQ_TRAN','LIQUIDATE_EMP_TERM');
7262: fnd_msg_pub.add;
7263: psp_message_s.print_error(p_mode => FND_FILE.LOG,
7264: p_print_header => FND_API.G_TRUE);
7265: ROLLBACK;
7266: errbuf := sqlerrm;