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.GMI_SHIPPING_UTIL dependencies on FND_PROFILE

Line 153: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

149:
150: IF p_shipping_line.locator_id IS NULL
151: THEN
152: /* hwahdani BUG#:1495550 get proper value of default location from profile */
153: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
154: ELSE
155: SELECT location INTO l_location
156: FROM ic_loct_mst
157: WHERE inventory_location_id = p_shipping_line.locator_id;

Line 220: IF ( l_lot_id = 0 and l_location = FND_PROFILE.VALUE('IC$DEFAULT_LOCT'))

216: ELSE
217: CLOSE get_opm_transaction_c;
218: /* original hwahdani IF ( l_lot_id = 0 and l_location is NULL) THEN */
219: /* BUG#:1495550 check if l_location is not NULL */
220: IF ( l_lot_id = 0 and l_location = FND_PROFILE.VALUE('IC$DEFAULT_LOCT'))
221: THEN
222: GMI_reservation_Util.PrintLn('Default Transaction Is Not LOT/LOC controlled');
223: GMI_reservation_Util.PrintLn('Action is => Revert staged_ind to zero');
224: /* BUG 1577035 BEGIN Set staged_ind = 0 in backorder scenario

Line 286: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

282: /* Set the value of location for Default Transaction */
283: /* Needs to be replaced with profile check in future. */
284:
285: /* hwahdani BUG#:1495550 get proper value of default location from profile */
286: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
287:
288: OPEN default_transaction_c;
289: FETCH default_transaction_c INTO l_trans_id, l_staged_ind;
290: IF default_transaction_c%NOTFOUND THEN

Line 426: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

422: /* Set the value of location for Default Transaction */
423: /* Needs to be replaced with profile check in future. */
424:
425: /* hwahdani BUG#:1495550 get proper value of default location from profile */
426: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
427:
428: OPEN default_transaction_c;
429: FETCH default_transaction_c INTO l_trans_id, l_staged_ind;
430: IF default_transaction_c%NOTFOUND

Line 600: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

596: END IF;
597:
598: END IF;
599: /* hwahdani BUG#:1495550 get proper value of default location from profile */
600: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
601:
602: GMI_RESERVATION_UTIL.find_default_lot
603: ( x_return_status => x_return_status,
604: x_msg_count => l_msg_count,

Line 821: l_allowneginv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);

817:
818: gmi_reservation_util.println('Value of schema name is '||l_schema);
819: -- HW 3385851. Added this fix for Pushkar
820: BEGIN
821: l_allowneginv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);
822: EXCEPTION
823: WHEN OTHERS THEN
824: gmi_reservation_util.println('Error in reading PROFILE: Allow Negative Inventory');
825: l_allowneginv := 0;

Line 876: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

872:
873: IF p_shipping_line.locator_id IS NULL
874: THEN
875: /* hwahdani BUG#:1495550 get proper value of default location from profile */
876: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
877: ELSE
878: SELECT location INTO l_location
879: FROM ic_loct_mst
880: WHERE inventory_location_id = p_shipping_line.locator_id;

Line 1676: l_allowneginv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);

1672: l_new_transaction_rec.whse_code);
1673: /* Bug 2775197 */
1674: -- HW 3385851. Added this fix for Pushkar
1675: BEGIN
1676: l_allowneginv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);
1677: EXCEPTION
1678: WHEN OTHERS THEN
1679: gmi_reservation_util.println('Error in reading PROFILE: Allow Negative Inventory');
1680: l_allowneginv := 0;

Line 2093: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

2089: AND msi.segment1 = iim.item_no;
2090:
2091: IF p_locator_id IS NULL
2092: THEN
2093: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
2094: ELSE
2095: SELECT location INTO l_location
2096: FROM ic_loct_mst
2097: WHERE inventory_location_id = p_locator_id;

Line 2547: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

2543: wsh_util_core.println ( 'Distribution account is ' || l_account );
2544: */
2545: if (l_detail_rec.source_code = 'OE') then
2546: if (WSH_SHIP_CONFIRM_ACTIONS.ont_source_code is NULL) then
2547: WSH_SHIP_CONFIRM_ACTIONS.ont_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
2548: end if;
2549: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;
2550: else
2551: l_source_code := 'OKE';

Line 3144: l_DIR Varchar2(255) := nvl(fnd_profile.value

3140: l_time VARCHAR2(10);
3141: l_trans_count NUMBER;
3142: l_wdd_count NUMBER;
3143: /*
3144: l_DIR Varchar2(255) := nvl(fnd_profile.value
3145: ('OE_DEBUG_LOG_DIRECTORY'), '/tmp');
3146: */
3147:
3148: /*

Line 3236: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

3232: END IF;
3233: CLOSE c_get_item_info;
3234: IF lines.locator_id IS NULL
3235: THEN
3236: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
3237: ELSE
3238: SELECT location INTO l_location
3239: FROM ic_loct_mst
3240: WHERE inventory_location_id = lines.locator_id;

Line 3306: l_default_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

3302: l_old_response := lines.org;
3303: END LOOP; /* FOR ALL ORDERS */
3304:
3305: /* find out the offset lines for unstaged */
3306: l_default_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
3307: FOR lines IN get_unstaged_lines LOOP
3308: l_required_lines := l_required_lines + 1;
3309: IF l_old_response <> lines.org THEN
3310: UTL_FILE.putf(v_outputfile,'\n ****** unstaged shipping lines ******\n');