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 AMS_UTILITY_PVT

Line 90: AMS_UTILITY_PVT.debug_message(' CALLING THE call_budget_request :'||p_deliverable_id);

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(
93: p_init_msg_list => FND_API.g_false
94: ,p_api_version => 1.0

Line 153: l_system_status_code VARCHAR2(30) := AMS_Utility_PVT.get_system_status_code(p_user_status_id) ;

149: WHERE arc_act_budget_used_by = 'DELV'
150: AND act_budget_used_by_id = p_deliverable_id);
151:
152:
153: l_system_status_code VARCHAR2(30) := AMS_Utility_PVT.get_system_status_code(p_user_status_id) ;
154: l_old_status_code VARCHAR2(30) ;
155: l_custom_setup_id NUMBER ;
156: BEGIN
157:

Line 164: AMS_Utility_PVT.debug_message('new status code'||l_system_status_code);

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;
163:
164: AMS_Utility_PVT.debug_message('new status code'||l_system_status_code);
165: AMS_Utility_PVT.debug_message('old status code'||l_old_status_code);
166:
167: IF l_old_status_id = p_user_status_id THEN
168: RETURN;

Line 165: AMS_Utility_PVT.debug_message('old status code'||l_old_status_code);

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;
163:
164: AMS_Utility_PVT.debug_message('new status code'||l_system_status_code);
165: AMS_Utility_PVT.debug_message('old status code'||l_old_status_code);
166:
167: IF l_old_status_id = p_user_status_id THEN
168: RETURN;
169: END IF;

Line 171: AMS_Utility_PVT.check_new_status_change(

167: IF l_old_status_id = p_user_status_id THEN
168: RETURN;
169: END IF;
170:
171: AMS_Utility_PVT.check_new_status_change(
172: p_object_type => 'DELV',
173: p_object_id => p_deliverable_id,
174: p_old_status_id => l_old_status_id,
175: p_new_status_id => p_user_status_id,

Line 186: IF AMS_UTILITY_PVT.get_system_status_code(p_user_status_id)= 'AVAILABLE'

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'
187: AND AMS_UTILITY_PVT.get_system_status_code(l_old_status_id)= 'NEW'
188: --AND nvl(l_approval_type,'A') <> 'BUDGET'
189: THEN
190: call_budget_request(p_deliverable_id);

Line 187: AND AMS_UTILITY_PVT.get_system_status_code(l_old_status_id)= 'NEW'

183: END IF;
184:
185:
186: IF AMS_UTILITY_PVT.get_system_status_code(p_user_status_id)= 'AVAILABLE'
187: AND AMS_UTILITY_PVT.get_system_status_code(l_old_status_id)= 'NEW'
188: --AND nvl(l_approval_type,'A') <> 'BUDGET'
189: THEN
190: call_budget_request(p_deliverable_id);
191: END IF;

Line 196: l_new_status_id := AMS_Utility_PVT.get_default_user_status(

192:
193:
194: IF l_approval_type = 'BUDGET' THEN
195: -- start budget approval process
196: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
197: 'AMS_DELIV_STATUS',
198: 'SUBMITTED_BA'
199: );
200: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(

Line 200: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(

196: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
197: 'AMS_DELIV_STATUS',
198: 'SUBMITTED_BA'
199: );
200: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(
201: 'AMS_DELIV_STATUS',
202: 'DENIED_BA'
203: );
204:

Line 214: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),

210: p_object_version_number => l_object_version,
211: p_orig_stat_id => l_old_status_id,
212: p_new_stat_id => p_user_status_id,
213: p_reject_stat_id => l_deny_status_id,
214: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
215: p_workflowprocess => 'AMS_APPROVAL',
216: p_item_type => 'AMSAPRV'
217: );
218: ELSIF l_approval_type = 'THEME' THEN

Line 219: l_new_status_id := AMS_Utility_PVT.get_default_user_status(

215: p_workflowprocess => 'AMS_APPROVAL',
216: p_item_type => 'AMSAPRV'
217: );
218: ELSIF l_approval_type = 'THEME' THEN
219: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
220: 'AMS_DELIV_STATUS',
221: 'SUBMITTED_TA'
222: );
223: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(

Line 223: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(

219: l_new_status_id := AMS_Utility_PVT.get_default_user_status(
220: 'AMS_DELIV_STATUS',
221: 'SUBMITTED_TA'
222: );
223: l_deny_status_id := AMS_Utility_PVT.get_default_user_status(
224: 'AMS_DELIV_STATUS',
225: 'DENIED_TA'
226: );
227:

Line 236: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),

232: p_object_version_number => l_object_version,
233: p_orig_stat_id => l_old_status_id,
234: p_new_stat_id => p_user_status_id,
235: p_reject_stat_id => l_deny_status_id,
236: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
237: p_workflowprocess => 'AMS_CONCEPT_APPROVAL',
238: p_item_type => 'AMSAPRV'
239: );
240: ELSE

Line 245: AMS_UTILITY_PVT.debug_message(' l_approval_type :'||l_approval_type);

241: l_new_status_id := p_user_status_id;
242: END IF;
243: /*
244: -- because if there is no BAPL the status get changed from NEW - Available
245: AMS_UTILITY_PVT.debug_message(' l_approval_type :'||l_approval_type);
246: AMS_UTILITY_PVT.debug_message(' THE NEW STATUS ID :'||l_new_status_id);
247:
248: IF AMS_UTILITY_PVT.get_system_status_code(l_new_status_id)= 'BUDGET_APPR'
249: AND nvl(l_approval_type,'A') <> 'BUDGET'

Line 246: AMS_UTILITY_PVT.debug_message(' THE NEW STATUS ID :'||l_new_status_id);

242: END IF;
243: /*
244: -- because if there is no BAPL the status get changed from NEW - Available
245: AMS_UTILITY_PVT.debug_message(' l_approval_type :'||l_approval_type);
246: AMS_UTILITY_PVT.debug_message(' THE NEW STATUS ID :'||l_new_status_id);
247:
248: IF AMS_UTILITY_PVT.get_system_status_code(l_new_status_id)= 'BUDGET_APPR'
249: AND nvl(l_approval_type,'A') <> 'BUDGET'
250: THEN

Line 248: IF AMS_UTILITY_PVT.get_system_status_code(l_new_status_id)= 'BUDGET_APPR'

244: -- because if there is no BAPL the status get changed from NEW - Available
245: AMS_UTILITY_PVT.debug_message(' l_approval_type :'||l_approval_type);
246: AMS_UTILITY_PVT.debug_message(' THE NEW STATUS ID :'||l_new_status_id);
247:
248: IF AMS_UTILITY_PVT.get_system_status_code(l_new_status_id)= 'BUDGET_APPR'
249: AND nvl(l_approval_type,'A') <> 'BUDGET'
250: THEN
251: call_budget_request(p_deliverable_id);
252: END IF;

Line 256: p_new_status_code => AMS_Utility_PVT.get_system_status_code(l_new_status_id)

252: END IF;
253: */
254: update_status(p_deliverable_id => p_deliverable_id,
255: p_new_status_id => l_new_status_id,
256: p_new_status_code => AMS_Utility_PVT.get_system_status_code(l_new_status_id)
257: ) ;
258:
259: END update_delv_status;
260:

Line 385: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: -- Debug Message
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;

Line 399: AMS_UTILITY_PVT.debug_message('l_content_item_status is either null or not PENDING ' || l_content_item_status);

395:
396: IF l_content_item_status IS NULL
397: OR l_content_item_status <> 'PENDING'
398: THEN
399: AMS_UTILITY_PVT.debug_message('l_content_item_status is either null or not PENDING ' || l_content_item_status);
400: RETURN;
401: END IF;
402:
403: AMS_UTILITY_PVT.debug_message('Public API: ' || l_content_item_id || ':' || l_citem_version_id ||':' || l_object_version_number || ':' || l_content_item_status);

Line 403: AMS_UTILITY_PVT.debug_message('Public API: ' || l_content_item_id || ':' || l_citem_version_id ||':' || l_object_version_number || ':' || l_content_item_status);

399: AMS_UTILITY_PVT.debug_message('l_content_item_status is either null or not PENDING ' || l_content_item_status);
400: RETURN;
401: END IF;
402:
403: AMS_UTILITY_PVT.debug_message('Public API: ' || l_content_item_id || ':' || l_citem_version_id ||':' || l_object_version_number || ':' || l_content_item_status);
404:
405: IBC_CITEM_ADMIN_GRP.approve_item(
406: p_citem_ver_id => l_citem_version_id,
407: p_commit => p_commit,

Line 432: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

428: END IF;
429:
430:
431: -- Debug Message
432: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
433:
434: -- Standard call to get message count and if count is 1, get message info.
435: FND_MSG_PUB.Count_And_Get
436: (p_count => x_msg_count,

Line 442: WHEN AMS_Utility_PVT.resource_locked THEN

438: );
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;