DBA Data[Home] [Help]

APPS.PO_REQUISITION_LINES_PKG1 dependencies on FND_LOG

Line 99: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_line_id'||X_Requisition_Line_Id ||' Database requisition_line_id '|| Recinfo.requisition_line_id);

95: return;
96: else
97: IF (g_fnd_debug = 'Y') THEN
98: IF (NVL(X_Requisition_Line_Id,-999) <> NVL(Recinfo.requisition_line_id,-999)) THEN
99: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_line_id'||X_Requisition_Line_Id ||' Database requisition_line_id '|| Recinfo.requisition_line_id);
100: END IF;
101: IF (NVL(X_Requisition_Header_Id,-999) <> NVL(Recinfo.requisition_header_id,-999)) THEN
102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_header_id'||X_Requisition_Header_Id ||' Database requisition_header_id '|| Recinfo.requisition_header_id);
103: END IF;

Line 102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_header_id'||X_Requisition_Header_Id ||' Database requisition_header_id '|| Recinfo.requisition_header_id);

98: IF (NVL(X_Requisition_Line_Id,-999) <> NVL(Recinfo.requisition_line_id,-999)) THEN
99: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_line_id'||X_Requisition_Line_Id ||' Database requisition_line_id '|| Recinfo.requisition_line_id);
100: END IF;
101: IF (NVL(X_Requisition_Header_Id,-999) <> NVL(Recinfo.requisition_header_id,-999)) THEN
102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_header_id'||X_Requisition_Header_Id ||' Database requisition_header_id '|| Recinfo.requisition_header_id);
103: END IF;
104: IF (NVL(X_Line_Num,-999) <> NVL(Recinfo.line_num,-999)) THEN
105: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_num'||X_Line_Num ||' Database line_num '|| Recinfo.line_num);
106: END IF;

Line 105: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_num'||X_Line_Num ||' Database line_num '|| Recinfo.line_num);

101: IF (NVL(X_Requisition_Header_Id,-999) <> NVL(Recinfo.requisition_header_id,-999)) THEN
102: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_header_id'||X_Requisition_Header_Id ||' Database requisition_header_id '|| Recinfo.requisition_header_id);
103: END IF;
104: IF (NVL(X_Line_Num,-999) <> NVL(Recinfo.line_num,-999)) THEN
105: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_num'||X_Line_Num ||' Database line_num '|| Recinfo.line_num);
106: END IF;
107: IF (NVL(X_Line_Type_Id,-999) <> NVL(Recinfo.line_type_id,-999)) THEN
108: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_type_id'||X_Line_Type_Id ||' Database line_type_id '|| Recinfo.line_type_id);
109: END IF;

Line 108: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_type_id'||X_Line_Type_Id ||' Database line_type_id '|| Recinfo.line_type_id);

104: IF (NVL(X_Line_Num,-999) <> NVL(Recinfo.line_num,-999)) THEN
105: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_num'||X_Line_Num ||' Database line_num '|| Recinfo.line_num);
106: END IF;
107: IF (NVL(X_Line_Type_Id,-999) <> NVL(Recinfo.line_type_id,-999)) THEN
108: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_type_id'||X_Line_Type_Id ||' Database line_type_id '|| Recinfo.line_type_id);
109: END IF;
110: IF (NVL(X_Category_Id,-999) <> NVL(Recinfo.category_id,-999)) THEN
111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form category_id'||X_Category_Id ||' Database category_id '|| Recinfo.category_id);
112: END IF;

Line 111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form category_id'||X_Category_Id ||' Database category_id '|| Recinfo.category_id);

107: IF (NVL(X_Line_Type_Id,-999) <> NVL(Recinfo.line_type_id,-999)) THEN
108: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_type_id'||X_Line_Type_Id ||' Database line_type_id '|| Recinfo.line_type_id);
109: END IF;
110: IF (NVL(X_Category_Id,-999) <> NVL(Recinfo.category_id,-999)) THEN
111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form category_id'||X_Category_Id ||' Database category_id '|| Recinfo.category_id);
112: END IF;
113: IF (NVL(TRIM(X_Item_Description),'-999') <> NVL( TRIM(Recinfo.item_description),'-999')) THEN
114: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_description '||X_Item_Description ||' Database item_description '||Recinfo.item_description);
115: END IF;

Line 114: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_description '||X_Item_Description ||' Database item_description '||Recinfo.item_description);

110: IF (NVL(X_Category_Id,-999) <> NVL(Recinfo.category_id,-999)) THEN
111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form category_id'||X_Category_Id ||' Database category_id '|| Recinfo.category_id);
112: END IF;
113: IF (NVL(TRIM(X_Item_Description),'-999') <> NVL( TRIM(Recinfo.item_description),'-999')) THEN
114: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_description '||X_Item_Description ||' Database item_description '||Recinfo.item_description);
115: END IF;
116: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
117: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_meas_lookup_code '||X_Unit_Meas_Lookup_Code ||' Database unit_meas_lookup_code '||Recinfo.unit_meas_lookup_code);
118: END IF;

Line 117: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_meas_lookup_code '||X_Unit_Meas_Lookup_Code ||' Database unit_meas_lookup_code '||Recinfo.unit_meas_lookup_code);

113: IF (NVL(TRIM(X_Item_Description),'-999') <> NVL( TRIM(Recinfo.item_description),'-999')) THEN
114: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_description '||X_Item_Description ||' Database item_description '||Recinfo.item_description);
115: END IF;
116: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
117: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_meas_lookup_code '||X_Unit_Meas_Lookup_Code ||' Database unit_meas_lookup_code '||Recinfo.unit_meas_lookup_code);
118: END IF;
119: IF (NVL(X_Unit_Price,-999) <> NVL(Recinfo.unit_price,-999)) THEN
120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_price'||X_Unit_Price ||' Database unit_price '|| Recinfo.unit_price);
121: END IF;

Line 120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_price'||X_Unit_Price ||' Database unit_price '|| Recinfo.unit_price);

116: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
117: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_meas_lookup_code '||X_Unit_Meas_Lookup_Code ||' Database unit_meas_lookup_code '||Recinfo.unit_meas_lookup_code);
118: END IF;
119: IF (NVL(X_Unit_Price,-999) <> NVL(Recinfo.unit_price,-999)) THEN
120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_price'||X_Unit_Price ||' Database unit_price '|| Recinfo.unit_price);
121: END IF;
122: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
124: END IF;

Line 123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);

119: IF (NVL(X_Unit_Price,-999) <> NVL(Recinfo.unit_price,-999)) THEN
120: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_price'||X_Unit_Price ||' Database unit_price '|| Recinfo.unit_price);
121: END IF;
122: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
124: END IF;
125: IF (NVL(X_Amount,-999) <> NVL(Recinfo.amount,-999)) THEN
126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount'||X_Amount ||' Database amount '|| Recinfo.amount);
127: END IF;

Line 126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount'||X_Amount ||' Database amount '|| Recinfo.amount);

122: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
123: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
124: END IF;
125: IF (NVL(X_Amount,-999) <> NVL(Recinfo.amount,-999)) THEN
126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount'||X_Amount ||' Database amount '|| Recinfo.amount);
127: END IF;
128: IF (NVL(X_Deliver_To_Location_Id,-999) <> NVL(Recinfo.deliver_to_location_id,-999)) THEN
129: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form deliver_to_location_id'||X_Deliver_To_Location_Id ||' Database deliver_to_location_id '|| Recinfo.deliver_to_location_id);
130: END IF;

Line 129: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form deliver_to_location_id'||X_Deliver_To_Location_Id ||' Database deliver_to_location_id '|| Recinfo.deliver_to_location_id);

125: IF (NVL(X_Amount,-999) <> NVL(Recinfo.amount,-999)) THEN
126: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount'||X_Amount ||' Database amount '|| Recinfo.amount);
127: END IF;
128: IF (NVL(X_Deliver_To_Location_Id,-999) <> NVL(Recinfo.deliver_to_location_id,-999)) THEN
129: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form deliver_to_location_id'||X_Deliver_To_Location_Id ||' Database deliver_to_location_id '|| Recinfo.deliver_to_location_id);
130: END IF;
131: IF (NVL(X_To_Person_Id,-999) <> NVL(Recinfo.to_person_id,-999)) THEN
132: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form to_person_id'||X_To_Person_Id ||' Database to_person_id '|| Recinfo.to_person_id);
133: END IF;

Line 132: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form to_person_id'||X_To_Person_Id ||' Database to_person_id '|| Recinfo.to_person_id);

128: IF (NVL(X_Deliver_To_Location_Id,-999) <> NVL(Recinfo.deliver_to_location_id,-999)) THEN
129: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form deliver_to_location_id'||X_Deliver_To_Location_Id ||' Database deliver_to_location_id '|| Recinfo.deliver_to_location_id);
130: END IF;
131: IF (NVL(X_To_Person_Id,-999) <> NVL(Recinfo.to_person_id,-999)) THEN
132: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form to_person_id'||X_To_Person_Id ||' Database to_person_id '|| Recinfo.to_person_id);
133: END IF;
134: IF (NVL(TRIM(X_Source_Type_Code),'-999') <> NVL( TRIM(Recinfo.source_type_code),'-999')) THEN
135: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_type_code '||X_Source_Type_Code ||' Database source_type_code '||Recinfo.source_type_code);
136: END IF;

Line 135: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_type_code '||X_Source_Type_Code ||' Database source_type_code '||Recinfo.source_type_code);

131: IF (NVL(X_To_Person_Id,-999) <> NVL(Recinfo.to_person_id,-999)) THEN
132: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form to_person_id'||X_To_Person_Id ||' Database to_person_id '|| Recinfo.to_person_id);
133: END IF;
134: IF (NVL(TRIM(X_Source_Type_Code),'-999') <> NVL( TRIM(Recinfo.source_type_code),'-999')) THEN
135: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_type_code '||X_Source_Type_Code ||' Database source_type_code '||Recinfo.source_type_code);
136: END IF;
137: IF (NVL(X_Item_Id,-999) <> NVL(Recinfo.item_id,-999)) THEN
138: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_id'||X_Item_Id ||' Database item_id '|| Recinfo.item_id);
139: END IF;

Line 138: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_id'||X_Item_Id ||' Database item_id '|| Recinfo.item_id);

134: IF (NVL(TRIM(X_Source_Type_Code),'-999') <> NVL( TRIM(Recinfo.source_type_code),'-999')) THEN
135: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_type_code '||X_Source_Type_Code ||' Database source_type_code '||Recinfo.source_type_code);
136: END IF;
137: IF (NVL(X_Item_Id,-999) <> NVL(Recinfo.item_id,-999)) THEN
138: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_id'||X_Item_Id ||' Database item_id '|| Recinfo.item_id);
139: END IF;
140:
141: IF (NVL(TRIM(X_Secondary_Unit_Of_Measure),'-999') <> NVL( TRIM(Recinfo.secondary_unit_of_measure),'-999')) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form secondary_unit_of_measure '||X_Secondary_Unit_Of_Measure ||' Database secondary_unit_of_measure '||Recinfo.secondary_unit_of_measure);

Line 142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form secondary_unit_of_measure '||X_Secondary_Unit_Of_Measure ||' Database secondary_unit_of_measure '||Recinfo.secondary_unit_of_measure);

138: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_id'||X_Item_Id ||' Database item_id '|| Recinfo.item_id);
139: END IF;
140:
141: IF (NVL(TRIM(X_Secondary_Unit_Of_Measure),'-999') <> NVL( TRIM(Recinfo.secondary_unit_of_measure),'-999')) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form secondary_unit_of_measure '||X_Secondary_Unit_Of_Measure ||' Database secondary_unit_of_measure '||Recinfo.secondary_unit_of_measure);
143: END IF;
144: IF (NVL(X_Secondary_Quantity,-999) <> NVL(Recinfo.secondary_quantity,-999)) THEN
145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form secondary_quantity'||X_Secondary_Quantity ||' Database secondary_quantity '|| Recinfo.secondary_quantity);
146: END IF;

Line 145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form secondary_quantity'||X_Secondary_Quantity ||' Database secondary_quantity '|| Recinfo.secondary_quantity);

141: IF (NVL(TRIM(X_Secondary_Unit_Of_Measure),'-999') <> NVL( TRIM(Recinfo.secondary_unit_of_measure),'-999')) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form secondary_unit_of_measure '||X_Secondary_Unit_Of_Measure ||' Database secondary_unit_of_measure '||Recinfo.secondary_unit_of_measure);
143: END IF;
144: IF (NVL(X_Secondary_Quantity,-999) <> NVL(Recinfo.secondary_quantity,-999)) THEN
145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form secondary_quantity'||X_Secondary_Quantity ||' Database secondary_quantity '|| Recinfo.secondary_quantity);
146: END IF;
147: IF (NVL(TRIM(X_Preferred_Grade),'-999') <> NVL( TRIM(Recinfo.preferred_grade),'-999')) THEN
148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preferred_grade '||X_Preferred_Grade ||' Database preferred_grade '||Recinfo.preferred_grade);
149: END IF;

Line 148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preferred_grade '||X_Preferred_Grade ||' Database preferred_grade '||Recinfo.preferred_grade);

144: IF (NVL(X_Secondary_Quantity,-999) <> NVL(Recinfo.secondary_quantity,-999)) THEN
145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form secondary_quantity'||X_Secondary_Quantity ||' Database secondary_quantity '|| Recinfo.secondary_quantity);
146: END IF;
147: IF (NVL(TRIM(X_Preferred_Grade),'-999') <> NVL( TRIM(Recinfo.preferred_grade),'-999')) THEN
148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preferred_grade '||X_Preferred_Grade ||' Database preferred_grade '||Recinfo.preferred_grade);
149: END IF;
150:
151: END IF;
152: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');