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

Line 27: RAISE FND_API.G_EXC_ERROR;

23: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
24: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
25: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);
26: IGS_GE_MSG_STACK.ADD;
27: RAISE FND_API.G_EXC_ERROR;
28: ELSIF l_col_length.column_type ='N' AND p_param_length > (l_col_length.precision - l_col_length.scale) THEN
29: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');
30: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
31: IF l_col_length.scale > 0 THEN

Line 37: RAISE FND_API.G_EXC_ERROR;

33: ELSE
34: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision );
35: END IF;
36: IGS_GE_MSG_STACK.ADD;
37: RAISE FND_API.G_EXC_ERROR;
38: END IF;
39: END check_length;
40:
41: --API

Line 45: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

41: --API
42: PROCEDURE PRE_CREATE_APPLICATION(
43: --Standard Parameters Start
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
46: p_commit IN VARCHAR2 default FND_API.G_FALSE,
47: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,

Line 46: p_commit IN VARCHAR2 default FND_API.G_FALSE,

42: PROCEDURE PRE_CREATE_APPLICATION(
43: --Standard Parameters Start
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
46: p_commit IN VARCHAR2 default FND_API.G_FALSE,
47: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,

Line 47: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

43: --Standard Parameters Start
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
46: p_commit IN VARCHAR2 default FND_API.G_FALSE,
47: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
51: --Standard parameter ends

Line 219: x_return_status := FND_API.G_RET_STS_SUCCESS;

215: l_message_name VARCHAR2(2000);
216:
217: BEGIN
218: SAVEPOINT PRE_CREATE_APPLICATION_pub;
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:
221: l_msg_index := 0;
222:
223: -- Standard call to check for call compatibility.

Line 224: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

220:
221: l_msg_index := 0;
222:
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 225: RAISE FND_API.G_EXC_ERROR;

221: l_msg_index := 0;
222:
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: -- Initialize message list if p_init_msg_list is set to TRUE.
229: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 229: IF FND_API.to_Boolean(p_init_msg_list) THEN

225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227:
228: -- Initialize message list if p_init_msg_list is set to TRUE.
229: IF FND_API.to_Boolean(p_init_msg_list) THEN
230: FND_MSG_PUB.initialize;
231: END IF;
232: l_msg_index := igs_ge_msg_stack.count_msg;
233:

Line 270: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN

266: ---------------------
267: --Intialization of variables to handle G_MISS_CHAR/NUM/DATE
268: ---------------------
269:
270: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN
271: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
272: IGS_GE_MSG_STACK.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: ELSE

Line 273: RAISE FND_API.G_EXC_ERROR;

269:
270: IF p_person_id = FND_API.G_MISS_NUM OR p_person_id IS NULL THEN
271: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
272: IGS_GE_MSG_STACK.ADD;
273: RAISE FND_API.G_EXC_ERROR;
274: ELSE
275: l_person_id := p_person_id;
276: END IF;
277:

Line 278: IF p_appl_date IS NULL OR p_appl_date = FND_API.G_MISS_DATE THEN

274: ELSE
275: l_person_id := p_person_id;
276: END IF;
277:
278: IF p_appl_date IS NULL OR p_appl_date = FND_API.G_MISS_DATE THEN
279: l_appl_date := SYSDATE;
280: ELSE
281: l_appl_date := p_appl_date;
282: END IF;

Line 284: IF p_acad_cal_type = FND_API.G_MISS_CHAR OR p_acad_cal_type IS NULL THEN

280: ELSE
281: l_appl_date := p_appl_date;
282: END IF;
283:
284: IF p_acad_cal_type = FND_API.G_MISS_CHAR OR p_acad_cal_type IS NULL THEN
285: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
286: IGS_GE_MSG_STACK.ADD;
287: RAISE FND_API.G_EXC_ERROR;
288: ELSE

Line 287: RAISE FND_API.G_EXC_ERROR;

283:
284: IF p_acad_cal_type = FND_API.G_MISS_CHAR OR p_acad_cal_type IS NULL THEN
285: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
286: IGS_GE_MSG_STACK.ADD;
287: RAISE FND_API.G_EXC_ERROR;
288: ELSE
289: l_acad_cal_type := p_acad_cal_type;
290: END IF;
291:

Line 292: IF p_acad_cal_seq_number = FND_API.G_MISS_NUM OR p_acad_cal_seq_number IS NULL THEN

288: ELSE
289: l_acad_cal_type := p_acad_cal_type;
290: END IF;
291:
292: IF p_acad_cal_seq_number = FND_API.G_MISS_NUM OR p_acad_cal_seq_number IS NULL THEN
293: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
294: IGS_GE_MSG_STACK.ADD;
295: RAISE FND_API.G_EXC_ERROR;
296: ELSE

Line 295: RAISE FND_API.G_EXC_ERROR;

291:
292: IF p_acad_cal_seq_number = FND_API.G_MISS_NUM OR p_acad_cal_seq_number IS NULL THEN
293: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
294: IGS_GE_MSG_STACK.ADD;
295: RAISE FND_API.G_EXC_ERROR;
296: ELSE
297: l_acad_cal_seq_number := p_acad_cal_seq_number;
298: END IF;
299:

Line 300: IF p_adm_cal_type = FND_API.G_MISS_CHAR OR p_adm_cal_type IS NULL THEN

296: ELSE
297: l_acad_cal_seq_number := p_acad_cal_seq_number;
298: END IF;
299:
300: IF p_adm_cal_type = FND_API.G_MISS_CHAR OR p_adm_cal_type IS NULL THEN
301: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
302: IGS_GE_MSG_STACK.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: ELSE

Line 303: RAISE FND_API.G_EXC_ERROR;

299:
300: IF p_adm_cal_type = FND_API.G_MISS_CHAR OR p_adm_cal_type IS NULL THEN
301: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
302: IGS_GE_MSG_STACK.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: ELSE
305: l_adm_cal_type := p_adm_cal_type;
306: END IF;
307:

Line 308: IF p_adm_cal_seq_number = FND_API.G_MISS_NUM OR p_adm_cal_seq_number IS NULL THEN

304: ELSE
305: l_adm_cal_type := p_adm_cal_type;
306: END IF;
307:
308: IF p_adm_cal_seq_number = FND_API.G_MISS_NUM OR p_adm_cal_seq_number IS NULL THEN
309: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
310: IGS_GE_MSG_STACK.ADD;
311: RAISE FND_API.G_EXC_ERROR;
312: ELSE

Line 311: RAISE FND_API.G_EXC_ERROR;

307:
308: IF p_adm_cal_seq_number = FND_API.G_MISS_NUM OR p_adm_cal_seq_number IS NULL THEN
309: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
310: IGS_GE_MSG_STACK.ADD;
311: RAISE FND_API.G_EXC_ERROR;
312: ELSE
313: l_adm_cal_seq_number :=p_adm_cal_seq_number ;
314: END IF;
315:

Line 317: IF p_entry_status = FND_API.G_MISS_NUM THEN

313: l_adm_cal_seq_number :=p_adm_cal_seq_number ;
314: END IF;
315:
316:
317: IF p_entry_status = FND_API.G_MISS_NUM THEN
318: l_entry_status := NULL;
319: ELSE
320: l_entry_status := p_entry_status;
321: END IF;

Line 323: IF p_entry_level = FND_API.G_MISS_NUM THEN

319: ELSE
320: l_entry_status := p_entry_status;
321: END IF;
322:
323: IF p_entry_level = FND_API.G_MISS_NUM THEN
324: l_entry_level := NULL;
325: ELSE
326: l_entry_level := p_entry_level;
327: END IF;

Line 329: IF p_spcl_gr1 = FND_API.G_MISS_NUM THEN

325: ELSE
326: l_entry_level := p_entry_level;
327: END IF;
328:
329: IF p_spcl_gr1 = FND_API.G_MISS_NUM THEN
330: l_spcl_gr1 := NULL;
331: ELSE
332: l_spcl_gr1 := p_spcl_gr1;
333: END IF;

Line 335: IF p_spcl_gr2 = FND_API.G_MISS_NUM THEN

331: ELSE
332: l_spcl_gr1 := p_spcl_gr1;
333: END IF;
334:
335: IF p_spcl_gr2 = FND_API.G_MISS_NUM THEN
336: l_spcl_gr2 := NULL;
337: ELSE
338: l_spcl_gr2 := p_spcl_gr2;
339: END IF;

Line 341: IF p_apply_for_finaid = FND_API.G_MISS_CHAR THEN

337: ELSE
338: l_spcl_gr2 := p_spcl_gr2;
339: END IF;
340:
341: IF p_apply_for_finaid = FND_API.G_MISS_CHAR THEN
342: l_apply_for_finaid := NULL;
343: ELSE
344: l_apply_for_finaid := p_apply_for_finaid;
345: END IF;

Line 347: IF p_finaid_apply_date = FND_API.G_MISS_DATE THEN

343: ELSE
344: l_apply_for_finaid := p_apply_for_finaid;
345: END IF;
346:
347: IF p_finaid_apply_date = FND_API.G_MISS_DATE THEN
348: l_finaid_apply_date := NULL;
349: ELSE
350: l_finaid_apply_date := p_finaid_apply_date;
351: END IF;

Line 353: IF p_admission_application_type = FND_API.G_MISS_CHAR OR p_admission_application_type IS NULL THEN

349: ELSE
350: l_finaid_apply_date := p_finaid_apply_date;
351: END IF;
352:
353: IF p_admission_application_type = FND_API.G_MISS_CHAR OR p_admission_application_type IS NULL THEN
354: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
355: IGS_GE_MSG_STACK.ADD;
356: RAISE FND_API.G_EXC_ERROR;
357: ELSE

Line 356: RAISE FND_API.G_EXC_ERROR;

352:
353: IF p_admission_application_type = FND_API.G_MISS_CHAR OR p_admission_application_type IS NULL THEN
354: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
355: IGS_GE_MSG_STACK.ADD;
356: RAISE FND_API.G_EXC_ERROR;
357: ELSE
358: l_admission_application_type := p_admission_application_type;
359: END IF;
360:

Line 361: IF p_apsource_id = FND_API.G_MISS_NUM OR p_apsource_id IS NULL THEN

357: ELSE
358: l_admission_application_type := p_admission_application_type;
359: END IF;
360:
361: IF p_apsource_id = FND_API.G_MISS_NUM OR p_apsource_id IS NULL THEN
362: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
363: IGS_GE_MSG_STACK.ADD;
364: RAISE FND_API.G_EXC_ERROR;
365: ELSE

Line 364: RAISE FND_API.G_EXC_ERROR;

360:
361: IF p_apsource_id = FND_API.G_MISS_NUM OR p_apsource_id IS NULL THEN
362: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');
363: IGS_GE_MSG_STACK.ADD;
364: RAISE FND_API.G_EXC_ERROR;
365: ELSE
366: l_apsource_id := p_apsource_id;
367: END IF;
368:

Line 369: IF p_application_fee_amount = FND_API.G_MISS_NUM OR p_application_fee_amount IS NULL THEN

365: ELSE
366: l_apsource_id := p_apsource_id;
367: END IF;
368:
369: IF p_application_fee_amount = FND_API.G_MISS_NUM OR p_application_fee_amount IS NULL THEN
370: l_application_fee_amount := 0;
371: ELSE
372: l_application_fee_amount := p_application_fee_amount;
373: END IF;

Line 385: RAISE FND_API.G_EXC_ERROR;

381:
382: IF l_application_fee_amount < 0 THEN
383: FND_MESSAGE.SET_NAME('IGS','IGS_AD_FEE_AMT_NON_NEGATIVE');
384: IGS_GE_MSG_STACK.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388:
389: -- Validate Person

Line 398: RAISE FND_API.G_EXC_ERROR;

394: IF l_person_rec IS NULL THEN
395: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
396: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'));
397: IGS_GE_MSG_STACK.ADD;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:
401: -- Validate Admission Calendar
402: OPEN c_cal(l_adm_cal_type,l_adm_cal_seq_number);

Line 410: RAISE FND_API.G_EXC_ERROR;

406: IF l_cal_rec.cal_type IS NULL THEN
407: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));
409: IGS_GE_MSG_STACK.ADD;
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:
413: -- derive Admission Calendar Description
414: l_description := l_cal_rec.description;

Line 426: RAISE FND_API.G_EXC_ERROR;

422: IF l_cal_rec.cal_type IS NULL THEN
423: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ACAD_CAL'));
425: IGS_GE_MSG_STACK.ADD;
426: RAISE FND_API.G_EXC_ERROR;
427: END IF;
428:
429: -- Validate Admission and Academic Calendar Relationship
430: OPEN c_cal_rel(l_adm_cal_type,l_adm_cal_seq_number,l_acad_cal_type,l_acad_cal_seq_number);

Line 437: RAISE FND_API.G_EXC_ERROR;

433:
434: IF l_cal_rel_rec IS NULL THEN
435: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ADMCAL_CHILD_ACACAL');
436: IGS_GE_MSG_STACK.ADD;
437: RAISE FND_API.G_EXC_ERROR;
438: END IF;
439:
440: -- Validate Entry Status
441: IF l_entry_status IS NOT NULL THEN

Line 450: RAISE FND_API.G_EXC_ERROR;

446: IF l_estatus_rec IS NULL THEN
447: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
448: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENTRY_STAT'));
449: IGS_GE_MSG_STACK.ADD;
450: RAISE FND_API.G_EXC_ERROR;
451: END IF;
452: END IF;
453:
454: -- Validate Entry Level

Line 464: RAISE FND_API.G_EXC_ERROR;

460: IF l_elevel_rec IS NULL THEN
461: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENTRY_LVL'));
463: IGS_GE_MSG_STACK.ADD;
464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466: END IF;
467:
468: -- Validate Special Group 1

Line 478: RAISE FND_API.G_EXC_ERROR;

474: IF l_spcl_grp1_rec IS NULL THEN
475: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_GRP1'));
477: IGS_GE_MSG_STACK.ADD;
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480: END IF;
481:
482: -- Validate Special Group 2

Line 492: RAISE FND_API.G_EXC_ERROR;

488: IF l_spcl_grp2_rec IS NULL THEN
489: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
490: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_GRP2'));
491: IGS_GE_MSG_STACK.ADD;
492: RAISE FND_API.G_EXC_ERROR;
493: END IF;
494: END IF;
495:
496: -- Validate Admission Application Type

Line 505: RAISE FND_API.G_EXC_ERROR;

501: IF l_apptype_rec.admission_application_type IS NULL THEN
502: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_APPL_TYPE'));
504: IGS_GE_MSG_STACK.ADD;
505: RAISE FND_API.G_EXC_ERROR;
506: END IF;
507:
508: -- Derive ADMISSION_CAT and S_ADM_PROCESS_TYPE
509: l_s_adm_process_type := l_apptype_rec.s_admission_process_type;

Line 520: RAISE FND_API.G_EXC_ERROR;

516:
517: IF l_apptype_admcal_rec IS NULL THEN
518: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_APP_TYPE');
519: IGS_GE_MSG_STACK.ADD;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:
523: -- Validate Apply for Financial Aid
524: IF l_apply_for_finaid IS NOT NULL THEN

Line 529: RAISE FND_API.G_EXC_ERROR;

525: IF (NOT (l_apply_for_finaid = 'Y' OR l_apply_for_finaid = 'N')) THEN
526: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIN_AID'));
528: IGS_GE_MSG_STACK.ADD;
529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531: END IF;
532:
533: -- Validate Financial Aid Apply Date

Line 537: RAISE FND_API.G_EXC_ERROR;

533: -- Validate Financial Aid Apply Date
534: IF l_apply_for_finaid IS NULL AND l_finaid_apply_date IS NOT NULL THEN
535: FND_MESSAGE.SET_NAME('IGS','IGS_AD_FIN_DATE_FIN_AID_REQ');
536: IGS_GE_MSG_STACK.ADD;
537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539:
540: -- Validate Application Date.
541: -- 1. If Application Date is NULL default to SYSDATE.

Line 547: RAISE FND_API.G_EXC_ERROR;

543: -- 2. Application Date cannot be greater than SYSDATE.
544: IF l_appl_date > SYSDATE THEN
545: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPLDT_LE_CURRENT_DT');
546: IGS_GE_MSG_STACK.ADD;
547: RAISE FND_API.G_EXC_ERROR;
548: END IF;
549:
550: -- 3. SYSDATE should not have passed the Application submission deadline.
551: OPEN c_late_app(l_admission_cat,l_s_adm_process_type);

Line 573: RAISE FND_API.G_EXC_ERROR;

569: l_message_name) THEN
570: -- SYSDATE has passed submission deadline
571: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SUB_DEADLINE');
572: IGS_GE_MSG_STACK.ADD;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575: ELSE -- Late Applications Allowed
576: IF NOT IGS_AD_VAL_ACAI.admp_val_acai_late (
577: SYSDATE,

Line 593: RAISE FND_API.G_EXC_ERROR;

589: l_message_name) THEN
590: -- SYSDATE has passed submission deadline
591: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SUB_DEADLINE');
592: IGS_GE_MSG_STACK.ADD;
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;
595: END IF;
596:
597: -- Validate Application Source Id

Line 606: RAISE FND_API.G_EXC_ERROR;

602: IF l_appsource_rec IS NULL THEN
603: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
604: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APP_SOURCE'));
605: IGS_GE_MSG_STACK.ADD;
606: RAISE FND_API.G_EXC_ERROR;
607: END IF;
608:
609: ---------------------
610: -- Insert the Application Record.

Line 663: IF FND_API.To_Boolean( p_commit ) THEN

659: l_apsource_id,
660: l_application_fee_amount
661: ) RETURNING SS_ADM_APPL_ID INTO x_ss_adm_appl_id;
662:
663: IF FND_API.To_Boolean( p_commit ) THEN
664: COMMIT;
665: END IF;
666:
667: -- Exception Handling

Line 669: WHEN FND_API.G_EXC_ERROR THEN

665: END IF;
666:
667: -- Exception Handling
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: ROLLBACK TO PRE_CREATE_APPLICATION_pub;
671: igs_ad_gen_016.extract_msg_from_stack (
672: p_msg_at_index => l_msg_index,
673: p_return_status => l_return_status,

Line 679: x_return_status := FND_API.G_RET_STS_ERROR;

675: p_msg_data => x_msg_data,
676: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
677:
678: IF l_hash_msg_name_text_type_tab(x_msg_count - 2).name <> 'ORA' THEN
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: ELSE
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: END IF;
683:

Line 681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

677:
678: IF l_hash_msg_name_text_type_tab(x_msg_count - 2).name <> 'ORA' THEN
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: ELSE
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: END IF;
683:
684: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-2).text;
685: x_msg_count := x_msg_count-1;

Line 697: x_return_status := FND_API.G_RET_STS_ERROR;

693: p_msg_data => x_msg_data,
694: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
695:
696: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: ELSE
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: END IF;
701:

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

695:
696: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: ELSE
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: END IF;
701:
702: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-1).text;
703:

Line 711: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

707: --API
708: PROCEDURE PRE_CREATE_APPLICATION_INST(
709: --Standard Parameters Start
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
712: p_commit IN VARCHAR2 default FND_API.G_FALSE,
713: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,

Line 712: p_commit IN VARCHAR2 default FND_API.G_FALSE,

708: PROCEDURE PRE_CREATE_APPLICATION_INST(
709: --Standard Parameters Start
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
712: p_commit IN VARCHAR2 default FND_API.G_FALSE,
713: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,
716: x_msg_data OUT NOCOPY VARCHAR2,

Line 713: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,

709: --Standard Parameters Start
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
712: p_commit IN VARCHAR2 default FND_API.G_FALSE,
713: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,
716: x_msg_data OUT NOCOPY VARCHAR2,
717: --Standard parameter ends

Line 918: x_return_status := FND_API.G_RET_STS_SUCCESS;

914: l_ss_admappl_pgm_id IGS_SS_APP_PGM_STG.ss_admappl_pgm_id%TYPE;
915:
916: BEGIN
917: SAVEPOINT PRE_CREATE_APPL_INST_pub;
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919: l_msg_index := 0;
920:
921: -- Standard call to check for call compatibility.
922: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

Line 922: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919: l_msg_index := 0;
920:
921: -- Standard call to check for call compatibility.
922: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925:
926: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 923: RAISE FND_API.G_EXC_ERROR;

919: l_msg_index := 0;
920:
921: -- Standard call to check for call compatibility.
922: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925:
926: -- Initialize message list if p_init_msg_list is set to TRUE.
927: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 927: IF FND_API.to_Boolean( p_init_msg_list ) THEN

923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925:
926: -- Initialize message list if p_init_msg_list is set to TRUE.
927: IF FND_API.to_Boolean( p_init_msg_list ) THEN
928: FND_MSG_PUB.initialize;
929: END IF;
930: l_msg_index := igs_ge_msg_stack.count_msg;
931:

Line 1078: IF p_ss_adm_appl_id = FND_API.G_MISS_NUM OR p_ss_adm_appl_id IS NULL THEN

1074: --Intialization of variables to handle G_MISS_CHAR/NUM/DATE
1075: ---------------------
1076:
1077: -- p_ss_adm_appl_id
1078: IF p_ss_adm_appl_id = FND_API.G_MISS_NUM OR p_ss_adm_appl_id IS NULL THEN
1079: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PAR_INST_MISS');
1080: IGS_GE_MSG_STACK.ADD;
1081: RAISE FND_API.G_EXC_ERROR;
1082: ELSE

Line 1081: RAISE FND_API.G_EXC_ERROR;

1077: -- p_ss_adm_appl_id
1078: IF p_ss_adm_appl_id = FND_API.G_MISS_NUM OR p_ss_adm_appl_id IS NULL THEN
1079: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PAR_INST_MISS');
1080: IGS_GE_MSG_STACK.ADD;
1081: RAISE FND_API.G_EXC_ERROR;
1082: ELSE
1083: l_ss_adm_appl_id := p_ss_adm_appl_id;
1084: END IF;
1085:

Line 1087: IF p_sch_apl_to_id = FND_API.G_MISS_NUM THEN

1083: l_ss_adm_appl_id := p_ss_adm_appl_id;
1084: END IF;
1085:
1086: -- p_sch_apl_to_id
1087: IF p_sch_apl_to_id = FND_API.G_MISS_NUM THEN
1088: l_sch_apl_to_id := NULL;
1089: ELSE
1090: l_sch_apl_to_id := p_sch_apl_to_id;
1091: END IF;

Line 1094: IF p_location_cd = FND_API.G_MISS_CHAR THEN

1090: l_sch_apl_to_id := p_sch_apl_to_id;
1091: END IF;
1092:
1093: -- p_location_cd
1094: IF p_location_cd = FND_API.G_MISS_CHAR THEN
1095: l_location_cd := NULL;
1096: ELSE
1097: l_location_cd := p_location_cd;
1098: END IF;

Line 1101: IF p_attendance_type = FND_API.G_MISS_CHAR THEN

1097: l_location_cd := p_location_cd;
1098: END IF;
1099:
1100: -- p_attendance_type
1101: IF p_attendance_type = FND_API.G_MISS_CHAR THEN
1102: l_attendance_type := NULL;
1103: ELSE
1104: l_attendance_type := p_attendance_type;
1105: END IF;

Line 1108: IF p_attendance_mode = FND_API.G_MISS_CHAR THEN

1104: l_attendance_type := p_attendance_type;
1105: END IF;
1106:
1107: -- p_attendance_mode
1108: IF p_attendance_mode = FND_API.G_MISS_CHAR THEN
1109: l_attendance_mode := NULL;
1110: ELSE
1111: l_attendance_mode := p_attendance_mode;
1112: END IF;

Line 1115: IF p_attribute_category = FND_API.G_MISS_CHAR THEN

1111: l_attendance_mode := p_attendance_mode;
1112: END IF;
1113:
1114: -- p_attribute_category
1115: IF p_attribute_category = FND_API.G_MISS_CHAR THEN
1116: l_attribute_category := NULL;
1117: ELSE
1118: l_attribute_category := p_attribute_category;
1119: END IF;

Line 1122: IF p_attribute1 = FND_API.G_MISS_CHAR THEN

1118: l_attribute_category := p_attribute_category;
1119: END IF;
1120:
1121: -- p_attribute1
1122: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
1123: l_attribute1 := NULL;
1124: ELSE
1125: l_attribute1 := p_attribute1;
1126: END IF;

Line 1129: IF p_attribute2 = FND_API.G_MISS_CHAR THEN

1125: l_attribute1 := p_attribute1;
1126: END IF;
1127:
1128: -- p_attribute2
1129: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
1130: l_attribute2 := NULL;
1131: ELSE
1132: l_attribute2 := p_attribute2;
1133: END IF;

Line 1136: IF p_attribute3 = FND_API.G_MISS_CHAR THEN

1132: l_attribute2 := p_attribute2;
1133: END IF;
1134:
1135: -- p_attribute3
1136: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
1137: l_attribute3 := NULL;
1138: ELSE
1139: l_attribute3 := p_attribute3;
1140: END IF;

Line 1143: IF p_attribute4 = FND_API.G_MISS_CHAR THEN

1139: l_attribute3 := p_attribute3;
1140: END IF;
1141:
1142: -- p_attribute4
1143: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
1144: l_attribute4 := NULL;
1145: ELSE
1146: l_attribute4 := p_attribute4;
1147: END IF;

Line 1150: IF p_attribute5 = FND_API.G_MISS_CHAR THEN

1146: l_attribute4 := p_attribute4;
1147: END IF;
1148:
1149: -- p_attribute5
1150: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
1151: l_attribute5 := NULL;
1152: ELSE
1153: l_attribute5 := p_attribute5;
1154: END IF;

Line 1157: IF p_attribute6 = FND_API.G_MISS_CHAR THEN

1153: l_attribute5 := p_attribute5;
1154: END IF;
1155:
1156: -- p_attribute6
1157: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
1158: l_attribute6 := NULL;
1159: ELSE
1160: l_attribute6 := p_attribute6;
1161: END IF;

Line 1164: IF p_attribute7 = FND_API.G_MISS_CHAR THEN

1160: l_attribute6 := p_attribute6;
1161: END IF;
1162:
1163: -- p_attribute7
1164: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
1165: l_attribute7 := NULL;
1166: ELSE
1167: l_attribute7 := p_attribute7;
1168: END IF;

Line 1171: IF p_attribute8 = FND_API.G_MISS_CHAR THEN

1167: l_attribute7 := p_attribute7;
1168: END IF;
1169:
1170: -- p_attribute8
1171: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
1172: l_attribute8 := NULL;
1173: ELSE
1174: l_attribute8 := p_attribute8;
1175: END IF;

Line 1178: IF p_attribute9 = FND_API.G_MISS_CHAR THEN

1174: l_attribute8 := p_attribute8;
1175: END IF;
1176:
1177: -- p_attribute9
1178: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
1179: l_attribute9 := NULL;
1180: ELSE
1181: l_attribute9 := p_attribute9;
1182: END IF;

Line 1185: IF p_attribute10 = FND_API.G_MISS_CHAR THEN

1181: l_attribute9 := p_attribute9;
1182: END IF;
1183:
1184: -- p_attribute10
1185: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
1186: l_attribute10 := NULL;
1187: ELSE
1188: l_attribute10 := p_attribute10;
1189: END IF;

Line 1192: IF p_attribute11 = FND_API.G_MISS_CHAR THEN

1188: l_attribute10 := p_attribute10;
1189: END IF;
1190:
1191: -- p_attribute11
1192: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
1193: l_attribute11 := NULL;
1194: ELSE
1195: l_attribute11 := p_attribute11;
1196: END IF;

Line 1199: IF p_attribute12 = FND_API.G_MISS_CHAR THEN

1195: l_attribute11 := p_attribute11;
1196: END IF;
1197:
1198: -- p_attribute12
1199: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
1200: l_attribute12 := NULL;
1201: ELSE
1202: l_attribute12 := p_attribute12;
1203: END IF;

Line 1206: IF p_attribute13 = FND_API.G_MISS_CHAR THEN

1202: l_attribute12 := p_attribute12;
1203: END IF;
1204:
1205: -- p_attribute13
1206: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
1207: l_attribute13 := NULL;
1208: ELSE
1209: l_attribute13 := p_attribute13;
1210: END IF;

Line 1213: IF p_attribute14 = FND_API.G_MISS_CHAR THEN

1209: l_attribute13 := p_attribute13;
1210: END IF;
1211:
1212: -- p_attribute14
1213: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
1214: l_attribute14 := NULL;
1215: ELSE
1216: l_attribute14 := p_attribute14;
1217: END IF;

Line 1220: IF p_attribute15 = FND_API.G_MISS_CHAR THEN

1216: l_attribute14 := p_attribute14;
1217: END IF;
1218:
1219: -- p_attribute14
1220: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
1221: l_attribute15 := NULL;
1222: ELSE
1223: l_attribute15 := p_attribute15;
1224: END IF;

Line 1227: IF p_attribute16 = FND_API.G_MISS_CHAR THEN

1223: l_attribute15 := p_attribute15;
1224: END IF;
1225:
1226: -- p_attribute16
1227: IF p_attribute16 = FND_API.G_MISS_CHAR THEN
1228: l_attribute16 := NULL;
1229: ELSE
1230: l_attribute16 := p_attribute16;
1231: END IF;

Line 1234: IF p_attribute17 = FND_API.G_MISS_CHAR THEN

1230: l_attribute16 := p_attribute16;
1231: END IF;
1232:
1233: -- p_attribute17
1234: IF p_attribute17 = FND_API.G_MISS_CHAR THEN
1235: l_attribute17 := NULL;
1236: ELSE
1237: l_attribute17 := p_attribute17;
1238: END IF;

Line 1241: IF p_attribute18 = FND_API.G_MISS_CHAR THEN

1237: l_attribute17 := p_attribute17;
1238: END IF;
1239:
1240: -- p_attribute18
1241: IF p_attribute18 = FND_API.G_MISS_CHAR THEN
1242: l_attribute18 := NULL;
1243: ELSE
1244: l_attribute18 := p_attribute18;
1245: END IF;

Line 1248: IF p_attribute19 = FND_API.G_MISS_CHAR THEN

1244: l_attribute18 := p_attribute18;
1245: END IF;
1246:
1247: -- p_attribute19
1248: IF p_attribute19 = FND_API.G_MISS_CHAR THEN
1249: l_attribute19 := NULL;
1250: ELSE
1251: l_attribute19 := p_attribute19;
1252: END IF;

Line 1255: IF p_attribute20 = FND_API.G_MISS_CHAR THEN

1251: l_attribute19 := p_attribute19;
1252: END IF;
1253:
1254: -- p_attribute20
1255: IF p_attribute20 = FND_API.G_MISS_CHAR THEN
1256: l_attribute20 := NULL;
1257: ELSE
1258: l_attribute20 := p_attribute20;
1259: END IF;

Line 1262: IF p_attribute21 = FND_API.G_MISS_CHAR THEN

1258: l_attribute20 := p_attribute20;
1259: END IF;
1260:
1261: -- p_attribute21
1262: IF p_attribute21 = FND_API.G_MISS_CHAR THEN
1263: l_attribute21 := NULL;
1264: ELSE
1265: l_attribute21 := p_attribute21;
1266: END IF;

Line 1269: IF p_attribute22 = FND_API.G_MISS_CHAR THEN

1265: l_attribute21 := p_attribute21;
1266: END IF;
1267:
1268: -- p_attribute22
1269: IF p_attribute22 = FND_API.G_MISS_CHAR THEN
1270: l_attribute22 := NULL;
1271: ELSE
1272: l_attribute22 := p_attribute22;
1273: END IF;

Line 1276: IF p_attribute23 = FND_API.G_MISS_CHAR THEN

1272: l_attribute22 := p_attribute22;
1273: END IF;
1274:
1275: -- p_attribute23
1276: IF p_attribute23 = FND_API.G_MISS_CHAR THEN
1277: l_attribute23 := NULL;
1278: ELSE
1279: l_attribute23 := p_attribute23;
1280: END IF;

Line 1283: IF p_attribute24 = FND_API.G_MISS_CHAR THEN

1279: l_attribute23 := p_attribute23;
1280: END IF;
1281:
1282: -- p_attribute24
1283: IF p_attribute24 = FND_API.G_MISS_CHAR THEN
1284: l_attribute24 := NULL;
1285: ELSE
1286: l_attribute24 := p_attribute24;
1287: END IF;

Line 1290: IF p_attribute25 = FND_API.G_MISS_CHAR THEN

1286: l_attribute24 := p_attribute24;
1287: END IF;
1288:
1289: -- p_attribute25
1290: IF p_attribute25 = FND_API.G_MISS_CHAR THEN
1291: l_attribute25 := NULL;
1292: ELSE
1293: l_attribute25 := p_attribute25;
1294: END IF;

Line 1297: IF p_attribute26 = FND_API.G_MISS_CHAR THEN

1293: l_attribute25 := p_attribute25;
1294: END IF;
1295:
1296: -- p_attribute26
1297: IF p_attribute26 = FND_API.G_MISS_CHAR THEN
1298: l_attribute26 := NULL;
1299: ELSE
1300: l_attribute26 := p_attribute26;
1301: END IF;

Line 1304: IF p_attribute27 = FND_API.G_MISS_CHAR THEN

1300: l_attribute26 := p_attribute26;
1301: END IF;
1302:
1303: -- p_attribute27
1304: IF p_attribute27 = FND_API.G_MISS_CHAR THEN
1305: l_attribute27 := NULL;
1306: ELSE
1307: l_attribute27 := p_attribute27;
1308: END IF;

Line 1311: IF p_attribute28 = FND_API.G_MISS_CHAR THEN

1307: l_attribute27 := p_attribute27;
1308: END IF;
1309:
1310: -- p_attribute28
1311: IF p_attribute28 = FND_API.G_MISS_CHAR THEN
1312: l_attribute28 := NULL;
1313: ELSE
1314: l_attribute28 := p_attribute28;
1315: END IF;

Line 1318: IF p_attribute29 = FND_API.G_MISS_CHAR THEN

1314: l_attribute28 := p_attribute28;
1315: END IF;
1316:
1317: -- p_attribute29
1318: IF p_attribute29 = FND_API.G_MISS_CHAR THEN
1319: l_attribute29 := NULL;
1320: ELSE
1321: l_attribute29 := p_attribute29;
1322: END IF;

Line 1325: IF p_attribute30 = FND_API.G_MISS_CHAR THEN

1321: l_attribute29 := p_attribute29;
1322: END IF;
1323:
1324: -- p_attribute30
1325: IF p_attribute30 = FND_API.G_MISS_CHAR THEN
1326: l_attribute30 := NULL;
1327: ELSE
1328: l_attribute30 := p_attribute30;
1329: END IF;

Line 1332: IF p_attribute31 = FND_API.G_MISS_CHAR THEN

1328: l_attribute30 := p_attribute30;
1329: END IF;
1330:
1331: -- p_attribute31
1332: IF p_attribute31 = FND_API.G_MISS_CHAR THEN
1333: l_attribute31 := NULL;
1334: ELSE
1335: l_attribute31 := p_attribute31;
1336: END IF;

Line 1339: IF p_attribute32 = FND_API.G_MISS_CHAR THEN

1335: l_attribute31 := p_attribute31;
1336: END IF;
1337:
1338: -- p_attribute32
1339: IF p_attribute32 = FND_API.G_MISS_CHAR THEN
1340: l_attribute32 := NULL;
1341: ELSE
1342: l_attribute32 := p_attribute32;
1343: END IF;

Line 1346: IF p_attribute33 = FND_API.G_MISS_CHAR THEN

1342: l_attribute32 := p_attribute32;
1343: END IF;
1344:
1345: -- p_attribute33
1346: IF p_attribute33 = FND_API.G_MISS_CHAR THEN
1347: l_attribute33 := NULL;
1348: ELSE
1349: l_attribute33 := p_attribute33;
1350: END IF;

Line 1353: IF p_attribute34 = FND_API.G_MISS_CHAR THEN

1349: l_attribute33 := p_attribute33;
1350: END IF;
1351:
1352: -- p_attribute34
1353: IF p_attribute34 = FND_API.G_MISS_CHAR THEN
1354: l_attribute34 := NULL;
1355: ELSE
1356: l_attribute34 := p_attribute34;
1357: END IF;

Line 1360: IF p_attribute35 = FND_API.G_MISS_CHAR THEN

1356: l_attribute34 := p_attribute34;
1357: END IF;
1358:
1359: -- p_attribute35
1360: IF p_attribute35 = FND_API.G_MISS_CHAR THEN
1361: l_attribute35 := NULL;
1362: ELSE
1363: l_attribute35 := p_attribute35;
1364: END IF;

Line 1367: IF p_attribute36 = FND_API.G_MISS_CHAR THEN

1363: l_attribute35 := p_attribute35;
1364: END IF;
1365:
1366: -- p_attribute36
1367: IF p_attribute36 = FND_API.G_MISS_CHAR THEN
1368: l_attribute36 := NULL;
1369: ELSE
1370: l_attribute36 := p_attribute36;
1371: END IF;

Line 1374: IF p_attribute37 = FND_API.G_MISS_CHAR THEN

1370: l_attribute36 := p_attribute36;
1371: END IF;
1372:
1373: -- p_attribute37
1374: IF p_attribute37 = FND_API.G_MISS_CHAR THEN
1375: l_attribute37 := NULL;
1376: ELSE
1377: l_attribute37 := p_attribute37;
1378: END IF;

Line 1381: IF p_attribute38 = FND_API.G_MISS_CHAR THEN

1377: l_attribute37 := p_attribute37;
1378: END IF;
1379:
1380: -- p_attribute38
1381: IF p_attribute38 = FND_API.G_MISS_CHAR THEN
1382: l_attribute38 := NULL;
1383: ELSE
1384: l_attribute38 := p_attribute38;
1385: END IF;

Line 1388: IF p_attribute39 = FND_API.G_MISS_CHAR THEN

1384: l_attribute38 := p_attribute38;
1385: END IF;
1386:
1387: -- p_attribute39
1388: IF p_attribute39 = FND_API.G_MISS_CHAR THEN
1389: l_attribute39 := NULL;
1390: ELSE
1391: l_attribute39 := p_attribute39;
1392: END IF;

Line 1395: IF p_attribute40 = FND_API.G_MISS_CHAR THEN

1391: l_attribute39 := p_attribute39;
1392: END IF;
1393:
1394: -- p_attribute40
1395: IF p_attribute40 = FND_API.G_MISS_CHAR THEN
1396: l_attribute40 := NULL;
1397: ELSE
1398: l_attribute40 := p_attribute40;
1399: END IF;

Line 1415: RAISE FND_API.G_EXC_ERROR;

1411: IF l_admappl_rec.ss_adm_appl_id IS NULL THEN
1412: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_APPL_ID'));
1414: IGS_GE_MSG_STACK.ADD;
1415: RAISE FND_API.G_EXC_ERROR;
1416: END IF;
1417:
1418: ---------------------
1419: -- Derive Person Id from the application Type

Line 1440: RAISE FND_API.G_EXC_ERROR;

1436: IF l_sch_apl_to_rec IS NULL THEN
1437: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1438: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SCH_APPLY_TO'));
1439: IGS_GE_MSG_STACK.ADD;
1440: RAISE FND_API.G_EXC_ERROR;
1441: END IF;
1442: END IF;
1443:
1444: -- validate l_location_cd

Line 1453: RAISE FND_API.G_EXC_ERROR;

1449:
1450: IF l_location_rec IS NULL THEN
1451: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LOC_CD_INV');
1452: IGS_GE_MSG_STACK.ADD;
1453: RAISE FND_API.G_EXC_ERROR;
1454: END IF;
1455: END IF;
1456:
1457: -- validate p_attendance_type

Line 1467: RAISE FND_API.G_EXC_ERROR;

1463: IF l_att_type_rec IS NULL THEN
1464: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1465: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_TYPE'));
1466: IGS_GE_MSG_STACK.ADD;
1467: RAISE FND_API.G_EXC_ERROR;
1468: END IF;
1469: END IF;
1470:
1471: -- validate p_attendance_mode

Line 1481: RAISE FND_API.G_EXC_ERROR;

1477: IF l_att_mode_rec IS NULL THEN
1478: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1479: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_MODE'));
1480: IGS_GE_MSG_STACK.ADD;
1481: RAISE FND_API.G_EXC_ERROR;
1482: END IF;
1483: END IF;
1484:
1485: -- validate p_location_cd, p_attendance_type and p_attendance_mode combination

Line 1489: RAISE FND_API.G_EXC_ERROR;

1485: -- validate p_location_cd, p_attendance_type and p_attendance_mode combination
1486: IF l_location_cd IS NULL AND l_attendance_type IS NULL AND l_attendance_mode IS NULL THEN
1487: FND_MESSAGE.SET_NAME('IGS','IGS_AD_COMB_NOT_NULL');
1488: IGS_GE_MSG_STACK.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: OPEN c_off_pattern(l_admappl_rec.admission_cat, l_admappl_rec.s_adm_process_type, l_location_cd, l_attendance_type,l_attendance_mode);
1493: FETCH c_off_pattern INTO l_off_pattern_rec;

Line 1499: RAISE FND_API.G_EXC_ERROR;

1495:
1496: IF l_off_pattern_rec IS NULL THEN
1497: FND_MESSAGE.SET_NAME('IGS','IGS_AD_COMB_NOT_EXIST');
1498: IGS_GE_MSG_STACK.ADD;
1499: RAISE FND_API.G_EXC_ERROR;
1500: END IF;
1501:
1502: -- Validate/ Derive Preference Number
1503: OPEN c_pref_limit(l_admappl_rec.admission_cat, l_admappl_rec.s_adm_process_type);

Line 1519: RAISE FND_API.G_EXC_ERROR;

1515: l_preference_number := 1;
1516: ELSE
1517: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROG_PREF_EXIST');
1518: IGS_GE_MSG_STACK.ADD;
1519: RAISE FND_API.G_EXC_ERROR;
1520: END IF;
1521: END IF;
1522:
1523: -- Check for correctness of Descriptive FlexField values

Line 1570: RAISE FND_API.G_EXC_ERROR;

1566: 'IGS_AD_APPL_INST_FLEX'
1567: ) THEN
1568: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_DESC_FLEX');
1569: IGS_GE_MSG_STACK.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572:
1573: ---------------------
1574: -- Insert the Application Instance Record.

Line 1686: IF FND_API.To_Boolean( p_commit ) THEN

1682: SYSDATE,
1683: FND_GLOBAL.USER_ID,
1684: FND_GLOBAL.USER_ID) RETURNING SS_ADMAPPL_PGM_ID INTO x_ss_admappl_pgm_id;
1685:
1686: IF FND_API.To_Boolean( p_commit ) THEN
1687: COMMIT;
1688: END IF;
1689:
1690: -- Exception Handling

Line 1692: WHEN FND_API.G_EXC_ERROR THEN

1688: END IF;
1689:
1690: -- Exception Handling
1691: EXCEPTION
1692: WHEN FND_API.G_EXC_ERROR THEN
1693: ROLLBACK TO PRE_CREATE_APPL_INST_pub;
1694: igs_ad_gen_016.extract_msg_from_stack (
1695: p_msg_at_index => l_msg_index,
1696: p_return_status => l_return_status,

Line 1702: x_return_status := FND_API.G_RET_STS_ERROR;

1698: p_msg_data => x_msg_data,
1699: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1700:
1701: IF l_hash_msg_name_text_type_tab(x_msg_count - 2).name <> 'ORA' THEN
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: ELSE
1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1705: END IF;
1706:

Line 1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1700:
1701: IF l_hash_msg_name_text_type_tab(x_msg_count - 2).name <> 'ORA' THEN
1702: x_return_status := FND_API.G_RET_STS_ERROR;
1703: ELSE
1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1705: END IF;
1706:
1707: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-2).text;
1708: x_msg_count := x_msg_count-1;

Line 1721: x_return_status := FND_API.G_RET_STS_ERROR;

1717: p_msg_data => x_msg_data,
1718: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1719:
1720: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: ELSE
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1724: END IF;
1725:

Line 1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1719:
1720: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
1721: x_return_status := FND_API.G_RET_STS_ERROR;
1722: ELSE
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1724: END IF;
1725:
1726: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-1).text;
1727:

Line 1733: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

1729:
1730: PROCEDURE INSERT_STG_FEE_REQ_DET (
1731:
1732: p_api_version IN NUMBER, -- standard Public API IN params
1733: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1734: p_commit IN VARCHAR2 default FND_API.G_FALSE,
1735: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1736: x_return_status OUT NOCOPY VARCHAR2, -- standard Public API OUT params
1737: x_msg_count OUT NOCOPY NUMBER,

Line 1734: p_commit IN VARCHAR2 default FND_API.G_FALSE,

1730: PROCEDURE INSERT_STG_FEE_REQ_DET (
1731:
1732: p_api_version IN NUMBER, -- standard Public API IN params
1733: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1734: p_commit IN VARCHAR2 default FND_API.G_FALSE,
1735: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1736: x_return_status OUT NOCOPY VARCHAR2, -- standard Public API OUT params
1737: x_msg_count OUT NOCOPY NUMBER,
1738: x_msg_data OUT NOCOPY VARCHAR2,

Line 1735: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

1731:
1732: p_api_version IN NUMBER, -- standard Public API IN params
1733: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
1734: p_commit IN VARCHAR2 default FND_API.G_FALSE,
1735: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1736: x_return_status OUT NOCOPY VARCHAR2, -- standard Public API OUT params
1737: x_msg_count OUT NOCOPY NUMBER,
1738: x_msg_data OUT NOCOPY VARCHAR2,
1739: p_SS_ADM_APPL_ID IN NUMBER, -- Staging table related params

Line 1808: x_return_status := FND_API.G_RET_STS_SUCCESS;

1804: -- Standard begin of API savepoint
1805: SAVEPOINT INSERT_STG_FEE_REQ_DET_PUB;
1806:
1807: -- Initialize API return status to success
1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809: l_msg_index := 0;
1810:
1811: -- Standard call to check for call compatibility.
1812: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

Line 1812: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)

1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809: l_msg_index := 0;
1810:
1811: -- Standard call to check for call compatibility.
1812: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1813: THEN
1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;
1816:

Line 1814: RAISE FND_API.G_EXC_ERROR;

1810:
1811: -- Standard call to check for call compatibility.
1812: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1813: THEN
1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;
1816:
1817: -- Check p_init_msg_list
1818: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1818: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;
1816:
1817: -- Check p_init_msg_list
1818: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1819: FND_MSG_PUB.initialize;
1820: END IF;
1821: l_msg_index := igs_ge_msg_stack.count_msg;
1822:

Line 1849: IF p_SS_ADM_APPL_ID = FND_API.G_MISS_NUM OR p_SS_ADM_APPL_ID IS NULL THEN

1845: ------------------------
1846: --Intialization of variables to handle G_MISS_CHAR/NUM/DATE
1847: ------------------------
1848:
1849: IF p_SS_ADM_APPL_ID = FND_API.G_MISS_NUM OR p_SS_ADM_APPL_ID IS NULL THEN
1850: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STG_FEE_PARAM_MISSING'); --error message
1851: IGS_GE_MSG_STACK.ADD;
1852: RAISE FND_API.G_EXC_ERROR;
1853: ELSE

Line 1852: RAISE FND_API.G_EXC_ERROR;

1848:
1849: IF p_SS_ADM_APPL_ID = FND_API.G_MISS_NUM OR p_SS_ADM_APPL_ID IS NULL THEN
1850: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STG_FEE_PARAM_MISSING'); --error message
1851: IGS_GE_MSG_STACK.ADD;
1852: RAISE FND_API.G_EXC_ERROR;
1853: ELSE
1854: l_SS_ADM_APPL_ID := p_SS_ADM_APPL_ID;
1855: END IF;
1856:

Line 1857: IF p_PERSON_ID = FND_API.G_MISS_NUM OR p_PERSON_ID IS NULL THEN

1853: ELSE
1854: l_SS_ADM_APPL_ID := p_SS_ADM_APPL_ID;
1855: END IF;
1856:
1857: IF p_PERSON_ID = FND_API.G_MISS_NUM OR p_PERSON_ID IS NULL THEN
1858: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STG_FEE_PARAM_MISSING'); --error message
1859: IGS_GE_MSG_STACK.ADD;
1860: RAISE FND_API.G_EXC_ERROR;
1861: ELSE

Line 1860: RAISE FND_API.G_EXC_ERROR;

1856:
1857: IF p_PERSON_ID = FND_API.G_MISS_NUM OR p_PERSON_ID IS NULL THEN
1858: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STG_FEE_PARAM_MISSING'); --error message
1859: IGS_GE_MSG_STACK.ADD;
1860: RAISE FND_API.G_EXC_ERROR;
1861: ELSE
1862: l_PERSON_ID := p_PERSON_ID;
1863: END IF;
1864:

Line 1865: IF p_APPLICANT_FEE_TYPE = FND_API.G_MISS_NUM THEN

1861: ELSE
1862: l_PERSON_ID := p_PERSON_ID;
1863: END IF;
1864:
1865: IF p_APPLICANT_FEE_TYPE = FND_API.G_MISS_NUM THEN
1866: l_APPLICANT_FEE_TYPE := NULL;
1867: ELSE
1868: l_APPLICANT_FEE_TYPE := p_APPLICANT_FEE_TYPE;
1869: END IF;

Line 1871: IF p_APPLICANT_FEE_STATUS = FND_API.G_MISS_NUM THEN

1867: ELSE
1868: l_APPLICANT_FEE_TYPE := p_APPLICANT_FEE_TYPE;
1869: END IF;
1870:
1871: IF p_APPLICANT_FEE_STATUS = FND_API.G_MISS_NUM THEN
1872: l_APPLICANT_FEE_STATUS := NULL;
1873: ELSE
1874: l_APPLICANT_FEE_STATUS := p_APPLICANT_FEE_STATUS;
1875: END IF;

Line 1877: IF p_FEE_DATE = FND_API.G_MISS_DATE THEN

1873: ELSE
1874: l_APPLICANT_FEE_STATUS := p_APPLICANT_FEE_STATUS;
1875: END IF;
1876:
1877: IF p_FEE_DATE = FND_API.G_MISS_DATE THEN
1878: l_FEE_DATE := NULL;
1879: ELSE
1880: l_FEE_DATE := p_FEE_DATE;
1881: END IF;

Line 1883: IF p_FEE_PAYMENT_METHOD = FND_API.G_MISS_NUM THEN

1879: ELSE
1880: l_FEE_DATE := p_FEE_DATE;
1881: END IF;
1882:
1883: IF p_FEE_PAYMENT_METHOD = FND_API.G_MISS_NUM THEN
1884: l_FEE_PAYMENT_METHOD := NULL;
1885: ELSE
1886: l_FEE_PAYMENT_METHOD := p_FEE_PAYMENT_METHOD;
1887: END IF;

Line 1889: IF p_FEE_AMOUNT = FND_API.G_MISS_NUM THEN

1885: ELSE
1886: l_FEE_PAYMENT_METHOD := p_FEE_PAYMENT_METHOD;
1887: END IF;
1888:
1889: IF p_FEE_AMOUNT = FND_API.G_MISS_NUM THEN
1890: l_FEE_AMOUNT := NULL;
1891: ELSE
1892: l_FEE_AMOUNT := p_FEE_AMOUNT;
1893: END IF;

Line 1895: IF p_REFERENCE_NUM = FND_API.G_MISS_CHAR THEN

1891: ELSE
1892: l_FEE_AMOUNT := p_FEE_AMOUNT;
1893: END IF;
1894:
1895: IF p_REFERENCE_NUM = FND_API.G_MISS_CHAR THEN
1896: l_REFERENCE_NUM := NULL;
1897: ELSE
1898: l_REFERENCE_NUM := p_REFERENCE_NUM;
1899: END IF;

Line 1911: RAISE FND_API.G_EXC_ERROR;

1907: OR l_FEE_DATE IS NULL OR l_FEE_AMOUNT IS NULL
1908: THEN
1909: FND_MESSAGE.SET_NAME('IGS','IGS_SS_AD_FEE_NTNULL'); --error message
1910: IGS_GE_MSG_STACK.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1913:
1914: -- check for applicant_fee_type values
1915: IF l_APPLICANT_FEE_TYPE IS NOT NULL THEN

Line 1923: RAISE FND_API.G_EXC_ERROR; --error message

1919: CLOSE C_FEE_TYPE;
1920: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_TYPE'));
1922: IGS_GE_MSG_STACK.ADD;
1923: RAISE FND_API.G_EXC_ERROR; --error message
1924: END IF;
1925: CLOSE C_FEE_TYPE;
1926: END IF;
1927:

Line 1937: RAISE FND_API.G_EXC_ERROR; --error message

1933: CLOSE C_FEE_STATUS;
1934: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_STAT'));
1936: IGS_GE_MSG_STACK.ADD;
1937: RAISE FND_API.G_EXC_ERROR; --error message
1938: END IF;
1939: CLOSE C_FEE_STATUS;
1940: END IF;
1941:

Line 1951: RAISE FND_API.G_EXC_ERROR; --error message

1947: CLOSE C_FEE_PAYMENT_METHOD;
1948: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
1949: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_PAY_METHOD'));
1950: IGS_GE_MSG_STACK.ADD;
1951: RAISE FND_API.G_EXC_ERROR; --error message
1952: END IF;
1953: CLOSE C_FEE_PAYMENT_METHOD;
1954: END IF;
1955:

Line 1960: RAISE FND_API.G_EXC_ERROR;

1956: -- if Fee Amount is negative
1957: IF l_FEE_AMOUNT IS NOT NULL AND l_FEE_AMOUNT < 0 THEN
1958: FND_MESSAGE.SET_NAME('IGS','IGS_AD_FEE_AMT_NON_NEGATIVE'); --error message
1959: IGS_GE_MSG_STACK.ADD;
1960: RAISE FND_API.G_EXC_ERROR;
1961: END IF;
1962:
1963: -- if Fee Date is greater than sysdate
1964: IF l_FEE_DATE IS NOT NULL AND l_FEE_DATE > SYSDATE THEN

Line 1968: RAISE FND_API.G_EXC_ERROR;

1964: IF l_FEE_DATE IS NOT NULL AND l_FEE_DATE > SYSDATE THEN
1965: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE'); --error message
1966: FND_MESSAGE.SET_TOKEN ('NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_DATE'));
1967: IGS_GE_MSG_STACK.ADD;
1968: RAISE FND_API.G_EXC_ERROR;
1969: END IF;
1970:
1971: INSERT INTO IGS_SS_APP_REQ_STG (
1972: SS_APP_REQ_ID,

Line 2005: IF FND_API.To_Boolean( p_commit ) THEN

2001: FND_GLOBAL.USER_ID,
2002: l_REFERENCE_NUM
2003: );
2004:
2005: IF FND_API.To_Boolean( p_commit ) THEN
2006: COMMIT WORK;
2007: END IF;
2008: -- Get message count and if 1, return message data.
2009: FND_MSG_PUB.Count_And_Get

Line 2016: WHEN FND_API.G_EXC_ERROR THEN

2012: );
2013:
2014:
2015: EXCEPTION
2016: WHEN FND_API.G_EXC_ERROR THEN
2017:
2018: ROLLBACK TO INSERT_STG_FEE_REQ_DET_PUB;
2019: igs_ad_gen_016.extract_msg_from_stack (
2020: p_msg_at_index => l_msg_index,

Line 2027: x_return_status := FND_API.G_RET_STS_ERROR;

2023: p_msg_data => x_msg_data,
2024: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2025:
2026: IF l_hash_msg_name_text_type_tab(x_msg_count - 2).name <> 'ORA' THEN
2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: ELSE
2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2030: END IF;
2031:

Line 2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2025:
2026: IF l_hash_msg_name_text_type_tab(x_msg_count - 2).name <> 'ORA' THEN
2027: x_return_status := FND_API.G_RET_STS_ERROR;
2028: ELSE
2029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2030: END IF;
2031:
2032: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-2).text;
2033: x_msg_count := x_msg_count-1;

Line 2046: x_return_status := FND_API.G_RET_STS_ERROR;

2042: p_msg_data => x_msg_data,
2043: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2044:
2045: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047: ELSE
2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2049: END IF;
2050:

Line 2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2044:
2045: IF l_hash_msg_name_text_type_tab(x_msg_count - 1).name <> 'ORA' THEN
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047: ELSE
2048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2049: END IF;
2050:
2051: x_msg_data := l_hash_msg_name_text_type_tab(x_msg_count-1).text;
2052: