DBA Data[Home] [Help]

APPS.GMD_LCF_FETCH_PKG dependencies on GMD_DEBUG

Line 1022: gmd_debug.log_initialize('LCF');

1018: l_value NUMBER;
1019: l_print_value VARCHAR2(40);
1020:
1021: BEGIN
1022: gmd_debug.log_initialize('LCF');
1023: --Load formulation specification details
1024: OPEN Cur_get_formulation;
1025: FETCH Cur_get_formulation INTO l_formulation;
1026: CLOSE Cur_get_formulation;

Line 1279: gmd_debug.put_line(l_print_line);

1275: l_value := ROUND(l_lt_matrix(i)(j),5);
1276: l_print_value := RPAD(TO_CHAR(l_value, '9990.99999'), 10);
1277: l_print_line := l_print_line||l_print_value||' ';
1278: END LOOP;
1279: gmd_debug.put_line(l_print_line);
1280: END LOOP; */
1281:
1282: --After builiding the matrix call the lcf engine routine.
1283: gmd_lcf_engine.evaluate (P_spec_id => V_formulation_spec_id,

Line 1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);

1329: select *
1330: from gmd_lcf_details_gtmp;
1331: BEGIN
1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);

Line 1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);

1330: from gmd_lcf_details_gtmp;
1331: BEGIN
1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);

Line 1335: gmd_debug.put_line('line_id'||l_record.line_id);

1331: BEGIN
1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);

Line 1336: gmd_debug.put_line('qty'||l_record.qty);

1332: FOR L_RECORD IN CUR_REC LOOP
1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);

Line 1337: gmd_debug.put_line('min_qty'||l_record.min_qty);

1333: gmd_debug.put_line('item_no'||l_record.concatenated_segments);
1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);

Line 1338: gmd_debug.put_line('max_qty'||l_record.max_qty);

1334: gmd_debug.put_line('detail_uom'||l_record.detail_uom);
1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);

Line 1339: gmd_debug.put_line('entity'||l_record.entity_id);

1335: gmd_debug.put_line('line_id'||l_record.line_id);
1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);

Line 1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);

1336: gmd_debug.put_line('qty'||l_record.qty);
1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1344: END LOOP;

Line 1341: gmd_debug.put_line('massuom'||l_record.mass_uom);

1337: gmd_debug.put_line('min_qty'||l_record.min_qty);
1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1344: END LOOP;
1345: END temp_dump;

Line 1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);

1338: gmd_debug.put_line('max_qty'||l_record.max_qty);
1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1344: END LOOP;
1345: END temp_dump;
1346:

Line 1343: gmd_debug.put_line('voluom'||l_record.vol_uom);

1339: gmd_debug.put_line('entity'||l_record.entity_id);
1340: gmd_debug.put_line('qtymass'||l_record.qty_mass);
1341: gmd_debug.put_line('massuom'||l_record.mass_uom);
1342: gmd_debug.put_line('qtyvol'||l_record.qty_vol);
1343: gmd_debug.put_line('voluom'||l_record.vol_uom);
1344: END LOOP;
1345: END temp_dump;
1346:
1347: procedure temp_param IS

Line 1354: gmd_debug.put_line('item lineid techparmname value');

1350: from gmd_lcf_tech_data_gtmp a, gmd_lcf_details_gtmp b
1351: where a.line_id= b.line_id;
1352: begin
1353: FOR L_REC IN CUR_REC1 LOOP
1354: gmd_debug.put_line('item lineid techparmname value');
1355: gmd_debug.put_line(l_rec.concatenated_segments|| '-' ||l_rec.line_id|| '-' ||l_rec.tech_parm_name|| '-' ||l_rec.value);
1356: END LOOP;
1357: end temp_param;
1358:

Line 1355: gmd_debug.put_line(l_rec.concatenated_segments|| '-' ||l_rec.line_id|| '-' ||l_rec.tech_parm_name|| '-' ||l_rec.value);

1351: where a.line_id= b.line_id;
1352: begin
1353: FOR L_REC IN CUR_REC1 LOOP
1354: gmd_debug.put_line('item lineid techparmname value');
1355: gmd_debug.put_line(l_rec.concatenated_segments|| '-' ||l_rec.line_id|| '-' ||l_rec.tech_parm_name|| '-' ||l_rec.value);
1356: END LOOP;
1357: end temp_param;
1358:
1359: procedure temp_category IS

Line 1365: gmd_debug.put_line('category lineid value_ind');

1361: select *
1362: from gmd_lcf_category_dtl_gtmp;
1363: begin
1364: FOR L_REC IN CUR_REC1 LOOP
1365: gmd_debug.put_line('category lineid value_ind');
1366: gmd_debug.put_line(l_rec.category_id|| '-' ||l_rec.line_id|| '-' ||l_rec.value_ind);
1367: END LOOP;
1368: end temp_category;
1369:

Line 1366: gmd_debug.put_line(l_rec.category_id|| '-' ||l_rec.line_id|| '-' ||l_rec.value_ind);

1362: from gmd_lcf_category_dtl_gtmp;
1363: begin
1364: FOR L_REC IN CUR_REC1 LOOP
1365: gmd_debug.put_line('category lineid value_ind');
1366: gmd_debug.put_line(l_rec.category_id|| '-' ||l_rec.line_id|| '-' ||l_rec.value_ind);
1367: END LOOP;
1368: end temp_category;
1369:
1370: