[Home] [Help]
99: ---------------------------------------------------------------
100: PROCEDURE set_proc_error_message (p_proc IN VARCHAR2)
101: IS
102: BEGIN
103: okc_api.set_message (p_app_name => g_app_name,
104: p_msg_name => 'OKC_I_ERROR_PROCEDURE',
105: p_token1 => 'PROCEDURE',
106: p_token1_value => p_proc
107: );
109:
110: PROCEDURE set_rec_num_message (p_rec_num IN NUMBER)
111: IS
112: BEGIN
113: okc_api.set_message (p_app_name => g_app_name,
114: p_msg_name => 'OKC_I_RECORD_NUM',
115: p_token1 => 'RECORD_NUM',
116: p_token1_value => p_rec_num
117: );
717: FROM okc_allowed_tmpl_usages
718: WHERE template_id = p_template_id
719: AND allowed_tmpl_usages_id = p_tmpl_usage_rec.allowed_tmpl_usages_id;
720:
721: IF (p_tmpl_usage_rec.object_version_number = okc_api.g_miss_num)
722: THEN
723: p_tmpl_usage_rec.object_version_number :=
724: l_db_rec.object_version_number;
725: END IF;
725: END IF;
726:
727: IF p_mode = 'UPDATE'
728: THEN
729: IF (p_tmpl_usage_rec.document_type = okc_api.g_miss_char)
730: THEN
731: p_tmpl_usage_rec.document_type := l_db_rec.document_type;
732: END IF;
733:
730: THEN
731: p_tmpl_usage_rec.document_type := l_db_rec.document_type;
732: END IF;
733:
734: IF p_tmpl_usage_rec.default_yn = okc_api.g_miss_char
735: THEN
736: p_tmpl_usage_rec.default_yn := l_db_rec.default_yn;
737: END IF;
738:
735: THEN
736: p_tmpl_usage_rec.default_yn := l_db_rec.default_yn;
737: END IF;
738:
739: IF p_tmpl_usage_rec.attribute_category = okc_api.g_miss_char
740: THEN
741: p_tmpl_usage_rec.attribute_category :=
742: l_db_rec.attribute_category;
743: END IF;
741: p_tmpl_usage_rec.attribute_category :=
742: l_db_rec.attribute_category;
743: END IF;
744:
745: IF p_tmpl_usage_rec.attribute1 = okc_api.g_miss_char
746: THEN
747: p_tmpl_usage_rec.attribute1 := l_db_rec.attribute1;
748: END IF;
749:
746: THEN
747: p_tmpl_usage_rec.attribute1 := l_db_rec.attribute1;
748: END IF;
749:
750: IF p_tmpl_usage_rec.attribute2 = okc_api.g_miss_char
751: THEN
752: p_tmpl_usage_rec.attribute2 := l_db_rec.attribute2;
753: END IF;
754:
751: THEN
752: p_tmpl_usage_rec.attribute2 := l_db_rec.attribute2;
753: END IF;
754:
755: IF p_tmpl_usage_rec.attribute3 = okc_api.g_miss_char
756: THEN
757: p_tmpl_usage_rec.attribute3 := l_db_rec.attribute3;
758: END IF;
759:
756: THEN
757: p_tmpl_usage_rec.attribute3 := l_db_rec.attribute3;
758: END IF;
759:
760: IF p_tmpl_usage_rec.attribute4 = okc_api.g_miss_char
761: THEN
762: p_tmpl_usage_rec.attribute4 := l_db_rec.attribute4;
763: END IF;
764:
761: THEN
762: p_tmpl_usage_rec.attribute4 := l_db_rec.attribute4;
763: END IF;
764:
765: IF p_tmpl_usage_rec.attribute5 = okc_api.g_miss_char
766: THEN
767: p_tmpl_usage_rec.attribute5 := l_db_rec.attribute5;
768: END IF;
769:
766: THEN
767: p_tmpl_usage_rec.attribute5 := l_db_rec.attribute5;
768: END IF;
769:
770: IF p_tmpl_usage_rec.attribute6 = okc_api.g_miss_char
771: THEN
772: p_tmpl_usage_rec.attribute6 := l_db_rec.attribute6;
773: END IF;
774:
771: THEN
772: p_tmpl_usage_rec.attribute6 := l_db_rec.attribute6;
773: END IF;
774:
775: IF p_tmpl_usage_rec.attribute7 = okc_api.g_miss_char
776: THEN
777: p_tmpl_usage_rec.attribute7 := l_db_rec.attribute7;
778: END IF;
779:
776: THEN
777: p_tmpl_usage_rec.attribute7 := l_db_rec.attribute7;
778: END IF;
779:
780: IF p_tmpl_usage_rec.attribute8 = okc_api.g_miss_char
781: THEN
782: p_tmpl_usage_rec.attribute8 := l_db_rec.attribute8;
783: END IF;
784:
781: THEN
782: p_tmpl_usage_rec.attribute8 := l_db_rec.attribute8;
783: END IF;
784:
785: IF p_tmpl_usage_rec.attribute9 = okc_api.g_miss_char
786: THEN
787: p_tmpl_usage_rec.attribute9 := l_db_rec.attribute9;
788: END IF;
789:
786: THEN
787: p_tmpl_usage_rec.attribute9 := l_db_rec.attribute9;
788: END IF;
789:
790: IF p_tmpl_usage_rec.attribute10 = okc_api.g_miss_char
791: THEN
792: p_tmpl_usage_rec.attribute10 := l_db_rec.attribute10;
793: END IF;
794:
791: THEN
792: p_tmpl_usage_rec.attribute10 := l_db_rec.attribute10;
793: END IF;
794:
795: IF p_tmpl_usage_rec.attribute11 = okc_api.g_miss_char
796: THEN
797: p_tmpl_usage_rec.attribute11 := l_db_rec.attribute11;
798: END IF;
799:
796: THEN
797: p_tmpl_usage_rec.attribute11 := l_db_rec.attribute11;
798: END IF;
799:
800: IF p_tmpl_usage_rec.attribute12 = okc_api.g_miss_char
801: THEN
802: p_tmpl_usage_rec.attribute12 := l_db_rec.attribute12;
803: END IF;
804:
801: THEN
802: p_tmpl_usage_rec.attribute12 := l_db_rec.attribute12;
803: END IF;
804:
805: IF p_tmpl_usage_rec.attribute13 = okc_api.g_miss_char
806: THEN
807: p_tmpl_usage_rec.attribute13 := l_db_rec.attribute13;
808: END IF;
809:
806: THEN
807: p_tmpl_usage_rec.attribute13 := l_db_rec.attribute13;
808: END IF;
809:
810: IF p_tmpl_usage_rec.attribute14 = okc_api.g_miss_char
811: THEN
812: p_tmpl_usage_rec.attribute14 := l_db_rec.attribute14;
813: END IF;
814:
811: THEN
812: p_tmpl_usage_rec.attribute14 := l_db_rec.attribute14;
813: END IF;
814:
815: IF p_tmpl_usage_rec.attribute15 = okc_api.g_miss_char
816: THEN
817: p_tmpl_usage_rec.attribute15 := l_db_rec.attribute15;
818: END IF;
819: END IF;
848: BEGIN
849: -- Validate the required fields
850: IF p_template_rec.template_name IS NULL
851: THEN
852: okc_api.set_message (p_app_name => g_app_name,
853: p_msg_name => 'OKC_I_NOT_NULL',
854: p_token1 => 'FIELD',
855: p_token1_value => 'TEMPLATE_NAME'
856: );
858: END IF;
859:
860: IF p_template_rec.intent IS NULL
861: THEN
862: okc_api.set_message (p_app_name => g_app_name,
863: p_msg_name => 'OKC_I_NOT_NULL',
864: p_token1 => 'FIELD',
865: p_token1_value => 'INTENT'
866: );
869:
870: IF p_template_rec.contract_expert_enabled = 'Y'
871: AND p_template_rec.xprt_scn_code IS NULL
872: THEN
873: okc_api.set_message (p_app_name => g_app_name,
874: p_msg_name => 'OKC_I_NOT_NULL',
875: p_token1 => 'FIELD',
876: p_token1_value => 'XPRT_SCN_CODE'
877: );
880:
881: IF p_template_rec.contract_expert_enabled IS NULL
882: AND p_template_rec.xprt_scn_code IS NOT NULL
883: THEN
884: okc_api.set_message (p_app_name => g_app_name,
885: p_msg_name => 'OKC_I_NOT_NULL',
886: p_token1 => 'FIELD',
887: p_token1_value => 'CONTRACT_EXPERT_ENABLED'
888: );
891:
892: -- Validate the input attributes
893: IF p_template_rec.intent NOT IN ('B', 'S')
894: THEN
895: okc_api.set_message (p_app_name => g_app_name,
896: p_msg_name => 'OKC_I_INVALID_VALUE',
897: p_token1 => 'FIELD',
898: p_token1_value => 'INTENT'
899: );
913: CLOSE cur_val_lookup;
914:
915: IF NVL (l_val_lookup, 'X') <> 'Y'
916: THEN
917: okc_api.set_message (p_app_name => g_app_name,
918: p_msg_name => 'OKC_I_INVALID_VALUE',
919: p_token1 => 'FIELD',
920: p_token1_value => 'XPRT_SCN_CODE'
921: );
931: IF p_template_rec.global_flag = 'Y'
932: THEN
933: IF p_template_rec.org_id <> fnd_profile.VALUE ('OKC_GLOBAL_ORG_ID')
934: THEN
935: okc_api.set_message (p_app_name => g_app_name,
936: p_msg_name => 'OKC_I_INVALID_VALUE',
937: p_token1 => 'FIELD',
938: p_token1_value => 'GLOBAL_ORG_ID'
939: );
964: p_template_rec IN OUT NOCOPY terms_template_rec_type
965: )
966: IS
967: BEGIN
968: IF p_template_rec.template_id = okc_api.g_miss_num
969: THEN
970: p_template_rec.template_id := NULL;
971: END IF;
972:
969: THEN
970: p_template_rec.template_id := NULL;
971: END IF;
972:
973: IF p_template_rec.template_name = okc_api.g_miss_char
974: THEN
975: p_template_rec.template_name := NULL;
976: END IF;
977:
974: THEN
975: p_template_rec.template_name := NULL;
976: END IF;
977:
978: IF p_template_rec.intent = okc_api.g_miss_char
979: THEN
980: p_template_rec.intent := NULL;
981: END IF;
982:
979: THEN
980: p_template_rec.intent := NULL;
981: END IF;
982:
983: -- IF p_template_rec.status_code = okc_api.g_miss_char
984: -- THEN
985: p_template_rec.status_code := 'DRAFT';
986:
987: -- END IF;
984: -- THEN
985: p_template_rec.status_code := 'DRAFT';
986:
987: -- END IF;
988: IF p_template_rec.start_date = okc_api.g_miss_date
989: THEN
990: p_template_rec.start_date := SYSDATE;
991: END IF;
992:
989: THEN
990: p_template_rec.start_date := SYSDATE;
991: END IF;
992:
993: IF p_template_rec.end_date = okc_api.g_miss_date
994: THEN
995: p_template_rec.end_date := NULL;
996: END IF;
997:
994: THEN
995: p_template_rec.end_date := NULL;
996: END IF;
997:
998: IF p_template_rec.global_flag = okc_api.g_miss_char
999: THEN
1000: p_template_rec.global_flag := 'N';
1001: END IF;
1002:
999: THEN
1000: p_template_rec.global_flag := 'N';
1001: END IF;
1002:
1003: IF p_template_rec.instruction_text = okc_api.g_miss_char
1004: THEN
1005: p_template_rec.instruction_text := NULL;
1006: END IF;
1007:
1004: THEN
1005: p_template_rec.instruction_text := NULL;
1006: END IF;
1007:
1008: IF p_template_rec.description = okc_api.g_miss_char
1009: THEN
1010: p_template_rec.description := NULL;
1011: END IF;
1012:
1009: THEN
1010: p_template_rec.description := NULL;
1011: END IF;
1012:
1013: IF p_template_rec.working_copy_flag = okc_api.g_miss_char
1014: THEN
1015: p_template_rec.working_copy_flag := 'N';
1016: END IF;
1017:
1014: THEN
1015: p_template_rec.working_copy_flag := 'N';
1016: END IF;
1017:
1018: IF p_template_rec.parent_template_id = okc_api.g_miss_num
1019: THEN
1020: p_template_rec.parent_template_id := NULL;
1021: END IF;
1022:
1019: THEN
1020: p_template_rec.parent_template_id := NULL;
1021: END IF;
1022:
1023: IF p_template_rec.contract_expert_enabled = okc_api.g_miss_char
1024: THEN
1025: p_template_rec.contract_expert_enabled := 'N';
1026: END IF;
1027:
1024: THEN
1025: p_template_rec.contract_expert_enabled := 'N';
1026: END IF;
1027:
1028: IF p_template_rec.template_model_id = okc_api.g_miss_num
1029: THEN
1030: p_template_rec.template_model_id := NULL;
1031: END IF;
1032:
1029: THEN
1030: p_template_rec.template_model_id := NULL;
1031: END IF;
1032:
1033: IF p_template_rec.tmpl_numbering_scheme = okc_api.g_miss_num
1034: THEN
1035: p_template_rec.tmpl_numbering_scheme := NULL;
1036: END IF;
1037:
1034: THEN
1035: p_template_rec.tmpl_numbering_scheme := NULL;
1036: END IF;
1037:
1038: IF p_template_rec.print_template_id = okc_api.g_miss_num
1039: THEN
1040: p_template_rec.print_template_id := NULL;
1041: END IF;
1042:
1039: THEN
1040: p_template_rec.print_template_id := NULL;
1041: END IF;
1042:
1043: IF p_template_rec.approval_wf_key = okc_api.g_miss_char
1044: THEN
1045: p_template_rec.approval_wf_key := NULL;
1046: END IF;
1047:
1044: THEN
1045: p_template_rec.approval_wf_key := NULL;
1046: END IF;
1047:
1048: IF p_template_rec.cz_export_wf_key = okc_api.g_miss_char
1049: THEN
1050: p_template_rec.cz_export_wf_key := NULL;
1051: END IF;
1052:
1049: THEN
1050: p_template_rec.cz_export_wf_key := NULL;
1051: END IF;
1052:
1053: IF p_template_rec.org_id = okc_api.g_miss_num
1054: THEN
1055: p_template_rec.org_id := mo_utils.get_default_org_id;
1056: END IF;
1057:
1054: THEN
1055: p_template_rec.org_id := mo_utils.get_default_org_id;
1056: END IF;
1057:
1058: IF p_template_rec.orig_system_reference_code = okc_api.g_miss_char
1059: THEN
1060: p_template_rec.orig_system_reference_code := NULL;
1061: END IF;
1062:
1059: THEN
1060: p_template_rec.orig_system_reference_code := NULL;
1061: END IF;
1062:
1063: IF p_template_rec.orig_system_reference_id1 = okc_api.g_miss_num
1064: THEN
1065: p_template_rec.orig_system_reference_id1 := NULL;
1066: END IF;
1067:
1064: THEN
1065: p_template_rec.orig_system_reference_id1 := NULL;
1066: END IF;
1067:
1068: IF p_template_rec.orig_system_reference_id2 = okc_api.g_miss_num
1069: THEN
1070: p_template_rec.orig_system_reference_id2 := NULL;
1071: END IF;
1072:
1069: THEN
1070: p_template_rec.orig_system_reference_id2 := NULL;
1071: END IF;
1072:
1073: IF p_template_rec.object_version_number = okc_api.g_miss_num
1074: THEN
1075: p_template_rec.object_version_number := 1;
1076: END IF;
1077:
1074: THEN
1075: p_template_rec.object_version_number := 1;
1076: END IF;
1077:
1078: IF p_template_rec.hide_yn = okc_api.g_miss_char
1079: THEN
1080: p_template_rec.hide_yn := NULL;
1081: END IF;
1082:
1079: THEN
1080: p_template_rec.hide_yn := NULL;
1081: END IF;
1082:
1083: IF p_template_rec.attribute_category = okc_api.g_miss_char
1084: THEN
1085: p_template_rec.attribute_category := NULL;
1086: END IF;
1087:
1084: THEN
1085: p_template_rec.attribute_category := NULL;
1086: END IF;
1087:
1088: IF p_template_rec.attribute1 = okc_api.g_miss_char
1089: THEN
1090: p_template_rec.attribute1 := NULL;
1091: END IF;
1092:
1089: THEN
1090: p_template_rec.attribute1 := NULL;
1091: END IF;
1092:
1093: IF p_template_rec.attribute2 = okc_api.g_miss_char
1094: THEN
1095: p_template_rec.attribute2 := NULL;
1096: END IF;
1097:
1094: THEN
1095: p_template_rec.attribute2 := NULL;
1096: END IF;
1097:
1098: IF p_template_rec.attribute3 = okc_api.g_miss_char
1099: THEN
1100: p_template_rec.attribute3 := NULL;
1101: END IF;
1102:
1099: THEN
1100: p_template_rec.attribute3 := NULL;
1101: END IF;
1102:
1103: IF p_template_rec.attribute4 = okc_api.g_miss_char
1104: THEN
1105: p_template_rec.attribute4 := NULL;
1106: END IF;
1107:
1104: THEN
1105: p_template_rec.attribute4 := NULL;
1106: END IF;
1107:
1108: IF p_template_rec.attribute5 = okc_api.g_miss_char
1109: THEN
1110: p_template_rec.attribute5 := NULL;
1111: END IF;
1112:
1109: THEN
1110: p_template_rec.attribute5 := NULL;
1111: END IF;
1112:
1113: IF p_template_rec.attribute6 = okc_api.g_miss_char
1114: THEN
1115: p_template_rec.attribute6 := NULL;
1116: END IF;
1117:
1114: THEN
1115: p_template_rec.attribute6 := NULL;
1116: END IF;
1117:
1118: IF p_template_rec.attribute7 = okc_api.g_miss_char
1119: THEN
1120: p_template_rec.attribute7 := NULL;
1121: END IF;
1122:
1119: THEN
1120: p_template_rec.attribute7 := NULL;
1121: END IF;
1122:
1123: IF p_template_rec.attribute8 = okc_api.g_miss_char
1124: THEN
1125: p_template_rec.attribute8 := NULL;
1126: END IF;
1127:
1124: THEN
1125: p_template_rec.attribute8 := NULL;
1126: END IF;
1127:
1128: IF p_template_rec.attribute9 = okc_api.g_miss_char
1129: THEN
1130: p_template_rec.attribute9 := NULL;
1131: END IF;
1132:
1129: THEN
1130: p_template_rec.attribute9 := NULL;
1131: END IF;
1132:
1133: IF p_template_rec.attribute10 = okc_api.g_miss_char
1134: THEN
1135: p_template_rec.attribute10 := NULL;
1136: END IF;
1137:
1134: THEN
1135: p_template_rec.attribute10 := NULL;
1136: END IF;
1137:
1138: IF p_template_rec.attribute11 = okc_api.g_miss_char
1139: THEN
1140: p_template_rec.attribute11 := NULL;
1141: END IF;
1142:
1139: THEN
1140: p_template_rec.attribute11 := NULL;
1141: END IF;
1142:
1143: IF p_template_rec.attribute12 = okc_api.g_miss_char
1144: THEN
1145: p_template_rec.attribute12 := NULL;
1146: END IF;
1147:
1144: THEN
1145: p_template_rec.attribute12 := NULL;
1146: END IF;
1147:
1148: IF p_template_rec.attribute13 = okc_api.g_miss_char
1149: THEN
1150: p_template_rec.attribute13 := NULL;
1151: END IF;
1152:
1149: THEN
1150: p_template_rec.attribute13 := NULL;
1151: END IF;
1152:
1153: IF p_template_rec.attribute14 = okc_api.g_miss_char
1154: THEN
1155: p_template_rec.attribute14 := NULL;
1156: END IF;
1157:
1154: THEN
1155: p_template_rec.attribute14 := NULL;
1156: END IF;
1157:
1158: IF p_template_rec.attribute15 = okc_api.g_miss_char
1159: THEN
1160: p_template_rec.attribute15 := NULL;
1161: END IF;
1162:
1159: THEN
1160: p_template_rec.attribute15 := NULL;
1161: END IF;
1162:
1163: IF p_template_rec.xprt_request_id = okc_api.g_miss_num
1164: THEN
1165: p_template_rec.xprt_request_id := NULL;
1166: END IF;
1167:
1164: THEN
1165: p_template_rec.xprt_request_id := NULL;
1166: END IF;
1167:
1168: IF p_template_rec.xprt_clause_mandatory_flag = okc_api.g_miss_char
1169: THEN
1170: p_template_rec.xprt_clause_mandatory_flag := 'N';
1171: END IF;
1172:
1169: THEN
1170: p_template_rec.xprt_clause_mandatory_flag := 'N';
1171: END IF;
1172:
1173: IF p_template_rec.xprt_scn_code = okc_api.g_miss_char
1174: THEN
1175: p_template_rec.xprt_scn_code := NULL;
1176: END IF;
1177:
1174: THEN
1175: p_template_rec.xprt_scn_code := NULL;
1176: END IF;
1177:
1178: IF p_template_rec.LANGUAGE = okc_api.g_miss_char
1179: THEN
1180: p_template_rec.LANGUAGE := NULL;
1181: END IF;
1182:
1179: THEN
1180: p_template_rec.LANGUAGE := NULL;
1181: END IF;
1182:
1183: IF p_template_rec.translated_from_tmpl_id = okc_api.g_miss_num
1184: THEN
1185: p_template_rec.translated_from_tmpl_id := NULL;
1186: END IF;
1187: END default_template;
1194: IF p_template_rec.org_id IS NOT NULL
1195: THEN
1196: IF isvalidou (p_org_id => p_template_rec.org_id) <> 'Y'
1197: THEN
1198: okc_api.set_message (p_app_name => g_app_name,
1199: p_msg_name => 'OKC_I_INVALID_VALUE',
1200: p_token1 => 'FIELD',
1201: p_token1_value => 'ORG_ID'
1202: );
1205:
1206: -- Set Policy context
1207: mo_global.set_policy_context ('S', TO_CHAR (p_template_rec.org_id));
1208: ELSE
1209: okc_api.set_message (p_app_name => g_app_name,
1210: p_msg_name => 'OKC_I_NOT_NULL',
1211: p_token1 => 'FIELD',
1212: p_token1_value => 'ORG_ID'
1213: );
1323: p_template_db_rec IN okc_terms_templates_all%ROWTYPE
1324: )
1325: IS
1326: BEGIN
1327: IF p_template_rec.template_id = okc_api.g_miss_num
1328: THEN
1329: p_template_rec.template_id := p_template_db_rec.template_id;
1330: END IF;
1331:
1328: THEN
1329: p_template_rec.template_id := p_template_db_rec.template_id;
1330: END IF;
1331:
1332: IF p_template_rec.template_name = okc_api.g_miss_char
1333: THEN
1334: p_template_rec.template_name := p_template_db_rec.template_name;
1335: END IF;
1336:
1333: THEN
1334: p_template_rec.template_name := p_template_db_rec.template_name;
1335: END IF;
1336:
1337: IF p_template_rec.intent = okc_api.g_miss_char
1338: THEN
1339: p_template_rec.intent := p_template_db_rec.intent;
1340: END IF;
1341:
1338: THEN
1339: p_template_rec.intent := p_template_db_rec.intent;
1340: END IF;
1341:
1342: IF p_template_rec.status_code = okc_api.g_miss_char
1343: THEN
1344: p_template_rec.status_code := p_template_db_rec.status_code;
1345: END IF;
1346:
1343: THEN
1344: p_template_rec.status_code := p_template_db_rec.status_code;
1345: END IF;
1346:
1347: IF p_template_rec.start_date = okc_api.g_miss_date
1348: THEN
1349: p_template_rec.start_date := p_template_db_rec.start_date;
1350: END IF;
1351:
1348: THEN
1349: p_template_rec.start_date := p_template_db_rec.start_date;
1350: END IF;
1351:
1352: IF p_template_rec.end_date = okc_api.g_miss_date
1353: THEN
1354: p_template_rec.end_date := p_template_db_rec.end_date;
1355: END IF;
1356:
1353: THEN
1354: p_template_rec.end_date := p_template_db_rec.end_date;
1355: END IF;
1356:
1357: IF p_template_rec.global_flag = okc_api.g_miss_char
1358: THEN
1359: p_template_rec.global_flag := p_template_db_rec.global_flag;
1360: END IF;
1361:
1358: THEN
1359: p_template_rec.global_flag := p_template_db_rec.global_flag;
1360: END IF;
1361:
1362: IF p_template_rec.instruction_text = okc_api.g_miss_char
1363: THEN
1364: p_template_rec.instruction_text :=
1365: p_template_db_rec.instruction_text;
1366: END IF;
1364: p_template_rec.instruction_text :=
1365: p_template_db_rec.instruction_text;
1366: END IF;
1367:
1368: IF p_template_rec.description = okc_api.g_miss_char
1369: THEN
1370: p_template_rec.description := p_template_db_rec.description;
1371: END IF;
1372:
1369: THEN
1370: p_template_rec.description := p_template_db_rec.description;
1371: END IF;
1372:
1373: IF p_template_rec.working_copy_flag = okc_api.g_miss_char
1374: THEN
1375: p_template_rec.working_copy_flag :=
1376: p_template_db_rec.working_copy_flag;
1377: END IF;
1375: p_template_rec.working_copy_flag :=
1376: p_template_db_rec.working_copy_flag;
1377: END IF;
1378:
1379: IF p_template_rec.parent_template_id = okc_api.g_miss_num
1380: THEN
1381: p_template_rec.parent_template_id :=
1382: p_template_db_rec.parent_template_id;
1383: END IF;
1381: p_template_rec.parent_template_id :=
1382: p_template_db_rec.parent_template_id;
1383: END IF;
1384:
1385: IF p_template_rec.contract_expert_enabled = okc_api.g_miss_char
1386: THEN
1387: p_template_rec.contract_expert_enabled :=
1388: p_template_db_rec.contract_expert_enabled;
1389: END IF;
1387: p_template_rec.contract_expert_enabled :=
1388: p_template_db_rec.contract_expert_enabled;
1389: END IF;
1390:
1391: IF p_template_rec.template_model_id = okc_api.g_miss_num
1392: THEN
1393: p_template_rec.template_model_id :=
1394: p_template_db_rec.template_model_id;
1395: END IF;
1393: p_template_rec.template_model_id :=
1394: p_template_db_rec.template_model_id;
1395: END IF;
1396:
1397: IF p_template_rec.tmpl_numbering_scheme = okc_api.g_miss_num
1398: THEN
1399: p_template_rec.tmpl_numbering_scheme :=
1400: p_template_db_rec.tmpl_numbering_scheme;
1401: END IF;
1399: p_template_rec.tmpl_numbering_scheme :=
1400: p_template_db_rec.tmpl_numbering_scheme;
1401: END IF;
1402:
1403: IF p_template_rec.print_template_id = okc_api.g_miss_num
1404: THEN
1405: p_template_rec.print_template_id :=
1406: p_template_db_rec.print_template_id;
1407: END IF;
1405: p_template_rec.print_template_id :=
1406: p_template_db_rec.print_template_id;
1407: END IF;
1408:
1409: IF p_template_rec.approval_wf_key = okc_api.g_miss_char
1410: THEN
1411: p_template_rec.approval_wf_key :=
1412: p_template_db_rec.approval_wf_key;
1413: END IF;
1411: p_template_rec.approval_wf_key :=
1412: p_template_db_rec.approval_wf_key;
1413: END IF;
1414:
1415: IF p_template_rec.cz_export_wf_key = okc_api.g_miss_char
1416: THEN
1417: p_template_rec.cz_export_wf_key :=
1418: p_template_db_rec.cz_export_wf_key;
1419: END IF;
1417: p_template_rec.cz_export_wf_key :=
1418: p_template_db_rec.cz_export_wf_key;
1419: END IF;
1420:
1421: IF p_template_rec.last_update_login = okc_api.g_miss_num
1422: THEN
1423: p_template_rec.last_update_login :=
1424: p_template_db_rec.last_update_login;
1425: END IF;
1423: p_template_rec.last_update_login :=
1424: p_template_db_rec.last_update_login;
1425: END IF;
1426:
1427: IF p_template_rec.creation_date = okc_api.g_miss_date
1428: THEN
1429: p_template_rec.creation_date := p_template_db_rec.creation_date;
1430: END IF;
1431:
1428: THEN
1429: p_template_rec.creation_date := p_template_db_rec.creation_date;
1430: END IF;
1431:
1432: IF p_template_rec.created_by = okc_api.g_miss_num
1433: THEN
1434: p_template_rec.created_by := p_template_db_rec.created_by;
1435: END IF;
1436:
1433: THEN
1434: p_template_rec.created_by := p_template_db_rec.created_by;
1435: END IF;
1436:
1437: IF p_template_rec.last_updated_by = okc_api.g_miss_num
1438: THEN
1439: p_template_rec.last_updated_by :=
1440: p_template_db_rec.last_updated_by;
1441: END IF;
1439: p_template_rec.last_updated_by :=
1440: p_template_db_rec.last_updated_by;
1441: END IF;
1442:
1443: IF p_template_rec.last_update_date = okc_api.g_miss_date
1444: THEN
1445: p_template_rec.last_update_date :=
1446: p_template_db_rec.last_update_date;
1447: END IF;
1445: p_template_rec.last_update_date :=
1446: p_template_db_rec.last_update_date;
1447: END IF;
1448:
1449: IF p_template_rec.org_id = okc_api.g_miss_num
1450: THEN
1451: p_template_rec.org_id := p_template_db_rec.org_id;
1452: END IF;
1453:
1450: THEN
1451: p_template_rec.org_id := p_template_db_rec.org_id;
1452: END IF;
1453:
1454: IF p_template_rec.orig_system_reference_code = okc_api.g_miss_char
1455: THEN
1456: p_template_rec.orig_system_reference_code :=
1457: p_template_db_rec.orig_system_reference_code;
1458: END IF;
1456: p_template_rec.orig_system_reference_code :=
1457: p_template_db_rec.orig_system_reference_code;
1458: END IF;
1459:
1460: IF p_template_rec.orig_system_reference_id1 = okc_api.g_miss_num
1461: THEN
1462: p_template_rec.orig_system_reference_id1 :=
1463: p_template_db_rec.orig_system_reference_id1;
1464: END IF;
1462: p_template_rec.orig_system_reference_id1 :=
1463: p_template_db_rec.orig_system_reference_id1;
1464: END IF;
1465:
1466: IF p_template_rec.orig_system_reference_id2 = okc_api.g_miss_num
1467: THEN
1468: p_template_rec.orig_system_reference_id2 :=
1469: p_template_db_rec.orig_system_reference_id2;
1470: END IF;
1468: p_template_rec.orig_system_reference_id2 :=
1469: p_template_db_rec.orig_system_reference_id2;
1470: END IF;
1471:
1472: IF p_template_rec.object_version_number = okc_api.g_miss_num
1473: THEN
1474: p_template_rec.object_version_number :=
1475: p_template_db_rec.object_version_number;
1476: END IF;
1474: p_template_rec.object_version_number :=
1475: p_template_db_rec.object_version_number;
1476: END IF;
1477:
1478: IF p_template_rec.hide_yn = okc_api.g_miss_char
1479: THEN
1480: p_template_rec.hide_yn := p_template_db_rec.hide_yn;
1481: END IF;
1482:
1479: THEN
1480: p_template_rec.hide_yn := p_template_db_rec.hide_yn;
1481: END IF;
1482:
1483: IF p_template_rec.attribute_category = okc_api.g_miss_char
1484: THEN
1485: p_template_rec.attribute_category :=
1486: p_template_db_rec.attribute_category;
1487: END IF;
1485: p_template_rec.attribute_category :=
1486: p_template_db_rec.attribute_category;
1487: END IF;
1488:
1489: IF p_template_rec.attribute1 = okc_api.g_miss_char
1490: THEN
1491: p_template_rec.attribute1 := p_template_db_rec.attribute1;
1492: END IF;
1493:
1490: THEN
1491: p_template_rec.attribute1 := p_template_db_rec.attribute1;
1492: END IF;
1493:
1494: IF p_template_rec.attribute2 = okc_api.g_miss_char
1495: THEN
1496: p_template_rec.attribute2 := p_template_db_rec.attribute2;
1497: END IF;
1498:
1495: THEN
1496: p_template_rec.attribute2 := p_template_db_rec.attribute2;
1497: END IF;
1498:
1499: IF p_template_rec.attribute3 = okc_api.g_miss_char
1500: THEN
1501: p_template_rec.attribute3 := p_template_db_rec.attribute3;
1502: END IF;
1503:
1500: THEN
1501: p_template_rec.attribute3 := p_template_db_rec.attribute3;
1502: END IF;
1503:
1504: IF p_template_rec.attribute4 = okc_api.g_miss_char
1505: THEN
1506: p_template_rec.attribute4 := p_template_db_rec.attribute4;
1507: END IF;
1508:
1505: THEN
1506: p_template_rec.attribute4 := p_template_db_rec.attribute4;
1507: END IF;
1508:
1509: IF p_template_rec.attribute5 = okc_api.g_miss_char
1510: THEN
1511: p_template_rec.attribute5 := p_template_db_rec.attribute5;
1512: END IF;
1513:
1510: THEN
1511: p_template_rec.attribute5 := p_template_db_rec.attribute5;
1512: END IF;
1513:
1514: IF p_template_rec.attribute6 = okc_api.g_miss_char
1515: THEN
1516: p_template_rec.attribute6 := p_template_db_rec.attribute6;
1517: END IF;
1518:
1515: THEN
1516: p_template_rec.attribute6 := p_template_db_rec.attribute6;
1517: END IF;
1518:
1519: IF p_template_rec.attribute7 = okc_api.g_miss_char
1520: THEN
1521: p_template_rec.attribute7 := p_template_db_rec.attribute7;
1522: END IF;
1523:
1520: THEN
1521: p_template_rec.attribute7 := p_template_db_rec.attribute7;
1522: END IF;
1523:
1524: IF p_template_rec.attribute8 = okc_api.g_miss_char
1525: THEN
1526: p_template_rec.attribute8 := p_template_db_rec.attribute8;
1527: END IF;
1528:
1525: THEN
1526: p_template_rec.attribute8 := p_template_db_rec.attribute8;
1527: END IF;
1528:
1529: IF p_template_rec.attribute9 = okc_api.g_miss_char
1530: THEN
1531: p_template_rec.attribute9 := p_template_db_rec.attribute9;
1532: END IF;
1533:
1530: THEN
1531: p_template_rec.attribute9 := p_template_db_rec.attribute9;
1532: END IF;
1533:
1534: IF p_template_rec.attribute10 = okc_api.g_miss_char
1535: THEN
1536: p_template_rec.attribute10 := p_template_db_rec.attribute10;
1537: END IF;
1538:
1535: THEN
1536: p_template_rec.attribute10 := p_template_db_rec.attribute10;
1537: END IF;
1538:
1539: IF p_template_rec.attribute11 = okc_api.g_miss_char
1540: THEN
1541: p_template_rec.attribute11 := p_template_db_rec.attribute11;
1542: END IF;
1543:
1540: THEN
1541: p_template_rec.attribute11 := p_template_db_rec.attribute11;
1542: END IF;
1543:
1544: IF p_template_rec.attribute12 = okc_api.g_miss_char
1545: THEN
1546: p_template_rec.attribute12 := p_template_db_rec.attribute12;
1547: END IF;
1548:
1545: THEN
1546: p_template_rec.attribute12 := p_template_db_rec.attribute12;
1547: END IF;
1548:
1549: IF p_template_rec.attribute13 = okc_api.g_miss_char
1550: THEN
1551: p_template_rec.attribute13 := p_template_db_rec.attribute13;
1552: END IF;
1553:
1550: THEN
1551: p_template_rec.attribute13 := p_template_db_rec.attribute13;
1552: END IF;
1553:
1554: IF p_template_rec.attribute14 = okc_api.g_miss_char
1555: THEN
1556: p_template_rec.attribute14 := p_template_db_rec.attribute14;
1557: END IF;
1558:
1555: THEN
1556: p_template_rec.attribute14 := p_template_db_rec.attribute14;
1557: END IF;
1558:
1559: IF p_template_rec.attribute15 = okc_api.g_miss_char
1560: THEN
1561: p_template_rec.attribute15 := p_template_db_rec.attribute15;
1562: END IF;
1563:
1560: THEN
1561: p_template_rec.attribute15 := p_template_db_rec.attribute15;
1562: END IF;
1563:
1564: IF p_template_rec.xprt_request_id = okc_api.g_miss_num
1565: THEN
1566: p_template_rec.xprt_request_id :=
1567: p_template_db_rec.xprt_request_id;
1568: END IF;
1566: p_template_rec.xprt_request_id :=
1567: p_template_db_rec.xprt_request_id;
1568: END IF;
1569:
1570: IF p_template_rec.xprt_clause_mandatory_flag = okc_api.g_miss_char
1571: THEN
1572: p_template_rec.xprt_clause_mandatory_flag :=
1573: p_template_db_rec.xprt_clause_mandatory_flag;
1574: END IF;
1572: p_template_rec.xprt_clause_mandatory_flag :=
1573: p_template_db_rec.xprt_clause_mandatory_flag;
1574: END IF;
1575:
1576: IF p_template_rec.xprt_scn_code = okc_api.g_miss_char
1577: THEN
1578: p_template_rec.xprt_scn_code := p_template_db_rec.xprt_scn_code;
1579: END IF;
1580:
1577: THEN
1578: p_template_rec.xprt_scn_code := p_template_db_rec.xprt_scn_code;
1579: END IF;
1580:
1581: IF p_template_rec.LANGUAGE = okc_api.g_miss_char
1582: THEN
1583: p_template_rec.LANGUAGE := p_template_db_rec.LANGUAGE;
1584: END IF;
1585:
1582: THEN
1583: p_template_rec.LANGUAGE := p_template_db_rec.LANGUAGE;
1584: END IF;
1585:
1586: IF p_template_rec.translated_from_tmpl_id = okc_api.g_miss_num
1587: THEN
1588: p_template_rec.translated_from_tmpl_id :=
1589: p_template_db_rec.translated_from_tmpl_id;
1590: END IF;
1605: WHERE template_id = p_template_rec.template_id;
1606: EXCEPTION
1607: WHEN OTHERS
1608: THEN
1609: okc_api.set_message (p_app_name => g_app_name,
1610: p_msg_name => 'OKC_I_INVALID_VALUE',
1611: p_token1 => 'FIELD',
1612: p_token1_value => 'TEMPLATE_ID'
1613: );
1616:
1617: --
1618: IF inittemplateinfo (p_template_rec.template_id) <> 'Y'
1619: THEN
1620: okc_api.set_message (p_app_name => g_app_name,
1621: p_msg_name => 'OKC_I_INVALID_VALUE',
1622: p_token1 => 'FIELD',
1623: p_token1_value => 'TEMPLATE_ID'
1624: );
1629: IF g_headerinfo_update_allowed = 'N'
1630: THEN
1631: l_progress := '020';
1632: -- Can't update anything just return the error.
1633: okc_api.set_message (p_app_name => g_app_name,
1634: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD',
1635: p_token1 => 'STATUS',
1636: p_token1_value => l_template_db_rec.status_code
1637: );
1637: );
1638: RAISE fnd_api.g_exc_error;
1639: ELSE
1640: -- Org Id Can't be changed
1641: IF p_template_rec.org_id <> okc_api.g_miss_num
1642: AND NVL (p_template_rec.org_id, -1) <> l_template_db_rec.org_id
1643: THEN
1644: -- You can not change ORG_ID
1645: okc_api.set_message
1641: IF p_template_rec.org_id <> okc_api.g_miss_num
1642: AND NVL (p_template_rec.org_id, -1) <> l_template_db_rec.org_id
1643: THEN
1644: -- You can not change ORG_ID
1645: okc_api.set_message
1646: (p_app_name => g_app_name,
1647: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD_FIELD',
1648: p_token1 => 'STATUS',
1649: p_token1_value => l_template_db_rec.status_code,
1653: RAISE fnd_api.g_exc_error;
1654: END IF;
1655:
1656: -- Intent Can't be changed
1657: IF p_template_rec.intent <> okc_api.g_miss_char
1658: AND NVL (p_template_rec.intent, 'ABC') <> l_template_db_rec.intent
1659: THEN
1660: -- You can not change Intent
1661: okc_api.set_message
1657: IF p_template_rec.intent <> okc_api.g_miss_char
1658: AND NVL (p_template_rec.intent, 'ABC') <> l_template_db_rec.intent
1659: THEN
1660: -- You can not change Intent
1661: okc_api.set_message
1662: (p_app_name => g_app_name,
1663: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD_FIELD',
1664: p_token1 => 'STATUS',
1665: p_token1_value => l_template_db_rec.status_code,
1669: RAISE fnd_api.g_exc_error;
1670: END IF;
1671:
1672: -- Status Can't be changed
1673: IF p_template_rec.status_code <> okc_api.g_miss_char
1674: AND NVL (p_template_rec.status_code, 'ABC') <>
1675: l_template_db_rec.status_code
1676: THEN
1677: -- You can not change Status
1674: AND NVL (p_template_rec.status_code, 'ABC') <>
1675: l_template_db_rec.status_code
1676: THEN
1677: -- You can not change Status
1678: okc_api.set_message (p_app_name => g_app_name,
1679: p_msg_name => 'OKC_I _TEMP_STS_CHANGE'
1680: );
1681: RAISE fnd_api.g_exc_error;
1682: END IF;
1683:
1684: IF l_template_db_rec.status_code = 'APPROVED'
1685: THEN
1686: -- Name Can't be changed
1687: IF p_template_rec.template_name <> okc_api.g_miss_char
1688: AND NVL (p_template_rec.template_name, 'ABC') <>
1689: l_template_db_rec.template_name
1690: THEN
1691: -- You can not change TEmplate NAme
1688: AND NVL (p_template_rec.template_name, 'ABC') <>
1689: l_template_db_rec.template_name
1690: THEN
1691: -- You can not change TEmplate NAme
1692: okc_api.set_message
1693: (p_app_name => g_app_name,
1694: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD_FIELD',
1695: p_token1 => 'STATUS',
1696: p_token1_value => l_template_db_rec.status_code,
1700: RAISE fnd_api.g_exc_error;
1701: END IF;
1702:
1703: -- Start Date Can't be changed
1704: IF p_template_rec.start_date <> okc_api.g_miss_date
1705: AND NVL (p_template_rec.start_date, okc_api.g_miss_date) <>
1706: l_template_db_rec.start_date
1707: THEN
1708: -- You can not change Start Date
1701: END IF;
1702:
1703: -- Start Date Can't be changed
1704: IF p_template_rec.start_date <> okc_api.g_miss_date
1705: AND NVL (p_template_rec.start_date, okc_api.g_miss_date) <>
1706: l_template_db_rec.start_date
1707: THEN
1708: -- You can not change Start Date
1709: okc_api.set_message
1705: AND NVL (p_template_rec.start_date, okc_api.g_miss_date) <>
1706: l_template_db_rec.start_date
1707: THEN
1708: -- You can not change Start Date
1709: okc_api.set_message
1710: (p_app_name => g_app_name,
1711: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD_FIELD',
1712: p_token1 => 'STATUS',
1713: p_token1_value => l_template_db_rec.status_code,
1718: END IF;
1719:
1720: -- Contract Expert enabled can't be changed
1721: IF p_template_rec.contract_expert_enabled <>
1722: okc_api.g_miss_char
1723: AND NVL (p_template_rec.contract_expert_enabled, 'ABC') <>
1724: l_template_db_rec.contract_expert_enabled
1725: THEN
1726: -- You can not change Contract Expert Enabled
1723: AND NVL (p_template_rec.contract_expert_enabled, 'ABC') <>
1724: l_template_db_rec.contract_expert_enabled
1725: THEN
1726: -- You can not change Contract Expert Enabled
1727: okc_api.set_message
1728: (p_app_name => g_app_name,
1729: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD_FIELD',
1730: p_token1 => 'STATUS',
1731: p_token1_value => l_template_db_rec.status_code,
1735: RAISE fnd_api.g_exc_error;
1736: END IF;
1737:
1738: --
1739: IF p_template_rec.xprt_scn_code <> okc_api.g_miss_char
1740: AND NVL (p_template_rec.xprt_scn_code, 'ABC') <>
1741: l_template_db_rec.xprt_scn_code
1742: THEN
1743: -- You can not change xprt_scn_code
1740: AND NVL (p_template_rec.xprt_scn_code, 'ABC') <>
1741: l_template_db_rec.xprt_scn_code
1742: THEN
1743: -- You can not change xprt_scn_code
1744: okc_api.set_message
1745: (p_app_name => g_app_name,
1746: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD_FIELD',
1747: p_token1 => 'STATUS',
1748: p_token1_value => l_template_db_rec.status_code,
1752: RAISE fnd_api.g_exc_error;
1753: END IF;
1754:
1755: IF p_template_rec.xprt_clause_mandatory_flag <>
1756: okc_api.g_miss_char
1757: AND NVL (p_template_rec.xprt_clause_mandatory_flag, 'ABC') <>
1758: l_template_db_rec.xprt_clause_mandatory_flag
1759: THEN
1760: -- You can not change xprt_scn_code
1757: AND NVL (p_template_rec.xprt_clause_mandatory_flag, 'ABC') <>
1758: l_template_db_rec.xprt_clause_mandatory_flag
1759: THEN
1760: -- You can not change xprt_scn_code
1761: okc_api.set_message
1762: (p_app_name => g_app_name,
1763: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD_FIELD',
1764: p_token1 => 'STATUS',
1765: p_token1_value => l_template_db_rec.status_code,
1910: THEN
1911: p_template_tbl (i).status := g_ret_sts_error;
1912: set_proc_error_message (p_proc => l_proc);
1913: set_rec_num_message (p_rec_num => l_failed_rec_num);
1914: okc_api.set_message (p_app_name => g_app_name,
1915: p_msg_name => g_unexpected_error,
1916: p_token1 => g_sqlcode_token,
1917: p_token1_value => SQLCODE,
1918: p_token2 => g_sqlerrm_token,
1980: THEN
1981: p_template_tbl (i).status := g_ret_sts_error;
1982: set_proc_error_message (p_proc => l_proc);
1983: set_rec_num_message (p_rec_num => l_failed_rec_num);
1984: okc_api.set_message (p_app_name => g_app_name,
1985: p_msg_name => g_unexpected_error,
1986: p_token1 => g_sqlcode_token,
1987: p_token1_value => SQLCODE,
1988: p_token2 => g_sqlerrm_token,
2015:
2016: PROCEDURE default_row (p_section_rec IN OUT NOCOPY section_rec_type)
2017: IS
2018: BEGIN
2019: IF p_section_rec.ID = okc_api.g_miss_num
2020: THEN
2021: /* SELECT okc_sections_b_s.NEXTVAL
2022: INTO p_section_rec.ID
2023: FROM DUAL; */
2024: p_section_rec.ID := NULL;
2025: END IF;
2026:
2027: -- Indicates if the section refers to a contract header or a standard clause set.
2028: IF p_section_rec.scn_type = okc_api.g_miss_char
2029: THEN
2030: p_section_rec.scn_type := NULL;
2031: END IF;
2032:
2030: p_section_rec.scn_type := NULL;
2031: END IF;
2032:
2033: -- Contract header id for this section. If -99, then the section refers to a standard clause set.
2034: IF p_section_rec.chr_id = okc_api.g_miss_num
2035: THEN
2036: p_section_rec.chr_id := NULL;
2037: END IF;
2038:
2037: END IF;
2038:
2039: -- Standard Clause Set code, for formatting standard clause sets.
2040: -- If -99, then this section refers to a contract.
2041: IF p_section_rec.sat_code = okc_api.g_miss_char
2042: THEN
2043: p_section_rec.sat_code := NULL;
2044: END IF;
2045:
2043: p_section_rec.sat_code := NULL;
2044: END IF;
2045:
2046: -- Sequence number for the section
2047: IF p_section_rec.section_sequence = okc_api.g_miss_num
2048: THEN
2049: p_section_rec.section_sequence := NULL;
2050: END IF;
2051:
2050: END IF;
2051:
2052: -- Sequential number set at 1 on insert and incremented on update.
2053: -- Used by APIs to ensure current record is passed.
2054: IF p_section_rec.object_version_number = okc_api.g_miss_num
2055: THEN
2056: p_section_rec.object_version_number := 1;
2057: END IF;
2058:
2055: THEN
2056: p_section_rec.object_version_number := 1;
2057: END IF;
2058:
2059: IF p_section_rec.created_by = okc_api.g_miss_num
2060: THEN
2061: p_section_rec.created_by := fnd_global.user_id;
2062: END IF;
2063:
2060: THEN
2061: p_section_rec.created_by := fnd_global.user_id;
2062: END IF;
2063:
2064: IF p_section_rec.creation_date = okc_api.g_miss_date
2065: THEN
2066: p_section_rec.creation_date := SYSDATE;
2067: END IF;
2068:
2065: THEN
2066: p_section_rec.creation_date := SYSDATE;
2067: END IF;
2068:
2069: IF p_section_rec.last_updated_by = okc_api.g_miss_num
2070: THEN
2071: p_section_rec.last_updated_by := fnd_global.user_id;
2072: END IF;
2073:
2070: THEN
2071: p_section_rec.last_updated_by := fnd_global.user_id;
2072: END IF;
2073:
2074: IF p_section_rec.last_update_date = okc_api.g_miss_date
2075: THEN
2076: p_section_rec.last_update_date := SYSDATE;
2077: END IF;
2078:
2075: THEN
2076: p_section_rec.last_update_date := SYSDATE;
2077: END IF;
2078:
2079: IF p_section_rec.last_update_login = okc_api.g_miss_num
2080: THEN
2081: p_section_rec.last_update_login := fnd_global.login_id;
2082: END IF;
2083:
2081: p_section_rec.last_update_login := fnd_global.login_id;
2082: END IF;
2083:
2084: -- The label to be printed for the section, such as III. or 3.
2085: IF p_section_rec.label = okc_api.g_miss_char
2086: THEN
2087: p_section_rec.label := NULL;
2088: END IF;
2089:
2087: p_section_rec.label := NULL;
2088: END IF;
2089:
2090: -- Indicates parent section for this subsection
2091: IF p_section_rec.scn_id = okc_api.g_miss_num
2092: THEN
2093: p_section_rec.scn_id := NULL;
2094: END IF;
2095:
2092: THEN
2093: p_section_rec.scn_id := NULL;
2094: END IF;
2095:
2096: IF p_section_rec.attribute_category = okc_api.g_miss_char
2097: THEN
2098: p_section_rec.attribute_category := NULL;
2099: END IF;
2100:
2097: THEN
2098: p_section_rec.attribute_category := NULL;
2099: END IF;
2100:
2101: IF p_section_rec.attribute1 = okc_api.g_miss_char
2102: THEN
2103: p_section_rec.attribute1 := NULL;
2104: END IF;
2105:
2102: THEN
2103: p_section_rec.attribute1 := NULL;
2104: END IF;
2105:
2106: IF p_section_rec.attribute2 = okc_api.g_miss_char
2107: THEN
2108: p_section_rec.attribute2 := NULL;
2109: END IF;
2110:
2107: THEN
2108: p_section_rec.attribute2 := NULL;
2109: END IF;
2110:
2111: IF p_section_rec.attribute3 = okc_api.g_miss_char
2112: THEN
2113: p_section_rec.attribute3 := NULL;
2114: END IF;
2115:
2112: THEN
2113: p_section_rec.attribute3 := NULL;
2114: END IF;
2115:
2116: IF p_section_rec.attribute4 = okc_api.g_miss_char
2117: THEN
2118: p_section_rec.attribute4 := NULL;
2119: END IF;
2120:
2117: THEN
2118: p_section_rec.attribute4 := NULL;
2119: END IF;
2120:
2121: IF p_section_rec.attribute5 = okc_api.g_miss_char
2122: THEN
2123: p_section_rec.attribute5 := NULL;
2124: END IF;
2125:
2122: THEN
2123: p_section_rec.attribute5 := NULL;
2124: END IF;
2125:
2126: IF p_section_rec.attribute6 = okc_api.g_miss_char
2127: THEN
2128: p_section_rec.attribute6 := NULL;
2129: END IF;
2130:
2127: THEN
2128: p_section_rec.attribute6 := NULL;
2129: END IF;
2130:
2131: IF p_section_rec.attribute7 = okc_api.g_miss_char
2132: THEN
2133: p_section_rec.attribute7 := NULL;
2134: END IF;
2135:
2132: THEN
2133: p_section_rec.attribute7 := NULL;
2134: END IF;
2135:
2136: IF p_section_rec.attribute8 = okc_api.g_miss_char
2137: THEN
2138: p_section_rec.attribute8 := NULL;
2139: END IF;
2140:
2137: THEN
2138: p_section_rec.attribute8 := NULL;
2139: END IF;
2140:
2141: IF p_section_rec.attribute9 = okc_api.g_miss_char
2142: THEN
2143: p_section_rec.attribute9 := NULL;
2144: END IF;
2145:
2142: THEN
2143: p_section_rec.attribute9 := NULL;
2144: END IF;
2145:
2146: IF p_section_rec.attribute10 = okc_api.g_miss_char
2147: THEN
2148: p_section_rec.attribute10 := NULL;
2149: END IF;
2150:
2147: THEN
2148: p_section_rec.attribute10 := NULL;
2149: END IF;
2150:
2151: IF p_section_rec.attribute11 = okc_api.g_miss_char
2152: THEN
2153: p_section_rec.attribute11 := NULL;
2154: END IF;
2155:
2152: THEN
2153: p_section_rec.attribute11 := NULL;
2154: END IF;
2155:
2156: IF p_section_rec.attribute12 = okc_api.g_miss_char
2157: THEN
2158: p_section_rec.attribute12 := NULL;
2159: END IF;
2160:
2157: THEN
2158: p_section_rec.attribute12 := NULL;
2159: END IF;
2160:
2161: IF p_section_rec.attribute13 = okc_api.g_miss_char
2162: THEN
2163: p_section_rec.attribute13 := NULL;
2164: END IF;
2165:
2162: THEN
2163: p_section_rec.attribute13 := NULL;
2164: END IF;
2165:
2166: IF p_section_rec.attribute14 = okc_api.g_miss_char
2167: THEN
2168: p_section_rec.attribute14 := NULL;
2169: END IF;
2170:
2167: THEN
2168: p_section_rec.attribute14 := NULL;
2169: END IF;
2170:
2171: IF p_section_rec.attribute15 = okc_api.g_miss_char
2172: THEN
2173: p_section_rec.attribute15 := NULL;
2174: END IF;
2175:
2172: THEN
2173: p_section_rec.attribute15 := NULL;
2174: END IF;
2175:
2176: IF p_section_rec.security_group_id = okc_api.g_miss_num
2177: THEN
2178: p_section_rec.security_group_id := NULL;
2179: END IF;
2180:
2177: THEN
2178: p_section_rec.security_group_id := NULL;
2179: END IF;
2180:
2181: IF p_section_rec.old_id = okc_api.g_miss_num
2182: THEN
2183: p_section_rec.old_id := NULL;
2184: END IF;
2185:
2183: p_section_rec.old_id := NULL;
2184: END IF;
2185:
2186: -- Business document type. Refers to document_type in okc_bus_doc_types_b
2187: IF p_section_rec.document_type = okc_api.g_miss_char
2188: THEN
2189: p_section_rec.document_type := 'TEMPLATE';
2190: END IF;
2191:
2189: p_section_rec.document_type := 'TEMPLATE';
2190: END IF;
2191:
2192: -- Business document identifier. Refers to ID in various business document header tables
2193: IF p_section_rec.document_id = okc_api.g_miss_num
2194: THEN
2195: p_section_rec.document_id := NULL;
2196: END IF;
2197:
2195: p_section_rec.document_id := NULL;
2196: END IF;
2197:
2198: -- section identifier
2199: IF p_section_rec.scn_code = okc_api.g_miss_char
2200: THEN
2201: p_section_rec.scn_code := NULL;
2202: END IF;
2203:
2201: p_section_rec.scn_code := NULL;
2202: END IF;
2203:
2204: -- Text to capture Section description
2205: IF p_section_rec.description = okc_api.g_miss_char
2206: THEN
2207: p_section_rec.description := NULL;
2208: END IF;
2209:
2206: THEN
2207: p_section_rec.description := NULL;
2208: END IF;
2209:
2210: IF p_section_rec.amendment_description = okc_api.g_miss_char
2211: THEN
2212: p_section_rec.amendment_description := NULL;
2213: END IF;
2214:
2211: THEN
2212: p_section_rec.amendment_description := NULL;
2213: END IF;
2214:
2215: IF p_section_rec.amendment_operation_code = okc_api.g_miss_char
2216: THEN
2217: p_section_rec.amendment_operation_code := NULL;
2218: END IF;
2219:
2216: THEN
2217: p_section_rec.amendment_operation_code := NULL;
2218: END IF;
2219:
2220: IF p_section_rec.orig_system_reference_code = okc_api.g_miss_char
2221: THEN
2222: p_section_rec.orig_system_reference_code := NULL;
2223: END IF;
2224:
2221: THEN
2222: p_section_rec.orig_system_reference_code := NULL;
2223: END IF;
2224:
2225: IF p_section_rec.orig_system_reference_id1 = okc_api.g_miss_num
2226: THEN
2227: p_section_rec.orig_system_reference_id1 := NULL;
2228: END IF;
2229:
2226: THEN
2227: p_section_rec.orig_system_reference_id1 := NULL;
2228: END IF;
2229:
2230: IF p_section_rec.orig_system_reference_id2 = okc_api.g_miss_num
2231: THEN
2232: p_section_rec.orig_system_reference_id2 := NULL;
2233: END IF;
2234:
2232: p_section_rec.orig_system_reference_id2 := NULL;
2233: END IF;
2234:
2235: -- Indicator for printing section when the document is printed. Valid values are Y and N.
2236: IF p_section_rec.print_yn = okc_api.g_miss_char
2237: THEN
2238: p_section_rec.print_yn := 'Y';
2239: END IF;
2240:
2237: THEN
2238: p_section_rec.print_yn := 'Y';
2239: END IF;
2240:
2241: IF p_section_rec.summary_amend_operation_code = okc_api.g_miss_char
2242: THEN
2243: p_section_rec.summary_amend_operation_code := NULL;
2244: END IF;
2245:
2243: p_section_rec.summary_amend_operation_code := NULL;
2244: END IF;
2245:
2246: -- Section title. This column is migrated from okc_sections_tl table
2247: IF p_section_rec.heading = okc_api.g_miss_char
2248: THEN
2249: p_section_rec.heading := NULL;
2250: END IF;
2251:
2248: THEN
2249: p_section_rec.heading := NULL;
2250: END IF;
2251:
2252: IF p_section_rec.last_amended_by = okc_api.g_miss_num
2253: THEN
2254: p_section_rec.last_amended_by := NULL;
2255: END IF;
2256:
2253: THEN
2254: p_section_rec.last_amended_by := NULL;
2255: END IF;
2256:
2257: IF p_section_rec.last_amendment_date = okc_api.g_miss_date
2258: THEN
2259: p_section_rec.last_amendment_date := NULL;
2260: END IF;
2261: END default_row;
2268: BEGIN
2269: -- not null
2270: IF p_section_rec.section_sequence IS NULL
2271: THEN
2272: okc_api.set_message (p_app_name => g_app_name,
2273: p_msg_name => 'OKC_I_NOT_NULL',
2274: p_token1 => 'FIELD',
2275: p_token1_value => 'SECTION_SEQUENCE'
2276: );
2278: END IF;
2279:
2280: IF p_section_rec.document_id IS NULL
2281: THEN
2282: okc_api.set_message (p_app_name => g_app_name,
2283: p_msg_name => 'OKC_I_NOT_NULL',
2284: p_token1 => 'FIELD',
2285: p_token1_value => 'TEMPLATE_ID'
2286: -- since the flow is for only templates
2289: END IF;
2290:
2291: IF p_section_rec.scn_code IS NULL
2292: THEN
2293: okc_api.set_message (p_app_name => g_app_name,
2294: p_msg_name => 'OKC_I_NOT_NULL',
2295: p_token1 => 'FIELD',
2296: p_token1_value => 'SCN_CODE'
2297: );
2300:
2301: -- Validate Docuemnt Type
2302: IF p_section_rec.document_type <> 'TEMPLATE'
2303: THEN
2304: okc_api.set_message (p_app_name => g_app_name,
2305: p_msg_name => 'OKC_I_INVALID_VALUE',
2306: p_token1 => 'FIELD',
2307: p_token1_value => 'TEMPLATE'
2308: );
2311:
2312: /*IF inittemplateinfo (p_template_id => p_section_rec.document_id) <>
2313: 'Y'
2314: THEN
2315: okc_api.set_message (p_app_name => g_app_name,
2316: p_msg_name => 'OKC_I_INVALID_VALUE',
2317: p_token1 => 'FIELD',
2318: p_token1_value => 'TEMPLATE_ID'
2319: );
2326: IF isvalidsection (p_template_id => p_section_rec.document_id,
2327: p_scn_id => p_section_rec.scn_id
2328: ) <> 'Y'
2329: THEN
2330: okc_api.set_message (p_app_name => g_app_name,
2331: p_msg_name => 'OKC_I_INVALID_VALUE',
2332: p_token1 => 'FIELD',
2333: p_token1_value => 'SCN_ID'
2334: );
2341: p_lookup_code => p_section_rec.scn_code,
2342: x_meaning => p_section_rec.description
2343: ) <> 'Y'
2344: THEN
2345: okc_api.set_message (p_app_name => g_app_name,
2346: p_msg_name => 'OKC_I_INVALID_VALUE',
2347: p_token1 => 'FIELD',
2348: p_token1_value => 'SCN_CODE'
2349: );
2365: THEN
2366: IF inittemplateinfo (p_template_id => p_section_rec.document_id) <>
2367: 'Y'
2368: THEN
2369: okc_api.set_message (p_app_name => g_app_name,
2370: p_msg_name => 'OKC_I_INVALID_VALUE',
2371: p_token1 => 'FIELD',
2372: p_token1_value => 'TEMPLATE_ID'
2373: );
2376: END IF;
2377:
2378: IF g_clause_update_allowed <> 'Y'
2379: THEN
2380: okc_api.set_message (p_app_name => g_app_name,
2381: p_msg_name => 'OKC_I_TEMP_STS_NO_INS_OBJ',
2382: p_token1 => 'STATUS',
2383: p_token1_value => g_template_status_code,
2384: p_token2 => 'OBJECT',
2473: WHEN OTHERS
2474: THEN
2475: p_section_rec.status := g_ret_sts_error;
2476: set_proc_error_message (p_proc => l_proc);
2477: okc_api.set_message (p_app_name => g_app_name,
2478: p_msg_name => g_unexpected_error,
2479: p_token1 => g_sqlcode_token,
2480: p_token1_value => SQLCODE,
2481: p_token2 => g_sqlerrm_token,
2504: PROCEDURE default_row (p_article_rec IN OUT NOCOPY k_article_rec_type)
2505: IS
2506: BEGIN
2507: /*
2508: IF p_article_rec.ID = okc_api.g_miss_num
2509: THEN
2510: SELECT
2511: INTO p_article_rec.ID
2512: FROM DUAL;
2510: SELECT
2511: INTO p_article_rec.ID
2512: FROM DUAL;
2513: END IF; */
2514: IF p_article_rec.sav_sae_id = okc_api.g_miss_num
2515: THEN
2516: p_article_rec.sav_sae_id := NULL;
2517: END IF;
2518:
2515: THEN
2516: p_article_rec.sav_sae_id := NULL;
2517: END IF;
2518:
2519: IF p_article_rec.sav_sav_release = okc_api.g_miss_char
2520: THEN
2521: p_article_rec.sav_sav_release := NULL;
2522: END IF;
2523:
2520: THEN
2521: p_article_rec.sav_sav_release := NULL;
2522: END IF;
2523:
2524: IF p_article_rec.sbt_code = okc_api.g_miss_char
2525: THEN
2526: p_article_rec.sbt_code := NULL;
2527: END IF;
2528:
2525: THEN
2526: p_article_rec.sbt_code := NULL;
2527: END IF;
2528:
2529: IF p_article_rec.cat_type = okc_api.g_miss_char
2530: THEN
2531: p_article_rec.cat_type := NULL;
2532: END IF;
2533:
2530: THEN
2531: p_article_rec.cat_type := NULL;
2532: END IF;
2533:
2534: IF p_article_rec.chr_id = okc_api.g_miss_num
2535: THEN
2536: p_article_rec.chr_id := NULL;
2537: END IF;
2538:
2535: THEN
2536: p_article_rec.chr_id := NULL;
2537: END IF;
2538:
2539: IF p_article_rec.cle_id = okc_api.g_miss_num
2540: THEN
2541: p_article_rec.cle_id := NULL;
2542: END IF;
2543:
2540: THEN
2541: p_article_rec.cle_id := NULL;
2542: END IF;
2543:
2544: IF p_article_rec.cat_id = okc_api.g_miss_num
2545: THEN
2546: p_article_rec.cat_id := NULL;
2547: END IF;
2548:
2545: THEN
2546: p_article_rec.cat_id := NULL;
2547: END IF;
2548:
2549: IF p_article_rec.dnz_chr_id = okc_api.g_miss_num
2550: THEN
2551: p_article_rec.dnz_chr_id := NULL;
2552: END IF;
2553:
2550: THEN
2551: p_article_rec.dnz_chr_id := NULL;
2552: END IF;
2553:
2554: IF p_article_rec.object_version_number = okc_api.g_miss_num
2555: THEN
2556: p_article_rec.object_version_number := 1;
2557: END IF;
2558:
2555: THEN
2556: p_article_rec.object_version_number := 1;
2557: END IF;
2558:
2559: IF p_article_rec.created_by = okc_api.g_miss_num
2560: THEN
2561: p_article_rec.created_by := fnd_global.user_id;
2562: END IF;
2563:
2560: THEN
2561: p_article_rec.created_by := fnd_global.user_id;
2562: END IF;
2563:
2564: IF p_article_rec.creation_date = okc_api.g_miss_date
2565: THEN
2566: p_article_rec.creation_date := SYSDATE;
2567: END IF;
2568:
2565: THEN
2566: p_article_rec.creation_date := SYSDATE;
2567: END IF;
2568:
2569: IF p_article_rec.last_updated_by = okc_api.g_miss_num
2570: THEN
2571: p_article_rec.last_updated_by := fnd_global.user_id;
2572: END IF;
2573:
2570: THEN
2571: p_article_rec.last_updated_by := fnd_global.user_id;
2572: END IF;
2573:
2574: IF p_article_rec.last_update_date = okc_api.g_miss_date
2575: THEN
2576: p_article_rec.last_update_date := SYSDATE;
2577: END IF;
2578:
2575: THEN
2576: p_article_rec.last_update_date := SYSDATE;
2577: END IF;
2578:
2579: IF p_article_rec.fulltext_yn = okc_api.g_miss_char
2580: THEN
2581: p_article_rec.fulltext_yn := NULL;
2582: END IF;
2583:
2580: THEN
2581: p_article_rec.fulltext_yn := NULL;
2582: END IF;
2583:
2584: IF p_article_rec.last_update_login = okc_api.g_miss_num
2585: THEN
2586: p_article_rec.last_update_login := fnd_global.login_id;
2587: END IF;
2588:
2585: THEN
2586: p_article_rec.last_update_login := fnd_global.login_id;
2587: END IF;
2588:
2589: IF p_article_rec.attribute_category = okc_api.g_miss_char
2590: THEN
2591: p_article_rec.attribute_category := NULL;
2592: END IF;
2593:
2590: THEN
2591: p_article_rec.attribute_category := NULL;
2592: END IF;
2593:
2594: IF p_article_rec.attribute1 = okc_api.g_miss_char
2595: THEN
2596: p_article_rec.attribute1 := NULL;
2597: END IF;
2598:
2595: THEN
2596: p_article_rec.attribute1 := NULL;
2597: END IF;
2598:
2599: IF p_article_rec.attribute2 = okc_api.g_miss_char
2600: THEN
2601: p_article_rec.attribute2 := NULL;
2602: END IF;
2603:
2600: THEN
2601: p_article_rec.attribute2 := NULL;
2602: END IF;
2603:
2604: IF p_article_rec.attribute3 = okc_api.g_miss_char
2605: THEN
2606: p_article_rec.attribute3 := NULL;
2607: END IF;
2608:
2605: THEN
2606: p_article_rec.attribute3 := NULL;
2607: END IF;
2608:
2609: IF p_article_rec.attribute4 = okc_api.g_miss_char
2610: THEN
2611: p_article_rec.attribute4 := NULL;
2612: END IF;
2613:
2610: THEN
2611: p_article_rec.attribute4 := NULL;
2612: END IF;
2613:
2614: IF p_article_rec.attribute5 = okc_api.g_miss_char
2615: THEN
2616: p_article_rec.attribute5 := NULL;
2617: END IF;
2618:
2615: THEN
2616: p_article_rec.attribute5 := NULL;
2617: END IF;
2618:
2619: IF p_article_rec.attribute6 = okc_api.g_miss_char
2620: THEN
2621: p_article_rec.attribute6 := NULL;
2622: END IF;
2623:
2620: THEN
2621: p_article_rec.attribute6 := NULL;
2622: END IF;
2623:
2624: IF p_article_rec.attribute7 = okc_api.g_miss_char
2625: THEN
2626: p_article_rec.attribute7 := NULL;
2627: END IF;
2628:
2625: THEN
2626: p_article_rec.attribute7 := NULL;
2627: END IF;
2628:
2629: IF p_article_rec.attribute8 = okc_api.g_miss_char
2630: THEN
2631: p_article_rec.attribute8 := NULL;
2632: END IF;
2633:
2630: THEN
2631: p_article_rec.attribute8 := NULL;
2632: END IF;
2633:
2634: IF p_article_rec.attribute9 = okc_api.g_miss_char
2635: THEN
2636: p_article_rec.attribute9 := NULL;
2637: END IF;
2638:
2635: THEN
2636: p_article_rec.attribute9 := NULL;
2637: END IF;
2638:
2639: IF p_article_rec.attribute10 = okc_api.g_miss_char
2640: THEN
2641: p_article_rec.attribute10 := NULL;
2642: END IF;
2643:
2640: THEN
2641: p_article_rec.attribute10 := NULL;
2642: END IF;
2643:
2644: IF p_article_rec.attribute11 = okc_api.g_miss_char
2645: THEN
2646: p_article_rec.attribute11 := NULL;
2647: END IF;
2648:
2645: THEN
2646: p_article_rec.attribute11 := NULL;
2647: END IF;
2648:
2649: IF p_article_rec.attribute12 = okc_api.g_miss_char
2650: THEN
2651: p_article_rec.attribute12 := NULL;
2652: END IF;
2653:
2650: THEN
2651: p_article_rec.attribute12 := NULL;
2652: END IF;
2653:
2654: IF p_article_rec.attribute13 = okc_api.g_miss_char
2655: THEN
2656: p_article_rec.attribute13 := NULL;
2657: END IF;
2658:
2655: THEN
2656: p_article_rec.attribute13 := NULL;
2657: END IF;
2658:
2659: IF p_article_rec.attribute14 = okc_api.g_miss_char
2660: THEN
2661: p_article_rec.attribute14 := NULL;
2662: END IF;
2663:
2660: THEN
2661: p_article_rec.attribute14 := NULL;
2662: END IF;
2663:
2664: IF p_article_rec.attribute15 = okc_api.g_miss_char
2665: THEN
2666: p_article_rec.attribute15 := NULL;
2667: END IF;
2668:
2665: THEN
2666: p_article_rec.attribute15 := NULL;
2667: END IF;
2668:
2669: IF p_article_rec.security_group_id = okc_api.g_miss_num
2670: THEN
2671: p_article_rec.security_group_id := NULL;
2672: END IF;
2673:
2670: THEN
2671: p_article_rec.security_group_id := NULL;
2672: END IF;
2673:
2674: IF p_article_rec.old_id = okc_api.g_miss_num
2675: THEN
2676: p_article_rec.old_id := NULL;
2677: END IF;
2678:
2675: THEN
2676: p_article_rec.old_id := NULL;
2677: END IF;
2678:
2679: IF p_article_rec.document_type = okc_api.g_miss_char
2680: OR p_article_rec.document_type IS NULL
2681: THEN
2682: p_article_rec.document_type := 'TEMPLATE';
2683: END IF;
2681: THEN
2682: p_article_rec.document_type := 'TEMPLATE';
2683: END IF;
2684:
2685: IF p_article_rec.document_id = okc_api.g_miss_num
2686: THEN
2687: p_article_rec.document_id := NULL;
2688: END IF;
2689:
2686: THEN
2687: p_article_rec.document_id := NULL;
2688: END IF;
2689:
2690: IF p_article_rec.source_flag = okc_api.g_miss_char
2691: THEN
2692: p_article_rec.source_flag := NULL;
2693: END IF;
2694:
2691: THEN
2692: p_article_rec.source_flag := NULL;
2693: END IF;
2694:
2695: IF p_article_rec.mandatory_yn = okc_api.g_miss_char
2696: THEN
2697: p_article_rec.mandatory_yn := 'N';
2698: END IF;
2699:
2697: p_article_rec.mandatory_yn := 'N';
2698: END IF;
2699:
2700: -- Rwa changes start
2701: IF p_article_rec.mandatory_rwa = okc_api.g_miss_char
2702: THEN
2703: p_article_rec.mandatory_rwa := NULL;
2704: END IF;
2705:
2703: p_article_rec.mandatory_rwa := NULL;
2704: END IF;
2705:
2706: -- Rwa changes end
2707: IF p_article_rec.scn_id = okc_api.g_miss_num
2708: THEN
2709: p_article_rec.scn_id := NULL;
2710: END IF;
2711:
2708: THEN
2709: p_article_rec.scn_id := NULL;
2710: END IF;
2711:
2712: IF p_article_rec.label = okc_api.g_miss_char
2713: THEN
2714: p_article_rec.label := NULL;
2715: END IF;
2716:
2713: THEN
2714: p_article_rec.label := NULL;
2715: END IF;
2716:
2717: IF p_article_rec.display_sequence = okc_api.g_miss_num
2718: THEN
2719: p_article_rec.display_sequence := NULL;
2720: END IF;
2721:
2718: THEN
2719: p_article_rec.display_sequence := NULL;
2720: END IF;
2721:
2722: IF p_article_rec.amendment_description = okc_api.g_miss_char
2723: THEN
2724: p_article_rec.amendment_description := NULL;
2725: END IF;
2726:
2723: THEN
2724: p_article_rec.amendment_description := NULL;
2725: END IF;
2726:
2727: IF p_article_rec.article_version_id = okc_api.g_miss_num
2728: THEN
2729: p_article_rec.article_version_id := NULL;
2730: END IF;
2731:
2728: THEN
2729: p_article_rec.article_version_id := NULL;
2730: END IF;
2731:
2732: IF p_article_rec.orig_system_reference_code = okc_api.g_miss_char
2733: THEN
2734: p_article_rec.orig_system_reference_code := NULL;
2735: END IF;
2736:
2733: THEN
2734: p_article_rec.orig_system_reference_code := NULL;
2735: END IF;
2736:
2737: IF p_article_rec.orig_system_reference_id1 = okc_api.g_miss_num
2738: THEN
2739: p_article_rec.orig_system_reference_id1 := NULL;
2740: END IF;
2741:
2738: THEN
2739: p_article_rec.orig_system_reference_id1 := NULL;
2740: END IF;
2741:
2742: IF p_article_rec.orig_system_reference_id2 = okc_api.g_miss_num
2743: THEN
2744: p_article_rec.orig_system_reference_id2 := NULL;
2745: END IF;
2746:
2743: THEN
2744: p_article_rec.orig_system_reference_id2 := NULL;
2745: END IF;
2746:
2747: IF p_article_rec.amendment_operation_code = okc_api.g_miss_char
2748: THEN
2749: p_article_rec.amendment_operation_code := NULL;
2750: END IF;
2751:
2748: THEN
2749: p_article_rec.amendment_operation_code := NULL;
2750: END IF;
2751:
2752: IF p_article_rec.summary_amend_operation_code = okc_api.g_miss_char
2753: THEN
2754: p_article_rec.summary_amend_operation_code := NULL;
2755: END IF;
2756:
2753: THEN
2754: p_article_rec.summary_amend_operation_code := NULL;
2755: END IF;
2756:
2757: IF p_article_rec.change_nonstd_yn = okc_api.g_miss_char
2758: THEN
2759: p_article_rec.change_nonstd_yn := 'N';
2760: END IF;
2761:
2758: THEN
2759: p_article_rec.change_nonstd_yn := 'N';
2760: END IF;
2761:
2762: IF p_article_rec.print_text_yn = okc_api.g_miss_char
2763: THEN
2764: p_article_rec.print_text_yn := 'N';
2765: END IF;
2766:
2763: THEN
2764: p_article_rec.print_text_yn := 'N';
2765: END IF;
2766:
2767: IF p_article_rec.ref_article_id = okc_api.g_miss_num
2768: THEN
2769: p_article_rec.ref_article_id := NULL;
2770: END IF;
2771:
2768: THEN
2769: p_article_rec.ref_article_id := NULL;
2770: END IF;
2771:
2772: IF p_article_rec.ref_article_version_id = okc_api.g_miss_num
2773: THEN
2774: p_article_rec.ref_article_version_id := NULL;
2775: END IF;
2776:
2773: THEN
2774: p_article_rec.ref_article_version_id := NULL;
2775: END IF;
2776:
2777: IF p_article_rec.orig_article_id = okc_api.g_miss_num
2778: THEN
2779: p_article_rec.orig_article_id := p_article_rec.sav_sae_id;
2780: END IF;
2781:
2778: THEN
2779: p_article_rec.orig_article_id := p_article_rec.sav_sae_id;
2780: END IF;
2781:
2782: IF p_article_rec.last_amended_by = okc_api.g_miss_num
2783: THEN
2784: p_article_rec.last_amended_by := NULL;
2785: END IF;
2786:
2783: THEN
2784: p_article_rec.last_amended_by := NULL;
2785: END IF;
2786:
2787: IF p_article_rec.last_amendment_date = okc_api.g_miss_date
2788: THEN
2789: p_article_rec.last_amendment_date := TO_DATE (NULL);
2790: END IF;
2791: END default_row;
2797: BEGIN
2798: -- Validate required fields can't be null
2799: IF p_article_rec.sav_sae_id IS NULL
2800: THEN
2801: okc_api.set_message (p_app_name => g_app_name,
2802: p_msg_name => 'OKC_I_NOT_NULL',
2803: p_token1 => 'FIELD',
2804: p_token1_value => 'SAV_SAE_ID'
2805: );
2807: END IF;
2808:
2809: IF p_article_rec.document_type IS NULL
2810: THEN
2811: okc_api.set_message (p_app_name => g_app_name,
2812: p_msg_name => 'OKC_I_NOT_NULL',
2813: p_token1 => 'FIELD',
2814: p_token1_value => 'DOCUMENT_TYPE'
2815: );
2817: END IF;
2818:
2819: IF p_article_rec.document_id IS NULL
2820: THEN
2821: okc_api.set_message (p_app_name => g_app_name,
2822: p_msg_name => 'OKC_I_NOT_NULL',
2823: p_token1 => 'FIELD',
2824: p_token1_value => 'DOCUMENT_ID'
2825: );
2827: END IF;
2828:
2829: IF p_article_rec.scn_id IS NULL
2830: THEN
2831: okc_api.set_message (p_app_name => g_app_name,
2832: p_msg_name => 'OKC_I_NOT_NULL',
2833: p_token1 => 'FIELD',
2834: p_token1_value => 'SCN_ID'
2835: );
2837: END IF;
2838:
2839: IF p_article_rec.display_sequence IS NULL
2840: THEN
2841: okc_api.set_message (p_app_name => g_app_name,
2842: p_msg_name => 'OKC_I_NOT_NULL',
2843: p_token1 => 'FIELD',
2844: p_token1_value => 'DISPLAY_SEQUENCE'
2845: );
2850: /*
2851: IF inittemplateinfo (p_template_id => p_article_rec.document_id) <>
2852: 'Y'
2853: THEN
2854: okc_api.set_message (p_app_name => g_app_name,
2855: p_msg_name => 'OKC_I_INVALID_VALUE',
2856: p_token1 => 'FIELD',
2857: p_token1_value => 'TEMPLATE_ID'
2858: );
2860: END IF; */
2861: IF isvalidou (p_org_id => g_template_org_id) <> 'Y'
2862: THEN
2863: -- Can'not access template from this resp
2864: okc_api.set_message
2865: (p_app_name => g_app_name,
2866: p_msg_name => 'Can not access Template. Please change the responsibility'
2867: );
2868: RAISE fnd_api.g_exc_error;
2876: p_intent => g_template_intent
2877: )
2878: ) <> 'Y'
2879: THEN
2880: okc_api.set_message (p_app_name => g_app_name,
2881: p_msg_name => 'OKC_I_INVALID_VALUE',
2882: p_token1 => 'FIELD',
2883: p_token1_value => 'SAV_SAE_ID'
2884: );
2894: IF isvalidsection (p_template_id => p_article_rec.document_id,
2895: p_scn_id => p_article_rec.scn_id
2896: ) <> 'Y'
2897: THEN
2898: okc_api.set_message (p_app_name => g_app_name,
2899: p_msg_name => 'OKC_I_INVALID_VALUE',
2900: p_token1 => 'FIELD',
2901: p_token1_value => 'SCN_ID'
2902: );
2906: /* RWA Changes Start */
2907: IF p_article_rec.mandatory_yn IS NOT NULL
2908: AND p_article_rec.mandatory_yn NOT IN ('Y', 'N')
2909: THEN
2910: okc_api.set_message (p_app_name => g_app_name,
2911: p_msg_name => 'OKC_I_INVALID_VALUE',
2912: p_token1 => 'FIELD',
2913: p_token1_value => 'MANDATORY_YN'
2914: );
2918: IF p_article_rec.mandatory_rwa IS NOT NULL
2919: AND isvalidlookup ('OKC_CLAUSE_RWA', p_article_rec.mandatory_rwa) =
2920: 'N'
2921: THEN
2922: okc_api.set_message (p_app_name => g_app_name,
2923: p_msg_name => 'OKC_I_INVALID_VALUE',
2924: p_token1 => 'FIELD',
2925: p_token1_value => 'MANDATORY_RWA'
2926: );
2942: THEN
2943: IF inittemplateinfo (p_template_id => p_article_rec.document_id) <>
2944: 'Y'
2945: THEN
2946: okc_api.set_message (p_app_name => g_app_name,
2947: p_msg_name => 'OKC_I_INVALID_VALUE',
2948: p_token1 => 'FIELD',
2949: p_token1_value => 'TEMPLATE_ID'
2950: );
2953: END IF;
2954:
2955: IF g_clause_update_allowed <> 'Y'
2956: THEN
2957: okc_api.set_message (p_app_name => g_app_name,
2958: p_msg_name => 'OKC_I_TEMP_STS_NO_INS_OBJ',
2959: p_token1 => 'STATUS',
2960: p_token1_value => g_template_status_code,
2961: p_token2 => 'OBJECT',
3079: WHEN OTHERS
3080: THEN
3081: p_article_rec.status := g_ret_sts_error;
3082: set_proc_error_message (p_proc => l_proc);
3083: okc_api.set_message (p_app_name => g_app_name,
3084: p_msg_name => g_unexpected_error,
3085: p_token1 => g_sqlcode_token,
3086: p_token1_value => SQLCODE,
3087: p_token2 => g_sqlerrm_token,
3133:
3134: -- PRE-VALIDATION
3135: IF inittemplateinfo (p_template_id => p_template_id) <> 'Y'
3136: THEN
3137: okc_api.set_message (p_app_name => g_app_name,
3138: p_msg_name => 'OKC_I_INVALID_VALUE',
3139: p_token1 => 'FIELD',
3140: p_token1_value => 'TEMPLATE_ID'
3141: );
3143: END IF;
3144:
3145: IF g_template_status_code <> 'APPROVED'
3146: THEN
3147: okc_api.set_message (p_app_name => g_app_name,
3148: p_msg_name => 'OKC_TERMS_REV_TMPL_INVALID',
3149: p_token1 => 'STATUS',
3150: p_token1_value => g_template_status_code
3151: );
3174: WHEN OTHERS
3175: THEN
3176: x_return_status := g_ret_sts_error;
3177: set_proc_error_message (p_proc => l_proc);
3178: okc_api.set_message (p_app_name => g_app_name,
3179: p_msg_name => g_unexpected_error,
3180: p_token1 => g_sqlcode_token,
3181: p_token1_value => SQLCODE,
3182: p_token2 => g_sqlerrm_token,
3202: IF p_template_id <> NVL (g_template_id, -1)
3203: THEN
3204: IF inittemplateinfo (p_template_id => p_template_id) <> 'Y'
3205: THEN
3206: okc_api.set_message (p_app_name => g_app_name,
3207: p_msg_name => 'OKC_I_INVALID_VALUE',
3208: p_token1 => 'FIELD',
3209: p_token1_value => 'TEMPLATE_ID'
3210: );
3214:
3215: -- Validate Template OU also:
3216: IF g_clause_update_allowed <> 'Y'
3217: THEN
3218: okc_api.set_message (p_app_name => g_app_name,
3219: p_msg_name => 'OKC_I_TEMP_STS_NO_DEL_OBJ',
3220: p_token1 => 'STATUS',
3221: p_token1_value => g_template_status_code,
3222: p_token2 => 'OBJECT',
3255: WHEN OTHERS
3256: THEN
3257: x_return_status := g_ret_sts_error;
3258: set_proc_error_message (p_proc => l_proc);
3259: okc_api.set_message (p_app_name => g_app_name,
3260: p_msg_name => g_unexpected_error,
3261: p_token1 => g_sqlcode_token,
3262: p_token1_value => SQLCODE,
3263: p_token2 => g_sqlerrm_token,
3290: IF p_template_id <> NVL (g_template_id, -1)
3291: THEN
3292: IF inittemplateinfo (p_template_id => p_template_id) <> 'Y'
3293: THEN
3294: okc_api.set_message (p_app_name => g_app_name,
3295: p_msg_name => 'OKC_I_INVALID_VALUE',
3296: p_token1 => 'FIELD',
3297: p_token1_value => 'TEMPLATE_ID'
3298: );
3301: END IF;
3302:
3303: IF g_clause_update_allowed <> 'Y'
3304: THEN
3305: okc_api.set_message (p_app_name => g_app_name,
3306: p_msg_name => 'OKC_I_TEMP_STS_NO_DEL_OBJ',
3307: p_token1 => 'STATUS',
3308: p_token1_value => g_template_status_code,
3309: p_token2 => 'OBJECT',
3348: WHEN OTHERS
3349: THEN
3350: x_return_status := g_ret_sts_error;
3351: set_proc_error_message (p_proc => l_proc);
3352: okc_api.set_message (p_app_name => g_app_name,
3353: p_msg_name => g_unexpected_error,
3354: p_token1 => g_sqlcode_token,
3355: p_token1_value => SQLCODE,
3356: p_token2 => g_sqlerrm_token,
3390: p_deliverable_rec IN OUT NOCOPY deliverable_rec_type
3391: )
3392: IS
3393: BEGIN
3394: IF p_deliverable_rec.deliverable_id = okc_api.g_miss_num
3395: THEN
3396: SELECT okc_deliverable_id_s.NEXTVAL
3397: INTO p_deliverable_rec.deliverable_id
3398: FROM DUAL;
3397: INTO p_deliverable_rec.deliverable_id
3398: FROM DUAL;
3399: END IF;
3400:
3401: IF p_deliverable_rec.business_document_type = okc_api.g_miss_char
3402: THEN
3403: p_deliverable_rec.business_document_type := 'TEMPLATE';
3404: END IF;
3405:
3402: THEN
3403: p_deliverable_rec.business_document_type := 'TEMPLATE';
3404: END IF;
3405:
3406: IF p_deliverable_rec.business_document_id = okc_api.g_miss_num
3407: THEN
3408: p_deliverable_rec.business_document_id := NULL;
3409: END IF;
3410:
3407: THEN
3408: p_deliverable_rec.business_document_id := NULL;
3409: END IF;
3410:
3411: IF p_deliverable_rec.business_document_number = okc_api.g_miss_char
3412: THEN
3413: p_deliverable_rec.business_document_number := NULL;
3414: END IF;
3415:
3412: THEN
3413: p_deliverable_rec.business_document_number := NULL;
3414: END IF;
3415:
3416: IF p_deliverable_rec.deliverable_type = okc_api.g_miss_char
3417: THEN
3418: p_deliverable_rec.deliverable_type := NULL;
3419: END IF;
3420:
3417: THEN
3418: p_deliverable_rec.deliverable_type := NULL;
3419: END IF;
3420:
3421: IF p_deliverable_rec.responsible_party = okc_api.g_miss_char
3422: THEN
3423: p_deliverable_rec.responsible_party := NULL;
3424: END IF;
3425:
3422: THEN
3423: p_deliverable_rec.responsible_party := NULL;
3424: END IF;
3425:
3426: IF p_deliverable_rec.internal_party_contact_id = okc_api.g_miss_num
3427: THEN
3428: p_deliverable_rec.internal_party_contact_id := NULL;
3429: END IF;
3430:
3427: THEN
3428: p_deliverable_rec.internal_party_contact_id := NULL;
3429: END IF;
3430:
3431: IF p_deliverable_rec.external_party_contact_id = okc_api.g_miss_num
3432: THEN
3433: p_deliverable_rec.external_party_contact_id := NULL;
3434: END IF;
3435:
3432: THEN
3433: p_deliverable_rec.external_party_contact_id := NULL;
3434: END IF;
3435:
3436: IF p_deliverable_rec.deliverable_name = okc_api.g_miss_char
3437: THEN
3438: p_deliverable_rec.deliverable_name := NULL;
3439: END IF;
3440:
3437: THEN
3438: p_deliverable_rec.deliverable_name := NULL;
3439: END IF;
3440:
3441: IF p_deliverable_rec.description = okc_api.g_miss_char
3442: THEN
3443: p_deliverable_rec.description := NULL;
3444: END IF;
3445:
3442: THEN
3443: p_deliverable_rec.description := NULL;
3444: END IF;
3445:
3446: IF p_deliverable_rec.comments = okc_api.g_miss_char
3447: THEN
3448: p_deliverable_rec.comments := NULL;
3449: END IF;
3450:
3447: THEN
3448: p_deliverable_rec.comments := NULL;
3449: END IF;
3450:
3451: IF p_deliverable_rec.display_sequence = okc_api.g_miss_num
3452: THEN
3453: p_deliverable_rec.display_sequence :=
3454: getdeldisplaysequence (p_deliverable_rec.deliverable_id);
3455: END IF;
3453: p_deliverable_rec.display_sequence :=
3454: getdeldisplaysequence (p_deliverable_rec.deliverable_id);
3455: END IF;
3456:
3457: IF p_deliverable_rec.fixed_due_date_yn = okc_api.g_miss_char
3458: THEN
3459: p_deliverable_rec.fixed_due_date_yn := 'Y';
3460: END IF;
3461:
3458: THEN
3459: p_deliverable_rec.fixed_due_date_yn := 'Y';
3460: END IF;
3461:
3462: IF p_deliverable_rec.actual_due_date = okc_api.g_miss_date
3463: THEN
3464: p_deliverable_rec.actual_due_date := NULL;
3465: END IF;
3466:
3463: THEN
3464: p_deliverable_rec.actual_due_date := NULL;
3465: END IF;
3466:
3467: IF p_deliverable_rec.print_due_date_msg_name = okc_api.g_miss_char
3468: THEN
3469: p_deliverable_rec.print_due_date_msg_name := NULL;
3470: END IF;
3471:
3468: THEN
3469: p_deliverable_rec.print_due_date_msg_name := NULL;
3470: END IF;
3471:
3472: IF p_deliverable_rec.recurring_yn = okc_api.g_miss_char
3473: THEN
3474: p_deliverable_rec.recurring_yn := 'N';
3475: END IF;
3476:
3473: THEN
3474: p_deliverable_rec.recurring_yn := 'N';
3475: END IF;
3476:
3477: IF p_deliverable_rec.notify_prior_due_date_value = okc_api.g_miss_num
3478: THEN
3479: p_deliverable_rec.notify_prior_due_date_value := NULL;
3480: END IF;
3481:
3478: THEN
3479: p_deliverable_rec.notify_prior_due_date_value := NULL;
3480: END IF;
3481:
3482: IF p_deliverable_rec.notify_prior_due_date_uom = okc_api.g_miss_char
3483: THEN
3484: p_deliverable_rec.notify_prior_due_date_uom := NULL;
3485: END IF;
3486:
3483: THEN
3484: p_deliverable_rec.notify_prior_due_date_uom := NULL;
3485: END IF;
3486:
3487: IF p_deliverable_rec.notify_prior_due_date_yn = okc_api.g_miss_char
3488: THEN
3489: p_deliverable_rec.notify_prior_due_date_yn := 'N';
3490: END IF;
3491:
3488: THEN
3489: p_deliverable_rec.notify_prior_due_date_yn := 'N';
3490: END IF;
3491:
3492: IF p_deliverable_rec.notify_completed_yn = okc_api.g_miss_char
3493: THEN
3494: p_deliverable_rec.notify_completed_yn := 'N';
3495: END IF;
3496:
3493: THEN
3494: p_deliverable_rec.notify_completed_yn := 'N';
3495: END IF;
3496:
3497: IF p_deliverable_rec.notify_overdue_yn = okc_api.g_miss_char
3498: THEN
3499: p_deliverable_rec.notify_overdue_yn := 'N';
3500: END IF;
3501:
3498: THEN
3499: p_deliverable_rec.notify_overdue_yn := 'N';
3500: END IF;
3501:
3502: IF p_deliverable_rec.notify_escalation_yn = okc_api.g_miss_char
3503: THEN
3504: p_deliverable_rec.notify_escalation_yn := 'N';
3505: END IF;
3506:
3503: THEN
3504: p_deliverable_rec.notify_escalation_yn := 'N';
3505: END IF;
3506:
3507: IF p_deliverable_rec.notify_escalation_value = okc_api.g_miss_num
3508: THEN
3509: p_deliverable_rec.notify_escalation_value := NULL;
3510: END IF;
3511:
3508: THEN
3509: p_deliverable_rec.notify_escalation_value := NULL;
3510: END IF;
3511:
3512: IF p_deliverable_rec.notify_escalation_uom = okc_api.g_miss_char
3513: THEN
3514: p_deliverable_rec.notify_escalation_uom := NULL;
3515: END IF;
3516:
3513: THEN
3514: p_deliverable_rec.notify_escalation_uom := NULL;
3515: END IF;
3516:
3517: IF p_deliverable_rec.escalation_assignee = okc_api.g_miss_num
3518: THEN
3519: p_deliverable_rec.escalation_assignee := NULL;
3520: END IF;
3521:
3518: THEN
3519: p_deliverable_rec.escalation_assignee := NULL;
3520: END IF;
3521:
3522: IF p_deliverable_rec.amendment_operation = okc_api.g_miss_char
3523: THEN
3524: p_deliverable_rec.amendment_operation := NULL;
3525: END IF;
3526:
3523: THEN
3524: p_deliverable_rec.amendment_operation := NULL;
3525: END IF;
3526:
3527: IF p_deliverable_rec.prior_notification_id = okc_api.g_miss_num
3528: THEN
3529: p_deliverable_rec.prior_notification_id := NULL;
3530: END IF;
3531:
3528: THEN
3529: p_deliverable_rec.prior_notification_id := NULL;
3530: END IF;
3531:
3532: IF p_deliverable_rec.amendment_notes = okc_api.g_miss_char
3533: THEN
3534: p_deliverable_rec.amendment_notes := NULL;
3535: END IF;
3536:
3533: THEN
3534: p_deliverable_rec.amendment_notes := NULL;
3535: END IF;
3536:
3537: IF p_deliverable_rec.completed_notification_id = okc_api.g_miss_num
3538: THEN
3539: p_deliverable_rec.completed_notification_id := NULL;
3540: END IF;
3541:
3538: THEN
3539: p_deliverable_rec.completed_notification_id := NULL;
3540: END IF;
3541:
3542: IF p_deliverable_rec.overdue_notification_id = okc_api.g_miss_num
3543: THEN
3544: p_deliverable_rec.overdue_notification_id := NULL;
3545: END IF;
3546:
3543: THEN
3544: p_deliverable_rec.overdue_notification_id := NULL;
3545: END IF;
3546:
3547: IF p_deliverable_rec.escalation_notification_id = okc_api.g_miss_num
3548: THEN
3549: p_deliverable_rec.escalation_notification_id := NULL;
3550: END IF;
3551:
3548: THEN
3549: p_deliverable_rec.escalation_notification_id := NULL;
3550: END IF;
3551:
3552: IF p_deliverable_rec.LANGUAGE = okc_api.g_miss_char
3553: THEN
3554: p_deliverable_rec.LANGUAGE := USERENV ('Lang');
3555: END IF;
3556:
3553: THEN
3554: p_deliverable_rec.LANGUAGE := USERENV ('Lang');
3555: END IF;
3556:
3557: IF p_deliverable_rec.original_deliverable_id = okc_api.g_miss_num
3558: THEN
3559: p_deliverable_rec.original_deliverable_id :=
3560: p_deliverable_rec.deliverable_id;
3561: END IF;
3559: p_deliverable_rec.original_deliverable_id :=
3560: p_deliverable_rec.deliverable_id;
3561: END IF;
3562:
3563: IF p_deliverable_rec.requester_id = okc_api.g_miss_num
3564: THEN
3565: p_deliverable_rec.requester_id := NULL;
3566: END IF;
3567:
3564: THEN
3565: p_deliverable_rec.requester_id := NULL;
3566: END IF;
3567:
3568: IF p_deliverable_rec.external_party_id = okc_api.g_miss_num
3569: THEN
3570: p_deliverable_rec.external_party_id := NULL;
3571: END IF;
3572:
3569: THEN
3570: p_deliverable_rec.external_party_id := NULL;
3571: END IF;
3572:
3573: IF p_deliverable_rec.recurring_del_parent_id = okc_api.g_miss_num
3574: THEN
3575: p_deliverable_rec.recurring_del_parent_id := NULL;
3576: END IF;
3577:
3574: THEN
3575: p_deliverable_rec.recurring_del_parent_id := NULL;
3576: END IF;
3577:
3578: --IF p_deliverable_rec.business_document_version = okc_api.g_miss_num
3579: --THEN
3580: p_deliverable_rec.business_document_version := -99;
3581:
3582: --END IF;
3579: --THEN
3580: p_deliverable_rec.business_document_version := -99;
3581:
3582: --END IF;
3583: IF p_deliverable_rec.relative_st_date_duration = okc_api.g_miss_num
3584: THEN
3585: p_deliverable_rec.relative_st_date_duration := NULL;
3586: END IF;
3587:
3584: THEN
3585: p_deliverable_rec.relative_st_date_duration := NULL;
3586: END IF;
3587:
3588: IF p_deliverable_rec.relative_st_date_uom = okc_api.g_miss_char
3589: THEN
3590: p_deliverable_rec.relative_st_date_uom := NULL;
3591: END IF;
3592:
3589: THEN
3590: p_deliverable_rec.relative_st_date_uom := NULL;
3591: END IF;
3592:
3593: IF p_deliverable_rec.relative_st_date_event_id = okc_api.g_miss_num
3594: THEN
3595: p_deliverable_rec.relative_st_date_event_id := NULL;
3596: END IF;
3597:
3594: THEN
3595: p_deliverable_rec.relative_st_date_event_id := NULL;
3596: END IF;
3597:
3598: IF p_deliverable_rec.relative_end_date_duration = okc_api.g_miss_num
3599: THEN
3600: p_deliverable_rec.relative_end_date_duration := NULL;
3601: END IF;
3602:
3599: THEN
3600: p_deliverable_rec.relative_end_date_duration := NULL;
3601: END IF;
3602:
3603: IF p_deliverable_rec.relative_end_date_uom = okc_api.g_miss_char
3604: THEN
3605: p_deliverable_rec.relative_end_date_uom := NULL;
3606: END IF;
3607:
3604: THEN
3605: p_deliverable_rec.relative_end_date_uom := NULL;
3606: END IF;
3607:
3608: IF p_deliverable_rec.relative_end_date_event_id = okc_api.g_miss_num
3609: THEN
3610: p_deliverable_rec.relative_end_date_event_id := NULL;
3611: END IF;
3612:
3609: THEN
3610: p_deliverable_rec.relative_end_date_event_id := NULL;
3611: END IF;
3612:
3613: IF p_deliverable_rec.repeating_day_of_month = okc_api.g_miss_char
3614: THEN
3615: p_deliverable_rec.repeating_day_of_month := NULL;
3616: END IF;
3617:
3614: THEN
3615: p_deliverable_rec.repeating_day_of_month := NULL;
3616: END IF;
3617:
3618: IF p_deliverable_rec.repeating_day_of_week = okc_api.g_miss_char
3619: THEN
3620: p_deliverable_rec.repeating_day_of_week := NULL;
3621: END IF;
3622:
3619: THEN
3620: p_deliverable_rec.repeating_day_of_week := NULL;
3621: END IF;
3622:
3623: IF p_deliverable_rec.repeating_frequency_uom = okc_api.g_miss_char
3624: THEN
3625: p_deliverable_rec.repeating_frequency_uom := NULL;
3626: END IF;
3627:
3624: THEN
3625: p_deliverable_rec.repeating_frequency_uom := NULL;
3626: END IF;
3627:
3628: IF p_deliverable_rec.repeating_duration = okc_api.g_miss_num
3629: THEN
3630: p_deliverable_rec.repeating_duration := NULL;
3631: END IF;
3632:
3629: THEN
3630: p_deliverable_rec.repeating_duration := NULL;
3631: END IF;
3632:
3633: IF p_deliverable_rec.fixed_start_date = okc_api.g_miss_date
3634: THEN
3635: p_deliverable_rec.fixed_start_date := NULL;
3636: END IF;
3637:
3634: THEN
3635: p_deliverable_rec.fixed_start_date := NULL;
3636: END IF;
3637:
3638: IF p_deliverable_rec.fixed_end_date = okc_api.g_miss_date
3639: THEN
3640: p_deliverable_rec.fixed_end_date := NULL;
3641: END IF;
3642:
3639: THEN
3640: p_deliverable_rec.fixed_end_date := NULL;
3641: END IF;
3642:
3643: IF p_deliverable_rec.manage_yn = okc_api.g_miss_char
3644: THEN
3645: p_deliverable_rec.manage_yn := 'N';
3646: END IF;
3647:
3644: THEN
3645: p_deliverable_rec.manage_yn := 'N';
3646: END IF;
3647:
3648: IF p_deliverable_rec.internal_party_id = okc_api.g_miss_num
3649: THEN
3650: p_deliverable_rec.internal_party_id := NULL;
3651: END IF;
3652:
3649: THEN
3650: p_deliverable_rec.internal_party_id := NULL;
3651: END IF;
3652:
3653: --IF p_deliverable_rec.deliverable_status = okc_api.g_miss_char
3654: --THEN
3655: p_deliverable_rec.deliverable_status := 'INACTIVE';
3656:
3657: --END IF;
3654: --THEN
3655: p_deliverable_rec.deliverable_status := 'INACTIVE';
3656:
3657: --END IF;
3658: IF p_deliverable_rec.status_change_notes = okc_api.g_miss_char
3659: THEN
3660: p_deliverable_rec.status_change_notes := NULL;
3661: END IF;
3662:
3659: THEN
3660: p_deliverable_rec.status_change_notes := NULL;
3661: END IF;
3662:
3663: IF p_deliverable_rec.created_by = okc_api.g_miss_num
3664: THEN
3665: p_deliverable_rec.created_by := fnd_global.user_id;
3666: END IF;
3667:
3664: THEN
3665: p_deliverable_rec.created_by := fnd_global.user_id;
3666: END IF;
3667:
3668: IF p_deliverable_rec.creation_date = okc_api.g_miss_date
3669: THEN
3670: p_deliverable_rec.creation_date := SYSDATE;
3671: END IF;
3672:
3669: THEN
3670: p_deliverable_rec.creation_date := SYSDATE;
3671: END IF;
3672:
3673: IF p_deliverable_rec.last_updated_by = okc_api.g_miss_num
3674: THEN
3675: p_deliverable_rec.last_updated_by := fnd_global.user_id;
3676: END IF;
3677:
3674: THEN
3675: p_deliverable_rec.last_updated_by := fnd_global.user_id;
3676: END IF;
3677:
3678: IF p_deliverable_rec.last_update_date = okc_api.g_miss_date
3679: THEN
3680: p_deliverable_rec.last_update_date := SYSDATE;
3681: END IF;
3682:
3679: THEN
3680: p_deliverable_rec.last_update_date := SYSDATE;
3681: END IF;
3682:
3683: IF p_deliverable_rec.last_update_login = okc_api.g_miss_num
3684: THEN
3685: p_deliverable_rec.last_update_login := fnd_global.login_id;
3686: END IF;
3687:
3684: THEN
3685: p_deliverable_rec.last_update_login := fnd_global.login_id;
3686: END IF;
3687:
3688: IF p_deliverable_rec.object_version_number = okc_api.g_miss_num
3689: THEN
3690: p_deliverable_rec.object_version_number := 1;
3691: END IF;
3692:
3689: THEN
3690: p_deliverable_rec.object_version_number := 1;
3691: END IF;
3692:
3693: IF p_deliverable_rec.attribute_category = okc_api.g_miss_char
3694: THEN
3695: p_deliverable_rec.attribute_category := NULL;
3696: END IF;
3697:
3694: THEN
3695: p_deliverable_rec.attribute_category := NULL;
3696: END IF;
3697:
3698: IF p_deliverable_rec.attribute1 = okc_api.g_miss_char
3699: THEN
3700: p_deliverable_rec.attribute1 := NULL;
3701: END IF;
3702:
3699: THEN
3700: p_deliverable_rec.attribute1 := NULL;
3701: END IF;
3702:
3703: IF p_deliverable_rec.attribute2 = okc_api.g_miss_char
3704: THEN
3705: p_deliverable_rec.attribute2 := NULL;
3706: END IF;
3707:
3704: THEN
3705: p_deliverable_rec.attribute2 := NULL;
3706: END IF;
3707:
3708: IF p_deliverable_rec.attribute3 = okc_api.g_miss_char
3709: THEN
3710: p_deliverable_rec.attribute3 := NULL;
3711: END IF;
3712:
3709: THEN
3710: p_deliverable_rec.attribute3 := NULL;
3711: END IF;
3712:
3713: IF p_deliverable_rec.attribute4 = okc_api.g_miss_char
3714: THEN
3715: p_deliverable_rec.attribute4 := NULL;
3716: END IF;
3717:
3714: THEN
3715: p_deliverable_rec.attribute4 := NULL;
3716: END IF;
3717:
3718: IF p_deliverable_rec.attribute5 = okc_api.g_miss_char
3719: THEN
3720: p_deliverable_rec.attribute5 := NULL;
3721: END IF;
3722:
3719: THEN
3720: p_deliverable_rec.attribute5 := NULL;
3721: END IF;
3722:
3723: IF p_deliverable_rec.attribute6 = okc_api.g_miss_char
3724: THEN
3725: p_deliverable_rec.attribute6 := NULL;
3726: END IF;
3727:
3724: THEN
3725: p_deliverable_rec.attribute6 := NULL;
3726: END IF;
3727:
3728: IF p_deliverable_rec.attribute7 = okc_api.g_miss_char
3729: THEN
3730: p_deliverable_rec.attribute7 := NULL;
3731: END IF;
3732:
3729: THEN
3730: p_deliverable_rec.attribute7 := NULL;
3731: END IF;
3732:
3733: IF p_deliverable_rec.attribute8 = okc_api.g_miss_char
3734: THEN
3735: p_deliverable_rec.attribute8 := NULL;
3736: END IF;
3737:
3734: THEN
3735: p_deliverable_rec.attribute8 := NULL;
3736: END IF;
3737:
3738: IF p_deliverable_rec.attribute9 = okc_api.g_miss_char
3739: THEN
3740: p_deliverable_rec.attribute9 := NULL;
3741: END IF;
3742:
3739: THEN
3740: p_deliverable_rec.attribute9 := NULL;
3741: END IF;
3742:
3743: IF p_deliverable_rec.attribute10 = okc_api.g_miss_char
3744: THEN
3745: p_deliverable_rec.attribute10 := NULL;
3746: END IF;
3747:
3744: THEN
3745: p_deliverable_rec.attribute10 := NULL;
3746: END IF;
3747:
3748: IF p_deliverable_rec.attribute11 = okc_api.g_miss_char
3749: THEN
3750: p_deliverable_rec.attribute11 := NULL;
3751: END IF;
3752:
3749: THEN
3750: p_deliverable_rec.attribute11 := NULL;
3751: END IF;
3752:
3753: IF p_deliverable_rec.attribute12 = okc_api.g_miss_char
3754: THEN
3755: p_deliverable_rec.attribute12 := NULL;
3756: END IF;
3757:
3754: THEN
3755: p_deliverable_rec.attribute12 := NULL;
3756: END IF;
3757:
3758: IF p_deliverable_rec.attribute13 = okc_api.g_miss_char
3759: THEN
3760: p_deliverable_rec.attribute13 := NULL;
3761: END IF;
3762:
3759: THEN
3760: p_deliverable_rec.attribute13 := NULL;
3761: END IF;
3762:
3763: IF p_deliverable_rec.attribute14 = okc_api.g_miss_char
3764: THEN
3765: p_deliverable_rec.attribute14 := NULL;
3766: END IF;
3767:
3764: THEN
3765: p_deliverable_rec.attribute14 := NULL;
3766: END IF;
3767:
3768: IF p_deliverable_rec.attribute15 = okc_api.g_miss_char
3769: THEN
3770: p_deliverable_rec.attribute15 := NULL;
3771: END IF;
3772:
3769: THEN
3770: p_deliverable_rec.attribute15 := NULL;
3771: END IF;
3772:
3773: IF p_deliverable_rec.disable_notifications_yn = okc_api.g_miss_char
3774: THEN
3775: p_deliverable_rec.disable_notifications_yn := 'N';
3776: END IF;
3777:
3774: THEN
3775: p_deliverable_rec.disable_notifications_yn := 'N';
3776: END IF;
3777:
3778: IF p_deliverable_rec.last_amendment_date = okc_api.g_miss_date
3779: THEN
3780: p_deliverable_rec.last_amendment_date := NULL;
3781: END IF;
3782:
3779: THEN
3780: p_deliverable_rec.last_amendment_date := NULL;
3781: END IF;
3782:
3783: IF p_deliverable_rec.business_document_line_id = okc_api.g_miss_num
3784: THEN
3785: p_deliverable_rec.business_document_line_id := NULL;
3786: END IF;
3787:
3784: THEN
3785: p_deliverable_rec.business_document_line_id := NULL;
3786: END IF;
3787:
3788: IF p_deliverable_rec.external_party_site_id = okc_api.g_miss_num
3789: THEN
3790: p_deliverable_rec.external_party_site_id := NULL;
3791: END IF;
3792:
3789: THEN
3790: p_deliverable_rec.external_party_site_id := NULL;
3791: END IF;
3792:
3793: IF p_deliverable_rec.start_event_date = okc_api.g_miss_date
3794: THEN
3795: p_deliverable_rec.start_event_date := NULL;
3796: END IF;
3797:
3794: THEN
3795: p_deliverable_rec.start_event_date := NULL;
3796: END IF;
3797:
3798: IF p_deliverable_rec.end_event_date = okc_api.g_miss_date
3799: THEN
3800: p_deliverable_rec.end_event_date := NULL;
3801: END IF;
3802:
3800: p_deliverable_rec.end_event_date := NULL;
3801: END IF;
3802:
3803: IF p_deliverable_rec.summary_amend_operation_code =
3804: okc_api.g_miss_char
3805: THEN
3806: p_deliverable_rec.summary_amend_operation_code := NULL;
3807: END IF;
3808:
3805: THEN
3806: p_deliverable_rec.summary_amend_operation_code := NULL;
3807: END IF;
3808:
3809: IF p_deliverable_rec.external_party_role = okc_api.g_miss_char
3810: THEN
3811: p_deliverable_rec.external_party_role := NULL;
3812: END IF;
3813:
3810: THEN
3811: p_deliverable_rec.external_party_role := NULL;
3812: END IF;
3813:
3814: IF p_deliverable_rec.pay_hold_prior_due_date_yn = okc_api.g_miss_char
3815: THEN
3816: p_deliverable_rec.pay_hold_prior_due_date_yn := NULL;
3817: END IF;
3818:
3816: p_deliverable_rec.pay_hold_prior_due_date_yn := NULL;
3817: END IF;
3818:
3819: IF p_deliverable_rec.pay_hold_prior_due_date_value =
3820: okc_api.g_miss_num
3821: THEN
3822: p_deliverable_rec.pay_hold_prior_due_date_value := NULL;
3823: END IF;
3824:
3822: p_deliverable_rec.pay_hold_prior_due_date_value := NULL;
3823: END IF;
3824:
3825: IF p_deliverable_rec.pay_hold_prior_due_date_uom =
3826: okc_api.g_miss_char
3827: THEN
3828: p_deliverable_rec.pay_hold_prior_due_date_uom := NULL;
3829: END IF;
3830:
3827: THEN
3828: p_deliverable_rec.pay_hold_prior_due_date_uom := NULL;
3829: END IF;
3830:
3831: IF p_deliverable_rec.pay_hold_overdue_yn = okc_api.g_miss_char
3832: THEN
3833: p_deliverable_rec.pay_hold_overdue_yn := NULL;
3834: END IF;
3835:
3832: THEN
3833: p_deliverable_rec.pay_hold_overdue_yn := NULL;
3834: END IF;
3835:
3836: IF p_deliverable_rec.raise_completion_event_yn = okc_api.g_miss_char
3837: THEN
3838: p_deliverable_rec.raise_completion_event_yn := NULL;
3839: END IF;
3840: END default_row;
3862:
3863: -- Business Document Type must be 'TEMPLATE'
3864: IF p_deliverable_rec.business_document_type <> 'TEMPLATE'
3865: THEN
3866: okc_api.set_message (p_app_name => g_app_name,
3867: p_msg_name => 'OKC_I_INVALID_VALUE',
3868: p_token1 => 'FIELD',
3869: p_token1_value => 'BUSINESS_DOCUMENT_TYPE'
3870: );
3874: -- Validate the Deliverable Type
3875: IF p_deliverable_rec.deliverable_type NOT IN
3876: ('CONTRACTUAL', 'INTERNAL_PURCHASING', 'SOURCING')
3877: THEN
3878: okc_api.set_message (p_app_name => g_app_name,
3879: p_msg_name => 'OKC_I_INVALID_VALUE',
3880: p_token1 => 'FIELD',
3881: p_token1_value => 'DELIVERABLE_TYPE'
3882: );
3893: AND p_deliverable_rec.responsible_party <> 'BUYER_ORG'
3894: )
3895: )
3896: THEN
3897: okc_api.set_message (p_app_name => g_app_name,
3898: p_msg_name => 'OKC_I_INVALID_VALUE',
3899: p_token1 => 'FIELD',
3900: p_token1_value => 'RESPONSIBLE_PARTY'
3901: );
3905: IF p_deliverable_rec.internal_party_contact_id IS NOT NULL
3906: AND isvalidcontact (p_deliverable_rec.internal_party_contact_id) <>
3907: 'Y'
3908: THEN
3909: okc_api.set_message (p_app_name => g_app_name,
3910: p_msg_name => 'OKC_I_INVALID_VALUE',
3911: p_token1 => 'FIELD',
3912: p_token1_value => 'RESPONSIBLE_PARTY'
3913: );
3916:
3917: IF p_deliverable_rec.requester_id IS NOT NULL
3918: AND isvalidcontact (p_deliverable_rec.requester_id) <> 'Y'
3919: THEN
3920: okc_api.set_message (p_app_name => g_app_name,
3921: p_msg_name => 'OKC_I_INVALID_VALUE',
3922: p_token1 => 'FIELD',
3923: p_token1_value => 'REQUESTER_ID'
3924: );
3926: END IF;
3927:
3928: IF p_deliverable_rec.deliverable_name IS NULL
3929: THEN
3930: okc_api.set_message (p_app_name => g_app_name,
3931: p_msg_name => 'OKC_I_NOT_NULL',
3932: p_token1 => 'FIELD',
3933: p_token1_value => 'DELIVERABLE_NAME'
3934: );
3938: IF p_deliverable_rec.fixed_due_date_yn = 'N'
3939: THEN
3940: IF p_deliverable_rec.relative_st_date_event_id IS NULL
3941: THEN
3942: okc_api.set_message
3943: (p_app_name => g_app_name,
3944: p_msg_name => 'OKC_I_NOT_NULL',
3945: p_token1 => 'FIELD',
3946: p_token1_value => 'RELATIVE_ST_DATE_EVENT_ID'
3949: END IF;
3950:
3951: IF p_deliverable_rec.relative_st_date_duration IS NULL
3952: THEN
3953: okc_api.set_message
3954: (p_app_name => g_app_name,
3955: p_msg_name => 'OKC_I_NOT_NULL',
3956: p_token1 => 'FIELD',
3957: p_token1_value => 'RELATIVE_ST_DATE_DURATION'
3960: END IF;
3961:
3962: IF p_deliverable_rec.relative_st_date_uom IS NULL
3963: THEN
3964: okc_api.set_message (p_app_name => g_app_name,
3965: p_msg_name => 'OKC_I_NOT_NULL',
3966: p_token1 => 'FIELD',
3967: p_token1_value => 'RELATIVE_ST_DATE_UOM'
3968: );
3976: p_deliverable_type => p_deliverable_rec.deliverable_type,
3977: p_bus_doc_event_id => p_deliverable_rec.relative_st_date_event_id
3978: ) <> 'Y'
3979: THEN
3980: okc_api.set_message
3981: (p_app_name => g_app_name,
3982: p_msg_name => 'OKC_I_INVALID_VALUE',
3983: p_token1 => 'FIELD',
3984: p_token1_value => 'RELATIVE_ST_DATE_EVENT_ID'
3993: IF p_deliverable_rec.notify_prior_due_date_uom IS NOT NULL
3994: AND p_deliverable_rec.notify_prior_due_date_uom NOT IN
3995: ('MTH', 'DAY', 'WK')
3996: THEN
3997: okc_api.set_message
3998: (p_app_name => g_app_name,
3999: p_msg_name => 'OKC_I_INVALID_VALUE',
4000: p_token1 => 'FIELD',
4001: p_token1_value => 'NOTIFY_PRIOR_DUE_DATE_UOM'
4005: IF p_deliverable_rec.notify_escalation_uom IS NOT NULL
4006: AND p_deliverable_rec.notify_escalation_uom NOT IN
4007: ('MTH', 'DAY', 'WK')
4008: THEN
4009: okc_api.set_message (p_app_name => g_app_name,
4010: p_msg_name => 'OKC_I_INVALID_VALUE',
4011: p_token1 => 'FIELD',
4012: p_token1_value => 'NOTIFY_ESCALATION_UOM'
4013: );
4016: IF p_deliverable_rec.relative_st_date_uom IS NOT NULL
4017: AND p_deliverable_rec.relative_st_date_uom NOT IN
4018: ('MTH', 'DAY', 'WK')
4019: THEN
4020: okc_api.set_message (p_app_name => g_app_name,
4021: p_msg_name => 'OKC_I_INVALID_VALUE',
4022: p_token1 => 'FIELD',
4023: p_token1_value => 'RELATIVE_ST_DATE_UOM'
4024: );
4027: IF p_deliverable_rec.relative_end_date_uom IS NOT NULL
4028: AND p_deliverable_rec.relative_end_date_uom NOT IN
4029: ('MTH', 'DAY', 'WK')
4030: THEN
4031: okc_api.set_message (p_app_name => g_app_name,
4032: p_msg_name => 'OKC_I_INVALID_VALUE',
4033: p_token1 => 'FIELD',
4034: p_token1_value => 'RELATIVE_END_DATE_UOM'
4035: );
4039: AND isvalidlookup ('OKC_DEL_REPEAT_FREQ',
4040: p_deliverable_rec.repeating_frequency_uom
4041: ) <> 'Y'
4042: THEN
4043: okc_api.set_message (p_app_name => g_app_name,
4044: p_msg_name => 'OKC_I_INVALID_VALUE',
4045: p_token1 => 'FIELD',
4046: p_token1_value => 'REPEATING_FREQUENCY_UOM'
4047: );
4050: IF p_deliverable_rec.pay_hold_prior_due_date_uom IS NOT NULL
4051: AND p_deliverable_rec.pay_hold_prior_due_date_uom NOT IN
4052: ('MTH', 'DAY', 'WK')
4053: THEN
4054: okc_api.set_message
4055: (p_app_name => g_app_name,
4056: p_msg_name => 'OKC_I_INVALID_VALUE',
4057: p_token1 => 'FIELD',
4058: p_token1_value => 'PAY_HOLD_PRIOR_DUE_DATE_UOM'
4084: OR ( p_deliverable_rec.relative_end_date_event_id IS NOT NULL
4085: AND p_deliverable_rec.fixed_end_date IS NOT NULL
4086: )
4087: THEN
4088: okc_api.set_message
4089: (p_app_name => g_app_name,
4090: p_msg_name => 'OKC_DEL_INCONSISTENT_DUE_DATES'
4091: );
4092: RAISE fnd_api.g_exc_error;
4099: THEN
4100: IF p_deliverable_rec.fixed_due_date_yn = 'N'
4101: AND p_deliverable_rec.fixed_start_date IS NULL
4102: THEN
4103: okc_api.set_message
4104: (p_app_name => g_app_name,
4105: p_msg_name => 'OKC_DEL_NULL_FIXED_ST_DATE_UI'
4106: );
4107: RAISE fnd_api.g_exc_error;
4114: IF p_deliverable_rec.relative_st_date_duration IS NULL
4115: THEN
4116:
4117: --Acq Plan Message Cleanup
4118: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4119: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4120:
4121: /* okc_api.set_message
4122: (p_app_name => g_app_name,
4115: THEN
4116:
4117: --Acq Plan Message Cleanup
4118: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4119: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4120:
4121: /* okc_api.set_message
4122: (p_app_name => g_app_name,
4123: p_msg_name => 'OKC_DEL_NULL_REL_ST_DUR_UI'
4117: --Acq Plan Message Cleanup
4118: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4119: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4120:
4121: /* okc_api.set_message
4122: (p_app_name => g_app_name,
4123: p_msg_name => 'OKC_DEL_NULL_REL_ST_DUR_UI'
4124: ); */
4125:
4122: (p_app_name => g_app_name,
4123: p_msg_name => 'OKC_DEL_NULL_REL_ST_DUR_UI'
4124: ); */
4125:
4126: okc_api.set_message
4127: (p_app_name => g_app_name,
4128: p_msg_name => l_resolved_msg_name,
4129: p_token1 => 'DEL_TOKEN',
4130: p_token1_value => l_resolved_token
4134:
4135: IF p_deliverable_rec.relative_st_date_duration < 0
4136: THEN
4137: --Acq Plan Message Cleanup
4138: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4139: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4140:
4141: okc_api.set_message (p_app_name => g_app_name,
4142: p_msg_name => l_resolved_msg_name,
4135: IF p_deliverable_rec.relative_st_date_duration < 0
4136: THEN
4137: --Acq Plan Message Cleanup
4138: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4139: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4140:
4141: okc_api.set_message (p_app_name => g_app_name,
4142: p_msg_name => l_resolved_msg_name,
4143: p_token1 => 'DEL_TOKEN',
4137: --Acq Plan Message Cleanup
4138: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_ST_DUR_UI',p_deliverable_rec.business_document_type);
4139: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4140:
4141: okc_api.set_message (p_app_name => g_app_name,
4142: p_msg_name => l_resolved_msg_name,
4143: p_token1 => 'DEL_TOKEN',
4144: p_token1_value => l_resolved_token
4145: );
4148:
4149: IF p_deliverable_rec.relative_st_date_event_id IS NULL
4150: THEN
4151: --Acq Plan Message Cleanup
4152: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_ST_EVENT_UI',p_deliverable_rec.business_document_type);
4153: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4154:
4155: okc_api.set_message (p_app_name => g_app_name,
4156: p_msg_name => l_resolved_msg_name,
4149: IF p_deliverable_rec.relative_st_date_event_id IS NULL
4150: THEN
4151: --Acq Plan Message Cleanup
4152: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_ST_EVENT_UI',p_deliverable_rec.business_document_type);
4153: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4154:
4155: okc_api.set_message (p_app_name => g_app_name,
4156: p_msg_name => l_resolved_msg_name,
4157: p_token1 => 'DEL_TOKEN',
4151: --Acq Plan Message Cleanup
4152: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_ST_EVENT_UI',p_deliverable_rec.business_document_type);
4153: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4154:
4155: okc_api.set_message (p_app_name => g_app_name,
4156: p_msg_name => l_resolved_msg_name,
4157: p_token1 => 'DEL_TOKEN',
4158: p_token1_value => l_resolved_token
4159: );
4168: p_deliverable_type => p_deliverable_rec.deliverable_type,
4169: p_bus_doc_event_id => p_deliverable_rec.relative_st_date_event_id
4170: ) <> 'Y'
4171: THEN
4172: okc_api.set_message
4173: (p_app_name => g_app_name,
4174: p_msg_name => 'OKC_I_INVALID_VALUE',
4175: p_token1 => 'FIELD',
4176: p_token1_value => 'RELATIVE_ST_DATE_EVENT_ID'
4185: AND p_deliverable_rec.repeating_frequency_uom = 'WK'
4186: THEN
4187: IF p_deliverable_rec.repeating_duration IS NULL
4188: THEN
4189: okc_api.set_message
4190: (p_app_name => g_app_name,
4191: p_msg_name => 'OKC_DEL_NULL_REPEAT_WEEK_UI'
4192: );
4193: RAISE fnd_api.g_exc_error;
4194: END IF;
4195:
4196: IF p_deliverable_rec.repeating_duration < 0
4197: THEN
4198: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_WEEK_UI',p_deliverable_rec.business_document_type);
4199: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4200:
4201: okc_api.set_message (p_app_name => g_app_name,
4202: p_msg_name => l_resolved_msg_name,
4195:
4196: IF p_deliverable_rec.repeating_duration < 0
4197: THEN
4198: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_WEEK_UI',p_deliverable_rec.business_document_type);
4199: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4200:
4201: okc_api.set_message (p_app_name => g_app_name,
4202: p_msg_name => l_resolved_msg_name,
4203: p_token1 => 'DEL_TOKEN',
4197: THEN
4198: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_WEEK_UI',p_deliverable_rec.business_document_type);
4199: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4200:
4201: okc_api.set_message (p_app_name => g_app_name,
4202: p_msg_name => l_resolved_msg_name,
4203: p_token1 => 'DEL_TOKEN',
4204: p_token1_value => l_resolved_token
4205: );
4213: (p_deliverable_rec.repeating_day_of_week
4214: )
4215: ) <> 'Y'
4216: THEN
4217: okc_api.set_message
4218: (p_app_name => g_app_name,
4219: p_msg_name => 'OKC_DEL_INVALID_DAY_OF_WEEK'
4220: );
4221: RAISE fnd_api.g_exc_error;
4226: AND p_deliverable_rec.repeating_frequency_uom = 'MTH'
4227: THEN
4228: IF p_deliverable_rec.repeating_duration IS NULL
4229: THEN
4230: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REPEAT_MONTH_UI',p_deliverable_rec.business_document_type);
4231: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4232:
4233: okc_api.set_message (p_app_name => g_app_name,
4234: p_msg_name => l_resolved_msg_name,
4227: THEN
4228: IF p_deliverable_rec.repeating_duration IS NULL
4229: THEN
4230: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REPEAT_MONTH_UI',p_deliverable_rec.business_document_type);
4231: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4232:
4233: okc_api.set_message (p_app_name => g_app_name,
4234: p_msg_name => l_resolved_msg_name,
4235: p_token1 => 'DEL_TOKEN',
4229: THEN
4230: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REPEAT_MONTH_UI',p_deliverable_rec.business_document_type);
4231: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4232:
4233: okc_api.set_message (p_app_name => g_app_name,
4234: p_msg_name => l_resolved_msg_name,
4235: p_token1 => 'DEL_TOKEN',
4236: p_token1_value => l_resolved_token
4237: );
4240: END IF;
4241:
4242: IF p_deliverable_rec.repeating_duration < 0
4243: THEN
4244: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_MONTH_UI',p_deliverable_rec.business_document_type);
4245: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4246:
4247: okc_api.set_message (p_app_name => g_app_name,
4248: p_msg_name => l_resolved_msg_name,
4241:
4242: IF p_deliverable_rec.repeating_duration < 0
4243: THEN
4244: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_MONTH_UI',p_deliverable_rec.business_document_type);
4245: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4246:
4247: okc_api.set_message (p_app_name => g_app_name,
4248: p_msg_name => l_resolved_msg_name,
4249: p_token1 => 'DEL_TOKEN',
4243: THEN
4244: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REPEAT_MONTH_UI',p_deliverable_rec.business_document_type);
4245: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4246:
4247: okc_api.set_message (p_app_name => g_app_name,
4248: p_msg_name => l_resolved_msg_name,
4249: p_token1 => 'DEL_TOKEN',
4250: p_token1_value => l_resolved_token
4251: );
4258: (p_deliverable_rec.repeating_day_of_month
4259: )
4260: ) <> 'Y'
4261: THEN
4262: okc_api.set_message
4263: (p_app_name => g_app_name,
4264: p_msg_name => 'OKC_DEL_INVALID_DAY_OF_MONTH'
4265: );
4266: RAISE fnd_api.g_exc_error;
4280: (p_deliverable_rec.relative_st_date_event_id,
4281: p_deliverable_rec.relative_end_date_event_id
4282: ) <> 'Y'
4283: THEN
4284: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_INVLD_EVENT_DOCTYPE_UI',p_deliverable_rec.business_document_type);
4285: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4286: /* okc_api.set_message
4287: (p_app_name => g_app_name,
4288: p_msg_name => 'OKC_DEL_INVLD_EVENT_DOCTYPE_UI'
4281: p_deliverable_rec.relative_end_date_event_id
4282: ) <> 'Y'
4283: THEN
4284: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_INVLD_EVENT_DOCTYPE_UI',p_deliverable_rec.business_document_type);
4285: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4286: /* okc_api.set_message
4287: (p_app_name => g_app_name,
4288: p_msg_name => 'OKC_DEL_INVLD_EVENT_DOCTYPE_UI'
4289: );*/
4282: ) <> 'Y'
4283: THEN
4284: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_INVLD_EVENT_DOCTYPE_UI',p_deliverable_rec.business_document_type);
4285: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4286: /* okc_api.set_message
4287: (p_app_name => g_app_name,
4288: p_msg_name => 'OKC_DEL_INVLD_EVENT_DOCTYPE_UI'
4289: );*/
4290: okc_api.set_message (p_app_name => g_app_name,
4286: /* okc_api.set_message
4287: (p_app_name => g_app_name,
4288: p_msg_name => 'OKC_DEL_INVLD_EVENT_DOCTYPE_UI'
4289: );*/
4290: okc_api.set_message (p_app_name => g_app_name,
4291: p_msg_name => l_resolved_msg_name,
4292: p_token1 => 'DEL_TOKEN',
4293: p_token1_value => l_resolved_token
4294: );
4302: )
4303: AND p_deliverable_rec.fixed_end_date IS NULL
4304: THEN
4305:
4306: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_FIXD_END_DATE_UI',p_deliverable_rec.business_document_type);
4307: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4308: okc_api.set_message (p_app_name => g_app_name,
4309: p_msg_name => l_resolved_msg_name,
4310: p_token1 => 'DEL_TOKEN',
4303: AND p_deliverable_rec.fixed_end_date IS NULL
4304: THEN
4305:
4306: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_FIXD_END_DATE_UI',p_deliverable_rec.business_document_type);
4307: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4308: okc_api.set_message (p_app_name => g_app_name,
4309: p_msg_name => l_resolved_msg_name,
4310: p_token1 => 'DEL_TOKEN',
4311: p_token1_value => l_resolved_token
4304: THEN
4305:
4306: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_FIXD_END_DATE_UI',p_deliverable_rec.business_document_type);
4307: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4308: okc_api.set_message (p_app_name => g_app_name,
4309: p_msg_name => l_resolved_msg_name,
4310: p_token1 => 'DEL_TOKEN',
4311: p_token1_value => l_resolved_token
4312: );
4320: AND p_deliverable_rec.fixed_end_date IS NOT NULL
4321: THEN
4322: IF p_deliverable_rec.fixed_end_date < SYSDATE
4323: THEN
4324: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_WRONG_FIXD_END_DATE_UI',p_deliverable_rec.business_document_type);
4325: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4326:
4327: okc_api.set_message (p_app_name => g_app_name,
4328: p_msg_name => l_resolved_msg_name,
4321: THEN
4322: IF p_deliverable_rec.fixed_end_date < SYSDATE
4323: THEN
4324: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_WRONG_FIXD_END_DATE_UI',p_deliverable_rec.business_document_type);
4325: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4326:
4327: okc_api.set_message (p_app_name => g_app_name,
4328: p_msg_name => l_resolved_msg_name,
4329: p_token1 => 'DEL_TOKEN',
4323: THEN
4324: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_WRONG_FIXD_END_DATE_UI',p_deliverable_rec.business_document_type);
4325: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4326:
4327: okc_api.set_message (p_app_name => g_app_name,
4328: p_msg_name => l_resolved_msg_name,
4329: p_token1 => 'DEL_TOKEN',
4330: p_token1_value => l_resolved_token
4331: );
4337: IF p_deliverable_rec.recurring_yn = 'Y'
4338: THEN
4339: IF p_deliverable_rec.relative_end_date_duration IS NULL
4340: THEN
4341: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_END_DUR_UI',p_deliverable_rec.business_document_type);
4342: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4343:
4344: /* okc_api.set_message
4345: (p_app_name => g_app_name,
4338: THEN
4339: IF p_deliverable_rec.relative_end_date_duration IS NULL
4340: THEN
4341: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_END_DUR_UI',p_deliverable_rec.business_document_type);
4342: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4343:
4344: /* okc_api.set_message
4345: (p_app_name => g_app_name,
4346: p_msg_name => 'OKC_DEL_NULL_REL_END_DUR_UI'
4340: THEN
4341: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_END_DUR_UI',p_deliverable_rec.business_document_type);
4342: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4343:
4344: /* okc_api.set_message
4345: (p_app_name => g_app_name,
4346: p_msg_name => 'OKC_DEL_NULL_REL_END_DUR_UI'
4347: );*/
4348: okc_api.set_message (p_app_name => g_app_name,
4344: /* okc_api.set_message
4345: (p_app_name => g_app_name,
4346: p_msg_name => 'OKC_DEL_NULL_REL_END_DUR_UI'
4347: );*/
4348: okc_api.set_message (p_app_name => g_app_name,
4349: p_msg_name => l_resolved_msg_name,
4350: p_token1 => 'DEL_TOKEN',
4351: p_token1_value => l_resolved_token
4352: );
4356: END IF;
4357:
4358: IF p_deliverable_rec.relative_end_date_duration < 0
4359: THEN
4360: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_END_DUR_UI',p_deliverable_rec.business_document_type);
4361: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4362:
4363:
4364: /*okc_api.set_message
4357:
4358: IF p_deliverable_rec.relative_end_date_duration < 0
4359: THEN
4360: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_END_DUR_UI',p_deliverable_rec.business_document_type);
4361: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4362:
4363:
4364: /*okc_api.set_message
4365: (p_app_name => g_app_name,
4360: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NEG_REL_END_DUR_UI',p_deliverable_rec.business_document_type);
4361: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4362:
4363:
4364: /*okc_api.set_message
4365: (p_app_name => g_app_name,
4366: p_msg_name => 'OKC_DEL_NEG_REL_END_DUR_UI'
4367: ); */
4368:
4365: (p_app_name => g_app_name,
4366: p_msg_name => 'OKC_DEL_NEG_REL_END_DUR_UI'
4367: ); */
4368:
4369: okc_api.set_message (p_app_name => g_app_name,
4370: p_msg_name => l_resolved_msg_name,
4371: p_token1 => 'DEL_TOKEN',
4372: p_token1_value => l_resolved_token
4373: );
4376: END IF;
4377:
4378: IF p_deliverable_rec.relative_end_date_event_id IS NULL
4379: THEN
4380: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_END_EVENT_UI',p_deliverable_rec.business_document_type);
4381: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4382:
4383: /* okc_api.set_message
4384: (p_app_name => g_app_name,
4377:
4378: IF p_deliverable_rec.relative_end_date_event_id IS NULL
4379: THEN
4380: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_END_EVENT_UI',p_deliverable_rec.business_document_type);
4381: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4382:
4383: /* okc_api.set_message
4384: (p_app_name => g_app_name,
4385: p_msg_name => 'OKC_DEL_NULL_REL_END_EVENT_UI'
4379: THEN
4380: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_NULL_REL_END_EVENT_UI',p_deliverable_rec.business_document_type);
4381: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4382:
4383: /* okc_api.set_message
4384: (p_app_name => g_app_name,
4385: p_msg_name => 'OKC_DEL_NULL_REL_END_EVENT_UI'
4386: );*/
4387:
4384: (p_app_name => g_app_name,
4385: p_msg_name => 'OKC_DEL_NULL_REL_END_EVENT_UI'
4386: );*/
4387:
4388: okc_api.set_message (p_app_name => g_app_name,
4389: p_msg_name => l_resolved_msg_name,
4390: p_token1 => 'DEL_TOKEN',
4391: p_token1_value => l_resolved_token
4392: );
4401: p_deliverable_type => p_deliverable_rec.deliverable_type,
4402: p_bus_doc_event_id => p_deliverable_rec.relative_end_date_event_id
4403: ) <> 'Y'
4404: THEN
4405: okc_api.set_message
4406: (p_app_name => g_app_name,
4407: p_msg_name => 'OKC_I_INVALID_VALUE',
4408: p_token1 => 'FIELD',
4409: p_token1_value => 'RELATIVE_END_DATE_EVENT_ID'
4420: IF p_deliverable_rec.fixed_start_date >
4421: p_deliverable_rec.fixed_end_date
4422: THEN
4423: --Acq Plan Message Cleanup
4424: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4425:
4426: /* okc_api.set_message
4427: (p_app_name => g_app_name,
4428: p_msg_name => 'OKC_I_INVALID_VALUE',
4422: THEN
4423: --Acq Plan Message Cleanup
4424: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4425:
4426: /* okc_api.set_message
4427: (p_app_name => g_app_name,
4428: p_msg_name => 'OKC_I_INVALID_VALUE',
4429: p_token1 => 'FIELD',
4430: p_token1_value => 'OKC_DEL_END_BEFORE_START_UI'
4428: p_msg_name => 'OKC_I_INVALID_VALUE',
4429: p_token1 => 'FIELD',
4430: p_token1_value => 'OKC_DEL_END_BEFORE_START_UI'
4431: );*/
4432: okc_api.set_message
4433: (p_app_name => g_app_name,
4434: p_msg_name => 'OKC_I_INVALID_VALUE',
4435: p_token1 => 'FIELD',
4436: p_token1_value => l_resolved_msg_name
4535: AND (l_startduration < l_endduration)
4536: )
4537: THEN
4538: --Acq Plan Message Cleanup
4539: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4540: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4541:
4542: /* okc_api.set_message
4543: (p_app_name => g_app_name,
4536: )
4537: THEN
4538: --Acq Plan Message Cleanup
4539: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4540: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4541:
4542: /* okc_api.set_message
4543: (p_app_name => g_app_name,
4544: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4538: --Acq Plan Message Cleanup
4539: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4540: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4541:
4542: /* okc_api.set_message
4543: (p_app_name => g_app_name,
4544: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4545: );*/
4546: okc_api.set_message
4542: /* okc_api.set_message
4543: (p_app_name => g_app_name,
4544: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4545: );*/
4546: okc_api.set_message
4547: (p_app_name => g_app_name,
4548: p_msg_name => l_resolved_msg_name,
4549: p_token1 => 'DEL_TOKEN',
4550: p_token1_value => l_resolved_token
4557: -- Scenario 3
4558: IF ('A' = l_startba AND 'B' = l_endba)
4559: THEN
4560: --Acq Plan Message Cleanup
4561: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4562: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4563:
4564: /* okc_api.set_message
4565: (p_app_name => g_app_name,
4558: IF ('A' = l_startba AND 'B' = l_endba)
4559: THEN
4560: --Acq Plan Message Cleanup
4561: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4562: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4563:
4564: /* okc_api.set_message
4565: (p_app_name => g_app_name,
4566: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4560: --Acq Plan Message Cleanup
4561: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4562: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4563:
4564: /* okc_api.set_message
4565: (p_app_name => g_app_name,
4566: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4567: );*/
4568: okc_api.set_message
4564: /* okc_api.set_message
4565: (p_app_name => g_app_name,
4566: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4567: );*/
4568: okc_api.set_message
4569: (p_app_name => g_app_name,
4570: p_msg_name => l_resolved_msg_name,
4571: p_token1 => 'DEL_TOKEN',
4572: p_token1_value => l_resolved_token
4580: AND l_startduration > l_endduration
4581: )
4582: THEN
4583: --Acq Plan Message Cleanup
4584: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4585: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4586:
4587: /* okc_api.set_message
4588: (p_app_name => g_app_name,
4581: )
4582: THEN
4583: --Acq Plan Message Cleanup
4584: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4585: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4586:
4587: /* okc_api.set_message
4588: (p_app_name => g_app_name,
4589: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4583: --Acq Plan Message Cleanup
4584: l_resolved_msg_name := OKC_API.resolve_message('OKC_DEL_END_BEFORE_START_UI',p_deliverable_rec.business_document_type);
4585: l_resolved_token := OKC_API.resolve_del_token(p_deliverable_rec.business_document_type);
4586:
4587: /* okc_api.set_message
4588: (p_app_name => g_app_name,
4589: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4590: );*/
4591: okc_api.set_message
4587: /* okc_api.set_message
4588: (p_app_name => g_app_name,
4589: p_msg_name => 'OKC_DEL_END_BEFORE_START_UI'
4590: );*/
4591: okc_api.set_message
4592: (p_app_name => g_app_name,
4593: p_msg_name => l_resolved_msg_name,
4594: p_token1 => 'DEL_TOKEN',
4595: p_token1_value => l_resolved_token
4606: IF p_deliverable_rec.escalation_assignee IS NOT NULL
4607: THEN
4608: IF isvalidcontact (p_deliverable_rec.escalation_assignee) <> 'Y'
4609: THEN
4610: okc_api.set_message (p_app_name => g_app_name,
4611: p_msg_name => 'OKC_I_INVALID_VALUE',
4612: p_token1 => 'FIELD',
4613: p_token1_value => 'ESCALATION_ASSIGNEE'
4614: );
4630: IF inittemplateinfo
4631: (p_template_id => p_deliverable_rec.business_document_id) <>
4632: 'Y'
4633: THEN
4634: okc_api.set_message (p_app_name => g_app_name,
4635: p_msg_name => 'OKC_I_INVALID_VALUE',
4636: p_token1 => 'FIELD',
4637: p_token1_value => 'TEMPLATE_ID'
4638: );
4641: END IF;
4642:
4643: IF g_template_intent = 'S'
4644: THEN
4645: okc_api.set_message (p_app_name => g_app_name,
4646: p_msg_name => 'OKC_I_INVALID_VALUE',
4647: p_token1 => 'FIELD',
4648: p_token1_value => 'TEMPLATE_INTENT'
4649: );
4651: END IF;
4652:
4653: IF g_deliverable_update_allowed <> 'Y'
4654: THEN
4655: okc_api.set_message (p_app_name => g_app_name,
4656: p_msg_name => 'OKC_I_TEMP_STS_NO_INS_OBJ',
4657: p_token1 => 'STATUS',
4658: p_token1_value => g_template_status_code,
4659: p_token2 => 'OBJECT',
4922: WHEN OTHERS
4923: THEN
4924: p_deliverable_rec.status := g_ret_sts_error;
4925: set_proc_error_message (p_proc => l_proc);
4926: okc_api.set_message (p_app_name => g_app_name,
4927: p_msg_name => g_unexpected_error,
4928: p_token1 => g_sqlcode_token,
4929: p_token1_value => SQLCODE,
4930: p_token2 => g_sqlerrm_token,
4980: IF p_template_id <> NVL (g_template_id, -1)
4981: THEN
4982: IF inittemplateinfo (p_template_id => p_template_id) <> 'Y'
4983: THEN
4984: okc_api.set_message (p_app_name => g_app_name,
4985: p_msg_name => 'OKC_I_INVALID_VALUE',
4986: p_token1 => 'FIELD',
4987: p_token1_value => 'TEMPLATE_ID'
4988: );
4991: END IF;
4992:
4993: IF g_deliverable_update_allowed <> 'Y'
4994: THEN
4995: okc_api.set_message (p_app_name => g_app_name,
4996: p_msg_name => 'OKC_I_TEMP_STS_NO_DEL_OBJ',
4997: p_token1 => 'STATUS',
4998: p_token1_value => g_template_status_code,
4999: p_token2 => 'OBJECT',
5032: WHEN OTHERS
5033: THEN
5034: x_return_status := g_ret_sts_error;
5035: set_proc_error_message (p_proc => l_proc);
5036: okc_api.set_message (p_app_name => g_app_name,
5037: p_msg_name => g_unexpected_error,
5038: p_token1 => g_sqlcode_token,
5039: p_token1_value => SQLCODE,
5040: p_token2 => g_sqlerrm_token,
5069: l_progress := '010';
5070:
5071: IF p_template_id IS NULL
5072: THEN
5073: okc_api.set_message (g_app_name,
5074: okc_api.g_required_value,
5075: okc_api.g_col_name_token,
5076: 'TEMPLATE_ID'
5077: );
5070:
5071: IF p_template_id IS NULL
5072: THEN
5073: okc_api.set_message (g_app_name,
5074: okc_api.g_required_value,
5075: okc_api.g_col_name_token,
5076: 'TEMPLATE_ID'
5077: );
5078: RAISE fnd_api.g_exc_error;
5071: IF p_template_id IS NULL
5072: THEN
5073: okc_api.set_message (g_app_name,
5074: okc_api.g_required_value,
5075: okc_api.g_col_name_token,
5076: 'TEMPLATE_ID'
5077: );
5078: RAISE fnd_api.g_exc_error;
5079: -- Template id must not be null and it must be a valid template
5078: RAISE fnd_api.g_exc_error;
5079: -- Template id must not be null and it must be a valid template
5080: ELSIF inittemplateinfo (p_template_id) <> 'Y'
5081: THEN
5082: okc_api.set_message (g_app_name,
5083: okc_api.g_invalid_value,
5084: okc_api.g_col_name_token,
5085: 'TEMPLATE_ID'
5086: );
5079: -- Template id must not be null and it must be a valid template
5080: ELSIF inittemplateinfo (p_template_id) <> 'Y'
5081: THEN
5082: okc_api.set_message (g_app_name,
5083: okc_api.g_invalid_value,
5084: okc_api.g_col_name_token,
5085: 'TEMPLATE_ID'
5086: );
5087: RAISE fnd_api.g_exc_error;
5080: ELSIF inittemplateinfo (p_template_id) <> 'Y'
5081: THEN
5082: okc_api.set_message (g_app_name,
5083: okc_api.g_invalid_value,
5084: okc_api.g_col_name_token,
5085: 'TEMPLATE_ID'
5086: );
5087: RAISE fnd_api.g_exc_error;
5088: END IF;
5091: IF g_headerinfo_update_allowed = 'N'
5092: THEN
5093: l_progress := '020';
5094: -- Can't update anything just return the error.
5095: okc_api.set_message (p_app_name => g_app_name,
5096: p_msg_name => 'OKC_I_TEMP_STS_NO_UPD',
5097: p_token1 => 'STATUS',
5098: p_token1_value => g_template_status_code
5099: );
5105: IF (p_mode = 'UPDATE' OR p_mode = 'DELETE')
5106: THEN
5107: IF p_tmpl_usage_rec.allowed_tmpl_usages_id IS NULL
5108: THEN
5109: okc_api.set_message (g_app_name,
5110: okc_api.g_required_value,
5111: okc_api.g_col_name_token,
5112: 'ALLOWED_TMPL_USAGES_ID'
5113: );
5106: THEN
5107: IF p_tmpl_usage_rec.allowed_tmpl_usages_id IS NULL
5108: THEN
5109: okc_api.set_message (g_app_name,
5110: okc_api.g_required_value,
5111: okc_api.g_col_name_token,
5112: 'ALLOWED_TMPL_USAGES_ID'
5113: );
5114: RAISE fnd_api.g_exc_error;
5107: IF p_tmpl_usage_rec.allowed_tmpl_usages_id IS NULL
5108: THEN
5109: okc_api.set_message (g_app_name,
5110: okc_api.g_required_value,
5111: okc_api.g_col_name_token,
5112: 'ALLOWED_TMPL_USAGES_ID'
5113: );
5114: RAISE fnd_api.g_exc_error;
5115: -- Validate and initialize the p_tmpl_usage_rec
5115: -- Validate and initialize the p_tmpl_usage_rec
5116: ELSIF validate_tmpl_usage_id (p_template_id, p_tmpl_usage_rec,
5117: p_mode) <> 'Y'
5118: THEN
5119: okc_api.set_message (g_app_name,
5120: okc_api.g_invalid_value,
5121: okc_api.g_col_name_token,
5122: 'ALLOWED_TMPL_USAGES_ID'
5123: );
5116: ELSIF validate_tmpl_usage_id (p_template_id, p_tmpl_usage_rec,
5117: p_mode) <> 'Y'
5118: THEN
5119: okc_api.set_message (g_app_name,
5120: okc_api.g_invalid_value,
5121: okc_api.g_col_name_token,
5122: 'ALLOWED_TMPL_USAGES_ID'
5123: );
5124: RAISE fnd_api.g_exc_error;
5117: p_mode) <> 'Y'
5118: THEN
5119: okc_api.set_message (g_app_name,
5120: okc_api.g_invalid_value,
5121: okc_api.g_col_name_token,
5122: 'ALLOWED_TMPL_USAGES_ID'
5123: );
5124: RAISE fnd_api.g_exc_error;
5125: END IF;
5130: THEN
5131: -- Validate document Type
5132: IF p_tmpl_usage_rec.document_type IS NULL
5133: THEN
5134: okc_api.set_message (g_app_name,
5135: okc_api.g_required_value,
5136: okc_api.g_col_name_token,
5137: 'DOCUMENT_TYPE'
5138: );
5131: -- Validate document Type
5132: IF p_tmpl_usage_rec.document_type IS NULL
5133: THEN
5134: okc_api.set_message (g_app_name,
5135: okc_api.g_required_value,
5136: okc_api.g_col_name_token,
5137: 'DOCUMENT_TYPE'
5138: );
5139: RAISE fnd_api.g_exc_error;
5132: IF p_tmpl_usage_rec.document_type IS NULL
5133: THEN
5134: okc_api.set_message (g_app_name,
5135: okc_api.g_required_value,
5136: okc_api.g_col_name_token,
5137: 'DOCUMENT_TYPE'
5138: );
5139: RAISE fnd_api.g_exc_error;
5140: ELSE
5148: CLOSE l_doc_intent_csr;
5149:
5150: IF g_template_intent <> l_doc_intent
5151: THEN
5152: okc_api.set_message (g_app_name,
5153: 'OKC_TMPL_ALWD_USG_WRONG_INTENT',
5154: 'DOCUMENT_TYPE',
5155: p_tmpl_usage_rec.document_type
5156: );
5158: END IF;
5159:
5160: IF validate_bus_doc_type (p_tmpl_usage_rec.document_type) <> 'Y'
5161: THEN
5162: okc_api.set_message (g_app_name,
5163: okc_api.g_invalid_value,
5164: okc_api.g_col_name_token,
5165: 'DOCUMENT_TYPE'
5166: );
5159:
5160: IF validate_bus_doc_type (p_tmpl_usage_rec.document_type) <> 'Y'
5161: THEN
5162: okc_api.set_message (g_app_name,
5163: okc_api.g_invalid_value,
5164: okc_api.g_col_name_token,
5165: 'DOCUMENT_TYPE'
5166: );
5167: RAISE fnd_api.g_exc_error;
5160: IF validate_bus_doc_type (p_tmpl_usage_rec.document_type) <> 'Y'
5161: THEN
5162: okc_api.set_message (g_app_name,
5163: okc_api.g_invalid_value,
5164: okc_api.g_col_name_token,
5165: 'DOCUMENT_TYPE'
5166: );
5167: RAISE fnd_api.g_exc_error;
5168: END IF;
5191: )
5192: IS
5193: l_proc VARCHAR2 (60) := 'DEFAULT_ROW';
5194: BEGIN
5195: -- IF p_tmpl_usage_rec.ALLOWED_TMPL_USAGES_ID = OKC_API.G_MISS_NUM THEN p_tmpl_usage_rec.ALLOWED_TMPL_USAGES_ID:= NULL; END IF;
5196: IF p_tmpl_usage_rec.document_type = okc_api.g_miss_char
5197: THEN
5198: p_tmpl_usage_rec.document_type := NULL;
5199: END IF;
5192: IS
5193: l_proc VARCHAR2 (60) := 'DEFAULT_ROW';
5194: BEGIN
5195: -- IF p_tmpl_usage_rec.ALLOWED_TMPL_USAGES_ID = OKC_API.G_MISS_NUM THEN p_tmpl_usage_rec.ALLOWED_TMPL_USAGES_ID:= NULL; END IF;
5196: IF p_tmpl_usage_rec.document_type = okc_api.g_miss_char
5197: THEN
5198: p_tmpl_usage_rec.document_type := NULL;
5199: END IF;
5200:
5197: THEN
5198: p_tmpl_usage_rec.document_type := NULL;
5199: END IF;
5200:
5201: IF p_tmpl_usage_rec.default_yn = okc_api.g_miss_char
5202: THEN
5203: p_tmpl_usage_rec.default_yn := 'N';
5204: END IF;
5205:
5202: THEN
5203: p_tmpl_usage_rec.default_yn := 'N';
5204: END IF;
5205:
5206: IF p_tmpl_usage_rec.last_update_login = okc_api.g_miss_num
5207: THEN
5208: p_tmpl_usage_rec.last_update_login := fnd_global.login_id;
5209: END IF;
5210:
5207: THEN
5208: p_tmpl_usage_rec.last_update_login := fnd_global.login_id;
5209: END IF;
5210:
5211: IF p_tmpl_usage_rec.creation_date = okc_api.g_miss_date
5212: THEN
5213: p_tmpl_usage_rec.creation_date := SYSDATE;
5214: END IF;
5215:
5212: THEN
5213: p_tmpl_usage_rec.creation_date := SYSDATE;
5214: END IF;
5215:
5216: IF p_tmpl_usage_rec.created_by = okc_api.g_miss_num
5217: THEN
5218: p_tmpl_usage_rec.created_by := fnd_global.user_id;
5219: END IF;
5220:
5217: THEN
5218: p_tmpl_usage_rec.created_by := fnd_global.user_id;
5219: END IF;
5220:
5221: IF p_tmpl_usage_rec.last_updated_by = okc_api.g_miss_num
5222: THEN
5223: p_tmpl_usage_rec.last_updated_by := fnd_global.user_id;
5224: END IF;
5225:
5222: THEN
5223: p_tmpl_usage_rec.last_updated_by := fnd_global.user_id;
5224: END IF;
5225:
5226: IF p_tmpl_usage_rec.last_update_date = okc_api.g_miss_date
5227: THEN
5228: p_tmpl_usage_rec.last_update_date := SYSDATE;
5229: END IF;
5230:
5227: THEN
5228: p_tmpl_usage_rec.last_update_date := SYSDATE;
5229: END IF;
5230:
5231: IF p_tmpl_usage_rec.object_version_number = okc_api.g_miss_num
5232: THEN
5233: p_tmpl_usage_rec.object_version_number := 1;
5234: END IF;
5235:
5232: THEN
5233: p_tmpl_usage_rec.object_version_number := 1;
5234: END IF;
5235:
5236: IF p_tmpl_usage_rec.attribute_category = okc_api.g_miss_char
5237: THEN
5238: p_tmpl_usage_rec.attribute_category := NULL;
5239: END IF;
5240:
5237: THEN
5238: p_tmpl_usage_rec.attribute_category := NULL;
5239: END IF;
5240:
5241: IF p_tmpl_usage_rec.attribute1 = okc_api.g_miss_char
5242: THEN
5243: p_tmpl_usage_rec.attribute1 := NULL;
5244: END IF;
5245:
5242: THEN
5243: p_tmpl_usage_rec.attribute1 := NULL;
5244: END IF;
5245:
5246: IF p_tmpl_usage_rec.attribute2 = okc_api.g_miss_char
5247: THEN
5248: p_tmpl_usage_rec.attribute2 := NULL;
5249: END IF;
5250:
5247: THEN
5248: p_tmpl_usage_rec.attribute2 := NULL;
5249: END IF;
5250:
5251: IF p_tmpl_usage_rec.attribute3 = okc_api.g_miss_char
5252: THEN
5253: p_tmpl_usage_rec.attribute3 := NULL;
5254: END IF;
5255:
5252: THEN
5253: p_tmpl_usage_rec.attribute3 := NULL;
5254: END IF;
5255:
5256: IF p_tmpl_usage_rec.attribute4 = okc_api.g_miss_char
5257: THEN
5258: p_tmpl_usage_rec.attribute4 := NULL;
5259: END IF;
5260:
5257: THEN
5258: p_tmpl_usage_rec.attribute4 := NULL;
5259: END IF;
5260:
5261: IF p_tmpl_usage_rec.attribute5 = okc_api.g_miss_char
5262: THEN
5263: p_tmpl_usage_rec.attribute5 := NULL;
5264: END IF;
5265:
5262: THEN
5263: p_tmpl_usage_rec.attribute5 := NULL;
5264: END IF;
5265:
5266: IF p_tmpl_usage_rec.attribute6 = okc_api.g_miss_char
5267: THEN
5268: p_tmpl_usage_rec.attribute6 := NULL;
5269: END IF;
5270:
5267: THEN
5268: p_tmpl_usage_rec.attribute6 := NULL;
5269: END IF;
5270:
5271: IF p_tmpl_usage_rec.attribute7 = okc_api.g_miss_char
5272: THEN
5273: p_tmpl_usage_rec.attribute7 := NULL;
5274: END IF;
5275:
5272: THEN
5273: p_tmpl_usage_rec.attribute7 := NULL;
5274: END IF;
5275:
5276: IF p_tmpl_usage_rec.attribute8 = okc_api.g_miss_char
5277: THEN
5278: p_tmpl_usage_rec.attribute8 := NULL;
5279: END IF;
5280:
5277: THEN
5278: p_tmpl_usage_rec.attribute8 := NULL;
5279: END IF;
5280:
5281: IF p_tmpl_usage_rec.attribute9 = okc_api.g_miss_char
5282: THEN
5283: p_tmpl_usage_rec.attribute9 := NULL;
5284: END IF;
5285:
5282: THEN
5283: p_tmpl_usage_rec.attribute9 := NULL;
5284: END IF;
5285:
5286: IF p_tmpl_usage_rec.attribute10 = okc_api.g_miss_char
5287: THEN
5288: p_tmpl_usage_rec.attribute10 := NULL;
5289: END IF;
5290:
5287: THEN
5288: p_tmpl_usage_rec.attribute10 := NULL;
5289: END IF;
5290:
5291: IF p_tmpl_usage_rec.attribute11 = okc_api.g_miss_char
5292: THEN
5293: p_tmpl_usage_rec.attribute11 := NULL;
5294: END IF;
5295:
5292: THEN
5293: p_tmpl_usage_rec.attribute11 := NULL;
5294: END IF;
5295:
5296: IF p_tmpl_usage_rec.attribute12 = okc_api.g_miss_char
5297: THEN
5298: p_tmpl_usage_rec.attribute12 := NULL;
5299: END IF;
5300:
5297: THEN
5298: p_tmpl_usage_rec.attribute12 := NULL;
5299: END IF;
5300:
5301: IF p_tmpl_usage_rec.attribute13 = okc_api.g_miss_char
5302: THEN
5303: p_tmpl_usage_rec.attribute13 := NULL;
5304: END IF;
5305:
5302: THEN
5303: p_tmpl_usage_rec.attribute13 := NULL;
5304: END IF;
5305:
5306: IF p_tmpl_usage_rec.attribute14 = okc_api.g_miss_char
5307: THEN
5308: p_tmpl_usage_rec.attribute14 := NULL;
5309: END IF;
5310:
5307: THEN
5308: p_tmpl_usage_rec.attribute14 := NULL;
5309: END IF;
5310:
5311: IF p_tmpl_usage_rec.attribute15 = okc_api.g_miss_char
5312: THEN
5313: p_tmpl_usage_rec.attribute15 := NULL;
5314: END IF;
5315: EXCEPTION
5407: fnd_msg_pub.initialize;
5408: WHEN OTHERS
5409: THEN
5410: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5411: okc_api.set_message (p_app_name => g_app_name,
5412: p_msg_name => g_unexpected_error,
5413: p_token1 => g_sqlcode_token,
5414: p_token1_value => SQLCODE,
5415: p_token2 => g_sqlerrm_token,
5519: fnd_msg_pub.initialize;
5520: WHEN OTHERS
5521: THEN
5522: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5523: okc_api.set_message (p_app_name => g_app_name,
5524: p_msg_name => g_unexpected_error,
5525: p_token1 => g_sqlcode_token,
5526: p_token1_value => SQLCODE,
5527: p_token2 => g_sqlerrm_token,
5611: fnd_msg_pub.initialize;
5612: WHEN OTHERS
5613: THEN
5614: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5615: okc_api.set_message (p_app_name => g_app_name,
5616: p_msg_name => g_unexpected_error,
5617: p_token1 => g_sqlcode_token,
5618: p_token1_value => SQLCODE,
5619: p_token2 => g_sqlerrm_token,