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_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: -- clear the cached results so that the cache is reset for

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

599: ) RETURN NUMBER
600: IS
601: l_result NUMBER;
602: --
603: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
604: --
605: BEGIN
606:
607: l_result := Is_OP_constrained

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

624: ) RETURN NUMBER
625: IS
626: l_result NUMBER;
627: --
628: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
629: --
630: BEGIN
631:
632: l_result := Is_OP_constrained

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

649: ) RETURN NUMBER
650: IS
651: l_result NUMBER;
652: --
653: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
654: --
655: BEGIN
656:
657: l_result := Is_OP_constrained

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

673: ) RETURN NUMBER
674: IS
675: l_result NUMBER;
676: --
677: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
678: --
679: BEGIN
680:
681: l_result := Is_OP_constrained

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

697: ) RETURN NUMBER
698: IS
699: l_result NUMBER;
700: --
701: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
702: --
703: BEGIN
704:
705: l_result := Is_OP_constrained

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

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

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

745: ) RETURN NUMBER
746: IS
747: l_result NUMBER;
748: --
749: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
750: --
751: BEGIN
752:
753: 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 797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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

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

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

841: ) RETURN NUMBER
842: IS
843: l_result NUMBER;
844: --
845: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
846: --
847: BEGIN
848:
849: l_result := Is_OP_constrained

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

867: l_operation VARCHAR2(1);
868: l_on_operation_action NUMBER;
869: l_rowtype_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;
870: --
871: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
872: --
873: BEGIN
874:
875: IF l_debug_level > 0 THEN

Line 876: oe_debug_pub.add( 'ENTER OE_LINE_PAYMENT_SECURITY.ENTITY' , 1 ) ;

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

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

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

Line 909: oe_debug_pub.add( 'EXIT OE_LINE_PAYMENT_SECURITY.ENTITY' , 1 ) ;

905: ,x_on_operation_action => l_on_operation_action
906: );
907:
908: IF l_debug_level > 0 THEN
909: oe_debug_pub.add( 'EXIT OE_LINE_PAYMENT_SECURITY.ENTITY' , 1 ) ;
910: END IF;
911:
912: EXCEPTION
913: WHEN OTHERS THEN

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

936: l_rowtype_rec OE_AK_LINE_PAYMENTS_V%ROWTYPE;
937: l_column_name VARCHAR2(30);
938: l_check_all_cols_constraint VARCHAR2(1);
939: --
940: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
941: --
942: BEGIN
943: IF l_debug_level > 0 THEN
944: oe_debug_pub.add( 'ENTER OE_LINE_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;

Line 944: oe_debug_pub.add( 'ENTER OE_LINE_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;

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

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

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

Line 1124: oe_debug_pub.add('Before calling is_same_Credit_card');

1120: --Since the credit card numbers are encrypted, calling
1121: --the function same credit card to determine whether the old
1122: --and new card numbers are equal.
1123: IF l_debug_level > 0 THEN
1124: oe_debug_pub.add('Before calling is_same_Credit_card');
1125: oe_debug_pub.add('Old and new cc number'||p_old_line_Payment_rec.credit_card_number||'and'||p_line_payment_rec.credit_Card_number);
1126: END IF;
1127: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_payment_rec.credit_card_number,
1128: p_line_payment_rec.credit_card_number,

Line 1125: oe_debug_pub.add('Old and new cc number'||p_old_line_Payment_rec.credit_card_number||'and'||p_line_payment_rec.credit_Card_number);

1121: --the function same credit card to determine whether the old
1122: --and new card numbers are equal.
1123: IF l_debug_level > 0 THEN
1124: oe_debug_pub.add('Before calling is_same_Credit_card');
1125: oe_debug_pub.add('Old and new cc number'||p_old_line_Payment_rec.credit_card_number||'and'||p_line_payment_rec.credit_Card_number);
1126: END IF;
1127: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_payment_rec.credit_card_number,
1128: p_line_payment_rec.credit_card_number,
1129: p_old_line_payment_rec.cc_instrument_id,

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

1496: END IF;
1497:
1498: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1499: IF l_debug_level > 0 THEN
1500: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1501: END IF;
1502: g_check_all_cols_constraint := l_check_all_cols_constraint;
1503: END IF;
1504:

Line 1510: oe_debug_pub.add( 'EXIT OE_LINE_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;

1506: -- NOTE: Please add constraints check for new attributes before the
1507: -- descriptive flexfield attributes check.
1508:
1509: IF l_debug_level > 0 THEN
1510: oe_debug_pub.add( 'EXIT OE_LINE_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;
1511: END IF;
1512:
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN