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_GLOBALS

Line 31: if oe_order_util.g_old_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then

27: -- Get created records
28:
29: i := oe_order_util.g_old_line_tbl.FIRST; -- get subscript of first element
30: WHILE i IS NOT NULL LOOP
31: if oe_order_util.g_old_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then
32: l_temp_table(l_temp_table.count + 1) := oe_order_util.g_old_line_tbl(i).line_id;
33: end if;
34: i := oe_order_util.g_old_line_tbl.NEXT(i); -- get subscript of next element
35: END LOOP;

Line 46: if oe_order_util.g_old_header_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then

42: end if;
43:
44: i := oe_order_util.g_old_header_adj_tbl.FIRST;
45: WHILE i IS NOT NULL LOOP
46: if oe_order_util.g_old_header_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then
47: l_temp_table(l_temp_table.count + 1) := oe_order_util.g_old_header_adj_tbl(i).price_adjustment_id;
48: end if;
49: i := oe_order_util.g_old_header_adj_tbl.NEXT(i);
50: END LOOP;

Line 54: if oe_order_util.g_old_line_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then

50: END LOOP;
51:
52: i := oe_order_util.g_old_line_adj_tbl.FIRST;
53: WHILE i IS NOT NULL LOOP
54: if oe_order_util.g_old_line_adj_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then
55: l_temp_table(l_temp_table.count + 1) := oe_order_util.g_old_line_adj_tbl(i).price_adjustment_id;
56: end if;
57: i := oe_order_util.g_old_line_adj_tbl.NEXT(i);
58: END LOOP;

Line 69: if oe_order_util.g_old_header_scredit_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then

65: end if;
66:
67: i := oe_order_util.g_old_header_scredit_tbl.FIRST;
68: WHILE i IS NOT NULL LOOP
69: if oe_order_util.g_old_header_scredit_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then
70: l_temp_table(l_temp_table.count + 1) := oe_order_util.g_old_header_scredit_tbl(i).sales_credit_id;
71: end if;
72: i := oe_order_util.g_old_header_scredit_tbl.NEXT(i);
73: END LOOP;

Line 77: if oe_order_util.g_old_line_scredit_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then

73: END LOOP;
74:
75: i := oe_order_util.g_old_line_scredit_tbl.FIRST;
76: WHILE i IS NOT NULL LOOP
77: if oe_order_util.g_old_line_scredit_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE then
78: l_temp_table(l_temp_table.count + 1) := oe_order_util.g_old_line_scredit_tbl(i).sales_credit_id;
79: end if;
80: i := oe_order_util.g_old_line_scredit_tbl.NEXT(i);
81: END LOOP;

Line 129: IF OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN

125: END IF;
126:
127: l_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129: IF OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
130: Perform_Versioning (p_header_id => p_header_id,
131: p_document_type => p_document_type,
132: p_changed_attribute => p_changed_attribute,
133: x_msg_count => x_msg_count,

Line 204: IF (OE_GLOBALS.G_ROLL_VERSION = 'PV') THEN

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';
206: l_phase_change_flag := 'Y';
207: IF (p_document_type <> 'BLANKETS') THEN
208: IF OE_ORDER_UTIL.g_old_header_rec.version_number IS NULL

Line 215: ELSIF (OE_GLOBALS.G_ROLL_VERSION = 'P') THEN

211: ELSE
212: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
213: END IF;
214: END IF;
215: ELSIF (OE_GLOBALS.G_ROLL_VERSION = 'P') THEN
216: l_version_flag := 'N';
217: l_phase_change_flag := 'Y';
218: ELSE
219: l_phase_change_flag := 'N';

Line 250: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

246: SET VERSION_NUMBER = l_version_number + 1,
247: LOCK_CONTROL = l_lock_control + 1
248: WHERE HEADER_ID = p_header_id;
249:
250: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
251: ELSIF l_version_number < OE_Blanket_Util.g_old_header_hist_rec.version_number THEN
252: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_REVISION_NUM');
253: OE_MSG_PUB.ADD;
254:

Line 260: IF OE_GLOBALS.G_CAPTURED_REASON = 'Y' AND

256: END IF;
257: END IF;
258:
259: --Apply reason changes
260: IF OE_GLOBALS.G_CAPTURED_REASON = 'Y' AND
261: OE_GLOBALS.G_REASON_CODE <> FND_API.G_MISS_CHAR THEN
262: OE_Reasons_Util.Apply_Reason(
263: p_entity_code => 'BLANKET_HEADER',
264: p_entity_id => p_header_id,

Line 261: OE_GLOBALS.G_REASON_CODE <> FND_API.G_MISS_CHAR THEN

257: END IF;
258:
259: --Apply reason changes
260: IF OE_GLOBALS.G_CAPTURED_REASON = 'Y' AND
261: OE_GLOBALS.G_REASON_CODE <> FND_API.G_MISS_CHAR THEN
262: OE_Reasons_Util.Apply_Reason(
263: p_entity_code => 'BLANKET_HEADER',
264: p_entity_id => p_header_id,
265: p_header_id => p_header_id,

Line 268: p_reason_code => OE_GLOBALS.G_REASON_CODE,

264: p_entity_id => p_header_id,
265: p_header_id => p_header_id,
266: p_version_number => OE_Blanket_Util.g_old_header_hist_rec.version_number,
267: p_reason_type => 'CANCEL_CODE',
268: p_reason_code => OE_GLOBALS.G_REASON_CODE,
269: p_reason_comments => OE_GLOBALS.G_REASON_COMMENTS,
270: x_reason_id => l_reason_id,
271: x_return_status => l_return_status);
272:

Line 269: p_reason_comments => OE_GLOBALS.G_REASON_COMMENTS,

265: p_header_id => p_header_id,
266: p_version_number => OE_Blanket_Util.g_old_header_hist_rec.version_number,
267: p_reason_type => 'CANCEL_CODE',
268: p_reason_code => OE_GLOBALS.G_REASON_CODE,
269: p_reason_comments => OE_GLOBALS.G_REASON_COMMENTS,
270: x_reason_id => l_reason_id,
271: x_return_status => l_return_status);
272:
273: UPDATE OE_BLANKET_HEADERS_HIST

Line 279: ELSIF OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN

275: WHERE phase_change_flag = l_phase_change_flag
276: AND version_flag = l_version_flag
277: AND version_number = OE_Blanket_Util.g_old_header_hist_rec.version_number;
278:
279: ELSIF OE_GLOBALS.G_CAPTURED_REASON = 'V' THEN
280: FND_MESSAGE.SET_NAME('ONT','OE_AUDIT_REASON_RQD');
281: OE_MSG_PUB.ADD;
282:
283: RAISE FND_API.G_EXC_ERROR;

Line 304: IF OE_Order_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR

300:
301:
302: -- Return if header is created in same operation
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;

Line 305: OE_GLOBALS.G_HEADER_CREATED THEN

301:
302: -- Return if header is created in same operation
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:

Line 360: IF OE_GLOBALS.G_REASON_CODE IS NULL OR

356:
357: l_return_status := Delete_Created_Records;
358:
359: IF IS_REASON_RQD <> 'N' THEN
360: IF OE_GLOBALS.G_REASON_CODE IS NULL OR
361: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN
362: -- Get stored reason in event of SYSTEM change
363: Get_Reason_Info(x_reason_code => OE_GLOBALS.G_REASON_CODE,
364: x_reason_comments => OE_GLOBALS.G_REASON_COMMENTS);

Line 361: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN

357: l_return_status := Delete_Created_Records;
358:
359: IF IS_REASON_RQD <> 'N' THEN
360: IF OE_GLOBALS.G_REASON_CODE IS NULL OR
361: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN
362: -- Get stored reason in event of SYSTEM change
363: Get_Reason_Info(x_reason_code => OE_GLOBALS.G_REASON_CODE,
364: x_reason_comments => OE_GLOBALS.G_REASON_COMMENTS);
365:

Line 363: Get_Reason_Info(x_reason_code => OE_GLOBALS.G_REASON_CODE,

359: IF IS_REASON_RQD <> 'N' THEN
360: IF OE_GLOBALS.G_REASON_CODE IS NULL OR
361: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN
362: -- Get stored reason in event of SYSTEM change
363: Get_Reason_Info(x_reason_code => OE_GLOBALS.G_REASON_CODE,
364: x_reason_comments => OE_GLOBALS.G_REASON_COMMENTS);
365:
366: IF OE_GLOBALS.G_REASON_CODE IS NOT NULL OR
367: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN

Line 364: x_reason_comments => OE_GLOBALS.G_REASON_COMMENTS);

360: IF OE_GLOBALS.G_REASON_CODE IS NULL OR
361: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN
362: -- Get stored reason in event of SYSTEM change
363: Get_Reason_Info(x_reason_code => OE_GLOBALS.G_REASON_CODE,
364: x_reason_comments => OE_GLOBALS.G_REASON_COMMENTS);
365:
366: IF OE_GLOBALS.G_REASON_CODE IS NOT NULL OR
367: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN
368: OE_GLOBALS.G_CAPTURED_REASON := 'Y';

Line 366: IF OE_GLOBALS.G_REASON_CODE IS NOT NULL OR

362: -- Get stored reason in event of SYSTEM change
363: Get_Reason_Info(x_reason_code => OE_GLOBALS.G_REASON_CODE,
364: x_reason_comments => OE_GLOBALS.G_REASON_COMMENTS);
365:
366: IF OE_GLOBALS.G_REASON_CODE IS NOT NULL OR
367: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN
368: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
369: END IF;
370: END IF;

Line 367: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN

363: Get_Reason_Info(x_reason_code => OE_GLOBALS.G_REASON_CODE,
364: x_reason_comments => OE_GLOBALS.G_REASON_COMMENTS);
365:
366: IF OE_GLOBALS.G_REASON_CODE IS NOT NULL OR
367: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN
368: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
369: END IF;
370: END IF;
371: END IF;

Line 368: OE_GLOBALS.G_CAPTURED_REASON := 'Y';

364: x_reason_comments => OE_GLOBALS.G_REASON_COMMENTS);
365:
366: IF OE_GLOBALS.G_REASON_CODE IS NOT NULL OR
367: OE_GLOBALS.G_REASON_CODE = FND_API.G_MISS_CHAR THEN
368: OE_GLOBALS.G_CAPTURED_REASON := 'Y';
369: END IF;
370: END IF;
371: END IF;
372:

Line 375: OE_GLOBALS.G_REASON_CODE <> FND_API.G_MISS_CHAR) OR

371: END IF;
372:
373: --Apply reason changes
374: IF (IS_REASON_RQD = 'Y' AND
375: OE_GLOBALS.G_REASON_CODE <> FND_API.G_MISS_CHAR) OR
376: (IS_REASON_RQD <> 'N' AND
377: OE_GLOBALS.G_DEFAULT_REASON) THEN
378:
379: IF OE_GLOBALS.G_DEFAULT_REASON THEN

Line 377: OE_GLOBALS.G_DEFAULT_REASON) THEN

373: --Apply reason changes
374: IF (IS_REASON_RQD = 'Y' AND
375: OE_GLOBALS.G_REASON_CODE <> FND_API.G_MISS_CHAR) OR
376: (IS_REASON_RQD <> 'N' AND
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');

Line 379: IF OE_GLOBALS.G_DEFAULT_REASON THEN

375: OE_GLOBALS.G_REASON_CODE <> FND_API.G_MISS_CHAR) OR
376: (IS_REASON_RQD <> 'N' AND
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');

Line 383: OE_GLOBALS.G_REASON_CODE := nvl(OE_GLOBALS.G_REASON_CODE, 'SYSTEM');

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:
386: IF l_debug_level > 0 THEN
387: oe_debug_pub.add('Calling Apply_Reason ' || OE_GLOBALS.G_REASON_CODE,1);

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 395: p_reason_type => nvl(OE_GLOBALS.G_REASON_TYPE, 'CANCEL_CODE'),

391: p_entity_code => 'HEADER',
392: p_entity_id => p_header_id,
393: p_header_id => p_header_id,
394: p_version_number => l_version_number,
395: p_reason_type => nvl(OE_GLOBALS.G_REASON_TYPE, 'CANCEL_CODE'),
396: p_reason_code => OE_GLOBALS.G_REASON_CODE,
397: p_reason_comments => OE_GLOBALS.G_REASON_COMMENTS,
398: x_reason_id => l_reason_id,
399: x_return_status => l_return_status);

Line 396: p_reason_code => OE_GLOBALS.G_REASON_CODE,

392: p_entity_id => p_header_id,
393: p_header_id => p_header_id,
394: p_version_number => l_version_number,
395: p_reason_type => nvl(OE_GLOBALS.G_REASON_TYPE, 'CANCEL_CODE'),
396: p_reason_code => OE_GLOBALS.G_REASON_CODE,
397: p_reason_comments => OE_GLOBALS.G_REASON_COMMENTS,
398: x_reason_id => l_reason_id,
399: x_return_status => l_return_status);
400:

Line 397: p_reason_comments => OE_GLOBALS.G_REASON_COMMENTS,

393: p_header_id => p_header_id,
394: p_version_number => l_version_number,
395: p_reason_type => nvl(OE_GLOBALS.G_REASON_TYPE, 'CANCEL_CODE'),
396: p_reason_code => OE_GLOBALS.G_REASON_CODE,
397: p_reason_comments => OE_GLOBALS.G_REASON_COMMENTS,
398: x_reason_id => l_reason_id,
399: x_return_status => l_return_status);
400:
401: UPDATE OE_ORDER_HEADER_HISTORY

Line 445: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;

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:
445: OE_GLOBALS.G_CASCADING_REQUEST_LOGGED := TRUE;
446: ELSIF OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER < OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER THEN
447: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_REVISION_NUM');
448: OE_MSG_PUB.ADD;
449:

Line 645: IF NOT OE_GLOBALS.Equal(OE_Order_Util.g_old_header_rec.operation, OE_GLOBALS.G_OPR_CREATE) AND

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
645: IF NOT OE_GLOBALS.Equal(OE_Order_Util.g_old_header_rec.operation, OE_GLOBALS.G_OPR_CREATE) AND
646: (p_version_flag = 'Y' OR p_phase_change_flag = 'Y' or
647: g_audit_header_hist_code IS NOT NULL) THEN
648:
649: IF g_audit_header_hist_code IS NOT NULL THEN

Line 727: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_line_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND

723:
724: --Update history for lines
725: i := oe_order_util.g_old_line_tbl.FIRST; -- get subscript of first element
726: WHILE i IS NOT NULL LOOP
727: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_line_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND
728: (p_version_flag = 'Y' OR p_phase_change_flag = 'Y' or
729: g_audit_line_id_tbl.exists(i)) THEN
730: IF g_audit_line_id_tbl.exists(i) THEN
731: l_audit_flag := 'Y';

Line 826: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_header_adj_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND

822:
823: --Update history for header adj
824: i := oe_order_util.g_old_header_adj_tbl.FIRST; -- get subscript of first element
825: WHILE i IS NOT NULL LOOP
826: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_header_adj_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND
827: (p_version_flag = 'Y' OR p_phase_change_flag = 'Y' or
828: g_audit_header_adj_id_tbl.exists(i)) THEN
829: IF g_audit_header_adj_id_tbl.exists(i) THEN
830: l_audit_flag := 'Y';

Line 873: p_reason_code => oe_globals.g_reason_code,

869: OE_CHG_ORDER_PVT.RecordHPAdjHist
870: (p_header_adj_id => oe_order_util.g_old_header_adj_tbl(i).price_adjustment_id,
871: p_header_adj_rec => oe_order_util.g_old_header_adj_tbl(i),
872: p_hist_type_code => l_hist_type_code,
873: p_reason_code => oe_globals.g_reason_code,
874: p_comments => oe_globals.g_reason_comments,
875: p_audit_flag => l_audit_flag,
876: p_version_flag => p_version_flag,
877: p_phase_change_flag => p_phase_change_flag,

Line 874: p_comments => oe_globals.g_reason_comments,

870: (p_header_adj_id => oe_order_util.g_old_header_adj_tbl(i).price_adjustment_id,
871: p_header_adj_rec => oe_order_util.g_old_header_adj_tbl(i),
872: p_hist_type_code => l_hist_type_code,
873: p_reason_code => oe_globals.g_reason_code,
874: p_comments => oe_globals.g_reason_comments,
875: p_audit_flag => l_audit_flag,
876: p_version_flag => p_version_flag,
877: p_phase_change_flag => p_phase_change_flag,
878: p_version_number => l_version_number,

Line 911: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_header_scredit_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND

907:
908: --Update history for header scredit
909: i := oe_order_util.g_old_header_scredit_tbl.FIRST; -- get subscript of first element
910: WHILE i IS NOT NULL LOOP
911: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_header_scredit_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND
912: (p_version_flag = 'Y' OR p_phase_change_flag = 'Y' or
913: g_audit_header_scredit_id_tbl.exists(i)) THEN
914: IF g_audit_header_scredit_id_tbl.exists(i) THEN
915: l_audit_flag := 'Y';

Line 958: p_reason_code => oe_globals.g_reason_code,

954: OE_CHG_ORDER_PVT.RecordHSCreditHist
955: (p_header_scredit_id => oe_order_util.g_old_header_scredit_tbl(i).sales_credit_id,
956: p_header_scredit_rec => oe_order_util.g_old_header_scredit_tbl(i),
957: p_hist_type_code => l_hist_type_code,
958: p_reason_code => oe_globals.g_reason_code,
959: p_comments => oe_globals.g_reason_comments,
960: p_audit_flag => l_audit_flag,
961: p_version_flag => p_version_flag,
962: p_phase_change_flag => p_phase_change_flag,

Line 959: p_comments => oe_globals.g_reason_comments,

955: (p_header_scredit_id => oe_order_util.g_old_header_scredit_tbl(i).sales_credit_id,
956: p_header_scredit_rec => oe_order_util.g_old_header_scredit_tbl(i),
957: p_hist_type_code => l_hist_type_code,
958: p_reason_code => oe_globals.g_reason_code,
959: p_comments => oe_globals.g_reason_comments,
960: p_audit_flag => l_audit_flag,
961: p_version_flag => p_version_flag,
962: p_phase_change_flag => p_phase_change_flag,
963: p_version_number => l_version_number,

Line 993: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_line_adj_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND

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
993: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_line_adj_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND
994: (p_version_flag = 'Y' OR p_phase_change_flag = 'Y' or
995: g_audit_line_adj_id_tbl.exists(i)) THEN
996: IF g_audit_line_adj_id_tbl.exists(i) THEN
997: l_audit_flag := 'Y';

Line 1040: p_reason_code => oe_globals.g_reason_code,

1036: OE_CHG_ORDER_PVT.RecordLPAdjHist
1037: (p_line_adj_id => oe_order_util.g_old_line_adj_tbl(i).price_adjustment_id,
1038: p_line_adj_rec => oe_order_util.g_old_line_adj_tbl(i),
1039: p_hist_type_code => l_hist_type_code,
1040: p_reason_code => oe_globals.g_reason_code,
1041: p_comments => oe_globals.g_reason_comments,
1042: p_audit_flag => l_audit_flag,
1043: p_version_flag => p_version_flag,
1044: p_phase_change_flag => p_phase_change_flag,

Line 1041: p_comments => oe_globals.g_reason_comments,

1037: (p_line_adj_id => oe_order_util.g_old_line_adj_tbl(i).price_adjustment_id,
1038: p_line_adj_rec => oe_order_util.g_old_line_adj_tbl(i),
1039: p_hist_type_code => l_hist_type_code,
1040: p_reason_code => oe_globals.g_reason_code,
1041: p_comments => oe_globals.g_reason_comments,
1042: p_audit_flag => l_audit_flag,
1043: p_version_flag => p_version_flag,
1044: p_phase_change_flag => p_phase_change_flag,
1045: p_version_number => l_version_number,

Line 1076: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_line_scredit_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND

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
1076: IF NOT OE_GLOBALS.Equal(oe_order_util.g_old_line_scredit_tbl(i).operation, OE_GLOBALS.G_OPR_CREATE) AND
1077: (p_version_flag = 'Y' OR p_phase_change_flag = 'Y' or
1078: g_audit_line_scredit_id_tbl.exists(i)) THEN
1079: IF g_audit_line_scredit_id_tbl.exists(i) THEN
1080: l_audit_flag := 'Y';

Line 1123: p_reason_code => oe_globals.g_reason_code,

1119: OE_CHG_ORDER_PVT.RecordLSCreditHist
1120: (p_line_scredit_id => oe_order_util.g_old_line_scredit_tbl(i).sales_credit_id,
1121: p_line_scredit_rec => oe_order_util.g_old_line_scredit_tbl(i),
1122: p_hist_type_code => l_hist_type_code,
1123: p_reason_code => oe_globals.g_reason_code,
1124: p_comments => oe_globals.g_reason_comments,
1125: p_audit_flag => l_audit_flag,
1126: p_version_flag => p_version_flag,
1127: p_phase_change_flag => p_phase_change_flag,

Line 1124: p_comments => oe_globals.g_reason_comments,

1120: (p_line_scredit_id => oe_order_util.g_old_line_scredit_tbl(i).sales_credit_id,
1121: p_line_scredit_rec => oe_order_util.g_old_line_scredit_tbl(i),
1122: p_hist_type_code => l_hist_type_code,
1123: p_reason_code => oe_globals.g_reason_code,
1124: p_comments => oe_globals.g_reason_comments,
1125: p_audit_flag => l_audit_flag,
1126: p_version_flag => p_version_flag,
1127: p_phase_change_flag => p_phase_change_flag,
1128: p_version_number => l_version_number,

Line 1187: OE_GLOBALS.G_ROLL_VERSION := 'N';

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';
1189: OE_GLOBALS.G_REASON_CODE := NULL;
1190: OE_GLOBALS.G_REASON_COMMENTS := NULL;
1191: OE_GLOBALS.G_REASON_TYPE := NULL;

Line 1188: OE_GLOBALS.G_CAPTURED_REASON := 'N';

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';
1189: OE_GLOBALS.G_REASON_CODE := NULL;
1190: OE_GLOBALS.G_REASON_COMMENTS := NULL;
1191: OE_GLOBALS.G_REASON_TYPE := NULL;
1192: G_Audit_Line_ID_Tbl.DELETE;

Line 1189: OE_GLOBALS.G_REASON_CODE := NULL;

1185: END IF;
1186:
1187: OE_GLOBALS.G_ROLL_VERSION := 'N';
1188: OE_GLOBALS.G_CAPTURED_REASON := 'N';
1189: OE_GLOBALS.G_REASON_CODE := NULL;
1190: OE_GLOBALS.G_REASON_COMMENTS := NULL;
1191: OE_GLOBALS.G_REASON_TYPE := NULL;
1192: G_Audit_Line_ID_Tbl.DELETE;
1193: G_Audit_Header_Adj_ID_Tbl.DELETE;

Line 1190: OE_GLOBALS.G_REASON_COMMENTS := NULL;

1186:
1187: OE_GLOBALS.G_ROLL_VERSION := 'N';
1188: OE_GLOBALS.G_CAPTURED_REASON := 'N';
1189: OE_GLOBALS.G_REASON_CODE := NULL;
1190: OE_GLOBALS.G_REASON_COMMENTS := NULL;
1191: OE_GLOBALS.G_REASON_TYPE := NULL;
1192: G_Audit_Line_ID_Tbl.DELETE;
1193: G_Audit_Header_Adj_ID_Tbl.DELETE;
1194: G_Audit_Line_Adj_ID_Tbl.DELETE;

Line 1191: OE_GLOBALS.G_REASON_TYPE := NULL;

1187: OE_GLOBALS.G_ROLL_VERSION := 'N';
1188: OE_GLOBALS.G_CAPTURED_REASON := 'N';
1189: OE_GLOBALS.G_REASON_CODE := NULL;
1190: OE_GLOBALS.G_REASON_COMMENTS := NULL;
1191: OE_GLOBALS.G_REASON_TYPE := NULL;
1192: G_Audit_Line_ID_Tbl.DELETE;
1193: G_Audit_Header_Adj_ID_Tbl.DELETE;
1194: G_Audit_Line_Adj_ID_Tbl.DELETE;
1195: G_Audit_Header_Scredit_ID_Tbl.DELETE;

Line 1218: if OE_Order_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR

1214: END IF;
1215:
1216: -- added for bug 3518059
1217: -- add g_header_created check to fix bug 3700341
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);

Line 1219: OE_GLOBALS.G_HEADER_CREATED OR

1215:
1216: -- added for bug 3518059
1217: -- add g_header_created check to fix bug 3700341
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;

Line 1220: OE_Blanket_Util.g_header_rec.operation = OE_GLOBALS.G_OPR_CREATE then

1216: -- added for bug 3518059
1217: -- add g_header_created check to fix bug 3700341
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

Line 1228: IF OE_GLOBALS.G_ROLL_VERSION = 'Y' THEN

1224: else
1225: IF p_column_name = 'TRANSACTION_PHASE_CODE' AND
1226: OE_QUOTE_UTIL.G_COMPLETE_NEG = 'Y' THEN
1227: --if transaction_phase is changing
1228: IF OE_GLOBALS.G_ROLL_VERSION = 'Y' THEN
1229: OE_GLOBALS.G_ROLL_VERSION := 'PV';
1230: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1231: OE_GLOBALS.G_ROLL_VERSION := 'P';
1232: END IF;

Line 1229: OE_GLOBALS.G_ROLL_VERSION := 'PV';

1225: IF p_column_name = 'TRANSACTION_PHASE_CODE' AND
1226: OE_QUOTE_UTIL.G_COMPLETE_NEG = 'Y' THEN
1227: --if transaction_phase is changing
1228: IF OE_GLOBALS.G_ROLL_VERSION = 'Y' THEN
1229: OE_GLOBALS.G_ROLL_VERSION := 'PV';
1230: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1231: OE_GLOBALS.G_ROLL_VERSION := 'P';
1232: END IF;
1233: END IF;

Line 1230: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN

1226: OE_QUOTE_UTIL.G_COMPLETE_NEG = 'Y' THEN
1227: --if transaction_phase is changing
1228: IF OE_GLOBALS.G_ROLL_VERSION = 'Y' THEN
1229: OE_GLOBALS.G_ROLL_VERSION := 'PV';
1230: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1231: OE_GLOBALS.G_ROLL_VERSION := 'P';
1232: END IF;
1233: END IF;
1234:

Line 1231: OE_GLOBALS.G_ROLL_VERSION := 'P';

1227: --if transaction_phase is changing
1228: IF OE_GLOBALS.G_ROLL_VERSION = 'Y' THEN
1229: OE_GLOBALS.G_ROLL_VERSION := 'PV';
1230: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1231: OE_GLOBALS.G_ROLL_VERSION := 'P';
1232: END IF;
1233: END IF;
1234:
1235: IF p_on_operation_action IN (.1,.2) THEN

Line 1236: IF OE_GLOBALS.G_ROLL_VERSION = 'P' THEN

1232: END IF;
1233: END IF;
1234:
1235: IF p_on_operation_action IN (.1,.2) THEN
1236: IF OE_GLOBALS.G_ROLL_VERSION = 'P' THEN
1237: OE_GLOBALS.G_ROLL_VERSION := 'PV';
1238: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1239: OE_GLOBALS.G_ROLL_VERSION := 'Y';
1240: END IF;

Line 1237: OE_GLOBALS.G_ROLL_VERSION := 'PV';

1233: END IF;
1234:
1235: IF p_on_operation_action IN (.1,.2) THEN
1236: IF OE_GLOBALS.G_ROLL_VERSION = 'P' THEN
1237: OE_GLOBALS.G_ROLL_VERSION := 'PV';
1238: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1239: OE_GLOBALS.G_ROLL_VERSION := 'Y';
1240: END IF;
1241:

Line 1238: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN

1234:
1235: IF p_on_operation_action IN (.1,.2) THEN
1236: IF OE_GLOBALS.G_ROLL_VERSION = 'P' THEN
1237: OE_GLOBALS.G_ROLL_VERSION := 'PV';
1238: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1239: OE_GLOBALS.G_ROLL_VERSION := 'Y';
1240: END IF;
1241:
1242: IF p_on_operation_action = .1 AND OE_GLOBALS.G_CAPTURED_REASON = 'N' THEN

Line 1239: OE_GLOBALS.G_ROLL_VERSION := 'Y';

1235: IF p_on_operation_action IN (.1,.2) THEN
1236: IF OE_GLOBALS.G_ROLL_VERSION = 'P' THEN
1237: OE_GLOBALS.G_ROLL_VERSION := 'PV';
1238: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1239: OE_GLOBALS.G_ROLL_VERSION := 'Y';
1240: END IF;
1241:
1242: IF p_on_operation_action = .1 AND OE_GLOBALS.G_CAPTURED_REASON = 'N' THEN
1243: --Capture reason required for versioning

Line 1242: IF p_on_operation_action = .1 AND OE_GLOBALS.G_CAPTURED_REASON = 'N' THEN

1238: ELSIF OE_GLOBALS.G_ROLL_VERSION = 'N' THEN
1239: OE_GLOBALS.G_ROLL_VERSION := 'Y';
1240: END IF;
1241:
1242: IF p_on_operation_action = .1 AND OE_GLOBALS.G_CAPTURED_REASON = 'N' THEN
1243: --Capture reason required for versioning
1244: OE_GLOBALS.G_CAPTURED_REASON := 'V';
1245: END IF;
1246: END IF;

Line 1244: OE_GLOBALS.G_CAPTURED_REASON := 'V';

1240: END IF;
1241:
1242: IF p_on_operation_action = .1 AND OE_GLOBALS.G_CAPTURED_REASON = 'N' THEN
1243: --Capture reason required for versioning
1244: OE_GLOBALS.G_CAPTURED_REASON := 'V';
1245: END IF;
1246: END IF;
1247: end if;
1248: IF l_debug_level > 0 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 1257: IF OE_GLOBALS.G_CAPTURED_REASON IN ('V') THEN

1253:
1254:
1255: FUNCTION IS_REASON_RQD RETURN Varchar2 IS
1256: BEGIN
1257: IF OE_GLOBALS.G_CAPTURED_REASON IN ('V') THEN
1258: RETURN OE_GLOBALS.G_CAPTURED_REASON;
1259: ELSIF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1260: RETURN 'A';
1261: ELSE

Line 1258: RETURN OE_GLOBALS.G_CAPTURED_REASON;

1254:
1255: FUNCTION IS_REASON_RQD RETURN Varchar2 IS
1256: BEGIN
1257: IF OE_GLOBALS.G_CAPTURED_REASON IN ('V') THEN
1258: RETURN OE_GLOBALS.G_CAPTURED_REASON;
1259: ELSIF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1260: RETURN 'A';
1261: ELSE
1262: -- else condition added for bug 4144357

Line 1259: ELSIF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN

1255: FUNCTION IS_REASON_RQD RETURN Varchar2 IS
1256: BEGIN
1257: IF OE_GLOBALS.G_CAPTURED_REASON IN ('V') THEN
1258: RETURN OE_GLOBALS.G_CAPTURED_REASON;
1259: ELSIF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1260: RETURN 'A';
1261: ELSE
1262: -- else condition added for bug 4144357
1263: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN

Line 1263: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN

1259: ELSIF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1260: RETURN 'A';
1261: ELSE
1262: -- else condition added for bug 4144357
1263: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN
1264: FOR l_ind in 1..OE_GLOBALS.oe_audit_history_tbl.last LOOP
1265: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.exists(l_ind) AND
1266: OE_GLOBALS.oe_audit_history_tbl(l_ind).HISTORY_TYPE = 'R' THEN
1267: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

Line 1264: FOR l_ind in 1..OE_GLOBALS.oe_audit_history_tbl.last LOOP

1260: RETURN 'A';
1261: ELSE
1262: -- else condition added for bug 4144357
1263: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN
1264: FOR l_ind in 1..OE_GLOBALS.oe_audit_history_tbl.last LOOP
1265: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.exists(l_ind) AND
1266: OE_GLOBALS.oe_audit_history_tbl(l_ind).HISTORY_TYPE = 'R' THEN
1267: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
1268: RETURN 'A';

Line 1265: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.exists(l_ind) AND

1261: ELSE
1262: -- else condition added for bug 4144357
1263: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN
1264: FOR l_ind in 1..OE_GLOBALS.oe_audit_history_tbl.last LOOP
1265: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.exists(l_ind) AND
1266: OE_GLOBALS.oe_audit_history_tbl(l_ind).HISTORY_TYPE = 'R' THEN
1267: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
1268: RETURN 'A';
1269: END IF;

Line 1266: OE_GLOBALS.oe_audit_history_tbl(l_ind).HISTORY_TYPE = 'R' THEN

1262: -- else condition added for bug 4144357
1263: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN
1264: FOR l_ind in 1..OE_GLOBALS.oe_audit_history_tbl.last LOOP
1265: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.exists(l_ind) AND
1266: OE_GLOBALS.oe_audit_history_tbl(l_ind).HISTORY_TYPE = 'R' THEN
1267: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
1268: RETURN 'A';
1269: END IF;
1270: END LOOP;

Line 1267: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';

1263: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.count > 0 THEN
1264: FOR l_ind in 1..OE_GLOBALS.oe_audit_history_tbl.last LOOP
1265: IF OE_GLOBALS.OE_AUDIT_HISTORY_TBL.exists(l_ind) AND
1266: OE_GLOBALS.oe_audit_history_tbl(l_ind).HISTORY_TYPE = 'R' THEN
1267: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'Y';
1268: RETURN 'A';
1269: END IF;
1270: END LOOP;
1271: END IF;

Line 1274: IF OE_GLOBALS.G_CAPTURED_REASON IN ('N','Y') THEN

1270: END LOOP;
1271: END IF;
1272: END IF;
1273:
1274: IF OE_GLOBALS.G_CAPTURED_REASON IN ('N','Y') THEN
1275: RETURN OE_GLOBALS.G_CAPTURED_REASON;
1276: END IF;
1277: END;
1278:

Line 1275: RETURN OE_GLOBALS.G_CAPTURED_REASON;

1271: END IF;
1272: END IF;
1273:
1274: IF OE_GLOBALS.G_CAPTURED_REASON IN ('N','Y') THEN
1275: RETURN OE_GLOBALS.G_CAPTURED_REASON;
1276: END IF;
1277: END;
1278:
1279: FUNCTION IS_AUDIT_REASON_CAPTURED

Line 1292: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN

1288: BEGIN
1289:
1290: G_UI_CALLED := TRUE;
1291:
1292: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1293: IF OE_Order_Util.g_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
1294: g_temp_reason_code := OE_Order_Util.g_header_rec.change_reason;
1295: g_temp_reason_comments := OE_Order_Util.g_header_rec.change_comments;
1296: RETURN TRUE;

Line 1308: IF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN

1304: l_result,
1305: l_return_stat);
1306:
1307: IF l_result = FND_API.G_TRUE THEN
1308: IF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
1309: IF OE_Order_Util.g_line_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR THEN
1310: g_temp_reason_code := OE_Order_Util.g_line_tbl(l_ind).change_reason;
1311: g_temp_reason_comments := OE_Order_Util.g_line_tbl(l_ind).change_comments;
1312: RETURN TRUE;

Line 1314: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN

1310: g_temp_reason_code := OE_Order_Util.g_line_tbl(l_ind).change_reason;
1311: g_temp_reason_comments := OE_Order_Util.g_line_tbl(l_ind).change_comments;
1312: RETURN TRUE;
1313: END IF;
1314: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN
1315: IF OE_Order_Util.g_header_adj_tbl(l_ind).change_reason_code <> FND_API.G_MISS_CHAR THEN
1316: g_temp_reason_code := OE_Order_Util.g_header_adj_tbl(l_ind).change_reason_code;
1317: g_temp_reason_comments := OE_Order_Util.g_header_adj_tbl(l_ind).change_reason_text;
1318: RETURN TRUE;

Line 1320: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT THEN

1316: g_temp_reason_code := OE_Order_Util.g_header_adj_tbl(l_ind).change_reason_code;
1317: g_temp_reason_comments := OE_Order_Util.g_header_adj_tbl(l_ind).change_reason_text;
1318: RETURN TRUE;
1319: END IF;
1320: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT THEN
1321: IF OE_Order_Util.g_header_scredit_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR THEN
1322: g_temp_reason_code := OE_Order_Util.g_header_scredit_tbl(l_ind).change_reason;
1323: g_temp_reason_comments := OE_Order_Util.g_header_scredit_tbl(l_ind).change_comments;
1324: RETURN TRUE;

Line 1326: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN

1322: g_temp_reason_code := OE_Order_Util.g_header_scredit_tbl(l_ind).change_reason;
1323: g_temp_reason_comments := OE_Order_Util.g_header_scredit_tbl(l_ind).change_comments;
1324: RETURN TRUE;
1325: END IF;
1326: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN
1327: IF OE_Order_Util.g_line_adj_tbl(l_ind).change_reason_code <> FND_API.G_MISS_CHAR THEN
1328: g_temp_reason_code := OE_Order_Util.g_line_adj_tbl(l_ind).change_reason_code;
1329: g_temp_reason_comments := OE_Order_Util.g_line_adj_tbl(l_ind).change_reason_text;
1330: RETURN TRUE;

Line 1332: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_SCREDIT THEN

1328: g_temp_reason_code := OE_Order_Util.g_line_adj_tbl(l_ind).change_reason_code;
1329: g_temp_reason_comments := OE_Order_Util.g_line_adj_tbl(l_ind).change_reason_text;
1330: RETURN TRUE;
1331: END IF;
1332: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_SCREDIT THEN
1333: IF OE_Order_Util.g_line_scredit_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR THEN
1334: g_temp_reason_code := OE_Order_Util.g_line_scredit_tbl(l_ind).change_reason;
1335: g_temp_reason_comments := OE_Order_Util.g_line_scredit_tbl(l_ind).change_comments;
1336: RETURN TRUE;

Line 1348: RETURN OE_GLOBALS.G_REASON_CODE;

1344: END;
1345:
1346: FUNCTION CAPTURED_REASON RETURN Varchar2 IS
1347: BEGIN
1348: RETURN OE_GLOBALS.G_REASON_CODE;
1349: END CAPTURED_REASON;
1350:
1351:
1352: Procedure Capture_Audit_Info(

Line 1373: IF p_entity_code <> OE_GLOBALS.G_ENTITY_HEADER THEN

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(
1375: p_entity_code,
1376: p_entity_id,
1377: l_ind,

Line 1382: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN

1378: l_result,
1379: l_return_stat);
1380: END IF;
1381:
1382: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1383: G_Audit_Header_Hist_Code := 'UPDATE';
1384: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1385: G_Audit_Header_Reason_Required := TRUE;
1386: END IF;

Line 1384: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN

1380: END IF;
1381:
1382: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
1383: G_Audit_Header_Hist_Code := 'UPDATE';
1384: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1385: G_Audit_Header_Reason_Required := TRUE;
1386: END IF;
1387: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
1388: IF NOT G_Audit_Line_ID_Tbl.exists(l_ind)

Line 1387: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN

1383: G_Audit_Header_Hist_Code := 'UPDATE';
1384: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1385: G_Audit_Header_Reason_Required := TRUE;
1386: END IF;
1387: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
1388: IF NOT G_Audit_Line_ID_Tbl.exists(l_ind)
1389: OR G_Audit_Line_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1390: G_Audit_Line_ID_Tbl(l_ind).entity_id := p_entity_id;
1391: G_Audit_Line_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;

Line 1392: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN

1388: IF NOT G_Audit_Line_ID_Tbl.exists(l_ind)
1389: OR G_Audit_Line_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1390: G_Audit_Line_ID_Tbl(l_ind).entity_id := p_entity_id;
1391: G_Audit_Line_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;
1392: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1393: G_Audit_Line_ID_Tbl(l_ind).Reason_Required := TRUE;
1394: END IF;
1395: END IF;
1396: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN

Line 1396: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN

1392: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1393: G_Audit_Line_ID_Tbl(l_ind).Reason_Required := TRUE;
1394: END IF;
1395: END IF;
1396: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_ADJ THEN
1397: IF NOT G_Audit_Header_Adj_ID_Tbl.exists(l_ind)
1398: OR G_Audit_Header_Adj_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1399: G_Audit_Header_Adj_ID_Tbl(l_ind).entity_id := p_entity_id;
1400: G_Audit_Header_Adj_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;

Line 1401: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN

1397: IF NOT G_Audit_Header_Adj_ID_Tbl.exists(l_ind)
1398: OR G_Audit_Header_Adj_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1399: G_Audit_Header_Adj_ID_Tbl(l_ind).entity_id := p_entity_id;
1400: G_Audit_Header_Adj_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;
1401: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1402: G_Audit_Header_Adj_ID_Tbl(l_ind).Reason_Required := TRUE;
1403: END IF;
1404: END IF;
1405: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT THEN

Line 1405: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT THEN

1401: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1402: G_Audit_Header_Adj_ID_Tbl(l_ind).Reason_Required := TRUE;
1403: END IF;
1404: END IF;
1405: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER_SCREDIT THEN
1406: IF NOT G_Audit_Header_scredit_ID_Tbl.exists(l_ind)
1407: OR G_Audit_Header_scredit_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1408: G_Audit_Header_scredit_ID_Tbl(l_ind).entity_id := p_entity_id;
1409: G_Audit_Header_scredit_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;

Line 1410: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN

1406: IF NOT G_Audit_Header_scredit_ID_Tbl.exists(l_ind)
1407: OR G_Audit_Header_scredit_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1408: G_Audit_Header_scredit_ID_Tbl(l_ind).entity_id := p_entity_id;
1409: G_Audit_Header_scredit_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;
1410: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1411: G_Audit_Header_Scredit_ID_Tbl(l_ind).Reason_Required := TRUE;
1412: END IF;
1413: END IF;
1414: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN

Line 1414: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN

1410: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1411: G_Audit_Header_Scredit_ID_Tbl(l_ind).Reason_Required := TRUE;
1412: END IF;
1413: END IF;
1414: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_ADJ THEN
1415: IF NOT G_Audit_Line_Adj_ID_Tbl.exists(l_ind)
1416: OR G_Audit_Line_Adj_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1417: G_Audit_Line_Adj_ID_Tbl(l_ind).entity_id := p_entity_id;
1418: G_Audit_Line_Adj_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;

Line 1419: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN

1415: IF NOT G_Audit_Line_Adj_ID_Tbl.exists(l_ind)
1416: OR G_Audit_Line_Adj_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1417: G_Audit_Line_Adj_ID_Tbl(l_ind).entity_id := p_entity_id;
1418: G_Audit_Line_Adj_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;
1419: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1420: G_Audit_Line_Adj_ID_Tbl(l_ind).Reason_Required := TRUE;
1421: END IF;
1422: END IF;
1423: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_SCREDIT THEN

Line 1423: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_SCREDIT THEN

1419: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1420: G_Audit_Line_Adj_ID_Tbl(l_ind).Reason_Required := TRUE;
1421: END IF;
1422: END IF;
1423: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE_SCREDIT THEN
1424: IF NOT G_Audit_Line_scredit_ID_Tbl.exists(l_ind)
1425: OR G_Audit_Line_scredit_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1426: G_Audit_Line_scredit_ID_Tbl(l_ind).entity_id := p_entity_id;
1427: G_Audit_Line_scredit_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;

Line 1428: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN

1424: IF NOT G_Audit_Line_scredit_ID_Tbl.exists(l_ind)
1425: OR G_Audit_Line_scredit_ID_Tbl(l_ind).hist_type_code NOT IN ('SPLIT', 'CANCELLATION') THEN
1426: G_Audit_Line_scredit_ID_Tbl(l_ind).entity_id := p_entity_id;
1427: G_Audit_Line_scredit_ID_Tbl(l_ind).hist_type_code := p_hist_type_code;
1428: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG = 'Y' THEN
1429: G_Audit_Line_Scredit_ID_Tbl(l_ind).Reason_Required := TRUE;
1430: END IF;
1431: END IF;
1432: END IF;

Line 1434: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';

1430: END IF;
1431: END IF;
1432: END IF;
1433:
1434: OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG := 'N';
1435: END Capture_Audit_Info;
1436:
1437: Procedure Get_Reason_Info(
1438: x_reason_code OUT NOCOPY VARCHAR2,

Line 1460: if OE_GLOBALS.G_REASON_CODE IS NOT NULL THEN

1456: end if;
1457:
1458: -- Get current change reason
1459:
1460: if OE_GLOBALS.G_REASON_CODE IS NOT NULL THEN
1461: x_reason_code := OE_GLOBALS.G_REASON_CODE;
1462: x_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
1463: end if;
1464:

Line 1461: x_reason_code := OE_GLOBALS.G_REASON_CODE;

1457:
1458: -- Get current change reason
1459:
1460: if OE_GLOBALS.G_REASON_CODE IS NOT NULL THEN
1461: x_reason_code := OE_GLOBALS.G_REASON_CODE;
1462: x_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
1463: end if;
1464:
1465: if oe_order_util.g_header_rec.change_reason <> FND_API.G_MISS_CHAR then

Line 1462: x_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;

1458: -- Get current change reason
1459:
1460: if OE_GLOBALS.G_REASON_CODE IS NOT NULL THEN
1461: x_reason_code := OE_GLOBALS.G_REASON_CODE;
1462: x_reason_comments := OE_GLOBALS.G_REASON_COMMENTS;
1463: end if;
1464:
1465: if oe_order_util.g_header_rec.change_reason <> FND_API.G_MISS_CHAR then
1466: x_reason_code := oe_order_util.g_header_rec.change_reason;