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

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

10: /*----------------------- Table HANDler Procedures ----------------------- */
11:
12: PROCEDURE Create_LD_Default_Assignments
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,

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

11:
12: PROCEDURE Create_LD_Default_Assignments
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,

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

12: PROCEDURE Create_LD_Default_Assignments
13: ( p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,
20: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

Line 20: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,
20: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
21: p_data_extract_id IN NUMBER
22:
23: ) IS
24:

Line 136: IF NOT FND_API.Compatible_API_Call (l_api_version,

132: BEGIN
133:
134: -- Standard call to check FOR call compatibility.
135:
136: IF NOT FND_API.Compatible_API_Call (l_api_version,
137: p_api_version,
138: l_api_name,
139: G_PKG_NAME)
140: THEN

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137: p_api_version,
138: l_api_name,
139: G_PKG_NAME)
140: THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: SAVEPOINT LD_Default_Assignments;
145:

Line 195: IF p_worksheet_id = FND_API.G_MISS_NUM THEN

191: l_percentage := 100-l_distribution_percentage;
192:
193: BEGIN
194:
195: IF p_worksheet_id = FND_API.G_MISS_NUM THEN
196: l_worksheet_id := NULL;
197: ELSE
198: l_worksheet_id := p_worksheet_id;
199: END IF;

Line 225: p_init_msg_list => FND_API.G_FALSE,

221: l_distribution_percentage :=
222: l_percentage *0.01*l_ld_dist_rec.distribution_percent;
223: PSB_POSITION_PAY_DISTR_PVT.Modify_Distribution
224: (p_api_version => 1.0,
225: p_init_msg_list => FND_API.G_FALSE,
226: p_commit => FND_API.G_FALSE,
227: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
228: p_return_status => l_return_status,
229: p_msg_count => l_msg_count,

Line 226: p_commit => FND_API.G_FALSE,

222: l_percentage *0.01*l_ld_dist_rec.distribution_percent;
223: PSB_POSITION_PAY_DISTR_PVT.Modify_Distribution
224: (p_api_version => 1.0,
225: p_init_msg_list => FND_API.G_FALSE,
226: p_commit => FND_API.G_FALSE,
227: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
228: p_return_status => l_return_status,
229: p_msg_count => l_msg_count,
230: p_msg_data => l_msg_data,

Line 227: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

223: PSB_POSITION_PAY_DISTR_PVT.Modify_Distribution
224: (p_api_version => 1.0,
225: p_init_msg_list => FND_API.G_FALSE,
226: p_commit => FND_API.G_FALSE,
227: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
228: p_return_status => l_return_status,
229: p_msg_count => l_msg_count,
230: p_msg_data => l_msg_data,
231: p_distribution_id => l_distribution_id,

Line 244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

240: p_distribution_default_rule_id => l_default_rule_id,
241: p_rowid => l_rowid,
242: p_mode => 'R');
243:
244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: END LOOP;--end of l_ld_dist_rec

Line 245: RAISE FND_API.G_EXC_ERROR;

241: p_rowid => l_rowid,
242: p_mode => 'R');
243:
244: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: END LOOP;--end of l_ld_dist_rec
249:

Line 263: p_return_status := FND_API.G_RET_STS_SUCCESS;

259: END LOOP; --end of l_positions_rec
260:
261: -- Initialize API return status to success
262:
263: p_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: -- StANDard check of p_commit.
266:
267: IF FND_API.to_Boolean (p_commit) THEN

Line 267: IF FND_API.to_Boolean (p_commit) THEN

263: p_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: -- StANDard check of p_commit.
266:
267: IF FND_API.to_Boolean (p_commit) THEN
268: commit work;
269: END IF;
270:
271: -- StANDard call to get message count AND IF count is 1, get message info.

Line 279: WHEN FND_API.G_EXC_ERROR THEN

275:
276:
277: EXCEPTION
278:
279: WHEN FND_API.G_EXC_ERROR THEN
280:
281: ROLLBACK to LD_Default_Assignments;
282:
283: p_return_status := FND_API.G_RET_STS_ERROR;

Line 283: p_return_status := FND_API.G_RET_STS_ERROR;

279: WHEN FND_API.G_EXC_ERROR THEN
280:
281: ROLLBACK to LD_Default_Assignments;
282:
283: p_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
286: p_data => p_msg_data);
287:

Line 288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

284:
285: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
286: p_data => p_msg_data);
287:
288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289:
290: ROLLBACK to LD_Default_Assignments;
291:
292: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 292: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

288: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
289:
290: ROLLBACK to LD_Default_Assignments;
291:
292: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293:
294: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
295: p_data => p_msg_data);
296:

Line 301: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

297: WHEN OTHERS THEN
298:
299: ROLLBACK to LD_Default_Assignments;
300:
301: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302:
303: IF FND_MSG_PUB.Check_Msg_Level
304: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
305: THEN FND_MSG_PUB.Add_Exc_Msg

Line 353: p_commit => FND_API.G_TRUE,

349: p_data_extract_id );
350:
351: PSB_BUDGET_POSITION_PVT.Populate_Budget_Positions
352: (p_api_version => 1.0,
353: p_commit => FND_API.G_TRUE,
354: p_return_status => l_return_status,
355: p_msg_count => l_msg_count,
356: p_msg_data => l_msg_data,
357: p_data_extract_id => p_data_extract_id);

Line 359: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

355: p_msg_count => l_msg_count,
356: p_msg_data => l_msg_data,
357: p_data_extract_id => p_data_extract_id);
358:
359: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: raise FND_API.G_EXC_ERROR;
361: end if;
362:
363: PSB_CONCURRENCY_CONTROL_PUB.Enforce_Concurrency_Control

Line 360: raise FND_API.G_EXC_ERROR;

356: p_msg_data => l_msg_data,
357: p_data_extract_id => p_data_extract_id);
358:
359: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: raise FND_API.G_EXC_ERROR;
361: end if;
362:
363: PSB_CONCURRENCY_CONTROL_PUB.Enforce_Concurrency_Control
364: (p_api_version => 1.0,

Line 372: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

368: p_concurrency_class => 'MAINTENANCE',
369: p_concurrency_entity_name => 'DATA_EXTRACT',
370: p_concurrency_entity_id => p_data_extract_id);
371:
372: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: raise FND_API.G_EXC_ERROR;
374: end if;
375:
376: PSB_LD_POS_DEFAULTS_PVT.Create_LD_Default_Assignments(

Line 373: raise FND_API.G_EXC_ERROR;

369: p_concurrency_entity_name => 'DATA_EXTRACT',
370: p_concurrency_entity_id => p_data_extract_id);
371:
372: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: raise FND_API.G_EXC_ERROR;
374: end if;
375:
376: PSB_LD_POS_DEFAULTS_PVT.Create_LD_Default_Assignments(
377: p_api_version => 1.0,

Line 378: p_init_msg_list => FND_API.G_TRUE,

374: end if;
375:
376: PSB_LD_POS_DEFAULTS_PVT.Create_LD_Default_Assignments(
377: p_api_version => 1.0,
378: p_init_msg_list => FND_API.G_TRUE,
379: p_commit => FND_API.G_TRUE,
380: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
381: p_return_status => l_return_status,
382: p_msg_count => l_msg_count,

Line 379: p_commit => FND_API.G_TRUE,

375:
376: PSB_LD_POS_DEFAULTS_PVT.Create_LD_Default_Assignments(
377: p_api_version => 1.0,
378: p_init_msg_list => FND_API.G_TRUE,
379: p_commit => FND_API.G_TRUE,
380: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
381: p_return_status => l_return_status,
382: p_msg_count => l_msg_count,
383: p_msg_data => l_msg_data,

Line 380: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

376: PSB_LD_POS_DEFAULTS_PVT.Create_LD_Default_Assignments(
377: p_api_version => 1.0,
378: p_init_msg_list => FND_API.G_TRUE,
379: p_commit => FND_API.G_TRUE,
380: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
381: p_return_status => l_return_status,
382: p_msg_count => l_msg_count,
383: p_msg_data => l_msg_data,
384: p_data_extract_id => p_data_extract_id) ;

Line 386: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

382: p_msg_count => l_msg_count,
383: p_msg_data => l_msg_data,
384: p_data_extract_id => p_data_extract_id) ;
385:
386: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
387: raise FND_API.G_EXC_ERROR;
388: END IF;
389: --
390:

Line 387: raise FND_API.G_EXC_ERROR;

383: p_msg_data => l_msg_data,
384: p_data_extract_id => p_data_extract_id) ;
385:
386: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
387: raise FND_API.G_EXC_ERROR;
388: END IF;
389: --
390:
391: -- This is the execution file for the concurrent program 'Release Concurrency

Line 403: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

399: p_concurrency_class => 'MAINTENANCE',
400: p_concurrency_entity_name => 'DATA_EXTRACT',
401: p_concurrency_entity_id => p_data_extract_id);
402:
403: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
404: raise FND_API.G_EXC_ERROR;
405: end if;
406: /* Start Bug No. 2322856 */
407: -- PSB_MESSAGE_S.Print_Success;

Line 404: raise FND_API.G_EXC_ERROR;

400: p_concurrency_entity_name => 'DATA_EXTRACT',
401: p_concurrency_entity_id => p_data_extract_id);
402:
403: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
404: raise FND_API.G_EXC_ERROR;
405: end if;
406: /* Start Bug No. 2322856 */
407: -- PSB_MESSAGE_S.Print_Success;
408: /* End Bug No. 2322856 */

Line 415: WHEN FND_API.G_EXC_ERROR THEN

411: COMMIT WORK;
412:
413: EXCEPTION
414:
415: WHEN FND_API.G_EXC_ERROR THEN
416: --
417: PSB_CONCURRENCY_CONTROL_PUB.Release_Concurrency_Control
418: (p_api_version => 1.0,
419: p_return_status => l_return_status,

Line 427: p_print_header => FND_API.G_TRUE );

423: p_concurrency_entity_name => 'DATA_EXTRACT',
424: p_concurrency_entity_id => p_data_extract_id);
425:
426: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
427: p_print_header => FND_API.G_TRUE );
428: retcode := 2 ;
429: COMMIT WORK ;
430: --
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

427: p_print_header => FND_API.G_TRUE );
428: retcode := 2 ;
429: COMMIT WORK ;
430: --
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: --
433: PSB_CONCURRENCY_CONTROL_PUB.Release_Concurrency_Control
434: (p_api_version => 1.0,
435: p_return_status => l_return_status,

Line 443: p_print_header => FND_API.G_TRUE );

439: p_concurrency_entity_name => 'DATA_EXTRACT',
440: p_concurrency_entity_id => p_data_extract_id);
441:
442: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
443: p_print_header => FND_API.G_TRUE );
444: retcode := 2 ;
445: COMMIT WORK ;
446:
447: WHEN OTHERS THEN

Line 466: p_print_header => FND_API.G_TRUE );

462: l_api_name ) ;
463: END IF ;
464: --
465: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
466: p_print_header => FND_API.G_TRUE );
467: --
468: retcode := 2 ;
469: COMMIT WORK ;
470: --