eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_MULTI_CURRENCIES_PKG dependencies on FND_API

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33: l_api_name || ' Start');
34: END IF;
35:
36: -- Initialize API return status to SUCCESS
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: i := p_TYPE_MAPPINGS_TBL.first;
40: l_last := p_TYPE_MAPPINGS_TBL.last;
41: WHILE i <= l_last

Line 59: FND_API.G_MISS_CHAR, NULL,

55: --,
56: -- SECURITY_GROUP_ID
57: ) VALUES (
58: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
59: FND_API.G_MISS_CHAR, NULL,
60: p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
61: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
62: FND_API.G_MISS_CHAR, NULL,
63: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),

Line 62: FND_API.G_MISS_CHAR, NULL,

58: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
59: FND_API.G_MISS_CHAR, NULL,
60: p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
61: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
62: FND_API.G_MISS_CHAR, NULL,
63: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
64: decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
65: FND_API.G_MISS_CHAR, NULL,
66: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),

Line 65: FND_API.G_MISS_CHAR, NULL,

61: decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
62: FND_API.G_MISS_CHAR, NULL,
63: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
64: decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
65: FND_API.G_MISS_CHAR, NULL,
66: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
67: decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
68: FND_API.G_MISS_CHAR, NULL,
69: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),

Line 68: FND_API.G_MISS_CHAR, NULL,

64: decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
65: FND_API.G_MISS_CHAR, NULL,
66: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
67: decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
68: FND_API.G_MISS_CHAR, NULL,
69: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
70: decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
71: FND_API.G_MISS_CHAR, NULL,
72: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),

Line 71: FND_API.G_MISS_CHAR, NULL,

67: decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
68: FND_API.G_MISS_CHAR, NULL,
69: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
70: decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
71: FND_API.G_MISS_CHAR, NULL,
72: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
73: decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
74: FND_API.G_MISS_CHAR, NULL,
75: p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),

Line 74: FND_API.G_MISS_CHAR, NULL,

70: decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
71: FND_API.G_MISS_CHAR, NULL,
72: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
73: decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
74: FND_API.G_MISS_CHAR, NULL,
75: p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),
76: SYSDATE,
77: FND_GLOBAL.USER_ID,
78: SYSDATE,

Line 83: -- FND_API.G_MISS_NUM, NULL,

79: FND_GLOBAL.USER_ID,
80: FND_GLOBAL.CONC_LOGIN_ID
81: --,
82: -- decode( p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID,
83: -- FND_API.G_MISS_NUM, NULL,
84: -- p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID)
85: );
86: i := i + 1;
87: END LOOP;

Line 95: WHEN FND_API.G_EXC_ERROR THEN

91: ( p_count => x_msg_count,
92: p_data => x_msg_data
93: );
94: EXCEPTION
95: WHEN FND_API.G_EXC_ERROR THEN
96: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
97: P_MODULE => l_module
98: ,P_API_NAME => L_API_NAME
99: ,P_PKG_NAME => G_PKG_NAME

Line 106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

102: ,X_MSG_COUNT => X_MSG_COUNT
103: ,X_MSG_DATA => X_MSG_DATA
104: ,X_RETURN_STATUS => X_RETURN_STATUS);
105:
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
108: P_MODULE => l_module
109: ,P_API_NAME => L_API_NAME
110: ,P_PKG_NAME => G_PKG_NAME

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150: l_api_name || ' Start');
151: END IF;
152:
153: -- Initialize API return status to SUCCESS
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155:
156: i := p_TYPE_MAPPINGS_TBL.first;
157: l_last := p_TYPE_MAPPINGS_TBL.last;
158:

Line 168: FND_API.G_MISS_CHAR, PERIOD_SET_NAME,

164: END IF;
165: UPDATE AS_MC_TYPE_MAPPINGS
166: SET
167: PERIOD_SET_NAME = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
168: FND_API.G_MISS_CHAR, PERIOD_SET_NAME,
169: p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
170: PERIOD_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
171: FND_API.G_MISS_CHAR, PERIOD_TYPE,
172: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),

Line 171: FND_API.G_MISS_CHAR, PERIOD_TYPE,

167: PERIOD_SET_NAME = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME,
168: FND_API.G_MISS_CHAR, PERIOD_SET_NAME,
169: p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME),
170: PERIOD_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
171: FND_API.G_MISS_CHAR, PERIOD_TYPE,
172: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
173: CONVERSION_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
174: FND_API.G_MISS_CHAR, CONVERSION_TYPE,
175: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),

Line 174: FND_API.G_MISS_CHAR, CONVERSION_TYPE,

170: PERIOD_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE,
171: FND_API.G_MISS_CHAR, PERIOD_TYPE,
172: p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE),
173: CONVERSION_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
174: FND_API.G_MISS_CHAR, CONVERSION_TYPE,
175: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
176: DESCRIPTION = decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
177: FND_API.G_MISS_CHAR, DESCRIPTION,
178: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),

Line 177: FND_API.G_MISS_CHAR, DESCRIPTION,

173: CONVERSION_TYPE = decode( p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE,
174: FND_API.G_MISS_CHAR, CONVERSION_TYPE,
175: p_TYPE_MAPPINGS_TBL(i).CONVERSION_TYPE),
176: DESCRIPTION = decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
177: FND_API.G_MISS_CHAR, DESCRIPTION,
178: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
179: UPDATEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
180: FND_API.G_MISS_CHAR, UPDATEABLE_FLAG,
181: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),

Line 180: FND_API.G_MISS_CHAR, UPDATEABLE_FLAG,

176: DESCRIPTION = decode( p_TYPE_MAPPINGS_TBL(i).DESCRIPTION,
177: FND_API.G_MISS_CHAR, DESCRIPTION,
178: p_TYPE_MAPPINGS_TBL(i).DESCRIPTION),
179: UPDATEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
180: FND_API.G_MISS_CHAR, UPDATEABLE_FLAG,
181: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
182: DELETEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
183: FND_API.G_MISS_CHAR, DELETEABLE_FLAG,
184: p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),

Line 183: FND_API.G_MISS_CHAR, DELETEABLE_FLAG,

179: UPDATEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG,
180: FND_API.G_MISS_CHAR, UPDATEABLE_FLAG,
181: p_TYPE_MAPPINGS_TBL(i).UPDATEABLE_FLAG),
182: DELETEABLE_FLAG = decode( p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG,
183: FND_API.G_MISS_CHAR, DELETEABLE_FLAG,
184: p_TYPE_MAPPINGS_TBL(i).DELETEABLE_FLAG),
185: LAST_UPDATE_DATE = SYSDATE,
186: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
187: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID

Line 191: -- FND_API.G_MISS_NUM, SECURITY_GROUP_ID,

187: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID
188: --,
189: -- SECURITY_GROUP_ID = decode(
190: -- p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID,
191: -- FND_API.G_MISS_NUM, SECURITY_GROUP_ID,
192: -- p_TYPE_MAPPINGS_TBL(i).SECURITY_GROUP_ID)
193: WHERE PERIOD_SET_NAME = p_TYPE_MAPPINGS_TBL(i).PERIOD_SET_NAME
194: AND PERIOD_TYPE = p_TYPE_MAPPINGS_TBL(i).PERIOD_TYPE;
195:

Line 208: WHEN FND_API.G_EXC_ERROR THEN

204: ( p_count => x_msg_count,
205: p_data => x_msg_data
206: );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_MODULE => l_module
211: ,P_API_NAME => L_API_NAME
212: ,P_PKG_NAME => G_PKG_NAME

Line 219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

215: ,X_MSG_COUNT => X_MSG_COUNT
216: ,X_MSG_DATA => X_MSG_DATA
217: ,X_RETURN_STATUS => X_RETURN_STATUS);
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
221: P_MODULE => l_module
222: ,P_API_NAME => L_API_NAME
223: ,P_PKG_NAME => G_PKG_NAME

Line 267: x_return_status := FND_API.G_RET_STS_SUCCESS;

263: l_api_name || ' Start');
264: END IF;
265:
266: -- Initialize API return status to SUCCESS
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268:
269: i := p_TYPE_MAPPINGS_TBL.first;
270: l_last := p_TYPE_MAPPINGS_TBL.last;
271: WHILE i <= l_last

Line 290: WHEN FND_API.G_EXC_ERROR THEN

286: p_data => x_msg_data
287: );
288:
289: EXCEPTION
290: WHEN FND_API.G_EXC_ERROR THEN
291: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
292: P_MODULE => l_module
293: ,P_API_NAME => L_API_NAME
294: ,P_PKG_NAME => G_PKG_NAME

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: ,X_MSG_COUNT => X_MSG_COUNT
298: ,X_MSG_DATA => X_MSG_DATA
299: ,X_RETURN_STATUS => X_RETURN_STATUS);
300:
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
303: P_MODULE => l_module
304: ,P_API_NAME => L_API_NAME
305: ,P_PKG_NAME => G_PKG_NAME

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: l_api_name || ' Start');
347: END IF;
348:
349: -- Initialize API return status to SUCCESS
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: i := p_PERIOD_RATES_TBL.first;
353: l_last := p_PERIOD_RATES_TBL.last;
354: WHILE i <= l_last

Line 367: FND_API.G_MISS_CHAR, NULL,

363: MODE_FLAG,
364: INVERSE_CONVERSION_RATE
365: ) VALUES (
366: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
367: FND_API.G_MISS_CHAR, NULL,
368: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
369: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
370: FND_API.G_MISS_CHAR, NULL,
371: p_PERIOD_RATES_TBL(i).TO_CURRENCY),

Line 370: FND_API.G_MISS_CHAR, NULL,

366: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
367: FND_API.G_MISS_CHAR, NULL,
368: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
369: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
370: FND_API.G_MISS_CHAR, NULL,
371: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
372: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
373: FND_API.G_MISS_DATE, NULL,
374: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),

Line 373: FND_API.G_MISS_DATE, NULL,

369: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
370: FND_API.G_MISS_CHAR, NULL,
371: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
372: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
373: FND_API.G_MISS_DATE, NULL,
374: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
375: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
376: FND_API.G_MISS_DATE, NULL,
377: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),

Line 376: FND_API.G_MISS_DATE, NULL,

372: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
373: FND_API.G_MISS_DATE, NULL,
374: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
375: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
376: FND_API.G_MISS_DATE, NULL,
377: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
378: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
379: FND_API.G_MISS_CHAR, NULL,
380: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),

Line 379: FND_API.G_MISS_CHAR, NULL,

375: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
376: FND_API.G_MISS_DATE, NULL,
377: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
378: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
379: FND_API.G_MISS_CHAR, NULL,
380: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
381: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
382: FND_API.G_MISS_NUM, NULL,
383: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),

Line 382: FND_API.G_MISS_NUM, NULL,

378: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
379: FND_API.G_MISS_CHAR, NULL,
380: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
381: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
382: FND_API.G_MISS_NUM, NULL,
383: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
384: 'I',
385: NULL);
386:

Line 396: WHEN FND_API.G_EXC_ERROR THEN

392: ( p_count => x_msg_count,
393: p_data => x_msg_data
394: );
395: EXCEPTION
396: WHEN FND_API.G_EXC_ERROR THEN
397: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
398: P_MODULE => l_module
399: ,P_API_NAME => L_API_NAME
400: ,P_PKG_NAME => G_PKG_NAME

Line 407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

403: ,X_MSG_COUNT => X_MSG_COUNT
404: ,X_MSG_DATA => X_MSG_DATA
405: ,X_RETURN_STATUS => X_RETURN_STATUS);
406:
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
409: P_MODULE => l_module
410: ,P_API_NAME => L_API_NAME
411: ,P_PKG_NAME => G_PKG_NAME

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

453: l_api_name || ' Start');
454: END IF;
455:
456: -- Initialize API return status to SUCCESS
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: i := p_PERIOD_RATES_TBL.first;
460: l_last := p_PERIOD_RATES_TBL.last;
461: WHILE i <= l_last

Line 474: FND_API.G_MISS_CHAR, NULL,

470: MODE_FLAG,
471: INVERSE_CONVERSION_RATE
472: ) VALUES (
473: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
474: FND_API.G_MISS_CHAR, NULL,
475: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
476: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
477: FND_API.G_MISS_CHAR, NULL,
478: p_PERIOD_RATES_TBL(i).TO_CURRENCY),

Line 477: FND_API.G_MISS_CHAR, NULL,

473: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
474: FND_API.G_MISS_CHAR, NULL,
475: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
476: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
477: FND_API.G_MISS_CHAR, NULL,
478: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
479: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
480: FND_API.G_MISS_DATE, NULL,
481: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),

Line 480: FND_API.G_MISS_DATE, NULL,

476: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
477: FND_API.G_MISS_CHAR, NULL,
478: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
479: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
480: FND_API.G_MISS_DATE, NULL,
481: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
482: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
483: FND_API.G_MISS_DATE, NULL,
484: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),

Line 483: FND_API.G_MISS_DATE, NULL,

479: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
480: FND_API.G_MISS_DATE, NULL,
481: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
482: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
483: FND_API.G_MISS_DATE, NULL,
484: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
485: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
486: FND_API.G_MISS_CHAR, NULL,
487: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),

Line 486: FND_API.G_MISS_CHAR, NULL,

482: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
483: FND_API.G_MISS_DATE, NULL,
484: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
485: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
486: FND_API.G_MISS_CHAR, NULL,
487: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
488: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
489: FND_API.G_MISS_NUM, NULL,
490: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),

Line 489: FND_API.G_MISS_NUM, NULL,

485: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
486: FND_API.G_MISS_CHAR, NULL,
487: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
488: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
489: FND_API.G_MISS_NUM, NULL,
490: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
491: 'I',
492: NULL);
493:

Line 503: WHEN FND_API.G_EXC_ERROR THEN

499: ( p_count => x_msg_count,
500: p_data => x_msg_data
501: );
502: EXCEPTION
503: WHEN FND_API.G_EXC_ERROR THEN
504: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
505: P_MODULE => l_module
506: ,P_API_NAME => L_API_NAME
507: ,P_PKG_NAME => G_PKG_NAME

Line 514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

510: ,X_MSG_COUNT => X_MSG_COUNT
511: ,X_MSG_DATA => X_MSG_DATA
512: ,X_RETURN_STATUS => X_RETURN_STATUS);
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
516: P_MODULE => l_module
517: ,P_API_NAME => L_API_NAME
518: ,P_PKG_NAME => G_PKG_NAME

Line 564: x_return_status := FND_API.G_RET_STS_SUCCESS;

560: l_api_name || ' Start');
561: END IF;
562:
563: -- Initialize API return status to SUCCESS
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565:
566: i := p_PERIOD_RATES_TBL.first;
567: l_last := p_PERIOD_RATES_TBL.last;
568: WHILE i <= l_last

Line 581: FND_API.G_MISS_CHAR, NULL,

577: MODE_FLAG,
578: INVERSE_CONVERSION_RATE
579: ) VALUES (
580: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
581: FND_API.G_MISS_CHAR, NULL,
582: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
583: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
584: FND_API.G_MISS_CHAR, NULL,
585: p_PERIOD_RATES_TBL(i).TO_CURRENCY),

Line 584: FND_API.G_MISS_CHAR, NULL,

580: decode( p_PERIOD_RATES_TBL(i).FROM_CURRENCY,
581: FND_API.G_MISS_CHAR, NULL,
582: p_PERIOD_RATES_TBL(i).FROM_CURRENCY),
583: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
584: FND_API.G_MISS_CHAR, NULL,
585: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
586: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
587: FND_API.G_MISS_DATE, NULL,
588: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),

Line 587: FND_API.G_MISS_DATE, NULL,

583: decode( p_PERIOD_RATES_TBL(i).TO_CURRENCY,
584: FND_API.G_MISS_CHAR, NULL,
585: p_PERIOD_RATES_TBL(i).TO_CURRENCY),
586: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
587: FND_API.G_MISS_DATE, NULL,
588: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
589: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
590: FND_API.G_MISS_DATE, NULL,
591: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),

Line 590: FND_API.G_MISS_DATE, NULL,

586: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
587: FND_API.G_MISS_DATE, NULL,
588: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
589: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
590: FND_API.G_MISS_DATE, NULL,
591: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
592: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
593: FND_API.G_MISS_CHAR, NULL,
594: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),

Line 593: FND_API.G_MISS_CHAR, NULL,

589: decode( p_PERIOD_RATES_TBL(i).CONVERSION_DATE,
590: FND_API.G_MISS_DATE, NULL,
591: p_PERIOD_RATES_TBL(i).CONVERSION_DATE),
592: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
593: FND_API.G_MISS_CHAR, NULL,
594: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
595: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
596: FND_API.G_MISS_NUM, NULL,
597: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),

Line 596: FND_API.G_MISS_NUM, NULL,

592: decode( p_PERIOD_RATES_TBL(i).CONVERSION_TYPE,
593: FND_API.G_MISS_CHAR, NULL,
594: p_PERIOD_RATES_TBL(i).CONVERSION_TYPE),
595: decode( p_PERIOD_RATES_TBL(i).CONVERSION_RATE,
596: FND_API.G_MISS_NUM, NULL,
597: p_PERIOD_RATES_TBL(i).CONVERSION_RATE),
598: 'D',
599: NULL);
600: i := i + 1;

Line 609: WHEN FND_API.G_EXC_ERROR THEN

605: ( p_count => x_msg_count,
606: p_data => x_msg_data
607: );
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
611: P_MODULE => l_module
612: ,P_API_NAME => L_API_NAME
613: ,P_PKG_NAME => G_PKG_NAME

Line 620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

616: ,X_MSG_COUNT => X_MSG_COUNT
617: ,X_MSG_DATA => X_MSG_DATA
618: ,X_RETURN_STATUS => X_RETURN_STATUS);
619:
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
622: P_MODULE => l_module
623: ,P_API_NAME => L_API_NAME
624: ,P_PKG_NAME => G_PKG_NAME