DBA Data[Home] [Help]

APPS.CSI_ML_CREATE_PVT dependencies on FND_MESSAGE

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

117: null;
118: END;
119:
120: BEGIN
121: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
122: l_error_message := fnd_message.get;
123:
124: UPDATE CSI_INSTANCE_INTERFACE cii
125: SET error_text =l_error_message

Line 122: l_error_message := fnd_message.get;

118: END;
119:
120: BEGIN
121: fnd_message.set_name('CSI','CSI_INTERFACE_LOC_TYPE_CODE');
122: l_error_message := fnd_message.get;
123:
124: UPDATE CSI_INSTANCE_INTERFACE cii
125: SET error_text =l_error_message
126: ,process_status ='E'

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

134: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
135: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
136: END IF;
137:
138: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
139: l_error_message := fnd_message.get;
140:
141: UPDATE CSI_INSTANCE_INTERFACE cii
142: SET error_text =l_error_message

Line 139: l_error_message := fnd_message.get;

135: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
136: END IF;
137:
138: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
139: l_error_message := fnd_message.get;
140:
141: UPDATE CSI_INSTANCE_INTERFACE cii
142: SET error_text =l_error_message
143: ,process_status ='E'

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

158: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
159: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
160: END IF;
161:
162: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
163: l_error_message := fnd_message.get;
164:
165: UPDATE CSI_INSTANCE_INTERFACE cii
166: SET error_text =l_error_message

Line 163: l_error_message := fnd_message.get;

159: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
160: END IF;
161:
162: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
163: l_error_message := fnd_message.get;
164:
165: UPDATE CSI_INSTANCE_INTERFACE cii
166: SET error_text =l_error_message
167: ,process_status ='E'

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

181: END IF;
182:
183:
184:
185: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
186: l_error_message := fnd_message.get;
187:
188: UPDATE CSI_INSTANCE_INTERFACE cii
189: SET error_text =l_error_message

Line 186: l_error_message := fnd_message.get;

182:
183:
184:
185: fnd_message.set_name('CSI','CSI_API_ASSET_REQUIRED');
186: l_error_message := fnd_message.get;
187:
188: UPDATE CSI_INSTANCE_INTERFACE cii
189: SET error_text =l_error_message
190: ,process_status ='E'

Line 2478: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');

2474: END IF;
2475:
2476: EXCEPTION
2477: WHEN NO_DATA_FOUND THEN
2478: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2479: fnd_message.set_token('API_NAME',l_api_name);
2480: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2481: fnd_message.set_token('TO_DATE',l_txn_to_date);
2482: x_error_message := fnd_message.get;

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

2475:
2476: EXCEPTION
2477: WHEN NO_DATA_FOUND THEN
2478: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2479: fnd_message.set_token('API_NAME',l_api_name);
2480: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2481: fnd_message.set_token('TO_DATE',l_txn_to_date);
2482: x_error_message := fnd_message.get;
2483: x_return_status := l_fnd_error;

Line 2480: fnd_message.set_token('FROM_DATE',l_txn_from_date);

2476: EXCEPTION
2477: WHEN NO_DATA_FOUND THEN
2478: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2479: fnd_message.set_token('API_NAME',l_api_name);
2480: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2481: fnd_message.set_token('TO_DATE',l_txn_to_date);
2482: x_error_message := fnd_message.get;
2483: x_return_status := l_fnd_error;
2484:

Line 2481: fnd_message.set_token('TO_DATE',l_txn_to_date);

2477: WHEN NO_DATA_FOUND THEN
2478: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2479: fnd_message.set_token('API_NAME',l_api_name);
2480: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2481: fnd_message.set_token('TO_DATE',l_txn_to_date);
2482: x_error_message := fnd_message.get;
2483: x_return_status := l_fnd_error;
2484:
2485: WHEN others THEN

Line 2482: x_error_message := fnd_message.get;

2478: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2479: fnd_message.set_token('API_NAME',l_api_name);
2480: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2481: fnd_message.set_token('TO_DATE',l_txn_to_date);
2482: x_error_message := fnd_message.get;
2483: x_return_status := l_fnd_error;
2484:
2485: WHEN others THEN
2486: l_sql_error := SQLERRM;

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

2483: x_return_status := l_fnd_error;
2484:
2485: WHEN others THEN
2486: l_sql_error := SQLERRM;
2487: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2488: fnd_message.set_token('API_NAME',l_api_name);
2489: fnd_message.set_token('SQL_ERROR',SQLERRM);
2490: x_error_message := fnd_message.get;
2491: x_return_status := l_fnd_unexpected;

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

2484:
2485: WHEN others THEN
2486: l_sql_error := SQLERRM;
2487: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2488: fnd_message.set_token('API_NAME',l_api_name);
2489: fnd_message.set_token('SQL_ERROR',SQLERRM);
2490: x_error_message := fnd_message.get;
2491: x_return_status := l_fnd_unexpected;
2492:

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

2485: WHEN others THEN
2486: l_sql_error := SQLERRM;
2487: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2488: fnd_message.set_token('API_NAME',l_api_name);
2489: fnd_message.set_token('SQL_ERROR',SQLERRM);
2490: x_error_message := fnd_message.get;
2491: x_return_status := l_fnd_unexpected;
2492:
2493: END get_iface_create_recs;

Line 2490: x_error_message := fnd_message.get;

2486: l_sql_error := SQLERRM;
2487: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2488: fnd_message.set_token('API_NAME',l_api_name);
2489: fnd_message.set_token('SQL_ERROR',SQLERRM);
2490: x_error_message := fnd_message.get;
2491: x_return_status := l_fnd_unexpected;
2492:
2493: END get_iface_create_recs;
2494:

Line 2661: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');

2657: END IF;
2658:
2659: EXCEPTION
2660: WHEN NO_DATA_FOUND THEN
2661: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2662: fnd_message.set_token('API_NAME',l_api_name);
2663: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2664: fnd_message.set_token('TO_DATE',l_txn_to_date);
2665: x_error_message := fnd_message.get;

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

2658:
2659: EXCEPTION
2660: WHEN NO_DATA_FOUND THEN
2661: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2662: fnd_message.set_token('API_NAME',l_api_name);
2663: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2664: fnd_message.set_token('TO_DATE',l_txn_to_date);
2665: x_error_message := fnd_message.get;
2666: x_return_status := l_fnd_error;

Line 2663: fnd_message.set_token('FROM_DATE',l_txn_from_date);

2659: EXCEPTION
2660: WHEN NO_DATA_FOUND THEN
2661: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2662: fnd_message.set_token('API_NAME',l_api_name);
2663: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2664: fnd_message.set_token('TO_DATE',l_txn_to_date);
2665: x_error_message := fnd_message.get;
2666: x_return_status := l_fnd_error;
2667:

Line 2664: fnd_message.set_token('TO_DATE',l_txn_to_date);

2660: WHEN NO_DATA_FOUND THEN
2661: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2662: fnd_message.set_token('API_NAME',l_api_name);
2663: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2664: fnd_message.set_token('TO_DATE',l_txn_to_date);
2665: x_error_message := fnd_message.get;
2666: x_return_status := l_fnd_error;
2667:
2668: WHEN others THEN

Line 2665: x_error_message := fnd_message.get;

2661: fnd_message.set_name('CSI','CSI_ML_NO_DATA_FOUND');
2662: fnd_message.set_token('API_NAME',l_api_name);
2663: fnd_message.set_token('FROM_DATE',l_txn_from_date);
2664: fnd_message.set_token('TO_DATE',l_txn_to_date);
2665: x_error_message := fnd_message.get;
2666: x_return_status := l_fnd_error;
2667:
2668: WHEN others THEN
2669: l_sql_error := SQLERRM;

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

2666: x_return_status := l_fnd_error;
2667:
2668: WHEN others THEN
2669: l_sql_error := SQLERRM;
2670: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2671: fnd_message.set_token('API_NAME',l_api_name);
2672: fnd_message.set_token('SQL_ERROR',SQLERRM);
2673: x_error_message := fnd_message.get;
2674: x_return_status := l_fnd_unexpected;

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

2667:
2668: WHEN others THEN
2669: l_sql_error := SQLERRM;
2670: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2671: fnd_message.set_token('API_NAME',l_api_name);
2672: fnd_message.set_token('SQL_ERROR',SQLERRM);
2673: x_error_message := fnd_message.get;
2674: x_return_status := l_fnd_unexpected;
2675:

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

2668: WHEN others THEN
2669: l_sql_error := SQLERRM;
2670: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2671: fnd_message.set_token('API_NAME',l_api_name);
2672: fnd_message.set_token('SQL_ERROR',SQLERRM);
2673: x_error_message := fnd_message.get;
2674: x_return_status := l_fnd_unexpected;
2675:
2676: END get_iface_rel_recs;

Line 2673: x_error_message := fnd_message.get;

2669: l_sql_error := SQLERRM;
2670: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
2671: fnd_message.set_token('API_NAME',l_api_name);
2672: fnd_message.set_token('SQL_ERROR',SQLERRM);
2673: x_error_message := fnd_message.get;
2674: x_return_status := l_fnd_unexpected;
2675:
2676: END get_iface_rel_recs;
2677: