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

Line 95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

91:
92: PROCEDURE Create_Allocation_Definition
93: (
94: p_api_version IN NUMBER ,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
97:
98: x_return_status OUT NOCOPY VARCHAR2 ,
99: x_msg_count OUT NOCOPY NUMBER ,

Line 96: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

92: PROCEDURE Create_Allocation_Definition
93: (
94: p_api_version IN NUMBER ,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
97:
98: x_return_status OUT NOCOPY VARCHAR2 ,
99: x_msg_count OUT NOCOPY NUMBER ,
100: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 117: IF FND_API.to_Boolean( p_init_msg_list ) THEN

113: -- Standard Start of API savepoint
114: SAVEPOINT Create_Alloc_Definition_PVT;
115:
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_Boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120:
121: -- Standard call to check for call compatibility.

Line 122: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

118: FND_MSG_PUB.initialize;
119: END IF;
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
123: p_api_version ,
124: l_api_name ,
125: G_PKG_NAME )
126: THEN

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: p_api_version ,
124: l_api_name ,
125: G_PKG_NAME )
126: THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize API return status to success
131: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 131: x_return_status := FND_API.G_RET_STS_SUCCESS;

127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize API return status to success
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132:
133:
134: -- Generate line_no for the alloc_id
135: SELECT NVL(MAX(line_no), 0)+1

Line 204: WHEN FND_API.G_EXC_ERROR THEN

200: p_data => x_msg_data
201: );
202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: ROLLBACK TO Create_Alloc_Definition_PVT;
206: x_return_status := FND_API.G_RET_STS_ERROR ;
207: FND_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count ,

Line 206: x_return_status := FND_API.G_RET_STS_ERROR ;

202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: ROLLBACK TO Create_Alloc_Definition_PVT;
206: x_return_status := FND_API.G_RET_STS_ERROR ;
207: FND_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count ,
209: p_data => x_msg_data
210: );

Line 211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

207: FND_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count ,
209: p_data => x_msg_data
210: );
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: ROLLBACK TO Create_Alloc_Definition_PVT;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count ,

Line 213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

209: p_data => x_msg_data
210: );
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: ROLLBACK TO Create_Alloc_Definition_PVT;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count ,
216: p_data => x_msg_data
217: );

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

216: p_data => x_msg_data
217: );
218: WHEN OTHERS THEN
219: ROLLBACK TO Create_Alloc_Definition_PVT;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: IF FND_MSG_PUB.Check_Msg_Level
222: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
223: THEN
224: FND_MSG_PUB.Add_Exc_Msg

Line 272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

268:
269: PROCEDURE Update_Allocation_Definition
270: (
271: p_api_version IN NUMBER ,
272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
273: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
274:
275: x_return_status OUT NOCOPY VARCHAR2 ,
276: x_msg_count OUT NOCOPY NUMBER ,

Line 273: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

269: PROCEDURE Update_Allocation_Definition
270: (
271: p_api_version IN NUMBER ,
272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
273: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
274:
275: x_return_status OUT NOCOPY VARCHAR2 ,
276: x_msg_count OUT NOCOPY NUMBER ,
277: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 293: IF FND_API.to_Boolean( p_init_msg_list ) THEN

289: -- Standard Start of API savepoint
290: SAVEPOINT Update_Alloc_Definition_PVT;
291:
292: -- Initialize message list if p_init_msg_list is set to TRUE.
293: IF FND_API.to_Boolean( p_init_msg_list ) THEN
294: FND_MSG_PUB.initialize;
295: END IF;
296:
297: -- Standard call to check for call compatibility.

Line 298: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

294: FND_MSG_PUB.initialize;
295: END IF;
296:
297: -- Standard call to check for call compatibility.
298: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
299: p_api_version ,
300: l_api_name ,
301: G_PKG_NAME )
302: THEN

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: p_api_version ,
300: l_api_name ,
301: G_PKG_NAME )
302: THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: -- Initialize API return status to success
307: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 307: x_return_status := FND_API.G_RET_STS_SUCCESS;

303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: -- Initialize API return status to success
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308:
309: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN -- Bug 2659435
310: log_msg('Updating record for alloc_id : ' ||
311: p_allocation_definition_rec.alloc_id || ' line_no : ' || p_allocation_definition_rec.line_no);

Line 317: FND_API.G_MISS_NUM, NULL,

313:
314: update gl_aloc_bas
315: SET
316: inventory_item_id = decode(p_allocation_definition_rec.item_id,
317: FND_API.G_MISS_NUM, NULL,
318: NULL, inventory_item_id,
319: p_allocation_definition_rec.item_id)
320: ,basis_account_id = decode(p_allocation_definition_rec.basis_account_id,
321: FND_API.G_MISS_NUM, NULL,

Line 321: FND_API.G_MISS_NUM, NULL,

317: FND_API.G_MISS_NUM, NULL,
318: NULL, inventory_item_id,
319: p_allocation_definition_rec.item_id)
320: ,basis_account_id = decode(p_allocation_definition_rec.basis_account_id,
321: FND_API.G_MISS_NUM, NULL,
322: NULL, basis_account_id,
323: p_allocation_definition_rec.basis_account_id)
324: ,balance_type = decode(p_allocation_definition_rec.balance_type,
325: FND_API.G_MISS_NUM, NULL,

Line 325: FND_API.G_MISS_NUM, NULL,

321: FND_API.G_MISS_NUM, NULL,
322: NULL, basis_account_id,
323: p_allocation_definition_rec.basis_account_id)
324: ,balance_type = decode(p_allocation_definition_rec.balance_type,
325: FND_API.G_MISS_NUM, NULL,
326: NULL, balance_type,
327: p_allocation_definition_rec.balance_type)
328: ,bas_ytd_ptd = decode(p_allocation_definition_rec.bas_ytd_ptd,
329: FND_API.G_MISS_NUM, NULL,

Line 329: FND_API.G_MISS_NUM, NULL,

325: FND_API.G_MISS_NUM, NULL,
326: NULL, balance_type,
327: p_allocation_definition_rec.balance_type)
328: ,bas_ytd_ptd = decode(p_allocation_definition_rec.bas_ytd_ptd,
329: FND_API.G_MISS_NUM, NULL,
330: NULL, bas_ytd_ptd,
331: p_allocation_definition_rec.bas_ytd_ptd)
332: ,basis_type = decode(p_allocation_definition_rec.basis_type,
333: FND_API.G_MISS_NUM, NULL,

Line 333: FND_API.G_MISS_NUM, NULL,

329: FND_API.G_MISS_NUM, NULL,
330: NULL, bas_ytd_ptd,
331: p_allocation_definition_rec.bas_ytd_ptd)
332: ,basis_type = decode(p_allocation_definition_rec.basis_type,
333: FND_API.G_MISS_NUM, NULL,
334: NULL, basis_type,
335: p_allocation_definition_rec.basis_type)
336: ,fixed_percent = decode(p_allocation_definition_rec.fixed_percent,
337: FND_API.G_MISS_NUM, NULL,

Line 337: FND_API.G_MISS_NUM, NULL,

333: FND_API.G_MISS_NUM, NULL,
334: NULL, basis_type,
335: p_allocation_definition_rec.basis_type)
336: ,fixed_percent = decode(p_allocation_definition_rec.fixed_percent,
337: FND_API.G_MISS_NUM, NULL,
338: NULL, fixed_percent,
339: p_allocation_definition_rec.fixed_percent)
340: ,cmpntcls_id = decode(p_allocation_definition_rec.cmpntcls_id,
341: FND_API.G_MISS_NUM, NULL,

Line 341: FND_API.G_MISS_NUM, NULL,

337: FND_API.G_MISS_NUM, NULL,
338: NULL, fixed_percent,
339: p_allocation_definition_rec.fixed_percent)
340: ,cmpntcls_id = decode(p_allocation_definition_rec.cmpntcls_id,
341: FND_API.G_MISS_NUM, NULL,
342: NULL, cmpntcls_id,
343: p_allocation_definition_rec.cmpntcls_id)
344: ,analysis_code = decode(p_allocation_definition_rec.analysis_code,
345: FND_API.G_MISS_CHAR, NULL,

Line 345: FND_API.G_MISS_CHAR, NULL,

341: FND_API.G_MISS_NUM, NULL,
342: NULL, cmpntcls_id,
343: p_allocation_definition_rec.cmpntcls_id)
344: ,analysis_code = decode(p_allocation_definition_rec.analysis_code,
345: FND_API.G_MISS_CHAR, NULL,
346: NULL, analysis_code,
347: p_allocation_definition_rec.analysis_code)
348: ,organization_id = decode(p_allocation_definition_rec.organization_id,
349: FND_API.G_MISS_NUM, NULL,

Line 349: FND_API.G_MISS_NUM, NULL,

345: FND_API.G_MISS_CHAR, NULL,
346: NULL, analysis_code,
347: p_allocation_definition_rec.analysis_code)
348: ,organization_id = decode(p_allocation_definition_rec.organization_id,
349: FND_API.G_MISS_NUM, NULL,
350: NULL, organization_id,
351: p_allocation_definition_rec.organization_id)
352: -- ,creation_date = sysdate -- Bug 2722404
353: -- ,created_by = p_user_id

Line 358: FND_API.G_MISS_NUM, NULL,

354: ,last_update_date = sysdate
355: ,last_updated_by = p_user_id
356: ,last_update_login = FND_GLOBAL.LOGIN_ID
357: ,delete_mark = decode(p_allocation_definition_rec.delete_mark,
358: FND_API.G_MISS_NUM, NULL,
359: NULL, delete_mark,
360: p_allocation_definition_rec.delete_mark)
361: WHERE
362: alloc_id = p_allocation_definition_rec.alloc_id

Line 373: WHEN FND_API.G_EXC_ERROR THEN

369: p_data => x_msg_data
370: );
371:
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO Update_Alloc_Definition_PVT;
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count ,

Line 375: x_return_status := FND_API.G_RET_STS_ERROR ;

371:
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO Update_Alloc_Definition_PVT;
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count ,
378: p_data => x_msg_data
379: );

Line 380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

376: FND_MSG_PUB.Count_And_Get
377: ( p_count => x_msg_count ,
378: p_data => x_msg_data
379: );
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: ROLLBACK TO Update_Alloc_Definition_PVT;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count ,

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

378: p_data => x_msg_data
379: );
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: ROLLBACK TO Update_Alloc_Definition_PVT;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383: FND_MSG_PUB.Count_And_Get
384: ( p_count => x_msg_count ,
385: p_data => x_msg_data
386: );

Line 389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

385: p_data => x_msg_data
386: );
387: WHEN OTHERS THEN
388: ROLLBACK TO Update_Alloc_Definition_PVT;
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: IF FND_MSG_PUB.Check_Msg_Level
391: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
392: THEN
393: FND_MSG_PUB.Add_Exc_Msg