DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on FND_API

Line 352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;

348: END get_actual_move_ops;
349:
350: PROCEDURE get_osp_move_details
351: IS
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;

Line 353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;

349:
350: PROCEDURE get_osp_move_details
351: IS
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;

Line 354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;

350: PROCEDURE get_osp_move_details
351: IS
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;

Line 355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;

351: IS
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;

Line 356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;

352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;

Line 357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;

353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;

Line 358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;

354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;

Line 359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;

355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;

Line 360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;

356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;

Line 362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;

358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;

Line 363: l_organization_id NUMBER := FND_API.G_MISS_NUM;

359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;

Line 364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;

360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;

Line 365: l_line_id NUMBER := FND_API.G_MISS_NUM;

361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;

Line 366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;

362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;

Line 367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;

363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;

Line 368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;

364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;

Line 369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;

365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;

Line 370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;

366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
374: l_neg_qty_indicator boolean;

Line 371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;

367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
374: l_neg_qty_indicator boolean;
375: BEGIN

Line 372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;

368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
374: l_neg_qty_indicator boolean;
375: BEGIN
376:

Line 373: l_basis_type NUMBER := FND_API.G_MISS_NUM;

369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
374: l_neg_qty_indicator boolean;
375: BEGIN
376:
377: l_wip_entity_id := g_OSP_rec.wip_entity_id;

Line 590: RETURN FND_API.G_MISS_NUM;

586: RETURN NULL;
587:
588: EXCEPTION
589: WHEN OTHERS THEN
590: RETURN FND_API.G_MISS_NUM;
591:
592: END Get_Acct_Period;
593:
594: FUNCTION Get_Created_By_Name

Line 612: RETURN FND_API.G_MISS_CHAR;

608: RETURN NULL;
609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: RETURN FND_API.G_MISS_CHAR;
613:
614: END Get_Created_By_Name;
615:
616: FUNCTION Get_Created_By

Line 633: RETURN FND_API.G_MISS_CHAR;

629: RETURN NULL;
630:
631: EXCEPTION
632: WHEN OTHERS THEN
633: RETURN FND_API.G_MISS_CHAR;
634:
635: END Get_Created_By;
636:
637: FUNCTION Get_Entity_Type

Line 663: RETURN FND_API.G_MISS_NUM;

659: RETURN NULL;
660:
661: EXCEPTION
662: WHEN OTHERS THEN
663: RETURN FND_API.G_MISS_NUM;
664:
665: END Get_Entity_Type;
666:
667: FUNCTION Get_Fm_Department_Code

Line 690: RETURN FND_API.G_MISS_CHAR;

686: RETURN NULL;
687:
688: EXCEPTION
689: WHEN OTHERS THEN
690: RETURN FND_API.G_MISS_CHAR;
691:
692: END Get_Fm_Department_Code;
693:
694: FUNCTION Get_Fm_Department_Id

Line 732: RETURN FND_API.G_MISS_NUM;

728: RETURN NULL;
729:
730: EXCEPTION
731: WHEN OTHERS THEN
732: RETURN FND_API.G_MISS_NUM;
733:
734: END Get_Fm_Department_Id;
735:
736: FUNCTION Get_Fm_Intraop_Step_Type

Line 758: RETURN FND_API.G_MISS_NUM;

754: RETURN NULL;
755:
756: EXCEPTION
757: WHEN OTHERS THEN
758: RETURN FND_API.G_MISS_NUM;
759:
760: END Get_Fm_Intraop_Step_Type;
761:
762: FUNCTION Get_Fm_Operation

Line 775: RETURN FND_API.G_MISS_CHAR;

771: RETURN NULL;
772:
773: EXCEPTION
774: WHEN OTHERS THEN
775: RETURN FND_API.G_MISS_CHAR;
776:
777: END Get_Fm_Operation;
778:
779: FUNCTION Get_Fm_Operation_Seq_Num

Line 802: RETURN FND_API.G_MISS_NUM;

798: RETURN NULL;
799:
800: EXCEPTION
801: WHEN OTHERS THEN
802: RETURN FND_API.G_MISS_NUM;
803:
804: END Get_Fm_Operation_Seq_Num;
805:
806: FUNCTION Get_Group

Line 819: RETURN FND_API.G_MISS_NUM;

815: RETURN NULL;
816:
817: EXCEPTION
818: WHEN OTHERS THEN
819: RETURN FND_API.G_MISS_NUM;
820:
821: END Get_Group;
822:
823: FUNCTION Get_Kanban_Card

Line 843: RETURN FND_API.G_MISS_NUM;

839: RETURN NULL;
840:
841: EXCEPTION
842: WHEN OTHERS THEN
843: RETURN FND_API.G_MISS_NUM;
844:
845: END Get_Kanban_Card;
846:
847: FUNCTION Get_Last_Updated_By_Name

Line 864: RETURN FND_API.G_MISS_CHAR;

860: RETURN NULL;
861:
862: EXCEPTION
863: WHEN OTHERS THEN
864: RETURN FND_API.G_MISS_CHAR;
865:
866: END Get_Last_Updated_By_Name;
867:
868: FUNCTION Get_Last_Update_Login

Line 885: RETURN FND_API.G_MISS_CHAR;

881: RETURN NULL;
882:
883: EXCEPTION
884: WHEN OTHERS THEN
885: RETURN FND_API.G_MISS_CHAR;
886:
887: END Get_Last_Update_Login;
888:
889: FUNCTION Get_Request_Id

Line 906: RETURN FND_API.G_MISS_CHAR;

902: RETURN NULL;
903:
904: EXCEPTION
905: WHEN OTHERS THEN
906: RETURN FND_API.G_MISS_CHAR;
907:
908: END Get_Request_Id;
909:
910: FUNCTION Get_Program_Id

Line 927: RETURN FND_API.G_MISS_CHAR;

923: RETURN NULL;
924:
925: EXCEPTION
926: WHEN OTHERS THEN
927: RETURN FND_API.G_MISS_CHAR;
928:
929: END Get_Program_Id;
930:
931: FUNCTION Get_Program_Application_Id

Line 948: RETURN FND_API.G_MISS_CHAR;

944: RETURN NULL;
945:
946: EXCEPTION
947: WHEN OTHERS THEN
948: RETURN FND_API.G_MISS_CHAR;
949:
950: END Get_Program_Application_Id;
951:
952: FUNCTION Get_Program_Update_Date

Line 969: RETURN FND_API.G_MISS_DATE;

965: RETURN NULL;
966:
967: EXCEPTION
968: WHEN OTHERS THEN
969: RETURN FND_API.G_MISS_DATE;
970:
971: END Get_Program_Update_Date;
972:
973: FUNCTION Get_Last_Updated_By

Line 990: RETURN FND_API.G_MISS_CHAR;

986: RETURN NULL;
987:
988: EXCEPTION
989: WHEN OTHERS THEN
990: RETURN FND_API.G_MISS_CHAR;
991:
992: END Get_Last_Updated_By;
993:
994: FUNCTION Get_Line_Code

Line 1019: RETURN FND_API.G_MISS_CHAR;

1015: RETURN NULL;
1016:
1017: EXCEPTION
1018: WHEN OTHERS THEN
1019: RETURN FND_API.G_MISS_CHAR;
1020:
1021: END Get_Line_Code;
1022:
1023: FUNCTION Get_Line_Id

Line 1040: RETURN FND_API.G_MISS_NUM;

1036: RETURN NULL;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: RETURN FND_API.G_MISS_NUM;
1041:
1042: END Get_Line_Id;
1043:
1044: FUNCTION Get_Organization_Code

Line 1066: RETURN FND_API.G_MISS_CHAR;

1062: RETURN NULL;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: RETURN FND_API.G_MISS_CHAR;
1067:
1068: END Get_Organization_Code;
1069:
1070: FUNCTION Get_Organization_Id

Line 1087: RETURN FND_API.G_MISS_NUM;

1083: RETURN NULL;
1084:
1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: RETURN FND_API.G_MISS_NUM;
1088:
1089: END Get_Organization_Id;
1090:
1091: FUNCTION Get_Overcpl_Primary_Qty

Line 1217: RAISE fnd_api.g_exc_error;

1213: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RT');
1214: end;
1215:
1216: IF (l_interface_txn_id IS NULL) THEN
1217: RAISE fnd_api.g_exc_error;
1218: END IF;
1219:
1220: begin
1221: SELECT item_id

Line 1383: RETURN FND_API.G_MISS_NUM;

1379: RETURN l_overcpl_primary_qty;
1380:
1381: EXCEPTION
1382: WHEN OTHERS THEN
1383: RETURN FND_API.G_MISS_NUM;
1384: END Get_Overcpl_Primary_Qty;
1385:
1386: FUNCTION Get_Overcpl_Transaction
1387: RETURN NUMBER

Line 1399: RETURN FND_API.G_MISS_NUM;

1395: RETURN NULL;
1396:
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: RETURN FND_API.G_MISS_NUM;
1400:
1401: END Get_Overcpl_Transaction;
1402:
1403: FUNCTION Get_Overcpl_Transaction_Qty

Line 1436: RETURN FND_API.G_MISS_NUM;

1432: RETURN NULL;
1433:
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: RETURN FND_API.G_MISS_NUM;
1437:
1438: END Get_Overcpl_Transaction_Qty;
1439:
1440: FUNCTION Get_Primary_Item

Line 1466: RETURN FND_API.G_MISS_NUM;

1462: RETURN NULL;
1463:
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: RETURN FND_API.G_MISS_NUM;
1467:
1468: END Get_Primary_Item;
1469:
1470: FUNCTION Get_Primary_Quantity

Line 1492: RETURN FND_API.G_MISS_NUM;

1488: RETURN NULL;
1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: RETURN FND_API.G_MISS_NUM;
1493:
1494: END Get_Primary_Quantity;
1495:
1496: FUNCTION Get_Primary_Uom

Line 1522: RETURN FND_API.G_MISS_CHAR;

1518: RETURN NULL;
1519:
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: RETURN FND_API.G_MISS_CHAR;
1523:
1524: END Get_Primary_Uom;
1525:
1526: FUNCTION Get_Process_Phase

Line 1543: RETURN FND_API.G_MISS_NUM;

1539: RETURN NULL;
1540:
1541: EXCEPTION
1542: WHEN OTHERS THEN
1543: RETURN FND_API.G_MISS_NUM;
1544:
1545: END Get_Process_Phase;
1546:
1547: FUNCTION Get_Process_Status

Line 1564: RETURN FND_API.G_MISS_NUM;

1560: RETURN NULL;
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: RETURN FND_API.G_MISS_NUM;
1565:
1566: END Get_Process_Status;
1567:
1568: FUNCTION Get_Qa_Collection

Line 1581: RETURN FND_API.G_MISS_NUM;

1577: RETURN NULL;
1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: RETURN FND_API.G_MISS_NUM;
1582:
1583: END Get_Qa_Collection;
1584:
1585: FUNCTION Get_Reason

Line 1602: RETURN FND_API.G_MISS_NUM;

1598: RETURN NULL;
1599:
1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: RETURN FND_API.G_MISS_NUM;
1603:
1604: END Get_Reason;
1605:
1606: FUNCTION Get_Reason_Name

Line 1623: RETURN FND_API.G_MISS_CHAR;

1619: RETURN NULL;
1620:
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: RETURN FND_API.G_MISS_CHAR;
1624:
1625: END Get_Reason_Name;
1626:
1627: FUNCTION Get_Reference

Line 1644: RETURN FND_API.G_MISS_NUM;

1640: RETURN NULL;
1641:
1642: EXCEPTION
1643: WHEN OTHERS THEN
1644: RETURN FND_API.G_MISS_NUM;
1645:
1646: END Get_Reference;
1647:
1648: FUNCTION Get_Repetitive_Schedule

Line 1665: RETURN FND_API.G_MISS_NUM;

1661: RETURN NULL;
1662:
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: RETURN FND_API.G_MISS_NUM;
1666:
1667: END Get_Repetitive_Schedule;
1668:
1669: FUNCTION Get_Scrap_Account

Line 1682: RETURN FND_API.G_MISS_NUM;

1678: RETURN NULL;
1679:
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: RETURN FND_API.G_MISS_NUM;
1683:
1684: END Get_Scrap_Account;
1685:
1686: FUNCTION Get_Source

Line 1703: RETURN FND_API.G_MISS_CHAR;

1699: RETURN NULL;
1700:
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: RETURN FND_API.G_MISS_CHAR;
1704:
1705: END Get_Source;
1706:
1707: FUNCTION Get_Source_Line

Line 1724: RETURN FND_API.G_MISS_NUM;

1720: RETURN NULL;
1721:
1722: EXCEPTION
1723: WHEN OTHERS THEN
1724: RETURN FND_API.G_MISS_NUM;
1725:
1726: END Get_Source_Line;
1727:
1728: FUNCTION Get_To_Department_Code

Line 1756: RETURN FND_API.G_MISS_CHAR;

1752: RETURN NULL;
1753:
1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: RETURN FND_API.G_MISS_CHAR;
1757:
1758: END Get_To_Department_Code;
1759:
1760: FUNCTION Get_To_Department_Id

Line 1798: RETURN FND_API.G_MISS_NUM;

1794: RETURN NULL;
1795:
1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: RETURN FND_API.G_MISS_NUM;
1799:
1800: END Get_To_Department_Id;
1801:
1802: FUNCTION Get_To_Intraop_Step_Type

Line 1824: RETURN FND_API.G_MISS_NUM;

1820: RETURN NULL;
1821:
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: RETURN FND_API.G_MISS_NUM;
1825:
1826: END Get_To_Intraop_Step_Type;
1827:
1828: FUNCTION Get_To_Operation

Line 1841: RETURN FND_API.G_MISS_CHAR;

1837: RETURN NULL;
1838:
1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: RETURN FND_API.G_MISS_CHAR;
1842:
1843: END Get_To_Operation;
1844:
1845: FUNCTION Get_To_Operation_Seq_Num

Line 1867: RETURN FND_API.G_MISS_NUM;

1863: RETURN NULL;
1864:
1865: EXCEPTION
1866: WHEN OTHERS THEN
1867: RETURN FND_API.G_MISS_NUM;
1868:
1869: END Get_To_Operation_Seq_Num;
1870:
1871: FUNCTION Get_Transaction_Date

Line 1888: RETURN FND_API.G_MISS_DATE;

1884: RETURN NULL;
1885:
1886: EXCEPTION
1887: WHEN OTHERS THEN
1888: RETURN FND_API.G_MISS_DATE;
1889:
1890: END Get_Transaction_Date;
1891:
1892: FUNCTION Get_Transaction

Line 1905: RETURN FND_API.G_MISS_NUM;

1901: RETURN NULL;
1902:
1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: RETURN FND_API.G_MISS_NUM;
1906:
1907: END Get_Transaction;
1908:
1909: FUNCTION Get_Transaction_Quantity

Line 1931: RETURN FND_API.G_MISS_NUM;

1927: RETURN NULL;
1928:
1929: EXCEPTION
1930: WHEN OTHERS THEN
1931: RETURN FND_API.G_MISS_NUM;
1932:
1933: END Get_Transaction_Quantity;
1934:
1935: FUNCTION Get_Transaction_Type

Line 1957: RETURN FND_API.G_MISS_NUM;

1953: RETURN NULL;
1954:
1955: EXCEPTION
1956: WHEN OTHERS THEN
1957: RETURN FND_API.G_MISS_NUM;
1958:
1959: END Get_Transaction_Type;
1960:
1961: FUNCTION Get_Transaction_Uom

Line 1978: RETURN FND_API.G_MISS_NUM;

1974: RETURN NULL;
1975:
1976: EXCEPTION
1977: WHEN OTHERS THEN
1978: RETURN FND_API.G_MISS_NUM;
1979:
1980: END Get_Transaction_Uom;
1981:
1982: FUNCTION Get_Wip_Entity

Line 1999: RETURN FND_API.G_MISS_NUM;

1995: RETURN NULL;
1996:
1997: EXCEPTION
1998: WHEN OTHERS THEN
1999: RETURN FND_API.G_MISS_NUM;
2000:
2001: END Get_Wip_Entity;
2002:
2003: FUNCTION Get_Wip_Entity_Name

Line 2029: RETURN FND_API.G_MISS_CHAR;

2025: RETURN NULL;
2026:
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: RETURN FND_API.G_MISS_CHAR;
2030:
2031: END Get_Wip_Entity_Name;
2032:
2033: PROCEDURE Get_Flex_Shopfloormove

Line 2039: IF g_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN

2035: BEGIN
2036:
2037: -- In the future call Flex APIs for defaults
2038:
2039: IF g_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2040: g_ShopFloorMove_rec.attribute1 := NULL;
2041: END IF;
2042:
2043: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 2043: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN

2039: IF g_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2040: g_ShopFloorMove_rec.attribute1 := NULL;
2041: END IF;
2042:
2043: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2044: g_ShopFloorMove_rec.attribute10 := NULL;
2045: END IF;
2046:
2047: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 2047: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN

2043: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2044: g_ShopFloorMove_rec.attribute10 := NULL;
2045: END IF;
2046:
2047: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2048: g_ShopFloorMove_rec.attribute11 := NULL;
2049: END IF;
2050:
2051: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 2051: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN

2047: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2048: g_ShopFloorMove_rec.attribute11 := NULL;
2049: END IF;
2050:
2051: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2052: g_ShopFloorMove_rec.attribute12 := NULL;
2053: END IF;
2054:
2055: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 2055: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN

2051: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2052: g_ShopFloorMove_rec.attribute12 := NULL;
2053: END IF;
2054:
2055: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2056: g_ShopFloorMove_rec.attribute13 := NULL;
2057: END IF;
2058:
2059: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 2059: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN

2055: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2056: g_ShopFloorMove_rec.attribute13 := NULL;
2057: END IF;
2058:
2059: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2060: g_ShopFloorMove_rec.attribute14 := NULL;
2061: END IF;
2062:
2063: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 2063: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN

2059: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2060: g_ShopFloorMove_rec.attribute14 := NULL;
2061: END IF;
2062:
2063: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2064: g_ShopFloorMove_rec.attribute15 := NULL;
2065: END IF;
2066:
2067: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 2067: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN

2063: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2064: g_ShopFloorMove_rec.attribute15 := NULL;
2065: END IF;
2066:
2067: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2068: g_ShopFloorMove_rec.attribute2 := NULL;
2069: END IF;
2070:
2071: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 2071: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN

2067: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2068: g_ShopFloorMove_rec.attribute2 := NULL;
2069: END IF;
2070:
2071: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2072: g_ShopFloorMove_rec.attribute3 := NULL;
2073: END IF;
2074:
2075: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 2075: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN

2071: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2072: g_ShopFloorMove_rec.attribute3 := NULL;
2073: END IF;
2074:
2075: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2076: g_ShopFloorMove_rec.attribute4 := NULL;
2077: END IF;
2078:
2079: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 2079: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN

2075: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2076: g_ShopFloorMove_rec.attribute4 := NULL;
2077: END IF;
2078:
2079: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2080: g_ShopFloorMove_rec.attribute5 := NULL;
2081: END IF;
2082:
2083: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 2083: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN

2079: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2080: g_ShopFloorMove_rec.attribute5 := NULL;
2081: END IF;
2082:
2083: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2084: g_ShopFloorMove_rec.attribute6 := NULL;
2085: END IF;
2086:
2087: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 2087: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN

2083: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2084: g_ShopFloorMove_rec.attribute6 := NULL;
2085: END IF;
2086:
2087: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2088: g_ShopFloorMove_rec.attribute7 := NULL;
2089: END IF;
2090:
2091: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 2091: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN

2087: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2088: g_ShopFloorMove_rec.attribute7 := NULL;
2089: END IF;
2090:
2091: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2092: g_ShopFloorMove_rec.attribute8 := NULL;
2093: END IF;
2094:
2095: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 2095: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN

2091: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2092: g_ShopFloorMove_rec.attribute8 := NULL;
2093: END IF;
2094:
2095: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2096: g_ShopFloorMove_rec.attribute9 := NULL;
2097: END IF;
2098:
2099: IF g_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 2099: IF g_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN

2095: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2096: g_ShopFloorMove_rec.attribute9 := NULL;
2097: END IF;
2098:
2099: IF g_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2100: g_ShopFloorMove_rec.attribute_category := NULL;
2101: END IF;
2102:
2103: END Get_Flex_Shopfloormove;

Line 2127: RAISE FND_API.G_EXC_ERROR;

2123: FND_MSG_PUB.Add;
2124:
2125: END IF;
2126:
2127: RAISE FND_API.G_EXC_ERROR;
2128:
2129: END IF;
2130:
2131: -- Initialize global variables