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_LANDEDCOST_PVT dependencies on FND_API

Line 38: x_return_status := FND_API.G_RET_STS_SUCCESS;

34:
35: --
36: -- Initialize return status to SUCCESS
37: --
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: l_debug_info := 'p_ship_header_id';
41: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
42: p_procedure_name => l_function_name,

Line 84: WHEN FND_API.G_EXC_ERROR THEN

80: RETURN FALSE;
81: END IF;
82:
83: EXCEPTION
84: WHEN FND_API.G_EXC_ERROR THEN
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: WHEN OTHERS THEN

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81: END IF;
82:
83: EXCEPTION
84: WHEN FND_API.G_EXC_ERROR THEN
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: WHEN OTHERS THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

82:
83: EXCEPTION
84: WHEN FND_API.G_EXC_ERROR THEN
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: WHEN OTHERS THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

83: EXCEPTION
84: WHEN FND_API.G_EXC_ERROR THEN
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: WHEN OTHERS THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
91: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_function_name);

Line 89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

85: x_return_status := FND_API.G_RET_STS_ERROR;
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: WHEN OTHERS THEN
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
91: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_function_name);
92: END IF;
93:

Line 636: x_return_status := FND_API.G_RET_STS_SUCCESS;

632: --
633: -- Initialize return status to SUCCESS
634: --
635:
636: x_return_status := FND_API.G_RET_STS_SUCCESS;
637:
638: l_allocation_basis := p_allocation_basis;
639:
640: --

Line 755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

751: FROM INL_adj_charge_lines_v
752: WHERE charge_line_id = rec_assoc.to_parent_table_id;
753:
754: -- If any errors happen abort API.
755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
756: RAISE FND_API.G_EXC_ERROR;
757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;

Line 756: RAISE FND_API.G_EXC_ERROR;

752: WHERE charge_line_id = rec_assoc.to_parent_table_id;
753:
754: -- If any errors happen abort API.
755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
756: RAISE FND_API.G_EXC_ERROR;
757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:

Line 757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

753:
754: -- If any errors happen abort API.
755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
756: RAISE FND_API.G_EXC_ERROR;
757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: ELSE

Line 758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

754: -- If any errors happen abort API.
755: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
756: RAISE FND_API.G_EXC_ERROR;
757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
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');

Line 764: RAISE FND_API.G_EXC_ERROR;

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;
767: ELSIF rec_assoc.to_parent_table_name = 'INL_TAX_LINES' THEN
768: IF l_allocation_basis = 'VALUE' THEN

Line 776: RAISE FND_API.G_EXC_ERROR;

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;
779: END LOOP;
780: CLOSE assoc;

Line 868: RAISE FND_API.G_EXC_ERROR;

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;
871: ELSIF p_to_component_name = 'INL_TAX_LINES' THEN
872: IF l_allocation_basis = 'VALUE' THEN

Line 880: RAISE FND_API.G_EXC_ERROR;

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;
883: END IF;
884:

Line 926: WHEN FND_API.G_EXC_ERROR THEN

922: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
923: p_procedure_name => l_procedure_name);
924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
928: p_procedure_name => l_procedure_name);
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 929: x_return_status := FND_API.G_RET_STS_ERROR;

925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
928: p_procedure_name => l_procedure_name);
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
932: p_procedure_name => l_procedure_name);
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

926: WHEN FND_API.G_EXC_ERROR THEN
927: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
928: p_procedure_name => l_procedure_name);
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
932: p_procedure_name => l_procedure_name);
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: WHEN OTHERS THEN

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
932: p_procedure_name => l_procedure_name);
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: WHEN OTHERS THEN
935: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
936: p_procedure_name => l_procedure_name);
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: WHEN OTHERS THEN
935: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
936: p_procedure_name => l_procedure_name);
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
939: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);
940: END IF;
941:

Line 1025: x_return_status := FND_API.G_RET_STS_SUCCESS;

1021: --
1022: -- Initialize return status to SUCCESS
1023: --
1024:
1025: x_return_status := FND_API.G_RET_STS_SUCCESS;
1026:
1027: l_debug_info := 'p_ship_header_id';
1028: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1029: p_procedure_name => l_procedure_name,

Line 1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1153: rec_assoc.allocation_uom_code,
1154: l_factor,
1155: l_return_status);
1156: -- If any errors happen abort API.
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158: RAISE FND_API.G_EXC_ERROR;
1159: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;

Line 1158: RAISE FND_API.G_EXC_ERROR;

1154: l_factor,
1155: l_return_status);
1156: -- If any errors happen abort API.
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158: RAISE FND_API.G_EXC_ERROR;
1159: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;
1162:

Line 1159: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1155: l_return_status);
1156: -- If any errors happen abort API.
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158: RAISE FND_API.G_EXC_ERROR;
1159: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;
1162:
1163: l_debug_info := 'l_factor';

Line 1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1156: -- If any errors happen abort API.
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158: RAISE FND_API.G_EXC_ERROR;
1159: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;
1162:
1163: l_debug_info := 'l_factor';
1164: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 1200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1196: p_lc_flag,
1197: p_adjustment_num,
1198: l_return_status);
1199: -- If any errors happen abort API.
1200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1201: RAISE FND_API.G_EXC_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: END IF;

Line 1201: RAISE FND_API.G_EXC_ERROR;

1197: p_adjustment_num,
1198: l_return_status);
1199: -- If any errors happen abort API.
1200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1201: RAISE FND_API.G_EXC_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: END IF;
1205:

Line 1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1198: l_return_status);
1199: -- If any errors happen abort API.
1200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1201: RAISE FND_API.G_EXC_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: END IF;
1205:
1206:

Line 1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1199: -- If any errors happen abort API.
1200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1201: RAISE FND_API.G_EXC_ERROR;
1202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204: END IF;
1205:
1206:
1207: END LOOP;

Line 1269: WHEN FND_API.G_EXC_ERROR THEN

1265: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1266: p_procedure_name => l_procedure_name);
1267:
1268: EXCEPTION
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1271: p_procedure_name => l_procedure_name);
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1272: x_return_status := FND_API.G_RET_STS_ERROR;

1268: EXCEPTION
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1271: p_procedure_name => l_procedure_name);
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1275: p_procedure_name => l_procedure_name);
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1269: WHEN FND_API.G_EXC_ERROR THEN
1270: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1271: p_procedure_name => l_procedure_name);
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1275: p_procedure_name => l_procedure_name);
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: WHEN OTHERS THEN

Line 1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1275: p_procedure_name => l_procedure_name);
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: WHEN OTHERS THEN
1278: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1279: p_procedure_name => l_procedure_name);
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: WHEN OTHERS THEN
1278: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1279: p_procedure_name => l_procedure_name);
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1282: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);
1283: END IF;
1284:

Line 1354: x_return_status := FND_API.G_RET_STS_SUCCESS;

1350: --
1351: -- Initialize return status to SUCCESS
1352: --
1353:
1354: x_return_status := FND_API.G_RET_STS_SUCCESS;
1355:
1356: l_debug_info := 'p_ship_header_id';
1357: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1358: p_procedure_name => l_procedure_name,

Line 1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1434: p_allocation_uom_code,
1435: l_factor,
1436: l_return_status);
1437: -- If any errors happen abort API.
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;

Line 1439: RAISE FND_API.G_EXC_ERROR;

1435: l_factor,
1436: l_return_status);
1437: -- If any errors happen abort API.
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443:

Line 1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1436: l_return_status);
1437: -- If any errors happen abort API.
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443:
1444: Insert_Allocation (p_ship_header_id,

Line 1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1437: -- If any errors happen abort API.
1438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1439: RAISE FND_API.G_EXC_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443:
1444: Insert_Allocation (p_ship_header_id,
1445: p_le_currency_code,

Line 1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1453: p_lc_flag,
1454: p_adjustment_num,
1455: l_return_status);
1456: -- If any errors happen abort API.
1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;

Line 1458: RAISE FND_API.G_EXC_ERROR;

1454: p_adjustment_num,
1455: l_return_status);
1456: -- If any errors happen abort API.
1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;
1462:

Line 1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1455: l_return_status);
1456: -- If any errors happen abort API.
1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;
1462:
1463: END LOOP;

Line 1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1456: -- If any errors happen abort API.
1457: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461: END IF;
1462:
1463: END LOOP;
1464: CLOSE dist;

Line 1470: WHEN FND_API.G_EXC_ERROR THEN

1466: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1467: p_procedure_name => l_procedure_name);
1468:
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1472: p_procedure_name => l_procedure_name);
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1473: x_return_status := FND_API.G_RET_STS_ERROR;

1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1472: p_procedure_name => l_procedure_name);
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1476: p_procedure_name => l_procedure_name);
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1470: WHEN FND_API.G_EXC_ERROR THEN
1471: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1472: p_procedure_name => l_procedure_name);
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1476: p_procedure_name => l_procedure_name);
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: WHEN OTHERS THEN

Line 1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1476: p_procedure_name => l_procedure_name);
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: WHEN OTHERS THEN
1479: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1480: p_procedure_name => l_procedure_name);
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: WHEN OTHERS THEN
1479: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1480: p_procedure_name => l_procedure_name);
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1483: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);
1484: END IF;
1485:

Line 1583: x_return_status := FND_API.G_RET_STS_SUCCESS;

1579: --
1580: -- Initialize return status to SUCCESS
1581: --
1582:
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: l_next_level_allocation := 'N';
1586:
1587: l_debug_info := 'p_ship_header_id';

Line 1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1677: p_allocation_uom_code,
1678: l_factor,
1679: l_return_status);
1680: -- If any errors happen abort API.
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;

Line 1682: RAISE FND_API.G_EXC_ERROR;

1678: l_factor,
1679: l_return_status);
1680: -- If any errors happen abort API.
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686:

Line 1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1679: l_return_status);
1680: -- If any errors happen abort API.
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686:
1687: Control_Allocation (p_ship_header_id,

Line 1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1680: -- If any errors happen abort API.
1681: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686:
1687: Control_Allocation (p_ship_header_id,
1688: p_le_currency_code,

Line 1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1701: rec_assoc.to_parent_table_id,
1702: p_adjustment_num,
1703: l_return_status);
1704: -- If any errors happen abort API.
1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1706: RAISE FND_API.G_EXC_ERROR;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1709: END IF;

Line 1706: RAISE FND_API.G_EXC_ERROR;

1702: p_adjustment_num,
1703: l_return_status);
1704: -- If any errors happen abort API.
1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1706: RAISE FND_API.G_EXC_ERROR;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1709: END IF;
1710:

Line 1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1703: l_return_status);
1704: -- If any errors happen abort API.
1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1706: RAISE FND_API.G_EXC_ERROR;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1709: END IF;
1710:
1711: END LOOP;

Line 1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1704: -- If any errors happen abort API.
1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1706: RAISE FND_API.G_EXC_ERROR;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1709: END IF;
1710:
1711: END LOOP;
1712: CLOSE assoc;

Line 1736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1732: 'N',
1733: p_adjustment_num,
1734: l_return_status);
1735: -- If any errors happen abort API.
1736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END IF;

Line 1737: RAISE FND_API.G_EXC_ERROR;

1733: p_adjustment_num,
1734: l_return_status);
1735: -- If any errors happen abort API.
1736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END IF;
1741: ELSE

Line 1738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1734: l_return_status);
1735: -- If any errors happen abort API.
1736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END IF;
1741: ELSE
1742: SELECT DECODE(l_next_level_allocation,'N','Y','N')

Line 1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1735: -- If any errors happen abort API.
1736: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1737: RAISE FND_API.G_EXC_ERROR;
1738: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END IF;
1741: ELSE
1742: SELECT DECODE(l_next_level_allocation,'N','Y','N')
1743: INTO l_lc_flag

Line 1760: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1756: l_lc_flag,
1757: p_adjustment_num,
1758: l_return_status);
1759: -- If any errors happen abort API.
1760: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1761: RAISE FND_API.G_EXC_ERROR;
1762: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1764: END IF;

Line 1761: RAISE FND_API.G_EXC_ERROR;

1757: p_adjustment_num,
1758: l_return_status);
1759: -- If any errors happen abort API.
1760: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1761: RAISE FND_API.G_EXC_ERROR;
1762: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1764: END IF;
1765:

Line 1762: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1758: l_return_status);
1759: -- If any errors happen abort API.
1760: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1761: RAISE FND_API.G_EXC_ERROR;
1762: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1764: END IF;
1765:
1766: END IF;

Line 1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1759: -- If any errors happen abort API.
1760: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1761: RAISE FND_API.G_EXC_ERROR;
1762: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1764: END IF;
1765:
1766: END IF;
1767:

Line 1772: WHEN FND_API.G_EXC_ERROR THEN

1768: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1769: p_procedure_name => l_procedure_name);
1770:
1771: EXCEPTION
1772: WHEN FND_API.G_EXC_ERROR THEN
1773: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1774: p_procedure_name => l_procedure_name);
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1775: x_return_status := FND_API.G_RET_STS_ERROR;

1771: EXCEPTION
1772: WHEN FND_API.G_EXC_ERROR THEN
1773: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1774: p_procedure_name => l_procedure_name);
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1778: p_procedure_name => l_procedure_name);
1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1772: WHEN FND_API.G_EXC_ERROR THEN
1773: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1774: p_procedure_name => l_procedure_name);
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1778: p_procedure_name => l_procedure_name);
1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: WHEN OTHERS THEN

Line 1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1778: p_procedure_name => l_procedure_name);
1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: WHEN OTHERS THEN
1781: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1782: p_procedure_name => l_procedure_name);
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: WHEN OTHERS THEN
1781: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1782: p_procedure_name => l_procedure_name);
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1785: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);
1786: END IF;
1787:

Line 1833: x_return_status := FND_API.G_RET_STS_SUCCESS;

1829: --
1830: -- Initialize return status to SUCCESS
1831: --
1832:
1833: x_return_status := FND_API.G_RET_STS_SUCCESS;
1834:
1835: l_debug_info := 'p_ship_header_id';
1836: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1837: p_procedure_name => l_procedure_name,

Line 1890: WHEN FND_API.G_EXC_ERROR THEN

1886: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1887: p_procedure_name => l_procedure_name);
1888:
1889: EXCEPTION
1890: WHEN FND_API.G_EXC_ERROR THEN
1891: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1892: p_procedure_name => l_procedure_name);
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1893: x_return_status := FND_API.G_RET_STS_ERROR;

1889: EXCEPTION
1890: WHEN FND_API.G_EXC_ERROR THEN
1891: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1892: p_procedure_name => l_procedure_name);
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1895: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1896: p_procedure_name => l_procedure_name);
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1890: WHEN FND_API.G_EXC_ERROR THEN
1891: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1892: p_procedure_name => l_procedure_name);
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1895: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1896: p_procedure_name => l_procedure_name);
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1898: WHEN OTHERS THEN

Line 1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1895: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1896: p_procedure_name => l_procedure_name);
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1898: WHEN OTHERS THEN
1899: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1900: p_procedure_name => l_procedure_name);
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1898: WHEN OTHERS THEN
1899: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1900: p_procedure_name => l_procedure_name);
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1902: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1903: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);
1904: END IF;
1905: END Update_Allocation;

Line 1913: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

1909: -- Function : Calculate Landed Costs for a given LCM Shipment.
1910: -- Pre-reqs : None
1911: -- Parameters :
1912: -- IN : p_api_version IN NUMBER Required
1913: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
1914: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1915: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1916: -- p_ship_header_id IN NUMBER Required
1917: -- p_calc_scope_code IN NUMBER Required Default = 0

Line 1914: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1910: -- Pre-reqs : None
1911: -- Parameters :
1912: -- IN : p_api_version IN NUMBER Required
1913: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
1914: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1915: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1916: -- p_ship_header_id IN NUMBER Required
1917: -- p_calc_scope_code IN NUMBER Required Default = 0
1918: -- 0-Run for all components

Line 1915: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

1911: -- Parameters :
1912: -- IN : p_api_version IN NUMBER Required
1913: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
1914: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1915: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
1916: -- p_ship_header_id IN NUMBER Required
1917: -- p_calc_scope_code IN NUMBER Required Default = 0
1918: -- 0-Run for all components
1919: -- 1-Run only for Item Price components

Line 1931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1927: -- Version : Current version 1.0
1928: --
1929: -- Notes :
1930: PROCEDURE Run_Calculation (p_api_version IN NUMBER,
1931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1932: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1933: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1934: p_ship_header_id IN NUMBER,
1935: p_calc_scope_code IN NUMBER,

Line 1932: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1928: --
1929: -- Notes :
1930: PROCEDURE Run_Calculation (p_api_version IN NUMBER,
1931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1932: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1933: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1934: p_ship_header_id IN NUMBER,
1935: p_calc_scope_code IN NUMBER,
1936: x_return_status OUT NOCOPY VARCHAR2,

Line 1933: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1929: -- Notes :
1930: PROCEDURE Run_Calculation (p_api_version IN NUMBER,
1931: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1932: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1933: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1934: p_ship_header_id IN NUMBER,
1935: p_calc_scope_code IN NUMBER,
1936: x_return_status OUT NOCOPY VARCHAR2,
1937: x_msg_count OUT NOCOPY NUMBER,

Line 2063: IF FND_API.to_Boolean (p_init_msg_list) THEN

2059:
2060: --
2061: -- Initialize message list if p_init_msg_list is set to TRUE
2062: --
2063: IF FND_API.to_Boolean (p_init_msg_list) THEN
2064: FND_MSG_PUB.initialize;
2065: END IF;
2066:
2067: --

Line 2070: IF NOT FND_API.Compatible_API_Call (l_api_version,

2066:
2067: --
2068: -- Standard call to check for call compatibility
2069: --
2070: IF NOT FND_API.Compatible_API_Call (l_api_version,
2071: p_api_version,
2072: l_api_name,
2073: G_PKG_NAME)
2074: THEN

Line 2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2071: p_api_version,
2072: l_api_name,
2073: G_PKG_NAME)
2074: THEN
2075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2076: END IF;
2077:
2078: --
2079: -- Initialize return status to SUCCESS

Line 2081: x_return_status := FND_API.G_RET_STS_SUCCESS;

2077:
2078: --
2079: -- Initialize return status to SUCCESS
2080: --
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:
2083: --
2084: -- Obtain Adjustment Number
2085: -- This is for obtaining the latest adjustment done to the LCM shipment

Line 2116: RAISE FND_API.G_EXC_ERROR;

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:
2119: -- If any errors happen abort API.
2120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2116: RAISE FND_API.G_EXC_ERROR;
2117: END IF;
2118:
2119: -- If any errors happen abort API.
2120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2121: RAISE FND_API.G_EXC_ERROR;
2122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2124: END IF;

Line 2121: RAISE FND_API.G_EXC_ERROR;

2117: END IF;
2118:
2119: -- If any errors happen abort API.
2120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2121: RAISE FND_API.G_EXC_ERROR;
2122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2124: END IF;
2125:

Line 2122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2118:
2119: -- If any errors happen abort API.
2120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2121: RAISE FND_API.G_EXC_ERROR;
2122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2124: END IF;
2125:
2126: END LOOP;

Line 2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2119: -- If any errors happen abort API.
2120: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2121: RAISE FND_API.G_EXC_ERROR;
2122: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2124: END IF;
2125:
2126: END LOOP;
2127: CLOSE assoc;

Line 2289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2285: rec_assoc.allocation_uom_code,
2286: l_factor,
2287: l_return_status);
2288: -- If any errors happen abort API.
2289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2290: RAISE FND_API.G_EXC_ERROR;
2291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2293: END IF;

Line 2290: RAISE FND_API.G_EXC_ERROR;

2286: l_factor,
2287: l_return_status);
2288: -- If any errors happen abort API.
2289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2290: RAISE FND_API.G_EXC_ERROR;
2291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2293: END IF;
2294:

Line 2291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2287: l_return_status);
2288: -- If any errors happen abort API.
2289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2290: RAISE FND_API.G_EXC_ERROR;
2291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2293: END IF;
2294:
2295: l_amount := l_amount * l_factor;

Line 2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2288: -- If any errors happen abort API.
2289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2290: RAISE FND_API.G_EXC_ERROR;
2291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2293: END IF;
2294:
2295: l_amount := l_amount * l_factor;
2296:

Line 2315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2311: rec_assoc.to_parent_table_id,
2312: l_adjustment_num,
2313: l_return_status);
2314: -- If any errors happen abort API.
2315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: RAISE FND_API.G_EXC_ERROR;
2317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: END IF;

Line 2316: RAISE FND_API.G_EXC_ERROR;

2312: l_adjustment_num,
2313: l_return_status);
2314: -- If any errors happen abort API.
2315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: RAISE FND_API.G_EXC_ERROR;
2317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: END IF;
2320: END LOOP;

Line 2317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2313: l_return_status);
2314: -- If any errors happen abort API.
2315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: RAISE FND_API.G_EXC_ERROR;
2317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: END IF;
2320: END LOOP;
2321: CLOSE assoc;

Line 2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2314: -- If any errors happen abort API.
2315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2316: RAISE FND_API.G_EXC_ERROR;
2317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2319: END IF;
2320: END LOOP;
2321: CLOSE assoc;
2322:

Line 2401: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2397: l_lc_flag,
2398: l_adjustment_num,
2399: l_return_status);
2400: -- If any errors happen abort API.
2401: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2402: RAISE FND_API.G_EXC_ERROR;
2403: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: END IF;

Line 2402: RAISE FND_API.G_EXC_ERROR;

2398: l_adjustment_num,
2399: l_return_status);
2400: -- If any errors happen abort API.
2401: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2402: RAISE FND_API.G_EXC_ERROR;
2403: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: END IF;
2406:

Line 2403: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2399: l_return_status);
2400: -- If any errors happen abort API.
2401: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2402: RAISE FND_API.G_EXC_ERROR;
2403: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: END IF;
2406:
2407: END LOOP;

Line 2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2400: -- If any errors happen abort API.
2401: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2402: RAISE FND_API.G_EXC_ERROR;
2403: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: END IF;
2406:
2407: END LOOP;
2408: CLOSE dist;

Line 2432: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2428: 'N',
2429: l_adjustment_num,
2430: l_return_status);
2431: -- If any errors happen abort API.
2432: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2433: RAISE FND_API.G_EXC_ERROR;
2434: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: END IF;

Line 2433: RAISE FND_API.G_EXC_ERROR;

2429: l_adjustment_num,
2430: l_return_status);
2431: -- If any errors happen abort API.
2432: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2433: RAISE FND_API.G_EXC_ERROR;
2434: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: END IF;
2437:

Line 2434: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2430: l_return_status);
2431: -- If any errors happen abort API.
2432: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2433: RAISE FND_API.G_EXC_ERROR;
2434: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: END IF;
2437:
2438: END LOOP;

Line 2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2431: -- If any errors happen abort API.
2432: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2433: RAISE FND_API.G_EXC_ERROR;
2434: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: END IF;
2437:
2438: END LOOP;
2439: CLOSE charge;

Line 2459: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2455: 'N',
2456: l_adjustment_num,
2457: l_return_status);
2458: -- If any errors happen abort API.
2459: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2460: RAISE FND_API.G_EXC_ERROR;
2461: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END IF;

Line 2460: RAISE FND_API.G_EXC_ERROR;

2456: l_adjustment_num,
2457: l_return_status);
2458: -- If any errors happen abort API.
2459: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2460: RAISE FND_API.G_EXC_ERROR;
2461: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END IF;
2464:

Line 2461: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2457: l_return_status);
2458: -- If any errors happen abort API.
2459: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2460: RAISE FND_API.G_EXC_ERROR;
2461: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END IF;
2464:
2465: END LOOP;

Line 2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2458: -- If any errors happen abort API.
2459: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2460: RAISE FND_API.G_EXC_ERROR;
2461: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2463: END IF;
2464:
2465: END LOOP;
2466: CLOSE tax;

Line 2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2470: Update_Allocation (p_ship_header_id,
2471: l_adjustment_num,
2472: x_return_status);
2473: -- If any errors happen abort API.
2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;

Line 2475: RAISE FND_API.G_EXC_ERROR;

2471: l_adjustment_num,
2472: x_return_status);
2473: -- If any errors happen abort API.
2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479:

Line 2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2472: x_return_status);
2473: -- If any errors happen abort API.
2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479:
2480: --

Line 2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2473: -- If any errors happen abort API.
2474: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479:
2480: --
2481: -- Standard check for commit

Line 2483: IF FND_API.To_Boolean (p_commit) THEN

2479:
2480: --
2481: -- Standard check for commit
2482: --
2483: IF FND_API.To_Boolean (p_commit) THEN
2484: COMMIT WORK;
2485: END IF;
2486:
2487: -- Standard call to get message count and if count is 1, get message info.

Line 2488: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,

2484: COMMIT WORK;
2485: END IF;
2486:
2487: -- Standard call to get message count and if count is 1, get message info.
2488: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
2489: p_count => x_msg_count,
2490: p_data => x_msg_data);
2491:
2492: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

Line 2496: WHEN FND_API.G_EXC_ERROR THEN

2492: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
2493: p_procedure_name => l_api_name);
2494:
2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN
2497: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2498: p_procedure_name => l_api_name);
2499: ROLLBACK TO Run_Calculation_PVT;
2500: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2500: x_return_status := FND_API.G_RET_STS_ERROR;

2496: WHEN FND_API.G_EXC_ERROR THEN
2497: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2498: p_procedure_name => l_api_name);
2499: ROLLBACK TO Run_Calculation_PVT;
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2502: p_count => x_msg_count,
2503: p_data => x_msg_data);
2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2497: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2498: p_procedure_name => l_api_name);
2499: ROLLBACK TO Run_Calculation_PVT;
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2502: p_count => x_msg_count,
2503: p_data => x_msg_data);
2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2505: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2502: p_count => x_msg_count,
2503: p_data => x_msg_data);
2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2505: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2506: p_procedure_name => l_api_name);
2507: ROLLBACK TO Run_Calculation_PVT;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2505: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2506: p_procedure_name => l_api_name);
2507: ROLLBACK TO Run_Calculation_PVT;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2510: p_count => x_msg_count,
2511: p_data => x_msg_data);
2512: WHEN OTHERS THEN

Line 2509: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2505: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2506: p_procedure_name => l_api_name);
2507: ROLLBACK TO Run_Calculation_PVT;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2510: p_count => x_msg_count,
2511: p_data => x_msg_data);
2512: WHEN OTHERS THEN
2513: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2512: WHEN OTHERS THEN
2513: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2514: p_procedure_name => l_api_name);
2515: ROLLBACK TO Run_Calculation_PVT;
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2518: THEN
2519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2520: END IF;

Line 2521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2518: THEN
2519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2520: END IF;
2521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2522: p_count => x_msg_count,
2523: p_data => x_msg_data);
2524:
2525: END Run_Calculation;