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

220: END IF;
221:
222: -- Debug Message
223: IF OZF_DEBUG_HIGH_ON THEN
224: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
225: END IF;
226:
227: -- Initialize API return status to sucess
228: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

246: CLOSE OPEN_line_count_csr;
247:
248: IF l_count <> 0 THEN
249: --Can not pay if there is an OPEN line
250: ozf_utility_pvt.error_message('OZF_RESALE_OPEN_LINE_EXIST');
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: ELSE
253: -- There is no need to find a fund id for the SPECIAL PRICING REQUEST
254: l_chargeback_fund_id := NULL;

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

289: ,x_msg_data => l_msg_data
290: );
291:
292: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
293: ozf_utility_pvt.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;
296: */
297: -- Bug 4380203 (-)

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

319: END IF;
320:
321: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_REJECTED THEN
322: IF OZF_DEBUG_LOW_ON THEN
323: OZF_UTILITY_PVT.debug_message('OZF_RESALE_REJECTED');
324: END IF;
325: ELSE
326: */
327: --i:=1;

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

339:
340: IF l_order_num_tbl.EXISTS(1) THEN
341: FOR k in 1..l_order_num_tbl.LAST LOOP
342: IF OZF_DEBUG_LOW_ON THEN
343: ozf_utility_PVT.debug_message('PROCESS ORDER: ');
344: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);
345: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);
346: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);
347: END IF;

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

340: IF l_order_num_tbl.EXISTS(1) THEN
341: FOR k in 1..l_order_num_tbl.LAST LOOP
342: IF OZF_DEBUG_LOW_ON THEN
343: ozf_utility_PVT.debug_message('PROCESS ORDER: ');
344: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);
345: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);
346: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);
347: END IF;
348:

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

341: FOR k in 1..l_order_num_tbl.LAST LOOP
342: IF OZF_DEBUG_LOW_ON THEN
343: ozf_utility_PVT.debug_message('PROCESS ORDER: ');
344: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);
345: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);
346: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);
347: END IF;
348:
349: -- beginjxwu header_fix

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

342: IF OZF_DEBUG_LOW_ON THEN
343: ozf_utility_PVT.debug_message('PROCESS ORDER: ');
344: ozf_utility_PVT.debug_message('ORDER NUMBER: '||l_order_num_tbl(k).order_number);
345: ozf_utility_PVT.debug_message('sold_from_ACCT: '||l_order_num_tbl(k).sold_from_cust_account_id);
346: ozf_utility_PVT.debug_message('DATE ORDERED: '||l_order_num_tbl(k).date_ordered);
347: END IF;
348:
349: -- beginjxwu header_fix
350: -- Here, I assume if a line is the duplicate of another line, then they share

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

411: -- I then try to create resale data.
412: For j in 1..l_valid_line_id_tbl.last
413: LOOP
414: IF OZF_DEBUG_LOW_ON THEN
415: ozf_utility_PVT.debug_message('Current line_int_id:' || l_valid_line_id_tbl(j).id);
416: END IF;
417:
418: OPEN OZF_RESALE_COMMON_PVT.g_interface_rec_csr(l_valid_line_id_tbl(j).id);
419: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_line_int_rec;

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

436: );
437:
438: IF not l_inventory_level_valid THEN
439: IF OZF_DEBUG_LOW_ON THEN
440: ozf_utility_PVT.debug_message('Did not pass inventory checking');
441: END IF;
442:
443: -- Here turn this line to disputed and create a disput code for it.
444: UPDATE ozf_resale_lines_int

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

555: ELSIF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN
556: l_line_id := l_line_int_rec.duplicated_line_id;
557: END IF;
558: IF OZF_DEBUG_LOW_ON THEN
559: OZF_UTILITY_PVT.debug_message('line_id is '|| l_line_id);
560: END IF;
561:
562: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED OR
563: l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DUPLICATED THEN

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

652: paid_amount = l_amount_claimed
653: WHERE resale_batch_id = p_resale_batch_id;
654: EXCEPTION
655: WHEN OTHERS THEN
656: ozf_utility_pvt.error_message('OZF_UPD_RESALE_WRG','TEXT',l_full_name||': END');
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END;
659: END IF;
660: ELSE

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

658: END;
659: END IF;
660: ELSE
661: -- Only disputed and processed batch can be paid.
662: ozf_utility_pvt.error_message('OZF_RESALE_WRONG_STAUS_TO_PAY');
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665:
666: -- Debug Message

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

664: END IF;
665:
666: -- Debug Message
667: IF OZF_DEBUG_HIGH_ON THEN
668: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
669: END IF;
670: --Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,

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

752: END IF;
753:
754: -- Debug Message
755: IF OZF_DEBUG_HIGH_ON THEN
756: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
757: END IF;
758:
759: -- Initialize API return status to sucess
760: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 795: OZF_UTILITY_PVT.error_message(

791: AND a.error_code ='OZF_RESALE_AGRM_TYPE_WNG'
792: );
793: EXCEPTION
794: WHEN OTHERS THEN
795: OZF_UTILITY_PVT.error_message(
796: p_message_name => 'OZF_INS_RESALE_LOG_WRG',
797: p_token_name => 'TEXT',
798: p_token_value => l_full_name||': END');
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 815: OZF_UTILITY_PVT.error_message(

811: AND agreement_type <>'SPO'
812: AND resale_batch_id = p_resale_batch_id;
813: EXCEPTION
814: WHEN OTHERS THEN
815: OZF_UTILITY_PVT.error_message(
816: p_message_name => 'OZF_UPD_RESALE_INT_WRG',
817: p_token_name => 'TEXT',
818: p_token_value => l_full_name||': END');
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 855: OZF_UTILITY_PVT.error_message(

851: AND a.error_code ='OZF_RESALE_PUR_PRICE_MISSING'
852: );
853: EXCEPTION
854: WHEN OTHERS THEN
855: OZF_UTILITY_PVT.error_message(
856: p_message_name => 'OZF_INS_RESALE_LOG_WRG',
857: p_token_name => 'TEXT',
858: p_token_value => l_full_name||': END');
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 875: OZF_UTILITY_PVT.error_message(

871: AND purchase_price IS NULL
872: AND resale_batch_id = p_resale_batch_id;
873: EXCEPTION
874: WHEN OTHERS THEN
875: OZF_UTILITY_PVT.error_message(
876: p_message_name => 'OZF_UPD_RESALE_INT_WRG',
877: p_token_name => 'TEXT',
878: p_token_value => l_full_name||': END');
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

880: END;
881:
882: -- Debug Message
883: IF OZF_DEBUG_HIGH_ON THEN
884: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
885: END IF;
886: --Standard call to get message count and if count=1, get the message
887: FND_MSG_PUB.Count_And_Get (
888: p_encoded => FND_API.G_FALSE,

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

1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: -- Debug Message
1107: IF OZF_DEBUG_HIGH_ON THEN
1108: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
1109: END IF;
1110:
1111: -- bug # 6821886 fixed by ateotia (+)
1112: -- Before start process, clean up the data structures if necessary.

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

1128: FETCH OZF_RESALE_COMMON_PVT.g_interface_rec_csr INTO l_resale_int_rec;
1129: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1130:
1131: IF OZF_DEBUG_LOW_ON THEN
1132: ozf_utility_PVT.debug_message(l_full_name || ' checking int line ' || l_all_order_set_tbl(i).resale_line_int_id);
1133: ozf_utility_PVT.debug_message(l_full_name || ' inventory tracking ' || g_inventory_tracking);
1134: END IF;
1135:
1136: IF g_inventory_tracking = 'T' THEN

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

1129: CLOSE OZF_RESALE_COMMON_PVT.g_interface_rec_csr;
1130:
1131: IF OZF_DEBUG_LOW_ON THEN
1132: ozf_utility_PVT.debug_message(l_full_name || ' checking int line ' || l_all_order_set_tbl(i).resale_line_int_id);
1133: ozf_utility_PVT.debug_message(l_full_name || ' inventory tracking ' || g_inventory_tracking);
1134: END IF;
1135:
1136: IF g_inventory_tracking = 'T' THEN
1137: -- Check inventory level first

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

1147: );
1148:
1149: IF NOT l_inventory_level_valid THEN
1150: IF OZF_DEBUG_LOW_ON THEN
1151: ozf_utility_PVT.debug_message(l_full_name || ' inventory checking not passed!!!');
1152: END IF;
1153:
1154: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1155: p_id_value => l_all_order_set_tbl(i).resale_line_int_id,

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

1201: AND resale_batch_id = p_resale_batch_id; -- bug 5222273 */
1202: -- bug # 6821886 fixed by ateotia (-)
1203:
1204: IF OZF_DEBUG_LOW_ON THEN
1205: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);
1206: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||p_order_number||'---*/');
1207: ozf_utility_PVT.debug_message('/*--- And cusomter:'||p_sold_from_cust_account_id||'---*/');
1208: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1209: END IF;

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

1202: -- bug # 6821886 fixed by ateotia (-)
1203:
1204: IF OZF_DEBUG_LOW_ON THEN
1205: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);
1206: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||p_order_number||'---*/');
1207: ozf_utility_PVT.debug_message('/*--- And cusomter:'||p_sold_from_cust_account_id||'---*/');
1208: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1209: END IF;
1210:

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

1203:
1204: IF OZF_DEBUG_LOW_ON THEN
1205: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);
1206: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||p_order_number||'---*/');
1207: ozf_utility_PVT.debug_message('/*--- And cusomter:'||p_sold_from_cust_account_id||'---*/');
1208: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1209: END IF;
1210:
1211: -- Before start process, clean up the data structures if necessary.

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

1204: IF OZF_DEBUG_LOW_ON THEN
1205: OZF_UTILITY_PVT.debug_message('partner_id:' || p_partner_id);
1206: ozf_utility_PVT.debug_message('/*--- Processing order for order NUMBER:'||p_order_number||'---*/');
1207: ozf_utility_PVT.debug_message('/*--- And cusomter:'||p_sold_from_cust_account_id||'---*/');
1208: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1209: END IF;
1210:
1211: -- Before start process, clean up the data structures if necessary.
1212: IF l_order_set_tbl.EXISTS(1) THEN

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

1229: --END LOOP;
1230: CLOSE order_set_csr;
1231:
1232: IF OZF_DEBUG_LOW_ON THEN
1233: ozf_utility_PVT.debug_message('after order set:'||l_order_set_tbl.LAST);
1234: END IF;
1235:
1236: IF l_order_set_tbl.exists(1) THEN
1237: For J in 1..l_order_set_tbl.LAST LOOP

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

1300: l_offer_type;
1301: CLOSE request_header_info_csr;
1302:
1303: IF OZF_DEBUG_LOW_ON THEN
1304: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);
1305: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);
1306: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);
1307: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);
1308: END IF;

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

1301: CLOSE request_header_info_csr;
1302:
1303: IF OZF_DEBUG_LOW_ON THEN
1304: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);
1305: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);
1306: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);
1307: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);
1308: END IF;
1309: IF l_header_start_date IS NULL OR

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

1302:
1303: IF OZF_DEBUG_LOW_ON THEN
1304: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);
1305: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);
1306: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);
1307: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);
1308: END IF;
1309: IF l_header_start_date IS NULL OR
1310: l_request_type_code IS NULL OR

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

1303: IF OZF_DEBUG_LOW_ON THEN
1304: OZF_UTILITY_PVT.debug_message(p_message_text => 'start_date' || l_header_start_date);
1305: OZF_UTILITY_PVT.debug_message(p_message_text => 'end_date' || l_header_end_date);
1306: OZF_UTILITY_PVT.debug_message(p_message_text => 'request_type ' || l_request_type_code);
1307: OZF_UTILITY_PVT.debug_message(p_message_text => 'currency_code' || l_header_currency_code);
1308: END IF;
1309: IF l_header_start_date IS NULL OR
1310: l_request_type_code IS NULL OR
1311: l_header_currency_code is NULL THEN

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

1333: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1334: AND resale_batch_id = p_resale_batch_id;
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1339: END;
1340: goto END_LOOP;
1341: END IF;

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

1340: goto END_LOOP;
1341: END IF;
1342:
1343: IF OZF_DEBUG_LOW_ON THEN
1344: OZF_UTILITY_PVT.debug_message(p_message_text => 'date_ordered' || l_order_set_tbl(J).date_ordered);
1345: END IF;
1346:
1347:
1348: IF l_order_set_tbl(J).date_ordered < l_header_start_date OR

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

1372: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1373: AND resale_batch_id = p_resale_batch_id;
1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1378: END;
1379: GOTO END_LOOP;
1380: END IF;

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

1379: GOTO END_LOOP;
1380: END IF;
1381:
1382: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1383: OZF_UTILITY_PVT.debug_message('line currency '||l_order_set_tbl(J).currency_code );
1384: END IF;
1385: IF l_order_set_tbl(J).currency_code <> l_header_currency_code THEN
1386: BEGIN
1387: UPDATE ozf_resale_lines_int

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

1393: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1394: AND resale_batch_id = p_resale_batch_id;
1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1399: END;
1400: GOTO END_LOOP;
1401: END IF;

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

1409: -- Validation on resale data is passed, only when bill_to/ ship_to is not null and equal to the
1410: -- end customer.
1411:
1412: IF OZF_DEBUG_LOW_ON THEN
1413: OZF_UTILITY_PVT.debug_message('In Bid request' );
1414: END IF;
1415: IF l_header_end_cust_party_id IS NOT NULL THEN
1416: -- One of the following should match
1417: IF (l_order_set_tbl(J).bill_to_party_id is not null AND

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

1432: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1433: AND resale_batch_id = p_resale_batch_id;
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: END;
1439: GOTO END_LOOP;
1440: END IF;

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

1454: -- bill_to/ ship_to is not null and equal to the end customer
1455: -- end if;
1456: -- end if;
1457: IF OZF_DEBUG_LOW_ON THEN
1458: OZF_UTILITY_PVT.debug_message('In Meet' );
1459: END IF;
1460: -- One of the following should match
1461: IF l_header_reseller_party_id IS NOT NULL THEN
1462: IF (l_order_set_tbl(J).bill_to_party_id is NOT NULL AND

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

1480: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1481: AND resale_batch_id = p_resale_batch_id;
1482: EXCEPTION
1483: WHEN OTHERS THEN
1484: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END;
1487: GOTO END_LOOP;
1488: END IF;

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

1498: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1499: AND resale_batch_id = p_resale_batch_id;
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END;
1505: GOTO END_LOOP;
1506: END IF;

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

1523: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1524: AND resale_batch_id = p_resale_batch_id;
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: END;
1530: GOTO END_LOOP;
1531: END IF;

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

1535:
1536: IF l_offer_id IS NULL THEN
1537:
1538: IF OZF_DEBUG_LOW_ON THEN
1539: OZF_UTILITY_PVT.debug_message('In Offer id null' );
1540: END IF;
1541: BEGIN
1542: UPDATE ozf_resale_lines_int
1543: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

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

1548: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1549: AND resale_batch_id = p_resale_batch_id;
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1554: END;
1555: GOTO END_LOOP;
1556: ELSE

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

1555: GOTO END_LOOP;
1556: ELSE
1557: IF l_offer_type = G_OFF_INVOICE_OFFER THEN
1558: IF OZF_DEBUG_LOW_ON THEN
1559: OZF_UTILITY_PVT.debug_message('In Off invoice offer' );
1560: END IF;
1561: BEGIN
1562: UPDATE ozf_resale_lines_int
1563: SET status_code=OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_DISPUTED,

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

1568: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1569: AND resale_batch_id = p_resale_batch_id;
1570: EXCEPTION
1571: WHEN OTHERS THEN
1572: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1574: END;
1575: GOTO END_LOOP;
1576: END IF;

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

1591: l_request_line_apprv_min_qty;
1592: CLOSE request_line_info_csr;
1593:
1594: IF OZF_DEBUG_LOW_ON THEN
1595: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );
1596: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );
1597: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1598: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1599: END IF;

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

1592: CLOSE request_line_info_csr;
1593:
1594: IF OZF_DEBUG_LOW_ON THEN
1595: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );
1596: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );
1597: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1598: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1599: END IF;
1600: IF l_request_line_id is NULL THEN

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

1593:
1594: IF OZF_DEBUG_LOW_ON THEN
1595: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );
1596: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );
1597: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1598: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1599: END IF;
1600: IF l_request_line_id is NULL THEN
1601: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

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

1594: IF OZF_DEBUG_LOW_ON THEN
1595: OZF_UTILITY_PVT.debug_message('request line_id:' || l_request_line_id );
1596: OZF_UTILITY_PVT.debug_message('request line uom:' || l_request_line_uom );
1597: OZF_UTILITY_PVT.debug_message('request line approved max:' || l_request_line_apprv_max_qty );
1598: OZF_UTILITY_PVT.debug_message('request line approved min' || l_request_line_apprv_min_qty );
1599: END IF;
1600: IF l_request_line_id is NULL THEN
1601: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1602: p_id_value => l_order_set_tbl(J).resale_line_int_id,

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

1622: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1623: AND resale_batch_id = p_resale_batch_id;
1624: EXCEPTION
1625: WHEN OTHERS THEN
1626: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: END;
1629: goto END_LOOP;
1630: END IF;

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

1649: */
1650:
1651: l_current_quantity := l_order_set_tbl(J).quantity;
1652: IF OZF_DEBUG_LOW_ON THEN
1653: OZF_UTILITY_PVT.debug_message('init current quantity:' || l_current_quantity );
1654: END IF;
1655:
1656: IF l_request_line_apprv_max_qty is not NULL OR
1657: l_request_line_apprv_min_qty is not NULL THEN

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

1691: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1692: AND resale_batch_id = p_resale_batch_id;
1693: EXCEPTION
1694: WHEN OTHERS THEN
1695: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: END;
1698: goto END_LOOP;
1699: END IF;

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

1718: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1719: AND resale_batch_id = p_resale_batch_id;
1720: EXCEPTION
1721: WHEN OTHERS THEN
1722: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1724: END;
1725: goto END_LOOP;
1726: END IF;

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

1748: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1749: AND resale_batch_id = p_resale_batch_id;
1750: EXCEPTION
1751: WHEN OTHERS THEN
1752: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1754: END;
1755: goto END_LOOP;
1756: END IF;

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

1756: END IF;
1757: END IF;
1758: END IF;
1759: IF OZF_DEBUG_LOW_ON THEN
1760: OZF_UTILITY_PVT.debug_message('2 current quantity:' || l_current_quantity );
1761: END IF;
1762:
1763: IF l_request_line_apprv_max_qty is not NULL AND
1764: l_current_quantity + l_used_quantity > l_request_line_apprv_max_qty THEN

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

1772: WHERE resale_line_int_id = l_order_set_tbl(J).resale_line_int_id
1773: AND resale_batch_id = p_resale_batch_id;
1774: EXCEPTION
1775: WHEN OTHERS THEN
1776: OZF_UTILITY_PVT.error_message(p_message_name => 'OZF_UPD_RESALE_INT_WRG');
1777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1778: END;
1779: goto END_LOOP;
1780: END IF;

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

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

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

1811: l_remaining_amount;
1812: CLOSE remaining_amount_csr;
1813:
1814: IF OZF_DEBUG_LOW_ON THEN
1815: OZF_UTILITY_PVT.debug_message('remaining amount:' || l_remaining_amount );
1816: END IF;
1817:
1818:
1819: -- allowed amount should be based on the request.

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

1834: NULL;
1835: END LOOP;
1836: END IF;
1837: IF OZF_DEBUG_LOW_ON THEN
1838: ozf_utility_PVT.debug_message('/*--- Success: Processing order for order NUMBER:'||p_order_number||'---*/');
1839: ozf_utility_PVT.debug_message('/*--- AND cusomter:'||p_sold_from_cust_account_id||'---*/');
1840: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1841: END IF;
1842:

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

1835: END LOOP;
1836: END IF;
1837: IF OZF_DEBUG_LOW_ON THEN
1838: ozf_utility_PVT.debug_message('/*--- Success: Processing order for order NUMBER:'||p_order_number||'---*/');
1839: ozf_utility_PVT.debug_message('/*--- AND cusomter:'||p_sold_from_cust_account_id||'---*/');
1840: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1841: END IF;
1842:
1843: -- Debug Message

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

1836: END IF;
1837: IF OZF_DEBUG_LOW_ON THEN
1838: ozf_utility_PVT.debug_message('/*--- Success: Processing order for order NUMBER:'||p_order_number||'---*/');
1839: ozf_utility_PVT.debug_message('/*--- AND cusomter:'||p_sold_from_cust_account_id||'---*/');
1840: ozf_utility_PVT.debug_message('/*--- And date ordered:'||p_date_ordered||'---*/');
1841: END IF;
1842:
1843: -- Debug Message
1844: IF OZF_DEBUG_HIGH_ON THEN

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

1841: END IF;
1842:
1843: -- Debug Message
1844: IF OZF_DEBUG_HIGH_ON THEN
1845: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
1846: END IF;
1847:
1848: x_return_status := l_return_status;
1849: EXCEPTION

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

1933: END IF;
1934:
1935: -- Debug Message
1936: IF OZF_DEBUG_HIGH_ON THEN
1937: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
1938: END IF;
1939:
1940: -- Initialize API return status to sucess
1941: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2028: and date_ordered = l_order_date_tbl(i)
2029: and resale_batch_id = p_resale_batch_id;
2030: EXCEPTION
2031: WHEN OTHERS THEN
2032: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');
2033: RAISE FND_API.g_exc_unexpected_error;
2034: END;
2035: IF OZF_DEBUG_LOW_ON THEN
2036: ozf_utility_PVT.debug_message('/*--- process_one_order Failed ---*/');

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

2032: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');
2033: RAISE FND_API.g_exc_unexpected_error;
2034: END;
2035: IF OZF_DEBUG_LOW_ON THEN
2036: ozf_utility_PVT.debug_message('/*--- process_one_order Failed ---*/');
2037: END IF;
2038: END IF;
2039: END IF; -- END if for order_number, sold_from cust, date_ordered not NULL
2040: END LOOP; -- END LOOP for l_order_num_tbl

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

2058: END IF;
2059:
2060: -- Debug Message
2061: IF OZF_DEBUG_HIGH_ON THEN
2062: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
2063: END IF;
2064: --Standard call to get message count and if count=1, get the message
2065: FND_MSG_PUB.Count_And_Get (
2066: p_encoded => FND_API.G_FALSE,