APPS.GME_SUPPLY_RES_PVT dependencies on GME_DEBUG

Line 148: IF g_debug <= gme_debug.g_log_procedure THEN

144: where batch_id = p_batch_id;
145:
146: BEGIN
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line ('Entering api '
150: || g_pkg_name || '.'
151: || l_api_name);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FPO batch_id '||p_fpo_batch_id);

Line 149: gme_debug.put_line ('Entering api '

145:
146: BEGIN
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line ('Entering api '
150: || g_pkg_name || '.'
151: || l_api_name);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FPO batch_id '||p_fpo_batch_id);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' BATCH batch_id '||p_new_batch_id);

Line 152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FPO batch_id '||p_fpo_batch_id);

148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line ('Entering api '
150: || g_pkg_name || '.'
151: || l_api_name);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FPO batch_id '||p_fpo_batch_id);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' BATCH batch_id '||p_new_batch_id);
154: END IF;
155:
156: /* loop through all the product lines in the batch */

Line 153: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' BATCH batch_id '||p_new_batch_id);

149: gme_debug.put_line ('Entering api '
150: || g_pkg_name || '.'
151: || l_api_name);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' FPO batch_id '||p_fpo_batch_id);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' BATCH batch_id '||p_new_batch_id);
154: END IF;
155:
156: /* loop through all the product lines in the batch */
157: For batch_line in get_batch_line(p_FPO_batch_id) Loop

Line 161: IF g_debug <= gme_debug.g_log_procedure THEN

157: For batch_line in get_batch_line(p_FPO_batch_id) Loop
158: l_fpo_batch_line_id := batch_line.material_detail_id ;
159: l_inventory_item_id := batch_line.inventory_item_id ;
160: l_fpo_qty := batch_line.plan_qty;
161: IF g_debug <= gme_debug.g_log_procedure THEN
162: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ' FPO batch_line_id '||l_fpo_batch_line_id);
163: END IF;
164: /* check reservation exist or not */
165: Open get_res_count(l_FPO_batch_line_id);

Line 162: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ' FPO batch_line_id '||l_fpo_batch_line_id);

158: l_fpo_batch_line_id := batch_line.material_detail_id ;
159: l_inventory_item_id := batch_line.inventory_item_id ;
160: l_fpo_qty := batch_line.plan_qty;
161: IF g_debug <= gme_debug.g_log_procedure THEN
162: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ' FPO batch_line_id '||l_fpo_batch_line_id);
163: END IF;
164: /* check reservation exist or not */
165: Open get_res_count(l_FPO_batch_line_id);
166: Fetch get_res_count into l_res_count;

Line 169: IF g_debug <= gme_debug.g_log_procedure THEN

165: Open get_res_count(l_FPO_batch_line_id);
166: Fetch get_res_count into l_res_count;
167: Close get_res_count;
168:
169: IF g_debug <= gme_debug.g_log_procedure THEN
170: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||' FPO reservation cound '||l_res_count);
171: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' NEW batch_line_id '||l_batch_line_id);
172: END IF;
173:

Line 170: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||' FPO reservation cound '||l_res_count);

166: Fetch get_res_count into l_res_count;
167: Close get_res_count;
168:
169: IF g_debug <= gme_debug.g_log_procedure THEN
170: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||' FPO reservation cound '||l_res_count);
171: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' NEW batch_line_id '||l_batch_line_id);
172: END IF;
173:
174: IF l_res_count = 0 THEN

Line 171: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' NEW batch_line_id '||l_batch_line_id);

167: Close get_res_count;
168:
169: IF g_debug <= gme_debug.g_log_procedure THEN
170: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||' FPO reservation cound '||l_res_count);
171: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' NEW batch_line_id '||l_batch_line_id);
172: END IF;
173:
174: IF l_res_count = 0 THEN
175: goto next_batch_line;

Line 187: IF g_debug <= gme_debug.g_log_procedure THEN

183: /* loop to see if different whse may have exist -- only one org in R12*/
184: For each_whse in check_whse(l_fpo_batch_line_id) Loop
185: l_organization_id := each_whse.organization_id;
186:
187: IF g_debug <= gme_debug.g_log_procedure THEN
188: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' reservation org id '||l_organization_id);
189: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' batch inventory_item_id '||l_inventory_item_id);
190: END IF;
191:

Line 188: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' reservation org id '||l_organization_id);

184: For each_whse in check_whse(l_fpo_batch_line_id) Loop
185: l_organization_id := each_whse.organization_id;
186:
187: IF g_debug <= gme_debug.g_log_procedure THEN
188: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' reservation org id '||l_organization_id);
189: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' batch inventory_item_id '||l_inventory_item_id);
190: END IF;
191:
192: Open get_new_batch_cmpt_date (p_new_batch_id) ;

Line 189: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' batch inventory_item_id '||l_inventory_item_id);

185: l_organization_id := each_whse.organization_id;
186:
187: IF g_debug <= gme_debug.g_log_procedure THEN
188: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' reservation org id '||l_organization_id);
189: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' batch inventory_item_id '||l_inventory_item_id);
190: END IF;
191:
192: Open get_new_batch_cmpt_date (p_new_batch_id) ;
193: Fetch get_new_batch_cmpt_date Into l_plan_cmplt_date;

Line 221: IF g_debug <= gme_debug.g_log_procedure THEN

217: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:
221: IF g_debug <= gme_debug.g_log_procedure THEN
222: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' fpo reservation count '||l_fpo_rsv_count);
223: END IF;
224:
225: l_remaining_qty := l_planned_qty;

Line 222: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' fpo reservation count '||l_fpo_rsv_count);

218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:
221: IF g_debug <= gme_debug.g_log_procedure THEN
222: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' fpo reservation count '||l_fpo_rsv_count);
223: END IF;
224:
225: l_remaining_qty := l_planned_qty;
226: for i in 1..l_fpo_rsv_count Loop

Line 231: IF g_debug <= gme_debug.g_log_procedure THEN

227: l_fpo_rsv_rec := l_fpo_rsv_tbl(i);
228: /* check the batch planned cplt date with the scheduled_ship_date
229: * if the date is out, skip this record
230: */
231: IF g_debug <= gme_debug.g_log_procedure THEN
232: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' build res record for the new batch');
233: END IF;
234: /*IF l_fpo_rsv_rec.requirement_date> l_plan_cmplt_date THEN
235: Goto next_res_line;

Line 232: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' build res record for the new batch');

228: /* check the batch planned cplt date with the scheduled_ship_date
229: * if the date is out, skip this record
230: */
231: IF g_debug <= gme_debug.g_log_procedure THEN
232: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' build res record for the new batch');
233: END IF;
234: /*IF l_fpo_rsv_rec.requirement_date> l_plan_cmplt_date THEN
235: Goto next_res_line;
236: END IF;

Line 285: IF g_debug <= gme_debug.g_log_procedure THEN

281: , from_name => NULL
282: , to_name => NULL);
283: end if;
284:
285: IF g_debug <= gme_debug.g_log_procedure THEN
286: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty '||l_reserved_qty);
287: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty2 '||l_reserved_qty2);
288: END IF;
289:

Line 286: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty '||l_reserved_qty);

282: , to_name => NULL);
283: end if;
284:
285: IF g_debug <= gme_debug.g_log_procedure THEN
286: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty '||l_reserved_qty);
287: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty2 '||l_reserved_qty2);
288: END IF;
289:
290: inv_reservation_pub.transfer_reservation

Line 287: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty2 '||l_reserved_qty2);

283: end if;
284:
285: IF g_debug <= gme_debug.g_log_procedure THEN
286: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty '||l_reserved_qty);
287: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty2 '||l_reserved_qty2);
288: END IF;
289:
290: inv_reservation_pub.transfer_reservation
291: (p_api_version_number => 1.0,

Line 334: IF g_debug <= gme_debug.g_log_procedure THEN

330: FND_MSG_PUB.count_and_get
331: ( p_count => x_msg_count
332: , p_data => x_msg_data
333: );
334: IF g_debug <= gme_debug.g_log_procedure THEN
335: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'u EXCEPTION: Expected');
336: END IF;
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 335: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'u EXCEPTION: Expected');

331: ( p_count => x_msg_count
332: , p_data => x_msg_data
333: );
334: IF g_debug <= gme_debug.g_log_procedure THEN
335: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'u EXCEPTION: Expected');
336: END IF;
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:

Line 348: IF g_debug <= gme_debug.g_log_procedure THEN

344: FND_MSG_PUB.count_and_get
345: ( p_count => x_msg_count
346: , p_data => x_msg_data
347: );
348: IF g_debug <= gme_debug.g_log_procedure THEN
349: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'u EXCEPTION: Others');
350: END IF;
351:
352: END create_reservation_from_FPO;

Line 349: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'u EXCEPTION: Others');

345: ( p_count => x_msg_count
346: , p_data => x_msg_data
347: );
348: IF g_debug <= gme_debug.g_log_procedure THEN
349: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'u EXCEPTION: Others');
350: END IF;
351:
352: END create_reservation_from_FPO;
353:

Line 483: IF g_debug <= gme_debug.g_log_procedure THEN

479: BEGIN
480:
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: IF g_debug <= gme_debug.g_log_procedure THEN
484: gme_debug.put_line ('Entering api '
485: || g_pkg_name || '.'
486: || l_api_name);
487: END IF;

Line 484: gme_debug.put_line ('Entering api '

480:
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: IF g_debug <= gme_debug.g_log_procedure THEN
484: gme_debug.put_line ('Entering api '
485: || g_pkg_name || '.'
486: || l_api_name);
487: END IF;
488: l_session_id := USERENV('sessionid');

Line 495: IF g_debug <= gme_debug.g_log_procedure THEN

491: l_organization_id := p_organization_id;
492:
493: /* will send the work flow */
494: IF p_batch_id is not null THEN
495: IF g_debug <= gme_debug.g_log_procedure THEN
496: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Batch_id is'|| p_batch_id);
497: END IF;
498: OPEN so_line_id_for_batch(p_batch_id);
499: FETCH so_line_id_for_batch INTO l_so_line_id;

Line 496: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Batch_id is'|| p_batch_id);

492:
493: /* will send the work flow */
494: IF p_batch_id is not null THEN
495: IF g_debug <= gme_debug.g_log_procedure THEN
496: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Batch_id is'|| p_batch_id);
497: END IF;
498: OPEN so_line_id_for_batch(p_batch_id);
499: FETCH so_line_id_for_batch INTO l_so_line_id;
500: IF(so_line_id_for_batch%NOTFOUND) THEN

Line 502: IF g_debug <= gme_debug.g_log_procedure THEN

498: OPEN so_line_id_for_batch(p_batch_id);
499: FETCH so_line_id_for_batch INTO l_so_line_id;
500: IF(so_line_id_for_batch%NOTFOUND) THEN
501: CLOSE so_line_id_for_batch;
502: IF g_debug <= gme_debug.g_log_procedure THEN
503: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' so_line_id_for_batch%NOTFOUND, returning from Notify CSR');
504: END IF;
505: RETURN;
506: END IF;

Line 503: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' so_line_id_for_batch%NOTFOUND, returning from Notify CSR');

499: FETCH so_line_id_for_batch INTO l_so_line_id;
500: IF(so_line_id_for_batch%NOTFOUND) THEN
501: CLOSE so_line_id_for_batch;
502: IF g_debug <= gme_debug.g_log_procedure THEN
503: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' so_line_id_for_batch%NOTFOUND, returning from Notify CSR');
504: END IF;
505: RETURN;
506: END IF;
507:

Line 514: IF g_debug <= gme_debug.g_log_procedure THEN

510: OPEN get_batch_type(p_batch_id);
511: FETCH get_batch_type INTO l_batch_type;
512: IF(get_batch_type%NOTFOUND) THEN
513: CLOSE get_batch_type;
514: IF g_debug <= gme_debug.g_log_procedure THEN
515: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' get_batch_type%NOTFOUND, returning from Notify CSR');
516: END IF;
517: RETURN;
518: END IF;

Line 515: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' get_batch_type%NOTFOUND, returning from Notify CSR');

511: FETCH get_batch_type INTO l_batch_type;
512: IF(get_batch_type%NOTFOUND) THEN
513: CLOSE get_batch_type;
514: IF g_debug <= gme_debug.g_log_procedure THEN
515: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' get_batch_type%NOTFOUND, returning from Notify CSR');
516: END IF;
517: RETURN;
518: END IF;
519:

Line 525: IF g_debug <= gme_debug.g_log_procedure THEN

521:
522: END IF;
523:
524: IF p_batch_line_id is not null THEN
525: IF g_debug <= gme_debug.g_log_procedure THEN
526: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Batch_line_id is '|| p_batch_line_id);
527: END IF;
528: OPEN so_line_id_for_batch_line(p_batch_line_id);
529: FETCH so_line_id_for_batch_line INTO l_so_line_id;

Line 526: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Batch_line_id is '|| p_batch_line_id);

522: END IF;
523:
524: IF p_batch_line_id is not null THEN
525: IF g_debug <= gme_debug.g_log_procedure THEN
526: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Batch_line_id is '|| p_batch_line_id);
527: END IF;
528: OPEN so_line_id_for_batch_line(p_batch_line_id);
529: FETCH so_line_id_for_batch_line INTO l_so_line_id;
530: IF(so_line_id_for_batch_line%NOTFOUND) THEN

Line 532: IF g_debug <= gme_debug.g_log_procedure THEN

528: OPEN so_line_id_for_batch_line(p_batch_line_id);
529: FETCH so_line_id_for_batch_line INTO l_so_line_id;
530: IF(so_line_id_for_batch_line%NOTFOUND) THEN
531: CLOSE so_line_id_for_batch_line;
532: IF g_debug <= gme_debug.g_log_procedure THEN
533: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' so_line_id_for_batch_line%NOTFOUND, returning from Notify CSR');
534: END IF;
535: RETURN;
536: END IF;

Line 533: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' so_line_id_for_batch_line%NOTFOUND, returning from Notify CSR');

529: FETCH so_line_id_for_batch_line INTO l_so_line_id;
530: IF(so_line_id_for_batch_line%NOTFOUND) THEN
531: CLOSE so_line_id_for_batch_line;
532: IF g_debug <= gme_debug.g_log_procedure THEN
533: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' so_line_id_for_batch_line%NOTFOUND, returning from Notify CSR');
534: END IF;
535: RETURN;
536: END IF;
537: CLOSE so_line_id_for_batch_line;

Line 543: IF g_debug <= gme_debug.g_log_procedure THEN

539: OPEN get_batch_id_for_line(p_batch_line_id);
540: FETCH get_batch_id_for_line INTO l_batch_id,l_batch_type;
541: IF(get_batch_id_for_line%NOTFOUND) THEN
542: CLOSE get_batch_id_for_line;
543: IF g_debug <= gme_debug.g_log_procedure THEN
544: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' get_batch_id_for_line%NOTFOUND, returning from Notify CSR');
545: END IF;
546: RETURN;
547: END IF;

Line 544: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' get_batch_id_for_line%NOTFOUND, returning from Notify CSR');

540: FETCH get_batch_id_for_line INTO l_batch_id,l_batch_type;
541: IF(get_batch_id_for_line%NOTFOUND) THEN
542: CLOSE get_batch_id_for_line;
543: IF g_debug <= gme_debug.g_log_procedure THEN
544: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' get_batch_id_for_line%NOTFOUND, returning from Notify CSR');
545: END IF;
546: RETURN;
547: END IF;
548: CLOSE get_batch_id_for_line;

Line 552: IF g_debug <= gme_debug.g_log_procedure THEN

548: CLOSE get_batch_id_for_line;
549:
550: END IF;
551:
552: IF g_debug <= gme_debug.g_log_procedure THEN
553: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : so_line_id is'|| l_so_line_id);
554: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_organization_id is'|| l_organization_id);
555: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_action_code is'|| p_action_code);
556: END IF;

Line 553: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : so_line_id is'|| l_so_line_id);

549:
550: END IF;
551:
552: IF g_debug <= gme_debug.g_log_procedure THEN
553: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : so_line_id is'|| l_so_line_id);
554: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_organization_id is'|| l_organization_id);
555: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_action_code is'|| p_action_code);
556: END IF;
557:

Line 554: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_organization_id is'|| l_organization_id);

550: END IF;
551:
552: IF g_debug <= gme_debug.g_log_procedure THEN
553: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : so_line_id is'|| l_so_line_id);
554: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_organization_id is'|| l_organization_id);
555: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_action_code is'|| p_action_code);
556: END IF;
557:
558: l_action_code := p_action_code;

Line 555: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_action_code is'|| p_action_code);

551:
552: IF g_debug <= gme_debug.g_log_procedure THEN
553: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : so_line_id is'|| l_so_line_id);
554: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_organization_id is'|| l_organization_id);
555: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : p_action_code is'|| p_action_code);
556: END IF;
557:
558: l_action_code := p_action_code;
559:

Line 573: IF g_debug <= gme_debug.g_log_procedure THEN

569: IF(p_action_code = 'CMPLT_DATE_CHANGE') THEN
570: l_action_code := 'PLAN_COMPL_DATE_CHANGED';
571: END IF;
572:
573: IF g_debug <= gme_debug.g_log_procedure THEN
574: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_action_code is'|| l_action_code);
575: END IF;
576:
577: OPEN CSR_for_so_line(l_so_line_id);

Line 574: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_action_code is'|| l_action_code);

570: l_action_code := 'PLAN_COMPL_DATE_CHANGED';
571: END IF;
572:
573: IF g_debug <= gme_debug.g_log_procedure THEN
574: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_action_code is'|| l_action_code);
575: END IF;
576:
577: OPEN CSR_for_so_line(l_so_line_id);
578: FETCH CSR_for_so_line INTO l_last_updated_by,l_created_by, l_so_header_id;

Line 581: IF g_debug <= gme_debug.g_log_procedure THEN

577: OPEN CSR_for_so_line(l_so_line_id);
578: FETCH CSR_for_so_line INTO l_last_updated_by,l_created_by, l_so_header_id;
579: IF(CSR_for_so_line%NOTFOUND) THEN
580: CLOSE CSR_for_so_line;
581: IF g_debug <= gme_debug.g_log_procedure THEN
582: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||' CSR_for_so_line%NOTFOUND, returning from Notify CSR');
583: END IF;
584: RETURN;
585: END IF;

Line 582: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||' CSR_for_so_line%NOTFOUND, returning from Notify CSR');

578: FETCH CSR_for_so_line INTO l_last_updated_by,l_created_by, l_so_header_id;
579: IF(CSR_for_so_line%NOTFOUND) THEN
580: CLOSE CSR_for_so_line;
581: IF g_debug <= gme_debug.g_log_procedure THEN
582: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||' CSR_for_so_line%NOTFOUND, returning from Notify CSR');
583: END IF;
584: RETURN;
585: END IF;
586: CLOSE CSR_for_so_line;

Line 587: IF g_debug <= gme_debug.g_log_procedure THEN

583: END IF;
584: RETURN;
585: END IF;
586: CLOSE CSR_for_so_line;
587: IF g_debug <= gme_debug.g_log_procedure THEN
588: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_last_updated_by is '||l_last_updated_by);
589: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Business Event......');
590: END IF;
591:

Line 588: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_last_updated_by is '||l_last_updated_by);

584: RETURN;
585: END IF;
586: CLOSE CSR_for_so_line;
587: IF g_debug <= gme_debug.g_log_procedure THEN
588: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_last_updated_by is '||l_last_updated_by);
589: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Business Event......');
590: END IF;
591:
592: -- MakeToOrder BEGIN

Line 589: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Business Event......');

585: END IF;
586: CLOSE CSR_for_so_line;
587: IF g_debug <= gme_debug.g_log_procedure THEN
588: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_last_updated_by is '||l_last_updated_by);
589: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Business Event......');
590: END IF;
591:
592: -- MakeToOrder BEGIN
593: IF p_action_code = 'NEW_BATCH_CREATED' THEN

Line 594: IF g_debug <= gme_debug.g_log_procedure THEN

590: END IF;
591:
592: -- MakeToOrder BEGIN
593: IF p_action_code = 'NEW_BATCH_CREATED' THEN
594: IF g_debug <= gme_debug.g_log_procedure THEN
595: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Retrieve any pending lot for line '||p_batch_line_id);
596: END IF;
597: OPEN Get_pending_lot(p_batch_id ,p_batch_line_id );
598: FETCH Get_pending_lot INTO l_lot_number;

Line 595: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Retrieve any pending lot for line '||p_batch_line_id);

591:
592: -- MakeToOrder BEGIN
593: IF p_action_code = 'NEW_BATCH_CREATED' THEN
594: IF g_debug <= gme_debug.g_log_procedure THEN
595: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Retrieve any pending lot for line '||p_batch_line_id);
596: END IF;
597: OPEN Get_pending_lot(p_batch_id ,p_batch_line_id );
598: FETCH Get_pending_lot INTO l_lot_number;
599: IF(Get_pending_lot%NOTFOUND) THEN

Line 600: IF g_debug <= gme_debug.g_log_procedure THEN

596: END IF;
597: OPEN Get_pending_lot(p_batch_id ,p_batch_line_id );
598: FETCH Get_pending_lot INTO l_lot_number;
599: IF(Get_pending_lot%NOTFOUND) THEN
600: IF g_debug <= gme_debug.g_log_procedure THEN
601: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' no pending lot exists for line '|| p_batch_line_id);
602: END IF;
603: END IF;
604:

Line 601: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' no pending lot exists for line '|| p_batch_line_id);

597: OPEN Get_pending_lot(p_batch_id ,p_batch_line_id );
598: FETCH Get_pending_lot INTO l_lot_number;
599: IF(Get_pending_lot%NOTFOUND) THEN
600: IF g_debug <= gme_debug.g_log_procedure THEN
601: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' no pending lot exists for line '|| p_batch_line_id);
602: END IF;
603: END IF;
604:
605: CLOSE Get_pending_lot;

Line 630: IF g_debug <= gme_debug.g_log_procedure THEN

626: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
630: IF g_debug <= gme_debug.g_log_procedure THEN
631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
632: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
633: End if;
634: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

Line 631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');

627: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
630: IF g_debug <= gme_debug.g_log_procedure THEN
631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
632: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
633: End if;
634: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
635: p_event_key => l_session_id,

Line 632: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );

628: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
629: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
630: IF g_debug <= gme_debug.g_log_procedure THEN
631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
632: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
633: End if;
634: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
635: p_event_key => l_session_id,
636: p_parameters => l_parameter_list);

Line 640: IF g_debug <= gme_debug.g_log_procedure THEN

636: p_parameters => l_parameter_list);
637:
638: IF(l_last_updated_by <> l_created_by) THEN
639:
640: IF g_debug <= gme_debug.g_log_procedure THEN
641: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
642: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
643: END IF;
644:

Line 641: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);

637:
638: IF(l_last_updated_by <> l_created_by) THEN
639:
640: IF g_debug <= gme_debug.g_log_procedure THEN
641: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
642: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
643: END IF;
644:
645: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id

Line 642: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');

638: IF(l_last_updated_by <> l_created_by) THEN
639:
640: IF g_debug <= gme_debug.g_log_procedure THEN
641: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
642: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
643: END IF;
644:
645: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
646: , p_approver => l_created_by

Line 675: IF g_debug <= gme_debug.g_log_procedure THEN

671: IF l_new_header_id <> l_old_header_id THEN
672: l_so_header_id := l_new_header_id;
673: l_old_header_id := l_new_header_id;
674:
675: IF g_debug <= gme_debug.g_log_procedure THEN
676: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
677: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
678: END IF;
679: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id

Line 676: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Multiple sales orders, header_id'||l_so_header_id);

672: l_so_header_id := l_new_header_id;
673: l_old_header_id := l_new_header_id;
674:
675: IF g_debug <= gme_debug.g_log_procedure THEN
676: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
677: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
678: END IF;
679: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
680: , p_approver => l_last_updated_by

Line 677: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');

673: l_old_header_id := l_new_header_id;
674:
675: IF g_debug <= gme_debug.g_log_procedure THEN
676: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
677: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
678: END IF;
679: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
680: , p_approver => l_last_updated_by
681: , p_so_header_id=> l_so_header_id

Line 698: IF g_debug <= gme_debug.g_log_procedure THEN

694: p_parameters => l_parameter_list);
695:
696: IF(l_last_updated_by <> l_created_by) THEN
697:
698: IF g_debug <= gme_debug.g_log_procedure THEN
699: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
700: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
701: END IF;
702:

Line 699: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);

695:
696: IF(l_last_updated_by <> l_created_by) THEN
697:
698: IF g_debug <= gme_debug.g_log_procedure THEN
699: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
700: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
701: END IF;
702:
703: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id

Line 700: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');

696: IF(l_last_updated_by <> l_created_by) THEN
697:
698: IF g_debug <= gme_debug.g_log_procedure THEN
699: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
700: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
701: END IF;
702:
703: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
704: , p_approver => l_created_by

Line 731: IF g_debug <= gme_debug.g_log_procedure THEN

727: IF l_new_header_id <> l_old_header_id THEN
728: l_so_header_id := l_new_header_id;
729: l_old_header_id := l_new_header_id;
730:
731: IF g_debug <= gme_debug.g_log_procedure THEN
732: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
733: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
734: END IF;
735: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id

Line 732: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Multiple sales orders, header_id'||l_so_header_id);

728: l_so_header_id := l_new_header_id;
729: l_old_header_id := l_new_header_id;
730:
731: IF g_debug <= gme_debug.g_log_procedure THEN
732: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
733: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
734: END IF;
735: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
736: , p_approver => l_last_updated_by

Line 733: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');

729: l_old_header_id := l_new_header_id;
730:
731: IF g_debug <= gme_debug.g_log_procedure THEN
732: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : Multiple sales orders, header_id'||l_so_header_id);
733: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
734: END IF;
735: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
736: , p_approver => l_last_updated_by
737: , p_so_header_id=> l_so_header_id

Line 754: IF g_debug <= gme_debug.g_log_procedure THEN

750: p_parameters => l_parameter_list);
751:
752: IF(l_last_updated_by <> l_created_by) THEN
753:
754: IF g_debug <= gme_debug.g_log_procedure THEN
755: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
756: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
757: END IF;
758:

Line 755: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);

751:
752: IF(l_last_updated_by <> l_created_by) THEN
753:
754: IF g_debug <= gme_debug.g_log_procedure THEN
755: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
756: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
757: END IF;
758:
759: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id

Line 756: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');

752: IF(l_last_updated_by <> l_created_by) THEN
753:
754: IF g_debug <= gme_debug.g_log_procedure THEN
755: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : l_created_by is '||l_created_by);
756: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Initiating the Workflow......');
757: END IF;
758:
759: /*GME_BATCH_WORKFLOW_PKG.Init_wf( p_session_id => l_session_id
760: , p_approver => l_created_by

Line 780: IF g_debug <= gme_debug.g_log_procedure THEN

776: END IF;
777: l_parameter_list.DELETE;
778:
779:
780: IF g_debug <= gme_debug.g_log_procedure THEN
781: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Exiting Notify_CSR .............');
782: END IF;
783:
784: EXCEPTION

Line 781: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Exiting Notify_CSR .............');

777: l_parameter_list.DELETE;
778:
779:
780: IF g_debug <= gme_debug.g_log_procedure THEN
781: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Exiting Notify_CSR .............');
782: END IF;
783:
784: EXCEPTION
785:

Line 787: IF g_debug <= gme_debug.g_log_procedure THEN

783:
784: EXCEPTION
785:
786: WHEN OTHERS THEN
787: IF g_debug <= gme_debug.g_log_procedure THEN
788: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'WARNING.... In Others Exception in Notify CSR');
789: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
790: END IF;
791:

Line 788: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'WARNING.... In Others Exception in Notify CSR');

784: EXCEPTION
785:
786: WHEN OTHERS THEN
787: IF g_debug <= gme_debug.g_log_procedure THEN
788: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'WARNING.... In Others Exception in Notify CSR');
789: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
790: END IF;
791:
792: END notify_CSR;

Line 789: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

785:
786: WHEN OTHERS THEN
787: IF g_debug <= gme_debug.g_log_procedure THEN
788: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'WARNING.... In Others Exception in Notify CSR');
789: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
790: END IF;
791:
792: END notify_CSR;
793:

Line 846: IF g_debug <= gme_debug.g_log_procedure THEN

842: uom_conversion_error EXCEPTION;
843: get_trans_err EXCEPTION;
844: notify_CSR_err EXCEPTION;
845: BEGIN
846: IF g_debug <= gme_debug.g_log_procedure THEN
847: gme_debug.put_line ('Entering api '
848: || g_pkg_name || '.'
849: || l_api_name);
850: END IF;

Line 847: gme_debug.put_line ('Entering api '

843: get_trans_err EXCEPTION;
844: notify_CSR_err EXCEPTION;
845: BEGIN
846: IF g_debug <= gme_debug.g_log_procedure THEN
847: gme_debug.put_line ('Entering api '
848: || g_pkg_name || '.'
849: || l_api_name);
850: END IF;
851:

Line 854: IF g_debug <= gme_debug.g_log_statement THEN

850: END IF;
851:
852: x_return_status := fnd_api.g_ret_sts_success;
853:
854: IF g_debug <= gme_debug.g_log_statement THEN
855: gme_debug.put_line
856: ( g_pkg_name
857: || '.'
858: || l_api_name

Line 855: gme_debug.put_line

851:
852: x_return_status := fnd_api.g_ret_sts_success;
853:
854: IF g_debug <= gme_debug.g_log_statement THEN
855: gme_debug.put_line
856: ( g_pkg_name
857: || '.'
858: || l_api_name
859: || ' Retrieve data for transaction id => '

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

865: ,x_mmln_tbl => l_mmln_tbl
866: ,x_return_status => x_return_status);
867:
868: IF x_return_status <> fnd_api.g_ret_sts_success THEN
869: IF (g_debug <= gme_debug.g_log_statement) THEN
870: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');
871: END IF;
872: RAISE get_trans_err;
873: END IF;

Line 870: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');

866: ,x_return_status => x_return_status);
867:
868: IF x_return_status <> fnd_api.g_ret_sts_success THEN
869: IF (g_debug <= gme_debug.g_log_statement) THEN
870: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');
871: END IF;
872: RAISE get_trans_err;
873: END IF;
874:

Line 882: IF g_debug <= gme_debug.g_log_statement THEN

878: l_yield_txn_counter := l_mmln_tbl.count;
879: ELSE
880: l_yield_txn_counter := 1;
881: END IF;
882: IF g_debug <= gme_debug.g_log_statement THEN
883: gme_debug.put_line
884: ( g_pkg_name
885: || '.'
886: || l_api_name

Line 883: gme_debug.put_line

879: ELSE
880: l_yield_txn_counter := 1;
881: END IF;
882: IF g_debug <= gme_debug.g_log_statement THEN
883: gme_debug.put_line
884: ( g_pkg_name
885: || '.'
886: || l_api_name
887: || ' Looping through transaction yield for a count of => '

Line 893: IF g_debug <= gme_debug.g_log_statement THEN

889: END IF;
890:
891: FOR x in 1..l_yield_txn_counter LOOP
892: IF l_SO_RSV_exist = 'N' THEN
893: IF g_debug <= gme_debug.g_log_statement THEN
894: gme_debug.put_line
895: ( g_pkg_name
896: || '.'
897: || l_api_name

Line 894: gme_debug.put_line

890:
891: FOR x in 1..l_yield_txn_counter LOOP
892: IF l_SO_RSV_exist = 'N' THEN
893: IF g_debug <= gme_debug.g_log_statement THEN
894: gme_debug.put_line
895: ( g_pkg_name
896: || '.'
897: || l_api_name
898: || 'No reservations outstanding for this supply line so exit now');

Line 904: IF g_debug <= gme_debug.g_log_statement THEN

900: EXIT;
901: END IF;
902: IF NVL(l_mmln_tbl.count,0) > 0 THEN
903: -- If mmli is populated, use the lot level data
904: IF g_debug <= gme_debug.g_log_statement THEN
905: gme_debug.put_line
906: ( g_pkg_name
907: || '.'
908: || l_api_name

Line 905: gme_debug.put_line

901: END IF;
902: IF NVL(l_mmln_tbl.count,0) > 0 THEN
903: -- If mmli is populated, use the lot level data
904: IF g_debug <= gme_debug.g_log_statement THEN
905: gme_debug.put_line
906: ( g_pkg_name
907: || '.'
908: || l_api_name
909: || ' Using lot level transaction data, lot is => '

Line 918: IF g_debug <= gme_debug.g_log_statement THEN

914: l_txn_secondary:= l_mmln_tbl(x).secondary_transaction_quantity;
915: l_txn_lot := l_mmln_tbl(x).lot_number;
916: ELSE
917: -- Use the transaction level data
918: IF g_debug <= gme_debug.g_log_statement THEN
919: gme_debug.put_line
920: ( g_pkg_name
921: || '.'
922: || l_api_name

Line 919: gme_debug.put_line

915: l_txn_lot := l_mmln_tbl(x).lot_number;
916: ELSE
917: -- Use the transaction level data
918: IF g_debug <= gme_debug.g_log_statement THEN
919: gme_debug.put_line
920: ( g_pkg_name
921: || '.'
922: || l_api_name
923: || ' Item is NOT lot controlled ');

Line 931: IF g_debug <= gme_debug.g_log_statement THEN

927: l_txn_secondary:= l_mmt_rec.secondary_transaction_quantity;
928: l_txn_lot := NULL;
929: END IF;
930:
931: IF g_debug <= gme_debug.g_log_statement THEN
932: gme_debug.put_line
933: ( g_pkg_name
934: || '.'
935: || l_api_name

Line 932: gme_debug.put_line

928: l_txn_lot := NULL;
929: END IF;
930:
931: IF g_debug <= gme_debug.g_log_statement THEN
932: gme_debug.put_line
933: ( g_pkg_name
934: || '.'
935: || l_api_name
936: || ' primary transaction quantity to be processed is '

Line 959: IF g_debug <= gme_debug.g_log_statement THEN

955: ,x_msg_count => x_message_count
956: ,x_msg_data => x_message_list
957: ,x_return_status => x_return_status);
958:
959: IF g_debug <= gme_debug.g_log_statement THEN
960: gme_debug.put_line
961: ( g_pkg_name
962: || '.'
963: || l_api_name

Line 960: gme_debug.put_line

956: ,x_msg_data => x_message_list
957: ,x_return_status => x_return_status);
958:
959: IF g_debug <= gme_debug.g_log_statement THEN
960: gme_debug.put_line
961: ( g_pkg_name
962: || '.'
963: || l_api_name
964: || 'Return status from query_prod_supply_reservations is '

Line 966: gme_debug.put_line

962: || '.'
963: || l_api_name
964: || 'Return status from query_prod_supply_reservations is '
965: || x_return_status);
966: gme_debug.put_line
967: ( g_pkg_name
968: || '.'
969: || l_api_name
970: || ' number of reservations is '

Line 975: IF g_debug <= gme_debug.g_log_statement THEN

971: || l_rsv_count);
972: END IF;
973:
974: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
975: IF g_debug <= gme_debug.g_log_statement THEN
976: gme_debug.put_line
977: ( g_pkg_name
978: || '.'
979: || l_api_name

Line 976: gme_debug.put_line

972: END IF;
973:
974: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
975: IF g_debug <= gme_debug.g_log_statement THEN
976: gme_debug.put_line
977: ( g_pkg_name
978: || '.'
979: || l_api_name
980: || 'Error is :'

Line 989: IF g_debug <= gme_debug.g_log_statement THEN

985:
986: -- if there are no reservations then there is no work to do so exit now
987: -- ====================================================================
988: IF NVL(l_rsv_count,0) = 0 THEN
989: IF g_debug <= gme_debug.g_log_statement THEN
990: gme_debug.put_line
991: ( g_pkg_name
992: || '.'
993: || l_api_name

Line 990: gme_debug.put_line

986: -- if there are no reservations then there is no work to do so exit now
987: -- ====================================================================
988: IF NVL(l_rsv_count,0) = 0 THEN
989: IF g_debug <= gme_debug.g_log_statement THEN
990: gme_debug.put_line
991: ( g_pkg_name
992: || '.'
993: || l_api_name
994: || 'No SO reservation demand so EXIT now ');

Line 1004: IF g_debug <= gme_debug.g_log_statement THEN

1000: l_rsv_rec := l_rsv_tbl (1);
1001:
1002: -- We will transfer the reserved quantity OR the transaction quantity; whichever is the smaller
1003: -- ================================================================================================
1004: IF g_debug <= gme_debug.g_log_statement THEN
1005: gme_debug.put_line
1006: ( g_pkg_name
1007: || '.'
1008: || l_api_name

Line 1005: gme_debug.put_line

1001:
1002: -- We will transfer the reserved quantity OR the transaction quantity; whichever is the smaller
1003: -- ================================================================================================
1004: IF g_debug <= gme_debug.g_log_statement THEN
1005: gme_debug.put_line
1006: ( g_pkg_name
1007: || '.'
1008: || l_api_name
1009: || ' Transaction primary quantity is '

Line 1070: IF g_debug <= gme_debug.g_log_statement THEN

1066: , to_unit => l_rsv_rec.secondary_uom_code
1067: , from_name => NULL -- from uom name
1068: , to_name => NULL -- to uom name
1069: );
1070: IF g_debug <= gme_debug.g_log_statement THEN
1071: gme_debug.put_line
1072: ( g_pkg_name
1073: || '.'
1074: || l_api_name

Line 1071: gme_debug.put_line

1067: , from_name => NULL -- from uom name
1068: , to_name => NULL -- to uom name
1069: );
1070: IF g_debug <= gme_debug.g_log_statement THEN
1071: gme_debug.put_line
1072: ( g_pkg_name
1073: || '.'
1074: || l_api_name
1075: || ' After UOM conversion the secondary qty is '

Line 1087: IF g_debug <= gme_debug.g_log_statement THEN

1083: END IF;
1084: END IF; -- IF l_lot_divisible_flag = 'N'
1085: END IF;
1086:
1087: IF g_debug <= gme_debug.g_log_statement THEN
1088: gme_debug.put_line
1089: ( g_pkg_name
1090: || '.'
1091: || l_api_name

Line 1088: gme_debug.put_line

1084: END IF; -- IF l_lot_divisible_flag = 'N'
1085: END IF;
1086:
1087: IF g_debug <= gme_debug.g_log_statement THEN
1088: gme_debug.put_line
1089: ( g_pkg_name
1090: || '.'
1091: || l_api_name
1092: || ' primary quantity to be reserved against INV is'

Line 1105: IF g_debug <= gme_debug.g_log_statement THEN

1101: l_transfer_quantity := l_transfer_secondary;
1102: ELSE
1103: l_transfer_quantity := NULL;
1104: END IF;
1105: IF g_debug <= gme_debug.g_log_statement THEN
1106: gme_debug.put_line
1107: ( g_pkg_name
1108: || '.'
1109: || l_api_name

Line 1106: gme_debug.put_line

1102: ELSE
1103: l_transfer_quantity := NULL;
1104: END IF;
1105: IF g_debug <= gme_debug.g_log_statement THEN
1106: gme_debug.put_line
1107: ( g_pkg_name
1108: || '.'
1109: || l_api_name
1110: || ' This is the primary quantity we are about to transfer => '

Line 1129: IF g_debug <= gme_debug.g_log_statement THEN

1125: -- Target Inventory IS RESERVABLE
1126: -- Transfer the reservation supply source from JOB to INVENTORY
1127: -- Use the detailing outlined on the COMPLETION transaction
1128: -- ============================================================
1129: IF g_debug <= gme_debug.g_log_statement THEN
1130: gme_debug.put_line
1131: ( g_pkg_name
1132: || '.'
1133: || l_api_name

Line 1130: gme_debug.put_line

1126: -- Transfer the reservation supply source from JOB to INVENTORY
1127: -- Use the detailing outlined on the COMPLETION transaction
1128: -- ============================================================
1129: IF g_debug <= gme_debug.g_log_statement THEN
1130: gme_debug.put_line
1131: ( g_pkg_name
1132: || '.'
1133: || l_api_name
1134: || ' This inventory yield IS reservable so proceed with transfer ');

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

1150: l_to_rsv_rec.reservation_quantity := l_transfer_quantity;
1151: l_to_rsv_rec.primary_reservation_quantity := l_transfer_primary;
1152: l_to_rsv_rec.secondary_reservation_quantity := l_transfer_secondary;
1153:
1154: IF (g_debug <= gme_debug.g_log_statement) THEN
1155: gme_debug.put_line ('Calling inv_reservation_pub.transfer_reservation');
1156: END IF;
1157:
1158: inv_reservation_pub.Transfer_Reservation

Line 1155: gme_debug.put_line ('Calling inv_reservation_pub.transfer_reservation');

1151: l_to_rsv_rec.primary_reservation_quantity := l_transfer_primary;
1152: l_to_rsv_rec.secondary_reservation_quantity := l_transfer_secondary;
1153:
1154: IF (g_debug <= gme_debug.g_log_statement) THEN
1155: gme_debug.put_line ('Calling inv_reservation_pub.transfer_reservation');
1156: END IF;
1157:
1158: inv_reservation_pub.Transfer_Reservation
1159: ( p_api_version_number => 1.0

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

1167: , p_to_serial_number => l_dummy_sn
1168: , p_validation_flag => FND_API.G_FALSE
1169: , x_to_reservation_id => l_rsv_id);
1170:
1171: IF (g_debug <= gme_debug.g_log_statement) THEN
1172: gme_debug.put_line ('After Calling inv_reservation_pub.transfer_reservation status is '||x_return_status);
1173: END IF;
1174:
1175: IF (l_return_status IN

Line 1172: gme_debug.put_line ('After Calling inv_reservation_pub.transfer_reservation status is '||x_return_status);

1168: , p_validation_flag => FND_API.G_FALSE
1169: , x_to_reservation_id => l_rsv_id);
1170:
1171: IF (g_debug <= gme_debug.g_log_statement) THEN
1172: gme_debug.put_line ('After Calling inv_reservation_pub.transfer_reservation status is '||x_return_status);
1173: END IF;
1174:
1175: IF (l_return_status IN
1176: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

Line 1183: IF g_debug <= gme_debug.g_log_statement THEN

1179: ELSE
1180: -- Target Inventory IS NOT RESERVABLE so we cannot transfer the reservation
1181: -- Need to debit the original SUPPLY reservation and notify sales staff is there is sales impact
1182: -- =============================================================================================
1183: IF g_debug <= gme_debug.g_log_statement THEN
1184: gme_debug.put_line
1185: ( g_pkg_name
1186: || '.'
1187: || l_api_name

Line 1184: gme_debug.put_line

1180: -- Target Inventory IS NOT RESERVABLE so we cannot transfer the reservation
1181: -- Need to debit the original SUPPLY reservation and notify sales staff is there is sales impact
1182: -- =============================================================================================
1183: IF g_debug <= gme_debug.g_log_statement THEN
1184: gme_debug.put_line
1185: ( g_pkg_name
1186: || '.'
1187: || l_api_name
1188: || ' This inventory yield IS NOT reservable so CANNOT transfer resv supply for line_id '

Line 1205: IF g_debug <= gme_debug.g_log_procedure THEN

1201: , X_return_status => x_return_status
1202: , X_msg_cont => x_message_count
1203: , X_msg_data => x_message_list );
1204:
1205: IF g_debug <= gme_debug.g_log_procedure THEN
1206: gme_debug.put_line ( g_pkg_name || '.'
1207: || l_api_name
1208: || ' after calling notify_CSR status is '
1209: || x_return_status );

Line 1206: gme_debug.put_line ( g_pkg_name || '.'

1202: , X_msg_cont => x_message_count
1203: , X_msg_data => x_message_list );
1204:
1205: IF g_debug <= gme_debug.g_log_procedure THEN
1206: gme_debug.put_line ( g_pkg_name || '.'
1207: || l_api_name
1208: || ' after calling notify_CSR status is '
1209: || x_return_status );
1210: END IF;

Line 1218: IF g_debug <= gme_debug.g_log_statement THEN

1214: END IF;
1215:
1216: END IF;
1217:
1218: IF g_debug <= gme_debug.g_log_statement THEN
1219: gme_debug.put_line
1220: ( g_pkg_name
1221: || '.'
1222: || l_api_name

Line 1219: gme_debug.put_line

1215:
1216: END IF;
1217:
1218: IF g_debug <= gme_debug.g_log_statement THEN
1219: gme_debug.put_line
1220: ( g_pkg_name
1221: || '.'
1222: || l_api_name
1223: || ' Invoke relieve reservation for quantity of '

Line 1244: IF g_debug <= gme_debug.g_log_procedure THEN

1240: , x_primary_remain_quantity => l_primary_remain
1241: , x_secondary_remain_quantity => l_secondary_remain
1242: );
1243:
1244: IF g_debug <= gme_debug.g_log_procedure THEN
1245: gme_debug.put_line ( g_pkg_name || '.'
1246: || l_api_name
1247: || ' after calling relieve_reservation status is '
1248: || x_return_status );

Line 1245: gme_debug.put_line ( g_pkg_name || '.'

1241: , x_secondary_remain_quantity => l_secondary_remain
1242: );
1243:
1244: IF g_debug <= gme_debug.g_log_procedure THEN
1245: gme_debug.put_line ( g_pkg_name || '.'
1246: || l_api_name
1247: || ' after calling relieve_reservation status is '
1248: || x_return_status );
1249: END IF;

Line 1269: IF g_debug <= gme_debug.g_log_procedure THEN

1265: END IF;
1266: END LOOP; -- WHILE l_l_transfer_complete = 'N'
1267: END LOOP; -- Transaction Quantity Processing
1268:
1269: IF g_debug <= gme_debug.g_log_procedure THEN
1270: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1271: END IF;
1272:
1273: EXCEPTION

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

1266: END LOOP; -- WHILE l_l_transfer_complete = 'N'
1267: END LOOP; -- Transaction Quantity Processing
1268:
1269: IF g_debug <= gme_debug.g_log_procedure THEN
1270: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1271: END IF;
1272:
1273: EXCEPTION
1274: WHEN uom_conversion_error THEN

Line 1280: IF (g_debug <= gme_debug.g_log_error) THEN

1276: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1277: fnd_message.set_token ('ITEM_NO', l_rsv_rec.inventory_item_id);
1278: fnd_message.set_token ('FROM_UOM', l_rsv_rec.primary_uom_code);
1279: fnd_message.set_token ('TO_UOM', l_rsv_rec.secondary_uom_code);
1280: IF (g_debug <= gme_debug.g_log_error) THEN
1281: gme_debug.put_line
1282: ( 'unit of measure conversion error for item '
1283: || l_rsv_rec.inventory_item_id
1284: || 'from unit '

Line 1281: gme_debug.put_line

1277: fnd_message.set_token ('ITEM_NO', l_rsv_rec.inventory_item_id);
1278: fnd_message.set_token ('FROM_UOM', l_rsv_rec.primary_uom_code);
1279: fnd_message.set_token ('TO_UOM', l_rsv_rec.secondary_uom_code);
1280: IF (g_debug <= gme_debug.g_log_error) THEN
1281: gme_debug.put_line
1282: ( 'unit of measure conversion error for item '
1283: || l_rsv_rec.inventory_item_id
1284: || 'from unit '
1285: || l_rsv_rec.primary_uom_code

Line 1290: IF (g_debug <= gme_debug.g_log_error) THEN

1286: || 'to unit '
1287: || l_rsv_rec.secondary_uom_code);
1288: END IF;
1289: WHEN transfer_reservation_err THEN
1290: IF (g_debug <= gme_debug.g_log_error) THEN
1291: gme_debug.put_line
1292: ( 'terminating due to error in inv_reservation_pub.transfer_reservation ');
1293: gme_debug.put_line ('error message is ' || x_message_list);
1294: END IF;

Line 1291: gme_debug.put_line

1287: || l_rsv_rec.secondary_uom_code);
1288: END IF;
1289: WHEN transfer_reservation_err THEN
1290: IF (g_debug <= gme_debug.g_log_error) THEN
1291: gme_debug.put_line
1292: ( 'terminating due to error in inv_reservation_pub.transfer_reservation ');
1293: gme_debug.put_line ('error message is ' || x_message_list);
1294: END IF;
1295: WHEN update_reservation_err THEN

Line 1293: gme_debug.put_line ('error message is ' || x_message_list);

1289: WHEN transfer_reservation_err THEN
1290: IF (g_debug <= gme_debug.g_log_error) THEN
1291: gme_debug.put_line
1292: ( 'terminating due to error in inv_reservation_pub.transfer_reservation ');
1293: gme_debug.put_line ('error message is ' || x_message_list);
1294: END IF;
1295: WHEN update_reservation_err THEN
1296: IF (g_debug <= gme_debug.g_log_error) THEN
1297: gme_debug.put_line

Line 1296: IF (g_debug <= gme_debug.g_log_error) THEN

1292: ( 'terminating due to error in inv_reservation_pub.transfer_reservation ');
1293: gme_debug.put_line ('error message is ' || x_message_list);
1294: END IF;
1295: WHEN update_reservation_err THEN
1296: IF (g_debug <= gme_debug.g_log_error) THEN
1297: gme_debug.put_line
1298: ( 'terminating due to error in inv_reservation_pub.update_reservation ');
1299: gme_debug.put_line ('error message is ' || x_message_list);
1300: END IF;

Line 1297: gme_debug.put_line

1293: gme_debug.put_line ('error message is ' || x_message_list);
1294: END IF;
1295: WHEN update_reservation_err THEN
1296: IF (g_debug <= gme_debug.g_log_error) THEN
1297: gme_debug.put_line
1298: ( 'terminating due to error in inv_reservation_pub.update_reservation ');
1299: gme_debug.put_line ('error message is ' || x_message_list);
1300: END IF;
1301: WHEN query_reservation_error THEN

Line 1299: gme_debug.put_line ('error message is ' || x_message_list);

1295: WHEN update_reservation_err THEN
1296: IF (g_debug <= gme_debug.g_log_error) THEN
1297: gme_debug.put_line
1298: ( 'terminating due to error in inv_reservation_pub.update_reservation ');
1299: gme_debug.put_line ('error message is ' || x_message_list);
1300: END IF;
1301: WHEN query_reservation_error THEN
1302: IF (g_debug <= gme_debug.g_log_error) THEN
1303: gme_debug.put_line

Line 1302: IF (g_debug <= gme_debug.g_log_error) THEN

1298: ( 'terminating due to error in inv_reservation_pub.update_reservation ');
1299: gme_debug.put_line ('error message is ' || x_message_list);
1300: END IF;
1301: WHEN query_reservation_error THEN
1302: IF (g_debug <= gme_debug.g_log_error) THEN
1303: gme_debug.put_line
1304: ( 'terminating due to error querying reservations ');
1305: gme_debug.put_line ('error message is ' || x_message_list);
1306: END IF;

Line 1303: gme_debug.put_line

1299: gme_debug.put_line ('error message is ' || x_message_list);
1300: END IF;
1301: WHEN query_reservation_error THEN
1302: IF (g_debug <= gme_debug.g_log_error) THEN
1303: gme_debug.put_line
1304: ( 'terminating due to error querying reservations ');
1305: gme_debug.put_line ('error message is ' || x_message_list);
1306: END IF;
1307: WHEN notify_CSR_err THEN

Line 1305: gme_debug.put_line ('error message is ' || x_message_list);

1301: WHEN query_reservation_error THEN
1302: IF (g_debug <= gme_debug.g_log_error) THEN
1303: gme_debug.put_line
1304: ( 'terminating due to error querying reservations ');
1305: gme_debug.put_line ('error message is ' || x_message_list);
1306: END IF;
1307: WHEN notify_CSR_err THEN
1308: IF (g_debug <= gme_debug.g_log_error) THEN
1309: gme_debug.put_line

Line 1308: IF (g_debug <= gme_debug.g_log_error) THEN

1304: ( 'terminating due to error querying reservations ');
1305: gme_debug.put_line ('error message is ' || x_message_list);
1306: END IF;
1307: WHEN notify_CSR_err THEN
1308: IF (g_debug <= gme_debug.g_log_error) THEN
1309: gme_debug.put_line
1310: ( 'terminating due to error invoking notify_CSR ');
1311: END IF;
1312: WHEN get_trans_err THEN

Line 1309: gme_debug.put_line

1305: gme_debug.put_line ('error message is ' || x_message_list);
1306: END IF;
1307: WHEN notify_CSR_err THEN
1308: IF (g_debug <= gme_debug.g_log_error) THEN
1309: gme_debug.put_line
1310: ( 'terminating due to error invoking notify_CSR ');
1311: END IF;
1312: WHEN get_trans_err THEN
1313: IF (g_debug <= gme_debug.g_log_error) THEN

Line 1313: IF (g_debug <= gme_debug.g_log_error) THEN

1309: gme_debug.put_line
1310: ( 'terminating due to error invoking notify_CSR ');
1311: END IF;
1312: WHEN get_trans_err THEN
1313: IF (g_debug <= gme_debug.g_log_error) THEN
1314: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
1315: END IF;
1316: WHEN error_get_item THEN
1317: IF (g_debug <= gme_debug.g_log_error) THEN

Line 1314: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');

1310: ( 'terminating due to error invoking notify_CSR ');
1311: END IF;
1312: WHEN get_trans_err THEN
1313: IF (g_debug <= gme_debug.g_log_error) THEN
1314: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
1315: END IF;
1316: WHEN error_get_item THEN
1317: IF (g_debug <= gme_debug.g_log_error) THEN
1318: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_item_rec');

Line 1317: IF (g_debug <= gme_debug.g_log_error) THEN

1313: IF (g_debug <= gme_debug.g_log_error) THEN
1314: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
1315: END IF;
1316: WHEN error_get_item THEN
1317: IF (g_debug <= gme_debug.g_log_error) THEN
1318: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_item_rec');
1319: END IF;
1320:
1321: WHEN OTHERS THEN

Line 1318: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_item_rec');

1314: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
1315: END IF;
1316: WHEN error_get_item THEN
1317: IF (g_debug <= gme_debug.g_log_error) THEN
1318: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_item_rec');
1319: END IF;
1320:
1321: WHEN OTHERS THEN
1322: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1322: IF g_debug <= gme_debug.g_log_unexpected THEN

1318: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_item_rec');
1319: END IF;
1320:
1321: WHEN OTHERS THEN
1322: IF g_debug <= gme_debug.g_log_unexpected THEN
1323: gme_debug.put_line ( 'When others exception in '
1324: || g_pkg_name
1325: || '.'
1326: || l_api_name

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

1319: END IF;
1320:
1321: WHEN OTHERS THEN
1322: IF g_debug <= gme_debug.g_log_unexpected THEN
1323: gme_debug.put_line ( 'When others exception in '
1324: || g_pkg_name
1325: || '.'
1326: || l_api_name
1327: || ' Error is '

Line 1356: IF g_debug <= gme_debug.g_log_procedure THEN

1352: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1353: -- ======================================================================
1354: query_reservation_error EXCEPTION;
1355: BEGIN
1356: IF g_debug <= gme_debug.g_log_procedure THEN
1357: gme_debug.put_line ('Entering api '
1358: || g_pkg_name || '.'
1359: || l_api_name);
1360: END IF;

Line 1357: gme_debug.put_line ('Entering api '

1353: -- ======================================================================
1354: query_reservation_error EXCEPTION;
1355: BEGIN
1356: IF g_debug <= gme_debug.g_log_procedure THEN
1357: gme_debug.put_line ('Entering api '
1358: || g_pkg_name || '.'
1359: || l_api_name);
1360: END IF;
1361:

Line 1374: IF g_debug <= gme_debug.g_log_statement THEN

1370: l_rsv_rec_inq.supply_source_header_id := p_matl_dtl_rec.batch_id;
1371: l_rsv_rec_inq.supply_source_line_id := p_matl_dtl_rec.material_detail_id;
1372: -- l_rsv_rec_inq.demand_source_type_id := 2;
1373:
1374: IF g_debug <= gme_debug.g_log_statement THEN
1375: gme_debug.put_line
1376: ( g_pkg_name
1377: || '.'
1378: || l_api_name

Line 1375: gme_debug.put_line

1371: l_rsv_rec_inq.supply_source_line_id := p_matl_dtl_rec.material_detail_id;
1372: -- l_rsv_rec_inq.demand_source_type_id := 2;
1373:
1374: IF g_debug <= gme_debug.g_log_statement THEN
1375: gme_debug.put_line
1376: ( g_pkg_name
1377: || '.'
1378: || l_api_name
1379: || ' Calling inv_reservation_pub.query_reservation for reservations against PROD supply for line'

Line 1389: IF g_debug <= gme_debug.g_log_statement THEN

1385: ELSE
1386: l_rsv_rec_inq.supply_source_type_id := 5;
1387: l_rsv_rec_inq.supply_source_header_id := p_matl_dtl_rec.batch_id;
1388:
1389: IF g_debug <= gme_debug.g_log_statement THEN
1390: gme_debug.put_line
1391: ( g_pkg_name
1392: || '.'
1393: || l_api_name

Line 1390: gme_debug.put_line

1386: l_rsv_rec_inq.supply_source_type_id := 5;
1387: l_rsv_rec_inq.supply_source_header_id := p_matl_dtl_rec.batch_id;
1388:
1389: IF g_debug <= gme_debug.g_log_statement THEN
1390: gme_debug.put_line
1391: ( g_pkg_name
1392: || '.'
1393: || l_api_name
1394: || ' Calling inv_reservation_pub.query_reservation for reservations against PROD supply for batce'

Line 1412: IF g_debug <= gme_debug.g_log_statement THEN

1408: ,x_mtl_reservation_tbl => x_mtl_reservation_tbl
1409: ,x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1410: ,x_error_code => l_error_code);
1411:
1412: IF g_debug <= gme_debug.g_log_statement THEN
1413: gme_debug.put_line
1414: ( g_pkg_name
1415: || '.'
1416: || l_api_name

Line 1413: gme_debug.put_line

1409: ,x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1410: ,x_error_code => l_error_code);
1411:
1412: IF g_debug <= gme_debug.g_log_statement THEN
1413: gme_debug.put_line
1414: ( g_pkg_name
1415: || '.'
1416: || l_api_name
1417: || 'Return status from inv_reservation_pub.query_reservation is '

Line 1427: IF g_debug <= gme_debug.g_log_statement THEN

1423: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1424: RAISE query_reservation_error;
1425: END IF;
1426:
1427: IF g_debug <= gme_debug.g_log_statement THEN
1428: gme_debug.put_line
1429: ( g_pkg_name
1430: || '.'
1431: || l_api_name

Line 1428: gme_debug.put_line

1424: RAISE query_reservation_error;
1425: END IF;
1426:
1427: IF g_debug <= gme_debug.g_log_statement THEN
1428: gme_debug.put_line
1429: ( g_pkg_name
1430: || '.'
1431: || l_api_name
1432: || ' Number of reservations against this production supply line is '

Line 1436: IF g_debug <= gme_debug.g_log_procedure THEN

1432: || ' Number of reservations against this production supply line is '
1433: || x_mtl_reservation_tbl_count);
1434: END IF;
1435:
1436: IF g_debug <= gme_debug.g_log_procedure THEN
1437: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1438: END IF;
1439:
1440: EXCEPTION

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

1433: || x_mtl_reservation_tbl_count);
1434: END IF;
1435:
1436: IF g_debug <= gme_debug.g_log_procedure THEN
1437: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1438: END IF;
1439:
1440: EXCEPTION
1441: WHEN query_reservation_error THEN

Line 1442: IF (g_debug <= gme_debug.g_log_error) THEN

1438: END IF;
1439:
1440: EXCEPTION
1441: WHEN query_reservation_error THEN
1442: IF (g_debug <= gme_debug.g_log_error) THEN
1443: gme_debug.put_line
1444: ( 'inv_reservation_pub.query_reservation returns '
1445: || x_return_status);
1446: gme_debug.put_line ('error message is ' || x_msg_data);

Line 1443: gme_debug.put_line

1439:
1440: EXCEPTION
1441: WHEN query_reservation_error THEN
1442: IF (g_debug <= gme_debug.g_log_error) THEN
1443: gme_debug.put_line
1444: ( 'inv_reservation_pub.query_reservation returns '
1445: || x_return_status);
1446: gme_debug.put_line ('error message is ' || x_msg_data);
1447: END IF;

Line 1446: gme_debug.put_line ('error message is ' || x_msg_data);

1442: IF (g_debug <= gme_debug.g_log_error) THEN
1443: gme_debug.put_line
1444: ( 'inv_reservation_pub.query_reservation returns '
1445: || x_return_status);
1446: gme_debug.put_line ('error message is ' || x_msg_data);
1447: END IF;
1448:
1449: WHEN OTHERS THEN
1450: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1450: IF g_debug <= gme_debug.g_log_unexpected THEN

1446: gme_debug.put_line ('error message is ' || x_msg_data);
1447: END IF;
1448:
1449: WHEN OTHERS THEN
1450: IF g_debug <= gme_debug.g_log_unexpected THEN
1451: gme_debug.put_line ( 'When others exception in '
1452: || g_pkg_name
1453: || '.'
1454: || l_api_name

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

1447: END IF;
1448:
1449: WHEN OTHERS THEN
1450: IF g_debug <= gme_debug.g_log_unexpected THEN
1451: gme_debug.put_line ( 'When others exception in '
1452: || g_pkg_name
1453: || '.'
1454: || l_api_name
1455: || ' Error is '

Line 1490: IF g_debug <= gme_debug.g_log_procedure THEN

1486: update_reservation_err EXCEPTION;
1487: delete_reservation_err EXCEPTION;
1488: notify_CSR_err EXCEPTION;
1489: BEGIN
1490: IF g_debug <= gme_debug.g_log_procedure THEN
1491: gme_debug.put_line ('Entering api '
1492: || g_pkg_name || '.'
1493: || l_api_name
1494: || ' material_detail_id '

Line 1491: gme_debug.put_line ('Entering api '

1487: delete_reservation_err EXCEPTION;
1488: notify_CSR_err EXCEPTION;
1489: BEGIN
1490: IF g_debug <= gme_debug.g_log_procedure THEN
1491: gme_debug.put_line ('Entering api '
1492: || g_pkg_name || '.'
1493: || l_api_name
1494: || ' material_detail_id '
1495: || p_matl_dtl_rec.material_detail_id);

Line 1512: IF g_debug <= gme_debug.g_log_statement THEN

1508: ,x_msg_count => x_msg_count
1509: ,x_msg_data => x_msg_data
1510: ,x_return_status => x_return_status);
1511:
1512: IF g_debug <= gme_debug.g_log_statement THEN
1513: gme_debug.put_line
1514: ( g_pkg_name
1515: || '.'
1516: || l_api_name

Line 1513: gme_debug.put_line

1509: ,x_msg_data => x_msg_data
1510: ,x_return_status => x_return_status);
1511:
1512: IF g_debug <= gme_debug.g_log_statement THEN
1513: gme_debug.put_line
1514: ( g_pkg_name
1515: || '.'
1516: || l_api_name
1517: || 'Return status from query_prod_supply_reservations is '

Line 1519: gme_debug.put_line

1515: || '.'
1516: || l_api_name
1517: || 'Return status from query_prod_supply_reservations is '
1518: || x_return_status);
1519: gme_debug.put_line
1520: ( g_pkg_name
1521: || '.'
1522: || l_api_name
1523: || ' number of reservations is '

Line 1528: IF g_debug <= gme_debug.g_log_statement THEN

1524: || l_rsv_count);
1525: END IF;
1526:
1527: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1528: IF g_debug <= gme_debug.g_log_statement THEN
1529: gme_debug.put_line
1530: ( g_pkg_name
1531: || '.'
1532: || l_api_name

Line 1529: gme_debug.put_line

1525: END IF;
1526:
1527: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1528: IF g_debug <= gme_debug.g_log_statement THEN
1529: gme_debug.put_line
1530: ( g_pkg_name
1531: || '.'
1532: || l_api_name
1533: || 'Error is :'

Line 1540: IF g_debug <= gme_debug.g_log_statement THEN

1536: RAISE query_reservation_error;
1537: END IF;
1538:
1539: IF NVL(l_rsv_count,0) <= 0 THEN
1540: IF g_debug <= gme_debug.g_log_statement THEN
1541: gme_debug.put_line
1542: ( g_pkg_name
1543: || '.'
1544: || l_api_name

Line 1541: gme_debug.put_line

1537: END IF;
1538:
1539: IF NVL(l_rsv_count,0) <= 0 THEN
1540: IF g_debug <= gme_debug.g_log_statement THEN
1541: gme_debug.put_line
1542: ( g_pkg_name
1543: || '.'
1544: || l_api_name
1545: || ' No reservations against material detail line as a source of supply so RETURN now ');

Line 1571: IF g_debug <= gme_debug.g_log_statement THEN

1567: ,to_name => NULL);
1568: END IF;
1569: -- Compare supply and demand. If supply meets/exceeds demand, there is nothing to do
1570: -- =================================================================================
1571: IF g_debug <= gme_debug.g_log_statement THEN
1572: gme_debug.put_line
1573: ( g_pkg_name
1574: || '.'
1575: || l_api_name

Line 1572: gme_debug.put_line

1568: END IF;
1569: -- Compare supply and demand. If supply meets/exceeds demand, there is nothing to do
1570: -- =================================================================================
1571: IF g_debug <= gme_debug.g_log_statement THEN
1572: gme_debug.put_line
1573: ( g_pkg_name
1574: || '.'
1575: || l_api_name
1576: || ' Current demand figure => '

Line 1582: IF g_debug <= gme_debug.g_log_statement THEN

1578: || ' Current supply figure => '
1579: || l_available_quantity);
1580: END IF;
1581: IF l_available_quantity >= l_total_primary_demand THEN
1582: IF g_debug <= gme_debug.g_log_statement THEN
1583: gme_debug.put_line
1584: ( g_pkg_name
1585: || '.'
1586: || l_api_name

Line 1583: gme_debug.put_line

1579: || l_available_quantity);
1580: END IF;
1581: IF l_available_quantity >= l_total_primary_demand THEN
1582: IF g_debug <= gme_debug.g_log_statement THEN
1583: gme_debug.put_line
1584: ( g_pkg_name
1585: || '.'
1586: || l_api_name
1587: || ' Supply exceeds Demand so no adjustments required; return now ');

Line 1597: IF g_debug <= gme_debug.g_log_procedure THEN

1593:
1594: FOR I IN 1..l_rsv_tbl.COUNT LOOP
1595:
1596: l_rsv_rec := l_rsv_tbl(I);
1597: IF g_debug <= gme_debug.g_log_procedure THEN
1598: gme_debug.put_line ( g_pkg_name || '.'
1599: || l_api_name
1600: || ' primary reserved qty '
1601: || l_rsv_rec.primary_reservation_quantity);

Line 1598: gme_debug.put_line ( g_pkg_name || '.'

1594: FOR I IN 1..l_rsv_tbl.COUNT LOOP
1595:
1596: l_rsv_rec := l_rsv_tbl(I);
1597: IF g_debug <= gme_debug.g_log_procedure THEN
1598: gme_debug.put_line ( g_pkg_name || '.'
1599: || l_api_name
1600: || ' primary reserved qty '
1601: || l_rsv_rec.primary_reservation_quantity);
1602: END IF;

Line 1617: IF g_debug <= gme_debug.g_log_procedure THEN

1613: , X_return_status => x_return_status
1614: , X_msg_cont => x_msg_count
1615: , X_msg_data => x_msg_data );
1616:
1617: IF g_debug <= gme_debug.g_log_procedure THEN
1618: gme_debug.put_line ( g_pkg_name || '.'
1619: || l_api_name
1620: || ' after calling notify_CSR status is '
1621: || x_return_status );

Line 1618: gme_debug.put_line ( g_pkg_name || '.'

1614: , X_msg_cont => x_msg_count
1615: , X_msg_data => x_msg_data );
1616:
1617: IF g_debug <= gme_debug.g_log_procedure THEN
1618: gme_debug.put_line ( g_pkg_name || '.'
1619: || l_api_name
1620: || ' after calling notify_CSR status is '
1621: || x_return_status );
1622: END IF;

Line 1630: IF g_debug <= gme_debug.g_log_procedure THEN

1626: RAISE notify_CSR_err;
1627: END IF;
1628:
1629: IF (l_rsv_rec.primary_reservation_quantity <= l_primary_to_unreserve) THEN
1630: IF g_debug <= gme_debug.g_log_procedure THEN
1631: gme_debug.put_line ( g_pkg_name || '.'
1632: || l_api_name
1633: || ' about to invoke delete_reservation ');
1634: END IF;

Line 1631: gme_debug.put_line ( g_pkg_name || '.'

1627: END IF;
1628:
1629: IF (l_rsv_rec.primary_reservation_quantity <= l_primary_to_unreserve) THEN
1630: IF g_debug <= gme_debug.g_log_procedure THEN
1631: gme_debug.put_line ( g_pkg_name || '.'
1632: || l_api_name
1633: || ' about to invoke delete_reservation ');
1634: END IF;
1635:

Line 1646: IF g_debug <= gme_debug.g_log_procedure THEN

1642: , p_rsv_rec => l_rsv_rec
1643: , p_serial_number => l_dummy_sn
1644: );
1645:
1646: IF g_debug <= gme_debug.g_log_procedure THEN
1647: gme_debug.put_line ( g_pkg_name || '.'
1648: || l_api_name
1649: || ' after calling delete_reservation status is '
1650: || x_return_status );

Line 1647: gme_debug.put_line ( g_pkg_name || '.'

1643: , p_serial_number => l_dummy_sn
1644: );
1645:
1646: IF g_debug <= gme_debug.g_log_procedure THEN
1647: gme_debug.put_line ( g_pkg_name || '.'
1648: || l_api_name
1649: || ' after calling delete_reservation status is '
1650: || x_return_status );
1651: END IF;

Line 1678: IF g_debug <= gme_debug.g_log_procedure THEN

1674: , from_name => NULL
1675: , to_name => NULL);
1676: END IF;
1677:
1678: IF g_debug <= gme_debug.g_log_procedure THEN
1679: gme_debug.put_line ( g_pkg_name || '.'
1680: || l_api_name
1681: || 'qty to relieve => '
1682: || l_primary_to_unreserve

Line 1679: gme_debug.put_line ( g_pkg_name || '.'

1675: , to_name => NULL);
1676: END IF;
1677:
1678: IF g_debug <= gme_debug.g_log_procedure THEN
1679: gme_debug.put_line ( g_pkg_name || '.'
1680: || l_api_name
1681: || 'qty to relieve => '
1682: || l_primary_to_unreserve
1683: || ' secondary qty to relieve => '

Line 1706: IF g_debug <= gme_debug.g_log_procedure THEN

1702: , x_primary_remain_quantity => l_primary_remain
1703: , x_secondary_remain_quantity => l_secondary_remain
1704: );
1705:
1706: IF g_debug <= gme_debug.g_log_procedure THEN
1707: gme_debug.put_line ( g_pkg_name || '.'
1708: || l_api_name
1709: || ' after calling relieve_reservation status is '
1710: || x_return_status );

Line 1707: gme_debug.put_line ( g_pkg_name || '.'

1703: , x_secondary_remain_quantity => l_secondary_remain
1704: );
1705:
1706: IF g_debug <= gme_debug.g_log_procedure THEN
1707: gme_debug.put_line ( g_pkg_name || '.'
1708: || l_api_name
1709: || ' after calling relieve_reservation status is '
1710: || x_return_status );
1711: END IF;

Line 1729: IF g_debug <= gme_debug.g_log_procedure THEN

1725: END IF;
1726:
1727: END LOOP;
1728:
1729: IF g_debug <= gme_debug.g_log_procedure THEN
1730: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1731: END IF;
1732: EXCEPTION
1733: WHEN delete_reservation_err THEN

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

1726:
1727: END LOOP;
1728:
1729: IF g_debug <= gme_debug.g_log_procedure THEN
1730: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1731: END IF;
1732: EXCEPTION
1733: WHEN delete_reservation_err THEN
1734: IF (g_debug <= gme_debug.g_log_error) THEN

Line 1734: IF (g_debug <= gme_debug.g_log_error) THEN

1730: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1731: END IF;
1732: EXCEPTION
1733: WHEN delete_reservation_err THEN
1734: IF (g_debug <= gme_debug.g_log_error) THEN
1735: gme_debug.put_line
1736: ( 'inv_reservation_pub.delete_reservation failure ');
1737: gme_debug.put_line ('error message is ' || x_msg_data);
1738: END IF;

Line 1735: gme_debug.put_line

1731: END IF;
1732: EXCEPTION
1733: WHEN delete_reservation_err THEN
1734: IF (g_debug <= gme_debug.g_log_error) THEN
1735: gme_debug.put_line
1736: ( 'inv_reservation_pub.delete_reservation failure ');
1737: gme_debug.put_line ('error message is ' || x_msg_data);
1738: END IF;
1739: WHEN update_reservation_err THEN

Line 1737: gme_debug.put_line ('error message is ' || x_msg_data);

1733: WHEN delete_reservation_err THEN
1734: IF (g_debug <= gme_debug.g_log_error) THEN
1735: gme_debug.put_line
1736: ( 'inv_reservation_pub.delete_reservation failure ');
1737: gme_debug.put_line ('error message is ' || x_msg_data);
1738: END IF;
1739: WHEN update_reservation_err THEN
1740: IF (g_debug <= gme_debug.g_log_error) THEN
1741: gme_debug.put_line

Line 1740: IF (g_debug <= gme_debug.g_log_error) THEN

1736: ( 'inv_reservation_pub.delete_reservation failure ');
1737: gme_debug.put_line ('error message is ' || x_msg_data);
1738: END IF;
1739: WHEN update_reservation_err THEN
1740: IF (g_debug <= gme_debug.g_log_error) THEN
1741: gme_debug.put_line
1742: ( 'inv_reservation_pub.relieve_reservation failure ');
1743: gme_debug.put_line ('error message is ' || x_msg_data);
1744: END IF;

Line 1741: gme_debug.put_line

1737: gme_debug.put_line ('error message is ' || x_msg_data);
1738: END IF;
1739: WHEN update_reservation_err THEN
1740: IF (g_debug <= gme_debug.g_log_error) THEN
1741: gme_debug.put_line
1742: ( 'inv_reservation_pub.relieve_reservation failure ');
1743: gme_debug.put_line ('error message is ' || x_msg_data);
1744: END IF;
1745: WHEN notify_CSR_err THEN

Line 1743: gme_debug.put_line ('error message is ' || x_msg_data);

1739: WHEN update_reservation_err THEN
1740: IF (g_debug <= gme_debug.g_log_error) THEN
1741: gme_debug.put_line
1742: ( 'inv_reservation_pub.relieve_reservation failure ');
1743: gme_debug.put_line ('error message is ' || x_msg_data);
1744: END IF;
1745: WHEN notify_CSR_err THEN
1746: IF (g_debug <= gme_debug.g_log_error) THEN
1747: gme_debug.put_line

Line 1746: IF (g_debug <= gme_debug.g_log_error) THEN

1742: ( 'inv_reservation_pub.relieve_reservation failure ');
1743: gme_debug.put_line ('error message is ' || x_msg_data);
1744: END IF;
1745: WHEN notify_CSR_err THEN
1746: IF (g_debug <= gme_debug.g_log_error) THEN
1747: gme_debug.put_line
1748: ( 'inv_reservation_pub.update_reservation failure ');
1749: gme_debug.put_line ('error message is ' || x_msg_data);
1750: END IF;

Line 1747: gme_debug.put_line

1743: gme_debug.put_line ('error message is ' || x_msg_data);
1744: END IF;
1745: WHEN notify_CSR_err THEN
1746: IF (g_debug <= gme_debug.g_log_error) THEN
1747: gme_debug.put_line
1748: ( 'inv_reservation_pub.update_reservation failure ');
1749: gme_debug.put_line ('error message is ' || x_msg_data);
1750: END IF;
1751:

Line 1749: gme_debug.put_line ('error message is ' || x_msg_data);

1745: WHEN notify_CSR_err THEN
1746: IF (g_debug <= gme_debug.g_log_error) THEN
1747: gme_debug.put_line
1748: ( 'inv_reservation_pub.update_reservation failure ');
1749: gme_debug.put_line ('error message is ' || x_msg_data);
1750: END IF;
1751:
1752:
1753: WHEN OTHERS THEN

Line 1754: IF g_debug <= gme_debug.g_log_unexpected THEN

1750: END IF;
1751:
1752:
1753: WHEN OTHERS THEN
1754: IF g_debug <= gme_debug.g_log_unexpected THEN
1755: gme_debug.put_line ( 'When others exception in '
1756: || g_pkg_name
1757: || '.'
1758: || l_api_name

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

1751:
1752:
1753: WHEN OTHERS THEN
1754: IF g_debug <= gme_debug.g_log_unexpected THEN
1755: gme_debug.put_line ( 'When others exception in '
1756: || g_pkg_name
1757: || '.'
1758: || l_api_name
1759: || ' Error is '

Line 1788: IF g_debug <= gme_debug.g_log_procedure THEN

1784: delete_reservation_err EXCEPTION;
1785: matl_fetch_error EXCEPTION;
1786: notify_CSR_err EXCEPTION;
1787: BEGIN
1788: IF g_debug <= gme_debug.g_log_procedure THEN
1789: gme_debug.put_line ('Entering api '
1790: || g_pkg_name || '.'
1791: || l_api_name
1792: || ' material_detail_id '

Line 1789: gme_debug.put_line ('Entering api '

1785: matl_fetch_error EXCEPTION;
1786: notify_CSR_err EXCEPTION;
1787: BEGIN
1788: IF g_debug <= gme_debug.g_log_procedure THEN
1789: gme_debug.put_line ('Entering api '
1790: || g_pkg_name || '.'
1791: || l_api_name
1792: || ' material_detail_id '
1793: || p_matl_dtl_rec.material_detail_id);

Line 1821: IF g_debug <= gme_debug.g_log_statement THEN

1817: ,x_msg_count => x_msg_count
1818: ,x_msg_data => x_msg_data
1819: ,x_return_status => x_return_status);
1820:
1821: IF g_debug <= gme_debug.g_log_statement THEN
1822: gme_debug.put_line
1823: ( g_pkg_name
1824: || '.'
1825: || l_api_name

Line 1822: gme_debug.put_line

1818: ,x_msg_data => x_msg_data
1819: ,x_return_status => x_return_status);
1820:
1821: IF g_debug <= gme_debug.g_log_statement THEN
1822: gme_debug.put_line
1823: ( g_pkg_name
1824: || '.'
1825: || l_api_name
1826: || 'Return status from query_prod_supply_reservations is '

Line 1828: gme_debug.put_line

1824: || '.'
1825: || l_api_name
1826: || 'Return status from query_prod_supply_reservations is '
1827: || x_return_status);
1828: gme_debug.put_line
1829: ( g_pkg_name
1830: || '.'
1831: || l_api_name
1832: || ' number of reservations is '

Line 1837: IF g_debug <= gme_debug.g_log_statement THEN

1833: || l_rsv_count);
1834: END IF;
1835:
1836: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1837: IF g_debug <= gme_debug.g_log_statement THEN
1838: gme_debug.put_line
1839: ( g_pkg_name
1840: || '.'
1841: || l_api_name

Line 1838: gme_debug.put_line

1834: END IF;
1835:
1836: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1837: IF g_debug <= gme_debug.g_log_statement THEN
1838: gme_debug.put_line
1839: ( g_pkg_name
1840: || '.'
1841: || l_api_name
1842: || 'Error is :'

Line 1849: IF g_debug <= gme_debug.g_log_statement THEN

1845: RAISE query_reservation_error;
1846: END IF;
1847:
1848: IF NVL(l_rsv_count,0) <= 0 THEN
1849: IF g_debug <= gme_debug.g_log_statement THEN
1850: gme_debug.put_line
1851: ( g_pkg_name
1852: || '.'
1853: || l_api_name

Line 1850: gme_debug.put_line

1846: END IF;
1847:
1848: IF NVL(l_rsv_count,0) <= 0 THEN
1849: IF g_debug <= gme_debug.g_log_statement THEN
1850: gme_debug.put_line
1851: ( g_pkg_name
1852: || '.'
1853: || l_api_name
1854: || ' No reservations against material detail line as a source of supply so RETURN now ');

Line 1879: IF g_debug <= gme_debug.g_log_procedure THEN

1875: , X_return_status => x_return_status
1876: , X_msg_cont => x_msg_count
1877: , X_msg_data => x_msg_data );
1878:
1879: IF g_debug <= gme_debug.g_log_procedure THEN
1880: gme_debug.put_line ( g_pkg_name || '.'
1881: || l_api_name
1882: || ' after calling notify_CSR status is '
1883: || x_return_status );

Line 1880: gme_debug.put_line ( g_pkg_name || '.'

1876: , X_msg_cont => x_msg_count
1877: , X_msg_data => x_msg_data );
1878:
1879: IF g_debug <= gme_debug.g_log_procedure THEN
1880: gme_debug.put_line ( g_pkg_name || '.'
1881: || l_api_name
1882: || ' after calling notify_CSR status is '
1883: || x_return_status );
1884: END IF;

Line 1891: IF g_debug <= gme_debug.g_log_procedure THEN

1887: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1888: RAISE notify_CSR_err;
1889: END IF;
1890:
1891: IF g_debug <= gme_debug.g_log_procedure THEN
1892: gme_debug.put_line ( g_pkg_name || '.'
1893: || l_api_name
1894: || ' about to invoke delete_reservation for reservation id '
1895: || l_rsv_rec.reservation_id);

Line 1892: gme_debug.put_line ( g_pkg_name || '.'

1888: RAISE notify_CSR_err;
1889: END IF;
1890:
1891: IF g_debug <= gme_debug.g_log_procedure THEN
1892: gme_debug.put_line ( g_pkg_name || '.'
1893: || l_api_name
1894: || ' about to invoke delete_reservation for reservation id '
1895: || l_rsv_rec.reservation_id);
1896: END IF;

Line 1908: IF g_debug <= gme_debug.g_log_procedure THEN

1904: , p_rsv_rec => l_rsv_rec
1905: , p_serial_number => l_dummy_sn
1906: );
1907:
1908: IF g_debug <= gme_debug.g_log_procedure THEN
1909: gme_debug.put_line ( g_pkg_name || '.'
1910: || l_api_name
1911: || ' after calling delete_reservation status is '
1912: || x_return_status );

Line 1909: gme_debug.put_line ( g_pkg_name || '.'

1905: , p_serial_number => l_dummy_sn
1906: );
1907:
1908: IF g_debug <= gme_debug.g_log_procedure THEN
1909: gme_debug.put_line ( g_pkg_name || '.'
1910: || l_api_name
1911: || ' after calling delete_reservation status is '
1912: || x_return_status );
1913: END IF;

Line 1922: IF g_debug <= gme_debug.g_log_procedure THEN

1918: RAISE delete_reservation_err;
1919: END IF;
1920:
1921: END LOOP;
1922: IF g_debug <= gme_debug.g_log_procedure THEN
1923: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1924: END IF;
1925:
1926: EXCEPTION

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

1919: END IF;
1920:
1921: END LOOP;
1922: IF g_debug <= gme_debug.g_log_procedure THEN
1923: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1924: END IF;
1925:
1926: EXCEPTION
1927: WHEN delete_reservation_err THEN

Line 1928: IF (g_debug <= gme_debug.g_log_error) THEN

1924: END IF;
1925:
1926: EXCEPTION
1927: WHEN delete_reservation_err THEN
1928: IF (g_debug <= gme_debug.g_log_error) THEN
1929: gme_debug.put_line
1930: ( 'inv_reservation_pub.delete_reservation failure ');
1931: gme_debug.put_line ('error message is ' || x_msg_data);
1932: END IF;

Line 1929: gme_debug.put_line

1925:
1926: EXCEPTION
1927: WHEN delete_reservation_err THEN
1928: IF (g_debug <= gme_debug.g_log_error) THEN
1929: gme_debug.put_line
1930: ( 'inv_reservation_pub.delete_reservation failure ');
1931: gme_debug.put_line ('error message is ' || x_msg_data);
1932: END IF;
1933: WHEN notify_CSR_err THEN

Line 1931: gme_debug.put_line ('error message is ' || x_msg_data);

1927: WHEN delete_reservation_err THEN
1928: IF (g_debug <= gme_debug.g_log_error) THEN
1929: gme_debug.put_line
1930: ( 'inv_reservation_pub.delete_reservation failure ');
1931: gme_debug.put_line ('error message is ' || x_msg_data);
1932: END IF;
1933: WHEN notify_CSR_err THEN
1934: IF (g_debug <= gme_debug.g_log_error) THEN
1935: gme_debug.put_line

Line 1934: IF (g_debug <= gme_debug.g_log_error) THEN

1930: ( 'inv_reservation_pub.delete_reservation failure ');
1931: gme_debug.put_line ('error message is ' || x_msg_data);
1932: END IF;
1933: WHEN notify_CSR_err THEN
1934: IF (g_debug <= gme_debug.g_log_error) THEN
1935: gme_debug.put_line
1936: ( 'gme_supply_res_pvt.notify_CSR failure ');
1937: gme_debug.put_line ('error message is ' || x_msg_data);
1938: END IF;

Line 1935: gme_debug.put_line

1931: gme_debug.put_line ('error message is ' || x_msg_data);
1932: END IF;
1933: WHEN notify_CSR_err THEN
1934: IF (g_debug <= gme_debug.g_log_error) THEN
1935: gme_debug.put_line
1936: ( 'gme_supply_res_pvt.notify_CSR failure ');
1937: gme_debug.put_line ('error message is ' || x_msg_data);
1938: END IF;
1939: WHEN matl_fetch_error THEN

Line 1937: gme_debug.put_line ('error message is ' || x_msg_data);

1933: WHEN notify_CSR_err THEN
1934: IF (g_debug <= gme_debug.g_log_error) THEN
1935: gme_debug.put_line
1936: ( 'gme_supply_res_pvt.notify_CSR failure ');
1937: gme_debug.put_line ('error message is ' || x_msg_data);
1938: END IF;
1939: WHEN matl_fetch_error THEN
1940: x_return_status := fnd_api.g_ret_sts_error;
1941: WHEN OTHERS THEN

Line 1942: IF g_debug <= gme_debug.g_log_unexpected THEN

1938: END IF;
1939: WHEN matl_fetch_error THEN
1940: x_return_status := fnd_api.g_ret_sts_error;
1941: WHEN OTHERS THEN
1942: IF g_debug <= gme_debug.g_log_unexpected THEN
1943: gme_debug.put_line ( 'When others exception in '
1944: || g_pkg_name
1945: || '.'
1946: || l_api_name

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

1939: WHEN matl_fetch_error THEN
1940: x_return_status := fnd_api.g_ret_sts_error;
1941: WHEN OTHERS THEN
1942: IF g_debug <= gme_debug.g_log_unexpected THEN
1943: gme_debug.put_line ( 'When others exception in '
1944: || g_pkg_name
1945: || '.'
1946: || l_api_name
1947: || ' Error is '

Line 1976: IF g_debug <= gme_debug.g_log_procedure THEN

1972: delete_reservation_err EXCEPTION;
1973: matl_fetch_error EXCEPTION;
1974: notify_CSR_err EXCEPTION;
1975: BEGIN
1976: IF g_debug <= gme_debug.g_log_procedure THEN
1977: gme_debug.put_line ('Entering api '
1978: || g_pkg_name || '.'
1979: || l_api_name
1980: || ' batch_id => '

Line 1977: gme_debug.put_line ('Entering api '

1973: matl_fetch_error EXCEPTION;
1974: notify_CSR_err EXCEPTION;
1975: BEGIN
1976: IF g_debug <= gme_debug.g_log_procedure THEN
1977: gme_debug.put_line ('Entering api '
1978: || g_pkg_name || '.'
1979: || l_api_name
1980: || ' batch_id => '
1981: || p_batch_header_rec.batch_id);

Line 1996: IF g_debug <= gme_debug.g_log_statement THEN

1992: ,x_msg_count => x_msg_count
1993: ,x_msg_data => x_msg_data
1994: ,x_return_status => x_return_status);
1995:
1996: IF g_debug <= gme_debug.g_log_statement THEN
1997: gme_debug.put_line
1998: ( g_pkg_name
1999: || '.'
2000: || l_api_name

Line 1997: gme_debug.put_line

1993: ,x_msg_data => x_msg_data
1994: ,x_return_status => x_return_status);
1995:
1996: IF g_debug <= gme_debug.g_log_statement THEN
1997: gme_debug.put_line
1998: ( g_pkg_name
1999: || '.'
2000: || l_api_name
2001: || 'Return status from query_prod_supply_reservations is '

Line 2003: gme_debug.put_line

1999: || '.'
2000: || l_api_name
2001: || 'Return status from query_prod_supply_reservations is '
2002: || x_return_status);
2003: gme_debug.put_line
2004: ( g_pkg_name
2005: || '.'
2006: || l_api_name
2007: || ' number of reservations is '

Line 2012: IF g_debug <= gme_debug.g_log_statement THEN

2008: || l_rsv_count);
2009: END IF;
2010:
2011: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2012: IF g_debug <= gme_debug.g_log_statement THEN
2013: gme_debug.put_line
2014: ( g_pkg_name
2015: || '.'
2016: || l_api_name

Line 2013: gme_debug.put_line

2009: END IF;
2010:
2011: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2012: IF g_debug <= gme_debug.g_log_statement THEN
2013: gme_debug.put_line
2014: ( g_pkg_name
2015: || '.'
2016: || l_api_name
2017: || 'Error is :'

Line 2024: IF g_debug <= gme_debug.g_log_statement THEN

2020: RAISE query_reservation_error;
2021: END IF;
2022:
2023: IF NVL(l_rsv_count,0) <= 0 THEN
2024: IF g_debug <= gme_debug.g_log_statement THEN
2025: gme_debug.put_line
2026: ( g_pkg_name
2027: || '.'
2028: || l_api_name

Line 2025: gme_debug.put_line

2021: END IF;
2022:
2023: IF NVL(l_rsv_count,0) <= 0 THEN
2024: IF g_debug <= gme_debug.g_log_statement THEN
2025: gme_debug.put_line
2026: ( g_pkg_name
2027: || '.'
2028: || l_api_name
2029: || ' No reservations against batch as a source of supply so RETURN now ');

Line 2049: IF g_debug <= gme_debug.g_log_procedure THEN

2045: , X_return_status => x_return_status
2046: , X_msg_cont => x_msg_count
2047: , X_msg_data => x_msg_data );
2048:
2049: IF g_debug <= gme_debug.g_log_procedure THEN
2050: gme_debug.put_line ( g_pkg_name || '.'
2051: || l_api_name
2052: || ' after calling notify_CSR status is '
2053: || x_return_status );

Line 2050: gme_debug.put_line ( g_pkg_name || '.'

2046: , X_msg_cont => x_msg_count
2047: , X_msg_data => x_msg_data );
2048:
2049: IF g_debug <= gme_debug.g_log_procedure THEN
2050: gme_debug.put_line ( g_pkg_name || '.'
2051: || l_api_name
2052: || ' after calling notify_CSR status is '
2053: || x_return_status );
2054: END IF;

Line 2070: IF g_debug <= gme_debug.g_log_procedure THEN

2066: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
2067: RAISE notify_CSR_err;
2068: END IF;
2069:
2070: IF g_debug <= gme_debug.g_log_procedure THEN
2071: gme_debug.put_line ( g_pkg_name || '.'
2072: || l_api_name
2073: || ' about to invoke delete_reservation for reservation id '
2074: || l_rsv_rec.reservation_id);

Line 2071: gme_debug.put_line ( g_pkg_name || '.'

2067: RAISE notify_CSR_err;
2068: END IF;
2069:
2070: IF g_debug <= gme_debug.g_log_procedure THEN
2071: gme_debug.put_line ( g_pkg_name || '.'
2072: || l_api_name
2073: || ' about to invoke delete_reservation for reservation id '
2074: || l_rsv_rec.reservation_id);
2075: END IF;

Line 2087: IF g_debug <= gme_debug.g_log_procedure THEN

2083: , p_rsv_rec => l_rsv_rec
2084: , p_serial_number => l_dummy_sn
2085: );
2086:
2087: IF g_debug <= gme_debug.g_log_procedure THEN
2088: gme_debug.put_line ( g_pkg_name || '.'
2089: || l_api_name
2090: || ' after calling delete_reservation status is '
2091: || x_return_status );

Line 2088: gme_debug.put_line ( g_pkg_name || '.'

2084: , p_serial_number => l_dummy_sn
2085: );
2086:
2087: IF g_debug <= gme_debug.g_log_procedure THEN
2088: gme_debug.put_line ( g_pkg_name || '.'
2089: || l_api_name
2090: || ' after calling delete_reservation status is '
2091: || x_return_status );
2092: END IF;

Line 2101: IF g_debug <= gme_debug.g_log_procedure THEN

2097: RAISE delete_reservation_err;
2098: END IF;
2099:
2100: END LOOP;
2101: IF g_debug <= gme_debug.g_log_procedure THEN
2102: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2103: END IF;
2104:
2105: EXCEPTION

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

2098: END IF;
2099:
2100: END LOOP;
2101: IF g_debug <= gme_debug.g_log_procedure THEN
2102: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2103: END IF;
2104:
2105: EXCEPTION
2106: WHEN delete_reservation_err THEN

Line 2107: IF (g_debug <= gme_debug.g_log_error) THEN

2103: END IF;
2104:
2105: EXCEPTION
2106: WHEN delete_reservation_err THEN
2107: IF (g_debug <= gme_debug.g_log_error) THEN
2108: gme_debug.put_line
2109: ( 'inv_reservation_pub.delete_reservation failure ');
2110: gme_debug.put_line ('error message is ' || x_msg_data);
2111: END IF;

Line 2108: gme_debug.put_line

2104:
2105: EXCEPTION
2106: WHEN delete_reservation_err THEN
2107: IF (g_debug <= gme_debug.g_log_error) THEN
2108: gme_debug.put_line
2109: ( 'inv_reservation_pub.delete_reservation failure ');
2110: gme_debug.put_line ('error message is ' || x_msg_data);
2111: END IF;
2112: WHEN notify_CSR_err THEN

Line 2110: gme_debug.put_line ('error message is ' || x_msg_data);

2106: WHEN delete_reservation_err THEN
2107: IF (g_debug <= gme_debug.g_log_error) THEN
2108: gme_debug.put_line
2109: ( 'inv_reservation_pub.delete_reservation failure ');
2110: gme_debug.put_line ('error message is ' || x_msg_data);
2111: END IF;
2112: WHEN notify_CSR_err THEN
2113: IF (g_debug <= gme_debug.g_log_error) THEN
2114: gme_debug.put_line

Line 2113: IF (g_debug <= gme_debug.g_log_error) THEN

2109: ( 'inv_reservation_pub.delete_reservation failure ');
2110: gme_debug.put_line ('error message is ' || x_msg_data);
2111: END IF;
2112: WHEN notify_CSR_err THEN
2113: IF (g_debug <= gme_debug.g_log_error) THEN
2114: gme_debug.put_line
2115: ( 'gme_supply_res_pvt.notify_CSR failure ');
2116: gme_debug.put_line ('error message is ' || x_msg_data);
2117: END IF;

Line 2114: gme_debug.put_line

2110: gme_debug.put_line ('error message is ' || x_msg_data);
2111: END IF;
2112: WHEN notify_CSR_err THEN
2113: IF (g_debug <= gme_debug.g_log_error) THEN
2114: gme_debug.put_line
2115: ( 'gme_supply_res_pvt.notify_CSR failure ');
2116: gme_debug.put_line ('error message is ' || x_msg_data);
2117: END IF;
2118: WHEN matl_fetch_error THEN

Line 2116: gme_debug.put_line ('error message is ' || x_msg_data);

2112: WHEN notify_CSR_err THEN
2113: IF (g_debug <= gme_debug.g_log_error) THEN
2114: gme_debug.put_line
2115: ( 'gme_supply_res_pvt.notify_CSR failure ');
2116: gme_debug.put_line ('error message is ' || x_msg_data);
2117: END IF;
2118: WHEN matl_fetch_error THEN
2119: x_return_status := fnd_api.g_ret_sts_error;
2120: WHEN OTHERS THEN

Line 2121: IF g_debug <= gme_debug.g_log_unexpected THEN

2117: END IF;
2118: WHEN matl_fetch_error THEN
2119: x_return_status := fnd_api.g_ret_sts_error;
2120: WHEN OTHERS THEN
2121: IF g_debug <= gme_debug.g_log_unexpected THEN
2122: gme_debug.put_line ( 'When others exception in '
2123: || g_pkg_name
2124: || '.'
2125: || l_api_name

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

2118: WHEN matl_fetch_error THEN
2119: x_return_status := fnd_api.g_ret_sts_error;
2120: WHEN OTHERS THEN
2121: IF g_debug <= gme_debug.g_log_unexpected THEN
2122: gme_debug.put_line ( 'When others exception in '
2123: || g_pkg_name
2124: || '.'
2125: || l_api_name
2126: || ' Error is '