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 PSP_ENC_LIQ_TRAN

Line 1: PACKAGE BODY PSP_ENC_LIQ_TRAN AS

1: PACKAGE BODY PSP_ENC_LIQ_TRAN AS
2: /* $Header: PSPENLQB.pls 120.12.12010000.3 2008/10/17 11:31:15 pvelugul ship $ */
3:
4: -- ##########################################################################
5: -- This procedure initiates the encumbrance liquidation processes gl/ogm

Line 342: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');

338: -- Replaced default successful return status with warning / success based on failed transactions check
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

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 515: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');

511: END IF;
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

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 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 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 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 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 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 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 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 7138: psp_enc_liq_tran.enc_liq_trans(

7134: END IF;
7135:
7136: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_liq_trans');
7137:
7138: psp_enc_liq_tran.enc_liq_trans(
7139: errbuf => l_errbuf,
7140: retcode => l_retcode,
7141: p_payroll_action_id => NULL,
7142: p_payroll_id => l_payroll_id,

Line 7232: psp_enc_liq_tran.enc_liq_trans(

7228: exit;
7229: end if;
7230: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_liq_trans');
7231:
7232: psp_enc_liq_tran.enc_liq_trans(
7233: errbuf => l_errbuf,
7234: retcode => l_retcode,
7235: p_payroll_action_id => NULL,
7236: p_payroll_id => l_payroll_id,

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 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 7271: END psp_enc_liq_tran;

7267: retcode := 2;
7268: end;
7269: End of comment for create and Update multi thread enh. *****/
7270:
7271: END psp_enc_liq_tran;