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_API_GRP dependencies on GME_DEBUG

Line 16: IF (g_debug <= gme_debug.g_log_statement) THEN

12: BEGIN
13: -- Initially let us assign the return status to success
14: x_return_status := fnd_api.g_ret_sts_success;
15:
16: IF (g_debug <= gme_debug.g_log_statement) THEN
17: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
18: || 'Entering');
19: gme_debug.put_line ( g_pkg_name
20: || '.'

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

13: -- Initially let us assign the return status to success
14: x_return_status := fnd_api.g_ret_sts_success;
15:
16: IF (g_debug <= gme_debug.g_log_statement) THEN
17: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
18: || 'Entering');
19: gme_debug.put_line ( g_pkg_name
20: || '.'
21: || l_api_name

Line 19: gme_debug.put_line ( g_pkg_name

15:
16: IF (g_debug <= gme_debug.g_log_statement) THEN
17: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
18: || 'Entering');
19: gme_debug.put_line ( g_pkg_name
20: || '.'
21: || l_api_name
22: || ':'
23: || 'header_id is :'

Line 37: IF (g_debug <= gme_debug.g_log_statement) THEN

33: RAISE fnd_api.g_exc_error;
34: END IF;
35: END IF;
36: x_return_status := l_return_status;
37: IF (g_debug <= gme_debug.g_log_statement) THEN
38: gme_debug.put_line ( g_pkg_name
39: || '.'
40: || l_api_name
41: || ':'

Line 38: gme_debug.put_line ( g_pkg_name

34: END IF;
35: END IF;
36: x_return_status := l_return_status;
37: IF (g_debug <= gme_debug.g_log_statement) THEN
38: gme_debug.put_line ( g_pkg_name
39: || '.'
40: || l_api_name
41: || ':'
42: || 'Exiting with '

Line 54: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

50: x_return_status := fnd_api.g_ret_sts_unexp_error;
51: WHEN OTHERS THEN
52: x_return_status := fnd_api.g_ret_sts_unexp_error;
53:
54: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
55: gme_debug.put_line ( g_pkg_name
56: || '.'
57: || l_api_name
58: || ':'

Line 55: gme_debug.put_line ( g_pkg_name

51: WHEN OTHERS THEN
52: x_return_status := fnd_api.g_ret_sts_unexp_error;
53:
54: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
55: gme_debug.put_line ( g_pkg_name
56: || '.'
57: || l_api_name
58: || ':'
59: || 'WHEN OTHERS:'

Line 84: IF (g_debug <= gme_debug.g_log_statement) THEN

80: l_txn_rec get_txns%ROWTYPE;
81: BEGIN
82: x_return_status := fnd_api.g_ret_sts_success;
83:
84: IF (g_debug <= gme_debug.g_log_statement) THEN
85: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
86: || 'Entering');
87: gme_debug.put_line ( g_pkg_name
88: || '.'

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

81: BEGIN
82: x_return_status := fnd_api.g_ret_sts_success;
83:
84: IF (g_debug <= gme_debug.g_log_statement) THEN
85: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
86: || 'Entering');
87: gme_debug.put_line ( g_pkg_name
88: || '.'
89: || l_api_name

Line 87: gme_debug.put_line ( g_pkg_name

83:
84: IF (g_debug <= gme_debug.g_log_statement) THEN
85: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
86: || 'Entering');
87: gme_debug.put_line ( g_pkg_name
88: || '.'
89: || l_api_name
90: || ':'
91: || 'transaction_id'

Line 110: IF (g_debug <= gme_debug.g_log_statement) THEN

106: RAISE fnd_api.g_exc_error;
107: END IF;
108:
109: x_return_status := l_return_status;
110: IF (g_debug <= gme_debug.g_log_statement) THEN
111: gme_debug.put_line ( g_pkg_name
112: || '.'
113: || l_api_name
114: || ':'

Line 111: gme_debug.put_line ( g_pkg_name

107: END IF;
108:
109: x_return_status := l_return_status;
110: IF (g_debug <= gme_debug.g_log_statement) THEN
111: gme_debug.put_line ( g_pkg_name
112: || '.'
113: || l_api_name
114: || ':'
115: || 'Exiting with '

Line 126: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

122: x_return_status := fnd_api.g_ret_sts_unexp_error;
123: WHEN OTHERS THEN
124: x_return_status := fnd_api.g_ret_sts_unexp_error;
125:
126: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
127: gme_debug.put_line ( g_pkg_name
128: || '.'
129: || l_api_name
130: || ':'

Line 127: gme_debug.put_line ( g_pkg_name

123: WHEN OTHERS THEN
124: x_return_status := fnd_api.g_ret_sts_unexp_error;
125:
126: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
127: gme_debug.put_line ( g_pkg_name
128: || '.'
129: || l_api_name
130: || ':'
131: || 'WHEN OTHERS:'

Line 193: IF g_debug <= gme_debug.g_log_procedure THEN

189: supply_demand_error EXCEPTION;
190:
191: BEGIN
192:
193: IF g_debug <= gme_debug.g_log_procedure THEN
194: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
195: END IF;
196:
197: /* Set the return status to success initially */

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

190:
191: BEGIN
192:
193: IF g_debug <= gme_debug.g_log_procedure THEN
194: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
195: END IF;
196:
197: /* Set the return status to success initially */
198: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 214: IF g_debug <= gme_debug.g_log_statement THEN

210: RAISE invalid_version;
211: END IF;
212:
213: /* Ensure mandatory inputs supplied */
214: IF g_debug <= gme_debug.g_log_statement THEN
215: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');
216: END IF;
217: IF p_organization_id IS NULL THEN
218: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'ORGANIZATION_ID');

Line 215: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');

211: END IF;
212:
213: /* Ensure mandatory inputs supplied */
214: IF g_debug <= gme_debug.g_log_statement THEN
215: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');
216: END IF;
217: IF p_organization_id IS NULL THEN
218: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'ORGANIZATION_ID');
219: RAISE input_param_missing;

Line 240: IF g_debug <= gme_debug.g_log_statement THEN

236:
237: /* Retrieve batch header row */
238: l_batch_header_rec.batch_id := p_supply_demand_header_id;
239: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
240: IF g_debug <= gme_debug.g_log_statement THEN
241: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
242: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
243: END IF;
244: RAISE fetch_failure;

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

237: /* Retrieve batch header row */
238: l_batch_header_rec.batch_id := p_supply_demand_header_id;
239: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
240: IF g_debug <= gme_debug.g_log_statement THEN
241: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
242: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
243: END IF;
244: RAISE fetch_failure;
245: END IF;

Line 246: IF g_debug <= gme_debug.g_log_statement THEN

242: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
243: END IF;
244: RAISE fetch_failure;
245: END IF;
246: IF g_debug <= gme_debug.g_log_statement THEN
247: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch Status '||l_batch_header_rec.batch_status);
248: END IF;
249:
250: /* Verify that update_inventory is allowed for the Batch */

Line 247: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch Status '||l_batch_header_rec.batch_status);

243: END IF;
244: RAISE fetch_failure;
245: END IF;
246: IF g_debug <= gme_debug.g_log_statement THEN
247: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch Status '||l_batch_header_rec.batch_status);
248: END IF;
249:
250: /* Verify that update_inventory is allowed for the Batch */
251: IF l_batch_header_rec.update_inventory_ind <> 'Y' THEN

Line 279: IF g_debug <= gme_debug.g_log_statement THEN

275:
276: /* Retrieve material details record */
277: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
278: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
279: IF g_debug <= gme_debug.g_log_statement THEN
280: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
281: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
282: END IF;
283: RAISE fetch_failure;

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

276: /* Retrieve material details record */
277: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
278: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
279: IF g_debug <= gme_debug.g_log_statement THEN
280: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
281: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
282: END IF;
283: RAISE fetch_failure;
284: END IF;

Line 310: IF g_debug <= gme_debug.g_log_statement THEN

306: gme_common_pvt.log_message('GME_INVALID_RSV_FOR_BYPROD');
307: RAISE validation_error;
308: END IF;
309:
310: IF g_debug <= gme_debug.g_log_statement THEN
311: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Material Release Type '||l_material_details_rec.release_type);
312: END IF;
313: /* Verify p_supply_demand_code and line_type. */
314: IF p_supply_demand_code = 2 /* Demand */ AND

Line 311: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Material Release Type '||l_material_details_rec.release_type);

307: RAISE validation_error;
308: END IF;
309:
310: IF g_debug <= gme_debug.g_log_statement THEN
311: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Material Release Type '||l_material_details_rec.release_type);
312: END IF;
313: /* Verify p_supply_demand_code and line_type. */
314: IF p_supply_demand_code = 2 /* Demand */ AND
315: l_material_details_rec.line_type <> gme_common_pvt.g_line_type_ing THEN

Line 336: IF g_debug <= gme_debug.g_log_statement THEN

332: --Bug#4604943 following code is commented out
333: /* BUG 4604943 BEGIN - check for auto AND autobystep here
334: IF l_mat_status in ( gme_common_pvt.g_mtl_auto_release ,gme_common_pvt.g_mtl_autobystep_release) AND
335: l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
336: IF g_debug <= gme_debug.g_log_statement THEN
337: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');
338: END IF;
339: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
340: RAISE supply_demand_error;

Line 337: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');

333: /* BUG 4604943 BEGIN - check for auto AND autobystep here
334: IF l_mat_status in ( gme_common_pvt.g_mtl_auto_release ,gme_common_pvt.g_mtl_autobystep_release) AND
335: l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
336: IF g_debug <= gme_debug.g_log_statement THEN
337: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');
338: END IF;
339: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
340: RAISE supply_demand_error;
341: BUG 4604943 END

Line 346: IF g_debug <= gme_debug.g_log_statement THEN

342: ELS */
343: IF l_mat_status = gme_common_pvt.g_mtl_auto_release AND
344: l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
345: IF p_called_by <> 'CVT' THEN
346: IF g_debug <= gme_debug.g_log_statement THEN
347: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');
348: END IF;
349: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
350: RAISE supply_demand_error;

Line 347: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');

343: IF l_mat_status = gme_common_pvt.g_mtl_auto_release AND
344: l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
345: IF p_called_by <> 'CVT' THEN
346: IF g_debug <= gme_debug.g_log_statement THEN
347: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');
348: END IF;
349: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
350: RAISE supply_demand_error;
351: END IF;

Line 354: IF g_debug <= gme_debug.g_log_statement THEN

350: RAISE supply_demand_error;
351: END IF;
352: ELSIF l_mat_status = gme_common_pvt.g_mtl_autobystep_release THEN
353: IF NOT gme_common_pvt.get_assoc_step(l_material_details_rec.material_detail_id,l_step_id,l_step_status) THEN
354: IF g_debug <= gme_debug.g_log_statement THEN
355: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Error in get_assoc_step');
356: END IF;
357: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
358: RAISE supply_demand_error;

Line 355: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Error in get_assoc_step');

351: END IF;
352: ELSIF l_mat_status = gme_common_pvt.g_mtl_autobystep_release THEN
353: IF NOT gme_common_pvt.get_assoc_step(l_material_details_rec.material_detail_id,l_step_id,l_step_status) THEN
354: IF g_debug <= gme_debug.g_log_statement THEN
355: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Error in get_assoc_step');
356: END IF;
357: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
358: RAISE supply_demand_error;
359: ELSIF l_step_id IS NOT NULL THEN

Line 364: IF g_debug <= gme_debug.g_log_statement THEN

360: /* for conversions of reservations, the step status should not be pending and
361: for creating the reservations, the step status should be greater than pending */
362: IF (p_called_by = 'CVT' and NVL(l_step_status,-1) <> gme_common_pvt.g_step_wip)
363: OR (p_called_by <> 'CVT' and NVL(l_step_status,-1) >= gme_common_pvt.g_step_wip) THEN
364: IF g_debug <= gme_debug.g_log_statement THEN
365: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic By Step Material in step: '||l_step_id||
366: ' with status of '||l_step_status||' not a valid demand');
367: END IF;
368: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');

Line 365: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic By Step Material in step: '||l_step_id||

361: for creating the reservations, the step status should be greater than pending */
362: IF (p_called_by = 'CVT' and NVL(l_step_status,-1) <> gme_common_pvt.g_step_wip)
363: OR (p_called_by <> 'CVT' and NVL(l_step_status,-1) >= gme_common_pvt.g_step_wip) THEN
364: IF g_debug <= gme_debug.g_log_statement THEN
365: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic By Step Material in step: '||l_step_id||
366: ' with status of '||l_step_status||' not a valid demand');
367: END IF;
368: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
369: RAISE supply_demand_error;

Line 375: IF g_debug <= gme_debug.g_log_procedure THEN

371: END IF; -- IF l_step_id IS NOT NULL AND NVL(l_step_status,-1) = gme_common_pvt.g_step_wip THEN
372: END IF; -- IF l_mat_status = gme_common_pvt.g_mtl_auto_release AND
373: END IF;
374:
375: IF g_debug <= gme_debug.g_log_procedure THEN
376: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
377: END IF;
378: EXCEPTION
379: /* Exception handling */

Line 376: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));

372: END IF; -- IF l_mat_status = gme_common_pvt.g_mtl_auto_release AND
373: END IF;
374:
375: IF g_debug <= gme_debug.g_log_procedure THEN
376: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
377: END IF;
378: EXCEPTION
379: /* Exception handling */
380: WHEN invalid_version OR input_param_missing OR validation_error

Line 388: IF g_debug <= gme_debug.g_log_unexpected THEN

384: gme_common_pvt.count_and_get(x_count => x_msg_count,
385: p_encoded => FND_API.g_false,
386: x_data => x_msg_data);
387: WHEN OTHERS THEN
388: IF g_debug <= gme_debug.g_log_unexpected THEN
389: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);
390: END IF;
391: x_return_status := FND_API.g_ret_sts_unexp_error;
392: x_valid_status := 'N';

Line 389: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);

385: p_encoded => FND_API.g_false,
386: x_data => x_msg_data);
387: WHEN OTHERS THEN
388: IF g_debug <= gme_debug.g_log_unexpected THEN
389: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);
390: END IF;
391: x_return_status := FND_API.g_ret_sts_unexp_error;
392: x_valid_status := 'N';
393: gme_common_pvt.count_and_get(x_count => x_msg_count,

Line 451: IF g_debug <= gme_debug.g_log_procedure THEN

447: fetch_failure EXCEPTION;
448:
449: BEGIN
450:
451: IF g_debug <= gme_debug.g_log_procedure THEN
452: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
453: END IF;
454:
455: /* Set the return status to success initially */

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

448:
449: BEGIN
450:
451: IF g_debug <= gme_debug.g_log_procedure THEN
452: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
453: END IF;
454:
455: /* Set the return status to success initially */
456: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 468: IF g_debug <= gme_debug.g_log_statement THEN

464: RAISE invalid_version;
465: END IF;
466:
467: /* Ensure mandatory inputs supplied */
468: IF g_debug <= gme_debug.g_log_statement THEN
469: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');
470: END IF;
471: IF p_supply_demand_code IS NULL THEN
472: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'SUPPLY_DEMAND_CODE');

Line 469: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');

465: END IF;
466:
467: /* Ensure mandatory inputs supplied */
468: IF g_debug <= gme_debug.g_log_statement THEN
469: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');
470: END IF;
471: IF p_supply_demand_code IS NULL THEN
472: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'SUPPLY_DEMAND_CODE');
473: RAISE input_param_missing;

Line 488: IF g_debug <= gme_debug.g_log_statement THEN

484:
485: /* Retrieve batch header */
486: l_batch_header_rec.batch_id := p_supply_demand_header_id;
487: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
488: IF g_debug <= gme_debug.g_log_statement THEN
489: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
490: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
491: END IF;
492: RAISE fetch_failure;

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

485: /* Retrieve batch header */
486: l_batch_header_rec.batch_id := p_supply_demand_header_id;
487: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
488: IF g_debug <= gme_debug.g_log_statement THEN
489: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
490: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
491: END IF;
492: RAISE fetch_failure;
493: END IF;

Line 498: IF g_debug <= gme_debug.g_log_statement THEN

494:
495: /* For Batch in Completed status , return 0*/
496: IF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_completed THEN
497: x_available_quantity := 0;
498: IF g_debug <= gme_debug.g_log_statement THEN
499: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
500: 'Batch status is completed so return available of 0 ');
501: END IF;
502: RETURN;

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

495: /* For Batch in Completed status , return 0*/
496: IF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_completed THEN
497: x_available_quantity := 0;
498: IF g_debug <= gme_debug.g_log_statement THEN
499: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
500: 'Batch status is completed so return available of 0 ');
501: END IF;
502: RETURN;
503: END IF;

Line 508: IF g_debug <= gme_debug.g_log_statement THEN

504:
505: /* Retrieve material details record */
506: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
507: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
508: IF g_debug <= gme_debug.g_log_statement THEN
509: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
510: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
511: END IF;
512: RAISE fetch_failure;

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

505: /* Retrieve material details record */
506: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
507: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
508: IF g_debug <= gme_debug.g_log_statement THEN
509: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
510: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
511: END IF;
512: RAISE fetch_failure;
513: END IF;

Line 547: IF g_debug <= gme_debug.g_log_statement THEN

543: /* Now retrieve the primary UOM code for the item */
544: OPEN cur_item (l_material_details_rec.organization_id,l_material_details_rec.inventory_item_id);
545: FETCH cur_item INTO l_primary_uom_code;
546: CLOSE cur_item;
547: IF g_debug <= gme_debug.g_log_statement THEN
548: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' primary uom code '||l_primary_uom_code);
549: END IF;
550:
551: /* Return the uom code and primary uom code */

Line 548: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' primary uom code '||l_primary_uom_code);

544: OPEN cur_item (l_material_details_rec.organization_id,l_material_details_rec.inventory_item_id);
545: FETCH cur_item INTO l_primary_uom_code;
546: CLOSE cur_item;
547: IF g_debug <= gme_debug.g_log_statement THEN
548: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' primary uom code '||l_primary_uom_code);
549: END IF;
550:
551: /* Return the uom code and primary uom code */
552: x_source_uom_code := l_material_details_rec.dtl_um;

Line 557: IF (g_debug <= gme_debug.g_log_unexpected) THEN

553: x_source_primary_uom_code := l_primary_uom_code;
554:
555: /* Return the available supply demand quantity.*/
556: /* The value will be same for p_supply_demand_code as Demand or Supply */
557: IF (g_debug <= gme_debug.g_log_unexpected) THEN
558: gme_debug.put_line ( g_pkg_name
559: || '.'
560: || l_api_name
561: || ':'

Line 558: gme_debug.put_line ( g_pkg_name

554:
555: /* Return the available supply demand quantity.*/
556: /* The value will be same for p_supply_demand_code as Demand or Supply */
557: IF (g_debug <= gme_debug.g_log_unexpected) THEN
558: gme_debug.put_line ( g_pkg_name
559: || '.'
560: || l_api_name
561: || ':'
562: || 'Compute available qty from these figues:'

Line 577: IF g_debug <= gme_debug.g_log_procedure THEN

573: l_available_quantity := NVL(l_material_details_rec.wip_plan_qty, l_material_details_rec.plan_qty) - l_material_details_rec.actual_qty;
574: -- To conform to INV standards, round to 5 decimal places
575: x_available_quantity := ROUND(l_available_quantity,5);
576: END IF;
577: IF g_debug <= gme_debug.g_log_procedure THEN
578: gme_debug.put_line ('Available quantity computes as '|| x_available_quantity);
579: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
580: END IF;
581: RETURN;

Line 578: gme_debug.put_line ('Available quantity computes as '|| x_available_quantity);

574: -- To conform to INV standards, round to 5 decimal places
575: x_available_quantity := ROUND(l_available_quantity,5);
576: END IF;
577: IF g_debug <= gme_debug.g_log_procedure THEN
578: gme_debug.put_line ('Available quantity computes as '|| x_available_quantity);
579: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
580: END IF;
581: RETURN;
582: EXCEPTION

Line 579: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));

575: x_available_quantity := ROUND(l_available_quantity,5);
576: END IF;
577: IF g_debug <= gme_debug.g_log_procedure THEN
578: gme_debug.put_line ('Available quantity computes as '|| x_available_quantity);
579: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
580: END IF;
581: RETURN;
582: EXCEPTION
583: /* Exception handling */

Line 590: IF g_debug <= gme_debug.g_log_unexpected THEN

586: gme_common_pvt.count_and_get(x_count => x_msg_count,
587: p_encoded => FND_API.g_false,
588: x_data => x_msg_data);
589: WHEN OTHERS THEN
590: IF g_debug <= gme_debug.g_log_unexpected THEN
591: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);
592: END IF;
593: x_return_status := FND_API.g_ret_sts_unexp_error;
594: gme_common_pvt.count_and_get(x_count => x_msg_count,

Line 591: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);

587: p_encoded => FND_API.g_false,
588: x_data => x_msg_data);
589: WHEN OTHERS THEN
590: IF g_debug <= gme_debug.g_log_unexpected THEN
591: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);
592: END IF;
593: x_return_status := FND_API.g_ret_sts_unexp_error;
594: gme_common_pvt.count_and_get(x_count => x_msg_count,
595: p_encoded => FND_API.g_false,

Line 674: IF (g_debug <= gme_debug.g_log_statement) THEN

670: BEGIN
671: -- Initially let us assign the return status to success
672: x_return_status := fnd_api.g_ret_sts_success;
673:
674: IF (g_debug <= gme_debug.g_log_statement) THEN
675: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
676: || 'Entering');
677: gme_debug.put_line ( g_pkg_name
678: || '.'

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

671: -- Initially let us assign the return status to success
672: x_return_status := fnd_api.g_ret_sts_success;
673:
674: IF (g_debug <= gme_debug.g_log_statement) THEN
675: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
676: || 'Entering');
677: gme_debug.put_line ( g_pkg_name
678: || '.'
679: || l_api_name

Line 677: gme_debug.put_line ( g_pkg_name

673:
674: IF (g_debug <= gme_debug.g_log_statement) THEN
675: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
676: || 'Entering');
677: gme_debug.put_line ( g_pkg_name
678: || '.'
679: || l_api_name
680: || ':'
681: || 'batch_id is :'

Line 699: IF (g_debug <= gme_debug.g_log_statement) THEN

695: RAISE fnd_api.g_exc_error;
696: END IF;
697: END IF;
698:
699: IF (g_debug <= gme_debug.g_log_statement) THEN
700: gme_debug.put_line ( g_pkg_name
701: || '.'
702: || l_api_name
703: || ':'

Line 700: gme_debug.put_line ( g_pkg_name

696: END IF;
697: END IF;
698:
699: IF (g_debug <= gme_debug.g_log_statement) THEN
700: gme_debug.put_line ( g_pkg_name
701: || '.'
702: || l_api_name
703: || ':'
704: || 'Exiting with '

Line 716: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

712:
713: WHEN OTHERS THEN
714: x_return_status := fnd_api.g_ret_sts_unexp_error;
715:
716: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
717: gme_debug.put_line ( g_pkg_name
718: || '.'
719: || l_api_name
720: || ':'

Line 717: gme_debug.put_line ( g_pkg_name

713: WHEN OTHERS THEN
714: x_return_status := fnd_api.g_ret_sts_unexp_error;
715:
716: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
717: gme_debug.put_line ( g_pkg_name
718: || '.'
719: || l_api_name
720: || ':'
721: || 'WHEN OTHERS:'

Line 746: IF (g_debug <= gme_debug.g_log_statement) THEN

742: BEGIN
743: -- Initially let us assign the return status to success
744: x_return_status := fnd_api.g_ret_sts_success;
745:
746: IF (g_debug <= gme_debug.g_log_statement) THEN
747: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
748: || 'Entering');
749: gme_debug.put_line ( g_pkg_name
750: || '.'

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

743: -- Initially let us assign the return status to success
744: x_return_status := fnd_api.g_ret_sts_success;
745:
746: IF (g_debug <= gme_debug.g_log_statement) THEN
747: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
748: || 'Entering');
749: gme_debug.put_line ( g_pkg_name
750: || '.'
751: || l_api_name

Line 749: gme_debug.put_line ( g_pkg_name

745:
746: IF (g_debug <= gme_debug.g_log_statement) THEN
747: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
748: || 'Entering');
749: gme_debug.put_line ( g_pkg_name
750: || '.'
751: || l_api_name
752: || ':'
753: || 'batch_id is :'

Line 770: IF (g_debug <= gme_debug.g_log_statement) THEN

766: RAISE fnd_api.g_exc_error;
767: END IF;
768: END IF;
769:
770: IF (g_debug <= gme_debug.g_log_statement) THEN
771: gme_debug.put_line ( g_pkg_name
772: || '.'
773: || l_api_name
774: || ':'

Line 771: gme_debug.put_line ( g_pkg_name

767: END IF;
768: END IF;
769:
770: IF (g_debug <= gme_debug.g_log_statement) THEN
771: gme_debug.put_line ( g_pkg_name
772: || '.'
773: || l_api_name
774: || ':'
775: || 'Exiting with '

Line 787: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

783:
784: WHEN OTHERS THEN
785: x_return_status := fnd_api.g_ret_sts_unexp_error;
786:
787: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
788: gme_debug.put_line ( g_pkg_name
789: || '.'
790: || l_api_name
791: || ':'

Line 788: gme_debug.put_line ( g_pkg_name

784: WHEN OTHERS THEN
785: x_return_status := fnd_api.g_ret_sts_unexp_error;
786:
787: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
788: gme_debug.put_line ( g_pkg_name
789: || '.'
790: || l_api_name
791: || ':'
792: || 'WHEN OTHERS:'

Line 824: IF g_debug <= gme_debug.g_log_procedure THEN

820: ) IS
821:
822: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LCF_BATCH';
823: BEGIN
824: IF g_debug <= gme_debug.g_log_procedure THEN
825: gme_debug.log_initialize('CreateLCFBatch');
826: END IF;
827:
828: IF g_debug <= gme_debug.g_log_procedure THEN

Line 825: gme_debug.log_initialize('CreateLCFBatch');

821:
822: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LCF_BATCH';
823: BEGIN
824: IF g_debug <= gme_debug.g_log_procedure THEN
825: gme_debug.log_initialize('CreateLCFBatch');
826: END IF;
827:
828: IF g_debug <= gme_debug.g_log_procedure THEN
829: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 828: IF g_debug <= gme_debug.g_log_procedure THEN

824: IF g_debug <= gme_debug.g_log_procedure THEN
825: gme_debug.log_initialize('CreateLCFBatch');
826: END IF;
827:
828: IF g_debug <= gme_debug.g_log_procedure THEN
829: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
830: || l_api_name);
831: END IF;
832: IF p_init_msg_list = fnd_api.g_true THEN

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

825: gme_debug.log_initialize('CreateLCFBatch');
826: END IF;
827:
828: IF g_debug <= gme_debug.g_log_procedure THEN
829: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
830: || l_api_name);
831: END IF;
832: IF p_init_msg_list = fnd_api.g_true THEN
833: fnd_msg_pub.initialize;

Line 846: IF g_debug <= gme_debug.g_log_procedure THEN

842: gme_common_pvt.log_message ('GME_INVALID_API_VERSION');
843: RAISE fnd_api.g_exc_error;
844: END IF;
845: /* Setup the common constants used accross the apis */
846: IF g_debug <= gme_debug.g_log_procedure THEN
847: gme_debug.put_line ('Calling gme_common_pvt.setup.');
848: END IF;
849:
850: gme_common_pvt.g_setup_done :=

Line 847: gme_debug.put_line ('Calling gme_common_pvt.setup.');

843: RAISE fnd_api.g_exc_error;
844: END IF;
845: /* Setup the common constants used accross the apis */
846: IF g_debug <= gme_debug.g_log_procedure THEN
847: gme_debug.put_line ('Calling gme_common_pvt.setup.');
848: END IF;
849:
850: gme_common_pvt.g_setup_done :=
851: gme_common_pvt.setup (p_org_id => p_batch_header_rec.organization_id

Line 854: IF g_debug <= gme_debug.g_log_procedure THEN

850: gme_common_pvt.g_setup_done :=
851: gme_common_pvt.setup (p_org_id => p_batch_header_rec.organization_id
852: ,p_org_code => NULL);
853:
854: IF g_debug <= gme_debug.g_log_procedure THEN
855: gme_debug.put_line ('After calling gme_common_pvt.setup.');
856: END IF;
857:
858: IF NOT gme_common_pvt.g_setup_done THEN

Line 855: gme_debug.put_line ('After calling gme_common_pvt.setup.');

851: gme_common_pvt.setup (p_org_id => p_batch_header_rec.organization_id
852: ,p_org_code => NULL);
853:
854: IF g_debug <= gme_debug.g_log_procedure THEN
855: gme_debug.put_line ('After calling gme_common_pvt.setup.');
856: END IF;
857:
858: IF NOT gme_common_pvt.g_setup_done THEN
859: x_return_status := fnd_api.g_ret_sts_error;

Line 885: IF g_debug <= gme_debug.g_log_procedure THEN

881: ,p_is_phantom => 'N'
882: ,x_exception_material_tbl => x_exception_material_tbl
883: );
884: IF x_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_inv_short_err,'C') THEN
885: IF g_debug <= gme_debug.g_log_procedure THEN
886: gme_debug.put_line ('Error in Create Batch: return status'||x_return_status);
887: END IF;
888: RAISE fnd_api.g_exc_error;
889: END IF;

Line 886: gme_debug.put_line ('Error in Create Batch: return status'||x_return_status);

882: ,x_exception_material_tbl => x_exception_material_tbl
883: );
884: IF x_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_inv_short_err,'C') THEN
885: IF g_debug <= gme_debug.g_log_procedure THEN
886: gme_debug.put_line ('Error in Create Batch: return status'||x_return_status);
887: END IF;
888: RAISE fnd_api.g_exc_error;
889: END IF;
890: IF g_debug <= gme_debug.g_log_procedure THEN

Line 890: IF g_debug <= gme_debug.g_log_procedure THEN

886: gme_debug.put_line ('Error in Create Batch: return status'||x_return_status);
887: END IF;
888: RAISE fnd_api.g_exc_error;
889: END IF;
890: IF g_debug <= gme_debug.g_log_procedure THEN
891: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
892: END IF;
893:
894:

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

887: END IF;
888: RAISE fnd_api.g_exc_error;
889: END IF;
890: IF g_debug <= gme_debug.g_log_procedure THEN
891: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
892: END IF;
893:
894:
895: EXCEPTION

Line 911: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

907: ,x_data => x_message_list);
908: WHEN OTHERS THEN
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910: x_batch_header_rec := null;
911: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
912: gme_debug.put_line ( g_pkg_name
913: || '.'
914: || l_api_name
915: || ':'

Line 912: gme_debug.put_line ( g_pkg_name

908: WHEN OTHERS THEN
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910: x_batch_header_rec := null;
911: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
912: gme_debug.put_line ( g_pkg_name
913: || '.'
914: || l_api_name
915: || ':'
916: || 'WHEN OTHERS:'

Line 939: IF g_debug <= gme_debug.g_log_procedure THEN

935: l_open_qty NUMBER := 0;
936: l_return_status VARCHAR2 (1);
937: l_mtl_dtl_rec gme_material_details%ROWTYPE;
938: BEGIN
939: IF g_debug <= gme_debug.g_log_procedure THEN
940: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
941: || l_api_name);
942: END IF;
943:

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

936: l_return_status VARCHAR2 (1);
937: l_mtl_dtl_rec gme_material_details%ROWTYPE;
938: BEGIN
939: IF g_debug <= gme_debug.g_log_procedure THEN
940: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
941: || l_api_name);
942: END IF;
943:
944: l_mtl_dtl_rec.organization_id := p_organization_id;

Line 965: IF g_debug <= gme_debug.g_log_unexpected THEN

961: EXCEPTION
962: WHEN OTHERS THEN
963: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
964:
965: IF g_debug <= gme_debug.g_log_unexpected THEN
966: gme_debug.put_line ( 'When others exception in '
967: || g_pkg_name
968: || '.'
969: || l_api_name

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

962: WHEN OTHERS THEN
963: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
964:
965: IF g_debug <= gme_debug.g_log_unexpected THEN
966: gme_debug.put_line ( 'When others exception in '
967: || g_pkg_name
968: || '.'
969: || l_api_name
970: || ' Error is '

Line 1004: IF g_debug <= gme_debug.g_log_procedure THEN

1000: FROM mtl_system_items_b
1001: WHERE organization_id = v_org_id
1002: AND inventory_item_id = v_inventory_item_id;
1003: BEGIN
1004: IF g_debug <= gme_debug.g_log_procedure THEN
1005: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1006: || l_api_name);
1007: END IF;
1008: IF p_reservation_id IS NOT NULL THEN

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

1001: WHERE organization_id = v_org_id
1002: AND inventory_item_id = v_inventory_item_id;
1003: BEGIN
1004: IF g_debug <= gme_debug.g_log_procedure THEN
1005: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1006: || l_api_name);
1007: END IF;
1008: IF p_reservation_id IS NOT NULL THEN
1009: OPEN cur_rsv_rec (p_reservation_id);

Line 1020: IF g_debug <= gme_debug.g_log_statement THEN

1016: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1017: ,'TABLE_NAME'
1018: ,'MTL_RESERVATIONS');
1019:
1020: IF g_debug <= gme_debug.g_log_statement THEN
1021: gme_debug.put_line
1022: ( g_pkg_name
1023: || '.'
1024: || l_api_name

Line 1021: gme_debug.put_line

1017: ,'TABLE_NAME'
1018: ,'MTL_RESERVATIONS');
1019:
1020: IF g_debug <= gme_debug.g_log_statement THEN
1021: gme_debug.put_line
1022: ( g_pkg_name
1023: || '.'
1024: || l_api_name
1025: || ' Retrieval failure against mtl_reservations using id of '

Line 1047: IF g_debug <= gme_debug.g_log_statement THEN

1043: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1044: ,'TABLE_NAME'
1045: ,'MTL_SYSTEM_ITEMS');
1046:
1047: IF g_debug <= gme_debug.g_log_statement THEN
1048: gme_debug.put_line
1049: ( g_pkg_name
1050: || '.'
1051: || l_api_name

Line 1048: gme_debug.put_line

1044: ,'TABLE_NAME'
1045: ,'MTL_SYSTEM_ITEMS');
1046:
1047: IF g_debug <= gme_debug.g_log_statement THEN
1048: gme_debug.put_line
1049: ( g_pkg_name
1050: || '.'
1051: || l_api_name
1052: || ' Retrieval failure against mtl_system_items using id of '

Line 1066: IF g_debug <= gme_debug.g_log_statement THEN

1062: gme_reservations_pvt.reservation_fully_specified
1063: (p_reservation_rec => l_rsv_rec
1064: ,p_item_location_control => NVL(l_item_rec.location_control_code,1)
1065: ,p_item_restrict_locators => l_item_rec.restrict_locators_code);
1066: IF g_debug <= gme_debug.g_log_statement THEN
1067: gme_debug.put_line
1068: ( g_pkg_name
1069: || '.'
1070: || l_api_name

Line 1067: gme_debug.put_line

1063: (p_reservation_rec => l_rsv_rec
1064: ,p_item_location_control => NVL(l_item_rec.location_control_code,1)
1065: ,p_item_restrict_locators => l_item_rec.restrict_locators_code);
1066: IF g_debug <= gme_debug.g_log_statement THEN
1067: gme_debug.put_line
1068: ( g_pkg_name
1069: || '.'
1070: || l_api_name
1071: || ' Return rsv_type from gme_reservations_pvt.reservation_fully_specified is '

Line 1095: IF g_debug <= gme_debug.g_log_unexpected THEN

1091:
1092: WHEN OTHERS THEN
1093: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1094:
1095: IF g_debug <= gme_debug.g_log_unexpected THEN
1096: gme_debug.put_line ( 'When others exception in '
1097: || g_pkg_name
1098: || '.'
1099: || l_api_name

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

1092: WHEN OTHERS THEN
1093: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1094:
1095: IF g_debug <= gme_debug.g_log_unexpected THEN
1096: gme_debug.put_line ( 'When others exception in '
1097: || g_pkg_name
1098: || '.'
1099: || l_api_name
1100: || ' Error is '

Line 1223: gme_debug.log_initialize ('IngredientSubstitution');

1219: --set the timestamp
1220: gme_common_pvt.set_timestamp;
1221:
1222: IF (g_debug IS NOT NULL) THEN
1223: gme_debug.log_initialize ('IngredientSubstitution');
1224: END IF;
1225:
1226: IF p_item_id IS NOT NULL THEN
1227: OPEN item_master_cursor (p_item_id, p_org_id);

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

1284: IF l_formula_tbl.COUNT = 0 THEN
1285: GOTO NEXT_RECORD; --GO to next record
1286: END IF;
1287:
1288: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1289: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1290: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);

Line 1289: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);

1285: GOTO NEXT_RECORD; --GO to next record
1286: END IF;
1287:
1288: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1289: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1290: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1293: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);

Line 1290: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);

1286: END IF;
1287:
1288: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1289: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1290: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1293: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1294: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);

Line 1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);

1287:
1288: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1289: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1290: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1293: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1294: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1295: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);

Line 1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);

1288: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1289: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1290: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1293: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1294: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1295: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);
1296: END IF;

Line 1293: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);

1289: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1290: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1293: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1294: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1295: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);
1296: END IF;
1297:

Line 1294: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);

1290: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1293: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1294: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1295: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);
1296: END IF;
1297:
1298: IF l_formula_tbl (1).inventory_item_id = rec.inventory_item_id AND

Line 1295: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);

1291: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1292: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1293: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1294: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1295: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);
1296: END IF;
1297:
1298: IF l_formula_tbl (1).inventory_item_id = rec.inventory_item_id AND
1299: l_formula_tbl (1).qty = rec.plan_qty AND

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

1706: gme_reservations_pvt.auto_detail_line (
1707: p_material_details_rec => l_material_detail_rec
1708: ,x_return_status => l_return_status);
1709:
1710: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1711: gme_debug.put_line ('return status from auto detail line is: ' || l_return_status);
1712: END IF;
1713:
1714: -- Validate Return Status

Line 1711: gme_debug.put_line ('return status from auto detail line is: ' || l_return_status);

1707: p_material_details_rec => l_material_detail_rec
1708: ,x_return_status => l_return_status);
1709:
1710: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1711: gme_debug.put_line ('return status from auto detail line is: ' || l_return_status);
1712: END IF;
1713:
1714: -- Validate Return Status
1715: IF l_return_status IN (fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error) THEN

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

1756: END IF; -- update inventory ind
1757:
1758: End Bug 7352169 - do not call auto detail line. */
1759:
1760: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1761: gme_debug.put_line ('ASQC is: ' || l_batch_header_rec.automatic_step_calculation);
1762: END IF;
1763:
1764: IF l_batch_header_rec.automatic_step_calculation = 1 THEN

Line 1761: gme_debug.put_line ('ASQC is: ' || l_batch_header_rec.automatic_step_calculation);

1757:
1758: End Bug 7352169 - do not call auto detail line. */
1759:
1760: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1761: gme_debug.put_line ('ASQC is: ' || l_batch_header_rec.automatic_step_calculation);
1762: END IF;
1763:
1764: IF l_batch_header_rec.automatic_step_calculation = 1 THEN
1765: IF l_batch_header_rec.update_inventory_ind = 'Y' AND NOT l_trans_loaded THEN

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

1762: END IF;
1763:
1764: IF l_batch_header_rec.automatic_step_calculation = 1 THEN
1765: IF l_batch_header_rec.update_inventory_ind = 'Y' AND NOT l_trans_loaded THEN
1766: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1767: gme_debug.put_line ('Entered into loading txns');
1768: END IF;
1769:
1770: -- Swapna K Bug#4354690 12-MAY-2005

Line 1767: gme_debug.put_line ('Entered into loading txns');

1763:
1764: IF l_batch_header_rec.automatic_step_calculation = 1 THEN
1765: IF l_batch_header_rec.update_inventory_ind = 'Y' AND NOT l_trans_loaded THEN
1766: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1767: gme_debug.put_line ('Entered into loading txns');
1768: END IF;
1769:
1770: -- Swapna K Bug#4354690 12-MAY-2005
1771: l_return_status := NULL;

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

1820:
1821: l_trans_loaded := TRUE;
1822: END IF; -- update inventory ind
1823:
1824: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1825: gme_debug.put_line ('Before updating step qty');
1826: END IF;
1827:
1828: gme_update_step_qty_pvt.update_step_qty (p_batch_step_rec => l_batchstep_rec,

Line 1825: gme_debug.put_line ('Before updating step qty');

1821: l_trans_loaded := TRUE;
1822: END IF; -- update inventory ind
1823:
1824: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1825: gme_debug.put_line ('Before updating step qty');
1826: END IF;
1827:
1828: gme_update_step_qty_pvt.update_step_qty (p_batch_step_rec => l_batchstep_rec,
1829: x_message_count => l_message_count,

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

1831: x_return_status => x_return_status,
1832: x_batch_step_rec => x_batchstep_rec
1833: );
1834:
1835: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1836: gme_debug.put_line ('After update step qty, return status is: ' || x_return_status);
1837: END IF;
1838: -- Swapna K Bug#4354690 12-MAY-2005
1839: /* l_return_status is replaced with x_return_status in the below if condition */

Line 1836: gme_debug.put_line ('After update step qty, return status is: ' || x_return_status);

1832: x_batch_step_rec => x_batchstep_rec
1833: );
1834:
1835: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1836: gme_debug.put_line ('After update step qty, return status is: ' || x_return_status);
1837: END IF;
1838: -- Swapna K Bug#4354690 12-MAY-2005
1839: /* l_return_status is replaced with x_return_status in the below if condition */
1840: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

1881: GOTO NEXT_RECORD; --GO to next record
1882: END IF;
1883: END IF; -- ASQC
1884:
1885: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1886: gme_debug.put_line ('Before consolidate transacitons');
1887: END IF;
1888:
1889: IF l_batch_header_rec.update_inventory_ind = 'Y' THEN

Line 1886: gme_debug.put_line ('Before consolidate transacitons');

1882: END IF;
1883: END IF; -- ASQC
1884:
1885: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1886: gme_debug.put_line ('Before consolidate transacitons');
1887: END IF;
1888:
1889: IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
1890:

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

1892: gme_resource_engine_pvt.consolidate_batch_resources (l_batch_header_rec.batch_id,
1893: x_return_status
1894: );
1895:
1896: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1897: gme_debug.put_line ('After consolidate resource transactions' || x_return_status);
1898: END IF;
1899:
1900: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1897: gme_debug.put_line ('After consolidate resource transactions' || x_return_status);

1893: x_return_status
1894: );
1895:
1896: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1897: gme_debug.put_line ('After consolidate resource transactions' || x_return_status);
1898: END IF;
1899:
1900: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1901: gme_common_pvt.count_and_get (x_count => l_message_count,

Line 2104: IF (NVL (g_debug, -1) = gme_debug.g_log_procedure) THEN

2100:
2101: uom_conversion_failure EXCEPTION ;
2102: invalid_batch_id EXCEPTION ;
2103: BEGIN
2104: IF (NVL (g_debug, -1) = gme_debug.g_log_procedure) THEN
2105: gme_debug.put_line('Entering gme_api_grp.get_total_quantity with batch id '||p_batch_id);
2106: END IF;
2107:
2108: IF p_batch_id IS NULL THEN

Line 2105: gme_debug.put_line('Entering gme_api_grp.get_total_quantity with batch id '||p_batch_id);

2101: uom_conversion_failure EXCEPTION ;
2102: invalid_batch_id EXCEPTION ;
2103: BEGIN
2104: IF (NVL (g_debug, -1) = gme_debug.g_log_procedure) THEN
2105: gme_debug.put_line('Entering gme_api_grp.get_total_quantity with batch id '||p_batch_id);
2106: END IF;
2107:
2108: IF p_batch_id IS NULL THEN
2109: gme_common_pvt.log_message ('GME_INVALID_BATCH','ID','BATCH_ID');

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

2118: ELSE
2119: prod_uom := p_uom;
2120: END IF;
2121:
2122: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2123: gme_debug.put_line('UOM being used for possible conversion is '||prod_uom);
2124: END IF;
2125:
2126: OPEN get_quantities(p_batch_id, p_line_type);

Line 2123: gme_debug.put_line('UOM being used for possible conversion is '||prod_uom);

2119: prod_uom := p_uom;
2120: END IF;
2121:
2122: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2123: gme_debug.put_line('UOM being used for possible conversion is '||prod_uom);
2124: END IF;
2125:
2126: OPEN get_quantities(p_batch_id, p_line_type);
2127: LOOP

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

2127: LOOP
2128: FETCH get_quantities INTO l_item_id, l_plan_qty, l_wip_plan_qty, l_actual_qty, l_item_um;
2129: EXIT when get_quantities%NOTFOUND ;
2130:
2131: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2132: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2133: gme_debug.put_line('Plan qty '||l_plan_qty);
2134: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2135: gme_debug.put_line('Actual qty '||l_actual_qty);

Line 2132: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');

2128: FETCH get_quantities INTO l_item_id, l_plan_qty, l_wip_plan_qty, l_actual_qty, l_item_um;
2129: EXIT when get_quantities%NOTFOUND ;
2130:
2131: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2132: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2133: gme_debug.put_line('Plan qty '||l_plan_qty);
2134: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2135: gme_debug.put_line('Actual qty '||l_actual_qty);
2136: gme_debug.put_line('UOM '||l_item_um);

Line 2133: gme_debug.put_line('Plan qty '||l_plan_qty);

2129: EXIT when get_quantities%NOTFOUND ;
2130:
2131: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2132: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2133: gme_debug.put_line('Plan qty '||l_plan_qty);
2134: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2135: gme_debug.put_line('Actual qty '||l_actual_qty);
2136: gme_debug.put_line('UOM '||l_item_um);
2137: END IF;

Line 2134: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);

2130:
2131: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2132: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2133: gme_debug.put_line('Plan qty '||l_plan_qty);
2134: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2135: gme_debug.put_line('Actual qty '||l_actual_qty);
2136: gme_debug.put_line('UOM '||l_item_um);
2137: END IF;
2138:

Line 2135: gme_debug.put_line('Actual qty '||l_actual_qty);

2131: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2132: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2133: gme_debug.put_line('Plan qty '||l_plan_qty);
2134: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2135: gme_debug.put_line('Actual qty '||l_actual_qty);
2136: gme_debug.put_line('UOM '||l_item_um);
2137: END IF;
2138:
2139: IF l_item_um <> prod_uom THEN

Line 2136: gme_debug.put_line('UOM '||l_item_um);

2132: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2133: gme_debug.put_line('Plan qty '||l_plan_qty);
2134: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2135: gme_debug.put_line('Actual qty '||l_actual_qty);
2136: gme_debug.put_line('UOM '||l_item_um);
2137: END IF;
2138:
2139: IF l_item_um <> prod_uom THEN
2140: l_plan_qty := inv_convert.inv_um_convert(l_item_id,

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

2145: NULL,
2146: NULL);
2147: IF l_plan_qty < 0 THEN
2148: CLOSE get_quantities;
2149: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2150: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2151: gme_debug.put_line('Plan qty '||l_plan_qty);
2152: gme_debug.put_line('From UOM '||l_item_um);
2153: gme_debug.put_line('To UOM '||prod_uom);

Line 2150: gme_debug.put_line('Conversion failed for item id is '||l_item_id);

2146: NULL);
2147: IF l_plan_qty < 0 THEN
2148: CLOSE get_quantities;
2149: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2150: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2151: gme_debug.put_line('Plan qty '||l_plan_qty);
2152: gme_debug.put_line('From UOM '||l_item_um);
2153: gme_debug.put_line('To UOM '||prod_uom);
2154: END IF;

Line 2151: gme_debug.put_line('Plan qty '||l_plan_qty);

2147: IF l_plan_qty < 0 THEN
2148: CLOSE get_quantities;
2149: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2150: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2151: gme_debug.put_line('Plan qty '||l_plan_qty);
2152: gme_debug.put_line('From UOM '||l_item_um);
2153: gme_debug.put_line('To UOM '||prod_uom);
2154: END IF;
2155:

Line 2152: gme_debug.put_line('From UOM '||l_item_um);

2148: CLOSE get_quantities;
2149: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2150: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2151: gme_debug.put_line('Plan qty '||l_plan_qty);
2152: gme_debug.put_line('From UOM '||l_item_um);
2153: gme_debug.put_line('To UOM '||prod_uom);
2154: END IF;
2155:
2156: -- Bug 9975725

Line 2153: gme_debug.put_line('To UOM '||prod_uom);

2149: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2150: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2151: gme_debug.put_line('Plan qty '||l_plan_qty);
2152: gme_debug.put_line('From UOM '||l_item_um);
2153: gme_debug.put_line('To UOM '||prod_uom);
2154: END IF;
2155:
2156: -- Bug 9975725
2157: gme_common_pvt.log_message

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

2175: NULL,
2176: NULL);
2177: IF l_actual_qty < 0 THEN
2178: CLOSE get_quantities;
2179: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2180: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2181: gme_debug.put_line('Plan qty '||l_plan_qty);
2182: gme_debug.put_line('Actual qty '||l_actual_qty);
2183: END IF;

Line 2180: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');

2176: NULL);
2177: IF l_actual_qty < 0 THEN
2178: CLOSE get_quantities;
2179: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2180: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2181: gme_debug.put_line('Plan qty '||l_plan_qty);
2182: gme_debug.put_line('Actual qty '||l_actual_qty);
2183: END IF;
2184: RAISE uom_conversion_failure;

Line 2181: gme_debug.put_line('Plan qty '||l_plan_qty);

2177: IF l_actual_qty < 0 THEN
2178: CLOSE get_quantities;
2179: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2180: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2181: gme_debug.put_line('Plan qty '||l_plan_qty);
2182: gme_debug.put_line('Actual qty '||l_actual_qty);
2183: END IF;
2184: RAISE uom_conversion_failure;
2185: END IF;

Line 2182: gme_debug.put_line('Actual qty '||l_actual_qty);

2178: CLOSE get_quantities;
2179: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2180: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2181: gme_debug.put_line('Plan qty '||l_plan_qty);
2182: gme_debug.put_line('Actual qty '||l_actual_qty);
2183: END IF;
2184: RAISE uom_conversion_failure;
2185: END IF;
2186:

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

2193: NULL,
2194: NULL);
2195: IF l_wip_plan_qty < 0 THEN
2196: CLOSE get_quantities;
2197: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2198: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2199: gme_debug.put_line('Plan qty '||l_plan_qty);
2200: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2201: gme_debug.put_line('Actual qty '||l_actual_qty);

Line 2198: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');

2194: NULL);
2195: IF l_wip_plan_qty < 0 THEN
2196: CLOSE get_quantities;
2197: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2198: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2199: gme_debug.put_line('Plan qty '||l_plan_qty);
2200: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2201: gme_debug.put_line('Actual qty '||l_actual_qty);
2202: END IF;

Line 2199: gme_debug.put_line('Plan qty '||l_plan_qty);

2195: IF l_wip_plan_qty < 0 THEN
2196: CLOSE get_quantities;
2197: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2198: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2199: gme_debug.put_line('Plan qty '||l_plan_qty);
2200: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2201: gme_debug.put_line('Actual qty '||l_actual_qty);
2202: END IF;
2203: RAISE uom_conversion_failure;

Line 2200: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);

2196: CLOSE get_quantities;
2197: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2198: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2199: gme_debug.put_line('Plan qty '||l_plan_qty);
2200: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2201: gme_debug.put_line('Actual qty '||l_actual_qty);
2202: END IF;
2203: RAISE uom_conversion_failure;
2204: END IF;

Line 2201: gme_debug.put_line('Actual qty '||l_actual_qty);

2197: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2198: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2199: gme_debug.put_line('Plan qty '||l_plan_qty);
2200: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2201: gme_debug.put_line('Actual qty '||l_actual_qty);
2202: END IF;
2203: RAISE uom_conversion_failure;
2204: END IF;
2205: --Bug#5111078 End

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

2218: x_total_actual_qty := l_total_actual_qty;
2219: -- This line will return uom used for conversion.
2220: x_uom := prod_uom;
2221:
2222: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2223: gme_debug.put_line('Qtys being returned are:');
2224: gme_debug.put_line('Total plan qty '||l_total_plan_qty);
2225: gme_debug.put_line('Total actual qty '||l_total_actual_qty);
2226: END IF;

Line 2223: gme_debug.put_line('Qtys being returned are:');

2219: -- This line will return uom used for conversion.
2220: x_uom := prod_uom;
2221:
2222: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2223: gme_debug.put_line('Qtys being returned are:');
2224: gme_debug.put_line('Total plan qty '||l_total_plan_qty);
2225: gme_debug.put_line('Total actual qty '||l_total_actual_qty);
2226: END IF;
2227: x_return_status := fnd_api.g_ret_sts_success;

Line 2224: gme_debug.put_line('Total plan qty '||l_total_plan_qty);

2220: x_uom := prod_uom;
2221:
2222: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2223: gme_debug.put_line('Qtys being returned are:');
2224: gme_debug.put_line('Total plan qty '||l_total_plan_qty);
2225: gme_debug.put_line('Total actual qty '||l_total_actual_qty);
2226: END IF;
2227: x_return_status := fnd_api.g_ret_sts_success;
2228: EXCEPTION

Line 2225: gme_debug.put_line('Total actual qty '||l_total_actual_qty);

2221:
2222: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2223: gme_debug.put_line('Qtys being returned are:');
2224: gme_debug.put_line('Total plan qty '||l_total_plan_qty);
2225: gme_debug.put_line('Total actual qty '||l_total_actual_qty);
2226: END IF;
2227: x_return_status := fnd_api.g_ret_sts_success;
2228: EXCEPTION
2229: WHEN uom_conversion_failure THEN

Line 2268: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

2264: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
2265: l_ret boolean;
2266: l_api_name VARCHAR2 (50) := 'check_inv_negative';
2267: BEGIN
2268: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
2269: gme_debug.g_log_procedure THEN
2270: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2271: END IF;
2272: -- Initially let us assign the return status to success

Line 2269: gme_debug.g_log_procedure THEN

2265: l_ret boolean;
2266: l_api_name VARCHAR2 (50) := 'check_inv_negative';
2267: BEGIN
2268: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
2269: gme_debug.g_log_procedure THEN
2270: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2271: END IF;
2272: -- Initially let us assign the return status to success
2273: x_return_status := fnd_api.g_ret_sts_success;

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

2266: l_api_name VARCHAR2 (50) := 'check_inv_negative';
2267: BEGIN
2268: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
2269: gme_debug.g_log_procedure THEN
2270: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2271: END IF;
2272: -- Initially let us assign the return status to success
2273: x_return_status := fnd_api.g_ret_sts_success;
2274:

Line 2301: IF (g_debug <= gme_debug.g_log_statement) THEN

2297: ( x_count => x_msg_count
2298: ,p_encoded => fnd_api.g_false
2299: ,x_data => x_msg_data);
2300:
2301: IF (g_debug <= gme_debug.g_log_statement) THEN
2302: gme_debug.put_line ( g_pkg_name
2303: || '.'
2304: || l_api_name
2305: || ':'

Line 2302: gme_debug.put_line ( g_pkg_name

2298: ,p_encoded => fnd_api.g_false
2299: ,x_data => x_msg_data);
2300:
2301: IF (g_debug <= gme_debug.g_log_statement) THEN
2302: gme_debug.put_line ( g_pkg_name
2303: || '.'
2304: || l_api_name
2305: || ':'
2306: || 'Exiting with '

Line 2331: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2327: gme_common_pvt.count_and_get
2328: ( x_count => x_msg_count
2329: ,p_encoded => fnd_api.g_false
2330: ,x_data => x_msg_data);
2331: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2332: gme_debug.put_line ( g_pkg_name
2333: || '.'
2334: || l_api_name
2335: || ':'

Line 2332: gme_debug.put_line ( g_pkg_name

2328: ( x_count => x_msg_count
2329: ,p_encoded => fnd_api.g_false
2330: ,x_data => x_msg_data);
2331: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2332: gme_debug.put_line ( g_pkg_name
2333: || '.'
2334: || l_api_name
2335: || ':'
2336: || 'WHEN OTHERS:'

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

2374:
2375: BEGIN
2376: --Take the value of the profile,GME: Ingredient Substitution Date
2377: l_ingred_sub_date := gme_common_pvt.g_ingr_sub_date;
2378: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2379: gme_debug.put_line ( g_pkg_name
2380: || '.'
2381: || l_api_name
2382: || ':'

Line 2379: gme_debug.put_line ( g_pkg_name

2375: BEGIN
2376: --Take the value of the profile,GME: Ingredient Substitution Date
2377: l_ingred_sub_date := gme_common_pvt.g_ingr_sub_date;
2378: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2379: gme_debug.put_line ( g_pkg_name
2380: || '.'
2381: || l_api_name
2382: || ':'
2383: || 'l_ingred_sub_date : '

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

2387: IF l_ingred_sub_date = 2 THEN -- Ingredient Requirement Date
2388: OPEN cur_get_matl_requirement_dt (p_material_detail_id);
2389: FETCH cur_get_matl_requirement_dt INTO l_matl_requirement_dt;
2390: CLOSE cur_get_matl_requirement_dt;
2391: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2392: gme_debug.put_line ( g_pkg_name
2393: || '.'
2394: || l_api_name
2395: || ':'

Line 2392: gme_debug.put_line ( g_pkg_name

2388: OPEN cur_get_matl_requirement_dt (p_material_detail_id);
2389: FETCH cur_get_matl_requirement_dt INTO l_matl_requirement_dt;
2390: CLOSE cur_get_matl_requirement_dt;
2391: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2392: gme_debug.put_line ( g_pkg_name
2393: || '.'
2394: || l_api_name
2395: || ':'
2396: || 'l_matl_requirement_dt : '

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

2402: OPEN cur_get_start_end_Date (p_batch_id);
2403: FETCH cur_get_start_end_Date INTO l_plan_start_date,l_plan_cmplt_date;
2404: CLOSE cur_get_start_end_Date;
2405: IF l_ingred_sub_date = 1 THEN -- Batch Start Date
2406: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2407: gme_debug.put_line ( g_pkg_name
2408: || '.'
2409: || l_api_name
2410: || ':'

Line 2407: gme_debug.put_line ( g_pkg_name

2403: FETCH cur_get_start_end_Date INTO l_plan_start_date,l_plan_cmplt_date;
2404: CLOSE cur_get_start_end_Date;
2405: IF l_ingred_sub_date = 1 THEN -- Batch Start Date
2406: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2407: gme_debug.put_line ( g_pkg_name
2408: || '.'
2409: || l_api_name
2410: || ':'
2411: || 'l_ingr_sub_dt = l_plan_start_date : '

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

2412: || TO_CHAR(l_plan_start_date, 'MON-DD-YYYY HH24:MI:SS'));
2413: END IF;
2414: RETURN l_plan_start_date;
2415: ELSIF l_ingred_sub_date = 3 THEN -- Batch Completion Date
2416: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2417: gme_debug.put_line ( g_pkg_name
2418: || '.'
2419: || l_api_name
2420: || ':'

Line 2417: gme_debug.put_line ( g_pkg_name

2413: END IF;
2414: RETURN l_plan_start_date;
2415: ELSIF l_ingred_sub_date = 3 THEN -- Batch Completion Date
2416: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2417: gme_debug.put_line ( g_pkg_name
2418: || '.'
2419: || l_api_name
2420: || ':'
2421: || 'l_ingr_sub_dt = l_plan_cmplt_date : '

Line 2438: IF g_debug <= gme_debug.g_log_procedure THEN

2434: x_resvns_cur OUT NOCOPY g_gmo_resvns,
2435: x_return_status OUT NOCOPY VARCHAR2) IS
2436: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_resvns';
2437: BEGIN
2438: IF g_debug <= gme_debug.g_log_procedure THEN
2439: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2440: END IF;
2441: x_return_status := FND_API.G_RET_STS_SUCCESS;
2442: OPEN x_resvns_cur FOR

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

2435: x_return_status OUT NOCOPY VARCHAR2) IS
2436: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_resvns';
2437: BEGIN
2438: IF g_debug <= gme_debug.g_log_procedure THEN
2439: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2440: END IF;
2441: x_return_status := FND_API.G_RET_STS_SUCCESS;
2442: OPEN x_resvns_cur FOR
2443: SELECT mr.*

Line 2458: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2454: EXCEPTION
2455: WHEN OTHERS THEN
2456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2458: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2459: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2460: END IF;
2461: END get_mat_resvns;
2462:

Line 2459: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2455: WHEN OTHERS THEN
2456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2458: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2459: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2460: END IF;
2461: END get_mat_resvns;
2462:
2463: PROCEDURE get_mat_pplots(p_mat_det_id IN NUMBER,

Line 2468: IF g_debug <= gme_debug.g_log_procedure THEN

2464: x_pplot_cur OUT NOCOPY g_gmo_pplots,
2465: x_return_status OUT NOCOPY VARCHAR2) IS
2466: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_pplots';
2467: BEGIN
2468: IF g_debug <= gme_debug.g_log_procedure THEN
2469: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2470: END IF;
2471: x_return_status := FND_API.G_RET_STS_SUCCESS;
2472: OPEN x_pplot_cur FOR

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

2465: x_return_status OUT NOCOPY VARCHAR2) IS
2466: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_pplots';
2467: BEGIN
2468: IF g_debug <= gme_debug.g_log_procedure THEN
2469: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2470: END IF;
2471: x_return_status := FND_API.G_RET_STS_SUCCESS;
2472: OPEN x_pplot_cur FOR
2473: SELECT *

Line 2481: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2477: EXCEPTION
2478: WHEN OTHERS THEN
2479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2480: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2481: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2482: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2483: END IF;
2484: END get_mat_pplots;
2485:

Line 2482: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2478: WHEN OTHERS THEN
2479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2480: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2481: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2482: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2483: END IF;
2484: END get_mat_pplots;
2485:
2486: PROCEDURE get_mat_trans(p_organization_id IN NUMBER,

Line 2493: IF g_debug <= gme_debug.g_log_procedure THEN

2489: x_txns_cur OUT NOCOPY g_gmo_txns,
2490: x_return_status OUT NOCOPY VARCHAR2) IS
2491: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_trans';
2492: BEGIN
2493: IF g_debug <= gme_debug.g_log_procedure THEN
2494: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2495: END IF;
2496: x_return_status := FND_API.G_RET_STS_SUCCESS;
2497: OPEN x_txns_cur FOR

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

2490: x_return_status OUT NOCOPY VARCHAR2) IS
2491: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_trans';
2492: BEGIN
2493: IF g_debug <= gme_debug.g_log_procedure THEN
2494: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2495: END IF;
2496: x_return_status := FND_API.G_RET_STS_SUCCESS;
2497: OPEN x_txns_cur FOR
2498: SELECT *

Line 2513: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2509: EXCEPTION
2510: WHEN OTHERS THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2512: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2513: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2514: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2515: END IF;
2516: END get_mat_trans;
2517:

Line 2514: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2510: WHEN OTHERS THEN
2511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2512: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2513: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2514: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2515: END IF;
2516: END get_mat_trans;
2517:
2518: PROCEDURE get_lot_trans(p_transaction_id IN NUMBER,

Line 2523: IF g_debug <= gme_debug.g_log_procedure THEN

2519: x_lot_txns_cur OUT NOCOPY g_gmo_lot_txns,
2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521: l_api_name CONSTANT VARCHAR2 (30) := 'get_lot_trans';
2522: BEGIN
2523: IF g_debug <= gme_debug.g_log_procedure THEN
2524: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2525: END IF;
2526: x_return_status := FND_API.G_RET_STS_SUCCESS;
2527: OPEN x_lot_txns_cur FOR

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

2520: x_return_status OUT NOCOPY VARCHAR2) IS
2521: l_api_name CONSTANT VARCHAR2 (30) := 'get_lot_trans';
2522: BEGIN
2523: IF g_debug <= gme_debug.g_log_procedure THEN
2524: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2525: END IF;
2526: x_return_status := FND_API.G_RET_STS_SUCCESS;
2527: OPEN x_lot_txns_cur FOR
2528: SELECT *

Line 2535: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2535: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2536: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2537: END IF;
2538: END get_lot_trans;
2539:

Line 2536: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2532: WHEN OTHERS THEN
2533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2535: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2536: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2537: END IF;
2538: END get_lot_trans;
2539:
2540: PROCEDURE create_material_txn(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

Line 2549: IF g_debug <= gme_debug.g_log_procedure THEN

2545: setup_failed EXCEPTION;
2546: create_txn_fail EXCEPTION;
2547: validate_txn_fail EXCEPTION;
2548: BEGIN
2549: IF g_debug <= gme_debug.g_log_procedure THEN
2550: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2551: END IF;
2552: x_return_status := FND_API.G_RET_STS_SUCCESS;
2553: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2546: create_txn_fail EXCEPTION;
2547: validate_txn_fail EXCEPTION;
2548: BEGIN
2549: IF g_debug <= gme_debug.g_log_procedure THEN
2550: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2551: END IF;
2552: x_return_status := FND_API.G_RET_STS_SUCCESS;
2553: IF NOT(gme_common_pvt.g_setup_done) THEN
2554: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_mmti_rec.organization_id);

Line 2575: IF g_debug <= gme_debug.g_log_procedure THEN

2571: x_return_status => l_return_status);
2572: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2573: RAISE create_txn_fail;
2574: END IF;
2575: IF g_debug <= gme_debug.g_log_procedure THEN
2576: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2577: END IF;
2578: EXCEPTION
2579: WHEN setup_failed THEN

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

2572: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2573: RAISE create_txn_fail;
2574: END IF;
2575: IF g_debug <= gme_debug.g_log_procedure THEN
2576: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2577: END IF;
2578: EXCEPTION
2579: WHEN setup_failed THEN
2580: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2586: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2582: x_return_status := l_return_status;
2583: WHEN OTHERS THEN
2584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2585: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2586: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2587: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2588: END IF;
2589: END create_material_txn;
2590:

Line 2587: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2583: WHEN OTHERS THEN
2584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2585: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2586: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2587: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2588: END IF;
2589: END create_material_txn;
2590:
2591: PROCEDURE update_material_txn(p_transaction_id IN NUMBER,

Line 2610: IF g_debug <= gme_debug.g_log_procedure THEN

2606: update_txn_fail EXCEPTION;
2607: validate_txn_fail EXCEPTION;
2608: update_txn_mismatch EXCEPTION;
2609: BEGIN
2610: IF g_debug <= gme_debug.g_log_procedure THEN
2611: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2612: END IF;
2613: x_return_status := FND_API.G_RET_STS_SUCCESS;
2614: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2607: validate_txn_fail EXCEPTION;
2608: update_txn_mismatch EXCEPTION;
2609: BEGIN
2610: IF g_debug <= gme_debug.g_log_procedure THEN
2611: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2612: END IF;
2613: x_return_status := FND_API.G_RET_STS_SUCCESS;
2614: IF NOT(gme_common_pvt.g_setup_done) THEN
2615: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_mmti_rec.organization_id);

Line 2646: IF g_debug <= gme_debug.g_log_procedure THEN

2642: x_return_status => l_return_status);
2643: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2644: RAISE update_txn_fail;
2645: END IF;
2646: IF g_debug <= gme_debug.g_log_procedure THEN
2647: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2648: END IF;
2649: EXCEPTION
2650: WHEN setup_failed THEN

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

2643: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2644: RAISE update_txn_fail;
2645: END IF;
2646: IF g_debug <= gme_debug.g_log_procedure THEN
2647: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2648: END IF;
2649: EXCEPTION
2650: WHEN setup_failed THEN
2651: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2660: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2656: x_return_status := l_return_status;
2657: WHEN OTHERS THEN
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2660: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2661: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2662: END IF;
2663: END update_material_txn;
2664:

Line 2661: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2657: WHEN OTHERS THEN
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2660: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2661: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2662: END IF;
2663: END update_material_txn;
2664:
2665: PROCEDURE delete_material_txn(p_organization_id IN NUMBER,

Line 2680: IF g_debug <= gme_debug.g_log_procedure THEN

2676: get_txn_fail EXCEPTION;
2677: const_txn_fail EXCEPTION;
2678: validate_txn_fail EXCEPTION;
2679: BEGIN
2680: IF g_debug <= gme_debug.g_log_procedure THEN
2681: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2682: END IF;
2683: x_return_status := FND_API.G_RET_STS_SUCCESS;
2684: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2677: const_txn_fail EXCEPTION;
2678: validate_txn_fail EXCEPTION;
2679: BEGIN
2680: IF g_debug <= gme_debug.g_log_procedure THEN
2681: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2682: END IF;
2683: x_return_status := FND_API.G_RET_STS_SUCCESS;
2684: IF NOT(gme_common_pvt.g_setup_done) THEN
2685: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_organization_id);

Line 2720: IF g_debug <= gme_debug.g_log_procedure THEN

2716: x_return_status => l_return_status);
2717: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2718: RAISE delete_txn_fail;
2719: END IF;
2720: IF g_debug <= gme_debug.g_log_procedure THEN
2721: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2722: END IF;
2723: EXCEPTION
2724: WHEN setup_failed THEN

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

2717: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2718: RAISE delete_txn_fail;
2719: END IF;
2720: IF g_debug <= gme_debug.g_log_procedure THEN
2721: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2722: END IF;
2723: EXCEPTION
2724: WHEN setup_failed THEN
2725: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2731: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2727: x_return_status := l_return_status;
2728: WHEN OTHERS THEN
2729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2730: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2731: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2732: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2733: END IF;
2734: END delete_material_txn;
2735:

Line 2732: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2728: WHEN OTHERS THEN
2729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2730: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2731: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2732: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2733: END IF;
2734: END delete_material_txn;
2735:
2736: PROCEDURE create_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

Line 2763: IF g_debug <= gme_debug.g_log_procedure THEN

2759: rsrc_update_err EXCEPTION;
2760: reduce_pend_usage_err EXCEPTION;
2761: error_load_trans EXCEPTION;
2762: BEGIN
2763: IF g_debug <= gme_debug.g_log_procedure THEN
2764: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2765: END IF;
2766: x_return_status := FND_API.G_RET_STS_SUCCESS;
2767: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2760: reduce_pend_usage_err EXCEPTION;
2761: error_load_trans EXCEPTION;
2762: BEGIN
2763: IF g_debug <= gme_debug.g_log_procedure THEN
2764: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2765: END IF;
2766: x_return_status := FND_API.G_RET_STS_SUCCESS;
2767: IF NOT(gme_common_pvt.g_setup_done) THEN
2768: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_rsrc_txn_gtmp_rec.organization_id);

Line 2847: IF g_debug <= gme_debug.g_log_procedure THEN

2843: END IF;
2844: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2845: RAISE rsrc_update_err;
2846: END IF;
2847: IF g_debug <= gme_debug.g_log_procedure THEN
2848: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2849: END IF;
2850: EXCEPTION
2851: WHEN setup_failed OR uom_conversion_err OR missing_profile_option OR rsrc_fetch_err OR rsrc_update_err THEN

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

2844: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2845: RAISE rsrc_update_err;
2846: END IF;
2847: IF g_debug <= gme_debug.g_log_procedure THEN
2848: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2849: END IF;
2850: EXCEPTION
2851: WHEN setup_failed OR uom_conversion_err OR missing_profile_option OR rsrc_fetch_err OR rsrc_update_err THEN
2852: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2858: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2854: x_return_status := l_return_status;
2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2858: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2859: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2860: END IF;
2861: END create_resource_txn;
2862:

Line 2859: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2857: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2858: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2859: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2860: END IF;
2861: END create_resource_txn;
2862:
2863: PROCEDURE update_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

Line 2885: IF g_debug <= gme_debug.g_log_procedure THEN

2881: upd_rsrc_err EXCEPTION;
2882: get_usage_fail EXCEPTION;
2883: reduce_pend_usage_err EXCEPTION;
2884: BEGIN
2885: IF g_debug <= gme_debug.g_log_procedure THEN
2886: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2887: END IF;
2888: x_return_status := FND_API.G_RET_STS_SUCCESS;
2889: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2882: get_usage_fail EXCEPTION;
2883: reduce_pend_usage_err EXCEPTION;
2884: BEGIN
2885: IF g_debug <= gme_debug.g_log_procedure THEN
2886: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2887: END IF;
2888: x_return_status := FND_API.G_RET_STS_SUCCESS;
2889: IF NOT(gme_common_pvt.g_setup_done) THEN
2890: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_rsrc_txn_gtmp_rec.organization_id);

Line 2946: IF g_debug <= gme_debug.g_log_procedure THEN

2942: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2943: RAISE upd_rsrc_err;
2944: END IF;
2945: END IF;
2946: IF g_debug <= gme_debug.g_log_procedure THEN
2947: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2948: END IF;
2949: EXCEPTION
2950: WHEN setup_failed OR error_load_trans OR rsrc_fetch_err OR get_usage_fail OR upd_rsrc_err THEN

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

2943: RAISE upd_rsrc_err;
2944: END IF;
2945: END IF;
2946: IF g_debug <= gme_debug.g_log_procedure THEN
2947: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2948: END IF;
2949: EXCEPTION
2950: WHEN setup_failed OR error_load_trans OR rsrc_fetch_err OR get_usage_fail OR upd_rsrc_err THEN
2951: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2957: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2953: x_return_status := l_return_status;
2954: WHEN OTHERS THEN
2955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2956: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2957: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2958: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2959: END IF;
2960: END update_resource_txn;
2961:

Line 2958: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

2954: WHEN OTHERS THEN
2955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2956: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2957: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2958: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2959: END IF;
2960: END update_resource_txn;
2961:
2962: PROCEDURE delete_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

Line 2987: IF g_debug <= gme_debug.g_log_procedure THEN

2983: upd_rsrc_err EXCEPTION;
2984: get_usage_fail EXCEPTION;
2985: reduce_pend_usage_err EXCEPTION;
2986: BEGIN
2987: IF g_debug <= gme_debug.g_log_procedure THEN
2988: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2989: END IF;
2990: x_return_status := FND_API.G_RET_STS_SUCCESS;
2991: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2984: get_usage_fail EXCEPTION;
2985: reduce_pend_usage_err EXCEPTION;
2986: BEGIN
2987: IF g_debug <= gme_debug.g_log_procedure THEN
2988: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2989: END IF;
2990: x_return_status := FND_API.G_RET_STS_SUCCESS;
2991: IF NOT(gme_common_pvt.g_setup_done) THEN
2992: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_rsrc_txn_gtmp_rec.organization_id);

Line 3041: IF g_debug <= gme_debug.g_log_procedure THEN

3037: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
3038: RAISE upd_rsrc_err;
3039: END IF;
3040: END IF;
3041: IF g_debug <= gme_debug.g_log_procedure THEN
3042: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3043: END IF;
3044: EXCEPTION
3045: WHEN setup_failed OR fetch_txn_failed OR validation_fail OR rsrc_fetch_err OR upd_rsrc_err THEN

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

3038: RAISE upd_rsrc_err;
3039: END IF;
3040: END IF;
3041: IF g_debug <= gme_debug.g_log_procedure THEN
3042: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3043: END IF;
3044: EXCEPTION
3045: WHEN setup_failed OR fetch_txn_failed OR validation_fail OR rsrc_fetch_err OR upd_rsrc_err THEN
3046: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3052: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

3048: x_return_status := l_return_status;
3049: WHEN OTHERS THEN
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3052: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3053: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
3054: END IF;
3055: END delete_resource_txn;
3056: END gme_api_grp;

Line 3053: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

3049: WHEN OTHERS THEN
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3052: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3053: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
3054: END IF;
3055: END delete_resource_txn;
3056: END gme_api_grp;