26: v_value_3,
27: v_token_4,
28: v_value_4);
29:
30: l_msg_name := fnd_message.get_number('XNP',v_msg_name) || ':'|| l_msg_name;
31: return l_msg_name;
32:
33: EXCEPTION
34: WHEN OTHERS THEN
31: return l_msg_name;
32:
33: EXCEPTION
34: WHEN OTHERS THEN
35: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
36: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
37: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
38: htp.p(htf.bodyOpen);
39: htp.p(gc_error_display||' : '||fnd_message.get);
32:
33: EXCEPTION
34: WHEN OTHERS THEN
35: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
36: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
37: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
38: htp.p(htf.bodyOpen);
39: htp.p(gc_error_display||' : '||fnd_message.get);
40: htp.p(htf.br);
33: EXCEPTION
34: WHEN OTHERS THEN
35: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
36: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
37: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
38: htp.p(htf.bodyOpen);
39: htp.p(gc_error_display||' : '||fnd_message.get);
40: htp.p(htf.br);
41: htp.p(htf.bodyClose);
35: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
36: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
37: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
38: htp.p(htf.bodyOpen);
39: htp.p(gc_error_display||' : '||fnd_message.get);
40: htp.p(htf.br);
41: htp.p(htf.bodyClose);
42: END GetNumErrMsg;
43:
58: RETURN VARCHAR2
59: IS
60: l_msg_name VARCHAR2(1996) := NULL;
61: BEGIN
62: fnd_message.set_name('XNP',substr(v_msg_name, 1, 30));
63:
64: if (v_token_1 IS NOT NULL) then
65: fnd_message.set_token(v_token_1, v_value_1);
66: end if;
61: BEGIN
62: fnd_message.set_name('XNP',substr(v_msg_name, 1, 30));
63:
64: if (v_token_1 IS NOT NULL) then
65: fnd_message.set_token(v_token_1, v_value_1);
66: end if;
67: if (v_token_2 IS NOT NULL) then
68: fnd_message.set_token(v_token_2, v_value_2);
69: end if;
64: if (v_token_1 IS NOT NULL) then
65: fnd_message.set_token(v_token_1, v_value_1);
66: end if;
67: if (v_token_2 IS NOT NULL) then
68: fnd_message.set_token(v_token_2, v_value_2);
69: end if;
70: if (v_token_3 IS NOT NULL) then
71: fnd_message.set_token(v_token_3, v_value_3);
72: end if;
67: if (v_token_2 IS NOT NULL) then
68: fnd_message.set_token(v_token_2, v_value_2);
69: end if;
70: if (v_token_3 IS NOT NULL) then
71: fnd_message.set_token(v_token_3, v_value_3);
72: end if;
73: if (v_token_4 IS NOT NULL) then
74: fnd_message.set_token(v_token_4, v_value_4);
75: end if;
70: if (v_token_3 IS NOT NULL) then
71: fnd_message.set_token(v_token_3, v_value_3);
72: end if;
73: if (v_token_4 IS NOT NULL) then
74: fnd_message.set_token(v_token_4, v_value_4);
75: end if;
76:
77: l_msg_name := fnd_message.get;
78: return l_msg_name;
73: if (v_token_4 IS NOT NULL) then
74: fnd_message.set_token(v_token_4, v_value_4);
75: end if;
76:
77: l_msg_name := fnd_message.get;
78: return l_msg_name;
79:
80: EXCEPTION
81: WHEN OTHERS THEN
78: return l_msg_name;
79:
80: EXCEPTION
81: WHEN OTHERS THEN
82: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
83: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
84: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
85: htp.p(htf.bodyOpen);
86: htp.p(gc_error_display||' : '||fnd_message.get);
79:
80: EXCEPTION
81: WHEN OTHERS THEN
82: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
83: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
84: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
85: htp.p(htf.bodyOpen);
86: htp.p(gc_error_display||' : '||fnd_message.get);
87: htp.p(htf.br);
80: EXCEPTION
81: WHEN OTHERS THEN
82: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
83: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
84: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
85: htp.p(htf.bodyOpen);
86: htp.p(gc_error_display||' : '||fnd_message.get);
87: htp.p(htf.br);
88: htp.p(htf.bodyClose);
82: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
83: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
84: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
85: htp.p(htf.bodyOpen);
86: htp.p(gc_error_display||' : '||fnd_message.get);
87: htp.p(htf.br);
88: htp.p(htf.bodyClose);
89: END GetMsgTxt;
90:
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: -- log error;
129: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
130: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
131: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
132: htp.p(htf.bodyOpen);
133: htp.p(gc_error_display||' : '||fnd_message.get);
126: EXCEPTION
127: WHEN OTHERS THEN
128: -- log error;
129: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
130: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
131: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
132: htp.p(htf.bodyOpen);
133: htp.p(gc_error_display||' : '||fnd_message.get);
134: htp.p(htf.br);
127: WHEN OTHERS THEN
128: -- log error;
129: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
130: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
131: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
132: htp.p(htf.bodyOpen);
133: htp.p(gc_error_display||' : '||fnd_message.get);
134: htp.p(htf.br);
135: htp.p(htf.bodyClose);
129: fnd_message.set_name('XNP','XNP_CVU_PROGRAM_ERROR');
130: fnd_message.set_token('ERROR_CODE',to_char(SQLCODE));
131: fnd_message.set_token('ERROR_MESSAGE',SQLERRM);
132: htp.p(htf.bodyOpen);
133: htp.p(gc_error_display||' : '||fnd_message.get);
134: htp.p(htf.br);
135: htp.p(htf.bodyClose);
136: END Print;
137: