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 1308: IF NOT FND_API.compatible_api_call

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

Line 1311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1314: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1318: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 1397: RAISE fnd_api.g_exc_error;

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

Line 1400: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1412: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1420: p_encoded => FND_API.G_FALSE

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

Line 1423: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1425: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1430: p_encoded => FND_API.G_FALSE

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

Line 1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1440: p_encoded => FND_API.G_FALSE

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

Line 1445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1454: p_encoded => FND_API.G_FALSE

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

Line 1544: IF NOT FND_API.compatible_api_call

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

Line 1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1550: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1554: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1611: RAISE FND_API.G_EXC_ERROR;

1607:
1608:
1609: IF l_count_pay > 0
1610: THEN
1611: RAISE FND_API.G_EXC_ERROR;
1612: END IF;
1613: */
1614:
1615: SELECT employee_number, type

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

1703: p_ovn => l_ovn_old ,
1704: x_loading_status => l_loading_status,
1705: x_status => l_status );
1706:
1707: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1708: RAISE fnd_api.g_exc_error;
1709: END IF;
1710:
1711: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1708: RAISE fnd_api.g_exc_error;

1704: x_loading_status => l_loading_status,
1705: x_status => l_status );
1706:
1707: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1708: RAISE fnd_api.g_exc_error;
1709: END IF;
1710:
1711: l_return_status := FND_API.G_RET_STS_SUCCESS;
1712:

Line 1711: l_return_status := FND_API.G_RET_STS_SUCCESS;

1707: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1708: RAISE fnd_api.g_exc_error;
1709: END IF;
1710:
1711: l_return_status := FND_API.G_RET_STS_SUCCESS;
1712:
1713: IF l_loading_status = 'CN_INVALID_SRP_PGRP_ASGN_DT' THEN
1714: cn_srp_paygroup_pvt.delete_srp_pay_group
1715: (

Line 1724: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1720: x_msg_data => l_msg_data,
1721: p_paygroup_assign_rec => delrec
1722: );
1723:
1724: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1725: RAISE fnd_api.g_exc_error;
1726: END IF;
1727: END IF;
1728:

Line 1725: RAISE fnd_api.g_exc_error;

1721: p_paygroup_assign_rec => delrec
1722: );
1723:
1724: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1725: RAISE fnd_api.g_exc_error;
1726: END IF;
1727: END IF;
1728:
1729: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1729: l_return_status := FND_API.G_RET_STS_SUCCESS;

1725: RAISE fnd_api.g_exc_error;
1726: END IF;
1727: END IF;
1728:
1729: l_return_status := FND_API.G_RET_STS_SUCCESS;
1730: x_return_status := l_return_status;
1731: x_loading_status := l_loading_status;
1732: ELSIF (l_count_srp_pay_group = 0 )
1733: THEN

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

1750: p_paygroup_assign_rec=> newrec,
1751: x_loading_status => l_loading_status,
1752: x_status => l_status );
1753:
1754: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1755: RAISE fnd_api.g_exc_error;
1756: END IF;
1757: END IF;
1758: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1755: RAISE fnd_api.g_exc_error;

1751: x_loading_status => l_loading_status,
1752: x_status => l_status );
1753:
1754: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1755: RAISE fnd_api.g_exc_error;
1756: END IF;
1757: END IF;
1758: l_return_status := FND_API.G_RET_STS_SUCCESS;
1759: x_return_status := l_return_status;

Line 1758: l_return_status := FND_API.G_RET_STS_SUCCESS;

1754: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1755: RAISE fnd_api.g_exc_error;
1756: END IF;
1757: END IF;
1758: l_return_status := FND_API.G_RET_STS_SUCCESS;
1759: x_return_status := l_return_status;
1760: x_loading_status := l_loading_status;
1761:
1762: END IF;

Line 1776: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1772: p_paygroup_assign_rec=> delrec
1773:
1774: );
1775:
1776: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1777: RAISE fnd_api.g_exc_error;
1778: END IF;
1779:
1780: l_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1777: RAISE fnd_api.g_exc_error;

1773:
1774: );
1775:
1776: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1777: RAISE fnd_api.g_exc_error;
1778: END IF;
1779:
1780: l_return_status:=FND_API.G_RET_STS_SUCCESS;
1781:

Line 1780: l_return_status:=FND_API.G_RET_STS_SUCCESS;

1776: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1777: RAISE fnd_api.g_exc_error;
1778: END IF;
1779:
1780: l_return_status:=FND_API.G_RET_STS_SUCCESS;
1781:
1782: END IF;
1783: ELSE
1784: NULL;

Line 1789: IF FND_API.To_Boolean( p_commit ) THEN

1785:
1786: END IF;
1787:
1788: -- Standard check of p_commit.
1789: IF FND_API.To_Boolean( p_commit ) THEN
1790: COMMIT WORK;
1791: END IF;
1792: -- Standard call to get message count and if count is 1, get message info.
1793: FND_MSG_PUB.Count_And_Get

Line 1797: p_encoded => FND_API.G_FALSE

1793: FND_MSG_PUB.Count_And_Get
1794: (
1795: p_count => x_msg_count ,
1796: p_data => x_msg_data ,
1797: p_encoded => FND_API.G_FALSE
1798: );
1799:
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN

Line 1801: WHEN FND_API.G_EXC_ERROR THEN

1797: p_encoded => FND_API.G_FALSE
1798: );
1799:
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN
1802: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1803: x_return_status := FND_API.G_RET_STS_ERROR ;
1804: FND_MSG_PUB.Count_And_Get
1805: (

Line 1803: x_return_status := FND_API.G_RET_STS_ERROR ;

1799:
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN
1802: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1803: x_return_status := FND_API.G_RET_STS_ERROR ;
1804: FND_MSG_PUB.Count_And_Get
1805: (
1806: p_count => x_msg_count ,
1807: p_data => x_msg_data ,

Line 1808: p_encoded => FND_API.G_FALSE

1804: FND_MSG_PUB.Count_And_Get
1805: (
1806: p_count => x_msg_count ,
1807: p_data => x_msg_data ,
1808: p_encoded => FND_API.G_FALSE
1809: );
1810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1811: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1812: x_loading_status := 'UNEXPECTED_ERR';

Line 1810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1809: );
1810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1811: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1812: x_loading_status := 'UNEXPECTED_ERR';
1813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1814: FND_MSG_PUB.Count_And_Get
1815: (
1816: p_count => x_msg_count ,
1817: p_data => x_msg_data ,

Line 1818: p_encoded => FND_API.G_FALSE

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

Line 1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1819: );
1820: WHEN OTHERS THEN
1821: ROLLBACK TO Update_Mass_Asgn_Srp_Pay;
1822: x_loading_status := 'UNEXPECTED_ERR';
1823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1824: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1825: THEN
1826: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
1827: END IF;

Line 1832: p_encoded => FND_API.G_FALSE

1828: FND_MSG_PUB.Count_And_Get
1829: (
1830: p_count => x_msg_count ,
1831: p_data => x_msg_data ,
1832: p_encoded => FND_API.G_FALSE
1833: );
1834:
1835: End Update_Mass_Asgn_Srp_Pay;
1836: