DBA Data[Home] [Help]

APPS.IBY_FD_USER_API_PUB dependencies on FND_MSG_PUB

Line 92: FND_MSG_PUB.initialize;

88: END IF;
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean(p_init_msg_list) THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94:
95: -- Initialize API return status to success
96: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 122: FND_MSG_PUB.Add;

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;
126: END LOOP;

Line 145: FND_MSG_PUB.Add;

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;
149: END LOOP;

Line 178: FND_MSG_PUB.Add;

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;
182: END LOOP;

Line 201: FND_MSG_PUB.Add;

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;
205: END LOOP;

Line 219: FND_MSG_PUB.Add;

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;
223: END LOOP;

Line 241: FND_MSG_PUB.Add;

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;
245: END IF;

Line 253: FND_MSG_PUB.Add;

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
257: IF p_payment_document_id is null THEN

Line 268: FND_MSG_PUB.Add;

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;
272: END IF;

Line 279: FND_MSG_PUB.Add;

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;
283: END IF;

Line 288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

284:
285: -- End of API body.
286:
287: -- Standard call to get message count and if count is 1, get message info.
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
289:
290: print_debuginfo(l_module_name, 'RETURN Validate_Method_Profile');
291:
292: EXCEPTION

Line 295: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

291:
292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
296: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
297: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
298:
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

297: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
298:
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
302: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
303: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
304:
305: WHEN OTHERS THEN

Line 307: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

303: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
304:
305: WHEN OTHERS THEN
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
309: END IF;
310: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
311: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');

Line 308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

304:
305: WHEN OTHERS THEN
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
309: END IF;
310: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
311: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
312: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));

Line 310: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
308: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
309: END IF;
310: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
311: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
312: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
313:
314: END Validate_Method_and_Profile;

Line 453: FND_MSG_PUB.initialize;

449: END IF;
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean(p_init_msg_list) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: -- Initialize API return status to success
457: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 462: FND_MSG_PUB.Add;

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:
466: select count(*)

Line 478: FND_MSG_PUB.Add;

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,
482: f.format_name

Line 498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

494:
495: -- End of API body.
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
499:
500: print_debuginfo(l_module_name, 'RETURN retrieve_default_sra_format');
501:
502: EXCEPTION

Line 505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

501:
502: EXCEPTION
503: WHEN FND_API.G_EXC_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
506: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
507: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

507: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
512: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
513: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
514:
515: WHEN SRA_INVALID_INSTR THEN

Line 517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

513: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
514:
515: WHEN SRA_INVALID_INSTR THEN
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
518: print_debuginfo(l_module_name,'ERROR: The payment instruction is not available for SRA. ');
519:
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 522: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

518: print_debuginfo(l_module_name,'ERROR: The payment instruction is not available for SRA. ');
519:
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
523: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
524: END IF;
525: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
526: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');

Line 523: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

519:
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
523: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
524: END IF;
525: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
526: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
527: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));

Line 525: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
523: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
524: END IF;
525: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
526: print_debuginfo(l_module_name,'Other ERROR: Exception occured during call to API ');
527: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
528:
529: END retrieve_default_sra_format;