10: IS
11: BEGIN
12: IF l_debug = 'Y' THEN
13: cse_debug_pub.add(p_message);
14: IF nvl(fnd_global.conc_request_id, -1) <> -1 THEN
15: fnd_file.put_line(fnd_file.log,p_message);
16: END IF;
17: END IF;
18: EXCEPTION
182: X_FEEDER_SYSTEM_NAME => l_feeder_system_name,
183: X_STATUS_CODE => 'NEW',
184: X_FA_BOOK_TYPE_CODE => p_asset_hdr_rec.book_type_code,
185: X_CREATION_DATE => sysdate,
186: X_CREATED_BY => fnd_global.user_id,
187: X_LAST_UPDATE_DATE => sysdate,
188: X_LAST_UPDATED_BY => fnd_global.user_id,
189: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
190:
184: X_FA_BOOK_TYPE_CODE => p_asset_hdr_rec.book_type_code,
185: X_CREATION_DATE => sysdate,
186: X_CREATED_BY => fnd_global.user_id,
187: X_LAST_UPDATE_DATE => sysdate,
188: X_LAST_UPDATED_BY => fnd_global.user_id,
189: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
190:
191: EXCEPTION
192: WHEN no_data_found THEN
185: X_CREATION_DATE => sysdate,
186: X_CREATED_BY => fnd_global.user_id,
187: X_LAST_UPDATE_DATE => sysdate,
188: X_LAST_UPDATED_BY => fnd_global.user_id,
189: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
190:
191: EXCEPTION
192: WHEN no_data_found THEN
193: null;
219: X_ERROR_FLAG => 'N',
220: X_ERROR_TEXT => null,
221: X_TRANSACTION_SOURCE_TYPE => p_trans_rec.transaction_type_code,
222: X_CREATION_DATE => sysdate,
223: X_CREATED_BY => fnd_global.user_id,
224: X_LAST_UPDATE_DATE => sysdate,
225: X_LAST_UPDATED_BY => fnd_global.user_id,
226: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
227:
221: X_TRANSACTION_SOURCE_TYPE => p_trans_rec.transaction_type_code,
222: X_CREATION_DATE => sysdate,
223: X_CREATED_BY => fnd_global.user_id,
224: X_LAST_UPDATE_DATE => sysdate,
225: X_LAST_UPDATED_BY => fnd_global.user_id,
226: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
227:
228: END LOOP; -- asset_dist_tbl loop
229:
222: X_CREATION_DATE => sysdate,
223: X_CREATED_BY => fnd_global.user_id,
224: X_LAST_UPDATE_DATE => sysdate,
225: X_LAST_UPDATED_BY => fnd_global.user_id,
226: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
227:
228: END LOOP; -- asset_dist_tbl loop
229:
230: END IF; -- p_asset_dist_tbl.count > 0
513: BEGIN
514:
515: report_output;
516:
517: l_request_id := fnd_global.conc_request_id;
518:
519: send_mail(l_request_id);
520:
521: END notify_users;