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

Line 47: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

43: BEGIN
44:
45: SAVEPOINT CreatePeriodicityWRP;
46: FND_MSG_PUB.Initialize;
47: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
48:
49: l_Periodicities_Rec_Type.Periodicity_Id := p_Periodicity_Id;
50: l_Periodicities_Rec_Type.Num_Of_Periods := p_Num_Of_Periods;
51: l_Periodicities_Rec_Type.Base_Periodicity_Id := p_Base_Periodicity_Id;

Line 59: --l_Periodicities_Rec_Type.ForceRunPopulateCalendar := FND_API.G_FALSE;

55: l_Periodicities_Rec_Type.Period_IDs := p_Period_Ids;
56: l_Periodicities_Rec_Type.Application_id := p_Application_Id;
57: l_Periodicities_Rec_Type.Short_Name := p_Short_Name;
58: l_Periodicities_Rec_Type.Custom_Code := p_Custom_Code;
59: --l_Periodicities_Rec_Type.ForceRunPopulateCalendar := FND_API.G_FALSE;
60:
61: BSC_BIS_LOCKS_PUB.Lock_Calendar (
62: p_Calendar_Id => p_Calendar_Id
63: , p_Time_Stamp => p_Calendar_Time_Stamp

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

64: , x_Return_Status => x_Return_Status
65: , x_Msg_Count => x_Msg_Count
66: , x_Msg_Data => x_Msg_Data
67: );
68: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72:

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: , x_Msg_Count => x_Msg_Count
66: , x_Msg_Data => x_Msg_Data
67: );
68: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72:
73: BSC_PERIODICITIES_PUB.Create_Periodicity (

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

78: ,x_Return_Status => x_Return_Status
79: ,x_Msg_Count => x_Msg_Count
80: ,x_Msg_Data => x_Msg_Data
81: );
82: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: ,x_Msg_Count => x_Msg_Count
80: ,x_Msg_Data => x_Msg_Data
81: );
82: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
87: COMMIT;

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

82: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
87: COMMIT;
88: END IF;
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN

Line 90: WHEN FND_API.G_EXC_ERROR THEN

86: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
87: COMMIT;
88: END IF;
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: ROLLBACK TO CreatePeriodicityWRP;
92: IF (x_msg_data IS NULL) THEN
93: FND_MSG_PUB.Count_And_Get
94: ( p_encoded => FND_API.G_FALSE

Line 94: ( p_encoded => FND_API.G_FALSE

90: WHEN FND_API.G_EXC_ERROR THEN
91: ROLLBACK TO CreatePeriodicityWRP;
92: IF (x_msg_data IS NULL) THEN
93: FND_MSG_PUB.Count_And_Get
94: ( p_encoded => FND_API.G_FALSE
95: , p_count => x_msg_count
96: , p_data => x_msg_data
97: );
98: END IF;

Line 99: x_Return_Status := FND_API.G_RET_STS_ERROR;

95: , p_count => x_msg_count
96: , p_data => x_msg_data
97: );
98: END IF;
99: x_Return_Status := FND_API.G_RET_STS_ERROR;
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: ROLLBACK TO CreatePeriodicityWRP;
102: IF (x_msg_data IS NULL) THEN
103: FND_MSG_PUB.Count_And_Get

Line 100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

96: , p_data => x_msg_data
97: );
98: END IF;
99: x_Return_Status := FND_API.G_RET_STS_ERROR;
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: ROLLBACK TO CreatePeriodicityWRP;
102: IF (x_msg_data IS NULL) THEN
103: FND_MSG_PUB.Count_And_Get
104: ( p_encoded => FND_API.G_FALSE

Line 104: ( p_encoded => FND_API.G_FALSE

100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: ROLLBACK TO CreatePeriodicityWRP;
102: IF (x_msg_data IS NULL) THEN
103: FND_MSG_PUB.Count_And_Get
104: ( p_encoded => FND_API.G_FALSE
105: , p_count => x_msg_count
106: , p_data => x_msg_data
107: );
108: END IF;

Line 109: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

105: , p_count => x_msg_count
106: , p_data => x_msg_data
107: );
108: END IF;
109: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
110: WHEN NO_DATA_FOUND THEN
111: ROLLBACK TO CreatePeriodicityWRP;
112: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF (x_msg_data IS NOT NULL) THEN

Line 112: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

108: END IF;
109: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
110: WHEN NO_DATA_FOUND THEN
111: ROLLBACK TO CreatePeriodicityWRP;
112: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF (x_msg_data IS NOT NULL) THEN
114: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
115: ELSE
116: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';

Line 120: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

116: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
117: END IF;
118: WHEN OTHERS THEN
119: ROLLBACK TO CreatePeriodicityWRP;
120: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
121: IF (x_msg_data IS NOT NULL) THEN
122: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';
123: ELSE
124: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Create_Periodicity ';

Line 151: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

147: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
148: BEGIN
149: SAVEPOINT UpdatePeriodicityWRP;
150: FND_MSG_PUB.Initialize;
151: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
152:
153: l_Periodicities_Rec_Type.Periodicity_Id := p_Periodicity_id;
154: l_Periodicities_Rec_Type.Num_Of_Periods := p_Num_Of_Periods;
155: l_Periodicities_Rec_Type.Base_Periodicity_Id := p_Base_Periodicity_Id;

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

173: , x_Return_Status => x_Return_Status
174: , x_Msg_Count => x_Msg_Count
175: , x_Msg_Data => x_Msg_Data
176: );
177: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180:
181: BSC_PERIODICITIES_PUB.Update_Periodicity (

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174: , x_Msg_Count => x_Msg_Count
175: , x_Msg_Data => x_Msg_Data
176: );
177: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: END IF;
180:
181: BSC_PERIODICITIES_PUB.Update_Periodicity (
182: p_Api_Version => BSC_PERIODS_UTILITY_PKG.C_API_VERSION_1_0

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

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

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 198: WHEN FND_API.G_EXC_ERROR THEN

194: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
195: COMMIT;
196: END IF;
197: EXCEPTION
198: WHEN FND_API.G_EXC_ERROR THEN
199: ROLLBACK TO UpdatePeriodicityWRP;
200: IF (x_msg_data IS NULL) THEN
201: FND_MSG_PUB.Count_And_Get
202: ( p_encoded => FND_API.G_FALSE

Line 202: ( p_encoded => FND_API.G_FALSE

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

Line 207: x_Return_Status := FND_API.G_RET_STS_ERROR;

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

Line 208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 212: ( p_encoded => FND_API.G_FALSE

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

Line 217: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 220: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

216: END IF;
217: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
218: WHEN NO_DATA_FOUND THEN
219: ROLLBACK TO UpdatePeriodicityWRP;
220: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
221: IF (x_msg_data IS NOT NULL) THEN
222: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
223: ELSE
224: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

Line 228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

224: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
225: END IF;
226: WHEN OTHERS THEN
227: ROLLBACK TO UpdatePeriodicityWRP;
228: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF (x_msg_data IS NOT NULL) THEN
230: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';
231: ELSE
232: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Update_Periodicity ';

Line 251: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

247: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
248: BEGIN
249: SAVEPOINT DeletePeriodicityWRP;
250: FND_MSG_PUB.Initialize;
251: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
252:
253: BSC_BIS_LOCKS_PUB.Lock_Periodicity (
254: p_Periodicity_Id => p_Periodicity_Id
255: , p_Time_Stamp => p_Periodicity_Time_Stamp

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

256: , x_Return_Status => x_Return_Status
257: , x_Msg_Count => x_Msg_Count
258: , x_Msg_Data => x_Msg_Data
259: );
260: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- passed the calendar_id instead.

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: , x_Msg_Count => x_Msg_Count
258: , x_Msg_Data => x_Msg_Data
259: );
260: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- passed the calendar_id instead.
265: BSC_BIS_LOCKS_PUB.Lock_Calendar (

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

268: , x_Return_Status => x_Return_Status
269: , x_Msg_Count => x_Msg_Count
270: , x_Msg_Data => x_Msg_Data
271: );
272: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: END IF;
275:
276:

Line 273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

269: , x_Msg_Count => x_Msg_Count
270: , x_Msg_Data => x_Msg_Data
271: );
272: IF(x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: END IF;
275:
276:
277: l_Periodicities_Rec_Type.Periodicity_Id := p_Periodicity_id;

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

284: ,x_Return_Status => x_Return_Status
285: ,x_Msg_Count => x_Msg_Count
286: ,x_Msg_Data => x_Msg_Data
287: );
288: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291:
292: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

285: ,x_Msg_Count => x_Msg_Count
286: ,x_Msg_Data => x_Msg_Data
287: );
288: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291:
292: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
293: COMMIT;

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

288: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
290: END IF;
291:
292: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
293: COMMIT;
294: END IF;
295: EXCEPTION
296: WHEN FND_API.G_EXC_ERROR THEN

Line 296: WHEN FND_API.G_EXC_ERROR THEN

292: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
293: COMMIT;
294: END IF;
295: EXCEPTION
296: WHEN FND_API.G_EXC_ERROR THEN
297: ROLLBACK TO DeletePeriodicityWRP;
298: IF (x_msg_data IS NULL) THEN
299: FND_MSG_PUB.Count_And_Get
300: ( p_encoded => FND_API.G_FALSE

Line 300: ( p_encoded => FND_API.G_FALSE

296: WHEN FND_API.G_EXC_ERROR THEN
297: ROLLBACK TO DeletePeriodicityWRP;
298: IF (x_msg_data IS NULL) THEN
299: FND_MSG_PUB.Count_And_Get
300: ( p_encoded => FND_API.G_FALSE
301: , p_count => x_msg_count
302: , p_data => x_msg_data
303: );
304: END IF;

Line 305: x_Return_Status := FND_API.G_RET_STS_ERROR;

301: , p_count => x_msg_count
302: , p_data => x_msg_data
303: );
304: END IF;
305: x_Return_Status := FND_API.G_RET_STS_ERROR;
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307: ROLLBACK TO DeletePeriodicityWRP;
308: IF (x_msg_data IS NULL) THEN
309: FND_MSG_PUB.Count_And_Get

Line 306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

302: , p_data => x_msg_data
303: );
304: END IF;
305: x_Return_Status := FND_API.G_RET_STS_ERROR;
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307: ROLLBACK TO DeletePeriodicityWRP;
308: IF (x_msg_data IS NULL) THEN
309: FND_MSG_PUB.Count_And_Get
310: ( p_encoded => FND_API.G_FALSE

Line 310: ( p_encoded => FND_API.G_FALSE

306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307: ROLLBACK TO DeletePeriodicityWRP;
308: IF (x_msg_data IS NULL) THEN
309: FND_MSG_PUB.Count_And_Get
310: ( p_encoded => FND_API.G_FALSE
311: , p_count => x_msg_count
312: , p_data => x_msg_data
313: );
314: END IF;

Line 315: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

311: , p_count => x_msg_count
312: , p_data => x_msg_data
313: );
314: END IF;
315: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
316: WHEN NO_DATA_FOUND THEN
317: ROLLBACK TO DeletePeriodicityWRP;
318: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
319: IF (x_msg_data IS NOT NULL) THEN

Line 318: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

314: END IF;
315: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
316: WHEN NO_DATA_FOUND THEN
317: ROLLBACK TO DeletePeriodicityWRP;
318: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
319: IF (x_msg_data IS NOT NULL) THEN
320: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
321: ELSE
322: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

Line 326: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

322: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
323: END IF;
324: WHEN OTHERS THEN
325: ROLLBACK TO DeletePeriodicityWRP;
326: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
327: IF (x_msg_data IS NOT NULL) THEN
328: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';
329: ELSE
330: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Delete_Periodicity ';

Line 348: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

344: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
345: BEGIN
346: SAVEPOINT ValidatePeriodicityWRP;
347: FND_MSG_PUB.Initialize;
348: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
349:
350: l_Periodicities_Rec_Type.Periodicity_Id := p_Periodicity_id;
351: l_Periodicities_Rec_Type.Calendar_Id := p_Calendar_Id;
352:

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

358: ,x_Return_Status => x_Return_Status
359: ,x_Msg_Count => x_Msg_Count
360: ,x_Msg_Data => x_Msg_Data
361: );
362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: ,x_Msg_Count => x_Msg_Count
360: ,x_Msg_Data => x_Msg_Data
361: );
362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
367: COMMIT;

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

362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
367: COMMIT;
368: END IF;
369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN

Line 370: WHEN FND_API.G_EXC_ERROR THEN

366: IF (p_Commit IS NOT NULL AND p_Commit = FND_API.G_TRUE) THEN
367: COMMIT;
368: END IF;
369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO ValidatePeriodicityWRP;
372: IF (x_msg_data IS NULL) THEN
373: FND_MSG_PUB.Count_And_Get
374: ( p_encoded => FND_API.G_FALSE

Line 374: ( p_encoded => FND_API.G_FALSE

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

Line 379: x_Return_Status := FND_API.G_RET_STS_ERROR;

375: , p_count => x_msg_count
376: , p_data => x_msg_data
377: );
378: END IF;
379: x_Return_Status := FND_API.G_RET_STS_ERROR;
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: ROLLBACK TO ValidatePeriodicityWRP;
382: IF (x_msg_data IS NULL) THEN
383: FND_MSG_PUB.Count_And_Get

Line 380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

376: , p_data => x_msg_data
377: );
378: END IF;
379: x_Return_Status := FND_API.G_RET_STS_ERROR;
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: ROLLBACK TO ValidatePeriodicityWRP;
382: IF (x_msg_data IS NULL) THEN
383: FND_MSG_PUB.Count_And_Get
384: ( p_encoded => FND_API.G_FALSE

Line 384: ( p_encoded => FND_API.G_FALSE

380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: ROLLBACK TO ValidatePeriodicityWRP;
382: IF (x_msg_data IS NULL) THEN
383: FND_MSG_PUB.Count_And_Get
384: ( p_encoded => FND_API.G_FALSE
385: , p_count => x_msg_count
386: , p_data => x_msg_data
387: );
388: END IF;

Line 389: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

385: , p_count => x_msg_count
386: , p_data => x_msg_data
387: );
388: END IF;
389: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
390: WHEN NO_DATA_FOUND THEN
391: ROLLBACK TO ValidatePeriodicityWRP;
392: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF (x_msg_data IS NOT NULL) THEN

Line 392: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

388: END IF;
389: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
390: WHEN NO_DATA_FOUND THEN
391: ROLLBACK TO ValidatePeriodicityWRP;
392: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF (x_msg_data IS NOT NULL) THEN
394: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
395: ELSE
396: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';

Line 400: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

396: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
397: END IF;
398: WHEN OTHERS THEN
399: ROLLBACK TO ValidatePeriodicityWRP;
400: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
401: IF (x_msg_data IS NOT NULL) THEN
402: x_msg_data := x_msg_data||' -> BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';
403: ELSE
404: x_msg_data := SQLERRM||' at BSC_PERIODICITIES_WRAPPER.Validate_Periodicity ';

Line 440: ,p_disable_period_val_flag => FND_API.G_FALSE

436: ,p_Calendar_Id => p_Calendar_Id
437: ,p_Custom_Code => p_Custom_Code
438: ,p_Period_Ids => p_Period_Ids
439: ,p_Calendar_Time_Stamp => p_Calendar_Time_Stamp
440: ,p_disable_period_val_flag => FND_API.G_FALSE
441: ,x_Return_Status => x_Return_Status
442: ,x_Msg_Count => x_Msg_Count
443: ,x_Msg_Data => x_Msg_Data
444: );

Line 480: ,p_disable_period_val_flag => FND_API.G_FALSE

476: ,p_Calendar_Id => p_Calendar_Id
477: ,p_Period_Ids => p_Period_Ids
478: ,p_Periodicity_Time_Stamp => p_Periodicity_Time_Stamp
479: ,p_Custom_Code => p_Custom_Code
480: ,p_disable_period_val_flag => FND_API.G_FALSE
481: ,x_Return_Status => x_Return_Status
482: ,x_Msg_Count => x_Msg_Count
483: ,x_Msg_Data => x_Msg_Data
484: );