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

Line 5: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1: PACKAGE BODY jtf_ec_contacts_pvt AS
2: /* $Header: jtfeccob.pls 115.14 2003/02/04 11:55:08 siyappan ship $ */
3: PROCEDURE create_escalation_contacts (
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_escalation_id IN NUMBER DEFAULT NULL,
8: p_escalation_number IN VARCHAR2 DEFAULT NULL,
9: p_contact_id IN NUMBER,

Line 6: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2: /* $Header: jtfeccob.pls 115.14 2003/02/04 11:55:08 siyappan ship $ */
3: PROCEDURE create_escalation_contacts (
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_escalation_id IN NUMBER DEFAULT NULL,
8: p_escalation_number IN VARCHAR2 DEFAULT NULL,
9: p_contact_id IN NUMBER,
10: p_contact_type_code IN VARCHAR2 DEFAULT NULL,

Line 44: x_return_status := fnd_api.g_ret_sts_success;

40: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
41: x CHAR;
42: BEGIN
43: SAVEPOINT create_escalation_contacts_pub;
44: x_return_status := fnd_api.g_ret_sts_success;
45:
46: IF NOT fnd_api.compatible_api_call (
47: l_api_version,
48: p_api_version,

Line 46: IF NOT fnd_api.compatible_api_call (

42: BEGIN
43: SAVEPOINT create_escalation_contacts_pub;
44: x_return_status := fnd_api.g_ret_sts_success;
45:
46: IF NOT fnd_api.compatible_api_call (
47: l_api_version,
48: p_api_version,
49: l_api_name,
50: g_pkg_name

Line 53: RAISE fnd_api.g_exc_unexpected_error;

49: l_api_name,
50: g_pkg_name
51: )
52: THEN
53: RAISE fnd_api.g_exc_unexpected_error;
54: END IF;
55:
56: IF fnd_api.to_boolean (p_init_msg_list)
57: THEN

Line 56: IF fnd_api.to_boolean (p_init_msg_list)

52: THEN
53: RAISE fnd_api.g_exc_unexpected_error;
54: END IF;
55:
56: IF fnd_api.to_boolean (p_init_msg_list)
57: THEN
58: fnd_msg_pub.initialize;
59: END IF;
60:

Line 70: RAISE fnd_api.g_exc_unexpected_error;

66: fnd_message.set_name('JTF', 'JTF_API_ALL_DUPLICATE_VALUE');
67: fnd_message.set_token('API_NAME', l_api_name);
68: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'Contact ID: ' || to_char(p_contact_id));
69: fnd_msg_pub.add;
70: RAISE fnd_api.g_exc_unexpected_error;
71: end if;
72: --end
73:
74: jtf_task_contacts_pub.create_task_contacts (

Line 76: p_init_msg_list => fnd_api.g_false,

72: --end
73:
74: jtf_task_contacts_pub.create_task_contacts (
75: p_api_version => 1.0,
76: p_init_msg_list => fnd_api.g_false,
77: p_commit => fnd_api.g_false,
78: p_task_id => p_escalation_id,
79: p_task_number => p_escalation_number,
80: p_contact_id => p_contact_id,

Line 77: p_commit => fnd_api.g_false,

73:
74: jtf_task_contacts_pub.create_task_contacts (
75: p_api_version => 1.0,
76: p_init_msg_list => fnd_api.g_false,
77: p_commit => fnd_api.g_false,
78: p_task_id => p_escalation_id,
79: p_task_number => p_escalation_number,
80: p_contact_id => p_contact_id,
81: p_contact_type_code => p_contact_type_code,

Line 106: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

102: p_attribute15 => p_attribute15,
103: p_attribute_category => p_attribute_category
104: );
105:
106: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
107: THEN
108: x_return_status := fnd_api.g_ret_sts_unexp_error;
109: RAISE fnd_api.g_exc_unexpected_error;
110: END IF;

Line 108: x_return_status := fnd_api.g_ret_sts_unexp_error;

104: );
105:
106: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
107: THEN
108: x_return_status := fnd_api.g_ret_sts_unexp_error;
109: RAISE fnd_api.g_exc_unexpected_error;
110: END IF;
111:
112: IF fnd_api.to_boolean (p_commit)

Line 109: RAISE fnd_api.g_exc_unexpected_error;

105:
106: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
107: THEN
108: x_return_status := fnd_api.g_ret_sts_unexp_error;
109: RAISE fnd_api.g_exc_unexpected_error;
110: END IF;
111:
112: IF fnd_api.to_boolean (p_commit)
113: THEN

Line 112: IF fnd_api.to_boolean (p_commit)

108: x_return_status := fnd_api.g_ret_sts_unexp_error;
109: RAISE fnd_api.g_exc_unexpected_error;
110: END IF;
111:
112: IF fnd_api.to_boolean (p_commit)
113: THEN
114: COMMIT WORK;
115: END IF;
116:

Line 120: WHEN fnd_api.g_exc_unexpected_error

116:
117: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
118:
119: EXCEPTION
120: WHEN fnd_api.g_exc_unexpected_error
121: THEN
122: ROLLBACK TO create_escalation_contacts_pub;
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 123: x_return_status := fnd_api.g_ret_sts_unexp_error;

119: EXCEPTION
120: WHEN fnd_api.g_exc_unexpected_error
121: THEN
122: ROLLBACK TO create_escalation_contacts_pub;
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
125: WHEN OTHERS
126: THEN
127: ROLLBACK TO create_escalation_contacts_pub;

Line 130: x_return_status := fnd_api.g_ret_sts_unexp_error;

126: THEN
127: ROLLBACK TO create_escalation_contacts_pub;
128: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
129: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
130: x_return_status := fnd_api.g_ret_sts_unexp_error;
131: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
132: END;
133:
134: PROCEDURE update_escalation_contacts (

Line 136: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

132: END;
133:
134: PROCEDURE update_escalation_contacts (
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
137: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
138: p_object_version_number IN OUT NOCOPY VARCHAR2,
139: p_escalation_contact_id IN NUMBER DEFAULT NULL,
140: p_contact_id IN NUMBER,

Line 137: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

133:
134: PROCEDURE update_escalation_contacts (
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
137: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
138: p_object_version_number IN OUT NOCOPY VARCHAR2,
139: p_escalation_contact_id IN NUMBER DEFAULT NULL,
140: p_contact_id IN NUMBER,
141: p_contact_type_code IN VARCHAR2 DEFAULT NULL,

Line 170: x_return_status := fnd_api.g_ret_sts_success;

166: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_CONTACTS';
167: l_object_version_number NUMBER;
168: BEGIN
169: SAVEPOINT update_escalation_contacts_pub;
170: x_return_status := fnd_api.g_ret_sts_success;
171:
172: IF NOT fnd_api.compatible_api_call (
173: l_api_version,
174: p_api_version,

Line 172: IF NOT fnd_api.compatible_api_call (

168: BEGIN
169: SAVEPOINT update_escalation_contacts_pub;
170: x_return_status := fnd_api.g_ret_sts_success;
171:
172: IF NOT fnd_api.compatible_api_call (
173: l_api_version,
174: p_api_version,
175: l_api_name,
176: g_pkg_name

Line 179: RAISE fnd_api.g_exc_unexpected_error;

175: l_api_name,
176: g_pkg_name
177: )
178: THEN
179: RAISE fnd_api.g_exc_unexpected_error;
180: END IF;
181:
182: IF fnd_api.to_boolean (p_init_msg_list)
183: THEN

Line 182: IF fnd_api.to_boolean (p_init_msg_list)

178: THEN
179: RAISE fnd_api.g_exc_unexpected_error;
180: END IF;
181:
182: IF fnd_api.to_boolean (p_init_msg_list)
183: THEN
184: fnd_msg_pub.initialize;
185: END IF;
186:

Line 187: x_return_status := fnd_api.g_ret_sts_success;

183: THEN
184: fnd_msg_pub.initialize;
185: END IF;
186:
187: x_return_status := fnd_api.g_ret_sts_success;
188: l_object_version_number := p_object_version_number;
189: jtf_task_contacts_pub.update_task_contacts (
190: p_api_version => p_api_version,
191: p_init_msg_list => p_init_msg_list,

Line 222: IF fnd_api.to_boolean (p_commit)

218: );
219:
220: p_object_version_number := l_object_version_number;
221:
222: IF fnd_api.to_boolean (p_commit)
223: THEN
224: COMMIT WORK;
225: END IF;
226:

Line 229: WHEN fnd_api.g_exc_unexpected_error

225: END IF;
226:
227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
228: EXCEPTION
229: WHEN fnd_api.g_exc_unexpected_error
230: THEN
231: ROLLBACK TO update_escalation_contacts_pub;
232: x_return_status := fnd_api.g_ret_sts_unexp_error;
233: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 232: x_return_status := fnd_api.g_ret_sts_unexp_error;

228: EXCEPTION
229: WHEN fnd_api.g_exc_unexpected_error
230: THEN
231: ROLLBACK TO update_escalation_contacts_pub;
232: x_return_status := fnd_api.g_ret_sts_unexp_error;
233: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
234: WHEN OTHERS
235: THEN
236: ROLLBACK TO update_escalation_contacts_pub;

Line 239: x_return_status := fnd_api.g_ret_sts_unexp_error;

235: THEN
236: ROLLBACK TO update_escalation_contacts_pub;
237: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
238: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
239: x_return_status := fnd_api.g_ret_sts_unexp_error;
240: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
241: END;
242:
243: PROCEDURE delete_escalation_contacts (

Line 245: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

241: END;
242:
243: PROCEDURE delete_escalation_contacts (
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
246: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
247: p_object_version_number IN NUMBER,
248: p_escalation_contact_id IN NUMBER,
249: x_return_status OUT NOCOPY VARCHAR2,

Line 246: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

242:
243: PROCEDURE delete_escalation_contacts (
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
246: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
247: p_object_version_number IN NUMBER,
248: p_escalation_contact_id IN NUMBER,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_data OUT NOCOPY VARCHAR2,

Line 258: x_return_status := fnd_api.g_ret_sts_success;

254: l_api_version CONSTANT NUMBER := 1.0;
255: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK_CONTACTS';
256: BEGIN
257: SAVEPOINT delete_escalation_contacts_pub;
258: x_return_status := fnd_api.g_ret_sts_success;
259: x_return_status := fnd_api.g_ret_sts_success;
260:
261: IF NOT fnd_api.compatible_api_call (
262: l_api_version,

Line 259: x_return_status := fnd_api.g_ret_sts_success;

255: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TASK_CONTACTS';
256: BEGIN
257: SAVEPOINT delete_escalation_contacts_pub;
258: x_return_status := fnd_api.g_ret_sts_success;
259: x_return_status := fnd_api.g_ret_sts_success;
260:
261: IF NOT fnd_api.compatible_api_call (
262: l_api_version,
263: p_api_version,

Line 261: IF NOT fnd_api.compatible_api_call (

257: SAVEPOINT delete_escalation_contacts_pub;
258: x_return_status := fnd_api.g_ret_sts_success;
259: x_return_status := fnd_api.g_ret_sts_success;
260:
261: IF NOT fnd_api.compatible_api_call (
262: l_api_version,
263: p_api_version,
264: l_api_name,
265: g_pkg_name

Line 268: RAISE fnd_api.g_exc_unexpected_error;

264: l_api_name,
265: g_pkg_name
266: )
267: THEN
268: RAISE fnd_api.g_exc_unexpected_error;
269: END IF;
270:
271: IF fnd_api.to_boolean (p_init_msg_list)
272: THEN

Line 271: IF fnd_api.to_boolean (p_init_msg_list)

267: THEN
268: RAISE fnd_api.g_exc_unexpected_error;
269: END IF;
270:
271: IF fnd_api.to_boolean (p_init_msg_list)
272: THEN
273: fnd_msg_pub.initialize;
274: END IF;
275:

Line 276: x_return_status := fnd_api.g_ret_sts_success;

272: THEN
273: fnd_msg_pub.initialize;
274: END IF;
275:
276: x_return_status := fnd_api.g_ret_sts_success;
277: jtf_task_contacts_pub.delete_task_contacts (
278: p_api_version => p_api_version,
279: p_init_msg_list => p_init_msg_list,
280: p_commit => p_commit,

Line 288: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

284: x_msg_data => x_msg_data,
285: x_msg_count => x_msg_count
286: );
287:
288: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
289: THEN
290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: RAISE fnd_api.g_exc_unexpected_error;
292: END IF;

Line 290: x_return_status := fnd_api.g_ret_sts_unexp_error;

286: );
287:
288: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
289: THEN
290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: RAISE fnd_api.g_exc_unexpected_error;
292: END IF;
293:
294: IF fnd_api.to_boolean (p_commit)

Line 291: RAISE fnd_api.g_exc_unexpected_error;

287:
288: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
289: THEN
290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: RAISE fnd_api.g_exc_unexpected_error;
292: END IF;
293:
294: IF fnd_api.to_boolean (p_commit)
295: THEN

Line 294: IF fnd_api.to_boolean (p_commit)

290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: RAISE fnd_api.g_exc_unexpected_error;
292: END IF;
293:
294: IF fnd_api.to_boolean (p_commit)
295: THEN
296: COMMIT WORK;
297: END IF;
298:

Line 301: WHEN fnd_api.g_exc_unexpected_error

297: END IF;
298:
299: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
300: EXCEPTION
301: WHEN fnd_api.g_exc_unexpected_error
302: THEN
303: ROLLBACK TO delete_task_contacts_pvt;
304: x_return_status := fnd_api.g_ret_sts_unexp_error;
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 304: x_return_status := fnd_api.g_ret_sts_unexp_error;

300: EXCEPTION
301: WHEN fnd_api.g_exc_unexpected_error
302: THEN
303: ROLLBACK TO delete_task_contacts_pvt;
304: x_return_status := fnd_api.g_ret_sts_unexp_error;
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
306: WHEN OTHERS
307: THEN
308: ROLLBACK TO delete_task_contacts_pvt;

Line 311: x_return_status := fnd_api.g_ret_sts_unexp_error;

307: THEN
308: ROLLBACK TO delete_task_contacts_pvt;
309: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
310: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
313: END;
314: END;