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

639: --END IF;
640: l_line_tbl(i).operation := OE_GLOBALS.g_opr_create;
641:
642: IF OZF_DEBUG_HIGH_ON THEN
643: 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);
644: 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);
645: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);
646: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);
647: END IF;

Line 644: 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);

640: l_line_tbl(i).operation := OE_GLOBALS.g_opr_create;
641:
642: IF OZF_DEBUG_HIGH_ON THEN
643: 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);
644: 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);
645: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);
646: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);
647: END IF;
648: END IF;

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

641:
642: IF OZF_DEBUG_HIGH_ON THEN
643: 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);
644: 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);
645: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);
646: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);
647: END IF;
648: END IF;
649: EXIT WHEN i = p_claim_line_tbl.LAST;

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

642: IF OZF_DEBUG_HIGH_ON THEN
643: 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);
644: 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);
645: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' return_reason_code : '||l_line_tbl(i).return_reason_code);
646: OZF_Utility_PVT.debug_message(l_full_name||': RMA line'||i||' line_type_id : '||l_line_tbl(i).line_type_id);
647: END IF;
648: END IF;
649: EXIT WHEN i = p_claim_line_tbl.LAST;
650: i := p_claim_line_tbl.NEXT(i);

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

908: END LOOP;
909: END IF;
910:
911: IF OZF_DEBUG_HIGH_ON THEN
912: OZF_Utility_PVT.debug_message(l_full_name||': end');
913: END IF;
914: EXCEPTION
915: WHEN FND_API.g_exc_error THEN
916: x_return_status := FND_API.g_ret_sts_error;

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

1002:
1003: BEGIN
1004: -------------------- initialize -----------------------
1005: IF OZF_DEBUG_HIGH_ON THEN
1006: OZF_Utility_PVT.debug_message(l_full_name||': start');
1007: END IF;
1008:
1009: x_return_status := FND_API.g_ret_sts_success;
1010:

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

1104: RAISE FND_API.g_exc_unexpected_error;
1105: END IF;
1106:
1107: IF OZF_DEBUG_HIGH_ON THEN
1108: OZF_Utility_PVT.debug_message(l_full_name||': end');
1109: END IF;
1110: EXCEPTION
1111: WHEN FND_API.g_exc_error THEN
1112: x_return_status := FND_API.g_ret_sts_error;

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

1157: -------------------- initialize -----------------------
1158: SAVEPOINT Create_OM_Payment;
1159:
1160: IF OZF_DEBUG_HIGH_ON THEN
1161: OZF_Utility_PVT.debug_message(l_full_name||': start');
1162: END IF;
1163:
1164: IF FND_API.to_boolean(p_init_msg_list) THEN
1165: FND_MSG_PUB.initialize;

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

1201: END IF;
1202:
1203: IF l_claim_rec.payment_method = 'RMA' THEN
1204: IF OZF_DEBUG_HIGH_ON THEN
1205: OZF_Utility_PVT.debug_message('Create RMA order for ==> '||l_claim_rec.claim_number);
1206: END IF;
1207: OZF_OM_PAYMENT_PVT.Complete_RMA_Order(
1208: p_x_claim_rec => l_claim_rec
1209: ,p_claim_line_tbl => l_claim_line_tbl

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

1228: RAISE FND_API.g_exc_unexpected_error;
1229: END IF;
1230:
1231: IF OZF_DEBUG_HIGH_ON THEN
1232: OZF_Utility_PVT.debug_message('Book RMA order for ==> '||l_claim_rec.claim_number);
1233: OZF_Utility_PVT.debug_message('RMA order number = '||l_claim_rec.payment_reference_number);
1234: END IF;
1235: Book_RMA_Order(
1236: p_claim_rec => l_claim_rec

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

1229: END IF;
1230:
1231: IF OZF_DEBUG_HIGH_ON THEN
1232: OZF_Utility_PVT.debug_message('Book RMA order for ==> '||l_claim_rec.claim_number);
1233: OZF_Utility_PVT.debug_message('RMA order number = '||l_claim_rec.payment_reference_number);
1234: END IF;
1235: Book_RMA_Order(
1236: p_claim_rec => l_claim_rec
1237: ,p_claim_line_tbl => l_claim_line_tbl

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

1267: p_data => x_msg_data
1268: );
1269:
1270: IF OZF_DEBUG_HIGH_ON THEN
1271: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1272: END IF;
1273: EXCEPTION
1274: WHEN FND_API.g_exc_error THEN
1275: ROLLBACK TO Create_OM_Payment;