DBA Data[Home] [Help]

APPS.IBY_FD_USER_API_PUB dependencies on FND_MESSAGE

Line 119: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_LE');

115: into l_le_name
116: from XLE_FIRSTPARTY_INFORMATION_V
117: where legal_entity_id = p_le_arr(i);
118:
119: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_LE');
120: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
121: FND_MESSAGE.SET_TOKEN('OBJECT', l_le_name);
122: FND_MSG_PUB.Add;
123:

Line 120: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);

116: from XLE_FIRSTPARTY_INFORMATION_V
117: where legal_entity_id = p_le_arr(i);
118:
119: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_LE');
120: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
121: FND_MESSAGE.SET_TOKEN('OBJECT', l_le_name);
122: FND_MSG_PUB.Add;
123:
124: x_return_status := FND_API.G_RET_STS_ERROR;

Line 121: FND_MESSAGE.SET_TOKEN('OBJECT', l_le_name);

117: where legal_entity_id = p_le_arr(i);
118:
119: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_LE');
120: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
121: FND_MESSAGE.SET_TOKEN('OBJECT', l_le_name);
122: FND_MSG_PUB.Add;
123:
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END IF;

Line 142: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_ORG');

138: into l_org_name
139: from HR_ALL_ORGANIZATION_UNITS_VL
140: where organization_id = p_org_arr(i).org_id;
141:
142: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_ORG');
143: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
144: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
145: FND_MSG_PUB.Add;
146:

Line 143: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);

139: from HR_ALL_ORGANIZATION_UNITS_VL
140: where organization_id = p_org_arr(i).org_id;
141:
142: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_ORG');
143: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
144: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
145: FND_MSG_PUB.Add;
146:
147: x_return_status := FND_API.G_RET_STS_ERROR;

Line 144: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);

140: where organization_id = p_org_arr(i).org_id;
141:
142: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_METHOD_ORG');
143: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
144: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
145: FND_MSG_PUB.Add;
146:
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: END IF;

Line 175: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ACC');

171: into l_acc_name
172: from CE_INTERNAL_BANK_ACCOUNTS_V
173: where bank_account_id = p_int_bank_acc_arr(i);
174:
175: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ACC');
176: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
177: FND_MESSAGE.SET_TOKEN('OBJECT', l_acc_name);
178: FND_MSG_PUB.Add;
179:

Line 176: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);

172: from CE_INTERNAL_BANK_ACCOUNTS_V
173: where bank_account_id = p_int_bank_acc_arr(i);
174:
175: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ACC');
176: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
177: FND_MESSAGE.SET_TOKEN('OBJECT', l_acc_name);
178: FND_MSG_PUB.Add;
179:
180: x_return_status := FND_API.G_RET_STS_ERROR;

Line 177: FND_MESSAGE.SET_TOKEN('OBJECT', l_acc_name);

173: where bank_account_id = p_int_bank_acc_arr(i);
174:
175: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ACC');
176: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
177: FND_MESSAGE.SET_TOKEN('OBJECT', l_acc_name);
178: FND_MSG_PUB.Add;
179:
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: END IF;

Line 198: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ORG');

194: into l_org_name
195: from HR_ALL_ORGANIZATION_UNITS_VL
196: where organization_id = p_org_arr(i).org_id;
197:
198: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ORG');
199: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
200: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
201: FND_MSG_PUB.Add;
202:

Line 199: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);

195: from HR_ALL_ORGANIZATION_UNITS_VL
196: where organization_id = p_org_arr(i).org_id;
197:
198: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ORG');
199: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
200: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
201: FND_MSG_PUB.Add;
202:
203: x_return_status := FND_API.G_RET_STS_ERROR;

Line 200: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);

196: where organization_id = p_org_arr(i).org_id;
197:
198: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_ORG');
199: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
200: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
201: FND_MSG_PUB.Add;
202:
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: END IF;

Line 216: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_CURR');

212: FETCH profile_appl_cur INTO l_count;
213: CLOSE profile_appl_cur;
214:
215: IF l_count = 0 THEN
216: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_CURR');
217: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
218: FND_MESSAGE.SET_TOKEN('OBJECT', p_curr_arr(i));
219: FND_MSG_PUB.Add;
220:

Line 217: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);

213: CLOSE profile_appl_cur;
214:
215: IF l_count = 0 THEN
216: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_CURR');
217: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
218: FND_MESSAGE.SET_TOKEN('OBJECT', p_curr_arr(i));
219: FND_MSG_PUB.Add;
220:
221: x_return_status := FND_API.G_RET_STS_ERROR;

Line 218: FND_MESSAGE.SET_TOKEN('OBJECT', p_curr_arr(i));

214:
215: IF l_count = 0 THEN
216: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_CURR');
217: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
218: FND_MESSAGE.SET_TOKEN('OBJECT', p_curr_arr(i));
219: FND_MSG_PUB.Add;
220:
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: END IF;

Line 238: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_METHOD');

234: and ap.applicable_type_code = 'PAYMENT_METHOD'
235: and (ap.applicable_value_to is null OR ap.applicable_value_to = p_payment_method_code);
236:
237: IF l_count = 0 THEN
238: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_METHOD');
239: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
240: FND_MESSAGE.SET_TOKEN('OBJECT', l_method_name);
241: FND_MSG_PUB.Add;
242:

Line 239: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);

235: and (ap.applicable_value_to is null OR ap.applicable_value_to = p_payment_method_code);
236:
237: IF l_count = 0 THEN
238: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_METHOD');
239: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
240: FND_MESSAGE.SET_TOKEN('OBJECT', l_method_name);
241: FND_MSG_PUB.Add;
242:
243: x_return_status := FND_API.G_RET_STS_ERROR;

Line 240: FND_MESSAGE.SET_TOKEN('OBJECT', l_method_name);

236:
237: IF l_count = 0 THEN
238: FND_MESSAGE.set_name('IBY', 'IBY_AP_VLDT_PROF_METHOD');
239: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
240: FND_MESSAGE.SET_TOKEN('OBJECT', l_method_name);
241: FND_MSG_PUB.Add;
242:
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: END IF;

Line 252: FND_MESSAGE.set_name('IBY', 'IBY_BUILD_INV_PARAMS');

248:
249: -- Validate Create Instruction Flag, etc.
250: IF p_crt_instr_flag = 'Y' THEN
251: IF p_ppp_id is null THEN
252: FND_MESSAGE.set_name('IBY', 'IBY_BUILD_INV_PARAMS');
253: FND_MSG_PUB.Add;
254:
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: ELSE

Line 267: FND_MESSAGE.set_name('IBY', 'IBY_APSUB_NO_DEFAULT_PMT_DOC');

263: where payment_profile_id = p_ppp_id;
264:
265: IF (l_payment_document_id = -1) and
266: (l_proc_type = 'PRINTED') THEN
267: FND_MESSAGE.set_name('IBY', 'IBY_APSUB_NO_DEFAULT_PMT_DOC');
268: FND_MSG_PUB.Add;
269:
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: END IF;

Line 278: FND_MESSAGE.set_name('IBY', 'IBY_BUILD_MISS_PMT_DOC_REL_PAR');

274: END IF;
275:
276: IF p_payment_document_id is not null THEN
277: IF p_ppp_id is null OR p_int_bank_acc_arr.COUNT = 0 THEN
278: FND_MESSAGE.set_name('IBY', 'IBY_BUILD_MISS_PMT_DOC_REL_PAR');
279: FND_MSG_PUB.Add;
280:
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: END IF;

Line 460: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');

456: -- Initialize API return status to success
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: IF p_instr_id is null THEN
460: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');
461: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);
462: FND_MSG_PUB.Add;
463: raise SRA_INVALID_INSTR;
464: END IF;

Line 461: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);

457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: IF p_instr_id is null THEN
460: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');
461: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);
462: FND_MSG_PUB.Add;
463: raise SRA_INVALID_INSTR;
464: END IF;
465:

Line 476: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');

472: and payment_instruction_status not in ('CREATION_ERROR', 'RETRY_CREATION', 'TERMINATED')
473: and IBY_FD_POST_PICP_PROGS_PVT.val_instruction_accessible(p_instr_id) = 'Y';
474:
475: IF l_instr_sra_ok = 0 THEN
476: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');
477: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);
478: FND_MSG_PUB.Add;
479: raise SRA_INVALID_INSTR;
480: ELSE

Line 477: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);

473: and IBY_FD_POST_PICP_PROGS_PVT.val_instruction_accessible(p_instr_id) = 'Y';
474:
475: IF l_instr_sra_ok = 0 THEN
476: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');
477: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);
478: FND_MSG_PUB.Add;
479: raise SRA_INVALID_INSTR;
480: ELSE
481: select sra_setup.remittance_advice_format_code,