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

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

23: l_constrained_column VARCHAR2(30);
24: l_code_level varchar2(6) := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
25: l_transaction_phase_code VARCHAR2(30);
26: --
27: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
28: --
29: BEGIN
30:
31: IF p_record.header_id <> g_header_id THEN

Line 65: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);

61: INTO l_constrained_column
62: FROM oe_pc_constraints
63: WHERE constraint_id = l_constraint_id;
64: if l_constrained_column is null AND x_on_operation_action = 0 then
65: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
66: RAISE FND_API.G_EXC_ERROR;
67: end if;
68: END IF;
69:

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

96: ) RETURN NUMBER
97: IS
98: l_result NUMBER;
99: --
100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
101: --
102: BEGIN
103:
104: l_result := Is_OP_constrained

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

121: ) RETURN NUMBER
122: IS
123: l_result NUMBER;
124: --
125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
126: --
127: BEGIN
128:
129: l_result := Is_OP_constrained

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

146: ) RETURN NUMBER
147: IS
148: l_result NUMBER;
149: --
150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
151: --
152: BEGIN
153:
154: l_result := Is_OP_constrained

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 501: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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

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

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

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

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

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

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

597: ) RETURN NUMBER
598: IS
599: l_result NUMBER;
600: --
601: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
602: --
603: BEGIN
604:
605: 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 722: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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

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

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

766: ) RETURN NUMBER
767: IS
768: l_result NUMBER;
769: --
770: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
771: --
772: BEGIN
773:
774: l_result := Is_OP_constrained

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

790: ) RETURN NUMBER
791: IS
792: l_result NUMBER;
793: --
794: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
795: --
796: BEGIN
797:
798: l_result := Is_OP_constrained

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

814: ) RETURN NUMBER
815: IS
816: l_result NUMBER;
817: --
818: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
819: --
820: BEGIN
821:
822: l_result := Is_OP_constrained

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

838: ) RETURN NUMBER
839: IS
840: l_result NUMBER;
841: --
842: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
843: --
844: BEGIN
845:
846: l_result := Is_OP_constrained

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

864: l_operation VARCHAR2(1);
865: l_on_operation_action NUMBER;
866: l_rowtype_rec OE_AK_HEADER_PAYMENTS_V%ROWTYPE;
867: --
868: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
869: --
870: BEGIN
871:
872: IF l_debug_level > 0 THEN

Line 873: oe_debug_pub.add( 'ENTER OE_HEADER_PAYMENT_SECURITY.ENTITY' , 1 ) ;

869: --
870: BEGIN
871:
872: IF l_debug_level > 0 THEN
873: oe_debug_pub.add( 'ENTER OE_HEADER_PAYMENT_SECURITY.ENTITY' , 1 ) ;
874: END IF;
875:
876: -- Initializing return status to SUCCESS
877: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

883: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
884: l_operation := OE_PC_GLOBALS.DELETE_OP;
885: ELSE
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
888: END IF;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891:

Line 906: oe_debug_pub.add( 'EXIT OE_HEADER_PAYMENT_SECURITY.ENTITY' , 1 ) ;

902: ,x_on_operation_action => l_on_operation_action
903: );
904:
905: IF l_debug_level > 0 THEN
906: oe_debug_pub.add( 'EXIT OE_HEADER_PAYMENT_SECURITY.ENTITY' , 1 ) ;
907: END IF;
908:
909: EXCEPTION
910: WHEN OTHERS THEN

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

933: l_rowtype_rec OE_AK_HEADER_PAYMENTS_V%ROWTYPE;
934: l_column_name VARCHAR2(30);
935: l_check_all_cols_constraint VARCHAR2(1);
936: --
937: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
938: --
939: BEGIN
940: IF l_debug_level > 0 THEN
941: oe_debug_pub.add( 'ENTER OE_HEADER_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;

Line 941: oe_debug_pub.add( 'ENTER OE_HEADER_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;

937: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
938: --
939: BEGIN
940: IF l_debug_level > 0 THEN
941: oe_debug_pub.add( 'ENTER OE_HEADER_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;
942: END IF;
943:
944: -- Initializing return status to SUCCESS
945: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

968: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
969: l_operation := OE_PC_GLOBALS.UPDATE_OP;
970: ELSE
971: IF l_debug_level > 0 THEN
972: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
973: END IF;
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976:

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

1486: END IF;
1487:
1488: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1489: IF l_debug_level > 0 THEN
1490: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1491: END IF;
1492: g_check_all_cols_constraint := l_check_all_cols_constraint;
1493: END IF;
1494:

Line 1500: oe_debug_pub.add( 'EXIT OE_HEADER_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;

1496: -- NOTE: Please add constraints check for new attributes before the
1497: -- descriptive flexfield attributes check.
1498:
1499: IF l_debug_level > 0 THEN
1500: oe_debug_pub.add( 'EXIT OE_HEADER_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;
1501: END IF;
1502:
1503: EXCEPTION
1504: WHEN FND_API.G_EXC_ERROR THEN