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.EAM_WOLCOSTING_PUB dependencies on FND_API

Line 10: -- p_init_msg_list VARCHAR2:= FND_API.G_FALSE

6: -- Function : Insert the hierarchy into the CST_EAM_HIERARCHY_SNAPSHOT table.
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER
10: -- p_init_msg_list VARCHAR2:= FND_API.G_FALSE
11: -- p_commit VARCHAR2:= FND_API.G_FALSE
12: -- p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL
13: -- p_wip_entity_id NUMBER
14: -- p_object_type NUMBER

Line 11: -- p_commit VARCHAR2:= FND_API.G_FALSE

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER
10: -- p_init_msg_list VARCHAR2:= FND_API.G_FALSE
11: -- p_commit VARCHAR2:= FND_API.G_FALSE
12: -- p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL
13: -- p_wip_entity_id NUMBER
14: -- p_object_type NUMBER
15: -- p_parent_object_type NUMBER

Line 12: -- p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL

8: -- Parameters :
9: -- IN p_api_version IN NUMBER
10: -- p_init_msg_list VARCHAR2:= FND_API.G_FALSE
11: -- p_commit VARCHAR2:= FND_API.G_FALSE
12: -- p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL
13: -- p_wip_entity_id NUMBER
14: -- p_object_type NUMBER
15: -- p_parent_object_type NUMBER
16: -- p_org_id NUMBER

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

32: --Bug3544656: Added a parameter to pass the relationship type
33:
34: PROCEDURE insert_into_snapshot_pub(
35: p_api_version IN NUMBER ,
36: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
37: p_commit IN VARCHAR2:= FND_API.G_FALSE,
38: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
39: p_wip_entity_id IN NUMBER,
40: p_object_type IN NUMBER,

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

33:
34: PROCEDURE insert_into_snapshot_pub(
35: p_api_version IN NUMBER ,
36: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
37: p_commit IN VARCHAR2:= FND_API.G_FALSE,
38: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
39: p_wip_entity_id IN NUMBER,
40: p_object_type IN NUMBER,
41: p_parent_object_type IN NUMBER,

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

34: PROCEDURE insert_into_snapshot_pub(
35: p_api_version IN NUMBER ,
36: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
37: p_commit IN VARCHAR2:= FND_API.G_FALSE,
38: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
39: p_wip_entity_id IN NUMBER,
40: p_object_type IN NUMBER,
41: p_parent_object_type IN NUMBER,
42: x_group_id OUT NOCOPY NUMBER,

Line 84: IF NOT FND_API.compatible_api_call(

80: -- Standard Start of API savepoint
81: SAVEPOINT insert_into_snapshot_pub;
82:
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.compatible_api_call(
85: l_api_version
86: ,p_api_version
87: ,l_api_name
88: ,g_pkg_name) THEN

Line 89: RAISE fnd_api.g_exc_unexpected_error;

85: l_api_version
86: ,p_api_version
87: ,l_api_name
88: ,g_pkg_name) THEN
89: RAISE fnd_api.g_exc_unexpected_error;
90: END IF;
91:
92: -- Initialize message list if p_init_msg_list is set to TRUE.
93: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 93: IF FND_API.to_boolean(p_init_msg_list) THEN

89: RAISE fnd_api.g_exc_unexpected_error;
90: END IF;
91:
92: -- Initialize message list if p_init_msg_list is set to TRUE.
93: IF FND_API.to_boolean(p_init_msg_list) THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96:
97: -- Initialize API return status to success

Line 98: x_return_status := FND_API.g_ret_sts_success;

94: FND_MSG_PUB.initialize;
95: END IF;
96:
97: -- Initialize API return status to success
98: x_return_status := FND_API.g_ret_sts_success;
99:
100: -- API body
101:
102: -- Insert the data into the cst_eam_hierarchy_snapshot table

Line 196: p_init_msg_list => FND_API.G_TRUE,

192: p_organization_id => p_org_id,
193: p_user_id => FND_GLOBAL.USER_ID,
194: p_prog_appl_id => FND_GLOBAL.PROG_APPL_ID,
195: x_return_status => x_return_status,
196: p_init_msg_list => FND_API.G_TRUE,
197: p_commit => FND_API.G_TRUE );
198:
199: FND_MSG_PUB.Add_Exc_Msg
200: ( p_pkg_name => G_PKG_NAME ,

Line 197: p_commit => FND_API.G_TRUE );

193: p_user_id => FND_GLOBAL.USER_ID,
194: p_prog_appl_id => FND_GLOBAL.PROG_APPL_ID,
195: x_return_status => x_return_status,
196: p_init_msg_list => FND_API.G_TRUE,
197: p_commit => FND_API.G_TRUE );
198:
199: FND_MSG_PUB.Add_Exc_Msg
200: ( p_pkg_name => G_PKG_NAME ,
201: p_procedure_name => l_api_name ,

Line 209: IF FND_API.TO_BOOLEAN(p_commit) THEN

205:
206: -- End of API body
207:
208: -- Standard check of p_commit.
209: IF FND_API.TO_BOOLEAN(p_commit) THEN
210: COMMIT WORK;
211: FND_MSG_PUB.Add_Exc_Msg
212: ( p_pkg_name => G_PKG_NAME ,
213: p_procedure_name => l_api_name ,

Line 221: p_encoded => FND_API.G_FALSE,

217:
218: -- See all the messages generated and stored into the msg table
219:
220: FND_MSG_PUB.count_and_get(
221: p_encoded => FND_API.G_FALSE,
222: p_count => x_msg_count,
223: p_data => x_msg_data
224: );
225:

Line 230: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);

226: IF x_msg_count > 0
227: THEN
228: FOR indexCount IN 1 ..x_msg_count
229: LOOP
230: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
231: -- DBMS_OUTPUT.PUT_LINE(indexCount ||'-'||l_msg_data);
232: END LOOP;
233: END IF;
234:

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: END IF;
234:
235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO insert_into_snapshot_pub;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: FND_MSG_PUB.count_and_get(
241: p_encoded => FND_API.G_FALSE,

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO insert_into_snapshot_pub;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: FND_MSG_PUB.count_and_get(
241: p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data

Line 241: p_encoded => FND_API.G_FALSE,

237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO insert_into_snapshot_pub;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: FND_MSG_PUB.count_and_get(
241: p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data
244: );
245:

Line 250: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);

246: IF x_msg_count > 0
247: THEN
248: FOR indexCount IN 1 ..x_msg_count
249: LOOP
250: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
251: -- DBMS_OUTPUT.PUT_LINE(indexCount ||'-'||l_msg_data);
252: END LOOP;
253: END IF;
254:

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

253: END IF;
254:
255: WHEN OTHERS THEN
256: ROLLBACK TO insert_into_snapshot_pub;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
258: IF FND_MSG_PUB.Check_Msg_Level
259: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
260: THEN
261: FND_MSG_PUB.Add_Exc_Msg

Line 267: p_encoded => FND_API.G_FALSE,

263: l_api_name
264: );
265: END IF;
266: FND_MSG_PUB.count_and_get(
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data
270: );
271: IF x_msg_count > 0

Line 275: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);

271: IF x_msg_count > 0
272: THEN
273: FOR indexCount IN 1 ..x_msg_count
274: LOOP
275: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
276: --DBMS_OUTPUT.PUT_LINE(indexCount ||'-'||l_msg_data);
277: END LOOP;
278: END IF;
279: