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

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

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

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

74: INTO l_constrained_column
75: FROM oe_pc_constraints
76: WHERE constraint_id = l_constraint_id;
77: if l_constrained_column is null then
78: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
79: RAISE FND_API.G_EXC_ERROR;
80: end if;
81: END IF;
82:

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

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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;

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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;

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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES REASON' , 1 ) ;
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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;

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 SALES CREDIT SECURITY , ATTRIBUTE CHANGE REQUIRES HISTORY' , 1 ) ;
145: END IF;
146: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG := 'Y';
147: END IF;
148: END IF;

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

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

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

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

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

548: ) RETURN NUMBER
549: IS
550: l_result NUMBER;
551: --
552: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
553: --
554: BEGIN
555:
556: 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 654: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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

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

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

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

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

725: l_operation VARCHAR2(1);
726: l_on_operation_action NUMBER;
727: l_rowtype_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;
728: --
729: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
730: --
731: BEGIN
732:
733: IF l_debug_level > 0 THEN

Line 734: oe_debug_pub.add( 'ENTER OE_HEADER_SCREDIT_SECURITY.ENTITY' , 1 ) ;

730: --
731: BEGIN
732:
733: IF l_debug_level > 0 THEN
734: oe_debug_pub.add( 'ENTER OE_HEADER_SCREDIT_SECURITY.ENTITY' , 1 ) ;
735: END IF;
736:
737: -- Initializing return status to SUCCESS
738: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

744: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
745: l_operation := OE_PC_GLOBALS.DELETE_OP;
746: ELSE
747: IF l_debug_level > 0 THEN
748: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
749: END IF;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752:

Line 767: oe_debug_pub.add( 'EXIT OE_HEADER_SCREDIT_SECURITY.ENTITY' , 1 ) ;

763: ,x_on_operation_action => l_on_operation_action
764: );
765:
766: IF l_debug_level > 0 THEN
767: oe_debug_pub.add( 'EXIT OE_HEADER_SCREDIT_SECURITY.ENTITY' , 1 ) ;
768: END IF;
769:
770: EXCEPTION
771: WHEN OTHERS THEN

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

794: l_rowtype_rec OE_AK_HEADER_SCREDITS_V%ROWTYPE;
795: l_column_name VARCHAR2(30);
796: l_check_all_cols_constraint VARCHAR2(1);
797: --
798: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
799: --
800: BEGIN
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'ENTER OE_HEADER_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;

Line 802: oe_debug_pub.add( 'ENTER OE_HEADER_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;

798: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
799: --
800: BEGIN
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'ENTER OE_HEADER_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;
803: END IF;
804:
805: -- Initializing return status to SUCCESS
806: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

829: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
830: l_operation := OE_PC_GLOBALS.UPDATE_OP;
831: ELSE
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
834: END IF;
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:

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

1198: END IF;
1199:
1200: IF OE_PC_GLOBALS.G_CHECK_UPDATE_ALL_FOR_DFF = 'N' THEN
1201: IF l_debug_level > 0 THEN
1202: oe_debug_pub.add( 'SETTING CHECK ALL COLS CONSTRAINT TO:'||L_CHECK_ALL_COLS_CONSTRAINT ) ;
1203: END IF;
1204: g_check_all_cols_constraint := l_check_all_cols_constraint;
1205: END IF;
1206:

Line 1212: oe_debug_pub.add( 'EXIT OE_HEADER_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;

1208: -- NOTE: Please add constraints check for new attributes before the
1209: -- descriptive flexfield attributes check.
1210:
1211: IF l_debug_level > 0 THEN
1212: oe_debug_pub.add( 'EXIT OE_HEADER_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;
1213: END IF;
1214:
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN