[Home] [Help]
41: P_DEBRIEF_Rec.TASK_ASSIGNMENT_ID := p_task_assignment_id;
42:
43: CSF_DEBRIEF_PUB.Create_DEBRIEF(
44: P_Api_Version_Number => 1.0,
45: P_Init_Msg_List => FND_API.G_FALSE,
46: P_Commit => FND_API.G_FALSE,
47: P_DEBRIEF_Rec => P_DEBRIEF_Rec,
48: P_DEBRIEF_LINE_tbl => CSF_DEBRIEF_PUB.G_MISS_DEBRIEF_LINE_Tbl ,
49: X_DEBRIEF_HEADER_ID => x_header_id,
42:
43: CSF_DEBRIEF_PUB.Create_DEBRIEF(
44: P_Api_Version_Number => 1.0,
45: P_Init_Msg_List => FND_API.G_FALSE,
46: P_Commit => FND_API.G_FALSE,
47: P_DEBRIEF_Rec => P_DEBRIEF_Rec,
48: P_DEBRIEF_LINE_tbl => CSF_DEBRIEF_PUB.G_MISS_DEBRIEF_LINE_Tbl ,
49: X_DEBRIEF_HEADER_ID => x_header_id,
50: X_Return_Status => l_return_status,
51: X_Msg_Count => l_msg_count,
52: X_Msg_Data => l_msg_data
53: );
54:
55: IF l_return_status = FND_API.G_RET_STS_SUCCESS
56: THEN
57: /* API-call was successfull */
58: p_error_id := 0;
59: p_error := FND_API.G_RET_STS_SUCCESS;
55: IF l_return_status = FND_API.G_RET_STS_SUCCESS
56: THEN
57: /* API-call was successfull */
58: p_error_id := 0;
59: p_error := FND_API.G_RET_STS_SUCCESS;
60: p_debrief_header_id := x_header_id;
61: ELSE
62:
63: FOR l_counter IN 1 .. l_msg_count
63: FOR l_counter IN 1 .. l_msg_count
64: LOOP
65: fnd_msg_pub.get
66: ( p_msg_index => l_counter
67: , p_encoded => FND_API.G_FALSE
68: , p_data => l_data
69: , p_msg_index_out => l_msg_index_out
70: );
71: --dbms_output.put_line( 'Message: '||l_data );
74: p_error := l_data;
75: p_debrief_header_id := 0;
76: END IF;
77:
78: if p_error = FND_API.G_RET_STS_SUCCESS
79: then
80: p_error := '';
81: end if;
82:
282:
283: P_DEBRIEF_TBL (1) := P_DEBRIEF_LINE_Rec;
284: CSF_DEBRIEF_PUB.Create_debrief_lines(
285: P_Api_Version_Number => 1.0,
286: P_Init_Msg_List => FND_API.G_FALSE,
287: P_Commit => FND_API.G_TRUE,
288: P_Upd_tskassgnstatus => NULL,
289: P_Task_Assignment_status => NULL,
290: P_DEBRIEF_LINE_Tbl => P_DEBRIEF_TBL ,
283: P_DEBRIEF_TBL (1) := P_DEBRIEF_LINE_Rec;
284: CSF_DEBRIEF_PUB.Create_debrief_lines(
285: P_Api_Version_Number => 1.0,
286: P_Init_Msg_List => FND_API.G_FALSE,
287: P_Commit => FND_API.G_TRUE,
288: P_Upd_tskassgnstatus => NULL,
289: P_Task_Assignment_status => NULL,
290: P_DEBRIEF_LINE_Tbl => P_DEBRIEF_TBL ,
291: P_DEBRIEF_HEADER_ID => l_header_id,
294: X_Msg_Count => l_msg_count ,
295: X_Msg_Data => l_msg_data
296: );
297:
298: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
299: FOR l_counter IN 1 .. l_msg_count
300: LOOP
301: fnd_msg_pub.get
302: ( p_msg_index => l_counter
299: FOR l_counter IN 1 .. l_msg_count
300: LOOP
301: fnd_msg_pub.get
302: ( p_msg_index => l_counter
303: , p_encoded => FND_API.G_FALSE
304: , p_data => l_data
305: , p_msg_index_out => l_msg_index_out
306: );
307: END LOOP;
309: p_error := l_data;
310: ELSE
311: p_debrief_line_id := l_dbf_line_id; -- added to return dbf_line_id
312: END IF;
313: if p_error = FND_API.G_RET_STS_SUCCESS then
314: p_error := '';
315: end if;
316:
317: EXCEPTION
414:
415: P_DEBRIEF_TBL (1) := P_DEBRIEF_LINE_Rec;
416: CSF_DEBRIEF_PUB.Create_debrief_lines(
417: P_Api_Version_Number => 1.0,
418: P_Init_Msg_List => FND_API.G_FALSE,
419: P_Commit => FND_API.G_TRUE,
420: P_Upd_tskassgnstatus => NULL,
421: P_Task_Assignment_status => NULL,
422: P_DEBRIEF_LINE_Tbl => P_DEBRIEF_TBL ,
415: P_DEBRIEF_TBL (1) := P_DEBRIEF_LINE_Rec;
416: CSF_DEBRIEF_PUB.Create_debrief_lines(
417: P_Api_Version_Number => 1.0,
418: P_Init_Msg_List => FND_API.G_FALSE,
419: P_Commit => FND_API.G_TRUE,
420: P_Upd_tskassgnstatus => NULL,
421: P_Task_Assignment_status => NULL,
422: P_DEBRIEF_LINE_Tbl => P_DEBRIEF_TBL ,
423: P_DEBRIEF_HEADER_ID => l_header_id,
426: X_Msg_Count => l_msg_count ,
427: X_Msg_Data => l_msg_data
428: );
429:
430: IF l_return_status = FND_API.G_RET_STS_SUCCESS
431: THEN
432: p_debrief_line_id := l_dbf_line_id; -- Added to return newly created Line_ID
433: null;
434: ELSE
435: FOR l_counter IN 1 .. l_msg_count
436: LOOP
437: fnd_msg_pub.get
438: ( p_msg_index => l_counter
439: , p_encoded => FND_API.G_FALSE
440: , p_data => l_data
441: , p_msg_index_out => l_msg_index_out
442: );
443: END LOOP;
445: p_error := l_data;
446:
447:
448: END IF;
449: if p_error = FND_API.G_RET_STS_SUCCESS
450: then
451: p_error := '';
452: end if;
453:
549:
550:
551: CSF_DEBRIEF_PUB.Update_debrief_line(
552: P_Api_Version_Number => 1.0,
553: P_Init_Msg_List => FND_API.G_FALSE,
554: P_Commit => FND_API.G_FALSE,
555: P_Upd_tskassgnstatus => NULL,
556: P_Task_Assignment_status => NULL,
557: P_DEBRIEF_LINE_Rec => P_DEBRIEF_LINE_Rec,
550:
551: CSF_DEBRIEF_PUB.Update_debrief_line(
552: P_Api_Version_Number => 1.0,
553: P_Init_Msg_List => FND_API.G_FALSE,
554: P_Commit => FND_API.G_FALSE,
555: P_Upd_tskassgnstatus => NULL,
556: P_Task_Assignment_status => NULL,
557: P_DEBRIEF_LINE_Rec => P_DEBRIEF_LINE_Rec,
558: X_Return_Status => l_return_status ,
560: X_Msg_Data => l_msg_data
561: );
562:
563:
564: IF l_return_status = FND_API.G_RET_STS_SUCCESS
565: THEN
566: NULL;
567: ELSE
568: FOR l_counter IN 1 .. l_msg_count
568: FOR l_counter IN 1 .. l_msg_count
569: LOOP
570: fnd_msg_pub.get
571: ( p_msg_index => l_counter
572: , p_encoded => FND_API.G_FALSE
573: , p_data => l_data
574: , p_msg_index_out => l_msg_index_out
575: );
576: END LOOP;
579:
580:
581: END IF;
582:
583: if p_error = FND_API.G_RET_STS_SUCCESS
584: then
585: p_error := '';
586: end if;
587:
763: END IF;
764:
765: CSF_DEBRIEF_PUB.Update_debrief_line(
766: P_Api_Version_Number => 1.0,
767: P_Init_Msg_List => FND_API.G_FALSE,
768: P_Commit => FND_API.G_FALSE,
769: P_Upd_tskassgnstatus => NULL,
770: P_Task_Assignment_status => NULL,
771: P_DEBRIEF_LINE_Rec => P_DEBRIEF_LINE_Rec,
764:
765: CSF_DEBRIEF_PUB.Update_debrief_line(
766: P_Api_Version_Number => 1.0,
767: P_Init_Msg_List => FND_API.G_FALSE,
768: P_Commit => FND_API.G_FALSE,
769: P_Upd_tskassgnstatus => NULL,
770: P_Task_Assignment_status => NULL,
771: P_DEBRIEF_LINE_Rec => P_DEBRIEF_LINE_Rec,
772: X_Return_Status => l_return_status ,
774: X_Msg_Data => l_msg_data
775: );
776:
777:
778: IF l_return_status = FND_API.G_RET_STS_SUCCESS
779: THEN
780: NULL;
781: ELSE
782: FOR l_counter IN 1 .. l_msg_count
782: FOR l_counter IN 1 .. l_msg_count
783: LOOP
784: fnd_msg_pub.get
785: ( p_msg_index => l_counter
786: , p_encoded => FND_API.G_FALSE
787: , p_data => l_data
788: , p_msg_index_out => l_msg_index_out
789: );
790: END LOOP;
792: p_error := l_data;
793:
794: END IF;
795:
796: if p_error = FND_API.G_RET_STS_SUCCESS
797: then
798: p_error := '';
799: end if;
800:
1416: if (p_updateFlag = 1) then
1417:
1418: CSF_DEBRIEF_PUB.Update_debrief_line(
1419: P_Api_Version_Number => 1.0,
1420: P_Init_Msg_List => FND_API.G_FALSE,
1421: P_Commit => FND_API.G_TRUE,
1422: P_Upd_tskassgnstatus => NULL,
1423: P_Task_Assignment_status => NULL,
1424: P_DEBRIEF_LINE_Rec => P_DEBRIEF_LINE_Rec,
1417:
1418: CSF_DEBRIEF_PUB.Update_debrief_line(
1419: P_Api_Version_Number => 1.0,
1420: P_Init_Msg_List => FND_API.G_FALSE,
1421: P_Commit => FND_API.G_TRUE,
1422: P_Upd_tskassgnstatus => NULL,
1423: P_Task_Assignment_status => NULL,
1424: P_DEBRIEF_LINE_Rec => P_DEBRIEF_LINE_Rec,
1425: X_Return_Status => l_return_status ,
1428: );
1429: else
1430: CSF_DEBRIEF_PUB.Create_debrief_lines(
1431: P_Api_Version_Number => 1.0,
1432: P_Init_Msg_List => FND_API.G_FALSE,
1433: P_Commit => FND_API.G_TRUE,
1434: P_Upd_tskassgnstatus => NULL,
1435: P_Task_Assignment_status => NULL,
1436: P_DEBRIEF_LINE_Tbl => P_DEBRIEF_TBL ,
1429: else
1430: CSF_DEBRIEF_PUB.Create_debrief_lines(
1431: P_Api_Version_Number => 1.0,
1432: P_Init_Msg_List => FND_API.G_FALSE,
1433: P_Commit => FND_API.G_TRUE,
1434: P_Upd_tskassgnstatus => NULL,
1435: P_Task_Assignment_status => NULL,
1436: P_DEBRIEF_LINE_Tbl => P_DEBRIEF_TBL ,
1437: P_DEBRIEF_HEADER_ID => l_header_id,
1443:
1444: end if;
1445:
1446:
1447: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1448: THEN
1449: p_error_id := 0;
1450: p_error := 'S';
1451: p_ret_dbfLine_id := P_DEBRIEF_LINE_Rec.DEBRIEF_LINE_ID; -- for DFF
1453: FOR l_counter IN 1 .. l_msg_count
1454: LOOP
1455: fnd_msg_pub.get
1456: ( p_msg_index => l_counter
1457: , p_encoded => FND_API.G_FALSE
1458: , p_data => l_data
1459: , p_msg_index_out => l_msg_index_out
1460: );
1461: --dbms_output.put_line('l_data '|| l_data);
1464: p_error := l_data;
1465:
1466:
1467: END IF;
1468: if p_error = FND_API.G_RET_STS_SUCCESS
1469: then
1470: p_error := '';
1471: end if;
1472: EXCEPTION
1613: x_line_number => l_line_number,
1614: p_Charges_Rec => l_Charges_Rec
1615: );
1616:
1617: IF l_return_status = FND_API.G_RET_STS_SUCCESS
1618: THEN
1619: l_interface_status := 'SUCCEEDED';
1620: ELSE
1621: l_interface_status := 'FAILED';
1626: close c_status_meaning;
1627:
1628: CSF_DEBRIEF_LINES_PKG.Update_Row(
1629: p_DEBRIEF_LINE_ID => p_dbfLineId,
1630: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1631: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1632: p_SERVICE_DATE => FND_API.G_MISS_DATE,
1633: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1627:
1628: CSF_DEBRIEF_LINES_PKG.Update_Row(
1629: p_DEBRIEF_LINE_ID => p_dbfLineId,
1630: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1631: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1632: p_SERVICE_DATE => FND_API.G_MISS_DATE,
1633: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1628: CSF_DEBRIEF_LINES_PKG.Update_Row(
1629: p_DEBRIEF_LINE_ID => p_dbfLineId,
1630: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1631: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1632: p_SERVICE_DATE => FND_API.G_MISS_DATE,
1633: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1629: p_DEBRIEF_LINE_ID => p_dbfLineId,
1630: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1631: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1632: p_SERVICE_DATE => FND_API.G_MISS_DATE,
1633: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1630: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1631: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1632: p_SERVICE_DATE => FND_API.G_MISS_DATE,
1633: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1631: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1632: p_SERVICE_DATE => FND_API.G_MISS_DATE,
1633: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1632: p_SERVICE_DATE => FND_API.G_MISS_DATE,
1633: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1633: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1634: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1635: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1636: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1637: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1638: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1639: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1640: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1641: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1642: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1643: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1644: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1645: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1646: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1647: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1648: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1649: p_UOM_CODE => FND_API.G_MISS_CHAR,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1650: p_QUANTITY => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1651: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1652: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1660: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
1653: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1660: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
1661: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
1654: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1660: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
1661: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
1662: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
1655: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1660: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
1661: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
1662: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
1663: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
1656: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1660: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
1661: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
1662: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
1663: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
1664: p_CHANNEL_CODE => 'WIRELESS_USER',
1657: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1660: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
1661: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
1662: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
1663: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
1664: p_CHANNEL_CODE => 'WIRELESS_USER',
1665: p_CHARGE_UPLOAD_STATUS => l_interface_status,
1658: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1660: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
1661: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
1662: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
1663: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
1664: p_CHANNEL_CODE => 'WIRELESS_USER',
1665: p_CHARGE_UPLOAD_STATUS => l_interface_status,
1666: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
1659: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
1660: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
1661: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
1662: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
1663: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
1664: p_CHANNEL_CODE => 'WIRELESS_USER',
1665: p_CHARGE_UPLOAD_STATUS => l_interface_status,
1666: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
1667: p_CHARGE_UPLOAD_MESSAGE => l_interface_status_meaning,
1662: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
1663: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
1664: p_CHANNEL_CODE => 'WIRELESS_USER',
1665: p_CHARGE_UPLOAD_STATUS => l_interface_status,
1666: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
1667: p_CHARGE_UPLOAD_MESSAGE => l_interface_status_meaning,
1668: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1669: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1670: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1664: p_CHANNEL_CODE => 'WIRELESS_USER',
1665: p_CHARGE_UPLOAD_STATUS => l_interface_status,
1666: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
1667: p_CHARGE_UPLOAD_MESSAGE => l_interface_status_meaning,
1668: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1669: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1670: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1671: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1665: p_CHARGE_UPLOAD_STATUS => l_interface_status,
1666: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
1667: p_CHARGE_UPLOAD_MESSAGE => l_interface_status_meaning,
1668: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1669: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1670: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1671: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1666: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
1667: p_CHARGE_UPLOAD_MESSAGE => l_interface_status_meaning,
1668: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1669: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1670: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1671: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1667: p_CHARGE_UPLOAD_MESSAGE => l_interface_status_meaning,
1668: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1669: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1670: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1671: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1668: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1669: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1670: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1671: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1669: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1670: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1671: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1670: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1671: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1671: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1672: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1673: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1674: p_CREATED_BY => FND_API.G_MISS_NUM,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1675: p_CREATION_DATE => FND_API.G_MISS_DATE,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1676: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1677: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1678: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1679: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1680: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1681: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1682: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1683: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1691: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1684: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1691: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1692: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1685: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1691: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1692: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1693: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1686: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1691: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1692: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1693: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1694: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
1687: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1691: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1692: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1693: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1694: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
1695:
1688: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1691: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1692: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1693: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1694: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
1695:
1696: commit work;
1689: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1691: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1692: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1693: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1694: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
1695:
1696: commit work;
1697:
1690: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
1691: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
1692: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
1693: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
1694: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
1695:
1696: commit work;
1697:
1698: p_error := 'S';
1698: p_error := 'S';
1699: p_error_id := 0;
1700:
1701:
1702: if p_error = FND_API.G_RET_STS_SUCCESS
1703: then
1704: p_error := '';
1705: end if;
1706:
1976: FOR l_counter IN 1 .. l_msg_count
1977: LOOP
1978: fnd_msg_pub.get
1979: ( p_msg_index => l_counter
1980: , p_encoded => FND_API.G_FALSE
1981: , p_data => l_data
1982: , p_msg_index_out => l_msg_index_out
1983: );
1984: --dbms_output.put_line( 'Message: '||l_data );
1993: close c_status_meaning;
1994:
1995: CSF_DEBRIEF_LINES_PKG.Update_Row(
1996: p_DEBRIEF_LINE_ID => p_dbfLineId,
1997: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1998: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1999: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2000: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
1994:
1995: CSF_DEBRIEF_LINES_PKG.Update_Row(
1996: p_DEBRIEF_LINE_ID => p_dbfLineId,
1997: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1998: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1999: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2000: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
1995: CSF_DEBRIEF_LINES_PKG.Update_Row(
1996: p_DEBRIEF_LINE_ID => p_dbfLineId,
1997: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1998: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1999: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2000: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
1996: p_DEBRIEF_LINE_ID => p_dbfLineId,
1997: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1998: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1999: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2000: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1997: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
1998: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1999: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2000: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
1998: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
1999: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2000: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
1999: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2000: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2000: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2001: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2002: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2003: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2004: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2005: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2006: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2007: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2008: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2009: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2010: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2011: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2012: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2013: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2014: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2015: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2016: p_UOM_CODE => FND_API.G_MISS_CHAR,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2017: p_QUANTITY => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2018: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2019: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2027: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2020: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2027: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2028: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2021: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2027: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2028: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2029: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2022: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2027: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2028: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2029: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2030: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2023: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2027: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2028: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2029: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2030: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2031: p_CHANNEL_CODE => 'WIRELESS_USER',
2024: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2027: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2028: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2029: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2030: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2031: p_CHANNEL_CODE => 'WIRELESS_USER',
2032: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2025: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2027: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2028: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2029: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2030: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2031: p_CHANNEL_CODE => 'WIRELESS_USER',
2032: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2033: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2026: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2027: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2028: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2029: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2030: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2031: p_CHANNEL_CODE => 'WIRELESS_USER',
2032: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2033: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2034: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2028: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2029: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2030: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2031: p_CHANNEL_CODE => 'WIRELESS_USER',
2032: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2033: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2034: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2035: p_IB_UPDATE_STATUS => l_interface_status,
2036: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2029: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2030: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2031: p_CHANNEL_CODE => 'WIRELESS_USER',
2032: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2033: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2034: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2035: p_IB_UPDATE_STATUS => l_interface_status,
2036: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2037: p_IB_UPDATE_MESSAGE => l_interface_status_meaning,
2030: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2031: p_CHANNEL_CODE => 'WIRELESS_USER',
2032: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2033: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2034: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2035: p_IB_UPDATE_STATUS => l_interface_status,
2036: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2037: p_IB_UPDATE_MESSAGE => l_interface_status_meaning,
2038: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2032: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2033: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2034: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2035: p_IB_UPDATE_STATUS => l_interface_status,
2036: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2037: p_IB_UPDATE_MESSAGE => l_interface_status_meaning,
2038: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2039: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2040: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2034: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2035: p_IB_UPDATE_STATUS => l_interface_status,
2036: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2037: p_IB_UPDATE_MESSAGE => l_interface_status_meaning,
2038: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2039: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2040: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2041: p_CREATED_BY => FND_API.G_MISS_NUM,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2035: p_IB_UPDATE_STATUS => l_interface_status,
2036: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2037: p_IB_UPDATE_MESSAGE => l_interface_status_meaning,
2038: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2039: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2040: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2041: p_CREATED_BY => FND_API.G_MISS_NUM,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2036: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2037: p_IB_UPDATE_MESSAGE => l_interface_status_meaning,
2038: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2039: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2040: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2041: p_CREATED_BY => FND_API.G_MISS_NUM,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2037: p_IB_UPDATE_MESSAGE => l_interface_status_meaning,
2038: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2039: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2040: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2041: p_CREATED_BY => FND_API.G_MISS_NUM,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2038: p_SPARE_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2039: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2040: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2041: p_CREATED_BY => FND_API.G_MISS_NUM,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2039: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2040: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2041: p_CREATED_BY => FND_API.G_MISS_NUM,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2040: p_SPARE_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2041: p_CREATED_BY => FND_API.G_MISS_NUM,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2041: p_CREATED_BY => FND_API.G_MISS_NUM,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2042: p_CREATION_DATE => FND_API.G_MISS_DATE,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2043: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2044: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2045: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2046: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2047: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2048: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2049: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2050: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2058: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2051: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2058: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2059: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2052: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2058: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2059: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2060: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2053: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2058: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2059: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2060: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2061: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2054: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2058: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2059: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2060: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2061: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2062:
2055: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2058: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2059: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2060: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2061: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2062:
2063: commit work;
2056: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2058: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2059: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2060: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2061: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2062:
2063: commit work;
2064:
2057: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2058: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2059: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2060: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2061: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2062:
2063: commit work;
2064:
2065: p_error := 'S';
2065: p_error := 'S';
2066: p_error_id := 0;
2067:
2068:
2069: if p_error = FND_API.G_RET_STS_SUCCESS
2070: then
2071: p_error := '';
2072: end if;
2073:
2218: p_api_version => l_api_version,
2219: x_return_status => l_RETURN_STATUS,
2220: x_msg_count => l_MSG_COUNT,
2221: x_msg_data => l_MSG_DATA,
2222: p_init_msg_list => FND_API.G_TRUE,
2223: p_commit => FND_API.G_FALSE,
2224: p_inventory_item_id => r_dbfLineRec.inventory_item_id,
2225: p_organization_id => r_dbfLineRec.INVENTORY_ORG_ID,
2226: p_subinventory_code => r_dbfLineRec.SUB_INVENTORY_CODE,
2219: x_return_status => l_RETURN_STATUS,
2220: x_msg_count => l_MSG_COUNT,
2221: x_msg_data => l_MSG_DATA,
2222: p_init_msg_list => FND_API.G_TRUE,
2223: p_commit => FND_API.G_FALSE,
2224: p_inventory_item_id => r_dbfLineRec.inventory_item_id,
2225: p_organization_id => r_dbfLineRec.INVENTORY_ORG_ID,
2226: p_subinventory_code => r_dbfLineRec.SUB_INVENTORY_CODE,
2227: p_locator_id => r_dbfLineRec.LOCATOR,
2250: FOR l_counter IN 1 .. l_msg_count
2251: LOOP
2252: fnd_msg_pub.get
2253: ( p_msg_index => l_counter
2254: , p_encoded => FND_API.G_FALSE
2255: , p_data => l_data
2256: , p_msg_index_out => l_msg_index_out
2257: );
2258: --dbms_output.put_line( 'Message: '||l_data );
2265: close c_status_meaning;
2266:
2267: CSF_DEBRIEF_LINES_PKG.Update_Row(
2268: p_DEBRIEF_LINE_ID => p_dbfLineId,
2269: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
2270: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2271: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2272: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2266:
2267: CSF_DEBRIEF_LINES_PKG.Update_Row(
2268: p_DEBRIEF_LINE_ID => p_dbfLineId,
2269: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
2270: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2271: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2272: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2267: CSF_DEBRIEF_LINES_PKG.Update_Row(
2268: p_DEBRIEF_LINE_ID => p_dbfLineId,
2269: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
2270: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2271: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2272: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2268: p_DEBRIEF_LINE_ID => p_dbfLineId,
2269: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
2270: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2271: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2272: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2269: p_DEBRIEF_HEADER_ID => FND_API.G_MISS_NUM,
2270: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2271: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2272: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2270: p_DEBRIEF_LINE_NUMBER => FND_API.G_MISS_NUM,
2271: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2272: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2271: p_SERVICE_DATE => FND_API.G_MISS_DATE,
2272: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2272: p_BUSINESS_PROCESS_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2273: p_TXN_BILLING_TYPE_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2274: p_INVENTORY_ITEM_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2275: P_INSTANCE_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2276: p_ISSUING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2277: p_RECEIVING_INVENTORY_ORG_ID => FND_API.G_MISS_NUM,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2278: p_ISSUING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2279: p_RECEIVING_SUB_INVENTORY_CODE => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2280: p_ISSUING_LOCATOR_ID => FND_API.G_MISS_NUM,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2281: p_RECEIVING_LOCATOR_ID => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2282: p_PARENT_PRODUCT_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2283: p_REMOVED_PRODUCT_ID => FND_API.G_MISS_NUM,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2284: p_STATUS_OF_RECEIVED_PART => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2285: p_ITEM_SERIAL_NUMBER => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2286: p_ITEM_REVISION => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2287: p_ITEM_LOTNUMBER => FND_API.G_MISS_CHAR,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2288: p_UOM_CODE => FND_API.G_MISS_CHAR,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2289: p_QUANTITY => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2290: p_RMA_HEADER_ID => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2291: p_DISPOSITION_CODE => FND_API.G_MISS_CHAR,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2299: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2292: p_MATERIAL_REASON_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2299: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2300: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2293: p_LABOR_REASON_CODE => FND_API.G_MISS_CHAR,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2299: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2300: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2301: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2294: p_EXPENSE_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2299: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2300: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2301: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2302: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2295: p_LABOR_START_DATE => FND_API.G_MISS_DATE,
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2299: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2300: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2301: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2302: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2303: p_CHANNEL_CODE => 'WIRELESS_USER',
2296: p_LABOR_END_DATE => FND_API.G_MISS_DATE,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2299: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2300: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2301: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2302: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2303: p_CHANNEL_CODE => 'WIRELESS_USER',
2304: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2297: p_STARTING_MILEAGE => FND_API.G_MISS_NUM,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2299: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2300: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2301: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2302: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2303: p_CHANNEL_CODE => 'WIRELESS_USER',
2304: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2305: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2298: p_ENDING_MILEAGE => FND_API.G_MISS_NUM,
2299: p_EXPENSE_AMOUNT => FND_API.G_MISS_NUM,
2300: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2301: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2302: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2303: p_CHANNEL_CODE => 'WIRELESS_USER',
2304: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2305: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2306: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2300: p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
2301: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2302: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2303: p_CHANNEL_CODE => 'WIRELESS_USER',
2304: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2305: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2306: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2307: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2308: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2301: p_DEBRIEF_LINE_STATUS_ID => FND_API.G_MISS_NUM,
2302: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2303: p_CHANNEL_CODE => 'WIRELESS_USER',
2304: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2305: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2306: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2307: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2308: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2309: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2302: P_RETURN_REASON_CODE => FND_API.G_MISS_CHAR,
2303: p_CHANNEL_CODE => 'WIRELESS_USER',
2304: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2305: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2306: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2307: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2308: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2309: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2310: p_SPARE_UPDATE_STATUS => l_interface_status,
2303: p_CHANNEL_CODE => 'WIRELESS_USER',
2304: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2305: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2306: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2307: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2308: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2309: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2310: p_SPARE_UPDATE_STATUS => l_interface_status,
2311: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2304: p_CHARGE_UPLOAD_STATUS => FND_API.G_MISS_CHAR,
2305: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2306: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2307: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2308: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2309: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2310: p_SPARE_UPDATE_STATUS => l_interface_status,
2311: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2312: p_SPARE_UPDATE_MESSAGE => l_interface_status_meaning,
2305: p_CHARGE_UPLOAD_MSG_CODE => FND_API.G_MISS_CHAR,
2306: p_CHARGE_UPLOAD_MESSAGE => FND_API.G_MISS_CHAR,
2307: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2308: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2309: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2310: p_SPARE_UPDATE_STATUS => l_interface_status,
2311: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2312: p_SPARE_UPDATE_MESSAGE => l_interface_status_meaning,
2313: p_CREATED_BY => FND_API.G_MISS_NUM,
2307: p_IB_UPDATE_STATUS => FND_API.G_MISS_CHAR,
2308: p_IB_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2309: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2310: p_SPARE_UPDATE_STATUS => l_interface_status,
2311: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2312: p_SPARE_UPDATE_MESSAGE => l_interface_status_meaning,
2313: p_CREATED_BY => FND_API.G_MISS_NUM,
2314: p_CREATION_DATE => FND_API.G_MISS_DATE,
2315: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2309: p_IB_UPDATE_MESSAGE => FND_API.G_MISS_CHAR,
2310: p_SPARE_UPDATE_STATUS => l_interface_status,
2311: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2312: p_SPARE_UPDATE_MESSAGE => l_interface_status_meaning,
2313: p_CREATED_BY => FND_API.G_MISS_NUM,
2314: p_CREATION_DATE => FND_API.G_MISS_DATE,
2315: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2316: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2310: p_SPARE_UPDATE_STATUS => l_interface_status,
2311: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2312: p_SPARE_UPDATE_MESSAGE => l_interface_status_meaning,
2313: p_CREATED_BY => FND_API.G_MISS_NUM,
2314: p_CREATION_DATE => FND_API.G_MISS_DATE,
2315: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2316: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2311: p_SPARE_UPDATE_MSG_CODE => FND_API.G_MISS_CHAR,
2312: p_SPARE_UPDATE_MESSAGE => l_interface_status_meaning,
2313: p_CREATED_BY => FND_API.G_MISS_NUM,
2314: p_CREATION_DATE => FND_API.G_MISS_DATE,
2315: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2316: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2312: p_SPARE_UPDATE_MESSAGE => l_interface_status_meaning,
2313: p_CREATED_BY => FND_API.G_MISS_NUM,
2314: p_CREATION_DATE => FND_API.G_MISS_DATE,
2315: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2316: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2313: p_CREATED_BY => FND_API.G_MISS_NUM,
2314: p_CREATION_DATE => FND_API.G_MISS_DATE,
2315: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2316: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2314: p_CREATION_DATE => FND_API.G_MISS_DATE,
2315: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2316: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2315: p_LAST_UPDATED_BY => FND_API.G_MISS_NUM,
2316: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2316: p_LAST_UPDATE_DATE => FND_API.G_MISS_DATE,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2317: p_LAST_UPDATE_LOGIN => FND_API.G_MISS_NUM,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2318: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2319: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2320: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2321: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2322: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2330: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2323: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2330: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2331: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2324: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2330: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2331: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2332: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2325: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2330: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2331: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2332: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2333: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2326: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2330: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2331: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2332: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2333: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2334:
2327: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2330: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2331: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2332: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2333: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2334:
2335: commit work;
2328: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2330: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2331: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2332: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2333: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2334:
2335: commit work;
2336:
2329: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
2330: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
2331: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
2332: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
2333: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR);
2334:
2335: commit work;
2336:
2337:
2335: commit work;
2336:
2337:
2338:
2339: if p_error = FND_API.G_RET_STS_SUCCESS
2340: then
2341: p_error := '';
2342: end if;
2343:
2371:
2372: l_return_value := 'S';
2373:
2374: CSF_DEBRIEF_PVT.VALIDATE_LABOR_TIMES (
2375: P_Init_Msg_List => FND_API.G_FALSE,
2376: P_api_version_number => 1.0,
2377: p_resource_type_code => p_resource_type_code,
2378: p_resource_id => p_resource_id,
2379: p_debrief_line_id => p_debrief_line_id,
2456: P_DEBRIEF_Rec.TASK_ASSIGNMENT_ID := p_task_assignment_id;
2457:
2458: CSF_DEBRIEF_PUB.Update_DEBRIEF(
2459: P_Api_Version_Number => 1.0,
2460: P_Init_Msg_List => FND_API.G_FALSE,
2461: P_Commit => FND_API.G_TRUE,
2462: P_DEBRIEF_Rec => P_DEBRIEF_Rec,
2463: X_Return_Status => l_return_status,
2464: X_Msg_Count => l_msg_count,
2457:
2458: CSF_DEBRIEF_PUB.Update_DEBRIEF(
2459: P_Api_Version_Number => 1.0,
2460: P_Init_Msg_List => FND_API.G_FALSE,
2461: P_Commit => FND_API.G_TRUE,
2462: P_DEBRIEF_Rec => P_DEBRIEF_Rec,
2463: X_Return_Status => l_return_status,
2464: X_Msg_Count => l_msg_count,
2465: X_Msg_Data => l_msg_data
2465: X_Msg_Data => l_msg_data
2466: );
2467:
2468:
2469: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2470: THEN
2471: /* API-call was successfull */
2472: p_error_id := 0;
2473: p_error := FND_API.G_RET_STS_SUCCESS;
2469: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2470: THEN
2471: /* API-call was successfull */
2472: p_error_id := 0;
2473: p_error := FND_API.G_RET_STS_SUCCESS;
2474: ELSE
2475: FOR l_counter IN 1 .. l_msg_count
2476: LOOP
2477: fnd_msg_pub.get
2475: FOR l_counter IN 1 .. l_msg_count
2476: LOOP
2477: fnd_msg_pub.get
2478: ( p_msg_index => l_counter
2479: , p_encoded => FND_API.G_FALSE
2480: , p_data => l_data
2481: , p_msg_index_out => l_msg_index_out
2482: );
2483: END LOOP ;
2484: p_error_id := 1;
2485: p_error := l_data;
2486: END IF;
2487:
2488: if p_error = FND_API.G_RET_STS_SUCCESS
2489: then
2490: p_error := '';
2491: end if;
2492:
2621: END IF;
2622:
2623: CSF_DEBRIEF_PUB.Update_debrief (
2624: P_Api_Version_Number => 1.0,
2625: P_Init_Msg_List => FND_API.G_FALSE,
2626: P_Commit => FND_API.G_FALSE,
2627: P_DEBRIEF_Rec => P_DEBRIEF_Rec,
2628: X_Return_Status => p_return_status,
2629: X_Msg_Count => p_error_count,
2622:
2623: CSF_DEBRIEF_PUB.Update_debrief (
2624: P_Api_Version_Number => 1.0,
2625: P_Init_Msg_List => FND_API.G_FALSE,
2626: P_Commit => FND_API.G_FALSE,
2627: P_DEBRIEF_Rec => P_DEBRIEF_Rec,
2628: X_Return_Status => p_return_status,
2629: X_Msg_Count => p_error_count,
2630: X_Msg_Data => l_error_msg
2629: X_Msg_Count => p_error_count,
2630: X_Msg_Data => l_error_msg
2631: );
2632:
2633: IF p_return_status = FND_API.G_RET_STS_SUCCESS
2634: THEN
2635: commit;
2636: ELSE
2637: FOR l_counter IN 1 .. p_error_count
2637: FOR l_counter IN 1 .. p_error_count
2638: LOOP
2639: FND_MSG_PUB.Get (
2640: p_msg_index => l_counter,
2641: p_encoded => FND_API.G_FALSE,
2642: p_data => l_error_msg,
2643: p_msg_index_out => l_msg_index_out
2644: );
2645: END LOOP ;