eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQUISITION_LINES_PKG3 dependencies on FND_LOG

Line 164: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate_type '||X_Rate_Type ||' Database rate_type '||Recinfo.rate_type);

160: return;
161: else
162: IF (g_fnd_debug = 'Y') THEN
163: IF (NVL(TRIM(X_Rate_Type),'-999') <> NVL( TRIM(Recinfo.rate_type),'-999')) THEN
164: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate_type '||X_Rate_Type ||' Database rate_type '||Recinfo.rate_type);
165: END IF;
166: IF (X_Rate_Date <> Recinfo.rate_date ) THEN
167: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate_date '||X_Rate_Date ||' Database rate_date '||Recinfo.rate_date);
168: END IF;

Line 167: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate_date '||X_Rate_Date ||' Database rate_date '||Recinfo.rate_date);

163: IF (NVL(TRIM(X_Rate_Type),'-999') <> NVL( TRIM(Recinfo.rate_type),'-999')) THEN
164: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate_type '||X_Rate_Type ||' Database rate_type '||Recinfo.rate_type);
165: END IF;
166: IF (X_Rate_Date <> Recinfo.rate_date ) THEN
167: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate_date '||X_Rate_Date ||' Database rate_date '||Recinfo.rate_date);
168: END IF;
169: IF (NVL(X_Rate,-999) <> NVL(Recinfo.rate,-999)) THEN
170: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate'||X_Rate ||' Database rate '|| Recinfo.rate);
171: END IF;

Line 170: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate'||X_Rate ||' Database rate '|| Recinfo.rate);

166: IF (X_Rate_Date <> Recinfo.rate_date ) THEN
167: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate_date '||X_Rate_Date ||' Database rate_date '||Recinfo.rate_date);
168: END IF;
169: IF (NVL(X_Rate,-999) <> NVL(Recinfo.rate,-999)) THEN
170: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate'||X_Rate ||' Database rate '|| Recinfo.rate);
171: END IF;
172: IF (NVL(X_Currency_Unit_Price,-999) <> NVL(Recinfo.currency_unit_price,-999)) THEN
173: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_unit_price'||X_Currency_Unit_Price ||' Database currency_unit_price '|| Recinfo.currency_unit_price);
174: END IF;

Line 173: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_unit_price'||X_Currency_Unit_Price ||' Database currency_unit_price '|| Recinfo.currency_unit_price);

169: IF (NVL(X_Rate,-999) <> NVL(Recinfo.rate,-999)) THEN
170: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rate'||X_Rate ||' Database rate '|| Recinfo.rate);
171: END IF;
172: IF (NVL(X_Currency_Unit_Price,-999) <> NVL(Recinfo.currency_unit_price,-999)) THEN
173: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_unit_price'||X_Currency_Unit_Price ||' Database currency_unit_price '|| Recinfo.currency_unit_price);
174: END IF;
175: IF (NVL(X_Currency_Amount,-999) <> NVL(Recinfo.currency_amount,-999)) THEN
176: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_amount'||X_Currency_Amount ||' Database currency_amount '|| Recinfo.currency_amount);
177: END IF;

Line 176: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_amount'||X_Currency_Amount ||' Database currency_amount '|| Recinfo.currency_amount);

172: IF (NVL(X_Currency_Unit_Price,-999) <> NVL(Recinfo.currency_unit_price,-999)) THEN
173: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_unit_price'||X_Currency_Unit_Price ||' Database currency_unit_price '|| Recinfo.currency_unit_price);
174: END IF;
175: IF (NVL(X_Currency_Amount,-999) <> NVL(Recinfo.currency_amount,-999)) THEN
176: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_amount'||X_Currency_Amount ||' Database currency_amount '|| Recinfo.currency_amount);
177: END IF;
178: IF (NVL(TRIM(X_Suggested_Vendor_Name),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_name),'-999')) THEN
179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_name '||X_Suggested_Vendor_Name ||' Database suggested_vendor_name '||Recinfo.suggested_vendor_name);
180: END IF;

Line 179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_name '||X_Suggested_Vendor_Name ||' Database suggested_vendor_name '||Recinfo.suggested_vendor_name);

175: IF (NVL(X_Currency_Amount,-999) <> NVL(Recinfo.currency_amount,-999)) THEN
176: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_amount'||X_Currency_Amount ||' Database currency_amount '|| Recinfo.currency_amount);
177: END IF;
178: IF (NVL(TRIM(X_Suggested_Vendor_Name),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_name),'-999')) THEN
179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_name '||X_Suggested_Vendor_Name ||' Database suggested_vendor_name '||Recinfo.suggested_vendor_name);
180: END IF;
181: IF (NVL(TRIM(X_Suggested_Vendor_Location),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_location),'-999')) THEN
182: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_location '||X_Suggested_Vendor_Location ||' Database suggested_vendor_location '||Recinfo.suggested_vendor_location);
183: END IF;

Line 182: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_location '||X_Suggested_Vendor_Location ||' Database suggested_vendor_location '||Recinfo.suggested_vendor_location);

178: IF (NVL(TRIM(X_Suggested_Vendor_Name),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_name),'-999')) THEN
179: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_name '||X_Suggested_Vendor_Name ||' Database suggested_vendor_name '||Recinfo.suggested_vendor_name);
180: END IF;
181: IF (NVL(TRIM(X_Suggested_Vendor_Location),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_location),'-999')) THEN
182: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_location '||X_Suggested_Vendor_Location ||' Database suggested_vendor_location '||Recinfo.suggested_vendor_location);
183: END IF;
184: IF (NVL(TRIM(X_Suggested_Vendor_Contact),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_contact),'-999')) THEN
185: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_contact '||X_Suggested_Vendor_Contact ||' Database suggested_vendor_contact '||Recinfo.suggested_vendor_contact);
186: END IF;

Line 185: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_contact '||X_Suggested_Vendor_Contact ||' Database suggested_vendor_contact '||Recinfo.suggested_vendor_contact);

181: IF (NVL(TRIM(X_Suggested_Vendor_Location),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_location),'-999')) THEN
182: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_location '||X_Suggested_Vendor_Location ||' Database suggested_vendor_location '||Recinfo.suggested_vendor_location);
183: END IF;
184: IF (NVL(TRIM(X_Suggested_Vendor_Contact),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_contact),'-999')) THEN
185: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_contact '||X_Suggested_Vendor_Contact ||' Database suggested_vendor_contact '||Recinfo.suggested_vendor_contact);
186: END IF;
187: IF (NVL(TRIM(X_Suggested_Vendor_Phone),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_phone),'-999')) THEN
188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_phone '||X_Suggested_Vendor_Phone ||' Database suggested_vendor_phone '||Recinfo.suggested_vendor_phone);
189: END IF;

Line 188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_phone '||X_Suggested_Vendor_Phone ||' Database suggested_vendor_phone '||Recinfo.suggested_vendor_phone);

184: IF (NVL(TRIM(X_Suggested_Vendor_Contact),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_contact),'-999')) THEN
185: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_contact '||X_Suggested_Vendor_Contact ||' Database suggested_vendor_contact '||Recinfo.suggested_vendor_contact);
186: END IF;
187: IF (NVL(TRIM(X_Suggested_Vendor_Phone),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_phone),'-999')) THEN
188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_phone '||X_Suggested_Vendor_Phone ||' Database suggested_vendor_phone '||Recinfo.suggested_vendor_phone);
189: END IF;
190: IF (NVL(TRIM(X_Sugg_Vendor_Product_Code),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_product_code),'-999')) THEN
191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form sugg_vendor_product_code '||X_Sugg_Vendor_Product_Code ||' Database sugg_vendor_product_code '||Recinfo.suggested_vendor_product_code);
192: END IF;

Line 191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form sugg_vendor_product_code '||X_Sugg_Vendor_Product_Code ||' Database sugg_vendor_product_code '||Recinfo.suggested_vendor_product_code);

187: IF (NVL(TRIM(X_Suggested_Vendor_Phone),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_phone),'-999')) THEN
188: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_vendor_phone '||X_Suggested_Vendor_Phone ||' Database suggested_vendor_phone '||Recinfo.suggested_vendor_phone);
189: END IF;
190: IF (NVL(TRIM(X_Sugg_Vendor_Product_Code),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_product_code),'-999')) THEN
191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form sugg_vendor_product_code '||X_Sugg_Vendor_Product_Code ||' Database sugg_vendor_product_code '||Recinfo.suggested_vendor_product_code);
192: END IF;
193: IF (NVL(X_Un_Number_Id,-999) <> NVL(Recinfo.un_number_id,-999)) THEN
194: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form un_number_id'||X_Un_Number_Id ||' Database un_number_id '|| Recinfo.un_number_id);
195: END IF;

Line 194: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form un_number_id'||X_Un_Number_Id ||' Database un_number_id '|| Recinfo.un_number_id);

190: IF (NVL(TRIM(X_Sugg_Vendor_Product_Code),'-999') <> NVL( TRIM(Recinfo.suggested_vendor_product_code),'-999')) THEN
191: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form sugg_vendor_product_code '||X_Sugg_Vendor_Product_Code ||' Database sugg_vendor_product_code '||Recinfo.suggested_vendor_product_code);
192: END IF;
193: IF (NVL(X_Un_Number_Id,-999) <> NVL(Recinfo.un_number_id,-999)) THEN
194: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form un_number_id'||X_Un_Number_Id ||' Database un_number_id '|| Recinfo.un_number_id);
195: END IF;
196: IF (NVL(X_Hazard_Class_Id,-999) <> NVL(Recinfo.hazard_class_id,-999)) THEN
197: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form hazard_class_id'||X_Hazard_Class_Id ||' Database hazard_class_id '|| Recinfo.hazard_class_id);
198: END IF;

Line 197: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form hazard_class_id'||X_Hazard_Class_Id ||' Database hazard_class_id '|| Recinfo.hazard_class_id);

193: IF (NVL(X_Un_Number_Id,-999) <> NVL(Recinfo.un_number_id,-999)) THEN
194: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form un_number_id'||X_Un_Number_Id ||' Database un_number_id '|| Recinfo.un_number_id);
195: END IF;
196: IF (NVL(X_Hazard_Class_Id,-999) <> NVL(Recinfo.hazard_class_id,-999)) THEN
197: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form hazard_class_id'||X_Hazard_Class_Id ||' Database hazard_class_id '|| Recinfo.hazard_class_id);
198: END IF;
199: IF (NVL(TRIM(X_Must_Use_Sugg_Vendor_Flag),'-999') <> NVL( TRIM(Recinfo.must_use_sugg_vendor_flag),'-999')) THEN
200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form must_use_sugg_vendor_flag '||X_Must_Use_Sugg_Vendor_Flag ||' Database must_use_sugg_vendor_flag '||Recinfo.must_use_sugg_vendor_flag);
201: END IF;

Line 200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form must_use_sugg_vendor_flag '||X_Must_Use_Sugg_Vendor_Flag ||' Database must_use_sugg_vendor_flag '||Recinfo.must_use_sugg_vendor_flag);

196: IF (NVL(X_Hazard_Class_Id,-999) <> NVL(Recinfo.hazard_class_id,-999)) THEN
197: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form hazard_class_id'||X_Hazard_Class_Id ||' Database hazard_class_id '|| Recinfo.hazard_class_id);
198: END IF;
199: IF (NVL(TRIM(X_Must_Use_Sugg_Vendor_Flag),'-999') <> NVL( TRIM(Recinfo.must_use_sugg_vendor_flag),'-999')) THEN
200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form must_use_sugg_vendor_flag '||X_Must_Use_Sugg_Vendor_Flag ||' Database must_use_sugg_vendor_flag '||Recinfo.must_use_sugg_vendor_flag);
201: END IF;
202: IF (NVL(TRIM(X_Reference_Num),'-999') <> NVL( TRIM(Recinfo.reference_num),'-999')) THEN
203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form reference_num '||X_Reference_Num ||' Database reference_num '||Recinfo.reference_num);
204: END IF;

Line 203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form reference_num '||X_Reference_Num ||' Database reference_num '||Recinfo.reference_num);

199: IF (NVL(TRIM(X_Must_Use_Sugg_Vendor_Flag),'-999') <> NVL( TRIM(Recinfo.must_use_sugg_vendor_flag),'-999')) THEN
200: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form must_use_sugg_vendor_flag '||X_Must_Use_Sugg_Vendor_Flag ||' Database must_use_sugg_vendor_flag '||Recinfo.must_use_sugg_vendor_flag);
201: END IF;
202: IF (NVL(TRIM(X_Reference_Num),'-999') <> NVL( TRIM(Recinfo.reference_num),'-999')) THEN
203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form reference_num '||X_Reference_Num ||' Database reference_num '||Recinfo.reference_num);
204: END IF;
205: IF (NVL(TRIM(X_On_Rfq_Flag),'-999') <> NVL( TRIM(Recinfo.on_rfq_flag),'-999')) THEN
206: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form on_rfq_flag '||X_On_Rfq_Flag ||' Database on_rfq_flag '||Recinfo.on_rfq_flag);
207: END IF;

Line 206: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form on_rfq_flag '||X_On_Rfq_Flag ||' Database on_rfq_flag '||Recinfo.on_rfq_flag);

202: IF (NVL(TRIM(X_Reference_Num),'-999') <> NVL( TRIM(Recinfo.reference_num),'-999')) THEN
203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form reference_num '||X_Reference_Num ||' Database reference_num '||Recinfo.reference_num);
204: END IF;
205: IF (NVL(TRIM(X_On_Rfq_Flag),'-999') <> NVL( TRIM(Recinfo.on_rfq_flag),'-999')) THEN
206: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form on_rfq_flag '||X_On_Rfq_Flag ||' Database on_rfq_flag '||Recinfo.on_rfq_flag);
207: END IF;
208: IF (NVL(TRIM(X_Urgent_Flag),'-999') <> NVL( TRIM(Recinfo.urgent_flag),'-999')) THEN
209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form urgent_flag '||X_Urgent_Flag ||' Database urgent_flag '||Recinfo.urgent_flag);
210: END IF;

Line 209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form urgent_flag '||X_Urgent_Flag ||' Database urgent_flag '||Recinfo.urgent_flag);

205: IF (NVL(TRIM(X_On_Rfq_Flag),'-999') <> NVL( TRIM(Recinfo.on_rfq_flag),'-999')) THEN
206: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form on_rfq_flag '||X_On_Rfq_Flag ||' Database on_rfq_flag '||Recinfo.on_rfq_flag);
207: END IF;
208: IF (NVL(TRIM(X_Urgent_Flag),'-999') <> NVL( TRIM(Recinfo.urgent_flag),'-999')) THEN
209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form urgent_flag '||X_Urgent_Flag ||' Database urgent_flag '||Recinfo.urgent_flag);
210: END IF;
211: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
212: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_flag '||X_Cancel_Flag ||' Database cancel_flag '||Recinfo.cancel_flag);
213: END IF;

Line 212: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_flag '||X_Cancel_Flag ||' Database cancel_flag '||Recinfo.cancel_flag);

208: IF (NVL(TRIM(X_Urgent_Flag),'-999') <> NVL( TRIM(Recinfo.urgent_flag),'-999')) THEN
209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form urgent_flag '||X_Urgent_Flag ||' Database urgent_flag '||Recinfo.urgent_flag);
210: END IF;
211: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
212: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_flag '||X_Cancel_Flag ||' Database cancel_flag '||Recinfo.cancel_flag);
213: END IF;
214: IF (NVL(X_Source_Organization_Id,-999) <> NVL(Recinfo.source_organization_id,-999)) THEN
215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_organization_id'||X_Source_Organization_Id ||' Database source_organization_id '|| Recinfo.source_organization_id);
216: END IF;

Line 215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_organization_id'||X_Source_Organization_Id ||' Database source_organization_id '|| Recinfo.source_organization_id);

211: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
212: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_flag '||X_Cancel_Flag ||' Database cancel_flag '||Recinfo.cancel_flag);
213: END IF;
214: IF (NVL(X_Source_Organization_Id,-999) <> NVL(Recinfo.source_organization_id,-999)) THEN
215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_organization_id'||X_Source_Organization_Id ||' Database source_organization_id '|| Recinfo.source_organization_id);
216: END IF;
217: IF (NVL(TRIM(X_Source_Subinventory),'-999') <> NVL( TRIM(Recinfo.source_subinventory),'-999')) THEN
218: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_subinventory '||X_Source_Subinventory ||' Database source_subinventory '||Recinfo.source_subinventory);
219: END IF;

Line 218: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_subinventory '||X_Source_Subinventory ||' Database source_subinventory '||Recinfo.source_subinventory);

214: IF (NVL(X_Source_Organization_Id,-999) <> NVL(Recinfo.source_organization_id,-999)) THEN
215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_organization_id'||X_Source_Organization_Id ||' Database source_organization_id '|| Recinfo.source_organization_id);
216: END IF;
217: IF (NVL(TRIM(X_Source_Subinventory),'-999') <> NVL( TRIM(Recinfo.source_subinventory),'-999')) THEN
218: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_subinventory '||X_Source_Subinventory ||' Database source_subinventory '||Recinfo.source_subinventory);
219: END IF;
220: IF (NVL(TRIM(X_Destination_Type_Code),'-999') <> NVL( TRIM(Recinfo.destination_type_code),'-999')) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_type_code '||X_Destination_Type_Code ||' Database destination_type_code '||Recinfo.destination_type_code);
222: END IF;

Line 221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_type_code '||X_Destination_Type_Code ||' Database destination_type_code '||Recinfo.destination_type_code);

217: IF (NVL(TRIM(X_Source_Subinventory),'-999') <> NVL( TRIM(Recinfo.source_subinventory),'-999')) THEN
218: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_subinventory '||X_Source_Subinventory ||' Database source_subinventory '||Recinfo.source_subinventory);
219: END IF;
220: IF (NVL(TRIM(X_Destination_Type_Code),'-999') <> NVL( TRIM(Recinfo.destination_type_code),'-999')) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_type_code '||X_Destination_Type_Code ||' Database destination_type_code '||Recinfo.destination_type_code);
222: END IF;
223: IF (NVL(X_Destination_Organization_Id,-999) <> NVL(Recinfo.destination_organization_id,-999)) THEN
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_organization_id'||X_Destination_Organization_Id ||' Database destination_organization_id '|| Recinfo.destination_organization_id);
225: END IF;

Line 224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_organization_id'||X_Destination_Organization_Id ||' Database destination_organization_id '|| Recinfo.destination_organization_id);

220: IF (NVL(TRIM(X_Destination_Type_Code),'-999') <> NVL( TRIM(Recinfo.destination_type_code),'-999')) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_type_code '||X_Destination_Type_Code ||' Database destination_type_code '||Recinfo.destination_type_code);
222: END IF;
223: IF (NVL(X_Destination_Organization_Id,-999) <> NVL(Recinfo.destination_organization_id,-999)) THEN
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_organization_id'||X_Destination_Organization_Id ||' Database destination_organization_id '|| Recinfo.destination_organization_id);
225: END IF;
226: IF (NVL(TRIM(X_Destination_Subinventory),'-999') <> NVL( TRIM(Recinfo.destination_subinventory),'-999')) THEN
227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_subinventory '||X_Destination_Subinventory ||' Database destination_subinventory '||Recinfo.destination_subinventory);
228: END IF;

Line 227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_subinventory '||X_Destination_Subinventory ||' Database destination_subinventory '||Recinfo.destination_subinventory);

223: IF (NVL(X_Destination_Organization_Id,-999) <> NVL(Recinfo.destination_organization_id,-999)) THEN
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_organization_id'||X_Destination_Organization_Id ||' Database destination_organization_id '|| Recinfo.destination_organization_id);
225: END IF;
226: IF (NVL(TRIM(X_Destination_Subinventory),'-999') <> NVL( TRIM(Recinfo.destination_subinventory),'-999')) THEN
227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_subinventory '||X_Destination_Subinventory ||' Database destination_subinventory '||Recinfo.destination_subinventory);
228: END IF;
229: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
231: END IF;

Line 230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);

226: IF (NVL(TRIM(X_Destination_Subinventory),'-999') <> NVL( TRIM(Recinfo.destination_subinventory),'-999')) THEN
227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form destination_subinventory '||X_Destination_Subinventory ||' Database destination_subinventory '||Recinfo.destination_subinventory);
228: END IF;
229: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
231: END IF;
232: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_date '||X_Cancel_Date ||' Database cancel_date '||Recinfo.cancel_date);
234: END IF;

Line 233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_date '||X_Cancel_Date ||' Database cancel_date '||Recinfo.cancel_date);

229: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
231: END IF;
232: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_date '||X_Cancel_Date ||' Database cancel_date '||Recinfo.cancel_date);
234: END IF;
235: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_reason '||X_Cancel_Reason ||' Database cancel_reason '||Recinfo.cancel_reason);
237: END IF;

Line 236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_reason '||X_Cancel_Reason ||' Database cancel_reason '||Recinfo.cancel_reason);

232: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_date '||X_Cancel_Date ||' Database cancel_date '||Recinfo.cancel_date);
234: END IF;
235: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_reason '||X_Cancel_Reason ||' Database cancel_reason '||Recinfo.cancel_reason);
237: END IF;
238: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_code '||X_Closed_Code ||' Database closed_code '||Recinfo.closed_code);
240: END IF;

Line 239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_code '||X_Closed_Code ||' Database closed_code '||Recinfo.closed_code);

235: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_reason '||X_Cancel_Reason ||' Database cancel_reason '||Recinfo.cancel_reason);
237: END IF;
238: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_code '||X_Closed_Code ||' Database closed_code '||Recinfo.closed_code);
240: END IF;
241: IF (NVL(TRIM(X_Agent_Return_Note),'-999') <> NVL( TRIM(Recinfo.agent_return_note),'-999')) THEN
242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_note '||X_Agent_Return_Note ||' Database agent_return_note '||Recinfo.agent_return_note);
243: END IF;

Line 242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_note '||X_Agent_Return_Note ||' Database agent_return_note '||Recinfo.agent_return_note);

238: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_code '||X_Closed_Code ||' Database closed_code '||Recinfo.closed_code);
240: END IF;
241: IF (NVL(TRIM(X_Agent_Return_Note),'-999') <> NVL( TRIM(Recinfo.agent_return_note),'-999')) THEN
242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_note '||X_Agent_Return_Note ||' Database agent_return_note '||Recinfo.agent_return_note);
243: END IF;
244: IF (NVL(TRIM(X_Changed_After_Research_Flag),'-999') <> NVL( TRIM(Recinfo.changed_after_research_flag),'-999')) THEN
245: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form changed_after_research_flag '||X_Changed_After_Research_Flag ||' Database changed_after_research_flag '||Recinfo.changed_after_research_flag);
246: END IF;

Line 245: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form changed_after_research_flag '||X_Changed_After_Research_Flag ||' Database changed_after_research_flag '||Recinfo.changed_after_research_flag);

241: IF (NVL(TRIM(X_Agent_Return_Note),'-999') <> NVL( TRIM(Recinfo.agent_return_note),'-999')) THEN
242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_note '||X_Agent_Return_Note ||' Database agent_return_note '||Recinfo.agent_return_note);
243: END IF;
244: IF (NVL(TRIM(X_Changed_After_Research_Flag),'-999') <> NVL( TRIM(Recinfo.changed_after_research_flag),'-999')) THEN
245: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form changed_after_research_flag '||X_Changed_After_Research_Flag ||' Database changed_after_research_flag '||Recinfo.changed_after_research_flag);
246: END IF;
247: IF (NVL(X_Vendor_Id,-999) <> NVL(Recinfo.vendor_id,-999)) THEN
248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_id'||X_Vendor_Id ||' Database vendor_id '|| Recinfo.vendor_id);
249: END IF;

Line 248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_id'||X_Vendor_Id ||' Database vendor_id '|| Recinfo.vendor_id);

244: IF (NVL(TRIM(X_Changed_After_Research_Flag),'-999') <> NVL( TRIM(Recinfo.changed_after_research_flag),'-999')) THEN
245: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form changed_after_research_flag '||X_Changed_After_Research_Flag ||' Database changed_after_research_flag '||Recinfo.changed_after_research_flag);
246: END IF;
247: IF (NVL(X_Vendor_Id,-999) <> NVL(Recinfo.vendor_id,-999)) THEN
248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_id'||X_Vendor_Id ||' Database vendor_id '|| Recinfo.vendor_id);
249: END IF;
250: IF (NVL(X_Vendor_Site_Id,-999) <> NVL(Recinfo.vendor_site_id,-999)) THEN
251: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_site_id'||X_Vendor_Site_Id ||' Database vendor_site_id '|| Recinfo.vendor_site_id);
252: END IF;

Line 251: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_site_id'||X_Vendor_Site_Id ||' Database vendor_site_id '|| Recinfo.vendor_site_id);

247: IF (NVL(X_Vendor_Id,-999) <> NVL(Recinfo.vendor_id,-999)) THEN
248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_id'||X_Vendor_Id ||' Database vendor_id '|| Recinfo.vendor_id);
249: END IF;
250: IF (NVL(X_Vendor_Site_Id,-999) <> NVL(Recinfo.vendor_site_id,-999)) THEN
251: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_site_id'||X_Vendor_Site_Id ||' Database vendor_site_id '|| Recinfo.vendor_site_id);
252: END IF;
253: IF (NVL(X_Vendor_Contact_Id,-999) <> NVL(Recinfo.vendor_contact_id,-999)) THEN
254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_contact_id'||X_Vendor_Contact_Id ||' Database vendor_contact_id '|| Recinfo.vendor_contact_id);
255: END IF;

Line 254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_contact_id'||X_Vendor_Contact_Id ||' Database vendor_contact_id '|| Recinfo.vendor_contact_id);

250: IF (NVL(X_Vendor_Site_Id,-999) <> NVL(Recinfo.vendor_site_id,-999)) THEN
251: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_site_id'||X_Vendor_Site_Id ||' Database vendor_site_id '|| Recinfo.vendor_site_id);
252: END IF;
253: IF (NVL(X_Vendor_Contact_Id,-999) <> NVL(Recinfo.vendor_contact_id,-999)) THEN
254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_contact_id'||X_Vendor_Contact_Id ||' Database vendor_contact_id '|| Recinfo.vendor_contact_id);
255: END IF;
256: END IF;
257: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
258: APP_EXCEPTION.RAISE_EXCEPTION;