7089: x_return_status := 'E';
7090: end if;
7091: close c_get_owner;
7092:
7093: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
7094: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
7095: fnd_message.set_token('NEXT_OWNER', l_owner_name);
7096: fnd_message.set_token('COMMENT', p_owner_comment);
7097: l_comment_text := fnd_message.get;
7090: end if;
7091: close c_get_owner;
7092:
7093: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
7094: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
7095: fnd_message.set_token('NEXT_OWNER', l_owner_name);
7096: fnd_message.set_token('COMMENT', p_owner_comment);
7097: l_comment_text := fnd_message.get;
7098:
7091: close c_get_owner;
7092:
7093: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
7094: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
7095: fnd_message.set_token('NEXT_OWNER', l_owner_name);
7096: fnd_message.set_token('COMMENT', p_owner_comment);
7097: l_comment_text := fnd_message.get;
7098:
7099: pa_ci_comments_pkg.insert_row(
7092:
7093: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
7094: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
7095: fnd_message.set_token('NEXT_OWNER', l_owner_name);
7096: fnd_message.set_token('COMMENT', p_owner_comment);
7097: l_comment_text := fnd_message.get;
7098:
7099: pa_ci_comments_pkg.insert_row(
7100: p_ci_comment_id => l_ci_comment_id,
7093: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
7094: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
7095: fnd_message.set_token('NEXT_OWNER', l_owner_name);
7096: fnd_message.set_token('COMMENT', p_owner_comment);
7097: l_comment_text := fnd_message.get;
7098:
7099: pa_ci_comments_pkg.insert_row(
7100: p_ci_comment_id => l_ci_comment_id,
7101: p_ci_id => p_ci_id,
8338: x_return_status := 'E';
8339: end if;
8340: close c_get_owner;
8341:
8342: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
8343: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
8344: fnd_message.set_token('NEXT_OWNER', l_owner_name);
8345: fnd_message.set_token('COMMENT', p_owner_comment);
8346: l_comment_text := fnd_message.get;
8339: end if;
8340: close c_get_owner;
8341:
8342: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
8343: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
8344: fnd_message.set_token('NEXT_OWNER', l_owner_name);
8345: fnd_message.set_token('COMMENT', p_owner_comment);
8346: l_comment_text := fnd_message.get;
8347:
8340: close c_get_owner;
8341:
8342: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
8343: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
8344: fnd_message.set_token('NEXT_OWNER', l_owner_name);
8345: fnd_message.set_token('COMMENT', p_owner_comment);
8346: l_comment_text := fnd_message.get;
8347:
8348: pa_ci_comments_pkg.insert_row(
8341:
8342: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
8343: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
8344: fnd_message.set_token('NEXT_OWNER', l_owner_name);
8345: fnd_message.set_token('COMMENT', p_owner_comment);
8346: l_comment_text := fnd_message.get;
8347:
8348: pa_ci_comments_pkg.insert_row(
8349: p_ci_comment_id => l_ci_comment_id,
8342: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
8343: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
8344: fnd_message.set_token('NEXT_OWNER', l_owner_name);
8345: fnd_message.set_token('COMMENT', p_owner_comment);
8346: l_comment_text := fnd_message.get;
8347:
8348: pa_ci_comments_pkg.insert_row(
8349: p_ci_comment_id => l_ci_comment_id,
8350: p_ci_id => p_ci_id,
9595: x_return_status := 'E';
9596: end if;
9597: close c_get_owner;
9598:
9599: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
9600: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
9601: fnd_message.set_token('NEXT_OWNER', l_owner_name);
9602: fnd_message.set_token('COMMENT', p_owner_comment);
9603: l_comment_text := fnd_message.get;
9596: end if;
9597: close c_get_owner;
9598:
9599: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
9600: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
9601: fnd_message.set_token('NEXT_OWNER', l_owner_name);
9602: fnd_message.set_token('COMMENT', p_owner_comment);
9603: l_comment_text := fnd_message.get;
9604:
9597: close c_get_owner;
9598:
9599: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
9600: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
9601: fnd_message.set_token('NEXT_OWNER', l_owner_name);
9602: fnd_message.set_token('COMMENT', p_owner_comment);
9603: l_comment_text := fnd_message.get;
9604:
9605: pa_ci_comments_pkg.insert_row(
9598:
9599: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
9600: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
9601: fnd_message.set_token('NEXT_OWNER', l_owner_name);
9602: fnd_message.set_token('COMMENT', p_owner_comment);
9603: l_comment_text := fnd_message.get;
9604:
9605: pa_ci_comments_pkg.insert_row(
9606: p_ci_comment_id => l_ci_comment_id,
9599: fnd_message.set_name('PA', 'PA_CI_LOG_OWNER_CHANGE');
9600: fnd_message.set_token('PREV_OWNER', l_curr_owner_name);
9601: fnd_message.set_token('NEXT_OWNER', l_owner_name);
9602: fnd_message.set_token('COMMENT', p_owner_comment);
9603: l_comment_text := fnd_message.get;
9604:
9605: pa_ci_comments_pkg.insert_row(
9606: p_ci_comment_id => l_ci_comment_id,
9607: p_ci_id => p_ci_id,