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_PO_CHG_ORDER_STATUS dependencies on FND_API

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: -- Sets the debug mode to be FILE
85: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
86: SAVEPOINT SO_PROCESSING_TXN;
87: -- Initialize API return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
90: x_msg_data := FND_MESSAGE.GET;
91: G_PO_LINE_NUMBER := -1;
92: IF (l_Debug_Level <= 2) THEN

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: p_msg_text => x_msg_data,
124: p_status_code => 1,
125: p_int_ctl_num => p_int_ctl_num);
126: IF l_return_status <> 'S' THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: IF (l_Debug_Level <= 1) THEN
131: cln_debug_pub.Add(x_msg_data, 1);

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: p_int_ctl_num => p_int_ctl_num);
126: IF l_return_status <> 'S' THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: IF (l_Debug_Level <= 1) THEN
131: cln_debug_pub.Add(x_msg_data, 1);
132: END IF;
133: IF (l_Debug_Level <= 2) THEN

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: p_msg_text => l_msg_text,
147: p_status_code => 0,
148: p_int_ctl_num => p_int_ctl_num);
149: IF l_return_status <> 'S' THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152: -- New PO API for Change Management
153: GET_TRADING_PARTNER_DETAILS(l_tp_id, l_tp_site_id, p_tp_id);
154: PO_CHG_REQUEST_GRP.initialize_chn_ack_inbound (

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: IF l_return_status <> 'S' THEN
218: IF (l_Debug_Level <= 1) THEN
219: cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);
220: END IF;
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223: RAISE_ADD_MESSAGE(
224: x_return_status => l_return_status,
225: x_msg_data => l_return_msg,

Line 237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

233: IF l_return_status <> 'S' THEN
234: IF (l_Debug_Level <= 1) THEN
235: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
236: END IF;
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: IF (l_Debug_Level <= 1) THEN
241: cln_debug_pub.Add(x_msg_data, 1);

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
236: END IF;
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
238: END IF;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: IF (l_Debug_Level <= 1) THEN
241: cln_debug_pub.Add(x_msg_data, 1);
242: END IF;
243: IF (l_Debug_Level <= 2) THEN

Line 252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

248: IF (l_Debug_Level <= 2) THEN
249: cln_debug_pub.Add('EXITING PROCESS_ORDER_HEADER', 2);
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: ROLLBACK TO SO_PROCESSING_TXN;
254: IF (l_Debug_Level <= 5) THEN
255: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
256: END IF;

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: ROLLBACK TO SO_PROCESSING_TXN;
254: IF (l_Debug_Level <= 5) THEN
255: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
256: END IF;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: x_msg_data := l_return_msg;
259: IF (l_Debug_Level <= 5) THEN
260: cln_debug_pub.Add(x_msg_data, 5);
261: END IF;

Line 283: x_return_status := FND_API.G_RET_STS_ERROR ;

279: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
280: END IF;
281: l_error_code := SQLCODE;
282: l_error_msg := SQLERRM;
283: x_return_status := FND_API.G_RET_STS_ERROR ;
284: x_msg_data := l_error_code||' : '||l_error_msg;
285: IF (l_Debug_Level <= 5) THEN
286: cln_debug_pub.Add(x_msg_data, 5);
287: END IF;

Line 357: x_return_status := FND_API.G_RET_STS_SUCCESS;

353: BEGIN
354: -- Sets the debug mode to be FILE
355: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
356: -- Initialize API return status to success
357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
359: x_msg_data := FND_MESSAGE.GET;
360:
361:

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: IF l_return_status <> 'S' THEN
480: IF (l_Debug_Level <= 1) THEN
481: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
482: END IF;
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485: END IF;
486: -- PO_CHG_REQUEST_GRP.store_supplier_request call failed
487: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506: IF l_return_status <> 'S' THEN
507: IF (l_Debug_Level <= 1) THEN
508: cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);
509: END IF;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512: RAISE_ADD_MESSAGE(
513: x_return_status => l_return_status,
514: x_msg_data => l_return_msg,

Line 526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

522: IF l_return_status <> 'S' THEN
523: IF (l_Debug_Level <= 1) THEN
524: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
525: END IF;
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: IF (l_Debug_Level <= 2) THEN
530: cln_debug_pub.Add('EXITING PROCESS_ORDER_LINE', 2);

Line 528: x_return_status := FND_API.G_RET_STS_ERROR;

524: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
525: END IF;
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: IF (l_Debug_Level <= 2) THEN
530: cln_debug_pub.Add('EXITING PROCESS_ORDER_LINE', 2);
531: END IF;
532: RETURN;

Line 548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

544: IF (l_Debug_Level <= 2) THEN
545: cln_debug_pub.Add('EXITING PROCESS_ORDER_LINE', 2);
546: END IF;
547: EXCEPTION
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO SO_PROCESSING_TXN;
550: IF (l_Debug_Level <= 5) THEN
551: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
552: END IF;

Line 553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

549: ROLLBACK TO SO_PROCESSING_TXN;
550: IF (l_Debug_Level <= 5) THEN
551: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
552: END IF;
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
554: x_msg_data := l_return_msg;
555: IF (l_Debug_Level <= 5) THEN
556: cln_debug_pub.Add(x_msg_data, 5);
557: END IF;

Line 581: x_return_status := FND_API.G_RET_STS_ERROR ;

577: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
578: END IF;
579: l_error_code := SQLCODE;
580: l_error_msg := SQLERRM;
581: x_return_status := FND_API.G_RET_STS_ERROR ;
582: x_msg_data := l_error_code||' : '||l_error_msg;
583: IF (l_Debug_Level <= 5) THEN
584: cln_debug_pub.Add(x_msg_data, 5);
585: END IF;

Line 662: x_return_status := FND_API.G_RET_STS_SUCCESS;

658: BEGIN
659: -- Sets the debug mode to be FILE
660: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
661: -- Initialize API return status to success
662: x_return_status := FND_API.G_RET_STS_SUCCESS;
663: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
664: x_msg_data := FND_MESSAGE.GET;
665:
666: IF (l_Debug_Level <= 2) THEN

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: IF l_return_status <> 'S' THEN
853: IF (l_Debug_Level <= 1) THEN
854: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
855: END IF;
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858: END IF;
859: -- PO_CHG_REQUEST_GRP.store_supplier_request call failed
860: IF l_error_id IS NOT NULL AND l_error_id <> 0 THEN

Line 881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

877: IF l_return_status <> 'S' THEN
878: IF (l_Debug_Level <= 1) THEN
879: cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);
880: END IF;
881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: END IF;
883: RAISE_ADD_MESSAGE(
884: x_return_status => l_return_status,
885: x_msg_data => l_return_msg,

Line 897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

893: IF l_return_status <> 'S' THEN
894: IF (l_Debug_Level <= 1) THEN
895: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
896: END IF;
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: IF (l_Debug_Level <= 2) THEN
901: cln_debug_pub.Add('EXITING PROCESS_ORDER_LINE_SHIPMENT', 2);

Line 899: x_return_status := FND_API.G_RET_STS_ERROR;

895: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
896: END IF;
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: IF (l_Debug_Level <= 2) THEN
901: cln_debug_pub.Add('EXITING PROCESS_ORDER_LINE_SHIPMENT', 2);
902: END IF;
903: -- Is Order Line Closed ?

Line 921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

917: IF (l_Debug_Level <= 2) THEN
918: cln_debug_pub.Add('EXITING PROCESS_ORDER_LINE_SHIPMENT', 2);
919: END IF;
920: EXCEPTION
921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
922: ROLLBACK TO SO_PROCESSING_TXN;
923: IF (l_Debug_Level <= 5) THEN
924: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
925: END IF;

Line 926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

922: ROLLBACK TO SO_PROCESSING_TXN;
923: IF (l_Debug_Level <= 5) THEN
924: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
925: END IF;
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927: x_msg_data := l_return_msg;
928: IF (l_Debug_Level <= 5) THEN
929: cln_debug_pub.Add(x_msg_data, 5);
930: END IF;

Line 956: x_return_status := FND_API.G_RET_STS_ERROR ;

952: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
953: END IF;
954: l_error_code := SQLCODE;
955: l_error_msg := SQLERRM;
956: x_return_status := FND_API.G_RET_STS_ERROR ;
957: x_msg_data := l_error_code||' : '||l_error_msg;
958: IF (l_Debug_Level <= 5) THEN
959: cln_debug_pub.Add(x_msg_data, 5);
960: END IF;

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: BEGIN
1006: -- Sets the debug mode to be FILE
1007: --l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
1008: -- Initialize API return status to success
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010: FND_MESSAGE.SET_NAME('CLN','CLN_G_RET_MSG_SUCCESS');
1011: x_msg_data := FND_MESSAGE.GET;
1012: IF (l_Debug_Level <= 2) THEN
1013: cln_debug_pub.Add('ENTERING LOAD_CHANGES', 2);

Line 1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1053: IF l_return_status <> 'S' THEN
1054: IF (l_Debug_Level <= 1) THEN
1055: cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);
1056: END IF;
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: IF (l_Debug_Level <= 2) THEN
1061: cln_debug_pub.Add('EXITING LOAD_CHANGES', 2);

Line 1059: x_return_status := FND_API.G_RET_STS_ERROR;

1055: cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);
1056: END IF;
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: IF (l_Debug_Level <= 2) THEN
1061: cln_debug_pub.Add('EXITING LOAD_CHANGES', 2);
1062: END IF;
1063: RETURN;

Line 1069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1065: IF (l_Debug_Level <= 2) THEN
1066: cln_debug_pub.Add('EXITING LOAD_CHANGES', 2);
1067: END IF;
1068: EXCEPTION
1069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1070: ROLLBACK TO SO_PROCESSING_TXN;
1071: IF (l_Debug_Level <= 5) THEN
1072: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
1073: END IF;

Line 1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1070: ROLLBACK TO SO_PROCESSING_TXN;
1071: IF (l_Debug_Level <= 5) THEN
1072: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
1073: END IF;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1075: x_msg_data := l_return_msg;
1076: IF (l_Debug_Level <= 5) THEN
1077: cln_debug_pub.Add(x_msg_data, 5);
1078: END IF;

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR ;

1092: cln_debug_pub.Add('Rolledback SO_PROCESSING_TXN transaction',5);
1093: END IF;
1094: l_error_code := SQLCODE;
1095: l_error_msg := SQLERRM;
1096: x_return_status := FND_API.G_RET_STS_ERROR ;
1097: x_msg_data := l_error_code||' : '||l_error_msg;
1098: IF (l_Debug_Level <= 5) THEN
1099: cln_debug_pub.Add(x_msg_data, 5);
1100: END IF;

Line 1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1241: IF l_return_status <> 'S' THEN
1242: IF (l_Debug_Level <= 1) THEN
1243: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 1);
1244: END IF;
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: END IF;
1247: RETURN;
1248: END IF;
1249: -- Error

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260: IF l_return_status <> 'S' THEN
1261: IF (l_Debug_Level <= 1) THEN
1262: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 1);
1263: END IF;
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266: RETURN;
1267: END IF;
1268: -- Order Line Closed

Line 1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1282: IF l_return_status <> 'S' THEN
1283: IF (l_Debug_Level <= 1) THEN
1284: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 1);
1285: END IF;
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288: RETURN;
1289: END IF;
1290: -- Success

Line 1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1303: IF l_return_status <> 'S' THEN
1304: IF (l_Debug_Level <= 1) THEN
1305: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 1);
1306: END IF;
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1308: END IF;
1309: IF (l_Debug_Level <= 2) THEN
1310: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);
1311: END IF;

Line 1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1309: IF (l_Debug_Level <= 2) THEN
1310: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);
1311: END IF;
1312: EXCEPTION
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: IF (l_Debug_Level <= 5) THEN
1315: cln_debug_pub.Add(l_return_msg, 6);
1316: END IF;
1317: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_not_msg);

Line 1365: x_return_status := FND_API.G_RET_STS_SUCCESS;

1361: IF (l_Debug_Level <= 2) THEN
1362: cln_debug_pub.Add('ENTERING RAISE_UPDATE_COLLABORATION', 2);
1363: END IF;
1364: -- Initialize API return status to success
1365: x_return_status := FND_API.G_RET_STS_SUCCESS;
1366: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
1367: FND_MESSAGE.SET_TOKEN('EVENT','Update');
1368: x_msg_data := FND_MESSAGE.GET;
1369: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line 1411: x_return_status := FND_API.G_RET_STS_ERROR;

1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: l_error_code := SQLCODE;
1410: l_error_msg := SQLERRM;
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: x_msg_data := l_error_code || ':' || l_error_msg;
1413: IF (l_Debug_Level <= 5) THEN
1414: cln_debug_pub.Add(x_msg_data, 4);
1415: END IF;

Line 1465: x_return_status := FND_API.G_RET_STS_SUCCESS;

1461: cln_debug_pub.Add('p_ref5 - ' || p_ref5,1);
1462: cln_debug_pub.Add('p_dtl_msg - ' || p_dtl_msg,1);
1463: END IF;
1464: -- Initialize API return status to success
1465: x_return_status := FND_API.G_RET_STS_SUCCESS;
1466: FND_MESSAGE.SET_NAME('CLN', 'CLN_G_RET_MSG_SUCCESS');
1467: x_msg_data := FND_MESSAGE.GET;
1468: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
1469: l_cln_ch_parameters := wf_parameter_list_t();

Line 1494: x_return_status := FND_API.G_RET_STS_ERROR;

1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: l_error_code := SQLCODE;
1493: l_error_msg := SQLERRM;
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: x_msg_data := l_error_code || ':' || l_error_msg;
1496: IF (l_Debug_Level <= 5) THEN
1497: cln_debug_pub.Add(x_msg_data, 4);
1498: cln_debug_pub.Add('EXITING RAISE_ADD_MESSAGE', 2);