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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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:
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
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 ) ;
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;
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:
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:
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