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

Line 30: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 66: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

73: X_Error_Message OUT NOCOPY VARCHAR2) IS
74:
75: l_Api_Name CONSTANT VARCHAR2(30) := 'CSE_PROJ_ITEM_INST_PKG';
76: l_api_version NUMBER DEFAULT 1.0;
77: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
78: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
79: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
80: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
81: l_Instance_Rec csi_datastructures_pub.Instance_Rec;

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

74:
75: l_Api_Name CONSTANT VARCHAR2(30) := 'CSE_PROJ_ITEM_INST_PKG';
76: l_api_version NUMBER DEFAULT 1.0;
77: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
78: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
79: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
80: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
81: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
82: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;

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

75: l_Api_Name CONSTANT VARCHAR2(30) := 'CSE_PROJ_ITEM_INST_PKG';
76: l_api_version NUMBER DEFAULT 1.0;
77: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
78: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
79: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;
80: l_Instance_Header_Tbl_Out csi_datastructures_pub.instance_header_tbl;
81: l_Instance_Rec csi_datastructures_pub.Instance_Rec;
82: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
83: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;

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

82: l_Dest_Instance_Rec csi_datastructures_pub.Instance_Rec;
83: l_Instance_Query_Rec csi_datastructures_pub.Instance_Query_Rec;
84: l_txn_rec csi_datastructures_pub.transaction_rec;
85: L_upd_txn_rec csi_datastructures_pub.transaction_rec;
86: l_Active_Instance_Only VARCHAR2(1) DEFAULT FND_API.G_FALSE;
87: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
88: l_Party_Query_Rec csi_datastructures_pub.party_query_rec;
89: l_party_tbl csi_datastructures_pub.party_tbl;
90: l_account_tbl csi_datastructures_pub.party_account_tbl;

Line 103: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;

99: l_object_version_number NUMBER :=1;
100: l_Msg_Count NUMBER;
101: l_Msg_Data VARCHAR2(2000);
102: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
103: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
104: l_Transaction_Id NUMBER;
105: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
106: l_Return_Status VARCHAR2(1);
107: l_Error_Message VARCHAR2(2000);

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

101: l_Msg_Data VARCHAR2(2000);
102: l_Account_Query_Rec csi_datastructures_pub.party_account_query_rec;
103: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;
104: l_Transaction_Id NUMBER;
105: l_Resolve_Id_Columns VARCHAR2(1) DEFAULT FND_API.G_FALSE;
106: l_Return_Status VARCHAR2(1);
107: l_Error_Message VARCHAR2(2000);
108: l_Hz_Location_Id NUMBER;
109: l_Location_Type_Code VARCHAR2(30) ;

Line 138: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

134: WHERE upper(name) ='EXPIRED';
135: Update_Ib_Exp EXCEPTION;
136:
137: BEGIN
138: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
139: X_Error_Message := Null;
140: -- l_Network_Location_Code := P_Proj_Item_Inst_Attr_Rec.Network_Location_Code;
141: If P_Proj_Item_Inst_Attr_Rec.Network_Location_id is not null then
142: l_hz_location_id :=P_Proj_Item_Inst_Attr_Rec.Network_Location_id ;

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

172: -- X_Hz_Location_Id => l_Hz_Location_Id,
173: -- X_Return_Status => l_Return_Status,
174: -- X_Error_Message => l_Error_Message);
175:
176: -- IF NOT(l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN
177: -- RAISE Update_Ib_Exp;
178: -- END IF;
179:
180: --check whether the the item is depreciable

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

233:
234:
235: -- get the error message from the stack if there is any error
236:
237: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
238: l_msg_index := 1;
239: l_Error_Message:=l_msg_data;
240: WHILE l_msg_count > 0 LOOP
241: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

237: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
238: l_msg_index := 1;
239: l_Error_Message:=l_msg_data;
240: WHILE l_msg_count > 0 LOOP
241: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
242: l_msg_index := l_msg_index + 1;
243: l_Msg_Count := l_Msg_Count - 1;
244: END LOOP;
245: RAISE Update_Ib_Exp;

Line 254: l_Return_Status := FND_API.G_RET_STS_ERROR;

250: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
251: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
252: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
253: l_error_message := fnd_message.get;
254: l_Return_Status := FND_API.G_RET_STS_ERROR;
255: RAISE Update_Ib_Exp;
256: END IF;
257:
258: -- check if there exist multiple source instances

Line 264: l_Return_Status := FND_API.G_RET_STS_ERROR;

260: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
261: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
262: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
263: l_error_message := fnd_message.get;
264: l_Return_Status := FND_API.G_RET_STS_ERROR;
265: RAISE Update_Ib_Exp;
266: END IF;
267:
268: -- continue if there exist only one source item instance

Line 292: l_Return_Status := FND_API.G_RET_STS_ERROR;

288: l_Instance_Header_Tbl_Out(i).Quantity) THEN
289: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
290: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
291: l_error_message := fnd_message.get;
292: l_Return_Status := FND_API.G_RET_STS_ERROR;
293: RAISE Update_Ib_Exp;
294: END IF;
295:
296:

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

356:
357:
358: -- get the error message from the stack if there is any error
359:
360: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
361: l_msg_index := 1;
362: l_Error_Message:=l_msg_data;
363: WHILE l_msg_count > 0 LOOP
364: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

360: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
361: l_msg_index := 1;
362: l_Error_Message:=l_msg_data;
363: WHILE l_msg_count > 0 LOOP
364: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
365: l_msg_index := l_msg_index + 1;
366: l_Msg_Count := l_Msg_Count - 1;
367: END LOOP;
368: RAISE Update_Ib_Exp;

Line 369: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

365: l_msg_index := l_msg_index + 1;
366: l_Msg_Count := l_Msg_Count - 1;
367: END LOOP;
368: RAISE Update_Ib_Exp;
369: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN
370: IF t_transaction_id =-1 THEN
371: t_transaction_id := l_txn_rec.transaction_id;
372: END IF;
373: END IF;

Line 397: l_Active_Instance_Only := FND_API.G_FALSE;

393: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
394: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
395: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_INSTALLED;
396:
397: l_Active_Instance_Only := FND_API.G_FALSE;
398:
399: IF (l_debug = 'Y') THEN
400: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
401: END IF;

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

417: x_msg_data => l_Msg_Data );
418:
419: -- get the error message from the stack if there is any error
420:
421: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
422: l_msg_index := 1;
423: l_Error_Message:=l_msg_data;
424: WHILE l_msg_count > 0 LOOP
425: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

421: IF NOT (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
422: l_msg_index := 1;
423: l_Error_Message:=l_msg_data;
424: WHILE l_msg_count > 0 LOOP
425: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
426: l_msg_index := l_msg_index + 1;
427: l_Msg_Count := l_Msg_Count - 1;
428: END LOOP;
429: RAISE Update_Ib_Exp;

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

480:
481:
482: -- get the error message from the stack if there is any error
483:
484: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
485: l_msg_index := 1;
486: l_Error_Message:=l_Msg_Data;
487: WHILE l_msg_count > 0 LOOP
488: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

484: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
485: l_msg_index := 1;
486: l_Error_Message:=l_Msg_Data;
487: WHILE l_msg_count > 0 LOOP
488: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
489: l_msg_index := l_msg_index + 1;
490: l_Msg_Count := l_Msg_Count - 1;
491: END LOOP;
492: RAISE Update_Ib_Exp;

Line 493: ELSIF (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

489: l_msg_index := l_msg_index + 1;
490: l_Msg_Count := l_Msg_Count - 1;
491: END LOOP;
492: RAISE Update_Ib_Exp;
493: ELSIF (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
494: IF t_transaction_Id = -1 THEN
495: t_transaction_id := l_txn_rec.transaction_id;
496: END IF;
497: END IF;

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

505: X_Return_Status => l_Return_Status,
506: X_Error_Message => l_Error_Message);
507:
508:
509: IF NOT(l_Return_Status = FND_API.G_RET_STS_SUCCESS) THEN
510: RAISE Update_Ib_Exp;
511: END IF;
512:
513:

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

582:
583: --l_Dest_transaction_id := l_txn_rec.transaction_id;
584: --l_upd_txn_rec.source_dist_ref_id2:= l_dest_transaction_id;
585:
586: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
587: l_msg_index := 1;
588: l_Error_Message:=l_Msg_Data;
589: WHILE l_msg_count > 0 LOOP
590: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

586: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
587: l_msg_index := 1;
588: l_Error_Message:=l_Msg_Data;
589: WHILE l_msg_count > 0 LOOP
590: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
591: l_msg_index := l_msg_index + 1;
592: l_Msg_Count := l_Msg_Count - 1;
593: END LOOP;
594: RAISE Update_Ib_Exp;

Line 595: ELSIF (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

591: l_msg_index := l_msg_index + 1;
592: l_Msg_Count := l_Msg_Count - 1;
593: END LOOP;
594: RAISE Update_Ib_Exp;
595: ELSIF (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
596: IF t_transaction_id =-1 THEN
597: t_transaction_id := l_txn_rec.transaction_id;
598: END IF;
599: END IF;

Line 602: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

598: END IF;
599: END IF;
600:
601: ELSIF l_Dest_Instance_Rec.Instance_Id IS NULL THEN
602: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
603: END IF;
604:
605: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
606: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

Line 606: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

602: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
603: END IF;
604:
605: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
606: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;
607: END IF;
608:
609: --create destination item instance ,if the dest item instance is not found
610:

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

607: END IF;
608:
609: --create destination item instance ,if the dest item instance is not found
610:
611: IF (l_Create_Dest_Inst_Flag = FND_API.G_TRUE ) THEN
612:
613: IF (l_debug = 'Y') THEN
614: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
615: END IF;

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

680: x_msg_data =>l_Msg_Data );
681:
682: -- get the error message from the stack if there is any error
683:
684: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
685: l_msg_index := 1;
686: l_Error_Message:=l_Msg_Data;
687: WHILE l_msg_count > 0 LOOP
688: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

684: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
685: l_msg_index := 1;
686: l_Error_Message:=l_Msg_Data;
687: WHILE l_msg_count > 0 LOOP
688: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
689: l_msg_index := l_msg_index + 1;
690: l_Msg_Count := l_Msg_Count - 1;
691: END LOOP;
692: RAISE Update_Ib_Exp;

Line 693: ELSIF (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

689: l_msg_index := l_msg_index + 1;
690: l_Msg_Count := l_Msg_Count - 1;
691: END LOOP;
692: RAISE Update_Ib_Exp;
693: ELSIF (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
694: IF t_transaction_id =-1 THEN
695: t_transaction_id := l_txn_rec.transaction_id;
696: END IF;
697: END IF;

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

723: IF (l_debug = 'Y') THEN
724: CSE_DEBUG_PUB.ADD('after calling csi_transactions_pvt.update_transactions');
725: END IF;
726:
727: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
728: l_msg_index := 1;
729: l_Error_Message:=l_Msg_Data;
730: WHILE l_msg_count > 0 LOOP
731: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);

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

727: IF NOT(l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
728: l_msg_index := 1;
729: l_Error_Message:=l_Msg_Data;
730: WHILE l_msg_count > 0 LOOP
731: l_Error_Message := FND_MSG_PUB.GET(l_msg_index,FND_API.G_FALSE);
732: l_msg_index := l_msg_index + 1;
733: l_Msg_Count := l_Msg_Count - 1;
734: END LOOP;
735: RAISE Update_Ib_Exp;

Line 736: ELSIF (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN

732: l_msg_index := l_msg_index + 1;
733: l_Msg_Count := l_Msg_Count - 1;
734: END LOOP;
735: RAISE Update_Ib_Exp;
736: ELSIF (l_Return_Status = FND_API.G_Ret_Sts_Success) THEN
737: IF NOT t_transaction_id =-1 THEN
738: l_txn_rec.transaction_id := t_transaction_id;
739: END IF;
740: END IF;

Line 756: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

752: WHEN OTHERS THEN
753: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
754: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
755: x_error_message := fnd_message.get;
756: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
757: END Update_Ib_Repository;
758: PROCEDURE Update_eib_instances(
759: P_proj_item_inst_Attr_tbl IN proj_item_inst_Attr_tbl_Type,
760: X_Return_Status OUT NOCOPY VARCHAR2,

Line 781: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

777: WHEN OTHERS THEN
778: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
779: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);
780: x_error_message := fnd_message.get;
781: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: END update_eib_instances;
784:
785: END CSE_PROJ_ITEM_INST_PKG;