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 FND_API

Line 21: l_return_status := FND_API.G_RET_STS_SUCCESS;

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;
22:
23: IF l_debug_level > 0 THEN
24: oe_debug_pub.add('Entering Delete_Created_Records ',1);
25: END IF;

Line 127: l_return_status := FND_API.G_RET_STS_SUCCESS;

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:
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,

Line 138: If l_return_status = FND_API.G_RET_STS_SUCCESS

134: x_msg_data => x_msg_data,
135: x_return_status => l_return_status);
136:
137: --takintoy Version articles
138: If l_return_status = FND_API.G_RET_STS_SUCCESS
139: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
140: Then
141: OE_Contracts_Util.Version_Articles(
142: p_api_version => 1,

Line 157: l_return_status := FND_API.G_RET_STS_ERROR;

153: Record_Changed_Records(
154: p_changed_attribute => p_changed_attribute,
155: x_return_status => l_return_status);
156: IF (NOT OE_Versioning_Util.Reset_Globals) THEN
157: l_return_status := FND_API.G_RET_STS_ERROR;
158: END IF;
159: END IF;
160:
161: IF l_debug_level > 0 THEN

Line 196: l_return_status := FND_API.G_RET_STS_SUCCESS;

192: BEGIN
193:
194: SAVEPOINT Perform_Versioning;
195:
196: l_return_status := FND_API.G_RET_STS_SUCCESS;
197: l_version_flag := 'N';
198: l_phase_change_flag := 'N';
199:
200: IF l_debug_level > 0 THEN

Line 209: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM 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
209: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN
210: select version_number into l_version_number from oe_order_headers_all where header_id = p_header_id;
211: ELSE
212: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
213: END IF;

Line 223: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN

219: l_phase_change_flag := 'N';
220: l_version_flag := 'Y';
221: IF (p_document_type <> 'BLANKETS') THEN
222: IF OE_ORDER_UTIL.g_old_header_rec.version_number IS NULL
223: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM THEN
224: select version_number into l_version_number from oe_order_headers_all where header_id = p_header_id;
225: ELSE
226: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
227: END IF;

Line 255: RAISE FND_API.G_EXC_ERROR;

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:
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: END IF;
258:
259: --Apply reason changes

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 283: RAISE FND_API.G_EXC_ERROR;

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;
284: END IF;
285:
286: -- Bug 5156668
287: -- This needs to be called only in the end, hence commenting

Line 289: -- RAISE FND_API.G_EXC_ERROR;

285:
286: -- Bug 5156668
287: -- This needs to be called only in the end, hence commenting
288: -- IF (NOT Reset_Globals) THEN
289: -- RAISE FND_API.G_EXC_ERROR;
290: -- END IF;
291:
292: -- XDING: Commentting out this DOESNOT fix bug 5156668 but cause
293: -- regression issue 505564, so put this code back

Line 295: RAISE FND_API.G_EXC_ERROR;

291:
292: -- XDING: Commentting out this DOESNOT fix bug 5156668 but cause
293: -- regression issue 505564, so put this code back
294: IF (NOT Reset_Globals) THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297:
298: RETURN;
299: END IF;

Line 315: -- RAISE FND_API.G_EXC_ERROR;

311:
312: -- Bug 5156668
313: -- This needs to be called only in the end, hence commenting
314: -- IF (NOT Reset_Globals) THEN
315: -- RAISE FND_API.G_EXC_ERROR;
316: -- END IF;
317:
318: -- XDING: Commentting out this DOESNOT fix bug 5156668 but cause
319: -- regression issue 505564, so put this code back

Line 321: RAISE FND_API.G_EXC_ERROR;

317:
318: -- XDING: Commentting out this DOESNOT fix bug 5156668 but cause
319: -- regression issue 505564, so put this code back
320: IF (NOT Reset_Globals) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323:
324: RETURN;
325: END IF;

Line 334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

330: p_phase_change_flag => l_phase_change_flag,
331: p_changed_attribute => p_changed_attribute,
332: x_return_status => l_return_status);
333:
334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;

Line 335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

331: p_changed_attribute => p_changed_attribute,
332: x_return_status => l_return_status);
333:
334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339:

Line 336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

332: x_return_status => l_return_status);
333:
334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339:
340: -- Record unchanged records

Line 337: RAISE FND_API.G_EXC_ERROR;

333:
334: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;
339:
340: -- Record unchanged records
341: IF l_debug_level > 0 THEN

Line 351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

347: p_phase_change_flag => l_phase_change_flag,
348: p_changed_attribute => p_changed_attribute,
349: x_return_status => l_return_status);
350:
351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;

Line 352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

348: p_changed_attribute => p_changed_attribute,
349: x_return_status => l_return_status);
350:
351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:

Line 353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

349: x_return_status => l_return_status);
350:
351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: l_return_status := Delete_Created_Records;

Line 354: RAISE FND_API.G_EXC_ERROR;

350:
351: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: l_return_status := Delete_Created_Records;
358:

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 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 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 412: RAISE FND_API.G_EXC_ERROR;

408: ELSIF IS_REASON_RQD <> 'N' THEN
409: FND_MESSAGE.SET_NAME('ONT','OE_AUDIT_REASON_RQD');
410: OE_MSG_PUB.ADD;
411:
412: RAISE FND_API.G_EXC_ERROR;
413:
414: END IF;
415:
416: --Update l_version_number

Line 429: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM

425: WHERE HEADER_ID = p_header_id;
426:
427: IF OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER
428: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER IS NULL
429: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM
430: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER IS NULL
431: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM THEN
432: UPDATE OE_ORDER_HEADERS_ALL
433: SET VERSION_NUMBER = l_version_number + 1,

Line 431: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM THEN

427: IF OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER
428: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER IS NULL
429: OR OE_ORDER_UTIL.G_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM
430: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER IS NULL
431: OR OE_ORDER_UTIL.G_OLD_HEADER_REC.VERSION_NUMBER = FND_API.G_MISS_NUM THEN
432: UPDATE OE_ORDER_HEADERS_ALL
433: SET VERSION_NUMBER = l_version_number + 1,
434: LOCK_CONTROL = l_lock_control + 1
435: WHERE HEADER_ID = p_header_id;

Line 450: RAISE FND_API.G_EXC_ERROR;

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:
450: RAISE FND_API.G_EXC_ERROR;
451: END IF;
452: END IF;
453:
454: G_VERSION_NUMBER := l_version_number;

Line 466: -- RAISE FND_API.G_EXC_ERROR;

462:
463: -- Bug 5156668
464: -- This needs to be called only in the end, hence commenting
465: --IF (NOT Reset_Globals) THEN
466: -- RAISE FND_API.G_EXC_ERROR;
467: --END IF;
468:
469: -- XDING: Commentting out this DOESNOT fix bug 5156668 but cause
470: -- regression issue 505564, so put this code back

Line 472: RAISE FND_API.G_EXC_ERROR;

468:
469: -- XDING: Commentting out this DOESNOT fix bug 5156668 but cause
470: -- regression issue 505564, so put this code back
471: IF (NOT Reset_Globals) THEN
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: EXCEPTION
476: WHEN FND_API.G_EXC_ERROR THEN

Line 476: WHEN FND_API.G_EXC_ERROR THEN

472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: EXCEPTION
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO SAVEPOINT Perform_Versioning;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: RAISE FND_API.G_EXC_ERROR;
480: WHEN OTHERS THEN

Line 478: x_return_status := FND_API.G_RET_STS_ERROR;

474:
475: EXCEPTION
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO SAVEPOINT Perform_Versioning;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: RAISE FND_API.G_EXC_ERROR;
480: WHEN OTHERS THEN
481: ROLLBACK TO SAVEPOINT Perform_Versioning;
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 479: RAISE FND_API.G_EXC_ERROR;

475: EXCEPTION
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO SAVEPOINT Perform_Versioning;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: RAISE FND_API.G_EXC_ERROR;
480: WHEN OTHERS THEN
481: ROLLBACK TO SAVEPOINT Perform_Versioning;
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483:

Line 482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

478: x_return_status := FND_API.G_RET_STS_ERROR;
479: RAISE FND_API.G_EXC_ERROR;
480: WHEN OTHERS THEN
481: ROLLBACK TO SAVEPOINT Perform_Versioning;
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483:
484: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
485: OE_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487: , 'Perform_Versioning'
488: );
489: END IF;
490:
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492:
493: END Perform_Versioning;
494:
495:

Line 504: if oe_order_util.g_header_id <> FND_API.G_MISS_NUM then

500: BEGIN
501:
502: -- Get current header_id
503:
504: if oe_order_util.g_header_id <> FND_API.G_MISS_NUM then
505: RETURN oe_order_util.g_header_id;
506: elsif
507: oe_order_util.g_old_header_rec.header_id <> FND_API.G_MISS_NUM then
508: RETURN oe_order_util.g_old_header_rec.header_id;

Line 507: oe_order_util.g_old_header_rec.header_id <> FND_API.G_MISS_NUM then

503:
504: if oe_order_util.g_header_id <> FND_API.G_MISS_NUM then
505: RETURN oe_order_util.g_header_id;
506: elsif
507: oe_order_util.g_old_header_rec.header_id <> FND_API.G_MISS_NUM then
508: RETURN oe_order_util.g_old_header_rec.header_id;
509: elsif
510: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM then
511: RETURN oe_order_util.g_header_rec.header_id;

Line 510: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM then

506: elsif
507: oe_order_util.g_old_header_rec.header_id <> FND_API.G_MISS_NUM then
508: RETURN oe_order_util.g_old_header_rec.header_id;
509: elsif
510: oe_order_util.g_header_rec.header_id <> FND_API.G_MISS_NUM then
511: RETURN oe_order_util.g_header_rec.header_id;
512: else
513: i := oe_order_util.g_old_line_tbl.FIRST; -- get subscript of first element
514: WHILE i IS NOT NULL LOOP

Line 515: if oe_order_util.g_old_line_tbl(i).header_id <> FND_API.G_MISS_NUM then

511: RETURN oe_order_util.g_header_rec.header_id;
512: else
513: i := oe_order_util.g_old_line_tbl.FIRST; -- get subscript of first element
514: WHILE i IS NOT NULL LOOP
515: if oe_order_util.g_old_line_tbl(i).header_id <> FND_API.G_MISS_NUM then
516: RETURN oe_order_util.g_old_line_tbl(i).header_id;
517: end if;
518: i := oe_order_util.g_old_line_tbl.NEXT(i); -- get subscript of next element
519: END LOOP;

Line 523: if oe_order_util.g_line_tbl(i).header_id <> FND_API.G_MISS_NUM then

519: END LOOP;
520:
521: i := oe_order_util.g_line_tbl.FIRST; -- get subscript of first element
522: WHILE i IS NOT NULL LOOP
523: if oe_order_util.g_line_tbl(i).header_id <> FND_API.G_MISS_NUM then
524: RETURN oe_order_util.g_line_tbl(i).header_id;
525: end if;
526: i := oe_order_util.g_line_tbl.NEXT(i); -- get subscript of next element
527: END LOOP;

Line 531: if oe_order_util.g_old_header_adj_tbl(i).header_id <> FND_API.G_MISS_NUM then

527: END LOOP;
528:
529: i := oe_order_util.g_old_header_adj_tbl.FIRST; -- get subscript of first element
530: WHILE i IS NOT NULL LOOP
531: if oe_order_util.g_old_header_adj_tbl(i).header_id <> FND_API.G_MISS_NUM then
532: RETURN oe_order_util.g_old_header_adj_tbl(i).header_id;
533: end if;
534: i := oe_order_util.g_old_header_adj_tbl.NEXT(i); -- get subscript of next element
535: END LOOP;

Line 539: if oe_order_util.g_header_adj_tbl(i).header_id <> FND_API.G_MISS_NUM then

535: END LOOP;
536:
537: i := oe_order_util.g_header_adj_tbl.FIRST; -- get subscript of first element
538: WHILE i IS NOT NULL LOOP
539: if oe_order_util.g_header_adj_tbl(i).header_id <> FND_API.G_MISS_NUM then
540: RETURN oe_order_util.g_header_adj_tbl(i).header_id;
541: end if;
542: i := oe_order_util.g_header_adj_tbl.NEXT(i); -- get subscript of next element
543: END LOOP;

Line 547: if oe_order_util.g_old_line_adj_tbl(i).header_id <> FND_API.G_MISS_NUM then

543: END LOOP;
544:
545: i := oe_order_util.g_old_line_adj_tbl.FIRST; -- get subscript of first element
546: WHILE i IS NOT NULL LOOP
547: if oe_order_util.g_old_line_adj_tbl(i).header_id <> FND_API.G_MISS_NUM then
548: RETURN oe_order_util.g_old_line_adj_tbl(i).header_id;
549: end if;
550: i := oe_order_util.g_old_line_adj_tbl.NEXT(i); -- get subscript of next element
551: END LOOP;

Line 555: if oe_order_util.g_line_adj_tbl(i).header_id <> FND_API.G_MISS_NUM then

551: END LOOP;
552:
553: i := oe_order_util.g_line_adj_tbl.FIRST; -- get subscript of first element
554: WHILE i IS NOT NULL LOOP
555: if oe_order_util.g_line_adj_tbl(i).header_id <> FND_API.G_MISS_NUM then
556: RETURN oe_order_util.g_line_adj_tbl(i).header_id;
557: end if;
558: i := oe_order_util.g_line_adj_tbl.NEXT(i); -- get subscript of next element
559: END LOOP;

Line 563: if oe_order_util.g_old_header_scredit_tbl(i).header_id <> FND_API.G_MISS_NUM then

559: END LOOP;
560:
561: i := oe_order_util.g_old_header_scredit_tbl.FIRST; -- get subscript of first element
562: WHILE i IS NOT NULL LOOP
563: if oe_order_util.g_old_header_scredit_tbl(i).header_id <> FND_API.G_MISS_NUM then
564: RETURN oe_order_util.g_old_header_scredit_tbl(i).header_id;
565: end if;
566: i := oe_order_util.g_old_header_scredit_tbl.NEXT(i); -- get subscript of next element
567: END LOOP;

Line 571: if oe_order_util.g_header_scredit_tbl(i).header_id <> FND_API.G_MISS_NUM then

567: END LOOP;
568:
569: i := oe_order_util.g_header_scredit_tbl.FIRST; -- get subscript of first element
570: WHILE i IS NOT NULL LOOP
571: if oe_order_util.g_header_scredit_tbl(i).header_id <> FND_API.G_MISS_NUM then
572: RETURN oe_order_util.g_header_scredit_tbl(i).header_id;
573: end if;
574: i := oe_order_util.g_header_scredit_tbl.NEXT(i); -- get subscript of next element
575: END LOOP;

Line 579: if oe_order_util.g_old_line_scredit_tbl(i).header_id <> FND_API.G_MISS_NUM then

575: END LOOP;
576:
577: i := oe_order_util.g_old_line_scredit_tbl.FIRST; -- get subscript of first element
578: WHILE i IS NOT NULL LOOP
579: if oe_order_util.g_old_line_scredit_tbl(i).header_id <> FND_API.G_MISS_NUM then
580: RETURN oe_order_util.g_old_line_scredit_tbl(i).header_id;
581: end if;
582: i := oe_order_util.g_old_line_scredit_tbl.NEXT(i); -- get subscript of next element
583: END LOOP;

Line 587: if oe_order_util.g_line_scredit_tbl(i).header_id <> FND_API.G_MISS_NUM then

583: END LOOP;
584:
585: i := oe_order_util.g_line_scredit_tbl.FIRST; -- get subscript of first element
586: WHILE i IS NOT NULL LOOP
587: if oe_order_util.g_line_scredit_tbl(i).header_id <> FND_API.G_MISS_NUM then
588: RETURN oe_order_util.g_line_scredit_tbl(i).header_id;
589: end if;
590: i := oe_order_util.g_line_scredit_tbl.NEXT(i); -- get subscript of next element
591: END LOOP;

Line 620: l_return_status := FND_API.G_RET_STS_SUCCESS;

616: --
617: BEGIN
618:
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;

Line 633: OR OE_ORDER_UTIL.g_old_header_rec.version_number = FND_API.G_MISS_NUM 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
634: select version_number into l_version_number from oe_order_headers_all where header_id = l_header_id;
635: ELSE
636: l_version_number := OE_ORDER_UTIL.g_old_header_rec.version_number;
637: END IF;

Line 644: IF OE_Order_Util.g_old_header_rec.header_id <> FND_API.G_MISS_NUM 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
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:

Line 670: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

666: p_reason_comments => OE_ORDER_UTIL.g_header_rec.change_comments,
667: x_reason_id => l_reason_id,
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:

Line 675: if l_return_status = FND_API.G_RET_STS_ERROR 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;
677: else
678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
679: end if;

Line 676: raise FND_API.G_EXC_ERROR;

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;
677: else
678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
679: end if;
680: end if;

Line 678: raise FND_API.G_EXC_UNEXPECTED_ERROR;

674:
675: if l_return_status = FND_API.G_RET_STS_ERROR then
676: raise FND_API.G_EXC_ERROR;
677: else
678: raise FND_API.G_EXC_UNEXPECTED_ERROR;
679: end if;
680: end if;
681:
682: end if; --end apply reason

Line 705: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

701: p_changed_attribute => p_changed_attribute,
702: x_return_status => l_return_status
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:

Line 710: if l_return_status = FND_API.G_RET_STS_ERROR 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;
712: else
713: raise FND_API.G_EXC_UNEXPECTED_ERROR;
714: end if;

Line 711: raise FND_API.G_EXC_ERROR;

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;
712: else
713: raise FND_API.G_EXC_UNEXPECTED_ERROR;
714: end if;
715: end if;

Line 713: raise FND_API.G_EXC_UNEXPECTED_ERROR;

709:
710: if l_return_status = FND_API.G_RET_STS_ERROR then
711: raise FND_API.G_EXC_ERROR;
712: else
713: raise FND_API.G_EXC_UNEXPECTED_ERROR;
714: end if;
715: end if;
716:
717: END IF;

Line 753: and OE_ORDER_UTIL.g_line_tbl(i).change_reason <> fnd_api.g_miss_char

749: -- but if reason is supplied for these hist types, it should be
750: -- captured.
751: OR (l_hist_type_code IN ('CANCELLATION','QUANTITY UPDATE')
752: and OE_ORDER_UTIL.g_line_tbl(i).change_reason is not null
753: and OE_ORDER_UTIL.g_line_tbl(i).change_reason <> fnd_api.g_miss_char
754: )
755: ) then
756: --Apply Reason for audit
757: OE_Reasons_Util.Apply_Reason(

Line 768: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

764: p_reason_comments => OE_ORDER_UTIL.g_line_tbl(i).change_comments,
765: x_reason_id => l_reason_id,
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:

Line 773: if l_return_status = FND_API.G_RET_STS_ERROR 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;
775: else
776: raise FND_API.G_EXC_UNEXPECTED_ERROR;
777: end if;

Line 774: raise FND_API.G_EXC_ERROR;

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;
775: else
776: raise FND_API.G_EXC_UNEXPECTED_ERROR;
777: end if;
778: end if;

Line 776: raise FND_API.G_EXC_UNEXPECTED_ERROR;

772:
773: if l_return_status = FND_API.G_RET_STS_ERROR then
774: raise FND_API.G_EXC_ERROR;
775: else
776: raise FND_API.G_EXC_UNEXPECTED_ERROR;
777: end if;
778: end if;
779:
780: end if; --end apply reason

Line 804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

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
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

Line 808: IF l_return_status = FND_API.G_RET_STS_ERROR then

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
811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;

Line 809: raise FND_API.G_EXC_ERROR;

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
811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: END IF;

Line 811: raise FND_API.G_EXC_UNEXPECTED_ERROR;

807: END IF;
808: IF l_return_status = FND_API.G_RET_STS_ERROR then
809: raise FND_API.G_EXC_ERROR;
810: ELSE
811: raise FND_API.G_EXC_UNEXPECTED_ERROR;
812: END IF;
813: END IF;
814:
815: END IF;

Line 851: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

847: p_reason_comments => OE_ORDER_UTIL.g_header_adj_tbl(i).change_reason_text,
848: x_reason_id => l_reason_id,
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:

Line 856: if l_return_status = FND_API.G_RET_STS_ERROR 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;
858: else
859: raise FND_API.G_EXC_UNEXPECTED_ERROR;
860: end if;

Line 857: raise FND_API.G_EXC_ERROR;

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;
858: else
859: raise FND_API.G_EXC_UNEXPECTED_ERROR;
860: end if;
861: end if;

Line 859: raise FND_API.G_EXC_UNEXPECTED_ERROR;

855:
856: if l_return_status = FND_API.G_RET_STS_ERROR then
857: raise FND_API.G_EXC_ERROR;
858: else
859: raise FND_API.G_EXC_UNEXPECTED_ERROR;
860: end if;
861: end if;
862:
863: end if; --end apply reason

Line 887: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

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);
890: END IF;
891:

Line 892: IF l_return_status = FND_API.G_RET_STS_ERROR 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;
894: ELSE
895: raise FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;

Line 893: raise FND_API.G_EXC_ERROR;

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;
894: ELSE
895: raise FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897: END IF;

Line 895: raise FND_API.G_EXC_UNEXPECTED_ERROR;

891:
892: IF l_return_status = FND_API.G_RET_STS_ERROR then
893: raise FND_API.G_EXC_ERROR;
894: ELSE
895: raise FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897: END IF;
898:
899: END IF;

Line 936: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

932: p_reason_comments => OE_ORDER_UTIL.g_header_scredit_tbl(i).change_comments,
933: x_reason_id => l_reason_id,
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:

Line 941: if l_return_status = FND_API.G_RET_STS_ERROR 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;
943: else
944: raise FND_API.G_EXC_UNEXPECTED_ERROR;
945: end if;

Line 942: raise FND_API.G_EXC_ERROR;

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;
943: else
944: raise FND_API.G_EXC_UNEXPECTED_ERROR;
945: end if;
946: end if;

Line 944: raise FND_API.G_EXC_UNEXPECTED_ERROR;

940:
941: if l_return_status = FND_API.G_RET_STS_ERROR then
942: raise FND_API.G_EXC_ERROR;
943: else
944: raise FND_API.G_EXC_UNEXPECTED_ERROR;
945: end if;
946: end if;
947:
948: end if; --end apply reason

Line 972: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

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);
975: END IF;
976: IF l_return_status = FND_API.G_RET_STS_ERROR then

Line 976: IF l_return_status = FND_API.G_RET_STS_ERROR then

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
979: raise FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;

Line 977: raise FND_API.G_EXC_ERROR;

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
979: raise FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: END IF;

Line 979: raise FND_API.G_EXC_UNEXPECTED_ERROR;

975: END IF;
976: IF l_return_status = FND_API.G_RET_STS_ERROR then
977: raise FND_API.G_EXC_ERROR;
978: ELSE
979: raise FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: END IF;
982:
983: END IF;

Line 1018: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1014: p_reason_comments => OE_ORDER_UTIL.g_line_adj_tbl(i).change_reason_text,
1015: x_reason_id => l_reason_id,
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:

Line 1023: if l_return_status = FND_API.G_RET_STS_ERROR 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;
1025: else
1026: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1027: end if;

Line 1024: raise FND_API.G_EXC_ERROR;

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;
1025: else
1026: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1027: end if;
1028: end if;

Line 1026: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1022:
1023: if l_return_status = FND_API.G_RET_STS_ERROR then
1024: raise FND_API.G_EXC_ERROR;
1025: else
1026: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1027: end if;
1028: end if;
1029:
1030: end if; --end apply reason

Line 1054: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

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);
1057: END IF;
1058:

Line 1059: IF l_return_status = FND_API.G_RET_STS_ERROR 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;
1061: ELSE
1062: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END IF;

Line 1060: raise FND_API.G_EXC_ERROR;

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;
1061: ELSE
1062: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END IF;
1064: END IF;

Line 1062: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1058:
1059: IF l_return_status = FND_API.G_RET_STS_ERROR then
1060: raise FND_API.G_EXC_ERROR;
1061: ELSE
1062: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1063: END IF;
1064: END IF;
1065:
1066: END IF;

Line 1101: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1097: p_reason_comments => OE_ORDER_UTIL.g_line_scredit_tbl(i).change_comments,
1098: x_reason_id => l_reason_id,
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:

Line 1106: if l_return_status = FND_API.G_RET_STS_ERROR 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;
1108: else
1109: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1110: end if;

Line 1107: raise FND_API.G_EXC_ERROR;

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;
1108: else
1109: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1110: end if;
1111: end if;

Line 1109: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1105:
1106: if l_return_status = FND_API.G_RET_STS_ERROR then
1107: raise FND_API.G_EXC_ERROR;
1108: else
1109: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1110: end if;
1111: end if;
1112:
1113: end if; --end apply reason

Line 1137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

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);
1140: END IF;
1141: IF l_return_status = FND_API.G_RET_STS_ERROR then

Line 1141: IF l_return_status = FND_API.G_RET_STS_ERROR then

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
1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END IF;

Line 1142: raise FND_API.G_EXC_ERROR;

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
1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END IF;
1146: END IF;

Line 1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1140: END IF;
1141: IF l_return_status = FND_API.G_RET_STS_ERROR then
1142: raise FND_API.G_EXC_ERROR;
1143: ELSE
1144: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1145: END IF;
1146: END IF;
1147:
1148: END IF;

Line 1157: RAISE FND_API.G_EXC_ERROR;

1153: x_return_status := l_return_status;
1154:
1155: /*
1156: IF (NOT Reset_Globals) THEN
1157: RAISE FND_API.G_EXC_ERROR;
1158: END IF;
1159: */
1160: EXCEPTION
1161: WHEN OTHERS THEN

Line 1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1159: */
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: ROLLBACK TO SAVEPOINT Record_Changed_Records;
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1165: OE_MSG_PUB.Add_Exc_Msg
1166: ( G_PKG_NAME
1167: , 'Record Changed Records'

Line 1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1166: ( G_PKG_NAME
1167: , 'Record Changed Records'
1168: );
1169: END IF;
1170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1171:
1172: END Record_Changed_Records;
1173:
1174: Function Reset_Globals

Line 1293: IF OE_Order_Util.g_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN

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;
1297: END IF;

Line 1307: IF l_result = FND_API.G_TRUE THEN

1303: l_ind,
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;

Line 1309: IF OE_Order_Util.g_line_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR THEN

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;
1313: END IF;

Line 1315: IF OE_Order_Util.g_header_adj_tbl(l_ind).change_reason_code <> FND_API.G_MISS_CHAR THEN

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;
1319: END IF;

Line 1321: IF OE_Order_Util.g_header_scredit_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR THEN

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;
1325: END IF;

Line 1327: IF OE_Order_Util.g_line_adj_tbl(l_ind).change_reason_code <> FND_API.G_MISS_CHAR THEN

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;
1331: END IF;

Line 1333: IF OE_Order_Util.g_line_scredit_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR THEN

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;
1337: END IF;

Line 1465: if oe_order_util.g_header_rec.change_reason <> FND_API.G_MISS_CHAR 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;
1467: x_reason_comments := oe_order_util.g_header_rec.change_comments;
1468: RETURN;
1469: else

Line 1473: if oe_order_util.g_header_adj_tbl(i).change_reason_code <> FND_API.G_MISS_CHAR then

1469: else
1470:
1471: i := oe_order_util.g_header_adj_tbl.FIRST; -- get subscript of first element
1472: WHILE i IS NOT NULL LOOP
1473: if oe_order_util.g_header_adj_tbl(i).change_reason_code <> FND_API.G_MISS_CHAR then
1474: x_reason_code := oe_order_util.g_header_adj_tbl(i).change_reason_code;
1475: x_reason_comments := oe_order_util.g_header_adj_tbl(i).change_reason_text;
1476: RETURN;
1477: end if;

Line 1483: if oe_order_util.g_header_scredit_tbl(i).change_reason <> FND_API.G_MISS_CHAR then

1479: END LOOP;
1480:
1481: i := oe_order_util.g_header_scredit_tbl.FIRST;
1482: WHILE i IS NOT NULL LOOP
1483: if oe_order_util.g_header_scredit_tbl(i).change_reason <> FND_API.G_MISS_CHAR then
1484: x_reason_code := oe_order_util.g_header_scredit_tbl(i).change_reason;
1485: x_reason_comments := oe_order_util.g_header_scredit_tbl(i).change_comments;
1486: RETURN;
1487: end if;

Line 1493: if oe_order_util.g_line_tbl(i).change_reason <> FND_API.G_MISS_CHAR then

1489: END LOOP;
1490:
1491: i := oe_order_util.g_line_tbl.FIRST;
1492: WHILE i IS NOT NULL LOOP
1493: if oe_order_util.g_line_tbl(i).change_reason <> FND_API.G_MISS_CHAR then
1494: x_reason_code := oe_order_util.g_line_tbl(i).change_reason;
1495: x_reason_comments := oe_order_util.g_line_tbl(i).change_comments;
1496: RETURN;
1497: end if;

Line 1503: if oe_order_util.g_line_adj_tbl(i).change_reason_code <> FND_API.G_MISS_CHAR then

1499: END LOOP;
1500:
1501: i := oe_order_util.g_line_adj_tbl.FIRST;
1502: WHILE i IS NOT NULL LOOP
1503: if oe_order_util.g_line_adj_tbl(i).change_reason_code <> FND_API.G_MISS_CHAR then
1504: x_reason_code := oe_order_util.g_line_adj_tbl(i).change_reason_code;
1505: x_reason_comments := oe_order_util.g_line_adj_tbl(i).change_reason_text;
1506: RETURN;
1507: end if;

Line 1513: if oe_order_util.g_line_scredit_tbl(i).change_reason <> FND_API.G_MISS_CHAR then

1509: END LOOP;
1510:
1511: i := oe_order_util.g_line_scredit_tbl.FIRST;
1512: WHILE i IS NOT NULL LOOP
1513: if oe_order_util.g_line_scredit_tbl(i).change_reason <> FND_API.G_MISS_CHAR then
1514: x_reason_code := oe_order_util.g_line_scredit_tbl(i).change_reason;
1515: x_reason_comments := oe_order_util.g_line_scredit_tbl(i).change_comments;
1516: RETURN;
1517: end if;