45: ------------------------------------------------------------------------------
46: -- Start of comments
47: --
48: -- Procedure Name : get_message
49: -- Description : function to return the message from fnd message for notifications
50: -- Business Rules : function to return the message from fnd message for notifications
51: -- Parameters :
52: -- Version : 1.0
53: -- History : viselvar created
46: -- Start of comments
47: --
48: -- Procedure Name : get_message
49: -- Description : function to return the message from fnd message for notifications
50: -- Business Rules : function to return the message from fnd message for notifications
51: -- Parameters :
52: -- Version : 1.0
53: -- History : viselvar created
54: --
60:
61: BEGIN
62:
63: IF p_msg_name IS NOT NULL THEN
64: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
65: Fnd_Message.SET_TOKEN(TOKEN => G_MSG_TOKEN_OBJECT_NAME,
66: VALUE => object_name);
67: Fnd_Message.SET_TOKEN(TOKEN => G_MSG_TOKEN_NAME, VALUE => object_value);
68: l_message := fnd_message.get();
61: BEGIN
62:
63: IF p_msg_name IS NOT NULL THEN
64: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
65: Fnd_Message.SET_TOKEN(TOKEN => G_MSG_TOKEN_OBJECT_NAME,
66: VALUE => object_name);
67: Fnd_Message.SET_TOKEN(TOKEN => G_MSG_TOKEN_NAME, VALUE => object_value);
68: l_message := fnd_message.get();
69: END IF;
63: IF p_msg_name IS NOT NULL THEN
64: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
65: Fnd_Message.SET_TOKEN(TOKEN => G_MSG_TOKEN_OBJECT_NAME,
66: VALUE => object_name);
67: Fnd_Message.SET_TOKEN(TOKEN => G_MSG_TOKEN_NAME, VALUE => object_value);
68: l_message := fnd_message.get();
69: END IF;
70: RETURN l_message;
71: EXCEPTION
64: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
65: Fnd_Message.SET_TOKEN(TOKEN => G_MSG_TOKEN_OBJECT_NAME,
66: VALUE => object_name);
67: Fnd_Message.SET_TOKEN(TOKEN => G_MSG_TOKEN_NAME, VALUE => object_value);
68: l_message := fnd_message.get();
69: END IF;
70: RETURN l_message;
71: EXCEPTION
72: WHEN OTHERS THEN
78: ------------------------------------------------------------------------------
79: -- Start of comments
80: --
81: -- Function Name : get_token
82: -- Description : get the message for a message name frm fnd messages
83: -- Business Rules : get the message for a message name frm fnd messages
84: -- Parameters :
85: -- Version : 1.0
86: -- History : viselvar created
79: -- Start of comments
80: --
81: -- Function Name : get_token
82: -- Description : get the message for a message name frm fnd messages
83: -- Business Rules : get the message for a message name frm fnd messages
84: -- Parameters :
85: -- Version : 1.0
86: -- History : viselvar created
87: --
93:
94: BEGIN
95:
96: IF p_msg_name IS NOT NULL THEN
97: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
98: Fnd_Message.SET_TOKEN(TOKEN => token_name, VALUE => token_value);
99: l_message := fnd_message.get();
100: END IF;
101: RETURN l_message;
94: BEGIN
95:
96: IF p_msg_name IS NOT NULL THEN
97: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
98: Fnd_Message.SET_TOKEN(TOKEN => token_name, VALUE => token_value);
99: l_message := fnd_message.get();
100: END IF;
101: RETURN l_message;
102: EXCEPTION
95:
96: IF p_msg_name IS NOT NULL THEN
97: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
98: Fnd_Message.SET_TOKEN(TOKEN => token_name, VALUE => token_value);
99: l_message := fnd_message.get();
100: END IF;
101: RETURN l_message;
102: EXCEPTION
103: WHEN OTHERS THEN