[Home] [Help]
64: NULL user_defined_ship_num_code, -- from inl_parameters (AUTOMATIC or MANUAL)
65: NULL manual_ship_num_type, -- from inl_parameters (NUMERIC or ALPHA)
66: NULL LCM_FLOW, -- can be AAS=as a service PR= pre receiving
67: NULL dflt_country
68: FROM inl_ship_headers_int h
69: WHERE h.request_id = l_fnd_conc_request_id_int
70: ORDER BY h.organization_id -- Bug 16310024
71: ;
72:
356: WHERE match_int_id = p_parent_table_id
357: AND processing_status_code <> 'ERROR';
358: */
359: END IF;
360: IF p_parent_table_name = 'INL_SHIP_HEADERS_INT'
361: OR l_ship_header_int_id IS NOT NULL
362: THEN
363: l_debug_info := 'Set Shipment Header Interface status to ERROR.';
364: INL_LOGGING_PVT.Log_Statement(
365: p_module_name => g_module_name,
366: p_procedure_name => l_program_name,
367: p_debug_info => l_debug_info) ;
368:
369: UPDATE inl_ship_headers_int
370: SET processing_status_code = 'ERROR' ,
371: request_id = L_FND_CONC_REQUEST_ID,
372: last_updated_by = L_FND_USER_ID ,
373: last_update_date = SYSDATE ,
807: ELSIF x_ship_num IS NOT NULL AND p_transaction_type = 'UPDATE' THEN
808: BEGIN
809: SELECT sh.ship_header_id
810: INTO x_ship_header_id
811: FROM inl_ship_headers_all sh --Bug#10381495
812: WHERE sh.ship_num = x_ship_num
813: AND sh.organization_id = p_organization_id;
814: EXCEPTION
815: WHEN OTHERS THEN
812: WHERE sh.ship_num = x_ship_num
813: AND sh.organization_id = p_organization_id;
814: EXCEPTION
815: WHEN OTHERS THEN
816: l_debug_info := 'Ship Num: ' || x_ship_num || ' not found in inl_ship_headers';
817: INL_LOGGING_PVT.Log_Statement(
818: p_module_name => g_module_name,
819: p_procedure_name => l_program_name,
820: p_debug_info => l_debug_info);
820: p_debug_info => l_debug_info);
821: l_result := L_FND_FALSE;
822: -- Add a line into inl_ship_errors
823: Handle_InterfError(
824: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
825: p_parent_table_id => p_ship_header_int_id,
826: p_column_name => 'SHIP_NUM',
827: p_column_value => x_ship_num,
828: p_error_message_name => 'INL_ERR_NO_SHIP_NUM',
853:
854: l_result := L_FND_FALSE;
855: -- Add a line into inl_ship_errors
856: Handle_InterfError(
857: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
858: p_parent_table_id => p_ship_header_int_id,
859: p_column_name => 'ORGANIZATION_ID',
860: p_column_value => p_organization_id,
861: p_error_message_name => 'INL_ERR_IMPORT_SHIP_NUM_GEN',
891:
892: l_result := L_FND_FALSE;
893: -- Add a line into inl_ship_errors
894: Handle_InterfError(
895: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
896: p_parent_table_id => p_ship_header_int_id,
897: p_column_name => 'SHIP_NUM',
898: p_column_value => p_ship_num,
899: p_error_message_name => 'INL_ERR_SHIP_NUM_NULL',
908: AND p_organization_id IS NOT NULL
909: THEN
910: SELECT COUNT(1)
911: INTO l_count_ship_num_exist
912: FROM inl_ship_headers_all sh --Bug#10381495
913: WHERE sh.ship_num = p_ship_num
914: AND sh.organization_id = p_organization_id;
915:
916: INL_LOGGING_PVT.Log_Variable(
928:
929: l_result := L_FND_FALSE;
930: -- Add a line into inl_ship_errors
931: Handle_InterfError(
932: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
933: p_parent_table_id => p_ship_header_int_id,
934: p_column_name => 'SHIP_NUM',
935: p_column_value => p_ship_num,
936: p_error_message_name => 'INL_ERR_SHIP_NUM',
969:
970: l_result := L_FND_FALSE;
971: -- Add a line into inl_ship_errors
972: Handle_InterfError(
973: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
974: p_parent_table_id => p_ship_header_int_id,
975: p_column_name => 'SHIP_NUM',
976: p_column_value => p_ship_num,
977: p_error_message_name => 'INL_SHIPMENT_NUMERIC',
997: p_debug_info => l_debug_info) ;
998: l_result := L_FND_FALSE;
999: -- Add a line into inl_ship_errors
1000: Handle_InterfError(
1001: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1002: p_parent_table_id => p_ship_header_int_id,
1003: p_column_name => 'USER_DEF_SHIP_NUM_CODE',
1004: p_column_value => 'AUTOMATIC',
1005: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
1005: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
1006: p_token1_name => 'COLUMN',
1007: p_token1_value => 'SHIP_NUM',
1008: p_token2_name => 'ID_NAME',
1009: p_token2_value => 'INL_SHIP_HEADERS_INT',
1010: p_token3_name => 'ID_VAL',
1011: p_token3_value => p_ship_header_int_id,
1012: x_return_status => l_return_status);
1013: -- If any errors happen abort API.
1181: l_result := L_FND_FALSE;
1182:
1183: -- Add a line into inl_ship_errors
1184: Handle_InterfError(
1185: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1186: p_parent_table_id => p_ship_header_int_id,
1187: p_column_name => 'SHIP_TYPE_ID',
1188: p_column_value => x_ship_type_id,
1189: p_error_message_name => 'INL_ERR_SHIP_TYPE_CLOSED',
1206: l_result := L_FND_FALSE;
1207:
1208: -- Add a line into inl_ship_errors
1209: Handle_InterfError(
1210: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1211: p_parent_table_id => p_ship_header_int_id,
1212: p_column_name => 'SHIP_TYPE_ID',
1213: p_column_value => x_ship_type_id,
1214: p_error_message_name => 'INL_ERR_NO_SHIP_LN_TYPE',
1231: l_result := L_FND_FALSE;
1232:
1233: -- Add a line into inl_ship_errors
1234: Handle_InterfError(
1235: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1236: p_parent_table_id => p_ship_header_int_id,
1237: p_column_name => 'SHIP_TYPE_ID',
1238: p_column_value => x_ship_type_id,
1239: p_error_message_name => 'INL_ERR_NO_SRC_TYPE',
1266: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1267: WHEN OTHERS THEN
1268: -- Add a line into inl_ship_errors
1269: Handle_InterfError(
1270: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1271: p_parent_table_id => p_ship_header_int_id,
1272: p_column_name => l_column_name,
1273: p_column_value => l_column_value,
1274: p_error_message_name => 'INL_ERR_SHIP_TP',
2637: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2638: WHEN OTHERS THEN
2639: -- Add a line into inl_ship_errors
2640: Handle_InterfError(
2641: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
2642: p_parent_table_id => p_ship_line_int_id,
2643: p_column_name => l_column_name,
2644: p_column_value => l_column_value,
2645: p_error_message_name => 'INL_ERR_LN_TP',
4284: l_column_value := p_ship_header_id;
4285:
4286: SELECT organization_id
4287: INTO x_organization_id
4288: FROM inl_ship_headers_all
4289: WHERE ship_header_id = p_ship_header_id;
4290:
4291: END IF;
4292: INL_LOGGING_PVT.Log_Variable(
4382:
4383: l_result := L_FND_FALSE;
4384: -- Add a line into inl_ship_errors
4385: Handle_InterfError(
4386: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
4387: p_parent_table_id => p_ship_header_int_id,
4388: p_column_name => 'ORGANIZATION_ID',
4389: p_column_value => x_organization_id,
4390: p_error_message_name => 'INL_ERR_NO_LCM_OPT_DEF_ORG',
4409:
4410: l_result := L_FND_FALSE;
4411: -- Add a line into inl_ship_errors
4412: Handle_InterfError(
4413: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
4414: p_parent_table_id => p_ship_header_int_id,
4415: p_column_name => 'ORGANIZATION_ID',
4416: p_column_value => x_organization_id,
4417: p_error_message_name => 'INL_ERR_NO_OP_UNIT_DEF',
4447: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4448: WHEN OTHERS THEN
4449: -- Add a line into inl_ship_errors
4450: Handle_InterfError(
4451: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
4452: p_parent_table_id => p_ship_header_int_id,
4453: p_column_name => l_column_name,
4454: p_column_value => l_column_value,
4455: p_error_message_name => 'INL_ERR_INVL_INV_ORG',
4662: l_result := L_FND_FALSE;
4663:
4664: -- Add a line into inl_ship_errors
4665: Handle_InterfError(
4666: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
4667: p_parent_table_id => p_ship_header_int_id,
4668: p_column_name => 'LOCATION_ID',
4669: p_column_value => x_location_id,
4670: p_error_message_name => 'INL_ERR_NO_LOCATION_INV_ORG',
4686: l_result := L_FND_FALSE;
4687:
4688: -- Add a line into inl_ship_errors
4689: Handle_InterfError(
4690: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
4691: p_parent_table_id => p_ship_header_int_id,
4692: p_column_name => 'LOCATION_ID',
4693: p_column_value => x_location_id,
4694: p_error_message_name => 'INL_ERR_COUNTRY_LOCATION',
4724: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4725: WHEN OTHERS THEN
4726: -- Add a line into inl_ship_errors
4727: Handle_InterfError(
4728: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
4729: p_parent_table_id => p_ship_header_int_id,
4730: p_column_name => l_column_name,
4731: p_column_value => l_column_value,
4732: p_error_message_name => 'INL_ERR_LOCATION_INV',
5025: p_token1_value => 'INL_SHIP_LINES_INT',
5026: p_token2_name => 'ID_VAL1',
5027: p_token2_value => l_ship_line_int_id,
5028: p_token3_name => 'ID_NAME2',
5029: p_token3_value => 'INL_SHIP_HEADERS_INT',
5030: p_token4_name => 'ID_VAL2',
5031: p_token4_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_header_int_id,
5032: x_return_status => l_return_status) ;
5033: -- If any errors happen abort API.
6050: IF l_ship_line_src_type_code NOT IN ('PO', 'IR', 'RMA') THEN
6051: l_response := FALSE;
6052: -- Add a line into inl_ship_errors
6053: Handle_InterfError(
6054: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6055: p_parent_table_id => p_ship_header_int_id,
6056: p_column_name => 'RCV_ENABLED_FLAG',
6057: p_column_value => p_rcv_enabled_flag,
6058: p_error_message_name => 'INL_ERR_RECEIVED_SRC_LN_TYP',
6058: p_error_message_name => 'INL_ERR_RECEIVED_SRC_LN_TYP',
6059: p_token1_name => 'SHIP_LN_SRC_TYPE_CODE',
6060: p_token1_value => l_ship_line_src_type_code,
6061: p_token2_name => 'ID_NAME',
6062: p_token2_value => 'INL_SHIP_HEADERS_INT',
6063: p_token3_name => 'ID_VAL',
6064: p_token3_value => p_ship_header_int_id,
6065: x_return_status => l_return_status) ;
6066: -- If unexpected errors happen abort
6071: ELSIF p_rcv_enabled_flag <> 'N' THEN
6072: l_response := FALSE;
6073: -- Add a line into inl_ship_errors
6074: Handle_InterfError(
6075: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6076: p_parent_table_id => p_ship_header_int_id,
6077: p_column_name => 'RCV_ENABLED_FLAG',
6078: p_column_value => p_rcv_enabled_flag,
6079: p_error_message_name => 'INL_ERR_RCV_ENABLED_FLAG_INV',
6077: p_column_name => 'RCV_ENABLED_FLAG',
6078: p_column_value => p_rcv_enabled_flag,
6079: p_error_message_name => 'INL_ERR_RCV_ENABLED_FLAG_INV',
6080: p_token1_name => 'ID_NAME',
6081: p_token1_value => 'INL_SHIP_HEADERS_INT',
6082: p_token2_name => 'ID_VAL',
6083: p_token2_value => p_ship_header_int_id,
6084: x_return_status => l_return_status) ;
6085: -- If unexpected errors happen abort
6236: IF p_ship_date IS NULL THEN
6237: l_response := FALSE;
6238: -- Add a line into inl_ship_errors
6239: Handle_InterfError(
6240: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6241: p_parent_table_id => p_ship_header_int_id,
6242: p_column_name => 'TRANSACTION_TYPE',
6243: p_column_value => 'CREATE',
6244: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6244: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6245: p_token1_name => 'COLUMN',
6246: p_token1_value => 'SHIP_DATE',
6247: p_token2_name => 'ID_NAME',
6248: p_token2_value => 'INL_SHIP_HEADERS_INT',
6249: p_token3_name => 'ID_VAL',
6250: p_token3_value => p_ship_header_int_id,
6251: x_return_status => l_return_status) ;
6252: -- If any errors happen abort API.
6260: IF p_last_task_code IS NULL THEN
6261: l_response := FALSE;
6262: -- Add a line into inl_ship_errors
6263: Handle_InterfError(
6264: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6265: p_parent_table_id => p_ship_header_int_id,
6266: p_column_name => 'TRANSACTION_TYPE',
6267: p_column_value => 'CREATE',
6268: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6268: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6269: p_token1_name => 'COLUMN',
6270: p_token1_value => 'LAST_TASK_CODE',
6271: p_token2_name => 'ID_NAME',
6272: p_token2_value => 'INL_SHIP_HEADERS_INT',
6273: p_token3_name => 'ID_VAL',
6274: p_token3_value => p_ship_header_int_id,
6275: x_return_status => l_return_status) ;
6276: -- If any errors happen abort API.
6282: ELSIF p_last_task_code NOT IN ('10', '20', '30', '40', '50', '60') THEN
6283: l_response := FALSE;
6284: -- Add a line into inl_ship_errors
6285: Handle_InterfError(
6286: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6287: p_parent_table_id => p_ship_header_int_id,
6288: p_column_name => 'LAST_TASK_CODE',
6289: p_column_value => p_last_task_code,
6290: p_error_message_name => 'INL_OI_LAST_TASK_CODE_INVL',
6303: p_ship_type_code IS NULL THEN
6304: l_response := FALSE;
6305: -- Add a line into inl_ship_errors
6306: Handle_InterfError(
6307: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6308: p_parent_table_id => p_ship_header_int_id,
6309: p_column_name => 'TRANSACTION_TYPE',
6310: p_column_value => 'CREATE',
6311: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6311: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6312: p_token1_name => 'COLUMN',
6313: p_token1_value => 'SHIP_TYPE_ID OR SHIP_TYPE_CODE',
6314: p_token2_name => 'ID_NAME',
6315: p_token2_value => 'INL_SHIP_HEADERS_INT',
6316: p_token3_name => 'ID_VAL',
6317: p_token3_value => p_ship_header_int_id,
6318: x_return_status => l_return_status) ;
6319: -- If any errors happen abort API.
6328: p_organization_code IS NULL THEN
6329: l_response := FALSE;
6330: -- Add a line into inl_ship_errors
6331: Handle_InterfError(
6332: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6333: p_parent_table_id => p_ship_header_int_id,
6334: p_column_name => 'TRANSACTION_TYPE',
6335: p_column_value => 'CREATE',
6336: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6336: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6337: p_token1_name => 'COLUMN',
6338: p_token1_value => 'ORGANIZATION_ID or ORGANIZATION_CODE',
6339: p_token2_name => 'ID_NAME',
6340: p_token2_value => 'INL_SHIP_HEADERS_INT',
6341: p_token3_name => 'ID_VAL',
6342: p_token3_value => p_ship_header_int_id,
6343: x_return_status => l_return_status) ;
6344: -- If any errors happen abort API.
6352: IF p_rcv_enabled_flag IS NULL THEN
6353: l_response := FALSE;
6354: -- Add a line into inl_ship_errors
6355: Handle_InterfError(
6356: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6357: p_parent_table_id => p_ship_header_int_id,
6358: p_column_name => 'TRANSACTION_TYPE',
6359: p_column_value => 'CREATE',
6360: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6360: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6361: p_token1_name => 'COLUMN',
6362: p_token1_value => 'RCV_ENABLED_FLAG',
6363: p_token2_name => 'ID_NAME',
6364: p_token2_value => 'INL_SHIP_HEADERS_INT',
6365: p_token3_name => 'ID_VAL',
6366: p_token3_value => p_ship_header_int_id,
6367: x_return_status => l_return_status) ;
6368: -- If any errors happen abort API.
6407: IF p_ship_header_id IS NOT NULL THEN
6408: l_response := FALSE;
6409: -- Add a line into inl_ship_errors
6410: Handle_InterfError(
6411: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6412: p_parent_table_id => p_ship_header_int_id,
6413: p_column_name => 'TRANSACTION_TYPE',
6414: p_column_value => 'CREATE',
6415: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
6415: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
6416: p_token1_name => 'COLUMN',
6417: p_token1_value => 'SHIP_HEADER_ID',
6418: p_token2_name => 'ID_NAME',
6419: p_token2_value => 'INL_SHIP_HEADERS_INT',
6420: p_token3_name => 'ID_VAL',
6421: p_token3_value => p_ship_header_int_id,
6422: x_return_status => l_return_status) ;
6423: -- If any errors happen abort API.
6579: SELECT
6580: sh.ship_status_code
6581: INTO
6582: l_ship_status_code
6583: FROM inl_ship_headers_all sh --Bug#10381495
6584: WHERE sh.ship_header_id = x_ship_header_id;
6585: x_ship_num := NULL;
6586: EXCEPTION
6587: WHEN NO_DATA_FOUND THEN
6584: WHERE sh.ship_header_id = x_ship_header_id;
6585: x_ship_num := NULL;
6586: EXCEPTION
6587: WHEN NO_DATA_FOUND THEN
6588: l_debug_info := 'x_ship_header_id: ' || x_ship_header_id || ' not found in inl_ship_headers_all';
6589: INL_LOGGING_PVT.Log_Statement(
6590: p_module_name => g_module_name,
6591: p_procedure_name => l_program_name,
6592: p_debug_info => l_debug_info);
6592: p_debug_info => l_debug_info);
6593: l_response := FALSE;
6594: -- Add a line into inl_ship_errors
6595: Handle_InterfError(
6596: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6597: p_parent_table_id => p_ship_header_int_id,
6598: p_column_name => 'TRANSACTION_TYPE',
6599: p_column_value => 'UPDATE',
6600: p_error_message_name => 'INL_ERR_OI_CHK_SHIP_HEADER_ID',
6598: p_column_name => 'TRANSACTION_TYPE',
6599: p_column_value => 'UPDATE',
6600: p_error_message_name => 'INL_ERR_OI_CHK_SHIP_HEADER_ID',
6601: p_token1_name => 'NAME',
6602: p_token1_value => 'INL_SHIP_HEADERS_INT',
6603: p_token2_name => 'ID',
6604: p_token2_value => p_ship_header_int_id,
6605: x_return_status => l_return_status);
6606: -- If any errors happen abort API.
6616: THEN
6617: l_response := FALSE;
6618: -- Add a line into inl_ship_errors
6619: Handle_InterfError(
6620: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6621: p_parent_table_id => p_ship_header_int_id,
6622: p_column_name => 'TRANSACTION_TYPE',
6623: p_column_value => 'UPDATE',
6624: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6624: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
6625: p_token1_name => 'COLUMN',
6626: p_token1_value => 'SHIP_HEADER_ID OR SHIP_NUM+ORG',
6627: p_token2_name => 'ID_NAME',
6628: p_token2_value => 'INL_SHIP_HEADERS_INT',
6629: p_token3_name => 'ID_VAL',
6630: p_token3_value => p_ship_header_int_id,
6631: x_return_status => l_return_status) ;
6632: -- If any errors happen abort API.
6648: sh.ship_header_id
6649: INTO
6650: l_ship_status_code,
6651: x_ship_header_id
6652: FROM inl_ship_headers_all sh --Bug#10381495
6653: WHERE sh.ship_num = x_ship_num
6654: AND organization_id = l_organization_id;
6655: EXCEPTION
6656: WHEN NO_DATA_FOUND THEN
6662: p_debug_info => l_debug_info);
6663: l_response := FALSE;
6664: -- Add a line into inl_ship_errors
6665: Handle_InterfError(
6666: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6667: p_parent_table_id => p_ship_header_int_id,
6668: p_column_name => 'TRANSACTION_TYPE',
6669: p_column_value => 'UPDATE',
6670: p_error_message_name => 'INL_ERR_NO_SHIP_NUM',
6703:
6704: l_response := FALSE;
6705: -- Add a line into inl_ship_errors
6706: Handle_InterfError(
6707: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6708: p_parent_table_id => p_ship_header_int_id,
6709: p_column_name => 'TRANSACTION_TYPE',
6710: p_column_value => 'UPDATE',
6711: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_STA_INVL',
6726: p_ship_type_code IS NOT NULL THEN
6727: l_response := FALSE;
6728: -- Add a line into inl_ship_errors
6729: Handle_InterfError(
6730: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6731: p_parent_table_id => p_ship_header_int_id,
6732: p_column_name => 'TRANSACTION_TYPE',
6733: p_column_value => 'UPDATE',
6734: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
6734: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
6735: p_token1_name => 'COLUMN',
6736: p_token1_value => 'SHIP_TYPE_ID AND SHIP_TYPE_CODE',
6737: p_token2_name => 'ID_NAME',
6738: p_token2_value => 'INL_SHIP_HEADERS_INT',
6739: p_token3_name => 'ID_VAL',
6740: p_token3_value => p_ship_header_int_id,
6741: x_return_status => l_return_status) ;
6742: -- If any errors happen abort API.
6751: p_location_code IS NOT NULL THEN
6752: l_response := FALSE;
6753: -- Add a line into inl_ship_errors
6754: Handle_InterfError(
6755: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6756: p_parent_table_id => p_ship_header_int_id,
6757: p_column_name => 'TRANSACTION_TYPE',
6758: p_column_value => 'UPDATE',
6759: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
6759: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
6760: p_token1_name => 'COLUMN',
6761: p_token1_value => 'LOCATION_ID AND LOCATION_CODE',
6762: p_token2_name => 'ID_NAME',
6763: p_token2_value => 'INL_SHIP_HEADERS_INT',
6764: p_token3_name => 'ID_VAL',
6765: p_token3_value => p_ship_header_int_id,
6766: x_return_status => l_return_status) ;
6767: -- If any errors happen abort API.
6775: IF p_rcv_enabled_flag IS NOT NULL THEN
6776: l_response := FALSE;
6777: -- Add a line into inl_ship_errors
6778: Handle_InterfError(
6779: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
6780: p_parent_table_id => p_ship_header_int_id,
6781: p_column_name => 'TRANSACTION_TYPE',
6782: p_column_value => 'UPDATE',
6783: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
6783: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
6784: p_token1_name => 'COLUMN',
6785: p_token1_value => 'RCV_ENABLED_FLAG',
6786: p_token2_name => 'ID_NAME',
6787: p_token2_value => 'INL_SHIP_HEADERS_INT',
6788: p_token3_name => 'ID_VAL',
6789: p_token3_value => p_ship_header_int_id,
6790: x_return_status => l_return_status) ;
6791: -- If any errors happen abort API.
7169: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7170: p_token1_name => 'COLUMN',
7171: p_token1_value => 'SHIP_LINE_TYPE_ID AND SHIP_LINE_TYPE_CODE',
7172: p_token2_name => 'ID_NAME',
7173: p_token2_value => 'INL_SHIP_HEADERS_INT',
7174: p_token3_name => 'ID_VAL',
7175: p_token3_value => l_ship_line_int_id,
7176: x_return_status => l_return_status) ;
7177: -- If any errors happen abort API.
7712: p_debug_info => l_debug_info);
7713: l_response := FALSE;
7714: -- Add a line into inl_ship_errors
7715: Handle_InterfError(
7716: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
7717: p_parent_table_id => p_ship_header_int_id,
7718: p_column_name => NULL,
7719: p_column_value => NULL,
7720: p_error_message_name => 'INL_ERR_ALL_PROCESSING_STATUS',
7718: p_column_name => NULL,
7719: p_column_value => NULL,
7720: p_error_message_name => 'INL_ERR_ALL_PROCESSING_STATUS',
7721: p_token1_name => 'ID_NAME',
7722: p_token1_value => 'INL_SHIP_HEADERS_INT',
7723: p_token2_name => 'ID_VAL',
7724: p_token2_value => p_ship_header_int_id,
7725: x_return_status => l_return_status) ;
7726: -- If any errors happen abort API.
7826: p_debug_info => l_debug_info);
7827: l_response := FALSE;
7828: -- Add a line into inl_ship_errors
7829: Handle_InterfError(
7830: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
7831: p_parent_table_id => p_ship_header_int_id,
7832: p_column_name => NULL,
7833: p_column_value => NULL,
7834: p_error_message_name => 'INL_ERR_ALL_SRC_TYPE',
7832: p_column_name => NULL,
7833: p_column_value => NULL,
7834: p_error_message_name => 'INL_ERR_ALL_SRC_TYPE',
7835: p_token1_name => 'ID_NAME',
7836: p_token1_value => 'INL_SHIP_HEADERS_INT',
7837: p_token2_name => 'ID_VAL',
7838: p_token2_value => p_ship_header_int_id,
7839: x_return_status => l_return_status) ;
7840: -- If any errors happen abort API.
8096: -- Utility name : Delete_Ship
8097: -- Type : Private
8098: -- Function : Delete a LCM Shipment from inl_ship_holds, inl_associations, inl_matches, inl_match_amount
8099: -- inl_allocations, inl_tax_lines, inl_charge_lines,
8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all
8101: -- If a Charge/Tax is associated with more than one Shipment, only the associations
8102: -- of the current shipment are going to be deleted
8103: -- Pre-reqs : None
8104: -- Parameters :
8342: p_var_value => sql%rowcount
8343: );
8344:
8345: -- Table
8346: l_debug_info := 'Delete from inl_ship_headers_all';
8347: INL_LOGGING_PVT.Log_Statement(
8348: p_module_name => g_module_name,
8349: p_procedure_name => l_program_name,
8350: p_debug_info => l_debug_info) ;
8348: p_module_name => g_module_name,
8349: p_procedure_name => l_program_name,
8350: p_debug_info => l_debug_info) ;
8351:
8352: DELETE FROM inl_ship_headers_all
8353: WHERE ship_header_id = p_ship_header_id;
8354:
8355: INL_LOGGING_PVT.Log_Variable(
8356: p_module_name => g_module_name,
9233:
9234: -- Utility name : Import_Headers
9235: -- Type : Private
9236: -- Function : Import Shipment Headers from Interface
9237: -- table to INL_SHIP_HEADERS_ALL
9238: --
9239: -- Pre-reqs : None
9240: -- Parameters :
9241: -- IN : p_simulation_id IN NUMBER,
9291: p_module_name => g_module_name,
9292: p_procedure_name => l_program_name,
9293: p_debug_info => l_debug_info) ;
9294:
9295: UPDATE inl_ship_headers_all sh --Bug#10381495
9296: SET ship_date = NVL(x_ship_hdr_int_rec.ship_date ,sh.ship_date ),
9297: taxation_country = NVL(x_ship_hdr_int_rec.taxation_country ,sh.taxation_country ),
9298: document_sub_type = NVL(x_ship_hdr_int_rec.document_sub_type ,sh.document_sub_type ),
9299: ship_header_int_id = NVL(x_ship_hdr_int_rec.ship_header_int_id ,sh.ship_header_int_id ),
9334: p_debug_info => l_debug_info) ;
9335: -- Check if Shipment Number is setup as(AUTOMATIC or MANUAL)
9336: SELECT user_defined_ship_num_code,
9337: next_ship_num,
9338: inl_ship_headers_all_s.NEXTVAL
9339: INTO l_user_defined_ship_num_code,
9340: l_next_ship_num,
9341: x_ship_hdr_int_rec.ship_header_id
9342: FROM inl_parameters
9412: p_var_value => x_ship_hdr_int_rec.rcv_enabled_flag);
9413:
9414: -- Insert an INL SHIP HEADER record
9415: INSERT
9416: INTO inl_ship_headers_all ( --Bug#10381495
9417: ship_header_id ,-- 01
9418: ship_num ,-- 02
9419: ship_date ,-- 03
9420: ship_type_id ,-- 04
10017: x_nrec_tax_amt := NVL(x_nrec_tax_amt, 0) + NVL(l_mat_nrec_tax_amt_P, 0) ;
10018: END IF;
10019: END IF;
10020:
10021: IF x_new_to_parent_table_name = 'INL_SHIP_HEADERS' THEN
10022: SELECT ship_header_id
10023: INTO x_ship_header_id
10024: FROM inl_ship_headers_all --Bug#10381495
10025: WHERE ship_header_id = x_new_to_parent_table_id;
10020:
10021: IF x_new_to_parent_table_name = 'INL_SHIP_HEADERS' THEN
10022: SELECT ship_header_id
10023: INTO x_ship_header_id
10024: FROM inl_ship_headers_all --Bug#10381495
10025: WHERE ship_header_id = x_new_to_parent_table_id;
10026: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINES' THEN
10027: SELECT ship_header_id
10028: INTO x_ship_header_id
10437: -- SCM-051
10438: CURSOR c_shipToProcess(pc_group_id NUMBER)IS
10439: SELECT sh.ship_num
10440: FROM inl_ship_lines sl,
10441: inl_ship_headers sh,
10442: inl_matches_int mi,
10443: rcv_transactions rt
10444: WHERE sh.ship_header_id = sl.ship_header_id
10445: AND sl.ship_line_id = rt.lcm_shipment_line_id
11596: l_qty , --Bug#9660043
11597: l_uom_code --Bug#9660043
11598: FROM
11599: inl_ship_lines_all sl, --Bug#10381495
11600: inl_ship_headers_all sh, --Bug#9660043 --Bug#10381495
11601: inl_adj_ship_lines_v sla
11602: WHERE sl.ship_line_id = p_ship_line_id
11603: AND sh.ship_header_id = sl.ship_header_id --Bug#9660043
11604: AND sla.ship_header_id = sl.ship_header_id --Bug#9660043
11607: /* --Bug#9660043
11608: -- Get Organization_Id for UOM conversion purpose
11609: SELECT sh.organization_id
11610: INTO l_organization_id
11611: FROM inl_ship_headers sh
11612: WHERE sh.ship_header_id = l_ship_header_id;
11613: l_debug_info := 'Get from Adjustment View the TXN_QTY and TXN_UOM_CODE';
11614: INL_LOGGING_PVT.Log_Statement(
11615: p_module_name => g_module_name,
12383:
12384: INL_LOGGING_PVT.Log_Statement(
12385: p_module_name => g_module_name,
12386: p_procedure_name => l_program_name,
12387: p_debug_info => 'Verify if Ship Line has an ELC update to parent RCV_TRANSACTIONS with FOR UPDATE of inl_ship_headers');
12388:
12389: SELECT
12390: sl.new_currency_conversion_rate,
12391: sl.new_currency_conversion_date,
12400: l_ship_num -- SCM-051
12401: FROM
12402: rcv_transactions rt,
12403: inl_adj_ship_lines_v sl,
12404: inl_ship_headers_all sh -- SCM-051
12405: WHERE
12406: rt.transaction_id = p_to_parent_table_id
12407: AND sh.ship_header_id = sl.ship_header_id -- SCM-051
12408: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = rt.lcm_shipment_line_id
12411:
12412: INL_LOGGING_PVT.Log_Statement(
12413: p_module_name => g_module_name,
12414: p_procedure_name => l_program_name,
12415: p_debug_info => 'Verify if Ship Line has an ELC update to parent INL_SHIP_LINES with FOR UPDATE of inl_ship_headers');
12416:
12417: SELECT
12418: sl.new_currency_conversion_rate,
12419: sl.new_currency_conversion_date,
12427: l_new_txn_unit_price,
12428: l_ship_num
12429: FROM
12430: inl_adj_ship_lines_v sl,
12431: inl_ship_headers_all sh -- SCM-051
12432: WHERE
12433: sh.ship_header_id = sl.ship_header_id -- SCM-051
12434: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = p_to_parent_table_id
12435: FOR UPDATE of sh.ship_header_id NOWAIT; -- SCM-051
12498:
12499: INL_LOGGING_PVT.Log_Statement(
12500: p_module_name => g_module_name,
12501: p_procedure_name => l_program_name,
12502: p_debug_info => 'Select FOR UPDATE of inl_ship_headers');
12503:
12504: -- SCM-051
12505: SELECT sh.ship_num
12506: INTO l_ship_num
12503:
12504: -- SCM-051
12505: SELECT sh.ship_num
12506: INTO l_ship_num
12507: FROM inl_ship_headers_all sh,
12508: inl_ship_lines_all sl,
12509: rcv_transactions rt
12510: WHERE sh.ship_header_id = sl.ship_header_id
12511: AND rt.transaction_id = p_to_parent_table_id
12532: rt.transaction_id = p_to_parent_table_id
12533: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = rt.lcm_shipment_line_id
12534: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
12535: AND (
12536: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
12537: AND a.to_parent_table_id = sl.ship_header_id)
12538: OR
12539: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
12540: AND a.to_parent_table_id = sl.ship_line_group_id)
12571:
12572: -- SCM-051
12573: SELECT sh.ship_num
12574: INTO l_ship_num
12575: FROM inl_ship_headers_all sh,
12576: inl_ship_lines_all sl
12577: WHERE sh.ship_header_id = sl.ship_header_id
12578: AND sl.ship_line_id = p_to_parent_table_id
12579: AND ROWNUM = 1
12596: WHERE
12597: sl.ship_line_id = p_to_parent_table_id
12598: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
12599: AND (
12600: (a.to_parent_table_name = 'INL_SHIP_HEADERS'
12601: AND a.to_parent_table_id = sl.ship_header_id)
12602: OR
12603: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
12604: AND a.to_parent_table_id = sl.ship_line_group_id)
13172: p_var_name => 'p_match_type_code',
13173: p_var_value => p_match_type_code
13174: ) ;
13175:
13176: IF p_to_parent_table_name IN('INL_SHIP_HEADERS',
13177: 'INL_SHIP_LINES',
13178: 'INL_SHIP_LINE_GROUPS',
13179: 'INL_CHARGE_LINES',
13180: 'INL_TAX_LINES',
13181: 'RCV_TRANSACTIONS'
13182: )
13183: OR (p_transaction_type = 'CREATE'
13184: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',
13185: 'INL_SHIP_HEADERS_INT')
13186: )
13187: OR(p_match_type_code = 'CORRECTION'
13188: AND p_to_parent_table_name IN('AP_INVOICE_DISTRIBUTIONS')
13189: )
13189: )
13190: THEN
13191: l_nameOk := 'Y';
13192: BEGIN
13193: IF p_to_parent_table_name = 'INL_SHIP_HEADERS' THEN
13194:
13195: l_INT_importedOk := 'Y';
13196: SELECT ship_header_id
13197: INTO l_ship_header_id
13194:
13195: l_INT_importedOk := 'Y';
13196: SELECT ship_header_id
13197: INTO l_ship_header_id
13198: FROM inl_ship_headers_all --Bug#10381495
13199: WHERE ship_header_id = p_to_parent_table_id;
13200: IF p_match_type_code = 'CHARGE' THEN
13201: l_matchTpCdOk := 'Y';
13202: END IF;
13278: WHERE sl.ship_line_int_id = p_to_parent_table_id;
13279: l_INT_importedOk := 'Y';
13280: */--Bug#9660043
13281:
13282: ELSIF p_to_parent_table_name = 'INL_SHIP_HEADERS_INT' THEN
13283: --Bug#9660043
13284: IF p_match_type_code IN('CHARGE') THEN
13285: l_matchTpCdOk := 'Y';
13286: END IF;
13291: INTO
13292: l_ship_header_id,
13293: l_INT_importedOk
13294: FROM
13295: inl_ship_headers_int shi,
13296: inl_ship_headers_all sh --Bug#10381495
13297: WHERE
13298: shi.ship_header_int_id = p_to_parent_table_id
13299: AND sh.ship_header_int_id = p_to_parent_table_id
13292: l_ship_header_id,
13293: l_INT_importedOk
13294: FROM
13295: inl_ship_headers_int shi,
13296: inl_ship_headers_all sh --Bug#10381495
13297: WHERE
13298: shi.ship_header_int_id = p_to_parent_table_id
13299: AND sh.ship_header_int_id = p_to_parent_table_id
13300: ;
13301: --Bug#9660043
13302: /*--Bug#9660043
13303: SELECT shi.ship_header_id
13304: INTO l_ship_header_id
13305: FROM inl_ship_headers_int shi
13306: WHERE shi.ship_header_int_id = p_to_parent_table_id;
13307:
13308: IF p_match_type_code IN('CHARGE') THEN
13309: l_matchTpCdOk := 'Y';
13311:
13312: -- Check if the Interface record has been imported
13313: SELECT sh.ship_header_id
13314: INTO l_ship_header_id
13315: FROM inl_ship_headers sh
13316: WHERE sh.ship_header_int_id = p_to_parent_table_id;
13317: l_INT_importedOk := 'Y';
13318: */--Bug#9660043
13319:
15303: l_debug_info VARCHAR2(200);
15304:
15305: CURSOR c_shipToDelete IS
15306: SELECT shi.ship_header_int_id
15307: FROM inl_ship_headers_int shi
15308: WHERE (p_group_id IS NULL OR shi.group_id = p_group_id)
15309: AND processing_status_code = 'COMPLETED';
15310:
15311: TYPE shipToDelete_ListType IS TABLE OF c_shipToDelete%ROWTYPE;
15349: IF NVL(shipToDelete_List.COUNT, 0) > 0 THEN
15350: FOR iHead IN 1 .. shipToDelete_List.COUNT
15351: LOOP
15352:
15353: l_debug_info := 'Delete from INL_SHIP_HEADERS_INT ';
15354: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
15355: p_procedure_name => l_program_name,
15356: p_debug_info => l_debug_info);
15357:
15354: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
15355: p_procedure_name => l_program_name,
15356: p_debug_info => l_debug_info);
15357:
15358: DELETE FROM inl_ship_headers_int
15359: WHERE ship_header_int_id = shipToDelete_List(iHead).ship_header_int_id;
15360:
15361: l_debug_info := 'Delete from INL_SHIP_LINES_INT ';
15362: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
16111:
16112: RAISE FND_API.G_EXC_ERROR;
16113: END IF;
16114:
16115: UPDATE inl_ship_headers_int
16116: SET request_id = l_fnd_conc_request_id_int
16117: WHERE (nvl(request_id,1) > 0
16118: OR request_id = -1) --Bug#11794483B
16119: AND processing_status_code = 'PENDING'
16234: request_id /*19*/
16235: )
16236: SELECT
16237: inl_interface_errors_s.NEXTVAL, /*01*/
16238: 'INL_SHIP_HEADERS_INT', /*02*/
16239: h.ship_header_int_id, /*03*/
16240: 'ship_header_int_id', /*04*/
16241: h.ship_header_int_id, /*05*/
16242: SYSDATE, /*06*/
16252: L_FND_CONC_PROGRAM_ID, /*16*/
16253: L_FND_PROG_APPL_ID, /*17*/
16254: SYSDATE, /*18*/
16255: L_FND_CONC_REQUEST_ID /*19*/
16256: FROM inl_ship_headers_int h
16257: WHERE NVL(h.request_id,1) > 0
16258: AND h.processing_status_code = 'PENDING'
16259: AND h.transaction_type = 'CREATE'
16260: AND NOT EXISTS
16276: p_debug_info => l_debug_info) ;
16277:
16278:
16279:
16280: UPDATE inl_ship_headers_int h
16281: SET h.processing_status_code = 'ERROR' ,
16282: h.request_id = L_FND_CONC_REQUEST_ID,
16283: h.last_updated_by = L_FND_USER_ID ,
16284: h.last_update_date = SYSDATE ,
16483: p_var_name => 'l_response',
16484: p_var_value => l_debug_info);
16485: -- Add a line into inl_ship_errors
16486: Handle_InterfError(
16487: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
16488: p_parent_table_id => x_ship_hdr_int_rec.ship_header_int_id,
16489: p_column_name => 'VALIDATION_FLAG',
16490: p_column_value => x_ship_hdr_int_rec.validation_flag,
16491: p_error_message_name => 'INL_ERR_VALIDATION_FLAG_INV',
16818: CURSOR c_ship_hdr_int_err
16819: IS
16820: SELECT
16821: ship_header_int_id
16822: FROM inl_ship_headers_int h
16823: WHERE request_id = l_fnd_conc_request_id_int
16824: AND processing_status_code = 'PENDING';
16825:
16826: TYPE ship_hdr_int_err_list_type
17089: p_var_name => 'l_ship_hdr_int_list('||l_ship_hdr_int_idx||')rcv_enabled_flag',
17090: p_var_value => l_ship_hdr_int_list(l_ship_hdr_int_idx).rcv_enabled_flag) ;
17091:
17092: Reset_InterfError(
17093: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
17094: p_parent_table_id => l_ship_hdr_int_list(l_ship_hdr_int_idx).ship_header_int_id,
17095: x_return_status => l_return_status
17096: );
17097: -- If any errors happen abort API.
17322: p_module_name => g_module_name,
17323: p_procedure_name => l_program_name,
17324: p_debug_info => l_debug_info);
17325:
17326: UPDATE inl_ship_headers_int
17327: SET processing_status_code = 'COMPLETED' ,
17328: request_id = L_FND_CONC_REQUEST_ID ,
17329: last_updated_by = L_FND_USER_ID ,
17330: last_update_date = SYSDATE ,
17335: ship_header_id = l_ship_hdr_int_list(l_ship_hdr_int_idx).ship_header_id
17336: WHERE ship_header_int_id = l_ship_hdr_int_list(l_ship_hdr_int_idx).ship_header_int_id;
17337: ELSE
17338: Handle_InterfError(
17339: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
17340: p_parent_table_id => l_ship_hdr_int_list(l_ship_hdr_int_idx).ship_header_int_id,
17341: p_column_name => 'ship_header_int_id('||l_ship_hdr_int_idx||')',
17342: p_column_value => l_ship_hdr_int_list(l_ship_hdr_int_idx).ship_header_int_id,
17343: p_error_message_name => 'INL_FAILED_ON_CONC_SUB',
17365: WHEN OTHERS THEN
17366: -- IF L_commit_cycle = 'P' THEN
17367: ROLLBACK TO InlInterfacePvt_ILCMShip;
17368: Handle_InterfError(
17369: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
17370: p_parent_table_id => l_ship_hdr_int_list(l_ship_hdr_int_idx).ship_header_int_id,
17371: p_column_name => 'ship_header_int_id('||l_ship_hdr_int_idx||')',
17372: p_column_value => l_ship_hdr_int_list(l_ship_hdr_int_idx).ship_header_int_id,
17373: p_error_message_name => 'INL_FAILED_ON_CONC_SUB',
17413: p_debug_info => l_debug_info
17414: ) ;
17415: /*
17416: Handle_InterfError(
17417: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
17418: p_parent_table_id => 0,
17419: p_column_name => 'P_GROUP_ID',
17420: p_column_value => p_group_id,
17421: p_error_message_name => 'INL_NO_RECORDS_FOUND_ERR',
17448:
17449: FOR l_ship_hdr_int_idx IN 1 .. l_ship_hdr_int_err_list.COUNT
17450: LOOP
17451: Handle_InterfError(
17452: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
17453: p_parent_table_id => l_ship_hdr_int_err_list(l_ship_hdr_int_idx).ship_header_int_id,
17454: p_column_name => 'l_ship_hdr_int_err_list('||l_ship_hdr_int_idx||')',
17455: p_column_value => l_ship_hdr_int_err_list(l_ship_hdr_int_idx).ship_header_int_id,
17456: p_error_message_name => 'INL_FAILED_ON_CONC_SUB',
17463: END IF;
17464:
17465: -- Bug #8264427
17466: -- Interface records that got completed successfully are removed
17467: -- from INL_SHIP_HEADERS_INT and INL_SHIP_LINES_INT
17468: Purge_LCMShipInt(
17469: p_api_version => 1.0,
17470: p_init_msg_list => l_init_msg_list,
17471: p_commit => l_commit,
17639: INTO l_count_elc_pend_shipment
17640: FROM inl_matches_int m,
17641: rcv_transactions rt,
17642: inl_ship_lines_all sl,
17643: inl_ship_headers_all sh
17644: WHERE sh.ship_header_id = sl.ship_header_id
17645: AND sl.ship_line_id = rt.lcm_shipment_line_id
17646: AND rt.transaction_id = m.to_parent_table_id
17647: AND m.group_id = l_matches_int_error(i).group_id