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.OKS_IMPORT_VALIDATE dependencies on OKS_USAGE_COUNTERS_INTERFACE

Line 4706: ,'OKS_USAGE_COUNTERS_INTERFACE'

4702: ,ERROR_MSG
4703: ,MSG_TOKENS)
4704: VALUES (G_WORKER_REQ_ID
4705: ,HEADER_INTERFACE_ROWID
4706: ,'OKS_USAGE_COUNTERS_INTERFACE'
4707: , USAGE_COUNTER_INTERFACE_ID
4708: ,'OKS_IMP_UCTR_INVALID_LINTID'
4709: ,NULL )
4710: WHEN (LINE_NUMBER IS NULL OR DUP_LINE_NUMBER_COUNT >0 OR LINE_NUMBER <= 0 OR floor(LINE_NUMBER) <> LINE_NUMBER) THEN

Line 4720: ,'OKS_USAGE_COUNTERS_INTERFACE'

4716: ,ERROR_MSG
4717: ,MSG_TOKENS)
4718: VALUES (G_WORKER_REQ_ID
4719: ,HEADER_INTERFACE_ROWID
4720: ,'OKS_USAGE_COUNTERS_INTERFACE'
4721: ,USAGE_COUNTER_INTERFACE_ID
4722: ,'OKS_IMP_UCTR_INVALID_LINNUM'
4723: ,NULL)
4724: WHEN (CNTR_VALID_YN = 'N' ) THEN

Line 4734: ,'OKS_USAGE_COUNTERS_INTERFACE'

4730: ,ERROR_MSG
4731: ,MSG_TOKENS)
4732: VALUES (G_WORKER_REQ_ID
4733: ,HEADER_INTERFACE_ROWID
4734: ,'OKS_USAGE_COUNTERS_INTERFACE'
4735: ,USAGE_COUNTER_INTERFACE_ID
4736: ,'OKS_IMP_UCTR_INVALID_CNTRID'
4737: ,NULL)
4738: WHEN (START_DATE IS NULL OR START_DATE_VALID ='N' ) THEN

Line 4748: ,'OKS_USAGE_COUNTERS_INTERFACE'

4744: ,ERROR_MSG
4745: ,MSG_TOKENS)
4746: VALUES (G_WORKER_REQ_ID
4747: ,HEADER_INTERFACE_ROWID
4748: ,'OKS_USAGE_COUNTERS_INTERFACE'
4749: ,USAGE_COUNTER_INTERFACE_ID
4750: ,'OKS_IMP_UCTR_INVALID_STRDT'
4751: ,NULL)
4752:

Line 4763: ,'OKS_USAGE_COUNTERS_INTERFACE'

4759: ,ERROR_MSG
4760: ,MSG_TOKENS)
4761: VALUES (G_WORKER_REQ_ID
4762: ,HEADER_INTERFACE_ROWID
4763: ,'OKS_USAGE_COUNTERS_INTERFACE'
4764: ,USAGE_COUNTER_INTERFACE_ID
4765: ,'OKS_IMP_UCTR_INVALID_ENDDT'
4766: ,NULL)
4767:

Line 4778: ,'OKS_USAGE_COUNTERS_INTERFACE'

4774: ,ERROR_MSG
4775: ,MSG_TOKENS)
4776: VALUES (G_WORKER_REQ_ID
4777: ,HEADER_INTERFACE_ROWID
4778: ,'OKS_USAGE_COUNTERS_INTERFACE'
4779: ,USAGE_COUNTER_INTERFACE_ID
4780: ,'OKS_IMP_UCTR_INVALID_STSCODE'
4781: ,NULL)
4782: WHEN (DATE_USGCNT_STS_VALID ='N') THEN

Line 4792: ,'OKS_USAGE_COUNTERS_INTERFACE'

4788: ,ERROR_MSG
4789: ,MSG_TOKENS)
4790: VALUES (G_WORKER_REQ_ID
4791: ,HEADER_INTERFACE_ROWID
4792: ,'OKS_USAGE_COUNTERS_INTERFACE'
4793: ,USAGE_COUNTER_INTERFACE_ID
4794: ,'OKS_IMP_USGCNT_INVALID_STS_DT'
4795: ,NULL)
4796:

Line 4807: ,'OKS_USAGE_COUNTERS_INTERFACE'

4803: ,ERROR_MSG
4804: ,MSG_TOKENS)
4805: VALUES (G_WORKER_REQ_ID
4806: ,HEADER_INTERFACE_ROWID
4807: ,'OKS_USAGE_COUNTERS_INTERFACE'
4808: ,USAGE_COUNTER_INTERFACE_ID
4809: ,'OKS_IMP_UCTR_INVALID_RNWLCD'
4810: ,NULL)
4811: WHEN (DATE_CANC_VALID ='N' OR DATE_CANC_NULL ='Y') THEN

Line 4821: ,'OKS_USAGE_COUNTERS_INTERFACE'

4817: ,ERROR_MSG
4818: ,MSG_TOKENS)
4819: VALUES (G_WORKER_REQ_ID
4820: ,HEADER_INTERFACE_ROWID
4821: ,'OKS_USAGE_COUNTERS_INTERFACE'
4822: ,USAGE_COUNTER_INTERFACE_ID
4823: ,'OKS_IMP_UCTR_INVALID_CNCLDT'
4824: ,NULL)
4825: WHEN (CR_VALID ='N' OR CR_NULL ='Y') THEN

Line 4835: ,'OKS_USAGE_COUNTERS_INTERFACE'

4831: ,ERROR_MSG
4832: ,MSG_TOKENS)
4833: VALUES (G_WORKER_REQ_ID
4834: ,HEADER_INTERFACE_ROWID
4835: ,'OKS_USAGE_COUNTERS_INTERFACE'
4836: ,USAGE_COUNTER_INTERFACE_ID
4837: ,'OKS_IMP_UCTR_INVALID_CNCLRSN'
4838: ,NULL)
4839: WHEN (PRINT_INVOICE IS NULL OR (PRINT_INVOICE IS NOT NULL AND PRINT_INVOICE <> 'Y' AND PRINT_INVOICE <> 'N')) THEN

Line 4849: ,'OKS_USAGE_COUNTERS_INTERFACE'

4845: ,ERROR_MSG
4846: ,MSG_TOKENS)
4847: VALUES (G_WORKER_REQ_ID
4848: ,HEADER_INTERFACE_ROWID
4849: ,'OKS_USAGE_COUNTERS_INTERFACE'
4850: ,USAGE_COUNTER_INTERFACE_ID
4851: ,'OKS_IMP_UCTR_INVALID_PRINV'
4852: ,NULL)
4853: WHEN ( SUBTOTAL_VALID = 'N' OR SUBTOTAL <0) THEN

Line 4863: ,'OKS_USAGE_COUNTERS_INTERFACE'

4859: ,ERROR_MSG
4860: ,MSG_TOKENS)
4861: VALUES (G_WORKER_REQ_ID
4862: ,HEADER_INTERFACE_ROWID
4863: ,'OKS_USAGE_COUNTERS_INTERFACE'
4864: ,USAGE_COUNTER_INTERFACE_ID
4865: ,'OKS_IMP_UCTR_INVALID_STOT'
4866: ,NULL)
4867: WHEN (TAX_VALID ='N' OR TAX_AMOUNT < 0 ) THEN

Line 4877: ,'OKS_USAGE_COUNTERS_INTERFACE'

4873: ,ERROR_MSG
4874: ,MSG_TOKENS)
4875: VALUES (G_WORKER_REQ_ID
4876: ,HEADER_INTERFACE_ROWID
4877: ,'OKS_USAGE_COUNTERS_INTERFACE'
4878: ,USAGE_COUNTER_INTERFACE_ID
4879: ,'OKS_IMP_UCTR_INVALID_TAXINV'
4880: ,NULL)
4881: WHEN (FIXED_USG_CNT_VALID = 'N' OR FIXED_USG_CNT_VALID IS NULL OR FIXED_USG_CNT <0 ) THEN

Line 4891: ,'OKS_USAGE_COUNTERS_INTERFACE'

4887: ,ERROR_MSG
4888: ,MSG_TOKENS)
4889: VALUES (G_WORKER_REQ_ID
4890: ,HEADER_INTERFACE_ROWID
4891: ,'OKS_USAGE_COUNTERS_INTERFACE'
4892: ,USAGE_COUNTER_INTERFACE_ID
4893: ,'OKS_IMP_UCTR_INVALID_FIXEDUSG'
4894: ,NULL)
4895: WHEN ( MINIMUM_USG_CNT_VALID ='N' OR MINIMUM_USG_CNT_VALID IS NULL OR MINIMUM_USG_CNT <0 ) THEN

Line 4905: ,'OKS_USAGE_COUNTERS_INTERFACE'

4901: ,ERROR_MSG
4902: ,MSG_TOKENS)
4903: VALUES (G_WORKER_REQ_ID
4904: ,HEADER_INTERFACE_ROWID
4905: ,'OKS_USAGE_COUNTERS_INTERFACE'
4906: ,USAGE_COUNTER_INTERFACE_ID
4907: ,'OKS_IMP_UCTR_INVALID_MINUSG'
4908: ,NULL)
4909: WHEN ( DEFAULT_USG_CNT_VALID='N' OR DEFAULT_USG_CNT_VALID IS NULL OR DEFAULT_USG_CNT < 0 ) THEN

Line 4919: ,'OKS_USAGE_COUNTERS_INTERFACE'

4915: ,ERROR_MSG
4916: ,MSG_TOKENS)
4917: VALUES (G_WORKER_REQ_ID
4918: ,HEADER_INTERFACE_ROWID
4919: ,'OKS_USAGE_COUNTERS_INTERFACE'
4920: ,USAGE_COUNTER_INTERFACE_ID
4921: ,'OKS_IMP_UCTR_INVALID_DEFUSG'
4922: ,NULL)
4923: WHEN (FILL_YN_VALID = 'N' OR ( FILL_YN <> 'Y' AND FILL_YN <> 'N')) THEN

Line 4933: ,'OKS_USAGE_COUNTERS_INTERFACE'

4929: ,ERROR_MSG
4930: ,MSG_TOKENS)
4931: VALUES (G_WORKER_REQ_ID
4932: ,HEADER_INTERFACE_ROWID
4933: ,'OKS_USAGE_COUNTERS_INTERFACE'
4934: ,USAGE_COUNTER_INTERFACE_ID
4935: ,'OKS_IMP_UCTR_INVALID_FILLYN'
4936: ,NULL)
4937: WHEN (ESTIMATION_METHOD_VALID='N' OR ESTMTHD_LKUP_VALID='N') THEN

Line 4947: ,'OKS_USAGE_COUNTERS_INTERFACE'

4943: ,ERROR_MSG
4944: ,MSG_TOKENS)
4945: VALUES (G_WORKER_REQ_ID
4946: ,HEADER_INTERFACE_ROWID
4947: ,'OKS_USAGE_COUNTERS_INTERFACE'
4948: ,USAGE_COUNTER_INTERFACE_ID
4949: ,'OKS_IMP_UCTR_INVALID_ESTMTHD'
4950: ,NULL)
4951: WHEN (EST_STRDT_VALID='N') THEN

Line 4961: ,'OKS_USAGE_COUNTERS_INTERFACE'

4957: ,ERROR_MSG
4958: ,MSG_TOKENS)
4959: VALUES (G_WORKER_REQ_ID
4960: ,HEADER_INTERFACE_ROWID
4961: ,'OKS_USAGE_COUNTERS_INTERFACE'
4962: ,USAGE_COUNTER_INTERFACE_ID
4963: ,'OKS_IMP_UCTR_INVALID_ESTSRTDT'
4964: ,NULL)
4965: WHEN (LEVEL_YN_VALID ='N' OR (LEVEL_YN is not NULL and LEVEL_YN <>'Y' AND LEVEL_YN <>'N')) THEN

Line 4975: ,'OKS_USAGE_COUNTERS_INTERFACE'

4971: ,ERROR_MSG
4972: ,MSG_TOKENS)
4973: VALUES (G_WORKER_REQ_ID
4974: ,HEADER_INTERFACE_ROWID
4975: ,'OKS_USAGE_COUNTERS_INTERFACE'
4976: ,USAGE_COUNTER_INTERFACE_ID
4977: ,'OKS_IMP_UCTR_INVALID_LVLYN'
4978: ,NULL)
4979:

Line 5115: FROM OKS_USAGE_COUNTERS_INTERFACE OUSGCNTR

5111: WHEN CSI_CNTR.USAGE_ITEM_ID <> OLSTG.ITEM_ID THEN 'N'
5112: ELSE 'Y'
5113: END ) CNTR_VALID_YN
5114:
5115: FROM OKS_USAGE_COUNTERS_INTERFACE OUSGCNTR
5116: ,OKS_USAGE_COUNTERS_INTERFACE OUSGLIN
5117: ,OKS_INT_LINE_STG_TEMP OLSTG
5118: ,FND_LOOKUPS ESTMTHD
5119: ,OKC_STATUSES_B STS

Line 5116: ,OKS_USAGE_COUNTERS_INTERFACE OUSGLIN

5112: ELSE 'Y'
5113: END ) CNTR_VALID_YN
5114:
5115: FROM OKS_USAGE_COUNTERS_INTERFACE OUSGCNTR
5116: ,OKS_USAGE_COUNTERS_INTERFACE OUSGLIN
5117: ,OKS_INT_LINE_STG_TEMP OLSTG
5118: ,FND_LOOKUPS ESTMTHD
5119: ,OKC_STATUSES_B STS
5120: ,FND_LOOKUPS CR1