DBA Data[Home] [Help]

APPS.PO_REQUISITION_LINES_PKG6 dependencies on FND_LOG

Line 99: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

95: ) then
96: return;
97: else
98: -- Logging Infra: Setting up runtime level
99: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
100: -- Logging Infra: Procedure level
101: IF (FND_LOG.LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
102: if (nvl(X_Attribute7,'-999') <> nvl(Recinfo.Attribute7,'-999') ) then
103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);

Line 101: IF (FND_LOG.LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

97: else
98: -- Logging Infra: Setting up runtime level
99: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
100: -- Logging Infra: Procedure level
101: IF (FND_LOG.LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
102: if (nvl(X_Attribute7,'-999') <> nvl(Recinfo.Attribute7,'-999') ) then
103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
104: end if;
105: if (nvl(X_Attribute8,'-999') <> nvl(Recinfo.Attribute8,'-999') ) then

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

99: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
100: -- Logging Infra: Procedure level
101: IF (FND_LOG.LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
102: if (nvl(X_Attribute7,'-999') <> nvl(Recinfo.Attribute7,'-999') ) then
103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
104: end if;
105: if (nvl(X_Attribute8,'-999') <> nvl(Recinfo.Attribute8,'-999') ) then
106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
107: end if;

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

102: if (nvl(X_Attribute7,'-999') <> nvl(Recinfo.Attribute7,'-999') ) then
103: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
104: end if;
105: if (nvl(X_Attribute8,'-999') <> nvl(Recinfo.Attribute8,'-999') ) then
106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
107: end if;
108: if (nvl(X_Attribute9,'-999') <> nvl(Recinfo.Attribute9,'-999') ) then
109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
110: end if;

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

105: if (nvl(X_Attribute8,'-999') <> nvl(Recinfo.Attribute8,'-999') ) then
106: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
107: end if;
108: if (nvl(X_Attribute9,'-999') <> nvl(Recinfo.Attribute9,'-999') ) then
109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
110: end if;
111: if (nvl(X_Attribute10,'-999') <> nvl(Recinfo.Attribute10,'-999') ) then
112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
113: end if;

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

108: if (nvl(X_Attribute9,'-999') <> nvl(Recinfo.Attribute9,'-999') ) then
109: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
110: end if;
111: if (nvl(X_Attribute10,'-999') <> nvl(Recinfo.Attribute10,'-999') ) then
112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
113: end if;
114: if (nvl(X_Attribute11,'-999') <> nvl(Recinfo.Attribute11,'-999') ) then
115: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
116: end if;

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

111: if (nvl(X_Attribute10,'-999') <> nvl(Recinfo.Attribute10,'-999') ) then
112: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
113: end if;
114: if (nvl(X_Attribute11,'-999') <> nvl(Recinfo.Attribute11,'-999') ) then
115: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
116: end if;
117: if (nvl(X_Attribute12,'-999') <> nvl(Recinfo.Attribute12,'-999') ) then
118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
119: end if;

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

114: if (nvl(X_Attribute11,'-999') <> nvl(Recinfo.Attribute11,'-999') ) then
115: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
116: end if;
117: if (nvl(X_Attribute12,'-999') <> nvl(Recinfo.Attribute12,'-999') ) then
118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
119: end if;
120: if (nvl(X_Attribute13,'-999') <> nvl(Recinfo.Attribute13,'-999') ) then
121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
122: end if;

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

117: if (nvl(X_Attribute12,'-999') <> nvl(Recinfo.Attribute12,'-999') ) then
118: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
119: end if;
120: if (nvl(X_Attribute13,'-999') <> nvl(Recinfo.Attribute13,'-999') ) then
121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
122: end if;
123: if (nvl(X_Attribute14,'-999') <> nvl(Recinfo.Attribute14,'-999') ) then
124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
125: end if;

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

120: if (nvl(X_Attribute13,'-999') <> nvl(Recinfo.Attribute13,'-999') ) then
121: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
122: end if;
123: if (nvl(X_Attribute14,'-999') <> nvl(Recinfo.Attribute14,'-999') ) then
124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
125: end if;
126: if (nvl(X_Attribute15,'-999') <> nvl(Recinfo.Attribute15,'-999') ) then
127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
128: end if;

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

123: if (nvl(X_Attribute14,'-999') <> nvl(Recinfo.Attribute14,'-999') ) then
124: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
125: end if;
126: if (nvl(X_Attribute15,'-999') <> nvl(Recinfo.Attribute15,'-999') ) then
127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
128: end if;
129: if (nvl(X_Bom_Resource_Id, -999 ) <> nvl(Recinfo.Bom_Resource_Id, -999 ) ) then
130: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Bom_Resource_Id '||X_Bom_Resource_Id ||' Database Bom_Resource_Id '||Recinfo.Bom_Resource_Id);
131: end if;

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

126: if (nvl(X_Attribute15,'-999') <> nvl(Recinfo.Attribute15,'-999') ) then
127: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
128: end if;
129: if (nvl(X_Bom_Resource_Id, -999 ) <> nvl(Recinfo.Bom_Resource_Id, -999 ) ) then
130: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Bom_Resource_Id '||X_Bom_Resource_Id ||' Database Bom_Resource_Id '||Recinfo.Bom_Resource_Id);
131: end if;
132: if (nvl(X_Government_Context,'-999') <> nvl(Recinfo.Government_Context,'-999') ) then
133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Government_Context '||X_Government_Context ||' Database Government_Context '||Recinfo.Government_Context);
134: end if;

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

129: if (nvl(X_Bom_Resource_Id, -999 ) <> nvl(Recinfo.Bom_Resource_Id, -999 ) ) then
130: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Bom_Resource_Id '||X_Bom_Resource_Id ||' Database Bom_Resource_Id '||Recinfo.Bom_Resource_Id);
131: end if;
132: if (nvl(X_Government_Context,'-999') <> nvl(Recinfo.Government_Context,'-999') ) then
133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Government_Context '||X_Government_Context ||' Database Government_Context '||Recinfo.Government_Context);
134: end if;
135: if (nvl(X_Closed_Reason,'-999') <> nvl(Recinfo.Closed_Reason,'-999') ) then
136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Closed_Reason '||X_Closed_Reason ||' Database Closed_Reason '||Recinfo.Closed_Reason);
137: end if;

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

132: if (nvl(X_Government_Context,'-999') <> nvl(Recinfo.Government_Context,'-999') ) then
133: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Government_Context '||X_Government_Context ||' Database Government_Context '||Recinfo.Government_Context);
134: end if;
135: if (nvl(X_Closed_Reason,'-999') <> nvl(Recinfo.Closed_Reason,'-999') ) then
136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Closed_Reason '||X_Closed_Reason ||' Database Closed_Reason '||Recinfo.Closed_Reason);
137: end if;
138: if (trunc(X_Closed_Date) <> trunc(Recinfo.Closed_Date) ) then
139: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Closed_Date '||X_Closed_Date ||' Database Closed_Date '||Recinfo.Closed_Date);
140: end if;

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

135: if (nvl(X_Closed_Reason,'-999') <> nvl(Recinfo.Closed_Reason,'-999') ) then
136: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Closed_Reason '||X_Closed_Reason ||' Database Closed_Reason '||Recinfo.Closed_Reason);
137: end if;
138: if (trunc(X_Closed_Date) <> trunc(Recinfo.Closed_Date) ) then
139: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Closed_Date '||X_Closed_Date ||' Database Closed_Date '||Recinfo.Closed_Date);
140: end if;
141: if (nvl(X_Transaction_Reason_Code,'-999') <> nvl(Recinfo.Transaction_Reason_Code,'-999') ) then
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Transaction_Reason_Code '||X_Transaction_Reason_Code ||' Database Transaction_Reason_Code '||Recinfo.Transaction_Reason_Code);
143: end if;

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

138: if (trunc(X_Closed_Date) <> trunc(Recinfo.Closed_Date) ) then
139: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Closed_Date '||X_Closed_Date ||' Database Closed_Date '||Recinfo.Closed_Date);
140: end if;
141: if (nvl(X_Transaction_Reason_Code,'-999') <> nvl(Recinfo.Transaction_Reason_Code,'-999') ) then
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Transaction_Reason_Code '||X_Transaction_Reason_Code ||' Database Transaction_Reason_Code '||Recinfo.Transaction_Reason_Code);
143: end if;
144: if (nvl(X_Quantity_Received, -999 ) <> nvl(Recinfo.Quantity_Received, -999 ) ) then
145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Quantity_Received '||X_Quantity_Received ||' Database Quantity_Received '||Recinfo.Quantity_Received);
146: end if;

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

141: if (nvl(X_Transaction_Reason_Code,'-999') <> nvl(Recinfo.Transaction_Reason_Code,'-999') ) then
142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Transaction_Reason_Code '||X_Transaction_Reason_Code ||' Database Transaction_Reason_Code '||Recinfo.Transaction_Reason_Code);
143: end if;
144: if (nvl(X_Quantity_Received, -999 ) <> nvl(Recinfo.Quantity_Received, -999 ) ) then
145: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form X_Quantity_Received '||X_Quantity_Received ||' Database Quantity_Received '||Recinfo.Quantity_Received);
146: end if;
147:
148:
149: END IF;