6: msg_number NUMBER;
7: msg_text VARCHAR2(2000);
8:
9: BEGIN
10: FND_MESSAGE.Set_Name('FII', msg_name);
11:
12: RETURN (SUBSTRB(FND_MESSAGE.Get, 1, 132));
13:
14: END;
8:
9: BEGIN
10: FND_MESSAGE.Set_Name('FII', msg_name);
11:
12: RETURN (SUBSTRB(FND_MESSAGE.Get, 1, 132));
13:
14: END;
15: -- **************************************************************
16:
27: show_num VARCHAR2,
28: t1 VARCHAR2,
29: v1 VARCHAR2) RETURN VARCHAR2 IS
30: BEGIN
31: FND_MESSAGE.Set_Name('FII', msg_name);
32:
33: FND_MESSAGE.Set_Token(t1, v1);
34:
35: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
29: v1 VARCHAR2) RETURN VARCHAR2 IS
30: BEGIN
31: FND_MESSAGE.Set_Name('FII', msg_name);
32:
33: FND_MESSAGE.Set_Token(t1, v1);
34:
35: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
36:
37: END;
31: FND_MESSAGE.Set_Name('FII', msg_name);
32:
33: FND_MESSAGE.Set_Token(t1, v1);
34:
35: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
36:
37: END;
38:
39: -- *************************************************************
44: v1 VARCHAR2,
45: t2 VARCHAR2,
46: v2 VARCHAR2) RETURN VARCHAR2 IS
47: BEGIN
48: FND_MESSAGE.Set_Name('FII', msg_name);
49:
50: FND_MESSAGE.Set_Token(t1, v1);
51:
52: FND_MESSAGE.Set_Token(t2, v2);
46: v2 VARCHAR2) RETURN VARCHAR2 IS
47: BEGIN
48: FND_MESSAGE.Set_Name('FII', msg_name);
49:
50: FND_MESSAGE.Set_Token(t1, v1);
51:
52: FND_MESSAGE.Set_Token(t2, v2);
53:
54: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
48: FND_MESSAGE.Set_Name('FII', msg_name);
49:
50: FND_MESSAGE.Set_Token(t1, v1);
51:
52: FND_MESSAGE.Set_Token(t2, v2);
53:
54: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
55:
56: END;
50: FND_MESSAGE.Set_Token(t1, v1);
51:
52: FND_MESSAGE.Set_Token(t2, v2);
53:
54: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
55:
56: END;
57:
58: -- ************************************************************
66: t3 VARCHAR2,
67: v3 VARCHAR2) RETURN VARCHAR2 IS
68:
69: BEGIN
70: FND_MESSAGE.Set_Name('FII', msg_name);
71:
72: FND_MESSAGE.Set_Token(t1, v1);
73:
74: FND_MESSAGE.Set_Token(t2, v2);
68:
69: BEGIN
70: FND_MESSAGE.Set_Name('FII', msg_name);
71:
72: FND_MESSAGE.Set_Token(t1, v1);
73:
74: FND_MESSAGE.Set_Token(t2, v2);
75:
76: FND_MESSAGE.Set_Token(t3, v3);
70: FND_MESSAGE.Set_Name('FII', msg_name);
71:
72: FND_MESSAGE.Set_Token(t1, v1);
73:
74: FND_MESSAGE.Set_Token(t2, v2);
75:
76: FND_MESSAGE.Set_Token(t3, v3);
77:
78: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
72: FND_MESSAGE.Set_Token(t1, v1);
73:
74: FND_MESSAGE.Set_Token(t2, v2);
75:
76: FND_MESSAGE.Set_Token(t3, v3);
77:
78: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
79:
80: END;
74: FND_MESSAGE.Set_Token(t2, v2);
75:
76: FND_MESSAGE.Set_Token(t3, v3);
77:
78: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
79:
80: END;
81:
82: -- ***************************************************************
91: v3 VARCHAR2,
92: t4 VARCHAR2,
93: v4 VARCHAR2) RETURN VARCHAR2 IS
94: BEGIN
95: FND_MESSAGE.Set_Name('FII', msg_name);
96:
97: FND_MESSAGE.Set_Token(t1, v1);
98:
99: FND_MESSAGE.Set_Token(t2, v2);
93: v4 VARCHAR2) RETURN VARCHAR2 IS
94: BEGIN
95: FND_MESSAGE.Set_Name('FII', msg_name);
96:
97: FND_MESSAGE.Set_Token(t1, v1);
98:
99: FND_MESSAGE.Set_Token(t2, v2);
100:
101: FND_MESSAGE.Set_Token(t3, v3);
95: FND_MESSAGE.Set_Name('FII', msg_name);
96:
97: FND_MESSAGE.Set_Token(t1, v1);
98:
99: FND_MESSAGE.Set_Token(t2, v2);
100:
101: FND_MESSAGE.Set_Token(t3, v3);
102:
103: FND_MESSAGE.Set_Token(t4, v4);
97: FND_MESSAGE.Set_Token(t1, v1);
98:
99: FND_MESSAGE.Set_Token(t2, v2);
100:
101: FND_MESSAGE.Set_Token(t3, v3);
102:
103: FND_MESSAGE.Set_Token(t4, v4);
104:
105: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
99: FND_MESSAGE.Set_Token(t2, v2);
100:
101: FND_MESSAGE.Set_Token(t3, v3);
102:
103: FND_MESSAGE.Set_Token(t4, v4);
104:
105: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
106:
107: END;
101: FND_MESSAGE.Set_Token(t3, v3);
102:
103: FND_MESSAGE.Set_Token(t4, v4);
104:
105: RETURN(SUBSTRB(FND_MESSAGE.Get, 1, 132));
106:
107: END;
108:
109: -- ******************************************************************
125: msgbuf VARCHAR2(5000);
126:
127: BEGIN
128:
129: FND_MESSAGE.Set_Name('FII',msg_name);
130:
131: IF (token_num = 1)THEN
132:
133: FND_MESSAGE.Set_Token(t1,v1);
129: FND_MESSAGE.Set_Name('FII',msg_name);
130:
131: IF (token_num = 1)THEN
132:
133: FND_MESSAGE.Set_Token(t1,v1);
134:
135: ElSIF (token_num = 2) THEN
136:
137: FND_MESSAGE.Set_Token(t1,v1);
133: FND_MESSAGE.Set_Token(t1,v1);
134:
135: ElSIF (token_num = 2) THEN
136:
137: FND_MESSAGE.Set_Token(t1,v1);
138:
139: FND_MESSAGE.Set_Token(t2,v2);
140:
141: ELSIF (token_num = 3) THEN
135: ElSIF (token_num = 2) THEN
136:
137: FND_MESSAGE.Set_Token(t1,v1);
138:
139: FND_MESSAGE.Set_Token(t2,v2);
140:
141: ELSIF (token_num = 3) THEN
142:
143: FND_MESSAGE.Set_Token(t1,v1);
139: FND_MESSAGE.Set_Token(t2,v2);
140:
141: ELSIF (token_num = 3) THEN
142:
143: FND_MESSAGE.Set_Token(t1,v1);
144:
145: FND_MESSAGE.Set_Token(t2,v2);
146:
147: FND_MESSAGE.Set_Token(t3,v3);
141: ELSIF (token_num = 3) THEN
142:
143: FND_MESSAGE.Set_Token(t1,v1);
144:
145: FND_MESSAGE.Set_Token(t2,v2);
146:
147: FND_MESSAGE.Set_Token(t3,v3);
148:
149: ELSIF (token_num = 4)THEN
143: FND_MESSAGE.Set_Token(t1,v1);
144:
145: FND_MESSAGE.Set_Token(t2,v2);
146:
147: FND_MESSAGE.Set_Token(t3,v3);
148:
149: ELSIF (token_num = 4)THEN
150:
151: FND_MESSAGE.Set_Token(t1,v1);
147: FND_MESSAGE.Set_Token(t3,v3);
148:
149: ELSIF (token_num = 4)THEN
150:
151: FND_MESSAGE.Set_Token(t1,v1);
152:
153: FND_MESSAGE.Set_Token(t2,v2);
154:
155: ELSIF (token_num = 3) THEN
149: ELSIF (token_num = 4)THEN
150:
151: FND_MESSAGE.Set_Token(t1,v1);
152:
153: FND_MESSAGE.Set_Token(t2,v2);
154:
155: ELSIF (token_num = 3) THEN
156:
157: FND_MESSAGE.Set_Token(t1,v1);
153: FND_MESSAGE.Set_Token(t2,v2);
154:
155: ELSIF (token_num = 3) THEN
156:
157: FND_MESSAGE.Set_Token(t1,v1);
158:
159: FND_MESSAGE.Set_Token(t2,v2);
160:
161: FND_MESSAGE.Set_Token(t3,v3);
155: ELSIF (token_num = 3) THEN
156:
157: FND_MESSAGE.Set_Token(t1,v1);
158:
159: FND_MESSAGE.Set_Token(t2,v2);
160:
161: FND_MESSAGE.Set_Token(t3,v3);
162:
163: ELSIF (token_num = 4)THEN
157: FND_MESSAGE.Set_Token(t1,v1);
158:
159: FND_MESSAGE.Set_Token(t2,v2);
160:
161: FND_MESSAGE.Set_Token(t3,v3);
162:
163: ELSIF (token_num = 4)THEN
164:
165: FND_MESSAGE.Set_Token(t1,v1);
161: FND_MESSAGE.Set_Token(t3,v3);
162:
163: ELSIF (token_num = 4)THEN
164:
165: FND_MESSAGE.Set_Token(t1,v1);
166:
167: FND_MESSAGE.Set_Token(t2,v2);
168:
169: FND_MESSAGE.Set_Token(t3,v3);
163: ELSIF (token_num = 4)THEN
164:
165: FND_MESSAGE.Set_Token(t1,v1);
166:
167: FND_MESSAGE.Set_Token(t2,v2);
168:
169: FND_MESSAGE.Set_Token(t3,v3);
170:
171: FND_MESSAGE.Set_Token(t4,v4);
165: FND_MESSAGE.Set_Token(t1,v1);
166:
167: FND_MESSAGE.Set_Token(t2,v2);
168:
169: FND_MESSAGE.Set_Token(t3,v3);
170:
171: FND_MESSAGE.Set_Token(t4,v4);
172:
173: ELSIF (token_num = 5) THEN
167: FND_MESSAGE.Set_Token(t2,v2);
168:
169: FND_MESSAGE.Set_Token(t3,v3);
170:
171: FND_MESSAGE.Set_Token(t4,v4);
172:
173: ELSIF (token_num = 5) THEN
174:
175: FND_MESSAGE.Set_Token(t1,v1);
171: FND_MESSAGE.Set_Token(t4,v4);
172:
173: ELSIF (token_num = 5) THEN
174:
175: FND_MESSAGE.Set_Token(t1,v1);
176:
177: FND_MESSAGE.Set_Token(t2,v2);
178:
179: FND_MESSAGE.Set_Token(t3,v3);
173: ELSIF (token_num = 5) THEN
174:
175: FND_MESSAGE.Set_Token(t1,v1);
176:
177: FND_MESSAGE.Set_Token(t2,v2);
178:
179: FND_MESSAGE.Set_Token(t3,v3);
180:
181: FND_MESSAGE.Set_Token(t4,v4);
175: FND_MESSAGE.Set_Token(t1,v1);
176:
177: FND_MESSAGE.Set_Token(t2,v2);
178:
179: FND_MESSAGE.Set_Token(t3,v3);
180:
181: FND_MESSAGE.Set_Token(t4,v4);
182:
183: FND_MESSAGE.Set_Token(t5,v5);
177: FND_MESSAGE.Set_Token(t2,v2);
178:
179: FND_MESSAGE.Set_Token(t3,v3);
180:
181: FND_MESSAGE.Set_Token(t4,v4);
182:
183: FND_MESSAGE.Set_Token(t5,v5);
184:
185: END IF;
179: FND_MESSAGE.Set_Token(t3,v3);
180:
181: FND_MESSAGE.Set_Token(t4,v4);
182:
183: FND_MESSAGE.Set_Token(t5,v5);
184:
185: END IF;
186:
187: msgbuf := msg_name||': '||FND_MESSAGE.Get;
183: FND_MESSAGE.Set_Token(t5,v5);
184:
185: END IF;
186:
187: msgbuf := msg_name||': '||FND_MESSAGE.Get;
188:
189: RETURN (msgbuf);
190:
191: END Write_Buffer;
221: textbuf VARCHAR2(5000);
222:
223: BEGIN
224:
225: FND_MESSAGE.Set_Name('FII',msg_name);
226:
227: IF (token_num = 1)THEN
228:
229: FND_MESSAGE.Set_Token(t1,v1);
225: FND_MESSAGE.Set_Name('FII',msg_name);
226:
227: IF (token_num = 1)THEN
228:
229: FND_MESSAGE.Set_Token(t1,v1);
230:
231: ElSIF (token_num = 2) THEN
232:
233: FND_MESSAGE.Set_Token(t1,v1);
229: FND_MESSAGE.Set_Token(t1,v1);
230:
231: ElSIF (token_num = 2) THEN
232:
233: FND_MESSAGE.Set_Token(t1,v1);
234:
235: FND_MESSAGE.Set_Token(t2,v2);
236:
237: ELSIF (token_num = 3) THEN
231: ElSIF (token_num = 2) THEN
232:
233: FND_MESSAGE.Set_Token(t1,v1);
234:
235: FND_MESSAGE.Set_Token(t2,v2);
236:
237: ELSIF (token_num = 3) THEN
238:
239: FND_MESSAGE.Set_Token(t1,v1);
235: FND_MESSAGE.Set_Token(t2,v2);
236:
237: ELSIF (token_num = 3) THEN
238:
239: FND_MESSAGE.Set_Token(t1,v1);
240:
241: FND_MESSAGE.Set_Token(t2,v2);
242:
243: FND_MESSAGE.Set_Token(t3,v3);
237: ELSIF (token_num = 3) THEN
238:
239: FND_MESSAGE.Set_Token(t1,v1);
240:
241: FND_MESSAGE.Set_Token(t2,v2);
242:
243: FND_MESSAGE.Set_Token(t3,v3);
244:
245: ELSIF (token_num = 4)THEN
239: FND_MESSAGE.Set_Token(t1,v1);
240:
241: FND_MESSAGE.Set_Token(t2,v2);
242:
243: FND_MESSAGE.Set_Token(t3,v3);
244:
245: ELSIF (token_num = 4)THEN
246:
247: FND_MESSAGE.Set_Token(t1,v1);
243: FND_MESSAGE.Set_Token(t3,v3);
244:
245: ELSIF (token_num = 4)THEN
246:
247: FND_MESSAGE.Set_Token(t1,v1);
248:
249: FND_MESSAGE.Set_Token(t2,v2);
250:
251: FND_MESSAGE.Set_Token(t3,v3);
245: ELSIF (token_num = 4)THEN
246:
247: FND_MESSAGE.Set_Token(t1,v1);
248:
249: FND_MESSAGE.Set_Token(t2,v2);
250:
251: FND_MESSAGE.Set_Token(t3,v3);
252:
253: FND_MESSAGE.Set_Token(t4,v4);
247: FND_MESSAGE.Set_Token(t1,v1);
248:
249: FND_MESSAGE.Set_Token(t2,v2);
250:
251: FND_MESSAGE.Set_Token(t3,v3);
252:
253: FND_MESSAGE.Set_Token(t4,v4);
254:
255: ELSIF (token_num = 5) THEN
249: FND_MESSAGE.Set_Token(t2,v2);
250:
251: FND_MESSAGE.Set_Token(t3,v3);
252:
253: FND_MESSAGE.Set_Token(t4,v4);
254:
255: ELSIF (token_num = 5) THEN
256:
257: FND_MESSAGE.Set_Token(t1,v1);
253: FND_MESSAGE.Set_Token(t4,v4);
254:
255: ELSIF (token_num = 5) THEN
256:
257: FND_MESSAGE.Set_Token(t1,v1);
258:
259: FND_MESSAGE.Set_Token(t2,v2);
260:
261: FND_MESSAGE.Set_Token(t3,v3);
255: ELSIF (token_num = 5) THEN
256:
257: FND_MESSAGE.Set_Token(t1,v1);
258:
259: FND_MESSAGE.Set_Token(t2,v2);
260:
261: FND_MESSAGE.Set_Token(t3,v3);
262:
263: FND_MESSAGE.Set_Token(t4,v4);
257: FND_MESSAGE.Set_Token(t1,v1);
258:
259: FND_MESSAGE.Set_Token(t2,v2);
260:
261: FND_MESSAGE.Set_Token(t3,v3);
262:
263: FND_MESSAGE.Set_Token(t4,v4);
264:
265: FND_MESSAGE.Set_Token(t5,v5);
259: FND_MESSAGE.Set_Token(t2,v2);
260:
261: FND_MESSAGE.Set_Token(t3,v3);
262:
263: FND_MESSAGE.Set_Token(t4,v4);
264:
265: FND_MESSAGE.Set_Token(t5,v5);
266:
267: END IF;
261: FND_MESSAGE.Set_Token(t3,v3);
262:
263: FND_MESSAGE.Set_Token(t4,v4);
264:
265: FND_MESSAGE.Set_Token(t5,v5);
266:
267: END IF;
268:
269: -- textbuf := msg_name||': '||FND_MESSAGE.get;
265: FND_MESSAGE.Set_Token(t5,v5);
266:
267: END IF;
268:
269: -- textbuf := msg_name||': '||FND_MESSAGE.get;
270: textbuf := FND_MESSAGE.get;
271:
272: FND_FILE.Put_Line(FND_FILE.Log,textbuf);
273:
266:
267: END IF;
268:
269: -- textbuf := msg_name||': '||FND_MESSAGE.get;
270: textbuf := FND_MESSAGE.get;
271:
272: FND_FILE.Put_Line(FND_FILE.Log,textbuf);
273:
274: END Write_Log;
343: textbuf VARCHAR2(5000);
344:
345: BEGIN
346:
347: FND_MESSAGE.Set_Name('FII',msg_name);
348:
349: IF (token_num = 1)THEN
350:
351: FND_MESSAGE.Set_Token(t1,v1);
347: FND_MESSAGE.Set_Name('FII',msg_name);
348:
349: IF (token_num = 1)THEN
350:
351: FND_MESSAGE.Set_Token(t1,v1);
352:
353: ElSIF (token_num = 2) THEN
354:
355: FND_MESSAGE.Set_Token(t1,v1);
351: FND_MESSAGE.Set_Token(t1,v1);
352:
353: ElSIF (token_num = 2) THEN
354:
355: FND_MESSAGE.Set_Token(t1,v1);
356:
357: FND_MESSAGE.Set_Token(t2,v2);
358:
359: ELSIF (token_num = 3) THEN
353: ElSIF (token_num = 2) THEN
354:
355: FND_MESSAGE.Set_Token(t1,v1);
356:
357: FND_MESSAGE.Set_Token(t2,v2);
358:
359: ELSIF (token_num = 3) THEN
360:
361: FND_MESSAGE.Set_Token(t1,v1);
357: FND_MESSAGE.Set_Token(t2,v2);
358:
359: ELSIF (token_num = 3) THEN
360:
361: FND_MESSAGE.Set_Token(t1,v1);
362:
363: FND_MESSAGE.Set_Token(t2,v2);
364:
365: FND_MESSAGE.Set_Token(t3,v3);
359: ELSIF (token_num = 3) THEN
360:
361: FND_MESSAGE.Set_Token(t1,v1);
362:
363: FND_MESSAGE.Set_Token(t2,v2);
364:
365: FND_MESSAGE.Set_Token(t3,v3);
366:
367: ELSIF (token_num = 4)THEN
361: FND_MESSAGE.Set_Token(t1,v1);
362:
363: FND_MESSAGE.Set_Token(t2,v2);
364:
365: FND_MESSAGE.Set_Token(t3,v3);
366:
367: ELSIF (token_num = 4)THEN
368:
369: FND_MESSAGE.Set_Token(t1,v1);
365: FND_MESSAGE.Set_Token(t3,v3);
366:
367: ELSIF (token_num = 4)THEN
368:
369: FND_MESSAGE.Set_Token(t1,v1);
370:
371: FND_MESSAGE.Set_Token(t2,v2);
372:
373: FND_MESSAGE.Set_Token(t3,v3);
367: ELSIF (token_num = 4)THEN
368:
369: FND_MESSAGE.Set_Token(t1,v1);
370:
371: FND_MESSAGE.Set_Token(t2,v2);
372:
373: FND_MESSAGE.Set_Token(t3,v3);
374:
375: FND_MESSAGE.Set_Token(t4,v4);
369: FND_MESSAGE.Set_Token(t1,v1);
370:
371: FND_MESSAGE.Set_Token(t2,v2);
372:
373: FND_MESSAGE.Set_Token(t3,v3);
374:
375: FND_MESSAGE.Set_Token(t4,v4);
376:
377: ELSIF (token_num = 5) THEN
371: FND_MESSAGE.Set_Token(t2,v2);
372:
373: FND_MESSAGE.Set_Token(t3,v3);
374:
375: FND_MESSAGE.Set_Token(t4,v4);
376:
377: ELSIF (token_num = 5) THEN
378:
379: FND_MESSAGE.Set_Token(t1,v1);
375: FND_MESSAGE.Set_Token(t4,v4);
376:
377: ELSIF (token_num = 5) THEN
378:
379: FND_MESSAGE.Set_Token(t1,v1);
380:
381: FND_MESSAGE.Set_Token(t2,v2);
382:
383: FND_MESSAGE.Set_Token(t3,v3);
377: ELSIF (token_num = 5) THEN
378:
379: FND_MESSAGE.Set_Token(t1,v1);
380:
381: FND_MESSAGE.Set_Token(t2,v2);
382:
383: FND_MESSAGE.Set_Token(t3,v3);
384:
385: FND_MESSAGE.Set_Token(t4,v4);
379: FND_MESSAGE.Set_Token(t1,v1);
380:
381: FND_MESSAGE.Set_Token(t2,v2);
382:
383: FND_MESSAGE.Set_Token(t3,v3);
384:
385: FND_MESSAGE.Set_Token(t4,v4);
386:
387: FND_MESSAGE.Set_Token(t5,v5);
381: FND_MESSAGE.Set_Token(t2,v2);
382:
383: FND_MESSAGE.Set_Token(t3,v3);
384:
385: FND_MESSAGE.Set_Token(t4,v4);
386:
387: FND_MESSAGE.Set_Token(t5,v5);
388:
389: END IF;
383: FND_MESSAGE.Set_Token(t3,v3);
384:
385: FND_MESSAGE.Set_Token(t4,v4);
386:
387: FND_MESSAGE.Set_Token(t5,v5);
388:
389: END IF;
390:
391: FND_FILE.Put_Line(FND_FILE.Output, FND_MESSAGE.get);
387: FND_MESSAGE.Set_Token(t5,v5);
388:
389: END IF;
390:
391: FND_FILE.Put_Line(FND_FILE.Output, FND_MESSAGE.get);
392:
393: END Write_Output;
394:
395: -- ******************************************************************