eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_LAYERS dependencies on GME_DEBUG

Line 77: IF g_debug <= gme_debug.g_log_procedure THEN

73:
74: BEGIN
75: x_return_status := FND_API.G_RET_STS_SUCCESS ;
76:
77: IF g_debug <= gme_debug.g_log_procedure THEN
78: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
79: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||
80: p_tran_rec.inventory_item_id ||'/'|| p_tran_rec.organization_id || '/' ||
81: p_tran_rec.lot_number ||'/'|| p_tran_rec.transaction_id ||'/'|| p_tran_rec.reverse_id ||

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

74: BEGIN
75: x_return_status := FND_API.G_RET_STS_SUCCESS ;
76:
77: IF g_debug <= gme_debug.g_log_procedure THEN
78: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
79: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||
80: p_tran_rec.inventory_item_id ||'/'|| p_tran_rec.organization_id || '/' ||
81: p_tran_rec.lot_number ||'/'|| p_tran_rec.transaction_id ||'/'|| p_tran_rec.reverse_id ||
82: ' line_type: ' || p_tran_rec.line_type);

Line 79: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||

75: x_return_status := FND_API.G_RET_STS_SUCCESS ;
76:
77: IF g_debug <= gme_debug.g_log_procedure THEN
78: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
79: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||
80: p_tran_rec.inventory_item_id ||'/'|| p_tran_rec.organization_id || '/' ||
81: p_tran_rec.lot_number ||'/'|| p_tran_rec.transaction_id ||'/'|| p_tran_rec.reverse_id ||
82: ' line_type: ' || p_tran_rec.line_type);
83: gme_debug.put_line ('pri Qty: ' || p_tran_rec.primary_quantity || ' ' || p_tran_rec.primary_uom ||

Line 83: gme_debug.put_line ('pri Qty: ' || p_tran_rec.primary_quantity || ' ' || p_tran_rec.primary_uom ||

79: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||
80: p_tran_rec.inventory_item_id ||'/'|| p_tran_rec.organization_id || '/' ||
81: p_tran_rec.lot_number ||'/'|| p_tran_rec.transaction_id ||'/'|| p_tran_rec.reverse_id ||
82: ' line_type: ' || p_tran_rec.line_type);
83: gme_debug.put_line ('pri Qty: ' || p_tran_rec.primary_quantity || ' ' || p_tran_rec.primary_uom ||
84: ' doc qty: ' || p_tran_rec.doc_qty || ' ' || p_tran_rec.doc_uom);
85: END IF;
86:
87: -- Possible validations

Line 138: IF g_debug <= gme_debug.g_log_procedure THEN

134: END;
135: END IF;
136:
137: IF (l_doc_qty IS NULL ) THEN
138: IF g_debug <= gme_debug.g_log_procedure THEN
139: gme_debug.put_line ('No doc quantity specified for the layer');
140: END IF;
141: x_return_status := FND_API.G_RET_STS_ERROR ;
142: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');

Line 139: gme_debug.put_line ('No doc quantity specified for the layer');

135: END IF;
136:
137: IF (l_doc_qty IS NULL ) THEN
138: IF g_debug <= gme_debug.g_log_procedure THEN
139: gme_debug.put_line ('No doc quantity specified for the layer');
140: END IF;
141: x_return_status := FND_API.G_RET_STS_ERROR ;
142: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');
143: FND_MSG_PUB.Add;

Line 152: IF g_debug <= gme_debug.g_log_statement THEN

148:
149: -- Create the incoming layer
150: SELECT gmf_layer_id_s.nextval INTO l_layer_id FROM DUAL;
151:
152: IF g_debug <= gme_debug.g_log_statement THEN
153: gme_debug.put_line ('creating incoming layer: ' || l_layer_id);
154: END IF;
155:
156: INSERT INTO gmf_incoming_material_layers(

Line 153: gme_debug.put_line ('creating incoming layer: ' || l_layer_id);

149: -- Create the incoming layer
150: SELECT gmf_layer_id_s.nextval INTO l_layer_id FROM DUAL;
151:
152: IF g_debug <= gme_debug.g_log_statement THEN
153: gme_debug.put_line ('creating incoming layer: ' || l_layer_id);
154: END IF;
155:
156: INSERT INTO gmf_incoming_material_layers(
157: layer_id,

Line 211: IF g_debug <= gme_debug.g_log_statement THEN

207: WHERE batch_id = p_tran_rec.transaction_source_id
208: AND delete_mark = 0;
209:
210: IF l_req_count = 0 THEN
211: IF g_debug <= gme_debug.g_log_statement THEN
212: gme_debug.put_line ('creating batch requirements before creating VIB details');
213: END IF;
214: -- Create the requirements
215: GMF_VIB.Create_Batch_Requirements(

Line 212: gme_debug.put_line ('creating batch requirements before creating VIB details');

208: AND delete_mark = 0;
209:
210: IF l_req_count = 0 THEN
211: IF g_debug <= gme_debug.g_log_statement THEN
212: gme_debug.put_line ('creating batch requirements before creating VIB details');
213: END IF;
214: -- Create the requirements
215: GMF_VIB.Create_Batch_Requirements(
216: 1.0,

Line 228: IF g_debug <= gme_debug.g_log_statement THEN

224: RETURN;
225: END IF;
226: END IF;
227:
228: IF g_debug <= gme_debug.g_log_statement THEN
229: gme_debug.put_line ('now calling Create_VIB_Details');
230: END IF;
231:
232: -- Now generate the VIB details for this product transaction.

Line 229: gme_debug.put_line ('now calling Create_VIB_Details');

225: END IF;
226: END IF;
227:
228: IF g_debug <= gme_debug.g_log_statement THEN
229: gme_debug.put_line ('now calling Create_VIB_Details');
230: END IF;
231:
232: -- Now generate the VIB details for this product transaction.
233:

Line 247: IF g_debug <= gme_debug.g_log_statement THEN

243: x_return_status,
244: x_msg_count,
245: x_msg_data);
246:
247: IF g_debug <= gme_debug.g_log_statement THEN
248: gme_debug.put_line ('done creating vib details. status/msg: ' || x_return_status ||'/'|| x_msg_data);
249: END IF;
250:
251: END IF; -- PK B 15888374

Line 248: gme_debug.put_line ('done creating vib details. status/msg: ' || x_return_status ||'/'|| x_msg_data);

244: x_msg_count,
245: x_msg_data);
246:
247: IF g_debug <= gme_debug.g_log_statement THEN
248: gme_debug.put_line ('done creating vib details. status/msg: ' || x_return_status ||'/'|| x_msg_data);
249: END IF;
250:
251: END IF; -- PK B 15888374
252:

Line 253: IF g_debug <= gme_debug.g_log_procedure THEN

249: END IF;
250:
251: END IF; -- PK B 15888374
252:
253: IF g_debug <= gme_debug.g_log_procedure THEN
254: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
255: END IF;
256:
257: EXCEPTION

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

250:
251: END IF; -- PK B 15888374
252:
253: IF g_debug <= gme_debug.g_log_procedure THEN
254: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
255: END IF;
256:
257: EXCEPTION
258: WHEN OTHERS THEN

Line 259: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);

255: END IF;
256:
257: EXCEPTION
258: WHEN OTHERS THEN
259: gme_debug.put_line ('Exiting api (thru when others) ' || g_pkg_name || '.' || l_api_name);
260: FND_MESSAGE.SET_NAME('GMI','GMI_DXFR_SQL_ERROR');
261: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
262: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM);
263: FND_MSG_PUB.Add;

Line 346: IF g_debug <= gme_debug.g_log_procedure THEN

342:
343: BEGIN
344: x_return_status := FND_API.G_RET_STS_SUCCESS ;
345:
346: IF g_debug <= gme_debug.g_log_procedure THEN
347: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
348: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||
349: p_tran_rec.inventory_item_id ||'/'|| p_tran_rec.organization_id || '/' ||
350: p_tran_rec.lot_number ||'/'|| p_tran_rec.transaction_id ||'/'|| p_tran_rec.reverse_id ||

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

343: BEGIN
344: x_return_status := FND_API.G_RET_STS_SUCCESS ;
345:
346: IF g_debug <= gme_debug.g_log_procedure THEN
347: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
348: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||
349: p_tran_rec.inventory_item_id ||'/'|| p_tran_rec.organization_id || '/' ||
350: p_tran_rec.lot_number ||'/'|| p_tran_rec.transaction_id ||'/'|| p_tran_rec.reverse_id ||
351: ' line_type: ' || p_tran_rec.line_type);

Line 348: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||

344: x_return_status := FND_API.G_RET_STS_SUCCESS ;
345:
346: IF g_debug <= gme_debug.g_log_procedure THEN
347: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
348: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||
349: p_tran_rec.inventory_item_id ||'/'|| p_tran_rec.organization_id || '/' ||
350: p_tran_rec.lot_number ||'/'|| p_tran_rec.transaction_id ||'/'|| p_tran_rec.reverse_id ||
351: ' line_type: ' || p_tran_rec.line_type);
352: gme_debug.put_line ('pri Qty: ' || p_tran_rec.primary_quantity || ' ' || p_tran_rec.primary_uom ||

Line 352: gme_debug.put_line ('pri Qty: ' || p_tran_rec.primary_quantity || ' ' || p_tran_rec.primary_uom ||

348: gme_debug.put_line ('processing batch: ' || p_tran_rec.transaction_source_id || ' item/org/lot/txnId/reverseId: ' ||
349: p_tran_rec.inventory_item_id ||'/'|| p_tran_rec.organization_id || '/' ||
350: p_tran_rec.lot_number ||'/'|| p_tran_rec.transaction_id ||'/'|| p_tran_rec.reverse_id ||
351: ' line_type: ' || p_tran_rec.line_type);
352: gme_debug.put_line ('pri Qty: ' || p_tran_rec.primary_quantity || ' ' || p_tran_rec.primary_uom ||
353: ' doc qty: ' || p_tran_rec.doc_qty || ' ' || p_tran_rec.doc_uom);
354: END IF;
355:
356: -- Possible validations

Line 372: gme_debug.put_line ('Error-GMF: Only Ingredients and By-Products allowed for outgoing layers');

368: RETURN;
369: END IF;
370: IF (p_tran_rec.line_type <> -1 and p_tran_rec.line_type <> 2) THEN
371: x_return_status := FND_API.G_RET_STS_ERROR ;
372: gme_debug.put_line ('Error-GMF: Only Ingredients and By-Products allowed for outgoing layers');
373: FND_MESSAGE.SET_NAME('GMF', 'GMF_NON_ING_TRANS');
374: FND_MSG_PUB.Add;
375: RETURN;
376: END IF;

Line 407: IF g_debug <= gme_debug.g_log_procedure THEN

403: END IF;
404:
405: IF (l_doc_qty IS NULL ) THEN
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: IF g_debug <= gme_debug.g_log_procedure THEN
408: gme_debug.put_line ('No doc quantity specified for the layer');
409: END IF;
410: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');
411: FND_MSG_PUB.Add;

Line 408: gme_debug.put_line ('No doc quantity specified for the layer');

404:
405: IF (l_doc_qty IS NULL ) THEN
406: x_return_status := FND_API.G_RET_STS_ERROR ;
407: IF g_debug <= gme_debug.g_log_procedure THEN
408: gme_debug.put_line ('No doc quantity specified for the layer');
409: END IF;
410: FND_MESSAGE.SET_NAME('GMF', 'GMF_NO_DOC_QTY_FOR_LAYER');
411: FND_MSG_PUB.Add;
412: RETURN;

Line 430: IF g_debug <= gme_debug.g_log_statement THEN

426: -- If the reverse transaction is alrady used in
427: -- VIB details, get the quantity used in VIB details.
428: -- We need to leave that much qty to reverse those VIB details later.
429:
430: IF g_debug <= gme_debug.g_log_statement THEN
431: gme_debug.put_line ('Reversal. get the quantity used in VIB details, if any.');
432: END IF;
433:
434: BEGIN

Line 431: gme_debug.put_line ('Reversal. get the quantity used in VIB details, if any.');

427: -- VIB details, get the quantity used in VIB details.
428: -- We need to leave that much qty to reverse those VIB details later.
429:
430: IF g_debug <= gme_debug.g_log_statement THEN
431: gme_debug.put_line ('Reversal. get the quantity used in VIB details, if any.');
432: END IF;
433:
434: BEGIN
435:

Line 448: IF g_debug <= gme_debug.g_log_statement THEN

444: nvl(l.lot_number,'X')= nvl(p_tran_rec.lot_number,'X') and
445: l.layer_id = v.consume_layer_id (+)
446: GROUP BY l.ROWID;
447:
448: IF g_debug <= gme_debug.g_log_statement THEN
449: gme_debug.put_line ('Reversal. quantity already used in VIB details is: ' ||
450: l_rev_consume_ib_doc_qty);
451: END IF;
452:

Line 449: gme_debug.put_line ('Reversal. quantity already used in VIB details is: ' ||

445: l.layer_id = v.consume_layer_id (+)
446: GROUP BY l.ROWID;
447:
448: IF g_debug <= gme_debug.g_log_statement THEN
449: gme_debug.put_line ('Reversal. quantity already used in VIB details is: ' ||
450: l_rev_consume_ib_doc_qty);
451: END IF;
452:
453: l_remaining_ib_doc_qty := l_rev_consume_ib_doc_qty;

Line 469: IF g_debug <= gme_debug.g_log_statement THEN

465: NULL;
466: END;
467: END IF;
468:
469: IF g_debug <= gme_debug.g_log_statement THEN
470: gme_debug.put_line ('l_remaining_ib_doc_qty: ' || l_remaining_ib_doc_qty);
471: END IF;
472:
473: IF l_remaining_ib_doc_qty > 0 THEN

Line 470: gme_debug.put_line ('l_remaining_ib_doc_qty: ' || l_remaining_ib_doc_qty);

466: END;
467: END IF;
468:
469: IF g_debug <= gme_debug.g_log_statement THEN
470: gme_debug.put_line ('l_remaining_ib_doc_qty: ' || l_remaining_ib_doc_qty);
471: END IF;
472:
473: IF l_remaining_ib_doc_qty > 0 THEN
474: -- If ingredients were consumed after the product was yielded, there are

Line 479: IF g_debug <= gme_debug.g_log_statement THEN

475: -- VIB details pointing to the NULL consumption layers. If possible,
476: -- Update them to consume from this layer. This is done only if the product
477: -- Layer is not posted to subledgerand the cost is not frozen.
478:
479: IF g_debug <= gme_debug.g_log_statement THEN
480: gme_debug.put_line ('getting null consumption layers from VIB details, if any');
481: END IF;
482:
483: FOR n IN c_null_vib_rows LOOP

Line 480: gme_debug.put_line ('getting null consumption layers from VIB details, if any');

476: -- Update them to consume from this layer. This is done only if the product
477: -- Layer is not posted to subledgerand the cost is not frozen.
478:
479: IF g_debug <= gme_debug.g_log_statement THEN
480: gme_debug.put_line ('getting null consumption layers from VIB details, if any');
481: END IF;
482:
483: FOR n IN c_null_vib_rows LOOP
484:

Line 485: IF g_debug <= gme_debug.g_log_statement THEN

481: END IF;
482:
483: FOR n IN c_null_vib_rows LOOP
484:
485: IF g_debug <= gme_debug.g_log_statement THEN
486: gme_debug.put_line ('found null consumption layers. prodLayer/ConsLayer/lineType: ' ||
487: n.prod_layer_id||'/'||n.consume_layer_id||'/'||n.line_type);
488: END IF;
489:

Line 486: gme_debug.put_line ('found null consumption layers. prodLayer/ConsLayer/lineType: ' ||

482:
483: FOR n IN c_null_vib_rows LOOP
484:
485: IF g_debug <= gme_debug.g_log_statement THEN
486: gme_debug.put_line ('found null consumption layers. prodLayer/ConsLayer/lineType: ' ||
487: n.prod_layer_id||'/'||n.consume_layer_id||'/'||n.line_type);
488: END IF;
489:
490: BEGIN

Line 519: IF g_debug <= gme_debug.g_log_statement THEN

515:
516: -- If ingredient qty is more then what is needed.
517: IF n.consume_ib_doc_qty <= l_remaining_ib_doc_qty THEN
518:
519: IF g_debug <= gme_debug.g_log_statement THEN
520: gme_debug.put_line ('If ingredient qty is more then what is needed.');
521: END IF;
522:
523: UPDATE gmf_batch_vib_details

Line 520: gme_debug.put_line ('If ingredient qty is more then what is needed.');

516: -- If ingredient qty is more then what is needed.
517: IF n.consume_ib_doc_qty <= l_remaining_ib_doc_qty THEN
518:
519: IF g_debug <= gme_debug.g_log_statement THEN
520: gme_debug.put_line ('If ingredient qty is more then what is needed.');
521: END IF;
522:
523: UPDATE gmf_batch_vib_details
524: SET consume_layer_id = l_layer_id,

Line 535: IF g_debug <= gme_debug.g_log_statement THEN

531: -- Split the row into 2.
532: -- Create another row with NULL layer for remaining quantity
533: -- First convert the consume quantity to primary UM.
534:
535: IF g_debug <= gme_debug.g_log_statement THEN
536: gme_debug.put_line ('If ingredient qty is less then what is needed...split the row into 2');
537: END IF;
538:
539: l_consume_ib_doc_qty := n.consume_ib_doc_qty - l_remaining_ib_doc_qty;

Line 536: gme_debug.put_line ('If ingredient qty is less then what is needed...split the row into 2');

532: -- Create another row with NULL layer for remaining quantity
533: -- First convert the consume quantity to primary UM.
534:
535: IF g_debug <= gme_debug.g_log_statement THEN
536: gme_debug.put_line ('If ingredient qty is less then what is needed...split the row into 2');
537: END IF;
538:
539: l_consume_ib_doc_qty := n.consume_ib_doc_qty - l_remaining_ib_doc_qty;
540:

Line 614: IF g_debug <= gme_debug.g_log_statement THEN

610: NULL; -- Skip to the next row
611: END;
612: END LOOP;
613:
614: IF g_debug <= gme_debug.g_log_statement THEN
615: gme_debug.put_line ('done processing consumption layers from VIB details');
616: END IF;
617:
618: END IF;

Line 615: gme_debug.put_line ('done processing consumption layers from VIB details');

611: END;
612: END LOOP;
613:
614: IF g_debug <= gme_debug.g_log_statement THEN
615: gme_debug.put_line ('done processing consumption layers from VIB details');
616: END IF;
617:
618: END IF;
619:

Line 620: IF g_debug <= gme_debug.g_log_statement THEN

616: END IF;
617:
618: END IF;
619:
620: IF g_debug <= gme_debug.g_log_statement THEN
621: gme_debug.put_line ('creating new outgoing layers...');
622: END IF;
623:
624: INSERT INTO gmf_outgoing_material_layers(

Line 621: gme_debug.put_line ('creating new outgoing layers...');

617:
618: END IF;
619:
620: IF g_debug <= gme_debug.g_log_statement THEN
621: gme_debug.put_line ('creating new outgoing layers...');
622: END IF;
623:
624: INSERT INTO gmf_outgoing_material_layers(
625: layer_id,

Line 653: IF g_debug <= gme_debug.g_log_statement THEN

649: p_tran_rec.last_updated_by,
650: sysdate,
651: p_tran_rec.last_update_login);
652:
653: IF g_debug <= gme_debug.g_log_statement THEN
654: gme_debug.put_line (sql%ROWCOUNT || ' rows inserted');
655: END IF;
656:
657: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 654: gme_debug.put_line (sql%ROWCOUNT || ' rows inserted');

650: sysdate,
651: p_tran_rec.last_update_login);
652:
653: IF g_debug <= gme_debug.g_log_statement THEN
654: gme_debug.put_line (sql%ROWCOUNT || ' rows inserted');
655: END IF;
656:
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:

Line 660: IF g_debug <= gme_debug.g_log_procedure THEN

656:
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659:
660: IF g_debug <= gme_debug.g_log_procedure THEN
661: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
662: END IF;
663:
664: EXCEPTION

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

657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659:
660: IF g_debug <= gme_debug.g_log_procedure THEN
661: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
662: END IF;
663:
664: EXCEPTION
665: WHEN OTHERS THEN

Line 746: IF g_debug <= gme_debug.g_log_procedure THEN

742: BEGIN
743: x_return_status := FND_API.G_RET_STS_SUCCESS ;
744:
745:
746: IF g_debug <= gme_debug.g_log_procedure THEN
747: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
748: gme_debug.put_line ('processing batch: ' || p_rsrc_rec.doc_id || ' lineID: ' || p_rsrc_rec.line_id ||
749: ' rsrc/org/txnId/reverseId: ' || p_rsrc_rec.resources ||'/'|| p_rsrc_rec.organization_id || '/' ||
750: p_rsrc_rec.poc_trans_id ||'/'|| p_rsrc_rec.reverse_id);

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

743: x_return_status := FND_API.G_RET_STS_SUCCESS ;
744:
745:
746: IF g_debug <= gme_debug.g_log_procedure THEN
747: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
748: gme_debug.put_line ('processing batch: ' || p_rsrc_rec.doc_id || ' lineID: ' || p_rsrc_rec.line_id ||
749: ' rsrc/org/txnId/reverseId: ' || p_rsrc_rec.resources ||'/'|| p_rsrc_rec.organization_id || '/' ||
750: p_rsrc_rec.poc_trans_id ||'/'|| p_rsrc_rec.reverse_id);
751: gme_debug.put_line ('transQty: ' || p_rsrc_rec.resource_usage || ' ' || p_rsrc_rec.trans_qty_um ||

Line 748: gme_debug.put_line ('processing batch: ' || p_rsrc_rec.doc_id || ' lineID: ' || p_rsrc_rec.line_id ||

744:
745:
746: IF g_debug <= gme_debug.g_log_procedure THEN
747: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
748: gme_debug.put_line ('processing batch: ' || p_rsrc_rec.doc_id || ' lineID: ' || p_rsrc_rec.line_id ||
749: ' rsrc/org/txnId/reverseId: ' || p_rsrc_rec.resources ||'/'|| p_rsrc_rec.organization_id || '/' ||
750: p_rsrc_rec.poc_trans_id ||'/'|| p_rsrc_rec.reverse_id);
751: gme_debug.put_line ('transQty: ' || p_rsrc_rec.resource_usage || ' ' || p_rsrc_rec.trans_qty_um ||
752: ' doc qty: ' || p_doc_qty || ' ' || p_doc_um);

Line 751: gme_debug.put_line ('transQty: ' || p_rsrc_rec.resource_usage || ' ' || p_rsrc_rec.trans_qty_um ||

747: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
748: gme_debug.put_line ('processing batch: ' || p_rsrc_rec.doc_id || ' lineID: ' || p_rsrc_rec.line_id ||
749: ' rsrc/org/txnId/reverseId: ' || p_rsrc_rec.resources ||'/'|| p_rsrc_rec.organization_id || '/' ||
750: p_rsrc_rec.poc_trans_id ||'/'|| p_rsrc_rec.reverse_id);
751: gme_debug.put_line ('transQty: ' || p_rsrc_rec.resource_usage || ' ' || p_rsrc_rec.trans_qty_um ||
752: ' doc qty: ' || p_doc_qty || ' ' || p_doc_um);
753: END IF;
754:
755: -- Possible validations

Line 961: IF g_debug <= gme_debug.g_log_procedure THEN

957: p_rsrc_rec.last_update_login);
958:
959: x_return_status := FND_API.G_RET_STS_SUCCESS;
960:
961: IF g_debug <= gme_debug.g_log_procedure THEN
962: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
963: END IF;
964:
965: EXCEPTION

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

958:
959: x_return_status := FND_API.G_RET_STS_SUCCESS;
960:
961: IF g_debug <= gme_debug.g_log_procedure THEN
962: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
963: END IF;
964:
965: EXCEPTION
966: WHEN OTHERS THEN