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

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

116: p_msg_text => x_msg_data,
117: p_status_code => 1,
118: p_int_ctl_num => p_int_cont_num);
119: IF l_return_status <> 'S' THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: IF (l_Debug_Level <= 1) THEN
124: cln_debug_pub.Add(x_msg_data, 1);

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: p_int_ctl_num => p_int_cont_num);
119: IF l_return_status <> 'S' THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: IF (l_Debug_Level <= 1) THEN
124: cln_debug_pub.Add(x_msg_data, 1);
125: END IF;
126:

Line 152: x_return_status := FND_API.G_RET_STS_ERROR;

148: WHEN OTHERS THEN
149: IF (l_Debug_Level <= 5) THEN
150: cln_debug_pub.Add('Exception while trying to obtain the BPO number',5);
151: END IF;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: l_error_code := SQLCODE;
154: l_error_msg := SQLERRM;
155: x_msg_data := l_error_code||' : '||l_error_msg;
156: IF (l_Debug_Level <= 5) THEN

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: IF (l_Debug_Level <= 1) THEN
192: cln_debug_pub.Add('RAISE_UPDATE_COLLABORATION CALL FAILED',1);
193: END IF;
194:
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197:
198: SELECT org_id
199: INTO l_org_id

Line 278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

274: cln_debug_pub.Add('EXITING PROCESS_HEADER', 2);
275: END IF;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: ROLLBACK TO PO_UPDATE_TXN;
280: IF (l_Debug_Level <= 5) THEN
281: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
282: END IF;

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
282: END IF;
283:
284: -- Assaign global error info and set return values
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: x_msg_data := l_return_msg;
287: IF (l_Debug_Level <= 5) THEN
288: cln_debug_pub.Add(x_msg_data, 5);
289: END IF;

Line 307: x_return_status := FND_API.G_RET_STS_ERROR;

303: IF (l_Debug_Level <= 5) THEN
304: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
305: END IF;
306:
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: l_error_code := SQLCODE;
309: l_error_msg := SQLERRM;
310: x_msg_data := l_error_code||' : '||l_error_msg;
311: IF (l_Debug_Level <= 5) THEN

Line 482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

478: p_msg_text => x_msg_data,
479: p_status_code => 1,
480: p_int_ctl_num => p_int_cont_num);
481: IF l_return_status <> 'S' THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484: x_return_status := 'DIE';
485: IF (l_Debug_Level <= 1) THEN
486: cln_debug_pub.Add(x_msg_data, 1);

Line 685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

681: IF (l_Debug_Level <= 1) THEN
682: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
683: END IF;
684:
685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
686: END IF;
687:
688: IF (l_Debug_Level <= 2) THEN
689: cln_debug_pub.Add('EXITING PROCESS_LINE', 2);

Line 693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

689: cln_debug_pub.Add('EXITING PROCESS_LINE', 2);
690: END IF;
691:
692: EXCEPTION
693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
694: ROLLBACK TO PO_UPDATE_TXN;
695: IF (l_Debug_Level <= 5) THEN
696: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
697: END IF;

Line 699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

695: IF (l_Debug_Level <= 5) THEN
696: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
697: END IF;
698:
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
700: x_msg_data := l_return_msg;
701: IF (l_Debug_Level <= 5) THEN
702: cln_debug_pub.Add(x_msg_data, 5);
703: END IF;

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718: IF (l_Debug_Level <= 5) THEN
719: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
720: END IF;
721:
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: l_error_code := SQLCODE;
724: l_error_msg := SQLERRM;
725: x_msg_data := l_error_code||' : '||l_error_msg;
726: IF (l_Debug_Level <= 5) THEN

Line 922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

918: IF (l_Debug_Level <= 1) THEN
919: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
920: END IF;
921:
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: END IF;
924:
925:
926: IF (l_Debug_Level <= 2) THEN

Line 931: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

927: cln_debug_pub.Add('EXITING PROCESS_PRICE_BREAKS', 2);
928: END IF;
929:
930: EXCEPTION
931: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
932: ROLLBACK TO PO_UPDATE_TXN;
933: IF (l_Debug_Level <= 5) THEN
934: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
935: END IF;

Line 937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

933: IF (l_Debug_Level <= 5) THEN
934: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
935: END IF;
936:
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: x_msg_data := l_return_msg;
939: IF (l_Debug_Level <= 5) THEN
940: cln_debug_pub.Add(x_msg_data, 5);
941: END IF;

Line 960: x_return_status := FND_API.G_RET_STS_ERROR;

956: IF (l_Debug_Level <= 5) THEN
957: cln_debug_pub.Add('Rolledback PO_UPDATE_TXN transaction',5);
958: END IF;
959:
960: x_return_status := FND_API.G_RET_STS_ERROR;
961: l_error_code := SQLCODE;
962: l_error_msg := SQLERRM;
963: x_msg_data := l_error_code||' : '||l_error_msg;
964: IF (l_Debug_Level <= 5) THEN

Line 1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1119: IF (l_Debug_Level <= 1) THEN
1120: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 1);
1121: END IF;
1122:
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;
1125: RETURN;
1126: END IF;
1127:

Line 1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1148: IF (l_Debug_Level <= 1) THEN
1149: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 1);
1150: END IF;
1151:
1152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1153: END IF;
1154: RETURN;
1155: END IF;
1156:

Line 1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1174: IF (l_Debug_Level <= 1) THEN
1175: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 1);
1176: END IF;
1177:
1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: END IF;
1180: RETURN;
1181: END IF;
1182:

Line 1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1197: IF (l_Debug_Level <= 1) THEN
1198: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 1);
1199: END IF;
1200:
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: END IF;
1203:
1204: IF (l_Debug_Level <= 2) THEN
1205: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);

Line 1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1828: p_msg_text => l_msg_data,
1829: p_status_code => 0,
1830: p_int_ctl_num => l_int_ctl_num);
1831: IF l_return_status <> 'S' THEN
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833: END IF;
1834: ELSE
1835: FND_MESSAGE.SET_NAME('CLN','CLN_OPEN_IF_ERROR');
1836: l_msg_data := FND_MESSAGE.GET;

Line 1837: l_error_status := FND_API.G_RET_STS_ERROR;

1833: END IF;
1834: ELSE
1835: FND_MESSAGE.SET_NAME('CLN','CLN_OPEN_IF_ERROR');
1836: l_msg_data := FND_MESSAGE.GET;
1837: l_error_status := FND_API.G_RET_STS_ERROR;
1838: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', l_error_status);
1839: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', l_msg_data);
1840: RAISE_UPDATE_COLLABORATION(
1841: x_return_status => l_return_status,

Line 1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1846: p_msg_text => l_msg_data,
1847: p_status_code => 1,
1848: p_int_ctl_num => l_int_ctl_num);
1849: IF l_return_status <> 'S' THEN
1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1851: END IF;
1852: FOR ERRORS IN PO_OPI_ERRORS(l_int_hdr_id) LOOP
1853: IF (l_Debug_Level <= 1) THEN
1854: cln_debug_pub.Add('Obtained cursor row for each error', 1);

Line 1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1868: IF (l_Debug_Level <= 1) THEN
1869: cln_debug_pub.Add('RAISE_ADD_MESSAGE CALL FAILED', 1);
1870: END IF;
1871:
1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: END IF;
1874: END LOOP;
1875: END IF;
1876:

Line 1987: x_return_status := FND_API.G_RET_STS_SUCCESS;

1983: END IF;
1984:
1985:
1986: -- Initialize API return status to success
1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988:
1989: FND_MESSAGE.SET_NAME('CLN','CLN_CH_EVENT_RAISED');
1990: FND_MESSAGE.SET_TOKEN('EVENT','Update');
1991: x_msg_data := FND_MESSAGE.GET;

Line 2045: x_return_status := FND_API.G_RET_STS_ERROR;

2041: EXCEPTION
2042: WHEN OTHERS THEN
2043: l_error_code := SQLCODE;
2044: l_error_msg := SQLERRM;
2045: x_return_status := FND_API.G_RET_STS_ERROR;
2046: x_msg_data := l_error_code || ':' || l_error_msg;
2047: IF (l_Debug_Level <= 5) THEN
2048: cln_debug_pub.Add(x_msg_data, 4);
2049: cln_debug_pub.Add('EXITING RAISE_UPDATE_COLLABORATION', 2);

Line 2104: x_return_status := FND_API.G_RET_STS_SUCCESS;

2100: END IF;
2101:
2102:
2103: -- Initialize API return status to success
2104: x_return_status := FND_API.G_RET_STS_SUCCESS;
2105: FND_MESSAGE.SET_NAME('CLN', 'CLN_G_RET_MSG_SUCCESS');
2106: x_msg_data := FND_MESSAGE.GET;
2107:
2108:

Line 2140: x_return_status := FND_API.G_RET_STS_ERROR;

2136: EXCEPTION
2137: WHEN OTHERS THEN
2138: l_error_code := SQLCODE;
2139: l_error_msg := SQLERRM;
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: x_msg_data := l_error_code || ':' || l_error_msg;
2142: IF (l_Debug_Level <= 5) THEN
2143: cln_debug_pub.Add(x_msg_data, 4);
2144: cln_debug_pub.Add('EXITING RAISE_ADD_MESSAGE', 2);