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

Line 20: := FND_API.G_FALSE,

16:
17:
18: PROCEDURE Get_inventory_items( p_api_version_number IN NUMBER,
19: p_init_msg_list IN VARCHAR2
20: := FND_API.G_FALSE,
21: p_identity_salesforce_id IN NUMBER,
22: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
23: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
24: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

46: l_return_status Varchar2(1);
47:
48: BEGIN
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
54: THEN

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 60: IF FND_API.to_Boolean( p_init_msg_list ) THEN

56: END IF;
57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Debug Message

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: --dbms_output.put_line('AS_FOUNDATION_PUB.Get_inventory_items: Start');
68: --END IF;
69:
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73:
74: -- API BODY
75:

Line 77: p_init_msg_list => FND_API.G_FALSE,

73:
74: -- API BODY
75:
76: AS_FOUNDATION_PVT.Get_inventory_items( p_api_version_number => 2.0,
77: p_init_msg_list => FND_API.G_FALSE,
78: p_identity_salesforce_id => p_identity_salesforce_id,
79: p_inventory_item_rec => p_inventory_item_rec,
80: x_return_status => l_return_status,
81: x_msg_count => x_msg_count,

Line 86: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then

82: x_msg_data => x_msg_data,
83: x_inventory_item_tbl => x_inventory_item_tbl);
84:
85:
86: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
87: RAISE FND_API.G_EXC_ERROR;
88: End if;
89:
90: -- API Ending

Line 87: RAISE FND_API.G_EXC_ERROR;

83: x_inventory_item_tbl => x_inventory_item_tbl);
84:
85:
86: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) Then
87: RAISE FND_API.G_EXC_ERROR;
88: End if;
89:
90: -- API Ending
91:

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: End if;
89:
90: -- API Ending
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- Success Message
95: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS)
96: THEN

Line 118: WHEN FND_API.G_EXC_ERROR THEN

114:
115:
116: EXCEPTION
117:
118: WHEN FND_API.G_EXC_ERROR THEN
119:
120: x_return_status := FND_API.G_RET_STS_ERROR ;
121:
122: FND_MSG_PUB.Count_And_Get

Line 120: x_return_status := FND_API.G_RET_STS_ERROR ;

116: EXCEPTION
117:
118: WHEN FND_API.G_EXC_ERROR THEN
119:
120: x_return_status := FND_API.G_RET_STS_ERROR ;
121:
122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data

Line 128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

124: p_data => x_msg_data
125: );
126:
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129:
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131:
132: FND_MSG_PUB.Count_And_Get

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

126:
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129:
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
131:
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

137:
138: WHEN OTHERS THEN
139:
140:
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142:
143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 158: -- Get_FND_API_Constant

154: End Get_inventory_items;
155:
156: --
157: -- NAME
158: -- Get_FND_API_Constant
159: --
160: -- PURPOSE
161: -- This function will return constant according to the passed in constant name.
162: -- This is a problem referencing constants from forms. We have to create server-

Line 172: if upper(Constant_Name) = 'FND_API.G_TRUE' then

168: return varchar2
169: IS
170: BEGIN
171:
172: if upper(Constant_Name) = 'FND_API.G_TRUE' then
173: return FND_API.G_TRUE;
174: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_FULL' then
175: return FND_API.G_VALID_LEVEL_FULL;
176: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_NONE' then

Line 173: return FND_API.G_TRUE;

169: IS
170: BEGIN
171:
172: if upper(Constant_Name) = 'FND_API.G_TRUE' then
173: return FND_API.G_TRUE;
174: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_FULL' then
175: return FND_API.G_VALID_LEVEL_FULL;
176: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_NONE' then
177: return FND_API.G_VALID_LEVEL_NONE;

Line 174: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_FULL' then

170: BEGIN
171:
172: if upper(Constant_Name) = 'FND_API.G_TRUE' then
173: return FND_API.G_TRUE;
174: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_FULL' then
175: return FND_API.G_VALID_LEVEL_FULL;
176: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_NONE' then
177: return FND_API.G_VALID_LEVEL_NONE;
178: -- elsif upper(Constant_Name) = 'CS_INTERACTION_GRP.G_VALID_LEVEL_INT' then

Line 175: return FND_API.G_VALID_LEVEL_FULL;

171:
172: if upper(Constant_Name) = 'FND_API.G_TRUE' then
173: return FND_API.G_TRUE;
174: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_FULL' then
175: return FND_API.G_VALID_LEVEL_FULL;
176: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_NONE' then
177: return FND_API.G_VALID_LEVEL_NONE;
178: -- elsif upper(Constant_Name) = 'CS_INTERACTION_GRP.G_VALID_LEVEL_INT' then
179: -- return CS_INTERACTION_GRP.G_VALID_LEVEL_INT; -- Commented OUT NOCOPY /* file.sql.39 change */ by Twzhou on March 07, 2000

Line 176: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_NONE' then

172: if upper(Constant_Name) = 'FND_API.G_TRUE' then
173: return FND_API.G_TRUE;
174: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_FULL' then
175: return FND_API.G_VALID_LEVEL_FULL;
176: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_NONE' then
177: return FND_API.G_VALID_LEVEL_NONE;
178: -- elsif upper(Constant_Name) = 'CS_INTERACTION_GRP.G_VALID_LEVEL_INT' then
179: -- return CS_INTERACTION_GRP.G_VALID_LEVEL_INT; -- Commented OUT NOCOPY /* file.sql.39 change */ by Twzhou on March 07, 2000
180: else

Line 177: return FND_API.G_VALID_LEVEL_NONE;

173: return FND_API.G_TRUE;
174: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_FULL' then
175: return FND_API.G_VALID_LEVEL_FULL;
176: elsif upper(Constant_Name) = 'FND_API.G_VALID_LEVEL_NONE' then
177: return FND_API.G_VALID_LEVEL_NONE;
178: -- elsif upper(Constant_Name) = 'CS_INTERACTION_GRP.G_VALID_LEVEL_INT' then
179: -- return CS_INTERACTION_GRP.G_VALID_LEVEL_INT; -- Commented OUT NOCOPY /* file.sql.39 change */ by Twzhou on March 07, 2000
180: else
181: return null;

Line 190: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

186: NULL;
187: END;
188:
189: PROCEDURE Calculate_Amount( p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_identity_salesforce_id IN NUMBER,
193: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
194: DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,

Line 191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

187: END;
188:
189: PROCEDURE Calculate_Amount( p_api_version_number IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_identity_salesforce_id IN NUMBER,
193: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
194: DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
195: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 195: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192: p_identity_salesforce_id IN NUMBER,
193: p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
194: DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
195: p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
196: p_currency_code IN VARCHAR2,
197: p_volume IN NUMBER,
198: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
199: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 213: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

209: l_price NUMBER;
210: l_amount NUMBER;
211: BEGIN
212: -- Standard call to check for call compatibility.
213: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
214: p_api_version_number,
215: l_api_name,
216: G_PKG_NAME) THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
214: p_api_version_number,
215: l_api_name,
216: G_PKG_NAME) THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- Initialize message list if p_init_msg_list is set to TRUE.
221: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 221: IF FND_API.to_Boolean( p_init_msg_list ) THEN

217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- Initialize message list if p_init_msg_list is set to TRUE.
221: IF FND_API.to_Boolean( p_init_msg_list ) THEN
222: FND_MSG_PUB.initialize;
223: END IF;
224:
225: -- Debug Message

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: --dbms_output.put_line('AS_Foundation_PUB.Calculate_Amount: Start');
228: --END IF;
229:
230: -- Initialize API return status to success
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: -- Fix bug 858155 initialize the l_price to NULL instead of 0
233: l_price := NULL;
234: IF (p_inventory_item_rec.inventory_item_id IS NOT NULL) AND
235: (p_inventory_item_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN

Line 235: (p_inventory_item_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN

231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: -- Fix bug 858155 initialize the l_price to NULL instead of 0
233: l_price := NULL;
234: IF (p_inventory_item_rec.inventory_item_id IS NOT NULL) AND
235: (p_inventory_item_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
236: AS_FOUNDATION_PUB.Get_Inventory_items(
237: p_api_version_number => 2.0,
238: p_init_msg_list => FND_API.G_TRUE,
239: p_identity_salesforce_id => NULL,

Line 238: p_init_msg_list => FND_API.G_TRUE,

234: IF (p_inventory_item_rec.inventory_item_id IS NOT NULL) AND
235: (p_inventory_item_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
236: AS_FOUNDATION_PUB.Get_Inventory_items(
237: p_api_version_number => 2.0,
238: p_init_msg_list => FND_API.G_TRUE,
239: p_identity_salesforce_id => NULL,
240: p_inventory_item_rec => p_inventory_item_rec,
241: x_return_status => x_return_status,
242: x_msg_count => x_msg_count,

Line 245: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

241: x_return_status => x_return_status,
242: x_msg_count => x_msg_count,
243: x_msg_data => x_msg_data,
244: x_inventory_item_tbl => l_inv_item_tbl);
245: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
246: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
247: --dbms_output.put_line('AS_FOUNDATION_PUB - Item : Not Found');
248: --END IF;
249: raise FND_API.G_EXC_ERROR;

Line 249: raise FND_API.G_EXC_ERROR;

245: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
246: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
247: --dbms_output.put_line('AS_FOUNDATION_PUB - Item : Not Found');
248: --END IF;
249: raise FND_API.G_EXC_ERROR;
250: END IF;
251: IF (p_inventory_item_rec.Primary_UOM_Code IS NOT NULL) THEN
252: l_inv_item_tbl(1).Primary_UOM_Code := p_inventory_item_rec.Primary_UOM_Code;
253: END IF;

Line 259: p_init_msg_list => FND_API.G_FALSE,

255: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
256: --dbms_output.put_line('AS_Foundation_PVT - UOM:' || p_inventory_item_rec.Primary_Uom_Code);
257: --END IF;
258: AS_FOUNDATION_PVT.Get_Price_Info(p_api_version_number => 2.0,
259: p_init_msg_list => FND_API.G_FALSE,
260: p_inventory_item_rec => l_inv_item_tbl(1),
261: p_secondary_interest_code_id => NULL,
262: p_currency_code => p_currency_code,
263: x_return_status => x_return_status,

Line 269: (p_secondary_interest_code_id <> FND_API.G_MISS_NUM) THEN

265: x_msg_data => x_msg_data,
266: x_price_list_id => l_price_list_id,
267: x_price => l_price);
268: Elsif (p_secondary_interest_code_id IS NOT NULL) AND
269: (p_secondary_interest_code_id <> FND_API.G_MISS_NUM) THEN
270: AS_FOUNDATION_PVT.Get_Price_Info(p_api_version_number => 2.0,
271: p_init_msg_list => FND_API.G_FALSE,
272: p_inventory_item_rec => NULL,
273: p_secondary_interest_code_id => p_secondary_interest_code_id,

Line 271: p_init_msg_list => FND_API.G_FALSE,

267: x_price => l_price);
268: Elsif (p_secondary_interest_code_id IS NOT NULL) AND
269: (p_secondary_interest_code_id <> FND_API.G_MISS_NUM) THEN
270: AS_FOUNDATION_PVT.Get_Price_Info(p_api_version_number => 2.0,
271: p_init_msg_list => FND_API.G_FALSE,
272: p_inventory_item_rec => NULL,
273: p_secondary_interest_code_id => p_secondary_interest_code_id,
274: p_currency_code => p_currency_code,
275: x_return_status => x_return_status,

Line 281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

277: x_msg_data => x_msg_data,
278: x_price_list_id => l_price_list_id,
279: x_price => l_price);
280: END IF;
281: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
282: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
283: --dbms_output.put_line('AS_FOUNDATION_PUB - Price : Not Found');
284: --END IF;
285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 290: raise FND_API.G_EXC_ERROR;

286: FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
287: FND_MESSAGE.Set_Token('COLUMN','Price', FALSE);
288: FND_MSG_PUB.ADD;
289: END IF;
290: raise FND_API.G_EXC_ERROR;
291: END IF;
292: -- Fix bug 858155
293: IF l_price IS NULL THEN
294: l_amount := NULL;

Line 321: WHEN FND_API.G_EXC_ERROR THEN

317: p_data => x_msg_data
318: );
319:
320: EXCEPTION
321: WHEN FND_API.G_EXC_ERROR THEN
322: x_return_status := FND_API.G_RET_STS_ERROR ;
323: FND_MSG_PUB.Count_And_Get
324: ( p_count => x_msg_count,
325: p_data => x_msg_data

Line 322: x_return_status := FND_API.G_RET_STS_ERROR ;

318: );
319:
320: EXCEPTION
321: WHEN FND_API.G_EXC_ERROR THEN
322: x_return_status := FND_API.G_RET_STS_ERROR ;
323: FND_MSG_PUB.Count_And_Get
324: ( p_count => x_msg_count,
325: p_data => x_msg_data
326: );

Line 327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

323: FND_MSG_PUB.Count_And_Get
324: ( p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

324: ( p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data
332: );

Line 334: x_return_status := FND_API.G_RET_STS_ERROR ;

330: ( p_count => x_msg_count,
331: p_data => x_msg_data
332: );
333: WHEN NO_DATA_FOUND THEN
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
336: --THEN
337: --dbms_output.put_line('AS_Foundation_PUB. - Cannot Find Price List Id');
338: --END IF;

Line 344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

340: ( p_count => x_msg_count,
341: p_data => x_msg_data
342: );
343: WHEN OTHERS THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
346: THEN
347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
348: END IF;

Line 358: := FND_API.G_FALSE,

354:
355: PROCEDURE Get_PeriodNames
356: ( p_api_version_number IN NUMBER,
357: p_init_msg_list IN VARCHAR2
358: := FND_API.G_FALSE,
359: p_period_rec IN UTIL_PERIOD_REC_TYPE,
360: x_period_tbl OUT NOCOPY /* file.sql.39 change */ UTIL_PERIOD_TBL_TYPE,
361: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
362: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 372: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

368: l_period_tbl AS_FOUNDATION_PVT.UTIL_PERIOD_TBL_TYPE;
369:
370: begin
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
373: p_api_version_number,
374: l_api_name,
375: G_PKG_NAME)
376: THEN

Line 383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

379: FND_MESSAGE.Set_Name('AS', 'API_UNEXP_ERROR_IN_PROCESSING');
380: FND_MESSAGE.Set_Token('ROW', 'AS_ACCESSES', TRUE);
381: FND_MSG_PUB.ADD;
382: END IF;
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385:
386: -- Initialize message list if p_init_msg_list is set to TRUE.
387: IF FND_API.to_Boolean( p_init_msg_list )

Line 387: IF FND_API.to_Boolean( p_init_msg_list )

383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385:
386: -- Initialize message list if p_init_msg_list is set to TRUE.
387: IF FND_API.to_Boolean( p_init_msg_list )
388: THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391:

Line 394: x_return_status := FND_API.G_RET_STS_SUCCESS;

390: END IF;
391:
392: -- Initialize API return status to success
393: --
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395:
396: --
397: -- API body
398: --

Line 418: p_init_msg_list => FND_API.G_FALSE,

414: l_period_rec_in.end_date := p_period_rec.end_date;
415:
416: as_foundation_pvt.Get_PeriodNames
417: ( p_api_version_number => l_api_version_number,
418: p_init_msg_list => FND_API.G_FALSE,
419: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
420: p_period_rec => l_period_rec_in,
421: x_period_tbl => l_period_tbl,
422: x_return_status => x_return_status,

Line 419: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

415:
416: as_foundation_pvt.Get_PeriodNames
417: ( p_api_version_number => l_api_version_number,
418: p_init_msg_list => FND_API.G_FALSE,
419: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
420: p_period_rec => l_period_rec_in,
421: x_period_tbl => l_period_tbl,
422: x_return_status => x_return_status,
423: x_msg_count => x_msg_count,

Line 429: WHEN FND_API.G_EXC_ERROR THEN

425:
426:
427: EXCEPTION
428:
429: WHEN FND_API.G_EXC_ERROR THEN
430:
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432:
433: FND_MSG_PUB.Count_And_Get

Line 431: x_return_status := FND_API.G_RET_STS_ERROR ;

427: EXCEPTION
428:
429: WHEN FND_API.G_EXC_ERROR THEN
430:
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432:
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data

Line 439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

435: p_data => x_msg_data
436: );
437:
438:
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440:
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442:
443: FND_MSG_PUB.Count_And_Get

Line 441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

437:
438:
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440:
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442:
443: FND_MSG_PUB.Count_And_Get
444: ( p_count => x_msg_count,
445: p_data => x_msg_data

Line 452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

448:
449: WHEN OTHERS THEN
450:
451:
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453:
454: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
455: THEN
456: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);