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.OZF_RESALE_WF_PVT dependencies on OZF_UTILITY_PVT

Line 113: OZF_UTILITY_PVT.debug_message('IN: Re_Initilize_Context' );

109: l_api_name CONSTANT VARCHAR2(30) := 'Re_Initilize_Context';
110:
111: BEGIN
112: IF OZF_DEBUG_HIGH_ON THEN
113: OZF_UTILITY_PVT.debug_message('IN: Re_Initilize_Context' );
114: END IF;
115:
116: l_user_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype
117: ,itemkey => itemkey

Line 132: OZF_UTILITY_PVT.debug_message('l_user_id ' || l_user_id );

128: ,aname => G_WF_ATTR_APPL_ID
129: );
130:
131: IF OZF_DEBUG_HIGH_ON THEN
132: OZF_UTILITY_PVT.debug_message('l_user_id ' || l_user_id );
133: OZF_UTILITY_PVT.debug_message('l_resp_id ' || l_resp_id );
134: OZF_UTILITY_PVT.debug_message('l_appl_id ' || l_appl_id );
135: END IF;
136: --//Initilize the session

Line 133: OZF_UTILITY_PVT.debug_message('l_resp_id ' || l_resp_id );

129: );
130:
131: IF OZF_DEBUG_HIGH_ON THEN
132: OZF_UTILITY_PVT.debug_message('l_user_id ' || l_user_id );
133: OZF_UTILITY_PVT.debug_message('l_resp_id ' || l_resp_id );
134: OZF_UTILITY_PVT.debug_message('l_appl_id ' || l_appl_id );
135: END IF;
136: --//Initilize the session
137: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);

Line 134: OZF_UTILITY_PVT.debug_message('l_appl_id ' || l_appl_id );

130:
131: IF OZF_DEBUG_HIGH_ON THEN
132: OZF_UTILITY_PVT.debug_message('l_user_id ' || l_user_id );
133: OZF_UTILITY_PVT.debug_message('l_resp_id ' || l_resp_id );
134: OZF_UTILITY_PVT.debug_message('l_appl_id ' || l_appl_id );
135: END IF;
136: --//Initilize the session
137: FND_GLOBAL.APPS_INITIALIZE(l_user_id, l_resp_id, l_appl_id);
138:

Line 190: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

186: l_batch_org_id NUMBER;
187:
188: BEGIN
189: IF OZF_DEBUG_HIGH_ON THEN
190: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
191: END IF;
192:
193: -- R12 MOAC Enhancement (+)
194: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 233: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

229: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
230: itemkey => itemkey,
231: aname => G_WF_ATTR_BATCH_ID);
232: IF OZF_DEBUG_LOW_ON THEN
233: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
234: END IF;
235:
236: IF l_batch_id IS NOT NULL THEN
237: l_batch_type := WF_ENGINE.GetItemAttrText (itemtype => itemType,

Line 262: OZF_UTILITY_PVT.debug_message('Check duplicate line is complete '||l_return_status);

258: x_msg_count => l_msg_count,
259: x_msg_data => l_msg_data);
260:
261: IF OZF_DEBUG_LOW_ON THEN
262: OZF_UTILITY_PVT.debug_message('Check duplicate line is complete '||l_return_status);
263: OZF_UTILITY_PVT.debug_message('batch status '||l_batch_return_status);
264: END IF;
265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
266: RAISE FND_API.G_EXC_ERROR;

Line 263: OZF_UTILITY_PVT.debug_message('batch status '||l_batch_return_status);

259: x_msg_data => l_msg_data);
260:
261: IF OZF_DEBUG_LOW_ON THEN
262: OZF_UTILITY_PVT.debug_message('Check duplicate line is complete '||l_return_status);
263: OZF_UTILITY_PVT.debug_message('batch status '||l_batch_return_status);
264: END IF;
265: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;

Line 270: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268: END IF;
269: ELSE
270: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: WF_ENGINE.SetItemAttrText(

Line 373: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);

369:
370: l_batch_org_id NUMBER;
371: BEGIN
372: IF OZF_DEBUG_HIGH_ON THEN
373: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
374: END IF;
375:
376: -- R12 MOAC Enhancement (+)
377: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 414: --OZF_UTILITY_PVT.error_message('OZF_RESALE_AUTO_TP_NULL');

410:
411: IF l_auto_tp_accrual is NULL THEN
412: -- 11/23/04 yizhang: default flag to FALSE instead of raising an error
413: l_auto_tp_accrual := 'F';
414: --OZF_UTILITY_PVT.error_message('OZF_RESALE_AUTO_TP_NULL');
415: --RAISE FND_API.G_EXC_ERROR;
416: ELSE
417: -- START: Added for bug#9598648 fix
418: FND_REQUEST.set_org_id(l_batch_org_id);

Line 508: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);

504: l_batch_org_id NUMBER;
505:
506: BEGIN
507: IF OZF_DEBUG_HIGH_ON THEN
508: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
509: END IF;
510:
511: -- R12 MOAC Enhancement (+)
512: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 557: OZF_UTILITY_PVT.error_message('OZF_API_DEBUG_MESSAGE','TEXT','Invalid Batch caller '|| l_batch_caller);

553: END IF;
554:
555: IF l_batch_caller NOT IN (G_WF_LKUP_UI, G_WF_LKUP_XML, G_WF_LKUP_WEBADI)
556: THEN
557: OZF_UTILITY_PVT.error_message('OZF_API_DEBUG_MESSAGE','TEXT','Invalid Batch caller '|| l_batch_caller);
558: RAISE FND_API.G_EXC_ERROR;
559: END IF;
560:
561: -- SET attribute OZF_BATCH_NUM_W_DATE for event key

Line 576: OZF_UTILITY_PVT.debug_message('Batch caller'|| l_batch_caller );

572: aname => G_WF_ATTR_BATCH_NUM_W_DATE,
573: avalue => l_batch_num_w_date);
574:
575: IF OZF_DEBUG_LOW_ON THEN
576: OZF_UTILITY_PVT.debug_message('Batch caller'|| l_batch_caller );
577: END IF;
578: l_resultout := 'COMPLETE:' || l_batch_caller;
579: --
580: ELSIF (funcmode = 'CANCEL') THEN

Line 667: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);

663:
664: l_batch_org_id NUMBER;
665: BEGIN
666: IF OZF_DEBUG_HIGH_ON THEN
667: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
668: END IF;
669:
670: -- R12 MOAC Enhancement (+)
671: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 709: OZF_UTILITY_PVT.debug_message('Batch status '|| l_status_code );

705: FETCH batch_status_csr into l_status_code;
706: CLOSE batch_status_csr;
707:
708: IF OZF_DEBUG_LOW_ON THEN
709: OZF_UTILITY_PVT.debug_message('Batch status '|| l_status_code );
710: END IF;
711: IF l_status_code not in ( OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,
712: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,
713: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN

Line 801: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);

797:
798: l_batch_org_id NUMBER;
799: BEGIN
800: IF OZF_DEBUG_HIGH_ON THEN
801: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
802: END IF;
803:
804: -- R12 MOAC Enhancement (+)
805: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 841: OZF_UTILITY_PVT.error_message('OZF_API_DEBUG_MESSAGE','TEXT','Invalid Batch Type '|| l_batch_type);

837:
838: IF l_batch_type NOT IN (G_WF_LKUP_CHARGEBACK, G_WF_LKUP_SPECIALPRICE, G_WF_LKUP_TRACING) OR
839: l_batch_type IS NULL
840: THEN
841: OZF_UTILITY_PVT.error_message('OZF_API_DEBUG_MESSAGE','TEXT','Invalid Batch Type '|| l_batch_type);
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844:
845: IF OZF_DEBUG_LOW_ON THEN

Line 846: OZF_UTILITY_PVT.debug_message('Batch Type '|| l_batch_type );

842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844:
845: IF OZF_DEBUG_LOW_ON THEN
846: OZF_UTILITY_PVT.debug_message('Batch Type '|| l_batch_type );
847: END IF;
848: l_resultout := 'COMPLETE:' || l_batch_type;
849: --
850: ELSIF (funcmode = 'CANCEL') THEN

Line 948: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

944: l_batch_org_id NUMBER;
945: --
946: BEGIN
947: IF OZF_DEBUG_HIGH_ON THEN
948: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
949: END IF;
950: IF (funcmode = 'RUN') THEN
951: -- Clear the error stack for one time
952: FND_MSG_PUB.initialize;

Line 960: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

956: itemkey => itemkey,
957: aname => G_WF_ATTR_BATCH_ID
958: );
959: IF l_resale_batch_id is NULL THEN
960: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: OPEN batch_num_csr (l_resale_batch_id);

Line 994: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));

990: );
991:
992: /*
993: -- The following is moved to workflow first activity-Set_Batch_Status.
994: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));
995: FETCH emp_infor_csr INTO l_emp_id;
996: CLOSE emp_infor_csr;
997:
998: WF_DIRECTORY.GetRoleName

Line 1104: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

1100: l_batch_org_id NUMBER;
1101:
1102: BEGIN
1103: IF OZF_DEBUG_HIGH_ON THEN
1104: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1105: END IF;
1106:
1107: -- R12 MOAC Enhancement (+)
1108: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 1151: OZF_UTILITY_PVT.debug_message('subscribe process iface is complete ');

1147: ,x_msg_data => l_msg_data
1148: ,x_msg_count => l_msg_count
1149: );
1150: IF OZF_DEBUG_LOW_ON THEN
1151: OZF_UTILITY_PVT.debug_message('subscribe process iface is complete ');
1152: END IF;
1153: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1154: RAISE FND_API.G_EXC_ERROR;
1155: END IF;

Line 1252: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

1248: l_batch_info get_batch_info%ROWTYPE;
1249:
1250: BEGIN
1251: IF OZF_DEBUG_HIGH_ON THEN
1252: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1253: END IF;
1254:
1255: -- R12 MOAC Enhancement (+)
1256: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 1403: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

1399: l_batch_org_id NUMBER;
1400:
1401: BEGIN
1402: IF OZF_DEBUG_HIGH_ON THEN
1403: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1404: END IF;
1405:
1406: -- R12 MOAC Enhancement (+)
1407: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 1539: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

1535: l_msg_data VARCHAR2(2000);
1536: l_error_msg VARCHAR2(4000);
1537: BEGIN
1538: IF OZF_DEBUG_HIGH_ON THEN
1539: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1540: END IF;
1541: IF (funcmode = 'RUN') THEN
1542: --
1543: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

Line 1649: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

1645: l_batch_org_id NUMBER;
1646:
1647: BEGIN
1648: IF OZF_DEBUG_HIGH_ON THEN
1649: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1650: END IF;
1651:
1652: -- R12 MOAC Enhancement (+)
1653: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 1696: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');

1692: ,x_msg_data => l_msg_data
1693: ,x_msg_count => l_msg_count
1694: );
1695: IF OZF_DEBUG_LOW_ON THEN
1696: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');
1697: END IF;
1698: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;

Line 1786: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

1782: l_batch_org_id NUMBER;
1783:
1784: BEGIN
1785: IF OZF_DEBUG_HIGH_ON THEN
1786: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1787: END IF;
1788:
1789: -- R12 MOAC Enhancement (+)
1790: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 1919: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

1915: l_batch_org_id NUMBER;
1916:
1917: BEGIN
1918: IF OZF_DEBUG_HIGH_ON THEN
1919: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1920: END IF;
1921:
1922: -- R12 MOAC Enhancement (+)
1923: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 1966: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');

1962: ,x_msg_data => l_msg_data
1963: ,x_msg_count => l_msg_count
1964: );
1965: IF OZF_DEBUG_LOW_ON THEN
1966: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');
1967: END IF;
1968: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1969: RAISE FND_API.G_EXC_ERROR;
1970: END IF;

Line 2055: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

2051: l_batch_org_id NUMBER;
2052:
2053: BEGIN
2054: IF OZF_DEBUG_HIGH_ON THEN
2055: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2056: END IF;
2057:
2058: -- R12 MOAC Enhancement (+)
2059: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 2102: OZF_UTILITY_PVT.debug_message('subscribe process tracing order complete ');

2098: ,x_msg_data => l_msg_data
2099: ,x_msg_count => l_msg_count
2100: );
2101: IF OZF_DEBUG_LOW_ON THEN
2102: OZF_UTILITY_PVT.debug_message('subscribe process tracing order complete ');
2103: END IF;
2104: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2105: RAISE FND_API.G_EXC_ERROR;
2106: END IF;

Line 2200: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

2196: WHERE resale_batch_id = p_id;
2197: --
2198: BEGIN
2199: IF OZF_DEBUG_HIGH_ON THEN
2200: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2201: END IF;
2202: IF (funcmode = 'RUN') THEN
2203: --
2204: l_resale_batch_id := WF_ENGINE.GetItemAttrText(

Line 2215: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_NULL');

2211: FETCH batch_status_csr into l_batch_status, l_lines_disputed;
2212: CLOSE batch_status_csr;
2213:
2214: IF l_batch_status is null THEN
2215: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_NULL');
2216: RAISE FND_API.G_EXC_ERROR;
2217: END IF;
2218:
2219: -- reset the status based on # of disputed lines

Line 2382: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

2378: AND wiav.name = p_name;
2379:
2380: BEGIN
2381: IF OZF_DEBUG_HIGH_ON THEN
2382: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2383: END IF;
2384:
2385: -- R12 MOAC Enhancement (+)
2386: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 2422: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' l_resale_batch_id : ' || l_resale_batch_id);

2418: );
2419:
2420: --//Bugfix : 10431933
2421: IF OZF_DEBUG_HIGH_ON THEN
2422: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' l_resale_batch_id : ' || l_resale_batch_id);
2423: END IF;
2424:
2425:
2426: IF SUBSTR(itemkey,1,11) = 'ResaleBatch' THEN

Line 2459: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));

2455: , l_batch_status;
2456: CLOSE batch_status_csr;
2457:
2458:
2459: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));
2460: FETCH emp_infor_csr INTO l_emp_id;
2461: CLOSE emp_infor_csr;
2462:
2463: --//Bugfix : 10431933

Line 2471: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);

2467: l_wf_user_id := l_last_updated_by;
2468: END IF;
2469:
2470: IF OZF_DEBUG_LOW_ON THEN
2471: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);
2472: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);
2473: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);
2474: END IF;
2475:

Line 2472: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);

2468: END IF;
2469:
2470: IF OZF_DEBUG_LOW_ON THEN
2471: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);
2472: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);
2473: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);
2474: END IF;
2475:
2476: WF_DIRECTORY.GetRoleName(

Line 2473: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);

2469:
2470: IF OZF_DEBUG_LOW_ON THEN
2471: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);
2472: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);
2473: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);
2474: END IF;
2475:
2476: WF_DIRECTORY.GetRoleName(
2477: p_orig_system => 'PER',

Line 2519: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_NULL');

2515: ,avalue => 682
2516: );
2517: --
2518: IF l_batch_status is null THEN
2519: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_NULL');
2520: RAISE FND_API.G_EXC_ERROR;
2521: END IF;
2522:
2523:

Line 2537: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_ERR');

2533: SET status_code = l_batch_next_status
2534: WHERE resale_batch_id = l_resale_batch_id;
2535:
2536: ELSE
2537: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_ERR');
2538: RAISE FND_API.G_EXC_ERROR;
2539: END IF;
2540: END IF;
2541:

Line 2632: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

2628:
2629: l_batch_org_id NUMBER;
2630: BEGIN
2631: IF OZF_DEBUG_HIGH_ON THEN
2632: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2633: END IF;
2634:
2635: -- R12 MOAC Enhancement (+)
2636: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 2820: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

2816: l_batch_org_id NUMBER;
2817:
2818: BEGIN
2819: IF OZF_DEBUG_HIGH_ON THEN
2820: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2821: END IF;
2822:
2823: -- R12 MOAC Enhancement (+)
2824: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 3008: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

3004: l_batch_org_id NUMBER;
3005:
3006: BEGIN
3007: IF OZF_DEBUG_HIGH_ON THEN
3008: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3009: END IF;
3010:
3011: -- R12 MOAC Enhancement (+)
3012: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 3046: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

3042: itemkey => itemkey,
3043: aname => G_WF_ATTR_BATCH_ID);
3044:
3045: IF OZF_DEBUG_LOW_ON THEN
3046: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3047: END IF;
3048: IF l_batch_id IS NOT NULL THEN
3049: OZF_RESALE_COMMON_PVT.Validate_Batch (
3050: p_api_version => 1.0,

Line 3061: OZF_UTILITY_PVT.debug_message('Validate Batch is complete '||l_return_status);

3057: x_msg_count => l_msg_count,
3058: x_msg_data => l_msg_data );
3059:
3060: IF OZF_DEBUG_LOW_ON THEN
3061: OZF_UTILITY_PVT.debug_message('Validate Batch is complete '||l_return_status);
3062: END IF;
3063: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3064: RAISE FND_API.G_EXC_ERROR;
3065: END IF;

Line 3068: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

3064: RAISE FND_API.G_EXC_ERROR;
3065: END IF;
3066: l_resultout := 'COMPLETE:SUCCESS';
3067: ELSE
3068: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3069: RAISE FND_API.G_EXC_ERROR;
3070: END IF;
3071: l_resultout := 'COMPLETE:SUCCESS';
3072: --

Line 3155: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

3151:
3152: l_batch_org_id NUMBER;
3153: BEGIN
3154: IF OZF_DEBUG_HIGH_ON THEN
3155: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3156: END IF;
3157:
3158: -- R12 MOAC Enhancement (+)
3159: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 3192: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

3188: itemkey => itemkey,
3189: aname => G_WF_ATTR_BATCH_ID);
3190:
3191: IF OZF_DEBUG_LOW_ON THEN
3192: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3193: END IF;
3194: IF l_batch_id IS NOT NULL THEN
3195: -- Verify the line information for this batch
3196: OZF_RESALE_COMMON_PVT.Validate_Order_Record (

Line 3207: OZF_UTILITY_PVT.error_message('OZF_RESALE_VALIDATE_ERR');

3203: ,x_msg_data => l_msg_data
3204: ,x_msg_count => l_msg_count
3205: );
3206: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3207: OZF_UTILITY_PVT.error_message('OZF_RESALE_VALIDATE_ERR');
3208: RAISE FND_API.G_EXC_ERROR;
3209: END IF;
3210: ELSE
3211: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

Line 3211: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

3207: OZF_UTILITY_PVT.error_message('OZF_RESALE_VALIDATE_ERR');
3208: RAISE FND_API.G_EXC_ERROR;
3209: END IF;
3210: ELSE
3211: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3212: RAISE FND_API.G_EXC_ERROR;
3213: END IF;
3214:
3215: l_resultout := 'COMPLETE:SUCCESS';

Line 3301: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

3297: l_batch_org_id NUMBER;
3298:
3299: BEGIN
3300: IF OZF_DEBUG_HIGH_ON THEN
3301: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3302: END IF;
3303:
3304: -- R12 MOAC Enhancement (+)
3305: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 3338: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

3334: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3335: itemkey => itemkey,
3336: aname => G_WF_ATTR_BATCH_ID);
3337: IF OZF_DEBUG_LOW_ON THEN
3338: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3339: END IF;
3340:
3341: IF l_batch_id IS NOT NULL THEN
3342: -- Verify the line information for this batch

Line 3354: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');

3350: ,x_msg_data => l_msg_data
3351: ,x_msg_count => l_msg_count
3352: );
3353: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3354: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3355: RAISE FND_API.G_EXC_ERROR;
3356: END IF;
3357: ELSE
3358: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

Line 3358: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

3354: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3355: RAISE FND_API.G_EXC_ERROR;
3356: END IF;
3357: ELSE
3358: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3359: RAISE FND_API.G_EXC_ERROR;
3360: END IF;
3361: l_resultout := 'COMPLETE:SUCCESS';
3362: --

Line 3446: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

3442:
3443: l_batch_org_id NUMBER;
3444: BEGIN
3445: IF OZF_DEBUG_HIGH_ON THEN
3446: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3447: END IF;
3448:
3449: -- R12 MOAC Enhancement (+)
3450: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 3483: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

3479: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3480: itemkey => itemkey,
3481: aname => G_WF_ATTR_BATCH_ID);
3482: IF OZF_DEBUG_LOW_ON THEN
3483: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3484: END IF;
3485:
3486: IF l_batch_id IS NOT NULL THEN
3487: -- Verify the line information for this batch

Line 3499: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');

3495: ,x_msg_data => l_msg_data
3496: ,x_msg_count => l_msg_count
3497: );
3498: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3499: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3500: RAISE FND_API.G_EXC_ERROR;
3501: END IF;
3502: ELSE
3503: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

Line 3503: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

3499: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3500: RAISE FND_API.G_EXC_ERROR;
3501: END IF;
3502: ELSE
3503: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;
3506: l_resultout := 'COMPLETE:SUCCESS';
3507: --

Line 3592: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

3588: l_batch_org_id NUMBER;
3589:
3590: BEGIN
3591: IF OZF_DEBUG_HIGH_ON THEN
3592: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3593: END IF;
3594:
3595: -- R12 MOAC Enhancement (+)
3596: l_batch_org_id := WF_ENGINE.GetItemAttrText(

Line 3629: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

3625: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3626: itemkey => itemkey,
3627: aname => G_WF_ATTR_BATCH_ID);
3628: IF OZF_DEBUG_LOW_ON THEN
3629: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3630: END IF;
3631:
3632: IF l_batch_id IS NOT NULL THEN
3633: -- Verify the line information for this batch

Line 3645: OZF_UTILITY_PVT.error_message('OZF_RESALE_TRAC_VALIDATE_ERR');

3641: ,x_msg_data => l_msg_data
3642: ,x_msg_count => l_msg_count
3643: );
3644: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3645: OZF_UTILITY_PVT.error_message('OZF_RESALE_TRAC_VALIDATE_ERR');
3646: RAISE FND_API.G_EXC_ERROR;
3647: END IF;
3648: ELSE
3649: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

Line 3649: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

3645: OZF_UTILITY_PVT.error_message('OZF_RESALE_TRAC_VALIDATE_ERR');
3646: RAISE FND_API.G_EXC_ERROR;
3647: END IF;
3648: ELSE
3649: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3650: RAISE FND_API.G_EXC_ERROR;
3651: END IF;
3652: l_resultout := 'COMPLETE:SUCCESS';
3653: --

Line 3799: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_batch_info.last_updated_by));

3795: ELSE
3796: l_wf_user_id := l_batch_info.last_updated_by;
3797: END IF;
3798:
3799: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_batch_info.last_updated_by));
3800: FETCH emp_infor_csr INTO l_emp_id;
3801: CLOSE emp_infor_csr;
3802:
3803: WF_DIRECTORY.GetRoleName(

Line 3811: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);

3807: p_display_name => l_display_name
3808: );
3809:
3810: IF OZF_DEBUG_LOW_ON THEN
3811: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);
3812: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);
3813: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);
3814: OZF_UTILITY_PVT.debug_message('l_emp_id :' || l_emp_id);
3815: END IF;

Line 3812: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);

3808: );
3809:
3810: IF OZF_DEBUG_LOW_ON THEN
3811: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);
3812: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);
3813: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);
3814: OZF_UTILITY_PVT.debug_message('l_emp_id :' || l_emp_id);
3815: END IF;
3816:

Line 3813: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);

3809:
3810: IF OZF_DEBUG_LOW_ON THEN
3811: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);
3812: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);
3813: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);
3814: OZF_UTILITY_PVT.debug_message('l_emp_id :' || l_emp_id);
3815: END IF;
3816:
3817: -- nepanda : Fix for bug # 12716192

Line 3814: OZF_UTILITY_PVT.debug_message('l_emp_id :' || l_emp_id);

3810: IF OZF_DEBUG_LOW_ON THEN
3811: OZF_UTILITY_PVT.debug_message('l_user_id :' || l_user_id);
3812: OZF_UTILITY_PVT.debug_message('l_wf_user_id :' || l_wf_user_id);
3813: OZF_UTILITY_PVT.debug_message('l_resp_id :' || l_resp_id);
3814: OZF_UTILITY_PVT.debug_message('l_emp_id :' || l_emp_id);
3815: END IF;
3816:
3817: -- nepanda : Fix for bug # 12716192
3818: -- If value of profile "OZF: IDSM Batch Processing Mode" is set to Synchronous then Batch Process will be done synchronously

Line 4067: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_batch_info.last_updated_by));

4063: OPEN wf_values_csr(l_itemtype,p_resale_batch_id,G_WF_ATTR_RESP_ID);
4064: FETCH wf_values_csr INTO l_resp_id;
4065: CLOSE wf_values_csr;
4066:
4067: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_batch_info.last_updated_by));
4068: FETCH emp_infor_csr INTO l_emp_id;
4069: CLOSE emp_infor_csr;
4070:
4071: -- fix for bug 16066424

Line 4158: OZF_UTILITY_PVT.debug_message('Before WF_EVENT.Raise');

4154: wf_event.AddParameterToList(p_name => 'OZF_BATCH_ORG_ID',
4155: p_value => l_batch_info.org_id,
4156: p_parameterlist => l_parameter_list);
4157: IF OZF_DEBUG_LOW_ON THEN
4158: OZF_UTILITY_PVT.debug_message('Before WF_EVENT.Raise');
4159: OZF_UTILITY_PVT.debug_message('p_event :'|| p_event);
4160: OZF_UTILITY_PVT.debug_message('l_itemkey :'|| l_itemkey);
4161: OZF_UTILITY_PVT.debug_message('l_user_id :'|| l_user_id);
4162: OZF_UTILITY_PVT.debug_message('l_resp_id :'|| l_resp_id);

Line 4159: OZF_UTILITY_PVT.debug_message('p_event :'|| p_event);

4155: p_value => l_batch_info.org_id,
4156: p_parameterlist => l_parameter_list);
4157: IF OZF_DEBUG_LOW_ON THEN
4158: OZF_UTILITY_PVT.debug_message('Before WF_EVENT.Raise');
4159: OZF_UTILITY_PVT.debug_message('p_event :'|| p_event);
4160: OZF_UTILITY_PVT.debug_message('l_itemkey :'|| l_itemkey);
4161: OZF_UTILITY_PVT.debug_message('l_user_id :'|| l_user_id);
4162: OZF_UTILITY_PVT.debug_message('l_resp_id :'|| l_resp_id);
4163: END IF;

Line 4160: OZF_UTILITY_PVT.debug_message('l_itemkey :'|| l_itemkey);

4156: p_parameterlist => l_parameter_list);
4157: IF OZF_DEBUG_LOW_ON THEN
4158: OZF_UTILITY_PVT.debug_message('Before WF_EVENT.Raise');
4159: OZF_UTILITY_PVT.debug_message('p_event :'|| p_event);
4160: OZF_UTILITY_PVT.debug_message('l_itemkey :'|| l_itemkey);
4161: OZF_UTILITY_PVT.debug_message('l_user_id :'|| l_user_id);
4162: OZF_UTILITY_PVT.debug_message('l_resp_id :'|| l_resp_id);
4163: END IF;
4164:

Line 4161: OZF_UTILITY_PVT.debug_message('l_user_id :'|| l_user_id);

4157: IF OZF_DEBUG_LOW_ON THEN
4158: OZF_UTILITY_PVT.debug_message('Before WF_EVENT.Raise');
4159: OZF_UTILITY_PVT.debug_message('p_event :'|| p_event);
4160: OZF_UTILITY_PVT.debug_message('l_itemkey :'|| l_itemkey);
4161: OZF_UTILITY_PVT.debug_message('l_user_id :'|| l_user_id);
4162: OZF_UTILITY_PVT.debug_message('l_resp_id :'|| l_resp_id);
4163: END IF;
4164:
4165:

Line 4162: OZF_UTILITY_PVT.debug_message('l_resp_id :'|| l_resp_id);

4158: OZF_UTILITY_PVT.debug_message('Before WF_EVENT.Raise');
4159: OZF_UTILITY_PVT.debug_message('p_event :'|| p_event);
4160: OZF_UTILITY_PVT.debug_message('l_itemkey :'|| l_itemkey);
4161: OZF_UTILITY_PVT.debug_message('l_user_id :'|| l_user_id);
4162: OZF_UTILITY_PVT.debug_message('l_resp_id :'|| l_resp_id);
4163: END IF;
4164:
4165:
4166: WF_EVENT.Raise