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

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

245: END IF;
246:
247: -- Debug Message
248: IF OZF_DEBUG_HIGH_ON THEN
249: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
250: END IF;
251:
252: -- Initialize API return status to sucess
253: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 275: ozf_utility_pvt.error_message('OZF_RESALE_OPEN_LINE_EXIST');

271: CLOSE OPEN_line_count_csr;
272:
273: IF l_count <> 0 THEN
274: --Can not pay if there is an OPEN line
275: ozf_utility_pvt.error_message('OZF_RESALE_OPEN_LINE_EXIST');
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: ELSE
278: -- There is no need to find a fund id for the SPECIAL PRICING REQUEST
279: l_chargeback_fund_id := NULL;

Line 318: ozf_utility_pvt.error_message('OZF_RESALE_INIT_INV_TMP_ERR');

314: ,x_msg_data => l_msg_data
315: );
316:
317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
318: ozf_utility_pvt.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321: */
322: -- Bug 4380203 (-)

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

344: END IF;
345:
346: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED THEN
347: IF OZF_DEBUG_LOW_ON THEN
348: OZF_UTILITY_PVT.debug_message('OZF_RESALE_REJECTED');
349: END IF;
350: ELSE
351: */
352: --i:=1;

Line 368: ozf_utility_PVT.debug_message('PROCESS ORDER: ');

364:
365: IF l_order_num_tbl.EXISTS(1) THEN
366: FOR k in 1..l_order_num_tbl.LAST LOOP
367: IF OZF_DEBUG_LOW_ON THEN
368: ozf_utility_PVT.debug_message('PROCESS ORDER: ');
369: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);
370: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);
371: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);
372: END IF;

Line 369: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);

365: IF l_order_num_tbl.EXISTS(1) THEN
366: FOR k in 1..l_order_num_tbl.LAST LOOP
367: IF OZF_DEBUG_LOW_ON THEN
368: ozf_utility_PVT.debug_message('PROCESS ORDER: ');
369: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);
370: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);
371: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);
372: END IF;
373:

Line 370: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);

366: FOR k in 1..l_order_num_tbl.LAST LOOP
367: IF OZF_DEBUG_LOW_ON THEN
368: ozf_utility_PVT.debug_message('PROCESS ORDER: ');
369: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);
370: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);
371: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);
372: END IF;
373:
374: -- beginjxwu header_fix

Line 371: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);

367: IF OZF_DEBUG_LOW_ON THEN
368: ozf_utility_PVT.debug_message('PROCESS ORDER: ');
369: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);
370: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);
371: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);
372: END IF;
373:
374: -- beginjxwu header_fix
375: -- Here, I assume if a line is the duplicate of another line, then they share

Line 440: ozf_utility_PVT.debug_message('Current line_int_id:' || l_valid_line_id_tbl(j).id);

436: -- I then try to create resale data.
437: For j in 1..l_valid_line_id_tbl.last
438: LOOP
439: IF OZF_DEBUG_LOW_ON THEN
440: ozf_utility_PVT.debug_message('Current line_int_id:' || l_valid_line_id_tbl(j).id);
441: END IF;
442:
443: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_valid_line_id_tbl(j).id);
444: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_line_int_rec;

Line 465: ozf_utility_PVT.debug_message('Did not pass inventory checking');

461: );
462:
463: IF not l_inventory_level_valid THEN
464: IF OZF_DEBUG_LOW_ON THEN
465: ozf_utility_PVT.debug_message('Did not pass inventory checking');
466: END IF;
467:
468: -- Here turn this line to disputed and create a disput code for it.
469: UPDATE ozf_resale_lines_int

Line 584: OZF_UTILITY_PVT.debug_message('line_id is '|| l_line_id);

580: ELSIF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN
581: l_line_id := l_line_int_rec.duplicated_line_id;
582: END IF;
583: IF OZF_DEBUG_LOW_ON THEN
584: OZF_UTILITY_PVT.debug_message('line_id is '|| l_line_id);
585: END IF;
586:
587: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED OR
588: l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN

Line 690: ozf_utility_pvt.error_message('OZF_UPD_RESALE_WRG','TEXT',l_full_name||': END');

686: paid_amount = l_amount_claimed
687: WHERE resale_batch_id = p_resale_batch_id;
688: EXCEPTION
689: WHEN OTHERS THEN
690: ozf_utility_pvt.error_message('OZF_UPD_RESALE_WRG','TEXT',l_full_name||': END');
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692: END;
693: END IF;
694: ELSE

Line 710: ozf_utility_pvt.error_message('OZF_UPD_RESALE_WRG','TEXT',l_full_name||': END');

706: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_CLOSED
707: WHERE resale_batch_id = p_resale_batch_id;
708: EXCEPTION
709: WHEN OTHERS THEN
710: ozf_utility_pvt.error_message('OZF_UPD_RESALE_WRG','TEXT',l_full_name||': END');
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: END;
713:
714:

Line 718: ozf_utility_pvt.error_message('OZF_RESALE_WRONG_STAUS_TO_PAY');

714:
715: END IF;
716: ELSE
717: -- Only disputed and processed batch can be paid.
718: ozf_utility_pvt.error_message('OZF_RESALE_WRONG_STAUS_TO_PAY');
719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
720: END IF;
721:
722: -- Debug Message

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

720: END IF;
721:
722: -- Debug Message
723: IF OZF_DEBUG_HIGH_ON THEN
724: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
725: END IF;
726: --Standard call to get message count and if count=1, get the message
727: FND_MSG_PUB.Count_And_Get (
728: p_encoded => FND_API.G_FALSE,

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

808: END IF;
809:
810: -- Debug Message
811: IF OZF_DEBUG_HIGH_ON THEN
812: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
813: END IF;
814:
815: -- Initialize API return status to sucess
816: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 851: OZF_UTILITY_PVT.error_message(

847: AND a.error_code ='OZF_RESALE_AGRM_TYPE_WNG'
848: );
849: EXCEPTION
850: WHEN OTHERS THEN
851: OZF_UTILITY_PVT.error_message(
852: p_message_name => 'OZF_INS_RESALE_LOG_WRG',
853: p_token_name => 'TEXT',
854: p_token_value => l_full_name||': END');
855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 871: OZF_UTILITY_PVT.error_message(

867: AND agreement_type <>'SPO'
868: AND resale_batch_id = p_resale_batch_id;
869: EXCEPTION
870: WHEN OTHERS THEN
871: OZF_UTILITY_PVT.error_message(
872: p_message_name => 'OZF_UPD_RESALE_INT_WRG',
873: p_token_name => 'TEXT',
874: p_token_value => l_full_name||': END');
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 911: OZF_UTILITY_PVT.error_message(

907: AND a.error_code ='OZF_RESALE_PUR_PRICE_MISSING'
908: );
909: EXCEPTION
910: WHEN OTHERS THEN
911: OZF_UTILITY_PVT.error_message(
912: p_message_name => 'OZF_INS_RESALE_LOG_WRG',
913: p_token_name => 'TEXT',
914: p_token_value => l_full_name||': END');
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 931: OZF_UTILITY_PVT.error_message(

927: AND purchase_price IS NULL
928: AND resale_batch_id = p_resale_batch_id;
929: EXCEPTION
930: WHEN OTHERS THEN
931: OZF_UTILITY_PVT.error_message(
932: p_message_name => 'OZF_UPD_RESALE_INT_WRG',
933: p_token_name => 'TEXT',
934: p_token_value => l_full_name||': END');
935: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

936: END;
937:
938: -- Debug Message
939: IF OZF_DEBUG_HIGH_ON THEN
940: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
941: END IF;
942: --Standard call to get message count and if count=1, get the message
943: FND_MSG_PUB.Count_And_Get (
944: p_encoded => FND_API.G_FALSE,

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

1180: x_return_status := FND_API.G_RET_STS_SUCCESS;
1181:
1182: -- Debug Message
1183: IF OZF_DEBUG_HIGH_ON THEN
1184: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
1185: END IF;
1186:
1187: -- bug # 6821886 fixed by ateotia (+)
1188: -- Before start process, clean up the data structures if necessary.

Line 1208: ozf_utility_PVT.debug_message(l_full_name || ' checking int line ' || l_all_order_set_tbl(i).resale_line_int_id);

1204: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1205: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1206:
1207: IF OZF_DEBUG_LOW_ON THEN
1208: ozf_utility_PVT.debug_message(l_full_name || ' checking int line ' || l_all_order_set_tbl(i).resale_line_int_id);
1209: ozf_utility_PVT.debug_message(l_full_name || ' inventory tracking ' || g_inventory_tracking);
1210: END IF;
1211:
1212: IF g_inventory_tracking = 'T' THEN

Line 1209: ozf_utility_PVT.debug_message(l_full_name || ' inventory tracking ' || g_inventory_tracking);

1205: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1206:
1207: IF OZF_DEBUG_LOW_ON THEN
1208: ozf_utility_PVT.debug_message(l_full_name || ' checking int line ' || l_all_order_set_tbl(i).resale_line_int_id);
1209: ozf_utility_PVT.debug_message(l_full_name || ' inventory tracking ' || g_inventory_tracking);
1210: END IF;
1211:
1212: IF g_inventory_tracking = 'T' THEN
1213: -- Check inventory level first

Line 1227: ozf_utility_PVT.debug_message(l_full_name || ' inventory checking not passed!!!');

1223: );
1224:
1225: IF NOT l_inventory_level_valid THEN
1226: IF OZF_DEBUG_LOW_ON THEN
1227: ozf_utility_PVT.debug_message(l_full_name || ' inventory checking not passed!!!');
1228: END IF;
1229:
1230: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1231: p_id_value => l_all_order_set_tbl(i).resale_line_int_id,

Line 1281: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);

1277: AND resale_batch_id = p_resale_batch_id; -- bug 5222273 */
1278: -- bug # 6821886 fixed by ateotia (-)
1279:
1280: IF OZF_DEBUG_LOW_ON THEN
1281: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);
1282: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||p_order_number||'---*/');
1283: ozf_utility_PVT.debug_message('/*--- And cusomter:'||p_sold_from_cust_account_id||'---*/');
1284: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1285: END IF;

Line 1282: ozf_utility_PVT.debug_message('/--- Processing order for order NUMBER:'||p_order_number||'---/');

1278: -- bug # 6821886 fixed by ateotia (-)
1279:
1280: IF OZF_DEBUG_LOW_ON THEN
1281: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);
1282: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||p_order_number||'---*/');
1283: ozf_utility_PVT.debug_message('/*--- And cusomter:'||p_sold_from_cust_account_id||'---*/');
1284: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1285: END IF;
1286:

Line 1283: ozf_utility_PVT.debug_message('/--- And cusomter:'||p_sold_from_cust_account_id||'---/');

1279:
1280: IF OZF_DEBUG_LOW_ON THEN
1281: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);
1282: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||p_order_number||'---*/');
1283: ozf_utility_PVT.debug_message('/*--- And cusomter:'||p_sold_from_cust_account_id||'---*/');
1284: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1285: END IF;
1286:
1287: -- Before start process, clean up the data structures if necessary.

Line 1284: ozf_utility_PVT.debug_message('/--- And date ordered:'||p_date_ordered||'---/');

1280: IF OZF_DEBUG_LOW_ON THEN
1281: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);
1282: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||p_order_number||'---*/');
1283: ozf_utility_PVT.debug_message('/*--- And cusomter:'||p_sold_from_cust_account_id||'---*/');
1284: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1285: END IF;
1286:
1287: -- Before start process, clean up the data structures if necessary.
1288: IF l_order_set_tbl.EXISTS(1) THEN

Line 1309: ozf_utility_PVT.debug_message('after order set:'||l_order_set_tbl.LAST);

1305: --END LOOP;
1306: CLOSE order_set_csr;
1307:
1308: IF OZF_DEBUG_LOW_ON THEN
1309: ozf_utility_PVT.debug_message('after order set:'||l_order_set_tbl.LAST);
1310: END IF;
1311:
1312: IF l_order_set_tbl.exists(1) THEN
1313: For J in 1..l_order_set_tbl.LAST LOOP

Line 1385: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);

1381: l_ship_from_stock_flag; --POS Batch Processing by profiles by ateotia
1382: CLOSE request_header_info_csr;
1383:
1384: IF OZF_DEBUG_LOW_ON THEN
1385: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);
1386: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);
1387: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);
1388: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);
1389: END IF;

Line 1386: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);

1382: CLOSE request_header_info_csr;
1383:
1384: IF OZF_DEBUG_LOW_ON THEN
1385: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);
1386: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);
1387: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);
1388: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);
1389: END IF;
1390: IF l_header_start_date IS NULL OR

Line 1387: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);

1383:
1384: IF OZF_DEBUG_LOW_ON THEN
1385: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);
1386: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);
1387: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);
1388: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);
1389: END IF;
1390: IF l_header_start_date IS NULL OR
1391: l_request_type_code IS NULL OR

Line 1388: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);

1384: IF OZF_DEBUG_LOW_ON THEN
1385: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);
1386: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);
1387: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);
1388: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);
1389: END IF;
1390: IF l_header_start_date IS NULL OR
1391: l_request_type_code IS NULL OR
1392: l_header_currency_code is NULL THEN

Line 1418: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1414: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1415: AND resale_batch_id = p_resale_batch_id;
1416: EXCEPTION
1417: WHEN OTHERS THEN
1418: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: END;
1421: goto END_LOOP;
1422: END IF;

Line 1425: OZF_UTILITY_PVT.debug_message(p_message_text => 'date_ordered' || l_order_set_tbl(J).date_ordered);

1421: goto END_LOOP;
1422: END IF;
1423:
1424: IF OZF_DEBUG_LOW_ON THEN
1425: OZF_UTILITY_PVT.debug_message(p_message_text => 'date_ordered' || l_order_set_tbl(J).date_ordered);
1426: END IF;
1427:
1428:
1429: IF l_order_set_tbl(J).date_ordered < l_header_start_date OR

Line 1457: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1453: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1454: AND resale_batch_id = p_resale_batch_id;
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1459: END;
1460: GOTO END_LOOP;
1461: END IF;

Line 1464: OZF_UTILITY_PVT.debug_message('line currency '||l_order_set_tbl(J).currency_code );

1460: GOTO END_LOOP;
1461: END IF;
1462:
1463: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1464: OZF_UTILITY_PVT.debug_message('line currency '||l_order_set_tbl(J).currency_code );
1465: END IF;
1466: IF l_order_set_tbl(J).currency_code <> l_header_currency_code THEN
1467: BEGIN
1468: UPDATE ozf_resale_lines_int

Line 1478: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1474: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1475: AND resale_batch_id = p_resale_batch_id;
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END;
1481: GOTO END_LOOP;
1482: END IF;

Line 1494: OZF_UTILITY_PVT.debug_message('In Bid request' );

1490: -- Validation on resale data is passed, only when bill_to/ ship_to is not null and equal to the
1491: -- end customer.
1492:
1493: IF OZF_DEBUG_LOW_ON THEN
1494: OZF_UTILITY_PVT.debug_message('In Bid request' );
1495: END IF;
1496: IF l_header_end_cust_party_id IS NOT NULL THEN
1497: -- One of the following should match
1498: IF (l_order_set_tbl(J).bill_to_party_id is not null AND

Line 1517: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1513: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1514: AND resale_batch_id = p_resale_batch_id;
1515: EXCEPTION
1516: WHEN OTHERS THEN
1517: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1519: END;
1520: GOTO END_LOOP;
1521: END IF;

Line 1539: OZF_UTILITY_PVT.debug_message('In Meet' );

1535: -- bill_to/ ship_to is not null and equal to the end customer
1536: -- end if;
1537: -- end if;
1538: IF OZF_DEBUG_LOW_ON THEN
1539: OZF_UTILITY_PVT.debug_message('In Meet' );
1540: END IF;
1541: -- One of the following should match
1542: IF l_header_reseller_party_id IS NOT NULL THEN
1543: IF (l_order_set_tbl(J).bill_to_party_id is NOT NULL AND

Line 1565: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1561: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1562: AND resale_batch_id = p_resale_batch_id;
1563: EXCEPTION
1564: WHEN OTHERS THEN
1565: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1567: END;
1568: GOTO END_LOOP;
1569: END IF;

Line 1583: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1579: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1580: AND resale_batch_id = p_resale_batch_id;
1581: EXCEPTION
1582: WHEN OTHERS THEN
1583: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END;
1586: GOTO END_LOOP;
1587: END IF;

Line 1608: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1604: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1605: AND resale_batch_id = p_resale_batch_id;
1606: EXCEPTION
1607: WHEN OTHERS THEN
1608: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1610: END;
1611: GOTO END_LOOP;
1612: END IF;

Line 1620: OZF_UTILITY_PVT.debug_message('In Offer id null' );

1616:
1617: IF l_offer_id IS NULL THEN
1618:
1619: IF OZF_DEBUG_LOW_ON THEN
1620: OZF_UTILITY_PVT.debug_message('In Offer id null' );
1621: END IF;
1622: BEGIN
1623: UPDATE ozf_resale_lines_int
1624: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

Line 1633: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1629: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1630: AND resale_batch_id = p_resale_batch_id;
1631: EXCEPTION
1632: WHEN OTHERS THEN
1633: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1635: END;
1636: GOTO END_LOOP;
1637: ELSE

Line 1640: OZF_UTILITY_PVT.debug_message('In Off invoice offer' );

1636: GOTO END_LOOP;
1637: ELSE
1638: IF l_offer_type = G_OFF_INVOICE_OFFER THEN
1639: IF OZF_DEBUG_LOW_ON THEN
1640: OZF_UTILITY_PVT.debug_message('In Off invoice offer' );
1641: END IF;
1642: BEGIN
1643: UPDATE ozf_resale_lines_int
1644: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

Line 1653: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1649: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1650: AND resale_batch_id = p_resale_batch_id;
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1655: END;
1656: GOTO END_LOOP;
1657: END IF;

Line 1684: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );

1680: l_request_line_apprv_min_qty;
1681: CLOSE request_line_info_csr;
1682:
1683: IF OZF_DEBUG_LOW_ON THEN
1684: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );
1685: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );
1686: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1687: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1688: END IF;

Line 1685: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );

1681: CLOSE request_line_info_csr;
1682:
1683: IF OZF_DEBUG_LOW_ON THEN
1684: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );
1685: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );
1686: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1687: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1688: END IF;
1689: IF l_request_line_id is NULL THEN

Line 1686: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );

1682:
1683: IF OZF_DEBUG_LOW_ON THEN
1684: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );
1685: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );
1686: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1687: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1688: END IF;
1689: IF l_request_line_id is NULL THEN
1690: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

Line 1687: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );

1683: IF OZF_DEBUG_LOW_ON THEN
1684: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );
1685: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );
1686: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1687: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1688: END IF;
1689: IF l_request_line_id is NULL THEN
1690: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1691: p_id_value => l_order_set_tbl(J).resale_line_int_id,

Line 1715: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1711: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1712: AND resale_batch_id = p_resale_batch_id;
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1717: END;
1718: goto END_LOOP;
1719: END IF;

Line 1742: OZF_UTILITY_PVT.debug_message('init current quantity:' || l_current_quantity );

1738: */
1739:
1740: l_current_quantity := l_order_set_tbl(J).quantity;
1741: IF OZF_DEBUG_LOW_ON THEN
1742: OZF_UTILITY_PVT.debug_message('init current quantity:' || l_current_quantity );
1743: END IF;
1744:
1745: IF l_request_line_apprv_max_qty is not NULL OR
1746: l_request_line_apprv_min_qty is not NULL THEN

Line 1799: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1795: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1796: AND resale_batch_id = p_resale_batch_id;
1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: END;
1802: goto END_LOOP;
1803: END IF;

Line 1826: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1822: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1823: AND resale_batch_id = p_resale_batch_id;
1824: EXCEPTION
1825: WHEN OTHERS THEN
1826: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1828: END;
1829: goto END_LOOP;
1830: END IF;

Line 1856: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1852: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1853: AND resale_batch_id = p_resale_batch_id;
1854: EXCEPTION
1855: WHEN OTHERS THEN
1856: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1858: END;
1859: goto END_LOOP;
1860: END IF;

Line 1864: OZF_UTILITY_PVT.debug_message('2 current quantity:' || l_current_quantity );

1860: END IF;
1861: END IF;
1862: END IF;
1863: IF OZF_DEBUG_LOW_ON THEN
1864: OZF_UTILITY_PVT.debug_message('2 current quantity:' || l_current_quantity );
1865: END IF;
1866:
1867: IF l_request_line_apprv_max_qty is not NULL AND
1868: l_current_quantity + l_used_quantity > l_request_line_apprv_max_qty THEN

Line 1880: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1876: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1877: AND resale_batch_id = p_resale_batch_id;
1878: EXCEPTION
1879: WHEN OTHERS THEN
1880: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1882: END;
1883: goto END_LOOP;
1884: END IF;

Line 1899: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');

1895: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1896: AND resale_batch_id = p_resale_batch_id;
1897: EXCEPTION
1898: WHEN OTHERS THEN
1899: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END;
1902: goto END_LOOP;
1903: END IF;

Line 1919: OZF_UTILITY_PVT.debug_message('remaining amount:' || l_remaining_amount );

1915: l_remaining_amount;
1916: CLOSE remaining_amount_csr;
1917:
1918: IF OZF_DEBUG_LOW_ON THEN
1919: OZF_UTILITY_PVT.debug_message('remaining amount:' || l_remaining_amount );
1920: END IF;
1921:
1922:
1923: -- allowed amount should be based on the request.

Line 1942: ozf_utility_PVT.debug_message('/--- Success: Processing order for order NUMBER:'||p_order_number||'---/');

1938: NULL;
1939: END LOOP;
1940: END IF;
1941: IF OZF_DEBUG_LOW_ON THEN
1942: ozf_utility_PVT.debug_message('/*--- Success: Processing order for order NUMBER:'||p_order_number||'---*/');
1943: ozf_utility_PVT.debug_message('/*--- AND cusomter:'||p_sold_from_cust_account_id||'---*/');
1944: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1945: END IF;
1946:

Line 1943: ozf_utility_PVT.debug_message('/--- AND cusomter:'||p_sold_from_cust_account_id||'---/');

1939: END LOOP;
1940: END IF;
1941: IF OZF_DEBUG_LOW_ON THEN
1942: ozf_utility_PVT.debug_message('/*--- Success: Processing order for order NUMBER:'||p_order_number||'---*/');
1943: ozf_utility_PVT.debug_message('/*--- AND cusomter:'||p_sold_from_cust_account_id||'---*/');
1944: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1945: END IF;
1946:
1947: -- Debug Message

Line 1944: ozf_utility_PVT.debug_message('/--- And date ordered:'||p_date_ordered||'---/');

1940: END IF;
1941: IF OZF_DEBUG_LOW_ON THEN
1942: ozf_utility_PVT.debug_message('/*--- Success: Processing order for order NUMBER:'||p_order_number||'---*/');
1943: ozf_utility_PVT.debug_message('/*--- AND cusomter:'||p_sold_from_cust_account_id||'---*/');
1944: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1945: END IF;
1946:
1947: -- Debug Message
1948: IF OZF_DEBUG_HIGH_ON THEN

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

1945: END IF;
1946:
1947: -- Debug Message
1948: IF OZF_DEBUG_HIGH_ON THEN
1949: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
1950: END IF;
1951:
1952: x_return_status := l_return_status;
1953: EXCEPTION

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

2037: END IF;
2038:
2039: -- Debug Message
2040: IF OZF_DEBUG_HIGH_ON THEN
2041: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
2042: END IF;
2043:
2044: -- Initialize API return status to sucess
2045: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2136: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');

2132: and date_ordered = l_order_date_tbl(i)
2133: and resale_batch_id = p_resale_batch_id;
2134: EXCEPTION
2135: WHEN OTHERS THEN
2136: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');
2137: RAISE FND_API.g_exc_unexpected_error;
2138: END;
2139: IF OZF_DEBUG_LOW_ON THEN
2140: ozf_utility_PVT.debug_message('/*--- process_one_order Failed ---*/');

Line 2140: ozf_utility_PVT.debug_message('/--- process_one_order Failed ---/');

2136: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');
2137: RAISE FND_API.g_exc_unexpected_error;
2138: END;
2139: IF OZF_DEBUG_LOW_ON THEN
2140: ozf_utility_PVT.debug_message('/*--- process_one_order Failed ---*/');
2141: END IF;
2142: END IF;
2143: END IF; -- END if for order_number, sold_from cust, date_ordered not NULL
2144: END LOOP; -- END LOOP for l_order_num_tbl

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

2162: END IF;
2163:
2164: -- Debug Message
2165: IF OZF_DEBUG_HIGH_ON THEN
2166: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
2167: END IF;
2168: --Standard call to get message count and if count=1, get the message
2169: FND_MSG_PUB.Count_And_Get (
2170: p_encoded => FND_API.G_FALSE,