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 440: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');

436: AND a.SOURCE_SYSTEM_NAME = nvl(p_source_system_name, a.SOURCE_SYSTEM_NAME); --Added this condition for #6443959
437:
438:
439: BEGIN
440: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
441: l_error_message := fnd_message.get;
442:
443: UPDATE CSI_INSTANCE_INTERFACE cii
444: SET error_text =l_error_message , process_status ='E'

Line 441: l_error_message := fnd_message.get;

437:
438:
439: BEGIN
440: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
441: l_error_message := fnd_message.get;
442:
443: UPDATE CSI_INSTANCE_INTERFACE cii
444: SET error_text =l_error_message , process_status ='E'
445: WHERE (NVL(cii.batch_name,'$CSI_NULL_VALUE$')=NVL(p_batch_name,cii.batch_name)

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

476: END IF;
477:
478: /*---- This piece of code required resolved ids or IDS for processing ---*/
479: BEGIN
480: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
481: l_error_message := fnd_message.get;
482:
483: UPDATE CSI_INSTANCE_INTERFACE cii
484: SET error_text =l_error_message

Line 481: l_error_message := fnd_message.get;

477:
478: /*---- This piece of code required resolved ids or IDS for processing ---*/
479: BEGIN
480: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
481: l_error_message := fnd_message.get;
482:
483: UPDATE CSI_INSTANCE_INTERFACE cii
484: SET error_text =l_error_message
485: ,process_status ='E'

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

503: END IF;
504: END IF;
505:
506:
507: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
508: l_error_message := fnd_message.get;
509:
510: UPDATE CSI_INSTANCE_INTERFACE cii
511: SET error_text =l_error_message

Line 508: l_error_message := fnd_message.get;

504: END IF;
505:
506:
507: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
508: l_error_message := fnd_message.get;
509:
510: UPDATE CSI_INSTANCE_INTERFACE cii
511: SET error_text =l_error_message
512: ,process_status ='E'

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

527: END IF;
528:
529:
530:
531: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
532: l_error_message := fnd_message.get;
533:
534: UPDATE CSI_INSTANCE_INTERFACE cii
535: SET error_text =l_error_message

Line 532: l_error_message := fnd_message.get;

528:
529:
530:
531: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
532: l_error_message := fnd_message.get;
533:
534: UPDATE CSI_INSTANCE_INTERFACE cii
535: SET error_text =l_error_message
536: ,process_status ='E'

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

3337: WHEN g_exc_error THEN
3338: x_return_status := l_return_status;
3339: x_error_message := l_error_message;
3340: WHEN others THEN
3341: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
3342: fnd_message.set_token('API_NAME',l_api_name);
3343: fnd_message.set_token('SQL_ERROR',SQLERRM);
3344: x_error_message := fnd_message.get;
3345: x_return_status := l_fnd_unexpected;

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

3338: x_return_status := l_return_status;
3339: x_error_message := l_error_message;
3340: WHEN others THEN
3341: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
3342: fnd_message.set_token('API_NAME',l_api_name);
3343: fnd_message.set_token('SQL_ERROR',SQLERRM);
3344: x_error_message := fnd_message.get;
3345: x_return_status := l_fnd_unexpected;
3346:

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

3339: x_error_message := l_error_message;
3340: WHEN others THEN
3341: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
3342: fnd_message.set_token('API_NAME',l_api_name);
3343: fnd_message.set_token('SQL_ERROR',SQLERRM);
3344: x_error_message := fnd_message.get;
3345: x_return_status := l_fnd_unexpected;
3346:
3347: END process_iface_txns;

Line 3344: x_error_message := fnd_message.get;

3340: WHEN others THEN
3341: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
3342: fnd_message.set_token('API_NAME',l_api_name);
3343: fnd_message.set_token('SQL_ERROR',SQLERRM);
3344: x_error_message := fnd_message.get;
3345: x_return_status := l_fnd_unexpected;
3346:
3347: END process_iface_txns;
3348: