eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FD_USER_API_PUB dependencies on FND_API

Line 17: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

13: p_debug_text IN VARCHAR2);
14:
15: PROCEDURE Validate_Method_and_Profile (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
18: p_payment_method_code IN VARCHAR2,
19: p_ppp_id IN NUMBER,
20: p_payment_document_id IN NUMBER,
21: p_crt_instr_flag IN VARCHAR2,

Line 83: IF NOT FND_API.Compatible_API_Call(l_api_version,

79:
80:
81: BEGIN
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call(l_api_version,
84: p_api_version,
85: l_api_name,
86: G_PKG_NAME) THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: IF NOT FND_API.Compatible_API_Call(l_api_version,
84: p_api_version,
85: l_api_name,
86: G_PKG_NAME) THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 91: IF FND_API.to_Boolean(p_init_msg_list) THEN

87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 96: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
97:
98: IF p_payment_method_code is not null THEN
99: print_debuginfo(l_module_name,'Payment method ' || p_payment_method_code || ' is to be validated.');
100:

Line 124: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 147: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

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;
246:
247: END IF; -- if payment profile is not null

Line 255: x_return_status := FND_API.G_RET_STS_ERROR;

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
258: select nvl(DEFAULT_PAYMENT_DOCUMENT_ID, -1),
259: processing_type

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 281: x_return_status := FND_API.G_RET_STS_ERROR;

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;
284:
285: -- End of API body.

Line 293: WHEN FND_API.G_EXC_ERROR THEN

289:
290: print_debuginfo(l_module_name, 'RETURN Validate_Method_Profile');
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));

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290: print_debuginfo(l_module_name, 'RETURN Validate_Method_Profile');
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:

Line 299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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));

Line 300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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:

Line 306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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);

Line 429: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

425: END Pmt_Instr_Action_Enabled;
426:
427: PROCEDURE retrieve_default_sra_format(
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
430: p_instr_id IN NUMBER,
431: x_default_sra_format_code OUT NOCOPY VARCHAR2,
432: x_default_sra_format_name OUT NOCOPY VARCHAR2,
433: x_return_status OUT NOCOPY VARCHAR2,

Line 444: IF NOT FND_API.Compatible_API_Call(l_api_version,

440:
441: l_instr_sra_ok NUMBER;
442: BEGIN
443: -- Standard call to check for call compatibility.
444: IF NOT FND_API.Compatible_API_Call(l_api_version,
445: p_api_version,
446: l_api_name,
447: G_PKG_NAME) THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444: IF NOT FND_API.Compatible_API_Call(l_api_version,
445: p_api_version,
446: l_api_name,
447: G_PKG_NAME) THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 452: IF FND_API.to_Boolean(p_init_msg_list) THEN

448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
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);

Line 503: WHEN FND_API.G_EXC_ERROR THEN

499:
500: print_debuginfo(l_module_name, 'RETURN retrieve_default_sra_format');
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));

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500: print_debuginfo(l_module_name, 'RETURN retrieve_default_sra_format');
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:

Line 509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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));

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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:

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

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
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

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_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;
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);