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.AMS_LISTACTION_PVT dependencies on FND_API

Line 133: x_return_status := FND_API.g_ret_sts_success;

129: l_action_count number;
130:
131:
132: BEGIN
133: x_return_status := FND_API.g_ret_sts_success;
134: --getting the count of actions for the list.
135: open c_actions_exist;
136: fetch c_actions_exist into l_action_count;
137: close c_actions_exist;

Line 139: IF p_action_rec.ORDER_NUMBER <> FND_API.G_MISS_NUM

135: open c_actions_exist;
136: fetch c_actions_exist into l_action_count;
137: close c_actions_exist;
138:
139: IF p_action_rec.ORDER_NUMBER <> FND_API.G_MISS_NUM
140: AND p_action_rec.ORDER_NUMBER IS NOT NULL THEN
141: IF(l_action_count >0 ) THEN
142: open c_is_ord_no_unique;
143: fetch c_is_ord_no_unique into l_ord_no_count;

Line 152: x_return_status := FND_API.G_RET_STS_ERROR;

148: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_BAD_ORD_NUM');
149: FND_MSG_PUB.Add;
150: END IF;
151:
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: -- If any errors happen abort API/Procedure.
154: RAISE FND_API.G_EXC_ERROR;
155:
156: ELSE

Line 154: RAISE FND_API.G_EXC_ERROR;

150: END IF;
151:
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: -- If any errors happen abort API/Procedure.
154: RAISE FND_API.G_EXC_ERROR;
155:
156: ELSE
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158: END IF;

Line 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

153: -- If any errors happen abort API/Procedure.
154: RAISE FND_API.G_EXC_ERROR;
155:
156: ELSE
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158: END IF;
159: ELSE
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: END IF;

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156: ELSE
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158: END IF;
159: ELSE
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: END IF;
162: END IF;
163:
164: --checking that the action with lowest order number is INCLUDE

Line 176: IF l_action_type <> FND_API.G_MISS_CHAR

172: CLOSE C_Min_List_Selection_Type;
173: else
174: l_action_type := p_action_rec.list_action_type;
175: end if;
176: IF l_action_type <> FND_API.G_MISS_CHAR
177: AND l_action_type IS NOT NULL THEN
178: IF(l_action_type <>'INCLUDE')THEN
179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
180: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
180: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
181: FND_MSG_PUB.Add;
182: END IF;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF; --end if l_action_type <>'INCLUDE'
186: END IF;-- end IF l_action_type <> FND_API.G_MISS_CHAR
187:

Line 184: RAISE FND_API.G_EXC_ERROR;

180: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_FIRST_INCLUDE');
181: FND_MSG_PUB.Add;
182: END IF;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF; --end if l_action_type <>'INCLUDE'
186: END IF;-- end IF l_action_type <> FND_API.G_MISS_CHAR
187:
188: --checking that the same action source is not included more than once in the list.

Line 186: END IF;-- end IF l_action_type <> FND_API.G_MISS_CHAR

182: END IF;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: RAISE FND_API.G_EXC_ERROR;
185: END IF; --end if l_action_type <>'INCLUDE'
186: END IF;-- end IF l_action_type <> FND_API.G_MISS_CHAR
187:
188: --checking that the same action source is not included more than once in the list.
189: IF ( p_action_rec.ARC_INCL_OBJECT_FROM <> FND_API.G_MISS_CHAR AND p_action_rec.ARC_INCL_OBJECT_FROM IS NOT NULL)
190: AND

Line 189: IF ( p_action_rec.ARC_INCL_OBJECT_FROM <> FND_API.G_MISS_CHAR AND p_action_rec.ARC_INCL_OBJECT_FROM IS NOT NULL)

185: END IF; --end if l_action_type <>'INCLUDE'
186: END IF;-- end IF l_action_type <> FND_API.G_MISS_CHAR
187:
188: --checking that the same action source is not included more than once in the list.
189: IF ( p_action_rec.ARC_INCL_OBJECT_FROM <> FND_API.G_MISS_CHAR AND p_action_rec.ARC_INCL_OBJECT_FROM IS NOT NULL)
190: AND
191: ( p_action_rec.INCL_OBJECT_ID <> FND_API.G_MISS_NUM AND p_action_rec.INCL_OBJECT_ID IS NOT NULL ) THEN
192:
193: IF(l_action_count >0 ) THEN

Line 191: ( p_action_rec.INCL_OBJECT_ID <> FND_API.G_MISS_NUM AND p_action_rec.INCL_OBJECT_ID IS NOT NULL ) THEN

187:
188: --checking that the same action source is not included more than once in the list.
189: IF ( p_action_rec.ARC_INCL_OBJECT_FROM <> FND_API.G_MISS_CHAR AND p_action_rec.ARC_INCL_OBJECT_FROM IS NOT NULL)
190: AND
191: ( p_action_rec.INCL_OBJECT_ID <> FND_API.G_MISS_NUM AND p_action_rec.INCL_OBJECT_ID IS NOT NULL ) THEN
192:
193: IF(l_action_count >0 ) THEN
194: OPEN c_is_source_unique;
195: FETCH c_is_source_unique into l_source_count;

Line 199: x_return_status := FND_API.G_RET_STS_SUCCESS;

195: FETCH c_is_source_unique into l_source_count;
196: CLOSE c_is_source_unique;
197:
198: IF(l_source_count = 0 )THEN
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200: ELSE
201: -- Error, check the msg level and added an error message to the
202: -- API message list
203: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: FND_MESSAGE.set_token('ACT_SOURCE', p_action_rec.arc_incl_object_from ||'-->'|| p_action_rec.incl_object_id );
207: FND_MSG_PUB.Add;
208: END IF;
209:
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: -- If any errors happen abort API/Procedure.
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: ELSE

Line 212: RAISE FND_API.G_EXC_ERROR;

208: END IF;
209:
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: -- If any errors happen abort API/Procedure.
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: ELSE
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: END IF;

Line 215: x_return_status := FND_API.G_RET_STS_SUCCESS;

211: -- If any errors happen abort API/Procedure.
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: ELSE
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: END IF;
217: END IF;
218:
219: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL AND p_action_rec.DISTRIBUTION_PCT <> FND_API.G_MISS_NUM ) THEN

Line 219: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL AND p_action_rec.DISTRIBUTION_PCT <> FND_API.G_MISS_NUM ) THEN

215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: END IF;
217: END IF;
218:
219: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL AND p_action_rec.DISTRIBUTION_PCT <> FND_API.G_MISS_NUM ) THEN
220: IF (p_action_rec.DISTRIBUTION_PCT > 100 )THEN
221: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_ERROR;

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL AND p_action_rec.DISTRIBUTION_PCT <> FND_API.G_MISS_NUM ) THEN
220: IF (p_action_rec.DISTRIBUTION_PCT > 100 )THEN
221: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226: IF (p_action_rec.DISTRIBUTION_PCT <= 0 )THEN
227: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');

Line 224: RAISE FND_API.G_EXC_ERROR;

220: IF (p_action_rec.DISTRIBUTION_PCT > 100 )THEN
221: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
222: FND_MSG_PUB.Add;
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226: IF (p_action_rec.DISTRIBUTION_PCT <= 0 )THEN
227: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
228: FND_MSG_PUB.Add;

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: END IF;
226: IF (p_action_rec.DISTRIBUTION_PCT <= 0 )THEN
227: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
228: FND_MSG_PUB.Add;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232: END IF;
233:

Line 230: RAISE FND_API.G_EXC_ERROR;

226: IF (p_action_rec.DISTRIBUTION_PCT <= 0 )THEN
227: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
228: FND_MSG_PUB.Add;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232: END IF;
233:
234: IF(p_action_rec.list_action_type <> 'INCLUDE' ) THEN

Line 235: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL AND p_action_rec.DISTRIBUTION_PCT <> FND_API.G_MISS_NUM ) THEN

231: END IF;
232: END IF;
233:
234: IF(p_action_rec.list_action_type <> 'INCLUDE' ) THEN
235: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL AND p_action_rec.DISTRIBUTION_PCT <> FND_API.G_MISS_NUM ) THEN
236: FND_MESSAGE.set_name('AMS', 'AMS_DIST_PCT_NULL');
237: FND_MSG_PUB.Add;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: RAISE FND_API.G_EXC_ERROR;

Line 238: x_return_status := FND_API.G_RET_STS_ERROR;

234: IF(p_action_rec.list_action_type <> 'INCLUDE' ) THEN
235: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL AND p_action_rec.DISTRIBUTION_PCT <> FND_API.G_MISS_NUM ) THEN
236: FND_MESSAGE.set_name('AMS', 'AMS_DIST_PCT_NULL');
237: FND_MSG_PUB.Add;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: END IF;
242:

Line 239: RAISE FND_API.G_EXC_ERROR;

235: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL AND p_action_rec.DISTRIBUTION_PCT <> FND_API.G_MISS_NUM ) THEN
236: FND_MESSAGE.set_name('AMS', 'AMS_DIST_PCT_NULL');
237: FND_MSG_PUB.Add;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: END IF;
242:
243:

Line 269: x_return_status := FND_API.g_ret_sts_success;

265: IS
266:
267: BEGIN
268:
269: x_return_status := FND_API.g_ret_sts_success;
270:
271: -- For create_action, when action_id is passed in, we need to
272: -- check if this action_id is unique.
273: IF p_validation_mode = JTF_PLSQL_API.g_create

Line 279: ) = FND_API.g_false

275: THEN
276: IF AMS_Utility_PVT.check_uniqueness(
277: 'ams_list_select_actions',
278: 'list_select_action_id = ' || p_action_rec.list_select_action_id
279: ) = FND_API.g_false
280: THEN
281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
282: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DUPE_ACTION');
283: FND_MSG_PUB.add;

Line 285: x_return_status := FND_API.g_ret_sts_error;

281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
282: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DUPE_ACTION');
283: FND_MSG_PUB.add;
284: END IF;
285: x_return_status := FND_API.g_ret_sts_error;
286: RETURN;
287: END IF;
288: END IF;
289:

Line 298: ) = FND_API.g_false

294: 'ams_list_select_actions',
295: 'order_number = ' || p_action_rec.order_number||
296: ' and action_used_by_id = '||p_action_rec.action_used_by_id
297: ||' and arc_action_used_by = '||p_action_rec.arc_action_used_by
298: ) = FND_API.g_false
299: THEN
300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
301: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_BAD_ORD_NUM');
302: FND_MSG_PUB.add;

Line 304: x_return_status := FND_API.g_ret_sts_error;

300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
301: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_BAD_ORD_NUM');
302: FND_MSG_PUB.add;
303: END IF;
304: x_return_status := FND_API.g_ret_sts_error;
305: RETURN;
306: END IF;
307: END IF;
308:

Line 319: ) = FND_API.g_false

315: ' and action_used_by_id = '||
316: p_action_rec.action_used_by_id
317: ||' and arc_action_used_by = '||
318: p_action_rec.arc_action_used_by
319: ) = FND_API.g_false
320: THEN
321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
322: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_RANK_NUM');
323: FND_MSG_PUB.add;

Line 325: x_return_status := FND_API.g_ret_sts_error;

321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
322: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_RANK_NUM');
323: FND_MSG_PUB.add;
324: END IF;
325: x_return_status := FND_API.g_ret_sts_error;
326: RETURN;
327: END IF;
328: END IF;
329:

Line 351: x_return_status := FND_API.g_ret_sts_success;

347: l_pk_name varchar2(100);
348:
349: BEGIN
350:
351: x_return_status := FND_API.g_ret_sts_success;
352:
353: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN
354:
355: AMS_Utility_PVT.get_qual_table_name_and_pk(

Line 353: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN

349: BEGIN
350:
351: x_return_status := FND_API.g_ret_sts_success;
352:
353: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN
354:
355: AMS_Utility_PVT.get_qual_table_name_and_pk(
356: p_sys_qual => p_action_rec.arc_action_used_by,
357: x_return_status => x_return_status,

Line 362: IF x_return_status <> FND_API.g_ret_sts_success THEN

358: x_table_name => l_table_name,
359: x_pk_name => l_pk_name
360: );
361:
362: IF x_return_status <> FND_API.g_ret_sts_success THEN
363: RETURN;
364: END IF;
365:
366: IF p_action_rec.action_used_by_id <> FND_API.g_miss_num THEN

Line 366: IF p_action_rec.action_used_by_id <> FND_API.g_miss_num THEN

362: IF x_return_status <> FND_API.g_ret_sts_success THEN
363: RETURN;
364: END IF;
365:
366: IF p_action_rec.action_used_by_id <> FND_API.g_miss_num THEN
367: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
368: , l_pk_name
369: , p_action_rec.action_used_by_id)
370: = FND_API.G_TRUE)

Line 370: = FND_API.G_TRUE)

366: IF p_action_rec.action_used_by_id <> FND_API.g_miss_num THEN
367: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
368: , l_pk_name
369: , p_action_rec.action_used_by_id)
370: = FND_API.G_TRUE)
371: THEN
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:
374: ELSE

Line 372: x_return_status := FND_API.G_RET_STS_SUCCESS;

368: , l_pk_name
369: , p_action_rec.action_used_by_id)
370: = FND_API.G_TRUE)
371: THEN
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:
374: ELSE
375: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
376: THEN

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: THEN
377: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ID_MISSING');
378: FND_MSG_PUB.Add;
379: END IF;
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
383: END IF; -- end p_action_rec.action_used_by_id
384: END IF; --end p_action_rec.arc_action_used_by <> FND_API.g_miss_char

Line 381: RAISE FND_API.G_EXC_ERROR;

377: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ID_MISSING');
378: FND_MSG_PUB.Add;
379: END IF;
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
383: END IF; -- end p_action_rec.action_used_by_id
384: END IF; --end p_action_rec.arc_action_used_by <> FND_API.g_miss_char
385:

Line 384: END IF; --end p_action_rec.arc_action_used_by <> FND_API.g_miss_char

380: x_return_status := FND_API.G_RET_STS_ERROR;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
383: END IF; -- end p_action_rec.action_used_by_id
384: END IF; --end p_action_rec.arc_action_used_by <> FND_API.g_miss_char
385:
386: IF p_action_rec.arc_incl_object_from <> FND_API.g_miss_char THEN
387:
388: if p_action_rec.arc_incl_object_from = 'STANDARD' then

Line 386: IF p_action_rec.arc_incl_object_from <> FND_API.g_miss_char THEN

382: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
383: END IF; -- end p_action_rec.action_used_by_id
384: END IF; --end p_action_rec.arc_action_used_by <> FND_API.g_miss_char
385:
386: IF p_action_rec.arc_incl_object_from <> FND_API.g_miss_char THEN
387:
388: if p_action_rec.arc_incl_object_from = 'STANDARD' then
389: l_arc_incl_object_from := 'LIST';
390: elsif p_action_rec.arc_incl_object_from = 'MANUAL' then

Line 402: IF x_return_status <> FND_API.g_ret_sts_success THEN

398: x_table_name => l_table_name,
399: x_pk_name => l_pk_name
400: );
401:
402: IF x_return_status <> FND_API.g_ret_sts_success THEN
403: RETURN;
404: END IF;
405:
406: IF p_action_rec.incl_object_id <> FND_API.g_miss_num THEN

Line 406: IF p_action_rec.incl_object_id <> FND_API.g_miss_num THEN

402: IF x_return_status <> FND_API.g_ret_sts_success THEN
403: RETURN;
404: END IF;
405:
406: IF p_action_rec.incl_object_id <> FND_API.g_miss_num THEN
407: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
408: , l_pk_name
409: , p_action_rec.incl_object_id)
410: = FND_API.G_TRUE)

Line 410: = FND_API.G_TRUE)

406: IF p_action_rec.incl_object_id <> FND_API.g_miss_num THEN
407: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
408: , l_pk_name
409: , p_action_rec.incl_object_id)
410: = FND_API.G_TRUE)
411: THEN
412: x_return_status := FND_API.G_RET_STS_SUCCESS;
413:
414: ELSE

Line 412: x_return_status := FND_API.G_RET_STS_SUCCESS;

408: , l_pk_name
409: , p_action_rec.incl_object_id)
410: = FND_API.G_TRUE)
411: THEN
412: x_return_status := FND_API.G_RET_STS_SUCCESS;
413:
414: ELSE
415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
416: THEN

Line 421: x_return_status := FND_API.G_RET_STS_ERROR;

417: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_SRC_INVALID');
418: FND_MESSAGE.set_token('LIST_SOURCE', p_action_rec.arc_incl_object_from ||'-->'|| p_action_rec.incl_object_id );
419: FND_MSG_PUB.Add;
420: END IF;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
424: END IF; -- p_action_rec.incl_object_id <> FND_API.g_miss_num
425: END IF; --end p_action_rec.arc_incl_object_from <> FND_API.g_miss_char

Line 422: RAISE FND_API.G_EXC_ERROR;

418: FND_MESSAGE.set_token('LIST_SOURCE', p_action_rec.arc_incl_object_from ||'-->'|| p_action_rec.incl_object_id );
419: FND_MSG_PUB.Add;
420: END IF;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
424: END IF; -- p_action_rec.incl_object_id <> FND_API.g_miss_num
425: END IF; --end p_action_rec.arc_incl_object_from <> FND_API.g_miss_char
426: -- check other fk items

Line 424: END IF; -- p_action_rec.incl_object_id <> FND_API.g_miss_num

420: END IF;
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
424: END IF; -- p_action_rec.incl_object_id <> FND_API.g_miss_num
425: END IF; --end p_action_rec.arc_incl_object_from <> FND_API.g_miss_char
426: -- check other fk items
427: END check_action_fk_items;
428:

Line 425: END IF; --end p_action_rec.arc_incl_object_from <> FND_API.g_miss_char

421: x_return_status := FND_API.G_RET_STS_ERROR;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
424: END IF; -- p_action_rec.incl_object_id <> FND_API.g_miss_num
425: END IF; --end p_action_rec.arc_incl_object_from <> FND_API.g_miss_char
426: -- check other fk items
427: END check_action_fk_items;
428:
429: PROCEDURE check_action_other_items(

Line 440: x_return_status := FND_API.g_ret_sts_success;

436: l_pk_name varchar2(100);
437:
438: BEGIN
439:
440: x_return_status := FND_API.g_ret_sts_success;
441:
442: IF p_action_rec.order_number <> FND_API.g_miss_num THEN
443: if p_action_rec.order_number < 1 then
444: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');

Line 442: IF p_action_rec.order_number <> FND_API.g_miss_num THEN

438: BEGIN
439:
440: x_return_status := FND_API.g_ret_sts_success;
441:
442: IF p_action_rec.order_number <> FND_API.g_miss_num THEN
443: if p_action_rec.order_number < 1 then
444: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');
445: FND_MESSAGE.set_token('FIELD', 'ORDER_NUMBER');
446: FND_MSG_PUB.add;

Line 447: x_return_status := FND_API.g_ret_sts_error;

443: if p_action_rec.order_number < 1 then
444: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');
445: FND_MESSAGE.set_token('FIELD', 'ORDER_NUMBER');
446: FND_MSG_PUB.add;
447: x_return_status := FND_API.g_ret_sts_error;
448: return ;
449: end if;
450: if trunc(p_action_rec.order_number) <> p_action_rec.order_number then
451: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');

Line 454: x_return_status := FND_API.g_ret_sts_error;

450: if trunc(p_action_rec.order_number) <> p_action_rec.order_number then
451: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');
452: FND_MESSAGE.set_token('FIELD', 'ORDER_NUMBER');
453: FND_MSG_PUB.add;
454: x_return_status := FND_API.g_ret_sts_error;
455: return ;
456: end if;
457:
458: END IF;

Line 461: IF p_action_rec.rank <> FND_API.g_miss_num AND p_action_rec.arc_action_used_by NOT IN ('MODL', 'SCOR') THEN

457:
458: END IF;
459:
460:
461: IF p_action_rec.rank <> FND_API.g_miss_num AND p_action_rec.arc_action_used_by NOT IN ('MODL', 'SCOR') THEN
462: if p_action_rec.rank < 1 then
463: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');
464: FND_MESSAGE.set_token('FIELD', 'RANK');
465: FND_MSG_PUB.add;

Line 466: x_return_status := FND_API.g_ret_sts_error;

462: if p_action_rec.rank < 1 then
463: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');
464: FND_MESSAGE.set_token('FIELD', 'RANK');
465: FND_MSG_PUB.add;
466: x_return_status := FND_API.g_ret_sts_error;
467: return ;
468: end if;
469: if trunc(p_action_rec.rank) <> p_action_rec.rank then
470: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');

Line 473: x_return_status := FND_API.g_ret_sts_error;

469: if trunc(p_action_rec.rank) <> p_action_rec.rank then
470: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ORDER_NUMBER_RANK');
471: FND_MESSAGE.set_token('FIELD', 'RANK');
472: FND_MSG_PUB.add;
473: x_return_status := FND_API.g_ret_sts_error;
474: return ;
475: end if;
476:
477: END IF;

Line 480: IF (p_action_rec.rank = FND_API.g_miss_num ) THEN

476:
477: END IF;
478:
479: IF (p_action_rec.list_action_type = 'INCLUDE' AND p_action_rec.arc_action_used_by NOT IN ('MODL', 'SCOR')) THEN
480: IF (p_action_rec.rank = FND_API.g_miss_num ) THEN
481: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_RANK_MISSING');
482: FND_MSG_PUB.add;
483: x_return_status := FND_API.g_ret_sts_error;
484: return ;

Line 483: x_return_status := FND_API.g_ret_sts_error;

479: IF (p_action_rec.list_action_type = 'INCLUDE' AND p_action_rec.arc_action_used_by NOT IN ('MODL', 'SCOR')) THEN
480: IF (p_action_rec.rank = FND_API.g_miss_num ) THEN
481: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_RANK_MISSING');
482: FND_MSG_PUB.add;
483: x_return_status := FND_API.g_ret_sts_error;
484: return ;
485: end if;
486: IF (p_action_rec.rank is null ) THEN
487: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_RANK_MISSING');

Line 489: x_return_status := FND_API.g_ret_sts_error;

485: end if;
486: IF (p_action_rec.rank is null ) THEN
487: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_RANK_MISSING');
488: FND_MSG_PUB.add;
489: x_return_status := FND_API.g_ret_sts_error;
490: return ;
491: end if;
492:
493:

Line 496: IF p_action_rec.incl_control_group <> FND_API.g_miss_char

492:
493:
494: END IF;
495:
496: IF p_action_rec.incl_control_group <> FND_API.g_miss_char
497: AND p_action_rec.incl_control_group IS NOT NULL THEN
498: IF AMS_Utility_PVT.is_Y_or_N(p_action_rec.incl_control_group) = FND_API.g_false THEN
499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
500: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_FLAG');

Line 498: IF AMS_Utility_PVT.is_Y_or_N(p_action_rec.incl_control_group) = FND_API.g_false THEN

494: END IF;
495:
496: IF p_action_rec.incl_control_group <> FND_API.g_miss_char
497: AND p_action_rec.incl_control_group IS NOT NULL THEN
498: IF AMS_Utility_PVT.is_Y_or_N(p_action_rec.incl_control_group) = FND_API.g_false THEN
499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
500: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_FLAG');
501: FND_MSG_PUB.add;
502: END IF;

Line 503: x_return_status := FND_API.g_ret_sts_error;

499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
500: FND_MESSAGE.set_name('AMS', 'AMS_LIST_BAD_FLAG');
501: FND_MSG_PUB.add;
502: END IF;
503: x_return_status := FND_API.g_ret_sts_error;
504: RETURN;
505: END IF;
506: END IF;
507: -- check other other items

Line 525: x_return_status := FND_API.g_ret_sts_success;

521: )
522: IS
523: BEGIN
524:
525: x_return_status := FND_API.g_ret_sts_success;
526:
527: ----------------------- arc_action_used_by ------------------------
528: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN
529: IF AMS_Utility_PVT.check_lookup_exists(

Line 528: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN

524:
525: x_return_status := FND_API.g_ret_sts_success;
526:
527: ----------------------- arc_action_used_by ------------------------
528: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN
529: IF AMS_Utility_PVT.check_lookup_exists(
530: p_lookup_type => 'AMS_SELECT_ACTION_USED_BY',
531: p_lookup_code => p_action_rec.arc_action_used_by
532: ) = FND_API.g_false

Line 532: ) = FND_API.g_false

528: IF p_action_rec.arc_action_used_by <> FND_API.g_miss_char THEN
529: IF AMS_Utility_PVT.check_lookup_exists(
530: p_lookup_type => 'AMS_SELECT_ACTION_USED_BY',
531: p_lookup_code => p_action_rec.arc_action_used_by
532: ) = FND_API.g_false
533: THEN
534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
535: THEN
536: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACTION_USEDBY_INVALID');

Line 541: x_return_status := FND_API.g_ret_sts_error;

537: FND_MESSAGE.set_token('ACTION_USED_BY', p_action_rec.arc_action_used_by);
538: FND_MSG_PUB.add;
539: END IF;
540:
541: x_return_status := FND_API.g_ret_sts_error;
542: RETURN;
543: END IF;
544: END IF;
545:

Line 547: IF p_action_rec.list_action_type <> FND_API.g_miss_char THEN

543: END IF;
544: END IF;
545:
546: ----------------------- list_action_type ------------------------
547: IF p_action_rec.list_action_type <> FND_API.g_miss_char THEN
548: IF AMS_Utility_PVT.check_lookup_exists(
549: p_lookup_type => 'AMS_LIST_SELECT_ACTION',
550: p_lookup_code => p_action_rec.list_action_type
551: ) = FND_API.g_false

Line 551: ) = FND_API.g_false

547: IF p_action_rec.list_action_type <> FND_API.g_miss_char THEN
548: IF AMS_Utility_PVT.check_lookup_exists(
549: p_lookup_type => 'AMS_LIST_SELECT_ACTION',
550: p_lookup_code => p_action_rec.list_action_type
551: ) = FND_API.g_false
552: THEN
553: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
554: THEN
555: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_BAD_TYPE');

Line 559: x_return_status := FND_API.g_ret_sts_error;

555: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_BAD_TYPE');
556: FND_MSG_PUB.add;
557: END IF;
558:
559: x_return_status := FND_API.g_ret_sts_error;
560: RETURN;
561: END IF;
562: END IF;
563:

Line 565: IF p_action_rec.arc_incl_object_from <> FND_API.g_miss_char THEN

561: END IF;
562: END IF;
563:
564: ----------------------- arc_incl_object_type ------------------------
565: IF p_action_rec.arc_incl_object_from <> FND_API.g_miss_char THEN
566: IF p_action_rec.arc_action_used_by NOT IN ('MODL', 'SCOR') THEN
567: IF AMS_Utility_PVT.check_lookup_exists(
568: p_lookup_type => 'AMS_LIST_SELECT_TYPE',
569: p_lookup_code => p_action_rec.arc_incl_object_from

Line 570: ) = FND_API.g_false

566: IF p_action_rec.arc_action_used_by NOT IN ('MODL', 'SCOR') THEN
567: IF AMS_Utility_PVT.check_lookup_exists(
568: p_lookup_type => 'AMS_LIST_SELECT_TYPE',
569: p_lookup_code => p_action_rec.arc_incl_object_from
570: ) = FND_API.g_false
571: THEN
572: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
573: THEN
574: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_SRC_INVALID');

Line 579: x_return_status := FND_API.g_ret_sts_error;

575: FND_MESSAGE.set_token('LIST_SOURCE', p_action_rec.arc_incl_object_from);
576: FND_MSG_PUB.add;
577: END IF;
578:
579: x_return_status := FND_API.g_ret_sts_error;
580: RETURN;
581: END IF;
582: ELSE -- use different lookup for model and score
583: -- CSCH included in the lookup breaks the rendering

Line 589: ) = FND_API.g_false

585: IF p_action_rec.arc_incl_object_from <> 'CSCH' THEN
586: IF AMS_Utility_PVT.check_lookup_exists(
587: p_lookup_type => 'AMS_DM_SOURCE_TYPE',
588: p_lookup_code => p_action_rec.arc_incl_object_from
589: ) = FND_API.g_false
590: THEN
591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
592: THEN
593: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_SRC_INVALID');

Line 598: x_return_status := FND_API.g_ret_sts_error;

594: FND_MESSAGE.set_token('LIST_SOURCE', p_action_rec.arc_incl_object_from);
595: FND_MSG_PUB.add;
596: END IF;
597:
598: x_return_status := FND_API.g_ret_sts_error;
599: END IF;
600: END IF;
601: END IF;
602: END IF;

Line 636: x_return_status := FND_API.G_RET_STS_SUCCESS;

632: ) IS
633:
634: BEGIN
635: --Initialize API/Procedure return status to success
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:
638: IF (p_action_rec.arc_action_used_by IS NULL) THEN
639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
640: FND_MESSAGE.Set_Name('AMS', 'AMS_ACTION_USEDBY_MISSING');

Line 643: x_return_status := FND_API.G_RET_STS_ERROR;

639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
640: FND_MESSAGE.Set_Name('AMS', 'AMS_ACTION_USEDBY_MISSING');
641: FND_MSG_PUB.Add;
642: END IF;
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: return;
645: END IF;
646:
647: IF (p_action_rec.action_used_by_id IS NULL) THEN

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
649: FND_MESSAGE.Set_Name('AMS', 'AMS_USEDBY_ID_MISSING');
650: FND_MSG_PUB.Add;
651: END IF;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: return;
654: END IF;
655:
656: IF (p_action_rec.order_number IS NULL) THEN

Line 661: x_return_status := FND_API.G_RET_STS_ERROR;

657: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
658: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_ACT_ORDNO_MISSING');
659: FND_MSG_PUB.Add;
660: END IF;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: return;
663: END IF;
664:
665: IF (p_action_rec.list_action_type IS NULL) THEN

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

666: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
667: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_ACT_TYPE_MISSING');
668: FND_MSG_PUB.Add;
669: END IF;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: return;
672: END IF;
673:
674: -- IF(p_action_rec.incl_object_name IS NULL) THEN

Line 679: -- x_return_status := FND_API.G_RET_STS_ERROR;

675: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
676: -- FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_ACT_SRC_NAME_MISSING');
677: -- FND_MSG_PUB.Add;
678: -- END IF;
679: -- x_return_status := FND_API.G_RET_STS_ERROR;
680: -- return;
681: -- END IF;
682:
683: IF (p_action_rec.arc_incl_object_from IS NULL) THEN

Line 688: x_return_status := FND_API.G_RET_STS_ERROR;

684: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
685: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_ARC_INCLUDE_FROM');
686: FND_MSG_PUB.Add;
687: END IF;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: return;
690: END IF;
691:
692: IF (p_action_rec.incl_object_id IS NULL) THEN

Line 697: x_return_status := FND_API.G_RET_STS_ERROR;

693: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
694: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_ARC_INCLUDE_FROM_ID');
695: FND_MSG_PUB.Add;
696: END IF;
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: return;
699: END IF;
700:
701:

Line 730: IF x_return_status <> FND_API.g_ret_sts_success THEN

726: p_action_rec => p_action_rec,
727: x_return_status => x_return_status
728: );
729:
730: IF x_return_status <> FND_API.g_ret_sts_success THEN
731: RETURN;
732: END IF;
733:
734:

Line 739: IF x_return_status <> FND_API.g_ret_sts_success THEN

735: check_action_lookup_items(
736: p_action_rec => p_action_rec,
737: x_return_status => x_return_status
738: );
739: IF x_return_status <> FND_API.g_ret_sts_success THEN
740: RETURN;
741: END IF;
742:
743: check_action_fk_items(

Line 748: IF x_return_status <> FND_API.g_ret_sts_success THEN

744: p_action_rec => p_action_rec,
745: x_return_status => x_return_status
746: );
747:
748: IF x_return_status <> FND_API.g_ret_sts_success THEN
749: RETURN;
750: END IF;
751:
752: check_action_other_items(

Line 757: IF x_return_status <> FND_API.g_ret_sts_success THEN

753: p_action_rec => p_action_rec,
754: x_return_status => x_return_status
755: );
756:
757: IF x_return_status <> FND_API.g_ret_sts_success THEN
758: RETURN;
759: END IF;
760:
761: check_action_uk_items(

Line 767: IF x_return_status <> FND_API.g_ret_sts_success THEN

763: p_validation_mode => p_validation_mode,
764: x_return_status => x_return_status
765: );
766:
767: IF x_return_status <> FND_API.g_ret_sts_success THEN
768: RETURN;
769: END IF;
770:
771:

Line 789: -- should not be any FND_API.g_miss_char/num/date in it.

785: -- p_action_rec: the list action record to be validated
786: --
787: -- NOTES
788: -- 1. p_action_rec should be the complete list action record. There
789: -- should not be any FND_API.g_miss_char/num/date in it.
790: ----------------------------------------------------------------------
791: -- End Of Comments
792: PROCEDURE Validate_ListAction
793: ( p_api_version IN NUMBER,

Line 794: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

790: ----------------------------------------------------------------------
791: -- End Of Comments
792: PROCEDURE Validate_ListAction
793: ( p_api_version IN NUMBER,
794: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
795: p_validation_level IN NUMBER
796: := FND_API.G_VALID_LEVEL_FULL,
797: x_return_status OUT NOCOPY VARCHAR2,
798: x_msg_count OUT NOCOPY NUMBER,

Line 796: := FND_API.G_VALID_LEVEL_FULL,

792: PROCEDURE Validate_ListAction
793: ( p_api_version IN NUMBER,
794: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
795: p_validation_level IN NUMBER
796: := FND_API.G_VALID_LEVEL_FULL,
797: x_return_status OUT NOCOPY VARCHAR2,
798: x_msg_count OUT NOCOPY NUMBER,
799: x_msg_data OUT NOCOPY VARCHAR2,
800:

Line 815: IF NOT FND_API.Compatible_API_Call ( l_api_version,

811:
812:
813: BEGIN
814: -- Standard call to check for call compatibility.
815: IF NOT FND_API.Compatible_API_Call ( l_api_version,
816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)
819: THEN

Line 820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)
819: THEN
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822:
823: -- Initialize message list if p_init_msg_list is set to TRUE.
824: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 824: IF FND_API.to_Boolean( p_init_msg_list ) THEN

820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822:
823: -- Initialize message list if p_init_msg_list is set to TRUE.
824: IF FND_API.to_Boolean( p_init_msg_list ) THEN
825: FND_MSG_PUB.initialize;
826: END IF;
827:
828: -- Debug Message

Line 843: x_return_status := FND_API.G_RET_STS_SUCCESS;

839:
840:
841:
842: -- Initialize API return status to success
843: x_return_status := FND_API.G_RET_STS_SUCCESS;
844:
845: ---------------------- validate ------------------------
846: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
847: check_action_items(

Line 853: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

849: p_validation_mode => JTF_PLSQL_API.g_create,
850: x_return_status => l_return_status
851: );
852:
853: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
854: RAISE FND_API.g_exc_unexpected_error;
855: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
856: RAISE FND_API.g_exc_error;
857: END IF;

Line 854: RAISE FND_API.g_exc_unexpected_error;

850: x_return_status => l_return_status
851: );
852:
853: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
854: RAISE FND_API.g_exc_unexpected_error;
855: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
856: RAISE FND_API.g_exc_error;
857: END IF;
858: END IF;

Line 855: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

851: );
852:
853: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
854: RAISE FND_API.g_exc_unexpected_error;
855: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
856: RAISE FND_API.g_exc_error;
857: END IF;
858: END IF;
859:

Line 856: RAISE FND_API.g_exc_error;

852:
853: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
854: RAISE FND_API.g_exc_unexpected_error;
855: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
856: RAISE FND_API.g_exc_error;
857: END IF;
858: END IF;
859:
860:

Line 868: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

864: p_complete_rec => NULL,
865: x_return_status => l_return_status
866: );
867:
868: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
869: RAISE FND_API.g_exc_unexpected_error;
870: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
871: RAISE FND_API.g_exc_error;
872: END IF;

Line 869: RAISE FND_API.g_exc_unexpected_error;

865: x_return_status => l_return_status
866: );
867:
868: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
869: RAISE FND_API.g_exc_unexpected_error;
870: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
871: RAISE FND_API.g_exc_error;
872: END IF;
873: END IF;

Line 870: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

866: );
867:
868: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
869: RAISE FND_API.g_exc_unexpected_error;
870: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
871: RAISE FND_API.g_exc_error;
872: END IF;
873: END IF;
874:

Line 871: RAISE FND_API.g_exc_error;

867:
868: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
869: RAISE FND_API.g_exc_unexpected_error;
870: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
871: RAISE FND_API.g_exc_error;
872: END IF;
873: END IF;
874:
875: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL) THEN

Line 879: x_return_status := FND_API.G_RET_STS_ERROR;

875: IF(p_action_rec.DISTRIBUTION_PCT IS NOT NULL) THEN
876: IF (p_action_rec.DISTRIBUTION_PCT > 100 )THEN
877: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
878: FND_MSG_PUB.Add;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: RAISE FND_API.G_EXC_ERROR;
881: END IF;
882: IF (p_action_rec.DISTRIBUTION_PCT <= 0 )THEN
883: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');

Line 880: RAISE FND_API.G_EXC_ERROR;

876: IF (p_action_rec.DISTRIBUTION_PCT > 100 )THEN
877: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
878: FND_MSG_PUB.Add;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: RAISE FND_API.G_EXC_ERROR;
881: END IF;
882: IF (p_action_rec.DISTRIBUTION_PCT <= 0 )THEN
883: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
884: FND_MSG_PUB.Add;

Line 885: x_return_status := FND_API.G_RET_STS_ERROR;

881: END IF;
882: IF (p_action_rec.DISTRIBUTION_PCT <= 0 )THEN
883: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
884: FND_MSG_PUB.Add;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888: END IF;
889:

Line 886: RAISE FND_API.G_EXC_ERROR;

882: IF (p_action_rec.DISTRIBUTION_PCT <= 0 )THEN
883: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACT_DIST_PCT_INVALID');
884: FND_MSG_PUB.Add;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888: END IF;
889:
890:

Line 921: p_encoded => FND_API.G_FALSE

917: -- Standard call to get message count AND IF count is 1, get message info.
918: FND_MSG_PUB.Count_AND_Get
919: ( p_count => x_msg_count,
920: p_data => x_msg_data,
921: p_encoded => FND_API.G_FALSE
922: );
923:
924:
925:

Line 927: WHEN FND_API.G_EXC_ERROR THEN

923:
924:
925:
926: EXCEPTION
927: WHEN FND_API.G_EXC_ERROR THEN
928: x_return_status := FND_API.G_RET_STS_ERROR ;
929:
930: FND_MSG_PUB.Count_AND_Get
931: ( p_count => x_msg_count,

Line 928: x_return_status := FND_API.G_RET_STS_ERROR ;

924:
925:
926: EXCEPTION
927: WHEN FND_API.G_EXC_ERROR THEN
928: x_return_status := FND_API.G_RET_STS_ERROR ;
929:
930: FND_MSG_PUB.Count_AND_Get
931: ( p_count => x_msg_count,
932: p_data => x_msg_data,

Line 933: p_encoded => FND_API.G_FALSE

929:
930: FND_MSG_PUB.Count_AND_Get
931: ( p_count => x_msg_count,
932: p_data => x_msg_data,
933: p_encoded => FND_API.G_FALSE
934: );
935:
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

933: p_encoded => FND_API.G_FALSE
934: );
935:
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
939: FND_MSG_PUB.Count_AND_Get
940: ( p_count => x_msg_count,
941: p_data => x_msg_data,

Line 938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

934: );
935:
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
939: FND_MSG_PUB.Count_AND_Get
940: ( p_count => x_msg_count,
941: p_data => x_msg_data,
942: p_encoded => FND_API.G_FALSE

Line 942: p_encoded => FND_API.G_FALSE

938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
939: FND_MSG_PUB.Count_AND_Get
940: ( p_count => x_msg_count,
941: p_data => x_msg_data,
942: p_encoded => FND_API.G_FALSE
943: );
944:
945: WHEN OTHERS THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

942: p_encoded => FND_API.G_FALSE
943: );
944:
945: WHEN OTHERS THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
947: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
948: THEN
949: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
950: END IF;

Line 955: p_encoded => FND_API.G_FALSE

951:
952: FND_MSG_PUB.Count_AND_Get
953: ( p_count => x_msg_count,
954: p_data => x_msg_data,
955: p_encoded => FND_API.G_FALSE
956: );
957:
958: END Validate_ListAction;
959:

Line 980: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

976: -- the sequence.
977: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
978: -- Raise exception for invalid flag.
979: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
980: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
981: ---------------------------------------------------------------------
982: PROCEDURE Create_ListAction
983: ( p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

980: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
981: ---------------------------------------------------------------------
982: PROCEDURE Create_ListAction
983: ( p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
985: p_commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER
987: := FND_API.G_VALID_LEVEL_FULL,
988: x_return_status OUT NOCOPY VARCHAR2,

Line 985: p_commit IN VARCHAR2 := FND_API.G_FALSE,

981: ---------------------------------------------------------------------
982: PROCEDURE Create_ListAction
983: ( p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
985: p_commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER
987: := FND_API.G_VALID_LEVEL_FULL,
988: x_return_status OUT NOCOPY VARCHAR2,
989: x_msg_count OUT NOCOPY NUMBER,

Line 987: := FND_API.G_VALID_LEVEL_FULL,

983: ( p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
985: p_commit IN VARCHAR2 := FND_API.G_FALSE,
986: p_validation_level IN NUMBER
987: := FND_API.G_VALID_LEVEL_FULL,
988: x_return_status OUT NOCOPY VARCHAR2,
989: x_msg_count OUT NOCOPY NUMBER,
990: x_msg_data OUT NOCOPY VARCHAR2,
991:

Line 1024: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1020: -- Standard Start of API savepoint
1021: SAVEPOINT Create_ListAction_PVT;
1022:
1023: -- Standard call to check for call compatibility.
1024: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1025: p_api_version,
1026: l_api_name,
1027: G_PKG_NAME)
1028: THEN

Line 1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1025: p_api_version,
1026: l_api_name,
1027: G_PKG_NAME)
1028: THEN
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;
1031:
1032: -- Initialize message list IF p_init_msg_list is set to TRUE.
1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;
1031:
1032: -- Initialize message list IF p_init_msg_list is set to TRUE.
1033: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1034: FND_MSG_PUB.initialize;
1035: END IF;
1036:
1037: -- Debug Message

Line 1051: x_return_status := FND_API.G_RET_STS_SUCCESS;

1047: END IF;
1048:
1049:
1050: -- Initialize API return status to success
1051: x_return_status := FND_API.G_RET_STS_SUCCESS;
1052:
1053: --
1054: -- API body
1055: --

Line 1060: l_action_rec.list_select_action_id = FND_API.g_miss_num THEN

1056:
1057: -- Perform the database operation
1058:
1059: IF l_action_rec.list_select_action_id IS NULL OR
1060: l_action_rec.list_select_action_id = FND_API.g_miss_num THEN
1061: LOOP
1062: OPEN c_action_seq;
1063: FETCH c_action_seq INTO l_action_rec.list_select_action_id;
1064: CLOSE c_action_seq;

Line 1086: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1082: );
1083:
1084:
1085: -- If any errors happen abort API.
1086: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;

Line 1087: RAISE FND_API.G_EXC_ERROR;

1083:
1084:
1085: -- If any errors happen abort API.
1086: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;
1091:

Line 1088: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1084:
1085: -- If any errors happen abort API.
1086: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;
1091:
1092:

Line 1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1085: -- If any errors happen abort API.
1086: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;
1091:
1092:
1093:

Line 1173: IF FND_API.To_Boolean ( p_commit )

1169: -- End of addition by nyostos.
1170:
1171:
1172: -- Standard check of p_commit.
1173: IF FND_API.To_Boolean ( p_commit )
1174: THEN
1175: COMMIT WORK;
1176: END IF;
1177:

Line 1199: p_encoded => FND_API.G_FALSE

1195: -- Standard call to get message count AND IF count is 1, get message info.
1196: FND_MSG_PUB.Count_AND_Get
1197: ( p_count => x_msg_count,
1198: p_data => x_msg_data,
1199: p_encoded => FND_API.G_FALSE
1200: );
1201:
1202: EXCEPTION
1203:

Line 1204: WHEN FND_API.G_EXC_ERROR THEN

1200: );
1201:
1202: EXCEPTION
1203:
1204: WHEN FND_API.G_EXC_ERROR THEN
1205:
1206: ROLLBACK TO Create_ListAction_PVT;
1207: x_return_status := FND_API.G_RET_STS_ERROR ;
1208: l_sqlerrm := SQLERRM;

Line 1207: x_return_status := FND_API.G_RET_STS_ERROR ;

1203:
1204: WHEN FND_API.G_EXC_ERROR THEN
1205:
1206: ROLLBACK TO Create_ListAction_PVT;
1207: x_return_status := FND_API.G_RET_STS_ERROR ;
1208: l_sqlerrm := SQLERRM;
1209: l_sqlcode := SQLCODE;
1210:
1211: FND_MSG_PUB.Count_AND_Get

Line 1214: p_encoded => FND_API.G_FALSE

1210:
1211: FND_MSG_PUB.Count_AND_Get
1212: ( p_count => x_msg_count,
1213: p_data => x_msg_data,
1214: p_encoded => FND_API.G_FALSE
1215: );
1216:
1217:
1218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1214: p_encoded => FND_API.G_FALSE
1215: );
1216:
1217:
1218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1219:
1220: ROLLBACK TO Create_ListAction_PVT;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1222: l_sqlerrm := SQLERRM;

Line 1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1217:
1218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1219:
1220: ROLLBACK TO Create_ListAction_PVT;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1222: l_sqlerrm := SQLERRM;
1223: l_sqlcode := SQLCODE;
1224:
1225: FND_MSG_PUB.Count_AND_Get

Line 1228: p_encoded => FND_API.G_FALSE

1224:
1225: FND_MSG_PUB.Count_AND_Get
1226: ( p_count => x_msg_count,
1227: p_data => x_msg_data,
1228: p_encoded => FND_API.G_FALSE
1229: );
1230:
1231: WHEN OTHERS THEN
1232:

Line 1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1230:
1231: WHEN OTHERS THEN
1232:
1233: ROLLBACK TO Create_ListAction_PVT;
1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1235: l_sqlerrm := SQLERRM;
1236: l_sqlcode := SQLCODE;
1237:
1238: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 1246: p_encoded => FND_API.G_FALSE

1242:
1243: FND_MSG_PUB.Count_AND_Get
1244: ( p_count => x_msg_count,
1245: p_data => x_msg_data,
1246: p_encoded => FND_API.G_FALSE
1247: );
1248:
1249: END Create_ListAction;
1250:

Line 1264: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

1260: -- p_action_rec: the record with new items
1261: --
1262: -- NOTES
1263: -- 1. Raise exception if the object_version_number doesn't match.
1264: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
1265: -- that column won't be updated.
1266: ----------------------------------------------------------------------
1267: -- End Of Comments
1268: PROCEDURE Update_ListAction

Line 1270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1266: ----------------------------------------------------------------------
1267: -- End Of Comments
1268: PROCEDURE Update_ListAction
1269: ( p_api_version IN NUMBER,
1270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1272: p_validation_level IN NUMBER
1273: := FND_API.G_VALID_LEVEL_FULL,
1274: x_return_status OUT NOCOPY VARCHAR2,

Line 1271: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1267: -- End Of Comments
1268: PROCEDURE Update_ListAction
1269: ( p_api_version IN NUMBER,
1270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1272: p_validation_level IN NUMBER
1273: := FND_API.G_VALID_LEVEL_FULL,
1274: x_return_status OUT NOCOPY VARCHAR2,
1275: x_msg_count OUT NOCOPY NUMBER,

Line 1273: := FND_API.G_VALID_LEVEL_FULL,

1269: ( p_api_version IN NUMBER,
1270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1272: p_validation_level IN NUMBER
1273: := FND_API.G_VALID_LEVEL_FULL,
1274: x_return_status OUT NOCOPY VARCHAR2,
1275: x_msg_count OUT NOCOPY NUMBER,
1276: x_msg_data OUT NOCOPY VARCHAR2,
1277:

Line 1298: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1294: -- Standard Start of API savepoint
1295: SAVEPOINT Update_ListAction_PVT;
1296:
1297: -- Standard call to check for call compatibility.
1298: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1299: p_api_version,
1300: l_api_name,
1301: G_PKG_NAME)
1302: THEN

Line 1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1299: p_api_version,
1300: l_api_name,
1301: G_PKG_NAME)
1302: THEN
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306: -- Initialize message list IF p_init_msg_list is set to TRUE.
1307: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1307: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1304: END IF;
1305:
1306: -- Initialize message list IF p_init_msg_list is set to TRUE.
1307: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1308: FND_MSG_PUB.initialize;
1309: END IF;
1310:
1311: -- Debug Message

Line 1329: x_return_status := FND_API.G_RET_STS_SUCCESS;

1325: init_action_rec(x_action_rec => l_action_rec);
1326: complete_action_rec(p_action_rec, l_action_rec);
1327:
1328: -- Initialize API return status to success
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1331: check_action_items(
1332: p_action_rec => l_action_rec,
1333: p_validation_mode => JTF_PLSQL_API.g_update,

Line 1336: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1332: p_action_rec => l_action_rec,
1333: p_validation_mode => JTF_PLSQL_API.g_update,
1334: x_return_status => l_return_status);
1335:
1336: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1337: RAISE FND_API.g_exc_unexpected_error;
1338: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1339: RAISE FND_API.g_exc_error;
1340: END IF;

Line 1337: RAISE FND_API.g_exc_unexpected_error;

1333: p_validation_mode => JTF_PLSQL_API.g_update,
1334: x_return_status => l_return_status);
1335:
1336: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1337: RAISE FND_API.g_exc_unexpected_error;
1338: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1339: RAISE FND_API.g_exc_error;
1340: END IF;
1341: END IF;

Line 1338: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1334: x_return_status => l_return_status);
1335:
1336: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1337: RAISE FND_API.g_exc_unexpected_error;
1338: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1339: RAISE FND_API.g_exc_error;
1340: END IF;
1341: END IF;
1342:

Line 1339: RAISE FND_API.g_exc_error;

1335:
1336: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1337: RAISE FND_API.g_exc_unexpected_error;
1338: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1339: RAISE FND_API.g_exc_error;
1340: END IF;
1341: END IF;
1342:
1343:

Line 1353: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1349: p_complete_rec => l_action_rec,
1350: x_return_status => l_return_status
1351: );
1352:
1353: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1354: RAISE FND_API.g_exc_unexpected_error;
1355: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1356: RAISE FND_API.g_exc_error;
1357: END IF;

Line 1354: RAISE FND_API.g_exc_unexpected_error;

1350: x_return_status => l_return_status
1351: );
1352:
1353: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1354: RAISE FND_API.g_exc_unexpected_error;
1355: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1356: RAISE FND_API.g_exc_error;
1357: END IF;
1358: END IF;

Line 1355: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1351: );
1352:
1353: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1354: RAISE FND_API.g_exc_unexpected_error;
1355: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1356: RAISE FND_API.g_exc_error;
1357: END IF;
1358: END IF;
1359:

Line 1356: RAISE FND_API.g_exc_error;

1352:
1353: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1354: RAISE FND_API.g_exc_unexpected_error;
1355: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1356: RAISE FND_API.g_exc_error;
1357: END IF;
1358: END IF;
1359:
1360:

Line 1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1421: FND_MESSAGE.Set_Token('ROW', 'AMS_ListAction_PVT.Update_ListAction API', TRUE);
1422: FND_MSG_PUB.Add;
1423: END IF;
1424:
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426: END IF;
1427:
1428: -- Added by nyostos on Oct 14, 2002
1429: -- If the Select Action record changed, Call the appropriate Model/Score

Line 1445: IF FND_API.To_Boolean ( p_commit )

1441: -- End of addition by nyostos.
1442:
1443:
1444: -- Standard check of p_commit.
1445: IF FND_API.To_Boolean ( p_commit )
1446: THEN
1447: COMMIT WORK;
1448: END IF;
1449:

Line 1474: p_encoded => FND_API.G_FALSE

1470: -- Standard call to get message count AND IF count is 1, get message info.
1471: FND_MSG_PUB.Count_AND_Get
1472: ( p_count => x_msg_count,
1473: p_data => x_msg_data,
1474: p_encoded => FND_API.G_FALSE
1475: );
1476:
1477: EXCEPTION
1478:

Line 1479: WHEN FND_API.G_EXC_ERROR THEN

1475: );
1476:
1477: EXCEPTION
1478:
1479: WHEN FND_API.G_EXC_ERROR THEN
1480:
1481: ROLLBACK TO Update_ListAction_PVT;
1482: x_return_status := FND_API.G_RET_STS_ERROR ;
1483: l_sqlerrm := SQLERRM;

Line 1482: x_return_status := FND_API.G_RET_STS_ERROR ;

1478:
1479: WHEN FND_API.G_EXC_ERROR THEN
1480:
1481: ROLLBACK TO Update_ListAction_PVT;
1482: x_return_status := FND_API.G_RET_STS_ERROR ;
1483: l_sqlerrm := SQLERRM;
1484: l_sqlcode := SQLCODE;
1485: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);
1486:

Line 1490: p_encoded => FND_API.G_FALSE

1486:
1487: FND_MSG_PUB.Count_AND_Get
1488: ( p_count => x_msg_count,
1489: p_data => x_msg_data,
1490: p_encoded => FND_API.G_FALSE
1491: );
1492:
1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1490: p_encoded => FND_API.G_FALSE
1491: );
1492:
1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1495:
1496: ROLLBACK TO Update_ListAction_PVT;
1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1498: l_sqlerrm := SQLERRM;

Line 1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1493:
1494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1495:
1496: ROLLBACK TO Update_ListAction_PVT;
1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1498: l_sqlerrm := SQLERRM;
1499: l_sqlcode := SQLCODE;
1500: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);
1501:

Line 1505: p_encoded => FND_API.G_FALSE

1501:
1502: FND_MSG_PUB.Count_AND_Get
1503: ( p_count => x_msg_count,
1504: p_data => x_msg_data,
1505: p_encoded => FND_API.G_FALSE
1506: );
1507:
1508:
1509: WHEN OTHERS THEN

Line 1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1508:
1509: WHEN OTHERS THEN
1510:
1511: ROLLBACK TO Update_ListAction_PVT;
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1513: l_sqlerrm := SQLERRM;
1514: l_sqlcode := SQLCODE;
1515: --dbms_output.put_line('AMS_ListAction_PVT.Update_listaction:'||l_sqlerrm||l_sqlcode);
1516:

Line 1525: p_encoded => FND_API.G_FALSE

1521:
1522: FND_MSG_PUB.Count_AND_Get
1523: ( p_count => x_msg_count,
1524: p_data => x_msg_data,
1525: p_encoded => FND_API.G_FALSE
1526: );
1527:
1528: End Update_ListAction;
1529:

Line 1548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1544: --------------------------------------------------------------------
1545: -- End Of Comments
1546: PROCEDURE Delete_ListAction
1547: ( p_api_version IN NUMBER,
1548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1549: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1551:
1552: x_return_status OUT NOCOPY VARCHAR2,

Line 1549: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1545: -- End Of Comments
1546: PROCEDURE Delete_ListAction
1547: ( p_api_version IN NUMBER,
1548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1549: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1551:
1552: x_return_status OUT NOCOPY VARCHAR2,
1553: x_msg_count OUT NOCOPY NUMBER,

Line 1550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1546: PROCEDURE Delete_ListAction
1547: ( p_api_version IN NUMBER,
1548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1549: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1551:
1552: x_return_status OUT NOCOPY VARCHAR2,
1553: x_msg_count OUT NOCOPY NUMBER,
1554: x_msg_data OUT NOCOPY VARCHAR2,

Line 1574: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1570: -- Standard Start of API savepoint
1571: SAVEPOINT Delete_ListAction_PVT;
1572:
1573: -- Standard call to check for call compatibility.
1574: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1575: p_api_version,
1576: l_api_name,
1577: G_PKG_NAME)
1578: THEN

Line 1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1575: p_api_version,
1576: l_api_name,
1577: G_PKG_NAME)
1578: THEN
1579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1580: END IF;
1581:
1582:
1583:

Line 1585: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1581:
1582:
1583:
1584: -- Initialize message list IF p_init_msg_list is set to TRUE.
1585: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1586: FND_MSG_PUB.initialize;
1587: END IF;
1588:
1589: -- Debug Message

Line 1603: x_return_status := FND_API.G_RET_STS_SUCCESS;

1599: END IF;
1600:
1601:
1602: -- Initialize API return status to success
1603: x_return_status := FND_API.G_RET_STS_SUCCESS;
1604:
1605:
1606: -- Perform the database operation
1607:

Line 1659: x_return_status := FND_API.g_ret_sts_error;

1655: FND_MESSAGE.set_name('AMS', 'AMS_LIST_ACTION_NO_DEL');
1656: FND_MSG_PUB.add;
1657: END IF;
1658:
1659: x_return_status := FND_API.g_ret_sts_error;
1660: RAISE FND_API.G_EXC_ERROR;
1661: -- RETURN;
1662: END IF;
1663:

Line 1660: RAISE FND_API.G_EXC_ERROR;

1656: FND_MSG_PUB.add;
1657: END IF;
1658:
1659: x_return_status := FND_API.g_ret_sts_error;
1660: RAISE FND_API.G_EXC_ERROR;
1661: -- RETURN;
1662: END IF;
1663:
1664: ELSIF (l_complete_action_rec.arc_action_used_by='MODL')

Line 1691: IF FND_API.To_Boolean ( p_commit )

1687: -- END of API body.
1688: --
1689:
1690: -- Standard check of p_commit.
1691: IF FND_API.To_Boolean ( p_commit )
1692: THEN
1693: COMMIT WORK;
1694: END IF;
1695:

Line 1718: p_encoded => FND_API.G_FALSE

1714: -- Standard call to get message count AND IF count is 1, get message info.
1715: FND_MSG_PUB.Count_AND_Get
1716: ( p_count => x_msg_count,
1717: p_data => x_msg_data,
1718: p_encoded => FND_API.G_FALSE
1719: );
1720:
1721: EXCEPTION
1722:

Line 1723: WHEN FND_API.G_EXC_ERROR THEN

1719: );
1720:
1721: EXCEPTION
1722:
1723: WHEN FND_API.G_EXC_ERROR THEN
1724:
1725: ROLLBACK TO Delete_ListAction_PVT;
1726: x_return_status := FND_API.G_RET_STS_ERROR ;
1727:

Line 1726: x_return_status := FND_API.G_RET_STS_ERROR ;

1722:
1723: WHEN FND_API.G_EXC_ERROR THEN
1724:
1725: ROLLBACK TO Delete_ListAction_PVT;
1726: x_return_status := FND_API.G_RET_STS_ERROR ;
1727:
1728: FND_MSG_PUB.Count_AND_Get
1729: ( p_count => x_msg_count,
1730: p_data => x_msg_data,

Line 1731: p_encoded => FND_API.G_FALSE

1727:
1728: FND_MSG_PUB.Count_AND_Get
1729: ( p_count => x_msg_count,
1730: p_data => x_msg_data,
1731: p_encoded => FND_API.G_FALSE
1732: );
1733:
1734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1735:

Line 1734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1730: p_data => x_msg_data,
1731: p_encoded => FND_API.G_FALSE
1732: );
1733:
1734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1735:
1736: ROLLBACK TO Delete_ListAction_PVT;
1737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1738:

Line 1737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1733:
1734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1735:
1736: ROLLBACK TO Delete_ListAction_PVT;
1737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1738:
1739: FND_MSG_PUB.Count_AND_Get
1740: ( p_count => x_msg_count,
1741: p_data => x_msg_data,

Line 1742: p_encoded => FND_API.G_FALSE

1738:
1739: FND_MSG_PUB.Count_AND_Get
1740: ( p_count => x_msg_count,
1741: p_data => x_msg_data,
1742: p_encoded => FND_API.G_FALSE
1743: );
1744:
1745:
1746: WHEN OTHERS THEN

Line 1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1745:
1746: WHEN OTHERS THEN
1747:
1748: ROLLBACK TO Delete_ListAction_PVT;
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1750:
1751: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1752: THEN
1753: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1759: p_encoded => FND_API.G_FALSE

1755:
1756: FND_MSG_PUB.Count_AND_Get
1757: ( p_count => x_msg_count,
1758: p_data => x_msg_data,
1759: p_encoded => FND_API.G_FALSE
1760: );
1761:
1762:
1763: END Delete_ListAction;

Line 1783: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1779: --------------------------------------------------------------------
1780: -- End Of Comments
1781: PROCEDURE Lock_ListAction
1782: ( p_api_version IN NUMBER,
1783: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1785:
1786: x_return_status OUT NOCOPY VARCHAR2,
1787: x_msg_count OUT NOCOPY NUMBER,

Line 1784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1780: -- End Of Comments
1781: PROCEDURE Lock_ListAction
1782: ( p_api_version IN NUMBER,
1783: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1785:
1786: x_return_status OUT NOCOPY VARCHAR2,
1787: x_msg_count OUT NOCOPY NUMBER,
1788: x_msg_data OUT NOCOPY VARCHAR2,

Line 1814: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1810: BEGIN
1811:
1812:
1813: -- Standard call to check for call compatibility.
1814: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1815: p_api_version,
1816: l_api_name,
1817: G_PKG_NAME)
1818: THEN

Line 1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1815: p_api_version,
1816: l_api_name,
1817: G_PKG_NAME)
1818: THEN
1819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1820: END IF;
1821:
1822:
1823:

Line 1825: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1821:
1822:
1823:
1824: -- Initialize message list if p_init_msg_list is set to TRUE.
1825: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1826: FND_MSG_PUB.initialize;
1827: END IF;
1828:
1829:

Line 1843: x_return_status := FND_API.G_RET_STS_SUCCESS;

1839: AMS_Utility_PVT.debug_message(l_api_name||': Start ');
1840: END IF;
1841:
1842: -- Initialize API return status to success
1843: x_return_status := FND_API.G_RET_STS_SUCCESS;
1844:
1845: OPEN c_list_actions;
1846: FETCH c_list_actions INTO l_list_select_action_id;
1847: IF (c_list_actions%NOTFOUND) THEN

Line 1853: RAISE FND_API.g_exc_error;

1849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1850: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1851: FND_MSG_PUB.add;
1852: END IF;
1853: RAISE FND_API.g_exc_error;
1854: END IF;
1855: CLOSE c_list_actions;
1856:
1857:

Line 1879: p_encoded => FND_API.G_FALSE

1875: -- Standard call to get message count AND IF count is 1, get message info.
1876: FND_MSG_PUB.Count_AND_Get
1877: ( p_count => x_msg_count,
1878: p_data => x_msg_data,
1879: p_encoded => FND_API.G_FALSE
1880: );
1881:
1882:
1883:

Line 1886: WHEN FND_API.G_EXC_ERROR THEN

1882:
1883:
1884: EXCEPTION
1885:
1886: WHEN FND_API.G_EXC_ERROR THEN
1887:
1888: x_return_status := FND_API.G_RET_STS_ERROR ;
1889:
1890: FND_MSG_PUB.Count_AND_Get

Line 1888: x_return_status := FND_API.G_RET_STS_ERROR ;

1884: EXCEPTION
1885:
1886: WHEN FND_API.G_EXC_ERROR THEN
1887:
1888: x_return_status := FND_API.G_RET_STS_ERROR ;
1889:
1890: FND_MSG_PUB.Count_AND_Get
1891: ( p_count => x_msg_count,
1892: p_data => x_msg_data,

Line 1893: p_encoded => FND_API.G_FALSE

1889:
1890: FND_MSG_PUB.Count_AND_Get
1891: ( p_count => x_msg_count,
1892: p_data => x_msg_data,
1893: p_encoded => FND_API.G_FALSE
1894: );
1895:
1896:
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1893: p_encoded => FND_API.G_FALSE
1894: );
1895:
1896:
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898:
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1900:
1901: FND_MSG_PUB.Count_AND_Get

Line 1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1895:
1896:
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898:
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1900:
1901: FND_MSG_PUB.Count_AND_Get
1902: ( p_count => x_msg_count,
1903: p_data => x_msg_data,

Line 1904: p_encoded => FND_API.G_FALSE

1900:
1901: FND_MSG_PUB.Count_AND_Get
1902: ( p_count => x_msg_count,
1903: p_data => x_msg_data,
1904: p_encoded => FND_API.G_FALSE
1905: );
1906:
1907: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
1908:

Line 1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1905: );
1906:
1907: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
1908:
1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1910:
1911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1912: THEN -- MMSG
1913: FND_MESSAGE.SET_NAME('AMS','API_RESOURCE_LOCKED');

Line 1920: p_encoded => FND_API.G_FALSE

1916:
1917: FND_MSG_PUB.Count_AND_Get
1918: ( p_count => x_msg_count,
1919: p_data => x_msg_data,
1920: p_encoded => FND_API.G_FALSE
1921: );
1922:
1923: WHEN OTHERS THEN
1924:

Line 1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1921: );
1922:
1923: WHEN OTHERS THEN
1924:
1925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1926:
1927: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1928: THEN
1929: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1935: p_encoded => FND_API.G_FALSE

1931:
1932: FND_MSG_PUB.Count_AND_Get
1933: ( p_count => x_msg_count,
1934: p_data => x_msg_data,
1935: p_encoded => FND_API.G_FALSE
1936: );
1937:
1938: END Lock_ListAction;
1939:

Line 1953: x_action_rec.list_select_action_id := FND_API.g_miss_num;

1949: )
1950: IS
1951: BEGIN
1952:
1953: x_action_rec.list_select_action_id := FND_API.g_miss_num;
1954: x_action_rec.last_update_date := FND_API.g_miss_date;
1955: x_action_rec.last_updated_by := FND_API.g_miss_num;
1956: x_action_rec.creation_date := FND_API.g_miss_date;
1957: x_action_rec.created_by := FND_API.g_miss_num;

Line 1954: x_action_rec.last_update_date := FND_API.g_miss_date;

1950: IS
1951: BEGIN
1952:
1953: x_action_rec.list_select_action_id := FND_API.g_miss_num;
1954: x_action_rec.last_update_date := FND_API.g_miss_date;
1955: x_action_rec.last_updated_by := FND_API.g_miss_num;
1956: x_action_rec.creation_date := FND_API.g_miss_date;
1957: x_action_rec.created_by := FND_API.g_miss_num;
1958: x_action_rec.last_update_login := FND_API.g_miss_num;

Line 1955: x_action_rec.last_updated_by := FND_API.g_miss_num;

1951: BEGIN
1952:
1953: x_action_rec.list_select_action_id := FND_API.g_miss_num;
1954: x_action_rec.last_update_date := FND_API.g_miss_date;
1955: x_action_rec.last_updated_by := FND_API.g_miss_num;
1956: x_action_rec.creation_date := FND_API.g_miss_date;
1957: x_action_rec.created_by := FND_API.g_miss_num;
1958: x_action_rec.last_update_login := FND_API.g_miss_num;
1959: x_action_rec.object_version_number := FND_API.g_miss_num;

Line 1956: x_action_rec.creation_date := FND_API.g_miss_date;

1952:
1953: x_action_rec.list_select_action_id := FND_API.g_miss_num;
1954: x_action_rec.last_update_date := FND_API.g_miss_date;
1955: x_action_rec.last_updated_by := FND_API.g_miss_num;
1956: x_action_rec.creation_date := FND_API.g_miss_date;
1957: x_action_rec.created_by := FND_API.g_miss_num;
1958: x_action_rec.last_update_login := FND_API.g_miss_num;
1959: x_action_rec.object_version_number := FND_API.g_miss_num;
1960: x_action_rec.order_number := FND_API.g_miss_num;

Line 1957: x_action_rec.created_by := FND_API.g_miss_num;

1953: x_action_rec.list_select_action_id := FND_API.g_miss_num;
1954: x_action_rec.last_update_date := FND_API.g_miss_date;
1955: x_action_rec.last_updated_by := FND_API.g_miss_num;
1956: x_action_rec.creation_date := FND_API.g_miss_date;
1957: x_action_rec.created_by := FND_API.g_miss_num;
1958: x_action_rec.last_update_login := FND_API.g_miss_num;
1959: x_action_rec.object_version_number := FND_API.g_miss_num;
1960: x_action_rec.order_number := FND_API.g_miss_num;
1961: x_action_rec.list_action_type := FND_API.g_miss_char;

Line 1958: x_action_rec.last_update_login := FND_API.g_miss_num;

1954: x_action_rec.last_update_date := FND_API.g_miss_date;
1955: x_action_rec.last_updated_by := FND_API.g_miss_num;
1956: x_action_rec.creation_date := FND_API.g_miss_date;
1957: x_action_rec.created_by := FND_API.g_miss_num;
1958: x_action_rec.last_update_login := FND_API.g_miss_num;
1959: x_action_rec.object_version_number := FND_API.g_miss_num;
1960: x_action_rec.order_number := FND_API.g_miss_num;
1961: x_action_rec.list_action_type := FND_API.g_miss_char;
1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;

Line 1959: x_action_rec.object_version_number := FND_API.g_miss_num;

1955: x_action_rec.last_updated_by := FND_API.g_miss_num;
1956: x_action_rec.creation_date := FND_API.g_miss_date;
1957: x_action_rec.created_by := FND_API.g_miss_num;
1958: x_action_rec.last_update_login := FND_API.g_miss_num;
1959: x_action_rec.object_version_number := FND_API.g_miss_num;
1960: x_action_rec.order_number := FND_API.g_miss_num;
1961: x_action_rec.list_action_type := FND_API.g_miss_char;
1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;
1963: x_action_rec.incl_object_id := FND_API.g_miss_num;

Line 1960: x_action_rec.order_number := FND_API.g_miss_num;

1956: x_action_rec.creation_date := FND_API.g_miss_date;
1957: x_action_rec.created_by := FND_API.g_miss_num;
1958: x_action_rec.last_update_login := FND_API.g_miss_num;
1959: x_action_rec.object_version_number := FND_API.g_miss_num;
1960: x_action_rec.order_number := FND_API.g_miss_num;
1961: x_action_rec.list_action_type := FND_API.g_miss_char;
1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;
1963: x_action_rec.incl_object_id := FND_API.g_miss_num;
1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;

Line 1961: x_action_rec.list_action_type := FND_API.g_miss_char;

1957: x_action_rec.created_by := FND_API.g_miss_num;
1958: x_action_rec.last_update_login := FND_API.g_miss_num;
1959: x_action_rec.object_version_number := FND_API.g_miss_num;
1960: x_action_rec.order_number := FND_API.g_miss_num;
1961: x_action_rec.list_action_type := FND_API.g_miss_char;
1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;
1963: x_action_rec.incl_object_id := FND_API.g_miss_num;
1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;
1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;

Line 1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;

1958: x_action_rec.last_update_login := FND_API.g_miss_num;
1959: x_action_rec.object_version_number := FND_API.g_miss_num;
1960: x_action_rec.order_number := FND_API.g_miss_num;
1961: x_action_rec.list_action_type := FND_API.g_miss_char;
1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;
1963: x_action_rec.incl_object_id := FND_API.g_miss_num;
1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;
1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;
1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;

Line 1963: x_action_rec.incl_object_id := FND_API.g_miss_num;

1959: x_action_rec.object_version_number := FND_API.g_miss_num;
1960: x_action_rec.order_number := FND_API.g_miss_num;
1961: x_action_rec.list_action_type := FND_API.g_miss_char;
1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;
1963: x_action_rec.incl_object_id := FND_API.g_miss_num;
1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;
1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;
1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;
1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;

Line 1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;

1960: x_action_rec.order_number := FND_API.g_miss_num;
1961: x_action_rec.list_action_type := FND_API.g_miss_char;
1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;
1963: x_action_rec.incl_object_id := FND_API.g_miss_num;
1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;
1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;
1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;
1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;
1968: */

Line 1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;

1961: x_action_rec.list_action_type := FND_API.g_miss_char;
1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;
1963: x_action_rec.incl_object_id := FND_API.g_miss_num;
1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;
1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;
1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;
1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;
1968: */
1969: x_action_rec.rank := FND_API.g_miss_num;

Line 1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;

1962: x_action_rec.arc_incl_object_from := FND_API.g_miss_char;
1963: x_action_rec.incl_object_id := FND_API.g_miss_num;
1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;
1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;
1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;
1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;
1968: */
1969: x_action_rec.rank := FND_API.g_miss_num;
1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;

Line 1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;

1963: x_action_rec.incl_object_id := FND_API.g_miss_num;
1964: /* x_action_rec.INCL_OBJECT_NAME := FND_API.g_miss_char;
1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;
1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;
1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;
1968: */
1969: x_action_rec.rank := FND_API.g_miss_num;
1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;
1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;

Line 1969: x_action_rec.rank := FND_API.g_miss_num;

1965: x_action_rec.INCL_OBJECT_WB_SHEET := FND_API.g_miss_char;
1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;
1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;
1968: */
1969: x_action_rec.rank := FND_API.g_miss_num;
1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;
1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;
1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;
1973: x_action_rec.distribution_pct := FND_API.g_miss_num;

Line 1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;

1966: x_action_rec.INCL_OBJECT_WB_OWNER := FND_API.g_miss_num;
1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;
1968: */
1969: x_action_rec.rank := FND_API.g_miss_num;
1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;
1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;
1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;
1973: x_action_rec.distribution_pct := FND_API.g_miss_num;
1974: x_action_rec.result_text := FND_API.g_miss_char;

Line 1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;

1967: x_action_rec.INCL_OBJECT_CELL_CODE := FND_API.g_miss_char;
1968: */
1969: x_action_rec.rank := FND_API.g_miss_num;
1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;
1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;
1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;
1973: x_action_rec.distribution_pct := FND_API.g_miss_num;
1974: x_action_rec.result_text := FND_API.g_miss_char;
1975: x_action_rec.description := FND_API.g_miss_char;

Line 1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;

1968: */
1969: x_action_rec.rank := FND_API.g_miss_num;
1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;
1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;
1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;
1973: x_action_rec.distribution_pct := FND_API.g_miss_num;
1974: x_action_rec.result_text := FND_API.g_miss_char;
1975: x_action_rec.description := FND_API.g_miss_char;
1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;

Line 1973: x_action_rec.distribution_pct := FND_API.g_miss_num;

1969: x_action_rec.rank := FND_API.g_miss_num;
1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;
1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;
1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;
1973: x_action_rec.distribution_pct := FND_API.g_miss_num;
1974: x_action_rec.result_text := FND_API.g_miss_char;
1975: x_action_rec.description := FND_API.g_miss_char;
1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;
1977: x_action_rec.action_used_by_id := FND_API.g_miss_num;

Line 1974: x_action_rec.result_text := FND_API.g_miss_char;

1970: x_action_rec.no_of_rows_available := FND_API.g_miss_num;
1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;
1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;
1973: x_action_rec.distribution_pct := FND_API.g_miss_num;
1974: x_action_rec.result_text := FND_API.g_miss_char;
1975: x_action_rec.description := FND_API.g_miss_char;
1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;
1977: x_action_rec.action_used_by_id := FND_API.g_miss_num;
1978: x_action_rec.incl_control_group := FND_API.g_miss_char;

Line 1975: x_action_rec.description := FND_API.g_miss_char;

1971: x_action_rec.no_of_rows_requested := FND_API.g_miss_num;
1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;
1973: x_action_rec.distribution_pct := FND_API.g_miss_num;
1974: x_action_rec.result_text := FND_API.g_miss_char;
1975: x_action_rec.description := FND_API.g_miss_char;
1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;
1977: x_action_rec.action_used_by_id := FND_API.g_miss_num;
1978: x_action_rec.incl_control_group := FND_API.g_miss_char;
1979: x_action_rec.no_of_rows_targeted := FND_API.g_miss_num;

Line 1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;

1972: x_action_rec.no_of_rows_used := FND_API.g_miss_num;
1973: x_action_rec.distribution_pct := FND_API.g_miss_num;
1974: x_action_rec.result_text := FND_API.g_miss_char;
1975: x_action_rec.description := FND_API.g_miss_char;
1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;
1977: x_action_rec.action_used_by_id := FND_API.g_miss_num;
1978: x_action_rec.incl_control_group := FND_API.g_miss_char;
1979: x_action_rec.no_of_rows_targeted := FND_API.g_miss_num;
1980:

Line 1977: x_action_rec.action_used_by_id := FND_API.g_miss_num;

1973: x_action_rec.distribution_pct := FND_API.g_miss_num;
1974: x_action_rec.result_text := FND_API.g_miss_char;
1975: x_action_rec.description := FND_API.g_miss_char;
1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;
1977: x_action_rec.action_used_by_id := FND_API.g_miss_num;
1978: x_action_rec.incl_control_group := FND_API.g_miss_char;
1979: x_action_rec.no_of_rows_targeted := FND_API.g_miss_num;
1980:
1981:

Line 1978: x_action_rec.incl_control_group := FND_API.g_miss_char;

1974: x_action_rec.result_text := FND_API.g_miss_char;
1975: x_action_rec.description := FND_API.g_miss_char;
1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;
1977: x_action_rec.action_used_by_id := FND_API.g_miss_num;
1978: x_action_rec.incl_control_group := FND_API.g_miss_char;
1979: x_action_rec.no_of_rows_targeted := FND_API.g_miss_num;
1980:
1981:
1982: End Init_Action_Rec;

Line 1979: x_action_rec.no_of_rows_targeted := FND_API.g_miss_num;

1975: x_action_rec.description := FND_API.g_miss_char;
1976: x_action_rec.arc_action_used_by := FND_API.g_miss_char;
1977: x_action_rec.action_used_by_id := FND_API.g_miss_num;
1978: x_action_rec.incl_control_group := FND_API.g_miss_char;
1979: x_action_rec.no_of_rows_targeted := FND_API.g_miss_num;
1980:
1981:
1982: End Init_Action_Rec;
1983:

Line 2016: RAISE FND_API.g_exc_error;

2012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2013: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2014: FND_MSG_PUB.add;
2015: END IF;
2016: RAISE FND_API.g_exc_error;
2017: END IF;
2018: CLOSE c_action;
2019:
2020:

Line 2021: IF p_action_rec.list_select_action_id = FND_API.g_miss_num THEN

2017: END IF;
2018: CLOSE c_action;
2019:
2020:
2021: IF p_action_rec.list_select_action_id = FND_API.g_miss_num THEN
2022: x_complete_rec.list_select_action_id := l_action_rec.list_select_action_id;
2023: END IF;
2024:
2025: IF p_action_rec.last_update_date = FND_API.g_miss_date THEN

Line 2025: IF p_action_rec.last_update_date = FND_API.g_miss_date THEN

2021: IF p_action_rec.list_select_action_id = FND_API.g_miss_num THEN
2022: x_complete_rec.list_select_action_id := l_action_rec.list_select_action_id;
2023: END IF;
2024:
2025: IF p_action_rec.last_update_date = FND_API.g_miss_date THEN
2026: x_complete_rec.last_update_date := l_action_rec.last_update_date;
2027: END IF;
2028:
2029: IF p_action_rec.last_updated_by = FND_API.g_miss_num THEN

Line 2029: IF p_action_rec.last_updated_by = FND_API.g_miss_num THEN

2025: IF p_action_rec.last_update_date = FND_API.g_miss_date THEN
2026: x_complete_rec.last_update_date := l_action_rec.last_update_date;
2027: END IF;
2028:
2029: IF p_action_rec.last_updated_by = FND_API.g_miss_num THEN
2030: x_complete_rec.last_updated_by := l_action_rec.last_updated_by;
2031: END IF;
2032:
2033: IF p_action_rec.creation_date = FND_API.g_miss_date THEN

Line 2033: IF p_action_rec.creation_date = FND_API.g_miss_date THEN

2029: IF p_action_rec.last_updated_by = FND_API.g_miss_num THEN
2030: x_complete_rec.last_updated_by := l_action_rec.last_updated_by;
2031: END IF;
2032:
2033: IF p_action_rec.creation_date = FND_API.g_miss_date THEN
2034: x_complete_rec.creation_date := l_action_rec.creation_date;
2035: END IF;
2036:
2037: IF p_action_rec.created_by = FND_API.g_miss_num THEN

Line 2037: IF p_action_rec.created_by = FND_API.g_miss_num THEN

2033: IF p_action_rec.creation_date = FND_API.g_miss_date THEN
2034: x_complete_rec.creation_date := l_action_rec.creation_date;
2035: END IF;
2036:
2037: IF p_action_rec.created_by = FND_API.g_miss_num THEN
2038: x_complete_rec.created_by := l_action_rec.created_by;
2039: END IF;
2040:
2041: IF p_action_rec.last_update_login = FND_API.g_miss_num THEN

Line 2041: IF p_action_rec.last_update_login = FND_API.g_miss_num THEN

2037: IF p_action_rec.created_by = FND_API.g_miss_num THEN
2038: x_complete_rec.created_by := l_action_rec.created_by;
2039: END IF;
2040:
2041: IF p_action_rec.last_update_login = FND_API.g_miss_num THEN
2042: x_complete_rec.last_update_login := l_action_rec.last_update_login;
2043: END IF;
2044:
2045: IF p_action_rec.object_version_number = FND_API.g_miss_num THEN

Line 2045: IF p_action_rec.object_version_number = FND_API.g_miss_num THEN

2041: IF p_action_rec.last_update_login = FND_API.g_miss_num THEN
2042: x_complete_rec.last_update_login := l_action_rec.last_update_login;
2043: END IF;
2044:
2045: IF p_action_rec.object_version_number = FND_API.g_miss_num THEN
2046: x_complete_rec.object_version_number := l_action_rec.object_version_number;
2047: END IF;
2048:
2049:

Line 2050: IF p_action_rec.order_number = FND_API.g_miss_num THEN

2046: x_complete_rec.object_version_number := l_action_rec.object_version_number;
2047: END IF;
2048:
2049:
2050: IF p_action_rec.order_number = FND_API.g_miss_num THEN
2051: x_complete_rec.order_number := l_action_rec.order_number;
2052: END IF;
2053:
2054: IF p_action_rec.list_action_type = FND_API.g_miss_char THEN

Line 2054: IF p_action_rec.list_action_type = FND_API.g_miss_char THEN

2050: IF p_action_rec.order_number = FND_API.g_miss_num THEN
2051: x_complete_rec.order_number := l_action_rec.order_number;
2052: END IF;
2053:
2054: IF p_action_rec.list_action_type = FND_API.g_miss_char THEN
2055: x_complete_rec.list_action_type := l_action_rec.list_action_type;
2056: END IF;
2057:
2058:

Line 2059: IF p_action_rec.arc_incl_object_from = FND_API.g_miss_char THEN

2055: x_complete_rec.list_action_type := l_action_rec.list_action_type;
2056: END IF;
2057:
2058:
2059: IF p_action_rec.arc_incl_object_from = FND_API.g_miss_char THEN
2060: x_complete_rec.arc_incl_object_from := l_action_rec.arc_incl_object_from;
2061: END IF;
2062:
2063: IF p_action_rec.incl_object_id = FND_API.g_miss_num THEN

Line 2063: IF p_action_rec.incl_object_id = FND_API.g_miss_num THEN

2059: IF p_action_rec.arc_incl_object_from = FND_API.g_miss_char THEN
2060: x_complete_rec.arc_incl_object_from := l_action_rec.arc_incl_object_from;
2061: END IF;
2062:
2063: IF p_action_rec.incl_object_id = FND_API.g_miss_num THEN
2064: x_complete_rec.incl_object_id := l_action_rec.incl_object_id;
2065: END IF;
2066:
2067: /*

Line 2068: IF p_action_rec.INCL_OBJECT_NAME = FND_API.g_miss_char THEN

2064: x_complete_rec.incl_object_id := l_action_rec.incl_object_id;
2065: END IF;
2066:
2067: /*
2068: IF p_action_rec.INCL_OBJECT_NAME = FND_API.g_miss_char THEN
2069: x_complete_rec.INCL_OBJECT_NAME := l_action_rec.INCL_OBJECT_NAME;
2070: END IF;
2071:
2072: IF p_action_rec.INCL_OBJECT_WB_SHEET = FND_API.g_miss_char THEN

Line 2072: IF p_action_rec.INCL_OBJECT_WB_SHEET = FND_API.g_miss_char THEN

2068: IF p_action_rec.INCL_OBJECT_NAME = FND_API.g_miss_char THEN
2069: x_complete_rec.INCL_OBJECT_NAME := l_action_rec.INCL_OBJECT_NAME;
2070: END IF;
2071:
2072: IF p_action_rec.INCL_OBJECT_WB_SHEET = FND_API.g_miss_char THEN
2073: x_complete_rec.INCL_OBJECT_WB_SHEET := l_action_rec.INCL_OBJECT_WB_SHEET;
2074: END IF;
2075:
2076: IF p_action_rec.INCL_OBJECT_WB_OWNER = FND_API.g_miss_num THEN

Line 2076: IF p_action_rec.INCL_OBJECT_WB_OWNER = FND_API.g_miss_num THEN

2072: IF p_action_rec.INCL_OBJECT_WB_SHEET = FND_API.g_miss_char THEN
2073: x_complete_rec.INCL_OBJECT_WB_SHEET := l_action_rec.INCL_OBJECT_WB_SHEET;
2074: END IF;
2075:
2076: IF p_action_rec.INCL_OBJECT_WB_OWNER = FND_API.g_miss_num THEN
2077: x_complete_rec.INCL_OBJECT_WB_OWNER := l_action_rec.INCL_OBJECT_WB_OWNER;
2078: END IF;
2079:
2080: IF p_action_rec.INCL_OBJECT_CELL_CODE = FND_API.g_miss_char THEN

Line 2080: IF p_action_rec.INCL_OBJECT_CELL_CODE = FND_API.g_miss_char THEN

2076: IF p_action_rec.INCL_OBJECT_WB_OWNER = FND_API.g_miss_num THEN
2077: x_complete_rec.INCL_OBJECT_WB_OWNER := l_action_rec.INCL_OBJECT_WB_OWNER;
2078: END IF;
2079:
2080: IF p_action_rec.INCL_OBJECT_CELL_CODE = FND_API.g_miss_char THEN
2081: x_complete_rec.INCL_OBJECT_CELL_CODE := l_action_rec.INCL_OBJECT_CELL_CODE;
2082: END IF;
2083: */
2084: IF p_action_rec.rank = FND_API.g_miss_num THEN

Line 2084: IF p_action_rec.rank = FND_API.g_miss_num THEN

2080: IF p_action_rec.INCL_OBJECT_CELL_CODE = FND_API.g_miss_char THEN
2081: x_complete_rec.INCL_OBJECT_CELL_CODE := l_action_rec.INCL_OBJECT_CELL_CODE;
2082: END IF;
2083: */
2084: IF p_action_rec.rank = FND_API.g_miss_num THEN
2085: x_complete_rec.rank := l_action_rec.rank ;
2086: END IF;
2087:
2088: IF p_action_rec.no_of_rows_available = FND_API.g_miss_num THEN

Line 2088: IF p_action_rec.no_of_rows_available = FND_API.g_miss_num THEN

2084: IF p_action_rec.rank = FND_API.g_miss_num THEN
2085: x_complete_rec.rank := l_action_rec.rank ;
2086: END IF;
2087:
2088: IF p_action_rec.no_of_rows_available = FND_API.g_miss_num THEN
2089: x_complete_rec.no_of_rows_available := l_action_rec.no_of_rows_available;
2090: END IF;
2091:
2092: IF p_action_rec.no_of_rows_requested = FND_API.g_miss_num THEN

Line 2092: IF p_action_rec.no_of_rows_requested = FND_API.g_miss_num THEN

2088: IF p_action_rec.no_of_rows_available = FND_API.g_miss_num THEN
2089: x_complete_rec.no_of_rows_available := l_action_rec.no_of_rows_available;
2090: END IF;
2091:
2092: IF p_action_rec.no_of_rows_requested = FND_API.g_miss_num THEN
2093: x_complete_rec.no_of_rows_requested := l_action_rec.no_of_rows_requested;
2094: END IF;
2095:
2096: IF p_action_rec.no_of_rows_used = FND_API.g_miss_num THEN

Line 2096: IF p_action_rec.no_of_rows_used = FND_API.g_miss_num THEN

2092: IF p_action_rec.no_of_rows_requested = FND_API.g_miss_num THEN
2093: x_complete_rec.no_of_rows_requested := l_action_rec.no_of_rows_requested;
2094: END IF;
2095:
2096: IF p_action_rec.no_of_rows_used = FND_API.g_miss_num THEN
2097: x_complete_rec.no_of_rows_used := l_action_rec.no_of_rows_used;
2098: END IF;
2099:
2100: IF p_action_rec.distribution_pct = FND_API.g_miss_num THEN

Line 2100: IF p_action_rec.distribution_pct = FND_API.g_miss_num THEN

2096: IF p_action_rec.no_of_rows_used = FND_API.g_miss_num THEN
2097: x_complete_rec.no_of_rows_used := l_action_rec.no_of_rows_used;
2098: END IF;
2099:
2100: IF p_action_rec.distribution_pct = FND_API.g_miss_num THEN
2101: x_complete_rec.distribution_pct := l_action_rec.distribution_pct;
2102: END IF;
2103:
2104: IF p_action_rec.result_text = FND_API.g_miss_char THEN

Line 2104: IF p_action_rec.result_text = FND_API.g_miss_char THEN

2100: IF p_action_rec.distribution_pct = FND_API.g_miss_num THEN
2101: x_complete_rec.distribution_pct := l_action_rec.distribution_pct;
2102: END IF;
2103:
2104: IF p_action_rec.result_text = FND_API.g_miss_char THEN
2105: x_complete_rec.result_text := l_action_rec.result_text;
2106: END IF;
2107:
2108: IF p_action_rec.description = FND_API.g_miss_char THEN

Line 2108: IF p_action_rec.description = FND_API.g_miss_char THEN

2104: IF p_action_rec.result_text = FND_API.g_miss_char THEN
2105: x_complete_rec.result_text := l_action_rec.result_text;
2106: END IF;
2107:
2108: IF p_action_rec.description = FND_API.g_miss_char THEN
2109: x_complete_rec.description := l_action_rec.description;
2110: END IF;
2111:
2112:

Line 2113: IF p_action_rec.arc_action_used_by = FND_API.g_miss_char THEN

2109: x_complete_rec.description := l_action_rec.description;
2110: END IF;
2111:
2112:
2113: IF p_action_rec.arc_action_used_by = FND_API.g_miss_char THEN
2114: x_complete_rec.arc_action_used_by := l_action_rec.arc_action_used_by;
2115: END IF;
2116:
2117: IF p_action_rec.action_used_by_id = FND_API.g_miss_num THEN

Line 2117: IF p_action_rec.action_used_by_id = FND_API.g_miss_num THEN

2113: IF p_action_rec.arc_action_used_by = FND_API.g_miss_char THEN
2114: x_complete_rec.arc_action_used_by := l_action_rec.arc_action_used_by;
2115: END IF;
2116:
2117: IF p_action_rec.action_used_by_id = FND_API.g_miss_num THEN
2118: x_complete_rec.action_used_by_id := l_action_rec.action_used_by_id;
2119: END IF;
2120:
2121: IF p_action_rec.incl_control_group= FND_API.g_miss_char THEN

Line 2121: IF p_action_rec.incl_control_group= FND_API.g_miss_char THEN

2117: IF p_action_rec.action_used_by_id = FND_API.g_miss_num THEN
2118: x_complete_rec.action_used_by_id := l_action_rec.action_used_by_id;
2119: END IF;
2120:
2121: IF p_action_rec.incl_control_group= FND_API.g_miss_char THEN
2122: x_complete_rec.incl_control_group:= l_action_rec.incl_control_group;
2123: END IF;
2124: IF p_action_rec.no_of_rows_targeted = FND_API.g_miss_num THEN
2125: x_complete_rec.no_of_rows_targeted := l_action_rec.no_of_rows_targeted;

Line 2124: IF p_action_rec.no_of_rows_targeted = FND_API.g_miss_num THEN

2120:
2121: IF p_action_rec.incl_control_group= FND_API.g_miss_char THEN
2122: x_complete_rec.incl_control_group:= l_action_rec.incl_control_group;
2123: END IF;
2124: IF p_action_rec.no_of_rows_targeted = FND_API.g_miss_num THEN
2125: x_complete_rec.no_of_rows_targeted := l_action_rec.no_of_rows_targeted;
2126: END IF;
2127:
2128: