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_SUM_TRANS dependencies on PSP_SUM_TRANS

Line 1: PACKAGE BODY PSP_SUM_TRANS as

1: PACKAGE BODY PSP_SUM_TRANS as
2: /* $Header: PSPTRSTB.pls 120.24.12020000.6 2013/04/13 04:32:12 lkodaman ship $ */
3: --- g_gms_avail VARCHAR2(1) := 'N'; removed the usage of this variable, because
4: --- transfer_to_gms has checks on GMS phase. bug 2444657
5: /* Following three global variables introduced to faciliate calling mark_batch_end procedure

Line 340: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');

336: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
341: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
342: p_encoded => FND_API.G_FALSE,
343: p_data => l_msg_data,
344: p_msg_index_out => l_msg_count); */

Line 452: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');

448: WHEN OTHERS THEN
449: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
450:
451: g_error_api_path := 'MARK_BATCH_BEGIN: ' || g_error_api_path;
452: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');
453: p_return_status := fnd_api.g_ret_sts_unexp_error;
454: RAISE;
455: END;
456: -------------------- MARK BATCH END ---------------------------------------------

Line 625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');

621: WHEN OTHERS THEN
622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
623:
624: g_error_api_path := 'MARK_BATCH_END: ' || g_error_api_path;
625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');
626: p_return_status := fnd_api.g_ret_sts_unexp_error;
627: RAISE;
628: END;
629: -------------------- CREATE GL SUM LINES -----------------------------------------------

Line 1126: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');

1122: WHEN OTHERS THEN
1123: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1124:
1125: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1126: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
1127: p_return_status := fnd_api.g_ret_sts_unexp_error;
1128:
1129: END;
1130:

Line 1277: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');

1273: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1274:
1275: --dbms_output.put_line('Errrrrrrrrrrrrrrrrrrrrrrrrrrorrrrrrrrrrr.........');
1276: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1277: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1278: p_return_status := fnd_api.g_ret_sts_unexp_error;
1279: END;
1280:
1281: ------------------------ GL INTERFACE --------------------------------------------------

Line 1715: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');

1711: WHEN OTHERS THEN
1712: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1713:
1714: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1715: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1716: p_return_status := fnd_api.g_ret_sts_unexp_error;
1717: END;
1718:
1719: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

Line 1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');

1738: WHEN OTHERS THEN
1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1740:
1741: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1742: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1743: p_return_status := fnd_api.g_ret_sts_unexp_error;
1744: END;
1745:
1746: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 1769: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');

1765: WHEN OTHERS THEN
1766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1767:
1768: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1769: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1770: p_return_status := fnd_api.g_ret_sts_unexp_error;
1771: END;
1772:
1773: ---------------------- GET_ENCUM_TYPE_ID -----------------------------------------------

Line 1798: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');

1794: WHEN OTHERS THEN
1795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1796:
1797: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1798: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');
1799: p_return_status := fnd_api.g_ret_sts_unexp_error;
1800: END;
1801:
1802:

Line 2724: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');

2720: WHEN OTHERS THEN
2721: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2722:
2723: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2724: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
2725: p_return_status := fnd_api.g_ret_sts_unexp_error;
2726: END;
2727:
2728:

Line 2943: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');

2939: WHEN OTHERS THEN
2940: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2941:
2942: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2943: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2944: p_return_status := fnd_api.g_ret_sts_unexp_error;
2945: END;
2946:
2947: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------

Line 3119: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');

3115: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3116:
3117: --dbms_output.put_line('Error while inserting .........................');
3118: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
3119: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
3120: p_return_status := fnd_api.g_ret_sts_unexp_error;
3121: END;
3122:
3123: -------------------- CREATE GMS SUM LINES -----------------------------------------------

Line 3649: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');

3645: WHEN OTHERS THEN
3646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3647:
3648: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3649: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
3650: p_return_status := fnd_api.g_ret_sts_unexp_error;
3651:
3652: END;
3653:

Line 4295: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');

4291: WHEN OTHERS THEN
4292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
4293:
4294: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4295: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
4296: p_return_status := fnd_api.g_ret_sts_unexp_error;
4297: END;
4298:
4299:

Line 5495: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');

5491:
5492: WHEN OTHERS THEN
5493: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5494: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5495: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
5496: p_return_status := fnd_api.g_ret_sts_unexp_error;
5497: END;
5498:
5499: ------------------ INSERT INTO GMS INTERFACE -----------------------------------------------

Line 5625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');

5621: WHEN OTHERS THEN
5622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
5623: -- dbms_output.put_line('Error while inserting .........................');
5624: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
5625: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');
5626: p_return_status := fnd_api.g_ret_sts_unexp_error;
5627: END;
5628:
5629: /* Created this procedure on 4-Nov-2004.

Line 6282: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_RECEIVER_TYPES');

6278: EXCEPTION
6279: when others then
6280: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6281: hr_utility.trace( 'SandT_Supercede-->send notifications --> GET_RECEIVER_TYPES when others '||sqlerrm);
6282: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_RECEIVER_TYPES');
6283: raise;
6284: END GET_RECEIVER_TYPES;
6285:
6286: PROCEDURE CALL_WF(p_supercede_reqid_str in varchar2,

Line 6389: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CALL_WF');

6385: when others then
6386: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6387:
6388: hr_utility.trace( 'SandT_Supercede-->send notifications --> call_wf when others '||sqlerrm);
6389: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CALL_WF');
6390: raise;
6391: END CALL_WF;
6392:
6393:

Line 6510: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SEND_NOTIFICATIONS');

6506: when others then
6507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6508:
6509: hr_utility.trace( 'SandT_Supercede-->send notifications when others '||sqlerrm);
6510: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SEND_NOTIFICATIONS');
6511: raise;
6512: END SEND_NOTIFICATIONS;
6513: BEGIN ----SUPERCEDE_ER
6514: --- comment trace.. debug

Line 6881: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');

6877: EXCEPTION
6878: when others then
6879: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6880: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;
6881: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6882: p_return_status := fnd_api.g_ret_sts_unexp_error;
6883: END supercede_er;
6884:
6885: END PSP_SUM_TRANS;

Line 6885: END PSP_SUM_TRANS;

6881: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6882: p_return_status := fnd_api.g_ret_sts_unexp_error;
6883: END supercede_er;
6884:
6885: END PSP_SUM_TRANS;