61:
62: EXCEPTION
63: WHEN OTHERS THEN
64: --HXT11o_error_message := 'Error('||SQLERRM||') occured creating in Define Reference Number (person id: '||TO_CHAR(i_person_id)||')';
65: fnd_message.set_name('HXT','HXT_39299_ERR_CRT_REF_NUM'); --HXT11
66: fnd_message.set_token('SQLERR',SQLERRM); --HXT11
67: fnd_message.set_token('PERSON_ID',TO_CHAR(i_person_id)); --HXT11
68: o_error_message := FND_MESSAGE.GET; --HXT11
69: FND_MESSAGE.CLEAR; --HXT11
62: EXCEPTION
63: WHEN OTHERS THEN
64: --HXT11o_error_message := 'Error('||SQLERRM||') occured creating in Define Reference Number (person id: '||TO_CHAR(i_person_id)||')';
65: fnd_message.set_name('HXT','HXT_39299_ERR_CRT_REF_NUM'); --HXT11
66: fnd_message.set_token('SQLERR',SQLERRM); --HXT11
67: fnd_message.set_token('PERSON_ID',TO_CHAR(i_person_id)); --HXT11
68: o_error_message := FND_MESSAGE.GET; --HXT11
69: FND_MESSAGE.CLEAR; --HXT11
70:
63: WHEN OTHERS THEN
64: --HXT11o_error_message := 'Error('||SQLERRM||') occured creating in Define Reference Number (person id: '||TO_CHAR(i_person_id)||')';
65: fnd_message.set_name('HXT','HXT_39299_ERR_CRT_REF_NUM'); --HXT11
66: fnd_message.set_token('SQLERR',SQLERRM); --HXT11
67: fnd_message.set_token('PERSON_ID',TO_CHAR(i_person_id)); --HXT11
68: o_error_message := FND_MESSAGE.GET; --HXT11
69: FND_MESSAGE.CLEAR; --HXT11
70:
71: END Define_Reference_Number;
64: --HXT11o_error_message := 'Error('||SQLERRM||') occured creating in Define Reference Number (person id: '||TO_CHAR(i_person_id)||')';
65: fnd_message.set_name('HXT','HXT_39299_ERR_CRT_REF_NUM'); --HXT11
66: fnd_message.set_token('SQLERR',SQLERRM); --HXT11
67: fnd_message.set_token('PERSON_ID',TO_CHAR(i_person_id)); --HXT11
68: o_error_message := FND_MESSAGE.GET; --HXT11
69: FND_MESSAGE.CLEAR; --HXT11
70:
71: END Define_Reference_Number;
72: --BEGIN GLOBAL
65: fnd_message.set_name('HXT','HXT_39299_ERR_CRT_REF_NUM'); --HXT11
66: fnd_message.set_token('SQLERR',SQLERRM); --HXT11
67: fnd_message.set_token('PERSON_ID',TO_CHAR(i_person_id)); --HXT11
68: o_error_message := FND_MESSAGE.GET; --HXT11
69: FND_MESSAGE.CLEAR; --HXT11
70:
71: END Define_Reference_Number;
72: --BEGIN GLOBAL
73: /*****************************************************************
83: o_batch_name := 'Batch #' || to_char(i_batch_id);
84:
85: EXCEPTION
86: WHEN OTHERS THEN
87: fnd_message.set_name('HXT','HXT_39485_ERR_DEF_BATCH_NAME');
88: fnd_message.set_token('SQLERR',SQLERRM);
89: o_error_message := FND_MESSAGE.GET;
90: FND_MESSAGE.CLEAR;
91: END Define_Batch_Name;
84:
85: EXCEPTION
86: WHEN OTHERS THEN
87: fnd_message.set_name('HXT','HXT_39485_ERR_DEF_BATCH_NAME');
88: fnd_message.set_token('SQLERR',SQLERRM);
89: o_error_message := FND_MESSAGE.GET;
90: FND_MESSAGE.CLEAR;
91: END Define_Batch_Name;
92: /******************************************************************************************************
85: EXCEPTION
86: WHEN OTHERS THEN
87: fnd_message.set_name('HXT','HXT_39485_ERR_DEF_BATCH_NAME');
88: fnd_message.set_token('SQLERR',SQLERRM);
89: o_error_message := FND_MESSAGE.GET;
90: FND_MESSAGE.CLEAR;
91: END Define_Batch_Name;
92: /******************************************************************************************************
93: FUNCTION retro_hours()
86: WHEN OTHERS THEN
87: fnd_message.set_name('HXT','HXT_39485_ERR_DEF_BATCH_NAME');
88: fnd_message.set_token('SQLERR',SQLERRM);
89: o_error_message := FND_MESSAGE.GET;
90: FND_MESSAGE.CLEAR;
91: END Define_Batch_Name;
92: /******************************************************************************************************
93: FUNCTION retro_hours()
94: