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_CATALOG_MIGRATION dependencies on FND_FILE

Line 162: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category mapping started');

158: if (upper(p_Debug_Flag) = 'Y') then
159: G_DEBUG := true;
160: end if;
161:
162: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category mapping started');
163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
164:
165: -- Initialize retcode to success
166: RETCODE := FND_API.G_RET_STS_SUCCESS;

Line 163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

159: G_DEBUG := true;
160: end if;
161:
162: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category mapping started');
163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
164:
165: -- Initialize retcode to success
166: RETCODE := FND_API.G_RET_STS_SUCCESS;
167:

Line 189: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find structure id corresponding to Product Catalog');

185: from MTL_CATEGORY_SETS C where C.category_set_id = l_category_set_id;
186:
187: EXCEPTION
188: WHEN OTHERS THEN
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find structure id corresponding to Product Catalog');
190: RAISE;
191: END;
192:
193: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find structure id corresponding to sales and marketing category set');

201: from FND_ID_FLEX_STRUCTURES FIFS
202: where FIFS.ID_FLEX_CODE = 'MCAT' AND FIFS.APPLICATION_ID = 401 AND FIFS.ID_FLEX_STRUCTURE_CODE = 'SALES_CATEGORIES';
203: EXCEPTION
204: WHEN OTHERS THEN
205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find structure id corresponding to sales and marketing category set');
206: RAISE;
207: END;
208:
209: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find attribute group for Sales and Marketing');

214: -- EGO Application Id is 431
215: SELECT ATTR_GROUP_ID INTO l_attr_group_id FROM EGO_FND_DSC_FLX_CTX_EXT WHERE APPLICATION_ID = 431 AND DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_PRODUCT_CATEGORY_SET' AND DESCRIPTIVE_FLEX_CONTEXT_CODE = 'SalesAndMarketing';
216: EXCEPTION
217: WHEN OTHERS THEN
218: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find attribute group for Sales and Marketing');
219: RAISE;
220: END;
221:
222: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 233: FND_FILE.PUT_LINE(FND_FILE.LOG,'->' || FND_MESSAGE.Get());

229: FOR scr in C_Get_Int_Type
230: LOOP
231: FND_MESSAGE.Set_Name('AS', 'API_PROCESSING_INTEREST_TYPE');
232: FND_MESSAGE.Set_Token('NAME', scr.interest_type);
233: FND_FILE.PUT_LINE(FND_FILE.LOG,'->' || FND_MESSAGE.Get());
234:
235: -- Create Mtl categories and associate to inventory items
236: Process_Categories(p_int_typ_cod_id => scr.interest_type_id,
237: p_structure_id => l_structure_id,

Line 352: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category mapping finished successfully');

348: NULL;
349: END LOOP;
350: END;
351:
352: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category mapping finished successfully');
353: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
354:
355: COMMIT;
356:

Line 353: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

349: END LOOP;
350: END;
351:
352: FND_FILE.PUT_LINE(FND_FILE.LOG,'Category mapping finished successfully');
353: FND_FILE.PUT_LINE(FND_FILE.LOG,'End time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
354:
355: COMMIT;
356:
357: if (l_warning = 'Y') then

Line 368: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, can not complete Concurrent Program') ;

364: RETCODE := FND_API.G_RET_STS_ERROR;
365:
366: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
367: IF l_status = TRUE THEN
368: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, can not complete Concurrent Program') ;
369: END IF ;
370:
371: ERRBUF := 'Error in category mapping '||SQLERRM;
372: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

Line 372: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);

368: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, can not complete Concurrent Program') ;
369: END IF ;
370:
371: ERRBUF := 'Error in category mapping '||SQLERRM;
372: FND_FILE.PUT_LINE(FND_FILE.LOG,ERRBUF);
373:
374: fnd_msg_pub.count_and_get( p_encoded => 'F'
375: , p_count => l_msg_count
376: , p_data => l_msg_data);

Line 377: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return Status:' || nvl(l_return_status,'xxx'));

373:
374: fnd_msg_pub.count_and_get( p_encoded => 'F'
375: , p_count => l_msg_count
376: , p_data => l_msg_data);
377: FND_FILE.PUT_LINE(FND_FILE.LOG,'Return Status:' || nvl(l_return_status,'xxx'));
378: --=================message display part begins
379: for k in 1 .. l_msg_count loop
380: l_msg_data := fnd_msg_pub.get( p_msg_index => k,
381: p_encoded => 'F'

Line 383: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error msg: '||substr(l_msg_data,1,240));

379: for k in 1 .. l_msg_count loop
380: l_msg_data := fnd_msg_pub.get( p_msg_index => k,
381: p_encoded => 'F'
382: );
383: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error msg: '||substr(l_msg_data,1,240));
384: ERRBUF := substr(ERRBUF || ';Error msg: '|| l_msg_data,1,3900);
385: end loop;
386: --=================message display part ends
387:

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

434: if (SQLCODE = '-6502') then
435: -- Warning! Unable to create category for interest type/code as category name is too long.
436: FND_MESSAGE.Set_Name('AS', 'API_WARNING_CREATE_CATEGORY');
437: FND_MESSAGE.Set_Token('NAME', p_category_name);
438: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
439:
440: x_warning_flag := 'Y';
441: return;
442: end if;

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

467: if (SQLCODE = '-6502') then
468: -- Warning! Unable to create legacy category for interest type/code as legacy category name is too long.
469: FND_MESSAGE.Set_Name('AS', 'API_WARNING_CREATE_LEGACY');
470: FND_MESSAGE.Set_Token('NAME', p_category_name);
471: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
472:
473: x_warning_flag := 'Y';
474: return;
475: end if;

Line 575: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured while retrieving category set');

571: END IF;
572: x_category_set_id := l_category_set_id;
573: EXCEPTION
574: WHEN OTHERS THEN
575: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error occured while retrieving category set');
576: RAISE;
577: END Retrieve_Category_Set;
578:
579: PROCEDURE Create_SME_Category_Set(x_category_set_id OUT NOCOPY NUMBER) IS

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

675:
676: -- Warning! Unable to grant access to catalog (Error code:' || x_errorcode || '). Please notify the administrator about this error.
677: FND_MESSAGE.Set_Name('AS', 'API_WARNING_GRANT_CATALOG');
678: FND_MESSAGE.Set_Token('ERRORCODE', x_errorcode);
679: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.Get());
680: end if;
681:
682: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
683: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Grant guid=' || x_grant_guid);

Line 701: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No functional area found corresponding to product catalog');

697: where functional_area_id = G_FUNCTIONAL_AREA;
698:
699: -- If nothing updated then this is an error
700: IF (SQL%NOTFOUND) THEN
701: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No functional area found corresponding to product catalog');
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
705: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Done Attaching Category Set to functional area 11');

Line 1095: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in Process_Categories');

1091: if l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1092: l_return_status := FND_API.G_RET_STS_ERROR;
1093: end if;
1094:
1095: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in Process_Categories');
1096: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Process_Categories');
1097: x_return_status := l_return_status;
1098: x_msg_count := l_msg_count;
1099: x_msg_data := l_msg_data;