DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PVT dependencies on FND_MSG_PUB

Line 2797: FND_MSG_PUB.ADD;

2793: WHEN OTHERS THEN
2794: ROLLBACK TO Do_On_Role_Assigned;
2795: FND_MESSAGE.SET_NAME( 'AMW', 'GENERIC_MESSAGE' );
2796: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2797: FND_MSG_PUB.ADD;
2798:
2799: WF_CORE.CONTEXT('AMW_VIOLATION_PVT','Do_On_Role_Assigned error', p_event.getEventName(), p_subscription_guid);
2800: WF_EVENT.setErrorInfo(p_event,'ERROR');
2801: RETURN 'ERROR';

Line 3327: FND_MSG_PUB.ADD;

3323: IF l_to_role_name IS NULL THEN
3324:
3325: x_return_status := FND_API.G_RET_STS_ERROR;
3326: FND_MESSAGE.set_name('AMW','AMW_APPR_INVALID_ROLE');
3327: FND_MSG_PUB.ADD;
3328: fnd_file.put_line(fnd_file.LOG, 'to_role is null');
3329: ELSE
3330:
3331: OPEN c_user_dynamic_sql FOR l_user_dynamic_sql USING

Line 3339: FND_MSG_PUB.add;

3335:
3336: FND_MESSAGE.set_name('AMW', 'AMW_VIOLAT_CONFIRM_NOTIF_SUBJ');
3337: FND_MESSAGE.set_token('CONSTRAINT_NAME', l_constraint_name, TRUE);
3338: FND_MESSAGE.set_token('USER_NAME', l_user_name, TRUE);
3339: FND_MSG_PUB.add;
3340: l_subject := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_LAST,
3341: p_encoded => fnd_api.g_false);
3342:
3343: l_notif_id := WF_NOTIFICATION.send(

Line 3340: l_subject := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_LAST,

3336: FND_MESSAGE.set_name('AMW', 'AMW_VIOLAT_CONFIRM_NOTIF_SUBJ');
3337: FND_MESSAGE.set_token('CONSTRAINT_NAME', l_constraint_name, TRUE);
3338: FND_MESSAGE.set_token('USER_NAME', l_user_name, TRUE);
3339: FND_MSG_PUB.add;
3340: l_subject := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.G_LAST,
3341: p_encoded => fnd_api.g_false);
3342:
3343: l_notif_id := WF_NOTIFICATION.send(
3344: role => l_to_role_name,