DBA Data[Home] [Help]

APPS.HXT_RETRO_MIX dependencies on FND_MESSAGE

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

88:
89: IF get_lookup_code_cur%NOTFOUND
90: THEN
91:
92: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
93: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
94: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
95: -- RAISE g_lookup_not_found;
96: NULL; -- This is to fix bug 1761779. Fassadi 16-may-2001

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

89: IF get_lookup_code_cur%NOTFOUND
90: THEN
91:
92: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
93: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
94: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
95: -- RAISE g_lookup_not_found;
96: NULL; -- This is to fix bug 1761779. Fassadi 16-may-2001
97: END IF;

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

90: THEN
91:
92: -- FND_MESSAGE.SET_NAME('HXT','HXT_39483_LOOKUP_NOT_FOUND');
93: -- FND_MESSAGE.SET_TOKEN('CODE', p_meaning); --SIR517 PWM 18FEB00
94: -- FND_MESSAGE.SET_TOKEN('TYPE', 'NAME_TRANSLATIONS'); --SIR517 PWM 18FEB00
95: -- RAISE g_lookup_not_found;
96: NULL; -- This is to fix bug 1761779. Fassadi 16-may-2001
97: END IF;
98: ELSE

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

138: FETCH get_meaning_cur INTO l_meaning;
139:
140: IF get_meaning_cur%NOTFOUND
141: THEN
142: fnd_message.set_name ('HXT', 'HXT_39483_LOOKUP_NOT_FOUND');
143: fnd_message.set_token ('CODE', p_lookup_code);
144: fnd_message.set_token ('TYPE', p_lookup_type);
145: RAISE g_lookup_not_found;
146: END IF;

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

139:
140: IF get_meaning_cur%NOTFOUND
141: THEN
142: fnd_message.set_name ('HXT', 'HXT_39483_LOOKUP_NOT_FOUND');
143: fnd_message.set_token ('CODE', p_lookup_code);
144: fnd_message.set_token ('TYPE', p_lookup_type);
145: RAISE g_lookup_not_found;
146: END IF;
147: ELSE

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

140: IF get_meaning_cur%NOTFOUND
141: THEN
142: fnd_message.set_name ('HXT', 'HXT_39483_LOOKUP_NOT_FOUND');
143: fnd_message.set_token ('CODE', p_lookup_code);
144: fnd_message.set_token ('TYPE', p_lookup_type);
145: RAISE g_lookup_not_found;
146: END IF;
147: ELSE
148: l_meaning := p_lookup_code;

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

747: WHEN OTHERS
748: THEN
749: hxt_util.DEBUG (SQLERRM); --HXT115
750: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
751: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
752: fnd_message.set_token ('SQLERR', SQLERRM);
753: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
754: END insert_pay_batch_lines;
755:

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

748: THEN
749: hxt_util.DEBUG (SQLERRM); --HXT115
750: hxt_util.DEBUG ('Oops...others in insert_pay_batch_lines'); --HXT115
751: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO');
752: fnd_message.set_token ('SQLERR', SQLERRM);
753: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
754: END insert_pay_batch_lines;
755:
756:

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

1804: THEN --SIR517 PWM 18FEB00
1805: hxt_util.DEBUG (
1806: 'Oops...g_lookup_not_found in procedure retro_sum_to_mix'
1807: ); --HXT115
1808: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1809: hxt_batch_process.insert_pay_batch_errors (
1810: p_batch_id,
1811: 'VE', -- RETROPAY
1812: '',

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

1815: RETURN;
1816: WHEN g_error_ins_batch_lines
1817: THEN --SIR517 PWM 18FEB00
1818: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115
1819: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111
1820: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
1821: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1822: hxt_batch_process.insert_pay_batch_errors (
1823: p_batch_id,

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

1816: WHEN g_error_ins_batch_lines
1817: THEN --SIR517 PWM 18FEB00
1818: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115
1819: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111
1820: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
1821: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1822: hxt_batch_process.insert_pay_batch_errors (
1823: p_batch_id,
1824: 'VE', -- RETROPAY

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

1817: THEN --SIR517 PWM 18FEB00
1818: hxt_util.DEBUG ('Error attempting to insert paymix information'); -- debug only --HXT115
1819: fnd_message.set_name ('HXT', 'HXT_39354_ERR_INS_PAYMX_INFO'); --HXT111
1820: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
1821: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1822: hxt_batch_process.insert_pay_batch_errors (
1823: p_batch_id,
1824: 'VE', -- RETROPAY
1825: '',

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

1837: ); -- debug only --HXT115
1838: p_sum_retcode := 3;
1839:
1840: --HXT111 p_err_buf := substr(' exception received at '||l_location||'. '||sqlerrm,1,65);
1841: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111
1842: fnd_message.set_token ('LOCATION', l_location); --HXT111
1843: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
1844: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1845: hxt_batch_process.insert_pay_batch_errors (

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

1838: p_sum_retcode := 3;
1839:
1840: --HXT111 p_err_buf := substr(' exception received at '||l_location||'. '||sqlerrm,1,65);
1841: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111
1842: fnd_message.set_token ('LOCATION', l_location); --HXT111
1843: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
1844: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1845: hxt_batch_process.insert_pay_batch_errors (
1846: p_batch_id,

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

1839:
1840: --HXT111 p_err_buf := substr(' exception received at '||l_location||'. '||sqlerrm,1,65);
1841: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111
1842: fnd_message.set_token ('LOCATION', l_location); --HXT111
1843: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
1844: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1845: hxt_batch_process.insert_pay_batch_errors (
1846: p_batch_id,
1847: 'VE', -- RETROPAY

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

1840: --HXT111 p_err_buf := substr(' exception received at '||l_location||'. '||sqlerrm,1,65);
1841: fnd_message.set_name ('HXT', 'HXT_39453_EXCPT_RCVD_AT'); --HXT111
1842: fnd_message.set_token ('LOCATION', l_location); --HXT111
1843: fnd_message.set_token ('SQLERR', SQLERRM); --HXT111
1844: p_err_buf := SUBSTR (fnd_message.get, 1, 65); --HXT111
1845: hxt_batch_process.insert_pay_batch_errors (
1846: p_batch_id,
1847: 'VE', -- RETROPAY
1848: