DBA Data[Home] [Help]

APPS.CSI_ML_INTERFACE_TXN_PVT dependencies on FND_MESSAGE

Line 70: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

66: WHEN e_exists THEN
67: x_instance_id := l_instance_id;
68: x_return_status := fnd_api.g_ret_sts_success;
69: WHEN others THEN
70: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
71: fnd_message.set_token('API_NAME','CSI_ML_INTERFACE_TXNS_PVT.INSTANCE_EXISTS');
72: fnd_message.set_token('SQL_ERROR',SQLERRM);
73: x_error_message := fnd_message.get;
74: x_return_status := l_fnd_unexpected;

Line 71: fnd_message.set_token('API_NAME','CSI_ML_INTERFACE_TXNS_PVT.INSTANCE_EXISTS');

67: x_instance_id := l_instance_id;
68: x_return_status := fnd_api.g_ret_sts_success;
69: WHEN others THEN
70: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
71: fnd_message.set_token('API_NAME','CSI_ML_INTERFACE_TXNS_PVT.INSTANCE_EXISTS');
72: fnd_message.set_token('SQL_ERROR',SQLERRM);
73: x_error_message := fnd_message.get;
74: x_return_status := l_fnd_unexpected;
75:

Line 72: fnd_message.set_token('SQL_ERROR',SQLERRM);

68: x_return_status := fnd_api.g_ret_sts_success;
69: WHEN others THEN
70: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
71: fnd_message.set_token('API_NAME','CSI_ML_INTERFACE_TXNS_PVT.INSTANCE_EXISTS');
72: fnd_message.set_token('SQL_ERROR',SQLERRM);
73: x_error_message := fnd_message.get;
74: x_return_status := l_fnd_unexpected;
75:
76: END instance_exists;

Line 73: x_error_message := fnd_message.get;

69: WHEN others THEN
70: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
71: fnd_message.set_token('API_NAME','CSI_ML_INTERFACE_TXNS_PVT.INSTANCE_EXISTS');
72: fnd_message.set_token('SQL_ERROR',SQLERRM);
73: x_error_message := fnd_message.get;
74: x_return_status := l_fnd_unexpected;
75:
76: END instance_exists;
77:

Line 453: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');

449: AND a.SOURCE_SYSTEM_NAME = nvl(p_source_system_name, a.SOURCE_SYSTEM_NAME); --Added this condition for #6443959
450:
451:
452: BEGIN
453: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
454: l_error_message := fnd_message.get;
455:
456: UPDATE CSI_INSTANCE_INTERFACE cii
457: SET error_text =l_error_message , process_status ='E'

Line 454: l_error_message := fnd_message.get;

450:
451:
452: BEGIN
453: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
454: l_error_message := fnd_message.get;
455:
456: UPDATE CSI_INSTANCE_INTERFACE cii
457: SET error_text =l_error_message , process_status ='E'
458: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)

Line 493: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');

489: END IF;
490:
491: /*---- This piece of code required resolved ids or IDS for processing ---*/
492: BEGIN
493: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
494: l_error_message := fnd_message.get;
495:
496: UPDATE CSI_INSTANCE_INTERFACE cii
497: SET error_text =l_error_message

Line 494: l_error_message := fnd_message.get;

490:
491: /*---- This piece of code required resolved ids or IDS for processing ---*/
492: BEGIN
493: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
494: l_error_message := fnd_message.get;
495:
496: UPDATE CSI_INSTANCE_INTERFACE cii
497: SET error_text =l_error_message
498: ,process_status ='E'

Line 520: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');

516: END IF;
517: END IF;
518:
519:
520: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
521: l_error_message := fnd_message.get;
522:
523: UPDATE CSI_INSTANCE_INTERFACE cii
524: SET error_text =l_error_message

Line 521: l_error_message := fnd_message.get;

517: END IF;
518:
519:
520: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
521: l_error_message := fnd_message.get;
522:
523: UPDATE CSI_INSTANCE_INTERFACE cii
524: SET error_text =l_error_message
525: ,process_status ='E'

Line 546: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');

542:
543: /* Commented for bug 9924463
544: /* it is not mandatory to have an asset association for an internally owned instance.
545: /* IB UI allows us to create an internally owned instance without an asset association.
546: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
547: l_error_message := fnd_message.get;
548:
549: UPDATE CSI_INSTANCE_INTERFACE cii
550: SET error_text =l_error_message

Line 547: l_error_message := fnd_message.get;

543: /* Commented for bug 9924463
544: /* it is not mandatory to have an asset association for an internally owned instance.
545: /* IB UI allows us to create an internally owned instance without an asset association.
546: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
547: l_error_message := fnd_message.get;
548:
549: UPDATE CSI_INSTANCE_INTERFACE cii
550: SET error_text =l_error_message
551: ,process_status ='E'

Line 3464: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

3460: WHEN g_exc_error THEN
3461: x_return_status := l_return_status;
3462: x_error_message := l_error_message;
3463: WHEN others THEN
3464: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
3465: fnd_message.set_token('API_NAME',l_api_name);
3466: fnd_message.set_token('SQL_ERROR',SQLERRM);
3467: x_error_message := fnd_message.get;
3468: x_return_status := l_fnd_unexpected;

Line 3465: fnd_message.set_token('API_NAME',l_api_name);

3461: x_return_status := l_return_status;
3462: x_error_message := l_error_message;
3463: WHEN others THEN
3464: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
3465: fnd_message.set_token('API_NAME',l_api_name);
3466: fnd_message.set_token('SQL_ERROR',SQLERRM);
3467: x_error_message := fnd_message.get;
3468: x_return_status := l_fnd_unexpected;
3469:

Line 3466: fnd_message.set_token('SQL_ERROR',SQLERRM);

3462: x_error_message := l_error_message;
3463: WHEN others THEN
3464: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
3465: fnd_message.set_token('API_NAME',l_api_name);
3466: fnd_message.set_token('SQL_ERROR',SQLERRM);
3467: x_error_message := fnd_message.get;
3468: x_return_status := l_fnd_unexpected;
3469:
3470: END process_iface_txns;

Line 3467: x_error_message := fnd_message.get;

3463: WHEN others THEN
3464: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
3465: fnd_message.set_token('API_NAME',l_api_name);
3466: fnd_message.set_token('SQL_ERROR',SQLERRM);
3467: x_error_message := fnd_message.get;
3468: x_return_status := l_fnd_unexpected;
3469:
3470: END process_iface_txns;
3471: