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 FND_MSG_PUB

Line 60: fnd_msg_pub.initialize;

56:
57: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Begin Adj S&T');
58:
59: g_error_api_path := '';
60: fnd_msg_pub.initialize;
61: psp_general.TRANSACTION_CHANGE_PURGEBLE;
62:
63: -- g_currency_code := psp_general.get_currency_code(p_business_group_id); -- Added for Bug 2478000 commented for bug fix 2916848
64:

Line 92: fnd_msg_pub.initialize;

88:
89: psp_message_s.print_error(p_mode => FND_FILE.LOG,
90: p_print_header => FND_API.G_FALSE);
91:
92: fnd_msg_pub.initialize;
93:
94: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' Calling create_gms_sum_lines for p_adj_sum_batch_name: '||p_adj_sum_batch_name);
95:
96: create_gms_sum_lines(p_adj_sum_batch_name,

Line 215: if fnd_msg_pub.Count_Msg > 0 then

211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214:
215: if fnd_msg_pub.Count_Msg > 0 then
216: psp_message_s.print_error(p_mode => FND_FILE.LOG,
217: p_print_header => FND_API.G_FALSE);
218: else
219: PSP_MESSAGE_S.Print_success;

Line 332: fnd_msg_pub.add;

328:
329: if l_batch_name_exists > 0 then
330: fnd_message.set_name('PSP','PSP_GB_NAME_EXISTS');
331: fnd_message.set_token('GB_NAME', p_adj_sum_batch_name);
332: fnd_msg_pub.add;
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: end if;
335:
336: open pc_batch_cur;

Line 341: fnd_msg_pub.add;

337: loop
338: fetch pc_batch_cur into pc_batch_rec;
339: if pc_batch_cur%ROWCOUNT = 0 then
340: fnd_message.set_name('PSP', 'PSP_NO_BATCHES_EXIST');
341: fnd_msg_pub.add;
342: close pc_batch_cur;
343: exit;
344: elsif pc_batch_cur%NOTFOUND then
345: close pc_batch_cur;

Line 354: fnd_msg_pub.add;

350: l_batch_cnt := l_batch_cnt + 1;
351: fnd_message.set_name('PSP','PSP_GB_NAME');
352: fnd_message.set_token('GB_NAME',p_adj_sum_batch_name);
353: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
354: fnd_msg_pub.add;
355:
356: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
357: l_batch_details_failed := TRUE;
358: ELSE

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 1390: fnd_msg_pub.add;

1386: fnd_message.set_token('VALUE',l_value);
1387: fnd_message.set_token('TABLE',l_table);
1388: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
1389: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
1390: fnd_msg_pub.add;
1391: -- Commented the following message for bug fix 1828519
1392: -- fnd_message.set_name('PSP', 'PSP_ADJ_GL_FAILED');
1393: -- fnd_message.set_token('ERR_NAME', 'TIME PERIOD NOT FOUND');
1394: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);

Line 1395: -- fnd_msg_pub.add;

1391: -- Commented the following message for bug fix 1828519
1392: -- fnd_message.set_name('PSP', 'PSP_ADJ_GL_FAILED');
1393: -- fnd_message.set_token('ERR_NAME', 'TIME PERIOD NOT FOUND');
1394: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
1395: -- fnd_msg_pub.add;
1396: cleanup_batch_details(gl_batch_rec.payroll_control_id,null);
1397: -- l_batch_cnt := l_batch_cnt - 1;
1398: close gl_batch_cursor;
1399: exit;

Line 1524: fnd_msg_pub.add;

1520: 'W'); -- changed 'N' to 'W' for bug fix 2908859
1521:
1522: IF req_id = 0 THEN
1523: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');
1524: fnd_msg_pub.add;
1525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1526: ELSE
1527: update psp_payroll_controls
1528: set gl_phase = 'Submitted_Import_Request'

Line 1541: fnd_msg_pub.add;

1537: call_status := fnd_concurrent.wait_for_request(req_id, 20, 0, rphase, rstatus,
1538: dphase, dstatus, message);
1539: if call_status = FALSE then
1540: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');
1541: fnd_msg_pub.add;
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: end if;
1544: END IF;
1545: END IF;

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 1586: fnd_msg_pub.add;

1582: l_product := 'GL';
1583: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1584: fnd_message.set_token('ERROR',l_error);
1585: fnd_message.set_token('PRODUCT',l_product);
1586: fnd_msg_pub.add;
1587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1588: END IF;
1589: CLOSE user_je_source_name;
1590:

Line 1599: -- fnd_msg_pub.add;

1595: -- l_product := 'GL';
1596: -- fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
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

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 1629: fnd_msg_pub.add;

1625: l_product := 'GL';
1626: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1627: fnd_message.set_token('ERROR',l_error);
1628: fnd_message.set_token('PRODUCT',l_product);
1629: fnd_msg_pub.add;
1630: p_return_status := fnd_api.g_ret_sts_unexp_error;
1631: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1632: END IF;
1633: CLOSE gl_je_category_cur;

Line 1643: -- fnd_msg_pub.add;

1639: -- l_product := 'GL';
1640: -- fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1641: -- fnd_message.set_token('ERROR',l_error);
1642: -- fnd_message.set_token('PRODUCT',l_product);
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');

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 1831: fnd_msg_pub.add;

1827:
1828: commit;
1829:
1830: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');
1831: fnd_msg_pub.add;
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833:
1834: end if;
1835:

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 1869: fnd_msg_pub.add;

1865:
1866:
1867: fnd_message.set_name('PSP','PSP_ADJ_GL_FAILED');
1868: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
1869: fnd_msg_pub.add;
1870:
1871: cleanup_batch_details(gl_tie_back_rec.payroll_control_id,l_group_id); -- added group id for 2133056
1872: -- Commented the following as cursor is not at all used
1873: -- Uncommented the following code as the code would fail if more than one GL batch fails along bug fix 1828519

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 2076: fnd_msg_pub.add;

2072: FETCH reversing_gl_ccid_cur INTO l_clrg_account_glccid;
2073: IF (reversing_gl_ccid_cur%NOTFOUND) THEN
2074: CLOSE reversing_gl_ccid_cur;
2075: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');
2076: fnd_msg_pub.add;
2077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2078: END IF;
2079: CLOSE reversing_gl_ccid_cur;
2080: END;

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 3031: fnd_msg_pub.add;

3027: l_product := 'GMS';
3028: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3029: fnd_message.set_token('ERROR',l_error);
3030: fnd_message.set_token('PRODUCT',l_product);
3031: fnd_msg_pub.add;
3032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3033: END IF;
3034: CLOSE transaction_source_cur;
3035:

Line 3050: fnd_msg_pub.add;

3046: l_product := 'GMS';
3047: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3048: fnd_message.set_token('ERROR',l_error);
3049: fnd_message.set_token('PRODUCT',l_product);
3050: fnd_msg_pub.add;
3051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3052: END IF;
3053: CLOSE site_transaction_source_cur;
3054: END;

Line 3139: fnd_msg_pub.add;

3135: fnd_message.set_token('VALUE',l_value);
3136: fnd_message.set_token('TABLE',l_table);
3137: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
3138: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
3139: fnd_msg_pub.add;
3140: -- Commented the following code for bug fix 1828519
3141: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3142: -- fnd_msg_pub.add;
3143: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);

Line 3142: -- fnd_msg_pub.add;

3138: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
3139: fnd_msg_pub.add;
3140: -- Commented the following code for bug fix 1828519
3141: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3142: -- fnd_msg_pub.add;
3143: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3144: close gms_batch_cursor;
3145: l_batch_cnt := l_batch_cnt - 1;
3146: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' l_batch_cnt 2 : '||l_batch_cnt);

Line 3188: fnd_msg_pub.add;

3184: fnd_message.set_token('VALUE',l_value);
3185: fnd_message.set_token('TABLE',l_table);
3186: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); --Included for bug fix 1828519
3187: fnd_message.set_token('PERSON_NAME',l_person_name); --Included for bug fix 1828519
3188: fnd_msg_pub.add;
3189: l_batch_cnt := l_batch_cnt - 1;
3190: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' l_batch_cnt 3 : '||l_batch_cnt);
3191:
3192: -- Commented the following message as part of bug fix 1828519

Line 3196: -- fnd_msg_pub.add;

3192: -- Commented the following message as part of bug fix 1828519
3193: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3194: -- fnd_message.set_token('ERR_NAME', 'PERSON ID NOT FOUND');
3195: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3196: -- fnd_msg_pub.add;
3197: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3198: close gms_interface_cursor;
3199: exit;
3200: END IF;

Line 3222: fnd_msg_pub.add;

3218: fnd_message.set_token('VALUE',l_value);
3219: fnd_message.set_token('TABLE',l_table);
3220: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
3221: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
3222: fnd_msg_pub.add;
3223: l_batch_cnt := l_batch_cnt - 1;
3224: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' l_batch_cnt 4 : '||l_batch_cnt);
3225:
3226: -- Commented the following message as part of bug fix 1828519

Line 3230: -- fnd_msg_pub.add;

3226: -- Commented the following message as part of bug fix 1828519
3227: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3228: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');
3229: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3230: -- fnd_msg_pub.add;
3231: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3232: close gms_interface_cursor;
3233: exit;
3234: END IF;

Line 3256: fnd_msg_pub.add;

3252: fnd_message.set_token('VALUE',l_value);
3253: fnd_message.set_token('TABLE',l_table);
3254: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
3255: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
3256: fnd_msg_pub.add;
3257: l_batch_cnt := l_batch_cnt - 1;
3258: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' l_batch_cnt 5 : '||l_batch_cnt);
3259:
3260: -- Commented the following message as part of bug fix 1828519

Line 3264: -- fnd_msg_pub.add;

3260: -- Commented the following message as part of bug fix 1828519
3261: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3262: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');
3263: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3264: -- fnd_msg_pub.add;
3265: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3266: close gms_interface_cursor;
3267: exit;
3268: END IF;

Line 3290: fnd_msg_pub.add;

3286: fnd_message.set_token('VALUE',l_value);
3287: fnd_message.set_token('TABLE',l_table);
3288: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
3289: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
3290: fnd_msg_pub.add;
3291: l_batch_cnt := l_batch_cnt - 1;
3292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' l_batch_cnt 6 : '||l_batch_cnt);
3293:
3294: -- Commented the following message as part of bug fix 1828519

Line 3298: -- fnd_msg_pub.add;

3294: -- Commented the following message as part of bug fix 1828519
3295: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3296: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');
3297: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3298: -- fnd_msg_pub.add;
3299: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3300: close gms_interface_cursor;
3301: exit;
3302: END IF;

Line 3528: fnd_msg_pub.add;

3524: l_gms_batch_name);
3525:
3526: IF req_id = 0 THEN
3527: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3528: fnd_msg_pub.add;
3529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3530:
3531: END IF;
3532: END LOOP;

Line 3577: fnd_msg_pub.add;

3573: rphase, rstatus, dphase, dstatus, message);
3574:
3575: IF call_status = FALSE then
3576: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3577: fnd_msg_pub.add;
3578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3579:
3580: END IF;
3581: END LOOP;

Line 3627: fnd_msg_pub.add;

3623: l_gms_batch_name);
3624:
3625: IF req_id = 0 THEN
3626: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3627: fnd_msg_pub.add;
3628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3629:
3630: END IF;
3631: END LOOP;

Line 3671: fnd_msg_pub.add;

3667: rphase, rstatus, dphase, dstatus, message);
3668:
3669: IF call_status = FALSE then
3670: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3671: fnd_msg_pub.add;
3672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3673:
3674: END IF;
3675: END LOOP;

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 4111: fnd_msg_pub.add;

4107: if NOT PROCESS_COMPLETE then
4108:
4109: ----- changed message tag for bug 2133056
4110: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4111: fnd_msg_pub.add;
4112: close gms_tie_back_cur;
4113: CLOSE gms_batch_name_cur;
4114: RAISE TI_DID_NOT_COMPLETE; --- Added this for Bug 2133056
4115:

Line 4149: fnd_msg_pub.add;

4145: fnd_message.set_name('PSP','PSP_ADJ_GMS_FAILED');
4146: -- Commented the following token as part of bug fix 1828519
4147: -- fnd_message.set_token('ERR_NAME', l_trx_rejection_code);
4148: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
4149: fnd_msg_pub.add;
4150: /* 1685685 added update statement...to clean pa tables in cleanup_batch_details..Venkat.*/
4151: update psp_payroll_controls
4152: set gms_phase = 'GMS_Tie_Back'
4153: where payroll_control_id = gms_tie_back_rec.payroll_control_id;

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 4293: fnd_msg_pub.add_exc_msg('PSP_ST_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';
4293: fnd_msg_pub.add_exc_msg('PSP_ST_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;

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 4833: fnd_msg_pub.add;

4829: l_no_complete := l_no_complete + 1;
4830: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_COMPLETE');
4831: fnd_message.set_token('PAYROLL_CONTROL_ID',payroll_control_rec.payroll_control_id);
4832: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
4833: fnd_msg_pub.add;
4834: end if;
4835:
4836: end if;
4837: end loop;

Line 4845: fnd_msg_pub.add_exc_msg('PSP_ST_ADJ', 'CHECK_INTERFACE_STATUS');

4841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4842: end if;
4843: exception
4844: when others then
4845: fnd_msg_pub.add_exc_msg('PSP_ST_ADJ', 'CHECK_INTERFACE_STATUS');
4846: end CHECK_INTERFACE_STATUS;
4847: -----------------------------------Get the Batch Details --------------------------------
4848: PROCEDURE get_the_batch_details(p_batch_name IN VARCHAR2,
4849: p_return_status OUT NOCOPY VARCHAR2) IS

Line 4957: fnd_msg_pub.add;

4953: --- fnd_message.set_token('ELEMENT_TYPE',l_element_name); commented for 2634557 DA Multiple element Enh
4954: fnd_message.set_token('DISTRIBUTION_START_DATE', to_char(l_distribution_start_date));
4955: fnd_message.set_token('DISTRIBUTION_END_DATE', to_char(l_distribution_end_date));
4956: fnd_message.set_token('CURRENCY_CODE', l_currency_code); -- Introduced for bug fix 2916848
4957: fnd_msg_pub.add;
4958:
4959: p_return_status := fnd_api.g_ret_sts_success;
4960:
4961: exception

Line 4966: fnd_msg_pub.add;

4962: when no_data_found then
4963: -- raise_application_error(-20001, l_error || ' No Data Found');
4964: fnd_message.set_token('BATCH_NAME', l_error || ' No data found');
4965: -- Included the following line for bug fix 1765678
4966: fnd_msg_pub.add;
4967: p_return_status := fnd_api.g_ret_sts_unexp_error;
4968: when too_many_rows then
4969: -- raise_application_error(-20001, l_error || ' ' || sqlerrm);
4970: fnd_message.set_token('BATCH_NAME', l_error || ' Too many rows');

Line 4972: fnd_msg_pub.add;

4968: when too_many_rows then
4969: -- raise_application_error(-20001, l_error || ' ' || sqlerrm);
4970: fnd_message.set_token('BATCH_NAME', l_error || ' Too many rows');
4971: -- Included the following line for bug fix 1765678
4972: fnd_msg_pub.add;
4973: p_return_status := fnd_api.g_ret_sts_unexp_error;
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);

Line 4977: fnd_msg_pub.add;

4973: p_return_status := fnd_api.g_ret_sts_unexp_error;
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;

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