DBA Data[Home] [Help]

APPS.JTF_TASK_INST_TEMPLATES_PUB dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2: /* $Header: jtfpttmb.pls 115.6 2003/02/05 02:41:34 sachoudh ship $ */
3:
4: PROCEDURE create_task_from_template (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_task_template_group_info IN task_template_group_info,
9: p_task_templates_tbl IN task_template_info_tbl,
10: p_task_contact_points_tbl IN task_contact_points_tbl,

Line 7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

3:
4: PROCEDURE create_task_from_template (
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_task_template_group_info IN task_template_group_info,
9: p_task_templates_tbl IN task_template_info_tbl,
10: p_task_contact_points_tbl IN task_contact_points_tbl,
11: x_return_status OUT NOCOPY VARCHAR2,

Line 45: x_return_status := fnd_api.g_ret_sts_success;

41: WHERE d.task_id = p_task_template_id
42: AND template_flag = jtf_task_utl.g_yes;
43: BEGIN
44: SAVEPOINT create_tasks_template_pub;
45: x_return_status := fnd_api.g_ret_sts_success;
46: IF fnd_api.to_boolean (p_init_msg_list)
47: THEN
48: fnd_msg_pub.initialize;
49: END IF;

Line 46: IF fnd_api.to_boolean (p_init_msg_list)

42: AND template_flag = jtf_task_utl.g_yes;
43: BEGIN
44: SAVEPOINT create_tasks_template_pub;
45: x_return_status := fnd_api.g_ret_sts_success;
46: IF fnd_api.to_boolean (p_init_msg_list)
47: THEN
48: fnd_msg_pub.initialize;
49: END IF;
50:

Line 51: IF NOT fnd_api.compatible_api_call (

47: THEN
48: fnd_msg_pub.initialize;
49: END IF;
50:
51: IF NOT fnd_api.compatible_api_call (
52: l_api_version,
53: p_api_version,
54: l_api_name,
55: 'jtf_task_create_templates'

Line 61: RAISE fnd_api.g_exc_unexpected_error;

57: THEN
58: fnd_message.set_name ('JTF', 'JTF_TASK_INCOMPATIBLE_API');
59: fnd_message.set_token ('JTF_TASK_INCOMPATIBLE_API',l_api_name);
60: fnd_msg_pub.add;
61: RAISE fnd_api.g_exc_unexpected_error;
62: END IF;
63: -- Validate Template Group-------
64: jtf_task_templates_utl.validate_task_template_group (
65: p_task_template_group_id => p_task_template_group_info.task_template_group_id

Line 87: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

83: x_msg_data => x_msg_data,
84: x_return_status => x_return_status
85: );
86:
87: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
88: THEN
89: RAISE fnd_api.g_exc_unexpected_error;
90: END IF;
91:

Line 89: RAISE fnd_api.g_exc_unexpected_error;

85: );
86:
87: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
88: THEN
89: RAISE fnd_api.g_exc_unexpected_error;
90: END IF;
91:
92: ELSE -- p_task_templates_tbl.COUNT <> 0
93: FOR i IN 1 .. p_task_templates_tbl.COUNT

Line 107: RAISE fnd_api.g_exc_unexpected_error;

103: 'P_TASK_TEMP_ID',
104: p_task_templates_tbl (i).task_template_id
105: );
106: fnd_msg_pub.add;
107: RAISE fnd_api.g_exc_unexpected_error;
108: END IF;
109: END LOOP;
110: -- Creating tasks.
111: jtf_task_templates_utl.validate_create_template (

Line 121: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

117: x_msg_data => x_msg_data,
118: x_return_status => x_return_status
119: );
120:
121: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
122: THEN
123: RAISE fnd_api.g_exc_unexpected_error;
124: END IF;
125:

Line 123: RAISE fnd_api.g_exc_unexpected_error;

119: );
120:
121: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
122: THEN
123: RAISE fnd_api.g_exc_unexpected_error;
124: END IF;
125:
126: x_task_details_tbl (i).task_id := l_task_id;
127: x_task_details_tbl (i).task_template_id := p_task_templates_tbl (i).task_template_id;

Line 144: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

140: x_msg_count => x_msg_count,
141: x_msg_data => x_msg_data
142: );
143:
144: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
145: THEN
146: RAISE fnd_api.g_exc_unexpected_error;
147: END IF;
148:

Line 146: RAISE fnd_api.g_exc_unexpected_error;

142: );
143:
144: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
145: THEN
146: RAISE fnd_api.g_exc_unexpected_error;
147: END IF;
148:
149: -- Resource Creation from Template
150: jtf_task_templates_utl.validate_create_task_resource (

Line 159: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

155: x_msg_data => x_msg_data,
156: x_return_status => x_return_status
157: );
158:
159: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
160: THEN
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163:

Line 161: RAISE fnd_api.g_exc_unexpected_error;

157: );
158:
159: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
160: THEN
161: RAISE fnd_api.g_exc_unexpected_error;
162: END IF;
163:
164: -- Create dependencies
165: FOR task_depends IN c_task_depends (x_task_details_tbl (i).task_template_id)

Line 190: p_init_msg_list => fnd_api.g_false,

186: IF l_found
187: THEN
188: jtf_task_dependency_pvt.create_task_dependency (
189: p_api_version => 1.0,
190: p_init_msg_list => fnd_api.g_false,
191: p_commit => fnd_api.g_false,
192: p_task_id => l_task_id,
193: p_dependent_on_task_id => l_dependent_on_task_id,
194: p_dependency_type_code => task_depends.dependency_type_code,

Line 191: p_commit => fnd_api.g_false,

187: THEN
188: jtf_task_dependency_pvt.create_task_dependency (
189: p_api_version => 1.0,
190: p_init_msg_list => fnd_api.g_false,
191: p_commit => fnd_api.g_false,
192: p_task_id => l_task_id,
193: p_dependent_on_task_id => l_dependent_on_task_id,
194: p_dependency_type_code => task_depends.dependency_type_code,
195: p_template_flag => 'N',

Line 204: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

200: x_msg_data => x_msg_data,
201: x_msg_count => x_msg_count
202: );
203:
204: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
205: THEN
206: RAISE fnd_api.g_exc_unexpected_error;
207: END IF;
208: END IF;

Line 206: RAISE fnd_api.g_exc_unexpected_error;

202: );
203:
204: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
205: THEN
206: RAISE fnd_api.g_exc_unexpected_error;
207: END IF;
208: END IF;
209: END LOOP; -- end create dependencies
210:

Line 231: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

227: x_msg_data => x_msg_data,
228: x_msg_count => x_msg_count
229: );
230:
231: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
232: THEN
233: RAISE fnd_api.g_exc_unexpected_error;
234: END IF;
235: END IF;

Line 233: RAISE fnd_api.g_exc_unexpected_error;

229: );
230:
231: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
232: THEN
233: RAISE fnd_api.g_exc_unexpected_error;
234: END IF;
235: END IF;
236: END LOOP; -- end creating recurrences
237:

Line 238: IF fnd_api.to_boolean (p_commit)

234: END IF;
235: END IF;
236: END LOOP; -- end creating recurrences
237:
238: IF fnd_api.to_boolean (p_commit)
239: THEN
240: COMMIT WORK;
241: END IF;
242:

Line 246: WHEN fnd_api.g_exc_unexpected_error

242:
243: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
244:
245: EXCEPTION
246: WHEN fnd_api.g_exc_unexpected_error
247: THEN
248: ROLLBACK TO create_tasks_template_pub;
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 249: x_return_status := fnd_api.g_ret_sts_unexp_error;

245: EXCEPTION
246: WHEN fnd_api.g_exc_unexpected_error
247: THEN
248: ROLLBACK TO create_tasks_template_pub;
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
251:
252: WHEN OTHERS
253: THEN

Line 258: x_return_status := fnd_api.g_ret_sts_unexp_error;

254: ROLLBACK TO create_tasks_template_pub;
255: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
256: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
260: END;
261: END;