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

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

13: , p_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
14: , p_old_ShopFloorMove_rec IN WIP_Transaction_PUB.Shopfloormove_Rec_Type
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: BEGIN
19:
20: IF nvl(p_validation_level,WIP_Transaction_PVT.COMPLETE) = WIP_Transaction_PVT.NONE then
21: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 21: x_return_status := FND_API.G_RET_STS_SUCCESS;

17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: BEGIN
19:
20: IF nvl(p_validation_level,WIP_Transaction_PVT.COMPLETE) = WIP_Transaction_PVT.NONE then
21: x_return_status := FND_API.G_RET_STS_SUCCESS;
22: return;
23: END IF;
24:
25: -- Check required attributes.

Line 30: l_return_status := FND_API.G_RET_STS_ERROR;

26:
27: IF p_ShopFloorMove_rec.acct_period_id IS NULL
28: THEN
29:
30: l_return_status := FND_API.G_RET_STS_ERROR;
31:
32: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
33: THEN
34:

Line 46: l_return_status := FND_API.G_RET_STS_ERROR;

42:
43: IF p_ShopFloorMove_rec.created_by_name IS NULL
44: THEN
45:
46: l_return_status := FND_API.G_RET_STS_ERROR;
47:
48: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
49: THEN
50:

Line 62: l_return_status := FND_API.G_RET_STS_ERROR;

58:
59: IF p_ShopFloorMove_rec.entity_type IS NULL
60: THEN
61:
62: l_return_status := FND_API.G_RET_STS_ERROR;
63:
64: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
65: THEN
66:

Line 78: l_return_status := FND_API.G_RET_STS_ERROR;

74:
75: IF p_ShopFloorMove_rec.fm_department_code IS NULL
76: THEN
77:
78: l_return_status := FND_API.G_RET_STS_ERROR;
79:
80: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
81: THEN
82:

Line 94: l_return_status := FND_API.G_RET_STS_ERROR;

90:
91: IF p_ShopFloorMove_rec.fm_department_id IS NULL
92: THEN
93:
94: l_return_status := FND_API.G_RET_STS_ERROR;
95:
96: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
97: THEN
98:

Line 110: l_return_status := FND_API.G_RET_STS_ERROR;

106:
107: IF p_ShopFloorMove_rec.fm_intraop_step_type IS NULL
108: THEN
109:
110: l_return_status := FND_API.G_RET_STS_ERROR;
111:
112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
113: THEN
114:

Line 126: l_return_status := FND_API.G_RET_STS_ERROR;

122:
123: IF p_ShopFloorMove_rec.fm_operation_seq_num IS NULL
124: THEN
125:
126: l_return_status := FND_API.G_RET_STS_ERROR;
127:
128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
129: THEN
130:

Line 142: l_return_status := FND_API.G_RET_STS_ERROR;

138:
139: IF p_ShopFloorMove_rec.organization_code IS NULL
140: THEN
141:
142: l_return_status := FND_API.G_RET_STS_ERROR;
143:
144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
145: THEN
146:

Line 158: l_return_status := FND_API.G_RET_STS_ERROR;

154:
155: IF p_ShopFloorMove_rec.last_updated_by_name IS NULL
156: THEN
157:
158: l_return_status := FND_API.G_RET_STS_ERROR;
159:
160: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
161: THEN
162:

Line 173: l_return_status := FND_API.G_RET_STS_ERROR;

169: END IF;
170: IF p_ShopFloorMove_rec.organization_id IS NULL
171: THEN
172:
173: l_return_status := FND_API.G_RET_STS_ERROR;
174:
175: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
176: THEN
177:

Line 189: l_return_status := FND_API.G_RET_STS_ERROR;

185:
186: IF p_ShopFloorMove_rec.primary_item_id IS NULL
187: THEN
188:
189: l_return_status := FND_API.G_RET_STS_ERROR;
190:
191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
192: THEN
193:

Line 205: l_return_status := FND_API.G_RET_STS_ERROR;

201:
202: IF p_ShopFloorMove_rec.primary_quantity IS NULL
203: THEN
204:
205: l_return_status := FND_API.G_RET_STS_ERROR;
206:
207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
208: THEN
209:

Line 221: l_return_status := FND_API.G_RET_STS_ERROR;

217:
218: IF p_ShopFloorMove_rec.primary_uom IS NULL
219: THEN
220:
221: l_return_status := FND_API.G_RET_STS_ERROR;
222:
223: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
224: THEN
225:

Line 237: l_return_status := FND_API.G_RET_STS_ERROR;

233:
234: IF p_ShopFloorMove_rec.process_phase IS NULL
235: THEN
236:
237: l_return_status := FND_API.G_RET_STS_ERROR;
238:
239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
240: THEN
241:

Line 253: l_return_status := FND_API.G_RET_STS_ERROR;

249:
250: IF p_ShopFloorMove_rec.process_status IS NULL
251: THEN
252:
253: l_return_status := FND_API.G_RET_STS_ERROR;
254:
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
256: THEN
257:

Line 269: l_return_status := FND_API.G_RET_STS_ERROR;

265:
266: IF p_ShopFloorMove_rec.to_department_code IS NULL
267: THEN
268:
269: l_return_status := FND_API.G_RET_STS_ERROR;
270:
271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
272: THEN
273:

Line 285: l_return_status := FND_API.G_RET_STS_ERROR;

281:
282: IF p_ShopFloorMove_rec.to_department_id IS NULL
283: THEN
284:
285: l_return_status := FND_API.G_RET_STS_ERROR;
286:
287: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
288: THEN
289:

Line 301: l_return_status := FND_API.G_RET_STS_ERROR;

297:
298: IF p_ShopFloorMove_rec.to_intraop_step_type IS NULL
299: THEN
300:
301: l_return_status := FND_API.G_RET_STS_ERROR;
302:
303: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
304: THEN
305:

Line 317: l_return_status := FND_API.G_RET_STS_ERROR;

313:
314: IF p_ShopFloorMove_rec.to_operation_seq_num IS NULL
315: THEN
316:
317: l_return_status := FND_API.G_RET_STS_ERROR;
318:
319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
320: THEN
321:

Line 333: l_return_status := FND_API.G_RET_STS_ERROR;

329:
330: IF p_ShopFloorMove_rec.transaction_date IS NULL
331: THEN
332:
333: l_return_status := FND_API.G_RET_STS_ERROR;
334:
335: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
336: THEN
337:

Line 349: l_return_status := FND_API.G_RET_STS_ERROR;

345:
346: IF p_ShopFloorMove_rec.transaction_quantity IS NULL
347: THEN
348:
349: l_return_status := FND_API.G_RET_STS_ERROR;
350:
351: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
352: THEN
353:

Line 365: l_return_status := FND_API.G_RET_STS_ERROR;

361:
362: IF p_ShopFloorMove_rec.transaction_type IS NULL
363: THEN
364:
365: l_return_status := FND_API.G_RET_STS_ERROR;
366:
367: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
368: THEN
369:

Line 381: l_return_status := FND_API.G_RET_STS_ERROR;

377:
378: IF p_ShopFloorMove_rec.transaction_uom IS NULL
379: THEN
380:
381: l_return_status := FND_API.G_RET_STS_ERROR;
382:
383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
384: THEN
385:

Line 397: l_return_status := FND_API.G_RET_STS_ERROR;

393:
394: IF p_ShopFloorMove_rec.wip_entity_id IS NULL
395: THEN
396:
397: l_return_status := FND_API.G_RET_STS_ERROR;
398:
399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
400: THEN
401:

Line 413: l_return_status := FND_API.G_RET_STS_ERROR;

409:
410: IF p_ShopFloorMove_rec.wip_entity_name IS NULL
411: THEN
412:
413: l_return_status := FND_API.G_RET_STS_ERROR;
414:
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
416: THEN
417:

Line 440: l_return_status := FND_API.G_RET_STS_ERROR;

436: --
437: IF p_ShopFloorMove_rec.repetitive_schedule_id IS NOT NULL
438: AND p_ShopFloorMove_rec.line_id IS NULL
439: THEN
440: l_return_status := FND_API.G_RET_STS_ERROR;
441:
442: WIP_Globals.Add_Error_Message(
443: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
444: p_token1_name => 'ATTRIBUTE',

Line 452: l_return_status := FND_API.G_RET_STS_ERROR;

448:
449: IF p_ShopFloorMove_rec.repetitive_schedule_id IS NOT NULL
450: AND p_ShopFloorMove_rec.line_code IS NULL
451: THEN
452: l_return_status := FND_API.G_RET_STS_ERROR;
453:
454: WIP_Globals.Add_Error_Message(
455: p_message_name => 'WIP_ATTRIBUTE_REQUIRED',
456: p_token1_name => 'ATTRIBUTE',

Line 460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

456: p_token1_name => 'ATTRIBUTE',
457: p_token1_value => 'line_code');
458: END IF;
459:
460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
461:
462: RAISE FND_API.G_EXC_ERROR;
463:
464: END IF;

Line 462: RAISE FND_API.G_EXC_ERROR;

458: END IF;
459:
460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
461:
462: RAISE FND_API.G_EXC_ERROR;
463:
464: END IF;
465:
466:

Line 479: WHEN FND_API.G_EXC_ERROR THEN

475: x_return_status := l_return_status;
476:
477: EXCEPTION
478:
479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: x_return_status := FND_API.G_RET_STS_ERROR;
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 481: x_return_status := FND_API.G_RET_STS_ERROR;

477: EXCEPTION
478:
479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: x_return_status := FND_API.G_RET_STS_ERROR;
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484:
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: x_return_status := FND_API.G_RET_STS_ERROR;
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484:
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486:
487: WHEN OTHERS THEN

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

481: x_return_status := FND_API.G_RET_STS_ERROR;
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484:
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486:
487: WHEN OTHERS THEN
488:
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486:
487: WHEN OTHERS THEN
488:
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490:
491: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
492: THEN
493: FND_MSG_PUB.Add_Exc_Msg

Line 512: x_return_status := FND_API.G_RET_STS_SUCCESS;

508: )
509: IS
510: BEGIN
511:
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513:
514: IF nvl(p_validation_level,WIP_Transaction_PVT.COMPLETE) = WIP_Transaction_PVT.NONE then
515: return;
516: END IF;

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: p_old_ShopFloorMove_rec.acct_period_id IS NULL )
524: THEN
525: IF NOT WIP_Validate.Acct_Period(p_ShopFloorMove_rec.acct_period_id,
526: p_ShopFloorMove_rec.organization_id) THEN
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: END IF;
529: END IF;
530:
531: IF p_ShopFloorMove_rec.created_by_name IS NOT NULL AND

Line 537: x_return_status := FND_API.G_RET_STS_ERROR;

533: p_old_ShopFloorMove_rec.created_by_name OR
534: p_old_ShopFloorMove_rec.created_by_name IS NULL )
535: THEN
536: IF NOT WIP_Validate.Created_By_Name(p_ShopFloorMove_rec.created_by_name) THEN
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: END IF;
539: END IF;
540:
541: IF p_ShopFloorMove_rec.entity_type IS NOT NULL AND

Line 547: x_return_status := FND_API.G_RET_STS_ERROR;

543: p_old_ShopFloorMove_rec.entity_type OR
544: p_old_ShopFloorMove_rec.entity_type IS NULL )
545: THEN
546: IF NOT WIP_Validate.Entity_Type(p_ShopFloorMove_rec.entity_type) THEN
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: END IF;
549: END IF;
550:
551: IF p_ShopFloorMove_rec.fm_department_code IS NOT NULL AND

Line 559: x_return_status := FND_API.G_RET_STS_ERROR;

555: THEN
556: IF NOT WIP_Validate.Department_Code(p_ShopFloorMove_rec.fm_department_code,
557: p_ShopFloorMove_rec.organization_id,
558: 'fm_department_code') THEN
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END IF;
561: END IF;
562:
563: IF p_ShopFloorMove_rec.fm_department_id IS NOT NULL AND

Line 570: x_return_status := FND_API.G_RET_STS_ERROR;

566: p_old_ShopFloorMove_rec.fm_department_id IS NULL )
567: THEN
568: IF NOT WIP_Validate.Department_Id(p_ShopFloorMove_rec.fm_department_id,
569: 'fm_department_id') THEN
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: END IF;
572: END IF;
573:
574: IF p_ShopFloorMove_rec.fm_intraop_step_type IS NOT NULL AND

Line 581: x_return_status := FND_API.G_RET_STS_ERROR;

577: p_old_ShopFloorMove_rec.fm_intraop_step_type IS NULL )
578: THEN
579: IF NOT WIP_Validate.Intraop_Step_Type(p_ShopFloorMove_rec.fm_intraop_step_type,
580: 'fm_intraop_step_type') THEN
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: END IF;
583: END IF;
584:
585: IF p_ShopFloorMove_rec.fm_operation_code IS NOT NULL AND

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588: p_old_ShopFloorMove_rec.fm_operation_code IS NULL )
589: THEN
590: IF NOT WIP_Validate.Operation_Code(p_ShopFloorMove_rec.fm_operation_code,
591: 'fm_operation_code') THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: END IF;
594: END IF;
595:
596: IF p_ShopFloorMove_rec.fm_operation_seq_num IS NOT NULL AND

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599: p_old_ShopFloorMove_rec.fm_operation_seq_num IS NULL )
600: THEN
601: IF NOT WIP_Validate.Operation_Seq_Num(p_ShopFloorMove_rec.fm_operation_seq_num,
602: 'fm_operation_seq_num') THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: END IF;
605: END IF;
606:
607: IF p_ShopFloorMove_rec.kanban_card_id IS NOT NULL AND

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: p_old_ShopFloorMove_rec.kanban_card_id IS NULL )
611: THEN
612: IF NOT WIP_Validate.Kanban_Card(p_ShopFloorMove_rec.kanban_card_id,
613: p_ShopFloorMove_rec.organization_id) THEN
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616: END IF;
617:
618: IF p_ShopFloorMove_rec.last_updated_by_name IS NOT NULL AND

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620: p_old_ShopFloorMove_rec.last_updated_by_name OR
621: p_old_ShopFloorMove_rec.last_updated_by_name IS NULL )
622: THEN
623: IF NOT WIP_Validate.Last_Updated_By_Name(p_ShopFloorMove_rec.last_updated_by_name) THEN
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626: END IF;
627:
628: IF p_ShopFloorMove_rec.line_code IS NOT NULL AND

Line 634: x_return_status := FND_API.G_RET_STS_ERROR;

630: p_old_ShopFloorMove_rec.line_code OR
631: p_old_ShopFloorMove_rec.line_code IS NULL )
632: THEN
633: IF NOT WIP_Validate.Line(p_ShopFloorMove_rec.line_code) THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: END IF;
636: END IF;
637:
638: IF p_ShopFloorMove_rec.line_id IS NOT NULL AND

Line 644: x_return_status := FND_API.G_RET_STS_ERROR;

640: p_old_ShopFloorMove_rec.line_id OR
641: p_old_ShopFloorMove_rec.line_id IS NULL )
642: THEN
643: IF NOT WIP_Validate.Line(p_ShopFloorMove_rec.line_id) THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: END IF;
646: END IF;
647:
648: IF p_ShopFloorMove_rec.organization_code IS NOT NULL AND

Line 654: x_return_status := FND_API.G_RET_STS_ERROR;

650: p_old_ShopFloorMove_rec.organization_code OR
651: p_old_ShopFloorMove_rec.organization_code IS NULL )
652: THEN
653: IF NOT WIP_Validate.Organization(p_ShopFloorMove_rec.organization_id) THEN
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: END IF;
656: END IF;
657:
658: IF p_ShopFloorMove_rec.organization_id IS NOT NULL AND

Line 664: x_return_status := FND_API.G_RET_STS_ERROR;

660: p_old_ShopFloorMove_rec.organization_id OR
661: p_old_ShopFloorMove_rec.organization_id IS NULL )
662: THEN
663: IF NOT WIP_Validate.Organization(p_ShopFloorMove_rec.organization_id) THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: END IF;
666: END IF;
667:
668: IF p_ShopFloorMove_rec.primary_item_id IS NOT NULL AND

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671: p_old_ShopFloorMove_rec.primary_item_id IS NULL )
672: THEN
673: IF NOT WIP_Validate.Primary_Item(p_ShopFloorMove_rec.primary_item_id,
674: p_ShopFloorMove_rec.organization_id) THEN
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: END IF;
677: END IF;
678:
679: IF p_ShopFloorMove_rec.primary_uom IS NOT NULL AND

Line 685: x_return_status := FND_API.G_RET_STS_ERROR;

681: p_old_ShopFloorMove_rec.primary_uom OR
682: p_old_ShopFloorMove_rec.primary_uom IS NULL )
683: THEN
684: IF NOT WIP_Validate.Primary_Uom(p_ShopFloorMove_rec.primary_uom) THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: END IF;
687: END IF;
688:
689: IF p_ShopFloorMove_rec.process_phase IS NOT NULL AND

Line 696: x_return_status := FND_API.G_RET_STS_ERROR;

692: p_old_ShopFloorMove_rec.process_phase IS NULL )
693: THEN
694: IF NOT WIP_Validate.Process_Phase(p_ShopFloorMove_rec.process_phase,
695: 'WIP_MOVE_PROCESS_PHASE') THEN
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: END IF;
698: END IF;
699:
700: IF p_ShopFloorMove_rec.process_status IS NOT NULL AND

Line 706: x_return_status := FND_API.G_RET_STS_ERROR;

702: p_old_ShopFloorMove_rec.process_status OR
703: p_old_ShopFloorMove_rec.process_status IS NULL )
704: THEN
705: IF NOT WIP_Validate.Process_Status(p_ShopFloorMove_rec.process_status) THEN
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: END IF;
708: END IF;
709:
710: IF p_ShopFloorMove_rec.reason_id IS NOT NULL AND

Line 716: x_return_status := FND_API.G_RET_STS_ERROR;

712: p_old_ShopFloorMove_rec.reason_id OR
713: p_old_ShopFloorMove_rec.reason_id IS NULL )
714: THEN
715: IF NOT WIP_Validate.Reason(p_ShopFloorMove_rec.reason_id) THEN
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: END IF;
718: END IF;
719:
720: IF p_ShopFloorMove_rec.reason_name IS NOT NULL AND

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

722: p_old_ShopFloorMove_rec.reason_name OR
723: p_old_ShopFloorMove_rec.reason_name IS NULL )
724: THEN
725: IF NOT WIP_Validate.Reason_Name(p_ShopFloorMove_rec.reason_name) THEN
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: END IF;
728: END IF;
729:
730: IF p_ShopFloorMove_rec.repetitive_schedule_id IS NOT NULL AND

Line 736: x_return_status := FND_API.G_RET_STS_ERROR;

732: p_old_ShopFloorMove_rec.repetitive_schedule_id OR
733: p_old_ShopFloorMove_rec.repetitive_schedule_id IS NULL )
734: THEN
735: IF NOT WIP_Validate.Repetitive_Schedule(p_ShopFloorMove_rec.repetitive_schedule_id) THEN
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: END IF;
738: END IF;
739:
740: IF p_ShopFloorMove_rec.scrap_account_id IS NOT NULL AND

Line 746: x_return_status := FND_API.G_RET_STS_ERROR;

742: p_old_ShopFloorMove_rec.scrap_account_id OR
743: p_old_ShopFloorMove_rec.scrap_account_id IS NULL )
744: THEN
745: IF NOT WIP_Validate.Scrap_Account(p_ShopFloorMove_rec.scrap_account_id) THEN
746: x_return_status := FND_API.G_RET_STS_ERROR;
747: END IF;
748: END IF;
749:
750: IF p_ShopFloorMove_rec.to_department_code IS NOT NULL AND

Line 758: x_return_status := FND_API.G_RET_STS_ERROR;

754: THEN
755: IF NOT WIP_Validate.Department_Code(p_ShopFloorMove_rec.to_department_code,
756: p_ShopFloorMove_rec.organization_id,
757: 'to_department_code') THEN
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: END IF;
760: END IF;
761:
762: IF p_ShopFloorMove_rec.to_department_id IS NOT NULL AND

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765: p_old_ShopFloorMove_rec.to_department_id IS NULL )
766: THEN
767: IF NOT WIP_Validate.Department_Id(p_ShopFloorMove_rec.to_department_id,
768: 'to_department_id') THEN
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: END IF;
771: END IF;
772:
773: IF p_ShopFloorMove_rec.to_intraop_step_type IS NOT NULL AND

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776: p_old_ShopFloorMove_rec.to_intraop_step_type IS NULL )
777: THEN
778: IF NOT WIP_Validate.Intraop_Step_Type(p_ShopFloorMove_rec.to_intraop_step_type,
779: 'to_intraop_step_type') THEN
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: END IF;
782: END IF;
783:
784: IF p_ShopFloorMove_rec.to_operation_code IS NOT NULL AND

Line 791: x_return_status := FND_API.G_RET_STS_ERROR;

787: p_old_ShopFloorMove_rec.to_operation_code IS NULL )
788: THEN
789: IF NOT WIP_Validate.Operation_Code(p_ShopFloorMove_rec.to_operation_code,
790: 'to_operation_code') THEN
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: END IF;
793: END IF;
794:
795: IF p_ShopFloorMove_rec.to_operation_seq_num IS NOT NULL AND

Line 802: x_return_status := FND_API.G_RET_STS_ERROR;

798: p_old_ShopFloorMove_rec.to_operation_seq_num IS NULL )
799: THEN
800: IF NOT WIP_Validate.Operation_Seq_Num(p_ShopFloorMove_rec.to_operation_seq_num,
801: 'to_operation_seq_num') THEN
802: x_return_status := FND_API.G_RET_STS_ERROR;
803: END IF;
804: END IF;
805:
806: IF p_ShopFloorMove_rec.transaction_type IS NOT NULL AND

Line 812: x_return_status := FND_API.G_RET_STS_ERROR;

808: p_old_ShopFloorMove_rec.transaction_type OR
809: p_old_ShopFloorMove_rec.transaction_type IS NULL )
810: THEN
811: IF NOT WIP_Validate.Transaction_Type(p_ShopFloorMove_rec.transaction_type, 'WIP_MOVE_TRANSACTION_TYPE') THEN
812: x_return_status := FND_API.G_RET_STS_ERROR;
813: END IF;
814: END IF;
815:
816: IF p_ShopFloorMove_rec.transaction_uom IS NOT NULL AND

Line 822: x_return_status := FND_API.G_RET_STS_ERROR;

818: p_old_ShopFloorMove_rec.transaction_uom OR
819: p_old_ShopFloorMove_rec.transaction_uom IS NULL )
820: THEN
821: IF NOT WIP_Validate.Transaction_Uom(p_ShopFloorMove_rec.transaction_uom) THEN
822: x_return_status := FND_API.G_RET_STS_ERROR;
823: END IF;
824: END IF;
825:
826: IF p_ShopFloorMove_rec.wip_entity_id IS NOT NULL AND

Line 832: x_return_status := FND_API.G_RET_STS_ERROR;

828: p_old_ShopFloorMove_rec.wip_entity_id OR
829: p_old_ShopFloorMove_rec.wip_entity_id IS NULL )
830: THEN
831: IF NOT WIP_Validate.Wip_Entity(p_ShopFloorMove_rec.wip_entity_id) THEN
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: END IF;
834: END IF;
835:
836: IF p_ShopFloorMove_rec.wip_entity_name IS NOT NULL AND

Line 843: x_return_status := FND_API.G_RET_STS_ERROR;

839: p_old_ShopFloorMove_rec.wip_entity_name IS NULL )
840: THEN
841: IF NOT WIP_Validate.Wip_Entity_Name(p_ShopFloorMove_rec.wip_entity_name,
842: p_ShopFloorMove_rec.organization_id) THEN
843: x_return_status := FND_API.G_RET_STS_ERROR;
844: END IF;
845: END IF;
846:
847:

Line 852: WHEN FND_API.G_EXC_ERROR THEN

848: -- Done validating attributes
849:
850: EXCEPTION
851:
852: WHEN FND_API.G_EXC_ERROR THEN
853:
854: x_return_status := FND_API.G_RET_STS_ERROR;
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 854: x_return_status := FND_API.G_RET_STS_ERROR;

850: EXCEPTION
851:
852: WHEN FND_API.G_EXC_ERROR THEN
853:
854: x_return_status := FND_API.G_RET_STS_ERROR;
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857:
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

852: WHEN FND_API.G_EXC_ERROR THEN
853:
854: x_return_status := FND_API.G_RET_STS_ERROR;
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857:
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859:
860: WHEN OTHERS THEN

Line 858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

854: x_return_status := FND_API.G_RET_STS_ERROR;
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857:
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859:
860: WHEN OTHERS THEN
861:
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859:
860: WHEN OTHERS THEN
861:
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863:
864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
865: THEN
866: FND_MSG_PUB.Add_Exc_Msg