DBA Data[Home] [Help]

APPS.CN_WKSHT_CT_UP_PUB dependencies on FND_API

Line 78: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

74: --
75: -- Standard call to check for call compatibility.
76: --
77:
78: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
79: p_api_version ,
80: l_api_name ,
81: G_PKG_NAME )
82: THEN

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: p_api_version ,
80: l_api_name ,
81: G_PKG_NAME )
82: THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85: --
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: --

Line 88: IF FND_API.to_Boolean( p_init_msg_list ) THEN

84: END IF;
85: --
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: --
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91: --
92: -- Initialize API return status to success

Line 94: x_return_status := FND_API.G_RET_STS_SUCCESS;

90: END IF;
91: --
92: -- Initialize API return status to success
93: --
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: --
97: -- API body
98:

Line 123: IF x_return_status <> fnd_api.g_ret_sts_success

119: x_ovn => l_ovn
120: );
121:
122:
123: IF x_return_status <> fnd_api.g_ret_sts_success
124: THEN
125: RAISE fnd_api.g_exc_error;
126: END IF;
127:

Line 125: RAISE fnd_api.g_exc_error;

121:
122:
123: IF x_return_status <> fnd_api.g_ret_sts_success
124: THEN
125: RAISE fnd_api.g_exc_error;
126: END IF;
127:
128: END LOOP;
129: close get_wksht;

Line 135: IF FND_API.To_Boolean( p_commit ) THEN

131: -- End of API body.
132:
133:
134: -- Standard check of p_commit.
135: IF FND_API.To_Boolean( p_commit ) THEN
136: COMMIT WORK;
137: END IF;
138:
139:

Line 149: p_encoded => FND_API.G_FALSE

145: FND_MSG_PUB.Count_And_Get
146: (
147: p_count => x_msg_count ,
148: p_data => x_msg_data ,
149: p_encoded => FND_API.G_FALSE
150: );
151:
152:
153: EXCEPTION

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: );
151:
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO Create_delete_Wrkhst;
156:
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: FND_MSG_PUB.Count_And_Get

Line 157: x_return_status := FND_API.G_RET_STS_ERROR ;

153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO Create_delete_Wrkhst;
156:
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: FND_MSG_PUB.Count_And_Get
159: (
160: p_count => x_msg_count ,
161: p_data => x_msg_data ,

Line 162: p_encoded => FND_API.G_FALSE

158: FND_MSG_PUB.Count_And_Get
159: (
160: p_count => x_msg_count ,
161: p_data => x_msg_data ,
162: p_encoded => FND_API.G_FALSE
163: );
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ROLLBACK TO Create_delete_Wrkhst;
166:

Line 164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

160: p_count => x_msg_count ,
161: p_data => x_msg_data ,
162: p_encoded => FND_API.G_FALSE
163: );
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ROLLBACK TO Create_delete_Wrkhst;
166:
167: x_loading_status := 'UNEXPECTED_ERR';
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ROLLBACK TO Create_delete_Wrkhst;
166:
167: x_loading_status := 'UNEXPECTED_ERR';
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
169: FND_MSG_PUB.Count_And_Get
170: (
171: p_count => x_msg_count ,
172: p_data => x_msg_data ,

Line 173: p_encoded => FND_API.G_FALSE

169: FND_MSG_PUB.Count_And_Get
170: (
171: p_count => x_msg_count ,
172: p_data => x_msg_data ,
173: p_encoded => FND_API.G_FALSE
174: );
175: WHEN OTHERS THEN
176:
177:

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

176:
177:
178: ROLLBACK TO Create_delete_Wrkhst;
179: x_loading_status := 'UNEXPECTED_ERR';
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
182: THEN
183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
184: END IF;

Line 189: p_encoded => FND_API.G_FALSE

185: FND_MSG_PUB.Count_And_Get
186: (
187: p_count => x_msg_count ,
188: p_data => x_msg_data ,
189: p_encoded => FND_API.G_FALSE
190: );
191: END Create_delete_Wrkhst ;
192:
193: --============================================================================

Line 254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

250: --
251: -- Standard call to check for call compatibility.
252: --
253:
254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
255: p_api_version ,
256: l_api_name ,
257: G_PKG_NAME )
258: THEN

Line 259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

255: p_api_version ,
256: l_api_name ,
257: G_PKG_NAME )
258: THEN
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261: --
262: -- Initialize message list if p_init_msg_list is set to TRUE.
263: --

Line 264: IF FND_API.to_Boolean( p_init_msg_list ) THEN

260: END IF;
261: --
262: -- Initialize message list if p_init_msg_list is set to TRUE.
263: --
264: IF FND_API.to_Boolean( p_init_msg_list ) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267: --
268: -- Initialize API return status to success

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: END IF;
267: --
268: -- Initialize API return status to success
269: --
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271:
272: --
273: -- API body
274:

Line 306: RAISE fnd_api.g_exc_error;

302: p_srp_pmt_plans_rec => newrec,
303: x_loading_status => x_loading_status );
304:
305: if x_loading_status <> 'CN_UPDATED' then
306: RAISE fnd_api.g_exc_error;
307: end if;
308:
309: OPEN get_wksht;
310: LOOP

Line 331: IF x_return_status <> fnd_api.g_ret_sts_success

327: x_loading_status => x_loading_status,
328: x_ovn => wksht_recs.object_version_number
329: );
330:
331: IF x_return_status <> fnd_api.g_ret_sts_success
332: THEN
333: RAISE fnd_api.g_exc_error;
334: END IF;
335:

Line 333: RAISE fnd_api.g_exc_error;

329: );
330:
331: IF x_return_status <> fnd_api.g_ret_sts_success
332: THEN
333: RAISE fnd_api.g_exc_error;
334: END IF;
335:
336: END LOOP;
337: close get_wksht;

Line 341: IF FND_API.To_Boolean( p_commit ) THEN

337: close get_wksht;
338:
339: -- End of API body.
340: -- Standard check of p_commit.
341: IF FND_API.To_Boolean( p_commit ) THEN
342: COMMIT WORK;
343: END IF;
344:
345: --

Line 353: p_encoded => FND_API.G_FALSE

349: FND_MSG_PUB.Count_And_Get
350: (
351: p_count => x_msg_count ,
352: p_data => x_msg_data ,
353: p_encoded => FND_API.G_FALSE
354: );
355:
356:
357: EXCEPTION

Line 358: WHEN FND_API.G_EXC_ERROR THEN

354: );
355:
356:
357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO Apply_payment_plan_upd;
360:
361: x_return_status := FND_API.G_RET_STS_ERROR ;
362: FND_MSG_PUB.Count_And_Get

Line 361: x_return_status := FND_API.G_RET_STS_ERROR ;

357: EXCEPTION
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO Apply_payment_plan_upd;
360:
361: x_return_status := FND_API.G_RET_STS_ERROR ;
362: FND_MSG_PUB.Count_And_Get
363: (
364: p_count => x_msg_count ,
365: p_data => x_msg_data ,

Line 366: p_encoded => FND_API.G_FALSE

362: FND_MSG_PUB.Count_And_Get
363: (
364: p_count => x_msg_count ,
365: p_data => x_msg_data ,
366: p_encoded => FND_API.G_FALSE
367: );
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO Apply_payment_plan_upd;
370:

Line 368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

364: p_count => x_msg_count ,
365: p_data => x_msg_data ,
366: p_encoded => FND_API.G_FALSE
367: );
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO Apply_payment_plan_upd;
370:
371: x_loading_status := 'UNEXPECTED_ERR';
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO Apply_payment_plan_upd;
370:
371: x_loading_status := 'UNEXPECTED_ERR';
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: FND_MSG_PUB.Count_And_Get
374: (
375: p_count => x_msg_count ,
376: p_data => x_msg_data ,

Line 377: p_encoded => FND_API.G_FALSE

373: FND_MSG_PUB.Count_And_Get
374: (
375: p_count => x_msg_count ,
376: p_data => x_msg_data ,
377: p_encoded => FND_API.G_FALSE
378: );
379: WHEN OTHERS THEN
380:
381:

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

380:
381:
382: ROLLBACK TO Apply_payment_plan_upd ;
383: x_loading_status := 'UNEXPECTED_ERR';
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
388: END IF;

Line 393: p_encoded => FND_API.G_FALSE

389: FND_MSG_PUB.Count_And_Get
390: (
391: p_count => x_msg_count ,
392: p_data => x_msg_data ,
393: p_encoded => FND_API.G_FALSE
394: );
395: END Apply_payment_plan_upd;
396:
397: --============================================================================

Line 452: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

448: --
449: -- Standard call to check for call compatibility.
450: --
451:
452: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
453: p_api_version ,
454: l_api_name ,
455: G_PKG_NAME )
456: THEN

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: p_api_version ,
454: l_api_name ,
455: G_PKG_NAME )
456: THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459: --
460: -- Initialize message list if p_init_msg_list is set to TRUE.
461: --

Line 462: IF FND_API.to_Boolean( p_init_msg_list ) THEN

458: END IF;
459: --
460: -- Initialize message list if p_init_msg_list is set to TRUE.
461: --
462: IF FND_API.to_Boolean( p_init_msg_list ) THEN
463: FND_MSG_PUB.initialize;
464: END IF;
465: --
466: -- Initialize API return status to success

Line 468: x_return_status := FND_API.G_RET_STS_SUCCESS;

464: END IF;
465: --
466: -- Initialize API return status to success
467: --
468: x_return_status := FND_API.G_RET_STS_SUCCESS;
469: x_loading_status := 'CN_DELETED';
470:
471: --
472: -- API body

Line 496: RAISE fnd_api.g_exc_error;

492: p_validation_only => 'N',
493: p_ovn => wksht_recs.object_version_number);
494:
495: if x_loading_status <> 'CN_DELETED' then
496: RAISE fnd_api.g_exc_error;
497: end if;
498:
499: END LOOP;
500: close get_wksht;

Line 528: RAISE fnd_api.g_exc_error;

524: p_srp_pmt_plans_rec => newrec,
525: x_loading_status => x_loading_status );
526:
527: if x_loading_status <> 'CN_DELETED' then
528: RAISE fnd_api.g_exc_error;
529: end if;
530:
531: x_loading_status := 'CN_INSERTED';
532:

Line 546: RAISE fnd_api.g_exc_error;

542: x_loading_status => x_loading_status,
543: x_status => x_status );
544:
545: if x_loading_status <> 'CN_INSERTED' then
546: RAISE fnd_api.g_exc_error;
547: end if;
548: -- End of API body.
549:
550:

Line 552: IF FND_API.To_Boolean( p_commit ) THEN

548: -- End of API body.
549:
550:
551: -- Standard check of p_commit.
552: IF FND_API.To_Boolean( p_commit ) THEN
553: COMMIT WORK;
554: END IF;
555:
556:

Line 566: p_encoded => FND_API.G_FALSE

562: FND_MSG_PUB.Count_And_Get
563: (
564: p_count => x_msg_count ,
565: p_data => x_msg_data ,
566: p_encoded => FND_API.G_FALSE
567: );
568:
569:
570: EXCEPTION

Line 571: WHEN FND_API.G_EXC_ERROR THEN

567: );
568:
569:
570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: ROLLBACK TO Apply_payment_plan_del;
573:
574: x_return_status := FND_API.G_RET_STS_ERROR ;
575: FND_MSG_PUB.Count_And_Get

Line 574: x_return_status := FND_API.G_RET_STS_ERROR ;

570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: ROLLBACK TO Apply_payment_plan_del;
573:
574: x_return_status := FND_API.G_RET_STS_ERROR ;
575: FND_MSG_PUB.Count_And_Get
576: (
577: p_count => x_msg_count ,
578: p_data => x_msg_data ,

Line 579: p_encoded => FND_API.G_FALSE

575: FND_MSG_PUB.Count_And_Get
576: (
577: p_count => x_msg_count ,
578: p_data => x_msg_data ,
579: p_encoded => FND_API.G_FALSE
580: );
581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
582: ROLLBACK TO Apply_payment_plan_del;
583:

Line 581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

577: p_count => x_msg_count ,
578: p_data => x_msg_data ,
579: p_encoded => FND_API.G_FALSE
580: );
581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
582: ROLLBACK TO Apply_payment_plan_del;
583:
584: x_loading_status := 'UNEXPECTED_ERR';
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
582: ROLLBACK TO Apply_payment_plan_del;
583:
584: x_loading_status := 'UNEXPECTED_ERR';
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
586: FND_MSG_PUB.Count_And_Get
587: (
588: p_count => x_msg_count ,
589: p_data => x_msg_data ,

Line 590: p_encoded => FND_API.G_FALSE

586: FND_MSG_PUB.Count_And_Get
587: (
588: p_count => x_msg_count ,
589: p_data => x_msg_data ,
590: p_encoded => FND_API.G_FALSE
591: );
592: WHEN OTHERS THEN
593:
594:

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

593:
594:
595: ROLLBACK TO Apply_payment_plan_del ;
596: x_loading_status := 'UNEXPECTED_ERR';
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
599: THEN
600: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
601: END IF;

Line 606: p_encoded => FND_API.G_FALSE

602: FND_MSG_PUB.Count_And_Get
603: (
604: p_count => x_msg_count ,
605: p_data => x_msg_data ,
606: p_encoded => FND_API.G_FALSE
607: );
608: END Apply_payment_plan_del;
609:
610: --============================================================================

Line 682: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

678: --
679: -- Standard call to check for call compatibility.
680: --
681:
682: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
683: p_api_version ,
684: l_api_name ,
685: G_PKG_NAME )
686: THEN

Line 687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

683: p_api_version ,
684: l_api_name ,
685: G_PKG_NAME )
686: THEN
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END IF;
689: --
690: -- Initialize message list if p_init_msg_list is set to TRUE.
691: --

Line 692: IF FND_API.to_Boolean( p_init_msg_list ) THEN

688: END IF;
689: --
690: -- Initialize message list if p_init_msg_list is set to TRUE.
691: --
692: IF FND_API.to_Boolean( p_init_msg_list ) THEN
693: FND_MSG_PUB.initialize;
694: END IF;
695: --
696: -- Initialize API return status to success

Line 698: x_return_status := FND_API.G_RET_STS_SUCCESS;

694: END IF;
695: --
696: -- Initialize API return status to success
697: --
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699: x_loading_status := 'CN_DELETED';
700:
701: --
702: -- API body

Line 726: RAISE fnd_api.g_exc_error;

722: p_validation_only => 'N',
723: p_ovn => wksht_recs.object_version_number);
724:
725: if x_loading_status <> 'CN_DELETED' then
726: RAISE fnd_api.g_exc_error;
727: end if;
728:
729: END LOOP;
730: close get_wksht;

Line 759: RAISE fnd_api.g_exc_error;

755: x_srp_pmt_plan_id => l_srp_pmt_plan_id,
756: x_loading_status => x_loading_status );
757:
758: if x_loading_status <> 'CN_INSERTED' then
759: RAISE fnd_api.g_exc_error;
760: end if;
761:
762: x_loading_status := 'CN_INSERTED';
763:

Line 777: RAISE fnd_api.g_exc_error;

773: x_loading_status => x_loading_status,
774: x_status => x_status );
775:
776: if x_loading_status <> 'CN_INSERTED' then
777: RAISE fnd_api.g_exc_error;
778: end if;
779: -- End of API body.
780:
781:

Line 783: IF FND_API.To_Boolean( p_commit ) THEN

779: -- End of API body.
780:
781:
782: -- Standard check of p_commit.
783: IF FND_API.To_Boolean( p_commit ) THEN
784: COMMIT WORK;
785: END IF;
786:
787:

Line 797: p_encoded => FND_API.G_FALSE

793: FND_MSG_PUB.Count_And_Get
794: (
795: p_count => x_msg_count ,
796: p_data => x_msg_data ,
797: p_encoded => FND_API.G_FALSE
798: );
799:
800:
801: EXCEPTION

Line 802: WHEN FND_API.G_EXC_ERROR THEN

798: );
799:
800:
801: EXCEPTION
802: WHEN FND_API.G_EXC_ERROR THEN
803: ROLLBACK TO Apply_payment_plan_cre;
804:
805: x_return_status := FND_API.G_RET_STS_ERROR ;
806: FND_MSG_PUB.Count_And_Get

Line 805: x_return_status := FND_API.G_RET_STS_ERROR ;

801: EXCEPTION
802: WHEN FND_API.G_EXC_ERROR THEN
803: ROLLBACK TO Apply_payment_plan_cre;
804:
805: x_return_status := FND_API.G_RET_STS_ERROR ;
806: FND_MSG_PUB.Count_And_Get
807: (
808: p_count => x_msg_count ,
809: p_data => x_msg_data ,

Line 810: p_encoded => FND_API.G_FALSE

806: FND_MSG_PUB.Count_And_Get
807: (
808: p_count => x_msg_count ,
809: p_data => x_msg_data ,
810: p_encoded => FND_API.G_FALSE
811: );
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: ROLLBACK TO Apply_payment_plan_cre;
814:

Line 812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

808: p_count => x_msg_count ,
809: p_data => x_msg_data ,
810: p_encoded => FND_API.G_FALSE
811: );
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: ROLLBACK TO Apply_payment_plan_cre;
814:
815: x_loading_status := 'UNEXPECTED_ERR';
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: ROLLBACK TO Apply_payment_plan_cre;
814:
815: x_loading_status := 'UNEXPECTED_ERR';
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: FND_MSG_PUB.Count_And_Get
818: (
819: p_count => x_msg_count ,
820: p_data => x_msg_data ,

Line 821: p_encoded => FND_API.G_FALSE

817: FND_MSG_PUB.Count_And_Get
818: (
819: p_count => x_msg_count ,
820: p_data => x_msg_data ,
821: p_encoded => FND_API.G_FALSE
822: );
823: WHEN OTHERS THEN
824:
825:

Line 828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

824:
825:
826: ROLLBACK TO Apply_payment_plan_cre ;
827: x_loading_status := 'UNEXPECTED_ERR';
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
829: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
830: THEN
831: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
832: END IF;

Line 837: p_encoded => FND_API.G_FALSE

833: FND_MSG_PUB.Count_And_Get
834: (
835: p_count => x_msg_count ,
836: p_data => x_msg_data ,
837: p_encoded => FND_API.G_FALSE
838: );
839: END Apply_payment_plan_cre;
840:
841: END CN_WKSHT_CT_UP_PUB;