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

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

15: PROCEDURE Pre_Process(p_batch_id IN NUMBER)
16: AS
17: l_msg_text VARCHAR2(2000);
18: --
19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20: --
21: BEGIN
22:
23: l_msg_text := FND_MESSAGE.GET_STRING('ONT','OE_BULK_REQD_HDR_ATTRIBUTES');

Line 53: oe_debug_pub.add( 'THE ERROR COUNT IS SET ???' ) ;

49: IF g_error_count = 0 THEN
50: IF SQL%ROWCOUNT > 0 THEN
51: g_error_count := 1;
52: IF l_debug_level > 0 THEN
53: oe_debug_pub.add( 'THE ERROR COUNT IS SET ???' ) ;
54: END IF;
55: END IF;
56: END IF;
57:

Line 92: oe_debug_pub.add( 'THE ERROR COUNT IS SET now' ) ;

88: IF g_error_count = 0 THEN
89: IF SQL%ROWCOUNT > 0 THEN
90: g_error_count := 1;
91: IF l_debug_level > 0 THEN
92: oe_debug_pub.add( 'THE ERROR COUNT IS SET now' ) ;
93: END IF;
94: END IF;
95: END IF;
96:

Line 135: oe_debug_pub.add( 'THE ERROR COUNT IS SET 1' ) ;

131: IF g_error_count = 0 THEN
132: IF SQL%ROWCOUNT > 0 THEN
133: g_error_count := 1;
134: IF l_debug_level > 0 THEN
135: oe_debug_pub.add( 'THE ERROR COUNT IS SET 1' ) ;
136: END IF;
137: END IF;
138: END IF;
139: */

Line 173: oe_debug_pub.add( 'THE ERROR COUNT IS SET 2' ) ;

169: IF g_error_count = 0 THEN
170: IF SQL%ROWCOUNT > 0 THEN
171: g_error_count := 1;
172: IF l_debug_level > 0 THEN
173: oe_debug_pub.add( 'THE ERROR COUNT IS SET 2' ) ;
174: END IF;
175: END IF;
176: END IF;
177: -- comment out with config support change

Line 216: oe_debug_pub.add( 'THE ERROR COUNT IS SET 3' ) ;

212: IF g_error_count = 0 THEN
213: IF SQL%ROWCOUNT > 0 THEN
214: g_error_count := 1;
215: IF l_debug_level > 0 THEN
216: oe_debug_pub.add( 'THE ERROR COUNT IS SET 3' ) ;
217: END IF;
218: END IF;
219: END IF;
220: */

Line 255: oe_debug_pub.add( 'THE ERROR COUNT IS SET 4' ) ;

251: IF g_error_count = 0 THEN
252: IF SQL%ROWCOUNT > 0 THEN
253: g_error_count := 1;
254: IF l_debug_level > 0 THEN
255: oe_debug_pub.add( 'THE ERROR COUNT IS SET 4' ) ;
256: END IF;
257: END IF;
258: END IF;
259:

Line 261: oe_debug_pub.add( 'EXIT PRE_PROCESS , G_ERROR_COUNT: '||G_ERROR_COUNT ) ;

257: END IF;
258: END IF;
259:
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add( 'EXIT PRE_PROCESS , G_ERROR_COUNT: '||G_ERROR_COUNT ) ;
262: END IF;
263: EXCEPTION
264: WHEN OTHERS THEN
265: IF l_debug_level > 0 THEN

Line 266: oe_debug_pub.add( 'OTHERS ERROR , PRE_PROCESS' ) ;

262: END IF;
263: EXCEPTION
264: WHEN OTHERS THEN
265: IF l_debug_level > 0 THEN
266: oe_debug_pub.add( 'OTHERS ERROR , PRE_PROCESS' ) ;
267: END IF;
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
270: END IF;

Line 269: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

265: IF l_debug_level > 0 THEN
266: oe_debug_pub.add( 'OTHERS ERROR , PRE_PROCESS' ) ;
267: END IF;
268: IF l_debug_level > 0 THEN
269: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
270: END IF;
271: OE_BULK_MSG_PUB.ADD_Exc_Msg
272: ( G_PKG_NAME
273: , 'Pre_Process'

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

292: l_msg_data VARCHAR2(2000);
293: l_count NUMBER;
294: l_org_id NUMBER;
295: --
296: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
297: --
298: BEGIN
299:
300: -- Also, include calculate price attribute validation

Line 367: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

363: IF g_error_count = 0 THEN
364: IF SQL%ROWCOUNT > 0 THEN
365: g_error_count := 1;
366: IF l_debug_level > 0 THEN
367: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
368: END IF;
369: END IF;
370: END IF;
371:

Line 405: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

401: IF g_error_count = 0 THEN
402: IF SQL%ROWCOUNT > 0 THEN
403: g_error_count := 1;
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
406: END IF;
407: END IF;
408: END IF;
409:

Line 440: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

436: IF g_error_count = 0 THEN
437: IF SQL%ROWCOUNT > 0 THEN
438: g_error_count := 1;
439: IF l_debug_level > 0 THEN
440: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
441: END IF;
442: END IF;
443: END IF;
444:

Line 498: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

494: IF g_error_count = 0 THEN
495: IF SQL%ROWCOUNT > 0 THEN
496: g_error_count := 1;
497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
499: END IF;
500: END IF;
501: END IF;
502:

Line 556: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

552: IF g_error_count = 0 THEN
553: IF SQL%ROWCOUNT > 0 THEN
554: g_error_count := 1;
555: IF l_debug_level > 0 THEN
556: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
557: END IF;
558: END IF;
559: END IF;
560:

Line 597: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

593: IF g_error_count = 0 THEN
594: IF SQL%ROWCOUNT > 0 THEN
595: g_error_count := 1;
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
598: END IF;
599: END IF;
600: END IF;
601:

Line 638: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

634: IF g_error_count = 0 THEN
635: IF SQL%ROWCOUNT > 0 THEN
636: g_error_count := 1;
637: IF l_debug_level > 0 THEN
638: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
639: END IF;
640: END IF;
641: END IF;
642:

Line 679: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

675: IF g_error_count = 0 THEN
676: IF SQL%ROWCOUNT > 0 THEN
677: g_error_count := 1;
678: IF l_debug_level > 0 THEN
679: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
680: END IF;
681: END IF;
682: END IF;
683:

Line 719: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

715: IF g_error_count = 0 THEN
716: IF SQL%ROWCOUNT > 0 THEN
717: g_error_count := 1;
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
720: END IF;
721: END IF;
722: END IF;
723:

Line 757: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

753: IF g_error_count = 0 THEN
754: IF SQL%ROWCOUNT > 0 THEN
755: g_error_count := 1;
756: IF l_debug_level > 0 THEN
757: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
758: END IF;
759: END IF;
760: END IF;
761:

Line 795: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

791: IF g_error_count = 0 THEN
792: IF SQL%ROWCOUNT > 0 THEN
793: g_error_count := 1;
794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
796: END IF;
797: END IF;
798: END IF;
799:

Line 835: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

831: IF g_error_count = 0 THEN
832: IF SQL%ROWCOUNT > 0 THEN
833: g_error_count := 1;
834: IF l_debug_level > 0 THEN
835: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
836: END IF;
837: END IF;
838: END IF;
839:

Line 874: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

870: IF g_error_count = 0 THEN
871: IF SQL%ROWCOUNT > 0 THEN
872: g_error_count := 1;
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
875: END IF;
876: END IF;
877: END IF;
878:

Line 912: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

908: IF g_error_count = 0 THEN
909: IF SQL%ROWCOUNT > 0 THEN
910: g_error_count := 1;
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
913: END IF;
914: END IF;
915: END IF;
916:

Line 951: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

947: IF g_error_count = 0 THEN
948: IF SQL%ROWCOUNT > 0 THEN
949: g_error_count := 1;
950: IF l_debug_level > 0 THEN
951: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
952: END IF;
953: END IF;
954: END IF;
955:

Line 989: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

985: IF g_error_count = 0 THEN
986: IF SQL%ROWCOUNT > 0 THEN
987: g_error_count := 1;
988: IF l_debug_level > 0 THEN
989: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
990: END IF;
991: END IF;
992: END IF;
993:

Line 1029: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1025: IF g_error_count = 0 THEN
1026: IF SQL%ROWCOUNT > 0 THEN
1027: g_error_count := 1;
1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1030: END IF;
1031: END IF;
1032: END IF;
1033:

Line 1069: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1065: IF g_error_count = 0 THEN
1066: IF SQL%ROWCOUNT > 0 THEN
1067: g_error_count := 1;
1068: IF l_debug_level > 0 THEN
1069: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1070: END IF;
1071: END IF;
1072: END IF;
1073:

Line 1107: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1103: IF g_error_count = 0 THEN
1104: IF SQL%ROWCOUNT > 0 THEN
1105: g_error_count := 1;
1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1108: END IF;
1109: END IF;
1110: END IF;
1111:

Line 1144: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1140: IF g_error_count = 0 THEN
1141: IF SQL%ROWCOUNT > 0 THEN
1142: g_error_count := 1;
1143: IF l_debug_level > 0 THEN
1144: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1145: END IF;
1146: END IF;
1147: END IF;
1148:

Line 1184: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1180: IF g_error_count = 0 THEN
1181: IF SQL%ROWCOUNT > 0 THEN
1182: g_error_count := 1;
1183: IF l_debug_level > 0 THEN
1184: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1185: END IF;
1186: END IF;
1187: END IF;
1188:

Line 1223: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1219: IF g_error_count = 0 THEN
1220: IF SQL%ROWCOUNT > 0 THEN
1221: g_error_count := 1;
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1224: END IF;
1225: END IF;
1226: END IF;
1227:

Line 1264: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1260: IF g_error_count = 0 THEN
1261: IF SQL%ROWCOUNT > 0 THEN
1262: g_error_count := 1;
1263: IF l_debug_level > 0 THEN
1264: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1265: END IF;
1266: END IF;
1267: END IF;
1268:

Line 1304: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1300: IF g_error_count = 0 THEN
1301: IF SQL%ROWCOUNT > 0 THEN
1302: g_error_count := 1;
1303: IF l_debug_level > 0 THEN
1304: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1305: END IF;
1306: END IF;
1307: END IF;
1308:

Line 1344: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1340: IF g_error_count = 0 THEN
1341: IF SQL%ROWCOUNT > 0 THEN
1342: g_error_count := 1;
1343: IF l_debug_level > 0 THEN
1344: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1345: END IF;
1346: END IF;
1347: END IF;
1348:

Line 1384: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1380: IF g_error_count = 0 THEN
1381: IF SQL%ROWCOUNT > 0 THEN
1382: g_error_count := 1;
1383: IF l_debug_level > 0 THEN
1384: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1385: END IF;
1386: END IF;
1387: END IF;
1388:

Line 1437: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1433: IF g_error_count = 0 THEN
1434: IF SQL%ROWCOUNT > 0 THEN
1435: g_error_count := 1;
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1438: END IF;
1439: END IF;
1440: END IF;
1441:

Line 1489: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1485: IF g_error_count = 0 THEN
1486: IF SQL%ROWCOUNT > 0 THEN
1487: g_error_count := 1;
1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1490: END IF;
1491: END IF;
1492: END IF;
1493:

Line 1528: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1524: IF g_error_count = 0 THEN
1525: IF SQL%ROWCOUNT > 0 THEN
1526: g_error_count := 1;
1527: IF l_debug_level > 0 THEN
1528: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1529: END IF;
1530: END IF;
1531: END IF;
1532:

Line 1567: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1563: IF g_error_count = 0 THEN
1564: IF SQL%ROWCOUNT > 0 THEN
1565: g_error_count := 1;
1566: IF l_debug_level > 0 THEN
1567: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1568: END IF;
1569: END IF;
1570: END IF;
1571:

Line 1602: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1598: IF g_error_count = 0 THEN
1599: IF SQL%ROWCOUNT > 0 THEN
1600: g_error_count := 1;
1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1603: END IF;
1604: END IF;
1605: END IF;
1606:

Line 1654: oe_debug_pub.add( 'PROCESS DUAL 0 THE ERROR COUNT IS SET' ) ;

1650: IF g_error_count = 0 THEN
1651: IF SQL%ROWCOUNT > 0 THEN
1652: g_error_count := 1;
1653: IF l_debug_level > 0 THEN
1654: oe_debug_pub.add( 'PROCESS DUAL 0 THE ERROR COUNT IS SET' ) ;
1655: END IF;
1656: END IF;
1657: END IF;
1658:

Line 1701: oe_debug_pub.add( 'PROCESS DUAL 1 THE ERROR COUNT IS SET' ) ;

1697: IF g_error_count = 0 THEN
1698: IF SQL%ROWCOUNT > 0 THEN
1699: g_error_count := 1;
1700: IF l_debug_level > 0 THEN
1701: oe_debug_pub.add( 'PROCESS DUAL 1 THE ERROR COUNT IS SET' ) ;
1702: END IF;
1703: END IF;
1704: END IF;
1705:

Line 1749: oe_debug_pub.add( 'PROCESS DUAL 2 THE ERROR COUNT IS SET' ) ;

1745: IF g_error_count = 0 THEN
1746: IF SQL%ROWCOUNT > 0 THEN
1747: g_error_count := 1;
1748: IF l_debug_level > 0 THEN
1749: oe_debug_pub.add( 'PROCESS DUAL 2 THE ERROR COUNT IS SET' ) ;
1750: END IF;
1751: END IF;
1752: END IF;
1753:

Line 1798: oe_debug_pub.add( 'PROCESS DUAL 3 THE ERROR COUNT IS SET' ) ;

1794: IF g_error_count = 0 THEN
1795: IF SQL%ROWCOUNT > 0 THEN
1796: g_error_count := 1;
1797: IF l_debug_level > 0 THEN
1798: oe_debug_pub.add( 'PROCESS DUAL 3 THE ERROR COUNT IS SET' ) ;
1799: END IF;
1800: END IF;
1801: END IF;
1802:

Line 1855: oe_debug_pub.add( 'PROCESS DUAL 4 THE ERROR COUNT IS SET' ) ;

1851: IF g_error_count = 0 THEN
1852: IF SQL%ROWCOUNT > 0 THEN
1853: g_error_count := 1;
1854: IF l_debug_level > 0 THEN
1855: oe_debug_pub.add( 'PROCESS DUAL 4 THE ERROR COUNT IS SET' ) ;
1856: END IF;
1857: END IF;
1858: END IF;
1859:

Line 1894: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1890: IF g_error_count = 0 THEN
1891: IF SQL%ROWCOUNT > 0 THEN
1892: g_error_count := 1;
1893: IF l_debug_level > 0 THEN
1894: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1895: END IF;
1896: END IF;
1897: END IF;
1898:

Line 1931: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1927: IF g_error_count = 0 THEN
1928: IF SQL%ROWCOUNT > 0 THEN
1929: g_error_count := 1;
1930: IF l_debug_level > 0 THEN
1931: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1932: END IF;
1933: END IF;
1934: END IF;
1935:

Line 1979: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

1975: IF g_error_count = 0 THEN
1976: IF SQL%ROWCOUNT > 0 THEN
1977: g_error_count := 1;
1978: IF l_debug_level > 0 THEN
1979: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
1980: END IF;
1981: END IF;
1982: END IF;
1983:

Line 2015: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

2011: IF g_error_count = 0 THEN
2012: IF SQL%ROWCOUNT > 0 THEN
2013: g_error_count := 1;
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
2016: END IF;
2017: END IF;
2018: END IF;
2019:

Line 2054: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

2050: IF g_error_count = 0 THEN
2051: IF SQL%ROWCOUNT > 0 THEN
2052: g_error_count := 1;
2053: IF l_debug_level > 0 THEN
2054: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
2055: END IF;
2056: END IF;
2057: END IF;
2058:

Line 2097: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

2093: IF g_error_count = 0 THEN
2094: IF SQL%ROWCOUNT > 0 THEN
2095: g_error_count := 1;
2096: IF l_debug_level > 0 THEN
2097: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
2098: END IF;
2099: END IF;
2100: END IF;
2101:

Line 2135: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

2131: IF g_error_count = 0 THEN
2132: IF SQL%ROWCOUNT > 0 THEN
2133: g_error_count := 1;
2134: IF l_debug_level > 0 THEN
2135: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
2136: END IF;
2137: END IF;
2138: END IF;
2139:

Line 2174: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

2170: IF g_error_count = 0 THEN
2171: IF SQL%ROWCOUNT > 0 THEN
2172: g_error_count := 1;
2173: IF l_debug_level > 0 THEN
2174: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
2175: END IF;
2176: END IF;
2177: END IF;
2178:

Line 2215: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

2211: IF g_error_count = 0 THEN
2212: IF SQL%ROWCOUNT > 0 THEN
2213: g_error_count := 1;
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
2216: END IF;
2217: END IF;
2218: END IF;
2219:

Line 2256: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;

2252: IF g_error_count = 0 THEN
2253: IF SQL%ROWCOUNT > 0 THEN
2254: g_error_count := 1;
2255: IF l_debug_level > 0 THEN
2256: oe_debug_pub.add( 'THE ERROR COUNT IS SET' ) ;
2257: END IF;
2258: END IF;
2259: END IF;
2260:

Line 2264: oe_debug_pub.add( 'EXIT ATTRIBUTES , G_ERROR_COUNT: '||G_ERROR_COUNT ) ;

2260:
2261: --bug 5054618}
2262:
2263: IF l_debug_level > 0 THEN
2264: oe_debug_pub.add( 'EXIT ATTRIBUTES , G_ERROR_COUNT: '||G_ERROR_COUNT ) ;
2265: END IF;
2266: EXCEPTION
2267: WHEN OTHERS THEN
2268: IF l_debug_level > 0 THEN

Line 2269: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE.ATTRIBUTES' ) ;

2265: END IF;
2266: EXCEPTION
2267: WHEN OTHERS THEN
2268: IF l_debug_level > 0 THEN
2269: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE.ATTRIBUTES' ) ;
2270: END IF;
2271: IF l_debug_level > 0 THEN
2272: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2273: END IF;

Line 2272: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

2268: IF l_debug_level > 0 THEN
2269: oe_debug_pub.add( 'OTHERS ERROR , VALIDATE.ATTRIBUTES' ) ;
2270: END IF;
2271: IF l_debug_level > 0 THEN
2272: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2273: END IF;
2274: OE_BULK_MSG_PUB.ADD_Exc_Msg
2275: ( G_PKG_NAME
2276: , 'Attributes'

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

2289:
2290: IS
2291: l_msg_text VARCHAR2(2000);
2292:
2293: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2294:
2295: BEGIN
2296: IF l_debug_level > 0 THEN
2297: oe_debug_pub.add( 'ENTERING OE_BULK_VALIDATE.Validate_BOM ') ;

Line 2297: oe_debug_pub.add( 'ENTERING OE_BULK_VALIDATE.Validate_BOM ') ;

2293: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2294:
2295: BEGIN
2296: IF l_debug_level > 0 THEN
2297: oe_debug_pub.add( 'ENTERING OE_BULK_VALIDATE.Validate_BOM ') ;
2298: END IF;
2299:
2300:
2301: -- Check if parent exists

Line 2531: oe_debug_pub.add('LEAVING OE_BULK_VALIDATE.Validate_BOM' , 1);

2527: END IF;
2528:
2529:
2530: IF l_debug_level > 0 THEN
2531: oe_debug_pub.add('LEAVING OE_BULK_VALIDATE.Validate_BOM' , 1);
2532: END IF;
2533:
2534: EXCEPTION
2535: WHEN OTHERS THEN

Line 2536: oe_debug_pub.add('Others Error, Validate_BOM');

2532: END IF;
2533:
2534: EXCEPTION
2535: WHEN OTHERS THEN
2536: oe_debug_pub.add('Others Error, Validate_BOM');
2537: oe_debug_pub.add(substr(sqlerrm,1,240));
2538: OE_BULK_MSG_PUB.Add_Exc_Msg
2539: ( G_PKG_NAME,
2540: 'Validate_BOM'

Line 2537: oe_debug_pub.add(substr(sqlerrm,1,240));

2533:
2534: EXCEPTION
2535: WHEN OTHERS THEN
2536: oe_debug_pub.add('Others Error, Validate_BOM');
2537: oe_debug_pub.add(substr(sqlerrm,1,240));
2538: OE_BULK_MSG_PUB.Add_Exc_Msg
2539: ( G_PKG_NAME,
2540: 'Validate_BOM'
2541: );

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

2555:
2556: PROCEDURE MARK_INTERFACE_ERROR(p_batch_id NUMBER)
2557: IS
2558: --
2559: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2560: --
2561: BEGIN
2562:
2563: -- set the error flag for the configuration pre_process failure

Line 2631: oe_debug_pub.add( 'OTHERS ERROR , MARK_INTERFACE_ERROR' ) ;

2627:
2628: EXCEPTION
2629: WHEN OTHERS THEN
2630: IF l_debug_level > 0 THEN
2631: oe_debug_pub.add( 'OTHERS ERROR , MARK_INTERFACE_ERROR' ) ;
2632: END IF;
2633: IF l_debug_level > 0 THEN
2634: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2635: END IF;

Line 2634: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;

2630: IF l_debug_level > 0 THEN
2631: oe_debug_pub.add( 'OTHERS ERROR , MARK_INTERFACE_ERROR' ) ;
2632: END IF;
2633: IF l_debug_level > 0 THEN
2634: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2635: END IF;
2636: OE_BULK_MSG_PUB.ADD_Exc_Msg
2637: ( G_PKG_NAME
2638: , 'MARK_INTERFACE_ERROR'