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_MATCHES

Line 119: ELSIF p_parent_table_name = 'INL_MATCHES_INT' THEN

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(
122: p_module_name => g_module_name,
123: p_procedure_name => l_proc_name,

Line 126: UPDATE inl_matches_int

122: p_module_name => g_module_name,
123: p_procedure_name => l_proc_name,
124: p_debug_info => l_debug_info
125: ) ;
126: UPDATE inl_matches_int
127: SET processing_status_code = 'ERROR' ,
128: request_id = fnd_global.conc_request_id,
129: last_updated_by = fnd_global.user_id ,
130: last_update_date = SYSDATE ,

Line 3442: FROM inl_matches

3438: p_debug_info => l_debug_info
3439: ) ;
3440: SELECT MIN(match_id)
3441: INTO x_parent_match_id
3442: FROM inl_matches
3443: WHERE to_parent_table_id = p_to_parent_table_id
3444: AND to_parent_table_name = p_to_parent_table_name
3445: AND from_parent_table_id = p_from_parent_table_id
3446: AND from_parent_table_name = p_from_parent_table_name

Line 3520: -- are recorded in interface tables by the INL_MATCHES_GRP package

3516: --
3517: -- Version : Current version 1.0
3518: --
3519: -- Notes : When the information come from AP the amounts variations
3520: -- are recorded in interface tables by the INL_MATCHES_GRP package
3521: -- and the adjustment program wait for final amounts.
3522: -- In order to equalize the information in this proc we:
3523: -- - receive the values of the new match
3524: PROCEDURE Derive_FromAP(

Line 3673: inl_matches mat1,

3669: l_mat_par_mat_id_P ,
3670: l_corr_from_parent_table_name,
3671: l_corr_from_parent_table_id
3672: FROM
3673: inl_matches mat1,
3674: (select *
3675: from inl_matches m2
3676: where NOT (m2.from_parent_table_name = p_from_parent_table_name
3677: AND m2.from_parent_table_id = p_from_parent_table_id)

Line 3675: from inl_matches m2

3671: l_corr_from_parent_table_id
3672: FROM
3673: inl_matches mat1,
3674: (select *
3675: from inl_matches m2
3676: where NOT (m2.from_parent_table_name = p_from_parent_table_name
3677: AND m2.from_parent_table_id = p_from_parent_table_id)
3678: ) mat2
3679: WHERE

Line 3687: FROM inl_matches mat1B

3683: AND mat1.from_parent_table_id = x_new_to_parent_table_id
3684: AND mat1.match_id
3685: =(
3686: SELECT MAX(mat1B.match_id)
3687: FROM inl_matches mat1B
3688: WHERE mat1B.to_parent_table_name = mat1.to_parent_table_name
3689: AND mat1B.to_parent_table_id = mat1.to_parent_table_id
3690: AND mat1B.from_parent_table_name = mat1.from_parent_table_name
3691: AND mat1B.from_parent_table_id = mat1.from_parent_table_id

Line 3698: FROM inl_matches mat1C,

3694: OR mat2.match_id = mat1.match_id
3695: OR mat2.match_id
3696: =(
3697: SELECT MAX(DECODE(mat2.match_id, mat1.match_id, NULL, mat2.match_id))
3698: FROM inl_matches mat1C,
3699: inl_matches mat2C
3700: WHERE mat2C.parent_match_id (+) = mat1C.match_id
3701: AND mat2C.match_type_code (+) = 'CORRECTION'
3702: AND NOT (mat2C.from_parent_table_name = p_from_parent_table_name

Line 3699: inl_matches mat2C

3695: OR mat2.match_id
3696: =(
3697: SELECT MAX(DECODE(mat2.match_id, mat1.match_id, NULL, mat2.match_id))
3698: FROM inl_matches mat1C,
3699: inl_matches mat2C
3700: WHERE mat2C.parent_match_id (+) = mat1C.match_id
3701: AND mat2C.match_type_code (+) = 'CORRECTION'
3702: AND NOT (mat2C.from_parent_table_name = p_from_parent_table_name
3703: AND mat2C.from_parent_table_id = p_from_parent_table_id)

Line 3907: FROM inl_matches

3903: WHERE tax_line_id = x_new_to_parent_table_id;
3904: ELSE -- In case of correction, the table is out of LCM limit
3905: SELECT ship_header_id
3906: INTO x_ship_header_id
3907: FROM inl_matches
3908: WHERE match_id = l_mat_par_mat_id_P;
3909: END IF;
3910: --
3911: -- Standard End of Procedure/Function Logging

Line 3990: SELECT inl_matches_s.NEXTVAL new_match_id,

3986: matchAmountsToProcess_List matchAmountsToProcess_ListType;
3987:
3988: CURSOR matchesToProcess
3989: IS
3990: SELECT inl_matches_s.NEXTVAL new_match_id,
3991: match_type_code ,
3992: from_parent_table_name,
3993: from_parent_table_id ,
3994: to_parent_table_name ,

Line 4013: FROM inl_matches_int

4009: tax_amt_included_flag,
4010: match_amount_int_id ,
4011: match_int_id ,
4012: transaction_type
4013: FROM inl_matches_int
4014: WHERE processing_status_code = 'RUNNING' /* Point 1: If any change occur here the other 4 points might be affected */
4015: AND (p_group_id IS NULL
4016: OR p_group_id = group_id)
4017: ;

Line 4233: INSERT INTO inl_matches(

4229: p_debug_info => l_debug_info
4230: ) ;
4231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4232: ELSE
4233: INSERT INTO inl_matches(
4234: match_id , /* 01 */
4235: match_type_code , /* 02 */
4236: ship_header_id , /* 03 */
4237: from_parent_table_name , /* 04 */

Line 4341: UPDATE inl_matches_int m

4337: p_debug_info => l_debug_info
4338: ) ;
4339: -- Set processing status to COMPLETED for
4340: -- the current and imported Match Line
4341: UPDATE inl_matches_int m
4342: SET m.processing_status_code = 'COMPLETED' ,
4343: m.request_id = fnd_global.conc_request_id,
4344: m.last_updated_by = fnd_global.user_id ,
4345: m.last_update_date = SYSDATE ,

Line 4764: FROM inl_matches

4760: AND p_match_type_code = 'CORRECTION'
4761: THEN
4762: SELECT MIN(match_id)
4763: INTO p_parent_match_id
4764: FROM inl_matches
4765: WHERE from_parent_table_id = p_to_parent_table_id
4766: AND from_parent_table_name = p_to_parent_table_name
4767: ;
4768: END IF;

Line 4855: p_parent_table_name => 'INL_MATCHES_INT',

4851: IF p_charge_line_type_id IS NULL THEN
4852: l_result := FND_API.G_FALSE;
4853: -- Add a line into inl_ship_errors
4854: Handle_InterfError(
4855: p_parent_table_name => 'INL_MATCHES_INT',
4856: p_parent_table_id => p_match_int_id,
4857: p_column_name => 'CHARGE_LINE_TYPE_ID',
4858: p_column_value => p_charge_line_type_id,
4859: p_error_message_name => 'INL_ERR_OI_MAT_CH_LN_TP_ID_N',

Line 4876: p_parent_table_name => 'INL_MATCHES_INT',

4872: THEN
4873: l_result := FND_API.G_FALSE;
4874: -- Add a line into inl_ship_errors
4875: Handle_InterfError(
4876: p_parent_table_name => 'INL_MATCHES_INT',
4877: p_parent_table_id => p_match_int_id,
4878: p_column_name => 'CHARGE_LINE_TYPE_ID',
4879: p_column_value => p_charge_line_type_id,
4880: p_error_message_name => 'INL_ERR_OI_MAT_CH_LN_TP_ID_NN',

Line 4977: p_parent_table_name => 'INL_MATCHES_INT',

4973: IF NVL(p_parent_match_type_code, p_match_type_code) <> 'ITEM' THEN
4974: l_result := FND_API.G_FALSE;
4975: -- Add a line into inl_ship_errors
4976: Handle_InterfError(
4977: p_parent_table_name => 'INL_MATCHES_INT',
4978: p_parent_table_id => p_match_int_id,
4979: p_column_name => 'REPLACE_ESTIM_QTY_FLAG',
4980: p_column_value => p_replace_estim_qty_flag,
4981: p_error_message_name => 'INL_ERR_OI_CHK_RPL_EST_QT_FLAG',

Line 5097: FROM inl_matches_int m1

5093: m1.match_int_id ,
5094: m1.matched_qty ,
5095: m1.matched_uom_code ,
5096: m1.replace_estim_qty_flag
5097: FROM inl_matches_int m1
5098: WHERE m1.to_parent_table_name = 'INL_SHIP_LINES'
5099: AND m1.to_parent_table_id = p_ship_line_id
5100: AND m1.match_int_id <> NVL(p_updated_match_id, 0)
5101: AND m1.processing_status_code = 'RUNNING'

Line 5450: p_parent_table_name => 'INL_MATCHES_INT',

5446: p_debug_info => l_debug_info
5447: );
5448: -- Add a line into inl_ship_errors
5449: Handle_InterfError(
5450: p_parent_table_name => 'INL_MATCHES_INT',
5451: p_parent_table_id => p_match_int_id,
5452: p_column_name => 'MATCHED_QTY',
5453: p_column_value => p_matched_qty,
5454: p_error_message_name => 'INL_ERR_OI_MAT_INSUF_EST_QTY',

Line 5569: p_parent_table_name => 'INL_MATCHES_INT',

5565: THEN
5566: l_result := FND_API.G_FALSE;
5567: -- Add a line into inl_ship_errors
5568: Handle_InterfError(
5569: p_parent_table_name => 'INL_MATCHES_INT',
5570: p_parent_table_id => p_match_int_id,
5571: p_column_name => 'NREC_TAX_AMT',
5572: p_column_value => p_nrec_tax_amt,
5573: p_error_message_name => 'INL_ERR_OI_CHK_NREC_TAX_AMT',

Line 5593: p_parent_table_name => 'INL_MATCHES_INT',

5589: IF p_tax_code IS NULL THEN
5590: l_result := FND_API.G_FALSE;
5591: -- Add a line into inl_ship_errors
5592: Handle_InterfError(
5593: p_parent_table_name => 'INL_MATCHES_INT',
5594: p_parent_table_id => p_match_int_id,
5595: p_column_name => 'TAX_CODE',
5596: p_column_value => p_tax_code,
5597: p_error_message_name => 'INL_ERR_OI_CHK_TX_CODE_NULL',

Line 5617: p_parent_table_name => 'INL_MATCHES_INT',

5613: IF p_tax_amt_included_flag IS NULL THEN
5614: l_result := FND_API.G_FALSE;
5615: -- Add a line into inl_ship_errors
5616: Handle_InterfError(
5617: p_parent_table_name => 'INL_MATCHES_INT',
5618: p_parent_table_id => p_match_int_id,
5619: p_column_name => 'TAX_AMT_INCLUDED_FLAG',
5620: p_column_value => p_tax_amt_included_flag,
5621: p_error_message_name => 'INL_ERR_OI_CHK_TX_AMT_FLG_NULL',

Line 5635: p_parent_table_name => 'INL_MATCHES_INT',

5631: ELSIF p_tax_amt_included_flag IS NOT NULL OR p_tax_code IS NOT NULL OR NVL(p_nrec_tax_amt, 0) <> 0 THEN
5632: l_result := FND_API.G_FALSE;
5633: -- Add a line into inl_ship_errors
5634: Handle_InterfError(
5635: p_parent_table_name => 'INL_MATCHES_INT',
5636: p_parent_table_id => p_match_int_id,
5637: p_column_name => 'TAX_INT_ID',
5638: p_column_value => p_match_int_id,
5639: p_error_message_name => 'INL_ERR_OI_CHK_TX_FIELD_NNULL',

Line 5744: p_parent_table_name => 'INL_MATCHES_INT',

5740: IF p_parent_matched_curr_code <> p_matched_curr_code THEN
5741: l_result := FND_API.G_FALSE;
5742: -- Add a line into inl_ship_errors
5743: Handle_InterfError(
5744: p_parent_table_name => 'INL_MATCHES_INT',
5745: p_parent_table_id => p_match_int_id,
5746: p_column_name => 'MATCHED_AMT',
5747: p_column_value => p_matched_amt,
5748: p_error_message_name => 'INL_ERR_OI_CHK_CURR_INV',

Line 5774: p_parent_table_name => 'INL_MATCHES_INT',

5770: THEN
5771: l_result := FND_API.G_FALSE;
5772: -- Add a line into inl_ship_errors
5773: Handle_InterfError(
5774: p_parent_table_name => 'INL_MATCHES_INT',
5775: p_parent_table_id => p_match_int_id,
5776: p_column_name => 'MATCHED_AMT',
5777: p_column_value => p_matched_amt,
5778: p_error_message_name => 'INL_ERR_OI_CHK_AMT_NULL',

Line 5872: p_parent_table_name => 'INL_MATCHES_INT',

5868: IF p_matched_uom_code IS NULL THEN
5869: l_result := FND_API.G_FALSE;
5870: -- Add a line into inl_ship_errors
5871: Handle_InterfError(
5872: p_parent_table_name => 'INL_MATCHES_INT',
5873: p_parent_table_id => p_match_int_id,
5874: p_column_name => 'MATCHED_UOM_CODE',
5875: p_column_value => p_matched_uom_code,
5876: p_error_message_name => 'INL_ERR_OI_CHK_UOM_NULL',

Line 5899: p_parent_table_name => 'INL_MATCHES_INT',

5895: WHEN NO_DATA_FOUND THEN
5896: l_result := FND_API.G_FALSE;
5897: -- Add a line into inl_ship_errors
5898: Handle_InterfError(
5899: p_parent_table_name => 'INL_MATCHES_INT',
5900: p_parent_table_id => p_match_int_id,
5901: p_column_name => 'MATCHED_UOM_CODE',
5902: p_column_value => p_matched_uom_code,
5903: p_error_message_name => 'INL_ERR_OI_CHK_UOM_INV',

Line 5919: p_parent_table_name => 'INL_MATCHES_INT',

5915: IF p_matched_uom_code IS NOT NULL THEN
5916: l_result := FND_API.G_FALSE;
5917: -- Add a line into inl_ship_errors
5918: Handle_InterfError(
5919: p_parent_table_name => 'INL_MATCHES_INT',
5920: p_parent_table_id => p_match_int_id,
5921: p_column_name => 'MATCHED_UOM_CODE',
5922: p_column_value => p_matched_uom_code,
5923: p_error_message_name => 'INL_ERR_OI_CHK_UOM_NNULL',

Line 6024: p_parent_table_name => 'INL_MATCHES_INT',

6020: IF p_parent_match_id IS NULL THEN
6021: l_result := FND_API.G_FALSE;
6022: -- Add a line into inl_ship_errors
6023: Handle_InterfError(
6024: p_parent_table_name => 'INL_MATCHES_INT',
6025: p_parent_table_id => p_match_int_id,
6026: p_column_name => 'PARENT_MATCH_ID',
6027: p_column_value => p_parent_match_id,
6028: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NULL',

Line 6045: FROM inl_matches

6041: ELSE
6042: BEGIN
6043: SELECT adj_already_generated_flag
6044: INTO l_adj_alr_gen_flag
6045: FROM inl_matches
6046: WHERE match_id = p_parent_match_id;
6047: EXCEPTION
6048: WHEN NO_DATA_FOUND THEN
6049: l_result := FND_API.G_FALSE;

Line 6052: p_parent_table_name => 'INL_MATCHES_INT',

6048: WHEN NO_DATA_FOUND THEN
6049: l_result := FND_API.G_FALSE;
6050: -- Add a line into inl_ship_errors
6051: Handle_InterfError(
6052: p_parent_table_name => 'INL_MATCHES_INT',
6053: p_parent_table_id => p_match_int_id,
6054: p_column_name => 'PARENT_MATCH_ID',
6055: p_column_value => p_parent_match_id,
6056: p_error_message_name => 'INL_ERR_OI_CHK_PAR_MAT_ID_NF',

Line 6074: p_parent_table_name => 'INL_MATCHES_INT',

6070: IF p_parent_match_id IS NOT NULL AND p_existing_match_info_flag <> 'Y' THEN
6071: l_result := FND_API.G_FALSE;
6072: -- Add a line into inl_ship_errors
6073: Handle_InterfError(
6074: p_parent_table_name => 'INL_MATCHES_INT',
6075: p_parent_table_id => p_match_int_id,
6076: p_column_name => 'PARENT_MATCH_ID',
6077: p_column_value => p_parent_match_id,
6078: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NNULL',

Line 6103: p_parent_table_name => 'INL_MATCHES_INT',

6099: IF p_match_id IS NULL THEN
6100: l_result := FND_API.G_FALSE;
6101: -- Add a line into inl_ship_errors
6102: Handle_InterfError(
6103: p_parent_table_name => 'INL_MATCHES_INT',
6104: p_parent_table_id => p_match_int_id,
6105: p_column_name => 'MATCH_ID',
6106: p_column_value => p_match_id,
6107: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NULL',

Line 6124: FROM inl_matches

6120: ELSE
6121: BEGIN
6122: SELECT adj_already_generated_flag
6123: INTO l_adj_alr_gen_flag
6124: FROM inl_matches
6125: WHERE match_id = p_match_id;
6126: IF l_adj_alr_gen_flag <> 'N' THEN
6127: l_result := FND_API.G_FALSE;
6128: -- Add a line into inl_ship_errors

Line 6130: p_parent_table_name => 'INL_MATCHES_INT',

6126: IF l_adj_alr_gen_flag <> 'N' THEN
6127: l_result := FND_API.G_FALSE;
6128: -- Add a line into inl_ship_errors
6129: Handle_InterfError(
6130: p_parent_table_name => 'INL_MATCHES_INT',
6131: p_parent_table_id => p_match_int_id,
6132: p_column_name => 'MATCH_ID',
6133: p_column_value => p_match_id,
6134: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ADJUSTED',

Line 6149: p_parent_table_name => 'INL_MATCHES_INT',

6145: WHEN NO_DATA_FOUND THEN
6146: l_result := FND_API.G_FALSE;
6147: -- Add a line into inl_ship_errors
6148: Handle_InterfError(
6149: p_parent_table_name => 'INL_MATCHES_INT',
6150: p_parent_table_id => p_match_int_id,
6151: p_column_name => 'MATCH_ID',
6152: p_column_value => p_match_id,
6153: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NF',

Line 6406: FROM inl_matches

6402: l_idOk := 'Y';
6403: l_INT_importedOk := 'Y';
6404: SELECT ship_header_id
6405: INTO l_ship_header_id
6406: FROM inl_matches
6407: WHERE match_id = p_parent_match_id;
6408: IF p_match_type_code = 'CORRECTION' THEN
6409: l_matchTpCdOk := 'Y';
6410: END IF;

Line 6425: p_parent_table_name => 'INL_MATCHES_INT',

6421: IF(l_nameOk = 'N') THEN
6422: l_result := FND_API.G_FALSE;
6423: -- Add a line into inl_ship_errors
6424: Handle_InterfError(
6425: p_parent_table_name => 'INL_MATCHES_INT',
6426: p_parent_table_id => p_match_int_id,
6427: p_column_name => 'TO_PARENT_TABLE_NAME',
6428: p_column_value => p_to_parent_table_name,
6429: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_NAME',

Line 6431: p_token1_value => 'INL_MATCHES_INT',

6427: p_column_name => 'TO_PARENT_TABLE_NAME',
6428: p_column_value => p_to_parent_table_name,
6429: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_NAME',
6430: p_token1_name => 'NAME',
6431: p_token1_value => 'INL_MATCHES_INT',
6432: p_token2_name => 'ID',
6433: p_token2_value => p_match_int_id,
6434: x_return_status => l_return_status
6435: ) ;

Line 6445: p_parent_table_name => 'INL_MATCHES_INT',

6441: ELSIF(l_idOk = 'N') THEN
6442: l_result := FND_API.G_FALSE;
6443: -- Add a line into inl_ship_errors
6444: Handle_InterfError(
6445: p_parent_table_name => 'INL_MATCHES_INT',
6446: p_parent_table_id => p_match_int_id,
6447: p_column_name => 'TO_PARENT_TABLE_NAME',
6448: p_column_value => p_to_parent_table_name,
6449: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_ID',

Line 6451: p_token1_value => 'INL_MATCHES_INT',

6447: p_column_name => 'TO_PARENT_TABLE_NAME',
6448: p_column_value => p_to_parent_table_name,
6449: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_ID',
6450: p_token1_name => 'NAME',
6451: p_token1_value => 'INL_MATCHES_INT',
6452: p_token2_name => 'ID',
6453: p_token2_value => p_match_int_id,
6454: x_return_status => l_return_status
6455: ) ;

Line 6465: p_parent_table_name => 'INL_MATCHES_INT',

6461: IF(l_SHidOk = 'N') THEN
6462: l_result := FND_API.G_FALSE;
6463: -- Add a line into inl_ship_errors
6464: Handle_InterfError(
6465: p_parent_table_name => 'INL_MATCHES_INT',
6466: p_parent_table_id => p_match_int_id,
6467: p_column_name => 'SHIP_HEADER_ID',
6468: p_column_value => p_ship_header_id,
6469: p_error_message_name => 'INL_ERR_OI_CHK_SHIP_HEADER_ID',

Line 6471: p_token1_value => 'INL_MATCHES_INT',

6467: p_column_name => 'SHIP_HEADER_ID',
6468: p_column_value => p_ship_header_id,
6469: p_error_message_name => 'INL_ERR_OI_CHK_SHIP_HEADER_ID',
6470: p_token1_name => 'NAME',
6471: p_token1_value => 'INL_MATCHES_INT',
6472: p_token2_name => 'ID',
6473: p_token2_value => p_match_int_id,
6474: x_return_status => l_return_status) ;
6475: -- If unexpected errors happen abort

Line 6484: p_parent_table_name => 'INL_MATCHES_INT',

6480: IF(l_matchTpCdOk = 'N') THEN
6481: l_result := FND_API.G_FALSE;
6482: -- Add a line into inl_ship_errors
6483: Handle_InterfError(
6484: p_parent_table_name => 'INL_MATCHES_INT',
6485: p_parent_table_id => p_match_int_id,
6486: p_column_name => 'MATCH_TYPE_CODE',
6487: p_column_value => p_match_type_code,
6488: p_error_message_name => 'INL_ERR_OI_CHK_MATCH_TP_CD',

Line 6490: p_token1_value => 'INL_MATCHES_INT',

6486: p_column_name => 'MATCH_TYPE_CODE',
6487: p_column_value => p_match_type_code,
6488: p_error_message_name => 'INL_ERR_OI_CHK_MATCH_TP_CD',
6489: p_token1_name => 'NAME',
6490: p_token1_value => 'INL_MATCHES_INT',
6491: p_token2_name => 'ID',
6492: p_token2_value => p_match_int_id,
6493: x_return_status => l_return_status
6494: ) ;

Line 6504: p_parent_table_name => 'INL_MATCHES_INT',

6500: IF(l_INT_importedOk = 'N') THEN
6501: l_result := FND_API.G_FALSE;
6502: -- Add a line into inl_ship_errors
6503: Handle_InterfError(
6504: p_parent_table_name => 'INL_MATCHES_INT',
6505: p_parent_table_id => p_match_int_id,
6506: p_column_name => 'MATCH_TYPE_CODE',
6507: p_column_value => p_match_type_code,
6508: p_error_message_name => 'INL_ERR_OI_CHK_TO_PAR_TAB_ID2',

Line 6614: p_parent_table_name => 'INL_MATCHES_INT',

6610: IF p_match_id IS NOT NULL THEN
6611: l_result := FND_API.G_FALSE;
6612: -- Add a line into inl_ship_errors
6613: Handle_InterfError(
6614: p_parent_table_name => 'INL_MATCHES_INT',
6615: p_parent_table_id => p_match_int_id,
6616: p_column_name => 'MATCH_ID',
6617: p_column_value => p_match_id,
6618: p_error_message_name => 'INL_ERR_OI_CHK_MAT_ID_NNULL',

Line 6636: p_parent_table_name => 'INL_MATCHES_INT',

6632: IF p_match_id IS NULL THEN
6633: l_result := FND_API.G_FALSE;
6634: -- Add a line into inl_ship_errors
6635: Handle_InterfError(
6636: p_parent_table_name => 'INL_MATCHES_INT',
6637: p_parent_table_id => p_match_int_id,
6638: p_column_name => 'MATCH_ID',
6639: p_column_value => p_match_id,
6640: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_ID_NULL',

Line 6658: FROM inl_matches m

6654: SELECT adj_already_generated_flag,
6655: replace_estim_qty_flag
6656: INTO l_adj_already_generated_flag,
6657: l_replace_estim_qty_flag
6658: FROM inl_matches m
6659: WHERE m.match_id = p_match_id;
6660:
6661: INL_LOGGING_PVT.Log_Variable(
6662: p_module_name => g_module_name,

Line 6678: p_parent_table_name => 'INL_MATCHES_INT',

6674: );
6675: l_result := FND_API.G_FALSE;
6676: -- Add a line into inl_ship_errors
6677: Handle_InterfError(
6678: p_parent_table_name => 'INL_MATCHES_INT',
6679: p_parent_table_id => p_match_int_id,
6680: p_column_name => 'TRANSACTION_TYPE',
6681: p_column_value => p_transaction_type,
6682: p_error_message_name => 'INL_ERR_OI_CHK_PROC_MAT_INVL',

Line 6702: p_parent_table_name => 'INL_MATCHES_INT',

6698: );
6699: l_result := FND_API.G_FALSE;
6700: -- Add a line into inl_ship_errors
6701: Handle_InterfError(
6702: p_parent_table_name => 'INL_MATCHES_INT',
6703: p_parent_table_id => p_match_int_id,
6704: p_column_name => 'REPLACE_ESTIM_QTY_FLAG',
6705: p_column_value => p_replace_estim_qty_flag,
6706: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_INVL',

Line 6728: FROM inl_matches m1

6724: -- replace_estim_qty_flag = 'Y' and adj_already_generated_flag = 'N'
6725: BEGIN
6726: SELECT m1.match_id
6727: INTO l_other_REQF_Y_match_id
6728: FROM inl_matches m1
6729: WHERE m1.to_parent_table_name = p_to_parent_table_name
6730: AND m1.to_parent_table_id = p_to_parent_table_id
6731: AND m1.match_type_code = 'ITEM'
6732: AND m1.replace_estim_qty_flag = 'Y'

Line 6736: FROM inl_matches m2

6732: AND m1.replace_estim_qty_flag = 'Y'
6733: AND m1.adj_already_generated_flag = 'N'
6734: --For validation purpose, it will consider only the latest and not processed record
6735: AND m1.match_id IN (SELECT MAX(m2.match_id)
6736: FROM inl_matches m2
6737: WHERE m2.to_parent_table_name = m1.to_parent_table_name
6738: AND m2.to_parent_table_id = m1.to_parent_table_id
6739: AND m2.match_type_code = 'ITEM'
6740: AND m2.replace_estim_qty_flag = 'Y'

Line 6766: p_parent_table_name => 'INL_MATCHES_INT',

6762: IF p_match_id < l_other_REQF_Y_match_id THEN
6763: l_result := FND_API.G_FALSE;
6764: -- Add a line into inl_ship_errors
6765: Handle_InterfError(
6766: p_parent_table_name => 'INL_MATCHES_INT',
6767: p_parent_table_id => p_match_int_id,
6768: p_column_name => 'TRANSACTION_TYPE',
6769: p_column_value => p_transaction_type,
6770: p_error_message_name => 'INL_ERR_OI_CHK_MAT_NO_EFFECT',

Line 6786: p_parent_table_name => 'INL_MATCHES_INT',

6782: ELSE
6783: l_result := FND_API.G_FALSE;
6784: -- Add a line into inl_ship_errors
6785: Handle_InterfError(
6786: p_parent_table_name => 'INL_MATCHES_INT',
6787: p_parent_table_id => p_match_int_id,
6788: p_column_name => 'TRANSACTION_TYPE',
6789: p_column_value => p_transaction_type,
6790: p_error_message_name => 'INL_ERR_OI_CHK_TRX_TP_INVL',

Line 6981: p_parent_table_name => 'INL_MATCHES_INT',

6977: );
6978: l_result := FND_API.G_FALSE;
6979: -- Add a line into inl_ship_errors
6980: Handle_InterfError(
6981: p_parent_table_name => 'INL_MATCHES_INT',
6982: p_parent_table_id => p_match_int_id,
6983: p_column_name => l_field,
6984: p_column_value => l_field_id,
6985: p_error_message_name => 'INL_ERR_OI_CHK_PARTY_INVAL',

Line 7009: p_parent_table_name => 'INL_MATCHES_INT',

7005: IF l_field <> 'x' THEN
7006: l_result := FND_API.G_FALSE;
7007: -- Add a line into inl_ship_errors
7008: Handle_InterfError(
7009: p_parent_table_name => 'INL_MATCHES_INT',
7010: p_parent_table_id => p_match_int_id,
7011: p_column_name => l_field,
7012: p_column_value => l_field_id,
7013: p_error_message_name => 'INL_ERR_OI_CHK_PARTY_NNULL',

Line 7228: FROM inl_matches

7224: INTO l_parent_match_type_code ,
7225: l_parent_matched_curr_code ,
7226: l_parent_to_parent_table_name,
7227: l_parent_to_parent_table_ID
7228: FROM inl_matches
7229: WHERE match_id = p_match_int_rec.parent_match_id;
7230: ELSE
7231: l_parent_match_type_code := NULL;
7232: l_parent_matched_curr_code := NULL;

Line 7631: FROM inl_matches_int m

7627: matched_curr_code ,
7628: matched_curr_conversion_type,
7629: matched_curr_conversion_date,
7630: matched_curr_conversion_rate
7631: FROM inl_matches_int m
7632: WHERE (p_group_id IS NULL
7633: OR m.group_id = p_group_id
7634: )
7635: AND m.processing_status_code = 'PENDING';

Line 7673: FROM inl_matches_int m

7669: nrec_tax_amt ,
7670: tax_amt_included_flag,
7671: match_amount_int_id,
7672: null
7673: FROM inl_matches_int m
7674: WHERE (p_group_id IS NULL
7675: OR m.group_id = p_group_id)
7676: AND m.processing_status_code = 'PENDING';
7677: match_int_list match_int_list_type;

Line 7739: p_parent_table_name => 'INL_MATCHES_INT',

7735: p_procedure_name => l_proc_name,
7736: p_debug_info => l_debug_info
7737: );
7738: Reset_InterfError(
7739: p_parent_table_name => 'INL_MATCHES_INT',
7740: p_parent_table_id => match_int_list(i) .match_int_id,
7741: x_return_status => l_return_status
7742: ) ;
7743: -- If any errors happen abort the process.

Line 7796: UPDATE inl_matches_int

7792: p_procedure_name => l_proc_name,
7793: p_debug_info => l_debug_info
7794: );
7795:
7796: UPDATE inl_matches_int
7797: SET processing_status_code = 'RUNNING' ,
7798: party_id = match_int_list(i).party_id ,
7799: party_site_id = match_int_list(i).party_site_id,
7800: request_id = fnd_global.conc_request_id ,

Line 7815: p_parent_table_name => 'INL_MATCHES_INT',

7811: END LOOP;
7812: ELSE
7813: -- Add a line into inl_ship_errors
7814: Handle_InterfError(
7815: p_parent_table_name => 'INL_MATCHES_INT',
7816: p_parent_table_id => 0,
7817: p_column_name => 'P_GROUP_ID',
7818: p_column_value => p_group_id,
7819: p_error_message_name => 'INL_NO_RECORDS_FOUND_ERR',

Line 7867: FROM inl_matches_int m

7863: END IF;
7864:
7865: SELECT SUM(matched_amt)
7866: INTO l_amt_sum
7867: FROM inl_matches_int m
7868: WHERE m.match_amount_int_id = match_amounts_int_list(i).match_amount_int_id
7869: AND m.matched_curr_code = match_amounts_int_list(i).matched_curr_code
7870: ;
7871: IF l_amt_sum <> match_amounts_int_list(i).matched_amt THEN

Line 7873: UPDATE inl_matches_int m

7869: AND m.matched_curr_code = match_amounts_int_list(i).matched_curr_code
7870: ;
7871: IF l_amt_sum <> match_amounts_int_list(i).matched_amt THEN
7872: l_processing_status_code := 'ERROR';
7873: UPDATE inl_matches_int m
7874: SET processing_status_code = 'ERROR'
7875: WHERE m.match_amount_int_id = match_amounts_int_list(i).match_amount_int_id
7876: ;
7877: -- Add a line into inl_ship_errors

Line 7915: UPDATE inl_matches_int

7911: p_module_name => g_module_name,
7912: p_procedure_name => l_proc_name,
7913: p_debug_info => l_debug_info
7914: );
7915: UPDATE inl_matches_int
7916: SET processing_status_code = l_processing_status_code ,
7917: party_id = match_int_list(i) .party_id ,
7918: party_site_id = match_int_list(i) .party_site_id,
7919: request_id = fnd_global.conc_request_id ,