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.

[Home] [Help]

APPS.CSE_PROJ_ITEM_INST_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 65: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

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

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

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

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

Line 102: l_Validation_Level NUMBER := fnd_api.g_valid_level_full;

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

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

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

Line 137: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

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

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

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

Line 253: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

Line 263: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

Line 291: l_Return_Status := FND_API.G_RET_STS_ERROR;

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

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

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

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

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

Line 368: ELSIF l_Return_Status = FND_API.G_Ret_Sts_Success THEN

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

Line 396: l_Active_Instance_Only := FND_API.G_FALSE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 601: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

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

Line 605: l_Create_Dest_Inst_Flag :=FND_API.G_TRUE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 755: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 780: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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