APPS.IGS_OR_INST_IMP_001 dependencies on FND_LOG

Line 20: -- 1. Logging mechanism introduced, FND_FILE.PUT_LINE replaced with methods in FND_LOG package

16: -- Modified the validation for INST_PRIORITY_CODE_ID, GOVT_INSTITUTION_CD, INST_CONTROL_TYPE to refer
17: -- the new lookups instead of the tables.
18: -- ssawhney 2nd jan No of updates reduced, performance tuning done, gather stats function used.
19: -- ssaleem 24-SEP-03 The following changes have been done for IGS.L
20: -- 1. Logging mechanism introduced, FND_FILE.PUT_LINE replaced with methods in FND_LOG package
21: -- log writer procedure modified for this purpose and package level variables declared, intialised
22: -- to control logging.
23: -- 2. Cursors that utilise variables in SELECT statements are replaced with cursor parameters
24: -- 3. Gather statistics done for IGS_OR_ADRUSGE_INT table

Line 53: FND_LOG.STRING_WITH_CONTEXT (fnd_log.level_exception,

49:
50: FND_MESSAGE.SET_NAME('IGS','IGS_OR_INST_IMP_FAIL');
51: FND_MESSAGE.SET_TOKEN('INT_ID',p_which_rec);
52: FND_MESSAGE.SET_TOKEN('ERROR_CODE',v_error_log.linex);
53: FND_LOG.STRING_WITH_CONTEXT (fnd_log.level_exception,
54: 'igs.plsql.igs_or_inst_imp_001.imp_or_institution.' || p_error_code,
55: fnd_message.get || '-' || p_error_text,NULL,NULL,NULL,NULL,NULL,g_request_id);
56:
57: END log_writer;

Line 230: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_001') THEN

226: l_owner VARCHAR2(30);
227:
228: BEGIN
229:
230: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_001') THEN
231: gb_write_exception_log1 := TRUE;
232: ELSE
233: gb_write_exception_log1 := FALSE;
234: END IF;

Line 236: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_002') THEN

232: ELSE
233: gb_write_exception_log1 := FALSE;
234: END IF;
235:
236: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_002') THEN
237: gb_write_exception_log2 := TRUE;
238: ELSE
239: gb_write_exception_log2 := FALSE;
240: END IF;

Line 242: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_003') THEN

238: ELSE
239: gb_write_exception_log2 := FALSE;
240: END IF;
241:
242: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_003') THEN
243: gb_write_exception_log3 := TRUE;
244: ELSE
245: gb_write_exception_log3 := FALSE;
246: END IF;

Line 305: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_001') THEN

301: );
302: EXCEPTION
303: WHEN OTHERS THEN
304: retcode := 2;
305: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_001') THEN
306: fnd_log.string_with_context (fnd_log.level_exception,
307: 'igs.plsql.igs_or_inst_imp_001.imp_or_institution.MainProc',
308: ' ' || SQLERRM,NULL,NULL,NULL,NULL,NULL,g_request_id);
309: END IF;

Line 306: fnd_log.string_with_context (fnd_log.level_exception,

302: EXCEPTION
303: WHEN OTHERS THEN
304: retcode := 2;
305: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_001') THEN
306: fnd_log.string_with_context (fnd_log.level_exception,
307: 'igs.plsql.igs_or_inst_imp_001.imp_or_institution.MainProc',
308: ' ' || SQLERRM,NULL,NULL,NULL,NULL,NULL,g_request_id);
309: END IF;
310:

Line 987: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

983:
984: EXCEPTION
985: WHEN OTHERS THEN
986: IF gb_write_exception_log1 THEN
987: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
988: 'igs.plsql.igs_or_inst_imp_001.simplealtidcomp.others',
989: SQLERRM, NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
990: END IF;
991: APP_EXCEPTION.Raise_Exception;

Line 1486: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

1482:
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: IF gb_write_exception_log1 THEN
1486: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
1487: 'igs.plsql.igs_or_inst_imp_001.exactAltidcomp.others',
1488: SQLERRM, NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
1489: END IF;
1490: APP_EXCEPTION.Raise_Exception;

Line 2048: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

2044:
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: IF gb_write_exception_log1 THEN
2048: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
2049: 'igs.plsql.igs_or_inst_imp_001.numericAltidcomp.others',
2050: SQLERRM, NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
2051: END IF;
2052: APP_EXCEPTION.Raise_Exception;

Line 2608: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,

2604:
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: IF gb_write_exception_log1 THEN
2608: FND_LOG.STRING_WITH_CONTEXT (FND_LOG.LEVEL_EXCEPTION,
2609: 'igs.plsql.igs_or_inst_imp_001.delete_log_int_rec.others',
2610: SQLERRM, NULL,NULL,NULL,NULL,NULL, IGS_OR_INST_IMP_001.G_REQUEST_ID);
2611: END IF;
2612: APP_EXCEPTION.Raise_Exception;