APPS.WIP_VALIDATE_RES dependencies on FND_API

Line 17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

13: , p_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
14: , p_old_Res_rec IN WIP_Transaction_PUB.Res_Rec_Type
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: l_dummy VARCHAR2(10) := NULL;
19: BEGIN
20:
21: IF nvl(p_validation_level,WIP_Transaction_PVT.COMPLETE) = WIP_Transaction_PVT.NONE then

Line 30: l_return_status := FND_API.G_RET_STS_ERROR;

26: -- Check required Resource/OSP attributes.
27:
28: IF p_Res_rec.acct_period_id IS NULL
29: THEN
30: l_return_status := FND_API.G_RET_STS_ERROR;
31:
32: WIP_Globals.Add_Error_Message(
33: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
34: p_token1_name => 'ATTRIBUTE',

Line 40: l_return_status := FND_API.G_RET_STS_ERROR;

36: END IF;
37:
38: IF p_Res_rec.autocharge_type IS NULL
39: THEN
40: l_return_status := FND_API.G_RET_STS_ERROR;
41:
42: WIP_Globals.Add_Error_Message(
43: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
44: p_token1_name => 'ATTRIBUTE',

Line 50: l_return_status := FND_API.G_RET_STS_ERROR;

46: END IF;
47:
48: IF p_Res_rec.basis_type IS NULL
49: THEN
50: l_return_status := FND_API.G_RET_STS_ERROR;
51:
52: WIP_Globals.Add_Error_Message(
53: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
54: p_token1_name => 'ATTRIBUTE',

Line 60: l_return_status := FND_API.G_RET_STS_ERROR;

56: END IF;
57:
58: IF p_Res_rec.department_code IS NULL
59: THEN
60: l_return_status := FND_API.G_RET_STS_ERROR;
61:
62: WIP_Globals.Add_Error_Message(
63: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
64: p_token1_name => 'ATTRIBUTE',

Line 70: l_return_status := FND_API.G_RET_STS_ERROR;

66: END IF;
67:
68: IF p_Res_rec.department_id IS NULL
69: THEN
70: l_return_status := FND_API.G_RET_STS_ERROR;
71:
72: WIP_Globals.Add_Error_Message(
73: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
74: p_token1_name => 'ATTRIBUTE',

Line 80: l_return_status := FND_API.G_RET_STS_ERROR;

76: END IF;
77:
78: IF p_Res_rec.entity_type IS NULL
79: THEN
80: l_return_status := FND_API.G_RET_STS_ERROR;
81:
82: WIP_Globals.Add_Error_Message(
83: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
84: p_token1_name => 'ATTRIBUTE',

Line 90: l_return_status := FND_API.G_RET_STS_ERROR;

86: END IF;
87:
88: IF p_Res_rec.last_updated_by_name IS NULL
89: THEN
90: l_return_status := FND_API.G_RET_STS_ERROR;
91:
92: WIP_Globals.Add_Error_Message(
93: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
94: p_token1_name => 'ATTRIBUTE',

Line 100: l_return_status := FND_API.G_RET_STS_ERROR;

96: END IF;
97:
98: IF p_Res_rec.operation_seq_num IS NULL
99: THEN
100: l_return_status := FND_API.G_RET_STS_ERROR;
101:
102: WIP_Globals.Add_Error_Message(
103: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
104: p_token1_name => 'ATTRIBUTE',

Line 110: l_return_status := FND_API.G_RET_STS_ERROR;

106: END IF;
107:
108: IF p_Res_rec.organization_code IS NULL
109: THEN
110: l_return_status := FND_API.G_RET_STS_ERROR;
111:
112: WIP_Globals.Add_Error_Message(
113: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
114: p_token1_name => 'ATTRIBUTE',

Line 120: l_return_status := FND_API.G_RET_STS_ERROR;

116: END IF;
117:
118: IF p_Res_rec.organization_id IS NULL
119: THEN
120: l_return_status := FND_API.G_RET_STS_ERROR;
121:
122: WIP_Globals.Add_Error_Message(
123: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
124: p_token1_name => 'ATTRIBUTE',

Line 130: l_return_status := FND_API.G_RET_STS_ERROR;

126: END IF;
127:
128: IF p_Res_rec.primary_item_id IS NULL
129: THEN
130: l_return_status := FND_API.G_RET_STS_ERROR;
131:
132: WIP_Globals.Add_Error_Message(
133: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
134: p_token1_name => 'ATTRIBUTE',

Line 140: l_return_status := FND_API.G_RET_STS_ERROR;

136: END IF;
137:
138: IF p_Res_rec.primary_quantity IS NULL
139: THEN
140: l_return_status := FND_API.G_RET_STS_ERROR;
141:
142: WIP_Globals.Add_Error_Message(
143: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
144: p_token1_name => 'ATTRIBUTE',

Line 150: l_return_status := FND_API.G_RET_STS_ERROR;

146: END IF;
147:
148: IF p_Res_rec.primary_uom IS NULL
149: THEN
150: l_return_status := FND_API.G_RET_STS_ERROR;
151:
152: WIP_Globals.Add_Error_Message(
153: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
154: p_token1_name => 'ATTRIBUTE',

Line 160: l_return_status := FND_API.G_RET_STS_ERROR;

156: END IF;
157:
158: IF p_Res_rec.process_phase IS NULL
159: THEN
160: l_return_status := FND_API.G_RET_STS_ERROR;
161:
162: WIP_Globals.Add_Error_Message(
163: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
164: p_token1_name => 'ATTRIBUTE',

Line 170: l_return_status := FND_API.G_RET_STS_ERROR;

166: END IF;
167:
168: IF p_Res_rec.process_status IS NULL
169: THEN
170: l_return_status := FND_API.G_RET_STS_ERROR;
171:
172: WIP_Globals.Add_Error_Message(
173: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
174: p_token1_name => 'ATTRIBUTE',

Line 180: l_return_status := FND_API.G_RET_STS_ERROR;

176: END IF;
177:
178: IF p_Res_rec.resource_code IS NULL
179: THEN
180: l_return_status := FND_API.G_RET_STS_ERROR;
181:
182: WIP_Globals.Add_Error_Message(
183: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
184: p_token1_name => 'ATTRIBUTE',

Line 190: l_return_status := FND_API.G_RET_STS_ERROR;

186: END IF;
187:
188: IF p_Res_rec.resource_id IS NULL
189: THEN
190: l_return_status := FND_API.G_RET_STS_ERROR;
191:
192: WIP_Globals.Add_Error_Message(
193: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
194: p_token1_name => 'ATTRIBUTE',

Line 200: l_return_status := FND_API.G_RET_STS_ERROR;

196: END IF;
197:
198: IF p_Res_rec.resource_seq_num IS NULL
199: THEN
200: l_return_status := FND_API.G_RET_STS_ERROR;
201:
202: WIP_Globals.Add_Error_Message(
203: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
204: p_token1_name => 'ATTRIBUTE',

Line 210: l_return_status := FND_API.G_RET_STS_ERROR;

206: END IF;
207:
208: IF p_Res_rec.standard_rate_flag IS NULL
209: THEN
210: l_return_status := FND_API.G_RET_STS_ERROR;
211:
212: WIP_Globals.Add_Error_Message(
213: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
214: p_token1_name => 'ATTRIBUTE',

Line 220: l_return_status := FND_API.G_RET_STS_ERROR;

216: END IF;
217:
218: IF p_Res_rec.transaction_date IS NULL
219: THEN
220: l_return_status := FND_API.G_RET_STS_ERROR;
221:
222: WIP_Globals.Add_Error_Message(
223: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
224: p_token1_name => 'ATTRIBUTE',

Line 230: l_return_status := FND_API.G_RET_STS_ERROR;

226: END IF;
227:
228: IF p_Res_rec.transaction_quantity IS NULL
229: THEN
230: l_return_status := FND_API.G_RET_STS_ERROR;
231:
232: WIP_Globals.Add_Error_Message(
233: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
234: p_token1_name => 'ATTRIBUTE',

Line 240: l_return_status := FND_API.G_RET_STS_ERROR;

236: END IF;
237:
238: IF p_Res_rec.transaction_type IS NULL
239: THEN
240: l_return_status := FND_API.G_RET_STS_ERROR;
241:
242: WIP_Globals.Add_Error_Message(
243: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
244: p_token1_name => 'ATTRIBUTE',

Line 250: l_return_status := FND_API.G_RET_STS_ERROR;

246: END IF;
247:
248: IF p_Res_rec.usage_rate_or_amount IS NULL
249: THEN
250: l_return_status := FND_API.G_RET_STS_ERROR;
251:
252: WIP_Globals.Add_Error_Message(
253: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
254: p_token1_name => 'ATTRIBUTE',

Line 260: l_return_status := FND_API.G_RET_STS_ERROR;

256: END IF;
257:
258: IF p_Res_rec.wip_entity_id IS NULL
259: THEN
260: l_return_status := FND_API.G_RET_STS_ERROR;
261:
262: WIP_Globals.Add_Error_Message(
263: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
264: p_token1_name => 'ATTRIBUTE',

Line 270: l_return_status := FND_API.G_RET_STS_ERROR;

266: END IF;
267:
268: IF p_Res_rec.wip_entity_name IS NULL
269: THEN
270: l_return_status := FND_API.G_RET_STS_ERROR;
271:
272: WIP_Globals.Add_Error_Message(
273: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
274: p_token1_name => 'ATTRIBUTE',

Line 293: l_return_status := FND_API.G_RET_STS_ERROR;

289:
290: IF p_Res_rec.repetitive_schedule_id IS NOT NULL
291: AND p_Res_rec.line_id IS NULL
292: THEN
293: l_return_status := FND_API.G_RET_STS_ERROR;
294:
295: WIP_Globals.Add_Error_Message(
296: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
297: p_token1_name => 'ATTRIBUTE',

Line 305: l_return_status := FND_API.G_RET_STS_ERROR;

301:
302: IF p_Res_rec.repetitive_schedule_id IS NOT NULL
303: AND p_Res_rec.line_code IS NULL
304: THEN
305: l_return_status := FND_API.G_RET_STS_ERROR;
306:
307: WIP_Globals.Add_Error_Message(
308: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
309: p_token1_name => 'ATTRIBUTE',

Line 326: l_return_status := FND_API.G_RET_STS_ERROR;

322: AND mp.project_reference_enabled = 1
323: AND mp.project_control_level = 2;
324: EXCEPTION
325: WHEN OTHERS THEN
326: l_return_status := FND_API.G_RET_STS_ERROR;
327:
328: WIP_Globals.Add_Error_Message(
329: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
330: p_token1_name => 'ATTRIBUTE',

Line 338: l_return_status := FND_API.G_RET_STS_ERROR;

334:
335: IF p_Res_rec.activity_id IS NOT NULL
336: AND p_Res_rec.activity_name IS NULL
337: THEN
338: l_return_status := FND_API.G_RET_STS_ERROR;
339:
340: WIP_Globals.Add_Error_Message(
341: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
342: p_token1_name => 'ATTRIBUTE',

Line 352: l_return_status := FND_API.G_RET_STS_ERROR;

348: IF p_Res_rec.transaction_type = WIP_CONSTANTS.OSP_TXN then
349:
350: IF p_Res_rec.po_header_id IS NULL
351: THEN
352: l_return_status := FND_API.G_RET_STS_ERROR;
353:
354: WIP_Globals.Add_Error_Message(
355: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
356: p_token1_name => 'ATTRIBUTE',

Line 363: l_return_status := FND_API.G_RET_STS_ERROR;

359:
360:
361: IF p_Res_rec.po_line_id IS NULL
362: THEN
363: l_return_status := FND_API.G_RET_STS_ERROR;
364:
365: WIP_Globals.Add_Error_Message(
366: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
367: p_token1_name => 'ATTRIBUTE',

Line 374: l_return_status := FND_API.G_RET_STS_ERROR;

370:
371:
372: IF p_Res_rec.rcv_transaction_id IS NULL
373: THEN
374: l_return_status := FND_API.G_RET_STS_ERROR;
375:
376: WIP_Globals.Add_Error_Message(
377: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
378: p_token1_name => 'ATTRIBUTE',

Line 384: l_return_status := FND_API.G_RET_STS_ERROR;

380: END IF;
381:
382: IF p_Res_rec.source_code IS NULL
383: THEN
384: l_return_status := FND_API.G_RET_STS_ERROR;
385:
386: WIP_Globals.Add_Error_Message(
387: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
388: p_token1_name => 'ATTRIBUTE',

Line 394: l_return_status := FND_API.G_RET_STS_ERROR;

390: END IF;
391:
392: IF p_Res_rec.source_line_id IS NULL
393: THEN
394: l_return_status := FND_API.G_RET_STS_ERROR;
395:
396: WIP_Globals.Add_Error_Message(
397: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
398: p_token1_name => 'ATTRIBUTE',

Line 405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

401:
402: END IF;
403: -- Return Error if a required attribute is missing.
404:
405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
406: RAISE FND_API.G_EXC_ERROR;
407: END IF;
408:
409: -- Do any other specific entity validations here.

Line 406: RAISE FND_API.G_EXC_ERROR;

402: END IF;
403: -- Return Error if a required attribute is missing.
404:
405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
406: RAISE FND_API.G_EXC_ERROR;
407: END IF;
408:
409: -- Do any other specific entity validations here.
410:

Line 417: WHEN FND_API.G_EXC_ERROR THEN

413: x_return_status := l_return_status;
414:
415: EXCEPTION
416:
417: WHEN FND_API.G_EXC_ERROR THEN
418:
419: x_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: EXCEPTION
416:
417: WHEN FND_API.G_EXC_ERROR THEN
418:
419: x_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

417: WHEN FND_API.G_EXC_ERROR THEN
418:
419: x_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424:
425: WHEN OTHERS THEN

Line 423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

419: x_return_status := FND_API.G_RET_STS_ERROR;
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424:
425: WHEN OTHERS THEN
426:
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424:
425: WHEN OTHERS THEN
426:
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428:
429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg

Line 450: x_return_status := FND_API.G_RET_STS_SUCCESS;

446: )
447: IS
448: BEGIN
449:
450: x_return_status := FND_API.G_RET_STS_SUCCESS;
451:
452: IF nvl(p_validation_level,WIP_Transaction_PVT.COMPLETE) = WIP_Transaction_PVT.NONE then
453: return;
454: END IF;

Line 465: x_return_status := FND_API.G_RET_STS_ERROR;

461: p_old_Res_rec.acct_period_id IS NULL )
462: THEN
463: IF NOT WIP_Validate.Acct_Period(p_Res_rec.acct_period_id,
464: p_Res_rec.organization_id) THEN
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: END IF;
467: END IF;
468:
469: IF p_Res_rec.activity_id IS NOT NULL AND

Line 475: x_return_status := FND_API.G_RET_STS_ERROR;

471: p_old_Res_rec.activity_id OR
472: p_old_Res_rec.activity_id IS NULL )
473: THEN
474: IF NOT WIP_Validate.Activity(p_Res_rec.activity_id) THEN
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: END IF;
477: END IF;
478:
479: IF p_Res_rec.activity_name IS NOT NULL AND

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481: p_old_Res_rec.activity_name OR
482: p_old_Res_rec.activity_name IS NULL )
483: THEN
484: IF NOT WIP_Validate.Activity_Name(p_Res_rec.activity_name) THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: END IF;
487: END IF;
488:
489: IF p_Res_rec.actual_resource_rate IS NOT NULL AND

Line 495: x_return_status := FND_API.G_RET_STS_ERROR;

491: p_old_Res_rec.actual_resource_rate OR
492: p_old_Res_rec.actual_resource_rate IS NULL )
493: THEN
494: IF NOT WIP_Validate.Actual_Resource_Rate(p_Res_rec.actual_resource_rate) THEN
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: END IF;
497: END IF;
498:
499: IF p_Res_rec.autocharge_type IS NOT NULL AND

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

501: p_old_Res_rec.autocharge_type OR
502: p_old_Res_rec.autocharge_type IS NULL )
503: THEN
504: IF NOT WIP_Validate.Autocharge_Type(p_Res_rec.autocharge_type) THEN
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: END IF;
507: END IF;
508:
509: IF p_Res_rec.basis_type IS NOT NULL AND

Line 515: x_return_status := FND_API.G_RET_STS_ERROR;

511: p_old_Res_rec.basis_type OR
512: p_old_Res_rec.basis_type IS NULL )
513: THEN
514: IF NOT WIP_Validate.Basis_Type(p_Res_rec.basis_type) THEN
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: END IF;
517: END IF;
518:
519: IF p_Res_rec.completion_transaction_id IS NOT NULL AND

Line 525: x_return_status := FND_API.G_RET_STS_ERROR;

521: p_old_Res_rec.completion_transaction_id OR
522: p_old_Res_rec.completion_transaction_id IS NULL )
523: THEN
524: IF NOT WIP_Validate.Completion_Transaction(p_Res_rec.completion_transaction_id) THEN
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: END IF;
527: END IF;
528:
529: /*

Line 536: x_return_status := FND_API.G_RET_STS_ERROR;

532: p_old_Res_rec.created_by OR
533: p_old_Res_rec.created_by IS NULL )
534: THEN
535: IF NOT WIP_Validate.Created_By(p_Res_rec.created_by) THEN
536: x_return_status := FND_API.G_RET_STS_ERROR;
537: END IF;
538: END IF;
539: */
540:

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543: p_old_Res_rec.created_by_name OR
544: p_old_Res_rec.created_by_name IS NULL )
545: THEN
546: IF NOT WIP_Validate.Created_By_Name(p_Res_rec.created_by_name) THEN
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: END IF;
550:
551: /*

Line 558: x_return_status := FND_API.G_RET_STS_ERROR;

554: p_old_Res_rec.creation_date OR
555: p_old_Res_rec.creation_date IS NULL )
556: THEN
557: IF NOT WIP_Validate.Creation_Date(p_Res_rec.creation_date) THEN
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: END IF;
560: END IF;
561: */
562:

Line 569: x_return_status := FND_API.G_RET_STS_ERROR;

565: p_old_Res_rec.currency_actual_rsc_rate OR
566: p_old_Res_rec.currency_actual_rsc_rate IS NULL )
567: THEN
568: IF NOT WIP_Validate.Currency_Actual_Rsc_Rate(p_Res_rec.currency_actual_rsc_rate) THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: END IF;
571: END IF;
572:
573: IF p_Res_rec.currency_code IS NOT NULL AND

Line 579: x_return_status := FND_API.G_RET_STS_ERROR;

575: p_old_Res_rec.currency_code OR
576: p_old_Res_rec.currency_code IS NULL )
577: THEN
578: IF NOT WIP_Validate.Currency(p_Res_rec.currency_code) THEN
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: END IF;
581: END IF;
582:
583: IF p_Res_rec.currency_conversion_date IS NOT NULL AND

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: p_old_Res_rec.currency_conversion_date OR
586: p_old_Res_rec.currency_conversion_date IS NULL )
587: THEN
588: IF NOT WIP_Validate.Currency_Conversion_Date(p_Res_rec.currency_conversion_date) THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: END IF;
591: END IF;
592:
593: IF p_Res_rec.currency_conversion_rate IS NOT NULL AND

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595: p_old_Res_rec.currency_conversion_rate OR
596: p_old_Res_rec.currency_conversion_rate IS NULL )
597: THEN
598: IF NOT WIP_Validate.Currency_Conversion_Rate(p_Res_rec.currency_conversion_rate) THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601: END IF;
602:
603: IF p_Res_rec.currency_conversion_type IS NOT NULL AND

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: p_old_Res_rec.currency_conversion_type OR
606: p_old_Res_rec.currency_conversion_type IS NULL )
607: THEN
608: IF NOT WIP_Validate.Currency_Conversion_Type(p_Res_rec.currency_conversion_type) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: END IF;
611: END IF;
612:
613: IF p_Res_rec.department_code IS NOT NULL AND

Line 619: x_return_status := FND_API.G_RET_STS_ERROR;

615: p_old_Res_rec.department_code OR
616: p_old_Res_rec.department_code IS NULL )
617: THEN
618: IF NOT WIP_Validate.Department_Code(p_Res_rec.department_code, p_Res_rec.organization_id) THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: END IF;
621: END IF;
622:
623: IF p_Res_rec.department_id IS NOT NULL AND

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: p_old_Res_rec.department_id OR
626: p_old_Res_rec.department_id IS NULL )
627: THEN
628: IF NOT WIP_Validate.Department_Id(p_Res_rec.department_id, p_Res_rec.organization_id) THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: END IF;
631: END IF;
632:
633: IF p_Res_rec.employee_id IS NOT NULL AND

Line 639: x_return_status := FND_API.G_RET_STS_ERROR;

635: p_old_Res_rec.employee_id OR
636: p_old_Res_rec.employee_id IS NULL )
637: THEN
638: IF NOT WIP_Validate.Employee(p_Res_rec.employee_id) THEN
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: END IF;
641: END IF;
642:
643: IF p_Res_rec.employee_num IS NOT NULL AND

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: p_old_Res_rec.employee_num OR
646: p_old_Res_rec.employee_num IS NULL )
647: THEN
648: IF NOT WIP_Validate.Employee_Num(p_Res_rec.employee_num) THEN
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: END IF;
651: END IF;
652:
653: IF p_Res_rec.entity_type IS NOT NULL AND

Line 659: x_return_status := FND_API.G_RET_STS_ERROR;

655: p_old_Res_rec.entity_type OR
656: p_old_Res_rec.entity_type IS NULL )
657: THEN
658: IF NOT WIP_Validate.Entity_Type(p_Res_rec.entity_type) THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: END IF;
661: END IF;
662:
663: IF p_Res_rec.group_id IS NOT NULL AND

Line 669: x_return_status := FND_API.G_RET_STS_ERROR;

665: p_old_Res_rec.group_id OR
666: p_old_Res_rec.group_id IS NULL )
667: THEN
668: IF NOT WIP_Validate.Group_Id(p_Res_rec.group_id) THEN
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: END IF;
671: END IF;
672:
673: /*

Line 680: x_return_status := FND_API.G_RET_STS_ERROR;

676: p_old_Res_rec.last_updated_by OR
677: p_old_Res_rec.last_updated_by IS NULL )
678: THEN
679: IF NOT WIP_Validate.Last_Updated_By(p_Res_rec.last_updated_by) THEN
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: END IF;
682: END IF;
683: */
684:

Line 691: x_return_status := FND_API.G_RET_STS_ERROR;

687: p_old_Res_rec.last_updated_by_name OR
688: p_old_Res_rec.last_updated_by_name IS NULL )
689: THEN
690: IF NOT WIP_Validate.Last_Updated_By_Name(p_Res_rec.last_updated_by_name) THEN
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: END IF;
693: END IF;
694:
695: /*

Line 702: x_return_status := FND_API.G_RET_STS_ERROR;

698: p_old_Res_rec.last_update_date OR
699: p_old_Res_rec.last_update_date IS NULL )
700: THEN
701: IF NOT WIP_Validate.Last_Update_Date(p_Res_rec.last_update_date) THEN
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: END IF;
704: END IF;
705:
706: IF p_Res_rec.last_update_login IS NOT NULL AND

Line 712: x_return_status := FND_API.G_RET_STS_ERROR;

708: p_old_Res_rec.last_update_login OR
709: p_old_Res_rec.last_update_login IS NULL )
710: THEN
711: IF NOT WIP_Validate.Last_Update_Login(p_Res_rec.last_update_login) THEN
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: END IF;
714: END IF;
715: */
716:

Line 723: x_return_status := FND_API.G_RET_STS_ERROR;

719: p_old_Res_rec.line_code OR
720: p_old_Res_rec.line_code IS NULL )
721: THEN
722: IF NOT WIP_Validate.Line(p_Res_rec.line_code) THEN
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: END IF;
725: END IF;
726:
727: IF p_Res_rec.line_id IS NOT NULL AND

Line 733: x_return_status := FND_API.G_RET_STS_ERROR;

729: p_old_Res_rec.line_id OR
730: p_old_Res_rec.line_id IS NULL )
731: THEN
732: IF NOT WIP_Validate.Line(p_Res_rec.line_id) THEN
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: END IF;
735: END IF;
736:
737: IF p_Res_rec.move_transaction_id IS NOT NULL AND

Line 743: x_return_status := FND_API.G_RET_STS_ERROR;

739: p_old_Res_rec.move_transaction_id OR
740: p_old_Res_rec.move_transaction_id IS NULL )
741: THEN
742: IF NOT WIP_Validate.Move_Transaction(p_Res_rec.move_transaction_id) THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: END IF;
745: END IF;
746:
747: IF p_Res_rec.operation_seq_num IS NOT NULL AND

Line 753: x_return_status := FND_API.G_RET_STS_ERROR;

749: p_old_Res_rec.operation_seq_num OR
750: p_old_Res_rec.operation_seq_num IS NULL )
751: THEN
752: IF NOT WIP_Validate.Operation_Seq_Num(p_Res_rec.operation_seq_num) THEN
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: END IF;
755: END IF;
756:
757: IF p_Res_rec.organization_code IS NOT NULL AND

Line 763: x_return_status := FND_API.G_RET_STS_ERROR;

759: p_old_Res_rec.organization_code OR
760: p_old_Res_rec.organization_code IS NULL )
761: THEN
762: IF NOT WIP_Validate.Organization(p_Res_rec.organization_id) THEN
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: END IF;
765: END IF;
766:
767: IF p_Res_rec.organization_id IS NOT NULL AND

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769: p_old_Res_rec.organization_id OR
770: p_old_Res_rec.organization_id IS NULL )
771: THEN
772: IF NOT WIP_Validate.Organization(p_Res_rec.organization_id) THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: END IF;
775: END IF;
776:
777: IF p_Res_rec.po_header_id IS NOT NULL AND

Line 783: x_return_status := FND_API.G_RET_STS_ERROR;

779: p_old_Res_rec.po_header_id OR
780: p_old_Res_rec.po_header_id IS NULL )
781: THEN
782: IF NOT WIP_Validate.Po_Header(p_Res_rec.po_header_id) THEN
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: END IF;
785: END IF;
786:
787: IF p_Res_rec.po_line_id IS NOT NULL AND

Line 793: x_return_status := FND_API.G_RET_STS_ERROR;

789: p_old_Res_rec.po_line_id OR
790: p_old_Res_rec.po_line_id IS NULL )
791: THEN
792: IF NOT WIP_Validate.Po_Line(p_Res_rec.po_line_id) THEN
793: x_return_status := FND_API.G_RET_STS_ERROR;
794: END IF;
795: END IF;
796:
797: IF p_Res_rec.primary_item_id IS NOT NULL AND

Line 804: x_return_status := FND_API.G_RET_STS_ERROR;

800: p_old_Res_rec.primary_item_id IS NULL )
801: THEN
802: IF NOT WIP_Validate.Primary_Item(p_Res_rec.primary_item_id,
803: p_Res_rec.organization_id) THEN
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: END IF;
806: END IF;
807:
808: IF p_Res_rec.primary_quantity IS NOT NULL AND

Line 814: x_return_status := FND_API.G_RET_STS_ERROR;

810: p_old_Res_rec.primary_quantity OR
811: p_old_Res_rec.primary_quantity IS NULL )
812: THEN
813: IF NOT WIP_Validate.Primary_Quantity(p_Res_rec.primary_quantity) THEN
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;
816: END IF;
817:
818: IF p_Res_rec.primary_uom IS NOT NULL AND

Line 824: x_return_status := FND_API.G_RET_STS_ERROR;

820: p_old_Res_rec.primary_uom OR
821: p_old_Res_rec.primary_uom IS NULL )
822: THEN
823: IF NOT WIP_Validate.Primary_Uom(p_Res_rec.primary_uom) THEN
824: x_return_status := FND_API.G_RET_STS_ERROR;
825: END IF;
826: END IF;
827:
828: IF p_Res_rec.primary_uom_class IS NOT NULL AND

Line 834: x_return_status := FND_API.G_RET_STS_ERROR;

830: p_old_Res_rec.primary_uom_class OR
831: p_old_Res_rec.primary_uom_class IS NULL )
832: THEN
833: IF NOT WIP_Validate.Primary_Uom_Class(p_Res_rec.primary_uom_class) THEN
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: END IF;
836: END IF;
837:
838: IF p_Res_rec.process_phase IS NOT NULL AND

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

840: p_old_Res_rec.process_phase OR
841: p_old_Res_rec.process_phase IS NULL )
842: THEN
843: IF NOT WIP_Validate.Process_Phase(p_Res_rec.process_phase, 'WIP_RESOURCE_PROCESS_PHASE') THEN
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: END IF;
846: END IF;
847:
848: IF p_Res_rec.process_status IS NOT NULL AND

Line 854: x_return_status := FND_API.G_RET_STS_ERROR;

850: p_old_Res_rec.process_status OR
851: p_old_Res_rec.process_status IS NULL )
852: THEN
853: IF NOT WIP_Validate.Process_Status(p_Res_rec.process_status) THEN
854: x_return_status := FND_API.G_RET_STS_ERROR;
855: END IF;
856: END IF;
857:
858: /*

Line 865: x_return_status := FND_API.G_RET_STS_ERROR;

861: p_old_Res_rec.program_application_id OR
862: p_old_Res_rec.program_application_id IS NULL )
863: THEN
864: IF NOT WIP_Validate.Program_Application(p_Res_rec.program_application_id) THEN
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: END IF;
867: END IF;
868:
869: IF p_Res_rec.program_id IS NOT NULL AND

Line 875: x_return_status := FND_API.G_RET_STS_ERROR;

871: p_old_Res_rec.program_id OR
872: p_old_Res_rec.program_id IS NULL )
873: THEN
874: IF NOT WIP_Validate.Program(p_Res_rec.program_id) THEN
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END IF;
877: END IF;
878:
879: IF p_Res_rec.program_update_date IS NOT NULL AND

Line 885: x_return_status := FND_API.G_RET_STS_ERROR;

881: p_old_Res_rec.program_update_date OR
882: p_old_Res_rec.program_update_date IS NULL )
883: THEN
884: IF NOT WIP_Validate.Program_Update_Date(p_Res_rec.program_update_date) THEN
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: END IF;
887: END IF;
888: */
889:

Line 897: x_return_status := FND_API.G_RET_STS_ERROR;

893: p_old_Res_rec.project_id IS NULL )
894: THEN
895: IF NOT WIP_Validate.Project(p_Res_rec.project_id,
896: p_Res_rec.organization_id) THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: END IF;
899: END IF;
900:
901: IF p_Res_rec.rcv_transaction_id IS NOT NULL AND

Line 911: x_return_status := FND_API.G_RET_STS_ERROR;

907: --validate against the rcv_transactions_interface table and thus
908: --need to pass the interface_transaction_id...source line id should
909: --always be populated if rcv_transaction_id is populated
910: IF NOT WIP_Validate.Rcv_Transaction(p_Res_rec.source_line_id) THEN
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: END IF;
913: END IF;
914:
915: IF p_Res_rec.reason_id IS NOT NULL AND

Line 921: x_return_status := FND_API.G_RET_STS_ERROR;

917: p_old_Res_rec.reason_id OR
918: p_old_Res_rec.reason_id IS NULL )
919: THEN
920: IF NOT WIP_Validate.Reason(p_Res_rec.reason_id) THEN
921: x_return_status := FND_API.G_RET_STS_ERROR;
922: END IF;
923: END IF;
924:
925: IF p_Res_rec.reason_name IS NOT NULL AND

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: p_old_Res_rec.reason_name OR
928: p_old_Res_rec.reason_name IS NULL )
929: THEN
930: IF NOT WIP_Validate.Reason_Name(p_Res_rec.reason_name) THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: END IF;
933: END IF;
934:
935: IF p_Res_rec.receiving_account_id IS NOT NULL AND

Line 941: x_return_status := FND_API.G_RET_STS_ERROR;

937: p_old_Res_rec.receiving_account_id OR
938: p_old_Res_rec.receiving_account_id IS NULL )
939: THEN
940: IF NOT WIP_Validate.Receiving_Account(p_Res_rec.receiving_account_id) THEN
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: END IF;
943: END IF;
944:
945: IF p_Res_rec.reference IS NOT NULL AND

Line 951: x_return_status := FND_API.G_RET_STS_ERROR;

947: p_old_Res_rec.reference OR
948: p_old_Res_rec.reference IS NULL )
949: THEN
950: IF NOT WIP_Validate.Reference(p_Res_rec.reference) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: END IF;
953: END IF;
954:
955: IF p_Res_rec.repetitive_schedule_id IS NOT NULL AND

Line 961: x_return_status := FND_API.G_RET_STS_ERROR;

957: p_old_Res_rec.repetitive_schedule_id OR
958: p_old_Res_rec.repetitive_schedule_id IS NULL )
959: THEN
960: IF NOT WIP_Validate.Repetitive_Schedule(p_Res_rec.repetitive_schedule_id) THEN
961: x_return_status := FND_API.G_RET_STS_ERROR;
962: END IF;
963: END IF;
964:
965: /*

Line 972: x_return_status := FND_API.G_RET_STS_ERROR;

968: p_old_Res_rec.request_id OR
969: p_old_Res_rec.request_id IS NULL )
970: THEN
971: IF NOT WIP_Validate.Request(p_Res_rec.request_id) THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: END IF;
974: END IF;
975: */
976:

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979: p_old_Res_rec.resource_code OR
980: p_old_Res_rec.resource_code IS NULL )
981: THEN
982: IF NOT WIP_Validate.Resource_Code(p_Res_rec.resource_code, p_Res_rec.organization_id) THEN
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: END IF;
985: END IF;
986:
987: IF p_Res_rec.resource_id IS NOT NULL AND

Line 993: x_return_status := FND_API.G_RET_STS_ERROR;

989: p_old_Res_rec.resource_id OR
990: p_old_Res_rec.resource_id IS NULL )
991: THEN
992: IF NOT WIP_Validate.Resource_Id(p_Res_rec.resource_id) THEN
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: END IF;
995: END IF;
996:
997: IF p_Res_rec.resource_seq_num IS NOT NULL AND

Line 1003: x_return_status := FND_API.G_RET_STS_ERROR;

999: p_old_Res_rec.resource_seq_num OR
1000: p_old_Res_rec.resource_seq_num IS NULL )
1001: THEN
1002: IF NOT WIP_Validate.Resource_Seq_Num(p_Res_rec.resource_seq_num) THEN
1003: x_return_status := FND_API.G_RET_STS_ERROR;
1004: END IF;
1005: END IF;
1006:
1007: IF p_Res_rec.resource_type IS NOT NULL AND

Line 1013: x_return_status := FND_API.G_RET_STS_ERROR;

1009: p_old_Res_rec.resource_type OR
1010: p_old_Res_rec.resource_type IS NULL )
1011: THEN
1012: IF NOT WIP_Validate.Resource_Type(p_Res_rec.resource_type) THEN
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: END IF;
1015: END IF;
1016:
1017: /*

Line 1024: x_return_status := FND_API.G_RET_STS_ERROR;

1020: p_old_Res_rec.source_code OR
1021: p_old_Res_rec.source_code IS NULL )
1022: THEN
1023: IF NOT WIP_Validate.Source(p_Res_rec.source_code) THEN
1024: x_return_status := FND_API.G_RET_STS_ERROR;
1025: END IF;
1026: END IF;
1027:
1028: IF p_Res_rec.source_line_id IS NOT NULL AND

Line 1034: x_return_status := FND_API.G_RET_STS_ERROR;

1030: p_old_Res_rec.source_line_id OR
1031: p_old_Res_rec.source_line_id IS NULL )
1032: THEN
1033: IF NOT WIP_Validate.Source_Line(p_Res_rec.source_line_id) THEN
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END IF;
1036: END IF;
1037: */
1038: IF p_Res_rec.standard_rate_flag IS NOT NULL AND

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR;

1040: p_old_Res_rec.standard_rate_flag OR
1041: p_old_Res_rec.standard_rate_flag IS NULL )
1042: THEN
1043: IF NOT WIP_Validate.Standard_Rate(p_Res_rec.standard_rate_flag) THEN
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: END IF;
1046: END IF;
1047:
1048: IF p_Res_rec.task_id IS NOT NULL AND

Line 1056: x_return_status := FND_API.G_RET_STS_ERROR;

1052: THEN
1053: IF NOT WIP_Validate.Task(p_Res_rec.task_id,
1054: p_Res_rec.project_id,
1055: p_Res_rec.organization_id) THEN
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: END IF;
1058: END IF;
1059:
1060: /*

Line 1067: x_return_status := FND_API.G_RET_STS_ERROR;

1063: p_old_Res_rec.transaction_date OR
1064: p_old_Res_rec.transaction_date IS NULL )
1065: THEN
1066: IF NOT WIP_Validate.Transaction_Date(p_Res_rec.transaction_date) THEN
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;
1069: END IF;
1070: */
1071:

Line 1078: x_return_status := FND_API.G_RET_STS_ERROR;

1074: p_old_Res_rec.transaction_id OR
1075: p_old_Res_rec.transaction_id IS NULL )
1076: THEN
1077: IF NOT WIP_Validate.Transaction(p_Res_rec.transaction_id) THEN
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: END IF;
1080: END IF;
1081:
1082: /*

Line 1089: x_return_status := FND_API.G_RET_STS_ERROR;

1085: p_old_Res_rec.transaction_quantity OR
1086: p_old_Res_rec.transaction_quantity IS NULL )
1087: THEN
1088: IF NOT WIP_Validate.Transaction_Quantity(p_Res_rec.transaction_quantity) THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: END IF;
1091: END IF;
1092: */
1093:

Line 1100: x_return_status := FND_API.G_RET_STS_ERROR;

1096: p_old_Res_rec.transaction_type OR
1097: p_old_Res_rec.transaction_type IS NULL )
1098: THEN
1099: IF NOT WIP_Validate.Transaction_Type(p_Res_rec.transaction_type, 'WIP_TRANSACTION_TYPE' ) THEN
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: END IF;
1102: END IF;
1103:
1104: IF p_Res_rec.transaction_uom IS NOT NULL AND

Line 1110: x_return_status := FND_API.G_RET_STS_ERROR;

1106: p_old_Res_rec.transaction_uom OR
1107: p_old_Res_rec.transaction_uom IS NULL )
1108: THEN
1109: IF NOT WIP_Validate.Transaction_Uom(p_Res_rec.transaction_uom) THEN
1110: x_return_status := FND_API.G_RET_STS_ERROR;
1111: END IF;
1112: END IF;
1113:
1114: IF p_Res_rec.usage_rate_or_amount IS NOT NULL AND

Line 1120: x_return_status := FND_API.G_RET_STS_ERROR;

1116: p_old_Res_rec.usage_rate_or_amount OR
1117: p_old_Res_rec.usage_rate_or_amount IS NULL )
1118: THEN
1119: IF NOT WIP_Validate.Usage_Rate_Or_Amount(p_Res_rec.usage_rate_or_amount) THEN
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: END IF;
1122: END IF;
1123:
1124: IF p_Res_rec.wip_entity_id IS NOT NULL AND

Line 1130: x_return_status := FND_API.G_RET_STS_ERROR;

1126: p_old_Res_rec.wip_entity_id OR
1127: p_old_Res_rec.wip_entity_id IS NULL )
1128: THEN
1129: IF NOT WIP_Validate.Wip_Entity(p_Res_rec.wip_entity_id) THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: END IF;
1132: END IF;
1133:
1134: IF p_Res_rec.wip_entity_name IS NOT NULL AND

Line 1141: x_return_status := FND_API.G_RET_STS_ERROR;

1137: p_old_Res_rec.wip_entity_name IS NULL )
1138: THEN
1139: IF NOT WIP_Validate.Wip_Entity_Name(p_Res_rec.wip_entity_name,
1140: p_Res_rec.organization_id) THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: END IF;
1143: END IF;
1144:
1145: IF (p_Res_rec.attribute1 IS NOT NULL AND

Line 1282: x_return_status := FND_API.G_RET_STS_ERROR;

1278:
1279: -- Validate descriptive flexfield.
1280:
1281: IF NOT WIP_Validate.Desc_Flex( 'OSP' ) THEN
1282: x_return_status := FND_API.G_RET_STS_ERROR;
1283: END IF;
1284:
1285: */
1286: END IF;

Line 1292: WHEN FND_API.G_EXC_ERROR THEN

1288: -- Done validating attributes
1289:
1290: EXCEPTION
1291:
1292: WHEN FND_API.G_EXC_ERROR THEN
1293:
1294: x_return_status := FND_API.G_RET_STS_ERROR;
1295:
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1294: x_return_status := FND_API.G_RET_STS_ERROR;

1290: EXCEPTION
1291:
1292: WHEN FND_API.G_EXC_ERROR THEN
1293:
1294: x_return_status := FND_API.G_RET_STS_ERROR;
1295:
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297:
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1292: WHEN FND_API.G_EXC_ERROR THEN
1293:
1294: x_return_status := FND_API.G_RET_STS_ERROR;
1295:
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297:
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299:
1300: WHEN OTHERS THEN

Line 1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1294: x_return_status := FND_API.G_RET_STS_ERROR;
1295:
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297:
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299:
1300: WHEN OTHERS THEN
1301:
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299:
1300: WHEN OTHERS THEN
1301:
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1303:
1304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1305: THEN
1306: FND_MSG_PUB.Add_Exc_Msg