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.CSI_ASSET_VLD_PVT dependencies on FND_API

Line 16: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN

12: p_param_name IN VARCHAR2,
13: p_api_name IN VARCHAR2
14: ) IS
15: BEGIN
16: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
17: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
18: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
19: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
20: FND_MSG_PUB.Add;

Line 21: RAISE FND_API.G_EXC_ERROR;

17: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
18: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
19: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
20: FND_MSG_PUB.Add;
21: RAISE FND_API.G_EXC_ERROR;
22: END IF;
23: END Check_Reqd_Param;
24:
25: /*-----------------------------------------------------------*/

Line 37: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN

33: p_param_name IN VARCHAR2,
34: p_api_name IN VARCHAR2
35: ) IS
36: BEGIN
37: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
38: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
39: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
40: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
41: FND_MSG_PUB.Add;

Line 42: RAISE FND_API.G_EXC_ERROR;

38: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
39: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
40: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
41: FND_MSG_PUB.Add;
42: RAISE FND_API.G_EXC_ERROR;
43: END IF;
44: END Check_Reqd_Param;
45:
46: /*-----------------------------------------------------------*/

Line 58: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN

54: p_param_name IN VARCHAR2,
55: p_api_name IN VARCHAR2
56: ) IS
57: BEGIN
58: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
59: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
60: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
61: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
62: FND_MSG_PUB.Add;

Line 63: RAISE FND_API.G_EXC_ERROR;

59: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
60: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
61: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
62: FND_MSG_PUB.Add;
63: RAISE FND_API.G_EXC_ERROR;
64: END IF;
65: END Check_Reqd_Param;
66:
67: /*-----------------------------------------------------------*/

Line 92: IF p_check_for_instance_expiry = fnd_api.g_true THEN

88: SELECT 'x'
89: FROM csi_item_instances
90: WHERE instance_id = p_instance_id;
91: BEGIN
92: IF p_check_for_instance_expiry = fnd_api.g_true THEN
93: OPEN c1;
94: FETCH c1 INTO l_dummy;
95: IF c1%NOTFOUND THEN
96: l_return_value := FALSE;

Line 381: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

377: FROM csi_item_instances
378: WHERE instance_id = p_instance_id
379: AND ((active_end_date IS NULL) OR (active_end_date >= SYSDATE));
380: BEGIN
381: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
382: IF p_start_date > p_end_date THEN
383: l_return_value := FALSE;
384: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');
385: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);

Line 393: IF p_check_for_instance_expiry = fnd_api.g_true -- Added for cse on 14-feb-03

389: END IF;
390:
391: OPEN c1;
392: FETCH c1 INTO l_instance_start_date,l_instance_end_date;
393: IF p_check_for_instance_expiry = fnd_api.g_true -- Added for cse on 14-feb-03
394: THEN
395: IF c1%NOTFOUND THEN
396: l_return_value := FALSE;
397: IF ( p_stack_err_msg = TRUE ) THEN

Line 417: IF p_check_for_instance_expiry = fnd_api.g_true -- Added for cse on 14-feb-03

413: END IF;
414: END IF;
415:
416: IF ((l_instance_end_date IS NOT NULL) AND (p_start_date > l_instance_end_date)) THEN
417: IF p_check_for_instance_expiry = fnd_api.g_true -- Added for cse on 14-feb-03
418: THEN
419: l_return_value := FALSE;
420: IF ( p_stack_err_msg = TRUE ) THEN
421: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');

Line 461: IF ((p_inst_asset_id IS NULL) OR (p_inst_asset_id = FND_API.G_MISS_NUM)) THEN

457: l_date_rec c1%ROWTYPE;
458:
459: BEGIN
460:
461: IF ((p_inst_asset_id IS NULL) OR (p_inst_asset_id = FND_API.G_MISS_NUM)) THEN
462: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) THEN
463:
464: IF p_end_date < SYSDATE THEN
465: l_return_value := FALSE;

Line 462: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) THEN

458:
459: BEGIN
460:
461: IF ((p_inst_asset_id IS NULL) OR (p_inst_asset_id = FND_API.G_MISS_NUM)) THEN
462: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) THEN
463:
464: IF p_end_date < SYSDATE THEN
465: l_return_value := FALSE;
466: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');

Line 493: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) then

489: l_return_value := FALSE;
490: RETURN l_return_value;
491: END IF;
492: END IF;
493: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE)) then
494: OPEN c1;
495: FETCH c1 INTO l_date_rec;
496:
497: IF (p_end_date > NVL(l_date_rec.active_end_date, p_end_date))

Line 499: IF p_check_for_instance_expiry = fnd_api.g_true -- Added for cse on 14-feb-03

495: FETCH c1 INTO l_date_rec;
496:
497: IF (p_end_date > NVL(l_date_rec.active_end_date, p_end_date))
498: THEN
499: IF p_check_for_instance_expiry = fnd_api.g_true -- Added for cse on 14-feb-03
500: THEN
501: l_return_value := FALSE;
502: IF ( p_stack_err_msg = TRUE ) THEN
503: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');