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 PSP_ENC_SUM_TRAN

Line 1: PACKAGE BODY PSP_ENC_SUM_TRAN AS

1: PACKAGE BODY PSP_ENC_SUM_TRAN AS
2: /* $Header: PSPENSTB.pls 120.13 2007/07/19 09:23:08 amakrish noship $ */
3:
4: -- ##########################################################################
5: -- This procedure initiates the encumbrance summarization processes gl/ogm

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 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 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 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 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 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 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 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 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 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 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 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 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 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;

Line 7148: END psp_enc_sum_tran;

7144: WHERE payroll_action_id = p_payroll_action_id
7145: AND status_code = 'R';
7146:
7147: END move_rej_lines_to_arch;
7148: END psp_enc_sum_tran;