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_TRANS dependencies on FND_MESSAGE

Line 435: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');

431: and batch_name = to_char(l_gms_batch_name)
432: and transaction_source in ('GOLD', 'OLD');
433:
434: if (l_ti_not_complete > 0) then
435: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
436: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
437: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
438: fnd_msg_pub.add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

432: and transaction_source in ('GOLD', 'OLD');
433:
434: if (l_ti_not_complete > 0) then
435: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
436: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
437: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
438: fnd_msg_pub.add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: end if;

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

433:
434: if (l_ti_not_complete > 0) then
435: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
436: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
437: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
438: fnd_msg_pub.add;
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: end if;
441:

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

853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN
855: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
856: l_table := 'PER_TIME_PERIODS';
857: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
858: fnd_message.set_token('VALUE',l_value);
859: fnd_message.set_token('TABLE',l_table);
860: fnd_msg_pub.add;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

854: WHEN NO_DATA_FOUND THEN
855: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
856: l_table := 'PER_TIME_PERIODS';
857: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
858: fnd_message.set_token('VALUE',l_value);
859: fnd_message.set_token('TABLE',l_table);
860: fnd_msg_pub.add;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END;

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

855: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
856: l_table := 'PER_TIME_PERIODS';
857: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
858: fnd_message.set_token('VALUE',l_value);
859: fnd_message.set_token('TABLE',l_table);
860: fnd_msg_pub.add;
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862: END;
863:

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

1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
1450: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1451: l_table := 'PER_TIME_PERIODS';
1452: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1453: fnd_message.set_token('VALUE',l_value);
1454: fnd_message.set_token('TABLE',l_table);
1455: fnd_msg_pub.add;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1449: WHEN NO_DATA_FOUND THEN
1450: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1451: l_table := 'PER_TIME_PERIODS';
1452: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1453: fnd_message.set_token('VALUE',l_value);
1454: fnd_message.set_token('TABLE',l_table);
1455: fnd_msg_pub.add;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;

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

1450: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1451: l_table := 'PER_TIME_PERIODS';
1452: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1453: fnd_message.set_token('VALUE',l_value);
1454: fnd_message.set_token('TABLE',l_table);
1455: fnd_msg_pub.add;
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END;
1458:

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

1615: );
1616:
1617: IF req_id = 0 THEN
1618:
1619: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1620: fnd_msg_pub.add;
1621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1622:
1623: ELSE

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

1643: rphase, rstatus, dphase, dstatus, message);
1644:
1645: IF call_status = FALSE THEN
1646:
1647: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1648: fnd_msg_pub.add;
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650:
1651: END IF;

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

1729: EXCEPTION
1730: WHEN NO_DATA_FOUND THEN
1731: l_error := 'JE SOURCES = OLD';
1732: l_product := 'GL';
1733: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1734: fnd_message.set_token('ERROR',l_error);
1735: fnd_message.set_token('PRODUCT',l_product);
1736: fnd_msg_pub.add;
1737: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

1730: WHEN NO_DATA_FOUND THEN
1731: l_error := 'JE SOURCES = OLD';
1732: l_product := 'GL';
1733: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1734: fnd_message.set_token('ERROR',l_error);
1735: fnd_message.set_token('PRODUCT',l_product);
1736: fnd_msg_pub.add;
1737: p_return_status := fnd_api.g_ret_sts_unexp_error;
1738: WHEN OTHERS THEN

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

1731: l_error := 'JE SOURCES = OLD';
1732: l_product := 'GL';
1733: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1734: fnd_message.set_token('ERROR',l_error);
1735: fnd_message.set_token('PRODUCT',l_product);
1736: fnd_msg_pub.add;
1737: p_return_status := fnd_api.g_ret_sts_unexp_error;
1738: WHEN OTHERS THEN
1739: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

1756: EXCEPTION
1757: WHEN NO_DATA_FOUND THEN
1758: l_error := 'JE CATEGORY = OLD';
1759: l_product := 'GL';
1760: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1761: fnd_message.set_token('ERROR',l_error);
1762: fnd_message.set_token('PRODUCT',l_product);
1763: fnd_msg_pub.add;
1764: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

1757: WHEN NO_DATA_FOUND THEN
1758: l_error := 'JE CATEGORY = OLD';
1759: l_product := 'GL';
1760: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1761: fnd_message.set_token('ERROR',l_error);
1762: fnd_message.set_token('PRODUCT',l_product);
1763: fnd_msg_pub.add;
1764: p_return_status := fnd_api.g_ret_sts_unexp_error;
1765: WHEN OTHERS THEN

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

1758: l_error := 'JE CATEGORY = OLD';
1759: l_product := 'GL';
1760: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1761: fnd_message.set_token('ERROR',l_error);
1762: fnd_message.set_token('PRODUCT',l_product);
1763: fnd_msg_pub.add;
1764: p_return_status := fnd_api.g_ret_sts_unexp_error;
1765: WHEN OTHERS THEN
1766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

1785: EXCEPTION
1786: WHEN NO_DATA_FOUND THEN
1787: l_error := 'ENCUMBRANCE TYPE = OLD';
1788: l_product := 'GL';
1789: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1790: fnd_message.set_token('ERROR',l_error);
1791: fnd_message.set_token('PRODUCT',l_product);
1792: fnd_msg_pub.add;
1793: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

1786: WHEN NO_DATA_FOUND THEN
1787: l_error := 'ENCUMBRANCE TYPE = OLD';
1788: l_product := 'GL';
1789: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1790: fnd_message.set_token('ERROR',l_error);
1791: fnd_message.set_token('PRODUCT',l_product);
1792: fnd_msg_pub.add;
1793: p_return_status := fnd_api.g_ret_sts_unexp_error;
1794: WHEN OTHERS THEN

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

1787: l_error := 'ENCUMBRANCE TYPE = OLD';
1788: l_product := 'GL';
1789: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1790: fnd_message.set_token('ERROR',l_error);
1791: fnd_message.set_token('PRODUCT',l_product);
1792: fnd_msg_pub.add;
1793: p_return_status := fnd_api.g_ret_sts_unexp_error;
1794: WHEN OTHERS THEN
1795: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 2083: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');

2079: --- bug 4328598--- fix end
2080: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Commit');
2081:
2082:
2083: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');
2084: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
2085: fnd_message.set_token('GROUP_ID',p_group_id);
2086: fnd_msg_pub.add;
2087: -- uncommented following statement for 2444657

Line 2084: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);

2080: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Commit');
2081:
2082:
2083: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');
2084: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
2085: fnd_message.set_token('GROUP_ID',p_group_id);
2086: fnd_msg_pub.add;
2087: -- uncommented following statement for 2444657
2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2085: fnd_message.set_token('GROUP_ID',p_group_id);

2081:
2082:
2083: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');
2084: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
2085: fnd_message.set_token('GROUP_ID',p_group_id);
2086: fnd_msg_pub.add;
2087: -- uncommented following statement for 2444657
2088: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2089:

Line 2300: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');

2296: l_award_id,
2297: l_expenditure_type,
2298: l_exp_org_id);
2299: end if;
2300: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2301: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2302: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2303: fnd_message.set_token('ASG_NUM',l_assignment_number);
2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

Line 2301: fnd_message.set_token('ORG_NAME',l_auto_org_name);

2297: l_expenditure_type,
2298: l_exp_org_id);
2299: end if;
2300: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2301: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2302: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2303: fnd_message.set_token('ASG_NUM',l_assignment_number);
2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2305: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

Line 2302: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);

2298: l_exp_org_id);
2299: end if;
2300: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2301: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2302: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2303: fnd_message.set_token('ASG_NUM',l_assignment_number);
2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2305: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2306: fnd_message.set_token('EFF_DATE',l_distribution_date);

Line 2303: fnd_message.set_token('ASG_NUM',l_assignment_number);

2299: end if;
2300: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2301: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2302: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2303: fnd_message.set_token('ASG_NUM',l_assignment_number);
2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2305: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2306: fnd_message.set_token('EFF_DATE',l_distribution_date);
2307: fnd_msg_pub.add;

Line 2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

2300: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2301: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2302: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2303: fnd_message.set_token('ASG_NUM',l_assignment_number);
2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2305: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2306: fnd_message.set_token('EFF_DATE',l_distribution_date);
2307: fnd_msg_pub.add;
2308: else

Line 2305: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

2301: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2302: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2303: fnd_message.set_token('ASG_NUM',l_assignment_number);
2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2305: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2306: fnd_message.set_token('EFF_DATE',l_distribution_date);
2307: fnd_msg_pub.add;
2308: else
2309: if l_acct_type = 'E' then

Line 2306: fnd_message.set_token('EFF_DATE',l_distribution_date);

2302: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2303: fnd_message.set_token('ASG_NUM',l_assignment_number);
2304: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2305: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2306: fnd_message.set_token('EFF_DATE',l_distribution_date);
2307: fnd_msg_pub.add;
2308: else
2309: if l_acct_type = 'E' then
2310: l_expenditure_type := l_new_expenditure_type;

Line 2396: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');

2392: AND payroll_control_id = p_payroll_control_id);
2393: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gl_interface count: '||sql%rowcount);
2394:
2395: IF l_reversal_ac_failed = 'Y' THEN
2396: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
2397: fnd_message.set_token('GLCCID',x_lines_glccid);
2398: fnd_msg_pub.add;
2399:
2400: /* Added the following for the Bug 3065866 */

Line 2397: fnd_message.set_token('GLCCID',x_lines_glccid);

2393: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' deleted from gl_interface count: '||sql%rowcount);
2394:
2395: IF l_reversal_ac_failed = 'Y' THEN
2396: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
2397: fnd_message.set_token('GLCCID',x_lines_glccid);
2398: fnd_msg_pub.add;
2399:
2400: /* Added the following for the Bug 3065866 */
2401:

Line 2460: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');

2456: --- above check for autopop error 5080403
2457: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_suspense_ac_failed = Y ');
2458:
2459: if nvl(l_suspense_ac_failed,'N') = 'Y' then
2460: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2461: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2462: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2463: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2464: fnd_msg_pub.add;

Line 2461: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);

2457: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_suspense_ac_failed = Y ');
2458:
2459: if nvl(l_suspense_ac_failed,'N') = 'Y' then
2460: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2461: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2462: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2463: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2464: fnd_msg_pub.add;
2465: end if;

Line 2462: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);

2458:
2459: if nvl(l_suspense_ac_failed,'N') = 'Y' then
2460: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2461: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2462: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2463: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2464: fnd_msg_pub.add;
2465: end if;
2466:

Line 2463: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);

2459: if nvl(l_suspense_ac_failed,'N') = 'Y' then
2460: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2461: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2462: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2463: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2464: fnd_msg_pub.add;
2465: end if;
2466:
2467: /* Added the following for Bug 3065866 */

Line 2526: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');

2522: IF l_suspense_ac_not_found = 'Y' THEN
2523: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_suspense_ac_not_found = Y ');
2524:
2525: /* commented following code for 2479579
2526: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
2527: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
2528: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
2529: fnd_msg_pub.add; */
2530:

Line 2527: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);

2523: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' l_suspense_ac_not_found = Y ');
2524:
2525: /* commented following code for 2479579
2526: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
2527: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
2528: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
2529: fnd_msg_pub.add; */
2530:
2531: /* Introduced the following check as part of Bug fix #1776606 */

Line 2528: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);

2524:
2525: /* commented following code for 2479579
2526: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
2527: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
2528: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
2529: fnd_msg_pub.add; */
2530:
2531: /* Introduced the following check as part of Bug fix #1776606 */
2532: if p_mode = 'N' then

Line 2700: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');

2696:
2697: /* Added Exceptions for bug 2056877 */
2698: WHEN NO_PROFILE_EXISTS THEN
2699: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2700: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2701: fnd_msg_pub.add;
2702: p_return_status := fnd_api.g_ret_sts_unexp_error;
2703:
2704: WHEN NO_VAL_DATE_MATCHES THEN

Line 2706: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

2702: p_return_status := fnd_api.g_ret_sts_unexp_error;
2703:
2704: WHEN NO_VAL_DATE_MATCHES THEN
2705: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2706: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2707: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2708: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2709: fnd_msg_pub.add;
2710: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2707: fnd_message.set_token('ORG_NAME',l_orig_org_name);

2703:
2704: WHEN NO_VAL_DATE_MATCHES THEN
2705: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2706: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2707: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2708: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2709: fnd_msg_pub.add;
2710: p_return_status := fnd_api.g_ret_sts_unexp_error;
2711:

Line 2708: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);

2704: WHEN NO_VAL_DATE_MATCHES THEN
2705: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2706: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2707: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2708: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2709: fnd_msg_pub.add;
2710: p_return_status := fnd_api.g_ret_sts_unexp_error;
2711:
2712: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 2714: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

2710: p_return_status := fnd_api.g_ret_sts_unexp_error;
2711:
2712: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2713: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2714: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2715: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2716: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2717: fnd_msg_pub.add;
2718: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.

Line 2715: fnd_message.set_token('ORG_NAME',l_orig_org_name);

2711:
2712: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2713: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2714: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2715: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2716: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2717: fnd_msg_pub.add;
2718: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2719:

Line 2716: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);

2712: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2713: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2714: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2715: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2716: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2717: fnd_msg_pub.add;
2718: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2719:
2720: WHEN OTHERS THEN

Line 2849: fnd_message.set_name('PSP','PSP_GL_REV_AMT_NOT_EQUAL');

2845: AND pdl.gl_project_flag = 'G'
2846: AND pdl.status_code = 'N';
2847:
2848: IF l_cr_amount <> l_dr_amount then
2849: fnd_message.set_name('PSP','PSP_GL_REV_AMT_NOT_EQUAL');
2850: fnd_msg_pub.add;
2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2852: END IF;
2853:

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

2864: AND business_group_id = p_business_group_id -- Changed for MO.
2865: AND payroll_id = l_payroll_id; -- Added for bug 5592964
2866: EXCEPTION
2867: WHEN NO_DATA_FOUND THEN
2868: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');
2869: fnd_msg_pub.add;
2870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2871: END;
2872:

Line 2926: fnd_message.set_name('PSP','PSP_GL_UNBALANCED_BATCH');

2922: and (ppgd.gl_code_combination_id is not null or (ppgd.suspense_org_account_id is not null
2923: and pos.gl_code_combination_id is not null)); */
2924:
2925: IF l_cr_amount <> l_dr_amount then
2926: fnd_message.set_name('PSP','PSP_GL_UNBALANCED_BATCH');
2927: fnd_msg_pub.add;
2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929: END IF;
2930:

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

3377: EXCEPTION
3378: WHEN NO_DATA_FOUND THEN
3379: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
3380: l_table := 'PER_TIME_PERIODS';
3381: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3382: fnd_message.set_token('VALUE',l_value);
3383: fnd_message.set_token('TABLE',l_table);
3384: fnd_msg_pub.add;
3385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3378: WHEN NO_DATA_FOUND THEN
3379: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
3380: l_table := 'PER_TIME_PERIODS';
3381: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3382: fnd_message.set_token('VALUE',l_value);
3383: fnd_message.set_token('TABLE',l_table);
3384: fnd_msg_pub.add;
3385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3386: END;

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

3379: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
3380: l_table := 'PER_TIME_PERIODS';
3381: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3382: fnd_message.set_token('VALUE',l_value);
3383: fnd_message.set_token('TABLE',l_table);
3384: fnd_msg_pub.add;
3385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3386: END;
3387:

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

3779: EXCEPTION
3780: WHEN NO_DATA_FOUND THEN
3781: l_error := 'TRANSACTION SOURCE = OLD';
3782: l_product := 'PA';
3783: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3784: fnd_message.set_token('ERROR',l_error);
3785: fnd_message.set_token('PRODUCT',l_product);
3786: fnd_msg_pub.add;
3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3780: WHEN NO_DATA_FOUND THEN
3781: l_error := 'TRANSACTION SOURCE = OLD';
3782: l_product := 'PA';
3783: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3784: fnd_message.set_token('ERROR',l_error);
3785: fnd_message.set_token('PRODUCT',l_product);
3786: fnd_msg_pub.add;
3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3788: END;

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

3781: l_error := 'TRANSACTION SOURCE = OLD';
3782: l_product := 'PA';
3783: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3784: fnd_message.set_token('ERROR',l_error);
3785: fnd_message.set_token('PRODUCT',l_product);
3786: fnd_msg_pub.add;
3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3788: END;
3789:

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

3796: EXCEPTION
3797: WHEN NO_DATA_FOUND THEN
3798: l_error := 'TRANSACTION SOURCE = GOLD';
3799: l_product := 'GMS';
3800: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3801: fnd_message.set_token('ERROR',l_error);
3802: fnd_message.set_token('PRODUCT',l_product);
3803: fnd_msg_pub.add;
3804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3797: WHEN NO_DATA_FOUND THEN
3798: l_error := 'TRANSACTION SOURCE = GOLD';
3799: l_product := 'GMS';
3800: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3801: fnd_message.set_token('ERROR',l_error);
3802: fnd_message.set_token('PRODUCT',l_product);
3803: fnd_msg_pub.add;
3804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3805: END;

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

3798: l_error := 'TRANSACTION SOURCE = GOLD';
3799: l_product := 'GMS';
3800: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3801: fnd_message.set_token('ERROR',l_error);
3802: fnd_message.set_token('PRODUCT',l_product);
3803: fnd_msg_pub.add;
3804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3805: END;
3806: end if;

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

3826: EXCEPTION
3827: WHEN NO_DATA_FOUND THEN
3828: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3829: l_table := 'PER_TIME_PERIODS';
3830: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3831: fnd_message.set_token('VALUE',l_value);
3832: fnd_message.set_token('TABLE',l_table);
3833: fnd_msg_pub.add;
3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3827: WHEN NO_DATA_FOUND THEN
3828: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3829: l_table := 'PER_TIME_PERIODS';
3830: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3831: fnd_message.set_token('VALUE',l_value);
3832: fnd_message.set_token('TABLE',l_table);
3833: fnd_msg_pub.add;
3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3835: END;

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

3828: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3829: l_table := 'PER_TIME_PERIODS';
3830: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3831: fnd_message.set_token('VALUE',l_value);
3832: fnd_message.set_token('TABLE',l_table);
3833: fnd_msg_pub.add;
3834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3835: END;
3836:

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

3901: EXCEPTION
3902: WHEN NO_DATA_FOUND THEN
3903: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3904: l_table := 'PER_PEOPLE_F';
3905: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3906: fnd_message.set_token('VALUE',l_value);
3907: fnd_message.set_token('TABLE',l_table);
3908: fnd_msg_pub.add;
3909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3902: WHEN NO_DATA_FOUND THEN
3903: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3904: l_table := 'PER_PEOPLE_F';
3905: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3906: fnd_message.set_token('VALUE',l_value);
3907: fnd_message.set_token('TABLE',l_table);
3908: fnd_msg_pub.add;
3909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3910: END;

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

3903: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3904: l_table := 'PER_PEOPLE_F';
3905: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3906: fnd_message.set_token('VALUE',l_value);
3907: fnd_message.set_token('TABLE',l_table);
3908: fnd_msg_pub.add;
3909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3910: END;
3911:

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

3919: EXCEPTION
3920: WHEN NO_DATA_FOUND THEN
3921: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3922: l_table := 'HR_ORGANIZATION_UNITS';
3923: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3924: fnd_message.set_token('VALUE',l_value);
3925: fnd_message.set_token('TABLE',l_table);
3926: fnd_msg_pub.add;
3927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3920: WHEN NO_DATA_FOUND THEN
3921: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3922: l_table := 'HR_ORGANIZATION_UNITS';
3923: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3924: fnd_message.set_token('VALUE',l_value);
3925: fnd_message.set_token('TABLE',l_table);
3926: fnd_msg_pub.add;
3927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3928: --l_org_name := NULL;

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

3921: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3922: l_table := 'HR_ORGANIZATION_UNITS';
3923: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3924: fnd_message.set_token('VALUE',l_value);
3925: fnd_message.set_token('TABLE',l_table);
3926: fnd_msg_pub.add;
3927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3928: --l_org_name := NULL;
3929: --l_org_name := 'LDM_ORG_NAME_INVALID';

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

3938: EXCEPTION
3939: WHEN NO_DATA_FOUND THEN
3940: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3941: l_table := 'PA_PROJECTS_ALL';
3942: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3943: fnd_message.set_token('VALUE',l_value);
3944: fnd_message.set_token('TABLE',l_table);
3945: fnd_msg_pub.add;
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3939: WHEN NO_DATA_FOUND THEN
3940: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3941: l_table := 'PA_PROJECTS_ALL';
3942: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3943: fnd_message.set_token('VALUE',l_value);
3944: fnd_message.set_token('TABLE',l_table);
3945: fnd_msg_pub.add;
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END;

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

3940: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3941: l_table := 'PA_PROJECTS_ALL';
3942: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3943: fnd_message.set_token('VALUE',l_value);
3944: fnd_message.set_token('TABLE',l_table);
3945: fnd_msg_pub.add;
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END;
3948:

Line 3961: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');

3957: EXCEPTION
3958: WHEN NO_DATA_FOUND THEN
3959: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3960: l_table := 'PA_PROJECTS_ALL';
3961: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3962: fnd_message.set_token('VALUE',l_value);
3963: fnd_message.set_token('TABLE',l_table);
3964: fnd_msg_pub.add;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3958: WHEN NO_DATA_FOUND THEN
3959: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3960: l_table := 'PA_PROJECTS_ALL';
3961: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3962: fnd_message.set_token('VALUE',l_value);
3963: fnd_message.set_token('TABLE',l_table);
3964: fnd_msg_pub.add;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3966: END;

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

3959: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3960: l_table := 'PA_PROJECTS_ALL';
3961: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3962: fnd_message.set_token('VALUE',l_value);
3963: fnd_message.set_token('TABLE',l_table);
3964: fnd_msg_pub.add;
3965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3966: END;
3967: */

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

3975: EXCEPTION
3976: WHEN NO_DATA_FOUND THEN
3977: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3978: l_table := 'PA_TASKS';
3979: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3980: fnd_message.set_token('VALUE',l_value);
3981: fnd_message.set_token('TABLE',l_table);
3982: fnd_msg_pub.add;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3976: WHEN NO_DATA_FOUND THEN
3977: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3978: l_table := 'PA_TASKS';
3979: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3980: fnd_message.set_token('VALUE',l_value);
3981: fnd_message.set_token('TABLE',l_table);
3982: fnd_msg_pub.add;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3984: END;

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

3977: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3978: l_table := 'PA_TASKS';
3979: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3980: fnd_message.set_token('VALUE',l_value);
3981: fnd_message.set_token('TABLE',l_table);
3982: fnd_msg_pub.add;
3983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3984: END;
3985:

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

4190: l_txn_source, -- should be l_txn_source rather than l_transaction_source,
4191: l_gms_batch_name);
4192:
4193: IF req_id = 0 THEN
4194: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4195: fnd_msg_pub.add;
4196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4197: END IF;
4198: END LOOP;

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

4213: LOOP
4214: call_status_tab(I) := fnd_concurrent.wait_for_request(req_id_tab(I), 20, 0,
4215: rphase, rstatus, dphase, dstatus, message);
4216: IF call_status_tab(I) = FALSE then
4217: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4218: fnd_msg_pub.add;
4219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4220: END IF;
4221: END LOOP;

Line 4630: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');

4626:
4627:
4628: if NOT PROCESS_COMPLETE then
4629: if (l_no_run_status = 'I') then
4630: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4631: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4632: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4633: fnd_msg_pub.add;
4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4631: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);

4627:
4628: if NOT PROCESS_COMPLETE then
4629: if (l_no_run_status = 'I') then
4630: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4631: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4632: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4633: fnd_msg_pub.add;
4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4635: end if;

Line 4632: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);

4628: if NOT PROCESS_COMPLETE then
4629: if (l_no_run_status = 'I') then
4630: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4631: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4632: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4633: fnd_msg_pub.add;
4634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4635: end if;
4636: end if;

Line 5035: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');

5031: l_award_id,
5032: l_new_expenditure_type,
5033: l_exp_org_id);
5034: end if;
5035: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
5036: fnd_message.set_token('ORG_NAME',l_auto_org_name);
5037: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
5038: fnd_message.set_token('ASG_NUM',l_assignment_number);
5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

Line 5036: fnd_message.set_token('ORG_NAME',l_auto_org_name);

5032: l_new_expenditure_type,
5033: l_exp_org_id);
5034: end if;
5035: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
5036: fnd_message.set_token('ORG_NAME',l_auto_org_name);
5037: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
5038: fnd_message.set_token('ASG_NUM',l_assignment_number);
5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
5040: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

Line 5037: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);

5033: l_exp_org_id);
5034: end if;
5035: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
5036: fnd_message.set_token('ORG_NAME',l_auto_org_name);
5037: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
5038: fnd_message.set_token('ASG_NUM',l_assignment_number);
5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
5040: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
5041: fnd_message.set_token('EFF_DATE',l_distribution_date);

Line 5038: fnd_message.set_token('ASG_NUM',l_assignment_number);

5034: end if;
5035: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
5036: fnd_message.set_token('ORG_NAME',l_auto_org_name);
5037: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
5038: fnd_message.set_token('ASG_NUM',l_assignment_number);
5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
5040: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
5041: fnd_message.set_token('EFF_DATE',l_distribution_date);
5042: fnd_msg_pub.add;

Line 5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

5035: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
5036: fnd_message.set_token('ORG_NAME',l_auto_org_name);
5037: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
5038: fnd_message.set_token('ASG_NUM',l_assignment_number);
5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
5040: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
5041: fnd_message.set_token('EFF_DATE',l_distribution_date);
5042: fnd_msg_pub.add;
5043: else

Line 5040: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

5036: fnd_message.set_token('ORG_NAME',l_auto_org_name);
5037: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
5038: fnd_message.set_token('ASG_NUM',l_assignment_number);
5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
5040: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
5041: fnd_message.set_token('EFF_DATE',l_distribution_date);
5042: fnd_msg_pub.add;
5043: else
5044: if l_acct_type = 'E' then

Line 5041: fnd_message.set_token('EFF_DATE',l_distribution_date);

5037: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
5038: fnd_message.set_token('ASG_NUM',l_assignment_number);
5039: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
5040: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
5041: fnd_message.set_token('EFF_DATE',l_distribution_date);
5042: fnd_msg_pub.add;
5043: else
5044: if l_acct_type = 'E' then
5045: l_expenditure_type := l_new_expenditure_type;

Line 5136: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');

5132: IF l_suspense_ac_failed = 'Y' or
5133: nvl(l_auto_status,'X') in ('AUTO_POP_NA_ERROR', 'AUTO_POP_EXP_ERROR', 'AUTO_POP_NO_VALUE') then
5134: --- above check for autopop error 5080403
5135: if nvl(l_suspense_ac_failed,'N') = 'Y' then
5136: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5137: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5138: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5139: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5140: fnd_msg_pub.add;

Line 5137: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);

5133: nvl(l_auto_status,'X') in ('AUTO_POP_NA_ERROR', 'AUTO_POP_EXP_ERROR', 'AUTO_POP_NO_VALUE') then
5134: --- above check for autopop error 5080403
5135: if nvl(l_suspense_ac_failed,'N') = 'Y' then
5136: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5137: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5138: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5139: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5140: fnd_msg_pub.add;
5141: end if;

Line 5138: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);

5134: --- above check for autopop error 5080403
5135: if nvl(l_suspense_ac_failed,'N') = 'Y' then
5136: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5137: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5138: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5139: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5140: fnd_msg_pub.add;
5141: end if;
5142:

Line 5139: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);

5135: if nvl(l_suspense_ac_failed,'N') = 'Y' then
5136: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5137: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5138: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5139: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5140: fnd_msg_pub.add;
5141: end if;
5142:
5143: /* Added this code for Bug 3065866 */

Line 5201: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');

5197: IF l_suspense_ac_not_found = 'Y' THEN
5198: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Suspence account not found');
5199:
5200: /* commented for 2479579
5201: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5202: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5203: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5204: fnd_msg_pub.add; */
5205:

Line 5202: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);

5198: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Suspence account not found');
5199:
5200: /* commented for 2479579
5201: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5202: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5203: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5204: fnd_msg_pub.add; */
5205:
5206: /* Added the following code for Bug 3065866 */

Line 5203: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);

5199:
5200: /* commented for 2479579
5201: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5202: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5203: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5204: fnd_msg_pub.add; */
5205:
5206: /* Added the following code for Bug 3065866 */
5207:

Line 5472: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');

5468: p_return_status := fnd_api.g_ret_sts_unexp_error;
5469: /* Added Exceptions for bug 2056877 */
5470: WHEN NO_PROFILE_EXISTS THEN
5471: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5472: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5473: fnd_msg_pub.add;
5474: p_return_status := fnd_api.g_ret_sts_unexp_error;
5475:
5476: WHEN NO_VAL_DATE_MATCHES THEN

Line 5478: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');

5474: p_return_status := fnd_api.g_ret_sts_unexp_error;
5475:
5476: WHEN NO_VAL_DATE_MATCHES THEN
5477: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5478: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5479: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5480: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5481: fnd_msg_pub.add;
5482: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5479: fnd_message.set_token('ORG_NAME',l_orig_org_name1);

5475:
5476: WHEN NO_VAL_DATE_MATCHES THEN
5477: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5478: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5479: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5480: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5481: fnd_msg_pub.add;
5482: p_return_status := fnd_api.g_ret_sts_unexp_error;
5483:

Line 5480: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);

5476: WHEN NO_VAL_DATE_MATCHES THEN
5477: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5478: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5479: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5480: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5481: fnd_msg_pub.add;
5482: p_return_status := fnd_api.g_ret_sts_unexp_error;
5483:
5484: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 5486: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');

5482: p_return_status := fnd_api.g_ret_sts_unexp_error;
5483:
5484: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5485: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5486: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5487: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5488: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5489: fnd_msg_pub.add;
5490: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.

Line 5487: fnd_message.set_token('ORG_NAME',l_orig_org_name1);

5483:
5484: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5485: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5486: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5487: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5488: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5489: fnd_msg_pub.add;
5490: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5491:

Line 5488: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);

5484: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5485: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5486: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5487: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5488: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5489: fnd_msg_pub.add;
5490: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5491:
5492: WHEN OTHERS THEN

Line 6698: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');

6694: p_exp_org_segment=> l_exp_org_segment,
6695: p_exp_type_segment => l_exp_type_segment);
6696: IF (l_proj_segment is null) OR (l_tsk_segment is null) OR (l_awd_sgement is null) OR
6697: (l_exp_org_segment is null) OR (l_exp_type_segment is null) THEN
6698: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');
6699: raise fnd_api.g_exc_unexpected_error;
6700: END IF;
6701: l_sql_string := replace(l_sql_string,'psl','erd');
6702: l_sql_string := replace(l_sql_string,'gcc','erd');

Line 6751: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');

6747: p_exp_org_segment=> l_exp_org_segment,
6748: p_exp_type_segment => l_exp_type_segment);
6749: IF (l_proj_segment is null) OR (l_tsk_segment is null) OR (l_awd_sgement is null) OR
6750: (l_exp_org_segment is null) OR (l_exp_type_segment is null) THEN
6751: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');
6752: raise fnd_api.g_exc_unexpected_error;
6753: END IF;
6754: l_sql_string := replace(l_sql_string,'psl','erd');
6755: l_sql_string := replace(l_sql_string,'gcc','erd');