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.3 2006/01/19 06:22:21 sbarat 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.3 2006/01/19 06:22:21 sbarat 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 351: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

Line 353: RAISE fnd_api.g_exc_unexpected_error;

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

Line 357: IF fnd_api.to_boolean (p_init_msg_list)

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

Line 363: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1139: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1140: RAISE fnd_api.g_exc_unexpected_error;

1136:
1137: IF ta_cur1%NOTFOUND
1138: THEN
1139: x_return_status := fnd_api.g_ret_sts_unexp_error;
1140: RAISE fnd_api.g_exc_unexpected_error;
1141: ELSE
1142: NULL;
1143: END IF;
1144:

Line 1147: IF fnd_api.to_boolean (p_commit)

1143: END IF;
1144:
1145: x_task_audit_id := l_task_audit_id ;
1146:
1147: IF fnd_api.to_boolean (p_commit)
1148: THEN
1149: COMMIT WORK;
1150: END IF;
1151:

Line 1154: WHEN fnd_api.g_exc_error

1150: END IF;
1151:
1152: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1153: EXCEPTION
1154: WHEN fnd_api.g_exc_error
1155: THEN
1156: ROLLBACK TO process_task_audit_pvt;
1157: x_return_status := fnd_api.g_ret_sts_error;
1158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1157: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1159: WHEN fnd_api.g_exc_unexpected_error

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

Line 1162: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1167: x_return_status := fnd_api.g_ret_sts_unexp_error;

1163: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1164: WHEN OTHERS
1165: THEN
1166: ROLLBACK TO process_task_audit_pvt;
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168:
1169: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1170: THEN
1171: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1179: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1175: END;
1176:
1177: PROCEDURE create_task_audits (
1178: p_api_version IN NUMBER,
1179: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1180: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1181: p_object_version_number IN NUMBER,
1182: p_task_id IN NUMBER,
1183: p_new_billable_flag IN VARCHAR2 DEFAULT NULL,

Line 1180: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1176:
1177: PROCEDURE create_task_audits (
1178: p_api_version IN NUMBER,
1179: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1180: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1181: p_object_version_number IN NUMBER,
1182: p_task_id IN NUMBER,
1183: p_new_billable_flag IN VARCHAR2 DEFAULT NULL,
1184: p_new_device1_flag IN VARCHAR2 DEFAULT NULL,

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

1249: IS
1250: l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
1251: l_api_version CONSTANT NUMBER := 1.0;
1252: l_rowid ROWID;
1253: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;
1254: l_commit VARCHAR2(10) := fnd_api.g_false;
1255: l_last_update_date DATE := SYSDATE;
1256: l_last_updated_by NUMBER := -1;
1257: l_creation_date DATE := SYSDATE;

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

1250: l_api_name CONSTANT VARCHAR2(30) := 'JTF_TASK_AUDITS_PVT';
1251: l_api_version CONSTANT NUMBER := 1.0;
1252: l_rowid ROWID;
1253: l_init_msg_list VARCHAR2(10) := fnd_api.g_false;
1254: l_commit VARCHAR2(10) := fnd_api.g_false;
1255: l_last_update_date DATE := SYSDATE;
1256: l_last_updated_by NUMBER := -1;
1257: l_creation_date DATE := SYSDATE;
1258: l_task_audit_id NUMBER;

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

1493: aud_rec tsk_aud%ROWTYPE;
1494: BEGIN
1495: SAVEPOINT process_task_audit_pvt;
1496:
1497: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1498: THEN
1499: RAISE fnd_api.g_exc_unexpected_error;
1500: END IF;
1501:

Line 1499: RAISE fnd_api.g_exc_unexpected_error;

1495: SAVEPOINT process_task_audit_pvt;
1496:
1497: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1498: THEN
1499: RAISE fnd_api.g_exc_unexpected_error;
1500: END IF;
1501:
1502: IF fnd_api.to_boolean (p_init_msg_list)
1503: THEN

Line 1502: IF fnd_api.to_boolean (p_init_msg_list)

1498: THEN
1499: RAISE fnd_api.g_exc_unexpected_error;
1500: END IF;
1501:
1502: IF fnd_api.to_boolean (p_init_msg_list)
1503: THEN
1504: fnd_msg_pub.initialize;
1505: END IF;
1506:

Line 1507: x_return_status := fnd_api.g_ret_sts_success;

1503: THEN
1504: fnd_msg_pub.initialize;
1505: END IF;
1506:
1507: x_return_status := fnd_api.g_ret_sts_success;
1508:
1509: OPEN tsk_aud (p_task_id);
1510:
1511: --dbms_output.put_line(' opening cursor....');

Line 1579: p_init_msg_list => fnd_api.g_false,

1575:
1576: --dbms_output.put_line(' calling process tasks...... ');
1577: jtf_task_audits_pvt.process_task_audits (
1578: p_api_version => 1.0,
1579: p_init_msg_list => fnd_api.g_false,
1580: p_commit => fnd_api.g_false,
1581: p_object_version_number => p_object_version_number ,
1582: x_return_status => x_return_status,
1583: x_msg_count => x_msg_count,

Line 1580: p_commit => fnd_api.g_false,

1576: --dbms_output.put_line(' calling process tasks...... ');
1577: jtf_task_audits_pvt.process_task_audits (
1578: p_api_version => 1.0,
1579: p_init_msg_list => fnd_api.g_false,
1580: p_commit => fnd_api.g_false,
1581: p_object_version_number => p_object_version_number ,
1582: x_return_status => x_return_status,
1583: x_msg_count => x_msg_count,
1584: x_msg_data => x_msg_data,

Line 1710: IF fnd_api.to_boolean (p_commit)

1706: p_new_location_id => l_new_location_id,
1707: x_task_audit_id => x_task_audit_id
1708: );
1709:
1710: IF fnd_api.to_boolean (p_commit)
1711: THEN
1712: COMMIT WORK;
1713: END IF;
1714:

Line 1717: WHEN fnd_api.g_exc_error

1713: END IF;
1714:
1715: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1716: EXCEPTION
1717: WHEN fnd_api.g_exc_error
1718: THEN
1719: ROLLBACK TO process_task_audit_pvt;
1720: x_return_status := fnd_api.g_ret_sts_error;
1721: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1720: x_return_status := fnd_api.g_ret_sts_error;

1716: EXCEPTION
1717: WHEN fnd_api.g_exc_error
1718: THEN
1719: ROLLBACK TO process_task_audit_pvt;
1720: x_return_status := fnd_api.g_ret_sts_error;
1721: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1722: WHEN fnd_api.g_exc_unexpected_error
1723: THEN
1724: ROLLBACK TO process_task_audit_pvt;

Line 1722: WHEN fnd_api.g_exc_unexpected_error

1718: THEN
1719: ROLLBACK TO process_task_audit_pvt;
1720: x_return_status := fnd_api.g_ret_sts_error;
1721: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1722: WHEN fnd_api.g_exc_unexpected_error
1723: THEN
1724: ROLLBACK TO process_task_audit_pvt;
1725: x_return_status := fnd_api.g_ret_sts_unexp_error;
1726: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1725: x_return_status := fnd_api.g_ret_sts_unexp_error;

1721: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1722: WHEN fnd_api.g_exc_unexpected_error
1723: THEN
1724: ROLLBACK TO process_task_audit_pvt;
1725: x_return_status := fnd_api.g_ret_sts_unexp_error;
1726: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1727: WHEN OTHERS
1728: THEN
1729: ROLLBACK TO process_task_audit_pvt;

Line 1730: x_return_status := fnd_api.g_ret_sts_unexp_error;

1726: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1727: WHEN OTHERS
1728: THEN
1729: ROLLBACK TO process_task_audit_pvt;
1730: x_return_status := fnd_api.g_ret_sts_unexp_error;
1731:
1732: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1733: THEN
1734: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);