34: ------------------------------------------------------------
35: -- Start processing
36: ------------------------------------------------------------
37:
38: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
39:
40: SAVEPOINT sp_adv_mon;
41:
42:
51: ,p_cross_currency_allowed => p_cross_currency_allowed
52: );
53:
54:
55: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
56: NULL;
57: --RAISE Fnd_Api.G_EXC_ERROR;
58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
59: NULL;
53:
54:
55: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
56: NULL;
57: --RAISE Fnd_Api.G_EXC_ERROR;
58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
59: NULL;
60: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
61: END IF;
54:
55: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
56: NULL;
57: --RAISE Fnd_Api.G_EXC_ERROR;
58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
59: NULL;
60: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
56: NULL;
57: --RAISE Fnd_Api.G_EXC_ERROR;
58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
59: NULL;
60: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
63: --Assign value to OUT variables
64:
67: x_msg_data := l_msg_data ;
68:
69: EXCEPTION
70:
71: WHEN Fnd_Api.G_EXC_ERROR THEN
72: ROLLBACK TO sp_adv_mon;
73: x_return_status := Fnd_Api.G_RET_STS_ERROR;
74: x_msg_count := l_msg_count ;
75: x_msg_data := l_msg_data ;
69: EXCEPTION
70:
71: WHEN Fnd_Api.G_EXC_ERROR THEN
72: ROLLBACK TO sp_adv_mon;
73: x_return_status := Fnd_Api.G_RET_STS_ERROR;
74: x_msg_count := l_msg_count ;
75: x_msg_data := l_msg_data ;
76: Fnd_Msg_Pub.count_and_get(
77: p_count => x_msg_count
75: x_msg_data := l_msg_data ;
76: Fnd_Msg_Pub.count_and_get(
77: p_count => x_msg_count
78: ,p_data => x_msg_data);
79: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO sp_adv_mon;
81: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := l_msg_count ;
83: x_msg_data := l_msg_data ;
77: p_count => x_msg_count
78: ,p_data => x_msg_data);
79: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
80: ROLLBACK TO sp_adv_mon;
81: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
82: x_msg_count := l_msg_count ;
83: x_msg_data := l_msg_data ;
84: Fnd_Msg_Pub.count_and_get(
85: p_count => x_msg_count
84: Fnd_Msg_Pub.count_and_get(
85: p_count => x_msg_count
86: ,p_data => x_msg_data);
87: WHEN OTHERS THEN
88: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
89: Fnd_Msg_Pub.ADD_EXC_MSG (
90: p_pkg_name => G_PKG_NAME,
91: p_procedure_name => l_api_name);
92: Fnd_Msg_Pub.Count_and_get (
135: ------------------------------------------------------------
136: -- Start processing
137: ------------------------------------------------------------
138:
139: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
140:
141: SAVEPOINT sp_adv_mon;
142:
143:
156: ,p_cross_currency_allowed => l_cross_currency_allowed
157: );
158:
159:
160: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
161: RAISE Fnd_Api.G_EXC_ERROR;
162: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
163: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
164: END IF;
157: );
158:
159:
160: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
161: RAISE Fnd_Api.G_EXC_ERROR;
162: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
163: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
158:
159:
160: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
161: RAISE Fnd_Api.G_EXC_ERROR;
162: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
163: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166: --Assign value to OUT variables
159:
160: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
161: RAISE Fnd_Api.G_EXC_ERROR;
162: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
163: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166: --Assign value to OUT variables
167:
170: x_msg_data := l_msg_data ;
171:
172: EXCEPTION
173:
174: WHEN Fnd_Api.G_EXC_ERROR THEN
175: ROLLBACK TO sp_adv_mon;
176: x_return_status := Fnd_Api.G_RET_STS_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
172: EXCEPTION
173:
174: WHEN Fnd_Api.G_EXC_ERROR THEN
175: ROLLBACK TO sp_adv_mon;
176: x_return_status := Fnd_Api.G_RET_STS_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: Fnd_Msg_Pub.count_and_get(
180: p_count => x_msg_count
178: x_msg_data := l_msg_data ;
179: Fnd_Msg_Pub.count_and_get(
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO sp_adv_mon;
184: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
180: p_count => x_msg_count
181: ,p_data => x_msg_data);
182: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO sp_adv_mon;
184: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
187: Fnd_Msg_Pub.count_and_get(
188: p_count => x_msg_count
188: p_count => x_msg_count
189: ,p_data => x_msg_data);
190: WHEN OTHERS THEN
191: ROLLBACK TO sp_adv_mon;
192: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
193: Fnd_Msg_Pub.ADD_EXC_MSG (
194: p_pkg_name => G_PKG_NAME,
195: p_procedure_name => l_api_name);
196: Fnd_Msg_Pub.Count_and_get (
396: ------------------------------------------------------------
397: -- Start processing
398: ------------------------------------------------------------
399:
400: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
401:
402: SAVEPOINT sp_adv_mon_w_rcpt;
403:
404:
412: ,p_cross_currency_allowed => l_cross_currency_allowed
413: );
414:
415:
416: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
417: RAISE Fnd_Api.G_EXC_ERROR;
418: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
419: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
420: END IF;
413: );
414:
415:
416: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
417: RAISE Fnd_Api.G_EXC_ERROR;
418: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
419: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:
414:
415:
416: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
417: RAISE Fnd_Api.G_EXC_ERROR;
418: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
419: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:
422: --Assign value to OUT variables
415:
416: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
417: RAISE Fnd_Api.G_EXC_ERROR;
418: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
419: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:
422: --Assign value to OUT variables
423:
426: x_msg_data := l_msg_data ;
427:
428: EXCEPTION
429:
430: WHEN Fnd_Api.G_EXC_ERROR THEN
431: ROLLBACK TO sp_adv_mon_w_rcpt;
432: x_return_status := Fnd_Api.G_RET_STS_ERROR;
433: x_msg_count := l_msg_count ;
434: x_msg_data := l_msg_data ;
428: EXCEPTION
429:
430: WHEN Fnd_Api.G_EXC_ERROR THEN
431: ROLLBACK TO sp_adv_mon_w_rcpt;
432: x_return_status := Fnd_Api.G_RET_STS_ERROR;
433: x_msg_count := l_msg_count ;
434: x_msg_data := l_msg_data ;
435: Fnd_Msg_Pub.count_and_get(
436: p_count => x_msg_count
434: x_msg_data := l_msg_data ;
435: Fnd_Msg_Pub.count_and_get(
436: p_count => x_msg_count
437: ,p_data => x_msg_data);
438: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO sp_adv_mon_w_rcpt;
440: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
436: p_count => x_msg_count
437: ,p_data => x_msg_data);
438: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO sp_adv_mon_w_rcpt;
440: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
441: x_msg_count := l_msg_count ;
442: x_msg_data := l_msg_data ;
443: Fnd_Msg_Pub.count_and_get(
444: p_count => x_msg_count
444: p_count => x_msg_count
445: ,p_data => x_msg_data);
446: WHEN OTHERS THEN
447: ROLLBACK TO sp_adv_mon_w_rcpt;
448: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
449: Fnd_Msg_Pub.ADD_EXC_MSG (
450: p_pkg_name => G_PKG_NAME,
451: p_procedure_name => l_api_name);
452: Fnd_Msg_Pub.Count_and_get (
641: ------------------------------------------------------------
642: -- Start processing
643: ------------------------------------------------------------
644:
645: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
646:
647: SAVEPOINT sp_adv_mon;
648:
649: OKL_BPD_ADVANCED_CASH_APP_PVT.AR_advance_receipt( p_api_version => l_api_version
677: x_msg_data := l_msg_data ;
678:
679: EXCEPTION
680:
681: WHEN Fnd_Api.G_EXC_ERROR THEN
682: ROLLBACK TO sp_adv_mon;
683: x_return_status := Fnd_Api.G_RET_STS_ERROR;
684: x_msg_count := l_msg_count ;
685: x_msg_data := l_msg_data ;
679: EXCEPTION
680:
681: WHEN Fnd_Api.G_EXC_ERROR THEN
682: ROLLBACK TO sp_adv_mon;
683: x_return_status := Fnd_Api.G_RET_STS_ERROR;
684: x_msg_count := l_msg_count ;
685: x_msg_data := l_msg_data ;
686: Fnd_Msg_Pub.count_and_get(
687: p_count => x_msg_count
685: x_msg_data := l_msg_data ;
686: Fnd_Msg_Pub.count_and_get(
687: p_count => x_msg_count
688: ,p_data => x_msg_data);
689: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
690: ROLLBACK TO sp_adv_mon;
691: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
692: x_msg_count := l_msg_count ;
693: x_msg_data := l_msg_data ;
687: p_count => x_msg_count
688: ,p_data => x_msg_data);
689: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
690: ROLLBACK TO sp_adv_mon;
691: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
692: x_msg_count := l_msg_count ;
693: x_msg_data := l_msg_data ;
694: Fnd_Msg_Pub.count_and_get(
695: p_count => x_msg_count
694: Fnd_Msg_Pub.count_and_get(
695: p_count => x_msg_count
696: ,p_data => x_msg_data);
697: WHEN OTHERS THEN
698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
699: Fnd_Msg_Pub.ADD_EXC_MSG (
700: p_pkg_name => G_PKG_NAME,
701: p_procedure_name => l_api_name);
702: Fnd_Msg_Pub.Count_and_get (