DBA Data[Home] [Help]

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 252: RAISE FND_API.G_EXC_ERROR;

248: fnd_message.set_name('IBY', 'IBY_FD_INVALID_PMT_INSTRUCTION');
249: fnd_message.set_token('PARAM', p_payment_instruction_id);
250: fnd_msg_pub.add;
251:
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: /*Bug 8760084 - Start*/
256: iby_debug_pub.add(debug_msg => 'Completion point of the payment instruction :' || l_completion_point,debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);

Line 268: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

264: p_instr_id => p_payment_instruction_id,
265: x_return_status => l_mark_complete_status
266: );
267:
268: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
269: -- set error for invalid data
270: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
271: fnd_message.set_token('PARAM', p_payment_instruction_id);
272: fnd_msg_pub.add;

Line 274: RAISE FND_API.G_EXC_ERROR;

270: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
271: fnd_message.set_token('PARAM', p_payment_instruction_id);
272: fnd_msg_pub.add;
273: iby_debug_pub.add(debug_msg => 'Marking payment instruction as completed - failed',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: iby_debug_pub.add(debug_msg => 'Marked payment instruction as complete',debug_level => FND_LOG.LEVEL_STATEMENT, module => l_Debug_Module);
278: RETURN;

Line 293: RAISE FND_API.G_EXC_ERROR;

289: fnd_message.set_name('IBY', 'IBY_FD_INVALID_PMT_INSTRUCTION');
290: fnd_message.set_token('PARAM', p_payment_instruction_id);
291: fnd_msg_pub.add;
292:
293: RAISE FND_API.G_EXC_ERROR;
294: END IF;
295:
296: -- the default param values are
297: -- implicit IN varchar2 default NO

Line 486: RAISE FND_API.G_EXC_ERROR;

482: debug_level => FND_LOG.LEVEL_STATEMENT,
483: module => l_Debug_Module);
484:
485: IF l_request_id = 0 THEN
486: RAISE FND_API.G_EXC_ERROR;
487: -- Bug:7259529 - CAll to the lock_pmt_entity has been moved to the java layer
488: -- Bug:9235888 - Reinstated instruction locking.
489: ELSE
490:

Line 503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

499: p_conc_request_id => l_request_id,
500: x_return_status => l_return_status
501: );
502:
503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
504: RAISE FND_API.G_EXC_ERROR;
505: ELSE
506: iby_debug_pub.add(debug_msg => 'lock_pmt_entity() API returned success',
507: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 504: RAISE FND_API.G_EXC_ERROR;

500: x_return_status => l_return_status
501: );
502:
503: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
504: RAISE FND_API.G_EXC_ERROR;
505: ELSE
506: iby_debug_pub.add(debug_msg => 'lock_pmt_entity() API returned success',
507: debug_level => FND_LOG.LEVEL_STATEMENT,
508: module => l_Debug_Module);

Line 579: x_return_status := FND_API.G_RET_STS_SUCCESS;

575: iby_debug_pub.add(debug_msg => 'Input is_reprint_flag: ' || p_is_reprint_flag,
576: debug_level => FND_LOG.LEVEL_STATEMENT,
577: module => l_Debug_Module);
578:
579: x_return_status := FND_API.G_RET_STS_SUCCESS;
580:
581: OPEN l_instruction_ovn_csr (p_payment_instruction_id);
582: FETCH l_instruction_ovn_csr INTO l_instruction_ovn, l_instr_status, l_proc_type,
583: l_mark_complete_event, l_format_code, l_pp_prt_immed, l_process_type;

Line 860: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

856: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
857: debug_level => FND_LOG.LEVEL_STATEMENT,
858: module => l_Debug_Module);
859:
860: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
861: -- set error for invalid data
862: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
863: fnd_message.set_token('PARAM', p_payment_instruction_id);
864: fnd_msg_pub.add;

Line 866: RAISE FND_API.G_EXC_ERROR;

862: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
863: fnd_message.set_token('PARAM', p_payment_instruction_id);
864: fnd_msg_pub.add;
865:
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868:
869: END IF;
870:

Line 984: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

980: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
981: debug_level => FND_LOG.LEVEL_STATEMENT,
982: module => l_Debug_Module);
983:
984: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
985: -- set error for invalid data
986: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
987: fnd_message.set_token('PARAM', p_payment_instruction_id);
988: fnd_msg_pub.add;

Line 990: RAISE FND_API.G_EXC_ERROR;

986: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
987: fnd_message.set_token('PARAM', p_payment_instruction_id);
988: fnd_msg_pub.add;
989:
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992:
993: END IF;
994:

Line 1065: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

1061: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1062: debug_level => FND_LOG.LEVEL_STATEMENT,
1063: module => l_Debug_Module);
1064:
1065: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
1066:
1067: -- set error for invalid data
1068: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
1069: fnd_message.set_token('PARAM', p_payment_instruction_id);

Line 1072: RAISE FND_API.G_EXC_ERROR;

1068: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
1069: fnd_message.set_token('PARAM', p_payment_instruction_id);
1070: fnd_msg_pub.add;
1071:
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074:
1075: END IF;
1076:

Line 1145: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

1141: iby_debug_pub.add(debug_msg => 'After Calling IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete().',
1142: debug_level => FND_LOG.LEVEL_STATEMENT,
1143: module => l_Debug_Module);
1144:
1145: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
1146: -- set error for invalid data
1147: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
1148: fnd_message.set_token('PARAM', p_payment_instruction_id);
1149: fnd_msg_pub.add;

Line 1151: RAISE FND_API.G_EXC_ERROR;

1147: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
1148: fnd_message.set_token('PARAM', p_payment_instruction_id);
1149: fnd_msg_pub.add;
1150:
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153:
1154: END IF;
1155:

Line 1170: WHEN FND_API.G_EXC_ERROR THEN

1166: module => l_Debug_Module);
1167:
1168: EXCEPTION
1169:
1170: WHEN FND_API.G_EXC_ERROR THEN
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: LOOP
1173: l_msg_data := FND_MSG_PUB.Get;
1174:

Line 1171: x_return_status := FND_API.G_RET_STS_ERROR;

1167:
1168: EXCEPTION
1169:
1170: WHEN FND_API.G_EXC_ERROR THEN
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: LOOP
1173: l_msg_data := FND_MSG_PUB.Get;
1174:
1175: IF l_msg_data IS NULL THEN

Line 1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1180: module => l_Debug_Module);
1181: END IF;
1182: END LOOP;
1183:
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186:
1187: LOOP
1188: l_msg_data := FND_MSG_PUB.Get;

Line 1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1181: END IF;
1182: END LOOP;
1183:
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186:
1187: LOOP
1188: l_msg_data := FND_MSG_PUB.Get;
1189:

Line 1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1196: END IF;
1197: END LOOP;
1198:
1199: WHEN OTHERS THEN
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201:
1202: LOOP
1203: l_msg_data := FND_MSG_PUB.Get;
1204:

Line 1241: IF l_fv_ts_req_status = FND_API.G_RET_STS_SUCCESS THEN

1237: x_msg_count => l_fv_ts_req_msg_cnt,
1238: x_msg_data => l_fv_ts_req_msg_dt
1239: );
1240:
1241: IF l_fv_ts_req_status = FND_API.G_RET_STS_SUCCESS THEN
1242: iby_debug_pub.add(debug_msg => 'Federal submit_pay_instr_ts_report() returns success.',
1243: debug_level => FND_LOG.LEVEL_STATEMENT,
1244: module => l_Debug_Module);
1245: iby_debug_pub.add(debug_msg => 'Payment Instruction Treasury Symbol Listing Report request id: ' || l_fv_ts_req_id,

Line 1671: p_commit => FND_API.G_FALSE,

1667:
1668: FV_FEDERAL_PAYMENT_FIELDS_PKG.Summary_Format_Prog_Completed(
1669: p_api_version => 1.0 ,
1670: p_init_msg_list => NULL,
1671: p_commit => FND_API.G_FALSE,
1672: x_return_status => l_return_status,
1673: x_msg_count => l_msg_count,
1674: x_msg_data => l_msg_data,
1675: p_payment_instruction_id => p_payment_instruction_id,

Line 2122: RAISE FND_API.G_EXC_ERROR;

2118: -- set error for invalid data
2119: fnd_message.set_name('IBY', 'IBY_FD_PPP_SEQ_NOT_SAVED');
2120: fnd_msg_pub.add;
2121:
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124:
2125: IF p_sequence_number = 1 THEN
2126:

Line 2398: p_init_msg_list => fnd_api.g_false,

2394: module => l_Debug_Module);
2395:
2396:
2397: IBY_PYO_TRANSACTION.Extract_PYO_Outbound ( p_api_version => 1.0,
2398: p_init_msg_list => fnd_api.g_false,
2399: p_commit => fnd_api.g_false,
2400: x_return_status => l_ece_status,
2401: x_msg_count => l_msg_count,
2402: x_msg_data => l_msg_data,

Line 2399: p_commit => fnd_api.g_false,

2395:
2396:
2397: IBY_PYO_TRANSACTION.Extract_PYO_Outbound ( p_api_version => 1.0,
2398: p_init_msg_list => fnd_api.g_false,
2399: p_commit => fnd_api.g_false,
2400: x_return_status => l_ece_status,
2401: x_msg_count => l_msg_count,
2402: x_msg_data => l_msg_data,
2403: p_payment_instruction_id => p_payment_instruction_id);

Line 2412: IF l_ece_status = FND_API.G_RET_STS_SUCCESS THEN

2408: iby_debug_pub.add(debug_msg => 'After calling IBY_PYO_TRANSACTION.Extract_PYO_Outbound() API, return status: ' || l_ece_status,
2409: debug_level => FND_LOG.LEVEL_STATEMENT,
2410: module => l_Debug_Module);
2411:
2412: IF l_ece_status = FND_API.G_RET_STS_SUCCESS THEN
2413:
2414: iby_debug_pub.add(debug_msg => 'Calling Post_Results()',
2415: debug_level => FND_LOG.LEVEL_STATEMENT,
2416: module => l_Debug_Module);

Line 2435: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN

2431: iby_debug_pub.add(debug_msg => 'After calling Post_Results(), return status: ' || l_post_status,
2432: debug_level => FND_LOG.LEVEL_STATEMENT,
2433: module => l_Debug_Module);
2434:
2435: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN
2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;
2438:
2439: ELSE

Line 2436: RAISE FND_API.G_EXC_ERROR;

2432: debug_level => FND_LOG.LEVEL_STATEMENT,
2433: module => l_Debug_Module);
2434:
2435: IF l_post_status <> FND_API.G_RET_STS_SUCCESS THEN
2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;
2438:
2439: ELSE
2440: RAISE FND_API.G_EXC_ERROR;

Line 2440: RAISE FND_API.G_EXC_ERROR;

2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;
2438:
2439: ELSE
2440: RAISE FND_API.G_EXC_ERROR;
2441: END IF;
2442:
2443: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2444: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 2516: RAISE FND_API.G_EXC_ERROR;

2512: debug_level => FND_LOG.LEVEL_STATEMENT,
2513: module => l_Debug_Module);
2514:
2515: IF l_request_id = 0 THEN
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;
2518:
2519: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
2520: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 2562: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN

2558: debug_level => FND_LOG.LEVEL_STATEMENT,
2559: module => l_Debug_Module);
2560:
2561:
2562: IF l_mark_complete_status <> FND_API.G_RET_STS_SUCCESS THEN
2563: -- set error for invalid data
2564: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
2565: fnd_message.set_token('PARAM', p_payment_instruction_id);
2566: fnd_msg_pub.add;

Line 2568: RAISE FND_API.G_EXC_ERROR;

2564: fnd_message.set_name('IBY', 'IBY_FD_ERR_MARK_COMPLETE');
2565: fnd_message.set_token('PARAM', p_payment_instruction_id);
2566: fnd_msg_pub.add;
2567:
2568: RAISE FND_API.G_EXC_ERROR;
2569: END IF;
2570:
2571: OPEN l_instruction_ovn_csr (p_payment_instruction_id);
2572: FETCH l_instruction_ovn_csr INTO l_format_code;

Line 2579: WHEN FND_API.G_EXC_ERROR THEN

2575: -- finally kick off Federal "Payment Instruction Treasury Symbol Listing Report"
2576: -- if its a Federal format
2577: Submit_FV_TS_Report(p_payment_instruction_id, l_format_code, l_Debug_Module);
2578: EXCEPTION
2579: WHEN FND_API.G_EXC_ERROR THEN
2580: x_return_status := FND_API.G_RET_STS_ERROR;
2581: LOOP
2582: l_msg_data := FND_MSG_PUB.Get;
2583: IF l_msg_data IS NULL THEN

Line 2580: x_return_status := FND_API.G_RET_STS_ERROR;

2576: -- if its a Federal format
2577: Submit_FV_TS_Report(p_payment_instruction_id, l_format_code, l_Debug_Module);
2578: EXCEPTION
2579: WHEN FND_API.G_EXC_ERROR THEN
2580: x_return_status := FND_API.G_RET_STS_ERROR;
2581: LOOP
2582: l_msg_data := FND_MSG_PUB.Get;
2583: IF l_msg_data IS NULL THEN
2584: EXIT;

Line 2591: RAISE FND_API.G_EXC_ERROR;

2587: debug_level => FND_LOG.LEVEL_STATEMENT,
2588: module => l_Debug_Module);
2589: END IF;
2590: END LOOP;
2591: RAISE FND_API.G_EXC_ERROR;
2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2594:
2595: LOOP

Line 2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2588: module => l_Debug_Module);
2589: END IF;
2590: END LOOP;
2591: RAISE FND_API.G_EXC_ERROR;
2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2594:
2595: LOOP
2596: l_msg_data := FND_MSG_PUB.Get;

Line 2593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2589: END IF;
2590: END LOOP;
2591: RAISE FND_API.G_EXC_ERROR;
2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2594:
2595: LOOP
2596: l_msg_data := FND_MSG_PUB.Get;
2597:

Line 2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2602: debug_level => FND_LOG.LEVEL_STATEMENT,
2603: module => l_Debug_Module);
2604: END IF;
2605: END LOOP;
2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2607: WHEN OTHERS THEN
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609:
2610: LOOP

Line 2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2604: END IF;
2605: END LOOP;
2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2607: WHEN OTHERS THEN
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609:
2610: LOOP
2611: l_msg_data := FND_MSG_PUB.Get;
2612:

Line 2621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2617: debug_level => FND_LOG.LEVEL_STATEMENT,
2618: module => l_Debug_Module);
2619: END IF;
2620: END LOOP;
2621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2622: END Retry_Completion;
2623:
2624: END IBY_FD_POST_PICP_PROGS_PVT;
2625: