DBA Data[Home] [Help]

APPS.CSI_ORGANIZATION_UNIT_PUB dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize;

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;

Line 101: FND_MSG_PUB.ADD;

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:

Line 151: FND_MSG_PUB.ADD;

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:

Line 184: FND_MSG_PUB.Count_And_Get

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:

Line 195: FND_MSG_PUB.Count_And_Get

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:

Line 203: FND_MSG_PUB.Count_And_Get

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:

Line 215: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 216: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 218: FND_MSG_PUB.Add_Exc_Msg

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;

Line 224: FND_MSG_PUB.Count_And_Get

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:

Line 286: FND_MSG_PUB.initialize;

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

Line 347: x_msg_data := FND_MSG_PUB.GET

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..');

Line 381: FND_MSG_PUB.Count_And_Get

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:

Line 392: FND_MSG_PUB.Count_And_Get

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:

Line 400: FND_MSG_PUB.Count_And_Get

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:

Line 409: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 410: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 412: FND_MSG_PUB.Add_Exc_Msg

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;

Line 418: FND_MSG_PUB.Count_And_Get

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:

Line 480: FND_MSG_PUB.initialize;

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

Line 539: x_msg_data := FND_MSG_PUB.GET

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..');

Line 571: FND_MSG_PUB.Count_And_Get

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:

Line 582: FND_MSG_PUB.Count_And_Get

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:

Line 590: FND_MSG_PUB.Count_And_Get

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:

Line 599: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 600: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 602: FND_MSG_PUB.Add_Exc_Msg

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;

Line 608: FND_MSG_PUB.Count_And_Get

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:

Line 664: FND_MSG_PUB.initialize;

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

Line 719: x_msg_data := FND_MSG_PUB.GET

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..');

Line 753: FND_MSG_PUB.Count_And_Get

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:

Line 764: FND_MSG_PUB.Count_And_Get

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:

Line 772: FND_MSG_PUB.Count_And_Get

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:

Line 781: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 782: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 784: FND_MSG_PUB.Add_Exc_Msg

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;

Line 790: FND_MSG_PUB.Count_And_Get

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: