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_SAMPLES_GRP dependencies on INV_MATERIAL_STATUS_PUB

Line 79: --| Raju Bug 10169386 is fixed by calling the INV_MATERIAL_STATUS_PUB.update_status |

75: --| KISHORE Bug No.8679485 Dt.16-Jul-2009 |
76: --| Added code to change Disposition in the tables GMD_SAMPLING_EVENTS, |
77: --| GMD_EVENT_SPEC_DISP while changing disposition from final to final like Accept to Reject
78: --| Reject -> Accept, Accept -> Accept With Variance etc...
79: --| Raju Bug 10169386 is fixed by calling the INV_MATERIAL_STATUS_PUB.update_status |
80: --| instead if private api to update the material status. |
81: --| PLOWE Bug 12829066 01-Nov-2011 Bug is that with multiple LPNs |
82: --| associated with lot the updates were not occurring with call to |
83: --| the INV_MATERIAL_STATUS_PUB.update_status API. Now we call in a |

Line 83: --| the INV_MATERIAL_STATUS_PUB.update_status API. Now we call in a |

79: --| Raju Bug 10169386 is fixed by calling the INV_MATERIAL_STATUS_PUB.update_status |
80: --| instead if private api to update the material status. |
81: --| PLOWE Bug 12829066 01-Nov-2011 Bug is that with multiple LPNs |
82: --| associated with lot the updates were not occurring with call to |
83: --| the INV_MATERIAL_STATUS_PUB.update_status API. Now we call in a |
84: --| loop for every unique mtl_onhand_quantities_detail record |
85: --| instead if private api to update the material status. |
86: --| Also handles one call with one LPN passed thru from Sample |
87: --| Also handles any loose material update of status if WMS enabled. |

Line 91: --| the INV_MATERIAL_STATUS_PUB.update_status API. Now when |

87: --| Also handles any loose material update of status if WMS enabled. |
88: --| |
89: --| PLOWE Bug 14620426 18-Sep-2012 Bug is that in a certain cases |
90: --| associated with lot the updates were not occurring with call to |
91: --| the INV_MATERIAL_STATUS_PUB.update_status API. Now when |
92: --| with no LPN found and the LPN is NOT passed from sample for |
93: --| a wms enabled org, there will still be a call to update the lot status |
94: --| PLOWE Bug 14769409 - SAMPLE DISPOSITION ERROR |
95: --| GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH AT 030 22-Nov-2012 |

Line 2369: --| Raju Bug 10169386 is fixed by calling the INV_MATERIAL_STATUS_PUB.update_status |

2365: --| |
2366: --|
2367: --|
2368: --| |
2369: --| Raju Bug 10169386 is fixed by calling the INV_MATERIAL_STATUS_PUB.update_status |
2370: --| instead if private api to update the material status. |
2371: --| PLOWE Bug 14620426 18-Sep-2012 Bug is that in a certain cases |
2372: --| associated with lot the updates were not occurring with call to |
2373: --| the INV_MATERIAL_STATUS_PUB.update_status API. Now when |

Line 2373: --| the INV_MATERIAL_STATUS_PUB.update_status API. Now when |

2369: --| Raju Bug 10169386 is fixed by calling the INV_MATERIAL_STATUS_PUB.update_status |
2370: --| instead if private api to update the material status. |
2371: --| PLOWE Bug 14620426 18-Sep-2012 Bug is that in a certain cases |
2372: --| associated with lot the updates were not occurring with call to |
2373: --| the INV_MATERIAL_STATUS_PUB.update_status API. Now when |
2374: --| with no LPN found and the LPN is NOT passed from sample for |
2375: --| a wms enabled org, there will still be a call to update the lot status |
2376: --| PLOWE Bug 14769409 - SAMPLE DISPOSITION ERROR |
2377: --| GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH AT 030 22-Nov-2012 |

Line 2436: l_inv_status_upd_rec_type INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type; -- 12829066 changed position

2432: l_onhand_reason_id NUMBER; -- Bug 91432301
2433:
2434: l_wms_enabled_flag varchar2(1); -- 12829066
2435: l_lpn_id NUMBER; -- 12829066
2436: l_inv_status_upd_rec_type INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type; -- 12829066 changed position
2437:
2438: l_lpn_found NUMBER := 0; -- pal 14620426 sep 14 fix
2439:
2440: req_fields_missing EXCEPTION;

Line 3013: gmd_debug.put_line('INV_MATERIAL_STATUS_PUB.update_status - lpn passed from sample = :'||l_lpn_id);

3009: -- fix for 12829066 -- pal
3010:
3011:
3012: IF (l_debug = 'Y') THEN
3013: gmd_debug.put_line('INV_MATERIAL_STATUS_PUB.update_status - lpn passed from sample = :'||l_lpn_id);
3014: END IF;
3015:
3016: IF l_lpn_id <> 0 THEN -- 12829066 lpn is passed from sample
3017:

Line 3019: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn is passed from sample - with l_lpn_id :'||l_lpn_id);

3015:
3016: IF l_lpn_id <> 0 THEN -- 12829066 lpn is passed from sample
3017:
3018: IF (l_debug = 'Y') THEN
3019: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn is passed from sample - with l_lpn_id :'||l_lpn_id);
3020: END IF;
3021:
3022: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3023:

Line 3026: INV_MATERIAL_STATUS_PUB.update_status

3022: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3023:
3024: -- call API with LPN once
3025:
3026: INV_MATERIAL_STATUS_PUB.update_status
3027: (p_api_version_number => 1.0,
3028: p_init_msg_lst => fnd_api.g_false,
3029: p_commit => fnd_api.g_false,
3030: x_return_status => x_return_status,

Line 3049: gmd_debug.put_line('about to try to call INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is wms enabled');

3045:
3046: IF l_wms_enabled_flag = 'Y' then -- 12829066 check if org is wms enabled
3047:
3048: IF (l_debug = 'Y') THEN
3049: gmd_debug.put_line('about to try to call INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is wms enabled');
3050: END IF;
3051: -- need to loop round moqd and update status for all lpns associated with that item and org
3052:
3053: OPEN cur_get_lpn;

Line 3067: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);

3063: END IF;
3064: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3065:
3066: IF (l_debug = 'Y') THEN
3067: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);
3068: END IF;
3069:
3070: INV_MATERIAL_STATUS_PUB.update_status
3071: (p_api_version_number => 1.0,

Line 3070: INV_MATERIAL_STATUS_PUB.update_status

3066: IF (l_debug = 'Y') THEN
3067: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);
3068: END IF;
3069:
3070: INV_MATERIAL_STATUS_PUB.update_status
3071: (p_api_version_number => 1.0,
3072: p_init_msg_lst => fnd_api.g_false,
3073: p_commit => fnd_api.g_false,
3074: x_return_status => x_return_status,

Line 3093: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);

3089:
3090: ELSE -- 12829066 NOT wms_enabled
3091:
3092: IF (l_debug = 'Y') THEN
3093: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);
3094: END IF;
3095:
3096:
3097: -- call API with null LPN

Line 3098: INV_MATERIAL_STATUS_PUB.update_status

3094: END IF;
3095:
3096:
3097: -- call API with null LPN
3098: INV_MATERIAL_STATUS_PUB.update_status
3099: (p_api_version_number => 1.0,
3100: p_init_msg_lst => fnd_api.g_false,
3101: p_commit => fnd_api.g_false,
3102: x_return_status => x_return_status,

Line 3177: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status lot number is not null - lpn is passed from sample - with l_lpn_id :'||l_lpn_id);

3173: IF l_lpn_id <> 0 THEN -- 12829066 lpn is passed from sample
3174:
3175:
3176: IF (l_debug = 'Y') THEN
3177: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status lot number is not null - lpn is passed from sample - with l_lpn_id :'||l_lpn_id);
3178: END IF;
3179:
3180: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3181:

Line 3184: INV_MATERIAL_STATUS_PUB.update_status

3180: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3181:
3182: -- call API with LPN once
3183:
3184: INV_MATERIAL_STATUS_PUB.update_status
3185: (p_api_version_number => 1.0,
3186: p_init_msg_lst => fnd_api.g_false,
3187: p_commit => fnd_api.g_false,
3188: x_return_status => x_return_status,

Line 3217: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status ; lot number is not null - LOOSE MATERIAL IN THIS mtl_onhand_quantities_detail FOR ORG, LOCATOR AND LOT . LOT = :'|| l_inv_status_upd_rec_type.lot_number);

3213: else
3214: CLOSE cur_get_loose_lpn;
3215:
3216: IF (l_debug = 'Y') THEN
3217: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status ; lot number is not null - LOOSE MATERIAL IN THIS mtl_onhand_quantities_detail FOR ORG, LOCATOR AND LOT . LOT = :'|| l_inv_status_upd_rec_type.lot_number);
3218: END IF;
3219:
3220: l_inv_status_upd_rec_type.LPN_ID := NULL;
3221:

Line 3222: INV_MATERIAL_STATUS_PUB.update_status

3218: END IF;
3219:
3220: l_inv_status_upd_rec_type.LPN_ID := NULL;
3221:
3222: INV_MATERIAL_STATUS_PUB.update_status
3223: (p_api_version_number => 1.0,
3224: p_init_msg_lst => fnd_api.g_false,
3225: p_commit => fnd_api.g_false,
3226: x_return_status => x_return_status,

Line 3250: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status lot number is not null - lpn NOT passed from sample - org is wms enabled');

3246: IF l_wms_enabled_flag = 'Y' then -- 12829066 check if org is wms enabled
3247:
3248: -- need to loop round moqd and update status for all lpns associated with that item and org
3249: IF (l_debug = 'Y') THEN
3250: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status lot number is not null - lpn NOT passed from sample - org is wms enabled');
3251: END IF;
3252: l_lpn_found := 0; -- pal 14620426 sep 14 fix
3253:
3254:

Line 3264: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);

3260: -- call API with LPN in a loop
3261: l_inv_status_upd_rec_type.LPN_ID := l_lpn_id;
3262: l_lpn_found := 1; -- pal 14620426 sep 14 fix
3263: IF (l_debug = 'Y') THEN
3264: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);
3265: END IF;
3266:
3267: INV_MATERIAL_STATUS_PUB.update_status
3268: (p_api_version_number => 1.0,

Line 3267: INV_MATERIAL_STATUS_PUB.update_status

3263: IF (l_debug = 'Y') THEN
3264: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with LPN in a loop with l_lpn_id :'||l_lpn_id);
3265: END IF;
3266:
3267: INV_MATERIAL_STATUS_PUB.update_status
3268: (p_api_version_number => 1.0,
3269: p_init_msg_lst => fnd_api.g_false,
3270: p_commit => fnd_api.g_false,
3271: x_return_status => x_return_status,

Line 3291: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with no LPN found lpn NOT passed from sample - org is wms enabled ; lot number :'|| l_inv_status_upd_rec_type.lot_number);

3287: -- pal 14620426 sep 14 fix
3288: IF l_lpn_found <> 1 then
3289:
3290: IF (l_debug = 'Y') THEN
3291: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with no LPN found lpn NOT passed from sample - org is wms enabled ; lot number :'|| l_inv_status_upd_rec_type.lot_number);
3292: END IF;
3293: INV_MATERIAL_STATUS_PUB.update_status
3294: (p_api_version_number => 1.0,
3295: p_init_msg_lst => fnd_api.g_false,

Line 3293: INV_MATERIAL_STATUS_PUB.update_status

3289:
3290: IF (l_debug = 'Y') THEN
3291: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status API with no LPN found lpn NOT passed from sample - org is wms enabled ; lot number :'|| l_inv_status_upd_rec_type.lot_number);
3292: END IF;
3293: INV_MATERIAL_STATUS_PUB.update_status
3294: (p_api_version_number => 1.0,
3295: p_init_msg_lst => fnd_api.g_false,
3296: p_commit => fnd_api.g_false,
3297: x_return_status => x_return_status,

Line 3315: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);

3311: ELSE -- 12829066 not wms_enabled
3312:
3313:
3314: IF (l_debug = 'Y') THEN
3315: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);
3316: END IF;
3317: -- call API with null LPN
3318: INV_MATERIAL_STATUS_PUB.update_status
3319: (p_api_version_number => 1.0,

Line 3318: INV_MATERIAL_STATUS_PUB.update_status

3314: IF (l_debug = 'Y') THEN
3315: gmd_debug.put_line('calling INV_MATERIAL_STATUS_PUB.update_status - lpn NOT passed from sample - org is NOT wms enabled with l_lpn_id :'||l_lpn_id);
3316: END IF;
3317: -- call API with null LPN
3318: INV_MATERIAL_STATUS_PUB.update_status
3319: (p_api_version_number => 1.0,
3320: p_init_msg_lst => fnd_api.g_false,
3321: p_commit => fnd_api.g_false,
3322: x_return_status => x_return_status,