DBA Data[Home] [Help]

APPS.JTF_TASK_PHONES_PUB dependencies on JTF_TASK_UTL

Line 113: jtf_task_utl.validate_phones_table (

109: THEN
110: fnd_msg_pub.initialize;
111: END IF;
112:
113: jtf_task_utl.validate_phones_table (
114: p_owner_table_name => p_owner_table_name,
115: x_return_status => x_return_status
116: );
117:

Line 124: jtf_task_utl.validate_missing_phone_id (

120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: RAISE fnd_api.g_exc_unexpected_error;
122: END IF;
123:
124: jtf_task_utl.validate_missing_phone_id (
125: p_task_phone_id => p_phone_id,
126: x_return_status => x_return_status
127: );
128:

Line 135: jtf_task_utl.validate_missing_contact_id (

131: x_return_status := fnd_api.g_ret_sts_unexp_error;
132: RAISE fnd_api.g_exc_unexpected_error;
133: END IF;
134:
135: jtf_task_utl.validate_missing_contact_id (
136: p_task_contact_id => p_task_contact_id,
137: x_return_status => x_return_status
138: );
139:

Line 146: jtf_task_utl.validate_contact_point (

142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: RAISE fnd_api.g_exc_unexpected_error;
144: END IF;
145:
146: jtf_task_utl.validate_contact_point (
147: p_contact_id => p_task_contact_id,
148: p_phone_id => p_phone_id,
149: x_return_status => x_return_status,
150: p_owner_table_name => p_owner_table_name

Line 159: jtf_task_utl.validate_flag (

155: x_return_status := fnd_api.g_ret_sts_unexp_error;
156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;
158:
159: jtf_task_utl.validate_flag (
160: p_flag_name => jtf_task_utl.get_translated_lookup (
161: 'JTF_TASK_TRANSLATED_MESSAGES',
162: 'PRIMARY_FLAG'
163: ),

Line 160: p_flag_name => jtf_task_utl.get_translated_lookup (

156: RAISE fnd_api.g_exc_unexpected_error;
157: END IF;
158:
159: jtf_task_utl.validate_flag (
160: p_flag_name => jtf_task_utl.get_translated_lookup (
161: 'JTF_TASK_TRANSLATED_MESSAGES',
162: 'PRIMARY_FLAG'
163: ),
164: p_flag_value => p_primary_flag,

Line 179: IF p_primary_flag = jtf_task_utl.g_yes

175: INTO l_task_phone_id
176: FROM dual;
177:
178: --Unmark the previous contact points with primary flag = 'Y'.
179: IF p_primary_flag = jtf_task_utl.g_yes
180: THEN
181: do_unmark_primary_flag_create (
182: p_task_contact_id,
183: p_phone_id,

Line 192: l_primary_flag := jtf_task_utl.g_yes;

188: -------------------------------------------
189: -- For fixing a bug 2644132
190: IF is_this_first_phone(p_task_contact_id, p_owner_table_name)
191: THEN
192: l_primary_flag := jtf_task_utl.g_yes;
193: END IF;
194: -------------------------------------------
195:
196: jtf_task_phones_pkg.insert_row (

Line 218: x_created_by => jtf_task_utl.created_by,

214: x_attribute15 => p_attribute15,
215: x_attribute_category => p_attribute_category,
216: x_phone_id => p_phone_id,
217: x_creation_date => SYSDATE,
218: x_created_by => jtf_task_utl.created_by,
219: x_last_update_date => SYSDATE,
220: x_last_updated_by => jtf_task_utl.updated_by,
221: x_last_update_login => jtf_task_utl.login_id,
222: x_owner_table_name => p_owner_table_name,

Line 220: x_last_updated_by => jtf_task_utl.updated_by,

216: x_phone_id => p_phone_id,
217: x_creation_date => SYSDATE,
218: x_created_by => jtf_task_utl.created_by,
219: x_last_update_date => SYSDATE,
220: x_last_updated_by => jtf_task_utl.updated_by,
221: x_last_update_login => jtf_task_utl.login_id,
222: x_owner_table_name => p_owner_table_name,
223: x_primary_flag => l_primary_flag -- For fixing a bug 2644132
224: );

Line 221: x_last_update_login => jtf_task_utl.login_id,

217: x_creation_date => SYSDATE,
218: x_created_by => jtf_task_utl.created_by,
219: x_last_update_date => SYSDATE,
220: x_last_updated_by => jtf_task_utl.updated_by,
221: x_last_update_login => jtf_task_utl.login_id,
222: x_owner_table_name => p_owner_table_name,
223: x_primary_flag => l_primary_flag -- For fixing a bug 2644132
224: );
225: OPEN c_jtf_task_phones (l_rowid);

Line 554: jtf_task_utl.validate_contact_point (

550: END IF;
551:
552: OPEN c_task_phones;
553: FETCH c_task_phones INTO task_phones;
554: jtf_task_utl.validate_contact_point (
555: p_contact_id => l_task_contact_id,
556: p_phone_id => p_phone_id,
557: x_return_status => x_return_status,
558: p_owner_table_name => task_phones.owner_table_name

Line 598: jtf_task_utl.validate_flag (

594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;
597:
598: jtf_task_utl.validate_flag (
599: p_flag_name => jtf_task_utl.get_translated_lookup (
600: 'JTF_TASK_TRANSLATED_MESSAGES',
601: 'PRIMARY_FLAG'
602: ),

Line 599: p_flag_name => jtf_task_utl.get_translated_lookup (

595: RAISE fnd_api.g_exc_unexpected_error;
596: END IF;
597:
598: jtf_task_utl.validate_flag (
599: p_flag_name => jtf_task_utl.get_translated_lookup (
600: 'JTF_TASK_TRANSLATED_MESSAGES',
601: 'PRIMARY_FLAG'
602: ),
603: p_flag_value => task_phones.primary_flag,

Line 614: IF p_primary_flag = jtf_task_utl.g_yes

610: RAISE fnd_api.g_exc_unexpected_error;
611: END IF;
612:
613: --Unmark the previous contact points with primary flag = 'Y'.
614: IF p_primary_flag = jtf_task_utl.g_yes
615: THEN
616: do_unmark_primary_flag_update (
617: p_task_phone_id,
618: p_phone_id,

Line 645: x_last_updated_by => jtf_task_utl.updated_by,

641: x_attribute15 => task_phones.attribute15,
642: x_attribute_category => task_phones.attribute_category,
643: x_phone_id => p_phone_id,
644: x_last_update_date => SYSDATE,
645: x_last_updated_by => jtf_task_utl.updated_by,
646: x_last_update_login => jtf_task_utl.login_id,
647: x_owner_table_name => task_phones.owner_table_name,
648: x_primary_flag => task_phones.primary_flag
649: );

Line 646: x_last_update_login => jtf_task_utl.login_id,

642: x_attribute_category => task_phones.attribute_category,
643: x_phone_id => p_phone_id,
644: x_last_update_date => SYSDATE,
645: x_last_updated_by => jtf_task_utl.updated_by,
646: x_last_update_login => jtf_task_utl.login_id,
647: x_owner_table_name => task_phones.owner_table_name,
648: x_primary_flag => task_phones.primary_flag
649: );
650: -- Increase ovn when all the process is successfully completed