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

266: END IF;
267: CLOSE batch_name_exist_cur;
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;

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

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

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

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

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

287: end if;
288:
289: l_batch_details_failed := FALSE;
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:

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

288:
289: l_batch_details_failed := FALSE;
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

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

1285: CLOSE employee_name_cur;
1286: -- End of bug fix 1828519
1287: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1288: l_table := 'PER_TIME_PERIODS';
1289: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

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

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

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

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

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

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

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

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

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

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

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

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);
1299: -- fnd_msg_pub.add;
1300: cleanup_batch_details(gl_batch_rec.payroll_control_id,null);
1301: -- l_batch_cnt := l_batch_cnt - 1;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1710: and je_source_name = 'OLD';
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;

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

1745:
1746: IF l_cnt_gl_interface > 0 THEN
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2978: CLOSE employee_name_cur;
2979: -- End of bug fix 1828519
2980: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
2981: l_table := 'PER_TIME_PERIODS';
2982: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

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

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

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

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

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

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

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

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

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

3023: l_table := 'PER_PEOPLE_F';
3024: -- Included the following code for bug fix 1828519
3025: l_person_name := 'PERSON ID NOT FOUND';
3026: -- End of bug fix 1828519
3027: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

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

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

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

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

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

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

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

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

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

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

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

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

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

3055: CLOSE employee_name_cur;
3056: -- End of bug fix 1828519
3057: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3058: l_table := 'HR_ORGANIZATION_UNITS';
3059: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

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

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

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

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

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

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

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

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

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

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

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

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

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

3087: CLOSE employee_name_cur;
3088: -- End of bug fix 1828519
3089: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3090: l_table := 'PA_PROJECTS_ALL';
3091: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

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

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

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

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

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

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

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

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

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

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

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

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

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

3119: CLOSE employee_name_cur;
3120: -- End of bug fix 1828519
3121: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3122: l_table := 'PA_TASKS';
3123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3730:
3731: -- l_trx_rejection_code := l_trx_reject_code;
3732: -- END LOOP;
3733:
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;

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

3732: -- END LOOP;
3733:
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

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

4395: CLOSE pa_txn_int_status_i_cur;
4396:
4397: if l_status_i > 0 then
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;

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

4396:
4397: if l_status_i > 0 then
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:

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

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

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

4515: */
4516:
4517: l_error := 'Batch : ' || p_batch_name || ' Setting Tokens ' ;
4518:
4519: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4520: fnd_message.set_token('PERSON_NAME',l_person_name);
4521: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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));

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

4516:
4517: l_error := 'Batch : ' || p_batch_name || ' Setting Tokens ' ;
4518:
4519: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4520: fnd_message.set_token('PERSON_NAME',l_person_name);
4521: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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));

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

4517: l_error := 'Batch : ' || p_batch_name || ' Setting Tokens ' ;
4518:
4519: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4520: fnd_message.set_token('PERSON_NAME',l_person_name);
4521: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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

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

4518:
4519: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4520: fnd_message.set_token('PERSON_NAME',l_person_name);
4521: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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;

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

4519: fnd_message.set_token('BATCH_NAME',l_adjustment_batch_name);
4520: fnd_message.set_token('PERSON_NAME',l_person_name);
4521: fnd_message.set_token('ASSIGNMENT_NUMBER',l_assignment_number);
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:

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

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

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

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

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

4529:
4530: exception
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

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

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

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

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