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.17.12010000.2 2008/09/25 10:18:52 amakrish 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 287: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');

283: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
285: END IF;
286:
287: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SUM_AND_TRANSFER');
288: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
289: p_encoded => FND_API.G_FALSE,
290: p_data => l_msg_data,
291: p_msg_index_out => l_msg_count); */

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

393: /* Introduced as part of Bug fix #1776606 */
394: EXCEPTION
395: WHEN OTHERS THEN
396: g_error_api_path := 'MARK_BATCH_BEGIN: ' || g_error_api_path;
397: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_BEGIN');
398: p_return_status := fnd_api.g_ret_sts_unexp_error;
399: RAISE;
400: END;
401: -------------------- MARK BATCH END ---------------------------------------------

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

564: /* Introduced as part of Bug fix #1776606 */
565: EXCEPTION
566: WHEN OTHERS THEN
567: g_error_api_path := 'MARK_BATCH_END: ' || g_error_api_path;
568: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','MARK_BATCH_END');
569: p_return_status := fnd_api.g_ret_sts_unexp_error;
570: RAISE;
571: END;
572: -------------------- CREATE GL SUM LINES -----------------------------------------------

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

1039: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1040: p_return_status := fnd_api.g_ret_sts_unexp_error;
1041: WHEN OTHERS THEN
1042: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1043: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
1044: p_return_status := fnd_api.g_ret_sts_unexp_error;
1045:
1046: END;
1047:

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

1188: EXCEPTION
1189: WHEN OTHERS THEN
1190: --dbms_output.put_line('Errrrrrrrrrrrrrrrrrrrrrrrrrrorrrrrrrrrrr.........');
1191: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1192: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1193: p_return_status := fnd_api.g_ret_sts_unexp_error;
1194: END;
1195:
1196: ------------------------ GL INTERFACE --------------------------------------------------

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

1607: p_return_status := fnd_api.g_ret_sts_success;
1608:
1609: WHEN OTHERS THEN
1610: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1611: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1612: p_return_status := fnd_api.g_ret_sts_unexp_error;
1613: END;
1614:
1615: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

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

1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN
1635: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1636: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1637: p_return_status := fnd_api.g_ret_sts_unexp_error;
1638: END;
1639:
1640: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

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

1657: fnd_msg_pub.add;
1658: p_return_status := fnd_api.g_ret_sts_unexp_error;
1659: WHEN OTHERS THEN
1660: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1661: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1662: p_return_status := fnd_api.g_ret_sts_unexp_error;
1663: END;
1664:
1665: ---------------------- GET_ENCUM_TYPE_ID -----------------------------------------------

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

1684: fnd_msg_pub.add;
1685: p_return_status := fnd_api.g_ret_sts_unexp_error;
1686: WHEN OTHERS THEN
1687: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;
1688: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','ENCUMBRANCE_TYPE_ID');
1689: p_return_status := fnd_api.g_ret_sts_unexp_error;
1690: END;
1691:
1692:

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

2542: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2543:
2544: WHEN OTHERS THEN
2545: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
2546: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
2547: p_return_status := fnd_api.g_ret_sts_unexp_error;
2548: END;
2549:
2550:

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

2759: p_return_status := fnd_api.g_ret_sts_unexp_error;
2760:
2761: WHEN OTHERS THEN
2762: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2763: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2764: p_return_status := fnd_api.g_ret_sts_unexp_error;
2765: END;
2766:
2767: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------

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

2933: EXCEPTION
2934: WHEN OTHERS THEN
2935: --dbms_output.put_line('Error while inserting .........................');
2936: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2937: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
2938: p_return_status := fnd_api.g_ret_sts_unexp_error;
2939: END;
2940:
2941: -------------------- CREATE GMS SUM LINES -----------------------------------------------

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

3454: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3455: p_return_status := fnd_api.g_ret_sts_unexp_error;
3456: WHEN OTHERS THEN
3457: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
3458: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
3459: p_return_status := fnd_api.g_ret_sts_unexp_error;
3460:
3461: END;
3462:

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

4028: p_return_status := fnd_api.g_ret_sts_success;
4029:
4030: WHEN OTHERS THEN
4031: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
4032: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
4033: p_return_status := fnd_api.g_ret_sts_unexp_error;
4034: END;
4035:
4036:

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

5081: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5082:
5083: WHEN OTHERS THEN
5084: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
5085: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
5086: p_return_status := fnd_api.g_ret_sts_unexp_error;
5087: END;
5088:
5089: ------------------ INSERT INTO GMS INTERFACE -----------------------------------------------

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

5198:
5199: WHEN OTHERS THEN
5200: -- dbms_output.put_line('Error while inserting .........................');
5201: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
5202: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_PA_INTERFACE');
5203: p_return_status := fnd_api.g_ret_sts_unexp_error;
5204: END;
5205:
5206: /* Created this procedure on 4-Nov-2004.

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

5855: EXCEPTION
5856: when others then
5857:
5858: hr_utility.trace( 'SandT_Supercede-->send notifications --> GET_RECEIVER_TYPES when others '||sqlerrm);
5859: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_RECEIVER_TYPES');
5860: raise;
5861: END GET_RECEIVER_TYPES;
5862:
5863: PROCEDURE CALL_WF(p_supercede_reqid_str in varchar2,

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

5960: itemkey => l_wf_itemkey);
5961: EXCEPTION
5962: when others then
5963: hr_utility.trace( 'SandT_Supercede-->send notifications --> call_wf when others '||sqlerrm);
5964: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CALL_WF');
5965: raise;
5966: END CALL_WF;
5967:
5968:

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

6079: end if;
6080: EXCEPTION
6081: when others then
6082: hr_utility.trace( 'SandT_Supercede-->send notifications when others '||sqlerrm);
6083: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','SEND_NOTIFICATIONS');
6084: raise;
6085: END SEND_NOTIFICATIONS;
6086: BEGIN ----SUPERCEDE_ER
6087: --- comment trace.. debug

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

6449: hr_utility.trace( 'SandT_Supercede--> EXITING');
6450: EXCEPTION
6451: when others then
6452: hr_utility.trace( 'SandT_Supercede--> when others in supercede_er'||sqlerrm) ;
6453: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6454: p_return_status := fnd_api.g_ret_sts_unexp_error;
6455: END supercede_er;
6456:
6457: END PSP_SUM_TRANS;

Line 6457: END PSP_SUM_TRANS;

6453: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS', 'SUPERCEDE_ER');
6454: p_return_status := fnd_api.g_ret_sts_unexp_error;
6455: END supercede_er;
6456:
6457: END PSP_SUM_TRANS;