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

Line 79: RAISE fnd_api.g_exc_error;

75: THEN
76: -- resource not exist for this user
77: fnd_message.set_name ('CN', 'CN_INVALID_PAYBYMODE');
78: fnd_msg_pub.ADD;
79: RAISE fnd_api.g_exc_error;
80: END IF ;
81: RETURN l_ret_val ;
82: END;
83:

Line 122: RAISE fnd_api.g_exc_error;

118: THEN
119: -- resource not exist for this user
120: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');
121: fnd_msg_pub.ADD;
122: RAISE fnd_api.g_exc_error;
123: END;
124:
125: -- Get number of parent_resource for current resource
126: SELECT SUM (DECODE (resource_id, parent_resource_id, 0, 1))

Line 195: RAISE fnd_api.g_exc_error;

191: THEN
192: -- resource not exist for this user
193: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');
194: fnd_msg_pub.ADD;
195: RAISE fnd_api.g_exc_error;
196: END;
197:
198: SELECT 1
199: INTO l_tmp

Line 259: x_return_status := fnd_api.g_ret_sts_success;

255: FROM cn_payruns
256: WHERE payrun_id = p_payrun_id;
257: BEGIN
258: -- Initialize API return status to success
259: x_return_status := fnd_api.g_ret_sts_success;
260:
261: OPEN getobj;
262:
263: FETCH getobj

Line 271: RAISE fnd_api.g_exc_error;

267: l_has_access := get_security_access (g_type_payrun, g_access_payrun_pay);
268:
269: IF (l_has_access = FALSE)
270: THEN
271: RAISE fnd_api.g_exc_error;
272: END IF;
273:
274: fnd_message.set_name('CN', 'CN_PAYSHEET_PAY_NOTE');
275: l_note_msg := fnd_message.get;

Line 304: IF x_return_status <> fnd_api.g_ret_sts_success

300: x_msg_data => x_msg_data,
301: p_payrun_id => p_payrun_id
302: );
303:
304: IF x_return_status <> fnd_api.g_ret_sts_success
305: THEN
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:

Line 306: RAISE fnd_api.g_exc_error;

302: );
303:
304: IF x_return_status <> fnd_api.g_ret_sts_success
305: THEN
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: -- update payrun status='PAID'
310: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,

Line 325: WHEN fnd_api.g_exc_error

321: p_event_name => 'pay' ,
322: p_payrun_id => p_payrun_id ) ;
323:
324: EXCEPTION
325: WHEN fnd_api.g_exc_error
326: THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
329: WHEN OTHERS

Line 327: x_return_status := fnd_api.g_ret_sts_error;

323:
324: EXCEPTION
325: WHEN fnd_api.g_exc_error
326: THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
329: WHEN OTHERS
330: THEN
331: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 328: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

324: EXCEPTION
325: WHEN fnd_api.g_exc_error
326: THEN
327: x_return_status := fnd_api.g_ret_sts_error;
328: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
329: WHEN OTHERS
330: THEN
331: x_return_status := fnd_api.g_ret_sts_unexp_error;
332:

Line 331: x_return_status := fnd_api.g_ret_sts_unexp_error;

327: x_return_status := fnd_api.g_ret_sts_error;
328: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
329: WHEN OTHERS
330: THEN
331: x_return_status := fnd_api.g_ret_sts_unexp_error;
332:
333: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
334: THEN
335: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 338: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

334: THEN
335: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
336: END IF;
337:
338: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
339: END paid_payrun_audit;
340:
341: --
342: -- Procedure : Payrun_Audit

Line 366: x_return_status := fnd_api.g_ret_sts_success;

362: FROM cn_payruns
363: WHERE payrun_id = p_payrun_id;
364: BEGIN
365: -- Initialize API return status to success
366: x_return_status := fnd_api.g_ret_sts_success;
367:
368: OPEN getobj;
369:
370: FETCH getobj

Line 385: RAISE fnd_api.g_exc_error;

381: l_has_access := get_security_access (g_type_payrun, g_access_payrun_freeze);
382:
383: IF (l_has_access = FALSE)
384: THEN
385: RAISE fnd_api.g_exc_error;
386: END IF;
387:
388: --Added for R12 payment security check end.
389: l_new_status := 'FROZEN';

Line 401: RAISE fnd_api.g_exc_error;

397: l_has_access := get_security_access (g_type_payrun, g_access_payrun_unfreeze);
398:
399: IF (l_has_access = FALSE)
400: THEN
401: RAISE fnd_api.g_exc_error;
402: END IF;
403: l_event_name := 'unfreeze' ;
404:
405: ELSIF p_action = 'REFRESH'

Line 411: RAISE fnd_api.g_exc_error;

407: l_has_access := get_security_access (g_type_payrun, g_access_payrun_refresh);
408:
409: IF (l_has_access = FALSE)
410: THEN
411: RAISE fnd_api.g_exc_error;
412: END IF;
413: l_event_name := 'refresh' ;
414:
415: ELSIF p_action = 'REMOVE'

Line 421: RAISE fnd_api.g_exc_error;

417: l_has_access := get_security_access (g_type_payrun, g_access_payrun_delete);
418:
419: IF (l_has_access = FALSE)
420: THEN
421: RAISE fnd_api.g_exc_error;
422: END IF;
423: l_event_name := 'delete' ;
424:
425: END IF;

Line 446: WHEN fnd_api.g_exc_error

442: p_payrun_id => p_payrun_id ) ;
443:
444: END IF;
445: EXCEPTION
446: WHEN fnd_api.g_exc_error
447: THEN
448: x_return_status := fnd_api.g_ret_sts_error;
449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
450: WHEN OTHERS

Line 448: x_return_status := fnd_api.g_ret_sts_error;

444: END IF;
445: EXCEPTION
446: WHEN fnd_api.g_exc_error
447: THEN
448: x_return_status := fnd_api.g_ret_sts_error;
449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
450: WHEN OTHERS
451: THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

445: EXCEPTION
446: WHEN fnd_api.g_exc_error
447: THEN
448: x_return_status := fnd_api.g_ret_sts_error;
449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
450: WHEN OTHERS
451: THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453:

Line 452: x_return_status := fnd_api.g_ret_sts_unexp_error;

448: x_return_status := fnd_api.g_ret_sts_error;
449: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
450: WHEN OTHERS
451: THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453:
454: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
455: THEN
456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 459: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

455: THEN
456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
457: END IF;
458:
459: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
460: END payrun_audit;
461:
462:
463: --===================================================================================

Line 466: -- This procedure expects validation to have been done already (worksheet_action p_do_audit => fnd_api.g_false)

462:
463: --===================================================================================
464: -- Procedure : Worksheet_Audit
465: -- Procedure to update worksheet status and enter audit info into notes
466: -- This procedure expects validation to have been done already (worksheet_action p_do_audit => fnd_api.g_false)
467: --===================================================================================
468: PROCEDURE worksheet_audit (
469: p_worksheet_id IN NUMBER,
470: p_payrun_id IN NUMBER,

Line 473: p_do_approval_flow IN VARCHAR2 := fnd_api.g_true,

469: p_worksheet_id IN NUMBER,
470: p_payrun_id IN NUMBER,
471: p_salesrep_id IN NUMBER,
472: p_action IN VARCHAR2,
473: p_do_approval_flow IN VARCHAR2 := fnd_api.g_true,
474: x_return_status OUT NOCOPY VARCHAR2,
475: x_msg_count OUT NOCOPY NUMBER,
476: x_msg_data OUT NOCOPY VARCHAR2
477: )

Line 493: x_return_status := fnd_api.g_ret_sts_success;

489: l_event_name VARCHAR2(80);
490:
491: BEGIN
492: -- Initialize API return status to success
493: x_return_status := fnd_api.g_ret_sts_success;
494:
495: -- update worksheet status
496: IF p_action = 'LOCK'
497: THEN

Line 549: IF p_do_approval_flow = fnd_api.g_true

545: ELSIF p_action = 'SUBMIT'
546: THEN
547: l_new_status := 'SUBMITTED';
548:
549: IF p_do_approval_flow = fnd_api.g_true
550: THEN
551: cn_pay_approval_flow_pvt.submit_worksheet (p_api_version => 1.0,
552: x_return_status => x_return_status,
553: x_msg_count => x_msg_count,

Line 558: IF x_return_status <> fnd_api.g_ret_sts_success

554: x_msg_data => x_msg_data,
555: p_worksheet_id => p_worksheet_id
556: );
557:
558: IF x_return_status <> fnd_api.g_ret_sts_success
559: THEN
560: RAISE fnd_api.g_exc_error;
561: END IF;
562: END IF;

Line 560: RAISE fnd_api.g_exc_error;

556: );
557:
558: IF x_return_status <> fnd_api.g_ret_sts_success
559: THEN
560: RAISE fnd_api.g_exc_error;
561: END IF;
562: END IF;
563: l_msg_name:='CN_PAYSHEET_SUBMIT_NOTE';
564: l_event_name := 'submit' ;

Line 570: IF p_do_approval_flow = fnd_api.g_true

566: ELSIF p_action = 'APPROVE'
567: THEN
568: l_new_status := 'APPROVED';
569:
570: IF p_do_approval_flow = fnd_api.g_true
571: THEN
572: cn_pay_approval_flow_pvt.approve_worksheet (p_api_version => 1.0,
573: x_return_status => x_return_status,
574: x_msg_count => x_msg_count,

Line 579: IF x_return_status <> fnd_api.g_ret_sts_success

575: x_msg_data => x_msg_data,
576: p_worksheet_id => p_worksheet_id
577: );
578:
579: IF x_return_status <> fnd_api.g_ret_sts_success
580: THEN
581: RAISE fnd_api.g_exc_error;
582: END IF;
583: END IF;

Line 581: RAISE fnd_api.g_exc_error;

577: );
578:
579: IF x_return_status <> fnd_api.g_ret_sts_success
580: THEN
581: RAISE fnd_api.g_exc_error;
582: END IF;
583: END IF;
584: l_msg_name:='CN_PAYESHEET_APPROVE_NOTE';
585: l_event_name := 'approve' ;

Line 591: IF p_do_approval_flow = fnd_api.g_true

587: ELSIF p_action = 'REJECT'
588: THEN
589: l_new_status := 'UNPAID';
590:
591: IF p_do_approval_flow = fnd_api.g_true
592: THEN
593: cn_pay_approval_flow_pvt.reject_worksheet (p_api_version => 1.0,
594: x_return_status => x_return_status,
595: x_msg_count => x_msg_count,

Line 600: IF x_return_status <> fnd_api.g_ret_sts_success

596: x_msg_data => x_msg_data,
597: p_worksheet_id => p_worksheet_id
598: );
599:
600: IF x_return_status <> fnd_api.g_ret_sts_success
601: THEN
602: RAISE fnd_api.g_exc_error;
603: END IF;
604: END IF;

Line 602: RAISE fnd_api.g_exc_error;

598: );
599:
600: IF x_return_status <> fnd_api.g_ret_sts_success
601: THEN
602: RAISE fnd_api.g_exc_error;
603: END IF;
604: END IF;
605: l_msg_name:='CN_PAYESHEET_REJECT_NOTE';
606: l_event_name := 'reject' ;

Line 652: WHEN fnd_api.g_exc_error

648: p_payrun_id => p_payrun_id,
649: p_salesrep_id => p_salesrep_id) ;
650:
651: EXCEPTION
652: WHEN fnd_api.g_exc_error
653: THEN
654: x_return_status := fnd_api.g_ret_sts_error;
655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
656: WHEN OTHERS

Line 654: x_return_status := fnd_api.g_ret_sts_error;

650:
651: EXCEPTION
652: WHEN fnd_api.g_exc_error
653: THEN
654: x_return_status := fnd_api.g_ret_sts_error;
655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
656: WHEN OTHERS
657: THEN
658: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

651: EXCEPTION
652: WHEN fnd_api.g_exc_error
653: THEN
654: x_return_status := fnd_api.g_ret_sts_error;
655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
656: WHEN OTHERS
657: THEN
658: x_return_status := fnd_api.g_ret_sts_unexp_error;
659:

Line 658: x_return_status := fnd_api.g_ret_sts_unexp_error;

654: x_return_status := fnd_api.g_ret_sts_error;
655: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
656: WHEN OTHERS
657: THEN
658: x_return_status := fnd_api.g_ret_sts_unexp_error;
659:
660: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
661: THEN
662: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 665: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

661: THEN
662: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
663: END IF;
664:
665: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
666: END worksheet_audit;
667:
668: -- Start of comments
669: -- API name : Payrun_Action

Line 676: -- Default = FND_API.G_FALSE

672: -- Pre-reqs : None.
673: -- Parameters :
674: -- IN : p_api_version IN NUMBER Required
675: -- p_init_msg_list IN VARCHAR2 Optional
676: -- Default = FND_API.G_FALSE
677: -- p_commit IN VARCHAR2 Optional
678: -- Default = FND_API.G_FALSE
679: -- p_validation_level IN NUMBER Optional
680: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 678: -- Default = FND_API.G_FALSE

674: -- IN : p_api_version IN NUMBER Required
675: -- p_init_msg_list IN VARCHAR2 Optional
676: -- Default = FND_API.G_FALSE
677: -- p_commit IN VARCHAR2 Optional
678: -- Default = FND_API.G_FALSE
679: -- p_validation_level IN NUMBER Optional
680: -- Default = FND_API.G_VALID_LEVEL_FULL
681: -- p_payrun_id IN NUMBER
682: -- p_action IN VARCHAR2

Line 680: -- Default = FND_API.G_VALID_LEVEL_FULL

676: -- Default = FND_API.G_FALSE
677: -- p_commit IN VARCHAR2 Optional
678: -- Default = FND_API.G_FALSE
679: -- p_validation_level IN NUMBER Optional
680: -- Default = FND_API.G_VALID_LEVEL_FULL
681: -- p_payrun_id IN NUMBER
682: -- p_action IN VARCHAR2
683: -- OUT : x_return_status OUT VARCHAR2(1)
684: -- x_msg_count OUT NUMBER

Line 693: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

689: --
690: -- End of comments
691: PROCEDURE payrun_action (
692: p_api_version IN NUMBER,
693: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
694: p_commit IN VARCHAR2 := fnd_api.g_false,
695: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
696: x_return_status OUT NOCOPY VARCHAR2,
697: x_msg_count OUT NOCOPY NUMBER,

Line 694: p_commit IN VARCHAR2 := fnd_api.g_false,

690: -- End of comments
691: PROCEDURE payrun_action (
692: p_api_version IN NUMBER,
693: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
694: p_commit IN VARCHAR2 := fnd_api.g_false,
695: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
696: x_return_status OUT NOCOPY VARCHAR2,
697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2,

Line 695: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

691: PROCEDURE payrun_action (
692: p_api_version IN NUMBER,
693: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
694: p_commit IN VARCHAR2 := fnd_api.g_false,
695: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
696: x_return_status OUT NOCOPY VARCHAR2,
697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2,
699: p_payrun_id IN NUMBER,

Line 701: p_do_audit IN VARCHAR2 := fnd_api.g_true

697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2,
699: p_payrun_id IN NUMBER,
700: p_action IN VARCHAR2,
701: p_do_audit IN VARCHAR2 := fnd_api.g_true
702: )
703: IS
704: l_api_name CONSTANT VARCHAR2 (30) := 'Payrun_Action';
705: l_api_version CONSTANT NUMBER := 1.0;

Line 737: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

733: -- Standard Start of API savepoint
734: SAVEPOINT payrun_action;
735:
736: -- Standard call to check for call compatibility.
737: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
738: THEN
739: RAISE fnd_api.g_exc_unexpected_error;
740: END IF;
741:

Line 739: RAISE fnd_api.g_exc_unexpected_error;

735:
736: -- Standard call to check for call compatibility.
737: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
738: THEN
739: RAISE fnd_api.g_exc_unexpected_error;
740: END IF;
741:
742: -- Initialize message list if p_init_msg_list is set to TRUE.
743: IF fnd_api.to_boolean (p_init_msg_list)

Line 743: IF fnd_api.to_boolean (p_init_msg_list)

739: RAISE fnd_api.g_exc_unexpected_error;
740: END IF;
741:
742: -- Initialize message list if p_init_msg_list is set to TRUE.
743: IF fnd_api.to_boolean (p_init_msg_list)
744: THEN
745: fnd_msg_pub.initialize;
746: END IF;
747:

Line 749: x_return_status := fnd_api.g_ret_sts_success;

745: fnd_msg_pub.initialize;
746: END IF;
747:
748: -- Initialize API return status to success
749: x_return_status := fnd_api.g_ret_sts_success;
750:
751: -- API body
752: -- Get payrun information
753: BEGIN

Line 769: RAISE fnd_api.g_exc_error;

765: fnd_message.set_name ('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
766: fnd_msg_pub.ADD;
767: END IF;
768:
769: RAISE fnd_api.g_exc_error;
770: END;
771:
772: BEGIN
773: -- lock payrun for update

Line 797: RAISE fnd_api.g_exc_error;

793: IF err_num = -54
794: THEN
795: fnd_message.set_name ('CN', 'CN_INVALID_OBJECT_VERSION');
796: fnd_msg_pub.ADD;
797: RAISE fnd_api.g_exc_error;
798: ELSE
799: RAISE;
800: END IF;
801: END;

Line 810: RAISE FND_API.G_EXC_ERROR ;

806: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
807: FND_MESSAGE.SET_NAME ('CN','CN_PAYRUN_NOT_SU');
808: FND_MSG_PUB.Add;
809: END IF;
810: RAISE FND_API.G_EXC_ERROR ;
811: END IF;
812: */
813:
814: -- cannot perform action on paid payrun

Line 823: RAISE fnd_api.g_exc_error;

819: fnd_message.set_name ('CN', 'CN_PAYRUN_PAID');
820: fnd_msg_pub.ADD;
821: END IF;
822:
823: RAISE fnd_api.g_exc_error;
824: END IF;
825:
826: -- should never perform any payrun action when one of the worksheets is processing
827: SELECT COUNT(1)

Line 840: RAISE fnd_api.g_exc_error;

836: THEN
837: fnd_message.set_name ('CN', 'CN_WKSHT_STILL_PROCESSING');
838: fnd_msg_pub.ADD;
839: END IF;
840: RAISE fnd_api.g_exc_error;
841: END IF;
842:
843: -- Check for each action
844: -- p_action = 'REFRESH' OR 'REMOVE' OR 'FREEZE'

Line 854: RAISE fnd_api.g_exc_error;

850: l_has_access := get_security_access (g_type_payrun, g_access_payrun_refresh);
851:
852: IF (l_has_access = FALSE)
853: THEN
854: RAISE fnd_api.g_exc_error;
855: END IF;
856: ELSIF p_action = 'REMOVE'
857: THEN
858: l_has_access := get_security_access (g_type_payrun, g_access_payrun_delete);

Line 862: RAISE fnd_api.g_exc_error;

858: l_has_access := get_security_access (g_type_payrun, g_access_payrun_delete);
859:
860: IF (l_has_access = FALSE)
861: THEN
862: RAISE fnd_api.g_exc_error;
863: END IF;
864: ELSIF p_action = 'FREEZE'
865: THEN
866: l_has_access := get_security_access (g_type_payrun, g_access_payrun_freeze);

Line 870: RAISE fnd_api.g_exc_error;

866: l_has_access := get_security_access (g_type_payrun, g_access_payrun_freeze);
867:
868: IF (l_has_access = FALSE)
869: THEN
870: RAISE fnd_api.g_exc_error;
871: END IF;
872: END IF;
873:
874: --Added for R12 payment security check end.

Line 883: RAISE fnd_api.g_exc_error;

879: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_UNPAID');
880: fnd_msg_pub.ADD;
881: END IF;
882:
883: RAISE fnd_api.g_exc_error;
884: END IF;
885: -- p_action = 'UNFREEZE'
886: ELSIF p_action = 'UNFREEZE'
887: THEN

Line 893: RAISE fnd_api.g_exc_error;

889: l_has_access := get_security_access (g_type_payrun, g_access_payrun_unfreeze);
890:
891: IF (l_has_access = FALSE)
892: THEN
893: RAISE fnd_api.g_exc_error;
894: END IF;
895:
896: --Added for R12 payment security check end.
897: IF l_payrun_status <> 'FROZEN'

Line 905: RAISE fnd_api.g_exc_error;

901: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_UNFREEZE');
902: fnd_msg_pub.ADD;
903: END IF;
904:
905: RAISE fnd_api.g_exc_error;
906: END IF;
907: -- p_action = 'PAY'
908: ELSIF p_action = 'PAY'
909: THEN

Line 915: RAISE fnd_api.g_exc_error;

911: l_has_access := get_security_access (g_type_payrun, g_access_payrun_pay);
912:
913: IF (l_has_access = FALSE)
914: THEN
915: RAISE fnd_api.g_exc_error;
916: END IF;
917:
918: --Added for R12 payment security check end.
919: IF NVL (fnd_profile.VALUE ('CN_CHK_WKSHT_STATUS'), 'Y') = 'Y'

Line 936: RAISE fnd_api.g_exc_error;

932: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_PAY');
933: fnd_msg_pub.ADD;
934: END IF;
935:
936: RAISE fnd_api.g_exc_error;
937: EXCEPTION
938: WHEN NO_DATA_FOUND
939: THEN
940: NULL;

Line 951: RAISE fnd_api.g_exc_error;

947: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_PAY_FRZ');
948: fnd_msg_pub.ADD;
949: END IF;
950:
951: RAISE fnd_api.g_exc_error;
952: END IF;
953: END IF;
954: ELSE
955: -- invalid p_action

Line 962: RAISE fnd_api.g_exc_error;

958: fnd_message.set_name ('CN', 'CN_PAYRUN_ACTION_NOT_EXIST');
959: fnd_msg_pub.ADD;
960: END IF;
961:
962: RAISE fnd_api.g_exc_error;
963: END IF;
964:
965: IF fnd_api.to_boolean (p_do_audit)
966: THEN

Line 965: IF fnd_api.to_boolean (p_do_audit)

961:
962: RAISE fnd_api.g_exc_error;
963: END IF;
964:
965: IF fnd_api.to_boolean (p_do_audit)
966: THEN
967: -- update audit table and payrun status
968: payrun_audit (p_payrun_id => p_payrun_id,
969: p_action => p_action,

Line 975: IF x_return_status <> fnd_api.g_ret_sts_success

971: x_msg_count => x_msg_count,
972: x_msg_data => x_msg_data
973: );
974:
975: IF x_return_status <> fnd_api.g_ret_sts_success
976: THEN
977: RAISE fnd_api.g_exc_error;
978: END IF;
979: END IF;

Line 977: RAISE fnd_api.g_exc_error;

973: );
974:
975: IF x_return_status <> fnd_api.g_ret_sts_success
976: THEN
977: RAISE fnd_api.g_exc_error;
978: END IF;
979: END IF;
980:
981: -- End of API body.

Line 983: IF fnd_api.to_boolean (p_commit)

979: END IF;
980:
981: -- End of API body.
982: -- Standard check of p_commit.
983: IF fnd_api.to_boolean (p_commit)
984: THEN
985: COMMIT WORK;
986: END IF;
987:

Line 989: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

985: COMMIT WORK;
986: END IF;
987:
988: -- Standard call to get message count and if count is 1, get message info.
989: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
990: EXCEPTION
991: WHEN fnd_api.g_exc_error
992: THEN
993: ROLLBACK TO payrun_action;

Line 991: WHEN fnd_api.g_exc_error

987:
988: -- Standard call to get message count and if count is 1, get message info.
989: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
990: EXCEPTION
991: WHEN fnd_api.g_exc_error
992: THEN
993: ROLLBACK TO payrun_action;
994: x_return_status := fnd_api.g_ret_sts_error;
995: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 994: x_return_status := fnd_api.g_ret_sts_error;

990: EXCEPTION
991: WHEN fnd_api.g_exc_error
992: THEN
993: ROLLBACK TO payrun_action;
994: x_return_status := fnd_api.g_ret_sts_error;
995: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
996: WHEN fnd_api.g_exc_unexpected_error
997: THEN
998: ROLLBACK TO payrun_action;

Line 995: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

991: WHEN fnd_api.g_exc_error
992: THEN
993: ROLLBACK TO payrun_action;
994: x_return_status := fnd_api.g_ret_sts_error;
995: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
996: WHEN fnd_api.g_exc_unexpected_error
997: THEN
998: ROLLBACK TO payrun_action;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 996: WHEN fnd_api.g_exc_unexpected_error

992: THEN
993: ROLLBACK TO payrun_action;
994: x_return_status := fnd_api.g_ret_sts_error;
995: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
996: WHEN fnd_api.g_exc_unexpected_error
997: THEN
998: ROLLBACK TO payrun_action;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;
1000: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 999: x_return_status := fnd_api.g_ret_sts_unexp_error;

995: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
996: WHEN fnd_api.g_exc_unexpected_error
997: THEN
998: ROLLBACK TO payrun_action;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;
1000: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1001: WHEN OTHERS
1002: THEN
1003: ROLLBACK TO payrun_action;

Line 1000: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

996: WHEN fnd_api.g_exc_unexpected_error
997: THEN
998: ROLLBACK TO payrun_action;
999: x_return_status := fnd_api.g_ret_sts_unexp_error;
1000: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1001: WHEN OTHERS
1002: THEN
1003: ROLLBACK TO payrun_action;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1004: x_return_status := fnd_api.g_ret_sts_unexp_error;

1000: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1001: WHEN OTHERS
1002: THEN
1003: ROLLBACK TO payrun_action;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005:
1006: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1007: THEN
1008: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1011: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1007: THEN
1008: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1009: END IF;
1010:
1011: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1012: END payrun_action;
1013:
1014: -- Start of comments
1015: -- API name : Worksheet_action

Line 1022: -- Default = FND_API.G_FALSE

1018: -- Pre-reqs : None.
1019: -- Parameters :
1020: -- IN : p_api_version IN NUMBER Required
1021: -- p_init_msg_list IN VARCHAR2 Optional
1022: -- Default = FND_API.G_FALSE
1023: -- p_commit IN VARCHAR2 Optional
1024: -- Default = FND_API.G_FALSE
1025: -- p_validation_level IN NUMBER Optional
1026: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1024: -- Default = FND_API.G_FALSE

1020: -- IN : p_api_version IN NUMBER Required
1021: -- p_init_msg_list IN VARCHAR2 Optional
1022: -- Default = FND_API.G_FALSE
1023: -- p_commit IN VARCHAR2 Optional
1024: -- Default = FND_API.G_FALSE
1025: -- p_validation_level IN NUMBER Optional
1026: -- Default = FND_API.G_VALID_LEVEL_FULL
1027: -- p_worksheet_id IN NUMBER
1028: -- p_action IN VARCHAR2

Line 1026: -- Default = FND_API.G_VALID_LEVEL_FULL

1022: -- Default = FND_API.G_FALSE
1023: -- p_commit IN VARCHAR2 Optional
1024: -- Default = FND_API.G_FALSE
1025: -- p_validation_level IN NUMBER Optional
1026: -- Default = FND_API.G_VALID_LEVEL_FULL
1027: -- p_worksheet_id IN NUMBER
1028: -- p_action IN VARCHAR2
1029: -- OUT : x_return_status OUT VARCHAR2(1)
1030: -- x_msg_count OUT NUMBER

Line 1039: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1035: --
1036: -- End of comments
1037: PROCEDURE worksheet_action (
1038: p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1040: p_commit IN VARCHAR2 := fnd_api.g_false,
1041: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,

Line 1040: p_commit IN VARCHAR2 := fnd_api.g_false,

1036: -- End of comments
1037: PROCEDURE worksheet_action (
1038: p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1040: p_commit IN VARCHAR2 := fnd_api.g_false,
1041: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2,

Line 1041: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1037: PROCEDURE worksheet_action (
1038: p_api_version IN NUMBER,
1039: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1040: p_commit IN VARCHAR2 := fnd_api.g_false,
1041: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2,
1045: p_worksheet_id IN NUMBER,

Line 1047: p_do_audit IN VARCHAR2 := fnd_api.g_true

1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2,
1045: p_worksheet_id IN NUMBER,
1046: p_action IN VARCHAR2,
1047: p_do_audit IN VARCHAR2 := fnd_api.g_true
1048: )
1049: IS
1050: l_api_name CONSTANT VARCHAR2 (30) := 'Worksheet_action';
1051: l_api_version CONSTANT NUMBER := 1.0;

Line 1089: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

1085: -- Standard Start of API savepoint
1086: SAVEPOINT worksheet_action;
1087:
1088: -- Standard call to check for call compatibility.
1089: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1090: THEN
1091: RAISE fnd_api.g_exc_unexpected_error;
1092: END IF;
1093:

Line 1091: RAISE fnd_api.g_exc_unexpected_error;

1087:
1088: -- Standard call to check for call compatibility.
1089: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1090: THEN
1091: RAISE fnd_api.g_exc_unexpected_error;
1092: END IF;
1093:
1094: -- Initialize message list if p_init_msg_list is set to TRUE.
1095: IF fnd_api.to_boolean (p_init_msg_list)

Line 1095: IF fnd_api.to_boolean (p_init_msg_list)

1091: RAISE fnd_api.g_exc_unexpected_error;
1092: END IF;
1093:
1094: -- Initialize message list if p_init_msg_list is set to TRUE.
1095: IF fnd_api.to_boolean (p_init_msg_list)
1096: THEN
1097: fnd_msg_pub.initialize;
1098: END IF;
1099:

Line 1101: x_return_status := fnd_api.g_ret_sts_success;

1097: fnd_msg_pub.initialize;
1098: END IF;
1099:
1100: -- Initialize API return status to success
1101: x_return_status := fnd_api.g_ret_sts_success;
1102:
1103: -- API body
1104: -- Get worksheet information
1105: BEGIN

Line 1138: RAISE fnd_api.g_exc_error;

1134: fnd_message.set_name ('CN', 'CN_WKSHT_DOES_NOT_EXIST');
1135: fnd_msg_pub.ADD;
1136: END IF;
1137:
1138: RAISE fnd_api.g_exc_error;
1139: END;
1140:
1141: BEGIN
1142: -- lock payrun for preventing update while updating wksht

Line 1166: RAISE fnd_api.g_exc_error;

1162: IF err_num = -54
1163: THEN
1164: fnd_message.set_name ('CN', 'CN_INVALID_OBJECT_VERSION');
1165: fnd_msg_pub.ADD;
1166: RAISE fnd_api.g_exc_error;
1167: ELSE
1168: RAISE;
1169: END IF;
1170: END;

Line 1181: RAISE fnd_api.g_exc_error;

1177: fnd_message.set_name ('CN', 'CN_PAYRUN_PAID');
1178: fnd_msg_pub.ADD;
1179: END IF;
1180:
1181: RAISE fnd_api.g_exc_error;
1182: END IF;
1183:
1184: -- Get login user resource_id
1185: l_resource_id := NULL;

Line 1198: RAISE fnd_api.g_exc_error;

1194: THEN
1195: -- resource not exist for this user
1196: fnd_message.set_name ('CN', 'CN_USER_RESOURCE_NF');
1197: fnd_msg_pub.ADD;
1198: RAISE fnd_api.g_exc_error;
1199: END;
1200:
1201: -- check if user can access this worksheet when
1202: -- l_assigned_to_user_id is not null

Line 1258: RAISE fnd_api.g_exc_error;

1254: fnd_message.set_name ('CN', 'CN_NO_SRP_ACCESS');
1255: fnd_msg_pub.ADD;
1256: END IF;
1257:
1258: RAISE fnd_api.g_exc_error;
1259: END;
1260:
1261: NULL;
1262: END IF; -- Bug 3498950

Line 1276: RAISE fnd_api.g_exc_error;

1272: l_has_access := get_security_access (g_type_wksht, g_access_wksht_refresh);
1273:
1274: IF (l_has_access = FALSE)
1275: THEN
1276: RAISE fnd_api.g_exc_error;
1277: END IF;
1278: ELSIF p_action = 'REMOVE'
1279: THEN
1280: l_has_access := get_security_access (g_type_wksht, g_access_wksht_delete);

Line 1284: RAISE fnd_api.g_exc_error;

1280: l_has_access := get_security_access (g_type_wksht, g_access_wksht_delete);
1281:
1282: IF (l_has_access = FALSE)
1283: THEN
1284: RAISE fnd_api.g_exc_error;
1285: END IF;
1286: ELSIF p_action = 'LOCK'
1287: THEN
1288: l_has_access := get_security_access (g_type_wksht, g_access_wksht_lock);

Line 1292: RAISE fnd_api.g_exc_error;

1288: l_has_access := get_security_access (g_type_wksht, g_access_wksht_lock);
1289:
1290: IF (l_has_access = FALSE)
1291: THEN
1292: RAISE fnd_api.g_exc_error;
1293: END IF;
1294: ELSIF p_action = 'RELEASE_HOLD'
1295: THEN
1296: l_has_access := get_security_access (g_type_wksht, g_access_wksht_release_holds);

Line 1300: RAISE fnd_api.g_exc_error;

1296: l_has_access := get_security_access (g_type_wksht, g_access_wksht_release_holds);
1297:
1298: IF (l_has_access = FALSE)
1299: THEN
1300: RAISE fnd_api.g_exc_error;
1301: END IF;
1302: END IF;
1303:
1304: --Added for R12 payment security check end.

Line 1313: RAISE fnd_api.g_exc_error;

1309: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNPAID');
1310: fnd_msg_pub.ADD;
1311: END IF;
1312:
1313: RAISE fnd_api.g_exc_error;
1314: END IF;
1315: ELSIF p_action IN ( 'HOLD_ALL' , 'RELEASE_ALL' )
1316: THEN
1317: l_has_access := get_security_access (g_type_wksht, g_access_wksht_release_holds);

Line 1321: RAISE fnd_api.g_exc_error;

1317: l_has_access := get_security_access (g_type_wksht, g_access_wksht_release_holds);
1318:
1319: IF (l_has_access = FALSE)
1320: THEN
1321: RAISE fnd_api.g_exc_error;
1322: END IF;
1323:
1324: --Added for R12 payment security check end.
1325: IF l_payrun_status <> 'UNPAID' OR l_worksheet_rec.worksheet_status NOT IN ('PROCESSING', 'UNPAID')

Line 1333: RAISE fnd_api.g_exc_error;

1329: fnd_message.set_name ('CN', 'CN_WKSHT_NOT_PROCESSING');
1330: fnd_msg_pub.ADD;
1331: END IF;
1332:
1333: RAISE fnd_api.g_exc_error;
1334: END IF;
1335:
1336: ELSIF p_action IN ( 'RESET_TO_UNPAID' )
1337: THEN

Line 1342: RAISE fnd_api.g_exc_error;

1338: l_has_access := get_security_access (g_type_wksht, g_access_wksht_release_holds);
1339:
1340: IF (l_has_access = FALSE)
1341: THEN
1342: RAISE fnd_api.g_exc_error;
1343: END IF;
1344:
1345: --Added for R12 payment security check end.
1346: IF l_payrun_status <> 'UNPAID' OR (l_worksheet_rec.worksheet_status NOT IN ('PROCESSING','FAILED'))

Line 1354: RAISE fnd_api.g_exc_error;

1350: fnd_message.set_name ('CN', 'CN_WKSHT_NOT_PROCESSING');
1351: fnd_msg_pub.ADD;
1352: END IF;
1353:
1354: RAISE fnd_api.g_exc_error;
1355: END IF;
1356:
1357: -- p_action = 'UNLOCK'
1358: ELSIF p_action = 'UNLOCK'

Line 1365: RAISE fnd_api.g_exc_error;

1361: l_has_access := get_security_access (g_type_wksht, g_access_wksht_unlock);
1362:
1363: IF (l_has_access = FALSE)
1364: THEN
1365: RAISE fnd_api.g_exc_error;
1366: END IF;
1367:
1368: --Added for R12 payment security check end.
1369: IF l_payrun_status <> 'UNPAID' OR l_worksheet_rec.worksheet_status <> 'LOCKED'

Line 1377: RAISE fnd_api.g_exc_error;

1373: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_UNLOCK');
1374: fnd_msg_pub.ADD;
1375: END IF;
1376:
1377: RAISE fnd_api.g_exc_error;
1378: END IF;
1379: -- p_action = 'SUBMIT'
1380: ELSIF p_action = 'SUBMIT'
1381: THEN

Line 1387: RAISE fnd_api.g_exc_error;

1383: l_has_access := get_security_access (g_type_wksht, g_access_wksht_submit);
1384:
1385: IF (l_has_access = FALSE)
1386: THEN
1387: RAISE fnd_api.g_exc_error;
1388: END IF;
1389:
1390: --Added for R12 payment security check end.
1391: IF l_worksheet_rec.worksheet_status <> 'LOCKED'

Line 1399: RAISE fnd_api.g_exc_error;

1395: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_SUBMIT');
1396: fnd_msg_pub.ADD;
1397: END IF;
1398:
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: ELSIF p_action = 'REJECT' OR p_action = 'APPROVE'
1403: THEN

Line 1411: RAISE fnd_api.g_exc_error;

1407: l_has_access := get_security_access (g_type_wksht, g_access_wksht_reject);
1408:
1409: IF (l_has_access = FALSE)
1410: THEN
1411: RAISE fnd_api.g_exc_error;
1412: END IF;
1413: ELSIF p_action = 'APPROVE'
1414: THEN
1415: l_has_access := get_security_access (g_type_wksht, g_access_wksht_approve);

Line 1419: RAISE fnd_api.g_exc_error;

1415: l_has_access := get_security_access (g_type_wksht, g_access_wksht_approve);
1416:
1417: IF (l_has_access = FALSE)
1418: THEN
1419: RAISE fnd_api.g_exc_error;
1420: END IF;
1421: END IF;
1422:
1423: --Added for R12 payment security check end.

Line 1433: RAISE fnd_api.g_exc_error;

1429: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_APPROVE');
1430: fnd_msg_pub.ADD;
1431: END IF;
1432:
1433: RAISE fnd_api.g_exc_error;
1434: END IF;
1435:
1436: -- only manager or superuser can perform submit and approve
1437: -- Check if user is manager

Line 1444: RAISE FND_API.G_EXC_ERROR ;

1440: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1441: FND_MESSAGE.SET_NAME ('CN','CN_WKSHT_NOT_MGR');
1442: FND_MSG_PUB.Add;
1443: END IF;
1444: RAISE FND_API.G_EXC_ERROR ;
1445: END IF;
1446: */
1447:
1448: -- l_assigned_to_user_id is null

Line 1508: RAISE fnd_api.g_exc_error;

1504: fnd_message.set_name ('CN', 'CN_NO_SRP_ACCESS');
1505: fnd_msg_pub.ADD;
1506: END IF;
1507:
1508: RAISE fnd_api.g_exc_error;
1509: END;
1510: END IF; -- Bug 3498950
1511: END IF;
1512:

Line 1521: RAISE fnd_api.g_exc_error;

1517: l_has_access := get_security_access (g_type_wksht, g_access_wksht_approve);
1518:
1519: IF (l_has_access = FALSE)
1520: THEN
1521: RAISE fnd_api.g_exc_error;
1522: END IF;
1523:
1524: --Added for R12 payment security check end.
1525: SELECT COUNT (1)

Line 1539: RAISE fnd_api.g_exc_error;

1535: fnd_message.set_name ('CN', 'CN_SAME_USER_APPROVE');
1536: fnd_msg_pub.ADD;
1537: END IF;
1538:
1539: RAISE fnd_api.g_exc_error;
1540: END IF;
1541: END IF;
1542:
1543: ELSE

Line 1551: RAISE fnd_api.g_exc_error;

1547: fnd_message.set_name ('CN', 'CN_WKSHT_ACTION_NOT_EXIST');
1548: fnd_msg_pub.ADD;
1549: END IF;
1550:
1551: RAISE fnd_api.g_exc_error;
1552: END IF;
1553:
1554: IF fnd_api.to_boolean (p_do_audit)
1555: THEN

Line 1554: IF fnd_api.to_boolean (p_do_audit)

1550:
1551: RAISE fnd_api.g_exc_error;
1552: END IF;
1553:
1554: IF fnd_api.to_boolean (p_do_audit)
1555: THEN
1556: -- update audit table and worksheet status
1557: worksheet_audit (p_worksheet_id => p_worksheet_id,
1558: p_payrun_id => l_worksheet_rec.payrun_id,

Line 1566: IF x_return_status <> fnd_api.g_ret_sts_success

1562: x_msg_count => x_msg_count,
1563: x_msg_data => x_msg_data
1564: );
1565:
1566: IF x_return_status <> fnd_api.g_ret_sts_success
1567: THEN
1568: RAISE fnd_api.g_exc_error;
1569: END IF;
1570: END IF;

Line 1568: RAISE fnd_api.g_exc_error;

1564: );
1565:
1566: IF x_return_status <> fnd_api.g_ret_sts_success
1567: THEN
1568: RAISE fnd_api.g_exc_error;
1569: END IF;
1570: END IF;
1571:
1572: -- End of API body.

Line 1574: IF fnd_api.to_boolean (p_commit)

1570: END IF;
1571:
1572: -- End of API body.
1573: -- Standard check of p_commit.
1574: IF fnd_api.to_boolean (p_commit)
1575: THEN
1576: COMMIT WORK;
1577: END IF;
1578:

Line 1580: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1576: COMMIT WORK;
1577: END IF;
1578:
1579: -- Standard call to get message count and if count is 1, get message info.
1580: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1581: EXCEPTION
1582: WHEN fnd_api.g_exc_error
1583: THEN
1584: ROLLBACK TO worksheet_action;

Line 1582: WHEN fnd_api.g_exc_error

1578:
1579: -- Standard call to get message count and if count is 1, get message info.
1580: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1581: EXCEPTION
1582: WHEN fnd_api.g_exc_error
1583: THEN
1584: ROLLBACK TO worksheet_action;
1585: x_return_status := fnd_api.g_ret_sts_error;
1586: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1585: x_return_status := fnd_api.g_ret_sts_error;

1581: EXCEPTION
1582: WHEN fnd_api.g_exc_error
1583: THEN
1584: ROLLBACK TO worksheet_action;
1585: x_return_status := fnd_api.g_ret_sts_error;
1586: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1587: WHEN fnd_api.g_exc_unexpected_error
1588: THEN
1589: ROLLBACK TO worksheet_action;

Line 1586: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1582: WHEN fnd_api.g_exc_error
1583: THEN
1584: ROLLBACK TO worksheet_action;
1585: x_return_status := fnd_api.g_ret_sts_error;
1586: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1587: WHEN fnd_api.g_exc_unexpected_error
1588: THEN
1589: ROLLBACK TO worksheet_action;
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1587: WHEN fnd_api.g_exc_unexpected_error

1583: THEN
1584: ROLLBACK TO worksheet_action;
1585: x_return_status := fnd_api.g_ret_sts_error;
1586: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1587: WHEN fnd_api.g_exc_unexpected_error
1588: THEN
1589: ROLLBACK TO worksheet_action;
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 1590: x_return_status := fnd_api.g_ret_sts_unexp_error;

1586: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1587: WHEN fnd_api.g_exc_unexpected_error
1588: THEN
1589: ROLLBACK TO worksheet_action;
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1592: WHEN OTHERS
1593: THEN
1594: ROLLBACK TO worksheet_action;

Line 1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1587: WHEN fnd_api.g_exc_unexpected_error
1588: THEN
1589: ROLLBACK TO worksheet_action;
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1592: WHEN OTHERS
1593: THEN
1594: ROLLBACK TO worksheet_action;
1595: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1595: x_return_status := fnd_api.g_ret_sts_unexp_error;

1591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1592: WHEN OTHERS
1593: THEN
1594: ROLLBACK TO worksheet_action;
1595: x_return_status := fnd_api.g_ret_sts_unexp_error;
1596:
1597: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1598: THEN
1599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1602: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

1598: THEN
1599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1600: END IF;
1601:
1602: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1603: END worksheet_action;
1604:
1605: --R12 payment security
1606: FUNCTION get_security_access (