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.OZF_OBJFUNDSUM_PVT dependencies on FND_API

Line 72: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

68: ,p_conv_date=> p_conv_date --bug 8532055
69: ,p_from_amount=> p_amount_1
70: ,x_to_amount=> x_amount_2
71: );
72: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
73: RAISE fnd_api.g_exc_unexpected_error;
74: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
75: RAISE fnd_api.g_exc_error;
76: END IF;

Line 73: RAISE fnd_api.g_exc_unexpected_error;

69: ,p_from_amount=> p_amount_1
70: ,x_to_amount=> x_amount_2
71: );
72: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
73: RAISE fnd_api.g_exc_unexpected_error;
74: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
75: RAISE fnd_api.g_exc_error;
76: END IF;
77: END IF;

Line 74: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

70: ,x_to_amount=> x_amount_2
71: );
72: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
73: RAISE fnd_api.g_exc_unexpected_error;
74: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
75: RAISE fnd_api.g_exc_error;
76: END IF;
77: END IF;
78: END IF;

Line 75: RAISE fnd_api.g_exc_error;

71: );
72: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
73: RAISE fnd_api.g_exc_unexpected_error;
74: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
75: RAISE fnd_api.g_exc_error;
76: END IF;
77: END IF;
78: END IF;
79:

Line 93: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

89: ,p_conv_date=> p_conv_date --bug 8532055
90: ,p_from_amount=> p_amount_1
91: ,x_to_amount=> x_amount_3
92: );
93: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
94: RAISE fnd_api.g_exc_unexpected_error;
95: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
96: RAISE fnd_api.g_exc_error;
97: END IF;

Line 94: RAISE fnd_api.g_exc_unexpected_error;

90: ,p_from_amount=> p_amount_1
91: ,x_to_amount=> x_amount_3
92: );
93: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
94: RAISE fnd_api.g_exc_unexpected_error;
95: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
96: RAISE fnd_api.g_exc_error;
97: END IF;
98: END IF;

Line 95: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

91: ,x_to_amount=> x_amount_3
92: );
93: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
94: RAISE fnd_api.g_exc_unexpected_error;
95: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
96: RAISE fnd_api.g_exc_error;
97: END IF;
98: END IF;
99: END IF;

Line 96: RAISE fnd_api.g_exc_error;

92: );
93: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
94: RAISE fnd_api.g_exc_unexpected_error;
95: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
96: RAISE fnd_api.g_exc_error;
97: END IF;
98: END IF;
99: END IF;
100: ELSE

Line 114: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

110: ,p_conv_date=> p_conv_date --bug 8532055
111: ,p_from_amount=> p_amount_2
112: ,x_to_amount=> x_amount_1
113: );
114: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
115: RAISE fnd_api.g_exc_unexpected_error;
116: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
117: RAISE fnd_api.g_exc_error;
118: END IF;

Line 115: RAISE fnd_api.g_exc_unexpected_error;

111: ,p_from_amount=> p_amount_2
112: ,x_to_amount=> x_amount_1
113: );
114: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
115: RAISE fnd_api.g_exc_unexpected_error;
116: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
117: RAISE fnd_api.g_exc_error;
118: END IF;
119: END IF;

Line 116: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

112: ,x_to_amount=> x_amount_1
113: );
114: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
115: RAISE fnd_api.g_exc_unexpected_error;
116: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
117: RAISE fnd_api.g_exc_error;
118: END IF;
119: END IF;
120:

Line 117: RAISE fnd_api.g_exc_error;

113: );
114: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
115: RAISE fnd_api.g_exc_unexpected_error;
116: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
117: RAISE fnd_api.g_exc_error;
118: END IF;
119: END IF;
120:
121: IF NVL(p_amount_3, 0) = 0 THEN

Line 134: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

130: ,p_conv_date=> p_conv_date --bug 8532055
131: ,p_from_amount=> p_amount_2
132: ,x_to_amount=> x_amount_3
133: );
134: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
135: RAISE fnd_api.g_exc_unexpected_error;
136: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
137: RAISE fnd_api.g_exc_error;
138: END IF;

Line 135: RAISE fnd_api.g_exc_unexpected_error;

131: ,p_from_amount=> p_amount_2
132: ,x_to_amount=> x_amount_3
133: );
134: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
135: RAISE fnd_api.g_exc_unexpected_error;
136: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
137: RAISE fnd_api.g_exc_error;
138: END IF;
139: END IF;

Line 136: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

132: ,x_to_amount=> x_amount_3
133: );
134: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
135: RAISE fnd_api.g_exc_unexpected_error;
136: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
137: RAISE fnd_api.g_exc_error;
138: END IF;
139: END IF;
140: END IF;

Line 137: RAISE fnd_api.g_exc_error;

133: );
134: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
135: RAISE fnd_api.g_exc_unexpected_error;
136: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
137: RAISE fnd_api.g_exc_error;
138: END IF;
139: END IF;
140: END IF;
141: END IF;

Line 159: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

155: -- 06/30/2005 yzhao Created.
156: --
157: PROCEDURE Create_objfundsum (
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
160: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
161: p_objfundsum_rec IN objfundsum_rec_type,
162: p_conv_date IN DATE DEFAULT NULL, --bug 8532055
163: x_return_status OUT NOCOPY VARCHAR2,

Line 160: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,

156: --
157: PROCEDURE Create_objfundsum (
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
160: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
161: p_objfundsum_rec IN objfundsum_rec_type,
162: p_conv_date IN DATE DEFAULT NULL, --bug 8532055
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,

Line 205: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN

201: IF (OZF_DEBUG_HIGH_ON) THEN
202: ozf_utility_pvt.Debug_Message(l_full_name||': start');
203: END IF;
204:
205: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
206: Fnd_Msg_Pub.Initialize;
207: END IF;
208:
209: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN

Line 209: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN

205: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
206: Fnd_Msg_Pub.Initialize;
207: END IF;
208:
209: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN
210: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: SAVEPOINT sp_create_objfundsum;

Line 210: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

206: Fnd_Msg_Pub.Initialize;
207: END IF;
208:
209: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN
210: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212:
213: SAVEPOINT sp_create_objfundsum;
214:

Line 215: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

211: END IF;
212:
213: SAVEPOINT sp_create_objfundsum;
214:
215: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
216: x_objfundsum_id := NULL;
217:
218: IF l_objfundsum_rec.fund_currency IS NULL THEN
219: OPEN c_get_fund_currency(l_objfundsum_rec.fund_id);

Line 230: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

226: p_object => l_objfundsum_rec.object_type
227: , p_object_id => l_objfundsum_rec.object_id
228: , x_return_status => l_return_status
229: );
230: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
231: RAISE Fnd_Api.G_EXC_ERROR;
232: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
233: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
234: END IF;

Line 231: RAISE Fnd_Api.G_EXC_ERROR;

227: , p_object_id => l_objfundsum_rec.object_id
228: , x_return_status => l_return_status
229: );
230: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
231: RAISE Fnd_Api.G_EXC_ERROR;
232: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
233: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235: END IF;

Line 232: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

228: , x_return_status => l_return_status
229: );
230: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
231: RAISE Fnd_Api.G_EXC_ERROR;
232: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
233: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235: END IF;
236:

Line 233: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

229: );
230: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
231: RAISE Fnd_Api.G_EXC_ERROR;
232: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
233: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
234: END IF;
235: END IF;
236:
237: -- currency conversion for planned amount

Line 252: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

248: x_return_status => l_return_status,
249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data
251: );
252: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
253: RAISE Fnd_Api.G_EXC_ERROR;
254: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
256: END IF;

Line 253: RAISE Fnd_Api.G_EXC_ERROR;

249: x_msg_count => x_msg_count,
250: x_msg_data => x_msg_data
251: );
252: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
253: RAISE Fnd_Api.G_EXC_ERROR;
254: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257: l_objfundsum_rec.plan_curr_planned_amt := l_amount_1;

Line 254: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

250: x_msg_data => x_msg_data
251: );
252: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
253: RAISE Fnd_Api.G_EXC_ERROR;
254: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257: l_objfundsum_rec.plan_curr_planned_amt := l_amount_1;
258: l_objfundsum_rec.planned_amt := l_amount_2;

Line 255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

251: );
252: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
253: RAISE Fnd_Api.G_EXC_ERROR;
254: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
255: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
256: END IF;
257: l_objfundsum_rec.plan_curr_planned_amt := l_amount_1;
258: l_objfundsum_rec.planned_amt := l_amount_2;
259: l_objfundsum_rec.univ_curr_planned_amt := l_amount_3;

Line 276: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

272: x_return_status => l_return_status,
273: x_msg_count => x_msg_count,
274: x_msg_data => x_msg_data
275: );
276: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
277: RAISE Fnd_Api.G_EXC_ERROR;
278: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
279: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
280: END IF;

Line 277: RAISE Fnd_Api.G_EXC_ERROR;

273: x_msg_count => x_msg_count,
274: x_msg_data => x_msg_data
275: );
276: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
277: RAISE Fnd_Api.G_EXC_ERROR;
278: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
279: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
280: END IF;
281: l_objfundsum_rec.plan_curr_committed_amt := l_amount_1;

Line 278: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

274: x_msg_data => x_msg_data
275: );
276: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
277: RAISE Fnd_Api.G_EXC_ERROR;
278: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
279: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
280: END IF;
281: l_objfundsum_rec.plan_curr_committed_amt := l_amount_1;
282: l_objfundsum_rec.committed_amt := l_amount_2;

Line 279: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

275: );
276: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
277: RAISE Fnd_Api.G_EXC_ERROR;
278: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
279: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
280: END IF;
281: l_objfundsum_rec.plan_curr_committed_amt := l_amount_1;
282: l_objfundsum_rec.committed_amt := l_amount_2;
283: l_objfundsum_rec.univ_curr_committed_amt := l_amount_3;

Line 300: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

296: x_return_status => l_return_status,
297: x_msg_count => x_msg_count,
298: x_msg_data => x_msg_data
299: );
300: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
301: RAISE Fnd_Api.G_EXC_ERROR;
302: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
303: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
304: END IF;

Line 301: RAISE Fnd_Api.G_EXC_ERROR;

297: x_msg_count => x_msg_count,
298: x_msg_data => x_msg_data
299: );
300: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
301: RAISE Fnd_Api.G_EXC_ERROR;
302: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
303: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: l_objfundsum_rec.plan_curr_recal_committed_amt := l_amount_1;

Line 302: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

298: x_msg_data => x_msg_data
299: );
300: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
301: RAISE Fnd_Api.G_EXC_ERROR;
302: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
303: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: l_objfundsum_rec.plan_curr_recal_committed_amt := l_amount_1;
306: l_objfundsum_rec.recal_committed_amt := l_amount_2;

Line 303: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

299: );
300: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
301: RAISE Fnd_Api.G_EXC_ERROR;
302: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
303: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: l_objfundsum_rec.plan_curr_recal_committed_amt := l_amount_1;
306: l_objfundsum_rec.recal_committed_amt := l_amount_2;
307: l_objfundsum_rec.univ_curr_recal_committed_amt := l_amount_3;

Line 324: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

320: x_return_status => l_return_status,
321: x_msg_count => x_msg_count,
322: x_msg_data => x_msg_data
323: );
324: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
325: RAISE Fnd_Api.G_EXC_ERROR;
326: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
328: END IF;

Line 325: RAISE Fnd_Api.G_EXC_ERROR;

321: x_msg_count => x_msg_count,
322: x_msg_data => x_msg_data
323: );
324: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
325: RAISE Fnd_Api.G_EXC_ERROR;
326: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329: l_objfundsum_rec.plan_curr_utilized_amt := l_amount_1;

Line 326: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

322: x_msg_data => x_msg_data
323: );
324: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
325: RAISE Fnd_Api.G_EXC_ERROR;
326: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329: l_objfundsum_rec.plan_curr_utilized_amt := l_amount_1;
330: l_objfundsum_rec.utilized_amt := l_amount_2;

Line 327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

323: );
324: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
325: RAISE Fnd_Api.G_EXC_ERROR;
326: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
327: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329: l_objfundsum_rec.plan_curr_utilized_amt := l_amount_1;
330: l_objfundsum_rec.utilized_amt := l_amount_2;
331: l_objfundsum_rec.univ_curr_utilized_amt := l_amount_3;

Line 348: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

344: x_return_status => l_return_status,
345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data
347: );
348: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
349: RAISE Fnd_Api.G_EXC_ERROR;
350: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
351: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
352: END IF;

Line 349: RAISE Fnd_Api.G_EXC_ERROR;

345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data
347: );
348: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
349: RAISE Fnd_Api.G_EXC_ERROR;
350: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
351: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353: l_objfundsum_rec.plan_curr_earned_amt := l_amount_1;

Line 350: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

346: x_msg_data => x_msg_data
347: );
348: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
349: RAISE Fnd_Api.G_EXC_ERROR;
350: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
351: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353: l_objfundsum_rec.plan_curr_earned_amt := l_amount_1;
354: l_objfundsum_rec.earned_amt := l_amount_2;

Line 351: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

347: );
348: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
349: RAISE Fnd_Api.G_EXC_ERROR;
350: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
351: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353: l_objfundsum_rec.plan_curr_earned_amt := l_amount_1;
354: l_objfundsum_rec.earned_amt := l_amount_2;
355: l_objfundsum_rec.univ_curr_earned_amt := l_amount_3;

Line 372: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

368: x_return_status => l_return_status,
369: x_msg_count => x_msg_count,
370: x_msg_data => x_msg_data
371: );
372: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
373: RAISE Fnd_Api.G_EXC_ERROR;
374: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
375: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
376: END IF;

Line 373: RAISE Fnd_Api.G_EXC_ERROR;

369: x_msg_count => x_msg_count,
370: x_msg_data => x_msg_data
371: );
372: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
373: RAISE Fnd_Api.G_EXC_ERROR;
374: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
375: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377: l_objfundsum_rec.plan_curr_paid_amt := l_amount_1;

Line 374: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

370: x_msg_data => x_msg_data
371: );
372: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
373: RAISE Fnd_Api.G_EXC_ERROR;
374: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
375: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377: l_objfundsum_rec.plan_curr_paid_amt := l_amount_1;
378: l_objfundsum_rec.paid_amt := l_amount_2;

Line 375: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

371: );
372: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
373: RAISE Fnd_Api.G_EXC_ERROR;
374: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
375: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
376: END IF;
377: l_objfundsum_rec.plan_curr_paid_amt := l_amount_1;
378: l_objfundsum_rec.paid_amt := l_amount_2;
379: l_objfundsum_rec.univ_curr_paid_amt := l_amount_3;

Line 391: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

387: x_msg_data => x_msg_data,
388: x_return_status => l_return_status
389: );
390:
391: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
392: RAISE Fnd_Api.G_EXC_ERROR;
393: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
394: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
395: END IF;

Line 392: RAISE Fnd_Api.G_EXC_ERROR;

388: x_return_status => l_return_status
389: );
390:
391: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
392: RAISE Fnd_Api.G_EXC_ERROR;
393: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
394: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:

Line 393: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

389: );
390:
391: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
392: RAISE Fnd_Api.G_EXC_ERROR;
393: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
394: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397: IF (OZF_DEBUG_HIGH_ON) THEN

Line 394: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

390:
391: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
392: RAISE Fnd_Api.G_EXC_ERROR;
393: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
394: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
395: END IF;
396:
397: IF (OZF_DEBUG_HIGH_ON) THEN
398: ozf_utility_pvt.debug_message(l_full_name ||': insert');

Line 532: p_encoded => Fnd_Api.G_FALSE

528:
529: Fnd_Msg_Pub.Count_And_Get (
530: p_count => x_msg_count,
531: p_data => x_msg_data,
532: p_encoded => Fnd_Api.G_FALSE
533: );
534:
535: IF (OZF_DEBUG_HIGH_ON) THEN
536: ozf_utility_pvt.debug_message(l_full_name ||': end Success');

Line 540: WHEN Fnd_Api.G_EXC_ERROR THEN

536: ozf_utility_pvt.debug_message(l_full_name ||': end Success');
537: END IF;
538:
539: EXCEPTION
540: WHEN Fnd_Api.G_EXC_ERROR THEN
541: ROLLBACK TO sp_create_objfundsum;
542: x_return_status := Fnd_Api.G_RET_STS_ERROR;
543: Fnd_Msg_Pub.Count_And_Get (
544: p_count => x_msg_count,

Line 542: x_return_status := Fnd_Api.G_RET_STS_ERROR;

538:
539: EXCEPTION
540: WHEN Fnd_Api.G_EXC_ERROR THEN
541: ROLLBACK TO sp_create_objfundsum;
542: x_return_status := Fnd_Api.G_RET_STS_ERROR;
543: Fnd_Msg_Pub.Count_And_Get (
544: p_count => x_msg_count,
545: p_data => x_msg_data,
546: p_encoded => FND_API.G_FALSE

Line 546: p_encoded => FND_API.G_FALSE

542: x_return_status := Fnd_Api.G_RET_STS_ERROR;
543: Fnd_Msg_Pub.Count_And_Get (
544: p_count => x_msg_count,
545: p_data => x_msg_data,
546: p_encoded => FND_API.G_FALSE
547: );
548: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO sp_create_objfundsum;
550: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 548: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

544: p_count => x_msg_count,
545: p_data => x_msg_data,
546: p_encoded => FND_API.G_FALSE
547: );
548: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO sp_create_objfundsum;
550: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
551: Fnd_Msg_Pub.Count_And_Get (
552: p_count => x_msg_count,

Line 550: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

546: p_encoded => FND_API.G_FALSE
547: );
548: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO sp_create_objfundsum;
550: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
551: Fnd_Msg_Pub.Count_And_Get (
552: p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => FND_API.G_FALSE

Line 554: p_encoded => FND_API.G_FALSE

550: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
551: Fnd_Msg_Pub.Count_And_Get (
552: p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => FND_API.G_FALSE
555: );
556: WHEN OTHERS THEN
557: ROLLBACK TO sp_create_objfundsum;
558: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 558: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

554: p_encoded => FND_API.G_FALSE
555: );
556: WHEN OTHERS THEN
557: ROLLBACK TO sp_create_objfundsum;
558: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
559: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
560: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
561: END IF;
562: Fnd_Msg_Pub.Count_And_Get (

Line 565: p_encoded => FND_API.G_FALSE

561: END IF;
562: Fnd_Msg_Pub.Count_And_Get (
563: p_count => x_msg_count,
564: p_data => x_msg_data,
565: p_encoded => FND_API.G_FALSE
566: );
567: END Create_objfundsum;
568:
569:

Line 582: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

578: -- HISTORY
579: -- 05/26/1999 choang Created.
580: PROCEDURE Update_objfundsum (
581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
583: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
584: p_objfundsum_rec IN objfundsum_rec_type,
585: p_conv_date IN DATE DEFAULT NULL, --bug 8532055
586: x_return_status OUT NOCOPY VARCHAR2,

Line 583: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

579: -- 05/26/1999 choang Created.
580: PROCEDURE Update_objfundsum (
581: p_api_version IN NUMBER,
582: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
583: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
584: p_objfundsum_rec IN objfundsum_rec_type,
585: p_conv_date IN DATE DEFAULT NULL, --bug 8532055
586: x_return_status OUT NOCOPY VARCHAR2,
587: x_msg_count OUT NOCOPY NUMBER,

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

591: L_API_VERSION CONSTANT NUMBER := 1.0;
592: L_API_NAME CONSTANT VARCHAR2(30) := 'UPDATE_objfundsum';
593: L_FULL_NAME CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
594:
595: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
596: l_objfundsum_rec objfundsum_rec_type := p_objfundsum_rec;
597: l_amount_1 NUMBER;
598: l_amount_2 NUMBER;
599: l_amount_3 NUMBER;

Line 613: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN

609: IF (OZF_DEBUG_HIGH_ON) THEN
610: ozf_utility_pvt.debug_message(l_full_name||': start');
611: END IF;
612:
613: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
614: Fnd_Msg_Pub.Initialize;
615: END IF;
616:
617: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,

Line 617: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,

613: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
614: Fnd_Msg_Pub.Initialize;
615: END IF;
616:
617: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
618: p_api_version,
619: L_API_NAME,
620: G_PKG_NAME)
621: THEN

Line 622: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

618: p_api_version,
619: L_API_NAME,
620: G_PKG_NAME)
621: THEN
622: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
626:

Line 625: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

621: THEN
622: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
626:
627: IF (OZF_DEBUG_HIGH_ON) THEN
628: ozf_utility_pvt.debug_message(l_full_name ||': validate');
629: END IF;

Line 649: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

645: x_return_status => l_return_status,
646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data
648: );
649: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
650: RAISE Fnd_Api.G_EXC_ERROR;
651: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
652: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
653: END IF;

Line 650: RAISE Fnd_Api.G_EXC_ERROR;

646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data
648: );
649: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
650: RAISE Fnd_Api.G_EXC_ERROR;
651: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
652: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654: l_objfundsum_rec.plan_curr_planned_amt := l_amount_1;

Line 651: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

647: x_msg_data => x_msg_data
648: );
649: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
650: RAISE Fnd_Api.G_EXC_ERROR;
651: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
652: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654: l_objfundsum_rec.plan_curr_planned_amt := l_amount_1;
655: l_objfundsum_rec.planned_amt := l_amount_2;

Line 652: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

648: );
649: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
650: RAISE Fnd_Api.G_EXC_ERROR;
651: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
652: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654: l_objfundsum_rec.plan_curr_planned_amt := l_amount_1;
655: l_objfundsum_rec.planned_amt := l_amount_2;
656: l_objfundsum_rec.univ_curr_planned_amt := l_amount_3;

Line 673: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

669: x_return_status => l_return_status,
670: x_msg_count => x_msg_count,
671: x_msg_data => x_msg_data
672: );
673: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
674: RAISE Fnd_Api.G_EXC_ERROR;
675: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
676: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
677: END IF;

Line 674: RAISE Fnd_Api.G_EXC_ERROR;

670: x_msg_count => x_msg_count,
671: x_msg_data => x_msg_data
672: );
673: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
674: RAISE Fnd_Api.G_EXC_ERROR;
675: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
676: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
677: END IF;
678: l_objfundsum_rec.plan_curr_committed_amt := l_amount_1;

Line 675: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

671: x_msg_data => x_msg_data
672: );
673: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
674: RAISE Fnd_Api.G_EXC_ERROR;
675: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
676: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
677: END IF;
678: l_objfundsum_rec.plan_curr_committed_amt := l_amount_1;
679: l_objfundsum_rec.committed_amt := l_amount_2;

Line 676: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

672: );
673: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
674: RAISE Fnd_Api.G_EXC_ERROR;
675: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
676: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
677: END IF;
678: l_objfundsum_rec.plan_curr_committed_amt := l_amount_1;
679: l_objfundsum_rec.committed_amt := l_amount_2;
680: l_objfundsum_rec.univ_curr_committed_amt := l_amount_3;

Line 697: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

693: x_return_status => l_return_status,
694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data
696: );
697: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
698: RAISE Fnd_Api.G_EXC_ERROR;
699: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
700: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
701: END IF;

Line 698: RAISE Fnd_Api.G_EXC_ERROR;

694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data
696: );
697: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
698: RAISE Fnd_Api.G_EXC_ERROR;
699: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
700: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
701: END IF;
702: l_objfundsum_rec.plan_curr_recal_committed_amt := l_amount_1;

Line 699: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

695: x_msg_data => x_msg_data
696: );
697: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
698: RAISE Fnd_Api.G_EXC_ERROR;
699: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
700: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
701: END IF;
702: l_objfundsum_rec.plan_curr_recal_committed_amt := l_amount_1;
703: l_objfundsum_rec.recal_committed_amt := l_amount_2;

Line 700: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

696: );
697: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
698: RAISE Fnd_Api.G_EXC_ERROR;
699: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
700: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
701: END IF;
702: l_objfundsum_rec.plan_curr_recal_committed_amt := l_amount_1;
703: l_objfundsum_rec.recal_committed_amt := l_amount_2;
704: l_objfundsum_rec.univ_curr_recal_committed_amt := l_amount_3;

Line 727: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

723: x_return_status => l_return_status,
724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data
726: );
727: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
728: RAISE Fnd_Api.G_EXC_ERROR;
729: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
730: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
731: END IF;

Line 728: RAISE Fnd_Api.G_EXC_ERROR;

724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data
726: );
727: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
728: RAISE Fnd_Api.G_EXC_ERROR;
729: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
730: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732: l_objfundsum_rec.plan_curr_utilized_amt := l_amount_1;

Line 729: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

725: x_msg_data => x_msg_data
726: );
727: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
728: RAISE Fnd_Api.G_EXC_ERROR;
729: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
730: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732: l_objfundsum_rec.plan_curr_utilized_amt := l_amount_1;
733: l_objfundsum_rec.utilized_amt := l_amount_2;

Line 730: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

726: );
727: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
728: RAISE Fnd_Api.G_EXC_ERROR;
729: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
730: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732: l_objfundsum_rec.plan_curr_utilized_amt := l_amount_1;
733: l_objfundsum_rec.utilized_amt := l_amount_2;
734: l_objfundsum_rec.univ_curr_utilized_amt := l_amount_3;

Line 757: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

753: x_return_status => l_return_status,
754: x_msg_count => x_msg_count,
755: x_msg_data => x_msg_data
756: );
757: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
758: RAISE Fnd_Api.G_EXC_ERROR;
759: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
760: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
761: END IF;

Line 758: RAISE Fnd_Api.G_EXC_ERROR;

754: x_msg_count => x_msg_count,
755: x_msg_data => x_msg_data
756: );
757: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
758: RAISE Fnd_Api.G_EXC_ERROR;
759: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
760: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
761: END IF;
762: l_objfundsum_rec.plan_curr_earned_amt := l_amount_1;

Line 759: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

755: x_msg_data => x_msg_data
756: );
757: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
758: RAISE Fnd_Api.G_EXC_ERROR;
759: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
760: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
761: END IF;
762: l_objfundsum_rec.plan_curr_earned_amt := l_amount_1;
763: l_objfundsum_rec.earned_amt := l_amount_2;

Line 760: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

756: );
757: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
758: RAISE Fnd_Api.G_EXC_ERROR;
759: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
760: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
761: END IF;
762: l_objfundsum_rec.plan_curr_earned_amt := l_amount_1;
763: l_objfundsum_rec.earned_amt := l_amount_2;
764: l_objfundsum_rec.univ_curr_earned_amt := l_amount_3;

Line 787: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

783: x_return_status => l_return_status,
784: x_msg_count => x_msg_count,
785: x_msg_data => x_msg_data
786: );
787: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
788: RAISE Fnd_Api.G_EXC_ERROR;
789: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
790: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
791: END IF;

Line 788: RAISE Fnd_Api.G_EXC_ERROR;

784: x_msg_count => x_msg_count,
785: x_msg_data => x_msg_data
786: );
787: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
788: RAISE Fnd_Api.G_EXC_ERROR;
789: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
790: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792: l_objfundsum_rec.plan_curr_paid_amt := l_amount_1;

Line 789: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

785: x_msg_data => x_msg_data
786: );
787: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
788: RAISE Fnd_Api.G_EXC_ERROR;
789: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
790: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792: l_objfundsum_rec.plan_curr_paid_amt := l_amount_1;
793: l_objfundsum_rec.paid_amt := l_amount_2;

Line 790: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

786: );
787: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
788: RAISE Fnd_Api.G_EXC_ERROR;
789: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
790: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
791: END IF;
792: l_objfundsum_rec.plan_curr_paid_amt := l_amount_1;
793: l_objfundsum_rec.paid_amt := l_amount_2;
794: l_objfundsum_rec.univ_curr_paid_amt := l_amount_3;

Line 806: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN

802: x_msg_count => x_msg_count,
803: x_msg_data => x_msg_data,
804: x_return_status => l_return_status
805: );
806: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
807: RAISE Fnd_Api.g_exc_unexpected_error;
808: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
809: RAISE Fnd_Api.g_exc_error;
810: END IF;

Line 807: RAISE Fnd_Api.g_exc_unexpected_error;

803: x_msg_data => x_msg_data,
804: x_return_status => l_return_status
805: );
806: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
807: RAISE Fnd_Api.g_exc_unexpected_error;
808: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
809: RAISE Fnd_Api.g_exc_error;
810: END IF;
811: END IF;

Line 808: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN

804: x_return_status => l_return_status
805: );
806: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
807: RAISE Fnd_Api.g_exc_unexpected_error;
808: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
809: RAISE Fnd_Api.g_exc_error;
810: END IF;
811: END IF;
812:

Line 809: RAISE Fnd_Api.g_exc_error;

805: );
806: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
807: RAISE Fnd_Api.g_exc_unexpected_error;
808: ELSIF l_return_status = Fnd_Api.g_ret_sts_error THEN
809: RAISE Fnd_Api.g_exc_error;
810: END IF;
811: END IF;
812:
813:

Line 873: RAISE Fnd_Api.g_exc_error;

869: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
870: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
871: Fnd_Msg_Pub.ADD;
872: END IF;
873: RAISE Fnd_Api.g_exc_error;
874: END IF;
875:
876: Fnd_Msg_Pub.Count_And_Get (
877: p_count => x_msg_count,

Line 879: p_encoded => Fnd_Api.G_FALSE

875:
876: Fnd_Msg_Pub.Count_And_Get (
877: p_count => x_msg_count,
878: p_data => x_msg_data,
879: p_encoded => Fnd_Api.G_FALSE
880: );
881:
882: IF (OZF_DEBUG_HIGH_ON) THEN
883: ozf_utility_pvt.debug_message(l_full_name ||': end');

Line 888: WHEN Fnd_Api.G_EXC_ERROR THEN

884: END IF;
885:
886:
887: EXCEPTION
888: WHEN Fnd_Api.G_EXC_ERROR THEN
889: ROLLBACK TO SP_Update_objfundsum;
890: x_return_status := Fnd_Api.G_RET_STS_ERROR;
891: Fnd_Msg_Pub.Count_And_Get (
892: p_count => x_msg_count,

Line 890: x_return_status := Fnd_Api.G_RET_STS_ERROR;

886:
887: EXCEPTION
888: WHEN Fnd_Api.G_EXC_ERROR THEN
889: ROLLBACK TO SP_Update_objfundsum;
890: x_return_status := Fnd_Api.G_RET_STS_ERROR;
891: Fnd_Msg_Pub.Count_And_Get (
892: p_count => x_msg_count,
893: p_data => x_msg_data,
894: p_encoded => FND_API.G_FALSE

Line 894: p_encoded => FND_API.G_FALSE

890: x_return_status := Fnd_Api.G_RET_STS_ERROR;
891: Fnd_Msg_Pub.Count_And_Get (
892: p_count => x_msg_count,
893: p_data => x_msg_data,
894: p_encoded => FND_API.G_FALSE
895: );
896: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
897: ROLLBACK TO SP_Update_objfundsum;
898: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 896: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

892: p_count => x_msg_count,
893: p_data => x_msg_data,
894: p_encoded => FND_API.G_FALSE
895: );
896: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
897: ROLLBACK TO SP_Update_objfundsum;
898: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
899: Fnd_Msg_Pub.Count_And_Get (
900: p_count => x_msg_count,

Line 898: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

894: p_encoded => FND_API.G_FALSE
895: );
896: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
897: ROLLBACK TO SP_Update_objfundsum;
898: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
899: Fnd_Msg_Pub.Count_And_Get (
900: p_count => x_msg_count,
901: p_data => x_msg_data,
902: p_encoded => FND_API.G_FALSE

Line 902: p_encoded => FND_API.G_FALSE

898: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
899: Fnd_Msg_Pub.Count_And_Get (
900: p_count => x_msg_count,
901: p_data => x_msg_data,
902: p_encoded => FND_API.G_FALSE
903: );
904: WHEN OTHERS THEN
905: ROLLBACK TO SP_Update_objfundsum;
906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

902: p_encoded => FND_API.G_FALSE
903: );
904: WHEN OTHERS THEN
905: ROLLBACK TO SP_Update_objfundsum;
906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
907: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
908: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
909: END IF;
910: Fnd_Msg_Pub.Count_And_Get (

Line 913: p_encoded => FND_API.G_FALSE

909: END IF;
910: Fnd_Msg_Pub.Count_And_Get (
911: p_count => x_msg_count,
912: p_data => x_msg_data,
913: p_encoded => FND_API.G_FALSE
914: );
915: END Update_objfundsum;
916:
917:

Line 932: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

928: --
929: --
930: PROCEDURE process_objfundsum (
931: p_api_version IN NUMBER,
932: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
933: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
934: p_objfundsum_rec IN objfundsum_rec_type,
935: x_return_status OUT NOCOPY VARCHAR2,
936: x_msg_count OUT NOCOPY NUMBER,

Line 933: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,

929: --
930: PROCEDURE process_objfundsum (
931: p_api_version IN NUMBER,
932: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
933: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
934: p_objfundsum_rec IN objfundsum_rec_type,
935: x_return_status OUT NOCOPY VARCHAR2,
936: x_msg_count OUT NOCOPY NUMBER,
937: x_msg_data OUT NOCOPY VARCHAR2,

Line 1016: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1012: x_msg_data => x_msg_data,
1013: x_objfundsum_id => l_objfundsum_id
1014: );
1015: -- dbms_output.put_line('process_objfunsum: create_objfunsum returns ' || l_return_status);
1016: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1017: RAISE fnd_api.g_exc_unexpected_error;
1018: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1019: RAISE fnd_api.g_exc_error;
1020: END IF;

Line 1017: RAISE fnd_api.g_exc_unexpected_error;

1013: x_objfundsum_id => l_objfundsum_id
1014: );
1015: -- dbms_output.put_line('process_objfunsum: create_objfunsum returns ' || l_return_status);
1016: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1017: RAISE fnd_api.g_exc_unexpected_error;
1018: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1019: RAISE fnd_api.g_exc_error;
1020: END IF;
1021: RETURN;

Line 1018: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1014: );
1015: -- dbms_output.put_line('process_objfunsum: create_objfunsum returns ' || l_return_status);
1016: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1017: RAISE fnd_api.g_exc_unexpected_error;
1018: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1019: RAISE fnd_api.g_exc_error;
1020: END IF;
1021: RETURN;
1022: ELSE

Line 1019: RAISE fnd_api.g_exc_error;

1015: -- dbms_output.put_line('process_objfunsum: create_objfunsum returns ' || l_return_status);
1016: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1017: RAISE fnd_api.g_exc_unexpected_error;
1018: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1019: RAISE fnd_api.g_exc_error;
1020: END IF;
1021: RETURN;
1022: ELSE
1023: CLOSE c_get_objfundsum_rec;

Line 1105: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1101: x_msg_count => x_msg_count,
1102: x_msg_data => x_msg_data
1103: );
1104: -- dbms_output.put_line('process_objfunsum: update_objfunsum returns ' || x_return_status);
1105: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1106: RAISE fnd_api.g_exc_unexpected_error;
1107: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1108: RAISE fnd_api.g_exc_error;
1109: END IF;

Line 1106: RAISE fnd_api.g_exc_unexpected_error;

1102: x_msg_data => x_msg_data
1103: );
1104: -- dbms_output.put_line('process_objfunsum: update_objfunsum returns ' || x_return_status);
1105: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1106: RAISE fnd_api.g_exc_unexpected_error;
1107: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1108: RAISE fnd_api.g_exc_error;
1109: END IF;
1110:

Line 1107: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1103: );
1104: -- dbms_output.put_line('process_objfunsum: update_objfunsum returns ' || x_return_status);
1105: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1106: RAISE fnd_api.g_exc_unexpected_error;
1107: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1108: RAISE fnd_api.g_exc_error;
1109: END IF;
1110:
1111: EXCEPTION

Line 1108: RAISE fnd_api.g_exc_error;

1104: -- dbms_output.put_line('process_objfunsum: update_objfunsum returns ' || x_return_status);
1105: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1106: RAISE fnd_api.g_exc_unexpected_error;
1107: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1108: RAISE fnd_api.g_exc_error;
1109: END IF;
1110:
1111: EXCEPTION
1112: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1112: WHEN Fnd_Api.G_EXC_ERROR THEN

1108: RAISE fnd_api.g_exc_error;
1109: END IF;
1110:
1111: EXCEPTION
1112: WHEN Fnd_Api.G_EXC_ERROR THEN
1113: ROLLBACK TO SP_process_objfundsum;
1114: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1115: Fnd_Msg_Pub.Count_And_Get (
1116: p_count => x_msg_count,

Line 1114: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1110:
1111: EXCEPTION
1112: WHEN Fnd_Api.G_EXC_ERROR THEN
1113: ROLLBACK TO SP_process_objfundsum;
1114: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1115: Fnd_Msg_Pub.Count_And_Get (
1116: p_count => x_msg_count,
1117: p_data => x_msg_data,
1118: p_encoded => FND_API.G_FALSE

Line 1118: p_encoded => FND_API.G_FALSE

1114: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1115: Fnd_Msg_Pub.Count_And_Get (
1116: p_count => x_msg_count,
1117: p_data => x_msg_data,
1118: p_encoded => FND_API.G_FALSE
1119: );
1120: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1121: ROLLBACK TO SP_process_objfundsum;
1122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1120: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1116: p_count => x_msg_count,
1117: p_data => x_msg_data,
1118: p_encoded => FND_API.G_FALSE
1119: );
1120: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1121: ROLLBACK TO SP_process_objfundsum;
1122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1123: Fnd_Msg_Pub.Count_And_Get (
1124: p_count => x_msg_count,

Line 1122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1118: p_encoded => FND_API.G_FALSE
1119: );
1120: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1121: ROLLBACK TO SP_process_objfundsum;
1122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1123: Fnd_Msg_Pub.Count_And_Get (
1124: p_count => x_msg_count,
1125: p_data => x_msg_data,
1126: p_encoded => FND_API.G_FALSE

Line 1126: p_encoded => FND_API.G_FALSE

1122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1123: Fnd_Msg_Pub.Count_And_Get (
1124: p_count => x_msg_count,
1125: p_data => x_msg_data,
1126: p_encoded => FND_API.G_FALSE
1127: );
1128: WHEN OTHERS THEN
1129: ROLLBACK TO SP_process_objfundsum;
1130: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1130: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1126: p_encoded => FND_API.G_FALSE
1127: );
1128: WHEN OTHERS THEN
1129: ROLLBACK TO SP_process_objfundsum;
1130: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1131: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1132: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1133: END IF;
1134: Fnd_Msg_Pub.Count_And_Get (

Line 1137: p_encoded => FND_API.G_FALSE

1133: END IF;
1134: Fnd_Msg_Pub.Count_And_Get (
1135: p_count => x_msg_count,
1136: p_data => x_msg_data,
1137: p_encoded => FND_API.G_FALSE
1138: );
1139: END process_objfundsum;
1140:
1141:

Line 1155: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

1151: -- 06/30/2005 yzhao Created.
1152:
1153: PROCEDURE Validate_objfundsum (
1154: p_api_version IN NUMBER,
1155: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1156: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
1157: p_objfundsum_rec IN objfundsum_rec_type,
1158: x_return_status OUT NOCOPY VARCHAR2,
1159: x_msg_count OUT NOCOPY NUMBER,

Line 1156: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,

1152:
1153: PROCEDURE Validate_objfundsum (
1154: p_api_version IN NUMBER,
1155: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
1156: p_validation_level IN NUMBER := Fnd_Api.G_Valid_Level_Full,
1157: p_objfundsum_rec IN objfundsum_rec_type,
1158: x_return_status OUT NOCOPY VARCHAR2,
1159: x_msg_count OUT NOCOPY NUMBER,
1160: x_msg_data OUT NOCOPY VARCHAR2

Line 1177: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN

1173: IF (OZF_DEBUG_HIGH_ON) THEN
1174: ozf_utility_pvt.debug_message(l_full_name||': start');
1175: END IF;
1176:
1177: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1178: Fnd_Msg_Pub.Initialize;
1179: END IF;
1180:
1181: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,

Line 1181: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,

1177: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1178: Fnd_Msg_Pub.Initialize;
1179: END IF;
1180:
1181: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
1182: p_api_version,
1183: L_API_NAME,
1184: G_PKG_NAME)
1185: THEN

Line 1186: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1182: p_api_version,
1183: L_API_NAME,
1184: G_PKG_NAME)
1185: THEN
1186: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1187: END IF;
1188:
1189: x_return_status := NULL;
1190:

Line 1198: p_objfundsum_rec.fund_id = fnd_api.g_miss_num

1194:
1195: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1196: -- fund_id is required
1197: IF p_objfundsum_rec.fund_id IS NULL OR
1198: p_objfundsum_rec.fund_id = fnd_api.g_miss_num
1199: THEN
1200: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1201: THEN
1202: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_ID');

Line 1205: RAISE Fnd_Api.G_EXC_ERROR;

1201: THEN
1202: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_ID');
1203: Fnd_Msg_Pub.ADD;
1204: END IF;
1205: RAISE Fnd_Api.G_EXC_ERROR;
1206: END IF;
1207:
1208: -- fund_currency is required
1209: IF p_objfundsum_rec.fund_currency IS NULL OR

Line 1210: p_objfundsum_rec.fund_currency = fnd_api.g_miss_char

1206: END IF;
1207:
1208: -- fund_currency is required
1209: IF p_objfundsum_rec.fund_currency IS NULL OR
1210: p_objfundsum_rec.fund_currency = fnd_api.g_miss_char
1211: THEN
1212: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1213: THEN
1214: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_CURRENCY');

Line 1217: RAISE Fnd_Api.G_EXC_ERROR;

1213: THEN
1214: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_CURRENCY');
1215: Fnd_Msg_Pub.ADD;
1216: END IF;
1217: RAISE Fnd_Api.G_EXC_ERROR;
1218: END IF;
1219:
1220: -- object_type is required
1221: IF p_objfundsum_rec.object_type IS NULL OR

Line 1222: p_objfundsum_rec.object_type = fnd_api.g_miss_char

1218: END IF;
1219:
1220: -- object_type is required
1221: IF p_objfundsum_rec.object_type IS NULL OR
1222: p_objfundsum_rec.object_type = fnd_api.g_miss_char
1223: THEN
1224: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1225: THEN
1226: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_TYPE');

Line 1229: RAISE Fnd_Api.G_EXC_ERROR;

1225: THEN
1226: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_TYPE');
1227: Fnd_Msg_Pub.ADD;
1228: END IF;
1229: RAISE Fnd_Api.G_EXC_ERROR;
1230: END IF;
1231:
1232: -- object_id is required
1233: IF p_objfundsum_rec.object_id IS NULL OR

Line 1234: p_objfundsum_rec.object_id = fnd_api.g_miss_num

1230: END IF;
1231:
1232: -- object_id is required
1233: IF p_objfundsum_rec.object_id IS NULL OR
1234: p_objfundsum_rec.object_id = fnd_api.g_miss_num
1235: THEN
1236: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1237: THEN
1238: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_ID');

Line 1241: RAISE Fnd_Api.G_EXC_ERROR;

1237: THEN
1238: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_ID');
1239: Fnd_Msg_Pub.ADD;
1240: END IF;
1241: RAISE Fnd_Api.G_EXC_ERROR;
1242: END IF;
1243:
1244: -- object_currency is required
1245: IF p_objfundsum_rec.object_currency IS NULL OR

Line 1246: p_objfundsum_rec.object_currency = fnd_api.g_miss_char

1242: END IF;
1243:
1244: -- object_currency is required
1245: IF p_objfundsum_rec.object_currency IS NULL OR
1246: p_objfundsum_rec.object_currency = fnd_api.g_miss_char
1247: THEN
1248: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1249: THEN
1250: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_CURRENCY');

Line 1253: RAISE Fnd_Api.G_EXC_ERROR;

1249: THEN
1250: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_CURRENCY');
1251: Fnd_Msg_Pub.ADD;
1252: END IF;
1253: RAISE Fnd_Api.G_EXC_ERROR;
1254: END IF;
1255:
1256: -- object_type should be valid code in lookup type OZF_FUND_TYPE
1257: IF ozf_utility_pvt.check_lookup_exists (

Line 1260: ) = fnd_api.g_false THEN

1256: -- object_type should be valid code in lookup type OZF_FUND_TYPE
1257: IF ozf_utility_pvt.check_lookup_exists (
1258: p_lookup_type=> 'OZF_FUND_SOURCE'
1259: ,p_lookup_code=> p_objfundsum_rec.object_type
1260: ) = fnd_api.g_false THEN
1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1262: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJTYPE');
1263: fnd_msg_pub.ADD;
1264: END IF;

Line 1265: RAISE Fnd_Api.G_EXC_ERROR;

1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1262: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJTYPE');
1263: fnd_msg_pub.ADD;
1264: END IF;
1265: RAISE Fnd_Api.G_EXC_ERROR;
1266: END IF;
1267:
1268: -- fund_id should be valid in ozf_funds_all_b
1269: IF ozf_utility_pvt.check_fk_exists (

Line 1273: ) = fnd_api.g_false THEN

1269: IF ozf_utility_pvt.check_fk_exists (
1270: p_table_name=> 'OZF_FUNDS_ALL_B'
1271: ,p_pk_name=> 'FUND_ID'
1272: ,p_pk_value=> p_objfundsum_rec.fund_id
1273: ) = fnd_api.g_false THEN
1274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1275: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_FUNDID');
1276: fnd_msg_pub.ADD;
1277: END IF;

Line 1278: RAISE Fnd_Api.G_EXC_ERROR;

1274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1275: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_FUNDID');
1276: fnd_msg_pub.ADD;
1277: END IF;
1278: RAISE Fnd_Api.G_EXC_ERROR;
1279: END IF;
1280:
1281: -- Check FK parameter: object_id
1282: IF p_objfundsum_rec.object_type = ('EVEH') THEN

Line 1307: ) = fnd_api.g_false THEN

1303: IF ozf_utility_pvt.check_fk_exists (
1304: p_table_name=> l_table_name
1305: ,p_pk_name=> l_pk_name
1306: ,p_pk_value=> l_pk_value
1307: ) = fnd_api.g_false THEN
1308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1309: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJID');
1310: fnd_msg_pub.ADD;
1311: END IF;

Line 1312: RAISE Fnd_Api.G_EXC_ERROR;

1308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1309: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJID');
1310: fnd_msg_pub.ADD;
1311: END IF;
1312: RAISE Fnd_Api.G_EXC_ERROR;
1313: END IF;
1314:
1315: END IF;
1316:

Line 1317: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1313: END IF;
1314:
1315: END IF;
1316:
1317: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1318:
1319: Fnd_Msg_Pub.Count_And_Get (
1320: p_count => x_msg_count,
1321: p_data => x_msg_data,

Line 1322: p_encoded => Fnd_Api.G_FALSE

1318:
1319: Fnd_Msg_Pub.Count_And_Get (
1320: p_count => x_msg_count,
1321: p_data => x_msg_data,
1322: p_encoded => Fnd_Api.G_FALSE
1323: );
1324:
1325: IF (OZF_DEBUG_HIGH_ON) THEN
1326: ozf_utility_pvt.debug_message(l_full_name ||': end');

Line 1330: WHEN Fnd_Api.G_EXC_ERROR THEN

1326: ozf_utility_pvt.debug_message(l_full_name ||': end');
1327: END IF;
1328:
1329: EXCEPTION
1330: WHEN Fnd_Api.G_EXC_ERROR THEN
1331: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1332: Fnd_Msg_Pub.Count_And_Get (
1333: p_count => x_msg_count,
1334: p_data => x_msg_data,

Line 1331: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1327: END IF;
1328:
1329: EXCEPTION
1330: WHEN Fnd_Api.G_EXC_ERROR THEN
1331: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1332: Fnd_Msg_Pub.Count_And_Get (
1333: p_count => x_msg_count,
1334: p_data => x_msg_data,
1335: p_encoded => FND_API.G_FALSE

Line 1335: p_encoded => FND_API.G_FALSE

1331: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1332: Fnd_Msg_Pub.Count_And_Get (
1333: p_count => x_msg_count,
1334: p_data => x_msg_data,
1335: p_encoded => FND_API.G_FALSE
1336: );
1337: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1338: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1339: Fnd_Msg_Pub.Count_And_Get (

Line 1337: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1333: p_count => x_msg_count,
1334: p_data => x_msg_data,
1335: p_encoded => FND_API.G_FALSE
1336: );
1337: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1338: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1339: Fnd_Msg_Pub.Count_And_Get (
1340: p_count => x_msg_count,
1341: p_data => x_msg_data,

Line 1338: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1334: p_data => x_msg_data,
1335: p_encoded => FND_API.G_FALSE
1336: );
1337: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1338: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1339: Fnd_Msg_Pub.Count_And_Get (
1340: p_count => x_msg_count,
1341: p_data => x_msg_data,
1342: p_encoded => FND_API.G_FALSE

Line 1342: p_encoded => FND_API.G_FALSE

1338: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1339: Fnd_Msg_Pub.Count_And_Get (
1340: p_count => x_msg_count,
1341: p_data => x_msg_data,
1342: p_encoded => FND_API.G_FALSE
1343: );
1344: WHEN OTHERS THEN
1345: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1346: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1345: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1341: p_data => x_msg_data,
1342: p_encoded => FND_API.G_FALSE
1343: );
1344: WHEN OTHERS THEN
1345: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1346: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1347: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1348: END IF;
1349: Fnd_Msg_Pub.Count_And_Get (

Line 1352: p_encoded => FND_API.G_FALSE

1348: END IF;
1349: Fnd_Msg_Pub.Count_And_Get (
1350: p_count => x_msg_count,
1351: p_data => x_msg_data,
1352: p_encoded => FND_API.G_FALSE
1353: );
1354: END Validate_objfundsum;
1355:
1356:

Line 1393: RAISE Fnd_Api.g_exc_error;

1389: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1390: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1391: Fnd_Msg_Pub.ADD;
1392: END IF;
1393: RAISE Fnd_Api.g_exc_error;
1394: END IF;
1395: CLOSE c_objfundsum;
1396:
1397: IF p_objfundsum_rec.fund_id = Fnd_Api.G_MISS_NUM THEN

Line 1397: IF p_objfundsum_rec.fund_id = Fnd_Api.G_MISS_NUM THEN

1393: RAISE Fnd_Api.g_exc_error;
1394: END IF;
1395: CLOSE c_objfundsum;
1396:
1397: IF p_objfundsum_rec.fund_id = Fnd_Api.G_MISS_NUM THEN
1398: x_complete_rec.fund_id := NULL;
1399: END IF;
1400: IF p_objfundsum_rec.fund_id IS NULL THEN
1401: x_complete_rec.fund_id := l_objfundsum_rec.fund_id;

Line 1404: IF p_objfundsum_rec.fund_currency = Fnd_Api.G_MISS_CHAR THEN

1400: IF p_objfundsum_rec.fund_id IS NULL THEN
1401: x_complete_rec.fund_id := l_objfundsum_rec.fund_id;
1402: END IF;
1403:
1404: IF p_objfundsum_rec.fund_currency = Fnd_Api.G_MISS_CHAR THEN
1405: x_complete_rec.fund_currency := NULL;
1406: END IF;
1407: IF p_objfundsum_rec.fund_currency IS NULL THEN
1408: x_complete_rec.fund_currency := l_objfundsum_rec.fund_currency;

Line 1411: IF p_objfundsum_rec.object_type = Fnd_Api.G_MISS_CHAR THEN

1407: IF p_objfundsum_rec.fund_currency IS NULL THEN
1408: x_complete_rec.fund_currency := l_objfundsum_rec.fund_currency;
1409: END IF;
1410:
1411: IF p_objfundsum_rec.object_type = Fnd_Api.G_MISS_CHAR THEN
1412: x_complete_rec.object_type := NULL;
1413: END IF;
1414: IF p_objfundsum_rec.object_type IS NULL THEN
1415: x_complete_rec.object_type := l_objfundsum_rec.object_type;

Line 1418: IF p_objfundsum_rec.object_id = Fnd_Api.G_MISS_NUM THEN

1414: IF p_objfundsum_rec.object_type IS NULL THEN
1415: x_complete_rec.object_type := l_objfundsum_rec.object_type;
1416: END IF;
1417:
1418: IF p_objfundsum_rec.object_id = Fnd_Api.G_MISS_NUM THEN
1419: x_complete_rec.object_id := NULL;
1420: END IF;
1421: IF p_objfundsum_rec.object_id IS NULL THEN
1422: x_complete_rec.object_id := l_objfundsum_rec.object_id;

Line 1425: IF p_objfundsum_rec.object_currency = Fnd_Api.G_MISS_CHAR THEN

1421: IF p_objfundsum_rec.object_id IS NULL THEN
1422: x_complete_rec.object_id := l_objfundsum_rec.object_id;
1423: END IF;
1424:
1425: IF p_objfundsum_rec.object_currency = Fnd_Api.G_MISS_CHAR THEN
1426: x_complete_rec.object_currency := NULL;
1427: END IF;
1428: IF p_objfundsum_rec.object_currency IS NULL THEN
1429: x_complete_rec.object_currency := l_objfundsum_rec.object_currency;

Line 1432: IF p_objfundsum_rec.reference_object_type = Fnd_Api.G_MISS_CHAR THEN

1428: IF p_objfundsum_rec.object_currency IS NULL THEN
1429: x_complete_rec.object_currency := l_objfundsum_rec.object_currency;
1430: END IF;
1431:
1432: IF p_objfundsum_rec.reference_object_type = Fnd_Api.G_MISS_CHAR THEN
1433: x_complete_rec.reference_object_type := NULL;
1434: END IF;
1435: IF p_objfundsum_rec.reference_object_type IS NULL THEN
1436: x_complete_rec.reference_object_type := l_objfundsum_rec.reference_object_type;

Line 1439: IF p_objfundsum_rec.reference_object_id = Fnd_Api.G_MISS_NUM THEN

1435: IF p_objfundsum_rec.reference_object_type IS NULL THEN
1436: x_complete_rec.reference_object_type := l_objfundsum_rec.reference_object_type;
1437: END IF;
1438:
1439: IF p_objfundsum_rec.reference_object_id = Fnd_Api.G_MISS_NUM THEN
1440: x_complete_rec.reference_object_id := NULL;
1441: END IF;
1442: IF p_objfundsum_rec.reference_object_id IS NULL THEN
1443: x_complete_rec.reference_object_id := l_objfundsum_rec.reference_object_id;

Line 1446: IF p_objfundsum_rec.source_from_parent = Fnd_Api.G_MISS_CHAR THEN

1442: IF p_objfundsum_rec.reference_object_id IS NULL THEN
1443: x_complete_rec.reference_object_id := l_objfundsum_rec.reference_object_id;
1444: END IF;
1445:
1446: IF p_objfundsum_rec.source_from_parent = Fnd_Api.G_MISS_CHAR THEN
1447: x_complete_rec.source_from_parent := NULL;
1448: END IF;
1449: IF p_objfundsum_rec.source_from_parent IS NULL THEN
1450: x_complete_rec.source_from_parent := l_objfundsum_rec.source_from_parent;

Line 1453: IF p_objfundsum_rec.planned_amt = Fnd_Api.G_MISS_NUM THEN

1449: IF p_objfundsum_rec.source_from_parent IS NULL THEN
1450: x_complete_rec.source_from_parent := l_objfundsum_rec.source_from_parent;
1451: END IF;
1452:
1453: IF p_objfundsum_rec.planned_amt = Fnd_Api.G_MISS_NUM THEN
1454: x_complete_rec.planned_amt := NULL;
1455: END IF;
1456: IF p_objfundsum_rec.planned_amt IS NULL THEN
1457: x_complete_rec.planned_amt := l_objfundsum_rec.planned_amt;

Line 1460: IF p_objfundsum_rec.committed_amt = Fnd_Api.G_MISS_NUM THEN

1456: IF p_objfundsum_rec.planned_amt IS NULL THEN
1457: x_complete_rec.planned_amt := l_objfundsum_rec.planned_amt;
1458: END IF;
1459:
1460: IF p_objfundsum_rec.committed_amt = Fnd_Api.G_MISS_NUM THEN
1461: x_complete_rec.committed_amt := NULL;
1462: END IF;
1463: IF p_objfundsum_rec.committed_amt IS NULL THEN
1464: x_complete_rec.committed_amt := l_objfundsum_rec.committed_amt;

Line 1467: IF p_objfundsum_rec.recal_committed_amt = Fnd_Api.G_MISS_NUM THEN

1463: IF p_objfundsum_rec.committed_amt IS NULL THEN
1464: x_complete_rec.committed_amt := l_objfundsum_rec.committed_amt;
1465: END IF;
1466:
1467: IF p_objfundsum_rec.recal_committed_amt = Fnd_Api.G_MISS_NUM THEN
1468: x_complete_rec.recal_committed_amt := NULL;
1469: END IF;
1470: IF p_objfundsum_rec.recal_committed_amt IS NULL THEN
1471: x_complete_rec.recal_committed_amt := l_objfundsum_rec.recal_committed_amt;

Line 1474: IF p_objfundsum_rec.utilized_amt = Fnd_Api.G_MISS_NUM THEN

1470: IF p_objfundsum_rec.recal_committed_amt IS NULL THEN
1471: x_complete_rec.recal_committed_amt := l_objfundsum_rec.recal_committed_amt;
1472: END IF;
1473:
1474: IF p_objfundsum_rec.utilized_amt = Fnd_Api.G_MISS_NUM THEN
1475: x_complete_rec.utilized_amt := NULL;
1476: END IF;
1477: IF p_objfundsum_rec.utilized_amt IS NULL THEN
1478: x_complete_rec.utilized_amt := l_objfundsum_rec.utilized_amt;

Line 1481: IF p_objfundsum_rec.earned_amt = Fnd_Api.G_MISS_NUM THEN

1477: IF p_objfundsum_rec.utilized_amt IS NULL THEN
1478: x_complete_rec.utilized_amt := l_objfundsum_rec.utilized_amt;
1479: END IF;
1480:
1481: IF p_objfundsum_rec.earned_amt = Fnd_Api.G_MISS_NUM THEN
1482: x_complete_rec.earned_amt := NULL;
1483: END IF;
1484: IF p_objfundsum_rec.earned_amt IS NULL THEN
1485: x_complete_rec.earned_amt := l_objfundsum_rec.earned_amt;

Line 1488: IF p_objfundsum_rec.paid_amt = Fnd_Api.G_MISS_NUM THEN

1484: IF p_objfundsum_rec.earned_amt IS NULL THEN
1485: x_complete_rec.earned_amt := l_objfundsum_rec.earned_amt;
1486: END IF;
1487:
1488: IF p_objfundsum_rec.paid_amt = Fnd_Api.G_MISS_NUM THEN
1489: x_complete_rec.paid_amt := NULL;
1490: END IF;
1491: IF p_objfundsum_rec.paid_amt IS NULL THEN
1492: x_complete_rec.paid_amt := l_objfundsum_rec.paid_amt;

Line 1495: IF p_objfundsum_rec.plan_curr_planned_amt = Fnd_Api.G_MISS_NUM THEN

1491: IF p_objfundsum_rec.paid_amt IS NULL THEN
1492: x_complete_rec.paid_amt := l_objfundsum_rec.paid_amt;
1493: END IF;
1494:
1495: IF p_objfundsum_rec.plan_curr_planned_amt = Fnd_Api.G_MISS_NUM THEN
1496: x_complete_rec.plan_curr_planned_amt := NULL;
1497: END IF;
1498: IF p_objfundsum_rec.plan_curr_planned_amt IS NULL THEN
1499: x_complete_rec.plan_curr_planned_amt := l_objfundsum_rec.plan_curr_planned_amt;

Line 1502: IF p_objfundsum_rec.plan_curr_committed_amt = Fnd_Api.G_MISS_NUM THEN

1498: IF p_objfundsum_rec.plan_curr_planned_amt IS NULL THEN
1499: x_complete_rec.plan_curr_planned_amt := l_objfundsum_rec.plan_curr_planned_amt;
1500: END IF;
1501:
1502: IF p_objfundsum_rec.plan_curr_committed_amt = Fnd_Api.G_MISS_NUM THEN
1503: x_complete_rec.plan_curr_committed_amt := NULL;
1504: END IF;
1505: IF p_objfundsum_rec.plan_curr_committed_amt IS NULL THEN
1506: x_complete_rec.plan_curr_committed_amt := l_objfundsum_rec.plan_curr_committed_amt;

Line 1509: IF p_objfundsum_rec.plan_curr_recal_committed_amt = Fnd_Api.G_MISS_NUM THEN

1505: IF p_objfundsum_rec.plan_curr_committed_amt IS NULL THEN
1506: x_complete_rec.plan_curr_committed_amt := l_objfundsum_rec.plan_curr_committed_amt;
1507: END IF;
1508:
1509: IF p_objfundsum_rec.plan_curr_recal_committed_amt = Fnd_Api.G_MISS_NUM THEN
1510: x_complete_rec.plan_curr_recal_committed_amt := NULL;
1511: END IF;
1512: IF p_objfundsum_rec.plan_curr_recal_committed_amt IS NULL THEN
1513: x_complete_rec.plan_curr_recal_committed_amt := l_objfundsum_rec.plan_curr_recal_committed_amt;

Line 1516: IF p_objfundsum_rec.plan_curr_utilized_amt = Fnd_Api.G_MISS_NUM THEN

1512: IF p_objfundsum_rec.plan_curr_recal_committed_amt IS NULL THEN
1513: x_complete_rec.plan_curr_recal_committed_amt := l_objfundsum_rec.plan_curr_recal_committed_amt;
1514: END IF;
1515:
1516: IF p_objfundsum_rec.plan_curr_utilized_amt = Fnd_Api.G_MISS_NUM THEN
1517: x_complete_rec.plan_curr_utilized_amt := NULL;
1518: END IF;
1519: IF p_objfundsum_rec.plan_curr_utilized_amt IS NULL THEN
1520: x_complete_rec.plan_curr_utilized_amt := l_objfundsum_rec.plan_curr_utilized_amt;

Line 1523: IF p_objfundsum_rec.plan_curr_earned_amt = Fnd_Api.G_MISS_NUM THEN

1519: IF p_objfundsum_rec.plan_curr_utilized_amt IS NULL THEN
1520: x_complete_rec.plan_curr_utilized_amt := l_objfundsum_rec.plan_curr_utilized_amt;
1521: END IF;
1522:
1523: IF p_objfundsum_rec.plan_curr_earned_amt = Fnd_Api.G_MISS_NUM THEN
1524: x_complete_rec.plan_curr_earned_amt := NULL;
1525: END IF;
1526: IF p_objfundsum_rec.plan_curr_earned_amt IS NULL THEN
1527: x_complete_rec.plan_curr_earned_amt := l_objfundsum_rec.plan_curr_earned_amt;

Line 1530: IF p_objfundsum_rec.plan_curr_paid_amt = Fnd_Api.G_MISS_NUM THEN

1526: IF p_objfundsum_rec.plan_curr_earned_amt IS NULL THEN
1527: x_complete_rec.plan_curr_earned_amt := l_objfundsum_rec.plan_curr_earned_amt;
1528: END IF;
1529:
1530: IF p_objfundsum_rec.plan_curr_paid_amt = Fnd_Api.G_MISS_NUM THEN
1531: x_complete_rec.plan_curr_paid_amt := NULL;
1532: END IF;
1533: IF p_objfundsum_rec.plan_curr_paid_amt IS NULL THEN
1534: x_complete_rec.plan_curr_paid_amt := l_objfundsum_rec.plan_curr_paid_amt;

Line 1537: IF p_objfundsum_rec.univ_curr_planned_amt = Fnd_Api.G_MISS_NUM THEN

1533: IF p_objfundsum_rec.plan_curr_paid_amt IS NULL THEN
1534: x_complete_rec.plan_curr_paid_amt := l_objfundsum_rec.plan_curr_paid_amt;
1535: END IF;
1536:
1537: IF p_objfundsum_rec.univ_curr_planned_amt = Fnd_Api.G_MISS_NUM THEN
1538: x_complete_rec.univ_curr_planned_amt := NULL;
1539: END IF;
1540: IF p_objfundsum_rec.univ_curr_planned_amt IS NULL THEN
1541: x_complete_rec.univ_curr_planned_amt := l_objfundsum_rec.univ_curr_planned_amt;

Line 1544: IF p_objfundsum_rec.univ_curr_committed_amt = Fnd_Api.G_MISS_NUM THEN

1540: IF p_objfundsum_rec.univ_curr_planned_amt IS NULL THEN
1541: x_complete_rec.univ_curr_planned_amt := l_objfundsum_rec.univ_curr_planned_amt;
1542: END IF;
1543:
1544: IF p_objfundsum_rec.univ_curr_committed_amt = Fnd_Api.G_MISS_NUM THEN
1545: x_complete_rec.univ_curr_committed_amt := NULL;
1546: END IF;
1547: IF p_objfundsum_rec.univ_curr_committed_amt IS NULL THEN
1548: x_complete_rec.univ_curr_committed_amt := l_objfundsum_rec.univ_curr_committed_amt;

Line 1551: IF p_objfundsum_rec.univ_curr_recal_committed_amt = Fnd_Api.G_MISS_NUM THEN

1547: IF p_objfundsum_rec.univ_curr_committed_amt IS NULL THEN
1548: x_complete_rec.univ_curr_committed_amt := l_objfundsum_rec.univ_curr_committed_amt;
1549: END IF;
1550:
1551: IF p_objfundsum_rec.univ_curr_recal_committed_amt = Fnd_Api.G_MISS_NUM THEN
1552: x_complete_rec.univ_curr_recal_committed_amt := NULL;
1553: END IF;
1554: IF p_objfundsum_rec.univ_curr_recal_committed_amt IS NULL THEN
1555: x_complete_rec.univ_curr_recal_committed_amt := l_objfundsum_rec.univ_curr_recal_committed_amt;

Line 1558: IF p_objfundsum_rec.univ_curr_utilized_amt = Fnd_Api.G_MISS_NUM THEN

1554: IF p_objfundsum_rec.univ_curr_recal_committed_amt IS NULL THEN
1555: x_complete_rec.univ_curr_recal_committed_amt := l_objfundsum_rec.univ_curr_recal_committed_amt;
1556: END IF;
1557:
1558: IF p_objfundsum_rec.univ_curr_utilized_amt = Fnd_Api.G_MISS_NUM THEN
1559: x_complete_rec.univ_curr_utilized_amt := NULL;
1560: END IF;
1561: IF p_objfundsum_rec.univ_curr_utilized_amt IS NULL THEN
1562: x_complete_rec.univ_curr_utilized_amt := l_objfundsum_rec.univ_curr_utilized_amt;

Line 1565: IF p_objfundsum_rec.univ_curr_earned_amt = Fnd_Api.G_MISS_NUM THEN

1561: IF p_objfundsum_rec.univ_curr_utilized_amt IS NULL THEN
1562: x_complete_rec.univ_curr_utilized_amt := l_objfundsum_rec.univ_curr_utilized_amt;
1563: END IF;
1564:
1565: IF p_objfundsum_rec.univ_curr_earned_amt = Fnd_Api.G_MISS_NUM THEN
1566: x_complete_rec.univ_curr_earned_amt := NULL;
1567: END IF;
1568: IF p_objfundsum_rec.univ_curr_earned_amt IS NULL THEN
1569: x_complete_rec.univ_curr_earned_amt := l_objfundsum_rec.univ_curr_earned_amt;

Line 1572: IF p_objfundsum_rec.univ_curr_paid_amt = Fnd_Api.G_MISS_NUM THEN

1568: IF p_objfundsum_rec.univ_curr_earned_amt IS NULL THEN
1569: x_complete_rec.univ_curr_earned_amt := l_objfundsum_rec.univ_curr_earned_amt;
1570: END IF;
1571:
1572: IF p_objfundsum_rec.univ_curr_paid_amt = Fnd_Api.G_MISS_NUM THEN
1573: x_complete_rec.univ_curr_paid_amt := NULL;
1574: END IF;
1575: IF p_objfundsum_rec.univ_curr_paid_amt IS NULL THEN
1576: x_complete_rec.univ_curr_paid_amt := l_objfundsum_rec.univ_curr_paid_amt;

Line 1580: IF p_objfundsum_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN

1576: x_complete_rec.univ_curr_paid_amt := l_objfundsum_rec.univ_curr_paid_amt;
1577: END IF;
1578:
1579:
1580: IF p_objfundsum_rec.attribute_category = Fnd_Api.G_MISS_CHAR THEN
1581: x_complete_rec.attribute_category := NULL;
1582: END IF;
1583: IF p_objfundsum_rec.attribute_category IS NULL THEN
1584: x_complete_rec.attribute_category := l_objfundsum_rec.attribute_category;

Line 1587: IF p_objfundsum_rec.attribute1 = Fnd_Api.G_MISS_CHAR THEN

1583: IF p_objfundsum_rec.attribute_category IS NULL THEN
1584: x_complete_rec.attribute_category := l_objfundsum_rec.attribute_category;
1585: END IF;
1586:
1587: IF p_objfundsum_rec.attribute1 = Fnd_Api.G_MISS_CHAR THEN
1588: x_complete_rec.attribute1 := NULL;
1589: END IF;
1590: IF p_objfundsum_rec.attribute1 IS NULL THEN
1591: x_complete_rec.attribute1 := l_objfundsum_rec.attribute1;

Line 1594: IF p_objfundsum_rec.attribute2 = Fnd_Api.G_MISS_CHAR THEN

1590: IF p_objfundsum_rec.attribute1 IS NULL THEN
1591: x_complete_rec.attribute1 := l_objfundsum_rec.attribute1;
1592: END IF;
1593:
1594: IF p_objfundsum_rec.attribute2 = Fnd_Api.G_MISS_CHAR THEN
1595: x_complete_rec.attribute2 := NULL;
1596: END IF;
1597: IF p_objfundsum_rec.attribute2 IS NULL THEN
1598: x_complete_rec.attribute2 := l_objfundsum_rec.attribute2;

Line 1601: IF p_objfundsum_rec.attribute3 = Fnd_Api.G_MISS_CHAR THEN

1597: IF p_objfundsum_rec.attribute2 IS NULL THEN
1598: x_complete_rec.attribute2 := l_objfundsum_rec.attribute2;
1599: END IF;
1600:
1601: IF p_objfundsum_rec.attribute3 = Fnd_Api.G_MISS_CHAR THEN
1602: x_complete_rec.attribute3 := NULL;
1603: END IF;
1604: IF p_objfundsum_rec.attribute3 IS NULL THEN
1605: x_complete_rec.attribute3 := l_objfundsum_rec.attribute3;

Line 1608: IF p_objfundsum_rec.attribute4 = Fnd_Api.G_MISS_CHAR THEN

1604: IF p_objfundsum_rec.attribute3 IS NULL THEN
1605: x_complete_rec.attribute3 := l_objfundsum_rec.attribute3;
1606: END IF;
1607:
1608: IF p_objfundsum_rec.attribute4 = Fnd_Api.G_MISS_CHAR THEN
1609: x_complete_rec.attribute4 := NULL;
1610: END IF;
1611: IF p_objfundsum_rec.attribute4 IS NULL THEN
1612: x_complete_rec.attribute4 := l_objfundsum_rec.attribute4;

Line 1615: IF p_objfundsum_rec.attribute5 = Fnd_Api.G_MISS_CHAR THEN

1611: IF p_objfundsum_rec.attribute4 IS NULL THEN
1612: x_complete_rec.attribute4 := l_objfundsum_rec.attribute4;
1613: END IF;
1614:
1615: IF p_objfundsum_rec.attribute5 = Fnd_Api.G_MISS_CHAR THEN
1616: x_complete_rec.attribute5 := NULL;
1617: END IF;
1618: IF p_objfundsum_rec.attribute5 IS NULL THEN
1619: x_complete_rec.attribute5 := l_objfundsum_rec.attribute5;

Line 1622: IF p_objfundsum_rec.attribute6 = Fnd_Api.G_MISS_CHAR THEN

1618: IF p_objfundsum_rec.attribute5 IS NULL THEN
1619: x_complete_rec.attribute5 := l_objfundsum_rec.attribute5;
1620: END IF;
1621:
1622: IF p_objfundsum_rec.attribute6 = Fnd_Api.G_MISS_CHAR THEN
1623: x_complete_rec.attribute6 := NULL;
1624: END IF;
1625: IF p_objfundsum_rec.attribute6 IS NULL THEN
1626: x_complete_rec.attribute6 := l_objfundsum_rec.attribute6;

Line 1629: IF p_objfundsum_rec.attribute7 = Fnd_Api.G_MISS_CHAR THEN

1625: IF p_objfundsum_rec.attribute6 IS NULL THEN
1626: x_complete_rec.attribute6 := l_objfundsum_rec.attribute6;
1627: END IF;
1628:
1629: IF p_objfundsum_rec.attribute7 = Fnd_Api.G_MISS_CHAR THEN
1630: x_complete_rec.attribute7 := NULL;
1631: END IF;
1632: IF p_objfundsum_rec.attribute7 IS NULL THEN
1633: x_complete_rec.attribute7 := l_objfundsum_rec.attribute7;

Line 1636: IF p_objfundsum_rec.attribute8 = Fnd_Api.G_MISS_CHAR THEN

1632: IF p_objfundsum_rec.attribute7 IS NULL THEN
1633: x_complete_rec.attribute7 := l_objfundsum_rec.attribute7;
1634: END IF;
1635:
1636: IF p_objfundsum_rec.attribute8 = Fnd_Api.G_MISS_CHAR THEN
1637: x_complete_rec.attribute8 := NULL;
1638: END IF;
1639: IF p_objfundsum_rec.attribute8 IS NULL THEN
1640: x_complete_rec.attribute8 := l_objfundsum_rec.attribute8;

Line 1643: IF p_objfundsum_rec.attribute9 = Fnd_Api.G_MISS_CHAR THEN

1639: IF p_objfundsum_rec.attribute8 IS NULL THEN
1640: x_complete_rec.attribute8 := l_objfundsum_rec.attribute8;
1641: END IF;
1642:
1643: IF p_objfundsum_rec.attribute9 = Fnd_Api.G_MISS_CHAR THEN
1644: x_complete_rec.attribute9 := NULL;
1645: END IF;
1646: IF p_objfundsum_rec.attribute9 IS NULL THEN
1647: x_complete_rec.attribute9 := l_objfundsum_rec.attribute9;

Line 1650: IF p_objfundsum_rec.attribute10 = Fnd_Api.G_MISS_CHAR THEN

1646: IF p_objfundsum_rec.attribute9 IS NULL THEN
1647: x_complete_rec.attribute9 := l_objfundsum_rec.attribute9;
1648: END IF;
1649:
1650: IF p_objfundsum_rec.attribute10 = Fnd_Api.G_MISS_CHAR THEN
1651: x_complete_rec.attribute10 := NULL;
1652: END IF;
1653: IF p_objfundsum_rec.attribute10 IS NULL THEN
1654: x_complete_rec.attribute10 := l_objfundsum_rec.attribute10;

Line 1657: IF p_objfundsum_rec.attribute11 = Fnd_Api.G_MISS_CHAR THEN

1653: IF p_objfundsum_rec.attribute10 IS NULL THEN
1654: x_complete_rec.attribute10 := l_objfundsum_rec.attribute10;
1655: END IF;
1656:
1657: IF p_objfundsum_rec.attribute11 = Fnd_Api.G_MISS_CHAR THEN
1658: x_complete_rec.attribute11 := NULL;
1659: END IF;
1660: IF p_objfundsum_rec.attribute11 IS NULL THEN
1661: x_complete_rec.attribute11 := l_objfundsum_rec.attribute11;

Line 1664: IF p_objfundsum_rec.attribute12 = Fnd_Api.G_MISS_CHAR THEN

1660: IF p_objfundsum_rec.attribute11 IS NULL THEN
1661: x_complete_rec.attribute11 := l_objfundsum_rec.attribute11;
1662: END IF;
1663:
1664: IF p_objfundsum_rec.attribute12 = Fnd_Api.G_MISS_CHAR THEN
1665: x_complete_rec.attribute12 := NULL;
1666: END IF;
1667: IF p_objfundsum_rec.attribute12 IS NULL THEN
1668: x_complete_rec.attribute12 := l_objfundsum_rec.attribute12;

Line 1671: IF p_objfundsum_rec.attribute13 = Fnd_Api.G_MISS_CHAR THEN

1667: IF p_objfundsum_rec.attribute12 IS NULL THEN
1668: x_complete_rec.attribute12 := l_objfundsum_rec.attribute12;
1669: END IF;
1670:
1671: IF p_objfundsum_rec.attribute13 = Fnd_Api.G_MISS_CHAR THEN
1672: x_complete_rec.attribute13 := NULL;
1673: END IF;
1674: IF p_objfundsum_rec.attribute13 IS NULL THEN
1675: x_complete_rec.attribute13 := l_objfundsum_rec.attribute13;

Line 1678: IF p_objfundsum_rec.attribute14 = Fnd_Api.G_MISS_CHAR THEN

1674: IF p_objfundsum_rec.attribute13 IS NULL THEN
1675: x_complete_rec.attribute13 := l_objfundsum_rec.attribute13;
1676: END IF;
1677:
1678: IF p_objfundsum_rec.attribute14 = Fnd_Api.G_MISS_CHAR THEN
1679: x_complete_rec.attribute14 := NULL;
1680: END IF;
1681: IF p_objfundsum_rec.attribute14 IS NULL THEN
1682: x_complete_rec.attribute14 := l_objfundsum_rec.attribute14;

Line 1685: IF p_objfundsum_rec.attribute15 = Fnd_Api.G_MISS_CHAR THEN

1681: IF p_objfundsum_rec.attribute14 IS NULL THEN
1682: x_complete_rec.attribute14 := l_objfundsum_rec.attribute14;
1683: END IF;
1684:
1685: IF p_objfundsum_rec.attribute15 = Fnd_Api.G_MISS_CHAR THEN
1686: x_complete_rec.attribute15 := NULL;
1687: END IF;
1688: IF p_objfundsum_rec.attribute15 IS NULL THEN
1689: x_complete_rec.attribute15 := l_objfundsum_rec.attribute15;