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 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: l_bill_to_cust_site_id number;
140: l_bill_to_party_site_id number;
141: -- End : Added for Enh. 7244277 (solving bug 7622467)
142: BEGIN
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: IF l_debug_level > 0 THEN
146: oe_debug_pub.add( ' ENTERING OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER :'||
147: 'header id :'||P_HEADER_REC.HEADER_ID || ' p_change type :'||P_CHANGE_TYPE);

Line 217: WHEN FND_API.G_EXC_ERROR THEN

213: END IF;
214:
215: EXCEPTION
216:
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: -- Get message count and data
220: IF l_debug_level > 0 THEN
221: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

214:
215: EXCEPTION
216:
217: WHEN FND_API.G_EXC_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: -- Get message count and data
220: IF l_debug_level > 0 THEN
221: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');
222: END IF;

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

222: END IF;
223:
224: WHEN OTHERS THEN
225:
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: IF l_debug_level > 0 THEN
228: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT - G_RET_STS_UNEXP_ERROR');
229: END IF;
230:

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264: o_ship_to_prty_cntct_id number;
265: o_bill_to_prty_cntct_id number;
266: BEGIN
267:
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: IF l_debug_level > 0 THEN
271: oe_debug_pub.add( ' ENTERING OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE :'||
272: 'line id :'||P_LINE_REC.LINE_ID || ' p_change type :'||P_CHANGE_TYPE||

Line 469: WHEN FND_API.G_EXC_ERROR THEN

465: END IF;
466:
467: EXCEPTION
468:
469: WHEN FND_API.G_EXC_ERROR THEN
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: -- Get message count and data
472:
473: IF l_debug_level > 0 THEN

Line 470: x_return_status := FND_API.G_RET_STS_ERROR;

466:
467: EXCEPTION
468:
469: WHEN FND_API.G_EXC_ERROR THEN
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: -- Get message count and data
472:
473: IF l_debug_level > 0 THEN
474: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

474: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');
475: END IF;
476: WHEN OTHERS THEN
477:
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
479:
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT - G_RET_STS_UNEXP_ERROR');
482: END IF;

Line 646: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

642: IF l_debug_level > 0 THEN
643: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event1');
644: END IF;
645:
646: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
647: raise_bpel_out_event(p_header_id => p_header_rec.header_id
648: ,p_line_id => p_line_rec.line_id
649: ,p_hdr_req_id => l_itemkey --XXXX
650: ,p_lin_req_id => l_itemkey --XXXX

Line 680: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

676: IF l_debug_level > 0 THEN
677: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event2');
678: END IF;
679:
680: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
681: raise_bpel_out_event(p_header_id => p_header_rec.header_id
682: ,p_line_id => p_line_rec.line_id
683: ,p_hdr_req_id => l_itemkey --XXXX
684: ,p_lin_req_id => l_itemkey --XXXX

Line 711: l_return_status := FND_API.G_RET_STS_SUCCESS;

707: FOR hdr_rec IN get_hdr_for_hldsrc_cur
708: LOOP
709:
710: BEGIN
711: l_return_status := FND_API.G_RET_STS_SUCCESS;
712:
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add('sync_header_line- in loop -released flag'||hdr_rec.released_flag);
715: END IF;

Line 819: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

815: INSERT_SYNC_lINE(P_LINE_REC => L_LINE_REC,
816: p_change_type => p_change_type,
817: p_req_id => l_itemkey, --XXXX
818: X_RETURN_STATUS => L_RETURN_STATUS);
819: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
820: IF l_debug_level > 0 THEN
821: oe_debug_pub.add('sync_header_line - Line inserted');
822: END IF;
823: END IF;

Line 846: WHEN FND_API.G_EXC_ERROR THEN

842: ,p_hold_source_id => p_hold_source_id
843: ,p_order_hold_id => p_order_hold_id);
844:
845: EXCEPTION
846: WHEN FND_API.G_EXC_ERROR THEN
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add('sync_header_line - G_EXC_ERROR Inside Main LOOP for Header/LineID: '
849: || hdr_rec.header_id || '/' || hdr_rec.line_id);
850: END IF;

Line 851: l_return_status := FND_API.G_RET_STS_ERROR;

847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add('sync_header_line - G_EXC_ERROR Inside Main LOOP for Header/LineID: '
849: || hdr_rec.header_id || '/' || hdr_rec.line_id);
850: END IF;
851: l_return_status := FND_API.G_RET_STS_ERROR;
852:
853: WHEN OTHERS THEN
854: IF l_debug_level > 0 THEN
855: oe_debug_pub.add('sync_header_line - OTHERS Inside Main LOOP for Header/LineID: '

Line 858: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

854: IF l_debug_level > 0 THEN
855: oe_debug_pub.add('sync_header_line - OTHERS Inside Main LOOP for Header/LineID: '
856: || hdr_rec.header_id || '/' || hdr_rec.line_id);
857: END IF;
858: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: OE_MSG_PUB.Add_Exc_Msg
862: ( G_PKG_NAME

Line 942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

938: IF l_debug_level > 0 THEN
939: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event5');
940: END IF;
941:
942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
943: raise_bpel_out_event(
944: p_header_id => ord_rec.header_id
945: ,p_line_id => ord_rec.line_id
946: ,p_hdr_req_id => l_itemkey

Line 967: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

963: IF l_debug_level > 0 THEN
964: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event6');
965: END IF;
966:
967: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
968: raise_bpel_out_event(p_header_id => ord_rec.header_id
969: ,p_line_id => ord_rec.line_id
970: ,p_hdr_req_id => l_itemkey --XXXX
971: ,p_lin_req_id => l_itemkey --XXXX