58: ' Get_OperatingUnit '
59: );
60: END IF;
61:
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63:
64: END Get_OperatingUnit;
65:
66:
112: ' Get_OrderType '
113: );
114: END IF;
115:
116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
117:
118: END Get_OrderType;
119:
120: FUNCTION Get_ContractTemplate(P_Database_Object_Name IN VARCHAR2,
165: ' Get_ContractTemplate '
166: );
167: END IF;
168:
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170:
171: END Get_ContractTemplate;
172:
173: FUNCTION Get_CustAcct_From_CustParty (
277: ' Get_CustAcct_From_CustParty '
278: );
279: END IF;
280:
281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
282:
283: END Get_CustAcct_From_CustParty;
284:
285: FUNCTION Get_PriceList_From_Agreement (
360: ' Get_PriceList_From_Agreement '
361: );
362: END IF;
363:
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365:
366: END Get_PriceList_From_Agreement;
367:
368:
443: ' Get_PriceList_From_CustAcct '
444: );
445: END IF;
446:
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448:
449: END Get_PriceList_From_CustAcct;
450:
451:
518: ' Get_PriceList_From_OrderType '
519: );
520: END IF;
521:
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523:
524: END Get_PriceList_From_OrderType;
525:
526:
591: ' Get_PaymentTerm_From_Agreement '
592: );
593: END IF;
594:
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596:
597: END Get_PaymentTerm_From_Agreement;
598:
599: FUNCTION Get_PaymentTerm_From_Customer (
662: ' Get_PaymentTerm_From_Customer '
663: );
664: END IF;
665:
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667:
668: END Get_PaymentTerm_From_Customer;
669:
670: FUNCTION Get_ExpirationDate (
748: ' Get_ExpirationDate '
749: );
750: END IF;
751:
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753:
754: END Get_ExpirationDate;
755:
756:
832: l_ret_value,1,'N');
833: END IF;
834: ELSE
835:
836: IF l_party_id IS NOT NULL AND l_party_id <> FND_API.G_MISS_NUM THEN
837: OPEN C_Get_Phone (l_party_id);
838: FETCH C_Get_Phone INTO l_ret_value;
839: CLOSE C_Get_Phone;
840: END IF;
867: ' Get_QuotePhone '
868: );
869: END IF;
870:
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872:
873: END Get_QuotePhone;
874:
875: FUNCTION Get_QuoteAddress(
1089: ' Get_QuoteAddress '
1090: );
1091: END IF;
1092:
1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1094:
1095: END Get_QuoteAddress;
1096:
1097: FUNCTION Get_BillAddress(
1316: ' Get_BillAddress '
1317: );
1318: END IF;
1319:
1320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1321:
1322: END Get_BillAddress;
1323:
1324: FUNCTION Get_ShipAddress(
1548: ' Get_ShipAddress '
1549: );
1550: END IF;
1551:
1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553:
1554: END Get_ShipAddress;
1555:
1556:
1609: l_resource_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_resource_id;
1610: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_Org_id;
1611: END IF;
1612:
1613: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN
1614: return null;
1615: END IF;
1616:
1617: IF l_resource_id IS NULL OR l_resource_id = FND_API.G_MISS_NUM THEN
1613: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN
1614: return null;
1615: END IF;
1616:
1617: IF l_resource_id IS NULL OR l_resource_id = FND_API.G_MISS_NUM THEN
1618: OPEN C_salesrep(G_USER_ID);
1619: FETCH C_salesrep INTO l_resource_id;
1620: CLOSE C_salesrep;
1621: END IF;
1649: ' Get_SalesGroup_From_Salesrep '
1650: );
1651: END IF;
1652:
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654:
1655: END Get_SalesGroup_From_Salesrep;
1656:
1657: FUNCTION Get_SalesGroup_From_Profile (
1700: ' Get_SalesGroup_From_Profile '
1701: );
1702: END IF;
1703:
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705:
1706: END Get_SalesGroup_From_Profile;
1707:
1708:
1755: ELSIF p_database_object_name = 'ASO_AK_QUOTE_OPPTY_V' THEN
1756: l_org_id := ASO_QUOTE_OPPTY_DEF_HDLR.g_record.O_ORG_ID;
1757: END IF;
1758:
1759: IF l_org_id is null or l_org_id = FND_API.G_MISS_NUM THEN
1760: return null;
1761: END IF;
1762:
1763: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1829: ' Get_SalesRep '
1830: );
1831: END IF;
1832:
1833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1834:
1835: END Get_SalesRep;
1836:
1837: FUNCTION Get_Currency_from_pricelist(
1887: ' Get_Currency_from_pricelist '
1888: );
1889: END IF;
1890:
1891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1892:
1893: End Get_Currency_from_pricelist;
1894:
1895: FUNCTION Get_Currency_from_Profile(
1930: ' Get_Currency_from_Profile '
1931: );
1932: END IF;
1933:
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935:
1936: END Get_Currency_from_Profile;
1937:
1938:
1958: IF p_database_object_name='ASO_AK_QUOTE_HEADER_V' THEN
1959: l_acct_id := ASO_QUOTE_HEADER_DEF_HDLR.g_record.Q_cust_account_id;
1960:
1961: IF ( l_acct_id IS NOT NULL AND
1962: l_acct_id <> FND_API.G_MISS_NUM ) THEN
1963: OPEN C_Get_RDT (l_acct_id);
1964: FETCH C_Get_RDT INTO l_ret_value;
1965: CLOSE C_Get_RDT;
1966:
1999: ' Get_RequestedDateType '
2000: );
2001: END IF;
2002:
2003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2004:
2005: END Get_RequestedDateType;
2006:
2007:
2029: l_organization_id := ASO_QUOTE_LINE_DEF_HDLR.g_record.L_ORGANIZATION_ID;
2030: l_inventory_item_id := ASO_QUOTE_LINE_DEF_HDLR.g_record.L_INVENTORY_ITEM_ID;
2031:
2032: IF ( l_organization_id IS NOT NULL AND
2033: l_organization_id <> FND_API.G_MISS_NUM )
2034: AND ( l_inventory_item_id IS NOT NULL AND
2035: l_inventory_item_id <> FND_API.G_MISS_NUM )THEN
2036: OPEN C_Get_CP (l_organization_id, l_inventory_item_id);
2037: FETCH C_Get_CP INTO l_ret_value;
2031:
2032: IF ( l_organization_id IS NOT NULL AND
2033: l_organization_id <> FND_API.G_MISS_NUM )
2034: AND ( l_inventory_item_id IS NOT NULL AND
2035: l_inventory_item_id <> FND_API.G_MISS_NUM )THEN
2036: OPEN C_Get_CP (l_organization_id, l_inventory_item_id);
2037: FETCH C_Get_CP INTO l_ret_value;
2038: CLOSE C_Get_CP;
2039:
2072: ' Get_ChargePeriodicity '
2073: );
2074: END IF;
2075:
2076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2077:
2078: END Get_ChargePeriodicity;
2079:
2080: END QOT_DEFAULT_PVT;