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_INT_TYP_COD_MIGRATION dependencies on FND_MESSAGE

Line 98: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));

94: FND_FILE.PUT_LINE(FND_FILE.LOG,'Migration finished successfully');
95: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
96:
97: if (l_warning = 'Y') then
98: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));
99: end if;
100: EXCEPTION
101: WHEN OTHERS THEN
102: Rollback;

Line 208: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));

204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmintb','End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
205: end if;
206:
207: if (RETCODE = G_RET_STS_WARNING) then
208: l_status := fnd_concurrent.set_completion_status('WARNING',FND_MESSAGE.Get_String('AS','API_REQUEST_WARNING_STATUS'));
209: end if;
210: EXCEPTION
211: WHEN OTHERS THEN
212: Rollback;

Line 312: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');

308: if C_Get_Product_Cat_Id%NOTFOUND THEN
309: close C_Get_Product_Cat_Id;
310:
311: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
312: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
313: FND_MESSAGE.Set_Token('NAME', p_query_name);
314: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
315: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
316:

Line 313: FND_MESSAGE.Set_Token('NAME', p_query_name);

309: close C_Get_Product_Cat_Id;
310:
311: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
312: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
313: FND_MESSAGE.Set_Token('NAME', p_query_name);
314: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
315: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
316:
317: l_warning := 'Y';

Line 314: FND_MESSAGE.Set_Token('ID', scr.parameter_value);

310:
311: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
312: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
313: FND_MESSAGE.Set_Token('NAME', p_query_name);
314: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
315: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
316:
317: l_warning := 'Y';
318: exit;

Line 315: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

311: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
312: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
313: FND_MESSAGE.Set_Token('NAME', p_query_name);
314: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
315: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
316:
317: l_warning := 'Y';
318: exit;
319: end if;

Line 325: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');

321: close C_Get_Product_Cat_Id;
322: if ((l_product_cat_id IS NULL) OR (l_product_cat_set_id IS NULL)) then
323:
324: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
325: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
326: FND_MESSAGE.Set_Token('NAME', p_query_name);
327: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
329:

Line 326: FND_MESSAGE.Set_Token('NAME', p_query_name);

322: if ((l_product_cat_id IS NULL) OR (l_product_cat_set_id IS NULL)) then
323:
324: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
325: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
326: FND_MESSAGE.Set_Token('NAME', p_query_name);
327: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
329:
330: l_warning := 'Y';

Line 327: FND_MESSAGE.Set_Token('ID', scr.parameter_value);

323:
324: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
325: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
326: FND_MESSAGE.Set_Token('NAME', p_query_name);
327: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
329:
330: l_warning := 'Y';
331: exit;

Line 328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

324: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
325: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
326: FND_MESSAGE.Set_Token('NAME', p_query_name);
327: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
328: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
329:
330: l_warning := 'Y';
331: exit;
332: end if;

Line 378: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING4');

374: if C_Get_Product_Cat_Id2%NOTFOUND THEN
375: close C_Get_Product_Cat_Id2;
376:
377: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest code id ' || l_sec_int_code_id || ')'
378: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING4');
379: FND_MESSAGE.Set_Token('NAME', p_query_name);
380: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
381: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
382:

Line 379: FND_MESSAGE.Set_Token('NAME', p_query_name);

375: close C_Get_Product_Cat_Id2;
376:
377: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest code id ' || l_sec_int_code_id || ')'
378: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING4');
379: FND_MESSAGE.Set_Token('NAME', p_query_name);
380: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
381: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
382:
383: l_warning := 'Y';

Line 380: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);

376:
377: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest code id ' || l_sec_int_code_id || ')'
378: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING4');
379: FND_MESSAGE.Set_Token('NAME', p_query_name);
380: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
381: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
382:
383: l_warning := 'Y';
384: exit;

Line 381: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

377: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest code id ' || l_sec_int_code_id || ')'
378: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING4');
379: FND_MESSAGE.Set_Token('NAME', p_query_name);
380: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
381: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
382:
383: l_warning := 'Y';
384: exit;
385: end if;

Line 391: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING5');

387: close C_Get_Product_Cat_Id2;
388: if ((l_product_cat_id IS NULL) OR (l_product_cat_set_id IS NULL)) then
389:
390: -- 'Warning! Ignoring query ' || p_query_name || '(Interest code with id ' || l_sec_int_code_id || ' not mapped to any product category)'
391: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING5');
392: FND_MESSAGE.Set_Token('NAME', p_query_name);
393: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
394: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
395:

Line 392: FND_MESSAGE.Set_Token('NAME', p_query_name);

388: if ((l_product_cat_id IS NULL) OR (l_product_cat_set_id IS NULL)) then
389:
390: -- 'Warning! Ignoring query ' || p_query_name || '(Interest code with id ' || l_sec_int_code_id || ' not mapped to any product category)'
391: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING5');
392: FND_MESSAGE.Set_Token('NAME', p_query_name);
393: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
394: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
395:
396: l_warning := 'Y';

Line 393: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);

389:
390: -- 'Warning! Ignoring query ' || p_query_name || '(Interest code with id ' || l_sec_int_code_id || ' not mapped to any product category)'
391: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING5');
392: FND_MESSAGE.Set_Token('NAME', p_query_name);
393: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
394: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
395:
396: l_warning := 'Y';
397: exit;

Line 394: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

390: -- 'Warning! Ignoring query ' || p_query_name || '(Interest code with id ' || l_sec_int_code_id || ' not mapped to any product category)'
391: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING5');
392: FND_MESSAGE.Set_Token('NAME', p_query_name);
393: FND_MESSAGE.Set_Token('ID', l_sec_int_code_id);
394: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
395:
396: l_warning := 'Y';
397: exit;
398: end if;

Line 407: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');

403: if C_Get_Product_Cat_Id%NOTFOUND THEN
404: close C_Get_Product_Cat_Id;
405:
406: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
407: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
408: FND_MESSAGE.Set_Token('NAME', p_query_name);
409: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
410: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
411:

Line 408: FND_MESSAGE.Set_Token('NAME', p_query_name);

404: close C_Get_Product_Cat_Id;
405:
406: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
407: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
408: FND_MESSAGE.Set_Token('NAME', p_query_name);
409: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
410: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
411:
412: l_warning := 'Y';

Line 409: FND_MESSAGE.Set_Token('ID', scr.parameter_value);

405:
406: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
407: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
408: FND_MESSAGE.Set_Token('NAME', p_query_name);
409: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
410: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
411:
412: l_warning := 'Y';
413: exit;

Line 410: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

406: -- 'Warning! Ignoring query ' || p_query_name || '(Found Invalid interest type id ' || scr.parameter_value || ')'
407: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING1');
408: FND_MESSAGE.Set_Token('NAME', p_query_name);
409: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
410: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
411:
412: l_warning := 'Y';
413: exit;
414: end if;

Line 420: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');

416: close C_Get_Product_Cat_Id;
417: if ((l_product_cat_id IS NULL) OR (l_product_cat_set_id IS NULL)) then
418:
419: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
420: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
421: FND_MESSAGE.Set_Token('NAME', p_query_name);
422: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
423: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
424:

Line 421: FND_MESSAGE.Set_Token('NAME', p_query_name);

417: if ((l_product_cat_id IS NULL) OR (l_product_cat_set_id IS NULL)) then
418:
419: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
420: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
421: FND_MESSAGE.Set_Token('NAME', p_query_name);
422: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
423: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
424:
425: l_warning := 'Y';

Line 422: FND_MESSAGE.Set_Token('ID', scr.parameter_value);

418:
419: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
420: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
421: FND_MESSAGE.Set_Token('NAME', p_query_name);
422: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
423: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
424:
425: l_warning := 'Y';
426: exit;

Line 423: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());

419: -- 'Warning! Ignoring query ' || p_query_name || '(Interest type with id ' || scr.parameter_value || ' not mapped to any product category)'
420: FND_MESSAGE.Set_Name('AS', 'API_MIGRATION_WARNING2');
421: FND_MESSAGE.Set_Token('NAME', p_query_name);
422: FND_MESSAGE.Set_Token('ID', scr.parameter_value);
423: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
424:
425: l_warning := 'Y';
426: exit;
427: end if;