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

Line 156: IF p_parent_table_name = 'INL_SHIP_HEADERS_INT' OR l_ship_header_int_id IS NOT NULL THEN

152: program_application_id = fnd_global.prog_appl_id
153: WHERE match_amount_int_id = p_parent_table_id
154: AND processing_status_code <> 'ERROR';
155: END IF;
156: IF p_parent_table_name = 'INL_SHIP_HEADERS_INT' OR l_ship_header_int_id IS NOT NULL THEN
157: l_debug_info := 'Set Shipment Header Interface status to ERROR.';
158: INL_LOGGING_PVT.Log_Statement(
159: p_module_name => g_module_name,
160: p_procedure_name => l_proc_name,

Line 163: UPDATE inl_ship_headers_int

159: p_module_name => g_module_name,
160: p_procedure_name => l_proc_name,
161: p_debug_info => l_debug_info
162: ) ;
163: UPDATE inl_ship_headers_int
164: SET processing_status_code = 'ERROR' ,
165: request_id = fnd_global.conc_request_id,
166: last_updated_by = fnd_global.user_id ,
167: last_update_date = SYSDATE ,

Line 569: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

565: IF p_ship_num IS NOT NULL THEN
566: l_result := FND_API.G_FALSE;
567: -- Add a line into inl_ship_errors
568: Handle_InterfError(
569: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
570: p_parent_table_id => p_ship_header_int_id,
571: p_column_name => 'SHIP_NUM',
572: p_column_value => p_ship_num,
573: p_error_message_name => 'INL_ERR_SHIP_NUM_NNULL',

Line 589: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

585: IF p_ship_num IS NULL THEN
586: l_result := FND_API.G_FALSE;
587: -- Add a line into inl_ship_errors
588: Handle_InterfError(
589: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
590: p_parent_table_id => p_ship_header_int_id,
591: p_column_name => 'SHIP_NUM',
592: p_column_value => p_ship_num,
593: p_error_message_name => 'INL_ERR_SHIP_NUM_NULL',

Line 703: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

699: WHEN OTHERS THEN
700: l_result := FND_API.G_FALSE;
701: -- Add a line into inl_ship_errors
702: Handle_InterfError(
703: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
704: p_parent_table_id => p_ship_header_int_id,
705: p_column_name => 'SHIP_TYPE_ID',
706: p_column_value => p_ship_type_id,
707: p_error_message_name => 'INL_ERR_SHIP_TP',

Line 922: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

918: IF p_org_id IS NULL THEN
919: l_result := FND_API.G_FALSE;
920: -- Add a line into inl_ship_errors
921: Handle_InterfError(
922: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
923: p_parent_table_id => p_ship_header_int_id,
924: p_column_name => 'ORG_ID',
925: p_column_value => p_org_id,
926: p_error_message_name => 'INL_ERR_OP_UNIT_NULL',

Line 953: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

949: IF NVL(l_org_count, 0) = 0 THEN
950: l_result := FND_API.G_FALSE;
951: -- Add a line into inl_ship_errors
952: Handle_InterfError(
953: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
954: p_parent_table_id => p_ship_header_int_id,
955: p_column_name => 'ORG_ID',
956: p_column_value => p_org_id,
957: p_error_message_name => 'INL_ERR_INVL_OP_UNIT',

Line 1051: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1047: IF p_organization_id IS NULL THEN
1048: l_result := FND_API.G_FALSE;
1049: -- Add a line into inl_ship_errors
1050: Handle_InterfError(
1051: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1052: p_parent_table_id => p_ship_header_int_id,
1053: p_column_name => 'ORGANIZATION_ID',
1054: p_column_value => p_organization_id,
1055: p_error_message_name => 'INL_ERR_INV_ORG_NULL',

Line 1080: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1076: l_result := FND_API.G_FALSE;
1077: l_organization_count := 0;
1078: -- Add a line into inl_ship_errors
1079: Handle_InterfError(
1080: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1081: p_parent_table_id => p_ship_header_int_id,
1082: p_column_name => 'ORGANIZATION_ID',
1083: p_column_value => p_organization_id,
1084: p_error_message_name => 'INL_ERR_INVL_INV_ORG',

Line 1110: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1106: IF NVL(l_organization_count, 0) = 0 THEN
1107: l_result := FND_API.G_FALSE;
1108: -- Add a line into inl_ship_errors
1109: Handle_InterfError(
1110: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1111: p_parent_table_id => p_ship_header_int_id,
1112: p_column_name => 'ORGANIZATION_ID',
1113: p_column_value => p_organization_id,
1114: p_error_message_name => 'INL_ERR_NO_LCM_OPT_DEF',

Line 1381: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1377: IF p_ship_header_id IS NOT NULL THEN
1378: l_response := FALSE;
1379: -- Add a line into inl_ship_errors
1380: Handle_InterfError(
1381: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1382: p_parent_table_id => p_ship_header_int_id,
1383: p_column_name => 'TRANSACTION_TYPE',
1384: p_column_value => p_transaction_type,
1385: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NNULL',

Line 1410: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1406: OR ship_line_id IS NOT NULL
1407: ) ;
1408: IF NVL(l_aux, 0) > 0 THEN
1409: Handle_InterfError(
1410: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1411: p_parent_table_id => p_ship_header_int_id,
1412: p_column_name => 'TRANSACTION_TYPE',
1413: p_column_value => p_transaction_type,
1414: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NNULL',

Line 1464: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1460: IF p_ship_header_id IS NULL THEN
1461: l_response := FALSE;
1462: -- Add a line into inl_ship_errors
1463: Handle_InterfError(
1464: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1465: p_parent_table_id => p_ship_header_int_id,
1466: p_column_name => 'TRANSACTION_TYPE',
1467: p_column_value => p_transaction_type,
1468: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NULL',

Line 1521: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1517: ) ;
1518: IF NVL(l_aux, 0) > 0 THEN
1519: l_response := FALSE;
1520: Handle_InterfError(
1521: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1522: p_parent_table_id => p_ship_header_int_id,
1523: p_column_name => 'TRANSACTION_TYPE',
1524: p_column_value => p_transaction_type,
1525: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_UPD_GRP',

Line 1590: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1586: IF p_ship_header_id IS NULL THEN
1587: l_response := FALSE;
1588: -- Add a line into inl_ship_errors
1589: Handle_InterfError(
1590: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1591: p_parent_table_id => p_ship_header_int_id,
1592: p_column_name => 'TRANSACTION_TYPE',
1593: p_column_value => p_transaction_type,
1594: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NULL',

Line 1623: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1619: IF NVL(l_aux, 0) > 0 THEN
1620: l_response := FALSE;
1621: -- Add a line into inl_ship_errors
1622: Handle_InterfError(
1623: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1624: p_parent_table_id => p_ship_header_int_id,
1625: p_column_name => 'TRANSACTION_TYPE',
1626: p_column_value => p_transaction_type,
1627: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NULL',

Line 1667: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1663: IF NVL(l_aux, 0) > 0 THEN
1664: l_response := FALSE;
1665: -- Add a line into inl_ship_errors
1666: Handle_InterfError(
1667: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1668: p_parent_table_id => p_ship_header_int_id,
1669: p_column_name => 'TRANSACTION_TYPE',
1670: p_column_value => p_transaction_type,
1671: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_DEL',

Line 1687: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1683: ELSE
1684: l_response := FALSE;
1685: -- Add a line into inl_ship_errors
1686: Handle_InterfError(
1687: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1688: p_parent_table_id => p_ship_header_int_id,
1689: p_column_name => 'TRANSACTION_TYPE',
1690: p_column_value => p_transaction_type,
1691: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_INVL',

Line 1718: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1714: IF l_status = 'COMPLETED' THEN
1715: l_response := FALSE;
1716: -- Add a line into inl_ship_errors
1717: Handle_InterfError(
1718: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1719: p_parent_table_id => p_ship_header_int_id,
1720: p_column_name => 'TRANSACTION_TYPE',
1721: p_column_value => p_transaction_type,
1722: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_STA_INVL',

Line 1895: p_in_param_value1 => 'INL_SHIP_HEADERS_INT',

1891: p_module_name => g_module_name,
1892: p_procedure_name => l_func_name,
1893: p_call_api_name => 'Validate_LastTaskCode',
1894: p_in_param_name1 => 'p_parent_table_name',
1895: p_in_param_value1 => 'INL_SHIP_HEADERS_INT',
1896: p_in_param_name2 => 'p_parent_table_id',
1897: p_in_param_value2 => p_ship_header_int_id,
1898: p_in_param_name3 => 'p_last_task_code',
1899: p_in_param_value3 => p_last_task_code

Line 1902: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

1898: p_in_param_name3 => 'p_last_task_code',
1899: p_in_param_value3 => p_last_task_code
1900: ) ;
1901: l_response := Validate_LastTaskCode(
1902: p_parent_table_name => 'INL_SHIP_HEADERS_INT',
1903: p_parent_table_id => p_ship_header_int_id,
1904: p_last_task_code => p_last_task_code,
1905: x_return_status => l_return_status) ;
1906: -- If any errors happen abort API.

Line 2373: FROM inl_ship_headers_int h

2369: h.attribute13 ,
2370: h.attribute14 ,
2371: h.attribute15 ,
2372: h.ship_header_id
2373: FROM inl_ship_headers_int h
2374: WHERE (p_group_id IS NULL
2375: OR h.group_id = p_group_id
2376: )
2377: AND ( p_org_id IS NULL

Line 2645: UPDATE inl_ship_headers_int

2641: p_debug_info => l_debug_info
2642: ) ;
2643: -- Set processing status code to COMPLETED
2644: -- for the current and imported Shipment Header
2645: UPDATE inl_ship_headers_int
2646: SET processing_status_code = 'COMPLETED' ,
2647: ship_header_id = validHeaders_List(iHead).ship_header_id,
2648: request_id = fnd_global.conc_request_id ,
2649: last_updated_by = fnd_global.user_id ,

Line 2977: FROM inl_ship_headers_int h

2973: IS
2974: SELECT h.ship_header_int_id,
2975: h.ship_header_id ,
2976: h.transaction_type
2977: FROM inl_ship_headers_int h
2978: WHERE (p_group_id IS NULL
2979: OR group_id = p_group_id)
2980: AND (p_org_id IS NULL
2981: OR h.org_id = p_org_id)

Line 4423: UPDATE inl_ship_headers_int sh

4419: p_procedure_name => l_proc_name
4420: ) ;
4421: -- Initialize API return status to success
4422: x_return_status := FND_API.G_RET_STS_SUCCESS;
4423: UPDATE inl_ship_headers_int sh
4424: SET sh.location_id = (
4425: SELECT hou.location_id
4426: FROM hr_organization_units hou,
4427: hr_locations hl

Line 6299: 'INL_SHIP_HEADERS_INT')

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')
6303: )

Line 6374: ELSIF p_to_parent_table_name = 'INL_SHIP_HEADERS_INT' THEN

6370: FROM inl_ship_lines
6371: WHERE ship_line_int_id = p_to_parent_table_id;
6372:
6373: l_INT_importedOk := 'Y';
6374: ELSIF p_to_parent_table_name = 'INL_SHIP_HEADERS_INT' THEN
6375: SELECT ship_header_id
6376: INTO l_ship_header_id
6377: FROM inl_ship_headers_int
6378: WHERE ship_header_int_id = p_to_parent_table_id;

Line 6377: FROM inl_ship_headers_int

6373: l_INT_importedOk := 'Y';
6374: ELSIF p_to_parent_table_name = 'INL_SHIP_HEADERS_INT' THEN
6375: SELECT ship_header_id
6376: INTO l_ship_header_id
6377: FROM inl_ship_headers_int
6378: WHERE ship_header_int_id = p_to_parent_table_id;
6379: IF p_match_type_code IN('CHARGE') THEN
6380: l_matchTpCdOk := 'Y';
6381: END IF;

Line 8077: FROM inl_ship_headers_int h

8073: transaction_type ,
8074: ship_header_id ,
8075: ship_num ,
8076: ship_type_id
8077: FROM inl_ship_headers_int h
8078: WHERE
8079: (
8080: p_group_id IS NULL
8081: OR h.group_id = p_group_id

Line 8203: Reset_InterfError(p_parent_table_name => 'INL_SHIP_HEADERS_INT', p_parent_table_id => ship_hdr_int_list(i) .ship_header_int_id, x_return_status => l_return_status) ;

8199: p_module_name => g_module_name,
8200: p_procedure_name => l_proc_name,
8201: p_debug_info => l_debug_info
8202: );
8203: Reset_InterfError(p_parent_table_name => 'INL_SHIP_HEADERS_INT', p_parent_table_id => ship_hdr_int_list(i) .ship_header_int_id, x_return_status => l_return_status) ;
8204: -- If any errors happen abort API.
8205: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8206: RAISE FND_API.G_EXC_ERROR;
8207: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 8340: UPDATE inl_ship_headers_int

8336: p_module_name => g_module_name,
8337: p_procedure_name => l_proc_name,
8338: p_debug_info => l_debug_info
8339: );
8340: UPDATE inl_ship_headers_int
8341: SET processing_status_code = 'RUNNING' ,
8342: request_id = fnd_global.conc_request_id,
8343: last_updated_by = fnd_global.user_id ,
8344: last_update_date = SYSDATE ,

Line 8368: UPDATE inl_ship_headers_int

8364: p_module_name => g_module_name,
8365: p_procedure_name => l_proc_name,
8366: p_debug_info => l_debug_info
8367: );
8368: UPDATE inl_ship_headers_int
8369: SET processing_status_code = 'COMPLETED' ,
8370: request_id = fnd_global.conc_request_id,
8371: last_updated_by = fnd_global.user_id ,
8372: last_update_date = SYSDATE ,

Line 8461: FROM inl_ship_headers_int h

8457: SELECT h.ship_header_id,
8458: h.ship_header_int_id,
8459: h.last_task_code ,
8460: h.transaction_type
8461: FROM inl_ship_headers_int h
8462: WHERE
8463: (
8464: p_group_id IS NULL
8465: OR h.group_id = p_group_id

Line 8509: FROM inl_ship_headers_int h

8505: -- Get the Last Task Code to control
8506: -- which actions must be executed
8507: SELECT MAX(last_task_code)
8508: INTO l_mx_last_task_code
8509: FROM inl_ship_headers_int h
8510: WHERE (p_group_id IS NULL
8511: OR h.group_id = p_group_id)
8512: AND (p_org_id IS NULL
8513: OR h.org_id = p_org_id)