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 XNB_CMN_PVT

Line 1: PACKAGE BODY XNB_CMN_PVT AS

1: PACKAGE BODY XNB_CMN_PVT AS
2: /* $Header: XNBVCMNB.pls 120.18 2006/11/20 05:40:50 pselvam noship $ */
3:
4: --Private Constants defined for this package.
5: --g_party_type: The XML Gateway Trading Partner Type is assumed to be 'C'-Customer here

Line 1357: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','Subscription has Triggered');

1353: WHERE entity_type = 'ACCOUNT_UPDATE';
1354:
1355: BEGIN
1356:
1357: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','Subscription has Triggered');
1358: l_event_name := p_event.geteventname();
1359: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS',l_event_name);
1360:
1361: OPEN l_sub_events;

Line 1359: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS',l_event_name);

1355: BEGIN
1356:
1357: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','Subscription has Triggered');
1358: l_event_name := p_event.geteventname();
1359: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS',l_event_name);
1360:
1361: OPEN l_sub_events;
1362: FETCH l_sub_events INTO l_subscribed_event;
1363:

Line 1364: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','AFTER FETCH');

1360:
1361: OPEN l_sub_events;
1362: FETCH l_sub_events INTO l_subscribed_event;
1363:
1364: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','AFTER FETCH');
1365:
1366: WHILE (l_sub_events%FOUND) LOOP
1367: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','INSIDE WHILE');
1368:

Line 1367: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','INSIDE WHILE');

1363:
1364: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','AFTER FETCH');
1365:
1366: WHILE (l_sub_events%FOUND) LOOP
1367: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','INSIDE WHILE');
1368:
1369: IF (l_subscribed_event = l_event_name) THEN
1370: publish_account_update(l_event_name, p_event);
1371: x_result := 'SUCCESS';

Line 1373: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','Successfully CHECKED x_result'||x_result);

1369: IF (l_subscribed_event = l_event_name) THEN
1370: publish_account_update(l_event_name, p_event);
1371: x_result := 'SUCCESS';
1372: CLOSE l_sub_events;
1373: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','Successfully CHECKED x_result'||x_result);
1374: RETURN x_result;
1375: END IF;
1376:
1377: FETCH l_sub_events INTO l_subscribed_event;

Line 1382: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','After Cursor Close,'||x_result);

1378: END LOOP;
1379:
1380: CLOSE l_sub_events;
1381: x_result := 'SUCCESS';
1382: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS','After Cursor Close,'||x_result);
1383: RETURN x_result;
1384:
1385: EXCEPTION
1386:

Line 1392: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS',l_err_name||' : '||l_err_message);

1388: wf_core.GET_ERROR (err_name => l_err_name,
1389: err_message => l_err_message,
1390: err_stack => l_err_stack,
1391: maxErrStackLength => 900);
1392: XNB_DEBUG.log('XNB_CMN_PVT.CHECK_SUBSCRIBED_EVENTS',l_err_name||' : '||l_err_message);
1393: CLOSE l_sub_events;
1394: x_result := 'ERROR';
1395: RETURN x_result;
1396:

Line 1463: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1459:
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;

Line 1465: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAccount.update');

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:
1469: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

Line 1495: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1491:
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;

Line 1497: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR BillingPreference');

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:
1501: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

Line 1530: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1526:
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;

Line 1532: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAcctRelate');

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:
1536: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

Line 1561: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1557:
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;

Line 1563: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAcctSiteUse');

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:
1567: IF l_event_name = 'oracle.apps.ar.hz.CustAcctSiteUse.create' THEN

Line 1592: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1588:
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;

Line 1594: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAcctSiteUse.create');

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:
1598: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

Line 1628: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1624:
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;

Line 1630: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustAcctSiteUse.update');

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:
1634: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

Line 1668: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1664:
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;

Line 1670: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR CustProfileAmt');

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:
1674: IF l_site_use_id IS NULL THEN--ST1 BUG Fix 5221801 - Cust Profile and Profile Amts

Line 1676: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR CustProfileAmt_'||l_num);

1672: END;
1673:
1674: IF l_site_use_id IS NULL THEN--ST1 BUG Fix 5221801 - Cust Profile and Profile Amts
1675: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');
1676: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR CustProfileAmt_'||l_num);
1677:
1678: IF l_num = 1 THEN
1679: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1680: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR CustProfileAmt');

Line 1680: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR CustProfileAmt');

1676: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR CustProfileAmt_'||l_num);
1677:
1678: IF l_num = 1 THEN
1679: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1680: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR CustProfileAmt');
1681: END IF;
1682: END IF;
1683:
1684: /* R12 Introduction of 4 new events : ksrikant*/

Line 1701: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1697:
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:

Line 1703: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR Party Update');

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
1707: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

Line 1707: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

1703: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR Party Update');
1704: RAISE;
1705:
1706: WHEN OTHERS THEN
1707: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);
1708:
1709: END;
1710:
1711: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Before FOR Loop of Party');

Line 1711: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Before FOR Loop of Party');

1707: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);
1708:
1709: END;
1710:
1711: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Before FOR Loop of Party');
1712:
1713: FOR i IN 1..l_acc_num.COUNT LOOP
1714:
1715: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Inside FOR Loop of Party');

Line 1715: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Inside FOR Loop of Party');

1711: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Before FOR Loop of Party');
1712:
1713: FOR i IN 1..l_acc_num.COUNT LOOP
1714:
1715: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Inside FOR Loop of Party');
1716: l_num := xnb_util_pvt.check_collaboration_doc_status (l_acc_num(i), 'XNB_ACCOUNT');
1717: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Party_'||l_acc_num(i)||'_'||l_num);
1718:
1719: IF l_num = 1 THEN

Line 1717: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Party_'||l_acc_num(i)||'_'||l_num);

1713: FOR i IN 1..l_acc_num.COUNT LOOP
1714:
1715: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Inside FOR Loop of Party');
1716: l_num := xnb_util_pvt.check_collaboration_doc_status (l_acc_num(i), 'XNB_ACCOUNT');
1717: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Party_'||l_acc_num(i)||'_'||l_num);
1718:
1719: IF l_num = 1 THEN
1720: raise_acctupdate_event(l_acc_num(i), l_org_id, l_event_name, l_param_value);
1721: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Party Account Num_'||l_acc_num(i));

Line 1721: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Party Account Num_'||l_acc_num(i));

1717: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Party_'||l_acc_num(i)||'_'||l_num);
1718:
1719: IF l_num = 1 THEN
1720: raise_acctupdate_event(l_acc_num(i), l_org_id, l_event_name, l_param_value);
1721: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Party Account Num_'||l_acc_num(i));
1722: END IF;
1723:
1724: END LOOP;
1725:

Line 1747: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1743:
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:

Line 1749: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','Check the Cust_Account_Id for the Updated Customer Profile');

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
1753: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

Line 1753: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

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
1753: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);
1754:
1755: END;
1756:
1757: IF l_site_use_id IS NULL THEN--ST1 BUG Fix 5221801 - Cust Profile and Profile Amts

Line 1759: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Credit CustomerProfile_'||l_num);

1755: END;
1756:
1757: IF l_site_use_id IS NULL THEN--ST1 BUG Fix 5221801 - Cust Profile and Profile Amts
1758: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');
1759: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Credit CustomerProfile_'||l_num);
1760:
1761: IF l_num = 1 THEN
1762: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1763: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Credit CustomerProfile');

Line 1763: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Credit CustomerProfile');

1759: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Credit CustomerProfile_'||l_num);
1760:
1761: IF l_num = 1 THEN
1762: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1763: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Credit CustomerProfile');
1764: END IF;
1765: END IF;
1766:
1767: ELSIF l_event_name = 'oracle.apps.ar.hz.ContactPoint.update' THEN

Line 1782: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1778:
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:

Line 1784: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','Check the Owner Table Name in HZ_CONTACT_POINTS');

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
1788: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

Line 1788: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

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
1788: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);
1789:
1790: END;
1791:
1792: IF l_table_name = 'HZ_PARTIES' THEN

Line 1794: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', 'Inside IF l_table_name = hz_parties');

1790: END;
1791:
1792: IF l_table_name = 'HZ_PARTIES' THEN
1793:
1794: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', 'Inside IF l_table_name = hz_parties');
1795:
1796: BEGIN
1797:
1798: SELECT c.account_number

Line 1810: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());

1806:
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:

Line 1812: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','ACCOUNT_NUMBER IS NULL FOR Contact Point Update');

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
1816: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

Line 1816: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

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
1816: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);
1817:
1818: END;
1819:
1820: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Before FOR Loop of Contact Point Update');

Line 1820: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Before FOR Loop of Contact Point Update');

1816: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);
1817:
1818: END;
1819:
1820: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Before FOR Loop of Contact Point Update');
1821:
1822: FOR i IN 1..l_acc_num.COUNT LOOP
1823:
1824: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Inside FOR Loop of Contact Point Update');

Line 1824: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Inside FOR Loop of Contact Point Update');

1820: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Before FOR Loop of Contact Point Update');
1821:
1822: FOR i IN 1..l_acc_num.COUNT LOOP
1823:
1824: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Inside FOR Loop of Contact Point Update');
1825:
1826: l_num := xnb_util_pvt.check_collaboration_doc_status (l_acc_num(i), 'XNB_ACCOUNT');
1827: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Contact Point_'||l_acc_num(i)||'_'||l_num);
1828:

Line 1827: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Contact Point_'||l_acc_num(i)||'_'||l_num);

1823:
1824: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Inside FOR Loop of Contact Point Update');
1825:
1826: l_num := xnb_util_pvt.check_collaboration_doc_status (l_acc_num(i), 'XNB_ACCOUNT');
1827: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Contact Point_'||l_acc_num(i)||'_'||l_num);
1828:
1829: IF l_num = 1 THEN
1830: raise_acctupdate_event(l_acc_num(i), l_org_id, l_event_name, l_param_value);
1831: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Contact Point_'||l_acc_num(i));

Line 1831: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Contact Point_'||l_acc_num(i));

1827: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','Check the collaboration FOR Contact Point_'||l_acc_num(i)||'_'||l_num);
1828:
1829: IF l_num = 1 THEN
1830: raise_acctupdate_event(l_acc_num(i), l_org_id, l_event_name, l_param_value);
1831: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCOUNT_UPDATE','After Raising the Account Publish Event FOR Contact Point_'||l_acc_num(i));
1832: END IF;
1833:
1834: END LOOP;
1835:

Line 1871: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.PUBLISH_ACCT_UPDATE','Org_id before Raising Event'||p_org_id);

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);
1872:
1873: wf_event.AddParameterToList( p_name =>'ACCT_ORG_ID',
1874: p_value => p_org_id,
1875: p_parameterlist => l_parameter_list);

Line 1897: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.RAISE_ACCTUPDATE_EVENT',l_err_name||' : '||l_err_message);

1893: wf_core.GET_ERROR( err_name => l_err_name,
1894: err_message => l_err_message,
1895: err_stack => l_err_stack,
1896: maxErrStackLength => 900);
1897: XNB_DEBUG.log('XNB_CMN_PVT_TEMP.RAISE_ACCTUPDATE_EVENT',l_err_name||' : '||l_err_message);
1898: RAISE;
1899:
1900: END RAISE_ACCTUPDATE_EVENT;
1901:

Line 2126: END XNB_CMN_PVT;

2122: END publish_grpsalesorder_info;
2123:
2124:
2125: --End of Package
2126: END XNB_CMN_PVT;