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.OE_SYNC_ORDER_PVT dependencies on FND_API

Line 124: x_return_status := FND_API.G_RET_STS_SUCCESS;

120: l_bill_to_cust_site_id number;
121: l_bill_to_party_site_id number;
122: -- End : Added for Enh. 7244277 (solving bug 7622467)
123: BEGIN
124: x_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( ' ENTERING OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER :'||
128: 'header id :'||P_HEADER_REC.HEADER_ID || ' p_change type :'||P_CHANGE_TYPE);

Line 190: WHEN FND_API.G_EXC_ERROR THEN

186: END IF;
187:
188: EXCEPTION
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: -- Get message count and data
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

187:
188: EXCEPTION
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: -- Get message count and data
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');
195: END IF;

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

195: END IF;
196:
197: WHEN OTHERS THEN
198:
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200: IF l_debug_level > 0 THEN
201: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT - G_RET_STS_UNEXP_ERROR');
202: END IF;
203:

Line 241: x_return_status := FND_API.G_RET_STS_SUCCESS;

237: o_ship_to_prty_cntct_id number;
238: o_bill_to_prty_cntct_id number;
239: BEGIN
240:
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242:
243: IF l_debug_level > 0 THEN
244: oe_debug_pub.add( ' ENTERING OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE :'||
245: 'line id :'||P_LINE_REC.LINE_ID || ' p_change type :'||P_CHANGE_TYPE||

Line 410: WHEN FND_API.G_EXC_ERROR THEN

406: END IF;
407:
408: EXCEPTION
409:
410: WHEN FND_API.G_EXC_ERROR THEN
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: -- Get message count and data
413:
414: IF l_debug_level > 0 THEN

Line 411: x_return_status := FND_API.G_RET_STS_ERROR;

407:
408: EXCEPTION
409:
410: WHEN FND_API.G_EXC_ERROR THEN
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: -- Get message count and data
413:
414: IF l_debug_level > 0 THEN
415: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');

Line 419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

415: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');
416: END IF;
417: WHEN OTHERS THEN
418:
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
420:
421: IF l_debug_level > 0 THEN
422: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT - G_RET_STS_UNEXP_ERROR');
423: END IF;

Line 540: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

536: IF l_debug_level > 0 THEN
537: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event1');
538: END IF;
539:
540: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
541: raise_bpel_out_event(p_header_id => p_header_rec.header_id
542: ,p_line_id => p_line_rec.line_id
543: ,p_hdr_req_id => l_itemkey --XXXX
544: ,p_lin_req_id => l_itemkey --XXXX

Line 573: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event2');
571: END IF;
572:
573: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
574: raise_bpel_out_event(p_header_id => p_header_rec.header_id
575: ,p_line_id => p_line_rec.line_id
576: ,p_hdr_req_id => l_itemkey --XXXX
577: ,p_lin_req_id => l_itemkey --XXXX

Line 596: l_return_status := FND_API.G_RET_STS_SUCCESS;

592: FOR hdr_rec IN get_hdr_for_hldsrc_cur
593: LOOP
594:
595: BEGIN
596: l_return_status := FND_API.G_RET_STS_SUCCESS;
597:
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add('sync_header_line- in loop -released flag'||hdr_rec.released_flag);
600: END IF;

Line 704: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

700: INSERT_SYNC_lINE(P_LINE_REC => L_LINE_REC,
701: p_change_type => p_change_type,
702: p_req_id => l_itemkey, --XXXX
703: X_RETURN_STATUS => L_RETURN_STATUS);
704: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
705: IF l_debug_level > 0 THEN
706: oe_debug_pub.add('sync_header_line - Line inserted');
707: END IF;
708: END IF;

Line 726: WHEN FND_API.G_EXC_ERROR THEN

722: ,p_hold_source_id => p_hold_source_id
723: ,p_order_hold_id => p_order_hold_id);
724:
725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR THEN
727: IF l_debug_level > 0 THEN
728: oe_debug_pub.add('sync_header_line - G_EXC_ERROR Inside Main LOOP for Header/LineID: '
729: || hdr_rec.header_id || '/' || hdr_rec.line_id);
730: END IF;

Line 731: l_return_status := FND_API.G_RET_STS_ERROR;

727: IF l_debug_level > 0 THEN
728: oe_debug_pub.add('sync_header_line - G_EXC_ERROR Inside Main LOOP for Header/LineID: '
729: || hdr_rec.header_id || '/' || hdr_rec.line_id);
730: END IF;
731: l_return_status := FND_API.G_RET_STS_ERROR;
732:
733: WHEN OTHERS THEN
734: IF l_debug_level > 0 THEN
735: oe_debug_pub.add('sync_header_line - OTHERS Inside Main LOOP for Header/LineID: '

Line 738: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

734: IF l_debug_level > 0 THEN
735: oe_debug_pub.add('sync_header_line - OTHERS Inside Main LOOP for Header/LineID: '
736: || hdr_rec.header_id || '/' || hdr_rec.line_id);
737: END IF;
738: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
740: THEN
741: OE_MSG_PUB.Add_Exc_Msg
742: ( G_PKG_NAME

Line 804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event5');
802: END IF;
803:
804: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
805: raise_bpel_out_event(
806: p_header_id => ord_rec.header_id
807: ,p_line_id => ord_rec.line_id
808: ,p_hdr_req_id => l_itemkey

Line 829: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

825: IF l_debug_level > 0 THEN
826: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event6');
827: END IF;
828:
829: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
830: raise_bpel_out_event(p_header_id => ord_rec.header_id
831: ,p_line_id => ord_rec.line_id
832: ,p_hdr_req_id => l_itemkey --XXXX
833: ,p_lin_req_id => l_itemkey --XXXX