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

Line 57: l_flag := FND_API.g_true;

53: FETCH c_custom_attr INTO l_flag ;
54: CLOSE c_custom_attr ;
55:
56: IF l_flag = 'Y' THEN
57: l_flag := FND_API.g_true;
58: ELSIF l_flag = 'N' THEN
59: l_flag := FND_API.g_false;
60: END IF;
61:

Line 59: l_flag := FND_API.g_false;

55:
56: IF l_flag = 'Y' THEN
57: l_flag := FND_API.g_true;
58: ELSIF l_flag = 'N' THEN
59: l_flag := FND_API.g_false;
60: END IF;
61:
62: RETURN l_flag ;
63:

Line 88: l_return_status := FND_API.g_ret_sts_success;

84: l_status_code VARCHAR2(30);
85:
86: BEGIN
87:
88: l_return_status := FND_API.g_ret_sts_success;
89:
90: AMS_UTILITY_PVT.debug_message(' CALLING THE call_budget_request :'||p_deliverable_id);
91:
92: OZF_BUDGETAPPROVAL_PVT.budget_request_approval(

Line 93: p_init_msg_list => FND_API.g_false

89:
90: AMS_UTILITY_PVT.debug_message(' CALLING THE call_budget_request :'||p_deliverable_id);
91:
92: OZF_BUDGETAPPROVAL_PVT.budget_request_approval(
93: p_init_msg_list => FND_API.g_false
94: ,p_api_version => 1.0
95: ,p_commit => FND_API.g_false
96: ,x_return_status => l_return_status
97: ,x_msg_count => l_msg_count

Line 95: ,p_commit => FND_API.g_false

91:
92: OZF_BUDGETAPPROVAL_PVT.budget_request_approval(
93: p_init_msg_list => FND_API.g_false
94: ,p_api_version => 1.0
95: ,p_commit => FND_API.g_false
96: ,x_return_status => l_return_status
97: ,x_msg_count => l_msg_count
98: ,x_msg_data => l_msg_data
99: ,p_object_type => 'DELV'

Line 104: IF l_return_status <> FND_API.g_ret_sts_success THEN

100: ,p_object_id => p_deliverable_id
101: ,x_status_code => l_status_code
102: );
103:
104: IF l_return_status <> FND_API.g_ret_sts_success THEN
105: RAISE FND_API.g_exc_error;
106: END IF;
107:
108: END call_budget_request;

Line 105: RAISE FND_API.g_exc_error;

101: ,x_status_code => l_status_code
102: );
103:
104: IF l_return_status <> FND_API.g_ret_sts_success THEN
105: RAISE FND_API.g_exc_error;
106: END IF;
107:
108: END call_budget_request;
109:

Line 158: l_return_status := FND_API.g_ret_sts_success;

154: l_old_status_code VARCHAR2(30) ;
155: l_custom_setup_id NUMBER ;
156: BEGIN
157:
158: l_return_status := FND_API.g_ret_sts_success;
159:
160: OPEN c_old_status;
161: FETCH c_old_status INTO l_old_status_id, l_object_version, l_old_status_code,l_custom_setup_id ;
162: CLOSE c_old_status;

Line 181: IF l_return_status <> FND_API.g_ret_sts_success THEN

177: x_approval_type => l_approval_type,
178: x_return_status => l_return_status
179: );
180:
181: IF l_return_status <> FND_API.g_ret_sts_success THEN
182: RAISE FND_API.g_exc_error;
183: END IF;
184:
185:

Line 182: RAISE FND_API.g_exc_error;

178: x_return_status => l_return_status
179: );
180:
181: IF l_return_status <> FND_API.g_ret_sts_success THEN
182: RAISE FND_API.g_exc_error;
183: END IF;
184:
185:
186: IF AMS_UTILITY_PVT.get_system_status_code(p_user_status_id)= 'AVAILABLE'

Line 297: l_return_status := FND_API.g_ret_sts_success;

293: l_msg_data VARCHAR2(2000);
294:
295: BEGIN
296:
297: l_return_status := FND_API.g_ret_sts_success;
298:
299: IF (p_new_status_code = 'AVAILABLE')
300: THEN
301: IF is_content_item(p_deliverable_id) = FND_API.g_true

Line 301: IF is_content_item(p_deliverable_id) = FND_API.g_true

297: l_return_status := FND_API.g_ret_sts_success;
298:
299: IF (p_new_status_code = 'AVAILABLE')
300: THEN
301: IF is_content_item(p_deliverable_id) = FND_API.g_true
302: THEN
303: Approve_Content_Item(
304: p_deliverable_id => p_deliverable_id
305: ,p_api_version_number => 1.0

Line 311: IF l_return_status <> FND_API.g_ret_sts_success

307: ,x_msg_count => l_msg_count
308: ,x_msg_data => l_msg_data
309: );
310:
311: IF l_return_status <> FND_API.g_ret_sts_success
312: THEN
313: RAISE FND_API.g_exc_error;
314: END IF;
315:

Line 313: RAISE FND_API.g_exc_error;

309: );
310:
311: IF l_return_status <> FND_API.g_ret_sts_success
312: THEN
313: RAISE FND_API.g_exc_error;
314: END IF;
315:
316: END IF; --if deliverable is a content item
317: END IF; -- if new status code is "AVAILABLE"

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

340: ------------------------------------------------------------------------
341:
342: PROCEDURE Approve_Content_Item(
343: p_deliverable_id IN NUMBER,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: p_api_version_number IN NUMBER,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,

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

341:
342: PROCEDURE Approve_Content_Item(
343: p_deliverable_id IN NUMBER,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: p_api_version_number IN NUMBER,
347: x_return_status OUT NOCOPY VARCHAR2,
348: x_msg_count OUT NOCOPY NUMBER,
349: x_msg_data OUT NOCOPY VARCHAR2

Line 379: IF FND_API.to_Boolean( p_init_msg_list )

375: -- Standard Start of API savepoint
376: SAVEPOINT Approve_Content_Item;
377:
378: -- Initialize message list if p_init_msg_list is set to TRUE.
379: IF FND_API.to_Boolean( p_init_msg_list )
380: THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:

Line 389: x_return_status := FND_API.G_RET_STS_SUCCESS;

385: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
386:
387:
388: -- Initialize API return status to SUCCESS
389: x_return_status := FND_API.G_RET_STS_SUCCESS;
390:
391: -- call ibc approve content API
392: OPEN c_content_approve;
393: FETCH c_content_approve INTO l_content_item_id, l_citem_version_id, l_object_version_number, l_content_item_status;

Line 416: IF x_return_status = FND_API.G_RET_STS_ERROR then

412: x_msg_count => x_msg_count,
413: x_msg_data => x_msg_data);
414:
415: -- Check return status from the above procedure call
416: IF x_return_status = FND_API.G_RET_STS_ERROR then
417: RAISE FND_API.G_EXC_ERROR;
418: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;

Line 417: RAISE FND_API.G_EXC_ERROR;

413: x_msg_data => x_msg_data);
414:
415: -- Check return status from the above procedure call
416: IF x_return_status = FND_API.G_RET_STS_ERROR then
417: RAISE FND_API.G_EXC_ERROR;
418: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421: --

Line 418: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

414:
415: -- Check return status from the above procedure call
416: IF x_return_status = FND_API.G_RET_STS_ERROR then
417: RAISE FND_API.G_EXC_ERROR;
418: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421: --
422: -- End of API body.

Line 419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

415: -- Check return status from the above procedure call
416: IF x_return_status = FND_API.G_RET_STS_ERROR then
417: RAISE FND_API.G_EXC_ERROR;
418: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421: --
422: -- End of API body.
423: --

Line 425: IF FND_API.to_Boolean( p_commit )

421: --
422: -- End of API body.
423: --
424: -- Standard check for p_commit
425: IF FND_API.to_Boolean( p_commit )
426: THEN
427: COMMIT WORK;
428: END IF;
429:

Line 443: x_return_status := FND_API.g_ret_sts_error;

439:
440: EXCEPTION
441:
442: WHEN AMS_Utility_PVT.resource_locked THEN
443: x_return_status := FND_API.g_ret_sts_error;
444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
445: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
446: FND_MSG_PUB.add;
447: END IF;

Line 449: WHEN FND_API.G_EXC_ERROR THEN

445: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
446: FND_MSG_PUB.add;
447: END IF;
448:
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO Approve_Content_Item;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (

Line 451: x_return_status := FND_API.G_RET_STS_ERROR;

447: END IF;
448:
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO Approve_Content_Item;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,

Line 454: p_encoded => FND_API.G_FALSE,

450: ROLLBACK TO Approve_Content_Item;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458:

Line 459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

455: p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK TO Approve_Content_Item;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: );
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK TO Approve_Content_Item;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,

Line 464: p_encoded => FND_API.G_FALSE,

460: ROLLBACK TO Approve_Content_Item;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,
466: p_data => x_msg_data
467: );
468:

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

467: );
468:
469: WHEN OTHERS THEN
470: ROLLBACK TO Approve_Content_Item;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
475: END IF;

Line 478: p_encoded => FND_API.G_FALSE,

474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
475: END IF;
476: -- Standard call to get message count and if count=1, get the message
477: FND_MSG_PUB.Count_And_Get (
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );
482: