DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on HR_UTILITY

Line 1018: HR_UTILITY.SET_MESSAGE(800,'HR_376898_NO_DEI_DATE_REQD');

1014: DOCUMENT_TYPE_ID=P_DOCUMENT_TYPE_ID AND
1015: (P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/
1016: BEGIN
1017: IF P_ISSUED_DATE IS NULL THEN
1018: HR_UTILITY.SET_MESSAGE(800,'HR_376898_NO_DEI_DATE_REQD');
1019: hr_utility.raise_error;
1020: END IF;
1021:
1022: open csr_doc_exists;

Line 1019: hr_utility.raise_error;

1015: (P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/
1016: BEGIN
1017: IF P_ISSUED_DATE IS NULL THEN
1018: HR_UTILITY.SET_MESSAGE(800,'HR_376898_NO_DEI_DATE_REQD');
1019: hr_utility.raise_error;
1020: END IF;
1021:
1022: open csr_doc_exists;
1023: fetch csr_doc_exists into l_exists;

Line 1025: hr_utility.set_message(800,'HR_376897_NO_OVERLAP_DEI_INFO');

1021:
1022: open csr_doc_exists;
1023: fetch csr_doc_exists into l_exists;
1024: if csr_doc_exists%FOUND then
1025: hr_utility.set_message(800,'HR_376897_NO_OVERLAP_DEI_INFO');
1026: hr_utility.raise_error;
1027: end if;
1028: close csr_doc_exists;
1029:

Line 1026: hr_utility.raise_error;

1022: open csr_doc_exists;
1023: fetch csr_doc_exists into l_exists;
1024: if csr_doc_exists%FOUND then
1025: hr_utility.set_message(800,'HR_376897_NO_OVERLAP_DEI_INFO');
1026: hr_utility.raise_error;
1027: end if;
1028: close csr_doc_exists;
1029:
1030: END;

Line 1060: HR_UTILITY.SET_MESSAGE(800,'HR_376898_NO_DEI_DATE_REQD');

1056: DOCUMENT_TYPE_ID=P_DOCUMENT_TYPE_ID AND
1057: (P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/
1058: BEGIN
1059: IF P_ISSUED_DATE IS NULL THEN
1060: HR_UTILITY.SET_MESSAGE(800,'HR_376898_NO_DEI_DATE_REQD');
1061: HR_UTILITY.RAISE_ERROR;
1062: END IF;
1063:
1064: open csr_doc_exists;

Line 1061: HR_UTILITY.RAISE_ERROR;

1057: (P_DATE_FROM< DATE_TO AND P_DATE_TO > DATE_FROM );*/
1058: BEGIN
1059: IF P_ISSUED_DATE IS NULL THEN
1060: HR_UTILITY.SET_MESSAGE(800,'HR_376898_NO_DEI_DATE_REQD');
1061: HR_UTILITY.RAISE_ERROR;
1062: END IF;
1063:
1064: open csr_doc_exists;
1065: fetch csr_doc_exists into l_exists;

Line 1067: hr_utility.set_message(800,'HR_376897_NO_OVERLAP_DEI_INFO');

1063:
1064: open csr_doc_exists;
1065: fetch csr_doc_exists into l_exists;
1066: if csr_doc_exists%FOUND then
1067: hr_utility.set_message(800,'HR_376897_NO_OVERLAP_DEI_INFO');
1068: hr_utility.raise_error;
1069: end if;
1070: close csr_doc_exists;
1071:

Line 1068: hr_utility.raise_error;

1064: open csr_doc_exists;
1065: fetch csr_doc_exists into l_exists;
1066: if csr_doc_exists%FOUND then
1067: hr_utility.set_message(800,'HR_376897_NO_OVERLAP_DEI_INFO');
1068: hr_utility.raise_error;
1069: end if;
1070: close csr_doc_exists;
1071:
1072: END;

Line 1103: hr_utility.trace('IANA Charset = '||lv_iana_charset);

1099: OPEN csr_get_iana_charset;
1100: FETCH csr_get_iana_charset INTO lv_iana_charset;
1101: CLOSE csr_get_iana_charset;
1102:
1103: hr_utility.trace('IANA Charset = '||lv_iana_charset);
1104: RETURN (lv_iana_charset);
1105: END get_IANA_charset;
1106:
1107:

Line 1117: --hr_utility.set_location('Entered '||l_proc,5);

1113: --l_proc varchar2(72) := g_package||'.get_message';
1114: --
1115: BEGIN
1116: --
1117: --hr_utility.set_location('Entered '||l_proc,5);
1118: hr_utility.set_location('. Message Name: ' || p_message_name, 40);
1119: fnd_message.set_name(p_product, p_message_name);
1120:
1121: IF p_token1 IS NOT NULL THEN

Line 1118: hr_utility.set_location('. Message Name: ' || p_message_name, 40);

1114: --
1115: BEGIN
1116: --
1117: --hr_utility.set_location('Entered '||l_proc,5);
1118: hr_utility.set_location('. Message Name: ' || p_message_name, 40);
1119: fnd_message.set_name(p_product, p_message_name);
1120:
1121: IF p_token1 IS NOT NULL THEN
1122:

Line 1127: hr_utility.set_location('. Token1: ' || l_token_name || '. Value: ' || l_token_value, 50);

1123: /* Obtain token 1 name and value */ l_colon_position := instr(p_token1, ':');
1124: l_token_name := SUBSTR(p_token1, 1, l_colon_position -1);
1125: l_token_value := SUBSTR(p_token1, l_colon_position + 1, LENGTH(p_token1));
1126: fnd_message.set_token(l_token_name, l_token_value);
1127: hr_utility.set_location('. Token1: ' || l_token_name || '. Value: ' || l_token_value, 50);
1128: END IF;
1129:
1130: IF p_token2 IS NOT NULL THEN
1131:

Line 1136: hr_utility.set_location('. Token2: ' || l_token_name || '. Value: ' || l_token_value, 60);

1132: /* Obtain token 2 name and value */ l_colon_position := instr(p_token2, ':');
1133: l_token_name := SUBSTR(p_token2, 1, l_colon_position -1);
1134: l_token_value := SUBSTR(p_token2, l_colon_position + 1, LENGTH(p_token2));
1135: fnd_message.set_token(l_token_name, l_token_value);
1136: hr_utility.set_location('. Token2: ' || l_token_name || '. Value: ' || l_token_value, 60);
1137: END IF;
1138:
1139: IF p_token3 IS NOT NULL THEN
1140:

Line 1145: hr_utility.set_location('. Token3: ' || l_token_name || '. Value: ' || l_token_value, 70);

1141: /* Obtain token 3 name and value */ l_colon_position := instr(p_token3, ':');
1142: l_token_name := SUBSTR(p_token3, 1, l_colon_position -1);
1143: l_token_value := SUBSTR(p_token3, l_colon_position + 1, LENGTH(p_token3));
1144: fnd_message.set_token(l_token_name, l_token_value);
1145: hr_utility.set_location('. Token3: ' || l_token_name || '. Value: ' || l_token_value, 70);
1146: END IF;
1147:
1148: l_message := SUBSTR(fnd_message.GET, 1, 254);
1149: --hr_utility.set_location('leaving '||l_proc,100);

Line 1149: --hr_utility.set_location('leaving '||l_proc,100);

1145: hr_utility.set_location('. Token3: ' || l_token_name || '. Value: ' || l_token_value, 70);
1146: END IF;
1147:
1148: l_message := SUBSTR(fnd_message.GET, 1, 254);
1149: --hr_utility.set_location('leaving '||l_proc,100);
1150: RETURN l_message;
1151: END get_message;
1152:
1153:

Line 1183: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));

1179:
1180: EXCEPTION
1181:
1182: WHEN others THEN
1183: hr_utility.trace('SQLERRM:'||substr(sqlerrm,1,200));
1184: raise;
1185:
1186: END get_global_value;
1187: