DBA Data[Home] [Help]

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.18.12020000.3 2013/03/20 07:22:52 lkodaman ship $ */
3:
4: -- ##########################################################################
5: -- This procedure initiates the encumbrance liquidation processes gl/ogm

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

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

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

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

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

7372: END IF;
7373:
7374: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_liq_trans');
7375:
7376: psp_enc_liq_tran.enc_liq_trans(
7377: errbuf => l_errbuf,
7378: retcode => l_retcode,
7379: p_payroll_action_id => NULL,
7380: p_payroll_id => l_payroll_id,

Line 7470: psp_enc_liq_tran.enc_liq_trans(

7466: exit;
7467: end if;
7468: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling enc_liq_trans');
7469:
7470: psp_enc_liq_tran.enc_liq_trans(
7471: errbuf => l_errbuf,
7472: retcode => l_retcode,
7473: p_payroll_action_id => NULL,
7474: p_payroll_id => l_payroll_id,

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

7505: retcode := 2;
7506: end;
7507: End of comment for create and Update multi thread enh. *****/
7508:
7509: END psp_enc_liq_tran;