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_RESPONSE_FACTS_PKG dependencies on FND_API

Line 14: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

10:
11: PROCEDURE POPULATE
12: (
13: p_api_version_number IN NUMBER
14: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
15: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,x_msg_count OUT NOCOPY NUMBER
18: ,x_msg_data OUT NOCOPY VARCHAR2

Line 15: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

11: PROCEDURE POPULATE
12: (
13: p_api_version_number IN NUMBER
14: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
15: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,x_msg_count OUT NOCOPY NUMBER
18: ,x_msg_data OUT NOCOPY VARCHAR2
19: ,x_return_status OUT NOCOPY VARCHAR2

Line 16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

12: (
13: p_api_version_number IN NUMBER
14: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
15: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,x_msg_count OUT NOCOPY NUMBER
18: ,x_msg_data OUT NOCOPY VARCHAR2
19: ,x_return_status OUT NOCOPY VARCHAR2
20: ,p_start_date IN DATE

Line 53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

49: fnd_message.set_token('OBJECT_NAME','Response',FALSE);
50: fnd_file.put_line(fnd_file.log,fnd_message.get);
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
54: p_api_version_number,
55: l_api_name,
56: g_pkg_name)
57: THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: p_api_version_number,
55: l_api_name,
56: g_pkg_name)
57: THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list )

Line 62: IF FND_API.to_Boolean( p_init_msg_list )

58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.
62: IF FND_API.to_Boolean( p_init_msg_list )
63: THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: FND_MSG_PUB.initialize;
65: END IF;
66:
67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: /* Find if the data will be loaded for the first time or not.*/
71: DECLARE
72: CURSOR chk_history_data IS

Line 84: -- p_encoded => FND_API.G_FALSE,

80: CLOSE chk_history_data;
81: EXCEPTION
82: WHEN OTHERS THEN
83: FND_MSG_PUB.Count_And_Get (
84: -- p_encoded => FND_API.G_FALSE,
85: p_count => x_msg_count,
86: p_data => x_msg_data
87: );
88: END;

Line 101: RAISE FND_API.G_EXC_ERROR;

97: THEN
98: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
99: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
100: fnd_file.put_line(fnd_file.log,fnd_message.get);
101: RAISE FND_API.G_EXC_ERROR;
102: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN
103: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
104: fnd_file.put_line(fnd_file.log,fnd_message.get);
105: RAISE FND_API.G_EXC_ERROR;

Line 105: RAISE FND_API.G_EXC_ERROR;

101: RAISE FND_API.G_EXC_ERROR;
102: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN
103: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
104: fnd_file.put_line(fnd_file.log,fnd_message.get);
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:
108: IF p_start_date IS NOT NULL THEN
109:

Line 113: RAISE FND_API.G_EXC_ERROR;

109:
110: IF (p_start_date >= l_temp_p_end_date) THEN
111: fnd_message.set_name('BIM','BIM_R_DATE_VALIDATION');
112: fnd_file.put_line(fnd_file.log,fnd_message.get);
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116: l_temp_start_date := trunc(p_start_date);
117: l_temp_end_date := trunc(l_temp_p_end_date);

Line 126: RAISE FND_API.g_exc_error;

122: IF (l_temp_p_end_date <= l_end_date) THEN
123: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');
124: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126: RAISE FND_API.g_exc_error;
127: END IF;
128:
129: l_temp_start_date := trunc(l_end_date) + 1;
130: l_temp_end_date := trunc(l_temp_p_end_date);

Line 139: ,p_init_msg_list => FND_API.G_FALSE

135:
136: RESPONSES_FACTS_LOAD(p_start_date => l_temp_start_date
137: ,p_end_date => l_temp_end_date
138: ,p_api_version_number => l_api_version_number
139: ,p_init_msg_list => FND_API.G_FALSE
140: ,x_msg_count => x_msg_count
141: ,x_msg_data => x_msg_data
142: ,x_return_status => x_return_status
143: );

Line 146: IF x_return_status = FND_API.g_ret_sts_error

142: ,x_return_status => x_return_status
143: );
144:
145:
146: IF x_return_status = FND_API.g_ret_sts_error
147: THEN
148: RAISE FND_API.g_exc_error;
149: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
150: RAISE FND_API.g_exc_unexpected_error;

Line 148: RAISE FND_API.g_exc_error;

144:
145:
146: IF x_return_status = FND_API.g_ret_sts_error
147: THEN
148: RAISE FND_API.g_exc_error;
149: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
150: RAISE FND_API.g_exc_unexpected_error;
151: END IF;
152:

Line 149: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

145:
146: IF x_return_status = FND_API.g_ret_sts_error
147: THEN
148: RAISE FND_API.g_exc_error;
149: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
150: RAISE FND_API.g_exc_unexpected_error;
151: END IF;
152:
153:

Line 150: RAISE FND_API.g_exc_unexpected_error;

146: IF x_return_status = FND_API.g_ret_sts_error
147: THEN
148: RAISE FND_API.g_exc_error;
149: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
150: RAISE FND_API.g_exc_unexpected_error;
151: END IF;
152:
153:
154: -- ams_utility_pvt.write_conc_log('----Period Validation----');

Line 161: IF FND_API.To_Boolean ( p_commit ) THEN

157: -- ams_utility_pvt.write_conc_log(l_currency_error);
158:
159: --Standard check of commit
160:
161: IF FND_API.To_Boolean ( p_commit ) THEN
162: COMMIT WORK;
163: END IF;
164:
165: fnd_message.set_name('BIM','BIM_R_END_PROGRAM');

Line 176: WHEN FND_API.G_EXC_ERROR THEN

172: );
173:
174: EXCEPTION
175:
176: WHEN FND_API.G_EXC_ERROR THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: -- Standard call to get message count and if count=1, get the message
179: FND_msg_PUB.Count_And_Get (
180: -- p_encoded => FND_API.G_FALSE,

Line 177: x_return_status := FND_API.G_RET_STS_ERROR;

173:
174: EXCEPTION
175:
176: WHEN FND_API.G_EXC_ERROR THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: -- Standard call to get message count and if count=1, get the message
179: FND_msg_PUB.Count_And_Get (
180: -- p_encoded => FND_API.G_FALSE,
181: p_count => x_msg_count,

Line 180: -- p_encoded => FND_API.G_FALSE,

176: WHEN FND_API.G_EXC_ERROR THEN
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: -- Standard call to get message count and if count=1, get the message
179: FND_msg_PUB.Count_And_Get (
180: -- p_encoded => FND_API.G_FALSE,
181: p_count => x_msg_count,
182: p_data => x_msg_data
183: );
184:

Line 186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

182: p_data => x_msg_data
183: );
184:
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187:
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: -- Standard call to get message count and if count=1, get the message
190: FND_msg_PUB.Count_And_Get (

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

184:
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187:
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: -- Standard call to get message count and if count=1, get the message
190: FND_msg_PUB.Count_And_Get (
191: --p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,

Line 191: --p_encoded => FND_API.G_FALSE,

187:
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: -- Standard call to get message count and if count=1, get the message
190: FND_msg_PUB.Count_And_Get (
191: --p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,
193: p_data => x_msg_data
194: );
195:

Line 197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

193: p_data => x_msg_data
194: );
195:
196: WHEN OTHERS THEN
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
199: THEN
200: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
201: END IF;

Line 204: -- p_encoded => FND_API.G_FALSE,

200: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
201: END IF;
202: -- Standard call to get message count and if count=1, get the message
203: FND_msg_PUB.Count_And_Get (
204: -- p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count,
206: p_data => x_msg_data
207: );
208:

Line 217: --,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

213: --------------------------------------------------------------------------------------------------
214:
215: PROCEDURE LOG_HISTORY
216: (--p_api_version_number IN NUMBER
217: --,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
218: --,x_msg_count OUT NUMBER
219: --,x_msg_data OUT VARCHAR2
220: --,x_return_status OUT VARCHAR2
221: p_object IN VARCHAR2,

Line 238: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

234: -- Debug Message
235: --AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the LOG_HISTORY procedure ');
236:
237: /* -- Standard call to check for call compatibility.
238: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
239: p_api_version_number,
240: l_api_name,
241: g_pkg_name)
242: THEN

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: p_api_version_number,
240: l_api_name,
241: g_pkg_name)
242: THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247: IF FND_API.to_Boolean( p_init_msg_list )

Line 247: IF FND_API.to_Boolean( p_init_msg_list )

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247: IF FND_API.to_Boolean( p_init_msg_list )
248: THEN
249: FND_msg_PUB.initialize;
250: END IF;
251:

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: FND_msg_PUB.initialize;
250: END IF;
251:
252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254: */
255:
256: INSERT INTO bim_rep_history
257: (CREATION_DATE,

Line 282: WHEN FND_API.G_EXC_ERROR THEN

278: p_data => x_msg_data
279: );
280: EXCEPTION
281:
282: WHEN FND_API.G_EXC_ERROR THEN
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: -- Standard call to get message count and if count=1, get the message
285: FND_msg_PUB.Count_And_Get (
286: -- p_encoded => FND_API.G_FALSE,

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279: );
280: EXCEPTION
281:
282: WHEN FND_API.G_EXC_ERROR THEN
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: -- Standard call to get message count and if count=1, get the message
285: FND_msg_PUB.Count_And_Get (
286: -- p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,

Line 286: -- p_encoded => FND_API.G_FALSE,

282: WHEN FND_API.G_EXC_ERROR THEN
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: -- Standard call to get message count and if count=1, get the message
285: FND_msg_PUB.Count_And_Get (
286: -- p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data
289: );
290:

Line 291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

287: p_count => x_msg_count,
288: p_data => x_msg_data
289: );
290:
291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: -- Standard call to get message count and if count=1, get the message
294: FND_msg_PUB.Count_And_Get (
295: --p_encoded => FND_API.G_FALSE,

Line 292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

288: p_data => x_msg_data
289: );
290:
291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: -- Standard call to get message count and if count=1, get the message
294: FND_msg_PUB.Count_And_Get (
295: --p_encoded => FND_API.G_FALSE,
296: p_count => x_msg_count,

Line 295: --p_encoded => FND_API.G_FALSE,

291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: -- Standard call to get message count and if count=1, get the message
294: FND_msg_PUB.Count_And_Get (
295: --p_encoded => FND_API.G_FALSE,
296: p_count => x_msg_count,
297: p_data => x_msg_data
298: );
299:

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: p_data => x_msg_data
298: );
299:
300: WHEN OTHERS THEN
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
303: THEN
304: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
305: END IF;

Line 308: -- p_encoded => FND_API.G_FALSE,

304: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
305: END IF;
306: -- Standard call to get message count and if count=1, get the message
307: FND_msg_PUB.Count_And_Get (
308: -- p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,
310: p_data => x_msg_data
311: );
312: */

Line 326: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

322: PROCEDURE RESPONSES_FACTS_LOAD
323: ( p_start_date IN DATE
324: ,p_end_date IN DATE
325: ,p_api_version_number IN NUMBER
326: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
327: ,x_msg_count OUT NOCOPY NUMBER
328: ,x_msg_data OUT NOCOPY VARCHAR2
329: ,x_return_status OUT NOCOPY VARCHAR2
330: )

Line 384: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

380:
381: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
382:
383: -- Standard call to check for call compatibility.
384: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
385: p_api_version_number,
386: l_api_name,
387: g_pkg_name)
388: THEN

Line 389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

385: p_api_version_number,
386: l_api_name,
387: g_pkg_name)
388: THEN
389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:
392: -- Initialize message list if p_init_msg_list is set to TRUE.
393: IF FND_API.to_Boolean( p_init_msg_list )

Line 393: IF FND_API.to_Boolean( p_init_msg_list )

389: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
390: END IF;
391:
392: -- Initialize message list if p_init_msg_list is set to TRUE.
393: IF FND_API.to_Boolean( p_init_msg_list )
394: THEN
395: FND_msg_PUB.initialize;
396: END IF;
397:

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: FND_msg_PUB.initialize;
396: END IF;
397:
398: -- Initialize API return status to SUCCESS
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400:
401: -- The below four commands are necessary for the purpose of the parallel insertion */
402:
403: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';

Line 822: WHEN FND_API.G_EXC_ERROR THEN

818: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'.bim_r_rrsn_weekly_facts_s CACHE 20';
819:
820: EXCEPTION
821:
822: WHEN FND_API.G_EXC_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_msg_PUB.Count_And_Get (
826: -- p_encoded => FND_API.G_FALSE,

Line 823: x_return_status := FND_API.G_RET_STS_ERROR;

819:
820: EXCEPTION
821:
822: WHEN FND_API.G_EXC_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_msg_PUB.Count_And_Get (
826: -- p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,

Line 826: -- p_encoded => FND_API.G_FALSE,

822: WHEN FND_API.G_EXC_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_msg_PUB.Count_And_Get (
826: -- p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830:

Line 833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

829: );
830:
831: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
832:
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834:
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836:
837: -- Standard call to get message count and if count=1, get the message

Line 835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

831: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
832:
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834:
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836:
837: -- Standard call to get message count and if count=1, get the message
838: FND_msg_PUB.Count_And_Get (
839: --p_encoded => FND_API.G_FALSE,

Line 839: --p_encoded => FND_API.G_FALSE,

835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836:
837: -- Standard call to get message count and if count=1, get the message
838: FND_msg_PUB.Count_And_Get (
839: --p_encoded => FND_API.G_FALSE,
840: p_count => x_msg_count,
841: p_data => x_msg_data
842: );
843:

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

844: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
845:
846: WHEN OTHERS THEN
847:
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849:
850: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
851: THEN
852: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

Line 857: -- p_encoded => FND_API.G_FALSE,

853: END IF;
854:
855: -- Standard call to get message count and if count=1, get the message
856: FND_msg_PUB.Count_And_Get (
857: -- p_encoded => FND_API.G_FALSE,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861: