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_ADM_REQ dependencies on IGS_GE_NUMBER

Line 275: l_acad_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));

271: --
272: -- Split the calendar details and the admission process category into seperate variables
273: --
274: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
275: l_acad_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
276: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
277: l_adm_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));
278:
279: -- Do not change SUBSTR position for APC param in code and SEED

Line 277: l_adm_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

273: --
274: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
275: l_acad_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
276: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
277: l_adm_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));
278:
279: -- Do not change SUBSTR position for APC param in code and SEED
280: -- since the same value set is used in value set IGS_SRS_AD_PERSON_ID_COMPLETE
281: l_admission_cat := RTRIM ( SUBSTR ( p_admission_process_category, 1, 10));

Line 298: OPEN c_get_person_number(IGS_GE_NUMBER.TO_CANN (assn_adm_pro_rec.person_id));

294: --
295: -- For Each Record Selected Do The Following
296: --
297:
298: OPEN c_get_person_number(IGS_GE_NUMBER.TO_CANN (assn_adm_pro_rec.person_id));
299: FETCH c_get_person_number INTO l_get_person_number;
300: CLOSE c_get_person_number;
301:
302: log_detail( FND_GLOBAL.NEWLINE );

Line 305: ' Admission Application Number :: ' || IGS_GE_NUMBER.TO_CANN (assn_adm_pro_rec.admission_appl_number ) );

301:
302: log_detail( FND_GLOBAL.NEWLINE );
303: log_detail( ' Application Instance Information ' );
304: log_detail( ' Person Number :: ' || RPAD(l_get_person_number,30) ||
305: ' Admission Application Number :: ' || IGS_GE_NUMBER.TO_CANN (assn_adm_pro_rec.admission_appl_number ) );
306: log_detail( ' Program Code :: ' || RPAD(assn_adm_pro_rec.nominated_course_cd,30) ||
307: ' Sequence Number :: ' || IGS_GE_NUMBER.TO_CANN ( assn_adm_pro_rec.sequence_number ) );
308: IF NOT crt_adm_trk_itm(
309: p_person_id => assn_adm_pro_rec.person_id,

Line 307: ' Sequence Number :: ' || IGS_GE_NUMBER.TO_CANN ( assn_adm_pro_rec.sequence_number ) );

303: log_detail( ' Application Instance Information ' );
304: log_detail( ' Person Number :: ' || RPAD(l_get_person_number,30) ||
305: ' Admission Application Number :: ' || IGS_GE_NUMBER.TO_CANN (assn_adm_pro_rec.admission_appl_number ) );
306: log_detail( ' Program Code :: ' || RPAD(assn_adm_pro_rec.nominated_course_cd,30) ||
307: ' Sequence Number :: ' || IGS_GE_NUMBER.TO_CANN ( assn_adm_pro_rec.sequence_number ) );
308: IF NOT crt_adm_trk_itm(
309: p_person_id => assn_adm_pro_rec.person_id,
310: p_admission_appl_number => assn_adm_pro_rec.admission_appl_number,
311: p_program_code => assn_adm_pro_rec.nominated_course_cd,

Line 333: OPEN c_get_person_number(IGS_GE_NUMBER.TO_CANN (assn_post_adm_rec.person_id));

329: --
330: -- For Each Record Selected Do The Following
331: --
332:
333: OPEN c_get_person_number(IGS_GE_NUMBER.TO_CANN (assn_post_adm_rec.person_id));
334: FETCH c_get_person_number INTO l_get_person_number;
335: CLOSE c_get_person_number;
336:
337:

Line 341: ' Admission Application Number :: ' || IGS_GE_NUMBER.TO_CANN (assn_post_adm_rec.admission_appl_number ) );

337:
338: log_detail( FND_GLOBAL.NEWLINE );
339: log_detail( ' Application Instance Information ' );
340: log_detail( ' Person Number :: ' || RPAD(l_get_person_number,30) ||
341: ' Admission Application Number :: ' || IGS_GE_NUMBER.TO_CANN (assn_post_adm_rec.admission_appl_number ) );
342: log_detail( ' Program Code :: ' || RPAD(assn_post_adm_rec.nominated_course_cd,30) ||
343: ' Sequence Number :: ' || IGS_GE_NUMBER.TO_CANN ( assn_post_adm_rec.sequence_number ) );
344: IF NOT crt_adm_trk_itm(
345: p_person_id => assn_post_adm_rec.person_id,

Line 343: ' Sequence Number :: ' || IGS_GE_NUMBER.TO_CANN ( assn_post_adm_rec.sequence_number ) );

339: log_detail( ' Application Instance Information ' );
340: log_detail( ' Person Number :: ' || RPAD(l_get_person_number,30) ||
341: ' Admission Application Number :: ' || IGS_GE_NUMBER.TO_CANN (assn_post_adm_rec.admission_appl_number ) );
342: log_detail( ' Program Code :: ' || RPAD(assn_post_adm_rec.nominated_course_cd,30) ||
343: ' Sequence Number :: ' || IGS_GE_NUMBER.TO_CANN ( assn_post_adm_rec.sequence_number ) );
344: IF NOT crt_adm_trk_itm(
345: p_person_id => assn_post_adm_rec.person_id,
346: p_admission_appl_number => assn_post_adm_rec.admission_appl_number,
347: p_program_code => assn_post_adm_rec.nominated_course_cd,

Line 601: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN ( l_tracking_id) ||' for tracking type :: ' || p_tracking_type);

597: -- Process completed successfully tracking items
598: -- created for the Application Instances entered
599: --
600: log_detail(FND_MESSAGE.GET_STRING ( 'IGS', 'IGS_AD_PROC_ASSIGN_REQ_COMP'));
601: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN ( l_tracking_id) ||' for tracking type :: ' || p_tracking_type);
602:
603: ELSE
604: log_detail('Failed to create the tracking item link to admission application instance');
605: log_detail('for the tracking item :: ' || IGS_GE_NUMBER.TO_CANN (l_tracking_id) ||', please create it manually');

Line 605: log_detail('for the tracking item :: ' || IGS_GE_NUMBER.TO_CANN (l_tracking_id) ||', please create it manually');

601: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN ( l_tracking_id) ||' for tracking type :: ' || p_tracking_type);
602:
603: ELSE
604: log_detail('Failed to create the tracking item link to admission application instance');
605: log_detail('for the tracking item :: ' || IGS_GE_NUMBER.TO_CANN (l_tracking_id) ||', please create it manually');
606: END IF;
607: EXCEPTION
608: WHEN OTHERS THEN
609: log_detail('Failed to create the tracking item link to admission application instance');

Line 610: log_detail('for the tracking item :: ' || IGS_GE_NUMBER.TO_CANN (l_tracking_id) ||', please create it manually');

606: END IF;
607: EXCEPTION
608: WHEN OTHERS THEN
609: log_detail('Failed to create the tracking item link to admission application instance');
610: log_detail('for the tracking item :: ' || IGS_GE_NUMBER.TO_CANN (l_tracking_id) ||', please create it manually');
611: END;
612: ELSE
613: log_detail('Failed to create the tracking item for the admission application instance');
614: log_detail('For the tracking type :: ' || p_tracking_type);

Line 694: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||

690: FOR check_existence_rec IN check_existence_cur LOOP
691: igs_ad_aplins_admreq_pkg.delete_row ( check_existence_rec.rowid);
692: IF igs_tr_gen_002.trkp_del_tri ( check_existence_rec.tracking_id, l_message_name) THEN
693: log_detail(FND_MESSAGE.GET_STRING( 'IGS', 'IGS_AD_TRAC_NOT_REQ_DELETED'));
694: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||
695: ' of tracking type :: ' || check_existence_rec.tracking_type);
696: ELSE
697: log_detail(FND_MESSAGE.GET_STRING( 'IGS', l_message_name));
698: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||

Line 698: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||

694: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||
695: ' of tracking type :: ' || check_existence_rec.tracking_type);
696: ELSE
697: log_detail(FND_MESSAGE.GET_STRING( 'IGS', l_message_name));
698: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||
699: ' of tracking type :: ' || check_existence_rec.tracking_type);
700: ROLLBACK TO sp_trkitm_aplproc;
701: RETURN FALSE;
702: END IF;

Line 794: log_detail('Tracking item :: '|| IGS_GE_NUMBER.TO_CANN(check_duplicate_cur_rec.tracking_id) ||

790: p_completion_due_dt => trk_comp_dt.alias_val
791: );
792: ELSE
793: CLOSE check_duplicate_cur;
794: log_detail('Tracking item :: '|| IGS_GE_NUMBER.TO_CANN(check_duplicate_cur_rec.tracking_id) ||
795: ' for tracking type :: ' || l_trk_types_final(k) ||
796: ' already exist with closed or bypassed steps, hence not recreating');
797: END IF;
798: END LOOP;