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_PVT dependencies on OZF_UTILITY_PVT

Line 70: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

66: END IF;
67:
68: -- Debug Message
69: IF OZF_DEBUG_HIGH_ON THEN
70: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
71: END IF;
72:
73: --Initialize message list if p_init_msg_list is TRUE.
74: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 88: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');

84:
85: IF l_org_id is not null THEN
86: fnd_client_info.set_org_context(to_char(l_org_id));
87: ELSE
88: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);

Line 97: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');

93: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;
94: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
95:
96: IF l_batch_type is null THEN
97: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100:
101: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN

Line 115: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');

111: ,x_msg_count => l_msg_count
112: );
113:
114: IF l_return_status = FND_API.g_ret_sts_error THEN
115: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
119: RAISE FND_API.g_exc_unexpected_error;

Line 118: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');

114: IF l_return_status = FND_API.g_ret_sts_error THEN
115: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PAYMNT_ERR');
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
122:

Line 135: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');

131: ,x_msg_count => l_msg_count
132: );
133:
134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
136: RAISE FND_API.g_exc_error;
137: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
138: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
139: RAISE FND_API.g_exc_unexpected_error;

Line 138: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');

134: IF l_return_status = FND_API.g_ret_sts_error THEN
135: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
136: RAISE FND_API.g_exc_error;
137: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
138: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PAYMNT_ERR');
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
142:

Line 155: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');

151: ,x_msg_count => l_msg_count
152: );
153:
154: IF l_return_status = FND_API.g_ret_sts_error THEN
155: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
156: RAISE FND_API.g_exc_error;
157: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
158: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
159: RAISE FND_API.g_exc_unexpected_error;

Line 158: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');

154: IF l_return_status = FND_API.g_ret_sts_error THEN
155: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
156: RAISE FND_API.g_exc_error;
157: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
158: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PAYMNT_ERR');
159: RAISE FND_API.g_exc_unexpected_error;
160: END IF;
161: END IF;
162:

Line 165: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

161: END IF;
162:
163: -- Debug Message
164: IF OZF_DEBUG_HIGH_ON THEN
165: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
166: END IF;
167: --Standard call to get message count and if count=1, get the message
168: FND_MSG_PUB.Count_And_Get (
169: p_encoded => FND_API.G_FALSE,

Line 237: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

233:
234: l_error_msg varchar2(4000);
235: BEGIN
236: IF OZF_DEBUG_HIGH_ON THEN
237: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
238: END IF;
239:
240: IF (funcmode = 'RUN') THEN
241: l_resale_batch_id := wf_engine.GetItemAttrText(itemtype => itemtype,

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

251: ,x_msg_data => l_msg_data
252: ,x_msg_count => l_msg_count
253: );
254: IF OZF_DEBUG_LOW_ON THEN
255: OZF_UTILITY_PVT.debug_message('subscribe process iface is complete ');
256: END IF;
257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;

Line 389: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

385: END IF;
386:
387: -- Debug Message
388: IF OZF_DEBUG_HIGH_ON THEN
389: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
390: END IF;
391:
392: -- Initialize API return status to sucess
393: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 402: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');

398:
399: IF l_org_id is not null THEN
400: fnd_client_info.set_org_context(to_char(l_org_id));
401: ELSE
402: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_ORG_ID_NOTFOUND');
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405:
406: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);

Line 412: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');

408: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
409:
410: -- Make sure that batch type is not null
411: IF l_batch_type is null THEN
412: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
414: END IF;
415:
416: -- Remove any log associated with this batch

Line 423: OZF_UTILITY_PVT.error_message('OZF_RESALE_DEL_LOG_ERR');

419: WHERE resale_id_type = 'BATCH'
420: AND resale_id = p_resale_batch_id;
421: EXCEPTION
422: WHEN OTHERS THEN
423: OZF_UTILITY_PVT.error_message('OZF_RESALE_DEL_LOG_ERR');
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END;
426:
427: -- Varify the line information for this batch

Line 441: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_VALIDATE_ERR');

437: ,x_msg_count => l_msg_count
438: );
439:
440: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
441: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_VALIDATE_ERR');
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- set disputed_code to null for the lines to be processed.

Line 489: OZF_UTILITY_PVT.debug_message('OZF_RESALE_REJECTED');

485: END IF;
486:
487: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED THEN
488: IF OZF_DEBUG_LOW_ON THEN
489: OZF_UTILITY_PVT.debug_message('OZF_RESALE_REJECTED');
490: END IF;
491: ELSE
492: -- Varify the line information for this batch
493: OZF_RESALE_COMMON_PVT.Validate_Order_Record(

Line 504: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_VALIDATE_ERR');

500: ,x_msg_data => l_msg_data
501: ,x_msg_count => l_msg_count
502: );
503: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
504: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_VALIDATE_ERR');
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507:
508: -- Call different validation here.

Line 523: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TP_VALIDATE_ERR');

519: ,x_msg_data => l_msg_data
520: ,x_msg_count => l_msg_count
521: );
522: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
523: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TP_VALIDATE_ERR');
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
527: OZF_CHARGEBACK_PVT.Validate_Order_Record(

Line 538: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_VALIDATE_ERR');

534: ,x_msg_data => l_msg_data
535: ,x_msg_count => l_msg_count
536: );
537: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
538: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_VALIDATE_ERR');
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: END IF;
541: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
542: OZF_SPECIAL_PRICING_PVT.Validate_Order_Record(

Line 553: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_VALIDATE_ERR');

549: ,x_msg_data => l_msg_data
550: ,x_msg_count => l_msg_count
551: );
552: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
553: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_VALIDATE_ERR');
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
555: END IF;
556: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
557: OZF_TRACING_ORDER_PVT.Validate_Order_Record(

Line 568: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_VALIDATE_ERR');

564: ,x_msg_data => l_msg_data
565: ,x_msg_count => l_msg_count
566: );
567: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
568: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_VALIDATE_ERR');
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571: ELSE
572: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');

Line 572: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');

568: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_VALIDATE_ERR');
569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
570: END IF;
571: ELSE
572: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');
573: RAISE FND_API.g_exc_unexpected_error;
574: END IF;
575:
576: /*

Line 604: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TP_PROC_ERR');

600: ,x_msg_count => l_msg_count
601: );
602:
603: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
604: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TP_PROC_ERR');
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN
608: OZF_CHARGEBACK_PVT.Process_Order(

Line 619: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PROC_ERR');

615: ,x_msg_data => l_msg_data
616: ,x_msg_count => l_msg_count
617: );
618: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
619: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_CHBK_PROC_ERR');
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621: END IF;
622: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN
623: OZF_SPECIAL_PRICING_PVT.Process_Order(

Line 634: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PROC_ERR');

630: ,x_msg_data => l_msg_data
631: ,x_msg_count => l_msg_count
632: );
633: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
634: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_SPP_PROC_ERR');
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END IF;
637: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN
638: OZF_TRACING_ORDER_PVT.Process_Order(

Line 650: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PROC_ERR');

646: ,x_msg_count => l_msg_count
647: );
648:
649: IF l_return_status<> FND_API.G_RET_STS_SUCCESS THEN
650: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PROC_ERR');
651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653: ELSE
654: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');

Line 654: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');

650: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_TRAC_PROC_ERR');
651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653: ELSE
654: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_WNG_BATCH_TYPE');
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: END IF; -- IF status is not rejected.
658:

Line 661: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');

657: END IF; -- IF status is not rejected.
658:
659: -- Debug Message
660: IF OZF_DEBUG_HIGH_ON THEN
661: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
662: END IF;
663: --Standard call to get message count and if count=1, get the message
664: FND_MSG_PUB.Count_And_Get (
665: p_encoded => FND_API.G_FALSE,

Line 730: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

726:
727: l_error_msg varchar2(4000);
728: BEGIN
729: IF OZF_DEBUG_HIGH_ON THEN
730: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
731: END IF;
732:
733: IF (funcmode = 'RUN') THEN
734: l_resale_batch_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 855: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

851:
852:
853: -- Debug Message
854: IF OZF_DEBUG_HIGH_ON THEN
855: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
856: END IF;
857:
858: IF p_resale_batch_id is null THEN
859: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_ID_NULL');

Line 859: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_ID_NULL');

855: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
856: END IF;
857:
858: IF p_resale_batch_id is null THEN
859: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_ID_NULL');
860: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_ID_NULL');
861: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
862: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: GOTO PROC_RESALE_END;

Line 878: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');

874: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;
875: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
876:
877: IF l_batch_type is null THEN
878: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
879: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_TYPE_NULL');
880: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : '||FND_MESSAGE.get);
881: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: GOTO PROC_RESALE_END;

Line 887: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_DUP_PROCESS_TP');

883: END IF;
884:
885: /*
886: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
887: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_DUP_PROCESS_TP');
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890: */
891:

Line 913: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

909: <>
910:
911: -- Debug Message
912: IF OZF_DEBUG_HIGH_ON THEN
913: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
914: END IF;
915: --Standard call to get message count and if count=1, get the message
916: FND_MSG_PUB.Count_And_Get (
917: p_encoded => FND_API.G_FALSE,

Line 1034: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1030: x_return_status := FND_API.G_RET_STS_SUCCESS;
1031:
1032: -- Debug Message
1033: IF OZF_DEBUG_HIGH_ON THEN
1034: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1035: END IF;
1036:
1037: -- Bug 4518607 (+)
1038: /*

Line 1061: ozf_utility_pvt.error_message('OZF_RESALE_WNG_DATE_RANGE');

1057:
1058: IF l_start_date IS NOT NULL AND
1059: l_end_date IS NOT NULL AND
1060: l_start_date > l_end_date THEN
1061: ozf_utility_pvt.error_message('OZF_RESALE_WNG_DATE_RANGE');
1062: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_WNG_DATE_RANGE');
1063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
1064: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: GOTO PROC_RESALE_2_END;

Line 1108: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

1104: ,x_msg_data => l_msg_data
1105: ,x_msg_count => l_msg_count
1106: );
1107: IF l_return_status = FND_API.g_ret_sts_error THEN
1108: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1109: RAISE FND_API.G_EXC_ERROR;
1110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1111: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1111: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

1107: IF l_return_status = FND_API.g_ret_sts_error THEN
1108: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1109: RAISE FND_API.G_EXC_ERROR;
1110: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1111: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114: END LOOP;
1115: ELSE

Line 1117: OZF_UTILITY_PVT.debug_message('No batch is specified.');

1113: END IF;
1114: END LOOP;
1115: ELSE
1116: IF OZF_DEBUG_LOW_ON THEN
1117: OZF_UTILITY_PVT.debug_message('No batch is specified.');
1118: END IF;
1119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No batches found to be process.');
1120: END IF;
1121:

Line 1127: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1123: <>
1124:
1125: -- Debug Message
1126: IF OZF_DEBUG_HIGH_ON THEN
1127: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1128: END IF;
1129: --Standard call to get message count and if count=1, get the message
1130: FND_MSG_PUB.Count_And_Get (
1131: p_encoded => FND_API.G_FALSE,

Line 1212: ozf_utility_PVT.debug_message(l_full_name||': start');

1208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1209: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1210: -- Debug Message
1211: IF OZF_DEBUG_LOW_ON THEN
1212: ozf_utility_PVT.debug_message(l_full_name||': start');
1213: END IF;
1214:
1215: IF p_resale_batch_id is NULL THEN
1216: Process_resale (

Line 1229: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

1225: ,x_msg_data => l_msg_data
1226: ,x_msg_count => l_msg_count
1227: );
1228: IF l_return_status = FND_API.g_ret_sts_error THEN
1229: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1230: RAISE FND_API.g_exc_error;
1231: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1232: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1233: RAISE FND_API.g_exc_unexpected_error;

Line 1232: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

1228: IF l_return_status = FND_API.g_ret_sts_error THEN
1229: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1230: RAISE FND_API.g_exc_error;
1231: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1232: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1233: RAISE FND_API.g_exc_unexpected_error;
1234: END IF;
1235: ELSE
1236: Process_resale (

Line 1247: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

1243: ,x_msg_data => l_msg_data
1244: ,x_msg_count => l_msg_count
1245: );
1246: IF l_return_status = FND_API.g_ret_sts_error THEN
1247: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1248: RAISE FND_API.g_exc_error;
1249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1250: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1251: RAISE FND_API.g_exc_unexpected_error;

Line 1250: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');

1246: IF l_return_status = FND_API.g_ret_sts_error THEN
1247: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1248: RAISE FND_API.g_exc_error;
1249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1250: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1251: RAISE FND_API.g_exc_unexpected_error;
1252: END IF;
1253: END IF;
1254:

Line 1257: OZF_UTILITY_PVT.debug_message(l_full_name||': end');

1253: END IF;
1254:
1255: -- Debug Message
1256: IF OZF_DEBUG_HIGH_ON THEN
1257: OZF_UTILITY_PVT.debug_message(l_full_name||': end');
1258: END IF;
1259:
1260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 1265: OZF_UTILITY_PVT.Write_Conc_Log;

1261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1263:
1264: -- Write all messages to a log
1265: OZF_UTILITY_PVT.Write_Conc_Log;
1266: EXCEPTION
1267: WHEN FND_API.g_exc_error THEN
1268: OZF_UTILITY_PVT.Write_Conc_Log;
1269: ERRBUF := l_msg_data;

Line 1268: OZF_UTILITY_PVT.Write_Conc_Log;

1264: -- Write all messages to a log
1265: OZF_UTILITY_PVT.Write_Conc_Log;
1266: EXCEPTION
1267: WHEN FND_API.g_exc_error THEN
1268: OZF_UTILITY_PVT.Write_Conc_Log;
1269: ERRBUF := l_msg_data;
1270: RETCODE := 1;
1271:
1272: WHEN FND_API.g_exc_unexpected_error THEN

Line 1273: OZF_UTILITY_PVT.Write_Conc_Log;

1269: ERRBUF := l_msg_data;
1270: RETCODE := 1;
1271:
1272: WHEN FND_API.g_exc_unexpected_error THEN
1273: OZF_UTILITY_PVT.Write_Conc_Log;
1274: ERRBUF := l_msg_data;
1275: RETCODE := 2;
1276:
1277: WHEN OTHERS THEN

Line 1279: OZF_UTILITY_PVT.Write_Conc_Log;

1275: RETCODE := 2;
1276:
1277: WHEN OTHERS THEN
1278: ROLLBACK TO Start_PROC_RESALE;
1279: OZF_UTILITY_PVT.Write_Conc_Log;
1280: ERRBUF := l_msg_data;
1281: RETCODE := 2;
1282: END Start_Process_Resale;
1283:

Line 1335: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1331: x_return_status := FND_API.G_RET_STS_SUCCESS;
1332:
1333: -- Debug Message
1334: IF OZF_DEBUG_HIGH_ON THEN
1335: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1336: END IF;
1337:
1338: IF p_resale_batch_id IS NULL THEN
1339: -- Purge the records that have been successfully processed

Line 1428: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1424:
1425:
1426: -- Debug Message
1427: IF OZF_DEBUG_HIGH_ON THEN
1428: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1429: END IF;
1430: --Standard call to get message count and if count=1, get the message
1431: FND_MSG_PUB.Count_And_Get (
1432: p_encoded => FND_API.G_FALSE,

Line 1501: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

1497: SAVEPOINT Start_RESALE_Purge;
1498: RETCODE := 0;
1499: -- Debug Message
1500: IF OZF_DEBUG_HIGH_ON THEN
1501: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1502: END IF;
1503:
1504: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start to purge processed order ---*/');
1505:

Line 1518: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');

1514: ,x_msg_data => l_msg_data
1515: ,x_msg_count => l_msg_count
1516: );
1517: IF l_return_status = FND_API.g_ret_sts_error THEN
1518: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1519: RAISE FND_API.g_exc_error;
1520: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1521: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1522: RAISE FND_API.g_exc_unexpected_error;

Line 1521: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');

1517: IF l_return_status = FND_API.g_ret_sts_error THEN
1518: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1519: RAISE FND_API.g_exc_error;
1520: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1521: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1522: RAISE FND_API.g_exc_unexpected_error;
1523: END IF;
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End of purge processed order ---*/');

Line 1529: OZF_UTILITY_PVT.debug_message(l_full_name||': End');

1525: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End of purge processed order ---*/');
1526:
1527: -- Debug Message
1528: IF OZF_DEBUG_HIGH_ON THEN
1529: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1530: END IF;
1531:
1532: -- Write all messages to a log
1533: OZF_UTILITY_PVT.Write_Conc_Log;

Line 1533: OZF_UTILITY_PVT.Write_Conc_Log;

1529: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1530: END IF;
1531:
1532: -- Write all messages to a log
1533: OZF_UTILITY_PVT.Write_Conc_Log;
1534: EXCEPTION
1535: WHEN FND_API.g_exc_error THEN
1536: ROLLBACK TO Start_RESALE_Purge;
1537: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');

Line 1538: OZF_UTILITY_PVT.Write_Conc_Log;

1534: EXCEPTION
1535: WHEN FND_API.g_exc_error THEN
1536: ROLLBACK TO Start_RESALE_Purge;
1537: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1538: OZF_UTILITY_PVT.Write_Conc_Log;
1539: ERRBUF := l_msg_data;
1540: RETCODE := 1;
1541:
1542: WHEN FND_API.g_exc_unexpected_error THEN

Line 1545: OZF_UTILITY_PVT.Write_Conc_Log;

1541:
1542: WHEN FND_API.g_exc_unexpected_error THEN
1543: ROLLBACK TO Start_RESALE_Purge;
1544: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1545: OZF_UTILITY_PVT.Write_Conc_Log;
1546: ERRBUF := l_msg_data;
1547: RETCODE := 2;
1548:
1549: WHEN OTHERS THEN

Line 1552: OZF_UTILITY_PVT.Write_Conc_Log;

1548:
1549: WHEN OTHERS THEN
1550: ROLLBACK TO Start_RESALE_Purge;
1551: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1552: OZF_UTILITY_PVT.Write_Conc_Log;
1553: ERRBUF := l_msg_data;
1554: RETCODE := 2;
1555:
1556: END Start_Purge;