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;
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;
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:
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);
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;
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);
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,
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;
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:
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 (
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;
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 (
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,
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;
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 :=
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;
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;
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 :=
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;
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;
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 :=
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;