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

Line 35: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

31:
32: ---------------------------------------------------------------------------
33: -- PROCEDURE report_all_credit_bureau
34: ---------------------------------------------------------------------------
35: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
36:
37: PROCEDURE report_all_credit_bureau(
38: errbuf OUT NOCOPY VARCHAR2,
39: retcode OUT NOCOPY NUMBER) AS

Line 71: --l_organization_id := fnd_profile.value('ORG_ID');

67: BEGIN
68: --get organization id
69: --Begin Bug#5373556 schekuri 12-Jul-2006
70: l_organization_id := mo_global.get_current_org_id;
71: --l_organization_id := fnd_profile.value('ORG_ID');
72: --End Bug#5373556 schekuri 12-Jul-2006
73:
74:
75: -- Get pending records to be processed

Line 376: l_iohv_rec.review_date := l_iohv_rec.request_date + fnd_profile.value('IEX_EA_TRANSFER_DAYS');

372:
373: /*
374: --Get number of days to transfer case to external agency
375: IF(l_iohv_rec.review_date IS NULL) THEN
376: l_iohv_rec.review_date := l_iohv_rec.request_date + fnd_profile.value('IEX_EA_TRANSFER_DAYS');
377: END IF;
378: */
379: END IF;
380:

Line 572: --l_organization_id := fnd_profile.value('ORG_ID');

568:
569: --get organization id
570: --Begin Bug#5373556 schekuri 12-Jul-2006
571: l_organization_id := mo_global.get_current_org_id;
572: --l_organization_id := fnd_profile.value('ORG_ID');
573: --End Bug#5373556 schekuri 12-Jul-2006
574:
575: -- Get pending records to be processed
576: OPEN l_oin_pend_csr(p_case_number

Line 2038: --l_organization_id := fnd_profile.value('ORG_ID');

2034:
2035: --get organization id
2036: --Begin Bug#5373556 schekuri 12-Jul-2006
2037: l_organization_id := mo_global.get_current_org_id;
2038: --l_organization_id := fnd_profile.value('ORG_ID');
2039: --End Bug#5373556 schekuri 12-Jul-2006
2040:
2041: /*
2042: l_organization_id := okl_context.get_okc_org_id;

Line 2075: l_subject := fnd_profile.value('IEX_CB_NOTIFY_CUST_EMAIL_SUBJECT');

2071:
2072: --if suject is null get subject
2073: IF (l_subject = OKC_API.G_MISS_CHAR OR
2074: l_subject IS NULL) THEN
2075: l_subject := fnd_profile.value('IEX_CB_NOTIFY_CUST_EMAIL_SUBJECT');
2076: END IF;
2077: --dbms_output.put_line('l_subject : ' || l_subject);
2078:
2079: --if content_id is null get content_id

Line 2082: l_content_id := to_number(fnd_profile.value('IEX_CB_NOTIFY_CUST_TEMPLATE'));

2078:
2079: --if content_id is null get content_id
2080: IF (l_content_id = OKC_API.G_MISS_NUM OR
2081: l_content_id IS NULL) THEN
2082: l_content_id := to_number(fnd_profile.value('IEX_CB_NOTIFY_CUST_TEMPLATE'));
2083: END IF;
2084: --dbms_output.put_line('l_content_id : ' || l_content_id);
2085:
2086: --if from is null get subject

Line 2089: l_from := fnd_profile.value('IEX_CB_NOTIFY_CUST_EMAIL_FROM');

2085:
2086: --if from is null get subject
2087: IF (l_from = OKC_API.G_MISS_CHAR OR
2088: l_from IS NULL) THEN
2089: l_from := fnd_profile.value('IEX_CB_NOTIFY_CUST_EMAIL_FROM');
2090: END IF;
2091: --dbms_output.put_line('l_from : ' || l_from);
2092:
2093:

Line 2195: l_start_date := sysdate + to_number(fnd_profile.value('IEX_CB_NOTIFY_GRACE_DAYS'));

2191: l_rows_processed := l_rows_processed + 1;
2192:
2193: l_task_name := 'Oracle Collections Review Contract';
2194: l_description := 'Oracle Collections Review contract for reporting to credit bureau';
2195: l_start_date := sysdate + to_number(fnd_profile.value('IEX_CB_NOTIFY_GRACE_DAYS'));
2196: create_followup(p_api_version => l_api_version,
2197: p_init_msg_list => okl_api.G_TRUE,
2198: p_oinv_rec => l_oinv_rec,
2199: p_iohv_rec => l_iohv_rec,

Line 2318: --l_organization_id := fnd_profile.value('ORG_ID');

2314: BEGIN
2315: --get organization id
2316: --Begin Bug#5373556 schekuri 12-Jul-2006
2317: l_organization_id := mo_global.get_current_org_id;
2318: --l_organization_id := fnd_profile.value('ORG_ID');
2319: --End Bug#5373556 schekuri 12-Jul-2006
2320:
2321: --check if case number is passed
2322: IF (p_case_number = OKC_API.G_MISS_CHAR OR

Line 2335: --l_extend_days := fnd_profile.value('IEX_EA_RECALL_GRACE_DAYS');

2331: l_ext_agncy_passed := Okc_Api.G_FALSE;
2332: --dbms_output.put_line('ext_agncy is not passed');
2333: END IF;
2334:
2335: --l_extend_days := fnd_profile.value('IEX_EA_RECALL_GRACE_DAYS');
2336:
2337: OPEN l_recall_csr(p_case_number
2338: ,p_ext_agncy_id
2339: ,l_organization_id);

Line 2626: --l_organization_id := fnd_profile.value('ORG_ID');

2622:
2623: --get organization id
2624: --Begin Bug#5373556 schekuri 12-Jul-2006
2625: l_organization_id := mo_global.get_current_org_id;
2626: --l_organization_id := fnd_profile.value('ORG_ID');
2627: --End Bug#5373556 schekuri 12-Jul-2006
2628:
2629: /*
2630: l_organization_id := okl_context.get_okc_org_id;

Line 2666: l_subject := fnd_profile.value('IEX_EA_NOTIFY_VENDOR_EMAIL_SUBJECT');

2662:
2663: --if suject is null get subject
2664: IF (l_subject = OKC_API.G_MISS_CHAR OR
2665: l_subject IS NULL) THEN
2666: l_subject := fnd_profile.value('IEX_EA_NOTIFY_VENDOR_EMAIL_SUBJECT');
2667: END IF;
2668: --dbms_output.put_line('l_subject : ' || l_subject);
2669:
2670: --if content_id is null get content_id

Line 2673: l_content_id := to_number(fnd_profile.value('IEX_EA_NOTIFY_VENDOR_TEMPLATE'));

2669:
2670: --if content_id is null get content_id
2671: IF (l_content_id = OKC_API.G_MISS_NUM OR
2672: l_content_id IS NULL) THEN
2673: l_content_id := to_number(fnd_profile.value('IEX_EA_NOTIFY_VENDOR_TEMPLATE'));
2674: END IF;
2675: --dbms_output.put_line('l_content_id : ' || l_content_id);
2676:
2677: --if from is null get subject

Line 2680: l_from := fnd_profile.value('IEX_EA_NOTIFY_VENDOR_EMAIL_FROM');

2676:
2677: --if from is null get subject
2678: IF (l_from = OKC_API.G_MISS_CHAR OR
2679: l_from IS NULL) THEN
2680: l_from := fnd_profile.value('IEX_EA_NOTIFY_VENDOR_EMAIL_FROM');
2681: END IF;
2682: --dbms_output.put_line('l_from : ' || l_from);
2683:
2684:

Line 2856: --l_organization_id := fnd_profile.value('ORG_ID');

2852: BEGIN
2853: --get organization id
2854: --Begin Bug#5373556 schekuri 12-Jul-2006
2855: l_organization_id := mo_global.get_current_org_id;
2856: --l_organization_id := fnd_profile.value('ORG_ID');
2857: --End Bug#5373556 schekuri 12-Jul-2006
2858:
2859: --check if case number is passed
2860: IF (p_case_number = OKC_API.G_MISS_CHAR OR

Line 3091: l_score_id := to_number(fnd_profile.value('IEX_EA_SCORE_ID'));

3087: l_oinv_rec := p_oinv_rec;
3088: l_iohv_rec := p_iohv_rec;
3089:
3090: --get score engine to score cases
3091: l_score_id := to_number(fnd_profile.value('IEX_EA_SCORE_ID'));
3092: --DBMS_OUTPUT.PUT_LINE('Score Engine Id : ' || l_score_id);
3093:
3094: --get score if a case has been previously scored on the same day
3095: FOR cur_score IN l_score_csr(l_oinv_rec.cas_id

Line 3197: l_score_id := to_number(fnd_profile.value('IEX_EA_SCORE_ID'));

3193: l_oinv_rec := p_oinv_rec;
3194: l_iohv_rec := p_iohv_rec;
3195:
3196: --get score engine to score cases
3197: l_score_id := to_number(fnd_profile.value('IEX_EA_SCORE_ID'));
3198:
3199: --get score of the case when assigned to externalagency previously
3200: FOR cur_score IN l_score_csr(l_oinv_rec.cas_id
3201: ,l_score_id

Line 3213: IF ((nvl(l_score_value,0) - nvl(l_score_value_previous,0)) >= to_number(fnd_profile.value('IEX_EA_SCORE_DIFF_FOR_RECALL'))) THEN

3209: P_OBJECT_ID => l_oinv_rec.cas_id,
3210: P_OBJECT_TYPE => 'IEX_CASES',
3211: P_SCORE_ID => l_score_id);
3212:
3213: IF ((nvl(l_score_value,0) - nvl(l_score_value_previous,0)) >= to_number(fnd_profile.value('IEX_EA_SCORE_DIFF_FOR_RECALL'))) THEN
3214: l_recall := Okc_Api.G_FALSE;
3215: END IF;
3216:
3217: x_recall := l_recall;

Line 3270: l_score_id := to_number(fnd_profile.value('IEX_EA_SCORE_ID'));

3266: l_oinv_rec := p_oinv_rec;
3267: l_iohv_rec := p_iohv_rec;
3268:
3269: --get score engine to score cases
3270: l_score_id := to_number(fnd_profile.value('IEX_EA_SCORE_ID'));
3271:
3272: --get score of the case when assigned to externalagency previously
3273: FOR cur_score IN l_score_csr(l_oinv_rec.cas_id
3274: ,l_score_id