APPS.ASO_QUOTE_TMPL_PVT dependencies on FND_PROFILE

Line 100: l_prof_temp_filter varchar2(1):=nvl(fnd_profile.value('ASO_FILTER_QUOTE_TEMPLATE_BY'),'Q');

96:
97: -- ER 9433340
98: l_validate_item boolean;
99: l_tmpl_org_id number;
100: l_prof_temp_filter varchar2(1):=nvl(fnd_profile.value('ASO_FILTER_QUOTE_TEMPLATE_BY'),'Q');
101: l_qte_organization_id number;
102:
103: CURSOR c_conc_segments (l_inventory_item_id NUMBER) IS
104: SELECT concatenated_segments

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

130:
131: -- Standard Start of API savepoint
132: SAVEPOINT Add_Template_To_Quote_PVT;
133:
134: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
135:
136: IF aso_debug_pub.g_debug_flag = 'Y' THEN
137: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
138: END IF;

Line 737: lprof varchar2(10) := nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N');

733: from aso_quote_lines_All
734: where quote_line_id = l_quote_line_id;
735:
736:
737: lprof varchar2(10) := nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N');
738: l_inv_id number;
739: l_service_ref_line_id number;
740: l_check_service_rec ASO_SERVICE_CONTRACTS_INT.CHECK_SERVICE_REC_TYPE;
741: l_cust number;

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

745:
746: -- end service items
747:
748: begin
749: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** Start of API body ***', 1, 'Y');
753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');

Line 798: IF (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') <> 'N') OR (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') is null) THEN

794: END IF;
795:
796:
797: IF orderable_items_rec.service_item_flag = 'Y' THEN
798: IF (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') <> 'N') OR (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') is null) THEN
799: IF aso_debug_pub.g_debug_flag = 'Y' THEN
800: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item is of type service:' || p_inventory_item_id, 1, 'N');
801: END IF;
802: open c_service_ref_quote(p_quote_line_id);

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

842: END IF;
843:
844: -- Top model item
845: IF orderable_items_rec.bom_item_type = 1 THEN
846: l_resp_id := FND_PROFILE.Value('RESP_ID');
847: l_resp_appl_id := FND_PROFILE.Value('RESP_APPL_ID');
848: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM(
849: p_inventory_item_id,
850: l_master_organization_id,

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

843:
844: -- Top model item
845: IF orderable_items_rec.bom_item_type = 1 THEN
846: l_resp_id := FND_PROFILE.Value('RESP_ID');
847: l_resp_appl_id := FND_PROFILE.Value('RESP_APPL_ID');
848: l_ui_def_id := CZ_CF_API.UI_FOR_ITEM(
849: p_inventory_item_id,
850: l_master_organization_id,
851: SYSDATE,

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

850: l_master_organization_id,
851: SYSDATE,
852: 'APPLET',
853: FND_API.G_MISS_NUM,
854: FND_PROFILE.Value('RESP_ID'),
855: FND_PROFILE.Value('RESP_APPL_ID')
856: );
857:
858: IF l_ui_def_id IS NULL THEN

Line 855: FND_PROFILE.Value('RESP_APPL_ID')

851: SYSDATE,
852: 'APPLET',
853: FND_API.G_MISS_NUM,
854: FND_PROFILE.Value('RESP_ID'),
855: FND_PROFILE.Value('RESP_APPL_ID')
856: );
857:
858: IF l_ui_def_id IS NULL THEN
859: IF aso_debug_pub.g_debug_flag = 'Y' THEN