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_DEBUG

Line 59: XNB_DEBUG.log('check_acct_update_publish',l_event_name);

55: itemtype => itemtype,
56: itemkey => itemkey,
57: aname => 'ACCOUNT_NUMBER');
58:
59: XNB_DEBUG.log('check_acct_update_publish',l_event_name);
60:
61: IF l_event_name = 'oracle.apps.xnb.account.update' THEN
62:
63: l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, 'XNB_ACCOUNT');

Line 65: XNB_DEBUG.log('check_acct_update_publish',l_num);

61: IF l_event_name = 'oracle.apps.xnb.account.update' THEN
62:
63: l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, 'XNB_ACCOUNT');
64:
65: XNB_DEBUG.log('check_acct_update_publish',l_num);
66:
67: IF l_num = 1 THEN
68: resultout := FND_API.G_TRUE;
69: END IF;

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 1448: XNB_DEBUG.log('Event_subscription',l_param_value);

1444:
1445: IF l_event_name = 'oracle.apps.ar.hz.CustAccount.update' THEN
1446:
1447: l_param_value := p_event.GetValueForParameter('CUST_ACCOUNT_ID');
1448: XNB_DEBUG.log('Event_subscription',l_param_value);
1449:
1450: BEGIN
1451:
1452:

Line 1458: XNB_DEBUG.log('oracle.apps.ar.hz.CustAccount.update',l_account_number);

1454: INTO l_account_number
1455: FROM HZ_CUST_ACCOUNTS
1456: WHERE CUST_ACCOUNT_ID = l_param_value;
1457:
1458: XNB_DEBUG.log('oracle.apps.ar.hz.CustAccount.update',l_account_number);
1459:
1460: EXCEPTION
1461:
1462: WHEN NO_DATA_FOUND THEN

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 1479: XNB_DEBUG.log('Event_subscription',l_param_value);

1475: /*
1476: ELSIF l_event_name = 'oracle.apps.ar.hz.BillingPreference.create' OR l_event_name = 'oracle.apps.ar.hz.BillingPreference.update' THEN
1477:
1478: l_param_value := p_event.GetValueForParameter('BILLING_PREFERENCES_ID');
1479: XNB_DEBUG.log('Event_subscription',l_param_value);
1480:
1481: BEGIN
1482:
1483: SELECT account_number

Line 1490: XNB_DEBUG.log('oracle.apps.ar.hz.BillingPreference',l_account_number);

1486: hz_cust_accounts acc
1487: WHERE bill_pref.cust_account_id = acc.cust_account_id
1488: AND bill_pref.billing_preferences_id = l_param_value;
1489:
1490: XNB_DEBUG.log('oracle.apps.ar.hz.BillingPreference',l_account_number);
1491:
1492: EXCEPTION
1493:
1494: WHEN NO_DATA_FOUND THEN

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 1511: XNB_DEBUG.log('Event_subscription',l_param_value);

1507: ELSIF l_event_name = 'oracle.apps.ar.hz.CustAcctRelate.create' OR l_event_name = 'oracle.apps.ar.hz.CustAcctRelate.update' THEN
1508:
1509: l_param_value := p_event.GetValueForParameter('CUST_ACCOUNT_ID');
1510: l_rel_cust_acct_id := p_event.GetValueForParameter('RELATED_CUST_ACCOUNT_ID');
1511: XNB_DEBUG.log('Event_subscription',l_param_value);
1512:
1513: BEGIN
1514:
1515: SELECT distinct ACCT.ACCOUNT_NUMBER

Line 1522: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctRelate','Account Number'||l_account_number);

1518: HZ_CUST_ACCT_RELATE_ALL ACCT_REL
1519: WHERE ACCT.CUST_ACCOUNT_ID = l_param_value
1520: AND ACCT.CUST_ACCOUNT_ID = ACCT_REL.CUST_ACCOUNT_ID;
1521:
1522: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctRelate','Account Number'||l_account_number);
1523: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctRelate','Related Cust Account Id '||l_rel_cust_acct_id);
1524:
1525: l_param_value := l_rel_cust_acct_id;
1526:

Line 1523: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctRelate','Related Cust Account Id '||l_rel_cust_acct_id);

1519: WHERE ACCT.CUST_ACCOUNT_ID = l_param_value
1520: AND ACCT.CUST_ACCOUNT_ID = ACCT_REL.CUST_ACCOUNT_ID;
1521:
1522: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctRelate','Account Number'||l_account_number);
1523: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctRelate','Related Cust Account Id '||l_rel_cust_acct_id);
1524:
1525: l_param_value := l_rel_cust_acct_id;
1526:
1527: EXCEPTION

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 1545: XNB_DEBUG.log('Event_subscription',l_param_value);

1541:
1542:
1543: ELSIF l_event_name = 'oracle.apps.ar.hz.CustAcctSiteUse.create' OR l_event_name = 'oracle.apps.ar.hz.CustAcctSiteUse.update' THEN
1544: l_param_value := p_event.GetValueForParameter('SITE_USE_ID');
1545: XNB_DEBUG.log('Event_subscription',l_param_value);
1546:
1547: BEGIN
1548:
1549: /* R12 MOAC UPTAKE : ksrikant*/

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 1569: XNB_DEBUG.log('Event_subscription','Inside If oracle.apps.ar.hz.CustAcctSiteUse.create');

1565: END;
1566:
1567: IF l_event_name = 'oracle.apps.ar.hz.CustAcctSiteUse.create' THEN
1568:
1569: XNB_DEBUG.log('Event_subscription','Inside If oracle.apps.ar.hz.CustAcctSiteUse.create');
1570:
1571: IF l_site_use_code = 'BILL_TO' AND l_flag = 'Y' THEN
1572:
1573:

Line 1587: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctSiteUse.create',l_account_number);

1583: WHERE p.site_use_id = l_param_value
1584: AND a.cust_acct_site_id = p.cust_acct_site_id
1585: AND a.cust_account_id = b.cust_account_id;
1586:
1587: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctSiteUse.create',l_account_number);
1588:
1589: EXCEPTION
1590:
1591: WHEN NO_DATA_FOUND THEN

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 1623: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctSiteUse.update',l_account_number);

1619: WHERE p.site_use_id = l_param_value
1620: AND a.cust_acct_site_id = p.cust_acct_site_id
1621: AND a.cust_account_id = b.cust_account_id;
1622:
1623: XNB_DEBUG.log('oracle.apps.ar.hz.CustAcctSiteUse.update',l_account_number);
1624:
1625: EXCEPTION
1626:
1627: WHEN NO_DATA_FOUND THEN

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 1647: XNB_DEBUG.log('Event_subscription',l_param_value);

1643:
1644: ELSIF l_event_name = 'oracle.apps.ar.hz.CustProfileAmt.create' OR l_event_name = 'oracle.apps.ar.hz.CustProfileAmt.update' THEN
1645:
1646: l_param_value := p_event.GetValueForParameter('CUST_ACCT_PROFILE_AMT_ID');
1647: XNB_DEBUG.log('Event_subscription',l_param_value);
1648:
1649: BEGIN
1650:
1651: --ST1 BUG Fix 5221801 - Cust Profile and Profile Amts

Line 1663: XNB_DEBUG.log('oracle.apps.ar.hz.CustProfileAmt',l_account_number);

1659: WHERE pfl_amnts.cust_account_id = acc.cust_account_id
1660: AND pfl.cust_account_profile_id = pfl_amnts.cust_account_profile_id
1661: AND pfl_amnts.CUST_ACCT_PROFILE_AMT_ID = l_param_value;
1662:
1663: XNB_DEBUG.log('oracle.apps.ar.hz.CustProfileAmt',l_account_number);
1664:
1665: EXCEPTION
1666:
1667: WHEN NO_DATA_FOUND THEN

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 1688: XNB_DEBUG.log('Event_subscription',l_param_value);

1684: /* R12 Introduction of 4 new events : ksrikant*/
1685: ELSIF l_event_name = 'oracle.apps.ar.hz.Person.update' OR l_event_name = 'oracle.apps.ar.hz.Organization.update' THEN
1686:
1687: l_param_value := p_event.GetValueForParameter('PARTY_ID');
1688: XNB_DEBUG.log('Event_subscription',l_param_value);
1689:
1690: BEGIN
1691:
1692: SELECT account_number

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 1729: XNB_DEBUG.log('Event_subscription',l_param_value);

1725:
1726: ELSIF l_event_name = 'oracle.apps.ar.hz.CustomerProfile.update' THEN
1727:
1728: l_param_value := p_event.GetValueForParameter('CUST_ACCOUNT_PROFILE_ID');
1729: XNB_DEBUG.log('Event_subscription',l_param_value);
1730:
1731: BEGIN
1732: --ST1 BUG Fix 5221801 - Cust Profile and Profile Amts
1733: SELECT b.account_number,

Line 1742: XNB_DEBUG.log('oracle.apps.ar.hz.CustomerProfile',l_account_number);

1738: hz_cust_accounts b
1739: WHERE a.cust_account_profile_id = l_param_value
1740: AND a.cust_account_id = b.cust_account_id;
1741:
1742: XNB_DEBUG.log('oracle.apps.ar.hz.CustomerProfile',l_account_number);
1743:
1744: EXCEPTION
1745:
1746: WHEN NO_DATA_FOUND THEN

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 1770: XNB_DEBUG.log('Event_subscription',l_param_value);

1766:
1767: ELSIF l_event_name = 'oracle.apps.ar.hz.ContactPoint.update' THEN
1768:
1769: l_param_value := p_event.GetValueForParameter('CONTACT_POINT_ID');
1770: XNB_DEBUG.log('Event_subscription',l_param_value);
1771:
1772: BEGIN
1773:
1774: SELECT owner_table_name

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