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

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

15: PROCEDURE Get_Attr_Tbl
16: IS
17: I NUMBER:=0;
18: --
19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20: --
21: BEGIN
22:
23: FND_API.g_attr_tbl.DELETE;

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

209: IS
210: l_id NUMBER;
211: l_segment_array FND_FLEX_EXT.SegmentArray;
212: --
213: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
214: --
215: BEGIN
216:
217: IF l_debug_level > 0 THEN

Line 218: oe_debug_pub.add( 'ENTERING OE_VALUE_TO_ID.KEY_FLEX' , 1 ) ;

214: --
215: BEGIN
216:
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add( 'ENTERING OE_VALUE_TO_ID.KEY_FLEX' , 1 ) ;
219: END IF;
220: l_segment_array := p_segment_array;
221:
222: -- Convert any missing values to NULL

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

279: ) RETURN NUMBER
280: IS
281: l_id NUMBER;
282: --
283: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
284: --
285: BEGIN
286:
287: IF p_accounting_rule IS NULL

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

332: ) RETURN NUMBER
333: IS
334: l_id NUMBER;
335: --
336: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
337: --
338: BEGIN
339:
340: IF p_agreement IS NULL

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

386: ) RETURN VARCHAR2
387: IS
388: l_code VARCHAR2(30);
389: --
390: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
391: --
392: BEGIN
393:
394: IF p_conversion_type IS NULL

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

440: ) RETURN NUMBER
441: IS
442: l_id NUMBER;
443: --
444: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
445: --
446: BEGIN
447:
448: IF p_deliver_to_contact IS NULL

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

589: l_deliver_to_customer_id number;
590: l_sold_to_org_id number;
591: l_dummy number;
592: --
593: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
594: --
595: BEGIN
596:
597: IF l_debug_level > 0 THEN

Line 598: oe_debug_pub.add( 'DELIVER_TO_ADDRESS1='||P_DELIVER_TO_ADDRESS1||' ADDRESS4='||P_DELIVER_TO_ADDRESS4||' DELIVER_TO_CUST_ID='||P_DELIVER_TO_CUSTOMER_ID ) ;

594: --
595: BEGIN
596:
597: IF l_debug_level > 0 THEN
598: oe_debug_pub.add( 'DELIVER_TO_ADDRESS1='||P_DELIVER_TO_ADDRESS1||' ADDRESS4='||P_DELIVER_TO_ADDRESS4||' DELIVER_TO_CUST_ID='||P_DELIVER_TO_CUSTOMER_ID ) ;
599: END IF;
600: IF nvl( p_deliver_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
601: AND nvl( p_deliver_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char
602: AND nvl( p_deliver_to_address3,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 612: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;

608: END IF;
609:
610: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;
613: END IF;
614: l_sold_to_org_id := p_sold_to_org_id;
615:
616:

Line 619: oe_debug_pub.add( 'DELIVER_TO_CUST_ID IS NULL' ) ;

615:
616:
617: IF nvl(p_deliver_to_Customer_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( 'DELIVER_TO_CUST_ID IS NULL' ) ;
620: END IF;
621: l_deliver_to_customer_id := null;
622: ELSE
623: l_deliver_to_customer_id := p_deliver_to_customer_id;

Line 633: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND DELIVER_TO_CUSTOMER ARE NOT SAME' ) ;

629: IF lcustomer_relations = 'N' AND
630: nvl(l_deliver_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND DELIVER_TO_CUSTOMER ARE NOT SAME' ) ;
634: END IF;
635: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
636:
637: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');

Line 651: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;

647: -- If the customer rel is on, then the customers should be related
648: ELSIF lcustomer_relations = 'Y' AND
649: nvl(l_deliver_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
650: IF l_debug_level > 0 THEN
651: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;
652: END IF;
653:
654: BEGIN
655: SELECT 1

Line 667: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND DELIVER_TO_CUSTOMER ARE NOT RELATED' ) ;

663: WHEN NO_DATA_FOUND THEN
664: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
665:
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND DELIVER_TO_CUSTOMER ARE NOT RELATED' ) ;
668: END IF;
669: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
670: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org_id');
671: OE_MSG_PUB.Add;

Line 683: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;

679:
680: END IF; -- check for diff deliver_cust_id
681:
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;
684: oe_debug_pub.add( 'L_DELIVER_TO_CUST_ID ='||L_DELIVER_TO_CUSTOMER_ID ) ;
685: END IF;
686:
687: IF l_deliver_to_customer_id is not null then

Line 684: oe_debug_pub.add( 'L_DELIVER_TO_CUST_ID ='||L_DELIVER_TO_CUSTOMER_ID ) ;

680: END IF; -- check for diff deliver_cust_id
681:
682: IF l_debug_level > 0 THEN
683: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;
684: oe_debug_pub.add( 'L_DELIVER_TO_CUST_ID ='||L_DELIVER_TO_CUSTOMER_ID ) ;
685: END IF;
686:
687: IF l_deliver_to_customer_id is not null then
688: l_sold_to_org_id := l_deliver_to_Customer_id;

Line 690: oe_debug_pub.add( 'L_DELIVER_TO_CUSTOMER_ID IS NOT NULL' ) ;

686:
687: IF l_deliver_to_customer_id is not null then
688: l_sold_to_org_id := l_deliver_to_Customer_id;
689: IF l_debug_level > 0 THEN
690: oe_debug_pub.add( 'L_DELIVER_TO_CUSTOMER_ID IS NOT NULL' ) ;
691: END IF;
692: END IF;
693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;

Line 694: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;

690: oe_debug_pub.add( 'L_DELIVER_TO_CUSTOMER_ID IS NOT NULL' ) ;
691: END IF;
692: END IF;
693: IF l_debug_level > 0 THEN
694: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;
695: END IF;
696:
697: -- the second condition is added to make sure that if the user passes the
698: -- deliver_to_customer information , it should be used to validate the

Line 705: oe_debug_pub.add( 'IF REL = N OR .. Y AND INV_CUST_ID NOT NULL' ) ;

701: IF lcustomer_relations = 'N' OR
702: (lcustomer_relations = 'Y' and l_deliver_to_customer_id is not null ) OR
703: (lcustomer_relations = 'A' and l_deliver_to_customer_id is not null )THEN
704: IF l_debug_level > 0 THEN
705: oe_debug_pub.add( 'IF REL = N OR .. Y AND INV_CUST_ID NOT NULL' ) ;
706: END IF;
707:
708: OPEN c_deliver_to_org_id(l_sold_to_org_id);
709: FETCH c_deliver_to_org_id

Line 744: oe_debug_pub.add( 'FOUND' ) ;

740: INTO l_id;
741:
742: IF C1%FOUND then
743: IF l_debug_level > 0 THEN
744: oe_debug_pub.add( 'FOUND' ) ;
745: END IF;
746: CLOSE C1;
747: return l_id;
748: ELSE

Line 750: oe_debug_pub.add( 'NOT FOUND' ) ;

746: CLOSE C1;
747: return l_id;
748: ELSE
749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add( 'NOT FOUND' ) ;
751: END IF;
752: l_org :=mo_global.get_current_org_id ; --MOAC
753: --select userenv('CLIENT_INFO') into l_org from dual;
754: IF l_debug_level > 0 THEN

Line 755: oe_debug_pub.add( 'ORG='||L_ORG ) ;

751: END IF;
752: l_org :=mo_global.get_current_org_id ; --MOAC
753: --select userenv('CLIENT_INFO') into l_org from dual;
754: IF l_debug_level > 0 THEN
755: oe_debug_pub.add( 'ORG='||L_ORG ) ;
756: END IF;
757:
758: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
759: INTO l_id

Line 781: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;

777: HZ_CUST_ACCT_RELATE WHERE
778: RELATED_CUST_ACCOUNT_ID = l_sold_to_org_id
779: and ship_to_flag = 'Y' and status='A');
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;
782: END IF;
783: END IF;
784:
785: CLOSE C1;

Line 787: oe_debug_pub.add( 'RETURNING FROM THE FUNCTION' ) ;

783: END IF;
784:
785: CLOSE C1;
786: IF l_debug_level > 0 THEN
787: oe_debug_pub.add( 'RETURNING FROM THE FUNCTION' ) ;
788: END IF;
789: RETURN l_id;
790:
791:

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

883: IS
884: l_code VARCHAR2(30);
885: l_lookup_type VARCHAR2(80) := 'FOB';
886: --
887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
888: --
889: BEGIN
890:
891: IF p_fob_point IS NULL

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

938: IS
939: l_code VARCHAR2(30);
940: l_lookup_type VARCHAR2(80) := 'FREIGHT_TERMS';
941: --
942: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
943: --
944: BEGIN
945:
946: IF p_freight_terms IS NULL

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

993: ) RETURN NUMBER
994: IS
995: l_id NUMBER;
996: --
997: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
998: --
999: BEGIN
1000:
1001: IF p_intermed_ship_to_contact IS NULL

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

1057: ) RETURN NUMBER
1058: IS
1059: l_id NUMBER;
1060: --
1061: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1062: --
1063: BEGIN
1064: l_id := Ship_To_Org
1065: ( p_ship_to_address1=>p_intermed_ship_to_address1

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

1114: IS
1115: l_id NUMBER;
1116: l_usage VARCHAR2(30);
1117: --
1118: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1119: --
1120: BEGIN
1121:
1122: IF p_invoice_to_contact IS NULL

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

1266: l_invoice_to_customer_id number;
1267: l_sold_to_org_id number;
1268: l_dummy number;
1269: --
1270: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1271: --
1272: BEGIN
1273:
1274: IF l_debug_level > 0 THEN

Line 1275: oe_debug_pub.add( 'INVOICE_TO_ORG VALUES ARE SOLD_TO_ORG_ID='||P_SOLD_TO_ORG_ID||' ADDRESS1='||P_INVOICE_TO_ADDRESS1||' ADDRESS4='||P_INVOICE_TO_ADDRESS4||' INVOICE_TO_CUST_ID='||P_INVOICE_TO_CUSTOMER_ID ) ;

1271: --
1272: BEGIN
1273:
1274: IF l_debug_level > 0 THEN
1275: oe_debug_pub.add( 'INVOICE_TO_ORG VALUES ARE SOLD_TO_ORG_ID='||P_SOLD_TO_ORG_ID||' ADDRESS1='||P_INVOICE_TO_ADDRESS1||' ADDRESS4='||P_INVOICE_TO_ADDRESS4||' INVOICE_TO_CUST_ID='||P_INVOICE_TO_CUSTOMER_ID ) ;
1276: END IF;
1277:
1278: IF nvl( p_invoice_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
1279: AND nvl( p_invoice_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 1290: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;

1286: END IF;
1287:
1288: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;
1291: END IF;
1292: l_sold_to_org_id := p_sold_to_org_id;
1293:
1294:

Line 1297: oe_debug_pub.add( 'INVOICE_TO_CUST_ID IS NULL' ) ;

1293:
1294:
1295: IF nvl(p_invoice_to_Customer_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
1296: IF l_debug_level > 0 THEN
1297: oe_debug_pub.add( 'INVOICE_TO_CUST_ID IS NULL' ) ;
1298: END IF;
1299: l_invoice_to_customer_id := null;
1300: ELSE
1301: l_invoice_to_customer_id := p_invoice_To_customer_id;

Line 1311: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND INVOICE_TO_CUSTOMER ARE NOT SAME' ) ;

1307: IF lcustomer_relations = 'N' AND
1308: nvl(l_invoice_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
1309:
1310: IF l_debug_level > 0 THEN
1311: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND INVOICE_TO_CUSTOMER ARE NOT SAME' ) ;
1312: END IF;
1313: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1314:
1315: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');

Line 1329: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;

1325: -- If the customer rel is on, then the customers should be related
1326: ELSIF lcustomer_relations = 'Y' AND
1327: nvl(l_invoice_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
1328: IF l_debug_level > 0 THEN
1329: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;
1330: END IF;
1331:
1332: BEGIN
1333: SELECT 1

Line 1346: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND INVOICE_TO_CUSTOMER ARE NOT RELATED' ) ;

1342: WHEN NO_DATA_FOUND THEN
1343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
1344:
1345: IF l_debug_level > 0 THEN
1346: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND INVOICE_TO_CUSTOMER ARE NOT RELATED' ) ;
1347: END IF;
1348: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
1349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org_id');
1350: OE_MSG_PUB.Add;

Line 1362: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;

1358:
1359: END IF; -- check for diff inv_cust_id
1360:
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;
1363: oe_debug_pub.add( 'L_INVOICE_TO_CUST_ID ='||L_INVOICE_TO_CUSTOMER_ID ) ;
1364: END IF;
1365:
1366: IF l_invoice_to_customer_id is not null then

Line 1363: oe_debug_pub.add( 'L_INVOICE_TO_CUST_ID ='||L_INVOICE_TO_CUSTOMER_ID ) ;

1359: END IF; -- check for diff inv_cust_id
1360:
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;
1363: oe_debug_pub.add( 'L_INVOICE_TO_CUST_ID ='||L_INVOICE_TO_CUSTOMER_ID ) ;
1364: END IF;
1365:
1366: IF l_invoice_to_customer_id is not null then
1367: l_sold_to_org_id := l_invoice_to_Customer_id;

Line 1369: oe_debug_pub.add( 'L_INVOICE_TO_CUSTOMER_ID IS NOT NULL' ) ;

1365:
1366: IF l_invoice_to_customer_id is not null then
1367: l_sold_to_org_id := l_invoice_to_Customer_id;
1368: IF l_debug_level > 0 THEN
1369: oe_debug_pub.add( 'L_INVOICE_TO_CUSTOMER_ID IS NOT NULL' ) ;
1370: END IF;
1371: END IF;
1372: IF l_debug_level > 0 THEN
1373: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;

Line 1373: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;

1369: oe_debug_pub.add( 'L_INVOICE_TO_CUSTOMER_ID IS NOT NULL' ) ;
1370: END IF;
1371: END IF;
1372: IF l_debug_level > 0 THEN
1373: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;
1374: END IF;
1375:
1376: -- the second condition is added to make sure that if the user passes the
1377: -- invoice_to_customer information , it should be used to validate the

Line 1384: oe_debug_pub.add( 'IF REL = N OR .. Y AND INV_CUST_ID NOT NULL' ) ;

1380: IF lcustomer_relations = 'N' OR
1381: (lcustomer_relations = 'Y' and l_invoice_to_customer_id is not null ) OR
1382: (lcustomer_relations = 'A' and l_invoice_to_customer_id is not null )THEN
1383: IF l_debug_level > 0 THEN
1384: oe_debug_pub.add( 'IF REL = N OR .. Y AND INV_CUST_ID NOT NULL' ) ;
1385: END IF;
1386:
1387: OPEN c_invoice_to_org_id(l_sold_to_org_id);
1388: FETCH c_invoice_to_org_id

Line 1419: oe_debug_pub.add( 'CUST REL = Y INV_CUST_ID='||L_INVOICE_TO_CUSTOMER_ID ) ;

1415:
1416: ELSIF lcustomer_relations = 'Y' THEN
1417:
1418: IF l_debug_level > 0 THEN
1419: oe_debug_pub.add( 'CUST REL = Y INV_CUST_ID='||L_INVOICE_TO_CUSTOMER_ID ) ;
1420: END IF;
1421: OPEN C1(l_sold_to_org_id);
1422: FETCH C1
1423: INTO l_id;

Line 1427: oe_debug_pub.add( 'FOUND' ) ;

1423: INTO l_id;
1424:
1425: IF C1%FOUND then
1426: IF l_debug_level > 0 THEN
1427: oe_debug_pub.add( 'FOUND' ) ;
1428: END IF;
1429: CLOSE C1;
1430: return l_id;
1431: ELSE

Line 1433: oe_debug_pub.add( 'NOT FOUND' ) ;

1429: CLOSE C1;
1430: return l_id;
1431: ELSE
1432: IF l_debug_level > 0 THEN
1433: oe_debug_pub.add( 'NOT FOUND' ) ;
1434: END IF;
1435: l_org :=mo_global.get_current_org_id ; --MOAC
1436: --select userenv('CLIENT_INFO') into l_org from dual;
1437: IF l_debug_level > 0 THEN

Line 1438: oe_debug_pub.add( 'ORG='||L_ORG ) ;

1434: END IF;
1435: l_org :=mo_global.get_current_org_id ; --MOAC
1436: --select userenv('CLIENT_INFO') into l_org from dual;
1437: IF l_debug_level > 0 THEN
1438: oe_debug_pub.add( 'ORG='||L_ORG ) ;
1439: END IF;
1440: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1441: INTO l_id
1442: FROM OE_INVOICE_TO_ORGS_V

Line 1463: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;

1459: HZ_CUST_ACCT_RELATE WHERE
1460: RELATED_CUST_ACCOUNT_ID = l_sold_to_org_id
1461: and bill_to_flag = 'Y' and status='A');
1462: IF l_debug_level > 0 THEN
1463: oe_debug_pub.add( 'AFTER SELECT FOUND='||L_ID ) ;
1464: END IF;
1465: END IF;
1466:
1467: CLOSE C1;

Line 1469: oe_debug_pub.add( 'RETURNING FROM THE FUNCTION' ) ;

1465: END IF;
1466:
1467: CLOSE C1;
1468: IF l_debug_level > 0 THEN
1469: oe_debug_pub.add( 'RETURNING FROM THE FUNCTION' ) ;
1470: END IF;
1471: RETURN l_id;
1472:
1473: null;

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

1564: ) RETURN NUMBER
1565: IS
1566: l_id NUMBER;
1567: --
1568: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1569: --
1570: BEGIN
1571:
1572: IF p_invoicing_rule IS NULL

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

1617: ) RETURN NUMBER
1618: IS
1619: l_id NUMBER;
1620: --
1621: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1622: --
1623: BEGIN
1624:
1625: IF p_order_source IS NULL

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

1675: ) RETURN NUMBER
1676: IS
1677: l_id NUMBER;
1678: --
1679: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1680: --
1681: BEGIN
1682:
1683: IF p_order_type IS NULL

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

1728: ) RETURN NUMBER
1729: IS
1730: l_id NUMBER;
1731: --
1732: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1733: --
1734: BEGIN
1735:
1736: IF p_payment_term IS NULL

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

1781: ) RETURN NUMBER
1782: IS
1783: l_id NUMBER;
1784: --
1785: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1786: --
1787: BEGIN
1788:
1789: IF p_price_list IS NULL

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

1836: IS
1837: l_code VARCHAR2(30);
1838: l_lookup_type VARCHAR2(80) := 'SHIPMENT_PRIORITY';
1839: --
1840: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1841: --
1842: BEGIN
1843:
1844: IF p_shipment_priority IS NULL

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

1895: ) RETURN NUMBER
1896: IS
1897: l_id NUMBER;
1898: --
1899: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1900: --
1901: BEGIN
1902:
1903: IF p_ship_from_address1 IS NULL

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

1972: IS
1973: l_id NUMBER;
1974: l_usage VARCHAR2(30);
1975: --
1976: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1977: --
1978: BEGIN
1979:
1980: IF p_ship_to_contact IS NULL

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

2033: ) RETURN NUMBER
2034: IS
2035: l_id NUMBER;
2036: --
2037: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2038: --
2039: BEGIN
2040:
2041: IF p_inventory_org IS NULL

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

2176: l_sold_to_org_id number;
2177: l_dummy number;
2178:
2179: --
2180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2181: --
2182: BEGIN
2183:
2184: IF l_debug_level > 0 THEN

Line 2185: oe_debug_pub.add( 'SHIP_TO_ADDRESS1='||P_SHIP_TO_ADDRESS1||' ADDRESS4='||P_SHIP_TO_ADDRESS4||' SHIP_TO_CUST_ID='||P_SHIP_TO_CUSTOMER_ID||' sold_to_org_id='||p_sold_to_org_id ) ;

2181: --
2182: BEGIN
2183:
2184: IF l_debug_level > 0 THEN
2185: oe_debug_pub.add( 'SHIP_TO_ADDRESS1='||P_SHIP_TO_ADDRESS1||' ADDRESS4='||P_SHIP_TO_ADDRESS4||' SHIP_TO_CUST_ID='||P_SHIP_TO_CUSTOMER_ID||' sold_to_org_id='||p_sold_to_org_id ) ;
2186: END IF;
2187:
2188: IF nvl( p_ship_to_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
2189: AND nvl( p_ship_to_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 2201: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;

2197:
2198:
2199: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2200: IF l_debug_level > 0 THEN
2201: oe_debug_pub.add( 'CUSTOMER RELATIONS='||LCUSTOMER_RELATIONS ) ;
2202: END IF;
2203: l_sold_to_org_id := p_sold_to_org_id;
2204:
2205:

Line 2208: oe_debug_pub.add( 'SHIP_TO_CUST_ID IS NULL' ) ;

2204:
2205:
2206: IF nvl(p_ship_to_Customer_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add( 'SHIP_TO_CUST_ID IS NULL' ) ;
2209: END IF;
2210: l_ship_to_customer_id := null;
2211: ELSE
2212: l_ship_to_customer_id := p_ship_To_customer_id;

Line 2222: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND SHIP_TO_CUSTOMER ARE NOT SAME' ) ;

2218: IF lcustomer_relations = 'N' AND
2219: nvl(l_ship_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
2220:
2221: IF l_debug_level > 0 THEN
2222: oe_debug_pub.add( 'CUSTOMER RELATION IS NOT ON , BUT THE SOLD_TO_ORG '|| 'AND SHIP_TO_CUSTOMER ARE NOT SAME' ) ;
2223: END IF;
2224: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2225:
2226: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');

Line 2240: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;

2236: -- If the customer rel is on, then the customers should be related
2237: ELSIF lcustomer_relations = 'Y' AND
2238: nvl(l_ship_to_customer_id,FND_API.G_MISS_NUM) <> nvl(p_sold_to_org_id,FND_API.G_MISS_NUM) then
2239: IF l_debug_level > 0 THEN
2240: oe_debug_pub.add( 'CUST REL IS ON , BUT DIFF CUST IDS' ) ;
2241: END IF;
2242:
2243: BEGIN
2244: SELECT 1

Line 2256: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND SHIP_TO_CUSTOMER ARE NOT RELATED' ) ;

2252: WHEN NO_DATA_FOUND THEN
2253: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
2254:
2255: IF l_debug_level > 0 THEN
2256: oe_debug_pub.add( 'CUSTOMER RELATION IS ON , BUT THE '|| 'SOLD_TO_ORG AND SHIP_TO_CUSTOMER ARE NOT RELATED' ) ;
2257: END IF;
2258: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
2259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org_id');
2260: OE_MSG_PUB.Add;

Line 2272: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;

2268:
2269: END IF; -- check for diff ship_cust_id
2270:
2271: IF l_debug_level > 0 THEN
2272: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;
2273: oe_debug_pub.add( 'L_SHIP_TO_CUST_ID ='||L_SHIP_TO_CUSTOMER_ID ) ;
2274: END IF;
2275:
2276: IF l_ship_to_customer_id is not null then

Line 2273: oe_debug_pub.add( 'L_SHIP_TO_CUST_ID ='||L_SHIP_TO_CUSTOMER_ID ) ;

2269: END IF; -- check for diff ship_cust_id
2270:
2271: IF l_debug_level > 0 THEN
2272: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID 0='||L_SOLD_TO_ORG_ID ) ;
2273: oe_debug_pub.add( 'L_SHIP_TO_CUST_ID ='||L_SHIP_TO_CUSTOMER_ID ) ;
2274: END IF;
2275:
2276: IF l_ship_to_customer_id is not null then
2277: l_sold_to_org_id := l_ship_to_Customer_id;

Line 2279: oe_debug_pub.add( 'L_SHIP_TO_CUSTOMER_ID IS NOT NULL' ) ;

2275:
2276: IF l_ship_to_customer_id is not null then
2277: l_sold_to_org_id := l_ship_to_Customer_id;
2278: IF l_debug_level > 0 THEN
2279: oe_debug_pub.add( 'L_SHIP_TO_CUSTOMER_ID IS NOT NULL' ) ;
2280: END IF;
2281: END IF;
2282: IF l_debug_level > 0 THEN
2283: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;

Line 2283: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;

2279: oe_debug_pub.add( 'L_SHIP_TO_CUSTOMER_ID IS NOT NULL' ) ;
2280: END IF;
2281: END IF;
2282: IF l_debug_level > 0 THEN
2283: oe_debug_pub.add( 'L_SOLD_TO_ORG_ID ='||L_SOLD_TO_ORG_ID ) ;
2284: END IF;
2285:
2286: -- the second condition is added to make sure that if the user passes the
2287: -- ship_to_customer information , it should be used to validate the

Line 2294: oe_debug_pub.add( 'IF REL = N OR .. Y AND INV_CUST_ID NOT NULL' ) ;

2290: IF lcustomer_relations = 'N' OR
2291: (lcustomer_relations = 'Y' and l_ship_to_customer_id is not null ) OR
2292: (lcustomer_relations = 'A' and l_ship_to_customer_id is not null )THEN
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add( 'IF REL = N OR .. Y AND INV_CUST_ID NOT NULL' ) ;
2295: END IF;
2296:
2297: OPEN c_ship_to_org_id(l_sold_to_org_id);
2298: FETCH c_ship_to_org_id

Line 2328: oe_debug_pub.add( 'CUST REL = Y SHIP_CUST_ID='||L_SHIP_TO_CUSTOMER_ID ) ;

2324: RETURN l_id;
2325:
2326: ELSIF lcustomer_relations = 'Y' THEN
2327: IF l_debug_level > 0 THEN
2328: oe_debug_pub.add( 'CUST REL = Y SHIP_CUST_ID='||L_SHIP_TO_CUSTOMER_ID ) ;
2329: END IF;
2330: OPEN C1(l_sold_To_org_id);
2331: FETCH C1
2332: INTO l_id;

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

2454: ) RETURN NUMBER
2455: IS
2456: l_id NUMBER;
2457: --
2458: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2459: --
2460: BEGIN
2461:
2462: IF p_sold_to_contact IS NULL

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

2512: ) RETURN NUMBER IS
2513:
2514: l_id NUMBER;
2515: --
2516: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2517: --
2518: BEGIN
2519:
2520: IF l_debug_level > 0 THEN

Line 2521: oe_debug_pub.add( 'SITE CUSTOMER = '||P_SITE_CUSTOMER|| ' NUMBER='||P_SITE_CUSTOMER_NUMBER|| ' TYPE='||P_TYPE ) ;

2517: --
2518: BEGIN
2519:
2520: IF l_debug_level > 0 THEN
2521: oe_debug_pub.add( 'SITE CUSTOMER = '||P_SITE_CUSTOMER|| ' NUMBER='||P_SITE_CUSTOMER_NUMBER|| ' TYPE='||P_TYPE ) ;
2522: END IF;
2523:
2524: IF nvl(p_site_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
2525: AND nvl(p_site_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 2528: oe_debug_pub.add( 'SITE CUSTOMER RETURNING NULL' ) ;

2524: IF nvl(p_site_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char
2525: AND nvl(p_site_customer_number,fnd_api.g_miss_char) = fnd_api.g_miss_char
2526: THEN
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( 'SITE CUSTOMER RETURNING NULL' ) ;
2529: END IF;
2530: RETURN NULL;
2531: END IF;
2532:

Line 2536: oe_debug_pub.add( 'SITE CUSTOMER SELECTING CUST NUM='||P_SITE_CUSTOMER_NUMBER ) ;

2532:
2533: IF nvl(p_site_customer_number,fnd_api.g_miss_char) <> fnd_api.g_miss_char THEN
2534:
2535: IF l_debug_level > 0 THEN
2536: oe_debug_pub.add( 'SITE CUSTOMER SELECTING CUST NUM='||P_SITE_CUSTOMER_NUMBER ) ;
2537: END IF;
2538:
2539:
2540: SELECT ORGANIZATION_ID

Line 2547: oe_debug_pub.add( 'AFTER SELECTING SITE_CUSTOMER' ) ;

2543: WHERE CUSTOMER_NUMBER = p_site_customer_number
2544: AND status='A'; -- added for bug 3651505
2545:
2546: IF l_debug_level > 0 THEN
2547: oe_debug_pub.add( 'AFTER SELECTING SITE_CUSTOMER' ) ;
2548: END IF;
2549:
2550: ELSE
2551:

Line 2553: oe_debug_pub.add( 'SITE CUSTOMER SELECTING CUST='||P_SITE_CUSTOMER ) ;

2549:
2550: ELSE
2551:
2552: IF l_debug_level > 0 THEN
2553: oe_debug_pub.add( 'SITE CUSTOMER SELECTING CUST='||P_SITE_CUSTOMER ) ;
2554: END IF;
2555:
2556: --Bug 3631191
2557: /* SELECT ORGANIZATION_ID

Line 2570: oe_debug_pub.add( 'AFTER SELECTING SITE_CUSTOMER' ) ;

2566: AND PARTY.PARTY_NAME = p_site_customer
2567: AND CUST_ACCT.status ='A'; -- added for bug 3651505
2568:
2569: IF l_debug_level > 0 THEN
2570: oe_debug_pub.add( 'AFTER SELECTING SITE_CUSTOMER' ) ;
2571: END IF;
2572:
2573: END IF;
2574:

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

2613: ) RETURN NUMBER
2614: IS
2615: l_id NUMBER;
2616: --
2617: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2618: --
2619: BEGIN
2620:
2621: IF nvl(p_sold_to_org,fnd_api.g_miss_char) = fnd_api.g_miss_char

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

2695: l_code VARCHAR2(30);
2696: -- eBTax Changes
2697: l_lookup_type VARCHAR2(80) := 'ZX_EXEMPTION_CONTROL';
2698: --
2699: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2700: --
2701: BEGIN
2702:
2703: IF p_tax_exempt IS NULL

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

2751: l_code VARCHAR2(30);
2752: -- eBTax changes
2753: l_lookup_type VARCHAR2(80) := 'ZX_EXEMPTION_REASON_CODE';
2754: --
2755: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2756: --
2757: BEGIN
2758:
2759: IF p_tax_exempt_reason IS NULL

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

2806: IS
2807: l_code VARCHAR2(30);
2808: l_lookup_type VARCHAR2(80) := 'TAX_POINT_TYPE';
2809: --
2810: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2811: --
2812: BEGIN
2813:
2814: IF p_tax_point IS NULL

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

2860: ) RETURN NUMBER
2861: IS
2862: l_id NUMBER;
2863: --
2864: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2865: --
2866: BEGIN
2867:
2868: IF p_discount IS NULL

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

2911: ) RETURN NUMBER
2912: IS
2913: l_id NUMBER;
2914: --
2915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2916: --
2917: BEGIN
2918:
2919: IF p_sales_credit_type IS NULL

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

2964: ) RETURN NUMBER
2965: IS
2966: l_id NUMBER;
2967: --
2968: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2969: --
2970: BEGIN
2971:
2972: IF p_salesrep IS NULL

Line 2987: oe_debug_pub.add(' Conversion returns to many rows, need to consider end date active');

2983:
2984: EXCEPTION
2985:
2986: WHEN TOO_MANY_ROWS THEN
2987: oe_debug_pub.add(' Conversion returns to many rows, need to consider end date active');
2988:
2989: BEGIN
2990: SELECT SALESREP_ID
2991: INTO l_id

Line 3002: oe_debug_pub.add('Multiple active salesrep with same name');

2998: WHEN TOO_MANY_ROWS THEN
2999: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');
3001: OE_MSG_PUB.Add;
3002: oe_debug_pub.add('Multiple active salesrep with same name');
3003: RETURN FND_API.G_MISS_NUM;
3004:
3005: END;
3006:

Line 3015: oe_debug_pub.add(' Value to ID conversion no data found on salesrep_id');

3011:
3012: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3013: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep_id');
3014: OE_MSG_PUB.Add;
3015: oe_debug_pub.add(' Value to ID conversion no data found on salesrep_id');
3016:
3017: END IF;
3018:
3019: RETURN FND_API.G_MISS_NUM;

Line 3031: oe_debug_pub.add(' Value to ID conversion--salesrep_id:'||SQLERRM);

3027: , 'Salesrep'
3028: );
3029: END IF;
3030:
3031: oe_debug_pub.add(' Value to ID conversion--salesrep_id:'||SQLERRM);
3032:
3033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3034:
3035: END Salesrep;

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

3041: ) RETURN VARCHAR2
3042: IS
3043: l_code VARCHAR2(30);
3044: --
3045: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3046: --
3047: BEGIN
3048:
3049: IF p_demand_bucket_type IS NULL

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

3094: ) RETURN NUMBER
3095: IS
3096: l_id NUMBER;
3097: --
3098: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3099: --
3100: BEGIN
3101:
3102: IF p_inventory_item IS NULL

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

3147: ) RETURN VARCHAR2
3148: IS
3149: l_code VARCHAR2(30);
3150: --
3151: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3152: --
3153: BEGIN
3154:
3155: IF p_item_type IS NULL

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

3200: ) RETURN NUMBER
3201: IS
3202: l_id NUMBER;
3203: --
3204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3205: --
3206: BEGIN
3207:
3208: IF p_line_type IS NULL

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

3253: ) RETURN NUMBER
3254: IS
3255: l_id NUMBER;
3256: --
3257: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3258: --
3259: BEGIN
3260:
3261: IF p_project IS NULL

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

3306: ) RETURN VARCHAR2
3307: IS
3308: l_code VARCHAR2(30);
3309: --
3310: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3311: --
3312: BEGIN
3313:
3314: IF p_rla_schedule_type IS NULL

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

3359: ) RETURN NUMBER
3360: IS
3361: l_id NUMBER;
3362: --
3363: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3364: --
3365: BEGIN
3366:
3367: IF p_task IS NULL

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

3410: ) RETURN VARCHAR2
3411: IS
3412: l_code VARCHAR2(15);
3413: --
3414: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3415: --
3416: BEGIN
3417:
3418: IF p_over_ship_reason IS NULL

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

3462: IS
3463: l_code VARCHAR2(15);
3464: l_lookup_type VARCHAR2(80) :='CREDIT_MEMO_REASON';
3465: --
3466: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3467: --
3468: BEGIN
3469:
3470: IF p_return_reason IS NULL

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

3514: ) RETURN NUMBER
3515: IS
3516: l_id NUMBER;
3517: --
3518: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3519: --
3520: BEGIN
3521:
3522: IF p_veh_cus_item_cum_Key IS NULL

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

3568: IS
3569: l_code VARCHAR2(30);
3570: l_lookup_type VARCHAR2(80) := 'PAYMENT TYPE';
3571: --
3572: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3573: --
3574: l_org_id number := NULL;
3575:
3576: BEGIN

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

3658: IS
3659: l_code VARCHAR2(30);
3660: l_lookup_type VARCHAR2(80) := 'CREDIT_CARD';
3661: --
3662: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3663: --
3664: BEGIN
3665:
3666: IF p_credit_card IS NULL

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

3710: ) RETURN NUMBER
3711: IS
3712: l_id NUMBER;
3713: --
3714: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3715: --
3716: BEGIN
3717:
3718: -- bug 1851006

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

3767: ) RETURN VARCHAR2
3768: IS
3769: l_code VARCHAR2(15);
3770: --
3771: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3772: --
3773: BEGIN
3774:
3775: IF p_currency IS NULL

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

3821: ) RETURN VARCHAR2
3822: IS
3823: l_code VARCHAR2(15);
3824: --
3825: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3826: --
3827: BEGIN
3828:
3829: IF p_Agreement_Contact IS NULL

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

3874: ) RETURN VARCHAR2
3875: IS
3876: l_code VARCHAR2(15);
3877: --
3878: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3879: --
3880: BEGIN
3881:
3882: IF p_Agreement_Type IS NULL

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

3927: ) RETURN VARCHAR2
3928: IS
3929: l_code VARCHAR2(15);
3930: --
3931: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3932: --
3933: BEGIN
3934:
3935: IF p_Customer IS NULL

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

3980: ) RETURN VARCHAR2
3981: IS
3982: l_code VARCHAR2(15);
3983: --
3984: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3985: --
3986: BEGIN
3987:
3988: IF p_Invoice_Contact IS NULL

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

4033: ) RETURN VARCHAR2
4034: IS
4035: l_code VARCHAR2(15);
4036: --
4037: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4038: --
4039: BEGIN
4040:
4041: IF p_Invoice_To_Site_Use IS NULL

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

4086: ) RETURN VARCHAR2
4087: IS
4088: l_code VARCHAR2(15);
4089: --
4090: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4091: --
4092: BEGIN
4093:
4094: IF p_Override_Arule IS NULL

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

4139: ) RETURN VARCHAR2
4140: IS
4141: l_code VARCHAR2(15);
4142: --
4143: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4144: --
4145: BEGIN
4146:
4147: IF p_Override_Irule IS NULL

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

4192: ) RETURN VARCHAR2
4193: IS
4194: l_code VARCHAR2(15);
4195: --
4196: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4197: --
4198: BEGIN
4199:
4200: IF p_Revision_Reason IS NULL

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

4246: IS
4247: l_code VARCHAR2(80);
4248:
4249: --
4250: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4251: --
4252: BEGIN
4253:
4254: IF p_Ship_Method IS NULL

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

4300: ) RETURN VARCHAR2
4301: IS
4302: l_code VARCHAR2(15);
4303: --
4304: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4305: --
4306: BEGIN
4307:
4308: IF p_Term IS NULL

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

4353: ) RETURN NUMBER
4354: IS
4355: l_id NUMBER;
4356: --
4357: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4358: --
4359: BEGIN
4360:
4361: IF p_secondary_price_list IS NULL

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

4406: ) RETURN NUMBER
4407: IS
4408: l_id NUMBER;
4409: --
4410: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4411: --
4412: BEGIN
4413:
4414: IF p_terms IS NULL

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

4459: ) RETURN VARCHAR2
4460: IS
4461: l_code VARCHAR2(1);
4462: --
4463: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4464: --
4465: BEGIN
4466:
4467: IF p_automatic_discount IS NULL

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

4512: ) RETURN VARCHAR2
4513: IS
4514: l_code VARCHAR2(1);
4515: --
4516: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4517: --
4518: BEGIN
4519:
4520: IF p_discount_lines IS NULL

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

4565: ) RETURN VARCHAR2
4566: IS
4567: l_code VARCHAR2(30);
4568: --
4569: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4570: --
4571: BEGIN
4572:
4573: IF p_discount_type IS NULL

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

4618: ) RETURN VARCHAR2
4619: IS
4620: l_code VARCHAR2(1);
4621: --
4622: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4623: --
4624: BEGIN
4625:
4626: IF p_manual_discount IS NULL

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

4671: ) RETURN VARCHAR2
4672: IS
4673: l_code VARCHAR2(1);
4674: --
4675: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4676: --
4677: BEGIN
4678:
4679: IF p_override_allowed IS NULL

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

4724: ) RETURN VARCHAR2
4725: IS
4726: l_code VARCHAR2(30);
4727: --
4728: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4729: --
4730: BEGIN
4731:
4732: IF p_prorate IS NULL

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

4778: ) RETURN VARCHAR2
4779: IS
4780: l_code VARCHAR2(4);
4781: --
4782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4783: --
4784: BEGIN
4785:
4786: IF p_method IS NULL

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

4831: ) RETURN NUMBER
4832: IS
4833: l_id NUMBER;
4834: --
4835: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4836: --
4837: BEGIN
4838:
4839: IF p_price_list_line IS NULL

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

4884: ) RETURN NUMBER
4885: IS
4886: l_id NUMBER;
4887: --
4888: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4889: --
4890: BEGIN
4891:
4892: IF p_pricing_rule IS NULL

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

4937: ) RETURN VARCHAR2
4938: IS
4939: l_code VARCHAR2(1);
4940: --
4941: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4942: --
4943: BEGIN
4944:
4945: IF p_reprice IS NULL

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

4990: ) RETURN VARCHAR2
4991: IS
4992: l_code VARCHAR2(3);
4993: --
4994: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4995: --
4996: BEGIN
4997:
4998: IF p_unit IS NULL

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

5043: ) RETURN VARCHAR2
5044: IS
5045: l_code VARCHAR2(30);
5046: --
5047: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5048: --
5049: BEGIN
5050:
5051: IF p_customer_class IS NULL

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

5096: ) RETURN NUMBER
5097: IS
5098: l_id NUMBER;
5099: --
5100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5101: --
5102: BEGIN
5103:
5104: IF p_discount_customer IS NULL

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

5149: ) RETURN NUMBER
5150: IS
5151: l_id NUMBER;
5152: --
5153: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5154: --
5155: BEGIN
5156:
5157: IF p_site_use IS NULL

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

5202: ) RETURN NUMBER
5203: IS
5204: l_id NUMBER;
5205: --
5206: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5207: --
5208: BEGIN
5209:
5210: IF p_entity IS NULL

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

5255: ) RETURN VARCHAR2
5256: IS
5257: l_code VARCHAR2(30);
5258: --
5259: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5260: --
5261: BEGIN
5262:
5263: IF p_method_type IS NULL

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

5310: ) RETURN NUMBER
5311: IS
5312: l_id NUMBER;
5313: --
5314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5315: --
5316: BEGIN
5317:
5318: IF p_lot_serial IS NULL

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

5363: ) RETURN VARCHAR2
5364: IS
5365: l_code VARCHAR2(1);
5366: --
5367: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5368: --
5369: BEGIN
5370:
5371: IF p_appear_on_ack IS NULL

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

5416: ) RETURN VARCHAR2
5417: IS
5418: l_code VARCHAR2(1);
5419: --
5420: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5421: --
5422: BEGIN
5423:
5424: IF p_appear_on_invoice IS NULL

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

5469: ) RETURN NUMBER
5470: IS
5471: l_id NUMBER;
5472: --
5473: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5474: --
5475: BEGIN
5476:
5477: IF p_charge IS NULL

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

5522: ) RETURN NUMBER
5523: IS
5524: l_id NUMBER;
5525: --
5526: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5527: --
5528: BEGIN
5529:
5530: IF p_charge_type IS NULL

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

5575: ) RETURN VARCHAR2
5576: IS
5577: l_code VARCHAR2(1);
5578: --
5579: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5580: --
5581: BEGIN
5582:
5583: IF p_cost_or_charge IS NULL

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

5628: ) RETURN NUMBER
5629: IS
5630: l_id NUMBER;
5631: --
5632: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5633: --
5634: BEGIN
5635:
5636: IF p_departure IS NULL

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

5681: ) RETURN VARCHAR2
5682: IS
5683: l_code VARCHAR2(1);
5684: --
5685: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5686: --
5687: BEGIN
5688:
5689: IF p_estimated IS NULL

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

5734: ) RETURN VARCHAR2
5735: IS
5736: l_code VARCHAR2(1);
5737: --
5738: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5739: --
5740: BEGIN
5741:
5742: IF p_invoiced IS NULL

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

5787: ) RETURN NUMBER
5788: IS
5789: l_id NUMBER;
5790: --
5791: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5792: --
5793: BEGIN
5794:
5795: IF p_parent_charge IS NULL

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

5840: ) RETURN VARCHAR2
5841: IS
5842: l_code VARCHAR2(1);
5843: --
5844: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5845: --
5846: BEGIN
5847:
5848: IF p_returnable IS NULL

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

5893: ) RETURN VARCHAR2
5894: IS
5895: l_code VARCHAR2(30);
5896: --
5897: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5898: --
5899: BEGIN
5900:
5901: IF p_tax_group IS NULL

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

5945: ) RETURN VARCHAR2
5946: IS
5947: l_code VARCHAR2(30);
5948: --
5949: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5950: --
5951: BEGIN
5952:
5953: IF p_flow_status IS NULL

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

6000: IS
6001: l_code VARCHAR2(30);
6002: l_ship_from_org_id NUMBER;
6003: --
6004: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6005: --
6006: BEGIN
6007:
6008: RETURN NULL;

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

6049: IS
6050: l_code VARCHAR2(30);
6051: l_lookup_type VARCHAR2(80) := 'SALES_CHANNEL';
6052: --
6053: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6054: --
6055: BEGIN
6056:
6057: IF p_sales_channel IS NULL

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

6110: ) RETURN NUMBER
6111: IS
6112: l_id NUMBER;
6113: --
6114: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6115: --
6116: BEGIN
6117:
6118: IF l_debug_level > 0 THEN

Line 6119: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS1='||P_SOLD_TO_LOCATION_ADDRESS1||' ADDRESS4='||P_SOLD_TO_LOCATION_ADDRESS4||' sold_to_org_id='||p_sold_to_org_id ) ;

6115: --
6116: BEGIN
6117:
6118: IF l_debug_level > 0 THEN
6119: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS1='||P_SOLD_TO_LOCATION_ADDRESS1||' ADDRESS4='||P_SOLD_TO_LOCATION_ADDRESS4||' sold_to_org_id='||p_sold_to_org_id ) ;
6120: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);
6121: END IF;
6122:
6123:

Line 6120: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);

6116: BEGIN
6117:
6118: IF l_debug_level > 0 THEN
6119: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS1='||P_SOLD_TO_LOCATION_ADDRESS1||' ADDRESS4='||P_SOLD_TO_LOCATION_ADDRESS4||' sold_to_org_id='||p_sold_to_org_id ) ;
6120: oe_debug_pub.add( 'SOLD_TO_LOCATION_ADDRESS2='||P_SOLD_TO_LOCATION_ADDRESS2||' ADDRESS3='||P_SOLD_TO_LOCATION_ADDRESS3);
6121: END IF;
6122:
6123:
6124: IF nvl( p_sold_to_location_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 6167: oe_debug_pub.add( 'jerome- sold to site use id: ' || l_id);

6163: AND ACCT_SITE.CUST_ACCOUNT_ID = p_sold_to_org_id;
6164:
6165:
6166: IF l_debug_level > 0 THEN
6167: oe_debug_pub.add( 'jerome- sold to site use id: ' || l_id);
6168: END IF;
6169:
6170: RETURN l_id;
6171:

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

6305: IS
6306:
6307: l_id NUMBER;
6308: --
6309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6310:
6311: BEGIN
6312:
6313: IF nvl(p_end_customer,fnd_api.g_miss_char) = fnd_api.g_miss_char

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

6369: , p_end_customer_id IN NUMBER
6370: ) RETURN NUMBER IS
6371:
6372: l_id NUMBER;
6373: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6374: BEGIN
6375:
6376: IF p_end_customer_contact IS NULL
6377: THEN

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

6492:
6493: l_id number;
6494:
6495: --
6496: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6497: BEGIN
6498:
6499: IF l_debug_level > 0 THEN
6500: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);

Line 6500: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);

6496: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6497: BEGIN
6498:
6499: IF l_debug_level > 0 THEN
6500: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);
6501: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);
6502: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
6503: END IF;
6504:

Line 6501: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);

6497: BEGIN
6498:
6499: IF l_debug_level > 0 THEN
6500: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);
6501: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);
6502: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
6503: END IF;
6504:
6505: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 6502: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );

6498:
6499: IF l_debug_level > 0 THEN
6500: oe_debug_pub.add(' end customer site address1: '||p_end_customer_site_address1);
6501: oe_debug_pub.add(' address4: '||p_end_customer_site_address4);
6502: oe_debug_pub.add(' end_customer_id: '||p_end_customer_id );
6503: END IF;
6504:
6505: IF nvl( p_end_customer_site_address1,fnd_api.g_miss_char) = fnd_api.g_miss_char
6506: AND nvl( p_end_customer_site_address2,fnd_api.g_miss_char) = fnd_api.g_miss_char

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

6678: l_lookup_type1 VARCHAR2(80) :='ITEM_OWNER';
6679: -- l_lookup_type2 VARCHAR2(80) :='ONT_INSTALL_BASE';
6680:
6681: --
6682: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6683: --
6684: BEGIN
6685:
6686: IF p_ib_owner IS NULL

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

6733: l_lookup_type1 VARCHAR2(80) :='ITEM_INSTALL_LOCATION';
6734: l_lookup_type2 VARCHAR2(80) :='ONT_INSTALL_BASE';
6735:
6736: --
6737: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6738: --
6739: BEGIN
6740: oe_Debug_pub.add('entering v to id of installed at location');
6741: IF p_ib_installed_at_location IS NULL

Line 6740: oe_Debug_pub.add('entering v to id of installed at location');

6736: --
6737: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6738: --
6739: BEGIN
6740: oe_Debug_pub.add('entering v to id of installed at location');
6741: IF p_ib_installed_at_location IS NULL
6742: THEN
6743: RETURN NULL;
6744: END IF;

Line 6751: oe_Debug_pub.add('ib inst code'||l_code);

6747: INTO l_code
6748: FROM OE_LOOKUPS
6749: WHERE MEANING = p_ib_installed_at_location
6750: AND LOOKUP_TYPE = l_lookup_type1; -- or LOOKUP_TYPE = l_lookup_type1);
6751: oe_Debug_pub.add('ib inst code'||l_code);
6752: RETURN l_code;
6753:
6754: EXCEPTION
6755:

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

6788: l_lookup_type1 VARCHAR2(80) :='ITEM_CURRENT_LOCATION';
6789: l_lookup_type2 VARCHAR2(80) :='ONT_INSTALL_BASE';
6790:
6791: --
6792: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6793: --
6794: BEGIN
6795:
6796: IF p_ib_current_location IS NULL

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

6851: ) RETURN NUMBER
6852: IS
6853:
6854: l_org_id NUMBER;
6855: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6856:
6857: BEGIN
6858:
6859: IF p_operating_unit IS NULL