DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on FND_API

Line 2138: p_init_msg_list => FND_API.G_TRUE,

2134: --Pass only g_oe_line_tbl. The rest uses default values
2135: --
2136: OE_Order_GRP.Process_order(
2137: p_api_version_number => x_oe_api_version,
2138: p_init_msg_list => FND_API.G_TRUE,
2139: p_return_values => FND_API.G_FALSE,
2140: --p_commit => FND_API.G_FALSE,
2141: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2142: x_return_status => l_return_status,

Line 2139: p_return_values => FND_API.G_FALSE,

2135: --
2136: OE_Order_GRP.Process_order(
2137: p_api_version_number => x_oe_api_version,
2138: p_init_msg_list => FND_API.G_TRUE,
2139: p_return_values => FND_API.G_FALSE,
2140: --p_commit => FND_API.G_FALSE,
2141: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2142: x_return_status => l_return_status,
2143: x_msg_count => x_msg_count,

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

2136: OE_Order_GRP.Process_order(
2137: p_api_version_number => x_oe_api_version,
2138: p_init_msg_list => FND_API.G_TRUE,
2139: p_return_values => FND_API.G_FALSE,
2140: --p_commit => FND_API.G_FALSE,
2141: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2142: x_return_status => l_return_status,
2143: x_msg_count => x_msg_count,
2144: x_msg_data => x_msg_data,

Line 2141: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2137: p_api_version_number => x_oe_api_version,
2138: p_init_msg_list => FND_API.G_TRUE,
2139: p_return_values => FND_API.G_FALSE,
2140: --p_commit => FND_API.G_FALSE,
2141: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2142: x_return_status => l_return_status,
2143: x_msg_count => x_msg_count,
2144: x_msg_data => x_msg_data,
2145: ------------------------------------------

Line 2177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2173: rlm_core_sv.dlog(C_SDEBUG, 'Input tbl count', g_oe_line_tbl.LAST);
2174: rlm_core_sv.dlog(C_SDEBUG, 'Output tbl count', l_oe_line_tbl_out.LAST);
2175: END IF;
2176: --
2177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2178: --
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: --
2181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2175: END IF;
2176: --
2177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2178: --
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: --
2181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2182: --
2183: RAISE FND_API.G_EXC_ERROR;

Line 2181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2178: --
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: --
2181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2182: --
2183: RAISE FND_API.G_EXC_ERROR;
2184: --
2185: ELSE

Line 2183: RAISE FND_API.G_EXC_ERROR;

2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180: --
2181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2182: --
2183: RAISE FND_API.G_EXC_ERROR;
2184: --
2185: ELSE
2186: --
2187: x_return_status := TRUE;

Line 2201: WHEN FND_API.G_EXC_ERROR THEN

2197: END IF;
2198: --
2199: EXCEPTION
2200: --
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: --
2203: --Get message count and data
2204: --
2205: OE_MSG_PUB.Count_And_Get(

Line 2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2254: END IF;
2255: --
2256: RAISE e_general_error;
2257: --
2258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2259: --
2260: -- Get message count and data
2261: --
2262: OE_MSG_PUB.Count_And_Get(

Line 4077: p_init_msg_list => FND_API.G_TRUE,

4073: IF v_index3 = g_oe_tmp_line_tbl.LAST THEN --{
4074: -- process order for the last time
4075: OE_Order_GRP.Process_order(
4076: p_api_version_number => x_oe_api_version,
4077: p_init_msg_list => FND_API.G_TRUE,
4078: p_return_values => FND_API.G_FALSE,
4079: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4080: x_return_status => l_return_status,
4081: x_msg_count => v_msg_count,

Line 4078: p_return_values => FND_API.G_FALSE,

4074: -- process order for the last time
4075: OE_Order_GRP.Process_order(
4076: p_api_version_number => x_oe_api_version,
4077: p_init_msg_list => FND_API.G_TRUE,
4078: p_return_values => FND_API.G_FALSE,
4079: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4080: x_return_status => l_return_status,
4081: x_msg_count => v_msg_count,
4082: x_msg_data => v_msg_data,

Line 4079: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4075: OE_Order_GRP.Process_order(
4076: p_api_version_number => x_oe_api_version,
4077: p_init_msg_list => FND_API.G_TRUE,
4078: p_return_values => FND_API.G_FALSE,
4079: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4080: x_return_status => l_return_status,
4081: x_msg_count => v_msg_count,
4082: x_msg_data => v_msg_data,
4083: ------------------------------------------

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

4115: --
4116: -- Handle the exceptions caused by the OE call
4117: --
4118:
4119: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4120: --
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: --}
4123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{

Line 4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4117: --
4118:
4119: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4120: --
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: --}
4123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4124: --
4125: RAISE FND_API.G_EXC_ERROR;

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

4119: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4120: --
4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: --}
4123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4124: --
4125: RAISE FND_API.G_EXC_ERROR;
4126: --}
4127: ELSE --{

Line 4125: RAISE FND_API.G_EXC_ERROR;

4121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4122: --}
4123: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4124: --
4125: RAISE FND_API.G_EXC_ERROR;
4126: --}
4127: ELSE --{
4128: --
4129: counter2 := counter2 + 1;

Line 4166: p_init_msg_list => FND_API.G_TRUE,

4162: --
4163:
4164: OE_Order_GRP.Process_order(
4165: p_api_version_number => x_oe_api_version,
4166: p_init_msg_list => FND_API.G_TRUE,
4167: p_return_values => FND_API.G_FALSE,
4168: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4169: x_return_status => l_return_status,
4170: x_msg_count => v_msg_count,

Line 4167: p_return_values => FND_API.G_FALSE,

4163:
4164: OE_Order_GRP.Process_order(
4165: p_api_version_number => x_oe_api_version,
4166: p_init_msg_list => FND_API.G_TRUE,
4167: p_return_values => FND_API.G_FALSE,
4168: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4169: x_return_status => l_return_status,
4170: x_msg_count => v_msg_count,
4171: x_msg_data => v_msg_data,

Line 4168: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4164: OE_Order_GRP.Process_order(
4165: p_api_version_number => x_oe_api_version,
4166: p_init_msg_list => FND_API.G_TRUE,
4167: p_return_values => FND_API.G_FALSE,
4168: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4169: x_return_status => l_return_status,
4170: x_msg_count => v_msg_count,
4171: x_msg_data => v_msg_data,
4172: ------------------------------------------

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

4203: rlm_core_sv.dlog(C_DEBUG, 'Output tbl count',
4204: l_oe_line_tbl_out.LAST);
4205: END IF;
4206: --
4207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4208: --
4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: --}
4211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{

Line 4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4205: END IF;
4206: --
4207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4208: --
4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: --}
4211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4212: --
4213: RAISE FND_API.G_EXC_ERROR;

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

4207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
4208: --
4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: --}
4211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4212: --
4213: RAISE FND_API.G_EXC_ERROR;
4214: --}
4215: ELSE --{

Line 4213: RAISE FND_API.G_EXC_ERROR;

4209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4210: --}
4211: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
4212: --
4213: RAISE FND_API.G_EXC_ERROR;
4214: --}
4215: ELSE --{
4216: --
4217: counter2 := counter2 + 1;

Line 4248: WHEN FND_API.G_EXC_ERROR THEN --{

4244: END LOOP; --}
4245: --
4246: EXCEPTION
4247: --
4248: WHEN FND_API.G_EXC_ERROR THEN --{
4249: --
4250: x_return_status := FALSE;
4251: --
4252: -- Get message count and data

Line 4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4307: --
4308: ROLLBACK;
4309: --}
4310:
4311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4312: --{
4313: x_return_status := FALSE;
4314: --
4315: --

Line 6143: p_init_msg_list => FND_API.G_TRUE,

6139: IF v_tmp_line_idx = g_oe_tmp_line_tbl.LAST THEN --{
6140: -- process order for the last time
6141: OE_Order_GRP.Process_order(
6142: p_api_version_number => x_oe_api_version,
6143: p_init_msg_list => FND_API.G_TRUE,
6144: p_return_values => FND_API.G_FALSE,
6145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6146: x_return_status => l_return_status,
6147: x_msg_count => v_msg_count,

Line 6144: p_return_values => FND_API.G_FALSE,

6140: -- process order for the last time
6141: OE_Order_GRP.Process_order(
6142: p_api_version_number => x_oe_api_version,
6143: p_init_msg_list => FND_API.G_TRUE,
6144: p_return_values => FND_API.G_FALSE,
6145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6146: x_return_status => l_return_status,
6147: x_msg_count => v_msg_count,
6148: x_msg_data => v_msg_data,

Line 6145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

6141: OE_Order_GRP.Process_order(
6142: p_api_version_number => x_oe_api_version,
6143: p_init_msg_list => FND_API.G_TRUE,
6144: p_return_values => FND_API.G_FALSE,
6145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6146: x_return_status => l_return_status,
6147: x_msg_count => v_msg_count,
6148: x_msg_data => v_msg_data,
6149: ------------------------------------------

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

6180: --
6181: -- Handle the exceptions caused by the OE call
6182: --
6183:
6184: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6185: --
6186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6187: --}
6188: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{

Line 6186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6182: --
6183:
6184: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6185: --
6186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6187: --}
6188: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6189: --
6190: RAISE FND_API.G_EXC_ERROR;

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

6184: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6185: --
6186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6187: --}
6188: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6189: --
6190: RAISE FND_API.G_EXC_ERROR;
6191: --}
6192: ELSE --{

Line 6190: RAISE FND_API.G_EXC_ERROR;

6186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6187: --}
6188: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6189: --
6190: RAISE FND_API.G_EXC_ERROR;
6191: --}
6192: ELSE --{
6193: --
6194: x_return_status := TRUE;

Line 6221: p_init_msg_list => FND_API.G_TRUE,

6217: --
6218:
6219: OE_Order_GRP.Process_order(
6220: p_api_version_number => x_oe_api_version,
6221: p_init_msg_list => FND_API.G_TRUE,
6222: p_return_values => FND_API.G_FALSE,
6223: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6224: x_return_status => l_return_status,
6225: x_msg_count => v_msg_count,

Line 6222: p_return_values => FND_API.G_FALSE,

6218:
6219: OE_Order_GRP.Process_order(
6220: p_api_version_number => x_oe_api_version,
6221: p_init_msg_list => FND_API.G_TRUE,
6222: p_return_values => FND_API.G_FALSE,
6223: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6224: x_return_status => l_return_status,
6225: x_msg_count => v_msg_count,
6226: x_msg_data => v_msg_data,

Line 6223: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

6219: OE_Order_GRP.Process_order(
6220: p_api_version_number => x_oe_api_version,
6221: p_init_msg_list => FND_API.G_TRUE,
6222: p_return_values => FND_API.G_FALSE,
6223: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
6224: x_return_status => l_return_status,
6225: x_msg_count => v_msg_count,
6226: x_msg_data => v_msg_data,
6227: ------------------------------------------

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

6256: rlm_core_sv.dlog(C_DEBUG, 'Input tbl count', g_oe_line_tbl.LAST); rlm_core_sv.dlog(C_DEBUG, 'Output tbl count',
6257: l_oe_line_tbl_out.LAST);
6258: END IF;
6259: --
6260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6261: --
6262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6263: --}
6264: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{

Line 6262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6258: END IF;
6259: --
6260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6261: --
6262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6263: --}
6264: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6265: --
6266: RAISE FND_API.G_EXC_ERROR;

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

6260: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN --{
6261: --
6262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6263: --}
6264: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6265: --
6266: RAISE FND_API.G_EXC_ERROR;
6267: --}
6268: ELSE --{

Line 6266: RAISE FND_API.G_EXC_ERROR;

6262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6263: --}
6264: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN --{
6265: --
6266: RAISE FND_API.G_EXC_ERROR;
6267: --}
6268: ELSE --{
6269: --
6270: x_return_status := TRUE;

Line 6309: WHEN FND_API.G_EXC_ERROR THEN

6305: IF (l_debug <> -1) THEN
6306: rlm_core_sv.dpop(C_DEBUG, 'UpdateOldKey e_SetSupplierCum');
6307: END IF;
6308: --
6309: WHEN FND_API.G_EXC_ERROR THEN
6310: --
6311: x_return_status := FALSE;
6312: --
6313: --Get message count and data

Line 6359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6355: IF (l_debug <> -1) THEN
6356: rlm_core_sv.dpop(C_DEBUG, 'UpdateOldKey G_EXC_ERROR');
6357: END IF;
6358: --
6359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6360: x_return_status := FALSE;
6361: --
6362: --Get message count and data
6363: --