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 4030: x_return_status := FND_API.G_RET_STS_SUCCESS;

4026: l_profile_source_system_code qp_list_headers_b.source_system_code%type;
4027: l_profile_pte_code qp_list_headers_b.pte_code%type;
4028: l_pte_code qp_list_headers_b.pte_code%type;
4029: BEGIN
4030: x_return_status := FND_API.G_RET_STS_SUCCESS;
4031:
4032: if p_list_header_id is NOT NULL then
4033: select source_system_code
4034: , list_type_code

Line 4064: x_return_status := FND_API.G_RET_STS_ERROR;

4060: )
4061: AND (l_list_type_code NOT IN ('AGR', 'PML', 'PRL'))
4062: ) then
4063:
4064: x_return_status := FND_API.G_RET_STS_ERROR;
4065:
4066: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4067: THEN
4068:

Line 4080: x_return_status := FND_API.G_RET_STS_ERROR;

4076: else -- attribute manager not installed
4077: if ((l_source_system_code <> l_profile_source_system_code)
4078: AND (l_list_type_code NOT IN ('AGR', 'PML', 'PRL'))) then
4079:
4080: x_return_status := FND_API.G_RET_STS_ERROR;
4081:
4082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4083: THEN
4084:

Line 4290: values can be either FND_API.G_RET_STS_SUCCESS or

4286:
4287: Output Parameters:
4288: ------------------
4289: x_return_status - Indicates Success, Expected_error or Unexpected Error -
4290: values can be either FND_API.G_RET_STS_SUCCESS or
4291: FND_API.G_RET_STS_ERROR.
4292: x_context_out_tbl - Table of records where each record has 2 columns,
4293: context_code and context_name
4294:

Line 4291: FND_API.G_RET_STS_ERROR.

4287: Output Parameters:
4288: ------------------
4289: x_return_status - Indicates Success, Expected_error or Unexpected Error -
4290: values can be either FND_API.G_RET_STS_SUCCESS or
4291: FND_API.G_RET_STS_ERROR.
4292: x_context_out_tbl - Table of records where each record has 2 columns,
4293: context_code and context_name
4294:
4295: ****************************************************************************/

Line 4349: x_return_status := FND_API.G_RET_STS_SUCCESS;

4345: l_add_flag BOOLEAN;
4346:
4347: BEGIN
4348:
4349: x_return_status := FND_API.G_RET_STS_SUCCESS;
4350:
4351: IF Attrmgr_Installed = 'Y' THEN
4352:
4353: --Get the PTE code

Line 4515: x_return_status := FND_API.G_RET_STS_ERROR;

4511: END IF; --If Attrmgr_Installed = 'Y'
4512:
4513: EXCEPTION
4514: WHEN OTHERS THEN
4515: x_return_status := FND_API.G_RET_STS_ERROR;
4516: FND_MESSAGE.SET_NAME('QP','QP_ERR_IN_VALUESET_DEF');
4517: OE_MSG_PUB.Add;
4518:
4519: END Web_Create_Context_Lov;

Line 4561: values can be either FND_API.G_RET_STS_SUCCESS or

4557:
4558: Output Parameters:
4559: ------------------
4560: x_return_status - Indicates Success, Expected_error or Unexpected Error -
4561: values can be either FND_API.G_RET_STS_SUCCESS or
4562: FND_API.G_RET_STS_ERROR.
4563: x_attribute_out_tbl - Table of records where each record has 5 columns -
4564: segment_mapping_column, segment_name,
4565: segment_code, precedence and valueset_id

Line 4562: FND_API.G_RET_STS_ERROR.

4558: Output Parameters:
4559: ------------------
4560: x_return_status - Indicates Success, Expected_error or Unexpected Error -
4561: values can be either FND_API.G_RET_STS_SUCCESS or
4562: FND_API.G_RET_STS_ERROR.
4563: x_attribute_out_tbl - Table of records where each record has 5 columns -
4564: segment_mapping_column, segment_name,
4565: segment_code, precedence and valueset_id
4566:

Line 4620: x_return_status := FND_API.G_RET_STS_SUCCESS;

4616: NO_SEGMENT_FOUND BOOLEAN := TRUE;
4617:
4618: BEGIN
4619:
4620: x_return_status := FND_API.G_RET_STS_SUCCESS;
4621:
4622: IF Attrmgr_Installed = 'Y' THEN
4623:
4624: --Get PTE code from profile

Line 4974: x_return_status := FND_API.G_RET_STS_ERROR;

4970: END IF; --If Attrmgr_Installed = 'Y'
4971:
4972: EXCEPTION
4973: WHEN QP_NO_SEGMENT THEN
4974: x_return_status := FND_API.G_RET_STS_ERROR;
4975: FND_MESSAGE.SET_NAME('QP','QP_NO_SEGMENTS_AVAILABLE');
4976: OE_MSG_PUB.Add;
4977:
4978: END Web_Create_Attribute_Lov;

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

5155: p_product_attribute IN VARCHAR2,
5156: p_product_attr_val IN VARCHAR2) RETURN VARCHAR2 IS
5157: l_appl_id NUMBER := FND_GLOBAL.RESP_APPL_ID;
5158: l_dummy VARCHAR2(30);
5159: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5160: BEGIN
5161:
5162: if (p_product_context = 'ITEM')
5163: and (p_product_attribute = 'PRICING_ATTRIBUTE1') THEN

Line 5177: RETURN FND_API.G_RET_STS_ERROR;

5173: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
5174: FND_MESSAGE.SET_NAME('QP','QP_ITEM_NOT_VALID');
5175: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_product_attr_val);
5176: OE_MSG_PUB.Add;
5177: RETURN FND_API.G_RET_STS_ERROR;
5178: END IF;
5179: RAISE FND_API.G_EXC_ERROR;
5180: WHEN OTHERS THEN
5181: null;

Line 5179: RAISE FND_API.G_EXC_ERROR;

5175: FND_MESSAGE.SET_TOKEN('ITEM_ID', p_product_attr_val);
5176: OE_MSG_PUB.Add;
5177: RETURN FND_API.G_RET_STS_ERROR;
5178: END IF;
5179: RAISE FND_API.G_EXC_ERROR;
5180: WHEN OTHERS THEN
5181: null;
5182: RETURN FND_API.G_RET_STS_ERROR;
5183: end;

Line 5182: RETURN FND_API.G_RET_STS_ERROR;

5178: END IF;
5179: RAISE FND_API.G_EXC_ERROR;
5180: WHEN OTHERS THEN
5181: null;
5182: RETURN FND_API.G_RET_STS_ERROR;
5183: end;
5184: end if;--(p_product_context =
5185:
5186: RETURN l_return_status;