APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1065: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_OPTION_CODE

1061: -- MTL_CCEOI_VAR_PVT.G_SYSTEM_QUANTITY
1062: -- MTL_CYCLE_COUNT_ENTRIES.SYSTEM_QUANTITY_CURRENT
1063: --
1064: -- p_approval_option_code IN NUMBER (required)
1065: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_OPTION_CODE
1066: --
1067: -- p_interface_rec IN MTL_CC_ENTRIES_INTERFACE%rowtype
1068: --
1069: -- p_simulate IN varchar2 (default)

Line 1756: -- FROM TABLE MTL_CYCLE_COUNT_HEADERS

1752: -- p_serial_number_control_code IN NUMBER (required)
1753: -- FROM TABLE MTL_SYSTEM_ITEMS
1754: --
1755: -- p_serial_count_option IN NUMBER (required)
1756: -- FROM TABLE MTL_CYCLE_COUNT_HEADERS
1757: --
1758: -- p_system_quantity in number (required - defaulted)
1759: -- default null
1760: --

Line 2209: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_POSITIVE

2205: -- p_class_cost_tol_neg IN NUMBER (required)
2206: -- MTL_CYCLE_COUNT_ENTRIES_V.CLASS_COST_TOL_NEG
2207: --
2208: -- p_head_app_tol_pos IN NUMBER (required)
2209: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_POSITIVE
2210: --
2211: -- p_head_app_tol_neg IN NUMBER (required)
2212: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_NEGATIVE
2213: --

Line 2212: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_NEGATIVE

2208: -- p_head_app_tol_pos IN NUMBER (required)
2209: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_POSITIVE
2210: --
2211: -- p_head_app_tol_neg IN NUMBER (required)
2212: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_NEGATIVE
2213: --
2214: -- p_head_cost_tol_pos IN NUMBER (required)
2215: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_POSITIVE
2216: --

Line 2215: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_POSITIVE

2211: -- p_head_app_tol_neg IN NUMBER (required)
2212: -- MTL_CYCLE_COUNT_HEADERS.APPROVAL_TOLERANCE_NEGATIVE
2213: --
2214: -- p_head_cost_tol_pos IN NUMBER (required)
2215: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_POSITIVE
2216: --
2217: -- p_head_cost_tol_neg IN NUMBER (required)
2218: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_NEGATIVE
2219: --

Line 2218: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_NEGATIVE

2214: -- p_head_cost_tol_pos IN NUMBER (required)
2215: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_POSITIVE
2216: --
2217: -- p_head_cost_tol_neg IN NUMBER (required)
2218: -- MTL_CYCLE_COUNT_HEADERS.COST_TOLERANCE_NEGATIVE
2219: --
2220: -- p_simulate NUMBER (default = FND_API.G_FALSE)
2221: -- G_FALSE = allow changes to tables other than interface tables
2222: -- G_TRUE = no changes will be made to any outside tables

Line 3743: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3744: , p_message_name => 'INV_CCEOI_INVALID_HEADER'
3745: );
3746: ELSIF
3747: x_errorcode = 1 THEN

Line 3752: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3754: );
3755: ELSIF
3756: x_errorcode = 45 THEN

Line 3761: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3763: );
3764: ELSIF x_errorcode = 0 THEN
3765: -- Get stock_locator_control

Line 3930: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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

Line 3947: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
3949: );
3950: RAISE FND_API.G_EXC_ERROR;
3951: ELSIF

Line 5391: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
5393: );
5394: --
5395: RAISE FND_API.G_EXC_ERROR;

Line 5401: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
5403: );
5404: --
5405: RAISE FND_API.G_EXC_ERROR;

Line 5410: , p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS'

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'
5412: );
5413: --
5414: RAISE FND_API.G_EXC_ERROR;