DBA Data[Home] [Help]

APPS.OE_ERROR_WF dependencies on FND_PROFILE

Line 470: l_profile_val := FND_PROFILE.VALUE('ONT_GENERATE_DIAGNOSTICS');

466: l_result_code := 'BYPASS_REQUEST';
467: -- We use a different message for blankets.
468: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG_NO_URL');
469: ELSE
470: l_profile_val := FND_PROFILE.VALUE('ONT_GENERATE_DIAGNOSTICS');
471: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' AND G_BATCH_RETRY_FLAG = 'N' THEN
472: l_result_code := 'SUBMIT_REQUEST';
473: ELSE
474: l_result_code := 'BYPASS_REQUEST';

Line 572: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;

568: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
569: l_header_id);
570:
571: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110506' THEN
572: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;
573: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);
574: END IF;
575:
576:

Line 689: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;

685: -- l_descriptor_line2);
686:
687: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
688: l_header_id);
689: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;
690: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);
691: resultout := 'COMPLETE:' || l_result_code;
692: return;
693:

Line 808: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;

804: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
805: -- l_descriptor_line2);
806:
807: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110506' THEN
808: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;
809: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);
810: END IF;
811: else -- l_header_id is null so don't submit the concurrent request
812: l_result_code := 'BYPASS_REQUEST';

Line 1102: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

1098: if p_itemtype = 'OESO' then
1099: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');
1100: else
1101: -- try to derive header id for OEOA and OEOI
1102: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
1103: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
1104:
1105: Begin
1106: Select header_id