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 29: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

25: p_debug_text IN VARCHAR2);
26:
27: PROCEDURE Validate_Method_and_Profile (
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
30: p_payment_method_code IN VARCHAR2,
31: p_ppp_id IN NUMBER,
32: p_payment_document_id IN NUMBER,
33: p_crt_instr_flag IN VARCHAR2,

Line 95: IF NOT FND_API.Compatible_API_Call(l_api_version,

91:
92:
93: BEGIN
94: -- Standard call to check for call compatibility.
95: IF NOT FND_API.Compatible_API_Call(l_api_version,
96: p_api_version,
97: l_api_name,
98: G_PKG_NAME) THEN
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

95: IF NOT FND_API.Compatible_API_Call(l_api_version,
96: p_api_version,
97: l_api_name,
98: G_PKG_NAME) THEN
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100: END IF;
101:
102: -- Initialize message list if p_init_msg_list is set to TRUE.
103: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 103: IF FND_API.to_Boolean(p_init_msg_list) THEN

99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100: END IF;
101:
102: -- Initialize message list if p_init_msg_list is set to TRUE.
103: IF FND_API.to_Boolean(p_init_msg_list) THEN
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: -- Initialize API return status to success

Line 108: x_return_status := FND_API.G_RET_STS_SUCCESS;

104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: -- Initialize API return status to success
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: IF p_payment_method_code is not null THEN
111: print_debuginfo(l_module_name,'Payment method ' || p_payment_method_code || ' is to be validated.');
112:

Line 136: x_return_status := FND_API.G_RET_STS_ERROR;

132: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
133: FND_MESSAGE.SET_TOKEN('OBJECT', l_le_name);
134: FND_MSG_PUB.Add;
135:
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: END IF;
138: END LOOP;
139: END IF;
140:

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

155: FND_MESSAGE.SET_TOKEN('METHOD', l_method_name);
156: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
157: FND_MSG_PUB.Add;
158:
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: END IF;
161: END LOOP;
162: END IF;
163:

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
189: FND_MESSAGE.SET_TOKEN('OBJECT', l_acc_name);
190: FND_MSG_PUB.Add;
191:
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;
194: END LOOP;
195: END IF;
196:

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
212: FND_MESSAGE.SET_TOKEN('OBJECT', l_org_name);
213: FND_MSG_PUB.Add;
214:
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: END IF;
217: END LOOP;
218: END IF;
219:

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
230: FND_MESSAGE.SET_TOKEN('OBJECT', p_curr_arr(i));
231: FND_MSG_PUB.Add;
232:
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: END IF;
235: END LOOP;
236: END IF;
237:

Line 255: x_return_status := FND_API.G_RET_STS_ERROR;

251: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
252: FND_MESSAGE.SET_TOKEN('OBJECT', l_method_name);
253: FND_MSG_PUB.Add;
254:
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;
257: END IF;
258:
259: END IF; -- if payment profile is not null

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;*/

264: /*
265: FND_MESSAGE.set_name('IBY', 'IBY_BUILD_INV_PARAMS');
266: FND_MSG_PUB.Add;
267:
268: x_return_status := FND_API.G_RET_STS_ERROR;*/
269: print_debuginfo(l_module_name,'Payment profile entry considered optional after bug 8781032');
270: ELSE
271: IF p_payment_document_id is null THEN
272: select nvl(DEFAULT_PAYMENT_DOCUMENT_ID, -1),

Line 284: x_return_status := FND_API.G_RET_STS_ERROR;

280: (l_proc_type = 'PRINTED') THEN
281: FND_MESSAGE.set_name('IBY', 'IBY_APSUB_NO_DEFAULT_PMT_DOC');
282: FND_MSG_PUB.Add;
283:
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: END IF;
286: END IF;
287: END IF;
288: END IF;

Line 295: x_return_status := FND_API.G_RET_STS_ERROR;

291: IF p_ppp_id is null OR p_int_bank_acc_arr.COUNT = 0 THEN
292: FND_MESSAGE.set_name('IBY', 'IBY_BUILD_MISS_PMT_DOC_REL_PAR');
293: FND_MSG_PUB.Add;
294:
295: x_return_status := FND_API.G_RET_STS_ERROR;
296: END IF;
297: END IF;
298:
299: -- End of API body.

Line 307: WHEN FND_API.G_EXC_ERROR THEN

303:
304: print_debuginfo(l_module_name, 'RETURN Validate_Method_Profile');
305:
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
310: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
311: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));

Line 308: x_return_status := FND_API.G_RET_STS_ERROR;

304: print_debuginfo(l_module_name, 'RETURN Validate_Method_Profile');
305:
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
310: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
311: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
312:

Line 313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
310: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
311: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
316: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
317: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

310: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
311: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
316: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
317: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
318:

Line 320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

316: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
317: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
318:
319: WHEN OTHERS THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
322: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
323: END IF;
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 569: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

565: END Pmt_Instr_Action_Enabled;
566:
567: PROCEDURE retrieve_default_sra_format(
568: p_api_version IN NUMBER,
569: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
570: p_instr_id IN NUMBER,
571: x_default_sra_format_code OUT NOCOPY VARCHAR2,
572: x_default_sra_format_name OUT NOCOPY VARCHAR2,
573: x_return_status OUT NOCOPY VARCHAR2,

Line 584: IF NOT FND_API.Compatible_API_Call(l_api_version,

580:
581: l_instr_sra_ok NUMBER;
582: BEGIN
583: -- Standard call to check for call compatibility.
584: IF NOT FND_API.Compatible_API_Call(l_api_version,
585: p_api_version,
586: l_api_name,
587: G_PKG_NAME) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584: IF NOT FND_API.Compatible_API_Call(l_api_version,
585: p_api_version,
586: l_api_name,
587: G_PKG_NAME) THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: -- Initialize message list if p_init_msg_list is set to TRUE.
592: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 592: IF FND_API.to_Boolean(p_init_msg_list) THEN

588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590:
591: -- Initialize message list if p_init_msg_list is set to TRUE.
592: IF FND_API.to_Boolean(p_init_msg_list) THEN
593: FND_MSG_PUB.initialize;
594: END IF;
595:
596: -- Initialize API return status to success

Line 597: x_return_status := FND_API.G_RET_STS_SUCCESS;

593: FND_MSG_PUB.initialize;
594: END IF;
595:
596: -- Initialize API return status to success
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598:
599: IF p_instr_id is null THEN
600: FND_MESSAGE.set_name('IBY', 'IBY_SRA_SUBMIT_INVALID_INSTR');
601: FND_MESSAGE.SET_TOKEN('INSTR_ID', p_instr_id);

Line 643: WHEN FND_API.G_EXC_ERROR THEN

639:
640: print_debuginfo(l_module_name, 'RETURN retrieve_default_sra_format');
641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
646: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
647: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));

Line 644: x_return_status := FND_API.G_RET_STS_ERROR;

640: print_debuginfo(l_module_name, 'RETURN retrieve_default_sra_format');
641:
642: EXCEPTION
643: WHEN FND_API.G_EXC_ERROR THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
646: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
647: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
648:

Line 649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

645: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
646: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
647: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
648:
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
652: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
653: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

646: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
647: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
648:
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
652: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
653: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
654:

Line 656: x_return_status := FND_API.G_RET_STS_ERROR;

652: print_debuginfo(l_module_name,'Unexpected ERROR: Exception occured during call to API ');
653: print_debuginfo(l_module_name,'SQLerr is :' || substr(SQLERRM, 1, 150));
654:
655: WHEN SRA_INVALID_INSTR THEN
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
658: print_debuginfo(l_module_name,'ERROR: The payment instruction is not available for SRA. ');
659:
660: WHEN OTHERS THEN

Line 661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

657: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
658: print_debuginfo(l_module_name,'ERROR: The payment instruction is not available for SRA. ');
659:
660: WHEN OTHERS THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
664: END IF;
665: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);