[Home] [Help]
60: p_REVIEW_UPLD_TERMS_id IN NUMBER,
61: x_REVIEW_UPLD_TERMS_id OUT NOCOPY NUMBER
62: ) RETURN VARCHAR2 IS
63: CURSOR l_seq_csr IS
64: SELECT OKC_REVIEW_UPLD_TERMS_S1.NEXTVAL FROM DUAL;
65: BEGIN
66: IF (l_debug = 'Y') THEN
67: Okc_Debug.Log('100: Entered get_seq_id', 2);
68: END IF;
3259: FND_GLOBAL.LOGIN_ID,
3260: FND_GLOBAL.USER_ID,
3261: SYSDATE,
3262: FND_GLOBAL.USER_ID,
3263: SYSDATE from dual);
3264:
3265: END IF;
3266: CLOSE check_document_row_exists;
3267:
3678: variable_code
3679: )
3680: (select okc_review_messages_s1.nextval review_messages_id,
3681: var_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3682: 'W' error_severity,l_message_name ,1 object_version_number, var_csr.variable_code from dual
3683: where not exists (select 1 from okc_review_messages where review_upld_terms_id = var_csr.review_upld_terms_id
3684: and variable_code = var_csr.variable_code and message_name = l_message_name));
3685:
3686: end loop;
3713: variable_code
3714: )
3715: (select okc_review_messages_s1.nextval review_messages_id,
3716: valid_var_added_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3717: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_added_csr.variable_code from dual
3718: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id
3719: and variable_code = valid_var_added_csr.variable_code and message_name = l_message_name));
3720: end loop;
3721:
3742: variable_code
3743: )
3744: (select okc_review_messages_s1.nextval review_messages_id,
3745: valid_var_new_clause_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3746: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_new_clause_csr.variable_code from dual
3747: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_new_clause_csr.review_upld_terms_id
3748: and variable_code = valid_var_new_clause_csr.variable_code and message_name = l_message_name));
3749: end loop;
3750:
3771: variable_code
3772: )
3773: (select okc_review_messages_s1.nextval review_messages_id,
3774: valid_new_var_ibr_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3775: 'W' error_severity, l_message_name ,1 object_version_number, valid_new_var_ibr_csr.variable_code from dual
3776: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_new_var_ibr_csr.review_upld_terms_id
3777: and variable_code = valid_new_var_ibr_csr.variable_code and message_name = l_message_name));
3778: end loop;
3779:
3796: removed_var_csr.variable_name,
3797: removed_var_csr.language,
3798: removed_var_csr.variable_code,
3799: 1,
3800: 'D' from dual);
3801:
3802: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3803: -- and variable_code
3804: insert into okc_review_messages (
3810: variable_code
3811: )
3812: (select okc_review_messages_s1.nextval review_messages_id,
3813: removed_var_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3814: 'W' error_severity,'OKC_REVIEW_VAR_REMOVED' message_name ,1 object_version_number, removed_var_csr.variable_code from dual
3815: where not exists (select 1 from okc_review_messages where review_upld_terms_id = removed_var_csr.review_upld_terms_id
3816: and variable_code = removed_var_csr.variable_code and message_name = 'OKC_REVIEW_VAR_REMOVED'));
3817: end loop;
3818:
3834: variable_code
3835: )
3836: (select okc_review_messages_s1.nextval review_messages_id,
3837: invalid_var_added_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3838: 'W' error_severity, l_message_name ,1 object_version_number, invalid_var_added_csr.variable_code from dual
3839: where not exists (select 1 from okc_review_messages where review_upld_terms_id = invalid_var_added_csr.review_upld_terms_id
3840: and variable_code = invalid_var_added_csr.variable_code and message_name = l_message_name));
3841: end loop;
3842:
3911:
3912: )
3913: (select okc_review_messages_s1.nextval review_messages_id,
3914: ibr_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3915: 'W' error_severity,'OKC_ARTICLE_UPDT_IBR' message_name ,1 object_version_number from dual);
3916: end loop;
3917:
3918: for mandatory_csr in is_article_mandatory(l_user_access) loop
3919: insert into okc_review_messages (
3925:
3926: )
3927: (select okc_review_messages_s1.nextval review_messages_id,
3928: mandatory_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3929: 'W' error_severity,'OKC_ARTICLE_IS_MANDATORY' message_name ,1 object_version_number from dual);
3930: end loop;
3931:
3932: for lock_csr in is_article_text_locked(l_user_access) loop
3933: insert into okc_review_messages (
3939:
3940: )
3941: (select okc_review_messages_s1.nextval review_messages_id,
3942: lock_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3943: 'W' error_severity,'OKC_ARTICLE_UPDT_LOCK' message_name ,1 object_version_number from dual);
3944: end loop;
3945:
3946: l_message_name := 'OKC_UPLOAD_CLAUSE_TITLE_LONG';
3947: for title_csr in check_sec_clause_title loop
3960:
3961: )
3962: (select okc_review_messages_s1.nextval review_messages_id,
3963: title_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3964: 'W' error_severity, l_message_name,1 object_version_number from dual);
3965:
3966: end loop;
3967: for upd_csr in update_err_warn_csr loop
3968: if (upd_csr.error_severity = 'E') then
4219: FND_GLOBAL.USER_ID,
4220: SYSDATE,
4221: FND_GLOBAL.USER_ID,
4222: SYSDATE
4223: FROM dual);
4224:
4225: --------------------------------------------
4226: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;