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

Line 5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1: PACKAGE BODY jtf_task_audits_pvt AS
2: /* $Header: jtftktub.pls 120.7 2011/04/28 11:27:54 abhishjj ship $ */
3: PROCEDURE process_task_audits (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_object_version_number IN NUMBER ,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,

Line 6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2: /* $Header: jtftktub.pls 120.7 2011/04/28 11:27:54 abhishjj ship $ */
3: PROCEDURE process_task_audits (
4: p_api_version IN NUMBER,
5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_object_version_number IN NUMBER ,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,

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

135: IS
136: l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
137: l_api_version CONSTANT NUMBER := 1.0;
138: l_rowid ROWID;
139: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;
140: l_commit VARCHAR2(10) := fnd_api.g_false;
141: l_last_update_date DATE;
142: l_last_updated_by NUMBER;
143: l_creation_date DATE := SYSDATE;

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

136: l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
137: l_api_version CONSTANT NUMBER := 1.0;
138: l_rowid ROWID;
139: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;
140: l_commit VARCHAR2(10) := fnd_api.g_false;
141: l_last_update_date DATE;
142: l_last_updated_by NUMBER;
143: l_creation_date DATE := SYSDATE;
144: l_task_audit_id NUMBER;

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

349: -- Establish savepoint
350: SAVEPOINT process_task_audit_pvt;
351:
352: -- Check version number
353: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
354: THEN
355: RAISE fnd_api.g_exc_unexpected_error;
356: END IF;
357:

Line 355: RAISE fnd_api.g_exc_unexpected_error;

351:
352: -- Check version number
353: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
354: THEN
355: RAISE fnd_api.g_exc_unexpected_error;
356: END IF;
357:
358: -- Initialize message list if requested
359: IF fnd_api.to_boolean (p_init_msg_list)

Line 359: IF fnd_api.to_boolean (p_init_msg_list)

355: RAISE fnd_api.g_exc_unexpected_error;
356: END IF;
357:
358: -- Initialize message list if requested
359: IF fnd_api.to_boolean (p_init_msg_list)
360: THEN
361: fnd_msg_pub.initialize;
362: END IF;
363:

Line 365: x_return_status := fnd_api.g_ret_sts_success;

361: fnd_msg_pub.initialize;
362: END IF;
363:
364: -- Initialize return status to SUCCESS
365: x_return_status := fnd_api.g_ret_sts_success;
366:
367: --dbms_output.put_line(' start of process task ');
368:
369: -- ----------------------------------------------

Line 1142: x_return_status := fnd_api.g_ret_sts_unexp_error;

1138: FETCH ta_cur1 INTO x;
1139:
1140: IF ta_cur1%NOTFOUND
1141: THEN
1142: x_return_status := fnd_api.g_ret_sts_unexp_error;
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: ELSE
1145: NULL;
1146: END IF;

Line 1143: RAISE fnd_api.g_exc_unexpected_error;

1139:
1140: IF ta_cur1%NOTFOUND
1141: THEN
1142: x_return_status := fnd_api.g_ret_sts_unexp_error;
1143: RAISE fnd_api.g_exc_unexpected_error;
1144: ELSE
1145: NULL;
1146: END IF;
1147:

Line 1152: IF fnd_api.to_boolean (p_commit)

1148: x_task_audit_id := l_task_audit_id ;
1149:
1150: END IF;
1151:
1152: IF fnd_api.to_boolean (p_commit)
1153: THEN
1154: COMMIT WORK;
1155: END IF;
1156:

Line 1160: WHEN fnd_api.g_exc_error

1156:
1157:
1158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1159: EXCEPTION
1160: WHEN fnd_api.g_exc_error
1161: THEN
1162: ROLLBACK TO process_task_audit_pvt;
1163: x_return_status := fnd_api.g_ret_sts_error;
1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1163: x_return_status := fnd_api.g_ret_sts_error;

1159: EXCEPTION
1160: WHEN fnd_api.g_exc_error
1161: THEN
1162: ROLLBACK TO process_task_audit_pvt;
1163: x_return_status := fnd_api.g_ret_sts_error;
1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1165: WHEN fnd_api.g_exc_unexpected_error
1166: THEN
1167: ROLLBACK TO process_task_audit_pvt;

Line 1165: WHEN fnd_api.g_exc_unexpected_error

1161: THEN
1162: ROLLBACK TO process_task_audit_pvt;
1163: x_return_status := fnd_api.g_ret_sts_error;
1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1165: WHEN fnd_api.g_exc_unexpected_error
1166: THEN
1167: ROLLBACK TO process_task_audit_pvt;
1168: x_return_status := fnd_api.g_ret_sts_unexp_error;
1169: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1168: x_return_status := fnd_api.g_ret_sts_unexp_error;

1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1165: WHEN fnd_api.g_exc_unexpected_error
1166: THEN
1167: ROLLBACK TO process_task_audit_pvt;
1168: x_return_status := fnd_api.g_ret_sts_unexp_error;
1169: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1170: WHEN OTHERS
1171: THEN
1172: ROLLBACK TO process_task_audit_pvt;

Line 1173: x_return_status := fnd_api.g_ret_sts_unexp_error;

1169: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1170: WHEN OTHERS
1171: THEN
1172: ROLLBACK TO process_task_audit_pvt;
1173: x_return_status := fnd_api.g_ret_sts_unexp_error;
1174:
1175: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1176: THEN
1177: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1185: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1181: END;
1182:
1183: PROCEDURE create_task_audits (
1184: p_api_version IN NUMBER,
1185: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1186: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1187: p_object_version_number IN NUMBER,
1188: p_task_id IN NUMBER,
1189: p_new_billable_flag IN VARCHAR2 DEFAULT NULL,

Line 1186: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1182:
1183: PROCEDURE create_task_audits (
1184: p_api_version IN NUMBER,
1185: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1186: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1187: p_object_version_number IN NUMBER,
1188: p_task_id IN NUMBER,
1189: p_new_billable_flag IN VARCHAR2 DEFAULT NULL,
1190: p_new_device1_flag IN VARCHAR2 DEFAULT NULL,

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

1255: IS
1256: l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
1257: l_api_version CONSTANT NUMBER := 1.0;
1258: l_rowid ROWID;
1259: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;
1260: l_commit VARCHAR2(10) := fnd_api.g_false;
1261: l_last_update_date DATE := SYSDATE;
1262: l_last_updated_by NUMBER := -1;
1263: l_creation_date DATE := SYSDATE;

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

1256: l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
1257: l_api_version CONSTANT NUMBER := 1.0;
1258: l_rowid ROWID;
1259: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;
1260: l_commit VARCHAR2(10) := fnd_api.g_false;
1261: l_last_update_date DATE := SYSDATE;
1262: l_last_updated_by NUMBER := -1;
1263: l_creation_date DATE := SYSDATE;
1264: l_task_audit_id NUMBER;

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

1499: aud_rec tsk_aud%ROWTYPE;
1500: BEGIN
1501: SAVEPOINT process_task_audit_pvt;
1502:
1503: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1504: THEN
1505: RAISE fnd_api.g_exc_unexpected_error;
1506: END IF;
1507:

Line 1505: RAISE fnd_api.g_exc_unexpected_error;

1501: SAVEPOINT process_task_audit_pvt;
1502:
1503: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1504: THEN
1505: RAISE fnd_api.g_exc_unexpected_error;
1506: END IF;
1507:
1508: IF fnd_api.to_boolean (p_init_msg_list)
1509: THEN

Line 1508: IF fnd_api.to_boolean (p_init_msg_list)

1504: THEN
1505: RAISE fnd_api.g_exc_unexpected_error;
1506: END IF;
1507:
1508: IF fnd_api.to_boolean (p_init_msg_list)
1509: THEN
1510: fnd_msg_pub.initialize;
1511: END IF;
1512:

Line 1513: x_return_status := fnd_api.g_ret_sts_success;

1509: THEN
1510: fnd_msg_pub.initialize;
1511: END IF;
1512:
1513: x_return_status := fnd_api.g_ret_sts_success;
1514:
1515: OPEN tsk_aud (p_task_id);
1516:
1517: --dbms_output.put_line(' opening cursor....');

Line 1648: p_init_msg_list => fnd_api.g_false,

1644:
1645: --dbms_output.put_line(' calling process tasks...... ');
1646: jtf_task_audits_pvt.process_task_audits (
1647: p_api_version => 1.0,
1648: p_init_msg_list => fnd_api.g_false,
1649: p_commit => fnd_api.g_false,
1650: p_object_version_number => p_object_version_number ,
1651: x_return_status => x_return_status,
1652: x_msg_count => x_msg_count,

Line 1649: p_commit => fnd_api.g_false,

1645: --dbms_output.put_line(' calling process tasks...... ');
1646: jtf_task_audits_pvt.process_task_audits (
1647: p_api_version => 1.0,
1648: p_init_msg_list => fnd_api.g_false,
1649: p_commit => fnd_api.g_false,
1650: p_object_version_number => p_object_version_number ,
1651: x_return_status => x_return_status,
1652: x_msg_count => x_msg_count,
1653: x_msg_data => x_msg_data,

Line 1779: IF fnd_api.to_boolean (p_commit)

1775: p_new_location_id => l_new_location_id,
1776: x_task_audit_id => x_task_audit_id
1777: );
1778:
1779: IF fnd_api.to_boolean (p_commit)
1780: THEN
1781: COMMIT WORK;
1782: END IF;
1783:

Line 1786: WHEN fnd_api.g_exc_error

1782: END IF;
1783:
1784: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1785: EXCEPTION
1786: WHEN fnd_api.g_exc_error
1787: THEN
1788: ROLLBACK TO process_task_audit_pvt;
1789: x_return_status := fnd_api.g_ret_sts_error;
1790: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1789: x_return_status := fnd_api.g_ret_sts_error;

1785: EXCEPTION
1786: WHEN fnd_api.g_exc_error
1787: THEN
1788: ROLLBACK TO process_task_audit_pvt;
1789: x_return_status := fnd_api.g_ret_sts_error;
1790: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1791: WHEN fnd_api.g_exc_unexpected_error
1792: THEN
1793: ROLLBACK TO process_task_audit_pvt;

Line 1791: WHEN fnd_api.g_exc_unexpected_error

1787: THEN
1788: ROLLBACK TO process_task_audit_pvt;
1789: x_return_status := fnd_api.g_ret_sts_error;
1790: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1791: WHEN fnd_api.g_exc_unexpected_error
1792: THEN
1793: ROLLBACK TO process_task_audit_pvt;
1794: x_return_status := fnd_api.g_ret_sts_unexp_error;
1795: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1794: x_return_status := fnd_api.g_ret_sts_unexp_error;

1790: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1791: WHEN fnd_api.g_exc_unexpected_error
1792: THEN
1793: ROLLBACK TO process_task_audit_pvt;
1794: x_return_status := fnd_api.g_ret_sts_unexp_error;
1795: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1796: WHEN OTHERS
1797: THEN
1798: ROLLBACK TO process_task_audit_pvt;

Line 1799: x_return_status := fnd_api.g_ret_sts_unexp_error;

1795: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1796: WHEN OTHERS
1797: THEN
1798: ROLLBACK TO process_task_audit_pvt;
1799: x_return_status := fnd_api.g_ret_sts_unexp_error;
1800:
1801: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1802: THEN
1803: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);