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 1057: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(

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

Line 1087: MTL_CCEOI_PROCESS_PVT.Validate_CHeader(

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

Line 1110: MTL_CCEOI_PROCESS_PVT.Validate_CountListSeq(

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

Line 1283: MTL_CCEOI_PROCESS_PVT.Validate_ItemSKU(

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

Line 1356: MTL_CCEOI_PROCESS_PVT.Validate_UOMQuantity(

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

Line 1395: MTL_CCEOI_PROCESS_PVT.Validate_SecondaryUOMQty(

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

Line 1433: MTL_CCEOI_PROCESS_PVT.Validate_CDate_Counter(

1429: IF (l_debug = 1) THEN
1430: mdebug('Count Date' || to_char(p_interface_rec.employee_id));
1431: END IF;
1432: -- Check the counter AND DATE information Step 5
1433: MTL_CCEOI_PROCESS_PVT.Validate_CDate_Counter(
1434: p_api_version => 0.9,
1435: x_return_status => L_return_status,
1436: x_msg_count => x_msg_count,
1437: x_msg_data => x_msg_data,

Line 1468: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

1464: -- UPDATE the interface TABLE flags
1465: IF L_return_status = FND_API.G_RET_STS_SUCCESS
1466: AND p_validation_level=1 THEN
1467: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1468: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1469: p_api_version => 0.9,
1470: x_return_status => L_return_status,
1471: x_msg_count => x_msg_count,
1472: x_msg_data => x_msg_data,

Line 1484: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

1480: ELSIF
1481: L_return_status = FND_API.G_RET_STS_SUCCESS
1482: AND p_validation_level=0 THEN
1483: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1484: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1485: p_api_version => 0.9,
1486: x_return_status => L_return_status,
1487: x_msg_count => x_msg_count,
1488: x_msg_data => x_msg_data,

Line 1504: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

1500:
1501: IF (l_debug = 1) THEN
1502: MDEBUG('Inserting interface entry');
1503: END IF;
1504: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
1505: p_interface_rec => p_interface_rec,
1506: x_return_status => L_return_status);
1507: END IF;
1508: --

Line 1510: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

1506: x_return_status => L_return_status);
1507: END IF;
1508: --
1509: -- SET the flags
1510: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1511: p_api_version => 0.9,
1512: x_return_status => L_return_status,
1513: x_msg_count => x_msg_count,
1514: x_msg_data => x_msg_data,

Line 1649: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(

1645: --
1646: -- API body
1647: --
1648: -- Delete all error records first
1649: MTL_CCEOI_PROCESS_PVT.Delete_CCEOIError(
1650: p_interface_rec.cc_entry_interface_id);
1651: --
1652: MTL_CCEOI_ACTION_PVT.Process_CountRequest
1653: -- Prozedur

Line 1667: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

1663: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1664: --
1665: -- If online mode insert interface record first
1666: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
1667: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
1668: p_interface_rec => p_interface_rec,
1669: x_return_status => L_return_status);
1670: END IF;
1671: --

Line 1672: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags

1668: p_interface_rec => p_interface_rec,
1669: x_return_status => L_return_status);
1670: END IF;
1671: --
1672: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags
1673: -- Prozedur
1674: (p_api_version => 0.9
1675: , x_return_status => L_return_status
1676: , x_msg_count => x_msg_count

Line 1684: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags

1680: -- error, processed with errors
1681: --
1682: ELSE
1683: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1684: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags
1685: (p_api_version => 0.9
1686: , x_return_status => L_return_status
1687: , x_msg_count => x_msg_count
1688: , x_msg_data => x_msg_data

Line 1845: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(

1841: cc_entry_interface_id =
1842: p_interface_rec.cc_entry_interface_id;
1843: --
1844: --
1845: MTL_CCEOI_PROCESS_PVT.Update_CCIEntry(
1846: p_interface_rec => p_interface_rec
1847: , x_return_status => L_return_status);
1848: --
1849: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1861: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(

1857: IF (l_debug = 1) THEN
1858: Mdebug('Before Insert_CCIEntry');
1859: END IF;
1860:
1861: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
1862: p_interface_rec => p_interface_rec
1863: , x_return_status => L_return_status);
1864: --
1865: IF (l_debug = 1) THEN