eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_CCEOI_ACTION_PVT dependencies on MTL_CCEOI_PROCESS_PVT

Line 61: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

57: FND_MSG_PUB.Add;
58:
59: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
60:
61: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
62: p_interface_rec=> p_interface_rec,
63: x_return_status => x_return_status);
64:
65: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 74: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

70: END IF;
71:
72: --
73: -- SET the flags
74: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
75: p_api_version => 0.9,
76: x_return_status => x_return_status,
77: x_msg_count => x_msg_count,
78: x_msg_data => x_msg_data,

Line 89: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

85: END IF;
86:
87: --
88: -- Write INTO Error TABLE
89: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
90: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
91: p_error_column_name => p_error_column_name,
92: p_error_table_name => p_error_table_name,
93: p_message_name => p_message_name );

Line 225: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(

221: --
222: -- API body
223: --
224: -- Delete all error records first
225: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
226: p_interface_rec.cc_entry_interface_id);
227: --
228: -- INSERT the RECORD INTO the TABLE MTL_CC_ENTRIES_INTERFACE
229: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

Line 229: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

225: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
226: p_interface_rec.cc_entry_interface_id);
227: --
228: -- INSERT the RECORD INTO the TABLE MTL_CC_ENTRIES_INTERFACE
229: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
230: p_interface_rec=> p_interface_rec,
231: x_return_status => L_return_status);
232: --
233: -- Set EXPORT FLAG= 1 in MTL_CYCLE_COUNT_ENTRIES

Line 234: MTL_CCEOI_PROCESS_PVT.Set_CCExport(

230: p_interface_rec=> p_interface_rec,
231: x_return_status => L_return_status);
232: --
233: -- Set EXPORT FLAG= 1 in MTL_CYCLE_COUNT_ENTRIES
234: MTL_CCEOI_PROCESS_PVT.Set_CCExport(
235: p_api_version => 0.9,
236: X_return_status=> L_return_status,
237: x_msg_count => L_msg_count,
238: x_msg_data => L_msg_data,

Line 391: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(

387: MDEBUG( 'Create_CountRequest');
388: END IF;
389:
390: -- Delete all error records first
391: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
392: p_interface_rec.cc_entry_interface_id);
393:
394:
395: MTL_CCEOI_ACTION_PVT.Validate_CountRequest

Line 470: MTL_CCEOI_PROCESS_PVT.Insert_CCEntry(

466: IF (p_simulate = FND_API.G_FALSE) THEN
467:
468:
469: -- insert count request into mtl_cycle_count_entries
470: MTL_CCEOI_PROCESS_PVT.Insert_CCEntry(
471: p_interface_rec=> p_interface_rec);
472:
473: declare
474: l_interface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE :=

Line 497: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(l_interface_rec,

493: l_interface_rec.cycle_count_entry_id := null;
494:
495: -- update CCI entry with cycle count entry id
496: -- from that point no SKU changes can be made
497: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(l_interface_rec,
498: x_return_status);
499:
500: if (x_return_status <> fnd_api.g_ret_sts_success) then
501: raise fnd_api.g_exc_unexpected_error;

Line 519: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

515:
516: END IF;
517:
518: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
519: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
520: p_api_version => 0.9,
521: x_return_status => x_return_status,
522: x_msg_count => x_msg_count,
523: x_msg_data => x_msg_data,

Line 688: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(

684: IF (l_debug = 1) THEN
685: MDEBUG( 'Process: Delete all errors ');
686: END IF;
687: -- Delete all error records first
688: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
689: p_interface_rec.cc_entry_interface_id);
690:
691: IF (l_debug = 1) THEN
692: MDEBUG( 'Process: Validate countrequest ');

Line 747: MTL_CCEOI_PROCESS_PVT.Process_Data

743:
744: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
745:
746: -- process the data
747: MTL_CCEOI_PROCESS_PVT.Process_Data
748: (p_api_version => 0.9
749: , p_simulate => p_simulate
750: , x_return_status => x_return_status
751: , x_msg_count => x_msg_count

Line 788: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

784: END IF;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: /*
787: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
788: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
789: p_api_version => 0.9,
790: x_return_status => x_return_status,
791: x_msg_count => x_msg_count,
792: x_msg_data => x_msg_data,

Line 806: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

802: IF MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE = 3
803: THEN
804: -- Added by suresh
805: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
806: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
807: p_api_version => 0.9,
808: x_return_status => x_return_status,
809: x_msg_count => x_msg_count,
810: x_msg_data => x_msg_data,

Line 819: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

815:
816: ELSE
817:
818: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
819: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
820: p_api_version => 0.9,
821: x_return_status => x_return_status,
822: x_msg_count => x_msg_count,
823: x_msg_data => x_msg_data,

Line 839: MTL_CCEOI_PROCESS_PVT.Update_CCEntry(

835: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID is NULL THEN
836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837: END IF;
838:
839: MTL_CCEOI_PROCESS_PVT.Update_CCEntry(
840: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID);
841:
842: END IF;
843:

Line 1060: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(

1056: l_simulate := fnd_api.g_false;
1057: end if;
1058:
1059: -- Delete all error records first
1060: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
1061: p_interface_rec.cc_entry_interface_id);
1062:
1063: IF (l_debug = 1) THEN
1064: mdebug('Validate_CountRequest: Deleted errors');

Line 1090: MTL_CCEOI_PROCESS_PVT.Validate_CHeader(

1086: END IF;
1087: --mdebug('Check Cycle Count Header: ' || to_char(p_interface_rec.cycle_count_header_id) || '.');
1088:
1089: -- Check the cycle COUNT header Process Step 1
1090: MTL_CCEOI_PROCESS_PVT.Validate_CHeader(
1091: p_api_version => 0.9,
1092: x_return_status => L_return_status,
1093: x_msg_count => x_msg_count,
1094: x_msg_data => x_msg_data,

Line 1113: MTL_CCEOI_PROCESS_PVT.Validate_CountListSeq(

1109: IF (l_debug = 1) THEN
1110: MDEBUG( 'Sequence Count List');
1111: END IF;
1112: -- Check the COUNT list sequence Step 2
1113: MTL_CCEOI_PROCESS_PVT.Validate_CountListSeq(
1114: p_api_version => 0.9,
1115: x_return_status => L_return_status,
1116: x_msg_count => x_msg_count,
1117: x_msg_data => x_msg_data,

Line 1286: MTL_CCEOI_PROCESS_PVT.Validate_ItemSKU(

1282: IF (l_debug = 1) THEN
1283: mdebug('Check ITEM SKU');
1284: END IF;
1285: -- Check the item AND SKU information Step 3
1286: MTL_CCEOI_PROCESS_PVT.Validate_ItemSKU(
1287: p_api_version => 0.9,
1288: x_return_status => L_return_status,
1289: x_msg_count => x_msg_count,
1290: x_msg_data => x_msg_data,

Line 1359: MTL_CCEOI_PROCESS_PVT.Validate_UOMQuantity(

1355: mdebug('LOT_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER);
1356: mdebug('system_quantity'||to_char(p_interface_rec.system_quantity));
1357: END IF;
1358: */ -- Check the UOM AND quantity information Step 4
1359: MTL_CCEOI_PROCESS_PVT.Validate_UOMQuantity(
1360: p_api_version => 0.9,
1361: x_return_status => L_return_status,
1362: x_msg_count => x_msg_count,
1363: x_msg_data => x_msg_data,

Line 1398: MTL_CCEOI_PROCESS_PVT.Validate_SecondaryUOMQty(

1394: IF (l_debug = 1) THEN
1395: mdebug('Validate Secondary UOM and Quantity');
1396: END IF;
1397:
1398: MTL_CCEOI_PROCESS_PVT.Validate_SecondaryUOMQty(
1399: p_api_version => 0.9
1400: , x_return_status => l_return_status
1401: , x_msg_count => x_msg_count
1402: , x_msg_data => x_msg_data

Line 1463: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

1459: FND_MSG_PUB.Add;
1460:
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462:
1463: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
1464: P_CC_ENTRY_INTERFACE_ID => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
1465: , P_ERROR_COLUMN_NAME => 'TRANSACTION_REASON_ID'
1466: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
1467: , p_message_name => 'INV_INT_REACODE'

Line 1482: MTL_CCEOI_PROCESS_PVT.Validate_CDate_Counter(

1478: IF (l_debug = 1) THEN
1479: mdebug('Count Date' || to_char(p_interface_rec.employee_id));
1480: END IF;
1481: -- Check the counter AND DATE information Step 5
1482: MTL_CCEOI_PROCESS_PVT.Validate_CDate_Counter(
1483: p_api_version => 0.9,
1484: x_return_status => L_return_status,
1485: x_msg_count => x_msg_count,
1486: x_msg_data => x_msg_data,

Line 1517: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

1513: -- UPDATE the interface TABLE flags
1514: IF L_return_status = FND_API.G_RET_STS_SUCCESS
1515: AND p_validation_level=1 THEN
1516: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1517: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1518: p_api_version => 0.9,
1519: x_return_status => L_return_status,
1520: x_msg_count => x_msg_count,
1521: x_msg_data => x_msg_data,

Line 1533: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

1529: ELSIF
1530: L_return_status = FND_API.G_RET_STS_SUCCESS
1531: AND p_validation_level=0 THEN
1532: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1533: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1534: p_api_version => 0.9,
1535: x_return_status => L_return_status,
1536: x_msg_count => x_msg_count,
1537: x_msg_data => x_msg_data,

Line 1553: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

1549:
1550: IF (l_debug = 1) THEN
1551: MDEBUG('Inserting interface entry');
1552: END IF;
1553: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
1554: p_interface_rec => p_interface_rec,
1555: x_return_status => L_return_status);
1556: END IF;
1557: --

Line 1559: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

1555: x_return_status => L_return_status);
1556: END IF;
1557: --
1558: -- SET the flags
1559: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1560: p_api_version => 0.9,
1561: x_return_status => L_return_status,
1562: x_msg_count => x_msg_count,
1563: x_msg_data => x_msg_data,

Line 1698: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(

1694: --
1695: -- API body
1696: --
1697: -- Delete all error records first
1698: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
1699: p_interface_rec.cc_entry_interface_id);
1700: --
1701: MTL_CCEOI_ACTION_PVT.Process_CountRequest
1702: -- Prozedur

Line 1716: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

1712: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1713: --
1714: -- If online mode insert interface record first
1715: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
1716: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
1717: p_interface_rec => p_interface_rec,
1718: x_return_status => L_return_status);
1719: END IF;
1720: --

Line 1721: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags

1717: p_interface_rec => p_interface_rec,
1718: x_return_status => L_return_status);
1719: END IF;
1720: --
1721: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags
1722: -- Prozedur
1723: (p_api_version => 0.9
1724: , x_return_status => L_return_status
1725: , x_msg_count => x_msg_count

Line 1733: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags

1729: -- error, processed with errors
1730: --
1731: ELSE
1732: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1733: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags
1734: (p_api_version => 0.9
1735: , x_return_status => L_return_status
1736: , x_msg_count => x_msg_count
1737: , x_msg_data => x_msg_data

Line 1894: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(

1890: cc_entry_interface_id =
1891: p_interface_rec.cc_entry_interface_id;
1892: --
1893: --
1894: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(
1895: p_interface_rec => p_interface_rec
1896: , x_return_status => L_return_status);
1897: --
1898: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1910: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

1906: IF (l_debug = 1) THEN
1907: Mdebug('Before Insert_CCIEntry');
1908: END IF;
1909:
1910: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
1911: p_interface_rec => p_interface_rec
1912: , x_return_status => L_return_status);
1913: --
1914: IF (l_debug = 1) THEN