APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_CYCLE_COUNT_HEADERS

Line 968: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_OPTION_CODE

964: -- MTL_CCEOI_VAR_PVT.G_SYSTEM_QUANTITY
965: -- MTL_CYCLE_COUNT_ENTRIES.SYSTEM_QUANTITY_CURRENT
966: --
967: -- p_approval_option_code IN NUMBER (required)
968: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_OPTION_CODE
969: --
970: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%rowtype
971: --
972: -- p_simulate IN varchar2 (default)

Line 1659: -- FROM TABLE MTL_CYCLE_COUNT_HEADERS

1655: -- p_serial_number_control_code IN NUMBER (required)
1656: -- FROM TABLE MTL_SYSTEM_ITEMS
1657: --
1658: -- p_serial_count_option IN NUMBER (required)
1659: -- FROM TABLE MTL_CYCLE_COUNT_HEADERS
1660: --
1661: -- p_system_quantity in number (required - defaulted)
1662: -- default null
1663: --

Line 2091: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_POSITIVE

2087: -- p_class_cost_tol_neg IN NUMBER (required)
2088: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_NEG
2089: --
2090: -- p_head_app_tol_pos IN NUMBER (required)
2091: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_POSITIVE
2092: --
2093: -- p_head_app_tol_neg IN NUMBER (required)
2094: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_NEGATIVE
2095: --

Line 2094: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_NEGATIVE

2090: -- p_head_app_tol_pos IN NUMBER (required)
2091: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_POSITIVE
2092: --
2093: -- p_head_app_tol_neg IN NUMBER (required)
2094: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_NEGATIVE
2095: --
2096: -- p_head_cost_tol_pos IN NUMBER (required)
2097: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_POSITIVE
2098: --

Line 2097: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_POSITIVE

2093: -- p_head_app_tol_neg IN NUMBER (required)
2094: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_NEGATIVE
2095: --
2096: -- p_head_cost_tol_pos IN NUMBER (required)
2097: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_POSITIVE
2098: --
2099: -- p_head_cost_tol_neg IN NUMBER (required)
2100: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_NEGATIVE
2101: --

Line 2100: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_NEGATIVE

2096: -- p_head_cost_tol_pos IN NUMBER (required)
2097: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_POSITIVE
2098: --
2099: -- p_head_cost_tol_neg IN NUMBER (required)
2100: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_NEGATIVE
2101: --
2102: -- p_simulate NUMBER (default = FND_API.G_FALSE)
2103: -- G_FALSE = allow changes to tables other than interface tables
2104: -- G_TRUE = no changes will be made to any outside tables

Line 3602: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3603: , p_message_name => 'INV_CCEOI_INVALID_HEADER'
3604: );
3605: ELSIF
3606: x_errorcode = 1 THEN

Line 3611: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3613: );
3614: ELSIF
3615: x_errorcode = 45 THEN

Line 3620: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3622: );
3623: ELSIF x_errorcode = 0 THEN
3624: -- Get stock_locator_control

Line 3789: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3791: );
3792: RAISE FND_API.G_EXC_ERROR;
3793: ELSIF x_errorcode in (65,66) THEN

Line 3806: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3808: );
3809: RAISE FND_API.G_EXC_ERROR;
3810: ELSIF

Line 5219: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
5221: );
5222: --
5223: RAISE FND_API.G_EXC_ERROR;

Line 5229: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
5231: );
5232: --
5233: RAISE FND_API.G_EXC_ERROR;

Line 5238: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
5240: );
5241: --
5242: RAISE FND_API.G_EXC_ERROR;