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

Line 142: l_attr_already_exists := FND_API.G_FALSE;

138: -- Loop for each attribute in business group of local worksheet
139:
140: for c_attr_rec in c_attr loop
141:
142: l_attr_already_exists := FND_API.G_FALSE;
143:
144: -- Check if same attribute is already defined in business group of global worksheet
145:
146: for c_attrname_exists_rec in c_attrname_exists (c_attr_rec.name) loop

Line 148: l_attr_already_exists := FND_API.G_TRUE;

144: -- Check if same attribute is already defined in business group of global worksheet
145:
146: for c_attrname_exists_rec in c_attrname_exists (c_attr_rec.name) loop
147: l_attribute_id := c_attrname_exists_rec.attribute_id;
148: l_attr_already_exists := FND_API.G_TRUE;
149: end loop;
150:
151: -- if attribute doesn't already exist in business group of global worksheet create the
152: -- attribute and all its values

Line 154: if not FND_API.to_Boolean(l_attr_already_exists) then

150:
151: -- if attribute doesn't already exist in business group of global worksheet create the
152: -- attribute and all its values
153:
154: if not FND_API.to_Boolean(l_attr_already_exists) then
155: begin
156:
157: for c_attr_seq_rec in c_attr_seq loop
158: l_attribute_id := c_attr_seq_rec.seq;

Line 192: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

188: p_last_update_login => g_loginid,
189: p_created_by => g_userid,
190: p_creation_date => sysdate);
191:
192: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
193: raise FND_API.G_EXC_ERROR;
194: end if;
195:
196: for c_attrval_rec in c_attrval (c_attr_rec.attribute_id) loop

Line 193: raise FND_API.G_EXC_ERROR;

189: p_created_by => g_userid,
190: p_creation_date => sysdate);
191:
192: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
193: raise FND_API.G_EXC_ERROR;
194: end if;
195:
196: for c_attrval_rec in c_attrval (c_attr_rec.attribute_id) loop
197:

Line 251: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

247: p_last_update_login => g_loginid,
248: p_created_by => g_userid,
249: p_creation_date => sysdate);
250:
251: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
252: raise FND_API.G_EXC_ERROR;
253: end if;
254:
255: end loop;

Line 252: raise FND_API.G_EXC_ERROR;

248: p_created_by => g_userid,
249: p_creation_date => sysdate);
250:
251: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
252: raise FND_API.G_EXC_ERROR;
253: end if;
254:
255: end loop;
256:

Line 266: l_attrval_already_exists := FND_API.G_FALSE;

262: -- consolidate attribute values if required
263:
264: for c_attrval_rec in c_attrval (l_attribute_id) loop
265:
266: l_attrval_already_exists := FND_API.G_FALSE;
267:
268: -- Check if attribute value is already defined in data extract of global worksheet
269:
270: for c_attrval_exists_rec in c_attrval_exists (l_attribute_id, c_attrval_rec.attribute_value) loop

Line 272: l_attrval_already_exists := FND_API.G_TRUE;

268: -- Check if attribute value is already defined in data extract of global worksheet
269:
270: for c_attrval_exists_rec in c_attrval_exists (l_attribute_id, c_attrval_rec.attribute_value) loop
271: l_attribute_value_id := c_attrval_exists_rec.attribute_value_id;
272: l_attrval_already_exists := FND_API.G_TRUE;
273: end loop;
274:
275: if not FND_API.to_Boolean(l_attrval_already_exists) then
276: begin

Line 275: if not FND_API.to_Boolean(l_attrval_already_exists) then

271: l_attribute_value_id := c_attrval_exists_rec.attribute_value_id;
272: l_attrval_already_exists := FND_API.G_TRUE;
273: end loop;
274:
275: if not FND_API.to_Boolean(l_attrval_already_exists) then
276: begin
277:
278: for c_attrval_seq_rec in c_attrval_seq loop
279: l_attribute_value_id := c_attrval_seq_rec.seq;

Line 331: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

327: p_last_update_login => g_loginid,
328: p_created_by => g_userid,
329: p_creation_date => sysdate);
330:
331: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
332: raise FND_API.G_EXC_ERROR;
333: end if;
334:
335: end;

Line 332: raise FND_API.G_EXC_ERROR;

328: p_created_by => g_userid,
329: p_creation_date => sysdate);
330:
331: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
332: raise FND_API.G_EXC_ERROR;
333: end if;
334:
335: end;
336: end if;

Line 348: p_return_status := FND_API.G_RET_STS_SUCCESS;

344:
345:
346: -- Initialize API return status to success
347:
348: p_return_status := FND_API.G_RET_STS_SUCCESS;
349:
350:
351: EXCEPTION
352:

Line 353: when FND_API.G_EXC_ERROR then

349:
350:
351: EXCEPTION
352:
353: when FND_API.G_EXC_ERROR then
354: p_return_status := FND_API.G_RET_STS_ERROR;
355:
356: when FND_API.G_EXC_UNEXPECTED_ERROR then
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 354: p_return_status := FND_API.G_RET_STS_ERROR;

350:
351: EXCEPTION
352:
353: when FND_API.G_EXC_ERROR then
354: p_return_status := FND_API.G_RET_STS_ERROR;
355:
356: when FND_API.G_EXC_UNEXPECTED_ERROR then
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358:

Line 356: when FND_API.G_EXC_UNEXPECTED_ERROR then

352:
353: when FND_API.G_EXC_ERROR then
354: p_return_status := FND_API.G_RET_STS_ERROR;
355:
356: when FND_API.G_EXC_UNEXPECTED_ERROR then
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358:
359: when OTHERS then
360: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

353: when FND_API.G_EXC_ERROR then
354: p_return_status := FND_API.G_RET_STS_ERROR;
355:
356: when FND_API.G_EXC_UNEXPECTED_ERROR then
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358:
359: when OTHERS then
360: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:

Line 360: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: when FND_API.G_EXC_UNEXPECTED_ERROR then
357: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358:
359: when OTHERS then
360: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:
362: END Consolidate_Attributes;
363:
364: /* ----------------------------------------------------------------------- */

Line 540: l_element_exists := FND_API.G_FALSE;

536: BEGIN
537:
538: for c_elem_rec in c_elem loop
539:
540: l_element_exists := FND_API.G_FALSE;
541:
542: -- Check if element name exists in the global data extract
543:
544: for c_elemname_exists_rec in c_elemname_exists (c_elem_rec.name) loop

Line 546: l_element_exists := FND_API.G_TRUE;

542: -- Check if element name exists in the global data extract
543:
544: for c_elemname_exists_rec in c_elemname_exists (c_elem_rec.name) loop
545: l_pay_element_id := c_elemname_exists_rec.pay_element_id;
546: l_element_exists := FND_API.G_TRUE;
547: end loop;
548:
549: if not FND_API.to_Boolean(l_element_exists) then
550: begin

Line 549: if not FND_API.to_Boolean(l_element_exists) then

545: l_pay_element_id := c_elemname_exists_rec.pay_element_id;
546: l_element_exists := FND_API.G_TRUE;
547: end loop;
548:
549: if not FND_API.to_Boolean(l_element_exists) then
550: begin
551:
552: for c_elem_seq_rec in c_elem_seq loop
553: l_pay_element_id := c_elem_seq_rec.seq;

Line 602: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

598: p_last_update_login => g_loginid,
599: p_created_by => g_userid,
600: p_creation_date => sysdate);
601:
602: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
603: raise FND_API.G_EXC_ERROR;
604: end if;
605:
606: if c_elem_rec.option_flag = 'Y' then

Line 603: raise FND_API.G_EXC_ERROR;

599: p_created_by => g_userid,
600: p_creation_date => sysdate);
601:
602: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
603: raise FND_API.G_EXC_ERROR;
604: end if;
605:
606: if c_elem_rec.option_flag = 'Y' then
607: begin

Line 631: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

627: p_last_update_login => g_loginid,
628: p_created_by => g_userid,
629: p_creation_date => sysdate);
630:
631: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
632: raise FND_API.G_EXC_ERROR;
633: end if;
634:
635: for c_elemrates_rec in c_elemrates (c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop

Line 632: raise FND_API.G_EXC_ERROR;

628: p_created_by => g_userid,
629: p_creation_date => sysdate);
630:
631: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
632: raise FND_API.G_EXC_ERROR;
633: end if;
634:
635: for c_elemrates_rec in c_elemrates (c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop
636:

Line 672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

668: p_last_update_login => g_loginid,
669: p_created_by => g_userid,
670: p_creation_date => sysdate);
671:
672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
673: raise FND_API.G_EXC_ERROR;
674: end if;
675:
676: end loop;

Line 673: raise FND_API.G_EXC_ERROR;

669: p_created_by => g_userid,
670: p_creation_date => sysdate);
671:
672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
673: raise FND_API.G_EXC_ERROR;
674: end if;
675:
676: end loop;
677:

Line 721: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

717: p_last_update_login => g_loginid,
718: p_created_by => g_userid,
719: p_creation_date => sysdate);
720:
721: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
722: raise FND_API.G_EXC_ERROR;
723: end if;
724:
725: end loop;

Line 722: raise FND_API.G_EXC_ERROR;

718: p_created_by => g_userid,
719: p_creation_date => sysdate);
720:
721: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
722: raise FND_API.G_EXC_ERROR;
723: end if;
724:
725: end loop;
726:

Line 752: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

748: p_last_update_login => g_loginid,
749: p_created_by => g_userid,
750: p_creation_date => sysdate);
751:
752: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
753: raise FND_API.G_EXC_ERROR;
754: end if;
755:
756: -- Consolidate all Set Relations for the Position Set Group

Line 753: raise FND_API.G_EXC_ERROR;

749: p_created_by => g_userid,
750: p_creation_date => sysdate);
751:
752: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
753: raise FND_API.G_EXC_ERROR;
754: end if;
755:
756: -- Consolidate all Set Relations for the Position Set Group
757:

Line 762: l_position_set_exists := FND_API.G_FALSE;

758: for c_setrel_rec in c_setrel (c_possetgrp_rec.position_set_group_id) loop
759:
760: for c_posset_rec in c_posset (c_setrel_rec.account_position_set_id) loop
761:
762: l_position_set_exists := FND_API.G_FALSE;
763:
764: for c_posset_exists_rec in c_posset_exists (c_posset_rec.name) loop
765: l_position_set_id := c_posset_exists_rec.account_position_set_id;
766: l_position_set_exists := FND_API.G_TRUE;

Line 766: l_position_set_exists := FND_API.G_TRUE;

762: l_position_set_exists := FND_API.G_FALSE;
763:
764: for c_posset_exists_rec in c_posset_exists (c_posset_rec.name) loop
765: l_position_set_id := c_posset_exists_rec.account_position_set_id;
766: l_position_set_exists := FND_API.G_TRUE;
767: end loop;
768:
769: if not FND_API.to_Boolean(l_position_set_exists) then
770: begin

Line 769: if not FND_API.to_Boolean(l_position_set_exists) then

765: l_position_set_id := c_posset_exists_rec.account_position_set_id;
766: l_position_set_exists := FND_API.G_TRUE;
767: end loop;
768:
769: if not FND_API.to_Boolean(l_position_set_exists) then
770: begin
771:
772: for c_posset_seq_rec in c_posset_seq loop
773: l_position_set_id := c_posset_seq_rec.seq;

Line 797: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

793: p_last_update_login => g_loginid,
794: p_created_by => g_userid,
795: p_creation_date => sysdate);
796:
797: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: raise FND_API.G_EXC_ERROR;
799: end if;
800:
801: for c_possetline_rec in c_possetline (c_posset_rec.account_position_set_id) loop

Line 798: raise FND_API.G_EXC_ERROR;

794: p_created_by => g_userid,
795: p_creation_date => sysdate);
796:
797: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: raise FND_API.G_EXC_ERROR;
799: end if;
800:
801: for c_possetline_rec in c_possetline (c_posset_rec.account_position_set_id) loop
802:

Line 865: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

861: p_last_update_login => g_loginid,
862: p_created_by => g_userid,
863: p_creation_date => sysdate);
864:
865: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
866: raise FND_API.G_EXC_ERROR;
867: end if;
868:
869: for c_possetlineval_rec in c_possetlineval (c_possetline_rec.line_sequence_id) loop

Line 866: raise FND_API.G_EXC_ERROR;

862: p_created_by => g_userid,
863: p_creation_date => sysdate);
864:
865: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
866: raise FND_API.G_EXC_ERROR;
867: end if;
868:
869: for c_possetlineval_rec in c_possetlineval (c_possetline_rec.line_sequence_id) loop
870:

Line 895: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

891: p_last_update_login => g_loginid,
892: p_created_by => g_userid,
893: p_creation_date => sysdate);
894:
895: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
896: raise FND_API.G_EXC_ERROR;
897: end if;
898:
899: end loop;

Line 896: raise FND_API.G_EXC_ERROR;

892: p_created_by => g_userid,
893: p_creation_date => sysdate);
894:
895: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
896: raise FND_API.G_EXC_ERROR;
897: end if;
898:
899: end loop;
900:

Line 909: l_line_sequence_exists := FND_API.G_FALSE;

905: begin /* Position Set exists; only consolidate position set lines and attribute values */
906:
907: for c_possetline_rec in c_possetline (c_posset_rec.account_position_set_id) loop
908:
909: l_line_sequence_exists := FND_API.G_FALSE;
910:
911: -- Find attribute id for the global business group
912:
913: for c_re_attr_rec in c_re_attr (c_possetline_rec.attribute_id) loop

Line 919: l_line_sequence_exists := FND_API.G_TRUE;

915: end loop;
916:
917: for c_possetline_exists_rec in c_possetline_exists (l_position_set_id, l_attribute_id) loop
918: l_line_sequence_id := c_possetline_exists_rec.line_sequence_id;
919: l_line_sequence_exists := FND_API.G_TRUE;
920: end loop;
921:
922: if not FND_API.to_Boolean(l_line_sequence_exists) then
923: begin

Line 922: if not FND_API.to_Boolean(l_line_sequence_exists) then

918: l_line_sequence_id := c_possetline_exists_rec.line_sequence_id;
919: l_line_sequence_exists := FND_API.G_TRUE;
920: end loop;
921:
922: if not FND_API.to_Boolean(l_line_sequence_exists) then
923: begin
924:
925: for c_possetline_seq_rec in c_possetline_seq loop
926: l_line_sequence_id := c_possetline_seq_rec.seq;

Line 983: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

979: p_last_update_login => g_loginid,
980: p_created_by => g_userid,
981: p_creation_date => sysdate);
982:
983: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
984: raise FND_API.G_EXC_ERROR;
985: end if;
986:
987: for c_possetlineval_rec in c_possetlineval (c_possetline_rec.line_sequence_id) loop

Line 984: raise FND_API.G_EXC_ERROR;

980: p_created_by => g_userid,
981: p_creation_date => sysdate);
982:
983: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
984: raise FND_API.G_EXC_ERROR;
985: end if;
986:
987: for c_possetlineval_rec in c_possetlineval (c_possetline_rec.line_sequence_id) loop
988:

Line 1013: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1009: p_last_update_login => g_loginid,
1010: p_created_by => g_userid,
1011: p_creation_date => sysdate);
1012:
1013: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1014: raise FND_API.G_EXC_ERROR;
1015: end if;
1016:
1017: end loop;

Line 1014: raise FND_API.G_EXC_ERROR;

1010: p_created_by => g_userid,
1011: p_creation_date => sysdate);
1012:
1013: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1014: raise FND_API.G_EXC_ERROR;
1015: end if;
1016:
1017: end loop;
1018:

Line 1031: l_value_sequence_exists := FND_API.G_TRUE;

1027: end loop;
1028:
1029: for c_possetlineval_exists_rec in c_possetlineval_exists (l_line_sequence_id, c_possetlineval_rec.attribute_value) loop
1030: l_value_sequence_id := c_possetlineval_exists_rec.value_sequence_id;
1031: l_value_sequence_exists := FND_API.G_TRUE;
1032: end loop;
1033:
1034: if not FND_API.to_Boolean(l_value_sequence_exists) then
1035: begin

Line 1034: if not FND_API.to_Boolean(l_value_sequence_exists) then

1030: l_value_sequence_id := c_possetlineval_exists_rec.value_sequence_id;
1031: l_value_sequence_exists := FND_API.G_TRUE;
1032: end loop;
1033:
1034: if not FND_API.to_Boolean(l_value_sequence_exists) then
1035: begin
1036:
1037: for c_possetlineval_seq_rec in c_possetlineval_seq loop
1038: l_value_sequence_id := c_possetlineval_seq_rec.seq;

Line 1057: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1053: p_last_update_login => g_loginid,
1054: p_created_by => g_userid,
1055: p_creation_date => sysdate);
1056:
1057: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1058: raise FND_API.G_EXC_ERROR;
1059: end if;
1060:
1061: end;

Line 1058: raise FND_API.G_EXC_ERROR;

1054: p_created_by => g_userid,
1055: p_creation_date => sysdate);
1056:
1057: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1058: raise FND_API.G_EXC_ERROR;
1059: end if;
1060:
1061: end;
1062: end if;

Line 1092: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1088: p_last_update_date => sysdate,
1089: p_last_updated_by => g_userid,
1090: p_last_update_login => g_loginid);
1091:
1092: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1093: raise FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: end;

Line 1093: raise FND_API.G_EXC_ERROR;

1089: p_last_updated_by => g_userid,
1090: p_last_update_login => g_loginid);
1091:
1092: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1093: raise FND_API.G_EXC_ERROR;
1094: end if;
1095:
1096: end;
1097: end if;

Line 1137: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1133: p_last_update_login => g_loginid,
1134: p_created_by => g_userid,
1135: p_creation_date => sysdate);
1136:
1137: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1138: raise FND_API.G_EXC_ERROR;
1139: end if;
1140:
1141: end loop; /* Position Sets */

Line 1138: raise FND_API.G_EXC_ERROR;

1134: p_created_by => g_userid,
1135: p_creation_date => sysdate);
1136:
1137: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1138: raise FND_API.G_EXC_ERROR;
1139: end if;
1140:
1141: end loop; /* Position Sets */
1142:

Line 1186: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1182: p_last_update_login => g_loginid,
1183: p_created_by => g_userid,
1184: p_creation_date => sysdate);
1185:
1186: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1187: raise FND_API.G_EXC_ERROR;
1188: end if;
1189:
1190: end loop; /* Element Distribution */

Line 1187: raise FND_API.G_EXC_ERROR;

1183: p_created_by => g_userid,
1184: p_creation_date => sysdate);
1185:
1186: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1187: raise FND_API.G_EXC_ERROR;
1188: end if;
1189:
1190: end loop; /* Element Distribution */
1191:

Line 1203: l_element_option_exists := FND_API.G_FALSE;

1199: begin
1200:
1201: for c_elemoptions_rec in c_elemoptions (c_elem_rec.pay_element_id) loop
1202:
1203: l_element_option_exists := FND_API.G_FALSE;
1204:
1205: -- Check if Element Option already exists
1206:
1207: for c_elemoptions_exists_rec in c_elemoptions_exists (c_elem_rec.pay_element_id, c_elemoptions_rec.name) loop

Line 1208: l_element_option_exists := FND_API.G_TRUE;

1204:
1205: -- Check if Element Option already exists
1206:
1207: for c_elemoptions_exists_rec in c_elemoptions_exists (c_elem_rec.pay_element_id, c_elemoptions_rec.name) loop
1208: l_element_option_exists := FND_API.G_TRUE;
1209: end loop;
1210:
1211: if not FND_API.to_Boolean(l_element_option_exists) then
1212: begin

Line 1211: if not FND_API.to_Boolean(l_element_option_exists) then

1207: for c_elemoptions_exists_rec in c_elemoptions_exists (c_elem_rec.pay_element_id, c_elemoptions_rec.name) loop
1208: l_element_option_exists := FND_API.G_TRUE;
1209: end loop;
1210:
1211: if not FND_API.to_Boolean(l_element_option_exists) then
1212: begin
1213:
1214: for c_elemoptions_seq_rec in c_elemoptions_seq loop
1215: l_pay_element_option_id := c_elemoptions_seq_rec.seq;

Line 1234: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1230: p_last_update_login => g_loginid,
1231: p_created_by => g_userid,
1232: p_creation_date => sysdate);
1233:
1234: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1235: raise FND_API.G_EXC_ERROR;
1236: end if;
1237:
1238: for c_elemrates_rec in c_elemrates (c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop

Line 1235: raise FND_API.G_EXC_ERROR;

1231: p_created_by => g_userid,
1232: p_creation_date => sysdate);
1233:
1234: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1235: raise FND_API.G_EXC_ERROR;
1236: end if;
1237:
1238: for c_elemrates_rec in c_elemrates (c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop
1239:

Line 1275: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1271: p_last_update_login => g_loginid,
1272: p_created_by => g_userid,
1273: p_creation_date => sysdate);
1274:
1275: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1276: raise FND_API.G_EXC_ERROR;
1277: end if;
1278:
1279: end loop;

Line 1276: raise FND_API.G_EXC_ERROR;

1272: p_created_by => g_userid,
1273: p_creation_date => sysdate);
1274:
1275: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1276: raise FND_API.G_EXC_ERROR;
1277: end if;
1278:
1279: end loop;
1280:

Line 1297: p_return_status := FND_API.G_RET_STS_SUCCESS;

1293:
1294:
1295: -- Initialize API return status to success
1296:
1297: p_return_status := FND_API.G_RET_STS_SUCCESS;
1298:
1299:
1300: EXCEPTION
1301:

Line 1302: when FND_API.G_EXC_ERROR then

1298:
1299:
1300: EXCEPTION
1301:
1302: when FND_API.G_EXC_ERROR then
1303: p_return_status := FND_API.G_RET_STS_ERROR;
1304:
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1303: p_return_status := FND_API.G_RET_STS_ERROR;

1299:
1300: EXCEPTION
1301:
1302: when FND_API.G_EXC_ERROR then
1303: p_return_status := FND_API.G_RET_STS_ERROR;
1304:
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307:

Line 1305: when FND_API.G_EXC_UNEXPECTED_ERROR then

1301:
1302: when FND_API.G_EXC_ERROR then
1303: p_return_status := FND_API.G_RET_STS_ERROR;
1304:
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307:
1308: when OTHERS then
1309: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1302: when FND_API.G_EXC_ERROR then
1303: p_return_status := FND_API.G_RET_STS_ERROR;
1304:
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307:
1308: when OTHERS then
1309: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310:

Line 1309: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307:
1308: when OTHERS then
1309: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310:
1311: END Consolidate_Elements;
1312:
1313: /* ----------------------------------------------------------------------- */

Line 1349: l_employee_exists := FND_API.G_FALSE;

1345: -- Loop for all employees in the local data extract
1346:
1347: for c_emp_rec in c_emp loop
1348:
1349: l_employee_exists := FND_API.G_FALSE;
1350:
1351: for c_emp_exists_rec in c_emp_exists (c_emp_rec.employee_number) loop
1352: l_employee_exists := FND_API.G_TRUE;
1353: end loop;

Line 1352: l_employee_exists := FND_API.G_TRUE;

1348:
1349: l_employee_exists := FND_API.G_FALSE;
1350:
1351: for c_emp_exists_rec in c_emp_exists (c_emp_rec.employee_number) loop
1352: l_employee_exists := FND_API.G_TRUE;
1353: end loop;
1354:
1355: -- If employee does not already exist in the global data extract create the employee
1356:

Line 1357: if not FND_API.to_Boolean(l_employee_exists) then

1353: end loop;
1354:
1355: -- If employee does not already exist in the global data extract create the employee
1356:
1357: if not FND_API.to_Boolean(l_employee_exists) then
1358: begin
1359:
1360: for c_emp_seq_rec in c_emp_seq loop
1361: l_employee_id := c_emp_seq_rec.seq;

Line 1383: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1379: c_emp_rec.middle_names, c_emp_rec.title,
1380: sysdate, g_userid, sysdate,
1381: g_userid, g_loginid);
1382:
1383: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1384: raise FND_API.G_EXC_ERROR;
1385: end if;
1386:
1387: end;

Line 1384: raise FND_API.G_EXC_ERROR;

1380: sysdate, g_userid, sysdate,
1381: g_userid, g_loginid);
1382:
1383: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1384: raise FND_API.G_EXC_ERROR;
1385: end if;
1386:
1387: end;
1388: end if;

Line 1395: p_return_status := FND_API.G_RET_STS_SUCCESS;

1391:
1392:
1393: -- Initialize API return status to success
1394:
1395: p_return_status := FND_API.G_RET_STS_SUCCESS;
1396:
1397:
1398: EXCEPTION
1399:

Line 1400: when FND_API.G_EXC_ERROR then

1396:
1397:
1398: EXCEPTION
1399:
1400: when FND_API.G_EXC_ERROR then
1401: p_return_status := FND_API.G_RET_STS_ERROR;
1402:
1403: when FND_API.G_EXC_UNEXPECTED_ERROR then
1404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1401: p_return_status := FND_API.G_RET_STS_ERROR;

1397:
1398: EXCEPTION
1399:
1400: when FND_API.G_EXC_ERROR then
1401: p_return_status := FND_API.G_RET_STS_ERROR;
1402:
1403: when FND_API.G_EXC_UNEXPECTED_ERROR then
1404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:

Line 1403: when FND_API.G_EXC_UNEXPECTED_ERROR then

1399:
1400: when FND_API.G_EXC_ERROR then
1401: p_return_status := FND_API.G_RET_STS_ERROR;
1402:
1403: when FND_API.G_EXC_UNEXPECTED_ERROR then
1404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:
1406: when OTHERS then
1407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1400: when FND_API.G_EXC_ERROR then
1401: p_return_status := FND_API.G_RET_STS_ERROR;
1402:
1403: when FND_API.G_EXC_UNEXPECTED_ERROR then
1404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:
1406: when OTHERS then
1407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408:

Line 1407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1403: when FND_API.G_EXC_UNEXPECTED_ERROR then
1404: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1405:
1406: when OTHERS then
1407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408:
1409: END Consolidate_Employees;
1410:
1411: /* ----------------------------------------------------------------------- */

Line 1538: l_position_exists := FND_API.G_FALSE;

1534: -- Loop for all positions in the local data extract
1535:
1536: for c_positions_rec in c_positions loop
1537:
1538: l_position_exists := FND_API.G_FALSE;
1539:
1540: for c_position_exists_rec in c_position_exists (c_positions_rec.name, c_positions_rec.hr_position_id, c_positions_rec.hr_employee_id) loop
1541: l_position_exists := FND_API.G_TRUE;
1542: end loop;

Line 1541: l_position_exists := FND_API.G_TRUE;

1537:
1538: l_position_exists := FND_API.G_FALSE;
1539:
1540: for c_position_exists_rec in c_position_exists (c_positions_rec.name, c_positions_rec.hr_position_id, c_positions_rec.hr_employee_id) loop
1541: l_position_exists := FND_API.G_TRUE;
1542: end loop;
1543:
1544: -- If position does not exist in the global data extract create the position
1545:

Line 1546: if not FND_API.to_Boolean(l_position_exists) then

1542: end loop;
1543:
1544: -- If position does not exist in the global data extract create the position
1545:
1546: if not FND_API.to_Boolean(l_position_exists) then
1547: begin
1548:
1549: for c_pos_seq_rec in c_pos_seq loop
1550: l_position_id := c_pos_seq_rec.seq;

Line 1598: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1594: p_attribute20 => c_positions_rec.attribute20,
1595: p_attribute_category => c_positions_rec.attribute_category,
1596: p_name => c_positions_rec.name);
1597:
1598: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1599: raise FND_API.G_EXC_ERROR;
1600: end if;
1601:
1602: -- Consolidate Position Attribute Assignments

Line 1599: raise FND_API.G_EXC_ERROR;

1595: p_attribute_category => c_positions_rec.attribute_category,
1596: p_name => c_positions_rec.name);
1597:
1598: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1599: raise FND_API.G_EXC_ERROR;
1600: end if;
1601:
1602: -- Consolidate Position Attribute Assignments
1603:

Line 1660: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1656: p_global_default_flag => null,
1657: p_assignment_default_rule_id => null,
1658: p_modify_flag => null);
1659:
1660: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1661: raise FND_API.G_EXC_ERROR;
1662: end if;
1663:
1664: end loop;

Line 1661: raise FND_API.G_EXC_ERROR;

1657: p_assignment_default_rule_id => null,
1658: p_modify_flag => null);
1659:
1660: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1661: raise FND_API.G_EXC_ERROR;
1662: end if;
1663:
1664: end loop;
1665:

Line 1724: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1720: p_global_default_flag => null,
1721: p_assignment_default_rule_id => null,
1722: p_modify_flag => null);
1723:
1724: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1725: raise FND_API.G_EXC_ERROR;
1726: end if;
1727:
1728: end loop;

Line 1725: raise FND_API.G_EXC_ERROR;

1721: p_assignment_default_rule_id => null,
1722: p_modify_flag => null);
1723:
1724: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1725: raise FND_API.G_EXC_ERROR;
1726: end if;
1727:
1728: end loop;
1729:

Line 1776: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1772: p_global_default_flag => null,
1773: p_assignment_default_rule_id => null,
1774: p_modify_flag => null);
1775:
1776: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1777: raise FND_API.G_EXC_ERROR;
1778: end if;
1779:
1780: end loop;

Line 1777: raise FND_API.G_EXC_ERROR;

1773: p_assignment_default_rule_id => null,
1774: p_modify_flag => null);
1775:
1776: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1777: raise FND_API.G_EXC_ERROR;
1778: end if;
1779:
1780: end loop;
1781:

Line 1820: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1816: p_expenditure_type => c_position_distr_rec.expenditure_type,
1817: p_expenditure_organization_id => c_position_distr_rec.expenditure_organization_id,
1818: p_description => c_position_distr_rec.description);
1819:
1820: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1821: raise FND_API.G_EXC_ERROR;
1822: end if;
1823:
1824: end loop;

Line 1821: raise FND_API.G_EXC_ERROR;

1817: p_expenditure_organization_id => c_position_distr_rec.expenditure_organization_id,
1818: p_description => c_position_distr_rec.description);
1819:
1820: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1821: raise FND_API.G_EXC_ERROR;
1822: end if;
1823:
1824: end loop;
1825:

Line 1834: p_return_status := FND_API.G_RET_STS_SUCCESS;

1830:
1831:
1832: -- Initialize API return status to success
1833:
1834: p_return_status := FND_API.G_RET_STS_SUCCESS;
1835:
1836:
1837: EXCEPTION
1838:

Line 1839: when FND_API.G_EXC_ERROR then

1835:
1836:
1837: EXCEPTION
1838:
1839: when FND_API.G_EXC_ERROR then
1840: p_return_status := FND_API.G_RET_STS_ERROR;
1841:
1842: when FND_API.G_EXC_UNEXPECTED_ERROR then
1843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1840: p_return_status := FND_API.G_RET_STS_ERROR;

1836:
1837: EXCEPTION
1838:
1839: when FND_API.G_EXC_ERROR then
1840: p_return_status := FND_API.G_RET_STS_ERROR;
1841:
1842: when FND_API.G_EXC_UNEXPECTED_ERROR then
1843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844:

Line 1842: when FND_API.G_EXC_UNEXPECTED_ERROR then

1838:
1839: when FND_API.G_EXC_ERROR then
1840: p_return_status := FND_API.G_RET_STS_ERROR;
1841:
1842: when FND_API.G_EXC_UNEXPECTED_ERROR then
1843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844:
1845: when OTHERS then
1846: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1839: when FND_API.G_EXC_ERROR then
1840: p_return_status := FND_API.G_RET_STS_ERROR;
1841:
1842: when FND_API.G_EXC_UNEXPECTED_ERROR then
1843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844:
1845: when OTHERS then
1846: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847:

Line 1846: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1842: when FND_API.G_EXC_UNEXPECTED_ERROR then
1843: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1844:
1845: when OTHERS then
1846: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847:
1848: END Consolidate_Positions;
1849:
1850: /* ----------------------------------------------------------------------- */

Line 1884: l_sp_exists := FND_API.G_FALSE;

1880: -- Loop for all service packages in the local worksheet
1881:
1882: for c_sp_rec in c_sp loop
1883:
1884: l_sp_exists := FND_API.G_FALSE;
1885:
1886: for c_sp_exists_rec in c_sp_exists (c_sp_rec.short_name) loop
1887: l_sp_exists := FND_API.G_TRUE;
1888: end loop;

Line 1887: l_sp_exists := FND_API.G_TRUE;

1883:
1884: l_sp_exists := FND_API.G_FALSE;
1885:
1886: for c_sp_exists_rec in c_sp_exists (c_sp_rec.short_name) loop
1887: l_sp_exists := FND_API.G_TRUE;
1888: end loop;
1889:
1890: if not FND_API.to_Boolean(l_sp_exists) then
1891: begin

Line 1890: if not FND_API.to_Boolean(l_sp_exists) then

1886: for c_sp_exists_rec in c_sp_exists (c_sp_rec.short_name) loop
1887: l_sp_exists := FND_API.G_TRUE;
1888: end loop;
1889:
1890: if not FND_API.to_Boolean(l_sp_exists) then
1891: begin
1892:
1893: for c_sp_seq_rec in c_sp_seq loop
1894: l_service_package_id := c_sp_seq_rec.seq;

Line 1913: p_return_status := FND_API.G_RET_STS_SUCCESS;

1909:
1910:
1911: -- Initialize API return status to success
1912:
1913: p_return_status := FND_API.G_RET_STS_SUCCESS;
1914:
1915: EXCEPTION
1916:
1917: when FND_API.G_EXC_ERROR then

Line 1917: when FND_API.G_EXC_ERROR then

1913: p_return_status := FND_API.G_RET_STS_SUCCESS;
1914:
1915: EXCEPTION
1916:
1917: when FND_API.G_EXC_ERROR then
1918: p_return_status := FND_API.G_RET_STS_ERROR;
1919:
1920: when FND_API.G_EXC_UNEXPECTED_ERROR then
1921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1918: p_return_status := FND_API.G_RET_STS_ERROR;

1914:
1915: EXCEPTION
1916:
1917: when FND_API.G_EXC_ERROR then
1918: p_return_status := FND_API.G_RET_STS_ERROR;
1919:
1920: when FND_API.G_EXC_UNEXPECTED_ERROR then
1921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1922:

Line 1920: when FND_API.G_EXC_UNEXPECTED_ERROR then

1916:
1917: when FND_API.G_EXC_ERROR then
1918: p_return_status := FND_API.G_RET_STS_ERROR;
1919:
1920: when FND_API.G_EXC_UNEXPECTED_ERROR then
1921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1922:
1923: when OTHERS then
1924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1917: when FND_API.G_EXC_ERROR then
1918: p_return_status := FND_API.G_RET_STS_ERROR;
1919:
1920: when FND_API.G_EXC_UNEXPECTED_ERROR then
1921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1922:
1923: when OTHERS then
1924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925:

Line 1924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1920: when FND_API.G_EXC_UNEXPECTED_ERROR then
1921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1922:
1923: when OTHERS then
1924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1925:
1926: END Consolidate_Service_Packages;
1927:
1928: /* ----------------------------------------------------------------------- */

Line 2072: p_check_spal_exists => FND_API.G_FALSE,

2068: (p_api_version => 1.0,
2069: p_return_status => l_return_status,
2070: p_account_line_id => l_account_line_id,
2071: p_worksheet_id => g_global_worksheet_id,
2072: p_check_spal_exists => FND_API.G_FALSE,
2073: p_gl_cutoff_period => null,
2074: p_allocrule_set_id => null,
2075: p_budget_calendar_id => null,
2076: p_rounding_factor => null,

Line 2093: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2089: p_current_stage_seq => c_wal_rec.current_stage_seq,
2090: p_end_stage_seq => c_wal_rec.end_stage_seq,
2091: p_copy_of_account_line_id => null);
2092:
2093: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2094: raise FND_API.G_EXC_ERROR;
2095: end if;
2096:
2097: end loop;

Line 2094: raise FND_API.G_EXC_ERROR;

2090: p_end_stage_seq => c_wal_rec.end_stage_seq,
2091: p_copy_of_account_line_id => null);
2092:
2093: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2094: raise FND_API.G_EXC_ERROR;
2095: end if;
2096:
2097: end loop;
2098:

Line 2125: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2121: p_position_id => l_position_id,
2122: p_budget_group_id => c_wpl_rec.budget_group_id,
2123: p_copy_of_position_line_id => null);
2124:
2125: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2126: raise FND_API.G_EXC_ERROR;
2127: end if;
2128:
2129: for c_wfl_rec in c_wfl (c_wpl_rec.position_line_id) loop

Line 2126: raise FND_API.G_EXC_ERROR;

2122: p_budget_group_id => c_wpl_rec.budget_group_id,
2123: p_copy_of_position_line_id => null);
2124:
2125: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2126: raise FND_API.G_EXC_ERROR;
2127: end if;
2128:
2129: for c_wfl_rec in c_wfl (c_wpl_rec.position_line_id) loop
2130:

Line 2170: p_check_spfl_exists => FND_API.G_FALSE,

2166: PSB_WS_POS1.Create_FTE_Lines
2167: (p_api_version => 1.0,
2168: p_return_status => l_return_status,
2169: p_fte_line_id => l_fte_line_id,
2170: p_check_spfl_exists => FND_API.G_FALSE,
2171: p_worksheet_id => g_global_worksheet_id,
2172: p_position_line_id => l_position_line_id,
2173: p_budget_year_id => c_wfl_rec.budget_year_id,
2174: p_annual_fte => c_wfl_rec.annual_fte,

Line 2182: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2178: p_current_stage_seq => c_wfl_rec.current_stage_seq,
2179: p_end_stage_seq => c_wfl_rec.end_stage_seq,
2180: p_period_fte => l_period_fte);
2181:
2182: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2183: raise FND_API.G_EXC_ERROR;
2184: end if;
2185:
2186: end loop;

Line 2183: raise FND_API.G_EXC_ERROR;

2179: p_end_stage_seq => c_wfl_rec.end_stage_seq,
2180: p_period_fte => l_period_fte);
2181:
2182: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2183: raise FND_API.G_EXC_ERROR;
2184: end if;
2185:
2186: end loop;
2187:

Line 2202: p_check_spel_exists => FND_API.G_FALSE,

2198: PSB_WS_POS1.Create_Element_Lines
2199: (p_api_version => 1.0,
2200: p_return_status => l_return_status,
2201: p_element_line_id => l_element_line_id,
2202: p_check_spel_exists => FND_API.G_FALSE,
2203: p_position_line_id => l_position_line_id,
2204: p_budget_year_id => c_wel_rec.budget_year_id,
2205: p_pay_element_id => l_pay_element_id,
2206: p_currency_code => c_wel_rec.currency_code,

Line 2215: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2211: p_start_stage_seq => c_wel_rec.start_stage_seq,
2212: p_current_stage_seq => c_wel_rec.current_stage_seq,
2213: p_end_stage_seq => c_wel_rec.end_stage_seq);
2214:
2215: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2216: raise FND_API.G_EXC_ERROR;
2217: end if;
2218:
2219: end loop;

Line 2216: raise FND_API.G_EXC_ERROR;

2212: p_current_stage_seq => c_wel_rec.current_stage_seq,
2213: p_end_stage_seq => c_wel_rec.end_stage_seq);
2214:
2215: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2216: raise FND_API.G_EXC_ERROR;
2217: end if;
2218:
2219: end loop;
2220:

Line 2263: p_check_spal_exists => FND_API.G_FALSE,

2259: (p_api_version => 1.0,
2260: p_return_status => l_return_status,
2261: p_account_line_id => l_account_line_id,
2262: p_worksheet_id => g_global_worksheet_id,
2263: p_check_spal_exists => FND_API.G_FALSE,
2264: p_gl_cutoff_period => null,
2265: p_allocrule_set_id => null,
2266: p_budget_calendar_id => null,
2267: p_rounding_factor => null,

Line 2284: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2280: p_start_stage_seq => c_wal_rec.start_stage_seq,
2281: p_current_stage_seq => c_wal_rec.current_stage_seq,
2282: p_end_stage_seq => c_wal_rec.end_stage_seq);
2283:
2284: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2285: raise FND_API.G_EXC_ERROR;
2286: end if;
2287:
2288: end loop;

Line 2285: raise FND_API.G_EXC_ERROR;

2281: p_current_stage_seq => c_wal_rec.current_stage_seq,
2282: p_end_stage_seq => c_wal_rec.end_stage_seq);
2283:
2284: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2285: raise FND_API.G_EXC_ERROR;
2286: end if;
2287:
2288: end loop;
2289:

Line 2298: p_return_status := FND_API.G_RET_STS_SUCCESS;

2294:
2295:
2296: -- Initialize API return status to success
2297:
2298: p_return_status := FND_API.G_RET_STS_SUCCESS;
2299:
2300:
2301: EXCEPTION
2302:

Line 2303: when FND_API.G_EXC_ERROR then

2299:
2300:
2301: EXCEPTION
2302:
2303: when FND_API.G_EXC_ERROR then
2304: p_return_status := FND_API.G_RET_STS_ERROR;
2305:
2306: when FND_API.G_EXC_UNEXPECTED_ERROR then
2307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2304: p_return_status := FND_API.G_RET_STS_ERROR;

2300:
2301: EXCEPTION
2302:
2303: when FND_API.G_EXC_ERROR then
2304: p_return_status := FND_API.G_RET_STS_ERROR;
2305:
2306: when FND_API.G_EXC_UNEXPECTED_ERROR then
2307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2308:

Line 2306: when FND_API.G_EXC_UNEXPECTED_ERROR then

2302:
2303: when FND_API.G_EXC_ERROR then
2304: p_return_status := FND_API.G_RET_STS_ERROR;
2305:
2306: when FND_API.G_EXC_UNEXPECTED_ERROR then
2307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2308:
2309: when OTHERS then
2310: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2303: when FND_API.G_EXC_ERROR then
2304: p_return_status := FND_API.G_RET_STS_ERROR;
2305:
2306: when FND_API.G_EXC_UNEXPECTED_ERROR then
2307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2308:
2309: when OTHERS then
2310: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2311:

Line 2310: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2306: when FND_API.G_EXC_UNEXPECTED_ERROR then
2307: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2308:
2309: when OTHERS then
2310: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2311:
2312: END Consolidate_Local_Worksheets;
2313:
2314: /* ----------------------------------------------------------------------- */

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

2314: /* ----------------------------------------------------------------------- */
2315:
2316: PROCEDURE Consolidate_Worksheets
2317: ( p_api_version IN NUMBER,
2318: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
2319: p_return_status OUT NOCOPY VARCHAR2,
2320: p_global_worksheet_id IN NUMBER
2321: ) IS
2322:

Line 2359: if not FND_API.Compatible_API_Call (l_api_version,

2355: BEGIN
2356:
2357: -- Standard call to check for call compatibility.
2358:
2359: if not FND_API.Compatible_API_Call (l_api_version,
2360: p_api_version,
2361: l_api_name,
2362: G_PKG_NAME)
2363: then

Line 2364: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2360: p_api_version,
2361: l_api_name,
2362: G_PKG_NAME)
2363: then
2364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2365: end if;
2366:
2367: PSB_WORKSHEET.Update_Worksheet
2368: (p_api_version => 1.0,

Line 2373: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2369: p_return_status => l_return_status,
2370: p_worksheet_id => p_global_worksheet_id,
2371: p_ws_creation_complete => 'N');
2372:
2373: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2374: raise FND_API.G_EXC_ERROR;
2375: end if;
2376:
2377: commit work;

Line 2374: raise FND_API.G_EXC_ERROR;

2370: p_worksheet_id => p_global_worksheet_id,
2371: p_ws_creation_complete => 'N');
2372:
2373: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2374: raise FND_API.G_EXC_ERROR;
2375: end if;
2376:
2377: commit work;
2378:

Line 2388: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2384: p_concurrency_class => 'WORKSHEET_CONSOLIDATION',
2385: p_concurrency_entity_name => 'WORKSHEET',
2386: p_concurrency_entity_id => p_global_worksheet_id);
2387:
2388: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2389: raise FND_API.G_EXC_ERROR;
2390: end if;
2391:
2392: for c_Global_WS_Rec in c_Global_WS loop

Line 2389: raise FND_API.G_EXC_ERROR;

2385: p_concurrency_entity_name => 'WORKSHEET',
2386: p_concurrency_entity_id => p_global_worksheet_id);
2387:
2388: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2389: raise FND_API.G_EXC_ERROR;
2390: end if;
2391:
2392: for c_Global_WS_Rec in c_Global_WS loop
2393: g_global_data_extract_id := c_Global_WS_Rec.data_extract_id;

Line 2416: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2412: p_concurrency_class => 'WORKSHEET_CONSOLIDATION',
2413: p_concurrency_entity_name => 'DATA_EXTRACT',
2414: p_concurrency_entity_id => c_Local_WS_Rec.data_extract_id);
2415:
2416: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2417: raise FND_API.G_EXC_ERROR;
2418: end if;
2419:
2420: Consolidate_Attributes

Line 2417: raise FND_API.G_EXC_ERROR;

2413: p_concurrency_entity_name => 'DATA_EXTRACT',
2414: p_concurrency_entity_id => c_Local_WS_Rec.data_extract_id);
2415:
2416: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2417: raise FND_API.G_EXC_ERROR;
2418: end if;
2419:
2420: Consolidate_Attributes
2421: (p_return_status => l_return_status,

Line 2425: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2421: (p_return_status => l_return_status,
2422: p_local_data_extract_id => c_Local_WS_Rec.data_extract_id,
2423: p_local_business_group_id => c_Local_WS_Rec.business_group_id);
2424:
2425: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2426: raise FND_API.G_EXC_ERROR;
2427: end if;
2428:
2429: Consolidate_Elements

Line 2426: raise FND_API.G_EXC_ERROR;

2422: p_local_data_extract_id => c_Local_WS_Rec.data_extract_id,
2423: p_local_business_group_id => c_Local_WS_Rec.business_group_id);
2424:
2425: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2426: raise FND_API.G_EXC_ERROR;
2427: end if;
2428:
2429: Consolidate_Elements
2430: (p_return_status => l_return_status,

Line 2435: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2431: p_local_worksheet_id => c_Local_WS_Rec.local_worksheet_id,
2432: p_local_data_extract_id => c_Local_WS_Rec.data_extract_id,
2433: p_local_business_group_id => c_Local_WS_Rec.business_group_id);
2434:
2435: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2436: raise FND_API.G_EXC_ERROR;
2437: end if;
2438:
2439: Consolidate_Employees

Line 2436: raise FND_API.G_EXC_ERROR;

2432: p_local_data_extract_id => c_Local_WS_Rec.data_extract_id,
2433: p_local_business_group_id => c_Local_WS_Rec.business_group_id);
2434:
2435: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2436: raise FND_API.G_EXC_ERROR;
2437: end if;
2438:
2439: Consolidate_Employees
2440: (p_return_status => l_return_status,

Line 2444: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2440: (p_return_status => l_return_status,
2441: p_local_data_extract_id => c_Local_WS_Rec.data_extract_id,
2442: p_local_business_group_id => c_Local_WS_Rec.business_group_id);
2443:
2444: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2445: raise FND_API.G_EXC_ERROR;
2446: end if;
2447:
2448: Consolidate_Positions

Line 2445: raise FND_API.G_EXC_ERROR;

2441: p_local_data_extract_id => c_Local_WS_Rec.data_extract_id,
2442: p_local_business_group_id => c_Local_WS_Rec.business_group_id);
2443:
2444: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2445: raise FND_API.G_EXC_ERROR;
2446: end if;
2447:
2448: Consolidate_Positions
2449: (p_return_status => l_return_status,

Line 2454: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2450: p_local_worksheet_id => c_Local_WS_Rec.local_worksheet_id,
2451: p_local_data_extract_id => c_Local_WS_Rec.data_extract_id,
2452: p_local_business_group_id => c_Local_WS_Rec.business_group_id);
2453:
2454: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2455: raise FND_API.G_EXC_ERROR;
2456: end if;
2457:
2458: commit work;

Line 2455: raise FND_API.G_EXC_ERROR;

2451: p_local_data_extract_id => c_Local_WS_Rec.data_extract_id,
2452: p_local_business_group_id => c_Local_WS_Rec.business_group_id);
2453:
2454: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2455: raise FND_API.G_EXC_ERROR;
2456: end if;
2457:
2458: commit work;
2459:

Line 2471: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2467: p_msg_count => l_msg_count,
2468: p_msg_data => l_msg_data,
2469: p_data_extract_id => g_global_data_extract_id);
2470:
2471: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2472: raise FND_API.G_EXC_ERROR;
2473: end if;
2474:
2475: -- In the second phase consolidate the service packages for all local worksheets

Line 2472: raise FND_API.G_EXC_ERROR;

2468: p_msg_data => l_msg_data,
2469: p_data_extract_id => g_global_data_extract_id);
2470:
2471: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2472: raise FND_API.G_EXC_ERROR;
2473: end if;
2474:
2475: -- In the second phase consolidate the service packages for all local worksheets
2476:

Line 2488: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2484: p_concurrency_class => 'WORKSHEET_CONSOLIDATION',
2485: p_concurrency_entity_name => 'WORKSHEET',
2486: p_concurrency_entity_id => c_Local_WS_Rec.local_worksheet_id);
2487:
2488: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2489: raise FND_API.G_EXC_ERROR;
2490: end if;
2491:
2492: Consolidate_Service_Packages

Line 2489: raise FND_API.G_EXC_ERROR;

2485: p_concurrency_entity_name => 'WORKSHEET',
2486: p_concurrency_entity_id => c_Local_WS_Rec.local_worksheet_id);
2487:
2488: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2489: raise FND_API.G_EXC_ERROR;
2490: end if;
2491:
2492: Consolidate_Service_Packages
2493: (p_return_status => l_return_status,

Line 2496: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2492: Consolidate_Service_Packages
2493: (p_return_status => l_return_status,
2494: p_local_worksheet_id => c_Local_WS_Rec.local_worksheet_id);
2495:
2496: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2497: raise FND_API.G_EXC_ERROR;
2498: end if;
2499:
2500: commit work;

Line 2497: raise FND_API.G_EXC_ERROR;

2493: (p_return_status => l_return_status,
2494: p_local_worksheet_id => c_Local_WS_Rec.local_worksheet_id);
2495:
2496: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2497: raise FND_API.G_EXC_ERROR;
2498: end if;
2499:
2500: commit work;
2501:

Line 2517: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2513: p_concurrency_class => 'WORKSHEET_CONSOLIDATION',
2514: p_concurrency_entity_name => 'WORKSHEET',
2515: p_concurrency_entity_id => c_Local_WS_Rec.local_worksheet_id);
2516:
2517: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2518: raise FND_API.G_EXC_ERROR;
2519: end if;
2520:
2521: Consolidate_Local_Worksheets

Line 2518: raise FND_API.G_EXC_ERROR;

2514: p_concurrency_entity_name => 'WORKSHEET',
2515: p_concurrency_entity_id => c_Local_WS_Rec.local_worksheet_id);
2516:
2517: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2518: raise FND_API.G_EXC_ERROR;
2519: end if;
2520:
2521: Consolidate_Local_Worksheets
2522: (p_return_status => l_return_status,

Line 2526: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2522: (p_return_status => l_return_status,
2523: p_local_worksheet_id => c_Local_WS_Rec.local_worksheet_id,
2524: p_global_worksheet_id => p_global_worksheet_id);
2525:
2526: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2527: raise FND_API.G_EXC_ERROR;
2528: end if;
2529:
2530: commit work;

Line 2527: raise FND_API.G_EXC_ERROR;

2523: p_local_worksheet_id => c_Local_WS_Rec.local_worksheet_id,
2524: p_global_worksheet_id => p_global_worksheet_id);
2525:
2526: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2527: raise FND_API.G_EXC_ERROR;
2528: end if;
2529:
2530: commit work;
2531:

Line 2540: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2536: p_return_status => l_return_status,
2537: p_worksheet_id => p_global_worksheet_id,
2538: p_ws_creation_complete => 'Y');
2539:
2540: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2541: raise FND_API.G_EXC_ERROR;
2542: end if;
2543:
2544: -- Initialize API return status to success

Line 2541: raise FND_API.G_EXC_ERROR;

2537: p_worksheet_id => p_global_worksheet_id,
2538: p_ws_creation_complete => 'Y');
2539:
2540: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2541: raise FND_API.G_EXC_ERROR;
2542: end if;
2543:
2544: -- Initialize API return status to success
2545:

Line 2546: p_return_status := FND_API.G_RET_STS_SUCCESS;

2542: end if;
2543:
2544: -- Initialize API return status to success
2545:
2546: p_return_status := FND_API.G_RET_STS_SUCCESS;
2547:
2548:
2549: EXCEPTION
2550:

Line 2551: when FND_API.G_EXC_ERROR then

2547:
2548:
2549: EXCEPTION
2550:
2551: when FND_API.G_EXC_ERROR then
2552: p_return_status := FND_API.G_RET_STS_ERROR;
2553:
2554: when FND_API.G_EXC_UNEXPECTED_ERROR then
2555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2552: p_return_status := FND_API.G_RET_STS_ERROR;

2548:
2549: EXCEPTION
2550:
2551: when FND_API.G_EXC_ERROR then
2552: p_return_status := FND_API.G_RET_STS_ERROR;
2553:
2554: when FND_API.G_EXC_UNEXPECTED_ERROR then
2555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556:

Line 2554: when FND_API.G_EXC_UNEXPECTED_ERROR then

2550:
2551: when FND_API.G_EXC_ERROR then
2552: p_return_status := FND_API.G_RET_STS_ERROR;
2553:
2554: when FND_API.G_EXC_UNEXPECTED_ERROR then
2555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556:
2557: when OTHERS then
2558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2551: when FND_API.G_EXC_ERROR then
2552: p_return_status := FND_API.G_RET_STS_ERROR;
2553:
2554: when FND_API.G_EXC_UNEXPECTED_ERROR then
2555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556:
2557: when OTHERS then
2558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559:

Line 2558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2554: when FND_API.G_EXC_UNEXPECTED_ERROR then
2555: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556:
2557: when OTHERS then
2558: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559:
2560: if FND_MSG_PUB.Check_Msg_Level
2561: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2562: FND_MSG_PUB.Add_Exc_Msg

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

2569: /* ----------------------------------------------------------------------- */
2570:
2571: PROCEDURE Validate_Consolidation
2572: ( p_api_version IN NUMBER,
2573: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
2574: p_return_status OUT NOCOPY VARCHAR2,
2575: p_global_worksheet_id IN NUMBER
2576: ) IS
2577:

Line 2638: if not FND_API.Compatible_API_Call (l_api_version,

2634: BEGIN
2635:
2636: -- Standard call to check for call compatibility.
2637:
2638: if not FND_API.Compatible_API_Call (l_api_version,
2639: p_api_version,
2640: l_api_name,
2641: G_PKG_NAME)
2642: then

Line 2643: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2639: p_api_version,
2640: l_api_name,
2641: G_PKG_NAME)
2642: then
2643: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2644: end if;
2645:
2646: for c_Global_WS_Rec in c_Global_WS loop
2647: l_freeze_flag := c_Global_WS_Rec.freeze_flag;

Line 2658: raise FND_API.G_EXC_ERROR;

2654: end loop;
2655:
2656: if l_freeze_flag = 'Y' then
2657: add_message('PSB', 'PSB_TARGET_WORKSHEET_IS_FROZEN');
2658: raise FND_API.G_EXC_ERROR;
2659: end if;
2660:
2661: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2662: begin

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

2657: add_message('PSB', 'PSB_TARGET_WORKSHEET_IS_FROZEN');
2658: raise FND_API.G_EXC_ERROR;
2659: end if;
2660:
2661: if l_budget_calendar_id <> nvl(PSB_WS_ACCT1.g_budget_calendar_id, FND_API.G_MISS_NUM) then
2662: begin
2663:
2664: PSB_WS_ACCT1.Cache_Budget_Calendar
2665: (p_return_status => l_return_status,

Line 2668: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

2664: PSB_WS_ACCT1.Cache_Budget_Calendar
2665: (p_return_status => l_return_status,
2666: p_budget_calendar_id => l_budget_calendar_id);
2667:
2668: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2669: raise FND_API.G_EXC_ERROR;
2670: end if;
2671:
2672: end;

Line 2669: raise FND_API.G_EXC_ERROR;

2665: (p_return_status => l_return_status,
2666: p_budget_calendar_id => l_budget_calendar_id);
2667:
2668: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2669: raise FND_API.G_EXC_ERROR;
2670: end if;
2671:
2672: end;
2673: end if;

Line 2682: raise FND_API.G_EXC_ERROR;

2678:
2679: if c_Local_WS_Rec.global_worksheet_flag <> 'Y' then
2680: message_token('WORKSHEET', c_Local_WS_Rec.name);
2681: add_message('PSB', 'PSB_CONS_NOT_GLOBAL');
2682: raise FND_API.G_EXC_ERROR;
2683: end if;
2684:
2685: -- Check that the stage set of every local worksheet matches the global worksheet
2686:

Line 2690: raise FND_API.G_EXC_ERROR;

2686:
2687: if c_Local_WS_Rec.stage_set_id <> l_stage_set_id then
2688: message_token('WORKSHEET', c_Local_WS_Rec.name);
2689: add_message('PSB', 'PSB_CONS_MISMATCH_STAGESET');
2690: raise FND_API.G_EXC_ERROR;
2691: end if;
2692:
2693: -- Check that the current stage sequence of every local worksheet matches the global worksheet
2694:

Line 2698: raise FND_API.G_EXC_ERROR;

2694:
2695: if c_Local_WS_Rec.current_stage_seq <> l_current_stage_seq then
2696: message_token('WORKSHEET', c_Local_WS_Rec.name);
2697: add_message('PSB', 'PSB_CONS_MISMATCH_STAGESEQ');
2698: raise FND_API.G_EXC_ERROR;
2699: end if;
2700:
2701: -- Check that the set of books for every local worksheet matches the global worksheet
2702:

Line 2706: raise FND_API.G_EXC_ERROR;

2702:
2703: if c_Local_WS_Rec.set_of_books_id <> l_set_of_books_id then
2704: message_token('WORKSHEET', c_Local_WS_Rec.name);
2705: add_message('PSB', 'PSB_CONS_MISMATCH_SOB');
2706: raise FND_API.G_EXC_ERROR;
2707: end if;
2708:
2709: -- Check that the budget calendar of every local worksheet matches the global worksheet
2710:

Line 2714: raise FND_API.G_EXC_ERROR;

2710:
2711: if c_Local_WS_Rec.budget_calendar_id <> l_budget_calendar_id then
2712: message_token('WORKSHEET', c_Local_WS_Rec.name);
2713: add_message('PSB', 'PSB_CONS_MISMATCH_CAL');
2714: raise FND_API.G_EXC_ERROR;
2715: end if;
2716:
2717: -- Check that position worksheets are not consolidated into a line-item global worksheet
2718:

Line 2722: raise FND_API.G_EXC_ERROR;

2718:
2719: if ((l_budget_by_position = 'N') and (c_Local_WS_Rec.budget_by_position <> l_budget_by_position)) then
2720: message_token('WORKSHEET', c_Local_WS_Rec.name);
2721: add_message('PSB', 'PSB_CONS_MISMATCH_POS');
2722: raise FND_API.G_EXC_ERROR;
2723: end if;
2724:
2725: -- Check that the budget group of every local worksheet belongs to the global worksheet budget group hierarchy
2726:

Line 2727: l_budget_group_exists := FND_API.G_FALSE;

2723: end if;
2724:
2725: -- Check that the budget group of every local worksheet belongs to the global worksheet budget group hierarchy
2726:
2727: l_budget_group_exists := FND_API.G_FALSE;
2728:
2729: for c_BudGrp_Rec in c_BudGrp (c_Local_WS_Rec.budget_group_id) loop
2730: l_budget_group_exists := FND_API.G_TRUE;
2731: end loop;

Line 2730: l_budget_group_exists := FND_API.G_TRUE;

2726:
2727: l_budget_group_exists := FND_API.G_FALSE;
2728:
2729: for c_BudGrp_Rec in c_BudGrp (c_Local_WS_Rec.budget_group_id) loop
2730: l_budget_group_exists := FND_API.G_TRUE;
2731: end loop;
2732:
2733: if not FND_API.to_Boolean(l_budget_group_exists) then
2734: begin

Line 2733: if not FND_API.to_Boolean(l_budget_group_exists) then

2729: for c_BudGrp_Rec in c_BudGrp (c_Local_WS_Rec.budget_group_id) loop
2730: l_budget_group_exists := FND_API.G_TRUE;
2731: end loop;
2732:
2733: if not FND_API.to_Boolean(l_budget_group_exists) then
2734: begin
2735:
2736: if c_Local_WS_Rec.budget_group_id <> l_budget_group_id then
2737: message_token('WORKSHEET', c_Local_WS_Rec.name);

Line 2739: raise FND_API.G_EXC_ERROR;

2735:
2736: if c_Local_WS_Rec.budget_group_id <> l_budget_group_id then
2737: message_token('WORKSHEET', c_Local_WS_Rec.name);
2738: add_message('PSB', 'PSB_CONS_MISMATCH_BGH');
2739: raise FND_API.G_EXC_ERROR;
2740: end if;
2741:
2742: end;
2743: end if;

Line 2750: p_return_status := FND_API.G_RET_STS_SUCCESS;

2746:
2747:
2748: -- Initialize API return status to success
2749:
2750: p_return_status := FND_API.G_RET_STS_SUCCESS;
2751:
2752:
2753: EXCEPTION
2754:

Line 2755: when FND_API.G_EXC_ERROR then

2751:
2752:
2753: EXCEPTION
2754:
2755: when FND_API.G_EXC_ERROR then
2756: p_return_status := FND_API.G_RET_STS_ERROR;
2757:
2758: when FND_API.G_EXC_UNEXPECTED_ERROR then
2759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2756: p_return_status := FND_API.G_RET_STS_ERROR;

2752:
2753: EXCEPTION
2754:
2755: when FND_API.G_EXC_ERROR then
2756: p_return_status := FND_API.G_RET_STS_ERROR;
2757:
2758: when FND_API.G_EXC_UNEXPECTED_ERROR then
2759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760:

Line 2758: when FND_API.G_EXC_UNEXPECTED_ERROR then

2754:
2755: when FND_API.G_EXC_ERROR then
2756: p_return_status := FND_API.G_RET_STS_ERROR;
2757:
2758: when FND_API.G_EXC_UNEXPECTED_ERROR then
2759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760:
2761: when OTHERS then
2762: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2755: when FND_API.G_EXC_ERROR then
2756: p_return_status := FND_API.G_RET_STS_ERROR;
2757:
2758: when FND_API.G_EXC_UNEXPECTED_ERROR then
2759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760:
2761: when OTHERS then
2762: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763:

Line 2762: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2758: when FND_API.G_EXC_UNEXPECTED_ERROR then
2759: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2760:
2761: when OTHERS then
2762: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763:
2764: if FND_MSG_PUB.Check_Msg_Level
2765: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2766: FND_MSG_PUB.Add_Exc_Msg