DBA Data[Home] [Help]

APPS.IGS_AD_IMP_013 dependencies on FND_LOG

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

261: l_error_code := 'E294';
262: ELSE
263: l_error_code := 'E322';
264:
265: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
266:
267:
268: l_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type.exception';
269:

Line 276: fnd_log.string_with_context( fnd_log.level_exception,

272: fnd_message.set_token('ERROR_CD',l_error_code);
273:
274: l_debug_str := fnd_message.get || ' ' || SQLERRM;
275:
276: fnd_log.string_with_context( fnd_log.level_exception,
277: l_label,
278: l_debug_str, NULL,
279: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
280: END IF;

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

442:
443: ELSE
444: l_error_code := 'E014';
445:
446: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
447:
448:
449: l_label := 'igs.plsql.igs_ad_imp_013.update_person_type.exception1';
450:

Line 457: fnd_log.string_with_context( fnd_log.level_exception,

453: fnd_message.set_token('ERROR_CD',l_error_code);
454:
455: l_debug_str := fnd_message.get || ' ' || SQLERRM;
456:
457: fnd_log.string_with_context( fnd_log.level_exception,
458: l_label,
459: l_debug_str, NULL,
460: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
461: END IF;

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

1358: END IF;
1359: ELSE
1360: l_error_text := NULL;
1361: l_error_Code := 'E518';
1362: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1363:
1364: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;
1365:
1366: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

Line 1372: fnd_log.string_with_context( fnd_log.level_exception,

1368: fnd_message.set_token('ERROR_CD','E322');
1369:
1370: l_debug_str := fnd_message.get;
1371:
1372: fnd_log.string_with_context( fnd_log.level_exception,
1373: l_label,
1374: l_debug_str, NULL,
1375: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1376: END IF;

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

1529: END IF;
1530: ELSE
1531: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1532: l_error_Code := 'E518';
1533: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1534:
1535: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;
1536:
1537: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

Line 1543: fnd_log.string_with_context( fnd_log.level_exception,

1539: fnd_message.set_token('ERROR_CD','E322');
1540:
1541: l_debug_str := fnd_message.get;
1542:
1543: fnd_log.string_with_context( fnd_log.level_exception,
1544: l_label,
1545: l_debug_str, NULL,
1546: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1547: END IF;

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

2227: **********************************************/
2228: l_status VARCHAR2(1);
2229: l_error_code VARCHAR2(30);
2230: BEGIN
2231: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2232: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.begin';
2233: l_debug_str := 'igs_ad_imp_028.update_pe_cred';
2234:
2235: fnd_log.string_with_context( fnd_log.level_procedure,

Line 2235: fnd_log.string_with_context( fnd_log.level_procedure,

2231: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2232: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.begin';
2233: l_debug_str := 'igs_ad_imp_028.update_pe_cred';
2234:
2235: fnd_log.string_with_context( fnd_log.level_procedure,
2236: l_label,
2237: l_debug_str, NULL,
2238: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2239: END IF;

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

2298: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');
2299: END IF;
2300: ELSE
2301: l_error_text := NULL;
2302: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2303:
2304: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.exception '|| l_msg_data;
2305:
2306: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

Line 2312: fnd_log.string_with_context( fnd_log.level_exception,

2308: fnd_message.set_token('ERROR_CD','E014');
2309:
2310: l_debug_str := fnd_message.get;
2311:
2312: fnd_log.string_with_context( fnd_log.level_exception,
2313: l_label,
2314: l_debug_str, NULL,
2315: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2316: END IF;

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

2348: l_rowid VARCHAR2(25);
2349: l_credential_id igs_pe_credentials.credential_id%TYPE;
2350:
2351: BEGIN
2352: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2353: l_label := 'igs.plsql.igs_ad_imp_028.insert_pe_cred.begin';
2354: l_debug_str := 'igs_ad_imp_028.insert_pe_cred';
2355:
2356: fnd_log.string_with_context( fnd_log.level_procedure,

Line 2356: fnd_log.string_with_context( fnd_log.level_procedure,

2352: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2353: l_label := 'igs.plsql.igs_ad_imp_028.insert_pe_cred.begin';
2354: l_debug_str := 'igs_ad_imp_028.insert_pe_cred';
2355:
2356: fnd_log.string_with_context( fnd_log.level_procedure,
2357: l_label,
2358: l_debug_str, NULL,
2359: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2360: END IF;

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

2400: IF p_enable_log = 'Y' THEN
2401: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,'E322','IGS_PE_CRED_INT');
2402: END IF;
2403:
2404: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2405:
2406: l_label := 'igs.plsql.igs_ad_imp_028.insert_pe_cred.exception'||l_msg_data;
2407:
2408: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

Line 2414: fnd_log.string_with_context( fnd_log.level_exception,

2410: fnd_message.set_token('ERROR_CD',l_error_code);
2411:
2412: l_debug_str := fnd_message.get;
2413:
2414: fnd_log.string_with_context( fnd_log.level_exception,
2415: l_label,
2416: l_debug_str, NULL,
2417: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2418: END IF;

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

2435: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');
2436: END IF;
2437: ELSE
2438: l_error_text := NULL;
2439: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2440:
2441: l_label := 'igs.plsql.igs_ad_imp_028.update_pe_cred.exception '||'E322';
2442:
2443: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');

Line 2449: fnd_log.string_with_context( fnd_log.level_exception,

2445: fnd_message.set_token('ERROR_CD','E322');
2446:
2447: l_debug_str := fnd_message.get;
2448:
2449: fnd_log.string_with_context( fnd_log.level_exception,
2450: l_label,
2451: l_debug_str, NULL,
2452: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2453: END IF;

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

2474: l_prog_label := 'igs.plsql.igs_ad_imp_028.prc_pe_cred_details';
2475: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_cred_details.';
2476: l_debug_str := 'igs.plsql.igs_ad_imp_008.prc_pe_cred_details.';
2477:
2478: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2479: l_label := 'igs.plsql.igs_ad_imp_028.prc_pe_cred_details.begin';
2480: l_debug_str := 'igs_ad_imp_028.prc_pe_cred_details';
2481:
2482: fnd_log.string_with_context( fnd_log.level_procedure,

Line 2482: fnd_log.string_with_context( fnd_log.level_procedure,

2478: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2479: l_label := 'igs.plsql.igs_ad_imp_028.prc_pe_cred_details.begin';
2480: l_debug_str := 'igs_ad_imp_028.prc_pe_cred_details';
2481:
2482: fnd_log.string_with_context( fnd_log.level_procedure,
2483: l_label,
2484: l_debug_str, NULL,
2485: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2486: END IF;