eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_RUNTIME_CAMP_PVT dependencies on OZF_OFFR_ELIG_PROD_DENORM_PVT

Line 1428: l_offers_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

1424: l_api_version CONSTANT NUMBER := 1.0;
1425: l_cust_account_id NUMBER;
1426: l_party_id NUMBER;
1427: --l_offers_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1428: l_offers_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1429: l_offer_lst JTF_NUMBER_TABLE;
1430:
1431: l_in_offer_lst JTF_NUMBER_TABLE;
1432:

Line 1434: x_offers_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

1430:
1431: l_in_offer_lst JTF_NUMBER_TABLE;
1432:
1433: --x_offers_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1434: x_offers_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1435:
1436: --fix for SQL Repository issue 11755480
1437: l_offer_stmt VARCHAR2(2500) := 'Select qlhv.list_header_id
1438: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch

Line 1554: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');

1550:
1551:
1552: IF (AMS_DEBUG_HIGH_ON) THEN
1553: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');
1554: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig starts');
1555: END IF;
1556:
1557: /*
1558: AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig(

Line 1574: OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig(

1570: );
1571:
1572: */
1573:
1574: OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig(
1575: p_offers_tbl => l_offers_tbl,
1576: p_party_id => l_party_id,
1577: p_cust_acct_id => l_cust_account_id,
1578: p_cust_site_id => NULL,

Line 1604: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');

1600: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1601: IF (AMS_DEBUG_HIGH_ON) THEN
1602:
1603: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1604: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig');
1605: END IF;
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: END IF;
1608:

Line 1623: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');

1619: END IF;
1620:
1621: IF (AMS_DEBUG_HIGH_ON) THEN
1622: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1623: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1624: END IF;
1625:
1626: -- Standard call to get message count and if count is 1, get message info.
1627: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 1814: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');

1810: -- End of API body.
1811:
1812: IF (AMS_DEBUG_HIGH_ON) THEN
1813: --AMS_UTILITY_PVT.debug_message('AMS_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1814: AMS_UTILITY_PVT.debug_message('OZF_OFFR_ELIG_PROD_DENORM_PVT.find_party_elig ends');
1815:
1816: END IF;
1817:
1818: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1889: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

1885: l_quote_prod_lst JTF_NUMBER_TABLE;
1886: l_in_offer_lst JTF_NUMBER_TABLE;
1887: --l_prod_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1888: --l_offer_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1889: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1890: l_offer_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1891: l_bus_prior VARCHAR2(30) := NULL;
1892:
1893: --fix for SQL Repository issue 11755493

Line 1890: l_offer_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

1886: l_in_offer_lst JTF_NUMBER_TABLE;
1887: --l_prod_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1888: --l_offer_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1889: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1890: l_offer_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1891: l_bus_prior VARCHAR2(30) := NULL;
1892:
1893: --fix for SQL Repository issue 11755493
1894: l_offer_stmt VARCHAR2(2500) := 'Select qlhv.list_header_id

Line 2052: OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig(

2048: x_msg_data,
2049: l_offer_tbl
2050: );
2051: */
2052: OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig(
2053: l_prod_tbl,
2054: p_party_id,
2055: p_cust_account_id,
2056: NULL, --p_cust_site_id

Line 2069: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');

2065:
2066: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2067: IF (AMS_DEBUG_HIGH_ON) THEN
2068: --AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2069: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2070: END IF;
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2303: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

2299: l_prod_lst JTF_NUMBER_TABLE;
2300: l_bus_prior VARCHAR2(30) := NULL;
2301: --l_prod_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2302: --l_offer_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2303: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2304: l_offer_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2305: l_offer_stmt VARCHAR2(2000) := 'SELECT qlhv.list_header_id
2306: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp
2307: WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id

Line 2304: l_offer_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

2300: l_bus_prior VARCHAR2(30) := NULL;
2301: --l_prod_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2302: --l_offer_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2303: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2304: l_offer_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2305: l_offer_stmt VARCHAR2(2000) := 'SELECT qlhv.list_header_id
2306: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch,ams_campaigns_all_b camp
2307: WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
2308: AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id

Line 2487: OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig(

2483: l_offer_tbl
2484: );
2485: */
2486:
2487: OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig(
2488: l_prod_tbl,
2489: p_party_id,
2490: p_cust_account_id,
2491: NULL, --p_cust_site_id

Line 2510: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');

2506: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2507: IF (AMS_DEBUG_HIGH_ON) THEN
2508:
2509: -- AMS_UTILITY_PVT.debug_message('Problem in AMS_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2510: AMS_UTILITY_PVT.debug_message('Problem in OZF_OFFR_ELIG_PROD_DENORM_PVT.find_product_elig');
2511: END IF;
2512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2513: END IF;
2514: