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

Line 98: x_return_status := fnd_api.g_ret_sts_success;

94: --initialize variables
95: l_group_id := p_group_id;
96: l_organization_id := p_organization_id;
97: l_mapping_exist := 'N';
98: x_return_status := fnd_api.g_ret_sts_success;
99:
100: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;

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

96: l_organization_id := p_organization_id;
97: l_mapping_exist := 'N';
98: x_return_status := fnd_api.g_ret_sts_success;
99:
100: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;
103:
104: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 101: RAISE fnd_api.g_exc_unexpected_error;

97: l_mapping_exist := 'N';
98: x_return_status := fnd_api.g_ret_sts_success;
99:
100: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;
103:
104: IF fnd_api.to_boolean(p_init_msg_list) THEN
105: fnd_msg_pub.initialize;

Line 104: IF fnd_api.to_boolean(p_init_msg_list) THEN

100: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
101: RAISE fnd_api.g_exc_unexpected_error;
102: END IF;
103:
104: IF fnd_api.to_boolean(p_init_msg_list) THEN
105: fnd_msg_pub.initialize;
106: END IF;
107:
108: /* Validate that the group is valid and not end dated */

Line 119: RAISE fnd_api.g_exc_error;

115: IF (l_group_start_date IS NULL) THEN
116: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
117: fnd_message.set_token('P_GROUP_ID',l_group_id);
118: fnd_msg_pub.add;
119: RAISE fnd_api.g_exc_error;
120: ELSIF
121: ((l_group_start_date IS NOT NULL) AND
122: (l_group_end_date < TRUNC(SYSDATE))
123: ) THEN

Line 127: RAISE fnd_api.g_exc_error;

123: ) THEN
124: fnd_message.set_name('JTF', 'JTF_RS_INACTIVE_GROUP');
125: fnd_message.set_token('P_GROUP_NAME',l_group_name);
126: fnd_msg_pub.add;
127: RAISE fnd_api.g_exc_error;
128: END IF;
129:
130:
131: /* Validate that the HR Org is valid and not end dated */

Line 142: RAISE fnd_api.g_exc_error;

138: IF (l_org_start_date IS NULL) THEN
139: fnd_message.set_name('JTF', 'JTF_RS_INVALID_HR_ORG');
140: fnd_message.set_token('P_ORG_ID',l_organization_id);
141: fnd_msg_pub.add;
142: RAISE fnd_api.g_exc_error;
143: ELSIF
144: ((l_org_start_date IS NOT NULL) AND
145: (l_org_end_date < TRUNC(SYSDATE))
146: ) THEN

Line 150: RAISE fnd_api.g_exc_error;

146: ) THEN
147: fnd_message.set_name('JTF', 'JTF_RS_INACTIVE_HR_ORG');
148: fnd_message.set_token('P_ORG_NAME',l_org_name);
149: fnd_msg_pub.add;
150: RAISE fnd_api.g_exc_error;
151: END IF;
152:
153: /* Validate that Resource Group and HR Org mapping does not already exist */
154:

Line 164: RAISE fnd_api.g_exc_error;

160: fnd_message.set_name('JTF', 'JTF_RS_GROUP_ORG_MAP_EXIST');
161: fnd_message.set_token('P_GROUP_NAME',l_group_name);
162: fnd_message.set_token('P_ORG_NAME',l_org_name);
163: fnd_msg_pub.add;
164: RAISE fnd_api.g_exc_error;
165: END IF;
166:
167: /* Insert the row into the table */
168:

Line 221: IF fnd_api.to_boolean(p_commit) THEN

217: P_ATTRIBUTE15,
218: P_ATTRIBUTE_CATEGORY
219: );
220:
221: IF fnd_api.to_boolean(p_commit) THEN
222: COMMIT WORK;
223: END IF;
224:
225: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 229: WHEN fnd_api.g_exc_error THEN

225: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
226:
227: EXCEPTION
228:
229: WHEN fnd_api.g_exc_error THEN
230: ROLLBACK TO create_group_org;
231: x_return_status := fnd_api.g_ret_sts_error;
232: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
233: p_data => x_msg_data);

Line 231: x_return_status := fnd_api.g_ret_sts_error;

227: EXCEPTION
228:
229: WHEN fnd_api.g_exc_error THEN
230: ROLLBACK TO create_group_org;
231: x_return_status := fnd_api.g_ret_sts_error;
232: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
233: p_data => x_msg_data);
234:
235: WHEN fnd_api.g_exc_unexpected_error THEN

Line 235: WHEN fnd_api.g_exc_unexpected_error THEN

231: x_return_status := fnd_api.g_ret_sts_error;
232: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
233: p_data => x_msg_data);
234:
235: WHEN fnd_api.g_exc_unexpected_error THEN
236: ROLLBACK TO create_group_org;
237: x_return_status := fnd_api.g_ret_sts_unexp_error;
238: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
239: p_data => x_msg_data);

Line 237: x_return_status := fnd_api.g_ret_sts_unexp_error;

233: p_data => x_msg_data);
234:
235: WHEN fnd_api.g_exc_unexpected_error THEN
236: ROLLBACK TO create_group_org;
237: x_return_status := fnd_api.g_ret_sts_unexp_error;
238: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
239: p_data => x_msg_data);
240:
241: WHEN OTHERS THEN

Line 248: x_return_status := fnd_api.g_ret_sts_unexp_error;

244: fnd_message.set_token('P_SQLCODE',SQLCODE);
245: fnd_message.set_token('P_SQLERRM',SQLERRM);
246: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
247: FND_MSG_PUB.add;
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
250: p_data => x_msg_data);
251:
252: END create_group_org;

Line 298: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,

294: SELECT
295: group_id l_group_id,
296: organization_id l_organization_id,
297: object_version_number l_object_version_number,
298: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
299: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
300: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,

Line 299: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,

295: group_id l_group_id,
296: organization_id l_organization_id,
297: object_version_number l_object_version_number,
298: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
299: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
300: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,

Line 300: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,

296: organization_id l_organization_id,
297: object_version_number l_object_version_number,
298: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
299: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
300: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,

Line 301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,

297: object_version_number l_object_version_number,
298: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
299: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
300: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,

Line 302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,

298: DECODE(p_attribute1,fnd_api.g_miss_char, attribute1, p_attribute1) l_attribute1,
299: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
300: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,

Line 303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,

299: DECODE(p_attribute2,fnd_api.g_miss_char, attribute2, p_attribute2) l_attribute2,
300: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,

Line 304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,

300: DECODE(p_attribute3,fnd_api.g_miss_char, attribute3, p_attribute3) l_attribute3,
301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,

Line 305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,

301: DECODE(p_attribute4,fnd_api.g_miss_char, attribute4, p_attribute4) l_attribute4,
302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,

Line 306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,

302: DECODE(p_attribute5,fnd_api.g_miss_char, attribute5, p_attribute5) l_attribute5,
303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,

Line 307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,

303: DECODE(p_attribute6,fnd_api.g_miss_char, attribute6, p_attribute6) l_attribute6,
304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
311: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,

Line 308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,

304: DECODE(p_attribute7,fnd_api.g_miss_char, attribute7, p_attribute7) l_attribute7,
305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
311: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
312: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,

Line 309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,

305: DECODE(p_attribute8,fnd_api.g_miss_char, attribute8, p_attribute8) l_attribute8,
306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
311: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
312: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
313: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category

Line 310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,

306: DECODE(p_attribute9,fnd_api.g_miss_char, attribute9, p_attribute9) l_attribute9,
307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
311: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
312: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
313: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
314: FROM jtf_rs_group_organizations

Line 311: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,

307: DECODE(p_attribute10,fnd_api.g_miss_char, attribute10, p_attribute10) l_attribute10,
308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
311: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
312: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
313: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
314: FROM jtf_rs_group_organizations
315: WHERE group_id = ll_group_id

Line 312: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,

308: DECODE(p_attribute11,fnd_api.g_miss_char, attribute11, p_attribute11) l_attribute11,
309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
311: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
312: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
313: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
314: FROM jtf_rs_group_organizations
315: WHERE group_id = ll_group_id
316: AND organization_id = ll_organization_id;

Line 313: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category

309: DECODE(p_attribute12,fnd_api.g_miss_char, attribute12, p_attribute12) l_attribute12,
310: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
311: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
312: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
313: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute_category, p_attribute_category) l_attribute_category
314: FROM jtf_rs_group_organizations
315: WHERE group_id = ll_group_id
316: AND organization_id = ll_organization_id;
317:

Line 327: x_return_status := fnd_api.g_ret_sts_success;

323: -- initialize valriables
324: l_group_id := p_group_id;
325: l_organization_id := p_organization_id;
326: l_object_version_number := p_object_version_number;
327: x_return_status := fnd_api.g_ret_sts_success;
328:
329: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
330: RAISE fnd_api.g_exc_unexpected_error;
331: END IF;

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

325: l_organization_id := p_organization_id;
326: l_object_version_number := p_object_version_number;
327: x_return_status := fnd_api.g_ret_sts_success;
328:
329: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
330: RAISE fnd_api.g_exc_unexpected_error;
331: END IF;
332:
333: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 330: RAISE fnd_api.g_exc_unexpected_error;

326: l_object_version_number := p_object_version_number;
327: x_return_status := fnd_api.g_ret_sts_success;
328:
329: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
330: RAISE fnd_api.g_exc_unexpected_error;
331: END IF;
332:
333: IF fnd_api.to_boolean(p_init_msg_list) THEN
334: fnd_msg_pub.initialize;

Line 333: IF fnd_api.to_boolean(p_init_msg_list) THEN

329: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
330: RAISE fnd_api.g_exc_unexpected_error;
331: END IF;
332:
333: IF fnd_api.to_boolean(p_init_msg_list) THEN
334: fnd_msg_pub.initialize;
335: END IF;
336:
337: --Fetch the existing data from table

Line 346: RAISE fnd_api.g_exc_unexpected_error;

342: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');
343: fnd_message.set_token('P_GRP_ID', l_group_id);
344: fnd_message.set_token('P_ORG_ID', l_organization_id);
345: fnd_msg_pub.add;
346: RAISE fnd_api.g_exc_unexpected_error;
347: ELSE
348: CLOSE c_group_org_update;
349: END IF;
350:

Line 358: RAISE fnd_api.g_exc_error;

354: NULL;
355: ELSE
356: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
357: fnd_msg_pub.add;
358: RAISE fnd_api.g_exc_error;
359: END IF;
360:
361: --Update the Object Version Number by Incrementing It
362: l_object_version_number := l_object_version_number+1;

Line 394: IF fnd_api.to_boolean(p_commit) THEN

390: AND ORGANIZATION_ID = l_organization_id;
391:
392: p_object_version_number := l_object_version_number;
393:
394: IF fnd_api.to_boolean(p_commit) THEN
395: COMMIT WORK;
396: END IF;
397:
398: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 401: WHEN fnd_api.g_exc_error THEN

397:
398: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
399:
400: EXCEPTION
401: WHEN fnd_api.g_exc_error THEN
402: ROLLBACK TO sp_update_group_org;
403: x_return_status := fnd_api.g_ret_sts_error;
404: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
405: WHEN fnd_api.g_exc_unexpected_error THEN

Line 403: x_return_status := fnd_api.g_ret_sts_error;

399:
400: EXCEPTION
401: WHEN fnd_api.g_exc_error THEN
402: ROLLBACK TO sp_update_group_org;
403: x_return_status := fnd_api.g_ret_sts_error;
404: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
405: WHEN fnd_api.g_exc_unexpected_error THEN
406: ROLLBACK TO sp_update_group_org;
407: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 405: WHEN fnd_api.g_exc_unexpected_error THEN

401: WHEN fnd_api.g_exc_error THEN
402: ROLLBACK TO sp_update_group_org;
403: x_return_status := fnd_api.g_ret_sts_error;
404: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
405: WHEN fnd_api.g_exc_unexpected_error THEN
406: ROLLBACK TO sp_update_group_org;
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
409: WHEN OTHERS THEN

Line 407: x_return_status := fnd_api.g_ret_sts_unexp_error;

403: x_return_status := fnd_api.g_ret_sts_error;
404: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
405: WHEN fnd_api.g_exc_unexpected_error THEN
406: ROLLBACK TO sp_update_group_org;
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
409: WHEN OTHERS THEN
410: ROLLBACK TO sp_update_group_org;
411: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 416: x_return_status := fnd_api.g_ret_sts_unexp_error;

412: fnd_message.set_token('P_SQLCODE',SQLCODE);
413: fnd_message.set_token('P_SQLERRM',SQLERRM);
414: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
415: FND_MSG_PUB.add;
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
418:
419: END update_group_org;
420:

Line 457: x_return_status := fnd_api.g_ret_sts_success;

453: BEGIN
454:
455: SAVEPOINT sp_delete_group_org;
456:
457: x_return_status := fnd_api.g_ret_sts_success;
458:
459: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;

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

455: SAVEPOINT sp_delete_group_org;
456:
457: x_return_status := fnd_api.g_ret_sts_success;
458:
459: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 460: RAISE fnd_api.g_exc_unexpected_error;

456:
457: x_return_status := fnd_api.g_ret_sts_success;
458:
459: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: IF fnd_api.to_boolean(p_init_msg_list) THEN
464: fnd_msg_pub.initialize;

Line 463: IF fnd_api.to_boolean(p_init_msg_list) THEN

459: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
460: RAISE fnd_api.g_exc_unexpected_error;
461: END IF;
462:
463: IF fnd_api.to_boolean(p_init_msg_list) THEN
464: fnd_msg_pub.initialize;
465: END IF;
466:
467: /* Validate that the specified group id and organization_id is valid */

Line 478: RAISE fnd_api.g_exc_error;

474: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');
475: fnd_message.set_token('P_GRP_ID', p_group_id);
476: fnd_message.set_token('P_ORG_ID', p_organization_id);
477: fnd_msg_pub.add;
478: RAISE fnd_api.g_exc_error;
479: END IF;
480:
481: --Check if object Version numbers match
482: IF (l_object_version_number = p_object_version_number)

Line 488: RAISE fnd_api.g_exc_error;

484: NULL;
485: ELSE
486: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
487: fnd_msg_pub.add;
488: RAISE fnd_api.g_exc_error;
489: END IF;
490:
491: /* delete table data*/
492:

Line 497: IF fnd_api.to_boolean(p_commit) THEN

493: DELETE FROM jtf_rs_group_organizations
494: WHERE GROUP_ID = P_GROUP_ID
495: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
496:
497: IF fnd_api.to_boolean(p_commit) THEN
498: COMMIT WORK;
499: END IF;
500:
501: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 505: WHEN fnd_api.g_exc_error THEN

501: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
502:
503: EXCEPTION
504:
505: WHEN fnd_api.g_exc_error THEN
506: ROLLBACK TO sp_delete_group_org;
507: x_return_status := fnd_api.g_ret_sts_error;
508: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
509: p_data => x_msg_data);

Line 507: x_return_status := fnd_api.g_ret_sts_error;

503: EXCEPTION
504:
505: WHEN fnd_api.g_exc_error THEN
506: ROLLBACK TO sp_delete_group_org;
507: x_return_status := fnd_api.g_ret_sts_error;
508: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN fnd_api.g_exc_unexpected_error THEN
511: ROLLBACK TO sp_delete_group_org;

Line 510: WHEN fnd_api.g_exc_unexpected_error THEN

506: ROLLBACK TO sp_delete_group_org;
507: x_return_status := fnd_api.g_ret_sts_error;
508: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN fnd_api.g_exc_unexpected_error THEN
511: ROLLBACK TO sp_delete_group_org;
512: x_return_status := fnd_api.g_ret_sts_unexp_error;
513: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
514: p_data => x_msg_data);

Line 512: x_return_status := fnd_api.g_ret_sts_unexp_error;

508: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
509: p_data => x_msg_data);
510: WHEN fnd_api.g_exc_unexpected_error THEN
511: ROLLBACK TO sp_delete_group_org;
512: x_return_status := fnd_api.g_ret_sts_unexp_error;
513: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
514: p_data => x_msg_data);
515: WHEN OTHERS THEN
516: ROLLBACK TO sp_delete_group_org;

Line 522: x_return_status := fnd_api.g_ret_sts_unexp_error;

518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
524: p_data => x_msg_data);
525:
526: END delete_group_org;