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

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

203: -- Standard Start of API savepoint
204: SAVEPOINT CHECK_COLLABORATION_PUB;
205:
206: -- Initialize API return status to success
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208: l_msg_data := 'XML Gateway successfully consumes SYNC ITEM inbound document';
209:
210: FND_MESSAGE.SET_NAME('CLN','CLN_CH_SYNC_ITEMS_CONSUMED');
211: x_msg_data := FND_MESSAGE.GET;

Line 295: RAISE FND_API.G_EXC_ERROR;

291: WHEN NO_DATA_FOUND THEN
292: l_msg_data :='ERROR : Incorrect Trading Partner Details';
293: FND_MESSAGE.SET_NAME('CLN','CLN_CH_INCORRECT_TP_DETAILS');
294: x_msg_data := FND_MESSAGE.GET;
295: RAISE FND_API.G_EXC_ERROR;
296: END;
297:
298: -- get a unique key for raising update collaboration event.
299: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: cln_debug_pub.Add('----------- EXITING RAISE_UPDATE_EVENT ------------', 2);
340: END IF;
341:
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345:
346: IF (l_Debug_Level <= 4) THEN
347: cln_debug_pub.Add(l_msg_data,4);

Line 344: x_return_status := FND_API.G_RET_STS_ERROR ;

340: END IF;
341:
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345:
346: IF (l_Debug_Level <= 4) THEN
347: cln_debug_pub.Add(l_msg_data,4);
348: END IF;

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

353:
354: WHEN OTHERS THEN
355: l_error_code := SQLCODE;
356: l_error_msg := SQLERRM;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: l_msg_data := l_error_code||' : '||l_error_msg;
359: x_msg_data := l_msg_data;
360: IF (l_Debug_Level <= 6) THEN
361: cln_debug_pub.Add(l_msg_data,6);

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415: cln_debug_pub.Add('-------- ENTERING RAISE_ADD_MSG_EVENT ------------', 2);
416: END IF;
417:
418: -- Initialize API return status to success
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420: l_msg_data := 'Item Details recorded in the collaboration history';
421:
422: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS');
423: x_msg_data := FND_MESSAGE.GET;

Line 504: RAISE FND_API.G_EXC_ERROR;

500: END IF;
501:
502: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',l_event_key, NULL, l_cln_ch_parameters, NULL);
503:
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507:
508: IF (p_sync_indicator <> 'Delete') THEN

Line 638: WHEN FND_API.G_EXC_ERROR THEN

634: cln_debug_pub.Add('--------- EXITING RAISE_ADD_MSG_EVENT -------------', 2);
635: END IF;
636:
637: EXCEPTION
638: WHEN FND_API.G_EXC_ERROR THEN
639: x_return_status := FND_API.G_RET_STS_ERROR;
640:
641: IF (l_Debug_Level <= 4) THEN
642: cln_debug_pub.Add(l_msg_data,4);

Line 639: x_return_status := FND_API.G_RET_STS_ERROR;

635: END IF;
636:
637: EXCEPTION
638: WHEN FND_API.G_EXC_ERROR THEN
639: x_return_status := FND_API.G_RET_STS_ERROR;
640:
641: IF (l_Debug_Level <= 4) THEN
642: cln_debug_pub.Add(l_msg_data,4);
643: END IF;

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

650:
651: WHEN OTHERS THEN
652: l_error_code := SQLCODE;
653: l_error_msg := SQLERRM;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: l_msg_data := l_error_code||' : '||l_error_msg;
656: x_msg_data := l_msg_data;
657: IF (l_Debug_Level <= 6) THEN
658: cln_debug_pub.Add(l_msg_data,6);

Line 816: x_return_status := FND_API.G_RET_STS_ERROR;

812: cln_debug_pub.Add(l_msg_data,1);
813: END IF;
814:
815: -- this is required for the proper processing in workflow.
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: IF (l_Debug_Level <= 1) THEN
818: cln_debug_pub.Add('the return status is :'||x_return_status,1);
819: END IF;
820:

Line 830: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;

826: EXCEPTION
827: WHEN OTHERS THEN
828: l_error_code :=SQLCODE;
829: l_error_msg :=SQLERRM;
830: x_return_status :=FND_API.G_RET_STS_UNEXP_ERROR ;
831: FND_MESSAGE.SET_NAME('CLN','CLN_CH_UNEXPECTED_ERROR');
832: FND_MESSAGE.SET_TOKEN('ERRORCODE',l_error_code);
833: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
834: x_msg_data :=FND_MESSAGE.GET;

Line 1003: RAISE FND_API.G_EXC_ERROR;

999: IF (l_Debug_Level <= 1) THEN
1000: cln_debug_pub.Add(l_msg_data,1);
1001: END IF;
1002:
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005: END IF;
1006: ----------------
1007:

Line 1760: RAISE FND_API.G_EXC_ERROR;

1756:
1757: EXCEPTION
1758: WHEN NO_DATA_FOUND THEN
1759: cln_debug_pub.Add('ERROR : Could not find the record in the mtl_system_items_b table for the item number -'||l_item_number, 1);
1760: RAISE FND_API.G_EXC_ERROR;
1761: END;
1762:
1763: UPDATE CLN_CST_DTLS_TEMP
1764: SET inventory_item_id = l_inventory_item_id,

Line 2042: RAISE FND_API.G_EXC_ERROR;

2038: IF (l_Debug_Level <= 1) THEN
2039: cln_debug_pub.Add(l_msg_data,1);
2040: END IF;
2041:
2042: RAISE FND_API.G_EXC_ERROR;
2043: END IF;
2044:
2045: RETURN;
2046: END IF;

Line 2185: RAISE FND_API.G_EXC_ERROR;

2181: IF (l_Debug_Level <= 1) THEN
2182: cln_debug_pub.Add(l_msg_data,1);
2183: END IF;
2184:
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2188:
2189: RETURN;

Line 2333: RAISE FND_API.G_EXC_ERROR;

2329: IF (l_Debug_Level <= 1) THEN
2330: cln_debug_pub.Add(l_msg_data,1);
2331: END IF;
2332:
2333: RAISE FND_API.G_EXC_ERROR;
2334: END IF;
2335:
2336: RETURN;
2337: END IF;

Line 2361: RAISE FND_API.G_EXC_ERROR;

2357: IF (l_Debug_Level <= 1) THEN
2358: cln_debug_pub.Add(l_msg_data,1);
2359: END IF;
2360:
2361: RAISE FND_API.G_EXC_ERROR;
2362: END IF;
2363:
2364: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_STATUS_TP', l_return_status_tp);
2365: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'RETURN_MSG_TP', 'SUCCESS');

Line 2608: RAISE FND_API.G_EXC_ERROR;

2604: IF (l_Debug_Level <= 1) THEN
2605: cln_debug_pub.Add(l_msg_data,1);
2606: END IF;
2607:
2608: RAISE FND_API.G_EXC_ERROR;
2609: END IF;
2610: ELSE
2611:
2612: IF (l_Debug_Level <= 1) THEN

Line 2836: x_return_status := FND_API.G_RET_STS_SUCCESS;

2832: cln_debug_pub.Add('-------- ENTERING ROLLBACK_CHANGES_RN ------------', 2);
2833: END IF;
2834:
2835: -- Initialize API return status to success
2836: x_return_status := FND_API.G_RET_STS_SUCCESS;
2837: l_msg_data := 'Item Details rolled back and recorded in the collaboration history';
2838:
2839: FND_MESSAGE.SET_NAME('CLN','CLN_CH_ITEM_DETAILS_ROLLED');
2840: x_msg_data := FND_MESSAGE.GET;

Line 2925: WHEN FND_API.G_EXC_ERROR THEN

2921: cln_debug_pub.Add('--------- EXITING ROLLBACK_CHANGES_RN -------------', 2);
2922: END IF;
2923:
2924: EXCEPTION
2925: WHEN FND_API.G_EXC_ERROR THEN
2926: x_return_status := FND_API.G_RET_STS_ERROR;
2927:
2928: IF (l_Debug_Level <= 4) THEN
2929: cln_debug_pub.Add(l_msg_data,4);

Line 2926: x_return_status := FND_API.G_RET_STS_ERROR;

2922: END IF;
2923:
2924: EXCEPTION
2925: WHEN FND_API.G_EXC_ERROR THEN
2926: x_return_status := FND_API.G_RET_STS_ERROR;
2927:
2928: IF (l_Debug_Level <= 4) THEN
2929: cln_debug_pub.Add(l_msg_data,4);
2930: END IF;

Line 2941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2937:
2938: WHEN OTHERS THEN
2939: l_error_code := SQLCODE;
2940: l_error_msg := SQLERRM;
2941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2942: l_msg_data := l_error_code||' : '||l_error_msg;
2943: x_msg_data := l_msg_data;
2944: IF (l_Debug_Level <= 6) THEN
2945: cln_debug_pub.Add(l_msg_data,6);