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

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

13: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
14: l_temp_table num_tbl;
15: l_return_status VARCHAR2(30);
16: --
17: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18: --
19: BEGIN
20:
21: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 24: oe_debug_pub.add('Entering Delete_Created_Records ',1);

20:
21: l_return_status := FND_API.G_RET_STS_SUCCESS;
22:
23: IF l_debug_level > 0 THEN
24: oe_debug_pub.add('Entering Delete_Created_Records ',1);
25: END IF;
26:
27: -- Get created records
28:

Line 91: oe_debug_pub.add('Exiting Delete_Created_Records ',1);

87: l_temp_table.DELETE;
88: end if;
89:
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add('Exiting Delete_Created_Records ',1);
92: END IF;
93:
94: RETURN l_return_status;
95:

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

116: x_return_status OUT NOCOPY VARCHAR2
117: )
118: IS
119: l_return_status VARCHAR2(30);
120: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
121:
122: BEGIN
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add('Executing Versioning/Audit delayed request');

Line 124: oe_debug_pub.add('Executing Versioning/Audit delayed request');

120: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
121:
122: BEGIN
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add('Executing Versioning/Audit delayed request');
125: END IF;
126:
127: l_return_status := FND_API.G_RET_STS_SUCCESS;
128:

Line 162: oe_debug_pub.add('End Versioning/Audit Request '|| l_return_status);

158: END IF;
159: END IF;
160:
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add('End Versioning/Audit Request '|| l_return_status);
163: END IF;
164:
165: x_return_status := l_return_status;
166:

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

186: l_phase_change_flag VARCHAR2(1);
187: i NUMBER;
188:
189: --
190: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
191: --
192: BEGIN
193:
194: SAVEPOINT Perform_Versioning;

Line 201: oe_debug_pub.add('Entering Perform_Versioning ',1);

197: l_version_flag := 'N';
198: l_phase_change_flag := 'N';
199:
200: IF l_debug_level > 0 THEN
201: oe_debug_pub.add('Entering Perform_Versioning ',1);
202: END IF;
203:
204: IF (OE_GLOBALS.G_ROLL_VERSION = 'PV') THEN
205: l_version_flag := 'Y';

Line 307: oe_debug_pub.add('Not versioning because header was also created',1);

303: -- add g_header_created check to fix bug 3700341
304: IF OE_Order_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
305: OE_GLOBALS.G_HEADER_CREATED THEN
306: IF l_debug_level > 0 THEN
307: oe_debug_pub.add('Not versioning because header was also created',1);
308: END IF;
309:
310: x_return_status := l_return_status;
311:

Line 342: oe_debug_pub.add('Calling Create_Version_History ',1);

338: END IF;
339:
340: -- Record unchanged records
341: IF l_debug_level > 0 THEN
342: oe_debug_pub.add('Calling Create_Version_History ',1);
343: END IF;
344:
345: OE_Version_History_Util.Create_Version_History(p_header_id => p_header_id,
346: p_version_number => l_version_number,

Line 381: oe_debug_pub.add('Defaulting Versioning Reason if necessary');

377: OE_GLOBALS.G_DEFAULT_REASON) THEN
378:
379: IF OE_GLOBALS.G_DEFAULT_REASON THEN
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add('Defaulting Versioning Reason if necessary');
382: END IF;
383: OE_GLOBALS.G_REASON_CODE := nvl(OE_GLOBALS.G_REASON_CODE, 'SYSTEM');
384: END IF;
385:

Line 387: oe_debug_pub.add('Calling Apply_Reason ' || OE_GLOBALS.G_REASON_CODE,1);

383: OE_GLOBALS.G_REASON_CODE := nvl(OE_GLOBALS.G_REASON_CODE, 'SYSTEM');
384: END IF;
385:
386: IF l_debug_level > 0 THEN
387: oe_debug_pub.add('Calling Apply_Reason ' || OE_GLOBALS.G_REASON_CODE,1);
388: END IF;
389:
390: OE_Reasons_Util.Apply_Reason(
391: p_entity_code => 'HEADER',

Line 420: oe_debug_pub.add(' Updating version number, lock control ',1);

416: --Update l_version_number
417: IF (l_version_flag = 'Y') THEN
418:
419: IF l_debug_level > 0 THEN
420: oe_debug_pub.add(' Updating version number, lock control ',1);
421: END IF;
422: SELECT LOCK_CONTROL
423: INTO l_lock_control
424: FROM OE_ORDER_HEADERS_ALL

Line 440: oe_debug_pub.add(' Updating oe_order_cache.g_header_rec with version number, lock control ',1);

436:
437: /* update the order cache so that the header can be updated without requery
438: after creating a new version from line, bug 4523686*/
439: IF l_debug_level > 0 THEN
440: oe_debug_pub.add(' Updating oe_order_cache.g_header_rec with version number, lock control ',1);
441: END IF;
442: OE_ORDER_CACHE.g_header_rec.version_number := l_version_number + 1;
443: OE_ORDER_CACHE.g_header_rec.lock_control := l_lock_control + 1;
444:

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

611: l_header_id NUMBER;
612: l_version_number NUMBER;
613: l_reason_id NUMBER;
614: --
615: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
616: --
617: BEGIN
618:
619: SAVEPOINT Record_Changed_Records;

Line 623: oe_debug_pub.add('Entering OE_Versioning_util.record_changed_records ',1);

619: SAVEPOINT Record_Changed_Records;
620: l_return_status := FND_API.G_RET_STS_SUCCESS;
621:
622: IF l_debug_level > 0 THEN
623: oe_debug_pub.add('Entering OE_Versioning_util.record_changed_records ',1);
624: END IF;
625:
626: l_header_id := Get_Header_ID;
627:

Line 629: oe_debug_pub.add('OE_Versioning_Util header_id: ' || l_header_id,1);

625:
626: l_header_id := Get_Header_ID;
627:
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add('OE_Versioning_Util header_id: ' || l_header_id,1);
630: END IF;
631:
632: IF OE_ORDER_UTIL.g_old_header_rec.version_number IS NULL
633: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN

Line 640: oe_debug_pub.add('Before updating history ',1);

636: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
637: END IF;
638:
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add('Before updating history ',1);
641: END IF;
642:
643: --Update history with audit flag information gathered in global picture
644: IF OE_Order_Util.g_old_header_rec.header_id <> FND_API.G_MISS_NUM THEN

Line 672: oe_debug_pub.add('Applying Audit Reason Caused Error on Header',1);

668: x_return_status => l_return_status);
669:
670: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add('Applying Audit Reason Caused Error on Header',1);
673: END IF;
674:
675: if l_return_status = FND_API.G_RET_STS_ERROR then
676: raise FND_API.G_EXC_ERROR;

Line 685: oe_debug_pub.add('Calling recordheaderhist operation: '|| oe_order_util.g_old_header_rec.operation,1);

681:
682: end if; --end apply reason
683:
684: IF l_debug_level > 0 THEN
685: oe_debug_pub.add('Calling recordheaderhist operation: '|| oe_order_util.g_old_header_rec.operation,1);
686: END IF;
687:
688: OE_CHG_ORDER_PVT.RecordHeaderHist
689: ( p_header_id => oe_order_util.g_old_header_rec.header_id,

Line 707: oe_debug_pub.add('Inserting Header History Caused Error ',1);

703: );
704:
705: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add('Inserting Header History Caused Error ',1);
708: END IF;
709:
710: if l_return_status = FND_API.G_RET_STS_ERROR then
711: raise FND_API.G_EXC_ERROR;

Line 721: oe_debug_pub.add(' OEXUVERB: before recording lines ',1);

717: END IF;
718: END IF;
719:
720: IF l_debug_level > 0 THEN
721: oe_debug_pub.add(' OEXUVERB: before recording lines ',1);
722: END IF;
723:
724: --Update history for lines
725: i := oe_order_util.g_old_line_tbl.FIRST; -- get subscript of first element

Line 739: oe_debug_pub.add('audit flag :'||l_audit_flag);

735: l_hist_type_code := 'VERSIONING';
736: END IF;
737:
738: if l_debug_level > 0 then
739: oe_debug_pub.add('audit flag :'||l_audit_flag);
740: oe_debug_pub.add('hist type code :'||l_hist_type_code);
741: end if;
742:
743: if l_audit_flag = 'Y' and g_audit_line_id_tbl.exists(i) and

Line 740: oe_debug_pub.add('hist type code :'||l_hist_type_code);

736: END IF;
737:
738: if l_debug_level > 0 then
739: oe_debug_pub.add('audit flag :'||l_audit_flag);
740: oe_debug_pub.add('hist type code :'||l_hist_type_code);
741: end if;
742:
743: if l_audit_flag = 'Y' and g_audit_line_id_tbl.exists(i) and
744: (g_audit_line_id_tbl(i).reason_required

Line 770: oe_debug_pub.add('Applying Audit Reason Caused Error on Line',1);

766: x_return_status => l_return_status);
767:
768: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
769: IF l_debug_level > 0 THEN
770: oe_debug_pub.add('Applying Audit Reason Caused Error on Line',1);
771: END IF;
772:
773: if l_return_status = FND_API.G_RET_STS_ERROR then
774: raise FND_API.G_EXC_ERROR;

Line 783: oe_debug_pub.add('Calling recordlinehist operation: '|| oe_order_util.g_old_line_tbl(i).operation,1);

779:
780: end if; --end apply reason
781:
782: IF l_debug_level > 0 THEN
783: oe_debug_pub.add('Calling recordlinehist operation: '|| oe_order_util.g_old_line_tbl(i).operation,1);
784: END IF;
785:
786: OE_CHG_ORDER_PVT.RecordLineHist
787: (p_line_id => oe_order_util.g_old_line_tbl(i).line_id,

Line 801: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);

797: p_wf_activity_code => null,
798: p_wf_result_code => null,
799: x_return_status => l_return_status);
800: IF l_debug_level > 0 THEN
801: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
802: END IF;
803:
804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
805: IF l_debug_level > 0 THEN

Line 806: oe_debug_pub.add('Inserting Line Audit History error',1);

802: END IF;
803:
804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
805: IF l_debug_level > 0 THEN
806: oe_debug_pub.add('Inserting Line Audit History error',1);
807: END IF;
808: IF l_return_status = FND_API.G_RET_STS_ERROR then
809: raise FND_API.G_EXC_ERROR;
810: ELSE

Line 820: oe_debug_pub.add(' OEXUVERB: before recording header adjs ',1);

816: i := oe_order_util.g_old_line_tbl.NEXT(i); -- get subscript of next element
817: END LOOP;
818:
819: IF l_debug_level > 0 THEN
820: oe_debug_pub.add(' OEXUVERB: before recording header adjs ',1);
821: END IF;
822:
823: --Update history for header adj
824: i := oe_order_util.g_old_header_adj_tbl.FIRST; -- get subscript of first element

Line 853: oe_debug_pub.add('Applying Audit Reason Caused Error on Header Adj',1);

849: x_return_status => l_return_status);
850:
851: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add('Applying Audit Reason Caused Error on Header Adj',1);
854: END IF;
855:
856: if l_return_status = FND_API.G_RET_STS_ERROR then
857: raise FND_API.G_EXC_ERROR;

Line 866: oe_debug_pub.add('Calling recordHPAdjhist operation: '|| oe_order_util.g_old_header_adj_tbl(i).operation,1);

862:
863: end if; --end apply reason
864:
865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add('Calling recordHPAdjhist operation: '|| oe_order_util.g_old_header_adj_tbl(i).operation,1);
867: END IF;
868:
869: OE_CHG_ORDER_PVT.RecordHPAdjHist
870: (p_header_adj_id => oe_order_util.g_old_header_adj_tbl(i).price_adjustment_id,

Line 885: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);

881: p_wf_result_code => null,
882: x_return_status => l_return_status);
883:
884: IF l_debug_level > 0 THEN
885: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
886: END IF;
887: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
888: IF l_debug_level > 0 THEN
889: oe_debug_pub.add('Inserting Line Audit History error',1);

Line 889: oe_debug_pub.add('Inserting Line Audit History error',1);

885: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
886: END IF;
887: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
888: IF l_debug_level > 0 THEN
889: oe_debug_pub.add('Inserting Line Audit History error',1);
890: END IF;
891:
892: IF l_return_status = FND_API.G_RET_STS_ERROR then
893: raise FND_API.G_EXC_ERROR;

Line 905: oe_debug_pub.add(' OEXUVERB: before recording header scredits ',1);

901: END LOOP;
902:
903:
904: IF l_debug_level > 0 THEN
905: oe_debug_pub.add(' OEXUVERB: before recording header scredits ',1);
906: END IF;
907:
908: --Update history for header scredit
909: i := oe_order_util.g_old_header_scredit_tbl.FIRST; -- get subscript of first element

Line 938: oe_debug_pub.add('Applying Audit Reason Caused Error on Header Scredit',1);

934: x_return_status => l_return_status);
935:
936: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
937: IF l_debug_level > 0 THEN
938: oe_debug_pub.add('Applying Audit Reason Caused Error on Header Scredit',1);
939: END IF;
940:
941: if l_return_status = FND_API.G_RET_STS_ERROR then
942: raise FND_API.G_EXC_ERROR;

Line 951: oe_debug_pub.add('Calling recordHSCredithist operation: '|| oe_order_util.g_old_header_scredit_tbl(i).operation,1);

947:
948: end if; --end apply reason
949:
950: IF l_debug_level > 0 THEN
951: oe_debug_pub.add('Calling recordHSCredithist operation: '|| oe_order_util.g_old_header_scredit_tbl(i).operation,1);
952: END IF;
953:
954: OE_CHG_ORDER_PVT.RecordHSCreditHist
955: (p_header_scredit_id => oe_order_util.g_old_header_scredit_tbl(i).sales_credit_id,

Line 970: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);

966: p_wf_result_code => null,
967: x_return_status => l_return_status);
968:
969: IF l_debug_level > 0 THEN
970: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
971: END IF;
972: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
973: IF l_debug_level > 0 THEN
974: oe_debug_pub.add('Inserting Line Audit History error',1);

Line 974: oe_debug_pub.add('Inserting Line Audit History error',1);

970: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
971: END IF;
972: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
973: IF l_debug_level > 0 THEN
974: oe_debug_pub.add('Inserting Line Audit History error',1);
975: END IF;
976: IF l_return_status = FND_API.G_RET_STS_ERROR then
977: raise FND_API.G_EXC_ERROR;
978: ELSE

Line 988: oe_debug_pub.add(' OEXUVERB: before recording line adjs ',1);

984: i := oe_order_util.g_old_header_scredit_tbl.NEXT(i); -- get subscript of next element
985: END LOOP;
986:
987: IF l_debug_level > 0 THEN
988: oe_debug_pub.add(' OEXUVERB: before recording line adjs ',1);
989: END IF;
990: --Update history for line adj
991: i := oe_order_util.g_old_line_adj_tbl.FIRST; -- get subscript of first element
992: WHILE i IS NOT NULL LOOP

Line 1020: oe_debug_pub.add('Applying Audit Reason Caused Error on Line Adj',1);

1016: x_return_status => l_return_status);
1017:
1018: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1019: IF l_debug_level > 0 THEN
1020: oe_debug_pub.add('Applying Audit Reason Caused Error on Line Adj',1);
1021: END IF;
1022:
1023: if l_return_status = FND_API.G_RET_STS_ERROR then
1024: raise FND_API.G_EXC_ERROR;

Line 1033: oe_debug_pub.add('Calling recordLPAdjhist operation: '|| oe_order_util.g_old_line_adj_tbl(i).operation,1);

1029:
1030: end if; --end apply reason
1031:
1032: IF l_debug_level > 0 THEN
1033: oe_debug_pub.add('Calling recordLPAdjhist operation: '|| oe_order_util.g_old_line_adj_tbl(i).operation,1);
1034: END IF;
1035:
1036: OE_CHG_ORDER_PVT.RecordLPAdjHist
1037: (p_line_adj_id => oe_order_util.g_old_line_adj_tbl(i).price_adjustment_id,

Line 1052: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);

1048: p_wf_result_code => null,
1049: x_return_status => l_return_status);
1050:
1051: IF l_debug_level > 0 THEN
1052: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
1053: END IF;
1054: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1055: IF l_debug_level > 0 THEN
1056: oe_debug_pub.add('Inserting Line Audit History error',1);

Line 1056: oe_debug_pub.add('Inserting Line Audit History error',1);

1052: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
1053: END IF;
1054: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1055: IF l_debug_level > 0 THEN
1056: oe_debug_pub.add('Inserting Line Audit History error',1);
1057: END IF;
1058:
1059: IF l_return_status = FND_API.G_RET_STS_ERROR then
1060: raise FND_API.G_EXC_ERROR;

Line 1071: oe_debug_pub.add(' OEXUVERB: before recording line scredits ',1);

1067: i := oe_order_util.g_old_line_adj_tbl.NEXT(i); -- get subscript of next element
1068: END LOOP;
1069:
1070: IF l_debug_level > 0 THEN
1071: oe_debug_pub.add(' OEXUVERB: before recording line scredits ',1);
1072: END IF;
1073: --Update history for line scredit
1074: i := oe_order_util.g_old_line_scredit_tbl.FIRST; -- get subscript of first element
1075: WHILE i IS NOT NULL LOOP

Line 1103: oe_debug_pub.add('Applying Audit Reason Caused Error on Line Scredit',1);

1099: x_return_status => l_return_status);
1100:
1101: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1102: IF l_debug_level > 0 THEN
1103: oe_debug_pub.add('Applying Audit Reason Caused Error on Line Scredit',1);
1104: END IF;
1105:
1106: if l_return_status = FND_API.G_RET_STS_ERROR then
1107: raise FND_API.G_EXC_ERROR;

Line 1116: oe_debug_pub.add('Calling recordLSCredithist operation: '|| oe_order_util.g_old_line_scredit_tbl(i).operation,1);

1112:
1113: end if; --end apply reason
1114:
1115: IF l_debug_level > 0 THEN
1116: oe_debug_pub.add('Calling recordLSCredithist operation: '|| oe_order_util.g_old_line_scredit_tbl(i).operation,1);
1117: END IF;
1118:
1119: OE_CHG_ORDER_PVT.RecordLSCreditHist
1120: (p_line_scredit_id => oe_order_util.g_old_line_scredit_tbl(i).sales_credit_id,

Line 1135: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);

1131: p_wf_result_code => null,
1132: x_return_status => l_return_status);
1133:
1134: IF l_debug_level > 0 THEN
1135: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
1136: END IF;
1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1138: IF l_debug_level > 0 THEN
1139: oe_debug_pub.add('Inserting Line Audit History error',1);

Line 1139: oe_debug_pub.add('Inserting Line Audit History error',1);

1135: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
1136: END IF;
1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1138: IF l_debug_level > 0 THEN
1139: oe_debug_pub.add('Inserting Line Audit History error',1);
1140: END IF;
1141: IF l_return_status = FND_API.G_RET_STS_ERROR then
1142: raise FND_API.G_EXC_ERROR;
1143: ELSE

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

1174: Function Reset_Globals
1175: RETURN BOOLEAN
1176: IS
1177: --
1178: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1179: --
1180: BEGIN
1181:
1182: --Reset globals

Line 1184: oe_debug_pub.add(' OEXUVERB: reset_globals ',1);

1180: BEGIN
1181:
1182: --Reset globals
1183: IF l_debug_level > 0 THEN
1184: oe_debug_pub.add(' OEXUVERB: reset_globals ',1);
1185: END IF;
1186:
1187: OE_GLOBALS.G_ROLL_VERSION := 'N';
1188: OE_GLOBALS.G_CAPTURED_REASON := 'N';

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

1204: p_column_name IN VARCHAR2,
1205: p_on_operation_action IN NUMBER)
1206: IS
1207: --
1208: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1209: --
1210: BEGIN
1211: IF l_debug_level > 0 THEN
1212: oe_debug_pub.add(' OEXUVERB: check security ',1);

Line 1212: oe_debug_pub.add(' OEXUVERB: check security ',1);

1208: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1209: --
1210: BEGIN
1211: IF l_debug_level > 0 THEN
1212: oe_debug_pub.add(' OEXUVERB: check security ',1);
1213: oe_debug_pub.add(' OEXUVERB: gen_version action: '|| p_on_operation_action,1);
1214: END IF;
1215:
1216: -- added for bug 3518059

Line 1213: oe_debug_pub.add(' OEXUVERB: gen_version action: '|| p_on_operation_action,1);

1209: --
1210: BEGIN
1211: IF l_debug_level > 0 THEN
1212: oe_debug_pub.add(' OEXUVERB: check security ',1);
1213: oe_debug_pub.add(' OEXUVERB: gen_version action: '|| p_on_operation_action,1);
1214: END IF;
1215:
1216: -- added for bug 3518059
1217: -- add g_header_created check to fix bug 3700341

Line 1222: oe_debug_pub.add(' OEXUVERB: header is created, do nothing',1);

1218: if OE_Order_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
1219: OE_GLOBALS.G_HEADER_CREATED OR
1220: OE_Blanket_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE then
1221: IF l_debug_level > 0 THEN
1222: oe_debug_pub.add(' OEXUVERB: header is created, do nothing',1);
1223: END IF;
1224: else
1225: IF p_column_name = 'TRANSACTION_PHASE_CODE' AND
1226: OE_QUOTE_UTIL.G_COMPLETE_NEG = 'Y' THEN

Line 1249: oe_debug_pub.add(' OEXUVERB: gen_version roll: '|| oe_globals.g_roll_version,1);

1245: END IF;
1246: END IF;
1247: end if;
1248: IF l_debug_level > 0 THEN
1249: oe_debug_pub.add(' OEXUVERB: gen_version roll: '|| oe_globals.g_roll_version,1);
1250: END IF;
1251:
1252: END Check_Security;
1253:

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

1358: l_ind NUMBER;
1359: l_result VARCHAR2(1);
1360: l_return_stat VARCHAR2(1);
1361: --
1362: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1363: --
1364: BEGIN
1365:
1366: if l_debug_level > 0 then

Line 1367: oe_debug_pub.add('capture audit info');

1363: --
1364: BEGIN
1365:
1366: if l_debug_level > 0 then
1367: oe_debug_pub.add('capture audit info');
1368: oe_debug_pub.add('entity code :'||p_entity_code);
1369: oe_debug_pub.add('entity id :'||p_entity_id);
1370: oe_debug_pub.add('hist type :'||p_hist_type_code);
1371: end if;

Line 1368: oe_debug_pub.add('entity code :'||p_entity_code);

1364: BEGIN
1365:
1366: if l_debug_level > 0 then
1367: oe_debug_pub.add('capture audit info');
1368: oe_debug_pub.add('entity code :'||p_entity_code);
1369: oe_debug_pub.add('entity id :'||p_entity_id);
1370: oe_debug_pub.add('hist type :'||p_hist_type_code);
1371: end if;
1372:

Line 1369: oe_debug_pub.add('entity id :'||p_entity_id);

1365:
1366: if l_debug_level > 0 then
1367: oe_debug_pub.add('capture audit info');
1368: oe_debug_pub.add('entity code :'||p_entity_code);
1369: oe_debug_pub.add('entity id :'||p_entity_id);
1370: oe_debug_pub.add('hist type :'||p_hist_type_code);
1371: end if;
1372:
1373: IF p_entity_code <> OE_GLOBALS.G_ENTITY_HEADER THEN

Line 1370: oe_debug_pub.add('hist type :'||p_hist_type_code);

1366: if l_debug_level > 0 then
1367: oe_debug_pub.add('capture audit info');
1368: oe_debug_pub.add('entity code :'||p_entity_code);
1369: oe_debug_pub.add('entity id :'||p_entity_id);
1370: oe_debug_pub.add('hist type :'||p_hist_type_code);
1371: end if;
1372:
1373: IF p_entity_code <> OE_GLOBALS.G_ENTITY_HEADER THEN
1374: OE_Order_Util.Return_Glb_Ent_Index(