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

Line 171: l_Is_Period_Modified := FND_API.G_FALSE;

167: l_Is_Period_Modified VARCHAR2(1);
168: l_In_Trimmed_String VARCHAR2(32000);
169: l_In_Dbase_String VARCHAR2(32000);
170: BEGIN
171: l_Is_Period_Modified := FND_API.G_FALSE;
172:
173: l_periods := Get_Period_List(p_Period_Record.Periodicity_Id);
174:
175: l_In_Trimmed_String := REPLACE(p_Period_Record.Periods,' ','');

Line 178: l_Is_Period_Modified := FND_API.G_TRUE;

174:
175: l_In_Trimmed_String := REPLACE(p_Period_Record.Periods,' ','');
176: l_In_Dbase_String := REPLACE(l_periods,' ','');
177: IF(l_In_Trimmed_String <> l_In_Dbase_String) THEN
178: l_Is_Period_Modified := FND_API.G_TRUE;
179: END IF;
180:
181: RETURN l_Is_Period_Modified;
182: EXCEPTION

Line 184: RETURN FND_API.G_FALSE;

180:
181: RETURN l_Is_Period_Modified;
182: EXCEPTION
183: WHEN OTHERS THEN
184: RETURN FND_API.G_FALSE;
185: END Is_Period_Modified;
186:
187: /******************************************************************************/
188:

Line 206: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

202:
203: BEGIN
204: SAVEPOINT CreatePeriodsPubSP;
205: FND_MSG_PUB.Initialize;
206: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
207: --dbms_output.put_line('before assigning ');
208: l_Period_Record := p_Period_Record;
209: l_period_Varray_Record := Parse_Periods
210: ( p_Periods => p_Period_Record.Periods

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

213: );
214: --dbms_output.put_line('before Validate_Periods_Action');
215: l_Period_Record.period_Varry := l_period_Varray_Record;
216:
217: IF(p_disable_period_val_flag = FND_API.G_FALSE)THEN
218:
219: BSC_PERIODS_PUB.Validate_Periods_Action
220: ( p_Api_Version => p_Api_Version
221: , p_Commit => p_Commit

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

226: , x_Return_Status => x_Return_Status
227: , x_Msg_Count => x_Msg_Count
228: , x_Msg_Data => x_Msg_Data
229: );
230: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: END IF;

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227: , x_Msg_Count => x_Msg_Count
228: , x_Msg_Data => x_Msg_Data
229: );
230: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: END IF;
235: --dbms_output.put_line('before Create_Periods');

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

240: , x_Return_Status => x_Return_Status
241: , x_Msg_Count => x_Msg_Count
242: , x_Msg_Data => x_Msg_Data
243: );
244: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247:
248:

Line 245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

241: , x_Msg_Count => x_Msg_Count
242: , x_Msg_Data => x_Msg_Data
243: );
244: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247:
248:
249: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN

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

245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247:
248:
249: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
250: COMMIT;
251: END IF;
252:
253: EXCEPTION

Line 254: WHEN FND_API.G_EXC_ERROR THEN

250: COMMIT;
251: END IF;
252:
253: EXCEPTION
254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO CreatePeriodsPubSP;
256: IF (x_msg_data IS NULL) THEN
257: FND_MSG_PUB.Count_And_Get
258: ( p_encoded => FND_API.G_FALSE

Line 258: ( p_encoded => FND_API.G_FALSE

254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO CreatePeriodsPubSP;
256: IF (x_msg_data IS NULL) THEN
257: FND_MSG_PUB.Count_And_Get
258: ( p_encoded => FND_API.G_FALSE
259: , p_count => x_msg_count
260: , p_data => x_msg_data
261: );
262: END IF;

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259: , p_count => x_msg_count
260: , p_data => x_msg_data
261: );
262: END IF;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: ROLLBACK TO CreatePeriodsPubSP;
266: IF (x_msg_data IS NULL) THEN
267: FND_MSG_PUB.Count_And_Get

Line 264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

260: , p_data => x_msg_data
261: );
262: END IF;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: ROLLBACK TO CreatePeriodsPubSP;
266: IF (x_msg_data IS NULL) THEN
267: FND_MSG_PUB.Count_And_Get
268: ( p_encoded => FND_API.G_FALSE

Line 268: ( p_encoded => FND_API.G_FALSE

264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: ROLLBACK TO CreatePeriodsPubSP;
266: IF (x_msg_data IS NULL) THEN
267: FND_MSG_PUB.Count_And_Get
268: ( p_encoded => FND_API.G_FALSE
269: , p_count => x_msg_count
270: , p_data => x_msg_data
271: );
272: END IF;

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

269: , p_count => x_msg_count
270: , p_data => x_msg_data
271: );
272: END IF;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: WHEN NO_DATA_FOUND THEN
275: ROLLBACK TO CreatePeriodsPubSP;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF (x_msg_data IS NOT NULL) THEN

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

272: END IF;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: WHEN NO_DATA_FOUND THEN
275: ROLLBACK TO CreatePeriodsPubSP;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: IF (x_msg_data IS NOT NULL) THEN
278: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Create_Periods ';
279: ELSE
280: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Create_Periods ';

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

280: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Create_Periods ';
281: END IF;
282: WHEN OTHERS THEN
283: ROLLBACK TO CreatePeriodsPubSP;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: IF (x_msg_data IS NOT NULL) THEN
286: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Create_Periods ';
287: ELSE
288: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Create_Periods ';

Line 312: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

308:
309: BEGIN
310: SAVEPOINT UpdatePeriodsPubSP;
311: FND_MSG_PUB.Initialize;
312: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
313:
314: l_Period_Record := p_Period_Record;
315: l_period_Varray_Record := Parse_Periods
316: ( p_Periods => p_Period_Record.Periods

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

319: );
320:
321: l_Period_Record.period_Varry := l_period_Varray_Record;
322:
323: IF(p_disable_period_val_flag = FND_API.G_FALSE)THEN
324:
325: BSC_PERIODS_PUB.Validate_Periods_Action
326: ( p_Api_Version => p_Api_Version
327: , p_Commit => p_Commit

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

332: , x_Return_Status => x_Return_Status
333: , x_Msg_Count => x_Msg_Count
334: , x_Msg_Data => x_Msg_Data
335: );
336: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339: END IF;
340:

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: , x_Msg_Count => x_Msg_Count
334: , x_Msg_Data => x_Msg_Data
335: );
336: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339: END IF;
340:
341: -- adrao modified to p_Period_Record

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

346: , x_Return_Status => x_Return_Status
347: , x_Msg_Count => x_Msg_Count
348: , x_Msg_Data => x_Msg_Data
349: );
350: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: , x_Msg_Count => x_Msg_Count
348: , x_Msg_Data => x_Msg_Data
349: );
350: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
355: COMMIT;

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

350: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
355: COMMIT;
356: END IF;
357:
358: EXCEPTION

Line 359: WHEN FND_API.G_EXC_ERROR THEN

355: COMMIT;
356: END IF;
357:
358: EXCEPTION
359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO UpdatePeriodsPubSP;
361: IF (x_msg_data IS NULL) THEN
362: FND_MSG_PUB.Count_And_Get
363: ( p_encoded => FND_API.G_FALSE

Line 363: ( p_encoded => FND_API.G_FALSE

359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO UpdatePeriodsPubSP;
361: IF (x_msg_data IS NULL) THEN
362: FND_MSG_PUB.Count_And_Get
363: ( p_encoded => FND_API.G_FALSE
364: , p_count => x_msg_count
365: , p_data => x_msg_data
366: );
367: END IF;

Line 368: x_return_status := FND_API.G_RET_STS_ERROR;

364: , p_count => x_msg_count
365: , p_data => x_msg_data
366: );
367: END IF;
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO UpdatePeriodsPubSP;
371: IF (x_msg_data IS NULL) THEN
372: FND_MSG_PUB.Count_And_Get

Line 369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

365: , p_data => x_msg_data
366: );
367: END IF;
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO UpdatePeriodsPubSP;
371: IF (x_msg_data IS NULL) THEN
372: FND_MSG_PUB.Count_And_Get
373: ( p_encoded => FND_API.G_FALSE

Line 373: ( p_encoded => FND_API.G_FALSE

369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO UpdatePeriodsPubSP;
371: IF (x_msg_data IS NULL) THEN
372: FND_MSG_PUB.Count_And_Get
373: ( p_encoded => FND_API.G_FALSE
374: , p_count => x_msg_count
375: , p_data => x_msg_data
376: );
377: END IF;

Line 378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

374: , p_count => x_msg_count
375: , p_data => x_msg_data
376: );
377: END IF;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: WHEN NO_DATA_FOUND THEN
380: ROLLBACK TO UpdatePeriodsPubSP;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF (x_msg_data IS NOT NULL) THEN

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

377: END IF;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: WHEN NO_DATA_FOUND THEN
380: ROLLBACK TO UpdatePeriodsPubSP;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: IF (x_msg_data IS NOT NULL) THEN
383: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Update_Periods ';
384: ELSE
385: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Update_Periods ';

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

385: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Update_Periods ';
386: END IF;
387: WHEN OTHERS THEN
388: ROLLBACK TO UpdatePeriodsPubSP;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: IF (x_msg_data IS NOT NULL) THEN
391: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Update_Periods ';
392: ELSE
393: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Update_Calendar ';

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

398:
399: /****************************************************************************************/
400: PROCEDURE Delete_Periods
401: ( p_Api_Version IN NUMBER
402: , p_Commit IN VARCHAR2 := FND_API.G_FALSE
403: , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
404: , x_Return_Status OUT NOCOPY VARCHAR2
405: , x_Msg_Count OUT NOCOPY NUMBER
406: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 411: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

407: )IS
408: BEGIN
409: SAVEPOINT DeletePeriodsPubSP;
410: FND_MSG_PUB.Initialize;
411: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
412:
413: BSC_PERIODS_PUB.Validate_Periods_Action
414: ( p_Api_Version => p_Api_Version
415: , p_Commit => p_Commit

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

420: , x_Return_Status => x_Return_Status
421: , x_Msg_Count => x_Msg_Count
422: , x_Msg_Data => x_Msg_Data
423: );
424: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: BSC_PERIODICITY_PVT.Delete_Periods

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: , x_Msg_Count => x_Msg_Count
422: , x_Msg_Data => x_Msg_Data
423: );
424: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: BSC_PERIODICITY_PVT.Delete_Periods
429: ( p_Api_Version => p_Api_Version

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

432: , x_Return_Status => x_Return_Status
433: , x_Msg_Count => x_Msg_Count
434: , x_Msg_Data => x_Msg_Data
435: );
436: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: END IF;
439:
440: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN

Line 437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

433: , x_Msg_Count => x_Msg_Count
434: , x_Msg_Data => x_Msg_Data
435: );
436: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: END IF;
439:
440: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
441: COMMIT;

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

436: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: END IF;
439:
440: IF ((p_Commit IS NOT NULL) AND (p_Commit = FND_API.G_TRUE)) THEN
441: COMMIT;
442: END IF;
443:
444: EXCEPTION

Line 445: WHEN FND_API.G_EXC_ERROR THEN

441: COMMIT;
442: END IF;
443:
444: EXCEPTION
445: WHEN FND_API.G_EXC_ERROR THEN
446: ROLLBACK TO DeletePeriodsPubSP;
447: IF (x_msg_data IS NULL) THEN
448: FND_MSG_PUB.Count_And_Get
449: ( p_encoded => FND_API.G_FALSE

Line 449: ( p_encoded => FND_API.G_FALSE

445: WHEN FND_API.G_EXC_ERROR THEN
446: ROLLBACK TO DeletePeriodsPubSP;
447: IF (x_msg_data IS NULL) THEN
448: FND_MSG_PUB.Count_And_Get
449: ( p_encoded => FND_API.G_FALSE
450: , p_count => x_msg_count
451: , p_data => x_msg_data
452: );
453: END IF;

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: , p_count => x_msg_count
451: , p_data => x_msg_data
452: );
453: END IF;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: ROLLBACK TO DeletePeriodsPubSP;
457: IF (x_msg_data IS NULL) THEN
458: FND_MSG_PUB.Count_And_Get

Line 455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

451: , p_data => x_msg_data
452: );
453: END IF;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: ROLLBACK TO DeletePeriodsPubSP;
457: IF (x_msg_data IS NULL) THEN
458: FND_MSG_PUB.Count_And_Get
459: ( p_encoded => FND_API.G_FALSE

Line 459: ( p_encoded => FND_API.G_FALSE

455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: ROLLBACK TO DeletePeriodsPubSP;
457: IF (x_msg_data IS NULL) THEN
458: FND_MSG_PUB.Count_And_Get
459: ( p_encoded => FND_API.G_FALSE
460: , p_count => x_msg_count
461: , p_data => x_msg_data
462: );
463: END IF;

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

460: , p_count => x_msg_count
461: , p_data => x_msg_data
462: );
463: END IF;
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465: WHEN NO_DATA_FOUND THEN
466: ROLLBACK TO DeletePeriodsPubSP;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF (x_msg_data IS NOT NULL) THEN

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

463: END IF;
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465: WHEN NO_DATA_FOUND THEN
466: ROLLBACK TO DeletePeriodsPubSP;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: IF (x_msg_data IS NOT NULL) THEN
469: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Delete_Periods ';
470: ELSE
471: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Delete_Periods ';

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Delete_Periods ';
472: END IF;
473: WHEN OTHERS THEN
474: ROLLBACK TO DeletePeriodsPubSP;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF (x_msg_data IS NOT NULL) THEN
477: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Delete_Periods ';
478: ELSE
479: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Delete_Periods ';

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

483: /***********************************************************************************/
484:
485: PROCEDURE Validate_Periods_Action
486: ( p_Api_Version IN NUMBER
487: , p_Commit IN VARCHAR2 := FND_API.G_FALSE
488: , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
489: , p_Action IN VARCHAR2
490: , x_Start_Period IN VARCHAR2
491: , x_End_Period IN VARCHAR2

Line 501: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

497: l_Is_Daily_Periodicity BOOLEAN;
498: BEGIN
499:
500: FND_MSG_PUB.Initialize;
501: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
502: IF(p_Period_Record.Base_Periodicity_Id IS NOT NULL) THEN
503: l_No_Base_Periods := BSC_PERIODS_UTILITY_PKG.Get_Periods_In_Base_Period(p_Period_Record.Base_Periodicity_Id);
504: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Period_Record.Base_Periodicity_Id);
505: END IF;

Line 513: RAISE FND_API.G_EXC_ERROR;

509: IF((NOT l_Is_Daily_Periodicity) AND (p_Period_Record.Base_Periodicity_Id IS NOT NULL)) THEN
510: IF(x_Start_Period <> 1 OR x_End_Period <> l_No_Base_Periods) THEN
511: FND_MESSAGE.SET_NAME('BSC','BSC_WRONG_PERIODS');
512: FND_MSG_PUB.ADD;
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: END IF;
516: END IF;
517:

Line 519: WHEN FND_API.G_EXC_ERROR THEN

515: END IF;
516: END IF;
517:
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: IF (x_msg_data IS NULL) THEN
521: FND_MSG_PUB.Count_And_Get
522: ( p_encoded => FND_API.G_FALSE
523: , p_count => x_msg_count

Line 522: ( p_encoded => FND_API.G_FALSE

518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: IF (x_msg_data IS NULL) THEN
521: FND_MSG_PUB.Count_And_Get
522: ( p_encoded => FND_API.G_FALSE
523: , p_count => x_msg_count
524: , p_data => x_msg_data
525: );
526: END IF;

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: , p_count => x_msg_count
524: , p_data => x_msg_data
525: );
526: END IF;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: IF (x_msg_data IS NULL) THEN
530: FND_MSG_PUB.Count_And_Get
531: ( p_encoded => FND_API.G_FALSE

Line 528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

524: , p_data => x_msg_data
525: );
526: END IF;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: IF (x_msg_data IS NULL) THEN
530: FND_MSG_PUB.Count_And_Get
531: ( p_encoded => FND_API.G_FALSE
532: , p_count => x_msg_count

Line 531: ( p_encoded => FND_API.G_FALSE

527: x_return_status := FND_API.G_RET_STS_ERROR;
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: IF (x_msg_data IS NULL) THEN
530: FND_MSG_PUB.Count_And_Get
531: ( p_encoded => FND_API.G_FALSE
532: , p_count => x_msg_count
533: , p_data => x_msg_data
534: );
535: END IF;

Line 536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

532: , p_count => x_msg_count
533: , p_data => x_msg_data
534: );
535: END IF;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: WHEN NO_DATA_FOUND THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: IF (x_msg_data IS NOT NULL) THEN
540: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Validate_Periods_Action ';

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

534: );
535: END IF;
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: WHEN NO_DATA_FOUND THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: IF (x_msg_data IS NOT NULL) THEN
540: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Validate_Periods_Action ';
541: ELSE
542: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Validate_Periods_Action ';

Line 545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

541: ELSE
542: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Validate_Periods_Action ';
543: END IF;
544: WHEN OTHERS THEN
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: IF (x_msg_data IS NOT NULL) THEN
547: x_msg_data := x_msg_data||' -> BSC_PERIODS_PUB.Validate_Periods_Action ';
548: ELSE
549: x_msg_data := SQLERRM||' at BSC_PERIODS_PUB.Validate_Periods_Action ';

Line 595: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

591:
592: BEGIN
593: --dbms_output.put_line('START :Create_Periodicity_View :- ' ||DBMS_UTILITY.GET_TIME);
594: FND_MSG_PUB.Initialize;
595: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
596: x_Periodicity_View_Name := Get_Valid_Period_View_Name(p_Short_Name);
597:
598: --dbms_output.put_line('BEFORE PREPARING SQL TEXT ');
599:

Line 649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

645: --dbms_output.put_line('END :Create_Periodicity_View :- ' ||DBMS_UTILITY.GET_TIME);
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_CREATE_PER_VIEW');
651: FND_MSG_PUB.ADD;
652: FND_MSG_PUB.Count_And_Get
653: ( p_encoded => FND_API.G_FALSE

Line 653: ( p_encoded => FND_API.G_FALSE

649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_CREATE_PER_VIEW');
651: FND_MSG_PUB.ADD;
652: FND_MSG_PUB.Count_And_Get
653: ( p_encoded => FND_API.G_FALSE
654: , p_count => x_msg_count
655: , p_data => x_msg_data
656: );
657: IF (x_msg_data IS NOT NULL) THEN

Line 673: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

669: )IS
670: l_Sql_Stmt VARCHAR2(32000);
671: BEGIN
672: FND_MSG_PUB.Initialize;
673: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
674:
675: l_Sql_Stmt := 'DROP VIEW ' || p_Periodicity_View;
676:
677: BSC_APPS.Do_Ddl_AT(l_Sql_Stmt, ad_ddl.drop_view, p_Periodicity_View, 'APPS', 'BSC');