80:
81: BEGIN
82:
83: IF g_fnd_debug = 'Y' THEN
84: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
85: THEN
86: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
87: , G_MODULE_PREFIX || l_api_name || '.invoked'
88: , 'Entry');
82:
83: IF g_fnd_debug = 'Y' THEN
84: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
85: THEN
86: FND_LOG.string( FND_LOG.LEVEL_PROCEDURE
87: , G_MODULE_PREFIX || l_api_name || '.invoked'
88: , 'Entry');
89: END IF;
90: END IF;
102: WHERE person_id = p_agent_id
103: AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;
104:
105: IF g_fnd_debug = 'Y' THEN
106: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
107: THEN
108: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
109: , G_MODULE_PREFIX || l_api_name || '.invoked'
110: , 'Create workflow process');
104:
105: IF g_fnd_debug = 'Y' THEN
106: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
107: THEN
108: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
109: , G_MODULE_PREFIX || l_api_name || '.invoked'
110: , 'Create workflow process');
111: END IF;
112: END IF;
138: wf_engine.StartProcess(itemtype => l_item_type,
139: itemkey => l_item_key);
140:
141: IF g_fnd_debug = 'Y' THEN
142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
143: THEN
144: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
145: , G_MODULE_PREFIX || l_api_name || '.invoked'
146: , 'Retrieve Notification ID and Sent date');
140:
141: IF g_fnd_debug = 'Y' THEN
142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
143: THEN
144: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
145: , G_MODULE_PREFIX || l_api_name || '.invoked'
146: , 'Retrieve Notification ID and Sent date');
147: END IF;
148: END IF;
156: AND was.item_key = l_item_key
157: AND wfn.notification_id = was.notification_id;
158:
159: IF g_fnd_debug = 'Y' THEN
160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
161: THEN
162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
163: , G_MODULE_PREFIX || l_api_name || '.invoked'
164: , 'Exit');
158:
159: IF g_fnd_debug = 'Y' THEN
160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
161: THEN
162: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
163: , G_MODULE_PREFIX || l_api_name || '.invoked'
164: , 'Exit');
165: END IF;
166: END IF;
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171:
172: IF g_fnd_debug = 'Y' THEN
173: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
174: THEN
175: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
176: , G_MODULE_PREFIX || l_api_name || '.invoked'
177: , 'Unexpected exception for user name ' || p_user_name ||
171:
172: IF g_fnd_debug = 'Y' THEN
173: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
174: THEN
175: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
176: , G_MODULE_PREFIX || l_api_name || '.invoked'
177: , 'Unexpected exception for user name ' || p_user_name ||
178: ' agent_id ' || p_agent_id || ' language ' || p_lang_code);
179: END IF;
255:
256: SAVEPOINT Send_Notification_PUB;
257:
258: IF g_fnd_debug = 'Y' THEN
259: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
260: THEN
261: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
262: , G_MODULE_PREFIX || l_api_name || '.invoked'
263: , 'Entry');
257:
258: IF g_fnd_debug = 'Y' THEN
259: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
260: THEN
261: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
262: , G_MODULE_PREFIX || l_api_name || '.invoked'
263: , 'Entry');
264: END IF;
265: END IF;
319: , x_return_status => notif_status_tbl(i));
320:
321: ELSE
322: IF g_fnd_debug = 'Y' THEN
323: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
324: THEN
325: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
326: , G_MODULE_PREFIX || l_api_name || '.invoked'
327: , 'Preferred language for user ' || rec.user_name ||
321: ELSE
322: IF g_fnd_debug = 'Y' THEN
323: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
324: THEN
325: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
326: , G_MODULE_PREFIX || l_api_name || '.invoked'
327: , 'Preferred language for user ' || rec.user_name ||
328: ', user_id ' || rec.user_id || ' not found.');
329: END IF;
351:
352: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
353: , p_data => x_msg_data);
354: IF g_fnd_debug = 'Y' THEN
355: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
356: THEN
357: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
358: , G_MODULE_PREFIX || l_api_name || '.invoked'
359: , 'Exit');
353: , p_data => x_msg_data);
354: IF g_fnd_debug = 'Y' THEN
355: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
356: THEN
357: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
358: , G_MODULE_PREFIX || l_api_name || '.invoked'
359: , 'Exit');
360: END IF;
361: END IF;
369:
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371:
372: IF (g_fnd_debug = 'Y') THEN
373: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
374: THEN
375: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
376: , G_MODULE_PREFIX || l_api_name || '.others_exception'
377: , 'Exception');
371:
372: IF (g_fnd_debug = 'Y') THEN
373: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
374: THEN
375: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
376: , G_MODULE_PREFIX || l_api_name || '.others_exception'
377: , 'Exception');
378: END IF;
379: END IF;