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_DEBUG_PUB

Line 23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

19: x_customer_site_id OUT NOCOPY NUMBER,
20: x_party_site_id OUT NOCOPY NUMBER
21: ) IS
22: --
23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
24: --
25: BEGIN
26: oe_debug_pub.add('Entering get_customer_details: ', 5);
27: oe_debug_pub.add(' p_site_use_id = ' || p_site_use_id, 5);

Line 26: oe_debug_pub.add('Entering get_customer_details: ', 5);

22: --
23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
24: --
25: BEGIN
26: oe_debug_pub.add('Entering get_customer_details: ', 5);
27: oe_debug_pub.add(' p_site_use_id = ' || p_site_use_id, 5);
28: oe_debug_pub.add(' p_site_use_code = ' || p_site_use_code, 5);
29:
30: SELECT cust.cust_account_id,

Line 27: oe_debug_pub.add(' p_site_use_id = ' || p_site_use_id, 5);

23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
24: --
25: BEGIN
26: oe_debug_pub.add('Entering get_customer_details: ', 5);
27: oe_debug_pub.add(' p_site_use_id = ' || p_site_use_id, 5);
28: oe_debug_pub.add(' p_site_use_code = ' || p_site_use_code, 5);
29:
30: SELECT cust.cust_account_id,
31: party.party_name,

Line 28: oe_debug_pub.add(' p_site_use_code = ' || p_site_use_code, 5);

24: --
25: BEGIN
26: oe_debug_pub.add('Entering get_customer_details: ', 5);
27: oe_debug_pub.add(' p_site_use_id = ' || p_site_use_id, 5);
28: oe_debug_pub.add(' p_site_use_code = ' || p_site_use_code, 5);
29:
30: SELECT cust.cust_account_id,
31: party.party_name,
32: cust.account_number,

Line 51: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);

47: AND site.cust_acct_site_id = cas.cust_acct_site_id
48: AND cas.cust_account_id = cust.cust_account_id
49: AND cust.party_id=party.party_id;
50:
51: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
52: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
53: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
54: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
55: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);

Line 52: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);

48: AND cas.cust_account_id = cust.cust_account_id
49: AND cust.party_id=party.party_id;
50:
51: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
52: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
53: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
54: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
55: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
56: oe_debug_pub.add('Exiting get_customer_details...', 5);

Line 53: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);

49: AND cust.party_id=party.party_id;
50:
51: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
52: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
53: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
54: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
55: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
56: oe_debug_pub.add('Exiting get_customer_details...', 5);
57:

Line 54: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);

50:
51: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
52: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
53: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
54: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
55: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
56: oe_debug_pub.add('Exiting get_customer_details...', 5);
57:
58: EXCEPTION

Line 55: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);

51: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
52: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
53: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
54: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
55: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
56: oe_debug_pub.add('Exiting get_customer_details...', 5);
57:
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN

Line 56: oe_debug_pub.add('Exiting get_customer_details...', 5);

52: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
53: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
54: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
55: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
56: oe_debug_pub.add('Exiting get_customer_details...', 5);
57:
58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN
60: Null;

Line 114: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

110:
111: )
112: IS
113: l_itemkey NUMBER;
114: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
115:
116: -- Start: Added for Enh. 7244277 (solving bug 7622467)
117: l_customer_id number;
118: l_customer_name varchar2(256);

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 225: l_debug_level CONSTANT number := oe_debug_pub.g_debug_level;

221: l_itemkey number;
222: l_parent_rec oe_order_pub.line_rec_type;
223: l_tmp_flow_status_code varchar2(256);
224: l_count number;
225: l_debug_level CONSTANT number := oe_debug_pub.g_debug_level;
226:
227: -- Customer Information
228: o_ship_to_cust_id number;
229: o_ship_to_cust_site_id number;

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 250: oe_debug_pub.add( ' l_itemkey' || l_itemkey);

246: 'flow status' || p_line_rec.flow_status_code);
247: END IF;
248:
249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add( ' l_itemkey' || l_itemkey);
251: oe_debug_pub.add( ' itemtypecode' || p_line_rec.item_type_code);
252: oe_debug_pub.add( ' split from line' || p_line_rec.split_from_line_id);
253: END IF;
254:

Line 251: oe_debug_pub.add( ' itemtypecode' || p_line_rec.item_type_code);

247: END IF;
248:
249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add( ' l_itemkey' || l_itemkey);
251: oe_debug_pub.add( ' itemtypecode' || p_line_rec.item_type_code);
252: oe_debug_pub.add( ' split from line' || p_line_rec.split_from_line_id);
253: END IF;
254:
255: IF p_line_rec.item_type_code='CONFIG' and p_line_rec.split_from_line_id IS NOT NULL THEN

Line 252: oe_debug_pub.add( ' split from line' || p_line_rec.split_from_line_id);

248:
249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add( ' l_itemkey' || l_itemkey);
251: oe_debug_pub.add( ' itemtypecode' || p_line_rec.item_type_code);
252: oe_debug_pub.add( ' split from line' || p_line_rec.split_from_line_id);
253: END IF;
254:
255: IF p_line_rec.item_type_code='CONFIG' and p_line_rec.split_from_line_id IS NOT NULL THEN
256: oe_line_util.query_row(

Line 260: oe_debug_pub.add( 'top model split from line' || l_parent_rec.split_from_line_id);

256: oe_line_util.query_row(
257: p_line_id => p_line_rec.top_model_line_id
258: ,x_line_rec => l_parent_rec
259: );
260: oe_debug_pub.add( 'top model split from line' || l_parent_rec.split_from_line_id);
261: END IF;
262:
263: -- Retrieve the ORG_CONTACT_ID based on
264: -- p_line_rec.[invoice ship]_to_contact_id

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 482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

478: l_line_rec OE_Order_PUB.Line_Rec_Type;
479: l_header_rec OE_Order_PUB.Header_Rec_Type;
480: l_prev_header_id NUMBER;
481:
482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
483: l_itemkey number;
484: l_return_status VARCHAR2(1);
485:
486: BEGIN

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 489: oe_debug_pub.add('sync_header_line - p_header_id : '||p_header_rec.header_id);

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);
493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);

Line 490: oe_debug_pub.add('sync_header_line - booked_flag : '||p_header_rec.booked_flag);

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);
493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);

Line 491: oe_debug_pub.add('sync_header_line - p_line_id : '||p_line_rec.line_id);

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);
493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
495: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);

Line 492: oe_debug_pub.add('sync_header_line - p_hdr_req_id : '||p_hdr_req_id);

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);
493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
495: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
496: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);

Line 493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);

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);
493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
495: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
496: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
497: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);

Line 494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);

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);
493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
495: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
496: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
497: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);
498: END IF;

Line 495: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);

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);
493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
495: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
496: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
497: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);
498: END IF;
499:

Line 496: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);

492: oe_debug_pub.add('sync_header_line - p_hdr_req_id : '||p_hdr_req_id);
493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
495: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
496: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
497: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);
498: END IF;
499:
500: IF p_change_type IN ('APPLY', 'RELEASE') THEN

Line 497: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);

493: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
494: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
495: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
496: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
497: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);
498: END IF;
499:
500: IF p_change_type IN ('APPLY', 'RELEASE') THEN
501:

Line 506: oe_debug_pub.add('sync_header_line- APPLY- Inserting row into oe_line_acks for p_line_id');

502: IF (p_line_rec.line_id IS NOT NULL AND
503: p_header_rec.booked_flag = 'Y') THEN
504:
505: IF l_debug_level > 0 THEN
506: oe_debug_pub.add('sync_header_line- APPLY- Inserting row into oe_line_acks for p_line_id');
507: END IF;
508:
509: select OE_XML_MESSAGE_SEQ_S.nextval
510: into l_itemkey

Line 519: oe_debug_pub.add('sync_header_line -APPLY- Inserting into oe_line_acks for p_line_id is DONE'||l_return_status);

515: p_req_id => l_itemkey, -- XXXX
516: X_RETURN_STATUS => L_RETURN_STATUS);
517:
518: IF l_debug_level > 0 THEN
519: oe_debug_pub.add('sync_header_line -APPLY- Inserting into oe_line_acks for p_line_id is DONE'||l_return_status);
520: END IF;
521:
522: IF p_header_rec.header_id IS NOT NULL THEN
523: IF l_debug_level > 0 THEN

Line 524: oe_debug_pub.add(' INSERT_SYNC_HEADER - inserting for apply holds ');

520: END IF;
521:
522: IF p_header_rec.header_id IS NOT NULL THEN
523: IF l_debug_level > 0 THEN
524: oe_debug_pub.add(' INSERT_SYNC_HEADER - inserting for apply holds ');
525: END IF;
526:
527: INSERT_SYNC_HEADER(p_header_rec => p_header_rec,
528: p_change_type => null, --TODO

Line 533: oe_debug_pub.add('sync_header_line - APPLY-inserted into line acks');

529: p_req_id => l_itemkey, --XXXX
530: x_return_status => l_return_status);
531: END IF;
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add('sync_header_line - APPLY-inserted into line acks');
534: END IF;
535:
536: IF l_debug_level > 0 THEN
537: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event1');

Line 537: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event1');

533: oe_debug_pub.add('sync_header_line - APPLY-inserted into line acks');
534: END IF;
535:
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

Line 554: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for header_id');

550: p_header_rec.header_id IS NOT NULL AND
551: p_header_rec.booked_flag = 'Y' THEN
552:
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for header_id');
555: END IF;
556: select OE_XML_MESSAGE_SEQ_S.nextval
557: into l_itemkey
558: from dual;

Line 566: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for header_id is DONE');

562: p_req_id => l_itemkey, --XXXX
563: x_return_status => l_return_status);
564:
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for header_id is DONE');
567: END IF;
568:
569: IF l_debug_level > 0 THEN
570: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event2');

Line 570: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event2');

566: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for header_id is DONE');
567: END IF;
568:
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

Line 588: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for p_hold_source_id');

584: p_header_rec.header_id IS NULL AND
585: p_hold_source_id IS NOT NULL THEN
586:
587: IF l_debug_level > 0 THEN
588: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for p_hold_source_id');
589: END IF;
590:
591:
592: FOR hdr_rec IN get_hdr_for_hldsrc_cur

Line 599: oe_debug_pub.add('sync_header_line- in loop -released flag'||hdr_rec.released_flag);

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;
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add('sync_header_line- hdr_rec.line_id: '||hdr_rec.line_id);
603: END IF;

Line 602: oe_debug_pub.add('sync_header_line- hdr_rec.line_id: '||hdr_rec.line_id);

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;
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add('sync_header_line- hdr_rec.line_id: '||hdr_rec.line_id);
603: END IF;
604:
605:
606: IF hdr_rec.line_id IS NULL THEN

Line 613: oe_debug_pub.add('sync_header_line - l_itemkey '|| l_itemkey);

609: into l_itemkey
610: from dual;
611:
612: IF l_debug_level > 0 THEN
613: oe_debug_pub.add('sync_header_line - l_itemkey '|| l_itemkey);
614: END IF;
615:
616: INSERT INTO oe_header_acks
617: (header_id

Line 646: oe_debug_pub.add('sync_header_line - after insert');

642: ,hdr_rec.org_id
643: ,hdr_rec.order_source_id);
644:
645: IF l_debug_level > 0 THEN
646: oe_debug_pub.add('sync_header_line - after insert');
647: END IF;
648: ELSE -- hdr_rec.line_id is NULL
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);

Line 650: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);

646: oe_debug_pub.add('sync_header_line - after insert');
647: END IF;
648: ELSE -- hdr_rec.line_id is NULL
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);
651: oe_debug_pub.add('sync_header_line - l_prev_header_id'||l_prev_header_id);
652: END IF;
653: If hdr_rec.header_id <> nvl(l_prev_header_id,-1) THEN
654: select OE_XML_MESSAGE_SEQ_S.nextval

Line 651: oe_debug_pub.add('sync_header_line - l_prev_header_id'||l_prev_header_id);

647: END IF;
648: ELSE -- hdr_rec.line_id is NULL
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);
651: oe_debug_pub.add('sync_header_line - l_prev_header_id'||l_prev_header_id);
652: END IF;
653: If hdr_rec.header_id <> nvl(l_prev_header_id,-1) THEN
654: select OE_XML_MESSAGE_SEQ_S.nextval
655: into l_itemkey

Line 659: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);

655: into l_itemkey
656: from dual;
657:
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
660: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);
661: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );
662: END IF;
663: INSERT INTO oe_header_acks

Line 660: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);

656: from dual;
657:
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
660: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);
661: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );
662: END IF;
663: INSERT INTO oe_header_acks
664: (header_id

Line 661: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );

657:
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
660: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);
661: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );
662: END IF;
663: INSERT INTO oe_header_acks
664: (header_id
665: ,acknowledgment_type

Line 694: oe_debug_pub.add('sync_header_line - calling query row ');

690: l_prev_header_id := hdr_rec.header_id;
691: END IF;
692:
693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add('sync_header_line - calling query row ');
695: END IF;
696: oe_line_util.query_row(
697: p_line_id => hdr_rec.line_id
698: ,x_line_rec => l_line_rec

Line 706: oe_debug_pub.add('sync_header_line - Line inserted');

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;
709:
710: END IF; -- hdr_rec.line_id

Line 713: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event3');

709:
710: END IF; -- hdr_rec.line_id
711:
712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event3');
714: END IF;
715:
716: raise_bpel_out_event(
717: p_header_id => hdr_rec.header_id

Line 728: oe_debug_pub.add('sync_header_line - G_EXC_ERROR Inside Main LOOP for Header/LineID: '

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;
731: l_return_status := FND_API.G_RET_STS_ERROR;
732:

Line 735: oe_debug_pub.add('sync_header_line - OTHERS Inside Main LOOP for Header/LineID: '

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: '
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)

Line 751: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for p_hold_source_id is DONE');

747:
748: END LOOP;
749:
750: IF l_debug_level > 0 THEN
751: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for p_hold_source_id is DONE');
752: END IF;
753: END IF;
754: END IF;
755:

Line 762: oe_debug_pub.add('sync_header_line -RELEASE-QUERING HEADER RECORD');

758:
759: FOR ord_rec IN get_ord_hld_cur
760: LOOP
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add('sync_header_line -RELEASE-QUERING HEADER RECORD');
763: END IF;
764: OE_Header_UTIL.Query_Row
765: (p_header_id => ord_rec.header_id
766: ,x_header_rec => l_header_rec

Line 771: oe_debug_pub.add('sync_header_line -RELEASE-QUERING LINE RECORD');

767: );
768:
769: IF ord_rec.line_id IS NOT NULL THEN
770: IF l_debug_level > 0 THEN
771: oe_debug_pub.add('sync_header_line -RELEASE-QUERING LINE RECORD');
772: END IF;
773:
774: oe_line_util.query_row(
775: p_line_id => ord_rec.line_id

Line 784: oe_debug_pub.add('sync_header_line -RELEASE-BEFORE INSERTING HEADER ');

780: into l_itemkey
781: from dual;
782:
783: IF l_debug_level > 0 THEN
784: oe_debug_pub.add('sync_header_line -RELEASE-BEFORE INSERTING HEADER ');
785: END IF;
786:
787: INSERT_SYNC_HEADER(p_header_rec => l_header_rec,
788: p_change_type => null,

Line 793: oe_debug_pub.add('sync_header_line -RELEASE-BEFORE INSERTING LINE ');

789: p_req_id => l_itemkey,
790: x_return_status => l_return_status);
791:
792: IF l_debug_level > 0 THEN
793: oe_debug_pub.add('sync_header_line -RELEASE-BEFORE INSERTING LINE ');
794: END IF;
795: INSERT_SYNC_LINE(P_LINE_REC => l_line_rec,
796: p_change_type => p_change_type,
797: p_req_id => l_itemkey,

Line 801: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event5');

797: p_req_id => l_itemkey,
798: X_RETURN_STATUS => L_RETURN_STATUS);
799:
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(

Line 826: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event6');

822: p_change_type => p_change_type,
823: p_req_id => l_itemkey, --XXXX
824: x_return_status => l_return_status);
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

Line 843: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event');

839: END LOOP;
840: END IF;
841:
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event');
844: END IF;
845:
846:
847: /* To handle other change types */

Line 852: oe_debug_pub.add('sync_header_line - inserted into header acks');

848:
849: IF p_change_type NOT IN ('APPLY','RELEASE') THEN
850:
851: IF l_debug_level > 0 THEN
852: oe_debug_pub.add('sync_header_line - inserted into header acks');
853: END IF;
854: IF p_header_rec.header_id IS NOT NULL THEN
855:
856: INSERT_SYNC_HEADER(p_header_rec => p_header_rec,

Line 862: oe_debug_pub.add('sync_header_line - inserted into line acks');

858: p_req_id => p_hdr_req_id,
859: x_return_status => l_return_status);
860: END IF;
861: IF l_debug_level > 0 THEN
862: oe_debug_pub.add('sync_header_line - inserted into line acks');
863: END IF;
864:
865:
866: IF l_debug_level > 0 THEN

Line 867: oe_debug_pub.add('sync_header_line - before calling bpel');

863: END IF;
864:
865:
866: IF l_debug_level > 0 THEN
867: oe_debug_pub.add('sync_header_line - before calling bpel');
868: oe_debug_pub.add('sync_header_line - flow status'||p_line_rec.flow_status_code);
869: END IF;
870:
871: /* logging business event */

Line 868: oe_debug_pub.add('sync_header_line - flow status'||p_line_rec.flow_status_code);

864:
865:
866: IF l_debug_level > 0 THEN
867: oe_debug_pub.add('sync_header_line - before calling bpel');
868: oe_debug_pub.add('sync_header_line - flow status'||p_line_rec.flow_status_code);
869: END IF;
870:
871: /* logging business event */
872:

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 945: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

941: UNIT_SELLING_PRICE_PER_PQTY, PRICING_DATE, SHIP_TO_ADDRESS_ID
942: FROM oe_line_acks
943: WHERE request_id = p_lin_req_id;
944:
945: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
946:
947: l_hdr_rec_ctr NUMBER := 0;
948: l_line_rec_ctr NUMBER := 0;
949:

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 954: oe_debug_pub.add('process_order_sync - p_header_id : '||p_header_id);

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);
958: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);

Line 955: oe_debug_pub.add('process_order_sync - p_line_id : '||p_line_id);

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);
958: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
959: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);

Line 956: oe_debug_pub.add('process_order_sync - p_hdr_req_id : '||p_hdr_req_id);

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);
958: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
959: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
960: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);

Line 957: oe_debug_pub.add('process_order_sync - p_lin_req_id : '||p_lin_req_id);

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);
958: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
959: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
960: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);
961: END IF;

Line 958: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);

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);
958: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
959: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
960: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);
961: END IF;
962:

Line 959: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_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);
958: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
959: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
960: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);
961: END IF;
962:
963:

Line 960: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_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);
958: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
959: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
960: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);
961: END IF;
962:
963:
964: IF p_hdr_req_id IS NOT NULL AND

Line 967: oe_debug_pub.add('process_order_sync - Getting data to populate p_hdr_ack_tbl');

963:
964: IF p_hdr_req_id IS NOT NULL AND
965: p_hdr_req_id <> 0 THEN
966: IF l_debug_level > 0 THEN
967: oe_debug_pub.add('process_order_sync - Getting data to populate p_hdr_ack_tbl');
968: END IF;
969: l_hdr_rec_ctr := 0;
970: FOR hdr_rec IN get_hdr_req_cur LOOP
971: l_hdr_rec_ctr := l_hdr_rec_ctr + 1;

Line 993: oe_debug_pub.add('process_order_sync - Getting data to populate p_line_ack_tbl');

989: IF p_lin_req_id IS NOT NULL AND
990: p_lin_req_id <> 0 THEN
991:
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add('process_order_sync - Getting data to populate p_line_ack_tbl');
994: END IF;
995: l_line_rec_ctr := 0;
996: FOR line_rec IN get_line_req_cur LOOP
997: l_line_rec_ctr := l_line_rec_ctr + 1;

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 1076: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1072:
1073: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1074: l_itemkey NUMBER;
1075: l_event_name VARCHAR2(50);
1076: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1077:
1078: BEGIN
1079:
1080: IF l_debug_level > 0 THEN

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 1082: oe_debug_pub.add('raise_bpel_out_event - p_header_id : '||p_header_id);

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);
1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);

Line 1083: oe_debug_pub.add('raise_bpel_out_event - p_line_id : '||p_line_id);

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);
1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1087: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);

Line 1084: oe_debug_pub.add('raise_bpel_out_event - p_hdr_req_id : '||p_hdr_req_id);

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);
1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1087: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1088: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);

Line 1085: oe_debug_pub.add('raise_bpel_out_event - p_lin_req_id : '||p_lin_req_id);

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);
1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1087: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1088: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1089: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');

Line 1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);

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);
1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1087: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1088: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1089: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');
1090: END IF;

Line 1087: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_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);
1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1087: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1088: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1089: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');
1090: END IF;
1091:

Line 1088: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_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);
1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1087: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1088: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1089: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');
1090: END IF;
1091:
1092: wf_event.AddParameterToList(p_name => 'HEADER_ID'

Line 1089: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');

1085: oe_debug_pub.add('raise_bpel_out_event - p_lin_req_id : '||p_lin_req_id);
1086: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1087: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1088: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1089: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');
1090: END IF;
1091:
1092: wf_event.AddParameterToList(p_name => 'HEADER_ID'
1093: ,p_value => NVL(p_header_id, 0)

Line 1121: oe_debug_pub.add('raise_bpel_out_event - Finished adding parameters to l_parameter_list');

1117: ,p_value => NVL(p_order_hold_id, 0)
1118: ,p_parameterlist => l_parameter_list);
1119:
1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add('raise_bpel_out_event - Finished adding parameters to l_parameter_list');
1122: END IF;
1123:
1124: SELECT OE_XML_MESSAGE_SEQ_S.nextval /* New one to be seeded */
1125: INTO l_itemkey

Line 1129: oe_debug_pub.add('raise_bpel_out_event - Generated value of l_itemkey: '||l_itemkey);

1125: INTO l_itemkey
1126: FROM DUAL;
1127:
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add('raise_bpel_out_event - Generated value of l_itemkey: '||l_itemkey);
1130: END IF;
1131:
1132: l_event_name := 'oracle.apps.ont.genesis.outbound.update';
1133: wf_event.raise(p_event_name => l_event_name

Line 1138: oe_debug_pub.add('raise_bpel_out_event - l_event_name: '||l_event_name);

1134: ,p_event_key => l_itemkey
1135: ,p_parameters => l_parameter_list);
1136:
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add('raise_bpel_out_event - l_event_name: '||l_event_name);
1139: oe_debug_pub.add('raise_bpel_out_event - Raising event...');
1140: END IF;
1141:
1142:

Line 1139: oe_debug_pub.add('raise_bpel_out_event - Raising event...');

1135: ,p_parameters => l_parameter_list);
1136:
1137: IF l_debug_level > 0 THEN
1138: oe_debug_pub.add('raise_bpel_out_event - l_event_name: '||l_event_name);
1139: oe_debug_pub.add('raise_bpel_out_event - Raising event...');
1140: END IF;
1141:
1142:
1143: IF l_debug_level > 0 THEN

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