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_PUB dependencies on FND_API

Line 142: p_show_message := fnd_api.g_true;

138: BEGIN
139: -- change for performance. Force to hit index on employee_number
140: -- Bug 1508614
141: -- Fixed on 25/0ct/2001
142: p_show_message := fnd_api.g_true;
143: l_emp_num := upper(p_emp_num);
144:
145: IF p_emp_num IS NULL THEN
146: SELECT salesrep_id

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

160: AND ((type = p_type) OR (type IS NULL AND p_type IS NULL));
161: END IF;
162:
163: x_salesrep_id := l_salesrep_id;
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165: x_loading_status := 'CN_SALESREP_FOUND';
166:
167: EXCEPTION
168: WHEN no_data_found THEN

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

166:
167: EXCEPTION
168: WHEN no_data_found THEN
169: x_salesrep_id := NULL;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: x_loading_status := 'CN_SALESREP_NOT_FOUND';
172: IF (p_show_message = FND_API.G_TRUE) THEN
173: -- Error, check the msg level and add an error message to the
174: -- API message list

Line 172: IF (p_show_message = FND_API.G_TRUE) THEN

168: WHEN no_data_found THEN
169: x_salesrep_id := NULL;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: x_loading_status := 'CN_SALESREP_NOT_FOUND';
172: IF (p_show_message = FND_API.G_TRUE) THEN
173: -- Error, check the msg level and add an error message to the
174: -- API message list
175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
176: THEN

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: END IF;
180: END IF;
181: WHEN too_many_rows THEN
182: x_salesrep_id := NULL;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: x_loading_status := 'CN_SALESREP_TOO_MANY_ROWS';
185: IF (p_show_message = FND_API.G_TRUE) THEN
186: -- Error, check the msg level and add an error message to the
187: -- API message list

Line 185: IF (p_show_message = FND_API.G_TRUE) THEN

181: WHEN too_many_rows THEN
182: x_salesrep_id := NULL;
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: x_loading_status := 'CN_SALESREP_TOO_MANY_ROWS';
185: IF (p_show_message = FND_API.G_TRUE) THEN
186: -- Error, check the msg level and add an error message to the
187: -- API message list
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
189: THEN

Line 251: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: p_api_version ,
253: l_api_name ,
254: G_PKG_NAME )
255: THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258:
259:
260: --

Line 263: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 271: x_return_status := FND_API.G_RET_STS_SUCCESS;

267:
268: --
269: -- Initialize API return status to success
270: --
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272: x_loading_status := 'CN_INSERTED';
273:
274: --
275: -- Assign the parameter to a local variable

Line 308: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

304: IF ( (cn_api.chk_miss_null_char_para
305: (p_char_para => l_paygroup_assign_rec.pay_group_name,
306: p_obj_name => 'Pay Group Name',
307: p_loading_status => x_loading_status,
308: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
309: THEN
310: RAISE FND_API.G_EXC_ERROR ;
311: END IF;
312:

Line 310: RAISE FND_API.G_EXC_ERROR ;

306: p_obj_name => 'Pay Group Name',
307: p_loading_status => x_loading_status,
308: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
309: THEN
310: RAISE FND_API.G_EXC_ERROR ;
311: END IF;
312:
313: -- Fetch pay_group_id
314: OPEN get_pay_group_id_cur;

Line 334: RAISE FND_API.G_EXC_ERROR;

330: END IF;
331:
332: x_loading_status := 'CN_INVALID_PAY_GROUP';
333: CLOSE get_pay_group_id_cur;
334: RAISE FND_API.G_EXC_ERROR;
335:
336: END IF;
337:
338: --

Line 391: RAISE fnd_api.g_exc_error;

387: --Reset the loading status
388: --
389: x_loading_status := 'CN_INSERTED';
390: ELSE
391: RAISE fnd_api.g_exc_error;
392: END IF;
393:
394: --
395: -- User hooks

Line 405: p_init_msg_list => fnd_api.g_false,

401: 'C')
402: THEN
403: cn_srp_paygroup_pub_cuhk.assign_salesreps_pre
404: (p_api_version => p_api_version,
405: p_init_msg_list => fnd_api.g_false,
406: p_commit => fnd_api.g_false,
407: p_validation_level => p_validation_level,
408: x_return_status => x_return_status,
409: x_msg_count => x_msg_count,

Line 406: p_commit => fnd_api.g_false,

402: THEN
403: cn_srp_paygroup_pub_cuhk.assign_salesreps_pre
404: (p_api_version => p_api_version,
405: p_init_msg_list => fnd_api.g_false,
406: p_commit => fnd_api.g_false,
407: p_validation_level => p_validation_level,
408: x_return_status => x_return_status,
409: x_msg_count => x_msg_count,
410: x_msg_data => x_msg_data,

Line 416: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

412: x_loading_status => x_loading_status,
413: x_status => x_status
414: );
415:
416: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
420: THEN

Line 418: RAISE FND_API.G_EXC_ERROR;

414: );
415:
416: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;

Line 419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

415:
416: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423: END IF;

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: THEN
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423: END IF;
424:
425: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

Line 432: p_init_msg_list => fnd_api.g_false,

428: 'V')
429: THEN
430: cn_srp_paygroup_pub_vuhk.assign_salesreps_pre
431: (p_api_version => p_api_version,
432: p_init_msg_list => fnd_api.g_false,
433: p_commit => fnd_api.g_false,
434: p_validation_level => p_validation_level,
435: x_return_status => x_return_status,
436: x_msg_count => x_msg_count,

Line 433: p_commit => fnd_api.g_false,

429: THEN
430: cn_srp_paygroup_pub_vuhk.assign_salesreps_pre
431: (p_api_version => p_api_version,
432: p_init_msg_list => fnd_api.g_false,
433: p_commit => fnd_api.g_false,
434: p_validation_level => p_validation_level,
435: x_return_status => x_return_status,
436: x_msg_count => x_msg_count,
437: x_msg_data => x_msg_data,

Line 443: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

439: x_loading_status => x_loading_status,
440: x_status => x_status
441: );
442:
443: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
444: THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
447: THEN

Line 445: RAISE FND_API.G_EXC_ERROR;

441: );
442:
443: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
444: THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;

Line 446: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

442:
443: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
444: THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450: END IF;

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444: THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
447: THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450: END IF;
451:
452: -- call main API

Line 487: IF x_return_status <> fnd_api.g_ret_sts_success THEN

483: x_msg_count => x_msg_count,
484: x_msg_data => x_msg_data,
485: p_paygroup_assign_rec => l_create_rec);
486:
487: IF x_return_status <> fnd_api.g_ret_sts_success THEN
488: RAISE fnd_api.g_exc_error;
489: END IF;
490:
491: --

Line 488: RAISE fnd_api.g_exc_error;

484: x_msg_data => x_msg_data,
485: p_paygroup_assign_rec => l_create_rec);
486:
487: IF x_return_status <> fnd_api.g_ret_sts_success THEN
488: RAISE fnd_api.g_exc_error;
489: END IF;
490:
491: --
492: -- End of API body.

Line 507: p_init_msg_list => fnd_api.g_false,

503: 'V')
504: THEN
505: cn_srp_paygroup_pub_vuhk.assign_salesreps_post
506: (p_api_version => p_api_version,
507: p_init_msg_list => fnd_api.g_false,
508: p_commit => fnd_api.g_false,
509: p_validation_level => p_validation_level,
510: x_return_status => x_return_status,
511: x_msg_count => x_msg_count,

Line 508: p_commit => fnd_api.g_false,

504: THEN
505: cn_srp_paygroup_pub_vuhk.assign_salesreps_post
506: (p_api_version => p_api_version,
507: p_init_msg_list => fnd_api.g_false,
508: p_commit => fnd_api.g_false,
509: p_validation_level => p_validation_level,
510: x_return_status => x_return_status,
511: x_msg_count => x_msg_count,
512: x_msg_data => x_msg_data,

Line 518: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

514: x_loading_status => x_loading_status,
515: x_status => x_status
516: );
517:
518: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
519: THEN
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
522: THEN

Line 520: RAISE FND_API.G_EXC_ERROR;

516: );
517:
518: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
519: THEN
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
522: THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;

Line 521: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

517:
518: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
519: THEN
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
522: THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: END IF;

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: THEN
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
522: THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: END IF;
526:
527: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

Line 534: p_init_msg_list => fnd_api.g_false,

530: 'C')
531: THEN
532: cn_srp_paygroup_pub_cuhk.assign_salesreps_post
533: (p_api_version => p_api_version,
534: p_init_msg_list => fnd_api.g_false,
535: p_commit => fnd_api.g_false,
536: p_validation_level => p_validation_level,
537: x_return_status => x_return_status,
538: x_msg_count => x_msg_count,

Line 535: p_commit => fnd_api.g_false,

531: THEN
532: cn_srp_paygroup_pub_cuhk.assign_salesreps_post
533: (p_api_version => p_api_version,
534: p_init_msg_list => fnd_api.g_false,
535: p_commit => fnd_api.g_false,
536: p_validation_level => p_validation_level,
537: x_return_status => x_return_status,
538: x_msg_count => x_msg_count,
539: x_msg_data => x_msg_data,

Line 545: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

541: x_loading_status => x_loading_status,
542: x_status => x_status
543: );
544:
545: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
546: THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
549: THEN

Line 547: RAISE FND_API.G_EXC_ERROR;

543: );
544:
545: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
546: THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
549: THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;

Line 548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

544:
545: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
546: THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
549: THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552: END IF;

Line 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546: THEN
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
549: THEN
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552: END IF;
553:
554: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PAYGROUP_PUB',

Line 581: IF (x_return_status = FND_API.G_RET_STS_ERROR)

577: p_oai_param => null,
578: p_oai_array => l_oai_array,
579: x_return_code => x_return_status) ;
580:
581: IF (x_return_status = FND_API.G_RET_STS_ERROR)
582: THEN
583: RAISE FND_API.G_EXC_ERROR;
584: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
585: THEN

Line 583: RAISE FND_API.G_EXC_ERROR;

579: x_return_code => x_return_status) ;
580:
581: IF (x_return_status = FND_API.G_RET_STS_ERROR)
582: THEN
583: RAISE FND_API.G_EXC_ERROR;
584: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
585: THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;

Line 584: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

580:
581: IF (x_return_status = FND_API.G_RET_STS_ERROR)
582: THEN
583: RAISE FND_API.G_EXC_ERROR;
584: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
585: THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588: END IF;

Line 586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

582: THEN
583: RAISE FND_API.G_EXC_ERROR;
584: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
585: THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588: END IF;
589: END IF;
590:

Line 594: IF FND_API.To_Boolean( p_commit ) THEN

590:
591:
592:
593: -- Standard check of p_commit.
594: IF FND_API.To_Boolean( p_commit ) THEN
595: COMMIT WORK;
596: END IF;
597:
598: --

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:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN

Line 610: WHEN FND_API.G_EXC_ERROR THEN

606: p_encoded => FND_API.G_FALSE
607: );
608:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO Assign_salesreps;
612: x_return_status := FND_API.G_RET_STS_ERROR ;
613: FND_MSG_PUB.Count_And_Get
614: (

Line 612: x_return_status := FND_API.G_RET_STS_ERROR ;

608:
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO Assign_salesreps;
612: x_return_status := FND_API.G_RET_STS_ERROR ;
613: FND_MSG_PUB.Count_And_Get
614: (
615: p_count => x_msg_count ,
616: p_data => x_msg_data ,

Line 617: p_encoded => FND_API.G_FALSE

613: FND_MSG_PUB.Count_And_Get
614: (
615: p_count => x_msg_count ,
616: p_data => x_msg_data ,
617: p_encoded => FND_API.G_FALSE
618: );
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO Assign_salesreps;
621: x_loading_status := 'UNEXPECTED_ERR';

Line 619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

615: p_count => x_msg_count ,
616: p_data => x_msg_data ,
617: p_encoded => FND_API.G_FALSE
618: );
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO Assign_salesreps;
621: x_loading_status := 'UNEXPECTED_ERR';
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
623: FND_MSG_PUB.Count_And_Get

Line 622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

618: );
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: ROLLBACK TO Assign_salesreps;
621: x_loading_status := 'UNEXPECTED_ERR';
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
623: FND_MSG_PUB.Count_And_Get
624: (
625: p_count => x_msg_count ,
626: p_data => x_msg_data ,

Line 627: p_encoded => FND_API.G_FALSE

623: FND_MSG_PUB.Count_And_Get
624: (
625: p_count => x_msg_count ,
626: p_data => x_msg_data ,
627: p_encoded => FND_API.G_FALSE
628: );
629: WHEN OTHERS THEN
630: ROLLBACK TO Assign_salesreps;
631: x_loading_status := 'UNEXPECTED_ERR';

Line 632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

628: );
629: WHEN OTHERS THEN
630: ROLLBACK TO Assign_salesreps;
631: x_loading_status := 'UNEXPECTED_ERR';
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
634: THEN
635: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
636: END IF;

Line 641: p_encoded => FND_API.G_FALSE

637: FND_MSG_PUB.Count_And_Get
638: (
639: p_count => x_msg_count ,
640: p_data => x_msg_data ,
641: p_encoded => FND_API.G_FALSE
642: );
643:
644: END Assign_salesreps;
645:

Line 719: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

715:
716: --
717: -- Standard call to check for call compatibility.
718: --
719: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
720: p_api_version ,
721: l_api_name ,
722: G_PKG_NAME )
723: THEN

Line 724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

720: p_api_version ,
721: l_api_name ,
722: G_PKG_NAME )
723: THEN
724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
725: END IF;
726:
727:
728: --

Line 731: IF FND_API.to_Boolean( p_init_msg_list ) THEN

727:
728: --
729: -- Initialize message list if p_init_msg_list is set to TRUE.
730: --
731: IF FND_API.to_Boolean( p_init_msg_list ) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734:
735:

Line 739: x_return_status := FND_API.G_RET_STS_SUCCESS;

735:
736: --
737: -- Initialize API return status to success
738: --
739: x_return_status := FND_API.G_RET_STS_SUCCESS;
740: x_loading_status := 'CN_UPDATED';
741:
742: --
743: -- Assign the parameter to a local variable

Line 773: RAISE FND_API.G_EXC_ERROR ;

769: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
770: FND_MSG_PUB.Add;
771: END IF;
772:
773: RAISE FND_API.G_EXC_ERROR ;
774: end if;
775:
776: l_org_id := l_old_paygroup_assign_rec.org_id;
777: mo_global.validate_orgid_pub_api

Line 795: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

791: (p_char_para => l_old_paygroup_assign_rec.pay_group_name,
792: p_obj_name =>
793: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
794: p_loading_status => x_loading_status,
795: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
796: THEN
797: RAISE FND_API.G_EXC_ERROR ;
798: END IF;
799:

Line 797: RAISE FND_API.G_EXC_ERROR ;

793: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
794: p_loading_status => x_loading_status,
795: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
796: THEN
797: RAISE FND_API.G_EXC_ERROR ;
798: END IF;
799:
800: -- Fetch pay_group_id
801: OPEN get_pay_group_id_cur(l_old_paygroup_assign_rec.pay_group_name, l_org_id);

Line 823: RAISE FND_API.G_EXC_ERROR;

819: END IF;
820:
821: x_loading_status := 'CN_INVALID_PAY_GROUP';
822: CLOSE get_pay_group_id_cur;
823: RAISE FND_API.G_EXC_ERROR;
824:
825: END IF;
826:
827:

Line 848: x_loading_status => x_loading_status)) = FND_API.G_TRUE )

844: (p_char_para => l_paygroup_assign_rec.pay_group_name,
845: p_obj_name =>
846: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
847: p_loading_status => x_loading_status,
848: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
849: THEN
850: RAISE FND_API.G_EXC_ERROR ;
851: END IF;
852:

Line 850: RAISE FND_API.G_EXC_ERROR ;

846: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
847: p_loading_status => x_loading_status,
848: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
849: THEN
850: RAISE FND_API.G_EXC_ERROR ;
851: END IF;
852:
853: -- Fetch pay_group_id
854: OPEN get_pay_group_id_cur(l_paygroup_assign_rec.pay_group_name, l_org_id);

Line 874: RAISE FND_API.G_EXC_ERROR;

870: END IF;
871:
872: x_loading_status := 'CN_INVALID_PAY_GROUP';
873: CLOSE get_pay_group_id_cur;
874: RAISE FND_API.G_EXC_ERROR;
875:
876: END IF;
877:
878: --

Line 931: RAISE fnd_api.g_exc_error;

927: --Reset the loading status
928: --
929: x_loading_status := 'CN_UPDATED';
930: ELSE
931: RAISE fnd_api.g_exc_error;
932: END IF;
933:
934: --**************************************************************
935: -- added Kumar Sivasankaran

Line 974: RAISE fnd_api.g_exc_error;

970: --Reset the loading status
971: --
972: x_loading_status := 'CN_UPDATED';
973: ELSE
974: RAISE fnd_api.g_exc_error;
975: END IF;
976:
977: OPEN get_srp_pay_group_id_cur(l_old_salesrep_id,
978: l_old_pay_group_id,

Line 997: RAISE FND_API.G_EXC_ERROR;

993: fnd_msg_pub.add;
994: END IF;
995: x_loading_status := 'CN_INVALID_SRP_PGRP_ASGN';
996: CLOSE get_srp_pay_group_id_cur;
997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
999:
1000: CLOSE get_srp_pay_group_id_cur;
1001:

Line 1013: p_init_msg_list => fnd_api.g_false,

1009: 'C')
1010: THEN
1011: cn_srp_paygroup_pub_cuhk.update_srp_assignment_pre
1012: (p_api_version => p_api_version,
1013: p_init_msg_list => fnd_api.g_false,
1014: p_commit => fnd_api.g_false,
1015: p_validation_level => p_validation_level,
1016: x_return_status => x_return_status,
1017: x_msg_count => x_msg_count,

Line 1014: p_commit => fnd_api.g_false,

1010: THEN
1011: cn_srp_paygroup_pub_cuhk.update_srp_assignment_pre
1012: (p_api_version => p_api_version,
1013: p_init_msg_list => fnd_api.g_false,
1014: p_commit => fnd_api.g_false,
1015: p_validation_level => p_validation_level,
1016: x_return_status => x_return_status,
1017: x_msg_count => x_msg_count,
1018: x_msg_data => x_msg_data,

Line 1025: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1021: x_loading_status => x_loading_status,
1022: x_status => x_status
1023: );
1024:
1025: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1026: THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1029: THEN

Line 1027: RAISE FND_API.G_EXC_ERROR;

1023: );
1024:
1025: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1026: THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1029: THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;

Line 1028: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1024:
1025: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1026: THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1029: THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032: END IF;

Line 1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1026: THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1029: THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032: END IF;
1033:
1034: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

Line 1041: p_init_msg_list => fnd_api.g_false,

1037: 'V')
1038: THEN
1039: cn_srp_paygroup_pub_vuhk.update_srp_assignment_pre
1040: (p_api_version => p_api_version,
1041: p_init_msg_list => fnd_api.g_false,
1042: p_commit => fnd_api.g_false,
1043: p_validation_level => p_validation_level,
1044: x_return_status => x_return_status,
1045: x_msg_count => x_msg_count,

Line 1042: p_commit => fnd_api.g_false,

1038: THEN
1039: cn_srp_paygroup_pub_vuhk.update_srp_assignment_pre
1040: (p_api_version => p_api_version,
1041: p_init_msg_list => fnd_api.g_false,
1042: p_commit => fnd_api.g_false,
1043: p_validation_level => p_validation_level,
1044: x_return_status => x_return_status,
1045: x_msg_count => x_msg_count,
1046: x_msg_data => x_msg_data,

Line 1053: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1049: x_loading_status => x_loading_status,
1050: x_status => x_status
1051: );
1052:
1053: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1054: THEN
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1057: THEN

Line 1055: RAISE FND_API.G_EXC_ERROR;

1051: );
1052:
1053: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1054: THEN
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1057: THEN
1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1059: END IF;

Line 1056: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1052:
1053: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1054: THEN
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1057: THEN
1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1059: END IF;
1060: END IF;

Line 1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1054: THEN
1055: RAISE FND_API.G_EXC_ERROR;
1056: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1057: THEN
1058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1059: END IF;
1060: END IF;
1061:
1062: -- main API

Line 1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1096: x_msg_count => x_msg_count,
1097: x_msg_data => x_msg_data,
1098: p_paygroup_assign_rec => l_update_rec);
1099:
1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1101: RAISE fnd_api.g_exc_error;
1102: END IF;
1103:
1104: --

Line 1101: RAISE fnd_api.g_exc_error;

1097: x_msg_data => x_msg_data,
1098: p_paygroup_assign_rec => l_update_rec);
1099:
1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1101: RAISE fnd_api.g_exc_error;
1102: END IF;
1103:
1104: --
1105: -- End of API body.

Line 1121: p_init_msg_list => fnd_api.g_false,

1117: 'V')
1118: THEN
1119: cn_srp_paygroup_pub_vuhk.update_srp_assignment_post
1120: (p_api_version => p_api_version,
1121: p_init_msg_list => fnd_api.g_false,
1122: p_commit => fnd_api.g_false,
1123: p_validation_level => p_validation_level,
1124: x_return_status => x_return_status,
1125: x_msg_count => x_msg_count,

Line 1122: p_commit => fnd_api.g_false,

1118: THEN
1119: cn_srp_paygroup_pub_vuhk.update_srp_assignment_post
1120: (p_api_version => p_api_version,
1121: p_init_msg_list => fnd_api.g_false,
1122: p_commit => fnd_api.g_false,
1123: p_validation_level => p_validation_level,
1124: x_return_status => x_return_status,
1125: x_msg_count => x_msg_count,
1126: x_msg_data => x_msg_data,

Line 1133: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1129: x_loading_status => x_loading_status,
1130: x_status => x_status
1131: );
1132:
1133: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1134: THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1137: THEN

Line 1135: RAISE FND_API.G_EXC_ERROR;

1131: );
1132:
1133: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1134: THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1137: THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;

Line 1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1132:
1133: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1134: THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1137: THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140: END IF;

Line 1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1134: THEN
1135: RAISE FND_API.G_EXC_ERROR;
1136: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1137: THEN
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END IF;
1140: END IF;
1141:
1142: IF JTF_USR_HKS.Ok_to_Execute('CN_SRP_PAYGROUP_PUB',

Line 1149: p_init_msg_list => fnd_api.g_false,

1145: 'C')
1146: THEN
1147: cn_srp_paygroup_pub_cuhk.update_srp_assignment_post
1148: (p_api_version => p_api_version,
1149: p_init_msg_list => fnd_api.g_false,
1150: p_commit => fnd_api.g_false,
1151: p_validation_level => p_validation_level,
1152: x_return_status => x_return_status,
1153: x_msg_count => x_msg_count,

Line 1150: p_commit => fnd_api.g_false,

1146: THEN
1147: cn_srp_paygroup_pub_cuhk.update_srp_assignment_post
1148: (p_api_version => p_api_version,
1149: p_init_msg_list => fnd_api.g_false,
1150: p_commit => fnd_api.g_false,
1151: p_validation_level => p_validation_level,
1152: x_return_status => x_return_status,
1153: x_msg_count => x_msg_count,
1154: x_msg_data => x_msg_data,

Line 1161: IF ( x_return_status = FND_API.G_RET_STS_ERROR )

1157: x_loading_status => x_loading_status,
1158: x_status => x_status
1159: );
1160:
1161: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1162: THEN
1163: RAISE FND_API.G_EXC_ERROR;
1164: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1165: THEN

Line 1163: RAISE FND_API.G_EXC_ERROR;

1159: );
1160:
1161: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1162: THEN
1163: RAISE FND_API.G_EXC_ERROR;
1164: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1165: THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;

Line 1164: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1160:
1161: IF ( x_return_status = FND_API.G_RET_STS_ERROR )
1162: THEN
1163: RAISE FND_API.G_EXC_ERROR;
1164: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1165: THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;
1168: END IF;

Line 1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1162: THEN
1163: RAISE FND_API.G_EXC_ERROR;
1164: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1165: THEN
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;
1168: END IF;
1169:
1170: IF JTF_USR_HKS.Ok_to_execute('CN_SRP_PAYGROUP_PUB',

Line 1197: IF (x_return_status = FND_API.G_RET_STS_ERROR)

1193: p_oai_param => null,
1194: p_oai_array => l_oai_array,
1195: x_return_code => x_return_status) ;
1196:
1197: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1198: THEN
1199: RAISE FND_API.G_EXC_ERROR;
1200: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1201: THEN

Line 1199: RAISE FND_API.G_EXC_ERROR;

1195: x_return_code => x_return_status) ;
1196:
1197: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1198: THEN
1199: RAISE FND_API.G_EXC_ERROR;
1200: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1201: THEN
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203: END IF;

Line 1200: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )

1196:
1197: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1198: THEN
1199: RAISE FND_API.G_EXC_ERROR;
1200: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1201: THEN
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203: END IF;
1204: END IF;

Line 1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1198: THEN
1199: RAISE FND_API.G_EXC_ERROR;
1200: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR )
1201: THEN
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203: END IF;
1204: END IF;
1205: END IF;
1206:

Line 1208: IF FND_API.To_Boolean( p_commit ) THEN

1204: END IF;
1205: END IF;
1206:
1207: -- Standard check of p_commit.
1208: IF FND_API.To_Boolean( p_commit ) THEN
1209: COMMIT WORK;
1210: END IF;
1211:
1212: --

Line 1220: p_encoded => FND_API.G_FALSE

1216: FND_MSG_PUB.Count_And_Get
1217: (
1218: p_count => x_msg_count ,
1219: p_data => x_msg_data ,
1220: p_encoded => FND_API.G_FALSE
1221: );
1222:
1223: EXCEPTION
1224: WHEN FND_API.G_EXC_ERROR THEN

Line 1224: WHEN FND_API.G_EXC_ERROR THEN

1220: p_encoded => FND_API.G_FALSE
1221: );
1222:
1223: EXCEPTION
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO update_srp_assignment;
1226: x_return_status := FND_API.G_RET_STS_ERROR ;
1227: FND_MSG_PUB.Count_And_Get
1228: (

Line 1226: x_return_status := FND_API.G_RET_STS_ERROR ;

1222:
1223: EXCEPTION
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO update_srp_assignment;
1226: x_return_status := FND_API.G_RET_STS_ERROR ;
1227: FND_MSG_PUB.Count_And_Get
1228: (
1229: p_count => x_msg_count ,
1230: p_data => x_msg_data ,

Line 1231: p_encoded => FND_API.G_FALSE

1227: FND_MSG_PUB.Count_And_Get
1228: (
1229: p_count => x_msg_count ,
1230: p_data => x_msg_data ,
1231: p_encoded => FND_API.G_FALSE
1232: );
1233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1234: ROLLBACK TO update_srp_assignment;
1235: x_loading_status := 'UNEXPECTED_ERR';

Line 1233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1229: p_count => x_msg_count ,
1230: p_data => x_msg_data ,
1231: p_encoded => FND_API.G_FALSE
1232: );
1233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1234: ROLLBACK TO update_srp_assignment;
1235: x_loading_status := 'UNEXPECTED_ERR';
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1237: FND_MSG_PUB.Count_And_Get

Line 1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1232: );
1233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1234: ROLLBACK TO update_srp_assignment;
1235: x_loading_status := 'UNEXPECTED_ERR';
1236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1237: FND_MSG_PUB.Count_And_Get
1238: (
1239: p_count => x_msg_count ,
1240: p_data => x_msg_data ,

Line 1241: p_encoded => FND_API.G_FALSE

1237: FND_MSG_PUB.Count_And_Get
1238: (
1239: p_count => x_msg_count ,
1240: p_data => x_msg_data ,
1241: p_encoded => FND_API.G_FALSE
1242: );
1243: WHEN OTHERS THEN
1244: ROLLBACK TO update_srp_assignment;
1245: x_loading_status := 'UNEXPECTED_ERR';

Line 1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1242: );
1243: WHEN OTHERS THEN
1244: ROLLBACK TO update_srp_assignment;
1245: x_loading_status := 'UNEXPECTED_ERR';
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1248: THEN
1249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1250: END IF;

Line 1255: p_encoded => FND_API.G_FALSE

1251: FND_MSG_PUB.Count_And_Get
1252: (
1253: p_count => x_msg_count ,
1254: p_data => x_msg_data ,
1255: p_encoded => FND_API.G_FALSE
1256: );
1257:
1258: END update_srp_assignment;
1259:

Line 1309: IF NOT FND_API.compatible_api_call

1305: BEGIN
1306: -- Standard Start of API savepoint
1307: SAVEPOINT Create_Mass_Asgn_Srp_Pay;
1308: -- Standard call to check for call compatibility.
1309: IF NOT FND_API.compatible_api_call
1310: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
1311: THEN
1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1313: END IF;

Line 1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1308: -- Standard call to check for call compatibility.
1309: IF NOT FND_API.compatible_api_call
1310: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
1311: THEN
1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1313: END IF;
1314: -- Initialize message list if p_init_msg_list is set to TRUE.
1315: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1316: FND_MSG_PUB.initialize;

Line 1315: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1311: THEN
1312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1313: END IF;
1314: -- Initialize message list if p_init_msg_list is set to TRUE.
1315: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318: -- Initialize API return status to success
1319: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1319: x_return_status := FND_API.G_RET_STS_SUCCESS;

1315: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318: -- Initialize API return status to success
1319: x_return_status := FND_API.G_RET_STS_SUCCESS;
1320: x_loading_status := 'CN_INSERTED';
1321:
1322: -- begin API
1323: select pay_group_id, start_date, end_date, org_id

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

1394: p_paygroup_assign_rec => newrec,
1395: x_loading_status => l_loading_status,
1396: x_status => l_status );
1397:
1398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1399: RAISE fnd_api.g_exc_error;

1395: x_loading_status => l_loading_status,
1396: x_status => l_status );
1397:
1398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: l_return_status := FND_API.G_RET_STS_SUCCESS;
1403: x_return_status := l_return_status;

Line 1402: l_return_status := FND_API.G_RET_STS_SUCCESS;

1398: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: l_return_status := FND_API.G_RET_STS_SUCCESS;
1403: x_return_status := l_return_status;
1404: x_loading_status := l_loading_status;
1405: ELSE
1406: null;

Line 1414: IF FND_API.To_Boolean( p_commit ) THEN

1410: NULL;
1411: END IF;
1412:
1413: -- Standard check of p_commit.
1414: IF FND_API.To_Boolean( p_commit ) THEN
1415: COMMIT WORK;
1416: END IF;
1417: -- Standard call to get message count and if count is 1, get message info.
1418: FND_MSG_PUB.Count_And_Get

Line 1422: p_encoded => FND_API.G_FALSE

1418: FND_MSG_PUB.Count_And_Get
1419: (
1420: p_count => x_msg_count ,
1421: p_data => x_msg_data ,
1422: p_encoded => FND_API.G_FALSE
1423: );
1424: EXCEPTION
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;

Line 1425: WHEN FND_API.G_EXC_ERROR THEN

1421: p_data => x_msg_data ,
1422: p_encoded => FND_API.G_FALSE
1423: );
1424: EXCEPTION
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: FND_MSG_PUB.Count_And_Get
1429: (

Line 1427: x_return_status := FND_API.G_RET_STS_ERROR ;

1423: );
1424: EXCEPTION
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: FND_MSG_PUB.Count_And_Get
1429: (
1430: p_count => x_msg_count ,
1431: p_data => x_msg_data ,

Line 1432: p_encoded => FND_API.G_FALSE

1428: FND_MSG_PUB.Count_And_Get
1429: (
1430: p_count => x_msg_count ,
1431: p_data => x_msg_data ,
1432: p_encoded => FND_API.G_FALSE
1433: );
1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1435: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1436: x_loading_status := 'UNEXPECTED_ERR';

Line 1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1430: p_count => x_msg_count ,
1431: p_data => x_msg_data ,
1432: p_encoded => FND_API.G_FALSE
1433: );
1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1435: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1436: x_loading_status := 'UNEXPECTED_ERR';
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1438: FND_MSG_PUB.Count_And_Get

Line 1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1433: );
1434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1435: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1436: x_loading_status := 'UNEXPECTED_ERR';
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1438: FND_MSG_PUB.Count_And_Get
1439: (
1440: p_count => x_msg_count ,
1441: p_data => x_msg_data ,

Line 1442: p_encoded => FND_API.G_FALSE

1438: FND_MSG_PUB.Count_And_Get
1439: (
1440: p_count => x_msg_count ,
1441: p_data => x_msg_data ,
1442: p_encoded => FND_API.G_FALSE
1443: );
1444: WHEN OTHERS THEN
1445: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1446: x_loading_status := 'UNEXPECTED_ERR';

Line 1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1443: );
1444: WHEN OTHERS THEN
1445: ROLLBACK TO Create_Mass_Asgn_Srp_Pay;
1446: x_loading_status := 'UNEXPECTED_ERR';
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1448: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1449: THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1451: END IF;

Line 1456: p_encoded => FND_API.G_FALSE

1452: FND_MSG_PUB.Count_And_Get
1453: (
1454: p_count => x_msg_count ,
1455: p_data => x_msg_data ,
1456: p_encoded => FND_API.G_FALSE
1457: );
1458:
1459: END Create_Mass_Asgn_Srp_Pay;
1460:

Line 1548: IF NOT FND_API.compatible_api_call

1544: BEGIN
1545: -- Standard Start of API savepoint
1546: SAVEPOINT Update_Mass_Asgn_Srp_Pay;
1547: -- Standard call to check for call compatibility.
1548: IF NOT FND_API.compatible_api_call
1549: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
1550: THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: END IF;

Line 1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1547: -- Standard call to check for call compatibility.
1548: IF NOT FND_API.compatible_api_call
1549: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
1550: THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: END IF;
1553: -- Initialize message list if p_init_msg_list is set to TRUE.
1554: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1555: FND_MSG_PUB.initialize;

Line 1554: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1550: THEN
1551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1552: END IF;
1553: -- Initialize message list if p_init_msg_list is set to TRUE.
1554: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1555: FND_MSG_PUB.initialize;
1556: END IF;
1557: -- Initialize API return status to success
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1558: x_return_status := FND_API.G_RET_STS_SUCCESS;

1554: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1555: FND_MSG_PUB.initialize;
1556: END IF;
1557: -- Initialize API return status to success
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;
1559: x_loading_status := 'CN_UPDATED';
1560:
1561: -- begin API
1562: SELECT org_id

Line 1615: RAISE FND_API.G_EXC_ERROR;

1611:
1612:
1613: IF l_count_pay > 0
1614: THEN
1615: RAISE FND_API.G_EXC_ERROR;
1616: END IF;
1617: */
1618:
1619: SELECT employee_number, type,source_id

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

1711: p_ovn => l_ovn_old ,
1712: x_loading_status => l_loading_status,
1713: x_status => l_status );
1714:
1715: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1716: RAISE fnd_api.g_exc_error;
1717: END IF;
1718:
1719: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1716: RAISE fnd_api.g_exc_error;

1712: x_loading_status => l_loading_status,
1713: x_status => l_status );
1714:
1715: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1716: RAISE fnd_api.g_exc_error;
1717: END IF;
1718:
1719: l_return_status := FND_API.G_RET_STS_SUCCESS;
1720:

Line 1719: l_return_status := FND_API.G_RET_STS_SUCCESS;

1715: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1716: RAISE fnd_api.g_exc_error;
1717: END IF;
1718:
1719: l_return_status := FND_API.G_RET_STS_SUCCESS;
1720:
1721: IF l_loading_status = 'CN_INVALID_SRP_PGRP_ASGN_DT' THEN
1722: cn_srp_paygroup_pvt.delete_srp_pay_group
1723: (

Line 1732: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1728: x_msg_data => l_msg_data,
1729: p_paygroup_assign_rec => delrec
1730: );
1731:
1732: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1733: RAISE fnd_api.g_exc_error;
1734: END IF;
1735: END IF;
1736:

Line 1733: RAISE fnd_api.g_exc_error;

1729: p_paygroup_assign_rec => delrec
1730: );
1731:
1732: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1733: RAISE fnd_api.g_exc_error;
1734: END IF;
1735: END IF;
1736:
1737: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1737: l_return_status := FND_API.G_RET_STS_SUCCESS;

1733: RAISE fnd_api.g_exc_error;
1734: END IF;
1735: END IF;
1736:
1737: l_return_status := FND_API.G_RET_STS_SUCCESS;
1738: x_return_status := l_return_status;
1739: x_loading_status := l_loading_status;
1740: ELSIF (l_count_srp_pay_group = 0 )
1741: THEN

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

1758: p_paygroup_assign_rec=> newrec,
1759: x_loading_status => l_loading_status,
1760: x_status => l_status );
1761:
1762: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1763: RAISE fnd_api.g_exc_error;
1764: END IF;
1765: END IF;
1766: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1763: RAISE fnd_api.g_exc_error;

1759: x_loading_status => l_loading_status,
1760: x_status => l_status );
1761:
1762: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1763: RAISE fnd_api.g_exc_error;
1764: END IF;
1765: END IF;
1766: l_return_status := FND_API.G_RET_STS_SUCCESS;
1767: x_return_status := l_return_status;

Line 1766: l_return_status := FND_API.G_RET_STS_SUCCESS;

1762: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1763: RAISE fnd_api.g_exc_error;
1764: END IF;
1765: END IF;
1766: l_return_status := FND_API.G_RET_STS_SUCCESS;
1767: x_return_status := l_return_status;
1768: x_loading_status := l_loading_status;
1769:
1770: END IF;

Line 1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1780: p_paygroup_assign_rec=> delrec
1781:
1782: );
1783:
1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1785: RAISE fnd_api.g_exc_error;
1786: END IF;
1787:
1788: l_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1785: RAISE fnd_api.g_exc_error;

1781:
1782: );
1783:
1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1785: RAISE fnd_api.g_exc_error;
1786: END IF;
1787:
1788: l_return_status:=FND_API.G_RET_STS_SUCCESS;
1789:

Line 1788: l_return_status:=FND_API.G_RET_STS_SUCCESS;

1784: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1785: RAISE fnd_api.g_exc_error;
1786: END IF;
1787:
1788: l_return_status:=FND_API.G_RET_STS_SUCCESS;
1789:
1790: END IF;
1791: ELSE
1792: NULL;

Line 1797: IF FND_API.To_Boolean( p_commit ) THEN

1793:
1794: END IF;
1795:
1796: -- Standard check of p_commit.
1797: IF FND_API.To_Boolean( p_commit ) THEN
1798: COMMIT WORK;
1799: END IF;
1800: -- Standard call to get message count and if count is 1, get message info.
1801: FND_MSG_PUB.Count_And_Get

Line 1805: p_encoded => FND_API.G_FALSE

1801: FND_MSG_PUB.Count_And_Get
1802: (
1803: p_count => x_msg_count ,
1804: p_data => x_msg_data ,
1805: p_encoded => FND_API.G_FALSE
1806: );
1807:
1808: EXCEPTION
1809: WHEN FND_API.G_EXC_ERROR THEN

Line 1809: WHEN FND_API.G_EXC_ERROR THEN

1805: p_encoded => FND_API.G_FALSE
1806: );
1807:
1808: EXCEPTION
1809: WHEN FND_API.G_EXC_ERROR THEN
1810: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1811: x_return_status := FND_API.G_RET_STS_ERROR ;
1812: FND_MSG_PUB.Count_And_Get
1813: (

Line 1811: x_return_status := FND_API.G_RET_STS_ERROR ;

1807:
1808: EXCEPTION
1809: WHEN FND_API.G_EXC_ERROR THEN
1810: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1811: x_return_status := FND_API.G_RET_STS_ERROR ;
1812: FND_MSG_PUB.Count_And_Get
1813: (
1814: p_count => x_msg_count ,
1815: p_data => x_msg_data ,

Line 1816: p_encoded => FND_API.G_FALSE

1812: FND_MSG_PUB.Count_And_Get
1813: (
1814: p_count => x_msg_count ,
1815: p_data => x_msg_data ,
1816: p_encoded => FND_API.G_FALSE
1817: );
1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1819: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1820: x_loading_status := 'UNEXPECTED_ERR';

Line 1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1814: p_count => x_msg_count ,
1815: p_data => x_msg_data ,
1816: p_encoded => FND_API.G_FALSE
1817: );
1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1819: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1820: x_loading_status := 'UNEXPECTED_ERR';
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: FND_MSG_PUB.Count_And_Get

Line 1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1817: );
1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1819: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1820: x_loading_status := 'UNEXPECTED_ERR';
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: FND_MSG_PUB.Count_And_Get
1823: (
1824: p_count => x_msg_count ,
1825: p_data => x_msg_data ,

Line 1826: p_encoded => FND_API.G_FALSE

1822: FND_MSG_PUB.Count_And_Get
1823: (
1824: p_count => x_msg_count ,
1825: p_data => x_msg_data ,
1826: p_encoded => FND_API.G_FALSE
1827: );
1828: WHEN OTHERS THEN
1829: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1830: x_loading_status := 'UNEXPECTED_ERR';

Line 1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1827: );
1828: WHEN OTHERS THEN
1829: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1830: x_loading_status := 'UNEXPECTED_ERR';
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1835: END IF;

Line 1840: p_encoded => FND_API.G_FALSE

1836: FND_MSG_PUB.Count_And_Get
1837: (
1838: p_count => x_msg_count ,
1839: p_data => x_msg_data ,
1840: p_encoded => FND_API.G_FALSE
1841: );
1842:
1843: End Update_Mass_Asgn_Srp_Pay;
1844: