DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on FND_API

Line 2128: p_init_msg_list => FND_API.G_TRUE,

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,

Line 2129: p_return_values => FND_API.G_FALSE,

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,

Line 2130: --p_commit => FND_API.G_FALSE,

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,

Line 2131: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 2167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 2169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 2171: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 2173: RAISE FND_API.G_EXC_ERROR;

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;

Line 2191: WHEN FND_API.G_EXC_ERROR THEN

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(

Line 2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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(

Line 4067: p_init_msg_list => FND_API.G_TRUE,

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,

Line 4068: p_return_values => FND_API.G_FALSE,

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,

Line 4069: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 4109: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{

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 --{

Line 4111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{

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 --{

Line 4115: RAISE FND_API.G_EXC_ERROR;

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;

Line 4156: p_init_msg_list => FND_API.G_TRUE,

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,

Line 4157: p_return_values => FND_API.G_FALSE,

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,

Line 4158: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 4197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{

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 --{

Line 4199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 4201: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{

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 --{

Line 4203: RAISE FND_API.G_EXC_ERROR;

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;

Line 4238: WHEN FND_API.G_EXC_ERROR THEN --{

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

Line 4301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4297: --
4298: ROLLBACK;
4299: --}
4300:
4301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4302: --{
4303: x_return_status := FALSE;
4304: --
4305: --

Line 6133: p_init_msg_list => FND_API.G_TRUE,

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,

Line 6134: p_return_values => FND_API.G_FALSE,

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,

Line 6135: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 6174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{

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 --{

Line 6176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 6178: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{

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 --{

Line 6180: RAISE FND_API.G_EXC_ERROR;

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;

Line 6211: p_init_msg_list => FND_API.G_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,

Line 6212: p_return_values => FND_API.G_FALSE,

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,

Line 6213: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 6250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{

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 --{

Line 6252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 6254: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{

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 --{

Line 6256: RAISE FND_API.G_EXC_ERROR;

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;

Line 6299: WHEN FND_API.G_EXC_ERROR THEN

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

Line 6349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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