DBA Data[Home] [Help]

APPS.ARH_CLASSIFICATION_PKG dependencies on ARH_CLASSIFICATION_PKG

Line 1: PACKAGE BODY ARH_CLASSIFICATION_PKG AS

1: PACKAGE BODY ARH_CLASSIFICATION_PKG AS
2: /*$Header: ARCLAASB.pls 115.4 2002/12/30 18:21:38 hyu noship $*/
3:
4: -----------------------------------
5: -- Local procedure and functions --

Line 517: lyn := arh_classification_pkg.assig_after_this_date

513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514:
515: /*
516: -- We allow user to create code assignment prior a start date of another one
517: lyn := arh_classification_pkg.assig_after_this_date
518: (p_owner_table_name,
519: p_owner_table_id,
520: p_class_category,
521: p_class_code,

Line 531: lyn := arh_classification_pkg.exist_overlap_assignment

527: RAISE lexception;
528: END IF;
529: */
530:
531: lyn := arh_classification_pkg.exist_overlap_assignment
532: (p_owner_table_name,
533: p_owner_table_id,
534: p_class_category,
535: p_class_code,

Line 597: ('EXCEPTION lexception: arh_classification_pkg.Create_Code_assignment'||x_msg_data);

593: END LOOP;
594: x_msg_data := tmp_var1;
595: END IF;
596: arp_standard.debug
597: ('EXCEPTION lexception: arh_classification_pkg.Create_Code_assignment'||x_msg_data);
598:
599: WHEN OTHERS THEN
600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
601: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

Line 609: ('EXCEPTION: arh_classification_pkg.Create_Code_assignment'||x_msg_data);

605: p_encoded => FND_API.G_FALSE,
606: p_count => x_msg_count,
607: p_data => x_msg_data );
608: arp_standard.debug
609: ('EXCEPTION: arh_classification_pkg.Create_Code_assignment'||x_msg_data);
610: END;
611:
612: /*------------------------------------------------------+
613: | Name : Update_Code_assignment |

Line 696: lyn := arh_classification_pkg.exist_overlap_assignment

692: END IF;
693: CLOSE cu_code_assig;
694:
695:
696: lyn := arh_classification_pkg.exist_overlap_assignment
697: (NULL,
698: NULL,
699: NULL,
700: NULL,

Line 750: arp_standard.debug('Exception arh_classification_pkg.update_code_assignment:'||x_msg_data);

746: tmp_var1 := tmp_var1 || ' '|| tmp_var;
747: END LOOP;
748: x_msg_data := tmp_var1;
749: END IF;
750: arp_standard.debug('Exception arh_classification_pkg.update_code_assignment:'||x_msg_data);
751:
752: WHEN tca_Exception THEN
753: IF x_msg_count > 1 THEN
754: FOR i IN 1..x_msg_count LOOP

Line 760: arp_standard.debug('Exception arh_classification_pkg.update_code_assignment:'||x_msg_data);

756: tmp_var1 := tmp_var1 || ' '|| tmp_var;
757: END LOOP;
758: x_msg_data := tmp_var1;
759: END IF;
760: arp_standard.debug('Exception arh_classification_pkg.update_code_assignment:'||x_msg_data);
761:
762: WHEN OTHERS THEN
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

Line 778: arp_standard.debug('OTHER Exception arh_classification_pkg.update_code_assignment:'||

774: tmp_var1 := tmp_var1 || ' '|| tmp_var;
775: END LOOP;
776: x_msg_data := tmp_var1;
777: END IF;
778: arp_standard.debug('OTHER Exception arh_classification_pkg.update_code_assignment:'||
779: x_msg_data);
780:
781: END;
782:

Line 829: END arh_classification_pkg;

825: RETURN lyn;
826: END;
827:
828:
829: END arh_classification_pkg;