113:
114:
115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN
117: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
118: l_msg_data := FND_MESSAGE.GET;
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;
114:
115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN
117: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
118: l_msg_data := FND_MESSAGE.GET;
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:
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
128: cln_debug_pub.Add('More then one row found for the same trading partner set up',1);
129: 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
128: cln_debug_pub.Add('More then one row found for the same trading partner set up',1);
129: END IF;
130:
185: );
186:
187: EXCEPTION
188: WHEN NO_DATA_FOUND THEN
189: FND_MESSAGE.SET_NAME('CLN','CLN_CH_NO_ROW_SELECTED');
190: l_msg_data := FND_MESSAGE.GET;
191: IF (l_Debug_Level <= 1) THEN
192: cln_debug_pub.Add('No records found for the user input',1);
193: END IF;
186:
187: EXCEPTION
188: WHEN NO_DATA_FOUND THEN
189: FND_MESSAGE.SET_NAME('CLN','CLN_CH_NO_ROW_SELECTED');
190: l_msg_data := FND_MESSAGE.GET;
191: IF (l_Debug_Level <= 1) THEN
192: cln_debug_pub.Add('No records found for the user input',1);
193: END IF;
194:
283: WHEN OTHERS THEN
284: l_error_code :=SQLCODE;
285: l_error_msg :=SQLERRM;
286: x_retcode :=2 ;
287: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
288: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
289: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
290: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
291: x_errbuf := l_msg_data;
284: l_error_code :=SQLCODE;
285: l_error_msg :=SQLERRM;
286: x_retcode :=2 ;
287: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
288: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
289: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
290: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
291: x_errbuf := l_msg_data;
292: IF (l_Debug_Level <= 5) THEN
285: l_error_msg :=SQLERRM;
286: x_retcode :=2 ;
287: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
288: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
289: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
290: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
291: x_errbuf := l_msg_data;
292: IF (l_Debug_Level <= 5) THEN
293: cln_debug_pub.Add(l_msg_data,6);
707: cln_debug_pub.Add('On Hand Quantity is = '||x_quantity_on_hand,1);
708: END IF;
709:
710:
711: FND_MESSAGE.SET_NAME('CLN','CLN_INV_REPORT_GENERATED');
712: l_msg_data := FND_MESSAGE.GET;
713: IF (l_Debug_Level <= 1) THEN
714: cln_debug_pub.Add('Success Message : '||l_msg_data,1);
715: END IF;
708: END IF;
709:
710:
711: FND_MESSAGE.SET_NAME('CLN','CLN_INV_REPORT_GENERATED');
712: l_msg_data := FND_MESSAGE.GET;
713: IF (l_Debug_Level <= 1) THEN
714: cln_debug_pub.Add('Success Message : '||l_msg_data,1);
715: END IF;
716:
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;
741: x_msg_data := l_msg_data;
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;
741: x_msg_data := l_msg_data;
742: IF (l_Debug_Level <= 5) THEN
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;
741: x_msg_data := l_msg_data;
742: IF (l_Debug_Level <= 5) THEN
743: cln_debug_pub.Add(l_msg_data,6);