DBA Data[Home] [Help]

APPS.CSI_ML_CREATE_PVT dependencies on FND_MESSAGE

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

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

Line 130: l_error_message := fnd_message.get;

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'

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

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

Line 147: l_error_message := fnd_message.get;

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'

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

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

Line 171: l_error_message := fnd_message.get;

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'

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

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

Line 196: l_error_message := fnd_message.get;

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'

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

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;

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

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;

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

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:

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

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

Line 2500: x_error_message := fnd_message.get;

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;

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

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;

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

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:

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

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;

Line 2508: x_error_message := fnd_message.get;

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:

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

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;

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

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;

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

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:

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

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

Line 2683: x_error_message := fnd_message.get;

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;

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

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;

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

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:

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

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;

Line 2691: x_error_message := fnd_message.get;

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: