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

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

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

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

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

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

15: PROCEDURE POPULATE
16: (p_api_version_number IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: p_commit IN VARCHAR2 := FND_API.G_FALSE,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,
22: x_return_status OUT NOCOPY VARCHAR2,
23: p_object IN VARCHAR2,

Line 51: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

47:
48: BEGIN
49:
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
55: THEN

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
55: THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58:
59: -- Initialize message list IF p_init_msg_list IS set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )

Line 60: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: -- Debug Message
66: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
67:
68: -- Initialize API return status to SUCCESS
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71:
72: /* Find if the data will be loaded for the first time or not.*/
73:

Line 92: RAISE FND_API.G_EXC_ERROR;

88: THEN
89: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
90: fnd_message.set_token('END_DATE', l_max_end_date, FALSE);
91: ams_utility_pvt.write_conc_log(fnd_message.get);
92: RAISE FND_API.G_EXC_ERROR;
93: elsif (l_max_end_date IS NULL AND p_start_date IS NULL) THEN
94: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
95: ams_utility_pvt.write_conc_log(fnd_message.get);
96: RAISE FND_API.G_EXC_ERROR;

Line 96: RAISE FND_API.G_EXC_ERROR;

92: RAISE FND_API.G_EXC_ERROR;
93: elsif (l_max_end_date IS NULL AND p_start_date IS NULL) THEN
94: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
95: ams_utility_pvt.write_conc_log(fnd_message.get);
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:
99:
100: IF p_start_date IS NOT NULL THEN

Line 105: RAISE FND_API.G_EXC_ERROR;

101:
102: IF (p_start_date > p_end_date) THEN
103: fnd_message.set_name('BIM','BIM_R_DATE_VALIDATION');
104: ams_utility_pvt.write_conc_log(fnd_message.get);
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107: LOAD_DATA(p_start_datel => p_start_date
108: ,p_end_datel => l_end_date
109: ,p_api_version_number => l_api_version_number

Line 115: IF x_return_status = FND_API.g_ret_sts_error

111: ,x_msg_data=>x_msg_data
112: ,x_return_status=>x_return_status
113: );
114:
115: IF x_return_status = FND_API.g_ret_sts_error
116: THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
119: RAISE FND_API.g_exc_unexpected_error;

Line 117: RAISE FND_API.g_exc_error;

113: );
114:
115: IF x_return_status = FND_API.g_ret_sts_error
116: THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121: ELSE

Line 118: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

114:
115: IF x_return_status = FND_API.g_ret_sts_error
116: THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121: ELSE
122:

Line 119: RAISE FND_API.g_exc_unexpected_error;

115: IF x_return_status = FND_API.g_ret_sts_error
116: THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121: ELSE
122:
123: IF l_max_end_date IS NOT NULL THEN

Line 129: RAISE FND_API.g_exc_error;

125: IF (p_end_date <= l_max_end_date) THEN
126: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');
127: fnd_message.set_token('END_DATE', l_max_end_date, FALSE);
128: ams_utility_pvt.write_conc_log(fnd_message.get);
129: RAISE FND_API.g_exc_error;
130: END IF;
131:
132: LOAD_DATA(p_start_datel => l_max_end_date + 1
133: ,p_end_datel => l_end_date

Line 141: IF x_return_status = FND_API.g_ret_sts_error

137: ,x_return_status=>x_return_status
138: );
139: END IF;
140:
141: IF x_return_status = FND_API.g_ret_sts_error
142: THEN
143: RAISE FND_API.g_exc_error;
144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
145: RAISE FND_API.g_exc_unexpected_error;

Line 143: RAISE FND_API.g_exc_error;

139: END IF;
140:
141: IF x_return_status = FND_API.g_ret_sts_error
142: THEN
143: RAISE FND_API.g_exc_error;
144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
145: RAISE FND_API.g_exc_unexpected_error;
146: END IF;
147: END IF;

Line 144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

140:
141: IF x_return_status = FND_API.g_ret_sts_error
142: THEN
143: RAISE FND_API.g_exc_error;
144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
145: RAISE FND_API.g_exc_unexpected_error;
146: END IF;
147: END IF;
148:

Line 145: RAISE FND_API.g_exc_unexpected_error;

141: IF x_return_status = FND_API.g_ret_sts_error
142: THEN
143: RAISE FND_API.g_exc_error;
144: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
145: RAISE FND_API.g_exc_unexpected_error;
146: END IF;
147: END IF;
148:
149: IF FND_API.To_Boolean ( p_commit ) THEN

Line 149: IF FND_API.To_Boolean ( p_commit ) THEN

145: RAISE FND_API.g_exc_unexpected_error;
146: END IF;
147: END IF;
148:
149: IF FND_API.To_Boolean ( p_commit ) THEN
150: COMMIT WORK;
151: END IF;
152: commit;
153:

Line 165: WHEN FND_API.G_EXC_ERROR THEN

161: p_data => x_msg_data
162: );
163: EXCEPTION
164:
165: WHEN FND_API.G_EXC_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: -- Standard call to get message count and IF count=1, get the message
168: FND_msg_PUB.Count_And_Get (
169: -- p_encoded => FND_API.G_FALSE,

Line 166: x_return_status := FND_API.G_RET_STS_ERROR;

162: );
163: EXCEPTION
164:
165: WHEN FND_API.G_EXC_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: -- Standard call to get message count and IF count=1, get the message
168: FND_msg_PUB.Count_And_Get (
169: -- p_encoded => FND_API.G_FALSE,
170: p_count => x_msg_count,

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

165: WHEN FND_API.G_EXC_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: -- Standard call to get message count and IF count=1, get the message
168: FND_msg_PUB.Count_And_Get (
169: -- p_encoded => FND_API.G_FALSE,
170: p_count => x_msg_count,
171: p_data => x_msg_data
172: );
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

169: -- p_encoded => FND_API.G_FALSE,
170: p_count => x_msg_count,
171: p_data => x_msg_data
172: );
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: -- Standard call to get message count and IF count=1, get the message
176: FND_msg_PUB.Count_And_Get (
177: --p_encoded => FND_API.G_FALSE,

Line 174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

170: p_count => x_msg_count,
171: p_data => x_msg_data
172: );
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: -- Standard call to get message count and IF count=1, get the message
176: FND_msg_PUB.Count_And_Get (
177: --p_encoded => FND_API.G_FALSE,
178: p_count => x_msg_count,

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

173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: -- Standard call to get message count and IF count=1, get the message
176: FND_msg_PUB.Count_And_Get (
177: --p_encoded => FND_API.G_FALSE,
178: p_count => x_msg_count,
179: p_data => x_msg_data
180: );
181:

Line 183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

179: p_data => x_msg_data
180: );
181:
182: WHEN OTHERS THEN
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
185: THEN
186: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);
187: END IF;

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

186: FND_msg_PUB.Add_Exc_msg( G_PKG_NAME,l_api_name);
187: END IF;
188: -- Standard call to get message count and IF count=1, get the message
189: FND_msg_PUB.Count_And_Get (
190: -- p_encoded => FND_API.G_FALSE,
191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194:

Line 303: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

299: fnd_message.set_token('P_OBJECT', l_object, FALSE);
300: ams_utility_pvt.write_conc_log(fnd_message.get);
301:
302: -- Standard call to check for call compatibility.
303: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
304: l_api_version_number,
305: l_api_name,
306: G_PKG_NAME)
307: THEN

Line 308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

304: l_api_version_number,
305: l_api_name,
306: G_PKG_NAME)
307: THEN
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: END IF;
310:
311:
312: -- Initialize API return status to SUCCESS

Line 313: x_return_status := FND_API.G_RET_STS_SUCCESS;

309: END IF;
310:
311:
312: -- Initialize API return status to SUCCESS
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
316: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'. bim_r_limp_daily_facts nologging';
317: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'. bim_r_limp_weekly_facts nologging';

Line 487: x_return_status := FND_API.G_RET_STS_ERROR;

483:
484: EXCEPTION
485: WHEN OTHERS THEN
486: EXECUTE IMMEDIATE 'ALTER sequence '||l_schema||'. bim_r_limp_daily_facts_s CACHE 20';
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
489: FND_MESSAGE.Set_token('table_name', p_table_name, FALSE);
490: FND_MSG_PUB.Add;
491: ams_utility_pvt.write_conc_log('LEAD IMPORT: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));

Line 492: RAISE FND_API.G_EXC_ERROR;

488: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
489: FND_MESSAGE.Set_token('table_name', p_table_name, FALSE);
490: FND_MSG_PUB.Add;
491: ams_utility_pvt.write_conc_log('LEAD IMPORT: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));
492: RAISE FND_API.G_EXC_ERROR;
493: end;
494:
495: p_table_name :='BIM_R_LIMP_WEEKLY_FACTS';
496:

Line 619: WHEN FND_API.G_EXC_ERROR THEN

615:
616:
617: EXCEPTION
618:
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: -- Standard call to get message count and if count=1, get the message
622: FND_msg_PUB.Count_And_Get (
623: -- p_encoded => FND_API.G_FALSE,

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616:
617: EXCEPTION
618:
619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: -- Standard call to get message count and if count=1, get the message
622: FND_msg_PUB.Count_And_Get (
623: -- p_encoded => FND_API.G_FALSE,
624: p_count => x_msg_count,

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

619: WHEN FND_API.G_EXC_ERROR THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: -- Standard call to get message count and if count=1, get the message
622: FND_msg_PUB.Count_And_Get (
623: -- p_encoded => FND_API.G_FALSE,
624: p_count => x_msg_count,
625: p_data => x_msg_data
626: );
627:

Line 630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

626: );
627:
628: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
629:
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631:
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633:
634: -- Standard call to get message count and if count=1, get the message

Line 632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

628: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
629:
630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631:
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633:
634: -- Standard call to get message count and if count=1, get the message
635: FND_msg_PUB.Count_And_Get (
636: --p_encoded => FND_API.G_FALSE,

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

632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633:
634: -- Standard call to get message count and if count=1, get the message
635: FND_msg_PUB.Count_And_Get (
636: --p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640:

Line 645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

641: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
642:
643: WHEN OTHERS THEN
644:
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646:
647: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
648: THEN
649: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

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

650: END IF;
651:
652: -- Standard call to get message count and if count=1, get the message
653: FND_msg_PUB.Count_And_Get (
654: -- p_encoded => FND_API.G_FALSE,
655: p_count => x_msg_count,
656: p_data => x_msg_data
657: );
658: