111: l_txn_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
112:
113: --bug#13072088
114: IF(l_debug_level>1) THEN
115: FND_File.Put_Line(Fnd_File.LOG,'Call to contract profile value : '||l_enable_contracts_oi);
116: END IF;
117: --bug#13072088
118:
119: BEGIN
139: AND cii.location_type_code in ('INVENTORY','PO','IN_TRANSIT','WIP','PROJECT');
140:
141: IF SQL%FOUND THEN
142: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
143: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
144: END IF;
145:
146: fnd_message.set_name('CSI','CSI_ML_NO_ASSET_FOR_CT');
147: l_error_message := fnd_message.get;
163: );
164:
165: IF SQL%FOUND THEN
166: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
167: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
168: END IF;
169:
170: fnd_message.set_name('CSI','CSI_NO_ASSET_ASSN_FOUND');
171: l_error_message := fnd_message.get;
184: AND ciai.fa_asset_number IS NULL
185: );
186:
187: IF SQL%FOUND THEN
188: FND_File.Put_Line(Fnd_File.LOG, l_error_message ||' Total Rows in this error : '||SQL%ROWCOUNT);
189: END IF;
190:
191:
192: /* Commented for bug 9924463
215: ));
216:
217: IF SQL%FOUND THEN
218: l_error_message := l_error_message||' Total Rows in this error : '||SQL%ROWCOUNT ;
219: FND_File.Put_Line(Fnd_File.LOG, l_error_message );
220: END IF;
221: */ --Commented for bug 9924463
222: END;
223:
2477: f := p_org_assign_tbl.count;
2478: g := p_txn_tbl.count;
2479:
2480: IF(l_debug_level>1) THEN
2481: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2482: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2483: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2484: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2485: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2478: g := p_txn_tbl.count;
2479:
2480: IF(l_debug_level>1) THEN
2481: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2482: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2483: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2484: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2485: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2486: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2479:
2480: IF(l_debug_level>1) THEN
2481: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2482: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2483: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2484: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2485: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2486: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2487: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2480: IF(l_debug_level>1) THEN
2481: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2482: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2483: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2484: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2485: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2486: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2487: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2488: END IF;
2481: FND_File.Put_Line(Fnd_File.LOG,'Inst Records: '||a);
2482: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2483: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2484: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2485: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2486: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2487: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2488: END IF;
2489:
2482: FND_File.Put_Line(Fnd_File.LOG,'Party Records: '||b);
2483: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2484: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2485: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2486: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2487: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2488: END IF;
2489:
2490: IF inst_idx = 1 then
2483: FND_File.Put_Line(Fnd_File.LOG,'Acct Records: '||c);
2484: FND_File.Put_Line(Fnd_File.LOG,'Price Records: '||e);
2485: FND_File.Put_Line(Fnd_File.LOG,'Ext Attr Records: '||d);
2486: FND_File.Put_Line(Fnd_File.LOG,'Org Assign Records: '||f);
2487: FND_File.Put_Line(Fnd_File.LOG,'Txn Records: '||g);
2488: END IF;
2489:
2490: IF inst_idx = 1 then
2491: RAISE no_data_found;
2666:
2667: a := p_relationship_tbl.count;
2668:
2669: IF(l_debug_level>1) THEN
2670: FND_File.Put_Line(Fnd_File.LOG,'Relationship Records: '||a);
2671: END IF;
2672:
2673: IF rel_idx = 1 then
2674: RAISE no_data_found;