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

Line 67: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);

63: IS
64: l_control_rec OE_GLOBALS.Control_Rec_Type;
65: l_return_status VARCHAR2(1);
66: BEGIN
67: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);
68:
69:
70:
71: -- Set the UI flag

Line 215: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);

211: ( p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214:
215: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DEFAULT_ATTRIBUTES', 1);
216:
217: EXCEPTION
218:
219: WHEN FND_API.G_EXC_ERROR THEN

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

288: IS
289: l_control_rec OE_GLOBALS.Control_Rec_Type;
290: l_return_status VARCHAR2(1);
291: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
292: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
293: template_id NUMBER := x_header_rec.contract_template_id;
294: BEGIN
295:
296: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);

Line 296: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);

292: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
293: template_id NUMBER := x_header_rec.contract_template_id;
294: BEGIN
295:
296: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);
297: oe_debug_pub.add('hash template id in change att start is '|| x_header_rec.contract_template_id);
298: -- Set the UI flag
299: OE_GLOBALS.G_UI_FLAG := TRUE;
300:

Line 297: oe_debug_pub.add('hash template id in change att start is '|| x_header_rec.contract_template_id);

293: template_id NUMBER := x_header_rec.contract_template_id;
294: BEGIN
295:
296: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);
297: oe_debug_pub.add('hash template id in change att start is '|| x_header_rec.contract_template_id);
298: -- Set the UI flag
299: OE_GLOBALS.G_UI_FLAG := TRUE;
300:
301: -- Set control flags.

Line 325: oe_debug_pub.add('hash template id in change att after get_header is '|| x_header_rec.contract_template_id);

321: ( p_db_record => FALSE
322: , p_header_id => p_header_id
323: , x_header_rec => x_header_rec
324: );
325: oe_debug_pub.add('hash template id in change att after get_header is '|| x_header_rec.contract_template_id);
326: x_header_rec.contract_template_id :=template_id;
327: x_old_header_rec := x_header_rec;
328:
329: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN

Line 332: oe_debug_pub.add( 'Code Release is >= 11.5.9') ;

328:
329: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
330:
331: IF l_debug_level > 0 THEN
332: oe_debug_pub.add( 'Code Release is >= 11.5.9') ;
333: END IF;
334:
335:
336: Copy_Attribute_To_Rec

Line 365: oe_debuG_pub.add('attri id'||p_attr_id);

361: -- COPY_ATTRIBUTE_TO_REC ALSO. THIS NEW PROCEDURE WILL REPLACE
362: -- THESE CALLS POST OM PACK I OR 11.5.9.
363:
364:
365: oe_debuG_pub.add('attri id'||p_attr_id);
366: oe_debug_pub.add('attr val ksur'||p_attr_value);
367: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
368: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
369: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN

Line 366: oe_debug_pub.add('attr val ksur'||p_attr_value);

362: -- THESE CALLS POST OM PACK I OR 11.5.9.
363:
364:
365: oe_debuG_pub.add('attri id'||p_attr_id);
366: oe_debug_pub.add('attr val ksur'||p_attr_value);
367: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
368: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);
369: ELSIF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE_DURATION THEN
370: x_header_rec.accounting_rule_duration := TO_NUMBER(p_attr_value);

Line 739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);

735: x_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
736: END IF;
737:
738: -- Call Oe_Order_Pvt.Header
739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);
740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);
741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);
742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:

Line 740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);

736: END IF;
737:
738: -- Call Oe_Order_Pvt.Header
739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);
740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);
741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);
742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:
744: Oe_Order_Pvt.Header

Line 741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);

737:
738: -- Call Oe_Order_Pvt.Header
739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);
740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);
741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);
742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:
744: Oe_Order_Pvt.Header
745: (

Line 742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);

738: -- Call Oe_Order_Pvt.Header
739: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES'||x_header_rec.sold_to_phone_id, 1);
740: oe_debug_pub.add('hash template id in change att before invoice is '|| x_header_rec.contract_template_id);
741: oe_debug_pub.add('Entering invoice'||x_header_rec.invoice_to_org_id, 1);
742: oe_debug_pub.add('Entering Invoice'||x_old_header_rec.invoice_to_org_id, 1);
743:
744: Oe_Order_Pvt.Header
745: (
746: p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);

749: , p_x_header_rec => x_header_rec
750: , p_x_old_header_rec => x_old_header_rec
751: , x_return_status => l_return_status
752: );
753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:

Line 754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);

750: , p_x_old_header_rec => x_old_header_rec
751: , x_return_status => l_return_status
752: );
753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 755: oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);

751: , x_return_status => l_return_status
752: );
753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 756: oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);

752: );
753: oe_debug_pub.add('Exiting invoice'||x_header_rec.invoice_to_org_id, 1);
754: oe_debug_pub.add('Exiting invoice'||x_old_header_rec.invoice_to_org_id, 1);
755: oe_debug_pub.add('Holder name new'||x_header_rec.credit_card_holder_name);
756: oe_debug_pub.add('Holder name old'||x_old_header_rec.credit_card_holder_name);
757:
758: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 783: oe_debug_pub.add('instr id in fhpmb'||x_header_rec.cc_instrument_id);

779: --OE_Default_Pvt package
780:
781: IF OE_Default_Pvt.g_default_instrument_id IS NOT NULL THEN
782: x_header_rec.cc_instrument_id := OE_Default_Pvt.g_default_instrument_id;
783: oe_debug_pub.add('instr id in fhpmb'||x_header_rec.cc_instrument_id);
784: --Setting the value of assignment id to null
785: --after passing the value to the library
786: OE_Default_Pvt.g_default_instrument_id := null;
787: END IF;

Line 791: oe_debug_pub.add('assign id in fhpmb'||x_header_rec.cc_instrument_assignment_id );

787: END IF;
788:
789: IF OE_Default_Pvt.g_default_instr_assignment_id IS NOT NULL THEN
790: x_header_rec.cc_instrument_assignment_id := OE_Default_Pvt.g_default_instr_assignment_id;
791: oe_debug_pub.add('assign id in fhpmb'||x_header_rec.cc_instrument_assignment_id );
792: --Setting the value of assignment id to null
793: --after passing the value to the library
794: OE_Default_Pvt.g_default_instr_assignment_id := null;
795: END IF;

Line 817: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);

813: ( p_count => x_msg_count
814: , p_data => x_msg_data
815: );
816:
817: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CHANGE_ATTRIBUTES', 1);
818:
819: EXCEPTION
820:
821: WHEN FND_API.G_EXC_ERROR THEN

Line 907: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);

903: BEGIN
904:
905: SAVEPOINT Header_Validate_And_Write;
906:
907: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);
908:
909: -- Set the UI flag
910: OE_GLOBALS.G_UI_FLAG := TRUE;
911:

Line 1024: oe_debug_pub.add('ksurendr Freight terms code after PO'||x_freight_terms_code, 1);

1020: (p_ship_method_code =>l_x_header_rec.shipping_method_code
1021: );
1022: --bug 4348011
1023: x_freight_terms_code := l_x_header_rec.freight_terms_code;
1024: oe_debug_pub.add('ksurendr Freight terms code after PO'||x_freight_terms_code, 1);
1025: x_freight_terms := OE_ID_TO_VALUE.Freight_Terms
1026: (p_freight_terms_code => l_x_header_rec.freight_terms_code);
1027: x_payment_term_id := l_x_header_rec.payment_term_id;
1028: x_payment_term := OE_ID_TO_VALUE.Payment_Term

Line 1053: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);

1049: ( p_count => x_msg_count
1050: , p_data => x_msg_data
1051: );
1052:
1053: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.VALIDATE_AND_WRITE', 1);
1054:
1055: EXCEPTION
1056:
1057: WHEN FND_API.G_EXC_ERROR THEN

Line 1128: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DELETE_ROW', 1);

1124: l_return_status VARCHAR2(1);
1125: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1126: BEGIN
1127: SAVEPOINT Header_Delete;
1128: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.DELETE_ROW', 1);
1129:
1130: -- Set the UI flag
1131: OE_GLOBALS.G_UI_FLAG := TRUE;
1132:

Line 1198: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DELETE_ROW', 1);

1194: ( p_count => x_msg_count
1195: , p_data => x_msg_data
1196: );
1197:
1198: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.DELETE_ROW', 1);
1199:
1200: EXCEPTION
1201:
1202: WHEN FND_API.G_EXC_ERROR THEN

Line 1265: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);

1261: IS
1262: l_return_status VARCHAR2(1);
1263: BEGIN
1264:
1265: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);
1266:
1267: -- Set the UI flag
1268: OE_GLOBALS.G_UI_FLAG := TRUE;
1269:

Line 1301: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);

1297: ( p_count => x_msg_count
1298: , p_data => x_msg_data
1299: );
1300:
1301: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_ENTITY', 1);
1302:
1303: EXCEPTION
1304:
1305: WHEN FND_API.G_EXC_ERROR THEN

Line 1368: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);

1364: l_return_status VARCHAR2(1);
1365: l_control_rec OE_GLOBALS.Control_Rec_Type;
1366: l_line_tbl oe_order_pub.line_tbl_type;
1367: BEGIN
1368: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);
1369:
1370: OE_MSG_PUB.initialize;
1371:
1372: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >='110510' THEN

Line 1447: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);

1443:
1444: OE_GLOBALS.G_UI_FLAG := FALSE;
1445: OE_GLOBALS.G_PROCESS_OBJECTS_FLAG := FALSE;
1446:
1447: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.PROCESS_OBJECT', 1);
1448:
1449: EXCEPTION
1450:
1451: WHEN FND_API.G_EXC_ERROR THEN

Line 1516: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.LOCK_ROW', 1);

1512: l_return_status VARCHAR2(1);
1513: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1514: BEGIN
1515:
1516: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.LOCK_ROW', 1);
1517:
1518: -- Load header record
1519:
1520: l_x_header_rec.lock_control := p_lock_control;

Line 1526: oe_debug_pub.add('header_id'|| l_x_header_rec.header_id, 1);

1522: l_x_header_rec.operation := OE_GLOBALS.G_OPR_LOCK; -- not req.
1523:
1524: -- Call OE_Header_Util.Lock_Row instead of Oe_Order_Pvt.Lock_order
1525:
1526: oe_debug_pub.add('header_id'|| l_x_header_rec.header_id, 1);
1527:
1528: OE_MSG_PUB.initialize;
1529: OE_Header_Util.Lock_Row
1530: ( x_return_status => l_return_status

Line 1563: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.LOCK_ROW', 1);

1559: ( p_count => x_msg_count
1560: , p_data => x_msg_data
1561: );
1562:
1563: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.LOCK_ROW', 1);
1564:
1565: EXCEPTION
1566: WHEN FND_API.G_EXC_ERROR THEN
1567:

Line 1621: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.WRITE_HEADER', 1);

1617: )
1618: IS
1619: BEGIN
1620:
1621: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.WRITE_HEADER', 1);
1622:
1623: g_header_rec := p_header_rec;
1624:
1625: IF p_db_record THEN

Line 1631: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.WRITE_HEADER', 1);

1627: g_db_header_rec := p_header_rec;
1628:
1629: END IF;
1630:
1631: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.WRITE_HEADER', 1);
1632:
1633: END Write_Header;
1634:
1635: PROCEDURE Get_header

Line 1644: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_HEADER', 1);

1640: IS
1641:
1642: BEGIN
1643:
1644: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_HEADER', 1);
1645:
1646: IF p_header_id <> NVL(g_header_rec.header_id,FND_API.G_MISS_NUM)
1647: THEN
1648:

Line 1674: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_HEADER', 1);

1670: x_header_rec:= g_header_rec;
1671:
1672: END IF;
1673:
1674: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_HEADER', 1);
1675:
1676: END Get_Header;
1677:
1678: PROCEDURE Clear_Header

Line 1682: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CLEAR_HEADER', 1);

1678: PROCEDURE Clear_Header
1679: IS
1680: BEGIN
1681:
1682: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.CLEAR_HEADER', 1);
1683:
1684: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1685: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1686:

Line 1687: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CLEAR_HEADER', 1);

1683:
1684: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1685: g_db_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
1686:
1687: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.CLEAR_HEADER', 1);
1688:
1689: END Clear_Header;
1690:
1691:

Line 1721: oe_debug_pub.add('Request does not exist, reset versioning globals'); IF (NOT OE_Versioning_Util.Reset_Globals) THEN

1717: );
1718:
1719: IF OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
1720:
1721: oe_debug_pub.add('Request does not exist, reset versioning globals'); IF (NOT OE_Versioning_Util.Reset_Globals) THEN
1722: l_return_status := FND_API.G_RET_STS_ERROR;
1723: RETURN;
1724: END IF;
1725: END IF;

Line 1805: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.SALES_PERSON', 1);

1801: and line_id is null;
1802: l_count Number;
1803: Begin
1804:
1805: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.SALES_PERSON', 1);
1806:
1807: OE_MSG_PUB.initialize;
1808: x_return_status := FND_API.G_RET_STS_SUCCESS;
1809: p_multiple_sales_credits := 'N';

Line 1836: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.SALES_PERSON', 1);

1832: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1833: RAISE FND_API.G_EXC_ERROR;
1834: END IF;
1835:
1836: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.SALES_PERSON', 1);
1837:
1838: EXCEPTION
1839:
1840: WHEN FND_API.G_EXC_ERROR THEN

Line 1883: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);

1879: FROM fnd_id_flex_structures
1880: WHERE id_flex_code = X_Id_Flex_Code;
1881: BEGIN
1882:
1883: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
1884:
1885: OPEN C_Item_Flex(Item_Id_Flex_Code);
1886: FETCH C_Item_Flex INTO Item_Id_Flex_Num;
1887: CLOSE C_Item_Flex;

Line 1889: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);

1885: OPEN C_Item_Flex(Item_Id_Flex_Code);
1886: FETCH C_Item_Flex INTO Item_Id_Flex_Num;
1887: CLOSE C_Item_Flex;
1888:
1889: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
1890:
1891: EXCEPTION
1892: WHEN OTHERS THEN
1893: oe_debug_pub.add('In when others exception : OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);

Line 1893: oe_debug_pub.add('In when others exception : OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);

1889: oe_debug_pub.add('Exiting OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
1890:
1891: EXCEPTION
1892: WHEN OTHERS THEN
1893: oe_debug_pub.add('In when others exception : OE_OE_FORM_HEADER.GET_FORM_STARTUP_VALUES', 1);
1894: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: OE_MSG_PUB.Add_Exc_Msg
1897: ( G_PKG_NAME ,

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

1982: x_check_number varchar2(100);
1983: l_return_status VARCHAR2(30) := NULL ;
1984: l_msg_count NUMBER := 0 ;
1985: l_msg_data VARCHAR2(2000) := NULL ;
1986: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1987: --R12 CC Encryption
1988:
1989: BEGIN
1990: if l_debug_level > 0 then

Line 1991: oe_debug_pub.add('Entering OE_OE_Form_Header.Populate_Control_Fields');

1987: --R12 CC Encryption
1988:
1989: BEGIN
1990: if l_debug_level > 0 then
1991: oe_debug_pub.add('Entering OE_OE_Form_Header.Populate_Control_Fields');
1992: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);
1993: end if;
1994:
1995: IF p_header_rec_type.salesrep_id is not null THEN

Line 1992: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);

1988:
1989: BEGIN
1990: if l_debug_level > 0 then
1991: oe_debug_pub.add('Entering OE_OE_Form_Header.Populate_Control_Fields');
1992: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);
1993: end if;
1994:
1995: IF p_header_rec_type.salesrep_id is not null THEN
1996: BEGIN

Line 2567: oe_debug_pub.add('prepaid_amount: '||x_header_val_rec.prepaid_amount||' And commitment_amount: '||l_commitment_amount);

2563: EXCEPTION
2564: WHEN NO_DATA_FOUND THEN
2565: l_commitment_amount := 0;
2566: END;
2567: oe_debug_pub.add('prepaid_amount: '||x_header_val_rec.prepaid_amount||' And commitment_amount: '||l_commitment_amount);
2568: x_header_val_rec.pending_amount := NVL(x_header_val_rec.subtotal,0)+NVL(x_header_val_rec.charges,0)+NVL(x_header_val_rec.tax,0) - NVL(x_header_val_rec.prepaid_amount, 0) - l_commitment_amount;
2569: oe_debug_pub.add('pending_amount: '||x_header_val_rec.pending_amount);
2570: ELSE
2571: x_header_val_rec.pending_amount := NULL;

Line 2569: oe_debug_pub.add('pending_amount: '||x_header_val_rec.pending_amount);

2565: l_commitment_amount := 0;
2566: END;
2567: oe_debug_pub.add('prepaid_amount: '||x_header_val_rec.prepaid_amount||' And commitment_amount: '||l_commitment_amount);
2568: x_header_val_rec.pending_amount := NVL(x_header_val_rec.subtotal,0)+NVL(x_header_val_rec.charges,0)+NVL(x_header_val_rec.tax,0) - NVL(x_header_val_rec.prepaid_amount, 0) - l_commitment_amount;
2569: oe_debug_pub.add('pending_amount: '||x_header_val_rec.pending_amount);
2570: ELSE
2571: x_header_val_rec.pending_amount := NULL;
2572: END IF;
2573:

Line 2602: oe_debug_pub.add('payment_type_code in populate control fields'||p_header_rec_type.payment_type_code);

2598: END IF;
2599:
2600: --R12 CC Encryption
2601: if l_debug_level > 0 then
2602: oe_debug_pub.add('payment_type_code in populate control fields'||p_header_rec_type.payment_type_code);
2603: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);
2604: end if;
2605:
2606: IF p_header_rec_type.payment_type_code IN ('CREDIT_CARD') THEN

Line 2603: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);

2599:
2600: --R12 CC Encryption
2601: if l_debug_level > 0 then
2602: oe_debug_pub.add('payment_type_code in populate control fields'||p_header_rec_type.payment_type_code);
2603: oe_debug_pub.add('Header id'||p_header_rec_type.header_id);
2604: end if;
2605:
2606: IF p_header_rec_type.payment_type_code IN ('CREDIT_CARD') THEN
2607:

Line 2676: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');

2672: x_header_val_rec.instrument_security_code := l_instrument_security_code;
2673: x_header_val_rec.cc_instrument_id := l_instrument_id;
2674: x_header_val_rec.cc_instrument_assignment_id := l_instrument_assignment_id;
2675:
2676: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');
2677: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2678: oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2679: BEGIN
2680: IF x_header_val_rec.credit_card_code is not null then

Line 2677: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);

2673: x_header_val_rec.cc_instrument_id := l_instrument_id;
2674: x_header_val_rec.cc_instrument_assignment_id := l_instrument_assignment_id;
2675:
2676: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');
2677: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2678: oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2679: BEGIN
2680: IF x_header_val_rec.credit_card_code is not null then
2681: x_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card

Line 2678: oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);

2674: x_header_val_rec.cc_instrument_assignment_id := l_instrument_assignment_id;
2675:
2676: oe_debug_pub.add('After calling OE_Header_Util.Query_card_details');
2677: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2678: oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2679: BEGIN
2680: IF x_header_val_rec.credit_card_code is not null then
2681: x_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card
2682: ( p_credit_card_code => x_header_val_rec.credit_card_code

Line 2717: l_debug_level NUMBER := oe_debug_pub.g_debug_level; -- cc project

2713: FUNCTION Load_Set_Of_Books
2714: RETURN Set_Of_Books_Rec_Type
2715: IS
2716: l_set_of_books_id NUMBER := NULL;
2717: l_debug_level NUMBER := oe_debug_pub.g_debug_level; -- cc project
2718: BEGIN
2719: /* commenting below line for cc project*/
2720: -- OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;
2721: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

Line 2720: -- OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;

2716: l_set_of_books_id NUMBER := NULL;
2717: l_debug_level NUMBER := oe_debug_pub.g_debug_level; -- cc project
2718: BEGIN
2719: /* commenting below line for cc project*/
2720: -- OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;
2721: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);
2722:
2723: -- Get set_of_books_id from profile option.
2724:

Line 2721: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

2717: l_debug_level NUMBER := oe_debug_pub.g_debug_level; -- cc project
2718: BEGIN
2719: /* commenting below line for cc project*/
2720: -- OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;
2721: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);
2722:
2723: -- Get set_of_books_id from profile option.
2724:
2725: --l_set_of_books_id := FND_PROFILE.VALUE('OE_SET_OF_BOOKS_ID');

Line 2739: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

2735: FROM OE_GL_SETS_OF_BOOKS_V
2736: WHERE SET_OF_BOOKS_ID = l_set_of_books_id;
2737:
2738: END IF;
2739: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);
2740:
2741: RETURN g_set_of_books_rec;
2742:
2743: EXCEPTION

Line 2823: OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;

2819: PROCEDURE RESET_DEBUG_LEVEL
2820: IS
2821:
2822: BEGIN
2823: OE_DEBUG_PUB.G_DEBUG_LEVEL:=0;
2824:
2825: END RESET_DEBUG_LEVEL;
2826:
2827:

Line 2832: OE_DEBUG_PUB.G_DEBUG_LEVEL:=p_debug_level;

2828: PROCEDURE SET_DEBUG_LEVEL (p_debug_level IN NUMBER)
2829: IS
2830:
2831: BEGIN
2832: OE_DEBUG_PUB.G_DEBUG_LEVEL:=p_debug_level;
2833:
2834: END SET_DEBUG_LEVEL;
2835:
2836:

Line 2895: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute');

2891: l_init_msg_list VARCHAR2(1) := FND_API.G_TRUE;
2892: --serla end
2893: BEGIN
2894: SAVEPOINT Header_Cascade_Attributes;
2895: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute');
2896: IF NOT OE_Globals.Equal(
2897: p_header_rec.cust_po_number,
2898: p_old_db_header_rec.cust_po_number) OR
2899: NOT OE_Globals.Equal(

Line 3262: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-Before PO');

3258: END IF; -- Cascade Only if Line is Open
3259: END LOOP;
3260:
3261: END IF;
3262: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-Before PO');
3263:
3264: -- Added for cascading in Mass Change ER 7509356
3265: IF OE_MASS_CHANGE_PVT.IS_MASS_CHANGE = 'T' THEN
3266: l_init_msg_list := FND_API.G_FALSE;

Line 3301: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-After PO');

3297: , p_x_lot_serial_tbl => l_x_lot_serial_tbl
3298:
3299: );
3300:
3301: oe_debug_pub.add('Entering OE_OE_FOR_HEADER.Cascade Attribute-After PO');
3302:
3303:
3304: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3461: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Create_Agreement', 1);

3457:
3458: BEGIN
3459:
3460:
3461: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Create_Agreement', 1);
3462:
3463: p_Agreement_rec.name := p_agreement_name;
3464: p_agreement_rec.creation_date :=sysdate;
3465: p_agreement_rec.created_by := FND_GLOBAL.USER_ID;

Line 3479: oe_debug_pub.add('Before Process_Agreement', 1);

3475: p_agreement_rec.agreement_id := FND_API.G_MISS_NUM;
3476: p_agreement_rec.operation := QP_GLOBALS.G_OPR_CREATE;
3477: p_agreement_rec.price_list_id := p_price_list_id;
3478: p_agreement_rec.sold_to_org_id := p_sold_to_org_id;
3479: oe_debug_pub.add('Before Process_Agreement', 1);
3480:
3481: OE_Pricing_Cont_PUB.Process_Agreement
3482: ( p_api_version_number => 1.0
3483:

Line 3501: oe_debug_pub.add('After Process_Agreement', 1);

3497: , x_Price_LLine_val_tbl => x_price_list_line_val_tbl
3498: , x_Pricing_Attr_tbl => x_pricing_attr_tbl
3499: , x_Pricing_Attr_val_tbl => x_pricing_attr_val_tbl
3500: );
3501: oe_debug_pub.add('After Process_Agreement', 1);
3502:
3503:
3504: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3510: oe_debug_pub.add('Before Commit', 1);

3506: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3507: RAISE FND_API.G_EXC_ERROR;
3508:
3509: END IF;
3510: oe_debug_pub.add('Before Commit', 1);
3511:
3512: COMMIT;
3513: oe_debug_pub.add('After Commit', 1);
3514:

Line 3513: oe_debug_pub.add('After Commit', 1);

3509: END IF;
3510: oe_debug_pub.add('Before Commit', 1);
3511:
3512: COMMIT;
3513: oe_debug_pub.add('After Commit', 1);
3514:
3515: EXCEPTION
3516:
3517: WHEN FND_API.G_EXC_ERROR THEN

Line 3555: oe_debug_pub.add('hash before prn');

3551: PROCEDURE Clear_Global_PO_Cache IS
3552: l_return_status VARCHAR2(1);
3553: BEGIN
3554:
3555: oe_debug_pub.add('hash before prn');
3556:
3557: -- bug 3588660
3558: IF OE_CODE_CONTROL.Code_Release_Level >= '110508' THEN
3559:

Line 3570: oe_debug_pub.add('hash calling prn');

3566: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
3569:
3570: oe_debug_pub.add('hash calling prn');
3571:
3572: OE_Order_PVT.Process_Requests_And_Notify
3573: ( p_process_requests => TRUE
3574: , p_notify => FALSE

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

3612: )
3613: IS
3614: l_date_format_mask VARCHAR2(30) := p_date_format_mask;
3615: --
3616: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3617: --
3618: BEGIN
3619: IF p_attr_id = OE_Header_Util.G_ACCOUNTING_RULE THEN
3620: x_header_rec.accounting_rule_id := TO_NUMBER(p_attr_value);

Line 4035: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number', 1);

4031: l_phone_format Varchar2(300);
4032: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
4033:
4034: BEGIN
4035: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number', 1);
4036: IF OE_OE_FORM_HEADER.G_HZ_H_Installed IS NULL THEN
4037: SELECT COUNT(bug_id)
4038: INTO l_bug_count
4039: FROM ad_bugs where bug_number IN ('2116159','2239222','2488745');

Line 4046: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number-HZ Minipack'||OE_OE_FORM_HEADER.G_HZ_H_Installed, 1);

4042: ELSE
4043: OE_OE_FORM_HEADER.G_HZ_H_Installed:='N';
4044: END IF;
4045: END IF;
4046: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number-HZ Minipack'||OE_OE_FORM_HEADER.G_HZ_H_Installed, 1);
4047:
4048: IF OE_OE_FORM_HEADER.G_HZ_H_Installed='N' THEN
4049: x_valid:=TRUE;
4050: ELSE

Line 4090: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number-User Territory'||

4086: END IF;
4087: ELSE
4088: l_user_territory_code:=p_country_code;
4089: END IF;
4090: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number-User Territory'||
4091: l_user_territory_code, 1);
4092:
4093:
4094:

Line 4114: oe_debug_pub.add('Entering Validate_Phone_Number-1x'||l_total_count,1);

4110: select Count(territory_code)
4111: into l_total_count
4112: from hz_phone_formats
4113: where territory_code=l_user_territory_code;
4114: oe_debug_pub.add('Entering Validate_Phone_Number-1x'||l_total_count,1);
4115:
4116: IF l_count=0 AND l_total_count=0 THEN
4117: l_sql_stmt := 'SELECT Count(territory_code)'||
4118: ' FROM hz_phone_country_codes'||

Line 4129: oe_debug_pub.add('Entering Validate_Phone_Number-2x'||l_count,1);

4125: x_valid:=FALSE;
4126: ELSE
4127: x_valid:=TRUE;
4128: END IF;
4129: oe_debug_pub.add('Entering Validate_Phone_Number-2x'||l_count,1);
4130: ELSIF l_count=0 AND l_total_count<>0 THEN
4131: x_valid:=FALSE;
4132: ELSE
4133: x_valid:=TRUE;

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

4294: l_operation VARCHAR2(30);
4295: l_result NUMBER;
4296: l_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
4297: l_action NUMBER;
4298: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4299: BEGIN
4300:
4301: IF l_debug_level > 0 THEN
4302: oe_debug_pub.add( 'ENTER OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;

Line 4302: oe_debug_pub.add( 'ENTER OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;

4298: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4299: BEGIN
4300:
4301: IF l_debug_level > 0 THEN
4302: oe_debug_pub.add( 'ENTER OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;
4303: END IF;
4304:
4305: IF p_column_name IS NOT NULL THEN
4306: -- Initializing return status to SUCCESS

Line 4356: oe_debug_pub.add( 'EXIT OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;

4352: ( p_count => x_msg_count
4353: , p_data => x_msg_data);
4354:
4355: IF l_debug_level > 0 THEN
4356: oe_debug_pub.add( 'EXIT OE_OE_FORM_HEADER.Check_Sec_Header_Attr' , 1 ) ;
4357: END IF;
4358:
4359: END Check_Sec_Header_Attr;
4360:

Line 4408: OE_DEBUG_PUB.ADD('Entering OE_OE_FORM_HEADER.Read_Cascadable_Fields',1);

4404:
4405:
4406: BEGIN
4407:
4408: OE_DEBUG_PUB.ADD('Entering OE_OE_FORM_HEADER.Read_Cascadable_Fields',1);
4409: l_lookup_code :='ACCOUNTING_RULE';
4410: open C_LOOKUP(l_lookup_code,l_lookup_type);
4411: fetch C_LOOKUP into l_enabled_flag;
4412: close C_LOOKUP;

Line 4604: OE_DEBUG_PUB.ADD('Exiting OE_OE_FORM_HEADER.Read_Cascadable_Fields',1);

4600: x_cascade_record:=p_cascade_record; -- Set the record
4601:
4602: x_cascade_record.p_cached:='Y'; -- Caching is done for this session
4603:
4604: OE_DEBUG_PUB.ADD('Exiting OE_OE_FORM_HEADER.Read_Cascadable_Fields',1);
4605:
4606: EXCEPTION
4607:
4608: WHEN NO_DATA_FOUND THEN