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_MESSAGE

Line 330: fnd_message.set_name('PSP','PSP_GB_NAME_EXISTS');

326: END IF;
327: CLOSE batch_name_exist_cur;
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;

Line 331: fnd_message.set_token('GB_NAME', p_adj_sum_batch_name);

327: CLOSE batch_name_exist_cur;
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:

Line 340: fnd_message.set_name('PSP', 'PSP_NO_BATCHES_EXIST');

336: open pc_batch_cur;
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

Line 351: fnd_message.set_name('PSP','PSP_GB_NAME');

347: end if;
348:
349: l_batch_details_failed := FALSE;
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:

Line 352: fnd_message.set_token('GB_NAME',p_adj_sum_batch_name);

348:
349: l_batch_details_failed := FALSE;
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

Line 1385: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

1381: CLOSE employee_name_cur;
1382: -- End of bug fix 1828519
1383: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1384: l_table := 'PER_TIME_PERIODS';
1385: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

Line 1386: fnd_message.set_token('VALUE',l_value);

1382: -- End of bug fix 1828519
1383: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1384: l_table := 'PER_TIME_PERIODS';
1385: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 1387: fnd_message.set_token('TABLE',l_table);

1383: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1384: l_table := 'PER_TIME_PERIODS';
1385: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

Line 1388: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519

1384: l_table := 'PER_TIME_PERIODS';
1385: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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');

Line 1389: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519

1385: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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');

Line 1392: -- fnd_message.set_name('PSP', 'PSP_ADJ_GL_FAILED');

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);
1395: -- fnd_msg_pub.add;
1396: cleanup_batch_details(gl_batch_rec.payroll_control_id,null);

Line 1393: -- fnd_message.set_token('ERR_NAME', 'TIME PERIOD NOT FOUND');

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);
1395: -- fnd_msg_pub.add;
1396: cleanup_batch_details(gl_batch_rec.payroll_control_id,null);
1397: -- l_batch_cnt := l_batch_cnt - 1;

Line 1523: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');

1519: g_enable_enc_summ_gl, -- Introduced as part of bug 2259310
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

Line 1540: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');

1536: commit;
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;

Line 1583: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');

1579: IF (user_je_source_name%NOTFOUND) THEN
1580: CLOSE user_je_source_name;
1581: l_error := 'JE SOURCES = OLD';
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;

Line 1584: fnd_message.set_token('ERROR',l_error);

1580: CLOSE user_je_source_name;
1581: l_error := 'JE SOURCES = OLD';
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;

Line 1585: fnd_message.set_token('PRODUCT',l_product);

1581: l_error := 'JE SOURCES = OLD';
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;

Line 1596: -- fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');

1592: WHEN NO_DATA_FOUND THEN
1593: -- Obsoleted the following code as it gets handled by the new code inserted above for bug fix 1765678
1594: -- l_error := 'JE SOURCES = OLD';
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;

Line 1597: -- fnd_message.set_token('ERROR',l_error);

1593: -- Obsoleted the following code as it gets handled by the new code inserted above for bug fix 1765678
1594: -- l_error := 'JE SOURCES = OLD';
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');

Line 1598: -- fnd_message.set_token('PRODUCT',l_product);

1594: -- l_error := 'JE SOURCES = OLD';
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;

Line 1626: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');

1622: IF (gl_je_category_cur%NOTFOUND) THEN
1623: CLOSE gl_je_category_cur;
1624: l_error := 'JE CATEGORY = OLD';
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;

Line 1627: fnd_message.set_token('ERROR',l_error);

1623: CLOSE gl_je_category_cur;
1624: l_error := 'JE CATEGORY = OLD';
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;

Line 1628: fnd_message.set_token('PRODUCT',l_product);

1624: l_error := 'JE CATEGORY = OLD';
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;

Line 1640: -- fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');

1636: WHEN NO_DATA_FOUND THEN
1637: -- Obsoleted the following code as the exception is handled in the cursor%NOTFOUND area for bug fix 1765678
1638: -- l_error := 'JE CATEGORY = OLD';
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;

Line 1641: -- fnd_message.set_token('ERROR',l_error);

1637: -- Obsoleted the following code as the exception is handled in the cursor%NOTFOUND area for bug fix 1765678
1638: -- l_error := 'JE CATEGORY = OLD';
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

Line 1642: -- fnd_message.set_token('PRODUCT',l_product);

1638: -- l_error := 'JE CATEGORY = OLD';
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;

Line 1830: fnd_message.set_name('PSP', 'PSP_TR_GL_IMP_FAILED');

1826:
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;

Line 1867: fnd_message.set_name('PSP','PSP_ADJ_GL_FAILED');

1863:
1864: IF l_cnt_gl_interface > 0 THEN
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

Line 2075: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');

2071: OPEN reversing_gl_ccid_cur;
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;

Line 3028: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');

3024: IF (transaction_source_cur%NOTFOUND) THEN
3025: CLOSE transaction_source_cur;
3026: l_error := 'TRANSACTION SOURCE = OLD';
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;

Line 3029: fnd_message.set_token('ERROR',l_error);

3025: CLOSE transaction_source_cur;
3026: l_error := 'TRANSACTION SOURCE = OLD';
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;

Line 3030: fnd_message.set_token('PRODUCT',l_product);

3026: l_error := 'TRANSACTION SOURCE = OLD';
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;

Line 3047: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');

3043: IF (site_transaction_source_cur%NOTFOUND) THEN
3044: CLOSE site_transaction_source_cur;
3045: l_error := 'TRANSACTION SOURCE = OLD';
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;

Line 3048: fnd_message.set_token('ERROR',l_error);

3044: CLOSE site_transaction_source_cur;
3045: l_error := 'TRANSACTION SOURCE = OLD';
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;

Line 3049: fnd_message.set_token('PRODUCT',l_product);

3045: l_error := 'TRANSACTION SOURCE = OLD';
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;

Line 3134: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

3130: CLOSE employee_name_cur;
3131: -- End of bug fix 1828519
3132: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3133: l_table := 'PER_TIME_PERIODS';
3134: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

Line 3135: fnd_message.set_token('VALUE',l_value);

3131: -- End of bug fix 1828519
3132: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3133: l_table := 'PER_TIME_PERIODS';
3134: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3136: fnd_message.set_token('TABLE',l_table);

3132: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3133: l_table := 'PER_TIME_PERIODS';
3134: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

Line 3137: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519

3133: l_table := 'PER_TIME_PERIODS';
3134: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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);

Line 3138: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519

3134: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3183: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

3179: l_table := 'PER_PEOPLE_F';
3180: -- Included the following code for bug fix 1828519
3181: l_person_name := 'PERSON ID NOT FOUND';
3182: -- End of bug fix 1828519
3183: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

Line 3184: fnd_message.set_token('VALUE',l_value);

3180: -- Included the following code for bug fix 1828519
3181: l_person_name := 'PERSON ID NOT FOUND';
3182: -- End of bug fix 1828519
3183: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3185: fnd_message.set_token('TABLE',l_table);

3181: l_person_name := 'PERSON ID NOT FOUND';
3182: -- End of bug fix 1828519
3183: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3186: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); --Included for bug fix 1828519

3182: -- End of bug fix 1828519
3183: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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);

Line 3187: fnd_message.set_token('PERSON_NAME',l_person_name); --Included for bug fix 1828519

3183: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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:

Line 3193: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');

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
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);

Line 3194: -- fnd_message.set_token('ERR_NAME', 'PERSON ID NOT FOUND');

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
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;

Line 3217: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

3213: CLOSE employee_name_cur;
3214: -- End of bug fix 1828519
3215: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3216: l_table := 'HR_ORGANIZATION_UNITS';
3217: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

Line 3218: fnd_message.set_token('VALUE',l_value);

3214: -- End of bug fix 1828519
3215: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3216: l_table := 'HR_ORGANIZATION_UNITS';
3217: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3219: fnd_message.set_token('TABLE',l_table);

3215: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3216: l_table := 'HR_ORGANIZATION_UNITS';
3217: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3220: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519

3216: l_table := 'HR_ORGANIZATION_UNITS';
3217: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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);

Line 3221: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519

3217: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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:

Line 3227: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');

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
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);

Line 3228: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');

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
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;

Line 3251: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

3247: CLOSE employee_name_cur;
3248: -- End of bug fix 1828519
3249: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3250: l_table := 'PA_PROJECTS_ALL';
3251: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

Line 3252: fnd_message.set_token('VALUE',l_value);

3248: -- End of bug fix 1828519
3249: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3250: l_table := 'PA_PROJECTS_ALL';
3251: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3253: fnd_message.set_token('TABLE',l_table);

3249: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3250: l_table := 'PA_PROJECTS_ALL';
3251: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3254: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519

3250: l_table := 'PA_PROJECTS_ALL';
3251: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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);

Line 3255: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519

3251: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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:

Line 3261: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');

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
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);

Line 3262: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');

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
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;

Line 3285: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');

3281: CLOSE employee_name_cur;
3282: -- End of bug fix 1828519
3283: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3284: l_table := 'PA_TASKS';
3285: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

Line 3286: fnd_message.set_token('VALUE',l_value);

3282: -- End of bug fix 1828519
3283: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3284: l_table := 'PA_TASKS';
3285: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3287: fnd_message.set_token('TABLE',l_table);

3283: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3284: l_table := 'PA_TASKS';
3285: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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;

Line 3288: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519

3284: l_table := 'PA_TASKS';
3285: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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);

Line 3289: fnd_message.set_token('PERSON_NAME',l_person_name); -- Included for bug fix 1828519

3285: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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:

Line 3295: -- fnd_message.set_name('PSP', 'PSP_ADJ_GMS_FAILED');

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
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);

Line 3296: -- fnd_message.set_token('ERR_NAME', 'ORGANIZATION NOT FOUND');

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
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;

Line 3527: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');

3523: l_txn_source, ----l_transaction_source,
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;

Line 3576: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');

3572: call_status_tab(i) := fnd_concurrent.wait_for_request(req_id_tab(i), 20, 0,
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;

Line 3626: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');

3622: l_txn_source, ----l_transaction_source,
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;

Line 3670: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');

3666: call_status_tab(i) := fnd_concurrent.wait_for_request(req_id_tab(i), 20, 0,
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;

Line 4110: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');

4106:
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

Line 4145: fnd_message.set_name('PSP','PSP_ADJ_GMS_FAILED');

4141:
4142: -- l_trx_rejection_code := l_trx_reject_code;
4143: -- END LOOP;
4144:
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;

Line 4147: -- fnd_message.set_token('ERR_NAME', l_trx_rejection_code);

4143: -- END LOOP;
4144:
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

Line 4830: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_COMPLETE');

4826: CLOSE pa_txn_int_status_i_cur;
4827:
4828: if l_status_i > 0 then
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;

Line 4831: fnd_message.set_token('PAYROLL_CONTROL_ID',payroll_control_rec.payroll_control_id);

4827:
4828: if l_status_i > 0 then
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:

Line 4832: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);

4828: if l_status_i > 0 then
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;

Line 4950: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);

4946: */
4947:
4948: l_error := 'Batch : ' || p_batch_name || ' Setting Tokens ' ;
4949:
4950: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4951: fnd_message.set_token('PERSON_NAME',l_person_name);
4952: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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));

Line 4951: fnd_message.set_token('PERSON_NAME',l_person_name);

4947:
4948: l_error := 'Batch : ' || p_batch_name || ' Setting Tokens ' ;
4949:
4950: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4951: fnd_message.set_token('PERSON_NAME',l_person_name);
4952: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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));

Line 4952: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);

4948: l_error := 'Batch : ' || p_batch_name || ' Setting Tokens ' ;
4949:
4950: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4951: fnd_message.set_token('PERSON_NAME',l_person_name);
4952: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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

Line 4953: --- fnd_message.set_token('ELEMENT_TYPE',l_element_name); commented for 2634557 DA Multiple element Enh

4949:
4950: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4951: fnd_message.set_token('PERSON_NAME',l_person_name);
4952: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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;

Line 4954: fnd_message.set_token('DISTRIBUTION_START_DATE', to_char(l_distribution_start_date));

4950: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4951: fnd_message.set_token('PERSON_NAME',l_person_name);
4952: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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:

Line 4955: fnd_message.set_token('DISTRIBUTION_END_DATE', to_char(l_distribution_end_date));

4951: fnd_message.set_token('PERSON_NAME',l_person_name);
4952: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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;

Line 4956: fnd_message.set_token('CURRENCY_CODE', l_currency_code); -- Introduced for bug fix 2916848

4952: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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:

Line 4964: fnd_message.set_token('BATCH_NAME', l_error || ' No data found');

4960:
4961: exception
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

Line 4970: fnd_message.set_token('BATCH_NAME', l_error || ' Too many rows');

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');
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

Line 4976: fnd_message.set_token('BATCH_NAME',l_error||'Unexpected Oracle error occured ORA -'||sqlcode);

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);
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;