APPS.CLN_NOTIFY_SHIPCONF_PKG dependencies on FND_API

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

50: cln_debug_pub.Add('-------- ENTERING RAISE_UPDATE_EVENT --------------', 2);
51: END IF;
52:
53: -- Initialize API return status to success
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55: l_msg_data := 'XML Gateway successfully consumes RN 3B13_Notify_of_Shipment_Confirmation inbound document';
56:
57: FND_MESSAGE.SET_NAME('CLN','CLN_WSH_SHIPCONF_CONSUMD');
58: x_msg_data := FND_MESSAGE.GET;

Line 99: RAISE FND_API.G_EXC_ERROR;

95: l_msg_data := FND_MESSAGE.GET;
96: IF (l_Debug_Level <= 1) THEN
97: cln_debug_pub.Add('Unable to find the transaction for the document id -'||p_delivery_doc_id,1);
98: END IF;
99: RAISE FND_API.G_EXC_ERROR;
100:
101: WHEN TOO_MANY_ROWS THEN
102: FND_MESSAGE.SET_NAME('CLN','CLN_WSH_TRANS_NOT_UNIQUE');
103: l_msg_data := FND_MESSAGE.GET;

Line 107: RAISE FND_API.G_EXC_ERROR;

103: l_msg_data := FND_MESSAGE.GET;
104: IF (l_Debug_Level <= 1) THEN
105: cln_debug_pub.Add('More then one row found for the same documnet id -'||p_delivery_doc_id,1);
106: END IF;
107: RAISE FND_API.G_EXC_ERROR;
108: END;
109:
110:
111: l_cln_ch_parameters := wf_parameter_list_t();

Line 143: WHEN FND_API.G_EXC_ERROR THEN

139: cln_debug_pub.Add('----------- EXITING RAISE_UPDATE_EVENT ------------', 2);
140: END IF;
141:
142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
144: x_return_status := FND_API.G_RET_STS_ERROR ;
145:
146: IF (l_Debug_Level <= 4) THEN
147: cln_debug_pub.Add(l_msg_data,4);

Line 144: x_return_status := FND_API.G_RET_STS_ERROR ;

140: END IF;
141:
142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
144: x_return_status := FND_API.G_RET_STS_ERROR ;
145:
146: IF (l_Debug_Level <= 4) THEN
147: cln_debug_pub.Add(l_msg_data,4);
148: END IF;

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

153:
154: WHEN OTHERS THEN
155: l_error_code := SQLCODE;
156: l_error_msg := SQLERRM;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158:
159: l_msg_data := l_error_code||' : '||l_error_msg;
160: x_msg_data := l_msg_data;
161:

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

224: EXCEPTION
225: WHEN OTHERS THEN
226: l_error_code := SQLCODE;
227: l_error_msg := SQLERRM;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229:
230: l_msg_data := l_error_code||' : '||l_error_msg;
231: x_msg_data := l_msg_data;
232:

Line 306: RAISE FND_API.G_EXC_ERROR;

302: l_msg_data := FND_MESSAGE.GET;
303: IF (l_Debug_Level <= 1) THEN
304: cln_debug_pub.Add('Unable to find the transaction for the document number (of transaction history) -'||p_delivery_name,1);
305: END IF;
306: RAISE FND_API.G_EXC_ERROR;
307:
308: WHEN TOO_MANY_ROWS THEN
309: FND_MESSAGE.SET_NAME('CLN','CLN_WSH_TRANS_NOT_UNIQUE');
310: l_msg_data := FND_MESSAGE.GET;

Line 314: RAISE FND_API.G_EXC_ERROR;

310: l_msg_data := FND_MESSAGE.GET;
311: IF (l_Debug_Level <= 1) THEN
312: cln_debug_pub.Add('More then one row found for the same documnet number (of transaction history) -'||p_delivery_name,1);
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END;
316:
317: UPDATE WSH_NEW_DEL_INTERFACE
318: SET WAYBILL = p_waybill,

Line 330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

326: EXCEPTION
327: WHEN OTHERS THEN
328: l_error_code := SQLCODE;
329: l_error_msg := SQLERRM;
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
331:
332: l_msg_data := l_error_code||' : '||l_error_msg;
333: x_msg_data := l_msg_data;
334: