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

Line 10: p_select_date IN DATE := fnd_api.g_miss_date

6:
7: PROCEDURE Initialize_View ( p_worksheet_id IN NUMBER,
8: p_start_date IN DATE,
9: p_end_date IN DATE,
10: p_select_date IN DATE := fnd_api.g_miss_date
11: ) IS
12:
13:
14: BEGIN

Line 28: p_init_msg_list in varchar2 := fnd_api.g_false,

24: END Initialize_View ;
25:
26: PROCEDURE Define_Worksheet_Values (
27: p_api_version in number,
28: p_init_msg_list in varchar2 := fnd_api.g_false,
29: p_commit in varchar2 := fnd_api.g_false,
30: p_validation_level in number := fnd_api.g_valid_level_full,
31: p_return_status OUT NOCOPY varchar2,
32: p_msg_count OUT NOCOPY number,

Line 29: p_commit in varchar2 := fnd_api.g_false,

25:
26: PROCEDURE Define_Worksheet_Values (
27: p_api_version in number,
28: p_init_msg_list in varchar2 := fnd_api.g_false,
29: p_commit in varchar2 := fnd_api.g_false,
30: p_validation_level in number := fnd_api.g_valid_level_full,
31: p_return_status OUT NOCOPY varchar2,
32: p_msg_count OUT NOCOPY number,
33: p_msg_data OUT NOCOPY varchar2,

Line 30: p_validation_level in number := fnd_api.g_valid_level_full,

26: PROCEDURE Define_Worksheet_Values (
27: p_api_version in number,
28: p_init_msg_list in varchar2 := fnd_api.g_false,
29: p_commit in varchar2 := fnd_api.g_false,
30: p_validation_level in number := fnd_api.g_valid_level_full,
31: p_return_status OUT NOCOPY varchar2,
32: p_msg_count OUT NOCOPY number,
33: p_msg_data OUT NOCOPY varchar2,
34: p_worksheet_id in number,

Line 36: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,

32: p_msg_count OUT NOCOPY number,
33: p_msg_data OUT NOCOPY varchar2,
34: p_worksheet_id in number,
35: p_position_id in number,
36: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
37: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
38: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
39: p_out_worksheet_id OUT NOCOPY number,
40: p_out_start_date OUT NOCOPY date,

Line 37: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,

33: p_msg_data OUT NOCOPY varchar2,
34: p_worksheet_id in number,
35: p_position_id in number,
36: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
37: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
38: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
39: p_out_worksheet_id OUT NOCOPY number,
40: p_out_start_date OUT NOCOPY date,
41: p_out_end_date OUT NOCOPY date) IS

Line 38: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,

34: p_worksheet_id in number,
35: p_position_id in number,
36: p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
37: p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
38: p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
39: p_out_worksheet_id OUT NOCOPY number,
40: p_out_start_date OUT NOCOPY date,
41: p_out_end_date OUT NOCOPY date) IS
42:

Line 71: p_init_msg_list in varchar2 := fnd_api.g_false,

67: -- modify_assignment used for insert/modify assignments
68:
69: PROCEDURE Modify_Assignment (
70: p_api_version in number,
71: p_init_msg_list in varchar2 := fnd_api.g_false,
72: p_commit in varchar2 := fnd_api.g_false,
73: p_validation_level in number := fnd_api.g_valid_level_full,
74: p_return_status OUT NOCOPY varchar2,
75: p_msg_count OUT NOCOPY number,

Line 72: p_commit in varchar2 := fnd_api.g_false,

68:
69: PROCEDURE Modify_Assignment (
70: p_api_version in number,
71: p_init_msg_list in varchar2 := fnd_api.g_false,
72: p_commit in varchar2 := fnd_api.g_false,
73: p_validation_level in number := fnd_api.g_valid_level_full,
74: p_return_status OUT NOCOPY varchar2,
75: p_msg_count OUT NOCOPY number,
76: p_msg_data OUT NOCOPY varchar2,

Line 73: p_validation_level in number := fnd_api.g_valid_level_full,

69: PROCEDURE Modify_Assignment (
70: p_api_version in number,
71: p_init_msg_list in varchar2 := fnd_api.g_false,
72: p_commit in varchar2 := fnd_api.g_false,
73: p_validation_level in number := fnd_api.g_valid_level_full,
74: p_return_status OUT NOCOPY varchar2,
75: p_msg_count OUT NOCOPY number,
76: p_msg_data OUT NOCOPY varchar2,
77: p_position_assignment_id in OUT NOCOPY number,

Line 142: p_init_msg_list in varchar2 := FND_API.G_FALSE,

138:
139:
140: PROCEDURE Create_Default_Assignments(
141: p_api_version in number,
142: p_init_msg_list in varchar2 := FND_API.G_FALSE,
143: p_commit in varchar2 := FND_API.G_FALSE,
144: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT NOCOPY varchar2,
146: p_msg_count OUT NOCOPY number,

Line 143: p_commit in varchar2 := FND_API.G_FALSE,

139:
140: PROCEDURE Create_Default_Assignments(
141: p_api_version in number,
142: p_init_msg_list in varchar2 := FND_API.G_FALSE,
143: p_commit in varchar2 := FND_API.G_FALSE,
144: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT NOCOPY varchar2,
146: p_msg_count OUT NOCOPY number,
147: p_msg_data OUT NOCOPY varchar2,

Line 144: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

140: PROCEDURE Create_Default_Assignments(
141: p_api_version in number,
142: p_init_msg_list in varchar2 := FND_API.G_FALSE,
143: p_commit in varchar2 := FND_API.G_FALSE,
144: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT NOCOPY varchar2,
146: p_msg_count OUT NOCOPY number,
147: p_msg_data OUT NOCOPY varchar2,
148: p_worksheet_id in number := FND_API.G_MISS_NUM,

Line 148: p_worksheet_id in number := FND_API.G_MISS_NUM,

144: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
145: p_return_status OUT NOCOPY varchar2,
146: p_msg_count OUT NOCOPY number,
147: p_msg_data OUT NOCOPY varchar2,
148: p_worksheet_id in number := FND_API.G_MISS_NUM,
149: p_data_extract_id in number,
150: p_position_id in number := FND_API.G_MISS_NUM,
151: p_position_start_date in date := FND_API.G_MISS_DATE,
152: p_position_end_date in date := FND_API.G_MISS_DATE) IS

Line 150: p_position_id in number := FND_API.G_MISS_NUM,

146: p_msg_count OUT NOCOPY number,
147: p_msg_data OUT NOCOPY varchar2,
148: p_worksheet_id in number := FND_API.G_MISS_NUM,
149: p_data_extract_id in number,
150: p_position_id in number := FND_API.G_MISS_NUM,
151: p_position_start_date in date := FND_API.G_MISS_DATE,
152: p_position_end_date in date := FND_API.G_MISS_DATE) IS
153:
154: -- bug 4559919

Line 151: p_position_start_date in date := FND_API.G_MISS_DATE,

147: p_msg_data OUT NOCOPY varchar2,
148: p_worksheet_id in number := FND_API.G_MISS_NUM,
149: p_data_extract_id in number,
150: p_position_id in number := FND_API.G_MISS_NUM,
151: p_position_start_date in date := FND_API.G_MISS_DATE,
152: p_position_end_date in date := FND_API.G_MISS_DATE) IS
153:
154: -- bug 4559919
155: -- reverted back the changes done for bug#4151746 as the

Line 152: p_position_end_date in date := FND_API.G_MISS_DATE) IS

148: p_worksheet_id in number := FND_API.G_MISS_NUM,
149: p_data_extract_id in number,
150: p_position_id in number := FND_API.G_MISS_NUM,
151: p_position_start_date in date := FND_API.G_MISS_DATE,
152: p_position_end_date in date := FND_API.G_MISS_DATE) IS
153:
154: -- bug 4559919
155: -- reverted back the changes done for bug#4151746 as the
156: -- behavior will be as per MPA for R12 across patch levels

Line 324: l_local_dist_exists VARCHAR2(1) := FND_API.G_FALSE;

320: l_msg_count NUMBER;
321: l_msg_data VARCHAR2(2000);
322: l_priority NUMBER;
323: l_global_default_flag VARCHAR2(1);
324: l_local_dist_exists VARCHAR2(1) := FND_API.G_FALSE;
325: l_global_dist_exists VARCHAR2(1) := FND_API.G_FALSE;
326: l_distribution_id NUMBER;
327: l_rowid VARCHAR2(100);
328: l_overwrite_flag VARCHAR2(1);

Line 325: l_global_dist_exists VARCHAR2(1) := FND_API.G_FALSE;

321: l_msg_data VARCHAR2(2000);
322: l_priority NUMBER;
323: l_global_default_flag VARCHAR2(1);
324: l_local_dist_exists VARCHAR2(1) := FND_API.G_FALSE;
325: l_global_dist_exists VARCHAR2(1) := FND_API.G_FALSE;
326: l_distribution_id NUMBER;
327: l_rowid VARCHAR2(100);
328: l_overwrite_flag VARCHAR2(1);
329: l_worksheet_id NUMBER;

Line 336: IF p_worksheet_id = FND_API.G_MISS_NUM THEN

332:
333: BEGIN
334:
335: /* Bug 4545909 Start */
336: IF p_worksheet_id = FND_API.G_MISS_NUM THEN
337: l_worksheet_id := NULL;
338: ELSE
339: l_worksheet_id := p_worksheet_id;
340: END IF;

Line 352: p_init_msg_list => FND_API.G_TRUE ,

348:
349: PSB_Budget_Position_Pvt.Add_Position_To_Position_Sets
350: (
351: p_api_version => 1.0 ,
352: p_init_msg_list => FND_API.G_TRUE ,
353: p_commit => FND_API.G_FALSE ,
354: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
355: p_return_status => l_return_status ,
356: p_msg_count => l_msg_count ,

Line 353: p_commit => FND_API.G_FALSE ,

349: PSB_Budget_Position_Pvt.Add_Position_To_Position_Sets
350: (
351: p_api_version => 1.0 ,
352: p_init_msg_list => FND_API.G_TRUE ,
353: p_commit => FND_API.G_FALSE ,
354: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
355: p_return_status => l_return_status ,
356: p_msg_count => l_msg_count ,
357: p_msg_data => l_msg_data ,

Line 354: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

350: (
351: p_api_version => 1.0 ,
352: p_init_msg_list => FND_API.G_TRUE ,
353: p_commit => FND_API.G_FALSE ,
354: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
355: p_return_status => l_return_status ,
356: p_msg_count => l_msg_count ,
357: p_msg_data => l_msg_data ,
358: p_position_id => p_position_id,

Line 361: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

357: p_msg_data => l_msg_data ,
358: p_position_id => p_position_id,
359: p_worksheet_id => l_worksheet_id
360: );
361: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
362: raise FND_API.G_EXC_ERROR;
363: END IF;
364:
365: /* Bug 4545909 End */

Line 362: raise FND_API.G_EXC_ERROR;

358: p_position_id => p_position_id,
359: p_worksheet_id => l_worksheet_id
360: );
361: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
362: raise FND_API.G_EXC_ERROR;
363: END IF;
364:
365: /* Bug 4545909 End */
366:

Line 368: IF ((p_position_start_date = FND_API.G_MISS_DATE) OR

364:
365: /* Bug 4545909 End */
366:
367: /* Bug 4273099 start */
368: IF ((p_position_start_date = FND_API.G_MISS_DATE) OR
369: (p_position_end_date = FND_API.G_MISS_DATE))
370: THEN
371:
372: FOR c_Position_Rec in c_Position LOOP

Line 369: (p_position_end_date = FND_API.G_MISS_DATE))

365: /* Bug 4545909 End */
366:
367: /* Bug 4273099 start */
368: IF ((p_position_start_date = FND_API.G_MISS_DATE) OR
369: (p_position_end_date = FND_API.G_MISS_DATE))
370: THEN
371:
372: FOR c_Position_Rec in c_Position LOOP
373: l_position_start_date := c_Position_Rec.effective_start_date;

Line 379: IF p_position_start_date <> FND_API.G_MISS_DATE THEN

375: END LOOP;
376:
377: END IF;
378:
379: IF p_position_start_date <> FND_API.G_MISS_DATE THEN
380: l_position_start_date := p_position_start_date;
381: END IF;
382:
383: IF p_position_end_date <> FND_API.G_MISS_DATE THEN

Line 383: IF p_position_end_date <> FND_API.G_MISS_DATE THEN

379: IF p_position_start_date <> FND_API.G_MISS_DATE THEN
380: l_position_start_date := p_position_start_date;
381: END IF;
382:
383: IF p_position_end_date <> FND_API.G_MISS_DATE THEN
384: l_position_end_date := p_position_end_date;
385: END IF;
386:
387: FOR c_Assignments_Rec in c_Assignment_Ruleset

Line 418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

414: p_modify_flag => c_Assignments_Rec.overwrite,
415: p_worksheet_id => l_worksheet_id );
416: END LOOP;
417:
418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
419: raise FND_API.G_EXC_ERROR;
420: END IF;
421:
422: FOR c_Priority_Rec in c_Priority_ruleset LOOP

Line 419: raise FND_API.G_EXC_ERROR;

415: p_worksheet_id => l_worksheet_id );
416: END LOOP;
417:
418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
419: raise FND_API.G_EXC_ERROR;
420: END IF;
421:
422: FOR c_Priority_Rec in c_Priority_ruleset LOOP
423:

Line 429: l_local_dist_exists := FND_API.G_TRUE;

425: l_priority := c_Priority_Rec.priority;
426: l_global_default_flag := c_Priority_Rec.global_default_flag;
427:
428: IF NVL(c_priority_rec.global_default_flag,'N') = 'N' THEN
429: l_local_dist_exists := FND_API.G_TRUE;
430: END IF;
431:
432: l_overwrite_flag := c_priority_rec.overwrite;
433:

Line 439: l_global_dist_exists := FND_API.G_TRUE;

435: l_overwrite_flag := 'N';
436: END IF;
437:
438: FOR c_Global_Dist_Rec in c_Global_Dist LOOP
439: l_global_dist_exists := FND_API.G_TRUE;
440: END LOOP;
441:
442: IF l_overwrite_flag <> 'N' THEN
443:

Line 444: IF ((FND_API.to_Boolean(l_local_dist_exists)) OR

440: END LOOP;
441:
442: IF l_overwrite_flag <> 'N' THEN
443:
444: IF ((FND_API.to_Boolean(l_local_dist_exists)) OR
445: (FND_API.to_Boolean(l_global_dist_exists))) THEN
446: BEGIN
447:
448: PSB_POSITION_PAY_DISTR_PVT.Delete_Distributions_Position

Line 445: (FND_API.to_Boolean(l_global_dist_exists))) THEN

441:
442: IF l_overwrite_flag <> 'N' THEN
443:
444: IF ((FND_API.to_Boolean(l_local_dist_exists)) OR
445: (FND_API.to_Boolean(l_global_dist_exists))) THEN
446: BEGIN
447:
448: PSB_POSITION_PAY_DISTR_PVT.Delete_Distributions_Position
449: (p_api_version => 1.0,

Line 456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

452: p_msg_data => l_msg_data,
453: p_position_id => p_position_id,
454: p_worksheet_id => l_worksheet_id);
455:
456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
457: raise FND_API.G_EXC_ERROR;
458: END IF;
459: END;
460: END IF;

Line 457: raise FND_API.G_EXC_ERROR;

453: p_position_id => p_position_id,
454: p_worksheet_id => l_worksheet_id);
455:
456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
457: raise FND_API.G_EXC_ERROR;
458: END IF;
459: END;
460: END IF;
461: END IF;

Line 494: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

490: p_distribution_default_rule_id => l_default_rule_id,
491: p_rowid => l_rowid);
492:
493:
494: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
495: raise FND_API.G_EXC_ERROR;
496: END IF;
497:
498: END LOOP;

Line 495: raise FND_API.G_EXC_ERROR;

491: p_rowid => l_rowid);
492:
493:
494: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
495: raise FND_API.G_EXC_ERROR;
496: END IF;
497:
498: END LOOP;
499:

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

510:
511:
512: FUNCTION Check_Allowed
513: ( p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516: p_msg_count OUT NOCOPY NUMBER,
517: p_msg_data OUT NOCOPY VARCHAR2,
518: p_worksheet_id IN NUMBER,

Line 515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

511:
512: FUNCTION Check_Allowed
513: ( p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516: p_msg_count OUT NOCOPY NUMBER,
517: p_msg_data OUT NOCOPY VARCHAR2,
518: p_worksheet_id IN NUMBER,
519: p_position_budget_group_id IN NUMBER

Line 529: if not FND_API.Compatible_API_Call (l_api_version,

525: BEGIN
526:
527: -- Standard call to check for call compatibility.
528:
529: if not FND_API.Compatible_API_Call (l_api_version,
530: p_api_version,
531: l_api_name,
532: G_PKG_NAME)
533: then

Line 534: raise FND_API.G_EXC_UNEXPECTED_ERROR;

530: p_api_version,
531: l_api_name,
532: G_PKG_NAME)
533: then
534: raise FND_API.G_EXC_UNEXPECTED_ERROR;
535: end if;
536:
537:
538: -- Initialize message list if p_init_msg_list is set to TRUE

Line 540: if FND_API.to_Boolean (p_init_msg_list) then

536:
537:
538: -- Initialize message list if p_init_msg_list is set to TRUE
539:
540: if FND_API.to_Boolean (p_init_msg_list) then
541: FND_MSG_PUB.initialize;
542: end if;
543:
544:

Line 562: when FND_API.G_EXC_ERROR then

558:
559:
560: EXCEPTION
561:
562: when FND_API.G_EXC_ERROR then
563: return FND_API.G_FALSE;
564:
565: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
566: p_data => p_msg_data);

Line 563: return FND_API.G_FALSE;

559:
560: EXCEPTION
561:
562: when FND_API.G_EXC_ERROR then
563: return FND_API.G_FALSE;
564:
565: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
566: p_data => p_msg_data);
567:

Line 569: when FND_API.G_EXC_UNEXPECTED_ERROR then

565: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
566: p_data => p_msg_data);
567:
568:
569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: return FND_API.G_FALSE;
571:
572: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
573: p_data => p_msg_data);

Line 570: return FND_API.G_FALSE;

566: p_data => p_msg_data);
567:
568:
569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: return FND_API.G_FALSE;
571:
572: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
573: p_data => p_msg_data);
574:

Line 577: return FND_API.G_FALSE;

573: p_data => p_msg_data);
574:
575:
576: when OTHERS then
577: return FND_API.G_FALSE;
578:
579: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
580: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
581: l_api_name);

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

587: END Check_Allowed;
588:
589: FUNCTION Rev_Check_Allowed
590: ( p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
593: p_msg_count OUT NOCOPY NUMBER,
594: p_msg_data OUT NOCOPY VARCHAR2,
595: p_startdate_pp IN DATE,

Line 592: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

588:
589: FUNCTION Rev_Check_Allowed
590: ( p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
593: p_msg_count OUT NOCOPY NUMBER,
594: p_msg_data OUT NOCOPY VARCHAR2,
595: p_startdate_pp IN DATE,
596: p_enddate_cy IN DATE,

Line 608: if not FND_API.Compatible_API_Call (l_api_version,

604: BEGIN
605:
606: -- Standard call to check for call compatibility.
607:
608: if not FND_API.Compatible_API_Call (l_api_version,
609: p_api_version,
610: l_api_name,
611: G_PKG_NAME)
612: then

Line 613: raise FND_API.G_EXC_UNEXPECTED_ERROR;

609: p_api_version,
610: l_api_name,
611: G_PKG_NAME)
612: then
613: raise FND_API.G_EXC_UNEXPECTED_ERROR;
614: end if;
615:
616:
617: -- Initialize message list if p_init_msg_list is set to TRUE

Line 619: if FND_API.to_Boolean (p_init_msg_list) then

615:
616:
617: -- Initialize message list if p_init_msg_list is set to TRUE
618:
619: if FND_API.to_Boolean (p_init_msg_list) then
620: FND_MSG_PUB.initialize;
621: end if;
622:
623:

Line 643: when FND_API.G_EXC_ERROR then

639:
640:
641: EXCEPTION
642:
643: when FND_API.G_EXC_ERROR then
644: return FND_API.G_FALSE;
645:
646: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
647: p_data => p_msg_data);

Line 644: return FND_API.G_FALSE;

640:
641: EXCEPTION
642:
643: when FND_API.G_EXC_ERROR then
644: return FND_API.G_FALSE;
645:
646: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
647: p_data => p_msg_data);
648:

Line 650: when FND_API.G_EXC_UNEXPECTED_ERROR then

646: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
647: p_data => p_msg_data);
648:
649:
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: return FND_API.G_FALSE;
652:
653: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
654: p_data => p_msg_data);

Line 651: return FND_API.G_FALSE;

647: p_data => p_msg_data);
648:
649:
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: return FND_API.G_FALSE;
652:
653: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
654: p_data => p_msg_data);
655:

Line 658: return FND_API.G_FALSE;

654: p_data => p_msg_data);
655:
656:
657: when OTHERS then
658: return FND_API.G_FALSE;
659:
660: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
661: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
662: l_api_name);

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

668: END Rev_Check_Allowed;
669:
670: PROCEDURE Modify_Distribution_WS
671: ( p_api_version IN NUMBER,
672: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
673: p_commit IN VARCHAR2 := FND_API.G_FALSE,
674: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
675: p_return_status OUT NOCOPY VARCHAR2,
676: p_msg_count OUT NOCOPY NUMBER,

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

669:
670: PROCEDURE Modify_Distribution_WS
671: ( p_api_version IN NUMBER,
672: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
673: p_commit IN VARCHAR2 := FND_API.G_FALSE,
674: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
675: p_return_status OUT NOCOPY VARCHAR2,
676: p_msg_count OUT NOCOPY NUMBER,
677: p_msg_data OUT NOCOPY VARCHAR2,

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

670: PROCEDURE Modify_Distribution_WS
671: ( p_api_version IN NUMBER,
672: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
673: p_commit IN VARCHAR2 := FND_API.G_FALSE,
674: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
675: p_return_status OUT NOCOPY VARCHAR2,
676: p_msg_count OUT NOCOPY NUMBER,
677: p_msg_data OUT NOCOPY VARCHAR2,
678: p_distribution_id IN OUT NOCOPY NUMBER,

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

675: p_return_status OUT NOCOPY VARCHAR2,
676: p_msg_count OUT NOCOPY NUMBER,
677: p_msg_data OUT NOCOPY VARCHAR2,
678: p_distribution_id IN OUT NOCOPY NUMBER,
679: p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
680: p_position_id IN NUMBER,
681: p_data_extract_id IN NUMBER,
682: p_effective_start_date IN DATE,
683: p_effective_end_date IN DATE,

Line 690: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,

686: p_distribution_percent IN NUMBER,
687: p_global_default_flag IN VARCHAR2,
688: p_distribution_default_rule_id IN NUMBER,
689: p_rowid IN OUT NOCOPY VARCHAR2,
690: p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
691: p_mode IN VARCHAR2
692: ) IS
693: BEGIN
694: PSB_POSITION_PAY_DISTR_PVT.MODIFY_DISTRIBUTION_WS (

Line 723: p_init_msg_list in varchar2 := fnd_api.g_false,

719: END Modify_Distribution_WS;
720:
721: PROCEDURE DELETE_ROW (
722: p_api_version in number,
723: p_init_msg_list in varchar2 := fnd_api.g_false,
724: p_commit in varchar2 := fnd_api.g_false,
725: p_validation_level in number := fnd_api.g_valid_level_full,
726: p_return_status OUT NOCOPY varchar2,
727: p_msg_count OUT NOCOPY number,

Line 724: p_commit in varchar2 := fnd_api.g_false,

720:
721: PROCEDURE DELETE_ROW (
722: p_api_version in number,
723: p_init_msg_list in varchar2 := fnd_api.g_false,
724: p_commit in varchar2 := fnd_api.g_false,
725: p_validation_level in number := fnd_api.g_valid_level_full,
726: p_return_status OUT NOCOPY varchar2,
727: p_msg_count OUT NOCOPY number,
728: p_msg_data OUT NOCOPY varchar2,

Line 725: p_validation_level in number := fnd_api.g_valid_level_full,

721: PROCEDURE DELETE_ROW (
722: p_api_version in number,
723: p_init_msg_list in varchar2 := fnd_api.g_false,
724: p_commit in varchar2 := fnd_api.g_false,
725: p_validation_level in number := fnd_api.g_valid_level_full,
726: p_return_status OUT NOCOPY varchar2,
727: p_msg_count OUT NOCOPY number,
728: p_msg_data OUT NOCOPY varchar2,
729: p_distribution_id in number

Line 749: p_init_msg_list in varchar2 := fnd_api.g_false,

745: --
746:
747: PROCEDURE LOCK_ROW (
748: p_api_version in number,
749: p_init_msg_list in varchar2 := fnd_api.g_false,
750: p_commit in varchar2 := fnd_api.g_false,
751: p_validation_level in number := fnd_api.g_valid_level_full,
752: p_return_status OUT NOCOPY varchar2,
753: p_msg_count OUT NOCOPY number,

Line 750: p_commit in varchar2 := fnd_api.g_false,

746:
747: PROCEDURE LOCK_ROW (
748: p_api_version in number,
749: p_init_msg_list in varchar2 := fnd_api.g_false,
750: p_commit in varchar2 := fnd_api.g_false,
751: p_validation_level in number := fnd_api.g_valid_level_full,
752: p_return_status OUT NOCOPY varchar2,
753: p_msg_count OUT NOCOPY number,
754: p_msg_data OUT NOCOPY varchar2,

Line 751: p_validation_level in number := fnd_api.g_valid_level_full,

747: PROCEDURE LOCK_ROW (
748: p_api_version in number,
749: p_init_msg_list in varchar2 := fnd_api.g_false,
750: p_commit in varchar2 := fnd_api.g_false,
751: p_validation_level in number := fnd_api.g_valid_level_full,
752: p_return_status OUT NOCOPY varchar2,
753: p_msg_count OUT NOCOPY number,
754: p_msg_data OUT NOCOPY varchar2,
755: p_row_locked OUT NOCOPY varchar2,