DBA Data[Home] [Help]

APPS.BIM_LEAD_RG_PKG dependencies on FND_FILE

Line 38: fnd_file.put_line(fnd_file.log,fnd_message.get);

34:
35: l_table_name := 'BIM_R_LEAD_GRP_MGR';
36: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
37: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
38: fnd_file.put_line(fnd_file.log,fnd_message.get);
39:
40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
41:
42: l_table_name := 'BIM_R_LEAD_SUM_FACTS';

Line 45: fnd_file.put_line(fnd_file.log,fnd_message.get);

41:
42: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
43: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
44: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
45: fnd_file.put_line(fnd_file.log,fnd_message.get);
46:
47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
48:
49: l_table_name := 'BIM_R_LEAD_RES_DENORM';

Line 52: fnd_file.put_line(fnd_file.log,fnd_message.get);

48:
49: l_table_name := 'BIM_R_LEAD_RES_DENORM';
50: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
51: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
52: fnd_file.put_line(fnd_file.log,fnd_message.get);
53:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
55:
56: l_table_name := 'BIM_R_LEAD_GRP_MGR';

Line 59: fnd_file.put_line(fnd_file.log,fnd_message.get);

55:
56: l_table_name := 'BIM_R_LEAD_GRP_MGR';
57: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
58: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
59: fnd_file.put_line(fnd_file.log,fnd_message.get);
60:
61:
62: INSERT
63: INTO bim_r_lead_grp_mgr(

Line 113: fnd_file.put_line(fnd_file.log,fnd_message.get);

109:
110: l_table_name := 'BIM_R_LEAD_SUM_FACTS';
111: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
112: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
113: fnd_file.put_line(fnd_file.log,fnd_message.get);
114:
115: INSERT
116: INTO bim_r_lead_sum_facts(
117: creation_date

Line 356: fnd_file.put_line(fnd_file.log,fnd_message.get);

352:
353: l_table_name := 'BIM_R_LEAD_RES_DENORM';
354: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
355: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
356: fnd_file.put_line(fnd_file.log,fnd_message.get);
357:
358: INSERT
359: INTO bim_r_lead_res_denorm(
360: creation_date

Line 455: fnd_file.put_line(fnd_file.log,fnd_message.get);

451: COMMIT;
452:
453: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
454: fnd_message.set_token('PROGRAM_NAME','GROUP HIERARCHY SUM OF LEADS',FALSE);
455: fnd_file.put_line(fnd_file.log,fnd_message.get);
456:
457:
458: EXCEPTION
459: