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_RESALE_COMMON_PVT

Line 92: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);

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

Line 93: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;

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);
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');

Line 94: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

90: END IF;
91:
92: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
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;

Line 101: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK 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
102:
103: OZF_CHARGEBACK_PVT.Initiate_Payment(
104: p_api_version => 1
105: ,p_init_msg_list => FND_API.G_FALSE

Line 121: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN

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:
123: OZF_SPECIAL_PRICING_PVT.Initiate_Payment(
124: p_api_version => 1
125: ,p_init_msg_list => FND_API.G_FALSE

Line 141: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

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:
143: OZF_TRACING_ORDER_PVT.Initiate_Payment(
144: p_api_version => 1
145: ,p_init_msg_list => FND_API.G_FALSE

Line 335: l_open_lines_tbl OZF_RESALE_COMMON_PVT.interface_lines_tbl_type;

331: l_batch_count number;
332:
333: l_batch_type varchar2(30);
334: i number;
335: l_open_lines_tbl OZF_RESALE_COMMON_PVT.interface_lines_tbl_type;
336: --
337: l_disputed_count number;
338: l_duplicate_count number;
339: l_dup_line_id number;

Line 348: WHERE status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

344: /*
345: CURSOR open_lines_csr(p_id IN NUMBER) IS
346: SELECT *
347: FROM ozf_resale_lines_int
348: WHERE status_code =OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
349: AND resale_batch_id = p_id;
350: */
351:
352: CURSOR batch_count_csr(pc_batch_id NUMBER) IS

Line 360: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED

356:
357: CURSOR duplicate_count_csr(p_id NUMBER) IS
358: SELECT count(1)
359: FROM ozf_resale_lines_int
360: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED
361: AND resale_batch_id = p_id;
362:
363: CURSOR disputed_count_csr(p_id number) IS
364: SELECT count(1)

Line 366: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED

362:
363: CURSOR disputed_count_csr(p_id number) IS
364: SELECT count(1)
365: FROM ozf_resale_lines_int
366: WHERE status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED
367: AND resale_batch_id = p_id;
368: --
369: BEGIN
370: -- Standard begin of API savepoint

Line 406: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);

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);
407: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;
408: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;
409:
410: -- Make sure that batch type is not null

Line 407: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;

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);
407: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;
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

Line 408: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

404: END IF;
405:
406: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
407: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;
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');

Line 428: OZF_RESALE_COMMON_PVT.Validate_batch(

424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END;
426:
427: -- Varify the line information for this batch
428: OZF_RESALE_COMMON_PVT.Validate_batch(
429: p_api_version => 1
430: ,p_init_msg_list => FND_API.G_FALSE
431: ,p_commit => FND_API.G_FALSE
432: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 449: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;

445: -- set disputed_code to null for the lines to be processed.
446: update ozf_resale_lines_int
447: set dispute_code = null
448: where resale_batch_id = p_resale_batch_id
449: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
450:
451: -- update tracing order lines to processed for this order to be processed
452: update ozf_resale_lines_int
453: set status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED

Line 453: set status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED

449: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN;
450:
451: -- update tracing order lines to processed for this order to be processed
452: update ozf_resale_lines_int
453: set status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
454: where resale_batch_id = p_resale_batch_id
455: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
456: and tracing_flag = 'T';
457:

Line 455: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN

451: -- update tracing order lines to processed for this order to be processed
452: update ozf_resale_lines_int
453: set status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED
454: where resale_batch_id = p_resale_batch_id
455: and status_code= OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN
456: and tracing_flag = 'T';
457:
458: /*
459: i := 1;

Line 468: OZF_RESALE_COMMON_PVT.Update_Duplicates (

464: i:= i+1;
465: END LOOP;
466: CLOSE open_lines_csr;
467: */
468: OZF_RESALE_COMMON_PVT.Update_Duplicates (
469: p_api_version => 1.0,
470: p_init_msg_list => FND_API.G_FALSE,
471: p_commit => FND_API.G_FALSE,
472: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 487: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED THEN

483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 493: OZF_RESALE_COMMON_PVT.Validate_Order_Record(

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(
494: p_api_version => 1
495: ,p_init_msg_list => FND_API.G_FALSE
496: ,p_commit => FND_API.G_FALSE
497: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 510: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN

506: END IF;
507:
508: -- Call different validation here.
509: -- calling chargeback validation for this batch
510: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
511: OZF_TP_ACCRUAL_PVT.Validate_Order_Record(
512: p_api_version => 1
513: ,p_init_msg_list => FND_API.G_FALSE
514: ,p_commit => FND_API.G_FALSE

Line 526: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN

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(
528: p_api_version => 1
529: ,p_init_msg_list => FND_API.G_FALSE
530: ,p_commit => FND_API.G_FALSE

Line 541: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN

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(
543: p_api_version => 1
544: ,p_init_msg_list => FND_API.G_FALSE
545: ,p_commit => FND_API.G_FALSE

Line 556: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

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(
558: p_api_version => 1
559: ,p_init_msg_list => FND_API.G_FALSE
560: ,p_commit => FND_API.G_FALSE

Line 587: set status_code = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED

583: CLOSE batch_count_csr;
584:
585: IF l_duplicate_count = l_batch_count THEN
586: update ozf_resale_batches_all
587: set status_code = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED
588: where resale_batch_id = p_resale_batch_id;
589: ELSE
590: */
591: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN

Line 591: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN

587: set status_code = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED
588: where resale_batch_id = p_resale_batch_id;
589: ELSE
590: */
591: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN
592: OZF_TP_ACCRUAL_PVT.Process_Order(
593: p_api_version => 1
594: ,p_init_msg_list => FND_API.G_FALSE
595: ,p_commit => FND_API.G_FALSE

Line 607: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_CHARGEBACK THEN

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(
609: p_api_version => 1
610: ,p_init_msg_list => FND_API.G_FALSE
611: ,p_commit => FND_API.G_FALSE

Line 622: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_SPECIAL_PRICING THEN

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(
624: p_api_version => 1
625: ,p_init_msg_list => FND_API.G_FALSE
626: ,p_commit => FND_API.G_FALSE

Line 637: ELSIF l_batch_type = OZF_RESALE_COMMON_PVT.G_TRACING THEN

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(
639: p_api_version => 1
640: ,p_init_msg_list => FND_API.G_FALSE
641: ,p_commit => FND_API.G_FALSE

Line 873: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);

869:
870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Number : '||l_batch_number);
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
872:
873: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
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

Line 874: FETCH OZF_RESALE_COMMON_PVT.g_batch_type_csr into l_batch_type;

870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Batch Number : '||l_batch_number);
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
872:
873: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
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');

Line 875: CLOSE OZF_RESALE_COMMON_PVT.g_batch_type_csr;

871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
872:
873: OPEN OZF_RESALE_COMMON_PVT.g_batch_type_csr(p_resale_batch_id);
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');

Line 886: IF l_batch_type = OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL THEN

882: GOTO PROC_RESALE_END;
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: */