79: SUBSTRB(SQLERRM,1,2000);
80: IF g_debug THEN
81: debug(l_message);
82: END IF;
83: fnd_message.set_name( 'PQP', 'PQP_230661_OSP_DUMMY_MSG' );
84: fnd_message.set_token( 'TOKEN',l_message);
85: END debug_others;
86: --
87:
80: IF g_debug THEN
81: debug(l_message);
82: END IF;
83: fnd_message.set_name( 'PQP', 'PQP_230661_OSP_DUMMY_MSG' );
84: fnd_message.set_token( 'TOKEN',l_message);
85: END debug_others;
86: --
87:
88:
127: WHEN OTHERS THEN
128: debug('No Value',20);
129: p_error_code:=-1;
130: p_message:=SUBSTR(SQLERRM,0,2000);
131: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
132: fnd_message.set_token('TOKEN', p_message);
133: RAISE;
134: debug_exit(l_proc_name) ;
135: END get_param_value ;
128: debug('No Value',20);
129: p_error_code:=-1;
130: p_message:=SUBSTR(SQLERRM,0,2000);
131: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
132: fnd_message.set_token('TOKEN', p_message);
133: RAISE;
134: debug_exit(l_proc_name) ;
135: END get_param_value ;
136:
291: EXCEPTION
292: WHEN VALUE_ERROR
293: OR invalid_length_of_service
294: THEN
295: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
296: -- The message name PQP_230012_OSPOMP_INALID_LOS has missing "V" in INVALID
297: -- this is not corrected as the related OSP code was already arcsed in
298: -- The value of "length of service", TOKEN, passed from the standard rate is invalid.
299: -- Please check that the standard rate has been setup correctly and that atleast
297: -- this is not corrected as the related OSP code was already arcsed in
298: -- The value of "length of service", TOKEN, passed from the standard rate is invalid.
299: -- Please check that the standard rate has been setup correctly and that atleast
300: -- one formula output is named exactly LENGTH_OF_SERVICE.
301: fnd_message.set_token( 'LOSVALUE', NVL(l_value,'
303:
304: END;
305:
298: -- The value of "length of service", TOKEN, passed from the standard rate is invalid.
299: -- Please check that the standard rate has been setup correctly and that atleast
300: -- one formula output is named exactly LENGTH_OF_SERVICE.
301: fnd_message.set_token( 'LOSVALUE', NVL(l_value,'
302: fnd_message.raise_error;
303:
304: END;
305:
306:
528: debug('Leaving: '||l_proc_name,-999);
529: END IF;
530: -- p_message := SQLERRM;
531: -- p_error_code := -1;
532: fnd_message.raise_error;
533: ELSE
534: RAISE;
535: END IF;
536:
596: debug('INTEND_TO_RETURN_FLAG:'||l_intend_to_return) ;
597: END IF ;
598:
599: IF p_message IS NOT NULL THEN
600: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
601: fnd_message.set_token('TOKEN', p_message);
602: fnd_message.raise_error;
603: END IF;
604:
597: END IF ;
598:
599: IF p_message IS NOT NULL THEN
600: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
601: fnd_message.set_token('TOKEN', p_message);
602: fnd_message.raise_error;
603: END IF;
604:
605:
598:
599: IF p_message IS NOT NULL THEN
600: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
601: fnd_message.set_token('TOKEN', p_message);
602: fnd_message.raise_error;
603: END IF;
604:
605:
606: -- This function gets all the avialable Bands and the
625: debug(l_proc_name,20);
626: END IF ;
627:
628: IF p_message IS NOT NULL THEN
629: fnd_message.set_name('PQP', 'PQP_230603_DEF_BAND1');
630: fnd_message.raise_error;
631: END IF;
632:
633: FOR i in 1..p_entitlements.COUNT
626: END IF ;
627:
628: IF p_message IS NOT NULL THEN
629: fnd_message.set_name('PQP', 'PQP_230603_DEF_BAND1');
630: fnd_message.raise_error;
631: END IF;
632:
633: FOR i in 1..p_entitlements.COUNT
634: LOOP
698: debug('Leaving: '||l_proc_name,-999);
699: END IF;
700: -- p_message := SQLERRM;
701: -- p_error_code := -1;
702: fnd_message.raise_error;
703: ELSE
704: RAISE;
705: END IF;
706:
846: IF g_debug THEN
847: debug('Leaving: '||l_proc_name,-999);
848: END IF;
849: p_absences_taken_to_Date := l_absences_taken_to_date_nc ;
850: fnd_message.raise_error;
851: ELSE
852: RAISE;
853: END IF;
854:
967: EXCEPTION
968: ---------
969: WHEN e_novalue THEN
970: debug('No Value in the Table' ,30);
971: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
972: fnd_message.set_token('TOKEN', 'No Value in Entitlement Balance Cache');
973: RAISE;
974: WHEN OTHERS THEN
975: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
968: ---------
969: WHEN e_novalue THEN
970: debug('No Value in the Table' ,30);
971: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
972: fnd_message.set_token('TOKEN', 'No Value in Entitlement Balance Cache');
973: RAISE;
974: WHEN OTHERS THEN
975: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
976: debug_others
981: debug('Leaving: '||l_proc_name,-999);
982: END IF;
983: -- p_message := SQLERRM;
984: -- p_error_code := -1;
985: fnd_message.raise_error;
986: ELSE
987: RAISE;
988: END IF;
989:
1204: EXCEPTION
1205: --------
1206: WHEN e_novalue THEN
1207: p_error_code:=-1;
1208: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1209: fnd_message.set_token('TOKEN', 'No Value in Plan Extra Info');
1210: debug_exit(l_proc_name) ;
1211: RAISE;
1212: WHEN OTHERS THEN
1205: --------
1206: WHEN e_novalue THEN
1207: p_error_code:=-1;
1208: fnd_message.set_name('PQP', 'PQP_230661_OSP_DUMMY_MSG');
1209: fnd_message.set_token('TOKEN', 'No Value in Plan Extra Info');
1210: debug_exit(l_proc_name) ;
1211: RAISE;
1212: WHEN OTHERS THEN
1213: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1219: debug('Leaving: '||l_proc_name,-999);
1220: END IF;
1221: -- p_message := SQLERRM;
1222: -- p_error_code := -1;
1223: fnd_message.raise_error;
1224: ELSE
1225: RAISE;
1226: END IF;
1227: END get_plan_extra_info_n_cache_it ;
1418: );
1419: IF g_debug THEN
1420: debug('Leaving: '||l_proc_name,-999);
1421: END IF;
1422: fnd_message.raise_error;
1423: ELSE
1424: RAISE;
1425: END IF;
1426:
1529: );
1530: IF g_debug THEN
1531: debug('Leaving: '||l_proc_name,-999);
1532: END IF;
1533: fnd_message.raise_error;
1534: ELSE
1535: RAISE;
1536: END IF;
1537: