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 133: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);

129: l_batch_org_id NUMBER;
130:
131: BEGIN
132: IF OZF_DEBUG_HIGH_ON THEN
133: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
134: END IF;
135:
136: -- R12 MOAC Enhancement (+)
137: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

165: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
166: itemkey => itemkey,
167: aname => G_WF_ATTR_BATCH_ID);
168: IF OZF_DEBUG_LOW_ON THEN
169: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
170: END IF;
171:
172: IF l_batch_id IS NOT NULL THEN
173: l_batch_type := WF_ENGINE.GetItemAttrText (itemtype => itemType,

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

194: x_msg_count => l_msg_count,
195: x_msg_data => l_msg_data);
196:
197: IF OZF_DEBUG_LOW_ON THEN
198: OZF_UTILITY_PVT.debug_message('Check duplicate line is complete '||l_return_status);
199: OZF_UTILITY_PVT.debug_message('batch status '||l_batch_return_status);
200: END IF;
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: RAISE FND_API.G_EXC_ERROR;

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

195: x_msg_data => l_msg_data);
196:
197: IF OZF_DEBUG_LOW_ON THEN
198: OZF_UTILITY_PVT.debug_message('Check duplicate line is complete '||l_return_status);
199: OZF_UTILITY_PVT.debug_message('batch status '||l_batch_return_status);
200: END IF;
201: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
202: RAISE FND_API.G_EXC_ERROR;
203: END IF;

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

202: RAISE FND_API.G_EXC_ERROR;
203: END IF;
204: END IF;
205: ELSE
206: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: WF_ENGINE.SetItemAttrText(

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

305:
306: l_batch_org_id NUMBER;
307: BEGIN
308: IF OZF_DEBUG_HIGH_ON THEN
309: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
310: END IF;
311:
312: -- R12 MOAC Enhancement (+)
313: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

344:
345: IF l_auto_tp_accrual is NULL THEN
346: -- 11/23/04 yizhang: default flag to FALSE instead of raising an error
347: l_auto_tp_accrual := 'F';
348: --OZF_UTILITY_PVT.error_message('OZF_RESALE_AUTO_TP_NULL');
349: --RAISE FND_API.G_EXC_ERROR;
350: END IF;
351: l_resultout := 'COMPLETE:' || l_auto_tp_accrual;
352: --

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

433: l_batch_org_id NUMBER;
434:
435: BEGIN
436: IF OZF_DEBUG_HIGH_ON THEN
437: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
438: END IF;
439:
440: -- R12 MOAC Enhancement (+)
441: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

481: END IF;
482:
483: IF l_batch_caller NOT IN (G_WF_LKUP_UI, G_WF_LKUP_XML, G_WF_LKUP_WEBADI)
484: THEN
485: OZF_UTILITY_PVT.error_message('OZF_API_DEBUG_MESSAGE','TEXT','Invalid Batch caller '|| l_batch_caller);
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489: -- SET attribute OZF_BATCH_NUM_W_DATE for event key

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

500: aname => G_WF_ATTR_BATCH_NUM_W_DATE,
501: avalue => l_batch_num_w_date);
502:
503: IF OZF_DEBUG_LOW_ON THEN
504: OZF_UTILITY_PVT.debug_message('Batch caller'|| l_batch_caller );
505: END IF;
506: l_resultout := 'COMPLETE:' || l_batch_caller;
507: --
508: ELSIF (funcmode = 'CANCEL') THEN

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

591:
592: l_batch_org_id NUMBER;
593: BEGIN
594: IF OZF_DEBUG_HIGH_ON THEN
595: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
596: END IF;
597:
598: -- R12 MOAC Enhancement (+)
599: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

632: FETCH batch_status_csr into l_status_code;
633: CLOSE batch_status_csr;
634:
635: IF OZF_DEBUG_LOW_ON THEN
636: OZF_UTILITY_PVT.debug_message('Batch status '|| l_status_code );
637: END IF;
638: IF l_status_code not in ( OZF_RESALE_COMMON_PVT.G_BATCH_PROCESSED,
639: OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED,
640: OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED) THEN

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

724:
725: l_batch_org_id NUMBER;
726: BEGIN
727: IF OZF_DEBUG_HIGH_ON THEN
728: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
729: END IF;
730:
731: -- R12 MOAC Enhancement (+)
732: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

763:
764: IF l_batch_type NOT IN (G_WF_LKUP_CHARGEBACK, G_WF_LKUP_SPECIALPRICE, G_WF_LKUP_TRACING) OR
765: l_batch_type IS NULL
766: THEN
767: OZF_UTILITY_PVT.error_message('OZF_API_DEBUG_MESSAGE','TEXT','Invalid Batch Type '|| l_batch_type);
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770:
771: IF OZF_DEBUG_LOW_ON THEN

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

768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770:
771: IF OZF_DEBUG_LOW_ON THEN
772: OZF_UTILITY_PVT.debug_message('Batch Type '|| l_batch_type );
773: END IF;
774: l_resultout := 'COMPLETE:' || l_batch_type;
775: --
776: ELSIF (funcmode = 'CANCEL') THEN

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

870: l_batch_org_id NUMBER;
871: --
872: BEGIN
873: IF OZF_DEBUG_HIGH_ON THEN
874: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
875: END IF;
876: IF (funcmode = 'RUN') THEN
877: -- Clear the error stack for one time
878: FND_MSG_PUB.initialize;

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

882: itemkey => itemkey,
883: aname => G_WF_ATTR_BATCH_ID
884: );
885: IF l_resale_batch_id is NULL THEN
886: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889:
890: OPEN batch_num_csr (l_resale_batch_id);

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

916: );
917:
918: /*
919: -- The following is moved to workflow first activity-Set_Batch_Status.
920: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));
921: FETCH emp_infor_csr INTO l_emp_id;
922: CLOSE emp_infor_csr;
923:
924: WF_DIRECTORY.GetRoleName

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

1026: l_batch_org_id NUMBER;
1027:
1028: BEGIN
1029: IF OZF_DEBUG_HIGH_ON THEN
1030: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1031: END IF;
1032:
1033: -- R12 MOAC Enhancement (+)
1034: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

1072: ,x_msg_data => l_msg_data
1073: ,x_msg_count => l_msg_count
1074: );
1075: IF OZF_DEBUG_LOW_ON THEN
1076: OZF_UTILITY_PVT.debug_message('subscribe process iface is complete ');
1077: END IF;
1078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;

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

1162: l_batch_org_id NUMBER;
1163:
1164: BEGIN
1165: IF OZF_DEBUG_HIGH_ON THEN
1166: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1167: END IF;
1168:
1169: -- R12 MOAC Enhancement (+)
1170: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

1294: l_batch_org_id NUMBER;
1295:
1296: BEGIN
1297: IF OZF_DEBUG_HIGH_ON THEN
1298: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1299: END IF;
1300:
1301: -- R12 MOAC Enhancement (+)
1302: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

1423: l_msg_data VARCHAR2(2000);
1424: l_error_msg VARCHAR2(4000);
1425: BEGIN
1426: IF OZF_DEBUG_HIGH_ON THEN
1427: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1428: END IF;
1429: IF (funcmode = 'RUN') THEN
1430: --
1431: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

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

1526: l_batch_org_id NUMBER;
1527:
1528: BEGIN
1529: IF OZF_DEBUG_HIGH_ON THEN
1530: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1531: END IF;
1532:
1533: -- R12 MOAC Enhancement (+)
1534: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

1572: ,x_msg_data => l_msg_data
1573: ,x_msg_count => l_msg_count
1574: );
1575: IF OZF_DEBUG_LOW_ON THEN
1576: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');
1577: END IF;
1578: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;

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

1662: l_batch_org_id NUMBER;
1663:
1664: BEGIN
1665: IF OZF_DEBUG_HIGH_ON THEN
1666: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1667: END IF;
1668:
1669: -- R12 MOAC Enhancement (+)
1670: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

1794: l_batch_org_id NUMBER;
1795:
1796: BEGIN
1797: IF OZF_DEBUG_HIGH_ON THEN
1798: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1799: END IF;
1800:
1801: -- R12 MOAC Enhancement (+)
1802: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

1840: ,x_msg_data => l_msg_data
1841: ,x_msg_count => l_msg_count
1842: );
1843: IF OZF_DEBUG_LOW_ON THEN
1844: OZF_UTILITY_PVT.debug_message('subscribe process chargeback order complete ');
1845: END IF;
1846: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1847: RAISE FND_API.G_EXC_ERROR;
1848: END IF;

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

1929: l_batch_org_id NUMBER;
1930:
1931: BEGIN
1932: IF OZF_DEBUG_HIGH_ON THEN
1933: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1934: END IF;
1935:
1936: -- R12 MOAC Enhancement (+)
1937: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

1975: ,x_msg_data => l_msg_data
1976: ,x_msg_count => l_msg_count
1977: );
1978: IF OZF_DEBUG_LOW_ON THEN
1979: OZF_UTILITY_PVT.debug_message('subscribe process tracing order complete ');
1980: END IF;
1981: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1982: RAISE FND_API.G_EXC_ERROR;
1983: END IF;

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

2073: WHERE resale_batch_id = p_id;
2074: --
2075: BEGIN
2076: IF OZF_DEBUG_HIGH_ON THEN
2077: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2078: END IF;
2079: IF (funcmode = 'RUN') THEN
2080: --
2081: l_resale_batch_id := WF_ENGINE.GetItemAttrText(

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

2088: FETCH batch_status_csr into l_batch_status, l_lines_disputed;
2089: CLOSE batch_status_csr;
2090:
2091: IF l_batch_status is null THEN
2092: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_NULL');
2093: RAISE FND_API.G_EXC_ERROR;
2094: END IF;
2095:
2096: -- reset the status based on # of disputed lines

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

2240:
2241: l_batch_org_id NUMBER;
2242: BEGIN
2243: IF OZF_DEBUG_HIGH_ON THEN
2244: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2245: END IF;
2246:
2247: -- R12 MOAC Enhancement (+)
2248: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

2283: , l_batch_status;
2284: CLOSE batch_status_csr;
2285:
2286:
2287: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_last_updated_by));
2288: FETCH emp_infor_csr INTO l_emp_id;
2289: CLOSE emp_infor_csr;
2290:
2291: WF_DIRECTORY.GetRoleName(

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

2310: );
2311:
2312: --
2313: IF l_batch_status is null THEN
2314: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_NULL');
2315: RAISE FND_API.G_EXC_ERROR;
2316: END IF;
2317:
2318:

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

2328: SET status_code = l_batch_next_status
2329: WHERE resale_batch_id = l_resale_batch_id;
2330:
2331: ELSE
2332: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_STATUS_ERR');
2333: RAISE FND_API.G_EXC_ERROR;
2334: END IF;
2335: END IF;
2336:

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

2423:
2424: l_batch_org_id NUMBER;
2425: BEGIN
2426: IF OZF_DEBUG_HIGH_ON THEN
2427: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2428: END IF;
2429:
2430: -- R12 MOAC Enhancement (+)
2431: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

2610: l_batch_org_id NUMBER;
2611:
2612: BEGIN
2613: IF OZF_DEBUG_HIGH_ON THEN
2614: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2615: END IF;
2616:
2617: -- R12 MOAC Enhancement (+)
2618: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

2797: l_batch_org_id NUMBER;
2798:
2799: BEGIN
2800: IF OZF_DEBUG_HIGH_ON THEN
2801: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2802: END IF;
2803:
2804: -- R12 MOAC Enhancement (+)
2805: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

2834: itemkey => itemkey,
2835: aname => G_WF_ATTR_BATCH_ID);
2836:
2837: IF OZF_DEBUG_LOW_ON THEN
2838: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
2839: END IF;
2840: IF l_batch_id IS NOT NULL THEN
2841: OZF_RESALE_COMMON_PVT.Validate_Batch (
2842: p_api_version => 1.0,

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

2849: x_msg_count => l_msg_count,
2850: x_msg_data => l_msg_data );
2851:
2852: IF OZF_DEBUG_LOW_ON THEN
2853: OZF_UTILITY_PVT.debug_message('Validate Batch is complete '||l_return_status);
2854: END IF;
2855: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2856: RAISE FND_API.G_EXC_ERROR;
2857: END IF;

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

2856: RAISE FND_API.G_EXC_ERROR;
2857: END IF;
2858: l_resultout := 'COMPLETE:SUCCESS';
2859: ELSE
2860: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
2861: RAISE FND_API.G_EXC_ERROR;
2862: END IF;
2863: l_resultout := 'COMPLETE:SUCCESS';
2864: --

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

2943:
2944: l_batch_org_id NUMBER;
2945: BEGIN
2946: IF OZF_DEBUG_HIGH_ON THEN
2947: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2948: END IF;
2949:
2950: -- R12 MOAC Enhancement (+)
2951: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

2980: itemkey => itemkey,
2981: aname => G_WF_ATTR_BATCH_ID);
2982:
2983: IF OZF_DEBUG_LOW_ON THEN
2984: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
2985: END IF;
2986: IF l_batch_id IS NOT NULL THEN
2987: -- Verify the line information for this batch
2988: OZF_RESALE_COMMON_PVT.Validate_Order_Record (

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

2995: ,x_msg_data => l_msg_data
2996: ,x_msg_count => l_msg_count
2997: );
2998: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
2999: OZF_UTILITY_PVT.error_message('OZF_RESALE_VALIDATE_ERR');
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: ELSE
3003: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

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

2999: OZF_UTILITY_PVT.error_message('OZF_RESALE_VALIDATE_ERR');
3000: RAISE FND_API.G_EXC_ERROR;
3001: END IF;
3002: ELSE
3003: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3004: RAISE FND_API.G_EXC_ERROR;
3005: END IF;
3006:
3007: l_resultout := 'COMPLETE:SUCCESS';

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

3089: l_batch_org_id NUMBER;
3090:
3091: BEGIN
3092: IF OZF_DEBUG_HIGH_ON THEN
3093: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3094: END IF;
3095:
3096: -- R12 MOAC Enhancement (+)
3097: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

3125: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3126: itemkey => itemkey,
3127: aname => G_WF_ATTR_BATCH_ID);
3128: IF OZF_DEBUG_LOW_ON THEN
3129: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3130: END IF;
3131:
3132: IF l_batch_id IS NOT NULL THEN
3133: -- Verify the line information for this batch

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

3141: ,x_msg_data => l_msg_data
3142: ,x_msg_count => l_msg_count
3143: );
3144: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3145: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3146: RAISE FND_API.G_EXC_ERROR;
3147: END IF;
3148: ELSE
3149: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

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

3145: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3146: RAISE FND_API.G_EXC_ERROR;
3147: END IF;
3148: ELSE
3149: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3150: RAISE FND_API.G_EXC_ERROR;
3151: END IF;
3152: l_resultout := 'COMPLETE:SUCCESS';
3153: --

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

3233:
3234: l_batch_org_id NUMBER;
3235: BEGIN
3236: IF OZF_DEBUG_HIGH_ON THEN
3237: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3238: END IF;
3239:
3240: -- R12 MOAC Enhancement (+)
3241: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

3269: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3270: itemkey => itemkey,
3271: aname => G_WF_ATTR_BATCH_ID);
3272: IF OZF_DEBUG_LOW_ON THEN
3273: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3274: END IF;
3275:
3276: IF l_batch_id IS NOT NULL THEN
3277: -- Verify the line information for this batch

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

3285: ,x_msg_data => l_msg_data
3286: ,x_msg_count => l_msg_count
3287: );
3288: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3289: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;
3292: ELSE
3293: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

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

3289: OZF_UTILITY_PVT.error_message('OZF_RESALE_CHBK_VALIDATE_ERR');
3290: RAISE FND_API.G_EXC_ERROR;
3291: END IF;
3292: ELSE
3293: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3294: RAISE FND_API.G_EXC_ERROR;
3295: END IF;
3296: l_resultout := 'COMPLETE:SUCCESS';
3297: --

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

3378: l_batch_org_id NUMBER;
3379:
3380: BEGIN
3381: IF OZF_DEBUG_HIGH_ON THEN
3382: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3383: END IF;
3384:
3385: -- R12 MOAC Enhancement (+)
3386: l_batch_org_id := WF_ENGINE.GetItemAttrText(

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

3414: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3415: itemkey => itemkey,
3416: aname => G_WF_ATTR_BATCH_ID);
3417: IF OZF_DEBUG_LOW_ON THEN
3418: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3419: END IF;
3420:
3421: IF l_batch_id IS NOT NULL THEN
3422: -- Verify the line information for this batch

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

3430: ,x_msg_data => l_msg_data
3431: ,x_msg_count => l_msg_count
3432: );
3433: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
3434: OZF_UTILITY_PVT.error_message('OZF_RESALE_TRAC_VALIDATE_ERR');
3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;
3437: ELSE
3438: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');

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

3434: OZF_UTILITY_PVT.error_message('OZF_RESALE_TRAC_VALIDATE_ERR');
3435: RAISE FND_API.G_EXC_ERROR;
3436: END IF;
3437: ELSE
3438: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
3439: RAISE FND_API.G_EXC_ERROR;
3440: END IF;
3441: l_resultout := 'COMPLETE:SUCCESS';
3442: --

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

3560: itemKey => l_itemkey,
3561: userKey => l_itemuserkey
3562: );
3563:
3564: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_batch_info.last_updated_by));
3565: FETCH emp_infor_csr INTO l_emp_id;
3566: CLOSE emp_infor_csr;
3567:
3568: WF_DIRECTORY.GetRoleName(

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

3696: itemKey => l_itemkey,
3697: userKey => l_itemuserkey
3698: );
3699:
3700: OPEN emp_infor_csr(OZF_UTILITY_PVT.get_resource_id(l_batch_info.last_updated_by));
3701: FETCH emp_infor_csr INTO l_emp_id;
3702: CLOSE emp_infor_csr;
3703:
3704: WF_DIRECTORY.GetRoleName(