APPS.CSI_COUNTER_PUB dependencies on FND_API

Line 74: IF NOT FND_API.Compatible_API_Call (l_api_version,

70: -- Standard Start of API savepoint
71: SAVEPOINT create_counter_pub;
72:
73: -- Standard call to check for call compatibility.
74: IF NOT FND_API.Compatible_API_Call (l_api_version,
75: p_api_version,
76: l_api_name ,
77: G_PKG_NAME )
78: THEN

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75: p_api_version,
76: l_api_name ,
77: G_PKG_NAME )
78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 83: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86:
87: -- Initialize API return status to success

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: FND_MSG_PUB.initialize;
85: END IF;
86:
87: -- Initialize API return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: -- Read the debug profiles values in to global variable 7197402
91: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
92:

Line 129: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

125: ,x_msg_count => x_msg_count
126: ,x_msg_data => x_msg_data
127: ,x_ctr_id => x_ctr_id
128: );
129: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
130: l_msg_index := 1;
131: l_msg_count := x_msg_count;
132:
133: WHILE l_msg_count > 0 LOOP

Line 136: FND_API.G_FALSE );

132:
133: WHILE l_msg_count > 0 LOOP
134: x_msg_data := FND_MSG_PUB.GET
135: (l_msg_index,
136: FND_API.G_FALSE );
137: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_COUNTER_PRE API');
138: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
139: l_msg_index := l_msg_index + 1;
140: l_msg_count := l_msg_count - 1;

Line 142: RAISE FND_API.G_EXC_ERROR;

138: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
139: l_msg_index := l_msg_index + 1;
140: l_msg_count := l_msg_count - 1;
141: END LOOP;
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;
144:
145:
146: END IF;

Line 165: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

161: ,x_msg_count => x_msg_count
162: ,x_msg_data => x_msg_data
163: ,x_ctr_id => x_ctr_id
164: );
165: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
166: l_msg_index := 1;
167: l_msg_count := x_msg_count;
168:
169: WHILE l_msg_count > 0 LOOP

Line 172: FND_API.G_FALSE );

168:
169: WHILE l_msg_count > 0 LOOP
170: x_msg_data := FND_MSG_PUB.GET
171: (l_msg_index,
172: FND_API.G_FALSE );
173: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_COUNTER_PRE API');
174: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
175: l_msg_index := l_msg_index + 1;
176: l_msg_count := l_msg_count - 1;

Line 178: RAISE FND_API.G_EXC_ERROR;

174: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
175: l_msg_index := l_msg_index + 1;
176: l_msg_count := l_msg_count - 1;
177: END LOOP;
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: END IF;
181:
182: -- Start of API Body

Line 201: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

197: ,x_msg_count => x_msg_count
198: ,x_msg_data => x_msg_data
199: ,x_ctr_id => l_counter_id
200: );
201: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
202: l_msg_index := 1;
203: l_msg_count := x_msg_count;
204:
205: WHILE l_msg_count > 0 LOOP

Line 208: FND_API.G_FALSE );

204:
205: WHILE l_msg_count > 0 LOOP
206: x_msg_data := FND_MSG_PUB.GET
207: (l_msg_index,
208: FND_API.G_FALSE );
209: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_COUNTER API');
210: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
211: l_msg_index := l_msg_index + 1;
212: l_msg_count := l_msg_count - 1;

Line 214: RAISE FND_API.G_EXC_ERROR;

210: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
211: l_msg_index := l_msg_index + 1;
212: l_msg_count := l_msg_count - 1;
213: END LOOP;
214: RAISE FND_API.G_EXC_ERROR;
215: END IF;
216:
217: x_ctr_id := l_counter_id;
218:

Line 268: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

264: ,x_msg_count => x_msg_count
265: ,x_msg_data => x_msg_data
266: ,x_ctr_property_id => l_ctr_property_id
267: );
268: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
269: l_msg_index := 1;
270: l_msg_count := x_msg_count;
271:
272: WHILE l_msg_count > 0 LOOP

Line 275: FND_API.G_FALSE );

271:
272: WHILE l_msg_count > 0 LOOP
273: x_msg_data := FND_MSG_PUB.GET
274: (l_msg_index,
275: FND_API.G_FALSE );
276: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_PROPERTY API');
277: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
278: l_msg_index := l_msg_index + 1;
279: l_msg_count := l_msg_count - 1;

Line 281: RAISE FND_API.G_EXC_ERROR;

277: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
278: l_msg_index := l_msg_index + 1;
279: l_msg_count := l_msg_count - 1;
280: END LOOP;
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283: END;
284: END LOOP;
285: END IF;

Line 331: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

327: ,x_return_status => x_return_status
328: ,x_msg_count => x_msg_count
329: ,x_msg_data => x_msg_data
330: );
331: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
332: l_msg_index := 1;
333: l_msg_count := x_msg_count;
334:
335: WHILE l_msg_count > 0 LOOP

Line 338: FND_API.G_FALSE );

334:
335: WHILE l_msg_count > 0 LOOP
336: x_msg_data := FND_MSG_PUB.GET
337: (l_msg_index,
338: FND_API.G_FALSE );
339: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_RELATIONSHIP API');
340: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
341: l_msg_index := l_msg_index + 1;
342: l_msg_count := l_msg_count - 1;

Line 344: RAISE FND_API.G_EXC_ERROR;

340: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
341: l_msg_index := l_msg_index + 1;
342: l_msg_count := l_msg_count - 1;
343: END LOOP;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346: END;
347: END LOOP;
348: END IF;

Line 367: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

363: ,x_return_status => x_return_status
364: ,x_msg_count => x_msg_count
365: ,x_msg_data => x_msg_data
366: );
367: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
368: l_msg_index := 1;
369: l_msg_count := x_msg_count;
370:
371: WHILE l_msg_count > 0 LOOP

Line 374: FND_API.G_FALSE );

370:
371: WHILE l_msg_count > 0 LOOP
372: x_msg_data := FND_MSG_PUB.GET
373: (l_msg_index,
374: FND_API.G_FALSE );
375: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS API');
376: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
377: l_msg_index := l_msg_index + 1;
378: l_msg_count := l_msg_count - 1;

Line 380: RAISE FND_API.G_EXC_ERROR;

376: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
377: l_msg_index := l_msg_index + 1;
378: l_msg_count := l_msg_count - 1;
379: END LOOP;
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382: END IF;
383:
384: -- Insert Counter associations

Line 432: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

428: ,x_msg_count => x_msg_count
429: ,x_msg_data => x_msg_data
430: ,x_instance_association_id => l_instance_association_id
431: );
432: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
433: l_msg_index := 1;
434: l_msg_count := x_msg_count;
435:
436: WHILE l_msg_count > 0 LOOP

Line 439: FND_API.G_FALSE );

435:
436: WHILE l_msg_count > 0 LOOP
437: x_msg_data := FND_MSG_PUB.GET
438: (l_msg_index,
439: FND_API.G_FALSE );
440: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS API');
441: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
442: l_msg_index := l_msg_index + 1;
443: l_msg_count := l_msg_count - 1;

Line 445: RAISE FND_API.G_EXC_ERROR;

441: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
442: l_msg_index := l_msg_index + 1;
443: l_msg_count := l_msg_count - 1;
444: END LOOP;
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447: END;
448: END LOOP;
449: END IF;

Line 453: p_counter_instance_rec.initial_reading <> FND_API.G_MISS_NUM) and nvl(l_counter_relationships_rec.RELATIONSHIP_TYPE_CODE,'X') <> l_rel_type then

449: END IF;
450:
451: -- Insert initial reading by calling counter reading api.
452: IF p_counter_instance_rec.counter_type = 'REGULAR' and (p_counter_instance_rec.initial_reading is not null and
453: p_counter_instance_rec.initial_reading <> FND_API.G_MISS_NUM) and nvl(l_counter_relationships_rec.RELATIONSHIP_TYPE_CODE,'X') <> l_rel_type then
454:
455: --create transaction record
456: l_transaction_tbl(l_c_ind_txn) := NULL;
457: l_transaction_tbl(l_c_ind_txn).TRANSACTION_ID := NULL;

Line 539: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

535: ,x_msg_count => x_msg_count
536: ,x_msg_data => x_msg_data
537: ,x_ctr_id => x_ctr_id
538: );
539: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
540: l_msg_index := 1;
541: l_msg_count := x_msg_count;
542:
543: WHILE l_msg_count > 0 LOOP

Line 546: FND_API.G_FALSE );

542:
543: WHILE l_msg_count > 0 LOOP
544: x_msg_data := FND_MSG_PUB.GET
545: (l_msg_index,
546: FND_API.G_FALSE );
547: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_COUNTER_POST API');
548: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
549: l_msg_index := l_msg_index + 1;
550: l_msg_count := l_msg_count - 1;

Line 552: RAISE FND_API.G_EXC_ERROR;

548: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
549: l_msg_index := l_msg_index + 1;
550: l_msg_count := l_msg_count - 1;
551: END LOOP;
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554: END IF;
555: /* Vertical post -processing section - Mandatory */
556: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) ) THEN

Line 573: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

569: ,x_msg_count => x_msg_count
570: ,x_msg_data => x_msg_data
571: ,x_ctr_id => x_ctr_id
572: );
573: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
574: l_msg_index := 1;
575: l_msg_count := x_msg_count;
576:
577: WHILE l_msg_count > 0 LOOP

Line 580: FND_API.G_FALSE );

576:
577: WHILE l_msg_count > 0 LOOP
578: x_msg_data := FND_MSG_PUB.GET
579: (l_msg_index,
580: FND_API.G_FALSE );
581: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_COUNTER_POST API');
582: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
583: l_msg_index := l_msg_index + 1;
584: l_msg_count := l_msg_count - 1;

Line 586: RAISE FND_API.G_EXC_ERROR;

582: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
583: l_msg_index := l_msg_index + 1;
584: l_msg_count := l_msg_count - 1;
585: END LOOP;
586: RAISE FND_API.G_EXC_ERROR;
587: END IF;
588: END IF;
589:
590: -- Standard check of p_commit.

Line 591: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

587: END IF;
588: END IF;
589:
590: -- Standard check of p_commit.
591: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
592: COMMIT WORK;
593: END IF;
594:
595: EXCEPTION

Line 596: WHEN FND_API.G_EXC_ERROR THEN

592: COMMIT WORK;
593: END IF;
594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR ;
598: ROLLBACK TO create_counter_pub;
599: FND_MSG_PUB.Count_And_Get
600: (p_count => x_msg_count,

Line 597: x_return_status := FND_API.G_RET_STS_ERROR ;

593: END IF;
594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR ;
598: ROLLBACK TO create_counter_pub;
599: FND_MSG_PUB.Count_And_Get
600: (p_count => x_msg_count,
601: p_data => x_msg_data

Line 604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

600: (p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: ROLLBACK TO create_counter_pub;
607: FND_MSG_PUB.Count_And_Get
608: (p_count => x_msg_count,

Line 605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

601: p_data => x_msg_data
602: );
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: ROLLBACK TO create_counter_pub;
607: FND_MSG_PUB.Count_And_Get
608: (p_count => x_msg_count,
609: p_data => x_msg_data

Line 612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

608: (p_count => x_msg_count,
609: p_data => x_msg_data
610: );
611: WHEN OTHERS THEN
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
613: ROLLBACK TO create_counter_pub;
614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
615: THEN
616: FND_MSG_PUB.Add_Exc_Msg

Line 664: IF NOT FND_API.Compatible_API_Call (l_api_version,

660: -- Standard Start of API savepoint
661: SAVEPOINT create_ctr_property_pub;
662:
663: -- Standard call to check for call compatibility.
664: IF NOT FND_API.Compatible_API_Call (l_api_version,
665: p_api_version,
666: l_api_name ,
667: G_PKG_NAME )
668: THEN

Line 669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

665: p_api_version,
666: l_api_name ,
667: G_PKG_NAME )
668: THEN
669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
670: END IF;
671:
672: -- Initialize message list if p_init_msg_list is set to TRUE.
673: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 673: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
670: END IF;
671:
672: -- Initialize message list if p_init_msg_list is set to TRUE.
673: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
674: FND_MSG_PUB.initialize;
675: END IF;
676:
677: -- Initialize API return status to success

Line 678: x_return_status := FND_API.G_RET_STS_SUCCESS;

674: FND_MSG_PUB.initialize;
675: END IF;
676:
677: -- Initialize API return status to success
678: x_return_status := FND_API.G_RET_STS_SUCCESS;
679:
680: -- Read the debug profiles values in to global variable 7197402
681: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
682:

Line 715: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

711: ,x_msg_count => x_msg_count
712: ,x_msg_data => x_msg_data
713: ,x_ctr_property_id => x_ctr_property_id
714: );
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:
719: WHILE l_msg_count > 0 LOOP

Line 722: FND_API.G_FALSE );

718:
719: WHILE l_msg_count > 0 LOOP
720: x_msg_data := FND_MSG_PUB.GET
721: (l_msg_index,
722: FND_API.G_FALSE );
723: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_PROPERTY_PRE API');
724: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
725: l_msg_index := l_msg_index + 1;
726: l_msg_count := l_msg_count - 1;

Line 728: RAISE FND_API.G_EXC_ERROR;

724: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
725: l_msg_index := l_msg_index + 1;
726: l_msg_count := l_msg_count - 1;
727: END LOOP;
728: RAISE FND_API.G_EXC_ERROR;
729: END IF;
730: END IF;
731: /* Vertical pre -processing section - Mandatory */
732: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) ) THEN

Line 745: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

741: ,x_msg_count => x_msg_count
742: ,x_msg_data => x_msg_data
743: ,x_ctr_property_id => x_ctr_property_id
744: );
745: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
746: l_msg_index := 1;
747: l_msg_count := x_msg_count;
748:
749: WHILE l_msg_count > 0 LOOP

Line 752: FND_API.G_FALSE );

748:
749: WHILE l_msg_count > 0 LOOP
750: x_msg_data := FND_MSG_PUB.GET
751: (l_msg_index,
752: FND_API.G_FALSE );
753: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_CTR_PROPERTY_PRE API');
754: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
755: l_msg_index := l_msg_index + 1;
756: l_msg_count := l_msg_count - 1;

Line 758: RAISE FND_API.G_EXC_ERROR;

754: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
755: l_msg_index := l_msg_index + 1;
756: l_msg_count := l_msg_count - 1;
757: END LOOP;
758: RAISE FND_API.G_EXC_ERROR;
759: END IF ;
760: END IF;
761:
762: -- Start of API Body

Line 812: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

808: ,x_msg_count => x_msg_count
809: ,x_msg_data => x_msg_data
810: ,x_ctr_property_id => l_ctr_property_id
811: );
812: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
813: l_msg_index := 1;
814: l_msg_count := x_msg_count;
815:
816: WHILE l_msg_count > 0 LOOP

Line 819: FND_API.G_FALSE );

815:
816: WHILE l_msg_count > 0 LOOP
817: x_msg_data := FND_MSG_PUB.GET
818: (l_msg_index,
819: FND_API.G_FALSE );
820: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_PROPERTY API');
821: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
822: l_msg_index := l_msg_index + 1;
823: l_msg_count := l_msg_count - 1;

Line 825: RAISE FND_API.G_EXC_ERROR;

821: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
822: l_msg_index := l_msg_index + 1;
823: l_msg_count := l_msg_count - 1;
824: END LOOP;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827: END;
828: END LOOP;
829: END IF;

Line 847: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

843: ,x_msg_count => x_msg_count
844: ,x_msg_data => x_msg_data
845: ,x_ctr_property_id => x_ctr_property_id
846: );
847: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
848: l_msg_index := 1;
849: l_msg_count := x_msg_count;
850:
851: WHILE l_msg_count > 0 LOOP

Line 854: FND_API.G_FALSE );

850:
851: WHILE l_msg_count > 0 LOOP
852: x_msg_data := FND_MSG_PUB.GET
853: (l_msg_index,
854: FND_API.G_FALSE );
855: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_PROPERTY_POST API');
856: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
857: l_msg_index := l_msg_index + 1;
858: l_msg_count := l_msg_count - 1;

Line 860: RAISE FND_API.G_EXC_ERROR;

856: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
857: l_msg_index := l_msg_index + 1;
858: l_msg_count := l_msg_count - 1;
859: END LOOP;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: END IF;
863: /* Vertical post -processing section - Mandatory */
864: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) ) THEN

Line 877: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

873: ,x_msg_count => x_msg_count
874: ,x_msg_data => x_msg_data
875: ,x_ctr_property_id => x_ctr_property_id
876: );
877: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
878: l_msg_index := 1;
879: l_msg_count := x_msg_count;
880:
881: WHILE l_msg_count > 0 LOOP

Line 884: FND_API.G_FALSE );

880:
881: WHILE l_msg_count > 0 LOOP
882: x_msg_data := FND_MSG_PUB.GET
883: (l_msg_index,
884: FND_API.G_FALSE );
885: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_PROPERTY_POST API');
886: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
887: l_msg_index := l_msg_index + 1;
888: l_msg_count := l_msg_count - 1;

Line 890: RAISE FND_API.G_EXC_ERROR;

886: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
887: l_msg_index := l_msg_index + 1;
888: l_msg_count := l_msg_count - 1;
889: END LOOP;
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892: END IF;
893:
894: -- Standard check of p_commit.

Line 895: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

891: END IF;
892: END IF;
893:
894: -- Standard check of p_commit.
895: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
896: COMMIT WORK;
897: END IF;
898:
899: EXCEPTION

Line 900: WHEN FND_API.G_EXC_ERROR THEN

896: COMMIT WORK;
897: END IF;
898:
899: EXCEPTION
900: WHEN FND_API.G_EXC_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_ERROR ;
902: ROLLBACK TO create_ctr_property_pub;
903: FND_MSG_PUB.Count_And_Get
904: (p_count => x_msg_count,

Line 901: x_return_status := FND_API.G_RET_STS_ERROR ;

897: END IF;
898:
899: EXCEPTION
900: WHEN FND_API.G_EXC_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_ERROR ;
902: ROLLBACK TO create_ctr_property_pub;
903: FND_MSG_PUB.Count_And_Get
904: (p_count => x_msg_count,
905: p_data => x_msg_data

Line 908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

904: (p_count => x_msg_count,
905: p_data => x_msg_data
906: );
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
910: ROLLBACK TO create_ctr_property_pub;
911: FND_MSG_PUB.Count_And_Get
912: (p_count => x_msg_count,

Line 909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

905: p_data => x_msg_data
906: );
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
910: ROLLBACK TO create_ctr_property_pub;
911: FND_MSG_PUB.Count_And_Get
912: (p_count => x_msg_count,
913: p_data => x_msg_data

Line 916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

912: (p_count => x_msg_count,
913: p_data => x_msg_data
914: );
915: WHEN OTHERS THEN
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
917: ROLLBACK TO create_ctr_property_pub;
918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg

Line 968: IF NOT FND_API.Compatible_API_Call (l_api_version,

964: -- Standard Start of API savepoint
965: SAVEPOINT create_ctr_associations_pub;
966:
967: -- Standard call to check for call compatibility.
968: IF NOT FND_API.Compatible_API_Call (l_api_version,
969: p_api_version,
970: l_api_name ,
971: G_PKG_NAME )
972: THEN

Line 973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

969: p_api_version,
970: l_api_name ,
971: G_PKG_NAME )
972: THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: -- Initialize message list if p_init_msg_list is set to TRUE.
977: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 977: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: -- Initialize message list if p_init_msg_list is set to TRUE.
977: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
978: FND_MSG_PUB.initialize;
979: END IF;
980:
981: -- Initialize API return status to success

Line 982: x_return_status := FND_API.G_RET_STS_SUCCESS;

978: FND_MSG_PUB.initialize;
979: END IF;
980:
981: -- Initialize API return status to success
982: x_return_status := FND_API.G_RET_STS_SUCCESS;
983:
984: -- Read the debug profiles values in to global variable 7197402
985: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
986:

Line 1019: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1015: ,x_msg_count => x_msg_count
1016: ,x_msg_data => x_msg_data
1017: ,x_instance_association_id => x_instance_association_id
1018: );
1019: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1020: l_msg_index := 1;
1021: l_msg_count := x_msg_count;
1022:
1023: WHILE l_msg_count > 0 LOOP

Line 1026: FND_API.G_FALSE );

1022:
1023: WHILE l_msg_count > 0 LOOP
1024: x_msg_data := FND_MSG_PUB.GET
1025: (l_msg_index,
1026: FND_API.G_FALSE );
1027: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_ASSOCIATIONS_PRE API');
1028: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1029: l_msg_index := l_msg_index + 1;
1030: l_msg_count := l_msg_count - 1;

Line 1032: RAISE FND_API.G_EXC_ERROR;

1028: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1029: l_msg_index := l_msg_index + 1;
1030: l_msg_count := l_msg_count - 1;
1031: END LOOP;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: END IF;
1035:
1036: /* Vertical pre -processing section - Mandatory */

Line 1050: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1046: ,x_msg_count => x_msg_count
1047: ,x_msg_data => x_msg_data
1048: ,x_instance_association_id => x_instance_association_id
1049: );
1050: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1051: l_msg_index := 1;
1052: l_msg_count := x_msg_count;
1053:
1054: WHILE l_msg_count > 0 LOOP

Line 1057: FND_API.G_FALSE );

1053:
1054: WHILE l_msg_count > 0 LOOP
1055: x_msg_data := FND_MSG_PUB.GET
1056: (l_msg_index,
1057: FND_API.G_FALSE );
1058: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_CTR_ASSOCIATIONS_PRE API');
1059: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1060: l_msg_index := l_msg_index + 1;
1061: l_msg_count := l_msg_count - 1;

Line 1063: RAISE FND_API.G_EXC_ERROR;

1059: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1060: l_msg_index := l_msg_index + 1;
1061: l_msg_count := l_msg_count - 1;
1062: END LOOP;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: END IF;
1066:
1067: -- Start of API Body

Line 1111: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1107: ,x_msg_count => x_msg_count
1108: ,x_msg_data => x_msg_data
1109: ,x_instance_association_id => l_instance_association_id
1110: );
1111: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1112: l_msg_index := 1;
1113: l_msg_count := x_msg_count;
1114:
1115: WHILE l_msg_count > 0 LOOP

Line 1118: FND_API.G_FALSE );

1114:
1115: WHILE l_msg_count > 0 LOOP
1116: x_msg_data := FND_MSG_PUB.GET
1117: (l_msg_index,
1118: FND_API.G_FALSE );
1119: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS API');
1120: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1121: l_msg_index := l_msg_index + 1;
1122: l_msg_count := l_msg_count - 1;

Line 1124: RAISE FND_API.G_EXC_ERROR;

1120: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1121: l_msg_index := l_msg_index + 1;
1122: l_msg_count := l_msg_count - 1;
1123: END LOOP;
1124: RAISE FND_API.G_EXC_ERROR;
1125: END IF;
1126: END;
1127: END LOOP;
1128: END IF;

Line 1144: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1140: ,x_msg_count => x_msg_count
1141: ,x_msg_data => x_msg_data
1142: ,x_instance_association_id => x_instance_association_id
1143: );
1144: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1145: l_msg_index := 1;
1146: l_msg_count := x_msg_count;
1147:
1148: WHILE l_msg_count > 0 LOOP

Line 1151: FND_API.G_FALSE );

1147:
1148: WHILE l_msg_count > 0 LOOP
1149: x_msg_data := FND_MSG_PUB.GET
1150: (l_msg_index,
1151: FND_API.G_FALSE );
1152: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_ASSOCIATIONS_POST API');
1153: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1154: l_msg_index := l_msg_index + 1;
1155: l_msg_count := l_msg_count - 1;

Line 1157: RAISE FND_API.G_EXC_ERROR;

1153: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1154: l_msg_index := l_msg_index + 1;
1155: l_msg_count := l_msg_count - 1;
1156: END LOOP;
1157: RAISE FND_API.G_EXC_ERROR;
1158: END IF;
1159: END IF;
1160:
1161: /* Vertical post -processing section - Mandatory */

Line 1175: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1171: ,x_msg_count => x_msg_count
1172: ,x_msg_data => x_msg_data
1173: ,x_instance_association_id => x_instance_association_id
1174: );
1175: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1176: l_msg_index := 1;
1177: l_msg_count := x_msg_count;
1178:
1179: WHILE l_msg_count > 0 LOOP

Line 1182: FND_API.G_FALSE );

1178:
1179: WHILE l_msg_count > 0 LOOP
1180: x_msg_data := FND_MSG_PUB.GET
1181: (l_msg_index,
1182: FND_API.G_FALSE );
1183: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_CTR_ASSOCIATIONS_POST API');
1184: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1185: l_msg_index := l_msg_index + 1;
1186: l_msg_count := l_msg_count - 1;

Line 1188: RAISE FND_API.G_EXC_ERROR;

1184: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1185: l_msg_index := l_msg_index + 1;
1186: l_msg_count := l_msg_count - 1;
1187: END LOOP;
1188: RAISE FND_API.G_EXC_ERROR;
1189: END IF;
1190: END IF;
1191:
1192: -- End of API body

Line 1195: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

1191:
1192: -- End of API body
1193:
1194: -- Standard check of p_commit.
1195: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1196: COMMIT WORK;
1197: END IF;
1198:
1199: EXCEPTION

Line 1200: WHEN FND_API.G_EXC_ERROR THEN

1196: COMMIT WORK;
1197: END IF;
1198:
1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: ROLLBACK TO create_ctr_associations_pub;
1203: FND_MSG_PUB.Count_And_Get
1204: (p_count => x_msg_count,

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR ;

1197: END IF;
1198:
1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: ROLLBACK TO create_ctr_associations_pub;
1203: FND_MSG_PUB.Count_And_Get
1204: (p_count => x_msg_count,
1205: p_data => x_msg_data

Line 1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1204: (p_count => x_msg_count,
1205: p_data => x_msg_data
1206: );
1207:
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1210: ROLLBACK TO create_ctr_associations_pub;
1211: FND_MSG_PUB.Count_And_Get
1212: (p_count => x_msg_count,

Line 1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1205: p_data => x_msg_data
1206: );
1207:
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1210: ROLLBACK TO create_ctr_associations_pub;
1211: FND_MSG_PUB.Count_And_Get
1212: (p_count => x_msg_count,
1213: p_data => x_msg_data

Line 1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1212: (p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );
1215: WHEN OTHERS THEN
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1217: ROLLBACK TO create_ctr_associations_pub;
1218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: FND_MSG_PUB.Add_Exc_Msg

Line 1268: IF NOT FND_API.Compatible_API_Call (l_api_version,

1264: -- Standard Start of API savepoint
1265: SAVEPOINT create_reading_lock_pub;
1266:
1267: -- Standard call to check for call compatibility.
1268: IF NOT FND_API.Compatible_API_Call (l_api_version,
1269: p_api_version,
1270: l_api_name ,
1271: G_PKG_NAME )
1272: THEN

Line 1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1269: p_api_version,
1270: l_api_name ,
1271: G_PKG_NAME )
1272: THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: -- Initialize message list if p_init_msg_list is set to TRUE.
1277: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 1277: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: -- Initialize message list if p_init_msg_list is set to TRUE.
1277: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1278: FND_MSG_PUB.initialize;
1279: END IF;
1280:
1281: -- Initialize API return status to success

Line 1282: x_return_status := FND_API.G_RET_STS_SUCCESS;

1278: FND_MSG_PUB.initialize;
1279: END IF;
1280:
1281: -- Initialize API return status to success
1282: x_return_status := FND_API.G_RET_STS_SUCCESS;
1283:
1284: -- Read the debug profiles values in to global variable 7197402
1285: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1286:

Line 1319: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1315: ,x_msg_count => x_msg_count
1316: ,x_msg_data => x_msg_data
1317: ,x_reading_lock_id => x_reading_lock_id
1318: );
1319: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1320: l_msg_index := 1;
1321: l_msg_count := x_msg_count;
1322:
1323: WHILE l_msg_count > 0 LOOP

Line 1326: FND_API.G_FALSE );

1322:
1323: WHILE l_msg_count > 0 LOOP
1324: x_msg_data := FND_MSG_PUB.GET
1325: (l_msg_index,
1326: FND_API.G_FALSE );
1327: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_READING_LOCK_PRE API');
1328: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1329: l_msg_index := l_msg_index + 1;
1330: l_msg_count := l_msg_count - 1;

Line 1332: RAISE FND_API.G_EXC_ERROR;

1328: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1329: l_msg_index := l_msg_index + 1;
1330: l_msg_count := l_msg_count - 1;
1331: END LOOP;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334: END IF;
1335: /* Vertical pre -processing section - Mandatory */
1336: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) ) THEN

Line 1349: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1345: ,x_msg_count => x_msg_count
1346: ,x_msg_data => x_msg_data
1347: ,x_reading_lock_id => x_reading_lock_id
1348: );
1349: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1350: l_msg_index := 1;
1351: l_msg_count := x_msg_count;
1352:
1353: WHILE l_msg_count > 0 LOOP

Line 1356: FND_API.G_FALSE );

1352:
1353: WHILE l_msg_count > 0 LOOP
1354: x_msg_data := FND_MSG_PUB.GET
1355: (l_msg_index,
1356: FND_API.G_FALSE );
1357: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_READING_LOCK_PRE API');
1358: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1359: l_msg_index := l_msg_index + 1;
1360: l_msg_count := l_msg_count - 1;

Line 1362: RAISE FND_API.G_EXC_ERROR;

1358: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1359: l_msg_index := l_msg_index + 1;
1360: l_msg_count := l_msg_count - 1;
1361: END LOOP;
1362: RAISE FND_API.G_EXC_ERROR;
1363: END IF;
1364: END IF;
1365:
1366: -- Start of API Body

Line 1380: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1376: ,x_msg_count => x_msg_count
1377: ,x_msg_data => x_msg_data
1378: ,x_reading_lock_id => l_reading_lock_id
1379: );
1380: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1381: l_msg_index := 1;
1382: l_msg_count := x_msg_count;
1383:
1384: WHILE l_msg_count > 0 LOOP

Line 1387: FND_API.G_FALSE );

1383:
1384: WHILE l_msg_count > 0 LOOP
1385: x_msg_data := FND_MSG_PUB.GET
1386: (l_msg_index,
1387: FND_API.G_FALSE );
1388: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_READING_LOCK API');
1389: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1390: l_msg_index := l_msg_index + 1;
1391: l_msg_count := l_msg_count - 1;

Line 1393: RAISE FND_API.G_EXC_ERROR;

1389: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1390: l_msg_index := l_msg_index + 1;
1391: l_msg_count := l_msg_count - 1;
1392: END LOOP;
1393: RAISE FND_API.G_EXC_ERROR;
1394: END IF;
1395:
1396: -- End of API body
1397:

Line 1412: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1408: ,x_msg_count => x_msg_count
1409: ,x_msg_data => x_msg_data
1410: ,x_reading_lock_id => x_reading_lock_id
1411: );
1412: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1413: l_msg_index := 1;
1414: l_msg_count := x_msg_count;
1415:
1416: WHILE l_msg_count > 0 LOOP

Line 1419: FND_API.G_FALSE );

1415:
1416: WHILE l_msg_count > 0 LOOP
1417: x_msg_data := FND_MSG_PUB.GET
1418: (l_msg_index,
1419: FND_API.G_FALSE );
1420: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_READING_LOCK_POST API');
1421: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1422: l_msg_index := l_msg_index + 1;
1423: l_msg_count := l_msg_count - 1;

Line 1425: RAISE FND_API.G_EXC_ERROR;

1421: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1422: l_msg_index := l_msg_index + 1;
1423: l_msg_count := l_msg_count - 1;
1424: END LOOP;
1425: RAISE FND_API.G_EXC_ERROR;
1426: END IF;
1427: END IF;
1428: /* Vertical post -processing section - Mandatory */
1429: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) ) THEN

Line 1442: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1438: ,x_msg_count => x_msg_count
1439: ,x_msg_data => x_msg_data
1440: ,x_reading_lock_id => x_reading_lock_id
1441: );
1442: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1443: l_msg_index := 1;
1444: l_msg_count := x_msg_count;
1445:
1446: WHILE l_msg_count > 0 LOOP

Line 1449: FND_API.G_FALSE );

1445:
1446: WHILE l_msg_count > 0 LOOP
1447: x_msg_data := FND_MSG_PUB.GET
1448: (l_msg_index,
1449: FND_API.G_FALSE );
1450: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_READING_LOCK_POST API');
1451: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1452: l_msg_index := l_msg_index + 1;
1453: l_msg_count := l_msg_count - 1;

Line 1455: RAISE FND_API.G_EXC_ERROR;

1451: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1452: l_msg_index := l_msg_index + 1;
1453: l_msg_count := l_msg_count - 1;
1454: END LOOP;
1455: RAISE FND_API.G_EXC_ERROR;
1456: END IF;
1457: END IF;
1458:
1459:

Line 1462: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

1458:
1459:
1460:
1461: -- Standard check of p_commit.
1462: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1463: COMMIT WORK;
1464: END IF;
1465:
1466: EXCEPTION

Line 1467: WHEN FND_API.G_EXC_ERROR THEN

1463: COMMIT WORK;
1464: END IF;
1465:
1466: EXCEPTION
1467: WHEN FND_API.G_EXC_ERROR THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR ;
1469: ROLLBACK TO create_reading_lock_pub;
1470: FND_MSG_PUB.Count_And_Get
1471: (p_count => x_msg_count,

Line 1468: x_return_status := FND_API.G_RET_STS_ERROR ;

1464: END IF;
1465:
1466: EXCEPTION
1467: WHEN FND_API.G_EXC_ERROR THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR ;
1469: ROLLBACK TO create_reading_lock_pub;
1470: FND_MSG_PUB.Count_And_Get
1471: (p_count => x_msg_count,
1472: p_data => x_msg_data

Line 1475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1471: (p_count => x_msg_count,
1472: p_data => x_msg_data
1473: );
1474:
1475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477: ROLLBACK TO create_reading_lock_pub;
1478: FND_MSG_PUB.Count_And_Get
1479: (p_count => x_msg_count,

Line 1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1472: p_data => x_msg_data
1473: );
1474:
1475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477: ROLLBACK TO create_reading_lock_pub;
1478: FND_MSG_PUB.Count_And_Get
1479: (p_count => x_msg_count,
1480: p_data => x_msg_data

Line 1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1479: (p_count => x_msg_count,
1480: p_data => x_msg_data
1481: );
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1484: ROLLBACK TO create_reading_lock_pub;
1485: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1486: THEN
1487: FND_MSG_PUB.Add_Exc_Msg

Line 1535: IF NOT FND_API.Compatible_API_Call (l_api_version,

1531: -- Standard Start of API savepoint
1532: SAVEPOINT create_daily_usage_pub;
1533:
1534: -- Standard call to check for call compatibility.
1535: IF NOT FND_API.Compatible_API_Call (l_api_version,
1536: p_api_version,
1537: l_api_name ,
1538: G_PKG_NAME )
1539: THEN

Line 1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1536: p_api_version,
1537: l_api_name ,
1538: G_PKG_NAME )
1539: THEN
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542:
1543: -- Initialize message list if p_init_msg_list is set to TRUE.
1544: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 1544: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542:
1543: -- Initialize message list if p_init_msg_list is set to TRUE.
1544: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1545: FND_MSG_PUB.initialize;
1546: END IF;
1547:
1548: -- Initialize API return status to success

Line 1549: x_return_status := FND_API.G_RET_STS_SUCCESS;

1545: FND_MSG_PUB.initialize;
1546: END IF;
1547:
1548: -- Initialize API return status to success
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;
1550:
1551: -- Read the debug profiles values in to global variable 7197402
1552: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1553:

Line 1586: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1582: ,x_msg_count => x_msg_count
1583: ,x_msg_data => x_msg_data
1584: ,x_instance_forecast_id => x_instance_forecast_id
1585: );
1586: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1587: l_msg_index := 1;
1588: l_msg_count := x_msg_count;
1589:
1590: WHILE l_msg_count > 0 LOOP

Line 1593: FND_API.G_FALSE );

1589:
1590: WHILE l_msg_count > 0 LOOP
1591: x_msg_data := FND_MSG_PUB.GET
1592: (l_msg_index,
1593: FND_API.G_FALSE );
1594: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_DAILY_USAGE_PRE API');
1595: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1596: l_msg_index := l_msg_index + 1;
1597: l_msg_count := l_msg_count - 1;

Line 1599: RAISE FND_API.G_EXC_ERROR;

1595: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1596: l_msg_index := l_msg_index + 1;
1597: l_msg_count := l_msg_count - 1;
1598: END LOOP;
1599: RAISE FND_API.G_EXC_ERROR;
1600: END IF;
1601: END IF;
1602: /* Vertical pre -processing section - Mandatory */
1603: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) ) THEN

Line 1616: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1612: ,x_msg_count => x_msg_count
1613: ,x_msg_data => x_msg_data
1614: ,x_instance_forecast_id => x_instance_forecast_id
1615: );
1616: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1617: l_msg_index := 1;
1618: l_msg_count := x_msg_count;
1619:
1620: WHILE l_msg_count > 0 LOOP

Line 1623: FND_API.G_FALSE );

1619:
1620: WHILE l_msg_count > 0 LOOP
1621: x_msg_data := FND_MSG_PUB.GET
1622: (l_msg_index,
1623: FND_API.G_FALSE );
1624: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_DAILY_USAGE_PRE API');
1625: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1626: l_msg_index := l_msg_index + 1;
1627: l_msg_count := l_msg_count - 1;

Line 1629: RAISE FND_API.G_EXC_ERROR;

1625: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1626: l_msg_index := l_msg_index + 1;
1627: l_msg_count := l_msg_count - 1;
1628: END LOOP;
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1631: END IF;
1632:
1633: -- Start of API Body

Line 1647: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1643: ,x_msg_count => x_msg_count
1644: ,x_msg_data => x_msg_data
1645: ,x_instance_forecast_id => l_instance_forecast_id
1646: );
1647: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1648: l_msg_index := 1;
1649: l_msg_count := x_msg_count;
1650:
1651: WHILE l_msg_count > 0 LOOP

Line 1654: FND_API.G_FALSE );

1650:
1651: WHILE l_msg_count > 0 LOOP
1652: x_msg_data := FND_MSG_PUB.GET
1653: (l_msg_index,
1654: FND_API.G_FALSE );
1655: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_DAILY_USAGE API');
1656: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1657: l_msg_index := l_msg_index + 1;
1658: l_msg_count := l_msg_count - 1;

Line 1660: RAISE FND_API.G_EXC_ERROR;

1656: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1657: l_msg_index := l_msg_index + 1;
1658: l_msg_count := l_msg_count - 1;
1659: END LOOP;
1660: RAISE FND_API.G_EXC_ERROR;
1661: END IF;
1662:
1663: -- End of API body
1664:

Line 1679: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1675: ,x_msg_count => x_msg_count
1676: ,x_msg_data => x_msg_data
1677: ,x_instance_forecast_id => x_instance_forecast_id
1678: );
1679: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1680: l_msg_index := 1;
1681: l_msg_count := x_msg_count;
1682:
1683: WHILE l_msg_count > 0 LOOP

Line 1686: FND_API.G_FALSE );

1682:
1683: WHILE l_msg_count > 0 LOOP
1684: x_msg_data := FND_MSG_PUB.GET
1685: (l_msg_index,
1686: FND_API.G_FALSE );
1687: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_DAILY_USAGE_POST API');
1688: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1689: l_msg_index := l_msg_index + 1;
1690: l_msg_count := l_msg_count - 1;

Line 1692: RAISE FND_API.G_EXC_ERROR;

1688: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1689: l_msg_index := l_msg_index + 1;
1690: l_msg_count := l_msg_count - 1;
1691: END LOOP;
1692: RAISE FND_API.G_EXC_ERROR;
1693: END IF;
1694: END IF;
1695: /* Vertical post -processing section - Mandatory */
1696: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) ) THEN

Line 1709: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1705: ,x_msg_count => x_msg_count
1706: ,x_msg_data => x_msg_data
1707: ,x_instance_forecast_id => x_instance_forecast_id
1708: );
1709: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1710: l_msg_index := 1;
1711: l_msg_count := x_msg_count;
1712:
1713: WHILE l_msg_count > 0 LOOP

Line 1716: FND_API.G_FALSE );

1712:
1713: WHILE l_msg_count > 0 LOOP
1714: x_msg_data := FND_MSG_PUB.GET
1715: (l_msg_index,
1716: FND_API.G_FALSE );
1717: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_DAILY_USAGE_POST API');
1718: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1719: l_msg_index := l_msg_index + 1;
1720: l_msg_count := l_msg_count - 1;

Line 1722: RAISE FND_API.G_EXC_ERROR;

1718: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1719: l_msg_index := l_msg_index + 1;
1720: l_msg_count := l_msg_count - 1;
1721: END LOOP;
1722: RAISE FND_API.G_EXC_ERROR;
1723: END IF;
1724: END IF;
1725:
1726: -- Standard check of p_commit.

Line 1727: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

1723: END IF;
1724: END IF;
1725:
1726: -- Standard check of p_commit.
1727: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1728: COMMIT WORK;
1729: END IF;
1730:
1731: EXCEPTION

Line 1732: WHEN FND_API.G_EXC_ERROR THEN

1728: COMMIT WORK;
1729: END IF;
1730:
1731: EXCEPTION
1732: WHEN FND_API.G_EXC_ERROR THEN
1733: x_return_status := FND_API.G_RET_STS_ERROR ;
1734: ROLLBACK TO create_daily_usage_pub;
1735: FND_MSG_PUB.Count_And_Get
1736: (p_count => x_msg_count,

Line 1733: x_return_status := FND_API.G_RET_STS_ERROR ;

1729: END IF;
1730:
1731: EXCEPTION
1732: WHEN FND_API.G_EXC_ERROR THEN
1733: x_return_status := FND_API.G_RET_STS_ERROR ;
1734: ROLLBACK TO create_daily_usage_pub;
1735: FND_MSG_PUB.Count_And_Get
1736: (p_count => x_msg_count,
1737: p_data => x_msg_data

Line 1740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1736: (p_count => x_msg_count,
1737: p_data => x_msg_data
1738: );
1739:
1740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1742: ROLLBACK TO create_daily_usage_pub;
1743: FND_MSG_PUB.Count_And_Get
1744: (p_count => x_msg_count,

Line 1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1737: p_data => x_msg_data
1738: );
1739:
1740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1742: ROLLBACK TO create_daily_usage_pub;
1743: FND_MSG_PUB.Count_And_Get
1744: (p_count => x_msg_count,
1745: p_data => x_msg_data

Line 1748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1744: (p_count => x_msg_count,
1745: p_data => x_msg_data
1746: );
1747: WHEN OTHERS THEN
1748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1749: ROLLBACK TO create_daily_usage_pub;
1750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1751: THEN
1752: FND_MSG_PUB.Add_Exc_Msg

Line 1806: IF NOT FND_API.Compatible_API_Call (l_api_version,

1802: -- Standard Start of API savepoint
1803: SAVEPOINT update_counter_pub;
1804:
1805: -- Standard call to check for call compatibility.
1806: IF NOT FND_API.Compatible_API_Call (l_api_version,
1807: p_api_version,
1808: l_api_name ,
1809: G_PKG_NAME )
1810: THEN

Line 1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1807: p_api_version,
1808: l_api_name ,
1809: G_PKG_NAME )
1810: THEN
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: END IF;
1813:
1814: -- Initialize message list if p_init_msg_list is set to TRUE.
1815: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 1815: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: END IF;
1813:
1814: -- Initialize message list if p_init_msg_list is set to TRUE.
1815: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1816: FND_MSG_PUB.initialize;
1817: END IF;
1818:
1819: -- Initialize API return status to success

Line 1820: x_return_status := FND_API.G_RET_STS_SUCCESS;

1816: FND_MSG_PUB.initialize;
1817: END IF;
1818:
1819: -- Initialize API return status to success
1820: x_return_status := FND_API.G_RET_STS_SUCCESS;
1821:
1822: -- Read the debug profiles values in to global variable 7197402
1823: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
1824:

Line 1860: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1856: ,x_return_status => x_return_status
1857: ,x_msg_count => x_msg_count
1858: ,x_msg_data => x_msg_data
1859: );
1860: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1861: l_msg_index := 1;
1862: l_msg_count := x_msg_count;
1863:
1864: WHILE l_msg_count > 0 LOOP

Line 1867: FND_API.G_FALSE );

1863:
1864: WHILE l_msg_count > 0 LOOP
1865: x_msg_data := FND_MSG_PUB.GET
1866: (l_msg_index,
1867: FND_API.G_FALSE );
1868: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_COUNTER_PRE API');
1869: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1870: l_msg_index := l_msg_index + 1;
1871: l_msg_count := l_msg_count - 1;

Line 1873: RAISE FND_API.G_EXC_ERROR;

1869: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1870: l_msg_index := l_msg_index + 1;
1871: l_msg_count := l_msg_count - 1;
1872: END LOOP;
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;
1875: END IF;
1876: /* Vertical pre -processing section - Mandatory */
1877: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) ) THEN

Line 1893: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1889: ,x_return_status => x_return_status
1890: ,x_msg_count => x_msg_count
1891: ,x_msg_data => x_msg_data
1892: );
1893: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1894: l_msg_index := 1;
1895: l_msg_count := x_msg_count;
1896:
1897: WHILE l_msg_count > 0 LOOP

Line 1900: FND_API.G_FALSE );

1896:
1897: WHILE l_msg_count > 0 LOOP
1898: x_msg_data := FND_MSG_PUB.GET
1899: (l_msg_index,
1900: FND_API.G_FALSE );
1901: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_COUNTER_PRE API');
1902: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1903: l_msg_index := l_msg_index + 1;
1904: l_msg_count := l_msg_count - 1;

Line 1906: RAISE FND_API.G_EXC_ERROR;

1902: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1903: l_msg_index := l_msg_index + 1;
1904: l_msg_count := l_msg_count - 1;
1905: END LOOP;
1906: RAISE FND_API.G_EXC_ERROR;
1907: END IF;
1908: END IF;
1909:
1910: -- Start of API Body

Line 1922: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1918: ,x_return_status => x_return_status
1919: ,x_msg_count => x_msg_count
1920: ,x_msg_data => x_msg_data
1921: );
1922: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1923: l_msg_index := 1;
1924: l_msg_count := x_msg_count;
1925:
1926: WHILE l_msg_count > 0 LOOP

Line 1929: FND_API.G_FALSE );

1925:
1926: WHILE l_msg_count > 0 LOOP
1927: x_msg_data := FND_MSG_PUB.GET
1928: (l_msg_index,
1929: FND_API.G_FALSE );
1930: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_COUNTER API');
1931: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1932: l_msg_index := l_msg_index + 1;
1933: l_msg_count := l_msg_count - 1;

Line 1935: RAISE FND_API.G_EXC_ERROR;

1931: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1932: l_msg_index := l_msg_index + 1;
1933: l_msg_count := l_msg_count - 1;
1934: END LOOP;
1935: RAISE FND_API.G_EXC_ERROR;
1936: END IF;
1937:
1938: -- Update Counter Properties
1939: IF p_ctr_properties_tbl.count > 0 THEN

Line 1976: If l_Ctr_properties_rec.COUNTER_PROPERTY_ID = FND_API.G_MISS_NUM THEN

1972: l_Ctr_properties_rec.ATTRIBUTE14 := p_ctr_properties_tbl(j).ATTRIBUTE14;
1973: l_Ctr_properties_rec.ATTRIBUTE15 := p_ctr_properties_tbl(j).ATTRIBUTE15;
1974: l_Ctr_properties_rec.ATTRIBUTE_CATEGORY := p_ctr_properties_tbl(j).ATTRIBUTE_CATEGORY;
1975:
1976: If l_Ctr_properties_rec.COUNTER_PROPERTY_ID = FND_API.G_MISS_NUM THEN
1977: l_Ctr_properties_rec.COUNTER_PROPERTY_ID := null;
1978: END IF;
1979:
1980: IF l_Ctr_properties_rec.COUNTER_PROPERTY_ID IS NOT NULL THEN

Line 1992: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1988: ,x_return_status => x_return_status
1989: ,x_msg_count => x_msg_count
1990: ,x_msg_data => x_msg_data
1991: );
1992: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1993: l_msg_index := 1;
1994: l_msg_count := x_msg_count;
1995:
1996: WHILE l_msg_count > 0 LOOP

Line 1999: FND_API.G_FALSE );

1995:
1996: WHILE l_msg_count > 0 LOOP
1997: x_msg_data := FND_MSG_PUB.GET
1998: (l_msg_index,
1999: FND_API.G_FALSE );
2000: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_PROPERTY API');
2001: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2002: l_msg_index := l_msg_index + 1;
2003: l_msg_count := l_msg_count - 1;

Line 2005: RAISE FND_API.G_EXC_ERROR;

2001: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2002: l_msg_index := l_msg_index + 1;
2003: l_msg_count := l_msg_count - 1;
2004: END LOOP;
2005: RAISE FND_API.G_EXC_ERROR;
2006: END IF;
2007: ELSE -- PROPERTY ID IS NULL. INSERT NEW PROPERTY
2008: l_Ctr_properties_rec.counter_id := p_counter_instance_rec.counter_id;
2009: CSI_COUNTER_PVT.create_ctr_property

Line 2021: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2017: ,x_msg_count => x_msg_count
2018: ,x_msg_data => x_msg_data
2019: ,x_ctr_property_id => l_ctr_property_id
2020: );
2021: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2022: l_msg_index := 1;
2023: l_msg_count := x_msg_count;
2024:
2025: WHILE l_msg_count > 0 LOOP

Line 2028: FND_API.G_FALSE );

2024:
2025: WHILE l_msg_count > 0 LOOP
2026: x_msg_data := FND_MSG_PUB.GET
2027: (l_msg_index,
2028: FND_API.G_FALSE );
2029: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_PROPERTY API');
2030: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2031: l_msg_index := l_msg_index + 1;
2032: l_msg_count := l_msg_count - 1;

Line 2034: RAISE FND_API.G_EXC_ERROR;

2030: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2031: l_msg_index := l_msg_index + 1;
2032: l_msg_count := l_msg_count - 1;
2033: END LOOP;
2034: RAISE FND_API.G_EXC_ERROR;
2035: END IF;
2036: END IF;
2037: END;
2038: END LOOP;

Line 2073: IF l_counter_relationships_rec.RELATIONSHIP_ID = FND_API.G_MISS_NUM THEN

2069: l_counter_relationships_rec.ATTRIBUTE14 := p_counter_relationships_tbl(i).ATTRIBUTE14;
2070: l_counter_relationships_rec.ATTRIBUTE15 := p_counter_relationships_tbl(i).ATTRIBUTE15;
2071: l_counter_relationships_rec.ATTRIBUTE_CATEGORY := p_counter_relationships_tbl(i).ATTRIBUTE_CATEGORY;
2072:
2073: IF l_counter_relationships_rec.RELATIONSHIP_ID = FND_API.G_MISS_NUM THEN
2074: l_counter_relationships_rec.RELATIONSHIP_ID := NULL;
2075: END IF;
2076:
2077: IF l_counter_relationships_rec.RELATIONSHIP_ID IS NOT NULL THEN

Line 2089: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2085: ,x_return_status => x_return_status
2086: ,x_msg_count => x_msg_count
2087: ,x_msg_data => x_msg_data
2088: );
2089: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2090: l_msg_index := 1;
2091: l_msg_count := x_msg_count;
2092:
2093: WHILE l_msg_count > 0 LOOP

Line 2096: FND_API.G_FALSE );

2092:
2093: WHILE l_msg_count > 0 LOOP
2094: x_msg_data := FND_MSG_PUB.GET
2095: (l_msg_index,
2096: FND_API.G_FALSE );
2097: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP API');
2098: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2099: l_msg_index := l_msg_index + 1;
2100: l_msg_count := l_msg_count - 1;

Line 2102: RAISE FND_API.G_EXC_ERROR;

2098: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2099: l_msg_index := l_msg_index + 1;
2100: l_msg_count := l_msg_count - 1;
2101: END LOOP;
2102: RAISE FND_API.G_EXC_ERROR;
2103: END IF;
2104: ELSE --RELATIONSHIP_ID is null, call to insert counter relationship
2105: l_counter_relationships_rec.OBJECT_COUNTER_ID := p_counter_instance_rec.counter_id;
2106: CSI_COUNTER_TEMPLATE_PVT.create_counter_relationship

Line 2117: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2113: ,x_return_status => x_return_status
2114: ,x_msg_count => x_msg_count
2115: ,x_msg_data => x_msg_data
2116: );
2117: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2118: l_msg_index := 1;
2119: l_msg_count := x_msg_count;
2120:
2121: WHILE l_msg_count > 0 LOOP

Line 2124: FND_API.G_FALSE );

2120:
2121: WHILE l_msg_count > 0 LOOP
2122: x_msg_data := FND_MSG_PUB.GET
2123: (l_msg_index,
2124: FND_API.G_FALSE );
2125: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_RELATIONSHIP API');
2126: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2127: l_msg_index := l_msg_index + 1;
2128: l_msg_count := l_msg_count - 1;

Line 2130: RAISE FND_API.G_EXC_ERROR;

2126: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2127: l_msg_index := l_msg_index + 1;
2128: l_msg_count := l_msg_count - 1;
2129: END LOOP;
2130: RAISE FND_API.G_EXC_ERROR;
2131: END IF;
2132: END IF;
2133: END;
2134: END LOOP;

Line 2158: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2154: ,x_return_status => x_return_status
2155: ,x_msg_count => x_msg_count
2156: ,x_msg_data => x_msg_data
2157: );
2158: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2159: l_msg_index := 1;
2160: l_msg_count := x_msg_count;
2161:
2162: WHILE l_msg_count > 0 LOOP

Line 2165: FND_API.G_FALSE );

2161:
2162: WHILE l_msg_count > 0 LOOP
2163: x_msg_data := FND_MSG_PUB.GET
2164: (l_msg_index,
2165: FND_API.G_FALSE );
2166: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS API');
2167: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2168: l_msg_index := l_msg_index + 1;
2169: l_msg_count := l_msg_count - 1;

Line 2171: RAISE FND_API.G_EXC_ERROR;

2167: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2168: l_msg_index := l_msg_index + 1;
2169: l_msg_count := l_msg_count - 1;
2170: END LOOP;
2171: RAISE FND_API.G_EXC_ERROR;
2172: END IF;
2173: END IF;
2174: -- Update Counter associations
2175:

Line 2207: IF l_counter_associations_rec.instance_association_id = FND_API.G_MISS_NUM THEN

2203: l_counter_associations_rec.ATTRIBUTE_CATEGORY := p_counter_associations_tbl(i).ATTRIBUTE_CATEGORY;
2204: l_counter_associations_rec.maint_organization_id := p_counter_associations_tbl(i).maint_organization_id;
2205: l_counter_associations_rec.primary_failure_flag := p_counter_associations_tbl(i).primary_failure_flag;
2206:
2207: IF l_counter_associations_rec.instance_association_id = FND_API.G_MISS_NUM THEN
2208: l_counter_associations_rec.instance_association_id := NULL;
2209: END IF;
2210:
2211: IF l_counter_associations_rec.instance_association_id IS NOT NULL THEN

Line 2223: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2219: ,x_return_status => x_return_status
2220: ,x_msg_count => x_msg_count
2221: ,x_msg_data => x_msg_data
2222: );
2223: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2224: l_msg_index := 1;
2225: l_msg_count := x_msg_count;
2226:
2227: WHILE l_msg_count > 0 LOOP

Line 2230: FND_API.G_FALSE );

2226:
2227: WHILE l_msg_count > 0 LOOP
2228: x_msg_data := FND_MSG_PUB.GET
2229: (l_msg_index,
2230: FND_API.G_FALSE );
2231: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_ASSOCIATIONS API');
2232: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2233: l_msg_index := l_msg_index + 1;
2234: l_msg_count := l_msg_count - 1;

Line 2236: RAISE FND_API.G_EXC_ERROR;

2232: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2233: l_msg_index := l_msg_index + 1;
2234: l_msg_count := l_msg_count - 1;
2235: END LOOP;
2236: RAISE FND_API.G_EXC_ERROR;
2237: END IF;
2238: ELSE --instance_association_id is null. insert new counter association
2239: l_counter_associations_rec.COUNTER_ID := p_counter_instance_rec.counter_id;
2240: CSI_COUNTER_PVT.create_ctr_associations

Line 2252: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2248: ,x_msg_count => x_msg_count
2249: ,x_msg_data => x_msg_data
2250: ,x_instance_association_id => l_instance_association_id
2251: );
2252: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2253: l_msg_index := 1;
2254: l_msg_count := x_msg_count;
2255:
2256: WHILE l_msg_count > 0 LOOP

Line 2259: FND_API.G_FALSE );

2255:
2256: WHILE l_msg_count > 0 LOOP
2257: x_msg_data := FND_MSG_PUB.GET
2258: (l_msg_index,
2259: FND_API.G_FALSE );
2260: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS API');
2261: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2262: l_msg_index := l_msg_index + 1;
2263: l_msg_count := l_msg_count - 1;

Line 2265: RAISE FND_API.G_EXC_ERROR;

2261: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2262: l_msg_index := l_msg_index + 1;
2263: l_msg_count := l_msg_count - 1;
2264: END LOOP;
2265: RAISE FND_API.G_EXC_ERROR;
2266: END IF;
2267: END IF;
2268: END;
2269: END LOOP;

Line 2292: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2288: ,x_return_status => x_return_status
2289: ,x_msg_count => x_msg_count
2290: ,x_msg_data => x_msg_data
2291: );
2292: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2293: l_msg_index := 1;
2294: l_msg_count := x_msg_count;
2295:
2296: WHILE l_msg_count > 0 LOOP

Line 2299: FND_API.G_FALSE );

2295:
2296: WHILE l_msg_count > 0 LOOP
2297: x_msg_data := FND_MSG_PUB.GET
2298: (l_msg_index,
2299: FND_API.G_FALSE );
2300: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_COUNTER_POST API');
2301: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2302: l_msg_index := l_msg_index + 1;
2303: l_msg_count := l_msg_count - 1;

Line 2305: RAISE FND_API.G_EXC_ERROR;

2301: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2302: l_msg_index := l_msg_index + 1;
2303: l_msg_count := l_msg_count - 1;
2304: END LOOP;
2305: RAISE FND_API.G_EXC_ERROR;
2306: END IF;
2307: END IF;
2308: /* Vertical post -processing section - Mandatory */
2309: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) ) THEN

Line 2325: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2321: ,x_return_status => x_return_status
2322: ,x_msg_count => x_msg_count
2323: ,x_msg_data => x_msg_data
2324: );
2325: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2326: l_msg_index := 1;
2327: l_msg_count := x_msg_count;
2328:
2329: WHILE l_msg_count > 0 LOOP

Line 2332: FND_API.G_FALSE );

2328:
2329: WHILE l_msg_count > 0 LOOP
2330: x_msg_data := FND_MSG_PUB.GET
2331: (l_msg_index,
2332: FND_API.G_FALSE );
2333: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_COUNTER_POST API');
2334: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2335: l_msg_index := l_msg_index + 1;
2336: l_msg_count := l_msg_count - 1;

Line 2338: RAISE FND_API.G_EXC_ERROR;

2334: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2335: l_msg_index := l_msg_index + 1;
2336: l_msg_count := l_msg_count - 1;
2337: END LOOP;
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340: END IF;
2341:
2342: -- Standard check of p_commit.

Line 2343: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

2339: END IF;
2340: END IF;
2341:
2342: -- Standard check of p_commit.
2343: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2344: COMMIT WORK;
2345: END IF;
2346:
2347: EXCEPTION

Line 2348: WHEN FND_API.G_EXC_ERROR THEN

2344: COMMIT WORK;
2345: END IF;
2346:
2347: EXCEPTION
2348: WHEN FND_API.G_EXC_ERROR THEN
2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350: ROLLBACK TO update_counter_pub;
2351: FND_MSG_PUB.Count_And_Get
2352: (p_count => x_msg_count,

Line 2349: x_return_status := FND_API.G_RET_STS_ERROR ;

2345: END IF;
2346:
2347: EXCEPTION
2348: WHEN FND_API.G_EXC_ERROR THEN
2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350: ROLLBACK TO update_counter_pub;
2351: FND_MSG_PUB.Count_And_Get
2352: (p_count => x_msg_count,
2353: p_data => x_msg_data

Line 2356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2352: (p_count => x_msg_count,
2353: p_data => x_msg_data
2354: );
2355:
2356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: ROLLBACK TO update_counter_pub;
2359: FND_MSG_PUB.Count_And_Get
2360: (p_count => x_msg_count,

Line 2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2353: p_data => x_msg_data
2354: );
2355:
2356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: ROLLBACK TO update_counter_pub;
2359: FND_MSG_PUB.Count_And_Get
2360: (p_count => x_msg_count,
2361: p_data => x_msg_data

Line 2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2360: (p_count => x_msg_count,
2361: p_data => x_msg_data
2362: );
2363: WHEN OTHERS THEN
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2365: ROLLBACK TO update_counter_pub;
2366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2367: THEN
2368: FND_MSG_PUB.Add_Exc_Msg

Line 2415: IF NOT FND_API.Compatible_API_Call (l_api_version,

2411: -- Standard Start of API savepoint
2412: SAVEPOINT update_ctr_property_pub;
2413:
2414: -- Standard call to check for call compatibility.
2415: IF NOT FND_API.Compatible_API_Call (l_api_version,
2416: p_api_version,
2417: l_api_name ,
2418: G_PKG_NAME )
2419: THEN

Line 2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2416: p_api_version,
2417: l_api_name ,
2418: G_PKG_NAME )
2419: THEN
2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2421: END IF;
2422:
2423: -- Initialize message list if p_init_msg_list is set to TRUE.
2424: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 2424: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

2420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2421: END IF;
2422:
2423: -- Initialize message list if p_init_msg_list is set to TRUE.
2424: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2425: FND_MSG_PUB.initialize;
2426: END IF;
2427:
2428: -- Initialize API return status to success

Line 2429: x_return_status := FND_API.G_RET_STS_SUCCESS;

2425: FND_MSG_PUB.initialize;
2426: END IF;
2427:
2428: -- Initialize API return status to success
2429: x_return_status := FND_API.G_RET_STS_SUCCESS;
2430:
2431: -- Read the debug profiles values in to global variable 7197402
2432: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2433:

Line 2465: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2461: ,x_return_status => x_return_status
2462: ,x_msg_count => x_msg_count
2463: ,x_msg_data => x_msg_data
2464: );
2465: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2466: l_msg_index := 1;
2467: l_msg_count := x_msg_count;
2468:
2469: WHILE l_msg_count > 0 LOOP

Line 2472: FND_API.G_FALSE );

2468:
2469: WHILE l_msg_count > 0 LOOP
2470: x_msg_data := FND_MSG_PUB.GET
2471: (l_msg_index,
2472: FND_API.G_FALSE );
2473: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_PROPERTY_PRE API');
2474: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2475: l_msg_index := l_msg_index + 1;
2476: l_msg_count := l_msg_count - 1;

Line 2478: RAISE FND_API.G_EXC_ERROR;

2474: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2475: l_msg_index := l_msg_index + 1;
2476: l_msg_count := l_msg_count - 1;
2477: END LOOP;
2478: RAISE FND_API.G_EXC_ERROR;
2479: END IF;
2480: END IF;
2481: /* Vertical pre -processing section - Mandatory */
2482: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'V' ) ) THEN

Line 2494: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2490: ,x_return_status => x_return_status
2491: ,x_msg_count => x_msg_count
2492: ,x_msg_data => x_msg_data
2493: );
2494: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2495: l_msg_index := 1;
2496: l_msg_count := x_msg_count;
2497:
2498: WHILE l_msg_count > 0 LOOP

Line 2501: FND_API.G_FALSE );

2497:
2498: WHILE l_msg_count > 0 LOOP
2499: x_msg_data := FND_MSG_PUB.GET
2500: (l_msg_index,
2501: FND_API.G_FALSE );
2502: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_CTR_PROPERTY_PRE API');
2503: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2504: l_msg_index := l_msg_index + 1;
2505: l_msg_count := l_msg_count - 1;

Line 2507: RAISE FND_API.G_EXC_ERROR;

2503: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2504: l_msg_index := l_msg_index + 1;
2505: l_msg_count := l_msg_count - 1;
2506: END LOOP;
2507: RAISE FND_API.G_EXC_ERROR;
2508: END IF;
2509: END IF;
2510:
2511: -- Start of API Body

Line 2560: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2556: ,x_return_status => x_return_status
2557: ,x_msg_count => x_msg_count
2558: ,x_msg_data => x_msg_data
2559: );
2560: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2561: l_msg_index := 1;
2562: l_msg_count := x_msg_count;
2563:
2564: WHILE l_msg_count > 0 LOOP

Line 2567: FND_API.G_FALSE );

2563:
2564: WHILE l_msg_count > 0 LOOP
2565: x_msg_data := FND_MSG_PUB.GET
2566: (l_msg_index,
2567: FND_API.G_FALSE );
2568: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_PROPERTY API');
2569: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2570: l_msg_index := l_msg_index + 1;
2571: l_msg_count := l_msg_count - 1;

Line 2573: RAISE FND_API.G_EXC_ERROR;

2569: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2570: l_msg_index := l_msg_index + 1;
2571: l_msg_count := l_msg_count - 1;
2572: END LOOP;
2573: RAISE FND_API.G_EXC_ERROR;
2574: END IF;
2575: END;
2576: END LOOP;
2577: END IF;

Line 2594: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2590: ,x_return_status => x_return_status
2591: ,x_msg_count => x_msg_count
2592: ,x_msg_data => x_msg_data
2593: );
2594: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2595: l_msg_index := 1;
2596: l_msg_count := x_msg_count;
2597:
2598: WHILE l_msg_count > 0 LOOP

Line 2601: FND_API.G_FALSE );

2597:
2598: WHILE l_msg_count > 0 LOOP
2599: x_msg_data := FND_MSG_PUB.GET
2600: (l_msg_index,
2601: FND_API.G_FALSE );
2602: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_PROPERTY_POST API');
2603: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2604: l_msg_index := l_msg_index + 1;
2605: l_msg_count := l_msg_count - 1;

Line 2607: RAISE FND_API.G_EXC_ERROR;

2603: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2604: l_msg_index := l_msg_index + 1;
2605: l_msg_count := l_msg_count - 1;
2606: END LOOP;
2607: RAISE FND_API.G_EXC_ERROR;
2608: END IF;
2609: END IF;
2610: /* Vertical post -processing section - Mandatory */
2611: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'A', 'V' ) ) THEN

Line 2623: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2619: ,x_return_status => x_return_status
2620: ,x_msg_count => x_msg_count
2621: ,x_msg_data => x_msg_data
2622: );
2623: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2624: l_msg_index := 1;
2625: l_msg_count := x_msg_count;
2626:
2627: WHILE l_msg_count > 0 LOOP

Line 2630: FND_API.G_FALSE );

2626:
2627: WHILE l_msg_count > 0 LOOP
2628: x_msg_data := FND_MSG_PUB.GET
2629: (l_msg_index,
2630: FND_API.G_FALSE );
2631: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_CTR_PROPERTY_POST API');
2632: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2633: l_msg_index := l_msg_index + 1;
2634: l_msg_count := l_msg_count - 1;

Line 2636: RAISE FND_API.G_EXC_ERROR;

2632: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2633: l_msg_index := l_msg_index + 1;
2634: l_msg_count := l_msg_count - 1;
2635: END LOOP;
2636: RAISE FND_API.G_EXC_ERROR;
2637: END IF;
2638: END IF;
2639:
2640: -- Standard check of p_commit.

Line 2641: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

2637: END IF;
2638: END IF;
2639:
2640: -- Standard check of p_commit.
2641: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2642: COMMIT WORK;
2643: END IF;
2644:
2645: EXCEPTION

Line 2646: WHEN FND_API.G_EXC_ERROR THEN

2642: COMMIT WORK;
2643: END IF;
2644:
2645: EXCEPTION
2646: WHEN FND_API.G_EXC_ERROR THEN
2647: x_return_status := FND_API.G_RET_STS_ERROR ;
2648: ROLLBACK TO update_ctr_property_pub;
2649: FND_MSG_PUB.Count_And_Get
2650: (p_count => x_msg_count,

Line 2647: x_return_status := FND_API.G_RET_STS_ERROR ;

2643: END IF;
2644:
2645: EXCEPTION
2646: WHEN FND_API.G_EXC_ERROR THEN
2647: x_return_status := FND_API.G_RET_STS_ERROR ;
2648: ROLLBACK TO update_ctr_property_pub;
2649: FND_MSG_PUB.Count_And_Get
2650: (p_count => x_msg_count,
2651: p_data => x_msg_data

Line 2654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2650: (p_count => x_msg_count,
2651: p_data => x_msg_data
2652: );
2653:
2654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2656: ROLLBACK TO update_ctr_property_pub;
2657: FND_MSG_PUB.Count_And_Get
2658: (p_count => x_msg_count,

Line 2655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2651: p_data => x_msg_data
2652: );
2653:
2654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2656: ROLLBACK TO update_ctr_property_pub;
2657: FND_MSG_PUB.Count_And_Get
2658: (p_count => x_msg_count,
2659: p_data => x_msg_data

Line 2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2658: (p_count => x_msg_count,
2659: p_data => x_msg_data
2660: );
2661: WHEN OTHERS THEN
2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2663: ROLLBACK TO update_ctr_property_pub;
2664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2665: THEN
2666: FND_MSG_PUB.Add_Exc_Msg

Line 2707: IF NOT FND_API.Compatible_API_Call (l_api_version,

2703: -- Standard Start of API savepoint
2704: SAVEPOINT update_ctr_associations_pub;
2705:
2706: -- Standard call to check for call compatibility.
2707: IF NOT FND_API.Compatible_API_Call (l_api_version,
2708: p_api_version,
2709: l_api_name ,
2710: G_PKG_NAME )
2711: THEN

Line 2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2708: p_api_version,
2709: l_api_name ,
2710: G_PKG_NAME )
2711: THEN
2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714:
2715: -- Initialize message list if p_init_msg_list is set to TRUE.
2716: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

Line 2716: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

2712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2713: END IF;
2714:
2715: -- Initialize message list if p_init_msg_list is set to TRUE.
2716: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2717: FND_MSG_PUB.initialize;
2718: END IF;
2719:
2720: -- Initialize API return status to success

Line 2721: x_return_status := FND_API.G_RET_STS_SUCCESS;

2717: FND_MSG_PUB.initialize;
2718: END IF;
2719:
2720: -- Initialize API return status to success
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;
2722:
2723: -- Read the debug profiles values in to global variable 7197402
2724: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
2725:

Line 2757: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2753: ,x_return_status => x_return_status
2754: ,x_msg_count => x_msg_count
2755: ,x_msg_data => x_msg_data
2756: );
2757: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2758: l_msg_index := 1;
2759: l_msg_count := x_msg_count;
2760:
2761: WHILE l_msg_count > 0 LOOP

Line 2764: FND_API.G_FALSE );

2760:
2761: WHILE l_msg_count > 0 LOOP
2762: x_msg_data := FND_MSG_PUB.GET
2763: (l_msg_index,
2764: FND_API.G_FALSE );
2765: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_PRE API');
2766: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2767: l_msg_index := l_msg_index + 1;
2768: l_msg_count := l_msg_count - 1;

Line 2770: RAISE FND_API.G_EXC_ERROR;

2766: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2767: l_msg_index := l_msg_index + 1;
2768: l_msg_count := l_msg_count - 1;
2769: END LOOP;
2770: RAISE FND_API.G_EXC_ERROR;
2771: END IF;
2772: END IF;
2773:
2774: /* Vertical pre -processing section - Mandatory */

Line 2787: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2783: ,x_return_status => x_return_status
2784: ,x_msg_count => x_msg_count
2785: ,x_msg_data => x_msg_data
2786: );
2787: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2788: l_msg_index := 1;
2789: l_msg_count := x_msg_count;
2790:
2791: WHILE l_msg_count > 0 LOOP

Line 2794: FND_API.G_FALSE );

2790:
2791: WHILE l_msg_count > 0 LOOP
2792: x_msg_data := FND_MSG_PUB.GET
2793: (l_msg_index,
2794: FND_API.G_FALSE );
2795: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_PRE API');
2796: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2797: l_msg_index := l_msg_index + 1;
2798: l_msg_count := l_msg_count - 1;

Line 2800: RAISE FND_API.G_EXC_ERROR;

2796: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2797: l_msg_index := l_msg_index + 1;
2798: l_msg_count := l_msg_count - 1;
2799: END LOOP;
2800: RAISE FND_API.G_EXC_ERROR;
2801: END IF;
2802: END IF;
2803:
2804: -- Start of API Body

Line 2847: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2843: ,x_return_status => x_return_status
2844: ,x_msg_count => x_msg_count
2845: ,x_msg_data => x_msg_data
2846: );
2847: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2848: l_msg_index := 1;
2849: l_msg_count := x_msg_count;
2850:
2851: WHILE l_msg_count > 0 LOOP

Line 2854: FND_API.G_FALSE );

2850:
2851: WHILE l_msg_count > 0 LOOP
2852: x_msg_data := FND_MSG_PUB.GET
2853: (l_msg_index,
2854: FND_API.G_FALSE );
2855: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_ASSOCIATIONS API');
2856: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2857: l_msg_index := l_msg_index + 1;
2858: l_msg_count := l_msg_count - 1;

Line 2860: RAISE FND_API.G_EXC_ERROR;

2856: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2857: l_msg_index := l_msg_index + 1;
2858: l_msg_count := l_msg_count - 1;
2859: END LOOP;
2860: RAISE FND_API.G_EXC_ERROR;
2861: END IF;
2862: END;
2863: END LOOP;
2864: END IF;

Line 2881: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2877: ,x_return_status => x_return_status
2878: ,x_msg_count => x_msg_count
2879: ,x_msg_data => x_msg_data
2880: );
2881: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2882: l_msg_index := 1;
2883: l_msg_count := x_msg_count;
2884:
2885: WHILE l_msg_count > 0 LOOP

Line 2888: FND_API.G_FALSE );

2884:
2885: WHILE l_msg_count > 0 LOOP
2886: x_msg_data := FND_MSG_PUB.GET
2887: (l_msg_index,
2888: FND_API.G_FALSE );
2889: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_POST API');
2890: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2891: l_msg_index := l_msg_index + 1;
2892: l_msg_count := l_msg_count - 1;

Line 2894: RAISE FND_API.G_EXC_ERROR;

2890: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2891: l_msg_index := l_msg_index + 1;
2892: l_msg_count := l_msg_count - 1;
2893: END LOOP;
2894: RAISE FND_API.G_EXC_ERROR;
2895: END IF;
2896: END IF;
2897:
2898: /* Vertical pre -processing section - Mandatory */

Line 2911: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2907: ,x_return_status => x_return_status
2908: ,x_msg_count => x_msg_count
2909: ,x_msg_data => x_msg_data
2910: );
2911: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2912: l_msg_index := 1;
2913: l_msg_count := x_msg_count;
2914:
2915: WHILE l_msg_count > 0 LOOP

Line 2918: FND_API.G_FALSE );

2914:
2915: WHILE l_msg_count > 0 LOOP
2916: x_msg_data := FND_MSG_PUB.GET
2917: (l_msg_index,
2918: FND_API.G_FALSE );
2919: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_POST API');
2920: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2921: l_msg_index := l_msg_index + 1;
2922: l_msg_count := l_msg_count - 1;

Line 2924: RAISE FND_API.G_EXC_ERROR;

2920: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
2921: l_msg_index := l_msg_index + 1;
2922: l_msg_count := l_msg_count - 1;
2923: END LOOP;
2924: RAISE FND_API.G_EXC_ERROR;
2925: END IF;
2926: END IF;
2927:
2928: -- Standard check of p_commit.

Line 2929: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

2925: END IF;
2926: END IF;
2927:
2928: -- Standard check of p_commit.
2929: IF FND_API.To_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2930: COMMIT WORK;
2931: END IF;
2932:
2933: EXCEPTION

Line 2934: WHEN FND_API.G_EXC_ERROR THEN

2930: COMMIT WORK;
2931: END IF;
2932:
2933: EXCEPTION
2934: WHEN FND_API.G_EXC_ERROR THEN
2935: x_return_status := FND_API.G_RET_STS_ERROR ;
2936: ROLLBACK TO update_ctr_associations_pub;
2937: FND_MSG_PUB.Count_And_Get
2938: (p_count => x_msg_count,

Line 2935: x_return_status := FND_API.G_RET_STS_ERROR ;

2931: END IF;
2932:
2933: EXCEPTION
2934: WHEN FND_API.G_EXC_ERROR THEN
2935: x_return_status := FND_API.G_RET_STS_ERROR ;
2936: ROLLBACK TO update_ctr_associations_pub;
2937: FND_MSG_PUB.Count_And_Get
2938: (p_count => x_msg_count,
2939: p_data => x_msg_data

Line 2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2938: (p_count => x_msg_count,
2939: p_data => x_msg_data
2940: );
2941:
2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2944: ROLLBACK TO update_ctr_associations_pub;
2945: FND_MSG_PUB.Count_And_Get
2946: (p_count => x_msg_count,

Line 2943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2939: p_data => x_msg_data
2940: );
2941:
2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2944: ROLLBACK TO update_ctr_associations_pub;
2945: FND_MSG_PUB.Count_And_Get
2946: (p_count => x_msg_count,
2947: p_data => x_msg_data

Line 2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2946: (p_count => x_msg_count,
2947: p_data => x_msg_data
2948: );
2949: WHEN OTHERS THEN
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: ROLLBACK TO update_ctr_associations_pub;
2952: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2953: THEN
2954: FND_MSG_PUB.Add_Exc_Msg