269: WHEN OTHERS THEN
270: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
271: p_procedure_name => l_function_name);
272:
273: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
274: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
275: FND_MESSAGE.SET_TOKEN('ALLOCATION_UOM_CODE',p_from_uom_code);
276: l_msg_data := FND_MESSAGE.GET;
277: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
270: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
271: p_procedure_name => l_function_name);
272:
273: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
274: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
275: FND_MESSAGE.SET_TOKEN('ALLOCATION_UOM_CODE',p_from_uom_code);
276: l_msg_data := FND_MESSAGE.GET;
277: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
278: END Converted_Price;
271: p_procedure_name => l_function_name);
272:
273: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
274: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
275: FND_MESSAGE.SET_TOKEN('ALLOCATION_UOM_CODE',p_from_uom_code);
276: l_msg_data := FND_MESSAGE.GET;
277: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
278: END Converted_Price;
279:
272:
273: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
274: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
275: FND_MESSAGE.SET_TOKEN('ALLOCATION_UOM_CODE',p_from_uom_code);
276: l_msg_data := FND_MESSAGE.GET;
277: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
278: END Converted_Price;
279:
280: -- Utility name : Converted_Qty
432: WHEN OTHERS THEN
433: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
434: p_procedure_name => l_function_name);
435:
436: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
437: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
438: FND_MESSAGE.SET_TOKEN('ALLOCATION_UOM_CODE',p_from_uom_code);
439: l_msg_data := FND_MESSAGE.GET;
440: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
433: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
434: p_procedure_name => l_function_name);
435:
436: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
437: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
438: FND_MESSAGE.SET_TOKEN('ALLOCATION_UOM_CODE',p_from_uom_code);
439: l_msg_data := FND_MESSAGE.GET;
440: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
441:
434: p_procedure_name => l_function_name);
435:
436: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
437: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
438: FND_MESSAGE.SET_TOKEN('ALLOCATION_UOM_CODE',p_from_uom_code);
439: l_msg_data := FND_MESSAGE.GET;
440: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
441:
442: END Converted_Qty;
435:
436: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
437: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);
438: FND_MESSAGE.SET_TOKEN('ALLOCATION_UOM_CODE',p_from_uom_code);
439: l_msg_data := FND_MESSAGE.GET;
440: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
441:
442: END Converted_Qty;
443:
486: EXCEPTION
487: WHEN OTHERS THEN
488: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
489: p_procedure_name => l_function_name);
490: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
491: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
492: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
493: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
494: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
487: WHEN OTHERS THEN
488: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
489: p_procedure_name => l_function_name);
490: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
491: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
492: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
493: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
494: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
495: l_msg_data := FND_MESSAGE.GET;
488: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
489: p_procedure_name => l_function_name);
490: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
491: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
492: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
493: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
494: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
495: l_msg_data := FND_MESSAGE.GET;
496: RAISE_APPLICATION_ERROR (-20002, l_msg_data);
489: p_procedure_name => l_function_name);
490: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
491: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
492: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
493: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
494: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
495: l_msg_data := FND_MESSAGE.GET;
496: RAISE_APPLICATION_ERROR (-20002, l_msg_data);
497: END Converted_Amt;
490: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
491: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
492: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
493: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
494: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
495: l_msg_data := FND_MESSAGE.GET;
496: RAISE_APPLICATION_ERROR (-20002, l_msg_data);
497: END Converted_Amt;
498:
491: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
492: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
493: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
494: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
495: l_msg_data := FND_MESSAGE.GET;
496: RAISE_APPLICATION_ERROR (-20002, l_msg_data);
497: END Converted_Amt;
498:
499: -- Utility name : Converted_Amt
550: EXCEPTION
551: WHEN OTHERS THEN
552: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
553: p_procedure_name => l_function_name);
554: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
555: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
556: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
557: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
558: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
551: WHEN OTHERS THEN
552: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
553: p_procedure_name => l_function_name);
554: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
555: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
556: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
557: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
558: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
559: l_msg_data := FND_MESSAGE.GET;
552: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
553: p_procedure_name => l_function_name);
554: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
555: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
556: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
557: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
558: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
559: l_msg_data := FND_MESSAGE.GET;
560: RAISE_APPLICATION_ERROR (-20002, l_msg_data);
553: p_procedure_name => l_function_name);
554: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
555: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
556: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
557: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
558: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
559: l_msg_data := FND_MESSAGE.GET;
560: RAISE_APPLICATION_ERROR (-20002, l_msg_data);
561: END Converted_Amt;
554: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
555: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
556: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
557: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
558: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
559: l_msg_data := FND_MESSAGE.GET;
560: RAISE_APPLICATION_ERROR (-20002, l_msg_data);
561: END Converted_Amt;
562:
555: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
556: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);
557: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSION_TYPE',p_currency_conversion_type);
558: FND_MESSAGE.SET_TOKEN('CURRENCY_CONVERSTION_DATE',p_currency_conversion_date);
559: l_msg_data := FND_MESSAGE.GET;
560: RAISE_APPLICATION_ERROR (-20002, l_msg_data);
561: END Converted_Amt;
562:
563:
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: ELSE
762: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHK_CH_ALLOC');
763: FND_MSG_PUB.Add;
764: RAISE FND_API.G_EXC_ERROR;
765:
766: END IF;
770: INTO l_total_amt
771: FROM INL_tax_lines
772: WHERE tax_line_id = rec_assoc.to_parent_table_id;
773: ELSE
774: FND_MESSAGE.SET_NAME('INL','INL_ERR_TX_ALLOC');
775: FND_MSG_PUB.Add;
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778: END IF;
862: INTO l_to_component_amt
863: FROM inl_adj_charge_lines_v
864: WHERE charge_line_id = p_to_component_id;
865: ELSE
866: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHK_CH_ALLOC');
867: FND_MSG_PUB.Add;
868: RAISE FND_API.G_EXC_ERROR;
869:
870: END IF;
874: INTO l_to_component_amt
875: FROM INL_tax_lines
876: WHERE tax_line_id = p_to_component_id;
877: ELSE
878: FND_MESSAGE.SET_NAME('INL','INL_ERR_TX_ALLOC');
879: FND_MSG_PUB.Add;
880: RAISE FND_API.G_EXC_ERROR;
881:
882: END IF;
2110: rec_assoc.from_parent_table_name,
2111: rec_assoc.from_parent_table_id,
2112: l_return_status)
2113: THEN
2114: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHK_IN_LOOP_ASSOC');
2115: FND_MSG_PUB.Add;
2116: RAISE FND_API.G_EXC_ERROR;
2117: END IF;
2118: