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_POST_PICP_PROGS_PVT dependencies on FND_API

Line 35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

31: -- APIs Start
32: PROCEDURE Process_Federal_Summary_Format
33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,

Line 36: p_commit IN VARCHAR2 := FND_API.G_FALSE,

32: PROCEDURE Process_Federal_Summary_Format
33: (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: p_payment_instruction_id IN NUMBER,

Line 59: IF NOT fnd_api.compatible_api_call(l_api_version,

55: SAVEPOINT l_rollback_point;
56:
57:
58: -- standard call to check for call compatibility.
59: IF NOT fnd_api.compatible_api_call(l_api_version,
60: p_api_version,
61: l_api_name,
62: g_pkg_name)
63: THEN

Line 64: RAISE fnd_api.g_exc_unexpected_error;

60: p_api_version,
61: l_api_name,
62: g_pkg_name)
63: THEN
64: RAISE fnd_api.g_exc_unexpected_error;
65: END IF;
66:
67: -- initialize message list if p_init_msg_list is set to true.
68: IF fnd_api.to_boolean(p_init_msg_list)

Line 68: IF fnd_api.to_boolean(p_init_msg_list)

64: RAISE fnd_api.g_exc_unexpected_error;
65: END IF;
66:
67: -- initialize message list if p_init_msg_list is set to true.
68: IF fnd_api.to_boolean(p_init_msg_list)
69: THEN
70: fnd_msg_pub.initialize;
71: END IF;
72:

Line 74: x_return_status := fnd_api.g_ret_sts_success;

70: fnd_msg_pub.initialize;
71: END IF;
72:
73: -- initialize api return status to success
74: x_return_status := fnd_api.g_ret_sts_success;
75:
76: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
77: debug_level => FND_LOG.LEVEL_PROCEDURE,
78: module => l_Debug_Module);

Line 154: IF fnd_api.to_boolean(p_commit)

150: -- end of api body.
151: --
152:
153: -- standard check for p_commit
154: IF fnd_api.to_boolean(p_commit)
155: THEN
156: COMMIT WORK;
157: END IF;
158:

Line 167: WHEN FND_API.G_EXC_ERROR THEN

163: );
164:
165: EXCEPTION
166:
167: WHEN FND_API.G_EXC_ERROR THEN
168: ROLLBACK TO l_rollback_point;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170:
171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 169: x_return_status := FND_API.G_RET_STS_ERROR;

165: EXCEPTION
166:
167: WHEN FND_API.G_EXC_ERROR THEN
168: ROLLBACK TO l_rollback_point;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170:
171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
172: ROLLBACK TO l_rollback_point;
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

167: WHEN FND_API.G_EXC_ERROR THEN
168: ROLLBACK TO l_rollback_point;
169: x_return_status := FND_API.G_RET_STS_ERROR;
170:
171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
172: ROLLBACK TO l_rollback_point;
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174:
175: WHEN OTHERS THEN

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

169: x_return_status := FND_API.G_RET_STS_ERROR;
170:
171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
172: ROLLBACK TO l_rollback_point;
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174:
175: WHEN OTHERS THEN
176: ROLLBACK TO l_rollback_point;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174:
175: WHEN OTHERS THEN
176: ROLLBACK TO l_rollback_point;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
179: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
180: END IF;
181:

Line 248: RAISE FND_API.G_EXC_ERROR;

244: fnd_message.set_name('IBY', 'IBY_FD_INVALID_PMT_INSTRUCTION');
245: fnd_message.set_token('PARAM', p_payment_instruction_id);
246: fnd_msg_pub.add;
247:
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251: IF l_instr_status not in ('FORMATTED_READY_FOR_PRINTING',
252: 'SUBMITTED_FOR_PRINTING',

Line 261: RAISE FND_API.G_EXC_ERROR;

257: fnd_message.set_name('IBY', 'IBY_FD_INVALID_PMT_INSTRUCTION');
258: fnd_message.set_token('PARAM', p_payment_instruction_id);
259: fnd_msg_pub.add;
260:
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:
264: -- the default param values are
265: -- implicit IN varchar2 default NO

Line 448: RAISE FND_API.G_EXC_ERROR;

444: debug_level => FND_LOG.LEVEL_STATEMENT,
445: module => l_Debug_Module);
446:
447: IF l_request_id = 0 THEN
448: RAISE FND_API.G_EXC_ERROR;
449: ELSE
450:
451: iby_debug_pub.add(debug_msg => 'Calling the lock_pmt_entity() API to lock instruction: ' || p_payment_instruction_id
452: || ' for the extract/formatting/printing/delivery program',

Line 463: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

459: p_conc_request_id => l_request_id,
460: x_return_status => l_return_status
461: );
462:
463: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
464: RAISE FND_API.G_EXC_ERROR;
465: ELSE
466: iby_debug_pub.add(debug_msg => 'lock_pmt_entity() API returned success',
467: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 464: RAISE FND_API.G_EXC_ERROR;

460: x_return_status => l_return_status
461: );
462:
463: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
464: RAISE FND_API.G_EXC_ERROR;
465: ELSE
466: iby_debug_pub.add(debug_msg => 'lock_pmt_entity() API returned success',
467: debug_level => FND_LOG.LEVEL_STATEMENT,
468: module => l_Debug_Module);

Line 537: x_return_status := FND_API.G_RET_STS_SUCCESS;

533: iby_debug_pub.add(debug_msg => 'Input is_reprint_flag: ' || p_is_reprint_flag,
534: debug_level => FND_LOG.LEVEL_STATEMENT,
535: module => l_Debug_Module);
536:
537: x_return_status := FND_API.G_RET_STS_SUCCESS;
538:
539: OPEN l_instruction_ovn_csr (p_payment_instruction_id);
540: FETCH l_instruction_ovn_csr INTO l_instruction_ovn, l_instr_status, l_proc_type,
541: l_mark_complete_event, l_format_code, l_pp_prt_immed, l_process_type;

Line 731: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

727: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
728: debug_level => FND_LOG.LEVEL_STATEMENT,
729: module => l_Debug_Module);
730:
731: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
732: -- set error for invalid data
733: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
734: fnd_message.set_token('PARAM', p_payment_instruction_id);
735: fnd_msg_pub.add;

Line 737: RAISE FND_API.G_EXC_ERROR;

733: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
734: fnd_message.set_token('PARAM', p_payment_instruction_id);
735: fnd_msg_pub.add;
736:
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:
740: END IF;
741:

Line 818: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

814: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
815: debug_level => FND_LOG.LEVEL_STATEMENT,
816: module => l_Debug_Module);
817:
818: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
819: -- set error for invalid data
820: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
821: fnd_message.set_token('PARAM', p_payment_instruction_id);
822: fnd_msg_pub.add;

Line 824: RAISE FND_API.G_EXC_ERROR;

820: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
821: fnd_message.set_token('PARAM', p_payment_instruction_id);
822: fnd_msg_pub.add;
823:
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826:
827: END IF;
828:

Line 875: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

871: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
872: debug_level => FND_LOG.LEVEL_STATEMENT,
873: module => l_Debug_Module);
874:
875: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
876: -- set error for invalid data
877: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
878: fnd_message.set_token('PARAM', p_payment_instruction_id);
879: fnd_msg_pub.add;

Line 881: RAISE FND_API.G_EXC_ERROR;

877: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
878: fnd_message.set_token('PARAM', p_payment_instruction_id);
879: fnd_msg_pub.add;
880:
881: RAISE FND_API.G_EXC_ERROR;
882: END IF;
883:
884: END IF;
885:

Line 933: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

929: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
930: debug_level => FND_LOG.LEVEL_STATEMENT,
931: module => l_Debug_Module);
932:
933: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
934: -- set error for invalid data
935: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
936: fnd_message.set_token('PARAM', p_payment_instruction_id);
937: fnd_msg_pub.add;

Line 939: RAISE FND_API.G_EXC_ERROR;

935: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
936: fnd_message.set_token('PARAM', p_payment_instruction_id);
937: fnd_msg_pub.add;
938:
939: RAISE FND_API.G_EXC_ERROR;
940: END IF;
941:
942: END IF;
943:

Line 958: WHEN FND_API.G_EXC_ERROR THEN

954: module => l_Debug_Module);
955:
956: EXCEPTION
957:
958: WHEN FND_API.G_EXC_ERROR THEN
959: x_return_status := FND_API.G_RET_STS_ERROR;
960:
961: LOOP
962: l_msg_data := FND_MSG_PUB.Get;

Line 959: x_return_status := FND_API.G_RET_STS_ERROR;

955:
956: EXCEPTION
957:
958: WHEN FND_API.G_EXC_ERROR THEN
959: x_return_status := FND_API.G_RET_STS_ERROR;
960:
961: LOOP
962: l_msg_data := FND_MSG_PUB.Get;
963:

Line 973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

969: module => l_Debug_Module);
970: END IF;
971: END LOOP;
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
975:
976: LOOP
977: l_msg_data := FND_MSG_PUB.Get;

Line 974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

970: END IF;
971: END LOOP;
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
975:
976: LOOP
977: l_msg_data := FND_MSG_PUB.Get;
978:

Line 989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

985: END IF;
986: END LOOP;
987:
988: WHEN OTHERS THEN
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990:
991: LOOP
992: l_msg_data := FND_MSG_PUB.Get;
993:

Line 1032: IF l_fv_ts_req_status = FND_API.G_RET_STS_SUCCESS THEN

1028: x_msg_count => l_fv_ts_req_msg_cnt,
1029: x_msg_data => l_fv_ts_req_msg_dt
1030: );
1031:
1032: IF l_fv_ts_req_status = FND_API.G_RET_STS_SUCCESS THEN
1033: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns success.',
1034: debug_level => FND_LOG.LEVEL_STATEMENT,
1035: module => l_Debug_Module);
1036: iby_debug_pub.add(debug_msg => 'Payment Instruction Treasury Symbol Listing Report request id: ' || l_fv_ts_req_id,

Line 1462: p_commit => FND_API.G_FALSE,

1458:
1459: FV_FEDERAL_PAYMENT_FIELDS_PKG.Summary_Format_Prog_Completed(
1460: p_api_version => 1.0 ,
1461: p_init_msg_list => NULL,
1462: p_commit => FND_API.G_FALSE,
1463: x_return_status => l_return_status,
1464: x_msg_count => l_msg_count,
1465: x_msg_data => l_msg_data,
1466: p_payment_instruction_id => p_payment_instruction_id,

Line 1913: RAISE FND_API.G_EXC_ERROR;

1909: -- set error for invalid data
1910: fnd_message.set_name('IBY', 'IBY_FD_PPP_SEQ_NOT_SAVED');
1911: fnd_msg_pub.add;
1912:
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915:
1916: IF p_sequence_number = 1 THEN
1917:

Line 2186: p_init_msg_list => fnd_api.g_false,

2182: debug_level => FND_LOG.LEVEL_STATEMENT,
2183: module => l_Debug_Module);
2184:
2185: ECE_AP_PAYMENT.Extract_PYO_Outbound ( p_api_version => 1.0,
2186: p_init_msg_list => fnd_api.g_false,
2187: p_commit => fnd_api.g_false,
2188: x_return_status => l_ece_status,
2189: x_msg_count => l_msg_count,
2190: x_msg_data => l_msg_data,

Line 2187: p_commit => fnd_api.g_false,

2183: module => l_Debug_Module);
2184:
2185: ECE_AP_PAYMENT.Extract_PYO_Outbound ( p_api_version => 1.0,
2186: p_init_msg_list => fnd_api.g_false,
2187: p_commit => fnd_api.g_false,
2188: x_return_status => l_ece_status,
2189: x_msg_count => l_msg_count,
2190: x_msg_data => l_msg_data,
2191: p_payment_instruction_id => p_payment_instruction_id);

Line 2197: IF l_ece_status = FND_API.G_RET_STS_SUCCESS THEN

2193: iby_debug_pub.add(debug_msg => 'After calling ECE_AP_PAYMENT.Extract_PYO_Outbound() API, return status: ' || l_ece_status,
2194: debug_level => FND_LOG.LEVEL_STATEMENT,
2195: module => l_Debug_Module);
2196:
2197: IF l_ece_status = FND_API.G_RET_STS_SUCCESS THEN
2198:
2199: iby_debug_pub.add(debug_msg => 'Calling Post_Results()',
2200: debug_level => FND_LOG.LEVEL_STATEMENT,
2201: module => l_Debug_Module);

Line 2215: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN

2211: iby_debug_pub.add(debug_msg => 'After calling Post_Results(), return status: ' || l_post_status,
2212: debug_level => FND_LOG.LEVEL_STATEMENT,
2213: module => l_Debug_Module);
2214:
2215: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: END IF;
2218:
2219: ELSE

Line 2216: RAISE FND_API.G_EXC_ERROR;

2212: debug_level => FND_LOG.LEVEL_STATEMENT,
2213: module => l_Debug_Module);
2214:
2215: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: END IF;
2218:
2219: ELSE
2220: RAISE FND_API.G_EXC_ERROR;

Line 2220: RAISE FND_API.G_EXC_ERROR;

2216: RAISE FND_API.G_EXC_ERROR;
2217: END IF;
2218:
2219: ELSE
2220: RAISE FND_API.G_EXC_ERROR;
2221: END IF;
2222:
2223: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2224: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 2296: RAISE FND_API.G_EXC_ERROR;

2292: debug_level => FND_LOG.LEVEL_STATEMENT,
2293: module => l_Debug_Module);
2294:
2295: IF l_request_id = 0 THEN
2296: RAISE FND_API.G_EXC_ERROR;
2297: END IF;
2298:
2299: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2300: debug_level => FND_LOG.LEVEL_PROCEDURE,