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.GMD_CONC_REPLACE_PKG dependencies on FND_FILE

Line 45: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

41: WHERE recipe_id = precipe_id)
42: AND line_type = 1);
43:
44: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_FM_DEP');
45: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
46: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
47:
48: ELSIF(update_item = 'ROUTING') THEN
49: DELETE FROM gmd_recipe_routing_steps

Line 46: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

42: AND line_type = 1);
43:
44: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_FM_DEP');
45: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
46: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
47:
48: ELSIF(update_item = 'ROUTING') THEN
49: DELETE FROM gmd_recipe_routing_steps
50: WHERE recipe_id = precipe_id;

Line 59: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

55: DELETE FROM gmd_recipe_orgn_resources
56: WHERE recipe_id = precipe_id;
57:
58: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_RT_DEP');
59: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
60: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
61: END IF;
62:
63: DELETE FROM gmd_recipe_step_materials

Line 60: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

56: WHERE recipe_id = precipe_id;
57:
58: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_RT_DEP');
59: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
60: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
61: END IF;
62:
63: DELETE FROM gmd_recipe_step_materials
64: WHERE recipe_id = precipe_id;

Line 67: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

63: DELETE FROM gmd_recipe_step_materials
64: WHERE recipe_id = precipe_id;
65:
66: fnd_message.set_name('GMD', 'GMD_DELETE_STEP_MAT_ASSOC');
67: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
68: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
69:
70: EXCEPTION
71: WHEN OTHERS THEN

Line 68: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

64: WHERE recipe_id = precipe_id;
65:
66: fnd_message.set_name('GMD', 'GMD_DELETE_STEP_MAT_ASSOC');
67: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
68: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: fnd_msg_pub.add_exc_msg (G_PKG_NAME, l_api_name);

Line 525: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

521:
522: -- Making new line entry and prompting users about MSNR request
523: -- Bug# 5008299 Kapil M
524: -- Moved the code for log file so that it is shown for every replace
525: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
526: FND_MESSAGE.SET_NAME('GMD','GMD_MSNR_REPLACE_MESG');
527: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
528: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
529: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);

Line 531: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

527: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
528: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
529: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
530: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
531: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
532: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
533:
534: -- NPD Conv.
535: -- Check if the Entity Owning organization is available for the responsibility

Line 532: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

528: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
529: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
530: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
531: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
532: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
533:
534: -- NPD Conv.
535: -- Check if the Entity Owning organization is available for the responsibility
536: IF NOT gmd_api_grp.Check_orgn_access( Entity => get_object_rec.object_type,

Line 601: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

597: (get_object_rec.object_type,
598: get_object_rec.object_id,
599: l_dependent_val);
600: IF l_dependent_val THEN
601: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
602: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
603: END IF;
604: END IF;
605:

Line 602: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

598: get_object_rec.object_id,
599: l_dependent_val);
600: IF l_dependent_val THEN
601: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
602: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
603: END IF;
604: END IF;
605:
606: -- Work thro' each object and call its appropriate APIs

Line 781: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

777: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
778: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
779: END IF;
780:
781: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
782: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
783: END IF;
784:
785: ELSIF (l_action_flag IN ('U')) THEN

Line 782: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

778: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
779: END IF;
780:
781: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
782: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
783: END IF;
784:
785: ELSIF (l_action_flag IN ('U')) THEN
786: IF (get_object_rec.replace_type IN ('FORMULA_CLASS','OWNER_ID')) THEN

Line 1061: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1057: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1058: END IF;
1059:
1060:
1061: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1062: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1063: END IF;
1064:
1065: ELSIF (l_action_flag IN ('U')) THEN

Line 1062: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1058: END IF;
1059:
1060:
1061: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1062: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1063: END IF;
1064:
1065: ELSIF (l_action_flag IN ('U')) THEN
1066: -- Perform updates

Line 1236: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1232: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1233: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1234: END IF;
1235:
1236: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1237: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1238: END IF;
1239:
1240: ELSIF (l_action_flag IN ('U')) THEN

Line 1237: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1233: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1234: END IF;
1235:
1236: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1237: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1238: END IF;
1239:
1240: ELSIF (l_action_flag IN ('U')) THEN
1241: p_rout_update_table(1).p_col_to_update := get_object_rec.replace_type;

Line 1430: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1426: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1427: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1428: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1429: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1430: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1431: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1432: END IF;
1433:
1434: ELSIF (l_action_flag IN ('U')) THEN

Line 1431: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1427: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1428: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1429: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1430: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1431: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1432: END IF;
1433:
1434: ELSIF (l_action_flag IN ('U')) THEN
1435: IF (get_object_rec.replace_type

Line 1676: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1672: -- to be removed
1673: -- fnd_msg_pub.add;
1674: END IF;
1675:
1676: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1677: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1678:
1679: -- Set the row counter
1680: l_rowcount := l_rowcount + 1;

Line 1677: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1673: -- fnd_msg_pub.add;
1674: END IF;
1675:
1676: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1677: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1678:
1679: -- Set the row counter
1680: l_rowcount := l_rowcount + 1;
1681: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : Within loop for Row # '

Line 1765: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1761: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1762: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1763: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1764: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1765: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1766: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1767: WHEN OTHERS THEN
1768:
1769: ret_code := 2;

Line 1766: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1762: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1763: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1764: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1765: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1766: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1767: WHEN OTHERS THEN
1768:
1769: ret_code := 2;
1770: err_buf := NULL;

Line 1835: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1831: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1832: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1833: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1834: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1835: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1836: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1837: END; -- End created to handle exception for each record
1838:
1839:

Line 1836: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1832: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1833: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1834: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1835: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1836: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1837: END; -- End created to handle exception for each record
1838:
1839:
1840: END LOOP; -- For all rows that needs to be replaced

Line 1881: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1877: gmd_debug.put_line(g_pkg_name||'.'||l_api_name
1878: ||' : In the No_replace_exception section '
1879: ||' Error text is '||l_error_text);
1880: END IF;
1881: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1882: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1883: -- outer excepption handles all error that occur prior to or after
1884: -- Mass updates (or within LOOP above)
1885:

Line 1882: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1878: ||' : In the No_replace_exception section '
1879: ||' Error text is '||l_error_text);
1880: END IF;
1881: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1882: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1883: -- outer excepption handles all error that occur prior to or after
1884: -- Mass updates (or within LOOP above)
1885:
1886: WHEN OTHERS THEN

Line 1907: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);

1903: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',pnew_name);
1904: END IF;
1905: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
1906: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1907: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1908: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1909:
1910: END Mass_Replace_Operation;
1911:

Line 1908: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

1904: END IF;
1905: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
1906: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
1907: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1908: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1909:
1910: END Mass_Replace_Operation;
1911:
1912: