APPS.PSP_ENC_LIQ_TRAN dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

2922: EXCEPTION
2923: WHEN NO_DATA_FOUND THEN
2924: l_value := 'time period id =';
2925: l_table := 'PER_TIME_PERIODS';
2926: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2927: fnd_message.set_token('VALUE','l_value');
2928: fnd_message.set_token('TABLE','l_table');
2929: fnd_msg_pub.add;
2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2923: WHEN NO_DATA_FOUND THEN
2924: l_value := 'time period id =';
2925: l_table := 'PER_TIME_PERIODS';
2926: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2927: fnd_message.set_token('VALUE','l_value');
2928: fnd_message.set_token('TABLE','l_table');
2929: fnd_msg_pub.add;
2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2931: END;

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

2924: l_value := 'time period id =';
2925: l_table := 'PER_TIME_PERIODS';
2926: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2927: fnd_message.set_token('VALUE','l_value');
2928: fnd_message.set_token('TABLE','l_table');
2929: fnd_msg_pub.add;
2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2931: END;
2932: If enc_control_rec.gl_phase = 'Summarize' then --- added for 2444657

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

2962: EXCEPTION
2963: WHEN NO_DATA_FOUND THEN
2964: l_error := 'CURRENCY CODE';
2965: l_product := 'GL';
2966: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2967: fnd_message.set_token('ERROR','l_error');
2968: fnd_message.set_token('PRODUCT','l_product');
2969: fnd_msg_pub.add;
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2963: WHEN NO_DATA_FOUND THEN
2964: l_error := 'CURRENCY CODE';
2965: l_product := 'GL';
2966: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2967: fnd_message.set_token('ERROR','l_error');
2968: fnd_message.set_token('PRODUCT','l_product');
2969: fnd_msg_pub.add;
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END;* /

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

2964: l_error := 'CURRENCY CODE';
2965: l_product := 'GL';
2966: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
2967: fnd_message.set_token('ERROR','l_error');
2968: fnd_message.set_token('PRODUCT','l_product');
2969: fnd_msg_pub.add;
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END;* /
2972: -- End of Comments for bug 2478000

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

3113: IF req_id = 0 THEN
3114: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import submission failed');
3115: -- insert into psp_stout values(0, 'req did not get submitted');
3116:
3117: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3118: fnd_msg_pub.add;
3119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3120:
3121: ELSE

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

3158: rphase, rstatus, dphase, dstatus, message);
3159:
3160: IF call_status = FALSE then
3161: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import failed');
3162: fnd_message.set_name('PSP','PSP_TR_GL_IMP_FAILED');
3163: fnd_msg_pub.add;
3164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3165: END IF;
3166: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Journal Import completed');

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

3296: EXCEPTION
3297: WHEN NO_DATA_FOUND THEN
3298: l_error := 'JE SOURCES = OLD';
3299: l_product := 'GL';
3300: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3301: fnd_message.set_token('ERROR',l_error);
3302: fnd_message.set_token('PRODUCT',l_product);
3303: fnd_msg_pub.add;
3304: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

3297: WHEN NO_DATA_FOUND THEN
3298: l_error := 'JE SOURCES = OLD';
3299: l_product := 'GL';
3300: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3301: fnd_message.set_token('ERROR',l_error);
3302: fnd_message.set_token('PRODUCT',l_product);
3303: fnd_msg_pub.add;
3304: p_return_status := fnd_api.g_ret_sts_unexp_error;
3305: WHEN OTHERS THEN

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

3298: l_error := 'JE SOURCES = OLD';
3299: l_product := 'GL';
3300: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3301: fnd_message.set_token('ERROR',l_error);
3302: fnd_message.set_token('PRODUCT',l_product);
3303: fnd_msg_pub.add;
3304: p_return_status := fnd_api.g_ret_sts_unexp_error;
3305: WHEN OTHERS THEN
3306: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

3325: EXCEPTION
3326: WHEN NO_DATA_FOUND THEN
3327: l_error := 'JE CATEGORY = OLD';
3328: l_product := 'GL';
3329: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3330: fnd_message.set_token('ERROR',l_error);
3331: fnd_message.set_token('PRODUCT',l_product);
3332: fnd_msg_pub.add;
3333: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

3326: WHEN NO_DATA_FOUND THEN
3327: l_error := 'JE CATEGORY = OLD';
3328: l_product := 'GL';
3329: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3330: fnd_message.set_token('ERROR',l_error);
3331: fnd_message.set_token('PRODUCT',l_product);
3332: fnd_msg_pub.add;
3333: p_return_status := fnd_api.g_ret_sts_unexp_error;
3334: WHEN OTHERS THEN

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

3327: l_error := 'JE CATEGORY = OLD';
3328: l_product := 'GL';
3329: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3330: fnd_message.set_token('ERROR',l_error);
3331: fnd_message.set_token('PRODUCT',l_product);
3332: fnd_msg_pub.add;
3333: p_return_status := fnd_api.g_ret_sts_unexp_error;
3334: WHEN OTHERS THEN
3335: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

3357: EXCEPTION
3358: WHEN NO_DATA_FOUND THEN
3359: l_error := 'ENCUMBRANCE TYPE = OLD';
3360: l_product := 'GL';
3361: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3362: fnd_message.set_token('ERROR',l_error);
3363: fnd_message.set_token('PRODUCT',l_product);
3364: fnd_msg_pub.add;
3365: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

3358: WHEN NO_DATA_FOUND THEN
3359: l_error := 'ENCUMBRANCE TYPE = OLD';
3360: l_product := 'GL';
3361: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3362: fnd_message.set_token('ERROR',l_error);
3363: fnd_message.set_token('PRODUCT',l_product);
3364: fnd_msg_pub.add;
3365: p_return_status := fnd_api.g_ret_sts_unexp_error;
3366: WHEN OTHERS THEN

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

3359: l_error := 'ENCUMBRANCE TYPE = OLD';
3360: l_product := 'GL';
3361: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
3362: fnd_message.set_token('ERROR',l_error);
3363: fnd_message.set_token('PRODUCT',l_product);
3364: fnd_msg_pub.add;
3365: p_return_status := fnd_api.g_ret_sts_unexp_error;
3366: WHEN OTHERS THEN
3367: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

4090: where enc_control_id = p_enc_control_id;
4091: end if;
4092: / * commented: Bug 2039196
4093: IF l_reversal_ac_failed = 'Y' THEN
4094: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
4095: fnd_message.set_token('GLCCID',x_lines_glccid);
4096: fnd_msg_pub.add;
4097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4098: END IF; * /

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

4091: end if;
4092: / * commented: Bug 2039196
4093: IF l_reversal_ac_failed = 'Y' THEN
4094: fnd_message.set_name('PSP','PSP_GL_REVERSE_AC_REJECT');
4095: fnd_message.set_token('GLCCID',x_lines_glccid);
4096: fnd_msg_pub.add;
4097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4098: END IF; * /
4099:

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

4105: SET gl_phase = 'INVALID_SUSPENSE'
4106: WHERE enc_control_id = p_enc_control_id;
4107: END IF;
4108: -- removed statement set invalid susp to 'Y' for 2479579
4109: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4110: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4111: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4112: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4113: fnd_msg_pub.add;

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

4106: WHERE enc_control_id = p_enc_control_id;
4107: END IF;
4108: -- removed statement set invalid susp to 'Y' for 2479579
4109: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4110: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4111: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4112: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4113: fnd_msg_pub.add;
4114: -- removed call enc_batch_end from here moved it to tr_to_gl for 2479579

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

4107: END IF;
4108: -- removed statement set invalid susp to 'Y' for 2479579
4109: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4110: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4111: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4112: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4113: fnd_msg_pub.add;
4114: -- removed call enc_batch_end from here moved it to tr_to_gl for 2479579
4115: END IF;

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

4108: -- removed statement set invalid susp to 'Y' for 2479579
4109: fnd_message.set_name('PSP','PSP_TR_GL_SUSP_AC_REJECT');
4110: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
4111: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
4112: fnd_message.set_token('ERROR_MSG',x_susp_failed_status);
4113: fnd_msg_pub.add;
4114: -- removed call enc_batch_end from here moved it to tr_to_gl for 2479579
4115: END IF;
4116: End of comment for Enh. Removal of suspense posting in Liquidation ***** /

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

4117:
4118: / *Commented for Restart Update/Quick Update Encumbrance Lines Enh.
4119: because of the introduction of get global suspense in previous fix 2056877
4120: IF l_suspense_ac_not_found = 'Y' THEN
4121: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4122: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4123: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4124: fnd_msg_pub.add;
4125: -- Bug 2039196: Introduced the if condn.

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

4118: / *Commented for Restart Update/Quick Update Encumbrance Lines Enh.
4119: because of the introduction of get global suspense in previous fix 2056877
4120: IF l_suspense_ac_not_found = 'Y' THEN
4121: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4122: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4123: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4124: fnd_msg_pub.add;
4125: -- Bug 2039196: Introduced the if condn.
4126: if p_mode = 'N' then

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

4119: because of the introduction of get global suspense in previous fix 2056877
4120: IF l_suspense_ac_not_found = 'Y' THEN
4121: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
4122: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
4123: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
4124: fnd_msg_pub.add;
4125: -- Bug 2039196: Introduced the if condn.
4126: if p_mode = 'N' then
4127: enc_batch_end(g_payroll_id,p_action_type, 'N',g_bg_id, g_sob_id,l_return_status);

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

4208: /***** Commented the following as part of bug fix 4625734
4209: / * Added Exceptions for bug 2056877 * /
4210: WHEN NO_PROFILE_EXISTS THEN
4211: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4212: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
4213: fnd_msg_pub.add;
4214: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4215:
4216: WHEN NO_VAL_DATE_MATCHES THEN

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

4214: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4215:
4216: WHEN NO_VAL_DATE_MATCHES THEN
4217: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4218: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4219: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4220: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4221: fnd_msg_pub.add;
4222: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

4215:
4216: WHEN NO_VAL_DATE_MATCHES THEN
4217: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4218: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4219: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4220: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4221: fnd_msg_pub.add;
4222: p_return_status := fnd_api.g_ret_sts_unexp_error;
4223: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579

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

4216: WHEN NO_VAL_DATE_MATCHES THEN
4217: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4218: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4219: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4220: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4221: fnd_msg_pub.add;
4222: p_return_status := fnd_api.g_ret_sts_unexp_error;
4223: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4224:

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

4223: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4224:
4225: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4226: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4227: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4228: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4229: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4230: fnd_msg_pub.add;
4231: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.

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

4224:
4225: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4226: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4227: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4228: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4229: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4230: fnd_msg_pub.add;
4231: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.
4232: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579

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

4225: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4226: g_error_api_path := SUBSTR('GL_ENC_TIE_BACK:'||g_error_api_path,1,230);
4227: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4228: fnd_message.set_token('ORG_NAME',l_orig_org_name);
4229: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
4230: fnd_msg_pub.add;
4231: p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification forBug 2056877.
4232: p_return_status := fnd_api.g_ret_sts_success; --- changed error to success for 2479579
4233: end of comment for bug fix 4625734 *****/

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

5263: EXCEPTION
5264: WHEN NO_DATA_FOUND THEN
5265: l_error := 'TRANSACTION SOURCE = GOLDE';
5266: l_product := 'GMS';
5267: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5268: fnd_message.set_token('ERROR',l_error);
5269: fnd_message.set_token('PRODUCT',l_product);
5270: fnd_msg_pub.add;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5264: WHEN NO_DATA_FOUND THEN
5265: l_error := 'TRANSACTION SOURCE = GOLDE';
5266: l_product := 'GMS';
5267: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5268: fnd_message.set_token('ERROR',l_error);
5269: fnd_message.set_token('PRODUCT',l_product);
5270: fnd_msg_pub.add;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5272: END;

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

5265: l_error := 'TRANSACTION SOURCE = GOLDE';
5266: l_product := 'GMS';
5267: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5268: fnd_message.set_token('ERROR',l_error);
5269: fnd_message.set_token('PRODUCT',l_product);
5270: fnd_msg_pub.add;
5271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5272: END;
5273: End of comment for bug fix 4625734 *****/

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

5277: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' transaction_source_cur transaction_source_cur'||transaction_source_cur%rowcount);
5278: CLOSE transaction_source_cur;
5279:
5280: IF (l_gms_transaction_source IS NULL) THEN
5281: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5282: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5283: fnd_message.set_token('PRODUCT','GMS');
5284: fnd_msg_pub.add;
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5278: CLOSE transaction_source_cur;
5279:
5280: IF (l_gms_transaction_source IS NULL) THEN
5281: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5282: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5283: fnd_message.set_token('PRODUCT','GMS');
5284: fnd_msg_pub.add;
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: END IF;

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

5279:
5280: IF (l_gms_transaction_source IS NULL) THEN
5281: fnd_message.set_name('PSP','PSP_TR_NOT_SET_UP');
5282: fnd_message.set_token('ERROR','TRANSACTION SOURCE = GOLDE');
5283: fnd_message.set_token('PRODUCT','GMS');
5284: fnd_msg_pub.add;
5285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5286: END IF;
5287: end if;

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

5390: l_raise_error := FALSE;
5391: FOR recno IN 1..r_interface.txn_interface_id.COUNT
5392: LOOP
5393: IF r_interface.employee_number(recno) IS NULL THEN
5394: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5395: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5396: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5397: fnd_msg_pub.add;
5398: l_raise_error := TRUE;

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

5391: FOR recno IN 1..r_interface.txn_interface_id.COUNT
5392: LOOP
5393: IF r_interface.employee_number(recno) IS NULL THEN
5394: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5395: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5396: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5397: fnd_msg_pub.add;
5398: l_raise_error := TRUE;
5399: END IF;

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

5392: LOOP
5393: IF r_interface.employee_number(recno) IS NULL THEN
5394: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5395: fnd_message.set_token('VALUE', 'person_id: ' || r_interface.person_id(recno));
5396: fnd_message.set_token('TABLE', 'PER_PEOPLE_F');
5397: fnd_msg_pub.add;
5398: l_raise_error := TRUE;
5399: END IF;
5400:

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

5398: l_raise_error := TRUE;
5399: END IF;
5400:
5401: IF r_interface.exp_org_name(recno) IS NULL THEN
5402: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5403: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5404: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5405: fnd_msg_pub.add;
5406: l_raise_error := TRUE;

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

5399: END IF;
5400:
5401: IF r_interface.exp_org_name(recno) IS NULL THEN
5402: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5403: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5404: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5405: fnd_msg_pub.add;
5406: l_raise_error := TRUE;
5407: END IF;

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

5400:
5401: IF r_interface.exp_org_name(recno) IS NULL THEN
5402: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5403: fnd_message.set_token('VALUE', 'org_id: ' || r_interface.expenditure_organization_id(recno));
5404: fnd_message.set_token('TABLE', 'HR_ORGANIZATION_UNITS');
5405: fnd_msg_pub.add;
5406: l_raise_error := TRUE;
5407: END IF;
5408:

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

5406: l_raise_error := TRUE;
5407: END IF;
5408:
5409: IF r_interface.operating_unit(recno) IS NULL THEN
5410: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5411: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5412: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5413: fnd_msg_pub.add;
5414: l_raise_error := TRUE;

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

5407: END IF;
5408:
5409: IF r_interface.operating_unit(recno) IS NULL THEN
5410: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5411: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5412: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5413: fnd_msg_pub.add;
5414: l_raise_error := TRUE;
5415: END IF;

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

5408:
5409: IF r_interface.operating_unit(recno) IS NULL THEN
5410: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5411: fnd_message.set_token('VALUE', 'operating_unit: ' || r_interface.operating_unit(recno));
5412: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5413: fnd_msg_pub.add;
5414: l_raise_error := TRUE;
5415: END IF;
5416:

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

5414: l_raise_error := TRUE;
5415: END IF;
5416:
5417: IF r_interface.project_number(recno) IS NULL THEN
5418: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5419: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5420: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5421: fnd_msg_pub.add;
5422: l_raise_error := TRUE;

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

5415: END IF;
5416:
5417: IF r_interface.project_number(recno) IS NULL THEN
5418: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5419: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5420: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5421: fnd_msg_pub.add;
5422: l_raise_error := TRUE;
5423: END IF;

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

5416:
5417: IF r_interface.project_number(recno) IS NULL THEN
5418: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5419: fnd_message.set_token('VALUE', 'project_id: ' || r_interface.project_id(recno));
5420: fnd_message.set_token('TABLE', 'PA_PROJECTS_ALL');
5421: fnd_msg_pub.add;
5422: l_raise_error := TRUE;
5423: END IF;
5424:

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

5422: l_raise_error := TRUE;
5423: END IF;
5424:
5425: IF r_interface.task_number(recno) IS NULL THEN
5426: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5427: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5428: fnd_message.set_token('TABLE', 'PA_TASKS');
5429: fnd_msg_pub.add;
5430: l_raise_error := TRUE;

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

5423: END IF;
5424:
5425: IF r_interface.task_number(recno) IS NULL THEN
5426: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5427: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5428: fnd_message.set_token('TABLE', 'PA_TASKS');
5429: fnd_msg_pub.add;
5430: l_raise_error := TRUE;
5431: END IF;

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

5424:
5425: IF r_interface.task_number(recno) IS NULL THEN
5426: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5427: fnd_message.set_token('VALUE', 'task_id: ' || r_interface.task_id(recno));
5428: fnd_message.set_token('TABLE', 'PA_TASKS');
5429: fnd_msg_pub.add;
5430: l_raise_error := TRUE;
5431: END IF;
5432: END LOOP;

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

5538:
5539: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5540:
5541: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5542: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5543: fnd_msg_pub.add;
5544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5545: END IF;
5546: END LOOP;

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

5595: EXCEPTION
5596: WHEN NO_DATA_FOUND THEN
5597: l_value := 'Person id ='||to_char(int_rec.person_id);
5598: l_table := 'PER_PEOPLE_F';
5599: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5600: fnd_message.set_token('VALUE',l_value);
5601: fnd_message.set_token('TABLE',l_table);
5602: fnd_msg_pub.add;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5596: WHEN NO_DATA_FOUND THEN
5597: l_value := 'Person id ='||to_char(int_rec.person_id);
5598: l_table := 'PER_PEOPLE_F';
5599: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5600: fnd_message.set_token('VALUE',l_value);
5601: fnd_message.set_token('TABLE',l_table);
5602: fnd_msg_pub.add;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END;

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

5597: l_value := 'Person id ='||to_char(int_rec.person_id);
5598: l_table := 'PER_PEOPLE_F';
5599: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5600: fnd_message.set_token('VALUE',l_value);
5601: fnd_message.set_token('TABLE',l_table);
5602: fnd_msg_pub.add;
5603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5604: END;
5605: --dbms_output.put_line('emp num='||l_emp_num);

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

5612: EXCEPTION
5613: WHEN NO_DATA_FOUND THEN
5614: l_value := 'Org id ='||to_char(int_rec.expenditure_organization_id);
5615: l_table := 'HR_ORGANIZATION_UNITS';
5616: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5617: fnd_message.set_token('VALUE',l_value);
5618: fnd_message.set_token('TABLE',l_table);
5619: fnd_msg_pub.add;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5613: WHEN NO_DATA_FOUND THEN
5614: l_value := 'Org id ='||to_char(int_rec.expenditure_organization_id);
5615: l_table := 'HR_ORGANIZATION_UNITS';
5616: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5617: fnd_message.set_token('VALUE',l_value);
5618: fnd_message.set_token('TABLE',l_table);
5619: fnd_msg_pub.add;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: END;

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

5614: l_value := 'Org id ='||to_char(int_rec.expenditure_organization_id);
5615: l_table := 'HR_ORGANIZATION_UNITS';
5616: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5617: fnd_message.set_token('VALUE',l_value);
5618: fnd_message.set_token('TABLE',l_table);
5619: fnd_msg_pub.add;
5620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5621: END;
5622: --dbms_output.put_line('org name='||l_org_name);

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

5629: EXCEPTION
5630: WHEN NO_DATA_FOUND THEN
5631: l_value := 'Project id ='||to_char(int_rec.project_id);
5632: l_table := 'PA_PROJECTS_ALL';
5633: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5634: fnd_message.set_token('VALUE',l_value);
5635: fnd_message.set_token('TABLE',l_table);
5636: fnd_msg_pub.add;
5637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5630: WHEN NO_DATA_FOUND THEN
5631: l_value := 'Project id ='||to_char(int_rec.project_id);
5632: l_table := 'PA_PROJECTS_ALL';
5633: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5634: fnd_message.set_token('VALUE',l_value);
5635: fnd_message.set_token('TABLE',l_table);
5636: fnd_msg_pub.add;
5637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5638: END;

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

5631: l_value := 'Project id ='||to_char(int_rec.project_id);
5632: l_table := 'PA_PROJECTS_ALL';
5633: fnd_message.set_name('PSP','PSP_ORG_VALUE_NOT_FOUND');
5634: fnd_message.set_token('VALUE',l_value);
5635: fnd_message.set_token('TABLE',l_table);
5636: fnd_msg_pub.add;
5637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5638: END;
5639:

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

5645: EXCEPTION
5646: WHEN NO_DATA_FOUND THEN
5647: l_value := 'Project id ='||to_char(int_rec.project_id);
5648: l_table := 'PA_PROJECTS_ALL';
5649: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5650: fnd_message.set_token('VALUE',l_value);
5651: fnd_message.set_token('TABLE',l_table);
5652: fnd_msg_pub.add;
5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5646: WHEN NO_DATA_FOUND THEN
5647: l_value := 'Project id ='||to_char(int_rec.project_id);
5648: l_table := 'PA_PROJECTS_ALL';
5649: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5650: fnd_message.set_token('VALUE',l_value);
5651: fnd_message.set_token('TABLE',l_table);
5652: fnd_msg_pub.add;
5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5654: END;

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

5647: l_value := 'Project id ='||to_char(int_rec.project_id);
5648: l_table := 'PA_PROJECTS_ALL';
5649: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5650: fnd_message.set_token('VALUE',l_value);
5651: fnd_message.set_token('TABLE',l_table);
5652: fnd_msg_pub.add;
5653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5654: END;
5655: --dbms_output.put_line('seg1='||l_seg1);

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

5662: EXCEPTION
5663: WHEN NO_DATA_FOUND THEN
5664: l_value := 'Task id ='||to_char(int_rec.task_id);
5665: l_table := 'PA_TASKS';
5666: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5667: fnd_message.set_token('VALUE',l_value);
5668: fnd_message.set_token('TABLE',l_table);
5669: fnd_msg_pub.add;
5670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

5663: WHEN NO_DATA_FOUND THEN
5664: l_value := 'Task id ='||to_char(int_rec.task_id);
5665: l_table := 'PA_TASKS';
5666: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5667: fnd_message.set_token('VALUE',l_value);
5668: fnd_message.set_token('TABLE',l_table);
5669: fnd_msg_pub.add;
5670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5671: END;

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

5664: l_value := 'Task id ='||to_char(int_rec.task_id);
5665: l_table := 'PA_TASKS';
5666: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
5667: fnd_message.set_token('VALUE',l_value);
5668: fnd_message.set_token('TABLE',l_table);
5669: fnd_msg_pub.add;
5670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5671: END;
5672: --dbms_output.put_line('task='||l_task_number);

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

5777:
5778: gms_transactions_pub.LOAD_GMS_XFACE_API(gms_rec, l_return_status);
5779:
5780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5781: fnd_message.set_name('PSP','PSP_GMS_XFACE_FAILED');
5782: fnd_msg_pub.add;
5783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5784: END IF;
5785:

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

5833: --dbms_output.put_line('Req id = '||to_char(req_id));
5834:
5835: IF req_id_tab(request_counter) = 0 THEN
5836: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submission of Transaction Import Failed');
5837: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5838: fnd_msg_pub.add;
5839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5840: ELSE
5841: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Submitted Transaction Import');

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

5888: rphase, rstatus, dphase, dstatus, message);
5889:
5890: IF call_status = FALSE then
5891: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import failed');
5892: fnd_message.set_name('PSP','PSP_TR_GMS_IMP_FAILED');
5893: fnd_msg_pub.add;
5894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5895: END IF;
5896: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Transaction Import completed');

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

6885: End of Comment for bug fix 4625734 *****/
6886:
6887: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6888: IF l_suspense_ac_failed = 'Y' THEN
6889: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6890: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6891: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6892: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6893: fnd_msg_pub.add;

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

6886:
6887: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6888: IF l_suspense_ac_failed = 'Y' THEN
6889: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6890: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6891: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6892: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6893: fnd_msg_pub.add;
6894: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /

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

6887: /***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
6888: IF l_suspense_ac_failed = 'Y' THEN
6889: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6890: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6891: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6892: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6893: fnd_msg_pub.add;
6894: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /
6895: IF p_action_type IN ('Q','U') THEN

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

6888: IF l_suspense_ac_failed = 'Y' THEN
6889: fnd_message.set_name('PSP','PSP_TR_GMS_SUSP_AC_REJECT');
6890: fnd_message.set_token('ORG_NAME',x_susp_failed_org_name);
6891: fnd_message.set_token('PAYROLL_DATE',x_susp_failed_date);
6892: fnd_message.set_token('ERROR_MSG',x_susp_failed_reject_code);
6893: fnd_msg_pub.add;
6894: / * Added the below IF condition for Restart Update/Quick Update Encumbrance Lines Enh. * /
6895: IF p_action_type IN ('Q','U') THEN
6896: UPDATE psp_enc_controls

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

6904:
6905: /* Commented for Restart Update/Quick Update Encumbrance Lines
6906: because global suspense function introduced,this situation is handled there.
6907: IF l_suspense_ac_not_found = 'Y' THEN
6908: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
6909: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
6910: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
6911: fnd_msg_pub.add;
6912: -- Bug 2039196: Introduced the if condn.

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

6905: /* Commented for Restart Update/Quick Update Encumbrance Lines
6906: because global suspense function introduced,this situation is handled there.
6907: IF l_suspense_ac_not_found = 'Y' THEN
6908: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
6909: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
6910: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
6911: fnd_msg_pub.add;
6912: -- Bug 2039196: Introduced the if condn.
6913: if p_mode = 'N' then

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

6906: because global suspense function introduced,this situation is handled there.
6907: IF l_suspense_ac_not_found = 'Y' THEN
6908: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_NOT_EXIST');
6909: fnd_message.set_token('ORG_NAME',x_susp_nf_org_name);
6910: fnd_message.set_token('PAYROLL_DATE',x_susp_nf_date);
6911: fnd_msg_pub.add;
6912: -- Bug 2039196: Introduced the if condn.
6913: if p_mode = 'N' then
6914: enc_batch_end(g_payroll_id,g_action_type, 'N',g_bg_id, g_sob_id,l_return_status);

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

7057: /* Added Exceptions for Bug 2056877 */
7058: /***** Commented the following for bgu fix 4625734
7059: WHEN NO_PROFILE_EXISTS THEN
7060: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7061: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
7062: fnd_msg_pub.add;
7063: --p_return_status := fnd_api.g_ret_sts_unexp_error;
7064: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
7065:

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

7064: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
7065:
7066: WHEN NO_VAL_DATE_MATCHES THEN
7067: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7068: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
7069: fnd_message.set_token('ORG_NAME',l_orig_org_name);
7070: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
7071: fnd_msg_pub.add;
7072: --p_return_status := fnd_api.g_ret_sts_unexp_error;

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

7065:
7066: WHEN NO_VAL_DATE_MATCHES THEN
7067: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7068: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
7069: fnd_message.set_token('ORG_NAME',l_orig_org_name);
7070: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
7071: fnd_msg_pub.add;
7072: --p_return_status := fnd_api.g_ret_sts_unexp_error;
7073: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579

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

7066: WHEN NO_VAL_DATE_MATCHES THEN
7067: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7068: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
7069: fnd_message.set_token('ORG_NAME',l_orig_org_name);
7070: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
7071: fnd_msg_pub.add;
7072: --p_return_status := fnd_api.g_ret_sts_unexp_error;
7073: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
7074:

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

7073: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
7074:
7075: WHEN NO_GLOBAL_ACCT_EXISTS THEN
7076: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
7078: fnd_message.set_token('ORG_NAME',l_orig_org_name);
7079: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
7080: fnd_msg_pub.add;
7081: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.

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

7074:
7075: WHEN NO_GLOBAL_ACCT_EXISTS THEN
7076: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
7078: fnd_message.set_token('ORG_NAME',l_orig_org_name);
7079: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
7080: fnd_msg_pub.add;
7081: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
7082: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579

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

7075: WHEN NO_GLOBAL_ACCT_EXISTS THEN
7076: g_error_api_path := SUBSTR('GMS_ENC_TIE_BACK:'||g_error_api_path,1,230);
7077: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
7078: fnd_message.set_token('ORG_NAME',l_orig_org_name);
7079: fnd_message.set_token('PAYROLL_DATE',l_encumbrance_date);
7080: fnd_msg_pub.add;
7081: --p_return_status := fnd_api.g_ret_sts_unexp_error; --End of Modification for Bug 2056877.
7082: p_return_status := fnd_api.g_ret_sts_success; --- replaced error with success for 2479579
7083: End of comment for bug fix 4625734 *****/

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

7222: END LOOP;
7223: CLOSE get_rec_to_move;
7224:
7225: IF p_action_type = 'Q' THEN
7226: fnd_message.set_name('PSP','PSP_ENC_NUM_ASG');
7227: fnd_message.set_token('NUM_ASG',no_of_asg);
7228: fnd_msg_pub.add;
7229: psp_message_s.print_error (p_mode => FND_FILE.LOG,
7230: p_print_header => FND_API.G_FALSE);

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

7223: CLOSE get_rec_to_move;
7224:
7225: IF p_action_type = 'Q' THEN
7226: fnd_message.set_name('PSP','PSP_ENC_NUM_ASG');
7227: fnd_message.set_token('NUM_ASG',no_of_asg);
7228: fnd_msg_pub.add;
7229: psp_message_s.print_error (p_mode => FND_FILE.LOG,
7230: p_print_header => FND_API.G_FALSE);
7231: END IF;

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

7360: OPEN get_full_name_cur(p_person_id, p_actual_term_date);
7361: FETCH get_full_name_cur INTO l_full_name2;
7362: CLOSE get_full_name_cur;
7363:
7364: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7365: fnd_message.set_token('PERSON1', l_full_name1);
7366: fnd_message.set_token('TERMDATE1', l_termination_date1);
7367: fnd_message.set_token('PERSON2', l_full_name2);
7368: fnd_message.set_token('TERMDATE2', p_actual_term_date);

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

7361: FETCH get_full_name_cur INTO l_full_name2;
7362: CLOSE get_full_name_cur;
7363:
7364: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7365: fnd_message.set_token('PERSON1', l_full_name1);
7366: fnd_message.set_token('TERMDATE1', l_termination_date1);
7367: fnd_message.set_token('PERSON2', l_full_name2);
7368: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7369: fnd_msg_pub.add;

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

7362: CLOSE get_full_name_cur;
7363:
7364: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7365: fnd_message.set_token('PERSON1', l_full_name1);
7366: fnd_message.set_token('TERMDATE1', l_termination_date1);
7367: fnd_message.set_token('PERSON2', l_full_name2);
7368: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7369: fnd_msg_pub.add;
7370:

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

7363:
7364: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7365: fnd_message.set_token('PERSON1', l_full_name1);
7366: fnd_message.set_token('TERMDATE1', l_termination_date1);
7367: fnd_message.set_token('PERSON2', l_full_name2);
7368: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7369: fnd_msg_pub.add;
7370:
7371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

7364: fnd_message.set_name('PSP', 'PSP_ENC_LIQ_TERM_EMP_MISMATCH');
7365: fnd_message.set_token('PERSON1', l_full_name1);
7366: fnd_message.set_token('TERMDATE1', l_termination_date1);
7367: fnd_message.set_token('PERSON2', l_full_name2);
7368: fnd_message.set_token('TERMDATE2', p_actual_term_date);
7369: fnd_msg_pub.add;
7370:
7371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7372: END IF;