DBA Data[Home] [Help]

APPS.JTF_TASK_CONTACTS_PUB dependencies on JTF_TASK_UTL

Line 113: jtf_task_utl.validate_task (

109: THEN
110: fnd_msg_pub.initialize;
111: END IF;
112:
113: jtf_task_utl.validate_task (
114: x_return_status => x_return_status,
115: p_task_id => p_task_id,
116: p_task_number => p_task_number,
117: x_task_id => l_task_id

Line 128: jtf_task_utl.validate_missing_task_id (

124: END IF;
125:
126:
127:
128: jtf_task_utl.validate_missing_task_id (
129: p_task_id => p_task_id,
130: x_return_status => x_return_status
131: );
132:

Line 141: jtf_task_utl.validate_missing_contact_id (

137: END IF;
138:
139:
140:
141: jtf_task_utl.validate_missing_contact_id (
142: p_task_contact_id => p_contact_id,
143: x_return_status => x_return_status
144: );
145:

Line 154: IF NOT jtf_task_utl.validate_lookup (

150: END IF;
151:
152:
153:
154: IF NOT jtf_task_utl.validate_lookup (
155: 'JTF_TASK_CONTACT_TYPE',
156: NVL (p_contact_type_code, 'CUST'),
157: 'Escalation Contact Point ( JTF_EC_CONTACT_TYPE)'
158: )

Line 164: jtf_task_utl.validate_contact (

160: x_return_status := fnd_api.g_ret_sts_unexp_error;
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163:
164: jtf_task_utl.validate_contact (
165: p_contact_id => p_contact_id,
166: p_task_id => p_task_id,
167: p_contact_type_code => NVL (p_contact_type_code, 'CUST'),
168: x_return_status => x_return_status

Line 178: jtf_task_utl.validate_flag (

174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: jtf_task_utl.validate_flag (
179: p_flag_name => jtf_task_utl.get_translated_lookup (
180: 'JTF_TASK_TRANSLATED_MESSAGES',
181: 'NOTIFICATION_FLAG'
182: ),

Line 179: p_flag_name => jtf_task_utl.get_translated_lookup (

175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177:
178: jtf_task_utl.validate_flag (
179: p_flag_name => jtf_task_utl.get_translated_lookup (
180: 'JTF_TASK_TRANSLATED_MESSAGES',
181: 'NOTIFICATION_FLAG'
182: ),
183: p_flag_value => p_escalation_notify_flag,

Line 193: jtf_task_utl.validate_flag (

189: x_return_status := fnd_api.g_ret_sts_unexp_error;
190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;
192:
193: jtf_task_utl.validate_flag (
194: p_flag_name => jtf_task_utl.get_translated_lookup (
195: 'JTF_TASK_TRANSLATED_MESSAGES',
196: 'ESCALATION_REQUESTOR_FLAG'
197: ),

Line 194: p_flag_name => jtf_task_utl.get_translated_lookup (

190: RAISE fnd_api.g_exc_unexpected_error;
191: END IF;
192:
193: jtf_task_utl.validate_flag (
194: p_flag_name => jtf_task_utl.get_translated_lookup (
195: 'JTF_TASK_TRANSLATED_MESSAGES',
196: 'ESCALATION_REQUESTOR_FLAG'
197: ),
198: p_flag_value => p_escalation_requester_flag,

Line 209: jtf_task_utl.check_duplicate_contact (

205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207:
208: -- Added this call for bug# 5140139
209: jtf_task_utl.check_duplicate_contact (
210: p_contact_id => p_contact_id,
211: p_task_id => p_task_id,
212: p_contact_type_code => NVL (p_contact_type_code, 'CUST'),
213: p_task_contact_id => NULL,

Line 228: IF p_primary_flag = jtf_task_utl.g_yes THEN

224: INTO l_task_contact_id
225: FROM dual;
226:
227: --Unmark the previous task id with primary flag = 'Y'.
228: IF p_primary_flag = jtf_task_utl.g_yes THEN
229: do_unmark_primary_flag_create( l_task_id );
230: END IF;
231:
232: -------------------------------------------

Line 236: l_primary_flag := jtf_task_utl.g_yes;

232: -------------------------------------------
233: -- For fixing a bug 2644132
234: IF is_this_first_contact(p_task_id)
235: THEN
236: l_primary_flag := jtf_task_utl.g_yes;
237: END IF;
238: -------------------------------------------
239:
240: jtf_task_contacts_pkg.insert_row (

Line 262: x_created_by => jtf_task_utl.created_by,

258: x_attribute2 => p_attribute2,
259: x_attribute3 => p_attribute3,
260: x_task_id => p_task_id,
261: x_creation_date => SYSDATE,
262: x_created_by => jtf_task_utl.created_by,
263: x_last_update_date => SYSDATE,
264: x_last_updated_by => jtf_task_utl.updated_by,
265: x_last_update_login => jtf_task_utl.login_id,
266: x_contact_type_code => p_contact_type_code,

Line 264: x_last_updated_by => jtf_task_utl.updated_by,

260: x_task_id => p_task_id,
261: x_creation_date => SYSDATE,
262: x_created_by => jtf_task_utl.created_by,
263: x_last_update_date => SYSDATE,
264: x_last_updated_by => jtf_task_utl.updated_by,
265: x_last_update_login => jtf_task_utl.login_id,
266: x_contact_type_code => p_contact_type_code,
267: x_escalation_notify_flag => p_escalation_notify_flag,
268: x_escalation_requester_flag => p_escalation_requester_flag,

Line 265: x_last_update_login => jtf_task_utl.login_id,

261: x_creation_date => SYSDATE,
262: x_created_by => jtf_task_utl.created_by,
263: x_last_update_date => SYSDATE,
264: x_last_updated_by => jtf_task_utl.updated_by,
265: x_last_update_login => jtf_task_utl.login_id,
266: x_contact_type_code => p_contact_type_code,
267: x_escalation_notify_flag => p_escalation_notify_flag,
268: x_escalation_requester_flag => p_escalation_requester_flag,
269: x_primary_flag => l_primary_flag -- For fixing a bug 2644132

Line 288: jtf_task_utl.create_party_reference (

284: -- ------------------------------------------------------------------------
285: -- Create reference to contact, fix for enh #1845501
286: -- ------------------------------------------------------------------------
287:
288: jtf_task_utl.create_party_reference (
289: p_reference_from => 'CONTACT',
290: p_task_id => p_task_id,
291: p_party_type_code => p_contact_type_code,
292: p_party_id => p_contact_id,

Line 595: jtf_task_utl.validate_missing_contact_id (

591:
592:
593:
594:
595: jtf_task_utl.validate_missing_contact_id (
596: p_task_contact_id => p_contact_id,
597: x_return_status => x_return_status
598: );
599:

Line 623: IF NOT jtf_task_utl.validate_lookup(

619: END IF;
620:
621:
622:
623: IF NOT jtf_task_utl.validate_lookup(
624: 'JTF_TASK_CONTACT_TYPE',
625: NVL (task_contacts.contact_type_code, 'CUST'),
626: 'Escalation Contact Point( JTF_EC_CONTACT_TYPE)'
627: )

Line 650: jtf_task_utl.validate_contact (

646: RAISE fnd_api.g_exc_unexpected_error;
647: END;
648:
649:
650: jtf_task_utl.validate_contact (
651: p_contact_id => task_contacts.contact_id,
652: p_task_id => task_contacts.task_id,
653: p_contact_type_code => task_contacts.contact_type_code,
654: x_return_status => x_return_status

Line 665: jtf_task_utl.validate_flag (

661: END IF;
662:
663:
664:
665: jtf_task_utl.validate_flag (
666: p_flag_name => jtf_task_utl.get_translated_lookup (
667: 'JTF_TASK_TRANSLATED_MESSAGES',
668: 'NOTIFICATION_FLAG'
669: ),

Line 666: p_flag_name => jtf_task_utl.get_translated_lookup (

662:
663:
664:
665: jtf_task_utl.validate_flag (
666: p_flag_name => jtf_task_utl.get_translated_lookup (
667: 'JTF_TASK_TRANSLATED_MESSAGES',
668: 'NOTIFICATION_FLAG'
669: ),
670: p_flag_value => task_contacts.escalation_notify_flag,

Line 682: jtf_task_utl.validate_flag (

678: END IF;
679:
680:
681:
682: jtf_task_utl.validate_flag (
683: p_flag_name => jtf_task_utl.get_translated_lookup (
684: 'JTF_TASK_TRANSLATED_MESSAGES',
685: 'ESCALATION_REQUESTOR_FLAG'
686: ),

Line 683: p_flag_name => jtf_task_utl.get_translated_lookup (

679:
680:
681:
682: jtf_task_utl.validate_flag (
683: p_flag_name => jtf_task_utl.get_translated_lookup (
684: 'JTF_TASK_TRANSLATED_MESSAGES',
685: 'ESCALATION_REQUESTOR_FLAG'
686: ),
687: p_flag_value => task_contacts.escalation_requester_flag,

Line 698: jtf_task_utl.check_duplicate_contact(

694: RAISE fnd_api.g_exc_unexpected_error;
695: END IF;
696:
697: -- Added this call for bug# 5140139
698: jtf_task_utl.check_duplicate_contact(
699: p_contact_id => task_contacts.contact_id,
700: p_task_id => task_contacts.task_id,
701: p_contact_type_code => NVL (task_contacts.contact_type_code, 'CUST'),
702: p_task_contact_id => p_task_contact_id,

Line 731: IF p_primary_flag = jtf_task_utl.g_yes THEN

727: END IF;
728:
729:
730: --unmark the previous task id with primary flag = 'Y'.
731: IF p_primary_flag = jtf_task_utl.g_yes THEN
732: do_unmark_primary_flag_update( P_task_contact_id );
733:
734: END IF;
735:

Line 773: x_last_updated_by => jtf_task_utl.updated_by,

769: x_attribute_category => task_contacts.attribute_category,
770: x_task_id => task_contacts.task_id,
771: x_contact_id => task_contacts.contact_id,
772: x_last_update_date => SYSDATE,
773: x_last_updated_by => jtf_task_utl.updated_by,
774: x_last_update_login => jtf_task_utl.login_id,
775: x_contact_type_code => task_contacts.contact_type_code,
776: x_escalation_notify_flag => task_contacts.escalation_notify_flag,
777: x_escalation_requester_flag => task_contacts.escalation_requester_flag,

Line 774: x_last_update_login => jtf_task_utl.login_id,

770: x_task_id => task_contacts.task_id,
771: x_contact_id => task_contacts.contact_id,
772: x_last_update_date => SYSDATE,
773: x_last_updated_by => jtf_task_utl.updated_by,
774: x_last_update_login => jtf_task_utl.login_id,
775: x_contact_type_code => task_contacts.contact_type_code,
776: x_escalation_notify_flag => task_contacts.escalation_notify_flag,
777: x_escalation_requester_flag => task_contacts.escalation_requester_flag,
778: x_primary_flag => task_contacts.primary_flag

Line 788: jtf_task_utl.delete_party_reference(

784: -- ------------------------------------------------------------------------
785: if (nvl(l_contact_id, 0) <> fnd_api.g_miss_num and
786: nvl(l_contact_id, 0) <> nvl(l_orig_con_id, 0)) then
787: -- delete the old one
788: jtf_task_utl.delete_party_reference(
789: p_reference_from => 'CONTACT',
790: p_task_id => l_task_id,
791: p_party_type_code => l_orig_type_code,
792: p_party_id => l_orig_con_id,

Line 803: jtf_task_utl.create_party_reference(

799: x_return_status := fnd_api.g_ret_sts_unexp_error;
800: RAISE fnd_api.g_exc_unexpected_error;
801: END IF;
802: -- create a new one
803: jtf_task_utl.create_party_reference(
804: p_reference_from => 'CONTACT',
805: p_task_id => l_task_id,
806: p_party_type_code => task_contacts.contact_type_code,
807: p_party_id => l_contact_id,

Line 898: jtf_task_utl.validate_missing_contact_id (

894: END IF;
895:
896: x_return_status := fnd_api.g_ret_sts_success;
897:
898: jtf_task_utl.validate_missing_contact_id (
899: p_task_contact_id => p_task_contact_id,
900: x_return_status => x_return_status
901: );
902:

Line 942: IF p_delete_cascade = jtf_task_utl.g_yes THEN

938: RAISE fnd_api.g_exc_unexpected_error;
939: END IF;
940:
941: --Delete the associated contact points in JTF_TASK_PHONES
942: IF p_delete_cascade = jtf_task_utl.g_yes THEN
943: do_delete_cascade (
944: p_task_contact_id => p_task_contact_id
945: ) ;
946: END IF;

Line 968: jtf_task_utl.delete_party_reference(

964:
965: -- ------------------------------------------------------------------------
966: -- Delete reference to contact, fix enh #1845501
967: -- ------------------------------------------------------------------------
968: jtf_task_utl.delete_party_reference(
969: p_reference_from => 'CONTACT',
970: p_task_id => l_task_id,
971: p_party_type_code => l_contact_type_code,
972: p_party_id => l_contact_id,