APPS.AMS_EVHRULES_PVT dependencies on FND_API

Line 83: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN

79: LOOP
80: FETCH c_ev_schedule
81: INTO l_event_offer_id, l_obj_version, l_status_code, l_obj_type;
82: EXIT WHEN c_ev_schedule%NOTFOUND ;
83: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN
84: -- Can cancel the event offer
85: UPDATE ams_event_offers_all_b
86: SET system_status_code = 'COMPLETED',
87: last_status_date = SYSDATE,

Line 103: RAISE FND_API.g_exc_error;

99:
100: IF (SQL%NOTFOUND) THEN
101: CLOSE c_ev_schedule ;
102: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
103: RAISE FND_API.g_exc_error;
104: END IF;
105:
106: AMS_EvhRules_PVT.process_leads(p_event_id => l_event_offer_id);
107:

Line 111: RAISE FND_API.g_exc_error;

107:
108: ELSE -- Can not cancel the schedule as the status is can not go to cancel from current status
109: CLOSE c_ev_schedule;
110: AMS_Utility_PVT.Error_Message('AMS_EVEH_CANNOT_COMPLETE');
111: RAISE FND_API.g_exc_error;
112: END IF ;
113:
114: END LOOP;
115: CLOSE c_ev_schedule;

Line 134: x_return_status := FND_API.g_ret_sts_success;

130: FROM ams_user_statuses_vl
131: WHERE user_status_id = p_user_status_id
132: AND system_status_type = 'AMS_EVENT_STATUS';
133: BEGIN
134: x_return_status := FND_API.g_ret_sts_success;
135: OPEN e_status_code;
136: FETCH e_status_code INTO l_status_code;
137: CLOSE e_status_code;
138: IF l_status_code IS NULL THEN

Line 139: x_return_status := FND_API.g_ret_sts_error;

135: OPEN e_status_code;
136: FETCH e_status_code INTO l_status_code;
137: CLOSE e_status_code;
138: IF l_status_code IS NULL THEN
139: x_return_status := FND_API.g_ret_sts_error;
140: AMS_Utility_PVT.error_message('AMS_EVH_NO_USER_STATUS');
141: END IF;
142: x_status_code := l_status_code;
143: END handle_evh_status;

Line 174: x_return_status := FND_API.g_ret_sts_success;

170: l_dummy NUMBER;
171: l_evh_rec c_evh%ROWTYPE;
172:
173: BEGIN
174: x_return_status := FND_API.g_ret_sts_success;
175:
176: OPEN c_evh;
177: FETCH c_evh INTO l_evh_rec;
178: IF c_evh%NOTFOUND THEN

Line 184: RAISE FND_API.g_exc_error;

180: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
181: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
182: FND_MSG_PUB.add;
183: END IF;
184: RAISE FND_API.g_exc_error;
185: END IF;
186: CLOSE c_evh;
187:
188: ---------------------------- status codes-----------------------

Line 197: IF p_evh_rec.user_status_id <> FND_API.g_miss_num

193: -- Commented the old style of approval process call.
194: -- gdeodhar : Oct 06, 2000.
195: /*
196: if p_evh_rec.event_level = 'MAIN' then
197: IF p_evh_rec.user_status_id <> FND_API.g_miss_num
198: AND p_evh_rec.user_status_id <> l_evh_rec.user_status_id
199: THEN
200: AMS_WFCmpApr_PVT.StartProcess(
201: p_approval_for => 'EVEH',

Line 212: IF p_evh_rec.event_header_name <> FND_API.g_miss_char

208: END IF;
209:
210: -- the following will be locked after theme approval
211: IF l_evh_rec.system_status_code <> 'NEW' THEN
212: IF p_evh_rec.event_header_name <> FND_API.g_miss_char
213: AND p_evh_rec.event_header_name <> l_evh_rec.event_header_name
214: THEN
215: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_EVH_NAME');
216: x_return_status := FND_API.g_ret_sts_error;

Line 216: x_return_status := FND_API.g_ret_sts_error;

212: IF p_evh_rec.event_header_name <> FND_API.g_miss_char
213: AND p_evh_rec.event_header_name <> l_evh_rec.event_header_name
214: THEN
215: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_EVH_NAME');
216: x_return_status := FND_API.g_ret_sts_error;
217: RETURN;
218: END IF;
219: IF p_evh_rec.active_from_date <> FND_API.g_miss_date
220: AND p_evh_rec.active_from_date <>

Line 219: IF p_evh_rec.active_from_date <> FND_API.g_miss_date

215: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_EVH_NAME');
216: x_return_status := FND_API.g_ret_sts_error;
217: RETURN;
218: END IF;
219: IF p_evh_rec.active_from_date <> FND_API.g_miss_date
220: AND p_evh_rec.active_from_date <>
221: l_evh_rec.active_from_date
222: THEN
223: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_START_DATE');

Line 224: x_return_status := FND_API.g_ret_sts_error;

220: AND p_evh_rec.active_from_date <>
221: l_evh_rec.active_from_date
222: THEN
223: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_START_DATE');
224: x_return_status := FND_API.g_ret_sts_error;
225: RETURN;
226: END IF;
227: IF p_evh_rec.active_to_date <> FND_API.g_miss_date
228: AND p_evh_rec.active_to_date <>

Line 227: IF p_evh_rec.active_to_date <> FND_API.g_miss_date

223: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_START_DATE');
224: x_return_status := FND_API.g_ret_sts_error;
225: RETURN;
226: END IF;
227: IF p_evh_rec.active_to_date <> FND_API.g_miss_date
228: AND p_evh_rec.active_to_date <>
229: l_evh_rec.active_to_date
230: THEN
231: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_END_DATE');

Line 232: x_return_status := FND_API.g_ret_sts_error;

228: AND p_evh_rec.active_to_date <>
229: l_evh_rec.active_to_date
230: THEN
231: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_END_DATE');
232: x_return_status := FND_API.g_ret_sts_error;
233: RETURN;
234: END IF;
235: END IF;
236: end if; -- event_level MAIN

Line 250: IF p_evh_rec.source_code <> FND_API.g_miss_char

246: -- modified sugupta 07/20/2000
247: --NOT NEEDED FOR EVENT AGENDAS
248: /* commented OUT NOCOPY by murali on july17 2001
249: IF p_evh_rec.event_level = 'MAIN' THEN
250: IF p_evh_rec.source_code <> FND_API.g_miss_char
251: AND p_evh_rec.source_code <> l_evh_rec.source_code
252: THEN
253: IF p_evh_rec.source_code IS NULL THEN
254: AMS_Utility_PVT.error_message('AMS_EVH_NO_SOURCE_CODE');

Line 255: x_return_status := FND_API.g_ret_sts_error;

251: AND p_evh_rec.source_code <> l_evh_rec.source_code
252: THEN
253: IF p_evh_rec.source_code IS NULL THEN
254: AMS_Utility_PVT.error_message('AMS_EVH_NO_SOURCE_CODE');
255: x_return_status := FND_API.g_ret_sts_error;
256: RETURN;
257: END IF;
258:
259: -- source_code cannot be changed if status is not NEW

Line 262: x_return_status := FND_API.g_ret_sts_error;

258:
259: -- source_code cannot be changed if status is not NEW
260: IF l_evh_rec.system_status_code <> 'NEW' THEN
261: AMS_Utility_PVT.error_message('AMS_EVH_UPDATE_SOURCE_CODE');
262: x_return_status := FND_API.g_ret_sts_error;
263: RETURN;
264: END IF;
265:
266: -- check if the new source code is unique

Line 274: x_return_status := FND_API.g_ret_sts_error;

270: CLOSE c_source_code;
271:
272: IF l_dummy IS NOT NULL THEN
273: AMS_Utility_PVT.error_message('AMS_EVH_DUPE_SOURCE');
274: x_return_status := FND_API.g_ret_sts_error;
275: RETURN;
276: END IF;
277:
278: -- otherwise revoke the old one and add the new one to ams_source_codes

Line 281: p_init_msg_list => FND_API.g_false,

277:
278: -- otherwise revoke the old one and add the new one to ams_source_codes
279: AMS_SourceCode_PVT.revoke_sourcecode(
280: p_api_version => 1.0,
281: p_init_msg_list => FND_API.g_false,
282: p_commit => FND_API.g_false,
283: p_validation_level => FND_API.g_valid_level_full,
284:
285: x_return_status => x_return_status,

Line 282: p_commit => FND_API.g_false,

278: -- otherwise revoke the old one and add the new one to ams_source_codes
279: AMS_SourceCode_PVT.revoke_sourcecode(
280: p_api_version => 1.0,
281: p_init_msg_list => FND_API.g_false,
282: p_commit => FND_API.g_false,
283: p_validation_level => FND_API.g_valid_level_full,
284:
285: x_return_status => x_return_status,
286: x_msg_count => l_msg_count,

Line 283: p_validation_level => FND_API.g_valid_level_full,

279: AMS_SourceCode_PVT.revoke_sourcecode(
280: p_api_version => 1.0,
281: p_init_msg_list => FND_API.g_false,
282: p_commit => FND_API.g_false,
283: p_validation_level => FND_API.g_valid_level_full,
284:
285: x_return_status => x_return_status,
286: x_msg_count => l_msg_count,
287: x_msg_data => l_msg_data,

Line 292: IF x_return_status <> FND_API.g_ret_sts_success THEN

288:
289: p_sourcecode => p_evh_rec.source_code
290: );
291:
292: IF x_return_status <> FND_API.g_ret_sts_success THEN
293: RAISE FND_API.g_exc_error;
294: END IF;
295:
296: AMS_SourceCode_PVT.create_sourcecode(

Line 293: RAISE FND_API.g_exc_error;

289: p_sourcecode => p_evh_rec.source_code
290: );
291:
292: IF x_return_status <> FND_API.g_ret_sts_success THEN
293: RAISE FND_API.g_exc_error;
294: END IF;
295:
296: AMS_SourceCode_PVT.create_sourcecode(
297: p_api_version => 1.0,

Line 298: p_init_msg_list => FND_API.g_false,

294: END IF;
295:
296: AMS_SourceCode_PVT.create_sourcecode(
297: p_api_version => 1.0,
298: p_init_msg_list => FND_API.g_false,
299: p_commit => FND_API.g_false,
300: p_validation_level => FND_API.g_valid_level_full,
301:
302: x_return_status => x_return_status,

Line 299: p_commit => FND_API.g_false,

295:
296: AMS_SourceCode_PVT.create_sourcecode(
297: p_api_version => 1.0,
298: p_init_msg_list => FND_API.g_false,
299: p_commit => FND_API.g_false,
300: p_validation_level => FND_API.g_valid_level_full,
301:
302: x_return_status => x_return_status,
303: x_msg_count => l_msg_count,

Line 300: p_validation_level => FND_API.g_valid_level_full,

296: AMS_SourceCode_PVT.create_sourcecode(
297: p_api_version => 1.0,
298: p_init_msg_list => FND_API.g_false,
299: p_commit => FND_API.g_false,
300: p_validation_level => FND_API.g_valid_level_full,
301:
302: x_return_status => x_return_status,
303: x_msg_count => l_msg_count,
304: x_msg_data => l_msg_data,

Line 312: IF x_return_status <> FND_API.g_ret_sts_success THEN

308: p_sourcecode_for_id => p_evh_rec.event_header_id,
309: x_sourcecode_id => l_dummy
310: );
311:
312: IF x_return_status <> FND_API.g_ret_sts_success THEN
313: RAISE FND_API.g_exc_error;
314: END IF;
315:
316: END IF; -- p_evh_rec.source_code

Line 313: RAISE FND_API.g_exc_error;

309: x_sourcecode_id => l_dummy
310: );
311:
312: IF x_return_status <> FND_API.g_ret_sts_success THEN
313: RAISE FND_API.g_exc_error;
314: END IF;
315:
316: END IF; -- p_evh_rec.source_code
317: END IF; -- p_evh_rec.event_level

Line 351: x_return_status := FND_API.g_ret_sts_success;

347: SELECT 1
348: FROM ams_event_offers_vl
349: WHERE event_offer_id = p_fund_source_id;
350: BEGIN
351: x_return_status := FND_API.g_ret_sts_success;
352: IF p_fund_source_type IS NULL AND p_fund_source_id IS NULL THEN
353: RETURN;
354: ELSIF p_fund_source_type IS NULL AND p_fund_source_id IS NOT NULL THEN
355: AMS_Utility_PVT.error_message('AMS_EVH_NO_FUND_SOURCE_TYPE');

Line 365: x_return_status := FND_API.g_ret_sts_error;

361: IF p_fund_source_id IS NOT NULL THEN
362: OPEN c_camp;
363: FETCH c_camp INTO l_dummy;
364: IF c_camp%NOTFOUND THEN
365: x_return_status := FND_API.g_ret_sts_error;
366: AMS_Utility_PVT.error_message('AMS_EVH_BAD_FUND_SOURCE_CAMP');
367: END IF;
368: CLOSE c_camp;
369: END IF;

Line 375: x_return_status := FND_API.g_ret_sts_error;

371: IF p_fund_source_id IS NOT NULL THEN
372: OPEN c_eveh;
373: FETCH c_eveh INTO l_dummy;
374: IF c_eveh%NOTFOUND THEN
375: x_return_status := FND_API.g_ret_sts_error;
376: AMS_Utility_PVT.error_message('AMS_EVH_BAD_FUND_SOURCE_EVEH');
377: END IF;
378: CLOSE c_eveh;
379: END IF;

Line 385: x_return_status := FND_API.g_ret_sts_error;

381: IF p_fund_source_id IS NOT NULL THEN
382: OPEN c_eveo;
383: FETCH c_eveo INTO l_dummy;
384: IF c_eveo%NOTFOUND THEN
385: x_return_status := FND_API.g_ret_sts_error;
386: AMS_Utility_PVT.error_message('AMS_EVH_BAD_FUND_SOURCE_EVEO');
387: END IF;
388: CLOSE c_eveo;
389: END IF;

Line 395: x_return_status := FND_API.g_ret_sts_error;

391: IF p_fund_source_id IS NOT NULL THEN
392: OPEN c_eone;
393: FETCH c_eone INTO l_dummy;
394: IF c_eone%NOTFOUND THEN
395: x_return_status := FND_API.g_ret_sts_error;
396: AMS_Utility_PVT.error_message('AMS_EVH_BAD_FUND_SOURCE_EVEO');
397: END IF;
398: CLOSE c_eone;
399: END IF;

Line 401: x_return_status := FND_API.g_ret_sts_error;

397: END IF;
398: CLOSE c_eone;
399: END IF;
400: ELSE
401: x_return_status := FND_API.g_ret_sts_error;
402: AMS_Utility_PVT.error_message('AMS_EVH_BAD_FUND_SOURCE');
403: END IF;
404: END check_evh_fund_source;
405: ---------------------------------------------------------------------

Line 451: x_return_status := FND_API.g_ret_sts_success;

447: AND period_name = p_end_period_name;
448:
449: BEGIN
450:
451: x_return_status := FND_API.g_ret_sts_success;
452:
453: -- check if p_evh_calendar is null
454: IF p_evh_calendar IS NULL
455: AND p_start_period_name IS NULL

Line 460: x_return_status := FND_API.g_ret_sts_error;

456: AND p_end_period_name IS NULL
457: THEN
458: RETURN;
459: ELSIF p_evh_calendar IS NULL THEN
460: x_return_status := FND_API.g_ret_sts_error;
461: AMS_Utility_PVT.error_message('AMS_EVH_NO_EVENT_CALENDAR');
462: RETURN;
463: END IF;
464:

Line 471: x_return_status := FND_API.g_ret_sts_error;

467: FETCH c_evh_calendar INTO l_dummy;
468: CLOSE c_evh_calendar;
469:
470: IF l_dummy IS NULL THEN
471: x_return_status := FND_API.g_ret_sts_error;
472: AMS_Utility_PVT.error_message('AMS_EVH_BAD_EVENT_CALENDAR');
473: RETURN;
474: END IF;
475:

Line 483: x_return_status := FND_API.g_ret_sts_error;

479: FETCH c_start_period INTO l_start_start, l_start_end;
480: CLOSE c_start_period;
481:
482: IF l_start_start IS NULL THEN
483: x_return_status := FND_API.g_ret_sts_error;
484: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_START_PERIOD'); -- resusing CAMP message
485: RETURN;
486: ELSIF p_start_date < l_start_start OR p_start_date > l_start_end THEN
487: x_return_status := FND_API.g_ret_sts_error;

Line 487: x_return_status := FND_API.g_ret_sts_error;

483: x_return_status := FND_API.g_ret_sts_error;
484: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_START_PERIOD'); -- resusing CAMP message
485: RETURN;
486: ELSIF p_start_date < l_start_start OR p_start_date > l_start_end THEN
487: x_return_status := FND_API.g_ret_sts_error;
488: AMS_Utility_PVT.error_message('AMS_EVH_OUT_START_PERIOD');
489: RETURN;
490: END IF;
491: END IF;

Line 500: x_return_status := FND_API.g_ret_sts_error;

496: FETCH c_end_period INTO l_end_start, l_end_end;
497: CLOSE c_end_period;
498:
499: IF l_end_end IS NULL THEN
500: x_return_status := FND_API.g_ret_sts_error;
501: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_END_PERIOD'); --resuing CAMP message
502: RETURN;
503: ELSIF p_end_date < l_end_start OR p_end_date > l_end_end THEN
504: x_return_status := FND_API.g_ret_sts_error;

Line 504: x_return_status := FND_API.g_ret_sts_error;

500: x_return_status := FND_API.g_ret_sts_error;
501: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_END_PERIOD'); --resuing CAMP message
502: RETURN;
503: ELSIF p_end_date < l_end_start OR p_end_date > l_end_end THEN
504: x_return_status := FND_API.g_ret_sts_error;
505: AMS_Utility_PVT.error_message('AMS_EVH_OUT_END_PERIOD');
506: RETURN;
507: END IF;
508: END IF;

Line 512: x_return_status := FND_API.g_ret_sts_error;

508: END IF;
509:
510: -- compare the start date and the end date
511: IF l_start_start > l_end_end THEN
512: x_return_status := FND_API.g_ret_sts_error;
513: AMS_Utility_PVT.error_message('AMS_CAMP_BAD_PERIODS');--resuing CAMP message
514: END IF;
515:
516: END check_evh_calendar;

Line 615: x_return_status := FND_API.g_ret_sts_success;

611: */
612: BEGIN
613:
614: x_source_code := p_source_code;
615: x_return_status := FND_API.g_ret_sts_success;
616:
617: OPEN c_old_info;
618: FETCH c_old_info INTO l_global_flag, l_source_code;
619: CLOSE c_old_info;

Line 640: x_return_status := FND_API.g_ret_sts_error;

636: END IF;
637:
638: IF x_source_code IS NULL THEN
639: AMS_Utility_PVT.error_message('AMS_EVO_NO_SOURCE_CODE');
640: x_return_status := FND_API.g_ret_sts_error;
641: RETURN;
642: END IF;
643:
644: -- check if the new source code is unique

Line 651: x_return_status := FND_API.g_ret_sts_error;

647: CLOSE c_source_code;
648:
649: IF l_source_code_id IS NOT NULL THEN
650: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE'); --reuse message
651: x_return_status := FND_API.g_ret_sts_error;
652: RETURN;
653: END IF;
654:
655: -- otherwise revoke the old one and add the new one to ams_source_codes

Line 658: p_init_msg_list => FND_API.g_false,

654:
655: -- otherwise revoke the old one and add the new one to ams_source_codes
656: AMS_SourceCode_PVT.revoke_sourcecode(
657: p_api_version => 1.0,
658: p_init_msg_list => FND_API.g_false,
659: p_commit => FND_API.g_false,
660: p_validation_level => FND_API.g_valid_level_full,
661:
662: x_return_status => x_return_status,

Line 659: p_commit => FND_API.g_false,

655: -- otherwise revoke the old one and add the new one to ams_source_codes
656: AMS_SourceCode_PVT.revoke_sourcecode(
657: p_api_version => 1.0,
658: p_init_msg_list => FND_API.g_false,
659: p_commit => FND_API.g_false,
660: p_validation_level => FND_API.g_valid_level_full,
661:
662: x_return_status => x_return_status,
663: x_msg_count => l_msg_count,

Line 660: p_validation_level => FND_API.g_valid_level_full,

656: AMS_SourceCode_PVT.revoke_sourcecode(
657: p_api_version => 1.0,
658: p_init_msg_list => FND_API.g_false,
659: p_commit => FND_API.g_false,
660: p_validation_level => FND_API.g_valid_level_full,
661:
662: x_return_status => x_return_status,
663: x_msg_count => l_msg_count,
664: x_msg_data => l_msg_data,

Line 669: IF x_return_status <> FND_API.g_ret_sts_success THEN

665:
666: p_sourcecode => l_source_code
667: );
668:
669: IF x_return_status <> FND_API.g_ret_sts_success THEN
670: RAISE FND_API.g_exc_error;
671: END IF;
672:
673: AMS_SourceCode_PVT.create_sourcecode(

Line 670: RAISE FND_API.g_exc_error;

666: p_sourcecode => l_source_code
667: );
668:
669: IF x_return_status <> FND_API.g_ret_sts_success THEN
670: RAISE FND_API.g_exc_error;
671: END IF;
672:
673: AMS_SourceCode_PVT.create_sourcecode(
674: p_api_version => 1.0,

Line 675: p_init_msg_list => FND_API.g_false,

671: END IF;
672:
673: AMS_SourceCode_PVT.create_sourcecode(
674: p_api_version => 1.0,
675: p_init_msg_list => FND_API.g_false,
676: p_commit => FND_API.g_false,
677: p_validation_level => FND_API.g_valid_level_full,
678: x_return_status => x_return_status,
679: x_msg_count => l_msg_count,

Line 676: p_commit => FND_API.g_false,

672:
673: AMS_SourceCode_PVT.create_sourcecode(
674: p_api_version => 1.0,
675: p_init_msg_list => FND_API.g_false,
676: p_commit => FND_API.g_false,
677: p_validation_level => FND_API.g_valid_level_full,
678: x_return_status => x_return_status,
679: x_msg_count => l_msg_count,
680: x_msg_data => l_msg_data,

Line 677: p_validation_level => FND_API.g_valid_level_full,

673: AMS_SourceCode_PVT.create_sourcecode(
674: p_api_version => 1.0,
675: p_init_msg_list => FND_API.g_false,
676: p_commit => FND_API.g_false,
677: p_validation_level => FND_API.g_valid_level_full,
678: x_return_status => x_return_status,
679: x_msg_count => l_msg_count,
680: x_msg_data => l_msg_data,
681:

Line 687: IF x_return_status <> FND_API.g_ret_sts_success THEN

683: p_sourcecode_for => 'EVEH',
684: p_sourcecode_for_id => p_evh_id,
685: x_sourcecode_id => l_source_code_id
686: );
687: IF x_return_status <> FND_API.g_ret_sts_success THEN
688: RAISE FND_API.g_exc_error;
689: END IF;
690:
691: END update_evh_source_code;

Line 688: RAISE FND_API.g_exc_error;

684: p_sourcecode_for_id => p_evh_id,
685: x_sourcecode_id => l_source_code_id
686: );
687: IF x_return_status <> FND_API.g_ret_sts_success THEN
688: RAISE FND_API.g_exc_error;
689: END IF;
690:
691: END update_evh_source_code;
692:

Line 742: x_return_status := FND_API.g_ret_sts_success;

738: */
739: BEGIN
740:
741: x_source_code := p_source_code;
742: x_return_status := FND_API.g_ret_sts_success;
743:
744: OPEN c_old_info;
745: FETCH c_old_info INTO l_global_flag, l_source_code;
746: CLOSE c_old_info;

Line 768: x_return_status := FND_API.g_ret_sts_error;

764: END IF;
765:
766: IF x_source_code IS NULL THEN
767: AMS_Utility_PVT.error_message('AMS_EVO_NO_SOURCE_CODE');
768: x_return_status := FND_API.g_ret_sts_error;
769: RETURN;
770: END IF;
771:
772: -- check if the new source code is unique

Line 779: x_return_status := FND_API.g_ret_sts_error;

775: CLOSE c_source_code;
776:
777: IF l_source_code_id IS NOT NULL THEN
778: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE'); --reuse message
779: x_return_status := FND_API.g_ret_sts_error;
780: RETURN;
781: END IF;
782:
783: -- otherwise revoke the old one and add the new one to ams_source_codes

Line 786: p_init_msg_list => FND_API.g_false,

782:
783: -- otherwise revoke the old one and add the new one to ams_source_codes
784: AMS_SourceCode_PVT.revoke_sourcecode(
785: p_api_version => 1.0,
786: p_init_msg_list => FND_API.g_false,
787: p_commit => FND_API.g_false,
788: p_validation_level => FND_API.g_valid_level_full,
789:
790: x_return_status => x_return_status,

Line 787: p_commit => FND_API.g_false,

783: -- otherwise revoke the old one and add the new one to ams_source_codes
784: AMS_SourceCode_PVT.revoke_sourcecode(
785: p_api_version => 1.0,
786: p_init_msg_list => FND_API.g_false,
787: p_commit => FND_API.g_false,
788: p_validation_level => FND_API.g_valid_level_full,
789:
790: x_return_status => x_return_status,
791: x_msg_count => l_msg_count,

Line 788: p_validation_level => FND_API.g_valid_level_full,

784: AMS_SourceCode_PVT.revoke_sourcecode(
785: p_api_version => 1.0,
786: p_init_msg_list => FND_API.g_false,
787: p_commit => FND_API.g_false,
788: p_validation_level => FND_API.g_valid_level_full,
789:
790: x_return_status => x_return_status,
791: x_msg_count => l_msg_count,
792: x_msg_data => l_msg_data,

Line 797: IF x_return_status <> FND_API.g_ret_sts_success THEN

793:
794: p_sourcecode => l_source_code
795: );
796:
797: IF x_return_status <> FND_API.g_ret_sts_success THEN
798: RAISE FND_API.g_exc_error;
799: END IF;
800:
801: AMS_SourceCode_PVT.create_sourcecode(

Line 798: RAISE FND_API.g_exc_error;

794: p_sourcecode => l_source_code
795: );
796:
797: IF x_return_status <> FND_API.g_ret_sts_success THEN
798: RAISE FND_API.g_exc_error;
799: END IF;
800:
801: AMS_SourceCode_PVT.create_sourcecode(
802: p_api_version => 1.0,

Line 803: p_init_msg_list => FND_API.g_false,

799: END IF;
800:
801: AMS_SourceCode_PVT.create_sourcecode(
802: p_api_version => 1.0,
803: p_init_msg_list => FND_API.g_false,
804: p_commit => FND_API.g_false,
805: p_validation_level => FND_API.g_valid_level_full,
806:
807: x_return_status => x_return_status,

Line 804: p_commit => FND_API.g_false,

800:
801: AMS_SourceCode_PVT.create_sourcecode(
802: p_api_version => 1.0,
803: p_init_msg_list => FND_API.g_false,
804: p_commit => FND_API.g_false,
805: p_validation_level => FND_API.g_valid_level_full,
806:
807: x_return_status => x_return_status,
808: x_msg_count => l_msg_count,

Line 805: p_validation_level => FND_API.g_valid_level_full,

801: AMS_SourceCode_PVT.create_sourcecode(
802: p_api_version => 1.0,
803: p_init_msg_list => FND_API.g_false,
804: p_commit => FND_API.g_false,
805: p_validation_level => FND_API.g_valid_level_full,
806:
807: x_return_status => x_return_status,
808: x_msg_count => l_msg_count,
809: x_msg_data => l_msg_data,

Line 817: IF x_return_status <> FND_API.g_ret_sts_success THEN

813: p_sourcecode_for_id => p_evo_id,
814: x_sourcecode_id => l_source_code_id
815: );
816:
817: IF x_return_status <> FND_API.g_ret_sts_success THEN
818: RAISE FND_API.g_exc_error;
819: END IF;
820:
821: END update_evo_source_code;

Line 818: RAISE FND_API.g_exc_error;

814: x_sourcecode_id => l_source_code_id
815: );
816:
817: IF x_return_status <> FND_API.g_ret_sts_success THEN
818: RAISE FND_API.g_exc_error;
819: END IF;
820:
821: END update_evo_source_code;
822:

Line 872: x_return_status := FND_API.g_ret_sts_success;

868: */
869: BEGIN
870:
871: x_source_code := p_source_code;
872: x_return_status := FND_API.g_ret_sts_success;
873:
874: OPEN c_old_info;
875: FETCH c_old_info INTO l_global_flag, l_source_code;
876: CLOSE c_old_info;

Line 898: x_return_status := FND_API.g_ret_sts_error;

894: END IF;
895:
896: IF x_source_code IS NULL THEN
897: AMS_Utility_PVT.error_message('AMS_EVO_NO_SOURCE_CODE');
898: x_return_status := FND_API.g_ret_sts_error;
899: RETURN;
900: END IF;
901:
902: -- check if the new source code is unique

Line 909: x_return_status := FND_API.g_ret_sts_error;

905: CLOSE c_source_code;
906:
907: IF l_source_code_id IS NOT NULL THEN
908: AMS_Utility_PVT.error_message('AMS_CAMP_DUPLICATE_CODE'); --reuse message
909: x_return_status := FND_API.g_ret_sts_error;
910: RETURN;
911: END IF;
912:
913: -- otherwise revoke the old one and add the new one to ams_source_codes

Line 916: p_init_msg_list => FND_API.g_false,

912:
913: -- otherwise revoke the old one and add the new one to ams_source_codes
914: AMS_SourceCode_PVT.revoke_sourcecode(
915: p_api_version => 1.0,
916: p_init_msg_list => FND_API.g_false,
917: p_commit => FND_API.g_false,
918: p_validation_level => FND_API.g_valid_level_full,
919:
920: x_return_status => x_return_status,

Line 917: p_commit => FND_API.g_false,

913: -- otherwise revoke the old one and add the new one to ams_source_codes
914: AMS_SourceCode_PVT.revoke_sourcecode(
915: p_api_version => 1.0,
916: p_init_msg_list => FND_API.g_false,
917: p_commit => FND_API.g_false,
918: p_validation_level => FND_API.g_valid_level_full,
919:
920: x_return_status => x_return_status,
921: x_msg_count => l_msg_count,

Line 918: p_validation_level => FND_API.g_valid_level_full,

914: AMS_SourceCode_PVT.revoke_sourcecode(
915: p_api_version => 1.0,
916: p_init_msg_list => FND_API.g_false,
917: p_commit => FND_API.g_false,
918: p_validation_level => FND_API.g_valid_level_full,
919:
920: x_return_status => x_return_status,
921: x_msg_count => l_msg_count,
922: x_msg_data => l_msg_data,

Line 927: IF x_return_status <> FND_API.g_ret_sts_success THEN

923:
924: p_sourcecode => l_source_code
925: );
926:
927: IF x_return_status <> FND_API.g_ret_sts_success THEN
928: RAISE FND_API.g_exc_error;
929: END IF;
930:
931: AMS_SourceCode_PVT.create_sourcecode(

Line 928: RAISE FND_API.g_exc_error;

924: p_sourcecode => l_source_code
925: );
926:
927: IF x_return_status <> FND_API.g_ret_sts_success THEN
928: RAISE FND_API.g_exc_error;
929: END IF;
930:
931: AMS_SourceCode_PVT.create_sourcecode(
932: p_api_version => 1.0,

Line 933: p_init_msg_list => FND_API.g_false,

929: END IF;
930:
931: AMS_SourceCode_PVT.create_sourcecode(
932: p_api_version => 1.0,
933: p_init_msg_list => FND_API.g_false,
934: p_commit => FND_API.g_false,
935: p_validation_level => FND_API.g_valid_level_full,
936:
937: x_return_status => x_return_status,

Line 934: p_commit => FND_API.g_false,

930:
931: AMS_SourceCode_PVT.create_sourcecode(
932: p_api_version => 1.0,
933: p_init_msg_list => FND_API.g_false,
934: p_commit => FND_API.g_false,
935: p_validation_level => FND_API.g_valid_level_full,
936:
937: x_return_status => x_return_status,
938: x_msg_count => l_msg_count,

Line 935: p_validation_level => FND_API.g_valid_level_full,

931: AMS_SourceCode_PVT.create_sourcecode(
932: p_api_version => 1.0,
933: p_init_msg_list => FND_API.g_false,
934: p_commit => FND_API.g_false,
935: p_validation_level => FND_API.g_valid_level_full,
936:
937: x_return_status => x_return_status,
938: x_msg_count => l_msg_count,
939: x_msg_data => l_msg_data,

Line 947: IF x_return_status <> FND_API.g_ret_sts_success THEN

943: p_sourcecode_for_id => p_evo_id,
944: x_sourcecode_id => l_source_code_id
945: );
946:
947: IF x_return_status <> FND_API.g_ret_sts_success THEN
948: RAISE FND_API.g_exc_error;
949: END IF;
950:
951: END update_eone_source_code;

Line 948: RAISE FND_API.g_exc_error;

944: x_sourcecode_id => l_source_code_id
945: );
946:
947: IF x_return_status <> FND_API.g_ret_sts_success THEN
948: RAISE FND_API.g_exc_error;
949: END IF;
950:
951: END update_eone_source_code;
952:

Line 1051: RAISE FND_API.g_exc_error;

1047:
1048: If l_system_status_code = 'ACTIVE' and l_parent_system_status_code <> 'ACTIVE'THEN
1049: FND_MESSAGE.set_name('AMS', 'AMS_PROGRAM_NOT_ACTIVE');
1050: FND_MSG_PUB.add;
1051: RAISE FND_API.g_exc_error;
1052: END IF;
1053:
1054: ELSIF p_event_activity_type ='EVEO' THEN
1055:

Line 1076: RAISE FND_API.g_exc_error;

1072: If l_system_status_code = 'ACTIVE' and l_parent_system_status_code <> 'ACTIVE'THEN
1073: -- changed 'AMS_EVENT_NOT ACTIVE' to 'AMS_EVENT_NOT_ACTIVE'
1074: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_NOT_ACTIVE');
1075: FND_MSG_PUB.add;
1076: RAISE FND_API.g_exc_error;
1077: END IF;
1078:
1079: ELSIF p_event_activity_type ='EONE' THEN
1080:

Line 1100: RAISE FND_API.g_exc_error;

1096:
1097: If l_system_status_code = 'ACTIVE' and l_parent_system_status_code <> 'ACTIVE'THEN
1098: FND_MESSAGE.set_name('AMS', 'AMS_PROGRAM_NOT_ACTIVE');
1099: FND_MSG_PUB.add;
1100: RAISE FND_API.g_exc_error;
1101: END IF;
1102:
1103: END IF;
1104:

Line 1131: IF l_return_status <> FND_API.g_ret_sts_success THEN

1127: x_approval_type => l_approval_type,
1128: x_return_status => l_return_status
1129: );
1130:
1131: IF l_return_status <> FND_API.g_ret_sts_success THEN
1132: RAISE FND_API.g_exc_error;
1133: END IF;
1134:
1135: IF l_approval_type = 'BUDGET' THEN

Line 1132: RAISE FND_API.g_exc_error;

1128: x_return_status => l_return_status
1129: );
1130:
1131: IF l_return_status <> FND_API.g_ret_sts_success THEN
1132: RAISE FND_API.g_exc_error;
1133: END IF;
1134:
1135: IF l_approval_type = 'BUDGET' THEN
1136: /* commented on oct 30 to support zero budget approval

Line 1146: AND p_fund_amount_tc <> FND_API.g_miss_num

1142:
1143: -- Also check if budget amount has been specified.
1144: IF p_fund_amount_tc IS NOT NULL
1145: AND p_currency_code_tc IS NOT NULL
1146: AND p_fund_amount_tc <> FND_API.g_miss_num
1147: AND p_currency_code_tc <> FND_API.g_miss_char
1148: THEN
1149: */
1150: l_new_status_id := AMS_Utility_PVT.get_default_user_status(

Line 1147: AND p_currency_code_tc <> FND_API.g_miss_char

1143: -- Also check if budget amount has been specified.
1144: IF p_fund_amount_tc IS NOT NULL
1145: AND p_currency_code_tc IS NOT NULL
1146: AND p_fund_amount_tc <> FND_API.g_miss_num
1147: AND p_currency_code_tc <> FND_API.g_miss_char
1148: THEN
1149: */
1150: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
1151: 'AMS_EVENT_STATUS',

Line 1174: RAISE FND_API.g_exc_error;

1170: );
1171: /* ELSE
1172: AMS_Utility_PVT.error_message('AMS_EVE_NO_BGT_AMT');
1173: -- Please Specify the Budget Amount Before seeking Approval! Error.
1174: RAISE FND_API.g_exc_error;
1175: END IF;
1176: ELSE
1177: AMS_Utility_PVT.error_message('AMS_EVE_NO_BGT_SRC');
1178: -- Please Specify Budget Source Before seeking Approval! Error.

Line 1179: RAISE FND_API.g_exc_error;

1175: END IF;
1176: ELSE
1177: AMS_Utility_PVT.error_message('AMS_EVE_NO_BGT_SRC');
1178: -- Please Specify Budget Source Before seeking Approval! Error.
1179: RAISE FND_API.g_exc_error;
1180: END IF;
1181: */
1182: ELSIF l_approval_type = 'THEME' THEN
1183: l_new_status_id := AMS_Utility_PVT.get_default_user_status(

Line 1212: p_init_msg_list => FND_API.G_FALSE

1208: If l_system_status_code = 'ACTIVE'
1209: THEN
1210: --anchaudh: changed call from ams_budgetapproval_pvt to ozf_budget_approval_pvt: bug#3453430
1211: OZF_BudgetApproval_PVT.budget_request_approval(
1212: p_init_msg_list => FND_API.G_FALSE
1213: , p_api_version => 1.0
1214: , p_commit => FND_API.G_False
1215: , x_return_status => l_return_status
1216: , x_msg_count => l_msg_count

Line 1214: , p_commit => FND_API.G_False

1210: --anchaudh: changed call from ams_budgetapproval_pvt to ozf_budget_approval_pvt: bug#3453430
1211: OZF_BudgetApproval_PVT.budget_request_approval(
1212: p_init_msg_list => FND_API.G_FALSE
1213: , p_api_version => 1.0
1214: , p_commit => FND_API.G_False
1215: , x_return_status => l_return_status
1216: , x_msg_count => l_msg_count
1217: , x_msg_data => l_msg_data
1218: , p_object_type => p_event_activity_type

Line 1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1219: , p_object_id => p_event_id
1220: -- , x_status_code =>
1221: );
1222:
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;

Line 1224: RAISE FND_API.G_EXC_ERROR;

1220: -- , x_status_code =>
1221: );
1222:
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;

Line 1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1221: );
1222:
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;
1229: l_new_status_id := p_user_status_id;

Line 1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1222:
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.G_EXC_ERROR;
1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;
1229: l_new_status_id := p_user_status_id;
1230: END IF;

Line 1638: RAISE FND_API.g_exc_unexpected_error;

1634: p_msg_type => 'DEBUG'
1635: );
1636:
1637: IF l_request_id = 0 THEN
1638: RAISE FND_API.g_exc_unexpected_error;
1639: --Change the above to raise a specific error later.
1640: END IF;
1641:
1642: -- Import completed successfully

Line 1792: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1788: p_from_amount => p_tc_amt,
1789: x_to_amount => x_fc_amt
1790: );
1791:
1792: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1793: RAISE FND_API.g_exc_error;
1794: END IF;
1795:
1796: x_fc_curr := l_curr_code ;

Line 1793: RAISE FND_API.g_exc_error;

1789: x_to_amount => x_fc_amt
1790: );
1791:
1792: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1793: RAISE FND_API.g_exc_error;
1794: END IF;
1795:
1796: x_fc_curr := l_curr_code ;
1797:

Line 1887: p_init_msg_list => FND_API.g_false,

1883: BEGIN
1884:
1885: AMS_SourceCode_PVT.create_sourcecode(
1886: p_api_version => 1.0,
1887: p_init_msg_list => FND_API.g_false,
1888: p_commit => FND_API.g_false,
1889: p_validation_level => FND_API.g_valid_level_full,
1890:
1891: x_return_status => l_return_status,

Line 1888: p_commit => FND_API.g_false,

1884:
1885: AMS_SourceCode_PVT.create_sourcecode(
1886: p_api_version => 1.0,
1887: p_init_msg_list => FND_API.g_false,
1888: p_commit => FND_API.g_false,
1889: p_validation_level => FND_API.g_valid_level_full,
1890:
1891: x_return_status => l_return_status,
1892: x_msg_count => l_msg_count,

Line 1889: p_validation_level => FND_API.g_valid_level_full,

1885: AMS_SourceCode_PVT.create_sourcecode(
1886: p_api_version => 1.0,
1887: p_init_msg_list => FND_API.g_false,
1888: p_commit => FND_API.g_false,
1889: p_validation_level => FND_API.g_valid_level_full,
1890:
1891: x_return_status => l_return_status,
1892: x_msg_count => l_msg_count,
1893: x_msg_data => l_msg_data,

Line 1904: IF l_return_status <> FND_API.g_ret_sts_success THEN

1900: p_related_sourceid => p_related_source_id,
1901: x_sourcecode_id => l_sourcecode_id
1902: );
1903:
1904: IF l_return_status <> FND_API.g_ret_sts_success THEN
1905: RAISE FND_API.g_exc_error;
1906: END IF;
1907:
1908: END push_source_code;

Line 1905: RAISE FND_API.g_exc_error;

1901: x_sourcecode_id => l_sourcecode_id
1902: );
1903:
1904: IF l_return_status <> FND_API.g_ret_sts_success THEN
1905: RAISE FND_API.g_exc_error;
1906: END IF;
1907:
1908: END push_source_code;
1909: --========================================================================

Line 1964: p_init_msg_list => FND_API.g_false,

1960: l_list_header_rec.list_source_type := 'PERSON_LIST' ;
1961: l_list_header_rec.owner_user_id := p_owner_id;
1962: AMS_ListHeader_PVT.Create_Listheader
1963: ( p_api_version => 1.0,
1964: p_init_msg_list => FND_API.g_false,
1965: p_commit => FND_API.g_false,
1966: p_validation_level => FND_API.g_valid_level_full,
1967:
1968: x_return_status => l_return_status,

Line 1965: p_commit => FND_API.g_false,

1961: l_list_header_rec.owner_user_id := p_owner_id;
1962: AMS_ListHeader_PVT.Create_Listheader
1963: ( p_api_version => 1.0,
1964: p_init_msg_list => FND_API.g_false,
1965: p_commit => FND_API.g_false,
1966: p_validation_level => FND_API.g_valid_level_full,
1967:
1968: x_return_status => l_return_status,
1969: x_msg_count => l_msg_count,

Line 1966: p_validation_level => FND_API.g_valid_level_full,

1962: AMS_ListHeader_PVT.Create_Listheader
1963: ( p_api_version => 1.0,
1964: p_init_msg_list => FND_API.g_false,
1965: p_commit => FND_API.g_false,
1966: p_validation_level => FND_API.g_valid_level_full,
1967:
1968: x_return_status => l_return_status,
1969: x_msg_count => l_msg_count,
1970: x_msg_data => l_msg_data,

Line 1975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1971: p_listheader_rec => l_list_header_rec,
1972: x_listheader_id => l_list_header_id
1973: );
1974:
1975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1976: RAISE FND_API.G_EXC_ERROR;
1977: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1979: END IF;

Line 1976: RAISE FND_API.G_EXC_ERROR;

1972: x_listheader_id => l_list_header_id
1973: );
1974:
1975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1976: RAISE FND_API.G_EXC_ERROR;
1977: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1979: END IF;
1980:

Line 1977: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1973: );
1974:
1975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1976: RAISE FND_API.G_EXC_ERROR;
1977: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1979: END IF;
1980:
1981: l_act_list_rec.list_header_id := l_list_header_id;

Line 1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1974:
1975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1976: RAISE FND_API.G_EXC_ERROR;
1977: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1979: END IF;
1980:
1981: l_act_list_rec.list_header_id := l_list_header_id;
1982: l_act_list_rec.list_used_by := p_obj_type;

Line 1988: p_init_msg_list => FND_API.g_false,

1984: l_act_list_rec.list_act_type := 'TARGET';
1985:
1986: AMS_Act_List_PVT.Create_Act_List(
1987: p_api_version_number => 1.0,
1988: p_init_msg_list => FND_API.g_false,
1989: p_commit => FND_API.g_false,
1990: p_validation_level => FND_API.g_valid_level_full,
1991: x_return_status => l_return_status,
1992: x_msg_count => l_msg_count,

Line 1989: p_commit => FND_API.g_false,

1985:
1986: AMS_Act_List_PVT.Create_Act_List(
1987: p_api_version_number => 1.0,
1988: p_init_msg_list => FND_API.g_false,
1989: p_commit => FND_API.g_false,
1990: p_validation_level => FND_API.g_valid_level_full,
1991: x_return_status => l_return_status,
1992: x_msg_count => l_msg_count,
1993: x_msg_data => l_msg_data,

Line 1990: p_validation_level => FND_API.g_valid_level_full,

1986: AMS_Act_List_PVT.Create_Act_List(
1987: p_api_version_number => 1.0,
1988: p_init_msg_list => FND_API.g_false,
1989: p_commit => FND_API.g_false,
1990: p_validation_level => FND_API.g_valid_level_full,
1991: x_return_status => l_return_status,
1992: x_msg_count => l_msg_count,
1993: x_msg_data => l_msg_data,
1994: p_act_list_rec => l_act_list_rec ,

Line 1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1994: p_act_list_rec => l_act_list_rec ,
1995: x_act_list_header_id => l_act_list_header_id
1996: ) ;
1997:
1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF;

Line 1999: RAISE FND_API.G_EXC_ERROR;

1995: x_act_list_header_id => l_act_list_header_id
1996: ) ;
1997:
1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF;
2003: */

Line 2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1996: ) ;
1997:
1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF;
2003: */
2004: END Create_list;

Line 2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1997:
1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF;
2003: */
2004: END Create_list;
2005:

Line 2039: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN

2035: OPEN c_evh ;
2036: LOOP
2037: FETCH c_evh INTO l_event_header_id,l_obj_version,l_status_code ;
2038: EXIT WHEN c_evh%NOTFOUND ;
2039: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN
2040: -- Can cancel the schedule
2041: UPDATE ams_event_headers_all_b
2042: SET system_status_code = 'CANCELLED',
2043: last_status_date = SYSDATE,

Line 2052: RAISE FND_API.g_exc_error;

2048:
2049: IF (SQL%NOTFOUND) THEN
2050: CLOSE c_evh ;
2051: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
2052: RAISE FND_API.g_exc_error;
2053: END IF;
2054: ELSE -- Can not cancel the schedule as the status is can not go to cancel from current status
2055: CLOSE c_evh;
2056: AMS_Utility_PVT.Error_Message('AMS_EVH_CANNOT_CANCEL');

Line 2057: RAISE FND_API.g_exc_error;

2053: END IF;
2054: ELSE -- Can not cancel the schedule as the status is can not go to cancel from current status
2055: CLOSE c_evh;
2056: AMS_Utility_PVT.Error_Message('AMS_EVH_CANNOT_CANCEL');
2057: RAISE FND_API.g_exc_error;
2058: END IF ;
2059:
2060: END LOOP;
2061: CLOSE c_evh;

Line 2101: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN

2097: OPEN c_evo_list ;
2098: LOOP
2099: FETCH c_evo_list INTO l_event_offer_id,l_obj_version,l_status_code,l_obj_type ; -- modified as per enh # 3805347
2100: EXIT WHEN c_evo_list%NOTFOUND ;
2101: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN
2102: -- Can cancel the schedule
2103: UPDATE ams_event_offers_all_b
2104: SET system_status_code = 'CANCELLED',
2105: last_status_date = SYSDATE,

Line 2121: RAISE FND_API.g_exc_error;

2117:
2118: IF (SQL%NOTFOUND) THEN
2119: CLOSE c_evo_list ;
2120: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
2121: RAISE FND_API.g_exc_error;
2122: END IF;
2123: ELSE -- Can not cancel the schedule as the status is can not go to cancel from current status
2124: CLOSE c_evo_list;
2125: AMS_Utility_PVT.Error_Message('AMS_EVO_CANNOT_CANCEL');

Line 2126: RAISE FND_API.g_exc_error;

2122: END IF;
2123: ELSE -- Can not cancel the schedule as the status is can not go to cancel from current status
2124: CLOSE c_evo_list;
2125: AMS_Utility_PVT.Error_Message('AMS_EVO_CANNOT_CANCEL');
2126: RAISE FND_API.g_exc_error;
2127: END IF ;
2128:
2129: END LOOP;
2130: CLOSE c_evo_list;

Line 2170: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN

2166: OPEN c_evo_list ;
2167: LOOP
2168: FETCH c_evo_list INTO l_event_offer_id,l_obj_version,l_status_code, l_obj_type; -- Modified as per enh # 3805347
2169: EXIT WHEN c_evo_list%NOTFOUND ;
2170: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN
2171: -- Can cancel the schedule
2172: UPDATE ams_event_offers_all_b
2173: SET system_status_code = 'CANCELLED',
2174: last_status_date = SYSDATE,

Line 2190: RAISE FND_API.g_exc_error;

2186:
2187: IF (SQL%NOTFOUND) THEN
2188: CLOSE c_evo_list ;
2189: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
2190: RAISE FND_API.g_exc_error;
2191: END IF;
2192: ELSE -- Can not cancel the schedule as the status is can not go to cancel from current status
2193: CLOSE c_evo_list;
2194: AMS_Utility_PVT.Error_Message('AMS_EONE_CANNOT_CANCEL');

Line 2195: RAISE FND_API.g_exc_error;

2191: END IF;
2192: ELSE -- Can not cancel the schedule as the status is can not go to cancel from current status
2193: CLOSE c_evo_list;
2194: AMS_Utility_PVT.Error_Message('AMS_EONE_CANNOT_CANCEL');
2195: RAISE FND_API.g_exc_error;
2196: END IF ;
2197:
2198: END LOOP;
2199: CLOSE c_evo_list;

Line 2253: RETURN FND_API.g_false;

2249: CLOSE c_evo_list;
2250:
2251: IF(l_event_offers > 0 OR l_event_headers > 0)
2252: THEN
2253: RETURN FND_API.g_false;
2254: ELSE
2255: RETURN FND_API.g_true;
2256: END IF;
2257:

Line 2255: RETURN FND_API.g_true;

2251: IF(l_event_offers > 0 OR l_event_headers > 0)
2252: THEN
2253: RETURN FND_API.g_false;
2254: ELSE
2255: RETURN FND_API.g_true;
2256: END IF;
2257:
2258: END Cancel_all_event;
2259:

Line 2293: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN

2289: OPEN c_evh ;
2290: LOOP
2291: FETCH c_evh INTO l_event_header_id,l_obj_version,l_status_code ;
2292: EXIT WHEN c_evh%NOTFOUND ;
2293: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN
2294: -- Can complete the schedule
2295: UPDATE ams_event_headers_all_b
2296: SET system_status_code = 'COMPLETED',
2297: last_status_date = SYSDATE,

Line 2306: RAISE FND_API.g_exc_error;

2302:
2303: IF (SQL%NOTFOUND) THEN
2304: CLOSE c_evh ;
2305: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
2306: RAISE FND_API.g_exc_error;
2307: END IF;
2308: ELSE -- Can not complete the schedule as the status is can not go to complete from current status
2309: CLOSE c_evh;
2310: AMS_Utility_PVT.Error_Message('AMS_EVH_CANNOT_COMPLETE');

Line 2311: RAISE FND_API.g_exc_error;

2307: END IF;
2308: ELSE -- Can not complete the schedule as the status is can not go to complete from current status
2309: CLOSE c_evh;
2310: AMS_Utility_PVT.Error_Message('AMS_EVH_CANNOT_COMPLETE');
2311: RAISE FND_API.g_exc_error;
2312: END IF ;
2313:
2314: END LOOP;
2315: CLOSE c_evh;

Line 2354: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN

2350: OPEN c_evo_list ;
2351: LOOP
2352: FETCH c_evo_list INTO l_event_offer_id,l_obj_version,l_status_code, l_obj_type; -- Modified as per enh # 3805347.
2353: EXIT WHEN c_evo_list%NOTFOUND ;
2354: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN
2355: -- Can complete the schedule
2356: UPDATE ams_event_offers_all_b
2357: SET system_status_code = 'COMPLETED',
2358: last_status_date = SYSDATE,

Line 2374: RAISE FND_API.g_exc_error;

2370:
2371: IF (SQL%NOTFOUND) THEN
2372: CLOSE c_evo_list ;
2373: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
2374: RAISE FND_API.g_exc_error;
2375: END IF;
2376: ELSE -- Can not complete the schedule as the status is can not go to complete from current status
2377: CLOSE c_evo_list;
2378: AMS_Utility_PVT.Error_Message('AMS_EVO_CANNOT_COMPLETE');

Line 2379: RAISE FND_API.g_exc_error;

2375: END IF;
2376: ELSE -- Can not complete the schedule as the status is can not go to complete from current status
2377: CLOSE c_evo_list;
2378: AMS_Utility_PVT.Error_Message('AMS_EVO_CANNOT_COMPLETE');
2379: RAISE FND_API.g_exc_error;
2380: END IF ;
2381:
2382: END LOOP;
2383: CLOSE c_evo_list;

Line 2422: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN

2418: OPEN c_evo_list ;
2419: LOOP
2420: FETCH c_evo_list INTO l_event_offer_id,l_obj_version,l_status_code, l_obj_type; -- Modified as per enh # 3805347
2421: EXIT WHEN c_evo_list%NOTFOUND ;
2422: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN
2423: -- Can complete the schedule
2424: UPDATE ams_event_offers_all_b
2425: SET system_status_code = 'COMPLETED',
2426: last_status_date = SYSDATE,

Line 2443: RAISE FND_API.g_exc_error;

2439:
2440: IF (SQL%NOTFOUND) THEN
2441: CLOSE c_evo_list ;
2442: AMS_Utility_PVT.Error_Message('AMS_API_RECORD_NOT_FOUND');
2443: RAISE FND_API.g_exc_error;
2444: END IF;
2445: ELSE -- Can not complete the schedule as the status is can not go to complete from current status
2446: CLOSE c_evo_list;
2447: AMS_Utility_PVT.Error_Message('AMS_EONE_CANNOT_COMPLETE');

Line 2448: RAISE FND_API.g_exc_error;

2444: END IF;
2445: ELSE -- Can not complete the schedule as the status is can not go to complete from current status
2446: CLOSE c_evo_list;
2447: AMS_Utility_PVT.Error_Message('AMS_EONE_CANNOT_COMPLETE');
2448: RAISE FND_API.g_exc_error;
2449: END IF ;
2450:
2451: END LOOP;
2452: CLOSE c_evo_list;

Line 2544: x_return_status := FND_API.G_RET_STS_SUCCESS;

2540: l_err_txt VARCHAR2(4000);
2541: inv_item_creation_error EXCEPTION;
2542:
2543: BEGIN
2544: x_return_status := FND_API.G_RET_STS_SUCCESS;
2545: l_org_id := FND_PROFILE.Value('AMS_ITEM_ORGANIZATION_ID');
2546: p_item_owner_rec.ORGANIZATION_ID := l_org_id;
2547: p_item_owner_rec.ITEM_NUMBER := p_item_number;
2548: p_item_owner_rec.OWNER_ID := p_user_id;

Line 2570: IF x_item_return_status <> FND_API.g_ret_sts_success THEN

2566: x_item_return_status => x_item_return_status,
2567: x_Error_tbl => Error_tbl
2568: );
2569:
2570: IF x_item_return_status <> FND_API.g_ret_sts_success THEN
2571: RAISE inv_item_creation_error;
2572: else
2573: IF x_return_status = FND_API.g_ret_sts_success THEN
2574: x_inv_item_id := Item_rec_out.INVENTORY_ITEM_ID;

Line 2573: IF x_return_status = FND_API.g_ret_sts_success THEN

2569:
2570: IF x_item_return_status <> FND_API.g_ret_sts_success THEN
2571: RAISE inv_item_creation_error;
2572: else
2573: IF x_return_status = FND_API.g_ret_sts_success THEN
2574: x_inv_item_id := Item_rec_out.INVENTORY_ITEM_ID;
2575: x_org_id := Item_rec_out.ORGANIZATION_ID;
2576: END IF;
2577:

Line 2589: p_encoded => FND_API.g_false,

2585: END LOOP;
2586: /*
2587: x_msg_data := l_err_txt;
2588: FND_MSG_PUB.count_and_get(
2589: p_encoded => FND_API.g_false,
2590: p_count => x_msg_count,
2591: p_data => x_msg_data
2592: );
2593: */

Line 2598: WHEN FND_API.g_exc_unexpected_error THEN

2594: FND_MESSAGE.set_name('INV', l_err_txt); -- error_tbl(i).message_name);
2595: FND_MSG_PUB.add;
2596: --END LOOP;
2597:
2598: WHEN FND_API.g_exc_unexpected_error THEN
2599: --x_return_status := FND_API.g_ret_sts_unexp_error ;
2600: x_msg_count := error_tbl.count;
2601: FOR i IN 1 .. error_tbl.count LOOP
2602: FND_MSG_PUB.count_and_get(

Line 2599: --x_return_status := FND_API.g_ret_sts_unexp_error ;

2595: FND_MSG_PUB.add;
2596: --END LOOP;
2597:
2598: WHEN FND_API.g_exc_unexpected_error THEN
2599: --x_return_status := FND_API.g_ret_sts_unexp_error ;
2600: x_msg_count := error_tbl.count;
2601: FOR i IN 1 .. error_tbl.count LOOP
2602: FND_MSG_PUB.count_and_get(
2603: p_encoded => FND_API.g_false,

Line 2603: p_encoded => FND_API.g_false,

2599: --x_return_status := FND_API.g_ret_sts_unexp_error ;
2600: x_msg_count := error_tbl.count;
2601: FOR i IN 1 .. error_tbl.count LOOP
2602: FND_MSG_PUB.count_and_get(
2603: p_encoded => FND_API.g_false,
2604: p_count => x_msg_count,
2605: p_data => error_tbl(i).message_text
2606: );
2607: END LOOP;

Line 2610: -- x_return_status := FND_API.g_ret_sts_unexp_error;

2606: );
2607: END LOOP;
2608:
2609: WHEN OTHERS THEN
2610: -- x_return_status := FND_API.g_ret_sts_unexp_error;
2611: x_msg_count := error_tbl.count;
2612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2613: THEN
2614: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 2619: p_encoded => FND_API.g_false,

2615: END IF;
2616:
2617: FOR i IN 1 .. error_tbl.count LOOP
2618: FND_MSG_PUB.count_and_get(
2619: p_encoded => FND_API.g_false,
2620: p_count => x_msg_count,
2621: -- p_data => x_msg_data
2622: p_data => error_tbl(i).message_text
2623: );

Line 2750: -- AND Fnd_Api.G_TRUE = Ams_Utility_Pvt.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED')

2746: FETCH c_header_status INTO l_status_code;
2747: CLOSE c_header_status;
2748:
2749: IF (l_numOfSchedules = 0
2750: -- AND Fnd_Api.G_TRUE = Ams_Utility_Pvt.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED')
2751: )
2752: THEN
2753:
2754: UPDATE ams_event_headers_all_b

Line 2764: RAISE FND_API.g_exc_error;

2760: ELSE
2761:
2762: FND_MESSAGE.set_name('AMS', 'AMS_EVH_CANNOT_CANCEL');
2763: FND_MSG_PUB.add;
2764: RAISE FND_API.g_exc_error;
2765:
2766: END IF;
2767:
2768: ELSE

Line 2841: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2837: -- 14-Jan-2001 gmadana Created.
2838: --=====================================================================
2839: PROCEDURE Update_Owner(
2840: p_api_version IN NUMBER,
2841: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2842: p_commit IN VARCHAR2 := FND_API.g_false,
2843: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2844: x_return_status OUT NOCOPY VARCHAR2,
2845: x_msg_count OUT NOCOPY NUMBER,

Line 2842: p_commit IN VARCHAR2 := FND_API.g_false,

2838: --=====================================================================
2839: PROCEDURE Update_Owner(
2840: p_api_version IN NUMBER,
2841: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2842: p_commit IN VARCHAR2 := FND_API.g_false,
2843: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2844: x_return_status OUT NOCOPY VARCHAR2,
2845: x_msg_count OUT NOCOPY NUMBER,
2846: x_msg_data OUT NOCOPY VARCHAR2,

Line 2843: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

2839: PROCEDURE Update_Owner(
2840: p_api_version IN NUMBER,
2841: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2842: p_commit IN VARCHAR2 := FND_API.g_false,
2843: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2844: x_return_status OUT NOCOPY VARCHAR2,
2845: x_msg_count OUT NOCOPY NUMBER,
2846: x_msg_data OUT NOCOPY VARCHAR2,
2847: p_object_type IN VARCHAR2 := NULL ,

Line 2872: RAISE FND_API.g_exc_error;

2868:
2869: IF c_header_owner%NOTFOUND THEN
2870: CLOSE c_header_owner;
2871: AMS_Utility_Pvt.Error_Message('AMS_API_RECORD_NOT_FOUND');
2872: RAISE FND_API.g_exc_error;
2873: ELSE
2874: CLOSE c_header_owner;
2875: END IF;
2876:

Line 2884: RAISE FND_API.g_exc_error;

2880:
2881: IF c_offer_owner%NOTFOUND THEN
2882: CLOSE c_offer_owner;
2883: AMS_Utility_Pvt.Error_Message('AMS_API_RECORD_NOT_FOUND');
2884: RAISE FND_API.g_exc_error;
2885: ELSE
2886: CLOSE c_offer_owner;
2887: END IF;
2888:

Line 2906: IF x_return_status = FND_API.g_ret_sts_error THEN

2902: p_resource_id => p_owner_id,
2903: p_old_resource_id => l_old_owner
2904: );
2905:
2906: IF x_return_status = FND_API.g_ret_sts_error THEN
2907: RAISE FND_API.g_exc_error;
2908: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2909: RAISE FND_API.g_exc_unexpected_error;
2910: END IF;

Line 2907: RAISE FND_API.g_exc_error;

2903: p_old_resource_id => l_old_owner
2904: );
2905:
2906: IF x_return_status = FND_API.g_ret_sts_error THEN
2907: RAISE FND_API.g_exc_error;
2908: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2909: RAISE FND_API.g_exc_unexpected_error;
2910: END IF;
2911:

Line 2908: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

2904: );
2905:
2906: IF x_return_status = FND_API.g_ret_sts_error THEN
2907: RAISE FND_API.g_exc_error;
2908: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2909: RAISE FND_API.g_exc_unexpected_error;
2910: END IF;
2911:
2912: END IF ;

Line 2909: RAISE FND_API.g_exc_unexpected_error;

2905:
2906: IF x_return_status = FND_API.g_ret_sts_error THEN
2907: RAISE FND_API.g_exc_error;
2908: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2909: RAISE FND_API.g_exc_unexpected_error;
2910: END IF;
2911:
2912: END IF ;
2913:

Line 3021: , p_init_msg_list => FND_API.g_false

3017:
3018:
3019: AMS_CT_RULE_PVT.check_content_rule(
3020: p_api_version => 1.0
3021: , p_init_msg_list => FND_API.g_false
3022: , p_commit => FND_API.g_false
3023: , p_object_type => l_object_type --p_object_type
3024: , p_object_id => l_object_id -- p_object_id
3025: , p_trigger_type => p_trigger_type

Line 3022: , p_commit => FND_API.g_false

3018:
3019: AMS_CT_RULE_PVT.check_content_rule(
3020: p_api_version => 1.0
3021: , p_init_msg_list => FND_API.g_false
3022: , p_commit => FND_API.g_false
3023: , p_object_type => l_object_type --p_object_type
3024: , p_object_id => l_object_id -- p_object_id
3025: , p_trigger_type => p_trigger_type
3026: -- , p_requestor_type => NULL

Line 3057: IF x_return_status = FND_API.g_ret_sts_error THEN

3053: IF (AMS_DEBUG_HIGH_ON) THEN
3054: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
3055: END IF;
3056:
3057: IF x_return_status = FND_API.g_ret_sts_error THEN
3058: RAISE FND_API.g_exc_error;
3059: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3060: RAISE FND_API.g_exc_unexpected_error;
3061: END IF;

Line 3058: RAISE FND_API.g_exc_error;

3054: AMS_Utility_PVT.debug_message('Request ID: ' || l_request_history_id);
3055: END IF;
3056:
3057: IF x_return_status = FND_API.g_ret_sts_error THEN
3058: RAISE FND_API.g_exc_error;
3059: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3060: RAISE FND_API.g_exc_unexpected_error;
3061: END IF;
3062:

Line 3059: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3055: END IF;
3056:
3057: IF x_return_status = FND_API.g_ret_sts_error THEN
3058: RAISE FND_API.g_exc_error;
3059: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3060: RAISE FND_API.g_exc_unexpected_error;
3061: END IF;
3062:
3063: END Send_Out_Information ;

Line 3060: RAISE FND_API.g_exc_unexpected_error;

3056:
3057: IF x_return_status = FND_API.g_ret_sts_error THEN
3058: RAISE FND_API.g_exc_error;
3059: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3060: RAISE FND_API.g_exc_unexpected_error;
3061: END IF;
3062:
3063: END Send_Out_Information ;
3064: