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_ADJ dependencies on PSP_SUM_ADJ

Line 1: PACKAGE BODY PSP_SUM_ADJ as

1: PACKAGE BODY PSP_SUM_ADJ as
2: /* $Header: PSPADSTB.pls 120.18.12020000.9 2013/04/12 05:15:24 lkodaman ship $ */
3: g_gms_avail varchar2(1) := 'N';
4: g_fatal number;
5: g_gms_batch_name varchar2(10); /* bug 1662816 */

Line 402: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','MARK_BATCH_BEGIN');

398: p_return_status := fnd_api.g_ret_sts_success;
399: --Included as part of Bug fix #1776606
400: EXCEPTION
401: WHEN OTHERS THEN
402: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','MARK_BATCH_BEGIN');
403: raise;
404: END;
405: -------------------- MARK BATCH END ---------------------------------------------
406:

Line 580: -- FND_MSG_PUB.ADD_EXC_MSG('PSP_SUM_ADJ', SQLERRM);

576:
577: EXCEPTION
578: WHEN OTHERS THEN
579: -- Bug 1776606 : Modifying the message to be displayed
580: -- FND_MSG_PUB.ADD_EXC_MSG('PSP_SUM_ADJ', SQLERRM);
581: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','MARK_BATCH_END');
582: raise;
583: END;
584:

Line 581: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','MARK_BATCH_END');

577: EXCEPTION
578: WHEN OTHERS THEN
579: -- Bug 1776606 : Modifying the message to be displayed
580: -- FND_MSG_PUB.ADD_EXC_MSG('PSP_SUM_ADJ', SQLERRM);
581: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','MARK_BATCH_END');
582: raise;
583: END;
584:
585:

Line 1019: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GL_SUM_LINES');

1015: EXCEPTION
1016:
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1019: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GL_SUM_LINES');
1020: p_return_status := fnd_api.g_ret_sts_unexp_error;
1021: WHEN OTHERS THEN
1022: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1023: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GL_SUM_LINES');

Line 1023: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GL_SUM_LINES');

1019: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GL_SUM_LINES');
1020: p_return_status := fnd_api.g_ret_sts_unexp_error;
1021: WHEN OTHERS THEN
1022: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
1023: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GL_SUM_LINES');
1024: p_return_status := fnd_api.g_ret_sts_unexp_error;
1025:
1026: END;
1027:

Line 1175: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','INSERT_INTO_SUMMARY_LINES');

1171: p_return_status := fnd_api.g_ret_sts_success;
1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1175: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','INSERT_INTO_SUMMARY_LINES');
1176: p_return_status := fnd_api.g_ret_sts_unexp_error;
1177: END;
1178:
1179: ------------------------ GL INTERFACE --------------------------------------------------

Line 1552: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GL_INTERFACE');

1548: p_return_status := fnd_api.g_ret_sts_success;
1549: EXCEPTION
1550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1551: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1552: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GL_INTERFACE');
1553: p_return_status := fnd_api.g_ret_sts_unexp_error;
1554:
1555: WHEN RETURN_BACK THEN
1556: p_return_status := fnd_api.g_ret_sts_success;

Line 1560: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GL_INTERFACE');

1556: p_return_status := fnd_api.g_ret_sts_success;
1557:
1558: WHEN OTHERS THEN
1559: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1560: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GL_INTERFACE');
1561: p_return_status := fnd_api.g_ret_sts_unexp_error;
1562: END;
1563:
1564: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

Line 1601: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');

1597: -- fnd_message.set_token('ERROR',l_error);
1598: -- fnd_message.set_token('PRODUCT',l_product);
1599: -- fnd_msg_pub.add;
1600: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1601: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1602: p_return_status := fnd_api.g_ret_sts_unexp_error;
1603: WHEN OTHERS THEN
1604: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1605: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');

Line 1605: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');

1601: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1602: p_return_status := fnd_api.g_ret_sts_unexp_error;
1603: WHEN OTHERS THEN
1604: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1605: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_SOURCES');
1606: p_return_status := fnd_api.g_ret_sts_unexp_error;
1607: END;
1608:
1609: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 1647: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_CATEGORY_NAME');

1643: -- fnd_msg_pub.add;
1644: p_return_status := fnd_api.g_ret_sts_unexp_error;
1645: WHEN OTHERS THEN
1646: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1647: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_JE_CATEGORY_NAME');
1648: p_return_status := fnd_api.g_ret_sts_unexp_error;
1649: END;
1650:
1651: -------------------- GL TIE BACK -----------------------------------------------------

Line 1791: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_TIE_BACK');

1787: FETCH summary_group_cur INTO l_group_id;
1788: IF (summary_group_cur%NOTFOUND) THEN
1789: CLOSE summary_group_cur;
1790: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1791: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_TIE_BACK');
1792: p_return_status := fnd_api.g_ret_sts_unexp_error;
1793: EXIT;
1794: END IF;
1795: CLOSE summary_group_cur;

Line 1858: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_TIE_BACK');

1854: FETCH gl_interface_group_cur INTO l_cnt_gl_interface;
1855: IF (gl_interface_group_cur%NOTFOUND) THEN
1856: CLOSE gl_interface_group_cur;
1857: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1858: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_TIE_BACK');
1859: p_return_status := fnd_api.g_ret_sts_unexp_error;
1860: EXIT;
1861: END IF;
1862: CLOSE gl_interface_group_cur;

Line 1966: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_TIE_BACK');

1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1965: -- Included the following for bug fix 1765678
1966: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_TIE_BACK');
1967: p_return_status := fnd_api.g_ret_sts_unexp_error;
1968:
1969: WHEN OTHERS THEN
1970: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;

Line 1971: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_TIE_BACK');

1967: p_return_status := fnd_api.g_ret_sts_unexp_error;
1968:
1969: WHEN OTHERS THEN
1970: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1971: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_TIE_BACK');
1972: p_return_status := fnd_api.g_ret_sts_unexp_error;
1973: END;
1974:
1975: ------------------ CREATE BALANCING TRANSACTIONS FOR GL ------------------------------

Line 2183: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_BALANCE_TRANSACTION');

2179: EXCEPTION
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2182: -- Included the following line for bug fix 1765678
2183: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_BALANCE_TRANSACTION');
2184: p_return_status := fnd_api.g_ret_sts_unexp_error;
2185:
2186: WHEN OTHERS THEN
2187: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;

Line 2188: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_BALANCE_TRANSACTION');

2184: p_return_status := fnd_api.g_ret_sts_unexp_error;
2185:
2186: WHEN OTHERS THEN
2187: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2188: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GL_BALANCE_TRANSACTION');
2189: p_return_status := fnd_api.g_ret_sts_unexp_error;
2190: END;
2191:
2192: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------

Line 2356: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','INSERT_INTO_GL_INTERFACE');

2352: p_return_status := fnd_api.g_ret_sts_success;
2353: EXCEPTION
2354: WHEN OTHERS THEN
2355: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2356: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','INSERT_INTO_GL_INTERFACE');
2357: p_return_status := fnd_api.g_ret_sts_unexp_error;
2358: END;
2359:
2360: -------------------- CREATE GMS SUM LINES -----------------------------------------------

Line 2806: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GMS_SUM_LINES');

2802:
2803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2804: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
2805: -- Included the following code for bug fix 1765678
2806: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GMS_SUM_LINES');
2807: p_return_status := fnd_api.g_ret_sts_unexp_error;
2808: WHEN OTHERS THEN
2809: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
2810: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GMS_SUM_LINES');

Line 2810: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GMS_SUM_LINES');

2806: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GMS_SUM_LINES');
2807: p_return_status := fnd_api.g_ret_sts_unexp_error;
2808: WHEN OTHERS THEN
2809: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
2810: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CREATE_GMS_SUM_LINES');
2811: p_return_status := fnd_api.g_ret_sts_unexp_error;
2812:
2813: END;
2814:

Line 3694: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GMS_INTERFACE');

3690: EXCEPTION
3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3692: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
3693: --Bug 1776606 : Building error Stack
3694: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GMS_INTERFACE');
3695: p_return_status := fnd_api.g_ret_sts_unexp_error;
3696:
3697: WHEN OTHERS THEN
3698: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;

Line 3699: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GMS_INTERFACE');

3695: p_return_status := fnd_api.g_ret_sts_unexp_error;
3696:
3697: WHEN OTHERS THEN
3698: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
3699: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','TRANSFER_TO_GMS_INTERFACE');
3700: p_return_status := fnd_api.g_ret_sts_unexp_error;
3701: END;
3702:
3703: ------------------------- GMS TIE BACK ---------------------------------------------------

Line 4025: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GET_PROCESS');

4021: exception
4022: when others then
4023: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' exception = '||sqlerrm);
4024:
4025: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GET_PROCESS');
4026: return FALSE;
4027: end PROCESS_COMPLETE;
4028:
4029: BEGIN

Line 4288: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GMS_TIE_BACK');

4284: p_return_status := fnd_api.g_ret_sts_success;
4285: EXCEPTION
4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4287: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
4288: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GMS_TIE_BACK');
4289: p_return_status := fnd_api.g_ret_sts_unexp_error;
4290:
4291: WHEN TI_DID_NOT_COMPLETE THEN
4292: g_error_api_path := 'GMS_TIE_BACK:' || 'Transaction Import did not complete for some batches';

Line 4298: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GMS_TIE_BACK');

4294: p_return_status := fnd_api.g_ret_sts_unexp_error;
4295:
4296: WHEN OTHERS THEN
4297: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
4298: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GMS_TIE_BACK');
4299: p_return_status := fnd_api.g_ret_sts_unexp_error;
4300: END;
4301:
4302: ------------------ INSERT INTO GMS INTERFACE -----------------------------------------------

Line 4426: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','INSERT_INTO_PA_INTERFACE');

4422:
4423: EXCEPTION
4424: WHEN OTHERS THEN
4425: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
4426: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','INSERT_INTO_PA_INTERFACE');
4427: p_return_status := fnd_api.g_ret_sts_unexp_error;
4428: END;
4429:
4430: --------------------------------------- CLEANUP BATCH DETAILS --------------------------

Line 4654: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CLEANUP_BATCH_DETAILS');

4650:
4651: EXCEPTION
4652: WHEN OTHERS THEN
4653: g_error_api_path := 'CLEANUP_BATCH_DETAILS:'||g_error_api_path;
4654: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','CLEANUP_BATCH_DETAILS');
4655: END;
4656: -------------------------------------
4657: PROCEDURE check_interface_status(p_target_name IN VARCHAR2,
4658: p_adj_sum_batch_name IN VARCHAR2) IS

Line 4978: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GET_THE_BATCH_DETAILS');

4974: when others then
4975: --Bug :1776606 : Building error stack
4976: fnd_message.set_token('BATCH_NAME',l_error||'Unexpected Oracle error occured ORA -'||sqlcode);
4977: fnd_msg_pub.add;
4978: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','GET_THE_BATCH_DETAILS');
4979: -- Included the following line for bug fix 1765678
4980: p_return_status := fnd_api.g_ret_sts_unexp_error;
4981: raise;
4982: -- Bug 1776606 : Commented the following line

Line 5004: END PSP_SUM_ADJ;

5000: P_MSG);
5001: END;
5002: */
5003:
5004: END PSP_SUM_ADJ;