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_TIME_MEASURES_PUB dependencies on OKC_API

Line 125: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

121: EXCEPTION
122: WHEN
123: INVALID_UOM_EXCEPTION
124: THEN
125: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
126: p_msg_name => 'OKS_INVD_UOM_CODE',
127: p_token1 => 'OKS_API_NAME',
128: p_token1_value => 'OKS_TIME_MEASURES_PUB.get_uom_code',
129: p_token2 => 'UOM_CODE',

Line 352: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

348: EXCEPTION
349: WHEN
350: INVALID_UOM_EXCEPTION
351: THEN
352: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
353: p_msg_name => 'OKS_INVD_UOM_CODE',
354: p_token1 => 'OKS_API_NAME',
355: p_token1_value => 'OKS_TIME_MEASURES_PUB.get_target_qty',
356: p_token2 => 'UOM_CODE',

Line 380: x_return_status := OKC_API.G_RET_STS_SUCCESS;

376: l_duration_wk number := 0;
377: l_duration_mth number := 0;
378:
379: BEGIN
380: x_return_status := OKC_API.G_RET_STS_SUCCESS;
381: if p_end_date is NULL Then
382: x_duration := NULL;
383: x_timeunit := NULL;
384: return;

Line 387: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

383: x_timeunit := NULL;
384: return;
385: end if;
386: if p_start_date > p_end_date then
387: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
388: p_msg_name => G_DATE_ERROR,
389: p_token1 => G_COL_NAME_TOKEN,
390: p_token1_value => 'START_DATE');
391: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 391: x_return_status := OKC_API.G_RET_STS_ERROR;

387: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
388: p_msg_name => G_DATE_ERROR,
389: p_token1 => G_COL_NAME_TOKEN,
390: p_token1_value => 'START_DATE');
391: x_return_status := OKC_API.G_RET_STS_ERROR;
392: return;
393: end if;
394:
395: okc_time_util_pub.get_duration(p_start_date,p_end_date,l_duration,l_timeunit,x_return_status);

Line 396: if x_return_status <> OKC_API.G_RET_STS_SUCCESS then

392: return;
393: end if;
394:
395: okc_time_util_pub.get_duration(p_start_date,p_end_date,l_duration,l_timeunit,x_return_status);
396: if x_return_status <> OKC_API.G_RET_STS_SUCCESS then
397: l_duration := NULL;
398: l_timeunit := NULL;
399: end if;
400:

Line 497: OKC_API.set_message('OKS','OKS_START_DATE_REQD');

493: EXCEPTION
494: WHEN
495: NO_STRDT_EXCEPTION
496: THEN
497: OKC_API.set_message('OKS','OKS_START_DATE_REQD');
498: return 0;
499: END;
500:
501: ------------------------------------------------------------------------

Line 624: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

620: EXCEPTION
621: WHEN
622: INVALID_UOM_EXCEPTION
623: THEN
624: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
625: p_msg_name => 'OKS_INVD_UOM_CODE',
626: p_token1 => 'OKS_API_NAME',
627: p_token1_value => 'OKS_TIME_MEASURES_PUB.get_quantity',
628: p_token2 => 'UOM_CODE',

Line 633: OKC_API.set_message(G_APP_NAME,

629: p_token2_value => p_source_uom );
630: close cs_validate_uom;
631: return 0;
632: WHEN OTHERS THEN
633: OKC_API.set_message(G_APP_NAME,
634: G_UNEXPECTED_ERROR,
635: G_SQLCODE_TOKEN,
636: SQLCODE,
637: G_SQLERRM_TOKEN,

Line 735: IF l_status = OKC_API.G_RET_STS_ERROR

731: x_full_periods => l_full_periods,
732: x_full_period_end_date => l_full_period_end_date,
733: x_return_status => l_status);
734:
735: IF l_status = OKC_API.G_RET_STS_ERROR
736: THEN
737: return 0;
738: END IF;
739:

Line 770: OKC_API.set_message(

766: EXCEPTION
767: WHEN
768: INVALID_PERIOD_TYPE_EXCEPTION
769: THEN
770: OKC_API.set_message(
771: p_app_name => G_APP_NAME,
772: p_msg_name => G_INVALID_VALUE,
773: p_token1 => G_COL_NAME_TOKEN,
774: p_token1_value => 'Period type');

Line 779: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

775: return 0;
776: WHEN
777: INVALID_UOM_EXCEPTION
778: THEN
779: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
780: p_msg_name => 'OKS_INVD_UOM_CODE',
781: p_token1 => 'OKS_API_NAME',
782: p_token1_value => 'OKS_TIME_MEASURES_PUB.get_target_qty_cal',
783: p_token2 => 'UOM_CODE',

Line 791: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');

787: return 0;
788: WHEN
789: INVALID_DATE_EXCEPTION
790: THEN
791: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
792: return 0;
793: WHEN OTHERS THEN
794: OKC_API.set_message(G_APP_NAME,
795: G_UNEXPECTED_ERROR,

Line 794: OKC_API.set_message(G_APP_NAME,

790: THEN
791: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
792: return 0;
793: WHEN OTHERS THEN
794: OKC_API.set_message(G_APP_NAME,
795: G_UNEXPECTED_ERROR,
796: G_SQLCODE_TOKEN,
797: SQLCODE,
798: G_SQLERRM_TOKEN,

Line 873: IF l_status = OKC_API.G_RET_STS_ERROR

869: x_full_periods => l_full_periods,
870: x_full_period_end_date => l_full_period_end_date,
871: x_return_status => l_status);
872:
873: IF l_status = OKC_API.G_RET_STS_ERROR
874: THEN
875: return 0;
876: END IF;
877:

Line 907: OKC_API.set_message(

903: EXCEPTION
904: WHEN
905: INVALID_PERIOD_TYPE_EXCEPTION
906: THEN
907: OKC_API.set_message(
908: p_app_name => G_APP_NAME,
909: p_msg_name => G_INVALID_VALUE,
910: p_token1 => G_COL_NAME_TOKEN,
911: p_token1_value => 'Period type');

Line 917: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

913: return 0;
914: WHEN
915: INVALID_UOM_EXCEPTION
916: THEN
917: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
918: p_msg_name => 'OKS_INVD_UOM_CODE',
919: p_token1 => 'OKS_API_NAME',
920: p_token1_value => 'OKS_TIME_MEASURES_PUB.get_target_qty_service',
921: p_token2 => 'UOM_CODE',

Line 928: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');

924: return 0;
925: WHEN
926: INVALID_DATE_EXCEPTION
927: THEN
928: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
929: return 0;
930: WHEN OTHERS THEN
931: OKC_API.set_message(G_APP_NAME,
932: G_UNEXPECTED_ERROR,

Line 931: OKC_API.set_message(G_APP_NAME,

927: THEN
928: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
929: return 0;
930: WHEN OTHERS THEN
931: OKC_API.set_message(G_APP_NAME,
932: G_UNEXPECTED_ERROR,
933: G_SQLCODE_TOKEN,
934: SQLCODE,
935: G_SQLERRM_TOKEN,

Line 1055: OKC_API.set_message(

1051: EXCEPTION
1052: WHEN
1053: INVALID_PERIOD_TYPE_EXCEPTION
1054: THEN
1055: OKC_API.set_message(
1056: p_app_name => G_APP_NAME,
1057: p_msg_name => G_INVALID_VALUE,
1058: p_token1 => G_COL_NAME_TOKEN,
1059: p_token1_value => 'Period Type');

Line 1064: OKC_API.set_message(

1060: return -1;
1061: WHEN
1062: INVALID_PERIOD_START_EXCEPTION
1063: THEN
1064: OKC_API.set_message(
1065: p_app_name => G_APP_NAME,
1066: p_msg_name => G_INVALID_VALUE,
1067: p_token1 => G_COL_NAME_TOKEN,
1068: p_token1_value => 'Period Start');

Line 1073: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

1069: return -1;
1070: WHEN
1071: INVALID_UOM_EXCEPTION
1072: THEN
1073: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
1074: p_msg_name => 'OKS_INVD_UOM_CODE',
1075: p_token1 => 'OKS_API_NAME',
1076: p_token1_value => 'OKS_TIME_MEASURES_PUB.get_partial_period_duration',
1077: p_token2 => 'UOM_CODE',

Line 1084: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');

1080: return -1;
1081: WHEN
1082: INVALID_DATE_EXCEPTION
1083: THEN
1084: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
1085: return -1;
1086: WHEN OTHERS THEN
1087: OKC_API.set_message(G_APP_NAME,
1088: G_UNEXPECTED_ERROR,

Line 1087: OKC_API.set_message(G_APP_NAME,

1083: THEN
1084: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
1085: return -1;
1086: WHEN OTHERS THEN
1087: OKC_API.set_message(G_APP_NAME,
1088: G_UNEXPECTED_ERROR,
1089: G_SQLCODE_TOKEN,
1090: SQLCODE,
1091: G_SQLERRM_TOKEN,

Line 1138: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1134: invalid_date_exception EXCEPTION;
1135: invalid_uom_exception EXCEPTION;
1136: invalid_mapping_exception EXCEPTION;
1137: BEGIN
1138: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1139: open cs_validate_uom(p_price_uom);
1140: fetch cs_validate_uom into cr_validate_uom;
1141: IF cs_validate_uom%NOTFOUND
1142: THEN

Line 1259: OKC_API.SET_MESSAGE(p_app_name => 'OKS',

1255: EXCEPTION
1256: WHEN
1257: INVALID_UOM_EXCEPTION
1258: THEN
1259: OKC_API.SET_MESSAGE(p_app_name => 'OKS',
1260: p_msg_name => 'OKS_INVD_UOM_CODE',
1261: p_token1 => 'OKS_API_NAME',
1262: p_token1_value => 'OKS_TIME_MEASURES_PUB.get_full_periods',
1263: p_token2 => 'UOM_CODE',

Line 1266: x_return_status := OKC_API.G_RET_STS_ERROR;

1262: p_token1_value => 'OKS_TIME_MEASURES_PUB.get_full_periods',
1263: p_token2 => 'UOM_CODE',
1264: p_token2_value => p_price_uom );
1265: close cs_validate_uom;
1266: x_return_status := OKC_API.G_RET_STS_ERROR;
1267: x_full_periods := NULL;
1268: x_full_period_end_date := NULL;
1269: WHEN
1270: INVALID_DATE_EXCEPTION

Line 1272: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');

1268: x_full_period_end_date := NULL;
1269: WHEN
1270: INVALID_DATE_EXCEPTION
1271: THEN
1272: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
1273: x_return_status := OKC_API.G_RET_STS_ERROR;
1274: x_full_periods := NULL;
1275: x_full_period_end_date := NULL;
1276: WHEN

Line 1273: x_return_status := OKC_API.G_RET_STS_ERROR;

1269: WHEN
1270: INVALID_DATE_EXCEPTION
1271: THEN
1272: OKC_API.set_message('OKC','OKC_REP_INV_EFF_DATE_SD');
1273: x_return_status := OKC_API.G_RET_STS_ERROR;
1274: x_full_periods := NULL;
1275: x_full_period_end_date := NULL;
1276: WHEN
1277: INVALID_MAPPING_EXCEPTION

Line 1279: OKC_API.set_message(

1275: x_full_period_end_date := NULL;
1276: WHEN
1277: INVALID_MAPPING_EXCEPTION
1278: THEN
1279: OKC_API.set_message(
1280: p_app_name => G_APP_NAME,
1281: p_msg_name => 'OKS_INVALID_TIME_MAPPING',
1282: p_token1 => 'TOKEN1',
1283: p_token1_value => p_price_uom);

Line 1284: x_return_status := OKC_API.G_RET_STS_ERROR;

1280: p_app_name => G_APP_NAME,
1281: p_msg_name => 'OKS_INVALID_TIME_MAPPING',
1282: p_token1 => 'TOKEN1',
1283: p_token1_value => p_price_uom);
1284: x_return_status := OKC_API.G_RET_STS_ERROR;
1285: x_full_periods := NULL;
1286: x_full_period_end_date := NULL;
1287: WHEN OTHERS THEN
1288: OKC_API.set_message(G_APP_NAME,

Line 1288: OKC_API.set_message(G_APP_NAME,

1284: x_return_status := OKC_API.G_RET_STS_ERROR;
1285: x_full_periods := NULL;
1286: x_full_period_end_date := NULL;
1287: WHEN OTHERS THEN
1288: OKC_API.set_message(G_APP_NAME,
1289: G_UNEXPECTED_ERROR,
1290: G_SQLCODE_TOKEN,
1291: SQLCODE,
1292: G_SQLERRM_TOKEN,

Line 1294: x_return_status := OKC_API.G_RET_STS_ERROR;

1290: G_SQLCODE_TOKEN,
1291: SQLCODE,
1292: G_SQLERRM_TOKEN,
1293: SQLERRM);
1294: x_return_status := OKC_API.G_RET_STS_ERROR;
1295: x_full_periods := NULL;
1296: x_full_period_end_date := NULL;
1297:
1298:

Line 1359: OKC_API.set_message(G_APP_NAME,

1355: END IF;
1356:
1357: EXCEPTION
1358: WHEN OTHERS THEN
1359: OKC_API.set_message(G_APP_NAME,
1360: G_UNEXPECTED_ERROR,
1361: G_SQLCODE_TOKEN,
1362: SQLCODE,
1363: G_SQLERRM_TOKEN,