2124: --Pass only g_oe_line_tbl. The rest uses default values
2125: --
2126: OE_Order_GRP.Process_order(
2127: p_api_version_number => x_oe_api_version,
2128: p_init_msg_list => FND_API.G_TRUE,
2129: p_return_values => FND_API.G_FALSE,
2130: --p_commit => FND_API.G_FALSE,
2131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2132: x_return_status => l_return_status,
2125: --
2126: OE_Order_GRP.Process_order(
2127: p_api_version_number => x_oe_api_version,
2128: p_init_msg_list => FND_API.G_TRUE,
2129: p_return_values => FND_API.G_FALSE,
2130: --p_commit => FND_API.G_FALSE,
2131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2132: x_return_status => l_return_status,
2133: x_msg_count => x_msg_count,
2126: OE_Order_GRP.Process_order(
2127: p_api_version_number => x_oe_api_version,
2128: p_init_msg_list => FND_API.G_TRUE,
2129: p_return_values => FND_API.G_FALSE,
2130: --p_commit => FND_API.G_FALSE,
2131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2132: x_return_status => l_return_status,
2133: x_msg_count => x_msg_count,
2134: x_msg_data => x_msg_data,
2127: p_api_version_number => x_oe_api_version,
2128: p_init_msg_list => FND_API.G_TRUE,
2129: p_return_values => FND_API.G_FALSE,
2130: --p_commit => FND_API.G_FALSE,
2131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2132: x_return_status => l_return_status,
2133: x_msg_count => x_msg_count,
2134: x_msg_data => x_msg_data,
2135: ------------------------------------------
2163: rlm_core_sv.dlog(C_SDEBUG, 'Input tbl count', g_oe_line_tbl.LAST);
2164: rlm_core_sv.dlog(C_SDEBUG, 'Output tbl count', l_oe_line_tbl_out.LAST);
2165: END IF;
2166: --
2167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2168: --
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: --
2171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2165: END IF;
2166: --
2167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2168: --
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: --
2171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2172: --
2173: RAISE FND_API.G_EXC_ERROR;
2167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2168: --
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: --
2171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2172: --
2173: RAISE FND_API.G_EXC_ERROR;
2174: --
2175: ELSE
2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2170: --
2171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2172: --
2173: RAISE FND_API.G_EXC_ERROR;
2174: --
2175: ELSE
2176: --
2177: x_return_status := TRUE;
2187: END IF;
2188: --
2189: EXCEPTION
2190: --
2191: WHEN FND_API.G_EXC_ERROR THEN
2192: --
2193: --Get message count and data
2194: --
2195: OE_MSG_PUB.Count_And_Get(
2244: END IF;
2245: --
2246: RAISE e_general_error;
2247: --
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: --
2250: -- Get message count and data
2251: --
2252: OE_MSG_PUB.Count_And_Get(
4063: IF v_index3 = g_oe_tmp_line_tbl.LAST THEN --{
4064: -- process order for the last time
4065: OE_Order_GRP.Process_order(
4066: p_api_version_number => x_oe_api_version,
4067: p_init_msg_list => FND_API.G_TRUE,
4068: p_return_values => FND_API.G_FALSE,
4069: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4070: x_return_status => l_return_status,
4071: x_msg_count => v_msg_count,
4064: -- process order for the last time
4065: OE_Order_GRP.Process_order(
4066: p_api_version_number => x_oe_api_version,
4067: p_init_msg_list => FND_API.G_TRUE,
4068: p_return_values => FND_API.G_FALSE,
4069: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4070: x_return_status => l_return_status,
4071: x_msg_count => v_msg_count,
4072: x_msg_data => v_msg_data,
4065: OE_Order_GRP.Process_order(
4066: p_api_version_number => x_oe_api_version,
4067: p_init_msg_list => FND_API.G_TRUE,
4068: p_return_values => FND_API.G_FALSE,
4069: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4070: x_return_status => l_return_status,
4071: x_msg_count => v_msg_count,
4072: x_msg_data => v_msg_data,
4073: ------------------------------------------
4105: --
4106: -- Handle the exceptions caused by the OE call
4107: --
4108:
4109: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4110: --
4111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4112: --}
4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4107: --
4108:
4109: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4110: --
4111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4112: --}
4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4114: --
4115: RAISE FND_API.G_EXC_ERROR;
4109: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4110: --
4111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4112: --}
4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4114: --
4115: RAISE FND_API.G_EXC_ERROR;
4116: --}
4117: ELSE --{
4111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4112: --}
4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4114: --
4115: RAISE FND_API.G_EXC_ERROR;
4116: --}
4117: ELSE --{
4118: --
4119: counter2 := counter2 + 1;
4152: --
4153:
4154: OE_Order_GRP.Process_order(
4155: p_api_version_number => x_oe_api_version,
4156: p_init_msg_list => FND_API.G_TRUE,
4157: p_return_values => FND_API.G_FALSE,
4158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4159: x_return_status => l_return_status,
4160: x_msg_count => v_msg_count,
4153:
4154: OE_Order_GRP.Process_order(
4155: p_api_version_number => x_oe_api_version,
4156: p_init_msg_list => FND_API.G_TRUE,
4157: p_return_values => FND_API.G_FALSE,
4158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4159: x_return_status => l_return_status,
4160: x_msg_count => v_msg_count,
4161: x_msg_data => v_msg_data,
4154: OE_Order_GRP.Process_order(
4155: p_api_version_number => x_oe_api_version,
4156: p_init_msg_list => FND_API.G_TRUE,
4157: p_return_values => FND_API.G_FALSE,
4158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4159: x_return_status => l_return_status,
4160: x_msg_count => v_msg_count,
4161: x_msg_data => v_msg_data,
4162: ------------------------------------------
4193: rlm_core_sv.dlog(C_DEBUG, 'Output tbl count',
4194: l_oe_line_tbl_out.LAST);
4195: END IF;
4196: --
4197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4198: --
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4200: --}
4201: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4195: END IF;
4196: --
4197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4198: --
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4200: --}
4201: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4202: --
4203: RAISE FND_API.G_EXC_ERROR;
4197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4198: --
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4200: --}
4201: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4202: --
4203: RAISE FND_API.G_EXC_ERROR;
4204: --}
4205: ELSE --{
4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4200: --}
4201: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4202: --
4203: RAISE FND_API.G_EXC_ERROR;
4204: --}
4205: ELSE --{
4206: --
4207: counter2 := counter2 + 1;
4234: END LOOP; --}
4235: --
4236: EXCEPTION
4237: --
4238: WHEN FND_API.G_EXC_ERROR THEN --{
4239: --
4240: x_return_status := FALSE;
4241: --
4242: -- Get message count and data
4297: --
4298: ROLLBACK;
4299: --}
4300:
4301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4302: --{
4303: x_return_status := FALSE;
4304: --
4305: --
6129: IF v_tmp_line_idx = g_oe_tmp_line_tbl.LAST THEN --{
6130: -- process order for the last time
6131: OE_Order_GRP.Process_order(
6132: p_api_version_number => x_oe_api_version,
6133: p_init_msg_list => FND_API.G_TRUE,
6134: p_return_values => FND_API.G_FALSE,
6135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6136: x_return_status => l_return_status,
6137: x_msg_count => v_msg_count,
6130: -- process order for the last time
6131: OE_Order_GRP.Process_order(
6132: p_api_version_number => x_oe_api_version,
6133: p_init_msg_list => FND_API.G_TRUE,
6134: p_return_values => FND_API.G_FALSE,
6135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6136: x_return_status => l_return_status,
6137: x_msg_count => v_msg_count,
6138: x_msg_data => v_msg_data,
6131: OE_Order_GRP.Process_order(
6132: p_api_version_number => x_oe_api_version,
6133: p_init_msg_list => FND_API.G_TRUE,
6134: p_return_values => FND_API.G_FALSE,
6135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6136: x_return_status => l_return_status,
6137: x_msg_count => v_msg_count,
6138: x_msg_data => v_msg_data,
6139: ------------------------------------------
6170: --
6171: -- Handle the exceptions caused by the OE call
6172: --
6173:
6174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6175: --
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: --}
6178: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6172: --
6173:
6174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6175: --
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: --}
6178: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6179: --
6180: RAISE FND_API.G_EXC_ERROR;
6174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6175: --
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: --}
6178: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6179: --
6180: RAISE FND_API.G_EXC_ERROR;
6181: --}
6182: ELSE --{
6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6177: --}
6178: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6179: --
6180: RAISE FND_API.G_EXC_ERROR;
6181: --}
6182: ELSE --{
6183: --
6184: x_return_status := TRUE;
6207: --
6208:
6209: OE_Order_GRP.Process_order(
6210: p_api_version_number => x_oe_api_version,
6211: p_init_msg_list => FND_API.G_TRUE,
6212: p_return_values => FND_API.G_FALSE,
6213: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6214: x_return_status => l_return_status,
6215: x_msg_count => v_msg_count,
6208:
6209: OE_Order_GRP.Process_order(
6210: p_api_version_number => x_oe_api_version,
6211: p_init_msg_list => FND_API.G_TRUE,
6212: p_return_values => FND_API.G_FALSE,
6213: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6214: x_return_status => l_return_status,
6215: x_msg_count => v_msg_count,
6216: x_msg_data => v_msg_data,
6209: OE_Order_GRP.Process_order(
6210: p_api_version_number => x_oe_api_version,
6211: p_init_msg_list => FND_API.G_TRUE,
6212: p_return_values => FND_API.G_FALSE,
6213: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6214: x_return_status => l_return_status,
6215: x_msg_count => v_msg_count,
6216: x_msg_data => v_msg_data,
6217: ------------------------------------------
6246: rlm_core_sv.dlog(C_DEBUG, 'Input tbl count', g_oe_line_tbl.LAST); rlm_core_sv.dlog(C_DEBUG, 'Output tbl count',
6247: l_oe_line_tbl_out.LAST);
6248: END IF;
6249: --
6250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6251: --
6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6253: --}
6254: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6248: END IF;
6249: --
6250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6251: --
6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6253: --}
6254: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6255: --
6256: RAISE FND_API.G_EXC_ERROR;
6250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6251: --
6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6253: --}
6254: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6255: --
6256: RAISE FND_API.G_EXC_ERROR;
6257: --}
6258: ELSE --{
6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6253: --}
6254: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6255: --
6256: RAISE FND_API.G_EXC_ERROR;
6257: --}
6258: ELSE --{
6259: --
6260: x_return_status := TRUE;
6295: IF (l_debug <> -1) THEN
6296: rlm_core_sv.dpop(C_DEBUG, 'UpdateOldKey e_SetSupplierCum');
6297: END IF;
6298: --
6299: WHEN FND_API.G_EXC_ERROR THEN
6300: --
6301: x_return_status := FALSE;
6302: --
6303: --Get message count and data
6345: IF (l_debug <> -1) THEN
6346: rlm_core_sv.dpop(C_DEBUG, 'UpdateOldKey G_EXC_ERROR');
6347: END IF;
6348: --
6349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6350: x_return_status := FALSE;
6351: --
6352: --Get message count and data
6353: --