125: null;
126: END;
127:
128: BEGIN
129: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
130: l_error_message := fnd_message.get;
131:
132: UPDATE CSI_INSTANCE_INTERFACE cii
133: SET error_text =l_error_message
126: END;
127:
128: BEGIN
129: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
130: l_error_message := fnd_message.get;
131:
132: UPDATE CSI_INSTANCE_INTERFACE cii
133: SET error_text =l_error_message
134: ,process_status ='E'
142: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
143: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
144: END IF;
145:
146: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
147: l_error_message := fnd_message.get;
148:
149: UPDATE CSI_INSTANCE_INTERFACE cii
150: SET error_text =l_error_message
143: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
144: END IF;
145:
146: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
147: l_error_message := fnd_message.get;
148:
149: UPDATE CSI_INSTANCE_INTERFACE cii
150: SET error_text =l_error_message
151: ,process_status ='E'
166: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
167: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
168: END IF;
169:
170: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
171: l_error_message := fnd_message.get;
172:
173: UPDATE CSI_INSTANCE_INTERFACE cii
174: SET error_text =l_error_message
167: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
168: END IF;
169:
170: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
171: l_error_message := fnd_message.get;
172:
173: UPDATE CSI_INSTANCE_INTERFACE cii
174: SET error_text =l_error_message
175: ,process_status ='E'
191:
192: /* Commented for bug 9924463
193: /* it is not mandatory to have an asset association for an internally owned instance.
194: /* IB UI allows us to create an internally owned instance without an asset association.
195: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
196: l_error_message := fnd_message.get;
197:
198: UPDATE CSI_INSTANCE_INTERFACE cii
199: SET error_text =l_error_message
192: /* Commented for bug 9924463
193: /* it is not mandatory to have an asset association for an internally owned instance.
194: /* IB UI allows us to create an internally owned instance without an asset association.
195: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
196: l_error_message := fnd_message.get;
197:
198: UPDATE CSI_INSTANCE_INTERFACE cii
199: SET error_text =l_error_message
200: ,process_status ='E'
2492: END IF;
2493:
2494: EXCEPTION
2495: WHEN NO_DATA_FOUND THEN
2496: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2497: fnd_message.set_token('API_NAME',l_api_name);
2498: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2499: fnd_message.set_token('TO_DATE',l_txn_to_date);
2500: x_error_message := fnd_message.get;
2493:
2494: EXCEPTION
2495: WHEN NO_DATA_FOUND THEN
2496: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2497: fnd_message.set_token('API_NAME',l_api_name);
2498: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2499: fnd_message.set_token('TO_DATE',l_txn_to_date);
2500: x_error_message := fnd_message.get;
2501: x_return_status := l_fnd_error;
2494: EXCEPTION
2495: WHEN NO_DATA_FOUND THEN
2496: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2497: fnd_message.set_token('API_NAME',l_api_name);
2498: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2499: fnd_message.set_token('TO_DATE',l_txn_to_date);
2500: x_error_message := fnd_message.get;
2501: x_return_status := l_fnd_error;
2502:
2495: WHEN NO_DATA_FOUND THEN
2496: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2497: fnd_message.set_token('API_NAME',l_api_name);
2498: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2499: fnd_message.set_token('TO_DATE',l_txn_to_date);
2500: x_error_message := fnd_message.get;
2501: x_return_status := l_fnd_error;
2502:
2503: WHEN others THEN
2496: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2497: fnd_message.set_token('API_NAME',l_api_name);
2498: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2499: fnd_message.set_token('TO_DATE',l_txn_to_date);
2500: x_error_message := fnd_message.get;
2501: x_return_status := l_fnd_error;
2502:
2503: WHEN others THEN
2504: l_sql_error := SQLERRM;
2501: x_return_status := l_fnd_error;
2502:
2503: WHEN others THEN
2504: l_sql_error := SQLERRM;
2505: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2506: fnd_message.set_token('API_NAME',l_api_name);
2507: fnd_message.set_token('SQL_ERROR',SQLERRM);
2508: x_error_message := fnd_message.get;
2509: x_return_status := l_fnd_unexpected;
2502:
2503: WHEN others THEN
2504: l_sql_error := SQLERRM;
2505: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2506: fnd_message.set_token('API_NAME',l_api_name);
2507: fnd_message.set_token('SQL_ERROR',SQLERRM);
2508: x_error_message := fnd_message.get;
2509: x_return_status := l_fnd_unexpected;
2510:
2503: WHEN others THEN
2504: l_sql_error := SQLERRM;
2505: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2506: fnd_message.set_token('API_NAME',l_api_name);
2507: fnd_message.set_token('SQL_ERROR',SQLERRM);
2508: x_error_message := fnd_message.get;
2509: x_return_status := l_fnd_unexpected;
2510:
2511: END get_iface_create_recs;
2504: l_sql_error := SQLERRM;
2505: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2506: fnd_message.set_token('API_NAME',l_api_name);
2507: fnd_message.set_token('SQL_ERROR',SQLERRM);
2508: x_error_message := fnd_message.get;
2509: x_return_status := l_fnd_unexpected;
2510:
2511: END get_iface_create_recs;
2512:
2675: END IF;
2676:
2677: EXCEPTION
2678: WHEN NO_DATA_FOUND THEN
2679: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2680: fnd_message.set_token('API_NAME',l_api_name);
2681: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2682: fnd_message.set_token('TO_DATE',l_txn_to_date);
2683: x_error_message := fnd_message.get;
2676:
2677: EXCEPTION
2678: WHEN NO_DATA_FOUND THEN
2679: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2680: fnd_message.set_token('API_NAME',l_api_name);
2681: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2682: fnd_message.set_token('TO_DATE',l_txn_to_date);
2683: x_error_message := fnd_message.get;
2684: x_return_status := l_fnd_error;
2677: EXCEPTION
2678: WHEN NO_DATA_FOUND THEN
2679: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2680: fnd_message.set_token('API_NAME',l_api_name);
2681: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2682: fnd_message.set_token('TO_DATE',l_txn_to_date);
2683: x_error_message := fnd_message.get;
2684: x_return_status := l_fnd_error;
2685:
2678: WHEN NO_DATA_FOUND THEN
2679: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2680: fnd_message.set_token('API_NAME',l_api_name);
2681: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2682: fnd_message.set_token('TO_DATE',l_txn_to_date);
2683: x_error_message := fnd_message.get;
2684: x_return_status := l_fnd_error;
2685:
2686: WHEN others THEN
2679: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2680: fnd_message.set_token('API_NAME',l_api_name);
2681: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2682: fnd_message.set_token('TO_DATE',l_txn_to_date);
2683: x_error_message := fnd_message.get;
2684: x_return_status := l_fnd_error;
2685:
2686: WHEN others THEN
2687: l_sql_error := SQLERRM;
2684: x_return_status := l_fnd_error;
2685:
2686: WHEN others THEN
2687: l_sql_error := SQLERRM;
2688: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2689: fnd_message.set_token('API_NAME',l_api_name);
2690: fnd_message.set_token('SQL_ERROR',SQLERRM);
2691: x_error_message := fnd_message.get;
2692: x_return_status := l_fnd_unexpected;
2685:
2686: WHEN others THEN
2687: l_sql_error := SQLERRM;
2688: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2689: fnd_message.set_token('API_NAME',l_api_name);
2690: fnd_message.set_token('SQL_ERROR',SQLERRM);
2691: x_error_message := fnd_message.get;
2692: x_return_status := l_fnd_unexpected;
2693:
2686: WHEN others THEN
2687: l_sql_error := SQLERRM;
2688: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2689: fnd_message.set_token('API_NAME',l_api_name);
2690: fnd_message.set_token('SQL_ERROR',SQLERRM);
2691: x_error_message := fnd_message.get;
2692: x_return_status := l_fnd_unexpected;
2693:
2694: END get_iface_rel_recs;
2687: l_sql_error := SQLERRM;
2688: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2689: fnd_message.set_token('API_NAME',l_api_name);
2690: fnd_message.set_token('SQL_ERROR',SQLERRM);
2691: x_error_message := fnd_message.get;
2692: x_return_status := l_fnd_unexpected;
2693:
2694: END get_iface_rel_recs;
2695: