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.GME_PENDING_PRODUCT_LOTS_PVT dependencies on GME_DEBUG

Line 40: IF g_debug <= gme_debug.g_log_procedure THEN

36: ORDER BY sequence asc, lot_number asc;
37:
38: l_api_name CONSTANT VARCHAR2 (30) := 'GET_PENDING_LOT';
39: BEGIN
40: IF g_debug <= gme_debug.g_log_procedure THEN
41: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
42: END IF;
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:

Line 41: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

37:
38: l_api_name CONSTANT VARCHAR2 (30) := 'GET_PENDING_LOT';
39: BEGIN
40: IF g_debug <= gme_debug.g_log_procedure THEN
41: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
42: END IF;
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: OPEN cur_get_lots(p_material_detail_id);

Line 49: IF g_debug <= gme_debug.g_log_procedure THEN

45: OPEN cur_get_lots(p_material_detail_id);
46: FETCH cur_get_lots BULK COLLECT INTO x_pending_product_lot_tbl;
47: CLOSE cur_get_lots;
48:
49: IF g_debug <= gme_debug.g_log_procedure THEN
50: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
51: END IF;
52: EXCEPTION
53: WHEN OTHERS THEN

Line 50: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

46: FETCH cur_get_lots BULK COLLECT INTO x_pending_product_lot_tbl;
47: CLOSE cur_get_lots;
48:
49: IF g_debug <= gme_debug.g_log_procedure THEN
50: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
51: END IF;
52: EXCEPTION
53: WHEN OTHERS THEN
54: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 54: IF g_debug <= gme_debug.g_log_unexpected THEN

50: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
51: END IF;
52: EXCEPTION
53: WHEN OTHERS THEN
54: IF g_debug <= gme_debug.g_log_unexpected THEN
55: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
56: END IF;
57: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 55: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

51: END IF;
52: EXCEPTION
53: WHEN OTHERS THEN
54: IF g_debug <= gme_debug.g_log_unexpected THEN
55: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
56: END IF;
57: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
58: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
59: END get_pending_lot;

Line 80: IF g_debug <= gme_debug.g_log_procedure THEN

76: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
77: l_return_status VARCHAR2(1);
78: error_delete_row EXCEPTION;
79: BEGIN
80: IF g_debug <= gme_debug.g_log_procedure THEN
81: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
82: END IF;
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:

Line 81: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

77: l_return_status VARCHAR2(1);
78: error_delete_row EXCEPTION;
79: BEGIN
80: IF g_debug <= gme_debug.g_log_procedure THEN
81: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
82: END IF;
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: OPEN cur_get_pending_lot_qty(p_pending_lot_id);

Line 128: IF g_debug <= gme_debug.g_log_procedure THEN

124: WHERE pending_product_lot_id = p_pending_lot_id;
125: END IF; -- IF l_sec_qty IS NOT NULL THEN
126: END IF; -- IF p_quantity >= l_qty THEN
127:
128: IF g_debug <= gme_debug.g_log_procedure THEN
129: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
130: END IF;
131: EXCEPTION
132: --Bug#5186388

Line 129: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

125: END IF; -- IF l_sec_qty IS NOT NULL THEN
126: END IF; -- IF p_quantity >= l_qty THEN
127:
128: IF g_debug <= gme_debug.g_log_procedure THEN
129: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
130: END IF;
131: EXCEPTION
132: --Bug#5186388
133: WHEN ERROR_DELETE_ROW THEN

Line 136: IF g_debug <= gme_debug.g_log_unexpected THEN

132: --Bug#5186388
133: WHEN ERROR_DELETE_ROW THEN
134: x_return_status := l_return_status;
135: WHEN OTHERS THEN
136: IF g_debug <= gme_debug.g_log_unexpected THEN
137: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
138: END IF;
139: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 137: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

133: WHEN ERROR_DELETE_ROW THEN
134: x_return_status := l_return_status;
135: WHEN OTHERS THEN
136: IF g_debug <= gme_debug.g_log_unexpected THEN
137: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
138: END IF;
139: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: END relieve_pending_lot;

Line 190: IF g_debug <= gme_debug.g_log_procedure THEN

186:
187: l_api_name CONSTANT VARCHAR2 (30) := 'create_product_lot';
188: BEGIN
189:
190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
192: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_organization_id= '||p_organization_id);
193: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_inventory_item_id= '||p_inventory_item_id);
194: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_parent_lot= '||p_parent_lot);

Line 191: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

187: l_api_name CONSTANT VARCHAR2 (30) := 'create_product_lot';
188: BEGIN
189:
190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
192: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_organization_id= '||p_organization_id);
193: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_inventory_item_id= '||p_inventory_item_id);
194: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_parent_lot= '||p_parent_lot);
195: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);

Line 192: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_organization_id= '||p_organization_id);

188: BEGIN
189:
190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
192: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_organization_id= '||p_organization_id);
193: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_inventory_item_id= '||p_inventory_item_id);
194: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_parent_lot= '||p_parent_lot);
195: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
196: FOR i in 1..p_mmli_tbl.count LOOP

Line 193: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_inventory_item_id= '||p_inventory_item_id);

189:
190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
192: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_organization_id= '||p_organization_id);
193: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_inventory_item_id= '||p_inventory_item_id);
194: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_parent_lot= '||p_parent_lot);
195: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
196: FOR i in 1..p_mmli_tbl.count LOOP
197: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);

Line 194: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_parent_lot= '||p_parent_lot);

190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
192: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_organization_id= '||p_organization_id);
193: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_inventory_item_id= '||p_inventory_item_id);
194: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_parent_lot= '||p_parent_lot);
195: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
196: FOR i in 1..p_mmli_tbl.count LOOP
197: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);
198: END LOOP;

Line 195: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);

191: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
192: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_organization_id= '||p_organization_id);
193: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_inventory_item_id= '||p_inventory_item_id);
194: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_parent_lot= '||p_parent_lot);
195: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
196: FOR i in 1..p_mmli_tbl.count LOOP
197: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);
198: END LOOP;
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_lot= '||p_generate_lot);

Line 197: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);

193: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_inventory_item_id= '||p_inventory_item_id);
194: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_parent_lot= '||p_parent_lot);
195: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
196: FOR i in 1..p_mmli_tbl.count LOOP
197: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);
198: END LOOP;
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_lot= '||p_generate_lot);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_parent_lot= '||p_generate_parent_lot);
201: END IF;

Line 199: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_lot= '||p_generate_lot);

195: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
196: FOR i in 1..p_mmli_tbl.count LOOP
197: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);
198: END LOOP;
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_lot= '||p_generate_lot);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_parent_lot= '||p_generate_parent_lot);
201: END IF;
202:
203: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 200: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_parent_lot= '||p_generate_parent_lot);

196: FOR i in 1..p_mmli_tbl.count LOOP
197: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);
198: END LOOP;
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_lot= '||p_generate_lot);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_generate_parent_lot= '||p_generate_parent_lot);
201: END IF;
202:
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
204:

Line 217: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

213: END IF;
214: END LOOP;
215:
216: IF l_null_lot_number THEN
217: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
218: gme_debug.put_line (g_pkg_name||'.'||l_api_name
219: ||' p_generate is false and there are null lot numbers');
220: END IF;
221: RAISE error_null_lots;

Line 218: gme_debug.put_line (g_pkg_name||'.'||l_api_name

214: END LOOP;
215:
216: IF l_null_lot_number THEN
217: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
218: gme_debug.put_line (g_pkg_name||'.'||l_api_name
219: ||' p_generate is false and there are null lot numbers');
220: END IF;
221: RAISE error_null_lots;
222: END IF;

Line 255: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

251: ,x_msg_count => l_msg_count
252: ,x_msg_data => l_msg_data);
253:
254: IF x_return_status <> fnd_api.g_ret_sts_success THEN
255: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
256: gme_debug.put_line (g_pkg_name||'.'||l_api_name
257: ||'auto_gen_lot for parent returned '
258: || x_return_status);
259: END IF;

Line 256: gme_debug.put_line (g_pkg_name||'.'||l_api_name

252: ,x_msg_data => l_msg_data);
253:
254: IF x_return_status <> fnd_api.g_ret_sts_success THEN
255: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
256: gme_debug.put_line (g_pkg_name||'.'||l_api_name
257: ||'auto_gen_lot for parent returned '
258: || x_return_status);
259: END IF;
260: RAISE error_gen_parent_lot;

Line 263: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

259: END IF;
260: RAISE error_gen_parent_lot;
261: END IF;
262:
263: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
264: gme_debug.put_line (g_pkg_name||'.'||l_api_name
265: ||'auto_gen_lot for parent'
266: || ':'
267: || 'l_parent_lot= '

Line 264: gme_debug.put_line (g_pkg_name||'.'||l_api_name

260: RAISE error_gen_parent_lot;
261: END IF;
262:
263: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
264: gme_debug.put_line (g_pkg_name||'.'||l_api_name
265: ||'auto_gen_lot for parent'
266: || ':'
267: || 'l_parent_lot= '
268: || l_parent_lot);

Line 300: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

296: ,x_msg_count => l_msg_count
297: ,x_msg_data => l_msg_data);
298:
299: IF x_return_status <> fnd_api.g_ret_sts_success THEN
300: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
301: gme_debug.put_line (g_pkg_name||'.'||l_api_name
302: ||'auto_gen_lot'
303: || ':'
304: || 'l_gen_lot '

Line 301: gme_debug.put_line (g_pkg_name||'.'||l_api_name

297: ,x_msg_data => l_msg_data);
298:
299: IF x_return_status <> fnd_api.g_ret_sts_success THEN
300: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
301: gme_debug.put_line (g_pkg_name||'.'||l_api_name
302: ||'auto_gen_lot'
303: || ':'
304: || 'l_gen_lot '
305: || x_return_status);

Line 310: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

306: END IF;
307: RAISE error_gen_lot;
308: END IF;
309:
310: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
311: gme_debug.put_line (g_pkg_name||'.'||l_api_name
312: ||'auto_gen_lot'
313: || ':'
314: || 'l_gen_lot= '

Line 311: gme_debug.put_line (g_pkg_name||'.'||l_api_name

307: RAISE error_gen_lot;
308: END IF;
309:
310: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
311: gme_debug.put_line (g_pkg_name||'.'||l_api_name
312: ||'auto_gen_lot'
313: || ':'
314: || 'l_gen_lot= '
315: || l_gen_lot);

Line 371: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

367:
368: x_mmli_tbl (i).parent_lot_number := l_parent_lot;
369: END LOOP; -- FOR i IN 1 .. l_mmli_tbl.COUNT LOOP
370:
371: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
372: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
373: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
374: FOR i in 1..p_mmli_tbl.count LOOP
375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);

Line 372: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

368: x_mmli_tbl (i).parent_lot_number := l_parent_lot;
369: END LOOP; -- FOR i IN 1 .. l_mmli_tbl.COUNT LOOP
370:
371: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
372: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
373: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
374: FOR i in 1..p_mmli_tbl.count LOOP
375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);
376: END LOOP;

Line 373: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);

369: END LOOP; -- FOR i IN 1 .. l_mmli_tbl.COUNT LOOP
370:
371: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
372: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
373: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
374: FOR i in 1..p_mmli_tbl.count LOOP
375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);
376: END LOOP;
377: END IF;

Line 375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);

371: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
372: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
373: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot count= '||p_mmli_tbl.count);
374: FOR i in 1..p_mmli_tbl.count LOOP
375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot number= '||p_mmli_tbl (i).lot_number);
376: END LOOP;
377: END IF;
378:
379: EXCEPTION

Line 386: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

382: WHEN error_not_prod OR error_lot_create OR error_gen_lot_no_create OR error_null_lots OR error_null_exp_dt THEN
383: x_return_status := fnd_api.g_ret_sts_error;
384: WHEN OTHERS THEN
385: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
386: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
387: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
388: END IF;
389: x_return_status := FND_API.g_ret_sts_unexp_error;
390:

Line 387: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);

383: x_return_status := fnd_api.g_ret_sts_error;
384: WHEN OTHERS THEN
385: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
386: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
387: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
388: END IF;
389: x_return_status := FND_API.g_ret_sts_unexp_error;
390:
391: END create_product_lot;

Line 405: IF g_debug <= gme_debug.g_log_procedure THEN

401: l_api_name CONSTANT VARCHAR2 (30) := 'create_pending_product_lot';
402:
403: BEGIN
404:
405: IF g_debug <= gme_debug.g_log_procedure THEN
406: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
407: END IF;
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409:

Line 406: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

402:
403: BEGIN
404:
405: IF g_debug <= gme_debug.g_log_procedure THEN
406: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
407: END IF;
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409:
410: IF NOT gme_pending_product_lots_dbl.insert_row

Line 418: IF g_debug <= gme_debug.g_log_procedure THEN

414: END IF;
415:
416: x_pending_product_lots_rec := l_pp_lot_rec;
417:
418: IF g_debug <= gme_debug.g_log_procedure THEN
419: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
420: END IF;
421:
422: EXCEPTION

Line 419: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

415:
416: x_pending_product_lots_rec := l_pp_lot_rec;
417:
418: IF g_debug <= gme_debug.g_log_procedure THEN
419: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
420: END IF;
421:
422: EXCEPTION
423: WHEN error_insert_row THEN

Line 427: IF g_debug <= gme_debug.g_log_unexpected THEN

423: WHEN error_insert_row THEN
424: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
425: x_return_status := FND_API.g_ret_sts_unexp_error;
426: WHEN OTHERS THEN
427: IF g_debug <= gme_debug.g_log_unexpected THEN
428: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
429: END IF;
430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 428: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

424: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
425: x_return_status := FND_API.g_ret_sts_unexp_error;
426: WHEN OTHERS THEN
427: IF g_debug <= gme_debug.g_log_unexpected THEN
428: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
429: END IF;
430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: END create_pending_product_lot;

Line 445: IF g_debug <= gme_debug.g_log_procedure THEN

441: l_api_name CONSTANT VARCHAR2 (30) := 'update_pending_product_lot';
442:
443: BEGIN
444:
445: IF g_debug <= gme_debug.g_log_procedure THEN
446: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
447: END IF;
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449:

Line 446: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

442:
443: BEGIN
444:
445: IF g_debug <= gme_debug.g_log_procedure THEN
446: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
447: END IF;
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449:
450: IF NOT gme_pending_product_lots_dbl.update_row

Line 461: IF g_debug <= gme_debug.g_log_procedure THEN

457: ,x_pending_product_lots_rec => x_pending_product_lots_rec) THEN
458: RAISE error_fetch_row;
459: END IF;
460:
461: IF g_debug <= gme_debug.g_log_procedure THEN
462: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
463: END IF;
464:
465: EXCEPTION

Line 462: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

458: RAISE error_fetch_row;
459: END IF;
460:
461: IF g_debug <= gme_debug.g_log_procedure THEN
462: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
463: END IF;
464:
465: EXCEPTION
466: WHEN error_update_row OR error_fetch_row THEN

Line 470: IF g_debug <= gme_debug.g_log_unexpected THEN

466: WHEN error_update_row OR error_fetch_row THEN
467: -- error message set in fetch routine
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: WHEN OTHERS THEN
470: IF g_debug <= gme_debug.g_log_unexpected THEN
471: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
472: END IF;
473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 471: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

467: -- error message set in fetch routine
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: WHEN OTHERS THEN
470: IF g_debug <= gme_debug.g_log_unexpected THEN
471: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
472: END IF;
473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: END update_pending_product_lot;

Line 486: IF g_debug <= gme_debug.g_log_procedure THEN

482: l_api_name CONSTANT VARCHAR2 (30) := 'delete_pending_product_lot';
483:
484: BEGIN
485:
486: IF g_debug <= gme_debug.g_log_procedure THEN
487: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
488: END IF;
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490:

Line 487: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

483:
484: BEGIN
485:
486: IF g_debug <= gme_debug.g_log_procedure THEN
487: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
488: END IF;
489: x_return_status := FND_API.G_RET_STS_SUCCESS;
490:
491: IF NOT gme_pending_product_lots_dbl.delete_row

Line 496: IF g_debug <= gme_debug.g_log_procedure THEN

492: (p_pending_product_lots_rec => p_pending_product_lots_rec) THEN
493: RAISE error_delete_row;
494: END IF;
495:
496: IF g_debug <= gme_debug.g_log_procedure THEN
497: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
498: END IF;
499:
500: EXCEPTION

Line 497: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

493: RAISE error_delete_row;
494: END IF;
495:
496: IF g_debug <= gme_debug.g_log_procedure THEN
497: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
498: END IF;
499:
500: EXCEPTION
501: WHEN error_delete_row THEN

Line 505: IF g_debug <= gme_debug.g_log_unexpected THEN

501: WHEN error_delete_row THEN
502: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
503: x_return_status := FND_API.g_ret_sts_unexp_error;
504: WHEN OTHERS THEN
505: IF g_debug <= gme_debug.g_log_unexpected THEN
506: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
507: END IF;
508: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 506: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

502: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
503: x_return_status := FND_API.g_ret_sts_unexp_error;
504: WHEN OTHERS THEN
505: IF g_debug <= gme_debug.g_log_unexpected THEN
506: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
507: END IF;
508: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: END delete_pending_product_lot;

Line 527: IF g_debug <= gme_debug.g_log_procedure THEN

523: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
524:
525: error_delete_row EXCEPTION;
526: BEGIN
527: IF g_debug <= gme_debug.g_log_procedure THEN
528: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
529: END IF;
530: x_return_status := FND_API.G_RET_STS_SUCCESS;
531:

Line 528: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

524:
525: error_delete_row EXCEPTION;
526: BEGIN
527: IF g_debug <= gme_debug.g_log_procedure THEN
528: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
529: END IF;
530: x_return_status := FND_API.G_RET_STS_SUCCESS;
531:
532: IF p_material_detail_id IS NOT NULL THEN

Line 547: IF g_debug <= gme_debug.g_log_procedure THEN

543: END LOOP;
544: CLOSE c_get_pending_lots;
545: END IF; /* p_material_detail_id IS NOT NULL*/
546:
547: IF g_debug <= gme_debug.g_log_procedure THEN
548: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
549: END IF;
550:
551: EXCEPTION

Line 548: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

544: CLOSE c_get_pending_lots;
545: END IF; /* p_material_detail_id IS NOT NULL*/
546:
547: IF g_debug <= gme_debug.g_log_procedure THEN
548: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
549: END IF;
550:
551: EXCEPTION
552: WHEN error_delete_row THEN

Line 556: IF g_debug <= gme_debug.g_log_unexpected THEN

552: WHEN error_delete_row THEN
553: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
554: x_return_status := FND_API.g_ret_sts_unexp_error;
555: WHEN OTHERS THEN
556: IF g_debug <= gme_debug.g_log_unexpected THEN
557: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
558: END IF;
559: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 557: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

553: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
554: x_return_status := FND_API.g_ret_sts_unexp_error;
555: WHEN OTHERS THEN
556: IF g_debug <= gme_debug.g_log_unexpected THEN
557: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
558: END IF;
559: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: END delete_pending_product_lot;

Line 578: IF g_debug <= gme_debug.g_log_procedure THEN

574: error_get_item_rec EXCEPTION;
575:
576: BEGIN
577:
578: IF g_debug <= gme_debug.g_log_procedure THEN
579: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
580: END IF;
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:

Line 579: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

575:
576: BEGIN
577:
578: IF g_debug <= gme_debug.g_log_procedure THEN
579: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
580: END IF;
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: gme_material_detail_pvt.get_item_rec

Line 612: IF g_debug <= gme_debug.g_log_procedure THEN

608: RAISE error_no_lot_create;
609: END IF;
610: END IF;
611:
612: IF g_debug <= gme_debug.g_log_procedure THEN
613: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
614: END IF;
615:
616: EXCEPTION

Line 613: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

609: END IF;
610: END IF;
611:
612: IF g_debug <= gme_debug.g_log_procedure THEN
613: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
614: END IF;
615:
616: EXCEPTION
617: WHEN error_not_lot_control OR error_no_lot_create THEN

Line 620: IF g_debug <= gme_debug.g_log_unexpected THEN

616: EXCEPTION
617: WHEN error_not_lot_control OR error_no_lot_create THEN
618: x_return_status := fnd_api.g_ret_sts_error;
619: WHEN OTHERS THEN
620: IF g_debug <= gme_debug.g_log_unexpected THEN
621: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
622: END IF;
623: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 621: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

617: WHEN error_not_lot_control OR error_no_lot_create THEN
618: x_return_status := fnd_api.g_ret_sts_error;
619: WHEN OTHERS THEN
620: IF g_debug <= gme_debug.g_log_unexpected THEN
621: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
622: END IF;
623: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
625: END validate_material_for_create;

Line 641: IF g_debug <= gme_debug.g_log_procedure THEN

637:
638: l_sequ NUMBER;
639:
640: BEGIN
641: IF g_debug <= gme_debug.g_log_procedure THEN
642: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
643: END IF;
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645:

Line 642: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);

638: l_sequ NUMBER;
639:
640: BEGIN
641: IF g_debug <= gme_debug.g_log_procedure THEN
642: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
643: END IF;
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645:
646: OPEN cur_get_sequ(p_matl_dtl_id);

Line 650: IF g_debug <= gme_debug.g_log_procedure THEN

646: OPEN cur_get_sequ(p_matl_dtl_id);
647: FETCH cur_get_sequ INTO l_sequ;
648: CLOSE cur_get_sequ;
649:
650: IF g_debug <= gme_debug.g_log_procedure THEN
651: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
652: END IF;
653:
654: RETURN NVL(l_sequ, 0);

Line 651: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);

647: FETCH cur_get_sequ INTO l_sequ;
648: CLOSE cur_get_sequ;
649:
650: IF g_debug <= gme_debug.g_log_procedure THEN
651: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
652: END IF;
653:
654: RETURN NVL(l_sequ, 0);
655:

Line 658: IF g_debug <= gme_debug.g_log_unexpected THEN

654: RETURN NVL(l_sequ, 0);
655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: IF g_debug <= gme_debug.g_log_unexpected THEN
659: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
660: END IF;
661: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 659: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: IF g_debug <= gme_debug.g_log_unexpected THEN
659: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
660: END IF;
661: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: END get_last_sequence;

Line 694: IF g_debug <= gme_debug.g_log_procedure THEN

690: l_sequence NUMBER;
691:
692: BEGIN
693:
694: IF g_debug <= gme_debug.g_log_procedure THEN
695: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
696: END IF;
697: x_return_status := FND_API.G_RET_STS_SUCCESS;
698:

Line 695: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

691:
692: BEGIN
693:
694: IF g_debug <= gme_debug.g_log_procedure THEN
695: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
696: END IF;
697: x_return_status := FND_API.G_RET_STS_SUCCESS;
698:
699: x_pending_product_lots_rec.batch_id := p_material_detail_rec.batch_id;

Line 834: IF g_debug <= gme_debug.g_log_procedure THEN

830: LAST_UPDATED_BY
831: LAST_UPDATE_LOGIN
832: */
833:
834: IF g_debug <= gme_debug.g_log_procedure THEN
835: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
836: END IF;
837:
838: EXCEPTION

Line 835: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

831: LAST_UPDATE_LOGIN
832: */
833:
834: IF g_debug <= gme_debug.g_log_procedure THEN
835: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
836: END IF;
837:
838: EXCEPTION
839: WHEN error_validate OR error_create_lot OR error_get_item THEN

Line 842: IF g_debug <= gme_debug.g_log_unexpected THEN

838: EXCEPTION
839: WHEN error_validate OR error_create_lot OR error_get_item THEN
840: NULL;
841: WHEN OTHERS THEN
842: IF g_debug <= gme_debug.g_log_unexpected THEN
843: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
844: END IF;
845: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 843: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

839: WHEN error_validate OR error_create_lot OR error_get_item THEN
840: NULL;
841: WHEN OTHERS THEN
842: IF g_debug <= gme_debug.g_log_unexpected THEN
843: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
844: END IF;
845: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: END validate_record_for_create;

Line 858: IF g_debug <= gme_debug.g_log_procedure THEN

854: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_update';
855:
856: BEGIN
857:
858: IF g_debug <= gme_debug.g_log_procedure THEN
859: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
860: END IF;
861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:

Line 859: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

855:
856: BEGIN
857:
858: IF g_debug <= gme_debug.g_log_procedure THEN
859: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
860: END IF;
861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:
863: IF g_debug <= gme_debug.g_log_procedure THEN

Line 863: IF g_debug <= gme_debug.g_log_procedure THEN

859: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
860: END IF;
861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:
863: IF g_debug <= gme_debug.g_log_procedure THEN
864: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
865: END IF;
866:
867: EXCEPTION

Line 864: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

860: END IF;
861: x_return_status := FND_API.G_RET_STS_SUCCESS;
862:
863: IF g_debug <= gme_debug.g_log_procedure THEN
864: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
865: END IF;
866:
867: EXCEPTION
868: WHEN OTHERS THEN

Line 869: IF g_debug <= gme_debug.g_log_unexpected THEN

865: END IF;
866:
867: EXCEPTION
868: WHEN OTHERS THEN
869: IF g_debug <= gme_debug.g_log_unexpected THEN
870: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
871: END IF;
872: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 870: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

866:
867: EXCEPTION
868: WHEN OTHERS THEN
869: IF g_debug <= gme_debug.g_log_unexpected THEN
870: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
871: END IF;
872: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: END validate_material_for_update;

Line 902: IF g_debug <= gme_debug.g_log_procedure THEN

898: error_get_item EXCEPTION;
899:
900: BEGIN
901:
902: IF g_debug <= gme_debug.g_log_procedure THEN
903: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
904: END IF;
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:

Line 903: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

899:
900: BEGIN
901:
902: IF g_debug <= gme_debug.g_log_procedure THEN
903: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
904: END IF;
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:
907:

Line 1074: IF g_debug <= gme_debug.g_log_procedure THEN

1070:
1071: x_pending_product_lots_rec.quantity := l_dtl_qty;
1072: x_pending_product_lots_rec.secondary_quantity := l_sec_qty;
1073:
1074: IF g_debug <= gme_debug.g_log_procedure THEN
1075: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1076: END IF;
1077:
1078: EXCEPTION

Line 1075: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

1071: x_pending_product_lots_rec.quantity := l_dtl_qty;
1072: x_pending_product_lots_rec.secondary_quantity := l_sec_qty;
1073:
1074: IF g_debug <= gme_debug.g_log_procedure THEN
1075: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1076: END IF;
1077:
1078: EXCEPTION
1079: WHEN error_validate OR error_get_item THEN

Line 1085: IF g_debug <= gme_debug.g_log_unexpected THEN

1081: WHEN error_fetch_row THEN
1082: -- error message set in fetch routine
1083: x_return_status := fnd_api.g_ret_sts_unexp_error;
1084: WHEN OTHERS THEN
1085: IF g_debug <= gme_debug.g_log_unexpected THEN
1086: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1087: END IF;
1088: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1086: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1082: -- error message set in fetch routine
1083: x_return_status := fnd_api.g_ret_sts_unexp_error;
1084: WHEN OTHERS THEN
1085: IF g_debug <= gme_debug.g_log_unexpected THEN
1086: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1087: END IF;
1088: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090: END validate_record_for_update;

Line 1101: IF g_debug <= gme_debug.g_log_procedure THEN

1097: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_delete';
1098:
1099: BEGIN
1100:
1101: IF g_debug <= gme_debug.g_log_procedure THEN
1102: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1103: END IF;
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:

Line 1102: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

1098:
1099: BEGIN
1100:
1101: IF g_debug <= gme_debug.g_log_procedure THEN
1102: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1103: END IF;
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1106: IF g_debug <= gme_debug.g_log_procedure THEN

1102: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1103: END IF;
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: IF g_debug <= gme_debug.g_log_procedure THEN
1107: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1108: END IF;
1109:
1110: EXCEPTION

Line 1107: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

1103: END IF;
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: IF g_debug <= gme_debug.g_log_procedure THEN
1107: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1108: END IF;
1109:
1110: EXCEPTION
1111: WHEN OTHERS THEN

Line 1112: IF g_debug <= gme_debug.g_log_unexpected THEN

1108: END IF;
1109:
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: IF g_debug <= gme_debug.g_log_unexpected THEN
1113: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1114: END IF;
1115: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1113: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1109:
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: IF g_debug <= gme_debug.g_log_unexpected THEN
1113: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1114: END IF;
1115: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: END validate_material_for_delete;

Line 1134: IF g_debug <= gme_debug.g_log_procedure THEN

1130: error_fetch_row EXCEPTION;
1131:
1132: BEGIN
1133:
1134: IF g_debug <= gme_debug.g_log_procedure THEN
1135: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1136: END IF;
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138:

Line 1135: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);

1131:
1132: BEGIN
1133:
1134: IF g_debug <= gme_debug.g_log_procedure THEN
1135: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1136: END IF;
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138:
1139: IF p_db_pending_product_lots_rec.pending_product_lot_id IS NOT NULL THEN

Line 1153: IF g_debug <= gme_debug.g_log_procedure THEN

1149: RAISE error_fetch_row;
1150: END IF;
1151: END IF;
1152:
1153: IF g_debug <= gme_debug.g_log_procedure THEN
1154: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1155: END IF;
1156:
1157: EXCEPTION

Line 1154: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);

1150: END IF;
1151: END IF;
1152:
1153: IF g_debug <= gme_debug.g_log_procedure THEN
1154: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1155: END IF;
1156:
1157: EXCEPTION
1158: WHEN error_fetch_row THEN

Line 1162: IF g_debug <= gme_debug.g_log_unexpected THEN

1158: WHEN error_fetch_row THEN
1159: -- error message set in fetch routine
1160: x_return_status := fnd_api.g_ret_sts_unexp_error;
1161: WHEN OTHERS THEN
1162: IF g_debug <= gme_debug.g_log_unexpected THEN
1163: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1164: END IF;
1165: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1163: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1159: -- error message set in fetch routine
1160: x_return_status := fnd_api.g_ret_sts_unexp_error;
1161: WHEN OTHERS THEN
1162: IF g_debug <= gme_debug.g_log_unexpected THEN
1163: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1164: END IF;
1165: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: END validate_record_for_delete;

Line 1203: IF g_debug <= gme_debug.g_log_procedure THEN

1199: error_val_qties EXCEPTION;
1200:
1201: BEGIN
1202:
1203: IF g_debug <= gme_debug.g_log_procedure THEN
1204: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1205: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.material_detail_id='||p_matl_dtl_rec.material_detail_id);
1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);
1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);

Line 1204: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);

1200:
1201: BEGIN
1202:
1203: IF g_debug <= gme_debug.g_log_procedure THEN
1204: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1205: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.material_detail_id='||p_matl_dtl_rec.material_detail_id);
1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);
1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);
1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);

Line 1205: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.material_detail_id='||p_matl_dtl_rec.material_detail_id);

1201: BEGIN
1202:
1203: IF g_debug <= gme_debug.g_log_procedure THEN
1204: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1205: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.material_detail_id='||p_matl_dtl_rec.material_detail_id);
1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);
1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);
1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);
1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);

Line 1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);

1202:
1203: IF g_debug <= gme_debug.g_log_procedure THEN
1204: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1205: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.material_detail_id='||p_matl_dtl_rec.material_detail_id);
1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);
1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);
1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);
1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);
1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);

Line 1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);

1203: IF g_debug <= gme_debug.g_log_procedure THEN
1204: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1205: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.material_detail_id='||p_matl_dtl_rec.material_detail_id);
1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);
1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);
1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);
1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);
1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);
1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);

Line 1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);

1204: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1205: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.material_detail_id='||p_matl_dtl_rec.material_detail_id);
1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);
1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);
1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);
1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);
1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);
1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);
1212: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);

Line 1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);

1205: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.material_detail_id='||p_matl_dtl_rec.material_detail_id);
1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);
1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);
1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);
1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);
1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);
1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);
1212: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
1213: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);

Line 1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);

1206: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.inventory_item_id='||p_matl_dtl_rec.inventory_item_id);
1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);
1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);
1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);
1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);
1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);
1212: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
1213: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1214: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);

Line 1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);

1207: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.organization_id='||p_matl_dtl_rec.organization_id);
1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);
1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);
1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);
1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);
1212: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
1213: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1214: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);
1215: END IF;

Line 1212: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);

1208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.subinventory='||p_matl_dtl_rec.subinventory);
1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);
1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);
1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);
1212: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
1213: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1214: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);
1215: END IF;
1216: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1213: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);

1209: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.locator_id='||p_matl_dtl_rec.locator_id);
1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);
1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);
1212: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
1213: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1214: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);
1215: END IF;
1216: x_return_status := FND_API.G_RET_STS_SUCCESS;
1217:

Line 1214: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);

1210: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_matl_dtl_rec.dtl_um='||p_matl_dtl_rec.dtl_um);
1211: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_lot_number='||p_lot_number);
1212: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
1213: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1214: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);
1215: END IF;
1216: x_return_status := FND_API.G_RET_STS_SUCCESS;
1217:
1218: IF p_matl_dtl_rec.line_type = gme_common_pvt.g_line_type_prod THEN

Line 1226: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1222: ELSE
1223: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;
1224: END IF;
1225:
1226: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1227: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_transaction_type_id='||l_transaction_type_id);
1228: END IF;
1229:
1230: OPEN cur_get_uom(p_matl_dtl_rec.inventory_item_id, p_matl_dtl_rec.organization_id);

Line 1227: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_transaction_type_id='||l_transaction_type_id);

1223: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;
1224: END IF;
1225:
1226: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1227: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_transaction_type_id='||l_transaction_type_id);
1228: END IF;
1229:
1230: OPEN cur_get_uom(p_matl_dtl_rec.inventory_item_id, p_matl_dtl_rec.organization_id);
1231: FETCH cur_get_uom INTO l_primary_uom_code, l_secondary_uom_code;

Line 1234: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1230: OPEN cur_get_uom(p_matl_dtl_rec.inventory_item_id, p_matl_dtl_rec.organization_id);
1231: FETCH cur_get_uom INTO l_primary_uom_code, l_secondary_uom_code;
1232: CLOSE cur_get_uom;
1233:
1234: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1235: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_uom_code='||l_primary_uom_code);
1236: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_secondary_uom_code='||l_secondary_uom_code);
1237: END IF;
1238:

Line 1235: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_uom_code='||l_primary_uom_code);

1231: FETCH cur_get_uom INTO l_primary_uom_code, l_secondary_uom_code;
1232: CLOSE cur_get_uom;
1233:
1234: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1235: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_uom_code='||l_primary_uom_code);
1236: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_secondary_uom_code='||l_secondary_uom_code);
1237: END IF;
1238:
1239: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 1236: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_secondary_uom_code='||l_secondary_uom_code);

1232: CLOSE cur_get_uom;
1233:
1234: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1235: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_uom_code='||l_primary_uom_code);
1236: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_secondary_uom_code='||l_secondary_uom_code);
1237: END IF;
1238:
1239: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1240: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_lot_qty='||l_primary_lot_qty);

Line 1239: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1235: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_uom_code='||l_primary_uom_code);
1236: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_secondary_uom_code='||l_secondary_uom_code);
1237: END IF;
1238:
1239: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1240: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_lot_qty='||l_primary_lot_qty);
1241: END IF;
1242:
1243: l_return := INV_LOT_API_PUB.validate_quantities

Line 1240: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_lot_qty='||l_primary_lot_qty);

1236: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_secondary_uom_code='||l_secondary_uom_code);
1237: END IF;
1238:
1239: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1240: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_primary_lot_qty='||l_primary_lot_qty);
1241: END IF;
1242:
1243: l_return := INV_LOT_API_PUB.validate_quantities
1244: (p_api_version => 1.0

Line 1265: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1261: ,x_msg_data => l_msg_data);
1262:
1263: IF NOT l_return OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1264: x_return_status := l_return_status;
1265: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1266: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' error returned from INV_LOT_API_PUB.validate_quantities with return status='||l_return_status);
1267: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_count='||l_msg_count);
1268: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_data='||l_msg_data);
1269: END IF;

Line 1266: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' error returned from INV_LOT_API_PUB.validate_quantities with return status='||l_return_status);

1262:
1263: IF NOT l_return OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1264: x_return_status := l_return_status;
1265: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1266: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' error returned from INV_LOT_API_PUB.validate_quantities with return status='||l_return_status);
1267: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_count='||l_msg_count);
1268: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_data='||l_msg_data);
1269: END IF;
1270: RAISE error_val_qties;

Line 1267: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_count='||l_msg_count);

1263: IF NOT l_return OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1264: x_return_status := l_return_status;
1265: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1266: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' error returned from INV_LOT_API_PUB.validate_quantities with return status='||l_return_status);
1267: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_count='||l_msg_count);
1268: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_data='||l_msg_data);
1269: END IF;
1270: RAISE error_val_qties;
1271: END IF;

Line 1268: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_data='||l_msg_data);

1264: x_return_status := l_return_status;
1265: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1266: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' error returned from INV_LOT_API_PUB.validate_quantities with return status='||l_return_status);
1267: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_count='||l_msg_count);
1268: gme_debug.put_line ( g_pkg_name||'.'||l_api_name||' l_msg_data='||l_msg_data);
1269: END IF;
1270: RAISE error_val_qties;
1271: END IF;
1272:

Line 1286: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1282: ,from_name => NULL
1283: ,to_name => NULL);
1284:
1285: IF p_dtl_qty = -99999 THEN
1286: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1287: gme_debug.put_line
1288: ( g_pkg_name
1289: || '.'
1290: || l_api_name

Line 1287: gme_debug.put_line

1283: ,to_name => NULL);
1284:
1285: IF p_dtl_qty = -99999 THEN
1286: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1287: gme_debug.put_line
1288: ( g_pkg_name
1289: || '.'
1290: || l_api_name
1291: || ' qty conversion failed for material detail'

Line 1298: IF g_debug <= gme_debug.g_log_procedure THEN

1294: RAISE error_um_conv;
1295: END IF;
1296: END IF;
1297:
1298: IF g_debug <= gme_debug.g_log_procedure THEN
1299: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);
1302: END IF;

Line 1299: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);

1295: END IF;
1296: END IF;
1297:
1298: IF g_debug <= gme_debug.g_log_procedure THEN
1299: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);
1302: END IF;
1303:

Line 1300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);

1296: END IF;
1297:
1298: IF g_debug <= gme_debug.g_log_procedure THEN
1299: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);
1302: END IF;
1303:
1304: RETURN l_return;

Line 1301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);

1297:
1298: IF g_debug <= gme_debug.g_log_procedure THEN
1299: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1300: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_dtl_qty='||p_dtl_qty);
1301: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_sec_qty='||p_sec_qty);
1302: END IF;
1303:
1304: RETURN l_return;
1305:

Line 1316: IF g_debug <= gme_debug.g_log_unexpected THEN

1312: fnd_msg_pub.ADD;
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: RETURN FALSE;
1315: WHEN OTHERS THEN
1316: IF g_debug <= gme_debug.g_log_unexpected THEN
1317: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1318: END IF;
1319: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1317: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: RETURN FALSE;
1315: WHEN OTHERS THEN
1316: IF g_debug <= gme_debug.g_log_unexpected THEN
1317: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1318: END IF;
1319: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321: RETURN FALSE;

Line 1346: IF g_debug <= gme_debug.g_log_procedure THEN

1342: l_return BOOLEAN;
1343:
1344: BEGIN
1345:
1346: IF g_debug <= gme_debug.g_log_procedure THEN
1347: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1348: END IF;
1349: x_return_status := FND_API.G_RET_STS_SUCCESS;
1350:

Line 1347: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);

1343:
1344: BEGIN
1345:
1346: IF g_debug <= gme_debug.g_log_procedure THEN
1347: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1348: END IF;
1349: x_return_status := FND_API.G_RET_STS_SUCCESS;
1350:
1351: OPEN check_lot_exists(p_inv_item_id, p_org_id, p_lot_number);

Line 1364: IF g_debug <= gme_debug.g_log_procedure THEN

1360: fnd_msg_pub.ADD;
1361: l_return := FALSE;
1362: END IF;
1363:
1364: IF g_debug <= gme_debug.g_log_procedure THEN
1365: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1366: END IF;
1367:
1368: RETURN l_return;

Line 1365: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);

1361: l_return := FALSE;
1362: END IF;
1363:
1364: IF g_debug <= gme_debug.g_log_procedure THEN
1365: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1366: END IF;
1367:
1368: RETURN l_return;
1369:

Line 1372: IF g_debug <= gme_debug.g_log_unexpected THEN

1368: RETURN l_return;
1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN
1372: IF g_debug <= gme_debug.g_log_unexpected THEN
1373: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1374: END IF;
1375: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1373: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN
1372: IF g_debug <= gme_debug.g_log_unexpected THEN
1373: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1374: END IF;
1375: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: RETURN FALSE;

Line 1401: IF g_debug <= gme_debug.g_log_procedure THEN

1397: error_validation EXCEPTION;
1398:
1399: BEGIN
1400:
1401: IF g_debug <= gme_debug.g_log_procedure THEN
1402: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1403: END IF;
1404: x_return_status := FND_API.G_RET_STS_SUCCESS;
1405:

Line 1402: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);

1398:
1399: BEGIN
1400:
1401: IF g_debug <= gme_debug.g_log_procedure THEN
1402: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1403: END IF;
1404: x_return_status := FND_API.G_RET_STS_SUCCESS;
1405:
1406: IF p_sequence IS NULL THEN

Line 1424: IF g_debug <= gme_debug.g_log_procedure THEN

1420: ELSE
1421: l_return := TRUE;
1422: END IF;
1423:
1424: IF g_debug <= gme_debug.g_log_procedure THEN
1425: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1426: END IF;
1427:
1428: RETURN l_return;

Line 1425: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);

1421: l_return := TRUE;
1422: END IF;
1423:
1424: IF g_debug <= gme_debug.g_log_procedure THEN
1425: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1426: END IF;
1427:
1428: RETURN l_return;
1429:

Line 1434: IF g_debug <= gme_debug.g_log_unexpected THEN

1430: EXCEPTION
1431: WHEN error_validation THEN
1432: return FALSE;
1433: WHEN OTHERS THEN
1434: IF g_debug <= gme_debug.g_log_unexpected THEN
1435: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1436: END IF;
1437: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1435: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1431: WHEN error_validation THEN
1432: return FALSE;
1433: WHEN OTHERS THEN
1434: IF g_debug <= gme_debug.g_log_unexpected THEN
1435: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1436: END IF;
1437: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: RETURN FALSE;

Line 1456: IF g_debug <= gme_debug.g_log_procedure THEN

1452:
1453:
1454: BEGIN
1455:
1456: IF g_debug <= gme_debug.g_log_procedure THEN
1457: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: /* Bug 4866553 Corrected API call */

Line 1457: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);

1453:
1454: BEGIN
1455:
1456: IF g_debug <= gme_debug.g_log_procedure THEN
1457: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1458: END IF;
1459: x_return_status := FND_API.G_RET_STS_SUCCESS;
1460: /* Bug 4866553 Corrected API call */
1461: gme_material_detail_pvt.validate_revision

Line 1473: IF g_debug <= gme_debug.g_log_procedure THEN

1469: ELSE
1470: l_return := TRUE;
1471: END IF;
1472:
1473: IF g_debug <= gme_debug.g_log_procedure THEN
1474: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1475: END IF;
1476:
1477: RETURN l_return;

Line 1474: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);

1470: l_return := TRUE;
1471: END IF;
1472:
1473: IF g_debug <= gme_debug.g_log_procedure THEN
1474: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1475: END IF;
1476:
1477: RETURN l_return;
1478:

Line 1481: IF g_debug <= gme_debug.g_log_unexpected THEN

1477: RETURN l_return;
1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: IF g_debug <= gme_debug.g_log_unexpected THEN
1482: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1483: END IF;
1484: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1482: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: IF g_debug <= gme_debug.g_log_unexpected THEN
1482: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1483: END IF;
1484: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1486: RETURN FALSE;

Line 1504: IF g_debug <= gme_debug.g_log_procedure THEN

1500: WHERE reason_id = v_reason_id
1501: AND NVL (disable_date, SYSDATE + 1) > SYSDATE;
1502:
1503: BEGIN
1504: IF g_debug <= gme_debug.g_log_procedure THEN
1505: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1506: END IF;
1507: x_return_status := FND_API.G_RET_STS_SUCCESS;
1508:

Line 1505: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);

1501: AND NVL (disable_date, SYSDATE + 1) > SYSDATE;
1502:
1503: BEGIN
1504: IF g_debug <= gme_debug.g_log_procedure THEN
1505: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1506: END IF;
1507: x_return_status := FND_API.G_RET_STS_SUCCESS;
1508:
1509: IF p_reason_id IS NULL THEN

Line 1527: IF g_debug <= gme_debug.g_log_procedure THEN

1523: ELSE
1524: l_return := TRUE;
1525: END IF;
1526:
1527: IF g_debug <= gme_debug.g_log_procedure THEN
1528: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1529: END IF;
1530:
1531: RETURN l_return;

Line 1528: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);

1524: l_return := TRUE;
1525: END IF;
1526:
1527: IF g_debug <= gme_debug.g_log_procedure THEN
1528: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1529: END IF;
1530:
1531: RETURN l_return;
1532: EXCEPTION

Line 1534: IF g_debug <= gme_debug.g_log_unexpected THEN

1530:
1531: RETURN l_return;
1532: EXCEPTION
1533: WHEN OTHERS THEN
1534: IF g_debug <= gme_debug.g_log_unexpected THEN
1535: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1536: END IF;
1537: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1535: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1531: RETURN l_return;
1532: EXCEPTION
1533: WHEN OTHERS THEN
1534: IF g_debug <= gme_debug.g_log_unexpected THEN
1535: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1536: END IF;
1537: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1539: RETURN FALSE;

Line 1560: IF g_debug <= gme_debug.g_log_procedure THEN

1556: AND quantity <> 0
1557: AND rownum = 1;
1558:
1559: BEGIN
1560: IF g_debug <= gme_debug.g_log_procedure THEN
1561: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1562: END IF;
1563:
1564: OPEN cur_pp_lot_exist (p_batch_id, p_material_detail_id);

Line 1561: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);

1557: AND rownum = 1;
1558:
1559: BEGIN
1560: IF g_debug <= gme_debug.g_log_procedure THEN
1561: gme_debug.put_line('Entering function '||g_pkg_name||'.'||l_api_name);
1562: END IF;
1563:
1564: OPEN cur_pp_lot_exist (p_batch_id, p_material_detail_id);
1565: FETCH cur_pp_lot_exist INTO l_is_pplot;

Line 1574: IF g_debug <= gme_debug.g_log_procedure THEN

1570: ELSE
1571: l_return := FALSE;
1572: END IF;
1573:
1574: IF g_debug <= gme_debug.g_log_procedure THEN
1575: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1576: END IF;
1577:
1578: RETURN l_return;

Line 1575: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);

1571: l_return := FALSE;
1572: END IF;
1573:
1574: IF g_debug <= gme_debug.g_log_procedure THEN
1575: gme_debug.put_line('Exiting function '||g_pkg_name||'.'||l_api_name);
1576: END IF;
1577:
1578: RETURN l_return;
1579: EXCEPTION

Line 1581: IF g_debug <= gme_debug.g_log_unexpected THEN

1577:
1578: RETURN l_return;
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: IF g_debug <= gme_debug.g_log_unexpected THEN
1582: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1583: END IF;
1584: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1585: RETURN FALSE;

Line 1582: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1578: RETURN l_return;
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: IF g_debug <= gme_debug.g_log_unexpected THEN
1582: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1583: END IF;
1584: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1585: RETURN FALSE;
1586: END pending_product_lot_exist;

Line 1599: IF g_debug <= gme_debug.g_log_procedure THEN

1595: l_pnd_prod_lot_tbl gme_common_pvt.pending_lots_tab;
1596: get_pending_lot_error EXCEPTION;
1597:
1598: BEGIN
1599: IF g_debug <= gme_debug.g_log_procedure THEN
1600: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1601: || l_api_name);
1602: END IF;
1603:

Line 1600: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

1596: get_pending_lot_error EXCEPTION;
1597:
1598: BEGIN
1599: IF g_debug <= gme_debug.g_log_procedure THEN
1600: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1601: || l_api_name);
1602: END IF;
1603:
1604: x_return_status := fnd_api.g_ret_sts_success;

Line 1619: IF g_debug <= gme_debug.g_log_procedure THEN

1615: FOR i IN 1 .. l_pnd_prod_lot_tbl.COUNT LOOP
1616: x_pnd_prod_lot_qty := x_pnd_prod_lot_qty + l_pnd_prod_lot_tbl(i).quantity;
1617: END LOOP;
1618:
1619: IF g_debug <= gme_debug.g_log_procedure THEN
1620: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1621: END IF;
1622: EXCEPTION
1623: WHEN get_pending_lot_error THEN

Line 1620: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

1616: x_pnd_prod_lot_qty := x_pnd_prod_lot_qty + l_pnd_prod_lot_tbl(i).quantity;
1617: END LOOP;
1618:
1619: IF g_debug <= gme_debug.g_log_procedure THEN
1620: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1621: END IF;
1622: EXCEPTION
1623: WHEN get_pending_lot_error THEN
1624: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1626: IF g_debug <= gme_debug.g_log_unexpected THEN

1622: EXCEPTION
1623: WHEN get_pending_lot_error THEN
1624: x_return_status := fnd_api.g_ret_sts_unexp_error;
1625: WHEN OTHERS THEN
1626: IF g_debug <= gme_debug.g_log_unexpected THEN
1627: gme_debug.put_line ( 'When others exception in '
1628: || g_pkg_name
1629: || '.'
1630: || l_api_name

Line 1627: gme_debug.put_line ( 'When others exception in '

1623: WHEN get_pending_lot_error THEN
1624: x_return_status := fnd_api.g_ret_sts_unexp_error;
1625: WHEN OTHERS THEN
1626: IF g_debug <= gme_debug.g_log_unexpected THEN
1627: gme_debug.put_line ( 'When others exception in '
1628: || g_pkg_name
1629: || '.'
1630: || l_api_name
1631: || ' Error is '