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

Line 6: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2: /* $Header: amsvapsb.pls 120.1 2005/12/28 00:24:38 vmodur noship $ */
3:
4: PROCEDURE Submit_Approval(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
9: p_object_id IN NUMBER, -- from pageid
10: p_object_type IN VARCHAR2, -- from pageid

Line 7: p_commit IN VARCHAR2 := FND_API.g_false,

3:
4: PROCEDURE Submit_Approval(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
9: p_object_id IN NUMBER, -- from pageid
10: p_object_type IN VARCHAR2, -- from pageid
11: p_new_status_id IN NUMBER, -- will come from status dropdown on approval detail page

Line 8: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

4: PROCEDURE Submit_Approval(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
7: p_commit IN VARCHAR2 := FND_API.g_false,
8: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
9: p_object_id IN NUMBER, -- from pageid
10: p_object_type IN VARCHAR2, -- from pageid
11: p_new_status_id IN NUMBER, -- will come from status dropdown on approval detail page
12:

Line 57: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

53: l_msg_data VARCHAR2(4000);
54: l_error_msg VARCHAR2(4000);
55:
56: BEGIN
57: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
58: IF p_object_type = 'CAMP' THEN
59: OPEN l_obj_details FOR
60: SELECT DECODE(rollup_type,'RCAM','RCAM','CAMP') object_type,
61: user_status_id,

Line 164: x_return_status := Fnd_Api.G_RET_STS_ERROR;

160: -- extend for other objects too
161: ELSE
162: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');
163: Fnd_Msg_Pub.ADD;
164: x_return_status := Fnd_Api.G_RET_STS_ERROR;
165: RETURN;
166: END IF ;
167:
168: FETCH l_obj_details INTO x_obj_type,

Line 179: x_return_status := Fnd_Api.G_RET_STS_ERROR;

175: IF l_obj_details%NOTFOUND THEN
176: CLOSE l_obj_details;
177: Fnd_Message.Set_Name('AMS','AMS_APPR_BAD_DETAILS');
178: Fnd_Msg_Pub.ADD;
179: x_return_status := Fnd_Api.G_RET_STS_ERROR;
180: RETURN;
181: END IF;
182: CLOSE l_obj_details;
183:

Line 193: IF FND_API.to_boolean (p_init_msg_list) THEN

189: --SAVEPOINT submit_approval;
190: -- Individual Update API's will start and rollback to
191: -- savepoints
192: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
193: IF FND_API.to_boolean (p_init_msg_list) THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196: IF NOT FND_API.compatible_api_call(
197: l_api_version,

Line 196: IF NOT FND_API.compatible_api_call(

192: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
193: IF FND_API.to_boolean (p_init_msg_list) THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196: IF NOT FND_API.compatible_api_call(
197: l_api_version,
198: p_api_version,
199: l_api_name,
200: g_pkg_name

Line 202: RAISE FND_API.g_exc_unexpected_error;

198: p_api_version,
199: l_api_name,
200: g_pkg_name
201: ) THEN
202: RAISE FND_API.g_exc_unexpected_error;
203: END IF;
204: x_return_status := FND_API.g_ret_sts_success;
205:
206: --------------------- Get Current Status -----------------------

Line 204: x_return_status := FND_API.g_ret_sts_success;

200: g_pkg_name
201: ) THEN
202: RAISE FND_API.g_exc_unexpected_error;
203: END IF;
204: x_return_status := FND_API.g_ret_sts_success;
205:
206: --------------------- Get Current Status -----------------------
207: Get_Object_Details(p_object_type => p_object_type,
208: p_object_id => p_object_id,

Line 217: IF x_return_status <> FND_API.g_ret_sts_success THEN

213: x_setup_id => l_setup_id,
214: x_other => l_other,
215: x_return_status => x_return_status );
216:
217: IF x_return_status <> FND_API.g_ret_sts_success THEN
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220: --------------------- check for valid status change -----------------------
221: -- Most probably this call not required as respective API's will check anyway

Line 218: RAISE FND_API.G_EXC_ERROR;

214: x_other => l_other,
215: x_return_status => x_return_status );
216:
217: IF x_return_status <> FND_API.g_ret_sts_success THEN
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220: --------------------- check for valid status change -----------------------
221: -- Most probably this call not required as respective API's will check anyway
222: -- For FREQ, there is no custom setup and this call will cause error

Line 235: IF x_return_status <> FND_API.g_ret_sts_success THEN

231: x_approval_type => x_approval_type, -- what does this return
232: x_return_status => x_return_status
233: );
234:
235: IF x_return_status <> FND_API.g_ret_sts_success THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: END IF;
239: */

Line 236: RAISE FND_API.G_EXC_ERROR;

232: x_return_status => x_return_status
233: );
234:
235: IF x_return_status <> FND_API.g_ret_sts_success THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: END IF;
239: */
240: --------------------- get system status type -----------------------

Line 431: p_validation_level => fnd_api.g_valid_level_full, -- full

427: Ozf_ActBudgets_Pvt.update_act_budgets (
428: p_api_version => p_api_version,
429: p_init_msg_list => p_init_msg_list,
430: p_commit => p_commit,
431: p_validation_level => fnd_api.g_valid_level_full, -- full
432:
433: p_act_budgets_rec => l_act_budgets_rec,
434:
435: x_return_status => x_return_status,

Line 552: WHEN fnd_api.g_exc_error THEN

548: --------------------- Get Current Status and other Details -----------------------
549:
550: EXCEPTION
551: --ROLLBACK TO submit_approval;
552: WHEN fnd_api.g_exc_error THEN
553: x_return_status := fnd_api.g_ret_sts_error;
554: fnd_msg_pub.count_and_get(
555: p_encoded => fnd_api.g_false
556: ,p_count => x_msg_count

Line 553: x_return_status := fnd_api.g_ret_sts_error;

549:
550: EXCEPTION
551: --ROLLBACK TO submit_approval;
552: WHEN fnd_api.g_exc_error THEN
553: x_return_status := fnd_api.g_ret_sts_error;
554: fnd_msg_pub.count_and_get(
555: p_encoded => fnd_api.g_false
556: ,p_count => x_msg_count
557: ,p_data => x_msg_data);

Line 555: p_encoded => fnd_api.g_false

551: --ROLLBACK TO submit_approval;
552: WHEN fnd_api.g_exc_error THEN
553: x_return_status := fnd_api.g_ret_sts_error;
554: fnd_msg_pub.count_and_get(
555: p_encoded => fnd_api.g_false
556: ,p_count => x_msg_count
557: ,p_data => x_msg_data);
558: WHEN fnd_api.g_exc_unexpected_error THEN
559: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 558: WHEN fnd_api.g_exc_unexpected_error THEN

554: fnd_msg_pub.count_and_get(
555: p_encoded => fnd_api.g_false
556: ,p_count => x_msg_count
557: ,p_data => x_msg_data);
558: WHEN fnd_api.g_exc_unexpected_error THEN
559: x_return_status := fnd_api.g_ret_sts_unexp_error;
560: fnd_msg_pub.count_and_get(
561: p_encoded => fnd_api.g_false
562: ,p_count => x_msg_count

Line 559: x_return_status := fnd_api.g_ret_sts_unexp_error;

555: p_encoded => fnd_api.g_false
556: ,p_count => x_msg_count
557: ,p_data => x_msg_data);
558: WHEN fnd_api.g_exc_unexpected_error THEN
559: x_return_status := fnd_api.g_ret_sts_unexp_error;
560: fnd_msg_pub.count_and_get(
561: p_encoded => fnd_api.g_false
562: ,p_count => x_msg_count
563: ,p_data => x_msg_data);

Line 561: p_encoded => fnd_api.g_false

557: ,p_data => x_msg_data);
558: WHEN fnd_api.g_exc_unexpected_error THEN
559: x_return_status := fnd_api.g_ret_sts_unexp_error;
560: fnd_msg_pub.count_and_get(
561: p_encoded => fnd_api.g_false
562: ,p_count => x_msg_count
563: ,p_data => x_msg_data);
564: WHEN OTHERS THEN
565: --ROLLBACK TO submit_approval;

Line 566: x_return_status := fnd_api.g_ret_sts_unexp_error;

562: ,p_count => x_msg_count
563: ,p_data => x_msg_data);
564: WHEN OTHERS THEN
565: --ROLLBACK TO submit_approval;
566: x_return_status := fnd_api.g_ret_sts_unexp_error;
567: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;
570: fnd_msg_pub.count_and_get(

Line 571: p_encoded => fnd_api.g_false

567: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
568: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
569: END IF;
570: fnd_msg_pub.count_and_get(
571: p_encoded => fnd_api.g_false
572: ,p_count => x_msg_count
573: ,p_data => x_msg_data);
574:
575: END Submit_Approval;