DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_CASH_APP_PUB dependencies on FND_API

Line 38: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

34: ------------------------------------------------------------
35: -- Start processing
36: ------------------------------------------------------------
37:
38: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
39:
40: SAVEPOINT sp_adv_mon;
41:
42:

Line 55: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

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;

Line 57: --RAISE Fnd_Api.G_EXC_ERROR;

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;

Line 58: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

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:

Line 60: --RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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:

Line 71: WHEN Fnd_Api.G_EXC_ERROR THEN

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 ;

Line 73: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 79: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 81: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 88: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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 (

Line 139: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

135: ------------------------------------------------------------
136: -- Start processing
137: ------------------------------------------------------------
138:
139: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
140:
141: SAVEPOINT sp_adv_mon;
142:
143:

Line 160: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

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;

Line 161: RAISE Fnd_Api.G_EXC_ERROR;

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:

Line 162: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

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

Line 163: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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:

Line 174: WHEN Fnd_Api.G_EXC_ERROR THEN

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 ;

Line 176: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 182: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 184: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 192: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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 (

Line 400: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

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:

Line 416: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

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;

Line 417: RAISE Fnd_Api.G_EXC_ERROR;

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:

Line 418: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

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

Line 419: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

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:

Line 430: WHEN Fnd_Api.G_EXC_ERROR THEN

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 ;

Line 432: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 438: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 440: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 448: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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 (

Line 645: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

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

Line 681: WHEN Fnd_Api.G_EXC_ERROR THEN

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 ;

Line 683: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 689: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 691: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 698: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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 (