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

Line 14: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

10: */
11:
12: PROCEDURE create_task_assignment_audit (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
15: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
16: p_object_version_number IN NUMBER,
17: p_task_id IN NUMBER,
18: p_task_assignment_id IN NUMBER,

Line 15: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

11:
12: PROCEDURE create_task_assignment_audit (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
15: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
16: p_object_version_number IN NUMBER,
17: p_task_id IN NUMBER,
18: p_task_assignment_id IN NUMBER,
19: p_new_resource_type_code IN VARCHAR2 DEFAULT NULL,

Line 50: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;

46: )
47: IS
48: l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENT_AUDIT_PKG';
49: l_api_version CONSTANT NUMBER := 1.0;
50: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;
51: l_commit VARCHAR2(10) := fnd_api.g_false;
52: l_old_resource_type_code VARCHAR2(30);
53: l_old_resource_id NUMBER;
54: l_old_assignment_status NUMBER;

Line 51: l_commit VARCHAR2(10) := fnd_api.g_false;

47: IS
48: l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENT_AUDIT_PKG';
49: l_api_version CONSTANT NUMBER := 1.0;
50: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;
51: l_commit VARCHAR2(10) := fnd_api.g_false;
52: l_old_resource_type_code VARCHAR2(30);
53: l_old_resource_id NUMBER;
54: l_old_assignment_status NUMBER;
55: l_old_actual_effort NUMBER;

Line 146: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

142: l_curr NUMBER;
143: BEGIN
144: SAVEPOINT create_asg_audit_pvt;
145:
146: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
147: THEN
148: RAISE fnd_api.g_exc_unexpected_error;
149: END IF;
150:

Line 148: RAISE fnd_api.g_exc_unexpected_error;

144: SAVEPOINT create_asg_audit_pvt;
145:
146: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
147: THEN
148: RAISE fnd_api.g_exc_unexpected_error;
149: END IF;
150:
151: IF fnd_api.to_boolean (p_init_msg_list)
152: THEN

Line 151: IF fnd_api.to_boolean (p_init_msg_list)

147: THEN
148: RAISE fnd_api.g_exc_unexpected_error;
149: END IF;
150:
151: IF fnd_api.to_boolean (p_init_msg_list)
152: THEN
153: fnd_msg_pub.initialize;
154: END IF;
155:

Line 156: x_return_status := fnd_api.g_ret_sts_success;

152: THEN
153: fnd_msg_pub.initialize;
154: END IF;
155:
156: x_return_status := fnd_api.g_ret_sts_success;
157:
158: OPEN cur_asg_audit (p_task_assignment_id);
159:
160: FETCH cur_asg_audit INTO audit_rec;

Line 216: IF (p_new_category_id = fnd_api.g_miss_num)

212: l_asg_create := 1;
213: END IF;
214: CLOSE cur_asg_audit;
215:
216: IF (p_new_category_id = fnd_api.g_miss_num)
217: THEN
218: l_new_category_id:=NULL;
219: END IF;
220:

Line 502: x_return_status := fnd_api.g_ret_sts_unexp_error;

498: FETCH c1 INTO x;
499:
500: IF c1%NOTFOUND
501: THEN
502: x_return_status := fnd_api.g_ret_sts_unexp_error;
503: RAISE fnd_api.g_exc_unexpected_error;
504: ELSE
505: NULL;
506: END IF;

Line 503: RAISE fnd_api.g_exc_unexpected_error;

499:
500: IF c1%NOTFOUND
501: THEN
502: x_return_status := fnd_api.g_ret_sts_unexp_error;
503: RAISE fnd_api.g_exc_unexpected_error;
504: ELSE
505: NULL;
506: END IF;
507:

Line 509: IF fnd_api.to_boolean (p_commit)

505: NULL;
506: END IF;
507:
508:
509: IF fnd_api.to_boolean (p_commit)
510: THEN
511: COMMIT WORK;
512: END IF;
513:

Line 516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

512: END IF;
513:
514: EXCEPTION
515: WHEN OTHERS THEN
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: END create_task_assignment_audit;
518:
519:
520:

Line 721: RAISE fnd_api.g_exc_unexpected_error;

717: FETCH c into l_rowid;
718: IF(c%notfound) THEN
719: DELETE FROM jtf_task_assignments_audit_b WHERE assignment_id = x_assignment_id;
720: ELSE
721: RAISE fnd_api.g_exc_unexpected_error;
722: END IF;
723: CLOSE c;
724: END DELETE_ROW;
725: