APPS.HXT_TIME_COLLECTION dependencies on FND_MESSAGE

Line 1994: fnd_message.set_name ('HXT', 'HXT_39308_EMPLYEE_NF');

1990: THEN
1991: hr_utility.set_location (l_proc, 1140);
1992: END IF;
1993:
1994: fnd_message.set_name ('HXT', 'HXT_39308_EMPLYEE_NF');
1995: fnd_message.set_token ('EMP_NUMBER', employee_number);
1996: l_otm_error := fnd_message.get;
1997: otm_error := l_otm_error;
1998: oracle_error := SQLERRM;

Line 1995: fnd_message.set_token ('EMP_NUMBER', employee_number);

1991: hr_utility.set_location (l_proc, 1140);
1992: END IF;
1993:
1994: fnd_message.set_name ('HXT', 'HXT_39308_EMPLYEE_NF');
1995: fnd_message.set_token ('EMP_NUMBER', employee_number);
1996: l_otm_error := fnd_message.get;
1997: otm_error := l_otm_error;
1998: oracle_error := SQLERRM;
1999: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 1996: l_otm_error := fnd_message.get;

1992: END IF;
1993:
1994: fnd_message.set_name ('HXT', 'HXT_39308_EMPLYEE_NF');
1995: fnd_message.set_token ('EMP_NUMBER', employee_number);
1996: l_otm_error := fnd_message.get;
1997: otm_error := l_otm_error;
1998: oracle_error := SQLERRM;
1999: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2000: --2278400

Line 2009: fnd_message.set_name ('HXT', 'HXT_39529_EMP_DATA_SYS_ERR');

2005: THEN
2006: hr_utility.set_location (l_proc, 1150);
2007: END IF;
2008:
2009: fnd_message.set_name ('HXT', 'HXT_39529_EMP_DATA_SYS_ERR');
2010: fnd_message.set_token ('EMP_NUMBER', employee_number);
2011: l_otm_error := fnd_message.get;
2012: otm_error := l_otm_error;
2013: oracle_error := SQLERRM;

Line 2010: fnd_message.set_token ('EMP_NUMBER', employee_number);

2006: hr_utility.set_location (l_proc, 1150);
2007: END IF;
2008:
2009: fnd_message.set_name ('HXT', 'HXT_39529_EMP_DATA_SYS_ERR');
2010: fnd_message.set_token ('EMP_NUMBER', employee_number);
2011: l_otm_error := fnd_message.get;
2012: otm_error := l_otm_error;
2013: oracle_error := SQLERRM;
2014: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2011: l_otm_error := fnd_message.get;

2007: END IF;
2008:
2009: fnd_message.set_name ('HXT', 'HXT_39529_EMP_DATA_SYS_ERR');
2010: fnd_message.set_token ('EMP_NUMBER', employee_number);
2011: l_otm_error := fnd_message.get;
2012: otm_error := l_otm_error;
2013: oracle_error := SQLERRM;
2014: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2015: --2278400

Line 2024: fnd_message.set_name ('HXT', 'HXT_39530_APPRVR_NF');

2020: THEN
2021: hr_utility.set_location (l_proc, 1160);
2022: END IF;
2023:
2024: fnd_message.set_name ('HXT', 'HXT_39530_APPRVR_NF');
2025: fnd_message.set_token ('APP_NUMBER', approver_number);
2026: l_otm_error := fnd_message.get;
2027: otm_error := l_otm_error;
2028: oracle_error := SQLERRM;

Line 2025: fnd_message.set_token ('APP_NUMBER', approver_number);

2021: hr_utility.set_location (l_proc, 1160);
2022: END IF;
2023:
2024: fnd_message.set_name ('HXT', 'HXT_39530_APPRVR_NF');
2025: fnd_message.set_token ('APP_NUMBER', approver_number);
2026: l_otm_error := fnd_message.get;
2027: otm_error := l_otm_error;
2028: oracle_error := SQLERRM;
2029: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2026: l_otm_error := fnd_message.get;

2022: END IF;
2023:
2024: fnd_message.set_name ('HXT', 'HXT_39530_APPRVR_NF');
2025: fnd_message.set_token ('APP_NUMBER', approver_number);
2026: l_otm_error := fnd_message.get;
2027: otm_error := l_otm_error;
2028: oracle_error := SQLERRM;
2029: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2030: --2278400

Line 2039: fnd_message.set_name ('HXT', 'HXT_39531_APP_DATA_SYS_ERR');

2035: THEN
2036: hr_utility.set_location (l_proc, 1170);
2037: END IF;
2038:
2039: fnd_message.set_name ('HXT', 'HXT_39531_APP_DATA_SYS_ERR');
2040: fnd_message.set_token ('APP_NUMBER', approver_number);
2041: l_otm_error := fnd_message.get;
2042: otm_error := l_otm_error;
2043: oracle_error := SQLERRM;

Line 2040: fnd_message.set_token ('APP_NUMBER', approver_number);

2036: hr_utility.set_location (l_proc, 1170);
2037: END IF;
2038:
2039: fnd_message.set_name ('HXT', 'HXT_39531_APP_DATA_SYS_ERR');
2040: fnd_message.set_token ('APP_NUMBER', approver_number);
2041: l_otm_error := fnd_message.get;
2042: otm_error := l_otm_error;
2043: oracle_error := SQLERRM;
2044: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2041: l_otm_error := fnd_message.get;

2037: END IF;
2038:
2039: fnd_message.set_name ('HXT', 'HXT_39531_APP_DATA_SYS_ERR');
2040: fnd_message.set_token ('APP_NUMBER', approver_number);
2041: l_otm_error := fnd_message.get;
2042: otm_error := l_otm_error;
2043: oracle_error := SQLERRM;
2044: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2045: --2278400

Line 2054: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');

2050: THEN
2051: hr_utility.set_location (l_proc, 1180);
2052: END IF;
2053:
2054: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2055: fnd_message.set_token ('FIRST_NAME', l_first_name);
2056: fnd_message.set_token ('LAST_NAME', l_last_name);
2057: fnd_message.set_token ('EMP_NUMBER', employee_number);
2058: l_otm_error := fnd_message.get;

Line 2055: fnd_message.set_token ('FIRST_NAME', l_first_name);

2051: hr_utility.set_location (l_proc, 1180);
2052: END IF;
2053:
2054: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2055: fnd_message.set_token ('FIRST_NAME', l_first_name);
2056: fnd_message.set_token ('LAST_NAME', l_last_name);
2057: fnd_message.set_token ('EMP_NUMBER', employee_number);
2058: l_otm_error := fnd_message.get;
2059: otm_error := l_otm_error;

Line 2056: fnd_message.set_token ('LAST_NAME', l_last_name);

2052: END IF;
2053:
2054: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2055: fnd_message.set_token ('FIRST_NAME', l_first_name);
2056: fnd_message.set_token ('LAST_NAME', l_last_name);
2057: fnd_message.set_token ('EMP_NUMBER', employee_number);
2058: l_otm_error := fnd_message.get;
2059: otm_error := l_otm_error;
2060: oracle_error := SQLERRM;

Line 2057: fnd_message.set_token ('EMP_NUMBER', employee_number);

2053:
2054: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2055: fnd_message.set_token ('FIRST_NAME', l_first_name);
2056: fnd_message.set_token ('LAST_NAME', l_last_name);
2057: fnd_message.set_token ('EMP_NUMBER', employee_number);
2058: l_otm_error := fnd_message.get;
2059: otm_error := l_otm_error;
2060: oracle_error := SQLERRM;
2061: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2058: l_otm_error := fnd_message.get;

2054: fnd_message.set_name ('HXT', 'HXT_39306_ASSIGN_NF');
2055: fnd_message.set_token ('FIRST_NAME', l_first_name);
2056: fnd_message.set_token ('LAST_NAME', l_last_name);
2057: fnd_message.set_token ('EMP_NUMBER', employee_number);
2058: l_otm_error := fnd_message.get;
2059: otm_error := l_otm_error;
2060: oracle_error := SQLERRM;
2061: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2062: --2278400

Line 2071: fnd_message.set_name ('HXT', 'HXT_39319_ERR_GET_ASSIGN');

2067: THEN
2068: hr_utility.set_location (l_proc, 1190);
2069: END IF;
2070:
2071: fnd_message.set_name ('HXT', 'HXT_39319_ERR_GET_ASSIGN');
2072: l_otm_error := fnd_message.get;
2073: otm_error := l_otm_error;
2074: oracle_error := SQLERRM;
2075: call_hxthxc_gen_error ('HXT', 'HXT_39319_ERR_GET_ASSIGN', NULL);

Line 2072: l_otm_error := fnd_message.get;

2068: hr_utility.set_location (l_proc, 1190);
2069: END IF;
2070:
2071: fnd_message.set_name ('HXT', 'HXT_39319_ERR_GET_ASSIGN');
2072: l_otm_error := fnd_message.get;
2073: otm_error := l_otm_error;
2074: oracle_error := SQLERRM;
2075: call_hxthxc_gen_error ('HXT', 'HXT_39319_ERR_GET_ASSIGN', NULL);
2076: --2278400

Line 2085: fnd_message.set_name ('HXT', 'HXT_39331_CANT_CALC_DAT_WRKED');

2081: THEN
2082: hr_utility.set_location (l_proc, 1200);
2083: END IF;
2084:
2085: fnd_message.set_name ('HXT', 'HXT_39331_CANT_CALC_DAT_WRKED');
2086: fnd_message.set_token ('START_TIME', TO_CHAR (start_time));
2087: l_otm_error := fnd_message.get;
2088: otm_error := l_otm_error;
2089: oracle_error := SQLERRM;

Line 2086: fnd_message.set_token ('START_TIME', TO_CHAR (start_time));

2082: hr_utility.set_location (l_proc, 1200);
2083: END IF;
2084:
2085: fnd_message.set_name ('HXT', 'HXT_39331_CANT_CALC_DAT_WRKED');
2086: fnd_message.set_token ('START_TIME', TO_CHAR (start_time));
2087: l_otm_error := fnd_message.get;
2088: otm_error := l_otm_error;
2089: oracle_error := SQLERRM;
2090: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2087: l_otm_error := fnd_message.get;

2083: END IF;
2084:
2085: fnd_message.set_name ('HXT', 'HXT_39331_CANT_CALC_DAT_WRKED');
2086: fnd_message.set_token ('START_TIME', TO_CHAR (start_time));
2087: l_otm_error := fnd_message.get;
2088: otm_error := l_otm_error;
2089: oracle_error := SQLERRM;
2090: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2091: --2278400

Line 2100: fnd_message.set_name ('HXT', 'HXT_39323_ERR_DATE_WRKED');

2096: THEN
2097: hr_utility.set_location (l_proc, 1210);
2098: END IF;
2099:
2100: fnd_message.set_name ('HXT', 'HXT_39323_ERR_DATE_WRKED');
2101: l_otm_error := fnd_message.get;
2102: otm_error := l_otm_error;
2103: oracle_error := SQLERRM;
2104: call_hxthxc_gen_error ('HXT', 'HXT_39323_ERR_DATE_WRKED', NULL);

Line 2101: l_otm_error := fnd_message.get;

2097: hr_utility.set_location (l_proc, 1210);
2098: END IF;
2099:
2100: fnd_message.set_name ('HXT', 'HXT_39323_ERR_DATE_WRKED');
2101: l_otm_error := fnd_message.get;
2102: otm_error := l_otm_error;
2103: oracle_error := SQLERRM;
2104: call_hxthxc_gen_error ('HXT', 'HXT_39323_ERR_DATE_WRKED', NULL);
2105: --2278400

Line 2114: fnd_message.set_name ('HXT', 'HXT_39532_INV_PREV_WAGE_CODE');

2110: THEN
2111: hr_utility.set_location (l_proc, 1220);
2112: END IF;
2113:
2114: fnd_message.set_name ('HXT', 'HXT_39532_INV_PREV_WAGE_CODE');
2115: fnd_message.set_token ('WAGE_CODE', wage_code);
2116: l_error_text := fnd_message.get;
2117: otm_error := l_error_text;
2118: oracle_error := SQLERRM;

Line 2115: fnd_message.set_token ('WAGE_CODE', wage_code);

2111: hr_utility.set_location (l_proc, 1220);
2112: END IF;
2113:
2114: fnd_message.set_name ('HXT', 'HXT_39532_INV_PREV_WAGE_CODE');
2115: fnd_message.set_token ('WAGE_CODE', wage_code);
2116: l_error_text := fnd_message.get;
2117: otm_error := l_error_text;
2118: oracle_error := SQLERRM;
2119: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);

Line 2116: l_error_text := fnd_message.get;

2112: END IF;
2113:
2114: fnd_message.set_name ('HXT', 'HXT_39532_INV_PREV_WAGE_CODE');
2115: fnd_message.set_token ('WAGE_CODE', wage_code);
2116: l_error_text := fnd_message.get;
2117: otm_error := l_error_text;
2118: oracle_error := SQLERRM;
2119: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
2120: --2278400

Line 2129: fnd_message.set_name ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR');

2125: THEN
2126: hr_utility.set_location (l_proc, 1230);
2127: END IF;
2128:
2129: fnd_message.set_name ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR');
2130: l_error_text := fnd_message.get;
2131: otm_error := l_error_text;
2132: oracle_error := SQLERRM;
2133: call_hxthxc_gen_error ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR', NULL);

Line 2130: l_error_text := fnd_message.get;

2126: hr_utility.set_location (l_proc, 1230);
2127: END IF;
2128:
2129: fnd_message.set_name ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR');
2130: l_error_text := fnd_message.get;
2131: otm_error := l_error_text;
2132: oracle_error := SQLERRM;
2133: call_hxthxc_gen_error ('HXT', 'HXT_39533_PREV_WAGE_CD_SYS_ERR', NULL);
2134: --2278400

Line 2143: fnd_message.set_name ('HXT', 'HXT_39534_ELEM_TYPE_NF');

2139: THEN
2140: hr_utility.set_location (l_proc, 1240);
2141: END IF;
2142:
2143: fnd_message.set_name ('HXT', 'HXT_39534_ELEM_TYPE_NF');
2144: fnd_message.set_token ('HRS_TYPE', hours_type);
2145: l_otm_error := fnd_message.get;
2146: otm_error := l_otm_error;
2147: oracle_error := SQLERRM;

Line 2144: fnd_message.set_token ('HRS_TYPE', hours_type);

2140: hr_utility.set_location (l_proc, 1240);
2141: END IF;
2142:
2143: fnd_message.set_name ('HXT', 'HXT_39534_ELEM_TYPE_NF');
2144: fnd_message.set_token ('HRS_TYPE', hours_type);
2145: l_otm_error := fnd_message.get;
2146: otm_error := l_otm_error;
2147: oracle_error := SQLERRM;
2148: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);

Line 2145: l_otm_error := fnd_message.get;

2141: END IF;
2142:
2143: fnd_message.set_name ('HXT', 'HXT_39534_ELEM_TYPE_NF');
2144: fnd_message.set_token ('HRS_TYPE', hours_type);
2145: l_otm_error := fnd_message.get;
2146: otm_error := l_otm_error;
2147: oracle_error := SQLERRM;
2148: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
2149: --2278400

Line 2158: fnd_message.set_name ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR');

2154: THEN
2155: hr_utility.set_location (l_proc, 1250);
2156: END IF;
2157:
2158: fnd_message.set_name ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR');
2159: l_otm_error := fnd_message.get;
2160: otm_error := l_otm_error;
2161: oracle_error := SQLERRM;
2162: call_hxthxc_gen_error ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR', NULL);

Line 2159: l_otm_error := fnd_message.get;

2155: hr_utility.set_location (l_proc, 1250);
2156: END IF;
2157:
2158: fnd_message.set_name ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR');
2159: l_otm_error := fnd_message.get;
2160: otm_error := l_otm_error;
2161: oracle_error := SQLERRM;
2162: call_hxthxc_gen_error ('HXT', 'HXT_39535_ELEM_TYPE_SYS_ERR', NULL);
2163: --2278400

Line 2172: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_NF');

2168: THEN
2169: hr_utility.set_location (l_proc, 1260);
2170: END IF;
2171:
2172: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_NF');
2173: fnd_message.set_token ('HRS_TYPE', hours_type);
2174: l_otm_error := fnd_message.get;
2175: otm_error := l_otm_error;
2176: oracle_error := SQLERRM;

Line 2173: fnd_message.set_token ('HRS_TYPE', hours_type);

2169: hr_utility.set_location (l_proc, 1260);
2170: END IF;
2171:
2172: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_NF');
2173: fnd_message.set_token ('HRS_TYPE', hours_type);
2174: l_otm_error := fnd_message.get;
2175: otm_error := l_otm_error;
2176: oracle_error := SQLERRM;
2177: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2174: l_otm_error := fnd_message.get;

2170: END IF;
2171:
2172: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_NF');
2173: fnd_message.set_token ('HRS_TYPE', hours_type);
2174: l_otm_error := fnd_message.get;
2175: otm_error := l_otm_error;
2176: oracle_error := SQLERRM;
2177: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2178: --2278400

Line 2187: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_SYS_ERR');

2183: THEN
2184: hr_utility.set_location (l_proc, 1270);
2185: END IF;
2186:
2187: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_SYS_ERR');
2188: l_otm_error := fnd_message.get;
2189: otm_error := l_otm_error;
2190: oracle_error := SQLERRM;
2191: call_hxthxc_gen_error ('HXT', 'HXT_ELEM_LINK_SYS_ERR', NULL);

Line 2188: l_otm_error := fnd_message.get;

2184: hr_utility.set_location (l_proc, 1270);
2185: END IF;
2186:
2187: fnd_message.set_name ('HXT', 'HXT_ELEM_LINK_SYS_ERR');
2188: l_otm_error := fnd_message.get;
2189: otm_error := l_otm_error;
2190: oracle_error := SQLERRM;
2191: call_hxthxc_gen_error ('HXT', 'HXT_ELEM_LINK_SYS_ERR', NULL);
2192: --2278400

Line 2201: fnd_message.set_name ('HXT', 'HXT_39536_TASK_ID_NF');

2197: THEN
2198: hr_utility.set_location (l_proc, 1280);
2199: END IF;
2200:
2201: fnd_message.set_name ('HXT', 'HXT_39536_TASK_ID_NF');
2202: fnd_message.set_token ('TASK_NUMBER', task_number);
2203: l_otm_error := fnd_message.get;
2204: otm_error := l_otm_error;
2205: oracle_error := SQLERRM;

Line 2202: fnd_message.set_token ('TASK_NUMBER', task_number);

2198: hr_utility.set_location (l_proc, 1280);
2199: END IF;
2200:
2201: fnd_message.set_name ('HXT', 'HXT_39536_TASK_ID_NF');
2202: fnd_message.set_token ('TASK_NUMBER', task_number);
2203: l_otm_error := fnd_message.get;
2204: otm_error := l_otm_error;
2205: oracle_error := SQLERRM;
2206: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2203: l_otm_error := fnd_message.get;

2199: END IF;
2200:
2201: fnd_message.set_name ('HXT', 'HXT_39536_TASK_ID_NF');
2202: fnd_message.set_token ('TASK_NUMBER', task_number);
2203: l_otm_error := fnd_message.get;
2204: otm_error := l_otm_error;
2205: oracle_error := SQLERRM;
2206: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2207: --2278400

Line 2216: fnd_message.set_name ('HXT', 'HXT_39537_TASK_ID_SYS_ERR');

2212: THEN
2213: hr_utility.set_location (l_proc, 1290);
2214: END IF;
2215:
2216: fnd_message.set_name ('HXT', 'HXT_39537_TASK_ID_SYS_ERR');
2217: l_otm_error := fnd_message.get;
2218: otm_error := l_otm_error;
2219: oracle_error := SQLERRM;
2220: RETURN;

Line 2217: l_otm_error := fnd_message.get;

2213: hr_utility.set_location (l_proc, 1290);
2214: END IF;
2215:
2216: fnd_message.set_name ('HXT', 'HXT_39537_TASK_ID_SYS_ERR');
2217: l_otm_error := fnd_message.get;
2218: otm_error := l_otm_error;
2219: oracle_error := SQLERRM;
2220: RETURN;
2221: WHEN l_locn_id_data_err

Line 2228: fnd_message.set_name ('HXT', 'HXT_39538_LOC_ID_NF');

2224: THEN
2225: hr_utility.set_location (l_proc, 1300);
2226: END IF;
2227:
2228: fnd_message.set_name ('HXT', 'HXT_39538_LOC_ID_NF');
2229: fnd_message.set_token ('LOC_CODE', location_code);
2230: l_otm_error := fnd_message.get;
2231: otm_error := l_otm_error;
2232: oracle_error := SQLERRM;

Line 2229: fnd_message.set_token ('LOC_CODE', location_code);

2225: hr_utility.set_location (l_proc, 1300);
2226: END IF;
2227:
2228: fnd_message.set_name ('HXT', 'HXT_39538_LOC_ID_NF');
2229: fnd_message.set_token ('LOC_CODE', location_code);
2230: l_otm_error := fnd_message.get;
2231: otm_error := l_otm_error;
2232: oracle_error := SQLERRM;
2233: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2230: l_otm_error := fnd_message.get;

2226: END IF;
2227:
2228: fnd_message.set_name ('HXT', 'HXT_39538_LOC_ID_NF');
2229: fnd_message.set_token ('LOC_CODE', location_code);
2230: l_otm_error := fnd_message.get;
2231: otm_error := l_otm_error;
2232: oracle_error := SQLERRM;
2233: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2234: --2278400

Line 2243: fnd_message.set_name ('HXT', 'HXT_39539_LOC_ID_SYS_ERR');

2239: THEN
2240: hr_utility.set_location (l_proc, 1310);
2241: END IF;
2242:
2243: fnd_message.set_name ('HXT', 'HXT_39539_LOC_ID_SYS_ERR');
2244: l_otm_error := fnd_message.get;
2245: otm_error := l_otm_error;
2246: oracle_error := SQLERRM;
2247: call_hxthxc_gen_error ('HXT', 'HXT_39539_LOC_ID_SYS_ERR', NULL);

Line 2244: l_otm_error := fnd_message.get;

2240: hr_utility.set_location (l_proc, 1310);
2241: END IF;
2242:
2243: fnd_message.set_name ('HXT', 'HXT_39539_LOC_ID_SYS_ERR');
2244: l_otm_error := fnd_message.get;
2245: otm_error := l_otm_error;
2246: oracle_error := SQLERRM;
2247: call_hxthxc_gen_error ('HXT', 'HXT_39539_LOC_ID_SYS_ERR', NULL);
2248: --2278400

Line 2257: fnd_message.set_name ('HXT', 'HXT_39540_PRJ_ID_NF');

2253: THEN
2254: hr_utility.set_location (l_proc, 1320);
2255: END IF;
2256:
2257: fnd_message.set_name ('HXT', 'HXT_39540_PRJ_ID_NF');
2258: fnd_message.set_token ('PRJ_NUMBER', project);
2259: l_otm_error := fnd_message.get;
2260: otm_error := l_otm_error;
2261: oracle_error := SQLERRM;

Line 2258: fnd_message.set_token ('PRJ_NUMBER', project);

2254: hr_utility.set_location (l_proc, 1320);
2255: END IF;
2256:
2257: fnd_message.set_name ('HXT', 'HXT_39540_PRJ_ID_NF');
2258: fnd_message.set_token ('PRJ_NUMBER', project);
2259: l_otm_error := fnd_message.get;
2260: otm_error := l_otm_error;
2261: oracle_error := SQLERRM;
2262: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2259: l_otm_error := fnd_message.get;

2255: END IF;
2256:
2257: fnd_message.set_name ('HXT', 'HXT_39540_PRJ_ID_NF');
2258: fnd_message.set_token ('PRJ_NUMBER', project);
2259: l_otm_error := fnd_message.get;
2260: otm_error := l_otm_error;
2261: oracle_error := SQLERRM;
2262: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2263: --2278400

Line 2272: fnd_message.set_name ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR');

2268: THEN
2269: hr_utility.set_location (l_proc, 1330);
2270: END IF;
2271:
2272: fnd_message.set_name ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR');
2273: l_otm_error := fnd_message.get;
2274: otm_error := l_otm_error;
2275: oracle_error := SQLERRM;
2276: call_hxthxc_gen_error ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR', NULL);

Line 2273: l_otm_error := fnd_message.get;

2269: hr_utility.set_location (l_proc, 1330);
2270: END IF;
2271:
2272: fnd_message.set_name ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR');
2273: l_otm_error := fnd_message.get;
2274: otm_error := l_otm_error;
2275: oracle_error := SQLERRM;
2276: call_hxthxc_gen_error ('HXT', 'HXT_39541_PRJ_ID_SYS_ERR', NULL);
2277: --2278400

Line 2286: fnd_message.set_name ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE');

2282: THEN
2283: hr_utility.set_location (l_proc, 1340);
2284: END IF;
2285:
2286: fnd_message.set_name ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE');
2287: l_otm_error := fnd_message.get;
2288: otm_error := l_otm_error;
2289: oracle_error := SQLERRM;
2290: call_hxthxc_gen_error ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE', NULL);

Line 2287: l_otm_error := fnd_message.get;

2283: hr_utility.set_location (l_proc, 1340);
2284: END IF;
2285:
2286: fnd_message.set_name ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE');
2287: l_otm_error := fnd_message.get;
2288: otm_error := l_otm_error;
2289: oracle_error := SQLERRM;
2290: call_hxthxc_gen_error ('HXT', 'HXT_39542_ERN_RSN_WO_HRS_TYPE', NULL);
2291: --2278400

Line 2300: fnd_message.set_name ('HXT', 'HXT_39543_ERN_RSN_NF');

2296: THEN
2297: hr_utility.set_location (l_proc, 1350);
2298: END IF;
2299:
2300: fnd_message.set_name ('HXT', 'HXT_39543_ERN_RSN_NF');
2301: fnd_message.set_token ('ERN_RSN_CD', earn_reason_code);
2302: l_otm_error := fnd_message.get;
2303: otm_error := l_otm_error;
2304: oracle_error := SQLERRM;

Line 2301: fnd_message.set_token ('ERN_RSN_CD', earn_reason_code);

2297: hr_utility.set_location (l_proc, 1350);
2298: END IF;
2299:
2300: fnd_message.set_name ('HXT', 'HXT_39543_ERN_RSN_NF');
2301: fnd_message.set_token ('ERN_RSN_CD', earn_reason_code);
2302: l_otm_error := fnd_message.get;
2303: otm_error := l_otm_error;
2304: oracle_error := SQLERRM;
2305: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2302: l_otm_error := fnd_message.get;

2298: END IF;
2299:
2300: fnd_message.set_name ('HXT', 'HXT_39543_ERN_RSN_NF');
2301: fnd_message.set_token ('ERN_RSN_CD', earn_reason_code);
2302: l_otm_error := fnd_message.get;
2303: otm_error := l_otm_error;
2304: oracle_error := SQLERRM;
2305: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2306: --2278400

Line 2315: fnd_message.set_name ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR');

2311: THEN
2312: hr_utility.set_location (l_proc, 1360);
2313: END IF;
2314:
2315: fnd_message.set_name ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR');
2316: l_otm_error := fnd_message.get;
2317: otm_error := l_otm_error;
2318: oracle_error := SQLERRM;
2319: call_hxthxc_gen_error ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR', NULL);

Line 2316: l_otm_error := fnd_message.get;

2312: hr_utility.set_location (l_proc, 1360);
2313: END IF;
2314:
2315: fnd_message.set_name ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR');
2316: l_otm_error := fnd_message.get;
2317: otm_error := l_otm_error;
2318: oracle_error := SQLERRM;
2319: call_hxthxc_gen_error ('HXT', 'HXT_39544_ERN_RSN_SYS_ERR', NULL);
2320: --2278400

Line 2329: fnd_message.set_name ('HXT', 'HXT_39545_SEP_CHK_NF');

2325: THEN
2326: hr_utility.set_location (l_proc, 1370);
2327: END IF;
2328:
2329: fnd_message.set_name ('HXT', 'HXT_39545_SEP_CHK_NF');
2330: fnd_message.set_token ('SEP_CHK', l_sep_chk_flg);
2331: l_otm_error := fnd_message.get;
2332: otm_error := l_otm_error;
2333: oracle_error := SQLERRM;

Line 2330: fnd_message.set_token ('SEP_CHK', l_sep_chk_flg);

2326: hr_utility.set_location (l_proc, 1370);
2327: END IF;
2328:
2329: fnd_message.set_name ('HXT', 'HXT_39545_SEP_CHK_NF');
2330: fnd_message.set_token ('SEP_CHK', l_sep_chk_flg);
2331: l_otm_error := fnd_message.get;
2332: otm_error := l_otm_error;
2333: oracle_error := SQLERRM;
2334: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2331: l_otm_error := fnd_message.get;

2327: END IF;
2328:
2329: fnd_message.set_name ('HXT', 'HXT_39545_SEP_CHK_NF');
2330: fnd_message.set_token ('SEP_CHK', l_sep_chk_flg);
2331: l_otm_error := fnd_message.get;
2332: otm_error := l_otm_error;
2333: oracle_error := SQLERRM;
2334: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2335: --2278400

Line 2344: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');

2340: THEN
2341: hr_utility.set_location (l_proc, 1380);
2342: END IF;
2343:
2344: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');
2345: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));
2346: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));
2347: l_otm_error := fnd_message.get;
2348: otm_error := l_otm_error;

Line 2345: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));

2341: hr_utility.set_location (l_proc, 1380);
2342: END IF;
2343:
2344: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');
2345: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));
2346: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));
2347: l_otm_error := fnd_message.get;
2348: otm_error := l_otm_error;
2349: oracle_error := SQLERRM;

Line 2346: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));

2342: END IF;
2343:
2344: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');
2345: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));
2346: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));
2347: l_otm_error := fnd_message.get;
2348: otm_error := l_otm_error;
2349: oracle_error := SQLERRM;
2350: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2347: l_otm_error := fnd_message.get;

2343:
2344: fnd_message.set_name ('HXT', 'HXT_39330_CANT_CALC_TIM_PER');
2345: fnd_message.set_token ('DATE_WORKED', TO_CHAR (l_date_worked));
2346: fnd_message.set_token ('PAYROLL', TO_CHAR (l_emp_rec.payroll_id));
2347: l_otm_error := fnd_message.get;
2348: otm_error := l_otm_error;
2349: oracle_error := SQLERRM;
2350: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2351: --2278400

Line 2360: fnd_message.set_name ('HXT', 'HXT_39324_ERR_TIME_PERIOD');

2356: THEN
2357: hr_utility.set_location (l_proc, 1390);
2358: END IF;
2359:
2360: fnd_message.set_name ('HXT', 'HXT_39324_ERR_TIME_PERIOD');
2361: fnd_message.set_token ('SQLERR', SQLERRM);
2362: l_otm_error := fnd_message.get;
2363: otm_error := l_otm_error;
2364: oracle_error := SQLERRM;

Line 2361: fnd_message.set_token ('SQLERR', SQLERRM);

2357: hr_utility.set_location (l_proc, 1390);
2358: END IF;
2359:
2360: fnd_message.set_name ('HXT', 'HXT_39324_ERR_TIME_PERIOD');
2361: fnd_message.set_token ('SQLERR', SQLERRM);
2362: l_otm_error := fnd_message.get;
2363: otm_error := l_otm_error;
2364: oracle_error := SQLERRM;
2365: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2362: l_otm_error := fnd_message.get;

2358: END IF;
2359:
2360: fnd_message.set_name ('HXT', 'HXT_39324_ERR_TIME_PERIOD');
2361: fnd_message.set_token ('SQLERR', SQLERRM);
2362: l_otm_error := fnd_message.get;
2363: otm_error := l_otm_error;
2364: oracle_error := SQLERRM;
2365: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2366: --2278400

Line 2375: fnd_message.set_name ('HXT', 'HXT_39298_ERR_GET_TIMCARD');

2371: THEN
2372: hr_utility.set_location (l_proc, 1400);
2373: END IF;
2374:
2375: fnd_message.set_name ('HXT', 'HXT_39298_ERR_GET_TIMCARD');
2376: l_otm_error := fnd_message.get;
2377: otm_error := l_otm_error;
2378: oracle_error := SQLERRM;
2379: call_hxthxc_gen_error ('HXT', 'HXT_39298_ERR_GET_TIMCARD', NULL);

Line 2376: l_otm_error := fnd_message.get;

2372: hr_utility.set_location (l_proc, 1400);
2373: END IF;
2374:
2375: fnd_message.set_name ('HXT', 'HXT_39298_ERR_GET_TIMCARD');
2376: l_otm_error := fnd_message.get;
2377: otm_error := l_otm_error;
2378: oracle_error := SQLERRM;
2379: call_hxthxc_gen_error ('HXT', 'HXT_39298_ERR_GET_TIMCARD', NULL);
2380: --2278400

Line 2389: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');

2385: THEN
2386: hr_utility.set_location (l_proc, 1410);
2387: END IF;
2388:
2389: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2390: fnd_message.set_token ('FIRST_NAME', l_first_name);
2391: fnd_message.set_token ('LAST_NAME', l_last_name);
2392: fnd_message.set_token ('EMP_NUMBER', employee_number);
2393: l_otm_error := fnd_message.get;

Line 2390: fnd_message.set_token ('FIRST_NAME', l_first_name);

2386: hr_utility.set_location (l_proc, 1410);
2387: END IF;
2388:
2389: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2390: fnd_message.set_token ('FIRST_NAME', l_first_name);
2391: fnd_message.set_token ('LAST_NAME', l_last_name);
2392: fnd_message.set_token ('EMP_NUMBER', employee_number);
2393: l_otm_error := fnd_message.get;
2394: otm_error := l_otm_error;

Line 2391: fnd_message.set_token ('LAST_NAME', l_last_name);

2387: END IF;
2388:
2389: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2390: fnd_message.set_token ('FIRST_NAME', l_first_name);
2391: fnd_message.set_token ('LAST_NAME', l_last_name);
2392: fnd_message.set_token ('EMP_NUMBER', employee_number);
2393: l_otm_error := fnd_message.get;
2394: otm_error := l_otm_error;
2395: oracle_error := SQLERRM;

Line 2392: fnd_message.set_token ('EMP_NUMBER', employee_number);

2388:
2389: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2390: fnd_message.set_token ('FIRST_NAME', l_first_name);
2391: fnd_message.set_token ('LAST_NAME', l_last_name);
2392: fnd_message.set_token ('EMP_NUMBER', employee_number);
2393: l_otm_error := fnd_message.get;
2394: otm_error := l_otm_error;
2395: oracle_error := SQLERRM;
2396: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2393: l_otm_error := fnd_message.get;

2389: fnd_message.set_name ('HXT', 'HXT_39267_AG_TCARD_EXISTS');
2390: fnd_message.set_token ('FIRST_NAME', l_first_name);
2391: fnd_message.set_token ('LAST_NAME', l_last_name);
2392: fnd_message.set_token ('EMP_NUMBER', employee_number);
2393: l_otm_error := fnd_message.get;
2394: otm_error := l_otm_error;
2395: oracle_error := SQLERRM;
2396: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2397: --2278400

Line 2406: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');

2402: THEN
2403: hr_utility.set_location (l_proc, 1420);
2404: END IF;
2405:
2406: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2407: fnd_message.set_token ('FIRST_NAME', l_first_name);
2408: fnd_message.set_token ('LAST_NAME', l_last_name);
2409: fnd_message.set_token ('EMP_NUMBER', employee_number);
2410: l_otm_error := fnd_message.get;

Line 2407: fnd_message.set_token ('FIRST_NAME', l_first_name);

2403: hr_utility.set_location (l_proc, 1420);
2404: END IF;
2405:
2406: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2407: fnd_message.set_token ('FIRST_NAME', l_first_name);
2408: fnd_message.set_token ('LAST_NAME', l_last_name);
2409: fnd_message.set_token ('EMP_NUMBER', employee_number);
2410: l_otm_error := fnd_message.get;
2411: otm_error := l_otm_error;

Line 2408: fnd_message.set_token ('LAST_NAME', l_last_name);

2404: END IF;
2405:
2406: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2407: fnd_message.set_token ('FIRST_NAME', l_first_name);
2408: fnd_message.set_token ('LAST_NAME', l_last_name);
2409: fnd_message.set_token ('EMP_NUMBER', employee_number);
2410: l_otm_error := fnd_message.get;
2411: otm_error := l_otm_error;
2412: oracle_error := SQLERRM;

Line 2409: fnd_message.set_token ('EMP_NUMBER', employee_number);

2405:
2406: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2407: fnd_message.set_token ('FIRST_NAME', l_first_name);
2408: fnd_message.set_token ('LAST_NAME', l_last_name);
2409: fnd_message.set_token ('EMP_NUMBER', employee_number);
2410: l_otm_error := fnd_message.get;
2411: otm_error := l_otm_error;
2412: oracle_error := SQLERRM;
2413: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2410: l_otm_error := fnd_message.get;

2406: fnd_message.set_name ('HXT', 'HXT_39291_CRT_TCARD_ERR');
2407: fnd_message.set_token ('FIRST_NAME', l_first_name);
2408: fnd_message.set_token ('LAST_NAME', l_last_name);
2409: fnd_message.set_token ('EMP_NUMBER', employee_number);
2410: l_otm_error := fnd_message.get;
2411: otm_error := l_otm_error;
2412: oracle_error := SQLERRM;
2413: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2414: --2278400

Line 2423: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');

2419: THEN
2420: hr_utility.set_location (l_proc, 1430);
2421: END IF;
2422:
2423: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2424: fnd_message.set_token ('FIRST_NAME', l_first_name);
2425: fnd_message.set_token ('LAST_NAME', l_last_name);
2426: fnd_message.set_token ('EMP_NUMBER', employee_number);
2427: l_otm_error := fnd_message.get;

Line 2424: fnd_message.set_token ('FIRST_NAME', l_first_name);

2420: hr_utility.set_location (l_proc, 1430);
2421: END IF;
2422:
2423: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2424: fnd_message.set_token ('FIRST_NAME', l_first_name);
2425: fnd_message.set_token ('LAST_NAME', l_last_name);
2426: fnd_message.set_token ('EMP_NUMBER', employee_number);
2427: l_otm_error := fnd_message.get;
2428: l_oracle_error := SQLERRM;

Line 2425: fnd_message.set_token ('LAST_NAME', l_last_name);

2421: END IF;
2422:
2423: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2424: fnd_message.set_token ('FIRST_NAME', l_first_name);
2425: fnd_message.set_token ('LAST_NAME', l_last_name);
2426: fnd_message.set_token ('EMP_NUMBER', employee_number);
2427: l_otm_error := fnd_message.get;
2428: l_oracle_error := SQLERRM;
2429: otm_error := l_otm_error;

Line 2426: fnd_message.set_token ('EMP_NUMBER', employee_number);

2422:
2423: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2424: fnd_message.set_token ('FIRST_NAME', l_first_name);
2425: fnd_message.set_token ('LAST_NAME', l_last_name);
2426: fnd_message.set_token ('EMP_NUMBER', employee_number);
2427: l_otm_error := fnd_message.get;
2428: l_oracle_error := SQLERRM;
2429: otm_error := l_otm_error;
2430: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2427: l_otm_error := fnd_message.get;

2423: fnd_message.set_name ('HXT', 'HXT_39318_ERR_CREAT_TCARD');
2424: fnd_message.set_token ('FIRST_NAME', l_first_name);
2425: fnd_message.set_token ('LAST_NAME', l_last_name);
2426: fnd_message.set_token ('EMP_NUMBER', employee_number);
2427: l_otm_error := fnd_message.get;
2428: l_oracle_error := SQLERRM;
2429: otm_error := l_otm_error;
2430: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2431: --2278400

Line 2441: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');

2437: THEN
2438: hr_utility.set_location (l_proc, 1440);
2439: END IF;
2440:
2441: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2442: fnd_message.set_token ('FIRST_NAME', l_first_name);
2443: fnd_message.set_token ('LAST_NAME', l_last_name);
2444: fnd_message.set_token ('EMP_NUMBER', employee_number);
2445: l_otm_error := fnd_message.get;

Line 2442: fnd_message.set_token ('FIRST_NAME', l_first_name);

2438: hr_utility.set_location (l_proc, 1440);
2439: END IF;
2440:
2441: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2442: fnd_message.set_token ('FIRST_NAME', l_first_name);
2443: fnd_message.set_token ('LAST_NAME', l_last_name);
2444: fnd_message.set_token ('EMP_NUMBER', employee_number);
2445: l_otm_error := fnd_message.get;
2446: otm_error := l_otm_error;

Line 2443: fnd_message.set_token ('LAST_NAME', l_last_name);

2439: END IF;
2440:
2441: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2442: fnd_message.set_token ('FIRST_NAME', l_first_name);
2443: fnd_message.set_token ('LAST_NAME', l_last_name);
2444: fnd_message.set_token ('EMP_NUMBER', employee_number);
2445: l_otm_error := fnd_message.get;
2446: otm_error := l_otm_error;
2447: oracle_error := SQLERRM;

Line 2444: fnd_message.set_token ('EMP_NUMBER', employee_number);

2440:
2441: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2442: fnd_message.set_token ('FIRST_NAME', l_first_name);
2443: fnd_message.set_token ('LAST_NAME', l_last_name);
2444: fnd_message.set_token ('EMP_NUMBER', employee_number);
2445: l_otm_error := fnd_message.get;
2446: otm_error := l_otm_error;
2447: oracle_error := SQLERRM;
2448: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2445: l_otm_error := fnd_message.get;

2441: fnd_message.set_name ('HXT', 'HXT_39292_CRT_HOL_HRS');
2442: fnd_message.set_token ('FIRST_NAME', l_first_name);
2443: fnd_message.set_token ('LAST_NAME', l_last_name);
2444: fnd_message.set_token ('EMP_NUMBER', employee_number);
2445: l_otm_error := fnd_message.get;
2446: otm_error := l_otm_error;
2447: oracle_error := SQLERRM;
2448: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2449: --2278400

Line 2458: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');

2454: THEN
2455: hr_utility.set_location (l_proc, 1450);
2456: END IF;
2457:
2458: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2459: fnd_message.set_token ('FIRST_NAME', l_first_name);
2460: fnd_message.set_token ('LAST_NAME', l_last_name);
2461: fnd_message.set_token ('EMP_NUMBER', employee_number);
2462: l_otm_error := fnd_message.get;

Line 2459: fnd_message.set_token ('FIRST_NAME', l_first_name);

2455: hr_utility.set_location (l_proc, 1450);
2456: END IF;
2457:
2458: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2459: fnd_message.set_token ('FIRST_NAME', l_first_name);
2460: fnd_message.set_token ('LAST_NAME', l_last_name);
2461: fnd_message.set_token ('EMP_NUMBER', employee_number);
2462: l_otm_error := fnd_message.get;
2463: otm_error := l_otm_error;

Line 2460: fnd_message.set_token ('LAST_NAME', l_last_name);

2456: END IF;
2457:
2458: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2459: fnd_message.set_token ('FIRST_NAME', l_first_name);
2460: fnd_message.set_token ('LAST_NAME', l_last_name);
2461: fnd_message.set_token ('EMP_NUMBER', employee_number);
2462: l_otm_error := fnd_message.get;
2463: otm_error := l_otm_error;
2464: oracle_error := SQLERRM;

Line 2461: fnd_message.set_token ('EMP_NUMBER', employee_number);

2457:
2458: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2459: fnd_message.set_token ('FIRST_NAME', l_first_name);
2460: fnd_message.set_token ('LAST_NAME', l_last_name);
2461: fnd_message.set_token ('EMP_NUMBER', employee_number);
2462: l_otm_error := fnd_message.get;
2463: otm_error := l_otm_error;
2464: oracle_error := SQLERRM;
2465: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2462: l_otm_error := fnd_message.get;

2458: fnd_message.set_name ('HXT', 'HXT_39320_ERR_CREAT_HOL');
2459: fnd_message.set_token ('FIRST_NAME', l_first_name);
2460: fnd_message.set_token ('LAST_NAME', l_last_name);
2461: fnd_message.set_token ('EMP_NUMBER', employee_number);
2462: l_otm_error := fnd_message.get;
2463: otm_error := l_otm_error;
2464: oracle_error := SQLERRM;
2465: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2466: --2278400

Line 2480: fnd_message.set_name ('HXT', 'HXT_39293_REC_HRS_ERR');

2476: -- there is no point writing over a specific system error
2477: -- with a generic translated error
2478: IF (l_otm_error IS NULL)
2479: THEN
2480: fnd_message.set_name ('HXT', 'HXT_39293_REC_HRS_ERR');
2481: l_otm_error := fnd_message.get;
2482: END IF;
2483:
2484: otm_error := l_otm_error;

Line 2481: l_otm_error := fnd_message.get;

2477: -- with a generic translated error
2478: IF (l_otm_error IS NULL)
2479: THEN
2480: fnd_message.set_name ('HXT', 'HXT_39293_REC_HRS_ERR');
2481: l_otm_error := fnd_message.get;
2482: END IF;
2483:
2484: otm_error := l_otm_error;
2485:

Line 2508: fnd_message.set_name ('HXT', 'HXT_39321_ERR_REC_HRS');

2504: -- there is no point writing over a specific system error
2505: -- with a generic translated error
2506: IF (l_otm_error IS NULL)
2507: THEN
2508: fnd_message.set_name ('HXT', 'HXT_39321_ERR_REC_HRS');
2509: l_otm_error := fnd_message.get;
2510: END IF;
2511:
2512: otm_error := l_otm_error;

Line 2509: l_otm_error := fnd_message.get;

2505: -- with a generic translated error
2506: IF (l_otm_error IS NULL)
2507: THEN
2508: fnd_message.set_name ('HXT', 'HXT_39321_ERR_REC_HRS');
2509: l_otm_error := fnd_message.get;
2510: END IF;
2511:
2512: otm_error := l_otm_error;
2513:

Line 2521: l_otm_error := fnd_message.get;

2517: ELSE
2518: oracle_error := l_oracle_error;
2519: END IF;
2520:
2521: l_otm_error := fnd_message.get;
2522: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2523: --2278400
2524: RETURN;
2525: WHEN l_hours_amount_data_err

Line 2532: fnd_message.set_name ('HXT', 'HXT_39527_HRS_REQ_IF_AMT');

2528: THEN
2529: hr_utility.set_location (l_proc, 1480);
2530: END IF;
2531:
2532: fnd_message.set_name ('HXT', 'HXT_39527_HRS_REQ_IF_AMT');
2533: l_otm_error := fnd_message.get;
2534: otm_error := l_otm_error;
2535: oracle_error := SQLERRM;
2536: call_hxthxc_gen_error ('HXT', 'HXT_39527_HRS_REQ_IF_AMT', NULL);

Line 2533: l_otm_error := fnd_message.get;

2529: hr_utility.set_location (l_proc, 1480);
2530: END IF;
2531:
2532: fnd_message.set_name ('HXT', 'HXT_39527_HRS_REQ_IF_AMT');
2533: l_otm_error := fnd_message.get;
2534: otm_error := l_otm_error;
2535: oracle_error := SQLERRM;
2536: call_hxthxc_gen_error ('HXT', 'HXT_39527_HRS_REQ_IF_AMT', NULL);
2537: --2278400

Line 2546: fnd_message.set_name ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP');

2542: THEN
2543: hr_utility.set_location (l_proc, 1490);
2544: END IF;
2545:
2546: fnd_message.set_name ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP');
2547: l_otm_error := fnd_message.get;
2548: otm_error := l_otm_error;
2549: oracle_error := SQLERRM;
2550: call_hxthxc_gen_error ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP', NULL);

Line 2547: l_otm_error := fnd_message.get;

2543: hr_utility.set_location (l_proc, 1490);
2544: END IF;
2545:
2546: fnd_message.set_name ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP');
2547: l_otm_error := fnd_message.get;
2548: otm_error := l_otm_error;
2549: oracle_error := SQLERRM;
2550: call_hxthxc_gen_error ('HXT', 'HXT_39528_HRS_NE0_IF_NO_HRSTYP', NULL);
2551: --2278400

Line 2560: fnd_message.set_name ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT');

2556: THEN
2557: hr_utility.set_location (l_proc, 1500);
2558: END IF;
2559:
2560: fnd_message.set_name ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT');
2561: l_otm_error := fnd_message.get;
2562: otm_error := l_otm_error;
2563: oracle_error := SQLERRM;
2564: call_hxthxc_gen_error ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT', NULL);

Line 2561: l_otm_error := fnd_message.get;

2557: hr_utility.set_location (l_proc, 1500);
2558: END IF;
2559:
2560: fnd_message.set_name ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT');
2561: l_otm_error := fnd_message.get;
2562: otm_error := l_otm_error;
2563: oracle_error := SQLERRM;
2564: call_hxthxc_gen_error ('HXT', 'HXT_39546_HRS_NE0_IF_NO_AMT', NULL);
2565: --2278400

Line 2574: fnd_message.set_name ('HXT', 'HXT_39547_START_END_REQ');

2570: THEN
2571: hr_utility.set_location (l_proc, 1510);
2572: END IF;
2573:
2574: fnd_message.set_name ('HXT', 'HXT_39547_START_END_REQ');
2575: l_otm_error := fnd_message.get;
2576: otm_error := l_otm_error;
2577: oracle_error := SQLERRM;
2578: call_hxthxc_gen_error ('HXT', 'HXT_39547_START_END_REQ', NULL);

Line 2575: l_otm_error := fnd_message.get;

2571: hr_utility.set_location (l_proc, 1510);
2572: END IF;
2573:
2574: fnd_message.set_name ('HXT', 'HXT_39547_START_END_REQ');
2575: l_otm_error := fnd_message.get;
2576: otm_error := l_otm_error;
2577: oracle_error := SQLERRM;
2578: call_hxthxc_gen_error ('HXT', 'HXT_39547_START_END_REQ', NULL);
2579: --2278400

Line 2588: fnd_message.set_name ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK');

2584: THEN
2585: hr_utility.set_location (l_proc, 1520);
2586: END IF;
2587:
2588: fnd_message.set_name ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK');
2589: l_otm_error := fnd_message.get;
2590: otm_error := l_otm_error;
2591: oracle_error := SQLERRM;
2592: call_hxthxc_gen_error ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK', NULL);

Line 2589: l_otm_error := fnd_message.get;

2585: hr_utility.set_location (l_proc, 1520);
2586: END IF;
2587:
2588: fnd_message.set_name ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK');
2589: l_otm_error := fnd_message.get;
2590: otm_error := l_otm_error;
2591: oracle_error := SQLERRM;
2592: call_hxthxc_gen_error ('HXT', 'HXT_39548_HRS_REQ_IF_DT_WRK', NULL);
2593: --2278400

Line 2602: fnd_message.set_name ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ');

2598: THEN
2599: hr_utility.set_location (l_proc, 1530);
2600: END IF;
2601:
2602: fnd_message.set_name ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ');
2603: l_otm_error := fnd_message.get;
2604: otm_error := l_otm_error;
2605: oracle_error := SQLERRM;
2606: call_hxthxc_gen_error ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ', NULL);

Line 2603: l_otm_error := fnd_message.get;

2599: hr_utility.set_location (l_proc, 1530);
2600: END IF;
2601:
2602: fnd_message.set_name ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ');
2603: l_otm_error := fnd_message.get;
2604: otm_error := l_otm_error;
2605: oracle_error := SQLERRM;
2606: call_hxthxc_gen_error ('HXT', 'HXT_39549_ST_END_OR_DT_WRK_REQ', NULL);
2607: --2278400

Line 2616: fnd_message.set_name ('HXT', 'HXT_39550_TIM_SRC_NF');

2612: THEN
2613: hr_utility.set_location (l_proc, 1540);
2614: END IF;
2615:
2616: fnd_message.set_name ('HXT', 'HXT_39550_TIM_SRC_NF');
2617: l_otm_error := fnd_message.get;
2618: otm_error := l_otm_error;
2619: oracle_error := SQLERRM;
2620: call_hxthxc_gen_error ('HXT', 'HXT_39550_TIM_SRC_NF', NULL);

Line 2617: l_otm_error := fnd_message.get;

2613: hr_utility.set_location (l_proc, 1540);
2614: END IF;
2615:
2616: fnd_message.set_name ('HXT', 'HXT_39550_TIM_SRC_NF');
2617: l_otm_error := fnd_message.get;
2618: otm_error := l_otm_error;
2619: oracle_error := SQLERRM;
2620: call_hxthxc_gen_error ('HXT', 'HXT_39550_TIM_SRC_NF', NULL);
2621: --2278400

Line 2630: fnd_message.set_name ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR');

2626: THEN
2627: hr_utility.set_location (l_proc, 1550);
2628: END IF;
2629:
2630: fnd_message.set_name ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR');
2631: l_otm_error := fnd_message.get;
2632: otm_error := l_otm_error;
2633: oracle_error := SQLERRM;
2634: call_hxthxc_gen_error ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR', NULL);

Line 2631: l_otm_error := fnd_message.get;

2627: hr_utility.set_location (l_proc, 1550);
2628: END IF;
2629:
2630: fnd_message.set_name ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR');
2631: l_otm_error := fnd_message.get;
2632: otm_error := l_otm_error;
2633: oracle_error := SQLERRM;
2634: call_hxthxc_gen_error ('HXT', 'HXT_39551_TIM_SRC_SYS_ERR', NULL);
2635: --2278400

Line 2644: fnd_message.set_name ('HXT', 'HXT_39552_TIM_SUM_ID_NF');

2640: THEN
2641: hr_utility.set_location (l_proc, 1560);
2642: END IF;
2643:
2644: fnd_message.set_name ('HXT', 'HXT_39552_TIM_SUM_ID_NF');
2645: l_otm_error := fnd_message.get;
2646: otm_error := l_otm_error;
2647: oracle_error := SQLERRM;
2648: call_hxthxc_gen_error ('HXT', 'HXT_39552_TIM_SUM_ID_NF', NULL);

Line 2645: l_otm_error := fnd_message.get;

2641: hr_utility.set_location (l_proc, 1560);
2642: END IF;
2643:
2644: fnd_message.set_name ('HXT', 'HXT_39552_TIM_SUM_ID_NF');
2645: l_otm_error := fnd_message.get;
2646: otm_error := l_otm_error;
2647: oracle_error := SQLERRM;
2648: call_hxthxc_gen_error ('HXT', 'HXT_39552_TIM_SUM_ID_NF', NULL);
2649: --2278400

Line 2658: fnd_message.set_name ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR');

2654: THEN
2655: hr_utility.set_location (l_proc, 1570);
2656: END IF;
2657:
2658: fnd_message.set_name ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR');
2659: l_otm_error := fnd_message.get;
2660: otm_error := l_otm_error;
2661: oracle_error := SQLERRM;
2662: call_hxthxc_gen_error ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR', NULL);

Line 2659: l_otm_error := fnd_message.get;

2655: hr_utility.set_location (l_proc, 1570);
2656: END IF;
2657:
2658: fnd_message.set_name ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR');
2659: l_otm_error := fnd_message.get;
2660: otm_error := l_otm_error;
2661: oracle_error := SQLERRM;
2662: call_hxthxc_gen_error ('HXT', 'HXT_39553_TIM_SUM_ID_SYS_ERR', NULL);
2663: --2278400

Line 2672: fnd_message.set_name ('HXT', 'HXT_39554_ERN_POL_NF');

2668: THEN
2669: hr_utility.set_location (l_proc, 1580);
2670: END IF;
2671:
2672: fnd_message.set_name ('HXT', 'HXT_39554_ERN_POL_NF');
2673: l_otm_error := fnd_message.get;
2674: otm_error := l_otm_error;
2675: oracle_error := SQLERRM;
2676: call_hxthxc_gen_error ('HXT', 'HXT_39554_ERN_POL_NF', NULL);

Line 2673: l_otm_error := fnd_message.get;

2669: hr_utility.set_location (l_proc, 1580);
2670: END IF;
2671:
2672: fnd_message.set_name ('HXT', 'HXT_39554_ERN_POL_NF');
2673: l_otm_error := fnd_message.get;
2674: otm_error := l_otm_error;
2675: oracle_error := SQLERRM;
2676: call_hxthxc_gen_error ('HXT', 'HXT_39554_ERN_POL_NF', NULL);
2677: --2278400

Line 2686: fnd_message.set_name ('HXT', 'HXT_39555_ERN_POL_SYS_ERR');

2682: THEN
2683: hr_utility.set_location (l_proc, 1590);
2684: END IF;
2685:
2686: fnd_message.set_name ('HXT', 'HXT_39555_ERN_POL_SYS_ERR');
2687: l_otm_error := fnd_message.get;
2688: otm_error := l_otm_error;
2689: oracle_error := SQLERRM;
2690: call_hxthxc_gen_error ('HXT', 'HXT_39555_ERN_POL_SYS_ERR', NULL);

Line 2687: l_otm_error := fnd_message.get;

2683: hr_utility.set_location (l_proc, 1590);
2684: END IF;
2685:
2686: fnd_message.set_name ('HXT', 'HXT_39555_ERN_POL_SYS_ERR');
2687: l_otm_error := fnd_message.get;
2688: otm_error := l_otm_error;
2689: oracle_error := SQLERRM;
2690: call_hxthxc_gen_error ('HXT', 'HXT_39555_ERN_POL_SYS_ERR', NULL);
2691: --2278400

Line 2700: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');

2696: THEN
2697: hr_utility.set_location (l_proc, 1600);
2698: END IF;
2699:
2700: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
2701: l_otm_error := fnd_message.get;
2702: otm_error := l_otm_error;
2703: oracle_error := SQLERRM;
2704: call_hxthxc_gen_error ('HXT', 'HXT_39556_SESSION_DT_NF', NULL);

Line 2701: l_otm_error := fnd_message.get;

2697: hr_utility.set_location (l_proc, 1600);
2698: END IF;
2699:
2700: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
2701: l_otm_error := fnd_message.get;
2702: otm_error := l_otm_error;
2703: oracle_error := SQLERRM;
2704: call_hxthxc_gen_error ('HXT', 'HXT_39556_SESSION_DT_NF', NULL);
2705: --2278400

Line 2714: fnd_message.set_name ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK');

2710: THEN
2711: hr_utility.set_location (l_proc, 1610);
2712: END IF;
2713:
2714: fnd_message.set_name ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK');
2715: l_otm_error := fnd_message.get;
2716: otm_error := l_otm_error;
2717: oracle_error := SQLERRM;
2718: call_hxthxc_gen_error ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK', NULL);

Line 2715: l_otm_error := fnd_message.get;

2711: hr_utility.set_location (l_proc, 1610);
2712: END IF;
2713:
2714: fnd_message.set_name ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK');
2715: l_otm_error := fnd_message.get;
2716: otm_error := l_otm_error;
2717: oracle_error := SQLERRM;
2718: call_hxthxc_gen_error ('HXT', 'HXT_39557_NO_TIME_IN_DT_WRK', NULL);
2719: --2278400

Line 2728: fnd_message.set_name ('HXT', 'HXT_39558_ERR_IN_DSR');

2724: THEN
2725: hr_utility.set_location (l_proc, 1620);
2726: END IF;
2727:
2728: fnd_message.set_name ('HXT', 'HXT_39558_ERR_IN_DSR');
2729: l_otm_error := fnd_message.get;
2730: otm_error := l_otm_error;
2731: oracle_error := SQLERRM;
2732: -- Removed for bug 3868006

Line 2729: l_otm_error := fnd_message.get;

2725: hr_utility.set_location (l_proc, 1620);
2726: END IF;
2727:
2728: fnd_message.set_name ('HXT', 'HXT_39558_ERR_IN_DSR');
2729: l_otm_error := fnd_message.get;
2730: otm_error := l_otm_error;
2731: oracle_error := SQLERRM;
2732: -- Removed for bug 3868006
2733: -- call_hxthxc_gen_error ('HXT', 'HXT_39558_ERR_IN_DSR', NULL); --2278400

Line 2751: fnd_message.set_name ('HXT', 'HXT_39559_DT_UPD_MODE_INV');

2747: THEN
2748: hr_utility.set_location (l_proc, 1640);
2749: END IF;
2750:
2751: fnd_message.set_name ('HXT', 'HXT_39559_DT_UPD_MODE_INV');
2752: fnd_message.set_token ('DT_UPD_MODE', dt_update_mode);
2753: l_otm_error := fnd_message.get;
2754: otm_error := l_otm_error;
2755: oracle_error := '';

Line 2752: fnd_message.set_token ('DT_UPD_MODE', dt_update_mode);

2748: hr_utility.set_location (l_proc, 1640);
2749: END IF;
2750:
2751: fnd_message.set_name ('HXT', 'HXT_39559_DT_UPD_MODE_INV');
2752: fnd_message.set_token ('DT_UPD_MODE', dt_update_mode);
2753: l_otm_error := fnd_message.get;
2754: otm_error := l_otm_error;
2755: oracle_error := '';
2756: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);

Line 2753: l_otm_error := fnd_message.get;

2749: END IF;
2750:
2751: fnd_message.set_name ('HXT', 'HXT_39559_DT_UPD_MODE_INV');
2752: fnd_message.set_token ('DT_UPD_MODE', dt_update_mode);
2753: l_otm_error := fnd_message.get;
2754: otm_error := l_otm_error;
2755: oracle_error := '';
2756: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', l_otm_error);
2757: --2278400

Line 2767: fnd_message.set_name ('HXT', 'HXT_39560_DT_UPD_MODE_NULL');

2763: THEN
2764: hr_utility.set_location (l_proc, 1650);
2765: END IF;
2766:
2767: fnd_message.set_name ('HXT', 'HXT_39560_DT_UPD_MODE_NULL');
2768: l_otm_error := fnd_message.get;
2769: otm_error := l_otm_error;
2770: oracle_error := '';
2771: call_hxthxc_gen_error ('HXT', 'HXT_39560_DT_UPD_MODE_NULL', NULL);

Line 2768: l_otm_error := fnd_message.get;

2764: hr_utility.set_location (l_proc, 1650);
2765: END IF;
2766:
2767: fnd_message.set_name ('HXT', 'HXT_39560_DT_UPD_MODE_NULL');
2768: l_otm_error := fnd_message.get;
2769: otm_error := l_otm_error;
2770: oracle_error := '';
2771: call_hxthxc_gen_error ('HXT', 'HXT_39560_DT_UPD_MODE_NULL', NULL);
2772: --2278400

Line 2784: fnd_message.set_name ('HXT', 'HXT_39406_EXCP_REC_TIME');

2780:
2781: -- GPM v115.23
2782: IF (l_otm_error IS NULL)
2783: THEN
2784: fnd_message.set_name ('HXT', 'HXT_39406_EXCP_REC_TIME');
2785: l_otm_error := fnd_message.get;
2786: END IF;
2787:
2788: otm_error := l_otm_error;

Line 2785: l_otm_error := fnd_message.get;

2781: -- GPM v115.23
2782: IF (l_otm_error IS NULL)
2783: THEN
2784: fnd_message.set_name ('HXT', 'HXT_39406_EXCP_REC_TIME');
2785: l_otm_error := fnd_message.get;
2786: END IF;
2787:
2788: otm_error := l_otm_error;
2789:

Line 3105: fnd_message.set_name ('HXT', 'HXT_39561_CANNOT_FIND_TCARD');

3101: END LOOP;
3102: EXCEPTION
3103: WHEN l_tim_not_found_err
3104: THEN
3105: fnd_message.set_name ('HXT', 'HXT_39561_CANNOT_FIND_TCARD');
3106: fnd_message.set_token ('TIM_ID', TO_CHAR (timecard_id));
3107: otm_error := fnd_message.get;
3108: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3109: --2278400

Line 3106: fnd_message.set_token ('TIM_ID', TO_CHAR (timecard_id));

3102: EXCEPTION
3103: WHEN l_tim_not_found_err
3104: THEN
3105: fnd_message.set_name ('HXT', 'HXT_39561_CANNOT_FIND_TCARD');
3106: fnd_message.set_token ('TIM_ID', TO_CHAR (timecard_id));
3107: otm_error := fnd_message.get;
3108: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3109: --2278400
3110: WHEN l_rec_hours_data_err

Line 3107: otm_error := fnd_message.get;

3103: WHEN l_tim_not_found_err
3104: THEN
3105: fnd_message.set_name ('HXT', 'HXT_39561_CANNOT_FIND_TCARD');
3106: fnd_message.set_token ('TIM_ID', TO_CHAR (timecard_id));
3107: otm_error := fnd_message.get;
3108: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3109: --2278400
3110: WHEN l_rec_hours_data_err
3111: THEN

Line 3112: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');

3108: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3109: --2278400
3110: WHEN l_rec_hours_data_err
3111: THEN
3112: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3113: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3114: otm_error := fnd_message.get;
3115: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3116: WHEN l_rec_hours_sys_err

Line 3113: fnd_message.set_token ('ERR_TEXT', l_otm_error);

3109: --2278400
3110: WHEN l_rec_hours_data_err
3111: THEN
3112: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3113: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3114: otm_error := fnd_message.get;
3115: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3116: WHEN l_rec_hours_sys_err
3117: THEN

Line 3114: otm_error := fnd_message.get;

3110: WHEN l_rec_hours_data_err
3111: THEN
3112: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3113: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3114: otm_error := fnd_message.get;
3115: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3116: WHEN l_rec_hours_sys_err
3117: THEN
3118: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');

Line 3118: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');

3114: otm_error := fnd_message.get;
3115: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3116: WHEN l_rec_hours_sys_err
3117: THEN
3118: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3119: fnd_message.set_token ('ERR_TEXT', l_oracle_error);
3120: oracle_error := fnd_message.get;
3121: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',oracle_error); --2278400
3122: --begin SIR334

Line 3119: fnd_message.set_token ('ERR_TEXT', l_oracle_error);

3115: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3116: WHEN l_rec_hours_sys_err
3117: THEN
3118: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3119: fnd_message.set_token ('ERR_TEXT', l_oracle_error);
3120: oracle_error := fnd_message.get;
3121: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',oracle_error); --2278400
3122: --begin SIR334
3123: WHEN l_delete_details_err

Line 3120: oracle_error := fnd_message.get;

3116: WHEN l_rec_hours_sys_err
3117: THEN
3118: fnd_message.set_name ('HXT', 'HXT_39562_ERR_IN_RET');
3119: fnd_message.set_token ('ERR_TEXT', l_oracle_error);
3120: oracle_error := fnd_message.get;
3121: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',oracle_error); --2278400
3122: --begin SIR334
3123: WHEN l_delete_details_err
3124: THEN

Line 3125: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');

3121: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',oracle_error); --2278400
3122: --begin SIR334
3123: WHEN l_delete_details_err
3124: THEN
3125: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
3126: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3127: otm_error := fnd_message.get;
3128: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3129: WHEN l_sess_date_err

Line 3126: fnd_message.set_token ('ERR_TEXT', l_otm_error);

3122: --begin SIR334
3123: WHEN l_delete_details_err
3124: THEN
3125: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
3126: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3127: otm_error := fnd_message.get;
3128: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3129: WHEN l_sess_date_err
3130: THEN

Line 3127: otm_error := fnd_message.get;

3123: WHEN l_delete_details_err
3124: THEN
3125: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
3126: fnd_message.set_token ('ERR_TEXT', l_otm_error);
3127: otm_error := fnd_message.get;
3128: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3129: WHEN l_sess_date_err
3130: THEN
3131: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');

Line 3131: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');

3127: otm_error := fnd_message.get;
3128: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3129: WHEN l_sess_date_err
3130: THEN
3131: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
3132: otm_error := fnd_message.get;
3133: oracle_error := SQLERRM;
3134: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3135: --2278400

Line 3132: otm_error := fnd_message.get;

3128: --call_hxthxc_gen_error('HXC','HXC_HXT_DEP_VAL_OTMERR',otm_error); --2278400
3129: WHEN l_sess_date_err
3130: THEN
3131: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
3132: otm_error := fnd_message.get;
3133: oracle_error := SQLERRM;
3134: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', otm_error);
3135: --2278400
3136: --end SIR334

Line 3139: fnd_message.set_name ('HXT', 'HXT_39564_EXCP_IN_RET');

3135: --2278400
3136: --end SIR334
3137: WHEN OTHERS
3138: THEN
3139: fnd_message.set_name ('HXT', 'HXT_39564_EXCP_IN_RET');
3140: otm_error := fnd_message.get;
3141: oracle_error := SQLERRM;
3142: call_hxthxc_gen_error ('HXT', 'HXT_39564_EXCP_IN_RET', NULL);
3143: --2278400

Line 3140: otm_error := fnd_message.get;

3136: --end SIR334
3137: WHEN OTHERS
3138: THEN
3139: fnd_message.set_name ('HXT', 'HXT_39564_EXCP_IN_RET');
3140: otm_error := fnd_message.get;
3141: oracle_error := SQLERRM;
3142: call_hxthxc_gen_error ('HXT', 'HXT_39564_EXCP_IN_RET', NULL);
3143: --2278400
3144: END re_explode_timecard;

Line 3627: fnd_message.set_name ('HXT', 'HXT_39409_CREATE_BATCH');

3623: RETURN 0;
3624: EXCEPTION
3625: WHEN l_batch_id_error
3626: THEN
3627: fnd_message.set_name ('HXT', 'HXT_39409_CREATE_BATCH');
3628: call_hxthxc_gen_error ('HXT', 'HXT_39409_CREATE_BATCH', NULL);
3629: --2278400
3630: RETURN 2;
3631: WHEN l_reference_num_error

Line 3633: fnd_message.set_name ('HXT', 'HXT_39410_CREATE_REF_FUNC');

3629: --2278400
3630: RETURN 2;
3631: WHEN l_reference_num_error
3632: THEN
3633: fnd_message.set_name ('HXT', 'HXT_39410_CREATE_REF_FUNC');
3634: call_hxthxc_gen_error ('HXT', 'HXT_39410_CREATE_REF_FUNC', NULL);
3635: --2278400
3636: RETURN l_retcode;
3637: WHEN l_batch_name_error

Line 3639: fnd_message.set_name ('HXT', 'HXT_39484_CREATE_BATCH_NAME');

3635: --2278400
3636: RETURN l_retcode;
3637: WHEN l_batch_name_error
3638: THEN
3639: fnd_message.set_name ('HXT', 'HXT_39484_CREATE_BATCH_NAME');
3640: call_hxthxc_gen_error ('HXT', 'HXT_39484_CREATE_BATCH_NAME', NULL);
3641: --2278400
3642: RETURN l_retcode;
3643: WHEN OTHERS

Line 3645: fnd_message.set_name ('HXT', 'HXT_39411_CREATE_BATCH_FUNC');

3641: --2278400
3642: RETURN l_retcode;
3643: WHEN OTHERS
3644: THEN
3645: fnd_message.set_name ('HXT', 'HXT_39411_CREATE_BATCH_FUNC');
3646: call_hxthxc_gen_error ('HXT', 'HXT_39411_CREATE_BATCH_FUNC', NULL);
3647: --2278400
3648: RETURN 2;
3649: END create_batch;

Line 3740: fnd_message.set_name ('HXT', 'HXT_39412_FIND_BATCH_FUNC');

3736: RETURN l_batch_id;
3737: EXCEPTION
3738: WHEN OTHERS
3739: THEN
3740: fnd_message.set_name ('HXT', 'HXT_39412_FIND_BATCH_FUNC');
3741: call_hxthxc_gen_error ('HXT', 'HXT_39412_FIND_BATCH_FUNC', NULL);
3742: RETURN NULL;
3743: END find_existing_batch;
3744:

Line 4084: fnd_message.set_name ('HXT', 'HXT_39565_ERR_IN_CHH');

4080: THEN
4081: hr_utility.set_location (l_proc, 190);
4082: END IF;
4083:
4084: fnd_message.set_name ('HXT', 'HXT_39565_ERR_IN_CHH');
4085: o_otm_error := fnd_message.get;
4086: o_oracle_error := SQLERRM;
4087: call_hxthxc_gen_error ('HXT', 'HXT_39565_ERR_IN_CHH', NULL);
4088: --2278400

Line 4085: o_otm_error := fnd_message.get;

4081: hr_utility.set_location (l_proc, 190);
4082: END IF;
4083:
4084: fnd_message.set_name ('HXT', 'HXT_39565_ERR_IN_CHH');
4085: o_otm_error := fnd_message.get;
4086: o_oracle_error := SQLERRM;
4087: call_hxthxc_gen_error ('HXT', 'HXT_39565_ERR_IN_CHH', NULL);
4088: --2278400
4089: RETURN 1;

Line 4097: fnd_message.set_name ('HXT', 'HXT_39413_LOC_HOL');

4093: THEN
4094: hr_utility.set_location (l_proc, 200);
4095: END IF;
4096:
4097: fnd_message.set_name ('HXT', 'HXT_39413_LOC_HOL');
4098: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
4099: o_otm_error := fnd_message.get;
4100: o_oracle_error := SQLERRM;
4101: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);

Line 4098: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));

4094: hr_utility.set_location (l_proc, 200);
4095: END IF;
4096:
4097: fnd_message.set_name ('HXT', 'HXT_39413_LOC_HOL');
4098: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
4099: o_otm_error := fnd_message.get;
4100: o_oracle_error := SQLERRM;
4101: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
4102: --2278400

Line 4099: o_otm_error := fnd_message.get;

4095: END IF;
4096:
4097: fnd_message.set_name ('HXT', 'HXT_39413_LOC_HOL');
4098: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
4099: o_otm_error := fnd_message.get;
4100: o_oracle_error := SQLERRM;
4101: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
4102: --2278400
4103: RETURN 2;

Line 4312: fnd_message.set_name ('HXT', 'HXT_39171_ERN_POL_OP_VIOL');

4308: THEN
4309: hr_utility.set_location (l_proc, 120);
4310: END IF;
4311:
4312: fnd_message.set_name ('HXT', 'HXT_39171_ERN_POL_OP_VIOL');
4313: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4314: p_otm_error := fnd_message.get;
4315: WHEN error_in_shift_info
4316: THEN

Line 4313: fnd_message.set_token ('ORA_ERROR', SQLERRM);

4309: hr_utility.set_location (l_proc, 120);
4310: END IF;
4311:
4312: fnd_message.set_name ('HXT', 'HXT_39171_ERN_POL_OP_VIOL');
4313: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4314: p_otm_error := fnd_message.get;
4315: WHEN error_in_shift_info
4316: THEN
4317: IF g_debug

Line 4314: p_otm_error := fnd_message.get;

4310: END IF;
4311:
4312: fnd_message.set_name ('HXT', 'HXT_39171_ERN_POL_OP_VIOL');
4313: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4314: p_otm_error := fnd_message.get;
4315: WHEN error_in_shift_info
4316: THEN
4317: IF g_debug
4318: THEN

Line 4322: fnd_message.set_name ('HXT', 'HXT_39172_SHF_PREMS_OP_VIOL');

4318: THEN
4319: hr_utility.set_location (l_proc, 130);
4320: END IF;
4321:
4322: fnd_message.set_name ('HXT', 'HXT_39172_SHF_PREMS_OP_VIOL');
4323: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4324: p_otm_error := fnd_message.get;
4325: /*
4326: WHEN error_in_check_hol THEN

Line 4323: fnd_message.set_token ('ORA_ERROR', SQLERRM);

4319: hr_utility.set_location (l_proc, 130);
4320: END IF;
4321:
4322: fnd_message.set_name ('HXT', 'HXT_39172_SHF_PREMS_OP_VIOL');
4323: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4324: p_otm_error := fnd_message.get;
4325: /*
4326: WHEN error_in_check_hol THEN
4327: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');

Line 4324: p_otm_error := fnd_message.get;

4320: END IF;
4321:
4322: fnd_message.set_name ('HXT', 'HXT_39172_SHF_PREMS_OP_VIOL');
4323: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4324: p_otm_error := fnd_message.get;
4325: /*
4326: WHEN error_in_check_hol THEN
4327: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');
4328: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);

Line 4327: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');

4323: fnd_message.set_token ('ORA_ERROR', SQLERRM);
4324: p_otm_error := fnd_message.get;
4325: /*
4326: WHEN error_in_check_hol THEN
4327: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');
4328: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);
4329: p_otm_error := fnd_message.get;
4330: */
4331: END load_policies;

Line 4328: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);

4324: p_otm_error := fnd_message.get;
4325: /*
4326: WHEN error_in_check_hol THEN
4327: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');
4328: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);
4329: p_otm_error := fnd_message.get;
4330: */
4331: END load_policies;
4332:

Line 4329: p_otm_error := fnd_message.get;

4325: /*
4326: WHEN error_in_check_hol THEN
4327: FND_MESSAGE.SET_NAME('HXT','HXT_39173_HOL_OP_VIOL');
4328: FND_MESSAGE.SET_TOKEN('ORA_ERROR',SQLERRM);
4329: p_otm_error := fnd_message.get;
4330: */
4331: END load_policies;
4332:
4333: /*************************************************************************

Line 5354: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');

5350: THEN
5351: hr_utility.set_location (l_proc, 380);
5352: END IF;
5353:
5354: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
5355: fnd_message.set_token ('ERR_TEXT', SQLERRM);
5356: o_error_message := fnd_message.get;
5357: call_hxthxc_gen_error ('HXC',
5358: 'HXC_HXT_DEP_VAL_OTMERR',

Line 5355: fnd_message.set_token ('ERR_TEXT', SQLERRM);

5351: hr_utility.set_location (l_proc, 380);
5352: END IF;
5353:
5354: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
5355: fnd_message.set_token ('ERR_TEXT', SQLERRM);
5356: o_error_message := fnd_message.get;
5357: call_hxthxc_gen_error ('HXC',
5358: 'HXC_HXT_DEP_VAL_OTMERR',
5359: o_error_message

Line 5356: o_error_message := fnd_message.get;

5352: END IF;
5353:
5354: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
5355: fnd_message.set_token ('ERR_TEXT', SQLERRM);
5356: o_error_message := fnd_message.get;
5357: call_hxthxc_gen_error ('HXC',
5358: 'HXC_HXT_DEP_VAL_OTMERR',
5359: o_error_message
5360: ); --2278400

Line 5532: fnd_message.set_name ('HXT', 'HXT_39414_LOC_ADDL_ASG');

5528: THEN
5529: hr_utility.set_location (l_proc, 450);
5530: END IF;
5531:
5532: fnd_message.set_name ('HXT', 'HXT_39414_LOC_ADDL_ASG');
5533: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5534: o_otm_error := fnd_message.get;
5535: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5536: --2278400

Line 5533: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));

5529: hr_utility.set_location (l_proc, 450);
5530: END IF;
5531:
5532: fnd_message.set_name ('HXT', 'HXT_39414_LOC_ADDL_ASG');
5533: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5534: o_otm_error := fnd_message.get;
5535: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5536: --2278400
5537: RETURN 1;

Line 5534: o_otm_error := fnd_message.get;

5530: END IF;
5531:
5532: fnd_message.set_name ('HXT', 'HXT_39414_LOC_ADDL_ASG');
5533: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5534: o_otm_error := fnd_message.get;
5535: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5536: --2278400
5537: RETURN 1;
5538: WHEN l_details_system_error

Line 5545: fnd_message.set_name ('HXT', 'HXT_39415_FETCH_ASG_DET');

5541: THEN
5542: hr_utility.set_location (l_proc, 460);
5543: END IF;
5544:
5545: fnd_message.set_name ('HXT', 'HXT_39415_FETCH_ASG_DET');
5546: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5547: o_otm_error := fnd_message.get;
5548: o_oracle_error := SQLERRM;
5549: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);

Line 5546: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));

5542: hr_utility.set_location (l_proc, 460);
5543: END IF;
5544:
5545: fnd_message.set_name ('HXT', 'HXT_39415_FETCH_ASG_DET');
5546: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5547: o_otm_error := fnd_message.get;
5548: o_oracle_error := SQLERRM;
5549: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5550: --2278400

Line 5547: o_otm_error := fnd_message.get;

5543: END IF;
5544:
5545: fnd_message.set_name ('HXT', 'HXT_39415_FETCH_ASG_DET');
5546: fnd_message.set_token ('ASG_ID', TO_CHAR (i_assignment_id));
5547: o_otm_error := fnd_message.get;
5548: o_oracle_error := SQLERRM;
5549: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5550: --2278400
5551: RETURN 2;

Line 5559: fnd_message.set_name ('HXT', 'HXT_39445_CHG_DATE');

5555: THEN
5556: hr_utility.set_location (l_proc, 470);
5557: END IF;
5558:
5559: fnd_message.set_name ('HXT', 'HXT_39445_CHG_DATE');
5560: o_otm_error := fnd_message.get;
5561: o_oracle_error := SQLERRM;
5562: call_hxthxc_gen_error ('HXT', 'HXT_39445_CHG_DATE', NULL); --2278400
5563: RETURN 1;

Line 5560: o_otm_error := fnd_message.get;

5556: hr_utility.set_location (l_proc, 470);
5557: END IF;
5558:
5559: fnd_message.set_name ('HXT', 'HXT_39445_CHG_DATE');
5560: o_otm_error := fnd_message.get;
5561: o_oracle_error := SQLERRM;
5562: call_hxthxc_gen_error ('HXT', 'HXT_39445_CHG_DATE', NULL); --2278400
5563: RETURN 1;
5564: WHEN l_hours_worked_id_error

Line 5571: fnd_message.set_name ('HXT', 'HXT_39416_GET_HRW_ID');

5567: THEN
5568: hr_utility.set_location (l_proc, 480);
5569: END IF;
5570:
5571: fnd_message.set_name ('HXT', 'HXT_39416_GET_HRW_ID');
5572: o_otm_error := fnd_message.get;
5573: o_oracle_error := SQLERRM;
5574: call_hxthxc_gen_error ('HXT', 'HXT_39416_GET_HRW_ID', NULL);
5575: --2278400

Line 5572: o_otm_error := fnd_message.get;

5568: hr_utility.set_location (l_proc, 480);
5569: END IF;
5570:
5571: fnd_message.set_name ('HXT', 'HXT_39416_GET_HRW_ID');
5572: o_otm_error := fnd_message.get;
5573: o_oracle_error := SQLERRM;
5574: call_hxthxc_gen_error ('HXT', 'HXT_39416_GET_HRW_ID', NULL);
5575: --2278400
5576: RETURN 2;

Line 5584: --fnd_message.set_name ('HXT', 'HXT_39417_PROB_GEN_DET');

5580: THEN
5581: hr_utility.set_location (l_proc, 490);
5582: END IF;
5583:
5584: --fnd_message.set_name ('HXT', 'HXT_39417_PROB_GEN_DET');
5585: o_otm_error := fnd_message.get;
5586: --call_hxthxc_gen_error('HXT', 'HXT_39417_PROB_GEN_DET',NULL); --2278400
5587: RETURN 2;
5588: WHEN l_inc_tim_hr_entry_err

Line 5585: o_otm_error := fnd_message.get;

5581: hr_utility.set_location (l_proc, 490);
5582: END IF;
5583:
5584: --fnd_message.set_name ('HXT', 'HXT_39417_PROB_GEN_DET');
5585: o_otm_error := fnd_message.get;
5586: --call_hxthxc_gen_error('HXT', 'HXT_39417_PROB_GEN_DET',NULL); --2278400
5587: RETURN 2;
5588: WHEN l_inc_tim_hr_entry_err
5589: THEN

Line 5595: fnd_message.set_name ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES');

5591: THEN
5592: hr_utility.set_location (l_proc, 495);
5593: END IF;
5594:
5595: fnd_message.set_name ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES');
5596: o_otm_error := fnd_message.get;
5597: call_hxthxc_gen_error ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES', NULL);
5598: --2278400
5599: RETURN 2;

Line 5596: o_otm_error := fnd_message.get;

5592: hr_utility.set_location (l_proc, 495);
5593: END IF;
5594:
5595: fnd_message.set_name ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES');
5596: o_otm_error := fnd_message.get;
5597: call_hxthxc_gen_error ('HXT', 'HXT_39329_INC_TIM_HR_ENTRIES', NULL);
5598: --2278400
5599: RETURN 2;
5600: WHEN l_seq_num_error

Line 5607: fnd_message.set_name ('HXT', 'HXT_39418_GET_HRW_SEQ');

5603: THEN
5604: hr_utility.set_location (l_proc, 500);
5605: END IF;
5606:
5607: fnd_message.set_name ('HXT', 'HXT_39418_GET_HRW_SEQ');
5608: o_otm_error := fnd_message.get;
5609: o_oracle_error := SQLERRM;
5610: call_hxthxc_gen_error ('HXT', 'HXT_39418_GET_HRW_SEQ', NULL);
5611: --2278400

Line 5608: o_otm_error := fnd_message.get;

5604: hr_utility.set_location (l_proc, 500);
5605: END IF;
5606:
5607: fnd_message.set_name ('HXT', 'HXT_39418_GET_HRW_SEQ');
5608: o_otm_error := fnd_message.get;
5609: o_oracle_error := SQLERRM;
5610: call_hxthxc_gen_error ('HXT', 'HXT_39418_GET_HRW_SEQ', NULL);
5611: --2278400
5612: RETURN 2;

Line 5620: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');

5616: THEN
5617: hr_utility.set_location (l_proc, 510);
5618: END IF;
5619:
5620: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
5621: fnd_message.set_token ('ERR_TEXT', l_otm_error);
5622: o_otm_error := fnd_message.get;
5623: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5624: --2278400

Line 5621: fnd_message.set_token ('ERR_TEXT', l_otm_error);

5617: hr_utility.set_location (l_proc, 510);
5618: END IF;
5619:
5620: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
5621: fnd_message.set_token ('ERR_TEXT', l_otm_error);
5622: o_otm_error := fnd_message.get;
5623: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5624: --2278400
5625: WHEN l_sess_date_err

Line 5622: o_otm_error := fnd_message.get;

5618: END IF;
5619:
5620: fnd_message.set_name ('HXT', 'HXT_39563_ERR_IN_RET_DD');
5621: fnd_message.set_token ('ERR_TEXT', l_otm_error);
5622: o_otm_error := fnd_message.get;
5623: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', o_otm_error);
5624: --2278400
5625: WHEN l_sess_date_err
5626: THEN

Line 5632: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');

5628: THEN
5629: hr_utility.set_location (l_proc, 520);
5630: END IF;
5631:
5632: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
5633: o_otm_error := fnd_message.get;
5634: o_oracle_error := SQLERRM;
5635: call_hxthxc_gen_error ('HXT', 'HXT_39556_SESSION_DT_NF', NULL);
5636: --2278400

Line 5633: o_otm_error := fnd_message.get;

5629: hr_utility.set_location (l_proc, 520);
5630: END IF;
5631:
5632: fnd_message.set_name ('HXT', 'HXT_39556_SESSION_DT_NF');
5633: o_otm_error := fnd_message.get;
5634: o_oracle_error := SQLERRM;
5635: call_hxthxc_gen_error ('HXT', 'HXT_39556_SESSION_DT_NF', NULL);
5636: --2278400
5637: WHEN l_retro_edit_err

Line 5660: fnd_message.set_name ('HXT', 'HXT_39419_SYSERR_RECFUNC');

5656: THEN
5657: hr_utility.set_location (l_proc, 540);
5658: END IF;
5659:
5660: fnd_message.set_name ('HXT', 'HXT_39419_SYSERR_RECFUNC');
5661: o_otm_error := fnd_message.get;
5662: o_oracle_error := SQLERRM;
5663: call_hxthxc_gen_error ('HXT', 'HXT_39419_SYSERR_RECFUNC', NULL);
5664: --2278400

Line 5661: o_otm_error := fnd_message.get;

5657: hr_utility.set_location (l_proc, 540);
5658: END IF;
5659:
5660: fnd_message.set_name ('HXT', 'HXT_39419_SYSERR_RECFUNC');
5661: o_otm_error := fnd_message.get;
5662: o_oracle_error := SQLERRM;
5663: call_hxthxc_gen_error ('HXT', 'HXT_39419_SYSERR_RECFUNC', NULL);
5664: --2278400
5665: RETURN 2;

Line 5803: fnd_message.set_name ('HXT', 'HXT_39566_ERR_IN_CAE');

5799: o_otm_error := l_otm_error;
5800: o_oracle_error := SQLERRM;
5801: WHEN OTHERS
5802: THEN
5803: fnd_message.set_name ('HXT', 'HXT_39566_ERR_IN_CAE');
5804: l_otm_error := fnd_message.get;
5805: o_otm_error := l_otm_error;
5806: o_oracle_error := SQLERRM;
5807: call_hxthxc_gen_error ('HXT', 'HXT_39566_ERR_IN_CAE', NULL);

Line 5804: l_otm_error := fnd_message.get;

5800: o_oracle_error := SQLERRM;
5801: WHEN OTHERS
5802: THEN
5803: fnd_message.set_name ('HXT', 'HXT_39566_ERR_IN_CAE');
5804: l_otm_error := fnd_message.get;
5805: o_otm_error := l_otm_error;
5806: o_oracle_error := SQLERRM;
5807: call_hxthxc_gen_error ('HXT', 'HXT_39566_ERR_IN_CAE', NULL);
5808: --2278400

Line 6010: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');

6006: END IF; -- Update or Correction
6007: EXCEPTION
6008: WHEN OTHERS
6009: THEN
6010: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
6011: fnd_message.set_token ('ERR_TEXT', SQLERRM);
6012: o_error_message := fnd_message.get;
6013: call_hxthxc_gen_error ('HXC',
6014: 'HXC_HXT_DEP_VAL_OTMERR',

Line 6011: fnd_message.set_token ('ERR_TEXT', SQLERRM);

6007: EXCEPTION
6008: WHEN OTHERS
6009: THEN
6010: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
6011: fnd_message.set_token ('ERR_TEXT', SQLERRM);
6012: o_error_message := fnd_message.get;
6013: call_hxthxc_gen_error ('HXC',
6014: 'HXC_HXT_DEP_VAL_OTMERR',
6015: o_error_message

Line 6012: o_error_message := fnd_message.get;

6008: WHEN OTHERS
6009: THEN
6010: fnd_message.set_name ('HXT', 'HXT_39567_ERR_IN_DD');
6011: fnd_message.set_token ('ERR_TEXT', SQLERRM);
6012: o_error_message := fnd_message.get;
6013: call_hxthxc_gen_error ('HXC',
6014: 'HXC_HXT_DEP_VAL_OTMERR',
6015: o_error_message
6016: ); --2278400

Line 6691: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');

6687: THEN
6688: hr_utility.set_location (l_proc, 210);
6689: END IF;
6690:
6691: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');
6692: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));
6693: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
6694: fnd_message.set_token ('DT_WRK',
6695: TO_CHAR (p_date_worked, 'DD-MON-YYYY')

Line 6692: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));

6688: hr_utility.set_location (l_proc, 210);
6689: END IF;
6690:
6691: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');
6692: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));
6693: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
6694: fnd_message.set_token ('DT_WRK',
6695: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
6696: );

Line 6693: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));

6689: END IF;
6690:
6691: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');
6692: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));
6693: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
6694: fnd_message.set_token ('DT_WRK',
6695: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
6696: );
6697: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));

Line 6694: fnd_message.set_token ('DT_WRK',

6690:
6691: fnd_message.set_name ('HXT', 'HXT_39598_IN_OUT_TIME_OVERLAP');
6692: fnd_message.set_token ('TIME_IN', TO_CHAR (p_time_in, 'HH24MI'));
6693: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
6694: fnd_message.set_token ('DT_WRK',
6695: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
6696: );
6697: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));
6698: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));

Line 6697: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));

6693: fnd_message.set_token ('TIME_OUT', TO_CHAR (p_time_out, 'HH24MI'));
6694: fnd_message.set_token ('DT_WRK',
6695: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
6696: );
6697: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));
6698: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));
6699: p_error := fnd_message.get;
6700: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
6701: --2278400

Line 6698: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));

6694: fnd_message.set_token ('DT_WRK',
6695: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
6696: );
6697: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));
6698: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));
6699: p_error := fnd_message.get;
6700: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
6701: --2278400
6702: p_code := 1;

Line 6699: p_error := fnd_message.get;

6695: TO_CHAR (p_date_worked, 'DD-MON-YYYY')
6696: );
6697: fnd_message.set_token ('TIM_ID', TO_CHAR (p_tim_id));
6698: fnd_message.set_token ('SUM_ID', TO_CHAR (p_hours_id));
6699: p_error := fnd_message.get;
6700: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
6701: --2278400
6702: p_code := 1;
6703: RETURN;

Line 6755: fnd_message.set_name ('HXT', 'HXT_39600_INVALID_ENTRIES');

6751: THEN
6752: hr_utility.set_location (l_proc, 220);
6753: END IF;
6754:
6755: fnd_message.set_name ('HXT', 'HXT_39600_INVALID_ENTRIES');
6756: p_error := fnd_message.get;
6757: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
6758: --2278400
6759: p_code := 1;

Line 6756: p_error := fnd_message.get;

6752: hr_utility.set_location (l_proc, 220);
6753: END IF;
6754:
6755: fnd_message.set_name ('HXT', 'HXT_39600_INVALID_ENTRIES');
6756: p_error := fnd_message.get;
6757: call_hxthxc_gen_error ('HXC', 'HXC_HXT_DEP_VAL_OTMERR', p_error);
6758: --2278400
6759: p_code := 1;
6760: RETURN;