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 31: fnd_msg_pub.initialize;

27:
28: BEGIN
29:
30: g_error_api_path := '';
31: fnd_msg_pub.initialize;
32: psp_general.TRANSACTION_CHANGE_PURGEBLE;
33:
34: -- g_currency_code := psp_general.get_currency_code(p_business_group_id); -- Added for Bug 2478000 commented for bug fix 2916848
35:

Line 53: fnd_msg_pub.initialize;

49:
50: psp_message_s.print_error(p_mode => FND_FILE.LOG,
51: p_print_header => FND_API.G_FALSE);
52:
53: fnd_msg_pub.initialize;
54:
55: create_gms_sum_lines(p_adj_sum_batch_name,
56: p_business_group_id,
57: p_set_of_books_id,

Line 157: if fnd_msg_pub.Count_Msg > 0 then

153: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157: if fnd_msg_pub.Count_Msg > 0 then
158: psp_message_s.print_error(p_mode => FND_FILE.LOG,
159: p_print_header => FND_API.G_FALSE);
160: else
161: PSP_MESSAGE_S.Print_success;

Line 272: fnd_msg_pub.add;

268:
269: if l_batch_name_exists > 0 then
270: fnd_message.set_name('PSP','PSP_GB_NAME_EXISTS');
271: fnd_message.set_token('GB_NAME', p_adj_sum_batch_name);
272: fnd_msg_pub.add;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: end if;
275:
276: open pc_batch_cur;

Line 281: fnd_msg_pub.add;

277: loop
278: fetch pc_batch_cur into pc_batch_rec;
279: if pc_batch_cur%ROWCOUNT = 0 then
280: fnd_message.set_name('PSP', 'PSP_NO_BATCHES_EXIST');
281: fnd_msg_pub.add;
282: close pc_batch_cur;
283: exit;
284: elsif pc_batch_cur%NOTFOUND then
285: close pc_batch_cur;

Line 294: fnd_msg_pub.add;

290: l_batch_cnt := l_batch_cnt + 1;
291: fnd_message.set_name('PSP','PSP_GB_NAME');
292: fnd_message.set_token('GB_NAME',p_adj_sum_batch_name);
293: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
294: fnd_msg_pub.add;
295:
296: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: l_batch_details_failed := TRUE;
298: ELSE

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

334: p_return_status := fnd_api.g_ret_sts_success;
335: --Included as part of Bug fix #1776606
336: EXCEPTION
337: WHEN OTHERS THEN
338: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','MARK_BATCH_BEGIN');
339: raise;
340: END;
341: -------------------- MARK BATCH END ---------------------------------------------
342:

Line 504: -- FND_MSG_PUB.ADD_EXC_MSG('PSP_SUM_TRANS', SQLERRM);

500:
501: EXCEPTION
502: WHEN OTHERS THEN
503: -- Bug 1776606 : Modifying the message to be displayed
504: -- FND_MSG_PUB.ADD_EXC_MSG('PSP_SUM_TRANS', SQLERRM);
505: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','MARK_BATCH_END');
506: raise;
507: END;
508:

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

501: EXCEPTION
502: WHEN OTHERS THEN
503: -- Bug 1776606 : Modifying the message to be displayed
504: -- FND_MSG_PUB.ADD_EXC_MSG('PSP_SUM_TRANS', SQLERRM);
505: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','MARK_BATCH_END');
506: raise;
507: END;
508:
509:

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

923: EXCEPTION
924:
925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
926: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
927: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
928: p_return_status := fnd_api.g_ret_sts_unexp_error;
929: WHEN OTHERS THEN
930: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
931: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');

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

927: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
928: p_return_status := fnd_api.g_ret_sts_unexp_error;
929: WHEN OTHERS THEN
930: g_error_api_path := 'CREATE_GL_SUM_LINES:'||g_error_api_path;
931: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GL_SUM_LINES');
932: p_return_status := fnd_api.g_ret_sts_unexp_error;
933:
934: END;
935:

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

1079: p_return_status := fnd_api.g_ret_sts_success;
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: g_error_api_path := 'INSERT_INTO_SUMMARY_LINES:'||g_error_api_path;
1083: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_SUMMARY_LINES');
1084: p_return_status := fnd_api.g_ret_sts_unexp_error;
1085: END;
1086:
1087: ------------------------ GL INTERFACE --------------------------------------------------

Line 1294: fnd_msg_pub.add;

1290: fnd_message.set_token('VALUE',l_value);
1291: fnd_message.set_token('TABLE',l_table);
1292: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
1293: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
1294: fnd_msg_pub.add;
1295: -- Commented the following message for bug fix 1828519
1296: -- fnd_message.set_name('PSP', 'PSP_ADJ_GL_FAILED');
1297: -- fnd_message.set_token('ERR_NAME', 'TIME PERIOD NOT FOUND');
1298: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);

Line 1299: -- fnd_msg_pub.add;

1295: -- Commented the following message for bug fix 1828519
1296: -- fnd_message.set_name('PSP', 'PSP_ADJ_GL_FAILED');
1297: -- fnd_message.set_token('ERR_NAME', 'TIME PERIOD NOT FOUND');
1298: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
1299: -- fnd_msg_pub.add;
1300: cleanup_batch_details(gl_batch_rec.payroll_control_id,null);
1301: -- l_batch_cnt := l_batch_cnt - 1;
1302: close gl_batch_cursor;
1303: exit;

Line 1419: fnd_msg_pub.add;

1415: 'W'); -- changed 'N' to 'W' for bug fix 2908859
1416:
1417: IF req_id = 0 THEN
1418: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');
1419: fnd_msg_pub.add;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: ELSE
1422: update psp_payroll_controls
1423: set gl_phase = 'Submitted_Import_Request'

Line 1434: fnd_msg_pub.add;

1430: call_status := fnd_concurrent.wait_for_request(req_id, 20, 0, rphase, rstatus,
1431: dphase, dstatus, message);
1432: if call_status = FALSE then
1433: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');
1434: fnd_msg_pub.add;
1435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1436: end if;
1437: END IF;
1438: END IF;

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

1441: p_return_status := fnd_api.g_ret_sts_success;
1442: EXCEPTION
1443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1444: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1445: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1446: p_return_status := fnd_api.g_ret_sts_unexp_error;
1447:
1448: WHEN RETURN_BACK THEN
1449: p_return_status := fnd_api.g_ret_sts_success;

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

1449: p_return_status := fnd_api.g_ret_sts_success;
1450:
1451: WHEN OTHERS THEN
1452: g_error_api_path := 'TRANSFER_TO_GL_INTERFACE:'||g_error_api_path;
1453: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GL_INTERFACE');
1454: p_return_status := fnd_api.g_ret_sts_unexp_error;
1455: END;
1456:
1457: ---------------------- GET_GL_JE_SOURCES --------------------------------------------------

Line 1479: fnd_msg_pub.add;

1475: l_product := 'GL';
1476: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1477: fnd_message.set_token('ERROR',l_error);
1478: fnd_message.set_token('PRODUCT',l_product);
1479: fnd_msg_pub.add;
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;
1482: CLOSE user_je_source_name;
1483:

Line 1492: -- fnd_msg_pub.add;

1488: -- l_product := 'GL';
1489: -- fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1490: -- fnd_message.set_token('ERROR',l_error);
1491: -- fnd_message.set_token('PRODUCT',l_product);
1492: -- fnd_msg_pub.add;
1493: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1494: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1495: p_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS THEN

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

1490: -- fnd_message.set_token('ERROR',l_error);
1491: -- fnd_message.set_token('PRODUCT',l_product);
1492: -- fnd_msg_pub.add;
1493: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1494: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1495: p_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS THEN
1497: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1498: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');

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

1494: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1495: p_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS THEN
1497: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;
1498: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_SOURCES');
1499: p_return_status := fnd_api.g_ret_sts_unexp_error;
1500: END;
1501:
1502: ---------------------- GET_GL_CATEGORIES --------------------------------------------------

Line 1522: fnd_msg_pub.add;

1518: l_product := 'GL';
1519: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1520: fnd_message.set_token('ERROR',l_error);
1521: fnd_message.set_token('PRODUCT',l_product);
1522: fnd_msg_pub.add;
1523: p_return_status := fnd_api.g_ret_sts_unexp_error;
1524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1525: END IF;
1526: CLOSE gl_je_category_cur;

Line 1536: -- fnd_msg_pub.add;

1532: -- l_product := 'GL';
1533: -- fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1534: -- fnd_message.set_token('ERROR',l_error);
1535: -- fnd_message.set_token('PRODUCT',l_product);
1536: -- fnd_msg_pub.add;
1537: p_return_status := fnd_api.g_ret_sts_unexp_error;
1538: WHEN OTHERS THEN
1539: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1540: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');

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

1536: -- fnd_msg_pub.add;
1537: p_return_status := fnd_api.g_ret_sts_unexp_error;
1538: WHEN OTHERS THEN
1539: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;
1540: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_JE_CATEGORY_NAME');
1541: p_return_status := fnd_api.g_ret_sts_unexp_error;
1542: END;
1543:
1544: -------------------- GL TIE BACK -----------------------------------------------------

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

1678: FETCH summary_group_cur INTO l_group_id;
1679: IF (summary_group_cur%NOTFOUND) THEN
1680: CLOSE summary_group_cur;
1681: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1682: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
1683: p_return_status := fnd_api.g_ret_sts_unexp_error;
1684: EXIT;
1685: END IF;
1686: CLOSE summary_group_cur;

Line 1715: fnd_msg_pub.add;

1711:
1712: commit;
1713:
1714: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');
1715: fnd_msg_pub.add;
1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1717:
1718: end if;
1719:

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

1736: FETCH gl_interface_group_cur INTO l_cnt_gl_interface;
1737: IF (gl_interface_group_cur%NOTFOUND) THEN
1738: CLOSE gl_interface_group_cur;
1739: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1740: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
1741: p_return_status := fnd_api.g_ret_sts_unexp_error;
1742: EXIT;
1743: END IF;
1744: CLOSE gl_interface_group_cur;

Line 1751: fnd_msg_pub.add;

1747:
1748:
1749: fnd_message.set_name('PSP','PSP_ADJ_GL_FAILED');
1750: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
1751: fnd_msg_pub.add;
1752:
1753: cleanup_batch_details(gl_tie_back_rec.payroll_control_id,l_group_id); -- added group id for 2133056
1754: -- Commented the following as cursor is not at all used
1755: -- Uncommented the following code as the code would fail if more than one GL batch fails along bug fix 1828519

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

1838:
1839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1840: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1841: -- Included the following for bug fix 1765678
1842: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
1843: p_return_status := fnd_api.g_ret_sts_unexp_error;
1844:
1845: WHEN OTHERS THEN
1846: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;

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

1843: p_return_status := fnd_api.g_ret_sts_unexp_error;
1844:
1845: WHEN OTHERS THEN
1846: g_error_api_path := 'GL_TIE_BACK:'||g_error_api_path;
1847: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_TIE_BACK');
1848: p_return_status := fnd_api.g_ret_sts_unexp_error;
1849: END;
1850:
1851: ------------------ CREATE BALANCING TRANSACTIONS FOR GL ------------------------------

Line 1952: fnd_msg_pub.add;

1948: FETCH reversing_gl_ccid_cur INTO l_clrg_account_glccid;
1949: IF (reversing_gl_ccid_cur%NOTFOUND) THEN
1950: CLOSE reversing_gl_ccid_cur;
1951: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');
1952: fnd_msg_pub.add;
1953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1954: END IF;
1955: CLOSE reversing_gl_ccid_cur;
1956: END;

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

2055: EXCEPTION
2056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2057: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2058: -- Included the following line for bug fix 1765678
2059: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2060: p_return_status := fnd_api.g_ret_sts_unexp_error;
2061:
2062: WHEN OTHERS THEN
2063: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;

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

2060: p_return_status := fnd_api.g_ret_sts_unexp_error;
2061:
2062: WHEN OTHERS THEN
2063: g_error_api_path := 'GL_BALANCE_TRANSACTION:'||g_error_api_path;
2064: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GL_BALANCE_TRANSACTION');
2065: p_return_status := fnd_api.g_ret_sts_unexp_error;
2066: END;
2067:
2068: ------------------ INSERT INTO GL INTERFACE -----------------------------------------------

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

2228: p_return_status := fnd_api.g_ret_sts_success;
2229: EXCEPTION
2230: WHEN OTHERS THEN
2231: g_error_api_path := 'INSERT_INTO_GL_INTERFACE:'||g_error_api_path;
2232: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','INSERT_INTO_GL_INTERFACE');
2233: p_return_status := fnd_api.g_ret_sts_unexp_error;
2234: END;
2235:
2236: -------------------- CREATE GMS SUM LINES -----------------------------------------------

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

2665:
2666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2667: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
2668: -- Included the following code for bug fix 1765678
2669: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
2670: p_return_status := fnd_api.g_ret_sts_unexp_error;
2671: WHEN OTHERS THEN
2672: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
2673: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');

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

2669: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
2670: p_return_status := fnd_api.g_ret_sts_unexp_error;
2671: WHEN OTHERS THEN
2672: g_error_api_path := 'CREATE_GMS_SUM_LINES:'||g_error_api_path;
2673: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CREATE_GMS_SUM_LINES');
2674: p_return_status := fnd_api.g_ret_sts_unexp_error;
2675:
2676: END;
2677:

Line 2885: fnd_msg_pub.add;

2881: l_product := 'GMS';
2882: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2883: fnd_message.set_token('ERROR',l_error);
2884: fnd_message.set_token('PRODUCT',l_product);
2885: fnd_msg_pub.add;
2886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2887: END IF;
2888: CLOSE transaction_source_cur;
2889:

Line 2904: fnd_msg_pub.add;

2900: l_product := 'GMS';
2901: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2902: fnd_message.set_token('ERROR',l_error);
2903: fnd_message.set_token('PRODUCT',l_product);
2904: fnd_msg_pub.add;
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2906: END IF;
2907: CLOSE site_transaction_source_cur;
2908: END;

Line 2987: fnd_msg_pub.add;

2983: fnd_message.set_token('VALUE',l_value);
2984: fnd_message.set_token('TABLE',l_table);
2985: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
2986: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
2987: fnd_msg_pub.add;
2988: -- Commented the following code for bug fix 1828519
2989: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
2990: -- fnd_msg_pub.add;
2991: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);

Line 2990: -- fnd_msg_pub.add;

2986: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
2987: fnd_msg_pub.add;
2988: -- Commented the following code for bug fix 1828519
2989: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
2990: -- fnd_msg_pub.add;
2991: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
2992: close gms_batch_cursor;
2993: l_batch_cnt := l_batch_cnt - 1;
2994: exit;

Line 3032: fnd_msg_pub.add;

3028: fnd_message.set_token('VALUE',l_value);
3029: fnd_message.set_token('TABLE',l_table);
3030: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); --Included for bug fix 1828519
3031: fnd_message.set_token('PERSON_NAME',l_person_name); --Included for bug fix 1828519
3032: fnd_msg_pub.add;
3033: l_batch_cnt := l_batch_cnt - 1;
3034: -- Commented the following message as part of bug fix 1828519
3035: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3036: -- fnd_message.set_token('ERR_NAME', 'PERSON ID NOT FOUND');

Line 3038: -- fnd_msg_pub.add;

3034: -- Commented the following message as part of bug fix 1828519
3035: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3036: -- fnd_message.set_token('ERR_NAME', 'PERSON ID NOT FOUND');
3037: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3038: -- fnd_msg_pub.add;
3039: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3040: close gms_interface_cursor;
3041: exit;
3042: END IF;

Line 3064: fnd_msg_pub.add;

3060: fnd_message.set_token('VALUE',l_value);
3061: fnd_message.set_token('TABLE',l_table);
3062: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
3063: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
3064: fnd_msg_pub.add;
3065: l_batch_cnt := l_batch_cnt - 1;
3066: -- Commented the following message as part of bug fix 1828519
3067: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3068: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');

Line 3070: -- fnd_msg_pub.add;

3066: -- Commented the following message as part of bug fix 1828519
3067: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3068: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');
3069: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3070: -- fnd_msg_pub.add;
3071: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3072: close gms_interface_cursor;
3073: exit;
3074: END IF;

Line 3096: fnd_msg_pub.add;

3092: fnd_message.set_token('VALUE',l_value);
3093: fnd_message.set_token('TABLE',l_table);
3094: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
3095: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
3096: fnd_msg_pub.add;
3097: l_batch_cnt := l_batch_cnt - 1;
3098: -- Commented the following message as part of bug fix 1828519
3099: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3100: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');

Line 3102: -- fnd_msg_pub.add;

3098: -- Commented the following message as part of bug fix 1828519
3099: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3100: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');
3101: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3102: -- fnd_msg_pub.add;
3103: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3104: close gms_interface_cursor;
3105: exit;
3106: END IF;

Line 3128: fnd_msg_pub.add;

3124: fnd_message.set_token('VALUE',l_value);
3125: fnd_message.set_token('TABLE',l_table);
3126: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519
3127: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519
3128: fnd_msg_pub.add;
3129: l_batch_cnt := l_batch_cnt - 1;
3130: -- Commented the following message as part of bug fix 1828519
3131: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3132: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');

Line 3134: -- fnd_msg_pub.add;

3130: -- Commented the following message as part of bug fix 1828519
3131: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');
3132: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');
3133: -- get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3134: -- fnd_msg_pub.add;
3135: cleanup_batch_details(gms_batch_rec.payroll_control_id,null);
3136: close gms_interface_cursor;
3137: exit;
3138: END IF;

Line 3281: fnd_msg_pub.add;

3277: l_gms_batch_name);
3278:
3279: IF req_id = 0 THEN
3280: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3281: fnd_msg_pub.add;
3282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3283:
3284: -- ELSE
3285: /***** Converted the following statement into BULK FETCH for R12 performance fixes (bug 4507892)

Line 3324: fnd_msg_pub.add;

3320: rphase, rstatus, dphase, dstatus, message);
3321:
3322: IF call_status = FALSE then
3323: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3324: fnd_msg_pub.add;
3325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3326:
3327: END IF;
3328: END LOOP;

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

3332: EXCEPTION
3333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3334: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
3335: --Bug 1776606 : Building error Stack
3336: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
3337: p_return_status := fnd_api.g_ret_sts_unexp_error;
3338:
3339: WHEN OTHERS THEN
3340: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;

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

3337: p_return_status := fnd_api.g_ret_sts_unexp_error;
3338:
3339: WHEN OTHERS THEN
3340: g_error_api_path := 'TRANSFER_TO_GMS_INTERFACE:'||g_error_api_path;
3341: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','TRANSFER_TO_GMS_INTERFACE');
3342: p_return_status := fnd_api.g_ret_sts_unexp_error;
3343: END;
3344:
3345: ------------------------- GMS TIE BACK ---------------------------------------------------

Line 3637: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_PROCESS');

3633: end loop;
3634:
3635: exception
3636: when others then
3637: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_PROCESS');
3638: return FALSE;
3639: end PROCESS_COMPLETE;
3640:
3641: BEGIN

Line 3702: fnd_msg_pub.add;

3698: if NOT PROCESS_COMPLETE then
3699:
3700: ----- changed message tag for bug 2133056
3701: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3702: fnd_msg_pub.add;
3703: close gms_tie_back_cur;
3704: CLOSE gms_batch_name_cur;
3705: RAISE TI_DID_NOT_COMPLETE; --- Added this for Bug 2133056
3706:

Line 3738: fnd_msg_pub.add;

3734: fnd_message.set_name('PSP','PSP_ADJ_GMS_FAILED');
3735: -- Commented the following token as part of bug fix 1828519
3736: -- fnd_message.set_token('ERR_NAME', l_trx_rejection_code);
3737: get_the_batch_details(pc_batch_rec.batch_name, l_return_status);
3738: fnd_msg_pub.add;
3739: /* 1685685 added update statement...to clean pa tables in cleanup_batch_details..Venkat.*/
3740: update psp_payroll_controls
3741: set gms_phase = 'GMS_Tie_Back'
3742: where payroll_control_id = gms_tie_back_rec.payroll_control_id;

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

3856: p_return_status := fnd_api.g_ret_sts_success;
3857: EXCEPTION
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
3860: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
3861: p_return_status := fnd_api.g_ret_sts_unexp_error;
3862:
3863: WHEN TI_DID_NOT_COMPLETE THEN
3864: g_error_api_path := 'GMS_TIE_BACK:' || 'Transaction Import did not complete for some batches';

Line 3865: fnd_msg_pub.add_exc_msg('PSP_ST_ADJ', 'GMS_TIE_BACK');

3861: p_return_status := fnd_api.g_ret_sts_unexp_error;
3862:
3863: WHEN TI_DID_NOT_COMPLETE THEN
3864: g_error_api_path := 'GMS_TIE_BACK:' || 'Transaction Import did not complete for some batches';
3865: fnd_msg_pub.add_exc_msg('PSP_ST_ADJ', 'GMS_TIE_BACK');
3866: p_return_status := fnd_api.g_ret_sts_unexp_error;
3867:
3868: WHEN OTHERS THEN
3869: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;

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

3866: p_return_status := fnd_api.g_ret_sts_unexp_error;
3867:
3868: WHEN OTHERS THEN
3869: g_error_api_path := 'GMS_TIE_BACK:'||g_error_api_path;
3870: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GMS_TIE_BACK');
3871: p_return_status := fnd_api.g_ret_sts_unexp_error;
3872: END;
3873:
3874: ------------------ INSERT INTO GMS INTERFACE -----------------------------------------------

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

3991:
3992: EXCEPTION
3993: WHEN OTHERS THEN
3994: g_error_api_path := 'INSERT_INTO_PA_INTERFACE:'||g_error_api_path;
3995: fnd_msg_pub.add_exc_msg('PSP_SUM_ADJ','INSERT_INTO_PA_INTERFACE');
3996: p_return_status := fnd_api.g_ret_sts_unexp_error;
3997: END;
3998:
3999: --------------------------------------- CLEANUP BATCH DETAILS --------------------------

Line 4223: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CLEANUP_BATCH_DETAILS');

4219:
4220: EXCEPTION
4221: WHEN OTHERS THEN
4222: g_error_api_path := 'CLEANUP_BATCH_DETAILS:'||g_error_api_path;
4223: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','CLEANUP_BATCH_DETAILS');
4224: END;
4225: -------------------------------------
4226: PROCEDURE check_interface_status(p_target_name IN VARCHAR2,
4227: p_adj_sum_batch_name IN VARCHAR2) IS

Line 4402: fnd_msg_pub.add;

4398: l_no_complete := l_no_complete + 1;
4399: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_COMPLETE');
4400: fnd_message.set_token('PAYROLL_CONTROL_ID',payroll_control_rec.payroll_control_id);
4401: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
4402: fnd_msg_pub.add;
4403: end if;
4404:
4405: end if;
4406: end loop;

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

4410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4411: end if;
4412: exception
4413: when others then
4414: fnd_msg_pub.add_exc_msg('PSP_ST_ADJ', 'CHECK_INTERFACE_STATUS');
4415: end CHECK_INTERFACE_STATUS;
4416: -----------------------------------Get the Batch Details --------------------------------
4417: PROCEDURE get_the_batch_details(p_batch_name IN VARCHAR2,
4418: p_return_status OUT NOCOPY VARCHAR2) IS

Line 4526: fnd_msg_pub.add;

4522: --- fnd_message.set_token('ELEMENT_TYPE',l_element_name); commented for 2634557 DA Multiple element Enh
4523: fnd_message.set_token('DISTRIBUTION_START_DATE', to_char(l_distribution_start_date));
4524: fnd_message.set_token('DISTRIBUTION_END_DATE', to_char(l_distribution_end_date));
4525: fnd_message.set_token('CURRENCY_CODE', l_currency_code); -- Introduced for bug fix 2916848
4526: fnd_msg_pub.add;
4527:
4528: p_return_status := fnd_api.g_ret_sts_success;
4529:
4530: exception

Line 4535: fnd_msg_pub.add;

4531: when no_data_found then
4532: -- raise_application_error(-20001, l_error || ' No Data Found');
4533: fnd_message.set_token('BATCH_NAME', l_error || ' No data found');
4534: -- Included the following line for bug fix 1765678
4535: fnd_msg_pub.add;
4536: p_return_status := fnd_api.g_ret_sts_unexp_error;
4537: when too_many_rows then
4538: -- raise_application_error(-20001, l_error || ' ' || sqlerrm);
4539: fnd_message.set_token('BATCH_NAME', l_error || ' Too many rows');

Line 4541: fnd_msg_pub.add;

4537: when too_many_rows then
4538: -- raise_application_error(-20001, l_error || ' ' || sqlerrm);
4539: fnd_message.set_token('BATCH_NAME', l_error || ' Too many rows');
4540: -- Included the following line for bug fix 1765678
4541: fnd_msg_pub.add;
4542: p_return_status := fnd_api.g_ret_sts_unexp_error;
4543: when others then
4544: --Bug :1776606 : Building error stack
4545: fnd_message.set_token('BATCH_NAME',l_error||'Unexpected Oracle error occured ORA -'||sqlcode);

Line 4546: fnd_msg_pub.add;

4542: p_return_status := fnd_api.g_ret_sts_unexp_error;
4543: when others then
4544: --Bug :1776606 : Building error stack
4545: fnd_message.set_token('BATCH_NAME',l_error||'Unexpected Oracle error occured ORA -'||sqlcode);
4546: fnd_msg_pub.add;
4547: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_THE_BATCH_DETAILS');
4548: -- Included the following line for bug fix 1765678
4549: p_return_status := fnd_api.g_ret_sts_unexp_error;
4550: raise;

Line 4547: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_THE_BATCH_DETAILS');

4543: when others then
4544: --Bug :1776606 : Building error stack
4545: fnd_message.set_token('BATCH_NAME',l_error||'Unexpected Oracle error occured ORA -'||sqlcode);
4546: fnd_msg_pub.add;
4547: fnd_msg_pub.add_exc_msg('PSP_SUM_TRANS','GET_THE_BATCH_DETAILS');
4548: -- Included the following line for bug fix 1765678
4549: p_return_status := fnd_api.g_ret_sts_unexp_error;
4550: raise;
4551: -- Bug 1776606 : Commented the following line