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 537: gmd_debug.put_line('SampleCreation WF. VERIFY_EVENT '); /* 4576699 */

533: CURSOR get_user_name(x_user_id NUMBER) IS /* 4576699 */
534: SELECT user_name FROM fnd_user WHERE user_id = x_user_id;
535:
536: BEGIN
537: gmd_debug.put_line('SampleCreation WF. VERIFY_EVENT '); /* 4576699 */
538:
539: IF (l_debug = 'Y') THEN
540: gmd_debug.log_initialize('SampleCreation');
541: END IF;

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

536: BEGIN
537: gmd_debug.put_line('SampleCreation WF. VERIFY_EVENT '); /* 4576699 */
538:
539: IF (l_debug = 'Y') THEN
540: gmd_debug.log_initialize('SampleCreation');
541: END IF;
542:
543: IF (l_debug = 'Y') THEN
544: gmd_debug.put_line('Event Name ' || l_event_name);

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

540: gmd_debug.log_initialize('SampleCreation');
541: END IF;
542:
543: IF (l_debug = 'Y') THEN
544: gmd_debug.put_line('Event Name ' || l_event_name);
545: gmd_debug.put_line('Event Key ' || l_event_key);
546:
547: END IF;
548:

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

541: END IF;
542:
543: IF (l_debug = 'Y') THEN
544: gmd_debug.put_line('Event Name ' || l_event_name);
545: gmd_debug.put_line('Event Key ' || l_event_key);
546:
547: END IF;
548:
549: /*************************************/

Line 566: gmd_debug.put_line('oracle.apps.gmi.inventory.created event - INVENTORY_TRANSACTION transaction_type '); /* 4576699 */

562: l_gen_obj_id := SUBSTR(l_event_key, INSTR(l_event_key, '-') + 1); -- 9756188
563:
564:
565: IF (l_debug = 'Y') THEN
566: gmd_debug.put_line('oracle.apps.gmi.inventory.created event - INVENTORY_TRANSACTION transaction_type '); /* 4576699 */
567: gmd_debug.put_line('l_trans_id ' || l_trans_id);
568: gmd_debug.put_line('l_gen_obj_id ' || l_gen_obj_id);
569: gmd_debug.put_line('l_transaction_source_type_id ' || l_transaction_source_type_id);
570: gmd_debug.put_line('l_transaction_action_id ' || l_transaction_action_id);

Line 567: gmd_debug.put_line('l_trans_id ' || l_trans_id);

563:
564:
565: IF (l_debug = 'Y') THEN
566: gmd_debug.put_line('oracle.apps.gmi.inventory.created event - INVENTORY_TRANSACTION transaction_type '); /* 4576699 */
567: gmd_debug.put_line('l_trans_id ' || l_trans_id);
568: gmd_debug.put_line('l_gen_obj_id ' || l_gen_obj_id);
569: gmd_debug.put_line('l_transaction_source_type_id ' || l_transaction_source_type_id);
570: gmd_debug.put_line('l_transaction_action_id ' || l_transaction_action_id);
571: END IF;

Line 568: gmd_debug.put_line('l_gen_obj_id ' || l_gen_obj_id);

564:
565: IF (l_debug = 'Y') THEN
566: gmd_debug.put_line('oracle.apps.gmi.inventory.created event - INVENTORY_TRANSACTION transaction_type '); /* 4576699 */
567: gmd_debug.put_line('l_trans_id ' || l_trans_id);
568: gmd_debug.put_line('l_gen_obj_id ' || l_gen_obj_id);
569: gmd_debug.put_line('l_transaction_source_type_id ' || l_transaction_source_type_id);
570: gmd_debug.put_line('l_transaction_action_id ' || l_transaction_action_id);
571: END IF;
572:

Line 569: gmd_debug.put_line('l_transaction_source_type_id ' || l_transaction_source_type_id);

565: IF (l_debug = 'Y') THEN
566: gmd_debug.put_line('oracle.apps.gmi.inventory.created event - INVENTORY_TRANSACTION transaction_type '); /* 4576699 */
567: gmd_debug.put_line('l_trans_id ' || l_trans_id);
568: gmd_debug.put_line('l_gen_obj_id ' || l_gen_obj_id);
569: gmd_debug.put_line('l_transaction_source_type_id ' || l_transaction_source_type_id);
570: gmd_debug.put_line('l_transaction_action_id ' || l_transaction_action_id);
571: END IF;
572:
573:

Line 570: gmd_debug.put_line('l_transaction_action_id ' || l_transaction_action_id);

566: gmd_debug.put_line('oracle.apps.gmi.inventory.created event - INVENTORY_TRANSACTION transaction_type '); /* 4576699 */
567: gmd_debug.put_line('l_trans_id ' || l_trans_id);
568: gmd_debug.put_line('l_gen_obj_id ' || l_gen_obj_id);
569: gmd_debug.put_line('l_transaction_source_type_id ' || l_transaction_source_type_id);
570: gmd_debug.put_line('l_transaction_action_id ' || l_transaction_action_id);
571: END IF;
572:
573:
574: OPEN inv;

Line 588: gmd_debug.put_line(' l_transaction_source_type_id = 5 AND l_transaction_action_id = 31 ');

584: IF ( l_transaction_source_type_id = 5 )-- G_SOURCETYPE_WIP
585: and ( l_transaction_action_id = 31 ) --g_action_assycomplete)
586: then
587: IF (l_debug = 'Y') THEN
588: gmd_debug.put_line(' l_transaction_source_type_id = 5 AND l_transaction_action_id = 31 ');
589: END IF;
590: OPEN get_mtln_lot(l_trans_id, l_gen_obj_id);
591: FETCH get_mtln_lot
592: into l_lot_number, l_parent_lot_number, l_trans_qty, l_trans_qty2;

Line 595: gmd_debug.put_line(' get_mtln_lot%NOTFOUND ');

591: FETCH get_mtln_lot
592: into l_lot_number, l_parent_lot_number, l_trans_qty, l_trans_qty2;
593:
594: IF get_mtln_lot%NOTFOUND THEN
595: gmd_debug.put_line(' get_mtln_lot%NOTFOUND ');
596: l_parent_lot_number := NULL;
597: l_lot_number := NULL;
598: END IF;
599: CLOSE get_mtln_lot;

Line 606: gmd_debug.put_line(' inv_lot%NOTFOUND');

602: OPEN inv_lot;
603: FETCH inv_lot
604: INTO l_parent_lot_number, l_lot_number;
605: IF inv_lot%NOTFOUND THEN
606: gmd_debug.put_line(' inv_lot%NOTFOUND');
607: l_parent_lot_number := NULL;
608: l_lot_number := NULL;
609: END IF;
610: CLOSE inv_lot;

Line 614: gmd_debug.put_line('_lot_number = ' || l_lot_number);

610: CLOSE inv_lot;
611: END IF; -- IF ( l_transaction_source_type_id = 5 )-- G_SOURCETYPE_WIP
612:
613: IF (l_debug = 'Y') THEN
614: gmd_debug.put_line('_lot_number = ' || l_lot_number);
615: END IF;
616:
617: END IF;
618:

Line 629: gmd_debug.put_line('9756188 l_event_key from l_trans_id back to ' || l_event_key);

625:
626: -- 9756188 need to set event-key to trans id for AME
627: l_event_key := l_trans_id; -- 9756188
628: IF (l_debug = 'Y') THEN
629: gmd_debug.put_line('9756188 l_event_key from l_trans_id back to ' || l_event_key);
630: END IF;
631:
632:
633: -- Bug 4165704: added cursor to retrieve locator

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

641: -- Bug 4165704:event name changed
642: -- ELSIF l_event_name = 'oracle.apps.gmd.lotexpiry')
643:
644: ELSIF (l_event_name = 'oracle.apps.gmi.lotexpirydate.update') THEN
645: gmd_debug.put_line('Lot Expiry Date '); /* 4576699 */
646:
647: l_transaction_type := 'LOTEXPIRY_TRANSACTION';
648: OPEN lot;
649: Fetch lot

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

669:
670: -- Bug 4165704:event name changed
671: -- ELSIF l_event_name = 'oracle.apps.gmd.lotretest' THEN
672: ELSIF (l_event_name = 'oracle.apps.gmi.lotretestdate.update') THEN
673: gmd_debug.put_line('Lot Retest Date '); /* 4576699 */
674:
675: l_transaction_type := 'LOTRETEST_TRANSACTION';
676: OPEN lot;
677: FETCH lot

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

694: l_subinventory := NULL;
695: l_locator_id := NULL;
696:
697: ELSIF l_event_name = 'oracle.apps.gml.po.receipt.created' THEN
698: gmd_debug.put_line('PO Receipts'); -- Bug # 4576699
699:
700: l_transaction_type := 'RECEIVING_TRANSACTION';
701: --wf_log_pkg.string(6, 'Dummy','PO Receipts');
702: /* Set Org Context as we are using multi org view RCV_TRANSACTIONS_V */

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

753: -- Bug 4165704:event name changed
754: --ELSIF l_event_name = 'oracle.apps.gmi.inv.po.receipt' THEN
755: ELSIF ((l_event_name = 'oracle.apps.gmd.po.receipt.inventory') OR
756: (l_event_name = 'oracle.apps.gmi.inv.po.receipt')) THEN
757: gmd_debug.put_line('Inventory PO Receipts'); -- Bug # 4576699
758:
759: l_transaction_type := 'INV_RCV_TRANSACTION';
760:
761: --RLNAGARA Bug5334308

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

775: l_vendor_site_id, l_receipt_line_id, l_purchase_no, l_receipt_no, l_locator_id, l_lot_number,
776: l_parent_lot_number, l_org_id, l_operating_unit, l_lot_qty, l_lot_qty2, l_vendor_lot_num, l_grade, --Bug#6145310 -- 10044459 added grade
777: local_user; --Bug#6276012 added
778: IF recv_inv%found THEN
779: gmd_debug.put_line('Found Inv PO Receipts'); -- Bug # 4576699
780: l_valid_transaction := true;
781: END IF;
782: CLOSE recv_inv;
783:

Line 787: gmd_debug.put_line('recv_inv%notfound so trying cursor recv_no_lot for non-lot-controlled item ');

783:
784: IF not l_valid_transaction THEN -- 13686877
785: l_trans_id := SUBSTR(l_event_key, 1, INSTR(l_event_key, '-') - 1);
786:
787: gmd_debug.put_line('recv_inv%notfound so trying cursor recv_no_lot for non-lot-controlled item ');
788:
789: -- 13686877
790: -- right now l_trans_id refers to mtl_material_transactions so we need to locate rcv_transaction_id in order to use as key to cursor recv_no_lot;
791:

Line 815: gmd_debug.put_line('Found Inv PO Receipts for cursor recv_no_lot after recv_inv%notfound - l_valid_transaction := true ');

811: l_transaction_id; -- 9509656
812:
813: IF recv_no_lot%found THEN
814:
815: gmd_debug.put_line('Found Inv PO Receipts for cursor recv_no_lot after recv_inv%notfound - l_valid_transaction := true ');
816:
817: --wf_log_pkg.string(6, 'Dummy','Found PO Receipts');
818:
819: l_valid_transaction := true;

Line 822: gmd_debug.put_line('recv_no_lot%notfound after recv_inv%notfound l_valid_transaction := false ');

818:
819: l_valid_transaction := true;
820:
821: else
822: gmd_debug.put_line('recv_no_lot%notfound after recv_inv%notfound l_valid_transaction := false ');
823:
824: END IF;
825:
826: CLOSE recv_no_lot;

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

837: CLOSE Cur_locator;
838: END IF; -- l_locator_id is not null
839:
840: ELSIF l_event_name = 'oracle.apps.gme.batch.created' THEN
841: gmd_debug.put_line('Event is Batch Creation'); -- Bug # 4576699
842: l_transaction_type := 'PRODUCTION_TRANSACTION';
843: l_valid_transaction := true;
844: ELSIF l_event_name = 'oracle.apps.gme.batchstep.created' THEN
845: gmd_debug.put_line('Event is Batchstep Creation'); -- Bug # 4576699

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

841: gmd_debug.put_line('Event is Batch Creation'); -- Bug # 4576699
842: l_transaction_type := 'PRODUCTION_TRANSACTION';
843: l_valid_transaction := true;
844: ELSIF l_event_name = 'oracle.apps.gme.batchstep.created' THEN
845: gmd_debug.put_line('Event is Batchstep Creation'); -- Bug # 4576699
846: l_transaction_type := 'PRODUCTION_TRANSACTION';
847: l_valid_transaction := true;
848: ELSIF l_event_name = 'oracle.apps.gme.bstep.rel.wf' THEN
849: gmd_debug.put_line('Event is Batch Step Release'); -- Bug # 4576699

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

845: gmd_debug.put_line('Event is Batchstep Creation'); -- Bug # 4576699
846: l_transaction_type := 'PRODUCTION_TRANSACTION';
847: l_valid_transaction := true;
848: ELSIF l_event_name = 'oracle.apps.gme.bstep.rel.wf' THEN
849: gmd_debug.put_line('Event is Batch Step Release'); -- Bug # 4576699
850: l_transaction_type := 'PRODUCTION_TRANSACTION';
851: l_valid_transaction := true;
852: END IF;
853:

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

855: /* END OF CHECK FOR WHICH EVENT HAS BEEN RAISED */
856: /************************************************/
857:
858: IF (l_debug = 'Y') THEN
859: gmd_debug.put_line('Transaction Type ' || l_transaction_type);
860: END IF;
861:
862: OPEN get_from_role;
863: FETCH get_from_role

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

866:
867: IF l_Event_name not in
868: ('oracle.apps.gme.batchstep.created', 'oracle.apps.gme.batch.created',
869: 'oracle.apps.gme.bstep.rel.wf') THEN
870: gmd_debug.put_line('Checking for Vendor Specifications '); -- Bug # 4576699
871:
872: /**********************************/
873: /* ONLY CONTINUE IF NOT WIP */
874: /**********************************/

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

877: IF l_valid_transaction and
878: l_event_name in ('oracle.apps.gml.po.receipt.created',
879: 'oracle.apps.gmd.po.receipt.inventory',
880: 'oracle.apps.gmi.inv.po.receipt') THEN
881: gmd_debug.put_line('Processing PO Transactions'); -- Bug # 4576699
882:
883: /**********************************/
884: /* Supplier Samples ONLY */
885: /* Check for specification */

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

885: /* Check for specification */
886: /**********************************/
887:
888: IF (l_debug = 'Y') THEN
889: gmd_debug.put_line('PO Receiving Code');
890: END IF;
891:
892: -- Bug 4165704: replaced the following sql with code below
893: IF l_vendor_id IS NOT NULL THEN

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

919: l_supp_spec.parent_lot_number := L_parent_lot_number;
920: l_supp_spec.org_id := l_org_id; --RLNAGARA B5018797 to find correct supplier spec using org_id
921: l_supp_spec.grade_code := L_GRADE; -- 10044459 add grade to spec matching
922:
923: gmd_debug.put_line('PO Specification attributes Set'); -- Bug # 4576699
924: --wf_log_pkg.string(6, 'Dummy','PO Specification attributes Set');
925:
926:
927:

Line 929: gmd_debug.put_line('l_supp_spec.grade = ' || l_grade);

925:
926:
927:
928: IF (l_debug = 'Y') THEN
929: gmd_debug.put_line('l_supp_spec.grade = ' || l_grade);
930: gmd_debug.put_line('Checking for Spec');
931: END IF;
932:
933: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(p_supplier_spec_rec => l_supp_spec,

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

926:
927:
928: IF (l_debug = 'Y') THEN
929: gmd_debug.put_line('l_supp_spec.grade = ' || l_grade);
930: gmd_debug.put_line('Checking for Spec');
931: END IF;
932:
933: IF GMD_SPEC_MATCH_GRP.FIND_SUPPLIER_OR_INV_SPEC(p_supplier_spec_rec => l_supp_spec,
934: x_spec_id => l_spec_id,

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

939:
940: /* Specification Found */
941: /* Check to see if there is a sampling plan */
942: IF (l_debug = 'Y') THEN
943: gmd_debug.put_line('Spec found');
944: END IF;
945:
946: OPEN get_sampling_plan_id(l_spec_vr_id);
947: FETCH get_sampling_plan_id

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

1016:
1017: IF NOT
1018: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,
1019: x_sampling_events => l_sampling_events_out) THEN
1020: gmd_debug.put_line('Sampling Event Creation Failed'); -- Bug # 4576699
1021:
1022: --wf_log_pkg.string(6, 'Dummy','Sampling Event Creation Failed');
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;

Line 1092: gmd_debug.put_line('PO Transactions, l_trans_qty_uom = ' ||

1088:
1089: --Begin Bug 6807847. For PO Transactions l_trans_qty_uom is in unit_of_measure.
1090: --Hence get corresponding uom_code from unit_of_measure.
1091: IF (l_debug = 'Y') THEN
1092: gmd_debug.put_line('PO Transactions, l_trans_qty_uom = ' ||
1093: l_trans_qty_uom);
1094: END IF;
1095:
1096: BEGIN

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

1101:
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: IF (l_debug = 'Y') THEN
1105: gmd_debug.put_line('Unable to fetch uom_code from mtl_units_of_measure');
1106: END IF;
1107: RAISE FND_API.G_EXC_ERROR;
1108: END;
1109: --End Bug 6807847.

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

1135:
1136: --Bug 6807847
1137: IF l_qty_conv = -99999 THEN
1138: IF (l_debug = 'Y') THEN
1139: gmd_debug.put_line('ERROR1 in function INV_CONVERT.inv_um_convert');
1140: END IF;
1141: RAISE FND_API.G_EXC_ERROR;
1142: END IF;
1143:

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

1329: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
1330: l_event_spec_disp.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1331:
1332: IF (l_debug = 'Y') THEN
1333: gmd_debug.put_line('Going to insert event spec disp');
1334: END IF;
1335:
1336: IF NOT
1337: GMD_EVENT_SPEC_DISP_PVT.INSERT_ROW(p_event_spec_disp => l_event_spec_disp,

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

1335:
1336: IF NOT
1337: GMD_EVENT_SPEC_DISP_PVT.INSERT_ROW(p_event_spec_disp => l_event_spec_disp,
1338: x_event_spec_disp => l_event_spec_disp_out) THEN
1339: gmd_debug.put_line('Sampling Event disposition Creation Failed'); -- Bug # 4576699
1340:
1341: --wf_log_pkg.string(6, 'Dummy','Sampling Event disposition Creation Failed');
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;

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

1344:
1345: l_event_spec_disp := l_event_spec_disp_out;
1346:
1347: IF (l_debug = 'Y') THEN
1348: gmd_debug.put_line('Created event spec disp');
1349: END IF;
1350:
1351: END IF; /* End of check to create event spec for non-auto sample */
1352:

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

1350:
1351: END IF; /* End of check to create event spec for non-auto sample */
1352:
1353: l_vendor_spec_found := true;
1354: gmd_debug.put_line('Vendor Specification Found....Event Created with id' ||
1355: l_sampling_events.sampling_event_id); -- Bug # 4576699
1356:
1357: ELSE
1358: -- supplier spec not found

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

1374: --gml_sf_log('Checking for inventory spec. ');
1375:
1376: IF l_valid_transaction and not l_vendor_spec_found THEN
1377: IF (l_debug = 'Y') THEN
1378: gmd_debug.put_line('Inventory Code');
1379: END IF;
1380:
1381: /* Figure out if proper Specifications exist */
1382: l_inv_spec.inventory_item_id := L_inventory_item_id;

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

1389: l_inv_spec.date_effective := SYSDATE;
1390: l_inv_spec.exact_match := 'N';
1391:
1392: IF (l_debug = 'Y') THEN
1393: gmd_debug.put_line('Checking for Spec');
1394: END IF;
1395:
1396: IF GMD_SPEC_MATCH_GRP.FIND_INVENTORY_SPEC(p_inventory_spec_rec => l_inv_spec,
1397: x_spec_id => l_spec_id,

Line 1406: gmd_debug.put_line('Spec Found: ' || l_spec_id || ' ' ||

1402: /* Specification Found */
1403: /* Create Sampling Event */
1404:
1405: IF (l_debug = 'Y') THEN
1406: gmd_debug.put_line('Spec Found: ' || l_spec_id || ' ' ||
1407: l_spec_vr_id);
1408: END IF;
1409:
1410: OPEN get_sampling_plan_id(l_spec_vr_id);

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

1450: l_sampling_events.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1451: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
1452:
1453: IF (l_debug = 'Y') THEN
1454: gmd_debug.put_line('Going to insert sample event');
1455: END IF;
1456:
1457: IF NOT
1458: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,

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

1456:
1457: IF NOT
1458: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,
1459: x_sampling_events => l_sampling_events_out) THEN
1460: gmd_debug.put_line('Sampling Event Creation Failed'); -- Bug # 4576699
1461: RAISE FND_API.G_EXC_ERROR;
1462: END IF;
1463:
1464: l_sampling_events := l_sampling_events_out;

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

1463:
1464: l_sampling_events := l_sampling_events_out;
1465:
1466: IF (l_debug = 'Y') THEN
1467: gmd_debug.put_line('Created Sampling Event');
1468: END IF;
1469:
1470: /* Check to see if auto Sample Creation is enabled for this Spec VR */
1471: OPEN inventory_auto_sample(l_spec_vr_id);

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

1485:
1486: l_doc_number := quality_config.sample_assignment_type;
1487:
1488: IF (l_debug = 'Y') THEN
1489: gmd_debug.put_line('Auto Sample Flag: ' || l_auto_sample);
1490: END IF;
1491:
1492: /* Check to see if there is a sampling plan */
1493: OPEN inv_sample_plan(l_spec_vr_id);

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

1517:
1518: /* Check to see if auto sample creation is enabled */
1519: IF ((l_auto_sample = 'Y') and (l_doc_number = 2)) THEN
1520: IF (l_debug = 'Y') THEN
1521: gmd_debug.put_line('going to Auto sample pkg');
1522: END IF;
1523:
1524: /* Calculate the required standard samples */
1525: -- BUG 4165704: event name changed

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

1550:
1551: --Bug 6807847
1552: IF l_qty_conv = -99999 THEN
1553: IF (l_debug = 'Y') THEN
1554: gmd_debug.put_line('ERROR2 in function INV_CONVERT.inv_um_convert');
1555: END IF;
1556: RAISE FND_API.G_EXC_ERROR;
1557: END IF;
1558:

Line 1583: gmd_debug.put_line('Status from Auto pkg ' ||

1579: l_spec_vr_id,
1580: create_status);
1581:
1582: IF (l_debug = 'Y') THEN
1583: gmd_debug.put_line('Status from Auto pkg ' ||
1584: create_status);
1585: END IF;
1586:
1587: /* Sampling Event Successfully Created. Set Form Attribute

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

1715: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
1716: l_event_spec_disp.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1717:
1718: IF (l_debug = 'Y') THEN
1719: gmd_debug.put_line('Going to insert event spec disp');
1720: END IF;
1721:
1722: IF NOT
1723: GMD_EVENT_SPEC_DISP_PVT.insert_row(

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

1723: GMD_EVENT_SPEC_DISP_PVT.insert_row(
1724:
1725: p_event_spec_disp => l_event_spec_disp,
1726: x_event_spec_disp => l_event_spec_disp_out) THEN
1727: gmd_debug.put_line('Sampling Event disposition Creation Failed'); -- Bug # 4576699
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF; -- IF NOT GMD_EVENT_SPEC_DISP_PVT.insert_row
1730:
1731: l_event_spec_disp := l_event_spec_disp_out;

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

1730:
1731: l_event_spec_disp := l_event_spec_disp_out;
1732:
1733: IF (l_debug = 'Y') THEN
1734: gmd_debug.put_line('Created event spec disp');
1735: END IF;
1736:
1737: END IF; /* End of check to create event spec for non-auto sample */
1738:

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

1736:
1737: END IF; /* End of check to create event spec for non-auto sample */
1738:
1739: ELSE
1740: gmd_debug.put_line('Could Not Find Specification'); -- Bug # 4576699
1741: --wf_log_pkg.string(6, 'Dummy','Could Not Find Specification');
1742: P_resultout := 'COMPLETE:NO_WORKFLOW';
1743: return;
1744: END IF;

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

1743: return;
1744: END IF;
1745: END IF;
1746: IF not l_valid_transaction THEN
1747: gmd_debug.put_line('No Valid Transctions'); /* 4576699 */
1748: /* No Valid Transctions */
1749: P_resultout := 'COMPLETE:NO_WORKFLOW';
1750: return;
1751: END IF;

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

1775: transactionTypeIn => l_transaction_type,
1776: nextApproverOut => Approver);
1777:
1778: IF (Approver.user_id is null and Approver.person_id is null) THEN
1779: gmd_debug.put_line('No Approval Required 1'); /* 4576699 */
1780:
1781: /* No Approval Required */
1782: P_resultout := 'COMPLETE:NO_WORKFLOW';
1783: return;

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

1999:
2000: -- Bug 4576699: added Exceptions besides OTHERS
2001: EXCEPTION
2002: WHEN no_vendor_found THEN
2003: gmd_debug.put_line('Vendor Number not found');
2004: WHEN no_application_id_found THEN
2005: gmd_debug.put_line('Application Id not found');
2006: WHEN no_user_name_found THEN
2007: gmd_debug.put_line('User Name not found');

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

2001: EXCEPTION
2002: WHEN no_vendor_found THEN
2003: gmd_debug.put_line('Vendor Number not found');
2004: WHEN no_application_id_found THEN
2005: gmd_debug.put_line('Application Id not found');
2006: WHEN no_user_name_found THEN
2007: gmd_debug.put_line('User Name not found');
2008: WHEN OTHERS THEN
2009: wf_core.CONTEXT('GMD_QMSMC',

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

2003: gmd_debug.put_line('Vendor Number not found');
2004: WHEN no_application_id_found THEN
2005: gmd_debug.put_line('Application Id not found');
2006: WHEN no_user_name_found THEN
2007: gmd_debug.put_line('User Name not found');
2008: WHEN OTHERS THEN
2009: wf_core.CONTEXT('GMD_QMSMC',
2010: 'VERIFY_EVENT',
2011: p_itemtype,

Line 2061: gmd_debug.put_line('SampleCreation WF. CHECK_NEXT_APPROVER ');

2057: BEGIN
2058:
2059: IF (l_debug = 'Y') THEN
2060:
2061: gmd_debug.put_line('SampleCreation WF. CHECK_NEXT_APPROVER ');
2062: gmd_debug.put_line('Event Name ' || l_event_name);
2063: gmd_debug.put_line('Event Key ' || l_event_key);
2064: gmd_debug.put_line('Transaction_type ' || l_transaction_type);
2065:

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

2058:
2059: IF (l_debug = 'Y') THEN
2060:
2061: gmd_debug.put_line('SampleCreation WF. CHECK_NEXT_APPROVER ');
2062: gmd_debug.put_line('Event Name ' || l_event_name);
2063: gmd_debug.put_line('Event Key ' || l_event_key);
2064: gmd_debug.put_line('Transaction_type ' || l_transaction_type);
2065:
2066: END IF;

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

2059: IF (l_debug = 'Y') THEN
2060:
2061: gmd_debug.put_line('SampleCreation WF. CHECK_NEXT_APPROVER ');
2062: gmd_debug.put_line('Event Name ' || l_event_name);
2063: gmd_debug.put_line('Event Key ' || l_event_key);
2064: gmd_debug.put_line('Transaction_type ' || l_transaction_type);
2065:
2066: END IF;
2067:

Line 2064: gmd_debug.put_line('Transaction_type ' || l_transaction_type);

2060:
2061: gmd_debug.put_line('SampleCreation WF. CHECK_NEXT_APPROVER ');
2062: gmd_debug.put_line('Event Name ' || l_event_name);
2063: gmd_debug.put_line('Event Key ' || l_event_key);
2064: gmd_debug.put_line('Transaction_type ' || l_transaction_type);
2065:
2066: END IF;
2067:
2068: -- 9756188 when event is this then AME needs to have the key transformed back to trans id as this event is now raised with gen_obj_id as well ( as part of this bug fix )

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

2073:
2074: END IF;
2075:
2076: IF (l_debug = 'Y') THEN
2077: gmd_debug.put_line('Event Key NOW ' || l_event_key);
2078:
2079: END IF;
2080: -- 9756188
2081:

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

2467: BEGIN
2468: --gml_sf_log('start proc PRODUCTION and event='||l_event_name);
2469:
2470: IF (l_debug = 'Y') THEN
2471: gmd_debug.put_line('Event name ' || l_event_name);
2472: gmd_debug.put_line('Event key ' || l_Event_key);
2473: END IF;
2474:
2475: OPEN get_from_role;

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

2468: --gml_sf_log('start proc PRODUCTION and event='||l_event_name);
2469:
2470: IF (l_debug = 'Y') THEN
2471: gmd_debug.put_line('Event name ' || l_event_name);
2472: gmd_debug.put_line('Event key ' || l_Event_key);
2473: END IF;
2474:
2475: OPEN get_from_role;
2476: FETCH get_from_role

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

2561: l_wip_spec.find_spec_with_step := 'N';
2562: END IF; */
2563:
2564: IF (l_debug = 'Y') THEN
2565: gmd_debug.put_line('Checking for WIP Spec ');
2566: END IF;
2567:
2568: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(p_wip_spec_rec => l_wip_spec,
2569: x_spec_id => l_spec_id,

Line 2575: gmd_debug.put_line('WIP Spec Found: ' || l_Spec_id || ' ' ||

2571: x_return_status => l_return_status,
2572: x_message_data => l_msg_data) THEN
2573:
2574: IF (l_debug = 'Y') THEN
2575: gmd_debug.put_line('WIP Spec Found: ' || l_Spec_id || ' ' ||
2576: l_spec_vr_id);
2577: END IF;
2578:
2579: /* RLNAGARA Bug 5032406 (FP of 4604305 ME) Assigning values to l_spec_name and l_spec_vers */

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

2684: END IF;
2685:
2686: l_doc_number := quality_config.sample_assignment_type;
2687: IF (l_debug = 'Y') THEN
2688: gmd_debug.put_line('Auto sample flag: ' || l_auto_sample);
2689: END IF;
2690:
2691: -- Bug 4165704: took out reference to wip_sample_plan cursor and put in l_sample_plan_exists
2692: IF l_sample_plan_exists = 1 THEN

Line 2742: gmd_debug.put_line('peter WIP Transaction, l_step_qty_um = ' ||

2738:
2739: --Begin Bug 6807847. For PO Transactions l_trans_qty_uom is in unit_of_measure.
2740: --Hence get corresponding uom_code from unit_of_measure.
2741: IF (l_debug = 'Y') THEN
2742: gmd_debug.put_line('peter WIP Transaction, l_step_qty_um = ' ||
2743: l_step_qty_um);
2744: gmd_debug.put_line('peter WIP Transaction, l_plan_step_qty = ' ||
2745: l_plan_step_qty);
2746:

Line 2744: gmd_debug.put_line('peter WIP Transaction, l_plan_step_qty = ' ||

2740: --Hence get corresponding uom_code from unit_of_measure.
2741: IF (l_debug = 'Y') THEN
2742: gmd_debug.put_line('peter WIP Transaction, l_step_qty_um = ' ||
2743: l_step_qty_um);
2744: gmd_debug.put_line('peter WIP Transaction, l_plan_step_qty = ' ||
2745: l_plan_step_qty);
2746:
2747: END IF;
2748:

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

2754:
2755: EXCEPTION
2756: WHEN OTHERS THEN
2757: IF (l_debug = 'Y') THEN
2758: gmd_debug.put_line('Unable to fetch uom_code from mtl_units_of_measure');
2759: END IF;
2760: RAISE FND_API.G_EXC_ERROR;
2761: END; */
2762:

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

2775:
2776: --Bug 6807847
2777: IF l_qty_conv = -99999 THEN
2778: IF (l_debug = 'Y') THEN
2779: gmd_debug.put_line('ERROR1 in function INV_CONVERT.inv_um_convert');
2780: END IF;
2781: RAISE FND_API.G_EXC_ERROR;
2782: END IF;
2783:

Line 2790: gmd_debug.put_line('peter WIP Transaction, l_sampling_events.sample_req_cnt = ' ||

2786: l_frequency_count) *
2787: l_sample_count;
2788:
2789: IF (l_debug = 'Y') THEN
2790: gmd_debug.put_line('peter WIP Transaction, l_sampling_events.sample_req_cnt = ' ||
2791: l_sampling_events.sample_req_cnt);
2792: END IF;
2793:
2794: END IF; -- IF (l_frequency_type = 'Q') THEN

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

2938: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
2939: l_event_spec_disp.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2940:
2941: IF (l_debug = 'Y') THEN
2942: gmd_debug.put_line('Going to insert event spec disp');
2943: END IF;
2944:
2945: IF NOT
2946: GMD_EVENT_SPEC_DISP_PVT.insert_row(p_event_spec_disp => l_event_spec_disp,

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

2950: END IF;
2951: l_event_spec_disp := l_event_spec_disp_out;
2952:
2953: IF (l_debug = 'Y') THEN
2954: gmd_debug.put_line('Created event spec disp');
2955: END IF;
2956: END IF; /* End of check to create event spec for non-auto sample */
2957:
2958: IF l_step_id is NOT NULL THEN

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

2973: END IF;
2974: END IF;
2975:
2976: IF (l_debug = 'Y') THEN
2977: gmd_debug.put_line('Ckecking for approver ');
2978: END IF;
2979:
2980: /* Start the Workflow for the Given Combination */
2981: AME_API.CLEARALLAPPROVALS(applicationIdIn => l_application_id,

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

3010: AME_UTIL.PERSONIDTOUSERID(Approver.person_id);
3011: END IF;
3012:
3013: IF (l_debug = 'Y') THEN
3014: gmd_debug.put_line('Approver Found ');
3015: END IF;
3016:
3017: l_itemtype := 'GMDQMSMC';
3018: l_itemkey := l_event_key || '-' || l_step_id || '-' ||