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.18.12020000.2 2013/02/06 09:59:37 sahvivek 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.18.12020000.2 2013/02/06 09:59:37 sahvivek 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 146: oe_debug_pub.add( ' ENTERING OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER :'||

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);
148: END IF;
149:
150: -- Retrieve the value: invoice_to_customer_id. (Bug # 7622467)

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

208: ,sysdate
209: ,p_header_rec.transactional_curr_code); -- Bug 9182921
210:
211: IF l_debug_level > 0 THEN
212: oe_debug_pub.add( ' EXITING OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER');
213: END IF;
214:
215: EXCEPTION
216:

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

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;
223:
224: WHEN OTHERS THEN
225:

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

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

Line 235: , 'OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER'

231: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: OE_MSG_PUB.Add_Exc_Msg
234: ( G_PKG_NAME
235: , 'OE_SYNC_ORDER_PVT.INSERT_SYNC_HEADER'
236: );
237: END IF;
238: END;
239:

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

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||
273: 'flow status: ' || p_line_rec.flow_status_code);
274: END IF;
275:

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

460: ,p_line_rec.line_category_code -- 9151484
461: );
462:
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( ' EXITING OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE');
465: END IF;
466:
467: EXCEPTION
468:

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

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');
475: END IF;
476: WHEN OTHERS THEN
477:
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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;
483: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: OE_MSG_PUB.Add_Exc_Msg

Line 487: , 'OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE'

483: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: OE_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME
487: , 'OE_SYNC_ORDER_PVT.INSERT_SYNC_LINE'
488: );
489: END IF;
490:
491: END;

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

549: l_return_status VARCHAR2(1);
550:
551: BEGIN
552: IF l_debug_level > 0 THEN
553: oe_debug_pub.add('OE_sync_order_PVT - Entering sync_header_line');
554: oe_debug_pub.add('sync_header_line - p_header_id : '||p_header_rec.header_id);
555: oe_debug_pub.add('sync_header_line - booked_flag : '||p_header_rec.booked_flag);
556: oe_debug_pub.add('sync_header_line - p_line_id : '||p_line_rec.line_id);
557: oe_debug_pub.add('sync_header_line - p_hdr_req_id : '||p_hdr_req_id);

Line 863: ,'OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE'

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
863: ,'OE_SYNC_ORDER_PVT.SYNC_HEADER_LINE'
864: );
865: END IF;
866: END;
867:

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

1022: ,p_order_hold_id => p_order_hold_id);
1023: END IF;
1024:
1025: IF l_debug_level > 0 THEN
1026: oe_debug_pub.add('OE_sync_order_PVT - Exiting sync_header_line');
1027: END IF;
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1103:
1104: BEGIN
1105:
1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add('OE_sync_order_PVT - Entering process_order_sync');
1108: oe_debug_pub.add('process_order_sync - p_header_id : '||p_header_id);
1109: oe_debug_pub.add('process_order_sync - p_line_id : '||p_line_id);
1110: oe_debug_pub.add('process_order_sync - p_hdr_req_id : '||p_hdr_req_id);
1111: oe_debug_pub.add('process_order_sync - p_lin_req_id : '||p_lin_req_id);

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

1212: END IF;
1213:
1214:
1215: IF l_debug_level > 0 THEN
1216: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Exiting process_order_sync');
1217: END IF;
1218:
1219: EXCEPTION
1220: WHEN OTHERS THEN

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

1217: END IF;
1218:
1219: EXCEPTION
1220: WHEN OTHERS THEN
1221: oe_debug_pub.add('EXCEPTION in OE_SYNC_ORDER_PVT');
1222: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1223: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'process_order_sync');
1224: END IF;
1225:

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

1240:
1241: BEGIN
1242:
1243: IF l_debug_level > 0 THEN
1244: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Entering raise_bpel_out_event');
1245: oe_debug_pub.add('raise_bpel_out_event - p_header_id : '||p_header_id);
1246: oe_debug_pub.add('raise_bpel_out_event - p_line_id : '||p_line_id);
1247: oe_debug_pub.add('raise_bpel_out_event - p_hdr_req_id : '||p_hdr_req_id);
1248: oe_debug_pub.add('raise_bpel_out_event - p_lin_req_id : '||p_lin_req_id);

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

1303: END IF;
1304:
1305:
1306: IF l_debug_level > 0 THEN
1307: oe_debug_pub.add('OE_SYNC_ORDER_PVT - Exiting raise_bpel_out_event');
1308: END IF;
1309:
1310: EXCEPTION
1311: WHEN OTHERS THEN

Line 1318: END OE_SYNC_ORDER_PVT;

1314: END IF;
1315:
1316: END raise_bpel_out_event;
1317:
1318: END OE_SYNC_ORDER_PVT;