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.CST_DIAGNOSTICS_PKG dependencies on CST_DIAG_TXN_ERRORS

Line 80: INSERT INTO CST_DIAG_TXN_ERRORS (TRANSACTION_ID,

76: AND ORGANIZATION_ID =L_ORG_ID;
77:
78: IF L_C_TXN_ID IS NULL
79: THEN
80: INSERT INTO CST_DIAG_TXN_ERRORS (TRANSACTION_ID,
81: ERROR_MESSAGE,RESOLUTION)
82: VALUES(TXN_ID,'COMPLETION TRANSACTION_ID NOT STAMPED.',NULL);
83: ELSE
84: SELECT COSTED_FLAG

Line 92: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

88: AND TRANSACTION_SOURCE_TYPE_ID = 5
89: AND TRANSACTION_ACTION_ID NOT IN (1, 27, 33, 34);
90:
91: IF ( L_COSTED_FLAG IS NULL) THEN
92: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
93: ERROR_MESSAGE,RESOLUTION)
94: VALUES(TXN_ID,'COMPLETION COSTED-ORPHANED TRANSACTION',NULL);
95: END IF;
96: END IF;

Line 99: INSERT INTO CST_DIAG_TXN_ERRORS (TRANSACTION_ID,

95: END IF;
96: END IF;
97: EXCEPTION
98: WHEN NO_DATA_FOUND THEN
99: INSERT INTO CST_DIAG_TXN_ERRORS (TRANSACTION_ID,
100: ERROR_MESSAGE,RESOLUTION)
101: VALUES(TXN_ID,'INCORRECT COMPLETION_TRANSACTION_ID',NULL);
102: END;
103:

Line 637: DELETE FROM CST_DIAG_TXN_ERRORS;

633: L_WMTI_COUNT NUMBER;
634: L_LOGICAL_TXN_CRTD NUMBER;
635:
636: BEGIN
637: DELETE FROM CST_DIAG_TXN_ERRORS;
638:
639: SELECT MIN(FCR.REQUEST_ID)
640: INTO L_MIN_REQUEST_ID
641: FROM FND_CONCURRENT_REQUESTS FCR

Line 672: --DELETE FROM CST_DIAG_TXN_ERRORS;

668: --DBMS_OUTPUT.PUT_LINE('COST CUT-OFF DATE : = '|| L_COST_CUTOFF_DATE);
669:
670: --DBMS_OUTPUT.PUT_LINE('DELETE TEMP TABLE!!!');
671:
672: --DELETE FROM CST_DIAG_TXN_ERRORS;
673:
674:
675: IF (L_PRIMARY_COST_METHOD =1)
676: THEN

Line 694: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

690: --DBMS_OUTPUT.PUT_LINE('TXN DATE :='||ITEM_REC.TRANSACTION_DATE);
691:
692: IF( ITEM_REC.TRANSACTION_GROUP_ID IS NOT NULL AND ITEM_REC.COSTED_FLAG ='N') THEN
693: --DBMS_OUTPUT.PUT_LINE('TRANSACTION_GROUP_ID IS NOT NULL FOR TRANSACTION WITH COSTED FLAG N');
694: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
695: ERROR_MESSAGE,RESOLUTION)
696: VALUES(ITEM_REC.TRANSACTION_ID,'TRANSACTION_GROUP_ID NOT NULL',NULL);
697:
698: ELSIF ( ITEM_REC.TRANSACTION_DATE >L_COST_CUTOFF_DATE) THEN

Line 701: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

697:
698: ELSIF ( ITEM_REC.TRANSACTION_DATE >L_COST_CUTOFF_DATE) THEN
699:
700: --DBMS_OUTPUT.PUT_LINE('COST CUTT OFF DATE CHECK');
701: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
702: ERROR_MESSAGE,RESOLUTION)
703: VALUES(ITEM_REC.TRANSACTION_ID,'TXN DATE IS LATER THEN COST CUTOFF DATE FOR ORG',NULL);
704: ELSIF /* A */
705: ( ITEM_REC.TRANSACTION_ACTION_ID IN (1, 27, 33, 34)

Line 714: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

710: ELSIF /* B */
711: ( ITEM_REC.TRANSACTION_ACTION_ID NOT IN (2,28,3,55,5)
712: AND ITEM_REC.TRANSFER_TRANSACTION_ID IS NOT NULL ) THEN
713: --DBMS_OUTPUT.PUT_LINE('TRANSFER TRANSACTION_ID CHECK');
714: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
715: ERROR_MESSAGE,RESOLUTION)
716: VALUES(ITEM_REC.TRANSACTION_ID,'INCORRECT TRANSFER_TRANSACTION_ID',NULL);
717: ELSIF /* C */
718: ( ITEM_REC.TRANSACTION_ACTION_ID IN (3,21,12) AND NVL(L_TRF_ORG_CST_METHOD,1) <>1 ) THEN

Line 720: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

716: VALUES(ITEM_REC.TRANSACTION_ID,'INCORRECT TRANSFER_TRANSACTION_ID',NULL);
717: ELSIF /* C */
718: ( ITEM_REC.TRANSACTION_ACTION_ID IN (3,21,12) AND NVL(L_TRF_ORG_CST_METHOD,1) <>1 ) THEN
719: --DBMS_OUTPUT.PUT_LINE('RUN CHECKS FOR TRANSFER ORGANIZATION_ID '|| ITEM_REC.TRANSFER_ORGANIZATION_ID);
720: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
721: ERROR_MESSAGE,RESOLUTION)
722: VALUES(NULL,'RUN CHECKS FOR TRANSFER ORGANIZATION_ID '|| ITEM_REC.TRANSFER_ORGANIZATION_ID,NULL);
723:
724: ELSIF /* F Only if WSM is enabled */

Line 757: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

753: AND WE.ORGANIZATION_ID = MMT.ORGANIZATION_ID
754: AND WE.ENTITY_TYPE = 5;
755:
756: IF ( L_LOT_FLAG =1 AND ITEM_REC.TRANSACTION_DATE < L_MIN_TXN_DTE ) THEN
757: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
758: ERROR_MESSAGE,RESOLUTION)
759: VALUES(ITEM_REC.TRANSACTION_ID,'ERRORED RECORDS IN MMT/WCTI FOR LOT BASED JOB',NULL);
760: END IF;
761:

Line 764: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

760: END IF;
761:
762: ELSIF( C_UNCOSTED_TRANSACTIONS%ROWCOUNT >0) THEN
763: --DBMS_OUTPUT.PUT_LINE('REPORT COSTING BUG');
764: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
765: ERROR_MESSAGE,RESOLUTION)
766: VALUES(ITEM_REC.TRANSACTION_ID,'REPORT A BUG WITH COSTING DEVELOPMENT',NULL);
767: ELSE
768: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

Line 768: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

764: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
765: ERROR_MESSAGE,RESOLUTION)
766: VALUES(ITEM_REC.TRANSACTION_ID,'REPORT A BUG WITH COSTING DEVELOPMENT',NULL);
767: ELSE
768: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
769: ERROR_MESSAGE,RESOLUTION)
770: VALUES(NULL,'NO UNCOSTED TRANSACTIONS FOUND!!',NULL);
771: END IF;
772: END LOOP;

Line 819: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

815:
816: IF (L_TXN_DATE >L_COST_CUTOFF_DATE)
817: THEN
818: --DBMS_OUTPUT.PUT_LINE('COST CUTT OFF DATE CHECK');
819: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
820: ERROR_MESSAGE,RESOLUTION)
821: VALUES(L_BOTTLE_NECK_TXN_ID,'TXN DATE IS LATER THEN COST CUTOFF DATE FOR ORG',NULL);
822: ELSIF (L_LOGICAL_TXN_CRTD = 2) THEN
823: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

Line 823: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

819: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
820: ERROR_MESSAGE,RESOLUTION)
821: VALUES(L_BOTTLE_NECK_TXN_ID,'TXN DATE IS LATER THEN COST CUTOFF DATE FOR ORG',NULL);
822: ELSIF (L_LOGICAL_TXN_CRTD = 2) THEN
823: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
824: ERROR_MESSAGE,RESOLUTION)
825: VALUES(L_BOTTLE_NECK_TXN_ID,'LOGICAL TRANSACTIONS FOR THIS TRANSACTION HAVE NOT BEEN CREATED',NULL);
826:
827: ELSIF /* A - CHECK MMTT FOR BACK FLUSH TRANSACTIONS*/

Line 842: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

838: OR MMTT.MOVE_TRANSACTION_ID = SC.MOVE_TRANSACTION_ID);
839:
840: IF (L_MMTT_COUNT > 0) THEN
841: --DBMS_OUTPUT.PUT_LINE('TRANSACTIONS STUCK IN MMTT');
842: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
843: ERROR_MESSAGE,RESOLUTION)
844: VALUES(L_BOTTLE_NECK_TXN_ID,L_MMTT_COUNT||' TRANSACTIONS ARE STUCK IN MMTT, CLEAR THEM BEFORE PROCEDDING',NULL);
845: END IF;
846:

Line 853: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

849: FROM WIP_MOVE_TXN_INTERFACE WMTI
850: WHERE WMTI.TRANSACTION_ID = L_TXN_MOVE_TXN_ID ;
851: IF (L_WMTI_COUNT > 0) THEN
852:
853: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
854: ERROR_MESSAGE,RESOLUTION)
855: VALUES(L_BOTTLE_NECK_TXN_ID,L_WMTI_COUNT||' TRANSACTIONS ARE STUCK IN WMTI, CLEAR THEM BEFORE PROCEDDING',NULL);
856: END IF;
857:

Line 876: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

872:
873: IF (L_TRANSFER_COST IS NOT NULL )
874: THEN
875: --DBMS_OUTPUT.PUT_LINE('TRANSFER COST IS NULL FOR DIRECT INTER_ORG TRANSFERS');
876: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
877: ERROR_MESSAGE,RESOLUTION)
878: VALUES(L_BOTTLE_NECK_TXN_ID,'TRANSFER COST IS NULL FOR DIRECT INTER_ORG TRANSFERS',NULL);
879: END IF;
880: ELSIF /* C - INTER ORGS */

Line 899: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

895:
896: IF (L_SHIPMENT_COSTED IS NOT NULL )
897: THEN
898: --DBMS_OUTPUT.PUT_LINE('THE SHIPMENT COSTED SHOULD BE Y');
899: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
900: ERROR_MESSAGE,RESOLUTION)
901: VALUES(L_BOTTLE_NECK_TXN_ID,'THE SHIPMENT COSTED SHOULD BE Y',NULL);
902: END IF;
903:

Line 907: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

903:
904: ELSIF /* D - ERRORED TRANSACTION */
905: ( L_TXN_COSTED_FLAG ='E' ) THEN
906: --DBMS_OUTPUT.PUT_LINE('THE TRANSACTION ERRORED');
907: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
908: ERROR_MESSAGE,RESOLUTION)
909: VALUES(L_BOTTLE_NECK_TXN_ID,'TRANSACTION ERRORED NEEDS TO BE RESOLVED',NULL);
910: ELSIF ( L_TXN_ACTION_ID IN (3,21,12)) THEN
911: --DBMS_OUTPUT.PUT_LINE('RUN CHECKS FOR TRANSFER ORGANIZATION_ID '|| L_TXN_TXFR_ORG);

Line 912: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

908: ERROR_MESSAGE,RESOLUTION)
909: VALUES(L_BOTTLE_NECK_TXN_ID,'TRANSACTION ERRORED NEEDS TO BE RESOLVED',NULL);
910: ELSIF ( L_TXN_ACTION_ID IN (3,21,12)) THEN
911: --DBMS_OUTPUT.PUT_LINE('RUN CHECKS FOR TRANSFER ORGANIZATION_ID '|| L_TXN_TXFR_ORG);
912: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
913: ERROR_MESSAGE,RESOLUTION)
914: VALUES(NULL,'RUN CHECKS FOR TRANSFER ORGANIZATION_ID '|| L_TXN_TXFR_TXN_ID,NULL);
915: ELSIF(L_BOTTLE_NECK_TXN_ID is NOT NULL) THEN
916: --DBMS_OUTPUT.PUT_LINE('REPORT COSTING BUG');

Line 917: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

913: ERROR_MESSAGE,RESOLUTION)
914: VALUES(NULL,'RUN CHECKS FOR TRANSFER ORGANIZATION_ID '|| L_TXN_TXFR_TXN_ID,NULL);
915: ELSIF(L_BOTTLE_NECK_TXN_ID is NOT NULL) THEN
916: --DBMS_OUTPUT.PUT_LINE('REPORT COSTING BUG');
917: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
918: ERROR_MESSAGE,RESOLUTION)
919: VALUES(L_BOTTLE_NECK_TXN_ID,'REPORT A BUG WITH COSTING DEVELOPMENT',NULL);
920: ELSE
921: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

Line 921: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

917: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
918: ERROR_MESSAGE,RESOLUTION)
919: VALUES(L_BOTTLE_NECK_TXN_ID,'REPORT A BUG WITH COSTING DEVELOPMENT',NULL);
920: ELSE
921: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
922: ERROR_MESSAGE,RESOLUTION)
923: VALUES(NULL,'NO UNCOSTED TRANSACTIONS FOUND!!',NULL);
924:
925: END IF;

Line 930: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,

926: END IF;
927:
928: EXCEPTION
929: WHEN COST_MANAGER_INACTIVE THEN
930: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,
931: ERROR_MESSAGE,RESOLUTION)
932: VALUES(NULL,'COST MANAGER IS INACTIVE','LAUNCH THE COST MANAGER TO GET THE TRANSACTIONS COSTED');
933: END Check_Transactions_MMT;
934: