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;
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:
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;
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:
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'
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)
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
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'
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
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'
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
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'
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;
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:
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;
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: