APPS.OKL_LEASE_APP_WF dependencies on FND_MESSAGE

Line 51: --function to return the message from fnd message for the subject of the notifications

47: FROM FND_LOOKUPS
48: WHERE LOOKUP_TYPE = 'OKL_FRONTEND_OBJECTS'
49: AND LOOKUP_CODE = object_type;
50:
51: --function to return the message from fnd message for the subject of the notifications
52:
53: FUNCTION get_message(p_msg_name IN VARCHAR2, object_name IN VARCHAR2,
54: object_value IN VARCHAR2) RETURN VARCHAR2 IS
55: l_message VARCHAR2(100);

Line 60: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);

56:
57: BEGIN
58:
59: IF p_msg_name IS NOT NULL THEN
60: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
61: Fnd_Message.SET_TOKEN(TOKEN => 'OBJECT_NAME',
62: VALUE => object_name);
63: Fnd_Message.SET_TOKEN(TOKEN => 'NAME', VALUE => object_value);
64: l_message := fnd_message.get();

Line 61: Fnd_Message.SET_TOKEN(TOKEN => 'OBJECT_NAME',

57: BEGIN
58:
59: IF p_msg_name IS NOT NULL THEN
60: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
61: Fnd_Message.SET_TOKEN(TOKEN => 'OBJECT_NAME',
62: VALUE => object_name);
63: Fnd_Message.SET_TOKEN(TOKEN => 'NAME', VALUE => object_value);
64: l_message := fnd_message.get();
65: END IF;

Line 63: Fnd_Message.SET_TOKEN(TOKEN => 'NAME', VALUE => object_value);

59: IF p_msg_name IS NOT NULL THEN
60: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
61: Fnd_Message.SET_TOKEN(TOKEN => 'OBJECT_NAME',
62: VALUE => object_name);
63: Fnd_Message.SET_TOKEN(TOKEN => 'NAME', VALUE => object_value);
64: l_message := fnd_message.get();
65: END IF;
66: RETURN l_message;
67: EXCEPTION

Line 64: l_message := fnd_message.get();

60: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
61: Fnd_Message.SET_TOKEN(TOKEN => 'OBJECT_NAME',
62: VALUE => object_name);
63: Fnd_Message.SET_TOKEN(TOKEN => 'NAME', VALUE => object_value);
64: l_message := fnd_message.get();
65: END IF;
66: RETURN l_message;
67: EXCEPTION
68: WHEN OTHERS THEN

Line 72: -- get the message for a message name frm fnd messages

68: WHEN OTHERS THEN
69: RETURN NULL;
70: END get_message;
71:
72: -- get the message for a message name frm fnd messages
73: FUNCTION get_token(p_msg_name IN VARCHAR2, token_name IN VARCHAR2,
74: token_value IN VARCHAR2) RETURN VARCHAR2 IS
75: l_message VARCHAR2(100);
76:

Line 80: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);

76:
77: BEGIN
78:
79: IF p_msg_name IS NOT NULL THEN
80: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
81: Fnd_Message.SET_TOKEN(TOKEN => token_name, VALUE => token_value);
82: l_message := fnd_message.get();
83: END IF;
84: RETURN l_message;

Line 81: Fnd_Message.SET_TOKEN(TOKEN => token_name, VALUE => token_value);

77: BEGIN
78:
79: IF p_msg_name IS NOT NULL THEN
80: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
81: Fnd_Message.SET_TOKEN(TOKEN => token_name, VALUE => token_value);
82: l_message := fnd_message.get();
83: END IF;
84: RETURN l_message;
85: EXCEPTION

Line 82: l_message := fnd_message.get();

78:
79: IF p_msg_name IS NOT NULL THEN
80: Fnd_Message.SET_NAME(APPLICATION => G_APP_NAME, NAME => p_msg_name);
81: Fnd_Message.SET_TOKEN(TOKEN => token_name, VALUE => token_value);
82: l_message := fnd_message.get();
83: END IF;
84: RETURN l_message;
85: EXCEPTION
86: WHEN OTHERS THEN