268: l_error_code :=SQLCODE;
269: l_error_msg :=SQLERRM;
270: x_retcode :=2 ;
271:
272: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
273: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
275: x_errbuf := FND_MESSAGE.GET;
276:
269: l_error_msg :=SQLERRM;
270: x_retcode :=2 ;
271:
272: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
273: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
275: x_errbuf := FND_MESSAGE.GET;
276:
277: IF (l_Debug_Level <= 5) THEN
270: x_retcode :=2 ;
271:
272: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
273: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
275: x_errbuf := FND_MESSAGE.GET;
276:
277: IF (l_Debug_Level <= 5) THEN
278: cln_debug_pub.Add(x_errbuf,6);
271:
272: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
273: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
275: x_errbuf := FND_MESSAGE.GET;
276:
277: IF (l_Debug_Level <= 5) THEN
278: cln_debug_pub.Add(x_errbuf,6);
279: cln_debug_pub.Add('------- Exiting raise_regqry_event API --------- ',2);
406: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
407: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
408: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
409: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
410: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
411: cln_debug_pub.Add('---------------------------------------' ,1);
412: END IF;
413:
414: cln_ch_collaboration_pkg.update_collaboration(
552: l_error_code := SQLCODE;
553: l_error_msg := SQLERRM;
554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
555:
556: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
557: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
558: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
559:
560: x_msg_data := FND_MESSAGE.GET;
553: l_error_msg := SQLERRM;
554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
555:
556: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
557: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
558: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
559:
560: x_msg_data := FND_MESSAGE.GET;
561:
554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
555:
556: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
557: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
558: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
559:
560: x_msg_data := FND_MESSAGE.GET;
561:
562: IF (l_debug_level <= 5) THEN
556: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
557: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
558: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
559:
560: x_msg_data := FND_MESSAGE.GET;
561:
562: IF (l_debug_level <= 5) THEN
563: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
564: END IF;