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

Line 292: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');

288: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then
289: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
290: pqh_psp_integration.relieve_budget_commitments( 'S', l_return_status);
291: If l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
292: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
293: fnd_msg_pub.add;
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: end if;
296: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');

Line 532: fnd_message.set_name('PSP','PSP_ENC_NO_SUMM_REC_FOUND');

528: FETCH enc_control_cur INTO enc_control_rec;
529:
530: IF enc_control_cur%rowcount = 0 THEN
531: g_control_rec_found := 'FALSE';
532: fnd_message.set_name('PSP','PSP_ENC_NO_SUMM_REC_FOUND');
533: fnd_msg_pub.add;
534: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
535: -- for bug fix 1868338 -- Subha
536: p_return_status := fnd_api.g_ret_sts_success;

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

1214: EXCEPTION
1215: WHEN NO_DATA_FOUND THEN
1216: l_error := 'TIME_BASED_SUMM';
1217: l_product := 'PSP';
1218: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1219: fnd_message.set_token('ERROR',l_error);
1220: fnd_message.set_token('PRODUCT',l_product);
1221: fnd_msg_pub.add;
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1215: WHEN NO_DATA_FOUND THEN
1216: l_error := 'TIME_BASED_SUMM';
1217: l_product := 'PSP';
1218: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1219: fnd_message.set_token('ERROR',l_error);
1220: fnd_message.set_token('PRODUCT',l_product);
1221: fnd_msg_pub.add;
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223: END;

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

1216: l_error := 'TIME_BASED_SUMM';
1217: l_product := 'PSP';
1218: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1219: fnd_message.set_token('ERROR',l_error);
1220: fnd_message.set_token('PRODUCT',l_product);
1221: fnd_msg_pub.add;
1222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1223: END;
1224:

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

1231: EXCEPTION
1232: WHEN NO_DATA_FOUND THEN
1233: l_error := 'CI_BASED_SUMM_GL';
1234: l_product := 'PSP';
1235: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1236: fnd_message.set_token('ERROR',l_error);
1237: fnd_message.set_token('PRODUCT',l_product);
1238: fnd_msg_pub.add;
1239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1232: WHEN NO_DATA_FOUND THEN
1233: l_error := 'CI_BASED_SUMM_GL';
1234: l_product := 'PSP';
1235: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1236: fnd_message.set_token('ERROR',l_error);
1237: fnd_message.set_token('PRODUCT',l_product);
1238: fnd_msg_pub.add;
1239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1240: END;

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

1233: l_error := 'CI_BASED_SUMM_GL';
1234: l_product := 'PSP';
1235: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1236: fnd_message.set_token('ERROR',l_error);
1237: fnd_message.set_token('PRODUCT',l_product);
1238: fnd_msg_pub.add;
1239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1240: END;
1241:

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

2033: EXCEPTION
2034: WHEN NO_DATA_FOUND THEN
2035: l_error := 'CURRENCY CODE';
2036: l_product := 'GL';
2037: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2038: fnd_message.set_token('ERROR',l_error);
2039: fnd_message.set_token('PRODUCT',l_product);
2040: fnd_msg_pub.add;
2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2034: WHEN NO_DATA_FOUND THEN
2035: l_error := 'CURRENCY CODE';
2036: l_product := 'GL';
2037: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2038: fnd_message.set_token('ERROR',l_error);
2039: fnd_message.set_token('PRODUCT',l_product);
2040: fnd_msg_pub.add;
2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2042: END; * /

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

2035: l_error := 'CURRENCY CODE';
2036: l_product := 'GL';
2037: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2038: fnd_message.set_token('ERROR',l_error);
2039: fnd_message.set_token('PRODUCT',l_product);
2040: fnd_msg_pub.add;
2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2042: END; * /
2043:

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

2051: EXCEPTION
2052: WHEN NO_DATA_FOUND THEN
2053: l_value := 'time period id =';
2054: l_table := 'PER_TIME_PERIODS';
2055: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2056: fnd_message.set_token('VALUE','l_value');
2057: fnd_message.set_token('TABLE','l_table');
2058: fnd_msg_pub.add;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2052: WHEN NO_DATA_FOUND THEN
2053: l_value := 'time period id =';
2054: l_table := 'PER_TIME_PERIODS';
2055: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2056: fnd_message.set_token('VALUE','l_value');
2057: fnd_message.set_token('TABLE','l_table');
2058: fnd_msg_pub.add;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END;

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

2053: l_value := 'time period id =';
2054: l_table := 'PER_TIME_PERIODS';
2055: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2056: fnd_message.set_token('VALUE','l_value');
2057: fnd_message.set_token('TABLE','l_table');
2058: fnd_msg_pub.add;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END;
2061:

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

2205: 'W'); -- Changed 'n' to 'W' for bug fix 2908859
2206:
2207: IF req_id = 0 THEN
2208:
2209: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2210: fnd_msg_pub.add;
2211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2212:
2213: ELSE

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

2236: call_status := fnd_concurrent.wait_for_request(req_id, 20, 0,
2237: rphase, rstatus, dphase, dstatus, message);
2238:
2239: IF call_status = FALSE then
2240: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2241: fnd_msg_pub.add;
2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2243: END IF;
2244: END IF;

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

2489: 'W');
2490:
2491: IF req_id = 0 THEN
2492: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import submission failed');
2493: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2494: fnd_msg_pub.add;
2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496: ELSE
2497: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Journal Import (req_id: ' || req_id || ')');

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

2528: call_status := fnd_concurrent.wait_for_request(req_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
2529:
2530: IF call_status = FALSE THEN
2531: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
2532: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2533: fnd_msg_pub.add;
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');

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

2625: EXCEPTION
2626: WHEN NO_DATA_FOUND THEN
2627: l_error := 'JE SOURCES = OLD';
2628: l_product := 'GL';
2629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2630: fnd_message.set_token('ERROR',l_error);
2631: fnd_message.set_token('PRODUCT',l_product);
2632: fnd_msg_pub.add;
2633: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

2626: WHEN NO_DATA_FOUND THEN
2627: l_error := 'JE SOURCES = OLD';
2628: l_product := 'GL';
2629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2630: fnd_message.set_token('ERROR',l_error);
2631: fnd_message.set_token('PRODUCT',l_product);
2632: fnd_msg_pub.add;
2633: p_return_status := fnd_api.g_ret_sts_unexp_error;
2634: WHEN OTHERS THEN

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

2627: l_error := 'JE SOURCES = OLD';
2628: l_product := 'GL';
2629: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2630: fnd_message.set_token('ERROR',l_error);
2631: fnd_message.set_token('PRODUCT',l_product);
2632: fnd_msg_pub.add;
2633: p_return_status := fnd_api.g_ret_sts_unexp_error;
2634: WHEN OTHERS THEN
2635: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

2654: EXCEPTION
2655: WHEN NO_DATA_FOUND THEN
2656: l_error := 'JE CATEGORY = OLD';
2657: l_product := 'GL';
2658: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2659: fnd_message.set_token('ERROR',l_error);
2660: fnd_message.set_token('PRODUCT',l_product);
2661: fnd_msg_pub.add;
2662: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

2655: WHEN NO_DATA_FOUND THEN
2656: l_error := 'JE CATEGORY = OLD';
2657: l_product := 'GL';
2658: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2659: fnd_message.set_token('ERROR',l_error);
2660: fnd_message.set_token('PRODUCT',l_product);
2661: fnd_msg_pub.add;
2662: p_return_status := fnd_api.g_ret_sts_unexp_error;
2663: WHEN OTHERS THEN

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

2656: l_error := 'JE CATEGORY = OLD';
2657: l_product := 'GL';
2658: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2659: fnd_message.set_token('ERROR',l_error);
2660: fnd_message.set_token('PRODUCT',l_product);
2661: fnd_msg_pub.add;
2662: p_return_status := fnd_api.g_ret_sts_unexp_error;
2663: WHEN OTHERS THEN
2664: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

2686: EXCEPTION
2687: WHEN NO_DATA_FOUND THEN
2688: l_error := 'ENCUMBRANCE TYPE = OLD';
2689: l_product := 'GL';
2690: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2691: fnd_message.set_token('ERROR',l_error);
2692: fnd_message.set_token('PRODUCT',l_product);
2693: fnd_msg_pub.add;
2694: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

2687: WHEN NO_DATA_FOUND THEN
2688: l_error := 'ENCUMBRANCE TYPE = OLD';
2689: l_product := 'GL';
2690: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2691: fnd_message.set_token('ERROR',l_error);
2692: fnd_message.set_token('PRODUCT',l_product);
2693: fnd_msg_pub.add;
2694: p_return_status := fnd_api.g_ret_sts_unexp_error;
2695: WHEN OTHERS THEN

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

2688: l_error := 'ENCUMBRANCE TYPE = OLD';
2689: l_product := 'GL';
2690: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2691: fnd_message.set_token('ERROR',l_error);
2692: fnd_message.set_token('PRODUCT',l_product);
2693: fnd_msg_pub.add;
2694: p_return_status := fnd_api.g_ret_sts_unexp_error;
2695: WHEN OTHERS THEN
2696: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

3151: SET gl_phase = 'TieBack'
3152: WHERE enc_control_id = p_enc_control_id;* /
3153: / * GL encumbrance does not have reversal lines: bug 2030232
3154: IF l_reversal_ac_failed = 'Y' THEN
3155: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
3156: fnd_message.set_token('GLCCID',x_lines_glccid);
3157: fnd_msg_pub.add;
3158: -- Included the following check as part of Bug fix #1776606 --
3159: IF p_mode = 'N' THEN

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

3152: WHERE enc_control_id = p_enc_control_id;* /
3153: / * GL encumbrance does not have reversal lines: bug 2030232
3154: IF l_reversal_ac_failed = 'Y' THEN
3155: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
3156: fnd_message.set_token('GLCCID',x_lines_glccid);
3157: fnd_msg_pub.add;
3158: -- Included the following check as part of Bug fix #1776606 --
3159: IF p_mode = 'N' THEN
3160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3163: * /
3164:
3165: IF l_suspense_ac_failed = 'Y' THEN
3166: g_susp_prob := 'Y'; -- for 2479579
3167: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3168: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3169: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3170: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3171: fnd_msg_pub.add;

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

3164:
3165: IF l_suspense_ac_failed = 'Y' THEN
3166: g_susp_prob := 'Y'; -- for 2479579
3167: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3168: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3169: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3170: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3171: fnd_msg_pub.add;
3172:

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

3165: IF l_suspense_ac_failed = 'Y' THEN
3166: g_susp_prob := 'Y'; -- for 2479579
3167: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3168: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3169: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3170: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3171: fnd_msg_pub.add;
3172:
3173:

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

3166: g_susp_prob := 'Y'; -- for 2479579
3167: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3168: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3169: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3170: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3171: fnd_msg_pub.add;
3172:
3173:
3174: / * Added the following for Bug 3194807 * /

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

3191: -- uncommented for 2479579, which was earlier commented for bug # 2142865
3192: IF l_suspense_ac_not_found = 'Y' THEN
3193: g_susp_prob := 'Y'; -- for 2479579
3194: / * commented this message stack for 2479579
3195: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
3196: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
3197: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
3198: fnd_msg_pub.add; * /
3199: ---added following if stmnt for 2479579

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

3192: IF l_suspense_ac_not_found = 'Y' THEN
3193: g_susp_prob := 'Y'; -- for 2479579
3194: / * commented this message stack for 2479579
3195: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
3196: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
3197: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
3198: fnd_msg_pub.add; * /
3199: ---added following if stmnt for 2479579
3200: IF l_susp_exception = 'NO_G_AC' then

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

3193: g_susp_prob := 'Y'; -- for 2479579
3194: / * commented this message stack for 2479579
3195: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
3196: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
3197: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
3198: fnd_msg_pub.add; * /
3199: ---added following if stmnt for 2479579
3200: IF l_susp_exception = 'NO_G_AC' then
3201: RAISE no_global_acct_exists;

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

3303:
3304: / * Added Exceptions for bug 2056877 * /
3305: WHEN NO_PROFILE_EXISTS THEN
3306: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3307: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3308: fnd_msg_pub.add;
3309: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3310: p_return_status := fnd_api.g_ret_sts_success;
3311:

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

3310: p_return_status := fnd_api.g_ret_sts_success;
3311:
3312: WHEN NO_VAL_DATE_MATCHES THEN
3313: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3314: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3315: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3316: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3317: fnd_msg_pub.add;
3318: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

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

3311:
3312: WHEN NO_VAL_DATE_MATCHES THEN
3313: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3314: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3315: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3316: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3317: fnd_msg_pub.add;
3318: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3319: p_return_status := fnd_api.g_ret_sts_success;

Line 3316: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);

3312: WHEN NO_VAL_DATE_MATCHES THEN
3313: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3314: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3315: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3316: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3317: fnd_msg_pub.add;
3318: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3319: p_return_status := fnd_api.g_ret_sts_success;
3320:

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

3319: p_return_status := fnd_api.g_ret_sts_success;
3320:
3321: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3322: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3323: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3324: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3325: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3326: fnd_msg_pub.add;
3327: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

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

3320:
3321: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3322: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3323: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3324: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3325: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3326: fnd_msg_pub.add;
3327: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3328: p_return_status := fnd_api.g_ret_sts_success;

Line 3325: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);

3321: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3322: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3323: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3324: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3325: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3326: fnd_msg_pub.add;
3327: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3328: p_return_status := fnd_api.g_ret_sts_success;
3329:

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

3596: CLOSE get_susp_org_cur;
3597:
3598: l_suspense_ac_failed := 'Y';
3599: g_susp_prob := 'Y';
3600: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3601: fnd_message.set_token('ORG_NAME', l_organization_name);
3602: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3603: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3604: fnd_msg_pub.add;

Line 3601: fnd_message.set_token('ORG_NAME', l_organization_name);

3597:
3598: l_suspense_ac_failed := 'Y';
3599: g_susp_prob := 'Y';
3600: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3601: fnd_message.set_token('ORG_NAME', l_organization_name);
3602: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3603: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3604: fnd_msg_pub.add;
3605: ELSE

Line 3602: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));

3598: l_suspense_ac_failed := 'Y';
3599: g_susp_prob := 'Y';
3600: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3601: fnd_message.set_token('ORG_NAME', l_organization_name);
3602: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3603: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3604: fnd_msg_pub.add;
3605: ELSE
3606: l_susp_ac_found := 'TRUE';

Line 3603: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));

3599: g_susp_prob := 'Y';
3600: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3601: fnd_message.set_token('ORG_NAME', l_organization_name);
3602: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3603: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3604: fnd_msg_pub.add;
3605: ELSE
3606: l_susp_ac_found := 'TRUE';
3607:

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

3887: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3888: EXCEPTION
3889: WHEN NO_PROFILE_EXISTS THEN
3890: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3891: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3892: fnd_msg_pub.add;
3893: p_return_status := fnd_api.g_ret_sts_success;
3894: WHEN NO_VAL_DATE_MATCHES THEN
3895: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

3892: fnd_msg_pub.add;
3893: p_return_status := fnd_api.g_ret_sts_success;
3894: WHEN NO_VAL_DATE_MATCHES THEN
3895: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3896: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3897: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3898: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3899: fnd_msg_pub.add;
3900: p_return_status := fnd_api.g_ret_sts_success;

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

3893: p_return_status := fnd_api.g_ret_sts_success;
3894: WHEN NO_VAL_DATE_MATCHES THEN
3895: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3896: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3897: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3898: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3899: fnd_msg_pub.add;
3900: p_return_status := fnd_api.g_ret_sts_success;
3901: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 3898: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);

3894: WHEN NO_VAL_DATE_MATCHES THEN
3895: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3896: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3897: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3898: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3899: fnd_msg_pub.add;
3900: p_return_status := fnd_api.g_ret_sts_success;
3901: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3902: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

3899: fnd_msg_pub.add;
3900: p_return_status := fnd_api.g_ret_sts_success;
3901: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3902: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3903: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3904: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3905: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3906: fnd_msg_pub.add;
3907: p_return_status := fnd_api.g_ret_sts_success;

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

3900: p_return_status := fnd_api.g_ret_sts_success;
3901: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3902: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3903: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3904: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3905: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3906: fnd_msg_pub.add;
3907: p_return_status := fnd_api.g_ret_sts_success;
3908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3905: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);

3901: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3902: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3903: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3904: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3905: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3906: fnd_msg_pub.add;
3907: p_return_status := fnd_api.g_ret_sts_success;
3908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3909: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;

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

4282: EXCEPTION
4283: WHEN NO_DATA_FOUND THEN
4284: l_error := 'TIME_BASED_SUMM';
4285: l_product := 'PSP';
4286: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4287: fnd_message.set_token('ERROR',l_error);
4288: fnd_message.set_token('PRODUCT',l_product);
4289: fnd_msg_pub.add;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4283: WHEN NO_DATA_FOUND THEN
4284: l_error := 'TIME_BASED_SUMM';
4285: l_product := 'PSP';
4286: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4287: fnd_message.set_token('ERROR',l_error);
4288: fnd_message.set_token('PRODUCT',l_product);
4289: fnd_msg_pub.add;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END;

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

4284: l_error := 'TIME_BASED_SUMM';
4285: l_product := 'PSP';
4286: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4287: fnd_message.set_token('ERROR',l_error);
4288: fnd_message.set_token('PRODUCT',l_product);
4289: fnd_msg_pub.add;
4290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4291: END;
4292:

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

4299: EXCEPTION
4300: WHEN NO_DATA_FOUND THEN
4301: l_error := 'CI_BASED_SUMM_OGM';
4302: l_product := 'PSP';
4303: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4304: fnd_message.set_token('ERROR',l_error);
4305: fnd_message.set_token('PRODUCT',l_product);
4306: fnd_msg_pub.add;
4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4300: WHEN NO_DATA_FOUND THEN
4301: l_error := 'CI_BASED_SUMM_OGM';
4302: l_product := 'PSP';
4303: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4304: fnd_message.set_token('ERROR',l_error);
4305: fnd_message.set_token('PRODUCT',l_product);
4306: fnd_msg_pub.add;
4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4308: END;

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

4301: l_error := 'CI_BASED_SUMM_OGM';
4302: l_product := 'PSP';
4303: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4304: fnd_message.set_token('ERROR',l_error);
4305: fnd_message.set_token('PRODUCT',l_product);
4306: fnd_msg_pub.add;
4307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4308: END;
4309:

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

4774: FETCH transaction_source_cur INTO l_gms_transaction_source;
4775: CLOSE transaction_source_cur;
4776:
4777: IF (l_gms_transaction_source IS NULL) THEN
4778: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4779: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4780: fnd_message.set_token('PRODUCT','GMS');
4781: fnd_msg_pub.add;
4782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4779: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');

4775: CLOSE transaction_source_cur;
4776:
4777: IF (l_gms_transaction_source IS NULL) THEN
4778: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4779: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4780: fnd_message.set_token('PRODUCT','GMS');
4781: fnd_msg_pub.add;
4782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4783: END IF;

Line 4780: fnd_message.set_token('PRODUCT','GMS');

4776:
4777: IF (l_gms_transaction_source IS NULL) THEN
4778: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4779: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4780: fnd_message.set_token('PRODUCT','GMS');
4781: fnd_msg_pub.add;
4782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4783: END IF;
4784: END IF;

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

4885: */
4886:
4887:
4888: IF r_interface.employee_number(recno) IS NULL THEN
4889: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4890: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
4891: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
4892: fnd_msg_pub.add;
4893: l_raise_error := TRUE;

Line 4890: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));

4886:
4887:
4888: IF r_interface.employee_number(recno) IS NULL THEN
4889: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4890: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
4891: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
4892: fnd_msg_pub.add;
4893: l_raise_error := TRUE;
4894: END IF;

Line 4891: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');

4887:
4888: IF r_interface.employee_number(recno) IS NULL THEN
4889: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4890: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
4891: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
4892: fnd_msg_pub.add;
4893: l_raise_error := TRUE;
4894: END IF;
4895:

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

4893: l_raise_error := TRUE;
4894: END IF;
4895:
4896: IF r_interface.exp_org_name(recno) IS NULL THEN
4897: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4898: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4899: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4900: fnd_msg_pub.add;
4901: l_raise_error := TRUE;

Line 4898: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));

4894: END IF;
4895:
4896: IF r_interface.exp_org_name(recno) IS NULL THEN
4897: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4898: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4899: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4900: fnd_msg_pub.add;
4901: l_raise_error := TRUE;
4902: END IF;

Line 4899: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');

4895:
4896: IF r_interface.exp_org_name(recno) IS NULL THEN
4897: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4898: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4899: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4900: fnd_msg_pub.add;
4901: l_raise_error := TRUE;
4902: END IF;
4903:

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

4901: l_raise_error := TRUE;
4902: END IF;
4903:
4904: IF r_interface.operating_unit(recno) IS NULL THEN
4905: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4906: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4907: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4908: fnd_msg_pub.add;
4909: l_raise_error := TRUE;

Line 4906: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));

4902: END IF;
4903:
4904: IF r_interface.operating_unit(recno) IS NULL THEN
4905: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4906: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4907: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4908: fnd_msg_pub.add;
4909: l_raise_error := TRUE;
4910: END IF;

Line 4907: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');

4903:
4904: IF r_interface.operating_unit(recno) IS NULL THEN
4905: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4906: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4907: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4908: fnd_msg_pub.add;
4909: l_raise_error := TRUE;
4910: END IF;
4911:

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

4909: l_raise_error := TRUE;
4910: END IF;
4911:
4912: IF r_interface.project_number(recno) IS NULL THEN
4913: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4914: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4915: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4916: fnd_msg_pub.add;
4917: l_raise_error := TRUE;

Line 4914: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));

4910: END IF;
4911:
4912: IF r_interface.project_number(recno) IS NULL THEN
4913: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4914: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4915: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4916: fnd_msg_pub.add;
4917: l_raise_error := TRUE;
4918: END IF;

Line 4915: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');

4911:
4912: IF r_interface.project_number(recno) IS NULL THEN
4913: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4914: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4915: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4916: fnd_msg_pub.add;
4917: l_raise_error := TRUE;
4918: END IF;
4919:

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

4917: l_raise_error := TRUE;
4918: END IF;
4919:
4920: IF r_interface.task_number(recno) IS NULL THEN
4921: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4922: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4923: fnd_message.set_token('TABLE', 'PA_TASKS');
4924: fnd_msg_pub.add;
4925: l_raise_error := TRUE;

Line 4922: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));

4918: END IF;
4919:
4920: IF r_interface.task_number(recno) IS NULL THEN
4921: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4922: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4923: fnd_message.set_token('TABLE', 'PA_TASKS');
4924: fnd_msg_pub.add;
4925: l_raise_error := TRUE;
4926: END IF;

Line 4923: fnd_message.set_token('TABLE', 'PA_TASKS');

4919:
4920: IF r_interface.task_number(recno) IS NULL THEN
4921: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4922: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4923: fnd_message.set_token('TABLE', 'PA_TASKS');
4924: fnd_msg_pub.add;
4925: l_raise_error := TRUE;
4926: END IF;
4927: END LOOP;

Line 5026: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');

5022:
5023: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5024:
5025: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5026: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5027: fnd_msg_pub.add;
5028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5029: END IF;
5030: END LOOP;

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

5047: gms_batch_name_tab(request_counter));
5048:
5049: IF req_id_tab(request_counter) = 0 THEN
5050: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
5051: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5052: fnd_msg_pub.add;
5053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5054: ELSE
5055: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');

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

5088: call_status := fnd_concurrent.wait_for_request(req_id_tab(I), 10, 0, rphase, rstatus, dphase, dstatus, message);
5089:
5090: IF call_status = FALSE then
5091: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
5092: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5093: fnd_msg_pub.add;
5094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5095: END IF;
5096: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');

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

5724: --COMMIT;
5725:
5726: IF l_suspense_ac_failed = 'Y' THEN
5727: g_susp_prob := 'Y'; -- for 2479579
5728: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5729: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5730: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5731: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5732: fnd_msg_pub.add;

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

5725:
5726: IF l_suspense_ac_failed = 'Y' THEN
5727: g_susp_prob := 'Y'; -- for 2479579
5728: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5729: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5730: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5731: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5732: fnd_msg_pub.add;
5733:

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

5726: IF l_suspense_ac_failed = 'Y' THEN
5727: g_susp_prob := 'Y'; -- for 2479579
5728: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5729: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5730: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5731: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5732: fnd_msg_pub.add;
5733:
5734:

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

5727: g_susp_prob := 'Y'; -- for 2479579
5728: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5729: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5730: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5731: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5732: fnd_msg_pub.add;
5733:
5734:
5735: / * Added the following for Bug 3194807 * /

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

5754: -- uncommented for 2479579, which was earlier commented for bug # 2142865
5755: IF l_suspense_ac_not_found = 'Y' THEN
5756: g_susp_prob := 'Y'; -- for 2479579
5757: / * commented this message stack for 2479579
5758: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5759: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5760: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5761: fnd_msg_pub.add; * /
5762: / * Included the following check as part of Bug fix #1776606 * /

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

5755: IF l_suspense_ac_not_found = 'Y' THEN
5756: g_susp_prob := 'Y'; -- for 2479579
5757: / * commented this message stack for 2479579
5758: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5759: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5760: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5761: fnd_msg_pub.add; * /
5762: / * Included the following check as part of Bug fix #1776606 * /
5763: ---added following if stmnt for 2479579

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

5756: g_susp_prob := 'Y'; -- for 2479579
5757: / * commented this message stack for 2479579
5758: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5759: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5760: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5761: fnd_msg_pub.add; * /
5762: / * Included the following check as part of Bug fix #1776606 * /
5763: ---added following if stmnt for 2479579
5764: IF l_susp_exception = 'NO_G_AC' then

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

5881:
5882: / * Added Exceptions for bug 2056877 * /
5883: WHEN NO_PROFILE_EXISTS THEN
5884: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5885: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5886: fnd_msg_pub.add;
5887: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5888: p_return_status := fnd_api.g_ret_sts_success;
5889:

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

5888: p_return_status := fnd_api.g_ret_sts_success;
5889:
5890: WHEN NO_VAL_DATE_MATCHES THEN
5891: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5892: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5893: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5894: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5895: fnd_msg_pub.add;
5896: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

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

5889:
5890: WHEN NO_VAL_DATE_MATCHES THEN
5891: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5892: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5893: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5894: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5895: fnd_msg_pub.add;
5896: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5897: p_return_status := fnd_api.g_ret_sts_success;

Line 5894: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);

5890: WHEN NO_VAL_DATE_MATCHES THEN
5891: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5892: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5893: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5894: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5895: fnd_msg_pub.add;
5896: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5897: p_return_status := fnd_api.g_ret_sts_success;
5898:

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

5897: p_return_status := fnd_api.g_ret_sts_success;
5898:
5899: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5900: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5901: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5902: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5903: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5904: fnd_msg_pub.add;
5905: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

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

5898:
5899: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5900: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5901: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5902: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5903: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5904: fnd_msg_pub.add;
5905: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5906: p_return_status := fnd_api.g_ret_sts_success;

Line 5903: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);

5899: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5900: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5901: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5902: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5903: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5904: fnd_msg_pub.add;
5905: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5906: p_return_status := fnd_api.g_ret_sts_success;
5907:

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

6303: CLOSE get_susp_org_cur;
6304:
6305: l_suspense_ac_failed := 'Y';
6306: g_susp_prob := 'Y';
6307: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6308: fnd_message.set_token('ORG_NAME', l_organization_name);
6309: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6310: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6311: fnd_msg_pub.add;

Line 6308: fnd_message.set_token('ORG_NAME', l_organization_name);

6304:
6305: l_suspense_ac_failed := 'Y';
6306: g_susp_prob := 'Y';
6307: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6308: fnd_message.set_token('ORG_NAME', l_organization_name);
6309: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6310: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6311: fnd_msg_pub.add;
6312: ELSE

Line 6309: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));

6305: l_suspense_ac_failed := 'Y';
6306: g_susp_prob := 'Y';
6307: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6308: fnd_message.set_token('ORG_NAME', l_organization_name);
6309: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6310: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6311: fnd_msg_pub.add;
6312: ELSE
6313: l_susp_ac_found := 'TRUE';

Line 6310: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));

6306: g_susp_prob := 'Y';
6307: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6308: fnd_message.set_token('ORG_NAME', l_organization_name);
6309: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6310: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6311: fnd_msg_pub.add;
6312: ELSE
6313: l_susp_ac_found := 'TRUE';
6314:

Line 6388: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');

6384: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6385: l_autopop_error := 'AUTO_POP_NO_VALUE';
6386: END IF;
6387: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6388: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6389: fnd_message.set_token('START_DATE', l_effective_date);
6390: fnd_message.set_token('END_DATE', l_effective_date);
6391: fnd_message.set_token('GL', l_gl_description);
6392: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);

Line 6389: fnd_message.set_token('START_DATE', l_effective_date);

6385: l_autopop_error := 'AUTO_POP_NO_VALUE';
6386: END IF;
6387: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6388: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6389: fnd_message.set_token('START_DATE', l_effective_date);
6390: fnd_message.set_token('END_DATE', l_effective_date);
6391: fnd_message.set_token('GL', l_gl_description);
6392: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6393: g_warning_message := fnd_message.get;

Line 6390: fnd_message.set_token('END_DATE', l_effective_date);

6386: END IF;
6387: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6388: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6389: fnd_message.set_token('START_DATE', l_effective_date);
6390: fnd_message.set_token('END_DATE', l_effective_date);
6391: fnd_message.set_token('GL', l_gl_description);
6392: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6393: g_warning_message := fnd_message.get;
6394: fnd_file.put_line(fnd_file.log, g_warning_message);

Line 6391: fnd_message.set_token('GL', l_gl_description);

6387: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6388: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6389: fnd_message.set_token('START_DATE', l_effective_date);
6390: fnd_message.set_token('END_DATE', l_effective_date);
6391: fnd_message.set_token('GL', l_gl_description);
6392: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6393: g_warning_message := fnd_message.get;
6394: fnd_file.put_line(fnd_file.log, g_warning_message);
6395: ELSE

Line 6392: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);

6388: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6389: fnd_message.set_token('START_DATE', l_effective_date);
6390: fnd_message.set_token('END_DATE', l_effective_date);
6391: fnd_message.set_token('GL', l_gl_description);
6392: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6393: g_warning_message := fnd_message.get;
6394: fnd_file.put_line(fnd_file.log, g_warning_message);
6395: ELSE
6396: l_susp_glccid := l_new_gl_code_combination_id;

Line 6393: g_warning_message := fnd_message.get;

6389: fnd_message.set_token('START_DATE', l_effective_date);
6390: fnd_message.set_token('END_DATE', l_effective_date);
6391: fnd_message.set_token('GL', l_gl_description);
6392: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6393: g_warning_message := fnd_message.get;
6394: fnd_file.put_line(fnd_file.log, g_warning_message);
6395: ELSE
6396: l_susp_glccid := l_new_gl_code_combination_id;
6397: END IF;

Line 6449: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');

6445: OPEN exp_org_name_cur;
6446: FETCH exp_org_name_cur INTO l_exp_org_name;
6447: CLOSE exp_org_name_cur;
6448:
6449: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6450: fnd_message.set_token('START_DATE', l_effective_date);
6451: fnd_message.set_token('END_DATE', l_effective_date);
6452: fnd_message.set_token('PJ', l_project_number);
6453: fnd_message.set_token('TK', l_task_number);

Line 6450: fnd_message.set_token('START_DATE', l_effective_date);

6446: FETCH exp_org_name_cur INTO l_exp_org_name;
6447: CLOSE exp_org_name_cur;
6448:
6449: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6450: fnd_message.set_token('START_DATE', l_effective_date);
6451: fnd_message.set_token('END_DATE', l_effective_date);
6452: fnd_message.set_token('PJ', l_project_number);
6453: fnd_message.set_token('TK', l_task_number);
6454: fnd_message.set_token('AW', l_award_number);

Line 6451: fnd_message.set_token('END_DATE', l_effective_date);

6447: CLOSE exp_org_name_cur;
6448:
6449: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6450: fnd_message.set_token('START_DATE', l_effective_date);
6451: fnd_message.set_token('END_DATE', l_effective_date);
6452: fnd_message.set_token('PJ', l_project_number);
6453: fnd_message.set_token('TK', l_task_number);
6454: fnd_message.set_token('AW', l_award_number);
6455: fnd_message.set_token('EO', l_exp_org_name);

Line 6452: fnd_message.set_token('PJ', l_project_number);

6448:
6449: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6450: fnd_message.set_token('START_DATE', l_effective_date);
6451: fnd_message.set_token('END_DATE', l_effective_date);
6452: fnd_message.set_token('PJ', l_project_number);
6453: fnd_message.set_token('TK', l_task_number);
6454: fnd_message.set_token('AW', l_award_number);
6455: fnd_message.set_token('EO', l_exp_org_name);
6456: fnd_message.set_token('ET', l_expenditure_type);

Line 6453: fnd_message.set_token('TK', l_task_number);

6449: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6450: fnd_message.set_token('START_DATE', l_effective_date);
6451: fnd_message.set_token('END_DATE', l_effective_date);
6452: fnd_message.set_token('PJ', l_project_number);
6453: fnd_message.set_token('TK', l_task_number);
6454: fnd_message.set_token('AW', l_award_number);
6455: fnd_message.set_token('EO', l_exp_org_name);
6456: fnd_message.set_token('ET', l_expenditure_type);
6457: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);

Line 6454: fnd_message.set_token('AW', l_award_number);

6450: fnd_message.set_token('START_DATE', l_effective_date);
6451: fnd_message.set_token('END_DATE', l_effective_date);
6452: fnd_message.set_token('PJ', l_project_number);
6453: fnd_message.set_token('TK', l_task_number);
6454: fnd_message.set_token('AW', l_award_number);
6455: fnd_message.set_token('EO', l_exp_org_name);
6456: fnd_message.set_token('ET', l_expenditure_type);
6457: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6458: g_warning_message := fnd_message.get;

Line 6455: fnd_message.set_token('EO', l_exp_org_name);

6451: fnd_message.set_token('END_DATE', l_effective_date);
6452: fnd_message.set_token('PJ', l_project_number);
6453: fnd_message.set_token('TK', l_task_number);
6454: fnd_message.set_token('AW', l_award_number);
6455: fnd_message.set_token('EO', l_exp_org_name);
6456: fnd_message.set_token('ET', l_expenditure_type);
6457: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6458: g_warning_message := fnd_message.get;
6459: fnd_file.put_line(fnd_file.log, g_warning_message);

Line 6456: fnd_message.set_token('ET', l_expenditure_type);

6452: fnd_message.set_token('PJ', l_project_number);
6453: fnd_message.set_token('TK', l_task_number);
6454: fnd_message.set_token('AW', l_award_number);
6455: fnd_message.set_token('EO', l_exp_org_name);
6456: fnd_message.set_token('ET', l_expenditure_type);
6457: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6458: g_warning_message := fnd_message.get;
6459: fnd_file.put_line(fnd_file.log, g_warning_message);
6460: ELSE

Line 6457: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);

6453: fnd_message.set_token('TK', l_task_number);
6454: fnd_message.set_token('AW', l_award_number);
6455: fnd_message.set_token('EO', l_exp_org_name);
6456: fnd_message.set_token('ET', l_expenditure_type);
6457: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6458: g_warning_message := fnd_message.get;
6459: fnd_file.put_line(fnd_file.log, g_warning_message);
6460: ELSE
6461: l_expenditure_type := l_new_expenditure_type;

Line 6458: g_warning_message := fnd_message.get;

6454: fnd_message.set_token('AW', l_award_number);
6455: fnd_message.set_token('EO', l_exp_org_name);
6456: fnd_message.set_token('ET', l_expenditure_type);
6457: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6458: g_warning_message := fnd_message.get;
6459: fnd_file.put_line(fnd_file.log, g_warning_message);
6460: ELSE
6461: l_expenditure_type := l_new_expenditure_type;
6462: END IF;

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

6680: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6681: EXCEPTION
6682: WHEN NO_PROFILE_EXISTS THEN
6683: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6684: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
6685: fnd_msg_pub.add;
6686: p_return_status := fnd_api.g_ret_sts_success;
6687: WHEN NO_VAL_DATE_MATCHES THEN
6688: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

6685: fnd_msg_pub.add;
6686: p_return_status := fnd_api.g_ret_sts_success;
6687: WHEN NO_VAL_DATE_MATCHES THEN
6688: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6689: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6690: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6691: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6692: fnd_msg_pub.add;
6693: p_return_status := fnd_api.g_ret_sts_success;

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

6686: p_return_status := fnd_api.g_ret_sts_success;
6687: WHEN NO_VAL_DATE_MATCHES THEN
6688: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6689: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6690: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6691: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6692: fnd_msg_pub.add;
6693: p_return_status := fnd_api.g_ret_sts_success;
6694: WHEN NO_GLOBAL_ACCT_EXISTS THEN

Line 6691: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);

6687: WHEN NO_VAL_DATE_MATCHES THEN
6688: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6689: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6690: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6691: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6692: fnd_msg_pub.add;
6693: p_return_status := fnd_api.g_ret_sts_success;
6694: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6695: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

6692: fnd_msg_pub.add;
6693: p_return_status := fnd_api.g_ret_sts_success;
6694: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6695: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6696: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6697: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6698: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6699: fnd_msg_pub.add;
6700: p_return_status := fnd_api.g_ret_sts_success;

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

6693: p_return_status := fnd_api.g_ret_sts_success;
6694: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6695: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6696: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6697: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6698: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6699: fnd_msg_pub.add;
6700: p_return_status := fnd_api.g_ret_sts_success;
6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6698: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);

6694: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6695: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6696: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6697: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6698: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6699: fnd_msg_pub.add;
6700: p_return_status := fnd_api.g_ret_sts_success;
6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6702: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;

Line 7195: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');

7191: OPEN exp_org_name_cur(st_warnings.exp_org_id(recno));
7192: FETCH exp_org_name_cur INTO l_exp_org_name;
7193: CLOSE exp_org_name_cur;
7194:
7195: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7196: fnd_message.set_token('PJ', l_project_number);
7197: fnd_message.set_token('TK', l_task_number);
7198: fnd_message.set_token('AW', l_award_number);
7199: fnd_message.set_token('EO', l_exp_org_name);

Line 7196: fnd_message.set_token('PJ', l_project_number);

7192: FETCH exp_org_name_cur INTO l_exp_org_name;
7193: CLOSE exp_org_name_cur;
7194:
7195: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7196: fnd_message.set_token('PJ', l_project_number);
7197: fnd_message.set_token('TK', l_task_number);
7198: fnd_message.set_token('AW', l_award_number);
7199: fnd_message.set_token('EO', l_exp_org_name);
7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));

Line 7197: fnd_message.set_token('TK', l_task_number);

7193: CLOSE exp_org_name_cur;
7194:
7195: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7196: fnd_message.set_token('PJ', l_project_number);
7197: fnd_message.set_token('TK', l_task_number);
7198: fnd_message.set_token('AW', l_award_number);
7199: fnd_message.set_token('EO', l_exp_org_name);
7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));
7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));

Line 7198: fnd_message.set_token('AW', l_award_number);

7194:
7195: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7196: fnd_message.set_token('PJ', l_project_number);
7197: fnd_message.set_token('TK', l_task_number);
7198: fnd_message.set_token('AW', l_award_number);
7199: fnd_message.set_token('EO', l_exp_org_name);
7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));
7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));

Line 7199: fnd_message.set_token('EO', l_exp_org_name);

7195: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
7196: fnd_message.set_token('PJ', l_project_number);
7197: fnd_message.set_token('TK', l_task_number);
7198: fnd_message.set_token('AW', l_award_number);
7199: fnd_message.set_token('EO', l_exp_org_name);
7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));
7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));

Line 7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));

7196: fnd_message.set_token('PJ', l_project_number);
7197: fnd_message.set_token('TK', l_task_number);
7198: fnd_message.set_token('AW', l_award_number);
7199: fnd_message.set_token('EO', l_exp_org_name);
7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));
7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7204: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));

Line 7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));

7197: fnd_message.set_token('TK', l_task_number);
7198: fnd_message.set_token('AW', l_award_number);
7199: fnd_message.set_token('EO', l_exp_org_name);
7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));
7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7204: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7205: g_warning_message := fnd_message.get;

Line 7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));

7198: fnd_message.set_token('AW', l_award_number);
7199: fnd_message.set_token('EO', l_exp_org_name);
7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));
7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7204: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7205: g_warning_message := fnd_message.get;
7206: ELSE

Line 7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));

7199: fnd_message.set_token('EO', l_exp_org_name);
7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));
7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7204: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7205: g_warning_message := fnd_message.get;
7206: ELSE
7207: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));

Line 7204: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));

7200: fnd_message.set_token('ET', st_warnings.exp_type(recno));
7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7204: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7205: g_warning_message := fnd_message.get;
7206: ELSE
7207: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
7208:

Line 7205: g_warning_message := fnd_message.get;

7201: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7202: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7203: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7204: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7205: g_warning_message := fnd_message.get;
7206: ELSE
7207: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
7208:
7209: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');

Line 7209: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');

7205: g_warning_message := fnd_message.get;
7206: ELSE
7207: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
7208:
7209: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
7210: fnd_message.set_token('GL', l_gl_description);
7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7212: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7213: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));

Line 7210: fnd_message.set_token('GL', l_gl_description);

7206: ELSE
7207: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
7208:
7209: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
7210: fnd_message.set_token('GL', l_gl_description);
7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7212: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7213: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7214: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));

Line 7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));

7207: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
7208:
7209: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
7210: fnd_message.set_token('GL', l_gl_description);
7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7212: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7213: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7214: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7215: g_warning_message := fnd_message.get;

Line 7212: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));

7208:
7209: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
7210: fnd_message.set_token('GL', l_gl_description);
7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7212: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7213: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7214: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7215: g_warning_message := fnd_message.get;
7216: END IF;

Line 7213: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));

7209: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
7210: fnd_message.set_token('GL', l_gl_description);
7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7212: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7213: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7214: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7215: g_warning_message := fnd_message.get;
7216: END IF;
7217:

Line 7214: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));

7210: fnd_message.set_token('GL', l_gl_description);
7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7212: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7213: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7214: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7215: g_warning_message := fnd_message.get;
7216: END IF;
7217:
7218: psp_general.add_report_error

Line 7215: g_warning_message := fnd_message.get;

7211: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
7212: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
7213: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
7214: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
7215: g_warning_message := fnd_message.get;
7216: END IF;
7217:
7218: psp_general.add_report_error
7219: (p_request_id => l_request_id,