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

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

Line 68: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 141: l_Commit := fnd_api.g_false;

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

Line 142: l_Init_Msg_List := fnd_api.g_true;

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

Line 143: l_Resolve_Id_Columns := fnd_api.g_false;

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

Line 144: l_Create_Dest_Inst_Flag := fnd_api.g_false;

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

Line 145: l_Validation_Level := fnd_api.g_valid_level_full;

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

Line 146: l_Active_Instance_Only := fnd_api.g_false;

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

Line 147: l_Resolve_Id_Column := fnd_api.g_false;

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

Line 148: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

Line 236: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

Line 247: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

Line 274: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

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

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

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

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

Line 339: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

Line 364: l_Active_Instance_Only:= FND_API.G_FALSE;

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

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

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

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

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

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

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

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

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

Line 464: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

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

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

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

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

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

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

Line 554: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

Line 560: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

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

Line 564: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

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

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

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

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

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

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

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

Line 647: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

Line 665: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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