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_AD_IMP_004 dependencies on FND_MESSAGE

Line 350: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

346: l_error_text VARCHAR2(2000);
347: BEGIN -- Validates the interface columns with apc steps
348: --i.e if the columns are having the valid values matchng to application type
349: IF l_rank_set_allowed = 'N' AND p_applinst_rec.course_rank_set IS NOT NULL THEN
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
351: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_COURSE_RANK_DTLS'));
352: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
353: l_error_text := FND_MESSAGE.GET;
354: l_error_code := 'E322';

Line 351: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_COURSE_RANK_DTLS'));

347: BEGIN -- Validates the interface columns with apc steps
348: --i.e if the columns are having the valid values matchng to application type
349: IF l_rank_set_allowed = 'N' AND p_applinst_rec.course_rank_set IS NOT NULL THEN
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
351: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_COURSE_RANK_DTLS'));
352: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
353: l_error_text := FND_MESSAGE.GET;
354: l_error_code := 'E322';
355: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 352: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

348: --i.e if the columns are having the valid values matchng to application type
349: IF l_rank_set_allowed = 'N' AND p_applinst_rec.course_rank_set IS NOT NULL THEN
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
351: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_COURSE_RANK_DTLS'));
352: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
353: l_error_text := FND_MESSAGE.GET;
354: l_error_code := 'E322';
355: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
356: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 353: l_error_text := FND_MESSAGE.GET;

349: IF l_rank_set_allowed = 'N' AND p_applinst_rec.course_rank_set IS NOT NULL THEN
350: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
351: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_COURSE_RANK_DTLS'));
352: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
353: l_error_text := FND_MESSAGE.GET;
354: l_error_code := 'E322';
355: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
356: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
357: IF p_enable_log = 'Y' THEN

Line 364: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

360: RETURN FALSE;
361: END IF;
362:
363: IF l_unit_set_allowed = 'N' AND p_applinst_rec.unit_set_cd IS NOT NULL THEN
364: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
365: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
366: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
367: l_error_text := FND_MESSAGE.GET;
368: l_error_code := 'E322';

Line 365: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));

361: END IF;
362:
363: IF l_unit_set_allowed = 'N' AND p_applinst_rec.unit_set_cd IS NOT NULL THEN
364: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
365: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
366: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
367: l_error_text := FND_MESSAGE.GET;
368: l_error_code := 'E322';
369: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 366: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

362:
363: IF l_unit_set_allowed = 'N' AND p_applinst_rec.unit_set_cd IS NOT NULL THEN
364: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
365: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
366: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
367: l_error_text := FND_MESSAGE.GET;
368: l_error_code := 'E322';
369: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
370: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 367: l_error_text := FND_MESSAGE.GET;

363: IF l_unit_set_allowed = 'N' AND p_applinst_rec.unit_set_cd IS NOT NULL THEN
364: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
365: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_PS_UNIT_SET'));
366: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
367: l_error_text := FND_MESSAGE.GET;
368: l_error_code := 'E322';
369: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
370: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
371: IF p_enable_log = 'Y' THEN

Line 378: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

374: RETURN FALSE;
375: END IF;
376:
377: IF l_fin_aid_allowed = 'N' AND p_applinst_rec.apply_for_finaid IS NOT NULL THEN
378: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
379: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIN_AID'));
380: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
381: l_error_text := FND_MESSAGE.GET;
382: l_error_code := 'E322';

Line 379: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIN_AID'));

375: END IF;
376:
377: IF l_fin_aid_allowed = 'N' AND p_applinst_rec.apply_for_finaid IS NOT NULL THEN
378: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
379: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIN_AID'));
380: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
381: l_error_text := FND_MESSAGE.GET;
382: l_error_code := 'E322';
383: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 380: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

376:
377: IF l_fin_aid_allowed = 'N' AND p_applinst_rec.apply_for_finaid IS NOT NULL THEN
378: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
379: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIN_AID'));
380: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
381: l_error_text := FND_MESSAGE.GET;
382: l_error_code := 'E322';
383: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
384: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 381: l_error_text := FND_MESSAGE.GET;

377: IF l_fin_aid_allowed = 'N' AND p_applinst_rec.apply_for_finaid IS NOT NULL THEN
378: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
379: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FIN_AID'));
380: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
381: l_error_text := FND_MESSAGE.GET;
382: l_error_code := 'E322';
383: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
384: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
385: IF p_enable_log = 'Y' THEN

Line 392: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

388: RETURN FALSE;
389: END IF;
390:
391: IF l_fee_cat_allowed = 'N' AND p_applinst_rec.fee_cat IS NOT NULL THEN
392: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
393: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_CAT'));
394: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
395: l_error_code := 'E322';
396: l_error_text := FND_MESSAGE.GET;

Line 393: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_CAT'));

389: END IF;
390:
391: IF l_fee_cat_allowed = 'N' AND p_applinst_rec.fee_cat IS NOT NULL THEN
392: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
393: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_CAT'));
394: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
395: l_error_code := 'E322';
396: l_error_text := FND_MESSAGE.GET;
397: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 394: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

390:
391: IF l_fee_cat_allowed = 'N' AND p_applinst_rec.fee_cat IS NOT NULL THEN
392: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
393: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_CAT'));
394: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
395: l_error_code := 'E322';
396: l_error_text := FND_MESSAGE.GET;
397: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
398: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 396: l_error_text := FND_MESSAGE.GET;

392: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
393: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FEE_CAT'));
394: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
395: l_error_code := 'E322';
396: l_error_text := FND_MESSAGE.GET;
397: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
398: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
399: IF p_enable_log = 'Y' THEN
400: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

Line 406: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

402: RETURN FALSE;
403: END IF;
404:
405: IF l_enrol_cat_allowed = 'N' AND p_applinst_rec.enrolment_cat IS NOT NULL THEN
406: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
407: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
408: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
409: l_error_text := FND_MESSAGE.GET;
410: l_error_code := 'E322';

Line 407: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));

403: END IF;
404:
405: IF l_enrol_cat_allowed = 'N' AND p_applinst_rec.enrolment_cat IS NOT NULL THEN
406: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
407: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
408: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
409: l_error_text := FND_MESSAGE.GET;
410: l_error_code := 'E322';
411: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 408: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

404:
405: IF l_enrol_cat_allowed = 'N' AND p_applinst_rec.enrolment_cat IS NOT NULL THEN
406: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
407: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
408: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
409: l_error_text := FND_MESSAGE.GET;
410: l_error_code := 'E322';
411: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
412: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 409: l_error_text := FND_MESSAGE.GET;

405: IF l_enrol_cat_allowed = 'N' AND p_applinst_rec.enrolment_cat IS NOT NULL THEN
406: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
407: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENROLMENT_CAT'));
408: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
409: l_error_text := FND_MESSAGE.GET;
410: l_error_code := 'E322';
411: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
412: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
413: IF p_enable_log = 'Y' THEN

Line 420: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

416: RETURN FALSE;
417: END IF;
418:
419: IF l_fund_src_allowed = 'N' AND p_applinst_rec.funding_source IS NOT NULL THEN
420: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
421: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
422: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
423: l_error_code := 'E322';
424: l_error_text := FND_MESSAGE.GET;

Line 421: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));

417: END IF;
418:
419: IF l_fund_src_allowed = 'N' AND p_applinst_rec.funding_source IS NOT NULL THEN
420: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
421: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
422: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
423: l_error_code := 'E322';
424: l_error_text := FND_MESSAGE.GET;
425: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 422: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

418:
419: IF l_fund_src_allowed = 'N' AND p_applinst_rec.funding_source IS NOT NULL THEN
420: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
421: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
422: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
423: l_error_code := 'E322';
424: l_error_text := FND_MESSAGE.GET;
425: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
426: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 424: l_error_text := FND_MESSAGE.GET;

420: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
421: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_FUNDING_SOURCE'));
422: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
423: l_error_code := 'E322';
424: l_error_text := FND_MESSAGE.GET;
425: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
426: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
427: IF p_enable_log = 'Y' THEN
428: igs_ad_imp_001.logerrormessage(p_applinst_rec.interface_ps_appl_inst_id,l_error_text,'IGS_AD_APPL_INST_INT');

Line 434: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

430: RETURN FALSE;
431: END IF;
432:
433: IF l_adv_std_allowed = 'N' AND p_applinst_rec.req_for_adv_standing_ind = 'Y' THEN
434: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
435: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REQ_ADV_STD_IND'));
436: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
437: l_error_text := FND_MESSAGE.GET;
438: l_error_code := 'E322';

Line 435: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REQ_ADV_STD_IND'));

431: END IF;
432:
433: IF l_adv_std_allowed = 'N' AND p_applinst_rec.req_for_adv_standing_ind = 'Y' THEN
434: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
435: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REQ_ADV_STD_IND'));
436: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
437: l_error_text := FND_MESSAGE.GET;
438: l_error_code := 'E322';
439: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 436: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

432:
433: IF l_adv_std_allowed = 'N' AND p_applinst_rec.req_for_adv_standing_ind = 'Y' THEN
434: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
435: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REQ_ADV_STD_IND'));
436: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
437: l_error_text := FND_MESSAGE.GET;
438: l_error_code := 'E322';
439: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
440: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 437: l_error_text := FND_MESSAGE.GET;

433: IF l_adv_std_allowed = 'N' AND p_applinst_rec.req_for_adv_standing_ind = 'Y' THEN
434: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
435: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_REQ_ADV_STD_IND'));
436: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
437: l_error_text := FND_MESSAGE.GET;
438: l_error_code := 'E322';
439: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
440: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
441: IF p_enable_log = 'Y' THEN

Line 448: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

444: RETURN FALSE;
445: END IF;
446:
447: IF l_int_acc_adv_no_allowed = 'N' AND p_applinst_rec.intrntnl_acceptance_advice_num IS NOT NULL THEN
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
449: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTRNL_ACC_ADV_NUM'));
450: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
451: l_error_text := FND_MESSAGE.GET;
452: l_error_code := 'E322';

Line 449: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTRNL_ACC_ADV_NUM'));

445: END IF;
446:
447: IF l_int_acc_adv_no_allowed = 'N' AND p_applinst_rec.intrntnl_acceptance_advice_num IS NOT NULL THEN
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
449: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTRNL_ACC_ADV_NUM'));
450: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
451: l_error_text := FND_MESSAGE.GET;
452: l_error_code := 'E322';
453: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 450: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

446:
447: IF l_int_acc_adv_no_allowed = 'N' AND p_applinst_rec.intrntnl_acceptance_advice_num IS NOT NULL THEN
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
449: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTRNL_ACC_ADV_NUM'));
450: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
451: l_error_text := FND_MESSAGE.GET;
452: l_error_code := 'E322';
453: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
454: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 451: l_error_text := FND_MESSAGE.GET;

447: IF l_int_acc_adv_no_allowed = 'N' AND p_applinst_rec.intrntnl_acceptance_advice_num IS NOT NULL THEN
448: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
449: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_INTRNL_ACC_ADV_NUM'));
450: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
451: l_error_text := FND_MESSAGE.GET;
452: l_error_code := 'E322';
453: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
454: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
455: IF p_enable_log = 'Y' THEN

Line 462: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_PREFNUM_NOTBE_SPECIFY');

458: RETURN FALSE;
459: END IF;
460:
461: IF l_pref_allowed = 'N' AND p_applinst_rec.preference_number IS NOT NULL THEN
462: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_PREFNUM_NOTBE_SPECIFY');
463: l_error_text := FND_MESSAGE.GET;
464: l_error_code := 'E322';
465: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
466: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 463: l_error_text := FND_MESSAGE.GET;

459: END IF;
460:
461: IF l_pref_allowed = 'N' AND p_applinst_rec.preference_number IS NOT NULL THEN
462: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_PREFNUM_NOTBE_SPECIFY');
463: l_error_text := FND_MESSAGE.GET;
464: l_error_code := 'E322';
465: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
466: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
467: IF p_enable_log = 'Y' THEN

Line 474: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

470: RETURN FALSE;
471: END IF;
472:
473: IF l_comp_yr_allowed = 'N' AND p_applinst_rec.expected_completion_yr IS NOT NULL THEN
474: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
475: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_YR'));
476: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
477: l_error_text := FND_MESSAGE.GET;
478: l_error_code := 'E322';

Line 475: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_YR'));

471: END IF;
472:
473: IF l_comp_yr_allowed = 'N' AND p_applinst_rec.expected_completion_yr IS NOT NULL THEN
474: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
475: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_YR'));
476: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
477: l_error_text := FND_MESSAGE.GET;
478: l_error_code := 'E322';
479: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 476: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

472:
473: IF l_comp_yr_allowed = 'N' AND p_applinst_rec.expected_completion_yr IS NOT NULL THEN
474: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
475: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_YR'));
476: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
477: l_error_text := FND_MESSAGE.GET;
478: l_error_code := 'E322';
479: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
480: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 477: l_error_text := FND_MESSAGE.GET;

473: IF l_comp_yr_allowed = 'N' AND p_applinst_rec.expected_completion_yr IS NOT NULL THEN
474: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
475: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_YR'));
476: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
477: l_error_text := FND_MESSAGE.GET;
478: l_error_code := 'E322';
479: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
480: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
481: IF p_enable_log = 'Y' THEN

Line 488: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');

484: RETURN FALSE;
485: END IF;
486:
487: IF l_comp_yr_allowed = 'N' AND p_applinst_rec.expected_completion_perd IS NOT NULL THEN
488: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
489: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
490: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
491: l_error_text := FND_MESSAGE.GET;
492: l_error_code := 'E322';

Line 489: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));

485: END IF;
486:
487: IF l_comp_yr_allowed = 'N' AND p_applinst_rec.expected_completion_perd IS NOT NULL THEN
488: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
489: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
490: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
491: l_error_text := FND_MESSAGE.GET;
492: l_error_code := 'E322';
493: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 490: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

486:
487: IF l_comp_yr_allowed = 'N' AND p_applinst_rec.expected_completion_perd IS NOT NULL THEN
488: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
489: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
490: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
491: l_error_text := FND_MESSAGE.GET;
492: l_error_code := 'E322';
493: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
494: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 491: l_error_text := FND_MESSAGE.GET;

487: IF l_comp_yr_allowed = 'N' AND p_applinst_rec.expected_completion_perd IS NOT NULL THEN
488: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
489: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_EXPCT_COMP_PRD'));
490: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
491: l_error_text := FND_MESSAGE.GET;
492: l_error_code := 'E322';
493: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
494: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
495: IF p_enable_log = 'Y' THEN

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

498: RETURN FALSE;
499: END IF;
500:
501: IF l_edu_goal_allowed = 'N' AND p_applinst_rec.edu_goal_prior_enroll_id IS NOT NULL THEN
502: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
503: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PRI_EN_EDU_GOAL'));
504: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
505: l_error_text := FND_MESSAGE.GET;
506: l_error_code := 'E322';

Line 503: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PRI_EN_EDU_GOAL'));

499: END IF;
500:
501: IF l_edu_goal_allowed = 'N' AND p_applinst_rec.edu_goal_prior_enroll_id IS NOT NULL THEN
502: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
503: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PRI_EN_EDU_GOAL'));
504: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
505: l_error_text := FND_MESSAGE.GET;
506: l_error_code := 'E322';
507: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',

Line 504: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);

500:
501: IF l_edu_goal_allowed = 'N' AND p_applinst_rec.edu_goal_prior_enroll_id IS NOT NULL THEN
502: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
503: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PRI_EN_EDU_GOAL'));
504: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
505: l_error_text := FND_MESSAGE.GET;
506: l_error_code := 'E322';
507: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
508: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);

Line 505: l_error_text := FND_MESSAGE.GET;

501: IF l_edu_goal_allowed = 'N' AND p_applinst_rec.edu_goal_prior_enroll_id IS NOT NULL THEN
502: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_NOT_APC_STEP');
503: FND_MESSAGE.SET_TOKEN('CATEGORY',FND_MESSAGE.GET_STRING('IGS','IGS_AD_PRI_EN_EDU_GOAL'));
504: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_admission_application_type);
505: l_error_text := FND_MESSAGE.GET;
506: l_error_code := 'E322';
507: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
508: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => l_error_code);
509: IF p_enable_log = 'Y' THEN

Line 601: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

597: l_error_code := 'E518';
598: p_status := 'U';
599: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
600: l_label :='igs.plsql.igs_ad_imp_004.create_application_details.exception '|| l_msg_data;
601: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
602: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);
603: fnd_message.set_token('ERROR_CD','E322');
604:
605: l_debug_str := fnd_message.get;

Line 602: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);

598: p_status := 'U';
599: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
600: l_label :='igs.plsql.igs_ad_imp_004.create_application_details.exception '|| l_msg_data;
601: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
602: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);
603: fnd_message.set_token('ERROR_CD','E322');
604:
605: l_debug_str := fnd_message.get;
606:

Line 603: fnd_message.set_token('ERROR_CD','E322');

599: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
600: l_label :='igs.plsql.igs_ad_imp_004.create_application_details.exception '|| l_msg_data;
601: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
602: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);
603: fnd_message.set_token('ERROR_CD','E322');
604:
605: l_debug_str := fnd_message.get;
606:
607: fnd_log.string_with_context( fnd_log.level_exception,

Line 605: l_debug_str := fnd_message.get;

601: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
602: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);
603: fnd_message.set_token('ERROR_CD','E322');
604:
605: l_debug_str := fnd_message.get;
606:
607: fnd_log.string_with_context( fnd_log.level_exception,
608: l_label,
609: l_debug_str, NULL,

Line 712: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

708: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
709: l_error_code := 'E518';
710: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
711: l_label :='igs.plsql.igs_ad_imp_004.update_application_details.exception '|| l_msg_data;
712: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
713: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);
714: fnd_message.set_token('ERROR_CD','E322');
715:
716: l_debug_str := fnd_message.get;

Line 713: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);

709: l_error_code := 'E518';
710: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
711: l_label :='igs.plsql.igs_ad_imp_004.update_application_details.exception '|| l_msg_data;
712: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
713: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);
714: fnd_message.set_token('ERROR_CD','E322');
715:
716: l_debug_str := fnd_message.get;
717:

Line 714: fnd_message.set_token('ERROR_CD','E322');

710: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
711: l_label :='igs.plsql.igs_ad_imp_004.update_application_details.exception '|| l_msg_data;
712: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
713: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);
714: fnd_message.set_token('ERROR_CD','E322');
715:
716: l_debug_str := fnd_message.get;
717:
718: fnd_log.string_with_context( fnd_log.level_exception,

Line 716: l_debug_str := fnd_message.get;

712: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
713: fnd_message.set_token('INTERFACE_ID',p_appl_rec.interface_appl_id);
714: fnd_message.set_token('ERROR_CD','E322');
715:
716: l_debug_str := fnd_message.get;
717:
718: fnd_log.string_with_context( fnd_log.level_exception,
719: l_label,
720: l_debug_str, NULL,

Line 989: FND_MESSAGE.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');

985: p_attribute39 => p_applinst_rec.attribute39,
986: p_attribute40 => p_applinst_rec.attribute40,
987: p_desc_flex_name => 'IGS_AD_APPL_INST_FLEX'
988: ) THEN
989: FND_MESSAGE.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');
990: l_error_text := FND_MESSAGE.get;
991: p_status := '3';
992: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
993: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => 'E322');

Line 990: l_error_text := FND_MESSAGE.get;

986: p_attribute40 => p_applinst_rec.attribute40,
987: p_desc_flex_name => 'IGS_AD_APPL_INST_FLEX'
988: ) THEN
989: FND_MESSAGE.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');
990: l_error_text := FND_MESSAGE.get;
991: p_status := '3';
992: update_appl_inst(p_admission_appl_number => NULL, p_match_ind => NULL, p_appl_inst_id => p_applinst_rec.interface_ps_appl_inst_id, p_status => '3',
993: p_error_text => l_error_text, p_sequence_number => NULL, p_error_code => 'E322');
994:

Line 1202: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_ASSIGNREQ_ERRM');

1198: p_error_text => l_error_text1,
1199: p_error_code => l_error_code1
1200: );
1201: IF l_error_code1 IS NOT NULL THEN
1202: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_ASSIGNREQ_ERRM');
1203: FND_MESSAGE.SET_TOKEN ('PERSON_ID', p_person_id);
1204: FND_MESSAGE.SET_TOKEN ('ADM_APPL_NUM', p_admission_Appl_number);
1205: FND_MESSAGE.SET_TOKEN ('NOMINATED_COURSE_CODE', p_applinst_rec.nominated_course_cd);
1206: FND_MESSAGE.SET_TOKEN ('SEQUENCE_NUMBER', l_acai_sequence_number);

Line 1203: FND_MESSAGE.SET_TOKEN ('PERSON_ID', p_person_id);

1199: p_error_code => l_error_code1
1200: );
1201: IF l_error_code1 IS NOT NULL THEN
1202: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_ASSIGNREQ_ERRM');
1203: FND_MESSAGE.SET_TOKEN ('PERSON_ID', p_person_id);
1204: FND_MESSAGE.SET_TOKEN ('ADM_APPL_NUM', p_admission_Appl_number);
1205: FND_MESSAGE.SET_TOKEN ('NOMINATED_COURSE_CODE', p_applinst_rec.nominated_course_cd);
1206: FND_MESSAGE.SET_TOKEN ('SEQUENCE_NUMBER', l_acai_sequence_number);
1207: FND_MESSAGE.SET_TOKEN ('ERROR_MESSAGE', l_error_text1);

Line 1204: FND_MESSAGE.SET_TOKEN ('ADM_APPL_NUM', p_admission_Appl_number);

1200: );
1201: IF l_error_code1 IS NOT NULL THEN
1202: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_ASSIGNREQ_ERRM');
1203: FND_MESSAGE.SET_TOKEN ('PERSON_ID', p_person_id);
1204: FND_MESSAGE.SET_TOKEN ('ADM_APPL_NUM', p_admission_Appl_number);
1205: FND_MESSAGE.SET_TOKEN ('NOMINATED_COURSE_CODE', p_applinst_rec.nominated_course_cd);
1206: FND_MESSAGE.SET_TOKEN ('SEQUENCE_NUMBER', l_acai_sequence_number);
1207: FND_MESSAGE.SET_TOKEN ('ERROR_MESSAGE', l_error_text1);
1208: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 1205: FND_MESSAGE.SET_TOKEN ('NOMINATED_COURSE_CODE', p_applinst_rec.nominated_course_cd);

1201: IF l_error_code1 IS NOT NULL THEN
1202: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_ASSIGNREQ_ERRM');
1203: FND_MESSAGE.SET_TOKEN ('PERSON_ID', p_person_id);
1204: FND_MESSAGE.SET_TOKEN ('ADM_APPL_NUM', p_admission_Appl_number);
1205: FND_MESSAGE.SET_TOKEN ('NOMINATED_COURSE_CODE', p_applinst_rec.nominated_course_cd);
1206: FND_MESSAGE.SET_TOKEN ('SEQUENCE_NUMBER', l_acai_sequence_number);
1207: FND_MESSAGE.SET_TOKEN ('ERROR_MESSAGE', l_error_text1);
1208: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1209:

Line 1206: FND_MESSAGE.SET_TOKEN ('SEQUENCE_NUMBER', l_acai_sequence_number);

1202: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_ASSIGNREQ_ERRM');
1203: FND_MESSAGE.SET_TOKEN ('PERSON_ID', p_person_id);
1204: FND_MESSAGE.SET_TOKEN ('ADM_APPL_NUM', p_admission_Appl_number);
1205: FND_MESSAGE.SET_TOKEN ('NOMINATED_COURSE_CODE', p_applinst_rec.nominated_course_cd);
1206: FND_MESSAGE.SET_TOKEN ('SEQUENCE_NUMBER', l_acai_sequence_number);
1207: FND_MESSAGE.SET_TOKEN ('ERROR_MESSAGE', l_error_text1);
1208: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1209:
1210: END IF;

Line 1207: FND_MESSAGE.SET_TOKEN ('ERROR_MESSAGE', l_error_text1);

1203: FND_MESSAGE.SET_TOKEN ('PERSON_ID', p_person_id);
1204: FND_MESSAGE.SET_TOKEN ('ADM_APPL_NUM', p_admission_Appl_number);
1205: FND_MESSAGE.SET_TOKEN ('NOMINATED_COURSE_CODE', p_applinst_rec.nominated_course_cd);
1206: FND_MESSAGE.SET_TOKEN ('SEQUENCE_NUMBER', l_acai_sequence_number);
1207: FND_MESSAGE.SET_TOKEN ('ERROR_MESSAGE', l_error_text1);
1208: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1209:
1210: END IF;
1211:

Line 1208: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1204: FND_MESSAGE.SET_TOKEN ('ADM_APPL_NUM', p_admission_Appl_number);
1205: FND_MESSAGE.SET_TOKEN ('NOMINATED_COURSE_CODE', p_applinst_rec.nominated_course_cd);
1206: FND_MESSAGE.SET_TOKEN ('SEQUENCE_NUMBER', l_acai_sequence_number);
1207: FND_MESSAGE.SET_TOKEN ('ERROR_MESSAGE', l_error_text1);
1208: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1209:
1210: END IF;
1211:
1212: --Assign Qualification Types to application instance being submitted **** Auto admit

Line 1248: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1244: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1245:
1246: l_label :='igs.plsql.igs_ad_imp_004.create_single_appl_instance.exception ';
1247: l_debug_str := 'Failed Creating Application instance'||l_msg_data;
1248: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1249: fnd_message.set_token('INTERFACE_ID',p_applinst_rec.interface_ps_appl_inst_id);
1250: fnd_message.set_token('ERROR_CD','E322');
1251:
1252: l_debug_str := fnd_message.get;

Line 1249: fnd_message.set_token('INTERFACE_ID',p_applinst_rec.interface_ps_appl_inst_id);

1245:
1246: l_label :='igs.plsql.igs_ad_imp_004.create_single_appl_instance.exception ';
1247: l_debug_str := 'Failed Creating Application instance'||l_msg_data;
1248: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1249: fnd_message.set_token('INTERFACE_ID',p_applinst_rec.interface_ps_appl_inst_id);
1250: fnd_message.set_token('ERROR_CD','E322');
1251:
1252: l_debug_str := fnd_message.get;
1253:

Line 1250: fnd_message.set_token('ERROR_CD','E322');

1246: l_label :='igs.plsql.igs_ad_imp_004.create_single_appl_instance.exception ';
1247: l_debug_str := 'Failed Creating Application instance'||l_msg_data;
1248: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1249: fnd_message.set_token('INTERFACE_ID',p_applinst_rec.interface_ps_appl_inst_id);
1250: fnd_message.set_token('ERROR_CD','E322');
1251:
1252: l_debug_str := fnd_message.get;
1253:
1254: fnd_log.string_with_context( fnd_log.level_exception,

Line 1252: l_debug_str := fnd_message.get;

1248: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1249: fnd_message.set_token('INTERFACE_ID',p_applinst_rec.interface_ps_appl_inst_id);
1250: fnd_message.set_token('ERROR_CD','E322');
1251:
1252: l_debug_str := fnd_message.get;
1253:
1254: fnd_log.string_with_context( fnd_log.level_exception,
1255: l_label,
1256: l_debug_str, NULL,

Line 1510: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

1506: l_error_code := 'E518';
1507: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1508: l_label :='igs.plsql.igs_ad_imp_004.Process_application_instance.exception '||l_msg_data;
1509:
1510: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1511: fnd_message.set_token('INTERFACE_ID',applinst_rec.interface_ps_appl_inst_id);
1512: fnd_message.set_token('ERROR_CD','E322');
1513:
1514: l_debug_str := fnd_message.get;

Line 1511: fnd_message.set_token('INTERFACE_ID',applinst_rec.interface_ps_appl_inst_id);

1507: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1508: l_label :='igs.plsql.igs_ad_imp_004.Process_application_instance.exception '||l_msg_data;
1509:
1510: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1511: fnd_message.set_token('INTERFACE_ID',applinst_rec.interface_ps_appl_inst_id);
1512: fnd_message.set_token('ERROR_CD','E322');
1513:
1514: l_debug_str := fnd_message.get;
1515:

Line 1512: fnd_message.set_token('ERROR_CD','E322');

1508: l_label :='igs.plsql.igs_ad_imp_004.Process_application_instance.exception '||l_msg_data;
1509:
1510: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1511: fnd_message.set_token('INTERFACE_ID',applinst_rec.interface_ps_appl_inst_id);
1512: fnd_message.set_token('ERROR_CD','E322');
1513:
1514: l_debug_str := fnd_message.get;
1515:
1516: fnd_log.string_with_context( fnd_log.level_exception,

Line 1514: l_debug_str := fnd_message.get;

1510: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1511: fnd_message.set_token('INTERFACE_ID',applinst_rec.interface_ps_appl_inst_id);
1512: fnd_message.set_token('ERROR_CD','E322');
1513:
1514: l_debug_str := fnd_message.get;
1515:
1516: fnd_log.string_with_context( fnd_log.level_exception,
1517: l_label,
1518: l_debug_str, NULL,