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 252: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

248: IF (g_asn_debug = 'Y') THEN
249: asn_debug.put_line('l_return_status: '|| l_return_status);
250: END IF;
251:
252: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
253: RAISE l_qp_api_exception;
254: END IF;
255:
256: IF l_qp_cost_table.count < 1 THEN

Line 391: x_return_status := FND_API.G_RET_STS_ERROR;

387: IF (g_asn_debug = 'Y') THEN
388: asn_debug.put_line('No QP charge for shipment header: ' ||l_rsh_id_table(i) );
389: END IF;
390: WHEN l_qp_api_exception THEN
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: IF (g_asn_debug = 'Y') THEN
393: asn_debug.put_line('QP API returned error for shipment_id: ' ||l_rsh_id_table(i) );
394: END IF;
395: WHEN others THEN

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

392: IF (g_asn_debug = 'Y') THEN
393: asn_debug.put_line('QP API returned error for shipment_id: ' ||l_rsh_id_table(i) );
394: END IF;
395: WHEN others THEN
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: x_msg_data := sqlerrm;
398: IF (g_asn_debug = 'Y') THEN
399: asn_debug.put_line('Unexpected exception occured in QP loop: '|| x_msg_data);
400: END IF;

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

429: END IF;
430:
431: EXCEPTION
432: WHEN OTHERS THEN
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: x_msg_data := sqlerrm;
435: IF (g_asn_debug = 'Y') THEN
436: asn_debug.put_line('Unexpected exception occured in Capture_QP_Charges(): '|| x_msg_data);
437: END IF;

Line 468: x_return_status := FND_API.G_RET_STS_SUCCESS;

464: END IF;
465:
466: k := 1;
467:
468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469:
470: SELECT DISTINCT shipment_header_id
471: BULK COLLECT INTO l_rsh_id_table
472: FROM rcv_transactions rt,

Line 510: p_init_msg_list => FND_API.G_FALSE,

506: l_no_fte_charge EXCEPTION;
507: BEGIN
508:
509: FTE_PO_INTEGRATION_GRP.get_estimated_rates(
510: p_init_msg_list => FND_API.G_FALSE,
511: p_api_version_number => 1.0,
512: x_msg_count => l_msg_count,
513: x_msg_data => l_msg_data,
514: x_return_status => l_return_status,

Line 518: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

514: x_return_status => l_return_status,
515: p_shipment_header_id => l_rsh_id_table(i),
516: x_receipt_lines_tab => l_fte_cost_table);
517:
518: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
519: RAISE l_fte_exception;
520: END IF;
521:
522: IF (g_asn_debug = 'Y') THEN

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632: IF (g_asn_debug = 'Y') THEN
633: asn_debug.put_line('No FTE charges retreived for shipment_id: '||l_rsh_id_table(i));
634: END IF;
635: WHEN l_fte_exception THEN
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: x_msg_data := l_msg_data;
638: IF (g_asn_debug = 'Y') THEN
639: asn_debug.put_line('FTE API failed for shipment_id: '||l_rsh_id_table(i)||'. msg_data: '|| l_msg_data );
640: END IF;

Line 642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

638: IF (g_asn_debug = 'Y') THEN
639: asn_debug.put_line('FTE API failed for shipment_id: '||l_rsh_id_table(i)||'. msg_data: '|| l_msg_data );
640: END IF;
641: WHEN others THEN
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: x_msg_data := sqlerrm;
644: IF (g_asn_debug = 'Y') THEN
645: asn_debug.put_line('Unexpected exception occured in FTE loop: '|| x_msg_data);
646: END IF;

Line 681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

677: asn_debug.put_line('Exit Capture_FTE_Estimated_Charges()');
678: END IF;
679: EXCEPTION
680: WHEN OTHERS THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: x_msg_data := sqlerrm;
683: IF (g_asn_debug = 'Y') THEN
684: asn_debug.put_line('Unexpected exception occured in Capture_FTE_Estimated_Charges(): ' || x_msg_data);
685: END IF;

Line 712: IF FND_API.to_Boolean( p_init_msg_list )

708:
709: SAVEPOINT PO_FTE_ACTUAL;
710:
711: -- Initialize message list if p_init_msg_list is set to TRUE.
712: IF FND_API.to_Boolean( p_init_msg_list )
713: THEN
714: FND_MSG_PUB.initialize;
715: END IF;
716:

Line 721: x_return_status := FND_API.G_RET_STS_SUCCESS;

717: IF (g_asn_debug = 'Y') THEN
718: asn_debug.put_line('Initialized FND message');
719: END IF;
720:
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: x_msg_count := 0;
723: x_msg_data := '';
724:
725: IF (g_asn_debug = 'Y') THEN

Line 854: p_encoded => FND_API.G_FALSE

850: FND_MSG_PUB.Count_And_Get
851: (
852: p_count => x_msg_count,
853: p_data => x_msg_data,
854: p_encoded => FND_API.G_FALSE
855: );
856:
857: EXCEPTION
858: WHEN l_invalid_shipment THEN

Line 860: x_return_status:= FND_API.G_RET_STS_ERROR;

856:
857: EXCEPTION
858: WHEN l_invalid_shipment THEN
859: x_msg_data := 'Invalid Shipment';
860: x_return_status:= FND_API.G_RET_STS_ERROR;
861: IF (g_asn_debug = 'Y') THEN
862: asn_debug.put_line('Invalid shipment.' );
863: END IF;
864: WHEN OTHERS THEN

Line 867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

863: END IF;
864: WHEN OTHERS THEN
865: ROLLBACK TO PO_FTE_ACTUAL;
866: x_msg_data := sqlerrm;
867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868: IF (g_asn_debug = 'Y') THEN
869: asn_debug.put_line('Unexpected error in Capture_FTE_Actual_Charges(), err_msg:'
870: || x_msg_data);
871: END IF;