DBA Data[Home] [Help]

APPS.IGS_AD_IMP_PRBLTY_VAL_PKG dependencies on FND_FILE

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

219:
220: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
221: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
222: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
223: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
224: RAISE skip_this_record;
225: END IF;
226: CLOSE person_id_cur;
227: END IF;

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

238:
239: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
240: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
241: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
242: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
243: RAISE skip_this_record;
244: END IF;
245:
246: --Check whether its a duplicate record

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

319:
320: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
321: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
322: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
323: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
324: RAISE skip_this_record;
325: END;
326:
327: ELSE -- Error_code is not NULL after validation.

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

334:
335: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
336: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
337: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
338: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
339: RAISE skip_this_record;
340: END IF; --error_code comparision
341:
342: ELSE -- If match_ind <> '21' then make the status 'Error'

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

350:
351: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
352: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
353: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
354: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
355: RAISE skip_this_record;
356:
357:
358: END IF; --match_ind comparision

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

398:
399: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
400: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
401: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
402: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
403: RAISE skip_this_record;
404: END;
405: ELSE -- Error_code is not NULL after validation.
406: -- Make the status 'Error' and error_code as obtained after validation

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

412:
413: FND_MESSAGE.SET_NAME('IGS','IGS_AD_PRBLTY_VALUE_ERROR');
414: FND_MESSAGE.SET_TOKEN('PRBLTY_VAL_INT_ID',prblty_val_rec.prblty_val_int_id);
415: FND_MESSAGE.SET_TOKEN('ERROR_CODE',l_error_code);
416: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
417: RAISE skip_this_record;
418: END IF; --error_code comparision
419:
420: END IF; --duplicate record check condition

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

437:
438: --Display the no of records processed in the log File
439: FND_MESSAGE.SET_NAME('IGS','IGS_AD_TOT_REC_PRC');
440: FND_MESSAGE.SET_TOKEN('RCOUNT',l_records_processed);
441: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: ROLLBACK;