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

Line 34: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

30:
31: BEGIN
32: SAVEPOINT CreateCalendarSP;
33: FND_MSG_PUB.Initialize;
34: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
35:
36: INSERT INTO bsc_sys_calendars_b
37: ( calendar_id
38: , edw_flag

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

102: WHERE T.calendar_id = p_Calendar_Record.Calendar_Id
103: AND T.LANGUAGE = L.LANGUAGE_CODE
104: );
105:
106: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
107: COMMIT;
108: END IF;
109:
110: EXCEPTION

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 143: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

139: l_System_Stage bsc_sys_init.property_value%TYPE;
140: BEGIN
141: SAVEPOINT UpdateCalendarSP;
142: FND_MSG_PUB.Initialize;
143: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
144:
145: -- added for Bug#4565308
146: UPDATE bsc_sys_calendars_b
147: SET fiscal_year = p_Calendar_Record.Fiscal_Year

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

171: WHERE calendar_id = p_Calendar_Record.Calendar_Id
172: AND periodicity_type = 1
173: );
174:
175: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
176: COMMIT;
177: END IF;
178:
179: EXCEPTION

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

178:
179: EXCEPTION
180: WHEN NO_DATA_FOUND THEN
181: ROLLBACK TO UpdateCalendarSP;
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: IF (x_msg_data IS NOT NULL) THEN
184: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Calendar ';
185: ELSE
186: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

186: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';
187: END IF;
188: WHEN OTHERS THEN
189: ROLLBACK TO UpdateCalendarSP;
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: IF (x_msg_data IS NOT NULL) THEN
192: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Calendar ';
193: ELSE
194: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Calendar ';

Line 210: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

206:
207: BEGIN
208: SAVEPOINT DeleteCalendarSP;
209: FND_MSG_PUB.Initialize;
210: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
211:
212: DELETE bsc_db_week_maps
213: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
214:

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

248:
249: DELETE bsc_sys_calendars_b
250: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
251:
252: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
253: COMMIT;
254: END IF;
255:
256: EXCEPTION

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

255:
256: EXCEPTION
257: WHEN NO_DATA_FOUND THEN
258: ROLLBACK TO DeleteCalendarSP;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: IF (x_msg_data IS NOT NULL) THEN
261: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Delete_Calendar ';
262: ELSE
263: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

263: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';
264: END IF;
265: WHEN OTHERS THEN
266: ROLLBACK TO DeleteCalendarSP;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
268: IF (x_msg_data IS NOT NULL) THEN
269: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Delete_Calendar ';
270: ELSE
271: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Delete_Calendar ';

Line 286: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

282: )IS
283: BEGIN
284: SAVEPOINT DeleteCalendarSP;
285: FND_MSG_PUB.Initialize;
286: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
287:
288: UPDATE bsc_sys_calendars_b
289: SET fiscal_change = 1
290: WHERE calendar_id = p_Calendar_Id;

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

288: UPDATE bsc_sys_calendars_b
289: SET fiscal_change = 1
290: WHERE calendar_id = p_Calendar_Id;
291:
292: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
293: COMMIT;
294: END IF;
295:
296: EXCEPTION

Line 299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

295:
296: EXCEPTION
297: WHEN NO_DATA_FOUND THEN
298: ROLLBACK TO DeleteCalendarSP;
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: IF (x_msg_data IS NOT NULL) THEN
301: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Fiscal_Change ';
302: ELSE
303: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';

Line 307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

303: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';
304: END IF;
305: WHEN OTHERS THEN
306: ROLLBACK TO DeleteCalendarSP;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: IF (x_msg_data IS NOT NULL) THEN
309: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_Fiscal_Change ';
310: ELSE
311: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_Fiscal_Change ';

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: END LOOP;
358:
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: IF (x_msg_data IS NOT NULL) THEN
363: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
364: ELSE
365: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';

Line 368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

364: ELSE
365: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
366: END IF;
367: WHEN OTHERS THEN
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: IF (x_msg_data IS NOT NULL) THEN
370: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';
371: ELSE
372: x_msg_data := SQLERRM||' at BSC_CALENDAR_PVT.Update_PeriodNames_In_Calendar ';