DBA Data[Home] [Help]

APPS.OKL_LOSS_PROV_PUB dependencies on FND_API

Line 58: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

54: p_glpv_rec IN glpv_rec_type) RETURN NUMBER
55: IS
56:
57: l_request_id NUMBER;
58: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
59: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_GENERAL_LOSS';
60: l_glpv_rec glpv_rec_type := p_glpv_rec;
61: BEGIN
62: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 62: x_return_status := FND_API.G_RET_STS_SUCCESS;

58: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
59: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_GENERAL_LOSS';
60: l_glpv_rec glpv_rec_type := p_glpv_rec;
61: BEGIN
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63: -- customer pre-processing
64:
65:
66:

Line 76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

72: p_api_version => p_api_version,
73: p_init_msg_list => p_init_msg_list,
74: p_glpv_rec => p_glpv_rec);
75:
76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
77: RAISE FND_API.G_EXC_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;

Line 77: RAISE FND_API.G_EXC_ERROR;

73: p_init_msg_list => p_init_msg_list,
74: p_glpv_rec => p_glpv_rec);
75:
76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
77: RAISE FND_API.G_EXC_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:

Line 78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

74: p_glpv_rec => p_glpv_rec);
75:
76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
77: RAISE FND_API.G_EXC_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: -- customer post-processing

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75:
76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
77: RAISE FND_API.G_EXC_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: -- customer post-processing
83:

Line 88: WHEN FND_API.G_EXC_ERROR THEN

84:
85: RETURN l_request_id;
86:
87: EXCEPTION
88: WHEN FND_API.G_EXC_ERROR THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90:
91: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
92: ,p_count => x_msg_count

Line 89: x_return_status := FND_API.G_RET_STS_ERROR;

85: RETURN l_request_id;
86:
87: EXCEPTION
88: WHEN FND_API.G_EXC_ERROR THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90:
91: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
92: ,p_count => x_msg_count
93: ,p_data => x_msg_data);

Line 96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

92: ,p_count => x_msg_count
93: ,p_data => x_msg_data);
94: RETURN l_request_id;
95:
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
99: ,p_count => x_msg_count
100: ,p_data => x_msg_data);

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

93: ,p_data => x_msg_data);
94: RETURN l_request_id;
95:
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
99: ,p_count => x_msg_count
100: ,p_data => x_msg_data);
101: RETURN l_request_id;

Line 108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

104: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SUBMIT_GENERAL_LOSS');
105: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
106: ,p_count => x_msg_count
107: ,p_data => x_msg_data);
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
109: RETURN l_request_id;
110:
111: END SUBMIT_GENERAL_LOSS;
112:

Line 124: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

120: ,x_return_status OUT NOCOPY VARCHAR2
121: ,p_slpv_rec IN slpv_rec_type)
122: IS
123:
124: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
125: l_api_name CONSTANT VARCHAR2(30) := 'SPECIFIC_LOSS_PROVISION';
126: l_slpv_rec slpv_rec_type := p_slpv_rec;
127:
128: BEGIN

Line 145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

141: ,x_msg_data => x_msg_data
142: ,x_return_status => x_return_status
143: ,p_slpv_rec => p_slpv_rec);
144:
145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;

Line 146: RAISE FND_API.G_EXC_ERROR;

142: ,x_return_status => x_return_status
143: ,p_slpv_rec => p_slpv_rec);
144:
145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150:

Line 147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

143: ,p_slpv_rec => p_slpv_rec);
144:
145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150:
151: -- customer post-processing

Line 148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

144:
145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150:
151: -- customer post-processing
152:

Line 155: WHEN FND_API.G_EXC_ERROR THEN

151: -- customer post-processing
152:
153:
154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: x_return_status := FND_API.G_RET_STS_ERROR;
157:
158: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
159: ,p_count => x_msg_count

Line 156: x_return_status := FND_API.G_RET_STS_ERROR;

152:
153:
154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: x_return_status := FND_API.G_RET_STS_ERROR;
157:
158: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);

Line 162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

158: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);
161:
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
165: ,p_count => x_msg_count
166: ,p_data => x_msg_data);

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);
161:
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
165: ,p_count => x_msg_count
166: ,p_data => x_msg_data);
167:

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

169: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SPECIFIC_LOSS_PROVISION');
170: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
171: ,p_count => x_msg_count
172: ,p_data => x_msg_data);
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174:
175: END SPECIFIC_LOSS_PROVISION;
176:
177: PROCEDURE SPECIFIC_LOSS_PROVISION (

Line 188: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

184: ,p_reverse_flag IN VARCHAR2
185: ,p_slpv_tbl IN slpv_tbl_type)
186: IS
187:
188: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
189: l_api_name CONSTANT VARCHAR2(30) := 'SPECIFIC_LOSS_PROVISION';
190: l_slpv_rec slpv_rec_type;
191:
192: BEGIN

Line 220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

216: ,x_msg_data => x_msg_data
217: ,x_return_status => x_return_status
218: ,p_slpv_rec => l_slpv_rec);
219:
220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
221: RAISE FND_API.G_EXC_ERROR;
222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;

Line 221: RAISE FND_API.G_EXC_ERROR;

217: ,x_return_status => x_return_status
218: ,p_slpv_rec => l_slpv_rec);
219:
220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
221: RAISE FND_API.G_EXC_ERROR;
222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:

Line 222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

218: ,p_slpv_rec => l_slpv_rec);
219:
220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
221: RAISE FND_API.G_EXC_ERROR;
222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: END LOOP;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219:
220: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
221: RAISE FND_API.G_EXC_ERROR;
222: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225:
226: END LOOP;
227:

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: END LOOP;
227:
228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
234: ,p_count => x_msg_count

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227:
228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
240: ,p_count => x_msg_count
241: ,p_data => x_msg_data);

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
240: ,p_count => x_msg_count
241: ,p_data => x_msg_data);
242:

Line 248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

244: FND_MSG_PUB.ADD_EXC_MSG('OKL_LOSS_PROV_PUB','SPECIFIC_LOSS_PROVISION');
245: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
246: ,p_count => x_msg_count
247: ,p_data => x_msg_data);
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249:
250: END SPECIFIC_LOSS_PROVISION;
251:
252: END OKL_LOSS_PROV_PUB;