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: IF l_debug_level > 0 THEN
27: oe_debug_pub.add('Entering get_customer_details: ', 5);

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

23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
24: --
25: BEGIN
26: IF l_debug_level > 0 THEN
27: oe_debug_pub.add('Entering get_customer_details: ', 5);
28: oe_debug_pub.add(' p_site_use_id = ' || p_site_use_id, 5);
29: oe_debug_pub.add(' p_site_use_code = ' || p_site_use_code, 5);
30: END IF;
31:

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

24: --
25: BEGIN
26: IF l_debug_level > 0 THEN
27: oe_debug_pub.add('Entering get_customer_details: ', 5);
28: oe_debug_pub.add(' p_site_use_id = ' || p_site_use_id, 5);
29: oe_debug_pub.add(' p_site_use_code = ' || p_site_use_code, 5);
30: END IF;
31:
32: SELECT cust.cust_account_id,

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

25: BEGIN
26: IF l_debug_level > 0 THEN
27: oe_debug_pub.add('Entering get_customer_details: ', 5);
28: oe_debug_pub.add(' p_site_use_id = ' || p_site_use_id, 5);
29: oe_debug_pub.add(' p_site_use_code = ' || p_site_use_code, 5);
30: END IF;
31:
32: SELECT cust.cust_account_id,
33: party.party_name,

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

50: AND cas.cust_account_id = cust.cust_account_id
51: AND cust.party_id=party.party_id;
52:
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
55: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
56: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
57: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
58: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);

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

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

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

52:
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
55: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
56: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
57: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
58: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
59: oe_debug_pub.add('Exiting get_customer_details...', 5);
60: END IF;

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

53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
55: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
56: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
57: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
58: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
59: oe_debug_pub.add('Exiting get_customer_details...', 5);
60: END IF;
61:

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

54: oe_debug_pub.add(' Calculated customer_id: ' || x_customer_id, 5);
55: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
56: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
57: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
58: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
59: oe_debug_pub.add('Exiting get_customer_details...', 5);
60: END IF;
61:
62: EXCEPTION

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

55: oe_debug_pub.add(' Calculated customer_name: ' || x_customer_name, 5);
56: oe_debug_pub.add(' Calculated customer_number: ' || x_customer_number, 5);
57: oe_debug_pub.add(' Calculated customer_site_id: ' || x_customer_site_id, 5);
58: oe_debug_pub.add(' Calculated party_site_id: ' || x_party_site_id, 5);
59: oe_debug_pub.add('Exiting get_customer_details...', 5);
60: END IF;
61:
62: EXCEPTION
63: WHEN NO_DATA_FOUND THEN

Line 64: oe_debug_pub.add(' GetCustomerDetails::: No Data Found: ' || sqlerrm);

60: END IF;
61:
62: EXCEPTION
63: WHEN NO_DATA_FOUND THEN
64: oe_debug_pub.add(' GetCustomerDetails::: No Data Found: ' || sqlerrm);
65:
66: When too_many_rows then
67: oe_debug_pub.add(' GetCustomerDetails::: Too Many Rows: ' || sqlerrm);
68:

Line 67: oe_debug_pub.add(' GetCustomerDetails::: Too Many Rows: ' || sqlerrm);

63: WHEN NO_DATA_FOUND THEN
64: oe_debug_pub.add(' GetCustomerDetails::: No Data Found: ' || sqlerrm);
65:
66: When too_many_rows then
67: oe_debug_pub.add(' GetCustomerDetails::: Too Many Rows: ' || sqlerrm);
68:
69: When others then
70: oe_debug_pub.add(' GetCustomerDetails::: Error occurred: ' || sqlerrm);
71:

Line 70: oe_debug_pub.add(' GetCustomerDetails::: Error occurred: ' || sqlerrm);

66: When too_many_rows then
67: oe_debug_pub.add(' GetCustomerDetails::: Too Many Rows: ' || sqlerrm);
68:
69: When others then
70: oe_debug_pub.add(' GetCustomerDetails::: Error occurred: ' || sqlerrm);
71:
72: END get_customer_details;
73:
74: -- This function retrieves the org_contact_id from the party layer,

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

79: )
80: RETURN NUMBER
81: IS
82: l_org_contact_id NUMBER;
83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
84: BEGIN
85:
86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add(' in get_party_org_contact_id: ' ||

Line 87: oe_debug_pub.add(' in get_party_org_contact_id: ' ||

83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
84: BEGIN
85:
86: IF l_debug_level > 0 THEN
87: oe_debug_pub.add(' in get_party_org_contact_id: ' ||
88: p_cust_acct_role_id || '...',5);
89: END IF;
90:
91: IF ( p_cust_acct_role_id IS NULL ) THEN

Line 107: oe_debug_pub.add(' l_org_contact_id: ' ||

103: AND r.directional_flag = 'F'
104: ;
105:
106: IF l_debug_level > 0 THEN
107: oe_debug_pub.add(' l_org_contact_id: ' ||
108: l_org_contact_id || '...',5);
109: END IF;
110:
111: RETURN l_org_contact_id;

Line 115: oe_debug_pub.add(' Returning null from exception block... ',5);

111: RETURN l_org_contact_id;
112: EXCEPTION
113: WHEN OTHERS THEN
114: IF l_debug_level > 0 THEN
115: oe_debug_pub.add(' Returning null from exception block... ',5);
116: END IF;
117: RETURN NULL;
118: END;
119:

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

129:
130: )
131: IS
132: l_itemkey NUMBER;
133: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
134:
135: -- Start: Added for Enh. 7244277 (solving bug 7622467)
136: l_customer_id number;
137: l_customer_name varchar2(256);

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 153: oe_debug_pub.add(' p_header_rec.invoice_to_org_id... ' ||

149:
150: -- Retrieve the value: invoice_to_customer_id. (Bug # 7622467)
151: IF ( p_header_rec.invoice_to_org_id IS NOT NULL ) THEN
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add(' p_header_rec.invoice_to_org_id... ' ||
154: p_header_rec.invoice_to_org_id, 5);
155: END IF;
156:
157: get_customer_details

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

248: l_itemkey number;
249: l_parent_rec oe_order_pub.line_rec_type;
250: l_tmp_flow_status_code varchar2(256);
251: l_count number;
252: l_debug_level CONSTANT number := oe_debug_pub.g_debug_level;
253:
254: -- Customer Information
255: o_ship_to_cust_id number;
256: o_ship_to_cust_site_id number;

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

273: 'flow status: ' || p_line_rec.flow_status_code);
274: END IF;
275:
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( ' l_itemkey' || l_itemkey);
278: oe_debug_pub.add( ' itemtypecode' || p_line_rec.item_type_code);
279: oe_debug_pub.add( ' split from line' || p_line_rec.split_from_line_id);
280: END IF;
281:

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

274: END IF;
275:
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( ' l_itemkey' || l_itemkey);
278: oe_debug_pub.add( ' itemtypecode' || p_line_rec.item_type_code);
279: oe_debug_pub.add( ' split from line' || p_line_rec.split_from_line_id);
280: END IF;
281:
282: IF p_line_rec.item_type_code='CONFIG' and p_line_rec.split_from_line_id IS NOT NULL THEN

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

275:
276: IF l_debug_level > 0 THEN
277: oe_debug_pub.add( ' l_itemkey' || l_itemkey);
278: oe_debug_pub.add( ' itemtypecode' || p_line_rec.item_type_code);
279: oe_debug_pub.add( ' split from line' || p_line_rec.split_from_line_id);
280: END IF;
281:
282: IF p_line_rec.item_type_code='CONFIG' and p_line_rec.split_from_line_id IS NOT NULL THEN
283: oe_line_util.query_row(

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

283: oe_line_util.query_row(
284: p_line_id => p_line_rec.top_model_line_id
285: ,x_line_rec => l_parent_rec
286: );
287: oe_debug_pub.add( 'top model split from line' || l_parent_rec.split_from_line_id);
288: END IF;
289:
290: -- Retrieve the ORG_CONTACT_ID based on
291: -- p_line_rec.[invoice ship]_to_contact_id

Line 302: oe_debug_pub.add( 'p_line_rec.invoice_to_org_id: ' ||

298:
299: -- Retrieve the value: invoice_to_customer_id
300: IF ( p_line_rec.invoice_to_org_id IS NOT NULL ) THEN
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'p_line_rec.invoice_to_org_id: ' ||
303: p_line_rec.invoice_to_org_id, 5);
304: END IF;
305: get_customer_details
306: (

Line 316: oe_debug_pub.add( 'Done with p_line_rec.invoice_to_org_id.', 5);

312: x_customer_site_id => o_bill_to_cust_site_id,
313: x_party_site_id => o_bill_to_party_site_id
314: );
315: IF l_debug_level > 0 THEN
316: oe_debug_pub.add( 'Done with p_line_rec.invoice_to_org_id.', 5);
317: END IF;
318: END IF;
319:
320: -- Retrieve the value: ship_to_customer_id

Line 323: oe_debug_pub.add( 'p_line_rec.ship_to_org_id: ' ||

319:
320: -- Retrieve the value: ship_to_customer_id
321: IF ( p_line_rec.ship_to_org_id IS NOT NULL ) THEN
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'p_line_rec.ship_to_org_id: ' ||
324: p_line_rec.ship_to_org_id, 5);
325: END IF;
326:
327: get_customer_details

Line 339: oe_debug_pub.add( 'Done with p_line_rec.ship_to_org_id.', 5);

335: x_party_site_id => o_ship_to_party_site_id
336: );
337:
338: IF l_debug_level > 0 THEN
339: oe_debug_pub.add( 'Done with p_line_rec.ship_to_org_id.', 5);
340: END IF;
341: END IF;
342:
343: IF l_debug_level > 0 THEN

Line 344: oe_debug_pub.add( 'Inserting into line acks.', 5);

340: END IF;
341: END IF;
342:
343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'Inserting into line acks.', 5);
345: END IF;
346:
347: INSERT INTO oe_line_acks
348: (header_id

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

543: l_line_rec OE_Order_PUB.Line_Rec_Type;
544: l_header_rec OE_Order_PUB.Header_Rec_Type;
545: l_prev_header_id NUMBER;
546:
547: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
548: l_itemkey number;
549: l_return_status VARCHAR2(1);
550:
551: BEGIN

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

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

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

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

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

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);
558: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
559: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
560: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);

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

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);
558: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
559: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
560: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
561: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);

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

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);
558: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
559: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
560: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
561: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
562: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);

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

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);
558: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
559: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
560: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
561: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
562: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);
563: END IF;

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

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);
558: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
559: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
560: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
561: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
562: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);
563: END IF;
564:

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

557: oe_debug_pub.add('sync_header_line - p_hdr_req_id : '||p_hdr_req_id);
558: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
559: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
560: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
561: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
562: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);
563: END IF;
564:
565: ----

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

558: oe_debug_pub.add('sync_header_line - p_lin_req_id : '||p_lin_req_id);
559: oe_debug_pub.add('sync_header_line - p_change_type : '||p_change_type);
560: oe_debug_pub.add('sync_header_line - p_hold_source_id: '||p_hold_source_id);
561: oe_debug_pub.add('sync_header_line - p_order_hold_id : '||p_order_hold_id);
562: oe_debug_pub.add('sync_header_line - p_hold_release_id : '||p_hold_release_id);
563: END IF;
564:
565: ----
566: -- Outer IF introduced during the fix of 10236368. When hold source based

Line 588: oe_debug_pub.ADD('sync_header_line - Order # ' || p_header_rec.order_number

584: IF p_change_type NOT IN ('APPLY', 'RELEASE') THEN
585: -- Fix of bug 8205201
586: IF ( NOT oe_genesis_util.source_aia_enabled(p_header_rec.order_source_id) )
587: THEN
588: oe_debug_pub.ADD('sync_header_line - Order # ' || p_header_rec.order_number
589: || ', ' || ' order source id: ' || p_header_rec.order_source_id);
590: oe_debug_pub.ADD('sync_header_line - not processing non-AIA order/quote...');
591: RETURN;
592: ELSE

Line 590: oe_debug_pub.ADD('sync_header_line - not processing non-AIA order/quote...');

586: IF ( NOT oe_genesis_util.source_aia_enabled(p_header_rec.order_source_id) )
587: THEN
588: oe_debug_pub.ADD('sync_header_line - Order # ' || p_header_rec.order_number
589: || ', ' || ' order source id: ' || p_header_rec.order_source_id);
590: oe_debug_pub.ADD('sync_header_line - not processing non-AIA order/quote...');
591: RETURN;
592: ELSE
593: oe_debug_pub.ADD('sync_header_line - p_header_rec.order_source_id: ' ||
594: p_header_rec.order_source_id);

Line 593: oe_debug_pub.ADD('sync_header_line - p_header_rec.order_source_id: ' ||

589: || ', ' || ' order source id: ' || p_header_rec.order_source_id);
590: oe_debug_pub.ADD('sync_header_line - not processing non-AIA order/quote...');
591: RETURN;
592: ELSE
593: oe_debug_pub.ADD('sync_header_line - p_header_rec.order_source_id: ' ||
594: p_header_rec.order_source_id);
595: oe_debug_pub.ADD('sync_header_line - processing synch operation on AIA...');
596: END IF; -- End of fix of bug 8205201
597: END IF;

Line 595: oe_debug_pub.ADD('sync_header_line - processing synch operation on AIA...');

591: RETURN;
592: ELSE
593: oe_debug_pub.ADD('sync_header_line - p_header_rec.order_source_id: ' ||
594: p_header_rec.order_source_id);
595: oe_debug_pub.ADD('sync_header_line - processing synch operation on AIA...');
596: END IF; -- End of fix of bug 8205201
597: END IF;
598: ----
599: -- 10236368

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

608: oe_genesis_util.source_aia_enabled(p_header_rec.order_source_id) -- 10236368
609: ) THEN
610:
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add('sync_header_line- APPLY- Inserting row into oe_line_acks for p_line_id');
613: END IF;
614:
615: select OE_XML_MESSAGE_SEQ_S.nextval
616: into l_itemkey

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

621: p_req_id => l_itemkey, -- XXXX
622: X_RETURN_STATUS => L_RETURN_STATUS);
623:
624: IF l_debug_level > 0 THEN
625: oe_debug_pub.add('sync_header_line -APPLY- Inserting into oe_line_acks for p_line_id is DONE'||l_return_status);
626: END IF;
627:
628: IF p_header_rec.header_id IS NOT NULL THEN
629: IF l_debug_level > 0 THEN

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

626: END IF;
627:
628: IF p_header_rec.header_id IS NOT NULL THEN
629: IF l_debug_level > 0 THEN
630: oe_debug_pub.add(' INSERT_SYNC_HEADER - inserting for apply holds ');
631: END IF;
632:
633: INSERT_SYNC_HEADER(p_header_rec => p_header_rec,
634: p_change_type => null, --TODO

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

635: p_req_id => l_itemkey, --XXXX
636: x_return_status => l_return_status);
637: END IF;
638: IF l_debug_level > 0 THEN
639: oe_debug_pub.add('sync_header_line - APPLY-inserted into line acks');
640: END IF;
641:
642: IF l_debug_level > 0 THEN
643: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event1');

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

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

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

657: -- p_header_rec.booked_flag = 'Y' AND bug 16041842
658: oe_genesis_util.source_aia_enabled(p_header_rec.order_source_id) THEN -- 10236368
659:
660: IF l_debug_level > 0 THEN
661: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for header_id');
662: END IF;
663: select OE_XML_MESSAGE_SEQ_S.nextval
664: into l_itemkey
665: from dual;

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

669: p_req_id => l_itemkey, --XXXX
670: x_return_status => l_return_status);
671:
672: IF l_debug_level > 0 THEN
673: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for header_id is DONE');
674: END IF;
675:
676: IF l_debug_level > 0 THEN
677: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event2');

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

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

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

699: -- is sensitive to the order header being AIA enabled or not.
700: ----
701:
702: IF l_debug_level > 0 THEN
703: oe_debug_pub.add('sync_header_line - Inserting row into oe_header_acks for p_hold_source_id');
704: END IF;
705:
706:
707: FOR hdr_rec IN get_hdr_for_hldsrc_cur

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

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

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

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;
716: IF l_debug_level > 0 THEN
717: oe_debug_pub.add('sync_header_line- hdr_rec.line_id: '||hdr_rec.line_id);
718: END IF;
719:
720:
721: IF hdr_rec.line_id IS NULL THEN

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

724: into l_itemkey
725: from dual;
726:
727: IF l_debug_level > 0 THEN
728: oe_debug_pub.add('sync_header_line - l_itemkey '|| l_itemkey);
729: END IF;
730:
731: INSERT INTO oe_header_acks
732: (header_id

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

757: ,hdr_rec.org_id
758: ,hdr_rec.order_source_id);
759:
760: IF l_debug_level > 0 THEN
761: oe_debug_pub.add('sync_header_line - after insert');
762: END IF;
763: ELSE -- hdr_rec.line_id is NOT NULL
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);

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

761: oe_debug_pub.add('sync_header_line - after insert');
762: END IF;
763: ELSE -- hdr_rec.line_id is NOT NULL
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);
766: oe_debug_pub.add('sync_header_line - l_prev_header_id'||l_prev_header_id);
767: END IF;
768: If hdr_rec.header_id <> nvl(l_prev_header_id,-1) THEN
769: select OE_XML_MESSAGE_SEQ_S.nextval

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

762: END IF;
763: ELSE -- hdr_rec.line_id is NOT NULL
764: IF l_debug_level > 0 THEN
765: oe_debug_pub.add('sync_header_line - hdr_rec.header_id'||hdr_rec.header_id);
766: oe_debug_pub.add('sync_header_line - l_prev_header_id'||l_prev_header_id);
767: END IF;
768: If hdr_rec.header_id <> nvl(l_prev_header_id,-1) THEN
769: select OE_XML_MESSAGE_SEQ_S.nextval
770: into l_itemkey

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

770: into l_itemkey
771: from dual;
772:
773: IF l_debug_level > 0 THEN
774: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
775: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);
776: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );
777: END IF;
778: INSERT INTO oe_header_acks

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

771: from dual;
772:
773: IF l_debug_level > 0 THEN
774: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
775: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);
776: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );
777: END IF;
778: INSERT INTO oe_header_acks
779: (header_id

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

772:
773: IF l_debug_level > 0 THEN
774: oe_debug_pub.add('sync_header_line-l_prev_header_id=' || l_prev_header_id);
775: oe_debug_pub.add('sync_header_line-hdr_rec.header_id=' || hdr_rec.header_id);
776: oe_debug_pub.add('sync_header_line-l_item_key=' || l_itemkey );
777: END IF;
778: INSERT INTO oe_header_acks
779: (header_id
780: ,acknowledgment_type

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

805: l_prev_header_id := hdr_rec.header_id;
806: END IF;
807:
808: IF l_debug_level > 0 THEN
809: oe_debug_pub.add('sync_header_line - calling query row ');
810: END IF;
811: oe_line_util.query_row(
812: p_line_id => hdr_rec.line_id
813: ,x_line_rec => l_line_rec

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

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;
824:
825: END IF; -- hdr_rec.line_id

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

824:
825: END IF; -- hdr_rec.line_id
826:
827: IF l_debug_level > 0 THEN
828: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event3');
829: END IF;
830:
831: ---
832: -- Would be good to do a check on l_return_status before calling this API.

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

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;
851: l_return_status := FND_API.G_RET_STS_ERROR;
852:

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

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

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

867:
868: END LOOP;
869:
870: IF l_debug_level > 0 THEN
871: oe_debug_pub.add('sync_header_line - Inserting into oe_header_acks for p_hold_source_id is DONE');
872: END IF;
873: END IF;
874: END IF;
875:

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

881:
882: FOR ord_rec IN get_ord_hld_cur
883: LOOP
884: IF l_debug_level > 0 THEN
885: oe_debug_pub.add('sync_header_line -RELEASE-QUERING HEADER RECORD');
886: END IF;
887:
888: -- Bug 8463870
889: if ( p_header_rec.header_id IS NULL ) then

Line 890: oe_debug_pub.add('.... Querying header_rec using API...');

886: END IF;
887:
888: -- Bug 8463870
889: if ( p_header_rec.header_id IS NULL ) then
890: oe_debug_pub.add('.... Querying header_rec using API...');
891: OE_Header_UTIL.Query_Row
892: (p_header_id => ord_rec.header_id
893: ,x_header_rec => l_header_rec
894: );

Line 896: oe_debug_pub.add('.... Assigning from passed in parameters...');

892: (p_header_id => ord_rec.header_id
893: ,x_header_rec => l_header_rec
894: );
895: else
896: oe_debug_pub.add('.... Assigning from passed in parameters...');
897: l_header_rec := p_header_rec;
898: end if;
899:
900: IF ord_rec.line_id IS NOT NULL THEN

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

898: end if;
899:
900: IF ord_rec.line_id IS NOT NULL THEN
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add('sync_header_line -RELEASE-QUERING LINE RECORD');
903: END IF;
904:
905: -- Bug 8463870
906: if ( p_line_rec.line_id is NULL ) then

Line 907: oe_debug_pub.add('.... Querying line_rec using API...');

903: END IF;
904:
905: -- Bug 8463870
906: if ( p_line_rec.line_id is NULL ) then
907: oe_debug_pub.add('.... Querying line_rec using API...');
908: oe_line_util.query_row(
909: p_line_id => ord_rec.line_id
910: ,x_line_rec => l_line_rec
911: );

Line 913: oe_debug_pub.add('... Assigning from passed in parameters...');

909: p_line_id => ord_rec.line_id
910: ,x_line_rec => l_line_rec
911: );
912: else
913: oe_debug_pub.add('... Assigning from passed in parameters...');
914: l_line_rec := p_line_rec;
915: end if;
916:
917: select OE_XML_MESSAGE_SEQ_S.nextval

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

918: into l_itemkey
919: from dual;
920:
921: IF l_debug_level > 0 THEN
922: oe_debug_pub.add('sync_header_line -RELEASE-BEFORE INSERTING HEADER ');
923: END IF;
924:
925: INSERT_SYNC_HEADER(p_header_rec => l_header_rec,
926: p_change_type => null,

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

927: p_req_id => l_itemkey,
928: x_return_status => l_return_status);
929:
930: IF l_debug_level > 0 THEN
931: oe_debug_pub.add('sync_header_line -RELEASE-BEFORE INSERTING LINE ');
932: END IF;
933: INSERT_SYNC_LINE(P_LINE_REC => l_line_rec,
934: p_change_type => p_change_type,
935: p_req_id => l_itemkey,

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

935: p_req_id => l_itemkey,
936: X_RETURN_STATUS => L_RETURN_STATUS);
937:
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(

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

960: p_change_type => p_change_type,
961: p_req_id => l_itemkey, --XXXX
962: x_return_status => l_return_status);
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

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

980: -- Complete: commenting superfluous code bug 8667900
981:
982: /*
983: IF l_debug_level > 0 THEN
984: oe_debug_pub.add('sync_header_line - Raise BPEL event by calling raise_bpel_out_event');
985: END IF;
986: */
987:
988:

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

991: ----
992: IF p_change_type NOT IN ('APPLY','RELEASE') THEN
993:
994: IF l_debug_level > 0 THEN
995: oe_debug_pub.add('sync_header_line - inserted into header acks');
996: END IF;
997: IF p_header_rec.header_id IS NOT NULL THEN
998:
999: INSERT_SYNC_HEADER(p_header_rec => p_header_rec,

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

1001: p_req_id => p_hdr_req_id,
1002: x_return_status => l_return_status);
1003: END IF;
1004: IF l_debug_level > 0 THEN
1005: oe_debug_pub.add('sync_header_line - inserted into line acks');
1006: END IF;
1007:
1008:
1009: IF l_debug_level > 0 THEN

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

1006: END IF;
1007:
1008:
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add('sync_header_line - before calling bpel');
1011: oe_debug_pub.add('sync_header_line - flow status'||p_line_rec.flow_status_code);
1012: END IF;
1013:
1014: /* logging business event */

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

1007:
1008:
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add('sync_header_line - before calling bpel');
1011: oe_debug_pub.add('sync_header_line - flow status'||p_line_rec.flow_status_code);
1012: END IF;
1013:
1014: /* logging business event */
1015:

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

1095: LINE_CATEGORY_CODE -- 9151484
1096: FROM oe_line_acks
1097: WHERE request_id = p_lin_req_id;
1098:
1099: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1100:
1101: l_hdr_rec_ctr NUMBER := 0;
1102: l_line_rec_ctr NUMBER := 0;
1103:

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

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

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

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

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

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);
1112: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
1113: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
1114: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);

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

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);
1112: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
1113: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
1114: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);
1115: END IF;

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

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);
1112: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
1113: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
1114: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);
1115: END IF;
1116:

Line 1113: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_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);
1112: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
1113: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
1114: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);
1115: END IF;
1116:
1117:

Line 1114: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_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);
1112: oe_debug_pub.add('process_order_sync - p_change_type : '||p_change_type);
1113: oe_debug_pub.add('process_order_sync - p_hold_source_id: '||p_hold_source_id);
1114: oe_debug_pub.add('process_order_sync - p_order_hold_id : '||p_order_hold_id);
1115: END IF;
1116:
1117:
1118: IF p_hdr_req_id IS NOT NULL AND

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

1117:
1118: IF p_hdr_req_id IS NOT NULL AND
1119: p_hdr_req_id <> 0 THEN
1120: IF l_debug_level > 0 THEN
1121: oe_debug_pub.add('process_order_sync - Getting data to populate p_hdr_ack_tbl');
1122: END IF;
1123: l_hdr_rec_ctr := 0;
1124: FOR hdr_rec IN get_hdr_req_cur LOOP
1125: l_hdr_rec_ctr := l_hdr_rec_ctr + 1;

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

1145: IF p_lin_req_id IS NOT NULL AND
1146: p_lin_req_id <> 0 THEN
1147:
1148: IF l_debug_level > 0 THEN
1149: oe_debug_pub.add('process_order_sync - Getting data to populate p_line_ack_tbl');
1150: END IF;
1151: l_line_rec_ctr := 0;
1152: FOR line_rec IN get_line_req_cur LOOP
1153: l_line_rec_ctr := l_line_rec_ctr + 1;

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

1235:
1236: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
1237: l_itemkey NUMBER;
1238: l_event_name VARCHAR2(50);
1239: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1240:
1241: BEGIN
1242:
1243: IF l_debug_level > 0 THEN

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

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

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

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

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

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);
1249: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1250: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1251: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);

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

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);
1249: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1250: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1251: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1252: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');

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

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);
1249: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1250: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1251: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1252: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');
1253: END IF;

Line 1250: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_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);
1249: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1250: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1251: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1252: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');
1253: END IF;
1254:

Line 1251: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_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);
1249: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1250: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1251: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1252: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');
1253: END IF;
1254:
1255: wf_event.AddParameterToList(p_name => 'HEADER_ID'

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

1248: oe_debug_pub.add('raise_bpel_out_event - p_lin_req_id : '||p_lin_req_id);
1249: oe_debug_pub.add('raise_bpel_out_event - p_change_type : '||p_change_type);
1250: oe_debug_pub.add('raise_bpel_out_event - p_hold_source_id: '||p_hold_source_id);
1251: oe_debug_pub.add('raise_bpel_out_event - p_order_hold_id : '||p_order_hold_id);
1252: oe_debug_pub.add('raise_bpel_out_event - Adding parameters to l_parameter_list');
1253: END IF;
1254:
1255: wf_event.AddParameterToList(p_name => 'HEADER_ID'
1256: ,p_value => NVL(p_header_id, 0)

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

1280: ,p_value => NVL(p_order_hold_id, 0)
1281: ,p_parameterlist => l_parameter_list);
1282:
1283: IF l_debug_level > 0 THEN
1284: oe_debug_pub.add('raise_bpel_out_event - Finished adding parameters to l_parameter_list');
1285: END IF;
1286:
1287: SELECT OE_XML_MESSAGE_SEQ_S.nextval /* New one to be seeded */
1288: INTO l_itemkey

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

1288: INTO l_itemkey
1289: FROM DUAL;
1290:
1291: IF l_debug_level > 0 THEN
1292: oe_debug_pub.add('raise_bpel_out_event - Generated value of l_itemkey: '||l_itemkey);
1293: END IF;
1294:
1295: l_event_name := 'oracle.apps.ont.genesis.outbound.update';
1296: wf_event.raise(p_event_name => l_event_name

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

1297: ,p_event_key => l_itemkey
1298: ,p_parameters => l_parameter_list);
1299:
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add('raise_bpel_out_event - l_event_name: '||l_event_name);
1302: oe_debug_pub.add('raise_bpel_out_event - Raising event...');
1303: END IF;
1304:
1305:

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

1298: ,p_parameters => l_parameter_list);
1299:
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add('raise_bpel_out_event - l_event_name: '||l_event_name);
1302: oe_debug_pub.add('raise_bpel_out_event - Raising event...');
1303: END IF;
1304:
1305:
1306: IF l_debug_level > 0 THEN

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