eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_ACK_PO_PKG dependencies on FND_API

Line 96: x_return_status := FND_API.G_RET_STS_SUCCESS;

92: cln_debug_pub.Add('-------- ENTERING RAISE_UPDATE_EVENT -----------', 2);
93: END IF;
94:
95: -- Initialize API return status to success
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97: l_msg_data := 'Update event successfully raised';
98:
99: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
100: FND_MESSAGE.SET_TOKEN('EVENT','Update');

Line 142: WHEN FND_API.G_EXC_ERROR THEN

138: END IF;
139:
140:
141: EXCEPTION
142: WHEN FND_API.G_EXC_ERROR THEN
143: l_error_code := SQLCODE;
144: l_error_msg := SQLERRM;
145: x_return_status := FND_API.G_RET_STS_ERROR ;
146: x_msg_data := l_error_code||' : '||l_error_msg;

Line 145: x_return_status := FND_API.G_RET_STS_ERROR ;

141: EXCEPTION
142: WHEN FND_API.G_EXC_ERROR THEN
143: l_error_code := SQLCODE;
144: l_error_msg := SQLERRM;
145: x_return_status := FND_API.G_RET_STS_ERROR ;
146: x_msg_data := l_error_code||' : '||l_error_msg;
147: IF (l_Debug_Level <= 6) THEN
148: cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 6);
149: cln_debug_pub.Add('----------- ERROR :EXITING RAISE_UPDATE_EVENT ------------', 6);

Line 155: x_return_status := FND_API.G_RET_STS_ERROR ;

151:
152: WHEN OTHERS THEN
153: l_error_code := SQLCODE;
154: l_error_msg := SQLERRM;
155: x_return_status := FND_API.G_RET_STS_ERROR ;
156: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
157: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
158: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
159: x_msg_data := FND_MESSAGE.GET;

Line 210: x_return_status := FND_API.G_RET_STS_SUCCESS;

206: cln_debug_pub.Add('-------- ENTERING RAISE_ADD_MSG_EVENT ------------', 2);
207: END IF;
208:
209: -- Initialize API return status to success
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: l_msg_data := 'Add Messages successfully raised';
212:
213: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
214: FND_MESSAGE.SET_TOKEN('EVENT','Add Messages');

Line 261: WHEN FND_API.G_EXC_ERROR THEN

257: END IF;
258:
259:
260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: x_return_status :=FND_API.G_RET_STS_ERROR ;
263: IF (l_Debug_Level <= 5) THEN
264: cln_debug_pub.Add('Error:' || x_msg_data, 4);
265: cln_debug_pub.Add('--------- ERROR :EXITING RAISE_ADD_MSG_EVENT -------------', 2);

Line 262: x_return_status :=FND_API.G_RET_STS_ERROR ;

258:
259:
260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: x_return_status :=FND_API.G_RET_STS_ERROR ;
263: IF (l_Debug_Level <= 5) THEN
264: cln_debug_pub.Add('Error:' || x_msg_data, 4);
265: cln_debug_pub.Add('--------- ERROR :EXITING RAISE_ADD_MSG_EVENT -------------', 2);
266: END IF;

Line 271: x_return_status :=FND_API.G_RET_STS_ERROR ;

267:
268: WHEN OTHERS THEN
269: l_error_code := SQLCODE;
270: l_error_msg := SQLERRM;
271: x_return_status :=FND_API.G_RET_STS_ERROR ;
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_msg_data :=FND_MESSAGE.GET;

Line 358: x_return_status := FND_API.G_RET_STS_SUCCESS;

354: -- Standard Start of API savepoint
355: SAVEPOINT CHECK_COLLABORATION_PUB;
356:
357: -- Initialize API return status to success
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359: l_msg_data := 'ACKPO Header successfully consumed';
360: l_call_po_apis := 'YES';
361: x_cln_required := 'TRUE';
362:

Line 406: RAISE FND_API.G_EXC_ERROR;

402: x_msg_data := FND_MESSAGE.GET;
403: l_msg_data :='Failed to verify the required criteria for updating/creating.collaboration';
404: x_coll_id :=null;
405: x_cln_required :='FALSE';
406: RAISE FND_API.G_EXC_ERROR;
407: ELSE
408: IF (l_update_reqd <> TRUE) THEN
409: x_cln_required := 'FALSE';
410: x_coll_id := null;

Line 432: RAISE FND_API.G_EXC_ERROR;

428: FND_MESSAGE.SET_TOKEN('PARAM','Application reference ID');
429: x_coll_id := null;
430: x_msg_data := FND_MESSAGE.GET;
431: l_msg_data :='Application reference ID is null';
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434:
435: IF (l_Debug_Level <= 1) THEN
436: cln_debug_pub.Add('Application Reference ID is not null',1);

Line 452: RAISE FND_API.G_EXC_ERROR;

448: FND_MESSAGE.SET_TOKEN('REFID',p_ref_id);
449: x_msg_data := FND_MESSAGE.GET;
450: x_coll_id := null;
451: l_msg_data :='Collaboration Not Found For Application reference ID :'||p_ref_id;
452: RAISE FND_API.G_EXC_ERROR;
453: END;
454: IF (l_Debug_Level <= 1) THEN
455: cln_debug_pub.Add('Collaboration ID retrieved as : '||x_coll_id,1);
456: cln_debug_pub.Add('Collaboration Type retrieved as : '||x_collaboration_type,1);

Line 515: RAISE FND_API.G_EXC_ERROR;

511: -- If initialize_chn_ack_inbound errored out
512: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
513: x_msg_data := l_error_status;
514: l_msg_data := l_error_status;
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517: IF (l_Debug_Level <= 2) THEN
518: cln_debug_pub.Add('PO_CHG_REQUEST_GRP.initialize_chn_ack_inbound returned Success',1);
519: END IF;

Line 531: RAISE FND_API.G_EXC_ERROR;

527: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_INVALID_TAG_VALUE');
528: FND_MESSAGE.SET_TOKEN('TAG','ACKHEADER/ACKCODE');
529: x_msg_data :=FND_MESSAGE.GET;
530: l_msg_data :='Invalid value for ACKHEADER/ACKCODE tag.';
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;
533:
534: SELECT meaning INTO l_action FROM fnd_lookups
535: WHERE lookup_code = x_collaboration_type AND lookup_type = 'CLN_COLLABORATION_TYPE';

Line 545: RAISE FND_API.G_EXC_ERROR;

541: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_TYPE_NOT');
542: FND_MESSAGE.SET_TOKEN('TYPE','CLN_COLLABORATION_TYPE');
543: FND_MESSAGE.SET_TOKEN('CODE',l_action);
544: x_msg_data := FND_MESSAGE.GET;
545: RAISE FND_API.G_EXC_ERROR;
546: END;
547: ELSE
548: l_action := 'Acknowledge PO';
549: END IF;

Line 612: RAISE FND_API.G_EXC_ERROR;

608: -- If validate header errored out
609: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
610: x_msg_data := l_error_status;
611: l_msg_data := l_error_status;
612: RAISE FND_API.G_EXC_ERROR;
613: END IF;
614: IF (l_Debug_Level <= 2) THEN
615: cln_debug_pub.Add('PO_CHG_REQUEST_GRP.validate_header returned Success',1);
616: END IF;

Line 653: RAISE FND_API.G_EXC_ERROR;

649:
650: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
651: x_msg_data := l_error_status;
652: l_msg_data := l_error_status;
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655:
656: END IF;
657: END IF;

Line 684: WHEN FND_API.G_EXC_ERROR THEN

680:
681: -- Exception Handling
682: EXCEPTION
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR ;
686: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_ERROR');
687: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);
688: FND_MESSAGE.SET_TOKEN('RELNUM',p_release_number);

Line 685: x_return_status := FND_API.G_RET_STS_ERROR ;

681: -- Exception Handling
682: EXCEPTION
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR ;
686: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_ERROR');
687: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);
688: FND_MESSAGE.SET_TOKEN('RELNUM',p_release_number);
689: FND_MESSAGE.SET_TOKEN('REVNUM',p_revision_number);

Line 703: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

699:
700: WHEN OTHERS THEN
701: l_error_code :=SQLCODE;
702: l_error_msg :=SQLERRM;
703: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
704: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
706: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
707: x_msg_data :=FND_MESSAGE.GET;

Line 918: RAISE FND_API.G_EXC_ERROR;

914:
915: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
916: x_msg_data := l_error_status;
917: l_msg_data := l_error_status;
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920:
921: ELSE
922:

Line 1034: RAISE FND_API.G_EXC_ERROR;

1030:
1031: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
1032: x_msg_data := l_error_status;
1033: l_msg_data := l_error_status;
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036:
1037: END IF;
1038:

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038:
1039: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
1040: x_msg_data := l_error_status;
1041: l_msg_data := l_error_status;
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044:
1045: /*
1046: IF l_error_id IS NULL OR l_error_id = 0 THEN

Line 1066: RAISE FND_API.G_EXC_ERROR;

1062:
1063: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
1064: x_msg_data := l_error_status;
1065: l_msg_data := l_error_status;
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068:
1069:
1070: IF ((p_cln_required = 'TRUE') AND (p_if_collaboration_updated = 'FALSE'))THEN

Line 1087: RAISE FND_API.G_EXC_ERROR;

1083:
1084: IF(x_return_status <> 'S')THEN
1085: p_if_collaboration_updated := 'ERROR';
1086: l_msg_data := 'Error in RAISE_UPDATE_EVENT API';
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089: p_if_collaboration_updated := 'TRUE';
1090: END IF;
1091:

Line 1121: RAISE FND_API.G_EXC_ERROR;

1117:
1118: IF(x_return_status <> 'S')THEN
1119: p_if_collaboration_updated := 'ERROR';
1120: l_msg_data := 'Error in RAISE_ADD_MSG_EVENT API';
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1123:
1124: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_CONSUMED');
1125: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);

Line 1131: x_return_status := FND_API.G_RET_STS_SUCCESS;

1127: END IF;
1128:
1129: --p_msg_dtl_screen := NULL;
1130: p_msg_txt_lines := NULL;
1131: x_return_status := FND_API.G_RET_STS_SUCCESS;
1132:
1133: IF (l_Debug_Level <= 1) THEN
1134: cln_debug_pub.Add(l_msg_data,1);
1135: END IF;

Line 1143: WHEN FND_API.G_EXC_ERROR THEN

1139:
1140: -- Exception Handling
1141: EXCEPTION
1142:
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR ;
1145: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_ERROR');
1146: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);
1147: FND_MESSAGE.SET_TOKEN('RELNUM',p_release_number);

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR ;

1140: -- Exception Handling
1141: EXCEPTION
1142:
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR ;
1145: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_ERROR');
1146: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);
1147: FND_MESSAGE.SET_TOKEN('RELNUM',p_release_number);
1148: FND_MESSAGE.SET_TOKEN('REVNUM',p_revision_number);

Line 1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1153: cln_debug_pub.Add('------- ERROR :Exiting PROCESS_HEADER_LINES API --------- ',2);
1154: END IF;
1155:
1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: l_error_code :=SQLCODE;
1159: l_error_msg :=SQLERRM;
1160: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1161: l_msg_data :=l_error_code||' : '||l_error_msg;

Line 1160: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

1156:
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: l_error_code :=SQLCODE;
1159: l_error_msg :=SQLERRM;
1160: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1161: l_msg_data :=l_error_code||' : '||l_error_msg;
1162: IF (l_Debug_Level <= 5) THEN
1163: cln_debug_pub.Add(l_msg_data,6);
1164: cln_debug_pub.Add('------- ERROR :Exiting PROCESS_HEADER_LINES API --------- ',2);

Line 1170: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

1166:
1167: WHEN OTHERS THEN
1168: l_error_code :=SQLCODE;
1169: l_error_msg :=SQLERRM;
1170: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1171: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1172: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1173: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1174: x_msg_data :=FND_MESSAGE.GET;

Line 1300: RAISE FND_API.G_EXC_ERROR;

1296: -- we are returning back the failure incase the initial code returned was error.
1297: -- This code is deliberately called after the API call.
1298: IF x_return_status <> 'S' THEN
1299: l_msg_data := x_msg_data;
1300: RAISE FND_API.G_EXC_ERROR;
1301: END IF;
1302:
1303: IF ( l_errored_code = 0 ) THEN
1304: x_msg_data := l_errored_msg;

Line 1305: RAISE FND_API.G_EXC_ERROR;

1301: END IF;
1302:
1303: IF ( l_errored_code = 0 ) THEN
1304: x_msg_data := l_errored_msg;
1305: RAISE FND_API.G_EXC_ERROR;
1306: END IF;
1307:
1308: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
1309: x_msg_data := l_error_status;

Line 1311: RAISE FND_API.G_EXC_ERROR;

1307:
1308: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
1309: x_msg_data := l_error_status;
1310: l_msg_data := l_error_status;
1311: RAISE FND_API.G_EXC_ERROR;
1312: END IF;
1313:
1314: x_return_status := 'S';
1315:

Line 1324: WHEN FND_API.G_EXC_ERROR THEN

1320: cln_debug_pub.Add('----- EXITING LOAD_CHANGES WITH SUCCESS-----', 2);
1321: END IF;
1322:
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := FND_API.G_RET_STS_ERROR ;
1326: IF (l_Debug_Level <= 5) THEN
1327: cln_debug_pub.Add(l_msg_data,4);
1328: cln_debug_pub.Add('------- ERROR :Exiting LOAD_CHANGES API --------- ',2);

Line 1325: x_return_status := FND_API.G_RET_STS_ERROR ;

1321: END IF;
1322:
1323: EXCEPTION
1324: WHEN FND_API.G_EXC_ERROR THEN
1325: x_return_status := FND_API.G_RET_STS_ERROR ;
1326: IF (l_Debug_Level <= 5) THEN
1327: cln_debug_pub.Add(l_msg_data,4);
1328: cln_debug_pub.Add('------- ERROR :Exiting LOAD_CHANGES API --------- ',2);
1329: END IF;

Line 1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1327: cln_debug_pub.Add(l_msg_data,4);
1328: cln_debug_pub.Add('------- ERROR :Exiting LOAD_CHANGES API --------- ',2);
1329: END IF;
1330:
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: l_error_code :=SQLCODE;
1333: l_error_msg :=SQLERRM;
1334: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1335: l_msg_data :=l_error_code||' : '||l_error_msg;

Line 1334: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

1330:
1331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1332: l_error_code :=SQLCODE;
1333: l_error_msg :=SQLERRM;
1334: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1335: l_msg_data :=l_error_code||' : '||l_error_msg;
1336: IF (l_Debug_Level <= 5) THEN
1337: cln_debug_pub.Add(l_msg_data,5);
1338: cln_debug_pub.Add('------- ERROR :Exiting LOAD_CHANGES API --------- ',2);

Line 1344: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

1340:
1341: WHEN OTHERS THEN
1342: l_error_code :=SQLCODE;
1343: l_error_msg :=SQLERRM;
1344: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1345: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1346: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1347: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1348: x_msg_data :=FND_MESSAGE.GET;

Line 1421: --- RAISE FND_API.G_EXC_ERROR;

1417: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(x_msg_data);
1418: l_msg_data := 'Collaboration ID is null. Moving out of ERROR HANDLER API.';
1419: ----Changes made for rnet messages
1420:
1421: --- RAISE FND_API.G_EXC_ERROR;
1422:
1423: ----Changes made for rnet messages
1424: END IF;
1425:

Line 1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1459: p_msg_text => l_error_msg,
1460: p_internal_control_number => p_internal_control_number );
1461:
1462: IF(x_return_status <> 'S')THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464: END IF;
1465:
1466: x_msg_data := l_msg_buffer; -- restoring the actual error msg.
1467:

Line 1482: WHEN FND_API.G_EXC_ERROR THEN

1478:
1479: -- Exception Handling
1480: EXCEPTION
1481:
1482: WHEN FND_API.G_EXC_ERROR THEN
1483: x_return_status := FND_API.G_RET_STS_ERROR ;
1484: IF (l_Debug_Level <= 5) THEN
1485: cln_debug_pub.Add(l_msg_data,4);
1486: cln_debug_pub.Add('------- ERROR :Exiting ACKPO_ERROR_HANDLER API --------- ',2);

Line 1483: x_return_status := FND_API.G_RET_STS_ERROR ;

1479: -- Exception Handling
1480: EXCEPTION
1481:
1482: WHEN FND_API.G_EXC_ERROR THEN
1483: x_return_status := FND_API.G_RET_STS_ERROR ;
1484: IF (l_Debug_Level <= 5) THEN
1485: cln_debug_pub.Add(l_msg_data,4);
1486: cln_debug_pub.Add('------- ERROR :Exiting ACKPO_ERROR_HANDLER API --------- ',2);
1487: END IF;

Line 1489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1485: cln_debug_pub.Add(l_msg_data,4);
1486: cln_debug_pub.Add('------- ERROR :Exiting ACKPO_ERROR_HANDLER API --------- ',2);
1487: END IF;
1488:
1489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1490: l_error_code :=SQLCODE;
1491: l_error_msg :=SQLERRM;
1492: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1493: l_msg_data :=l_error_code||' : '||l_error_msg;

Line 1492: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

1488:
1489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1490: l_error_code :=SQLCODE;
1491: l_error_msg :=SQLERRM;
1492: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1493: l_msg_data :=l_error_code||' : '||l_error_msg;
1494: IF (l_Debug_Level <= 5) THEN
1495: cln_debug_pub.Add(l_msg_data,6);
1496: cln_debug_pub.Add('------- ERROR :Exiting ACKPO_ERROR_HANDLER API --------- ',2);

Line 1502: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

1498:
1499: WHEN OTHERS THEN
1500: l_error_code :=SQLCODE;
1501: l_error_msg :=SQLERRM;
1502: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1503: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1504: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1505: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1506: x_msg_data :=FND_MESSAGE.GET;

Line 1585: x_return_status := FND_API.G_RET_STS_SUCCESS;

1581: -- Standard Start of API savepoint
1582: SAVEPOINT CHECK_COLLABORATION_PUB;
1583:
1584: -- Initialize API return status to success
1585: x_return_status := FND_API.G_RET_STS_SUCCESS;
1586: l_msg_data := 'ACKPO Header successfully consumed';
1587: l_call_po_apis := 'YES';
1588: x_cln_required := 'TRUE';
1589:

Line 1633: RAISE FND_API.G_EXC_ERROR;

1629: x_msg_data := FND_MESSAGE.GET;
1630: l_msg_data :='Failed to verify the required criteria for updating/creating.collaboration';
1631: -- x_coll_id :=null;
1632: x_cln_required :='FALSE';
1633: RAISE FND_API.G_EXC_ERROR;
1634: ELSE
1635: IF (l_update_reqd <> TRUE) THEN
1636: x_cln_required := 'FALSE';
1637: -- x_coll_id := null;

Line 1698: RAISE FND_API.G_EXC_ERROR;

1694: -- If initialize_chn_ack_inbound errored out
1695: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
1696: x_msg_data := l_error_status;
1697: l_msg_data := l_error_status;
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700: IF (l_Debug_Level <= 2) THEN
1701: cln_debug_pub.Add('PO_CHG_REQUEST_GRP.initialize_chn_ack_inbound returned Success',1);
1702: END IF;

Line 1714: RAISE FND_API.G_EXC_ERROR;

1710: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_INVALID_TAG_VALUE');
1711: FND_MESSAGE.SET_TOKEN('TAG','ACKHEADER/ACKCODE');
1712: x_msg_data :=FND_MESSAGE.GET;
1713: l_msg_data :='Invalid value for ACKHEADER/ACKCODE tag.';
1714: RAISE FND_API.G_EXC_ERROR;
1715: END IF;
1716:
1717: SELECT meaning INTO l_action FROM fnd_lookups
1718: WHERE lookup_code = p_collaboration_type AND lookup_type = 'CLN_COLLABORATION_TYPE';

Line 1728: RAISE FND_API.G_EXC_ERROR;

1724: FND_MESSAGE.SET_NAME('CLN','CLN_CH_COLLABORATION_TYPE_NOT');
1725: FND_MESSAGE.SET_TOKEN('TYPE','CLN_COLLABORATION_TYPE');
1726: FND_MESSAGE.SET_TOKEN('CODE',l_action);
1727: x_msg_data := FND_MESSAGE.GET;
1728: RAISE FND_API.G_EXC_ERROR;
1729: END;
1730: ELSE
1731: l_action := 'Acknowledge PO';
1732: END IF;

Line 1795: RAISE FND_API.G_EXC_ERROR;

1791: -- If validate header errored out
1792: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
1793: x_msg_data := l_error_status;
1794: l_msg_data := l_error_status;
1795: RAISE FND_API.G_EXC_ERROR;
1796: END IF;
1797: IF (l_Debug_Level <= 2) THEN
1798: cln_debug_pub.Add('PO_CHG_REQUEST_GRP.validate_header returned Success',1);
1799: END IF;

Line 1836: RAISE FND_API.G_EXC_ERROR;

1832:
1833: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
1834: x_msg_data := l_error_status;
1835: l_msg_data := l_error_status;
1836: RAISE FND_API.G_EXC_ERROR;
1837: END IF;
1838:
1839: END IF;
1840: END IF;

Line 1867: WHEN FND_API.G_EXC_ERROR THEN

1863:
1864: -- Exception Handling
1865: EXCEPTION
1866:
1867: WHEN FND_API.G_EXC_ERROR THEN
1868: x_return_status := FND_API.G_RET_STS_ERROR ;
1869: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_ERROR');
1870: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);
1871: FND_MESSAGE.SET_TOKEN('RELNUM',p_release_number);

Line 1868: x_return_status := FND_API.G_RET_STS_ERROR ;

1864: -- Exception Handling
1865: EXCEPTION
1866:
1867: WHEN FND_API.G_EXC_ERROR THEN
1868: x_return_status := FND_API.G_RET_STS_ERROR ;
1869: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_ERROR');
1870: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);
1871: FND_MESSAGE.SET_TOKEN('RELNUM',p_release_number);
1872: FND_MESSAGE.SET_TOKEN('REVNUM',p_revision_number);

Line 1886: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

1882:
1883: WHEN OTHERS THEN
1884: l_error_code :=SQLCODE;
1885: l_error_msg :=SQLERRM;
1886: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
1887: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
1888: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
1889: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
1890: x_msg_data :=FND_MESSAGE.GET;

Line 2102: RAISE FND_API.G_EXC_ERROR;

2098:
2099: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
2100: x_msg_data := l_error_status;
2101: l_msg_data := l_error_status;
2102: RAISE FND_API.G_EXC_ERROR;
2103: END IF;
2104:
2105: ELSE
2106:

Line 2218: RAISE FND_API.G_EXC_ERROR;

2214:
2215: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
2216: x_msg_data := l_error_status;
2217: l_msg_data := l_error_status;
2218: RAISE FND_API.G_EXC_ERROR;
2219: END IF;
2220:
2221: END IF;
2222:

Line 2226: RAISE FND_API.G_EXC_ERROR;

2222:
2223: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
2224: x_msg_data := l_error_status;
2225: l_msg_data := l_error_status;
2226: RAISE FND_API.G_EXC_ERROR;
2227: END IF;
2228:
2229: /*
2230: IF l_error_id IS NULL OR l_error_id = 0 THEN

Line 2250: RAISE FND_API.G_EXC_ERROR;

2246:
2247: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN
2248: x_msg_data := l_error_status;
2249: l_msg_data := l_error_status;
2250: RAISE FND_API.G_EXC_ERROR;
2251: END IF;
2252:
2253:
2254: IF ((p_cln_required = 'TRUE') AND (p_if_collaboration_updated = 'FALSE'))THEN

Line 2271: RAISE FND_API.G_EXC_ERROR;

2267:
2268: IF(x_return_status <> 'S')THEN
2269: p_if_collaboration_updated := 'ERROR';
2270: l_msg_data := 'Error in RAISE_UPDATE_EVENT API';
2271: RAISE FND_API.G_EXC_ERROR;
2272: END IF;
2273: p_if_collaboration_updated := 'TRUE';
2274: END IF;
2275:

Line 2305: RAISE FND_API.G_EXC_ERROR;

2301:
2302: IF(x_return_status <> 'S')THEN
2303: p_if_collaboration_updated := 'ERROR';
2304: l_msg_data := 'Error in RAISE_ADD_MSG_EVENT API';
2305: RAISE FND_API.G_EXC_ERROR;
2306: END IF;
2307:
2308: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_CONSUMED');
2309: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);

Line 2315: x_return_status := FND_API.G_RET_STS_SUCCESS;

2311: END IF;
2312:
2313: --p_msg_dtl_screen := NULL;
2314: p_msg_txt_lines := NULL;
2315: x_return_status := FND_API.G_RET_STS_SUCCESS;
2316:
2317: IF (l_Debug_Level <= 1) THEN
2318: cln_debug_pub.Add(l_msg_data,1);
2319: END IF;

Line 2327: WHEN FND_API.G_EXC_ERROR THEN

2323:
2324: -- Exception Handling
2325: EXCEPTION
2326:
2327: WHEN FND_API.G_EXC_ERROR THEN
2328: x_return_status := FND_API.G_RET_STS_ERROR ;
2329: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_ERROR');
2330: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);
2331: FND_MESSAGE.SET_TOKEN('RELNUM',p_release_number);

Line 2328: x_return_status := FND_API.G_RET_STS_ERROR ;

2324: -- Exception Handling
2325: EXCEPTION
2326:
2327: WHEN FND_API.G_EXC_ERROR THEN
2328: x_return_status := FND_API.G_RET_STS_ERROR ;
2329: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ACKPO_ERROR');
2330: FND_MESSAGE.SET_TOKEN('PONUM',p_po_number);
2331: FND_MESSAGE.SET_TOKEN('RELNUM',p_release_number);
2332: FND_MESSAGE.SET_TOKEN('REVNUM',p_revision_number);

Line 2341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2337: cln_debug_pub.Add('------- ERROR :Exiting PROCESS_HEADER_LINES API --------- ',2);
2338: END IF;
2339:
2340:
2341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2342: l_error_code :=SQLCODE;
2343: l_error_msg :=SQLERRM;
2344: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2345: l_msg_data :=l_error_code||' : '||l_error_msg;

Line 2344: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

2340:
2341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2342: l_error_code :=SQLCODE;
2343: l_error_msg :=SQLERRM;
2344: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2345: l_msg_data :=l_error_code||' : '||l_error_msg;
2346: IF (l_Debug_Level <= 5) THEN
2347: cln_debug_pub.Add(l_msg_data,6);
2348: cln_debug_pub.Add('------- ERROR :Exiting PROCESS_HEADER_LINES API --------- ',2);

Line 2354: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

2350:
2351: WHEN OTHERS THEN
2352: l_error_code :=SQLCODE;
2353: l_error_msg :=SQLERRM;
2354: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2355: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2356: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2357: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2358: x_msg_data :=FND_MESSAGE.GET;

Line 2487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2483:
2484: IF(x_return_status <> 'S')THEN
2485: p_if_collaboration_updated := 'ERROR';
2486: l_msg_data := 'Error in RAISE_UPDATE_EVENT API';
2487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2488: END IF;
2489: p_if_collaboration_updated := 'TRUE';
2490: END IF;
2491:

Line 2492: x_return_status := FND_API.G_RET_STS_SUCCESS;

2488: END IF;
2489: p_if_collaboration_updated := 'TRUE';
2490: END IF;
2491:
2492: x_return_status := FND_API.G_RET_STS_SUCCESS;
2493: IF (l_Debug_Level <= 1) THEN
2494: cln_debug_pub.Add(l_msg_data,1);
2495: END IF;
2496: IF (l_Debug_Level <= 2) THEN

Line 2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2500: -- Exception Handling
2501: EXCEPTION
2502:
2503:
2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2505: l_error_code :=SQLCODE;
2506: l_error_msg :=SQLERRM;
2507: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2508: l_msg_data :=l_error_code||' : '||l_error_msg;

Line 2507: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

2503:
2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2505: l_error_code :=SQLCODE;
2506: l_error_msg :=SQLERRM;
2507: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2508: l_msg_data :=l_error_code||' : '||l_error_msg;
2509: IF (l_Debug_Level <= 5) THEN
2510: cln_debug_pub.Add(l_msg_data,6);
2511: cln_debug_pub.Add('------- ERROR :Exiting UPDATE_COLL_FOR_HDR_ONLY_MSG API --------- ',2);

Line 2517: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

2513:
2514: WHEN OTHERS THEN
2515: l_error_code :=SQLCODE;
2516: l_error_msg :=SQLERRM;
2517: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
2518: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
2519: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
2520: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
2521: x_msg_data :=FND_MESSAGE.GET;