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 305: gmd_debug.put_line('Begin of modify_status() ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

867: END IF;
868: END IF;
869:
870: IF (l_debug = 'Y') THEN
871: gmd_debug.put_line('After ERES implementation');
872: END IF;
873:
874: IF (l_eSignature_status IN ('S','P') ) THEN
875: x_return_status := l_eSignature_status;

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

900: ,p_encoded => FND_API.g_false
901: ,p_data => x_message_list);
902:
903: IF (l_debug = 'Y') THEN
904: gmd_debug.put_line('Status was updated successfullly');
905: END IF;
906:
907: IF (l_debug = 'Y') THEN
908: gmd_debug.put_line('Completed '||l_api_name ||' at '

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

904: gmd_debug.put_line('Status was updated successfullly');
905: END IF;
906:
907: IF (l_debug = 'Y') THEN
908: gmd_debug.put_line('Completed '||l_api_name ||' at '
909: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
910: END IF;
911:
912: EXCEPTION

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

912: EXCEPTION
913: WHEN status_update_failure OR invalid_version THEN
914: ROLLBACK TO SAVEPOINT modify_status;
915: IF (l_debug = 'Y') THEN
916: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
917: END IF;
918: fnd_msg_pub.count_and_get (
919: p_count => x_message_count
920: ,p_encoded => FND_API.g_false

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

931: ROLLBACK TO SAVEPOINT modify_status;
932: x_return_status := FND_API.G_RET_STS_ERROR;
933:
934: IF (l_debug = 'Y') THEN
935: gmd_debug.put_line ('In locked exception section ');
936: END IF;
937: SELECT DECODE(P_entity_name,
938: 'FORMULA','FM_FORM_MST_B',
939: 'RECIPE','GMD_RECIPES_B',

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

953: WHEN OTHERS THEN
954: ROLLBACK TO SAVEPOINT modify_status;
955: fnd_msg_pub.add_exc_msg (gmd_status_pub.m_pkg_name, l_api_name);
956: IF (l_debug = 'Y') THEN
957: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
958: END IF;
959: fnd_msg_pub.count_and_get (
960: p_count => x_message_count
961: ,p_encoded => FND_API.g_false