DBA Data[Home] [Help]

APPS.CSI_ML_UPDATE_PVT dependencies on FND_MESSAGE

Line 139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

135: IF(l_debug_level>1) THEN
136: FND_File.Put_Line(Fnd_File.LOG,'Value of l_last_update_date='||to_char(l_last_update_date,'dd-mon-yy hh24:mi:ss'));
137: FND_File.Put_Line(Fnd_File.LOG,'Value of inst_intf_rec.source_transaction_date='||to_char(inst_intf_rec.source_transaction_date,'dd-mon-yy hh24:mi:ss'));
138: end if;
139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);
141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);
142: l_error_message :=substr(fnd_message.get,1,208);
143: RAISE e_restriction;

Line 140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);

136: FND_File.Put_Line(Fnd_File.LOG,'Value of l_last_update_date='||to_char(l_last_update_date,'dd-mon-yy hh24:mi:ss'));
137: FND_File.Put_Line(Fnd_File.LOG,'Value of inst_intf_rec.source_transaction_date='||to_char(inst_intf_rec.source_transaction_date,'dd-mon-yy hh24:mi:ss'));
138: end if;
139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);
141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);
142: l_error_message :=substr(fnd_message.get,1,208);
143: RAISE e_restriction;
144: END IF;

Line 141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);

137: FND_File.Put_Line(Fnd_File.LOG,'Value of inst_intf_rec.source_transaction_date='||to_char(inst_intf_rec.source_transaction_date,'dd-mon-yy hh24:mi:ss'));
138: end if;
139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);
141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);
142: l_error_message :=substr(fnd_message.get,1,208);
143: RAISE e_restriction;
144: END IF;
145:

Line 142: l_error_message :=substr(fnd_message.get,1,208);

138: end if;
139: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
140: fnd_message.set_token('INSTANCE_NUMBER',inst_intf_rec.instance_id);
141: fnd_message.set_token('SOURCE_DATE',inst_intf_rec.source_transaction_date);
142: l_error_message :=substr(fnd_message.get,1,208);
143: RAISE e_restriction;
144: END IF;
145:
146: OPEN ou_obj_ver_cur (inst_intf_rec.instance_id);

Line 152: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

148: l_last_update_date;
149: CLOSE ou_obj_ver_cur;
150: IF l_last_update_date > inst_intf_rec.source_transaction_date
151: THEN
152: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
153: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
154: l_error_message :=substr(fnd_message.get,1,208);
155: RAISE e_restriction;
156: END IF;

Line 153: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

149: CLOSE ou_obj_ver_cur;
150: IF l_last_update_date > inst_intf_rec.source_transaction_date
151: THEN
152: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
153: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
154: l_error_message :=substr(fnd_message.get,1,208);
155: RAISE e_restriction;
156: END IF;
157: OPEN price_obj_ver_cur (inst_intf_rec.instance_id);

Line 154: l_error_message :=substr(fnd_message.get,1,208);

150: IF l_last_update_date > inst_intf_rec.source_transaction_date
151: THEN
152: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
153: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
154: l_error_message :=substr(fnd_message.get,1,208);
155: RAISE e_restriction;
156: END IF;
157: OPEN price_obj_ver_cur (inst_intf_rec.instance_id);
158: FETCH price_obj_ver_cur INTO l_price_object_version,

Line 163: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

159: l_last_update_date;
160: CLOSE price_obj_ver_cur;
161: IF l_last_update_date > inst_intf_rec.source_transaction_date
162: THEN
163: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
164: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
165: l_error_message :=substr(fnd_message.get,1,208);
166: RAISE e_restriction;
167: END IF;

Line 164: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

160: CLOSE price_obj_ver_cur;
161: IF l_last_update_date > inst_intf_rec.source_transaction_date
162: THEN
163: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
164: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
165: l_error_message :=substr(fnd_message.get,1,208);
166: RAISE e_restriction;
167: END IF;
168:

Line 165: l_error_message :=substr(fnd_message.get,1,208);

161: IF l_last_update_date > inst_intf_rec.source_transaction_date
162: THEN
163: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
164: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
165: l_error_message :=substr(fnd_message.get,1,208);
166: RAISE e_restriction;
167: END IF;
168:
169: SELECT l_miss_num /* DECODE (

Line 1780: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

1776: l_last_update_date ;
1777: CLOSE ip_obj_ver_cur;
1778: IF l_last_update_date > inst_intf_rec.source_transaction_date
1779: THEN
1780: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1781: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1782: l_error_message := fnd_message.get;
1783: RAISE e_restriction;
1784: END IF;

Line 1781: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

1777: CLOSE ip_obj_ver_cur;
1778: IF l_last_update_date > inst_intf_rec.source_transaction_date
1779: THEN
1780: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1781: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1782: l_error_message := fnd_message.get;
1783: RAISE e_restriction;
1784: END IF;
1785: SELECT DECODE (

Line 1782: l_error_message := fnd_message.get;

1778: IF l_last_update_date > inst_intf_rec.source_transaction_date
1779: THEN
1780: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1781: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1782: l_error_message := fnd_message.get;
1783: RAISE e_restriction;
1784: END IF;
1785: SELECT DECODE (
1786: party_intf_rec.party_source_table,

Line 1978: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

1974: l_last_update_date;
1975: CLOSE ipa_obj_ver_cur;
1976: IF l_last_update_date > inst_intf_rec.source_transaction_date
1977: THEN
1978: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1979: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1980: l_error_message := fnd_message.get;
1981: RAISE e_restriction;
1982: END IF;

Line 1979: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

1975: CLOSE ipa_obj_ver_cur;
1976: IF l_last_update_date > inst_intf_rec.source_transaction_date
1977: THEN
1978: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1979: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1980: l_error_message := fnd_message.get;
1981: RAISE e_restriction;
1982: END IF;
1983: x_account_tbl (ptyacc_idx).object_version_number :=

Line 1980: l_error_message := fnd_message.get;

1976: IF l_last_update_date > inst_intf_rec.source_transaction_date
1977: THEN
1978: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
1979: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
1980: l_error_message := fnd_message.get;
1981: RAISE e_restriction;
1982: END IF;
1983: x_account_tbl (ptyacc_idx).object_version_number :=
1984: l_ipa1_object_version;

Line 2158: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

2154: l_last_update_date;
2155: CLOSE ipa_obj_ver_cur;
2156: IF l_last_update_date > inst_intf_rec.source_transaction_date
2157: THEN
2158: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2159: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2160: l_error_message := fnd_message.get;
2161: RAISE e_restriction;
2162: END IF;

Line 2159: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

2155: CLOSE ipa_obj_ver_cur;
2156: IF l_last_update_date > inst_intf_rec.source_transaction_date
2157: THEN
2158: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2159: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2160: l_error_message := fnd_message.get;
2161: RAISE e_restriction;
2162: END IF;
2163: x_account_tbl (ptyacc_idx).object_version_number :=

Line 2160: l_error_message := fnd_message.get;

2156: IF l_last_update_date > inst_intf_rec.source_transaction_date
2157: THEN
2158: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2159: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2160: l_error_message := fnd_message.get;
2161: RAISE e_restriction;
2162: END IF;
2163: x_account_tbl (ptyacc_idx).object_version_number :=
2164: l_ipa2_object_version;

Line 2338: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');

2334: l_last_update_date;
2335: CLOSE ipa_obj_ver_cur;
2336: IF l_last_update_date > inst_intf_rec.source_transaction_date
2337: THEN
2338: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2339: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2340: l_error_message := fnd_message.get;
2341: RAISE e_restriction;
2342: END IF;

Line 2339: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);

2335: CLOSE ipa_obj_ver_cur;
2336: IF l_last_update_date > inst_intf_rec.source_transaction_date
2337: THEN
2338: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2339: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2340: l_error_message := fnd_message.get;
2341: RAISE e_restriction;
2342: END IF;
2343: x_account_tbl (ptyacc_idx).object_version_number :=

Line 2340: l_error_message := fnd_message.get;

2336: IF l_last_update_date > inst_intf_rec.source_transaction_date
2337: THEN
2338: fnd_message.set_name('CSI','CSI_INTERFACE_RESTRICTION');
2339: fnd_message.set_token('instance_id',inst_intf_rec.instance_id);
2340: l_error_message := fnd_message.get;
2341: RAISE e_restriction;
2342: END IF;
2343: x_account_tbl (ptyacc_idx).object_version_number :=
2344: l_ipa3_object_version;