DBA Data[Home] [Help]

APPS.CLN_CH_COLLABORATION_PKG dependencies on FND_MESSAGE

Line 765: FND_MESSAGE.SET_NAME('CLN','CLN_CH_VALIDATION_SUCCESS');

761: END;
762: END IF;
763:
764:
765: FND_MESSAGE.SET_NAME('CLN','CLN_CH_VALIDATION_SUCCESS');
766: x_msg_data := FND_MESSAGE.GET;
767:
768: IF (l_Debug_Level <= 1) THEN
769: ecx_cln_debug_pub.Add('Successfully validated all parameters passed',1);

Line 766: x_msg_data := FND_MESSAGE.GET;

762: END IF;
763:
764:
765: FND_MESSAGE.SET_NAME('CLN','CLN_CH_VALIDATION_SUCCESS');
766: x_msg_data := FND_MESSAGE.GET;
767:
768: IF (l_Debug_Level <= 1) THEN
769: ecx_cln_debug_pub.Add('Successfully validated all parameters passed',1);
770: END IF;

Line 779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_PARAM_VALIDATION');

775: -- Exception Handling
776: EXCEPTION
777: WHEN FND_API.G_EXC_ERROR THEN
778: x_return_status := FND_API.G_RET_STS_ERROR ;
779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_PARAM_VALIDATION');
780: FND_MESSAGE.SET_TOKEN('PARAM',l_param);
781: FND_MESSAGE.SET_TOKEN('VALUE',l_meaning);
782: x_msg_data := FND_MESSAGE.GET;
783: IF (l_Debug_Level <= 5) THEN

Line 780: FND_MESSAGE.SET_TOKEN('PARAM',l_param);

776: EXCEPTION
777: WHEN FND_API.G_EXC_ERROR THEN
778: x_return_status := FND_API.G_RET_STS_ERROR ;
779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_PARAM_VALIDATION');
780: FND_MESSAGE.SET_TOKEN('PARAM',l_param);
781: FND_MESSAGE.SET_TOKEN('VALUE',l_meaning);
782: x_msg_data := FND_MESSAGE.GET;
783: IF (l_Debug_Level <= 5) THEN
784: ecx_cln_debug_pub.Add(l_param||' is irrelevant -'||l_meaning,4);

Line 781: FND_MESSAGE.SET_TOKEN('VALUE',l_meaning);

777: WHEN FND_API.G_EXC_ERROR THEN
778: x_return_status := FND_API.G_RET_STS_ERROR ;
779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_PARAM_VALIDATION');
780: FND_MESSAGE.SET_TOKEN('PARAM',l_param);
781: FND_MESSAGE.SET_TOKEN('VALUE',l_meaning);
782: x_msg_data := FND_MESSAGE.GET;
783: IF (l_Debug_Level <= 5) THEN
784: ecx_cln_debug_pub.Add(l_param||' is irrelevant -'||l_meaning,4);
785: ecx_cln_debug_pub.Add('-------- Exiting VALIDATE_PARAMS API ----- ',2);

Line 782: x_msg_data := FND_MESSAGE.GET;

778: x_return_status := FND_API.G_RET_STS_ERROR ;
779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_PARAM_VALIDATION');
780: FND_MESSAGE.SET_TOKEN('PARAM',l_param);
781: FND_MESSAGE.SET_TOKEN('VALUE',l_meaning);
782: x_msg_data := FND_MESSAGE.GET;
783: IF (l_Debug_Level <= 5) THEN
784: ecx_cln_debug_pub.Add(l_param||' is irrelevant -'||l_meaning,4);
785: ecx_cln_debug_pub.Add('-------- Exiting VALIDATE_PARAMS API ----- ',2);
786: END IF;

Line 1186: FND_MESSAGE.SET_NAME('CLN','CLN_CH_DOC_NUMBER_NOT_GEN');

1182: IF (p_doc_no IS NULL) THEN
1183: IF (l_Debug_Level <= 1) THEN
1184: ecx_cln_debug_pub.Add('Document Number passed as NULL',1);
1185: END IF;
1186: FND_MESSAGE.SET_NAME('CLN','CLN_CH_DOC_NUMBER_NOT_GEN');
1187: l_doc_no := FND_MESSAGE.GET;
1188: IF (l_Debug_Level <= 1) THEN
1189: ecx_cln_debug_pub.Add('Setting Document Number :'||l_doc_no,1);
1190: END IF;

Line 1187: l_doc_no := FND_MESSAGE.GET;

1183: IF (l_Debug_Level <= 1) THEN
1184: ecx_cln_debug_pub.Add('Document Number passed as NULL',1);
1185: END IF;
1186: FND_MESSAGE.SET_NAME('CLN','CLN_CH_DOC_NUMBER_NOT_GEN');
1187: l_doc_no := FND_MESSAGE.GET;
1188: IF (l_Debug_Level <= 1) THEN
1189: ecx_cln_debug_pub.Add('Setting Document Number :'||l_doc_no,1);
1190: END IF;
1191:

Line 1295: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_PARAMS_MISSING');

1291: END IF;
1292:
1293: -- Check for required parameters
1294: IF((l_app_id IS NULL) OR (l_doc_dir IS NULL)) THEN
1295: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_PARAMS_MISSING');
1296: FND_MESSAGE.SET_TOKEN('ACTION','create');
1297: x_msg_data := FND_MESSAGE.GET;
1298: l_msg_data := 'Failed to create Collaboration as required parameters Application ID/Document_Direction not found';
1299: RAISE FND_API.G_EXC_ERROR;

Line 1296: FND_MESSAGE.SET_TOKEN('ACTION','create');

1292:
1293: -- Check for required parameters
1294: IF((l_app_id IS NULL) OR (l_doc_dir IS NULL)) THEN
1295: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_PARAMS_MISSING');
1296: FND_MESSAGE.SET_TOKEN('ACTION','create');
1297: x_msg_data := FND_MESSAGE.GET;
1298: l_msg_data := 'Failed to create Collaboration as required parameters Application ID/Document_Direction not found';
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;

Line 1297: x_msg_data := FND_MESSAGE.GET;

1293: -- Check for required parameters
1294: IF((l_app_id IS NULL) OR (l_doc_dir IS NULL)) THEN
1295: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_PARAMS_MISSING');
1296: FND_MESSAGE.SET_TOKEN('ACTION','create');
1297: x_msg_data := FND_MESSAGE.GET;
1298: l_msg_data := 'Failed to create Collaboration as required parameters Application ID/Document_Direction not found';
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301:

Line 1368: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_CRITERIA_FAIL');

1364: END IF;
1365:
1366:
1367: IF (x_return_status <> 'S') THEN
1368: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_CRITERIA_FAIL');
1369: x_msg_data := FND_MESSAGE.GET;
1370: l_msg_data :='Failed to verify the required criteria for updating/creating collaboration';
1371: RAISE FND_API.G_EXC_ERROR;
1372: END IF;

Line 1369: x_msg_data := FND_MESSAGE.GET;

1365:
1366:
1367: IF (x_return_status <> 'S') THEN
1368: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_CRITERIA_FAIL');
1369: x_msg_data := FND_MESSAGE.GET;
1370: l_msg_data :='Failed to verify the required criteria for updating/creating collaboration';
1371: RAISE FND_API.G_EXC_ERROR;
1372: END IF;
1373: IF (l_update_reqd <> TRUE) THEN

Line 1458: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');

1454: ecx_cln_debug_pub.Add('Collaboration Details successfully entered in CLN_COLL_HIST_HDR TABLE',1);
1455: END IF;
1456:
1457: ELSE
1458: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1459: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_HDR');
1460: x_msg_data := FND_MESSAGE.GET;
1461: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_HDR TABLE';
1462: RAISE FND_API.G_EXC_ERROR;

Line 1459: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_HDR');

1455: END IF;
1456:
1457: ELSE
1458: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1459: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_HDR');
1460: x_msg_data := FND_MESSAGE.GET;
1461: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_HDR TABLE';
1462: RAISE FND_API.G_EXC_ERROR;
1463: END IF;

Line 1460: x_msg_data := FND_MESSAGE.GET;

1456:
1457: ELSE
1458: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1459: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_HDR');
1460: x_msg_data := FND_MESSAGE.GET;
1461: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_HDR TABLE';
1462: RAISE FND_API.G_EXC_ERROR;
1463: END IF;
1464:

Line 1470: --FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_CREATED');

1466: l_msg_text := 'CLN_CH_COLLABORATION_CREATED';
1467: END IF;
1468:
1469:
1470: --FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_CREATED');
1471: -- Calling UPDATE_COLLABORATION_INIT API
1472:
1473: UPDATE_COLLABORATION_INIT(
1474: x_return_status,x_coll_id,l_doc_type,l_doc_dir,l_coll_pt,l_doc_no,'SUCCESS',null,

Line 1485: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');

1481: END IF;
1482:
1483:
1484: IF x_return_status <> 'S' THEN
1485: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1486: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
1487: x_msg_data := FND_MESSAGE.GET;
1488: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
1489: RAISE FND_API.G_EXC_ERROR;

Line 1486: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');

1482:
1483:
1484: IF x_return_status <> 'S' THEN
1485: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1486: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
1487: x_msg_data := FND_MESSAGE.GET;
1488: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;

Line 1487: x_msg_data := FND_MESSAGE.GET;

1483:
1484: IF x_return_status <> 'S' THEN
1485: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
1486: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
1487: x_msg_data := FND_MESSAGE.GET;
1488: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:

Line 1492: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_CREATED');

1488: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_CREATED');
1493: x_msg_data := FND_MESSAGE.GET;
1494: IF (l_Debug_Level <= 1) THEN
1495: ecx_cln_debug_pub.Add(l_msg_data,1);
1496: END IF;

Line 1493: x_msg_data := FND_MESSAGE.GET;

1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_CREATED');
1493: x_msg_data := FND_MESSAGE.GET;
1494: IF (l_Debug_Level <= 1) THEN
1495: ecx_cln_debug_pub.Add(l_msg_data,1);
1496: END IF;
1497:

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

1516: ROLLBACK TO CREATE_COLLABORATION_PUB;
1517: l_error_code :=SQLCODE;
1518: l_error_msg :=SQLERRM;
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1520: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1521: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1522: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1523: x_msg_data :=FND_MESSAGE.GET;
1524: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;

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

1517: l_error_code :=SQLCODE;
1518: l_error_msg :=SQLERRM;
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1520: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1521: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1522: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1523: x_msg_data :=FND_MESSAGE.GET;
1524: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
1525: IF (l_Debug_Level <= 5) THEN

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

1518: l_error_msg :=SQLERRM;
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1520: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1521: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1522: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1523: x_msg_data :=FND_MESSAGE.GET;
1524: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
1525: IF (l_Debug_Level <= 5) THEN
1526: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 1523: x_msg_data :=FND_MESSAGE.GET;

1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1520: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1521: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1522: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1523: x_msg_data :=FND_MESSAGE.GET;
1524: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
1525: IF (l_Debug_Level <= 5) THEN
1526: ecx_cln_debug_pub.Add(l_msg_data,6);
1527: ecx_cln_debug_pub.Add('------- Exiting CREATE_COLLABORATION API ---------- ',2);

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

1533: ROLLBACK TO CREATE_COLLABORATION_PUB;
1534: l_error_code :=SQLCODE;
1535: l_error_msg :=SQLERRM;
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1537: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1538: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1539: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1540: x_msg_data :=FND_MESSAGE.GET;
1541: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;

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

1534: l_error_code :=SQLCODE;
1535: l_error_msg :=SQLERRM;
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1537: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1538: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1539: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1540: x_msg_data :=FND_MESSAGE.GET;
1541: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
1542: IF (l_Debug_Level <= 5) THEN

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

1535: l_error_msg :=SQLERRM;
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1537: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1538: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1539: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1540: x_msg_data :=FND_MESSAGE.GET;
1541: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
1542: IF (l_Debug_Level <= 5) THEN
1543: ecx_cln_debug_pub.Add(l_msg_data,4);

Line 1540: x_msg_data :=FND_MESSAGE.GET;

1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1537: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1538: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1539: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1540: x_msg_data :=FND_MESSAGE.GET;
1541: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
1542: IF (l_Debug_Level <= 5) THEN
1543: ecx_cln_debug_pub.Add(l_msg_data,4);
1544: ecx_cln_debug_pub.Add('------- Exiting CREATE_COLLABORATION API ---------- ',2);

Line 1958: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_CRITERIA_FAIL');

1954: END IF;
1955:
1956:
1957: IF (x_return_status <> 'S') THEN
1958: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_CRITERIA_FAIL');
1959: x_msg_data := FND_MESSAGE.GET;
1960: l_msg_data:='Failed to verify the required criteria for updating/creating collaboration';
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;

Line 1959: x_msg_data := FND_MESSAGE.GET;

1955:
1956:
1957: IF (x_return_status <> 'S') THEN
1958: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_CRITERIA_FAIL');
1959: x_msg_data := FND_MESSAGE.GET;
1960: l_msg_data:='Failed to verify the required criteria for updating/creating collaboration';
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1963:

Line 1977: FND_MESSAGE.SET_NAME('CLN','CLN_CH_DEFAULT_MSG_TXT');

1973:
1974:
1975: -- set the message text to default value if found null
1976: IF (l_msg_text IS NULL OR ltrim(rtrim(l_msg_text)) = '') THEN
1977: FND_MESSAGE.SET_NAME('CLN','CLN_CH_DEFAULT_MSG_TXT');
1978: l_msg_text := FND_MESSAGE.GET;
1979: IF (l_Debug_Level <= 1) THEN
1980: ecx_cln_debug_pub.Add('Message Text Value is NULL, Defaulting to : '||l_msg_text,1);
1981: END IF;

Line 1978: l_msg_text := FND_MESSAGE.GET;

1974:
1975: -- set the message text to default value if found null
1976: IF (l_msg_text IS NULL OR ltrim(rtrim(l_msg_text)) = '') THEN
1977: FND_MESSAGE.SET_NAME('CLN','CLN_CH_DEFAULT_MSG_TXT');
1978: l_msg_text := FND_MESSAGE.GET;
1979: IF (l_Debug_Level <= 1) THEN
1980: ecx_cln_debug_pub.Add('Message Text Value is NULL, Defaulting to : '||l_msg_text,1);
1981: END IF;
1982:

Line 2075: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');

2071:
2072: END IF;
2073:
2074: IF l_coll_id IS NULL THEN
2075: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');
2076: x_msg_data := FND_MESSAGE.GET;
2077: RAISE FND_API.G_EXC_ERROR;
2078: END IF;
2079:

Line 2076: x_msg_data := FND_MESSAGE.GET;

2072: END IF;
2073:
2074: IF l_coll_id IS NULL THEN
2075: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');
2076: x_msg_data := FND_MESSAGE.GET;
2077: RAISE FND_API.G_EXC_ERROR;
2078: END IF;
2079:
2080: -- If Application ID or Collaboration Type is null (this may be the case when the

Line 2146: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_PARAMS_MISSING');

2142:
2143:
2144: -- Check for required parameters
2145: IF((l_coll_status IS NULL) OR (l_doc_dir IS NULL)) THEN
2146: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_PARAMS_MISSING');
2147: FND_MESSAGE.SET_TOKEN('ACTION','update');
2148: x_msg_data := FND_MESSAGE.GET;
2149: l_msg_data := 'Failed to update Collaboration as required parameters Collaboration Status / Document Direction not found';
2150: RAISE FND_API.G_EXC_ERROR;

Line 2147: FND_MESSAGE.SET_TOKEN('ACTION','update');

2143:
2144: -- Check for required parameters
2145: IF((l_coll_status IS NULL) OR (l_doc_dir IS NULL)) THEN
2146: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_PARAMS_MISSING');
2147: FND_MESSAGE.SET_TOKEN('ACTION','update');
2148: x_msg_data := FND_MESSAGE.GET;
2149: l_msg_data := 'Failed to update Collaboration as required parameters Collaboration Status / Document Direction not found';
2150: RAISE FND_API.G_EXC_ERROR;
2151: END IF;

Line 2148: x_msg_data := FND_MESSAGE.GET;

2144: -- Check for required parameters
2145: IF((l_coll_status IS NULL) OR (l_doc_dir IS NULL)) THEN
2146: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_PARAMS_MISSING');
2147: FND_MESSAGE.SET_TOKEN('ACTION','update');
2148: x_msg_data := FND_MESSAGE.GET;
2149: l_msg_data := 'Failed to update Collaboration as required parameters Collaboration Status / Document Direction not found';
2150: RAISE FND_API.G_EXC_ERROR;
2151: END IF;
2152:

Line 2248: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');

2244: ecx_cln_debug_pub.Add('Collaboration Details successfully updated in CLN_COLL_HIST_HDR TABLE',1);
2245: END IF;
2246:
2247: ELSE
2248: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');
2249: x_msg_data := FND_MESSAGE.GET;
2250: l_msg_data := 'Unable to find the collaboration in Collaboration History';
2251: RAISE FND_API.G_EXC_ERROR;
2252: END IF;

Line 2249: x_msg_data := FND_MESSAGE.GET;

2245: END IF;
2246:
2247: ELSE
2248: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');
2249: x_msg_data := FND_MESSAGE.GET;
2250: l_msg_data := 'Unable to find the collaboration in Collaboration History';
2251: RAISE FND_API.G_EXC_ERROR;
2252: END IF;
2253:

Line 2303: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');

2299: ecx_cln_debug_pub.Add('Collaboration Details successfully entered in CLN_COLL_HIST_DTL TABLE',1);
2300: END IF;
2301:
2302: ELSE
2303: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
2304: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
2305: x_msg_data := FND_MESSAGE.GET;
2306: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
2307: RAISE FND_API.G_EXC_ERROR;

Line 2304: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');

2300: END IF;
2301:
2302: ELSE
2303: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
2304: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
2305: x_msg_data := FND_MESSAGE.GET;
2306: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;

Line 2305: x_msg_data := FND_MESSAGE.GET;

2301:
2302: ELSE
2303: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_DTLS_FAILED');
2304: FND_MESSAGE.SET_TOKEN('TABLE','CLN_COLL_HIST_DTL');
2305: x_msg_data := FND_MESSAGE.GET;
2306: l_msg_data := 'Failed to add Collaboration Details in CLN_COLL_HIST_DTL TABLE';
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309:

Line 2311: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_UPDATED');

2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309:
2310:
2311: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_UPDATED');
2312: x_msg_data := FND_MESSAGE.GET;
2313: IF (l_Debug_Level <= 1) THEN
2314: ecx_cln_debug_pub.Add(l_msg_data,1);
2315: END IF;

Line 2312: x_msg_data := FND_MESSAGE.GET;

2308: END IF;
2309:
2310:
2311: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_UPDATED');
2312: x_msg_data := FND_MESSAGE.GET;
2313: IF (l_Debug_Level <= 1) THEN
2314: ecx_cln_debug_pub.Add(l_msg_data,1);
2315: END IF;
2316:

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

2337: --ROLLBACK TO UPDATE_COLLABORATION_PUB;
2338: l_error_code :=SQLCODE;
2339: l_error_msg :=SQLERRM;
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2341: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2342: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2343: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2344: x_msg_data :=FND_MESSAGE.GET;
2345: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;

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

2338: l_error_code :=SQLCODE;
2339: l_error_msg :=SQLERRM;
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2341: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2342: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2343: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2344: x_msg_data :=FND_MESSAGE.GET;
2345: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
2346: IF (l_Debug_Level <= 5) THEN

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

2339: l_error_msg :=SQLERRM;
2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2341: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2342: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2343: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2344: x_msg_data :=FND_MESSAGE.GET;
2345: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
2346: IF (l_Debug_Level <= 5) THEN
2347: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 2344: x_msg_data :=FND_MESSAGE.GET;

2340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2341: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2342: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2343: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2344: x_msg_data :=FND_MESSAGE.GET;
2345: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
2346: IF (l_Debug_Level <= 5) THEN
2347: ecx_cln_debug_pub.Add(l_msg_data,6);
2348: ecx_cln_debug_pub.Add('------ Exiting UPDATE_COLLABORATION API ------- ',2);

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

2354: --ROLLBACK TO UPDATE_COLLABORATION_PUB;
2355: l_error_code :=SQLCODE;
2356: l_error_msg :=SQLERRM;
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2359: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2360: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2361: x_msg_data :=FND_MESSAGE.GET;
2362: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;

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

2355: l_error_code :=SQLCODE;
2356: l_error_msg :=SQLERRM;
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2359: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2360: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2361: x_msg_data :=FND_MESSAGE.GET;
2362: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
2363: IF (l_Debug_Level <= 5) THEN

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

2356: l_error_msg :=SQLERRM;
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2359: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2360: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2361: x_msg_data :=FND_MESSAGE.GET;
2362: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
2363: IF (l_Debug_Level <= 5) THEN
2364: ecx_cln_debug_pub.Add(l_msg_data,4);

Line 2361: x_msg_data :=FND_MESSAGE.GET;

2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2359: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2360: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2361: x_msg_data :=FND_MESSAGE.GET;
2362: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
2363: IF (l_Debug_Level <= 5) THEN
2364: ecx_cln_debug_pub.Add(l_msg_data,4);
2365: ecx_cln_debug_pub.Add('------ Exiting UPDATE_COLLABORATION API ------- ',2);

Line 2474: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_FOUND');

2470: ecx_cln_debug_pub.Add('--- After SQL Query : Retrieving Collaboration Status ----',1);
2471: END IF;
2472:
2473:
2474: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_FOUND');
2475: x_msg_data := FND_MESSAGE.GET;
2476:
2477: IF (l_Debug_Level <= 1) THEN
2478: ecx_cln_debug_pub.Add(l_msg_data,1);

Line 2475: x_msg_data := FND_MESSAGE.GET;

2471: END IF;
2472:
2473:
2474: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_FOUND');
2475: x_msg_data := FND_MESSAGE.GET;
2476:
2477: IF (l_Debug_Level <= 1) THEN
2478: ecx_cln_debug_pub.Add(l_msg_data,1);
2479: END IF;

Line 2493: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');

2489: WHEN FND_API.G_EXC_ERROR THEN
2490: l_error_code :=SQLCODE;
2491: l_error_msg :=SQLERRM;
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2494: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2495: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2496: x_msg_data := FND_MESSAGE.GET;
2497: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;

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

2490: l_error_code :=SQLCODE;
2491: l_error_msg :=SQLERRM;
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2494: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2495: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2496: x_msg_data := FND_MESSAGE.GET;
2497: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2498: IF (l_Debug_Level <= 4) THEN

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

2491: l_error_msg :=SQLERRM;
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2494: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2495: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2496: x_msg_data := FND_MESSAGE.GET;
2497: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2498: IF (l_Debug_Level <= 4) THEN
2499: ecx_cln_debug_pub.Add(l_msg_data,4);

Line 2496: x_msg_data := FND_MESSAGE.GET;

2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2494: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2495: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2496: x_msg_data := FND_MESSAGE.GET;
2497: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2498: IF (l_Debug_Level <= 4) THEN
2499: ecx_cln_debug_pub.Add(l_msg_data,4);
2500: ecx_cln_debug_pub.Add('----- Exiting FIND_COLLABORATION_STATUS API -----',2);

Line 2529: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');

2525:
2526: l_error_code :=SQLCODE;
2527: l_error_msg :=SQLERRM;
2528: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2529: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2530: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2531: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2532: x_msg_data := FND_MESSAGE.GET;
2533: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;

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

2526: l_error_code :=SQLCODE;
2527: l_error_msg :=SQLERRM;
2528: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2529: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2530: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2531: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2532: x_msg_data := FND_MESSAGE.GET;
2533: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2534: END;

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

2527: l_error_msg :=SQLERRM;
2528: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2529: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2530: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2531: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2532: x_msg_data := FND_MESSAGE.GET;
2533: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2534: END;
2535: IF (l_Debug_Level <= 1) THEN

Line 2532: x_msg_data := FND_MESSAGE.GET;

2528: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2529: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2530: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2531: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2532: x_msg_data := FND_MESSAGE.GET;
2533: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2534: END;
2535: IF (l_Debug_Level <= 1) THEN
2536: ecx_cln_debug_pub.Add(l_msg_data,1);

Line 2549: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');

2545: WHEN OTHERS THEN
2546: l_error_code :=SQLCODE;
2547: l_error_msg :=SQLERRM;
2548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2549: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2550: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2551: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2552: x_msg_data := FND_MESSAGE.GET;
2553: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;

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

2546: l_error_code :=SQLCODE;
2547: l_error_msg :=SQLERRM;
2548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2549: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2550: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2551: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2552: x_msg_data := FND_MESSAGE.GET;
2553: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2554: IF (l_Debug_Level <= 5) THEN

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

2547: l_error_msg :=SQLERRM;
2548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2549: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2550: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2551: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2552: x_msg_data := FND_MESSAGE.GET;
2553: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2554: IF (l_Debug_Level <= 5) THEN
2555: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 2552: x_msg_data := FND_MESSAGE.GET;

2548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2549: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_STATUS_NOT_FOUND');
2550: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2551: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2552: x_msg_data := FND_MESSAGE.GET;
2553: l_msg_data :='Collaboration status could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2554: IF (l_Debug_Level <= 5) THEN
2555: ecx_cln_debug_pub.Add(l_msg_data,6);
2556: ecx_cln_debug_pub.Add('----- Exiting FIND_COLLABORATION_STATUS API -----',2);

Line 2666: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_RETRIEVED');

2662: -- Initialize API return status to success
2663: x_return_status := FND_API.G_RET_STS_SUCCESS;
2664: l_msg_data := 'Collaboration details successfully retrieved ';
2665:
2666: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_RETRIEVED');
2667: x_msg_data := FND_MESSAGE.GET;
2668:
2669: -- get the paramaters passed
2670: IF (l_Debug_Level <= 1) THEN

Line 2667: x_msg_data := FND_MESSAGE.GET;

2663: x_return_status := FND_API.G_RET_STS_SUCCESS;
2664: l_msg_data := 'Collaboration details successfully retrieved ';
2665:
2666: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_RETRIEVED');
2667: x_msg_data := FND_MESSAGE.GET;
2668:
2669: -- get the paramaters passed
2670: IF (l_Debug_Level <= 1) THEN
2671: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);

Line 2763: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');

2759: WHEN FND_API.G_EXC_ERROR THEN
2760: l_error_code :=SQLCODE;
2761: l_error_msg :=SQLERRM;
2762: x_return_status := FND_API.G_RET_STS_ERROR ;
2763: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2764: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2765: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2766: x_msg_data := FND_MESSAGE.GET;
2767: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;

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

2760: l_error_code :=SQLCODE;
2761: l_error_msg :=SQLERRM;
2762: x_return_status := FND_API.G_RET_STS_ERROR ;
2763: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2764: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2765: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2766: x_msg_data := FND_MESSAGE.GET;
2767: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2768: IF (l_Debug_Level <= 4) THEN

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

2761: l_error_msg :=SQLERRM;
2762: x_return_status := FND_API.G_RET_STS_ERROR ;
2763: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2764: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2765: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2766: x_msg_data := FND_MESSAGE.GET;
2767: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2768: IF (l_Debug_Level <= 4) THEN
2769: ecx_cln_debug_pub.Add(l_msg_data,4);

Line 2766: x_msg_data := FND_MESSAGE.GET;

2762: x_return_status := FND_API.G_RET_STS_ERROR ;
2763: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2764: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2765: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2766: x_msg_data := FND_MESSAGE.GET;
2767: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2768: IF (l_Debug_Level <= 4) THEN
2769: ecx_cln_debug_pub.Add(l_msg_data,4);
2770: ecx_cln_debug_pub.Add('---- Exiting RETRIEVE_COLLABORATION_DETAILS API -----',2);

Line 2779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');

2775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2776: l_error_code :=SQLCODE;
2777: l_error_msg :=SQLERRM;
2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2780: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2781: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2782: x_msg_data := FND_MESSAGE.GET;
2783: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;

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

2776: l_error_code :=SQLCODE;
2777: l_error_msg :=SQLERRM;
2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2780: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2781: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2782: x_msg_data := FND_MESSAGE.GET;
2783: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2784: IF (l_Debug_Level <= 4) THEN

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

2777: l_error_msg :=SQLERRM;
2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2780: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2781: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2782: x_msg_data := FND_MESSAGE.GET;
2783: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2784: IF (l_Debug_Level <= 4) THEN
2785: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 2782: x_msg_data := FND_MESSAGE.GET;

2778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2779: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2780: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2781: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2782: x_msg_data := FND_MESSAGE.GET;
2783: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2784: IF (l_Debug_Level <= 4) THEN
2785: ecx_cln_debug_pub.Add(l_msg_data,6);
2786: ecx_cln_debug_pub.Add('---- Exiting RETRIEVE_COLLABORATION_DETAILS API -----',2);

Line 2795: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');

2791: WHEN NO_DATA_FOUND THEN
2792: l_error_code :=SQLCODE;
2793: l_error_msg :=SQLERRM;
2794: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2795: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2796: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2797: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2798: x_msg_data := FND_MESSAGE.GET;
2799: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;

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

2792: l_error_code :=SQLCODE;
2793: l_error_msg :=SQLERRM;
2794: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2795: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2796: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2797: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2798: x_msg_data := FND_MESSAGE.GET;
2799: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2800: IF (l_Debug_Level <= 5) THEN

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

2793: l_error_msg :=SQLERRM;
2794: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2795: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2796: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2797: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2798: x_msg_data := FND_MESSAGE.GET;
2799: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2800: IF (l_Debug_Level <= 5) THEN
2801: ecx_cln_debug_pub.Add(l_msg_data,4);

Line 2798: x_msg_data := FND_MESSAGE.GET;

2794: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2795: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2796: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2797: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2798: x_msg_data := FND_MESSAGE.GET;
2799: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2800: IF (l_Debug_Level <= 5) THEN
2801: ecx_cln_debug_pub.Add(l_msg_data,4);
2802: ecx_cln_debug_pub.Add('---- Exiting RETRIEVE_COLLABORATION_DETAILS API -----',2);

Line 2811: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');

2807: WHEN OTHERS THEN
2808: l_error_code :=SQLCODE;
2809: l_error_msg :=SQLERRM;
2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2811: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2812: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2813: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2814: x_msg_data := FND_MESSAGE.GET;
2815: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;

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

2808: l_error_code :=SQLCODE;
2809: l_error_msg :=SQLERRM;
2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2811: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2812: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2813: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2814: x_msg_data := FND_MESSAGE.GET;
2815: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2816: IF (l_Debug_Level <= 5) THEN

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

2809: l_error_msg :=SQLERRM;
2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2811: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2812: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2813: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2814: x_msg_data := FND_MESSAGE.GET;
2815: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2816: IF (l_Debug_Level <= 5) THEN
2817: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 2814: x_msg_data := FND_MESSAGE.GET;

2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2811: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILS_NOT_FOUND');
2812: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2813: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2814: x_msg_data := FND_MESSAGE.GET;
2815: l_msg_data :='Collaboration details could not be retrieved for the parameters passed '||l_error_code||' : '||l_error_msg;
2816: IF (l_Debug_Level <= 5) THEN
2817: ecx_cln_debug_pub.Add(l_msg_data,6);
2818: ecx_cln_debug_pub.Add('---- Exiting RETRIEVE_COLLABORATION_DETAILS API -----',2);

Line 3000: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_NOT_FOUND');

2996: WHERE collaboration_dtl_id = p_dtl_coll_id;
2997: END IF;
2998: EXCEPTION
2999: WHEN NO_DATA_FOUND THEN
3000: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_NOT_FOUND');
3001: FND_MESSAGE.SET_TOKEN('PARAM','Collaboration Detail Id');
3002: FND_MESSAGE.SET_TOKEN('VALUE',p_dtl_coll_id);
3003: x_msg_data := FND_MESSAGE.GET;
3004: l_msg_data :='Collaboration not found for the particular Collaboration Detail Id :'||p_dtl_coll_id;

Line 3001: FND_MESSAGE.SET_TOKEN('PARAM','Collaboration Detail Id');

2997: END IF;
2998: EXCEPTION
2999: WHEN NO_DATA_FOUND THEN
3000: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_NOT_FOUND');
3001: FND_MESSAGE.SET_TOKEN('PARAM','Collaboration Detail Id');
3002: FND_MESSAGE.SET_TOKEN('VALUE',p_dtl_coll_id);
3003: x_msg_data := FND_MESSAGE.GET;
3004: l_msg_data :='Collaboration not found for the particular Collaboration Detail Id :'||p_dtl_coll_id;
3005: RAISE FND_API.G_EXC_ERROR;

Line 3002: FND_MESSAGE.SET_TOKEN('VALUE',p_dtl_coll_id);

2998: EXCEPTION
2999: WHEN NO_DATA_FOUND THEN
3000: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_NOT_FOUND');
3001: FND_MESSAGE.SET_TOKEN('PARAM','Collaboration Detail Id');
3002: FND_MESSAGE.SET_TOKEN('VALUE',p_dtl_coll_id);
3003: x_msg_data := FND_MESSAGE.GET;
3004: l_msg_data :='Collaboration not found for the particular Collaboration Detail Id :'||p_dtl_coll_id;
3005: RAISE FND_API.G_EXC_ERROR;
3006: END;

Line 3003: x_msg_data := FND_MESSAGE.GET;

2999: WHEN NO_DATA_FOUND THEN
3000: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_NOT_FOUND');
3001: FND_MESSAGE.SET_TOKEN('PARAM','Collaboration Detail Id');
3002: FND_MESSAGE.SET_TOKEN('VALUE',p_dtl_coll_id);
3003: x_msg_data := FND_MESSAGE.GET;
3004: l_msg_data :='Collaboration not found for the particular Collaboration Detail Id :'||p_dtl_coll_id;
3005: RAISE FND_API.G_EXC_ERROR;
3006: END;
3007:

Line 3032: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_MSGS_FAILED');

3028: ecx_cln_debug_pub.Add('Detail Messages for a collaboration Added',1);
3029: END IF;
3030:
3031: ELSE
3032: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_MSGS_FAILED');
3033: x_msg_data :=FND_MESSAGE.GET;
3034: l_msg_data :='Failed to add Message Details';
3035: RAISE FND_API.G_EXC_ERROR;
3036: END IF;

Line 3033: x_msg_data :=FND_MESSAGE.GET;

3029: END IF;
3030:
3031: ELSE
3032: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ADD_MSGS_FAILED');
3033: x_msg_data :=FND_MESSAGE.GET;
3034: l_msg_data :='Failed to add Message Details';
3035: RAISE FND_API.G_EXC_ERROR;
3036: END IF;
3037:

Line 3038: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_MSGS_ADDED');

3034: l_msg_data :='Failed to add Message Details';
3035: RAISE FND_API.G_EXC_ERROR;
3036: END IF;
3037:
3038: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_MSGS_ADDED');
3039: x_msg_data := FND_MESSAGE.GET;
3040: IF (l_Debug_Level <= 1) THEN
3041: ecx_cln_debug_pub.Add(l_msg_data,1);
3042: END IF;

Line 3039: x_msg_data := FND_MESSAGE.GET;

3035: RAISE FND_API.G_EXC_ERROR;
3036: END IF;
3037:
3038: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_MSGS_ADDED');
3039: x_msg_data := FND_MESSAGE.GET;
3040: IF (l_Debug_Level <= 1) THEN
3041: ecx_cln_debug_pub.Add(l_msg_data,1);
3042: END IF;
3043:

Line 3065: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');

3061: l_error_code :=SQLCODE;
3062: l_error_msg :=SQLERRM;
3063: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR ;
3064: l_msg_data :='Collaboration not found for the particular Collaboration Detail Id :'||l_error_code||' : '||l_error_msg;
3065: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3066: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3067: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3068: x_msg_data := FND_MESSAGE.GET;
3069: IF (l_Debug_Level <= 5) THEN

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

3062: l_error_msg :=SQLERRM;
3063: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR ;
3064: l_msg_data :='Collaboration not found for the particular Collaboration Detail Id :'||l_error_code||' : '||l_error_msg;
3065: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3066: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3067: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3068: x_msg_data := FND_MESSAGE.GET;
3069: IF (l_Debug_Level <= 5) THEN
3070: ecx_cln_debug_pub.Add(l_msg_data,4);

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

3063: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR ;
3064: l_msg_data :='Collaboration not found for the particular Collaboration Detail Id :'||l_error_code||' : '||l_error_msg;
3065: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3066: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3067: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3068: x_msg_data := FND_MESSAGE.GET;
3069: IF (l_Debug_Level <= 5) THEN
3070: ecx_cln_debug_pub.Add(l_msg_data,4);
3071: ecx_cln_debug_pub.Add('------ Exiting ADD_COLLABORATION_MESSAGES API ------',2);

Line 3068: x_msg_data := FND_MESSAGE.GET;

3064: l_msg_data :='Collaboration not found for the particular Collaboration Detail Id :'||l_error_code||' : '||l_error_msg;
3065: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3066: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3067: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3068: x_msg_data := FND_MESSAGE.GET;
3069: IF (l_Debug_Level <= 5) THEN
3070: ecx_cln_debug_pub.Add(l_msg_data,4);
3071: ecx_cln_debug_pub.Add('------ Exiting ADD_COLLABORATION_MESSAGES API ------',2);
3072: END IF;

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

3075:
3076: WHEN OTHERS THEN
3077: l_error_code :=SQLCODE;
3078: l_error_msg :=SQLERRM;
3079: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
3080: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3081: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3082: x_msg_data :=FND_MESSAGE.GET;
3083: l_msg_data :=l_error_code||' : '||l_error_msg;

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

3076: WHEN OTHERS THEN
3077: l_error_code :=SQLCODE;
3078: l_error_msg :=SQLERRM;
3079: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
3080: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3081: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3082: x_msg_data :=FND_MESSAGE.GET;
3083: l_msg_data :=l_error_code||' : '||l_error_msg;
3084: IF (l_Debug_Level <= 5) THEN

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

3077: l_error_code :=SQLCODE;
3078: l_error_msg :=SQLERRM;
3079: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
3080: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3081: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3082: x_msg_data :=FND_MESSAGE.GET;
3083: l_msg_data :=l_error_code||' : '||l_error_msg;
3084: IF (l_Debug_Level <= 5) THEN
3085: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 3082: x_msg_data :=FND_MESSAGE.GET;

3078: l_error_msg :=SQLERRM;
3079: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
3080: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3081: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3082: x_msg_data :=FND_MESSAGE.GET;
3083: l_msg_data :=l_error_code||' : '||l_error_msg;
3084: IF (l_Debug_Level <= 5) THEN
3085: ecx_cln_debug_pub.Add(l_msg_data,6);
3086: ecx_cln_debug_pub.Add('------ Exiting ADD_COLLABORATION_MESSAGES API ------',2);

Line 3142: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ROSETTANET_STD');

3138: -- Initialize API return status to success
3139: x_return_status := FND_API.G_RET_STS_SUCCESS;
3140:
3141:
3142: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ROSETTANET_STD');
3143: x_msg_data := FND_MESSAGE.GET;
3144: l_msg_data := 'Collaboration is on RosettaNet standards';
3145: x_update_reqd := FALSE;
3146: l_protocol_type := p_sender_component ;

Line 3143: x_msg_data := FND_MESSAGE.GET;

3139: x_return_status := FND_API.G_RET_STS_SUCCESS;
3140:
3141:
3142: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ROSETTANET_STD');
3143: x_msg_data := FND_MESSAGE.GET;
3144: l_msg_data := 'Collaboration is on RosettaNet standards';
3145: x_update_reqd := FALSE;
3146: l_protocol_type := p_sender_component ;
3147:

Line 3172: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_REQD');

3168: IF (l_Debug_Level <= 1) THEN
3169: ecx_cln_debug_pub.Add('Profile Value - CLN_UPDATION found as NEVER',1);
3170: END IF;
3171:
3172: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_REQD');
3173: x_msg_data := FND_MESSAGE.GET;
3174: x_return_status := FND_API.G_RET_STS_SUCCESS;
3175: x_update_reqd := FALSE;
3176: IF (l_Debug_Level <= 1) THEN

Line 3173: x_msg_data := FND_MESSAGE.GET;

3169: ecx_cln_debug_pub.Add('Profile Value - CLN_UPDATION found as NEVER',1);
3170: END IF;
3171:
3172: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_REQD');
3173: x_msg_data := FND_MESSAGE.GET;
3174: x_return_status := FND_API.G_RET_STS_SUCCESS;
3175: x_update_reqd := FALSE;
3176: IF (l_Debug_Level <= 1) THEN
3177: ecx_cln_debug_pub.Add('Collaboration need not be created/updated',1);

Line 3209: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INVALID_PARAM');

3205: AND eep.direction = 'OUT';
3206: EXCEPTION
3207: WHEN NO_DATA_FOUND THEN
3208: l_msg_data := 'Invalid Trading Partner';
3209: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INVALID_PARAM');
3210: FND_MESSAGE.SET_TOKEN('PARAM','Trading Partner');
3211: x_msg_data := FND_MESSAGE.GET;
3212: RAISE FND_API.G_EXC_ERROR;
3213: END;

Line 3210: FND_MESSAGE.SET_TOKEN('PARAM','Trading Partner');

3206: EXCEPTION
3207: WHEN NO_DATA_FOUND THEN
3208: l_msg_data := 'Invalid Trading Partner';
3209: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INVALID_PARAM');
3210: FND_MESSAGE.SET_TOKEN('PARAM','Trading Partner');
3211: x_msg_data := FND_MESSAGE.GET;
3212: RAISE FND_API.G_EXC_ERROR;
3213: END;
3214:

Line 3211: x_msg_data := FND_MESSAGE.GET;

3207: WHEN NO_DATA_FOUND THEN
3208: l_msg_data := 'Invalid Trading Partner';
3209: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INVALID_PARAM');
3210: FND_MESSAGE.SET_TOKEN('PARAM','Trading Partner');
3211: x_msg_data := FND_MESSAGE.GET;
3212: RAISE FND_API.G_EXC_ERROR;
3213: END;
3214:
3215: -- if hub value is also entered along with the protocol or

Line 3232: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INVALID_USERID_HUB');

3228: AND ehu.hub_user_id = l_hub_user_id;
3229: EXCEPTION
3230: WHEN NO_DATA_FOUND THEN
3231: l_msg_data := 'Invalid user id for Hub';
3232: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INVALID_USERID_HUB');
3233: x_msg_data := FND_MESSAGE.GET;
3234: RAISE FND_API.G_EXC_ERROR;
3235: END;
3236: END IF;

Line 3233: x_msg_data := FND_MESSAGE.GET;

3229: EXCEPTION
3230: WHEN NO_DATA_FOUND THEN
3231: l_msg_data := 'Invalid user id for Hub';
3232: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INVALID_USERID_HUB');
3233: x_msg_data := FND_MESSAGE.GET;
3234: RAISE FND_API.G_EXC_ERROR;
3235: END;
3236: END IF;
3237: END IF;

Line 3245: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_REQD');

3241: END IF;
3242:
3243:
3244: IF(l_protocol_type <> 'IAS') THEN
3245: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_REQD');
3246: x_msg_data := FND_MESSAGE.GET;
3247: ecx_cln_debug_pub.Add('Protocol type is not IAS',1);
3248: ecx_cln_debug_pub.Add('Collaboration need not be created/updated',1);
3249: x_update_reqd :=FALSE;

Line 3246: x_msg_data := FND_MESSAGE.GET;

3242:
3243:
3244: IF(l_protocol_type <> 'IAS') THEN
3245: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_REQD');
3246: x_msg_data := FND_MESSAGE.GET;
3247: ecx_cln_debug_pub.Add('Protocol type is not IAS',1);
3248: ecx_cln_debug_pub.Add('Collaboration need not be created/updated',1);
3249: x_update_reqd :=FALSE;
3250: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3301: WHEN OTHERS THEN
3302: l_error_code :=SQLCODE;
3303: l_error_msg :=SQLERRM;
3304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3305: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
3306: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3307: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3308: x_msg_data :=FND_MESSAGE.GET;
3309: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;

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

3302: l_error_code :=SQLCODE;
3303: l_error_msg :=SQLERRM;
3304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3305: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
3306: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3307: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3308: x_msg_data :=FND_MESSAGE.GET;
3309: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
3310: IF (l_Debug_Level <= 5) THEN

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

3303: l_error_msg :=SQLERRM;
3304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3305: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
3306: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3307: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3308: x_msg_data :=FND_MESSAGE.GET;
3309: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
3310: IF (l_Debug_Level <= 5) THEN
3311: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 3308: x_msg_data :=FND_MESSAGE.GET;

3304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3305: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
3306: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3307: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3308: x_msg_data :=FND_MESSAGE.GET;
3309: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
3310: IF (l_Debug_Level <= 5) THEN
3311: ecx_cln_debug_pub.Add(l_msg_data,6);
3312: ecx_cln_debug_pub.Add('------ Exiting IS_UPDATE_REQUIRED ------- ',2);

Line 3378: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_FOUND');

3374: -- Initialize API return status to success
3375: x_return_status := FND_API.G_RET_STS_SUCCESS;
3376: l_msg_data := 'Collaboration detail id successfully found'||x_dtl_coll_id;
3377:
3378: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_FOUND');
3379: x_msg_data := FND_MESSAGE.GET;
3380:
3381: -- get the paramaters passed
3382: IF (l_Debug_Level <= 1) THEN

Line 3379: x_msg_data := FND_MESSAGE.GET;

3375: x_return_status := FND_API.G_RET_STS_SUCCESS;
3376: l_msg_data := 'Collaboration detail id successfully found'||x_dtl_coll_id;
3377:
3378: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_FOUND');
3379: x_msg_data := FND_MESSAGE.GET;
3380:
3381: -- get the paramaters passed
3382: IF (l_Debug_Level <= 1) THEN
3383: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);

Line 3507: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');

3503: OR XMLG_MSG_ID = p_xmlg_msg_id
3504: OR XMLG_INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number;
3505: EXCEPTION
3506: WHEN TOO_MANY_ROWS THEN
3507: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
3508: x_msg_data := FND_MESSAGE.GET;
3509: l_msg_data := 'Unique Collaboration Not Found';
3510: RAISE FND_API.G_EXC_ERROR;
3511:

Line 3508: x_msg_data := FND_MESSAGE.GET;

3504: OR XMLG_INTERNAL_CONTROL_NUMBER = p_xmlg_internal_control_number;
3505: EXCEPTION
3506: WHEN TOO_MANY_ROWS THEN
3507: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
3508: x_msg_data := FND_MESSAGE.GET;
3509: l_msg_data := 'Unique Collaboration Not Found';
3510: RAISE FND_API.G_EXC_ERROR;
3511:
3512: WHEN NO_DATA_FOUND THEN

Line 3538: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');

3534: IF (l_Debug_Level <= 1) THEN
3535: ecx_cln_debug_pub.Add('Unable to find the collaboration in Collaboration History - Header Table',1);
3536: END IF;
3537:
3538: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');
3539: x_msg_data := FND_MESSAGE.GET;
3540: l_msg_data := 'Unable to find the collaboration in Collaboration History - Detail Table'; RAISE FND_API.G_EXC_ERROR;
3541: WHEN TOO_MANY_ROWS THEN
3542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');

Line 3539: x_msg_data := FND_MESSAGE.GET;

3535: ecx_cln_debug_pub.Add('Unable to find the collaboration in Collaboration History - Header Table',1);
3536: END IF;
3537:
3538: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');
3539: x_msg_data := FND_MESSAGE.GET;
3540: l_msg_data := 'Unable to find the collaboration in Collaboration History - Detail Table'; RAISE FND_API.G_EXC_ERROR;
3541: WHEN TOO_MANY_ROWS THEN
3542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
3543: x_msg_data := FND_MESSAGE.GET;

Line 3542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');

3538: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_NOT_FOUND');
3539: x_msg_data := FND_MESSAGE.GET;
3540: l_msg_data := 'Unable to find the collaboration in Collaboration History - Detail Table'; RAISE FND_API.G_EXC_ERROR;
3541: WHEN TOO_MANY_ROWS THEN
3542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
3543: x_msg_data := FND_MESSAGE.GET;
3544: l_msg_data := 'Unique Collaboration Not Found';
3545: RAISE FND_API.G_EXC_ERROR;
3546: END;

Line 3543: x_msg_data := FND_MESSAGE.GET;

3539: x_msg_data := FND_MESSAGE.GET;
3540: l_msg_data := 'Unable to find the collaboration in Collaboration History - Detail Table'; RAISE FND_API.G_EXC_ERROR;
3541: WHEN TOO_MANY_ROWS THEN
3542: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
3543: x_msg_data := FND_MESSAGE.GET;
3544: l_msg_data := 'Unique Collaboration Not Found';
3545: RAISE FND_API.G_EXC_ERROR;
3546: END;
3547: ELSE

Line 3593: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');

3589: WHEN NO_DATA_FOUND THEN
3590: l_error_code :=SQLCODE;
3591: l_error_msg :=SQLERRM;
3592: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
3593: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3594: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3595: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3596: x_msg_data := FND_MESSAGE.GET;
3597: l_msg_data :='Collaboration detail id could not be found for the parameters passed :'||l_error_code||' : '||l_error_msg;

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

3590: l_error_code :=SQLCODE;
3591: l_error_msg :=SQLERRM;
3592: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
3593: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3594: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3595: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3596: x_msg_data := FND_MESSAGE.GET;
3597: l_msg_data :='Collaboration detail id could not be found for the parameters passed :'||l_error_code||' : '||l_error_msg;
3598: IF (l_Debug_Level <= 4) THEN

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

3591: l_error_msg :=SQLERRM;
3592: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
3593: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3594: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3595: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3596: x_msg_data := FND_MESSAGE.GET;
3597: l_msg_data :='Collaboration detail id could not be found for the parameters passed :'||l_error_code||' : '||l_error_msg;
3598: IF (l_Debug_Level <= 4) THEN
3599: ecx_cln_debug_pub.Add(l_msg_data,4);

Line 3596: x_msg_data := FND_MESSAGE.GET;

3592: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
3593: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3594: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3595: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3596: x_msg_data := FND_MESSAGE.GET;
3597: l_msg_data :='Collaboration detail id could not be found for the parameters passed :'||l_error_code||' : '||l_error_msg;
3598: IF (l_Debug_Level <= 4) THEN
3599: ecx_cln_debug_pub.Add(l_msg_data,4);
3600: ecx_cln_debug_pub.Add('Error in FIND_COLLABORATION_DETAIL_ID API',2);

Line 3610: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');

3606: WHEN OTHERS THEN
3607: l_error_code :=SQLCODE;
3608: l_error_msg :=SQLERRM;
3609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3610: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3611: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3612: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3613: x_msg_data := FND_MESSAGE.GET;
3614: l_msg_data :='Collaboration detail id could not be found for the parameters passed :'||l_error_code||' : '||l_error_msg;

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

3607: l_error_code :=SQLCODE;
3608: l_error_msg :=SQLERRM;
3609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3610: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3611: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3612: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3613: x_msg_data := FND_MESSAGE.GET;
3614: l_msg_data :='Collaboration detail id could not be found for the parameters passed :'||l_error_code||' : '||l_error_msg;
3615: IF (l_Debug_Level <= 5) THEN

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

3608: l_error_msg :=SQLERRM;
3609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3610: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3611: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3612: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3613: x_msg_data := FND_MESSAGE.GET;
3614: l_msg_data :='Collaboration detail id could not be found for the parameters passed :'||l_error_code||' : '||l_error_msg;
3615: IF (l_Debug_Level <= 5) THEN
3616: ecx_cln_debug_pub.Add(x_msg_data,6);

Line 3613: x_msg_data := FND_MESSAGE.GET;

3609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3610: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLL_DETAILID_NOT_FOUND');
3611: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
3612: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
3613: x_msg_data := FND_MESSAGE.GET;
3614: l_msg_data :='Collaboration detail id could not be found for the parameters passed :'||l_error_code||' : '||l_error_msg;
3615: IF (l_Debug_Level <= 5) THEN
3616: ecx_cln_debug_pub.Add(x_msg_data,6);
3617: ecx_cln_debug_pub.Add('Error in FIND_COLLABORATION_DETAIL_ID API',2);

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

3798:
3799:
3800: EXCEPTION
3801: WHEN NO_DATA_FOUND THEN
3802: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3803: x_msg_data := FND_MESSAGE.GET;
3804: ecx_cln_debug_pub.Add('Unable to find the set up details for the trading partner',1);
3805: WHEN TOO_MANY_ROWS THEN
3806: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');

Line 3803: x_msg_data := FND_MESSAGE.GET;

3799:
3800: EXCEPTION
3801: WHEN NO_DATA_FOUND THEN
3802: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3803: x_msg_data := FND_MESSAGE.GET;
3804: ecx_cln_debug_pub.Add('Unable to find the set up details for the trading partner',1);
3805: WHEN TOO_MANY_ROWS THEN
3806: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3807: x_msg_data := FND_MESSAGE.GET;

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

3802: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3803: x_msg_data := FND_MESSAGE.GET;
3804: ecx_cln_debug_pub.Add('Unable to find the set up details for the trading partner',1);
3805: WHEN TOO_MANY_ROWS THEN
3806: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3807: x_msg_data := FND_MESSAGE.GET;
3808: ecx_cln_debug_pub.Add('More then one row found for the same trading partner set up',1);
3809: END;
3810:

Line 3807: x_msg_data := FND_MESSAGE.GET;

3803: x_msg_data := FND_MESSAGE.GET;
3804: ecx_cln_debug_pub.Add('Unable to find the set up details for the trading partner',1);
3805: WHEN TOO_MANY_ROWS THEN
3806: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3807: x_msg_data := FND_MESSAGE.GET;
3808: ecx_cln_debug_pub.Add('More then one row found for the same trading partner set up',1);
3809: END;
3810:
3811: IF (l_Debug_Level <= 1) THEN

Line 3863: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TRANSACTION_NOT_FOUND');

3859:
3860:
3861: EXCEPTION
3862: WHEN NO_DATA_FOUND THEN
3863: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TRANSACTION_NOT_FOUND');
3864: x_msg_data := FND_MESSAGE.GET;
3865: IF (l_Debug_Level <= 1) THEN
3866: ecx_cln_debug_pub.Add('Unable to find External Transaction Type/ Subtype',1);
3867: END IF;

Line 3864: x_msg_data := FND_MESSAGE.GET;

3860:
3861: EXCEPTION
3862: WHEN NO_DATA_FOUND THEN
3863: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TRANSACTION_NOT_FOUND');
3864: x_msg_data := FND_MESSAGE.GET;
3865: IF (l_Debug_Level <= 1) THEN
3866: ecx_cln_debug_pub.Add('Unable to find External Transaction Type/ Subtype',1);
3867: END IF;
3868:

Line 3871: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EXCESS_TXN_FOUND');

3867: END IF;
3868:
3869:
3870: WHEN TOO_MANY_ROWS THEN
3871: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EXCESS_TXN_FOUND');
3872: x_msg_data := SUBSTR(FND_MESSAGE.GET,10);
3873: IF (l_Debug_Level <= 1) THEN
3874: ecx_cln_debug_pub.Add('More then one row found for the same transaction detail',1);
3875: END IF;

Line 3872: x_msg_data := SUBSTR(FND_MESSAGE.GET,10);

3868:
3869:
3870: WHEN TOO_MANY_ROWS THEN
3871: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EXCESS_TXN_FOUND');
3872: x_msg_data := SUBSTR(FND_MESSAGE.GET,10);
3873: IF (l_Debug_Level <= 1) THEN
3874: ecx_cln_debug_pub.Add('More then one row found for the same transaction detail',1);
3875: END IF;
3876:

Line 3901: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TRANSACTION_NOT_FOUND');

3897: ecx_cln_debug_pub.Add('==================================================================',1);
3898:
3899: EXCEPTION
3900: WHEN NO_DATA_FOUND THEN
3901: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TRANSACTION_NOT_FOUND');
3902: x_msg_data := FND_MESSAGE.GET;
3903: ecx_cln_debug_pub.Add('Unable to find Internal Transaction Type/ Subtype',1);
3904:
3905: WHEN TOO_MANY_ROWS THEN

Line 3902: x_msg_data := FND_MESSAGE.GET;

3898:
3899: EXCEPTION
3900: WHEN NO_DATA_FOUND THEN
3901: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TRANSACTION_NOT_FOUND');
3902: x_msg_data := FND_MESSAGE.GET;
3903: ecx_cln_debug_pub.Add('Unable to find Internal Transaction Type/ Subtype',1);
3904:
3905: WHEN TOO_MANY_ROWS THEN
3906: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EXCESS_TXN_FOUND');

Line 3906: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EXCESS_TXN_FOUND');

3902: x_msg_data := FND_MESSAGE.GET;
3903: ecx_cln_debug_pub.Add('Unable to find Internal Transaction Type/ Subtype',1);
3904:
3905: WHEN TOO_MANY_ROWS THEN
3906: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EXCESS_TXN_FOUND');
3907: x_msg_data := SUBSTR(FND_MESSAGE.GET,10);
3908: ecx_cln_debug_pub.Add('More then one row found for the same transaction detail',1);
3909: END;
3910: END IF;

Line 3907: x_msg_data := SUBSTR(FND_MESSAGE.GET,10);

3903: ecx_cln_debug_pub.Add('Unable to find Internal Transaction Type/ Subtype',1);
3904:
3905: WHEN TOO_MANY_ROWS THEN
3906: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EXCESS_TXN_FOUND');
3907: x_msg_data := SUBSTR(FND_MESSAGE.GET,10);
3908: ecx_cln_debug_pub.Add('More then one row found for the same transaction detail',1);
3909: END;
3910: END IF;
3911: */

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

3963:
3964:
3965: EXCEPTION
3966: WHEN NO_DATA_FOUND THEN
3967: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3968: x_msg_data := FND_MESSAGE.GET;
3969: IF (l_Debug_Level <= 1) THEN
3970: ecx_cln_debug_pub.Add('Unable to find the id details for the trading partner',1);
3971: ecx_cln_debug_pub.Add('Trying to find details without considering party type',1);

Line 3968: x_msg_data := FND_MESSAGE.GET;

3964:
3965: EXCEPTION
3966: WHEN NO_DATA_FOUND THEN
3967: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3968: x_msg_data := FND_MESSAGE.GET;
3969: IF (l_Debug_Level <= 1) THEN
3970: ecx_cln_debug_pub.Add('Unable to find the id details for the trading partner',1);
3971: ecx_cln_debug_pub.Add('Trying to find details without considering party type',1);
3972: END IF;

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

3985: AND eth.tp_header_id = etd.tp_header_id
3986: AND estd.standard_type = l_xmlg_msg_type;
3987: EXCEPTION
3988: WHEN OTHERS THEN
3989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3990: x_msg_data := FND_MESSAGE.GET;
3991: IF (l_Debug_Level <= 1) THEN
3992: ecx_cln_debug_pub.Add('Event without TP, unable to find the id details for the trading partner',1);
3993: END IF;

Line 3990: x_msg_data := FND_MESSAGE.GET;

3986: AND estd.standard_type = l_xmlg_msg_type;
3987: EXCEPTION
3988: WHEN OTHERS THEN
3989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3990: x_msg_data := FND_MESSAGE.GET;
3991: IF (l_Debug_Level <= 1) THEN
3992: ecx_cln_debug_pub.Add('Event without TP, unable to find the id details for the trading partner',1);
3993: END IF;
3994: END;

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

3994: END;
3995:
3996:
3997: WHEN TOO_MANY_ROWS THEN
3998: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3999: x_msg_data := FND_MESSAGE.GET;
4000: IF (l_Debug_Level <= 1) THEN
4001: ecx_cln_debug_pub.Add('More then one row found for the same trading partner set up',1);
4002: END IF;

Line 3999: x_msg_data := FND_MESSAGE.GET;

3995:
3996:
3997: WHEN TOO_MANY_ROWS THEN
3998: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
3999: x_msg_data := FND_MESSAGE.GET;
4000: IF (l_Debug_Level <= 1) THEN
4001: ecx_cln_debug_pub.Add('More then one row found for the same trading partner set up',1);
4002: END IF;
4003:

Line 4012: FND_MESSAGE.SET_NAME('CLN','CLN_CH_API_CALL_NOT_REQD');

4008: p_collaboration_standard := NVL(p_collaboration_standard,l_xmlg_msg_standard);
4009: END IF;
4010: ELSE
4011: x_return_status := FND_API.G_RET_STS_SUCCESS;
4012: FND_MESSAGE.SET_NAME('CLN','CLN_CH_API_CALL_NOT_REQD');
4013: x_msg_data := FND_MESSAGE.GET;
4014: IF (l_Debug_Level <= 1) THEN
4015: ecx_cln_debug_pub.Add('API - GET_TRADING_PARTNER_DETAILS need not be called as all input parameters are having non-null values ',1);
4016: END IF;

Line 4013: x_msg_data := FND_MESSAGE.GET;

4009: END IF;
4010: ELSE
4011: x_return_status := FND_API.G_RET_STS_SUCCESS;
4012: FND_MESSAGE.SET_NAME('CLN','CLN_CH_API_CALL_NOT_REQD');
4013: x_msg_data := FND_MESSAGE.GET;
4014: IF (l_Debug_Level <= 1) THEN
4015: ecx_cln_debug_pub.Add('API - GET_TRADING_PARTNER_DETAILS need not be called as all input parameters are having non-null values ',1);
4016: END IF;
4017:

Line 4043: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS');

4039: END IF;
4040:
4041:
4042:
4043: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS');
4044: x_msg_data := FND_MESSAGE.GET;
4045:
4046: l_msg_data := 'Successfully retrieved values for the Trading partner';
4047: IF (l_Debug_Level <= 1) THEN

Line 4044: x_msg_data := FND_MESSAGE.GET;

4040:
4041:
4042:
4043: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS');
4044: x_msg_data := FND_MESSAGE.GET;
4045:
4046: l_msg_data := 'Successfully retrieved values for the Trading partner';
4047: IF (l_Debug_Level <= 1) THEN
4048: ecx_cln_debug_pub.Add(l_msg_data,1);

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

4057: WHEN OTHERS THEN
4058: l_error_code :=SQLCODE;
4059: l_error_msg :=SQLERRM;
4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- sending back success for backward compatibility
4061: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4062: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4063: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4064: x_msg_data :=FND_MESSAGE.GET;
4065: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;

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

4058: l_error_code :=SQLCODE;
4059: l_error_msg :=SQLERRM;
4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- sending back success for backward compatibility
4061: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4062: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4063: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4064: x_msg_data :=FND_MESSAGE.GET;
4065: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
4066: IF (l_Debug_Level <= 6) THEN

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

4059: l_error_msg :=SQLERRM;
4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- sending back success for backward compatibility
4061: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4062: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4063: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4064: x_msg_data :=FND_MESSAGE.GET;
4065: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
4066: IF (l_Debug_Level <= 6) THEN
4067: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 4064: x_msg_data :=FND_MESSAGE.GET;

4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- sending back success for backward compatibility
4061: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4062: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4063: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4064: x_msg_data :=FND_MESSAGE.GET;
4065: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
4066: IF (l_Debug_Level <= 6) THEN
4067: ecx_cln_debug_pub.Add(l_msg_data,6);
4068: ecx_cln_debug_pub.Add('------ Exiting GET_TRADING_PARTNER_DETAILS ------- ',2);

Line 4142: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_KEY_MISSING');

4138: IF (l_Debug_Level <= 1) THEN
4139: ecx_cln_debug_pub.Add(l_msg_data,1);
4140: END IF;
4141:
4142: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_KEY_MISSING');
4143: FND_MESSAGE.SET_TOKEN('API','DEFAULT_XMLGTXN_MAPPING');
4144: x_msg_data := FND_MESSAGE.GET;
4145: x_return_status := FND_API.G_RET_STS_SUCCESS;
4146: RETURN;

Line 4143: FND_MESSAGE.SET_TOKEN('API','DEFAULT_XMLGTXN_MAPPING');

4139: ecx_cln_debug_pub.Add(l_msg_data,1);
4140: END IF;
4141:
4142: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_KEY_MISSING');
4143: FND_MESSAGE.SET_TOKEN('API','DEFAULT_XMLGTXN_MAPPING');
4144: x_msg_data := FND_MESSAGE.GET;
4145: x_return_status := FND_API.G_RET_STS_SUCCESS;
4146: RETURN;
4147: END IF;

Line 4144: x_msg_data := FND_MESSAGE.GET;

4140: END IF;
4141:
4142: FND_MESSAGE.SET_NAME('CLN','CLN_CH_REQD_KEY_MISSING');
4143: FND_MESSAGE.SET_TOKEN('API','DEFAULT_XMLGTXN_MAPPING');
4144: x_msg_data := FND_MESSAGE.GET;
4145: x_return_status := FND_API.G_RET_STS_SUCCESS;
4146: RETURN;
4147: END IF;
4148:

Line 4178: FND_MESSAGE.SET_NAME('CLN','CLN_CH_XMLGTXN_MAPPING_NF');

4174: IF (l_Debug_Level <= 1) THEN
4175: ecx_cln_debug_pub.Add(l_msg_data,1);
4176: END IF;
4177:
4178: FND_MESSAGE.SET_NAME('CLN','CLN_CH_XMLGTXN_MAPPING_NF');
4179: x_msg_data := FND_MESSAGE.GET;
4180: x_return_status := FND_API.G_RET_STS_SUCCESS;
4181: RETURN;
4182: END;

Line 4179: x_msg_data := FND_MESSAGE.GET;

4175: ecx_cln_debug_pub.Add(l_msg_data,1);
4176: END IF;
4177:
4178: FND_MESSAGE.SET_NAME('CLN','CLN_CH_XMLGTXN_MAPPING_NF');
4179: x_msg_data := FND_MESSAGE.GET;
4180: x_return_status := FND_API.G_RET_STS_SUCCESS;
4181: RETURN;
4182: END;
4183: END IF;

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

4222: WHEN OTHERS THEN
4223: l_error_code :=SQLCODE;
4224: l_error_msg :=SQLERRM;
4225: x_return_status := FND_API.G_RET_STS_SUCCESS ; -- sending back success for backward compatibility
4226: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4227: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4228: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4229: x_msg_data :=FND_MESSAGE.GET;
4230: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;

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

4223: l_error_code :=SQLCODE;
4224: l_error_msg :=SQLERRM;
4225: x_return_status := FND_API.G_RET_STS_SUCCESS ; -- sending back success for backward compatibility
4226: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4227: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4228: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4229: x_msg_data :=FND_MESSAGE.GET;
4230: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
4231: IF (l_Debug_Level <= 5) THEN

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

4224: l_error_msg :=SQLERRM;
4225: x_return_status := FND_API.G_RET_STS_SUCCESS ; -- sending back success for backward compatibility
4226: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4227: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4228: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4229: x_msg_data :=FND_MESSAGE.GET;
4230: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
4231: IF (l_Debug_Level <= 5) THEN
4232: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 4229: x_msg_data :=FND_MESSAGE.GET;

4225: x_return_status := FND_API.G_RET_STS_SUCCESS ; -- sending back success for backward compatibility
4226: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4227: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4228: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4229: x_msg_data :=FND_MESSAGE.GET;
4230: l_msg_data := 'Unexpected Error : '||l_error_code||'-'||l_error_msg;
4231: IF (l_Debug_Level <= 5) THEN
4232: ecx_cln_debug_pub.Add(l_msg_data,6);
4233: ecx_cln_debug_pub.Add('------ Exiting DEFAULT_XMLGTXN_MAPPING ------- ',2);

Line 4285: FND_MESSAGE.SET_NAME('CLN','CLN_COLL_STATUS_FOUND');

4281:
4282: -- Initialize API return status to success
4283: x_return_status := FND_API.G_RET_STS_SUCCESS;
4284:
4285: FND_MESSAGE.SET_NAME('CLN','CLN_COLL_STATUS_FOUND');
4286:
4287: IF (l_Debug_Level <= 1) THEN
4288: ecx_cln_debug_pub.Add('------------Parameters Received-------------',1);
4289: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_app_id,1);

Line 4303: FND_MESSAGE.SET_TOKEN('STATUS','ERROR');

4299:
4300:
4301: IF (p_doc_status = 'ERROR') THEN
4302: x_coll_status := 'ERROR';
4303: FND_MESSAGE.SET_TOKEN('STATUS','ERROR');
4304: x_msg_data := FND_MESSAGE.GET;
4305: IF (l_Debug_Level <= 1) THEN
4306: ecx_cln_debug_pub.Add('Collaboration Status ----- >>>'||x_coll_status ,1);
4307: END IF;

Line 4304: x_msg_data := FND_MESSAGE.GET;

4300:
4301: IF (p_doc_status = 'ERROR') THEN
4302: x_coll_status := 'ERROR';
4303: FND_MESSAGE.SET_TOKEN('STATUS','ERROR');
4304: x_msg_data := FND_MESSAGE.GET;
4305: IF (l_Debug_Level <= 1) THEN
4306: ecx_cln_debug_pub.Add('Collaboration Status ----- >>>'||x_coll_status ,1);
4307: END IF;
4308:

Line 4364: FND_MESSAGE.SET_TOKEN('STATUS','COMPLETED');

4360:
4361:
4362: IF (l_msg_count_in_hist >= l_message_count-1) THEN
4363: x_coll_status := 'COMPLETED';
4364: FND_MESSAGE.SET_TOKEN('STATUS','COMPLETED');
4365: x_msg_data := FND_MESSAGE.GET;
4366: END IF;
4367: ELSE
4368: x_coll_status := 'COMPLETED';

Line 4365: x_msg_data := FND_MESSAGE.GET;

4361:
4362: IF (l_msg_count_in_hist >= l_message_count-1) THEN
4363: x_coll_status := 'COMPLETED';
4364: FND_MESSAGE.SET_TOKEN('STATUS','COMPLETED');
4365: x_msg_data := FND_MESSAGE.GET;
4366: END IF;
4367: ELSE
4368: x_coll_status := 'COMPLETED';
4369: FND_MESSAGE.SET_TOKEN('STATUS','COMPLETED');

Line 4369: FND_MESSAGE.SET_TOKEN('STATUS','COMPLETED');

4365: x_msg_data := FND_MESSAGE.GET;
4366: END IF;
4367: ELSE
4368: x_coll_status := 'COMPLETED';
4369: FND_MESSAGE.SET_TOKEN('STATUS','COMPLETED');
4370: x_msg_data := FND_MESSAGE.GET;
4371: END IF;
4372:
4373: EXCEPTION

Line 4370: x_msg_data := FND_MESSAGE.GET;

4366: END IF;
4367: ELSE
4368: x_coll_status := 'COMPLETED';
4369: FND_MESSAGE.SET_TOKEN('STATUS','COMPLETED');
4370: x_msg_data := FND_MESSAGE.GET;
4371: END IF;
4372:
4373: EXCEPTION
4374: WHEN NO_DATA_FOUND THEN

Line 4376: FND_MESSAGE.SET_TOKEN('STATUS','STARTED');

4372:
4373: EXCEPTION
4374: WHEN NO_DATA_FOUND THEN
4375: x_coll_status := 'STARTED';
4376: FND_MESSAGE.SET_TOKEN('STATUS','STARTED');
4377: x_msg_data := FND_MESSAGE.GET;
4378: END;
4379:
4380: IF (l_Debug_Level <= 1) THEN

Line 4377: x_msg_data := FND_MESSAGE.GET;

4373: EXCEPTION
4374: WHEN NO_DATA_FOUND THEN
4375: x_coll_status := 'STARTED';
4376: FND_MESSAGE.SET_TOKEN('STATUS','STARTED');
4377: x_msg_data := FND_MESSAGE.GET;
4378: END;
4379:
4380: IF (l_Debug_Level <= 1) THEN
4381: ecx_cln_debug_pub.Add('Collaboration Status ----- >>>'||x_coll_status ,1);

Line 4510: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');

4506:
4507:
4508: EXCEPTION
4509: WHEN TOO_MANY_ROWS THEN
4510: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4511: x_msg_data := FND_MESSAGE.GET;
4512: l_msg_data := 'Unique Collaboration Not Found';
4513: RAISE FND_API.G_EXC_ERROR;
4514: WHEN NO_DATA_FOUND THEN

Line 4511: x_msg_data := FND_MESSAGE.GET;

4507:
4508: EXCEPTION
4509: WHEN TOO_MANY_ROWS THEN
4510: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4511: x_msg_data := FND_MESSAGE.GET;
4512: l_msg_data := 'Unique Collaboration Not Found';
4513: RAISE FND_API.G_EXC_ERROR;
4514: WHEN NO_DATA_FOUND THEN
4515: IF (l_Debug_Level <= 1) THEN

Line 4547: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');

4543: ecx_cln_debug_pub.Add('Unable to find the collaboration in Collaboration History - Header Table',1);
4544: END IF;
4545:
4546: WHEN TOO_MANY_ROWS THEN
4547: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4548: x_msg_data := FND_MESSAGE.GET;
4549: l_msg_data := 'Unique Collaboration Not Found';
4550: RAISE FND_API.G_EXC_ERROR;
4551:

Line 4548: x_msg_data := FND_MESSAGE.GET;

4544: END IF;
4545:
4546: WHEN TOO_MANY_ROWS THEN
4547: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4548: x_msg_data := FND_MESSAGE.GET;
4549: l_msg_data := 'Unique Collaboration Not Found';
4550: RAISE FND_API.G_EXC_ERROR;
4551:
4552: END;

Line 4590: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');

4586: ecx_cln_debug_pub.Add('Unable to find the collaboration in Collaboration History - Detail Table',1);
4587: END IF;
4588:
4589: WHEN TOO_MANY_ROWS THEN
4590: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4591: x_msg_data := FND_MESSAGE.GET;
4592: l_msg_data := 'Unique Collaboration Not Found';
4593: RAISE FND_API.G_EXC_ERROR;
4594: END;

Line 4591: x_msg_data := FND_MESSAGE.GET;

4587: END IF;
4588:
4589: WHEN TOO_MANY_ROWS THEN
4590: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4591: x_msg_data := FND_MESSAGE.GET;
4592: l_msg_data := 'Unique Collaboration Not Found';
4593: RAISE FND_API.G_EXC_ERROR;
4594: END;
4595:

Line 4627: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');

4623: ecx_cln_debug_pub.Add('Unable to find the collaboration in Collaboration History - Header Table using Transaction Type/SubType',1);
4624: END IF;
4625:
4626: WHEN TOO_MANY_ROWS THEN
4627: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4628: x_msg_data := FND_MESSAGE.GET;
4629: l_msg_data := 'Unique Collaboration Not Found';
4630: RAISE FND_API.G_EXC_ERROR;
4631: END;

Line 4628: x_msg_data := FND_MESSAGE.GET;

4624: END IF;
4625:
4626: WHEN TOO_MANY_ROWS THEN
4627: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4628: x_msg_data := FND_MESSAGE.GET;
4629: l_msg_data := 'Unique Collaboration Not Found';
4630: RAISE FND_API.G_EXC_ERROR;
4631: END;
4632:

Line 4701: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');

4697: ecx_cln_debug_pub.Add('Unable to find the collaboration in Collaboration History - Header Table using Transaction Type/SubType',1);
4698: END IF;
4699:
4700: WHEN TOO_MANY_ROWS THEN
4701: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4702: x_msg_data := FND_MESSAGE.GET;
4703: l_msg_data := 'Unique Collaboration Not Found';
4704: RAISE FND_API.G_EXC_ERROR;
4705: END;

Line 4702: x_msg_data := FND_MESSAGE.GET;

4698: END IF;
4699:
4700: WHEN TOO_MANY_ROWS THEN
4701: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNIQUE_COLLABORATION_NF');
4702: x_msg_data := FND_MESSAGE.GET;
4703: l_msg_data := 'Unique Collaboration Not Found';
4704: RAISE FND_API.G_EXC_ERROR;
4705: END;
4706: END IF;

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

4735: WHEN OTHERS THEN
4736: l_error_code :=SQLCODE;
4737: l_error_msg :=SQLERRM;
4738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4739: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4740: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4741: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4742: x_msg_data :=FND_MESSAGE.GET;
4743: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;

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

4736: l_error_code :=SQLCODE;
4737: l_error_msg :=SQLERRM;
4738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4739: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4740: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4741: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4742: x_msg_data :=FND_MESSAGE.GET;
4743: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
4744: IF (l_Debug_Level <= 4) THEN

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

4737: l_error_msg :=SQLERRM;
4738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4739: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4740: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4741: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4742: x_msg_data :=FND_MESSAGE.GET;
4743: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
4744: IF (l_Debug_Level <= 4) THEN
4745: ecx_cln_debug_pub.Add(l_msg_data,4);

Line 4742: x_msg_data :=FND_MESSAGE.GET;

4738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4739: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
4740: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
4741: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
4742: x_msg_data :=FND_MESSAGE.GET;
4743: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
4744: IF (l_Debug_Level <= 4) THEN
4745: ecx_cln_debug_pub.Add(l_msg_data,4);
4746: ecx_cln_debug_pub.Add('------ Exiting FIND_COLLABORATION_ID API ------- ',2);

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

5268: --ROLLBACK TO UPDATE_COLLABORATION_PUB;
5269: l_error_code :=SQLCODE;
5270: l_error_msg :=SQLERRM;
5271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5272: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
5273: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
5274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
5275: x_msg_data :=FND_MESSAGE.GET;
5276: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;

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

5269: l_error_code :=SQLCODE;
5270: l_error_msg :=SQLERRM;
5271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5272: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
5273: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
5274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
5275: x_msg_data :=FND_MESSAGE.GET;
5276: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
5277: IF (l_Debug_Level <= 5) THEN

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

5270: l_error_msg :=SQLERRM;
5271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5272: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
5273: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
5274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
5275: x_msg_data :=FND_MESSAGE.GET;
5276: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
5277: IF (l_Debug_Level <= 5) THEN
5278: ecx_cln_debug_pub.Add(l_msg_data,6);

Line 5275: x_msg_data :=FND_MESSAGE.GET;

5271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5272: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
5273: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
5274: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
5275: x_msg_data :=FND_MESSAGE.GET;
5276: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
5277: IF (l_Debug_Level <= 5) THEN
5278: ecx_cln_debug_pub.Add(l_msg_data,6);
5279: ecx_cln_debug_pub.Add('------ Exiting ADD_COLLABORATION API ------- ',2);

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

5285: --ROLLBACK TO UPDATE_COLLABORATION_PUB;
5286: l_error_code :=SQLCODE;
5287: l_error_msg :=SQLERRM;
5288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5289: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
5290: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
5291: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
5292: x_msg_data :=FND_MESSAGE.GET;
5293: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;

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

5286: l_error_code :=SQLCODE;
5287: l_error_msg :=SQLERRM;
5288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5289: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
5290: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
5291: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
5292: x_msg_data :=FND_MESSAGE.GET;
5293: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
5294: IF (l_Debug_Level <= 4) THEN

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

5287: l_error_msg :=SQLERRM;
5288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5289: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
5290: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
5291: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
5292: x_msg_data :=FND_MESSAGE.GET;
5293: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
5294: IF (l_Debug_Level <= 4) THEN
5295: ecx_cln_debug_pub.Add(l_msg_data,4);

Line 5292: x_msg_data :=FND_MESSAGE.GET;

5288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5289: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
5290: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
5291: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
5292: x_msg_data :=FND_MESSAGE.GET;
5293: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
5294: IF (l_Debug_Level <= 4) THEN
5295: ecx_cln_debug_pub.Add(l_msg_data,4);
5296: ecx_cln_debug_pub.Add('------ Exiting ADD_COLLABORATION API ------- ',2);