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

281: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then
282: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
283: pqh_psp_integration.relieve_budget_commitments( 'S', l_return_status);
284: If l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
285: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
286: fnd_msg_pub.add;
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: end if;
289: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');

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

517: LOOP
518: FETCH enc_control_cur INTO enc_control_rec;
519: IF enc_control_cur%rowcount = 0 THEN
520: g_control_rec_found := 'FALSE';
521: fnd_message.set_name('PSP','PSP_ENC_NO_SUMM_REC_FOUND');
522: fnd_msg_pub.add;
523: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
524: -- for bug fix 1868338 -- Subha
525: p_return_status := fnd_api.g_ret_sts_success;

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

1194: EXCEPTION
1195: WHEN NO_DATA_FOUND THEN
1196: l_error := 'TIME_BASED_SUMM';
1197: l_product := 'PSP';
1198: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1199: fnd_message.set_token('ERROR',l_error);
1200: fnd_message.set_token('PRODUCT',l_product);
1201: fnd_msg_pub.add;
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1195: WHEN NO_DATA_FOUND THEN
1196: l_error := 'TIME_BASED_SUMM';
1197: l_product := 'PSP';
1198: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1199: fnd_message.set_token('ERROR',l_error);
1200: fnd_message.set_token('PRODUCT',l_product);
1201: fnd_msg_pub.add;
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203: END;

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

1196: l_error := 'TIME_BASED_SUMM';
1197: l_product := 'PSP';
1198: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1199: fnd_message.set_token('ERROR',l_error);
1200: fnd_message.set_token('PRODUCT',l_product);
1201: fnd_msg_pub.add;
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203: END;
1204:

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

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

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

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

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

1213: l_error := 'CI_BASED_SUMM_GL';
1214: l_product := 'PSP';
1215: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
1216: fnd_message.set_token('ERROR',l_error);
1217: fnd_message.set_token('PRODUCT',l_product);
1218: fnd_msg_pub.add;
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: END;
1221:

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

2012: EXCEPTION
2013: WHEN NO_DATA_FOUND THEN
2014: l_error := 'CURRENCY CODE';
2015: l_product := 'GL';
2016: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2017: fnd_message.set_token('ERROR',l_error);
2018: fnd_message.set_token('PRODUCT',l_product);
2019: fnd_msg_pub.add;
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2013: WHEN NO_DATA_FOUND THEN
2014: l_error := 'CURRENCY CODE';
2015: l_product := 'GL';
2016: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2017: fnd_message.set_token('ERROR',l_error);
2018: fnd_message.set_token('PRODUCT',l_product);
2019: fnd_msg_pub.add;
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END; * /

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

2014: l_error := 'CURRENCY CODE';
2015: l_product := 'GL';
2016: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2017: fnd_message.set_token('ERROR',l_error);
2018: fnd_message.set_token('PRODUCT',l_product);
2019: fnd_msg_pub.add;
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END; * /
2022:

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

2030: EXCEPTION
2031: WHEN NO_DATA_FOUND THEN
2032: l_value := 'time period id =';
2033: l_table := 'PER_TIME_PERIODS';
2034: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2035: fnd_message.set_token('VALUE','l_value');
2036: fnd_message.set_token('TABLE','l_table');
2037: fnd_msg_pub.add;
2038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2031: WHEN NO_DATA_FOUND THEN
2032: l_value := 'time period id =';
2033: l_table := 'PER_TIME_PERIODS';
2034: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2035: fnd_message.set_token('VALUE','l_value');
2036: fnd_message.set_token('TABLE','l_table');
2037: fnd_msg_pub.add;
2038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2039: END;

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

2032: l_value := 'time period id =';
2033: l_table := 'PER_TIME_PERIODS';
2034: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2035: fnd_message.set_token('VALUE','l_value');
2036: fnd_message.set_token('TABLE','l_table');
2037: fnd_msg_pub.add;
2038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2039: END;
2040:

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

2184: 'W'); -- Changed 'n' to 'W' for bug fix 2908859
2185:
2186: IF req_id = 0 THEN
2187:
2188: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2189: fnd_msg_pub.add;
2190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2191:
2192: ELSE

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

2215: call_status := fnd_concurrent.wait_for_request(req_id, 20, 0,
2216: rphase, rstatus, dphase, dstatus, message);
2217:
2218: IF call_status = FALSE then
2219: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2220: fnd_msg_pub.add;
2221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2222: END IF;
2223: END IF;

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

2470: 'W');
2471:
2472: IF req_id = 0 THEN
2473: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import submission failed');
2474: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2475: fnd_msg_pub.add;
2476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2477: ELSE
2478: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Journal Import (req_id: ' || req_id || ')');

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

2502: call_status := fnd_concurrent.wait_for_request(req_id, 10, 0, rphase, rstatus, dphase, dstatus, message);
2503:
2504: IF call_status = FALSE THEN
2505: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
2506: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
2507: fnd_msg_pub.add;
2508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2509: END IF;
2510: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');

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

2586: EXCEPTION
2587: WHEN NO_DATA_FOUND THEN
2588: l_error := 'JE SOURCES = OLD';
2589: l_product := 'GL';
2590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2591: fnd_message.set_token('ERROR',l_error);
2592: fnd_message.set_token('PRODUCT',l_product);
2593: fnd_msg_pub.add;
2594: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

2587: WHEN NO_DATA_FOUND THEN
2588: l_error := 'JE SOURCES = OLD';
2589: l_product := 'GL';
2590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2591: fnd_message.set_token('ERROR',l_error);
2592: fnd_message.set_token('PRODUCT',l_product);
2593: fnd_msg_pub.add;
2594: p_return_status := fnd_api.g_ret_sts_unexp_error;
2595: WHEN OTHERS THEN

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

2588: l_error := 'JE SOURCES = OLD';
2589: l_product := 'GL';
2590: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2591: fnd_message.set_token('ERROR',l_error);
2592: fnd_message.set_token('PRODUCT',l_product);
2593: fnd_msg_pub.add;
2594: p_return_status := fnd_api.g_ret_sts_unexp_error;
2595: WHEN OTHERS THEN
2596: g_error_api_path := 'gl_je_source:'||g_error_api_path;

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

2614: EXCEPTION
2615: WHEN NO_DATA_FOUND THEN
2616: l_error := 'JE CATEGORY = OLD';
2617: l_product := 'GL';
2618: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2619: fnd_message.set_token('ERROR',l_error);
2620: fnd_message.set_token('PRODUCT',l_product);
2621: fnd_msg_pub.add;
2622: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

2615: WHEN NO_DATA_FOUND THEN
2616: l_error := 'JE CATEGORY = OLD';
2617: l_product := 'GL';
2618: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2619: fnd_message.set_token('ERROR',l_error);
2620: fnd_message.set_token('PRODUCT',l_product);
2621: fnd_msg_pub.add;
2622: p_return_status := fnd_api.g_ret_sts_unexp_error;
2623: WHEN OTHERS THEN

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

2616: l_error := 'JE CATEGORY = OLD';
2617: l_product := 'GL';
2618: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2619: fnd_message.set_token('ERROR',l_error);
2620: fnd_message.set_token('PRODUCT',l_product);
2621: fnd_msg_pub.add;
2622: p_return_status := fnd_api.g_ret_sts_unexp_error;
2623: WHEN OTHERS THEN
2624: g_error_api_path := 'gl_je_cat:'||g_error_api_path;

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

2645: EXCEPTION
2646: WHEN NO_DATA_FOUND THEN
2647: l_error := 'ENCUMBRANCE TYPE = OLD';
2648: l_product := 'GL';
2649: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2650: fnd_message.set_token('ERROR',l_error);
2651: fnd_message.set_token('PRODUCT',l_product);
2652: fnd_msg_pub.add;
2653: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

2646: WHEN NO_DATA_FOUND THEN
2647: l_error := 'ENCUMBRANCE TYPE = OLD';
2648: l_product := 'GL';
2649: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2650: fnd_message.set_token('ERROR',l_error);
2651: fnd_message.set_token('PRODUCT',l_product);
2652: fnd_msg_pub.add;
2653: p_return_status := fnd_api.g_ret_sts_unexp_error;
2654: WHEN OTHERS THEN

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

2647: l_error := 'ENCUMBRANCE TYPE = OLD';
2648: l_product := 'GL';
2649: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2650: fnd_message.set_token('ERROR',l_error);
2651: fnd_message.set_token('PRODUCT',l_product);
2652: fnd_msg_pub.add;
2653: p_return_status := fnd_api.g_ret_sts_unexp_error;
2654: WHEN OTHERS THEN
2655: g_error_api_path := 'enc_type:'||g_error_api_path;

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

3109: SET gl_phase = 'TieBack'
3110: WHERE enc_control_id = p_enc_control_id;* /
3111: / * GL encumbrance does not have reversal lines: bug 2030232
3112: IF l_reversal_ac_failed = 'Y' THEN
3113: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
3114: fnd_message.set_token('GLCCID',x_lines_glccid);
3115: fnd_msg_pub.add;
3116: -- Included the following check as part of Bug fix #1776606 --
3117: IF p_mode = 'N' THEN

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

3110: WHERE enc_control_id = p_enc_control_id;* /
3111: / * GL encumbrance does not have reversal lines: bug 2030232
3112: IF l_reversal_ac_failed = 'Y' THEN
3113: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
3114: fnd_message.set_token('GLCCID',x_lines_glccid);
3115: fnd_msg_pub.add;
3116: -- Included the following check as part of Bug fix #1776606 --
3117: IF p_mode = 'N' THEN
3118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3121: * /
3122:
3123: IF l_suspense_ac_failed = 'Y' THEN
3124: g_susp_prob := 'Y'; -- for 2479579
3125: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3126: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3127: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3128: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3129: fnd_msg_pub.add;

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

3122:
3123: IF l_suspense_ac_failed = 'Y' THEN
3124: g_susp_prob := 'Y'; -- for 2479579
3125: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3126: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3127: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3128: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3129: fnd_msg_pub.add;
3130:

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

3123: IF l_suspense_ac_failed = 'Y' THEN
3124: g_susp_prob := 'Y'; -- for 2479579
3125: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3126: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3127: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3128: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3129: fnd_msg_pub.add;
3130:
3131:

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

3124: g_susp_prob := 'Y'; -- for 2479579
3125: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
3126: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
3127: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
3128: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
3129: fnd_msg_pub.add;
3130:
3131:
3132: / * Added the following for Bug 3194807 * /

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

3149: -- uncommented for 2479579, which was earlier commented for bug # 2142865
3150: IF l_suspense_ac_not_found = 'Y' THEN
3151: g_susp_prob := 'Y'; -- for 2479579
3152: / * commented this message stack for 2479579
3153: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
3154: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
3155: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
3156: fnd_msg_pub.add; * /
3157: ---added following if stmnt for 2479579

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

3150: IF l_suspense_ac_not_found = 'Y' THEN
3151: g_susp_prob := 'Y'; -- for 2479579
3152: / * commented this message stack for 2479579
3153: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
3154: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
3155: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
3156: fnd_msg_pub.add; * /
3157: ---added following if stmnt for 2479579
3158: IF l_susp_exception = 'NO_G_AC' then

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

3151: g_susp_prob := 'Y'; -- for 2479579
3152: / * commented this message stack for 2479579
3153: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
3154: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
3155: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
3156: fnd_msg_pub.add; * /
3157: ---added following if stmnt for 2479579
3158: IF l_susp_exception = 'NO_G_AC' then
3159: RAISE no_global_acct_exists;

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

3261:
3262: / * Added Exceptions for bug 2056877 * /
3263: WHEN NO_PROFILE_EXISTS THEN
3264: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3265: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3266: fnd_msg_pub.add;
3267: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3268: p_return_status := fnd_api.g_ret_sts_success;
3269:

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

3268: p_return_status := fnd_api.g_ret_sts_success;
3269:
3270: WHEN NO_VAL_DATE_MATCHES THEN
3271: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3272: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3273: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3274: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3275: fnd_msg_pub.add;
3276: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

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

3269:
3270: WHEN NO_VAL_DATE_MATCHES THEN
3271: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3272: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3273: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3274: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3275: fnd_msg_pub.add;
3276: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3277: p_return_status := fnd_api.g_ret_sts_success;

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

3270: WHEN NO_VAL_DATE_MATCHES THEN
3271: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3272: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3273: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3274: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3275: fnd_msg_pub.add;
3276: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3277: p_return_status := fnd_api.g_ret_sts_success;
3278:

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

3277: p_return_status := fnd_api.g_ret_sts_success;
3278:
3279: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3280: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3281: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3282: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3283: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3284: fnd_msg_pub.add;
3285: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

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

3278:
3279: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3280: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3281: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3282: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3283: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3284: fnd_msg_pub.add;
3285: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3286: p_return_status := fnd_api.g_ret_sts_success;

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

3279: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3280: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3281: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3282: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3283: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3284: fnd_msg_pub.add;
3285: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
3286: p_return_status := fnd_api.g_ret_sts_success;
3287:

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

3548: CLOSE get_susp_org_cur;
3549:
3550: l_suspense_ac_failed := 'Y';
3551: g_susp_prob := 'Y';
3552: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3553: fnd_message.set_token('ORG_NAME', l_organization_name);
3554: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3555: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3556: fnd_msg_pub.add;

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

3549:
3550: l_suspense_ac_failed := 'Y';
3551: g_susp_prob := 'Y';
3552: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3553: fnd_message.set_token('ORG_NAME', l_organization_name);
3554: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3555: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3556: fnd_msg_pub.add;
3557: ELSE

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

3550: l_suspense_ac_failed := 'Y';
3551: g_susp_prob := 'Y';
3552: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3553: fnd_message.set_token('ORG_NAME', l_organization_name);
3554: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3555: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3556: fnd_msg_pub.add;
3557: ELSE
3558: l_susp_ac_found := 'TRUE';

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

3551: g_susp_prob := 'Y';
3552: fnd_message.set_name('PSP', 'PSP_TR_GL_SUSP_AC_REJECT');
3553: fnd_message.set_token('ORG_NAME', l_organization_name);
3554: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
3555: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
3556: fnd_msg_pub.add;
3557: ELSE
3558: l_susp_ac_found := 'TRUE';
3559:

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

3785: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GL_ENC_TIE_BACK');
3786: EXCEPTION
3787: WHEN NO_PROFILE_EXISTS THEN
3788: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3789: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
3790: fnd_msg_pub.add;
3791: p_return_status := fnd_api.g_ret_sts_success;
3792: WHEN NO_VAL_DATE_MATCHES THEN
3793: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

3790: fnd_msg_pub.add;
3791: p_return_status := fnd_api.g_ret_sts_success;
3792: WHEN NO_VAL_DATE_MATCHES THEN
3793: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3794: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3795: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3796: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3797: fnd_msg_pub.add;
3798: p_return_status := fnd_api.g_ret_sts_success;

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

3791: p_return_status := fnd_api.g_ret_sts_success;
3792: WHEN NO_VAL_DATE_MATCHES THEN
3793: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3794: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3795: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3796: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3797: fnd_msg_pub.add;
3798: p_return_status := fnd_api.g_ret_sts_success;
3799: WHEN NO_GLOBAL_ACCT_EXISTS THEN

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

3792: WHEN NO_VAL_DATE_MATCHES THEN
3793: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3794: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
3795: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3796: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3797: fnd_msg_pub.add;
3798: p_return_status := fnd_api.g_ret_sts_success;
3799: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3800: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

3797: fnd_msg_pub.add;
3798: p_return_status := fnd_api.g_ret_sts_success;
3799: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3800: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3801: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3802: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3803: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3804: fnd_msg_pub.add;
3805: p_return_status := fnd_api.g_ret_sts_success;

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

3798: p_return_status := fnd_api.g_ret_sts_success;
3799: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3800: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3801: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3802: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3803: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3804: fnd_msg_pub.add;
3805: p_return_status := fnd_api.g_ret_sts_success;
3806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3799: WHEN NO_GLOBAL_ACCT_EXISTS THEN
3800: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
3801: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
3802: fnd_message.set_token('ORG_NAME',l_orig_org_name);
3803: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
3804: fnd_msg_pub.add;
3805: p_return_status := fnd_api.g_ret_sts_success;
3806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3807: g_error_api_path := 'GL_ENC_TIE_BACK:'||g_error_api_path;

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

4178: EXCEPTION
4179: WHEN NO_DATA_FOUND THEN
4180: l_error := 'TIME_BASED_SUMM';
4181: l_product := 'PSP';
4182: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4183: fnd_message.set_token('ERROR',l_error);
4184: fnd_message.set_token('PRODUCT',l_product);
4185: fnd_msg_pub.add;
4186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4179: WHEN NO_DATA_FOUND THEN
4180: l_error := 'TIME_BASED_SUMM';
4181: l_product := 'PSP';
4182: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4183: fnd_message.set_token('ERROR',l_error);
4184: fnd_message.set_token('PRODUCT',l_product);
4185: fnd_msg_pub.add;
4186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4187: END;

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

4180: l_error := 'TIME_BASED_SUMM';
4181: l_product := 'PSP';
4182: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4183: fnd_message.set_token('ERROR',l_error);
4184: fnd_message.set_token('PRODUCT',l_product);
4185: fnd_msg_pub.add;
4186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4187: END;
4188:

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

4195: EXCEPTION
4196: WHEN NO_DATA_FOUND THEN
4197: l_error := 'CI_BASED_SUMM_OGM';
4198: l_product := 'PSP';
4199: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4200: fnd_message.set_token('ERROR',l_error);
4201: fnd_message.set_token('PRODUCT',l_product);
4202: fnd_msg_pub.add;
4203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4196: WHEN NO_DATA_FOUND THEN
4197: l_error := 'CI_BASED_SUMM_OGM';
4198: l_product := 'PSP';
4199: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4200: fnd_message.set_token('ERROR',l_error);
4201: fnd_message.set_token('PRODUCT',l_product);
4202: fnd_msg_pub.add;
4203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4204: END;

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

4197: l_error := 'CI_BASED_SUMM_OGM';
4198: l_product := 'PSP';
4199: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4200: fnd_message.set_token('ERROR',l_error);
4201: fnd_message.set_token('PRODUCT',l_product);
4202: fnd_msg_pub.add;
4203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4204: END;
4205:

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

4665: FETCH transaction_source_cur INTO l_gms_transaction_source;
4666: CLOSE transaction_source_cur;
4667:
4668: IF (l_gms_transaction_source IS NULL) THEN
4669: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4670: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4671: fnd_message.set_token('PRODUCT','GMS');
4672: fnd_msg_pub.add;
4673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4666: CLOSE transaction_source_cur;
4667:
4668: IF (l_gms_transaction_source IS NULL) THEN
4669: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4670: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4671: fnd_message.set_token('PRODUCT','GMS');
4672: fnd_msg_pub.add;
4673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4674: END IF;

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

4667:
4668: IF (l_gms_transaction_source IS NULL) THEN
4669: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
4670: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
4671: fnd_message.set_token('PRODUCT','GMS');
4672: fnd_msg_pub.add;
4673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4674: END IF;
4675: END IF;

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

4761: END IF;
4762: END LOOP;
4763:
4764: IF r_interface.employee_number(recno) IS NULL THEN
4765: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4766: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
4767: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
4768: fnd_msg_pub.add;
4769: l_raise_error := TRUE;

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

4762: END LOOP;
4763:
4764: IF r_interface.employee_number(recno) IS NULL THEN
4765: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4766: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
4767: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
4768: fnd_msg_pub.add;
4769: l_raise_error := TRUE;
4770: END IF;

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

4763:
4764: IF r_interface.employee_number(recno) IS NULL THEN
4765: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4766: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
4767: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
4768: fnd_msg_pub.add;
4769: l_raise_error := TRUE;
4770: END IF;
4771:

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

4769: l_raise_error := TRUE;
4770: END IF;
4771:
4772: IF r_interface.exp_org_name(recno) IS NULL THEN
4773: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4774: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4775: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4776: fnd_msg_pub.add;
4777: l_raise_error := TRUE;

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

4770: END IF;
4771:
4772: IF r_interface.exp_org_name(recno) IS NULL THEN
4773: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4774: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4775: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4776: fnd_msg_pub.add;
4777: l_raise_error := TRUE;
4778: END IF;

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

4771:
4772: IF r_interface.exp_org_name(recno) IS NULL THEN
4773: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4774: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
4775: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
4776: fnd_msg_pub.add;
4777: l_raise_error := TRUE;
4778: END IF;
4779:

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

4777: l_raise_error := TRUE;
4778: END IF;
4779:
4780: IF r_interface.operating_unit(recno) IS NULL THEN
4781: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4782: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4783: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4784: fnd_msg_pub.add;
4785: l_raise_error := TRUE;

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

4778: END IF;
4779:
4780: IF r_interface.operating_unit(recno) IS NULL THEN
4781: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4782: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4783: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4784: fnd_msg_pub.add;
4785: l_raise_error := TRUE;
4786: END IF;

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

4779:
4780: IF r_interface.operating_unit(recno) IS NULL THEN
4781: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
4782: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4783: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4784: fnd_msg_pub.add;
4785: l_raise_error := TRUE;
4786: END IF;
4787:

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

4785: l_raise_error := TRUE;
4786: END IF;
4787:
4788: IF r_interface.project_number(recno) IS NULL THEN
4789: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4790: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4791: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4792: fnd_msg_pub.add;
4793: l_raise_error := TRUE;

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

4786: END IF;
4787:
4788: IF r_interface.project_number(recno) IS NULL THEN
4789: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4790: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4791: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4792: fnd_msg_pub.add;
4793: l_raise_error := TRUE;
4794: END IF;

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

4787:
4788: IF r_interface.project_number(recno) IS NULL THEN
4789: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4790: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
4791: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
4792: fnd_msg_pub.add;
4793: l_raise_error := TRUE;
4794: END IF;
4795:

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

4793: l_raise_error := TRUE;
4794: END IF;
4795:
4796: IF r_interface.task_number(recno) IS NULL THEN
4797: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4798: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4799: fnd_message.set_token('TABLE', 'PA_TASKS');
4800: fnd_msg_pub.add;
4801: l_raise_error := TRUE;

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

4794: END IF;
4795:
4796: IF r_interface.task_number(recno) IS NULL THEN
4797: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4798: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4799: fnd_message.set_token('TABLE', 'PA_TASKS');
4800: fnd_msg_pub.add;
4801: l_raise_error := TRUE;
4802: END IF;

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

4795:
4796: IF r_interface.task_number(recno) IS NULL THEN
4797: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4798: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
4799: fnd_message.set_token('TABLE', 'PA_TASKS');
4800: fnd_msg_pub.add;
4801: l_raise_error := TRUE;
4802: END IF;
4803: END LOOP;

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

4886:
4887: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
4888:
4889: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4890: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
4891: fnd_msg_pub.add;
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: END IF;
4894: END LOOP;

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

4911: gms_batch_name_tab(request_counter));
4912:
4913: IF req_id_tab(request_counter) = 0 THEN
4914: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
4915: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4916: fnd_msg_pub.add;
4917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4918: ELSE
4919: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');

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

4946: call_status := fnd_concurrent.wait_for_request(req_id_tab(I), 10, 0, rphase, rstatus, dphase, dstatus, message);
4947:
4948: IF call_status = FALSE then
4949: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
4950: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
4951: fnd_msg_pub.add;
4952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4953: END IF;
4954: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');

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

5541: --COMMIT;
5542:
5543: IF l_suspense_ac_failed = 'Y' THEN
5544: g_susp_prob := 'Y'; -- for 2479579
5545: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5546: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5547: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5548: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5549: fnd_msg_pub.add;

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

5542:
5543: IF l_suspense_ac_failed = 'Y' THEN
5544: g_susp_prob := 'Y'; -- for 2479579
5545: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5546: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5547: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5548: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5549: fnd_msg_pub.add;
5550:

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

5543: IF l_suspense_ac_failed = 'Y' THEN
5544: g_susp_prob := 'Y'; -- for 2479579
5545: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5546: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5547: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5548: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5549: fnd_msg_pub.add;
5550:
5551:

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

5544: g_susp_prob := 'Y'; -- for 2479579
5545: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
5546: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
5547: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
5548: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
5549: fnd_msg_pub.add;
5550:
5551:
5552: / * Added the following for Bug 3194807 * /

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

5571: -- uncommented for 2479579, which was earlier commented for bug # 2142865
5572: IF l_suspense_ac_not_found = 'Y' THEN
5573: g_susp_prob := 'Y'; -- for 2479579
5574: / * commented this message stack for 2479579
5575: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5576: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5577: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5578: fnd_msg_pub.add; * /
5579: / * Included the following check as part of Bug fix #1776606 * /

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

5572: IF l_suspense_ac_not_found = 'Y' THEN
5573: g_susp_prob := 'Y'; -- for 2479579
5574: / * commented this message stack for 2479579
5575: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5576: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5577: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5578: fnd_msg_pub.add; * /
5579: / * Included the following check as part of Bug fix #1776606 * /
5580: ---added following if stmnt for 2479579

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

5573: g_susp_prob := 'Y'; -- for 2479579
5574: / * commented this message stack for 2479579
5575: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
5576: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
5577: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
5578: fnd_msg_pub.add; * /
5579: / * Included the following check as part of Bug fix #1776606 * /
5580: ---added following if stmnt for 2479579
5581: IF l_susp_exception = 'NO_G_AC' then

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

5698:
5699: / * Added Exceptions for bug 2056877 * /
5700: WHEN NO_PROFILE_EXISTS THEN
5701: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5702: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
5703: fnd_msg_pub.add;
5704: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5705: p_return_status := fnd_api.g_ret_sts_success;
5706:

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

5705: p_return_status := fnd_api.g_ret_sts_success;
5706:
5707: WHEN NO_VAL_DATE_MATCHES THEN
5708: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5709: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5710: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5711: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5712: fnd_msg_pub.add;
5713: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

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

5706:
5707: WHEN NO_VAL_DATE_MATCHES THEN
5708: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5709: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5710: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5711: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5712: fnd_msg_pub.add;
5713: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5714: p_return_status := fnd_api.g_ret_sts_success;

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

5707: WHEN NO_VAL_DATE_MATCHES THEN
5708: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5709: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
5710: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5711: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5712: fnd_msg_pub.add;
5713: --p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5714: p_return_status := fnd_api.g_ret_sts_success;
5715:

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

5714: p_return_status := fnd_api.g_ret_sts_success;
5715:
5716: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5717: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5718: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5719: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5720: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5721: fnd_msg_pub.add;
5722: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579

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

5715:
5716: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5717: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5718: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5719: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5720: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5721: fnd_msg_pub.add;
5722: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5723: p_return_status := fnd_api.g_ret_sts_success;

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

5716: WHEN NO_GLOBAL_ACCT_EXISTS THEN
5717: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
5718: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
5719: fnd_message.set_token('ORG_NAME',l_orig_org_name);
5720: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
5721: fnd_msg_pub.add;
5722: -- p_return_status := fnd_api.g_ret_sts_unexp_error; commented and intro success for 2479579
5723: p_return_status := fnd_api.g_ret_sts_success;
5724:

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

6102: CLOSE get_susp_org_cur;
6103:
6104: l_suspense_ac_failed := 'Y';
6105: g_susp_prob := 'Y';
6106: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6107: fnd_message.set_token('ORG_NAME', l_organization_name);
6108: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6109: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6110: fnd_msg_pub.add;

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

6103:
6104: l_suspense_ac_failed := 'Y';
6105: g_susp_prob := 'Y';
6106: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6107: fnd_message.set_token('ORG_NAME', l_organization_name);
6108: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6109: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6110: fnd_msg_pub.add;
6111: ELSE

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

6104: l_suspense_ac_failed := 'Y';
6105: g_susp_prob := 'Y';
6106: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6107: fnd_message.set_token('ORG_NAME', l_organization_name);
6108: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6109: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6110: fnd_msg_pub.add;
6111: ELSE
6112: l_susp_ac_found := 'TRUE';

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

6105: g_susp_prob := 'Y';
6106: fnd_message.set_name('PSP', 'PSP_TR_GMS_SUSP_AC_REJECT');
6107: fnd_message.set_token('ORG_NAME', l_organization_name);
6108: fnd_message.set_token('PAYROLL_DATE', r_suspense_ac.encumbrance_date(recno));
6109: fnd_message.set_token('ERROR_MSG', r_suspense_ac.interface_status(recno));
6110: fnd_msg_pub.add;
6111: ELSE
6112: l_susp_ac_found := 'TRUE';
6113:

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

6183: IF (l_autopop_status = FND_API.G_RET_STS_ERROR) THEN
6184: l_autopop_error := 'AUTO_POP_NO_VALUE';
6185: END IF;
6186: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6187: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6188: fnd_message.set_token('START_DATE', l_effective_date);
6189: fnd_message.set_token('END_DATE', l_effective_date);
6190: fnd_message.set_token('GL', l_gl_description);
6191: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);

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

6184: l_autopop_error := 'AUTO_POP_NO_VALUE';
6185: END IF;
6186: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6187: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6188: fnd_message.set_token('START_DATE', l_effective_date);
6189: fnd_message.set_token('END_DATE', l_effective_date);
6190: fnd_message.set_token('GL', l_gl_description);
6191: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6192: g_warning_message := fnd_message.get;

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

6185: END IF;
6186: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6187: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6188: fnd_message.set_token('START_DATE', l_effective_date);
6189: fnd_message.set_token('END_DATE', l_effective_date);
6190: fnd_message.set_token('GL', l_gl_description);
6191: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6192: g_warning_message := fnd_message.get;
6193: fnd_file.put_line(fnd_file.log, g_warning_message);

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

6186: l_gl_description := psp_general.get_gl_values(g_set_of_books_id, l_susp_glccid);
6187: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6188: fnd_message.set_token('START_DATE', l_effective_date);
6189: fnd_message.set_token('END_DATE', l_effective_date);
6190: fnd_message.set_token('GL', l_gl_description);
6191: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6192: g_warning_message := fnd_message.get;
6193: fnd_file.put_line(fnd_file.log, g_warning_message);
6194: ELSE

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

6187: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AUTOPOP');
6188: fnd_message.set_token('START_DATE', l_effective_date);
6189: fnd_message.set_token('END_DATE', l_effective_date);
6190: fnd_message.set_token('GL', l_gl_description);
6191: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6192: g_warning_message := fnd_message.get;
6193: fnd_file.put_line(fnd_file.log, g_warning_message);
6194: ELSE
6195: l_susp_glccid := l_new_gl_code_combination_id;

Line 6192: g_warning_message := fnd_message.get;

6188: fnd_message.set_token('START_DATE', l_effective_date);
6189: fnd_message.set_token('END_DATE', l_effective_date);
6190: fnd_message.set_token('GL', l_gl_description);
6191: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6192: g_warning_message := fnd_message.get;
6193: fnd_file.put_line(fnd_file.log, g_warning_message);
6194: ELSE
6195: l_susp_glccid := l_new_gl_code_combination_id;
6196: END IF;

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

6244: OPEN exp_org_name_cur;
6245: FETCH exp_org_name_cur INTO l_exp_org_name;
6246: CLOSE exp_org_name_cur;
6247:
6248: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6249: fnd_message.set_token('START_DATE', l_effective_date);
6250: fnd_message.set_token('END_DATE', l_effective_date);
6251: fnd_message.set_token('PJ', l_project_number);
6252: fnd_message.set_token('TK', l_task_number);

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

6245: FETCH exp_org_name_cur INTO l_exp_org_name;
6246: CLOSE exp_org_name_cur;
6247:
6248: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6249: fnd_message.set_token('START_DATE', l_effective_date);
6250: fnd_message.set_token('END_DATE', l_effective_date);
6251: fnd_message.set_token('PJ', l_project_number);
6252: fnd_message.set_token('TK', l_task_number);
6253: fnd_message.set_token('AW', l_award_number);

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

6246: CLOSE exp_org_name_cur;
6247:
6248: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6249: fnd_message.set_token('START_DATE', l_effective_date);
6250: fnd_message.set_token('END_DATE', l_effective_date);
6251: fnd_message.set_token('PJ', l_project_number);
6252: fnd_message.set_token('TK', l_task_number);
6253: fnd_message.set_token('AW', l_award_number);
6254: fnd_message.set_token('EO', l_exp_org_name);

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

6247:
6248: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6249: fnd_message.set_token('START_DATE', l_effective_date);
6250: fnd_message.set_token('END_DATE', l_effective_date);
6251: fnd_message.set_token('PJ', l_project_number);
6252: fnd_message.set_token('TK', l_task_number);
6253: fnd_message.set_token('AW', l_award_number);
6254: fnd_message.set_token('EO', l_exp_org_name);
6255: fnd_message.set_token('ET', l_expenditure_type);

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

6248: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_AP_PATEO');
6249: fnd_message.set_token('START_DATE', l_effective_date);
6250: fnd_message.set_token('END_DATE', l_effective_date);
6251: fnd_message.set_token('PJ', l_project_number);
6252: fnd_message.set_token('TK', l_task_number);
6253: fnd_message.set_token('AW', l_award_number);
6254: fnd_message.set_token('EO', l_exp_org_name);
6255: fnd_message.set_token('ET', l_expenditure_type);
6256: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);

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

6249: fnd_message.set_token('START_DATE', l_effective_date);
6250: fnd_message.set_token('END_DATE', l_effective_date);
6251: fnd_message.set_token('PJ', l_project_number);
6252: fnd_message.set_token('TK', l_task_number);
6253: fnd_message.set_token('AW', l_award_number);
6254: fnd_message.set_token('EO', l_exp_org_name);
6255: fnd_message.set_token('ET', l_expenditure_type);
6256: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6257: g_warning_message := fnd_message.get;

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

6250: fnd_message.set_token('END_DATE', l_effective_date);
6251: fnd_message.set_token('PJ', l_project_number);
6252: fnd_message.set_token('TK', l_task_number);
6253: fnd_message.set_token('AW', l_award_number);
6254: fnd_message.set_token('EO', l_exp_org_name);
6255: fnd_message.set_token('ET', l_expenditure_type);
6256: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6257: g_warning_message := fnd_message.get;
6258: fnd_file.put_line(fnd_file.log, g_warning_message);

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

6251: fnd_message.set_token('PJ', l_project_number);
6252: fnd_message.set_token('TK', l_task_number);
6253: fnd_message.set_token('AW', l_award_number);
6254: fnd_message.set_token('EO', l_exp_org_name);
6255: fnd_message.set_token('ET', l_expenditure_type);
6256: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6257: g_warning_message := fnd_message.get;
6258: fnd_file.put_line(fnd_file.log, g_warning_message);
6259: ELSE

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

6252: fnd_message.set_token('TK', l_task_number);
6253: fnd_message.set_token('AW', l_award_number);
6254: fnd_message.set_token('EO', l_exp_org_name);
6255: fnd_message.set_token('ET', l_expenditure_type);
6256: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6257: g_warning_message := fnd_message.get;
6258: fnd_file.put_line(fnd_file.log, g_warning_message);
6259: ELSE
6260: l_expenditure_type := l_new_expenditure_type;

Line 6257: g_warning_message := fnd_message.get;

6253: fnd_message.set_token('AW', l_award_number);
6254: fnd_message.set_token('EO', l_exp_org_name);
6255: fnd_message.set_token('ET', l_expenditure_type);
6256: fnd_message.set_token('AUTOPOP_STATUS', l_autopop_error);
6257: g_warning_message := fnd_message.get;
6258: fnd_file.put_line(fnd_file.log, g_warning_message);
6259: ELSE
6260: l_expenditure_type := l_new_expenditure_type;
6261: END IF;

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

6447: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving GMS_ENC_TIE_BACK');
6448: EXCEPTION
6449: WHEN NO_PROFILE_EXISTS THEN
6450: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6451: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
6452: fnd_msg_pub.add;
6453: p_return_status := fnd_api.g_ret_sts_success;
6454: WHEN NO_VAL_DATE_MATCHES THEN
6455: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

6452: fnd_msg_pub.add;
6453: p_return_status := fnd_api.g_ret_sts_success;
6454: WHEN NO_VAL_DATE_MATCHES THEN
6455: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6456: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6457: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6458: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6459: fnd_msg_pub.add;
6460: p_return_status := fnd_api.g_ret_sts_success;

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

6453: p_return_status := fnd_api.g_ret_sts_success;
6454: WHEN NO_VAL_DATE_MATCHES THEN
6455: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6456: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6457: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6458: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6459: fnd_msg_pub.add;
6460: p_return_status := fnd_api.g_ret_sts_success;
6461: WHEN NO_GLOBAL_ACCT_EXISTS THEN

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

6454: WHEN NO_VAL_DATE_MATCHES THEN
6455: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6456: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6457: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6458: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6459: fnd_msg_pub.add;
6460: p_return_status := fnd_api.g_ret_sts_success;
6461: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6462: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);

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

6459: fnd_msg_pub.add;
6460: p_return_status := fnd_api.g_ret_sts_success;
6461: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6462: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6463: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6464: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6465: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6466: fnd_msg_pub.add;
6467: p_return_status := fnd_api.g_ret_sts_success;

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

6460: p_return_status := fnd_api.g_ret_sts_success;
6461: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6462: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6463: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6464: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6465: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6466: fnd_msg_pub.add;
6467: p_return_status := fnd_api.g_ret_sts_success;
6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

6461: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6462: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6463: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6464: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6465: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6466: fnd_msg_pub.add;
6467: p_return_status := fnd_api.g_ret_sts_success;
6468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6469: g_error_api_path := 'GMS_ENC_TIE_BACK:'||g_error_api_path;

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

6955: OPEN exp_org_name_cur(st_warnings.exp_org_id(recno));
6956: FETCH exp_org_name_cur INTO l_exp_org_name;
6957: CLOSE exp_org_name_cur;
6958:
6959: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6960: fnd_message.set_token('PJ', l_project_number);
6961: fnd_message.set_token('TK', l_task_number);
6962: fnd_message.set_token('AW', l_award_number);
6963: fnd_message.set_token('EO', l_exp_org_name);

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

6956: FETCH exp_org_name_cur INTO l_exp_org_name;
6957: CLOSE exp_org_name_cur;
6958:
6959: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6960: fnd_message.set_token('PJ', l_project_number);
6961: fnd_message.set_token('TK', l_task_number);
6962: fnd_message.set_token('AW', l_award_number);
6963: fnd_message.set_token('EO', l_exp_org_name);
6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));

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

6957: CLOSE exp_org_name_cur;
6958:
6959: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6960: fnd_message.set_token('PJ', l_project_number);
6961: fnd_message.set_token('TK', l_task_number);
6962: fnd_message.set_token('AW', l_award_number);
6963: fnd_message.set_token('EO', l_exp_org_name);
6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));
6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));

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

6958:
6959: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6960: fnd_message.set_token('PJ', l_project_number);
6961: fnd_message.set_token('TK', l_task_number);
6962: fnd_message.set_token('AW', l_award_number);
6963: fnd_message.set_token('EO', l_exp_org_name);
6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));
6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6966: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));

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

6959: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_PATEO');
6960: fnd_message.set_token('PJ', l_project_number);
6961: fnd_message.set_token('TK', l_task_number);
6962: fnd_message.set_token('AW', l_award_number);
6963: fnd_message.set_token('EO', l_exp_org_name);
6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));
6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6966: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6967: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));

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

6960: fnd_message.set_token('PJ', l_project_number);
6961: fnd_message.set_token('TK', l_task_number);
6962: fnd_message.set_token('AW', l_award_number);
6963: fnd_message.set_token('EO', l_exp_org_name);
6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));
6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6966: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6967: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6968: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));

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

6961: fnd_message.set_token('TK', l_task_number);
6962: fnd_message.set_token('AW', l_award_number);
6963: fnd_message.set_token('EO', l_exp_org_name);
6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));
6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6966: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6967: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6968: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6969: g_warning_message := fnd_message.get;

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

6962: fnd_message.set_token('AW', l_award_number);
6963: fnd_message.set_token('EO', l_exp_org_name);
6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));
6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6966: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6967: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6968: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6969: g_warning_message := fnd_message.get;
6970: ELSE

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

6963: fnd_message.set_token('EO', l_exp_org_name);
6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));
6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6966: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6967: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6968: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6969: g_warning_message := fnd_message.get;
6970: ELSE
6971: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));

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

6964: fnd_message.set_token('ET', st_warnings.exp_type(recno));
6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6966: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6967: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6968: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6969: g_warning_message := fnd_message.get;
6970: ELSE
6971: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
6972:

Line 6969: g_warning_message := fnd_message.get;

6965: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6966: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6967: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6968: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6969: g_warning_message := fnd_message.get;
6970: ELSE
6971: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
6972:
6973: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');

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

6969: g_warning_message := fnd_message.get;
6970: ELSE
6971: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
6972:
6973: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
6974: fnd_message.set_token('GL', l_gl_description);
6975: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6976: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6977: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));

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

6970: ELSE
6971: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
6972:
6973: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
6974: fnd_message.set_token('GL', l_gl_description);
6975: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6976: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6977: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6978: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));

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

6971: l_gl_description := psp_general.get_gl_description(g_set_of_books_id, st_warnings.gl_ccid(recno));
6972:
6973: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
6974: fnd_message.set_token('GL', l_gl_description);
6975: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6976: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6977: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6978: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6979: g_warning_message := fnd_message.get;

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

6972:
6973: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
6974: fnd_message.set_token('GL', l_gl_description);
6975: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6976: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6977: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6978: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6979: g_warning_message := fnd_message.get;
6980: END IF;

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

6973: fnd_message.set_name('PSP', 'PSP_SUSPENSE_REASON_INV_GL');
6974: fnd_message.set_token('GL', l_gl_description);
6975: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6976: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6977: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6978: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6979: g_warning_message := fnd_message.get;
6980: END IF;
6981:

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

6974: fnd_message.set_token('GL', l_gl_description);
6975: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6976: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6977: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6978: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6979: g_warning_message := fnd_message.get;
6980: END IF;
6981:
6982: psp_general.add_report_error

Line 6979: g_warning_message := fnd_message.get;

6975: fnd_message.set_token('START_DATE', st_warnings.start_date(recno));
6976: fnd_message.set_token('END_DATE', st_warnings.end_date(recno));
6977: fnd_message.set_token('EFFECTIVE_DATE', st_warnings.effective_date(recno));
6978: fnd_message.set_token('ERROR_STATUS', st_warnings.error_status(recno));
6979: g_warning_message := fnd_message.get;
6980: END IF;
6981:
6982: psp_general.add_report_error
6983: (p_request_id => l_request_id,