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;
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;
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:
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;
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;
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:
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;
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;
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:
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
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;
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;
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
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;
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;
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
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;
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;
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
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;
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
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;
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:
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);
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);
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);
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;
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
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
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;
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 */
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:
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;
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;
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:
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 */
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:
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 */
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
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
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;
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:
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
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.
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:
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
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:
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:
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:
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;
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;
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:
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;
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;
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:
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;
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;
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;
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;
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;
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:
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;
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;
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:
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;
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;
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';
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;
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;
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:
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;
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;
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: */
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;
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;
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:
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;
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;
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;
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;
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;
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);
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);
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);
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;
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
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
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;
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;
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;
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:
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 */
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:
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 */
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:
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
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;
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:
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
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.
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:
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
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');
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');