57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Initialize API return status to success
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
97: AND ( p_ou_query_rec.operating_unit_id = FND_API.G_MISS_NUM)
98: AND ( p_ou_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
99:
100: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_ERROR;
103: END IF;
104:
105:
147: IF p_time_stamp <= sysdate THEN
148: csi_organization_unit_pvt.Construct_ou_From_Hist(x_org_unit_tbl, p_time_stamp);
149: ELSE
150: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
151: FND_MSG_PUB.ADD;
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154: END IF;
155:
180: -- End disable trace
181: ****/
182:
183: -- Standard call to get message count and if count is get message info.
184: FND_MSG_PUB.Count_And_Get
185: (p_count => x_msg_count ,
186: p_data => x_msg_data
187: );
188:
191:
192: WHEN FND_API.G_EXC_ERROR THEN
193: -- ROLLBACK TO get_organization_unit;
194: x_return_status := FND_API.G_RET_STS_ERROR ;
195: FND_MSG_PUB.Count_And_Get
196: ( p_count => x_msg_count,
197: p_data => x_msg_data
198: );
199:
199:
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: -- ROLLBACK TO get_organization_unit;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
203: FND_MSG_PUB.Count_And_Get
204: ( p_count => x_msg_count,
205: p_data => x_msg_data
206: );
207:
211: END IF;
212: -- ROLLBACK TO get_organization_unit;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214:
215: IF FND_MSG_PUB.Check_Msg_Level
216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
217: THEN
218: FND_MSG_PUB.Add_Exc_Msg
219: ( g_pkg_name,
212: -- ROLLBACK TO get_organization_unit;
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
214:
215: IF FND_MSG_PUB.Check_Msg_Level
216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
217: THEN
218: FND_MSG_PUB.Add_Exc_Msg
219: ( g_pkg_name,
220: l_api_name
214:
215: IF FND_MSG_PUB.Check_Msg_Level
216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
217: THEN
218: FND_MSG_PUB.Add_Exc_Msg
219: ( g_pkg_name,
220: l_api_name
221: );
222: END IF;
220: l_api_name
221: );
222: END IF;
223:
224: FND_MSG_PUB.Count_And_Get
225: ( p_count => x_msg_count,
226: p_data => x_msg_data
227: );
228:
282:
283:
284: -- Initialize message list if p_init_msg_list is set to TRUE.
285: IF FND_API.to_Boolean( p_init_msg_list ) THEN
286: FND_MSG_PUB.initialize;
287: END IF;
288:
289:
290: -- Initialize API return status to success
343: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
344: l_msg_index := 1;
345: l_msg_count := x_msg_count;
346: WHILE l_msg_count > 0 LOOP
347: x_msg_data := FND_MSG_PUB.GET
348: ( l_msg_index,
349: FND_API.G_FALSE );
350:
351: csi_gen_utility_pvt.put_line( ' Failed Pub:create_organization_unit..');
377: -- End disable trace
378: ****/
379:
380: -- Standard call to get message count and if count is get message info.
381: FND_MSG_PUB.Count_And_Get
382: (p_count => x_msg_count ,
383: p_data => x_msg_data
384: );
385:
388:
389: WHEN FND_API.G_EXC_ERROR THEN
390: ROLLBACK TO create_organization_unit;
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392: FND_MSG_PUB.Count_And_Get
393: ( p_count => x_msg_count,
394: p_data => x_msg_data
395: );
396:
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: ROLLBACK TO create_organization_unit;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400: FND_MSG_PUB.Count_And_Get
401: ( p_count => x_msg_count,
402: p_data => x_msg_data
403: );
404:
405: WHEN OTHERS THEN
406: ROLLBACK TO create_organization_unit;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
408:
409: IF FND_MSG_PUB.Check_Msg_Level
410: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: FND_MSG_PUB.Add_Exc_Msg
413: ( g_pkg_name,
406: ROLLBACK TO create_organization_unit;
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
408:
409: IF FND_MSG_PUB.Check_Msg_Level
410: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: FND_MSG_PUB.Add_Exc_Msg
413: ( g_pkg_name,
414: l_api_name
408:
409: IF FND_MSG_PUB.Check_Msg_Level
410: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
411: THEN
412: FND_MSG_PUB.Add_Exc_Msg
413: ( g_pkg_name,
414: l_api_name
415: );
416: END IF;
414: l_api_name
415: );
416: END IF;
417:
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count,
420: p_data => x_msg_data
421: );
422:
476:
477:
478: -- Initialize message list if p_init_msg_list is set to TRUE.
479: IF FND_API.to_Boolean( p_init_msg_list ) THEN
480: FND_MSG_PUB.initialize;
481: END IF;
482:
483:
484: -- Initialize API return status to success
535: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
536: l_msg_index := 1;
537: l_msg_count := x_msg_count;
538: WHILE l_msg_count > 0 LOOP
539: x_msg_data := FND_MSG_PUB.GET
540: ( l_msg_index,
541: FND_API.G_FALSE );
542:
543: csi_gen_utility_pvt.put_line( ' Failed Pub:update_organization_unit..');
567: -- End disable trace
568: ****/
569:
570: -- Standard call to get message count and if count is get message info.
571: FND_MSG_PUB.Count_And_Get
572: (p_count => x_msg_count ,
573: p_data => x_msg_data
574: );
575:
578:
579: WHEN FND_API.G_EXC_ERROR THEN
580: ROLLBACK TO update_organization_unit;
581: x_return_status := FND_API.G_RET_STS_ERROR ;
582: FND_MSG_PUB.Count_And_Get
583: ( p_count => x_msg_count,
584: p_data => x_msg_data
585: );
586:
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: ROLLBACK TO update_organization_unit;
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
590: FND_MSG_PUB.Count_And_Get
591: ( p_count => x_msg_count,
592: p_data => x_msg_data
593: );
594:
595: WHEN OTHERS THEN
596: ROLLBACK TO update_organization_unit;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598:
599: IF FND_MSG_PUB.Check_Msg_Level
600: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
601: THEN
602: FND_MSG_PUB.Add_Exc_Msg
603: ( g_pkg_name,
596: ROLLBACK TO update_organization_unit;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598:
599: IF FND_MSG_PUB.Check_Msg_Level
600: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
601: THEN
602: FND_MSG_PUB.Add_Exc_Msg
603: ( g_pkg_name,
604: l_api_name
598:
599: IF FND_MSG_PUB.Check_Msg_Level
600: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
601: THEN
602: FND_MSG_PUB.Add_Exc_Msg
603: ( g_pkg_name,
604: l_api_name
605: );
606: END IF;
604: l_api_name
605: );
606: END IF;
607:
608: FND_MSG_PUB.Count_And_Get
609: ( p_count => x_msg_count,
610: p_data => x_msg_data
611: );
612:
660:
661:
662: -- Initialize message list if p_init_msg_list is set to TRUE.
663: IF FND_API.to_Boolean( p_init_msg_list ) THEN
664: FND_MSG_PUB.initialize;
665: END IF;
666:
667:
668: -- Initialize API return status to success
715: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
716: l_msg_index := 1;
717: l_msg_count := x_msg_count;
718: WHILE l_msg_count > 0 LOOP
719: x_msg_data := FND_MSG_PUB.GET
720: ( l_msg_index,
721: FND_API.G_FALSE );
722:
723: csi_gen_utility_pvt.put_line( ' Failed Pub:expire_organization_unit..');
749: -- End disable trace
750: ****/
751:
752: -- Standard call to get message count and if count is get message info.
753: FND_MSG_PUB.Count_And_Get
754: (p_count => x_msg_count ,
755: p_data => x_msg_data
756: );
757:
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK TO expire_organization_unit;
763: x_return_status := FND_API.G_RET_STS_ERROR ;
764: FND_MSG_PUB.Count_And_Get
765: ( p_count => x_msg_count,
766: p_data => x_msg_data
767: );
768:
768:
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: ROLLBACK TO expire_organization_unit;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
772: FND_MSG_PUB.Count_And_Get
773: ( p_count => x_msg_count,
774: p_data => x_msg_data
775: );
776:
777: WHEN OTHERS THEN
778: ROLLBACK TO expire_organization_unit;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780:
781: IF FND_MSG_PUB.Check_Msg_Level
782: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: FND_MSG_PUB.Add_Exc_Msg
785: ( g_pkg_name,
778: ROLLBACK TO expire_organization_unit;
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780:
781: IF FND_MSG_PUB.Check_Msg_Level
782: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: FND_MSG_PUB.Add_Exc_Msg
785: ( g_pkg_name,
786: l_api_name
780:
781: IF FND_MSG_PUB.Check_Msg_Level
782: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: FND_MSG_PUB.Add_Exc_Msg
785: ( g_pkg_name,
786: l_api_name
787: );
788: END IF;
786: l_api_name
787: );
788: END IF;
789:
790: FND_MSG_PUB.Count_And_Get
791: ( p_count => x_msg_count,
792: p_data => x_msg_data
793: );
794: