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 OE_SYNC_ORDER_PVT

Line 1: PACKAGE BODY OE_SYNC_ORDER_PVT AS

1: PACKAGE BODY OE_SYNC_ORDER_PVT AS
2: /* $Header: OEXVGNOB.pls 120.2.12010000.5 2008/12/28 17:27:21 snimmaga ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SYNC_ORDER_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SYNC_ORDER_PVT';

1: PACKAGE BODY OE_SYNC_ORDER_PVT AS
2: /* $Header: OEXVGNOB.pls 120.2.12010000.5 2008/12/28 17:27:21 snimmaga ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SYNC_ORDER_PVT';
5:
6:
7: --
8: -- Start : Added for Enh. 7244277 (To solve bug 7622467)

Line 127: oe_debug_pub.add( ' ENTERING OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER :'||

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);
129: END IF;
130:
131: -- Retrieve the value: invoice_to_customer_id. (Bug # 7622467)

Line 185: oe_debug_pub.add( ' EXITING OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER');

181: -- End : Added for Enh. 7244277
182: ,sysdate);
183:
184: IF l_debug_level > 0 THEN
185: oe_debug_pub.add( ' EXITING OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER');
186: END IF;
187:
188: EXCEPTION
189:

Line 194: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');

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;
196:
197: WHEN OTHERS THEN
198:

Line 201: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT - G_RET_STS_UNEXP_ERROR');

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:
204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
205: THEN

Line 208: , 'OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER'

204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
205: THEN
206: OE_MSG_PUB.Add_Exc_Msg
207: ( G_PKG_NAME
208: , 'OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER'
209: );
210: END IF;
211: END;
212:

Line 244: oe_debug_pub.add( ' ENTERING OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE :'||

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||
246: 'flow status' || p_line_rec.flow_status_code);
247: END IF;
248:

Line 405: oe_debug_pub.add( ' EXITING OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE');

401: ,sysdate
402: );
403:
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add( ' EXITING OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE');
406: END IF;
407:
408: EXCEPTION
409:

Line 415: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT -G_EXC_ERROR');

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');
416: END IF;
417: WHEN OTHERS THEN
418:
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 422: oe_debug_pub.add( ' OE_SYNC_ORDER_PVT - G_RET_STS_UNEXP_ERROR');

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;
424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: OE_MSG_PUB.Add_Exc_Msg

Line 428: , 'OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE'

424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: OE_MSG_PUB.Add_Exc_Msg
427: ( G_PKG_NAME
428: , 'OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE'
429: );
430: END IF;
431:
432: END;

Line 488: oe_debug_pub.add('OE_sync_order_PVT - Entering sync_header_line');

484: l_return_status VARCHAR2(1);
485:
486: BEGIN
487: IF l_debug_level > 0 THEN
488: oe_debug_pub.add('OE_sync_order_PVT - Entering sync_header_line');
489: oe_debug_pub.add('sync_header_line - p_header_id : '||p_header_rec.header_id);
490: oe_debug_pub.add('sync_header_line - booked_flag : '||p_header_rec.booked_flag);
491: oe_debug_pub.add('sync_header_line - p_line_id : '||p_line_rec.line_id);
492: oe_debug_pub.add('sync_header_line - p_hdr_req_id : '||p_hdr_req_id);

Line 743: ,'OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE'

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
743: ,'OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE'
744: );
745: END IF;
746: END;
747:

Line 883: oe_debug_pub.add('OE_sync_order_PVT - Exiting sync_header_line');

879: ,p_order_hold_id => p_order_hold_id);
880: END IF;
881:
882: IF l_debug_level > 0 THEN
883: oe_debug_pub.add('OE_sync_order_PVT - Exiting sync_header_line');
884: END IF;
885: EXCEPTION
886: WHEN OTHERS THEN
887: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 953: oe_debug_pub.add('OE_sync_order_PVT - Entering process_order_sync');

949:
950: BEGIN
951:
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add('OE_sync_order_PVT - Entering process_order_sync');
954: oe_debug_pub.add('process_order_sync - p_header_id : '||p_header_id);
955: oe_debug_pub.add('process_order_sync - p_line_id : '||p_line_id);
956: oe_debug_pub.add('process_order_sync - p_hdr_req_id : '||p_hdr_req_id);
957: oe_debug_pub.add('process_order_sync - p_lin_req_id : '||p_lin_req_id);

Line 1053: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Exiting process_order_sync');

1049: END IF;
1050:
1051:
1052: IF l_debug_level > 0 THEN
1053: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Exiting process_order_sync');
1054: END IF;
1055:
1056: EXCEPTION
1057: WHEN OTHERS THEN

Line 1058: oe_debug_pub.add('EXCEPTION in OE_SYNC_ORDER_PVT');

1054: END IF;
1055:
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: oe_debug_pub.add('EXCEPTION in OE_SYNC_ORDER_PVT');
1059: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1060: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'process_order_sync');
1061: END IF;
1062:

Line 1081: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Entering raise_bpel_out_event');

1077:
1078: BEGIN
1079:
1080: IF l_debug_level > 0 THEN
1081: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Entering raise_bpel_out_event');
1082: oe_debug_pub.add('raise_bpel_out_event - p_header_id : '||p_header_id);
1083: oe_debug_pub.add('raise_bpel_out_event - p_line_id : '||p_line_id);
1084: oe_debug_pub.add('raise_bpel_out_event - p_hdr_req_id : '||p_hdr_req_id);
1085: oe_debug_pub.add('raise_bpel_out_event - p_lin_req_id : '||p_lin_req_id);

Line 1144: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Exiting raise_bpel_out_event');

1140: END IF;
1141:
1142:
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Exiting raise_bpel_out_event');
1145: END IF;
1146:
1147: EXCEPTION
1148: WHEN OTHERS THEN

Line 1155: END OE_SYNC_ORDER_PVT;

1151: END IF;
1152:
1153: END raise_bpel_out_event;
1154:
1155: END OE_SYNC_ORDER_PVT;