DBA Data[Home] [Help]

APPS.IGS_OR_PRC_CWLK dependencies on FND_MESSAGE

Line 113: FND_MESSAGE.Set_Name('IGS',

109: x_institution_code => NULL,
110: x_institution_name => cwlkrec.institution_name);
111:
112: -- Log appropriate messages in the Log file of the Concurrent Manager
113: FND_MESSAGE.Set_Name('IGS',
114: 'IGS_OR_IMP_INST_NAME');
115: FND_MESSAGE.Set_Token('INST_NAME',
116: cwlkrec.institution_name);
117: FND_FILE.Put_Line(FND_FILE.Log,

Line 115: FND_MESSAGE.Set_Token('INST_NAME',

111:
112: -- Log appropriate messages in the Log file of the Concurrent Manager
113: FND_MESSAGE.Set_Name('IGS',
114: 'IGS_OR_IMP_INST_NAME');
115: FND_MESSAGE.Set_Token('INST_NAME',
116: cwlkrec.institution_name);
117: FND_FILE.Put_Line(FND_FILE.Log,
118: FND_MESSAGE.Get);
119:

Line 118: FND_MESSAGE.Get);

114: 'IGS_OR_IMP_INST_NAME');
115: FND_MESSAGE.Set_Token('INST_NAME',
116: cwlkrec.institution_name);
117: FND_FILE.Put_Line(FND_FILE.Log,
118: FND_MESSAGE.Get);
119:
120: -- Loop through the Crosswalk Detail Interface table based on the
121: -- Crosswalk Id passed from the Crosswalk Interface table(previous cursor)
122:

Line 129: FND_MESSAGE.Set_Name('IGS',

125: -- Check if the Alt_Id_Type exists in the IGS_OR_ORG_ALT_IDTYP table
126: IF NOT validate_alt_id(cwlkdtlrec.alt_id_type) THEN
127:
128: -- If it does not exist, then log the appropriate message in the Concurrent Manager logfile
129: FND_MESSAGE.Set_Name('IGS',
130: 'IGS_OR_INVALID_ALT_ID_TYP');
131: FND_MESSAGE.Set_Token('ALT_ID_TYPE',
132: cwlkdtlrec.alt_id_type);
133: FND_FILE.Put_Line(FND_FILE.Log,

Line 131: FND_MESSAGE.Set_Token('ALT_ID_TYPE',

127:
128: -- If it does not exist, then log the appropriate message in the Concurrent Manager logfile
129: FND_MESSAGE.Set_Name('IGS',
130: 'IGS_OR_INVALID_ALT_ID_TYP');
131: FND_MESSAGE.Set_Token('ALT_ID_TYPE',
132: cwlkdtlrec.alt_id_type);
133: FND_FILE.Put_Line(FND_FILE.Log,
134: FND_MESSAGE.Get);
135:

Line 134: FND_MESSAGE.Get);

130: 'IGS_OR_INVALID_ALT_ID_TYP');
131: FND_MESSAGE.Set_Token('ALT_ID_TYPE',
132: cwlkdtlrec.alt_id_type);
133: FND_FILE.Put_Line(FND_FILE.Log,
134: FND_MESSAGE.Get);
135:
136: -- Raise the exception so that the record can be updated to Status 3
137: APP_EXCEPTION.RAISE_EXCEPTION;
138: END IF;

Line 163: FND_MESSAGE.Get || ' ' || l_in_proc_alt_id || '-' || l_in_proc_alt_value);

159: -- Concurrent Manager's log file.Set the Exception variable
160: -- to TRUE for appropriate updation of the Interface record
161: ROLLBACK TO sp_record;
162: FND_FILE.Put_Line(FND_FILE.Log,
163: FND_MESSAGE.Get || ' ' || l_in_proc_alt_id || '-' || l_in_proc_alt_value);
164: l_exception := TRUE;
165: END;
166:
167: -- If the Exception variable is set to True, then update the status variable to error