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.

[Home] [Help]

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.5 2006/12/21 08:36:41 rvedulla 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.5 2006/12/21 08:36:41 rvedulla ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MTL_CCEOI_PROCESS_PVT';
4:
5:
6: procedure mdebug(msg in varchar2)
7: is

Line 1560: MTL_CCEOI_PROCESS_PVT.Entry_to_Current

1556: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.APPROVAL_DATE := SYSDATE;
1557: -- SET the COUNT TYPE CODE TO ZEROCOUNT
1558: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.COUNT_TYPE_CODE := 4;
1559: --
1560: MTL_CCEOI_PROCESS_PVT.Entry_to_Current
1561: (p_reference => p_reference
1562: , p_primary_uom_quantity => p_primary_uom_quantity );
1563: --
1564: MTL_CCEOI_PROCESS_PVT.Current_to_first

Line 1564: MTL_CCEOI_PROCESS_PVT.Current_to_first

1560: MTL_CCEOI_PROCESS_PVT.Entry_to_Current
1561: (p_reference => p_reference
1562: , p_primary_uom_quantity => p_primary_uom_quantity );
1563: --
1564: MTL_CCEOI_PROCESS_PVT.Current_to_first
1565: (p_reference => p_reference
1566: , p_primary_uom_quantity => p_primary_uom_quantity
1567: );
1568: --

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

3075: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.serial_adjustment_option = 1 THEN
3076: --
3077: -- Issue
3078: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE := 5;
3079: l_success := MTL_CCEOI_PROCESS_PVT.check_serial_location(L_issue);
3080:
3081: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.NEG_ADJUSTMENT_QUANTITY := 1;
3082: --
3083: IF(L_success = FALSE) THEN

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

3102: --
3103: IF(
3104: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.serial_adjustment_option = 1) THEN
3105: -- Receipt
3106: L_success := MTL_CCEOI_PROCESS_PVT.check_serial_location(L_Receipt);
3107: --
3108: -- in case of failure just send for manual approval for now
3109: IF (L_success = TRUE) THEN
3110:

Line 3598: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3594: mdebug('Process: In Validate_CHeader return'||x_return_status);
3595: END IF;
3596: -- Write INTO interface error TABLE
3597: IF x_errorcode = 2 THEN
3598: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3599: p_cc_entry_interface_id =>
3600: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, p_error_column_name =>
3601: 'CYCLE_COUNT_HEADER_ID'
3602: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

Line 3608: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3604: );
3605: ELSIF
3606: x_errorcode = 1 THEN
3607: -- Write INTO interface error TABLE
3608: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3609: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
3610: , p_error_column_name => 'CYCLE_COUNT_HEADER_ID'
3611: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
3612: , p_message_name => 'INV_CCEOI_NO_HEADER'

Line 3617: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3613: );
3614: ELSIF
3615: x_errorcode = 45 THEN
3616: -- Write INTO interface error TABLE
3617: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3618: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
3619: , p_error_column_name => 'CYCLE_COUNT_HEADER_ID'
3620: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
3621: , p_message_name => 'INV_CCEOI_MULT_HEADER'

Line 3786: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3782: END IF;
3783: --
3784: IF x_errorcode = 46 THEN
3785: -- Write INTO interface error TABLE
3786: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3787: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
3788: , p_error_column_name => 'CYCLE_COUNT_HEADER_ID'
3789: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
3790: , p_message_name => 'INV_CCEOI_UNMATCH_LISTSEQ'

Line 3803: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

3799: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC);
3800: ELSIF
3801: x_errorcode = 3 THEN
3802: -- Write INTO interface error TABLE
3803: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
3804: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
3805: , p_error_column_name => 'CYCLE_COUNT_HEADER_ID'
3806: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
3807: , p_message_name => 'INV_CCEOI_MULT_MATCH_REQ'

Line 4041: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4037: L_column_name := 'INVENTORY_ITEM_ID';
4038: END IF;
4039:
4040: -- Write INTO interface error TABLE
4041: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4042: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4043: , p_error_column_name => L_column_name
4044: , p_error_table_name => L_table_name
4045: , p_message_name => L_message_name

Line 4052: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4048: RAISE FND_API.G_EXC_ERROR;
4049: ELSIF
4050: x_errorcode < 0 THEN
4051: -- Write INTO interface error TABLE
4052: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4053: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4054: , p_error_column_name => 'unexpected error'
4055: , p_error_table_name => 'unexpected error'
4056: , p_message_name => 'unexpected error'

Line 4102: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4098: L_table_name := 'MTL_SECONDARY_INVENTORIES';
4099: L_column_name := 'QUANTITY_TRACKED';
4100: END IF;
4101: -- Write INTO interface error TABLE
4102: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4103: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4104: , p_error_column_name => L_column_name
4105: , p_error_table_name => L_table_name
4106: , p_message_name => L_message_name

Line 4113: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4109: RAISE FND_API.G_EXC_ERROR;
4110: ELSIF
4111: x_errorcode < 0 THEN
4112: -- Write INTO interface error TABLE
4113: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4114: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4115: , p_error_column_name => 'unexpected error'
4116: , p_error_table_name => 'unexpected error'
4117: , p_message_name => 'unexpected error'

Line 4183: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4179: L_message_name := 'INV_CCEOI_NO_SERIAL';
4180: L_column_name := 'SERIAL_NUMBER_CONTROL_CODE';
4181: END IF;
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 4251: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4247: L_message_name := 'INV_CCEOI_LOC_NOT_IN_LIST';
4248: L_column_name := 'SECONDARY_LOCATOR';
4249: END IF;
4250: -- Write INTO interface error TABLE
4251: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4252: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4253: , p_error_column_name => L_column_name
4254: , p_error_table_name => L_table_name
4255: , p_message_name => L_message_name

Line 4262: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4258: ELSIF
4259: x_errorcode < 0 THEN
4260: --
4261: -- Write INTO interface error TABLE
4262: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4263: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4264: , p_error_column_name => 'unexpected error'
4265: , p_error_table_name => 'unexpected error'
4266: , p_message_name => 'unexpected error'

Line 4311: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4307: ELSIF x_errorcode = 12 THEN
4308: L_message_name := 'INV_CCEOI_LOC_INVALID_REV';
4309: END IF;
4310: -- Write INTO interface error TABLE
4311: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4312: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4313: , p_error_column_name => L_column_name
4314: , p_error_table_name => L_table_name
4315: , p_message_name => L_message_name

Line 4322: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4318: ELSIF
4319: x_errorcode < 0 THEN
4320: --
4321: -- Write INTO interface error TABLE
4322: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4323: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4324: , p_error_column_name => 'unexpected error'
4325: , p_error_table_name => 'unexpected error'
4326: , p_message_name => 'unexpected error'

Line 4393: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4389: -- Write INTO interface error TABLE
4390: IF (l_debug = 1) THEN
4391: MDEBUG( 'Process: In Validate_ItemSKU call Val_Lot Msg '||L_message_name);
4392: END IF;
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 4407: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4403: IF (l_debug = 1) THEN
4404: MDEBUG( 'Process: In Validate_ItemSKU call Val_Lot Error < 0');
4405: END IF;
4406: -- Write INTO interface error TABLE
4407: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4408: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4409: , p_error_column_name => 'unexpected error'
4410: , p_error_table_name => 'unexpected error'
4411: , p_message_name => 'unexpected error'

Line 4504: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4500: --
4501: FND_MESSAGE.SET_NAME('INV',L_message_name);
4502: FND_MSG_PUB.Add;
4503: -- Write INTO interface error TABLE
4504: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4505: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4506: , p_error_column_name => L_column_name
4507: , p_error_table_name => L_table_name
4508: , p_message_name => L_message_name

Line 4515: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4511: ELSIF
4512: x_errorcode < 0 THEN
4513: --
4514: -- Write INTO interface error TABLE
4515: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4516: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4517: , p_error_column_name => 'unexpected error'
4518: , p_error_table_name => 'unexpected error'
4519: , p_message_name => 'unexpected error'

Line 4584: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4580: x_errorcode := 48;
4581: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_CCENTRY');
4582: FND_MSG_PUB.Add;
4583: -- Write INTO interface error TABLE
4584: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4585: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4586: , p_error_column_name => '*'
4587: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4588: , p_message_name => 'INV_CCEOI_NO_CCENTRY'

Line 4605: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4601: END IF;
4602: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_MULT_REQUESTS');
4603: FND_MSG_PUB.Add;
4604: -- Write INTO interface error TABLE
4605: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4606: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4607: , p_error_column_name => '*'
4608: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'
4609: , p_message_name => 'INV_CCEOI_MULT_REQUESTS'

Line 4851: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4847: END IF;
4848:
4849: IF x_errorcode < 0 THEN
4850:
4851: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4852: p_cc_entry_interface_id =>
4853: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4854: , p_error_column_name => 'unexpected error'
4855: , p_error_table_name => 'unexpected error'

Line 4860: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4856: , p_message_name => 'unexpected error');
4857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4858:
4859: ELSIF x_errorcode = 22 THEN
4860: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4861: p_cc_entry_interface_id =>
4862: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4863: , p_error_column_name => 'COUNT_QUANTITY'
4864: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

Line 4869: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4865: , p_message_name => 'INV_CCEOI_NEG_QTY');
4866: RAISE FND_API.G_EXC_ERROR;
4867:
4868: ELSIF x_errorcode = 60 THEN
4869: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4870: p_cc_entry_interface_id =>
4871: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4872: , p_error_column_name => 'COUNT_QUANTITY'
4873: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

Line 4878: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4874: , p_message_name => 'INV_SERIAL_QTY_MUST_BE_1');
4875: RAISE FND_API.G_EXC_ERROR;
4876:
4877: ELSIF x_errorcode = 61 THEN
4878: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4879: p_cc_entry_interface_id =>
4880: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4881: , p_error_column_name => 'COUNT_QUANTITY'
4882: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

Line 4910: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4906:
4907: IF x_errorcode = 19 THEN
4908:
4909: -- Write INTO interface error TABLE
4910: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4911: p_cc_entry_interface_id =>
4912: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4913: , p_error_column_name =>
4914: 'UOM_CODE/UNIT_OF_MEASURE'

Line 4921: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4917: );
4918: RAISE FND_API.G_EXC_ERROR;
4919:
4920: ELSIF x_errorcode = 20 THEN
4921: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4922: p_cc_entry_interface_id =>
4923: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4924: , p_error_column_name =>
4925: 'UOM_CODE/UNIT_OF_MEASURE'

Line 4933: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4929: RAISE FND_API.G_EXC_ERROR;
4930:
4931: ELSIF x_errorcode < 0 THEN
4932:
4933: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4934: p_cc_entry_interface_id =>
4935: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4936: , p_error_column_name => 'unexpected error'
4937: , p_error_table_name => 'unexpected error'

Line 4959: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4955:
4956:
4957: IF x_errorcode = 22 THEN
4958:
4959: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4960: p_cc_entry_interface_id =>
4961: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4962: , p_error_column_name => 'COUNT_QUANTITY'
4963: , p_error_table_name => 'MTL_CYCLE_COUNT_ENTRIES'

Line 4969: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4965:
4966: RAISE FND_API.G_EXC_ERROR;
4967: ELSIF x_errorcode = 60 THEN
4968:
4969: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4970: p_cc_entry_interface_id =>
4971: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4972: , p_error_column_name => 'COUNT_QUANTITY'
4973: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

Line 4979: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4975:
4976: RAISE FND_API.G_EXC_ERROR;
4977: ELSIF x_errorcode = 61 THEN
4978:
4979: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4980: p_cc_entry_interface_id =>
4981: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4982: , p_error_column_name => 'COUNT_QUANTITY'
4983: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'

Line 4990: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

4986: RAISE FND_API.G_EXC_ERROR;
4987:
4988: ELSIF x_errorcode < 0 THEN
4989: -- Write INTO interface error TABLE
4990: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4991: p_cc_entry_interface_id =>
4992: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4993: , p_error_column_name => 'unexpected error'
4994: , p_error_table_name => 'unexpected error'

Line 5006: MTL_CCEOI_PROCESS_PVT.Calculate_Adjustment

5002:
5003: IF (l_debug = 1) THEN
5004: mdebug('Process: In Validate_UOMQuantity call Validate_Calculate_Adj');
5005: END IF;
5006: MTL_CCEOI_PROCESS_PVT.Calculate_Adjustment
5007: (p_api_version => 0.9
5008: , x_return_status => x_return_status
5009: , x_msg_count => x_msg_count
5010: , x_msg_data => x_msg_data

Line 5034: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5030: END IF;
5031: --
5032: IF x_errorcode = 17 THEN -- XXX this code is disabled in CalcAdj()
5033: -- Write INTO interface error TABLE
5034: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5035: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5036: , p_error_column_name => 'TRANSACTION_QUANTITY'
5037: , p_error_table_name => 'MTL_ONHAND_QUANTITIES'
5038: , p_message_name => 'INV_CCEOI_ADJCALC_NO_SERIAL'

Line 5045: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5041: RAISE FND_API.G_EXC_ERROR;
5042: ELSIF
5043: x_errorcode < 0 THEN
5044: -- Write INTO interface error TABLE
5045: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5046: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5047: , p_error_column_name => 'unexpected error'
5048: , p_error_table_name => 'unexpected error'
5049: , p_message_name => 'unexpected error'

Line 5058: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5054: ELSE -- XXX this is just a precaution (should never happen)
5055: IF (l_debug = 1) THEN
5056: MDEBUG('Invalid count_type_code');
5057: END IF;
5058: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5059: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5060: , p_error_column_name => 'unexpected error'
5061: , p_error_table_name => 'unexpected error'
5062: , p_message_name => 'unexpected error'

Line 5216: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5212: mdebug('Process: In Validate_CDate_Counter call Validate Countdate Return='||x_return_status);
5213: END IF;
5214: --
5215: IF x_errorcode = 23 THEN
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 => 'COUNT_DATE'
5219: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
5220: , p_message_name => 'INV_CCEOI_COUNT_DATE_FUTURE'

Line 5226: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5222: --
5223: RAISE FND_API.G_EXC_ERROR;
5224: --
5225: ELSIF x_errorcode = 59 THEN -- New errorcode ( existing one )
5226: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5227: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5228: , p_error_column_name => 'COUNT_DATE'
5229: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
5230: , p_message_name => 'INV_COUNT_DATE_FUTURE'

Line 5235: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5231: );
5232: --
5233: RAISE FND_API.G_EXC_ERROR;
5234: ELSIF x_errorcode = 24 THEN
5235: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5236: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5237: , p_error_column_name => 'COUNT_DATE'
5238: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'
5239: , p_message_name => 'INV_CCEOI_NO_OPEN_ADJ_PRD'

Line 5247: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5243:
5244: ELSIF
5245: x_errorcode < 0 THEN
5246: -- Write INTO interface error TABLE
5247: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5248: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5249: , p_error_column_name => 'unexpected error'
5250: , p_error_table_name => 'unexpected error'
5251: , p_message_name => 'unexpected error'

Line 5292: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5288: ELSIF x_errorcode = 101 THEN
5289: L_message_name := 'INV_CCEOI_NOT_UNIQUE_COUNTER';
5290: END IF;
5291: -- Write INTO interface error TABLE
5292: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5293: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5294: , p_error_column_name => 'EMPLOYEE_ID/NAME'
5295: , p_error_table_name => 'MTL_EMPLOYEES_CURRENT_VIEW'
5296: , p_message_name => L_message_name

Line 5303: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(

5299: RAISE FND_API.G_EXC_ERROR;
5300: ELSIF
5301: x_errorcode < 0 THEN
5302: -- Write INTO interface error TABLE
5303: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
5304: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
5305: , p_error_column_name => 'unexpected error'
5306: , p_error_table_name => 'unexpected error'
5307: , p_message_name => 'unexpected error'

Line 5545: -- BY the PROCEDURE MTL_CCEOI_PROCESS_PVT.Process_Data

5541: -- Pre-reqs : None
5542: -- FUNCTION :
5543: -- process data porcessed the interface RECORD according to the
5544: -- cycle COUNT entries form. this PROCEDURE can only be called
5545: -- BY the PROCEDURE MTL_CCEOI_PROCESS_PVT.Process_Data
5546: -- Parameters:
5547: -- IN :
5548: -- p_api_version IN NUMBER (required)
5549: -- API Version of this procedure

Line 6467: mtl_cceoi_process_pvt.insert_cceoierror

6463: END IF;
6464:
6465: IF x_errorcode = 20 THEN
6466: -- Write INTO interface error TABLE
6467: mtl_cceoi_process_pvt.insert_cceoierror
6468: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6469: , p_error_column_name => 'SECONDARY_UOM_CODE'
6470: , p_error_table_name => 'MTL_SYSTEM_ITEMS'
6471: , p_message_name => 'INV_INCORRECT_SECONDARY_UOM');

Line 6506: mtl_cceoi_process_pvt.insert_cceoierror

6502: END IF;
6503:
6504: IF x_errorcode = 50 THEN
6505: -- Write INTO interface error TABLE
6506: mtl_cceoi_process_pvt.insert_cceoierror
6507: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6508: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6509: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6510: , p_message_name => 'INV_NO_CONVERSION_ERR');

Line 6514: mtl_cceoi_process_pvt.insert_cceoierror

6510: , p_message_name => 'INV_NO_CONVERSION_ERR');
6511: RAISE fnd_api.g_exc_error;
6512: ELSIF x_errorcode = 51 THEN
6513: -- Write INTO interface error TABLE
6514: mtl_cceoi_process_pvt.insert_cceoierror
6515: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6516: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6517: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6518: , p_message_name => 'INV_DEVIATION_CHECK_ERR');

Line 6522: mtl_cceoi_process_pvt.insert_cceoierror

6518: , p_message_name => 'INV_DEVIATION_CHECK_ERR');
6519: RAISE fnd_api.g_exc_error;
6520: ELSIF x_errorcode = 52 THEN
6521: -- Write INTO interface error TABLE
6522: mtl_cceoi_process_pvt.insert_cceoierror
6523: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6524: , p_error_column_name => 'SECONDARY_COUNT_QUANTITY'
6525: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
6526: , p_message_name => 'INV_CCEOI_NEG_QTY');

Line 6539: mtl_cceoi_process_pvt.insert_cceoierror

6535: IF (l_debug = 1) THEN
6536: mdebug ('Invalid count_type_code');
6537: END IF;
6538:
6539: mtl_cceoi_process_pvt.insert_cceoierror
6540: (p_cc_entry_interface_id => mtl_cceoi_var_pvt.g_cc_entry_interface_id
6541: , p_error_column_name => 'unexpected error'
6542: , p_error_table_name => 'unexpected error'
6543: , p_message_name => 'unexpected error');

Line 6577: END MTL_CCEOI_PROCESS_PVT;

6573: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6574: END validate_secondaryuomqty;
6575: -- END INVCONV
6576:
6577: END MTL_CCEOI_PROCESS_PVT;