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.

[Home] [Help]

APPS.MSC_X_USER_EXCEP_GEN dependencies on WF_ENGINE

Line 265: l_publisher_item_name := wf_engine.getItemAttrText(

261:
262: begin
263:
264: --we fetch the item_name from the ouput attr
265: l_publisher_item_name := wf_engine.getItemAttrText(
266: p_item_type,
267: pItemKey,
268: 'P.ITEM_NAME' );
269: l_publisher_site_name := wf_engine.getItemAttrText(

Line 269: l_publisher_site_name := wf_engine.getItemAttrText(

265: l_publisher_item_name := wf_engine.getItemAttrText(
266: p_item_type,
267: pItemKey,
268: 'P.ITEM_NAME' );
269: l_publisher_site_name := wf_engine.getItemAttrText(
270: p_item_type,
271: pItemKey,
272: 'P.PUBLISHER_SITE_NAME' );
273:

Line 405: l_sup_name := wf_engine.getItemAttrText(

401:
402: begin
403:
404: --get the supplier_name , supplier_site_name, and org.
405: l_sup_name := wf_engine.getItemAttrText(
406: p_item_type,
407: pItemKey,
408: 'P.SUPPLIER_NAME' );
409: l_sup_site_name := wf_engine.getItemAttrText(

Line 409: l_sup_site_name := wf_engine.getItemAttrText(

405: l_sup_name := wf_engine.getItemAttrText(
406: p_item_type,
407: pItemKey,
408: 'P.SUPPLIER_NAME' );
409: l_sup_site_name := wf_engine.getItemAttrText(
410: p_item_type,
411: pItemKey,
412: 'P.SUPPLIER_SITE_NAME' );
413:

Line 414: l_publisher_site_name := wf_engine.getItemAttrText(

410: p_item_type,
411: pItemKey,
412: 'P.SUPPLIER_SITE_NAME' );
413:
414: l_publisher_site_name := wf_engine.getItemAttrText(
415: p_item_type,
416: pItemKey,
417: 'P.PUBLISHER_SITE_NAME' );
418:

Line 1944: saveThreshold := WF_ENGINE.threshold;

1940: columnNtfTableHeader := null;
1941: columnNtfRowValue := null;
1942: vNtfBodyText := null;
1943:
1944: saveThreshold := WF_ENGINE.threshold;
1945:
1946: If v_NumRows <> 0 Then
1947:
1948: For rowCounter in 1..v_NumRows

Line 1962: --WF_ENGINE.threshold := -1;

1958: l_item_key := to_char( v_EXCEPTION_DETAIL_ID(rowCounter));
1959: v_notificationTitle := v_notification_text;
1960:
1961:
1962: --WF_ENGINE.threshold := -1;
1963:
1964: if v_debug and
1965: vFirstRow then
1966: log_message('Before creating workflow = '||v_item_type);

Line 1970: wf_engine.CreateProcess( itemtype => v_item_type,

1966: log_message('Before creating workflow = '||v_item_type);
1967: log_message('Workflow item_key = '||l_item_key);
1968: end if;
1969:
1970: wf_engine.CreateProcess( itemtype => v_item_type,
1971: itemkey => l_item_key,
1972: process => v_wf_process );
1973:
1974: if v_debug and

Line 1980: wf_engine.SetItemOwner( itemtype => v_item_type,

1976: log_message('After creating workflow = '||v_item_type);
1977: end if;
1978: -- Set the process owner to user who defined this exception
1979:
1980: wf_engine.SetItemOwner( itemtype => v_item_type,
1981: itemkey => l_item_key,
1982: owner => v_created_by_name );
1983:
1984:

Line 2053: wf_engine.SetItemAttrText ( itemtype => v_item_type,

2049: ' '||
2050: ''||columnNtfTableHeader||''||
2051: ''||columnNtfRowValue||'';
2052:
2053: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2054: itemkey => l_item_key,
2055: aname => 'NOTIFICATION_TITLE' ,
2056: avalue => v_notificationTitle );
2057:
Line 2058: wf_engine.SetItemAttrText ( itemtype => v_item_type,

2054: itemkey => l_item_key,
2055: aname => 'NOTIFICATION_TITLE' ,
2056: avalue => v_notificationTitle );
2057:
2058: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2059: itemkey => l_item_key,
2060: aname => 'NTF_BODY' ,
2061: avalue => vNtfBodyText );
2062: if v_debug and

Line 2069: wf_engine.SetItemAttrText ( itemtype => v_item_type,

2065: --log_message('notificationText='||vNtfBodyText);
2066: dumpstmt('notificationText='||vNtfBodyText);
2067: end if;
2068:
2069: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2070: itemkey => l_item_key,
2071: aname => 'EXCEPTION_TYPE_NAME' ,
2072: avalue => v_exception_name );
2073:

Line 2075: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,

2071: aname => 'EXCEPTION_TYPE_NAME' ,
2072: avalue => v_exception_name );
2073:
2074:
2075: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2076: itemkey => l_item_key,
2077: aname => 'EXCEPTION_TYPE' ,
2078: avalue => v_exception_id );
2079:

Line 2080: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,

2076: itemkey => l_item_key,
2077: aname => 'EXCEPTION_TYPE' ,
2078: avalue => v_exception_id );
2079:
2080: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2081: itemkey => l_item_key,
2082: aname => 'EXCEPTION_EXIST' ,
2083: avalue => v_exception_exist );
2084:

Line 2085: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,

2081: itemkey => l_item_key,
2082: aname => 'EXCEPTION_EXIST' ,
2083: avalue => v_exception_exist );
2084:
2085: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2086: itemkey => l_item_key,
2087: aname => 'EXCEPTION_DETAIL_ID' ,
2088: avalue => v_EXCEPTION_DETAIL_ID(rowCounter) );
2089: details_url :=

Line 2118: wf_engine.SetItemAttrText ( itemtype => v_item_type,

2114: );
2115:
2116: details_url := details_url||'/OracleApps.RF?F='||l_Report_Run_str; */
2117: log_message('oa details_url='||details_url);
2118: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2119: itemkey => l_item_key,
2120: aname => 'DETAILS_URL',
2121: avalue => details_url );
2122:

Line 2130: wf_engine.StartProcess( itemtype => v_item_type,

2126: vFirstRow then
2127: log_message('Before starting workflow process. Key='|| l_item_key );
2128: end if;
2129:
2130: wf_engine.StartProcess( itemtype => v_item_type,
2131: itemkey => l_item_key );
2132:
2133:
2134: if v_debug and

Line 2139: WF_ENGINE.threshold := saveThreshold;

2135: vFirstRow then
2136: log_message('after starting workflow process. Key='|| l_item_key );
2137: end if;
2138:
2139: WF_ENGINE.threshold := saveThreshold;
2140:
2141: end loop; --v_NumRows
2142:
2143: end if; -- v_NumRows <> 0

Line 2218: wf_engine.SetItemAttrDate ( itemtype => v_item_type,

2214: log_message('Initializing wk flow Date attribute='||wfAttributeName ||
2215: ' Value='||to_char(l_dateValue) );
2216: end if;
2217: if AttributeTypeList(columnCounter) = 'SELECT' then
2218: wf_engine.SetItemAttrDate ( itemtype => v_item_type,
2219: itemkey => l_item_key,
2220: aname => wfAttributeName ,
2221: avalue => l_dateValue );
2222: elsif AttributeTypeList(columnCounter) = 'CALCULATION' then

Line 2223: wf_engine.AddItemAttr ( itemtype => v_item_type,

2219: itemkey => l_item_key,
2220: aname => wfAttributeName ,
2221: avalue => l_dateValue );
2222: elsif AttributeTypeList(columnCounter) = 'CALCULATION' then
2223: wf_engine.AddItemAttr ( itemtype => v_item_type,
2224: itemkey => l_item_key,
2225: aname => wfAttributeName ,
2226: date_value => l_dateValue);
2227: end if;

Line 2240: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,

2236: l_numberValue := NumberValue(numberCounter,rowCounter);
2237: l_SelValue := to_char(l_numberValue);
2238: if AttributeTypeList(columnCounter) = 'SELECT' then
2239:
2240: wf_engine.SetItemAttrNumber ( itemtype => v_item_type,
2241: itemkey => l_item_key,
2242: aname => wfAttributeName ,
2243: avalue => l_SelValue );
2244:

Line 2247: wf_engine.AddItemAttr ( itemtype => v_item_type,

2243: avalue => l_SelValue );
2244:
2245: elsif AttributeTypeList(columnCounter) = 'CALCULATION' then
2246:
2247: wf_engine.AddItemAttr ( itemtype => v_item_type,
2248: itemkey => l_item_key,
2249: aname => wfAttributeName ,
2250: number_value => l_numberValue);
2251: end if;

Line 2266: wf_engine.SetItemAttrText ( itemtype => v_item_type,

2262: ' Value='||l_varcharValue );
2263: end if;
2264: if AttributeTypeList(columnCounter) = 'SELECT' then
2265:
2266: wf_engine.SetItemAttrText ( itemtype => v_item_type,
2267: itemkey => l_item_key,
2268: aname => wfAttributeName ,
2269: avalue => l_varcharValue );
2270:

Line 2273: wf_engine.AddItemAttr ( itemtype => v_item_type,

2269: avalue => l_varcharValue );
2270:
2271: elsif AttributeTypeList(columnCounter) = 'CALCULATION' then
2272:
2273: wf_engine.AddItemAttr ( itemtype => v_item_type,
2274: itemkey => l_item_key,
2275: aname => wfAttributeName ,
2276: text_value => l_varcharValue);
2277:

Line 3005: l_exception_exist := wf_engine.getItemAttrNumber(

3001: lAdhocUser Varchar2(320);
3002:
3003: begin
3004: if ( p_funcmode = 'RUN' ) THEN
3005: l_exception_exist := wf_engine.getItemAttrNumber(
3006: p_item_type,
3007: pItemKey,
3008: 'EXCEPTION_EXIST');
3009:

Line 3153: l_publisher_item_name := wf_engine.getItemAttrText(

3149:
3150: begin
3151:
3152: --we fetch the item_name from the ouput attr
3153: l_publisher_item_name := wf_engine.getItemAttrText(
3154: p_item_type,
3155: pItemKey,
3156: 'P.ITEM_NAME' );
3157:

Line 3158: l_publisher_site_name := wf_engine.getItemAttrText(

3154: p_item_type,
3155: pItemKey,
3156: 'P.ITEM_NAME' );
3157:
3158: l_publisher_site_name := wf_engine.getItemAttrText(
3159: p_item_type,
3160: pItemKey,
3161: 'P.PUBLISHER_SITE_NAME' );
3162:

Line 3256: text_value := wf_engine.getItemAttrText(

3252: l_end_pos number;
3253: begin
3254:
3255: if command = 'GET' then
3256: text_value := wf_engine.getItemAttrText(
3257: v_item_type,
3258: context,
3259: attr_name);
3260: if v_debug then