eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_LEAD_FACTS_PKG dependencies on FND_MESSAGE

Line 56: fnd_message.set_name('BIM','BIM_R_START_FACTS');

52: l_schema VARCHAR2(30);
53: l_return BOOLEAN;
54: BEGIN
55: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
56: fnd_message.set_name('BIM','BIM_R_START_FACTS');
57: fnd_message.set_token('P_OBJECT', 'LEADS', FALSE);
58: fnd_file.put_line(fnd_file.log,fnd_message.get);
59:
60:

Line 57: fnd_message.set_token('P_OBJECT', 'LEADS', FALSE);

53: l_return BOOLEAN;
54: BEGIN
55: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
56: fnd_message.set_name('BIM','BIM_R_START_FACTS');
57: fnd_message.set_token('P_OBJECT', 'LEADS', FALSE);
58: fnd_file.put_line(fnd_file.log,fnd_message.get);
59:
60:
61: -- Standard call to check for call compatibility.

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

54: BEGIN
55: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
56: fnd_message.set_name('BIM','BIM_R_START_FACTS');
57: fnd_message.set_token('P_OBJECT', 'LEADS', FALSE);
58: fnd_file.put_line(fnd_file.log,fnd_message.get);
59:
60:
61: -- Standard call to check for call compatibility.
62: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 110: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');

106: END IF;
107:
108: IF (l_end_date IS NOT NULL AND p_start_date IS NOT NULL)
109: THEN
110: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
111: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
112: fnd_file.put_line(fnd_file.log,fnd_message.get);
113:
114: RAISE FND_API.G_EXC_ERROR;

Line 111: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);

107:
108: IF (l_end_date IS NOT NULL AND p_start_date IS NOT NULL)
109: THEN
110: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
111: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
112: fnd_file.put_line(fnd_file.log,fnd_message.get);
113:
114: RAISE FND_API.G_EXC_ERROR;
115:

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

108: IF (l_end_date IS NOT NULL AND p_start_date IS NOT NULL)
109: THEN
110: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
111: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
112: fnd_file.put_line(fnd_file.log,fnd_message.get);
113:
114: RAISE FND_API.G_EXC_ERROR;
115:
116: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN

Line 117: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');

113:
114: RAISE FND_API.G_EXC_ERROR;
115:
116: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN
117: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121:

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

114: RAISE FND_API.G_EXC_ERROR;
115:
116: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN
117: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121:
122:

Line 126: fnd_message.set_name('BIM','BIM_R_DATE_VALIDATION');

122:
123: IF p_start_date IS NOT NULL THEN
124:
125: IF (p_start_date >= l_temp_p_end_date) THEN
126: fnd_message.set_name('BIM','BIM_R_DATE_VALIDATION');
127: fnd_file.put_line(fnd_file.log,fnd_message.get);
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:

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

123: IF p_start_date IS NOT NULL THEN
124:
125: IF (p_start_date >= l_temp_p_end_date) THEN
126: fnd_message.set_name('BIM','BIM_R_DATE_VALIDATION');
127: fnd_file.put_line(fnd_file.log,fnd_message.get);
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: l_temp_start_date := trunc(p_start_date);

Line 147: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');

143: ELSE
144: IF l_end_date IS NOT NULL THEN
145:
146: IF (l_temp_p_end_date <= l_end_date) THEN
147: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');
148: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
149: fnd_file.put_line(fnd_file.log,fnd_message.get);
150: RAISE FND_API.g_exc_error;
151: END IF;

Line 148: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);

144: IF l_end_date IS NOT NULL THEN
145:
146: IF (l_temp_p_end_date <= l_end_date) THEN
147: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');
148: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
149: fnd_file.put_line(fnd_file.log,fnd_message.get);
150: RAISE FND_API.g_exc_error;
151: END IF;
152:

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

145:
146: IF (l_temp_p_end_date <= l_end_date) THEN
147: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');
148: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
149: fnd_file.put_line(fnd_file.log,fnd_message.get);
150: RAISE FND_API.g_exc_error;
151: END IF;
152:
153: l_temp_start_date := trunc(l_end_date) + 1;

Line 187: fnd_message.set_name('BIM','BIM_R_END_FACTS');

183: END IF;
184:
185: COMMIT;
186:
187: fnd_message.set_name('BIM','BIM_R_END_FACTS');
188: fnd_message.set_token('OBJECT_NAME', 'LEADS', FALSE);
189: fnd_file.put_line(fnd_file.log,fnd_message.get);
190:
191: -- Standard call to get message count and if count is 1, get message info.

Line 188: fnd_message.set_token('OBJECT_NAME', 'LEADS', FALSE);

184:
185: COMMIT;
186:
187: fnd_message.set_name('BIM','BIM_R_END_FACTS');
188: fnd_message.set_token('OBJECT_NAME', 'LEADS', FALSE);
189: fnd_file.put_line(fnd_file.log,fnd_message.get);
190:
191: -- Standard call to get message count and if count is 1, get message info.
192: FND_MSG_PUB.Count_And_Get

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

185: COMMIT;
186:
187: fnd_message.set_name('BIM','BIM_R_END_FACTS');
188: fnd_message.set_token('OBJECT_NAME', 'LEADS', FALSE);
189: fnd_file.put_line(fnd_file.log,fnd_message.get);
190:
191: -- Standard call to get message count and if count is 1, get message info.
192: FND_MSG_PUB.Count_And_Get
193: (p_count => x_msg_count,

Line 454: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

450:
451:
452:
453: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';
454: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
455: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
456: fnd_file.put_line(fnd_file.log,fnd_message.get);
457:
458:

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

451:
452:
453: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';
454: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
455: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
456: fnd_file.put_line(fnd_file.log,fnd_message.get);
457:
458:
459: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');

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

452:
453: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';
454: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
455: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
456: fnd_file.put_line(fnd_file.log,fnd_message.get);
457:
458:
459: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');
460:

Line 842: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

838: /***************************************************************/
839:
840:
841: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';
842: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
843: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
844: fnd_file.put_line(fnd_file.log,fnd_message.get);
845:
846: -- Analyze the daily facts table

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

839:
840:
841: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';
842: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
843: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
844: fnd_file.put_line(fnd_file.log,fnd_message.get);
845:
846: -- Analyze the daily facts table
847: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_DAILY_FACTS', estimate_percent => 5,

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

840:
841: l_table_name := 'BIM_R_LEAD_DAILY_FACTS';
842: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
843: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
844: fnd_file.put_line(fnd_file.log,fnd_message.get);
845:
846: -- Analyze the daily facts table
847: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_DAILY_FACTS', estimate_percent => 5,
848: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 861: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

857: /* Here we are inserting the summarized data into the weekly facts by taking it from the daily facts.
858: For every week we have a record since we group by that weekend date which is nothing but the Load date. */
859:
860: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';
861: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
862: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
863: fnd_file.put_line(fnd_file.log,fnd_message.get);
864:
865: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_lead_weekly_facts';

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

858: For every week we have a record since we group by that weekend date which is nothing but the Load date. */
859:
860: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';
861: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
862: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
863: fnd_file.put_line(fnd_file.log,fnd_message.get);
864:
865: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_lead_weekly_facts';
866:

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

859:
860: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';
861: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
862: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
863: fnd_file.put_line(fnd_file.log,fnd_message.get);
864:
865: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_lead_weekly_facts';
866:
867: /*BEGIN BLOCK FOR THE WEEKLY INSERT */

Line 993: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

989:
990: COMMIT;
991:
992: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';
993: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
994: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996:
997: -- Analyze the daily facts table

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

990: COMMIT;
991:
992: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';
993: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
994: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996:
997: -- Analyze the daily facts table
998: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_WEEKLY_FACTS', estimate_percent => 5,

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

991:
992: l_table_name := 'BIM_R_LEAD_WEEKLY_FACTS';
993: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
994: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996:
997: -- Analyze the daily facts table
998: DBMS_STATS.gather_table_stats('BIM','BIM_R_LEAD_WEEKLY_FACTS', estimate_percent => 5,
999: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);