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_PROCESS_PVT dependencies on MTL_CCEOI_PROCESS_PVT

Line 1: PACKAGE BODY MTL_CCEOI_PROCESS_PVT AS

1: PACKAGE BODY MTL_CCEOI_PROCESS_PVT AS
2: /* $Header: INVVCCPB.pls 120.12.12020000.7 2013/03/18 06:46:43 jianpyu ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_CCEOI_PROCESS_PVT';
4:
5:

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_CCEOI_PROCESS_PVT';

1: PACKAGE BODY MTL_CCEOI_PROCESS_PVT AS
2: /* $Header: INVVCCPB.pls 120.12.12020000.7 2013/03/18 06:46:43 jianpyu ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_CCEOI_PROCESS_PVT';
4:
5:
6: procedure mdebug(msg in varchar2)
7: is

Line 1657: MTL_CCEOI_PROCESS_PVT.Entry_to_Current

1653: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.APPROVAL_DATE := SYSDATE;
1654: -- SET the COUNT TYPE CODE TO ZEROCOUNT
1655: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.COUNT_TYPE_CODE := 4;
1656: --
1657: MTL_CCEOI_PROCESS_PVT.Entry_to_Current
1658: (p_reference => p_reference
1659: , p_primary_uom_quantity => p_primary_uom_quantity );
1660: --
1661: MTL_CCEOI_PROCESS_PVT.Current_to_first

Line 1661: MTL_CCEOI_PROCESS_PVT.Current_to_first

1657: MTL_CCEOI_PROCESS_PVT.Entry_to_Current
1658: (p_reference => p_reference
1659: , p_primary_uom_quantity => p_primary_uom_quantity );
1660: --
1661: MTL_CCEOI_PROCESS_PVT.Current_to_first
1662: (p_reference => p_reference
1663: , p_primary_uom_quantity => p_primary_uom_quantity
1664: );
1665: --

Line 3217: l_success := MTL_CCEOI_PROCESS_PVT.check_serial_location(L_issue);

3213: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.serial_adjustment_option = 1 THEN
3214: --
3215: -- Issue
3216: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE := 5;
3217: l_success := MTL_CCEOI_PROCESS_PVT.check_serial_location(L_issue);
3218:
3219: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.NEG_ADJUSTMENT_QUANTITY := 1;
3220: --
3221: IF(L_success = FALSE) THEN

Line 3244: L_success := MTL_CCEOI_PROCESS_PVT.check_serial_location(L_Receipt);

3240: --
3241: IF(
3242: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.serial_adjustment_option = 1) THEN
3243: -- Receipt
3244: L_success := MTL_CCEOI_PROCESS_PVT.check_serial_location(L_Receipt);
3245: --
3246: -- in case of failure just send for manual approval for now
3247: IF (L_success = TRUE) THEN
3248:

Line 3739: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3735: mdebug('Process: In Validate_CHeader return'||x_return_status);
3736: END IF;
3737: -- Write INTO interface error TABLE
3738: IF x_errorcode = 2 THEN
3739: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3740: p_cc_entry_interface_id =>
3741: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, p_error_column_name =>
3742: 'CYCLE_COUNT_HEADER_ID'
3743: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

Line 3749: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3745: );
3746: ELSIF
3747: x_errorcode = 1 THEN
3748: -- Write INTO interface error TABLE
3749: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3750: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
3751: , p_error_column_name => 'CYCLE_COUNT_HEADER_ID'
3752: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
3753: , p_message_name => 'INV_CCEOI_NO_HEADER'

Line 3758: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3754: );
3755: ELSIF
3756: x_errorcode = 45 THEN
3757: -- Write INTO interface error TABLE
3758: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3759: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
3760: , p_error_column_name => 'CYCLE_COUNT_HEADER_ID'
3761: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
3762: , p_message_name => 'INV_CCEOI_MULT_HEADER'

Line 3927: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3923: END IF;
3924: --
3925: IF x_errorcode = 46 THEN
3926: -- Write INTO interface error TABLE
3927: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3928: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
3929: , p_error_column_name => 'CYCLE_COUNT_HEADER_ID'
3930: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
3931: , p_message_name => 'INV_CCEOI_UNMATCH_LISTSEQ'

Line 3944: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3940: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC);
3941: ELSIF
3942: x_errorcode = 3 THEN
3943: -- Write INTO interface error TABLE
3944: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3945: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
3946: , p_error_column_name => 'CYCLE_COUNT_HEADER_ID'
3947: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
3948: , p_message_name => 'INV_CCEOI_MULT_MATCH_REQ'

Line 4183: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4179: L_column_name := 'INVENTORY_ITEM_ID';
4180: END IF;
4181:
4182: -- Write INTO interface error TABLE
4183: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4184: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4185: , p_error_column_name => L_column_name
4186: , p_error_table_name => L_table_name
4187: , p_message_name => L_message_name

Line 4194: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4190: RAISE FND_API.G_EXC_ERROR;
4191: ELSIF
4192: x_errorcode < 0 THEN
4193: -- Write INTO interface error TABLE
4194: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4195: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4196: , p_error_column_name => 'unexpected error'
4197: , p_error_table_name => 'unexpected error'
4198: , p_message_name => 'unexpected error'

Line 4244: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4240: L_table_name := 'MTL_SECONDARY_INVENTORIES';
4241: L_column_name := 'QUANTITY_TRACKED';
4242: END IF;
4243: -- Write INTO interface error TABLE
4244: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4245: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4246: , p_error_column_name => L_column_name
4247: , p_error_table_name => L_table_name
4248: , p_message_name => L_message_name

Line 4255: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4251: RAISE FND_API.G_EXC_ERROR;
4252: ELSIF
4253: x_errorcode < 0 THEN
4254: -- Write INTO interface error TABLE
4255: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4256: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4257: , p_error_column_name => 'unexpected error'
4258: , p_error_table_name => 'unexpected error'
4259: , p_message_name => 'unexpected error'

Line 4325: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4321: L_message_name := 'INV_CCEOI_NO_SERIAL';
4322: L_column_name := 'SERIAL_NUMBER_CONTROL_CODE';
4323: END IF;
4324: -- Write INTO interface error TABLE
4325: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4326: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4327: , p_error_column_name => L_column_name
4328: , p_error_table_name => L_table_name
4329: , p_message_name => L_message_name

Line 4336: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4332: RAISE FND_API.G_EXC_ERROR;
4333: ELSIF
4334: x_errorcode < 0 THEN
4335: -- Write INTO interface error TABLE
4336: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4337: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4338: , p_error_column_name => 'unexpected error'
4339: , p_error_table_name => 'unexpected error'
4340: , p_message_name => 'unexpected error'

Line 4393: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4389: L_message_name := 'INV_CCEOI_LOC_NOT_IN_LIST';
4390: L_column_name := 'SECONDARY_LOCATOR';
4391: END IF;
4392: -- Write INTO interface error TABLE
4393: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4394: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4395: , p_error_column_name => L_column_name
4396: , p_error_table_name => L_table_name
4397: , p_message_name => L_message_name

Line 4404: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4400: ELSIF
4401: x_errorcode < 0 THEN
4402: --
4403: -- Write INTO interface error TABLE
4404: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4405: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4406: , p_error_column_name => 'unexpected error'
4407: , p_error_table_name => 'unexpected error'
4408: , p_message_name => 'unexpected error'

Line 4453: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4449: ELSIF x_errorcode = 12 THEN
4450: L_message_name := 'INV_CCEOI_LOC_INVALID_REV';
4451: END IF;
4452: -- Write INTO interface error TABLE
4453: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4454: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4455: , p_error_column_name => L_column_name
4456: , p_error_table_name => L_table_name
4457: , p_message_name => L_message_name

Line 4464: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4460: ELSIF
4461: x_errorcode < 0 THEN
4462: --
4463: -- Write INTO interface error TABLE
4464: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4465: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4466: , p_error_column_name => 'unexpected error'
4467: , p_error_table_name => 'unexpected error'
4468: , p_message_name => 'unexpected error'

Line 4535: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4531: -- Write INTO interface error TABLE
4532: IF (l_debug = 1) THEN
4533: MDEBUG( 'Process: In Validate_ItemSKU call Val_Lot Msg '||L_message_name);
4534: END IF;
4535: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4536: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4537: , p_error_column_name => L_column_name
4538: , p_error_table_name => L_table_name
4539: , p_message_name => L_message_name

Line 4549: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4545: IF (l_debug = 1) THEN
4546: MDEBUG( 'Process: In Validate_ItemSKU call Val_Lot Error < 0');
4547: END IF;
4548: -- Write INTO interface error TABLE
4549: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4550: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4551: , p_error_column_name => 'unexpected error'
4552: , p_error_table_name => 'unexpected error'
4553: , p_message_name => 'unexpected error'

Line 4647: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4643: --
4644: FND_MESSAGE.SET_NAME('INV',L_message_name);
4645: FND_MSG_PUB.Add;
4646: -- Write INTO interface error TABLE
4647: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4648: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4649: , p_error_column_name => L_column_name
4650: , p_error_table_name => L_table_name
4651: , p_message_name => L_message_name

Line 4658: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4654: ELSIF
4655: x_errorcode < 0 THEN
4656: --
4657: -- Write INTO interface error TABLE
4658: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4659: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4660: , p_error_column_name => 'unexpected error'
4661: , p_error_table_name => 'unexpected error'
4662: , p_message_name => 'unexpected error'

Line 4755: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4751: x_errorcode := 48;
4752: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_CCENTRY');
4753: FND_MSG_PUB.Add;
4754: -- Write INTO interface error TABLE
4755: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4756: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4757: , p_error_column_name => '*'
4758: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4759: , p_message_name => 'INV_CCEOI_NO_CCENTRY'

Line 4776: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4772: END IF;
4773: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_MULT_REQUESTS');
4774: FND_MSG_PUB.Add;
4775: -- Write INTO interface error TABLE
4776: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4777: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4778: , p_error_column_name => '*'
4779: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4780: , p_message_name => 'INV_CCEOI_MULT_REQUESTS'

Line 5022: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5018: END IF;
5019:
5020: IF x_errorcode < 0 THEN
5021:
5022: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5023: p_cc_entry_interface_id =>
5024: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5025: , p_error_column_name => 'unexpected error'
5026: , p_error_table_name => 'unexpected error'

Line 5031: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5027: , p_message_name => 'unexpected error');
5028: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5029:
5030: ELSIF x_errorcode = 22 THEN
5031: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5032: p_cc_entry_interface_id =>
5033: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5034: , p_error_column_name => 'COUNT_QUANTITY'
5035: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

Line 5040: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5036: , p_message_name => 'INV_CCEOI_NEG_QTY');
5037: RAISE FND_API.G_EXC_ERROR;
5038:
5039: ELSIF x_errorcode = 60 THEN
5040: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5041: p_cc_entry_interface_id =>
5042: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5043: , p_error_column_name => 'COUNT_QUANTITY'
5044: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

Line 5049: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5045: , p_message_name => 'INV_SERIAL_QTY_MUST_BE_1');
5046: RAISE FND_API.G_EXC_ERROR;
5047:
5048: ELSIF x_errorcode = 61 THEN
5049: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5050: p_cc_entry_interface_id =>
5051: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5052: , p_error_column_name => 'COUNT_QUANTITY'
5053: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

Line 5081: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5077:
5078: IF x_errorcode = 19 THEN
5079:
5080: -- Write INTO interface error TABLE
5081: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5082: p_cc_entry_interface_id =>
5083: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5084: , p_error_column_name =>
5085: 'UOM_CODE/UNIT_OF_MEASURE'

Line 5092: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5088: );
5089: RAISE FND_API.G_EXC_ERROR;
5090:
5091: ELSIF x_errorcode = 20 THEN
5092: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5093: p_cc_entry_interface_id =>
5094: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5095: , p_error_column_name =>
5096: 'UOM_CODE/UNIT_OF_MEASURE'

Line 5104: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5100: RAISE FND_API.G_EXC_ERROR;
5101:
5102: ELSIF x_errorcode < 0 THEN
5103:
5104: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5105: p_cc_entry_interface_id =>
5106: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5107: , p_error_column_name => 'unexpected error'
5108: , p_error_table_name => 'unexpected error'

Line 5130: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5126:
5127:
5128: IF x_errorcode = 22 THEN
5129:
5130: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5131: p_cc_entry_interface_id =>
5132: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5133: , p_error_column_name => 'COUNT_QUANTITY'
5134: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

Line 5140: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5136:
5137: RAISE FND_API.G_EXC_ERROR;
5138: ELSIF x_errorcode = 60 THEN
5139:
5140: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5141: p_cc_entry_interface_id =>
5142: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5143: , p_error_column_name => 'COUNT_QUANTITY'
5144: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

Line 5150: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5146:
5147: RAISE FND_API.G_EXC_ERROR;
5148: ELSIF x_errorcode = 61 THEN
5149:
5150: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5151: p_cc_entry_interface_id =>
5152: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5153: , p_error_column_name => 'COUNT_QUANTITY'
5154: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

Line 5161: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5157: RAISE FND_API.G_EXC_ERROR;
5158:
5159: ELSIF x_errorcode < 0 THEN
5160: -- Write INTO interface error TABLE
5161: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5162: p_cc_entry_interface_id =>
5163: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5164: , p_error_column_name => 'unexpected error'
5165: , p_error_table_name => 'unexpected error'

Line 5177: MTL_CCEOI_PROCESS_PVT.Calculate_Adjustment

5173:
5174: IF (l_debug = 1) THEN
5175: mdebug('Process: In Validate_UOMQuantity call Validate_Calculate_Adj');
5176: END IF;
5177: MTL_CCEOI_PROCESS_PVT.Calculate_Adjustment
5178: (p_api_version => 0.9
5179: , x_return_status => x_return_status
5180: , x_msg_count => x_msg_count
5181: , x_msg_data => x_msg_data

Line 5205: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5201: END IF;
5202: --
5203: IF x_errorcode = 17 THEN -- XXX this code is disabled in CalcAdj()
5204: -- Write INTO interface error TABLE
5205: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5206: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5207: , p_error_column_name => 'TRANSACTION_QUANTITY'
5208: , p_error_table_name => 'MTL_ONHAND_QUANTITIES'
5209: , p_message_name => 'INV_CCEOI_ADJCALC_NO_SERIAL'

Line 5216: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5212: RAISE FND_API.G_EXC_ERROR;
5213: ELSIF
5214: x_errorcode < 0 THEN
5215: -- Write INTO interface error TABLE
5216: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5217: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5218: , p_error_column_name => 'unexpected error'
5219: , p_error_table_name => 'unexpected error'
5220: , p_message_name => 'unexpected error'

Line 5229: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5225: ELSE -- XXX this is just a precaution (should never happen)
5226: IF (l_debug = 1) THEN
5227: MDEBUG('Invalid count_type_code');
5228: END IF;
5229: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5230: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5231: , p_error_column_name => 'unexpected error'
5232: , p_error_table_name => 'unexpected error'
5233: , p_message_name => 'unexpected error'

Line 5388: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5384: mdebug('Process: In Validate_CDate_Counter call Validate Countdate Return='||x_return_status);
5385: END IF;
5386: --
5387: IF x_errorcode = 23 THEN
5388: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5389: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5390: , p_error_column_name => 'COUNT_DATE'
5391: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
5392: , p_message_name => 'INV_CCEOI_COUNT_DATE_FUTURE'

Line 5398: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5394: --
5395: RAISE FND_API.G_EXC_ERROR;
5396: --
5397: ELSIF x_errorcode = 59 THEN -- New errorcode ( existing one )
5398: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5399: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5400: , p_error_column_name => 'COUNT_DATE'
5401: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
5402: , p_message_name => 'INV_COUNT_DATE_FUTURE'

Line 5407: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5403: );
5404: --
5405: RAISE FND_API.G_EXC_ERROR;
5406: ELSIF x_errorcode = 24 THEN
5407: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5408: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5409: , p_error_column_name => 'COUNT_DATE'
5410: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
5411: , p_message_name => 'INV_CCEOI_NO_OPEN_ADJ_PRD'

Line 5419: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5415:
5416: ELSIF
5417: x_errorcode < 0 THEN
5418: -- Write INTO interface error TABLE
5419: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5420: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5421: , p_error_column_name => 'unexpected error'
5422: , p_error_table_name => 'unexpected error'
5423: , p_message_name => 'unexpected error'

Line 5467: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5463: ELSIF x_errorcode = 101 THEN
5464: L_message_name := 'INV_CCEOI_NOT_UNIQUE_COUNTER';
5465: END IF;
5466: -- Write INTO interface error TABLE
5467: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5468: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5469: , p_error_column_name => 'EMPLOYEE_ID/NAME'
5470: , p_error_table_name => 'MTL_EMPLOYEES_CURRENT_VIEW'
5471: , p_message_name => L_message_name

Line 5478: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5474: RAISE FND_API.G_EXC_ERROR;
5475: ELSIF
5476: x_errorcode < 0 THEN
5477: -- Write INTO interface error TABLE
5478: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5479: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5480: , p_error_column_name => 'unexpected error'
5481: , p_error_table_name => 'unexpected error'
5482: , p_message_name => 'unexpected error'

Line 5720: -- BY the PROCEDURE MTL_CCEOI_PROCESS_PVT.Process_Data

5716: -- Pre-reqs : None
5717: -- FUNCTION :
5718: -- process data porcessed the interface RECORD according to the
5719: -- cycle COUNT entries form. this PROCEDURE can only be called
5720: -- BY the PROCEDURE MTL_CCEOI_PROCESS_PVT.Process_Data
5721: -- Parameters:
5722: -- IN :
5723: -- p_api_version IN NUMBER (required)
5724: -- API Version of this procedure

Line 6642: mtl_cceoi_process_pvt.insert_cceoierror

6638: END IF;
6639:
6640: IF x_errorcode = 20 THEN
6641: -- Write INTO interface error TABLE
6642: mtl_cceoi_process_pvt.insert_cceoierror
6643: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6644: , p_error_column_name => 'SECONDARY_UOM_CODE'
6645: , p_error_table_name => 'MTL_SYSTEM_ITEMS'
6646: , p_message_name => 'INV_INCORRECT_SECONDARY_UOM');

Line 6681: mtl_cceoi_process_pvt.insert_cceoierror

6677: END IF;
6678:
6679: IF x_errorcode = 50 THEN
6680: -- Write INTO interface error TABLE
6681: mtl_cceoi_process_pvt.insert_cceoierror
6682: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6683: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6684: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6685: , p_message_name => 'INV_NO_CONVERSION_ERR');

Line 6689: mtl_cceoi_process_pvt.insert_cceoierror

6685: , p_message_name => 'INV_NO_CONVERSION_ERR');
6686: RAISE fnd_api.g_exc_error;
6687: ELSIF x_errorcode = 51 THEN
6688: -- Write INTO interface error TABLE
6689: mtl_cceoi_process_pvt.insert_cceoierror
6690: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6691: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6692: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6693: , p_message_name => 'INV_DEVIATION_CHECK_ERR');

Line 6697: mtl_cceoi_process_pvt.insert_cceoierror

6693: , p_message_name => 'INV_DEVIATION_CHECK_ERR');
6694: RAISE fnd_api.g_exc_error;
6695: ELSIF x_errorcode = 52 THEN
6696: -- Write INTO interface error TABLE
6697: mtl_cceoi_process_pvt.insert_cceoierror
6698: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6699: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6700: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6701: , p_message_name => 'INV_CCEOI_NEG_QTY');

Line 6714: mtl_cceoi_process_pvt.insert_cceoierror

6710: IF (l_debug = 1) THEN
6711: mdebug ('Invalid count_type_code');
6712: END IF;
6713:
6714: mtl_cceoi_process_pvt.insert_cceoierror
6715: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6716: , p_error_column_name => 'unexpected error'
6717: , p_error_table_name => 'unexpected error'
6718: , p_message_name => 'unexpected error');

Line 6752: END MTL_CCEOI_PROCESS_PVT;

6748: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6749: END validate_secondaryuomqty;
6750: -- END INVCONV
6751:
6752: END MTL_CCEOI_PROCESS_PVT;