3:
4:
5: ----------------------- Global variables and constants -----------------------
6:
7: g_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_MISS_CHAR;
8: g_MISS_NUM CONSTANT NUMBER := fnd_api.g_MISS_NUM;
9: g_MISS_DATE CONSTANT DATE := fnd_api.g_MISS_DATE;
10: g_YES CONSTANT VARCHAR2(1) := 'Y';
11: g_NO CONSTANT VARCHAR2(1) := 'N';
4:
5: ----------------------- Global variables and constants -----------------------
6:
7: g_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_MISS_CHAR;
8: g_MISS_NUM CONSTANT NUMBER := fnd_api.g_MISS_NUM;
9: g_MISS_DATE CONSTANT DATE := fnd_api.g_MISS_DATE;
10: g_YES CONSTANT VARCHAR2(1) := 'Y';
11: g_NO CONSTANT VARCHAR2(1) := 'N';
12:
5: ----------------------- Global variables and constants -----------------------
6:
7: g_MISS_CHAR CONSTANT VARCHAR2(1) := fnd_api.g_MISS_CHAR;
8: g_MISS_NUM CONSTANT NUMBER := fnd_api.g_MISS_NUM;
9: g_MISS_DATE CONSTANT DATE := fnd_api.g_MISS_DATE;
10: g_YES CONSTANT VARCHAR2(1) := 'Y';
11: g_NO CONSTANT VARCHAR2(1) := 'N';
12:
13: -- Global constants used by the Write_Message procedure to
75: -------------------------------- Add_Message ---------------------------------
76:
77: PROCEDURE Add_Message
78: ( p_Msg_Name IN VARCHAR2
79: , p_token1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
80: , p_value1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
81: , p_token2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
82: , p_value2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
83: , p_token3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
76:
77: PROCEDURE Add_Message
78: ( p_Msg_Name IN VARCHAR2
79: , p_token1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
80: , p_value1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
81: , p_token2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
82: , p_value2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
83: , p_token3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
84: , p_value3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
77: PROCEDURE Add_Message
78: ( p_Msg_Name IN VARCHAR2
79: , p_token1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
80: , p_value1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
81: , p_token2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
82: , p_value2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
83: , p_token3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
84: , p_value3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
85: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
78: ( p_Msg_Name IN VARCHAR2
79: , p_token1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
80: , p_value1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
81: , p_token2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
82: , p_value2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
83: , p_token3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
84: , p_value3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
85: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
86: , p_transaction_id IN NUMBER DEFAULT fnd_api.g_MISS_NUM
79: , p_token1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
80: , p_value1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
81: , p_token2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
82: , p_value2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
83: , p_token3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
84: , p_value3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
85: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
86: , p_transaction_id IN NUMBER DEFAULT fnd_api.g_MISS_NUM
87: , p_column_name IN VARCHAR2 DEFAULT NULL
80: , p_value1 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
81: , p_token2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
82: , p_value2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
83: , p_token3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
84: , p_value3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
85: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
86: , p_transaction_id IN NUMBER DEFAULT fnd_api.g_MISS_NUM
87: , p_column_name IN VARCHAR2 DEFAULT NULL
88: );
81: , p_token2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
82: , p_value2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
83: , p_token3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
84: , p_value3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
85: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
86: , p_transaction_id IN NUMBER DEFAULT fnd_api.g_MISS_NUM
87: , p_column_name IN VARCHAR2 DEFAULT NULL
88: );
89:
82: , p_value2 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
83: , p_token3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
84: , p_value3 IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
85: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
86: , p_transaction_id IN NUMBER DEFAULT fnd_api.g_MISS_NUM
87: , p_column_name IN VARCHAR2 DEFAULT NULL
88: );
89:
90:
91: ---------------------------------- Add_Error ---------------------------------
92:
93: PROCEDURE Add_Error
94: ( p_Msg_Name IN VARCHAR2
95: , p_token IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
96: , p_value IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
97: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
98: );
99:
92:
93: PROCEDURE Add_Error
94: ( p_Msg_Name IN VARCHAR2
95: , p_token IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
96: , p_value IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
97: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
98: );
99:
100:
93: PROCEDURE Add_Error
94: ( p_Msg_Name IN VARCHAR2
95: , p_token IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
96: , p_value IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
97: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
98: );
99:
100:
101: --------------------------------- Add_Warning --------------------------------
101: --------------------------------- Add_Warning --------------------------------
102:
103: PROCEDURE Add_Warning
104: ( p_Msg_Name IN VARCHAR2
105: , p_token IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
106: , p_value IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
107: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
108: );
109:
102:
103: PROCEDURE Add_Warning
104: ( p_Msg_Name IN VARCHAR2
105: , p_token IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
106: , p_value IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
107: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
108: );
109:
110:
103: PROCEDURE Add_Warning
104: ( p_Msg_Name IN VARCHAR2
105: , p_token IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
106: , p_value IN VARCHAR2 DEFAULT fnd_api.g_MISS_CHAR
107: , p_translate IN VARCHAR2 DEFAULT fnd_api.g_FALSE
108: );
109:
110:
111: ---------------------------- Add_Unexpected_Error ----------------------------
132:
133: -------------------------------- Count_And_Get -------------------------------
134:
135: PROCEDURE Count_And_Get
136: ( p_encoded IN VARCHAR2 := FND_API.g_TRUE
137: , p_count OUT NOCOPY NUMBER
138: , p_data OUT NOCOPY VARCHAR2
139: );
140: