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

Line 891: G_RAIL_REC.receipt_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0')); */

887: IF l_line_party_id = l_line_party_id THEN */
888: IF l_line_party_id = l_hdr_party_id THEN
889: G_RAIL_REC.payment_trxn_extension_id := p_ext_id;
890: /* Commented by sjanakir for Bug #6855301
891: G_RAIL_REC.receipt_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0')); */
892:
893: Else
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB. no Transaction Ext. Id for line ');
895: End if;

Line 1037: if nvl(fnd_profile.value('OKS_INV_ORG_TAX_COMPUTE'),'NO') = 'YES'

1033: The profile option determines if contract line inventory org is used
1034: when calculating service line tax thorugh vertex.
1035: ****/
1036: G_RAIL_REC.WAREHOUSE_ID := NULL;
1037: if nvl(fnd_profile.value('OKS_INV_ORG_TAX_COMPUTE'),'NO') = 'YES'
1038: Then
1039: G_RAIL_REC.WAREHOUSE_ID := item_rec.Object1_id2;
1040: End if;
1041:

Line 1089: l_cro_code := FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE');

1085: AND party.cle_id is null;
1086:
1087: l_cro_code Varchar2(30);
1088: BEGIN
1089: l_cro_code := FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE');
1090:
1091: OPEN l_Salesrep_csr(l_cro_code, p_dnz_chr_id);
1092: FETCH l_Salesrep_csr into G_RAIL_REC.PRIMARY_SALESREP_ID ;
1093: CLOSE l_Salesrep_csr;

Line 2111: If nvl(FND_PROFILE.VALUE('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y')='N' THEN

2107: x_return_status := 'E';
2108: END IF; --IF (l_ret_stat <> 'S')
2109:
2110: /*Added for bug 14242256 */
2111: If nvl(FND_PROFILE.VALUE('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y')='N' THEN
2112: INSERT_RA_REV_DIST( x_return_status,
2113: p_bcl_cle_id);
2114: IF (x_return_status <> 'S') THEN
2115: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_price_breaks => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');

Line 2824: l_pay_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0'));

2820: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Customer Payment method id is '||l_cust_pay_method_id);
2821: END IF;
2822: ELSE
2823:
2824: l_pay_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, p_org_id, NULL),'0'));
2825:
2826: IF l_pay_method_id = 0 THEN
2827: IF G_LOG_YES_NO = 'YES' THEN
2828: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Payment method id is '||l_pay_method_id);

Line 2980: G_LOG_YES_NO := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');

2976: --Fix for bug#4198616
2977: --declared global variable G_LOG_YES_NO and using this variable
2978: --in place OKS_BILLING_PUB.l_write_log to decide whether to log
2979: --messages
2980: G_LOG_YES_NO := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
2981:
2982: If G_LOG_YES_NO = 'YES' then ---- added by ansraj for 14016663
2983: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => OKS: Billing Report And Log is set to '||G_LOG_YES_NO);
2984: End If;

Line 3396: (FND_PROFILE.VALUE('OKS_CURR_CONV_DATE') = 'SYSDATE' AND G_RAIL_REC.CONVERSION_TYPE <> 'User' )THEN

3392: END IF;
3393:
3394: /*cgopinee bugfix for 8361496*/
3395: IF (Rul_hdr_rec.conversion_rate_date IS NULL) OR
3396: (FND_PROFILE.VALUE('OKS_CURR_CONV_DATE') = 'SYSDATE' AND G_RAIL_REC.CONVERSION_TYPE <> 'User' )THEN
3397: G_RAIL_REC.CONVERSION_DATE := sysdate;
3398: ELSE
3399: G_RAIL_REC.CONVERSION_DATE := Rul_hdr_rec.conversion_rate_date;
3400: --G_RAIL_REC.CONVERSION_DATE := to_date(Rules_rec.Rule_information2,'YYYY/MM/DD HH24:MI:SS');

Line 3792: G_RAIL_REC.receipt_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, rul_hdr_rec.org_id, NULL),'0'));*/

3788: IF bcl_rec.trxn_extension_id is NOT NULL then
3789: G_RAIL_REC.payment_trxn_extension_id :=
3790: bcl_rec.trxn_extension_id;
3791: /* Commented and Modification done by sjanakir for Bug #6855301
3792: G_RAIL_REC.receipt_method_id := to_number(nvl(FND_PROFILE.VALUE_SPECIFIC('OKS_RECEIPT_METHOD_ID', NULL, NULL, NULL, rul_hdr_rec.org_id, NULL),'0'));*/
3793: G_RAIL_REC.receipt_method_id := Get_receipt_method_id (p_customer_id => l_cust_id,
3794: p_site_use_id => l_site_use_id,
3795: p_cc_only => l_cc_only ,
3796: p_as_of_date => TRUNC(l_as_of_date) ,

Line 3904: l_bill_profile_flag := FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN');

3900: ELSE
3901: IF (l_hdr_summary_flag = 'Y') THEN --Summary flag set in contract
3902: l_bill_profile := G_SUM;
3903: ELSE -- read profile value
3904: l_bill_profile_flag := FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN');
3905: IF (l_bill_profile_flag = 'YES') THEN
3906: l_bill_profile := G_SUM;
3907: ELSE
3908: l_bill_profile := G_DET;

Line 4128: ELSIF (Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N') THEN

4124:
4125: RAISE MAIN_CUR_EXCEPTION;
4126: END IF;
4127:
4128: ELSIF (Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N') THEN
4129: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);
4130:
4131: IF (l_ret_stat <> 'S') THEN
4132: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);

Line 4657: ELSIF (Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N') THEN

4653: IF (l_ret_stat <> 'S') THEN
4654: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4655: RAISE MAIN_CUR_EXCEPTION;
4656: END IF;
4657: ELSIF (Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N') THEN
4658: insert_ra_rev_dist( l_ret_stat,bcl_rec.cle_id);
4659: IF (l_ret_stat <> 'S') THEN
4660: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Get_REC_FEEDER => Insert INTO RA_REVENUE_DISTRIBUTIONS'||lines_rec.id);
4661: RAISE MAIN_CUR_EXCEPTION;

Line 4708: l_bill_profile_flag := FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN');

4704: ELSE
4705: IF (l_hdr_summary_flag = 'Y') THEN --Summary flag set in contract
4706: l_bill_profile := G_SUM;
4707: ELSE -- read profile value
4708: l_bill_profile_flag := FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN');
4709: IF (l_bill_profile_flag = 'YES') THEN
4710: l_bill_profile := G_SUM;
4711: ELSE
4712: l_bill_profile := G_DET;

Line 4792: l_bill_profile_flag := FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN');

4788: ELSE
4789: IF (l_hdr_summary_flag = 'Y') THEN --Summary flag set in contract
4790: l_bill_profile := G_SUM;
4791: ELSE -- read profile value
4792: l_bill_profile_flag := FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN');
4793: IF (l_bill_profile_flag = 'YES') THEN
4794: l_bill_profile := G_SUM;
4795: ELSE
4796: l_bill_profile := G_DET;

Line 5095: IF Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N' THEN

5091: x_return_status := 'E';
5092: END IF; --IF (l_ret_stat <> 'S')
5093:
5094: /*Added for bug 14242256*/
5095: IF Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N' THEN
5096: INSERT_RA_REV_DIST( x_return_status,
5097: p_bcl_cle_id);
5098: IF (x_return_status <> 'S') THEN
5099: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');

Line 5143: IF Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N' THEN

5139: x_return_status := 'E';
5140: END IF; --IF (l_ret_stat <> 'S')
5141:
5142: /*Added for bug 14242256*/
5143: IF Nvl(fnd_profile.Value('AR_USE_INV_ACCT_FOR_CM_FLAG'),'Y') ='N' THEN
5144: INSERT_RA_REV_DIST( x_return_status,
5145: p_bcl_cle_id);
5146: IF (x_return_status <> 'S') THEN
5147: FND_FILE.PUT_LINE(FND_FILE.LOG,'OKS_ARFEEDER_PUB.Set_Reference_PB_Value => Insert INTO RA_REVENUE_DISTRIBUTIONS failed for Price Break');