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 28: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 60: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 131: l_Commit := FND_API.G_FALSE;

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

Line 132: l_Init_Msg_List := FND_API.G_TRUE;

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

Line 133: l_Create_Dest_Inst_Flag := FND_API.G_FALSE;

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

Line 134: l_Validation_Level := fnd_api.g_valid_level_full;

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

Line 135: l_Active_Instance_Only := FND_API.G_FALSE;

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

Line 136: l_Resolve_Id_Column := FND_API.G_FALSE;

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

Line 139: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

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

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

Line 242: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

Line 255: l_Return_Status := FND_API.G_RET_STS_ERROR;

251: END IF;
252: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
253: fnd_message.set_token('ITEM',P_In_Service_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 285: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

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

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

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

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

Line 349: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

Line 374: l_Active_Instance_Only := FND_API.G_FALSE;

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

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

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

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

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

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

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

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

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

Line 473: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

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

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

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

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

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

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

Line 575: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

Line 582: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

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

Line 586: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

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

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

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

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

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

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

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

Line 674: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

Line 690: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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