DBA Data[Home] [Help]

APPS.ASO_OPP_QTE_PUB dependencies on FND_PROFILE

Line 310: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

306:
307: -- Standard Start of API savepoint
308: SAVEPOINT Create_Qte_Opportunity_pub;
309:
310: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
311:
312: IF aso_debug_pub.g_debug_flag = 'Y' THEN
313: aso_debug_pub.add('****** Start of Create_Qte_Opportunity API ******', 1, 'Y');
314: END IF;

Line 1101: l_profile_val := fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE');

1097: l_ln_shipment_count := 0;
1098: l_ln_sales_credit_count := 0;
1099: l_ln_price_attr_count := 0;
1100: l_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
1101: l_profile_val := fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE');
1102:
1103: FOR i IN 1..lpx_qte_line_tbl.count LOOP
1104:
1105: IF lpx_qte_line_tbl(i).pricing_status_code <> FND_API.G_RET_STS_SUCCESS THEN

Line 1207: || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'N');

1203: END LOOP;
1204:
1205: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1206: aso_debug_pub.add('ASO_OPP_QTE_PUB: value of ASO_API_ENABLE_SECURITY:'
1207: || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'N');
1208: aso_debug_pub.add('ASO_OPP_QTE_PUB: before copy sales team loop: lx_qte_header_rec.resource_id:'
1209: || lx_qte_header_rec.resource_id, 1, 'Y');
1210: END IF;
1211:

Line 1212: IF NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN

1208: aso_debug_pub.add('ASO_OPP_QTE_PUB: before copy sales team loop: lx_qte_header_rec.resource_id:'
1209: || lx_qte_header_rec.resource_id, 1, 'Y');
1210: END IF;
1211:
1212: IF NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN
1213: FOR l_sales_team_rec IN C_sales_team(P_OPP_QTE_IN_REC.OPPORTUNITY_ID) LOOP
1214: IF l_sales_team_rec.salesforce_id <> lx_qte_header_rec.resource_id THEN
1215: l_qte_access_rec := ASO_SECURITY_INT.G_MISS_QTE_ACCESS_REC;
1216: l_qte_access_rec.OPERATION_CODE := 'CREATE';

Line 1257: END IF; --NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y'

1253: aso_debug_pub.add('ASO_OPP_QTE_PUB: after copy sales team loop: l_qte_access_tbl.count:'
1254: || l_qte_access_tbl.count, 1, 'N');
1255: END IF;
1256:
1257: END IF; --NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y'
1258:
1259:
1260:
1261:

Line 1351: || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'N');

1347:
1348:
1349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1350: aso_debug_pub.add('ASO_OPP_QTE_PUB: value of ASO_API_ENABLE_SECURITY:'
1351: || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'N');
1352: END IF;
1353:
1354: IF NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN
1355: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1354: IF NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN

1350: aso_debug_pub.add('ASO_OPP_QTE_PUB: value of ASO_API_ENABLE_SECURITY:'
1351: || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'N');
1352: END IF;
1353:
1354: IF NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' THEN
1355: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1356: aso_debug_pub.add('ASO_OPP_QTE_PUB: before copy sales team loop: lx_qte_header_rec.resource_id:'
1357: || lx_qte_header_rec.resource_id, 1, 'Y');
1358: END IF;

Line 1613: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1609: l_master_organization_id NUMBER;
1610: l_segment1 VARCHAR2(240);
1611: BEGIN
1612:
1613: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1614:
1615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1616: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: *** Start of API body ***', 1, 'Y');
1617: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');

Line 1664: IF (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') <> 'N')

1660:
1661: END IF;
1662:
1663: IF orderable_items_rec.service_item_flag = 'Y' THEN
1664: IF (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') <> 'N')
1665: OR (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') is null) THEN
1666: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1667: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item is of type service:'
1668: || p_inventory_item_id, 1, 'N');

Line 1665: OR (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') is null) THEN

1661: END IF;
1662:
1663: IF orderable_items_rec.service_item_flag = 'Y' THEN
1664: IF (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') <> 'N')
1665: OR (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') is null) THEN
1666: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1667: aso_debug_pub.add('ASO_OPP_QTE_PUB: Validate_Item: item is of type service:'
1668: || p_inventory_item_id, 1, 'N');
1669: END IF;

Line 1679: l_resp_id := FND_PROFILE.Value('RESP_ID');

1675: end if;
1676: END IF;
1677:
1678: IF orderable_items_rec.bom_item_type = 1 THEN
1679: l_resp_id := FND_PROFILE.Value('RESP_ID');
1680: l_resp_appl_id := FND_PROFILE.Value('RESP_APPL_ID');
1681: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM(
1682: p_inventory_item_id,
1683: p_organization_id,

Line 1680: l_resp_appl_id := FND_PROFILE.Value('RESP_APPL_ID');

1676: END IF;
1677:
1678: IF orderable_items_rec.bom_item_type = 1 THEN
1679: l_resp_id := FND_PROFILE.Value('RESP_ID');
1680: l_resp_appl_id := FND_PROFILE.Value('RESP_APPL_ID');
1681: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM(
1682: p_inventory_item_id,
1683: p_organization_id,
1684: SYSDATE,

Line 1687: FND_PROFILE.Value('RESP_ID'),

1683: p_organization_id,
1684: SYSDATE,
1685: 'APPLET',
1686: FND_API.G_MISS_NUM,
1687: FND_PROFILE.Value('RESP_ID'),
1688: FND_PROFILE.Value('RESP_APPL_ID')
1689: );
1690:
1691: IF l_ui_def_id IS NULL THEN

Line 1688: FND_PROFILE.Value('RESP_APPL_ID')

1684: SYSDATE,
1685: 'APPLET',
1686: FND_API.G_MISS_NUM,
1687: FND_PROFILE.Value('RESP_ID'),
1688: FND_PROFILE.Value('RESP_APPL_ID')
1689: );
1690:
1691: IF l_ui_def_id IS NULL THEN
1692: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1786: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1782: AND entity_name = 'AS_OPPORTUNITY_ATTCH';
1783:
1784: BEGIN
1785:
1786: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1787:
1788: x_copy_notes_flag := 'N';
1789: x_copy_task_flag := 'N';
1790: x_copy_att_flag := 'N';