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

Line 32: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 69: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 142: l_Commit := fnd_api.g_false;

138: Update_Ib_Exp EXCEPTION;
139:
140: BEGIN
141:
142: l_Commit := fnd_api.g_false;
143: l_Init_Msg_List := fnd_api.g_true;
144: l_Resolve_Id_Columns := fnd_api.g_false;
145: l_Create_Dest_Inst_Flag := fnd_api.g_false;
146: l_Validation_Level := fnd_api.g_valid_level_full;

Line 143: l_Init_Msg_List := fnd_api.g_true;

139:
140: BEGIN
141:
142: l_Commit := fnd_api.g_false;
143: l_Init_Msg_List := fnd_api.g_true;
144: l_Resolve_Id_Columns := fnd_api.g_false;
145: l_Create_Dest_Inst_Flag := fnd_api.g_false;
146: l_Validation_Level := fnd_api.g_valid_level_full;
147: l_Active_Instance_Only := fnd_api.g_false;

Line 144: l_Resolve_Id_Columns := fnd_api.g_false;

140: BEGIN
141:
142: l_Commit := fnd_api.g_false;
143: l_Init_Msg_List := fnd_api.g_true;
144: l_Resolve_Id_Columns := fnd_api.g_false;
145: l_Create_Dest_Inst_Flag := fnd_api.g_false;
146: l_Validation_Level := fnd_api.g_valid_level_full;
147: l_Active_Instance_Only := fnd_api.g_false;
148: l_Resolve_Id_Column := fnd_api.g_false;

Line 145: l_Create_Dest_Inst_Flag := fnd_api.g_false;

141:
142: l_Commit := fnd_api.g_false;
143: l_Init_Msg_List := fnd_api.g_true;
144: l_Resolve_Id_Columns := fnd_api.g_false;
145: l_Create_Dest_Inst_Flag := fnd_api.g_false;
146: l_Validation_Level := fnd_api.g_valid_level_full;
147: l_Active_Instance_Only := fnd_api.g_false;
148: l_Resolve_Id_Column := fnd_api.g_false;
149: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 146: l_Validation_Level := fnd_api.g_valid_level_full;

142: l_Commit := fnd_api.g_false;
143: l_Init_Msg_List := fnd_api.g_true;
144: l_Resolve_Id_Columns := fnd_api.g_false;
145: l_Create_Dest_Inst_Flag := fnd_api.g_false;
146: l_Validation_Level := fnd_api.g_valid_level_full;
147: l_Active_Instance_Only := fnd_api.g_false;
148: l_Resolve_Id_Column := fnd_api.g_false;
149: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
150: X_Error_Message := Null;

Line 147: l_Active_Instance_Only := fnd_api.g_false;

143: l_Init_Msg_List := fnd_api.g_true;
144: l_Resolve_Id_Columns := fnd_api.g_false;
145: l_Create_Dest_Inst_Flag := fnd_api.g_false;
146: l_Validation_Level := fnd_api.g_valid_level_full;
147: l_Active_Instance_Only := fnd_api.g_false;
148: l_Resolve_Id_Column := fnd_api.g_false;
149: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
150: X_Error_Message := Null;
151: t_transaction_id := -1;

Line 148: l_Resolve_Id_Column := fnd_api.g_false;

144: l_Resolve_Id_Columns := fnd_api.g_false;
145: l_Create_Dest_Inst_Flag := fnd_api.g_false;
146: l_Validation_Level := fnd_api.g_valid_level_full;
147: l_Active_Instance_Only := fnd_api.g_false;
148: l_Resolve_Id_Column := fnd_api.g_false;
149: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
150: X_Error_Message := Null;
151: t_transaction_id := -1;
152: IF (l_debug = 'Y') THEN

Line 149: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

145: l_Create_Dest_Inst_Flag := fnd_api.g_false;
146: l_Validation_Level := fnd_api.g_valid_level_full;
147: l_Active_Instance_Only := fnd_api.g_false;
148: l_Resolve_Id_Column := fnd_api.g_false;
149: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
150: X_Error_Message := Null;
151: t_transaction_id := -1;
152: IF (l_debug = 'Y') THEN
153: CSE_DEBUG_PUB.ADD('***** OUT NOCOPY OF SERVICE TRANSACTION ******');

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

214:
215:
216: -- get the error message from the stack if there is any error
217:
218: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
219: l_msg_index := 1;
220: l_Error_Message:=l_msg_data;
221: WHILE l_msg_count > 0
222: LOOP

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

219: l_msg_index := 1;
220: l_Error_Message:=l_msg_data;
221: WHILE l_msg_count > 0
222: LOOP
223: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
224: l_msg_index := l_msg_index + 1;
225: l_Msg_Count := l_Msg_Count - 1;
226: END LOOP;
227: RAISE Update_Ib_Exp;

Line 237: l_Return_Status := FND_API.G_RET_STS_ERROR;

233:
234: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
235: fnd_message.set_token('ITEM',P_Out_Of_Service_Attr_Rec.Item_Id);
236: l_error_message := fnd_message.get;
237: l_Return_Status := FND_API.G_RET_STS_ERROR;
238: RAISE Update_Ib_Exp;
239: END IF;
240:
241: -- check if there exist multiple source instances

Line 248: l_Return_Status := FND_API.G_RET_STS_ERROR;

244:
245: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
246: fnd_message.set_token('ITEM',P_Out_Of_Service_Attr_Rec.Item_Id);
247: l_error_message := fnd_message.get;
248: l_Return_Status := FND_API.G_RET_STS_ERROR;
249: RAISE Update_Ib_Exp;
250: END IF;
251:
252: -- continue if there exist only one source item instance

Line 275: l_Return_Status := FND_API.G_RET_STS_ERROR;

271: l_Instance_Header_Tbl_Out(i).Quantity) THEN
272: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
273: fnd_message.set_token('ITEM',P_Out_Of_Service_Attr_Rec.Item_Id);
274: l_error_message := fnd_message.get;
275: l_Return_Status := FND_API.G_RET_STS_ERROR;
276: RAISE Update_Ib_Exp;
277: END IF;
278:
279:

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

327:
328:
329: -- get the error message from the stack if there is any error
330:
331: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
332: l_msg_index := 1;
333: l_Error_Message:=l_msg_data;
334: WHILE l_msg_count > 0 LOOP
335: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

331: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
332: l_msg_index := 1;
333: l_Error_Message:=l_msg_data;
334: WHILE l_msg_count > 0 LOOP
335: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
336: l_msg_index := l_msg_index + 1;
337: l_Msg_Count := l_Msg_Count - 1;
338: END LOOP;
339: RAISE Update_Ib_Exp;

Line 340: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

336: l_msg_index := l_msg_index + 1;
337: l_Msg_Count := l_Msg_Count - 1;
338: END LOOP;
339: RAISE Update_Ib_Exp;
340: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
341: IF t_transaction_id =-1 THEN
342: t_transaction_id := l_txn_rec.transaction_id;
343: END IF;
344: END IF;

Line 365: l_Active_Instance_Only:= FND_API.G_FALSE;

361: l_Instance_Query_Rec.Serial_Number:= P_Out_Of_Service_Attr_Rec.Serial_Number;
362: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
363: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
364: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
365: l_Active_Instance_Only:= FND_API.G_FALSE;
366:
367: IF (l_debug = 'Y') THEN
368: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
369: END IF;

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

387:
388:
389: -- get the error message from the stack if there is any error
390:
391: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
392: l_msg_index := 1;
393: l_Error_Message:=l_Msg_Data;
394: WHILE l_msg_count > 0
395: LOOP

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

392: l_msg_index := 1;
393: l_Error_Message:=l_Msg_Data;
394: WHILE l_msg_count > 0
395: LOOP
396: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
397: l_msg_index := l_msg_index + 1;
398: l_Msg_Count := l_Msg_Count - 1;
399: END LOOP;
400: RAISE Update_Ib_Exp;

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

452:
453:
454: -- get the error message from the stack if there is any error
455:
456: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
457: l_msg_index := 1;
458: l_Error_Message:=l_msg_data;
459: WHILE l_msg_count > 0 LOOP
460: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

456: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
457: l_msg_index := 1;
458: l_Error_Message:=l_msg_data;
459: WHILE l_msg_count > 0 LOOP
460: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
461: l_msg_index := l_msg_index + 1;
462: l_Msg_Count := l_Msg_Count - 1;
463: END LOOP;
464: RAISE Update_Ib_Exp;

Line 465: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

461: l_msg_index := l_msg_index + 1;
462: l_Msg_Count := l_Msg_Count - 1;
463: END LOOP;
464: RAISE Update_Ib_Exp;
465: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
466: IF t_transaction_id =-1 THEN
467: t_transaction_id := l_txn_rec.transaction_id;
468: END IF;
469: END IF;

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

475: X_Instance_Rec => l_Dest_Instance_Rec,
476: X_Return_Status => l_Return_Status,
477: X_Error_Message => l_Error_Message);
478:
479: IF NOT(l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN
480: RAISE Update_Ib_Exp;
481: END IF;
482:
483:

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

542: x_msg_data => l_Msg_Data );
543:
544: -- get the error message from the stack if there is any error
545:
546: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
547: l_msg_index := 1;
548: l_Error_Message:=l_msg_data;
549: WHILE l_msg_count > 0 LOOP
550: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

546: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
547: l_msg_index := 1;
548: l_Error_Message:=l_msg_data;
549: WHILE l_msg_count > 0 LOOP
550: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
551: l_msg_index := l_msg_index + 1;
552: l_Msg_Count := l_Msg_Count - 1;
553: END LOOP;
554: RAISE Update_Ib_Exp;

Line 555: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

551: l_msg_index := l_msg_index + 1;
552: l_Msg_Count := l_Msg_Count - 1;
553: END LOOP;
554: RAISE Update_Ib_Exp;
555: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
556: IF t_transaction_id =-1 THEN
557: t_transaction_id := l_txn_rec.transaction_id;
558: END IF;
559: END IF;

Line 561: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

557: t_transaction_id := l_txn_rec.transaction_id;
558: END IF;
559: END IF;
560: ELSIF l_Dest_Instance_Rec.instance_id IS NULL THEN
561: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
562: END IF;
563:
564: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
565: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

Line 565: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

561: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
562: END IF;
563:
564: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
565: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
566: END IF;
567:
568: --create destination item instance ,if the dest item instance is not found
569:

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

566: END IF;
567:
568: --create destination item instance ,if the dest item instance is not found
569:
570: IF (l_Create_Dest_Inst_Flag = FND_API.G_TRUE ) THEN
571:
572: IF (l_debug = 'Y') THEN
573: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
574: END IF;

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

635: x_msg_data =>l_Msg_Data );
636:
637: -- get the error message from the stack if there is any error
638:
639: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
640: l_msg_index := 1;
641: l_Error_Message:=l_msg_data;
642: WHILE l_msg_count > 0 LOOP
643: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

639: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
640: l_msg_index := 1;
641: l_Error_Message:=l_msg_data;
642: WHILE l_msg_count > 0 LOOP
643: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
644: l_msg_index := l_msg_index + 1;
645: l_Msg_Count := l_Msg_Count - 1;
646: END LOOP;
647: RAISE Update_Ib_Exp;

Line 648: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

644: l_msg_index := l_msg_index + 1;
645: l_Msg_Count := l_Msg_Count - 1;
646: END LOOP;
647: RAISE Update_Ib_Exp;
648: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
649: IF t_transaction_id =-1 THEN
650: t_transaction_id := l_txn_rec.transaction_id;
651: END IF;
652: END IF;

Line 666: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

662: WHEN OTHERS THEN
663: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
664: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
665: x_error_message := fnd_message.get;
666: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
667:
668: END Update_Ib_Repository;
669: PROCEDURE Update_eib_instances(
670: P_Out_Of_Service_Attr_tbl IN Out_Of_Service_Attr_tbl_Type,