DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on FND_MESSAGE

Line 101: fnd_message.set_name('PSP','PSP_ENC_NO_LIQ_REC_FOUND');

97: / ******* No control record found. Exiting from the program successfully ******* /
98: IF g_control_rec_found = 'FALSE'
99: THEN
100: --insert into psp_Stout values(99, 'no control rec found');
101: fnd_message.set_name('PSP','PSP_ENC_NO_LIQ_REC_FOUND');
102: fnd_msg_pub.add;
103: retcode := FND_API.G_RET_STS_SUCCESS;
104:
105: -- Added code for error message handler by Bijoy , 27-Jul-1999

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

119: if fnd_profile.value('PSP_ENC_ENABLE_PQH') ='Y' then
120: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
121: pqh_psp_integration.relieve_budget_commitments('L', l_return_status);
122: If l_return_status <>FND_API.G_RET_STS_SUCCESS THEN
123: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
124: fnd_msg_pub.add;
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126:
127:

Line 342: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');

338: -- Replaced default successful return status with warning / success based on failed transactions check
339: IF (g_liq_has_failed_transactions) THEN
340: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: TRUE');
341: retcode := fnd_api.g_ret_sts_error;
342: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');
343: fnd_msg_pub.add;
344: psp_message_s.print_error(p_mode => FND_FILE.LOG,
345: p_print_header => FND_API.G_TRUE);
346: ELSE

Line 457: fnd_message.set_name('PSP','PSP_ENC_NO_LIQ_REC_FOUND');

453: END IF;
454: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After enc_batch_begin');
455:
456: IF (g_control_rec_found = 'FALSE') THEN
457: fnd_message.set_name('PSP','PSP_ENC_NO_LIQ_REC_FOUND');
458: fnd_msg_pub.add;
459: p_return_status := FND_API.G_RET_STS_SUCCESS;
460: RETURN;
461: END IF;

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

464: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Calling pqh_psp_integration.relieve_budget_commitments');
465: pqh_psp_integration.relieve_budget_commitments('L', l_return_status);
466:
467: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
468: fnd_message.set_name('PSP','PSP_ENC_PQH_ERROR');
469: fnd_msg_pub.add;
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' After pqh_psp_integration.relieve_budget_commitments');

Line 515: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');

511: END IF;
512:
513: IF (g_liq_has_failed_transactions) THEN
514: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_liq_has_failed_transactions: TRUE');
515: fnd_message.set_name('PSP','PSP_ENC_LIQ_TRANS_FAILED');
516: fnd_msg_pub.add;
517: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
518: p_return_status := fnd_api.g_ret_sts_error;
519: ELSE

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

2869: EXCEPTION
2870: WHEN NO_DATA_FOUND THEN
2871: l_value := 'time period id =';
2872: l_table := 'PER_TIME_PERIODS';
2873: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2874: fnd_message.set_token('VALUE','l_value');
2875: fnd_message.set_token('TABLE','l_table');
2876: fnd_msg_pub.add;
2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2870: WHEN NO_DATA_FOUND THEN
2871: l_value := 'time period id =';
2872: l_table := 'PER_TIME_PERIODS';
2873: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2874: fnd_message.set_token('VALUE','l_value');
2875: fnd_message.set_token('TABLE','l_table');
2876: fnd_msg_pub.add;
2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2878: END;

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

2871: l_value := 'time period id =';
2872: l_table := 'PER_TIME_PERIODS';
2873: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2874: fnd_message.set_token('VALUE','l_value');
2875: fnd_message.set_token('TABLE','l_table');
2876: fnd_msg_pub.add;
2877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2878: END;
2879: If enc_control_rec.gl_phase = 'Summarize' then --- added for 2444657

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

2909: EXCEPTION
2910: WHEN NO_DATA_FOUND THEN
2911: l_error := 'CURRENCY CODE';
2912: l_product := 'GL';
2913: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2914: fnd_message.set_token('ERROR','l_error');
2915: fnd_message.set_token('PRODUCT','l_product');
2916: fnd_msg_pub.add;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2910: WHEN NO_DATA_FOUND THEN
2911: l_error := 'CURRENCY CODE';
2912: l_product := 'GL';
2913: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2914: fnd_message.set_token('ERROR','l_error');
2915: fnd_message.set_token('PRODUCT','l_product');
2916: fnd_msg_pub.add;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END;* /

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

2911: l_error := 'CURRENCY CODE';
2912: l_product := 'GL';
2913: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2914: fnd_message.set_token('ERROR','l_error');
2915: fnd_message.set_token('PRODUCT','l_product');
2916: fnd_msg_pub.add;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918: END;* /
2919: -- End of Comments for bug 2478000

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

3060: IF req_id = 0 THEN
3061: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import submission failed');
3062: -- insert into psp_stout values(0, 'req did not get submitted');
3063:
3064: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3065: fnd_msg_pub.add;
3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067:
3068: ELSE

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

3105: rphase, rstatus, dphase, dstatus, message);
3106:
3107: IF call_status = FALSE then
3108: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
3109: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3110: fnd_msg_pub.add;
3111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3112: END IF;
3113: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');

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

3242: EXCEPTION
3243: WHEN NO_DATA_FOUND THEN
3244: l_error := 'JE SOURCES = OLD';
3245: l_product := 'GL';
3246: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3247: fnd_message.set_token('ERROR',l_error);
3248: fnd_message.set_token('PRODUCT',l_product);
3249: fnd_msg_pub.add;
3250: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

3243: WHEN NO_DATA_FOUND THEN
3244: l_error := 'JE SOURCES = OLD';
3245: l_product := 'GL';
3246: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3247: fnd_message.set_token('ERROR',l_error);
3248: fnd_message.set_token('PRODUCT',l_product);
3249: fnd_msg_pub.add;
3250: p_return_status := fnd_api.g_ret_sts_unexp_error;
3251: WHEN OTHERS THEN

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

3244: l_error := 'JE SOURCES = OLD';
3245: l_product := 'GL';
3246: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3247: fnd_message.set_token('ERROR',l_error);
3248: fnd_message.set_token('PRODUCT',l_product);
3249: fnd_msg_pub.add;
3250: p_return_status := fnd_api.g_ret_sts_unexp_error;
3251: WHEN OTHERS THEN
3252: g_error_api_path := 'gl_je_source:'||g_error_api_path;

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

3270: EXCEPTION
3271: WHEN NO_DATA_FOUND THEN
3272: l_error := 'JE CATEGORY = OLD';
3273: l_product := 'GL';
3274: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3275: fnd_message.set_token('ERROR',l_error);
3276: fnd_message.set_token('PRODUCT',l_product);
3277: fnd_msg_pub.add;
3278: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

3271: WHEN NO_DATA_FOUND THEN
3272: l_error := 'JE CATEGORY = OLD';
3273: l_product := 'GL';
3274: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3275: fnd_message.set_token('ERROR',l_error);
3276: fnd_message.set_token('PRODUCT',l_product);
3277: fnd_msg_pub.add;
3278: p_return_status := fnd_api.g_ret_sts_unexp_error;
3279: WHEN OTHERS THEN

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

3272: l_error := 'JE CATEGORY = OLD';
3273: l_product := 'GL';
3274: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3275: fnd_message.set_token('ERROR',l_error);
3276: fnd_message.set_token('PRODUCT',l_product);
3277: fnd_msg_pub.add;
3278: p_return_status := fnd_api.g_ret_sts_unexp_error;
3279: WHEN OTHERS THEN
3280: g_error_api_path := 'gl_je_cat:'||g_error_api_path;

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

3301: EXCEPTION
3302: WHEN NO_DATA_FOUND THEN
3303: l_error := 'ENCUMBRANCE TYPE = OLD';
3304: l_product := 'GL';
3305: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3306: fnd_message.set_token('ERROR',l_error);
3307: fnd_message.set_token('PRODUCT',l_product);
3308: fnd_msg_pub.add;
3309: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

3302: WHEN NO_DATA_FOUND THEN
3303: l_error := 'ENCUMBRANCE TYPE = OLD';
3304: l_product := 'GL';
3305: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3306: fnd_message.set_token('ERROR',l_error);
3307: fnd_message.set_token('PRODUCT',l_product);
3308: fnd_msg_pub.add;
3309: p_return_status := fnd_api.g_ret_sts_unexp_error;
3310: WHEN OTHERS THEN

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

3303: l_error := 'ENCUMBRANCE TYPE = OLD';
3304: l_product := 'GL';
3305: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3306: fnd_message.set_token('ERROR',l_error);
3307: fnd_message.set_token('PRODUCT',l_product);
3308: fnd_msg_pub.add;
3309: p_return_status := fnd_api.g_ret_sts_unexp_error;
3310: WHEN OTHERS THEN
3311: g_error_api_path := 'enc_type:'||g_error_api_path;

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

4027: where enc_control_id = p_enc_control_id;
4028: end if;
4029: / * commented: Bug 2039196
4030: IF l_reversal_ac_failed = 'Y' THEN
4031: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
4032: fnd_message.set_token('GLCCID',x_lines_glccid);
4033: fnd_msg_pub.add;
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: END IF; * /

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

4028: end if;
4029: / * commented: Bug 2039196
4030: IF l_reversal_ac_failed = 'Y' THEN
4031: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
4032: fnd_message.set_token('GLCCID',x_lines_glccid);
4033: fnd_msg_pub.add;
4034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4035: END IF; * /
4036:

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

4042: SET gl_phase = 'INVALID_SUSPENSE'
4043: WHERE enc_control_id = p_enc_control_id;
4044: END IF;
4045: -- removed statement set invalid susp to 'Y' for 2479579
4046: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4047: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4048: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4049: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4050: fnd_msg_pub.add;

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

4043: WHERE enc_control_id = p_enc_control_id;
4044: END IF;
4045: -- removed statement set invalid susp to 'Y' for 2479579
4046: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4047: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4048: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4049: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4050: fnd_msg_pub.add;
4051: -- removed call enc_batch_end from here moved it to tr_to_gl for 2479579

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

4044: END IF;
4045: -- removed statement set invalid susp to 'Y' for 2479579
4046: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4047: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4048: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4049: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4050: fnd_msg_pub.add;
4051: -- removed call enc_batch_end from here moved it to tr_to_gl for 2479579
4052: END IF;

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

4045: -- removed statement set invalid susp to 'Y' for 2479579
4046: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4047: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4048: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4049: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4050: fnd_msg_pub.add;
4051: -- removed call enc_batch_end from here moved it to tr_to_gl for 2479579
4052: END IF;
4053: End of comment for Enh. Removal of suspense posting in Liquidation ***** /

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

4054:
4055: / *Commented for Restart Update/Quick Update Encumbrance Lines Enh.
4056: because of the introduction of get global suspense in previous fix 2056877
4057: IF l_suspense_ac_not_found = 'Y' THEN
4058: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4059: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4060: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4061: fnd_msg_pub.add;
4062: -- Bug 2039196: Introduced the if condn.

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

4055: / *Commented for Restart Update/Quick Update Encumbrance Lines Enh.
4056: because of the introduction of get global suspense in previous fix 2056877
4057: IF l_suspense_ac_not_found = 'Y' THEN
4058: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4059: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4060: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4061: fnd_msg_pub.add;
4062: -- Bug 2039196: Introduced the if condn.
4063: if p_mode = 'N' then

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

4056: because of the introduction of get global suspense in previous fix 2056877
4057: IF l_suspense_ac_not_found = 'Y' THEN
4058: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4059: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4060: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4061: fnd_msg_pub.add;
4062: -- Bug 2039196: Introduced the if condn.
4063: if p_mode = 'N' then
4064: enc_batch_end(g_payroll_id,p_action_type, 'N',g_bg_id, g_sob_id,l_return_status);

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

4145: /***** Commented the following as part of bug fix 4625734
4146: / * Added Exceptions for bug 2056877 * /
4147: WHEN NO_PROFILE_EXISTS THEN
4148: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4149: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
4150: fnd_msg_pub.add;
4151: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4152:
4153: WHEN NO_VAL_DATE_MATCHES THEN

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

4151: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4152:
4153: WHEN NO_VAL_DATE_MATCHES THEN
4154: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4155: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4156: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4157: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4158: fnd_msg_pub.add;
4159: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

4152:
4153: WHEN NO_VAL_DATE_MATCHES THEN
4154: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4155: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4156: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4157: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4158: fnd_msg_pub.add;
4159: p_return_status := fnd_api.g_ret_sts_unexp_error;
4160: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579

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

4153: WHEN NO_VAL_DATE_MATCHES THEN
4154: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4155: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4156: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4157: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4158: fnd_msg_pub.add;
4159: p_return_status := fnd_api.g_ret_sts_unexp_error;
4160: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4161:

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

4160: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4161:
4162: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4163: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4164: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4165: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4166: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4167: fnd_msg_pub.add;
4168: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.

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

4161:
4162: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4163: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4164: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4165: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4166: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4167: fnd_msg_pub.add;
4168: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.
4169: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579

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

4162: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4163: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4164: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4165: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4166: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4167: fnd_msg_pub.add;
4168: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.
4169: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4170: end of comment for bug fix 4625734 *****/

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

5198: EXCEPTION
5199: WHEN NO_DATA_FOUND THEN
5200: l_error := 'TRANSACTION SOURCE = GOLDE';
5201: l_product := 'GMS';
5202: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5203: fnd_message.set_token('ERROR',l_error);
5204: fnd_message.set_token('PRODUCT',l_product);
5205: fnd_msg_pub.add;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5199: WHEN NO_DATA_FOUND THEN
5200: l_error := 'TRANSACTION SOURCE = GOLDE';
5201: l_product := 'GMS';
5202: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5203: fnd_message.set_token('ERROR',l_error);
5204: fnd_message.set_token('PRODUCT',l_product);
5205: fnd_msg_pub.add;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END;

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

5200: l_error := 'TRANSACTION SOURCE = GOLDE';
5201: l_product := 'GMS';
5202: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5203: fnd_message.set_token('ERROR',l_error);
5204: fnd_message.set_token('PRODUCT',l_product);
5205: fnd_msg_pub.add;
5206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5207: END;
5208: End of comment for bug fix 4625734 *****/

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

5210: FETCH transaction_source_cur INTO l_gms_transaction_source;
5211: CLOSE transaction_source_cur;
5212:
5213: IF (l_gms_transaction_source IS NULL) THEN
5214: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5215: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5216: fnd_message.set_token('PRODUCT','GMS');
5217: fnd_msg_pub.add;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5211: CLOSE transaction_source_cur;
5212:
5213: IF (l_gms_transaction_source IS NULL) THEN
5214: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5215: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5216: fnd_message.set_token('PRODUCT','GMS');
5217: fnd_msg_pub.add;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5219: END IF;

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

5212:
5213: IF (l_gms_transaction_source IS NULL) THEN
5214: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5215: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5216: fnd_message.set_token('PRODUCT','GMS');
5217: fnd_msg_pub.add;
5218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5219: END IF;
5220: end if;

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

5309: l_raise_error := FALSE;
5310: FOR recno IN 1..r_interface.txn_interface_id.COUNT
5311: LOOP
5312: IF r_interface.employee_number(recno) IS NULL THEN
5313: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5314: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5315: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5316: fnd_msg_pub.add;
5317: l_raise_error := TRUE;

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

5310: FOR recno IN 1..r_interface.txn_interface_id.COUNT
5311: LOOP
5312: IF r_interface.employee_number(recno) IS NULL THEN
5313: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5314: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5315: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5316: fnd_msg_pub.add;
5317: l_raise_error := TRUE;
5318: END IF;

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

5311: LOOP
5312: IF r_interface.employee_number(recno) IS NULL THEN
5313: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5314: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5315: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5316: fnd_msg_pub.add;
5317: l_raise_error := TRUE;
5318: END IF;
5319:

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

5317: l_raise_error := TRUE;
5318: END IF;
5319:
5320: IF r_interface.exp_org_name(recno) IS NULL THEN
5321: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5322: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5323: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5324: fnd_msg_pub.add;
5325: l_raise_error := TRUE;

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

5318: END IF;
5319:
5320: IF r_interface.exp_org_name(recno) IS NULL THEN
5321: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5322: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5323: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5324: fnd_msg_pub.add;
5325: l_raise_error := TRUE;
5326: END IF;

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

5319:
5320: IF r_interface.exp_org_name(recno) IS NULL THEN
5321: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5322: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5323: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5324: fnd_msg_pub.add;
5325: l_raise_error := TRUE;
5326: END IF;
5327:

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

5325: l_raise_error := TRUE;
5326: END IF;
5327:
5328: IF r_interface.operating_unit(recno) IS NULL THEN
5329: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5330: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5331: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5332: fnd_msg_pub.add;
5333: l_raise_error := TRUE;

Line 5330: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));

5326: END IF;
5327:
5328: IF r_interface.operating_unit(recno) IS NULL THEN
5329: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5330: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5331: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5332: fnd_msg_pub.add;
5333: l_raise_error := TRUE;
5334: END IF;

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

5327:
5328: IF r_interface.operating_unit(recno) IS NULL THEN
5329: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5330: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5331: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5332: fnd_msg_pub.add;
5333: l_raise_error := TRUE;
5334: END IF;
5335:

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

5333: l_raise_error := TRUE;
5334: END IF;
5335:
5336: IF r_interface.project_number(recno) IS NULL THEN
5337: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5338: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5339: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5340: fnd_msg_pub.add;
5341: l_raise_error := TRUE;

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

5334: END IF;
5335:
5336: IF r_interface.project_number(recno) IS NULL THEN
5337: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5338: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5339: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5340: fnd_msg_pub.add;
5341: l_raise_error := TRUE;
5342: END IF;

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

5335:
5336: IF r_interface.project_number(recno) IS NULL THEN
5337: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5338: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5339: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5340: fnd_msg_pub.add;
5341: l_raise_error := TRUE;
5342: END IF;
5343:

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

5341: l_raise_error := TRUE;
5342: END IF;
5343:
5344: IF r_interface.task_number(recno) IS NULL THEN
5345: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5346: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5347: fnd_message.set_token('TABLE', 'PA_TASKS');
5348: fnd_msg_pub.add;
5349: l_raise_error := TRUE;

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

5342: END IF;
5343:
5344: IF r_interface.task_number(recno) IS NULL THEN
5345: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5346: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5347: fnd_message.set_token('TABLE', 'PA_TASKS');
5348: fnd_msg_pub.add;
5349: l_raise_error := TRUE;
5350: END IF;

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

5343:
5344: IF r_interface.task_number(recno) IS NULL THEN
5345: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5346: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5347: fnd_message.set_token('TABLE', 'PA_TASKS');
5348: fnd_msg_pub.add;
5349: l_raise_error := TRUE;
5350: END IF;
5351: END LOOP;

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

5443:
5444: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5445:
5446: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5447: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5448: fnd_msg_pub.add;
5449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5450: END IF;
5451: END LOOP;

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

5500: EXCEPTION
5501: WHEN NO_DATA_FOUND THEN
5502: l_value := 'Person id ='||to_char(int_rec.person_id);
5503: l_table := 'PER_PEOPLE_F';
5504: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5505: fnd_message.set_token('VALUE',l_value);
5506: fnd_message.set_token('TABLE',l_table);
5507: fnd_msg_pub.add;
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5501: WHEN NO_DATA_FOUND THEN
5502: l_value := 'Person id ='||to_char(int_rec.person_id);
5503: l_table := 'PER_PEOPLE_F';
5504: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5505: fnd_message.set_token('VALUE',l_value);
5506: fnd_message.set_token('TABLE',l_table);
5507: fnd_msg_pub.add;
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: END;

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

5502: l_value := 'Person id ='||to_char(int_rec.person_id);
5503: l_table := 'PER_PEOPLE_F';
5504: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5505: fnd_message.set_token('VALUE',l_value);
5506: fnd_message.set_token('TABLE',l_table);
5507: fnd_msg_pub.add;
5508: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5509: END;
5510: --dbms_output.put_line('emp num='||l_emp_num);

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

5517: EXCEPTION
5518: WHEN NO_DATA_FOUND THEN
5519: l_value := 'Org id ='||to_char(int_rec.expenditure_organization_id);
5520: l_table := 'HR_ORGANIZATION_UNITS';
5521: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5522: fnd_message.set_token('VALUE',l_value);
5523: fnd_message.set_token('TABLE',l_table);
5524: fnd_msg_pub.add;
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5518: WHEN NO_DATA_FOUND THEN
5519: l_value := 'Org id ='||to_char(int_rec.expenditure_organization_id);
5520: l_table := 'HR_ORGANIZATION_UNITS';
5521: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5522: fnd_message.set_token('VALUE',l_value);
5523: fnd_message.set_token('TABLE',l_table);
5524: fnd_msg_pub.add;
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: END;

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

5519: l_value := 'Org id ='||to_char(int_rec.expenditure_organization_id);
5520: l_table := 'HR_ORGANIZATION_UNITS';
5521: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5522: fnd_message.set_token('VALUE',l_value);
5523: fnd_message.set_token('TABLE',l_table);
5524: fnd_msg_pub.add;
5525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5526: END;
5527: --dbms_output.put_line('org name='||l_org_name);

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

5534: EXCEPTION
5535: WHEN NO_DATA_FOUND THEN
5536: l_value := 'Project id ='||to_char(int_rec.project_id);
5537: l_table := 'PA_PROJECTS_ALL';
5538: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5539: fnd_message.set_token('VALUE',l_value);
5540: fnd_message.set_token('TABLE',l_table);
5541: fnd_msg_pub.add;
5542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5535: WHEN NO_DATA_FOUND THEN
5536: l_value := 'Project id ='||to_char(int_rec.project_id);
5537: l_table := 'PA_PROJECTS_ALL';
5538: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5539: fnd_message.set_token('VALUE',l_value);
5540: fnd_message.set_token('TABLE',l_table);
5541: fnd_msg_pub.add;
5542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5543: END;

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

5536: l_value := 'Project id ='||to_char(int_rec.project_id);
5537: l_table := 'PA_PROJECTS_ALL';
5538: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5539: fnd_message.set_token('VALUE',l_value);
5540: fnd_message.set_token('TABLE',l_table);
5541: fnd_msg_pub.add;
5542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5543: END;
5544:

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

5550: EXCEPTION
5551: WHEN NO_DATA_FOUND THEN
5552: l_value := 'Project id ='||to_char(int_rec.project_id);
5553: l_table := 'PA_PROJECTS_ALL';
5554: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5555: fnd_message.set_token('VALUE',l_value);
5556: fnd_message.set_token('TABLE',l_table);
5557: fnd_msg_pub.add;
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5551: WHEN NO_DATA_FOUND THEN
5552: l_value := 'Project id ='||to_char(int_rec.project_id);
5553: l_table := 'PA_PROJECTS_ALL';
5554: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5555: fnd_message.set_token('VALUE',l_value);
5556: fnd_message.set_token('TABLE',l_table);
5557: fnd_msg_pub.add;
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: END;

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

5552: l_value := 'Project id ='||to_char(int_rec.project_id);
5553: l_table := 'PA_PROJECTS_ALL';
5554: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5555: fnd_message.set_token('VALUE',l_value);
5556: fnd_message.set_token('TABLE',l_table);
5557: fnd_msg_pub.add;
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: END;
5560: --dbms_output.put_line('seg1='||l_seg1);

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

5567: EXCEPTION
5568: WHEN NO_DATA_FOUND THEN
5569: l_value := 'Task id ='||to_char(int_rec.task_id);
5570: l_table := 'PA_TASKS';
5571: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5572: fnd_message.set_token('VALUE',l_value);
5573: fnd_message.set_token('TABLE',l_table);
5574: fnd_msg_pub.add;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5568: WHEN NO_DATA_FOUND THEN
5569: l_value := 'Task id ='||to_char(int_rec.task_id);
5570: l_table := 'PA_TASKS';
5571: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5572: fnd_message.set_token('VALUE',l_value);
5573: fnd_message.set_token('TABLE',l_table);
5574: fnd_msg_pub.add;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5576: END;

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

5569: l_value := 'Task id ='||to_char(int_rec.task_id);
5570: l_table := 'PA_TASKS';
5571: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5572: fnd_message.set_token('VALUE',l_value);
5573: fnd_message.set_token('TABLE',l_table);
5574: fnd_msg_pub.add;
5575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5576: END;
5577: --dbms_output.put_line('task='||l_task_number);

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

5682:
5683: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5684:
5685: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5686: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5687: fnd_msg_pub.add;
5688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5689: END IF;
5690:

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

5737: --dbms_output.put_line('Req id = '||to_char(req_id));
5738:
5739: IF req_id_tab(request_counter) = 0 THEN
5740: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
5741: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5742: fnd_msg_pub.add;
5743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5744: ELSE
5745: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');

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

5783: rphase, rstatus, dphase, dstatus, message);
5784:
5785: IF call_status = FALSE then
5786: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
5787: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5788: fnd_msg_pub.add;
5789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5790: END IF;
5791: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');

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

6668: End of Comment for bug fix 4625734 *****/
6669:
6670: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6671: IF l_suspense_ac_failed = 'Y' THEN
6672: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6673: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6674: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6675: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6676: fnd_msg_pub.add;

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

6669:
6670: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6671: IF l_suspense_ac_failed = 'Y' THEN
6672: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6673: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6674: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6675: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6676: fnd_msg_pub.add;
6677: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /

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

6670: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6671: IF l_suspense_ac_failed = 'Y' THEN
6672: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6673: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6674: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6675: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6676: fnd_msg_pub.add;
6677: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /
6678: IF p_action_type IN ('Q','U') THEN

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

6671: IF l_suspense_ac_failed = 'Y' THEN
6672: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6673: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6674: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6675: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6676: fnd_msg_pub.add;
6677: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /
6678: IF p_action_type IN ('Q','U') THEN
6679: UPDATE psp_enc_controls

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

6687:
6688: /* Commented for Restart Update/Quick Update Encumbrance Lines
6689: because global suspense function introduced,this situation is handled there.
6690: IF l_suspense_ac_not_found = 'Y' THEN
6691: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
6692: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
6693: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
6694: fnd_msg_pub.add;
6695: -- Bug 2039196: Introduced the if condn.

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

6688: /* Commented for Restart Update/Quick Update Encumbrance Lines
6689: because global suspense function introduced,this situation is handled there.
6690: IF l_suspense_ac_not_found = 'Y' THEN
6691: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
6692: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
6693: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
6694: fnd_msg_pub.add;
6695: -- Bug 2039196: Introduced the if condn.
6696: if p_mode = 'N' then

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

6689: because global suspense function introduced,this situation is handled there.
6690: IF l_suspense_ac_not_found = 'Y' THEN
6691: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
6692: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
6693: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
6694: fnd_msg_pub.add;
6695: -- Bug 2039196: Introduced the if condn.
6696: if p_mode = 'N' then
6697: enc_batch_end(g_payroll_id,g_action_type, 'N',g_bg_id, g_sob_id,l_return_status);

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

6820: /* Added Exceptions for Bug 2056877 */
6821: /***** Commented the following for bgu fix 4625734
6822: WHEN NO_PROFILE_EXISTS THEN
6823: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6824: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
6825: fnd_msg_pub.add;
6826: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6827: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6828:

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

6827: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6828:
6829: WHEN NO_VAL_DATE_MATCHES THEN
6830: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6831: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6832: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6833: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6834: fnd_msg_pub.add;
6835: --p_return_status := fnd_api.g_ret_sts_unexp_error;

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

6828:
6829: WHEN NO_VAL_DATE_MATCHES THEN
6830: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6831: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6832: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6833: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6834: fnd_msg_pub.add;
6835: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6836: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579

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

6829: WHEN NO_VAL_DATE_MATCHES THEN
6830: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6831: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
6832: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6833: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6834: fnd_msg_pub.add;
6835: --p_return_status := fnd_api.g_ret_sts_unexp_error;
6836: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6837:

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

6836: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6837:
6838: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6839: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6840: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6841: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6842: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6843: fnd_msg_pub.add;
6844: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.

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

6837:
6838: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6839: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6840: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6841: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6842: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6843: fnd_msg_pub.add;
6844: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
6845: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579

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

6838: WHEN NO_GLOBAL_ACCT_EXISTS THEN
6839: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
6840: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
6841: fnd_message.set_token('ORG_NAME',l_orig_org_name);
6842: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
6843: fnd_msg_pub.add;
6844: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
6845: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
6846: End of comment for bug fix 4625734 *****/

Line 6988: fnd_message.set_name('PSP','PSP_ENC_NUM_ASG');

6984: END LOOP;
6985: CLOSE get_rec_to_move;
6986:
6987: IF p_action_type = 'Q' THEN
6988: fnd_message.set_name('PSP','PSP_ENC_NUM_ASG');
6989: fnd_message.set_token('NUM_ASG',no_of_asg);
6990: fnd_msg_pub.add;
6991: psp_message_s.print_error (p_mode => FND_FILE.LOG,
6992: p_print_header => FND_API.G_FALSE);

Line 6989: fnd_message.set_token('NUM_ASG',no_of_asg);

6985: CLOSE get_rec_to_move;
6986:
6987: IF p_action_type = 'Q' THEN
6988: fnd_message.set_name('PSP','PSP_ENC_NUM_ASG');
6989: fnd_message.set_token('NUM_ASG',no_of_asg);
6990: fnd_msg_pub.add;
6991: psp_message_s.print_error (p_mode => FND_FILE.LOG,
6992: p_print_header => FND_API.G_FALSE);
6993: END IF;

Line 7126: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');

7122: OPEN get_full_name_cur(p_person_id, p_actual_term_date);
7123: FETCH get_full_name_cur INTO l_full_name2;
7124: CLOSE get_full_name_cur;
7125:
7126: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7127: fnd_message.set_token('PERSON1', l_full_name1);
7128: fnd_message.set_token('TERMDATE1', l_termination_date1);
7129: fnd_message.set_token('PERSON2', l_full_name2);
7130: fnd_message.set_token('TERMDATE2', p_actual_term_date);

Line 7127: fnd_message.set_token('PERSON1', l_full_name1);

7123: FETCH get_full_name_cur INTO l_full_name2;
7124: CLOSE get_full_name_cur;
7125:
7126: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7127: fnd_message.set_token('PERSON1', l_full_name1);
7128: fnd_message.set_token('TERMDATE1', l_termination_date1);
7129: fnd_message.set_token('PERSON2', l_full_name2);
7130: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7131: fnd_msg_pub.add;

Line 7128: fnd_message.set_token('TERMDATE1', l_termination_date1);

7124: CLOSE get_full_name_cur;
7125:
7126: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7127: fnd_message.set_token('PERSON1', l_full_name1);
7128: fnd_message.set_token('TERMDATE1', l_termination_date1);
7129: fnd_message.set_token('PERSON2', l_full_name2);
7130: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7131: fnd_msg_pub.add;
7132:

Line 7129: fnd_message.set_token('PERSON2', l_full_name2);

7125:
7126: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7127: fnd_message.set_token('PERSON1', l_full_name1);
7128: fnd_message.set_token('TERMDATE1', l_termination_date1);
7129: fnd_message.set_token('PERSON2', l_full_name2);
7130: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7131: fnd_msg_pub.add;
7132:
7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 7130: fnd_message.set_token('TERMDATE2', p_actual_term_date);

7126: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7127: fnd_message.set_token('PERSON1', l_full_name1);
7128: fnd_message.set_token('TERMDATE1', l_termination_date1);
7129: fnd_message.set_token('PERSON2', l_full_name2);
7130: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7131: fnd_msg_pub.add;
7132:
7133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7134: END IF;