APPS.CLN_SYNC_INVENTORY_PKG dependencies on FND_API

Line 123: RAISE FND_API.G_EXC_ERROR;

119: IF (l_Debug_Level <= 1) THEN
120: cln_debug_pub.Add('Unable to find the set up details for the trading partner',1);
121: END IF;
122:
123: RAISE FND_API.G_EXC_ERROR;
124: WHEN TOO_MANY_ROWS THEN
125: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_UNIQUE');
126: l_msg_data := FND_MESSAGE.GET;
127: IF (l_Debug_Level <= 1) THEN

Line 131: RAISE FND_API.G_EXC_ERROR;

127: IF (l_Debug_Level <= 1) THEN
128: cln_debug_pub.Add('More then one row found for the same trading partner set up',1);
129: END IF;
130:
131: RAISE FND_API.G_EXC_ERROR;
132: END;
133: IF (l_Debug_Level <= 1) THEN
134: cln_debug_pub.Add('Trading Partner Details Found',1);
135: END IF;

Line 195: RAISE FND_API.G_EXC_ERROR;

191: IF (l_Debug_Level <= 1) THEN
192: cln_debug_pub.Add('No records found for the user input',1);
193: END IF;
194:
195: RAISE FND_API.G_EXC_ERROR;
196: WHEN TOO_MANY_ROWS THEN
197: IF (l_Debug_Level <= 1) THEN
198: cln_debug_pub.Add('More then one row found for the user input',1);
199: END IF;

Line 274: WHEN FND_API.G_EXC_ERROR THEN

270:
271: -- Exception Handling
272: EXCEPTION
273:
274: WHEN FND_API.G_EXC_ERROR THEN
275: x_retcode := 2 ;
276: x_errbuf := l_msg_data;
277: IF (l_Debug_Level <= 5) THEN
278: cln_debug_pub.Add(l_msg_data,4);

Line 576: , p_init_msg_lst => fnd_api.g_true

572:
573:
574: inv_quantity_tree_pub.query_quantities
575: ( p_api_version_number => 1
576: , p_init_msg_lst => fnd_api.g_true
577: , x_return_status => x_return_status
578: , x_msg_count => l_msg_count
579: , x_msg_data => l_msg_data
580: , p_organization_id => p_inv_org

Line 631: RAISE FND_API.G_EXC_ERROR;

627: IF (l_Debug_Level <= 2) THEN
628: cln_debug_pub.Add(' Error : '||l_msg_data,2);
629: END IF;
630:
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;
633:
634:
635: IF((p_diposition_blocked = 'Null') OR (p_diposition_blocked IS NULL)) THEN

Line 662: , p_init_msg_lst => fnd_api.g_true

658:
659:
660: inv_quantity_tree_pub.query_quantities
661: ( p_api_version_number => 1
662: , p_init_msg_lst => fnd_api.g_true
663: , x_return_status => x_return_status
664: , x_msg_count => l_msg_count
665: , x_msg_data => l_msg_data
666: , p_organization_id => p_inv_org

Line 701: RAISE FND_API.G_EXC_ERROR;

697: IF (l_Debug_Level <= 1) THEN
698: cln_debug_pub.Add(' Error : '||l_msg_data,1);
699: END IF;
700:
701: RAISE FND_API.G_EXC_ERROR;
702: END IF;
703: x_quantity_on_hand := l_qty_on_hand;
704: END IF;
705:

Line 725: WHEN FND_API.G_EXC_ERROR THEN

721: x_return_status := 'S';
722:
723: -- Exception Handling
724: EXCEPTION
725: WHEN FND_API.G_EXC_ERROR THEN
726: x_return_status := FND_API.G_RET_STS_ERROR ;
727: IF (l_Debug_Level <= 5) THEN
728: cln_debug_pub.Add(l_msg_data,4);
729: cln_debug_pub.Add('------- Exiting GET_XML_TAG_VALUES API --------- ',2);

Line 726: x_return_status := FND_API.G_RET_STS_ERROR ;

722:
723: -- Exception Handling
724: EXCEPTION
725: WHEN FND_API.G_EXC_ERROR THEN
726: x_return_status := FND_API.G_RET_STS_ERROR ;
727: IF (l_Debug_Level <= 5) THEN
728: cln_debug_pub.Add(l_msg_data,4);
729: cln_debug_pub.Add('------- Exiting GET_XML_TAG_VALUES API --------- ',2);
730: END IF;

Line 736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

732:
733: WHEN OTHERS THEN
734: l_error_code :=SQLCODE;
735: l_error_msg :=SQLERRM;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
737: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
738: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
739: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
740: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;