DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on FND_API

Line 1045: x_return VARCHAR2(1) := FND_API.G_FALSE;

1041: WHERE a.prc_context_id = b.prc_context_id
1042: AND b.segment_code = a_attribute_code
1043: AND a.prc_context_type = 'QUALIFIER';
1044:
1045: x_return VARCHAR2(1) := FND_API.G_FALSE;
1046: l_context_id NUMBER;
1047:
1048: BEGIN
1049:

Line 1057: x_return := FND_API.G_TRUE;

1053:
1054: FETCH context_cur INTO l_context_id;
1055:
1056: IF context_cur%FOUND THEN
1057: x_return := FND_API.G_TRUE;
1058: END IF;
1059:
1060: CLOSE context_cur;
1061:

Line 1082: x_return := FND_API.G_TRUE;

1078: '1004', --customer PO
1079: '1053', -- new customer PO
1080: 'DISCOUNT_ID') THEN
1081:
1082: x_return := FND_API.G_TRUE;
1083:
1084: END IF;
1085:
1086: END IF; --If Attrmgr_Installed = 'Y'

Line 1108: x_return VARCHAR2(1) := FND_API.G_FALSE;

1104: WHERE a.prc_context_id = b.prc_context_id
1105: AND b.segment_code = a_attribute_code
1106: AND a.prc_context_type = 'PRICING';
1107:
1108: x_return VARCHAR2(1) := FND_API.G_FALSE;
1109: l_context_id NUMBER;
1110:
1111: BEGIN
1112:

Line 1120: x_return := FND_API.G_TRUE;

1116:
1117: FETCH context_cur INTO l_context_id;
1118:
1119: IF context_cur%FOUND THEN
1120: x_return := FND_API.G_TRUE;
1121: END IF;
1122:
1123: CLOSE context_cur;
1124:

Line 1136: x_return := FND_API.G_TRUE;

1132: 'UNITS',
1133: 'DOLLARS'
1134: ) THEN
1135:
1136: x_return := FND_API.G_TRUE;
1137:
1138: END IF;
1139:
1140: END IF; --Attrmgr_Installed = 'Y'

Line 1247: IF G_PRODUCT_STATUS = FND_API.G_MISS_CHAR THEN

1243: l_retval BOOLEAN;
1244: BEGIN
1245:
1246:
1247: IF G_PRODUCT_STATUS = FND_API.G_MISS_CHAR THEN
1248:
1249: l_retval := fnd_installation.get(l_application_id,l_application_id,
1250: l_status,l_industry);
1251:

Line 4053: x_return_status := FND_API.G_RET_STS_SUCCESS;

4049: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4050: l_profile_pte_code qp_list_headers_b.pte_code%type;
4051: l_pte_code qp_list_headers_b.pte_code%type;
4052: BEGIN
4053: x_return_status := FND_API.G_RET_STS_SUCCESS;
4054:
4055: if p_list_header_id is NOT NULL then
4056: select source_system_code
4057: , list_type_code

Line 4087: x_return_status := FND_API.G_RET_STS_ERROR;

4083: )
4084: AND (l_list_type_code NOT IN ('AGR', 'PML', 'PRL'))
4085: ) then
4086:
4087: x_return_status := FND_API.G_RET_STS_ERROR;
4088:
4089: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4090: THEN
4091:

Line 4103: x_return_status := FND_API.G_RET_STS_ERROR;

4099: else -- attribute manager not installed
4100: if ((l_source_system_code <> l_profile_source_system_code)
4101: AND (l_list_type_code NOT IN ('AGR', 'PML', 'PRL'))) then
4102:
4103: x_return_status := FND_API.G_RET_STS_ERROR;
4104:
4105: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4106: THEN
4107:

Line 4313: values can be either FND_API.G_RET_STS_SUCCESS or

4309:
4310: Output Parameters:
4311: ------------------
4312: x_return_status - Indicates Success, Expected_error or Unexpected Error -
4313: values can be either FND_API.G_RET_STS_SUCCESS or
4314: FND_API.G_RET_STS_ERROR.
4315: x_context_out_tbl - Table of records where each record has 2 columns,
4316: context_code and context_name
4317:

Line 4314: FND_API.G_RET_STS_ERROR.

4310: Output Parameters:
4311: ------------------
4312: x_return_status - Indicates Success, Expected_error or Unexpected Error -
4313: values can be either FND_API.G_RET_STS_SUCCESS or
4314: FND_API.G_RET_STS_ERROR.
4315: x_context_out_tbl - Table of records where each record has 2 columns,
4316: context_code and context_name
4317:
4318: ****************************************************************************/

Line 4372: x_return_status := FND_API.G_RET_STS_SUCCESS;

4368: l_add_flag BOOLEAN;
4369:
4370: BEGIN
4371:
4372: x_return_status := FND_API.G_RET_STS_SUCCESS;
4373:
4374: IF Attrmgr_Installed = 'Y' THEN
4375:
4376: --Get the PTE code

Line 4538: x_return_status := FND_API.G_RET_STS_ERROR;

4534: END IF; --If Attrmgr_Installed = 'Y'
4535:
4536: EXCEPTION
4537: WHEN OTHERS THEN
4538: x_return_status := FND_API.G_RET_STS_ERROR;
4539: FND_MESSAGE.SET_NAME('QP','QP_ERR_IN_VALUESET_DEF');
4540: OE_MSG_PUB.Add;
4541:
4542: END Web_Create_Context_Lov;

Line 4584: values can be either FND_API.G_RET_STS_SUCCESS or

4580:
4581: Output Parameters:
4582: ------------------
4583: x_return_status - Indicates Success, Expected_error or Unexpected Error -
4584: values can be either FND_API.G_RET_STS_SUCCESS or
4585: FND_API.G_RET_STS_ERROR.
4586: x_attribute_out_tbl - Table of records where each record has 5 columns -
4587: segment_mapping_column, segment_name,
4588: segment_code, precedence and valueset_id

Line 4585: FND_API.G_RET_STS_ERROR.

4581: Output Parameters:
4582: ------------------
4583: x_return_status - Indicates Success, Expected_error or Unexpected Error -
4584: values can be either FND_API.G_RET_STS_SUCCESS or
4585: FND_API.G_RET_STS_ERROR.
4586: x_attribute_out_tbl - Table of records where each record has 5 columns -
4587: segment_mapping_column, segment_name,
4588: segment_code, precedence and valueset_id
4589:

Line 4643: x_return_status := FND_API.G_RET_STS_SUCCESS;

4639: NO_SEGMENT_FOUND BOOLEAN := TRUE;
4640:
4641: BEGIN
4642:
4643: x_return_status := FND_API.G_RET_STS_SUCCESS;
4644:
4645: IF Attrmgr_Installed = 'Y' THEN
4646:
4647: --Get PTE code from profile

Line 4997: x_return_status := FND_API.G_RET_STS_ERROR;

4993: END IF; --If Attrmgr_Installed = 'Y'
4994:
4995: EXCEPTION
4996: WHEN QP_NO_SEGMENT THEN
4997: x_return_status := FND_API.G_RET_STS_ERROR;
4998: FND_MESSAGE.SET_NAME('QP','QP_NO_SEGMENTS_AVAILABLE');
4999: OE_MSG_PUB.Add;
5000:
5001: END Web_Create_Attribute_Lov;

Line 5182: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

5178: p_product_attribute IN VARCHAR2,
5179: p_product_attr_val IN VARCHAR2) RETURN VARCHAR2 IS
5180: l_appl_id NUMBER := FND_GLOBAL.RESP_APPL_ID;
5181: l_dummy VARCHAR2(30);
5182: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5183: BEGIN
5184:
5185: if (p_product_context = 'ITEM')
5186: and (p_product_attribute = 'PRICING_ATTRIBUTE1') THEN

Line 5200: RETURN FND_API.G_RET_STS_ERROR;

5196: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
5197: FND_MESSAGE.SET_NAME('QP','QP_ITEM_NOT_VALID');
5198: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_product_attr_val);
5199: OE_MSG_PUB.Add;
5200: RETURN FND_API.G_RET_STS_ERROR;
5201: END IF;
5202: RAISE FND_API.G_EXC_ERROR;
5203: WHEN OTHERS THEN
5204: null;

Line 5202: RAISE FND_API.G_EXC_ERROR;

5198: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_product_attr_val);
5199: OE_MSG_PUB.Add;
5200: RETURN FND_API.G_RET_STS_ERROR;
5201: END IF;
5202: RAISE FND_API.G_EXC_ERROR;
5203: WHEN OTHERS THEN
5204: null;
5205: RETURN FND_API.G_RET_STS_ERROR;
5206: end;

Line 5205: RETURN FND_API.G_RET_STS_ERROR;

5201: END IF;
5202: RAISE FND_API.G_EXC_ERROR;
5203: WHEN OTHERS THEN
5204: null;
5205: RETURN FND_API.G_RET_STS_ERROR;
5206: end;
5207: end if;--(p_product_context =
5208:
5209: RETURN l_return_status;