DBA Data[Home] [Help]

APPS.BIM_LEAD_RG_PKG dependencies on FND_MESSAGE

Line 36: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');

32:
33: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
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';

Line 37: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

33: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
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:

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 43: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');

39:
40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
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';

Line 44: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

40: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_grp_mgr';
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:

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 50: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');

46:
47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
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';

Line 51: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

47: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_sum_facts';
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:

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 57: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

53:
54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
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:

Line 58: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

54: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_lead_res_denorm';
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

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 111: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

107: ) inner;
108: COMMIT;
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

Line 112: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

108: COMMIT;
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(

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 354: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

350: ;
351: COMMIT;
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

Line 355: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

351: COMMIT;
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(

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 453: fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');

449: 'LEAD_RG',
450: sysdate);
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:

Line 454: fnd_message.set_token('PROGRAM_NAME','GROUP HIERARCHY SUM OF LEADS',FALSE);

450: sysdate);
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

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: