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 678: FND_FILE.NEW_LINE(FND_FILE.LOG,1);

674:
675: -- Making new line entry and prompting users about MSNR request
676: -- Bug# 5008299 Kapil M
677: -- Moved the code for log file so that it is shown for every replace
678: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
679: FND_MESSAGE.SET_NAME('GMD','GMD_MSNR_REPLACE_MESG');
680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);

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

680: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
684: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
685: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
686:
687: -- NPD Conv.
688: -- Check if the Entity Owning organization is available for the responsibility

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

681: FND_MESSAGE.SET_TOKEN('NAME',get_object_rec.object_name);
682: FND_MESSAGE.SET_TOKEN('VERSION',get_object_rec.object_vers);
683: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
684: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
685: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
686:
687: -- NPD Conv.
688: -- Check if the Entity Owning organization is available for the responsibility
689: IF NOT gmd_api_grp.Check_orgn_access( Entity => get_object_rec.object_type,

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

750: (get_object_rec.object_type,
751: get_object_rec.object_id,
752: l_dependent_val);
753: IF l_dependent_val THEN
754: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
755: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
756: END IF;
757: END IF;
758:

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

751: get_object_rec.object_id,
752: l_dependent_val);
753: IF l_dependent_val THEN
754: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
755: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
756: END IF;
757: END IF;
758:
759: -- Work thro' each object and call its appropriate APIs

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

930: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
931: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
932: END IF;
933:
934: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
935: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
936: END IF;
937:
938: ELSIF (l_action_flag IN ('U')) THEN

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

931: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
932: END IF;
933:
934: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
935: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
936: END IF;
937:
938: ELSIF (l_action_flag IN ('U')) THEN
939: IF (get_object_rec.replace_type IN ('FORMULA_CLASS','OWNER_ID')) THEN

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

1210: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1211: END IF;
1212:
1213:
1214: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1215: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1216: END IF;
1217:
1218: ELSIF (l_action_flag IN ('U')) THEN

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

1211: END IF;
1212:
1213:
1214: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1215: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1216: END IF;
1217:
1218: ELSIF (l_action_flag IN ('U')) THEN
1219: -- Perform updates

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

1385: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',get_object_rec.replace_type);
1386: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1387: END IF;
1388:
1389: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1390: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1391: END IF;
1392:
1393: ELSIF (l_action_flag IN ('U')) THEN

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

1386: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1387: END IF;
1388:
1389: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1390: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1391: END IF;
1392:
1393: ELSIF (l_action_flag IN ('U')) THEN
1394: p_rout_update_table(1).p_col_to_update := get_object_rec.replace_type;

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

1595: FND_MESSAGE.SET_TOKEN('VERSION',l_object_version);
1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1599: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1600: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1601: END IF;
1602:
1603: ELSIF (l_action_flag IN ('U')) THEN

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

1596: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1597: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1598: FND_MESSAGE.SET_TOKEN('NEW_ITEM',get_object_rec.new_name);
1599: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1600: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1601: END IF;
1602:
1603: ELSIF (l_action_flag IN ('U')) THEN
1604: IF (get_object_rec.replace_type

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

1858: -- to be removed
1859: -- fnd_msg_pub.add;
1860: END IF;
1861:
1862: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1863: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1864:
1865: -- Set the row counter
1866: l_rowcount := l_rowcount + 1;

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

1859: -- fnd_msg_pub.add;
1860: END IF;
1861:
1862: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1863: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1864:
1865: -- Set the row counter
1866: l_rowcount := l_rowcount + 1;
1867: gmd_debug.put_line(g_pkg_name||'.'||l_api_name||' : Within loop for Row # '

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

1947: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1949: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1950: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1951: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1952: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1953: WHEN OTHERS THEN
1954:
1955: ret_code := 2;

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

1948: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
1949: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
1950: FND_MESSAGE.SET_TOKEN('ERRMSG',l_error_text);
1951: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
1952: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
1953: WHEN OTHERS THEN
1954:
1955: ret_code := 2;
1956: err_buf := NULL;

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

2017: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',get_object_rec.object_name);
2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
2019: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
2020: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2021: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2022: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2023: END; -- End created to handle exception for each record
2024:
2025:

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

2018: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',get_object_rec.object_type);
2019: FND_MESSAGE.SET_TOKEN('OBJECT_VERS',get_object_rec.object_vers);
2020: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2021: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2022: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2023: END; -- End created to handle exception for each record
2024:
2025:
2026: END LOOP; -- For all rows that needs to be replaced

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

2063: gmd_debug.put_line(g_pkg_name||'.'||l_api_name
2064: ||' : In the No_replace_exception section '
2065: ||' Error text is '||l_error_text);
2066: END IF;
2067: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2068: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2069: -- outer excepption handles all error that occur prior to or after
2070: -- Mass updates (or within LOOP above)
2071:

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

2064: ||' : In the No_replace_exception section '
2065: ||' Error text is '||l_error_text);
2066: END IF;
2067: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2068: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2069: -- outer excepption handles all error that occur prior to or after
2070: -- Mass updates (or within LOOP above)
2071:
2072: WHEN OTHERS THEN

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

2089: FND_MESSAGE.SET_TOKEN('REPLACE_VALUE',pnew_name);
2090: END IF;
2091: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
2092: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2093: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2094: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2095:
2096: END Mass_Replace_Operation;
2097:

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

2090: END IF;
2091: FND_MESSAGE.SET_TOKEN('OBJECT_TYPE',pObject_type);
2092: FND_MESSAGE.SET_TOKEN('ERRMSG',SQLERRM);
2093: FND_FILE.PUT(FND_FILE.LOG,FND_MESSAGE.GET);
2094: FND_FILE.NEW_LINE(FND_FILE.LOG,1);
2095:
2096: END Mass_Replace_Operation;
2097:
2098: