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.BSC_PERIODICITY_PVT dependencies on FND_API

Line 23: , p_Commit IN VARCHAR2 := FND_API.G_FALSE

19:
20:
21: PROCEDURE Create_Periods
22: ( p_Api_Version IN NUMBER
23: , p_Commit IN VARCHAR2 := FND_API.G_FALSE
24: , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
25: , x_Return_Status OUT NOCOPY VARCHAR2
26: , x_Msg_Count OUT NOCOPY NUMBER
27: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 42: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

38: l_No_Base_Periods NUMBER;
39: BEGIN
40: SAVEPOINT CreatePeriodsPVTSP;
41: FND_MSG_PUB.Initialize;
42: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
43:
44: IF(p_Period_Record.Base_Periodicity_Id IS NOT NULL) THEN
45: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Period_Record.Base_Periodicity_Id);
46: END IF;

Line 107: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN

103:
104: END LOOP;
105: END IF;
106:
107: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
108: COMMIT;
109: END IF;
110:
111: EXCEPTION

Line 114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

110:
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN
113: ROLLBACK TO CreatePeriodsPVTSP;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: IF (x_msg_data IS NOT NULL) THEN
116: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Create_Periods ';
117: ELSE
118: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';

Line 122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

118: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';
119: END IF;
120: WHEN OTHERS THEN
121: ROLLBACK TO CreatePeriodsPVTSP;
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: IF (x_msg_data IS NOT NULL) THEN
124: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Create_Periods ';
125: ELSE
126: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Create_Periods ';

Line 134: , p_Commit IN VARCHAR2 := FND_API.G_FALSE

130: /****************************************************************************************/
131:
132: PROCEDURE Update_Periods
133: ( p_Api_Version IN NUMBER
134: , p_Commit IN VARCHAR2 := FND_API.G_FALSE
135: , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
136: , x_Return_Status OUT NOCOPY VARCHAR2
137: , x_Msg_Count OUT NOCOPY NUMBER
138: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 144: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

140: l_System_Stage bsc_sys_init.property_value%TYPE;
141: BEGIN
142: SAVEPOINT UpdatePeriodsPVTSP;
143: FND_MSG_PUB.Initialize;
144: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
145:
146: BSC_PERIODICITY_PVT.Delete_Periods
147: ( p_Api_Version => p_Api_Version
148: , p_Commit => p_Commit

Line 154: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

150: , x_Return_Status => x_Return_Status
151: , x_Msg_Count => x_Msg_Count
152: , x_Msg_Data => x_Msg_Data
153: );
154: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: BSC_PERIODICITY_PVT.Create_Periods

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: , x_Msg_Count => x_Msg_Count
152: , x_Msg_Data => x_Msg_Data
153: );
154: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: END IF;
157:
158: BSC_PERIODICITY_PVT.Create_Periods
159: ( p_Api_Version => p_Api_Version

Line 166: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

162: , x_Return_Status => x_Return_Status
163: , x_Msg_Count => x_Msg_Count
164: , x_Msg_Data => x_Msg_Data
165: );
166: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: END IF;
169:
170: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN

Line 167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

163: , x_Msg_Count => x_Msg_Count
164: , x_Msg_Data => x_Msg_Data
165: );
166: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: END IF;
169:
170: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
171: COMMIT;

Line 170: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN

166: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
168: END IF;
169:
170: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
171: COMMIT;
172: END IF;
173:
174: EXCEPTION

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173:
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: ROLLBACK TO UpdatePeriodsPVTSP;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NOT NULL) THEN
179: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';
180: ELSE
181: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

181: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';
182: END IF;
183: WHEN OTHERS THEN
184: ROLLBACK TO UpdatePeriodsPVTSP;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF (x_msg_data IS NOT NULL) THEN
187: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Update_Periods ';
188: ELSE
189: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Update_Periods ';

Line 197: , p_Commit IN VARCHAR2 := FND_API.G_FALSE

193: /**********************************************************************************/
194:
195: PROCEDURE Delete_Periods
196: ( p_Api_Version IN NUMBER
197: , p_Commit IN VARCHAR2 := FND_API.G_FALSE
198: , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
199: , x_Return_Status OUT NOCOPY VARCHAR2
200: , x_Msg_Count OUT NOCOPY NUMBER
201: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 207: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

203:
204: BEGIN
205: SAVEPOINT DeletePeriodsPVTSP;
206: FND_MSG_PUB.Initialize;
207: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
208:
209: DELETE bsc_sys_periods
210: WHERE periodicity_id = p_Period_Record.Periodicity_Id;
211:

Line 215: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN

211:
212: DELETE bsc_sys_periods_tl
213: WHERE periodicity_id = p_Period_Record.Periodicity_Id;
214:
215: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
216: COMMIT;
217: END IF;
218:
219: EXCEPTION

Line 222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

218:
219: EXCEPTION
220: WHEN NO_DATA_FOUND THEN
221: ROLLBACK TO DeletePeriodsPVTSP;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF (x_msg_data IS NOT NULL) THEN
224: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';
225: ELSE
226: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

226: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';
227: END IF;
228: WHEN OTHERS THEN
229: ROLLBACK TO DeletePeriodsPVTSP;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: IF (x_msg_data IS NOT NULL) THEN
232: x_msg_data := x_msg_data||' -> BSC_PERIODICITY_PVT.Delete_Periods ';
233: ELSE
234: x_msg_data := SQLERRM||' at BSC_PERIODICITY_PVT.Delete_Periods ';