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_DEPENDENCY_PVT dependencies on FND_MSG_PUB

Line 69: fnd_msg_pub.add;

65:
66: if l_master_start_date > l_child_start_date
67: then
68: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPEND_S2S');
69: fnd_msg_pub.add;
70: raise fnd_api.g_exc_error;
71: end if;
72:
73: -- Dependency type code is 'FF'

Line 86: fnd_msg_pub.add;

82:
83: if (l_master_end_date > l_child_end_date)
84: then
85: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPEND_F2F');
86: fnd_msg_pub.add;
87: raise fnd_api.g_exc_error;
88: end if;
89:
90: -- Dependency type code is 'FS'

Line 103: fnd_msg_pub.add;

99:
100: if (l_master_end_date > l_child_start_date)
101: then
102: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPEND_F2S');
103: fnd_msg_pub.add;
104: raise fnd_api.g_exc_error;
105: end if;
106:
107: -- Dependency type code is 'SF'

Line 120: fnd_msg_pub.add;

116:
117: if (l_master_start_date > l_child_end_date)
118: then
119: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPEND_S2F');
120: fnd_msg_pub.add;
121: raise fnd_api.g_exc_error;
122: end if;
123: end if;
124:

Line 135: fnd_msg_pub.add;

131: when others
132: then
133: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
134: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
135: fnd_msg_pub.add;
136: return fnd_api.g_ret_sts_unexp_error;
137: end;
138:
139:

Line 204: fnd_msg_pub.add;

200: if p_task_id = p_dependent_on_task_id
201: then
202: l_return_status := fnd_api.g_ret_sts_error;
203: fnd_message.set_name ('JTF', 'JTF_TASK_ITSELF_DEPENDS');
204: fnd_msg_pub.add;
205: raise fnd_api.g_exc_error;
206: end if;
207:
208: if (p_template_flag = 'Y')

Line 218: fnd_msg_pub.add;

214: then
215: close c_check_dup_temp_y;
216: l_return_status := fnd_api.g_ret_sts_error;
217: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_EXISTS');
218: fnd_msg_pub.add;
219: raise fnd_api.g_exc_error;
220: end if;
221: close c_check_dup_temp_y;
222:

Line 231: fnd_msg_pub.add;

227: then
228: close c_check_dup_temp_y;
229: l_return_status := fnd_api.g_ret_sts_error;
230: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_RVERSE_EXISTS');
231: fnd_msg_pub.add;
232: raise fnd_api.g_exc_error;
233: end if;
234: close c_check_dup_temp_y;
235:

Line 244: fnd_msg_pub.add;

240: then
241: close c_check_cyc_temp_y;
242: l_return_status := fnd_api.g_ret_sts_unexp_error;
243: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_CYCLICAL');
244: fnd_msg_pub.add;
245: raise fnd_api.g_exc_error;
246: end if;
247: close c_check_cyc_temp_y;
248: elsif (p_template_flag is null or p_template_flag = 'N')

Line 258: fnd_msg_pub.add;

254: then
255: close c_check_dup_temp_n;
256: l_return_status := fnd_api.g_ret_sts_error;
257: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_EXISTS');
258: fnd_msg_pub.add;
259: raise fnd_api.g_exc_error;
260: end if;
261: close c_check_dup_temp_n;
262:

Line 271: fnd_msg_pub.add;

267: then
268: close c_check_dup_temp_n;
269: l_return_status := fnd_api.g_ret_sts_error;
270: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_RVERSE_EXISTS');
271: fnd_msg_pub.add;
272: raise fnd_api.g_exc_error;
273: end if;
274: close c_check_dup_temp_n;
275:

Line 284: fnd_msg_pub.add;

280: then
281: close c_check_cyc_temp_n;
282: l_return_status := fnd_api.g_ret_sts_unexp_error;
283: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_CYCLICAL');
284: fnd_msg_pub.add;
285: raise fnd_api.g_exc_error;
286: end if;
287: close c_check_cyc_temp_n;
288: end if;

Line 303: fnd_msg_pub.add;

299: when others
300: then
301: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
302: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
303: fnd_msg_pub.add;
304: return fnd_api.g_ret_sts_unexp_error;
305: end;
306:
307: procedure reconnect_dependency (p_api_version in number,

Line 389: fnd_msg_pub.initialize;

385: end if;
386:
387: if fnd_api.to_boolean (p_init_msg_list)
388: then
389: fnd_msg_pub.initialize;
390: end if;
391: -- Walk through parent dependencies and reconnect them with child dependencies
392: for parent_depend in c_predecessor_dependency
393: loop

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

431: when fnd_api.g_exc_error
432: then
433: rollback to reconnect_dependency_pvt;
434: x_return_status := fnd_api.g_ret_sts_error;
435: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
436: when fnd_api.g_exc_unexpected_error
437: then
438: rollback to reconnect_dependency_pvt;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

436: when fnd_api.g_exc_unexpected_error
437: then
438: rollback to reconnect_dependency_pvt;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
441: when no_data_found
442: then
443: rollback to reconnect_dependency_pvt;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 446: fnd_msg_pub.add;

442: then
443: rollback to reconnect_dependency_pvt;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_DEPENDS');
446: fnd_msg_pub.add;
447: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
448: when others
449: then
450: rollback to reconnect_dependency_pvt;

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

443: rollback to reconnect_dependency_pvt;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_DEPENDS');
446: fnd_msg_pub.add;
447: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
448: when others
449: then
450: rollback to reconnect_dependency_pvt;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 454: fnd_msg_pub.add;

450: rollback to reconnect_dependency_pvt;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
453: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
454: fnd_msg_pub.add;
455: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
456: end;
457:
458:

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

451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
453: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
454: fnd_msg_pub.add;
455: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
456: end;
457:
458:
459: PROCEDURE create_task_dependency (

Line 516: fnd_msg_pub.initialize;

512: END IF;
513:
514: IF fnd_api.to_boolean (p_init_msg_list)
515: THEN
516: fnd_msg_pub.initialize;
517: END IF;
518:
519: -- Validate effort
520: jtf_task_utl.validate_effort (x_return_status => x_return_status,

Line 540: fnd_msg_pub.add;

536: then
537: fnd_message.set_name ('JTF', 'JTF_TASK_INCONSISTENT_TEMP');
538: fnd_message.set_token ('P_TASK_TEMPLATE_1', p_task_id);
539: fnd_message.set_token ('P_TASK_TEMPLATE_2', p_dependent_on_task_id);
540: fnd_msg_pub.add;
541: raise fnd_api.g_exc_unexpected_error;
542: end if;
543: else
544: jtf_task_utl.get_object_details (p_task_id => p_task_id,

Line 577: fnd_msg_pub.add;

573: (l_source_object_type_code is not null and
574: l_d_source_object_type_code is null))
575: then
576: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');
577: fnd_msg_pub.add;
578: raise fnd_api.g_exc_error;
579: end if;
580:
581: if (l_source_object_type_code is not null and l_d_source_object_type_code is not null)

Line 586: fnd_msg_pub.add;

582: then
583: if (l_source_object_type_code <> l_d_source_object_type_code)
584: then
585: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');
586: fnd_msg_pub.add;
587: raise fnd_api.g_exc_error;
588: end if;
589: end if;
590: end if;

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

657: WHEN fnd_api.g_exc_error
658: THEN
659: ROLLBACK TO create_task_dependency_pvt;
660: x_return_status := fnd_api.g_ret_sts_error;
661: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
662: WHEN fnd_api.g_exc_unexpected_error
663: THEN
664: ROLLBACK TO create_task_dependency_pvt;
665: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

662: WHEN fnd_api.g_exc_unexpected_error
663: THEN
664: ROLLBACK TO create_task_dependency_pvt;
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
667: WHEN no_data_found
668: THEN
669: ROLLBACK TO create_task_dependency_pvt;
670: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 672: fnd_msg_pub.add;

668: THEN
669: ROLLBACK TO create_task_dependency_pvt;
670: x_return_status := fnd_api.g_ret_sts_unexp_error;
671: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_DEPENDS');
672: fnd_msg_pub.add;
673: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
674: WHEN OTHERS
675: THEN
676: ROLLBACK TO create_task_dependency_pvt;

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

669: ROLLBACK TO create_task_dependency_pvt;
670: x_return_status := fnd_api.g_ret_sts_unexp_error;
671: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_DEPENDS');
672: fnd_msg_pub.add;
673: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
674: WHEN OTHERS
675: THEN
676: ROLLBACK TO create_task_dependency_pvt;
677: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 680: fnd_msg_pub.add;

676: ROLLBACK TO create_task_dependency_pvt;
677: x_return_status := fnd_api.g_ret_sts_unexp_error;
678: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
679: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
680: fnd_msg_pub.add;
681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
682: END;
683:
684: /**********************************************************************************************************

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

677: x_return_status := fnd_api.g_ret_sts_unexp_error;
678: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
679: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
680: fnd_msg_pub.add;
681: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
682: END;
683:
684: /**********************************************************************************************************
685: ***********************************************************************************************************

Line 784: fnd_msg_pub.add;

780: IF c_jtf_task_depends%NOTFOUND
781: THEN
782: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
783: fnd_message.set_token ('P_DEPENDENCY_ID', p_dependency_id);
784: fnd_msg_pub.add;
785: x_return_status := fnd_api.g_ret_sts_unexp_error;
786: RAISE fnd_api.g_exc_unexpected_error;
787: END IF;
788:

Line 842: fnd_msg_pub.add;

838: then
839: fnd_message.set_name ('JTF', 'JTF_TASK_INCONSISTENT_TEMP');
840: fnd_message.set_token ('P_TASK_TEMPLATE_1', p_task_id);
841: fnd_message.set_token ('P_TASK_TEMPLATE_2', p_dependent_on_task_id);
842: fnd_msg_pub.add;
843: raise fnd_api.g_exc_unexpected_error;
844: end if;
845: else
846: jtf_task_utl.get_object_details (p_task_id => p_task_id,

Line 879: fnd_msg_pub.add;

875: (l_source_object_type_code is not null and
876: l_d_source_object_type_code is null))
877: then
878: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');
879: fnd_msg_pub.add;
880: raise fnd_api.g_exc_error;
881: end if;
882:
883: if (l_source_object_type_code is not null and l_d_source_object_type_code is not null)

Line 888: fnd_msg_pub.add;

884: then
885: if (l_source_object_type_code <> l_d_source_object_type_code)
886: then
887: fnd_message.set_name ('JTF', 'JTF_TASK_DEPENDS_TYPE_CODE');
888: fnd_msg_pub.add;
889: raise fnd_api.g_exc_error;
890: end if;
891: end if;
892: end if;

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

956: END IF;
957:
958: p_object_version_number := p_object_version_number + 1;
959:
960: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
961: EXCEPTION
962: /*
963: Bug 3342398
964: Added handle of fnd_api.g_exc_error.

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

966: WHEN fnd_api.g_exc_error
967: THEN
968: ROLLBACK TO update_task_dependency_pvt;
969: x_return_status := fnd_api.g_ret_sts_error;
970: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
971: WHEN fnd_api.g_exc_unexpected_error
972: THEN
973: IF c_jtf_task_depends%ISOPEN
974: THEN

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

975: CLOSE c_jtf_task_depends;
976: END IF;
977: ROLLBACK TO update_task_dependency_pvt;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
980: WHEN no_data_found
981: THEN
982: ROLLBACK TO create_task_dependency_pvt;
983: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 985: fnd_msg_pub.add;

981: THEN
982: ROLLBACK TO create_task_dependency_pvt;
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_DEPENDS');
985: fnd_msg_pub.add;
986: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
987: WHEN Resource_Locked then
988: ROLLBACK TO lock_task_depends_pub;
989: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');

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

982: ROLLBACK TO create_task_dependency_pvt;
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_DEPENDS');
985: fnd_msg_pub.add;
986: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
987: WHEN Resource_Locked then
988: ROLLBACK TO lock_task_depends_pub;
989: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
990: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');

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

988: ROLLBACK TO lock_task_depends_pub;
989: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
990: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
991: x_return_status := fnd_api.g_ret_sts_unexp_error;
992: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
993: WHEN OTHERS
994: THEN
995: IF c_jtf_task_depends%ISOPEN
996: THEN

Line 1004: fnd_msg_pub.add;

1000: ROLLBACK TO update_task_dependency_pvt;
1001: x_return_status := fnd_api.g_ret_sts_unexp_error;
1002: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1003: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1004: fnd_msg_pub.add;
1005: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1006: END;
1007:
1008: /**********************************************************************************************************

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

1001: x_return_status := fnd_api.g_ret_sts_unexp_error;
1002: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1003: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1004: fnd_msg_pub.add;
1005: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1006: END;
1007:
1008: /**********************************************************************************************************
1009: ***********************************************************************************************************

Line 1054: fnd_msg_pub.add;

1050:
1051: IF c_jtf_task_depends%FOUND
1052: THEN
1053: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_DEPEND');
1054: fnd_msg_pub.add;
1055: x_return_status := fnd_api.g_ret_sts_unexp_error;
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: CLOSE c_jtf_task_depends;
1058: ELSE

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

1068: THEN
1069: COMMIT WORK;
1070: END IF;
1071:
1072: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1073: EXCEPTION
1074: /*
1075: Bug 3342398
1076: Added handle of fnd_api.g_exc_error.

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

1078: WHEN fnd_api.g_exc_error
1079: THEN
1080: ROLLBACK TO delete_task_dependency_pvt;
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1083: WHEN fnd_api.g_exc_unexpected_error
1084: THEN
1085: ROLLBACK TO delete_task_dependency_pvt;
1086: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1083: WHEN fnd_api.g_exc_unexpected_error
1084: THEN
1085: ROLLBACK TO delete_task_dependency_pvt;
1086: x_return_status := fnd_api.g_ret_sts_unexp_error;
1087: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1088: WHEN Resource_Locked then
1089: ROLLBACK TO lock_task_depends_pub;
1090: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
1091: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');

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

1089: ROLLBACK TO lock_task_depends_pub;
1090: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
1091: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
1092: x_return_status := fnd_api.g_ret_sts_unexp_error;
1093: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1094: WHEN OTHERS
1095: THEN
1096: ROLLBACK TO delete_task_dependency_pvt;
1097: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1100: fnd_msg_pub.add;

1096: ROLLBACK TO delete_task_dependency_pvt;
1097: x_return_status := fnd_api.g_ret_sts_unexp_error;
1098: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1099: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1100: fnd_msg_pub.add;
1101: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1102: END;
1103: END; -- CREATE OR REPLACE PACKAGE spec

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

1097: x_return_status := fnd_api.g_ret_sts_unexp_error;
1098: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1099: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1100: fnd_msg_pub.add;
1101: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1102: END;
1103: END; -- CREATE OR REPLACE PACKAGE spec