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

Line 66: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

62: BEGIN
63: SAVEPOINT CreatePeriodicityPUB;
64: FND_MSG_PUB.Initialize;
65:
66: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
67: l_Dim_Enabled := FND_API.G_TRUE;
68: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
69:
70: BSC_PERIODICITIES_PUB.Populate_Periodicity_Record (

Line 67: l_Dim_Enabled := FND_API.G_TRUE;

63: SAVEPOINT CreatePeriodicityPUB;
64: FND_MSG_PUB.Initialize;
65:
66: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
67: l_Dim_Enabled := FND_API.G_TRUE;
68: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
69:
70: BSC_PERIODICITIES_PUB.Populate_Periodicity_Record (
71: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

Line 78: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

74: ,x_Return_Status => x_Return_Status
75: ,x_Msg_Count => x_Msg_Count
76: ,x_Msg_Data => x_Msg_Data
77: );
78: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: BSC_PERIODICITIES_PUB.Validate_Periodicity (

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75: ,x_Msg_Count => x_Msg_Count
76: ,x_Msg_Data => x_Msg_Data
77: );
78: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: BSC_PERIODICITIES_PUB.Validate_Periodicity (
83: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

Line 90: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

86: ,x_Return_Status => x_Return_Status
87: ,x_Msg_Count => x_Msg_Count
88: ,x_Msg_Data => x_Msg_Data
89: );
90: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: BSC_PERIODICITIES_PVT.Create_Periodicity (

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: ,x_Msg_Count => x_Msg_Count
88: ,x_Msg_Data => x_Msg_Data
89: );
90: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: BSC_PERIODICITIES_PVT.Create_Periodicity (
95: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

Line 102: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

98: ,x_Return_Status => x_Return_Status
99: ,x_Msg_Count => x_Msg_Count
100: ,x_Msg_Data => x_Msg_Data
101: );
102: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: ,x_Msg_Count => x_Msg_Count
100: ,x_Msg_Data => x_Msg_Data
101: );
102: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (
107: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

Line 116: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

112: ,x_Return_Status => x_Return_Status
113: ,x_Msg_Count => x_Msg_Count
114: ,x_Msg_Data => x_Msg_Data
115: );
116: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: BSC_PERIODICITIES_PUB.Update_Annually_Source (

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113: ,x_Msg_Count => x_Msg_Count
114: ,x_Msg_Data => x_Msg_Data
115: );
116: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: BSC_PERIODICITIES_PUB.Update_Annually_Source (
121: p_Calendar_Id => l_Periodicities_Rec_Type.Calendar_Id

Line 128: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

124: ,x_Return_Status => x_Return_Status
125: ,x_Msg_Count => x_Msg_Count
126: ,x_Msg_Data => x_Msg_Data
127: );
128: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: END IF;
131:
132: BSC_PERIODS_PUB.Create_Periodicity_View (

Line 129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

125: ,x_Msg_Count => x_Msg_Count
126: ,x_Msg_Data => x_Msg_Data
127: );
128: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
130: END IF;
131:
132: BSC_PERIODS_PUB.Create_Periodicity_View (
133: p_Periodicity_Id => l_Periodicities_Rec_Type.Periodicity_Id

Line 141: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

137: , x_Return_Status => x_Return_Status
138: , x_Msg_Count => x_Msg_Count
139: , x_Msg_Data => x_Msg_Data
140: );
141: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144: IF(l_Periodicities_Rec_Type.Periodicity_Type IN (11,12) )THEN
145: l_Dim_Enabled := FND_API.G_FALSE;

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

138: , x_Msg_Count => x_Msg_Count
139: , x_Msg_Data => x_Msg_Data
140: );
141: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144: IF(l_Periodicities_Rec_Type.Periodicity_Type IN (11,12) )THEN
145: l_Dim_Enabled := FND_API.G_FALSE;
146: END IF;

Line 145: l_Dim_Enabled := FND_API.G_FALSE;

141: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144: IF(l_Periodicities_Rec_Type.Periodicity_Type IN (11,12) )THEN
145: l_Dim_Enabled := FND_API.G_FALSE;
146: END IF;
147:
148: l_Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(l_Periodicities_Rec_Type.Calendar_Id);
149: l_Dimobj_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period

Line 180: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

176: , x_return_status => x_return_status
177: , x_msg_count => x_msg_count
178: , x_msg_data => x_msg_data
179: );
180: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183: IF(l_Periodicities_Rec_Type.ForceRunPopulateCalendar = FND_API.G_TRUE ) THEN
184: BSC_UPDATE_UTIL.Populate_Calendar_Tables

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: , x_msg_count => x_msg_count
178: , x_msg_data => x_msg_data
179: );
180: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183: IF(l_Periodicities_Rec_Type.ForceRunPopulateCalendar = FND_API.G_TRUE ) THEN
184: BSC_UPDATE_UTIL.Populate_Calendar_Tables
185: ( p_commit => p_Commit

Line 183: IF(l_Periodicities_Rec_Type.ForceRunPopulateCalendar = FND_API.G_TRUE ) THEN

179: );
180: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: END IF;
183: IF(l_Periodicities_Rec_Type.ForceRunPopulateCalendar = FND_API.G_TRUE ) THEN
184: BSC_UPDATE_UTIL.Populate_Calendar_Tables
185: ( p_commit => p_Commit
186: , p_calendar_id => l_Periodicities_Rec_Type.Calendar_Id
187: , x_return_status => x_Return_Status

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

187: , x_return_status => x_Return_Status
188: , x_msg_count => x_Msg_Count
189: , x_msg_data => x_Msg_Data
190: );
191: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194: END IF;
195: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN

Line 192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

188: , x_msg_count => x_Msg_Count
189: , x_msg_data => x_Msg_Data
190: );
191: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194: END IF;
195: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
196: COMMIT;

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

191: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194: END IF;
195: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
196: COMMIT;
197: END IF;
198:
199: EXCEPTION

Line 200: WHEN FND_API.G_EXC_ERROR THEN

196: COMMIT;
197: END IF;
198:
199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO CreatePeriodicityPUB;
202: IF (x_msg_data IS NULL) THEN
203: FND_MSG_PUB.Count_And_Get
204: ( p_encoded => FND_API.G_FALSE

Line 204: ( p_encoded => FND_API.G_FALSE

200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO CreatePeriodicityPUB;
202: IF (x_msg_data IS NULL) THEN
203: FND_MSG_PUB.Count_And_Get
204: ( p_encoded => FND_API.G_FALSE
205: , p_count => x_msg_count
206: , p_data => x_msg_data
207: );
208: END IF;

Line 209: x_Return_Status := FND_API.G_RET_STS_ERROR;

205: , p_count => x_msg_count
206: , p_data => x_msg_data
207: );
208: END IF;
209: x_Return_Status := FND_API.G_RET_STS_ERROR;
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO CreatePeriodicityPUB;
212: IF (x_msg_data IS NULL) THEN
213: FND_MSG_PUB.Count_And_Get

Line 210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

206: , p_data => x_msg_data
207: );
208: END IF;
209: x_Return_Status := FND_API.G_RET_STS_ERROR;
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO CreatePeriodicityPUB;
212: IF (x_msg_data IS NULL) THEN
213: FND_MSG_PUB.Count_And_Get
214: ( p_encoded => FND_API.G_FALSE

Line 214: ( p_encoded => FND_API.G_FALSE

210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO CreatePeriodicityPUB;
212: IF (x_msg_data IS NULL) THEN
213: FND_MSG_PUB.Count_And_Get
214: ( p_encoded => FND_API.G_FALSE
215: , p_count => x_msg_count
216: , p_data => x_msg_data
217: );
218: END IF;

Line 219: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

215: , p_count => x_msg_count
216: , p_data => x_msg_data
217: );
218: END IF;
219: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
220: WHEN NO_DATA_FOUND THEN
221: ROLLBACK TO CreatePeriodicityPUB;
222: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
223: IF (x_msg_data IS NOT NULL) THEN

Line 222: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

218: END IF;
219: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
220: WHEN NO_DATA_FOUND THEN
221: ROLLBACK TO CreatePeriodicityPUB;
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_PERIODICITIES_PUB.Create_Periodicity ';
225: ELSE
226: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';

Line 230: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

226: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';
227: END IF;
228: WHEN OTHERS THEN
229: ROLLBACK TO CreatePeriodicityPUB;
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_PERIODICITIES_PUB.Create_Periodicity ';
233: ELSE
234: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Create_Periodicity ';

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

237:
238:
239: PROCEDURE Update_Periodicity (
240: p_Api_Version IN NUMBER
241: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
242: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
243: ,p_disable_period_val_flag IN VARCHAR2
244: ,x_Return_Status OUT NOCOPY VARCHAR2
245: ,x_Msg_Count OUT NOCOPY NUMBER

Line 259: l_Dim_Enabled := FND_API.G_TRUE;

255: l_Dim_Enabled VARCHAR2(10);
256: BEGIN
257: SAVEPOINT UpdatePeriodicityPUB;
258: FND_MSG_PUB.Initialize;
259: l_Dim_Enabled := FND_API.G_TRUE;
260: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
261:
262: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
263:

Line 260: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

256: BEGIN
257: SAVEPOINT UpdatePeriodicityPUB;
258: FND_MSG_PUB.Initialize;
259: l_Dim_Enabled := FND_API.G_TRUE;
260: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
261:
262: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
263:
264: l_Structural_Flag := FND_API.G_FALSE;

Line 264: l_Structural_Flag := FND_API.G_FALSE;

260: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
261:
262: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
263:
264: l_Structural_Flag := FND_API.G_FALSE;
265:
266: BSC_PERIODICITIES_PUB.Validate_Periodicity (
267: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
268: ,p_Periodicities_Rec_Type => l_Periodicities_Rec_Type

Line 274: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

270: ,x_Return_Status => x_Return_Status
271: ,x_Msg_Count => x_Msg_Count
272: ,x_Msg_Data => x_Msg_Data
273: );
274: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: BSC_PERIODICITIES_PUB.Get_Incr_Change (

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: ,x_Msg_Count => x_Msg_Count
272: ,x_Msg_Data => x_Msg_Data
273: );
274: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: BSC_PERIODICITIES_PUB.Get_Incr_Change (
279: p_Periodicity_Id => l_Periodicities_Rec_Type.Periodicity_Id

Line 284: ,p_Return_Values => FND_API.G_FALSE

280: ,p_Calendar_ID => l_Periodicities_Rec_Type.Calendar_Id
281: ,p_Base_Periodicity_Id => l_Periodicities_Rec_Type.Base_Periodicity_Id
282: ,p_Num_Of_Periods => l_Periodicities_Rec_Type.Num_Of_Periods
283: ,p_Period_Ids => l_Periodicities_Rec_Type.Period_IDs
284: ,p_Return_Values => FND_API.G_FALSE
285: ,x_Message_Name => l_Message_Name
286: ,x_Objective_List => l_Objective_List
287: );
288:

Line 298: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

294: ,x_Return_Status => x_Return_Status
295: ,x_Msg_Count => x_Msg_Count
296: ,x_Msg_Data => x_Msg_Data
297: );
298: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301:
302: IF (l_Message_Name IS NOT NULL) THEN

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: ,x_Msg_Count => x_Msg_Count
296: ,x_Msg_Data => x_Msg_Data
297: );
298: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301:
302: IF (l_Message_Name IS NOT NULL) THEN
303: l_Structural_Flag := FND_API.G_TRUE;

Line 303: l_Structural_Flag := FND_API.G_TRUE;

299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301:
302: IF (l_Message_Name IS NOT NULL) THEN
303: l_Structural_Flag := FND_API.G_TRUE;
304: END IF ;
305:
306: BSC_PERIODICITIES_PUB.Populate_Period_Metadata (
307: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

Line 316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

312: ,x_Return_Status => x_Return_Status
313: ,x_Msg_Count => x_Msg_Count
314: ,x_Msg_Data => x_Msg_Data
315: );
316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: BSC_PERIODICITIES_PUB.Update_Annually_Source(

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: ,x_Msg_Count => x_Msg_Count
314: ,x_Msg_Data => x_Msg_Data
315: );
316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: BSC_PERIODICITIES_PUB.Update_Annually_Source(
321: p_Calendar_Id => l_Periodicities_Rec_Type.Calendar_Id

Line 328: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

324: ,x_Return_Status => x_Return_Status
325: ,x_Msg_Count => x_Msg_Count
326: ,x_Msg_Data => x_Msg_Data
327: );
328: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
330: END IF;
331:
332: -- Recreate underlying views.

Line 329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

325: ,x_Msg_Count => x_Msg_Count
326: ,x_Msg_Data => x_Msg_Data
327: );
328: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
330: END IF;
331:
332: -- Recreate underlying views.
333: BSC_PERIODS_PUB.Create_Periodicity_View

Line 343: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

339: , x_Return_Status => x_Return_Status
340: , x_Msg_Count => x_Msg_Count
341: , x_Msg_Data => x_Msg_Data
342: );
343: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346:
347: IF(l_Periodicities_Rec_Type.Periodicity_Type IN (11,12) )THEN

Line 344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

340: , x_Msg_Count => x_Msg_Count
341: , x_Msg_Data => x_Msg_Data
342: );
343: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346:
347: IF(l_Periodicities_Rec_Type.Periodicity_Type IN (11,12) )THEN
348: l_Dim_Enabled := FND_API.G_FALSE;

Line 348: l_Dim_Enabled := FND_API.G_FALSE;

344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
345: END IF;
346:
347: IF(l_Periodicities_Rec_Type.Periodicity_Type IN (11,12) )THEN
348: l_Dim_Enabled := FND_API.G_FALSE;
349: END IF;
350:
351: l_Dim_Short_Name := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(l_Periodicities_Rec_Type.Calendar_Id);
352: l_Dimobj_Name := BSC_PERIODS_UTILITY_PKG.get_Dimobj_Name_From_period

Line 384: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

380: , x_Return_Status => x_Return_Status
381: , x_Msg_Count => x_Msg_Count
382: , x_Msg_Data => x_Msg_Data
383: );
384: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387:
388:

Line 385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

381: , x_Msg_Count => x_Msg_Count
382: , x_Msg_Data => x_Msg_Data
383: );
384: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387:
388:
389: IF (l_Structural_Flag = FND_API.G_TRUE) THEN

Line 389: IF (l_Structural_Flag = FND_API.G_TRUE) THEN

385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387:
388:
389: IF (l_Structural_Flag = FND_API.G_TRUE) THEN
390: BSC_PERIODICITIES_PVT.Incr_Refresh_Objectives(
391: p_Commit => p_Commit
392: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
393: ,x_Return_Status => x_Return_Status

Line 397: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

393: ,x_Return_Status => x_Return_Status
394: ,x_Msg_Count => x_Msg_Count
395: ,x_Msg_Data => x_Msg_Data
396: );
397: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400: END IF;
401: -- populate Calendar tables.

Line 398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

394: ,x_Msg_Count => x_Msg_Count
395: ,x_Msg_Data => x_Msg_Data
396: );
397: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400: END IF;
401: -- populate Calendar tables.
402:

Line 403: IF(l_Periodicities_Rec_Type.ForceRunPopulateCalendar = FND_API.G_TRUE ) THEN

399: END IF;
400: END IF;
401: -- populate Calendar tables.
402:
403: IF(l_Periodicities_Rec_Type.ForceRunPopulateCalendar = FND_API.G_TRUE ) THEN
404: BSC_UPDATE_UTIL.Populate_Calendar_Tables
405: ( p_commit => p_Commit
406: , p_calendar_id => l_Periodicities_Rec_Type.Calendar_Id
407: , x_return_status => x_Return_Status

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

407: , x_return_status => x_Return_Status
408: , x_msg_count => x_Msg_Count
409: , x_msg_data => x_Msg_Data
410: );
411: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414:
415: END IF;

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408: , x_msg_count => x_Msg_Count
409: , x_msg_data => x_Msg_Data
410: );
411: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414:
415: END IF;
416:

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

413: END IF;
414:
415: END IF;
416:
417: IF ((p_Commit IS NOT NULL) AND p_Commit = FND_API.G_TRUE) THEN
418: COMMIT;
419: END IF;
420:
421: EXCEPTION

Line 422: WHEN FND_API.G_EXC_ERROR THEN

418: COMMIT;
419: END IF;
420:
421: EXCEPTION
422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO UpdatePeriodicityPUB;
424: IF (x_msg_data IS NULL) THEN
425: FND_MSG_PUB.Count_And_Get
426: ( p_encoded => FND_API.G_FALSE

Line 426: ( p_encoded => FND_API.G_FALSE

422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO UpdatePeriodicityPUB;
424: IF (x_msg_data IS NULL) THEN
425: FND_MSG_PUB.Count_And_Get
426: ( p_encoded => FND_API.G_FALSE
427: , p_count => x_msg_count
428: , p_data => x_msg_data
429: );
430: END IF;

Line 431: x_Return_Status := FND_API.G_RET_STS_ERROR;

427: , p_count => x_msg_count
428: , p_data => x_msg_data
429: );
430: END IF;
431: x_Return_Status := FND_API.G_RET_STS_ERROR;
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO UpdatePeriodicityPUB;
434: IF (x_msg_data IS NULL) THEN
435: FND_MSG_PUB.Count_And_Get

Line 432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

428: , p_data => x_msg_data
429: );
430: END IF;
431: x_Return_Status := FND_API.G_RET_STS_ERROR;
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO UpdatePeriodicityPUB;
434: IF (x_msg_data IS NULL) THEN
435: FND_MSG_PUB.Count_And_Get
436: ( p_encoded => FND_API.G_FALSE

Line 436: ( p_encoded => FND_API.G_FALSE

432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO UpdatePeriodicityPUB;
434: IF (x_msg_data IS NULL) THEN
435: FND_MSG_PUB.Count_And_Get
436: ( p_encoded => FND_API.G_FALSE
437: , p_count => x_msg_count
438: , p_data => x_msg_data
439: );
440: END IF;

Line 441: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

437: , p_count => x_msg_count
438: , p_data => x_msg_data
439: );
440: END IF;
441: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
442: WHEN NO_DATA_FOUND THEN
443: ROLLBACK TO UpdatePeriodicityPUB;
444: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
445: IF (x_msg_data IS NOT NULL) THEN

Line 444: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

440: END IF;
441: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
442: WHEN NO_DATA_FOUND THEN
443: ROLLBACK TO UpdatePeriodicityPUB;
444: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
445: IF (x_msg_data IS NOT NULL) THEN
446: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Update_Periodicity ';
447: ELSE
448: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';

Line 452: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

448: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';
449: END IF;
450: WHEN OTHERS THEN
451: ROLLBACK TO UpdatePeriodicityPUB;
452: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF (x_msg_data IS NOT NULL) THEN
454: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Update_Periodicity ';
455: ELSE
456: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Update_Periodicity ';

Line 487: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

483: BEGIN
484: SAVEPOINT DeletePeriodicityPUB;
485: FND_MSG_PUB.Initialize;
486:
487: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
488: --dbms_output.PUT_LINE('p_Periodicities_Rec_Type.Periodicity_Id - ' ||p_Periodicities_Rec_Type.Periodicity_Id);
489: --dbms_output.PUT_LINE('p_Periodicities_Rec_Type.Calendar_Id - ' ||p_Periodicities_Rec_Type.Calendar_Id);
490:
491:

Line 500: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

496: ,x_Return_Status => x_Return_Status
497: ,x_Msg_Count => x_Msg_Count
498: ,x_Msg_Data => x_Msg_Data
499: );
500: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: l_Dim_Object_SN := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Short_Name(p_Periodicities_Rec_Type.Periodicity_Id);

Line 501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

497: ,x_Msg_Count => x_Msg_Count
498: ,x_Msg_Data => x_Msg_Data
499: );
500: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
502: END IF;
503:
504: l_Dim_Object_SN := BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Short_Name(p_Periodicities_Rec_Type.Periodicity_Id);
505: l_Dimension_SN := BSC_PERIODS_UTILITY_PKG.Get_Calendar_Short_Name(p_Periodicities_Rec_Type.Calendar_Id);

Line 524: RAISE FND_API.G_EXC_ERROR;

520: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_obj_name);
521: FND_MESSAGE.SET_TOKEN('DIM_OBJ_NAME', l_dim_name);
522: FND_MESSAGE.SET_TOKEN('REPORTS_ASSOC', l_regions);
523: FND_MSG_PUB.ADD;
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: BSC_PERIODICITIES_PVT.Delete_Periodicity (
528: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

Line 535: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

531: ,x_Return_Status => x_Return_Status
532: ,x_Msg_Count => x_Msg_Count
533: ,x_Msg_Data => x_Msg_Data
534: );
535: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:
539: BSC_PERIODICITIES_PUB.Update_Annually_Source(

Line 536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

532: ,x_Msg_Count => x_Msg_Count
533: ,x_Msg_Data => x_Msg_Data
534: );
535: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:
539: BSC_PERIODICITIES_PUB.Update_Annually_Source(
540: p_Calendar_Id => p_Periodicities_Rec_Type.Calendar_Id

Line 547: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

543: ,x_Return_Status => x_Return_Status
544: ,x_Msg_Count => x_Msg_Count
545: ,x_Msg_Data => x_Msg_Data
546: );
547: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END IF;
550:
551:

Line 548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

544: ,x_Msg_Count => x_Msg_Count
545: ,x_Msg_Data => x_Msg_Data
546: );
547: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END IF;
550:
551:
552: --dbms_output.PUT_LINE('Shortnames - ' || l_Dim_Object_SN || ', ' || l_Dimension_SN);

Line 562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

558: , x_return_status => x_return_status
559: , x_msg_count => x_msg_count
560: , x_msg_data => x_msg_data
561: );
562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565:
566: --dbms_output.PUT_LINE(' After Unassign_Dimensions ');

Line 563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

559: , x_msg_count => x_msg_count
560: , x_msg_data => x_msg_data
561: );
562: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565:
566: --dbms_output.PUT_LINE(' After Unassign_Dimensions ');
567:

Line 580: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

576: , x_return_status => x_return_status
577: , x_msg_count => x_msg_count
578: , x_msg_data => x_msg_data
579: );
580: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:
584: --dbms_output.PUT_LINE(' After Delete_Dim_Object ');

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: , x_msg_count => x_msg_count
578: , x_msg_data => x_msg_data
579: );
580: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END IF;
583:
584: --dbms_output.PUT_LINE(' After Delete_Dim_Object ');
585:

Line 596: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

592: , x_Return_Status => x_Return_Status
593: , x_Msg_Count => x_Msg_Count
594: , x_Msg_Data => x_Msg_Data
595: );
596: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: END IF;
600:

Line 597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

593: , x_Msg_Count => x_Msg_Count
594: , x_Msg_Data => x_Msg_Data
595: );
596: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: END IF;
600:
601: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN

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

597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END IF;
599: END IF;
600:
601: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
602: COMMIT;
603: END IF;
604:
605: EXCEPTION

Line 606: WHEN FND_API.G_EXC_ERROR THEN

602: COMMIT;
603: END IF;
604:
605: EXCEPTION
606: WHEN FND_API.G_EXC_ERROR THEN
607: ROLLBACK TO DeletePeriodicityPUB;
608: IF (x_msg_data IS NULL) THEN
609: FND_MSG_PUB.Count_And_Get
610: ( p_encoded => FND_API.G_FALSE

Line 610: ( p_encoded => FND_API.G_FALSE

606: WHEN FND_API.G_EXC_ERROR THEN
607: ROLLBACK TO DeletePeriodicityPUB;
608: IF (x_msg_data IS NULL) THEN
609: FND_MSG_PUB.Count_And_Get
610: ( p_encoded => FND_API.G_FALSE
611: , p_count => x_msg_count
612: , p_data => x_msg_data
613: );
614: END IF;

Line 615: x_Return_Status := FND_API.G_RET_STS_ERROR;

611: , p_count => x_msg_count
612: , p_data => x_msg_data
613: );
614: END IF;
615: x_Return_Status := FND_API.G_RET_STS_ERROR;
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO DeletePeriodicityPUB;
618: IF (x_msg_data IS NULL) THEN
619: FND_MSG_PUB.Count_And_Get

Line 616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

612: , p_data => x_msg_data
613: );
614: END IF;
615: x_Return_Status := FND_API.G_RET_STS_ERROR;
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO DeletePeriodicityPUB;
618: IF (x_msg_data IS NULL) THEN
619: FND_MSG_PUB.Count_And_Get
620: ( p_encoded => FND_API.G_FALSE

Line 620: ( p_encoded => FND_API.G_FALSE

616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO DeletePeriodicityPUB;
618: IF (x_msg_data IS NULL) THEN
619: FND_MSG_PUB.Count_And_Get
620: ( p_encoded => FND_API.G_FALSE
621: , p_count => x_msg_count
622: , p_data => x_msg_data
623: );
624: END IF;

Line 625: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

621: , p_count => x_msg_count
622: , p_data => x_msg_data
623: );
624: END IF;
625: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
626: WHEN NO_DATA_FOUND THEN
627: ROLLBACK TO DeletePeriodicityPUB;
628: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF (x_msg_data IS NOT NULL) THEN

Line 628: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

624: END IF;
625: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
626: WHEN NO_DATA_FOUND THEN
627: ROLLBACK TO DeletePeriodicityPUB;
628: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF (x_msg_data IS NOT NULL) THEN
630: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Delete_Periodicity ';
631: ELSE
632: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';

Line 636: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

632: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';
633: END IF;
634: WHEN OTHERS THEN
635: ROLLBACK TO DeletePeriodicityPUB;
636: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
637: IF (x_msg_data IS NOT NULL) THEN
638: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Delete_Periodicity ';
639: ELSE
640: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Delete_Periodicity ';

Line 659: ,p_disable_period_val_flag => FND_API.G_FALSE

655: (
656: p_Api_Version => p_Api_Version
657: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
658: ,p_Action_Type => p_Action_Type
659: ,p_disable_period_val_flag => FND_API.G_FALSE
660: ,x_Return_Status => x_Return_Status
661: ,x_Msg_Count => x_Msg_Count
662: ,x_Msg_Data => x_Msg_Data
663: );

Line 695: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

691: BEGIN
692: SAVEPOINT ValidatePeriodicityPUB;
693:
694: FND_MSG_PUB.Initialize;
695: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
696:
697:
698: IF ((p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) OR (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE)) THEN
699:

Line 703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

699:
700: IF (p_Periodicities_Rec_Type.Calendar_Id IS NULL) THEN
701: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_ID_NULL');
702: FND_MSG_PUB.ADD;
703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
704: END IF;
705:
706: IF (p_Periodicities_Rec_Type.Custom_Code <> BSC_PERIODS_UTILITY_PKG.C_BASE_PERIODICITY_TYPE) THEN
707: IF (p_Periodicities_Rec_Type.Base_Periodicity_Id IS NULL) THEN

Line 710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

706: IF (p_Periodicities_Rec_Type.Custom_Code <> BSC_PERIODS_UTILITY_PKG.C_BASE_PERIODICITY_TYPE) THEN
707: IF (p_Periodicities_Rec_Type.Base_Periodicity_Id IS NULL) THEN
708: FND_MESSAGE.SET_NAME('BSC','BSC_BASE_PERIODICITY_NULL');
709: FND_MSG_PUB.ADD;
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:
713: IF (p_Periodicities_Rec_Type.Period_IDs IS NULL) THEN
714: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_IDS_NULL');

Line 716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

712:
713: IF (p_Periodicities_Rec_Type.Period_IDs IS NULL) THEN
714: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_IDS_NULL');
715: FND_MSG_PUB.ADD;
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718: END IF;
719:
720: l_Is_Name_Unique := BSC_PERIODS_UTILITY_PKG.Is_Period_Name_Unique (

Line 729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

725: -- Validation#3
726: IF (p_Periodicities_Rec_Type.Num_Of_Periods IS NULL) THEN
727: FND_MESSAGE.SET_NAME('BSC','BSC_NUM_PERIODS_CANNOT_NULL');
728: FND_MSG_PUB.ADD;
729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
730: END IF;
731:
732:
733:

Line 737: IF(l_Is_Name_Unique = FND_API.G_FALSE) THEN

733:
734: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_CREATE) THEN
735:
736: -- Validation#1:
737: IF(l_Is_Name_Unique = FND_API.G_FALSE) THEN
738: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_EXISTS');
739: FND_MESSAGE.SET_TOKEN('PERIOD', p_Periodicities_Rec_Type.Name);
740: FND_MESSAGE.SET_TOKEN('CALENDAR',
741: BSC_PERIODS_UTILITY_PKG.Get_Calendar_Name(

Line 746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

742: p_Periodicities_Rec_Type.Calendar_Id
743: )
744: );
745: FND_MSG_PUB.ADD;
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749: -- Validation#2
750: SELECT COUNT(1) INTO l_Count

Line 758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

754: IF (l_Count <> 0) THEN
755: FND_MESSAGE.SET_NAME('BSC','BSC_PERIODICITY_ID_UNIQUE');
756: FND_MESSAGE.SET_TOKEN('PERIODICITY_ID', p_Periodicities_Rec_Type.Periodicity_id);
757: FND_MSG_PUB.ADD;
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760:
761: -- Validation#2:
762: l_Max_Periodicities := BSC_PERIODS_UTILITY_PKG.Get_Cust_Per_Cnt_By_Calendar(

Line 773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

769: p_Periodicities_Rec_Type.Calendar_Id
770: )
771: );
772: FND_MSG_PUB.ADD;
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775: END IF;
776:
777: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN

Line 794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

790: p_Periodicities_Rec_Type.Calendar_Id
791: )
792: );
793: FND_MSG_PUB.ADD;
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: -- Do not allow update of Base Periodicities .
798: -- Change Periodicity_Type to Custom_Code.

Line 808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

804:
805: IF (l_Count <> 0) THEN
806: FND_MESSAGE.SET_NAME('BSC','BSC_NO_UPT_BASE_PERIODICITIES');
807: FND_MSG_PUB.ADD;
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: END IF;
810:
811: -- Check for circular dependency
812: l_Is_Circular := BSC_BIS_KPI_MEAS_PUB.is_Period_Circular (

Line 820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

816:
817: IF (l_Is_Circular = BSC_BIS_KPI_MEAS_PUB.CIR_REF_EXISTS) THEN
818: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_NO_CIRCULAR_REF');
819: FND_MSG_PUB.ADD;
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822: END IF;
823: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_DELETE) THEN
824:

Line 835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

831:
832: IF (l_Count <> 0) THEN
833: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DEL_BASE_PERIODICITIES');
834: FND_MSG_PUB.ADD;
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:
838: -- You cannot delete a custom periodicity, which is the base
839: -- periodicity of another Custom Periodicity

Line 841: IF(p_disable_period_val_flag=FND_API.G_FALSE)THEN

837:
838: -- You cannot delete a custom periodicity, which is the base
839: -- periodicity of another Custom Periodicity
840:
841: IF(p_disable_period_val_flag=FND_API.G_FALSE)THEN
842:
843: SELECT COUNT(1) INTO l_Count
844: FROM BSC_SYS_PERIODICITIES B
845: WHERE TRIM(B.SOURCE) = TO_CHAR(p_Periodicities_Rec_Type.Periodicity_id);

Line 850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

846:
847: IF (l_Count <> 0) THEN
848: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DEL_IS_BASE_PER');
849: FND_MSG_PUB.ADD;
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;
853:
854: -- You cannot delete a periodicity, if it being used in some

Line 875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

871: FND_MESSAGE.SET_NAME('BSC','BSC_PERIOD_USED_IN_OBJECTIVE');
872: FND_MESSAGE.SET_TOKEN('PERIODICITY', BSC_PERIODS_UTILITY_PKG.Get_Periodicity_Name(p_Periodicities_Rec_Type.Periodicity_id));
873: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Objective_Names);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
876: END IF;
877:
878: END IF;
879:

Line 881: WHEN FND_API.G_EXC_ERROR THEN

877:
878: END IF;
879:
880: EXCEPTION
881: WHEN FND_API.G_EXC_ERROR THEN
882: ROLLBACK TO ValidatePeriodicityPUB;
883: IF (x_msg_data IS NULL) THEN
884: FND_MSG_PUB.Count_And_Get
885: ( p_encoded => FND_API.G_FALSE

Line 885: ( p_encoded => FND_API.G_FALSE

881: WHEN FND_API.G_EXC_ERROR THEN
882: ROLLBACK TO ValidatePeriodicityPUB;
883: IF (x_msg_data IS NULL) THEN
884: FND_MSG_PUB.Count_And_Get
885: ( p_encoded => FND_API.G_FALSE
886: , p_count => x_msg_count
887: , p_data => x_msg_data
888: );
889: END IF;

Line 890: x_Return_Status := FND_API.G_RET_STS_ERROR;

886: , p_count => x_msg_count
887: , p_data => x_msg_data
888: );
889: END IF;
890: x_Return_Status := FND_API.G_RET_STS_ERROR;
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: ROLLBACK TO ValidatePeriodicityPUB;
893: IF (x_msg_data IS NULL) THEN
894: FND_MSG_PUB.Count_And_Get

Line 891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

887: , p_data => x_msg_data
888: );
889: END IF;
890: x_Return_Status := FND_API.G_RET_STS_ERROR;
891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: ROLLBACK TO ValidatePeriodicityPUB;
893: IF (x_msg_data IS NULL) THEN
894: FND_MSG_PUB.Count_And_Get
895: ( p_encoded => FND_API.G_FALSE

Line 895: ( p_encoded => FND_API.G_FALSE

891: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
892: ROLLBACK TO ValidatePeriodicityPUB;
893: IF (x_msg_data IS NULL) THEN
894: FND_MSG_PUB.Count_And_Get
895: ( p_encoded => FND_API.G_FALSE
896: , p_count => x_msg_count
897: , p_data => x_msg_data
898: );
899: END IF;

Line 900: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

896: , p_count => x_msg_count
897: , p_data => x_msg_data
898: );
899: END IF;
900: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
901: WHEN NO_DATA_FOUND THEN
902: ROLLBACK TO ValidatePeriodicityPUB;
903: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
904: IF (x_msg_data IS NOT NULL) THEN

Line 903: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

899: END IF;
900: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
901: WHEN NO_DATA_FOUND THEN
902: ROLLBACK TO ValidatePeriodicityPUB;
903: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
904: IF (x_msg_data IS NOT NULL) THEN
905: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Validate_Periodicity ';
906: ELSE
907: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';

Line 911: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

907: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';
908: END IF;
909: WHEN OTHERS THEN
910: ROLLBACK TO ValidatePeriodicityPUB;
911: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF (x_msg_data IS NOT NULL) THEN
913: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Validate_Periodicity ';
914: ELSE
915: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Validate_Periodicity ';

Line 934: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

930: l_Calendar_Id BSC_SYS_CALENDARS_B.CALENDAR_ID%TYPE;
931: l_Base_Periodicity_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;
932: BEGIN
933: FND_MSG_PUB.Initialize;
934: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
935: x_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
936:
937: l_Calendar_Id := p_Periodicities_Rec_Type.Calendar_Id;
938: l_Base_Periodicity_Source := NULL;

Line 1050: ( p_encoded => FND_API.G_FALSE

1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: IF (x_msg_data IS NULL) THEN
1049: FND_MSG_PUB.Count_And_Get
1050: ( p_encoded => FND_API.G_FALSE
1051: , p_count => x_msg_count
1052: , p_data => x_msg_data
1053: );
1054: END IF;

Line 1055: x_Return_Status := FND_API.G_RET_STS_ERROR;

1051: , p_count => x_msg_count
1052: , p_data => x_msg_data
1053: );
1054: END IF;
1055: x_Return_Status := FND_API.G_RET_STS_ERROR;
1056: END Populate_Periodicity_Record;
1057:
1058: -- populates the BSC_SYS_PERIODS Metadata.
1059:

Line 1075: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1071: l_Struct_Flag BOOLEAN;
1072: BEGIN
1073: SAVEPOINT PopulatePeriodsPUB;
1074: FND_MSG_PUB.Initialize;
1075: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1076:
1077: l_Period_Record.Periodicity_Id := p_Periodicities_Rec_Type.Periodicity_Id;
1078: l_Period_Record.Base_Periodicity_Id := p_Periodicities_Rec_Type.Base_Periodicity_Id;
1079: l_Period_Record.Calendar_Id := p_Periodicities_Rec_Type.Calendar_Id;

Line 1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1110: , x_Return_Status => x_Return_Status
1111: , x_Msg_Count => x_Msg_Count
1112: , x_Msg_Data => x_Msg_Data
1113: );
1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
1118: BSC_PERIODS_PUB.Update_Periods

Line 1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1111: , x_Msg_Count => x_Msg_Count
1112: , x_Msg_Data => x_Msg_Data
1113: );
1114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
1118: BSC_PERIODS_PUB.Update_Periods
1119: (

Line 1129: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1125: , x_Return_Status => x_Return_Status
1126: , x_Msg_Count => x_Msg_Count
1127: , x_Msg_Data => x_Msg_Data
1128: );
1129: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132: END IF;
1133:

Line 1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1126: , x_Msg_Count => x_Msg_Count
1127: , x_Msg_Data => x_Msg_Data
1128: );
1129: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132: END IF;
1133:
1134: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN

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

1130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1131: END IF;
1132: END IF;
1133:
1134: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
1135: COMMIT;
1136: END IF;
1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN

Line 1138: WHEN FND_API.G_EXC_ERROR THEN

1134: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
1135: COMMIT;
1136: END IF;
1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: ROLLBACK TO PopulatePeriodsPUB;
1140: IF (x_msg_data IS NULL) THEN
1141: FND_MSG_PUB.Count_And_Get
1142: ( p_encoded => FND_API.G_FALSE

Line 1142: ( p_encoded => FND_API.G_FALSE

1138: WHEN FND_API.G_EXC_ERROR THEN
1139: ROLLBACK TO PopulatePeriodsPUB;
1140: IF (x_msg_data IS NULL) THEN
1141: FND_MSG_PUB.Count_And_Get
1142: ( p_encoded => FND_API.G_FALSE
1143: , p_count => x_msg_count
1144: , p_data => x_msg_data
1145: );
1146: END IF;

Line 1147: x_Return_Status := FND_API.G_RET_STS_ERROR;

1143: , p_count => x_msg_count
1144: , p_data => x_msg_data
1145: );
1146: END IF;
1147: x_Return_Status := FND_API.G_RET_STS_ERROR;
1148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1149: ROLLBACK TO PopulatePeriodsPUB;
1150: IF (x_msg_data IS NULL) THEN
1151: FND_MSG_PUB.Count_And_Get

Line 1148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1144: , p_data => x_msg_data
1145: );
1146: END IF;
1147: x_Return_Status := FND_API.G_RET_STS_ERROR;
1148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1149: ROLLBACK TO PopulatePeriodsPUB;
1150: IF (x_msg_data IS NULL) THEN
1151: FND_MSG_PUB.Count_And_Get
1152: ( p_encoded => FND_API.G_FALSE

Line 1152: ( p_encoded => FND_API.G_FALSE

1148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1149: ROLLBACK TO PopulatePeriodsPUB;
1150: IF (x_msg_data IS NULL) THEN
1151: FND_MSG_PUB.Count_And_Get
1152: ( p_encoded => FND_API.G_FALSE
1153: , p_count => x_msg_count
1154: , p_data => x_msg_data
1155: );
1156: END IF;

Line 1157: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1153: , p_count => x_msg_count
1154: , p_data => x_msg_data
1155: );
1156: END IF;
1157: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1158: WHEN NO_DATA_FOUND THEN
1159: ROLLBACK TO PopulatePeriodsPUB;
1160: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: IF (x_msg_data IS NOT NULL) THEN

Line 1160: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1156: END IF;
1157: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1158: WHEN NO_DATA_FOUND THEN
1159: ROLLBACK TO PopulatePeriodsPUB;
1160: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1161: IF (x_msg_data IS NOT NULL) THEN
1162: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1163: ELSE
1164: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';

Line 1168: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1164: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1165: END IF;
1166: WHEN OTHERS THEN
1167: ROLLBACK TO PopulatePeriodsPUB;
1168: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: IF (x_msg_data IS NOT NULL) THEN
1170: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';
1171: ELSE
1172: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Populate_Period_Metadata ';

Line 1187: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1183: ,x_Msg_Data OUT NOCOPY VARCHAR2
1184: ) IS
1185: BEGIN
1186: FND_MSG_PUB.Initialize;
1187: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1188:
1189: BSC_PERIODICITIES_PVT.Retrieve_Periodicity (
1190: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
1191: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type

Line 1197: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1193: ,x_Return_Status => x_Return_Status
1194: ,x_Msg_Count => x_Msg_Count
1195: ,x_Msg_Data => x_Msg_Data
1196: );
1197: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200:
1201: EXCEPTION

Line 1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1194: ,x_Msg_Count => x_Msg_Count
1195: ,x_Msg_Data => x_Msg_Data
1196: );
1197: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200:
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_ERROR THEN

Line 1202: WHEN FND_API.G_EXC_ERROR THEN

1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200:
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: IF (x_msg_data IS NULL) THEN
1204: FND_MSG_PUB.Count_And_Get
1205: ( p_encoded => FND_API.G_FALSE
1206: , p_count => x_msg_count

Line 1205: ( p_encoded => FND_API.G_FALSE

1201: EXCEPTION
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: IF (x_msg_data IS NULL) THEN
1204: FND_MSG_PUB.Count_And_Get
1205: ( p_encoded => FND_API.G_FALSE
1206: , p_count => x_msg_count
1207: , p_data => x_msg_data
1208: );
1209: END IF;

Line 1210: x_Return_Status := FND_API.G_RET_STS_ERROR;

1206: , p_count => x_msg_count
1207: , p_data => x_msg_data
1208: );
1209: END IF;
1210: x_Return_Status := FND_API.G_RET_STS_ERROR;
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: IF (x_msg_data IS NULL) THEN
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_encoded => FND_API.G_FALSE

Line 1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1207: , p_data => x_msg_data
1208: );
1209: END IF;
1210: x_Return_Status := FND_API.G_RET_STS_ERROR;
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: IF (x_msg_data IS NULL) THEN
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_encoded => FND_API.G_FALSE
1215: , p_count => x_msg_count

Line 1214: ( p_encoded => FND_API.G_FALSE

1210: x_Return_Status := FND_API.G_RET_STS_ERROR;
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: IF (x_msg_data IS NULL) THEN
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_encoded => FND_API.G_FALSE
1215: , p_count => x_msg_count
1216: , p_data => x_msg_data
1217: );
1218: END IF;

Line 1219: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1215: , p_count => x_msg_count
1216: , p_data => x_msg_data
1217: );
1218: END IF;
1219: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: WHEN NO_DATA_FOUND THEN
1221: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: IF (x_msg_data IS NOT NULL) THEN
1223: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';

Line 1221: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1217: );
1218: END IF;
1219: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: WHEN NO_DATA_FOUND THEN
1221: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: IF (x_msg_data IS NOT NULL) THEN
1223: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1224: ELSE
1225: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';

Line 1228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1224: ELSE
1225: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1226: END IF;
1227: WHEN OTHERS THEN
1228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: IF (x_msg_data IS NOT NULL) THEN
1230: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';
1231: ELSE
1232: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_PUB.Retrieve_Periodicity ';

Line 1246: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1242: , x_Msg_Data OUT NOCOPY VARCHAR2
1243: )IS
1244: BEGIN
1245: FND_MSG_PUB.Initialize;
1246: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1247: BSC_UPDATE_UTIL.Update_AnualPeriodicity_Src
1248: ( x_calendar_id => p_Calendar_Id
1249: , x_periodicity_id => p_Periodicity_Id
1250: , x_action => p_Action

Line 1256: RAISE FND_API.G_EXC_ERROR;

1252:
1253: IF(BSC_PERIODS_UTILITY_PKG.Check_Error_Message('BSC_UPDATE_UTIL.UpdAnualPeriodicitySrc')) THEN
1254: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_UPDATE_ANUAL_SOURCE');
1255: FND_MSG_PUB.ADD;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258:
1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN

Line 1260: WHEN FND_API.G_EXC_ERROR THEN

1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;
1258:
1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: IF (x_msg_data IS NULL) THEN
1262: FND_MSG_PUB.Count_And_Get
1263: ( p_encoded => FND_API.G_FALSE
1264: , p_count => x_msg_count

Line 1263: ( p_encoded => FND_API.G_FALSE

1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: IF (x_msg_data IS NULL) THEN
1262: FND_MSG_PUB.Count_And_Get
1263: ( p_encoded => FND_API.G_FALSE
1264: , p_count => x_msg_count
1265: , p_data => x_msg_data
1266: );
1267: END IF;

Line 1268: x_return_status := FND_API.G_RET_STS_ERROR;

1264: , p_count => x_msg_count
1265: , p_data => x_msg_data
1266: );
1267: END IF;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270: IF (x_msg_data IS NULL) THEN
1271: FND_MSG_PUB.Count_And_Get
1272: ( p_encoded => FND_API.G_FALSE

Line 1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1265: , p_data => x_msg_data
1266: );
1267: END IF;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270: IF (x_msg_data IS NULL) THEN
1271: FND_MSG_PUB.Count_And_Get
1272: ( p_encoded => FND_API.G_FALSE
1273: , p_count => x_msg_count

Line 1272: ( p_encoded => FND_API.G_FALSE

1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270: IF (x_msg_data IS NULL) THEN
1271: FND_MSG_PUB.Count_And_Get
1272: ( p_encoded => FND_API.G_FALSE
1273: , p_count => x_msg_count
1274: , p_data => x_msg_data
1275: );
1276: END IF;

Line 1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1273: , p_count => x_msg_count
1274: , p_data => x_msg_data
1275: );
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: WHEN NO_DATA_FOUND THEN
1279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1280: IF (x_msg_data IS NOT NULL) THEN
1281: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar_Indexes ';

Line 1279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1275: );
1276: END IF;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: WHEN NO_DATA_FOUND THEN
1279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1280: IF (x_msg_data IS NOT NULL) THEN
1281: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar_Indexes ';
1282: ELSE
1283: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar_Indexes ';

Line 1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1282: ELSE
1283: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar_Indexes ';
1284: END IF;
1285: WHEN OTHERS THEN
1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1287: IF (x_msg_data IS NOT NULL) THEN
1288: x_msg_data := x_msg_data||' -> BSC_CALENDAR_PUB.Delete_Calendar_Indexes ';
1289: ELSE
1290: x_msg_data := SQLERRM||' at BSC_CALENDAR_PUB.Delete_Calendar_Indexes ';

Line 1325: l_Structural_Flag := FND_API.G_FALSE;

1321:
1322: BEGIN
1323:
1324: l1_Periodicities_Rec_Type.Periodicity_Id := p_Periodicity_Id;
1325: l_Structural_Flag := FND_API.G_FALSE;
1326:
1327: BSC_PERIODICITIES_PUB.Retrieve_Periodicity (
1328: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0
1329: ,p_Periodicities_Rec_Type => l1_Periodicities_Rec_Type

Line 1338: l_Structural_Flag := FND_API.G_TRUE;

1334: );
1335:
1336: IF (p_Num_Of_Periods IS NOT NULL) THEN
1337: IF(l2_Periodicities_Rec_Type.Num_Of_Periods <> p_Num_Of_Periods) THEN
1338: l_Structural_Flag := FND_API.G_TRUE;
1339: END IF;
1340: END IF;
1341:
1342: IF (p_Base_Periodicity_Id IS NOT NULL) THEN

Line 1344: l_Structural_Flag := FND_API.G_TRUE;

1340: END IF;
1341:
1342: IF (p_Base_Periodicity_Id IS NOT NULL) THEN
1343: IF (TO_CHAR(p_Base_Periodicity_Id) <> l2_Periodicities_Rec_Type.Source) THEN
1344: l_Structural_Flag := FND_API.G_TRUE;
1345: END IF;
1346: END IF;
1347:
1348: l_Period_Record.Periodicity_Id := p_Periodicity_Id;

Line 1351: IF(BSC_PERIODS_PUB.Is_Period_Modified(l_Period_Record) = FND_API.G_TRUE) THEN

1347:
1348: l_Period_Record.Periodicity_Id := p_Periodicity_Id;
1349: l_Period_Record.Periods := p_Period_Ids;
1350:
1351: IF(BSC_PERIODS_PUB.Is_Period_Modified(l_Period_Record) = FND_API.G_TRUE) THEN
1352: l_Structural_Flag := FND_API.G_TRUE;
1353: END IF;
1354:
1355: IF(l_Structural_Flag = FND_API.G_TRUE) THEN

Line 1352: l_Structural_Flag := FND_API.G_TRUE;

1348: l_Period_Record.Periodicity_Id := p_Periodicity_Id;
1349: l_Period_Record.Periods := p_Period_Ids;
1350:
1351: IF(BSC_PERIODS_PUB.Is_Period_Modified(l_Period_Record) = FND_API.G_TRUE) THEN
1352: l_Structural_Flag := FND_API.G_TRUE;
1353: END IF;
1354:
1355: IF(l_Structural_Flag = FND_API.G_TRUE) THEN
1356: x_Message_Name := 'BSC_PMD_KPI_STRUCT_INVALID';

Line 1355: IF(l_Structural_Flag = FND_API.G_TRUE) THEN

1351: IF(BSC_PERIODS_PUB.Is_Period_Modified(l_Period_Record) = FND_API.G_TRUE) THEN
1352: l_Structural_Flag := FND_API.G_TRUE;
1353: END IF;
1354:
1355: IF(l_Structural_Flag = FND_API.G_TRUE) THEN
1356: x_Message_Name := 'BSC_PMD_KPI_STRUCT_INVALID';
1357:
1358: IF(p_Return_Values = FND_API.G_TRUE) THEN
1359: FOR Colst IN C_Obj_List LOOP

Line 1358: IF(p_Return_Values = FND_API.G_TRUE) THEN

1354:
1355: IF(l_Structural_Flag = FND_API.G_TRUE) THEN
1356: x_Message_Name := 'BSC_PMD_KPI_STRUCT_INVALID';
1357:
1358: IF(p_Return_Values = FND_API.G_TRUE) THEN
1359: FOR Colst IN C_Obj_List LOOP
1360: IF(x_Objective_List Is NULL) THEN
1361: x_Objective_List := Colst.NAME||'['||Colst.INDICATOR||']';
1362: ELSE

Line 1390: ,p_disable_period_val_flag => FND_API.G_FALSE

1386: BSC_PERIODICITIES_PUB.Create_Periodicity (
1387: p_Api_Version => p_Api_Version
1388: ,p_Commit => p_Commit
1389: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
1390: ,p_disable_period_val_flag => FND_API.G_FALSE
1391: ,x_Return_Status => x_Return_Status
1392: ,x_Msg_Count => x_Msg_Count
1393: ,x_Msg_Data => x_Msg_Data
1394: );

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

1397:
1398:
1399: PROCEDURE Update_Periodicity (
1400: p_Api_Version IN NUMBER
1401: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
1402: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1403: ,x_Return_Status OUT NOCOPY VARCHAR2
1404: ,x_Msg_Count OUT NOCOPY NUMBER
1405: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 1412: ,p_disable_period_val_flag => FND_API.G_FALSE

1408: BSC_PERIODICITIES_PUB.Update_Periodicity (
1409: p_Api_Version => p_Api_Version
1410: ,p_Commit => p_Commit
1411: ,p_Periodicities_Rec_Type => p_Periodicities_Rec_Type
1412: ,p_disable_period_val_flag => FND_API.G_FALSE
1413: ,x_Return_Status => x_Return_Status
1414: ,x_Msg_Count => x_Msg_Count
1415: ,x_Msg_Data => x_Msg_Data
1416: );

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

1418: END Update_Periodicity;
1419:
1420: PROCEDURE Translate_Periodicity (
1421: p_Api_Version IN NUMBER
1422: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
1423: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1424: ,p_disable_period_val_flag IN VARCHAR2
1425: ,x_Return_Status OUT NOCOPY VARCHAR2
1426: ,x_Msg_Count OUT NOCOPY NUMBER

Line 1430: x_return_status := FND_API.G_RET_STS_SUCCESS;

1426: ,x_Msg_Count OUT NOCOPY NUMBER
1427: ,x_Msg_Data OUT NOCOPY VARCHAR2
1428: ) IS
1429: BEGIN
1430: x_return_status := FND_API.G_RET_STS_SUCCESS;
1431:
1432: UPDATE bsc_sys_periodicities_tl
1433: SET name = NVL(p_Periodicities_Rec_Type.name,name)
1434: , source_lang = USERENV('LANG')

Line 1440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1436: AND periodicity_id = p_Periodicities_Rec_Type.Periodicity_Id;
1437:
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1441:
1442: END Translate_Periodicity;
1443:
1444:

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

1443:
1444:
1445: PROCEDURE Load_Periodicity (
1446: p_Api_Version IN NUMBER
1447: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
1448: ,p_Periodicities_Rec_Type IN BSC_PERIODICITIES_PUB.Periodicities_Rec_Type
1449: ,p_disable_period_val_flag IN VARCHAR2
1450: ,x_Return_Status OUT NOCOPY VARCHAR2
1451: ,x_Msg_Count OUT NOCOPY NUMBER

Line 1457: x_return_status := FND_API.G_RET_STS_SUCCESS;

1453: ) IS
1454: l_count NUMBER;
1455: l_name bsc_sys_periodicities_tl.name%TYPE;
1456: BEGIN
1457: x_return_status := FND_API.G_RET_STS_SUCCESS;
1458:
1459: UPDATE bsc_sys_periodicities
1460: SET num_of_periods = p_Periodicities_Rec_Type.Num_Of_Periods,
1461: source = p_Periodicities_Rec_Type.Source,

Line 1553: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1549:
1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: -- If error is set from previous API don't change it.
1553: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1555: END IF;
1556: END Load_Periodicity;
1557:

Line 1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1550: EXCEPTION
1551: WHEN OTHERS THEN
1552: -- If error is set from previous API don't change it.
1553: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1555: END IF;
1556: END Load_Periodicity;
1557:
1558: END BSC_PERIODICITIES_PUB;