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

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

29: WHERE HEADER_ID = x_header_id;
30:
31: l_transaction_phase_code VARCHAR2(30);
32: --
33: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
34: --
35: BEGIN
36:
37: IF l_code_level >= '110510' THEN

Line 105: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;

101: IF l_result = OE_PC_GLOBALS.YES THEN
102: IF x_on_operation_action = 1 THEN
103: -- set OUT result to NOT CONSTRAINED
104: IF l_debug_level > 0 THEN
105: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
106: END IF;
107: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
108: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
109: ELSIF x_on_operation_action = 2 THEN

Line 113: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;

109: ELSIF x_on_operation_action = 2 THEN
110: -- set OUT result to NOT CONSTRAINED
111: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
112: IF l_debug_level > 0 THEN
113: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
114: END IF;
115: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
116: END IF;
117: END IF;

Line 125: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;

121: IF l_result = OE_PC_GLOBALS.YES THEN
122: IF x_on_operation_action = 1 THEN
123: -- set OUT result to NOT CONSTRAINED
124: IF l_debug_level > 0 THEN
125: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
126: END IF;
127: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
128: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
129: ELSIF x_on_operation_action = 2 THEN

Line 133: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;

129: ELSIF x_on_operation_action = 2 THEN
130: -- set OUT result to NOT CONSTRAINED
131: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
132: IF l_debug_level > 0 THEN
133: oe_debug_pub.add( 'LINE ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
134: END IF;
135: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
136: END IF;
137: END IF;

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

160: ) RETURN NUMBER
161: IS
162: l_result NUMBER;
163: --
164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
165: --
166: BEGIN
167:
168: l_result := Is_OP_constrained

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

185: ) RETURN NUMBER
186: IS
187: l_result NUMBER;
188: --
189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
190: --
191: BEGIN
192:
193: l_result := Is_OP_constrained

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

210: ) RETURN NUMBER
211: IS
212: l_result NUMBER;
213: --
214: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
215: --
216: BEGIN
217:
218: l_result := Is_OP_constrained

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

235: ) RETURN NUMBER
236: IS
237: l_result NUMBER;
238: --
239: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
240: --
241: BEGIN
242:
243: l_result := Is_OP_constrained

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

260: ) RETURN NUMBER
261: IS
262: l_result NUMBER;
263: --
264: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
265: --
266: BEGIN
267:
268: l_result := Is_OP_constrained

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

285: ) RETURN NUMBER
286: IS
287: l_result NUMBER;
288: --
289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
290: --
291: BEGIN
292:
293: l_result := Is_OP_constrained

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

310: ) RETURN NUMBER
311: IS
312: l_result NUMBER;
313: --
314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
315: --
316: BEGIN
317:
318: l_result := Is_OP_constrained

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

335: ) RETURN NUMBER
336: IS
337: l_result NUMBER;
338: --
339: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
340: --
341: BEGIN
342:
343: l_result := Is_OP_constrained

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

360: ) RETURN NUMBER
361: IS
362: l_result NUMBER;
363: --
364: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
365: --
366: BEGIN
367:
368: l_result := Is_OP_constrained

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

385: ) RETURN NUMBER
386: IS
387: l_result NUMBER;
388: --
389: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
390: --
391: BEGIN
392:
393: l_result := Is_OP_constrained

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

410: ) RETURN NUMBER
411: IS
412: l_result NUMBER;
413: --
414: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
415: --
416: BEGIN
417:
418: l_result := Is_OP_constrained

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

435: ) RETURN NUMBER
436: IS
437: l_result NUMBER;
438: --
439: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
440: --
441: BEGIN
442:
443: l_result := Is_OP_constrained

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

460: ) RETURN NUMBER
461: IS
462: l_result NUMBER;
463: --
464: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
465: --
466: BEGIN
467:
468: l_result := Is_OP_constrained

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

485: ) RETURN NUMBER
486: IS
487: l_result NUMBER;
488: --
489: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
490: --
491: BEGIN
492:
493: l_result := Is_OP_constrained

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

510: ) RETURN NUMBER
511: IS
512: l_result NUMBER;
513: --
514: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
515: --
516: BEGIN
517:
518: l_result := Is_OP_constrained

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

535: ) RETURN NUMBER
536: IS
537: l_result NUMBER;
538: --
539: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
540: --
541: BEGIN
542:
543: l_result := Is_OP_constrained

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

560: ) RETURN NUMBER
561: IS
562: l_result NUMBER;
563: --
564: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
565: --
566: BEGIN
567:
568: l_result := Is_OP_constrained

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

585: ) RETURN NUMBER
586: IS
587: l_result NUMBER;
588: --
589: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
590: --
591: BEGIN
592:
593: l_result := Is_OP_constrained

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

610: ) RETURN NUMBER
611: IS
612: l_result NUMBER;
613: --
614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
615: --
616: BEGIN
617:
618: l_result := Is_OP_constrained

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

635: ) RETURN NUMBER
636: IS
637: l_result NUMBER;
638: --
639: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
640: --
641: BEGIN
642:
643: l_result := Is_OP_constrained

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

659: ) RETURN NUMBER
660: IS
661: l_result NUMBER;
662: --
663: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
664: --
665: BEGIN
666:
667: l_result := Is_OP_constrained

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

683: ) RETURN NUMBER
684: IS
685: l_result NUMBER;
686: --
687: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
688: --
689: BEGIN
690:
691: l_result := Is_OP_constrained

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

708: ) RETURN NUMBER
709: IS
710: l_result NUMBER;
711: --
712: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
713: --
714: BEGIN
715:
716: l_result := Is_OP_constrained

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

733: ) RETURN NUMBER
734: IS
735: l_result NUMBER;
736: --
737: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
738: --
739: BEGIN
740:
741: l_result := Is_OP_constrained

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

758: ) RETURN NUMBER
759: IS
760: l_result NUMBER;
761: --
762: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
763: --
764: BEGIN
765:
766: l_result := Is_OP_constrained

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

783: ) RETURN NUMBER
784: IS
785: l_result NUMBER;
786: --
787: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
788: --
789: BEGIN
790:
791: l_result := Is_OP_constrained

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

808: ) RETURN NUMBER
809: IS
810: l_result NUMBER;
811: --
812: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
813: --
814: BEGIN
815:
816: l_result := Is_OP_constrained

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

833: ) RETURN NUMBER
834: IS
835: l_result NUMBER;
836: --
837: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
838: --
839: BEGIN
840:
841: l_result := Is_OP_constrained

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

858: ) RETURN NUMBER
859: IS
860: l_result NUMBER;
861: --
862: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
863: --
864: BEGIN
865:
866: l_result := Is_OP_constrained

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

883: ) RETURN NUMBER
884: IS
885: l_result NUMBER;
886: --
887: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
888: --
889: BEGIN
890:
891: l_result := Is_OP_constrained

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

908: ) RETURN NUMBER
909: IS
910: l_result NUMBER;
911: --
912: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
913: --
914: BEGIN
915:
916: l_result := Is_OP_constrained

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

933: ) RETURN NUMBER
934: IS
935: l_result NUMBER;
936: --
937: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
938: --
939: BEGIN
940:
941: l_result := Is_OP_constrained

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

958: ) RETURN NUMBER
959: IS
960: l_result NUMBER;
961: --
962: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
963: --
964: BEGIN
965:
966: l_result := Is_OP_constrained

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

982: ) RETURN NUMBER
983: IS
984: l_result NUMBER;
985: --
986: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
987: --
988: BEGIN
989:
990: l_result := Is_OP_constrained

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

1006: ) RETURN NUMBER
1007: IS
1008: l_result NUMBER;
1009: --
1010: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1011: --
1012: BEGIN
1013:
1014: l_result := Is_OP_constrained

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

1030: ) RETURN NUMBER
1031: IS
1032: l_result NUMBER;
1033: --
1034: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1035: --
1036: BEGIN
1037:
1038: l_result := Is_OP_constrained

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

1054: ) RETURN NUMBER
1055: IS
1056: l_result NUMBER;
1057: --
1058: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1059: --
1060: BEGIN
1061:
1062: l_result := Is_OP_constrained

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

1078: ) RETURN NUMBER
1079: IS
1080: l_result NUMBER;
1081: --
1082: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1083: --
1084: BEGIN
1085:
1086: l_result := Is_OP_constrained

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

1102: ) RETURN NUMBER
1103: IS
1104: l_result NUMBER;
1105: --
1106: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1107: --
1108: BEGIN
1109:
1110: l_result := Is_OP_constrained

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

1126: ) RETURN NUMBER
1127: IS
1128: l_result NUMBER;
1129: --
1130: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1131: --
1132: BEGIN
1133:
1134: l_result := Is_OP_constrained

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

1150: ) RETURN NUMBER
1151: IS
1152: l_result NUMBER;
1153: --
1154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1155: --
1156: BEGIN
1157:
1158: l_result := Is_OP_constrained

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

1174: ) RETURN NUMBER
1175: IS
1176: l_result NUMBER;
1177: --
1178: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1179: --
1180: BEGIN
1181:
1182: l_result := Is_OP_constrained

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

1198: ) RETURN NUMBER
1199: IS
1200: l_result NUMBER;
1201: --
1202: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1203: --
1204: BEGIN
1205:
1206: l_result := Is_OP_constrained

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

1222: ) RETURN NUMBER
1223: IS
1224: l_result NUMBER;
1225: --
1226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1227: --
1228: BEGIN
1229:
1230: l_result := Is_OP_constrained

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

1248: l_operation VARCHAR2(1);
1249: l_on_operation_action NUMBER;
1250: l_rowtype_rec OE_AK_LINE_PRCADJS_V%ROWTYPE;
1251: --
1252: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1253: --
1254: BEGIN
1255:
1256: IF l_debug_level > 0 THEN

Line 1257: oe_debug_pub.add( 'ENTER OE_LINE_ADJ_SECURITY.ENTITY' , 1 ) ;

1253: --
1254: BEGIN
1255:
1256: IF l_debug_level > 0 THEN
1257: oe_debug_pub.add( 'ENTER OE_LINE_ADJ_SECURITY.ENTITY' , 1 ) ;
1258: END IF;
1259:
1260: -- Initializing return status to SUCCESS
1261: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1271: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

1267: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1268: l_operation := OE_PC_GLOBALS.DELETE_OP;
1269: ELSE
1270: IF l_debug_level > 0 THEN
1271: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1272: END IF;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:

Line 1290: oe_debug_pub.add( 'EXIT OE_LINE_ADJ_SECURITY.ENTITY' , 1 ) ;

1286: ,x_on_operation_action => l_on_operation_action
1287: );
1288:
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'EXIT OE_LINE_ADJ_SECURITY.ENTITY' , 1 ) ;
1291: END IF;
1292:
1293: EXCEPTION
1294: WHEN OTHERS THEN

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

1317: l_rowtype_rec OE_AK_LINE_PRCADJS_V%ROWTYPE;
1318: l_column_name VARCHAR2(30);
1319: l_check_all_cols_constraint VARCHAR2(1);
1320: --
1321: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1322: --
1323: BEGIN
1324: IF l_debug_level > 0 THEN
1325: oe_debug_pub.add( 'ENTER OE_LINE_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;

Line 1325: oe_debug_pub.add( 'ENTER OE_LINE_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;

1321: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1322: --
1323: BEGIN
1324: IF l_debug_level > 0 THEN
1325: oe_debug_pub.add( 'ENTER OE_LINE_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;
1326: END IF;
1327:
1328: -- Initializing return status to SUCCESS
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1353: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

1349: ELSIF p_LINE_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1350: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1351: ELSE
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1354: END IF;
1355: RAISE FND_API.G_EXC_ERROR;
1356: END IF;
1357:

Line 1739: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;

1735: END IF;
1736:
1737: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1738: IF l_debug_level > 0 THEN
1739: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1740: END IF;
1741: g_check_all_cols_constraint := l_check_all_cols_constraint;
1742: END IF;
1743:

Line 1749: oe_debug_pub.add( 'EXIT OE_LINE_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;

1745: -- NOTE: Please add constraints check for new attributes before the
1746: -- descriptive flexfield attributes check.
1747:
1748: IF l_debug_level > 0 THEN
1749: oe_debug_pub.add( 'EXIT OE_LINE_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;
1750: END IF;
1751:
1752: EXCEPTION
1753: WHEN FND_API.G_EXC_ERROR THEN