DBA Data[Home] [Help]

APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_GE_MSG_STACK

Line 26: IGS_GE_MSG_STACK.ADD;

22: IF l_col_length.column_type = 'V' AND p_param_length > l_col_length.width THEN
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);

Line 36: IGS_GE_MSG_STACK.ADD;

32: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision || ',' || l_col_length.scale);
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:

Line 232: l_msg_index := igs_ge_msg_stack.count_msg;

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:
234: -----------------------
235: -- Validate all the parameters for their length
236: -----------------------

Line 272: IGS_GE_MSG_STACK.ADD;

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
275: l_person_id := p_person_id;
276: END IF;

Line 286: IGS_GE_MSG_STACK.ADD;

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
289: l_acad_cal_type := p_acad_cal_type;
290: END IF;

Line 294: IGS_GE_MSG_STACK.ADD;

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
297: l_acad_cal_seq_number := p_acad_cal_seq_number;
298: END IF;

Line 302: IGS_GE_MSG_STACK.ADD;

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
305: l_adm_cal_type := p_adm_cal_type;
306: END IF;

Line 310: IGS_GE_MSG_STACK.ADD;

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
313: l_adm_cal_seq_number :=p_adm_cal_seq_number ;
314: END IF;

Line 355: IGS_GE_MSG_STACK.ADD;

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
358: l_admission_application_type := p_admission_application_type;
359: END IF;

Line 363: IGS_GE_MSG_STACK.ADD;

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
366: l_apsource_id := p_apsource_id;
367: END IF;

Line 384: IGS_GE_MSG_STACK.ADD;

380: -- Validate Application Fee Amount
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:

Line 397: IGS_GE_MSG_STACK.ADD;

393:
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

Line 409: IGS_GE_MSG_STACK.ADD;

405:
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

Line 425: IGS_GE_MSG_STACK.ADD;

421:
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

Line 436: IGS_GE_MSG_STACK.ADD;

432: CLOSE c_cal_rel;
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

Line 449: IGS_GE_MSG_STACK.ADD;

445:
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:

Line 463: IGS_GE_MSG_STACK.ADD;

459:
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:

Line 477: IGS_GE_MSG_STACK.ADD;

473:
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:

Line 491: IGS_GE_MSG_STACK.ADD;

487:
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:

Line 504: IGS_GE_MSG_STACK.ADD;

500:
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

Line 519: IGS_GE_MSG_STACK.ADD;

515: CLOSE c_apptype_admcal;
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

Line 528: IGS_GE_MSG_STACK.ADD;

524: IF l_apply_for_finaid IS NOT NULL THEN
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:

Line 536: IGS_GE_MSG_STACK.ADD;

532:
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.

Line 546: IGS_GE_MSG_STACK.ADD;

542:
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.

Line 572: IGS_GE_MSG_STACK.ADD;

568: 'N', -- late app not allowed
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 (

Line 592: IGS_GE_MSG_STACK.ADD;

588: 'Y', -- late app allowed
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:

Line 605: IGS_GE_MSG_STACK.ADD;

601:
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: ---------------------

Line 930: l_msg_index := igs_ge_msg_stack.count_msg;

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:
932: -----------------------
933: -- Validate all the parameters for their length
934: -----------------------

Line 1080: IGS_GE_MSG_STACK.ADD;

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
1083: l_ss_adm_appl_id := p_ss_adm_appl_id;
1084: END IF;

Line 1414: IGS_GE_MSG_STACK.ADD;

1410:
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: ---------------------

Line 1439: IGS_GE_MSG_STACK.ADD;

1435:
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:

Line 1452: IGS_GE_MSG_STACK.ADD;

1448: CLOSE c_location;
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:

Line 1466: IGS_GE_MSG_STACK.ADD;

1462:
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:

Line 1480: IGS_GE_MSG_STACK.ADD;

1476:
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:

Line 1488: IGS_GE_MSG_STACK.ADD;

1484:
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);

Line 1498: IGS_GE_MSG_STACK.ADD;

1494: CLOSE c_off_pattern;
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

Line 1518: IGS_GE_MSG_STACK.ADD;

1514: IF l_prog_inst_rec IS NULL THEN -- Another Program Instance for same Parent Application does not exists
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:

Line 1569: IGS_GE_MSG_STACK.ADD;

1565: l_attribute40,
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: ---------------------

Line 1821: l_msg_index := igs_ge_msg_stack.count_msg;

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:
1823:
1824: -----------------------
1825: -- Validate all the parameters for their length

Line 1851: IGS_GE_MSG_STACK.ADD;

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
1854: l_SS_ADM_APPL_ID := p_SS_ADM_APPL_ID;
1855: END IF;

Line 1859: IGS_GE_MSG_STACK.ADD;

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
1862: l_PERSON_ID := p_PERSON_ID;
1863: END IF;

Line 1910: IGS_GE_MSG_STACK.ADD;

1906: IF l_APPLICANT_FEE_TYPE IS NULL OR l_APPLICANT_FEE_STATUS IS NULL
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

Line 1922: IGS_GE_MSG_STACK.ADD;

1918: IF (C_FEE_TYPE%NOTFOUND) THEN
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;

Line 1936: IGS_GE_MSG_STACK.ADD;

1932: IF (C_FEE_STATUS%NOTFOUND) THEN
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;

Line 1950: IGS_GE_MSG_STACK.ADD;

1946: IF (C_FEE_PAYMENT_METHOD%NOTFOUND) THEN
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;

Line 1959: IGS_GE_MSG_STACK.ADD;

1955:
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

Line 1967: IGS_GE_MSG_STACK.ADD;

1963: -- if Fee Date is greater than sysdate
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 (