DBA Data[Home] [Help]

APPS.CLN_SYNC_INVENTORY_PKG dependencies on FND_MESSAGE

Line 117: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');

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;

Line 118: l_msg_data := FND_MESSAGE.GET;

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:

Line 125: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_UNIQUE');

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;

Line 126: l_msg_data := FND_MESSAGE.GET;

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:

Line 189: FND_MESSAGE.SET_NAME('CLN','CLN_CH_NO_ROW_SELECTED');

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;

Line 190: l_msg_data := FND_MESSAGE.GET;

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:

Line 287: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');

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;

Line 288: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);

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

Line 289: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);

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);

Line 711: FND_MESSAGE.SET_NAME('CLN','CLN_INV_REPORT_GENERATED');

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;

Line 712: l_msg_data := FND_MESSAGE.GET;

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:

Line 737: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');

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;

Line 738: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);

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

Line 739: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);

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);