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.16.12020000.5 2013/03/27 00:38:00 lkodaman ship $ */
3:
4: -- ##########################################################################
5: -- This procedure initiates the encumbrance summarization processes gl/ogm

Line 470: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');

466: EXCEPTION
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: ROLLBACK; --Introduced as part of bug fix 1776606
469: g_error_api_path := 'ENC_SUM_TRANS:'||g_error_api_path;
470: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
471: retcode := 2;
472:
473: 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 || '
474: p_business_group_id: ' || p_business_group_id || '

Line 484: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');

480: WHEN OTHERS THEN
481: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
482: ROLLBACK; --Introduced as part of bug fix 1776606
483: g_error_api_path := 'ENC_SUM_TRANS:'||g_error_api_path;
484: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
485: retcode := 2;
486:
487: 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 || '
488: p_business_group_id: ' || p_business_group_id || '

Line 559: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_BEGIN');

555: /* Introduced as part of bug fix #1776606 */
556: when others then
557: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
558: g_error_api_path := 'ENC_BATCH_BEGIN:'||g_error_api_path;
559: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_BEGIN');
560: p_return_status := fnd_api.g_ret_sts_unexp_error;
561: RAISE;
562: END;
563: -- ##########################################################################

Line 724: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');

720: EXCEPTION
721: WHEN OTHERS THEN
722: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
723: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;
724: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');
725: p_return_status := fnd_api.g_ret_sts_unexp_error;
726: END enc_batch_end;
727:
728: /***** Commented for Create and Update multi thread enh.

Line 892: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');

888: EXCEPTION
889: / * Introduced as part of Bug fix #1776606 * /
890: WHEN others then
891: g_error_api_path := 'ENC_BATCH_END:'||g_error_api_path;
892: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_BATCH_END');
893: p_return_status := fnd_api.g_ret_sts_unexp_error;
894: END;
895: End of comment for Create and Update multi thread enh. *****/
896:

Line 1707: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');

1703:
1704: EXCEPTION
1705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1706: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1707: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
1708: p_return_status := fnd_api.g_ret_sts_unexp_error;
1709: WHEN OTHERS THEN
1710: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1711: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GL_ENC_SUM_LINES');

Line 1711: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GL_ENC_SUM_LINES');

1707: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','ENC_SUM_TRANS');
1708: p_return_status := fnd_api.g_ret_sts_unexp_error;
1709: WHEN OTHERS THEN
1710: g_error_api_path := 'CREATE_GL_ENC_SUM_LINES:'||g_error_api_path;
1711: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GL_ENC_SUM_LINES');
1712: p_return_status := fnd_api.g_ret_sts_unexp_error;
1713: END;
1714: End of comment for Create and Update enh. *****/
1715:

Line 1837: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','INSERT_INTO_ENC_SUM_LINES');

1833: EXCEPTION
1834: WHEN OTHERS THEN
1835: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1836: g_error_api_path := 'INSERT_INTO_ENC_SUM_LINES:'||g_error_api_path;
1837: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','INSERT_INTO_ENC_SUM_LINES');
1838: p_return_status := fnd_api.g_ret_sts_unexp_error;
1839: END;
1840:
1841: -- ##########################################################################

Line 2314: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');

2310: p_return_status := fnd_api.g_ret_sts_success;
2311:
2312: WHEN OTHERS THEN
2313: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2314: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');
2315: p_return_status := fnd_api.g_ret_sts_unexp_error;
2316: END;
2317: End of comment for Create and Update multi thread enh. *****/
2318:

Line 2606: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');

2602: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2603: WHEN OTHERS THEN
2604: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2605: g_error_api_path := 'TR_TO_GL_INT:'||g_error_api_path;
2606: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GL_INT');
2607: p_return_status := fnd_api.g_ret_sts_unexp_error;
2608: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving TR_TO_GL_INT');
2609: END tr_to_gl_int;
2610: -- End of changes for Create and Update multi thread enh.

Line 2637: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');

2633: p_return_status := fnd_api.g_ret_sts_unexp_error;
2634: WHEN OTHERS THEN
2635: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2636: g_error_api_path := 'gl_je_source:'||g_error_api_path;
2637: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_source');
2638: p_return_status := fnd_api.g_ret_sts_unexp_error;
2639: END;
2640:
2641: -- ##########################################################################

Line 2666: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');

2662: p_return_status := fnd_api.g_ret_sts_unexp_error;
2663: WHEN OTHERS THEN
2664: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2665: g_error_api_path := 'gl_je_cat:'||g_error_api_path;
2666: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','gl_je_cat');
2667: p_return_status := fnd_api.g_ret_sts_unexp_error;
2668: END;
2669:
2670: -- ##########################################################################

Line 2698: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','enc_type');

2694: p_return_status := fnd_api.g_ret_sts_unexp_error;
2695: WHEN OTHERS THEN
2696: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2697: g_error_api_path := 'enc_type:'||g_error_api_path;
2698: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','enc_type');
2699: p_return_status := fnd_api.g_ret_sts_unexp_error;
2700:
2701: END;
2702:

Line 3332: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');

3328: p_return_status := fnd_api.g_ret_sts_success;
3329:
3330: WHEN OTHERS THEN
3331: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3332: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');
3333: p_return_status := fnd_api.g_ret_sts_unexp_error;
3334:
3335: END;
3336: End of comment for Create and Update multi thread enh. *****/

Line 3915: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');

3911: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3912: WHEN OTHERS THEN
3913: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3914: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;
3915: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GL_ENC_TIE_BACK');
3916: p_return_status := fnd_api.g_ret_sts_unexp_error;
3917: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3918: END gl_enc_tie_back;
3919: -- End of changes for Create and Update multi thread enh.

Line 4083: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','insert_into_gl_int');

4079: WHEN OTHERS THEN
4080: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4081: -- dbms_output.put_line('Error while inserting into gl_interface..........');
4082: g_error_api_path := 'insert_into_gl_int:'||g_error_api_path;
4083: fnd_msg_pub.add_exc_msg('psp_enc_sum_tran','insert_into_gl_int');
4084: p_return_status := fnd_api.g_ret_sts_unexp_error;
4085:
4086:
4087: END;

Line 4545: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GMS_ENC_SUM_LINES');

4541: p_return_status := fnd_api.g_ret_sts_unexp_error;
4542:
4543: WHEN OTHERS THEN
4544: g_error_api_path := 'CREATE_GMS_ENC_SUM_LINES:'||g_error_api_path;
4545: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','CREATE_GMS_ENC_SUM_LINES');
4546: p_return_status := fnd_api.g_ret_sts_unexp_error;
4547:
4548: END;
4549: End of comment for Create and Update multi thread *****/

Line 5206: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GMS_INT');

5202:
5203: WHEN OTHERS THEN
5204: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5205: g_error_api_path := 'TR_TO_GMS_INT:'||g_error_api_path;
5206: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','TR_TO_GMS_INT');
5207: p_return_status := fnd_api.g_ret_sts_unexp_error;
5208: END tr_to_gms_int;
5209: -- End of comment for Create and Update multi thread
5210:

Line 5910: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');

5906: p_return_status := fnd_api.g_ret_sts_success;
5907:
5908: WHEN OTHERS THEN
5909: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
5910: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');
5911: p_return_status := fnd_api.g_ret_sts_unexp_error;
5912:
5913: END;
5914: End of comment for Create and Update multi thread enh. *****/

Line 6708: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');

6704: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6705: WHEN OTHERS THEN
6706: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6707: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;
6708: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN','GMS_ENC_TIE_BACK');
6709: p_return_status := fnd_api.g_ret_sts_unexp_error;
6710: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6711: END gms_enc_tie_back;
6712: -- End of changes for Create and Update multi thread enh.

Line 6923: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', 'CREATE_SUM_LINES');

6919: EXCEPTION
6920: WHEN OTHERS THEN
6921: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6922: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
6923: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', 'CREATE_SUM_LINES');
6924: p_return_status := fnd_api.g_ret_sts_unexp_error;
6925: END create_sum_lines;
6926:
6927: PROCEDURE update_hierarchy_dates (p_payroll_action_id IN NUMBER,

Line 7075: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', ' UPDATE_HIERARCHY_DATES');

7071: EXCEPTION
7072: WHEN OTHERS THEN
7073: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
7074: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
7075: fnd_msg_pub.add_exc_msg('PSP_ENC_SUM_TRAN', ' UPDATE_HIERARCHY_DATES');
7076: p_return_status := fnd_api.g_ret_sts_unexp_error;
7077: fnd_file.put_line(fnd_file.log, 'SQLCODE: ' || SQLCODE || ' SQLERRM: ' || SQLERRM);
7078: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
7079: END update_hierarchy_dates;

Line 7386: END psp_enc_sum_tran;

7382:
7383: fnd_file.put_line(fnd_file.log, 'Deleted rows from psp_enc_summary_lines with rejection code R'||sql%rowcount);
7384:
7385: END move_rej_lines_to_arch;
7386: END psp_enc_sum_tran;