51:
52: BEGIN
53:
54: -- Check version number
55: IF NOT fnd_api.compatible_api_call
56: ( l_api_version
57: , p_api_version
58: , l_api_name
59: , g_pkg_name
58: , l_api_name
59: , g_pkg_name
60: )
61: THEN
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: -- Initialize message list
66: IF fnd_api.to_boolean( p_init_msg_list )
62: RAISE fnd_api.g_exc_unexpected_error;
63: END IF;
64:
65: -- Initialize message list
66: IF fnd_api.to_boolean( p_init_msg_list )
67: THEN
68: fnd_msg_pub.initialize;
69: END IF;
70:
68: fnd_msg_pub.initialize;
69: END IF;
70:
71: -- Initialize return status to SUCCESS
72: x_return_status := fnd_api.g_ret_sts_success;
73:
74: CAC_AVLBLTY_PVT.GET_SCHEDULE_DATA
75: (
76: p_Object_Type => p_Object_Type,
86: );
87:
88: EXCEPTION
89:
90: WHEN fnd_api.g_exc_error
91: THEN
92: x_return_status := fnd_api.g_ret_sts_error;
93: fnd_msg_pub.count_and_get( p_encoded => 'F'
94: , p_count => x_msg_count
88: EXCEPTION
89:
90: WHEN fnd_api.g_exc_error
91: THEN
92: x_return_status := fnd_api.g_ret_sts_error;
93: fnd_msg_pub.count_and_get( p_encoded => 'F'
94: , p_count => x_msg_count
95: , p_data => x_msg_data
96: );
94: , p_count => x_msg_count
95: , p_data => x_msg_data
96: );
97:
98: WHEN fnd_api.g_exc_unexpected_error
99: THEN
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
101: fnd_msg_pub.count_and_get( p_encoded => 'F'
102: , p_count => x_msg_count
96: );
97:
98: WHEN fnd_api.g_exc_unexpected_error
99: THEN
100: x_return_status := fnd_api.g_ret_sts_unexp_error;
101: fnd_msg_pub.count_and_get( p_encoded => 'F'
102: , p_count => x_msg_count
103: , p_data => x_msg_data
104: );
107: THEN
108: --
109: -- Set status
110: --
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112:
113: --
114: -- Push message onto CRM stack
115: --
168:
169: BEGIN
170:
171: -- Check version number
172: IF NOT fnd_api.compatible_api_call
173: ( l_api_version
174: , p_api_version
175: , l_api_name
176: , g_pkg_name
175: , l_api_name
176: , g_pkg_name
177: )
178: THEN
179: RAISE fnd_api.g_exc_unexpected_error;
180: END IF;
181:
182: -- Initialize message list
183: IF fnd_api.to_boolean( p_init_msg_list )
179: RAISE fnd_api.g_exc_unexpected_error;
180: END IF;
181:
182: -- Initialize message list
183: IF fnd_api.to_boolean( p_init_msg_list )
184: THEN
185: fnd_msg_pub.initialize;
186: END IF;
187:
185: fnd_msg_pub.initialize;
186: END IF;
187:
188: -- Initialize return status to SUCCESS
189: x_return_status := fnd_api.g_ret_sts_success;
190:
191: CAC_AVLBLTY_PVT.GET_SCHEDULE_DATA
192: (
193: p_Object_Type => p_Object_Type,
203: );
204:
205: EXCEPTION
206:
207: WHEN fnd_api.g_exc_error
208: THEN
209: x_return_status := fnd_api.g_ret_sts_error;
210: fnd_msg_pub.count_and_get( p_encoded => 'F'
211: , p_count => x_msg_count
205: EXCEPTION
206:
207: WHEN fnd_api.g_exc_error
208: THEN
209: x_return_status := fnd_api.g_ret_sts_error;
210: fnd_msg_pub.count_and_get( p_encoded => 'F'
211: , p_count => x_msg_count
212: , p_data => x_msg_data
213: );
211: , p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214:
215: WHEN fnd_api.g_exc_unexpected_error
216: THEN
217: x_return_status := fnd_api.g_ret_sts_unexp_error;
218: fnd_msg_pub.count_and_get( p_encoded => 'F'
219: , p_count => x_msg_count
213: );
214:
215: WHEN fnd_api.g_exc_unexpected_error
216: THEN
217: x_return_status := fnd_api.g_ret_sts_unexp_error;
218: fnd_msg_pub.count_and_get( p_encoded => 'F'
219: , p_count => x_msg_count
220: , p_data => x_msg_data
221: );
224: THEN
225: --
226: -- Set status
227: --
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229:
230: --
231: -- Push message onto CRM stack
232: --
327:
328: BEGIN
329:
330: -- Check version number
331: IF NOT fnd_api.compatible_api_call
332: ( l_api_version
333: , p_api_version
334: , l_api_name
335: , g_pkg_name
334: , l_api_name
335: , g_pkg_name
336: )
337: THEN
338: RAISE fnd_api.g_exc_unexpected_error;
339: END IF;
340:
341: -- Initialize message list
342: IF fnd_api.to_boolean( p_init_msg_list )
338: RAISE fnd_api.g_exc_unexpected_error;
339: END IF;
340:
341: -- Initialize message list
342: IF fnd_api.to_boolean( p_init_msg_list )
343: THEN
344: fnd_msg_pub.initialize;
345: END IF;
346:
344: fnd_msg_pub.initialize;
345: END IF;
346:
347: -- Initialize return status to SUCCESS
348: x_return_status := fnd_api.g_ret_sts_success;
349:
350: x_Available := 'T';
351:
352: FOR ref_tasks IN c_tasks(p_Object_Type,
369: END LOOP;
370:
371: EXCEPTION
372:
373: WHEN fnd_api.g_exc_unexpected_error
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_msg_pub.count_and_get( p_encoded => 'F'
377: , p_count => x_msg_count
371: EXCEPTION
372:
373: WHEN fnd_api.g_exc_unexpected_error
374: THEN
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_msg_pub.count_and_get( p_encoded => 'F'
377: , p_count => x_msg_count
378: , p_data => x_msg_data
379: );
382: THEN
383: --
384: -- Set status
385: --
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: --
389: -- Push message onto CRM stack
390: --