DBA Data[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on FND_MESSAGE

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

378: and batch_name = to_char(l_gms_batch_name)
379: and transaction_source in ('GOLD', 'OLD');
380:
381: if (l_ti_not_complete > 0) then
382: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
383: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
384: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
385: fnd_msg_pub.add;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

379: and transaction_source in ('GOLD', 'OLD');
380:
381: if (l_ti_not_complete > 0) then
382: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
383: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
384: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
385: fnd_msg_pub.add;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: end if;

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

380:
381: if (l_ti_not_complete > 0) then
382: fnd_message.set_name('PSP','PSP_TI_DID_NOT_COMPLETE');
383: fnd_message.set_token('PAYROLL_CONTROL_ID', payroll_control_rec.payroll_control_id);
384: fnd_message.set_token('GMS_BATCH_NAME', l_gms_batch_name);
385: fnd_msg_pub.add;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: end if;
388:

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

794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
797: l_table := 'PER_TIME_PERIODS';
798: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
799: fnd_message.set_token('VALUE',l_value);
800: fnd_message.set_token('TABLE',l_table);
801: fnd_msg_pub.add;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

795: WHEN NO_DATA_FOUND THEN
796: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
797: l_table := 'PER_TIME_PERIODS';
798: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
799: fnd_message.set_token('VALUE',l_value);
800: fnd_message.set_token('TABLE',l_table);
801: fnd_msg_pub.add;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END;

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

796: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
797: l_table := 'PER_TIME_PERIODS';
798: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
799: fnd_message.set_token('VALUE',l_value);
800: fnd_message.set_token('TABLE',l_table);
801: fnd_msg_pub.add;
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END;
804:

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

1361: EXCEPTION
1362: WHEN NO_DATA_FOUND THEN
1363: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1364: l_table := 'PER_TIME_PERIODS';
1365: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1366: fnd_message.set_token('VALUE',l_value);
1367: fnd_message.set_token('TABLE',l_table);
1368: fnd_msg_pub.add;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1362: WHEN NO_DATA_FOUND THEN
1363: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1364: l_table := 'PER_TIME_PERIODS';
1365: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1366: fnd_message.set_token('VALUE',l_value);
1367: fnd_message.set_token('TABLE',l_table);
1368: fnd_msg_pub.add;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: END;

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

1363: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1364: l_table := 'PER_TIME_PERIODS';
1365: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1366: fnd_message.set_token('VALUE',l_value);
1367: fnd_message.set_token('TABLE',l_table);
1368: fnd_msg_pub.add;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: END;
1371:

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

1517: );
1518:
1519: IF req_id = 0 THEN
1520:
1521: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1522: fnd_msg_pub.add;
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524:
1525: ELSE

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

1543: rphase, rstatus, dphase, dstatus, message);
1544:
1545: IF call_status = FALSE THEN
1546:
1547: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
1548: fnd_msg_pub.add;
1549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550:
1551: END IF;

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

1625: EXCEPTION
1626: WHEN NO_DATA_FOUND THEN
1627: l_error := 'JE SOURCES = OLD';
1628: l_product := 'GL';
1629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1630: fnd_message.set_token('ERROR',l_error);
1631: fnd_message.set_token('PRODUCT',l_product);
1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

1626: WHEN NO_DATA_FOUND THEN
1627: l_error := 'JE SOURCES = OLD';
1628: l_product := 'GL';
1629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1630: fnd_message.set_token('ERROR',l_error);
1631: fnd_message.set_token('PRODUCT',l_product);
1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN

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

1627: l_error := 'JE SOURCES = OLD';
1628: l_product := 'GL';
1629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1630: fnd_message.set_token('ERROR',l_error);
1631: fnd_message.set_token('PRODUCT',l_product);
1632: fnd_msg_pub.add;
1633: p_return_status := fnd_api.g_ret_sts_unexp_error;
1634: WHEN OTHERS THEN
1635: g_error_api_path := 'GL_JE_SOURCES:'||g_error_api_path;

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

1650: EXCEPTION
1651: WHEN NO_DATA_FOUND THEN
1652: l_error := 'JE CATEGORY = OLD';
1653: l_product := 'GL';
1654: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1655: fnd_message.set_token('ERROR',l_error);
1656: fnd_message.set_token('PRODUCT',l_product);
1657: fnd_msg_pub.add;
1658: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

1651: WHEN NO_DATA_FOUND THEN
1652: l_error := 'JE CATEGORY = OLD';
1653: l_product := 'GL';
1654: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1655: fnd_message.set_token('ERROR',l_error);
1656: fnd_message.set_token('PRODUCT',l_product);
1657: fnd_msg_pub.add;
1658: p_return_status := fnd_api.g_ret_sts_unexp_error;
1659: WHEN OTHERS THEN

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

1652: l_error := 'JE CATEGORY = OLD';
1653: l_product := 'GL';
1654: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1655: fnd_message.set_token('ERROR',l_error);
1656: fnd_message.set_token('PRODUCT',l_product);
1657: fnd_msg_pub.add;
1658: p_return_status := fnd_api.g_ret_sts_unexp_error;
1659: WHEN OTHERS THEN
1660: g_error_api_path := 'GL_JE_CATEGORY_NAME:'||g_error_api_path;

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

1677: EXCEPTION
1678: WHEN NO_DATA_FOUND THEN
1679: l_error := 'ENCUMBRANCE TYPE = OLD';
1680: l_product := 'GL';
1681: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1682: fnd_message.set_token('ERROR',l_error);
1683: fnd_message.set_token('PRODUCT',l_product);
1684: fnd_msg_pub.add;
1685: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

1678: WHEN NO_DATA_FOUND THEN
1679: l_error := 'ENCUMBRANCE TYPE = OLD';
1680: l_product := 'GL';
1681: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1682: fnd_message.set_token('ERROR',l_error);
1683: fnd_message.set_token('PRODUCT',l_product);
1684: fnd_msg_pub.add;
1685: p_return_status := fnd_api.g_ret_sts_unexp_error;
1686: WHEN OTHERS THEN

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

1679: l_error := 'ENCUMBRANCE TYPE = OLD';
1680: l_product := 'GL';
1681: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1682: fnd_message.set_token('ERROR',l_error);
1683: fnd_message.set_token('PRODUCT',l_product);
1684: fnd_msg_pub.add;
1685: p_return_status := fnd_api.g_ret_sts_unexp_error;
1686: WHEN OTHERS THEN
1687: g_error_api_path := 'ENCUMBRANCE_TYPE_ID:'||g_error_api_path;

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

1955: commit;
1956: --- bug 4328598--- fix end
1957:
1958:
1959: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');
1960: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
1961: fnd_message.set_token('GROUP_ID',p_group_id);
1962: fnd_msg_pub.add;
1963: -- uncommented following statement for 2444657

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

1956: --- bug 4328598--- fix end
1957:
1958:
1959: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');
1960: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
1961: fnd_message.set_token('GROUP_ID',p_group_id);
1962: fnd_msg_pub.add;
1963: -- uncommented following statement for 2444657
1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1957:
1958:
1959: fnd_message.set_name('PSP','PSP_JI_DID_NOT_RUN');
1960: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
1961: fnd_message.set_token('GROUP_ID',p_group_id);
1962: fnd_msg_pub.add;
1963: -- uncommented following statement for 2444657
1964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1965:

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

2169: l_award_id,
2170: l_expenditure_type,
2171: l_exp_org_id);
2172: end if;
2173: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2174: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2175: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2176: fnd_message.set_token('ASG_NUM',l_assignment_number);
2177: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

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

2170: l_expenditure_type,
2171: l_exp_org_id);
2172: end if;
2173: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2174: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2175: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2176: fnd_message.set_token('ASG_NUM',l_assignment_number);
2177: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2178: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

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

2171: l_exp_org_id);
2172: end if;
2173: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2174: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2175: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2176: fnd_message.set_token('ASG_NUM',l_assignment_number);
2177: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2178: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2179: fnd_message.set_token('EFF_DATE',l_distribution_date);

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

2172: end if;
2173: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2174: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2175: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2176: fnd_message.set_token('ASG_NUM',l_assignment_number);
2177: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2178: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2179: fnd_message.set_token('EFF_DATE',l_distribution_date);
2180: fnd_msg_pub.add;

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

2173: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
2174: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2175: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2176: fnd_message.set_token('ASG_NUM',l_assignment_number);
2177: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2178: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2179: fnd_message.set_token('EFF_DATE',l_distribution_date);
2180: fnd_msg_pub.add;
2181: else

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

2174: fnd_message.set_token('ORG_NAME',l_auto_org_name);
2175: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2176: fnd_message.set_token('ASG_NUM',l_assignment_number);
2177: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2178: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2179: fnd_message.set_token('EFF_DATE',l_distribution_date);
2180: fnd_msg_pub.add;
2181: else
2182: if l_acct_type = 'E' then

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

2175: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
2176: fnd_message.set_token('ASG_NUM',l_assignment_number);
2177: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
2178: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
2179: fnd_message.set_token('EFF_DATE',l_distribution_date);
2180: fnd_msg_pub.add;
2181: else
2182: if l_acct_type = 'E' then
2183: l_expenditure_type := l_new_expenditure_type;

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

2258: WHERE GROUP_ID = p_group_id
2259: AND payroll_control_id = p_payroll_control_id);
2260:
2261: IF l_reversal_ac_failed = 'Y' THEN
2262: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
2263: fnd_message.set_token('GLCCID',x_lines_glccid);
2264: fnd_msg_pub.add;
2265:
2266: /* Added the following for the Bug 3065866 */

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

2259: AND payroll_control_id = p_payroll_control_id);
2260:
2261: IF l_reversal_ac_failed = 'Y' THEN
2262: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
2263: fnd_message.set_token('GLCCID',x_lines_glccid);
2264: fnd_msg_pub.add;
2265:
2266: /* Added the following for the Bug 3065866 */
2267:

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

2311: IF l_suspense_ac_failed = 'Y' or
2312: nvl(l_auto_status,'X') in ('AUTO_POP_NA_ERROR', 'AUTO_POP_EXP_ERROR', 'AUTO_POP_NO_VALUE') then
2313: --- above check for autopop error 5080403
2314: if nvl(l_suspense_ac_failed,'N') = 'Y' then
2315: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2316: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2317: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2318: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2319: fnd_msg_pub.add;

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

2312: nvl(l_auto_status,'X') in ('AUTO_POP_NA_ERROR', 'AUTO_POP_EXP_ERROR', 'AUTO_POP_NO_VALUE') then
2313: --- above check for autopop error 5080403
2314: if nvl(l_suspense_ac_failed,'N') = 'Y' then
2315: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2316: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2317: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2318: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2319: fnd_msg_pub.add;
2320: end if;

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

2313: --- above check for autopop error 5080403
2314: if nvl(l_suspense_ac_failed,'N') = 'Y' then
2315: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2316: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2317: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2318: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2319: fnd_msg_pub.add;
2320: end if;
2321:

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

2314: if nvl(l_suspense_ac_failed,'N') = 'Y' then
2315: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
2316: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
2317: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
2318: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
2319: fnd_msg_pub.add;
2320: end if;
2321:
2322: /* Added the following for Bug 3065866 */

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

2365: END IF;
2366:
2367: IF l_suspense_ac_not_found = 'Y' THEN
2368: /* commented following code for 2479579
2369: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
2370: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
2371: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
2372: fnd_msg_pub.add; */
2373:

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

2366:
2367: IF l_suspense_ac_not_found = 'Y' THEN
2368: /* commented following code for 2479579
2369: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
2370: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
2371: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
2372: fnd_msg_pub.add; */
2373:
2374: /* Introduced the following check as part of Bug fix #1776606 */

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

2367: IF l_suspense_ac_not_found = 'Y' THEN
2368: /* commented following code for 2479579
2369: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
2370: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
2371: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
2372: fnd_msg_pub.add; */
2373:
2374: /* Introduced the following check as part of Bug fix #1776606 */
2375: if p_mode = 'N' then

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

2520:
2521: /* Added Exceptions for bug 2056877 */
2522: WHEN NO_PROFILE_EXISTS THEN
2523: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2524: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
2525: fnd_msg_pub.add;
2526: p_return_status := fnd_api.g_ret_sts_unexp_error;
2527:
2528: WHEN NO_VAL_DATE_MATCHES THEN

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

2526: p_return_status := fnd_api.g_ret_sts_unexp_error;
2527:
2528: WHEN NO_VAL_DATE_MATCHES THEN
2529: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2530: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2531: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2532: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2533: fnd_msg_pub.add;
2534: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

2527:
2528: WHEN NO_VAL_DATE_MATCHES THEN
2529: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2530: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2531: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2532: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2533: fnd_msg_pub.add;
2534: p_return_status := fnd_api.g_ret_sts_unexp_error;
2535:

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

2528: WHEN NO_VAL_DATE_MATCHES THEN
2529: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2530: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
2531: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2532: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2533: fnd_msg_pub.add;
2534: p_return_status := fnd_api.g_ret_sts_unexp_error;
2535:
2536: WHEN NO_GLOBAL_ACCT_EXISTS THEN

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

2534: p_return_status := fnd_api.g_ret_sts_unexp_error;
2535:
2536: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2537: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2538: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2539: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2540: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2541: fnd_msg_pub.add;
2542: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.

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

2535:
2536: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2537: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2538: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2539: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2540: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2541: fnd_msg_pub.add;
2542: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2543:

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

2536: WHEN NO_GLOBAL_ACCT_EXISTS THEN
2537: g_error_api_path := SUBSTR('GL_TIE_BACK:'||g_error_api_path,1,230);
2538: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
2539: fnd_message.set_token('ORG_NAME',l_orig_org_name);
2540: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
2541: fnd_msg_pub.add;
2542: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Changes for Bug 2056877.
2543:
2544: WHEN OTHERS THEN

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

2667: AND pdl.gl_project_flag = 'G'
2668: AND pdl.status_code = 'N';
2669:
2670: IF l_cr_amount <> l_dr_amount then
2671: fnd_message.set_name('PSP','PSP_GL_REV_AMT_NOT_EQUAL');
2672: fnd_msg_pub.add;
2673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2674: END IF;
2675:

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

2686: AND business_group_id = p_business_group_id -- Changed for MO.
2687: AND payroll_id = l_payroll_id; -- Added for bug 5592964
2688: EXCEPTION
2689: WHEN NO_DATA_FOUND THEN
2690: fnd_message.set_name('PSP','PSP_TR_CLRG_AC_NOT_SET_UP');
2691: fnd_msg_pub.add;
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: END;
2694:

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

2744: and (ppgd.gl_code_combination_id is not null or (ppgd.suspense_org_account_id is not null
2745: and pos.gl_code_combination_id is not null)); */
2746:
2747: IF l_cr_amount <> l_dr_amount then
2748: fnd_message.set_name('PSP','PSP_GL_UNBALANCED_BATCH');
2749: fnd_msg_pub.add;
2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2751: END IF;
2752:

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

3192: EXCEPTION
3193: WHEN NO_DATA_FOUND THEN
3194: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
3195: l_table := 'PER_TIME_PERIODS';
3196: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3197: fnd_message.set_token('VALUE',l_value);
3198: fnd_message.set_token('TABLE',l_table);
3199: fnd_msg_pub.add;
3200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3193: WHEN NO_DATA_FOUND THEN
3194: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
3195: l_table := 'PER_TIME_PERIODS';
3196: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3197: fnd_message.set_token('VALUE',l_value);
3198: fnd_message.set_token('TABLE',l_table);
3199: fnd_msg_pub.add;
3200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3201: END;

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

3194: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
3195: l_table := 'PER_TIME_PERIODS';
3196: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3197: fnd_message.set_token('VALUE',l_value);
3198: fnd_message.set_token('TABLE',l_table);
3199: fnd_msg_pub.add;
3200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3201: END;
3202:

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

3586: EXCEPTION
3587: WHEN NO_DATA_FOUND THEN
3588: l_error := 'TRANSACTION SOURCE = OLD';
3589: l_product := 'PA';
3590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3591: fnd_message.set_token('ERROR',l_error);
3592: fnd_message.set_token('PRODUCT',l_product);
3593: fnd_msg_pub.add;
3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3587: WHEN NO_DATA_FOUND THEN
3588: l_error := 'TRANSACTION SOURCE = OLD';
3589: l_product := 'PA';
3590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3591: fnd_message.set_token('ERROR',l_error);
3592: fnd_message.set_token('PRODUCT',l_product);
3593: fnd_msg_pub.add;
3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3595: END;

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

3588: l_error := 'TRANSACTION SOURCE = OLD';
3589: l_product := 'PA';
3590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3591: fnd_message.set_token('ERROR',l_error);
3592: fnd_message.set_token('PRODUCT',l_product);
3593: fnd_msg_pub.add;
3594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3595: END;
3596:

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

3603: EXCEPTION
3604: WHEN NO_DATA_FOUND THEN
3605: l_error := 'TRANSACTION SOURCE = GOLD';
3606: l_product := 'GMS';
3607: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3608: fnd_message.set_token('ERROR',l_error);
3609: fnd_message.set_token('PRODUCT',l_product);
3610: fnd_msg_pub.add;
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3604: WHEN NO_DATA_FOUND THEN
3605: l_error := 'TRANSACTION SOURCE = GOLD';
3606: l_product := 'GMS';
3607: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3608: fnd_message.set_token('ERROR',l_error);
3609: fnd_message.set_token('PRODUCT',l_product);
3610: fnd_msg_pub.add;
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END;

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

3605: l_error := 'TRANSACTION SOURCE = GOLD';
3606: l_product := 'GMS';
3607: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3608: fnd_message.set_token('ERROR',l_error);
3609: fnd_message.set_token('PRODUCT',l_product);
3610: fnd_msg_pub.add;
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END;
3613: end if;

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

3631: EXCEPTION
3632: WHEN NO_DATA_FOUND THEN
3633: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3634: l_table := 'PER_TIME_PERIODS';
3635: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3636: fnd_message.set_token('VALUE',l_value);
3637: fnd_message.set_token('TABLE',l_table);
3638: fnd_msg_pub.add;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3632: WHEN NO_DATA_FOUND THEN
3633: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3634: l_table := 'PER_TIME_PERIODS';
3635: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3636: fnd_message.set_token('VALUE',l_value);
3637: fnd_message.set_token('TABLE',l_table);
3638: fnd_msg_pub.add;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3640: END;

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

3633: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3634: l_table := 'PER_TIME_PERIODS';
3635: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3636: fnd_message.set_token('VALUE',l_value);
3637: fnd_message.set_token('TABLE',l_table);
3638: fnd_msg_pub.add;
3639: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3640: END;
3641:

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

3701: EXCEPTION
3702: WHEN NO_DATA_FOUND THEN
3703: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3704: l_table := 'PER_PEOPLE_F';
3705: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3706: fnd_message.set_token('VALUE',l_value);
3707: fnd_message.set_token('TABLE',l_table);
3708: fnd_msg_pub.add;
3709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3702: WHEN NO_DATA_FOUND THEN
3703: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3704: l_table := 'PER_PEOPLE_F';
3705: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3706: fnd_message.set_token('VALUE',l_value);
3707: fnd_message.set_token('TABLE',l_table);
3708: fnd_msg_pub.add;
3709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3710: END;

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

3703: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3704: l_table := 'PER_PEOPLE_F';
3705: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3706: fnd_message.set_token('VALUE',l_value);
3707: fnd_message.set_token('TABLE',l_table);
3708: fnd_msg_pub.add;
3709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3710: END;
3711:

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

3719: EXCEPTION
3720: WHEN NO_DATA_FOUND THEN
3721: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3722: l_table := 'HR_ORGANIZATION_UNITS';
3723: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3724: fnd_message.set_token('VALUE',l_value);
3725: fnd_message.set_token('TABLE',l_table);
3726: fnd_msg_pub.add;
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3720: WHEN NO_DATA_FOUND THEN
3721: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3722: l_table := 'HR_ORGANIZATION_UNITS';
3723: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3724: fnd_message.set_token('VALUE',l_value);
3725: fnd_message.set_token('TABLE',l_table);
3726: fnd_msg_pub.add;
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3728: --l_org_name := NULL;

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

3721: l_value := 'Organization Id = '||to_char(gms_interface_rec.expenditure_organization_id);
3722: l_table := 'HR_ORGANIZATION_UNITS';
3723: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3724: fnd_message.set_token('VALUE',l_value);
3725: fnd_message.set_token('TABLE',l_table);
3726: fnd_msg_pub.add;
3727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3728: --l_org_name := NULL;
3729: --l_org_name := 'LDM_ORG_NAME_INVALID';

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

3738: EXCEPTION
3739: WHEN NO_DATA_FOUND THEN
3740: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3741: l_table := 'PA_PROJECTS_ALL';
3742: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3743: fnd_message.set_token('VALUE',l_value);
3744: fnd_message.set_token('TABLE',l_table);
3745: fnd_msg_pub.add;
3746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3739: WHEN NO_DATA_FOUND THEN
3740: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3741: l_table := 'PA_PROJECTS_ALL';
3742: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3743: fnd_message.set_token('VALUE',l_value);
3744: fnd_message.set_token('TABLE',l_table);
3745: fnd_msg_pub.add;
3746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3747: END;

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

3740: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3741: l_table := 'PA_PROJECTS_ALL';
3742: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3743: fnd_message.set_token('VALUE',l_value);
3744: fnd_message.set_token('TABLE',l_table);
3745: fnd_msg_pub.add;
3746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3747: END;
3748:

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

3757: EXCEPTION
3758: WHEN NO_DATA_FOUND THEN
3759: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3760: l_table := 'PA_PROJECTS_ALL';
3761: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3762: fnd_message.set_token('VALUE',l_value);
3763: fnd_message.set_token('TABLE',l_table);
3764: fnd_msg_pub.add;
3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3758: WHEN NO_DATA_FOUND THEN
3759: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3760: l_table := 'PA_PROJECTS_ALL';
3761: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3762: fnd_message.set_token('VALUE',l_value);
3763: fnd_message.set_token('TABLE',l_table);
3764: fnd_msg_pub.add;
3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3766: END;

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

3759: l_value := 'Project Id = '||to_char(gms_interface_rec.project_Id);
3760: l_table := 'PA_PROJECTS_ALL';
3761: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
3762: fnd_message.set_token('VALUE',l_value);
3763: fnd_message.set_token('TABLE',l_table);
3764: fnd_msg_pub.add;
3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3766: END;
3767: */

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

3775: EXCEPTION
3776: WHEN NO_DATA_FOUND THEN
3777: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3778: l_table := 'PA_TASKS';
3779: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3780: fnd_message.set_token('VALUE',l_value);
3781: fnd_message.set_token('TABLE',l_table);
3782: fnd_msg_pub.add;
3783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3776: WHEN NO_DATA_FOUND THEN
3777: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3778: l_table := 'PA_TASKS';
3779: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3780: fnd_message.set_token('VALUE',l_value);
3781: fnd_message.set_token('TABLE',l_table);
3782: fnd_msg_pub.add;
3783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3784: END;

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

3777: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3778: l_table := 'PA_TASKS';
3779: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3780: fnd_message.set_token('VALUE',l_value);
3781: fnd_message.set_token('TABLE',l_table);
3782: fnd_msg_pub.add;
3783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3784: END;
3785:

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

3941: l_txn_source, -- should be l_txn_source rather than l_transaction_source,
3942: l_gms_batch_name);
3943:
3944: IF req_id = 0 THEN
3945: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3946: fnd_msg_pub.add;
3947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3948: END IF;
3949: END LOOP;

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

3957: LOOP
3958: call_status_tab(I) := fnd_concurrent.wait_for_request(req_id_tab(I), 20, 0,
3959: rphase, rstatus, dphase, dstatus, message);
3960: IF call_status_tab(I) = FALSE then
3961: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
3962: fnd_msg_pub.add;
3963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3964: END IF;
3965: END LOOP;

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

4347:
4348:
4349: if NOT PROCESS_COMPLETE then
4350: if (l_no_run_status = 'I') then
4351: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4352: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4353: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4354: fnd_msg_pub.add;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4348:
4349: if NOT PROCESS_COMPLETE then
4350: if (l_no_run_status = 'I') then
4351: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4352: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4353: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4354: fnd_msg_pub.add;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: end if;

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

4349: if NOT PROCESS_COMPLETE then
4350: if (l_no_run_status = 'I') then
4351: fnd_message.set_name('PSP','PSP_PRC_DID_NOT_RUN');
4352: fnd_message.set_token('PAYROLL_CONTROL_ID',p_payroll_control_id);
4353: fnd_message.set_token('GMS_BATCH_NAME',p_gms_batch_name);
4354: fnd_msg_pub.add;
4355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4356: end if;
4357: end if;

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

4694: l_award_id,
4695: l_new_expenditure_type,
4696: l_exp_org_id);
4697: end if;
4698: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
4699: fnd_message.set_token('ORG_NAME',l_auto_org_name);
4700: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
4701: fnd_message.set_token('ASG_NUM',l_assignment_number);
4702: fnd_message.set_token('CHARGING_ACCOUNT',l_account);

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

4695: l_new_expenditure_type,
4696: l_exp_org_id);
4697: end if;
4698: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
4699: fnd_message.set_token('ORG_NAME',l_auto_org_name);
4700: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
4701: fnd_message.set_token('ASG_NUM',l_assignment_number);
4702: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
4703: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);

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

4696: l_exp_org_id);
4697: end if;
4698: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
4699: fnd_message.set_token('ORG_NAME',l_auto_org_name);
4700: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
4701: fnd_message.set_token('ASG_NUM',l_assignment_number);
4702: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
4703: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
4704: fnd_message.set_token('EFF_DATE',l_distribution_date);

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

4697: end if;
4698: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
4699: fnd_message.set_token('ORG_NAME',l_auto_org_name);
4700: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
4701: fnd_message.set_token('ASG_NUM',l_assignment_number);
4702: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
4703: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
4704: fnd_message.set_token('EFF_DATE',l_distribution_date);
4705: fnd_msg_pub.add;

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

4698: fnd_message.set_name('PSP','PSP_SUSPENSE_AUTOPOP_FAIL');
4699: fnd_message.set_token('ORG_NAME',l_auto_org_name);
4700: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
4701: fnd_message.set_token('ASG_NUM',l_assignment_number);
4702: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
4703: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
4704: fnd_message.set_token('EFF_DATE',l_distribution_date);
4705: fnd_msg_pub.add;
4706: else

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

4699: fnd_message.set_token('ORG_NAME',l_auto_org_name);
4700: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
4701: fnd_message.set_token('ASG_NUM',l_assignment_number);
4702: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
4703: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
4704: fnd_message.set_token('EFF_DATE',l_distribution_date);
4705: fnd_msg_pub.add;
4706: else
4707: if l_acct_type = 'E' then

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

4700: fnd_message.set_token('EMPLOYEE_NAME',l_person_name);
4701: fnd_message.set_token('ASG_NUM',l_assignment_number);
4702: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
4703: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
4704: fnd_message.set_token('EFF_DATE',l_distribution_date);
4705: fnd_msg_pub.add;
4706: else
4707: if l_acct_type = 'E' then
4708: l_expenditure_type := l_new_expenditure_type;

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

4778: IF l_suspense_ac_failed = 'Y' or
4779: nvl(l_auto_status,'X') in ('AUTO_POP_NA_ERROR', 'AUTO_POP_EXP_ERROR', 'AUTO_POP_NO_VALUE') then
4780: --- above check for autopop error 5080403
4781: if nvl(l_suspense_ac_failed,'N') = 'Y' then
4782: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
4783: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4784: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4785: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
4786: fnd_msg_pub.add;

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

4779: nvl(l_auto_status,'X') in ('AUTO_POP_NA_ERROR', 'AUTO_POP_EXP_ERROR', 'AUTO_POP_NO_VALUE') then
4780: --- above check for autopop error 5080403
4781: if nvl(l_suspense_ac_failed,'N') = 'Y' then
4782: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
4783: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4784: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4785: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
4786: fnd_msg_pub.add;
4787: end if;

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

4780: --- above check for autopop error 5080403
4781: if nvl(l_suspense_ac_failed,'N') = 'Y' then
4782: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
4783: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4784: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4785: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
4786: fnd_msg_pub.add;
4787: end if;
4788:

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

4781: if nvl(l_suspense_ac_failed,'N') = 'Y' then
4782: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
4783: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4784: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4785: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
4786: fnd_msg_pub.add;
4787: end if;
4788:
4789: /* Added this code for Bug 3065866 */

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

4832: END IF;
4833:
4834: IF l_suspense_ac_not_found = 'Y' THEN
4835: /* commented for 2479579
4836: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4837: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4838: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4839: fnd_msg_pub.add; */
4840:

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

4833:
4834: IF l_suspense_ac_not_found = 'Y' THEN
4835: /* commented for 2479579
4836: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4837: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4838: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4839: fnd_msg_pub.add; */
4840:
4841: /* Added the following code for Bug 3065866 */

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

4834: IF l_suspense_ac_not_found = 'Y' THEN
4835: /* commented for 2479579
4836: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4837: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4838: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4839: fnd_msg_pub.add; */
4840:
4841: /* Added the following code for Bug 3065866 */
4842:

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

5059: p_return_status := fnd_api.g_ret_sts_unexp_error;
5060: /* Added Exceptions for bug 2056877 */
5061: WHEN NO_PROFILE_EXISTS THEN
5062: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5063: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5064: fnd_msg_pub.add;
5065: p_return_status := fnd_api.g_ret_sts_unexp_error;
5066:
5067: WHEN NO_VAL_DATE_MATCHES THEN

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

5065: p_return_status := fnd_api.g_ret_sts_unexp_error;
5066:
5067: WHEN NO_VAL_DATE_MATCHES THEN
5068: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5069: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5070: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5071: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5072: fnd_msg_pub.add;
5073: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

5066:
5067: WHEN NO_VAL_DATE_MATCHES THEN
5068: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5069: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5070: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5071: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5072: fnd_msg_pub.add;
5073: p_return_status := fnd_api.g_ret_sts_unexp_error;
5074:

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

5067: WHEN NO_VAL_DATE_MATCHES THEN
5068: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5069: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5070: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5071: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5072: fnd_msg_pub.add;
5073: p_return_status := fnd_api.g_ret_sts_unexp_error;
5074:
5075: WHEN NO_GLOBAL_ACCT_EXISTS THEN

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

5073: p_return_status := fnd_api.g_ret_sts_unexp_error;
5074:
5075: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5076: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5078: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5079: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5080: fnd_msg_pub.add;
5081: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.

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

5074:
5075: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5076: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5078: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5079: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5080: fnd_msg_pub.add;
5081: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5082:

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

5075: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5076: g_error_api_path := SUBSTR('GMS_TIE_BACK:'||g_error_api_path,1,230);
5077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5078: fnd_message.set_token('ORG_NAME',l_orig_org_name1);
5079: fnd_message.set_token('PAYROLL_DATE',l_distribution_date);
5080: fnd_msg_pub.add;
5081: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
5082:
5083: WHEN OTHERS THEN

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

6267: p_exp_org_segment=> l_exp_org_segment,
6268: p_exp_type_segment => l_exp_type_segment);
6269: IF (l_proj_segment is null) OR (l_tsk_segment is null) OR (l_awd_sgement is null) OR
6270: (l_exp_org_segment is null) OR (l_exp_type_segment is null) THEN
6271: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');
6272: raise fnd_api.g_exc_unexpected_error;
6273: END IF;
6274: l_sql_string := replace(l_sql_string,'psl','erd');
6275: l_sql_string := replace(l_sql_string,'gcc','erd');

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

6320: p_exp_org_segment=> l_exp_org_segment,
6321: p_exp_type_segment => l_exp_type_segment);
6322: IF (l_proj_segment is null) OR (l_tsk_segment is null) OR (l_awd_sgement is null) OR
6323: (l_exp_org_segment is null) OR (l_exp_type_segment is null) THEN
6324: fnd_message.set_name('PSP', 'PSP_GL_PTAOE_NOT_MAPPED');
6325: raise fnd_api.g_exc_unexpected_error;
6326: END IF;
6327: l_sql_string := replace(l_sql_string,'psl','erd');
6328: l_sql_string := replace(l_sql_string,'gcc','erd');