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_ORDER_UTIL dependencies on FND_API

Line 48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

44: ( G_PKG_NAME
45: , 'GET_ATTRIBUTE_NAME'
46: );
47: END IF;
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END GET_ATTRIBUTE_NAME;
50:
51: ---------------------------------------------------------------
52: PROCEDURE LOCK_ORDER_OBJECT

Line 81: x_return_status := FND_API.G_RET_STS_SUCCESS;

77: FOR UPDATE NOWAIT;
78: BEGIN
79: SAVEPOINT Lock_Order_Object;
80:
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: -- Lock order header
84: OPEN header;
85: CLOSE header;

Line 101: x_return_status := FND_API.G_RET_STS_ERROR;

97: CLOSE sales_credits;
98:
99: EXCEPTION
100: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_OBJECT_LOCKED');
103: OE_MSG_PUB.ADD;
104: IF (header%ISOPEN) THEN
105: CLOSE header;

Line 115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

111: CLOSE sales_credits;
112: END IF;
113: ROLLBACK TO Lock_Order_Object;
114: WHEN OTHERS THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: IF FND_MSG_PUB.Check_Msg_Level
117: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
118: THEN
119: OE_MSG_PUB.Add_Exc_Msg

Line 199: x_return_status := FND_API.G_RET_STS_SUCCESS;

195: --
196: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
197: --
198: BEGIN
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: IF l_debug_level > 0 THEN
202: oe_debug_pub.add( 'ENTERING OE_ORDER_UTIL.UPDATE_GLOBAL_PICTURE' , 1 ) ;
203: END IF;

Line 250: IF g_old_header_rec.header_id=FND_API.G_MISS_NUM OR

246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add( 'P_HEADER_ID=' || P_HEADER_ID , 1 ) ;
248: END IF;
249:
250: IF g_old_header_rec.header_id=FND_API.G_MISS_NUM OR
251: g_old_header_rec.header_id is NULL THEN
252:
253: IF p_old_header_rec.header_id=FND_API.G_MISS_NUM OR
254: P_old_header_rec.header_id is NULL THEN

Line 253: IF p_old_header_rec.header_id=FND_API.G_MISS_NUM OR

249:
250: IF g_old_header_rec.header_id=FND_API.G_MISS_NUM OR
251: g_old_header_rec.header_id is NULL THEN
252:
253: IF p_old_header_rec.header_id=FND_API.G_MISS_NUM OR
254: P_old_header_rec.header_id is NULL THEN
255:
256: IF p_header_Rec.header_id is not null and
257: p_header_Rec.operation = oe_globals.g_opr_create THEN

Line 294: g_header_rec.change_reason <> FND_API.G_MISS_CHAR) THEN

290: END IF;
291: -- Begin Audit/Versioning changes (retain old change reason)
292: IF (OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
293: g_header_rec.change_reason IS NOT NULL AND
294: g_header_rec.change_reason <> FND_API.G_MISS_CHAR) THEN
295: l_reason_existed := TRUE;
296: l_change_reason := g_header_rec.change_reason;
297: l_change_comments := g_header_rec.change_comments;
298: END IF;

Line 346: IF l_result = FND_API.G_FALSE THEN

342: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STAT , 1 ) ;
343: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
344: END IF;
345:
346: IF l_result = FND_API.G_FALSE THEN
347:
348: IF p_old_hdr_scr_rec.sales_credit_id = FND_API.G_MISS_NUM OR
349: p_old_hdr_scr_rec.sales_credit_id is NULL THEN
350:

Line 348: IF p_old_hdr_scr_rec.sales_credit_id = FND_API.G_MISS_NUM OR

344: END IF;
345:
346: IF l_result = FND_API.G_FALSE THEN
347:
348: IF p_old_hdr_scr_rec.sales_credit_id = FND_API.G_MISS_NUM OR
349: p_old_hdr_scr_rec.sales_credit_id is NULL THEN
350:
351: IF p_hdr_scr_rec.sales_credit_id is not null and
352: p_hdr_scr_rec.operation = oe_globals.g_opr_create THEN

Line 375: g_header_scredit_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR) THEN

371: -- Begin Audit/Versioning changes (retain old change reason)
372: IF (OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
373: g_header_scredit_tbl.exists(l_ind) AND
374: g_header_scredit_tbl(l_ind).change_reason IS NOT NULL AND
375: g_header_scredit_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR) THEN
376: l_reason_existed := TRUE;
377: l_change_reason := g_header_scredit_tbl(l_ind).change_reason;
378: l_change_comments := g_header_scredit_tbl(l_ind).change_comments;
379: END IF;

Line 428: IF l_result = FND_API.G_FALSE THEN

424: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STAT , 1 ) ;
425: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
426: END IF;
427:
428: IF l_result = FND_API.G_FALSE THEN
429: IF p_old_hdr_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM OR
430: p_old_hdr_adj_rec.price_adjustment_id is NULL THEN
431:
432: IF p_hdr_adj_rec.price_adjustment_id is not null and

Line 429: IF p_old_hdr_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM OR

425: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
426: END IF;
427:
428: IF l_result = FND_API.G_FALSE THEN
429: IF p_old_hdr_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM OR
430: p_old_hdr_adj_rec.price_adjustment_id is NULL THEN
431:
432: IF p_hdr_adj_rec.price_adjustment_id is not null and
433: p_hdr_adj_rec.operation = oe_globals.g_opr_create THEN

Line 456: g_header_adj_tbl(l_ind).change_reason_code <> FND_API.G_MISS_CHAR) THEN

452: -- Begin Audit/Versioning changes (retain old change reason)
453: IF (OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
454: g_header_adj_tbl.exists(l_ind) AND
455: g_header_adj_tbl(l_ind).change_reason_code IS NOT NULL AND
456: g_header_adj_tbl(l_ind).change_reason_code <> FND_API.G_MISS_CHAR) THEN
457: l_reason_existed := TRUE;
458: l_change_reason := g_header_adj_tbl(l_ind).change_reason_code;
459: l_change_comments := g_header_adj_tbl(l_ind).change_reason_text;
460: END IF;

Line 510: IF l_result = FND_API.G_FALSE then

506: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STAT , 1 ) ;
507: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
508: END IF;
509:
510: IF l_result = FND_API.G_FALSE then
511: IF p_old_line_rec.line_id = FND_API.G_MISS_NUM OR
512: p_old_line_rec.line_id is NULL THEN
513:
514: IF p_line_rec.line_id is not null and

Line 511: IF p_old_line_rec.line_id = FND_API.G_MISS_NUM OR

507: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
508: END IF;
509:
510: IF l_result = FND_API.G_FALSE then
511: IF p_old_line_rec.line_id = FND_API.G_MISS_NUM OR
512: p_old_line_rec.line_id is NULL THEN
513:
514: IF p_line_rec.line_id is not null and
515: p_line_rec.operation = oe_globals.g_opr_create THEN

Line 539: g_line_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR) THEN

535: -- Begin Audit/Versioning changes (retain old change reason)
536: IF (OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
537: g_line_tbl.exists(l_ind) AND
538: g_line_tbl(l_ind).change_reason IS NOT NULL AND
539: g_line_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR) THEN
540: l_reason_existed := TRUE;
541: l_change_reason := g_line_tbl(l_ind).change_reason;
542: l_change_comments := g_line_tbl(l_ind).change_comments;
543: END IF;

Line 591: IF l_result = FND_API.G_FALSE THEN

587: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STAT , 1 ) ;
588: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
589: END IF;
590:
591: IF l_result = FND_API.G_FALSE THEN
592: IF p_old_line_scr_rec.sales_credit_id = FND_API.G_MISS_NUM OR
593: p_old_line_scr_rec.sales_credit_id is NULL THEN
594:
595: IF p_line_scr_rec.sales_credit_id is not null and

Line 592: IF p_old_line_scr_rec.sales_credit_id = FND_API.G_MISS_NUM OR

588: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
589: END IF;
590:
591: IF l_result = FND_API.G_FALSE THEN
592: IF p_old_line_scr_rec.sales_credit_id = FND_API.G_MISS_NUM OR
593: p_old_line_scr_rec.sales_credit_id is NULL THEN
594:
595: IF p_line_scr_rec.sales_credit_id is not null and
596: p_line_scr_rec.operation = oe_globals.g_opr_create THEN

Line 617: g_line_scredit_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR) THEN

613: -- Begin Audit/Versioning changes (retain old change reason)
614: IF (OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
615: g_line_scredit_tbl.exists(l_ind) AND
616: g_line_scredit_tbl(l_ind).change_reason IS NOT NULL AND
617: g_line_scredit_tbl(l_ind).change_reason <> FND_API.G_MISS_CHAR) THEN
618: l_reason_existed := TRUE;
619: l_change_reason := g_line_scredit_tbl(l_ind).change_reason;
620: l_change_comments := g_line_scredit_tbl(l_ind).change_comments;
621: END IF;

Line 671: IF l_result = FND_API.G_FALSE then

667: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
668: oe_debug_pub.add( 'OPERATION =' || P_LINE_ADJ_REC.OPERATION , 1 ) ;
669: END IF;
670:
671: IF l_result = FND_API.G_FALSE then
672: IF p_old_line_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM OR
673: p_old_line_adj_rec.price_adjustment_id is NULL THEN
674:
675: IF p_line_adj_rec.price_adjustment_id is not null and

Line 672: IF p_old_line_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM OR

668: oe_debug_pub.add( 'OPERATION =' || P_LINE_ADJ_REC.OPERATION , 1 ) ;
669: END IF;
670:
671: IF l_result = FND_API.G_FALSE then
672: IF p_old_line_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM OR
673: p_old_line_adj_rec.price_adjustment_id is NULL THEN
674:
675: IF p_line_adj_rec.price_adjustment_id is not null and
676: p_line_adj_rec.operation = oe_globals.g_opr_create THEN

Line 696: g_line_adj_tbl(l_ind).change_reason_code <> FND_API.G_MISS_CHAR) THEN

692: -- Begin Audit/Versioning changes (retain old change reason)
693: IF (OE_CODE_CONTROL.Code_Release_Level >= '110510' AND
694: g_line_adj_tbl.exists(l_ind) AND
695: g_line_adj_tbl(l_ind).change_reason_code IS NOT NULL AND
696: g_line_adj_tbl(l_ind).change_reason_code <> FND_API.G_MISS_CHAR) THEN
697: l_reason_existed := TRUE;
698: l_change_reason := g_line_adj_tbl(l_ind).change_reason_code;
699: l_change_comments := g_line_adj_tbl(l_ind).change_reason_text;
700: END IF;

Line 750: IF l_result = FND_API.G_FALSE then

746: oe_debug_pub.add( 'L_RETURN_STATUS =' || L_RETURN_STAT , 1 ) ;
747: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
748: END IF;
749:
750: IF l_result = FND_API.G_FALSE then
751: IF p_old_lot_serial_rec.lot_serial_id = FND_API.G_MISS_NUM OR
752: p_old_lot_serial_rec.lot_serial_id is NULL THEN
753:
754: IF p_lot_serial_rec.lot_serial_id is not null and

Line 751: IF p_old_lot_serial_rec.lot_serial_id = FND_API.G_MISS_NUM OR

747: oe_debug_pub.add( 'L_RESULT =' || L_RESULT , 1 ) ;
748: END IF;
749:
750: IF l_result = FND_API.G_FALSE then
751: IF p_old_lot_serial_rec.lot_serial_id = FND_API.G_MISS_NUM OR
752: p_old_lot_serial_rec.lot_serial_id is NULL THEN
753:
754: IF p_lot_serial_rec.lot_serial_id is not null and
755: p_lot_serial_rec.operation = oe_globals.g_opr_create THEN

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800: OE_MSG_PUB.Add_Exc_Msg
801: (G_PKG_NAME
802: ,'Update_Global_picture');
803: END IF;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805:
806: END Update_Global_Picture;
807:
808:

Line 834: x_return_status := FND_API.G_RET_STS_SUCCESS;

830: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
831: --
832: BEGIN
833:
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835: x_result := FND_API.G_FALSE;
836:
837: l_ind := (mod(p_entity_id,100000) * G_MAX_REQUESTS)+1;
838: l_max_ind := l_ind + G_MAX_REQUESTS - 1;

Line 835: x_result := FND_API.G_FALSE;

831: --
832: BEGIN
833:
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835: x_result := FND_API.G_FALSE;
836:
837: l_ind := (mod(p_entity_id,100000) * G_MAX_REQUESTS)+1;
838: l_max_ind := l_ind + G_MAX_REQUESTS - 1;
839:

Line 861: x_result := FND_API.G_TRUE;

857: IF (g_old_line_tbl(l_ind).line_id = p_entity_id OR
858: g_old_line_tbl(l_ind).line_id IS NULL )
859: THEN
860: x_index := l_ind;
861: x_result := FND_API.G_TRUE;
862: EXIT;
863: END IF;
864:
865: l_ind := g_old_line_tbl.Next(l_ind);

Line 887: x_result := FND_API.G_TRUE;

883: IF (g_old_header_scredit_tbl(l_ind).sales_credit_id = p_entity_id OR
884: g_old_header_scredit_tbl(l_ind).sales_credit_id IS NULL)
885: THEN
886: x_index := l_ind;
887: x_result := FND_API.G_TRUE;
888: EXIT;
889: END IF;
890:
891: l_ind := g_old_header_scredit_tbl.Next(l_ind);

Line 913: x_result := FND_API.G_TRUE;

909: IF (g_old_line_scredit_tbl(l_ind).sales_credit_id = p_entity_id OR
910: g_old_line_scredit_tbl(l_ind).sales_credit_id IS NULL)
911: THEN
912: x_index := l_ind;
913: x_result := FND_API.G_TRUE;
914: EXIT;
915: END IF;
916:
917: l_ind := g_old_line_scredit_tbl.Next(l_ind);

Line 940: x_result := FND_API.G_TRUE;

936: IF (g_old_header_adj_tbl(l_ind).price_adjustment_id= p_entity_id OR
937: g_old_header_adj_tbl(l_ind).price_adjustment_id IS NULL)
938: THEN
939: x_index := l_ind;
940: x_result := FND_API.G_TRUE;
941: EXIT;
942: END IF;
943:
944: l_ind := g_old_header_adj_tbl.Next(l_ind);

Line 965: x_result := FND_API.G_TRUE;

961: IF (g_old_line_adj_tbl(l_ind).price_adjustment_id = p_entity_id OR
962: g_old_line_adj_tbl(l_ind).price_adjustment_id IS NULL)
963: THEN
964: x_index := l_ind;
965: x_result := FND_API.G_TRUE;
966: EXIT;
967: END IF;
968:
969: l_ind := g_old_line_adj_tbl.Next(l_ind);

Line 990: x_result := FND_API.G_TRUE;

986: IF (g_old_lot_serial_tbl(l_ind).lot_serial_id = p_entity_id OR
987: g_old_lot_serial_tbl(l_ind).lot_serial_id IS NULL)
988: THEN
989: x_index := l_ind;
990: x_result := FND_API.G_TRUE;
991: EXIT;
992: END IF;
993:
994: l_ind := g_old_lot_serial_tbl.Next(l_ind);

Line 1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

998:
999: IF x_index > l_max_ind THEN
1000: FND_MESSAGE.SET_NAME('ONT','OE_MAX_REQUESTS_EXCEEDED');
1001: OE_MSG_PUB.ADD;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: END IF;
1004:
1005: IF l_debug_level > 0 THEN
1006: oe_debug_pub.add( 'EXITING OE_ORDER_UTIL.RETURN_GLB_ENT_INDEX' , 1 ) ;

Line 1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1014: OE_MSG_PUB.Add_Exc_Msg
1015: (G_PKG_NAME
1016: ,'Return_Glb_Ent_Index');
1017: END IF;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019:
1020:
1021: END Return_Glb_Ent_Index;
1022:

Line 1052: x_return_status := FND_API.G_RET_STS_SUCCESS;

1048: G_Lot_Serial_tbl.DELETE;
1049: --Bug 4569284
1050: OE_GLOBALS.G_FTE_REINVOKE:=NULL;
1051: --Bug 4569284
1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054: EXCEPTION
1055:
1056: WHEN OTHERS THEN

Line 1064: x_return_status := FND_API.G_RET_STS_ERROR;

1060: (G_PKG_NAME
1061: ,'Clear_Global_Picture');
1062: END IF;
1063:
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065:
1066: End Clear_Global_Picture;
1067:
1068: PROCEDURE Initialize_Access_List

Line 1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1261: , 'IS_ACTION_IN_ACCESS_LIST'
1262: );
1263: END IF;
1264:
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: END Add_Access;
1267:
1268: FUNCTION IS_ACTION_IN_ACCESS_LIST(Action_code in varchar2)
1269: RETURN BOOLEAN IS

Line 1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1313: , 'IS_ACTION_IN_ACCESS_LIST'
1314: );
1315: END IF;
1316:
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318:
1319: END IS_ACTION_IN_ACCESS_LIST;
1320:
1321: PROCEDURE Get_Access_List