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.XNB_CMN_PVT dependencies on WF_EVENT

Line 1216: wf_event.AddParameterToList(p_name =>'SALES_ORDER_ID',p_value => l_line_id,p_parameterlist => l_parameter_list);

1212:
1213: SELECT org_id into l_org_id from oe_order_lines_all
1214: WHERE line_id = l_line_id;
1215:
1216: wf_event.AddParameterToList(p_name =>'SALES_ORDER_ID',p_value => l_line_id,p_parameterlist => l_parameter_list);
1217: wf_event.AddParameterToList(p_name =>'SALE_ORG_ID',p_value => l_org_id,p_parameterlist => l_parameter_list);
1218:
1219: wf_event.raise( p_event_name => 'oracle.apps.xnb.salesorder.create',
1220: p_event_key => l_key,

Line 1217: wf_event.AddParameterToList(p_name =>'SALE_ORG_ID',p_value => l_org_id,p_parameterlist => l_parameter_list);

1213: SELECT org_id into l_org_id from oe_order_lines_all
1214: WHERE line_id = l_line_id;
1215:
1216: wf_event.AddParameterToList(p_name =>'SALES_ORDER_ID',p_value => l_line_id,p_parameterlist => l_parameter_list);
1217: wf_event.AddParameterToList(p_name =>'SALE_ORG_ID',p_value => l_org_id,p_parameterlist => l_parameter_list);
1218:
1219: wf_event.raise( p_event_name => 'oracle.apps.xnb.salesorder.create',
1220: p_event_key => l_key,
1221: p_parameters => l_parameter_list);

Line 1219: wf_event.raise( p_event_name => 'oracle.apps.xnb.salesorder.create',

1215:
1216: wf_event.AddParameterToList(p_name =>'SALES_ORDER_ID',p_value => l_line_id,p_parameterlist => l_parameter_list);
1217: wf_event.AddParameterToList(p_name =>'SALE_ORG_ID',p_value => l_org_id,p_parameterlist => l_parameter_list);
1218:
1219: wf_event.raise( p_event_name => 'oracle.apps.xnb.salesorder.create',
1220: p_event_key => l_key,
1221: p_parameters => l_parameter_list);
1222:
1223:

Line 1304: wf_event.AddParameterToList(p_name =>'ACCOUNT_NUMBER',p_value => l_account_number,p_parameterlist =>l_parameter_list);

1300: WHILE (l_accounts%FOUND) LOOP
1301:
1302: l_key := 'XNB:'||'ACCOUNT:'||l_account_number||':'||to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1303:
1304: wf_event.AddParameterToList(p_name =>'ACCOUNT_NUMBER',p_value => l_account_number,p_parameterlist =>l_parameter_list);
1305: wf_event.AddParameterToList(p_name =>'ACCT_ORG_ID',p_value => l_org_id ,p_parameterlist => l_parameter_list);
1306:
1307: --------------------------------------------------------------------------------
1308: -- Raise the event to publish the account number with the necessary parameters

Line 1305: wf_event.AddParameterToList(p_name =>'ACCT_ORG_ID',p_value => l_org_id ,p_parameterlist => l_parameter_list);

1301:
1302: l_key := 'XNB:'||'ACCOUNT:'||l_account_number||':'||to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1303:
1304: wf_event.AddParameterToList(p_name =>'ACCOUNT_NUMBER',p_value => l_account_number,p_parameterlist =>l_parameter_list);
1305: wf_event.AddParameterToList(p_name =>'ACCT_ORG_ID',p_value => l_org_id ,p_parameterlist => l_parameter_list);
1306:
1307: --------------------------------------------------------------------------------
1308: -- Raise the event to publish the account number with the necessary parameters
1309: --

Line 1313: wf_event.raise( p_event_name => 'oracle.apps.xnb.account.create',

1309: --
1310: --------------------------------------------------------------------------------
1311:
1312:
1313: wf_event.raise( p_event_name => 'oracle.apps.xnb.account.create',
1314: p_event_key => l_key,
1315: p_parameters => l_parameter_list);
1316:
1317: FETCH l_accounts into l_account_number;

Line 1339: p_event IN OUT NOCOPY WF_EVENT_T

1335: END publish_account_info;
1336:
1337: Function check_subscribed_events(
1338: p_subscription_guid IN RAW,
1339: p_event IN OUT NOCOPY WF_EVENT_T
1340: )
1341: return VARCHAR2
1342: AS
1343:

Line 1400: p_event IN OUT NOCOPY WF_EVENT_T)

1396:
1397: END check_subscribed_events;
1398:
1399: PROCEDURE publish_account_update(l_event_name IN VARCHAR2,
1400: p_event IN OUT NOCOPY WF_EVENT_T)
1401: AS
1402:
1403: l_param_value VARCHAR2(60);
1404: l_rel_cust_acct_id VARCHAR2(60);

Line 1464: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1460: EXCEPTION
1461:
1462: WHEN NO_DATA_FOUND THEN
1463: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1464: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1465: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAccount.update');
1466: RAISE;
1467: END;
1468:

Line 1496: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1492: EXCEPTION
1493:
1494: WHEN NO_DATA_FOUND THEN
1495: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1496: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1497: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR BillingPreference');
1498: RAISE;
1499: END;
1500:

Line 1531: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1527: EXCEPTION
1528:
1529: WHEN NO_DATA_FOUND THEN
1530: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1531: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1532: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAcctRelate');
1533: RAISE;
1534: END;
1535:

Line 1562: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1558: EXCEPTION
1559:
1560: WHEN NO_DATA_FOUND THEN
1561: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1562: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1563: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAcctSiteUse');
1564: RAISE;
1565: END;
1566:

Line 1593: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1589: EXCEPTION
1590:
1591: WHEN NO_DATA_FOUND THEN
1592: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1593: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1594: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAcctSiteUse.create');
1595: RAISE;
1596: END;
1597:

Line 1629: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1625: EXCEPTION
1626:
1627: WHEN NO_DATA_FOUND THEN
1628: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1629: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1630: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAcctSiteUse.update');
1631: RAISE;
1632: END;
1633:

Line 1669: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1665: EXCEPTION
1666:
1667: WHEN NO_DATA_FOUND THEN
1668: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1669: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1670: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustProfileAmt');
1671: RAISE;
1672: END;
1673:

Line 1702: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1698: EXCEPTION
1699:
1700: WHEN NO_DATA_FOUND THEN
1701: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1702: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1703: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR Party Update');
1704: RAISE;
1705:
1706: WHEN OTHERS THEN

Line 1748: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1744: EXCEPTION
1745:
1746: WHEN NO_DATA_FOUND THEN
1747: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1748: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1749: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','Check the Cust_Account_Id for the Updated Customer Profile');
1750: RAISE;
1751:
1752: WHEN OTHERS THEN

Line 1783: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1779: EXCEPTION
1780:
1781: WHEN NO_DATA_FOUND THEN
1782: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1783: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1784: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','Check the Owner Table Name in HZ_CONTACT_POINTS');
1785: RAISE;
1786:
1787: WHEN OTHERS THEN

Line 1811: WF_EVENT.setErrorInfo(p_event, 'ERROR');

1807: EXCEPTION
1808:
1809: WHEN NO_DATA_FOUND THEN
1810: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1811: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1812: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR Contact Point Update');
1813: RAISE;
1814:
1815: WHEN OTHERS THEN

Line 1867: wf_event.AddParameterToList( p_name =>'ACCOUNT_NUMBER',

1863: ------------------------------------------------------------------------------------
1864:
1865: l_key := 'XNB:'||'ACCOUNT:'||p_account_number||':'||to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS');
1866:
1867: wf_event.AddParameterToList( p_name =>'ACCOUNT_NUMBER',
1868: p_value => p_account_number,
1869: p_parameterlist => l_parameter_list);
1870:
1871: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','Org_id before Raising Event'||p_org_id);

Line 1873: wf_event.AddParameterToList( p_name =>'ACCT_ORG_ID',

1869: p_parameterlist => l_parameter_list);
1870:
1871: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','Org_id before Raising Event'||p_org_id);
1872:
1873: wf_event.AddParameterToList( p_name =>'ACCT_ORG_ID',
1874: p_value => p_org_id,
1875: p_parameterlist => l_parameter_list);
1876:
1877: wf_event.AddParameterToList( p_name =>'PARAMETER3',

Line 1877: wf_event.AddParameterToList( p_name =>'PARAMETER3',

1873: wf_event.AddParameterToList( p_name =>'ACCT_ORG_ID',
1874: p_value => p_org_id,
1875: p_parameterlist => l_parameter_list);
1876:
1877: wf_event.AddParameterToList( p_name =>'PARAMETER3',
1878: p_value => p_event_name,
1879: p_parameterlist => l_parameter_list);
1880:
1881: wf_event.AddParameterToList( p_name =>'ECX_PARAMETER4',

Line 1881: wf_event.AddParameterToList( p_name =>'ECX_PARAMETER4',

1877: wf_event.AddParameterToList( p_name =>'PARAMETER3',
1878: p_value => p_event_name,
1879: p_parameterlist => l_parameter_list);
1880:
1881: wf_event.AddParameterToList( p_name =>'ECX_PARAMETER4',
1882: p_value => p_param_value,
1883: p_parameterlist => l_parameter_list);
1884:
1885: wf_event.raise( p_event_name => 'oracle.apps.xnb.account.update',

Line 1885: wf_event.raise( p_event_name => 'oracle.apps.xnb.account.update',

1881: wf_event.AddParameterToList( p_name =>'ECX_PARAMETER4',
1882: p_value => p_param_value,
1883: p_parameterlist => l_parameter_list);
1884:
1885: wf_event.raise( p_event_name => 'oracle.apps.xnb.account.update',
1886: p_event_key => l_key,
1887: p_parameters => l_parameter_list);
1888:
1889:

Line 2105: wf_event.AddParameterToList(p_name =>'ORDER_NUMBER', p_value => l_order_number, p_parameterlist =>l_parameter_list);

2101: ANAME => 'ORG_ID');
2102:
2103:
2104: l_key := 'XNB:'||'GRPSALESORDER:'||l_order_number;
2105: wf_event.AddParameterToList(p_name =>'ORDER_NUMBER', p_value => l_order_number, p_parameterlist =>l_parameter_list);
2106: wf_event.AddParameterToList(p_name =>'SALE_ORG_ID',p_value => l_org_id,p_parameterlist => l_parameter_list);
2107:
2108: --------------------------------------------------------------------------------
2109: -- Raise the event to publish the grouped salesorder with the necessary parameters

Line 2106: wf_event.AddParameterToList(p_name =>'SALE_ORG_ID',p_value => l_org_id,p_parameterlist => l_parameter_list);

2102:
2103:
2104: l_key := 'XNB:'||'GRPSALESORDER:'||l_order_number;
2105: wf_event.AddParameterToList(p_name =>'ORDER_NUMBER', p_value => l_order_number, p_parameterlist =>l_parameter_list);
2106: wf_event.AddParameterToList(p_name =>'SALE_ORG_ID',p_value => l_org_id,p_parameterlist => l_parameter_list);
2107:
2108: --------------------------------------------------------------------------------
2109: -- Raise the event to publish the grouped salesorder with the necessary parameters
2110: --

Line 2113: wf_event.raise( p_event_name => 'oracle.apps.xnb.groupedsalesorder.create',

2109: -- Raise the event to publish the grouped salesorder with the necessary parameters
2110: --
2111: --------------------------------------------------------------------------------
2112:
2113: wf_event.raise( p_event_name => 'oracle.apps.xnb.groupedsalesorder.create',
2114: p_event_key => l_key,
2115: p_parameters => l_parameter_list);
2116: END IF;
2117: