DBA Data[Home] [Help]

APPS.HXT_TIMECARD_API dependencies on FND_MESSAGE

Line 110: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF');

106: WHEN assignment_not_found THEN
107: if g_debug then
108: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',40);
109: end if;
110: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF');
111: --HXT11iiFND_MESSAGE.SET_TOKEN('EMP_NUMBER',i_employee_number);
112: FND_MESSAGE.SET_TOKEN('EMP_NUMBER',l_assignment_number);
113: l_display_error := FND_MESSAGE.GET;
114: l_oracle_error := SQLERRM;

Line 111: --HXT11iiFND_MESSAGE.SET_TOKEN('EMP_NUMBER',i_employee_number);

107: if g_debug then
108: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',40);
109: end if;
110: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF');
111: --HXT11iiFND_MESSAGE.SET_TOKEN('EMP_NUMBER',i_employee_number);
112: FND_MESSAGE.SET_TOKEN('EMP_NUMBER',l_assignment_number);
113: l_display_error := FND_MESSAGE.GET;
114: l_oracle_error := SQLERRM;
115: HXT_UTIL.DEBUG(l_display_error);

Line 112: FND_MESSAGE.SET_TOKEN('EMP_NUMBER',l_assignment_number);

108: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',40);
109: end if;
110: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF');
111: --HXT11iiFND_MESSAGE.SET_TOKEN('EMP_NUMBER',i_employee_number);
112: FND_MESSAGE.SET_TOKEN('EMP_NUMBER',l_assignment_number);
113: l_display_error := FND_MESSAGE.GET;
114: l_oracle_error := SQLERRM;
115: HXT_UTIL.DEBUG(l_display_error);
116: HXT_UTIL.DEBUG(l_oracle_error);

Line 113: l_display_error := FND_MESSAGE.GET;

109: end if;
110: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF');
111: --HXT11iiFND_MESSAGE.SET_TOKEN('EMP_NUMBER',i_employee_number);
112: FND_MESSAGE.SET_TOKEN('EMP_NUMBER',l_assignment_number);
113: l_display_error := FND_MESSAGE.GET;
114: l_oracle_error := SQLERRM;
115: HXT_UTIL.DEBUG(l_display_error);
116: HXT_UTIL.DEBUG(l_oracle_error);
117: o_otm_error := l_display_error;

Line 124: FND_MESSAGE.SET_NAME('HXT','HXT_39511_ACCRUAL_PLAN_NF');

120: WHEN accrual_not_found THEN
121: if g_debug then
122: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',50);
123: end if;
124: FND_MESSAGE.SET_NAME('HXT','HXT_39511_ACCRUAL_PLAN_NF');
125: l_display_error := FND_MESSAGE.GET;
126: l_oracle_error := SQLERRM;
127: HXT_UTIL.DEBUG(l_display_error);
128: HXT_UTIL.DEBUG(l_oracle_error);

Line 125: l_display_error := FND_MESSAGE.GET;

121: if g_debug then
122: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',50);
123: end if;
124: FND_MESSAGE.SET_NAME('HXT','HXT_39511_ACCRUAL_PLAN_NF');
125: l_display_error := FND_MESSAGE.GET;
126: l_oracle_error := SQLERRM;
127: HXT_UTIL.DEBUG(l_display_error);
128: HXT_UTIL.DEBUG(l_oracle_error);
129: o_otm_error := l_display_error;

Line 136: FND_MESSAGE.SET_NAME('HXT','HXT_39512_OTH_OAB_ERROR');

132: WHEN OTHERS THEN
133: if g_debug then
134: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',60);
135: end if;
136: FND_MESSAGE.SET_NAME('HXT','HXT_39512_OTH_OAB_ERROR');
137: l_display_error := FND_MESSAGE.GET;
138: l_oracle_error := SQLERRM;
139: HXT_UTIL.DEBUG(l_display_error);
140: HXT_UTIL.DEBUG(l_oracle_error);

Line 137: l_display_error := FND_MESSAGE.GET;

133: if g_debug then
134: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',60);
135: end if;
136: FND_MESSAGE.SET_NAME('HXT','HXT_39512_OTH_OAB_ERROR');
137: l_display_error := FND_MESSAGE.GET;
138: l_oracle_error := SQLERRM;
139: HXT_UTIL.DEBUG(l_display_error);
140: HXT_UTIL.DEBUG(l_oracle_error);
141: o_otm_error := l_display_error;

Line 266: FND_MESSAGE.SET_NAME('HXT','HXT_39513_OTH_APN_ERROR');

262: WHEN others THEN
263: if g_debug then
264: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',50);
265: end if;
266: FND_MESSAGE.SET_NAME('HXT','HXT_39513_OTH_APN_ERROR');
267: l_display_error := FND_MESSAGE.GET;
268: l_oracle_error := SQLERRM;
269: HXT_UTIL.DEBUG(l_display_error);
270: HXT_UTIL.DEBUG(l_oracle_error);

Line 267: l_display_error := FND_MESSAGE.GET;

263: if g_debug then
264: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',50);
265: end if;
266: FND_MESSAGE.SET_NAME('HXT','HXT_39513_OTH_APN_ERROR');
267: l_display_error := FND_MESSAGE.GET;
268: l_oracle_error := SQLERRM;
269: HXT_UTIL.DEBUG(l_display_error);
270: HXT_UTIL.DEBUG(l_oracle_error);
271: o_otm_error := l_display_error;

Line 644: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');

640: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70.1);
641: end if;
642:
643: -- CREATE AND ADD THE MESSAGE
644: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
645: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
646: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
647:
648: l_display_error := FND_MESSAGE.GET;

Line 645: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);

641: end if;
642:
643: -- CREATE AND ADD THE MESSAGE
644: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
645: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
646: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
647:
648: l_display_error := FND_MESSAGE.GET;
649: else

Line 646: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));

642:
643: -- CREATE AND ADD THE MESSAGE
644: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
645: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
646: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
647:
648: l_display_error := FND_MESSAGE.GET;
649: else
650: -- IF A MESSAGE HAS BEEN ALREADY ADDED FOR AN ACCRUAL PLAN, DO NOT ADD IT

Line 648: l_display_error := FND_MESSAGE.GET;

644: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
645: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
646: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
647:
648: l_display_error := FND_MESSAGE.GET;
649: else
650: -- IF A MESSAGE HAS BEEN ALREADY ADDED FOR AN ACCRUAL PLAN, DO NOT ADD IT
651: if(instr(l_display_error, l_accrual_plan_name) = 0) then
652: if g_debug then

Line 655: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');

651: if(instr(l_display_error, l_accrual_plan_name) = 0) then
652: if g_debug then
653: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70.2);
654: end if;
655: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
656: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
657: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
658: --ADD MESSAGE WITH A NEW LINE
659: l_display_error := l_display_error ||'

Line 656: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);

652: if g_debug then
653: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70.2);
654: end if;
655: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
656: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
657: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
658: --ADD MESSAGE WITH A NEW LINE
659: l_display_error := l_display_error ||'
660: '|| FND_MESSAGE.GET;

Line 657: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));

653: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70.2);
654: end if;
655: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
656: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
657: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
658: --ADD MESSAGE WITH A NEW LINE
659: l_display_error := l_display_error ||'
660: '|| FND_MESSAGE.GET;
661: end if;

Line 660: '|| FND_MESSAGE.GET;

656: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
657: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
658: --ADD MESSAGE WITH A NEW LINE
659: l_display_error := l_display_error ||'
660: '|| FND_MESSAGE.GET;
661: end if;
662: end if;
663:
664: l_flag_acc_exceeded := 1;

Line 702: FND_MESSAGE.SET_NAME('HXT','HXT_39514_NO_TIMECARD_ROWS');

698: WHEN no_summary_rows THEN
699: if g_debug then
700: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',80);
701: end if;
702: FND_MESSAGE.SET_NAME('HXT','HXT_39514_NO_TIMECARD_ROWS');
703: l_display_error := FND_MESSAGE.GET;
704: HXT_UTIL.DEBUG(l_display_error);
705: o_otm_error := l_display_error;
706: o_oracle_error := NULL;

Line 703: l_display_error := FND_MESSAGE.GET;

699: if g_debug then
700: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',80);
701: end if;
702: FND_MESSAGE.SET_NAME('HXT','HXT_39514_NO_TIMECARD_ROWS');
703: l_display_error := FND_MESSAGE.GET;
704: HXT_UTIL.DEBUG(l_display_error);
705: o_otm_error := l_display_error;
706: o_oracle_error := NULL;
707: o_return_code := 1;

Line 715: -- FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');

711: WHEN accrual_exceeded THEN
712: if g_debug then
713: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',90);
714: end if;
715: -- FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
716: -- FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
717: -- FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
718: -- l_display_error := FND_MESSAGE.GET;
719: HXT_UTIL.DEBUG(l_display_error);

Line 716: -- FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);

712: if g_debug then
713: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',90);
714: end if;
715: -- FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
716: -- FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
717: -- FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
718: -- l_display_error := FND_MESSAGE.GET;
719: HXT_UTIL.DEBUG(l_display_error);
720: o_otm_error := l_display_error;

Line 717: -- FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));

713: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',90);
714: end if;
715: -- FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
716: -- FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
717: -- FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
718: -- l_display_error := FND_MESSAGE.GET;
719: HXT_UTIL.DEBUG(l_display_error);
720: o_otm_error := l_display_error;
721: o_oracle_error := NULL;

Line 718: -- l_display_error := FND_MESSAGE.GET;

714: end if;
715: -- FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
716: -- FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
717: -- FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
718: -- l_display_error := FND_MESSAGE.GET;
719: HXT_UTIL.DEBUG(l_display_error);
720: o_otm_error := l_display_error;
721: o_oracle_error := NULL;
722: o_accrual_plan_name := l_accrual_plan_name;

Line 731: FND_MESSAGE.SET_NAME('HXT','HXT_39515_TAFW_OAB_ERROR');

727: WHEN obtain_error THEN
728: if g_debug then
729: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',100);
730: end if;
731: FND_MESSAGE.SET_NAME('HXT','HXT_39515_TAFW_OAB_ERROR');
732: l_display_error := FND_MESSAGE.GET || ' ' || v_otm_error;
733: l_oracle_error := v_oracle_error;
734: HXT_UTIL.DEBUG(l_display_error);
735: HXT_UTIL.DEBUG(l_oracle_error);

Line 732: l_display_error := FND_MESSAGE.GET || ' ' || v_otm_error;

728: if g_debug then
729: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',100);
730: end if;
731: FND_MESSAGE.SET_NAME('HXT','HXT_39515_TAFW_OAB_ERROR');
732: l_display_error := FND_MESSAGE.GET || ' ' || v_otm_error;
733: l_oracle_error := v_oracle_error;
734: HXT_UTIL.DEBUG(l_display_error);
735: HXT_UTIL.DEBUG(l_oracle_error);
736: o_otm_error := l_display_error;

Line 746: FND_MESSAGE.SET_NAME('HXT','HXT_39516_OTH_TAFW_ERROR');

742: WHEN others THEN
743: if g_debug then
744: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',110);
745: end if;
746: FND_MESSAGE.SET_NAME('HXT','HXT_39516_OTH_TAFW_ERROR');
747: l_display_error := FND_MESSAGE.GET;
748: l_oracle_error := SQLERRM;
749: HXT_UTIL.DEBUG(l_display_error);
750: HXT_UTIL.DEBUG(l_oracle_error);

Line 747: l_display_error := FND_MESSAGE.GET;

743: if g_debug then
744: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',110);
745: end if;
746: FND_MESSAGE.SET_NAME('HXT','HXT_39516_OTH_TAFW_ERROR');
747: l_display_error := FND_MESSAGE.GET;
748: l_oracle_error := SQLERRM;
749: HXT_UTIL.DEBUG(l_display_error);
750: HXT_UTIL.DEBUG(l_oracle_error);
751: o_otm_error := l_display_error;