55: l_territory VARCHAR2(250);
56:
57: BEGIN
58:
59: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
61: 'start send_notification');
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
63: 'parameters: p_request_id = ' || p_request_id ||
56:
57: BEGIN
58:
59: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
61: 'start send_notification');
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
63: 'parameters: p_request_id = ' || p_request_id ||
64: ', p_from_role = ' || p_from_role ||
58:
59: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
61: 'start send_notification');
62: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
63: 'parameters: p_request_id = ' || p_request_id ||
64: ', p_from_role = ' || p_from_role ||
65: ', p_to_email_address = ' || p_to_email_address ||
66: ', p_problem_summary = ' || p_problem_summary ||
146: wf_engine.startprocess('FUNCTUS',
147: p_request_id);
148:
149:
150: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
152: 'end send_notification');
153: end if;
154:
147: p_request_id);
148:
149:
150: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
152: 'end send_notification');
153: end if;
154:
155: END send_notification;
192: l_employee_id fnd_user.employee_id%TYPE;
193: l_customer_id fnd_user.customer_id%TYPE;
194: l_vendor_id fnd_user.supplier_id%TYPE;
195: BEGIN
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
198: 'start get_user_info');
199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
200: 'parameters: p_user_id = ' || p_user_id ||
193: l_customer_id fnd_user.customer_id%TYPE;
194: l_vendor_id fnd_user.supplier_id%TYPE;
195: BEGIN
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
198: 'start get_user_info');
199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
200: 'parameters: p_user_id = ' || p_user_id ||
201: ', p_full_name = ' || p_full_name ||
195: BEGIN
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
197: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
198: 'start get_user_info');
199: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
200: 'parameters: p_user_id = ' || p_user_id ||
201: ', p_full_name = ' || p_full_name ||
202: ', p_email_address = ' || p_email_address);
203: END IF;
259: p_email_address := l_email_address;
260: END IF;
261: p_return_status := G_RETURN_SUCCESS;
262:
263: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
265: 'end get_user_info');
266: END IF;
267:
260: END IF;
261: p_return_status := G_RETURN_SUCCESS;
262:
263: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,
265: 'end get_user_info');
266: END IF;
267:
268: EXCEPTION