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_BILLING_PUB dependencies on FND_PROFILE

Line 106: l_negative_yn := NVL(FND_PROFILE.VALUE('OKS_NEGATIVE_BILLING_YN'),'NO');

102:
103: BEGIN
104:
105: X_return_status := 'S';
106: l_negative_yn := NVL(FND_PROFILE.VALUE('OKS_NEGATIVE_BILLING_YN'),'NO');
107: FOR l_ptr in 1..p_cov_tbl.count
108: LOOP
109: OPEN l_bill_qty_csr(p_cov_tbl(l_ptr).id);
110: FETCH l_bill_qty_csr into l_bill_qty_rec;

Line 353: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN

349: ELSE
350: IF (p_summary_yn = 'Y') THEN
351: l_processed_lines_tbl(l_pr_tbl_idx).Summary_bill_YN := 'Y';
352: ELSE
353: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN
354: l_processed_lines_tbl(l_pr_tbl_idx).Summary_bill_YN := 'Y';
355: ELSE
356: l_processed_lines_tbl(l_pr_tbl_idx).Summary_bill_YN := 'N';
357: END IF;

Line 412: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN

408: ELSE
409: IF (p_summary_yn = 'Y') THEN
410: l_processed_sub_lines_tbl(l_prs_tbl_idx).Summary_bill_YN := 'Y';
411: ELSE
412: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN
413: l_processed_sub_lines_tbl(l_prs_tbl_idx).Summary_bill_YN := 'Y';
414: ELSE
415: l_processed_sub_lines_tbl(l_prs_tbl_idx).Summary_bill_YN := 'N';
416: END IF;

Line 1362: If (l_line_rec.usage_qty <>0 OR ( l_line_rec.usage_qty=0 AND nvl(FND_PROFILE.VALUE('OKS_USAGE_SKIP_QP_CALL_ZERO_QTY'),'N') = 'N')) THEN

1358: X_MSG_DATA => l_msg_data
1359: );
1360: */
1361:
1362: If (l_line_rec.usage_qty <>0 OR ( l_line_rec.usage_qty=0 AND nvl(FND_PROFILE.VALUE('OKS_USAGE_SKIP_QP_CALL_ZERO_QTY'),'N') = 'N')) THEN
1363: Begin
1364: --skuchima Ceredian ER call the procedure to insert data into temp table
1365: Insert_usg_qp_dtls_prc(
1366: l_line_rec,

Line 4370: If (l_line_rec.usage_qty <>0 OR ( l_line_rec.usage_qty=0 AND nvl(FND_PROFILE.VALUE('OKS_USAGE_SKIP_QP_CALL_ZERO_QTY'),'N') = 'N')) THEN

4366: l_line_rec.price_list_line_id
4367: :=nvl(bsl_price_rec.locked_price_list_line_id,l_locked_price_list_line_id);
4368:
4369: /*Ceredian ER 13105205 */
4370: If (l_line_rec.usage_qty <>0 OR ( l_line_rec.usage_qty=0 AND nvl(FND_PROFILE.VALUE('OKS_USAGE_SKIP_QP_CALL_ZERO_QTY'),'N') = 'N')) THEN
4371: /*Pricing API to calculate amount */
4372: OKS_QP_PKG.CALC_PRICE
4373: (
4374: P_DETAIL_REC => l_line_rec,

Line 4694: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN

4690:
4691: IF (p_summary_yn = 'Y') THEN
4692: l_summary_yn := 'Y';
4693: ELSE
4694: IF ( FND_PROFILE.VALUE('OKS_AR_TRANSACTIONS_SUBMIT_SUMMARY_YN') = 'YES') THEN
4695: l_summary_yn := 'Y';
4696: ELSE
4697: l_summary_yn := 'N';
4698: END IF;

Line 5533: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');

5529: X_return_status := 'S';
5530:
5531: --mchoudha Fix for bug#4198616
5532: --initializing the variables in case of parallel workers
5533: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
5534: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => OKS: Billing Report And Log is set to '||l_yes_no);
5535:
5536: --Ceredian ER
5537: l_bulk_usage := FND_PROFILE.VALUE('OKS_USAGE_BILL_QP_BULK_CALL');

Line 5537: l_bulk_usage := FND_PROFILE.VALUE('OKS_USAGE_BILL_QP_BULK_CALL');

5533: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
5534: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => OKS: Billing Report And Log is set to '||l_yes_no);
5535:
5536: --Ceredian ER
5537: l_bulk_usage := FND_PROFILE.VALUE('OKS_USAGE_BILL_QP_BULK_CALL');
5538:
5539: If l_write_log then
5540: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill processing starts ');
5541: FND_FILE.PUT_LINE( FND_FILE.LOG, 'OKS_BILLING_PUB.Calculate_bill => OKS_USAGE_BILL_QP_BULK_CALL is set to '||l_bulk_usage);

Line 6132: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');

6128: BEGIN
6129:
6130: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main Starts');
6131:
6132: l_yes_no := Fnd_profile.value('OKS_BILLING_REPORT_AND_LOG');
6133:
6134: FND_FILE.PUT_LINE( FND_FILE.LOG,'OKS_BILLING_PUB.Billing_Main => OKS: Billing Report And Log is set to '||l_yes_no);
6135:
6136: If l_yes_no = 'YES' then

Line 6147: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN

6143:
6144: l_org_id := p_org_id;
6145:
6146: --mchoudha fixed bug#4729936
6147: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
6148: -- l_org_id := fnd_profile.value('ORG_ID');
6149: If l_write_log then
6150: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => parameter Org ID is '||l_org_id);
6151: End If;

Line 6148: -- l_org_id := fnd_profile.value('ORG_ID');

6144: l_org_id := p_org_id;
6145:
6146: --mchoudha fixed bug#4729936
6147: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
6148: -- l_org_id := fnd_profile.value('ORG_ID');
6149: If l_write_log then
6150: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => parameter Org ID is '||l_org_id);
6151: End If;
6152: -- END IF;

Line 6817: l_subrequests := nvl(FND_PROFILE.VALUE('OKS_NO_CHILD_REQUESTS_MAIN_BILLING'),30);

6813:
6814: END IF;
6815:
6816: /* As part of bug13105205 removed the hardcoded value to l_subrequests and assigning the value from profile skuchima*/
6817: l_subrequests := nvl(FND_PROFILE.VALUE('OKS_NO_CHILD_REQUESTS_MAIN_BILLING'),30);
6818:
6819: If l_write_log then
6820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Profile option OKS: Number of Child Requests for Service Contracts Main Billing '||l_subrequests);
6821: End If;

Line 6826: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES') THEN

6822:
6823:
6824: IF (p_contract_hdr_id is null) AND -- not a specific contract
6825: (FND_CONC_GLOBAL.request_data is null) AND -- not a restart of parent
6826: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES') THEN
6827:
6828: -- l_line_no represent total records to be processed here
6829: If l_write_log then
6830: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Profile option OKS: Parallel Worker is set to YES');

Line 6887: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES')) THEN

6883: return; -- parent exits and waits for children to finish before restart
6884: END IF; -- l_agg_rec.total
6885:
6886: ELSIF ((FND_CONC_GLOBAL.request_data is not null ) AND
6887: (nvl(FND_PROFILE.VALUE('OKS_PARALLEL_WORKER'),'NO') = 'YES')) THEN
6888: -- restart detected (sub-requests finished)...cleanup and exit.
6889: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OKS_BILLING_PUB.Billing_Main => Commiting here');
6890: COMMIT;
6891:

Line 7078: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN

7074:
7075: l_org_id := p_org_id;
7076:
7077: --mchoudha fixed bug#4729936
7078: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
7079: -- l_org_id := fnd_profile.value('ORG_ID');
7080: --END IF;
7081:
7082: --Bug # 4928184 19-JAN-2006 maanand

Line 7079: -- l_org_id := fnd_profile.value('ORG_ID');

7075: l_org_id := p_org_id;
7076:
7077: --mchoudha fixed bug#4729936
7078: --IF (nvl(fnd_profile.value('OKC_VIEW_K_BY_ORG'),'N') = 'Y' ) THEN
7079: -- l_org_id := fnd_profile.value('ORG_ID');
7080: --END IF;
7081:
7082: --Bug # 4928184 19-JAN-2006 maanand
7083: