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

187: i NUMBER;
188: l_x_header_rec OE_Order_Pub.Header_Rec_Type; --Bug# 14084432
189:
190: --
191: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
192: --
193: BEGIN
194:
195: SAVEPOINT Perform_Versioning;

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

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

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

314: -- add g_header_created check to fix bug 3700341
315: IF OE_Order_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
316: OE_GLOBALS.G_HEADER_CREATED THEN
317: IF l_debug_level > 0 THEN
318: oe_debug_pub.add('Not versioning because header was also created',1);
319: END IF;
320:
321: x_return_status := l_return_status;
322:

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

349: END IF;
350:
351: -- Record unchanged records
352: IF l_debug_level > 0 THEN
353: oe_debug_pub.add('Calling Create_Version_History ',1);
354: END IF;
355:
356: OE_Version_History_Util.Create_Version_History(p_header_id => p_header_id,
357: p_version_number => l_version_number,

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

388: OE_GLOBALS.G_DEFAULT_REASON) THEN
389:
390: IF OE_GLOBALS.G_DEFAULT_REASON THEN
391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add('Defaulting Versioning Reason if necessary');
393: END IF;
394: OE_GLOBALS.G_REASON_CODE := nvl(OE_GLOBALS.G_REASON_CODE, 'SYSTEM');
395: END IF;
396:

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

394: OE_GLOBALS.G_REASON_CODE := nvl(OE_GLOBALS.G_REASON_CODE, 'SYSTEM');
395: END IF;
396:
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add('Calling Apply_Reason ' || OE_GLOBALS.G_REASON_CODE,1);
399: END IF;
400:
401: OE_Reasons_Util.Apply_Reason(
402: p_entity_code => 'HEADER',

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

427: --Update l_version_number
428: IF (l_version_flag = 'Y') THEN
429:
430: IF l_debug_level > 0 THEN
431: oe_debug_pub.add(' Updating version number, lock control ',1);
432: END IF;
433: --Adding for Bug# 14084432
434: OE_Header_Util.Lock_Row
435: (p_header_id => p_header_id

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

459:
460: /* update the order cache so that the header can be updated without requery
461: after creating a new version from line, bug 4523686*/
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add(' Updating oe_order_cache.g_header_rec with version number, lock control ',1);
464: END IF;
465: OE_ORDER_CACHE.g_header_rec.version_number := l_version_number + 1;
466: OE_ORDER_CACHE.g_header_rec.lock_control := l_lock_control + 1;
467:

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

634: l_header_id NUMBER;
635: l_version_number NUMBER;
636: l_reason_id NUMBER;
637: --
638: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
639: --
640: BEGIN
641:
642: SAVEPOINT Record_Changed_Records;

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

642: SAVEPOINT Record_Changed_Records;
643: l_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645: IF l_debug_level > 0 THEN
646: oe_debug_pub.add('Entering OE_Versioning_util.record_changed_records ',1);
647: END IF;
648:
649: l_header_id := Get_Header_ID;
650:

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

648:
649: l_header_id := Get_Header_ID;
650:
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add('OE_Versioning_Util header_id: ' || l_header_id,1);
653: END IF;
654:
655: IF OE_ORDER_UTIL.g_old_header_rec.version_number IS NULL
656: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN

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

659: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
660: END IF;
661:
662: IF l_debug_level > 0 THEN
663: oe_debug_pub.add('Before updating history ',1);
664: END IF;
665:
666: --Update history with audit flag information gathered in global picture
667: IF OE_Order_Util.g_old_header_rec.header_id <> FND_API.G_MISS_NUM THEN

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

691: x_return_status => l_return_status);
692:
693: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add('Applying Audit Reason Caused Error on Header',1);
696: END IF;
697:
698: if l_return_status = FND_API.G_RET_STS_ERROR then
699: raise FND_API.G_EXC_ERROR;

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

704:
705: end if; --end apply reason
706:
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add('Calling recordheaderhist operation: '|| oe_order_util.g_old_header_rec.operation,1);
709: END IF;
710:
711: OE_CHG_ORDER_PVT.RecordHeaderHist
712: ( p_header_id => oe_order_util.g_old_header_rec.header_id,

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

726: );
727:
728: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
729: IF l_debug_level > 0 THEN
730: oe_debug_pub.add('Inserting Header History Caused Error ',1);
731: END IF;
732:
733: if l_return_status = FND_API.G_RET_STS_ERROR then
734: raise FND_API.G_EXC_ERROR;

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

740: END IF;
741: END IF;
742:
743: IF l_debug_level > 0 THEN
744: oe_debug_pub.add(' OEXUVERB: before recording lines ',1);
745: END IF;
746:
747: --Update history for lines
748: i := oe_order_util.g_old_line_tbl.FIRST; -- get subscript of first element

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

758: l_hist_type_code := 'VERSIONING';
759: END IF;
760:
761: if l_debug_level > 0 then
762: oe_debug_pub.add('audit flag :'||l_audit_flag);
763: oe_debug_pub.add('hist type code :'||l_hist_type_code);
764: end if;
765:
766: if l_audit_flag = 'Y' and g_audit_line_id_tbl.exists(i) and

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

759: END IF;
760:
761: if l_debug_level > 0 then
762: oe_debug_pub.add('audit flag :'||l_audit_flag);
763: oe_debug_pub.add('hist type code :'||l_hist_type_code);
764: end if;
765:
766: if l_audit_flag = 'Y' and g_audit_line_id_tbl.exists(i) and
767: (g_audit_line_id_tbl(i).reason_required

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

789: x_return_status => l_return_status);
790:
791: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
792: IF l_debug_level > 0 THEN
793: oe_debug_pub.add('Applying Audit Reason Caused Error on Line',1);
794: END IF;
795:
796: if l_return_status = FND_API.G_RET_STS_ERROR then
797: raise FND_API.G_EXC_ERROR;

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

802:
803: end if; --end apply reason
804:
805: IF l_debug_level > 0 THEN
806: oe_debug_pub.add('Calling recordlinehist operation: '|| oe_order_util.g_old_line_tbl(i).operation,1);
807: END IF;
808:
809: OE_CHG_ORDER_PVT.RecordLineHist
810: (p_line_id => oe_order_util.g_old_line_tbl(i).line_id,

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

820: p_wf_activity_code => null,
821: p_wf_result_code => null,
822: x_return_status => l_return_status);
823: IF l_debug_level > 0 THEN
824: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
825: END IF;
826:
827: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
828: IF l_debug_level > 0 THEN

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

825: END IF;
826:
827: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add('Inserting Line Audit History error',1);
830: END IF;
831: IF l_return_status = FND_API.G_RET_STS_ERROR then
832: raise FND_API.G_EXC_ERROR;
833: ELSE

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

839: i := oe_order_util.g_old_line_tbl.NEXT(i); -- get subscript of next element
840: END LOOP;
841:
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add(' OEXUVERB: before recording header adjs ',1);
844: END IF;
845:
846: --Update history for header adj
847: i := oe_order_util.g_old_header_adj_tbl.FIRST; -- get subscript of first element

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

872: x_return_status => l_return_status);
873:
874: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
875: IF l_debug_level > 0 THEN
876: oe_debug_pub.add('Applying Audit Reason Caused Error on Header Adj',1);
877: END IF;
878:
879: if l_return_status = FND_API.G_RET_STS_ERROR then
880: raise FND_API.G_EXC_ERROR;

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

885:
886: end if; --end apply reason
887:
888: IF l_debug_level > 0 THEN
889: oe_debug_pub.add('Calling recordHPAdjhist operation: '|| oe_order_util.g_old_header_adj_tbl(i).operation,1);
890: END IF;
891:
892: OE_CHG_ORDER_PVT.RecordHPAdjHist
893: (p_header_adj_id => oe_order_util.g_old_header_adj_tbl(i).price_adjustment_id,

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

904: p_wf_result_code => null,
905: x_return_status => l_return_status);
906:
907: IF l_debug_level > 0 THEN
908: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
909: END IF;
910: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add('Inserting Line Audit History error',1);

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

908: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
909: END IF;
910: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
911: IF l_debug_level > 0 THEN
912: oe_debug_pub.add('Inserting Line Audit History error',1);
913: END IF;
914:
915: IF l_return_status = FND_API.G_RET_STS_ERROR then
916: raise FND_API.G_EXC_ERROR;

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

924: END LOOP;
925:
926:
927: IF l_debug_level > 0 THEN
928: oe_debug_pub.add(' OEXUVERB: before recording header scredits ',1);
929: END IF;
930:
931: --Update history for header scredit
932: i := oe_order_util.g_old_header_scredit_tbl.FIRST; -- get subscript of first element

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

957: x_return_status => l_return_status);
958:
959: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
960: IF l_debug_level > 0 THEN
961: oe_debug_pub.add('Applying Audit Reason Caused Error on Header Scredit',1);
962: END IF;
963:
964: if l_return_status = FND_API.G_RET_STS_ERROR then
965: raise FND_API.G_EXC_ERROR;

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

970:
971: end if; --end apply reason
972:
973: IF l_debug_level > 0 THEN
974: oe_debug_pub.add('Calling recordHSCredithist operation: '|| oe_order_util.g_old_header_scredit_tbl(i).operation,1);
975: END IF;
976:
977: OE_CHG_ORDER_PVT.RecordHSCreditHist
978: (p_header_scredit_id => oe_order_util.g_old_header_scredit_tbl(i).sales_credit_id,

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

989: p_wf_result_code => null,
990: x_return_status => l_return_status);
991:
992: IF l_debug_level > 0 THEN
993: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
994: END IF;
995: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
996: IF l_debug_level > 0 THEN
997: oe_debug_pub.add('Inserting Line Audit History error',1);

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

993: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
994: END IF;
995: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
996: IF l_debug_level > 0 THEN
997: oe_debug_pub.add('Inserting Line Audit History error',1);
998: END IF;
999: IF l_return_status = FND_API.G_RET_STS_ERROR then
1000: raise FND_API.G_EXC_ERROR;
1001: ELSE

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

1007: i := oe_order_util.g_old_header_scredit_tbl.NEXT(i); -- get subscript of next element
1008: END LOOP;
1009:
1010: IF l_debug_level > 0 THEN
1011: oe_debug_pub.add(' OEXUVERB: before recording line adjs ',1);
1012: END IF;
1013: --Update history for line adj
1014: i := oe_order_util.g_old_line_adj_tbl.FIRST; -- get subscript of first element
1015: WHILE i IS NOT NULL LOOP

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

1039: x_return_status => l_return_status);
1040:
1041: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1042: IF l_debug_level > 0 THEN
1043: oe_debug_pub.add('Applying Audit Reason Caused Error on Line Adj',1);
1044: END IF;
1045:
1046: if l_return_status = FND_API.G_RET_STS_ERROR then
1047: raise FND_API.G_EXC_ERROR;

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

1052:
1053: end if; --end apply reason
1054:
1055: IF l_debug_level > 0 THEN
1056: oe_debug_pub.add('Calling recordLPAdjhist operation: '|| oe_order_util.g_old_line_adj_tbl(i).operation,1);
1057: END IF;
1058:
1059: OE_CHG_ORDER_PVT.RecordLPAdjHist
1060: (p_line_adj_id => oe_order_util.g_old_line_adj_tbl(i).price_adjustment_id,

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

1071: p_wf_result_code => null,
1072: x_return_status => l_return_status);
1073:
1074: IF l_debug_level > 0 THEN
1075: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
1076: END IF;
1077: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1078: IF l_debug_level > 0 THEN
1079: oe_debug_pub.add('Inserting Line Audit History error',1);

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

1075: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
1076: END IF;
1077: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1078: IF l_debug_level > 0 THEN
1079: oe_debug_pub.add('Inserting Line Audit History error',1);
1080: END IF;
1081:
1082: IF l_return_status = FND_API.G_RET_STS_ERROR then
1083: raise FND_API.G_EXC_ERROR;

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

1090: i := oe_order_util.g_old_line_adj_tbl.NEXT(i); -- get subscript of next element
1091: END LOOP;
1092:
1093: IF l_debug_level > 0 THEN
1094: oe_debug_pub.add(' OEXUVERB: before recording line scredits ',1);
1095: END IF;
1096: --Update history for line scredit
1097: i := oe_order_util.g_old_line_scredit_tbl.FIRST; -- get subscript of first element
1098: WHILE i IS NOT NULL LOOP

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

1122: x_return_status => l_return_status);
1123:
1124: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add('Applying Audit Reason Caused Error on Line Scredit',1);
1127: END IF;
1128:
1129: if l_return_status = FND_API.G_RET_STS_ERROR then
1130: raise FND_API.G_EXC_ERROR;

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

1135:
1136: end if; --end apply reason
1137:
1138: IF l_debug_level > 0 THEN
1139: oe_debug_pub.add('Calling recordLSCredithist operation: '|| oe_order_util.g_old_line_scredit_tbl(i).operation,1);
1140: END IF;
1141:
1142: OE_CHG_ORDER_PVT.RecordLSCreditHist
1143: (p_line_scredit_id => oe_order_util.g_old_line_scredit_tbl(i).sales_credit_id,

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

1154: p_wf_result_code => null,
1155: x_return_status => l_return_status);
1156:
1157: IF l_debug_level > 0 THEN
1158: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
1159: END IF;
1160: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1161: IF l_debug_level > 0 THEN
1162: oe_debug_pub.add('Inserting Line Audit History error',1);

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

1158: OE_DEBUG_PUB.add('IN OEXUVERB:After'||l_return_status,5);
1159: END IF;
1160: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
1161: IF l_debug_level > 0 THEN
1162: oe_debug_pub.add('Inserting Line Audit History error',1);
1163: END IF;
1164: IF l_return_status = FND_API.G_RET_STS_ERROR then
1165: raise FND_API.G_EXC_ERROR;
1166: ELSE

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

1197: Function Reset_Globals
1198: RETURN BOOLEAN
1199: IS
1200: --
1201: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1202: --
1203: BEGIN
1204:
1205: --Reset globals

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

1203: BEGIN
1204:
1205: --Reset globals
1206: IF l_debug_level > 0 THEN
1207: oe_debug_pub.add(' OEXUVERB: reset_globals ',1);
1208: END IF;
1209:
1210: OE_GLOBALS.G_ROLL_VERSION := 'N';
1211: OE_GLOBALS.G_CAPTURED_REASON := 'N';

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

1227: p_column_name IN VARCHAR2,
1228: p_on_operation_action IN NUMBER)
1229: IS
1230: --
1231: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1232: --
1233: BEGIN
1234: IF l_debug_level > 0 THEN
1235: oe_debug_pub.add(' OEXUVERB: check security ',1);

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

1231: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1232: --
1233: BEGIN
1234: IF l_debug_level > 0 THEN
1235: oe_debug_pub.add(' OEXUVERB: check security ',1);
1236: oe_debug_pub.add(' OEXUVERB: gen_version action: '|| p_on_operation_action,1);
1237: END IF;
1238:
1239: -- added for bug 3518059

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

1232: --
1233: BEGIN
1234: IF l_debug_level > 0 THEN
1235: oe_debug_pub.add(' OEXUVERB: check security ',1);
1236: oe_debug_pub.add(' OEXUVERB: gen_version action: '|| p_on_operation_action,1);
1237: END IF;
1238:
1239: -- added for bug 3518059
1240: -- add g_header_created check to fix bug 3700341

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

1241: if OE_Order_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
1242: OE_GLOBALS.G_HEADER_CREATED OR
1243: OE_Blanket_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE then
1244: IF l_debug_level > 0 THEN
1245: oe_debug_pub.add(' OEXUVERB: header is created, do nothing',1);
1246: END IF;
1247: else
1248: IF p_column_name = 'TRANSACTION_PHASE_CODE' AND
1249: OE_QUOTE_UTIL.G_COMPLETE_NEG = 'Y' THEN

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

1268: END IF;
1269: END IF;
1270: end if;
1271: IF l_debug_level > 0 THEN
1272: oe_debug_pub.add(' OEXUVERB: gen_version roll: '|| oe_globals.g_roll_version,1);
1273: END IF;
1274:
1275: END Check_Security;
1276:

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

1381: l_ind NUMBER;
1382: l_result VARCHAR2(1);
1383: l_return_stat VARCHAR2(1);
1384: --
1385: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1386: --
1387: BEGIN
1388:
1389: if l_debug_level > 0 then

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

1386: --
1387: BEGIN
1388:
1389: if l_debug_level > 0 then
1390: oe_debug_pub.add('capture audit info');
1391: oe_debug_pub.add('entity code :'||p_entity_code);
1392: oe_debug_pub.add('entity id :'||p_entity_id);
1393: oe_debug_pub.add('hist type :'||p_hist_type_code);
1394: end if;

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

1387: BEGIN
1388:
1389: if l_debug_level > 0 then
1390: oe_debug_pub.add('capture audit info');
1391: oe_debug_pub.add('entity code :'||p_entity_code);
1392: oe_debug_pub.add('entity id :'||p_entity_id);
1393: oe_debug_pub.add('hist type :'||p_hist_type_code);
1394: end if;
1395:

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

1388:
1389: if l_debug_level > 0 then
1390: oe_debug_pub.add('capture audit info');
1391: oe_debug_pub.add('entity code :'||p_entity_code);
1392: oe_debug_pub.add('entity id :'||p_entity_id);
1393: oe_debug_pub.add('hist type :'||p_hist_type_code);
1394: end if;
1395:
1396: IF p_entity_code <> OE_GLOBALS.G_ENTITY_HEADER THEN

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

1389: if l_debug_level > 0 then
1390: oe_debug_pub.add('capture audit info');
1391: oe_debug_pub.add('entity code :'||p_entity_code);
1392: oe_debug_pub.add('entity id :'||p_entity_id);
1393: oe_debug_pub.add('hist type :'||p_hist_type_code);
1394: end if;
1395:
1396: IF p_entity_code <> OE_GLOBALS.G_ENTITY_HEADER THEN
1397: OE_Order_Util.Return_Glb_Ent_Index(