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_BLANKET_PUB dependencies on OE_DEBUG_PUB

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

7:
8: PROCEDURE set_context (p_org_id in number) is
9: l_org_id number ;
10: l_return_status varchar2(1);
11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN
13: l_org_id := p_org_id;
14: if l_debug_level > 0 then
15: oe_debug_pub.add('Entering set_context');

Line 15: oe_debug_pub.add('Entering set_context');

11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN
13: l_org_id := p_org_id;
14: if l_debug_level > 0 then
15: oe_debug_pub.add('Entering set_context');
16: oe_debug_pub.add('Org_id is '||nvl(p_org_id,-1));
17: end if;
18: MO_GLOBAL.set_policy_context('S',l_org_id); -- remove this and next line
19: oe_debug_pub.add('After Set Policy Context ');

Line 16: oe_debug_pub.add('Org_id is '||nvl(p_org_id,-1));

12: BEGIN
13: l_org_id := p_org_id;
14: if l_debug_level > 0 then
15: oe_debug_pub.add('Entering set_context');
16: oe_debug_pub.add('Org_id is '||nvl(p_org_id,-1));
17: end if;
18: MO_GLOBAL.set_policy_context('S',l_org_id); -- remove this and next line
19: oe_debug_pub.add('After Set Policy Context ');
20: OE_GLOBALS.Set_Context();

Line 19: oe_debug_pub.add('After Set Policy Context ');

15: oe_debug_pub.add('Entering set_context');
16: oe_debug_pub.add('Org_id is '||nvl(p_org_id,-1));
17: end if;
18: MO_GLOBAL.set_policy_context('S',l_org_id); -- remove this and next line
19: oe_debug_pub.add('After Set Policy Context ');
20: OE_GLOBALS.Set_Context();
21: END ;
22:
23:

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

29: )IS
30: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
31: l_header_rec OE_Order_PUB.Header_Rec_Type;
32: l_order_type_d INTEGER ;
33: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
34: BEGIN
35: oe_debug_pub.add('In Header Id Conversion ');
36:
37: l_header_val_rec.accounting_rule := p_header_val_rec.accounting_rule ;

Line 35: oe_debug_pub.add('In Header Id Conversion ');

31: l_header_rec OE_Order_PUB.Header_Rec_Type;
32: l_order_type_d INTEGER ;
33: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
34: BEGIN
35: oe_debug_pub.add('In Header Id Conversion ');
36:
37: l_header_val_rec.accounting_rule := p_header_val_rec.accounting_rule ;
38: l_header_val_rec.agreement := p_header_val_rec.agreement ;
39: l_header_val_rec.conversion_type := p_header_val_rec.conversion_type ;

Line 182: oe_debug_pub.add(' Price List :'|| p_header_val_rec.price_list);

178: p_header_rec.ship_from_org_id := l_header_rec.ship_from_org_id ;
179: p_header_rec.shipping_method_code := l_header_rec.shipping_method_code;
180: p_header_rec.freight_terms_code := l_header_rec.freight_terms_code;
181:
182: oe_debug_pub.add(' Price List :'|| p_header_val_rec.price_list);
183: oe_debug_pub.add(' Price List Id :'|| p_header_rec.price_list_id);
184: oe_debug_pub.add(' Invoice to org id :'|| p_header_rec.invoice_to_org_id );
185: oe_debug_pub.add(' Ship to org id :'|| p_header_rec.ship_to_org_id);
186: oe_debug_pub.add(' Deliver to Org id :'|| p_header_rec.deliver_to_org_id );

Line 183: oe_debug_pub.add(' Price List Id :'|| p_header_rec.price_list_id);

179: p_header_rec.shipping_method_code := l_header_rec.shipping_method_code;
180: p_header_rec.freight_terms_code := l_header_rec.freight_terms_code;
181:
182: oe_debug_pub.add(' Price List :'|| p_header_val_rec.price_list);
183: oe_debug_pub.add(' Price List Id :'|| p_header_rec.price_list_id);
184: oe_debug_pub.add(' Invoice to org id :'|| p_header_rec.invoice_to_org_id );
185: oe_debug_pub.add(' Ship to org id :'|| p_header_rec.ship_to_org_id);
186: oe_debug_pub.add(' Deliver to Org id :'|| p_header_rec.deliver_to_org_id );
187:

Line 184: oe_debug_pub.add(' Invoice to org id :'|| p_header_rec.invoice_to_org_id );

180: p_header_rec.freight_terms_code := l_header_rec.freight_terms_code;
181:
182: oe_debug_pub.add(' Price List :'|| p_header_val_rec.price_list);
183: oe_debug_pub.add(' Price List Id :'|| p_header_rec.price_list_id);
184: oe_debug_pub.add(' Invoice to org id :'|| p_header_rec.invoice_to_org_id );
185: oe_debug_pub.add(' Ship to org id :'|| p_header_rec.ship_to_org_id);
186: oe_debug_pub.add(' Deliver to Org id :'|| p_header_rec.deliver_to_org_id );
187:
188: EXCEPTION

Line 185: oe_debug_pub.add(' Ship to org id :'|| p_header_rec.ship_to_org_id);

181:
182: oe_debug_pub.add(' Price List :'|| p_header_val_rec.price_list);
183: oe_debug_pub.add(' Price List Id :'|| p_header_rec.price_list_id);
184: oe_debug_pub.add(' Invoice to org id :'|| p_header_rec.invoice_to_org_id );
185: oe_debug_pub.add(' Ship to org id :'|| p_header_rec.ship_to_org_id);
186: oe_debug_pub.add(' Deliver to Org id :'|| p_header_rec.deliver_to_org_id );
187:
188: EXCEPTION
189:

Line 186: oe_debug_pub.add(' Deliver to Org id :'|| p_header_rec.deliver_to_org_id );

182: oe_debug_pub.add(' Price List :'|| p_header_val_rec.price_list);
183: oe_debug_pub.add(' Price List Id :'|| p_header_rec.price_list_id);
184: oe_debug_pub.add(' Invoice to org id :'|| p_header_rec.invoice_to_org_id );
185: oe_debug_pub.add(' Ship to org id :'|| p_header_rec.ship_to_org_id);
186: oe_debug_pub.add(' Deliver to Org id :'|| p_header_rec.deliver_to_org_id );
187:
188: EXCEPTION
189:
190:

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

212: )IS
213: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
214: l_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_organization_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
217: BEGIN
218: oe_debug_pub.add('In Line Id Conversion ');
219:
220:

Line 218: oe_debug_pub.add('In Line Id Conversion ');

214: l_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_organization_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
217: BEGIN
218: oe_debug_pub.add('In Line Id Conversion ');
219:
220:
221: l_line_val_rec.accounting_rule := p_line_val_rec.accounting_rule ;
222: l_line_val_rec.agreement := p_line_val_rec.agreement ;

Line 313: oe_debug_pub.add(' inventory_item_id :'|| p_line_rec.inventory_item_id, 1);

309: l_line_rec.invoice_to_org_id:= p_line_rec.invoice_to_org_id;
310: l_line_rec.ship_to_org_id := p_line_rec.ship_to_org_id;
311: l_line_rec.inventory_item_id := p_line_rec.inventory_item_id;
312:
313: oe_debug_pub.add(' inventory_item_id :'|| p_line_rec.inventory_item_id, 1);
314: oe_debug_pub.add(' ordered_item_id :'|| p_line_rec.ordered_item_id, 1);
315: -- 7695556
316:
317: IF p_line_rec.inventory_item_id IS NOT NULL

Line 314: oe_debug_pub.add(' ordered_item_id :'|| p_line_rec.ordered_item_id, 1);

310: l_line_rec.ship_to_org_id := p_line_rec.ship_to_org_id;
311: l_line_rec.inventory_item_id := p_line_rec.inventory_item_id;
312:
313: oe_debug_pub.add(' inventory_item_id :'|| p_line_rec.inventory_item_id, 1);
314: oe_debug_pub.add(' ordered_item_id :'|| p_line_rec.ordered_item_id, 1);
315: -- 7695556
316:
317: IF p_line_rec.inventory_item_id IS NOT NULL
318: OR p_line_rec.ordered_item_id IS NOT NULL THEN

Line 330: oe_debug_pub.add(' ordered_item :'|| l_line_rec.ordered_item, 1);

326: ,x_ordered_item => l_line_rec.ordered_item
327: ,x_inventory_item => l_line_val_rec.inventory_item);
328:
329: END IF;
330: oe_debug_pub.add(' ordered_item :'|| l_line_rec.ordered_item, 1);
331: oe_debug_pub.add(' inventory_item :'|| l_line_val_rec.inventory_item, 1);
332:
333: OE_Line_Util.Get_Ids(p_line_val_rec => l_line_val_rec
334: , p_x_line_rec => l_line_rec);

Line 331: oe_debug_pub.add(' inventory_item :'|| l_line_val_rec.inventory_item, 1);

327: ,x_inventory_item => l_line_val_rec.inventory_item);
328:
329: END IF;
330: oe_debug_pub.add(' ordered_item :'|| l_line_rec.ordered_item, 1);
331: oe_debug_pub.add(' inventory_item :'|| l_line_val_rec.inventory_item, 1);
332:
333: OE_Line_Util.Get_Ids(p_line_val_rec => l_line_val_rec
334: , p_x_line_rec => l_line_rec);
335:

Line 338: oe_debug_pub.add(' ordered_item :'|| p_line_rec.ordered_item, 1);

334: , p_x_line_rec => l_line_rec);
335:
336: p_line_rec.ordered_item := l_line_rec.ordered_item;
337:
338: oe_debug_pub.add(' ordered_item :'|| p_line_rec.ordered_item, 1);
339:
340: p_line_rec.accounting_rule_id := l_line_rec.accounting_rule_id;
341: p_line_rec.agreement_id := l_line_rec.agreement_id;
342: p_line_rec.price_list_id := l_line_rec.price_list_id;

Line 358: oe_debug_pub.add(' Price List :'|| p_line_val_rec.price_list);

354: p_line_rec.invoice_to_org_id:= l_line_rec.invoice_to_org_id;
355: p_line_rec.ship_to_org_id := l_line_rec.ship_to_org_id;
356:
357:
358: oe_debug_pub.add(' Price List :'|| p_line_val_rec.price_list);
359: oe_debug_pub.add(' Price List Id :'|| p_line_rec.price_list_id);
360: oe_debug_pub.add(' Invoice to org id :'|| p_line_rec.invoice_to_org_id);
361: oe_debug_pub.add(' Ship to org id :'|| p_line_rec.ship_to_org_id);
362: oe_debug_pub.add(' Deliver to Org id :'|| p_line_rec.deliver_to_org_id);

Line 359: oe_debug_pub.add(' Price List Id :'|| p_line_rec.price_list_id);

355: p_line_rec.ship_to_org_id := l_line_rec.ship_to_org_id;
356:
357:
358: oe_debug_pub.add(' Price List :'|| p_line_val_rec.price_list);
359: oe_debug_pub.add(' Price List Id :'|| p_line_rec.price_list_id);
360: oe_debug_pub.add(' Invoice to org id :'|| p_line_rec.invoice_to_org_id);
361: oe_debug_pub.add(' Ship to org id :'|| p_line_rec.ship_to_org_id);
362: oe_debug_pub.add(' Deliver to Org id :'|| p_line_rec.deliver_to_org_id);
363: oe_debug_pub.add(' ordered_item :'|| p_line_rec.ordered_item, 1);

Line 360: oe_debug_pub.add(' Invoice to org id :'|| p_line_rec.invoice_to_org_id);

356:
357:
358: oe_debug_pub.add(' Price List :'|| p_line_val_rec.price_list);
359: oe_debug_pub.add(' Price List Id :'|| p_line_rec.price_list_id);
360: oe_debug_pub.add(' Invoice to org id :'|| p_line_rec.invoice_to_org_id);
361: oe_debug_pub.add(' Ship to org id :'|| p_line_rec.ship_to_org_id);
362: oe_debug_pub.add(' Deliver to Org id :'|| p_line_rec.deliver_to_org_id);
363: oe_debug_pub.add(' ordered_item :'|| p_line_rec.ordered_item, 1);
364: EXCEPTION

Line 361: oe_debug_pub.add(' Ship to org id :'|| p_line_rec.ship_to_org_id);

357:
358: oe_debug_pub.add(' Price List :'|| p_line_val_rec.price_list);
359: oe_debug_pub.add(' Price List Id :'|| p_line_rec.price_list_id);
360: oe_debug_pub.add(' Invoice to org id :'|| p_line_rec.invoice_to_org_id);
361: oe_debug_pub.add(' Ship to org id :'|| p_line_rec.ship_to_org_id);
362: oe_debug_pub.add(' Deliver to Org id :'|| p_line_rec.deliver_to_org_id);
363: oe_debug_pub.add(' ordered_item :'|| p_line_rec.ordered_item, 1);
364: EXCEPTION
365:

Line 362: oe_debug_pub.add(' Deliver to Org id :'|| p_line_rec.deliver_to_org_id);

358: oe_debug_pub.add(' Price List :'|| p_line_val_rec.price_list);
359: oe_debug_pub.add(' Price List Id :'|| p_line_rec.price_list_id);
360: oe_debug_pub.add(' Invoice to org id :'|| p_line_rec.invoice_to_org_id);
361: oe_debug_pub.add(' Ship to org id :'|| p_line_rec.ship_to_org_id);
362: oe_debug_pub.add(' Deliver to Org id :'|| p_line_rec.deliver_to_org_id);
363: oe_debug_pub.add(' ordered_item :'|| p_line_rec.ordered_item, 1);
364: EXCEPTION
365:
366:

Line 363: oe_debug_pub.add(' ordered_item :'|| p_line_rec.ordered_item, 1);

359: oe_debug_pub.add(' Price List Id :'|| p_line_rec.price_list_id);
360: oe_debug_pub.add(' Invoice to org id :'|| p_line_rec.invoice_to_org_id);
361: oe_debug_pub.add(' Ship to org id :'|| p_line_rec.ship_to_org_id);
362: oe_debug_pub.add(' Deliver to Org id :'|| p_line_rec.deliver_to_org_id);
363: oe_debug_pub.add(' ordered_item :'|| p_line_rec.ordered_item, 1);
364: EXCEPTION
365:
366:
367:

Line 468: oe_debug_pub.add('After Set Context');

464:
465:
466: set_context(p_org_id =>l_org_id);
467:
468: oe_debug_pub.add('After Set Context');
469:
470:
471: IF l_header_rec.operation = OE_Globals.G_OPR_CREATE THEN
472: -- Pre-default header_id for proper message display

Line 476: oe_debug_pub.add('Set Message Context');

472: -- Pre-default header_id for proper message display
473: SELECT OE_ORDER_HEADERS_S.NEXTVAL
474: INTO l_header_rec.header_id
475: FROM DUAL;
476: oe_debug_pub.add('Set Message Context');
477:
478: OE_MSG_PUB.set_msg_context(
479: p_entity_code => 'BLANKET_HEADER'
480: ,p_entity_id => l_header_rec.header_id

Line 494: oe_debug_pub.add('3');

490:
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493:
494: oe_debug_pub.add('3');
495: oe_debug_pub.add (' Price List :'|| l_header_val_rec.price_list );
496: oe_debug_pub.add (' Price List id :'|| l_header_rec.price_list_id );
497:
498: Header_Id_Conversion ( p_header_val_rec => l_header_val_rec

Line 495: oe_debug_pub.add (' Price List :'|| l_header_val_rec.price_list );

491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493:
494: oe_debug_pub.add('3');
495: oe_debug_pub.add (' Price List :'|| l_header_val_rec.price_list );
496: oe_debug_pub.add (' Price List id :'|| l_header_rec.price_list_id );
497:
498: Header_Id_Conversion ( p_header_val_rec => l_header_val_rec
499: , p_header_rec => l_header_rec) ;

Line 496: oe_debug_pub.add (' Price List id :'|| l_header_rec.price_list_id );

492:
493:
494: oe_debug_pub.add('3');
495: oe_debug_pub.add (' Price List :'|| l_header_val_rec.price_list );
496: oe_debug_pub.add (' Price List id :'|| l_header_rec.price_list_id );
497:
498: Header_Id_Conversion ( p_header_val_rec => l_header_val_rec
499: , p_header_rec => l_header_rec) ;
500:

Line 520: oe_debug_pub.add('In Lines Loop', 1);

516: x_return_status := FND_API.G_RET_STS_SUCCESS;
517:
518: FOR l_count in 1..l_line_tbl.COUNT LOOP
519:
520: oe_debug_pub.add('In Lines Loop', 1);
521: oe_debug_pub.add(' Operation :'|| l_line_rec.operation,1);
522:
523: IF l_line_tbl(l_count).operation = OE_Globals.G_OPR_CREATE THEN
524: oe_debug_pub.add(' Operation :'|| l_line_tbl(l_count).operation,1);

Line 521: oe_debug_pub.add(' Operation :'|| l_line_rec.operation,1);

517:
518: FOR l_count in 1..l_line_tbl.COUNT LOOP
519:
520: oe_debug_pub.add('In Lines Loop', 1);
521: oe_debug_pub.add(' Operation :'|| l_line_rec.operation,1);
522:
523: IF l_line_tbl(l_count).operation = OE_Globals.G_OPR_CREATE THEN
524: oe_debug_pub.add(' Operation :'|| l_line_tbl(l_count).operation,1);
525: l_line_tbl(l_count).header_id := l_header_rec.header_id;

Line 524: oe_debug_pub.add(' Operation :'|| l_line_tbl(l_count).operation,1);

520: oe_debug_pub.add('In Lines Loop', 1);
521: oe_debug_pub.add(' Operation :'|| l_line_rec.operation,1);
522:
523: IF l_line_tbl(l_count).operation = OE_Globals.G_OPR_CREATE THEN
524: oe_debug_pub.add(' Operation :'|| l_line_tbl(l_count).operation,1);
525: l_line_tbl(l_count).header_id := l_header_rec.header_id;
526:
527: l_line_rec := l_line_tbl(l_count);
528: l_line_val_rec := l_line_val_tbl(l_count);

Line 530: oe_debug_pub.add(' Call Line_Id_Conversion' ,1);

526:
527: l_line_rec := l_line_tbl(l_count);
528: l_line_val_rec := l_line_val_tbl(l_count);
529:
530: oe_debug_pub.add(' Call Line_Id_Conversion' ,1);
531:
532: Line_Id_Conversion ( p_line_val_rec => l_line_val_rec
533: , p_line_rec => l_line_rec );
534:

Line 544: oe_debug_pub.add('In Lines Loop');

540: FROM DUAL;
541:
542: END IF;
543:
544: oe_debug_pub.add('In Lines Loop');
545: oe_debug_pub.add(' ordered item :'|| l_line_tbl(l_count).ordered_item, 1);
546:
547: OE_MSG_PUB.set_msg_context(
548: p_entity_code => 'BLANKET_LINE'

Line 545: oe_debug_pub.add(' ordered item :'|| l_line_tbl(l_count).ordered_item, 1);

541:
542: END IF;
543:
544: oe_debug_pub.add('In Lines Loop');
545: oe_debug_pub.add(' ordered item :'|| l_line_tbl(l_count).ordered_item, 1);
546:
547: OE_MSG_PUB.set_msg_context(
548: p_entity_code => 'BLANKET_LINE'
549: ,p_entity_id => l_line_tbl(l_count).line_id

Line 575: oe_debug_pub.add('Call OE_BLANKET_PVT.Process_Blanket');

571: l_control_rec.validate_entity := TRUE;
572: l_control_rec.check_security := TRUE;
573: l_control_rec.default_from_header := TRUE;
574:
575: oe_debug_pub.add('Call OE_BLANKET_PVT.Process_Blanket');
576: -- E_GLOBALS.g_validate_desc_flex := p_validate_desc_flex ;
577:
578:
579: OE_BLANKET_PVT.Process_Blanket