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

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

79: l_location_id NUMBER;
80: l_region_id_list varchar2(32000) := ',';
81: l_return_status VARCHAR2(1);
82: l_region_id_tbl WSH_UTIL_CORE.ID_TAB_TYPE;
83: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
84: begin
85:
86: IF NOT OE_GLOBALS.Equal( p_ship_to_org_id , G_SHIP_TO_ORGANIZATION_ID ) then
87:

Line 103: oe_debug_pub.add('Unexpected error in WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');

99: x_return_status => l_return_status );
100:
101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
102: IF l_debug_level > 0 then
103: oe_debug_pub.add('Unexpected error in WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');
104: END IF;
105:
106: RETURN NULL;
107: END IF;

Line 123: oe_debug_pub.add('Unexpected error in getting the region_ids :'||SQLERRM);

119: END IF;
120: Exception
121: when others then
122: IF l_debug_level > 0 then
123: oe_debug_pub.add('Unexpected error in getting the region_ids :'||SQLERRM);
124: END IF;
125:
126: return NULL;
127:

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

214: P_INVOICE_TO_ORG_ID IN NUMBER,
215: P_DELIVER_TO_ORG_ID IN NUMBER
216: ) IS
217:
218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
219: begin
220:
221: IF l_debug_level > 0 then
222: oe_debug_pub.add(' Set Globals - P_CUSTOMER_ID :'||P_CUSTOMER_ID );

Line 222: oe_debug_pub.add(' Set Globals - P_CUSTOMER_ID :'||P_CUSTOMER_ID );

218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
219: begin
220:
221: IF l_debug_level > 0 then
222: oe_debug_pub.add(' Set Globals - P_CUSTOMER_ID :'||P_CUSTOMER_ID );
223: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CLASS_ID :'||P_CUSTOMER_CLASS_ID );
224: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CATEGORY_CODE :'||P_CUSTOMER_CATEGORY_CODE );
225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );
226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );

Line 223: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CLASS_ID :'||P_CUSTOMER_CLASS_ID );

219: begin
220:
221: IF l_debug_level > 0 then
222: oe_debug_pub.add(' Set Globals - P_CUSTOMER_ID :'||P_CUSTOMER_ID );
223: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CLASS_ID :'||P_CUSTOMER_CLASS_ID );
224: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CATEGORY_CODE :'||P_CUSTOMER_CATEGORY_CODE );
225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );
226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );
227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );

Line 224: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CATEGORY_CODE :'||P_CUSTOMER_CATEGORY_CODE );

220:
221: IF l_debug_level > 0 then
222: oe_debug_pub.add(' Set Globals - P_CUSTOMER_ID :'||P_CUSTOMER_ID );
223: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CLASS_ID :'||P_CUSTOMER_CLASS_ID );
224: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CATEGORY_CODE :'||P_CUSTOMER_CATEGORY_CODE );
225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );
226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );
227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );
228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);

Line 225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );

221: IF l_debug_level > 0 then
222: oe_debug_pub.add(' Set Globals - P_CUSTOMER_ID :'||P_CUSTOMER_ID );
223: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CLASS_ID :'||P_CUSTOMER_CLASS_ID );
224: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CATEGORY_CODE :'||P_CUSTOMER_CATEGORY_CODE );
225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );
226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );
227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );
228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);
229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );

Line 226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );

222: oe_debug_pub.add(' Set Globals - P_CUSTOMER_ID :'||P_CUSTOMER_ID );
223: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CLASS_ID :'||P_CUSTOMER_CLASS_ID );
224: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CATEGORY_CODE :'||P_CUSTOMER_CATEGORY_CODE );
225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );
226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );
227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );
228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);
229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );
230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );

Line 227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );

223: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CLASS_ID :'||P_CUSTOMER_CLASS_ID );
224: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CATEGORY_CODE :'||P_CUSTOMER_CATEGORY_CODE );
225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );
226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );
227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );
228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);
229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );
230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);

Line 228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);

224: oe_debug_pub.add(' Set Globals - P_CUSTOMER_CATEGORY_CODE :'||P_CUSTOMER_CATEGORY_CODE );
225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );
226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );
227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );
228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);
229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );
230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);
232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);

Line 229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );

225: oe_debug_pub.add(' Set Globals - P_REGION_ID_LIST :'|| P_REGION_ID_LIST );
226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );
227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );
228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);
229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );
230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);
232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);
233: oe_debug_pub.add(' Set Globals - OPERATING_UNIT_ID :'|| mo_global.get_current_org_id);

Line 230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );

226: oe_debug_pub.add(' Set Globals - P_ORDER_TYPE_ID :'||P_ORDER_TYPE_ID );
227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );
228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);
229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );
230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);
232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);
233: oe_debug_pub.add(' Set Globals - OPERATING_UNIT_ID :'|| mo_global.get_current_org_id);
234: oe_debug_pub.add(' Set Globals - ITEM_VALIDATION_ORG_ID :'|| OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));

Line 231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);

227: oe_debug_pub.add(' Set Globals - P_SHIP_TO_ORG_ID :'||P_SHIP_TO_ORG_ID );
228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);
229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );
230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);
232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);
233: oe_debug_pub.add(' Set Globals - OPERATING_UNIT_ID :'|| mo_global.get_current_org_id);
234: oe_debug_pub.add(' Set Globals - ITEM_VALIDATION_ORG_ID :'|| OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
235: END IF;

Line 232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);

228: oe_debug_pub.add(' Set Globals - P_SALES_CHANNEL_CODE :'||P_SALES_CHANNEL_CODE);
229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );
230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);
232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);
233: oe_debug_pub.add(' Set Globals - OPERATING_UNIT_ID :'|| mo_global.get_current_org_id);
234: oe_debug_pub.add(' Set Globals - ITEM_VALIDATION_ORG_ID :'|| OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
235: END IF;
236:

Line 233: oe_debug_pub.add(' Set Globals - OPERATING_UNIT_ID :'|| mo_global.get_current_org_id);

229: oe_debug_pub.add(' Set Globals - P_SALESREP_ID :'||P_SALESREP_ID );
230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);
232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);
233: oe_debug_pub.add(' Set Globals - OPERATING_UNIT_ID :'|| mo_global.get_current_org_id);
234: oe_debug_pub.add(' Set Globals - ITEM_VALIDATION_ORG_ID :'|| OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
235: END IF;
236:
237: G_CUSTOMER_ID := P_CUSTOMER_ID;

Line 234: oe_debug_pub.add(' Set Globals - ITEM_VALIDATION_ORG_ID :'|| OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));

230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);
232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);
233: oe_debug_pub.add(' Set Globals - OPERATING_UNIT_ID :'|| mo_global.get_current_org_id);
234: oe_debug_pub.add(' Set Globals - ITEM_VALIDATION_ORG_ID :'|| OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
235: END IF;
236:
237: G_CUSTOMER_ID := P_CUSTOMER_ID;
238: G_CUSTOMER_CLASS_ID := P_CUSTOMER_CLASS_ID;

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

363: Function Validate_item_orderability ( p_line_rec in OE_Order_PUB.Line_Rec_Type )
364: Return BOOLEAN IS
365: l_operating_unit_id NUMBER;
366: l_exists varchar2(1);
367: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
368:
369:
370: l_x_item_category_id NUMBER;
371: l_x_customer_class_id NUMBER;

Line 389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);

385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
387:
388: IF l_debug_level >0 then
389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);
391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);

Line 390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);

386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
387:
388: IF l_debug_level >0 then
389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);
391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);
394: oe_debug_pub.add('region_id_list :'||l_x_region_id_list);

Line 391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);

387:
388: IF l_debug_level >0 then
389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);
391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);
394: oe_debug_pub.add('region_id_list :'||l_x_region_id_list);
395: oe_debug_pub.add('order_type_id :'||l_x_order_type_id);

Line 392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);

388: IF l_debug_level >0 then
389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);
391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);
394: oe_debug_pub.add('region_id_list :'||l_x_region_id_list);
395: oe_debug_pub.add('order_type_id :'||l_x_order_type_id);
396: oe_debug_pub.add('sales_channel_code :'||l_x_sales_channel_code);

Line 393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);

389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);
391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);
394: oe_debug_pub.add('region_id_list :'||l_x_region_id_list);
395: oe_debug_pub.add('order_type_id :'||l_x_order_type_id);
396: oe_debug_pub.add('sales_channel_code :'||l_x_sales_channel_code);
397:

Line 394: oe_debug_pub.add('region_id_list :'||l_x_region_id_list);

390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);
391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);
394: oe_debug_pub.add('region_id_list :'||l_x_region_id_list);
395: oe_debug_pub.add('order_type_id :'||l_x_order_type_id);
396: oe_debug_pub.add('sales_channel_code :'||l_x_sales_channel_code);
397:
398: END IF;

Line 395: oe_debug_pub.add('order_type_id :'||l_x_order_type_id);

391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);
394: oe_debug_pub.add('region_id_list :'||l_x_region_id_list);
395: oe_debug_pub.add('order_type_id :'||l_x_order_type_id);
396: oe_debug_pub.add('sales_channel_code :'||l_x_sales_channel_code);
397:
398: END IF;
399:

Line 396: oe_debug_pub.add('sales_channel_code :'||l_x_sales_channel_code);

392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);
394: oe_debug_pub.add('region_id_list :'||l_x_region_id_list);
395: oe_debug_pub.add('order_type_id :'||l_x_order_type_id);
396: oe_debug_pub.add('sales_channel_code :'||l_x_sales_channel_code);
397:
398: END IF;
399:
400:

Line 488: oe_debug_pub.add('Exiting OE_ITORD_UTIL.Validate_item_orderability',1);

484:
485: END IF;
486:
487:
488: oe_debug_pub.add('Exiting OE_ITORD_UTIL.Validate_item_orderability',1);
489:
490: Exception
491: when others then
492: OE_MSG_PUB.Add_Exc_Msg

Line 935: oe_debug_pub.add('Rule Level: '||P_RULE_LEVEL);

931: IS
932: l_rule_level_id NUMBER;
933: l_rule_level_value varchar2(200);
934: BEGIN
935: oe_debug_pub.add('Rule Level: '||P_RULE_LEVEL);
936: oe_debug_pub.add('Rule Level Value: '||P_RULE_LEVEL_VALUE);
937:
938: IF p_rule_level IN('CUSTOMER','END_CUST')
939: THEN

Line 936: oe_debug_pub.add('Rule Level Value: '||P_RULE_LEVEL_VALUE);

932: l_rule_level_id NUMBER;
933: l_rule_level_value varchar2(200);
934: BEGIN
935: oe_debug_pub.add('Rule Level: '||P_RULE_LEVEL);
936: oe_debug_pub.add('Rule Level Value: '||P_RULE_LEVEL_VALUE);
937:
938: IF p_rule_level IN('CUSTOMER','END_CUST')
939: THEN
940: