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.CSE_ITEM_MOVE_PKG dependencies on FND_API

Line 29: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

25: l_Transacted_By NUMBER;
26:
27: BEGIN
28:
29: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
30: X_Error_Message := Null;
31:
32: Xnp_Xml_Utils.Decode(P_Msg_Text,'ITEM_ID',l_Item_Id);
33: Xnp_Xml_Utils.Decode(P_Msg_Text,'REVISION',l_Revision);

Line 67: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

63: WHEN OTHERS THEN
64: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
65: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
66: x_error_message := fnd_message.get;
67: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
68:
69: END Decode_Message;
70:
71: PROCEDURE Update_Ib_Repository(

Line 78: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;

74: X_Error_Message OUT NOCOPY VARCHAR2) IS
75:
76: l_Api_Name CONSTANT VARCHAR2(30) :='CSE_ITEM_MOVE_PKG';
77: l_api_version NUMBER DEFAULT 1.0;
78: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
79: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
80: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
81: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
82: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;

Line 79: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;

75:
76: l_Api_Name CONSTANT VARCHAR2(30) :='CSE_ITEM_MOVE_PKG';
77: l_api_version NUMBER DEFAULT 1.0;
78: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
79: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
80: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
81: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
82: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;
83: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;

Line 80: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;

76: l_Api_Name CONSTANT VARCHAR2(30) :='CSE_ITEM_MOVE_PKG';
77: l_api_version NUMBER DEFAULT 1.0;
78: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
79: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
80: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
81: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
82: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;
83: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
84: l_Resolve_Id_Column VARCHAR2(1) DEFAULT FND_API.G_FALSE;

Line 81: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;

77: l_api_version NUMBER DEFAULT 1.0;
78: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
79: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
80: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
81: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
82: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;
83: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
84: l_Resolve_Id_Column VARCHAR2(1) DEFAULT FND_API.G_FALSE;
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;

Line 82: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;

78: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
79: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
80: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
81: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
82: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;
83: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
84: l_Resolve_Id_Column VARCHAR2(1) DEFAULT FND_API.G_FALSE;
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;

Line 83: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;

79: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
80: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
81: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
82: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;
83: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
84: l_Resolve_Id_Column VARCHAR2(1) DEFAULT FND_API.G_FALSE;
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;

Line 84: l_Resolve_Id_Column VARCHAR2(1) DEFAULT FND_API.G_FALSE;

80: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
81: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
82: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;
83: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
84: l_Resolve_Id_Column VARCHAR2(1) DEFAULT FND_API.G_FALSE;
85: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
86: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
87: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
88: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;

Line 139: l_Commit := FND_API.G_FALSE;

135: WHERE upper(name) ='EXPIRED';
136: Update_Ib_Exp EXCEPTION;
137:
138: BEGIN
139: l_Commit := FND_API.G_FALSE;
140: l_Init_Msg_List := FND_API.G_TRUE;
141: l_Resolve_Id_Columns := FND_API.G_FALSE;
142: l_Create_Dest_Inst_Flag:= FND_API.G_FALSE;
143: l_Active_Instance_Only := FND_API.G_FALSE;

Line 140: l_Init_Msg_List := FND_API.G_TRUE;

136: Update_Ib_Exp EXCEPTION;
137:
138: BEGIN
139: l_Commit := FND_API.G_FALSE;
140: l_Init_Msg_List := FND_API.G_TRUE;
141: l_Resolve_Id_Columns := FND_API.G_FALSE;
142: l_Create_Dest_Inst_Flag:= FND_API.G_FALSE;
143: l_Active_Instance_Only := FND_API.G_FALSE;
144: l_Validation_Level := fnd_api.g_valid_level_full;

Line 141: l_Resolve_Id_Columns := FND_API.G_FALSE;

137:
138: BEGIN
139: l_Commit := FND_API.G_FALSE;
140: l_Init_Msg_List := FND_API.G_TRUE;
141: l_Resolve_Id_Columns := FND_API.G_FALSE;
142: l_Create_Dest_Inst_Flag:= FND_API.G_FALSE;
143: l_Active_Instance_Only := FND_API.G_FALSE;
144: l_Validation_Level := fnd_api.g_valid_level_full;
145: l_Resolve_Id_Column := FND_API.G_FALSE;

Line 142: l_Create_Dest_Inst_Flag:= FND_API.G_FALSE;

138: BEGIN
139: l_Commit := FND_API.G_FALSE;
140: l_Init_Msg_List := FND_API.G_TRUE;
141: l_Resolve_Id_Columns := FND_API.G_FALSE;
142: l_Create_Dest_Inst_Flag:= FND_API.G_FALSE;
143: l_Active_Instance_Only := FND_API.G_FALSE;
144: l_Validation_Level := fnd_api.g_valid_level_full;
145: l_Resolve_Id_Column := FND_API.G_FALSE;
146: t_transaction_id := -1;

Line 143: l_Active_Instance_Only := FND_API.G_FALSE;

139: l_Commit := FND_API.G_FALSE;
140: l_Init_Msg_List := FND_API.G_TRUE;
141: l_Resolve_Id_Columns := FND_API.G_FALSE;
142: l_Create_Dest_Inst_Flag:= FND_API.G_FALSE;
143: l_Active_Instance_Only := FND_API.G_FALSE;
144: l_Validation_Level := fnd_api.g_valid_level_full;
145: l_Resolve_Id_Column := FND_API.G_FALSE;
146: t_transaction_id := -1;
147: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 144: l_Validation_Level := fnd_api.g_valid_level_full;

140: l_Init_Msg_List := FND_API.G_TRUE;
141: l_Resolve_Id_Columns := FND_API.G_FALSE;
142: l_Create_Dest_Inst_Flag:= FND_API.G_FALSE;
143: l_Active_Instance_Only := FND_API.G_FALSE;
144: l_Validation_Level := fnd_api.g_valid_level_full;
145: l_Resolve_Id_Column := FND_API.G_FALSE;
146: t_transaction_id := -1;
147: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
148: X_Error_Message := Null;

Line 145: l_Resolve_Id_Column := FND_API.G_FALSE;

141: l_Resolve_Id_Columns := FND_API.G_FALSE;
142: l_Create_Dest_Inst_Flag:= FND_API.G_FALSE;
143: l_Active_Instance_Only := FND_API.G_FALSE;
144: l_Validation_Level := fnd_api.g_valid_level_full;
145: l_Resolve_Id_Column := FND_API.G_FALSE;
146: t_transaction_id := -1;
147: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
148: X_Error_Message := Null;
149:

Line 147: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

143: l_Active_Instance_Only := FND_API.G_FALSE;
144: l_Validation_Level := fnd_api.g_valid_level_full;
145: l_Resolve_Id_Column := FND_API.G_FALSE;
146: t_transaction_id := -1;
147: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
148: X_Error_Message := Null;
149:
150: -- If the option is set turn on the debug log.
151:

Line 203: l_Active_Instance_Only := FND_API.G_TRUE; --Added for bug 7423694, base bug 7233717

199: l_Instance_Query_Rec.Serial_Number := P_Item_Move_Attr_Rec.Serial_Number;
200: l_Instance_Query_Rec.Location_Id := l_From_Hz_Location_Id;
201: l_Instance_Query_Rec.Location_Type_Code:= l_from_Location_Type_Code;
202: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
203: l_Active_Instance_Only := FND_API.G_TRUE; --Added for bug 7423694, base bug 7233717
204:
205: IF (l_debug = 'Y') THEN
206: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
207: END IF;

Line 227: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

223: x_msg_data =>l_Msg_Data );
224:
225: -- get the error message from the stack if there is any error
226:
227: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
228: l_msg_index := 1;
229: l_Error_Message:=l_Msg_Data;
230: WHILE l_msg_count > 0
231: LOOP

Line 232: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

228: l_msg_index := 1;
229: l_Error_Message:=l_Msg_Data;
230: WHILE l_msg_count > 0
231: LOOP
232: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
233: l_msg_index := l_msg_index + 1;
234: l_Msg_Count := l_Msg_Count - 1;
235: END LOOP;
236: RAISE Update_Ib_Exp;

Line 245: l_Return_Status := FND_API.G_RET_STS_ERROR;

241: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
242: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
243: fnd_message.set_token('ITEM',P_Item_Move_Attr_Rec.Item_Id);
244: l_error_message := fnd_message.get;
245: l_Return_Status := FND_API.G_RET_STS_ERROR;
246: RAISE Update_Ib_Exp;
247: END IF;
248:
249: -- check if there exist multiple source instances

Line 255: l_Return_Status := FND_API.G_RET_STS_ERROR;

251: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
252: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
253: fnd_message.set_token('ITEM',P_Item_Move_Attr_Rec.Item_Id);
254: l_error_message := fnd_message.get;
255: l_Return_Status := FND_API.G_RET_STS_ERROR;
256: RAISE Update_Ib_Exp;
257: END IF;
258:
259: -- continue if there exist only one source item instance

Line 282: l_Return_Status := FND_API.G_RET_STS_ERROR;

278: l_Instance_Header_Tbl_Out(i).Quantity) THEN
279: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
280: fnd_message.set_token('ITEM',P_Item_Move_Attr_Rec.Item_Id);
281: l_error_message := fnd_message.get;
282: l_Return_Status := FND_API.G_RET_STS_ERROR;
283: RAISE Update_Ib_Exp;
284: END IF;
285:
286:

Line 339: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

335:
336:
337: -- get the error message from the stack if there is any error
338:
339: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
340: l_msg_index := 1;
341: l_Error_Message:=l_msg_data;
342: WHILE l_msg_count > 0 LOOP
343: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

Line 343: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

339: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
340: l_msg_index := 1;
341: l_Error_Message:=l_msg_data;
342: WHILE l_msg_count > 0 LOOP
343: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
344: l_msg_index := l_msg_index + 1;
345: l_Msg_Count := l_Msg_Count - 1;
346: END LOOP;
347: RAISE Update_Ib_Exp;

Line 348: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

344: l_msg_index := l_msg_index + 1;
345: l_Msg_Count := l_Msg_Count - 1;
346: END LOOP;
347: RAISE Update_Ib_Exp;
348: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
349: IF t_transaction_id =-1 THEN
350: t_transaction_id := l_txn_rec.transaction_id;
351: END IF;
352: END IF;

Line 373: l_Active_Instance_Only := FND_API.G_FALSE;

369: l_Instance_Query_Rec.Serial_Number := P_Item_Move_Attr_Rec.Serial_Number;
370: l_Instance_Query_Rec.Location_Id := l_To_Hz_Location_Id;
371: l_Instance_Query_Rec.Location_Type_Code:= l_to_Location_Type_Code;
372: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
373: l_Active_Instance_Only := FND_API.G_FALSE;
374:
375: IF (l_debug = 'Y') THEN
376: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
377: END IF;

Line 398: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

394:
395:
396: -- get the error message from the stack if there is any error
397:
398: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
399: l_msg_index := 1;
400: l_Error_Message:=l_msg_data;
401: WHILE l_msg_count > 0
402: LOOP

Line 403: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

399: l_msg_index := 1;
400: l_Error_Message:=l_msg_data;
401: WHILE l_msg_count > 0
402: LOOP
403: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
404: l_msg_index := l_msg_index + 1;
405: l_Msg_Count := l_Msg_Count - 1;
406: END LOOP;
407: RAISE Update_Ib_Exp;

Line 463: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

459:
460:
461: -- get the error message from the stack if there is any error
462:
463: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
464: l_msg_index := 1;
465: l_Error_Message:=l_msg_data;
466: WHILE l_msg_count > 0 LOOP
467: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

Line 467: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

463: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
464: l_msg_index := 1;
465: l_Error_Message:=l_msg_data;
466: WHILE l_msg_count > 0 LOOP
467: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
468: l_msg_index := l_msg_index + 1;
469: l_Msg_Count := l_Msg_Count - 1;
470: END LOOP;
471: RAISE Update_Ib_Exp;

Line 472: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

468: l_msg_index := l_msg_index + 1;
469: l_Msg_Count := l_Msg_Count - 1;
470: END LOOP;
471: RAISE Update_Ib_Exp;
472: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
473: IF t_transaction_id =-1 THEN
474: t_transaction_id := l_txn_rec.transaction_id;
475: END IF;
476: END IF;

Line 486: IF NOT(l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN

482: X_Instance_Rec => l_Dest_Instance_Rec,
483: X_Return_Status => l_Return_Status,
484: X_Error_Message => l_Error_Message);
485:
486: IF NOT(l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN
487: RAISE Update_Ib_Exp;
488: END IF;
489:
490: -- If destination item instance is found

Line 556: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

552:
553:
554: -- get the error message from the stack if there is any error
555:
556: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
557: l_msg_index := 1;
558: l_Error_Message:=l_msg_data;
559: WHILE l_msg_count > 0 LOOP
560: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

Line 560: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

556: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
557: l_msg_index := 1;
558: l_Error_Message:=l_msg_data;
559: WHILE l_msg_count > 0 LOOP
560: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
561: l_msg_index := l_msg_index + 1;
562: l_Msg_Count := l_Msg_Count - 1;
563: END LOOP;
564: RAISE Update_Ib_Exp;

Line 565: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

561: l_msg_index := l_msg_index + 1;
562: l_Msg_Count := l_Msg_Count - 1;
563: END LOOP;
564: RAISE Update_Ib_Exp;
565: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
566: IF t_transaction_id =-1 THEN
567: t_transaction_id := l_txn_rec.transaction_id;
568: END IF;
569: END IF;

Line 571: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

567: t_transaction_id := l_txn_rec.transaction_id;
568: END IF;
569: END IF;
570: ELSIF l_Dest_Instance_Rec.instance_id IS NULL THEN
571: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
572: END IF;
573:
574: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
575: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

Line 575: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

571: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
572: END IF;
573:
574: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
575: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
576: END IF;
577:
578: --create destination item instance ,if the dest item instance is not found
579:

Line 580: IF (l_Create_Dest_Inst_Flag = FND_API.G_TRUE ) THEN

576: END IF;
577:
578: --create destination item instance ,if the dest item instance is not found
579:
580: IF (l_Create_Dest_Inst_Flag = FND_API.G_TRUE ) THEN
581:
582: IF (l_debug = 'Y') THEN
583: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
584: END IF;

Line 648: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

644:
645:
646: -- get the error message from the stack if there is any error
647:
648: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
649: l_msg_index := 1;
650: l_Error_Message:=l_msg_data;
651: WHILE l_msg_count > 0 LOOP
652: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

Line 652: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

648: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
649: l_msg_index := 1;
650: l_Error_Message:=l_msg_data;
651: WHILE l_msg_count > 0 LOOP
652: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
653: l_msg_index := l_msg_index + 1;
654: l_Msg_Count := l_Msg_Count - 1;
655: END LOOP;
656: RAISE Update_Ib_Exp;

Line 657: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

653: l_msg_index := l_msg_index + 1;
654: l_Msg_Count := l_Msg_Count - 1;
655: END LOOP;
656: RAISE Update_Ib_Exp;
657: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
658: IF t_transaction_id =-1 THEN
659: t_transaction_id := l_txn_rec.transaction_id;
660: END IF;
661: END IF;

Line 676: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

672: WHEN OTHERS THEN
673: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
674: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
675: x_error_message := fnd_message.get;
676: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
677:
678: END Update_Ib_Repository;
679: PROCEDURE Update_eib_instances(
680: P_Item_Move_Attr_tbl IN Item_Move_Attr_tbl_Type,