33:
34: -- Initialize message list if p_init_msg_list is set to TRUE
35:
36: if FND_API.to_Boolean (p_init_msg_list) then
37: FND_MSG_PUB.initialize;
38: end if;
39:
40:
41: -- Call Private Function
48:
49:
50: -- Standard call to get message count and if count is 1, get message info
51:
52: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
53: p_data => p_msg_data);
54:
55:
56: EXCEPTION
57:
58: when FND_API.G_EXC_ERROR then
59: return FND_API.G_FALSE;
60:
61: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
62: p_data => p_msg_data);
63:
64:
65: when FND_API.G_EXC_UNEXPECTED_ERROR then
64:
65: when FND_API.G_EXC_UNEXPECTED_ERROR then
66: return FND_API.G_FALSE;
67:
68: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
69: p_data => p_msg_data);
70:
71:
72: when OTHERS then
71:
72: when OTHERS then
73: return FND_API.G_FALSE;
74:
75: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
76: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
77: l_api_name);
78: end if;
79:
72: when OTHERS then
73: return FND_API.G_FALSE;
74:
75: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
76: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
77: l_api_name);
78: end if;
79:
80: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
76: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
77: l_api_name);
78: end if;
79:
80: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
81: p_data => p_msg_data);
82:
83: END Check_Allowed;
84:
122:
123: -- Initialize message list if p_init_msg_list is set to TRUE
124:
125: if FND_API.to_Boolean (p_init_msg_list) then
126: FND_MSG_PUB.initialize;
127: end if;
128:
129:
130: -- Call Private Function
148:
149:
150: -- Standard call to get message count and if count is 1, get message info
151:
152: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
153: p_data => p_msg_data);
154:
155:
156: EXCEPTION
158: when FND_API.G_EXC_ERROR then
159: rollback to Create_Position_Lines_Pvt;
160: p_return_status := FND_API.G_RET_STS_ERROR;
161:
162: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
163: p_data => p_msg_data);
164:
165:
166: when FND_API.G_EXC_UNEXPECTED_ERROR then
166: when FND_API.G_EXC_UNEXPECTED_ERROR then
167: rollback to Create_Position_Lines_Pvt;
168: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169:
170: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
171: p_data => p_msg_data);
172:
173:
174: when OTHERS then
174: when OTHERS then
175: rollback to Create_Position_Lines_Pvt;
176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177:
178: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
179: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
180: l_api_name);
181: end if;
182:
175: rollback to Create_Position_Lines_Pvt;
176: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177:
178: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
179: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
180: l_api_name);
181: end if;
182:
183: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
179: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
180: l_api_name);
181: end if;
182:
183: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
184: p_data => p_msg_data);
185:
186: END Create_Position_Lines;
187:
224:
225: -- Initialize message list if p_init_msg_list is set to TRUE
226:
227: if FND_API.to_Boolean (p_init_msg_list) then
228: FND_MSG_PUB.initialize;
229: end if;
230:
231:
232: -- Call Private Function
249:
250:
251: -- Standard call to get message count and if count is 1, get message info
252:
253: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
254: p_data => p_msg_data);
255:
256:
257: EXCEPTION
259: when FND_API.G_EXC_ERROR then
260: rollback to Create_Position_Matrix_Pvt;
261: p_return_status := FND_API.G_RET_STS_ERROR;
262:
263: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
264: p_data => p_msg_data);
265:
266:
267: when FND_API.G_EXC_UNEXPECTED_ERROR then
267: when FND_API.G_EXC_UNEXPECTED_ERROR then
268: rollback to Create_Position_Matrix_Pvt;
269: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270:
271: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
272: p_data => p_msg_data);
273:
274:
275: when OTHERS then
275: when OTHERS then
276: rollback to Create_Position_Matrix_Pvt;
277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:
279: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
280: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
281: l_api_name);
282: end if;
283:
276: rollback to Create_Position_Matrix_Pvt;
277: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:
279: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
280: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
281: l_api_name);
282: end if;
283:
284: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
280: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
281: l_api_name);
282: end if;
283:
284: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
285: p_data => p_msg_data);
286:
287: END Create_Position_Matrix;
288:
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE
338:
339: if FND_API.to_Boolean (p_init_msg_list) then
340: FND_MSG_PUB.initialize;
341: end if;
342:
343:
344: -- Call Private Function
372:
373:
374: -- Standard call to get message count and if count is 1, get message info
375:
376: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
377: p_data => p_msg_data);
378:
379:
380: EXCEPTION
382: when FND_API.G_EXC_ERROR then
383: rollback to Create_FTE_Lines_Pvt;
384: p_return_status := FND_API.G_RET_STS_ERROR;
385:
386: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
387: p_data => p_msg_data);
388:
389:
390: when FND_API.G_EXC_UNEXPECTED_ERROR then
390: when FND_API.G_EXC_UNEXPECTED_ERROR then
391: rollback to Create_FTE_Lines_Pvt;
392: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393:
394: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
395: p_data => p_msg_data);
396:
397:
398: when OTHERS then
398: when OTHERS then
399: rollback to Create_FTE_Lines_Pvt;
400: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401:
402: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
403: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
404: l_api_name);
405: end if;
406:
399: rollback to Create_FTE_Lines_Pvt;
400: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401:
402: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
403: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
404: l_api_name);
405: end if;
406:
407: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
403: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
404: l_api_name);
405: end if;
406:
407: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
408: p_data => p_msg_data);
409:
410: END Create_FTE_Lines;
411:
507:
508: -- Initialize message list if p_init_msg_list is set to TRUE
509:
510: if FND_API.to_Boolean (p_init_msg_list) then
511: FND_MSG_PUB.initialize;
512: end if;
513:
514:
515: /* Bug 4379636 Start */
568:
569:
570: -- Standard call to get message count and if count is 1, get message info
571:
572: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
573: p_data => p_msg_data);
574:
575:
576: EXCEPTION
578: when FND_API.G_EXC_ERROR then
579: rollback to Create_FTE_Lines_Pvt;
580: p_return_status := FND_API.G_RET_STS_ERROR;
581:
582: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
583: p_data => p_msg_data);
584:
585:
586: when FND_API.G_EXC_UNEXPECTED_ERROR then
586: when FND_API.G_EXC_UNEXPECTED_ERROR then
587: rollback to Create_FTE_Lines_Pvt;
588: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589:
590: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
591: p_data => p_msg_data);
592:
593:
594: when OTHERS then
594: when OTHERS then
595: rollback to Create_FTE_Lines_Pvt;
596: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597:
598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
599: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
600: l_api_name);
601: end if;
602:
595: rollback to Create_FTE_Lines_Pvt;
596: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597:
598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
599: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
600: l_api_name);
601: end if;
602:
603: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
599: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
600: l_api_name);
601: end if;
602:
603: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
604: p_data => p_msg_data);
605:
606: END Create_FTE_Lines;
607:
653:
654: -- Initialize message list if p_init_msg_list is set to TRUE
655:
656: if FND_API.to_Boolean (p_init_msg_list) then
657: FND_MSG_PUB.initialize;
658: end if;
659:
660:
661: -- Call Private Function
686:
687:
688: -- Standard call to get message count and if count is 1, get message info
689:
690: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
691: p_data => p_msg_data);
692:
693:
694: EXCEPTION
696: when FND_API.G_EXC_ERROR then
697: rollback to Create_Element_Lines_Pvt;
698: p_return_status := FND_API.G_RET_STS_ERROR;
699:
700: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
701: p_data => p_msg_data);
702:
703:
704: when FND_API.G_EXC_UNEXPECTED_ERROR then
704: when FND_API.G_EXC_UNEXPECTED_ERROR then
705: rollback to Create_Element_Lines_Pvt;
706: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707:
708: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
709: p_data => p_msg_data);
710:
711:
712: when OTHERS then
712: when OTHERS then
713: rollback to Create_Element_Lines_Pvt;
714: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715:
716: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
717: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
718: l_api_name);
719: end if;
720:
713: rollback to Create_Element_Lines_Pvt;
714: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715:
716: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
717: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
718: l_api_name);
719: end if;
720:
721: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
717: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
718: l_api_name);
719: end if;
720:
721: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
722: p_data => p_msg_data);
723:
724: END Create_Element_Lines;
725:
763:
764: -- Initialize message list if p_init_msg_list is set to TRUE
765:
766: if FND_API.to_Boolean (p_init_msg_list) then
767: FND_MSG_PUB.initialize;
768: end if;
769:
770:
771: -- Call Private Function
789:
790:
791: -- Standard call to get message count and if count is 1, get message info
792:
793: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
794: p_data => p_msg_data);
795:
796:
797: EXCEPTION
799: when FND_API.G_EXC_ERROR then
800: rollback to Create_Element_Lines_Pvt;
801: p_return_status := FND_API.G_RET_STS_ERROR;
802:
803: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
804: p_data => p_msg_data);
805:
806:
807: when FND_API.G_EXC_UNEXPECTED_ERROR then
807: when FND_API.G_EXC_UNEXPECTED_ERROR then
808: rollback to Create_Element_Lines_Pvt;
809: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810:
811: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
812: p_data => p_msg_data);
813:
814:
815: when OTHERS then
815: when OTHERS then
816: rollback to Create_Element_Lines_Pvt;
817: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818:
819: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
820: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
821: l_api_name);
822: end if;
823:
816: rollback to Create_Element_Lines_Pvt;
817: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818:
819: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
820: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
821: l_api_name);
822: end if;
823:
824: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
820: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
821: l_api_name);
822: end if;
823:
824: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
825: p_data => p_msg_data);
826:
827: END Create_Element_Lines;
828:
868:
869: -- Initialize message list if p_init_msg_list is set to TRUE
870:
871: if FND_API.to_Boolean (p_init_msg_list) then
872: FND_MSG_PUB.initialize;
873: end if;
874:
875:
876: -- Call Private Function
896:
897:
898: -- Standard call to get message count and if count is 1, get message info
899:
900: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
901: p_data => p_msg_data);
902:
903:
904: EXCEPTION
906: when FND_API.G_EXC_ERROR then
907: rollback to Update_Annual_FTE_Pvt;
908: p_return_status := FND_API.G_RET_STS_ERROR;
909:
910: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
911: p_data => p_msg_data);
912:
913:
914: when FND_API.G_EXC_UNEXPECTED_ERROR then
914: when FND_API.G_EXC_UNEXPECTED_ERROR then
915: rollback to Update_Annual_FTE_Pvt;
916: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917:
918: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
919: p_data => p_msg_data);
920:
921:
922: when OTHERS then
922: when OTHERS then
923: rollback to Update_Annual_FTE_Pvt;
924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925:
926: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
927: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
928: l_api_name);
929: end if;
930:
923: rollback to Update_Annual_FTE_Pvt;
924: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
925:
926: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
927: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
928: l_api_name);
929: end if;
930:
931: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
927: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
928: l_api_name);
929: end if;
930:
931: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
932: p_data => p_msg_data);
933:
934: END Update_Annual_FTE;
935:
974:
975: -- Initialize message list if p_init_msg_list is set to TRUE
976:
977: if FND_API.to_Boolean (p_init_msg_list) then
978: FND_MSG_PUB.initialize;
979: end if;
980:
981:
982: -- Call Private Function
1001:
1002:
1003: -- Standard call to get message count and if count is 1, get message info
1004:
1005: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1006: p_data => p_msg_data);
1007:
1008:
1009: EXCEPTION
1011: when FND_API.G_EXC_ERROR then
1012: rollback to Redistribute_Follow_Salary_Pvt;
1013: p_return_status := FND_API.G_RET_STS_ERROR;
1014:
1015: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1016: p_data => p_msg_data);
1017:
1018:
1019: when FND_API.G_EXC_UNEXPECTED_ERROR then
1019: when FND_API.G_EXC_UNEXPECTED_ERROR then
1020: rollback to Redistribute_Follow_Salary_Pvt;
1021: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1022:
1023: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1024: p_data => p_msg_data);
1025:
1026:
1027: when OTHERS then
1027: when OTHERS then
1028: rollback to Redistribute_Follow_Salary_Pvt;
1029: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030:
1031: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1032: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1033: l_api_name);
1034: end if;
1035:
1028: rollback to Redistribute_Follow_Salary_Pvt;
1029: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030:
1031: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1032: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1033: l_api_name);
1034: end if;
1035:
1036: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1032: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1033: l_api_name);
1034: end if;
1035:
1036: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1037: p_data => p_msg_data);
1038:
1039: END Redistribute_Follow_Salary;
1040:
1081:
1082: -- Initialize message list if p_init_msg_list is set to TRUE
1083:
1084: if FND_API.to_Boolean (p_init_msg_list) then
1085: FND_MSG_PUB.initialize;
1086: end if;
1087:
1088:
1089: -- Call Private Function
1110:
1111:
1112: -- Standard call to get message count and if count is 1, get message info
1113:
1114: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1115: p_data => p_msg_data);
1116:
1117:
1118: EXCEPTION
1120: when FND_API.G_EXC_ERROR then
1121: rollback to Apply_Element_Parameters_Pvt;
1122: p_return_status := FND_API.G_RET_STS_ERROR;
1123:
1124: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1125: p_data => p_msg_data);
1126:
1127:
1128: when FND_API.G_EXC_UNEXPECTED_ERROR then
1128: when FND_API.G_EXC_UNEXPECTED_ERROR then
1129: rollback to Apply_Element_Parameters_Pvt;
1130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131:
1132: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1133: p_data => p_msg_data);
1134:
1135:
1136: when OTHERS then
1136: when OTHERS then
1137: rollback to Apply_Element_Parameters_Pvt;
1138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139:
1140: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1141: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1142: l_api_name);
1143: end if;
1144:
1137: rollback to Apply_Element_Parameters_Pvt;
1138: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139:
1140: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1141: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1142: l_api_name);
1143: end if;
1144:
1145: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1141: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1142: l_api_name);
1143: end if;
1144:
1145: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1146: p_data => p_msg_data);
1147:
1148: END Apply_Element_Parameters;
1149:
1190:
1191: -- Initialize message list if p_init_msg_list is set to TRUE
1192:
1193: if FND_API.to_Boolean (p_init_msg_list) then
1194: FND_MSG_PUB.initialize;
1195: end if;
1196:
1197:
1198: -- Call Private Function
1219:
1220:
1221: -- Standard call to get message count and if count is 1, get message info
1222:
1223: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1224: p_data => p_msg_data);
1225:
1226:
1227: EXCEPTION
1229: when FND_API.G_EXC_ERROR then
1230: rollback to Apply_Position_Parameters_Pvt;
1231: p_return_status := FND_API.G_RET_STS_ERROR;
1232:
1233: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1234: p_data => p_msg_data);
1235:
1236:
1237: when FND_API.G_EXC_UNEXPECTED_ERROR then
1237: when FND_API.G_EXC_UNEXPECTED_ERROR then
1238: rollback to Apply_Position_Parameters_Pvt;
1239: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240:
1241: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1242: p_data => p_msg_data);
1243:
1244:
1245: when OTHERS then
1245: when OTHERS then
1246: rollback to Apply_Position_Parameters_Pvt;
1247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248:
1249: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1250: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1251: l_api_name);
1252: end if;
1253:
1246: rollback to Apply_Position_Parameters_Pvt;
1247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248:
1249: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1250: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1251: l_api_name);
1252: end if;
1253:
1254: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1250: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1251: l_api_name);
1252: end if;
1253:
1254: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1255: p_data => p_msg_data);
1256:
1257: END Apply_Position_Parameters;
1258:
1313:
1314: -- Initialize message list if p_init_msg_list is set to TRUE
1315:
1316: if FND_API.to_Boolean (p_init_msg_list) then
1317: FND_MSG_PUB.initialize;
1318: end if;
1319:
1320:
1321: -- Call Private Function
1380:
1381:
1382: -- Standard call to get message count and if count is 1, get message info
1383:
1384: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1385: p_data => p_msg_data);
1386:
1387:
1388: EXCEPTION
1390: when FND_API.G_EXC_ERROR then
1391: rollback to Calculate_Position_Cost_Pvt;
1392: p_return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1395: p_data => p_msg_data);
1396:
1397:
1398: when FND_API.G_EXC_UNEXPECTED_ERROR then
1398: when FND_API.G_EXC_UNEXPECTED_ERROR then
1399: rollback to Calculate_Position_Cost_Pvt;
1400: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401:
1402: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1403: p_data => p_msg_data);
1404:
1405:
1406: when OTHERS then
1406: when OTHERS then
1407: rollback to Calculate_Position_Cost_Pvt;
1408: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1409:
1410: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1411: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1412: l_api_name);
1413: end if;
1414:
1407: rollback to Calculate_Position_Cost_Pvt;
1408: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1409:
1410: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1411: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1412: l_api_name);
1413: end if;
1414:
1415: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1411: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1412: l_api_name);
1413: end if;
1414:
1415: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1416: p_data => p_msg_data);
1417:
1418: END Calculate_Position_Cost;
1419:
1459:
1460: -- Initialize message list if p_init_msg_list is set to TRUE
1461:
1462: if FND_API.to_Boolean (p_init_msg_list) then
1463: FND_MSG_PUB.initialize;
1464: end if;
1465:
1466: -- Enforce Concurrency Control
1467:
1530:
1531:
1532: -- Standard call to get message count and if count is 1, get message info
1533:
1534: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1535: p_data => p_msg_data);
1536:
1537:
1538: EXCEPTION
1539:
1540: when FND_API.G_EXC_ERROR then
1541: --rollback to Revise_Pos_Projections_Pvt;
1542: p_return_status := FND_API.G_RET_STS_ERROR;
1543: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1544: p_data => p_msg_data);
1545:
1546:
1547: when FND_API.G_EXC_UNEXPECTED_ERROR then
1546:
1547: when FND_API.G_EXC_UNEXPECTED_ERROR then
1548: --rollback to Revise_Pos_Projections_Pvt;
1549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1551: p_data => p_msg_data);
1552:
1553:
1554: when OTHERS then
1554: when OTHERS then
1555: --rollback to Revise_Pos_Projections_Pvt;
1556: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557:
1558: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1559: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1560: l_api_name);
1561: end if;
1562:
1555: --rollback to Revise_Pos_Projections_Pvt;
1556: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557:
1558: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1559: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1560: l_api_name);
1561: end if;
1562:
1563: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1559: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1560: l_api_name);
1561: end if;
1562:
1563: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1564: p_data => p_msg_data);
1565:
1566: END Revise_Position_Projections;
1567:
1675: p_concurrency_entity_name => 'WORKSHEET',
1676: p_concurrency_entity_id => p_worksheet_id);
1677:
1678: --
1679: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1680: --
1681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1682: l_api_name ) ;
1683: END IF ;
1677:
1678: --
1679: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1680: --
1681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1682: l_api_name ) ;
1683: END IF ;
1684: --
1685: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1752: --
1753: if l_rep_req_id = 0 then
1754: --
1755: fnd_message.set_name('PSB', 'PSB_FAIL_TO_SUBMIT_REQUEST');
1756: FND_MSG_PUB.Add;
1757: raise FND_API.G_EXC_ERROR;
1758: --
1759: end if;
1760:
1758: --
1759: end if;
1760:
1761: fnd_message.set_name('PSB', 'PSB_POSITION_WS_EXCEPTION');
1762: FND_MSG_PUB.Add;
1763:
1764: raise FND_API.G_EXC_ERROR;
1765:
1766: end if;
1787: COMMIT WORK ;
1788: --
1789: WHEN OTHERS THEN
1790:
1791: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1792: --
1793: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1794: l_api_name ) ;
1795: END IF ;
1789: WHEN OTHERS THEN
1790:
1791: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1792: --
1793: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1794: l_api_name ) ;
1795: END IF ;
1796: --
1797: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1881: COMMIT WORK ;
1882:
1883: WHEN OTHERS THEN
1884:
1885: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1886: --
1887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1888: l_api_name ) ;
1889: END IF ;
1883: WHEN OTHERS THEN
1884:
1885: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1886: --
1887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1888: l_api_name ) ;
1889: END IF ;
1890: --
1891: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
1975: COMMIT WORK ;
1976:
1977: WHEN OTHERS THEN
1978:
1979: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1980: --
1981: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1982: l_api_name ) ;
1983: END IF ;
1977: WHEN OTHERS THEN
1978:
1979: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1980: --
1981: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1982: l_api_name ) ;
1983: END IF ;
1984: --
1985: PSB_MESSAGE_S.Print_Error ( p_mode => FND_FILE.LOG ,
2026:
2027: -- Initialize message list if p_init_msg_list is set to TRUE
2028:
2029: if FND_API.to_Boolean (p_init_msg_list) then
2030: FND_MSG_PUB.initialize;
2031: end if;
2032:
2033: -- Enforce Concurrency Control
2034:
2095:
2096:
2097: -- Standard call to get message count and if count is 1, get message info
2098:
2099: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2100: p_data => p_msg_data);
2101:
2102:
2103: EXCEPTION
2104:
2105: when FND_API.G_EXC_ERROR then
2106: rollback;
2107: p_return_status := FND_API.G_RET_STS_ERROR;
2108: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2109: p_data => p_msg_data);
2110:
2111:
2112: when FND_API.G_EXC_UNEXPECTED_ERROR then
2111:
2112: when FND_API.G_EXC_UNEXPECTED_ERROR then
2113: rollback;
2114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2116: p_data => p_msg_data);
2117:
2118:
2119: when OTHERS then
2119: when OTHERS then
2120: rollback;
2121: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2122:
2123: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2124: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2125: l_api_name);
2126: end if;
2127:
2120: rollback;
2121: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2122:
2123: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2124: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2125: l_api_name);
2126: end if;
2127:
2128: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2124: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2125: l_api_name);
2126: end if;
2127:
2128: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2129: p_data => p_msg_data);
2130:
2131: END Revise_Element_Projections;
2132: