APPS.IGS_AD_IMP_023 dependencies on FND_LOG

Line 201: || pkpatel 18-DEC-2003 Bug 3091707 (Moved the log messages from FND_FILE to FND_LOG_REPOSITORY)

197: || Known limitations, enhancements or remarks : Uses REF cursor for checking the Detail
198: || Level Discrepancy Rule.
199: || Change History :
200: || Who When What
201: || pkpatel 18-DEC-2003 Bug 3091707 (Moved the log messages from FND_FILE to FND_LOG_REPOSITORY)
202: || gmaheswa 23-Feb-2006 Stubbed and created a new overloaded function. as part of literal usage fix.
203: || (reverse chronological order - newest change first)
204: */
205:

Line 242: -- Variables for FND logging

238: l_interface_sql VARCHAR2(2000);
239: l_ad_column_null NUMBER(1) :=0;
240: l_int_column_null NUMBER(1) :=0;
241:
242: -- Variables for FND logging
243: l_request_id NUMBER(15) := fnd_global.conc_request_id;
244: l_prog_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_002.prc_pe_dtls';
245: l_label VARCHAR2(100) := 'igs.plsql.igs_ad_imp_023.find_detail_discrepancy_rule.';
246: l_debug_str VARCHAR2(10000);

Line 313: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

309:
310: IF (l_ad_column_null = 1 AND l_int_column_null <> 1) OR (l_ad_column_null <> 1 AND l_int_column_null = 1) THEN
311:
312: -- Discrepancy exists, match indicator for this record should be updated to '20'.
313: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
314:
315: l_label := l_label || 'discpNULL';
316: l_debug_str := p_int_pk_col_name||' = '|| p_int_pk_col_val || ' Discrepancy exists as only one of the value IS NULL for : '|| detail_discrepancy_rec.attribute_name;
317:

Line 318: fnd_log.string_with_context( fnd_log.level_procedure,l_label, l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

314:
315: l_label := l_label || 'discpNULL';
316: l_debug_str := p_int_pk_col_name||' = '|| p_int_pk_col_val || ' Discrepancy exists as only one of the value IS NULL for : '|| detail_discrepancy_rec.attribute_name;
317:
318: fnd_log.string_with_context( fnd_log.level_procedure,l_label, l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
319: END IF;
320:
321: RETURN TRUE;
322: ELSIF l_ad_column_null = 0 AND l_int_column_null = 0 THEN

Line 339: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

335: -- Discrepancy does not exist, give me more..
336: CLOSE discrepancy_check_ref_cur;
337: ELSE
338: -- Discrepancy exists, match indicator for this record should be updated to '20'.
339: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
340:
341: l_label := l_label || 'discpNOTNULL';
342: l_debug_str := p_int_pk_col_name||' = '|| p_int_pk_col_val ||' Discrepancy exists, Value of l_ref_cur_sql is :***>>'|| l_ref_cur_sql;
343:

Line 344: fnd_log.string_with_context( fnd_log.level_procedure,l_label, l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

340:
341: l_label := l_label || 'discpNOTNULL';
342: l_debug_str := p_int_pk_col_name||' = '|| p_int_pk_col_val ||' Discrepancy exists, Value of l_ref_cur_sql is :***>>'|| l_ref_cur_sql;
343:
344: fnd_log.string_with_context( fnd_log.level_procedure,l_label, l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
345: END IF;
346:
347: CLOSE discrepancy_check_ref_cur;
348: RETURN TRUE;

Line 366: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

362: -- Some SQL execution problem occurred. Mark this record for Discrepancy check.
363: -- Discrepancy exists, match indicator for this record should be updated to '20'.
364: -- Capture the error details in the logfile.
365:
366: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
367:
368: l_label := l_label || 'Exception';
369: l_debug_str := p_int_pk_col_name||' = '|| p_int_pk_col_val ||' When Other Exception Raised. To be on safer side Returning TRUE. Value of l_ref_cur_sql is :***>>'|| l_ref_cur_sql||
370: ' Value of SQLERRM is :***>> '||SQLERRM;

Line 372: fnd_log.string_with_context( fnd_log.level_procedure,l_label, l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

368: l_label := l_label || 'Exception';
369: l_debug_str := p_int_pk_col_name||' = '|| p_int_pk_col_val ||' When Other Exception Raised. To be on safer side Returning TRUE. Value of l_ref_cur_sql is :***>>'|| l_ref_cur_sql||
370: ' Value of SQLERRM is :***>> '||SQLERRM;
371:
372: fnd_log.string_with_context( fnd_log.level_procedure,l_label, l_debug_str, NULL,NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
373: END IF;
374:
375: RETURN TRUE;
376: END find_detail_discrepancy_rule;