DBA Data[Home] [Help]

APPS.PO_MESSAGE_S dependencies on FND_MESSAGE

Line 15: -- FND Message Stack

11: --Pre-reqs:
12: -- N/A
13: --Modifies:
14: -- FND_LOG_MESSAGES
15: -- FND Message Stack
16: --Locks:
17: -- N/A
18: --Function:
19: -- This procedure sets a message describing a SQL error onto the

Line 20: -- server-side FND message stack

16: --Locks:
17: -- N/A
18: --Function:
19: -- This procedure sets a message describing a SQL error onto the
20: -- server-side FND message stack
21: -- Additionally, if debug logging is enabled, a message is also
22: -- recorded in the FND_LOG_MESSAGES table
23: --Parameters:
24: --IN:

Line 63: -- FND Message Stack

59: --Pre-reqs:
60: -- N/A
61: --Modifies:
62: -- FND_LOG_MESSAGES
63: -- FND Message Stack
64: --Locks:
65: -- N/A
66: --Function:
67: -- This procedure sets a message describing a SQL error onto the

Line 68: -- server-side FND message stack

64: --Locks:
65: -- N/A
66: --Function:
67: -- This procedure sets a message describing a SQL error onto the
68: -- server-side FND message stack
69: -- Additionally, if debug logging is enabled, a message is also
70: -- recorded in the FND_LOG_MESSAGES table
71: --Parameters:
72: --IN:

Line 110: FND_MESSAGE.set_name('PO', PO_ALL_SQL_ERROR);

106:
107: g_routine := p_routine;
108: g_location := p_location;
109:
110: FND_MESSAGE.set_name('PO', PO_ALL_SQL_ERROR);
111: FND_MESSAGE.set_token(c_ROUTINE_token, p_routine);
112: FND_MESSAGE.set_token(c_ERR_NUMBER_token, p_location);
113: FND_MESSAGE.set_token(c_SQL_ERR_token, l_error_msg);
114: FND_MESSAGE.set_token(c_LSQL_ERR_token, SQLERRM);

Line 111: FND_MESSAGE.set_token(c_ROUTINE_token, p_routine);

107: g_routine := p_routine;
108: g_location := p_location;
109:
110: FND_MESSAGE.set_name('PO', PO_ALL_SQL_ERROR);
111: FND_MESSAGE.set_token(c_ROUTINE_token, p_routine);
112: FND_MESSAGE.set_token(c_ERR_NUMBER_token, p_location);
113: FND_MESSAGE.set_token(c_SQL_ERR_token, l_error_msg);
114: FND_MESSAGE.set_token(c_LSQL_ERR_token, SQLERRM);
115:

Line 112: FND_MESSAGE.set_token(c_ERR_NUMBER_token, p_location);

108: g_location := p_location;
109:
110: FND_MESSAGE.set_name('PO', PO_ALL_SQL_ERROR);
111: FND_MESSAGE.set_token(c_ROUTINE_token, p_routine);
112: FND_MESSAGE.set_token(c_ERR_NUMBER_token, p_location);
113: FND_MESSAGE.set_token(c_SQL_ERR_token, l_error_msg);
114: FND_MESSAGE.set_token(c_LSQL_ERR_token, SQLERRM);
115:
116: END IF;

Line 113: FND_MESSAGE.set_token(c_SQL_ERR_token, l_error_msg);

109:
110: FND_MESSAGE.set_name('PO', PO_ALL_SQL_ERROR);
111: FND_MESSAGE.set_token(c_ROUTINE_token, p_routine);
112: FND_MESSAGE.set_token(c_ERR_NUMBER_token, p_location);
113: FND_MESSAGE.set_token(c_SQL_ERR_token, l_error_msg);
114: FND_MESSAGE.set_token(c_LSQL_ERR_token, SQLERRM);
115:
116: END IF;
117:

Line 114: FND_MESSAGE.set_token(c_LSQL_ERR_token, SQLERRM);

110: FND_MESSAGE.set_name('PO', PO_ALL_SQL_ERROR);
111: FND_MESSAGE.set_token(c_ROUTINE_token, p_routine);
112: FND_MESSAGE.set_token(c_ERR_NUMBER_token, p_location);
113: FND_MESSAGE.set_token(c_SQL_ERR_token, l_error_msg);
114: FND_MESSAGE.set_token(c_LSQL_ERR_token, SQLERRM);
115:
116: END IF;
117:
118: IF g_debug_unexp THEN

Line 131: FND_MESSAGE.set_name('PO',error_name);

127: PROCEDURE APP_ERROR(error_name IN varchar2) IS
128: BEGIN
129: IF (g_routine is NULL) THEN
130: g_routine := 'ERROR';
131: FND_MESSAGE.set_name('PO',error_name);
132: APP_EXCEPTION.RAISE_EXCEPTION;
133: END IF;
134:
135: EXCEPTION

Line 146: FND_MESSAGE.set_name('PO',error_name);

142: BEGIN
143: IF (g_routine is NULL) THEN
144: g_routine := 'ERROR';
145:
146: FND_MESSAGE.set_name('PO',error_name);
147:
148: IF (token1 is not NULL and value1 is not null) THEN
149: FND_MESSAGE.SET_TOKEN(token1,value1);
150: END IF;

Line 149: FND_MESSAGE.SET_TOKEN(token1,value1);

145:
146: FND_MESSAGE.set_name('PO',error_name);
147:
148: IF (token1 is not NULL and value1 is not null) THEN
149: FND_MESSAGE.SET_TOKEN(token1,value1);
150: END IF;
151:
152: APP_EXCEPTION.RAISE_EXCEPTION;
153: END IF;

Line 168: FND_MESSAGE.set_name('PO',error_name);

164: BEGIN
165: IF (g_routine is NULL) THEN
166: g_routine := 'ERROR';
167:
168: FND_MESSAGE.set_name('PO',error_name);
169:
170: IF (token1 is not NULL and value1 is not null) THEN
171: FND_MESSAGE.SET_TOKEN(token1,value1);
172: END IF;

Line 171: FND_MESSAGE.SET_TOKEN(token1,value1);

167:
168: FND_MESSAGE.set_name('PO',error_name);
169:
170: IF (token1 is not NULL and value1 is not null) THEN
171: FND_MESSAGE.SET_TOKEN(token1,value1);
172: END IF;
173:
174: IF (token2 is not NULL and value2 is not null) THEN
175: FND_MESSAGE.SET_TOKEN(token2,value2);

Line 175: FND_MESSAGE.SET_TOKEN(token2,value2);

171: FND_MESSAGE.SET_TOKEN(token1,value1);
172: END IF;
173:
174: IF (token2 is not NULL and value2 is not null) THEN
175: FND_MESSAGE.SET_TOKEN(token2,value2);
176: END IF;
177:
178: APP_EXCEPTION.RAISE_EXCEPTION;
179: END IF;

Line 196: FND_MESSAGE.set_name('PO',error_name);

192: BEGIN
193: IF (g_routine is NULL) THEN
194: g_routine := 'ERROR';
195:
196: FND_MESSAGE.set_name('PO',error_name);
197:
198: IF (token1 is not NULL and value1 is not null) THEN
199: FND_MESSAGE.SET_TOKEN(token1,value1);
200: END IF;

Line 199: FND_MESSAGE.SET_TOKEN(token1,value1);

195:
196: FND_MESSAGE.set_name('PO',error_name);
197:
198: IF (token1 is not NULL and value1 is not null) THEN
199: FND_MESSAGE.SET_TOKEN(token1,value1);
200: END IF;
201:
202: IF (token2 is not NULL and value2 is not null) THEN
203: FND_MESSAGE.SET_TOKEN(token2,value2);

Line 203: FND_MESSAGE.SET_TOKEN(token2,value2);

199: FND_MESSAGE.SET_TOKEN(token1,value1);
200: END IF;
201:
202: IF (token2 is not NULL and value2 is not null) THEN
203: FND_MESSAGE.SET_TOKEN(token2,value2);
204: END IF;
205:
206: IF (token3 is not NULL and value3 is not null) THEN
207: FND_MESSAGE.SET_TOKEN(token3,value3);

Line 207: FND_MESSAGE.SET_TOKEN(token3,value3);

203: FND_MESSAGE.SET_TOKEN(token2,value2);
204: END IF;
205:
206: IF (token3 is not NULL and value3 is not null) THEN
207: FND_MESSAGE.SET_TOKEN(token3,value3);
208: END IF;
209:
210: APP_EXCEPTION.RAISE_EXCEPTION;
211: END IF;

Line 230: FND_MESSAGE.set_name('PO',error_name);

226: BEGIN
227: IF (g_routine is NULL) THEN
228: g_routine := 'ERROR';
229:
230: FND_MESSAGE.set_name('PO',error_name);
231:
232: IF (token1 is not NULL and value1 is not null) THEN
233: FND_MESSAGE.SET_TOKEN(token1,value1);
234: END IF;

Line 233: FND_MESSAGE.SET_TOKEN(token1,value1);

229:
230: FND_MESSAGE.set_name('PO',error_name);
231:
232: IF (token1 is not NULL and value1 is not null) THEN
233: FND_MESSAGE.SET_TOKEN(token1,value1);
234: END IF;
235:
236: IF (token2 is not NULL and value2 is not null) THEN
237: FND_MESSAGE.SET_TOKEN(token2,value2);

Line 237: FND_MESSAGE.SET_TOKEN(token2,value2);

233: FND_MESSAGE.SET_TOKEN(token1,value1);
234: END IF;
235:
236: IF (token2 is not NULL and value2 is not null) THEN
237: FND_MESSAGE.SET_TOKEN(token2,value2);
238: END IF;
239:
240: IF (token3 is not NULL and value3 is not null) THEN
241: FND_MESSAGE.SET_TOKEN(token3,value3);

Line 241: FND_MESSAGE.SET_TOKEN(token3,value3);

237: FND_MESSAGE.SET_TOKEN(token2,value2);
238: END IF;
239:
240: IF (token3 is not NULL and value3 is not null) THEN
241: FND_MESSAGE.SET_TOKEN(token3,value3);
242: END IF;
243:
244: IF (token4 is not NULL and value4 is not null) THEN
245: FND_MESSAGE.SET_TOKEN(token4,value4);

Line 245: FND_MESSAGE.SET_TOKEN(token4,value4);

241: FND_MESSAGE.SET_TOKEN(token3,value3);
242: END IF;
243:
244: IF (token4 is not NULL and value4 is not null) THEN
245: FND_MESSAGE.SET_TOKEN(token4,value4);
246: END IF;
247:
248: APP_EXCEPTION.RAISE_EXCEPTION;
249: END IF;

Line 259: FND_MESSAGE.set_name('PO',error_name);

255: PROCEDURE APP_SET_NAME(error_name IN varchar2) IS
256: BEGIN
257: IF (g_routine is null) THEN
258: g_routine := 'ERROR';
259: FND_MESSAGE.set_name('PO',error_name);
260: END IF;
261:
262: EXCEPTION
263: WHEN OTHERS THEN RAISE;

Line 377: --Name: concat_fnd_messages_in_stack

373:
374: --
375: --------------------------------------------------------------------------------
376: --Start of Comments
377: --Name: concat_fnd_messages_in_stack
378: --Pre-reqs:
379: -- N/A
380: --Modifies:
381: -- N/A

Line 397: PROCEDURE concat_fnd_messages_in_stack

393: --Testing:
394: --
395: --End of Comments
396: -------------------------------------------------------------------------------
397: PROCEDURE concat_fnd_messages_in_stack
398: ( p_max_size IN NUMBER,
399: x_message_text OUT NOCOPY VARCHAR2
400: ) IS
401:

Line 414: END concat_fnd_messages_in_stack;

410:
411: x_message_text := SUBSTRB(x_message_text || l_msg_temp || ' ',
412: p_max_size);
413: END LOOP;
414: END concat_fnd_messages_in_stack;
415: --
416:
417: END PO_MESSAGE_S;