168: eam_unavail_dtl.maint_org_id,
169: eam_unavail_dtl.op_seq
170: );
171:
172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Wip Entity Ids Inserted - '||eam_unavail_dtl.ORGANIZATION_CODE||'-'||eam_unavail_dtl.wip_entity_id);
173: END LOOP;
174:
175: IF i = 0 THEN
176: RAISE NO_ROWS;
179: EXCEPTION
180: WHEN NO_ROWS THEN
181: errbuf := sqlerrm;
182: FND_MESSAGE.SET_NAME('GMA','SY_NO_ROWS_SELECTED');
183: FND_FILE.PUT_LINE ( FND_FILE.LOG,'-'||FND_MESSAGE.GET);
184: /* Setting the Concurrent Status to Warning instead of giving Error */
185: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',NULL)) THEN
186: NULL;
187: END IF;
186: NULL;
187: END IF;
188: retcode := '3';
189: WHEN OTHERS THEN
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert Failed - Error Occured '||sqlerrm);
191:
192: END insert_man_unavail;
193:
194: END gmp_eam_downtime_pkg;