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

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

31: WHERE HEADER_ID = x_header_id;
32:
33: l_transaction_phase_code VARCHAR2(30);
34: --
35: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
36: --
37: BEGIN
38:
39: -- Bug 1755817: if header adjustment belongs to a different order, then

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

112: IF l_result = OE_PC_GLOBALS.YES THEN
113: IF x_on_operation_action = 1 THEN
114: -- set OUT result to NOT CONSTRAINED
115: IF l_debug_level > 0 THEN
116: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
117: END IF;
118: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
119: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
120: ELSIF x_on_operation_action = 2 THEN

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

120: ELSIF x_on_operation_action = 2 THEN
121: -- set OUT result to NOT CONSTRAINED
122: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
125: END IF;
126: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
127: END IF;
128: END IF;

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

132: IF l_result = OE_PC_GLOBALS.YES THEN
133: IF x_on_operation_action = 1 THEN
134: -- set OUT result to NOT CONSTRAINED
135: IF l_debug_level > 0 THEN
136: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES REASON TO TRUE' , 5 ) ;
137: END IF;
138: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
139: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'N';
140: ELSIF x_on_operation_action = 2 THEN

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

140: ELSIF x_on_operation_action = 2 THEN
141: -- set OUT result to NOT CONSTRAINED
142: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'HEADER ADJUSTMENTS SECURITY - SETTING REQUIRES HISTORY TO TRUE' , 5 ) ;
145: END IF;
146: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
147: END IF;
148: END IF;

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

171: ) RETURN NUMBER
172: IS
173: l_result NUMBER;
174: --
175: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
176: --
177: BEGIN
178:
179: l_result := Is_OP_constrained

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

196: ) RETURN NUMBER
197: IS
198: l_result NUMBER;
199: --
200: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
201: --
202: BEGIN
203:
204: l_result := Is_OP_constrained

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

221: ) RETURN NUMBER
222: IS
223: l_result NUMBER;
224: --
225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
226: --
227: BEGIN
228:
229: l_result := Is_OP_constrained

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

246: ) RETURN NUMBER
247: IS
248: l_result NUMBER;
249: --
250: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
251: --
252: BEGIN
253:
254: l_result := Is_OP_constrained

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

271: ) RETURN NUMBER
272: IS
273: l_result NUMBER;
274: --
275: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
276: --
277: BEGIN
278:
279: l_result := Is_OP_constrained

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

296: ) RETURN NUMBER
297: IS
298: l_result NUMBER;
299: --
300: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
301: --
302: BEGIN
303:
304: l_result := Is_OP_constrained

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

321: ) RETURN NUMBER
322: IS
323: l_result NUMBER;
324: --
325: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
326: --
327: BEGIN
328:
329: l_result := Is_OP_constrained

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

346: ) RETURN NUMBER
347: IS
348: l_result NUMBER;
349: --
350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
351: --
352: BEGIN
353:
354: l_result := Is_OP_constrained

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

371: ) RETURN NUMBER
372: IS
373: l_result NUMBER;
374: --
375: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
376: --
377: BEGIN
378:
379: l_result := Is_OP_constrained

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

396: ) RETURN NUMBER
397: IS
398: l_result NUMBER;
399: --
400: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
401: --
402: BEGIN
403:
404: l_result := Is_OP_constrained

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

421: ) RETURN NUMBER
422: IS
423: l_result NUMBER;
424: --
425: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
426: --
427: BEGIN
428:
429: l_result := Is_OP_constrained

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

446: ) RETURN NUMBER
447: IS
448: l_result NUMBER;
449: --
450: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
451: --
452: BEGIN
453:
454: l_result := Is_OP_constrained

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

471: ) RETURN NUMBER
472: IS
473: l_result NUMBER;
474: --
475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
476: --
477: BEGIN
478:
479: l_result := Is_OP_constrained

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

496: ) RETURN NUMBER
497: IS
498: l_result NUMBER;
499: --
500: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
501: --
502: BEGIN
503:
504: l_result := Is_OP_constrained

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

521: ) RETURN NUMBER
522: IS
523: l_result NUMBER;
524: --
525: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
526: --
527: BEGIN
528:
529: l_result := Is_OP_constrained

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

546: ) RETURN NUMBER
547: IS
548: l_result NUMBER;
549: --
550: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
551: --
552: BEGIN
553:
554: l_result := Is_OP_constrained

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

571: ) RETURN NUMBER
572: IS
573: l_result NUMBER;
574: --
575: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
576: --
577: BEGIN
578:
579: l_result := Is_OP_constrained

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

596: ) RETURN NUMBER
597: IS
598: l_result NUMBER;
599: --
600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
601: --
602: BEGIN
603:
604: l_result := Is_OP_constrained

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

621: ) RETURN NUMBER
622: IS
623: l_result NUMBER;
624: --
625: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
626: --
627: BEGIN
628:
629: l_result := Is_OP_constrained

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

646: ) RETURN NUMBER
647: IS
648: l_result NUMBER;
649: --
650: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
651: --
652: BEGIN
653:
654: l_result := Is_OP_constrained

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

670: ) RETURN NUMBER
671: IS
672: l_result NUMBER;
673: --
674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
675: --
676: BEGIN
677:
678: l_result := Is_OP_constrained

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

694: ) RETURN NUMBER
695: IS
696: l_result NUMBER;
697: --
698: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
699: --
700: BEGIN
701:
702: l_result := Is_OP_constrained

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

719: ) RETURN NUMBER
720: IS
721: l_result NUMBER;
722: --
723: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
724: --
725: BEGIN
726:
727: l_result := Is_OP_constrained

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

744: ) RETURN NUMBER
745: IS
746: l_result NUMBER;
747: --
748: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
749: --
750: BEGIN
751:
752: l_result := Is_OP_constrained

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

769: ) RETURN NUMBER
770: IS
771: l_result NUMBER;
772: --
773: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
774: --
775: BEGIN
776:
777: l_result := Is_OP_constrained

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

794: ) RETURN NUMBER
795: IS
796: l_result NUMBER;
797: --
798: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
799: --
800: BEGIN
801:
802: l_result := Is_OP_constrained

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

819: ) RETURN NUMBER
820: IS
821: l_result NUMBER;
822: --
823: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
824: --
825: BEGIN
826:
827: l_result := Is_OP_constrained

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

844: ) RETURN NUMBER
845: IS
846: l_result NUMBER;
847: --
848: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
849: --
850: BEGIN
851:
852: l_result := Is_OP_constrained

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

869: ) RETURN NUMBER
870: IS
871: l_result NUMBER;
872: --
873: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
874: --
875: BEGIN
876:
877: l_result := Is_OP_constrained

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

894: ) RETURN NUMBER
895: IS
896: l_result NUMBER;
897: --
898: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
899: --
900: BEGIN
901:
902: l_result := Is_OP_constrained

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

919: ) RETURN NUMBER
920: IS
921: l_result NUMBER;
922: --
923: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
924: --
925: BEGIN
926:
927: l_result := Is_OP_constrained

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

944: ) RETURN NUMBER
945: IS
946: l_result NUMBER;
947: --
948: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
949: --
950: BEGIN
951:
952: l_result := Is_OP_constrained

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

969: ) RETURN NUMBER
970: IS
971: l_result NUMBER;
972: --
973: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
974: --
975: BEGIN
976:
977: l_result := Is_OP_constrained

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

994: ) RETURN NUMBER
995: IS
996: l_result NUMBER;
997: --
998: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
999: --
1000: BEGIN
1001:
1002: l_result := Is_OP_constrained

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

1018: ) RETURN NUMBER
1019: IS
1020: l_result NUMBER;
1021: --
1022: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1023: --
1024: BEGIN
1025:
1026: l_result := Is_OP_constrained

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

1042: ) RETURN NUMBER
1043: IS
1044: l_result NUMBER;
1045: --
1046: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1047: --
1048: BEGIN
1049:
1050: l_result := Is_OP_constrained

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

1066: ) RETURN NUMBER
1067: IS
1068: l_result NUMBER;
1069: --
1070: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1071: --
1072: BEGIN
1073:
1074: l_result := Is_OP_constrained

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

1090: ) RETURN NUMBER
1091: IS
1092: l_result NUMBER;
1093: --
1094: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1095: --
1096: BEGIN
1097:
1098: l_result := Is_OP_constrained

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

1114: ) RETURN NUMBER
1115: IS
1116: l_result NUMBER;
1117: --
1118: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1119: --
1120: BEGIN
1121:
1122: l_result := Is_OP_constrained

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

1138: ) RETURN NUMBER
1139: IS
1140: l_result NUMBER;
1141: --
1142: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1143: --
1144: BEGIN
1145:
1146: l_result := Is_OP_constrained

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

1162: ) RETURN NUMBER
1163: IS
1164: l_result NUMBER;
1165: --
1166: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1167: --
1168: BEGIN
1169:
1170: l_result := Is_OP_constrained

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

1186: ) RETURN NUMBER
1187: IS
1188: l_result NUMBER;
1189: --
1190: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1191: --
1192: BEGIN
1193:
1194: l_result := Is_OP_constrained

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

1210: ) RETURN NUMBER
1211: IS
1212: l_result NUMBER;
1213: --
1214: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1215: --
1216: BEGIN
1217:
1218: l_result := Is_OP_constrained

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

1234: ) RETURN NUMBER
1235: IS
1236: l_result NUMBER;
1237: --
1238: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1239: --
1240: BEGIN
1241:
1242: l_result := Is_OP_constrained

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

1260: l_operation VARCHAR2(1);
1261: l_on_operation_action NUMBER;
1262: l_rowtype_rec OE_AK_HEADER_PRCADJS_V%ROWTYPE;
1263: --
1264: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1265: --
1266: BEGIN
1267:
1268: IF l_debug_level > 0 THEN

Line 1269: oe_debug_pub.add( 'ENTER OE_HEADER_ADJ_SECURITY.ENTITY' , 1 ) ;

1265: --
1266: BEGIN
1267:
1268: IF l_debug_level > 0 THEN
1269: oe_debug_pub.add( 'ENTER OE_HEADER_ADJ_SECURITY.ENTITY' , 1 ) ;
1270: END IF;
1271:
1272: -- Initializing return status to SUCCESS
1273: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1279: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
1280: l_operation := OE_PC_GLOBALS.DELETE_OP;
1281: ELSE
1282: IF l_debug_level > 0 THEN
1283: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1284: END IF;
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:

Line 1301: oe_debug_pub.add( 'EXIT OE_HEADER_ADJ_SECURITY.ENTITY' , 1 ) ;

1297: ,x_on_operation_action => l_on_operation_action
1298: );
1299:
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add( 'EXIT OE_HEADER_ADJ_SECURITY.ENTITY' , 1 ) ;
1302: END IF;
1303:
1304: EXCEPTION
1305: WHEN OTHERS THEN

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

1328: l_rowtype_rec OE_AK_HEADER_PRCADJS_V%ROWTYPE;
1329: l_column_name VARCHAR2(30);
1330: l_check_all_cols_constraint VARCHAR2(1);
1331: --
1332: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1333: --
1334: BEGIN
1335: IF l_debug_level > 0 THEN
1336: oe_debug_pub.add( 'ENTER OE_HEADER_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;

Line 1336: oe_debug_pub.add( 'ENTER OE_HEADER_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;

1332: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1333: --
1334: BEGIN
1335: IF l_debug_level > 0 THEN
1336: oe_debug_pub.add( 'ENTER OE_HEADER_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;
1337: END IF;
1338:
1339: -- Initializing return status to SUCCESS
1340: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1360: ELSIF p_HEADER_ADJ_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1361: l_operation := OE_PC_GLOBALS.UPDATE_OP;
1362: ELSE
1363: IF l_debug_level > 0 THEN
1364: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1365: END IF;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:

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

1745: END IF;
1746:
1747: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1748: IF l_debug_level > 0 THEN
1749: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1750: END IF;
1751: g_check_all_cols_constraint := l_check_all_cols_constraint;
1752: END IF;
1753:

Line 1759: oe_debug_pub.add( 'EXIT OE_HEADER_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;

1755: -- NOTE: Please add constraints check for new attributes before the
1756: -- descriptive flexfield attributes check.
1757:
1758: IF l_debug_level > 0 THEN
1759: oe_debug_pub.add( 'EXIT OE_HEADER_ADJ_SECURITY.ATTRIBUTES' , 1 ) ;
1760: END IF;
1761:
1762: EXCEPTION
1763: WHEN FND_API.G_EXC_ERROR THEN