DBA Data[Home] [Help]

APPS.XNB_CMN_PVT dependencies on XNB_UTIL_PVT

Line 63: l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, 'XNB_ACCOUNT');

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');
64:
65: XNB_DEBUG.log('check_acct_update_publish',l_num);
66:
67: IF l_num = 1 THEN

Line 210: l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, l_transaction_type, l_transaction_subtype);

206: --if l_num = 2 Collaboration doesn't exist so Create
207: --else Collaboration exists so Update
208: ---------------------------------------------------------------------------------------
209:
210: l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, l_transaction_type, l_transaction_subtype);
211:
212: IF l_num = 2 THEN
213: resultout := FND_API.G_FALSE;
214: RETURN ;

Line 618: l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, 'XNB_ACCOUNT');

614: --if l_num = 2 Collaboration doesn't exist so Create
615: --else Collaboration exists so Update
616: ---------------------------------------------------------------------------------------
617:
618: l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, 'XNB_ACCOUNT');
619:
620: IF l_num = 2 THEN
621: resultout := FND_API.G_FALSE;
622: RETURN ;

Line 819: /* l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, l_transaction_type, l_transaction_subtype);

815: --if l_num = 2 Collaboration doesn't exist so Create
816: --else Collaboration exists so Update
817: ---------------------------------------------------------------------------------------
818:
819: /* l_num := xnb_util_pvt.check_collaboration_doc_status (l_doc_no, l_transaction_type, l_transaction_subtype);
820:
821: IF l_num = 2 THEN
822: resultout := FND_API.G_FALSE;
823: RETURN ;

Line 1077: l_ret := xnb_util_pvt.check_collaboration_doc_status (

1073: 'IB_INSTANCE_ORG_ID',
1074: to_char(l_inv_org_id));
1075:
1076: --Call the util procedure and check Collaboration History, if the account is published
1077: l_ret := xnb_util_pvt.check_collaboration_doc_status (
1078: to_char(l_instance_id),
1079: 'XNB_OWNER');
1080:
1081: IF (l_ret = 2 OR l_ret = -1) THEN --If it was not found / or there was an error

Line 1151: l_ret := xnb_util_pvt.check_collaboration_doc_status (

1147: itemkey,
1148: 'IB_INSTANCE_ID');
1149:
1150: --Call the util procedure and check Collaboration History
1151: l_ret := xnb_util_pvt.check_collaboration_doc_status (
1152: l_document_id,
1153: 'XNB_OWNER');
1154:
1155:

Line 1469: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

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');
1470:
1471: IF l_num = 1 THEN
1472: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1473: END IF;

Line 1501: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

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');
1502:
1503: IF l_num = 1 THEN
1504: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1505: END IF;

Line 1536: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

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');
1537:
1538: IF l_num = 1 THEN
1539: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1540: END IF;

Line 1598: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

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');
1599:
1600: IF l_num = 1 THEN
1601: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1602: END IF;

Line 1634: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

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');
1635:
1636: IF l_num = 1 THEN
1637: raise_acctupdate_event(l_account_number, l_org_id, l_event_name, l_param_value);
1638: END IF;

Line 1675: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

1671: RAISE;
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);

Line 1716: l_num := xnb_util_pvt.check_collaboration_doc_status (l_acc_num(i), 'XNB_ACCOUNT');

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
1720: raise_acctupdate_event(l_acc_num(i), l_org_id, l_event_name, l_param_value);

Line 1758: l_num := xnb_util_pvt.check_collaboration_doc_status (l_account_number, 'XNB_ACCOUNT');

1754:
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);

Line 1826: l_num := xnb_util_pvt.check_collaboration_doc_status (l_acc_num(i), 'XNB_ACCOUNT');

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:
1829: IF l_num = 1 THEN
1830: raise_acctupdate_event(l_acc_num(i), l_org_id, l_event_name, l_param_value);