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_STATUS_PUB dependencies on GMD_DEBUG

Line 309: gmd_debug.put_line('Begin of modify_status() ');

305:
306: SAVEPOINT modify_status;
307:
308: IF l_debug = 'Y' THEN
309: gmd_debug.put_line('Begin of modify_status() ');
310: END IF;
311:
312: /* Set the return status to success initially */
313: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 396: gmd_debug.put_line('For TOQ - P_entity_id is '||l_entity_id);

392: -- use or Lab use for formulas created with a total output qty of zero
393: IF (l_to_status_type IN (400,700)) THEN
394:
395: IF l_debug = 'Y' THEN
396: gmd_debug.put_line('For TOQ - P_entity_id is '||l_entity_id);
397: END IF;
398:
399: OPEN get_fm_toq(l_Entity_id);
400: FETCH get_fm_toq INTO l_toq;

Line 404: gmd_debug.put_line('TOQ value is '||l_toq);

400: FETCH get_fm_toq INTO l_toq;
401: CLOSE get_fm_toq;
402:
403: IF l_debug = 'Y' THEN
404: gmd_debug.put_line('TOQ value is '||l_toq);
405: END IF;
406:
407: IF (l_toq = 0) THEN
408: FND_MESSAGE.SET_NAME('GMD','GMD_TOTAL_OUTPUT_ZERO');

Line 477: gmd_debug.put_line('The return status after calling val operation is '||

473: status for this operation to 700 or 400. */
474: IF (to_number(l_to_status_type) IN (400,700)) THEN
475: validate_operation(l_entity_id, x_return_status);
476: IF l_debug = 'Y' THEN
477: gmd_debug.put_line('The return status after calling val operation is '||
478: x_return_status);
479: END IF;
480: IF (x_return_status = FND_API.g_ret_sts_error) THEN
481: RAISE status_update_failure;

Line 577: gmd_debug.put_line('The entity details are Entity_name = '||l_entity_name

573: RAISE status_update_failure;
574: END IF;
575:
576: IF (l_debug = 'Y') THEN
577: gmd_debug.put_line('The entity details are Entity_name = '||l_entity_name
578: ||', Entity Id = '||l_entity_id||', Entity no is '||l_entity_no
579: ||', Entity version is '||l_entity_version
580: ||' and its status is '||l_from_status);
581:

Line 582: gmd_debug.put_line('About to verify if the To status is valid '||

578: ||', Entity Id = '||l_entity_id||', Entity no is '||l_entity_no
579: ||', Entity version is '||l_entity_version
580: ||' and its status is '||l_from_status);
581:
582: gmd_debug.put_line('About to verify if the To status is valid '||
583: 'the From status is '||l_from_status||' and To status is '||P_to_status);
584: END IF;
585:
586:

Line 614: gmd_debug.put_line('From status type = '||l_from_status_type

610: RETURN;
611: END IF;
612:
613: IF (l_debug = 'Y') THEN
614: gmd_debug.put_line('From status type = '||l_from_status_type
615: ||', From Status desc = '||l_from_status_desc
616: ||' and target status = '||l_target_status);
617: END IF;
618:

Line 623: gmd_debug.put_line('Checking the Parent status dependency for '||l_entity_name);

619: /* Check parent status */
620: -- Check if entity is already in use before putting it on hold
621: -- or obsoleting it.
622: IF (l_debug = 'Y') THEN
623: gmd_debug.put_line('Checking the Parent status dependency for '||l_entity_name);
624: END IF;
625: IF (to_number(l_to_status_type) IN (800, 1000)) THEN
626: IF (NOT gmd_status_code.check_parent_status(l_entity_name
627: ,l_entity_id)) THEN

Line 653: gmd_debug.put_line('Checking the Dependent status, From status = '||l_from_status

649: END IF; -- Checking parent status
650: END IF;
651:
652: IF (l_debug = 'Y') THEN
653: gmd_debug.put_line('Checking the Dependent status, From status = '||l_from_status
654: ||' To Status '||p_to_status);
655: END IF;
656:
657: /* Check Dependent Status */

Line 685: gmd_debug.put_line('Dependent status are valid, about to check if recipes'||

681: RAISE status_update_failure;
682: ELSE
683:
684: IF (l_debug = 'Y') THEN
685: gmd_debug.put_line('Dependent status are valid, about to check if recipes'||
686: ' have any VRs , The from status type = '||l_from_status_type);
687: END IF;
688:
689: -- Only when entity is 'RECIPE'

Line 701: gmd_debug.put_line('about to derive l_chk_vr, l_entity_id is '||l_entity_id);

697: FETCH check_val_rules_900 into l_check_vr ;
698: CLOSE check_val_rules_900 ;
699: ELSIF (to_number(l_to_status_type) = 1000) THEN
700: IF (l_debug = 'Y') THEN
701: gmd_debug.put_line('about to derive l_chk_vr, l_entity_id is '||l_entity_id);
702: END IF;
703: OPEN check_val_rules_1000(l_entity_id) ;
704: FETCH check_val_rules_1000 into l_check_vr ;
705: CLOSE check_val_rules_1000 ;

Line 709: gmd_debug.put_line('Dependent status are valid and check VR = '||l_check_vr);

705: CLOSE check_val_rules_1000 ;
706: END IF ;
707:
708: IF (l_debug = 'Y') THEN
709: gmd_debug.put_line('Dependent status are valid and check VR = '||l_check_vr);
710: END IF;
711:
712: IF l_check_vr = 1 THEN
713: /*ERES Implementation - If approvals are required for the */

Line 742: gmd_debug.put_line('Ignore flag was true and we are about update VR ');

738: WHERE recipe_id = l_entity_id
739: AND to_number(validity_rule_status) < to_number('800') ;
740: ELSIF (to_number(l_to_status_type) = 1000) THEN
741: IF (l_debug = 'Y') THEN
742: gmd_debug.put_line('Ignore flag was true and we are about update VR ');
743: END IF;
744: UPDATE gmd_recipe_validity_rules
745: SET validity_rule_status = P_to_status
746: WHERE recipe_id = l_entity_id

Line 763: gmd_debug.put_line('About to get the pending and rework status ');

759:
760: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
761: IF (l_from_status <> P_to_status) THEN
762: IF (l_debug = 'Y') THEN
763: gmd_debug.put_line('About to get the pending and rework status ');
764: END IF;
765: /* Added the following code as part of ERES Implementation */
766: l_pending_status := GMD_STATUS_CODE.get_pending_status
767: (p_from_status => l_from_status

Line 775: gmd_debug.put_line('Pending and Rework status is '||l_pending_status

771: (p_from_status => l_from_status
772: ,p_to_status => P_to_status);
773:
774: IF (l_debug = 'Y') THEN
775: gmd_debug.put_line('Pending and Rework status is '||l_pending_status
776: ||' and '||l_rework_status);
777:
778: gmd_debug.put_line('About to impement ERES for '||l_entity_name||
779: ' Entity id is '||l_entity_id||' the To status is '||P_to_status||

Line 778: gmd_debug.put_line('About to impement ERES for '||l_entity_name||

774: IF (l_debug = 'Y') THEN
775: gmd_debug.put_line('Pending and Rework status is '||l_pending_status
776: ||' and '||l_rework_status);
777:
778: gmd_debug.put_line('About to impement ERES for '||l_entity_name||
779: ' Entity id is '||l_entity_id||' the To status is '||P_to_status||
780: ' the entity no is '||l_entity_no||' the version is '||l_entity_version);
781: END IF;
782:

Line 799: gmd_debug.put_line('In GMD Status Pub - About call ERES Util for update Recipe ');

795:
796: ELSIF (l_entity_name = 'RECIPE') THEN
797:
798: IF l_debug = 'Y' THEN
799: gmd_debug.put_line('In GMD Status Pub - About call ERES Util for update Recipe ');
800: END IF;
801:
802: GMD_ERES_UTILS.update_recipe_status
803: (p_recipe_id => l_entity_id

Line 814: gmd_debug.put_line('In GMD Status Pub - After call ERES Util for update Recipe ');

810: ,p_called_from_form => 'T'
811: ,x_return_status => l_eSignature_status);
812:
813: IF l_debug = 'Y' THEN
814: gmd_debug.put_line('In GMD Status Pub - After call ERES Util for update Recipe ');
815: END IF;
816:
817: ELSIF(l_entity_name = 'OPERATION') THEN
818:

Line 857: gmd_debug.put_line('In GMD Status Pub - About call ERES Util for update substitution ');

853: -- Bug 5394532
854: ELSIF (l_entity_name = 'SUBSTITUTION') THEN
855:
856: IF l_debug = 'Y' THEN
857: gmd_debug.put_line('In GMD Status Pub - About call ERES Util for update substitution ');
858: END IF;
859:
860: GMD_ERES_UTILS.update_substitution_status
861: (p_substitution_id => l_entity_id

Line 870: gmd_debug.put_line('In GMD Status Pub - After call ERES Util for update substitution ');

866: ,p_called_from_form => 'T'
867: ,x_return_status => l_eSignature_status);
868:
869: IF l_debug = 'Y' THEN
870: gmd_debug.put_line('In GMD Status Pub - After call ERES Util for update substitution ');
871: END IF;
872: END IF;
873:
874: IF (l_debug = 'Y') THEN

Line 875: gmd_debug.put_line('After ERES implementation');

871: END IF;
872: END IF;
873:
874: IF (l_debug = 'Y') THEN
875: gmd_debug.put_line('After ERES implementation');
876: END IF;
877:
878: IF (l_eSignature_status IN ('S','P') ) THEN
879: x_return_status := l_eSignature_status;

Line 910: gmd_debug.put_line('Status was updated successfullly');

906: ,p_encoded => FND_API.g_false
907: ,p_data => x_message_list);
908:
909: IF (l_debug = 'Y') THEN
910: gmd_debug.put_line('Status was updated successfullly');
911: END IF;
912:
913: IF (l_debug = 'Y') THEN
914: gmd_debug.put_line('Completed '||l_api_name ||' at '

Line 914: gmd_debug.put_line('Completed '||l_api_name ||' at '

910: gmd_debug.put_line('Status was updated successfullly');
911: END IF;
912:
913: IF (l_debug = 'Y') THEN
914: gmd_debug.put_line('Completed '||l_api_name ||' at '
915: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
916: END IF;
917:
918: EXCEPTION

Line 922: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');

918: EXCEPTION
919: WHEN status_update_failure OR invalid_version THEN
920: ROLLBACK TO SAVEPOINT modify_status;
921: IF (l_debug = 'Y') THEN
922: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
923: END IF;
924: fnd_msg_pub.count_and_get (
925: p_count => x_message_count
926: ,p_encoded => FND_API.g_false

Line 941: gmd_debug.put_line ('In locked exception section ');

937: ROLLBACK TO SAVEPOINT modify_status;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939:
940: IF (l_debug = 'Y') THEN
941: gmd_debug.put_line ('In locked exception section ');
942: END IF;
943: SELECT DECODE(P_entity_name,
944: 'FORMULA','FM_FORM_MST_B',
945: 'RECIPE','GMD_RECIPES_B',

Line 963: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

959: WHEN OTHERS THEN
960: ROLLBACK TO SAVEPOINT modify_status;
961: fnd_msg_pub.add_exc_msg (gmd_status_pub.m_pkg_name, l_api_name);
962: IF (l_debug = 'Y') THEN
963: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
964: END IF;
965: fnd_msg_pub.count_and_get (
966: p_count => x_message_count
967: ,p_encoded => FND_API.g_false