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.OZF_PRE_PROCESS_PVT dependencies on FND_PROFILE

Line 24: G_DQM_CONTACT_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_CONTACT_DQM_RULE');

20: G_BATCH_CURRENCY_CODE VARCHAR2(30) := NULL;
21: G_INVENTORY_TRACKING_FLAG VARCHAR2(1) := NULL;
22: G_ADMIN_EMAIL VARCHAR2(100);
23:
24: G_DQM_CONTACT_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_CONTACT_DQM_RULE');
25: G_DQM_PARTY_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_DQM_RULE');
26: G_DQM_PARTY_SITE_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_SITE_DQM_RULE');
27: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
28: G_DEFAULT_ORG_ID NUMBER := FND_PROFILE.value('DEFAULT_ORG_ID');

Line 25: G_DQM_PARTY_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_DQM_RULE');

21: G_INVENTORY_TRACKING_FLAG VARCHAR2(1) := NULL;
22: G_ADMIN_EMAIL VARCHAR2(100);
23:
24: G_DQM_CONTACT_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_CONTACT_DQM_RULE');
25: G_DQM_PARTY_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_DQM_RULE');
26: G_DQM_PARTY_SITE_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_SITE_DQM_RULE');
27: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
28: G_DEFAULT_ORG_ID NUMBER := FND_PROFILE.value('DEFAULT_ORG_ID');
29:

Line 26: G_DQM_PARTY_SITE_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_SITE_DQM_RULE');

22: G_ADMIN_EMAIL VARCHAR2(100);
23:
24: G_DQM_CONTACT_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_CONTACT_DQM_RULE');
25: G_DQM_PARTY_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_DQM_RULE');
26: G_DQM_PARTY_SITE_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_SITE_DQM_RULE');
27: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
28: G_DEFAULT_ORG_ID NUMBER := FND_PROFILE.value('DEFAULT_ORG_ID');
29:
30: -- Private Procedure

Line 27: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

23:
24: G_DQM_CONTACT_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_CONTACT_DQM_RULE');
25: G_DQM_PARTY_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_DQM_RULE');
26: G_DQM_PARTY_SITE_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_SITE_DQM_RULE');
27: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
28: G_DEFAULT_ORG_ID NUMBER := FND_PROFILE.value('DEFAULT_ORG_ID');
29:
30: -- Private Procedure
31: PROCEDURE Number_Mapping_Required(

Line 28: G_DEFAULT_ORG_ID NUMBER := FND_PROFILE.value('DEFAULT_ORG_ID');

24: G_DQM_CONTACT_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_CONTACT_DQM_RULE');
25: G_DQM_PARTY_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_DQM_RULE');
26: G_DQM_PARTY_SITE_RULE NUMBER := FND_PROFILE.value('OZF_RESALE_PARTY_SITE_DQM_RULE');
27: G_ITEM_ORG_ID NUMBER := FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
28: G_DEFAULT_ORG_ID NUMBER := FND_PROFILE.value('DEFAULT_ORG_ID');
29:
30: -- Private Procedure
31: PROCEDURE Number_Mapping_Required(
32: p_internal_code_tbl IN NUMBER_TABLE,

Line 1187: l_dqm_contact_rule := G_DQM_CONTACT_RULE; --fnd_profile.value('OZF_RESALE_CONTACT_DQM_RULE');

1183: l_partner_cntct_rec.contact_name := px_resale_batch_rec.partner_contact_name;
1184: l_partner_cntct_rec.party_email_id := px_resale_batch_rec.partner_email;
1185: l_partner_cntct_rec.party_phone := px_resale_batch_rec.partner_phone;
1186: l_partner_cntct_rec.party_fax := px_resale_batch_rec.partner_fax;
1187: l_dqm_contact_rule := G_DQM_CONTACT_RULE; --fnd_profile.value('OZF_RESALE_CONTACT_DQM_RULE');
1188: IF OZF_DEBUG_LOW_ON THEN
1189: ozf_utility_pvt.debug_message ( 'DQM Contact Rule '|| l_dqm_contact_rule);
1190: END IF;
1191: IF l_dqm_contact_rule IS NOT NULL THEN

Line 1269: l_resale_batch_rec.org_id := G_DEFAULT_ORG_ID; --FND_PROFILE.value('DEFAULT_ORG_ID');

1265: -- Org ID Defaulting
1266: -- -----------------------------------------------------------------
1267:
1268: IF l_resale_batch_rec.org_id IS NULL THEN
1269: l_resale_batch_rec.org_id := G_DEFAULT_ORG_ID; --FND_PROFILE.value('DEFAULT_ORG_ID');
1270: END IF;
1271: IF OZF_DEBUG_LOW_ON THEN
1272: ozf_utility_pvt.debug_message ( 'Org ID '|| l_resale_batch_rec.org_id);
1273: END IF;

Line 2063: px_line_record.org_id(i) := G_DEFAULT_ORG_ID; --FND_PROFILE.value('DEFAULT_ORG_ID');

2059: LOOP
2060:
2061: -- Derive ORG ID
2062: IF px_line_record.org_id(i) IS NULL THEN
2063: px_line_record.org_id(i) := G_DEFAULT_ORG_ID; --FND_PROFILE.value('DEFAULT_ORG_ID');
2064: END IF;
2065: -- Derive Quantity from External Quantity
2066: IF px_line_record.quantity(i) IS NULL THEN
2067: IF px_line_record.orig_system_quantity(i) IS NOT NULL THEN

Line 2141: px_line_record.price_list_id(i) := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');

2137: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
2138:
2139: IF l_batch_type = 'TP_ACCRUAL' THEN
2140: IF px_line_record.agreement_type(i) IS NULL AND px_line_record.agreement_id(i) IS NULL AND px_line_record.price_list_id(i) IS NULL THEN
2141: px_line_record.price_list_id(i) := FND_PROFILE.value('OZF_TP_ACCRUAL_PRICE_LIST');
2142: END IF;
2143: END IF;
2144:
2145: IF px_line_record.price_list_id(i) IS NOT NULL AND

Line 2723: l_org_id := G_ITEM_ORG_ID; --FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

2719: -----------------------------------------------------------------------
2720: IF px_line_record.inventory_item_id(i) IS NOT NULL AND
2721: px_line_record.item_number(i) IS NULL THEN
2722: -- Bug 4520881 (+)
2723: l_org_id := G_ITEM_ORG_ID; --FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
2724: -- SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
2725: -- INTO l_org_id FROM DUAL;
2726: -- Bug 4520881 (-)
2727: OPEN get_item_number( px_line_record.inventory_item_id(i)

Line 4442: l_org_id := G_ITEM_ORG_ID; --FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');

4438:
4439: IF p_item_number_tbl.COUNT > 0 THEN
4440: FOR i IN 1..p_item_number_tbl.COUNT LOOP
4441: IF p_item_number_tbl(i) IS NOT NULL THEN
4442: l_org_id := G_ITEM_ORG_ID; --FND_PROFILE.value('AMS_ITEM_ORGANIZATION_ID');
4443: IF OZF_DEBUG_LOW_ON THEN
4444: ozf_utility_pvt.debug_message('p_item_number_tbl(i) ' || p_item_number_tbl(i));
4445: END IF;
4446: OPEN get_inventory_item_id(p_item_number_tbl(i),

Line 5747: l_dqm_party_rule := G_DQM_PARTY_RULE; --fnd_profile.value('OZF_RESALE_PARTY_DQM_RULE');

5743:
5744:
5745: IF l_run_dqm_flag = 'Y' THEN
5746:
5747: l_dqm_party_rule := G_DQM_PARTY_RULE; --fnd_profile.value('OZF_RESALE_PARTY_DQM_RULE');
5748: l_dqm_party_site_rule := G_DQM_PARTY_SITE_RULE; --fnd_profile.value('OZF_RESALE_PARTY_SITE_DQM_RULE');
5749: l_dqm_contact_rule := G_DQM_CONTACT_RULE; --fnd_profile.value('OZF_RESALE_CONTACT_DQM_RULE');
5750:
5751: IF OZF_DEBUG_LOW_ON THEN

Line 5748: l_dqm_party_site_rule := G_DQM_PARTY_SITE_RULE; --fnd_profile.value('OZF_RESALE_PARTY_SITE_DQM_RULE');

5744:
5745: IF l_run_dqm_flag = 'Y' THEN
5746:
5747: l_dqm_party_rule := G_DQM_PARTY_RULE; --fnd_profile.value('OZF_RESALE_PARTY_DQM_RULE');
5748: l_dqm_party_site_rule := G_DQM_PARTY_SITE_RULE; --fnd_profile.value('OZF_RESALE_PARTY_SITE_DQM_RULE');
5749: l_dqm_contact_rule := G_DQM_CONTACT_RULE; --fnd_profile.value('OZF_RESALE_CONTACT_DQM_RULE');
5750:
5751: IF OZF_DEBUG_LOW_ON THEN
5752: ozf_utility_pvt.debug_message( 'Party DQM Rule '|| l_dqm_party_rule );

Line 5749: l_dqm_contact_rule := G_DQM_CONTACT_RULE; --fnd_profile.value('OZF_RESALE_CONTACT_DQM_RULE');

5745: IF l_run_dqm_flag = 'Y' THEN
5746:
5747: l_dqm_party_rule := G_DQM_PARTY_RULE; --fnd_profile.value('OZF_RESALE_PARTY_DQM_RULE');
5748: l_dqm_party_site_rule := G_DQM_PARTY_SITE_RULE; --fnd_profile.value('OZF_RESALE_PARTY_SITE_DQM_RULE');
5749: l_dqm_contact_rule := G_DQM_CONTACT_RULE; --fnd_profile.value('OZF_RESALE_CONTACT_DQM_RULE');
5750:
5751: IF OZF_DEBUG_LOW_ON THEN
5752: ozf_utility_pvt.debug_message( 'Party DQM Rule '|| l_dqm_party_rule );
5753: ozf_utility_pvt.debug_message( 'Party Site DQM Rule '|| l_dqm_party_site_rule );