DBA Data[Home] [Help]

APPS.CSI_ASSET_VLD_PVT dependencies on FND_MESSAGE

Line 17: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');

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;
21: RAISE FND_API.G_EXC_ERROR;

Line 18: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

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;
21: RAISE FND_API.G_EXC_ERROR;
22: END IF;

Line 19: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

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;
21: RAISE FND_API.G_EXC_ERROR;
22: END IF;
23: END Check_Reqd_Param;

Line 38: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');

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;
42: RAISE FND_API.G_EXC_ERROR;

Line 39: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

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;
42: RAISE FND_API.G_EXC_ERROR;
43: END IF;

Line 40: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

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;
42: RAISE FND_API.G_EXC_ERROR;
43: END IF;
44: END Check_Reqd_Param;

Line 59: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');

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;
63: RAISE FND_API.G_EXC_ERROR;

Line 60: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);

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;
63: RAISE FND_API.G_EXC_ERROR;
64: END IF;

Line 61: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);

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;
63: RAISE FND_API.G_EXC_ERROR;
64: END IF;
65: END Check_Reqd_Param;

Line 98: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');

94: FETCH c1 INTO l_dummy;
95: IF c1%NOTFOUND THEN
96: l_return_value := FALSE;
97: IF ( p_stack_err_msg = TRUE ) THEN
98: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
99: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
100: FND_MSG_PUB.Add;
101: END IF;
102: END IF;

Line 99: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);

95: IF c1%NOTFOUND THEN
96: l_return_value := FALSE;
97: IF ( p_stack_err_msg = TRUE ) THEN
98: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
99: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
100: FND_MSG_PUB.Add;
101: END IF;
102: END IF;
103: CLOSE c1;

Line 110: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');

106: FETCH c2 INTO l_dummy;
107: IF c2%NOTFOUND THEN
108: l_return_value := FALSE;
109: IF ( p_stack_err_msg = TRUE ) THEN
110: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
111: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
112: FND_MSG_PUB.Add;
113: END IF;
114: END IF;

Line 111: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);

107: IF c2%NOTFOUND THEN
108: l_return_value := FALSE;
109: IF ( p_stack_err_msg = TRUE ) THEN
110: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');
111: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',p_instance_id);
112: FND_MSG_PUB.Add;
113: END IF;
114: END IF;
115: CLOSE c2;

Line 164: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');

160: FROM csi_i_assets
161: WHERE instance_asset_id = p_instance_asset_id ;
162:
163: IF ( p_stack_err_msg = TRUE ) THEN
164: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');
165: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);
166: FND_MSG_PUB.Add;
167: END IF;
168: RETURN l_return_value;

Line 165: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);

161: WHERE instance_asset_id = p_instance_asset_id ;
162:
163: IF ( p_stack_err_msg = TRUE ) THEN
164: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');
165: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);
166: FND_MSG_PUB.Add;
167: END IF;
168: RETURN l_return_value;
169: EXCEPTION

Line 199: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');

195: EXCEPTION
196: WHEN NO_DATA_FOUND THEN
197: l_return_value := FALSE;
198: IF ( p_stack_err_msg = TRUE ) THEN
199: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');
200: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);
201: FND_MSG_PUB.Add;
202: END IF;
203: RETURN l_return_value;

Line 200: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);

196: WHEN NO_DATA_FOUND THEN
197: l_return_value := FALSE;
198: IF ( p_stack_err_msg = TRUE ) THEN
199: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');
200: FND_MESSAGE.SET_TOKEN('INSTANCE_ASSET_ID',p_instance_asset_id);
201: FND_MSG_PUB.Add;
202: END IF;
203: RETURN l_return_value;
204: END Is_Inst_asset_id_valid;

Line 234: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');

230: FETCH c1 INTO l_dummy;
231: IF c1%NOTFOUND THEN
232: l_return_value := FALSE;
233: IF ( p_stack_err_msg = TRUE ) THEN
234: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
235: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);
236: FND_MSG_PUB.Add;
237: END IF;
238: END IF;

Line 235: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);

231: IF c1%NOTFOUND THEN
232: l_return_value := FALSE;
233: IF ( p_stack_err_msg = TRUE ) THEN
234: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
235: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_update_status);
236: FND_MSG_PUB.Add;
237: END IF;
238: END IF;
239: CLOSE c1;

Line 259: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ASSET_QTY');

255: l_return_status BOOLEAN := TRUE;
256: BEGIN
257: IF (NVL(p_asset_quantity,-1) <= 0 ) THEN
258: l_return_status := FALSE;
259: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ASSET_QTY');
260: FND_MESSAGE.SET_TOKEN('QUANTITY',p_asset_quantity);
261: FND_MSG_PUB.Add;
262: END IF;
263:

Line 260: FND_MESSAGE.SET_TOKEN('QUANTITY',p_asset_quantity);

256: BEGIN
257: IF (NVL(p_asset_quantity,-1) <= 0 ) THEN
258: l_return_status := FALSE;
259: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ASSET_QTY');
260: FND_MESSAGE.SET_TOKEN('QUANTITY',p_asset_quantity);
261: FND_MSG_PUB.Add;
262: END IF;
263:
264: RETURN l_return_status;

Line 314: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');

310: FETCH C1 INTO l_dummy;
311: IF C1%NOTFOUND THEN
312: l_return_value := FALSE;
313: IF ( p_stack_err_msg = TRUE ) THEN
314: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
315: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_asset_id||'-'||p_book_type_code);
316: FND_MSG_PUB.Add;
317: END IF;
318: END IF;

Line 315: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_asset_id||'-'||p_book_type_code);

311: IF C1%NOTFOUND THEN
312: l_return_value := FALSE;
313: IF ( p_stack_err_msg = TRUE ) THEN
314: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
315: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_asset_id||'-'||p_book_type_code);
316: FND_MSG_PUB.Add;
317: END IF;
318: END IF;
319: CLOSE C1;

Line 349: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');

345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN
347: l_return_value := FALSE;
348: IF ( p_stack_err_msg = TRUE ) THEN
349: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
350: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_location_id);
351: FND_MSG_PUB.Add;
352: END IF;
353: RETURN l_return_value;

Line 350: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_location_id);

346: WHEN NO_DATA_FOUND THEN
347: l_return_value := FALSE;
348: IF ( p_stack_err_msg = TRUE ) THEN
349: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
350: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_location_id);
351: FND_MSG_PUB.Add;
352: END IF;
353: RETURN l_return_value;
354: END Is_Asset_Location_Valid;

Line 384: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');

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);
386: FND_MSG_PUB.Add;
387: RETURN l_return_value;
388: END IF;

Line 385: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);

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);
386: FND_MSG_PUB.Add;
387: RETURN l_return_value;
388: END IF;
389: END IF;

Line 398: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');

394: THEN
395: IF c1%NOTFOUND THEN
396: l_return_value := FALSE;
397: IF ( p_stack_err_msg = TRUE ) THEN
398: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
399: FND_MESSAGE.SET_TOKEN('ENTITY','ASSET');
400: FND_MSG_PUB.Add;
401: END IF;
402: RETURN l_return_value;

Line 399: FND_MESSAGE.SET_TOKEN('ENTITY','ASSET');

395: IF c1%NOTFOUND THEN
396: l_return_value := FALSE;
397: IF ( p_stack_err_msg = TRUE ) THEN
398: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_INST_START_DATE');
399: FND_MESSAGE.SET_TOKEN('ENTITY','ASSET');
400: FND_MSG_PUB.Add;
401: END IF;
402: RETURN l_return_value;
403: END IF;

Line 410: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');

406:
407: IF (p_start_date < l_instance_start_date) AND (l_instance_start_date IS NOT NULL) THEN
408: l_return_value := FALSE;
409: IF ( p_stack_err_msg = TRUE ) THEN
410: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');
411: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
412: FND_MSG_PUB.Add;
413: END IF;
414: END IF;

Line 411: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);

407: IF (p_start_date < l_instance_start_date) AND (l_instance_start_date IS NOT NULL) THEN
408: l_return_value := FALSE;
409: IF ( p_stack_err_msg = TRUE ) THEN
410: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');
411: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
412: FND_MSG_PUB.Add;
413: END IF;
414: END IF;
415:

Line 421: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');

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');
422: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
423: FND_MSG_PUB.Add;
424: END IF;
425: END IF;

Line 422: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);

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');
422: FND_MESSAGE.SET_TOKEN('START_DATE',p_start_date);
423: FND_MSG_PUB.Add;
424: END IF;
425: END IF;
426: END IF;

Line 466: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');

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');
467: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
468: FND_MSG_PUB.Add;
469: l_return_value := FALSE;
470: RETURN l_return_value;

Line 467: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);

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');
467: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
468: FND_MSG_PUB.Add;
469: l_return_value := FALSE;
470: RETURN l_return_value;
471: END IF;

Line 486: fnd_message.set_name('CSI','CSI_HAS_TXNS');

482: AND t.transaction_id <> nvl(p_txn_id, -999999);
483:
484: IF l_transaction_date > p_end_date
485: THEN
486: fnd_message.set_name('CSI','CSI_HAS_TXNS');
487: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
488: fnd_msg_pub.add;
489: l_return_value := FALSE;
490: RETURN l_return_value;

Line 487: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);

483:
484: IF l_transaction_date > p_end_date
485: THEN
486: fnd_message.set_name('CSI','CSI_HAS_TXNS');
487: fnd_message.set_token('END_DATE_ACTIVE',p_end_date);
488: fnd_msg_pub.add;
489: l_return_value := FALSE;
490: RETURN l_return_value;
491: END IF;

Line 503: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');

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');
504: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
505: FND_MSG_PUB.Add;
506: END IF;
507: RETURN l_return_value;

Line 504: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);

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');
504: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
505: FND_MSG_PUB.Add;
506: END IF;
507: RETURN l_return_value;
508: END IF;

Line 515: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');

511: IF (p_end_date < NVL(l_date_rec.active_start_date,p_end_date))
512: THEN
513: l_return_value := FALSE;
514: IF ( p_stack_err_msg = TRUE ) THEN
515: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');
516: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
517: FND_MSG_PUB.Add;
518: END IF;
519: RETURN l_return_value;

Line 516: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);

512: THEN
513: l_return_value := FALSE;
514: IF ( p_stack_err_msg = TRUE ) THEN
515: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');
516: FND_MESSAGE.SET_TOKEN('END_DATE',p_end_date);
517: FND_MSG_PUB.Add;
518: END IF;
519: RETURN l_return_value;
520: END IF;