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.AMS_MTL_CATG_LOADER_PVT dependencies on FND_MESSAGE

Line 288: FND_MESSAGE.Set_Name('AMS', 'AMS_API_INTEREST_TYPE_MISSING');

284: OPEN c_get_interest_type;
285: FETCH c_get_interest_type INTO l_interest_type;
286: CLOSE c_get_interest_type;
287: IF ( i=0) THEN
288: FND_MESSAGE.Set_Name('AMS', 'AMS_API_INTEREST_TYPE_MISSING');
289: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
290: -- Category Mapping is missing for the following Interest Types in the as_interest_types:
291: END IF;
292: FND_MESSAGE.Set_Name('AMS', 'AMS_INTEREST_TYPE_ASSOC_COMP');

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

285: FETCH c_get_interest_type INTO l_interest_type;
286: CLOSE c_get_interest_type;
287: IF ( i=0) THEN
288: FND_MESSAGE.Set_Name('AMS', 'AMS_API_INTEREST_TYPE_MISSING');
289: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
290: -- Category Mapping is missing for the following Interest Types in the as_interest_types:
291: END IF;
292: FND_MESSAGE.Set_Name('AMS', 'AMS_INTEREST_TYPE_ASSOC_COMP');
293: -- Interest Type NAME ( Id: ID) associated with the COMPNAME (Competitor_Id: COMPID).

Line 292: FND_MESSAGE.Set_Name('AMS', 'AMS_INTEREST_TYPE_ASSOC_COMP');

288: FND_MESSAGE.Set_Name('AMS', 'AMS_API_INTEREST_TYPE_MISSING');
289: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
290: -- Category Mapping is missing for the following Interest Types in the as_interest_types:
291: END IF;
292: FND_MESSAGE.Set_Name('AMS', 'AMS_INTEREST_TYPE_ASSOC_COMP');
293: -- Interest Type NAME ( Id: ID) associated with the COMPNAME (Competitor_Id: COMPID).
294: FND_MESSAGE.Set_Token('NAME',l_interest_type);
295: FND_MESSAGE.Set_Token('ID',l_interest_type_id);
296: FND_MESSAGE.Set_Token('COMPNAME',l_comp_name);

Line 294: FND_MESSAGE.Set_Token('NAME',l_interest_type);

290: -- Category Mapping is missing for the following Interest Types in the as_interest_types:
291: END IF;
292: FND_MESSAGE.Set_Name('AMS', 'AMS_INTEREST_TYPE_ASSOC_COMP');
293: -- Interest Type NAME ( Id: ID) associated with the COMPNAME (Competitor_Id: COMPID).
294: FND_MESSAGE.Set_Token('NAME',l_interest_type);
295: FND_MESSAGE.Set_Token('ID',l_interest_type_id);
296: FND_MESSAGE.Set_Token('COMPNAME',l_comp_name);
297: FND_MESSAGE.Set_Token('COMPID',l_competitor_prod_id);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());

Line 295: FND_MESSAGE.Set_Token('ID',l_interest_type_id);

291: END IF;
292: FND_MESSAGE.Set_Name('AMS', 'AMS_INTEREST_TYPE_ASSOC_COMP');
293: -- Interest Type NAME ( Id: ID) associated with the COMPNAME (Competitor_Id: COMPID).
294: FND_MESSAGE.Set_Token('NAME',l_interest_type);
295: FND_MESSAGE.Set_Token('ID',l_interest_type_id);
296: FND_MESSAGE.Set_Token('COMPNAME',l_comp_name);
297: FND_MESSAGE.Set_Token('COMPID',l_competitor_prod_id);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
299: i := i+1;

Line 296: FND_MESSAGE.Set_Token('COMPNAME',l_comp_name);

292: FND_MESSAGE.Set_Name('AMS', 'AMS_INTEREST_TYPE_ASSOC_COMP');
293: -- Interest Type NAME ( Id: ID) associated with the COMPNAME (Competitor_Id: COMPID).
294: FND_MESSAGE.Set_Token('NAME',l_interest_type);
295: FND_MESSAGE.Set_Token('ID',l_interest_type_id);
296: FND_MESSAGE.Set_Token('COMPNAME',l_comp_name);
297: FND_MESSAGE.Set_Token('COMPID',l_competitor_prod_id);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
299: i := i+1;
300: END IF;

Line 297: FND_MESSAGE.Set_Token('COMPID',l_competitor_prod_id);

293: -- Interest Type NAME ( Id: ID) associated with the COMPNAME (Competitor_Id: COMPID).
294: FND_MESSAGE.Set_Token('NAME',l_interest_type);
295: FND_MESSAGE.Set_Token('ID',l_interest_type_id);
296: FND_MESSAGE.Set_Token('COMPNAME',l_comp_name);
297: FND_MESSAGE.Set_Token('COMPID',l_competitor_prod_id);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
299: i := i+1;
300: END IF;
301: CLOSE c_get_category;

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

294: FND_MESSAGE.Set_Token('NAME',l_interest_type);
295: FND_MESSAGE.Set_Token('ID',l_interest_type_id);
296: FND_MESSAGE.Set_Token('COMPNAME',l_comp_name);
297: FND_MESSAGE.Set_Token('COMPID',l_competitor_prod_id);
298: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
299: i := i+1;
300: END IF;
301: CLOSE c_get_category;
302: END LOOP;

Line 381: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_MAPPING_MISSING');

377: ,category_set_id = l_cat_rec.cat_set_id
378: WHERE activity_product_id = l_activity_product_id;
379: ELSE
380: IF (i = 0) THEN
381: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_MAPPING_MISSING');
382: -- Category Mapping is missing for the following:
383: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
384: END IF;
385: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_ASSOC_OBJECT');

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

379: ELSE
380: IF (i = 0) THEN
381: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_MAPPING_MISSING');
382: -- Category Mapping is missing for the following:
383: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
384: END IF;
385: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_ASSOC_OBJECT');
386: -- NAME ( Id: ID) category associated with the object OBJTYPE (ObjId: OBJID).
387: FND_MESSAGE.Set_Token('NAME',l_cat_name_rec.description);

Line 385: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_ASSOC_OBJECT');

381: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_MAPPING_MISSING');
382: -- Category Mapping is missing for the following:
383: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
384: END IF;
385: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_ASSOC_OBJECT');
386: -- NAME ( Id: ID) category associated with the object OBJTYPE (ObjId: OBJID).
387: FND_MESSAGE.Set_Token('NAME',l_cat_name_rec.description);
388: FND_MESSAGE.Set_Token('ID',l_category_id);
389: FND_MESSAGE.Set_Token('OBJTYPE',l_obj_type);

Line 387: FND_MESSAGE.Set_Token('NAME',l_cat_name_rec.description);

383: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
384: END IF;
385: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_ASSOC_OBJECT');
386: -- NAME ( Id: ID) category associated with the object OBJTYPE (ObjId: OBJID).
387: FND_MESSAGE.Set_Token('NAME',l_cat_name_rec.description);
388: FND_MESSAGE.Set_Token('ID',l_category_id);
389: FND_MESSAGE.Set_Token('OBJTYPE',l_obj_type);
390: FND_MESSAGE.Set_Token('OBJID',l_obj_id);
391: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());

Line 388: FND_MESSAGE.Set_Token('ID',l_category_id);

384: END IF;
385: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_ASSOC_OBJECT');
386: -- NAME ( Id: ID) category associated with the object OBJTYPE (ObjId: OBJID).
387: FND_MESSAGE.Set_Token('NAME',l_cat_name_rec.description);
388: FND_MESSAGE.Set_Token('ID',l_category_id);
389: FND_MESSAGE.Set_Token('OBJTYPE',l_obj_type);
390: FND_MESSAGE.Set_Token('OBJID',l_obj_id);
391: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
392: i := i+1;

Line 389: FND_MESSAGE.Set_Token('OBJTYPE',l_obj_type);

385: FND_MESSAGE.Set_Name('AMS', 'AMS_API_CAT_ASSOC_OBJECT');
386: -- NAME ( Id: ID) category associated with the object OBJTYPE (ObjId: OBJID).
387: FND_MESSAGE.Set_Token('NAME',l_cat_name_rec.description);
388: FND_MESSAGE.Set_Token('ID',l_category_id);
389: FND_MESSAGE.Set_Token('OBJTYPE',l_obj_type);
390: FND_MESSAGE.Set_Token('OBJID',l_obj_id);
391: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
392: i := i+1;
393: END IF;

Line 390: FND_MESSAGE.Set_Token('OBJID',l_obj_id);

386: -- NAME ( Id: ID) category associated with the object OBJTYPE (ObjId: OBJID).
387: FND_MESSAGE.Set_Token('NAME',l_cat_name_rec.description);
388: FND_MESSAGE.Set_Token('ID',l_category_id);
389: FND_MESSAGE.Set_Token('OBJTYPE',l_obj_type);
390: FND_MESSAGE.Set_Token('OBJID',l_obj_id);
391: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
392: i := i+1;
393: END IF;
394: CLOSE c_get_map_cat;

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

387: FND_MESSAGE.Set_Token('NAME',l_cat_name_rec.description);
388: FND_MESSAGE.Set_Token('ID',l_category_id);
389: FND_MESSAGE.Set_Token('OBJTYPE',l_obj_type);
390: FND_MESSAGE.Set_Token('OBJID',l_obj_id);
391: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.Get());
392: i := i+1;
393: END IF;
394: CLOSE c_get_map_cat;
395: END LOOP;