DBA Data[Home] [Help]

APPS.PO_CHARGES_GRP dependencies on FND_API

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: asn_debug.put_line('Entering Capture_QP_Charges() for group_id:' || p_group_id
64: || ' and request_id:'|| p_request_id);
65: END IF;
66: k := 1;
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: -- Retrieve QP charges for PO receipts and import ASN
70:
71: SELECT shipment_header_id

Line 246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

242: IF (g_asn_debug = 'Y') THEN
243: asn_debug.put_line('l_return_status: '|| l_return_status);
244: END IF;
245:
246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
247: RAISE l_qp_api_exception;
248: END IF;
249:
250: IF l_qp_cost_table.count < 1 THEN

Line 361: x_return_status := FND_API.G_RET_STS_ERROR;

357: IF (g_asn_debug = 'Y') THEN
358: asn_debug.put_line('No QP charge for shipment header: ' ||l_rsh_id_table(i) );
359: END IF;
360: WHEN l_qp_api_exception THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: IF (g_asn_debug = 'Y') THEN
363: asn_debug.put_line('QP API returned error for shipment_id: ' ||l_rsh_id_table(i) );
364: END IF;
365: WHEN others THEN

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: IF (g_asn_debug = 'Y') THEN
363: asn_debug.put_line('QP API returned error for shipment_id: ' ||l_rsh_id_table(i) );
364: END IF;
365: WHEN others THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: x_msg_data := sqlerrm;
368: IF (g_asn_debug = 'Y') THEN
369: asn_debug.put_line('Unexpected exception occured in QP loop: '|| x_msg_data);
370: END IF;

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

399: END IF;
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_msg_data := sqlerrm;
405: IF (g_asn_debug = 'Y') THEN
406: asn_debug.put_line('Unexpected exception occured in Capture_QP_Charges(): '|| x_msg_data);
407: END IF;

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

434: END IF;
435:
436: k := 1;
437:
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439:
440: SELECT DISTINCT shipment_header_id
441: BULK COLLECT INTO l_rsh_id_table
442: FROM rcv_transactions rt,

Line 480: p_init_msg_list => FND_API.G_FALSE,

476: l_no_fte_charge EXCEPTION;
477: BEGIN
478:
479: FTE_PO_INTEGRATION_GRP.get_estimated_rates(
480: p_init_msg_list => FND_API.G_FALSE,
481: p_api_version_number => 1.0,
482: x_msg_count => l_msg_count,
483: x_msg_data => l_msg_data,
484: x_return_status => l_return_status,

Line 488: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

484: x_return_status => l_return_status,
485: p_shipment_header_id => l_rsh_id_table(i),
486: x_receipt_lines_tab => l_fte_cost_table);
487:
488: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
489: RAISE l_fte_exception;
490: END IF;
491:
492: IF (g_asn_debug = 'Y') THEN

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: IF (g_asn_debug = 'Y') THEN
603: asn_debug.put_line('No FTE charges retreived for shipment_id: '||l_rsh_id_table(i));
604: END IF;
605: WHEN l_fte_exception THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: x_msg_data := l_msg_data;
608: IF (g_asn_debug = 'Y') THEN
609: asn_debug.put_line('FTE API failed for shipment_id: '||l_rsh_id_table(i)||'. msg_data: '|| l_msg_data );
610: END IF;

Line 612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

608: IF (g_asn_debug = 'Y') THEN
609: asn_debug.put_line('FTE API failed for shipment_id: '||l_rsh_id_table(i)||'. msg_data: '|| l_msg_data );
610: END IF;
611: WHEN others THEN
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: x_msg_data := sqlerrm;
614: IF (g_asn_debug = 'Y') THEN
615: asn_debug.put_line('Unexpected exception occured in FTE loop: '|| x_msg_data);
616: END IF;

Line 651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

647: asn_debug.put_line('Exit Capture_FTE_Estimated_Charges()');
648: END IF;
649: EXCEPTION
650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: x_msg_data := sqlerrm;
653: IF (g_asn_debug = 'Y') THEN
654: asn_debug.put_line('Unexpected exception occured in Capture_FTE_Estimated_Charges(): ' || x_msg_data);
655: END IF;

Line 682: IF FND_API.to_Boolean( p_init_msg_list )

678:
679: SAVEPOINT PO_FTE_ACTUAL;
680:
681: -- Initialize message list if p_init_msg_list is set to TRUE.
682: IF FND_API.to_Boolean( p_init_msg_list )
683: THEN
684: FND_MSG_PUB.initialize;
685: END IF;
686:

Line 691: x_return_status := FND_API.G_RET_STS_SUCCESS;

687: IF (g_asn_debug = 'Y') THEN
688: asn_debug.put_line('Initialized FND message');
689: END IF;
690:
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: x_msg_count := 0;
693: x_msg_data := '';
694:
695: IF (g_asn_debug = 'Y') THEN

Line 824: p_encoded => FND_API.G_FALSE

820: FND_MSG_PUB.Count_And_Get
821: (
822: p_count => x_msg_count,
823: p_data => x_msg_data,
824: p_encoded => FND_API.G_FALSE
825: );
826:
827: EXCEPTION
828: WHEN l_invalid_shipment THEN

Line 830: x_return_status:= FND_API.G_RET_STS_ERROR;

826:
827: EXCEPTION
828: WHEN l_invalid_shipment THEN
829: x_msg_data := 'Invalid Shipment';
830: x_return_status:= FND_API.G_RET_STS_ERROR;
831: IF (g_asn_debug = 'Y') THEN
832: asn_debug.put_line('Invalid shipment.' );
833: END IF;
834: WHEN OTHERS THEN

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

833: END IF;
834: WHEN OTHERS THEN
835: ROLLBACK TO PO_FTE_ACTUAL;
836: x_msg_data := sqlerrm;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: IF (g_asn_debug = 'Y') THEN
839: asn_debug.put_line('Unexpected error in Capture_FTE_Actual_Charges(), err_msg:'
840: || x_msg_data);
841: END IF;