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 71: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

895:
896:
897: -- Debug Message
898: IF OZF_DEBUG_HIGH_ON THEN
899: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
900: END IF;
901:
902: IF p_resale_batch_id is null THEN
903: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_ID_NULL');

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

899: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
900: END IF;
901:
902: IF p_resale_batch_id is null THEN
903: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_ID_NULL');
904: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_ID_NULL');
905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
906: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
907: GOTO PROC_RESALE_END;

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

918: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;
919: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
920:
921: IF l_batch_type is null THEN
922: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_BATCH_TYPE_NULL');
923: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_BATCH_TYPE_NULL');
924: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Error : '||FND_MESSAGE.get);
925: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
926: GOTO PROC_RESALE_END;

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

927: END IF;
928:
929: /*
930: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
931: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_RESALE_DUP_PROCESS_TP');
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934: */
935:

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

953: <>
954:
955: -- Debug Message
956: IF OZF_DEBUG_HIGH_ON THEN
957: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
958: END IF;
959: --Standard call to get message count and if count=1, get the message
960: FND_MSG_PUB.Count_And_Get (
961: p_encoded => FND_API.G_FALSE,

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

1075: x_return_status := FND_API.G_RET_STS_SUCCESS;
1076:
1077: -- Debug Message
1078: IF OZF_DEBUG_HIGH_ON THEN
1079: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1080: END IF;
1081:
1082: -- Bug 4518607 (+)
1083: /*

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

1102:
1103: IF l_start_date IS NOT NULL AND
1104: l_end_date IS NOT NULL AND
1105: l_start_date > l_end_date THEN
1106: ozf_utility_pvt.error_message('OZF_RESALE_WNG_DATE_RANGE');
1107: FND_MESSAGE.set_name('OZF', 'OZF_RESALE_WNG_DATE_RANGE');
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Error : '||FND_MESSAGE.get);
1109: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: GOTO PROC_RESALE_2_END;

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

1150: ,x_msg_count => l_msg_count
1151: ,x_batch_status => x_batch_status -- For TPA Parallel Execution ER
1152: );
1153: IF l_return_status = FND_API.g_ret_sts_error THEN
1154: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1155: RAISE FND_API.G_EXC_ERROR;
1156: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1157: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1153: IF l_return_status = FND_API.g_ret_sts_error THEN
1154: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1155: RAISE FND_API.G_EXC_ERROR;
1156: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1157: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1159: END IF;
1160:
1161: -- For TPA Parallel Execution ER - 9614703 (+)

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

1172:
1173: END LOOP;
1174: ELSE
1175: IF OZF_DEBUG_LOW_ON THEN
1176: OZF_UTILITY_PVT.debug_message('No batch is specified.');
1177: END IF;
1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'No batches found to be process.');
1179: END IF;
1180:

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

1182: <>
1183:
1184: -- Debug Message
1185: IF OZF_DEBUG_HIGH_ON THEN
1186: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1187: END IF;
1188: --Standard call to get message count and if count=1, get the message
1189: FND_MSG_PUB.Count_And_Get (
1190: p_encoded => FND_API.G_FALSE,

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

1280: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1281: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
1282: -- Debug Message
1283: IF OZF_DEBUG_LOW_ON THEN
1284: ozf_utility_PVT.debug_message(l_full_name||': start');
1285: END IF;
1286:
1287: IF p_resale_batch_id is NULL THEN
1288:

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

1309: ,x_msg_count => l_msg_count
1310: );
1311:
1312: IF l_return_status = FND_API.g_ret_sts_error THEN
1313: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1314: RAISE FND_API.g_exc_error;
1315: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1316: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1317: RAISE FND_API.g_exc_unexpected_error;

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

1312: IF l_return_status = FND_API.g_ret_sts_error THEN
1313: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1314: RAISE FND_API.g_exc_error;
1315: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1316: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1317: RAISE FND_API.g_exc_unexpected_error;
1318: END IF;
1319: ELSE
1320: Process_resale (

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

1327: ,x_msg_data => l_msg_data
1328: ,x_msg_count => l_msg_count
1329: );
1330: IF l_return_status = FND_API.g_ret_sts_error THEN
1331: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1332: RAISE FND_API.g_exc_error;
1333: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1334: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1335: RAISE FND_API.g_exc_unexpected_error;

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

1330: IF l_return_status = FND_API.g_ret_sts_error THEN
1331: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1332: RAISE FND_API.g_exc_error;
1333: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1334: ozf_utility_pvt.error_message('OZF_PROC_RESALE_ERR');
1335: RAISE FND_API.g_exc_unexpected_error;
1336: END IF;
1337: END IF;
1338:

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

1405: END IF;
1406:
1407: -- Debug Message
1408: IF OZF_DEBUG_HIGH_ON THEN
1409: OZF_UTILITY_PVT.debug_message(l_full_name||': end');
1410: END IF;
1411:
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));

Line 1417: OZF_UTILITY_PVT.Write_Conc_Log;

1413: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Ends On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1414: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1415:
1416: -- Write all messages to a log
1417: OZF_UTILITY_PVT.Write_Conc_Log;
1418: EXCEPTION
1419: WHEN FND_API.g_exc_error THEN
1420: OZF_UTILITY_PVT.Write_Conc_Log;
1421: ERRBUF := l_msg_data;

Line 1420: OZF_UTILITY_PVT.Write_Conc_Log;

1416: -- Write all messages to a log
1417: OZF_UTILITY_PVT.Write_Conc_Log;
1418: EXCEPTION
1419: WHEN FND_API.g_exc_error THEN
1420: OZF_UTILITY_PVT.Write_Conc_Log;
1421: ERRBUF := l_msg_data;
1422: RETCODE := 1;
1423:
1424: WHEN FND_API.g_exc_unexpected_error THEN

Line 1425: OZF_UTILITY_PVT.Write_Conc_Log;

1421: ERRBUF := l_msg_data;
1422: RETCODE := 1;
1423:
1424: WHEN FND_API.g_exc_unexpected_error THEN
1425: OZF_UTILITY_PVT.Write_Conc_Log;
1426: ERRBUF := l_msg_data;
1427: RETCODE := 2;
1428:
1429: WHEN OTHERS THEN

Line 1431: OZF_UTILITY_PVT.Write_Conc_Log;

1427: RETCODE := 2;
1428:
1429: WHEN OTHERS THEN
1430: ROLLBACK TO Start_PROC_RESALE;
1431: OZF_UTILITY_PVT.Write_Conc_Log;
1432: ERRBUF := l_msg_data;
1433: RETCODE := 2;
1434: END Start_Process_Resale;
1435:

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

1483: x_return_status := FND_API.G_RET_STS_SUCCESS;
1484:
1485: -- Debug Message
1486: IF OZF_DEBUG_HIGH_ON THEN
1487: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1488: END IF;
1489:
1490: IF p_resale_batch_id IS NULL THEN
1491: -- Purge the records that have been successfully processed

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

1576:
1577:
1578: -- Debug Message
1579: IF OZF_DEBUG_HIGH_ON THEN
1580: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1581: END IF;
1582: --Standard call to get message count and if count=1, get the message
1583: FND_MSG_PUB.Count_And_Get (
1584: p_encoded => FND_API.G_FALSE,

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

1649: SAVEPOINT Start_RESALE_Purge;
1650: RETCODE := 0;
1651: -- Debug Message
1652: IF OZF_DEBUG_HIGH_ON THEN
1653: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1654: END IF;
1655:
1656: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Start to purge processed order ---*/');
1657:

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

1666: ,x_msg_data => l_msg_data
1667: ,x_msg_count => l_msg_count
1668: );
1669: IF l_return_status = FND_API.g_ret_sts_error THEN
1670: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1671: RAISE FND_API.g_exc_error;
1672: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1673: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1674: RAISE FND_API.g_exc_unexpected_error;

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

1669: IF l_return_status = FND_API.g_ret_sts_error THEN
1670: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1671: RAISE FND_API.g_exc_error;
1672: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1673: ozf_utility_pvt.error_message('OZF_PURGE_CHG_INT_ERR');
1674: RAISE FND_API.g_exc_unexpected_error;
1675: END IF;
1676:
1677: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End of purge processed order ---*/');

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

1677: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- End of purge processed order ---*/');
1678:
1679: -- Debug Message
1680: IF OZF_DEBUG_HIGH_ON THEN
1681: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1682: END IF;
1683:
1684: -- Write all messages to a log
1685: OZF_UTILITY_PVT.Write_Conc_Log;

Line 1685: OZF_UTILITY_PVT.Write_Conc_Log;

1681: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1682: END IF;
1683:
1684: -- Write all messages to a log
1685: OZF_UTILITY_PVT.Write_Conc_Log;
1686: EXCEPTION
1687: WHEN FND_API.g_exc_error THEN
1688: ROLLBACK TO Start_RESALE_Purge;
1689: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');

Line 1690: OZF_UTILITY_PVT.Write_Conc_Log;

1686: EXCEPTION
1687: WHEN FND_API.g_exc_error THEN
1688: ROLLBACK TO Start_RESALE_Purge;
1689: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1690: OZF_UTILITY_PVT.Write_Conc_Log;
1691: ERRBUF := l_msg_data;
1692: RETCODE := 1;
1693:
1694: WHEN FND_API.g_exc_unexpected_error THEN

Line 1697: OZF_UTILITY_PVT.Write_Conc_Log;

1693:
1694: WHEN FND_API.g_exc_unexpected_error THEN
1695: ROLLBACK TO Start_RESALE_Purge;
1696: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1697: OZF_UTILITY_PVT.Write_Conc_Log;
1698: ERRBUF := l_msg_data;
1699: RETCODE := 2;
1700:
1701: WHEN OTHERS THEN

Line 1704: OZF_UTILITY_PVT.Write_Conc_Log;

1700:
1701: WHEN OTHERS THEN
1702: ROLLBACK TO Start_RESALE_Purge;
1703: FND_FILE.PUT_LINE(FND_FILE.LOG, '/*--- Error happened during purge ---*/');
1704: OZF_UTILITY_PVT.Write_Conc_Log;
1705: ERRBUF := l_msg_data;
1706: RETCODE := 2;
1707:
1708: END Start_Purge;