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_MESSAGE

Line 23: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');

19: OPEN c_col_length;
20: FETCH c_col_length INTO l_col_length;
21: CLOSE c_col_length;
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;

Line 24: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);

20: FETCH c_col_length INTO l_col_length;
21: CLOSE c_col_length;
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

Line 25: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.width);

21: CLOSE c_col_length;
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');

Line 29: FND_MESSAGE.SET_NAME('IGS','IGS_AD_EXCEED_MAX_LENGTH');

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

Line 30: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);

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

Line 32: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision || ',' || l_col_length.scale);

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
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;

Line 34: FND_MESSAGE.SET_TOKEN('LENGTH',l_col_length.precision );

30: FND_MESSAGE.SET_TOKEN('PARAMETER',p_param_name);
31: IF l_col_length.scale > 0 THEN
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;

Line 271: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');

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

Line 285: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');

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

Line 293: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');

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

Line 301: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');

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

Line 309: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');

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

Line 354: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');

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

Line 362: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PARAM_MISSING');

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

Line 383: FND_MESSAGE.SET_NAME('IGS','IGS_AD_FEE_AMT_NON_NEGATIVE');

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

Line 395: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

391: FETCH c_person INTO l_person_rec;
392: CLOSE c_person;
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;

Line 396: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PERSON_ID'));

392: CLOSE c_person;
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:

Line 407: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

403: FETCH c_cal INTO l_cal_rec;
404: CLOSE c_cal;
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;

Line 408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_CAL'));

404: CLOSE c_cal;
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:

Line 423: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

419: FETCH c_cal INTO l_cal_rec;
420: CLOSE c_cal;
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;

Line 424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ACAD_CAL'));

420: CLOSE c_cal;
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:

Line 435: FND_MESSAGE.SET_NAME('IGS','IGS_AD_ADMCAL_CHILD_ACACAL');

431: FETCH c_cal_rel INTO l_cal_rel_rec;
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:

Line 447: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

443: FETCH c_estatus INTO l_estatus_rec;
444: CLOSE c_estatus;
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;

Line 448: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENTRY_STAT'));

444: CLOSE c_estatus;
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;

Line 461: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

457: FETCH c_elevel INTO l_elevel_rec;
458: CLOSE c_elevel;
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;

Line 462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENTRY_LVL'));

458: CLOSE c_elevel;
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;

Line 475: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

471: FETCH c_spcl_grp1 INTO l_spcl_grp1_rec;
472: CLOSE c_spcl_grp1;
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;

Line 476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_GRP1'));

472: CLOSE c_spcl_grp1;
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;

Line 489: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

485: FETCH c_spcl_grp2 INTO l_spcl_grp2_rec;
486: CLOSE c_spcl_grp2;
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;

Line 490: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SPL_GRP2'));

486: CLOSE c_spcl_grp2;
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;

Line 502: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

498: FETCH c_apptype INTO l_apptype_rec;
499: CLOSE c_apptype;
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;

Line 503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_APPL_TYPE'));

499: CLOSE c_apptype;
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:

Line 518: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_APP_TYPE');

514: FETCH c_apptype_admcal INTO l_apptype_admcal_rec;
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:

Line 526: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

522:
523: -- Validate Apply for Financial Aid
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;

Line 527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIN_AID'));

523: -- Validate Apply for Financial Aid
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;

Line 535: FND_MESSAGE.SET_NAME('IGS','IGS_AD_FIN_DATE_FIN_AID_REQ');

531: END IF;
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:

Line 545: FND_MESSAGE.SET_NAME('IGS','IGS_AD_APPLDT_LE_CURRENT_DT');

541: -- 1. If Application Date is NULL default to SYSDATE.
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:

Line 571: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SUB_DEADLINE');

567: l_s_adm_process_type,
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

Line 591: FND_MESSAGE.SET_NAME('IGS','IGS_AD_SUB_DEADLINE');

587: l_s_adm_process_type,
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;

Line 603: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

599: FETCH c_appsource INTO l_appsource_rec;
600: CLOSE c_appsource;
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;

Line 604: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APP_SOURCE'));

600: CLOSE c_appsource;
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:

Line 1079: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRECREATE_PAR_INST_MISS');

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

Line 1412: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

1408: FETCH c_admappl INTO l_admappl_rec;
1409: CLOSE c_admappl;
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;

Line 1413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ADM_APPL_ID'));

1409: CLOSE c_admappl;
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:

Line 1437: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

1433: FETCH c_sch_apl_to INTO l_sch_apl_to_rec;
1434: CLOSE c_sch_apl_to;
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;

Line 1438: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_SCH_APPLY_TO'));

1434: CLOSE c_sch_apl_to;
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;

Line 1451: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LOC_CD_INV');

1447: FETCH c_location INTO l_location_rec;
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;

Line 1464: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

1460: FETCH c_att_type INTO l_att_type_rec;
1461: CLOSE c_att_type;
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;

Line 1465: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_TYPE'));

1461: CLOSE c_att_type;
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;

Line 1478: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

1474: FETCH c_att_mode INTO l_att_mode_rec;
1475: CLOSE c_att_mode;
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;

Line 1479: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ATTENDANCE_MODE'));

1475: CLOSE c_att_mode;
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;

Line 1487: FND_MESSAGE.SET_NAME('IGS','IGS_AD_COMB_NOT_NULL');

1483: END IF;
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:

Line 1497: FND_MESSAGE.SET_NAME('IGS','IGS_AD_COMB_NOT_EXIST');

1493: FETCH c_off_pattern INTO l_off_pattern_rec;
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:

Line 1517: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PROG_PREF_EXIST');

1513: ELSE -- Preference Limit APC Step is set
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;

Line 1568: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_DESC_FLEX');

1564: l_attribute39,
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:

Line 1850: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STG_FEE_PARAM_MISSING'); --error message

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

Line 1858: FND_MESSAGE.SET_NAME('IGS','IGS_AD_STG_FEE_PARAM_MISSING'); --error message

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

Line 1909: FND_MESSAGE.SET_NAME('IGS','IGS_SS_AD_FEE_NTNULL'); --error message

1905: -- When fee type, fee status, fee date and fee amount are null
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:

Line 1920: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

1916: OPEN C_FEE_TYPE(l_APPLICANT_FEE_TYPE);
1917: FETCH C_FEE_TYPE INTO l_APPL_FEE_TYPE_REC;
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;

Line 1921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_TYPE'));

1917: FETCH C_FEE_TYPE INTO l_APPL_FEE_TYPE_REC;
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;

Line 1934: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

1930: OPEN C_FEE_STATUS(l_APPLICANT_FEE_STATUS);
1931: FETCH C_FEE_STATUS INTO l_APPL_FEE_STATUS_REC;
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;

Line 1935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_STAT'));

1931: FETCH C_FEE_STATUS INTO l_APPL_FEE_STATUS_REC;
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;

Line 1948: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');

1944: OPEN C_FEE_PAYMENT_METHOD(l_FEE_PAYMENT_METHOD);
1945: FETCH C_FEE_PAYMENT_METHOD INTO l_APPL_FEE_PAY_MET_REC;
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;

Line 1949: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_PAY_METHOD'));

1945: FETCH C_FEE_PAYMENT_METHOD INTO l_APPL_FEE_PAY_MET_REC;
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;

Line 1958: FND_MESSAGE.SET_NAME('IGS','IGS_AD_FEE_AMT_NON_NEGATIVE'); --error message

1954: END IF;
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:

Line 1965: FND_MESSAGE.SET_NAME('IGS','IGS_AD_DATE_SYSDATE'); --error message

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
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;

Line 1966: FND_MESSAGE.SET_TOKEN ('NAME',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_DATE'));

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