DBA Data[Home] [Help]

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on FND_API

Line 316: l_transaction_type NUMBER := FND_API.G_MISS_NUM;

312: END get_actual_move_ops;
313:
314: PROCEDURE get_osp_move_details
315: IS
316: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
317: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
318: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;

Line 317: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;

313:
314: PROCEDURE get_osp_move_details
315: IS
316: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
317: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
318: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;

Line 318: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;

314: PROCEDURE get_osp_move_details
315: IS
316: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
317: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
318: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;

Line 319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;

315: IS
316: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
317: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
318: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;

Line 320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;

316: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
317: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
318: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;

Line 321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;

317: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
318: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
325: l_correction_type NUMBER;

Line 322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;

318: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
325: l_correction_type NUMBER;
326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;

Line 323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;

319: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
325: l_correction_type NUMBER;
326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
327: l_organization_id NUMBER := FND_API.G_MISS_NUM;

Line 324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;

320: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
321: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
325: l_correction_type NUMBER;
326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
327: l_organization_id NUMBER := FND_API.G_MISS_NUM;
328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;

Line 326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;

322: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
325: l_correction_type NUMBER;
326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
327: l_organization_id NUMBER := FND_API.G_MISS_NUM;
328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
329: l_line_id NUMBER := FND_API.G_MISS_NUM;
330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;

Line 327: l_organization_id NUMBER := FND_API.G_MISS_NUM;

323: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
325: l_correction_type NUMBER;
326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
327: l_organization_id NUMBER := FND_API.G_MISS_NUM;
328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
329: l_line_id NUMBER := FND_API.G_MISS_NUM;
330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;

Line 328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;

324: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
325: l_correction_type NUMBER;
326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
327: l_organization_id NUMBER := FND_API.G_MISS_NUM;
328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
329: l_line_id NUMBER := FND_API.G_MISS_NUM;
330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;

Line 329: l_line_id NUMBER := FND_API.G_MISS_NUM;

325: l_correction_type NUMBER;
326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
327: l_organization_id NUMBER := FND_API.G_MISS_NUM;
328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
329: l_line_id NUMBER := FND_API.G_MISS_NUM;
330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;

Line 330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;

326: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
327: l_organization_id NUMBER := FND_API.G_MISS_NUM;
328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
329: l_line_id NUMBER := FND_API.G_MISS_NUM;
330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;

Line 331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;

327: l_organization_id NUMBER := FND_API.G_MISS_NUM;
328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
329: l_line_id NUMBER := FND_API.G_MISS_NUM;
330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
335: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;

Line 332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;

328: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
329: l_line_id NUMBER := FND_API.G_MISS_NUM;
330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
335: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
336: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;

Line 333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;

329: l_line_id NUMBER := FND_API.G_MISS_NUM;
330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
335: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
336: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
337: l_basis_type NUMBER := FND_API.G_MISS_NUM;

Line 334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;

330: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
335: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
336: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
337: l_basis_type NUMBER := FND_API.G_MISS_NUM;
338: l_neg_qty_indicator boolean;

Line 335: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;

331: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
335: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
336: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
337: l_basis_type NUMBER := FND_API.G_MISS_NUM;
338: l_neg_qty_indicator boolean;
339: BEGIN

Line 336: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;

332: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
335: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
336: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
337: l_basis_type NUMBER := FND_API.G_MISS_NUM;
338: l_neg_qty_indicator boolean;
339: BEGIN
340:

Line 337: l_basis_type NUMBER := FND_API.G_MISS_NUM;

333: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
334: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
335: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
336: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
337: l_basis_type NUMBER := FND_API.G_MISS_NUM;
338: l_neg_qty_indicator boolean;
339: BEGIN
340:
341: l_wip_entity_id := g_OSP_rec.wip_entity_id;

Line 554: RETURN FND_API.G_MISS_NUM;

550: RETURN NULL;
551:
552: EXCEPTION
553: WHEN OTHERS THEN
554: RETURN FND_API.G_MISS_NUM;
555:
556: END Get_Acct_Period;
557:
558: FUNCTION Get_Created_By_Name

Line 576: RETURN FND_API.G_MISS_CHAR;

572: RETURN NULL;
573:
574: EXCEPTION
575: WHEN OTHERS THEN
576: RETURN FND_API.G_MISS_CHAR;
577:
578: END Get_Created_By_Name;
579:
580: FUNCTION Get_Created_By

Line 597: RETURN FND_API.G_MISS_CHAR;

593: RETURN NULL;
594:
595: EXCEPTION
596: WHEN OTHERS THEN
597: RETURN FND_API.G_MISS_CHAR;
598:
599: END Get_Created_By;
600:
601: FUNCTION Get_Entity_Type

Line 627: RETURN FND_API.G_MISS_NUM;

623: RETURN NULL;
624:
625: EXCEPTION
626: WHEN OTHERS THEN
627: RETURN FND_API.G_MISS_NUM;
628:
629: END Get_Entity_Type;
630:
631: FUNCTION Get_Fm_Department_Code

Line 654: RETURN FND_API.G_MISS_CHAR;

650: RETURN NULL;
651:
652: EXCEPTION
653: WHEN OTHERS THEN
654: RETURN FND_API.G_MISS_CHAR;
655:
656: END Get_Fm_Department_Code;
657:
658: FUNCTION Get_Fm_Department_Id

Line 696: RETURN FND_API.G_MISS_NUM;

692: RETURN NULL;
693:
694: EXCEPTION
695: WHEN OTHERS THEN
696: RETURN FND_API.G_MISS_NUM;
697:
698: END Get_Fm_Department_Id;
699:
700: FUNCTION Get_Fm_Intraop_Step_Type

Line 722: RETURN FND_API.G_MISS_NUM;

718: RETURN NULL;
719:
720: EXCEPTION
721: WHEN OTHERS THEN
722: RETURN FND_API.G_MISS_NUM;
723:
724: END Get_Fm_Intraop_Step_Type;
725:
726: FUNCTION Get_Fm_Operation

Line 739: RETURN FND_API.G_MISS_CHAR;

735: RETURN NULL;
736:
737: EXCEPTION
738: WHEN OTHERS THEN
739: RETURN FND_API.G_MISS_CHAR;
740:
741: END Get_Fm_Operation;
742:
743: FUNCTION Get_Fm_Operation_Seq_Num

Line 766: RETURN FND_API.G_MISS_NUM;

762: RETURN NULL;
763:
764: EXCEPTION
765: WHEN OTHERS THEN
766: RETURN FND_API.G_MISS_NUM;
767:
768: END Get_Fm_Operation_Seq_Num;
769:
770: FUNCTION Get_Group

Line 783: RETURN FND_API.G_MISS_NUM;

779: RETURN NULL;
780:
781: EXCEPTION
782: WHEN OTHERS THEN
783: RETURN FND_API.G_MISS_NUM;
784:
785: END Get_Group;
786:
787: FUNCTION Get_Kanban_Card

Line 807: RETURN FND_API.G_MISS_NUM;

803: RETURN NULL;
804:
805: EXCEPTION
806: WHEN OTHERS THEN
807: RETURN FND_API.G_MISS_NUM;
808:
809: END Get_Kanban_Card;
810:
811: FUNCTION Get_Last_Updated_By_Name

Line 828: RETURN FND_API.G_MISS_CHAR;

824: RETURN NULL;
825:
826: EXCEPTION
827: WHEN OTHERS THEN
828: RETURN FND_API.G_MISS_CHAR;
829:
830: END Get_Last_Updated_By_Name;
831:
832: FUNCTION Get_Last_Update_Login

Line 849: RETURN FND_API.G_MISS_CHAR;

845: RETURN NULL;
846:
847: EXCEPTION
848: WHEN OTHERS THEN
849: RETURN FND_API.G_MISS_CHAR;
850:
851: END Get_Last_Update_Login;
852:
853: FUNCTION Get_Request_Id

Line 870: RETURN FND_API.G_MISS_CHAR;

866: RETURN NULL;
867:
868: EXCEPTION
869: WHEN OTHERS THEN
870: RETURN FND_API.G_MISS_CHAR;
871:
872: END Get_Request_Id;
873:
874: FUNCTION Get_Program_Id

Line 891: RETURN FND_API.G_MISS_CHAR;

887: RETURN NULL;
888:
889: EXCEPTION
890: WHEN OTHERS THEN
891: RETURN FND_API.G_MISS_CHAR;
892:
893: END Get_Program_Id;
894:
895: FUNCTION Get_Program_Application_Id

Line 912: RETURN FND_API.G_MISS_CHAR;

908: RETURN NULL;
909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: RETURN FND_API.G_MISS_CHAR;
913:
914: END Get_Program_Application_Id;
915:
916: FUNCTION Get_Program_Update_Date

Line 933: RETURN FND_API.G_MISS_DATE;

929: RETURN NULL;
930:
931: EXCEPTION
932: WHEN OTHERS THEN
933: RETURN FND_API.G_MISS_DATE;
934:
935: END Get_Program_Update_Date;
936:
937: FUNCTION Get_Last_Updated_By

Line 954: RETURN FND_API.G_MISS_CHAR;

950: RETURN NULL;
951:
952: EXCEPTION
953: WHEN OTHERS THEN
954: RETURN FND_API.G_MISS_CHAR;
955:
956: END Get_Last_Updated_By;
957:
958: FUNCTION Get_Line_Code

Line 983: RETURN FND_API.G_MISS_CHAR;

979: RETURN NULL;
980:
981: EXCEPTION
982: WHEN OTHERS THEN
983: RETURN FND_API.G_MISS_CHAR;
984:
985: END Get_Line_Code;
986:
987: FUNCTION Get_Line_Id

Line 1004: RETURN FND_API.G_MISS_NUM;

1000: RETURN NULL;
1001:
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: RETURN FND_API.G_MISS_NUM;
1005:
1006: END Get_Line_Id;
1007:
1008: FUNCTION Get_Organization_Code

Line 1030: RETURN FND_API.G_MISS_CHAR;

1026: RETURN NULL;
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: RETURN FND_API.G_MISS_CHAR;
1031:
1032: END Get_Organization_Code;
1033:
1034: FUNCTION Get_Organization_Id

Line 1051: RETURN FND_API.G_MISS_NUM;

1047: RETURN NULL;
1048:
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: RETURN FND_API.G_MISS_NUM;
1052:
1053: END Get_Organization_Id;
1054:
1055: FUNCTION Get_Overcpl_Primary_Qty

Line 1171: RAISE fnd_api.g_exc_error;

1167: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RT');
1168: end;
1169:
1170: IF (l_interface_txn_id IS NULL) THEN
1171: RAISE fnd_api.g_exc_error;
1172: END IF;
1173:
1174: begin
1175: SELECT item_id

Line 1324: RETURN FND_API.G_MISS_NUM;

1320: RETURN l_overcpl_primary_qty;
1321:
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: RETURN FND_API.G_MISS_NUM;
1325: END Get_Overcpl_Primary_Qty;
1326:
1327: FUNCTION Get_Overcpl_Transaction
1328: RETURN NUMBER

Line 1340: RETURN FND_API.G_MISS_NUM;

1336: RETURN NULL;
1337:
1338: EXCEPTION
1339: WHEN OTHERS THEN
1340: RETURN FND_API.G_MISS_NUM;
1341:
1342: END Get_Overcpl_Transaction;
1343:
1344: FUNCTION Get_Overcpl_Transaction_Qty

Line 1377: RETURN FND_API.G_MISS_NUM;

1373: RETURN NULL;
1374:
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: RETURN FND_API.G_MISS_NUM;
1378:
1379: END Get_Overcpl_Transaction_Qty;
1380:
1381: FUNCTION Get_Primary_Item

Line 1407: RETURN FND_API.G_MISS_NUM;

1403: RETURN NULL;
1404:
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: RETURN FND_API.G_MISS_NUM;
1408:
1409: END Get_Primary_Item;
1410:
1411: FUNCTION Get_Primary_Quantity

Line 1433: RETURN FND_API.G_MISS_NUM;

1429: RETURN NULL;
1430:
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: RETURN FND_API.G_MISS_NUM;
1434:
1435: END Get_Primary_Quantity;
1436:
1437: FUNCTION Get_Primary_Uom

Line 1463: RETURN FND_API.G_MISS_CHAR;

1459: RETURN NULL;
1460:
1461: EXCEPTION
1462: WHEN OTHERS THEN
1463: RETURN FND_API.G_MISS_CHAR;
1464:
1465: END Get_Primary_Uom;
1466:
1467: FUNCTION Get_Process_Phase

Line 1484: RETURN FND_API.G_MISS_NUM;

1480: RETURN NULL;
1481:
1482: EXCEPTION
1483: WHEN OTHERS THEN
1484: RETURN FND_API.G_MISS_NUM;
1485:
1486: END Get_Process_Phase;
1487:
1488: FUNCTION Get_Process_Status

Line 1505: RETURN FND_API.G_MISS_NUM;

1501: RETURN NULL;
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: RETURN FND_API.G_MISS_NUM;
1506:
1507: END Get_Process_Status;
1508:
1509: FUNCTION Get_Qa_Collection

Line 1522: RETURN FND_API.G_MISS_NUM;

1518: RETURN NULL;
1519:
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: RETURN FND_API.G_MISS_NUM;
1523:
1524: END Get_Qa_Collection;
1525:
1526: FUNCTION Get_Reason

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_Reason;
1546:
1547: FUNCTION Get_Reason_Name

Line 1564: RETURN FND_API.G_MISS_CHAR;

1560: RETURN NULL;
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: RETURN FND_API.G_MISS_CHAR;
1565:
1566: END Get_Reason_Name;
1567:
1568: FUNCTION Get_Reference

Line 1585: RETURN FND_API.G_MISS_NUM;

1581: RETURN NULL;
1582:
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: RETURN FND_API.G_MISS_NUM;
1586:
1587: END Get_Reference;
1588:
1589: FUNCTION Get_Repetitive_Schedule

Line 1606: RETURN FND_API.G_MISS_NUM;

1602: RETURN NULL;
1603:
1604: EXCEPTION
1605: WHEN OTHERS THEN
1606: RETURN FND_API.G_MISS_NUM;
1607:
1608: END Get_Repetitive_Schedule;
1609:
1610: FUNCTION Get_Scrap_Account

Line 1623: RETURN FND_API.G_MISS_NUM;

1619: RETURN NULL;
1620:
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: RETURN FND_API.G_MISS_NUM;
1624:
1625: END Get_Scrap_Account;
1626:
1627: FUNCTION Get_Source

Line 1644: RETURN FND_API.G_MISS_CHAR;

1640: RETURN NULL;
1641:
1642: EXCEPTION
1643: WHEN OTHERS THEN
1644: RETURN FND_API.G_MISS_CHAR;
1645:
1646: END Get_Source;
1647:
1648: FUNCTION Get_Source_Line

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_Source_Line;
1668:
1669: FUNCTION Get_To_Department_Code

Line 1697: RETURN FND_API.G_MISS_CHAR;

1693: RETURN NULL;
1694:
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: RETURN FND_API.G_MISS_CHAR;
1698:
1699: END Get_To_Department_Code;
1700:
1701: FUNCTION Get_To_Department_Id

Line 1739: RETURN FND_API.G_MISS_NUM;

1735: RETURN NULL;
1736:
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: RETURN FND_API.G_MISS_NUM;
1740:
1741: END Get_To_Department_Id;
1742:
1743: FUNCTION Get_To_Intraop_Step_Type

Line 1765: RETURN FND_API.G_MISS_NUM;

1761: RETURN NULL;
1762:
1763: EXCEPTION
1764: WHEN OTHERS THEN
1765: RETURN FND_API.G_MISS_NUM;
1766:
1767: END Get_To_Intraop_Step_Type;
1768:
1769: FUNCTION Get_To_Operation

Line 1782: RETURN FND_API.G_MISS_CHAR;

1778: RETURN NULL;
1779:
1780: EXCEPTION
1781: WHEN OTHERS THEN
1782: RETURN FND_API.G_MISS_CHAR;
1783:
1784: END Get_To_Operation;
1785:
1786: FUNCTION Get_To_Operation_Seq_Num

Line 1808: RETURN FND_API.G_MISS_NUM;

1804: RETURN NULL;
1805:
1806: EXCEPTION
1807: WHEN OTHERS THEN
1808: RETURN FND_API.G_MISS_NUM;
1809:
1810: END Get_To_Operation_Seq_Num;
1811:
1812: FUNCTION Get_Transaction_Date

Line 1829: RETURN FND_API.G_MISS_DATE;

1825: RETURN NULL;
1826:
1827: EXCEPTION
1828: WHEN OTHERS THEN
1829: RETURN FND_API.G_MISS_DATE;
1830:
1831: END Get_Transaction_Date;
1832:
1833: FUNCTION Get_Transaction

Line 1846: RETURN FND_API.G_MISS_NUM;

1842: RETURN NULL;
1843:
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: RETURN FND_API.G_MISS_NUM;
1847:
1848: END Get_Transaction;
1849:
1850: FUNCTION Get_Transaction_Quantity

Line 1872: RETURN FND_API.G_MISS_NUM;

1868: RETURN NULL;
1869:
1870: EXCEPTION
1871: WHEN OTHERS THEN
1872: RETURN FND_API.G_MISS_NUM;
1873:
1874: END Get_Transaction_Quantity;
1875:
1876: FUNCTION Get_Transaction_Type

Line 1898: RETURN FND_API.G_MISS_NUM;

1894: RETURN NULL;
1895:
1896: EXCEPTION
1897: WHEN OTHERS THEN
1898: RETURN FND_API.G_MISS_NUM;
1899:
1900: END Get_Transaction_Type;
1901:
1902: FUNCTION Get_Transaction_Uom

Line 1919: RETURN FND_API.G_MISS_NUM;

1915: RETURN NULL;
1916:
1917: EXCEPTION
1918: WHEN OTHERS THEN
1919: RETURN FND_API.G_MISS_NUM;
1920:
1921: END Get_Transaction_Uom;
1922:
1923: FUNCTION Get_Wip_Entity

Line 1940: RETURN FND_API.G_MISS_NUM;

1936: RETURN NULL;
1937:
1938: EXCEPTION
1939: WHEN OTHERS THEN
1940: RETURN FND_API.G_MISS_NUM;
1941:
1942: END Get_Wip_Entity;
1943:
1944: FUNCTION Get_Wip_Entity_Name

Line 1970: RETURN FND_API.G_MISS_CHAR;

1966: RETURN NULL;
1967:
1968: EXCEPTION
1969: WHEN OTHERS THEN
1970: RETURN FND_API.G_MISS_CHAR;
1971:
1972: END Get_Wip_Entity_Name;
1973:
1974: PROCEDURE Get_Flex_Shopfloormove

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

1976: BEGIN
1977:
1978: -- In the future call Flex APIs for defaults
1979:
1980: IF g_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1981: g_ShopFloorMove_rec.attribute1 := NULL;
1982: END IF;
1983:
1984: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

1980: IF g_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1981: g_ShopFloorMove_rec.attribute1 := NULL;
1982: END IF;
1983:
1984: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1985: g_ShopFloorMove_rec.attribute10 := NULL;
1986: END IF;
1987:
1988: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

1984: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1985: g_ShopFloorMove_rec.attribute10 := NULL;
1986: END IF;
1987:
1988: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1989: g_ShopFloorMove_rec.attribute11 := NULL;
1990: END IF;
1991:
1992: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

1988: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1989: g_ShopFloorMove_rec.attribute11 := NULL;
1990: END IF;
1991:
1992: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1993: g_ShopFloorMove_rec.attribute12 := NULL;
1994: END IF;
1995:
1996: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

1992: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1993: g_ShopFloorMove_rec.attribute12 := NULL;
1994: END IF;
1995:
1996: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1997: g_ShopFloorMove_rec.attribute13 := NULL;
1998: END IF;
1999:
2000: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

1996: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1997: g_ShopFloorMove_rec.attribute13 := NULL;
1998: END IF;
1999:
2000: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2001: g_ShopFloorMove_rec.attribute14 := NULL;
2002: END IF;
2003:
2004: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

2000: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2001: g_ShopFloorMove_rec.attribute14 := NULL;
2002: END IF;
2003:
2004: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2005: g_ShopFloorMove_rec.attribute15 := NULL;
2006: END IF;
2007:
2008: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

2004: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2005: g_ShopFloorMove_rec.attribute15 := NULL;
2006: END IF;
2007:
2008: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2009: g_ShopFloorMove_rec.attribute2 := NULL;
2010: END IF;
2011:
2012: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

2008: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2009: g_ShopFloorMove_rec.attribute2 := NULL;
2010: END IF;
2011:
2012: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2013: g_ShopFloorMove_rec.attribute3 := NULL;
2014: END IF;
2015:
2016: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

2012: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2013: g_ShopFloorMove_rec.attribute3 := NULL;
2014: END IF;
2015:
2016: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2017: g_ShopFloorMove_rec.attribute4 := NULL;
2018: END IF;
2019:
2020: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

2016: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2017: g_ShopFloorMove_rec.attribute4 := NULL;
2018: END IF;
2019:
2020: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2021: g_ShopFloorMove_rec.attribute5 := NULL;
2022: END IF;
2023:
2024: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

2020: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2021: g_ShopFloorMove_rec.attribute5 := NULL;
2022: END IF;
2023:
2024: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2025: g_ShopFloorMove_rec.attribute6 := NULL;
2026: END IF;
2027:
2028: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

2024: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2025: g_ShopFloorMove_rec.attribute6 := NULL;
2026: END IF;
2027:
2028: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2029: g_ShopFloorMove_rec.attribute7 := NULL;
2030: END IF;
2031:
2032: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

2028: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2029: g_ShopFloorMove_rec.attribute7 := NULL;
2030: END IF;
2031:
2032: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2033: g_ShopFloorMove_rec.attribute8 := NULL;
2034: END IF;
2035:
2036: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

2032: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2033: g_ShopFloorMove_rec.attribute8 := NULL;
2034: END IF;
2035:
2036: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2037: g_ShopFloorMove_rec.attribute9 := NULL;
2038: END IF;
2039:
2040: IF g_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN

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

2036: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2037: g_ShopFloorMove_rec.attribute9 := NULL;
2038: END IF;
2039:
2040: IF g_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2041: g_ShopFloorMove_rec.attribute_category := NULL;
2042: END IF;
2043:
2044: END Get_Flex_Shopfloormove;

Line 2068: RAISE FND_API.G_EXC_ERROR;

2064: FND_MSG_PUB.Add;
2065:
2066: END IF;
2067:
2068: RAISE FND_API.G_EXC_ERROR;
2069:
2070: END IF;
2071:
2072: -- Initialize global variables