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 4832: ,'OKS_USAGE_COUNTERS_INTERFACE'

4828: ,ERROR_MSG
4829: ,MSG_TOKENS)
4830: VALUES (G_WORKER_REQ_ID
4831: ,HEADER_INTERFACE_ROWID
4832: ,'OKS_USAGE_COUNTERS_INTERFACE'
4833: , USAGE_COUNTER_INTERFACE_ID
4834: ,'OKS_IMP_UCTR_INVALID_LINTID'
4835: ,NULL )
4836: WHEN (LINE_NUMBER IS NULL OR DUP_LINE_NUMBER_COUNT >0 OR LINE_NUMBER <= 0 OR floor(LINE_NUMBER) <> LINE_NUMBER) THEN

Line 4846: ,'OKS_USAGE_COUNTERS_INTERFACE'

4842: ,ERROR_MSG
4843: ,MSG_TOKENS)
4844: VALUES (G_WORKER_REQ_ID
4845: ,HEADER_INTERFACE_ROWID
4846: ,'OKS_USAGE_COUNTERS_INTERFACE'
4847: ,USAGE_COUNTER_INTERFACE_ID
4848: ,'OKS_IMP_UCTR_INVALID_LINNUM'
4849: ,NULL)
4850: WHEN (CNTR_VALID_YN = 'N' ) THEN

Line 4860: ,'OKS_USAGE_COUNTERS_INTERFACE'

4856: ,ERROR_MSG
4857: ,MSG_TOKENS)
4858: VALUES (G_WORKER_REQ_ID
4859: ,HEADER_INTERFACE_ROWID
4860: ,'OKS_USAGE_COUNTERS_INTERFACE'
4861: ,USAGE_COUNTER_INTERFACE_ID
4862: ,'OKS_IMP_UCTR_INVALID_CNTRID'
4863: ,NULL)
4864: WHEN (START_DATE IS NULL OR START_DATE_VALID ='N' ) THEN

Line 4874: ,'OKS_USAGE_COUNTERS_INTERFACE'

4870: ,ERROR_MSG
4871: ,MSG_TOKENS)
4872: VALUES (G_WORKER_REQ_ID
4873: ,HEADER_INTERFACE_ROWID
4874: ,'OKS_USAGE_COUNTERS_INTERFACE'
4875: ,USAGE_COUNTER_INTERFACE_ID
4876: ,'OKS_IMP_UCTR_INVALID_STRDT'
4877: ,NULL)
4878:

Line 4889: ,'OKS_USAGE_COUNTERS_INTERFACE'

4885: ,ERROR_MSG
4886: ,MSG_TOKENS)
4887: VALUES (G_WORKER_REQ_ID
4888: ,HEADER_INTERFACE_ROWID
4889: ,'OKS_USAGE_COUNTERS_INTERFACE'
4890: ,USAGE_COUNTER_INTERFACE_ID
4891: ,'OKS_IMP_UCTR_INVALID_ENDDT'
4892: ,NULL)
4893:

Line 4904: ,'OKS_USAGE_COUNTERS_INTERFACE'

4900: ,ERROR_MSG
4901: ,MSG_TOKENS)
4902: VALUES (G_WORKER_REQ_ID
4903: ,HEADER_INTERFACE_ROWID
4904: ,'OKS_USAGE_COUNTERS_INTERFACE'
4905: ,USAGE_COUNTER_INTERFACE_ID
4906: ,'OKS_IMP_UCTR_INVALID_STSCODE'
4907: ,NULL)
4908: WHEN (DATE_USGCNT_STS_VALID ='N') THEN

Line 4918: ,'OKS_USAGE_COUNTERS_INTERFACE'

4914: ,ERROR_MSG
4915: ,MSG_TOKENS)
4916: VALUES (G_WORKER_REQ_ID
4917: ,HEADER_INTERFACE_ROWID
4918: ,'OKS_USAGE_COUNTERS_INTERFACE'
4919: ,USAGE_COUNTER_INTERFACE_ID
4920: ,'OKS_IMP_USGCNT_INVALID_STS_DT'
4921: ,NULL)
4922:

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_RNWLCD'
4936: ,NULL)
4937: WHEN (DATE_CANC_VALID ='N' OR DATE_CANC_NULL ='Y') 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_CNCLDT'
4950: ,NULL)
4951: WHEN (CR_VALID ='N' OR CR_NULL ='Y') 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_CNCLRSN'
4964: ,NULL)
4965: WHEN (PRINT_INVOICE IS NULL OR (PRINT_INVOICE IS NOT NULL AND PRINT_INVOICE <> 'Y' AND PRINT_INVOICE <> '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_PRINV'
4978: ,NULL)
4979: WHEN ( SUBTOTAL_VALID = 'N' OR SUBTOTAL <0) THEN

Line 4989: ,'OKS_USAGE_COUNTERS_INTERFACE'

4985: ,ERROR_MSG
4986: ,MSG_TOKENS)
4987: VALUES (G_WORKER_REQ_ID
4988: ,HEADER_INTERFACE_ROWID
4989: ,'OKS_USAGE_COUNTERS_INTERFACE'
4990: ,USAGE_COUNTER_INTERFACE_ID
4991: ,'OKS_IMP_UCTR_INVALID_STOT'
4992: ,NULL)
4993: WHEN (TAX_VALID ='N' OR TAX_AMOUNT < 0 ) THEN

Line 5003: ,'OKS_USAGE_COUNTERS_INTERFACE'

4999: ,ERROR_MSG
5000: ,MSG_TOKENS)
5001: VALUES (G_WORKER_REQ_ID
5002: ,HEADER_INTERFACE_ROWID
5003: ,'OKS_USAGE_COUNTERS_INTERFACE'
5004: ,USAGE_COUNTER_INTERFACE_ID
5005: ,'OKS_IMP_UCTR_INVALID_TAXINV'
5006: ,NULL)
5007: WHEN (FIXED_USG_CNT_VALID = 'N' OR FIXED_USG_CNT_VALID IS NULL OR FIXED_USG_CNT <0 ) THEN

Line 5017: ,'OKS_USAGE_COUNTERS_INTERFACE'

5013: ,ERROR_MSG
5014: ,MSG_TOKENS)
5015: VALUES (G_WORKER_REQ_ID
5016: ,HEADER_INTERFACE_ROWID
5017: ,'OKS_USAGE_COUNTERS_INTERFACE'
5018: ,USAGE_COUNTER_INTERFACE_ID
5019: ,'OKS_IMP_UCTR_INVALID_FIXEDUSG'
5020: ,NULL)
5021: WHEN ( MINIMUM_USG_CNT_VALID ='N' OR MINIMUM_USG_CNT_VALID IS NULL OR MINIMUM_USG_CNT <0 ) THEN

Line 5031: ,'OKS_USAGE_COUNTERS_INTERFACE'

5027: ,ERROR_MSG
5028: ,MSG_TOKENS)
5029: VALUES (G_WORKER_REQ_ID
5030: ,HEADER_INTERFACE_ROWID
5031: ,'OKS_USAGE_COUNTERS_INTERFACE'
5032: ,USAGE_COUNTER_INTERFACE_ID
5033: ,'OKS_IMP_UCTR_INVALID_MINUSG'
5034: ,NULL)
5035: WHEN ( DEFAULT_USG_CNT_VALID='N' OR DEFAULT_USG_CNT_VALID IS NULL OR DEFAULT_USG_CNT < 0 ) THEN

Line 5045: ,'OKS_USAGE_COUNTERS_INTERFACE'

5041: ,ERROR_MSG
5042: ,MSG_TOKENS)
5043: VALUES (G_WORKER_REQ_ID
5044: ,HEADER_INTERFACE_ROWID
5045: ,'OKS_USAGE_COUNTERS_INTERFACE'
5046: ,USAGE_COUNTER_INTERFACE_ID
5047: ,'OKS_IMP_UCTR_INVALID_DEFUSG'
5048: ,NULL)
5049: WHEN (FILL_YN_VALID = 'N' OR ( Nvl(FILL_YN,'Y') <> 'Y' AND Nvl(FILL_YN,'N') <> 'N')) THEN --skuchima bug 12664469

Line 5059: ,'OKS_USAGE_COUNTERS_INTERFACE'

5055: ,ERROR_MSG
5056: ,MSG_TOKENS)
5057: VALUES (G_WORKER_REQ_ID
5058: ,HEADER_INTERFACE_ROWID
5059: ,'OKS_USAGE_COUNTERS_INTERFACE'
5060: ,USAGE_COUNTER_INTERFACE_ID
5061: ,'OKS_IMP_UCTR_INVALID_FILLYN'
5062: ,NULL)
5063: WHEN (ESTIMATION_METHOD_VALID='N' OR ESTMTHD_LKUP_VALID='N') THEN

Line 5073: ,'OKS_USAGE_COUNTERS_INTERFACE'

5069: ,ERROR_MSG
5070: ,MSG_TOKENS)
5071: VALUES (G_WORKER_REQ_ID
5072: ,HEADER_INTERFACE_ROWID
5073: ,'OKS_USAGE_COUNTERS_INTERFACE'
5074: ,USAGE_COUNTER_INTERFACE_ID
5075: ,'OKS_IMP_UCTR_INVALID_ESTMTHD'
5076: ,NULL)
5077: WHEN (EST_STRDT_VALID='N') THEN

Line 5087: ,'OKS_USAGE_COUNTERS_INTERFACE'

5083: ,ERROR_MSG
5084: ,MSG_TOKENS)
5085: VALUES (G_WORKER_REQ_ID
5086: ,HEADER_INTERFACE_ROWID
5087: ,'OKS_USAGE_COUNTERS_INTERFACE'
5088: ,USAGE_COUNTER_INTERFACE_ID
5089: ,'OKS_IMP_UCTR_INVALID_ESTSRTDT'
5090: ,NULL)
5091: WHEN (LEVEL_YN_VALID ='N' OR (LEVEL_YN is not NULL and LEVEL_YN <>'Y' AND LEVEL_YN <>'N')) THEN

Line 5101: ,'OKS_USAGE_COUNTERS_INTERFACE'

5097: ,ERROR_MSG
5098: ,MSG_TOKENS)
5099: VALUES (G_WORKER_REQ_ID
5100: ,HEADER_INTERFACE_ROWID
5101: ,'OKS_USAGE_COUNTERS_INTERFACE'
5102: ,USAGE_COUNTER_INTERFACE_ID
5103: ,'OKS_IMP_UCTR_INVALID_LVLYN'
5104: ,NULL)
5105:

Line 5241: FROM OKS_USAGE_COUNTERS_INTERFACE OUSGCNTR

5237: WHEN CSI_CNTR.USAGE_ITEM_ID <> OLSTG.ITEM_ID THEN 'N'
5238: ELSE 'Y'
5239: END ) CNTR_VALID_YN
5240:
5241: FROM OKS_USAGE_COUNTERS_INTERFACE OUSGCNTR
5242: ,OKS_USAGE_COUNTERS_INTERFACE OUSGLIN
5243: ,OKS_INT_LINE_STG_TEMP OLSTG
5244: ,FND_LOOKUPS ESTMTHD
5245: ,OKC_STATUSES_B STS

Line 5242: ,OKS_USAGE_COUNTERS_INTERFACE OUSGLIN

5238: ELSE 'Y'
5239: END ) CNTR_VALID_YN
5240:
5241: FROM OKS_USAGE_COUNTERS_INTERFACE OUSGCNTR
5242: ,OKS_USAGE_COUNTERS_INTERFACE OUSGLIN
5243: ,OKS_INT_LINE_STG_TEMP OLSTG
5244: ,FND_LOOKUPS ESTMTHD
5245: ,OKC_STATUSES_B STS
5246: ,FND_LOOKUPS CR1