eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PAYGROUP_PVT dependencies on FND_API

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39:
40: --
41: -- Initialize API return status to success
42: --
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44: x_loading_status := p_loading_status ;
45:
46: -- Check if already exist( duplicate assigned,unique key violation check)
47: SELECT COUNT(1) INTO l_dummy

Line 65: RAISE FND_API.G_EXC_ERROR ;

61: FND_MESSAGE.Set_Name('CN', 'CN_SRP_PAY_GRP_EXIST');
62: FND_MSG_PUB.Add;
63: END IF;
64: x_loading_status := 'CN_SRP_PAY_GRP_EXIST';
65: RAISE FND_API.G_EXC_ERROR ;
66: END IF;
67:
68:
69: -- Check if Salesrep active

Line 85: RAISE FND_API.G_EXC_ERROR ;

81: FND_MESSAGE.SET_NAME('CN','SRP_MUST_ACTIVATE_REP');
82: FND_MSG_PUB.Add;
83: END IF;
84: x_loading_status := 'SRP_MUST_ACTIVATE_REP';
85: RAISE FND_API.G_EXC_ERROR ;
86: END IF;
87:
88:
89: -- Check if date range invalid

Line 96: p_end_date_nullable => FND_API.G_TRUE,

92: -- if start_date > end_date
93: IF ( (cn_api.invalid_date_range
94: (p_start_date => p_start_date,
95: p_end_date => p_end_date,
96: p_end_date_nullable => FND_API.G_TRUE,
97: p_loading_status => x_loading_status,
98: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
99: RAISE FND_API.G_EXC_ERROR ;
100: END IF;

Line 98: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN

94: (p_start_date => p_start_date,
95: p_end_date => p_end_date,
96: p_end_date_nullable => FND_API.G_TRUE,
97: p_loading_status => x_loading_status,
98: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
99: RAISE FND_API.G_EXC_ERROR ;
100: END IF;
101:
102:

Line 99: RAISE FND_API.G_EXC_ERROR ;

95: p_end_date => p_end_date,
96: p_end_date_nullable => FND_API.G_TRUE,
97: p_loading_status => x_loading_status,
98: x_loading_status => x_loading_status)) = FND_API.G_TRUE ) THEN
99: RAISE FND_API.G_EXC_ERROR ;
100: END IF;
101:
102:
103: --

Line 135: RAISE FND_API.G_EXC_ERROR ;

131: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PG_PRDS_NI_SRP_PRDS');
132: FND_MSG_PUB.Add;
133: END IF;
134: x_loading_status := 'CN_SPP_PG_PRDS_NI_SRP_PRDS';
135: RAISE FND_API.G_EXC_ERROR ;
136: END IF;
137:
138:
139: --

Line 176: RAISE FND_API.G_EXC_ERROR ;

172: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPP_PRDS_NI_PAY_GRP_PRDS');
173: FND_MSG_PUB.Add;
174: END IF;
175: x_loading_status := 'CN_SPP_PRDS_NI_PAY_GRP_PRDS';
176: RAISE FND_API.G_EXC_ERROR ;
177: END IF;
178:
179: --
180: -- Check if the current assignment dates do not fit within the effectivity of the

Line 200: RAISE FND_API.G_EXC_ERROR;

196: fnd_msg_pub.add;
197: END IF;
198:
199: x_loading_status := 'CN_INVALID_SRP_PGRP_ASGN_DT';
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:
203: --
204: -- Check for overlapping assignments

Line 224: RAISE FND_API.G_EXC_ERROR;

220: fnd_msg_pub.add;
221: END IF;
222:
223: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227: SELECT count(1)
228: INTO l_count

Line 246: RAISE FND_API.G_EXC_ERROR;

242: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
243: fnd_msg_pub.add;
244: END IF;
245: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: SELECT count(1)
250: INTO l_count

Line 269: RAISE FND_API.G_EXC_ERROR;

265: fnd_msg_pub.add;
266: END IF;
267:
268: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: -- End of Validate Assignment
273: EXCEPTION

Line 275: WHEN FND_API.G_EXC_ERROR THEN

271:
272: -- End of Validate Assignment
273: EXCEPTION
274:
275: WHEN FND_API.G_EXC_ERROR THEN
276: x_return_status := FND_API.G_RET_STS_ERROR ;
277:
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: x_loading_status := 'UNEXPECTED_ERR';

Line 276: x_return_status := FND_API.G_RET_STS_ERROR ;

272: -- End of Validate Assignment
273: EXCEPTION
274:
275: WHEN FND_API.G_EXC_ERROR THEN
276: x_return_status := FND_API.G_RET_STS_ERROR ;
277:
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: x_loading_status := 'UNEXPECTED_ERR';
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

274:
275: WHEN FND_API.G_EXC_ERROR THEN
276: x_return_status := FND_API.G_RET_STS_ERROR ;
277:
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: x_loading_status := 'UNEXPECTED_ERR';
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281:
282: WHEN OTHERS THEN

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

276: x_return_status := FND_API.G_RET_STS_ERROR ;
277:
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: x_loading_status := 'UNEXPECTED_ERR';
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281:
282: WHEN OTHERS THEN
283: x_loading_status := 'UNEXPECTED_ERR';
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281:
282: WHEN OTHERS THEN
283: x_loading_status := 'UNEXPECTED_ERR';
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
286: THEN
287: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
288: END IF;

Line 323: x_return_status := FND_API.G_RET_STS_SUCCESS;

319:
320: --
321: -- Initialize API return status to success
322: --
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324: x_loading_status := p_loading_status ;
325:
326:
327: /* cn_posting_details is obsolete - we now validate against pmt worksheets

Line 348: RAISE FND_API.G_EXC_ERROR ;

344: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_PGRP_ASGN_END_DT');
345: FND_MSG_PUB.Add;
346: END IF;
347: x_loading_status := 'CN_INVALID_PGRP_ASGN_END_DT';
348: RAISE FND_API.G_EXC_ERROR ;
349: END;
350: */
351:
352:

Line 355: WHEN FND_API.G_EXC_ERROR THEN

351:
352:
353: EXCEPTION
354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: x_loading_status := 'UNEXPECTED_ERR';

Line 356: x_return_status := FND_API.G_RET_STS_ERROR ;

352:
353: EXCEPTION
354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: x_loading_status := 'UNEXPECTED_ERR';
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: x_loading_status := 'UNEXPECTED_ERR';
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361:
362: WHEN OTHERS THEN

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

356: x_return_status := FND_API.G_RET_STS_ERROR ;
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: x_loading_status := 'UNEXPECTED_ERR';
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361:
362: WHEN OTHERS THEN
363: x_loading_status := 'UNEXPECTED_ERR';
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
361:
362: WHEN OTHERS THEN
363: x_loading_status := 'UNEXPECTED_ERR';
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
368: END IF;

Line 405: x_return_status := FND_API.G_RET_STS_SUCCESS;

401:
402: BEGIN
403:
404: -- Initialize API return status to success
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406: x_loading_status := p_loading_status;
407:
408: FOR l_rec IN l_cur
409: LOOP

Line 421: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

417: p_srp_role_id => l_rec.srp_role_id,
418: p_role_plan_id => p_role_plan_id,
419: x_loading_status => l_loading_status);
420:
421: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
422: x_return_status := l_return_status;
423: x_loading_status := l_loading_status;
424: EXIT;
425: END IF;

Line 533: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

529: SAVEPOINT Create_Srp_Pay_Group;
530:
531: -- Standard call to check for call compatibility.
532:
533: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
534: p_api_version ,
535: l_api_name ,
536: G_PKG_NAME )
537: THEN

Line 538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

534: p_api_version ,
535: l_api_name ,
536: G_PKG_NAME )
537: THEN
538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539: END IF;
540:
541: -- Initialize message list if p_init_msg_list is set to TRUE.
542: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 542: IF FND_API.to_Boolean( p_init_msg_list ) THEN

538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539: END IF;
540:
541: -- Initialize message list if p_init_msg_list is set to TRUE.
542: IF FND_API.to_Boolean( p_init_msg_list ) THEN
543: FND_MSG_PUB.initialize;
544: END IF;
545:
546: -- Initialize API return status to success

Line 547: x_return_status := FND_API.G_RET_STS_SUCCESS;

543: FND_MSG_PUB.initialize;
544: END IF;
545:
546: -- Initialize API return status to success
547: x_return_status := FND_API.G_RET_STS_SUCCESS;
548: x_loading_status := 'CN_CREATED';
549:
550: SELECT cn_srp_pay_groups_s.NEXTVAL
551: INTO l_srp_pay_group_id

Line 574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

570: FROM cn_salesreps
571: WHERE salesrep_id = p_paygroup_assign_rec.salesrep_id
572: AND org_id = p_paygroup_assign_rec.org_id;
573:
574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
575: THEN
576: RAISE FND_API.G_EXC_ERROR ;
577: ELSIF x_loading_status = 'CN_INVALID_SRP_PGRP_ASGN_DT'
578: THEN

Line 576: RAISE FND_API.G_EXC_ERROR ;

572: AND org_id = p_paygroup_assign_rec.org_id;
573:
574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
575: THEN
576: RAISE FND_API.G_EXC_ERROR ;
577: ELSIF x_loading_status = 'CN_INVALID_SRP_PGRP_ASGN_DT'
578: THEN
579: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
580: THEN

Line 585: RAISE FND_API.G_EXC_ERROR;

581: fnd_message.set_name('CN', 'CN_INVALID_SRP_PGRP_ASGN_DT');
582: fnd_msg_pub.add;
583: END IF;
584: x_loading_status := 'CN_INVALID_SRP_PGRP_ASGN_DT';
585: RAISE FND_API.G_EXC_ERROR;
586: ELSIF x_loading_status = 'CN_OVERLAP_SRP_PGRP_ASGN'
587: THEN
588: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
589: THEN

Line 594: RAISE FND_API.G_EXC_ERROR;

590: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
591: fnd_msg_pub.add;
592: END IF;
593: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
594: RAISE FND_API.G_EXC_ERROR;
595: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
596: THEN
597:
598: Validate_end_date

Line 595: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )

591: fnd_msg_pub.add;
592: END IF;
593: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
594: RAISE FND_API.G_EXC_ERROR;
595: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
596: THEN
597:
598: Validate_end_date
599: (x_return_status => x_return_status,

Line 609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

605: p_loading_status => x_loading_status,
606: x_loading_status => x_loading_status,
607: x_status => l_status );
608:
609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
610: THEN
611: RAISE FND_API.G_EXC_ERROR ;
612: END IF;
613:

Line 611: RAISE FND_API.G_EXC_ERROR ;

607: x_status => l_status );
608:
609: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
610: THEN
611: RAISE FND_API.G_EXC_ERROR ;
612: END IF;
613:
614: -- ready to insert
615: CN_SRP_Pay_Groups_Pkg.Begin_Record(

Line 663: RAISE FND_API.G_EXC_ERROR ;

659: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PAY_GROUPS_EXIST');
660: FND_MSG_PUB.Add;
661: END IF;
662: x_loading_status := 'CN_SRP_PAY_GROUPS_EXIST';
663: RAISE FND_API.G_EXC_ERROR ;
664: END IF;
665:
666:
667: -- Call cn_srp_periods_pvt api to affect the records in cn_srp_periods

Line 691: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN

687: p_srp_role_id => roles.srp_role_id,
688: p_role_plan_id => role_plans.role_plan_id,
689: x_loading_status => x_loading_status );
690:
691: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
692: RAISE FND_API.G_EXC_ERROR;
693: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;

Line 692: RAISE FND_API.G_EXC_ERROR;

688: p_role_plan_id => role_plans.role_plan_id,
689: x_loading_status => x_loading_status );
690:
691: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
692: RAISE FND_API.G_EXC_ERROR;
693: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696:

Line 693: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

689: x_loading_status => x_loading_status );
690:
691: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
692: RAISE FND_API.G_EXC_ERROR;
693: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696:
697: -- clku bug 2758073

Line 694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

690:
691: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
692: RAISE FND_API.G_EXC_ERROR;
693: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696:
697: -- clku bug 2758073
698: -- mark event for intel calc, when new plan assignement is populated

Line 745: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

741: p_comp_plan_id => plans.comp_plan_id,
742: p_start_date => plans.start_date,
743: p_end_date => plans.end_date,
744: x_loading_status => x_loading_status);
745: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
746: THEN
747: RAISE FND_API.G_EXC_ERROR;
748: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
749: THEN

Line 747: RAISE FND_API.G_EXC_ERROR;

743: p_end_date => plans.end_date,
744: x_loading_status => x_loading_status);
745: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
746: THEN
747: RAISE FND_API.G_EXC_ERROR;
748: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
749: THEN
750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END IF;

Line 748: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

744: x_loading_status => x_loading_status);
745: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
746: THEN
747: RAISE FND_API.G_EXC_ERROR;
748: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
749: THEN
750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END IF;
752:

Line 750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

746: THEN
747: RAISE FND_API.G_EXC_ERROR;
748: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
749: THEN
750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END IF;
752:
753: END IF;
754: END LOOP;

Line 761: IF FND_API.To_Boolean( p_commit ) THEN

757: -- End of API body
758:
759: -- Standard check of p_commit.
760:
761: IF FND_API.To_Boolean( p_commit ) THEN
762: COMMIT WORK;
763: END IF;
764:
765: -- Standard call to get message count and if count is 1, get message info

Line 770: p_encoded => FND_API.G_FALSE

766: FND_MSG_PUB.Count_And_Get
767: (
768: p_count => x_msg_count ,
769: p_data => x_msg_data ,
770: p_encoded => FND_API.G_FALSE
771: );
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN

Line 774: WHEN FND_API.G_EXC_ERROR THEN

770: p_encoded => FND_API.G_FALSE
771: );
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: ROLLBACK TO Create_Srp_Pay_Group;
776: x_return_status := FND_API.G_RET_STS_ERROR ;
777: FND_MSG_PUB.Count_And_Get
778: (

Line 776: x_return_status := FND_API.G_RET_STS_ERROR ;

772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_ERROR THEN
775: ROLLBACK TO Create_Srp_Pay_Group;
776: x_return_status := FND_API.G_RET_STS_ERROR ;
777: FND_MSG_PUB.Count_And_Get
778: (
779: p_count => x_msg_count ,
780: p_data => x_msg_data ,

Line 781: p_encoded => FND_API.G_FALSE

777: FND_MSG_PUB.Count_And_Get
778: (
779: p_count => x_msg_count ,
780: p_data => x_msg_data ,
781: p_encoded => FND_API.G_FALSE
782: );
783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: ROLLBACK TO Create_Srp_Pay_Group;
785: x_loading_status := 'UNEXPECTED_ERR';

Line 783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

779: p_count => x_msg_count ,
780: p_data => x_msg_data ,
781: p_encoded => FND_API.G_FALSE
782: );
783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: ROLLBACK TO Create_Srp_Pay_Group;
785: x_loading_status := 'UNEXPECTED_ERR';
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: FND_MSG_PUB.Count_And_Get

Line 786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

782: );
783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: ROLLBACK TO Create_Srp_Pay_Group;
785: x_loading_status := 'UNEXPECTED_ERR';
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
787: FND_MSG_PUB.Count_And_Get
788: (
789: p_count => x_msg_count ,
790: p_data => x_msg_data ,

Line 791: p_encoded => FND_API.G_FALSE

787: FND_MSG_PUB.Count_And_Get
788: (
789: p_count => x_msg_count ,
790: p_data => x_msg_data ,
791: p_encoded => FND_API.G_FALSE
792: );
793: WHEN OTHERS THEN
794: ROLLBACK TO Create_Srp_Pay_Group;
795: x_loading_status := 'UNEXPECTED_ERR';

Line 796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

792: );
793: WHEN OTHERS THEN
794: ROLLBACK TO Create_Srp_Pay_Group;
795: x_loading_status := 'UNEXPECTED_ERR';
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
797: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
798: THEN
799: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
800: END IF;

Line 805: p_encoded => FND_API.G_FALSE

801: FND_MSG_PUB.Count_And_Get
802: (
803: p_count => x_msg_count ,
804: p_data => x_msg_data ,
805: p_encoded => FND_API.G_FALSE
806: );
807: END create_srp_pay_group;
808:
809:

Line 890: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

886: SAVEPOINT Update_Srp_Pay_Group;
887:
888: -- Standard call to check for call compatibility.
889:
890: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
891: p_api_version ,
892: l_api_name ,
893: G_PKG_NAME )
894: THEN

Line 895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

891: p_api_version ,
892: l_api_name ,
893: G_PKG_NAME )
894: THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897:
898: -- Initialize message list if p_init_msg_list is set to TRUE.
899: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 899: IF FND_API.to_Boolean( p_init_msg_list ) THEN

895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897:
898: -- Initialize message list if p_init_msg_list is set to TRUE.
899: IF FND_API.to_Boolean( p_init_msg_list ) THEN
900: FND_MSG_PUB.initialize;
901: END IF;
902:
903: -- Initialize API return status to success

Line 904: x_return_status := FND_API.G_RET_STS_SUCCESS;

900: FND_MSG_PUB.initialize;
901: END IF;
902:
903: -- Initialize API return status to success
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905: x_loading_status := 'CN_UPDATED';
906:
907:
908: -- get the current object version number

Line 925: RAISE FND_API.G_EXC_ERROR;

921: fnd_message.set_name('CN', 'CL_INVALID_OVN');
922: fnd_msg_pub.add;
923: END IF;
924: x_loading_status := 'CL_INVALID_OVN';
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927:
928: IF p_paygroup_assign_rec.salesrep_id <> l_old_salesrep_id
929: THEN

Line 940: RAISE FND_API.G_EXC_ERROR;

936: fnd_message.set_name('CN', 'CN_INVALID_UPD_SRP_PGRP');
937: fnd_msg_pub.add;
938: END IF;
939: x_loading_status := 'CN_INVALID_UPD_SRP_PGRP';
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: -- can't change lock flag from Y to N
944: IF l_old_lock_flag = 'Y' AND p_paygroup_assign_rec.lock_flag = 'N' THEN

Line 951: RAISE FND_API.G_EXC_ERROR;

947: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');
948: fnd_msg_pub.add;
949: END IF;
950: x_loading_status := 'CN_CANNOT_UPDATE_LOCK';
951: RAISE FND_API.G_EXC_ERROR;
952: END IF;
953:
954: -- can't change lock from N to Y if it is manual assignment
955: IF l_old_lock_flag = 'N' AND p_paygroup_assign_rec.lock_flag = 'Y' AND

Line 963: RAISE FND_API.G_EXC_ERROR;

959: fnd_message.set_name('CN', 'CN_CANNOT_UPDATE_LOCK');
960: fnd_msg_pub.add;
961: END IF;
962: x_loading_status := 'CN_CANNOT_UPDATE_LOCK';
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965:
966: Validate_assignment
967: (x_return_status => x_return_status,

Line 986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

982: FROM cn_salesreps
983: WHERE salesrep_id = p_paygroup_assign_rec.salesrep_id
984: AND org_id = p_paygroup_assign_rec.org_id;
985:
986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
987: THEN
988: RAISE FND_API.G_EXC_ERROR ;
989: ELSIF x_loading_status = 'CN_INVALID_SRP_PGRP_ASGN_DT'
990: THEN

Line 988: RAISE FND_API.G_EXC_ERROR ;

984: AND org_id = p_paygroup_assign_rec.org_id;
985:
986: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
987: THEN
988: RAISE FND_API.G_EXC_ERROR ;
989: ELSIF x_loading_status = 'CN_INVALID_SRP_PGRP_ASGN_DT'
990: THEN
991: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
992: THEN

Line 997: RAISE FND_API.G_EXC_ERROR;

993: fnd_message.set_name('CN', 'CN_INVALID_SRP_PGRP_ASGN_DT');
994: fnd_msg_pub.add;
995: END IF;
996: x_loading_status := 'CN_INVALID_SRP_PGRP_ASGN_DT';
997: RAISE FND_API.G_EXC_ERROR;
998: ELSIF x_loading_status = 'CN_OVERLAP_SRP_PGRP_ASGN'
999: THEN
1000: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1001: THEN

Line 1006: RAISE FND_API.G_EXC_ERROR;

1002: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
1003: fnd_msg_pub.add;
1004: END IF;
1005: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
1006: RAISE FND_API.G_EXC_ERROR;
1007: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
1008: THEN
1009:
1010: Validate_end_date

Line 1007: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )

1003: fnd_msg_pub.add;
1004: END IF;
1005: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
1006: RAISE FND_API.G_EXC_ERROR;
1007: ELSIF ( x_return_status = FND_API.G_RET_STS_SUCCESS )
1008: THEN
1009:
1010: Validate_end_date
1011: (x_return_status => x_return_status,

Line 1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1018: x_loading_status => x_loading_status,
1019: x_status => l_status );
1020:
1021:
1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1023: THEN
1024: RAISE FND_API.G_EXC_ERROR ;
1025: END IF;
1026:

Line 1024: RAISE FND_API.G_EXC_ERROR ;

1020:
1021:
1022: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1023: THEN
1024: RAISE FND_API.G_EXC_ERROR ;
1025: END IF;
1026:
1027: --clku, payee check enhancement
1028: OPEN payee_check_curs(p_paygroup_assign_rec.salesrep_id);

Line 1061: RAISE FND_API.G_EXC_ERROR;

1057: fnd_msg_pub.add;
1058: END IF;
1059:
1060: x_loading_status := 'CN_PA_ASGN_DATE';
1061: RAISE FND_API.G_EXC_ERROR;
1062:
1063:
1064: END IF;
1065: END LOOP;

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: fnd_msg_pub.add;
1093: END IF;
1094:
1095: x_loading_status := 'CN_SRP_PG_WS';
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098:
1099: END IF; --if l_date_range_action_tbl(i).action_flag = 'D'
1100: END LOOP; -- FOR i IN 1..l_date_range_action_tbl.COUNT LOOP

Line 1137: RAISE FND_API.G_EXC_ERROR ;

1133: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPG_CANNOT_SHORTEN_ED');
1134: FND_MSG_PUB.Add;
1135: END IF;
1136: x_loading_status := 'CN_SPG_CANNOT_SHORTEN_ED';
1137: RAISE FND_API.G_EXC_ERROR ;
1138: end if;
1139:
1140: END IF ; -- end IF end date change
1141:

Line 1164: RAISE FND_API.G_EXC_ERROR ;

1160: FND_MESSAGE.SET_NAME ('CN' , 'CN_SPG_UPDATE_NOT_ALLOWED');
1161: FND_MSG_PUB.Add;
1162: END IF;
1163: x_loading_status := 'CN_SPG_UPDATE_NOT_ALLOWED';
1164: RAISE FND_API.G_EXC_ERROR ;
1165: END if;
1166:
1167: END IF ; -- end IF start date change
1168:

Line 1248: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN

1244: p_srp_role_id => roles.srp_role_id,
1245: p_role_plan_id => role_plans.role_plan_id,
1246: x_loading_status => x_loading_status );
1247:
1248: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;

Line 1249: RAISE FND_API.G_EXC_ERROR;

1245: p_role_plan_id => role_plans.role_plan_id,
1246: x_loading_status => x_loading_status );
1247:
1248: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:

Line 1250: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

1246: x_loading_status => x_loading_status );
1247:
1248: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1254: -- clku bug 2758073

Line 1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1247:
1248: IF ( x_return_status = FND_API.G_RET_STS_ERROR) THEN
1249: RAISE FND_API.G_EXC_ERROR;
1250: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1254: -- clku bug 2758073
1255: -- mark event for intel calc, when plan assignement's date

Line 1301: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1297: p_comp_plan_id => plans.comp_plan_id,
1298: p_start_date => plans.start_date,
1299: p_end_date => plans.end_date,
1300: x_loading_status => x_loading_status);
1301: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1302: THEN
1303: RAISE FND_API.G_EXC_ERROR;
1304: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1305: THEN

Line 1303: RAISE FND_API.G_EXC_ERROR;

1299: p_end_date => plans.end_date,
1300: x_loading_status => x_loading_status);
1301: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1302: THEN
1303: RAISE FND_API.G_EXC_ERROR;
1304: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1305: THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: END IF;

Line 1304: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1300: x_loading_status => x_loading_status);
1301: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1302: THEN
1303: RAISE FND_API.G_EXC_ERROR;
1304: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1305: THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: END IF;
1308: END IF;

Line 1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1302: THEN
1303: RAISE FND_API.G_EXC_ERROR;
1304: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1305: THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: END IF;
1308: END IF;
1309: END LOOP;
1310: END LOOP;

Line 1316: IF FND_API.To_Boolean( p_commit ) THEN

1312: -- End of API body
1313:
1314: -- Standard check of p_commit.
1315:
1316: IF FND_API.To_Boolean( p_commit ) THEN
1317: COMMIT WORK;
1318: END IF;
1319:
1320: -- Standard call to get message count and if count is 1, get message info

Line 1325: p_encoded => FND_API.G_FALSE

1321: FND_MSG_PUB.Count_And_Get
1322: (
1323: p_count => x_msg_count ,
1324: p_data => x_msg_data ,
1325: p_encoded => FND_API.G_FALSE
1326: );
1327:
1328: EXCEPTION
1329: WHEN FND_API.G_EXC_ERROR THEN

Line 1329: WHEN FND_API.G_EXC_ERROR THEN

1325: p_encoded => FND_API.G_FALSE
1326: );
1327:
1328: EXCEPTION
1329: WHEN FND_API.G_EXC_ERROR THEN
1330: ROLLBACK TO Update_Srp_Pay_Group;
1331: x_return_status := FND_API.G_RET_STS_ERROR ;
1332: FND_MSG_PUB.Count_And_Get
1333: (

Line 1331: x_return_status := FND_API.G_RET_STS_ERROR ;

1327:
1328: EXCEPTION
1329: WHEN FND_API.G_EXC_ERROR THEN
1330: ROLLBACK TO Update_Srp_Pay_Group;
1331: x_return_status := FND_API.G_RET_STS_ERROR ;
1332: FND_MSG_PUB.Count_And_Get
1333: (
1334: p_count => x_msg_count ,
1335: p_data => x_msg_data ,

Line 1336: p_encoded => FND_API.G_FALSE

1332: FND_MSG_PUB.Count_And_Get
1333: (
1334: p_count => x_msg_count ,
1335: p_data => x_msg_data ,
1336: p_encoded => FND_API.G_FALSE
1337: );
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: ROLLBACK TO Update_Srp_Pay_Group;
1340: x_loading_status := 'UNEXPECTED_ERR';

Line 1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1334: p_count => x_msg_count ,
1335: p_data => x_msg_data ,
1336: p_encoded => FND_API.G_FALSE
1337: );
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: ROLLBACK TO Update_Srp_Pay_Group;
1340: x_loading_status := 'UNEXPECTED_ERR';
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1342: FND_MSG_PUB.Count_And_Get

Line 1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1337: );
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: ROLLBACK TO Update_Srp_Pay_Group;
1340: x_loading_status := 'UNEXPECTED_ERR';
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1342: FND_MSG_PUB.Count_And_Get
1343: (
1344: p_count => x_msg_count ,
1345: p_data => x_msg_data ,

Line 1346: p_encoded => FND_API.G_FALSE

1342: FND_MSG_PUB.Count_And_Get
1343: (
1344: p_count => x_msg_count ,
1345: p_data => x_msg_data ,
1346: p_encoded => FND_API.G_FALSE
1347: );
1348: WHEN OTHERS THEN
1349: ROLLBACK TO Update_Srp_Pay_Group;
1350: x_loading_status := 'UNEXPECTED_ERR';

Line 1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1347: );
1348: WHEN OTHERS THEN
1349: ROLLBACK TO Update_Srp_Pay_Group;
1350: x_loading_status := 'UNEXPECTED_ERR';
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1353: THEN
1354: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1355: END IF;

Line 1360: p_encoded => FND_API.G_FALSE

1356: FND_MSG_PUB.Count_And_Get
1357: (
1358: p_count => x_msg_count ,
1359: p_data => x_msg_data ,
1360: p_encoded => FND_API.G_FALSE
1361: );
1362:
1363: END update_srp_pay_group;
1364:

Line 1404: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1400:
1401:
1402: BEGIN
1403: -- Initialize message list if p_init_msg_list is set to TRUE.
1404: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1405: FND_MSG_PUB.initialize;
1406: END IF;
1407:
1408: -- Initialize API return status to success

Line 1409: x_return_status := FND_API.G_RET_STS_SUCCESS;

1405: FND_MSG_PUB.initialize;
1406: END IF;
1407:
1408: -- Initialize API return status to success
1409: x_return_status := FND_API.G_RET_STS_SUCCESS;
1410: x_loading_status := 'CN_DELETED';
1411:
1412: --clku, payee check enhancement
1413: OPEN payee_check_curs(p_paygroup_assign_rec.salesrep_id);

Line 1436: RAISE FND_API.G_EXC_ERROR;

1432: fnd_msg_pub.add;
1433: END IF;
1434:
1435: x_loading_status := 'CN_PA_ASGN_DATE';
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438: END LOOP;
1439:
1440: -- check if the payee has any worksheet

Line 1469: RAISE FND_API.G_EXC_ERROR;

1465: fnd_msg_pub.add;
1466: END IF;
1467:
1468: x_loading_status := 'CN_SRP_PG_WS';
1469: RAISE FND_API.G_EXC_ERROR;
1470: END IF;
1471:
1472: END IF;
1473:

Line 1521: RAISE FND_API.G_EXC_ERROR;

1517: fnd_msg_pub.add;
1518: END IF;
1519:
1520: x_loading_status := 'CN_SRP_PG_WS';
1521: RAISE FND_API.G_EXC_ERROR;
1522:
1523: END IF;
1524: EXCEPTION
1525: WHEN FND_API.G_EXC_ERROR THEN

Line 1525: WHEN FND_API.G_EXC_ERROR THEN

1521: RAISE FND_API.G_EXC_ERROR;
1522:
1523: END IF;
1524: EXCEPTION
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: x_return_status := FND_API.G_RET_STS_ERROR ;
1527: FND_MSG_PUB.Count_And_Get
1528:
1529:

Line 1526: x_return_status := FND_API.G_RET_STS_ERROR ;

1522:
1523: END IF;
1524: EXCEPTION
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: x_return_status := FND_API.G_RET_STS_ERROR ;
1527: FND_MSG_PUB.Count_And_Get
1528:
1529:
1530: (

Line 1533: p_encoded => FND_API.G_FALSE

1529:
1530: (
1531: p_count => x_msg_count ,
1532: p_data => x_msg_data ,
1533: p_encoded => FND_API.G_FALSE
1534: );
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: x_loading_status := 'UNEXPECTED_ERR';
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1531: p_count => x_msg_count ,
1532: p_data => x_msg_data ,
1533: p_encoded => FND_API.G_FALSE
1534: );
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: x_loading_status := 'UNEXPECTED_ERR';
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1538: FND_MSG_PUB.Count_And_Get
1539: (

Line 1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1533: p_encoded => FND_API.G_FALSE
1534: );
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: x_loading_status := 'UNEXPECTED_ERR';
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1538: FND_MSG_PUB.Count_And_Get
1539: (
1540: p_count => x_msg_count ,
1541: p_data => x_msg_data ,

Line 1542: p_encoded => FND_API.G_FALSE

1538: FND_MSG_PUB.Count_And_Get
1539: (
1540: p_count => x_msg_count ,
1541: p_data => x_msg_data ,
1542: p_encoded => FND_API.G_FALSE
1543: );
1544: WHEN OTHERS THEN
1545: x_loading_status := 'UNEXPECTED_ERR';
1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1542: p_encoded => FND_API.G_FALSE
1543: );
1544: WHEN OTHERS THEN
1545: x_loading_status := 'UNEXPECTED_ERR';
1546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1547: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1548: THEN
1549: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1550: END IF;

Line 1555: p_encoded => FND_API.G_FALSE

1551: FND_MSG_PUB.Count_And_Get
1552: (
1553: p_count => x_msg_count ,
1554: p_data => x_msg_data ,
1555: p_encoded => FND_API.G_FALSE
1556: );
1557:
1558:
1559: END valid_delete_srp_pay_group;

Line 1633: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1629: SAVEPOINT Delete_Srp_Pay_Group;
1630:
1631: -- Standard call to check for call compatibility.
1632:
1633: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1634: p_api_version ,
1635: l_api_name ,
1636: G_PKG_NAME )
1637: THEN

Line 1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1634: p_api_version ,
1635: l_api_name ,
1636: G_PKG_NAME )
1637: THEN
1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:
1641: -- Initialize message list if p_init_msg_list is set to TRUE.
1642: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1642: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1639: END IF;
1640:
1641: -- Initialize message list if p_init_msg_list is set to TRUE.
1642: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1643: FND_MSG_PUB.initialize;
1644: END IF;
1645:
1646: -- Initialize API return status to success

Line 1647: x_return_status := FND_API.G_RET_STS_SUCCESS;

1643: FND_MSG_PUB.initialize;
1644: END IF;
1645:
1646: -- Initialize API return status to success
1647: x_return_status := FND_API.G_RET_STS_SUCCESS;
1648: x_loading_status := 'CN_DELETED';
1649:
1650: -- validate delete
1651: valid_delete_srp_pay_group

Line 1659: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1655: x_return_status => x_return_status,
1656: x_msg_count => x_msg_count,
1657: x_msg_data => x_msg_data);
1658:
1659: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1660: RAISE fnd_api.g_exc_error;
1661: END IF;
1662:
1663: -- if made it here, then OK to delete

Line 1660: RAISE fnd_api.g_exc_error;

1656: x_msg_count => x_msg_count,
1657: x_msg_data => x_msg_data);
1658:
1659: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1660: RAISE fnd_api.g_exc_error;
1661: END IF;
1662:
1663: -- if made it here, then OK to delete
1664: SELECT SRP_PAY_GROUP_ID

Line 1704: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1700: x_return_status => x_return_status,
1701: p_loading_status => l_loading_status,
1702: x_loading_status => x_loading_status);
1703:
1704: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1705: RAISE FND_API.G_EXC_ERROR;
1706: END IF;
1707: END LOOP ;
1708: END LOOP;

Line 1705: RAISE FND_API.G_EXC_ERROR;

1701: p_loading_status => l_loading_status,
1702: x_loading_status => x_loading_status);
1703:
1704: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1705: RAISE FND_API.G_EXC_ERROR;
1706: END IF;
1707: END LOOP ;
1708: END LOOP;
1709: END IF;

Line 1731: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1727: x_msg_data => x_msg_data,
1728: p_srp_role_id => roles.srp_role_id,
1729: p_role_plan_id => role_plans.role_plan_id,
1730: x_loading_status => x_loading_status );
1731: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1732: RAISE FND_API.G_EXC_ERROR;
1733: END IF;
1734: END LOOP;
1735: END if;

Line 1732: RAISE FND_API.G_EXC_ERROR;

1728: p_srp_role_id => roles.srp_role_id,
1729: p_role_plan_id => role_plans.role_plan_id,
1730: x_loading_status => x_loading_status );
1731: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1732: RAISE FND_API.G_EXC_ERROR;
1733: END IF;
1734: END LOOP;
1735: END if;
1736: FOR plans IN get_plan_assigns

Line 1761: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1757: p_comp_plan_id => plans.comp_plan_id,
1758: p_start_date => plans.start_date,
1759: p_end_date => plans.end_date,
1760: x_loading_status => x_loading_status);
1761: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1762: RAISE FND_API.G_EXC_ERROR;
1763: END IF;
1764: END IF;
1765: END LOOP;

Line 1762: RAISE FND_API.G_EXC_ERROR;

1758: p_start_date => plans.start_date,
1759: p_end_date => plans.end_date,
1760: x_loading_status => x_loading_status);
1761: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1762: RAISE FND_API.G_EXC_ERROR;
1763: END IF;
1764: END IF;
1765: END LOOP;
1766: END LOOP;

Line 1776: IF FND_API.To_Boolean( p_commit ) THEN

1772:
1773: -- Standard check of p_commit.
1774:
1775:
1776: IF FND_API.To_Boolean( p_commit ) THEN
1777: COMMIT WORK;
1778: END IF;
1779:
1780:

Line 1787: p_encoded => FND_API.G_FALSE

1783: FND_MSG_PUB.Count_And_Get
1784: (
1785: p_count => x_msg_count ,
1786: p_data => x_msg_data ,
1787: p_encoded => FND_API.G_FALSE
1788: );
1789:
1790: EXCEPTION
1791: WHEN FND_API.G_EXC_ERROR THEN

Line 1791: WHEN FND_API.G_EXC_ERROR THEN

1787: p_encoded => FND_API.G_FALSE
1788: );
1789:
1790: EXCEPTION
1791: WHEN FND_API.G_EXC_ERROR THEN
1792: ROLLBACK TO Delete_Srp_Pay_Group;
1793: x_return_status := FND_API.G_RET_STS_ERROR ;
1794: FND_MSG_PUB.Count_And_Get
1795:

Line 1793: x_return_status := FND_API.G_RET_STS_ERROR ;

1789:
1790: EXCEPTION
1791: WHEN FND_API.G_EXC_ERROR THEN
1792: ROLLBACK TO Delete_Srp_Pay_Group;
1793: x_return_status := FND_API.G_RET_STS_ERROR ;
1794: FND_MSG_PUB.Count_And_Get
1795:
1796:
1797: (

Line 1800: p_encoded => FND_API.G_FALSE

1796:
1797: (
1798: p_count => x_msg_count ,
1799: p_data => x_msg_data ,
1800: p_encoded => FND_API.G_FALSE
1801: );
1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1803: ROLLBACK TO Delete_Srp_Pay_Group;
1804: x_loading_status := 'UNEXPECTED_ERR';

Line 1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1798: p_count => x_msg_count ,
1799: p_data => x_msg_data ,
1800: p_encoded => FND_API.G_FALSE
1801: );
1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1803: ROLLBACK TO Delete_Srp_Pay_Group;
1804: x_loading_status := 'UNEXPECTED_ERR';
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1806: FND_MSG_PUB.Count_And_Get

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1801: );
1802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1803: ROLLBACK TO Delete_Srp_Pay_Group;
1804: x_loading_status := 'UNEXPECTED_ERR';
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1806: FND_MSG_PUB.Count_And_Get
1807: (
1808: p_count => x_msg_count ,
1809: p_data => x_msg_data ,

Line 1810: p_encoded => FND_API.G_FALSE

1806: FND_MSG_PUB.Count_And_Get
1807: (
1808: p_count => x_msg_count ,
1809: p_data => x_msg_data ,
1810: p_encoded => FND_API.G_FALSE
1811: );
1812: WHEN OTHERS THEN
1813: ROLLBACK TO Delete_Srp_Pay_Group;
1814: x_loading_status := 'UNEXPECTED_ERR';

Line 1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1811: );
1812: WHEN OTHERS THEN
1813: ROLLBACK TO Delete_Srp_Pay_Group;
1814: x_loading_status := 'UNEXPECTED_ERR';
1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1817: THEN
1818: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1819: END IF;

Line 1824: p_encoded => FND_API.G_FALSE

1820: FND_MSG_PUB.Count_And_Get
1821: (
1822: p_count => x_msg_count ,
1823: p_data => x_msg_data ,
1824: p_encoded => FND_API.G_FALSE
1825: );
1826: END Delete_Srp_Pay_Group;
1827:
1828: -- --------------------------------------------------------------------------*

Line 1906: RAISE FND_API.G_EXC_ERROR;

1902: Least(Nvl(spp.end_date,l_null_date),
1903: Nvl(l_srp_end_date,l_null_date));
1904: EXCEPTION
1905: WHEN no_data_found THEN
1906: RAISE FND_API.G_EXC_ERROR;
1907:
1908: END;
1909:
1910: IF l_lock_flag = 'Y'

Line 1912: RAISE FND_API.G_EXC_ERROR;

1908: END;
1909:
1910: IF l_lock_flag = 'Y'
1911: THEN
1912: RAISE FND_API.G_EXC_ERROR;
1913: END IF;
1914: SELECT count(*)
1915: into l_count
1916: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,

Line 1935: RAISE FND_API.G_EXC_ERROR;

1931: set role_pay_group_id = null
1932: where role_pay_group_id = p_role_pay_group_id
1933: and salesrep_id = l_salesrep_id
1934: and org_id = l_org_id;
1935: RAISE FND_API.G_EXC_ERROR;
1936: END IF;
1937:
1938: newrec.assignment_start_date := l_start_date;
1939: newrec.assignment_end_date := l_end_date;

Line 1953: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1949: x_msg_count => l_msg_count,
1950: x_msg_data => l_msg_data,
1951: p_paygroup_assign_rec=> newrec);
1952:
1953: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1954: RAISE fnd_api.g_exc_error;
1955: END IF;
1956:
1957: x_return_status := l_return_status;

Line 1954: RAISE fnd_api.g_exc_error;

1950: x_msg_data => l_msg_data,
1951: p_paygroup_assign_rec=> newrec);
1952:
1953: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1954: RAISE fnd_api.g_exc_error;
1955: END IF;
1956:
1957: x_return_status := l_return_status;
1958: x_loading_status := l_loading_status;

Line 1960: WHEN FND_API.G_EXC_ERROR THEN

1956:
1957: x_return_status := l_return_status;
1958: x_loading_status := l_loading_status;
1959: EXCEPTION
1960: WHEN FND_API.G_EXC_ERROR THEN
1961: NULL;
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: NULL;

Line 1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1959: EXCEPTION
1960: WHEN FND_API.G_EXC_ERROR THEN
1961: NULL;
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: NULL;
1965: WHEN OTHERS THEN
1966: NULL;
1967: