131: AND cii.location_type_code in ('INVENTORY','PO','IN_TRANSIT','WIP','PROJECT');
132:
133: IF SQL%FOUND THEN
134: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
135: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
136: END IF;
137:
138: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
139: l_error_message := fnd_message.get;
155: );
156:
157: IF SQL%FOUND THEN
158: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
159: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
160: END IF;
161:
162: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
163: l_error_message := fnd_message.get;
176: AND ciai.fa_asset_number IS NULL
177: );
178:
179: IF SQL%FOUND THEN
180: FND_File.Put_Line(Fnd_File.LOG, l_error_message ||' Total Rows in this error : '||SQL%ROWCOUNT);
181: END IF;
182:
183:
184:
205: ));
206:
207: IF SQL%FOUND THEN
208: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
209: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
210: END IF;
211:
212: END;
213:
2459: f := p_org_assign_tbl.count;
2460: g := p_txn_tbl.count;
2461:
2462: IF(l_debug_level>1) THEN
2463: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2464: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2465: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2466: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2467: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2460: g := p_txn_tbl.count;
2461:
2462: IF(l_debug_level>1) THEN
2463: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2464: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2465: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2466: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2467: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2468: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2461:
2462: IF(l_debug_level>1) THEN
2463: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2464: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2465: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2466: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2467: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2468: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2469: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2462: IF(l_debug_level>1) THEN
2463: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2464: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2465: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2466: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2467: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2468: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2469: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2470: END IF;
2463: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2464: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2465: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2466: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2467: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2468: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2469: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2470: END IF;
2471:
2464: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2465: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2466: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2467: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2468: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2469: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2470: END IF;
2471:
2472: IF inst_idx = 1 then
2465: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2466: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2467: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2468: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2469: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2470: END IF;
2471:
2472: IF inst_idx = 1 then
2473: RAISE no_data_found;
2648:
2649: a := p_relationship_tbl.count;
2650:
2651: IF(l_debug_level>1) THEN
2652: FND_File.Put_Line(Fnd_File.LOG,'Relationship Records: '||a);
2653: END IF;
2654:
2655: IF rel_idx = 1 then
2656: RAISE no_data_found;