DBA Data[Home] [Help]

APPS.PO_REQUISITION_LINES_PKG4 dependencies on FND_LOG

Line 103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_revision '||X_Item_Revision ||' Database item_revision '||Recinfo.item_revision);

99: return;
100: else
101: IF (g_fnd_debug = 'Y') THEN
102: IF (NVL(TRIM(X_Item_Revision),'-999') <> NVL( TRIM(Recinfo.item_revision),'-999')) THEN
103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_revision '||X_Item_Revision ||' Database item_revision '||Recinfo.item_revision);
104: END IF;
105: IF (NVL(X_Quantity_Delivered,-999) <> NVL(Recinfo.quantity_delivered,-999)) THEN
106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_delivered'||X_Quantity_Delivered ||' Database quantity_delivered '|| Recinfo.quantity_delivered);
107: END IF;

Line 106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_delivered'||X_Quantity_Delivered ||' Database quantity_delivered '|| Recinfo.quantity_delivered);

102: IF (NVL(TRIM(X_Item_Revision),'-999') <> NVL( TRIM(Recinfo.item_revision),'-999')) THEN
103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_revision '||X_Item_Revision ||' Database item_revision '||Recinfo.item_revision);
104: END IF;
105: IF (NVL(X_Quantity_Delivered,-999) <> NVL(Recinfo.quantity_delivered,-999)) THEN
106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_delivered'||X_Quantity_Delivered ||' Database quantity_delivered '|| Recinfo.quantity_delivered);
107: END IF;
108: IF (NVL(X_Suggested_Buyer_Id,-999) <> NVL(Recinfo.suggested_buyer_id,-999)) THEN
109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_buyer_id'||X_Suggested_Buyer_Id ||' Database suggested_buyer_id '|| Recinfo.suggested_buyer_id);
110: END IF;

Line 109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_buyer_id'||X_Suggested_Buyer_Id ||' Database suggested_buyer_id '|| Recinfo.suggested_buyer_id);

105: IF (NVL(X_Quantity_Delivered,-999) <> NVL(Recinfo.quantity_delivered,-999)) THEN
106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_delivered'||X_Quantity_Delivered ||' Database quantity_delivered '|| Recinfo.quantity_delivered);
107: END IF;
108: IF (NVL(X_Suggested_Buyer_Id,-999) <> NVL(Recinfo.suggested_buyer_id,-999)) THEN
109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_buyer_id'||X_Suggested_Buyer_Id ||' Database suggested_buyer_id '|| Recinfo.suggested_buyer_id);
110: END IF;
111: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
113: END IF;

Line 112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);

108: IF (NVL(X_Suggested_Buyer_Id,-999) <> NVL(Recinfo.suggested_buyer_id,-999)) THEN
109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form suggested_buyer_id'||X_Suggested_Buyer_Id ||' Database suggested_buyer_id '|| Recinfo.suggested_buyer_id);
110: END IF;
111: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
113: END IF;
114: IF (NVL(TRIM(X_Rfq_Required_Flag),'-999') <> NVL( TRIM(Recinfo.rfq_required_flag),'-999')) THEN
115: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rfq_required_flag '||X_Rfq_Required_Flag ||' Database rfq_required_flag '||Recinfo.rfq_required_flag);
116: END IF;

Line 115: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rfq_required_flag '||X_Rfq_Required_Flag ||' Database rfq_required_flag '||Recinfo.rfq_required_flag);

111: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
113: END IF;
114: IF (NVL(TRIM(X_Rfq_Required_Flag),'-999') <> NVL( TRIM(Recinfo.rfq_required_flag),'-999')) THEN
115: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rfq_required_flag '||X_Rfq_Required_Flag ||' Database rfq_required_flag '||Recinfo.rfq_required_flag);
116: END IF;
117: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
119: END IF;

Line 118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);

114: IF (NVL(TRIM(X_Rfq_Required_Flag),'-999') <> NVL( TRIM(Recinfo.rfq_required_flag),'-999')) THEN
115: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form rfq_required_flag '||X_Rfq_Required_Flag ||' Database rfq_required_flag '||Recinfo.rfq_required_flag);
116: END IF;
117: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
119: END IF;
120: IF (NVL(X_Line_Location_Id,-999) <> NVL(Recinfo.line_location_id,-999)) THEN
121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_location_id'||X_Line_Location_Id ||' Database line_location_id '|| Recinfo.line_location_id);
122: END IF;

Line 121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_location_id'||X_Line_Location_Id ||' Database line_location_id '|| Recinfo.line_location_id);

117: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
119: END IF;
120: IF (NVL(X_Line_Location_Id,-999) <> NVL(Recinfo.line_location_id,-999)) THEN
121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_location_id'||X_Line_Location_Id ||' Database line_location_id '|| Recinfo.line_location_id);
122: END IF;
123: IF (NVL(TRIM(X_Modified_By_Agent_Flag),'-999') <> NVL( TRIM(Recinfo.modified_by_agent_flag),'-999')) THEN
124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form modified_by_agent_flag '||X_Modified_By_Agent_Flag ||' Database modified_by_agent_flag '||Recinfo.modified_by_agent_flag);
125: END IF;

Line 124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form modified_by_agent_flag '||X_Modified_By_Agent_Flag ||' Database modified_by_agent_flag '||Recinfo.modified_by_agent_flag);

120: IF (NVL(X_Line_Location_Id,-999) <> NVL(Recinfo.line_location_id,-999)) THEN
121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_location_id'||X_Line_Location_Id ||' Database line_location_id '|| Recinfo.line_location_id);
122: END IF;
123: IF (NVL(TRIM(X_Modified_By_Agent_Flag),'-999') <> NVL( TRIM(Recinfo.modified_by_agent_flag),'-999')) THEN
124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form modified_by_agent_flag '||X_Modified_By_Agent_Flag ||' Database modified_by_agent_flag '||Recinfo.modified_by_agent_flag);
125: END IF;
126: IF (NVL(X_Parent_Req_Line_Id,-999) <> NVL(Recinfo.parent_req_line_id,-999)) THEN
127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form parent_req_line_id'||X_Parent_Req_Line_Id ||' Database parent_req_line_id '|| Recinfo.parent_req_line_id);
128: END IF;

Line 127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form parent_req_line_id'||X_Parent_Req_Line_Id ||' Database parent_req_line_id '|| Recinfo.parent_req_line_id);

123: IF (NVL(TRIM(X_Modified_By_Agent_Flag),'-999') <> NVL( TRIM(Recinfo.modified_by_agent_flag),'-999')) THEN
124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form modified_by_agent_flag '||X_Modified_By_Agent_Flag ||' Database modified_by_agent_flag '||Recinfo.modified_by_agent_flag);
125: END IF;
126: IF (NVL(X_Parent_Req_Line_Id,-999) <> NVL(Recinfo.parent_req_line_id,-999)) THEN
127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form parent_req_line_id'||X_Parent_Req_Line_Id ||' Database parent_req_line_id '|| Recinfo.parent_req_line_id);
128: END IF;
129: IF (NVL(TRIM(X_Justification),'-999') <> NVL( TRIM(Recinfo.justification),'-999')) THEN
130: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form justification '||X_Justification ||' Database justification '||Recinfo.justification);
131: END IF;

Line 130: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form justification '||X_Justification ||' Database justification '||Recinfo.justification);

126: IF (NVL(X_Parent_Req_Line_Id,-999) <> NVL(Recinfo.parent_req_line_id,-999)) THEN
127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form parent_req_line_id'||X_Parent_Req_Line_Id ||' Database parent_req_line_id '|| Recinfo.parent_req_line_id);
128: END IF;
129: IF (NVL(TRIM(X_Justification),'-999') <> NVL( TRIM(Recinfo.justification),'-999')) THEN
130: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form justification '||X_Justification ||' Database justification '||Recinfo.justification);
131: END IF;
132: IF (NVL(TRIM(X_Note_To_Agent),'-999') <> NVL( TRIM(Recinfo.note_to_agent),'-999')) THEN
133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_agent '||X_Note_To_Agent ||' Database note_to_agent '||Recinfo.note_to_agent);
134: END IF;

Line 133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_agent '||X_Note_To_Agent ||' Database note_to_agent '||Recinfo.note_to_agent);

129: IF (NVL(TRIM(X_Justification),'-999') <> NVL( TRIM(Recinfo.justification),'-999')) THEN
130: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form justification '||X_Justification ||' Database justification '||Recinfo.justification);
131: END IF;
132: IF (NVL(TRIM(X_Note_To_Agent),'-999') <> NVL( TRIM(Recinfo.note_to_agent),'-999')) THEN
133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_agent '||X_Note_To_Agent ||' Database note_to_agent '||Recinfo.note_to_agent);
134: END IF;
135: IF (NVL(TRIM(X_Note_To_Receiver),'-999') <> NVL( TRIM(Recinfo.note_to_receiver),'-999')) THEN
136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_receiver '||X_Note_To_Receiver ||' Database note_to_receiver '||Recinfo.note_to_receiver);
137: END IF;

Line 136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_receiver '||X_Note_To_Receiver ||' Database note_to_receiver '||Recinfo.note_to_receiver);

132: IF (NVL(TRIM(X_Note_To_Agent),'-999') <> NVL( TRIM(Recinfo.note_to_agent),'-999')) THEN
133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_agent '||X_Note_To_Agent ||' Database note_to_agent '||Recinfo.note_to_agent);
134: END IF;
135: IF (NVL(TRIM(X_Note_To_Receiver),'-999') <> NVL( TRIM(Recinfo.note_to_receiver),'-999')) THEN
136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_receiver '||X_Note_To_Receiver ||' Database note_to_receiver '||Recinfo.note_to_receiver);
137: END IF;
138: IF (NVL(X_Purchasing_Agent_Id,-999) <> NVL(Recinfo.purchasing_agent_id,-999)) THEN
139: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form purchasing_agent_id'||X_Purchasing_Agent_Id ||' Database purchasing_agent_id '|| Recinfo.purchasing_agent_id);
140: END IF;

Line 139: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form purchasing_agent_id'||X_Purchasing_Agent_Id ||' Database purchasing_agent_id '|| Recinfo.purchasing_agent_id);

135: IF (NVL(TRIM(X_Note_To_Receiver),'-999') <> NVL( TRIM(Recinfo.note_to_receiver),'-999')) THEN
136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_receiver '||X_Note_To_Receiver ||' Database note_to_receiver '||Recinfo.note_to_receiver);
137: END IF;
138: IF (NVL(X_Purchasing_Agent_Id,-999) <> NVL(Recinfo.purchasing_agent_id,-999)) THEN
139: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form purchasing_agent_id'||X_Purchasing_Agent_Id ||' Database purchasing_agent_id '|| Recinfo.purchasing_agent_id);
140: END IF;
141: IF (NVL(TRIM(X_Document_Type_Code),'-999') <> NVL( TRIM(Recinfo.document_type_code),'-999')) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form document_type_code '||X_Document_Type_Code ||' Database document_type_code '||Recinfo.document_type_code);
143: END IF;

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

138: IF (NVL(X_Purchasing_Agent_Id,-999) <> NVL(Recinfo.purchasing_agent_id,-999)) THEN
139: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form purchasing_agent_id'||X_Purchasing_Agent_Id ||' Database purchasing_agent_id '|| Recinfo.purchasing_agent_id);
140: END IF;
141: IF (NVL(TRIM(X_Document_Type_Code),'-999') <> NVL( TRIM(Recinfo.document_type_code),'-999')) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form document_type_code '||X_Document_Type_Code ||' Database document_type_code '||Recinfo.document_type_code);
143: END IF;
144: IF (NVL(X_Blanket_Po_Header_Id,-999) <> NVL(Recinfo.blanket_po_header_id,-999)) THEN
145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form blanket_po_header_id'||X_Blanket_Po_Header_Id ||' Database blanket_po_header_id '|| Recinfo.blanket_po_header_id);
146: END IF;

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

141: IF (NVL(TRIM(X_Document_Type_Code),'-999') <> NVL( TRIM(Recinfo.document_type_code),'-999')) THEN
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form document_type_code '||X_Document_Type_Code ||' Database document_type_code '||Recinfo.document_type_code);
143: END IF;
144: IF (NVL(X_Blanket_Po_Header_Id,-999) <> NVL(Recinfo.blanket_po_header_id,-999)) THEN
145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form blanket_po_header_id'||X_Blanket_Po_Header_Id ||' Database blanket_po_header_id '|| Recinfo.blanket_po_header_id);
146: END IF;
147: IF (NVL(X_Blanket_Po_Line_Num,-999) <> NVL(Recinfo.blanket_po_line_num,-999)) THEN
148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form blanket_po_line_num'||X_Blanket_Po_Line_Num ||' Database blanket_po_line_num '|| Recinfo.blanket_po_line_num);
149: END IF;

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

144: IF (NVL(X_Blanket_Po_Header_Id,-999) <> NVL(Recinfo.blanket_po_header_id,-999)) THEN
145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form blanket_po_header_id'||X_Blanket_Po_Header_Id ||' Database blanket_po_header_id '|| Recinfo.blanket_po_header_id);
146: END IF;
147: IF (NVL(X_Blanket_Po_Line_Num,-999) <> NVL(Recinfo.blanket_po_line_num,-999)) THEN
148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form blanket_po_line_num'||X_Blanket_Po_Line_Num ||' Database blanket_po_line_num '|| Recinfo.blanket_po_line_num);
149: END IF;
150: IF (NVL(TRIM(X_Currency_Code),'-999') <> NVL( TRIM(Recinfo.currency_code),'-999')) THEN
151: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_code '||X_Currency_Code ||' Database currency_code '||Recinfo.currency_code);
152: END IF;

Line 151: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_code '||X_Currency_Code ||' Database currency_code '||Recinfo.currency_code);

147: IF (NVL(X_Blanket_Po_Line_Num,-999) <> NVL(Recinfo.blanket_po_line_num,-999)) THEN
148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form blanket_po_line_num'||X_Blanket_Po_Line_Num ||' Database blanket_po_line_num '|| Recinfo.blanket_po_line_num);
149: END IF;
150: IF (NVL(TRIM(X_Currency_Code),'-999') <> NVL( TRIM(Recinfo.currency_code),'-999')) THEN
151: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form currency_code '||X_Currency_Code ||' Database currency_code '||Recinfo.currency_code);
152: END IF;
153: END IF;
154: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
155: APP_EXCEPTION.RAISE_EXCEPTION;