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 104: IF (g_debug <= gme_debug.g_log_statement) THEN

100: RAISE fnd_api.g_exc_error;
101: END IF;
102:
103: x_return_status := l_return_status;
104: IF (g_debug <= gme_debug.g_log_statement) THEN
105: gme_debug.put_line ( g_pkg_name
106: || '.'
107: || l_api_name
108: || ':'

Line 105: gme_debug.put_line ( g_pkg_name

101: END IF;
102:
103: x_return_status := l_return_status;
104: IF (g_debug <= gme_debug.g_log_statement) THEN
105: gme_debug.put_line ( g_pkg_name
106: || '.'
107: || l_api_name
108: || ':'
109: || 'Exiting with '

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

116: x_return_status := fnd_api.g_ret_sts_unexp_error;
117: WHEN OTHERS THEN
118: x_return_status := fnd_api.g_ret_sts_unexp_error;
119:
120: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
121: gme_debug.put_line ( g_pkg_name
122: || '.'
123: || l_api_name
124: || ':'

Line 121: gme_debug.put_line ( g_pkg_name

117: WHEN OTHERS THEN
118: x_return_status := fnd_api.g_ret_sts_unexp_error;
119:
120: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
121: gme_debug.put_line ( g_pkg_name
122: || '.'
123: || l_api_name
124: || ':'
125: || 'WHEN OTHERS:'

Line 186: IF g_debug <= gme_debug.g_log_procedure THEN

182: supply_demand_error EXCEPTION;
183:
184: BEGIN
185:
186: IF g_debug <= gme_debug.g_log_procedure THEN
187: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
188: END IF;
189:
190: /* Set the return status to success initially */

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

183:
184: BEGIN
185:
186: IF g_debug <= gme_debug.g_log_procedure THEN
187: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
188: END IF;
189:
190: /* Set the return status to success initially */
191: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 207: IF g_debug <= gme_debug.g_log_statement THEN

203: RAISE invalid_version;
204: END IF;
205:
206: /* Ensure mandatory inputs supplied */
207: IF g_debug <= gme_debug.g_log_statement THEN
208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');
209: END IF;
210: IF p_organization_id IS NULL THEN
211: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'ORGANIZATION_ID');

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

204: END IF;
205:
206: /* Ensure mandatory inputs supplied */
207: IF g_debug <= gme_debug.g_log_statement THEN
208: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');
209: END IF;
210: IF p_organization_id IS NULL THEN
211: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'ORGANIZATION_ID');
212: RAISE input_param_missing;

Line 233: IF g_debug <= gme_debug.g_log_statement THEN

229:
230: /* Retrieve batch header row */
231: l_batch_header_rec.batch_id := p_supply_demand_header_id;
232: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
233: IF g_debug <= gme_debug.g_log_statement THEN
234: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
235: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
236: END IF;
237: RAISE fetch_failure;

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

230: /* Retrieve batch header row */
231: l_batch_header_rec.batch_id := p_supply_demand_header_id;
232: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
233: IF g_debug <= gme_debug.g_log_statement THEN
234: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
235: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
236: END IF;
237: RAISE fetch_failure;
238: END IF;

Line 239: IF g_debug <= gme_debug.g_log_statement THEN

235: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
236: END IF;
237: RAISE fetch_failure;
238: END IF;
239: IF g_debug <= gme_debug.g_log_statement THEN
240: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch Status '||l_batch_header_rec.batch_status);
241: END IF;
242:
243: /* Verify that update_inventory is allowed for the Batch */

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

236: END IF;
237: RAISE fetch_failure;
238: END IF;
239: IF g_debug <= gme_debug.g_log_statement THEN
240: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Batch Status '||l_batch_header_rec.batch_status);
241: END IF;
242:
243: /* Verify that update_inventory is allowed for the Batch */
244: IF l_batch_header_rec.update_inventory_ind <> 'Y' THEN

Line 265: IF g_debug <= gme_debug.g_log_statement THEN

261:
262: /* Retrieve material details record */
263: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
264: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
265: IF g_debug <= gme_debug.g_log_statement THEN
266: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
267: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
268: END IF;
269: RAISE fetch_failure;

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

262: /* Retrieve material details record */
263: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
264: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
265: IF g_debug <= gme_debug.g_log_statement THEN
266: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
267: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
268: END IF;
269: RAISE fetch_failure;
270: END IF;

Line 296: IF g_debug <= gme_debug.g_log_statement THEN

292: gme_common_pvt.log_message('GME_INVALID_RSV_FOR_BYPROD');
293: RAISE validation_error;
294: END IF;
295:
296: IF g_debug <= gme_debug.g_log_statement THEN
297: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Material Release Type '||l_material_details_rec.release_type);
298: END IF;
299: /* Verify p_supply_demand_code and line_type. */
300: IF p_supply_demand_code = 2 /* Demand */ AND

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

293: RAISE validation_error;
294: END IF;
295:
296: IF g_debug <= gme_debug.g_log_statement THEN
297: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Material Release Type '||l_material_details_rec.release_type);
298: END IF;
299: /* Verify p_supply_demand_code and line_type. */
300: IF p_supply_demand_code = 2 /* Demand */ AND
301: l_material_details_rec.line_type <> gme_common_pvt.g_line_type_ing THEN

Line 322: IF g_debug <= gme_debug.g_log_statement THEN

318: --Bug#4604943 following code is commented out
319: /* BUG 4604943 BEGIN - check for auto AND autobystep here
320: IF l_mat_status in ( gme_common_pvt.g_mtl_auto_release ,gme_common_pvt.g_mtl_autobystep_release) AND
321: l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
322: IF g_debug <= gme_debug.g_log_statement THEN
323: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');
324: END IF;
325: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
326: RAISE supply_demand_error;

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

319: /* BUG 4604943 BEGIN - check for auto AND autobystep here
320: IF l_mat_status in ( gme_common_pvt.g_mtl_auto_release ,gme_common_pvt.g_mtl_autobystep_release) AND
321: l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
322: IF g_debug <= gme_debug.g_log_statement THEN
323: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');
324: END IF;
325: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
326: RAISE supply_demand_error;
327: BUG 4604943 END

Line 331: IF g_debug <= gme_debug.g_log_statement THEN

327: BUG 4604943 END
328: ELS */
329: IF l_mat_status = gme_common_pvt.g_mtl_auto_release AND
330: l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
331: IF g_debug <= gme_debug.g_log_statement THEN
332: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');
333: END IF;
334: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
335: RAISE supply_demand_error;

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

328: ELS */
329: IF l_mat_status = gme_common_pvt.g_mtl_auto_release AND
330: l_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
331: IF g_debug <= gme_debug.g_log_statement THEN
332: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic Release Material in WIP batch not a valid demand');
333: END IF;
334: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
335: RAISE supply_demand_error;
336: ELSIF l_mat_status = gme_common_pvt.g_mtl_autobystep_release THEN

Line 338: IF g_debug <= gme_debug.g_log_statement THEN

334: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
335: RAISE supply_demand_error;
336: ELSIF l_mat_status = gme_common_pvt.g_mtl_autobystep_release THEN
337: IF NOT gme_common_pvt.get_assoc_step(l_material_details_rec.material_detail_id,l_step_id,l_step_status) THEN
338: IF g_debug <= gme_debug.g_log_statement THEN
339: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Error in get_assoc_step');
340: END IF;
341: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
342: RAISE supply_demand_error;

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

335: RAISE supply_demand_error;
336: ELSIF l_mat_status = gme_common_pvt.g_mtl_autobystep_release THEN
337: IF NOT gme_common_pvt.get_assoc_step(l_material_details_rec.material_detail_id,l_step_id,l_step_status) THEN
338: IF g_debug <= gme_debug.g_log_statement THEN
339: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Error in get_assoc_step');
340: END IF;
341: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
342: RAISE supply_demand_error;
343: ELSIF l_step_id IS NOT NULL AND NVL(l_step_status,-1) >= gme_common_pvt.g_step_wip THEN

Line 344: IF g_debug <= gme_debug.g_log_statement THEN

340: END IF;
341: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
342: RAISE supply_demand_error;
343: ELSIF l_step_id IS NOT NULL AND NVL(l_step_status,-1) >= gme_common_pvt.g_step_wip THEN
344: IF g_debug <= gme_debug.g_log_statement THEN
345: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic By Step Material in step: '||l_step_id||
346: ' with status of '||l_step_status||' not a valid demand');
347: END IF;
348: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');

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

341: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
342: RAISE supply_demand_error;
343: ELSIF l_step_id IS NOT NULL AND NVL(l_step_status,-1) >= gme_common_pvt.g_step_wip THEN
344: IF g_debug <= gme_debug.g_log_statement THEN
345: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Automatic By Step Material in step: '||l_step_id||
346: ' with status of '||l_step_status||' not a valid demand');
347: END IF;
348: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
349: RAISE supply_demand_error;

Line 354: IF g_debug <= gme_debug.g_log_procedure THEN

350: END IF; -- IF l_step_id IS NOT NULL AND NVL(l_step_status,-1) = gme_common_pvt.g_step_wip THEN
351: END IF; -- IF l_mat_status = gme_common_pvt.g_mtl_auto_release AND
352: END IF;
353:
354: IF g_debug <= gme_debug.g_log_procedure THEN
355: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
356: END IF;
357: EXCEPTION
358: /* Exception handling */

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

351: END IF; -- IF l_mat_status = gme_common_pvt.g_mtl_auto_release AND
352: END IF;
353:
354: IF g_debug <= gme_debug.g_log_procedure THEN
355: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
356: END IF;
357: EXCEPTION
358: /* Exception handling */
359: WHEN invalid_version OR input_param_missing OR validation_error

Line 367: IF g_debug <= gme_debug.g_log_unexpected THEN

363: gme_common_pvt.count_and_get(x_count => x_msg_count,
364: p_encoded => FND_API.g_false,
365: x_data => x_msg_data);
366: WHEN OTHERS THEN
367: IF g_debug <= gme_debug.g_log_unexpected THEN
368: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);
369: END IF;
370: x_return_status := FND_API.g_ret_sts_unexp_error;
371: x_valid_status := 'N';

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

364: p_encoded => FND_API.g_false,
365: x_data => x_msg_data);
366: WHEN OTHERS THEN
367: IF g_debug <= gme_debug.g_log_unexpected THEN
368: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);
369: END IF;
370: x_return_status := FND_API.g_ret_sts_unexp_error;
371: x_valid_status := 'N';
372: gme_common_pvt.count_and_get(x_count => x_msg_count,

Line 430: IF g_debug <= gme_debug.g_log_procedure THEN

426: fetch_failure EXCEPTION;
427:
428: BEGIN
429:
430: IF g_debug <= gme_debug.g_log_procedure THEN
431: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
432: END IF;
433:
434: /* Set the return status to success initially */

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

427:
428: BEGIN
429:
430: IF g_debug <= gme_debug.g_log_procedure THEN
431: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
432: END IF;
433:
434: /* Set the return status to success initially */
435: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 447: IF g_debug <= gme_debug.g_log_statement THEN

443: RAISE invalid_version;
444: END IF;
445:
446: /* Ensure mandatory inputs supplied */
447: IF g_debug <= gme_debug.g_log_statement THEN
448: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');
449: END IF;
450: IF p_supply_demand_code IS NULL THEN
451: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'SUPPLY_DEMAND_CODE');

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

444: END IF;
445:
446: /* Ensure mandatory inputs supplied */
447: IF g_debug <= gme_debug.g_log_statement THEN
448: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' validate for mandatory input parameters ');
449: END IF;
450: IF p_supply_demand_code IS NULL THEN
451: gme_common_pvt.log_message('GME_FIELD_VALUE_REQUIRED','FIELD_NAME', 'SUPPLY_DEMAND_CODE');
452: RAISE input_param_missing;

Line 467: IF g_debug <= gme_debug.g_log_statement THEN

463:
464: /* Retrieve batch header */
465: l_batch_header_rec.batch_id := p_supply_demand_header_id;
466: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
467: IF g_debug <= gme_debug.g_log_statement THEN
468: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
469: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
470: END IF;
471: RAISE fetch_failure;

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

464: /* Retrieve batch header */
465: l_batch_header_rec.batch_id := p_supply_demand_header_id;
466: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
467: IF g_debug <= gme_debug.g_log_statement THEN
468: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
469: 'Fetch failure against gme_batch_header using id of '||p_supply_demand_header_id);
470: END IF;
471: RAISE fetch_failure;
472: END IF;

Line 477: IF g_debug <= gme_debug.g_log_statement THEN

473:
474: /* For Batch in Completed status , return 0*/
475: IF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_completed THEN
476: x_available_quantity := 0;
477: IF g_debug <= gme_debug.g_log_statement THEN
478: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
479: 'Batch status is completed so return available of 0 ');
480: END IF;
481: RETURN;

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

474: /* For Batch in Completed status , return 0*/
475: IF l_batch_header_rec.batch_status = gme_common_pvt.g_batch_completed THEN
476: x_available_quantity := 0;
477: IF g_debug <= gme_debug.g_log_statement THEN
478: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
479: 'Batch status is completed so return available of 0 ');
480: END IF;
481: RETURN;
482: END IF;

Line 487: IF g_debug <= gme_debug.g_log_statement THEN

483:
484: /* Retrieve material details record */
485: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
486: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
487: IF g_debug <= gme_debug.g_log_statement THEN
488: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
489: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
490: END IF;
491: RAISE fetch_failure;

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

484: /* Retrieve material details record */
485: l_material_details_rec.material_detail_id := p_supply_demand_line_id;
486: IF (NOT(gme_material_details_dbl.fetch_row(l_material_details_rec, l_material_details_rec))) THEN
487: IF g_debug <= gme_debug.g_log_statement THEN
488: gme_debug.put_line(g_pkg_name||'.'||l_api_name||
489: 'Fetch failure against gme_material_details using id of '||p_supply_demand_line_id);
490: END IF;
491: RAISE fetch_failure;
492: END IF;

Line 523: IF g_debug <= gme_debug.g_log_statement THEN

519: /* Now retrieve the primary UOM code for the item */
520: OPEN cur_item (l_material_details_rec.organization_id,l_material_details_rec.inventory_item_id);
521: FETCH cur_item INTO l_primary_uom_code;
522: CLOSE cur_item;
523: IF g_debug <= gme_debug.g_log_statement THEN
524: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' primary uom code '||l_primary_uom_code);
525: END IF;
526:
527: /* Return the uom code and primary uom code */

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

520: OPEN cur_item (l_material_details_rec.organization_id,l_material_details_rec.inventory_item_id);
521: FETCH cur_item INTO l_primary_uom_code;
522: CLOSE cur_item;
523: IF g_debug <= gme_debug.g_log_statement THEN
524: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' primary uom code '||l_primary_uom_code);
525: END IF;
526:
527: /* Return the uom code and primary uom code */
528: x_source_uom_code := l_material_details_rec.dtl_um;

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

529: x_source_primary_uom_code := l_primary_uom_code;
530:
531: /* Return the available supply demand quantity.*/
532: /* The value will be same for p_supply_demand_code as Demand or Supply */
533: IF (g_debug <= gme_debug.g_log_unexpected) THEN
534: gme_debug.put_line ( g_pkg_name
535: || '.'
536: || l_api_name
537: || ':'

Line 534: gme_debug.put_line ( g_pkg_name

530:
531: /* Return the available supply demand quantity.*/
532: /* The value will be same for p_supply_demand_code as Demand or Supply */
533: IF (g_debug <= gme_debug.g_log_unexpected) THEN
534: gme_debug.put_line ( g_pkg_name
535: || '.'
536: || l_api_name
537: || ':'
538: || 'Compute available qty from these figues:'

Line 553: IF g_debug <= gme_debug.g_log_procedure THEN

549: l_available_quantity := NVL(l_material_details_rec.wip_plan_qty, l_material_details_rec.plan_qty) - l_material_details_rec.actual_qty;
550: -- To conform to INV standards, round to 5 decimal places
551: x_available_quantity := ROUND(l_available_quantity,5);
552: END IF;
553: IF g_debug <= gme_debug.g_log_procedure THEN
554: gme_debug.put_line ('Available quantity computes as '|| x_available_quantity);
555: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
556: END IF;
557: RETURN;

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

550: -- To conform to INV standards, round to 5 decimal places
551: x_available_quantity := ROUND(l_available_quantity,5);
552: END IF;
553: IF g_debug <= gme_debug.g_log_procedure THEN
554: gme_debug.put_line ('Available quantity computes as '|| x_available_quantity);
555: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
556: END IF;
557: RETURN;
558: EXCEPTION

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

551: x_available_quantity := ROUND(l_available_quantity,5);
552: END IF;
553: IF g_debug <= gme_debug.g_log_procedure THEN
554: gme_debug.put_line ('Available quantity computes as '|| x_available_quantity);
555: gme_debug.put_line ('Completed '|| l_api_name|| ' at '|| TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS'));
556: END IF;
557: RETURN;
558: EXCEPTION
559: /* Exception handling */

Line 566: IF g_debug <= gme_debug.g_log_unexpected THEN

562: gme_common_pvt.count_and_get(x_count => x_msg_count,
563: p_encoded => FND_API.g_false,
564: x_data => x_msg_data);
565: WHEN OTHERS THEN
566: IF g_debug <= gme_debug.g_log_unexpected THEN
567: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);
568: END IF;
569: x_return_status := FND_API.g_ret_sts_unexp_error;
570: gme_common_pvt.count_and_get(x_count => x_msg_count,

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

563: p_encoded => FND_API.g_false,
564: x_data => x_msg_data);
565: WHEN OTHERS THEN
566: IF g_debug <= gme_debug.g_log_unexpected THEN
567: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'When others exception:'|| SQLERRM);
568: END IF;
569: x_return_status := FND_API.g_ret_sts_unexp_error;
570: gme_common_pvt.count_and_get(x_count => x_msg_count,
571: p_encoded => FND_API.g_false,

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

646: BEGIN
647: -- Initially let us assign the return status to success
648: x_return_status := fnd_api.g_ret_sts_success;
649:
650: IF (g_debug <= gme_debug.g_log_statement) THEN
651: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
652: || 'Entering');
653: gme_debug.put_line ( g_pkg_name
654: || '.'

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

647: -- Initially let us assign the return status to success
648: x_return_status := fnd_api.g_ret_sts_success;
649:
650: IF (g_debug <= gme_debug.g_log_statement) THEN
651: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
652: || 'Entering');
653: gme_debug.put_line ( g_pkg_name
654: || '.'
655: || l_api_name

Line 653: gme_debug.put_line ( g_pkg_name

649:
650: IF (g_debug <= gme_debug.g_log_statement) THEN
651: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
652: || 'Entering');
653: gme_debug.put_line ( g_pkg_name
654: || '.'
655: || l_api_name
656: || ':'
657: || 'batch_id is :'

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

671: RAISE fnd_api.g_exc_error;
672: END IF;
673: END IF;
674:
675: IF (g_debug <= gme_debug.g_log_statement) THEN
676: gme_debug.put_line ( g_pkg_name
677: || '.'
678: || l_api_name
679: || ':'

Line 676: gme_debug.put_line ( g_pkg_name

672: END IF;
673: END IF;
674:
675: IF (g_debug <= gme_debug.g_log_statement) THEN
676: gme_debug.put_line ( g_pkg_name
677: || '.'
678: || l_api_name
679: || ':'
680: || 'Exiting with '

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

688:
689: WHEN OTHERS THEN
690: x_return_status := fnd_api.g_ret_sts_unexp_error;
691:
692: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
693: gme_debug.put_line ( g_pkg_name
694: || '.'
695: || l_api_name
696: || ':'

Line 693: gme_debug.put_line ( g_pkg_name

689: WHEN OTHERS THEN
690: x_return_status := fnd_api.g_ret_sts_unexp_error;
691:
692: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
693: gme_debug.put_line ( g_pkg_name
694: || '.'
695: || l_api_name
696: || ':'
697: || 'WHEN OTHERS:'

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

718: BEGIN
719: -- Initially let us assign the return status to success
720: x_return_status := fnd_api.g_ret_sts_success;
721:
722: IF (g_debug <= gme_debug.g_log_statement) THEN
723: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
724: || 'Entering');
725: gme_debug.put_line ( g_pkg_name
726: || '.'

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

719: -- Initially let us assign the return status to success
720: x_return_status := fnd_api.g_ret_sts_success;
721:
722: IF (g_debug <= gme_debug.g_log_statement) THEN
723: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
724: || 'Entering');
725: gme_debug.put_line ( g_pkg_name
726: || '.'
727: || l_api_name

Line 725: gme_debug.put_line ( g_pkg_name

721:
722: IF (g_debug <= gme_debug.g_log_statement) THEN
723: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
724: || 'Entering');
725: gme_debug.put_line ( g_pkg_name
726: || '.'
727: || l_api_name
728: || ':'
729: || 'batch_id is :'

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

742: RAISE fnd_api.g_exc_error;
743: END IF;
744: END IF;
745:
746: IF (g_debug <= gme_debug.g_log_statement) THEN
747: gme_debug.put_line ( g_pkg_name
748: || '.'
749: || l_api_name
750: || ':'

Line 747: gme_debug.put_line ( g_pkg_name

743: END IF;
744: END IF;
745:
746: IF (g_debug <= gme_debug.g_log_statement) THEN
747: gme_debug.put_line ( g_pkg_name
748: || '.'
749: || l_api_name
750: || ':'
751: || 'Exiting with '

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

759:
760: WHEN OTHERS THEN
761: x_return_status := fnd_api.g_ret_sts_unexp_error;
762:
763: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
764: gme_debug.put_line ( g_pkg_name
765: || '.'
766: || l_api_name
767: || ':'

Line 764: gme_debug.put_line ( g_pkg_name

760: WHEN OTHERS THEN
761: x_return_status := fnd_api.g_ret_sts_unexp_error;
762:
763: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
764: gme_debug.put_line ( g_pkg_name
765: || '.'
766: || l_api_name
767: || ':'
768: || 'WHEN OTHERS:'

Line 800: IF g_debug <= gme_debug.g_log_procedure THEN

796: ) IS
797:
798: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LCF_BATCH';
799: BEGIN
800: IF g_debug <= gme_debug.g_log_procedure THEN
801: gme_debug.log_initialize('CreateLCFBatch');
802: END IF;
803:
804: IF g_debug <= gme_debug.g_log_procedure THEN

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

797:
798: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LCF_BATCH';
799: BEGIN
800: IF g_debug <= gme_debug.g_log_procedure THEN
801: gme_debug.log_initialize('CreateLCFBatch');
802: END IF;
803:
804: IF g_debug <= gme_debug.g_log_procedure THEN
805: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 804: IF g_debug <= gme_debug.g_log_procedure THEN

800: IF g_debug <= gme_debug.g_log_procedure THEN
801: gme_debug.log_initialize('CreateLCFBatch');
802: END IF;
803:
804: IF g_debug <= gme_debug.g_log_procedure THEN
805: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
806: || l_api_name);
807: END IF;
808: IF p_init_msg_list = fnd_api.g_true THEN

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

801: gme_debug.log_initialize('CreateLCFBatch');
802: END IF;
803:
804: IF g_debug <= gme_debug.g_log_procedure THEN
805: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
806: || l_api_name);
807: END IF;
808: IF p_init_msg_list = fnd_api.g_true THEN
809: fnd_msg_pub.initialize;

Line 822: IF g_debug <= gme_debug.g_log_procedure THEN

818: gme_common_pvt.log_message ('GME_INVALID_API_VERSION');
819: RAISE fnd_api.g_exc_error;
820: END IF;
821: /* Setup the common constants used accross the apis */
822: IF g_debug <= gme_debug.g_log_procedure THEN
823: gme_debug.put_line ('Calling gme_common_pvt.setup.');
824: END IF;
825:
826: gme_common_pvt.g_setup_done :=

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

819: RAISE fnd_api.g_exc_error;
820: END IF;
821: /* Setup the common constants used accross the apis */
822: IF g_debug <= gme_debug.g_log_procedure THEN
823: gme_debug.put_line ('Calling gme_common_pvt.setup.');
824: END IF;
825:
826: gme_common_pvt.g_setup_done :=
827: gme_common_pvt.setup (p_org_id => p_batch_header_rec.organization_id

Line 830: IF g_debug <= gme_debug.g_log_procedure THEN

826: gme_common_pvt.g_setup_done :=
827: gme_common_pvt.setup (p_org_id => p_batch_header_rec.organization_id
828: ,p_org_code => NULL);
829:
830: IF g_debug <= gme_debug.g_log_procedure THEN
831: gme_debug.put_line ('After calling gme_common_pvt.setup.');
832: END IF;
833:
834: IF NOT gme_common_pvt.g_setup_done THEN

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

827: gme_common_pvt.setup (p_org_id => p_batch_header_rec.organization_id
828: ,p_org_code => NULL);
829:
830: IF g_debug <= gme_debug.g_log_procedure THEN
831: gme_debug.put_line ('After calling gme_common_pvt.setup.');
832: END IF;
833:
834: IF NOT gme_common_pvt.g_setup_done THEN
835: x_return_status := fnd_api.g_ret_sts_error;

Line 861: IF g_debug <= gme_debug.g_log_procedure THEN

857: ,p_is_phantom => 'N'
858: ,x_exception_material_tbl => x_exception_material_tbl
859: );
860: IF x_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_inv_short_err,'C') THEN
861: IF g_debug <= gme_debug.g_log_procedure THEN
862: gme_debug.put_line ('Error in Create Batch: return status'||x_return_status);
863: END IF;
864: RAISE fnd_api.g_exc_error;
865: END IF;

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

858: ,x_exception_material_tbl => x_exception_material_tbl
859: );
860: IF x_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_inv_short_err,'C') THEN
861: IF g_debug <= gme_debug.g_log_procedure THEN
862: gme_debug.put_line ('Error in Create Batch: return status'||x_return_status);
863: END IF;
864: RAISE fnd_api.g_exc_error;
865: END IF;
866: IF g_debug <= gme_debug.g_log_procedure THEN

Line 866: IF g_debug <= gme_debug.g_log_procedure THEN

862: gme_debug.put_line ('Error in Create Batch: return status'||x_return_status);
863: END IF;
864: RAISE fnd_api.g_exc_error;
865: END IF;
866: IF g_debug <= gme_debug.g_log_procedure THEN
867: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
868: END IF;
869:
870:

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

863: END IF;
864: RAISE fnd_api.g_exc_error;
865: END IF;
866: IF g_debug <= gme_debug.g_log_procedure THEN
867: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
868: END IF;
869:
870:
871: EXCEPTION

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

883: ,x_data => x_message_list);
884: WHEN OTHERS THEN
885: x_return_status := fnd_api.g_ret_sts_unexp_error;
886: x_batch_header_rec := null;
887: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
888: gme_debug.put_line ( g_pkg_name
889: || '.'
890: || l_api_name
891: || ':'

Line 888: gme_debug.put_line ( g_pkg_name

884: WHEN OTHERS THEN
885: x_return_status := fnd_api.g_ret_sts_unexp_error;
886: x_batch_header_rec := null;
887: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
888: gme_debug.put_line ( g_pkg_name
889: || '.'
890: || l_api_name
891: || ':'
892: || 'WHEN OTHERS:'

Line 915: IF g_debug <= gme_debug.g_log_procedure THEN

911: l_open_qty NUMBER := 0;
912: l_return_status VARCHAR2 (1);
913: l_mtl_dtl_rec gme_material_details%ROWTYPE;
914: BEGIN
915: IF g_debug <= gme_debug.g_log_procedure THEN
916: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
917: || l_api_name);
918: END IF;
919:

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

912: l_return_status VARCHAR2 (1);
913: l_mtl_dtl_rec gme_material_details%ROWTYPE;
914: BEGIN
915: IF g_debug <= gme_debug.g_log_procedure THEN
916: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
917: || l_api_name);
918: END IF;
919:
920: l_mtl_dtl_rec.organization_id := p_organization_id;

Line 941: IF g_debug <= gme_debug.g_log_unexpected THEN

937: EXCEPTION
938: WHEN OTHERS THEN
939: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
940:
941: IF g_debug <= gme_debug.g_log_unexpected THEN
942: gme_debug.put_line ( 'When others exception in '
943: || g_pkg_name
944: || '.'
945: || l_api_name

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

938: WHEN OTHERS THEN
939: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
940:
941: IF g_debug <= gme_debug.g_log_unexpected THEN
942: gme_debug.put_line ( 'When others exception in '
943: || g_pkg_name
944: || '.'
945: || l_api_name
946: || ' Error is '

Line 980: IF g_debug <= gme_debug.g_log_procedure THEN

976: FROM mtl_system_items_b
977: WHERE organization_id = v_org_id
978: AND inventory_item_id = v_inventory_item_id;
979: BEGIN
980: IF g_debug <= gme_debug.g_log_procedure THEN
981: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
982: || l_api_name);
983: END IF;
984: IF p_reservation_id IS NOT NULL THEN

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

977: WHERE organization_id = v_org_id
978: AND inventory_item_id = v_inventory_item_id;
979: BEGIN
980: IF g_debug <= gme_debug.g_log_procedure THEN
981: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
982: || l_api_name);
983: END IF;
984: IF p_reservation_id IS NOT NULL THEN
985: OPEN cur_rsv_rec (p_reservation_id);

Line 996: IF g_debug <= gme_debug.g_log_statement THEN

992: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
993: ,'TABLE_NAME'
994: ,'MTL_RESERVATIONS');
995:
996: IF g_debug <= gme_debug.g_log_statement THEN
997: gme_debug.put_line
998: ( g_pkg_name
999: || '.'
1000: || l_api_name

Line 997: gme_debug.put_line

993: ,'TABLE_NAME'
994: ,'MTL_RESERVATIONS');
995:
996: IF g_debug <= gme_debug.g_log_statement THEN
997: gme_debug.put_line
998: ( g_pkg_name
999: || '.'
1000: || l_api_name
1001: || ' Retrieval failure against mtl_reservations using id of '

Line 1023: IF g_debug <= gme_debug.g_log_statement THEN

1019: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
1020: ,'TABLE_NAME'
1021: ,'MTL_SYSTEM_ITEMS');
1022:
1023: IF g_debug <= gme_debug.g_log_statement THEN
1024: gme_debug.put_line
1025: ( g_pkg_name
1026: || '.'
1027: || l_api_name

Line 1024: gme_debug.put_line

1020: ,'TABLE_NAME'
1021: ,'MTL_SYSTEM_ITEMS');
1022:
1023: IF g_debug <= gme_debug.g_log_statement THEN
1024: gme_debug.put_line
1025: ( g_pkg_name
1026: || '.'
1027: || l_api_name
1028: || ' Retrieval failure against mtl_system_items using id of '

Line 1042: IF g_debug <= gme_debug.g_log_statement THEN

1038: gme_reservations_pvt.reservation_fully_specified
1039: (p_reservation_rec => l_rsv_rec
1040: ,p_item_location_control => NVL(l_item_rec.location_control_code,1)
1041: ,p_item_restrict_locators => l_item_rec.restrict_locators_code);
1042: IF g_debug <= gme_debug.g_log_statement THEN
1043: gme_debug.put_line
1044: ( g_pkg_name
1045: || '.'
1046: || l_api_name

Line 1043: gme_debug.put_line

1039: (p_reservation_rec => l_rsv_rec
1040: ,p_item_location_control => NVL(l_item_rec.location_control_code,1)
1041: ,p_item_restrict_locators => l_item_rec.restrict_locators_code);
1042: IF g_debug <= gme_debug.g_log_statement THEN
1043: gme_debug.put_line
1044: ( g_pkg_name
1045: || '.'
1046: || l_api_name
1047: || ' Return rsv_type from gme_reservations_pvt.reservation_fully_specified is '

Line 1071: IF g_debug <= gme_debug.g_log_unexpected THEN

1067:
1068: WHEN OTHERS THEN
1069: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1070:
1071: IF g_debug <= gme_debug.g_log_unexpected THEN
1072: gme_debug.put_line ( 'When others exception in '
1073: || g_pkg_name
1074: || '.'
1075: || l_api_name

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

1068: WHEN OTHERS THEN
1069: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1070:
1071: IF g_debug <= gme_debug.g_log_unexpected THEN
1072: gme_debug.put_line ( 'When others exception in '
1073: || g_pkg_name
1074: || '.'
1075: || l_api_name
1076: || ' Error is '

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

1190: --set the timestamp
1191: gme_common_pvt.set_timestamp;
1192:
1193: IF (g_debug IS NOT NULL) THEN
1194: gme_debug.log_initialize ('IngredientSubstitution');
1195: END IF;
1196:
1197: IF p_item_id IS NOT NULL THEN
1198: OPEN item_master_cursor (p_item_id, p_org_id);

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

1255: IF l_formula_tbl.COUNT = 0 THEN
1256: GOTO NEXT_RECORD; --GO to next record
1257: END IF;
1258:
1259: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1260: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1261: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1262: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1263: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);

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

1256: GOTO NEXT_RECORD; --GO to next record
1257: END IF;
1258:
1259: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1260: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1261: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1262: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1263: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1264: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);

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

1257: END IF;
1258:
1259: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1260: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1261: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1262: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1263: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1264: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1265: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);

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

1258:
1259: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1260: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1261: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1262: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1263: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1264: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1265: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1266: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);

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

1259: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1260: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1261: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1262: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1263: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1264: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1265: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1266: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);
1267: END IF;

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

1260: gme_debug.put_line (' I/P formulaline_id line id is: ' || rec.formulaline_id);
1261: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1262: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1263: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1264: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1265: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1266: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);
1267: END IF;
1268:

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

1261: gme_debug.put_line (' I/P item id is is: ' || rec.inventory_item_id);
1262: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1263: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1264: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1265: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1266: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);
1267: END IF;
1268:
1269: IF l_formula_tbl (1).inventory_item_id = rec.inventory_item_id AND

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

1262: gme_debug.put_line (' I/P plan_qty Qty is: ' || rec.plan_qty);
1263: gme_debug.put_line (' I/P UOM is: ' || rec.dtl_um);
1264: gme_debug.put_line (' O/P item id is is: ' || l_formula_tbl (1).inventory_item_id);
1265: gme_debug.put_line (' O/P plan_qty Qty is: ' || l_formula_tbl (1).qty);
1266: gme_debug.put_line ('O/P UOM is: ' || l_formula_tbl (1).detail_uom);
1267: END IF;
1268:
1269: IF l_formula_tbl (1).inventory_item_id = rec.inventory_item_id AND
1270: l_formula_tbl (1).qty = rec.plan_qty AND

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

1653: gme_reservations_pvt.auto_detail_line (
1654: p_material_details_rec => l_material_detail_rec
1655: ,x_return_status => l_return_status);
1656:
1657: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1658: gme_debug.put_line ('return status from auto detail line is: ' || l_return_status);
1659: END IF;
1660:
1661: -- Validate Return Status

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

1654: p_material_details_rec => l_material_detail_rec
1655: ,x_return_status => l_return_status);
1656:
1657: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1658: gme_debug.put_line ('return status from auto detail line is: ' || l_return_status);
1659: END IF;
1660:
1661: -- Validate Return Status
1662: IF l_return_status IN (fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error) THEN

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

1701: END IF; -- IF l_return_status IN (fnd_api.g_ret_sts_unexp_error, fnd_api.g_ret_sts_error) THEN
1702:
1703: END IF; -- update inventory ind
1704:
1705: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1706: gme_debug.put_line ('ASQC is: ' || l_batch_header_rec.automatic_step_calculation);
1707: END IF;
1708:
1709: IF l_batch_header_rec.automatic_step_calculation = 1 THEN

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

1702:
1703: END IF; -- update inventory ind
1704:
1705: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1706: gme_debug.put_line ('ASQC is: ' || l_batch_header_rec.automatic_step_calculation);
1707: END IF;
1708:
1709: IF l_batch_header_rec.automatic_step_calculation = 1 THEN
1710: IF l_batch_header_rec.update_inventory_ind = 'Y' AND NOT l_trans_loaded THEN

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

1707: END IF;
1708:
1709: IF l_batch_header_rec.automatic_step_calculation = 1 THEN
1710: IF l_batch_header_rec.update_inventory_ind = 'Y' AND NOT l_trans_loaded THEN
1711: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1712: gme_debug.put_line ('Entered into loading txns');
1713: END IF;
1714:
1715: -- Swapna K Bug#4354690 12-MAY-2005

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

1708:
1709: IF l_batch_header_rec.automatic_step_calculation = 1 THEN
1710: IF l_batch_header_rec.update_inventory_ind = 'Y' AND NOT l_trans_loaded THEN
1711: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1712: gme_debug.put_line ('Entered into loading txns');
1713: END IF;
1714:
1715: -- Swapna K Bug#4354690 12-MAY-2005
1716: l_return_status := NULL;

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

1762:
1763: l_trans_loaded := TRUE;
1764: END IF; -- update inventory ind
1765:
1766: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1767: gme_debug.put_line ('Before updating step qty');
1768: END IF;
1769:
1770: gme_update_step_qty_pvt.update_step_qty (p_batch_step_rec => l_batchstep_rec,

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

1763: l_trans_loaded := TRUE;
1764: END IF; -- update inventory ind
1765:
1766: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1767: gme_debug.put_line ('Before updating step qty');
1768: END IF;
1769:
1770: gme_update_step_qty_pvt.update_step_qty (p_batch_step_rec => l_batchstep_rec,
1771: x_message_count => l_message_count,

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

1773: x_return_status => x_return_status,
1774: x_batch_step_rec => x_batchstep_rec
1775: );
1776:
1777: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1778: gme_debug.put_line ('After update step qty, return status is: ' || x_return_status);
1779: END IF;
1780: -- Swapna K Bug#4354690 12-MAY-2005
1781: /* l_return_status is replaced with x_return_status in the below if condition */

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

1774: x_batch_step_rec => x_batchstep_rec
1775: );
1776:
1777: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1778: gme_debug.put_line ('After update step qty, return status is: ' || x_return_status);
1779: END IF;
1780: -- Swapna K Bug#4354690 12-MAY-2005
1781: /* l_return_status is replaced with x_return_status in the below if condition */
1782: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

1820: GOTO NEXT_RECORD; --GO to next record
1821: END IF;
1822: END IF; -- ASQC
1823:
1824: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1825: gme_debug.put_line ('Before consolidate transacitons');
1826: END IF;
1827:
1828: IF l_batch_header_rec.update_inventory_ind = 'Y' THEN

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

1821: END IF;
1822: END IF; -- ASQC
1823:
1824: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1825: gme_debug.put_line ('Before consolidate transacitons');
1826: END IF;
1827:
1828: IF l_batch_header_rec.update_inventory_ind = 'Y' THEN
1829:

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

1831: gme_resource_engine_pvt.consolidate_batch_resources (l_batch_header_rec.batch_id,
1832: x_return_status
1833: );
1834:
1835: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1836: gme_debug.put_line ('After consolidate resource transactions' || x_return_status);
1837: END IF;
1838:
1839: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

1832: x_return_status
1833: );
1834:
1835: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1836: gme_debug.put_line ('After consolidate resource transactions' || x_return_status);
1837: END IF;
1838:
1839: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1840: gme_common_pvt.count_and_get (x_count => l_message_count,

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

2027:
2028: uom_conversion_failure EXCEPTION ;
2029: invalid_batch_id EXCEPTION ;
2030: BEGIN
2031: IF (NVL (g_debug, -1) = gme_debug.g_log_procedure) THEN
2032: gme_debug.put_line('Entering gme_api_grp.get_total_quantity with batch id '||p_batch_id);
2033: END IF;
2034:
2035: IF p_batch_id IS NULL THEN

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

2028: uom_conversion_failure EXCEPTION ;
2029: invalid_batch_id EXCEPTION ;
2030: BEGIN
2031: IF (NVL (g_debug, -1) = gme_debug.g_log_procedure) THEN
2032: gme_debug.put_line('Entering gme_api_grp.get_total_quantity with batch id '||p_batch_id);
2033: END IF;
2034:
2035: IF p_batch_id IS NULL THEN
2036: gme_common_pvt.log_message ('GME_INVALID_BATCH','ID','BATCH_ID');

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

2045: ELSE
2046: prod_uom := p_uom;
2047: END IF;
2048:
2049: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2050: gme_debug.put_line('UOM being used for possible conversion is '||prod_uom);
2051: END IF;
2052:
2053: OPEN get_quantities(p_batch_id, p_line_type);

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

2046: prod_uom := p_uom;
2047: END IF;
2048:
2049: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2050: gme_debug.put_line('UOM being used for possible conversion is '||prod_uom);
2051: END IF;
2052:
2053: OPEN get_quantities(p_batch_id, p_line_type);
2054: LOOP

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

2054: LOOP
2055: FETCH get_quantities INTO l_item_id, l_plan_qty, l_wip_plan_qty, l_actual_qty, l_item_um;
2056: EXIT when get_quantities%NOTFOUND ;
2057:
2058: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2059: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2060: gme_debug.put_line('Plan qty '||l_plan_qty);
2061: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2062: gme_debug.put_line('Actual qty '||l_actual_qty);

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

2055: FETCH get_quantities INTO l_item_id, l_plan_qty, l_wip_plan_qty, l_actual_qty, l_item_um;
2056: EXIT when get_quantities%NOTFOUND ;
2057:
2058: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2059: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2060: gme_debug.put_line('Plan qty '||l_plan_qty);
2061: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2062: gme_debug.put_line('Actual qty '||l_actual_qty);
2063: gme_debug.put_line('UOM '||l_item_um);

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

2056: EXIT when get_quantities%NOTFOUND ;
2057:
2058: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2059: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2060: gme_debug.put_line('Plan qty '||l_plan_qty);
2061: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2062: gme_debug.put_line('Actual qty '||l_actual_qty);
2063: gme_debug.put_line('UOM '||l_item_um);
2064: END IF;

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

2057:
2058: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2059: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2060: gme_debug.put_line('Plan qty '||l_plan_qty);
2061: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2062: gme_debug.put_line('Actual qty '||l_actual_qty);
2063: gme_debug.put_line('UOM '||l_item_um);
2064: END IF;
2065:

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

2058: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2059: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2060: gme_debug.put_line('Plan qty '||l_plan_qty);
2061: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2062: gme_debug.put_line('Actual qty '||l_actual_qty);
2063: gme_debug.put_line('UOM '||l_item_um);
2064: END IF;
2065:
2066: IF l_item_um <> prod_uom THEN

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

2059: gme_debug.put_line('Fetched values for item id '||l_item_id||' are:');
2060: gme_debug.put_line('Plan qty '||l_plan_qty);
2061: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2062: gme_debug.put_line('Actual qty '||l_actual_qty);
2063: gme_debug.put_line('UOM '||l_item_um);
2064: END IF;
2065:
2066: IF l_item_um <> prod_uom THEN
2067: l_plan_qty := inv_convert.inv_um_convert(l_item_id,

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

2072: NULL,
2073: NULL);
2074: IF l_plan_qty < 0 THEN
2075: CLOSE get_quantities;
2076: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2077: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2078: gme_debug.put_line('Plan qty '||l_plan_qty);
2079: gme_debug.put_line('From UOM '||l_item_um);
2080: gme_debug.put_line('To UOM '||prod_uom);

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

2073: NULL);
2074: IF l_plan_qty < 0 THEN
2075: CLOSE get_quantities;
2076: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2077: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2078: gme_debug.put_line('Plan qty '||l_plan_qty);
2079: gme_debug.put_line('From UOM '||l_item_um);
2080: gme_debug.put_line('To UOM '||prod_uom);
2081: END IF;

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

2074: IF l_plan_qty < 0 THEN
2075: CLOSE get_quantities;
2076: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2077: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2078: gme_debug.put_line('Plan qty '||l_plan_qty);
2079: gme_debug.put_line('From UOM '||l_item_um);
2080: gme_debug.put_line('To UOM '||prod_uom);
2081: END IF;
2082: RAISE uom_conversion_failure;

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

2075: CLOSE get_quantities;
2076: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2077: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2078: gme_debug.put_line('Plan qty '||l_plan_qty);
2079: gme_debug.put_line('From UOM '||l_item_um);
2080: gme_debug.put_line('To UOM '||prod_uom);
2081: END IF;
2082: RAISE uom_conversion_failure;
2083: END IF;

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

2076: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2077: gme_debug.put_line('Conversion failed for item id is '||l_item_id);
2078: gme_debug.put_line('Plan qty '||l_plan_qty);
2079: gme_debug.put_line('From UOM '||l_item_um);
2080: gme_debug.put_line('To UOM '||prod_uom);
2081: END IF;
2082: RAISE uom_conversion_failure;
2083: END IF;
2084:

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

2090: NULL,
2091: NULL);
2092: IF l_actual_qty < 0 THEN
2093: CLOSE get_quantities;
2094: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2095: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2096: gme_debug.put_line('Plan qty '||l_plan_qty);
2097: gme_debug.put_line('Actual qty '||l_actual_qty);
2098: END IF;

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

2091: NULL);
2092: IF l_actual_qty < 0 THEN
2093: CLOSE get_quantities;
2094: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2095: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2096: gme_debug.put_line('Plan qty '||l_plan_qty);
2097: gme_debug.put_line('Actual qty '||l_actual_qty);
2098: END IF;
2099: RAISE uom_conversion_failure;

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

2092: IF l_actual_qty < 0 THEN
2093: CLOSE get_quantities;
2094: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2095: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2096: gme_debug.put_line('Plan qty '||l_plan_qty);
2097: gme_debug.put_line('Actual qty '||l_actual_qty);
2098: END IF;
2099: RAISE uom_conversion_failure;
2100: END IF;

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

2093: CLOSE get_quantities;
2094: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2095: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2096: gme_debug.put_line('Plan qty '||l_plan_qty);
2097: gme_debug.put_line('Actual qty '||l_actual_qty);
2098: END IF;
2099: RAISE uom_conversion_failure;
2100: END IF;
2101:

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

2108: NULL,
2109: NULL);
2110: IF l_wip_plan_qty < 0 THEN
2111: CLOSE get_quantities;
2112: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2113: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2114: gme_debug.put_line('Plan qty '||l_plan_qty);
2115: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2116: gme_debug.put_line('Actual qty '||l_actual_qty);

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

2109: NULL);
2110: IF l_wip_plan_qty < 0 THEN
2111: CLOSE get_quantities;
2112: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2113: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2114: gme_debug.put_line('Plan qty '||l_plan_qty);
2115: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2116: gme_debug.put_line('Actual qty '||l_actual_qty);
2117: END IF;

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

2110: IF l_wip_plan_qty < 0 THEN
2111: CLOSE get_quantities;
2112: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2113: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2114: gme_debug.put_line('Plan qty '||l_plan_qty);
2115: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2116: gme_debug.put_line('Actual qty '||l_actual_qty);
2117: END IF;
2118: RAISE uom_conversion_failure;

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

2111: CLOSE get_quantities;
2112: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2113: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2114: gme_debug.put_line('Plan qty '||l_plan_qty);
2115: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2116: gme_debug.put_line('Actual qty '||l_actual_qty);
2117: END IF;
2118: RAISE uom_conversion_failure;
2119: END IF;

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

2112: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2113: gme_debug.put_line('Converted values for item id '||l_item_id||' are:');
2114: gme_debug.put_line('Plan qty '||l_plan_qty);
2115: gme_debug.put_line('WIP Plan qty '||l_wip_plan_qty);
2116: gme_debug.put_line('Actual qty '||l_actual_qty);
2117: END IF;
2118: RAISE uom_conversion_failure;
2119: END IF;
2120: --Bug#5111078 End

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

2133: x_total_actual_qty := l_total_actual_qty;
2134: -- This line will return uom used for conversion.
2135: x_uom := prod_uom;
2136:
2137: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2138: gme_debug.put_line('Qtys being returned are:');
2139: gme_debug.put_line('Total plan qty '||l_total_plan_qty);
2140: gme_debug.put_line('Total actual qty '||l_total_actual_qty);
2141: END IF;

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

2134: -- This line will return uom used for conversion.
2135: x_uom := prod_uom;
2136:
2137: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2138: gme_debug.put_line('Qtys being returned are:');
2139: gme_debug.put_line('Total plan qty '||l_total_plan_qty);
2140: gme_debug.put_line('Total actual qty '||l_total_actual_qty);
2141: END IF;
2142: x_return_status := fnd_api.g_ret_sts_success;

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

2135: x_uom := prod_uom;
2136:
2137: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2138: gme_debug.put_line('Qtys being returned are:');
2139: gme_debug.put_line('Total plan qty '||l_total_plan_qty);
2140: gme_debug.put_line('Total actual qty '||l_total_actual_qty);
2141: END IF;
2142: x_return_status := fnd_api.g_ret_sts_success;
2143: EXCEPTION

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

2136:
2137: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2138: gme_debug.put_line('Qtys being returned are:');
2139: gme_debug.put_line('Total plan qty '||l_total_plan_qty);
2140: gme_debug.put_line('Total actual qty '||l_total_actual_qty);
2141: END IF;
2142: x_return_status := fnd_api.g_ret_sts_success;
2143: EXCEPTION
2144: WHEN uom_conversion_failure THEN

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

2179: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
2180: l_ret boolean;
2181: l_api_name VARCHAR2 (50) := 'check_inv_negative';
2182: BEGIN
2183: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
2184: gme_debug.g_log_procedure THEN
2185: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2186: END IF;
2187: -- Initially let us assign the return status to success

Line 2184: gme_debug.g_log_procedure THEN

2180: l_ret boolean;
2181: l_api_name VARCHAR2 (50) := 'check_inv_negative';
2182: BEGIN
2183: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
2184: gme_debug.g_log_procedure THEN
2185: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2186: END IF;
2187: -- Initially let us assign the return status to success
2188: x_return_status := fnd_api.g_ret_sts_success;

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

2181: l_api_name VARCHAR2 (50) := 'check_inv_negative';
2182: BEGIN
2183: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
2184: gme_debug.g_log_procedure THEN
2185: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2186: END IF;
2187: -- Initially let us assign the return status to success
2188: x_return_status := fnd_api.g_ret_sts_success;
2189:

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

2212: ( x_count => x_msg_count
2213: ,p_encoded => fnd_api.g_false
2214: ,x_data => x_msg_data);
2215:
2216: IF (g_debug <= gme_debug.g_log_statement) THEN
2217: gme_debug.put_line ( g_pkg_name
2218: || '.'
2219: || l_api_name
2220: || ':'

Line 2217: gme_debug.put_line ( g_pkg_name

2213: ,p_encoded => fnd_api.g_false
2214: ,x_data => x_msg_data);
2215:
2216: IF (g_debug <= gme_debug.g_log_statement) THEN
2217: gme_debug.put_line ( g_pkg_name
2218: || '.'
2219: || l_api_name
2220: || ':'
2221: || 'Exiting with '

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

2242: gme_common_pvt.count_and_get
2243: ( x_count => x_msg_count
2244: ,p_encoded => fnd_api.g_false
2245: ,x_data => x_msg_data);
2246: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2247: gme_debug.put_line ( g_pkg_name
2248: || '.'
2249: || l_api_name
2250: || ':'

Line 2247: gme_debug.put_line ( g_pkg_name

2243: ( x_count => x_msg_count
2244: ,p_encoded => fnd_api.g_false
2245: ,x_data => x_msg_data);
2246: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2247: gme_debug.put_line ( g_pkg_name
2248: || '.'
2249: || l_api_name
2250: || ':'
2251: || 'WHEN OTHERS:'

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

2289:
2290: BEGIN
2291: --Take the value of the profile,GME: Ingredient Substitution Date
2292: l_ingred_sub_date := gme_common_pvt.g_ingr_sub_date;
2293: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2294: gme_debug.put_line ( g_pkg_name
2295: || '.'
2296: || l_api_name
2297: || ':'

Line 2294: gme_debug.put_line ( g_pkg_name

2290: BEGIN
2291: --Take the value of the profile,GME: Ingredient Substitution Date
2292: l_ingred_sub_date := gme_common_pvt.g_ingr_sub_date;
2293: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2294: gme_debug.put_line ( g_pkg_name
2295: || '.'
2296: || l_api_name
2297: || ':'
2298: || 'l_ingred_sub_date : '

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

2302: IF l_ingred_sub_date = 2 THEN -- Ingredient Requirement Date
2303: OPEN cur_get_matl_requirement_dt (p_material_detail_id);
2304: FETCH cur_get_matl_requirement_dt INTO l_matl_requirement_dt;
2305: CLOSE cur_get_matl_requirement_dt;
2306: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2307: gme_debug.put_line ( g_pkg_name
2308: || '.'
2309: || l_api_name
2310: || ':'

Line 2307: gme_debug.put_line ( g_pkg_name

2303: OPEN cur_get_matl_requirement_dt (p_material_detail_id);
2304: FETCH cur_get_matl_requirement_dt INTO l_matl_requirement_dt;
2305: CLOSE cur_get_matl_requirement_dt;
2306: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2307: gme_debug.put_line ( g_pkg_name
2308: || '.'
2309: || l_api_name
2310: || ':'
2311: || 'l_matl_requirement_dt : '

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

2317: OPEN cur_get_start_end_Date (p_batch_id);
2318: FETCH cur_get_start_end_Date INTO l_plan_start_date,l_plan_cmplt_date;
2319: CLOSE cur_get_start_end_Date;
2320: IF l_ingred_sub_date = 1 THEN -- Batch Start Date
2321: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2322: gme_debug.put_line ( g_pkg_name
2323: || '.'
2324: || l_api_name
2325: || ':'

Line 2322: gme_debug.put_line ( g_pkg_name

2318: FETCH cur_get_start_end_Date INTO l_plan_start_date,l_plan_cmplt_date;
2319: CLOSE cur_get_start_end_Date;
2320: IF l_ingred_sub_date = 1 THEN -- Batch Start Date
2321: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2322: gme_debug.put_line ( g_pkg_name
2323: || '.'
2324: || l_api_name
2325: || ':'
2326: || 'l_ingr_sub_dt = l_plan_start_date : '

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

2327: || TO_CHAR(l_plan_start_date, 'MON-DD-YYYY HH24:MI:SS'));
2328: END IF;
2329: RETURN l_plan_start_date;
2330: ELSIF l_ingred_sub_date = 3 THEN -- Batch Completion Date
2331: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) 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: END IF;
2329: RETURN l_plan_start_date;
2330: ELSIF l_ingred_sub_date = 3 THEN -- Batch Completion Date
2331: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2332: gme_debug.put_line ( g_pkg_name
2333: || '.'
2334: || l_api_name
2335: || ':'
2336: || 'l_ingr_sub_dt = l_plan_cmplt_date : '

Line 2353: IF g_debug <= gme_debug.g_log_procedure THEN

2349: x_resvns_cur OUT NOCOPY g_gmo_resvns,
2350: x_return_status OUT NOCOPY VARCHAR2) IS
2351: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_resvns';
2352: BEGIN
2353: IF g_debug <= gme_debug.g_log_procedure THEN
2354: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2355: END IF;
2356: x_return_status := FND_API.G_RET_STS_SUCCESS;
2357: OPEN x_resvns_cur FOR

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

2350: x_return_status OUT NOCOPY VARCHAR2) IS
2351: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_resvns';
2352: BEGIN
2353: IF g_debug <= gme_debug.g_log_procedure THEN
2354: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2355: END IF;
2356: x_return_status := FND_API.G_RET_STS_SUCCESS;
2357: OPEN x_resvns_cur FOR
2358: SELECT mr.*

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

2369: EXCEPTION
2370: WHEN OTHERS THEN
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2373: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2374: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2375: END IF;
2376: END get_mat_resvns;
2377:

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

2370: WHEN OTHERS THEN
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2373: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2374: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2375: END IF;
2376: END get_mat_resvns;
2377:
2378: PROCEDURE get_mat_pplots(p_mat_det_id IN NUMBER,

Line 2383: IF g_debug <= gme_debug.g_log_procedure THEN

2379: x_pplot_cur OUT NOCOPY g_gmo_pplots,
2380: x_return_status OUT NOCOPY VARCHAR2) IS
2381: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_pplots';
2382: BEGIN
2383: IF g_debug <= gme_debug.g_log_procedure THEN
2384: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2385: END IF;
2386: x_return_status := FND_API.G_RET_STS_SUCCESS;
2387: OPEN x_pplot_cur FOR

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

2380: x_return_status OUT NOCOPY VARCHAR2) IS
2381: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_pplots';
2382: BEGIN
2383: IF g_debug <= gme_debug.g_log_procedure THEN
2384: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2385: END IF;
2386: x_return_status := FND_API.G_RET_STS_SUCCESS;
2387: OPEN x_pplot_cur FOR
2388: SELECT *

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

2392: EXCEPTION
2393: WHEN OTHERS THEN
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2396: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2397: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2398: END IF;
2399: END get_mat_pplots;
2400:

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

2393: WHEN OTHERS THEN
2394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2395: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2396: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2397: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2398: END IF;
2399: END get_mat_pplots;
2400:
2401: PROCEDURE get_mat_trans(p_organization_id IN NUMBER,

Line 2408: IF g_debug <= gme_debug.g_log_procedure THEN

2404: x_txns_cur OUT NOCOPY g_gmo_txns,
2405: x_return_status OUT NOCOPY VARCHAR2) IS
2406: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_trans';
2407: BEGIN
2408: IF g_debug <= gme_debug.g_log_procedure THEN
2409: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2410: END IF;
2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412: OPEN x_txns_cur FOR

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

2405: x_return_status OUT NOCOPY VARCHAR2) IS
2406: l_api_name CONSTANT VARCHAR2 (30) := 'get_mat_trans';
2407: BEGIN
2408: IF g_debug <= gme_debug.g_log_procedure THEN
2409: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2410: END IF;
2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412: OPEN x_txns_cur FOR
2413: SELECT *

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

2424: EXCEPTION
2425: WHEN OTHERS THEN
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2428: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2429: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2430: END IF;
2431: END get_mat_trans;
2432:

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

2425: WHEN OTHERS THEN
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2428: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2429: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2430: END IF;
2431: END get_mat_trans;
2432:
2433: PROCEDURE get_lot_trans(p_transaction_id IN NUMBER,

Line 2438: IF g_debug <= gme_debug.g_log_procedure THEN

2434: x_lot_txns_cur OUT NOCOPY g_gmo_lot_txns,
2435: x_return_status OUT NOCOPY VARCHAR2) IS
2436: l_api_name CONSTANT VARCHAR2 (30) := 'get_lot_trans';
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_lot_txns_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_lot_trans';
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_lot_txns_cur FOR
2443: SELECT *

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

2446: EXCEPTION
2447: WHEN OTHERS THEN
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2449: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2450: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2451: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2452: END IF;
2453: END get_lot_trans;
2454:

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

2447: WHEN OTHERS THEN
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2449: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2450: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2451: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2452: END IF;
2453: END get_lot_trans;
2454:
2455: PROCEDURE create_material_txn(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,

Line 2464: IF g_debug <= gme_debug.g_log_procedure THEN

2460: setup_failed EXCEPTION;
2461: create_txn_fail EXCEPTION;
2462: validate_txn_fail EXCEPTION;
2463: BEGIN
2464: IF g_debug <= gme_debug.g_log_procedure THEN
2465: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2466: END IF;
2467: x_return_status := FND_API.G_RET_STS_SUCCESS;
2468: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2461: create_txn_fail EXCEPTION;
2462: validate_txn_fail EXCEPTION;
2463: BEGIN
2464: IF g_debug <= gme_debug.g_log_procedure THEN
2465: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2466: END IF;
2467: x_return_status := FND_API.G_RET_STS_SUCCESS;
2468: IF NOT(gme_common_pvt.g_setup_done) THEN
2469: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_mmti_rec.organization_id);

Line 2490: IF g_debug <= gme_debug.g_log_procedure THEN

2486: x_return_status => l_return_status);
2487: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2488: RAISE create_txn_fail;
2489: END IF;
2490: IF g_debug <= gme_debug.g_log_procedure THEN
2491: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2492: END IF;
2493: EXCEPTION
2494: WHEN setup_failed THEN

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

2487: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2488: RAISE create_txn_fail;
2489: END IF;
2490: IF g_debug <= gme_debug.g_log_procedure THEN
2491: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2492: END IF;
2493: EXCEPTION
2494: WHEN setup_failed THEN
2495: x_return_status := FND_API.G_RET_STS_ERROR;

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

2497: x_return_status := l_return_status;
2498: WHEN OTHERS THEN
2499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2500: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2501: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2502: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2503: END IF;
2504: END create_material_txn;
2505:

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

2498: WHEN OTHERS THEN
2499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2500: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2501: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2502: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2503: END IF;
2504: END create_material_txn;
2505:
2506: PROCEDURE update_material_txn(p_transaction_id IN NUMBER,

Line 2525: IF g_debug <= gme_debug.g_log_procedure THEN

2521: update_txn_fail EXCEPTION;
2522: validate_txn_fail EXCEPTION;
2523: update_txn_mismatch EXCEPTION;
2524: BEGIN
2525: IF g_debug <= gme_debug.g_log_procedure THEN
2526: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2527: END IF;
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2522: validate_txn_fail EXCEPTION;
2523: update_txn_mismatch EXCEPTION;
2524: BEGIN
2525: IF g_debug <= gme_debug.g_log_procedure THEN
2526: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2527: END IF;
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529: IF NOT(gme_common_pvt.g_setup_done) THEN
2530: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_mmti_rec.organization_id);

Line 2561: IF g_debug <= gme_debug.g_log_procedure THEN

2557: x_return_status => l_return_status);
2558: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2559: RAISE update_txn_fail;
2560: END IF;
2561: IF g_debug <= gme_debug.g_log_procedure THEN
2562: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2563: END IF;
2564: EXCEPTION
2565: WHEN setup_failed THEN

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

2558: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2559: RAISE update_txn_fail;
2560: END IF;
2561: IF g_debug <= gme_debug.g_log_procedure THEN
2562: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2563: END IF;
2564: EXCEPTION
2565: WHEN setup_failed THEN
2566: x_return_status := FND_API.G_RET_STS_ERROR;

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

2571: x_return_status := l_return_status;
2572: WHEN OTHERS THEN
2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2574: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2575: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2576: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2577: END IF;
2578: END update_material_txn;
2579:

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

2572: WHEN OTHERS THEN
2573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2574: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2575: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2576: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2577: END IF;
2578: END update_material_txn;
2579:
2580: PROCEDURE delete_material_txn(p_organization_id IN NUMBER,

Line 2595: IF g_debug <= gme_debug.g_log_procedure THEN

2591: get_txn_fail EXCEPTION;
2592: const_txn_fail EXCEPTION;
2593: validate_txn_fail EXCEPTION;
2594: BEGIN
2595: IF g_debug <= gme_debug.g_log_procedure THEN
2596: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2597: END IF;
2598: x_return_status := FND_API.G_RET_STS_SUCCESS;
2599: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2592: const_txn_fail EXCEPTION;
2593: validate_txn_fail EXCEPTION;
2594: BEGIN
2595: IF g_debug <= gme_debug.g_log_procedure THEN
2596: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2597: END IF;
2598: x_return_status := FND_API.G_RET_STS_SUCCESS;
2599: IF NOT(gme_common_pvt.g_setup_done) THEN
2600: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_organization_id);

Line 2635: IF g_debug <= gme_debug.g_log_procedure THEN

2631: x_return_status => l_return_status);
2632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2633: RAISE delete_txn_fail;
2634: END IF;
2635: IF g_debug <= gme_debug.g_log_procedure THEN
2636: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2637: END IF;
2638: EXCEPTION
2639: WHEN setup_failed THEN

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

2632: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2633: RAISE delete_txn_fail;
2634: END IF;
2635: IF g_debug <= gme_debug.g_log_procedure THEN
2636: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2637: END IF;
2638: EXCEPTION
2639: WHEN setup_failed THEN
2640: x_return_status := FND_API.G_RET_STS_ERROR;

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

2642: x_return_status := l_return_status;
2643: WHEN OTHERS THEN
2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2645: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2646: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2647: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2648: END IF;
2649: END delete_material_txn;
2650:

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

2643: WHEN OTHERS THEN
2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2645: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2646: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2647: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2648: END IF;
2649: END delete_material_txn;
2650:
2651: PROCEDURE create_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

Line 2678: IF g_debug <= gme_debug.g_log_procedure THEN

2674: rsrc_update_err EXCEPTION;
2675: reduce_pend_usage_err EXCEPTION;
2676: error_load_trans EXCEPTION;
2677: BEGIN
2678: IF g_debug <= gme_debug.g_log_procedure THEN
2679: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2680: END IF;
2681: x_return_status := FND_API.G_RET_STS_SUCCESS;
2682: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2675: reduce_pend_usage_err EXCEPTION;
2676: error_load_trans EXCEPTION;
2677: BEGIN
2678: IF g_debug <= gme_debug.g_log_procedure THEN
2679: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2680: END IF;
2681: x_return_status := FND_API.G_RET_STS_SUCCESS;
2682: IF NOT(gme_common_pvt.g_setup_done) THEN
2683: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_rsrc_txn_gtmp_rec.organization_id);

Line 2762: IF g_debug <= gme_debug.g_log_procedure THEN

2758: END IF;
2759: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2760: RAISE rsrc_update_err;
2761: END IF;
2762: IF g_debug <= gme_debug.g_log_procedure THEN
2763: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2764: END IF;
2765: EXCEPTION
2766: WHEN setup_failed OR uom_conversion_err OR missing_profile_option OR rsrc_fetch_err OR rsrc_update_err THEN

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

2759: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2760: RAISE rsrc_update_err;
2761: END IF;
2762: IF g_debug <= gme_debug.g_log_procedure THEN
2763: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2764: END IF;
2765: EXCEPTION
2766: WHEN setup_failed OR uom_conversion_err OR missing_profile_option OR rsrc_fetch_err OR rsrc_update_err THEN
2767: x_return_status := FND_API.G_RET_STS_ERROR;

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

2769: x_return_status := l_return_status;
2770: WHEN OTHERS THEN
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2773: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2774: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2775: END IF;
2776: END create_resource_txn;
2777:

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

2770: WHEN OTHERS THEN
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2773: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2774: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2775: END IF;
2776: END create_resource_txn;
2777:
2778: PROCEDURE update_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

Line 2800: IF g_debug <= gme_debug.g_log_procedure THEN

2796: upd_rsrc_err EXCEPTION;
2797: get_usage_fail EXCEPTION;
2798: reduce_pend_usage_err EXCEPTION;
2799: BEGIN
2800: IF g_debug <= gme_debug.g_log_procedure THEN
2801: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2802: END IF;
2803: x_return_status := FND_API.G_RET_STS_SUCCESS;
2804: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2797: get_usage_fail EXCEPTION;
2798: reduce_pend_usage_err EXCEPTION;
2799: BEGIN
2800: IF g_debug <= gme_debug.g_log_procedure THEN
2801: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2802: END IF;
2803: x_return_status := FND_API.G_RET_STS_SUCCESS;
2804: IF NOT(gme_common_pvt.g_setup_done) THEN
2805: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_rsrc_txn_gtmp_rec.organization_id);

Line 2861: IF g_debug <= gme_debug.g_log_procedure THEN

2857: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2858: RAISE upd_rsrc_err;
2859: END IF;
2860: END IF;
2861: IF g_debug <= gme_debug.g_log_procedure THEN
2862: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2863: END IF;
2864: EXCEPTION
2865: WHEN setup_failed OR error_load_trans OR rsrc_fetch_err OR get_usage_fail OR upd_rsrc_err THEN

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

2858: RAISE upd_rsrc_err;
2859: END IF;
2860: END IF;
2861: IF g_debug <= gme_debug.g_log_procedure THEN
2862: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2863: END IF;
2864: EXCEPTION
2865: WHEN setup_failed OR error_load_trans OR rsrc_fetch_err OR get_usage_fail OR upd_rsrc_err THEN
2866: x_return_status := FND_API.G_RET_STS_ERROR;

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

2868: x_return_status := l_return_status;
2869: WHEN OTHERS THEN
2870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2871: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2872: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2873: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2874: END IF;
2875: END update_resource_txn;
2876:

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

2869: WHEN OTHERS THEN
2870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2871: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2872: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2873: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2874: END IF;
2875: END update_resource_txn;
2876:
2877: PROCEDURE delete_resource_txn(p_rsrc_txn_gtmp_rec IN gme_resource_txns_gtmp%ROWTYPE,

Line 2902: IF g_debug <= gme_debug.g_log_procedure THEN

2898: upd_rsrc_err EXCEPTION;
2899: get_usage_fail EXCEPTION;
2900: reduce_pend_usage_err EXCEPTION;
2901: BEGIN
2902: IF g_debug <= gme_debug.g_log_procedure THEN
2903: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2904: END IF;
2905: x_return_status := FND_API.G_RET_STS_SUCCESS;
2906: IF NOT(gme_common_pvt.g_setup_done) THEN

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

2899: get_usage_fail EXCEPTION;
2900: reduce_pend_usage_err EXCEPTION;
2901: BEGIN
2902: IF g_debug <= gme_debug.g_log_procedure THEN
2903: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
2904: END IF;
2905: x_return_status := FND_API.G_RET_STS_SUCCESS;
2906: IF NOT(gme_common_pvt.g_setup_done) THEN
2907: gme_common_pvt.g_setup_done := gme_common_pvt.setup(p_org_id => p_rsrc_txn_gtmp_rec.organization_id);

Line 2956: IF g_debug <= gme_debug.g_log_procedure THEN

2952: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2953: RAISE upd_rsrc_err;
2954: END IF;
2955: END IF;
2956: IF g_debug <= gme_debug.g_log_procedure THEN
2957: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2958: END IF;
2959: EXCEPTION
2960: WHEN setup_failed OR fetch_txn_failed OR validation_fail OR rsrc_fetch_err OR upd_rsrc_err THEN

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

2953: RAISE upd_rsrc_err;
2954: END IF;
2955: END IF;
2956: IF g_debug <= gme_debug.g_log_procedure THEN
2957: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2958: END IF;
2959: EXCEPTION
2960: WHEN setup_failed OR fetch_txn_failed OR validation_fail OR rsrc_fetch_err OR upd_rsrc_err THEN
2961: x_return_status := FND_API.G_RET_STS_ERROR;

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

2963: x_return_status := l_return_status;
2964: WHEN OTHERS THEN
2965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2966: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2967: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2968: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2969: END IF;
2970: END delete_resource_txn;
2971: END gme_api_grp;

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

2964: WHEN OTHERS THEN
2965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2966: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2967: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2968: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
2969: END IF;
2970: END delete_resource_txn;
2971: END gme_api_grp;