APPS.IGS_AD_AC_COMP dependencies on FND_MESSAGE

Line 170: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_ITM_NT_CMPLT');

166:
167: -- p_message_name = 'Application completion status cannot be updated to satisfied since the tracking item/s are not yet complete'
168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
170: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_ITM_NT_CMPLT');
171: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
172:
173: RETURN;
174:

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

167: -- p_message_name = 'Application completion status cannot be updated to satisfied since the tracking item/s are not yet complete'
168: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
169: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
170: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_TR_ITM_NT_CMPLT');
171: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
172:
173: RETURN;
174:
175: ELSE

Line 321: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CMPLT_STAT_UPD');

317:
318: -- p_message_name = 'Application completion status for the application updated to SATISFIED';
319: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
320: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
321: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CMPLT_STAT_UPD');
322: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
323:
324: END IF;
325:

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

318: -- p_message_name = 'Application completion status for the application updated to SATISFIED';
319: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Person Id :'||p_person_id||' Admission Application Number :'||p_admission_appl_number);
320: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Course Code :' ||p_course_cd ||' Sequence Number :'||p_sequence_number);
321: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_CMPLT_STAT_UPD');
322: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
323:
324: END IF;
325:
326: EXCEPTION

Line 334: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);

330: --Loop through the messages in stack to check if there is Security Policy exception already set or not. Ref: Bug 3919112
331: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
332: WHILE l_sc_msg_count <> 0 LOOP
333: igs_ge_msg_stack.get(l_sc_msg_count, 'T', l_sc_encoded_text, l_sc_msg_index);
334: fnd_message.parse_encoded(l_sc_encoded_text, l_sc_app_short_name, l_sc_message_name);
335: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
336: --print the the security exception in log file and return.
337: fnd_file.put_line( fnd_file.log, 'Error occured while processing the Application instance with Person Id: '||p_person_id||', Admission Application Number: '||p_admission_appl_number||
338: ', Course Code: ' ||p_course_cd ||' and Sequence Number: '||p_sequence_number);

Line 339: fnd_message.set_encoded(l_sc_encoded_text);

335: IF l_sc_message_name = 'IGS_SC_POLICY_EXCEPTION' OR l_sc_message_name = 'IGS_SC_POLICY_UPD_DEL_EXCEP' THEN
336: --print the the security exception in log file and return.
337: fnd_file.put_line( fnd_file.log, 'Error occured while processing the Application instance with Person Id: '||p_person_id||', Admission Application Number: '||p_admission_appl_number||
338: ', Course Code: ' ||p_course_cd ||' and Sequence Number: '||p_sequence_number);
339: fnd_message.set_encoded(l_sc_encoded_text);
340: fnd_file.put_line( fnd_file.log, fnd_message.get());
341: fnd_file.put_line( fnd_file.log, ' ');
342: RETURN;
343: END IF;

Line 340: fnd_file.put_line( fnd_file.log, fnd_message.get());

336: --print the the security exception in log file and return.
337: fnd_file.put_line( fnd_file.log, 'Error occured while processing the Application instance with Person Id: '||p_person_id||', Admission Application Number: '||p_admission_appl_number||
338: ', Course Code: ' ||p_course_cd ||' and Sequence Number: '||p_sequence_number);
339: fnd_message.set_encoded(l_sc_encoded_text);
340: fnd_file.put_line( fnd_file.log, fnd_message.get());
341: fnd_file.put_line( fnd_file.log, ' ');
342: RETURN;
343: END IF;
344: l_sc_msg_count := l_sc_msg_count - 1;

Line 476: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_COM_PRMS');

472: ERRBUF := NULL;
473: lv_status := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
474: lv_sql_stmt := igs_pe_dynamic_persid_group.get_dynamic_sql(p_person_id_group,lv_status,lv_group_type);
475: -- Log the Initial parameters into the LOG file.
476: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_COM_PRMS');
477: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);

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

473: lv_status := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
474: lv_sql_stmt := igs_pe_dynamic_persid_group.get_dynamic_sql(p_person_id_group,lv_status,lv_group_type);
475: -- Log the Initial parameters into the LOG file.
476: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_COM_PRMS');
477: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');

475: -- Log the Initial parameters into the LOG file.
476: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_COM_PRMS');
477: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
482:
483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');

Line 480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);

476: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_COM_PRMS');
477: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
482:
483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);

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

477: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
478:
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
482:
483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');

479: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID');
480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
482:
483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
486:
487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');

Line 484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);

480: FND_MESSAGE.SET_TOKEN('PID', p_person_id);
481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
482:
483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
486:
487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);

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

481: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
482:
483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
486:
487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');

483: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_PID_GRP');
484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
486:
487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
490:
491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');

Line 488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);

484: FND_MESSAGE.SET_TOKEN('PGPID', p_person_id_group);
485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
486:
487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
490:
491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);

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

485: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
486:
487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
490:
491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');

487: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_ADM_APLNO');
488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
490:
491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
494:
495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');

Line 492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);

488: FND_MESSAGE.SET_TOKEN('APLNO', p_admission_appl_number);
489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
490:
491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
494:
495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);

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

489: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
490:
491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
494:
495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');

491: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CRCD');
492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
494:
495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
498:
499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');

Line 496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);

492: FND_MESSAGE.SET_TOKEN('CRCD', p_course_cd);
493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
494:
495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
498:
499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);

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

493: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
494:
495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
498:
499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');

495: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APP_SEQNO');
496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
498:
499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
502:
503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');

Line 500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);

496: FND_MESSAGE.SET_TOKEN('SEQNO', p_sequence_number);
497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
498:
499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
502:
503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
504: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);

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

497: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
498:
499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
502:
503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
504: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
505: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());

Line 503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');

499: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_CL_DTLS');
500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
502:
503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
504: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
505: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
506:
507: -- CASE 1 :

Line 504: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);

500: FND_MESSAGE.SET_TOKEN('CLDTLS', p_calendar_details);
501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
502:
503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
504: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
505: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
506:
507: -- CASE 1 :
508: -- If the parameters p_person_id, p_admission_appl_number, p_course_cd and p_sequence_number are entered

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

501: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
502:
503: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_LG_APC');
504: FND_MESSAGE.SET_TOKEN('APC', p_admission_process_category);
505: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
506:
507: -- CASE 1 :
508: -- If the parameters p_person_id, p_admission_appl_number, p_course_cd and p_sequence_number are entered
509: IF p_person_id IS NOT NULL AND

Line 538: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');

534: -- If the Applicaiton records are not found then log a message
535: IF l_records_not_found THEN
536: -- Tracking steps cannot be completed for applications not having application completion status of pending
537: -- and application outcome status of pending or conditional offer
538: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
539: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
540:
541: -- Abort the process and raise error
542: RETURN;

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

535: IF l_records_not_found THEN
536: -- Tracking steps cannot be completed for applications not having application completion status of pending
537: -- and application outcome status of pending or conditional offer
538: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
539: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
540:
541: -- Abort the process and raise error
542: RETURN;
543:

Line 576: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');

572: -- If the Applicaiton records are not found then log a message
573: IF l_records_not_found THEN
574: -- Tracking steps cannot be completed for applications not having application completion status of pending
575: -- and application outcome status of pending or conditional offer
576: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
577: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
578:
579: -- Abort the process and raise error
580: RETURN;

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

573: IF l_records_not_found THEN
574: -- Tracking steps cannot be completed for applications not having application completion status of pending
575: -- and application outcome status of pending or conditional offer
576: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
577: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
578:
579: -- Abort the process and raise error
580: RETURN;
581:

Line 675: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');

671: -- If the Applicaiton records are not found then log a message
672: IF l_records_not_found THEN
673: -- Tracking steps cannot be completed for applications not having application completion status of pending
674: -- and application outcome status of pending or conditional offer
675: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
676: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
677:
678: -- Abort the process and raise error
679: RETURN;

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

672: IF l_records_not_found THEN
673: -- Tracking steps cannot be completed for applications not having application completion status of pending
674: -- and application outcome status of pending or conditional offer
675: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
676: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
677:
678: -- Abort the process and raise error
679: RETURN;
680: END IF;

Line 685: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');

681:
682: END IF;
683: EXCEPTION
684: WHEN OTHERS THEN
685: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
686: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
687: FND_FILE.PUT_LINE (FND_FILE.LOG,lv_sql_stmt);
688: END;
689:

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

682: END IF;
683: EXCEPTION
684: WHEN OTHERS THEN
685: FND_MESSAGE.SET_NAME ('IGF','IGF_AP_INVALID_QUERY');
686: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
687: FND_FILE.PUT_LINE (FND_FILE.LOG,lv_sql_stmt);
688: END;
689:
690: ELSE

Line 691: FND_MESSAGE.SET_NAME ('IGS',' IGS_AZ_DYN_PERS_ID_GRP_ERR');

687: FND_FILE.PUT_LINE (FND_FILE.LOG,lv_sql_stmt);
688: END;
689:
690: ELSE
691: FND_MESSAGE.SET_NAME ('IGS',' IGS_AZ_DYN_PERS_ID_GRP_ERR');
692: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
693: END IF;
694:
695: -- CASE 4 :

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

688: END;
689:
690: ELSE
691: FND_MESSAGE.SET_NAME ('IGS',' IGS_AZ_DYN_PERS_ID_GRP_ERR');
692: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.GET);
693: END IF;
694:
695: -- CASE 4 :
696: -- In case the academic calendar, admission process category and admission calendar are

Line 739: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');

735: -- If the Applicaiton records are not found then log a message
736: IF l_records_not_found THEN
737: -- Tracking steps cannot be completed for applications not having application completion status of pending
738: -- and application outcome status of pending or conditional offer
739: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
740: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
741:
742: -- Abort the process and raise error
743: RETURN;

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

736: IF l_records_not_found THEN
737: -- Tracking steps cannot be completed for applications not having application completion status of pending
738: -- and application outcome status of pending or conditional offer
739: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_PEND_STAT');
740: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
741:
742: -- Abort the process and raise error
743: RETURN;
744:

Line 759: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_ALL_PRM_NULL');

755: p_sequence_number IS NULL
756: THEN
757:
758: -- Message ( 'All the parameters are null. The process cannot be run')
759: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_ALL_PRM_NULL');
760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
761: RETURN;
762:
763: -- CASE 6 :

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

756: THEN
757:
758: -- Message ( 'All the parameters are null. The process cannot be run')
759: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_ALL_PRM_NULL');
760: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
761: RETURN;
762:
763: -- CASE 6 :
764: -- In case if the parameters are not in proper combination.

Line 769: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_INV_PRM_COMB');

765: -- OR some improper combination
766: ELSE
767: -- 'Invalid parameters entered. Valid combinations for parameters to be entered is Person ID OR Person Group ID OR Person ID,
768: -- Admission Application Number, Program Code, Sequence Number OR Academic Calendar, Admission Calendar, Admission Process Category'
769: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_INV_PRM_COMB');
770: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
771: RETURN;
772:
773: END IF;

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

766: ELSE
767: -- 'Invalid parameters entered. Valid combinations for parameters to be entered is Person ID OR Person Group ID OR Person ID,
768: -- Admission Application Number, Program Code, Sequence Number OR Academic Calendar, Admission Calendar, Admission Process Category'
769: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_APP_INV_PRM_COMB');
770: FND_FILE.PUT_LINE( FND_FILE.LOG, FND_MESSAGE.GET());
771: RETURN;
772:
773: END IF;
774:

Line 779: ERRBUF := fnd_message.get_string( 'IGS', 'IGS_GE_UNHANDLED_EXCEPTION');

775: EXCEPTION
776: WHEN OTHERS THEN
777: ROLLBACK;
778: RETCODE := 2;
779: ERRBUF := fnd_message.get_string( 'IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
780: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
781:
782: END upd_apl_cmp_st;
783: