DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on FND_MESSAGE

Line 120: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');

116:
117: IF get_lookup_code_cur%NOTFOUND
118: THEN
119:
120: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
121: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
122: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
123: -- RAISE g_lookup_not_found;
124: NULL; -- This is to fix bug 1761779. Fassadi 16-may-2001

Line 121: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00

117: IF get_lookup_code_cur%NOTFOUND
118: THEN
119:
120: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
121: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
122: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
123: -- RAISE g_lookup_not_found;
124: NULL; -- This is to fix bug 1761779. Fassadi 16-may-2001
125: END IF;

Line 122: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00

118: THEN
119:
120: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
121: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
122: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
123: -- RAISE g_lookup_not_found;
124: NULL; -- This is to fix bug 1761779. Fassadi 16-may-2001
125: END IF;
126: ELSE

Line 174: fnd_message.set_name ('HXT', 'HXT_39483_LOOKUP_NOT_FOUND');

170: FETCH get_meaning_cur INTO l_meaning;
171:
172: IF get_meaning_cur%NOTFOUND
173: THEN
174: fnd_message.set_name ('HXT', 'HXT_39483_LOOKUP_NOT_FOUND');
175: fnd_message.set_token ('CODE', p_lookup_code);
176: fnd_message.set_token ('TYPE', p_lookup_type);
177: RAISE g_lookup_not_found;
178: END IF;

Line 175: fnd_message.set_token ('CODE', p_lookup_code);

171:
172: IF get_meaning_cur%NOTFOUND
173: THEN
174: fnd_message.set_name ('HXT', 'HXT_39483_LOOKUP_NOT_FOUND');
175: fnd_message.set_token ('CODE', p_lookup_code);
176: fnd_message.set_token ('TYPE', p_lookup_type);
177: RAISE g_lookup_not_found;
178: END IF;
179: ELSE

Line 176: fnd_message.set_token ('TYPE', p_lookup_type);

172: IF get_meaning_cur%NOTFOUND
173: THEN
174: fnd_message.set_name ('HXT', 'HXT_39483_LOOKUP_NOT_FOUND');
175: fnd_message.set_token ('CODE', p_lookup_code);
176: fnd_message.set_token ('TYPE', p_lookup_type);
177: RAISE g_lookup_not_found;
178: END IF;
179: ELSE
180: l_meaning := p_lookup_code;

Line 938: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');

934: WHEN OTHERS
935: THEN
936: hxt_util.DEBUG (SQLERRM); --HXT115
937: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
938: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
939: fnd_message.set_token ('SQLERR', SQLERRM);
940: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
941: END insert_pay_batch_lines;
942:

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

935: THEN
936: hxt_util.DEBUG (SQLERRM); --HXT115
937: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
938: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
939: fnd_message.set_token ('SQLERR', SQLERRM);
940: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
941: END insert_pay_batch_lines;
942:
943:

Line 2159: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111

2155: THEN --SIR517 PWM 18FEB00
2156: hxt_util.DEBUG (
2157: 'Oops...g_lookup_not_found in procedure retro_sum_to_mix'
2158: ); --HXT115
2159: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2160: hxt_batch_process.insert_pay_batch_errors (
2161: p_batch_id,
2162: 'VE', -- RETROPAY
2163: '',

Line 2170: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111

2166: RETURN;
2167: WHEN g_error_ins_batch_lines
2168: THEN --SIR517 PWM 18FEB00
2169: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115
2170: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111
2171: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
2172: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2173: hxt_batch_process.insert_pay_batch_errors (
2174: p_batch_id,

Line 2171: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111

2167: WHEN g_error_ins_batch_lines
2168: THEN --SIR517 PWM 18FEB00
2169: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115
2170: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111
2171: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
2172: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2173: hxt_batch_process.insert_pay_batch_errors (
2174: p_batch_id,
2175: 'VE', -- RETROPAY

Line 2172: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111

2168: THEN --SIR517 PWM 18FEB00
2169: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115
2170: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111
2171: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
2172: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2173: hxt_batch_process.insert_pay_batch_errors (
2174: p_batch_id,
2175: 'VE', -- RETROPAY
2176: '',

Line 2192: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111

2188: ); -- debug only --HXT115
2189: p_sum_retcode := 3;
2190:
2191: --HXT111 p_err_buf := substr(' exception received at '||l_location||'. '||sqlerrm,1,65);
2192: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111
2193: fnd_message.set_token ('LOCATION', l_location); --HXT111
2194: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
2195: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2196: hxt_batch_process.insert_pay_batch_errors (

Line 2193: fnd_message.set_token ('LOCATION', l_location); --HXT111

2189: p_sum_retcode := 3;
2190:
2191: --HXT111 p_err_buf := substr(' exception received at '||l_location||'. '||sqlerrm,1,65);
2192: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111
2193: fnd_message.set_token ('LOCATION', l_location); --HXT111
2194: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
2195: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2196: hxt_batch_process.insert_pay_batch_errors (
2197: p_batch_id,

Line 2194: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111

2190:
2191: --HXT111 p_err_buf := substr(' exception received at '||l_location||'. '||sqlerrm,1,65);
2192: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111
2193: fnd_message.set_token ('LOCATION', l_location); --HXT111
2194: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
2195: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2196: hxt_batch_process.insert_pay_batch_errors (
2197: p_batch_id,
2198: 'VE', -- RETROPAY

Line 2195: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111

2191: --HXT111 p_err_buf := substr(' exception received at '||l_location||'. '||sqlerrm,1,65);
2192: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111
2193: fnd_message.set_token ('LOCATION', l_location); --HXT111
2194: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
2195: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
2196: hxt_batch_process.insert_pay_batch_errors (
2197: p_batch_id,
2198: 'VE', -- RETROPAY
2199: