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

Line 197: FROM inl_ship_lines_int

193: attribute15_sl ,
194: ship_line_group_num ,
195: inventory_item_name ,
196: ship_line_group_id
197: FROM inl_ship_lines_int
198: WHERE ship_header_int_id = pc_ship_header_int_id
199: ORDER BY
200: ship_line_group_reference,
201: ship_line_src_type_code,

Line 316: IF p_parent_table_name = 'INL_SHIP_LINES_INT' THEN

312: p_procedure_name => l_program_name,
313: p_debug_info => l_debug_info ) ;
314:
315: -- In case of error during Shipment Line import process
316: IF p_parent_table_name = 'INL_SHIP_LINES_INT' THEN
317: l_debug_info := 'Set Shipment Line Interface status to ERROR.';
318: INL_LOGGING_PVT.LOG_STATEMENT(
319: P_MODULE_NAME => G_MODULE_NAME,
320: P_PROCEDURE_NAME => l_program_name,

Line 323: UPDATE inl_ship_lines_int

319: P_MODULE_NAME => G_MODULE_NAME,
320: P_PROCEDURE_NAME => l_program_name,
321: P_DEBUG_INFO => L_DEBUG_INFO) ;
322:
323: UPDATE inl_ship_lines_int
324: SET processing_status_code = 'ERROR' ,
325: request_id = L_FND_CONC_REQUEST_ID,
326: last_updated_by = L_FND_USER_ID ,
327: last_update_date = SYSDATE ,

Line 337: FROM inl_ship_lines_int

333: AND processing_status_code <> 'ERROR';
334:
335: SELECT ship_header_int_id
336: INTO l_ship_header_int_id
337: FROM inl_ship_lines_int
338: WHERE ship_line_int_id = p_parent_table_id;
339: /* --Bug#11794442 made in procedure Run_MatchPreProcessor
340: ELSIF p_parent_table_name = 'INL_MATCHES_INT' THEN
341: l_debug_info := 'Set Match Interface status to ERROR.';

Line 1453: p_parent_table_name => 'INL_SHIP_LINES_INT',

1449: p_debug_info => l_debug_info);
1450: l_response := L_FND_FALSE;
1451: -- Add a line into inl_ship_errors
1452: Handle_InterfError(
1453: p_parent_table_name => 'INL_SHIP_LINES_INT',
1454: p_parent_table_id => p_ship_line_int_id,
1455: p_column_name => 'PARTY_ID',
1456: p_column_value => x_party_id,
1457: p_error_message_name => 'INL_ERR_PARTY_TYPE',

Line 1475: p_parent_table_name => 'INL_SHIP_LINES_INT',

1471: p_debug_info => l_debug_info);
1472: l_response := L_FND_FALSE;
1473: -- Add a line into inl_ship_errors
1474: Handle_InterfError(
1475: p_parent_table_name => 'INL_SHIP_LINES_INT',
1476: p_parent_table_id => p_ship_line_int_id,
1477: p_column_name => 'PARTY_ID',
1478: p_column_value => x_party_id,
1479: p_error_message_name => 'INL_ERR_PARTY_USAGE',

Line 1510: p_parent_table_name => 'INL_SHIP_LINES_INT',

1506: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1507: WHEN OTHERS THEN
1508: -- Add a line into inl_ship_errors
1509: Handle_InterfError(
1510: p_parent_table_name => 'INL_SHIP_LINES_INT',
1511: p_parent_table_id => p_ship_line_int_id,
1512: p_column_name => l_column_name,
1513: p_column_value => l_column_value,
1514: p_error_message_name => 'INL_ERR_PARTY',

Line 1705: p_parent_table_name => 'INL_SHIP_LINES_INT',

1701: p_debug_info => l_debug_info);
1702: l_response := L_FND_FALSE;
1703: -- Add a line into inl_ship_errors
1704: Handle_InterfError(
1705: p_parent_table_name => 'INL_SHIP_LINES_INT',
1706: p_parent_table_id => p_ship_line_int_id,
1707: p_column_name => 'PARTY_SITE_ID',
1708: p_column_value => x_party_site_id,
1709: p_error_message_name => 'INL_ERR_3RD_PTY_ST_NNULL',

Line 1730: p_parent_table_name => 'INL_SHIP_LINES_INT',

1726: p_debug_info => l_debug_info);
1727: l_response := L_FND_FALSE;
1728: -- Add a line into inl_ship_errors
1729: Handle_InterfError(
1730: p_parent_table_name => 'INL_SHIP_LINES_INT',
1731: p_parent_table_id => p_ship_line_int_id,
1732: p_column_name => 'PARTY_SITE_ID',
1733: p_column_value => x_party_site_id,
1734: p_error_message_name => 'INL_ERR_NO_3RD_PTY_ST_DEF_PTY',

Line 1751: p_parent_table_name => 'INL_SHIP_LINES_INT',

1747: p_debug_info => l_debug_info);
1748: l_response := L_FND_FALSE;
1749: -- Add a line into inl_ship_errors
1750: Handle_InterfError(
1751: p_parent_table_name => 'INL_SHIP_LINES_INT',
1752: p_parent_table_id => p_ship_line_int_id,
1753: p_column_name => 'PARTY_SITE_ID',
1754: p_column_value => x_party_site_id,
1755: p_error_message_name => 'INL_ERR_3RD_PTY_ST_ALLOWED',

Line 1792: p_parent_table_name => 'INL_SHIP_LINES_INT',

1788: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1789: WHEN OTHERS THEN
1790: -- Add a line into inl_ship_errors
1791: Handle_InterfError(
1792: p_parent_table_name => 'INL_SHIP_LINES_INT',
1793: p_parent_table_id => p_ship_line_int_id,
1794: p_column_name => l_column_name,
1795: p_column_value => l_column_value,
1796: p_error_message_name => 'INL_ERR_PARTY_SITE',

Line 1945: p_parent_table_name => 'INL_SHIP_LINES_INT',

1941: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1942: WHEN OTHERS THEN
1943: -- Add a line into inl_ship_errors
1944: Handle_InterfError(
1945: p_parent_table_name => 'INL_SHIP_LINES_INT',
1946: p_parent_table_id => p_ship_line_int_id,
1947: p_column_name => l_column_name,
1948: p_column_value => l_column_value,
1949: p_error_message_name => 'INL_ERR_SRC_ORG',

Line 2085: p_parent_table_name => 'INL_SHIP_LINES_INT',

2081: p_debug_info => l_debug_info);
2082: l_result := L_FND_FALSE;
2083: -- Add a line into inl_ship_errors
2084: Handle_InterfError(
2085: p_parent_table_name => 'INL_SHIP_LINES_INT',
2086: p_parent_table_id => p_ship_line_int_id,
2087: p_column_name => 'SHIP_LINE_GROUP_NUM',
2088: p_column_value => x_ship_line_group_num,
2089: p_error_message_name => 'INL_ERR_NO_LN_GRP',

Line 2121: p_parent_table_name => 'INL_SHIP_LINES_INT',

2117: p_debug_info => l_debug_info);
2118: l_result := L_FND_FALSE;
2119: -- Add a line into inl_ship_errors
2120: Handle_InterfError(
2121: p_parent_table_name => 'INL_SHIP_LINES_INT',
2122: p_parent_table_id => p_ship_line_int_id,
2123: p_column_name => 'SHIP_LINE_GROUP_NUM',
2124: p_column_value => x_ship_line_group_num,
2125: p_error_message_name => 'INL_ERR_NO_LN_GRP',

Line 2145: FROM inl_ship_lines_all sl, --Bug#10381495

2141: BEGIN
2142: SELECT sl.ship_line_group_id, slg.ship_line_group_num
2143: INTO x_ship_line_group_id,
2144: x_ship_line_group_num
2145: FROM inl_ship_lines_all sl, --Bug#10381495
2146: inl_ship_line_groups slg
2147: WHERE sl.ship_header_id = p_ship_header_id
2148: AND sl.ship_line_id = p_ship_line_id
2149: AND sl.ship_line_group_id = slg.ship_line_group_id

Line 2161: p_parent_table_name => 'INL_SHIP_LINES_INT',

2157: p_debug_info => l_debug_info);
2158: l_result := L_FND_FALSE;
2159: -- Add a line into inl_ship_errors
2160: Handle_InterfError(
2161: p_parent_table_name => 'INL_SHIP_LINES_INT',
2162: p_parent_table_id => p_ship_line_int_id,
2163: p_column_name => 'SHIP_LINE_GROUP_NUM',
2164: p_column_value => x_ship_line_group_num,
2165: p_error_message_name => 'INL_ERR_NO_LN_GRP',

Line 2310: FROM inl_ship_lines_all sl --Bug#10381495

2306: x_ship_line_num := NULL;
2307: IF p_validation_flag = 'Y' THEN
2308: SELECT COUNT (1)
2309: INTO l_count_ship_ln_num_exist
2310: FROM inl_ship_lines_all sl --Bug#10381495
2311: WHERE sl.ship_line_id = x_ship_line_id;
2312:
2313: IF NVL(l_count_ship_ln_num_exist,0) = 0 THEN
2314: l_debug_info := 'No Shipment Line found';

Line 2322: p_parent_table_name => 'INL_SHIP_LINES_INT',

2318: p_debug_info => l_debug_info);
2319: l_response := L_FND_FALSE;
2320: -- Add a line into inl_ship_errors
2321: Handle_InterfError(
2322: p_parent_table_name => 'INL_SHIP_LINES_INT',
2323: p_parent_table_id => p_ship_line_int_id,
2324: p_column_name => 'SHIP_LINE_ID',
2325: p_column_value => x_ship_line_id,
2326: p_error_message_name => 'INL_ERR_CHK_NO_SHIP_LN',

Line 2342: FROM inl_ship_lines_all sl --Bug#10381495

2338: l_colum_value := x_ship_line_num;
2339: BEGIN
2340: SELECT sl.ship_line_id
2341: INTO x_ship_line_id
2342: FROM inl_ship_lines_all sl --Bug#10381495
2343: WHERE sl.ship_header_id = p_ship_header_id
2344: AND sl.ship_line_group_id = p_ship_line_group_id
2345: AND sl.ship_line_num = x_ship_line_num;
2346: EXCEPTION

Line 2356: p_parent_table_name => 'INL_SHIP_LINES_INT',

2352: p_debug_info => l_debug_info);
2353: l_response := L_FND_FALSE;
2354: -- Add a line into inl_ship_errors
2355: Handle_InterfError(
2356: p_parent_table_name => 'INL_SHIP_LINES_INT',
2357: p_parent_table_id => p_ship_line_int_id,
2358: p_column_name => 'SHIP_LINE_NUM',
2359: p_column_value => x_ship_line_num,
2360: p_error_message_name => 'INL_ERR_CHK_NO_SHIP_LN',

Line 2392: p_parent_table_name => 'INL_SHIP_LINES_INT',

2388: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2389: WHEN OTHERS THEN
2390: -- Add a line into inl_ship_errors
2391: Handle_InterfError(
2392: p_parent_table_name => 'INL_SHIP_LINES_INT',
2393: p_parent_table_id => p_ship_line_int_id,
2394: p_column_name => 'SHIP_LINE_NUM',
2395: p_column_value => x_ship_line_num,
2396: p_error_message_name => 'INL_ERR_CHK_NO_SHIP_LN',

Line 2582: p_parent_table_name => 'INL_SHIP_LINES_INT',

2578: p_debug_info => l_debug_info);
2579: l_result := L_FND_FALSE;
2580: -- Add a line into inl_ship_errors
2581: Handle_InterfError(
2582: p_parent_table_name => 'INL_SHIP_LINES_INT',
2583: p_parent_table_id => p_ship_line_int_id,
2584: p_column_name => 'SHIP_LINE_TYPE_ID',
2585: p_column_value => x_ship_line_type_id,
2586: p_error_message_name => 'INL_ERR_SHIP_LN_TP_CLOSED',

Line 2605: p_parent_table_name => 'INL_SHIP_LINES_INT',

2601: p_debug_info => l_debug_info);
2602: l_result := L_FND_FALSE;
2603: -- Add a line into inl_ship_errors
2604: Handle_InterfError(
2605: p_parent_table_name => 'INL_SHIP_LINES_INT',
2606: p_parent_table_id => p_ship_line_int_id,
2607: p_column_name => 'SHIP_LINE_TYPE_ID',
2608: p_column_value => x_ship_line_type_id,
2609: p_error_message_name => 'INL_ERR_NO_SHIP_LN_DEF',

Line 2717: p_parent_table_name => 'INL_SHIP_LINES_INT',

2713: p_debug_info => l_debug_info);
2714: l_result := L_FND_FALSE;
2715: -- Add a line into inl_ship_errors
2716: Handle_InterfError(
2717: p_parent_table_name => 'INL_SHIP_LINES_INT',
2718: p_parent_table_id => p_ship_line_int_id,
2719: p_column_name => 'SHIP_LINE_SRC_TYPE_CODE',
2720: p_column_value => p_ship_ln_src_tp_code,
2721: p_error_message_name => 'INL_ERR_CHK_SHIP_LN_SRC_TP',

Line 2883: p_parent_table_name => 'INL_SHIP_LINES_INT',

2879: p_debug_info => l_debug_info);
2880: l_response := L_FND_FALSE;
2881: -- Add a line into inl_ship_errors
2882: Handle_InterfError(
2883: p_parent_table_name => 'INL_SHIP_LINES_INT',
2884: p_parent_table_id => p_ship_line_int_id,
2885: p_column_name => 'CURRENCY_CODE',
2886: p_column_value => p_currency_code,
2887: p_error_message_name => 'INL_ERR_CURR_CODE_INV',

Line 2907: p_parent_table_name => 'INL_SHIP_LINES_INT',

2903: p_debug_info => l_debug_info);
2904: l_response := L_FND_FALSE;
2905: -- Add a line into inl_ship_errors
2906: Handle_InterfError(
2907: p_parent_table_name => 'INL_SHIP_LINES_INT',
2908: p_parent_table_id => p_ship_line_int_id,
2909: p_column_name => 'CURRENCY_CONVERSION_TYPE',
2910: p_column_value => p_curr_conv_type,
2911: p_error_message_name => 'INL_ERR_CURR_CONV_TP_NNULL',

Line 2930: p_parent_table_name => 'INL_SHIP_LINES_INT',

2926: p_debug_info => l_debug_info);
2927: l_response := L_FND_FALSE;
2928: -- Add a line into inl_ship_errors
2929: Handle_InterfError(
2930: p_parent_table_name => 'INL_SHIP_LINES_INT',
2931: p_parent_table_id => p_ship_line_int_id,
2932: p_column_name => 'CURRENCY_CONVERSION_RATE',
2933: p_column_value => x_curr_conv_rate,
2934: p_error_message_name => 'INL_ERR_CURR_CONV_RT_NNULL',

Line 2953: p_parent_table_name => 'INL_SHIP_LINES_INT',

2949: p_debug_info => l_debug_info);
2950: l_response := L_FND_FALSE;
2951: -- Add a line into inl_ship_errors
2952: Handle_InterfError(
2953: p_parent_table_name => 'INL_SHIP_LINES_INT',
2954: p_parent_table_id => p_ship_line_int_id,
2955: p_column_name => 'CURRENCY_CONVERSION_DATE',
2956: p_column_value => p_curr_conv_date,
2957: p_error_message_name => 'INL_ERR_CURR_CONV_DT_NNULL',

Line 2977: p_parent_table_name => 'INL_SHIP_LINES_INT',

2973: p_debug_info => l_debug_info);
2974: l_response := L_FND_FALSE;
2975: -- Add a line into inl_ship_errors
2976: Handle_InterfError(
2977: p_parent_table_name => 'INL_SHIP_LINES_INT',
2978: p_parent_table_id => p_ship_line_int_id,
2979: p_column_name => 'CURRENCY_CONVERSION_DATE',
2980: p_column_value => p_curr_conv_date,
2981: p_error_message_name => 'INL_ERR_CURR_CONV_DT_NULL',

Line 3000: p_parent_table_name => 'INL_SHIP_LINES_INT',

2996: p_debug_info => l_debug_info);
2997: l_response := L_FND_FALSE;
2998: -- Add a line into inl_ship_errors
2999: Handle_InterfError(
3000: p_parent_table_name => 'INL_SHIP_LINES_INT',
3001: p_parent_table_id => p_ship_line_int_id,
3002: p_column_name => 'CURRENCY_CONVERSION_RATE',
3003: p_column_value => x_curr_conv_rate,
3004: p_error_message_name => 'INL_ERR_CURR_CONV_RT_NULL',

Line 3023: p_parent_table_name => 'INL_SHIP_LINES_INT',

3019: p_debug_info => l_debug_info);
3020: l_response := L_FND_FALSE;
3021: -- Add a line into inl_ship_errors
3022: Handle_InterfError(
3023: p_parent_table_name => 'INL_SHIP_LINES_INT',
3024: p_parent_table_id => p_ship_line_int_id,
3025: p_column_name => 'CURRENCY_CONVERSION_TYPE',
3026: p_column_value => p_curr_conv_type,
3027: p_error_message_name => 'INL_ERR_CURR_CONV_TP_NULL',

Line 3055: p_parent_table_name => 'INL_SHIP_LINES_INT',

3051: p_debug_info => l_debug_info);
3052: l_response := L_FND_FALSE;
3053: -- Add a line into inl_ship_errors
3054: Handle_InterfError(
3055: p_parent_table_name => 'INL_SHIP_LINES_INT',
3056: p_parent_table_id => p_ship_line_int_id,
3057: p_column_name => 'CURRENCY_CONVERSION_TYPE',
3058: p_column_value => p_curr_conv_type,
3059: p_error_message_name => 'INL_ERR_CURR_CONV_TP_INV',

Line 3102: p_parent_table_name => 'INL_SHIP_LINES_INT',

3098: p_debug_info => l_debug_info);
3099: l_response := L_FND_FALSE;
3100: -- Add a line into inl_ship_errors
3101: Handle_InterfError(
3102: p_parent_table_name => 'INL_SHIP_LINES_INT',
3103: p_parent_table_id => p_ship_line_int_id,
3104: p_column_name => 'CURRENCY_CONVERSION_RATE',
3105: p_column_value => x_curr_conv_rate,
3106: p_error_message_name => 'INL_NO_RATE_DEFINED',

Line 3275: p_parent_table_name => 'INL_SHIP_LINES_INT',

3271: RETURN FND_API.to_boolean(L_FND_FALSE);
3272: WHEN OTHERS THEN
3273: -- Add a line into inl_ship_errors
3274: Handle_InterfError(
3275: p_parent_table_name => 'INL_SHIP_LINES_INT',
3276: p_parent_table_id => p_ship_line_int_id,
3277: p_column_name => l_column_name,
3278: p_column_value => l_column_value,
3279: p_error_message_name => 'INL_ERR_INV_ITEM_INV',

Line 3357: p_parent_table_name => 'INL_SHIP_LINES_INT',

3353: p_debug_info => l_debug_info);
3354: l_result := L_FND_FALSE;
3355: -- Add a line into inl_ship_errors
3356: Handle_InterfError(
3357: p_parent_table_name => 'INL_SHIP_LINES_INT',
3358: p_parent_table_id => p_ship_line_int_id,
3359: p_column_name => 'TXN_UOM_CODE',
3360: p_column_value => p_txn_uom_code,
3361: p_error_message_name => 'INL_ERR_UOM_CODE_INV',

Line 3584: FROM inl_ship_lines_all sl --Bug#10381495

3580: INTO l_inventory_item_id,
3581: l_txn_uom_code,
3582: l_txn_qty,
3583: l_txn_unit_price
3584: FROM inl_ship_lines_all sl --Bug#10381495
3585: WHERE sl.ship_line_id = p_ship_line_id;
3586: END IF;
3587:
3588: INL_LOGGING_PVT.Log_Variable(

Line 3654: p_parent_table_name => 'INL_SHIP_LINES_INT',

3650:
3651: l_result := L_FND_FALSE;
3652: -- Add a line into inl_ship_errors
3653: Handle_InterfError(
3654: p_parent_table_name => 'INL_SHIP_LINES_INT',
3655: p_parent_table_id => p_ship_line_int_id,
3656: p_column_name => 'TXN_UOM_CODE',
3657: p_column_value => l_txn_uom_code,
3658: p_error_message_name => 'INL_ERR_DERIVE_PRI_SEC_FLDS',

Line 3846: p_parent_table_name => 'INL_SHIP_LINES_INT',

3842: p_debug_info => l_debug_info);
3843: l_result := L_FND_FALSE;
3844: -- Add a line into inl_ship_errors
3845: Handle_InterfError(
3846: p_parent_table_name => 'INL_SHIP_LINES_INT',
3847: p_parent_table_id => p_ship_line_int_id,
3848: p_column_name => 'SECONDARY_UOM_CODE',
3849: p_column_value => x_2ary_uom_code,
3850: p_error_message_name => 'INL_ERR_SEC_FLDS_NULL',

Line 3880: p_parent_table_name => 'INL_SHIP_LINES_INT',

3876: p_debug_info => l_debug_info);
3877: l_result := L_FND_FALSE;
3878: -- Add a line into inl_ship_errors
3879: Handle_InterfError(
3880: p_parent_table_name => 'INL_SHIP_LINES_INT',
3881: p_parent_table_id => p_ship_line_int_id,
3882: p_column_name => 'SECONDARY_UOM_CODE',
3883: p_column_value => x_2ary_uom_code,
3884: p_error_message_name => 'INL_ERR_SEC_UOM_CODE_INV',

Line 3994: p_parent_table_name => 'INL_SHIP_LINES_INT',

3990: l_result := L_FND_FALSE;
3991:
3992: -- Add a line into inl_ship_errors
3993: Handle_InterfError(
3994: p_parent_table_name => 'INL_SHIP_LINES_INT',
3995: p_parent_table_id => p_ship_line_int_id,
3996: p_column_name => 'LANDED_COST_FLAG',
3997: p_column_value => p_landed_cost_flag,
3998: p_error_message_name => 'INL_ERR_LC_FLAG_INV',

Line 4095: p_parent_table_name => 'INL_SHIP_LINES_INT',

4091: l_result := L_FND_FALSE;
4092:
4093: -- Add a line into inl_ship_errors
4094: Handle_InterfError(
4095: p_parent_table_name => 'INL_SHIP_LINES_INT',
4096: p_parent_table_id => p_ship_line_int_id,
4097: p_column_name => 'ALLOCATION_ENABLED_FLAG',
4098: p_column_value => p_alloc_enabled_flag,
4099: p_error_message_name => 'INL_ERR_ALLOC_ENABLED_INV',

Line 4101: p_token1_value => 'INL_SHIP_LINES_INT',

4097: p_column_name => 'ALLOCATION_ENABLED_FLAG',
4098: p_column_value => p_alloc_enabled_flag,
4099: p_error_message_name => 'INL_ERR_ALLOC_ENABLED_INV',
4100: p_token1_name => 'ID_NAME',
4101: p_token1_value => 'INL_SHIP_LINES_INT',
4102: p_token2_name => 'ID_VAL',
4103: p_token2_value => p_ship_line_int_id,
4104: x_return_status => l_return_status);
4105: -- If any errors happen abort API.

Line 4927: p_parent_table_name => 'INL_SHIP_LINES_INT',

4923: THEN
4924: l_response := FALSE;
4925: -- Add a line into inl_ship_errors
4926: Handle_InterfError(
4927: p_parent_table_name => 'INL_SHIP_LINES_INT',
4928: p_parent_table_id => l_ship_line_int_id,
4929: p_column_name => 'TRANSACTION_TYPE',
4930: p_column_value => 'CREATE',
4931: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 4935: p_token2_value => 'INL_SHIP_LINES_INT',

4931: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
4932: p_token1_name => 'COLUMN',
4933: p_token1_value => 'SHIP_LINE_SRC_TYPE_CODE',
4934: p_token2_name => 'ID_NAME',
4935: p_token2_value => 'INL_SHIP_LINES_INT',
4936: p_token3_name => 'ID_VAL',
4937: p_token3_value => l_ship_line_int_id,
4938: x_return_status => l_return_status) ;
4939: -- If any errors happen abort API.

Line 4965: p_parent_table_name => 'INL_SHIP_LINES_INT',

4961: THEN
4962: l_response := FALSE;
4963: -- Add a line into inl_ship_errors
4964: Handle_InterfError(
4965: p_parent_table_name => 'INL_SHIP_LINES_INT',
4966: p_parent_table_id => l_ship_line_int_id,
4967: p_column_name => 'TRANSACTION_TYPE',
4968: p_column_value => 'CREATE',
4969: p_error_message_name => 'INL_ERR_PARTY_FLDS_NULL_SRC_TP',

Line 4973: p_token2_value => 'INL_SHIP_LINES_INT',

4969: p_error_message_name => 'INL_ERR_PARTY_FLDS_NULL_SRC_TP',
4970: p_token1_name => 'SHIP_LN_SRC',
4971: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
4972: p_token2_name => 'ID_NAME',
4973: p_token2_value => 'INL_SHIP_LINES_INT',
4974: p_token3_name => 'ID_VAL',
4975: p_token3_value => l_ship_line_int_id,
4976: x_return_status => l_return_status) ;
4977: -- If any errors happen abort API.

Line 5019: p_parent_table_name => 'INL_SHIP_LINES_INT',

5015: IF NVL(l_lcm_flag,'N') <> 'Y' THEN
5016: l_response := FALSE;
5017: -- Add a line into inl_ship_errors
5018: Handle_InterfError(
5019: p_parent_table_name => 'INL_SHIP_LINES_INT',
5020: p_parent_table_id => l_ship_line_int_id,
5021: p_column_name => 'TRANSACTION_TYPE',
5022: p_column_value => 'CREATE',
5023: p_error_message_name => 'INL_ERR_SHIP_REC_NOT_COMPL',

Line 5025: p_token1_value => 'INL_SHIP_LINES_INT',

5021: p_column_name => 'TRANSACTION_TYPE',
5022: p_column_value => 'CREATE',
5023: p_error_message_name => 'INL_ERR_SHIP_REC_NOT_COMPL',
5024: p_token1_name => 'ID_NAME1',
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',

Line 5049: p_parent_table_name => 'INL_SHIP_LINES_INT',

5045: THEN
5046: l_response := FALSE;
5047: -- Add a line into inl_ship_errors
5048: Handle_InterfError(
5049: p_parent_table_name => 'INL_SHIP_LINES_INT',
5050: p_parent_table_id => l_ship_line_int_id,
5051: p_column_name => 'TRANSACTION_TYPE',
5052: p_column_value => 'CREATE',
5053: p_error_message_name => 'INL_ERR_SRC_ORG_FLDS_NNULL',

Line 5057: p_token2_value => 'INL_SHIP_LINES_INT',

5053: p_error_message_name => 'INL_ERR_SRC_ORG_FLDS_NNULL',
5054: p_token1_name => 'SHIP_LN_SRC',
5055: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
5056: p_token2_name => 'ID_NAME',
5057: p_token2_value => 'INL_SHIP_LINES_INT',
5058: p_token3_name => 'ID_VAL',
5059: p_token3_value => l_ship_line_int_id,
5060: x_return_status => l_return_status) ;
5061: -- If any errors happen abort API.

Line 5082: p_parent_table_name => 'INL_SHIP_LINES_INT',

5078: THEN
5079: l_response := FALSE;
5080: -- Add a line into inl_ship_errors
5081: Handle_InterfError(
5082: p_parent_table_name => 'INL_SHIP_LINES_INT',
5083: p_parent_table_id => l_ship_line_int_id,
5084: p_column_name => 'TRANSACTION_TYPE',
5085: p_column_value => 'CREATE',
5086: p_error_message_name => 'INL_ERR_PARTY_NULL',

Line 5090: p_token2_value => 'INL_SHIP_LINES_INT',

5086: p_error_message_name => 'INL_ERR_PARTY_NULL',
5087: p_token1_name => 'SHIP_LN_SRC',
5088: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
5089: p_token2_name => 'ID_NAME',
5090: p_token2_value => 'INL_SHIP_LINES_INT',
5091: p_token3_name => 'ID_VAL',
5092: p_token3_value => l_ship_line_int_id,
5093: x_return_status => l_return_status) ;
5094: -- If any errors happen abort API.

Line 5107: p_parent_table_name => 'INL_SHIP_LINES_INT',

5103: THEN
5104: l_response := FALSE;
5105: -- Add a line into inl_ship_errors
5106: Handle_InterfError(
5107: p_parent_table_name => 'INL_SHIP_LINES_INT',
5108: p_parent_table_id => l_ship_line_int_id,
5109: p_column_name => 'TRANSACTION_TYPE',
5110: p_column_value => 'CREATE',
5111: p_error_message_name => 'INL_ERR_SRC_ORG_FLDS_NNULL',

Line 5115: p_token2_value => 'INL_SHIP_LINES_INT',

5111: p_error_message_name => 'INL_ERR_SRC_ORG_FLDS_NNULL',
5112: p_token1_name => 'SHIP_LN_SRC',
5113: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
5114: p_token2_name => 'ID_NAME',
5115: p_token2_value => 'INL_SHIP_LINES_INT',
5116: p_token3_name => 'ID_VAL',
5117: p_token3_value => l_ship_line_int_id,
5118: x_return_status => l_return_status) ;
5119: -- If any errors happen abort API.

Line 5132: p_parent_table_name => 'INL_SHIP_LINES_INT',

5128: THEN
5129: l_response := FALSE;
5130: -- Add a line into inl_ship_errors
5131: Handle_InterfError(
5132: p_parent_table_name => 'INL_SHIP_LINES_INT',
5133: p_parent_table_id => l_ship_line_int_id,
5134: p_column_name => 'TRANSACTION_TYPE',
5135: p_column_value => 'CREATE',
5136: p_error_message_name => 'INL_ERR_PTY_ST_NNULL_SRC_TP',

Line 5140: p_token2_value => 'INL_SHIP_LINES_INT',

5136: p_error_message_name => 'INL_ERR_PTY_ST_NNULL_SRC_TP',
5137: p_token1_name => 'SHIP_LN_SRC',
5138: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
5139: p_token2_name => 'ID_NAME',
5140: p_token2_value => 'INL_SHIP_LINES_INT',
5141: p_token3_name => 'ID_VAL',
5142: p_token3_value => l_ship_line_int_id,
5143: x_return_status => l_return_status) ;
5144: -- If any errors happen abort API.

Line 5164: p_parent_table_name => 'INL_SHIP_LINES_INT',

5160: THEN
5161: l_response := FALSE;
5162: -- Add a line into inl_ship_errors
5163: Handle_InterfError(
5164: p_parent_table_name => 'INL_SHIP_LINES_INT',
5165: p_parent_table_id => l_ship_line_int_id,
5166: p_column_name => 'TRANSACTION_TYPE',
5167: p_column_value => 'CREATE',
5168: p_error_message_name => 'INL_ERR_SRC_ORG_NULL_SRC_TP',

Line 5171: p_token2_value => 'INL_SHIP_LINES_INT',

5167: p_column_value => 'CREATE',
5168: p_error_message_name => 'INL_ERR_SRC_ORG_NULL_SRC_TP',
5169: p_token1_name => 'SHIP_LN_SRC_TYPE_CODE',
5170: p_token2_name => 'ID_NAME',
5171: p_token2_value => 'INL_SHIP_LINES_INT',
5172: p_token3_name => 'ID_VAL',
5173: p_token3_value => l_ship_line_int_id,
5174: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
5175: x_return_status => l_return_status) ;

Line 5190: p_parent_table_name => 'INL_SHIP_LINES_INT',

5186: THEN
5187: l_response := FALSE;
5188: -- Add a line into inl_ship_errors
5189: Handle_InterfError(
5190: p_parent_table_name => 'INL_SHIP_LINES_INT',
5191: p_parent_table_id => l_ship_line_int_id,
5192: p_column_name => 'TRANSACTION_TYPE',
5193: p_column_value => 'CREATE',
5194: p_error_message_name => 'INL_ERR_PTY_ST_NNULL_SRC_TP',

Line 5198: p_token2_value => 'INL_SHIP_LINES_INT',

5194: p_error_message_name => 'INL_ERR_PTY_ST_NNULL_SRC_TP',
5195: p_token1_name => 'SHIP_LN_SRC',
5196: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
5197: p_token2_name => 'ID_NAME',
5198: p_token2_value => 'INL_SHIP_LINES_INT',
5199: p_token3_name => 'ID_VAL',
5200: p_token3_value => l_ship_line_int_id,
5201: x_return_status => l_return_status) ;
5202: -- If any errors happen abort API.

Line 5216: p_parent_table_name => 'INL_SHIP_LINES_INT',

5212: THEN
5213: l_response := FALSE;
5214: -- Add a line into inl_ship_errors
5215: Handle_InterfError(
5216: p_parent_table_name => 'INL_SHIP_LINES_INT',
5217: p_parent_table_id => l_ship_line_int_id,
5218: p_column_name => 'TRANSACTION_TYPE',
5219: p_column_value => 'CREATE',
5220: p_error_message_name => 'INL_ERR_PARTY_NNULL_SRC_TP',

Line 5224: p_token2_value => 'INL_SHIP_LINES_INT',

5220: p_error_message_name => 'INL_ERR_PARTY_NNULL_SRC_TP',
5221: p_token1_name => 'SHIP_LN_SRC',
5222: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
5223: p_token2_name => 'ID_NAME',
5224: p_token2_value => 'INL_SHIP_LINES_INT',
5225: p_token3_name => 'ID_VAL',
5226: p_token3_value => l_ship_line_int_id,
5227: x_return_status => l_return_status) ;
5228: -- If any errors happen abort API.

Line 5244: p_parent_table_name => 'INL_SHIP_LINES_INT',

5240: p_debug_info => l_debug_info);
5241: l_response := FALSE;
5242: -- Add a line into inl_ship_errors
5243: Handle_InterfError(
5244: p_parent_table_name => 'INL_SHIP_LINES_INT',
5245: p_parent_table_id => l_ship_line_int_id,
5246: p_column_name => 'TRANSACTION_TYPE',
5247: p_column_value => 'CREATE',
5248: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_INVL',

Line 5252: p_token2_value => 'INL_SHIP_LINES_INT',

5248: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_INVL',
5249: p_token1_name => 'TTYPE',
5250: p_token1_value => x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code,
5251: p_token2_name => 'ID_NAME',
5252: p_token2_value => 'INL_SHIP_LINES_INT',
5253: p_token3_name => 'ID_VAL',
5254: p_token3_value => l_ship_line_int_id,
5255: x_return_status => l_return_status) ;
5256: -- If any errors happen abort API.

Line 5277: p_parent_table_name => 'INL_SHIP_LINES_INT',

5273: p_debug_info => l_debug_info);
5274: l_response := FALSE;
5275: -- Add a line into inl_ship_errors
5276: Handle_InterfError(
5277: p_parent_table_name => 'INL_SHIP_LINES_INT',
5278: p_parent_table_id => l_ship_line_int_id,
5279: p_column_name => 'PARTY_ID',
5280: p_column_value => x_ship_ln_int_lst(l_ship_ln_int_idx).party_id,
5281: p_error_message_name => 'INL_ERR_PARTY_SRC_ORG_EXISTS',

Line 5301: p_parent_table_name => 'INL_SHIP_LINES_INT',

5297: IF(x_ship_ln_int_lst(l_ship_ln_int_idx).currency_code IS NULL) THEN
5298: l_response := FALSE;
5299: -- Add a line into inl_ship_errors
5300: Handle_InterfError(
5301: p_parent_table_name => 'INL_SHIP_LINES_INT',
5302: p_parent_table_id => l_ship_line_int_id,
5303: p_column_name => 'TRANSACTION_TYPE',
5304: p_column_value => 'CREATE',
5305: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 5309: p_token2_value => 'INL_SHIP_LINES_INT',

5305: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
5306: p_token1_name => 'COLUMN',
5307: p_token1_value => 'CURRENCY_CODE',
5308: p_token2_name => 'ID_NAME',
5309: p_token2_value => 'INL_SHIP_LINES_INT',
5310: p_token3_name => 'ID_VAL',
5311: p_token3_value => l_ship_line_int_id,
5312: x_return_status => l_return_status) ;
5313: -- If any errors happen abort API.

Line 5331: p_parent_table_name => 'INL_SHIP_LINES_INT',

5327: IF(x_ship_ln_int_lst(l_ship_ln_int_idx).txn_qty IS NULL) THEN
5328: l_response := FALSE;
5329: -- Add a line into inl_ship_errors
5330: Handle_InterfError(
5331: p_parent_table_name => 'INL_SHIP_LINES_INT',
5332: p_parent_table_id => l_ship_line_int_id,
5333: p_column_name => 'TRANSACTION_TYPE',
5334: p_column_value => 'CREATE',
5335: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 5339: p_token2_value => 'INL_SHIP_LINES_INT',

5335: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
5336: p_token1_name => 'COLUMN',
5337: p_token1_value => 'TXN_QTY',
5338: p_token2_name => 'ID_NAME',
5339: p_token2_value => 'INL_SHIP_LINES_INT',
5340: p_token3_name => 'ID_VAL',
5341: p_token3_value => l_ship_line_int_id,
5342: x_return_status => l_return_status) ;
5343: -- If any errors happen abort API.

Line 5361: p_parent_table_name => 'INL_SHIP_LINES_INT',

5357: IF(x_ship_ln_int_lst(l_ship_ln_int_idx).txn_uom_code IS NULL) THEN
5358: l_response := FALSE;
5359: -- Add a line into inl_ship_errors
5360: Handle_InterfError(
5361: p_parent_table_name => 'INL_SHIP_LINES_INT',
5362: p_parent_table_id => l_ship_line_int_id,
5363: p_column_name => 'TRANSACTION_TYPE',
5364: p_column_value => 'CREATE',
5365: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 5369: p_token2_value => 'INL_SHIP_LINES_INT',

5365: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
5366: p_token1_name => 'COLUMN',
5367: p_token1_value => 'TXN_UOM_CODE',
5368: p_token2_name => 'ID_NAME',
5369: p_token2_value => 'INL_SHIP_LINES_INT',
5370: p_token3_name => 'ID_VAL',
5371: p_token3_value => l_ship_line_int_id,
5372: x_return_status => l_return_status) ;
5373: -- If any errors happen abort API.

Line 5391: p_parent_table_name => 'INL_SHIP_LINES_INT',

5387: IF(x_ship_ln_int_lst(l_ship_ln_int_idx).txn_unit_price IS NULL) THEN
5388: l_response := FALSE;
5389: -- Add a line into inl_ship_errors
5390: Handle_InterfError(
5391: p_parent_table_name => 'INL_SHIP_LINES_INT',
5392: p_parent_table_id => l_ship_line_int_id,
5393: p_column_name => 'TRANSACTION_TYPE',
5394: p_column_value => 'CREATE',
5395: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 5399: p_token2_value => 'INL_SHIP_LINES_INT',

5395: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
5396: p_token1_name => 'COLUMN',
5397: p_token1_value => 'TXN_UNIT_PRICE',
5398: p_token2_name => 'ID_NAME',
5399: p_token2_value => 'INL_SHIP_LINES_INT',
5400: p_token3_name => 'ID_VAL',
5401: p_token3_value => l_ship_line_int_id,
5402: x_return_status => l_return_status) ;
5403: -- If any errors happen abort API.

Line 5417: p_parent_table_name => 'INL_SHIP_LINES_INT',

5413: THEN
5414: l_response := FALSE;
5415: -- Add a line into inl_ship_errors
5416: Handle_InterfError(
5417: p_parent_table_name => 'INL_SHIP_LINES_INT',
5418: p_parent_table_id => l_ship_line_int_id,
5419: p_column_name => 'TRANSACTION_TYPE',
5420: p_column_value => 'CREATE',
5421: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 5425: p_token2_value => 'INL_SHIP_LINES_INT',

5421: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
5422: p_token1_name => 'COLUMN',
5423: p_token1_value => 'SHIP_LINE_TYPE_ID OR SHIP_LINE_TYPE_CODE',
5424: p_token2_name => 'ID_NAME',
5425: p_token2_value => 'INL_SHIP_LINES_INT',
5426: p_token3_name => 'ID_VAL',
5427: p_token3_value => l_ship_line_int_id,
5428: x_return_status => l_return_status) ;
5429: -- If any errors happen abort API.

Line 5444: p_parent_table_name => 'INL_SHIP_LINES_INT',

5440: l_response := FALSE;
5441:
5442: -- Add a line into inl_ship_errors
5443: Handle_InterfError(
5444: p_parent_table_name => 'INL_SHIP_LINES_INT',
5445: p_parent_table_id => l_ship_line_int_id,
5446: p_column_name => 'TRANSACTION_TYPE',
5447: p_column_value => 'CREATE',
5448: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 5452: p_token2_value => 'INL_SHIP_LINES_INT',

5448: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
5449: p_token1_name => 'COLUMN',
5450: p_token1_value => 'INVENTORY_ITEM_ID OR INVENTORY_ITEM_NAME',
5451: p_token2_name => 'ID_NAME',
5452: p_token2_value => 'INL_SHIP_LINES_INT',
5453: p_token3_name => 'ID_VAL',
5454: p_token3_value => l_ship_line_int_id,
5455: x_return_status => l_return_status) ;
5456: -- If any errors happen abort API.

Line 5469: p_parent_table_name => 'INL_SHIP_LINES_INT',

5465: THEN
5466: l_response := FALSE;
5467: -- Add a line into inl_ship_errors
5468: Handle_InterfError(
5469: p_parent_table_name => 'INL_SHIP_LINES_INT',
5470: p_parent_table_id => l_ship_line_int_id,
5471: p_column_name => 'TRANSACTION_TYPE',
5472: p_column_value => 'CREATE',
5473: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 5477: p_token2_value => 'INL_SHIP_LINES_INT',

5473: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
5474: p_token1_name => 'COLUMN',
5475: p_token1_value => 'SHIP_HEADER_ID',
5476: p_token2_name => 'ID_NAME',
5477: p_token2_value => 'INL_SHIP_LINES_INT',
5478: p_token3_name => 'ID_VAL',
5479: p_token3_value => l_ship_line_int_id,
5480: x_return_status => l_return_status) ;
5481: -- If any errors happen abort API.

Line 5496: p_parent_table_name => 'INL_SHIP_LINES_INT',

5492: l_response := FALSE;
5493:
5494: -- Add a line into inl_ship_errors
5495: Handle_InterfError(
5496: p_parent_table_name => 'INL_SHIP_LINES_INT',
5497: p_parent_table_id => l_ship_line_int_id,
5498: p_column_name => 'TRANSACTION_TYPE',
5499: p_column_value => 'CREATE',
5500: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 5504: p_token2_value => 'INL_SHIP_LINES_INT',

5500: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
5501: p_token1_name => 'COLUMN',
5502: p_token1_value => 'SHIP_LINE_GROUP_ID AND SHIP_LINE_GROUP_NUM',
5503: p_token2_name => 'ID_NAME',
5504: p_token2_value => 'INL_SHIP_LINES_INT',
5505: p_token3_name => 'ID_VAL',
5506: p_token3_value => l_ship_line_int_id,
5507: x_return_status => l_return_status) ;
5508: -- If any errors happen abort API.

Line 5523: p_parent_table_name => 'INL_SHIP_LINES_INT',

5519: l_response := FALSE;
5520:
5521: -- Add a line into inl_ship_errors
5522: Handle_InterfError(
5523: p_parent_table_name => 'INL_SHIP_LINES_INT',
5524: p_parent_table_id => l_ship_line_int_id,
5525: p_column_name => 'TRANSACTION_TYPE',
5526: p_column_value => 'CREATE',
5527: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 5531: p_token2_value => 'INL_SHIP_LINES_INT',

5527: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
5528: p_token1_name => 'COLUMN',
5529: p_token1_value => 'SHIP_LINE_ID AND SHIP_LINE_NUM',
5530: p_token2_name => 'ID_NAME',
5531: p_token2_value => 'INL_SHIP_LINES_INT',
5532: p_token3_name => 'ID_VAL',
5533: p_token3_value => l_ship_line_int_id,
5534: x_return_status => l_return_status) ;
5535: -- If any errors happen abort API.

Line 6040: FROM inl_ship_lines_int sli

6036: p_debug_info => l_debug_info);
6037:
6038: SELECT DISTINCT(sli.ship_line_src_type_code)
6039: INTO l_ship_line_src_type_code
6040: FROM inl_ship_lines_int sli
6041: WHERE sli.ship_header_int_id = p_ship_header_int_id;
6042:
6043: INL_LOGGING_PVT.Log_Variable(
6044: p_module_name => g_module_name,

Line 7014: p_parent_table_name => 'INL_SHIP_LINES_INT',

7010: x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_group_num IS NULL THEN
7011: l_response := FALSE;
7012: -- Add a line into inl_ship_errors
7013: Handle_InterfError(
7014: p_parent_table_name => 'INL_SHIP_LINES_INT',
7015: p_parent_table_id => l_ship_line_int_id,
7016: p_column_name => 'TRANSACTION_TYPE',
7017: p_column_value => 'UPDATE',
7018: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 7022: p_token2_value => 'INL_SHIP_LINES_INT',

7018: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
7019: p_token1_name => 'COLUMN',
7020: p_token1_value => 'SHIP_LINE_GROUP_ID OR SHIP_LINE_GROUP_NUM',
7021: p_token2_name => 'ID_NAME',
7022: p_token2_value => 'INL_SHIP_LINES_INT',
7023: p_token3_name => 'ID_VAL',
7024: p_token3_value => l_ship_line_int_id,
7025: x_return_status => l_return_status) ;
7026: -- If any errors happen abort API.

Line 7045: p_parent_table_name => 'INL_SHIP_LINES_INT',

7041: x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num IS NULL THEN
7042: l_response := FALSE;
7043: -- Add a line into inl_ship_errors
7044: Handle_InterfError(
7045: p_parent_table_name => 'INL_SHIP_LINES_INT',
7046: p_parent_table_id => l_ship_line_int_id,
7047: p_column_name => 'TRANSACTION_TYPE',
7048: p_column_value => 'UPDATE',
7049: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',

Line 7053: p_token2_value => 'INL_SHIP_LINES_INT',

7049: p_error_message_name => 'INL_ERR_TRX_TP_ID_NULL',
7050: p_token1_name => 'COLUMN',
7051: p_token1_value => 'SHIP_LINE_ID OR SHIP_LINE_NUM',
7052: p_token2_name => 'ID_NAME',
7053: p_token2_value => 'INL_SHIP_LINES_INT',
7054: p_token3_name => 'ID_VAL',
7055: p_token3_value => l_ship_line_int_id,
7056: x_return_status => l_return_status) ;
7057: -- If any errors happen abort API.

Line 7075: p_parent_table_name => 'INL_SHIP_LINES_INT',

7071: x_ship_ln_int_lst(l_ship_ln_int_idx).party_number IS NOT NULL THEN
7072: l_response := FALSE;
7073: -- Add a line into inl_ship_errors
7074: Handle_InterfError(
7075: p_parent_table_name => 'INL_SHIP_LINES_INT',
7076: p_parent_table_id => l_ship_line_int_id,
7077: p_column_name => 'TRANSACTION_TYPE',
7078: p_column_value => 'UPDATE',
7079: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7083: p_token2_value => 'INL_SHIP_LINES_INT',

7079: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7080: p_token1_name => 'COLUMN',
7081: p_token1_value => 'PARTY_ID AND PARTY_NUMBER',
7082: p_token2_name => 'ID_NAME',
7083: p_token2_value => 'INL_SHIP_LINES_INT',
7084: p_token3_name => 'ID_VAL',
7085: p_token3_value => l_ship_line_int_id,
7086: x_return_status => l_return_status) ;
7087: -- If any errors happen abort API.

Line 7105: p_parent_table_name => 'INL_SHIP_LINES_INT',

7101: x_ship_ln_int_lst(l_ship_ln_int_idx).party_site_number IS NOT NULL THEN
7102: l_response := FALSE;
7103: -- Add a line into inl_ship_errors
7104: Handle_InterfError(
7105: p_parent_table_name => 'INL_SHIP_LINES_INT',
7106: p_parent_table_id => l_ship_line_int_id,
7107: p_column_name => 'TRANSACTION_TYPE',
7108: p_column_value => 'UPDATE',
7109: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7113: p_token2_value => 'INL_SHIP_LINES_INT',

7109: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7110: p_token1_name => 'COLUMN',
7111: p_token1_value => 'PARTY_SITE_ID AND PARTY_SITE_NUMBER',
7112: p_token2_name => 'ID_NAME',
7113: p_token2_value => 'INL_SHIP_LINES_INT',
7114: p_token3_name => 'ID_VAL',
7115: p_token3_value => l_ship_line_int_id,
7116: x_return_status => l_return_status) ;
7117: -- If any errors happen abort API.

Line 7135: p_parent_table_name => 'INL_SHIP_LINES_INT',

7131: x_ship_ln_int_lst(l_ship_ln_int_idx).source_organization_code IS NOT NULL THEN
7132: l_response := FALSE;
7133: -- Add a line into inl_ship_errors
7134: Handle_InterfError(
7135: p_parent_table_name => 'INL_SHIP_LINES_INT',
7136: p_parent_table_id => l_ship_line_int_id,
7137: p_column_name => 'TRANSACTION_TYPE',
7138: p_column_value => 'UPDATE',
7139: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7143: p_token2_value => 'INL_SHIP_LINES_INT',

7139: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7140: p_token1_name => 'COLUMN',
7141: p_token1_value => 'SOURCE_ORGANIZATION_ID AND SOURCE_ORGANIZATION_CODE',
7142: p_token2_name => 'ID_NAME',
7143: p_token2_value => 'INL_SHIP_LINES_INT',
7144: p_token3_name => 'ID_VAL',
7145: p_token3_value => l_ship_line_int_id,
7146: x_return_status => l_return_status) ;
7147: -- If any errors happen abort API.

Line 7165: p_parent_table_name => 'INL_SHIP_LINES_INT',

7161: x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_type_code IS NOT NULL THEN
7162: l_response := FALSE;
7163: -- Add a line into inl_ship_errors
7164: Handle_InterfError(
7165: p_parent_table_name => 'INL_SHIP_LINES_INT',
7166: p_parent_table_id => l_ship_line_int_id,
7167: p_column_name => 'TRANSACTION_TYPE',
7168: p_column_value => 'UPDATE',
7169: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7194: p_parent_table_name => 'INL_SHIP_LINES_INT',

7190: IF x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_src_type_code IS NOT NULL THEN
7191: l_response := FALSE;
7192: -- Add a line into inl_ship_errors
7193: Handle_InterfError(
7194: p_parent_table_name => 'INL_SHIP_LINES_INT',
7195: p_parent_table_id => l_ship_line_int_id,
7196: p_column_name => 'TRANSACTION_TYPE',
7197: p_column_value => 'UPDATE',
7198: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7202: p_token2_value => 'INL_SHIP_LINES_INT',

7198: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7199: p_token1_name => 'COLUMN',
7200: p_token1_value => 'SHIP_LINE_SRC_TYPE_CODE',
7201: p_token2_name => 'ID_NAME',
7202: p_token2_value => 'INL_SHIP_LINES_INT',
7203: p_token3_name => 'ID_VAL',
7204: p_token3_value => l_ship_line_int_id,
7205: x_return_status => l_return_status) ;
7206: -- If any errors happen abort API.

Line 7223: p_parent_table_name => 'INL_SHIP_LINES_INT',

7219: IF x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_source_id IS NOT NULL THEN
7220: l_response := FALSE;
7221: -- Add a line into inl_ship_errors
7222: Handle_InterfError(
7223: p_parent_table_name => 'INL_SHIP_LINES_INT',
7224: p_parent_table_id => l_ship_line_int_id,
7225: p_column_name => 'TRANSACTION_TYPE',
7226: p_column_value => 'UPDATE',
7227: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7231: p_token2_value => 'INL_SHIP_LINES_INT',

7227: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7228: p_token1_name => 'COLUMN',
7229: p_token1_value => 'SHIP_LINE_SOURCE_ID',
7230: p_token2_name => 'ID_NAME',
7231: p_token2_value => 'INL_SHIP_LINES_INT',
7232: p_token3_name => 'ID_VAL',
7233: p_token3_value => l_ship_line_int_id,
7234: x_return_status => l_return_status) ;
7235: -- If any errors happen abort API.

Line 7252: p_parent_table_name => 'INL_SHIP_LINES_INT',

7248: IF x_ship_ln_int_lst(l_ship_ln_int_idx).currency_code IS NOT NULL THEN
7249: l_response := FALSE;
7250: -- Add a line into inl_ship_errors
7251: Handle_InterfError(
7252: p_parent_table_name => 'INL_SHIP_LINES_INT',
7253: p_parent_table_id => l_ship_line_int_id,
7254: p_column_name => 'TRANSACTION_TYPE',
7255: p_column_value => 'UPDATE',
7256: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7260: p_token2_value => 'INL_SHIP_LINES_INT',

7256: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7257: p_token1_name => 'COLUMN',
7258: p_token1_value => 'CURRENCY_CODE',
7259: p_token2_name => 'ID_NAME',
7260: p_token2_value => 'INL_SHIP_LINES_INT',
7261: p_token3_name => 'ID_VAL',
7262: p_token3_value => l_ship_line_int_id,
7263: x_return_status => l_return_status) ;
7264: -- If any errors happen abort API.

Line 7281: p_parent_table_name => 'INL_SHIP_LINES_INT',

7277: IF x_ship_ln_int_lst(l_ship_ln_int_idx).currency_conversion_type IS NOT NULL THEN
7278: l_response := FALSE;
7279: -- Add a line into inl_ship_errors
7280: Handle_InterfError(
7281: p_parent_table_name => 'INL_SHIP_LINES_INT',
7282: p_parent_table_id => l_ship_line_int_id,
7283: p_column_name => 'TRANSACTION_TYPE',
7284: p_column_value => 'UPDATE',
7285: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7289: p_token2_value => 'INL_SHIP_LINES_INT',

7285: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7286: p_token1_name => 'COLUMN',
7287: p_token1_value => 'CURRENCY_CONVERSION_TYPE',
7288: p_token2_name => 'ID_NAME',
7289: p_token2_value => 'INL_SHIP_LINES_INT',
7290: p_token3_name => 'ID_VAL',
7291: p_token3_value => l_ship_line_int_id,
7292: x_return_status => l_return_status) ;
7293: -- If any errors happen abort API.

Line 7310: p_parent_table_name => 'INL_SHIP_LINES_INT',

7306: IF x_ship_ln_int_lst(l_ship_ln_int_idx).currency_conversion_date IS NOT NULL THEN
7307: l_response := FALSE;
7308: -- Add a line into inl_ship_errors
7309: Handle_InterfError(
7310: p_parent_table_name => 'INL_SHIP_LINES_INT',
7311: p_parent_table_id => l_ship_line_int_id,
7312: p_column_name => 'TRANSACTION_TYPE',
7313: p_column_value => 'UPDATE',
7314: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7318: p_token2_value => 'INL_SHIP_LINES_INT',

7314: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7315: p_token1_name => 'COLUMN',
7316: p_token1_value => 'CURRENCY_CONVERSION_DATE',
7317: p_token2_name => 'ID_NAME',
7318: p_token2_value => 'INL_SHIP_LINES_INT',
7319: p_token3_name => 'ID_VAL',
7320: p_token3_value => l_ship_line_int_id,
7321: x_return_status => l_return_status) ;
7322: -- If any errors happen abort API.

Line 7339: p_parent_table_name => 'INL_SHIP_LINES_INT',

7335: IF x_ship_ln_int_lst(l_ship_ln_int_idx).currency_conversion_rate IS NOT NULL THEN
7336: l_response := FALSE;
7337: -- Add a line into inl_ship_errors
7338: Handle_InterfError(
7339: p_parent_table_name => 'INL_SHIP_LINES_INT',
7340: p_parent_table_id => l_ship_line_int_id,
7341: p_column_name => 'TRANSACTION_TYPE',
7342: p_column_value => 'UPDATE',
7343: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7347: p_token2_value => 'INL_SHIP_LINES_INT',

7343: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7344: p_token1_name => 'COLUMN',
7345: p_token1_value => 'CURRENCY_CONVERSION_RATE',
7346: p_token2_name => 'ID_NAME',
7347: p_token2_value => 'INL_SHIP_LINES_INT',
7348: p_token3_name => 'ID_VAL',
7349: p_token3_value => l_ship_line_int_id,
7350: x_return_status => l_return_status) ;
7351: -- If any errors happen abort API.

Line 7369: p_parent_table_name => 'INL_SHIP_LINES_INT',

7365: x_ship_ln_int_lst(l_ship_ln_int_idx).inventory_item_name IS NOT NULL THEN
7366: l_response := FALSE;
7367: -- Add a line into inl_ship_errors
7368: Handle_InterfError(
7369: p_parent_table_name => 'INL_SHIP_LINES_INT',
7370: p_parent_table_id => l_ship_line_int_id,
7371: p_column_name => 'TRANSACTION_TYPE',
7372: p_column_value => 'UPDATE',
7373: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',

Line 7377: p_token2_value => 'INL_SHIP_LINES_INT',

7373: p_error_message_name => 'INL_ERR_TRX_TP_ID_NNULL',
7374: p_token1_name => 'COLUMN',
7375: p_token1_value => 'INVENTORY_ITEM_ID AND INVENTORY_ITEM_NAME',
7376: p_token2_name => 'ID_NAME',
7377: p_token2_value => 'INL_SHIP_LINES_INT',
7378: p_token3_name => 'ID_VAL',
7379: p_token3_value => l_ship_line_int_id,
7380: x_return_status => l_return_status) ;
7381: -- If any errors happen abort API.

Line 7697: FROM inl_ship_lines_int sli

7693: p_var_value => p_ship_header_int_id);
7694:
7695: SELECT COUNT(1)
7696: INTO l_count_ln_proc_error
7697: FROM inl_ship_lines_int sli
7698: WHERE sli.ship_header_int_id = p_ship_header_int_id
7699: AND sli.processing_status_code = 'ERROR';
7700:
7701: INL_LOGGING_PVT.Log_Variable(

Line 7812: FROM inl_ship_lines_int sli

7808: p_var_value => p_ship_header_int_id);
7809:
7810: SELECT COUNT(DISTINCT(sli.ship_line_src_type_code))
7811: INTO l_count_ln_src_tp_code
7812: FROM inl_ship_lines_int sli
7813: WHERE sli.ship_header_int_id = p_ship_header_int_id;
7814:
7815: INL_LOGGING_PVT.Log_Variable(
7816: p_module_name => g_module_name,

Line 8100: -- inl_ship_lines_all, inl_ship_line_groups and inl_ship_headers_all

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 :

Line 8312: l_debug_info := 'Delete from inl_ship_lines_all';

8308: p_var_value => sql%rowcount
8309: );
8310:
8311: -- Table
8312: l_debug_info := 'Delete from inl_ship_lines_all';
8313: INL_LOGGING_PVT.Log_Statement(
8314: p_module_name => g_module_name,
8315: p_procedure_name => l_program_name,
8316: p_debug_info => l_debug_info) ;

Line 8318: DELETE FROM inl_ship_lines_all

8314: p_module_name => g_module_name,
8315: p_procedure_name => l_program_name,
8316: p_debug_info => l_debug_info) ;
8317:
8318: DELETE FROM inl_ship_lines_all
8319: WHERE ship_header_id = p_ship_header_id;
8320:
8321: INL_LOGGING_PVT.Log_Variable(
8322: p_module_name => g_module_name,

Line 8917: FROM inl_ship_lines_all

8913: IF x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num IS NULL THEN
8914: -- Get the next Ship Line Number
8915: SELECT MAX(ship_line_num)
8916: INTO x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num
8917: FROM inl_ship_lines_all
8918: WHERE ship_header_id = x_ship_ln_int_lst(l_ship_ln_int_idx).ship_header_id
8919: AND ship_line_group_id = x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_group_id;
8920:
8921: x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num := NVL(x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_num, 0) + 1;

Line 8935: SELECT inl_ship_Lines_all_s.NEXTVAL

8931: p_module_name => g_module_name,
8932: p_procedure_name => l_program_name,
8933: p_debug_info => l_debug_info) ;
8934: -- Get the next Shipment Line Id
8935: SELECT inl_ship_Lines_all_s.NEXTVAL
8936: INTO x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_id
8937: FROM dual;
8938:
8939: INL_LOGGING_PVT.Log_Variable(

Line 8952: INSERT INTO inl_ship_lines_all (

8948: p_procedure_name => l_program_name,
8949: p_debug_info => l_debug_info);
8950:
8951: -- Insert an INL SHIP LINE record
8952: INSERT INTO inl_ship_lines_all (
8953: ship_header_id, --01
8954: ship_line_group_id, --02
8955: ship_line_id, --03
8956: ship_line_num, --04

Line 9117: UPDATE inl_ship_lines_all sl

9113: p_procedure_name => l_program_name,
9114: p_debug_info => l_debug_info) ;
9115:
9116: -- update the INL SHIP LINE record
9117: UPDATE inl_ship_lines_all sl
9118: SET adjustment_num = 0,
9119: match_id = NULL,
9120: txn_qty = NVL(x_ship_ln_int_lst(l_ship_ln_int_idx).txn_qty , sl.txn_qty) ,
9121: txn_uom_code = NVL(x_ship_ln_int_lst(l_ship_ln_int_idx).txn_uom_code , sl.txn_uom_code) ,

Line 9187: UPDATE inl_ship_lines_int

9183: p_procedure_name => l_program_name,
9184: p_debug_info => l_debug_info) ;
9185: -- Set processing status code to COMPLETED
9186: -- for a given and imported Shipment Line
9187: UPDATE inl_ship_lines_int
9188: SET processing_status_code = 'COMPLETED' ,
9189: ship_header_id = x_ship_ln_int_lst(l_ship_ln_int_idx).ship_header_id ,
9190: ship_line_group_id = x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_group_id ,
9191: ship_line_id = x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_id ,

Line 9731: x_new_to_parent_table_name := 'INL_SHIP_LINES';

9727: p_procedure_name => l_program_name,
9728: p_debug_info => l_debug_info
9729: ) ;
9730: IF x_new_to_parent_table_name = 'RCV_TRANSACTIONS' THEN
9731: x_new_to_parent_table_name := 'INL_SHIP_LINES';
9732: SELECT lcm_shipment_line_id
9733: INTO x_new_to_parent_table_id
9734: FROM rcv_transactions rt
9735: WHERE rt.transaction_id = x_new_to_parent_table_id

Line 10026: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINES' 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
10029: FROM inl_ship_lines_all --Bug#10381495
10030: WHERE ship_line_id = x_new_to_parent_table_id;

Line 10029: FROM inl_ship_lines_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
10029: FROM inl_ship_lines_all --Bug#10381495
10030: WHERE ship_line_id = x_new_to_parent_table_id;
10031: ELSIF x_new_to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
10032: SELECT ship_header_id
10033: INTO x_ship_header_id

Line 10440: FROM inl_ship_lines sl,

10436:
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

Line 11510: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'

11506: SELECT m1.match_id,
11507: m1.matched_qty ,
11508: m1.matched_uom_code
11509: FROM inl_corr_matches_v m1
11510: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
11511: AND m1.to_parent_table_id = p_ship_line_id
11512: AND m1.match_type_code = 'ITEM'
11513: AND m1.replace_estim_qty_flag = 'N'
11514: -- In case of resubmit the same actual value more than once, the

Line 11539: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'

11535: m1.matched_qty ,
11536: m1.matched_uom_code ,
11537: m1.replace_estim_qty_flag
11538: FROM inl_matches_int m1
11539: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
11540: AND m1.to_parent_table_id = p_ship_line_id
11541: AND m1.match_int_id <> NVL(p_updated_match_id, 0)
11542: AND m1.processing_status_code = 'RUNNING'
11543: ORDER BY m1.match_int_id

Line 11599: inl_ship_lines_all sl, --Bug#10381495

11595: --Bug#9660043 l_ship_line_group_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

Line 11658: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'

11654: INTO l_unproc_actual_qty,
11655: l_unproc_uom_code,
11656: l_unproc_match_id
11657: FROM inl_corr_matches_v m1
11658: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
11659: AND m1.to_parent_table_id = p_ship_line_id
11660: AND m1.match_type_code = 'ITEM'
11661: AND m1.replace_estim_qty_flag = 'Y'
11662: AND m1.adj_already_generated_flag = 'N'

Line 11742: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'

11738: )
11739: )
11740: INTO l_unproc_actual_qty
11741: FROM inl_corr_matches_v m1
11742: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
11743: AND m1.to_parent_table_id = p_ship_line_id
11744: AND m1.match_type_code = 'ITEM'
11745: AND m1.replace_estim_qty_flag = 'N'
11746: AND m1.adj_already_generated_flag = 'N'

Line 12410: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN

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
12409: FOR UPDATE of sh.ship_header_id NOWAIT; -- SCM-051
12410: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN
12411:
12412: INL_LOGGING_PVT.Log_Statement(
12413: p_module_name => g_module_name,
12414: p_procedure_name => l_program_name,

Line 12415: p_debug_info => 'Verify if Ship Line has an ELC update to parent INL_SHIP_LINES with FOR UPDATE of inl_ship_headers');

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,

Line 12508: inl_ship_lines_all sl,

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
12512: AND NVL(sl.parent_ship_line_id,sl.ship_line_id) = rt.lcm_shipment_line_id

Line 12529: inl_ship_lines_all sl,

12525: l_count_elc_ong
12526: FROM
12527: inl_adj_charge_lines_v cl,
12528: inl_associations a,
12529: inl_ship_lines_all sl,
12530: rcv_transactions rt
12531: WHERE
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

Line 12542: (a.to_parent_table_name = 'INL_SHIP_LINES'

12538: OR
12539: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
12540: AND a.to_parent_table_id = sl.ship_line_group_id)
12541: OR
12542: (a.to_parent_table_name = 'INL_SHIP_LINES'
12543: AND a.to_parent_table_id = NVL(sl.parent_ship_line_id,sl.ship_line_id))
12544: )
12545: AND cl.charge_line_type_id = p_charge_line_type_id
12546: AND cl.adjustment_num <= 0

Line 12565: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN

12561: OR cl.new_charge_amt IS NOT NULL
12562: OR cl.adjustment_type_flag = 'A') -- new ELC charge line waiting for submit
12563: ;
12564:
12565: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN
12566:
12567: INL_LOGGING_PVT.Log_Statement(
12568: p_module_name => g_module_name,
12569: p_procedure_name => l_program_name,

Line 12570: p_debug_info => 'Verify if Charge Line has an ELC update to parent INL_SHIP_LINES');

12566:
12567: INL_LOGGING_PVT.Log_Statement(
12568: p_module_name => g_module_name,
12569: p_procedure_name => l_program_name,
12570: p_debug_info => 'Verify if Charge Line has an ELC update to parent INL_SHIP_LINES');
12571:
12572: -- SCM-051
12573: SELECT sh.ship_num
12574: INTO l_ship_num

Line 12576: inl_ship_lines_all sl

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
12580: FOR UPDATE OF sh.ship_header_id NOWAIT;

Line 12586: p_debug_info => 'Verify if Charge Line has an ELC update to parent INL_SHIP_LINES');

12582:
12583: INL_LOGGING_PVT.Log_Statement(
12584: p_module_name => g_module_name,
12585: p_procedure_name => l_program_name,
12586: p_debug_info => 'Verify if Charge Line has an ELC update to parent INL_SHIP_LINES');
12587:
12588: SELECT
12589: NVL(COUNT(*),0)
12590: INTO

Line 12595: inl_ship_lines_all sl

12591: l_count_elc_ong
12592: FROM
12593: inl_adj_charge_lines_v cl,
12594: inl_associations a,
12595: inl_ship_lines_all sl
12596: WHERE
12597: sl.ship_line_id = p_to_parent_table_id
12598: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
12599: AND (

Line 12606: (a.to_parent_table_name = 'INL_SHIP_LINES'

12602: OR
12603: (a.to_parent_table_name = 'INL_SHIP_LINE_GROUPS'
12604: AND a.to_parent_table_id = sl.ship_line_group_id)
12605: OR
12606: (a.to_parent_table_name = 'INL_SHIP_LINES'
12607: AND a.to_parent_table_id = NVL(sl.parent_ship_line_id,sl.ship_line_id))
12608: )
12609: AND cl.charge_line_type_id = p_charge_line_type_id
12610: AND cl.adjustment_num <= 0

Line 13177: 'INL_SHIP_LINES',

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'

Line 13184: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',

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

Line 13203: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN

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;
13203: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN
13204: l_INT_importedOk := 'Y';
13205: SELECT ship_header_id
13206: INTO l_ship_header_id
13207: FROM inl_ship_lines_all --Bug#10381495

Line 13207: FROM inl_ship_lines_all --Bug#10381495

13203: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES' THEN
13204: l_INT_importedOk := 'Y';
13205: SELECT ship_header_id
13206: INTO l_ship_header_id
13207: FROM inl_ship_lines_all --Bug#10381495
13208: WHERE ship_line_id = p_to_parent_table_id;
13209: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
13210: l_matchTpCdOk := 'Y';
13211: END IF;

Line 13246: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES_INT' THEN

13242: WHERE tax_line_id = p_to_parent_table_id;
13243: IF p_match_type_code IN('TAX') THEN
13244: l_matchTpCdOk := 'Y';
13245: END IF;
13246: ELSIF p_to_parent_table_name = 'INL_SHIP_LINES_INT' THEN
13247: --Bug#9660043
13248: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
13249: l_matchTpCdOk := 'Y';
13250: END IF;

Line 13259: inl_ship_lines_int sli,

13255: INTO
13256: l_ship_header_id,
13257: l_INT_importedOk
13258: FROM
13259: inl_ship_lines_int sli,
13260: inl_ship_lines_all sl --Bug#10381495
13261: WHERE
13262: sli.ship_line_int_id = p_to_parent_table_id
13263: AND sl.ship_line_int_id = p_to_parent_table_id;

Line 13260: inl_ship_lines_all sl --Bug#10381495

13256: l_ship_header_id,
13257: l_INT_importedOk
13258: FROM
13259: inl_ship_lines_int sli,
13260: inl_ship_lines_all sl --Bug#10381495
13261: WHERE
13262: sli.ship_line_int_id = p_to_parent_table_id
13263: AND sl.ship_line_int_id = p_to_parent_table_id;
13264: --Bug#9660043

Line 13269: FROM inl_ship_lines_int sli

13265:
13266: /* --Bug#9660043
13267: SELECT sli.ship_header_id
13268: INTO l_ship_header_id
13269: FROM inl_ship_lines_int sli
13270: WHERE sli.ship_line_int_id = p_to_parent_table_id;
13271: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
13272: l_matchTpCdOk := 'Y';
13273: END IF;

Line 13277: FROM inl_ship_lines sl

13273: END IF;
13274: -- Check if the Interface has been imported
13275: SELECT sl.ship_header_id
13276: INTO l_ship_header_id
13277: FROM inl_ship_lines sl
13278: WHERE sl.ship_line_int_id = p_to_parent_table_id;
13279: l_INT_importedOk := 'Y';
13280: */--Bug#9660043
13281:

Line 13336: inl_ship_lines_all sl --Bug#10381495

13332: l_ship_line_id,
13333: l_ship_header_id
13334: FROM
13335: rcv_transactions rt,
13336: inl_ship_lines_all sl --Bug#10381495
13337: WHERE
13338: rt.transaction_id = p_to_parent_table_id
13339: AND sl.ship_line_id = rt.lcm_shipment_line_id
13340: ;

Line 13350: FROM inl_ship_lines sl

13346: WHERE rt.transaction_id = p_to_parent_table_id;
13347:
13348: SELECT sl.ship_header_id
13349: INTO l_ship_header_id
13350: FROM inl_ship_lines sl
13351: WHERE sl.ship_line_id = l_ship_line_id;
13352: IF p_match_type_code IN('ITEM', 'CHARGE', 'TAX') THEN
13353: l_matchTpCdOk := 'Y';
13354: END IF;

Line 14247: IF((p_match_int_rec.to_parent_table_name = 'INL_SHIP_LINES'

14243: p_module_name => g_module_name,
14244: p_procedure_name => l_program_name,
14245: p_debug_info => l_debug_info
14246: );
14247: IF((p_match_int_rec.to_parent_table_name = 'INL_SHIP_LINES'
14248: AND p_match_int_rec.match_type_code = 'ITEM')
14249: OR (l_parent_to_parent_table_name = 'INL_SHIP_LINES'
14250: AND l_parent_match_type_code = 'ITEM'
14251: )

Line 14249: OR (l_parent_to_parent_table_name = 'INL_SHIP_LINES'

14245: p_debug_info => l_debug_info
14246: );
14247: IF((p_match_int_rec.to_parent_table_name = 'INL_SHIP_LINES'
14248: AND p_match_int_rec.match_type_code = 'ITEM')
14249: OR (l_parent_to_parent_table_name = 'INL_SHIP_LINES'
14250: AND l_parent_match_type_code = 'ITEM'
14251: )
14252: ) AND p_match_int_rec.matched_qty IS NOT NULL
14253: THEN

Line 15361: l_debug_info := 'Delete from INL_SHIP_LINES_INT ';

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,
15363: p_procedure_name => l_program_name,
15364: p_debug_info => l_debug_info);
15365:

Line 15366: DELETE FROM inl_ship_lines_int

15362: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
15363: p_procedure_name => l_program_name,
15364: p_debug_info => l_debug_info);
15365:
15366: DELETE FROM inl_ship_lines_int
15367: WHERE ship_header_int_id = shipToDelete_List(iHead).ship_header_int_id;
15368:
15369: END LOOP;
15370: END IF;

Line 16262: FROM inl_ship_lines_int l

16258: AND h.processing_status_code = 'PENDING'
16259: AND h.transaction_type = 'CREATE'
16260: AND NOT EXISTS
16261: (SELECT 1
16262: FROM inl_ship_lines_int l
16263: WHERE l.ship_header_int_id = h.ship_header_int_id
16264: AND ROWNUM < 2);
16265:
16266: l_debug_info := 'Inserted '||SQL%ROWCOUNT ||' error messages into Interface Error table.';

Line 16294: FROM inl_ship_lines_int l

16290: AND processing_status_code = 'PENDING'
16291: AND transaction_type = 'CREATE'
16292: AND NOT EXISTS
16293: (SELECT 1
16294: FROM inl_ship_lines_int l
16295: WHERE l.ship_header_int_id = h.ship_header_int_id
16296: AND ROWNUM < 2);
16297: END IF;
16298: -- Standard End of Procedure/Function Logging

Line 17467: -- from INL_SHIP_HEADERS_INT and INL_SHIP_LINES_INT

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,

Line 17598: inl_ship_lines_all sl

17594: CURSOR c_matches_int_error IS
17595: SELECT DISTINCT m.group_id
17596: FROM inl_matches_int m,
17597: rcv_transactions rt,
17598: inl_ship_lines_all sl
17599: WHERE sl.ship_line_id = rt.lcm_shipment_line_id
17600: AND rt.transaction_id = m.to_parent_table_id
17601: AND m.to_parent_table_name = 'RCV_TRANSACTIONS'
17602: AND m.processing_status_code = 'ERROR'

Line 17642: inl_ship_lines_all sl,

17638: SELECT COUNT(1)
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