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_IN_SERVICE_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 61: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

57: WHEN OTHERS THEN
58: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
59: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
60: x_error_message := fnd_message.get;
61: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
62: END Decode_Message;
63:
64: PROCEDURE Update_Ib_Repository(
65: P_In_Service_Attr_Rec IN In_Service_Attr_Rec_Type,

Line 132: l_Commit := FND_API.G_FALSE;

128: WHERE upper(name) ='EXPIRED';
129: Update_Ib_Exp EXCEPTION;
130:
131: BEGIN
132: l_Commit := FND_API.G_FALSE;
133: l_Init_Msg_List := FND_API.G_TRUE;
134: l_Create_Dest_Inst_Flag := FND_API.G_FALSE;
135: l_Validation_Level := fnd_api.g_valid_level_full;
136: l_Active_Instance_Only := FND_API.G_FALSE;

Line 133: l_Init_Msg_List := FND_API.G_TRUE;

129: Update_Ib_Exp EXCEPTION;
130:
131: BEGIN
132: l_Commit := FND_API.G_FALSE;
133: l_Init_Msg_List := FND_API.G_TRUE;
134: l_Create_Dest_Inst_Flag := FND_API.G_FALSE;
135: l_Validation_Level := fnd_api.g_valid_level_full;
136: l_Active_Instance_Only := FND_API.G_FALSE;
137: l_Resolve_Id_Column := FND_API.G_FALSE;

Line 134: l_Create_Dest_Inst_Flag := FND_API.G_FALSE;

130:
131: BEGIN
132: l_Commit := FND_API.G_FALSE;
133: l_Init_Msg_List := FND_API.G_TRUE;
134: l_Create_Dest_Inst_Flag := FND_API.G_FALSE;
135: l_Validation_Level := fnd_api.g_valid_level_full;
136: l_Active_Instance_Only := FND_API.G_FALSE;
137: l_Resolve_Id_Column := FND_API.G_FALSE;
138: t_transaction_id := -1;

Line 135: l_Validation_Level := fnd_api.g_valid_level_full;

131: BEGIN
132: l_Commit := FND_API.G_FALSE;
133: l_Init_Msg_List := FND_API.G_TRUE;
134: l_Create_Dest_Inst_Flag := FND_API.G_FALSE;
135: l_Validation_Level := fnd_api.g_valid_level_full;
136: l_Active_Instance_Only := FND_API.G_FALSE;
137: l_Resolve_Id_Column := FND_API.G_FALSE;
138: t_transaction_id := -1;
139:

Line 136: l_Active_Instance_Only := FND_API.G_FALSE;

132: l_Commit := FND_API.G_FALSE;
133: l_Init_Msg_List := FND_API.G_TRUE;
134: l_Create_Dest_Inst_Flag := FND_API.G_FALSE;
135: l_Validation_Level := fnd_api.g_valid_level_full;
136: l_Active_Instance_Only := FND_API.G_FALSE;
137: l_Resolve_Id_Column := FND_API.G_FALSE;
138: t_transaction_id := -1;
139:
140: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 137: l_Resolve_Id_Column := FND_API.G_FALSE;

133: l_Init_Msg_List := FND_API.G_TRUE;
134: l_Create_Dest_Inst_Flag := FND_API.G_FALSE;
135: l_Validation_Level := fnd_api.g_valid_level_full;
136: l_Active_Instance_Only := FND_API.G_FALSE;
137: l_Resolve_Id_Column := FND_API.G_FALSE;
138: t_transaction_id := -1;
139:
140: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
141: X_Error_Message := Null;

Line 140: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

136: l_Active_Instance_Only := FND_API.G_FALSE;
137: l_Resolve_Id_Column := FND_API.G_FALSE;
138: t_transaction_id := -1;
139:
140: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
141: X_Error_Message := Null;
142:
143: IF (l_debug = 'Y') THEN
144: CSE_DEBUG_PUB.ADD('***** IN SERVICE TRANSACTION ******');

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

175: -- X_Hz_Location_Id => l_Hz_Location_Id,
176: -- X_Return_Status => l_Return_Status,
177: -- X_Error_Message => l_Error_Message);
178:
179: -- IF NOT(l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN
180: -- RAISE Update_Ib_Exp;
181: -- END IF;
182:
183: --Step 2, Query for the existence of the source record

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

193: l_Instance_Query_Rec.Serial_Number := P_In_Service_Attr_Rec.Serial_Number;
194: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
195: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
196: l_Instance_Query_Rec.Instance_Usage_Code :=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
197: l_Active_Instance_Only := FND_API.G_TRUE; --Added for bug 7423694, base bug 7233717
198:
199: IF (l_debug = 'Y') THEN
200: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
201: END IF;

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

219:
220:
221: -- get the error message from the stack if there is any error
222:
223: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
224: l_msg_index := 1;
225: l_Error_Message:=l_msg_data;
226: WHILE l_msg_count > 0 LOOP
227: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

223: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
224: l_msg_index := 1;
225: l_Error_Message:=l_msg_data;
226: WHILE l_msg_count > 0 LOOP
227: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
228: l_msg_index := l_msg_index + 1;
229: l_Msg_Count := l_Msg_Count - 1;
230: END LOOP;
231: RAISE Update_Ib_Exp;

Line 243: l_Return_Status := FND_API.G_RET_STS_ERROR;

239: END IF;
240: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
241: fnd_message.set_token('ITEM',P_In_Service_Attr_Rec.Item_Id);
242: l_error_message := fnd_message.get;
243: l_Return_Status := FND_API.G_RET_STS_ERROR;
244: RAISE Update_Ib_Exp;
245: END IF;
246:
247: -- check if there exist multiple source instances

Line 256: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

Line 286: l_Return_Status := FND_API.G_RET_STS_ERROR;

282: END IF;
283: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
284: fnd_message.set_token('ITEM',P_In_Service_Attr_Rec.Item_Id);
285: l_error_message := fnd_message.get;
286: l_Return_Status := FND_API.G_RET_STS_ERROR;
287: RAISE Update_Ib_Exp;
288: END IF;
289:
290:

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

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

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

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

Line 350: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

Line 375: l_Active_Instance_Only := FND_API.G_FALSE;

371: l_Instance_Query_Rec.Serial_Number := P_In_Service_Attr_Rec.Serial_Number;
372: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
373: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
374: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_IN_SERVICE;
375: l_Active_Instance_Only := FND_API.G_FALSE;
376:
377: IF (l_debug = 'Y') THEN
378: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
379: END IF;

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

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

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

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

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

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

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

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

Line 474: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

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

489: X_Instance_Rec => l_Dest_Instance_Rec,
490: X_Return_Status => l_Return_Status,
491: X_Error_Message => l_Error_Message);
492:
493: IF NOT(l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN
494: RAISE Update_Ib_Exp;
495: END IF;
496:
497: -- If destination item instance is found

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

563:
564:
565: -- get the error message from the stack if there is any error
566:
567: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
568: l_msg_index := 1;
569: l_Error_Message:=l_msg_data;
570: WHILE l_msg_count > 0 LOOP
571: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

567: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
568: l_msg_index := 1;
569: l_Error_Message:=l_msg_data;
570: WHILE l_msg_count > 0 LOOP
571: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
572: l_msg_index := l_msg_index + 1;
573: l_Msg_Count := l_Msg_Count - 1;
574: END LOOP;
575: RAISE Update_Ib_Exp;

Line 576: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

572: l_msg_index := l_msg_index + 1;
573: l_Msg_Count := l_Msg_Count - 1;
574: END LOOP;
575: RAISE Update_Ib_Exp;
576: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
577: IF t_transaction_id =-1 THEN
578: t_transaction_id := l_txn_rec.transaction_id;
579: END IF;
580: END IF;

Line 583: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

579: END IF;
580: END IF;
581:
582: ELSIF l_Dest_Instance_Rec.instance_id IS NULL THEN
583: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
584: END IF;
585:
586: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
587: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

Line 587: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

583: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
584: END IF;
585:
586: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
587: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
588: END IF;
589: END IF;
590:
591: --create destination item instance ,if the dest item instance is not found

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

589: END IF;
590:
591: --create destination item instance ,if the dest item instance is not found
592:
593: IF (l_Create_Dest_Inst_Flag = FND_API.G_TRUE ) THEN
594:
595: IF (l_debug = 'Y') THEN
596: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
597: END IF;

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

662: x_msg_data => l_Msg_Data );
663:
664: -- get the error message from the stack if there is any error
665:
666: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
667: l_msg_index := 1;
668: l_Error_Message:=l_msg_data;
669: WHILE l_msg_count > 0 LOOP
670: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

666: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
667: l_msg_index := 1;
668: l_Error_Message:=l_msg_data;
669: WHILE l_msg_count > 0 LOOP
670: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
671: l_msg_index := l_msg_index + 1;
672: l_Msg_Count := l_Msg_Count - 1;
673: END LOOP;
674: RAISE Update_Ib_Exp;

Line 675: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

671: l_msg_index := l_msg_index + 1;
672: l_Msg_Count := l_Msg_Count - 1;
673: END LOOP;
674: RAISE Update_Ib_Exp;
675: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
676: IF t_transaction_id =-1 THEN
677: t_transaction_id := l_txn_rec.transaction_id;
678: END IF;
679: END IF;

Line 691: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

687: WHEN OTHERS THEN
688: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
689: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
690: x_error_message := fnd_message.get;
691: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
692:
693: END Update_Ib_Repository;
694: PROCEDURE update_eib_instances(
695: P_In_Service_Attr_tbl IN In_Service_Attr_tbl_Type,