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.GMD_QMSMC dependencies on GMD_DEBUG

Line 450: gmd_debug.put_line ('SampleCreation WF. VERIFY_EVENT '); /* 4576699 */

446: FROM fnd_user
447: WHERE user_id = x_user_id;
448:
449: BEGIN
450: gmd_debug.put_line ('SampleCreation WF. VERIFY_EVENT '); /* 4576699 */
451:
452:
453: IF (l_debug = 'Y') THEN
454: gmd_debug.log_initialize('SampleCreation');

Line 454: gmd_debug.log_initialize('SampleCreation');

450: gmd_debug.put_line ('SampleCreation WF. VERIFY_EVENT '); /* 4576699 */
451:
452:
453: IF (l_debug = 'Y') THEN
454: gmd_debug.log_initialize('SampleCreation');
455: END IF;
456:
457: IF (l_debug = 'Y') THEN
458: gmd_debug.put_line('Event Name ' || l_event_name);

Line 458: gmd_debug.put_line('Event Name ' || l_event_name);

454: gmd_debug.log_initialize('SampleCreation');
455: END IF;
456:
457: IF (l_debug = 'Y') THEN
458: gmd_debug.put_line('Event Name ' || l_event_name);
459: gmd_debug.put_line('Event Key ' || l_event_key);
460:
461:
462: END IF;

Line 459: gmd_debug.put_line('Event Key ' || l_event_key);

455: END IF;
456:
457: IF (l_debug = 'Y') THEN
458: gmd_debug.put_line('Event Name ' || l_event_name);
459: gmd_debug.put_line('Event Key ' || l_event_key);
460:
461:
462: END IF;
463:

Line 473: gmd_debug.put_line ('Inventory '); /* 4576699 */

469:
470: IF ((l_event_name = 'oracle.apps.gmd.inventory.created')
471: OR ( l_event_name = 'oracle.apps.gmi.inventory.created')) THEN
472: l_transaction_type:='INVENTORY_TRANSACTION';
473: gmd_debug.put_line ('Inventory '); /* 4576699 */
474:
475: OPEN inv;
476: FETCH inv INTO l_inventory_item_id,
477: l_revision,

Line 523: gmd_debug.put_line ('Lot Expiry Date ') ;/* 4576699 */

519: -- Bug 4165704:event name changed
520: -- ELSIF l_event_name = 'oracle.apps.gmd.lotexpiry')
521:
522: ELSIF ( l_event_name = 'oracle.apps.gmi.lotexpirydate.update') THEN
523: gmd_debug.put_line ('Lot Expiry Date ') ;/* 4576699 */
524:
525: l_transaction_type:='LOTEXPIRY_TRANSACTION';
526: OPEN lot;
527: Fetch lot INTO l_inventory_item_id,

Line 556: gmd_debug.put_line ('Lot Retest Date ') ;/* 4576699 */

552:
553: -- Bug 4165704:event name changed
554: -- ELSIF l_event_name = 'oracle.apps.gmd.lotretest' THEN
555: ELSIF ( l_event_name = 'oracle.apps.gmi.lotretestdate.update') THEN
556: gmd_debug.put_line ('Lot Retest Date ') ;/* 4576699 */
557:
558: l_transaction_type:='LOTRETEST_TRANSACTION';
559: OPEN lot;
560: FETCH lot INTO l_inventory_item_id,

Line 586: gmd_debug.put_line ('PO Receipts'); -- Bug # 4576699

582: l_subinventory := NULL;
583: l_locator_id := NULL;
584:
585: ELSIF l_event_name = 'oracle.apps.gml.po.receipt.created' THEN
586: gmd_debug.put_line ('PO Receipts'); -- Bug # 4576699
587:
588: l_transaction_type:='RECEIVING_TRANSACTION';
589: --wf_log_pkg.string(6, 'Dummy','PO Receipts');
590: /* Set Org Context as we are using multi org view RCV_TRANSACTIONS_V */

Line 636: gmd_debug.put_line ('Inventory PO Receipts'); -- Bug # 4576699

632: -- Bug 4165704:event name changed
633: --ELSIF l_event_name = 'oracle.apps.gmi.inv.po.receipt' THEN
634: ELSIF(( l_event_name = 'oracle.apps.gmd.po.receipt.inventory')
635: OR (l_event_name = 'oracle.apps.gmi.inv.po.receipt')) THEN
636: gmd_debug.put_line ('Inventory PO Receipts'); -- Bug # 4576699
637:
638: l_transaction_type:='INV_RCV_TRANSACTION';
639:
640: --RLNAGARA Bug5334308

Line 677: gmd_debug.put_line ('Found Inv PO Receipts'); -- Bug # 4576699

673: l_lot_qty,
674: l_lot_qty2,
675: l_vendor_lot_num; --Bug#6145310
676: IF recv_inv%found THEN
677: gmd_debug.put_line ('Found Inv PO Receipts'); -- Bug # 4576699
678: l_valid_transaction :=true;
679: END IF;
680: CLOSE recv_inv;
681:

Line 690: gmd_debug.put_line ('Event is Batch Creation'); -- Bug # 4576699

686: CLOSE Cur_locator;
687: END IF; -- l_locator_id is not null
688:
689: ELSIF l_event_name = 'oracle.apps.gme.batch.created' THEN
690: gmd_debug.put_line ('Event is Batch Creation'); -- Bug # 4576699
691: l_transaction_type:='PRODUCTION_TRANSACTION';
692: l_valid_transaction:=true;
693: ELSIF l_event_name = 'oracle.apps.gme.batchstep.created' THEN
694: gmd_debug.put_line ('Event is Batchstep Creation'); -- Bug # 4576699

Line 694: gmd_debug.put_line ('Event is Batchstep Creation'); -- Bug # 4576699

690: gmd_debug.put_line ('Event is Batch Creation'); -- Bug # 4576699
691: l_transaction_type:='PRODUCTION_TRANSACTION';
692: l_valid_transaction:=true;
693: ELSIF l_event_name = 'oracle.apps.gme.batchstep.created' THEN
694: gmd_debug.put_line ('Event is Batchstep Creation'); -- Bug # 4576699
695: l_transaction_type:='PRODUCTION_TRANSACTION';
696: l_valid_transaction:=true;
697: ELSIF l_event_name = 'oracle.apps.gme.bstep.rel.wf' THEN
698: gmd_debug.put_line ('Event is Batch Step Release'); -- Bug # 4576699

Line 698: gmd_debug.put_line ('Event is Batch Step Release'); -- Bug # 4576699

694: gmd_debug.put_line ('Event is Batchstep Creation'); -- Bug # 4576699
695: l_transaction_type:='PRODUCTION_TRANSACTION';
696: l_valid_transaction:=true;
697: ELSIF l_event_name = 'oracle.apps.gme.bstep.rel.wf' THEN
698: gmd_debug.put_line ('Event is Batch Step Release'); -- Bug # 4576699
699: l_transaction_type:='PRODUCTION_TRANSACTION';
700: l_valid_transaction:=true;
701: END IF;
702:

Line 710: gmd_debug.put_line('Transaction Type ' || l_transaction_type);

706: /************************************************/
707:
708:
709: IF (l_debug = 'Y') THEN
710: gmd_debug.put_line('Transaction Type ' || l_transaction_type);
711: END IF;
712:
713: OPEN get_from_role ;
714: FETCH get_from_role into l_from_role ;

Line 721: gmd_debug.put_line ('Checking for Vendor Specifications '); -- Bug # 4576699

717:
718: IF l_Event_name not in ('oracle.apps.gme.batchstep.created',
719: 'oracle.apps.gme.batch.created',
720: 'oracle.apps.gme.bstep.rel.wf') THEN
721: gmd_debug.put_line ('Checking for Vendor Specifications '); -- Bug # 4576699
722:
723: /**********************************/
724: /* ONLY CONTINUE IF NOT WIP */
725: /**********************************/

Line 731: gmd_debug.put_line ('Processing PO Transactions'); -- Bug # 4576699

727: -- Bug 4165704: event 'oracle.apps.gmi.inv.po.receipt' name changed to 'oracle.apps.gmd.po.receipt.inventory'
728: IF l_valid_transaction and l_event_name in ('oracle.apps.gml.po.receipt.created',
729: 'oracle.apps.gmd.po.receipt.inventory',
730: 'oracle.apps.gmi.inv.po.receipt') THEN
731: gmd_debug.put_line ('Processing PO Transactions'); -- Bug # 4576699
732:
733:
734: /**********************************/
735: /* Supplier Samples ONLY */

Line 741: gmd_debug.put_line('PO Receiving Code');

737: /**********************************/
738:
739:
740: IF (l_debug = 'Y') THEN
741: gmd_debug.put_line('PO Receiving Code');
742: END IF;
743:
744: -- Bug 4165704: replaced the following sql with code below
745: IF l_vendor_id IS NOT NULL THEN

Line 776: gmd_debug.put_line ('PO Specification attributes Set'); -- Bug # 4576699

772: l_supp_spec.lot_number := L_lot_number;
773: l_supp_spec.parent_lot_number := L_parent_lot_number;
774: l_supp_spec.org_id := l_org_id; --RLNAGARA B5018797 to find correct supplier spec using org_id
775:
776: gmd_debug.put_line ('PO Specification attributes Set'); -- Bug # 4576699
777: --wf_log_pkg.string(6, 'Dummy','PO Specification attributes Set');
778:
779: IF (l_debug = 'Y') THEN
780: gmd_debug.put_line('Checking for Spec');

Line 780: gmd_debug.put_line('Checking for Spec');

776: gmd_debug.put_line ('PO Specification attributes Set'); -- Bug # 4576699
777: --wf_log_pkg.string(6, 'Dummy','PO Specification attributes Set');
778:
779: IF (l_debug = 'Y') THEN
780: gmd_debug.put_line('Checking for Spec');
781: END IF;
782:
783: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(
784: p_supplier_spec_rec => l_supp_spec,

Line 795: gmd_debug.put_line('Spec found');

791:
792: /* Specification Found */
793: /* Check to see if there is a sampling plan */
794: IF (l_debug = 'Y') THEN
795: gmd_debug.put_line('Spec found');
796: END IF;
797:
798: OPEN get_sampling_plan_id (l_spec_vr_id);
799: FETCH get_sampling_plan_id into l_sample_count,

Line 873: gmd_debug.put_line ('Sampling Event Creation Failed'); -- Bug # 4576699

869:
870: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (
871: p_sampling_events => l_sampling_events,
872: x_sampling_events => l_sampling_events_out) THEN
873: gmd_debug.put_line ('Sampling Event Creation Failed'); -- Bug # 4576699
874:
875: --wf_log_pkg.string(6, 'Dummy','Sampling Event Creation Failed');
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;

Line 944: gmd_debug.put_line('PO Transactions, l_trans_qty_uom = '||l_trans_qty_uom);

940:
941: --Begin Bug 6807847. For PO Transactions l_trans_qty_uom is in unit_of_measure.
942: --Hence get corresponding uom_code from unit_of_measure.
943: IF (l_debug = 'Y') THEN
944: gmd_debug.put_line('PO Transactions, l_trans_qty_uom = '||l_trans_qty_uom);
945: END IF;
946:
947: BEGIN
948: SELECT uom_code

Line 956: gmd_debug.put_line('Unable to fetch uom_code from mtl_units_of_measure');

952:
953: EXCEPTION
954: WHEN OTHERS THEN
955: IF (l_debug = 'Y') THEN
956: gmd_debug.put_line('Unable to fetch uom_code from mtl_units_of_measure');
957: END IF;
958: RAISE FND_API.G_EXC_ERROR;
959: END;
960: --End Bug 6807847.

Line 990: gmd_debug.put_line('ERROR1 in function INV_CONVERT.inv_um_convert');

986:
987: --Bug 6807847
988: IF l_qty_conv = -99999 THEN
989: IF (l_debug = 'Y') THEN
990: gmd_debug.put_line('ERROR1 in function INV_CONVERT.inv_um_convert');
991: END IF;
992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:

Line 1156: gmd_debug.put_line('Going to insert event spec disp');

1152: l_event_spec_disp.LAST_UPDATE_DATE:=sysdate;
1153: l_event_spec_disp.LAST_UPDATED_BY:=FND_GLOBAL.USER_ID;
1154:
1155: IF (l_debug = 'Y') THEN
1156: gmd_debug.put_line('Going to insert event spec disp');
1157: END IF;
1158:
1159: IF NOT GMD_EVENT_SPEC_DISP_PVT.INSERT_ROW(
1160: p_event_spec_disp =>l_event_spec_disp,

Line 1162: gmd_debug.put_line ('Sampling Event disposition Creation Failed'); -- Bug # 4576699

1158:
1159: IF NOT GMD_EVENT_SPEC_DISP_PVT.INSERT_ROW(
1160: p_event_spec_disp =>l_event_spec_disp,
1161: x_event_spec_disp =>l_event_spec_disp_out) THEN
1162: gmd_debug.put_line ('Sampling Event disposition Creation Failed'); -- Bug # 4576699
1163:
1164: --wf_log_pkg.string(6, 'Dummy','Sampling Event disposition Creation Failed');
1165: RAISE FND_API.G_EXC_ERROR;
1166: END IF;

Line 1171: gmd_debug.put_line('Created event spec disp');

1167:
1168: l_event_spec_disp := l_event_spec_disp_out ;
1169:
1170: IF (l_debug = 'Y') THEN
1171: gmd_debug.put_line('Created event spec disp');
1172: END IF;
1173:
1174: END IF ; /* End of check to create event spec for non-auto sample */
1175:

Line 1177: gmd_debug.put_line ( 'Vendor Specification Found....Event Created with id'

1173:
1174: END IF ; /* End of check to create event spec for non-auto sample */
1175:
1176: l_vendor_spec_found:=true;
1177: gmd_debug.put_line ( 'Vendor Specification Found....Event Created with id'
1178: || l_sampling_events.sampling_event_id); -- Bug # 4576699
1179:
1180: ELSE -- supplier spec not found
1181: l_vendor_spec_found:=false;

Line 1201: gmd_debug.put_line('Inventory Code');

1197: --gml_sf_log('Checking for inventory spec. ');
1198:
1199: IF l_valid_transaction and not l_vendor_spec_found THEN
1200: IF (l_debug = 'Y') THEN
1201: gmd_debug.put_line('Inventory Code');
1202: END IF;
1203:
1204: /* Figure out if proper Specifications exist */
1205: l_inv_spec.inventory_item_id := L_inventory_item_id;

Line 1216: gmd_debug.put_line('Checking for Spec');

1212: l_inv_spec.date_effective := SYSDATE;
1213: l_inv_spec.exact_match := 'N';
1214:
1215: IF (l_debug = 'Y') THEN
1216: gmd_debug.put_line('Checking for Spec');
1217: END IF;
1218:
1219:
1220: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(

Line 1231: gmd_debug.put_line('Spec Found: '||l_spec_id||' '||l_spec_vr_id);

1227: /* Specification Found */
1228: /* Create Sampling Event */
1229:
1230: IF (l_debug = 'Y') THEN
1231: gmd_debug.put_line('Spec Found: '||l_spec_id||' '||l_spec_vr_id);
1232: END IF;
1233:
1234: OPEN get_sampling_plan_id (l_spec_vr_id);
1235: FETCH get_sampling_plan_id INTO l_sample_count,

Line 1287: gmd_debug.put_line('Going to insert sample event');

1283: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1284: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
1285:
1286: IF (l_debug = 'Y') THEN
1287: gmd_debug.put_line('Going to insert sample event');
1288: END IF;
1289:
1290: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (
1291: p_sampling_events => l_sampling_events,

Line 1293: gmd_debug.put_line ('Sampling Event Creation Failed'); -- Bug # 4576699

1289:
1290: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (
1291: p_sampling_events => l_sampling_events,
1292: x_sampling_events => l_sampling_events_out) THEN
1293: gmd_debug.put_line ('Sampling Event Creation Failed'); -- Bug # 4576699
1294: RAISE FND_API.G_EXC_ERROR;
1295: END IF;
1296:
1297: l_sampling_events := l_sampling_events_out ;

Line 1300: gmd_debug.put_line('Created Sampling Event');

1296:
1297: l_sampling_events := l_sampling_events_out ;
1298:
1299: IF (l_debug = 'Y') THEN
1300: gmd_debug.put_line('Created Sampling Event');
1301: END IF;
1302:
1303: /* Check to see if auto Sample Creation is enabled for this Spec VR */
1304: OPEN inventory_auto_sample ( l_spec_vr_id);

Line 1322: gmd_debug.put_line('Auto Sample Flag: ' || l_auto_sample);

1318:
1319: l_doc_number := quality_config.sample_assignment_type;
1320:
1321: IF (l_debug = 'Y') THEN
1322: gmd_debug.put_line('Auto Sample Flag: ' || l_auto_sample);
1323: END IF;
1324:
1325: /* Check to see if there is a sampling plan */
1326: OPEN inv_sample_plan(l_spec_vr_id);

Line 1356: gmd_debug.put_line('going to Auto sample pkg');

1352:
1353: /* Check to see if auto sample creation is enabled */
1354: IF ((l_auto_sample = 'Y') and (l_doc_number = 2)) THEN
1355: IF (l_debug = 'Y') THEN
1356: gmd_debug.put_line('going to Auto sample pkg');
1357: END IF;
1358:
1359: /* Calculate the required standard samples */
1360: -- BUG 4165704: event name changed

Line 1388: gmd_debug.put_line('ERROR2 in function INV_CONVERT.inv_um_convert');

1384:
1385: --Bug 6807847
1386: IF l_qty_conv = -99999 THEN
1387: IF (l_debug = 'Y') THEN
1388: gmd_debug.put_line('ERROR2 in function INV_CONVERT.inv_um_convert');
1389: END IF;
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392:

Line 1409: gmd_debug.put_line('Status from Auto pkg ' ||create_status);

1405: GMD_AUTO_SAMPLE_PKG.create_samples(l_sampling_events,
1406: l_spec_id,l_spec_vr_id, create_status );
1407:
1408: IF (l_debug = 'Y') THEN
1409: gmd_debug.put_line('Status from Auto pkg ' ||create_status);
1410: END IF;
1411:
1412:
1413: /* Sampling Event Successfully Created. Set Form Attribute

Line 1535: gmd_debug.put_line('Going to insert event spec disp');

1531: l_event_spec_disp.LAST_UPDATE_DATE:=sysdate;
1532: l_event_spec_disp.LAST_UPDATED_BY:=FND_GLOBAL.USER_ID;
1533:
1534: IF (l_debug = 'Y') THEN
1535: gmd_debug.put_line('Going to insert event spec disp');
1536: END IF;
1537:
1538: IF NOT GMD_EVENT_SPEC_DISP_PVT.insert_row(
1539:

Line 1542: gmd_debug.put_line ('Sampling Event disposition Creation Failed'); -- Bug # 4576699

1538: IF NOT GMD_EVENT_SPEC_DISP_PVT.insert_row(
1539:
1540: p_event_spec_disp =>l_event_spec_disp,
1541: x_event_spec_disp =>l_event_spec_disp_out) THEN
1542: gmd_debug.put_line ('Sampling Event disposition Creation Failed'); -- Bug # 4576699
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF; -- IF NOT GMD_EVENT_SPEC_DISP_PVT.insert_row
1545:
1546: l_event_spec_disp := l_event_spec_disp_out ;

Line 1549: gmd_debug.put_line('Created event spec disp');

1545:
1546: l_event_spec_disp := l_event_spec_disp_out ;
1547:
1548: IF (l_debug = 'Y') THEN
1549: gmd_debug.put_line('Created event spec disp');
1550: END IF;
1551:
1552: END IF ; /* End of check to create event spec for non-auto sample */
1553:

Line 1555: gmd_debug.put_line ('Could Not Find Specification'); -- Bug # 4576699

1551:
1552: END IF ; /* End of check to create event spec for non-auto sample */
1553:
1554: ELSE
1555: gmd_debug.put_line ('Could Not Find Specification'); -- Bug # 4576699
1556: --wf_log_pkg.string(6, 'Dummy','Could Not Find Specification');
1557: P_resultout:='COMPLETE:NO_WORKFLOW';
1558: return;
1559: END IF;

Line 1562: gmd_debug.put_line ('No Valid Transctions') ; /* 4576699 */

1558: return;
1559: END IF;
1560: END IF;
1561: IF not l_valid_transaction THEN
1562: gmd_debug.put_line ('No Valid Transctions') ; /* 4576699 */
1563: /* No Valid Transctions */
1564: P_resultout:='COMPLETE:NO_WORKFLOW';
1565: return;
1566: END IF;

Line 1595: gmd_debug.put_line ('No Approval Required 1'); /* 4576699 */

1591: transactionTypeIn => l_transaction_type,
1592: nextApproverOut => Approver);
1593:
1594: IF(Approver.user_id is null and Approver.person_id is null) THEN
1595: gmd_debug.put_line ('No Approval Required 1'); /* 4576699 */
1596:
1597: /* No Approval Required */
1598: P_resultout:='COMPLETE:NO_WORKFLOW';
1599: return;

Line 1774: gmd_debug.put_line ('Vendor Number not found');

1770: -- Bug 4576699: added Exceptions besides OTHERS
1771: EXCEPTION
1772: WHEN no_vendor_found
1773: THEN
1774: gmd_debug.put_line ('Vendor Number not found');
1775: WHEN no_application_id_found
1776: THEN
1777: gmd_debug.put_line ('Application Id not found');
1778: WHEN no_user_name_found

Line 1777: gmd_debug.put_line ('Application Id not found');

1773: THEN
1774: gmd_debug.put_line ('Vendor Number not found');
1775: WHEN no_application_id_found
1776: THEN
1777: gmd_debug.put_line ('Application Id not found');
1778: WHEN no_user_name_found
1779: THEN
1780: gmd_debug.put_line ('User Name not found');
1781: WHEN OTHERS

Line 1780: gmd_debug.put_line ('User Name not found');

1776: THEN
1777: gmd_debug.put_line ('Application Id not found');
1778: WHEN no_user_name_found
1779: THEN
1780: gmd_debug.put_line ('User Name not found');
1781: WHEN OTHERS
1782: THEN
1783: wf_core.CONTEXT ('GMD_QMSMC',
1784: 'VERIFY_EVENT',

Line 2174: gmd_debug.put_line('Event name ' || l_event_name);

2170: BEGIN
2171: --gml_sf_log('start proc PRODUCTION and event='||l_event_name);
2172:
2173: IF (l_debug = 'Y') THEN
2174: gmd_debug.put_line('Event name ' || l_event_name);
2175: gmd_debug.put_line('Event key ' || l_Event_key);
2176: END IF;
2177:
2178: OPEN get_from_role ;

Line 2175: gmd_debug.put_line('Event key ' || l_Event_key);

2171: --gml_sf_log('start proc PRODUCTION and event='||l_event_name);
2172:
2173: IF (l_debug = 'Y') THEN
2174: gmd_debug.put_line('Event name ' || l_event_name);
2175: gmd_debug.put_line('Event key ' || l_Event_key);
2176: END IF;
2177:
2178: OPEN get_from_role ;
2179: FETCH get_from_role into l_from_role ;

Line 2282: gmd_debug.put_line('Checking for WIP Spec ');

2278: END IF; */
2279:
2280:
2281: IF (l_debug = 'Y') THEN
2282: gmd_debug.put_line('Checking for WIP Spec ');
2283: END IF;
2284:
2285: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
2286: p_wip_spec_rec => l_wip_spec,

Line 2293: gmd_debug.put_line('WIP Spec Found: '||l_Spec_id||' '||l_spec_vr_id);

2289: x_return_status => l_return_status,
2290: x_message_data => l_msg_data) THEN
2291:
2292: IF (l_debug = 'Y') THEN
2293: gmd_debug.put_line('WIP Spec Found: '||l_Spec_id||' '||l_spec_vr_id);
2294: END IF;
2295:
2296: /* RLNAGARA Bug 5032406 (FP of 4604305 ME) Assigning values to l_spec_name and l_spec_vers */
2297: OPEN get_spec_name(l_spec_id);

Line 2399: gmd_debug.put_line('Auto sample flag: ' ||l_auto_sample);

2395: END IF;
2396:
2397: l_doc_number := quality_config.sample_assignment_type;
2398: IF (l_debug = 'Y') THEN
2399: gmd_debug.put_line('Auto sample flag: ' ||l_auto_sample);
2400: END IF;
2401:
2402: -- Bug 4165704: took out reference to wip_sample_plan cursor and put in l_sample_plan_exists
2403: IF l_sample_plan_exists = 1 THEN

Line 2569: gmd_debug.put_line('Going to insert event spec disp');

2565: l_event_spec_disp.LAST_UPDATE_DATE :=sysdate;
2566: l_event_spec_disp.LAST_UPDATED_BY :=FND_GLOBAL.USER_ID;
2567:
2568: IF (l_debug = 'Y') THEN
2569: gmd_debug.put_line('Going to insert event spec disp');
2570: END IF;
2571:
2572: IF NOT GMD_EVENT_SPEC_DISP_PVT.insert_row(
2573: p_event_spec_disp =>l_event_spec_disp,

Line 2581: gmd_debug.put_line('Created event spec disp');

2577: END IF;
2578: l_event_spec_disp := l_event_spec_disp_out ;
2579:
2580: IF (l_debug = 'Y') THEN
2581: gmd_debug.put_line('Created event spec disp');
2582: END IF;
2583: END IF ; /* End of check to create event spec for non-auto sample */
2584:
2585:

Line 2605: gmd_debug.put_line('Ckecking for approver ');

2601: END IF;
2602: END IF;
2603:
2604: IF (l_debug = 'Y') THEN
2605: gmd_debug.put_line('Ckecking for approver ');
2606: END IF;
2607:
2608: /* Start the Workflow for the Given Combination */
2609: AME_API.CLEARALLAPPROVALS(applicationIdIn => l_application_id,

Line 2639: gmd_debug.put_line('Approver Found ');

2635: where user_id=AME_UTIL.PERSONIDTOUSERID(Approver.person_id);
2636: END IF;
2637:
2638: IF (l_debug = 'Y') THEN
2639: gmd_debug.put_line('Approver Found ');
2640: END IF;
2641:
2642: l_itemtype :='GMDQMSMC';
2643: l_itemkey :=l_event_key||'-'||l_step_id||'-'||l_INVENTORY_item_id