DBA Data[Home] [Help]

APPS.PSB_MESSAGE_S dependencies on FND_API

Line 7: p_encoded IN VARCHAR2 := FND_API.G_TRUE )

3:
4: l_new_line_char VARCHAR2(2000) := FND_GLOBAL.Newline;
5:
6: FUNCTION Get ( p_msg_index IN NUMBER ,
7: p_encoded IN VARCHAR2 := FND_API.G_TRUE )
8: RETURN VARCHAR2 IS
9:
10: l_msg_buf VARCHAR2(2000) ;
11:

Line 51: p_print_header IN VARCHAR2 := FND_API.G_TRUE )

47:
48:
49:
50: PROCEDURE Print_Error ( p_mode IN VARCHAR2,
51: p_print_header IN VARCHAR2 := FND_API.G_TRUE )
52: IS
53:
54: l_msg_count NUMBER ;
55: l_msg_data VARCHAR2(2000) ;

Line 80: IF FND_API.to_Boolean( p_print_header ) THEN

76: IF l_msg_count = 0 THEN
77: RETURN ;
78: ELSE
79: -- Print standard header is asked for.
80: IF FND_API.to_Boolean( p_print_header ) THEN
81: FND_MESSAGE.Set_Name('PSB', 'PSB_PROGRAM_FAILURE_HEADER');
82: l_msg_buf := substrb_get ;
83: FND_FILE.Put_Line( p_mode, l_msg_buf ) ;
84: END IF ;

Line 109: p_encoded => FND_API.G_FALSE ) ;

105: --
106: IF i = 1 THEN
107: l_msg_buf := substrb_get
108: ( p_msg_index => FND_MSG_PUB.G_FIRST,
109: p_encoded => FND_API.G_FALSE ) ;
110: ELSE
111: l_msg_buf := substrb_get
112: ( p_msg_index => FND_MSG_PUB.G_NEXT,
113: p_encoded => FND_API.G_FALSE ) ;

Line 113: p_encoded => FND_API.G_FALSE ) ;

109: p_encoded => FND_API.G_FALSE ) ;
110: ELSE
111: l_msg_buf := substrb_get
112: ( p_msg_index => FND_MSG_PUB.G_NEXT,
113: p_encoded => FND_API.G_FALSE ) ;
114: END IF;
115: --
116: FND_FILE.Put_Line( p_mode, l_msg_buf ) ;
117: --

Line 132: p_desc_sequence IN VARCHAR2 := FND_API.G_FALSE

128: PROCEDURE Insert_Error( p_source_process IN VARCHAR2,
129: p_process_id IN NUMBER,
130: p_msg_count IN NUMBER,
131: p_msg_data IN VARCHAR2,
132: p_desc_sequence IN VARCHAR2 := FND_API.G_FALSE
133: )
134: IS
135:
136:

Line 140: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);

136:
137: l_msg_count NUMBER := p_msg_count ;
138: l_msg_data VARCHAR2(2000) := p_msg_data ;
139: l_msg_buf VARCHAR2(2000) ;
140: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);
141: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
142: l_seq_number NUMBER := 0 ;
143:
144: BEGIN

Line 146: if FND_API.to_Boolean( p_desc_sequence ) then

142: l_seq_number NUMBER := 0 ;
143:
144: BEGIN
145:
146: if FND_API.to_Boolean( p_desc_sequence ) then
147: l_seq_number := l_msg_count + 1 ;
148: end if;
149:
150: if l_msg_count = 1 then

Line 162: p_encoded => FND_API.G_FALSE);

158:
159: if i =1 then
160: l_msg_buf := FND_MSG_PUB.Get
161: (p_msg_index => FND_MSG_PUB.G_FIRST,
162: p_encoded => FND_API.G_FALSE);
163: else
164: l_msg_buf := FND_MSG_PUB.Get
165: (p_msg_index => FND_MSG_PUB.G_NEXT,
166: p_encoded => FND_API.G_FALSE);

Line 166: p_encoded => FND_API.G_FALSE);

162: p_encoded => FND_API.G_FALSE);
163: else
164: l_msg_buf := FND_MSG_PUB.Get
165: (p_msg_index => FND_MSG_PUB.G_NEXT,
166: p_encoded => FND_API.G_FALSE);
167: end if;
168:
169: if FND_API.to_Boolean( p_desc_sequence ) then
170: l_seq_number := l_seq_number - 1 ;

Line 169: if FND_API.to_Boolean( p_desc_sequence ) then

165: (p_msg_index => FND_MSG_PUB.G_NEXT,
166: p_encoded => FND_API.G_FALSE);
167: end if;
168:
169: if FND_API.to_Boolean( p_desc_sequence ) then
170: l_seq_number := l_seq_number - 1 ;
171: else
172: l_seq_number := i ;
173: end if ;

Line 228: PROCEDURE Get_Error_Message( p_print_header IN VARCHAR2 := FND_API.G_TRUE,

224:
225: END Print_Success ;
226:
227:
228: PROCEDURE Get_Error_Message( p_print_header IN VARCHAR2 := FND_API.G_TRUE,
229: p_msg_string OUT NOCOPY VARCHAR2)
230: IS
231: --
232: l_msg_count NUMBER ;

Line 238: if FND_API.to_Boolean( p_print_header ) then

234: l_msg_buf VARCHAR2(2000) ;
235: --
236: BEGIN
237:
238: if FND_API.to_Boolean( p_print_header ) then
239: -- Standard program failure message.
240: FND_MESSAGE.Set_Name('PSB', 'PSB_PROGRAM_FAILURE_HEADER');
241: l_msg_buf := substrb_get;
242: end if;

Line 261: p_encoded => FND_API.G_FALSE

257: if i = 1 then
258: l_msg_buf := l_msg_buf || l_new_line_char ||
259: substrb_get
260: ( p_msg_index => FND_MSG_PUB.G_FIRST,
261: p_encoded => FND_API.G_FALSE
262: );
263: else
264: l_msg_buf := l_msg_buf || l_new_line_char ||
265: substrb_get

Line 267: p_encoded => FND_API.G_FALSE

263: else
264: l_msg_buf := l_msg_buf || l_new_line_char ||
265: substrb_get
266: ( p_msg_index => FND_MSG_PUB.G_NEXT,
267: p_encoded => FND_API.G_FALSE
268: );
269: end if;
270: end loop ;
271: elsif l_msg_count = 0 then

Line 315: p_encoded => FND_API.G_FALSE ,

311: -- Retrieve messages from the message stack.
312: FOR i IN 1..p_msg_count
313: LOOP
314: FND_MSG_PUB.Get( p_msg_index => i ,
315: p_encoded => FND_API.G_FALSE ,
316: p_data => l_msg_data ,
317: p_msg_index_out => l_msg_count
318: );
319:

Line 349: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);

345: l_msg_buf VARCHAR2(3000);
346: l_max_seq_no NUMBER;
347: l_seq_no NUMBER;
348: l_loop_process BOOLEAN;
349: l_conc_req_id NUMBER := NVL(FND_GLOBAL.CONC_REQUEST_ID, FND_API.G_MISS_NUM);
350: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
351:
352: -- cursor to fetch the maximum of sequence
353: CURSOR l_seq_csr

Line 385: p_encoded => FND_API.G_FALSE);

381: l_msg_buf := FND_MESSAGE.Get;
382: else
383: l_msg_buf := FND_MSG_PUB.Get
384: (p_msg_index => FND_MSG_PUB.G_FIRST,
385: p_encoded => FND_API.G_FALSE);
386: end if;
387: else
388: l_msg_buf := FND_MSG_PUB.Get
389: (p_msg_index => FND_MSG_PUB.G_NEXT,

Line 390: p_encoded => FND_API.G_FALSE);

386: end if;
387: else
388: l_msg_buf := FND_MSG_PUB.Get
389: (p_msg_index => FND_MSG_PUB.G_NEXT,
390: p_encoded => FND_API.G_FALSE);
391: end if;
392:
393: insert into PSB_ERROR_MESSAGES
394: (concurrent_request_id,