DBA Data[Home] [Help]

APPS.OZF_OM_PAYMENT_PVT dependencies on OZF_UTILITY_PVT

Line 286: OZF_Utility_PVT.debug_message('Claim Id = '|| p_claim_id);

282: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
283: FND_MSG_PUB.add;
284: END IF;
285: IF OZF_DEBUG_HIGH_ON THEN
286: OZF_Utility_PVT.debug_message('Claim Id = '|| p_claim_id);
287: OZF_Utility_PVT.debug_message('SQLERRM = '|| SQLERRM);
288: END IF;
289: x_return_status := FND_API.g_ret_sts_unexp_error;
290:

Line 287: OZF_Utility_PVT.debug_message('SQLERRM = '|| SQLERRM);

283: FND_MSG_PUB.add;
284: END IF;
285: IF OZF_DEBUG_HIGH_ON THEN
286: OZF_Utility_PVT.debug_message('Claim Id = '|| p_claim_id);
287: OZF_Utility_PVT.debug_message('SQLERRM = '|| SQLERRM);
288: END IF;
289: x_return_status := FND_API.g_ret_sts_unexp_error;
290:
291: END Query_Claim;

Line 500: OZF_Utility_PVT.debug_message(l_full_name||': start');

496:
497: BEGIN
498: -------------------- initialize -----------------------
499: IF OZF_DEBUG_HIGH_ON THEN
500: OZF_Utility_PVT.debug_message(l_full_name||': start');
501: END IF;
502:
503: x_return_status := FND_API.g_ret_sts_success;
504:

Line 566: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - order_type_id : '||l_header_rec.order_type_id);

562: l_header_rec.transactional_curr_code := p_x_claim_rec.currency_code;
563: l_header_rec.operation := OE_GLOBALS.g_opr_create;
564:
565: IF OZF_DEBUG_HIGH_ON THEN
566: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - order_type_id : '||l_header_rec.order_type_id);
567: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - sold_to_org_id : '||l_header_rec.sold_to_org_id);
568: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - invoice_to_org_id : '||l_header_rec.invoice_to_org_id);
569: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - ship_to_org_id : '||l_header_rec.ship_to_org_id);
570: END IF;

Line 567: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - sold_to_org_id : '||l_header_rec.sold_to_org_id);

563: l_header_rec.operation := OE_GLOBALS.g_opr_create;
564:
565: IF OZF_DEBUG_HIGH_ON THEN
566: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - order_type_id : '||l_header_rec.order_type_id);
567: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - sold_to_org_id : '||l_header_rec.sold_to_org_id);
568: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - invoice_to_org_id : '||l_header_rec.invoice_to_org_id);
569: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - ship_to_org_id : '||l_header_rec.ship_to_org_id);
570: END IF;
571:

Line 568: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - invoice_to_org_id : '||l_header_rec.invoice_to_org_id);

564:
565: IF OZF_DEBUG_HIGH_ON THEN
566: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - order_type_id : '||l_header_rec.order_type_id);
567: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - sold_to_org_id : '||l_header_rec.sold_to_org_id);
568: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - invoice_to_org_id : '||l_header_rec.invoice_to_org_id);
569: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - ship_to_org_id : '||l_header_rec.ship_to_org_id);
570: END IF;
571:
572: /*------------------------------------------------------*

Line 569: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - ship_to_org_id : '||l_header_rec.ship_to_org_id);

565: IF OZF_DEBUG_HIGH_ON THEN
566: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - order_type_id : '||l_header_rec.order_type_id);
567: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - sold_to_org_id : '||l_header_rec.sold_to_org_id);
568: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - invoice_to_org_id : '||l_header_rec.invoice_to_org_id);
569: OZF_Utility_PVT.debug_message(l_full_name||': RMA header - ship_to_org_id : '||l_header_rec.ship_to_org_id);
570: END IF;
571:
572: /*------------------------------------------------------*
573: | 2. Setting up line records

Line 637: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||': '||l_line_tbl(i).inventory_item_id||'/'||l_line_tbl(i).ordered_quantity||'/'||l_line_tbl(i).order_quantity_uom||'/'||l_line_tbl(i).unit_list_price);

633: --END IF;
634: l_line_tbl(i).operation := OE_GLOBALS.g_opr_create;
635:
636: IF OZF_DEBUG_HIGH_ON THEN
637: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||': '||l_line_tbl(i).inventory_item_id||'/'||l_line_tbl(i).ordered_quantity||'/'||l_line_tbl(i).order_quantity_uom||'/'||l_line_tbl(i).unit_list_price);
638: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' reference: '||l_line_tbl(i).return_context||'/'||l_line_tbl(i).return_attribute1||'/'||l_line_tbl(i).return_attribute2);
639: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);
640: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);
641: END IF;

Line 638: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' reference: '||l_line_tbl(i).return_context||'/'||l_line_tbl(i).return_attribute1||'/'||l_line_tbl(i).return_attribute2);

634: l_line_tbl(i).operation := OE_GLOBALS.g_opr_create;
635:
636: IF OZF_DEBUG_HIGH_ON THEN
637: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||': '||l_line_tbl(i).inventory_item_id||'/'||l_line_tbl(i).ordered_quantity||'/'||l_line_tbl(i).order_quantity_uom||'/'||l_line_tbl(i).unit_list_price);
638: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' reference: '||l_line_tbl(i).return_context||'/'||l_line_tbl(i).return_attribute1||'/'||l_line_tbl(i).return_attribute2);
639: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);
640: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);
641: END IF;
642: END IF;

Line 639: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);

635:
636: IF OZF_DEBUG_HIGH_ON THEN
637: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||': '||l_line_tbl(i).inventory_item_id||'/'||l_line_tbl(i).ordered_quantity||'/'||l_line_tbl(i).order_quantity_uom||'/'||l_line_tbl(i).unit_list_price);
638: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' reference: '||l_line_tbl(i).return_context||'/'||l_line_tbl(i).return_attribute1||'/'||l_line_tbl(i).return_attribute2);
639: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);
640: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);
641: END IF;
642: END IF;
643: EXIT WHEN i = p_claim_line_tbl.LAST;

Line 640: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);

636: IF OZF_DEBUG_HIGH_ON THEN
637: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||': '||l_line_tbl(i).inventory_item_id||'/'||l_line_tbl(i).ordered_quantity||'/'||l_line_tbl(i).order_quantity_uom||'/'||l_line_tbl(i).unit_list_price);
638: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' reference: '||l_line_tbl(i).return_context||'/'||l_line_tbl(i).return_attribute1||'/'||l_line_tbl(i).return_attribute2);
639: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);
640: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);
641: END IF;
642: END IF;
643: EXIT WHEN i = p_claim_line_tbl.LAST;
644: i := p_claim_line_tbl.NEXT(i);

Line 906: OZF_Utility_PVT.debug_message(l_full_name||': end');

902: END LOOP;
903: END IF;
904:
905: IF OZF_DEBUG_HIGH_ON THEN
906: OZF_Utility_PVT.debug_message(l_full_name||': end');
907: END IF;
908: EXCEPTION
909: WHEN FND_API.g_exc_error THEN
910: x_return_status := FND_API.g_ret_sts_error;

Line 1000: OZF_Utility_PVT.debug_message(l_full_name||': start');

996:
997: BEGIN
998: -------------------- initialize -----------------------
999: IF OZF_DEBUG_HIGH_ON THEN
1000: OZF_Utility_PVT.debug_message(l_full_name||': start');
1001: END IF;
1002:
1003: x_return_status := FND_API.g_ret_sts_success;
1004:

Line 1102: OZF_Utility_PVT.debug_message(l_full_name||': end');

1098: RAISE FND_API.g_exc_unexpected_error;
1099: END IF;
1100:
1101: IF OZF_DEBUG_HIGH_ON THEN
1102: OZF_Utility_PVT.debug_message(l_full_name||': end');
1103: END IF;
1104: EXCEPTION
1105: WHEN FND_API.g_exc_error THEN
1106: x_return_status := FND_API.g_ret_sts_error;

Line 1155: OZF_Utility_PVT.debug_message(l_full_name||': start');

1151: -------------------- initialize -----------------------
1152: SAVEPOINT Create_OM_Payment;
1153:
1154: IF OZF_DEBUG_HIGH_ON THEN
1155: OZF_Utility_PVT.debug_message(l_full_name||': start');
1156: END IF;
1157:
1158: IF FND_API.to_boolean(p_init_msg_list) THEN
1159: FND_MSG_PUB.initialize;

Line 1199: OZF_Utility_PVT.debug_message('Create RMA order for ==> '||l_claim_rec.claim_number);

1195: END IF;
1196:
1197: IF l_claim_rec.payment_method = 'RMA' THEN
1198: IF OZF_DEBUG_HIGH_ON THEN
1199: OZF_Utility_PVT.debug_message('Create RMA order for ==> '||l_claim_rec.claim_number);
1200: END IF;
1201: OZF_OM_PAYMENT_PVT.Complete_RMA_Order(
1202: p_x_claim_rec => l_claim_rec
1203: ,p_claim_line_tbl => l_claim_line_tbl

Line 1226: OZF_Utility_PVT.debug_message('Book RMA order for ==> '||l_claim_rec.claim_number);

1222: RAISE FND_API.g_exc_unexpected_error;
1223: END IF;
1224:
1225: IF OZF_DEBUG_HIGH_ON THEN
1226: OZF_Utility_PVT.debug_message('Book RMA order for ==> '||l_claim_rec.claim_number);
1227: OZF_Utility_PVT.debug_message('RMA order number = '||l_claim_rec.payment_reference_number);
1228: END IF;
1229: Book_RMA_Order(
1230: p_claim_rec => l_claim_rec

Line 1227: OZF_Utility_PVT.debug_message('RMA order number = '||l_claim_rec.payment_reference_number);

1223: END IF;
1224:
1225: IF OZF_DEBUG_HIGH_ON THEN
1226: OZF_Utility_PVT.debug_message('Book RMA order for ==> '||l_claim_rec.claim_number);
1227: OZF_Utility_PVT.debug_message('RMA order number = '||l_claim_rec.payment_reference_number);
1228: END IF;
1229: Book_RMA_Order(
1230: p_claim_rec => l_claim_rec
1231: ,p_claim_line_tbl => l_claim_line_tbl

Line 1265: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1261: p_data => x_msg_data
1262: );
1263:
1264: IF OZF_DEBUG_HIGH_ON THEN
1265: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1266: END IF;
1267: EXCEPTION
1268: WHEN FND_API.g_exc_error THEN
1269: ROLLBACK TO Create_OM_Payment;