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_TRACING_ORDER_PVT dependencies on FND_API

Line 30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

26: --
27: ---------------------------------------------------------------------
28: PROCEDURE Initiate_payment (
29: p_api_version IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: ,p_resale_batch_id IN NUMBER
34: ,x_return_status OUT NOCOPY VARCHAR2

Line 31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

27: ---------------------------------------------------------------------
28: PROCEDURE Initiate_payment (
29: p_api_version IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: ,p_resale_batch_id IN NUMBER
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_data OUT NOCOPY VARCHAR2

Line 32: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

28: PROCEDURE Initiate_payment (
29: p_api_version IN NUMBER
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
33: ,p_resale_batch_id IN NUMBER
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_data OUT NOCOPY VARCHAR2
36: ,x_msg_count OUT NOCOPY NUMBER

Line 201: IF NOT FND_API.Compatible_API_Call (

197: BEGIN
198: -- Standard begin of API savepoint
199: SAVEPOINT TRAC_INITIATE_PAYMENT;
200: -- Standard call to check for call compatibility.
201: IF NOT FND_API.Compatible_API_Call (
202: l_api_version,
203: p_api_version,
204: l_api_name,
205: G_PKG_NAME)

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: p_api_version,
204: l_api_name,
205: G_PKG_NAME)
206: THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: --Initialize message list if p_init_msg_list is TRUE.
211: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 211: IF FND_API.To_Boolean (p_init_msg_list) THEN

207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: END IF;
209:
210: --Initialize message list if p_init_msg_list is TRUE.
211: IF FND_API.To_Boolean (p_init_msg_list) THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214:
215: -- Debug Message

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218: END IF;
219:
220:
221: -- Initialize API return status to sucess
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: OPEN Batch_info_csr(p_resale_batch_id);
225: FETCH batch_info_csr INTO l_batch_status,
226: l_batch_type,

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240:
241: IF l_count <> 0 THEN
242: --Can not pay if there is an OPEN line
243: ozf_utility_pvt.error_message('OZF_RESALE_OPEN_LINE_EXIST');
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: ELSE
246: -- Check whether there is a need to do inventory_verification
247: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
248: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;

Line 254: ,p_init_msg_list => FND_API.G_FALSE

250:
251: IF l_inventory_tracking = 'T' THEN
252: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
253: p_api_version => 1.0
254: ,p_init_msg_list => FND_API.G_FALSE
255: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
256: ,p_resale_batch_id => p_resale_batch_id
257: ,p_start_date => l_report_start_date
258: ,p_end_date => l_report_end_date

Line 255: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

251: IF l_inventory_tracking = 'T' THEN
252: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
253: p_api_version => 1.0
254: ,p_init_msg_list => FND_API.G_FALSE
255: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
256: ,p_resale_batch_id => p_resale_batch_id
257: ,p_start_date => l_report_start_date
258: ,p_end_date => l_report_end_date
259: ,x_return_status => l_return_status

Line 263: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

259: ,x_return_status => l_return_status
260: ,x_msg_count => l_msg_count
261: ,x_msg_data => l_msg_data
262: );
263: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
264: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
265: RAISE FND_API.G_EXC_ERROR;
266: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
267: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');

Line 265: RAISE FND_API.G_EXC_ERROR;

261: ,x_msg_data => l_msg_data
262: );
263: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
264: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
265: RAISE FND_API.G_EXC_ERROR;
266: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
267: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;

Line 266: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

262: );
263: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
264: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
265: RAISE FND_API.G_EXC_ERROR;
266: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
267: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270: END IF;

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

264: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
265: RAISE FND_API.G_EXC_ERROR;
266: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
267: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270: END IF;
271:
272: OPEN end_cust_relation_flag_csr;

Line 298: ,p_init_msg_list => FND_API.G_FALSE

294: l_new_party_rec.site_Use_Code := 'BILL_TO';
295:
296: OZF_RESALE_COMMON_PVT.Create_Party(
297: p_api_version => 1.0
298: ,p_init_msg_list => FND_API.G_FALSE
299: ,p_commit => FND_API.G_FALSE
300: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
301: ,px_party_rec => l_new_party_rec
302: ,x_return_status => l_return_status

Line 299: ,p_commit => FND_API.G_FALSE

295:
296: OZF_RESALE_COMMON_PVT.Create_Party(
297: p_api_version => 1.0
298: ,p_init_msg_list => FND_API.G_FALSE
299: ,p_commit => FND_API.G_FALSE
300: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
301: ,px_party_rec => l_new_party_rec
302: ,x_return_status => l_return_status
303: ,x_msg_data => l_msg_data

Line 300: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

296: OZF_RESALE_COMMON_PVT.Create_Party(
297: p_api_version => 1.0
298: ,p_init_msg_list => FND_API.G_FALSE
299: ,p_commit => FND_API.G_FALSE
300: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
301: ,px_party_rec => l_new_party_rec
302: ,x_return_status => l_return_status
303: ,x_msg_data => l_msg_data
304: ,x_msg_count => l_msg_count

Line 306: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

302: ,x_return_status => l_return_status
303: ,x_msg_data => l_msg_data
304: ,x_msg_count => l_msg_count
305: );
306: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
307: RAISE FND_API.G_EXC_ERROR;
308: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;

Line 307: RAISE FND_API.G_EXC_ERROR;

303: ,x_msg_data => l_msg_data
304: ,x_msg_count => l_msg_count
305: );
306: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
307: RAISE FND_API.G_EXC_ERROR;
308: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:

Line 308: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

304: ,x_msg_count => l_msg_count
305: );
306: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
307: RAISE FND_API.G_EXC_ERROR;
308: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: UPDATE ozf_resale_lines_int_all

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

305: );
306: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
307: RAISE FND_API.G_EXC_ERROR;
308: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: UPDATE ozf_resale_lines_int_all
313: SET bill_to_party_id = l_new_party_rec.party_id

Line 353: ,p_init_msg_list => FND_API.G_FALSE

349: l_new_party_rec.site_use_code := l_orig_end_cust_tbl(i).end_cust_site_use_code;
350:
351: OZF_RESALE_COMMON_PVT.Create_Party
352: ( p_api_version => 1.0
353: ,p_init_msg_list => FND_API.G_FALSE
354: ,p_commit => FND_API.G_FALSE
355: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
356: ,px_party_rec => l_new_party_rec
357: ,x_return_status => l_return_status

Line 354: ,p_commit => FND_API.G_FALSE

350:
351: OZF_RESALE_COMMON_PVT.Create_Party
352: ( p_api_version => 1.0
353: ,p_init_msg_list => FND_API.G_FALSE
354: ,p_commit => FND_API.G_FALSE
355: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
356: ,px_party_rec => l_new_party_rec
357: ,x_return_status => l_return_status
358: ,x_msg_data => l_msg_data

Line 355: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

351: OZF_RESALE_COMMON_PVT.Create_Party
352: ( p_api_version => 1.0
353: ,p_init_msg_list => FND_API.G_FALSE
354: ,p_commit => FND_API.G_FALSE
355: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
356: ,px_party_rec => l_new_party_rec
357: ,x_return_status => l_return_status
358: ,x_msg_data => l_msg_data
359: ,x_msg_count => l_msg_count

Line 361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

357: ,x_return_status => l_return_status
358: ,x_msg_data => l_msg_data
359: ,x_msg_count => l_msg_count
360: );
361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;

Line 362: RAISE FND_API.G_EXC_ERROR;

358: ,x_msg_data => l_msg_data
359: ,x_msg_count => l_msg_count
360: );
361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:

Line 363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

359: ,x_msg_count => l_msg_count
360: );
361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: UPDATE ozf_resale_lines_int_all

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

360: );
361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: UPDATE ozf_resale_lines_int_all
368: SET end_cust_party_id = l_new_party_rec.party_id

Line 490: ,p_init_msg_list => FND_API.G_FALSE

486: THEN
487: -- Check inventory level first
488: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
489: p_api_version => 1.0
490: ,p_init_msg_list => FND_API.G_FALSE
491: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
492: ,p_line_int_rec => l_line_int_rec
493: ,x_valid => l_inventory_level_valid
494: ,x_return_status => l_return_status

Line 491: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

487: -- Check inventory level first
488: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
489: p_api_version => 1.0
490: ,p_init_msg_list => FND_API.G_FALSE
491: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
492: ,p_line_int_rec => l_line_int_rec
493: ,x_valid => l_inventory_level_valid
494: ,x_return_status => l_return_status
495: ,x_msg_count => l_msg_count

Line 529: ,p_init_msg_list => FND_API.G_FALSE

525: -- Determin header id
526: IF l_create_order_header THEN
527: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
528: p_api_version => 1
529: ,p_init_msg_list => FND_API.G_FALSE
530: ,p_commit => FND_API.G_FALSE
531: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
532: ,p_line_int_rec => l_line_int_rec
533: ,x_header_id => l_header_id

Line 530: ,p_commit => FND_API.G_FALSE

526: IF l_create_order_header THEN
527: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
528: p_api_version => 1
529: ,p_init_msg_list => FND_API.G_FALSE
530: ,p_commit => FND_API.G_FALSE
531: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
532: ,p_line_int_rec => l_line_int_rec
533: ,x_header_id => l_header_id
534: ,x_return_status => l_return_status

Line 531: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

527: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
528: p_api_version => 1
529: ,p_init_msg_list => FND_API.G_FALSE
530: ,p_commit => FND_API.G_FALSE
531: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
532: ,p_line_int_rec => l_line_int_rec
533: ,x_header_id => l_header_id
534: ,x_return_status => l_return_status
535: ,x_msg_data => l_msg_data

Line 538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

534: ,x_return_status => l_return_status
535: ,x_msg_data => l_msg_data
536: ,x_msg_count => l_msg_count
537: );
538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;

Line 539: RAISE FND_API.G_EXC_ERROR;

535: ,x_msg_data => l_msg_data
536: ,x_msg_count => l_msg_count
537: );
538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543: --

Line 540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

536: ,x_msg_count => l_msg_count
537: );
538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543: --
544: ELSE

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537: );
538: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543: --
544: ELSE
545: NULL;

Line 563: ,p_init_msg_list => FND_API.G_FALSE

559:
560: -- No problem so far. Insert INTO batch_lines TABLE
561: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
562: p_api_version => 1
563: ,p_init_msg_list => FND_API.G_FALSE
564: ,p_commit => FND_API.G_FALSE
565: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
566: ,p_line_int_rec => l_line_int_rec
567: ,p_header_id => l_header_id

Line 564: ,p_commit => FND_API.G_FALSE

560: -- No problem so far. Insert INTO batch_lines TABLE
561: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
562: p_api_version => 1
563: ,p_init_msg_list => FND_API.G_FALSE
564: ,p_commit => FND_API.G_FALSE
565: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
566: ,p_line_int_rec => l_line_int_rec
567: ,p_header_id => l_header_id
568: ,x_line_id => l_line_id

Line 565: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

561: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
562: p_api_version => 1
563: ,p_init_msg_list => FND_API.G_FALSE
564: ,p_commit => FND_API.G_FALSE
565: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
566: ,p_line_int_rec => l_line_int_rec
567: ,p_header_id => l_header_id
568: ,x_line_id => l_line_id
569: ,x_return_status => l_return_status

Line 573: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

569: ,x_return_status => l_return_status
570: ,x_msg_data => l_msg_data
571: ,x_msg_count => l_msg_count
572: );
573: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
574: RAISE FND_API.G_EXC_ERROR;
575: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;

Line 574: RAISE FND_API.G_EXC_ERROR;

570: ,x_msg_data => l_msg_data
571: ,x_msg_count => l_msg_count
572: );
573: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
574: RAISE FND_API.G_EXC_ERROR;
575: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: --

Line 575: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

571: ,x_msg_count => l_msg_count
572: );
573: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
574: RAISE FND_API.G_EXC_ERROR;
575: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: --
579:

Line 576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

572: );
573: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
574: RAISE FND_API.G_EXC_ERROR;
575: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: --
579:
580: -- FOR processed order line, I need to create a transaction FOR it.

Line 583: ,p_init_msg_list => FND_API.G_FALSE

579:
580: -- FOR processed order line, I need to create a transaction FOR it.
581: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
582: p_api_version => 1.0
583: ,p_init_msg_list => FND_API.G_FALSE
584: ,p_commit => FND_API.G_FALSE
585: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
586: ,p_line_int_rec => l_line_int_rec
587: ,p_header_id => l_header_id

Line 584: ,p_commit => FND_API.G_FALSE

580: -- FOR processed order line, I need to create a transaction FOR it.
581: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
582: p_api_version => 1.0
583: ,p_init_msg_list => FND_API.G_FALSE
584: ,p_commit => FND_API.G_FALSE
585: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
586: ,p_line_int_rec => l_line_int_rec
587: ,p_header_id => l_header_id
588: ,p_line_id => l_line_id

Line 585: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

581: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
582: p_api_version => 1.0
583: ,p_init_msg_list => FND_API.G_FALSE
584: ,p_commit => FND_API.G_FALSE
585: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
586: ,p_line_int_rec => l_line_int_rec
587: ,p_header_id => l_header_id
588: ,p_line_id => l_line_id
589: ,x_sales_transaction_id => l_sales_transaction_id

Line 594: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

590: ,x_return_status => l_return_status
591: ,x_msg_data => l_msg_data
592: ,x_msg_count => l_msg_count
593: );
594: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;

Line 595: RAISE FND_API.G_EXC_ERROR;

591: ,x_msg_data => l_msg_data
592: ,x_msg_count => l_msg_count
593: );
594: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: --

Line 596: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

592: ,x_msg_count => l_msg_count
593: );
594: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: --
600:

Line 597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

593: );
594: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: --
600:
601: IF l_inventory_tracking = 'T' THEN

Line 604: ,p_init_msg_list => FND_API.G_FALSE

600:
601: IF l_inventory_tracking = 'T' THEN
602: OZF_SALES_TRANSACTIONS_PVT.Update_Inventory_Tmp (
603: p_api_version => 1.0
604: ,p_init_msg_list => FND_API.G_FALSE
605: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
606: ,p_sales_transaction_id => l_sales_transaction_id
607: ,x_return_status => l_return_status
608: ,x_msg_data => l_msg_data

Line 605: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

601: IF l_inventory_tracking = 'T' THEN
602: OZF_SALES_TRANSACTIONS_PVT.Update_Inventory_Tmp (
603: p_api_version => 1.0
604: ,p_init_msg_list => FND_API.G_FALSE
605: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
606: ,p_sales_transaction_id => l_sales_transaction_id
607: ,x_return_status => l_return_status
608: ,x_msg_data => l_msg_data
609: ,x_msg_count => l_msg_count

Line 611: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

607: ,x_return_status => l_return_status
608: ,x_msg_data => l_msg_data
609: ,x_msg_count => l_msg_count
610: );
611: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;

Line 612: RAISE FND_API.G_EXC_ERROR;

608: ,x_msg_data => l_msg_data
609: ,x_msg_count => l_msg_count
610: );
611: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616: --

Line 613: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

609: ,x_msg_count => l_msg_count
610: );
611: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616: --
617: END IF;

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610: );
611: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616: --
617: END IF;
618: ELSE

Line 636: ,p_init_msg_list => FND_API.G_FALSE

632: -- only create mapping FOR the lines that are processed or
633: -- duplicated, yet the adjustment IS new then
634: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
635: p_api_version => 1
636: ,p_init_msg_list => FND_API.G_FALSE
637: ,p_commit => FND_API.G_FALSE
638: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
639: ,p_resale_batch_id => p_resale_batch_id
640: ,p_line_id => l_line_id

Line 637: ,p_commit => FND_API.G_FALSE

633: -- duplicated, yet the adjustment IS new then
634: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
635: p_api_version => 1
636: ,p_init_msg_list => FND_API.G_FALSE
637: ,p_commit => FND_API.G_FALSE
638: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
639: ,p_resale_batch_id => p_resale_batch_id
640: ,p_line_id => l_line_id
641: ,x_return_status => l_return_status

Line 638: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

634: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
635: p_api_version => 1
636: ,p_init_msg_list => FND_API.G_FALSE
637: ,p_commit => FND_API.G_FALSE
638: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
639: ,p_resale_batch_id => p_resale_batch_id
640: ,p_line_id => l_line_id
641: ,x_return_status => l_return_status
642: ,x_msg_data => l_msg_data

Line 645: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

641: ,x_return_status => l_return_status
642: ,x_msg_data => l_msg_data
643: ,x_msg_count => l_msg_count
644: );
645: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: RAISE FND_API.G_EXC_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;

Line 646: RAISE FND_API.G_EXC_ERROR;

642: ,x_msg_data => l_msg_data
643: ,x_msg_count => l_msg_count
644: );
645: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: RAISE FND_API.G_EXC_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650: END IF;

Line 647: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

643: ,x_msg_count => l_msg_count
644: );
645: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: RAISE FND_API.G_EXC_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650: END IF;
651:

Line 648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

644: );
645: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
646: RAISE FND_API.G_EXC_ERROR;
647: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650: END IF;
651:
652: << END_ORDER_LINE >>

Line 682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

678: WHERE resale_batch_id = p_resale_batch_id;
679: EXCEPTION
680: WHEN OTHERS THEN
681: ozf_utility_pvt.error_message('OZF_UPD_RESALE_WRG','TEXT',l_full_name||': END');
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END;
684:
685: ELSE
686: -- Only disputed and processed batch can be paid.

Line 688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

684:
685: ELSE
686: -- Only disputed and processed batch can be paid.
687: ozf_utility_pvt.error_message('OZF_RESALE_WRONG_STAUS_TO_PAY');
688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
689: END IF;
690:
691: -- Debug Message
692: IF OZF_DEBUG_HIGH_ON THEN

Line 697: p_encoded => FND_API.G_FALSE,

693: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
694: END IF;
695: --Standard call to get message count and if count=1, get the message
696: FND_MSG_PUB.Count_And_Get (
697: p_encoded => FND_API.G_FALSE,
698: p_count => x_msg_count,
699: p_data => x_msg_data
700: );
701: x_return_status := l_return_status;

Line 703: WHEN FND_API.G_EXC_ERROR THEN

699: p_data => x_msg_data
700: );
701: x_return_status := l_return_status;
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: -- Standard call to get message count and if count=1, get the message
706: FND_MSG_PUB.Count_And_Get (
707: p_encoded => FND_API.G_FALSE,

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: );
701: x_return_status := l_return_status;
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: -- Standard call to get message count and if count=1, get the message
706: FND_MSG_PUB.Count_And_Get (
707: p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count,

Line 707: p_encoded => FND_API.G_FALSE,

703: WHEN FND_API.G_EXC_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: -- Standard call to get message count and if count=1, get the message
706: FND_MSG_PUB.Count_And_Get (
707: p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count,
709: p_data => x_msg_data
710: );
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

707: p_encoded => FND_API.G_FALSE,
708: p_count => x_msg_count,
709: p_data => x_msg_data
710: );
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: ROLLBACK TO TRAC_INITIATE_PAYMENT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714:
715: -- Standard call to get message count and if count=1, get the message

Line 713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

709: p_data => x_msg_data
710: );
711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
712: ROLLBACK TO TRAC_INITIATE_PAYMENT;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714:
715: -- Standard call to get message count and if count=1, get the message
716: FND_MSG_PUB.Count_And_Get (
717: p_encoded => FND_API.G_FALSE,

Line 717: p_encoded => FND_API.G_FALSE,

713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714:
715: -- Standard call to get message count and if count=1, get the message
716: FND_MSG_PUB.Count_And_Get (
717: p_encoded => FND_API.G_FALSE,
718: p_count => x_msg_count,
719: p_data => x_msg_data
720: );
721: WHEN OTHERS THEN

Line 723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

719: p_data => x_msg_data
720: );
721: WHEN OTHERS THEN
722: ROLLBACK TO TRAC_INITIATE_PAYMENT;
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724:
725: -- Standard call to get message count and if count=1, get the message
726: FND_MSG_PUB.Count_And_Get (
727: p_encoded => FND_API.G_FALSE,

Line 727: p_encoded => FND_API.G_FALSE,

723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724:
725: -- Standard call to get message count and if count=1, get the message
726: FND_MSG_PUB.Count_And_Get (
727: p_encoded => FND_API.G_FALSE,
728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );
731: END Initiate_payment;

Line 748: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

744: -- NOTES
745: ---------------------------------------------------------------------
746: PROCEDURE Validate_Order_Record(
747: p_api_version IN NUMBER
748: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
749: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
750: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
751: ,p_resale_batch_id IN NUMBER
752: ,x_return_status OUT NOCOPY VARCHAR2

Line 749: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

745: ---------------------------------------------------------------------
746: PROCEDURE Validate_Order_Record(
747: p_api_version IN NUMBER
748: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
749: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
750: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
751: ,p_resale_batch_id IN NUMBER
752: ,x_return_status OUT NOCOPY VARCHAR2
753: ,x_msg_data OUT NOCOPY VARCHAR2

Line 750: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

746: PROCEDURE Validate_Order_Record(
747: p_api_version IN NUMBER
748: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
749: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
750: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
751: ,p_resale_batch_id IN NUMBER
752: ,x_return_status OUT NOCOPY VARCHAR2
753: ,x_msg_data OUT NOCOPY VARCHAR2
754: ,x_msg_count OUT NOCOPY NUMBER

Line 775: IF NOT FND_API.Compatible_API_Call (

771:
772: BEGIN
773: -- Standard begin of API savepoint
774: -- Standard call to check for call compatibility.
775: IF NOT FND_API.Compatible_API_Call (
776: l_api_version,
777: p_api_version,
778: l_api_name,
779: G_PKG_NAME)

Line 781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

777: p_api_version,
778: l_api_name,
779: G_PKG_NAME)
780: THEN
781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
782: END IF;
783:
784: -- Debug Message
785: IF OZF_DEBUG_HIGH_ON THEN

Line 790: IF FND_API.To_Boolean (p_init_msg_list) THEN

786: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
787: END IF;
788:
789: --Initialize message list if p_init_msg_list is TRUE.
790: IF FND_API.To_Boolean (p_init_msg_list) THEN
791: FND_MSG_PUB.initialize;
792: END IF;
793:
794: -- Initialize API return status to sucess

Line 795: x_return_status := FND_API.G_RET_STS_SUCCESS;

791: FND_MSG_PUB.initialize;
792: END IF;
793:
794: -- Initialize API return status to sucess
795: x_return_status := FND_API.G_RET_STS_SUCCESS;
796:
797: OPEN non_tracing_count_csr (p_resale_batch_id);
798: FETCH non_tracing_count_csr INTO l_non_tracing_count;
799: CLOSE non_tracing_count_csr;

Line 837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

833: OZF_UTILITY_PVT.error_message(
834: p_message_name => 'OZF_INS_RESALE_LOG_WRG',
835: p_token_name => 'TEXT',
836: p_token_value => l_full_name||': END');
837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
838: END;
839:
840: UPDATE ozf_resale_lines_int_all
841: SET status_code = 'DISPUTED',

Line 856: p_encoded => FND_API.G_FALSE,

852: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
853: END IF;
854: --Standard call to get message count and if count=1, get the message
855: FND_MSG_PUB.Count_And_Get (
856: p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,
858: p_data => x_msg_data
859: );
860: EXCEPTION

Line 861: WHEN FND_API.G_EXC_ERROR THEN

857: p_count => x_msg_count,
858: p_data => x_msg_data
859: );
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: -- Standard call to get message count and if count=1, get the message
864: FND_MSG_PUB.Count_And_Get (
865: p_encoded => FND_API.G_FALSE,

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: p_data => x_msg_data
859: );
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: -- Standard call to get message count and if count=1, get the message
864: FND_MSG_PUB.Count_And_Get (
865: p_encoded => FND_API.G_FALSE,
866: p_count => x_msg_count,

Line 865: p_encoded => FND_API.G_FALSE,

861: WHEN FND_API.G_EXC_ERROR THEN
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: -- Standard call to get message count and if count=1, get the message
864: FND_MSG_PUB.Count_And_Get (
865: p_encoded => FND_API.G_FALSE,
866: p_count => x_msg_count,
867: p_data => x_msg_data
868: );
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

865: p_encoded => FND_API.G_FALSE,
866: p_count => x_msg_count,
867: p_data => x_msg_data
868: );
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: -- Standard call to get message count and if count=1, get the message
872: FND_MSG_PUB.Count_And_Get (
873: p_encoded => FND_API.G_FALSE,

Line 870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

866: p_count => x_msg_count,
867: p_data => x_msg_data
868: );
869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: -- Standard call to get message count and if count=1, get the message
872: FND_MSG_PUB.Count_And_Get (
873: p_encoded => FND_API.G_FALSE,
874: p_count => x_msg_count,

Line 873: p_encoded => FND_API.G_FALSE,

869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: -- Standard call to get message count and if count=1, get the message
872: FND_MSG_PUB.Count_And_Get (
873: p_encoded => FND_API.G_FALSE,
874: p_count => x_msg_count,
875: p_data => x_msg_data
876: );
877: WHEN OTHERS THEN

Line 878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

874: p_count => x_msg_count,
875: p_data => x_msg_data
876: );
877: WHEN OTHERS THEN
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879:
880: -- Standard call to get message count and if count=1, get the message
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,

Line 882: p_encoded => FND_API.G_FALSE,

878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879:
880: -- Standard call to get message count and if count=1, get the message
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,
883: p_count => x_msg_count,
884: p_data => x_msg_data
885: );
886: END Validate_Order_Record;

Line 904: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

900: ---------------------------------------------------------------------
901: PROCEDURE Process_Order
902: (
903: p_api_version IN NUMBER
904: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
905: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
906: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
907: ,p_resale_batch_id IN NUMBER
908: ,x_return_status OUT NOCOPY VARCHAR2

Line 905: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

901: PROCEDURE Process_Order
902: (
903: p_api_version IN NUMBER
904: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
905: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
906: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
907: ,p_resale_batch_id IN NUMBER
908: ,x_return_status OUT NOCOPY VARCHAR2
909: ,x_msg_data OUT NOCOPY VARCHAR2

Line 906: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

902: (
903: p_api_version IN NUMBER
904: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
905: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
906: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
907: ,p_resale_batch_id IN NUMBER
908: ,x_return_status OUT NOCOPY VARCHAR2
909: ,x_msg_data OUT NOCOPY VARCHAR2
910: ,x_msg_count OUT NOCOPY NUMBER

Line 986: IF NOT FND_API.Compatible_API_Call (

982: BEGIN
983: -- Standard begin of API savepoint
984: SAVEPOINT PROCESS_TRAC_ORDER;
985: -- Standard call to check for call compatibility.
986: IF NOT FND_API.Compatible_API_Call (
987: l_api_version,
988: p_api_version,
989: l_api_name,
990: G_PKG_NAME)

Line 992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

988: p_api_version,
989: l_api_name,
990: G_PKG_NAME)
991: THEN
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
993: END IF;
994:
995: -- Debug Message
996: IF OZF_DEBUG_HIGH_ON THEN

Line 1001: IF FND_API.To_Boolean (p_init_msg_list) THEN

997: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
998: END IF;
999:
1000: --Initialize message list if p_init_msg_list is TRUE.
1001: IF FND_API.To_Boolean (p_init_msg_list) THEN
1002: FND_MSG_PUB.initialize;
1003: END IF;
1004:
1005: -- Initialize API return status to sucess

Line 1006: x_return_status := FND_API.G_RET_STS_SUCCESS;

1002: FND_MSG_PUB.initialize;
1003: END IF;
1004:
1005: -- Initialize API return status to sucess
1006: x_return_status := FND_API.G_RET_STS_SUCCESS;
1007:
1008:
1009: /*
1010: OZF_RESALE_COMMON_PVT.Delete_Log(

Line 1012: ,p_init_msg_list => FND_API.G_FALSE

1008:
1009: /*
1010: OZF_RESALE_COMMON_PVT.Delete_Log(
1011: p_api_version => 1.0
1012: ,p_init_msg_list => FND_API.G_FALSE
1013: ,p_commit => FND_API.G_FALSE
1014: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1015: ,p_resale_batch_id => p_resale_batch_id
1016: ,x_return_status => l_return_status

Line 1013: ,p_commit => FND_API.G_FALSE

1009: /*
1010: OZF_RESALE_COMMON_PVT.Delete_Log(
1011: p_api_version => 1.0
1012: ,p_init_msg_list => FND_API.G_FALSE
1013: ,p_commit => FND_API.G_FALSE
1014: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1015: ,p_resale_batch_id => p_resale_batch_id
1016: ,x_return_status => l_return_status
1017: ,x_msg_count => l_msg_count

Line 1014: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1010: OZF_RESALE_COMMON_PVT.Delete_Log(
1011: p_api_version => 1.0
1012: ,p_init_msg_list => FND_API.G_FALSE
1013: ,p_commit => FND_API.G_FALSE
1014: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1015: ,p_resale_batch_id => p_resale_batch_id
1016: ,x_return_status => l_return_status
1017: ,x_msg_count => l_msg_count
1018: ,x_msg_data => l_msg_data

Line 1020: IF l_return_status = FND_API.g_ret_sts_error THEN

1016: ,x_return_status => l_return_status
1017: ,x_msg_count => l_msg_count
1018: ,x_msg_data => l_msg_data
1019: );
1020: IF l_return_status = FND_API.g_ret_sts_error THEN
1021: RAISE FND_API.g_exc_error;
1022: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1023: RAISE FND_API.g_exc_unexpected_error;
1024: END IF;

Line 1021: RAISE FND_API.g_exc_error;

1017: ,x_msg_count => l_msg_count
1018: ,x_msg_data => l_msg_data
1019: );
1020: IF l_return_status = FND_API.g_ret_sts_error THEN
1021: RAISE FND_API.g_exc_error;
1022: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1023: RAISE FND_API.g_exc_unexpected_error;
1024: END IF;
1025: */

Line 1022: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1018: ,x_msg_data => l_msg_data
1019: );
1020: IF l_return_status = FND_API.g_ret_sts_error THEN
1021: RAISE FND_API.g_exc_error;
1022: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1023: RAISE FND_API.g_exc_unexpected_error;
1024: END IF;
1025: */
1026:

Line 1023: RAISE FND_API.g_exc_unexpected_error;

1019: );
1020: IF l_return_status = FND_API.g_ret_sts_error THEN
1021: RAISE FND_API.g_exc_error;
1022: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1023: RAISE FND_API.g_exc_unexpected_error;
1024: END IF;
1025: */
1026:
1027: -- fetch all orders into a cursor.

Line 1052: ,p_init_msg_list => FND_API.G_FALSE

1048: CLOSE batch_info_csr;
1049: -- Bug 4380203 Fixing (+)
1050: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
1051: p_api_version => 1.0
1052: ,p_init_msg_list => FND_API.G_FALSE
1053: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1054: ,p_resale_batch_id => p_resale_batch_id
1055: ,p_start_date => l_report_start_date
1056: ,p_end_date => l_report_end_date

Line 1053: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1049: -- Bug 4380203 Fixing (+)
1050: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
1051: p_api_version => 1.0
1052: ,p_init_msg_list => FND_API.G_FALSE
1053: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1054: ,p_resale_batch_id => p_resale_batch_id
1055: ,p_start_date => l_report_start_date
1056: ,p_end_date => l_report_end_date
1057: ,x_return_status => l_return_status

Line 1061: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1057: ,x_return_status => l_return_status
1058: ,x_msg_count => l_msg_count
1059: ,x_msg_data => l_msg_data
1060: );
1061: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1062: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1063: RAISE FND_API.G_EXC_ERROR;
1064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1065: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');

Line 1063: RAISE FND_API.G_EXC_ERROR;

1059: ,x_msg_data => l_msg_data
1060: );
1061: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1062: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1063: RAISE FND_API.G_EXC_ERROR;
1064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1065: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END IF;

Line 1064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1060: );
1061: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1062: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1063: RAISE FND_API.G_EXC_ERROR;
1064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1065: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END IF;
1068:

Line 1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1062: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1063: RAISE FND_API.G_EXC_ERROR;
1064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1065: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END IF;
1068:
1069: /*
1070: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (

Line 1072: ,p_init_msg_list => FND_API.G_FALSE

1068:
1069: /*
1070: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
1071: p_api_version => 1.0
1072: ,p_init_msg_list => FND_API.G_FALSE
1073: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1074: ,p_party_id => l_partner_party_id
1075: ,p_start_date => l_report_start_date
1076: ,x_return_status => l_return_status

Line 1073: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1069: /*
1070: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
1071: p_api_version => 1.0
1072: ,p_init_msg_list => FND_API.G_FALSE
1073: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1074: ,p_party_id => l_partner_party_id
1075: ,p_start_date => l_report_start_date
1076: ,x_return_status => l_return_status
1077: ,x_msg_count => l_msg_count

Line 1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1120: AND resale_id_type = OZF_RESALE_COMMON_PVT.G_ID_TYPE_IFACE;
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: ozf_utility_pvt.error_message('OZF_DEL_RESALE_LOG_WRG');
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: END;
1126:
1127: IF l_inventory_tracking = 'T' THEN
1128:

Line 1132: ,p_init_msg_list => FND_API.G_FALSE

1128:
1129: -- Only need to Check inventory level
1130: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1131: p_api_version => 1.0
1132: ,p_init_msg_list => FND_API.G_FALSE
1133: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1134: ,p_line_int_rec => l_order_set_tbl(J)
1135: ,x_valid => l_inventory_level_valid
1136: ,x_return_status => l_return_status

Line 1133: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1129: -- Only need to Check inventory level
1130: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1131: p_api_version => 1.0
1132: ,p_init_msg_list => FND_API.G_FALSE
1133: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1134: ,p_line_int_rec => l_order_set_tbl(J)
1135: ,x_valid => l_inventory_level_valid
1136: ,x_return_status => l_return_status
1137: ,x_msg_count => l_msg_count

Line 1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1211: WHERE resale_batch_id = p_resale_batch_id;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: ozf_utility_pvt.error_message('OZF_UPD_RESALE_BATCH_WRG');
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: END;
1217:
1218:
1219: -- Debug Message

Line 1225: p_encoded => FND_API.G_FALSE,

1221: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
1222: END IF;
1223: --Standard call to get message count and if count=1, get the message
1224: FND_MSG_PUB.Count_And_Get (
1225: p_encoded => FND_API.G_FALSE,
1226: p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );
1229:

Line 1231: WHEN FND_API.G_EXC_ERROR THEN

1227: p_data => x_msg_data
1228: );
1229:
1230: EXCEPTION
1231: WHEN FND_API.G_EXC_ERROR THEN
1232: ROLLBACK TO PROCESS_TRAC_ORDER;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: -- Standard call to get message count and if count=1, get the message
1235: FND_MSG_PUB.Count_And_Get (

Line 1233: x_return_status := FND_API.G_RET_STS_ERROR;

1229:
1230: EXCEPTION
1231: WHEN FND_API.G_EXC_ERROR THEN
1232: ROLLBACK TO PROCESS_TRAC_ORDER;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: -- Standard call to get message count and if count=1, get the message
1235: FND_MSG_PUB.Count_And_Get (
1236: p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,

Line 1236: p_encoded => FND_API.G_FALSE,

1232: ROLLBACK TO PROCESS_TRAC_ORDER;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: -- Standard call to get message count and if count=1, get the message
1235: FND_MSG_PUB.Count_And_Get (
1236: p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
1238: p_data => x_msg_data
1239: );
1240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1236: p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
1238: p_data => x_msg_data
1239: );
1240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1241: ROLLBACK TO PROCESS_TRAC_ORDER;
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243:
1244: -- Standard call to get message count and if count=1, get the message

Line 1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1238: p_data => x_msg_data
1239: );
1240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1241: ROLLBACK TO PROCESS_TRAC_ORDER;
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243:
1244: -- Standard call to get message count and if count=1, get the message
1245: FND_MSG_PUB.Count_And_Get (
1246: p_encoded => FND_API.G_FALSE,

Line 1246: p_encoded => FND_API.G_FALSE,

1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243:
1244: -- Standard call to get message count and if count=1, get the message
1245: FND_MSG_PUB.Count_And_Get (
1246: p_encoded => FND_API.G_FALSE,
1247: p_count => x_msg_count,
1248: p_data => x_msg_data
1249: );
1250: WHEN OTHERS THEN

Line 1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1248: p_data => x_msg_data
1249: );
1250: WHEN OTHERS THEN
1251: ROLLBACK TO PROCESS_TRAC_ORDER;
1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253:
1254: -- Standard call to get message count and if count=1, get the message
1255: FND_MSG_PUB.Count_And_Get (
1256: p_encoded => FND_API.G_FALSE,

Line 1256: p_encoded => FND_API.G_FALSE,

1252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1253:
1254: -- Standard call to get message count and if count=1, get the message
1255: FND_MSG_PUB.Count_And_Get (
1256: p_encoded => FND_API.G_FALSE,
1257: p_count => x_msg_count,
1258: p_data => x_msg_data
1259: );
1260: END Process_Order;