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_SCREDIT_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 68: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);

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

Line 106: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

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

Line 114: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;

110: ELSIF x_on_operation_action = 2 THEN
111: -- set OUT result to NOT CONSTRAINED
112: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
115: END IF;
116: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
117: END IF;
118: END IF;

Line 126: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

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

Line 134: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;

130: ELSIF x_on_operation_action = 2 THEN
131: -- set OUT result to NOT CONSTRAINED
132: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'Y' then
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add( 'LINE SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
135: END IF;
136: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
137: END IF;
138: END IF;

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

163: ) RETURN NUMBER
164: IS
165: l_result NUMBER;
166: --
167: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
168: --
169: BEGIN
170:
171: l_result := Is_OP_constrained

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

188: ) RETURN NUMBER
189: IS
190: l_result NUMBER;
191: --
192: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
193: --
194: BEGIN
195:
196: l_result := Is_OP_constrained

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

463: ) RETURN NUMBER
464: IS
465: l_result NUMBER;
466: --
467: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
468: --
469: BEGIN
470:
471: l_result := Is_OP_constrained

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

488: ) RETURN NUMBER
489: IS
490: l_result NUMBER;
491: --
492: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
493: --
494: BEGIN
495:
496: l_result := Is_OP_constrained

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

513: ) RETURN NUMBER
514: IS
515: l_result NUMBER;
516: --
517: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
518: --
519: BEGIN
520:
521: l_result := Is_OP_constrained

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

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

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

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

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

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

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

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

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

638: ) RETURN NUMBER
639: IS
640: l_result NUMBER;
641: --
642: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
643: --
644: BEGIN
645:
646: l_result := Is_OP_constrained

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

663: ) RETURN NUMBER
664: IS
665: l_result NUMBER;
666: --
667: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
668: --
669: BEGIN
670:
671: l_result := Is_OP_constrained

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

688: ) RETURN NUMBER
689: IS
690: l_result NUMBER;
691: --
692: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
693: --
694: BEGIN
695:
696: l_result := Is_OP_constrained

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

715: l_operation VARCHAR2(1);
716: l_on_operation_action NUMBER;
717: l_rowtype_rec OE_AK_LINE_SCREDITS_V%ROWTYPE;
718: --
719: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
720: --
721: BEGIN
722:
723: IF l_debug_level > 0 THEN

Line 724: oe_debug_pub.add( 'ENTER OE_LINE_SCREDIT_SECURITY.ENTITY' , 1 ) ;

720: --
721: BEGIN
722:
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'ENTER OE_LINE_SCREDIT_SECURITY.ENTITY' , 1 ) ;
725: END IF;
726:
727: -- Initializing return status to SUCCESS
728: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

734: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
735: l_operation := OE_PC_GLOBALS.DELETE_OP;
736: ELSE
737: IF l_debug_level > 0 THEN
738: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
739: END IF;
740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742:

Line 757: oe_debug_pub.add( 'EXIT OE_LINE_SCREDIT_SECURITY.ENTITY' , 1 ) ;

753: ,x_on_operation_action => l_on_operation_action
754: );
755:
756: IF l_debug_level > 0 THEN
757: oe_debug_pub.add( 'EXIT OE_LINE_SCREDIT_SECURITY.ENTITY' , 1 ) ;
758: END IF;
759:
760: EXCEPTION
761: WHEN OTHERS THEN

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

784: l_rowtype_rec OE_AK_LINE_SCREDITS_V%ROWTYPE;
785: l_column_name VARCHAR2(30);
786: l_check_all_cols_constraint VARCHAR2(1);
787: --
788: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
789: --
790: BEGIN
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'ENTER OE_LINE_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;

Line 792: oe_debug_pub.add( 'ENTER OE_LINE_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;

788: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
789: --
790: BEGIN
791: IF l_debug_level > 0 THEN
792: oe_debug_pub.add( 'ENTER OE_LINE_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;
793: END IF;
794:
795: -- Initializing return status to SUCCESS
796: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

819: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
820: l_operation := OE_PC_GLOBALS.UPDATE_OP;
821: ELSE
822: IF l_debug_level > 0 THEN
823: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
824: END IF;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:

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

1188: END IF;
1189:
1190: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1191: IF l_debug_level > 0 THEN
1192: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1193: END IF;
1194: g_check_all_cols_constraint := l_check_all_cols_constraint;
1195: END IF;
1196:

Line 1202: oe_debug_pub.add( 'EXIT OE_LINE_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;

1198: -- NOTE: Please add constraints check for new attributes before the
1199: -- descriptive flexfield attributes check.
1200:
1201: IF l_debug_level > 0 THEN
1202: oe_debug_pub.add( 'EXIT OE_LINE_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;
1203: END IF;
1204:
1205: EXCEPTION
1206: WHEN FND_API.G_EXC_ERROR THEN