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.INL_INTERFACE_PVT dependencies on INL_SHIP_LINES_INT

Line 97: IF p_parent_table_name = 'INL_SHIP_LINES_INT' THEN

93: p_procedure_name => l_proc_name,
94: p_debug_info => l_debug_info
95: ) ;
96: -- In case of error during Shipment Line import process
97: IF p_parent_table_name = 'INL_SHIP_LINES_INT' THEN
98: l_debug_info := 'Set Shipment Line Interface status to ERROR.';
99: INL_LOGGING_PVT.LOG_STATEMENT(
100: P_MODULE_NAME => G_MODULE_NAME,
101: P_PROCEDURE_NAME => L_PROC_NAME,

Line 104: UPDATE inl_ship_lines_int

100: P_MODULE_NAME => G_MODULE_NAME,
101: P_PROCEDURE_NAME => L_PROC_NAME,
102: P_DEBUG_INFO => L_DEBUG_INFO
103: ) ;
104: UPDATE inl_ship_lines_int
105: SET processing_status_code = 'ERROR' ,
106: request_id = fnd_global.conc_request_id,
107: last_updated_by = fnd_global.user_id ,
108: last_update_date = SYSDATE ,

Line 117: FROM inl_ship_lines_int

113: WHERE ship_line_int_id = p_parent_table_id
114: AND processing_status_code <> 'ERROR';
115: SELECT ship_header_int_id
116: INTO l_ship_header_int_id
117: FROM inl_ship_lines_int
118: WHERE ship_line_int_id = p_parent_table_id;
119: ELSIF p_parent_table_name = 'INL_MATCHES_INT' THEN
120: l_debug_info := 'Set Match Interface status to ERROR.';
121: INL_LOGGING_PVT.Log_Statement(

Line 824: p_parent_table_name => 'INL_SHIP_LINES_INT',

820: WHEN OTHERS THEN
821: l_result := FND_API.G_FALSE;
822: -- Add a line into inl_ship_errors
823: Handle_InterfError(
824: p_parent_table_name => 'INL_SHIP_LINES_INT',
825: p_parent_table_id => p_ship_line_int_id,
826: p_column_name => 'SHIP_LINE_TYPE_ID',
827: p_column_value => p_ship_line_type_id,
828: p_error_message_name => 'INL_ERR_LN_TP',

Line 1401: FROM inl_ship_lines_int

1397: END IF;
1398: ELSE
1399: SELECT COUNT( *)
1400: INTO l_aux
1401: FROM inl_ship_lines_int
1402: WHERE ship_header_int_id = p_ship_header_int_id
1403: AND
1404: (
1405: ship_header_id IS NOT NULL

Line 1427: FROM inl_ship_lines_int

1423: -- Add a line into inl_ship_errors
1424: FOR c_lin_err IN
1425: (
1426: SELECT ship_line_int_id
1427: FROM inl_ship_lines_int
1428: WHERE ship_header_int_id = p_ship_header_int_id
1429: AND
1430: (
1431: ship_header_id IS NOT NULL

Line 1437: p_parent_table_name => 'INL_SHIP_LINES_INT',

1433: )
1434: )
1435: LOOP
1436: Handle_InterfError(
1437: p_parent_table_name => 'INL_SHIP_LINES_INT',
1438: p_parent_table_id => c_lin_err.ship_line_int_id,
1439: p_column_name => 'TRANSACTION_TYPE',
1440: p_column_value => p_transaction_type,
1441: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NNULL',

Line 1486: FROM inl_ship_lines_int a

1482: END IF;
1483: END IF;
1484: SELECT COUNT( *)
1485: INTO l_aux
1486: FROM inl_ship_lines_int a
1487: WHERE a.ship_header_int_id = p_ship_header_int_id
1488: AND a.ship_line_id IS NOT NULL
1489: AND NOT EXISTS
1490: (

Line 1535: FROM inl_ship_lines_int a

1531: END IF;
1532: -- Add a line into inl_ship_errors for each line
1533: FOR c_lin_err IN (
1534: SELECT ship_line_int_id
1535: FROM inl_ship_lines_int a
1536: WHERE a.ship_header_int_id = p_ship_header_int_id
1537: AND a.ship_line_id IS NOT NULL
1538: AND NOT EXISTS
1539: (

Line 1569: p_parent_table_name => 'INL_SHIP_LINES_INT',

1565: AND NVL(a.attribute15_lg, FND_API.G_MISS_CHAR) = NVL(g.attribute15, FND_API.G_MISS_CHAR)
1566: )
1567: ) LOOP
1568: Handle_InterfError(
1569: p_parent_table_name => 'INL_SHIP_LINES_INT',
1570: p_parent_table_id => c_lin_err.ship_line_int_id,
1571: p_column_name => 'TRANSACTION_TYPE',
1572: p_column_value => p_transaction_type,
1573: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_UPD_GRP',

Line 1613: FROM inl_ship_lines_int

1609: ELSE
1610: -- Check for all ids in lines
1611: SELECT COUNT( *)
1612: INTO l_aux
1613: FROM inl_ship_lines_int
1614: WHERE ship_header_int_id = p_ship_header_int_id
1615: AND (ship_header_id IS NULL
1616: OR ship_line_id IS NULL
1617: )

Line 1646: FROM inl_ship_lines_int

1642: END IF;
1643: -- Check for lines under a given interface header
1644: SELECT COUNT( *)
1645: INTO l_aux
1646: FROM inl_ship_lines_int
1647: WHERE ship_header_int_id = p_ship_header_int_id;
1648: -- Check if all lines were included into the Open Interface
1649: IF NVL(l_aux, 0) > 0 THEN
1650: SELECT COUNT( *)

Line 1657: FROM inl_ship_lines_int b

1653: WHERE a.ship_header_id = p_ship_header_id
1654: AND NOT EXISTS
1655: (
1656: SELECT 1
1657: FROM inl_ship_lines_int b
1658: WHERE b.ship_header_int_id = p_ship_header_int_id
1659: AND b.ship_header_id = a.ship_header_id
1660: AND b.ship_line_id = a.ship_line_id
1661: )

Line 2385: FROM inl_ship_lines_int l

2381: AND h.processing_status_code = 'RUNNING'
2382: AND (h.transaction_type = 'DELETE'
2383: OR EXISTS (
2384: SELECT 1
2385: FROM inl_ship_lines_int l
2386: WHERE l.ship_header_int_id = h.ship_header_int_id
2387: AND ROWNUM < 2
2388: )
2389: )

Line 2429: UPDATE inl_ship_lines_int

2425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2426: END IF;
2427: -- Set processing status code to 'COMPLETED' for all lines
2428: -- related to the current and imported Shipment Header
2429: UPDATE inl_ship_lines_int
2430: SET processing_status_code = 'COMPLETED' ,
2431: request_id = fnd_global.conc_request_id,
2432: last_updated_by = fnd_global.user_id ,
2433: last_update_date = SYSDATE ,

Line 2987: FROM inl_ship_lines_int l

2983: AND h.transaction_type <> 'DELETE'
2984: AND h.last_task_code >= '10'
2985: AND EXISTS (
2986: SELECT 1
2987: FROM inl_ship_lines_int l
2988: WHERE l.ship_header_int_id = h.ship_header_int_id
2989: AND l.processing_status_code = 'RUNNING'
2990: AND ROWNUM < 2
2991: );

Line 3343: UPDATE inl_ship_lines_int

3339: p_debug_info => l_debug_info
3340: ) ;
3341: -- Set processing status code to COMPLETED
3342: -- for a given and imported Shipment Line
3343: UPDATE inl_ship_lines_int
3344: SET processing_status_code = 'COMPLETED' ,
3345: ship_header_id = headersToProcess_List(iHead).ship_header_id,
3346: ship_line_id = l_ship_line_id ,
3347: request_id = fnd_global.conc_request_id ,

Line 4545: FROM inl_ship_lines_int

4541: poo_organization_id ,
4542: poo_to_organization_code ,
4543: poo_location_id ,
4544: poo_location_code
4545: FROM inl_ship_lines_int
4546: WHERE ship_header_int_id = P_ship_header_int_id
4547: AND processing_status_code = 'PENDING'; --'ERROR' IN CASE OF FAIL
4548: TYPE toDeriveLines_List_Type IS TABLE OF toDeriveLines%ROWTYPE;
4549: toDeriveLines_List toDeriveLines_List_Type ;

Line 4613: UPDATE inl_ship_lines_int

4609: toDeriveLines_list(i) .secondary_uom_code := l_2ary_uom_code;
4610: toDeriveLines_list(i) .secondary_unit_price :=(toDeriveLines_list(i) .txn_qty * toDeriveLines_list(i) .txn_unit_price) / l_2ary_qty;
4611: END IF;
4612: IF l_updated_flag = 'Y' THEN
4613: UPDATE inl_ship_lines_int
4614: SET party_id = toDeriveLines_list(i) .party_id ,
4615: party_site_id = toDeriveLines_list(i) .party_site_id ,
4616: source_organization_id = toDeriveLines_list(i) .source_organization_id ,
4617: ship_line_type_id = toDeriveLines_list(i) .ship_line_type_id ,

Line 6298: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',

6294: 'INL_TAX_LINES',
6295: 'RCV_TRANSACTIONS'
6296: )
6297: OR (p_transaction_type = 'CREATE'
6298: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',
6299: 'INL_SHIP_HEADERS_INT')
6300: )
6301: OR(p_match_type_code = 'CORRECTION'
6302: AND p_to_parent_table_name IN('AP_INVOICE_DISTRIBUTIONS')

Line 6359: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES_INT' THEN

6355: WHERE tax_line_id = p_to_parent_table_id;
6356: IF p_match_type_code IN('TAX') THEN
6357: l_matchTpCdOk := 'Y';
6358: END IF;
6359: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES_INT' THEN
6360: SELECT ship_header_id
6361: INTO l_ship_header_id
6362: FROM inl_ship_lines_int
6363: WHERE ship_line_int_id = p_to_parent_table_id;

Line 6362: FROM inl_ship_lines_int

6358: END IF;
6359: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES_INT' THEN
6360: SELECT ship_header_id
6361: INTO l_ship_header_id
6362: FROM inl_ship_lines_int
6363: WHERE ship_line_int_id = p_to_parent_table_id;
6364: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
6365: l_matchTpCdOk := 'Y';
6366: END IF;

Line 8095: FROM inl_ship_lines_int l

8091: h.transaction_type = 'DELETE'
8092: OR EXISTS
8093: (
8094: SELECT 1
8095: FROM inl_ship_lines_int l
8096: WHERE l.ship_header_int_id = h.ship_header_int_id
8097: AND ROWNUM < 2
8098: )
8099: ) ;

Line 8112: FROM inl_ship_lines_int l

8108: SELECT
8109: ship_header_int_id ,
8110: ship_line_int_id ,
8111: ship_line_type_id
8112: FROM inl_ship_lines_int l
8113: WHERE l.processing_status_code = 'PENDING'
8114: AND l.ship_header_int_id = p_ship_header_int_id;
8115:
8116: TYPE ship_lin_int_list_type IS TABLE OF c_ship_lin_int%ROWTYPE;

Line 8350: UPDATE inl_ship_lines_int

8346: program_id = fnd_global.conc_program_id,
8347: program_update_date = SYSDATE ,
8348: program_application_id = fnd_global.prog_appl_id
8349: WHERE ship_header_int_id = l_ship_header_int_id;
8350: UPDATE inl_ship_lines_int
8351: SET processing_status_code = 'RUNNING' ,
8352: request_id = fnd_global.conc_request_id,
8353: last_updated_by = fnd_global.user_id ,
8354: last_update_date = SYSDATE ,

Line 8378: UPDATE inl_ship_lines_int

8374: program_id = fnd_global.conc_program_id,
8375: program_update_date = SYSDATE ,
8376: program_application_id = fnd_global.prog_appl_id
8377: WHERE ship_header_int_id = l_ship_header_int_id;
8378: UPDATE inl_ship_lines_int
8379: SET processing_status_code = 'COMPLETED' ,
8380: request_id = fnd_global.conc_request_id,
8381: last_updated_by = fnd_global.user_id ,
8382: last_update_date = SYSDATE ,

Line 8478: FROM inl_ship_lines_int l

8474: AND h.last_task_code >= '20'
8475: AND EXISTS
8476: (
8477: SELECT 1
8478: FROM inl_ship_lines_int l
8479: WHERE l.ship_header_int_id = h.ship_header_int_id
8480: AND ROWNUM < 2
8481: )
8482: AND h.request_id = fnd_global.conc_request_id;

Line 8517: FROM inl_ship_lines_int l

8513: OR h.org_id = p_org_id)
8514: AND h.processing_status_code = 'RUNNING'
8515: AND (h.transaction_type = 'DELETE'
8516: OR EXISTS (SELECT 1
8517: FROM inl_ship_lines_int l
8518: WHERE l.ship_header_int_id = h.ship_header_int_id
8519: AND ROWNUM < 2
8520: )
8521: )