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_MSG_PUB

Line 105: fnd_msg_pub.initialize;

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 */
109:

Line 118: fnd_msg_pub.add;

114:
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))

Line 126: fnd_msg_pub.add;

122: (l_group_end_date < TRUNC(SYSDATE))
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:

Line 141: fnd_msg_pub.add;

137:
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))

Line 149: fnd_msg_pub.add;

145: (l_org_end_date < TRUNC(SYSDATE))
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 */

Line 163: fnd_msg_pub.add;

159: IF (l_mapping_exist = 'Y') THEN
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 */

Line 225: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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);
226:
227: EXCEPTION
228:
229: WHEN fnd_api.g_exc_error THEN

Line 232: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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
236: ROLLBACK TO create_group_org;

Line 238: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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
242: ROLLBACK TO create_group_org;

Line 247: FND_MSG_PUB.add;

243: fnd_message.set_name ('JTF', 'JTF_RS_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:

Line 249: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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;
253:

Line 334: fnd_msg_pub.initialize;

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
338: OPEN c_group_org_update(l_group_id, l_organization_id);

Line 345: fnd_msg_pub.add;

341: CLOSE c_group_org_update;
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;

Line 357: fnd_msg_pub.add;

353: THEN
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

Line 398: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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);
399:
400: EXCEPTION
401: WHEN fnd_api.g_exc_error THEN
402: ROLLBACK TO sp_update_group_org;

Line 404: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
408: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 408: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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');
412: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 415: FND_MSG_PUB.add;

411: fnd_message.set_name ('JTF', 'JTF_RS_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;

Line 417: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
421:

Line 464: fnd_msg_pub.initialize;

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 */
468:

Line 477: fnd_msg_pub.add;

473: IF (l_object_version_number IS NULL) THEN
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

Line 487: fnd_msg_pub.add;

483: THEN
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*/

Line 501: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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);
502:
503: EXCEPTION
504:
505: WHEN fnd_api.g_exc_error THEN

Line 508: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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;
512: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 513: 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;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 521: FND_MSG_PUB.add;

517: fnd_message.set_name ('JTF', 'JTF_RS_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:

Line 523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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;
527: