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

Line 97: p_insert_from_base IN VARCHAR2 := FND_API.G_FALSE,

93: -- using the Period FTE Ratios and the Annual FTE Ratio
94:
95: PROCEDURE Distribute_Position_Cost
96: ( p_return_status OUT NOCOPY VARCHAR2,
97: p_insert_from_base IN VARCHAR2 := FND_API.G_FALSE,
98: p_update_from_base IN VARCHAR2 := FND_API.G_FALSE,
99: p_worksheet_id IN NUMBER,
100: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_rounding_factor IN NUMBER,

Line 98: p_update_from_base IN VARCHAR2 := FND_API.G_FALSE,

94:
95: PROCEDURE Distribute_Position_Cost
96: ( p_return_status OUT NOCOPY VARCHAR2,
97: p_insert_from_base IN VARCHAR2 := FND_API.G_FALSE,
98: p_update_from_base IN VARCHAR2 := FND_API.G_FALSE,
99: p_worksheet_id IN NUMBER,
100: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_rounding_factor IN NUMBER,
102: p_position_line_id IN NUMBER,

Line 100: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

96: ( p_return_status OUT NOCOPY VARCHAR2,
97: p_insert_from_base IN VARCHAR2 := FND_API.G_FALSE,
98: p_update_from_base IN VARCHAR2 := FND_API.G_FALSE,
99: p_worksheet_id IN NUMBER,
100: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
101: p_rounding_factor IN NUMBER,
102: p_position_line_id IN NUMBER,
103: p_pay_element_id IN NUMBER,
104: p_budget_year_id IN NUMBER,

Line 105: p_base_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

101: p_rounding_factor IN NUMBER,
102: p_position_line_id IN NUMBER,
103: p_pay_element_id IN NUMBER,
104: p_budget_year_id IN NUMBER,
105: p_base_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_service_package_id IN NUMBER,
107: p_stage_set_id IN NUMBER,
108: p_start_stage_seq IN NUMBER,
109: p_current_stage_seq IN NUMBER,

Line 161: ( p_init_index NUMBER := FND_API.G_MISS_NUM

157:
158: -- Initialize the PL/SQL Structures that temporarily store Position Cost info
159:
160: PROCEDURE Initialize_Calc
161: ( p_init_index NUMBER := FND_API.G_MISS_NUM
162: ) IS
163:
164: l_init_index BINARY_INTEGER;
165:

Line 168: if p_init_index = FND_API.G_MISS_NUM then

164: l_init_index BINARY_INTEGER;
165:
166: BEGIN
167:
168: if p_init_index = FND_API.G_MISS_NUM then
169: begin
170:
171: -- Initialize the entire structure
172:

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

514: -- creating new Positions
515:
516: FUNCTION Check_Allowed
517: ( p_api_version IN NUMBER,
518: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
519: p_worksheet_id IN NUMBER,
520: p_position_budget_group_id IN NUMBER
521: ) RETURN VARCHAR2 IS
522:

Line 529: l_return_status VARCHAR2(1) := FND_API.G_FALSE;

525:
526: l_budget_calendar_id NUMBER;
527: l_budget_group_id NUMBER;
528:
529: l_return_status VARCHAR2(1) := FND_API.G_FALSE;
530:
531: cursor c_Allowed is
532: select 'Valid'
533: from PSB_BUDGET_GROUPS

Line 546: if not FND_API.Compatible_API_Call (l_api_version,

542: BEGIN
543:
544: -- Standard call to check for call compatibility
545:
546: if not FND_API.Compatible_API_Call (l_api_version,
547: p_api_version,
548: l_api_name,
549: G_PKG_NAME)
550: then

Line 551: raise FND_API.G_EXC_UNEXPECTED_ERROR;

547: p_api_version,
548: l_api_name,
549: G_PKG_NAME)
550: then
551: raise FND_API.G_EXC_UNEXPECTED_ERROR;
552: end if;
553:
554: for c_WS_Rec in c_WS (p_worksheet_id) loop
555: l_budget_calendar_id := c_WS_Rec.budget_calendar_id;

Line 559: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then

555: l_budget_calendar_id := c_WS_Rec.budget_calendar_id;
556: l_budget_group_id := c_WS_Rec.budget_group_id;
557: end loop;
558:
559: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
560: begin
561:
562: PSB_WS_ACCT1.Cache_Budget_Calendar
563: (p_return_status => l_return_status,

Line 566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

562: PSB_WS_ACCT1.Cache_Budget_Calendar
563: (p_return_status => l_return_status,
564: p_budget_calendar_id => l_budget_calendar_id);
565:
566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
567: raise FND_API.G_EXC_ERROR;
568: end if;
569:
570: end;

Line 567: raise FND_API.G_EXC_ERROR;

563: (p_return_status => l_return_status,
564: p_budget_calendar_id => l_budget_calendar_id);
565:
566: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
567: raise FND_API.G_EXC_ERROR;
568: end if;
569:
570: end;
571: end if;

Line 574: l_return_status := FND_API.G_TRUE;

570: end;
571: end if;
572:
573: for c_Allowed_Rec in c_Allowed loop
574: l_return_status := FND_API.G_TRUE;
575: end loop;
576:
577: return l_return_status;
578:

Line 582: when FND_API.G_EXC_ERROR then

578:
579:
580: EXCEPTION
581:
582: when FND_API.G_EXC_ERROR then
583: return FND_API.G_FALSE;
584:
585: when FND_API.G_EXC_UNEXPECTED_ERROR then
586: return FND_API.G_FALSE;

Line 583: return FND_API.G_FALSE;

579:
580: EXCEPTION
581:
582: when FND_API.G_EXC_ERROR then
583: return FND_API.G_FALSE;
584:
585: when FND_API.G_EXC_UNEXPECTED_ERROR then
586: return FND_API.G_FALSE;
587:

Line 585: when FND_API.G_EXC_UNEXPECTED_ERROR then

581:
582: when FND_API.G_EXC_ERROR then
583: return FND_API.G_FALSE;
584:
585: when FND_API.G_EXC_UNEXPECTED_ERROR then
586: return FND_API.G_FALSE;
587:
588: when OTHERS then
589: return FND_API.G_FALSE;

Line 586: return FND_API.G_FALSE;

582: when FND_API.G_EXC_ERROR then
583: return FND_API.G_FALSE;
584:
585: when FND_API.G_EXC_UNEXPECTED_ERROR then
586: return FND_API.G_FALSE;
587:
588: when OTHERS then
589: return FND_API.G_FALSE;
590:

Line 589: return FND_API.G_FALSE;

585: when FND_API.G_EXC_UNEXPECTED_ERROR then
586: return FND_API.G_FALSE;
587:
588: when OTHERS then
589: return FND_API.G_FALSE;
590:
591: if FND_MSG_PUB.Check_Msg_Level
592: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
593: then

Line 678: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then

674: if g_budget_calendar_id is not null then
675: l_budget_calendar_id := g_budget_calendar_id;
676: end if;
677:
678: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
679: begin
680:
681: PSB_WS_ACCT1.Cache_Budget_Calendar
682: (p_return_status => l_return_status,

Line 685: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

681: PSB_WS_ACCT1.Cache_Budget_Calendar
682: (p_return_status => l_return_status,
683: p_budget_calendar_id => l_budget_calendar_id);
684:
685: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
686: raise FND_API.G_EXC_ERROR;
687: end if;
688:
689: end;

Line 686: raise FND_API.G_EXC_ERROR;

682: (p_return_status => l_return_status,
683: p_budget_calendar_id => l_budget_calendar_id);
684:
685: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
686: raise FND_API.G_EXC_ERROR;
687: end if;
688:
689: end;
690: end if;

Line 716: p_return_status := FND_API.G_RET_STS_SUCCESS;

712:
713:
714: -- Initialize API return status to success
715:
716: p_return_status := FND_API.G_RET_STS_SUCCESS;
717:
718:
719: EXCEPTION
720:

Line 721: when FND_API.G_EXC_ERROR then

717:
718:
719: EXCEPTION
720:
721: when FND_API.G_EXC_ERROR then
722: p_return_status := FND_API.G_RET_STS_ERROR;
723:
724: when FND_API.G_EXC_UNEXPECTED_ERROR then
725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 722: p_return_status := FND_API.G_RET_STS_ERROR;

718:
719: EXCEPTION
720:
721: when FND_API.G_EXC_ERROR then
722: p_return_status := FND_API.G_RET_STS_ERROR;
723:
724: when FND_API.G_EXC_UNEXPECTED_ERROR then
725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:

Line 724: when FND_API.G_EXC_UNEXPECTED_ERROR then

720:
721: when FND_API.G_EXC_ERROR then
722: p_return_status := FND_API.G_RET_STS_ERROR;
723:
724: when FND_API.G_EXC_UNEXPECTED_ERROR then
725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: when OTHERS then
728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

721: when FND_API.G_EXC_ERROR then
722: p_return_status := FND_API.G_RET_STS_ERROR;
723:
724: when FND_API.G_EXC_UNEXPECTED_ERROR then
725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: when OTHERS then
728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729:

Line 728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

724: when FND_API.G_EXC_UNEXPECTED_ERROR then
725: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: when OTHERS then
728: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729:
730: END Cache_Elements;
731:
732: /* ----------------------------------------------------------------------- */

Line 773: p_return_status := FND_API.G_RET_STS_SUCCESS;

769:
770:
771: -- Initialize API return status to success
772:
773: p_return_status := FND_API.G_RET_STS_SUCCESS;
774:
775:
776: EXCEPTION
777:

Line 778: when FND_API.G_EXC_ERROR then

774:
775:
776: EXCEPTION
777:
778: when FND_API.G_EXC_ERROR then
779: p_return_status := FND_API.G_RET_STS_ERROR;
780:
781: when FND_API.G_EXC_UNEXPECTED_ERROR then
782: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 779: p_return_status := FND_API.G_RET_STS_ERROR;

775:
776: EXCEPTION
777:
778: when FND_API.G_EXC_ERROR then
779: p_return_status := FND_API.G_RET_STS_ERROR;
780:
781: when FND_API.G_EXC_UNEXPECTED_ERROR then
782: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783:

Line 781: when FND_API.G_EXC_UNEXPECTED_ERROR then

777:
778: when FND_API.G_EXC_ERROR then
779: p_return_status := FND_API.G_RET_STS_ERROR;
780:
781: when FND_API.G_EXC_UNEXPECTED_ERROR then
782: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783:
784: when OTHERS then
785: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 782: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

778: when FND_API.G_EXC_ERROR then
779: p_return_status := FND_API.G_RET_STS_ERROR;
780:
781: when FND_API.G_EXC_UNEXPECTED_ERROR then
782: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783:
784: when OTHERS then
785: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786:

Line 785: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

781: when FND_API.G_EXC_UNEXPECTED_ERROR then
782: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783:
784: when OTHERS then
785: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786:
787: END Cache_Named_Attributes;
788:
789: /* ----------------------------------------------------------------------- */

Line 897: p_return_status := FND_API.G_RET_STS_SUCCESS;

893:
894:
895: -- Initialize API return status to success
896:
897: p_return_status := FND_API.G_RET_STS_SUCCESS;
898:
899: EXCEPTION
900:
901: when FND_API.G_EXC_ERROR then

Line 901: when FND_API.G_EXC_ERROR then

897: p_return_status := FND_API.G_RET_STS_SUCCESS;
898:
899: EXCEPTION
900:
901: when FND_API.G_EXC_ERROR then
902: /* Bug 4075170 Start */
903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
904: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');

Line 905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');

901: when FND_API.G_EXC_ERROR then
902: /* Bug 4075170 Start */
903: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
904: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
905: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_ERROR');
906: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
907: ||'failed due to the following error');
908: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
909: /* Bug 4075170 End */

Line 911: p_return_status := FND_API.G_RET_STS_ERROR;

907: ||'failed due to the following error');
908: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
909: /* Bug 4075170 End */
910:
911: p_return_status := FND_API.G_RET_STS_ERROR;
912:
913: when FND_API.G_EXC_UNEXPECTED_ERROR then
914: /* Bug 4075170 Start */
915: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);

Line 913: when FND_API.G_EXC_UNEXPECTED_ERROR then

909: /* Bug 4075170 End */
910:
911: p_return_status := FND_API.G_RET_STS_ERROR;
912:
913: when FND_API.G_EXC_UNEXPECTED_ERROR then
914: /* Bug 4075170 Start */
915: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');

Line 917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');

913: when FND_API.G_EXC_UNEXPECTED_ERROR then
914: /* Bug 4075170 Start */
915: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);
916: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Parameter Info::'||l_param_info);
917: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error Type:: FND_API.G_EXC_UNEXPECTED_ERROR');
918: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cache_Named_Attribute_Values API '
919: ||'failed due to the following error');
920: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
921: /* Bug 4075170 End */

Line 923: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

919: ||'failed due to the following error');
920: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
921: /* Bug 4075170 End */
922:
923: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924:
925: when OTHERS then
926: /* Bug 4075170 Start */
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Status::>'||l_debug_info);

Line 935: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

931: ||'failed due to the following error');
932: FND_FILE.PUT_LINE(FND_FILE.LOG, sqlerrm);
933: /* Bug 4075170 End */
934:
935: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936:
937: END Cache_Named_Attribute_Values;
938:
939: /* ----------------------------------------------------------------------- */

Line 977: raise FND_API.G_EXC_ERROR;

973: message_token('ELEMENT', p_element_name);
974: message_token('START_DATE', p_start_date);
975: message_token('END_DATE', p_end_date);
976: add_message('PSB', 'PSB_FACTOR_NOT_DEFINED');
977: raise FND_API.G_EXC_ERROR;
978: end if;
979:
980: p_factor := l_factor;
981:

Line 985: p_return_status := FND_API.G_RET_STS_SUCCESS;

981:
982:
983: -- Initialize API return status to success
984:
985: p_return_status := FND_API.G_RET_STS_SUCCESS;
986:
987:
988: EXCEPTION
989:

Line 990: when FND_API.G_EXC_ERROR then

986:
987:
988: EXCEPTION
989:
990: when FND_API.G_EXC_ERROR then
991: p_return_status := FND_API.G_RET_STS_ERROR;
992:
993: when FND_API.G_EXC_UNEXPECTED_ERROR then
994: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 991: p_return_status := FND_API.G_RET_STS_ERROR;

987:
988: EXCEPTION
989:
990: when FND_API.G_EXC_ERROR then
991: p_return_status := FND_API.G_RET_STS_ERROR;
992:
993: when FND_API.G_EXC_UNEXPECTED_ERROR then
994: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995:

Line 993: when FND_API.G_EXC_UNEXPECTED_ERROR then

989:
990: when FND_API.G_EXC_ERROR then
991: p_return_status := FND_API.G_RET_STS_ERROR;
992:
993: when FND_API.G_EXC_UNEXPECTED_ERROR then
994: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995:
996: when OTHERS then
997: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 994: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

990: when FND_API.G_EXC_ERROR then
991: p_return_status := FND_API.G_RET_STS_ERROR;
992:
993: when FND_API.G_EXC_UNEXPECTED_ERROR then
994: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995:
996: when OTHERS then
997: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998:

Line 997: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

993: when FND_API.G_EXC_UNEXPECTED_ERROR then
994: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995:
996: when OTHERS then
997: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998:
999: END HRMS_Factor;
1000:
1001: /* ----------------------------------------------------------------------- */

Line 1138: if nvl(g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then

1134: for c_Dist_Rec in c_WSDist loop
1135:
1136: l_saldist_found := TRUE;
1137:
1138: if nvl(g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
1139: begin
1140:
1141: for c_Budget_Group_Rec in c_Budget_Group (c_Dist_Rec.code_combination_id) loop
1142: g_salary_budget_group_id := c_Budget_Group_Rec.budget_group_id;

Line 1162: raise FND_API.G_EXC_ERROR;

1158:
1159: message_token('CCID', l_concat_segments);
1160: message_token('POSITION', p_position_name);
1161: add_message('PSB', 'PSB_CANNOT_ASSIGN_BUDGET_GROUP');
1162: raise FND_API.G_EXC_ERROR;
1163:
1164: end;
1165: end if;
1166:

Line 1186: if nvl(g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then

1182: for c_Dist_Rec in c_Dist loop
1183:
1184: l_saldist_found := TRUE;
1185:
1186: if nvl(g_salary_budget_group_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM then
1187: begin
1188:
1189: for c_Budget_Group_Rec in c_Budget_Group (c_Dist_Rec.code_combination_id) loop
1190: g_salary_budget_group_id := c_Budget_Group_Rec.budget_group_id;

Line 1210: raise FND_API.G_EXC_ERROR;

1206:
1207: message_token('CCID', l_concat_segments);
1208: message_token('POSITION', p_position_name);
1209: add_message('PSB', 'PSB_CANNOT_ASSIGN_BUDGET_GROUP');
1210: raise FND_API.G_EXC_ERROR;
1211:
1212: end;
1213: end if;
1214:

Line 1239: raise FND_API.G_EXC_ERROR;

1235: message_token('POSITION', p_position_name);
1236: message_token('START_DATE', p_start_date);
1237: message_token('END_DATE', p_end_date);
1238: add_message('PSB', 'PSB_NO_SALARY_DISTRIBUTION');
1239: raise FND_API.G_EXC_ERROR;
1240: end if;
1241:
1242: if p_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then
1243: begin

Line 1242: if p_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then

1238: add_message('PSB', 'PSB_NO_SALARY_DISTRIBUTION');
1239: raise FND_API.G_EXC_ERROR;
1240: end if;
1241:
1242: if p_flex_code <> nvl(PSB_WS_ACCT1.g_flex_code, FND_API.G_MISS_NUM) then
1243: begin
1244:
1245: PSB_WS_ACCT1.Flex_Info
1246: (p_flex_code => p_flex_code,

Line 1249: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1245: PSB_WS_ACCT1.Flex_Info
1246: (p_flex_code => p_flex_code,
1247: p_return_status => l_return_status);
1248:
1249: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1250: raise FND_API.G_EXC_ERROR;
1251: end if;
1252:
1253: end;

Line 1250: raise FND_API.G_EXC_ERROR;

1246: (p_flex_code => p_flex_code,
1247: p_return_status => l_return_status);
1248:
1249: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1250: raise FND_API.G_EXC_ERROR;
1251: end if;
1252:
1253: end;
1254: end if;

Line 1259: p_return_status := FND_API.G_RET_STS_SUCCESS;

1255:
1256:
1257: -- Initialize API return status to success
1258:
1259: p_return_status := FND_API.G_RET_STS_SUCCESS;
1260:
1261:
1262: EXCEPTION
1263:

Line 1264: when FND_API.G_EXC_ERROR then

1260:
1261:
1262: EXCEPTION
1263:
1264: when FND_API.G_EXC_ERROR then
1265: p_return_status := FND_API.G_RET_STS_ERROR;
1266:
1267: when FND_API.G_EXC_UNEXPECTED_ERROR then
1268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1265: p_return_status := FND_API.G_RET_STS_ERROR;

1261:
1262: EXCEPTION
1263:
1264: when FND_API.G_EXC_ERROR then
1265: p_return_status := FND_API.G_RET_STS_ERROR;
1266:
1267: when FND_API.G_EXC_UNEXPECTED_ERROR then
1268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269:

Line 1267: when FND_API.G_EXC_UNEXPECTED_ERROR then

1263:
1264: when FND_API.G_EXC_ERROR then
1265: p_return_status := FND_API.G_RET_STS_ERROR;
1266:
1267: when FND_API.G_EXC_UNEXPECTED_ERROR then
1268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269:
1270: when OTHERS then
1271: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1264: when FND_API.G_EXC_ERROR then
1265: p_return_status := FND_API.G_RET_STS_ERROR;
1266:
1267: when FND_API.G_EXC_UNEXPECTED_ERROR then
1268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269:
1270: when OTHERS then
1271: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272:

Line 1271: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1267: when FND_API.G_EXC_UNEXPECTED_ERROR then
1268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269:
1270: when OTHERS then
1271: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272:
1273: END Cache_Salary_Dist;
1274:
1275: /* ----------------------------------------------------------------------- */

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

1282: -- Worksheet Operations APIs
1283:
1284: PROCEDURE Create_Position_Lines
1285: ( p_api_version IN NUMBER,
1286: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1287: p_return_status OUT NOCOPY VARCHAR2,
1288: p_position_line_id OUT NOCOPY NUMBER,
1289: p_worksheet_id IN NUMBER,
1290: p_position_id IN NUMBER,

Line 1292: p_copy_of_position_line_id IN NUMBER := FND_API.G_MISS_NUM

1288: p_position_line_id OUT NOCOPY NUMBER,
1289: p_worksheet_id IN NUMBER,
1290: p_position_id IN NUMBER,
1291: p_budget_group_id IN NUMBER,
1292: p_copy_of_position_line_id IN NUMBER := FND_API.G_MISS_NUM
1293: ) IS
1294:
1295: l_api_name CONSTANT VARCHAR2(30) := 'Create_Position_Lines';
1296: l_api_version CONSTANT NUMBER := 1.0;

Line 1301: l_instance_exists VARCHAR2(1) := FND_API.G_FALSE;

1297:
1298: l_userid NUMBER;
1299: l_loginid NUMBER;
1300:
1301: l_instance_exists VARCHAR2(1) := FND_API.G_FALSE;
1302:
1303: l_poslineid NUMBER;
1304: l_budget_group_id NUMBER;
1305:

Line 1328: if not FND_API.Compatible_API_Call (l_api_version,

1324: BEGIN
1325:
1326: -- Standard call to check for call compatibility
1327:
1328: if not FND_API.Compatible_API_Call (l_api_version,
1329: p_api_version,
1330: l_api_name,
1331: G_PKG_NAME)
1332: then

Line 1333: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1329: p_api_version,
1330: l_api_name,
1331: G_PKG_NAME)
1332: then
1333: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1334: end if;
1335:
1336: l_userid := FND_GLOBAL.USER_ID;
1337: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 1359: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then

1355:
1356: end;
1357: end if;
1358:
1359: if g_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1360: begin
1361:
1362: PSB_WS_ACCT1.Cache_Budget_Calendar
1363: (p_return_status => l_return_status,

Line 1366: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1362: PSB_WS_ACCT1.Cache_Budget_Calendar
1363: (p_return_status => l_return_status,
1364: p_budget_calendar_id => g_budget_calendar_id);
1365:
1366: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1367: raise FND_API.G_EXC_ERROR;
1368: end if;
1369:
1370: end;

Line 1367: raise FND_API.G_EXC_ERROR;

1363: (p_return_status => l_return_status,
1364: p_budget_calendar_id => g_budget_calendar_id);
1365:
1366: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1367: raise FND_API.G_EXC_ERROR;
1368: end if;
1369:
1370: end;
1371: end if;

Line 1376: l_instance_exists := FND_API.G_TRUE;

1372:
1373: for c_PosLine_Rec in c_PosLine loop
1374: l_poslineid := c_PosLine_Rec.position_line_id;
1375: l_budget_group_id := c_PosLine_Rec.budget_group_id;
1376: l_instance_exists := FND_API.G_TRUE;
1377: end loop;
1378:
1379: if FND_API.to_Boolean(l_instance_exists) then
1380: begin

Line 1379: if FND_API.to_Boolean(l_instance_exists) then

1375: l_budget_group_id := c_PosLine_Rec.budget_group_id;
1376: l_instance_exists := FND_API.G_TRUE;
1377: end loop;
1378:
1379: if FND_API.to_Boolean(l_instance_exists) then
1380: begin
1381:
1382: if p_budget_group_id <> l_budget_group_id then
1383: begin

Line 1387: copy_of_position_line_id = decode(p_copy_of_position_line_id, FND_API.G_MISS_NUM, null, p_copy_of_position_line_id),

1383: begin
1384:
1385: update PSB_WS_POSITION_LINES
1386: set budget_group_id = p_budget_group_id,
1387: copy_of_position_line_id = decode(p_copy_of_position_line_id, FND_API.G_MISS_NUM, null, p_copy_of_position_line_id),
1388: last_update_date = sysdate,
1389: last_updated_by = l_userid,
1390: last_update_login = l_loginid
1391: where position_line_id = l_poslineid;

Line 1405: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1401: p_return_status => l_return_status,
1402: p_worksheet_id => p_worksheet_id,
1403: p_position_line_id => l_poslineid);
1404:
1405: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1406: raise FND_API.G_EXC_ERROR;
1407: end if;
1408:
1409: end;

Line 1406: raise FND_API.G_EXC_ERROR;

1402: p_worksheet_id => p_worksheet_id,
1403: p_position_line_id => l_poslineid);
1404:
1405: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1406: raise FND_API.G_EXC_ERROR;
1407: end if;
1408:
1409: end;
1410: else

Line 1424: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1420: p_return_status => l_return_status,
1421: p_worksheet_id => c_Distribute_WS_Rec.worksheet_id,
1422: p_position_line_id => l_poslineid);
1423:
1424: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1425: raise FND_API.G_EXC_ERROR;
1426: end if;
1427:
1428: end loop;

Line 1425: raise FND_API.G_EXC_ERROR;

1421: p_worksheet_id => c_Distribute_WS_Rec.worksheet_id,
1422: p_position_line_id => l_poslineid);
1423:
1424: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1425: raise FND_API.G_EXC_ERROR;
1426: end if;
1427:
1428: end loop;
1429:

Line 1457: decode(p_copy_of_position_line_id, FND_API.G_MISS_NUM, null, p_copy_of_position_line_id),

1453: creation_date)
1454: values (l_poslineid,
1455: p_position_id,
1456: p_budget_group_id,
1457: decode(p_copy_of_position_line_id, FND_API.G_MISS_NUM, null, p_copy_of_position_line_id),
1458: sysdate,
1459: l_userid,
1460: l_loginid,
1461: l_userid,

Line 1473: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1469: p_return_status => l_return_status,
1470: p_worksheet_id => p_worksheet_id,
1471: p_position_line_id => l_poslineid);
1472:
1473: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1474: raise FND_API.G_EXC_ERROR;
1475: end if;
1476:
1477: end;

Line 1474: raise FND_API.G_EXC_ERROR;

1470: p_worksheet_id => p_worksheet_id,
1471: p_position_line_id => l_poslineid);
1472:
1473: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1474: raise FND_API.G_EXC_ERROR;
1475: end if;
1476:
1477: end;
1478: else

Line 1492: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1488: p_return_status => l_return_status,
1489: p_worksheet_id => c_Distribute_WS_Rec.worksheet_id,
1490: p_position_line_id => l_poslineid);
1491:
1492: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1493: raise FND_API.G_EXC_ERROR;
1494: end if;
1495:
1496: end loop;

Line 1493: raise FND_API.G_EXC_ERROR;

1489: p_worksheet_id => c_Distribute_WS_Rec.worksheet_id,
1490: p_position_line_id => l_poslineid);
1491:
1492: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1493: raise FND_API.G_EXC_ERROR;
1494: end if;
1495:
1496: end loop;
1497:

Line 1509: p_return_status := FND_API.G_RET_STS_SUCCESS;

1505:
1506:
1507: -- Initialize API return status to success
1508:
1509: p_return_status := FND_API.G_RET_STS_SUCCESS;
1510:
1511:
1512: EXCEPTION
1513:

Line 1514: when FND_API.G_EXC_ERROR then

1510:
1511:
1512: EXCEPTION
1513:
1514: when FND_API.G_EXC_ERROR then
1515: p_return_status := FND_API.G_RET_STS_ERROR;
1516: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1517: p_data => l_msg_data);
1518:

Line 1515: p_return_status := FND_API.G_RET_STS_ERROR;

1511:
1512: EXCEPTION
1513:
1514: when FND_API.G_EXC_ERROR then
1515: p_return_status := FND_API.G_RET_STS_ERROR;
1516: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1517: p_data => l_msg_data);
1518:
1519:

Line 1520: when FND_API.G_EXC_UNEXPECTED_ERROR then

1516: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1517: p_data => l_msg_data);
1518:
1519:
1520: when FND_API.G_EXC_UNEXPECTED_ERROR then
1521: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1522: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1523: p_data => l_msg_data);
1524:

Line 1521: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1517: p_data => l_msg_data);
1518:
1519:
1520: when FND_API.G_EXC_UNEXPECTED_ERROR then
1521: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1522: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1523: p_data => l_msg_data);
1524:
1525: when OTHERS then

Line 1526: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1522: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
1523: p_data => l_msg_data);
1524:
1525: when OTHERS then
1526: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:
1528: if FND_MSG_PUB.Check_Msg_Level
1529: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1530: then

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

1544: -- (PSB_WS_LINES_POSITIONS)
1545:
1546: PROCEDURE Create_Position_Matrix
1547: ( p_api_version IN NUMBER,
1548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1549: p_return_status OUT NOCOPY VARCHAR2,
1550: p_worksheet_id IN NUMBER,
1551: p_position_line_id IN NUMBER,
1552: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,

Line 1552: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,

1548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1549: p_return_status OUT NOCOPY VARCHAR2,
1550: p_worksheet_id IN NUMBER,
1551: p_position_line_id IN NUMBER,
1552: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,
1553: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE
1554: ) IS
1555:
1556: l_api_name CONSTANT VARCHAR2(30) := 'Create_Position_Matrix';

Line 1553: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE

1549: p_return_status OUT NOCOPY VARCHAR2,
1550: p_worksheet_id IN NUMBER,
1551: p_position_line_id IN NUMBER,
1552: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,
1553: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE
1554: ) IS
1555:
1556: l_api_name CONSTANT VARCHAR2(30) := 'Create_Position_Matrix';
1557: l_api_version CONSTANT NUMBER := 1.0;

Line 1566: if not FND_API.Compatible_API_Call (l_api_version,

1562: BEGIN
1563:
1564: -- Standard call to check for call compatibility
1565:
1566: if not FND_API.Compatible_API_Call (l_api_version,
1567: p_api_version,
1568: l_api_name,
1569: G_PKG_NAME)
1570: then

Line 1571: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1567: p_api_version,
1568: l_api_name,
1569: G_PKG_NAME)
1570: then
1571: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1572: end if;
1573:
1574: l_userid := FND_GLOBAL.USER_ID;
1575: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 1578: set freeze_flag = decode(p_freeze_flag, FND_API.G_FALSE, null, FND_API.G_TRUE, 'Y', p_freeze_flag),

1574: l_userid := FND_GLOBAL.USER_ID;
1575: l_loginid := FND_GLOBAL.LOGIN_ID;
1576:
1577: update PSB_WS_LINES_POSITIONS
1578: set freeze_flag = decode(p_freeze_flag, FND_API.G_FALSE, null, FND_API.G_TRUE, 'Y', p_freeze_flag),
1579: view_line_flag = decode(p_view_line_flag, FND_API.G_TRUE, 'Y', FND_API.G_FALSE, null, p_view_line_flag),
1580: last_update_date = sysdate,
1581: last_updated_by = l_userid,
1582: last_update_login = l_loginid

Line 1579: view_line_flag = decode(p_view_line_flag, FND_API.G_TRUE, 'Y', FND_API.G_FALSE, null, p_view_line_flag),

1575: l_loginid := FND_GLOBAL.LOGIN_ID;
1576:
1577: update PSB_WS_LINES_POSITIONS
1578: set freeze_flag = decode(p_freeze_flag, FND_API.G_FALSE, null, FND_API.G_TRUE, 'Y', p_freeze_flag),
1579: view_line_flag = decode(p_view_line_flag, FND_API.G_TRUE, 'Y', FND_API.G_FALSE, null, p_view_line_flag),
1580: last_update_date = sysdate,
1581: last_updated_by = l_userid,
1582: last_update_login = l_loginid
1583: where position_line_id = p_position_line_id

Line 1602: decode(p_freeze_flag, FND_API.G_FALSE, null, FND_API.G_TRUE, 'Y', p_freeze_flag),

1598: creation_date)
1599: values
1600: (p_worksheet_id,
1601: p_position_line_id,
1602: decode(p_freeze_flag, FND_API.G_FALSE, null, FND_API.G_TRUE, 'Y', p_freeze_flag),
1603: decode(p_view_line_flag, FND_API.G_TRUE, 'Y', FND_API.G_FALSE, null, p_view_line_flag),
1604: sysdate,
1605: l_userid,
1606: l_loginid,

Line 1603: decode(p_view_line_flag, FND_API.G_TRUE, 'Y', FND_API.G_FALSE, null, p_view_line_flag),

1599: values
1600: (p_worksheet_id,
1601: p_position_line_id,
1602: decode(p_freeze_flag, FND_API.G_FALSE, null, FND_API.G_TRUE, 'Y', p_freeze_flag),
1603: decode(p_view_line_flag, FND_API.G_TRUE, 'Y', FND_API.G_FALSE, null, p_view_line_flag),
1604: sysdate,
1605: l_userid,
1606: l_loginid,
1607: l_userid,

Line 1616: p_return_status := FND_API.G_RET_STS_SUCCESS;

1612:
1613:
1614: -- Initialize API return status to success
1615:
1616: p_return_status := FND_API.G_RET_STS_SUCCESS;
1617:
1618:
1619: EXCEPTION
1620:

Line 1621: when FND_API.G_EXC_ERROR then

1617:
1618:
1619: EXCEPTION
1620:
1621: when FND_API.G_EXC_ERROR then
1622: p_return_status := FND_API.G_RET_STS_ERROR;
1623:
1624: when FND_API.G_EXC_UNEXPECTED_ERROR then
1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1622: p_return_status := FND_API.G_RET_STS_ERROR;

1618:
1619: EXCEPTION
1620:
1621: when FND_API.G_EXC_ERROR then
1622: p_return_status := FND_API.G_RET_STS_ERROR;
1623:
1624: when FND_API.G_EXC_UNEXPECTED_ERROR then
1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626:

Line 1624: when FND_API.G_EXC_UNEXPECTED_ERROR then

1620:
1621: when FND_API.G_EXC_ERROR then
1622: p_return_status := FND_API.G_RET_STS_ERROR;
1623:
1624: when FND_API.G_EXC_UNEXPECTED_ERROR then
1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626:
1627: when OTHERS then
1628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1621: when FND_API.G_EXC_ERROR then
1622: p_return_status := FND_API.G_RET_STS_ERROR;
1623:
1624: when FND_API.G_EXC_UNEXPECTED_ERROR then
1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626:
1627: when OTHERS then
1628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629:

Line 1628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1624: when FND_API.G_EXC_UNEXPECTED_ERROR then
1625: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626:
1627: when OTHERS then
1628: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629:
1630: if FND_MSG_PUB.Check_Msg_Level
1631: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1632: then

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

1651: -- of FTE
1652:
1653: PROCEDURE Create_FTE_Lines
1654: ( p_api_version IN NUMBER,
1655: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1656: p_return_status OUT NOCOPY VARCHAR2,
1657: p_fte_line_id OUT NOCOPY NUMBER,
1658: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
1659: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,

Line 1658: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,

1654: ( p_api_version IN NUMBER,
1655: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1656: p_return_status OUT NOCOPY VARCHAR2,
1657: p_fte_line_id OUT NOCOPY NUMBER,
1658: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
1659: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
1660: p_worksheet_id IN NUMBER,
1661: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
1662: p_position_line_id IN NUMBER,

Line 1659: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,

1655: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
1656: p_return_status OUT NOCOPY VARCHAR2,
1657: p_fte_line_id OUT NOCOPY NUMBER,
1658: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
1659: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
1660: p_worksheet_id IN NUMBER,
1661: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
1662: p_position_line_id IN NUMBER,
1663: p_budget_year_id IN NUMBER,

Line 1661: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

1657: p_fte_line_id OUT NOCOPY NUMBER,
1658: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
1659: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
1660: p_worksheet_id IN NUMBER,
1661: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
1662: p_position_line_id IN NUMBER,
1663: p_budget_year_id IN NUMBER,
1664: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
1665: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,

Line 1664: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

1660: p_worksheet_id IN NUMBER,
1661: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
1662: p_position_line_id IN NUMBER,
1663: p_budget_year_id IN NUMBER,
1664: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
1665: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
1666: p_service_package_id IN NUMBER,
1667: p_stage_set_id IN NUMBER,
1668: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 1665: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,

1661: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
1662: p_position_line_id IN NUMBER,
1663: p_budget_year_id IN NUMBER,
1664: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
1665: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
1666: p_service_package_id IN NUMBER,
1667: p_stage_set_id IN NUMBER,
1668: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
1669: p_current_stage_seq IN NUMBER,

Line 1668: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

1664: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
1665: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
1666: p_service_package_id IN NUMBER,
1667: p_stage_set_id IN NUMBER,
1668: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
1669: p_current_stage_seq IN NUMBER,
1670: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
1671: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type
1672: ) IS

Line 1670: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

1666: p_service_package_id IN NUMBER,
1667: p_stage_set_id IN NUMBER,
1668: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
1669: p_current_stage_seq IN NUMBER,
1670: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
1671: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type
1672: ) IS
1673:
1674: l_api_name CONSTANT VARCHAR2(30) := 'Create_FTE_Lines';

Line 1701: l_spfl_exists VARCHAR2(1) := FND_API.G_FALSE;

1697:
1698: l_spflid NUMBER;
1699: l_spfte PSB_WS_ACCT1.g_prdamt_tbl_type;
1700: l_spannual_fte NUMBER;
1701: l_spfl_exists VARCHAR2(1) := FND_API.G_FALSE;
1702:
1703: l_global_wsid NUMBER;
1704: l_base_spid NUMBER;
1705:

Line 1719: if not FND_API.Compatible_API_Call (l_api_version,

1715: BEGIN
1716:
1717: -- Standard call to check for call compatibility
1718:
1719: if not FND_API.Compatible_API_Call (l_api_version,
1720: p_api_version,
1721: l_api_name,
1722: G_PKG_NAME)
1723: then

Line 1724: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1720: p_api_version,
1721: l_api_name,
1722: G_PKG_NAME)
1723: then
1724: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1725: end if;
1726:
1727: l_userid := FND_GLOBAL.USER_ID;
1728: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 1737: if p_start_stage_seq = FND_API.G_MISS_NUM then

1733: l_total_fte := l_total_fte + nvl(p_period_fte(l_index),0);
1734: end loop;
1735: /*For Bug No : 2811698 End*/
1736:
1737: if p_start_stage_seq = FND_API.G_MISS_NUM then
1738: l_start_stage_seq := p_current_stage_seq;
1739: else
1740: l_start_stage_seq := p_start_stage_seq;
1741: end if;

Line 1743: if FND_API.to_Boolean(p_check_spfl_exists) then

1739: else
1740: l_start_stage_seq := p_start_stage_seq;
1741: end if;
1742:
1743: if FND_API.to_Boolean(p_check_spfl_exists) then
1744: begin
1745:
1746: -- For a Service Package overlap try to identify the target FTE Line
1747:

Line 1784: l_spfl_exists := FND_API.G_TRUE;

1780: l_spfte(57) := c_Wfl_Rec.period57_fte; l_spfte(58) := c_Wfl_Rec.period58_fte;
1781: l_spfte(59) := c_Wfl_Rec.period59_fte; l_spfte(60) := c_Wfl_Rec.period60_fte;
1782: l_spannual_fte := c_Wfl_Rec.annual_fte;
1783:
1784: l_spfl_exists := FND_API.G_TRUE;
1785:
1786: end loop;
1787:
1788: end;

Line 1791: if ((p_annual_fte = FND_API.G_MISS_NUM) or

1787:
1788: end;
1789: end if;
1790:
1791: if ((p_annual_fte = FND_API.G_MISS_NUM) or
1792: (FND_API.to_Boolean(l_spfl_exists)) or
1793: (FND_API.to_Boolean(p_recalculate_flag))) then
1794: begin
1795:

Line 1792: (FND_API.to_Boolean(l_spfl_exists)) or

1788: end;
1789: end if;
1790:
1791: if ((p_annual_fte = FND_API.G_MISS_NUM) or
1792: (FND_API.to_Boolean(l_spfl_exists)) or
1793: (FND_API.to_Boolean(p_recalculate_flag))) then
1794: begin
1795:
1796: for c_WS_Rec in c_WS (p_worksheet_id) loop

Line 1793: (FND_API.to_Boolean(p_recalculate_flag))) then

1789: end if;
1790:
1791: if ((p_annual_fte = FND_API.G_MISS_NUM) or
1792: (FND_API.to_Boolean(l_spfl_exists)) or
1793: (FND_API.to_Boolean(p_recalculate_flag))) then
1794: begin
1795:
1796: for c_WS_Rec in c_WS (p_worksheet_id) loop
1797: l_global_wsid := c_WS_Rec.global_worksheet_id;

Line 1808: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then

1804: for c_BG_Rec in c_BG (l_budget_group_id) loop
1805: l_business_group_id := c_BG_Rec.business_group_id;
1806: end loop;
1807:
1808: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
1809: begin
1810:
1811: PSB_WS_ACCT1.Cache_Budget_Calendar
1812: (p_return_status => l_return_status,

Line 1815: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1811: PSB_WS_ACCT1.Cache_Budget_Calendar
1812: (p_return_status => l_return_status,
1813: p_budget_calendar_id => l_budget_calendar_id);
1814:
1815: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1816: raise FND_API.G_EXC_ERROR;
1817: end if;
1818:
1819: end;

Line 1816: raise FND_API.G_EXC_ERROR;

1812: (p_return_status => l_return_status,
1813: p_budget_calendar_id => l_budget_calendar_id);
1814:
1815: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1816: raise FND_API.G_EXC_ERROR;
1817: end if;
1818:
1819: end;
1820: end if;

Line 1842: if FND_API.to_Boolean(l_spfl_exists) then

1838: l_annual_fte := 0;
1839:
1840: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
1841:
1842: if FND_API.to_Boolean(l_spfl_exists) then
1843: begin
1844:
1845: l_fte := nvl(p_period_fte(l_index), 0) + nvl(l_spfte(l_index), 0);
1846:

Line 1862: if p_annual_fte <> FND_API.G_MISS_NUM then

1858: l_annual_fte := l_annual_fte + l_fte;
1859:
1860: end loop;
1861:
1862: if p_annual_fte <> FND_API.G_MISS_NUM then
1863: l_annual_fte := p_annual_fte;
1864: else
1865: begin
1866:

Line 1874: if FND_API.to_Boolean(l_spfl_exists) then

1870:
1871: end;
1872: end if;
1873:
1874: if FND_API.to_Boolean(l_spfl_exists) then
1875: begin
1876:
1877: update PSB_WS_FTE_LINES
1878: set period1_fte = l_period_fte(1), period2_fte = l_period_fte(2),

Line 1908: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),

1904: period53_fte = l_period_fte(53), period54_fte = l_period_fte(54),
1905: period55_fte = l_period_fte(55), period56_fte = l_period_fte(56),
1906: period57_fte = l_period_fte(57), period58_fte = l_period_fte(58),
1907: period59_fte = l_period_fte(59), period60_fte = l_period_fte(60),
1908: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
1909: annual_fte = l_annual_fte,
1910: last_update_date = sysdate,
1911: last_updated_by = l_userid,
1912: last_update_login = l_loginid

Line 1950: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),

1946: period53_fte = l_period_fte(53), period54_fte = l_period_fte(54),
1947: period55_fte = l_period_fte(55), period56_fte = l_period_fte(56),
1948: period57_fte = l_period_fte(57), period58_fte = l_period_fte(58),
1949: period59_fte = l_period_fte(59), period60_fte = l_period_fte(60),
1950: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
1951: annual_fte = l_annual_fte,
1952: last_update_date = sysdate,
1953: last_updated_by = l_userid,
1954: last_update_login = l_loginid

Line 2020: decode(p_end_stage_seq, FND_API.G_MISS_NUM, null, p_end_stage_seq),

2016: p_service_package_id,
2017: p_stage_set_id,
2018: l_start_stage_seq,
2019: p_current_stage_seq,
2020: decode(p_end_stage_seq, FND_API.G_MISS_NUM, null, p_end_stage_seq),
2021: l_period_fte(1), l_period_fte(2), l_period_fte(3), l_period_fte(4),
2022: l_period_fte(5), l_period_fte(6), l_period_fte(7), l_period_fte(8),
2023: l_period_fte(9), l_period_fte(10), l_period_fte(11), l_period_fte(12),
2024: l_period_fte(13), l_period_fte(14), l_period_fte(15), l_period_fte(16),

Line 2045: if FND_API.to_Boolean(p_recalculate_flag) then

2041: sysdate);
2042:
2043: p_fte_line_id := l_ftelineid;
2044:
2045: if FND_API.to_Boolean(p_recalculate_flag) then
2046: begin
2047:
2048: for c_BaseSP_Rec in c_BaseSP (l_global_wsid) loop
2049: l_base_spid := c_BaseSP_Rec.service_package_id;

Line 2061: p_insert_from_base => FND_API.G_TRUE,

2057: --This is to ensure that FTE proration will happen based on the yearly FTE
2058: --and not on period level FTE
2059: Distribute_Position_Cost
2060: (p_return_status => l_return_status,
2061: p_insert_from_base => FND_API.G_TRUE,
2062: p_worksheet_id => p_worksheet_id,
2063: p_flex_mapping_set_id => p_flex_mapping_set_id,
2064: p_rounding_factor => l_rounding_factor,
2065: p_position_line_id => p_position_line_id,

Line 2081: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2077: p_num_budget_periods => l_num_budget_periods
2078: /*For Bug No : 2811698 End*/
2079: );
2080:
2081: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2082: raise FND_API.G_EXC_ERROR;
2083: end if;
2084:
2085: end loop;

Line 2082: raise FND_API.G_EXC_ERROR;

2078: /*For Bug No : 2811698 End*/
2079: );
2080:
2081: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2082: raise FND_API.G_EXC_ERROR;
2083: end if;
2084:
2085: end loop;
2086:

Line 2094: if ((FND_API.to_Boolean(p_recalculate_flag)) or

2090: end;
2091: else
2092: begin
2093:
2094: if ((FND_API.to_Boolean(p_recalculate_flag)) or
2095: (FND_API.to_Boolean(l_spfl_exists))) then
2096: begin
2097:
2098: for c_Elements_Rec in c_Rec_Elements (l_data_extract_id,

Line 2095: (FND_API.to_Boolean(l_spfl_exists))) then

2091: else
2092: begin
2093:
2094: if ((FND_API.to_Boolean(p_recalculate_flag)) or
2095: (FND_API.to_Boolean(l_spfl_exists))) then
2096: begin
2097:
2098: for c_Elements_Rec in c_Rec_Elements (l_data_extract_id,
2099: l_business_group_id) loop

Line 2120: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2116: p_num_budget_periods => l_num_budget_periods
2117: /*For Bug No : 2811698 End*/
2118: );
2119:
2120: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2121: raise FND_API.G_EXC_ERROR;
2122: end if;
2123:
2124: end loop;

Line 2121: raise FND_API.G_EXC_ERROR;

2117: /*For Bug No : 2811698 End*/
2118: );
2119:
2120: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2121: raise FND_API.G_EXC_ERROR;
2122: end if;
2123:
2124: end loop;
2125:

Line 2132: if ((FND_API.to_Boolean(p_recalculate_flag)) or

2128:
2129: end;
2130: end if;
2131:
2132: if ((FND_API.to_Boolean(p_recalculate_flag)) or
2133: (FND_API.to_Boolean(l_spfl_exists))) then
2134: begin
2135:
2136: -- Redistribute the Annual FTE across the Recurring Salary Distributions

Line 2133: (FND_API.to_Boolean(l_spfl_exists))) then

2129: end;
2130: end if;
2131:
2132: if ((FND_API.to_Boolean(p_recalculate_flag)) or
2133: (FND_API.to_Boolean(l_spfl_exists))) then
2134: begin
2135:
2136: -- Redistribute the Annual FTE across the Recurring Salary Distributions
2137:

Line 2149: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2145: p_stage_set_id => p_stage_set_id,
2146: p_current_stage_seq => p_current_stage_seq,
2147: p_budget_group_id => p_budget_group_id);
2148:
2149: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2150: raise FND_API.G_EXC_ERROR;
2151: end if;
2152:
2153: end;

Line 2150: raise FND_API.G_EXC_ERROR;

2146: p_current_stage_seq => p_current_stage_seq,
2147: p_budget_group_id => p_budget_group_id);
2148:
2149: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2150: raise FND_API.G_EXC_ERROR;
2151: end if;
2152:
2153: end;
2154: end if;

Line 2159: p_return_status := FND_API.G_RET_STS_SUCCESS;

2155:
2156:
2157: -- Initialize API return status to success
2158:
2159: p_return_status := FND_API.G_RET_STS_SUCCESS;
2160:
2161:
2162: EXCEPTION
2163:

Line 2164: when FND_API.G_EXC_ERROR then

2160:
2161:
2162: EXCEPTION
2163:
2164: when FND_API.G_EXC_ERROR then
2165: p_return_status := FND_API.G_RET_STS_ERROR;
2166: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2167: p_data => l_msg_data);
2168:

Line 2165: p_return_status := FND_API.G_RET_STS_ERROR;

2161:
2162: EXCEPTION
2163:
2164: when FND_API.G_EXC_ERROR then
2165: p_return_status := FND_API.G_RET_STS_ERROR;
2166: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2167: p_data => l_msg_data);
2168:
2169:

Line 2170: when FND_API.G_EXC_UNEXPECTED_ERROR then

2166: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2167: p_data => l_msg_data);
2168:
2169:
2170: when FND_API.G_EXC_UNEXPECTED_ERROR then
2171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2172: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2173: p_data => l_msg_data);
2174:

Line 2171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2167: p_data => l_msg_data);
2168:
2169:
2170: when FND_API.G_EXC_UNEXPECTED_ERROR then
2171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2172: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2173: p_data => l_msg_data);
2174:
2175: when OTHERS then

Line 2176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2172: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2173: p_data => l_msg_data);
2174:
2175: when OTHERS then
2176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177:
2178: if FND_MSG_PUB.Check_Msg_Level
2179: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2180: then

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

2221: -- definition independent of FTE
2222:
2223: PROCEDURE Create_FTE_Lines
2224: ( p_api_version IN NUMBER,
2225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
2226: p_return_status OUT NOCOPY VARCHAR2,
2227: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
2228: p_worksheet_id IN NUMBER,
2229: p_fte_line_id IN NUMBER,

Line 2227: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

2223: PROCEDURE Create_FTE_Lines
2224: ( p_api_version IN NUMBER,
2225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
2226: p_return_status OUT NOCOPY VARCHAR2,
2227: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
2228: p_worksheet_id IN NUMBER,
2229: p_fte_line_id IN NUMBER,
2230: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
2231: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 2230: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

2226: p_return_status OUT NOCOPY VARCHAR2,
2227: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
2228: p_worksheet_id IN NUMBER,
2229: p_fte_line_id IN NUMBER,
2230: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
2231: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
2232: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
2233: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
2234: ) IS

Line 2231: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

2227: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
2228: p_worksheet_id IN NUMBER,
2229: p_fte_line_id IN NUMBER,
2230: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
2231: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
2232: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
2233: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
2234: ) IS
2235:

Line 2233: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM

2229: p_fte_line_id IN NUMBER,
2230: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
2231: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
2232: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
2233: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
2234: ) IS
2235:
2236: l_api_name CONSTANT VARCHAR2(30) := 'Create_FTE_Lines';
2237: l_api_version CONSTANT NUMBER := 1.0;

Line 2239: l_new_stage VARCHAR2(1) := FND_API.G_FALSE;

2235:
2236: l_api_name CONSTANT VARCHAR2(30) := 'Create_FTE_Lines';
2237: l_api_version CONSTANT NUMBER := 1.0;
2238:
2239: l_new_stage VARCHAR2(1) := FND_API.G_FALSE;
2240:
2241: l_previous_stage_seq NUMBER;
2242:
2243: l_userid NUMBER;

Line 2276: l_spfl_exists VARCHAR2(1) := FND_API.G_FALSE;

2272: l_spflid NUMBER;
2273: l_spfte PSB_WS_ACCT1.g_prdamt_tbl_type;
2274: -- Added l_bind_fte as part of fix for bug 3132485
2275: l_bind_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
2276: l_spfl_exists VARCHAR2(1) := FND_API.G_FALSE;
2277:
2278: l_recalculate_flag VARCHAR2(1) := FND_API.G_FALSE;
2279:
2280: sql_wfl VARCHAR2(6000);

Line 2278: l_recalculate_flag VARCHAR2(1) := FND_API.G_FALSE;

2274: -- Added l_bind_fte as part of fix for bug 3132485
2275: l_bind_fte PSB_WS_ACCT1.g_prdamt_tbl_type;
2276: l_spfl_exists VARCHAR2(1) := FND_API.G_FALSE;
2277:
2278: l_recalculate_flag VARCHAR2(1) := FND_API.G_FALSE;
2279:
2280: sql_wfl VARCHAR2(6000);
2281: num_wfl INTEGER;
2282:

Line 2289: l_update_from_base VARCHAR2(1) := FND_API.G_FALSE;

2285:
2286: l_global_wsid NUMBER;
2287: l_base_spid NUMBER;
2288:
2289: l_update_from_base VARCHAR2(1) := FND_API.G_FALSE;
2290:
2291: l_return_status VARCHAR2(1);
2292: l_msg_count NUMBER;
2293: l_msg_data VARCHAR2(2000);

Line 2334: if not FND_API.Compatible_API_Call (l_api_version,

2330:
2331: -- Standard call to check for call compatibility
2332:
2333:
2334: if not FND_API.Compatible_API_Call (l_api_version,
2335: p_api_version,
2336: l_api_name,
2337: G_PKG_NAME)
2338: then

Line 2339: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2335: p_api_version,
2336: l_api_name,
2337: G_PKG_NAME)
2338: then
2339: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2340: end if;
2341:
2342: --Total cost would be the sum of all the periods
2343: /*For Bug No : 2811698 Start*/

Line 2393: if ((p_service_package_id <> FND_API.G_MISS_NUM) and

2389:
2390:
2391: -- If Service Package is being modified, check whether the target FTE line exists
2392:
2393: if ((p_service_package_id <> FND_API.G_MISS_NUM) and
2394: (p_service_package_id <> l_service_package_id)) then
2395: begin
2396:
2397: for c_Wfl_Rec in c_Wfl_SP (l_position_line_id, l_budget_year_id, p_service_package_id,

Line 2431: l_spfl_exists := FND_API.G_TRUE;

2427: l_spfte(55) := c_Wfl_Rec.period55_fte; l_spfte(56) := c_Wfl_Rec.period56_fte;
2428: l_spfte(57) := c_Wfl_Rec.period57_fte; l_spfte(58) := c_Wfl_Rec.period58_fte;
2429: l_spfte(59) := c_Wfl_Rec.period59_fte; l_spfte(60) := c_Wfl_Rec.period60_fte;
2430:
2431: l_spfl_exists := FND_API.G_TRUE;
2432: end loop;
2433:
2434: l_new_stage := FND_API.G_TRUE;
2435:

Line 2434: l_new_stage := FND_API.G_TRUE;

2430:
2431: l_spfl_exists := FND_API.G_TRUE;
2432: end loop;
2433:
2434: l_new_stage := FND_API.G_TRUE;
2435:
2436: -- Delete target FTE line if it exists since entries for the target FTE line will
2437: -- be added to the current FTE line
2438:

Line 2439: if FND_API.to_Boolean(l_spfl_exists) then

2435:
2436: -- Delete target FTE line if it exists since entries for the target FTE line will
2437: -- be added to the current FTE line
2438:
2439: if FND_API.to_Boolean(l_spfl_exists) then
2440: begin
2441:
2442: l_recalculate_flag := FND_API.G_TRUE;
2443:

Line 2442: l_recalculate_flag := FND_API.G_TRUE;

2438:
2439: if FND_API.to_Boolean(l_spfl_exists) then
2440: begin
2441:
2442: l_recalculate_flag := FND_API.G_TRUE;
2443:
2444: PSB_WORKSHEET.Delete_WFL
2445: (p_api_version => 1.0,
2446: p_return_status => l_return_status,

Line 2449: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2445: (p_api_version => 1.0,
2446: p_return_status => l_return_status,
2447: p_fte_line_id => l_spflid);
2448:
2449: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2450: raise FND_API.G_EXC_ERROR;
2451: end if;
2452:
2453: end;

Line 2450: raise FND_API.G_EXC_ERROR;

2446: p_return_status => l_return_status,
2447: p_fte_line_id => l_spflid);
2448:
2449: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2450: raise FND_API.G_EXC_ERROR;
2451: end if;
2452:
2453: end;
2454: end if;

Line 2463: if nvl(p_period_fte(l_index), FND_API.G_MISS_NUM) <> nvl(l_period_fte(l_index), FND_API.G_MISS_NUM) then

2459: -- Create new Stage if any of the existing Period FTEs are being updated and the Start Stage Seq for
2460: -- the current FTE line is different from the Current Stage Sequence
2461:
2462: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2463: if nvl(p_period_fte(l_index), FND_API.G_MISS_NUM) <> nvl(l_period_fte(l_index), FND_API.G_MISS_NUM) then
2464: l_new_stage := FND_API.G_TRUE;
2465: l_recalculate_flag := FND_API.G_TRUE;
2466: exit;
2467: end if;

Line 2464: l_new_stage := FND_API.G_TRUE;

2460: -- the current FTE line is different from the Current Stage Sequence
2461:
2462: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2463: if nvl(p_period_fte(l_index), FND_API.G_MISS_NUM) <> nvl(l_period_fte(l_index), FND_API.G_MISS_NUM) then
2464: l_new_stage := FND_API.G_TRUE;
2465: l_recalculate_flag := FND_API.G_TRUE;
2466: exit;
2467: end if;
2468:

Line 2465: l_recalculate_flag := FND_API.G_TRUE;

2461:
2462: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2463: if nvl(p_period_fte(l_index), FND_API.G_MISS_NUM) <> nvl(l_period_fte(l_index), FND_API.G_MISS_NUM) then
2464: l_new_stage := FND_API.G_TRUE;
2465: l_recalculate_flag := FND_API.G_TRUE;
2466: exit;
2467: end if;
2468:
2469: end loop;

Line 2471: if ((FND_API.to_Boolean(l_new_stage)) and

2467: end if;
2468:
2469: end loop;
2470:
2471: if ((FND_API.to_Boolean(l_new_stage)) and
2472: (l_start_stage_seq = l_current_stage_seq)) then
2473: l_new_stage := FND_API.G_FALSE;
2474: end if;
2475:

Line 2473: l_new_stage := FND_API.G_FALSE;

2469: end loop;
2470:
2471: if ((FND_API.to_Boolean(l_new_stage)) and
2472: (l_start_stage_seq = l_current_stage_seq)) then
2473: l_new_stage := FND_API.G_FALSE;
2474: end if;
2475:
2476: l_userid := FND_GLOBAL.USER_ID;
2477: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 2479: if ((FND_API.to_Boolean(p_check_stages)) and

2475:
2476: l_userid := FND_GLOBAL.USER_ID;
2477: l_loginid := FND_GLOBAL.LOGIN_ID;
2478:
2479: if ((FND_API.to_Boolean(p_check_stages)) and
2480: (FND_API.to_Boolean(l_new_stage)) and
2481: (l_start_stage_seq < l_current_stage_seq)) then
2482: begin
2483:

Line 2480: (FND_API.to_Boolean(l_new_stage)) and

2476: l_userid := FND_GLOBAL.USER_ID;
2477: l_loginid := FND_GLOBAL.LOGIN_ID;
2478:
2479: if ((FND_API.to_Boolean(p_check_stages)) and
2480: (FND_API.to_Boolean(l_new_stage)) and
2481: (l_start_stage_seq < l_current_stage_seq)) then
2482: begin
2483:
2484: for c_PrevStage_Rec in c_PrevStage loop

Line 2568: raise FND_API.G_EXC_ERROR;

2564: /*
2565: num_wfl := PSB_WS_ACCT1.dsql_execute(sql_wfl);
2566:
2567: if num_wfl < 0 then
2568: raise FND_API.G_EXC_ERROR;
2569: end if;
2570: */
2571:
2572: end;

Line 2583: if FND_API.to_Boolean(l_spfl_exists) then

2579: 'service_package_id, :p_service_package_id2 ), ';
2580:
2581: for l_index in 1..PSB_WS_ACCT1.g_max_num_amounts loop
2582:
2583: if FND_API.to_Boolean(l_spfl_exists) then
2584: l_fte := nvl(p_period_fte(l_index), 0) + nvl(l_spfte(l_index), 0);
2585: else
2586: l_fte := nvl(p_period_fte(l_index), 0);
2587: end if;

Line 2608: if ((FND_API.to_Boolean(p_check_stages)) and

2604: -- If new Stage is created, update the Start and Current Stage Sequences to reflect
2605: -- the new Stage; otherwise, update the Current Stage Sequence if it is being changed
2606: -- from Worksheet Operations
2607:
2608: if ((FND_API.to_Boolean(p_check_stages)) and
2609: (FND_API.to_Boolean(l_new_stage)) and
2610: (l_start_stage_seq < l_current_stage_seq)) then
2611: begin
2612: -- Bug#5030383

Line 2609: (FND_API.to_Boolean(l_new_stage)) and

2605: -- the new Stage; otherwise, update the Current Stage Sequence if it is being changed
2606: -- from Worksheet Operations
2607:
2608: if ((FND_API.to_Boolean(p_check_stages)) and
2609: (FND_API.to_Boolean(l_new_stage)) and
2610: (l_start_stage_seq < l_current_stage_seq)) then
2611: begin
2612: -- Bug#5030383
2613: -- Replaced literals by b_start_stage_seq and :b_current_stage_seq

Line 2621: -- Replaced p_current_stage_seq and FND_API.G_MISS_NUM with bind variables for

2617:
2618: end;
2619: else
2620: begin
2621: -- Replaced p_current_stage_seq and FND_API.G_MISS_NUM with bind variables for
2622: -- bug 3132485
2623: sql_wfl := sql_wfl ||
2624: 'current_stage_seq = decode( :p_current_stage_seq1 , :gmn2 ,'||
2625: 'current_stage_seq, :p_current_stage_seq2 ), ';

Line 2630: if FND_API.to_Boolean(l_recalculate_flag) then

2626:
2627: end;
2628: end if;
2629:
2630: if FND_API.to_Boolean(l_recalculate_flag) then
2631: begin
2632:
2633: for c_WS_Rec in c_WS (p_worksheet_id) loop
2634: l_global_wsid := c_WS_Rec.global_worksheet_id;

Line 2645: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then

2641: for c_BG_Rec in c_BG (l_budget_group_id) loop
2642: l_business_group_id := c_BG_Rec.business_group_id;
2643: end loop;
2644:
2645: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2646: begin
2647:
2648: PSB_WS_ACCT1.Cache_Budget_Calendar
2649: (p_return_status => l_return_status,

Line 2652: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2648: PSB_WS_ACCT1.Cache_Budget_Calendar
2649: (p_return_status => l_return_status,
2650: p_budget_calendar_id => l_budget_calendar_id);
2651:
2652: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2653: raise FND_API.G_EXC_ERROR;
2654: end if;
2655:
2656: end;

Line 2653: raise FND_API.G_EXC_ERROR;

2649: (p_return_status => l_return_status,
2650: p_budget_calendar_id => l_budget_calendar_id);
2651:
2652: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2653: raise FND_API.G_EXC_ERROR;
2654: end if;
2655:
2656: end;
2657: end if;

Line 2693: raise FND_API.G_EXC_ERROR;

2689: /*
2690: num_wfl := PSB_WS_ACCT1.dsql_execute(sql_wfl);
2691:
2692: if num_wfl < 0 then
2693: raise FND_API.G_EXC_ERROR;
2694: end if;
2695: */
2696:
2697: -- start of bug 3353382

Line 2698: if ((FND_API.to_Boolean(p_check_stages)) and

2694: end if;
2695: */
2696:
2697: -- start of bug 3353382
2698: if ((FND_API.to_Boolean(p_check_stages)) and
2699: (FND_API.to_Boolean(l_new_stage)) and
2700: (l_start_stage_seq < l_current_stage_seq)) then
2701:
2702: if FND_API.to_Boolean(l_recalculate_flag) then

Line 2699: (FND_API.to_Boolean(l_new_stage)) and

2695: */
2696:
2697: -- start of bug 3353382
2698: if ((FND_API.to_Boolean(p_check_stages)) and
2699: (FND_API.to_Boolean(l_new_stage)) and
2700: (l_start_stage_seq < l_current_stage_seq)) then
2701:
2702: if FND_API.to_Boolean(l_recalculate_flag) then
2703:

Line 2702: if FND_API.to_Boolean(l_recalculate_flag) then

2698: if ((FND_API.to_Boolean(p_check_stages)) and
2699: (FND_API.to_Boolean(l_new_stage)) and
2700: (l_start_stage_seq < l_current_stage_seq)) then
2701:
2702: if FND_API.to_Boolean(l_recalculate_flag) then
2703:
2704: -- Bug#5030383
2705:
2706: EXECUTE IMMEDIATE sql_wfl USING

Line 2707: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,

2703:
2704: -- Bug#5030383
2705:
2706: EXECUTE IMMEDIATE sql_wfl USING
2707: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,
2708: l_bind_fte(1),l_bind_fte(2),l_bind_fte(3),l_bind_fte(4),
2709: l_bind_fte(5),l_bind_fte(6),l_bind_fte(7),l_bind_fte(8),
2710: l_bind_fte(9),l_bind_fte(10),l_bind_fte(11),l_bind_fte(12),
2711: l_bind_fte(13),l_bind_fte(14),l_bind_fte(15),l_bind_fte(16),

Line 2730: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,

2726: else
2727: -- Bug#5030383
2728:
2729: EXECUTE IMMEDIATE sql_wfl USING
2730: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,
2731: l_bind_fte(1),l_bind_fte(2),l_bind_fte(3),l_bind_fte(4),
2732: l_bind_fte(5),l_bind_fte(6),l_bind_fte(7),l_bind_fte(8),
2733: l_bind_fte(9),l_bind_fte(10),l_bind_fte(11),l_bind_fte(12),
2734: l_bind_fte(13),l_bind_fte(14),l_bind_fte(15),l_bind_fte(16),

Line 2752: if FND_API.to_Boolean(l_recalculate_flag) then

2748:
2749: end if;
2750: else
2751:
2752: if FND_API.to_Boolean(l_recalculate_flag) then
2753: -- Bug#5030383
2754:
2755: EXECUTE IMMEDIATE sql_wfl USING
2756: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,

Line 2756: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,

2752: if FND_API.to_Boolean(l_recalculate_flag) then
2753: -- Bug#5030383
2754:
2755: EXECUTE IMMEDIATE sql_wfl USING
2756: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,
2757: l_bind_fte(1),l_bind_fte(2),l_bind_fte(3),l_bind_fte(4),
2758: l_bind_fte(5),l_bind_fte(6),l_bind_fte(7),l_bind_fte(8),
2759: l_bind_fte(9),l_bind_fte(10),l_bind_fte(11),l_bind_fte(12),
2760: l_bind_fte(13),l_bind_fte(14),l_bind_fte(15),l_bind_fte(16),

Line 2772: p_current_stage_seq,FND_API.G_MISS_NUM,p_current_stage_seq,

2768: l_bind_fte(45),l_bind_fte(46),l_bind_fte(47),l_bind_fte(48),
2769: l_bind_fte(49),l_bind_fte(50),l_bind_fte(51),l_bind_fte(52),
2770: l_bind_fte(53),l_bind_fte(54),l_bind_fte(55),l_bind_fte(56),
2771: l_bind_fte(57),l_bind_fte(58),l_bind_fte(59),l_bind_fte(60),
2772: p_current_stage_seq,FND_API.G_MISS_NUM,p_current_stage_seq,
2773: l_new_annual_fte, SYSDATE, l_userid, l_loginid, p_fte_line_id ;
2774:
2775: else
2776: -- Bug#5030383

Line 2779: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,

2775: else
2776: -- Bug#5030383
2777:
2778: EXECUTE IMMEDIATE sql_wfl USING
2779: p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,
2780: l_bind_fte(1),l_bind_fte(2),l_bind_fte(3),l_bind_fte(4),
2781: l_bind_fte(5),l_bind_fte(6),l_bind_fte(7),l_bind_fte(8),
2782: l_bind_fte(9),l_bind_fte(10),l_bind_fte(11),l_bind_fte(12),
2783: l_bind_fte(13),l_bind_fte(14),l_bind_fte(15),l_bind_fte(16),

Line 2795: p_current_stage_seq,FND_API.G_MISS_NUM,p_current_stage_seq,

2791: l_bind_fte(45),l_bind_fte(46),l_bind_fte(47),l_bind_fte(48),
2792: l_bind_fte(49),l_bind_fte(50),l_bind_fte(51),l_bind_fte(52),
2793: l_bind_fte(53),l_bind_fte(54),l_bind_fte(55),l_bind_fte(56),
2794: l_bind_fte(57),l_bind_fte(58),l_bind_fte(59),l_bind_fte(60),
2795: p_current_stage_seq,FND_API.G_MISS_NUM,p_current_stage_seq,
2796: SYSDATE, l_userid, l_loginid, p_fte_line_id ;
2797:
2798: end if;
2799:

Line 2803: --p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,

2799:
2800: end if;
2801:
2802: --EXECUTE IMMEDIATE sql_wfl USING
2803: --p_service_package_id,FND_API.G_MISS_NUM,p_service_package_id,
2804: --l_bind_fte(1),l_bind_fte(2),l_bind_fte(3),l_bind_fte(4),
2805: --l_bind_fte(5),l_bind_fte(6),l_bind_fte(7),l_bind_fte(8),
2806: --l_bind_fte(9),l_bind_fte(10),l_bind_fte(11),l_bind_fte(12),
2807: --l_bind_fte(13),l_bind_fte(14),l_bind_fte(15),l_bind_fte(16),

Line 2819: --p_current_stage_seq,FND_API.G_MISS_NUM,p_current_stage_seq,

2815: --l_bind_fte(45),l_bind_fte(46),l_bind_fte(47),l_bind_fte(48),
2816: --l_bind_fte(49),l_bind_fte(50),l_bind_fte(51),l_bind_fte(52),
2817: --l_bind_fte(53),l_bind_fte(54),l_bind_fte(55),l_bind_fte(56),
2818: --l_bind_fte(57),l_bind_fte(58),l_bind_fte(59),l_bind_fte(60),
2819: --p_current_stage_seq,FND_API.G_MISS_NUM,p_current_stage_seq,
2820: --l_new_annual_fte;
2821:
2822: -- end of bug 3353382
2823:

Line 2824: if FND_API.to_Boolean(l_recalculate_flag) then

2820: --l_new_annual_fte;
2821:
2822: -- end of bug 3353382
2823:
2824: if FND_API.to_Boolean(l_recalculate_flag) then
2825: begin
2826:
2827: if ((p_service_package_id <> FND_API.G_MISS_NUM) and
2828: (p_service_package_id <> l_service_package_id)) then

Line 2827: if ((p_service_package_id <> FND_API.G_MISS_NUM) and

2823:
2824: if FND_API.to_Boolean(l_recalculate_flag) then
2825: begin
2826:
2827: if ((p_service_package_id <> FND_API.G_MISS_NUM) and
2828: (p_service_package_id <> l_service_package_id)) then
2829: l_service_package_id := p_service_package_id;
2830: end if;
2831:

Line 2860: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2856: p_num_budget_periods => l_num_budget_periods
2857: /*For Bug No : 2811698 End*/
2858: );
2859:
2860: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2861: raise FND_API.G_EXC_ERROR;
2862: end if;
2863:
2864: end loop;

Line 2861: raise FND_API.G_EXC_ERROR;

2857: /*For Bug No : 2811698 End*/
2858: );
2859:
2860: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2861: raise FND_API.G_EXC_ERROR;
2862: end if;
2863:
2864: end loop;
2865:

Line 2879: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2875: p_stage_set_id => l_stage_set_id,
2876: p_current_stage_seq => l_current_stage_seq,
2877: p_budget_group_id => p_budget_group_id);
2878:
2879: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2880: raise FND_API.G_EXC_ERROR;
2881: end if;
2882:
2883: end;

Line 2880: raise FND_API.G_EXC_ERROR;

2876: p_current_stage_seq => l_current_stage_seq,
2877: p_budget_group_id => p_budget_group_id);
2878:
2879: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2880: raise FND_API.G_EXC_ERROR;
2881: end if;
2882:
2883: end;
2884: end if;

Line 2889: p_return_status := FND_API.G_RET_STS_SUCCESS;

2885:
2886:
2887: -- Initialize API return status to success
2888:
2889: p_return_status := FND_API.G_RET_STS_SUCCESS;
2890:
2891:
2892: EXCEPTION
2893: when FND_API.G_EXC_ERROR then

Line 2893: when FND_API.G_EXC_ERROR then

2889: p_return_status := FND_API.G_RET_STS_SUCCESS;
2890:
2891:
2892: EXCEPTION
2893: when FND_API.G_EXC_ERROR then
2894: p_return_status := FND_API.G_RET_STS_ERROR;
2895: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2896: p_data => l_msg_data);
2897:

Line 2894: p_return_status := FND_API.G_RET_STS_ERROR;

2890:
2891:
2892: EXCEPTION
2893: when FND_API.G_EXC_ERROR then
2894: p_return_status := FND_API.G_RET_STS_ERROR;
2895: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2896: p_data => l_msg_data);
2897:
2898:

Line 2899: when FND_API.G_EXC_UNEXPECTED_ERROR then

2895: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2896: p_data => l_msg_data);
2897:
2898:
2899: when FND_API.G_EXC_UNEXPECTED_ERROR then
2900: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2901: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2902: p_data => l_msg_data);
2903:

Line 2900: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2896: p_data => l_msg_data);
2897:
2898:
2899: when FND_API.G_EXC_UNEXPECTED_ERROR then
2900: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2901: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2902: p_data => l_msg_data);
2903:
2904: when OTHERS then

Line 2905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2901: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
2902: p_data => l_msg_data);
2903:
2904: when OTHERS then
2905: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2906:
2907: if FND_MSG_PUB.Check_Msg_Level
2908: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2909: then

Line 2927: p_insert_from_base IN VARCHAR2 := FND_API.G_FALSE,

2923: -- using the pre-computed Period FTE Ratios and the Annual FTE Ratio
2924:
2925: PROCEDURE Distribute_Position_Cost
2926: ( p_return_status OUT NOCOPY VARCHAR2,
2927: p_insert_from_base IN VARCHAR2 := FND_API.G_FALSE,
2928: p_update_from_base IN VARCHAR2 := FND_API.G_FALSE,
2929: p_worksheet_id IN NUMBER,
2930: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
2931: p_rounding_factor IN NUMBER,

Line 2928: p_update_from_base IN VARCHAR2 := FND_API.G_FALSE,

2924:
2925: PROCEDURE Distribute_Position_Cost
2926: ( p_return_status OUT NOCOPY VARCHAR2,
2927: p_insert_from_base IN VARCHAR2 := FND_API.G_FALSE,
2928: p_update_from_base IN VARCHAR2 := FND_API.G_FALSE,
2929: p_worksheet_id IN NUMBER,
2930: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
2931: p_rounding_factor IN NUMBER,
2932: p_position_line_id IN NUMBER,

Line 2930: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

2926: ( p_return_status OUT NOCOPY VARCHAR2,
2927: p_insert_from_base IN VARCHAR2 := FND_API.G_FALSE,
2928: p_update_from_base IN VARCHAR2 := FND_API.G_FALSE,
2929: p_worksheet_id IN NUMBER,
2930: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
2931: p_rounding_factor IN NUMBER,
2932: p_position_line_id IN NUMBER,
2933: p_pay_element_id IN NUMBER,
2934: p_budget_year_id IN NUMBER,

Line 2935: p_base_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

2931: p_rounding_factor IN NUMBER,
2932: p_position_line_id IN NUMBER,
2933: p_pay_element_id IN NUMBER,
2934: p_budget_year_id IN NUMBER,
2935: p_base_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
2936: p_service_package_id IN NUMBER,
2937: p_stage_set_id IN NUMBER,
2938: p_start_stage_seq IN NUMBER,
2939: p_current_stage_seq IN NUMBER,

Line 3187: if FND_API.to_Boolean(p_insert_from_base) then

3183: /* Bug 4379636 End */
3184:
3185: l_rounding_diff := 0;
3186:
3187: if FND_API.to_Boolean(p_insert_from_base) then
3188: begin
3189:
3190: for c_Element_Dist_Rec in c_Base_Element_Dist loop
3191:

Line 3262: l_salary_account_line := FND_API.G_FALSE;

3258: l_annual_fte := p_total_fte / p_num_budget_periods;
3259: /*For Bug No : 2811698 End*/
3260:
3261: if c_Element_Dist_Rec.salary_account_line is null then
3262: l_salary_account_line := FND_API.G_FALSE;
3263: else
3264: l_salary_account_line := FND_API.G_TRUE;
3265: end if;
3266:

Line 3264: l_salary_account_line := FND_API.G_TRUE;

3260:
3261: if c_Element_Dist_Rec.salary_account_line is null then
3262: l_salary_account_line := FND_API.G_FALSE;
3263: else
3264: l_salary_account_line := FND_API.G_TRUE;
3265: end if;
3266:
3267: PSB_WS_ACCT1.Create_Account_Dist
3268: (p_api_version => 1.0,

Line 3274: p_check_spal_exists => FND_API.G_FALSE,

3270: p_account_line_id => l_account_line_id,
3271: p_worksheet_id => p_worksheet_id,
3272: p_flex_mapping_set_id => p_flex_mapping_set_id,
3273: p_map_accounts => TRUE,
3274: p_check_spal_exists => FND_API.G_FALSE,
3275: p_gl_cutoff_period => null,
3276: p_allocrule_set_id => null,
3277: p_budget_calendar_id => null,
3278: p_rounding_factor => p_rounding_factor,

Line 3298: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3294: p_service_package_id => p_service_package_id,
3295: p_start_stage_seq => p_start_stage_seq,
3296: p_current_stage_seq => p_current_stage_seq);
3297:
3298: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3299: raise FND_API.G_EXC_ERROR;
3300: end if;
3301:
3302: end loop;

Line 3299: raise FND_API.G_EXC_ERROR;

3295: p_start_stage_seq => p_start_stage_seq,
3296: p_current_stage_seq => p_current_stage_seq);
3297:
3298: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3299: raise FND_API.G_EXC_ERROR;
3300: end if;
3301:
3302: end loop;
3303:

Line 3310: p_check_spel_exists => FND_API.G_FALSE,

3306: Create_Element_Lines
3307: (p_api_version => 1.0,
3308: p_return_status => l_return_status,
3309: p_element_line_id => l_element_line_id,
3310: p_check_spel_exists => FND_API.G_FALSE,
3311: p_position_line_id => p_position_line_id,
3312: p_budget_year_id => p_budget_year_id,
3313: p_pay_element_id => p_pay_element_id,
3314: p_currency_code => c_Element_Cost_Rec.currency_code,

Line 3325: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3321: p_stage_set_id => p_stage_set_id,
3322: p_start_stage_seq => p_start_stage_seq,
3323: p_current_stage_seq => p_current_stage_seq);
3324:
3325: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3326: raise FND_API.G_EXC_ERROR;
3327: end if;
3328:
3329: end loop;

Line 3326: raise FND_API.G_EXC_ERROR;

3322: p_start_stage_seq => p_start_stage_seq,
3323: p_current_stage_seq => p_current_stage_seq);
3324:
3325: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3326: raise FND_API.G_EXC_ERROR;
3327: end if;
3328:
3329: end loop;
3330:

Line 3365: if FND_API.to_Boolean(p_update_from_base) then

3361: END LOOP;
3362: END IF;
3363: /* Bug 4379636 End */
3364:
3365: if FND_API.to_Boolean(p_update_from_base) then
3366: begin
3367:
3368: for c_Base_Element_Dist_Rec in c_Base_Element_Dist loop
3369:

Line 3490: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3486: p_service_package_id => p_service_package_id,
3487: p_current_stage_seq => p_current_stage_seq,
3488: p_budget_group_id => p_budget_group_id);
3489:
3490: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3491: raise FND_API.G_EXC_ERROR;
3492: end if;
3493:
3494: -- For Bug No. 2250319

Line 3491: raise FND_API.G_EXC_ERROR;

3487: p_current_stage_seq => p_current_stage_seq,
3488: p_budget_group_id => p_budget_group_id);
3489:
3490: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3491: raise FND_API.G_EXC_ERROR;
3492: end if;
3493:
3494: -- For Bug No. 2250319
3495: END IF;

Line 3519: if FND_API.to_Boolean(p_update_from_base) then

3515: end loop;
3516:
3517: for c_Element_Cost_Rec in c_Element_Cost loop
3518:
3519: if FND_API.to_Boolean(p_update_from_base) then
3520: begin
3521: for c_Base_Element_Cost_Rec in c_Base_Element_Cost loop
3522: l_element_cost := c_Base_Element_Cost_Rec.element_cost * nvl(l_annual_fte_ratio, 0) + l_rounding_diff;
3523: end loop;

Line 3537: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3533: p_element_cost => l_element_cost,
3534: p_service_package_id => p_service_package_id,
3535: p_current_stage_seq => p_current_stage_seq);
3536:
3537: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3538: raise FND_API.G_EXC_ERROR;
3539: end if;
3540:
3541: end loop;

Line 3538: raise FND_API.G_EXC_ERROR;

3534: p_service_package_id => p_service_package_id,
3535: p_current_stage_seq => p_current_stage_seq);
3536:
3537: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3538: raise FND_API.G_EXC_ERROR;
3539: end if;
3540:
3541: end loop;
3542:

Line 3549: p_return_status := FND_API.G_RET_STS_SUCCESS;

3545:
3546:
3547: -- Initialize API return status to success
3548:
3549: p_return_status := FND_API.G_RET_STS_SUCCESS;
3550:
3551:
3552: EXCEPTION
3553: when FND_API.G_EXC_ERROR then

Line 3553: when FND_API.G_EXC_ERROR then

3549: p_return_status := FND_API.G_RET_STS_SUCCESS;
3550:
3551:
3552: EXCEPTION
3553: when FND_API.G_EXC_ERROR then
3554: p_return_status := FND_API.G_RET_STS_ERROR;
3555: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3556: p_data => l_msg_data);
3557:

Line 3554: p_return_status := FND_API.G_RET_STS_ERROR;

3550:
3551:
3552: EXCEPTION
3553: when FND_API.G_EXC_ERROR then
3554: p_return_status := FND_API.G_RET_STS_ERROR;
3555: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3556: p_data => l_msg_data);
3557:
3558:

Line 3559: when FND_API.G_EXC_UNEXPECTED_ERROR then

3555: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3556: p_data => l_msg_data);
3557:
3558:
3559: when FND_API.G_EXC_UNEXPECTED_ERROR then
3560: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3561: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3562: p_data => l_msg_data);
3563:

Line 3560: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3556: p_data => l_msg_data);
3557:
3558:
3559: when FND_API.G_EXC_UNEXPECTED_ERROR then
3560: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3561: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3562: p_data => l_msg_data);
3563:
3564: when OTHERS then

Line 3565: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3561: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3562: p_data => l_msg_data);
3563:
3564: when OTHERS then
3565: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3566:
3567: if FND_MSG_PUB.Check_Msg_Level
3568: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3569: then

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

3583: -- the element_line_id identifier is not known
3584:
3585: PROCEDURE Create_Element_Lines
3586: ( p_api_version IN NUMBER,
3587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
3588: p_return_status OUT NOCOPY VARCHAR2,
3589: p_element_line_id OUT NOCOPY NUMBER,
3590: p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,
3591: p_position_line_id IN NUMBER,

Line 3590: p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,

3586: ( p_api_version IN NUMBER,
3587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
3588: p_return_status OUT NOCOPY VARCHAR2,
3589: p_element_line_id OUT NOCOPY NUMBER,
3590: p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,
3591: p_position_line_id IN NUMBER,
3592: p_budget_year_id IN NUMBER,
3593: p_pay_element_id IN NUMBER,
3594: p_currency_code IN VARCHAR2,

Line 3599: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

3595: p_element_cost IN NUMBER,
3596: p_element_set_id IN NUMBER,
3597: p_service_package_id IN NUMBER,
3598: p_stage_set_id IN NUMBER,
3599: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
3600: p_current_stage_seq IN NUMBER,
3601: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
3602: p_functional_transaction IN VARCHAR2 := NULL
3603: ) IS

Line 3601: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

3597: p_service_package_id IN NUMBER,
3598: p_stage_set_id IN NUMBER,
3599: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
3600: p_current_stage_seq IN NUMBER,
3601: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
3602: p_functional_transaction IN VARCHAR2 := NULL
3603: ) IS
3604:
3605: l_api_name CONSTANT VARCHAR2(30) := 'Create_Element_Lines';

Line 3616: l_spel_exists VARCHAR2(1) := FND_API.G_FALSE;

3612: l_start_stage_seq NUMBER;
3613: l_set_of_books_id NUMBER;
3614: l_spelid NUMBER;
3615: l_spelcost NUMBER;
3616: l_spel_exists VARCHAR2(1) := FND_API.G_FALSE;
3617:
3618: l_return_status VARCHAR2(1);
3619: l_msg_data VARCHAR2(2000);
3620: l_msg_count NUMBER;

Line 3641: if not FND_API.Compatible_API_Call (l_api_version,

3637: BEGIN
3638:
3639: -- Standard call to check for call compatibility
3640:
3641: if not FND_API.Compatible_API_Call (l_api_version,
3642: p_api_version,
3643: l_api_name,
3644: G_PKG_NAME)
3645: then

Line 3646: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3642: p_api_version,
3643: l_api_name,
3644: G_PKG_NAME)
3645: then
3646: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3647: end if;
3648:
3649: l_userid := FND_GLOBAL.USER_ID;
3650: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 3652: if p_start_stage_seq = FND_API.G_MISS_NUM then

3648:
3649: l_userid := FND_GLOBAL.USER_ID;
3650: l_loginid := FND_GLOBAL.LOGIN_ID;
3651:
3652: if p_start_stage_seq = FND_API.G_MISS_NUM then
3653: l_start_stage_seq := p_current_stage_seq;
3654: else
3655: l_start_stage_seq := p_start_stage_seq;
3656: end if;

Line 3658: if FND_API.to_Boolean(p_check_spel_exists) then

3654: else
3655: l_start_stage_seq := p_start_stage_seq;
3656: end if;
3657:
3658: if FND_API.to_Boolean(p_check_spel_exists) then
3659: begin
3660:
3661: for c_Wel_Rec in c_Wel_SP loop
3662: l_spelid := c_Wel_Rec.element_line_id;

Line 3665: l_spel_exists := FND_API.G_TRUE;

3661: for c_Wel_Rec in c_Wel_SP loop
3662: l_spelid := c_Wel_Rec.element_line_id;
3663: l_spelcost := c_Wel_Rec.element_cost;
3664:
3665: l_spel_exists := FND_API.G_TRUE;
3666: end loop;
3667:
3668: end;
3669: end if;

Line 3671: if FND_API.to_Boolean(l_spel_exists) then

3667:
3668: end;
3669: end if;
3670:
3671: if FND_API.to_Boolean(l_spel_exists) then
3672: begin
3673:
3674: update PSB_WS_ELEMENT_LINES
3675: set element_cost = nvl(p_element_cost, 0),

Line 3678: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),

3674: update PSB_WS_ELEMENT_LINES
3675: set element_cost = nvl(p_element_cost, 0),
3676: element_set_id = p_element_set_id,
3677: current_stage_seq = p_current_stage_seq,
3678: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
3679: last_update_date = sysdate,
3680: last_updated_by = l_userid,
3681: last_update_login = l_loginid
3682: where element_line_id = l_spelid;

Line 3692: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),

3688: update PSB_WS_ELEMENT_LINES a
3689: set element_cost = nvl(p_element_cost, 0),
3690: element_set_id = p_element_set_id,
3691: current_stage_seq = p_current_stage_seq,
3692: end_stage_seq = decode(p_end_stage_seq, FND_API.G_MISS_NUM, end_stage_seq, p_end_stage_seq),
3693: last_update_date = sysdate,
3694: last_updated_by = l_userid,
3695: last_update_login = l_loginid
3696: where start_stage_seq = p_start_stage_seq

Line 3744: decode(p_end_stage_seq, FND_API.G_MISS_NUM, null, p_end_stage_seq),

3740: p_service_package_id,
3741: p_stage_set_id,
3742: l_start_stage_seq,
3743: p_current_stage_seq,
3744: decode(p_end_stage_seq, FND_API.G_MISS_NUM, null, p_end_stage_seq),
3745: sysdate,
3746: l_userid,
3747: l_loginid,
3748: l_userid,

Line 3759: p_return_status := FND_API.G_RET_STS_SUCCESS;

3755: end if;
3756:
3757: -- Initialize API return status to success
3758:
3759: p_return_status := FND_API.G_RET_STS_SUCCESS;
3760:
3761:
3762: EXCEPTION
3763:

Line 3764: when FND_API.G_EXC_ERROR then

3760:
3761:
3762: EXCEPTION
3763:
3764: when FND_API.G_EXC_ERROR then
3765: p_return_status := FND_API.G_RET_STS_ERROR;
3766: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3767: p_data => l_msg_data);
3768:

Line 3765: p_return_status := FND_API.G_RET_STS_ERROR;

3761:
3762: EXCEPTION
3763:
3764: when FND_API.G_EXC_ERROR then
3765: p_return_status := FND_API.G_RET_STS_ERROR;
3766: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3767: p_data => l_msg_data);
3768:
3769:

Line 3770: when FND_API.G_EXC_UNEXPECTED_ERROR then

3766: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3767: p_data => l_msg_data);
3768:
3769:
3770: when FND_API.G_EXC_UNEXPECTED_ERROR then
3771: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3772: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3773: p_data => l_msg_data);
3774:

Line 3771: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3767: p_data => l_msg_data);
3768:
3769:
3770: when FND_API.G_EXC_UNEXPECTED_ERROR then
3771: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3772: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3773: p_data => l_msg_data);
3774:
3775: when OTHERS then

Line 3776: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3772: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
3773: p_data => l_msg_data);
3774:
3775: when OTHERS then
3776: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3777:
3778: if FND_MSG_PUB.Check_Msg_Level
3779: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3780: then

Line 3794: -- required and the flag p_check_stages is set to FND_API.G_TRUE

3790:
3791: /* ----------------------------------------------------------------------- */
3792:
3793: -- Update existing Position Element Cost line and create new Stages if
3794: -- required and the flag p_check_stages is set to FND_API.G_TRUE
3795:
3796: PROCEDURE Create_Element_Lines
3797: ( p_api_version IN NUMBER,
3798: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

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

3794: -- required and the flag p_check_stages is set to FND_API.G_TRUE
3795:
3796: PROCEDURE Create_Element_Lines
3797: ( p_api_version IN NUMBER,
3798: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
3799: p_return_status OUT NOCOPY VARCHAR2,
3800: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
3801: p_element_line_id IN NUMBER,
3802: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

Line 3800: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

3796: PROCEDURE Create_Element_Lines
3797: ( p_api_version IN NUMBER,
3798: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
3799: p_return_status OUT NOCOPY VARCHAR2,
3800: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
3801: p_element_line_id IN NUMBER,
3802: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
3803: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
3804: p_element_cost IN NUMBER := FND_API.G_MISS_NUM

Line 3802: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

3798: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
3799: p_return_status OUT NOCOPY VARCHAR2,
3800: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
3801: p_element_line_id IN NUMBER,
3802: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
3803: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
3804: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
3805: ) IS
3806:

Line 3803: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

3799: p_return_status OUT NOCOPY VARCHAR2,
3800: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
3801: p_element_line_id IN NUMBER,
3802: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
3803: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
3804: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
3805: ) IS
3806:
3807: l_api_name CONSTANT VARCHAR2(30) := 'Create_Element_Lines';

Line 3804: p_element_cost IN NUMBER := FND_API.G_MISS_NUM

3800: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
3801: p_element_line_id IN NUMBER,
3802: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
3803: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
3804: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
3805: ) IS
3806:
3807: l_api_name CONSTANT VARCHAR2(30) := 'Create_Element_Lines';
3808: l_api_version CONSTANT NUMBER := 1.0;

Line 3810: l_new_stage VARCHAR2(1) := FND_API.G_FALSE;

3806:
3807: l_api_name CONSTANT VARCHAR2(30) := 'Create_Element_Lines';
3808: l_api_version CONSTANT NUMBER := 1.0;
3809:
3810: l_new_stage VARCHAR2(1) := FND_API.G_FALSE;
3811:
3812: l_previous_stage_seq NUMBER;
3813:
3814: l_userid NUMBER;

Line 3831: l_spel_exists VARCHAR2(1) := FND_API.G_FALSE;

3827: l_end_stage_seq NUMBER;
3828:
3829: l_spelid NUMBER;
3830: l_spelcost NUMBER;
3831: l_spel_exists VARCHAR2(1) := FND_API.G_FALSE;
3832:
3833: sql_wel VARCHAR2(6000);
3834: num_wel INTEGER;
3835:

Line 3857: if not FND_API.Compatible_API_Call (l_api_version,

3853: BEGIN
3854:
3855: -- Standard call to check for call compatibility
3856:
3857: if not FND_API.Compatible_API_Call (l_api_version,
3858: p_api_version,
3859: l_api_name,
3860: G_PKG_NAME)
3861: then

Line 3862: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3858: p_api_version,
3859: l_api_name,
3860: G_PKG_NAME)
3861: then
3862: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3863: end if;
3864:
3865: sql_wel := 'select position_line_id, budget_year_id, pay_element_id, currency_code, element_cost, ' ||
3866: 'element_set_id, service_package_id, stage_set_id, start_stage_seq, current_stage_seq, ' ||

Line 3878: if ((p_service_package_id <> FND_API.G_MISS_NUM) and

3874: using p_element_line_id;
3875:
3876: -- If Service Package is being modified, check whether the target element line exists
3877:
3878: if ((p_service_package_id <> FND_API.G_MISS_NUM) and
3879: (p_service_package_id <> l_service_package_id)) then
3880: begin
3881:
3882: sql_wel := 'select ' ||

Line 3899: l_spel_exists := FND_API.G_TRUE;

3895: l_spelid, l_spelcost
3896: using l_current_stage_seq, l_pay_element_id, l_stage_set_id, p_service_package_id, l_budget_year_id,
3897: l_position_line_id;
3898:
3899: l_spel_exists := FND_API.G_TRUE;
3900:
3901: exception
3902: when others then
3903: l_spel_exists := FND_API.G_FALSE;

Line 3903: l_spel_exists := FND_API.G_FALSE;

3899: l_spel_exists := FND_API.G_TRUE;
3900:
3901: exception
3902: when others then
3903: l_spel_exists := FND_API.G_FALSE;
3904: end;
3905:
3906: l_new_stage := FND_API.G_TRUE;
3907:

Line 3906: l_new_stage := FND_API.G_TRUE;

3902: when others then
3903: l_spel_exists := FND_API.G_FALSE;
3904: end;
3905:
3906: l_new_stage := FND_API.G_TRUE;
3907:
3908: if FND_API.to_Boolean(l_spel_exists) then
3909: begin
3910:

Line 3908: if FND_API.to_Boolean(l_spel_exists) then

3904: end;
3905:
3906: l_new_stage := FND_API.G_TRUE;
3907:
3908: if FND_API.to_Boolean(l_spel_exists) then
3909: begin
3910:
3911: PSB_WORKSHEET.Delete_WEL
3912: (p_api_version => 1.0,

Line 3916: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

3912: (p_api_version => 1.0,
3913: p_return_status => l_return_status,
3914: p_element_line_id => l_spelid);
3915:
3916: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3917: raise FND_API.G_EXC_ERROR;
3918: end if;
3919:
3920: end;

Line 3917: raise FND_API.G_EXC_ERROR;

3913: p_return_status => l_return_status,
3914: p_element_line_id => l_spelid);
3915:
3916: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3917: raise FND_API.G_EXC_ERROR;
3918: end if;
3919:
3920: end;
3921: end if;

Line 3926: if ((p_element_cost <> FND_API.G_MISS_NUM) and

3922:
3923: end;
3924: end if;
3925:
3926: if ((p_element_cost <> FND_API.G_MISS_NUM) and
3927: (p_element_cost <> l_element_cost)) then
3928: l_new_stage := FND_API.G_TRUE;
3929: end if;
3930:

Line 3928: l_new_stage := FND_API.G_TRUE;

3924: end if;
3925:
3926: if ((p_element_cost <> FND_API.G_MISS_NUM) and
3927: (p_element_cost <> l_element_cost)) then
3928: l_new_stage := FND_API.G_TRUE;
3929: end if;
3930:
3931: if ((FND_API.to_Boolean(l_new_stage)) and
3932: (l_start_stage_seq = l_current_stage_seq)) then

Line 3931: if ((FND_API.to_Boolean(l_new_stage)) and

3927: (p_element_cost <> l_element_cost)) then
3928: l_new_stage := FND_API.G_TRUE;
3929: end if;
3930:
3931: if ((FND_API.to_Boolean(l_new_stage)) and
3932: (l_start_stage_seq = l_current_stage_seq)) then
3933: l_new_stage := FND_API.G_FALSE;
3934: end if;
3935:

Line 3933: l_new_stage := FND_API.G_FALSE;

3929: end if;
3930:
3931: if ((FND_API.to_Boolean(l_new_stage)) and
3932: (l_start_stage_seq = l_current_stage_seq)) then
3933: l_new_stage := FND_API.G_FALSE;
3934: end if;
3935:
3936: l_userid := FND_GLOBAL.USER_ID;
3937: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 3939: if ((FND_API.to_Boolean(p_check_stages)) and

3935:
3936: l_userid := FND_GLOBAL.USER_ID;
3937: l_loginid := FND_GLOBAL.LOGIN_ID;
3938:
3939: if ((FND_API.to_Boolean(p_check_stages)) and
3940: (FND_API.to_Boolean(l_new_stage)) and
3941: (l_start_stage_seq < l_current_stage_seq)) then
3942: begin
3943:

Line 3940: (FND_API.to_Boolean(l_new_stage)) and

3936: l_userid := FND_GLOBAL.USER_ID;
3937: l_loginid := FND_GLOBAL.LOGIN_ID;
3938:
3939: if ((FND_API.to_Boolean(p_check_stages)) and
3940: (FND_API.to_Boolean(l_new_stage)) and
3941: (l_start_stage_seq < l_current_stage_seq)) then
3942: begin
3943:
3944: for c_PrevStage_Rec in c_PrevStage loop

Line 4015: raise FND_API.G_EXC_ERROR;

4011: , SYSDATE
4012: , p_element_line_id ;
4013:
4014: /* if num_wel < 0 then
4015: raise FND_API.G_EXC_ERROR;
4016: end if; */
4017:
4018: update PSB_WS_ELEMENT_LINES
4019: set element_cost = decode(p_element_cost, FND_API.G_MISS_NUM, element_cost, null, 0, p_element_cost),

Line 4019: set element_cost = decode(p_element_cost, FND_API.G_MISS_NUM, element_cost, null, 0, p_element_cost),

4015: raise FND_API.G_EXC_ERROR;
4016: end if; */
4017:
4018: update PSB_WS_ELEMENT_LINES
4019: set element_cost = decode(p_element_cost, FND_API.G_MISS_NUM, element_cost, null, 0, p_element_cost),
4020: service_package_id = decode(p_service_package_id, FND_API.G_MISS_NUM, service_package_id, p_service_package_id),
4021: start_stage_seq = l_current_stage_seq,
4022: current_stage_seq = l_current_stage_seq,
4023: last_update_date = sysdate,

Line 4020: service_package_id = decode(p_service_package_id, FND_API.G_MISS_NUM, service_package_id, p_service_package_id),

4016: end if; */
4017:
4018: update PSB_WS_ELEMENT_LINES
4019: set element_cost = decode(p_element_cost, FND_API.G_MISS_NUM, element_cost, null, 0, p_element_cost),
4020: service_package_id = decode(p_service_package_id, FND_API.G_MISS_NUM, service_package_id, p_service_package_id),
4021: start_stage_seq = l_current_stage_seq,
4022: current_stage_seq = l_current_stage_seq,
4023: last_update_date = sysdate,
4024: last_updated_by = l_userid,

Line 4033: set element_cost = decode(p_element_cost, FND_API.G_MISS_NUM, element_cost, null, 0, p_element_cost),

4029: else
4030: begin
4031:
4032: update PSB_WS_ELEMENT_LINES
4033: set element_cost = decode(p_element_cost, FND_API.G_MISS_NUM, element_cost, null, 0, p_element_cost),
4034: service_package_id = decode(p_service_package_id, FND_API.G_MISS_NUM, service_package_id, p_service_package_id),
4035: current_stage_seq = decode(p_current_stage_seq, FND_API.G_MISS_NUM, current_stage_seq, p_current_stage_seq),
4036: last_update_date = sysdate,
4037: last_updated_by = l_userid,

Line 4034: service_package_id = decode(p_service_package_id, FND_API.G_MISS_NUM, service_package_id, p_service_package_id),

4030: begin
4031:
4032: update PSB_WS_ELEMENT_LINES
4033: set element_cost = decode(p_element_cost, FND_API.G_MISS_NUM, element_cost, null, 0, p_element_cost),
4034: service_package_id = decode(p_service_package_id, FND_API.G_MISS_NUM, service_package_id, p_service_package_id),
4035: current_stage_seq = decode(p_current_stage_seq, FND_API.G_MISS_NUM, current_stage_seq, p_current_stage_seq),
4036: last_update_date = sysdate,
4037: last_updated_by = l_userid,
4038: last_update_login = l_loginid

Line 4035: current_stage_seq = decode(p_current_stage_seq, FND_API.G_MISS_NUM, current_stage_seq, p_current_stage_seq),

4031:
4032: update PSB_WS_ELEMENT_LINES
4033: set element_cost = decode(p_element_cost, FND_API.G_MISS_NUM, element_cost, null, 0, p_element_cost),
4034: service_package_id = decode(p_service_package_id, FND_API.G_MISS_NUM, service_package_id, p_service_package_id),
4035: current_stage_seq = decode(p_current_stage_seq, FND_API.G_MISS_NUM, current_stage_seq, p_current_stage_seq),
4036: last_update_date = sysdate,
4037: last_updated_by = l_userid,
4038: last_update_login = l_loginid
4039: where element_line_id = p_element_line_id;

Line 4046: p_return_status := FND_API.G_RET_STS_SUCCESS;

4042: end if;
4043:
4044: -- Initialize API return status to success
4045:
4046: p_return_status := FND_API.G_RET_STS_SUCCESS;
4047:
4048:
4049: EXCEPTION
4050:

Line 4051: when FND_API.G_EXC_ERROR then

4047:
4048:
4049: EXCEPTION
4050:
4051: when FND_API.G_EXC_ERROR then
4052: p_return_status := FND_API.G_RET_STS_ERROR;
4053: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4054: p_data => l_msg_data);
4055:

Line 4052: p_return_status := FND_API.G_RET_STS_ERROR;

4048:
4049: EXCEPTION
4050:
4051: when FND_API.G_EXC_ERROR then
4052: p_return_status := FND_API.G_RET_STS_ERROR;
4053: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4054: p_data => l_msg_data);
4055:
4056:

Line 4057: when FND_API.G_EXC_UNEXPECTED_ERROR then

4053: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4054: p_data => l_msg_data);
4055:
4056:
4057: when FND_API.G_EXC_UNEXPECTED_ERROR then
4058: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4059: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4060: p_data => l_msg_data);
4061:

Line 4058: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4054: p_data => l_msg_data);
4055:
4056:
4057: when FND_API.G_EXC_UNEXPECTED_ERROR then
4058: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4059: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4060: p_data => l_msg_data);
4061:
4062: when OTHERS then

Line 4063: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4059: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
4060: p_data => l_msg_data);
4061:
4062: when OTHERS then
4063: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4064:
4065: if FND_MSG_PUB.Check_Msg_Level
4066: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4067: then

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

4081: -- Distributions
4082:
4083: PROCEDURE Update_Annual_FTE
4084: ( p_api_version IN NUMBER,
4085: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
4086: p_return_status OUT NOCOPY VARCHAR2,
4087: p_worksheet_id IN NUMBER,
4088: p_position_line_id IN NUMBER,
4089: p_budget_year_id IN NUMBER,

Line 4156: if not FND_API.Compatible_API_Call (l_api_version,

4152: BEGIN
4153:
4154: -- Standard call to check for call compatibility
4155:
4156: if not FND_API.Compatible_API_Call (l_api_version,
4157: p_api_version,
4158: l_api_name,
4159: G_PKG_NAME)
4160: then

Line 4161: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4157: p_api_version,
4158: l_api_name,
4159: G_PKG_NAME)
4160: then
4161: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4162: end if;
4163:
4164: l_ytd_amount := 0;
4165:

Line 4318: p_check_stages => FND_API.G_FALSE,

4314: (p_api_version => 1.0,
4315: p_return_status => l_return_status,
4316: p_worksheet_id => p_worksheet_id,
4317: p_account_line_id => g_element_dist(l_salary_index).account_line_id,
4318: p_check_stages => FND_API.G_FALSE,
4319: p_ytd_amount => g_element_dist(l_salary_index).ytd_amount,
4320: p_annual_fte => l_annual_fte * g_element_dist(l_salary_index).ytd_amount / l_ytd_amount,
4321: p_period_amount => l_period_amount,
4322: p_budget_group_id => p_budget_group_id,

Line 4326: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

4322: p_budget_group_id => p_budget_group_id,
4323: p_service_package_id => p_service_package_id,
4324: p_current_stage_seq => p_current_stage_seq);
4325:
4326: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4327: raise FND_API.G_EXC_ERROR;
4328: end if;
4329:
4330: end loop;

Line 4327: raise FND_API.G_EXC_ERROR;

4323: p_service_package_id => p_service_package_id,
4324: p_current_stage_seq => p_current_stage_seq);
4325:
4326: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4327: raise FND_API.G_EXC_ERROR;
4328: end if;
4329:
4330: end loop;
4331:

Line 4338: p_return_status := FND_API.G_RET_STS_SUCCESS;

4334:
4335:
4336: -- Initialize API return status to success
4337:
4338: p_return_status := FND_API.G_RET_STS_SUCCESS;
4339:
4340:
4341: EXCEPTION
4342:

Line 4343: when FND_API.G_EXC_ERROR then

4339:
4340:
4341: EXCEPTION
4342:
4343: when FND_API.G_EXC_ERROR then
4344: p_return_status := FND_API.G_RET_STS_ERROR;
4345:
4346: when FND_API.G_EXC_UNEXPECTED_ERROR then
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4344: p_return_status := FND_API.G_RET_STS_ERROR;

4340:
4341: EXCEPTION
4342:
4343: when FND_API.G_EXC_ERROR then
4344: p_return_status := FND_API.G_RET_STS_ERROR;
4345:
4346: when FND_API.G_EXC_UNEXPECTED_ERROR then
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348:

Line 4346: when FND_API.G_EXC_UNEXPECTED_ERROR then

4342:
4343: when FND_API.G_EXC_ERROR then
4344: p_return_status := FND_API.G_RET_STS_ERROR;
4345:
4346: when FND_API.G_EXC_UNEXPECTED_ERROR then
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348:
4349: when OTHERS then
4350: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4343: when FND_API.G_EXC_ERROR then
4344: p_return_status := FND_API.G_RET_STS_ERROR;
4345:
4346: when FND_API.G_EXC_UNEXPECTED_ERROR then
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348:
4349: when OTHERS then
4350: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4351:

Line 4350: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4346: when FND_API.G_EXC_UNEXPECTED_ERROR then
4347: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4348:
4349: when OTHERS then
4350: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4351:
4352: if FND_MSG_PUB.Check_Msg_Level
4353: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4354: then

Line 4366: p_redistribute IN VARCHAR2 := FND_API.G_FALSE,

4362: /* ----------------------------------------------------------------------- */
4363:
4364: PROCEDURE Distribute_Following_Elements
4365: ( p_return_status OUT NOCOPY VARCHAR2,
4366: p_redistribute IN VARCHAR2 := FND_API.G_FALSE,
4367: p_pay_element_id IN NUMBER,
4368: p_data_extract_id IN NUMBER,
4369: p_flex_code IN NUMBER,
4370: p_business_group_id IN NUMBER,

Line 4397: l_elem_found VARCHAR2(1) := FND_API.G_FALSE;

4393: l_dist_index BINARY_INTEGER;
4394: l_element_index BINARY_INTEGER;
4395: l_index BINARY_INTEGER;
4396:
4397: l_elem_found VARCHAR2(1) := FND_API.G_FALSE;
4398: l_dist_found VARCHAR2(1);
4399:
4400: l_percent NUMBER;
4401: l_element_set_id NUMBER;

Line 4445: l_elem_found := FND_API.G_TRUE;

4441:
4442: if ((g_pc_costs(l_calc_index).budget_year_id = p_budget_year_id) and
4443: (g_pc_costs(l_calc_index).pay_element_id = p_pay_element_id)) then
4444: l_element_index := l_calc_index;
4445: l_elem_found := FND_API.G_TRUE;
4446: exit;
4447: end if;
4448:
4449: end loop;

Line 4451: if FND_API.to_Boolean(l_elem_found) then

4447: end if;
4448:
4449: end loop;
4450:
4451: if FND_API.to_Boolean(l_elem_found) then
4452: begin
4453:
4454: /* Bug No 2278216 Start */
4455: PSB_WS_POS1.Initialize_Period_Dist;

Line 4494: l_dist_found := FND_API.G_FALSE;

4490:
4491: l_dist_start_date := greatest(l_start_date, PSB_WS_POS1.g_salary_dist(l_saldist_index).start_date);
4492: l_dist_end_date := least(l_end_date, nvl(PSB_WS_POS1.g_salary_dist(l_saldist_index).end_date, l_end_date));
4493:
4494: l_dist_found := FND_API.G_FALSE;
4495:
4496: -- commented for bug # 4502946
4497: /*if g_salary_dist(l_saldist_index).percent < 1 then
4498: l_percent := g_salary_dist(l_saldist_index).percent;

Line 4520: raise FND_API.G_EXC_ERROR;

4516: n_segments => PSB_WS_ACCT1.g_num_segs,
4517: segments => l_ccid_val) then
4518:
4519: FND_MSG_PUB.Add;
4520: raise FND_API.G_EXC_ERROR;
4521: end if;
4522:
4523: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop
4524:

Line 4674: raise FND_API.G_EXC_ERROR;

4670:
4671: FND_MSG_PUB.Add;
4672: message_token('ACCOUNT', l_concat_segments);
4673: add_message('PSB', 'PSB_GL_CCID_FAILURE');
4674: raise FND_API.G_EXC_ERROR;
4675:
4676: end;
4677: end if;
4678:

Line 4686: l_dist_found := FND_API.G_TRUE;

4682: (g_pd_costs(l_index).budget_year_id = p_budget_year_id) and
4683: (g_pd_costs(l_index).element_type = 'F')) then
4684: l_element_set_id := g_pd_costs(l_index).element_set_id;
4685: l_dist_index := l_index;
4686: l_dist_found := FND_API.G_TRUE;
4687: exit;
4688: end if;
4689:
4690: end loop;

Line 4695: if not FND_API.to_Boolean(l_dist_found) then

4691:
4692: /* Bug No 2278216 Start */
4693: -- Created a separate procedure for calculating period amounts
4694:
4695: if not FND_API.to_Boolean(l_dist_found) then
4696: begin
4697: g_num_pd_costs := g_num_pd_costs + 1;
4698:
4699: g_pd_costs(g_num_pd_costs).budget_year_id := p_budget_year_id;

Line 4703: if not FND_API.to_Boolean(p_redistribute) then

4699: g_pd_costs(g_num_pd_costs).budget_year_id := p_budget_year_id;
4700: g_pd_costs(g_num_pd_costs).element_type := 'F';
4701: g_pd_costs(g_num_pd_costs).ccid := l_ccid;
4702:
4703: if not FND_API.to_Boolean(p_redistribute) then
4704: begin
4705: if l_element_set_id is null then
4706: l_element_set_id := p_pay_element_id;
4707: end if;

Line 4723: if not FND_API.to_Boolean(p_redistribute) then

4719: end if;
4720: end;
4721: else
4722: begin
4723: if not FND_API.to_Boolean(p_redistribute) then
4724: begin
4725: if g_pc_costs(l_element_index).element_set_id is null then
4726: g_pc_costs(l_element_index).element_set_id := l_element_set_id;
4727: end if;

Line 4761: if not FND_API.to_Boolean(p_redistribute) then

4757: if ((g_pd_costs(l_dist_index).budget_year_id = p_budget_year_id)
4758: and (g_pd_costs(l_dist_index).element_type = 'F')
4759: and (g_pd_costs(l_dist_index).element_set_id = l_element_set_id)) then
4760:
4761: if not FND_API.to_Boolean(p_redistribute) then
4762: begin
4763:
4764: for l_period_index in 1..g_num_periods loop
4765: if ((g_periods(l_period_index).ccid = g_pd_costs(l_dist_index).ccid)

Line 4784: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

4780: p_element_index => l_element_index,
4781: p_dist_index => l_dist_index,
4782: p_percent => g_periods(l_period_index).percent);
4783:
4784: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4785: raise FND_API.G_EXC_ERROR;
4786: end if;
4787:
4788: end if;

Line 4785: raise FND_API.G_EXC_ERROR;

4781: p_dist_index => l_dist_index,
4782: p_percent => g_periods(l_period_index).percent);
4783:
4784: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4785: raise FND_API.G_EXC_ERROR;
4786: end if;
4787:
4788: end if;
4789: end loop;

Line 4810: p_return_status := FND_API.G_RET_STS_SUCCESS;

4806: end if;
4807:
4808: -- Initialize API return status to success
4809:
4810: p_return_status := FND_API.G_RET_STS_SUCCESS;
4811:
4812:
4813: EXCEPTION
4814:

Line 4815: when FND_API.G_EXC_ERROR then

4811:
4812:
4813: EXCEPTION
4814:
4815: when FND_API.G_EXC_ERROR then
4816: p_return_status := FND_API.G_RET_STS_ERROR;
4817:
4818: when FND_API.G_EXC_UNEXPECTED_ERROR then
4819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4816: p_return_status := FND_API.G_RET_STS_ERROR;

4812:
4813: EXCEPTION
4814:
4815: when FND_API.G_EXC_ERROR then
4816: p_return_status := FND_API.G_RET_STS_ERROR;
4817:
4818: when FND_API.G_EXC_UNEXPECTED_ERROR then
4819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4820:

Line 4818: when FND_API.G_EXC_UNEXPECTED_ERROR then

4814:
4815: when FND_API.G_EXC_ERROR then
4816: p_return_status := FND_API.G_RET_STS_ERROR;
4817:
4818: when FND_API.G_EXC_UNEXPECTED_ERROR then
4819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4820:
4821: when OTHERS then
4822: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4815: when FND_API.G_EXC_ERROR then
4816: p_return_status := FND_API.G_RET_STS_ERROR;
4817:
4818: when FND_API.G_EXC_UNEXPECTED_ERROR then
4819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4820:
4821: when OTHERS then
4822: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4823:

Line 4822: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4818: when FND_API.G_EXC_UNEXPECTED_ERROR then
4819: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4820:
4821: when OTHERS then
4822: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4823:
4824: END Distribute_Following_Elements;
4825:
4826: /* ------------------------------------------------------------------------- */

Line 5374: p_return_status := FND_API.G_RET_STS_SUCCESS;

5370: end if;
5371:
5372: -- Initialize API return status to success
5373:
5374: p_return_status := FND_API.G_RET_STS_SUCCESS;
5375:
5376:
5377: EXCEPTION
5378:

Line 5379: when FND_API.G_EXC_ERROR then

5375:
5376:
5377: EXCEPTION
5378:
5379: when FND_API.G_EXC_ERROR then
5380: p_return_status := FND_API.G_RET_STS_ERROR;
5381:
5382: when FND_API.G_EXC_UNEXPECTED_ERROR then
5383: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5380: p_return_status := FND_API.G_RET_STS_ERROR;

5376:
5377: EXCEPTION
5378:
5379: when FND_API.G_EXC_ERROR then
5380: p_return_status := FND_API.G_RET_STS_ERROR;
5381:
5382: when FND_API.G_EXC_UNEXPECTED_ERROR then
5383: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5384:

Line 5382: when FND_API.G_EXC_UNEXPECTED_ERROR then

5378:
5379: when FND_API.G_EXC_ERROR then
5380: p_return_status := FND_API.G_RET_STS_ERROR;
5381:
5382: when FND_API.G_EXC_UNEXPECTED_ERROR then
5383: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5384:
5385: when OTHERS then
5386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5383: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5379: when FND_API.G_EXC_ERROR then
5380: p_return_status := FND_API.G_RET_STS_ERROR;
5381:
5382: when FND_API.G_EXC_UNEXPECTED_ERROR then
5383: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5384:
5385: when OTHERS then
5386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5387:

Line 5386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5382: when FND_API.G_EXC_UNEXPECTED_ERROR then
5383: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5384:
5385: when OTHERS then
5386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5387:
5388: END Distribute_Periods;
5389:
5390: /* Bug No 2278216 End */