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

Line 50: RAISE FND_API.G_EXC_ERROR;

46:
47:
48: IF NOT bis_collection_utilities.setup(l_object_name) THEN
49: bis_collection_utilities.log('Object BIM_SOURCE_CODE Not Setup Properly');
50: RAISE FND_API.G_EXC_ERROR;
51: END IF;
52: bis_collection_utilities.log('Start of the Source Code Population Program');
53:
54: -- Standard call to check for call compatibility.

Line 55: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

51: END IF;
52: bis_collection_utilities.log('Start of the Source Code Population Program');
53:
54: -- Standard call to check for call compatibility.
55: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
56: p_api_version_number,
57: l_api_name,
58: g_pkg_name)
59: THEN

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 64: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: FND_MSG_PUB.initialize;
67: END IF;
68:
69: -- Initialize API return status to SUCCESS
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: bis_collection_utilities.get_last_refresh_dates(l_object_name,
73: l_conc_start_date,
74: l_conc_end_date,

Line 85: ,p_init_msg_list => FND_API.G_FALSE

81:
82: FIRST_LOAD(p_start_date => greatest(trunc(l_global_date),trunc(p_start_date))
83: ,p_end_date => sysdate
84: ,p_api_version_number => l_api_version_number
85: ,p_init_msg_list => FND_API.G_FALSE
86: ,x_msg_count => x_msg_count
87: ,x_msg_data => x_msg_data
88: ,x_return_status => x_return_status
89: );

Line 101: ,p_init_msg_list => FND_API.G_FALSE

97:
98: FIRST_LOAD(p_start_date => greatest(l_global_date,p_start_date)
99: ,p_end_date => l_sysdate
100: ,p_api_version_number => l_api_version_number
101: ,p_init_msg_list => FND_API.G_FALSE
102: ,x_msg_count => x_msg_count
103: ,x_msg_data => x_msg_data
104: ,x_return_status => x_return_status
105: );

Line 112: ,p_init_msg_list => FND_API.G_FALSE

108:
109: INCREMENTAL_LOAD(p_start_date => trunc(l_end_date)
110: ,p_end_date => sysdate
111: ,p_api_version_number => l_api_version_number
112: ,p_init_msg_list => FND_API.G_FALSE
113: ,x_msg_count => x_msg_count
114: ,x_msg_data => x_msg_data
115: ,x_return_status => x_return_status
116: );

Line 121: IF x_return_status = FND_API.g_ret_sts_error

117: END IF;
118: END IF;
119:
120:
121: IF x_return_status = FND_API.g_ret_sts_error
122: THEN
123: RAISE FND_API.g_exc_error;
124: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
125: RAISE FND_API.g_exc_unexpected_error;

Line 123: RAISE FND_API.g_exc_error;

119:
120:
121: IF x_return_status = FND_API.g_ret_sts_error
122: THEN
123: RAISE FND_API.g_exc_error;
124: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
125: RAISE FND_API.g_exc_unexpected_error;
126: END IF;
127:

Line 124: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

120:
121: IF x_return_status = FND_API.g_ret_sts_error
122: THEN
123: RAISE FND_API.g_exc_error;
124: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
125: RAISE FND_API.g_exc_unexpected_error;
126: END IF;
127:
128: --Standard check of commit

Line 125: RAISE FND_API.g_exc_unexpected_error;

121: IF x_return_status = FND_API.g_ret_sts_error
122: THEN
123: RAISE FND_API.g_exc_error;
124: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
125: RAISE FND_API.g_exc_unexpected_error;
126: END IF;
127:
128: --Standard check of commit
129:

Line 130: IF FND_API.To_Boolean ( p_commit ) THEN

126: END IF;
127:
128: --Standard check of commit
129:
130: IF FND_API.To_Boolean ( p_commit ) THEN
131: COMMIT WORK;
132: END IF;
133:
134: COMMIT;

Line 145: WHEN FND_API.G_EXC_ERROR THEN

141: );
142:
143: EXCEPTION
144:
145: WHEN FND_API.G_EXC_ERROR THEN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: -- Standard call to get message count and if count=1, get the message
148: FND_msg_PUB.Count_And_Get (
149: -- p_encoded => FND_API.G_FALSE,

Line 146: x_return_status := FND_API.G_RET_STS_ERROR;

142:
143: EXCEPTION
144:
145: WHEN FND_API.G_EXC_ERROR THEN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: -- Standard call to get message count and if count=1, get the message
148: FND_msg_PUB.Count_And_Get (
149: -- p_encoded => FND_API.G_FALSE,
150: p_count => x_msg_count,

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

145: WHEN FND_API.G_EXC_ERROR THEN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: -- Standard call to get message count and if count=1, get the message
148: FND_msg_PUB.Count_And_Get (
149: -- p_encoded => FND_API.G_FALSE,
150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153:

Line 155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

151: p_data => x_msg_data
152: );
153:
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: /* FOR l_counter IN 1 .. x_msg_count
158: LOOP
159: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

Line 159: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156:
157: /* FOR l_counter IN 1 .. x_msg_count
158: LOOP
159: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
160: fnd_msg_pub.dump_msg(l_counter);
161: end loop; */
162:
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
160: fnd_msg_pub.dump_msg(l_counter);
161: end loop; */
162:
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: -- Standard call to get message count and if count=1, get the message
165: FND_msg_PUB.Count_And_Get (
166: --p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,

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

162:
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: -- Standard call to get message count and if count=1, get the message
165: FND_msg_PUB.Count_And_Get (
166: --p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170:

Line 172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

168: p_data => x_msg_data
169: );
170:
171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
174: THEN
175: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
176: END IF;

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

175: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
176: END IF;
177: -- Standard call to get message count and if count=1, get the message
178: FND_msg_PUB.Count_And_Get (
179: -- p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data
182: );
183:

Line 229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

225: BEGIN
226: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
227:
228: -- Standard call to check for call compatibility.
229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
230: p_api_version_number,
231: l_api_name,
232: g_pkg_name)
233: THEN

Line 234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

230: p_api_version_number,
231: l_api_name,
232: g_pkg_name)
233: THEN
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: END IF;
236:
237: -- Initialize message list if p_init_msg_list is set to TRUE.
238: IF FND_API.to_Boolean( p_init_msg_list )

Line 238: IF FND_API.to_Boolean( p_init_msg_list )

234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: END IF;
236:
237: -- Initialize message list if p_init_msg_list is set to TRUE.
238: IF FND_API.to_Boolean( p_init_msg_list )
239: THEN
240: FND_msg_PUB.initialize;
241: END IF;
242:

Line 244: x_return_status := FND_API.G_RET_STS_SUCCESS;

240: FND_msg_PUB.initialize;
241: END IF;
242:
243: -- Initialize API return status to SUCCESS
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246:
247:
248: /* Dropping INdexes */

Line 780: WHEN FND_API.G_EXC_ERROR THEN

776:
777:
778: EXCEPTION
779:
780: WHEN FND_API.G_EXC_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: FND_msg_PUB.Count_And_Get (
784: -- p_encoded => FND_API.G_FALSE,

Line 781: x_return_status := FND_API.G_RET_STS_ERROR;

777:
778: EXCEPTION
779:
780: WHEN FND_API.G_EXC_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: FND_msg_PUB.Count_And_Get (
784: -- p_encoded => FND_API.G_FALSE,
785: p_count => x_msg_count,

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

780: WHEN FND_API.G_EXC_ERROR THEN
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: -- Standard call to get message count and if count=1, get the message
783: FND_msg_PUB.Count_And_Get (
784: -- p_encoded => FND_API.G_FALSE,
785: p_count => x_msg_count,
786: p_data => x_msg_data
787: );
788:

Line 791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

787: );
788:
789: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
790:
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792:
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794:
795: -- Standard call to get message count and if count=1, get the message

Line 793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

789: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
790:
791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
792:
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794:
795: -- Standard call to get message count and if count=1, get the message
796: FND_msg_PUB.Count_And_Get (
797: --p_encoded => FND_API.G_FALSE,

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

793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794:
795: -- Standard call to get message count and if count=1, get the message
796: FND_msg_PUB.Count_And_Get (
797: --p_encoded => FND_API.G_FALSE,
798: p_count => x_msg_count,
799: p_data => x_msg_data
800: );
801:

Line 806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

802: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
803:
804: WHEN OTHERS THEN
805:
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807:
808: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
809: THEN
810: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

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

811: END IF;
812:
813: -- Standard call to get message count and if count=1, get the message
814: FND_msg_PUB.Count_And_Get (
815: -- p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data
818: );
819:

Line 864: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

860:
861: BEGIN
862:
863: -- Standard call to check for call compatibility.
864: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
865: p_api_version_number,
866: l_api_name,
867: g_pkg_name)
868: THEN

Line 869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

865: p_api_version_number,
866: l_api_name,
867: g_pkg_name)
868: THEN
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END IF;
871:
872: -- Initialize message list if p_init_msg_list is set to TRUE.
873: IF FND_API.to_Boolean( p_init_msg_list )

Line 873: IF FND_API.to_Boolean( p_init_msg_list )

869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END IF;
871:
872: -- Initialize message list if p_init_msg_list is set to TRUE.
873: IF FND_API.to_Boolean( p_init_msg_list )
874: THEN
875: FND_msg_PUB.initialize;
876: END IF;
877:

Line 879: x_return_status := FND_API.G_RET_STS_SUCCESS;

875: FND_msg_PUB.initialize;
876: END IF;
877:
878: -- Initialize API return status to SUCCESS
879: x_return_status := FND_API.G_RET_STS_SUCCESS;
880:
881:
882: DELETE FROM bim_i_source_codes WHERE trunc(obj_last_update_date) = p_start_date;
883:

Line 1522: WHEN FND_API.G_EXC_ERROR THEN

1518:
1519:
1520: EXCEPTION
1521:
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: -- Standard call to get message count and if count=1, get the message
1525: FND_msg_PUB.Count_And_Get (
1526: -- p_encoded => FND_API.G_FALSE,

Line 1523: x_return_status := FND_API.G_RET_STS_ERROR;

1519:
1520: EXCEPTION
1521:
1522: WHEN FND_API.G_EXC_ERROR THEN
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: -- Standard call to get message count and if count=1, get the message
1525: FND_msg_PUB.Count_And_Get (
1526: -- p_encoded => FND_API.G_FALSE,
1527: p_count => x_msg_count,

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

1522: WHEN FND_API.G_EXC_ERROR THEN
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: -- Standard call to get message count and if count=1, get the message
1525: FND_msg_PUB.Count_And_Get (
1526: -- p_encoded => FND_API.G_FALSE,
1527: p_count => x_msg_count,
1528: p_data => x_msg_data
1529: );
1530:

Line 1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1529: );
1530:
1531: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1532:
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534:
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536:
1537: -- Standard call to get message count and if count=1, get the message

Line 1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1531: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1532:
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534:
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536:
1537: -- Standard call to get message count and if count=1, get the message
1538: FND_msg_PUB.Count_And_Get (
1539: --p_encoded => FND_API.G_FALSE,

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

1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1536:
1537: -- Standard call to get message count and if count=1, get the message
1538: FND_msg_PUB.Count_And_Get (
1539: --p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,
1541: p_data => x_msg_data
1542: );
1543:

Line 1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1544: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
1545:
1546: WHEN OTHERS THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549:
1550: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
1551: THEN
1552: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

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

1553: END IF;
1554:
1555: -- Standard call to get message count and if count=1, get the message
1556: FND_msg_PUB.Count_And_Get (
1557: -- p_encoded => FND_API.G_FALSE,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );
1561: