52: if effective_end_date > input_end_date then
53: CP_missing_end := input_end_date;
54: end if;
55: CP_missing_flag := 1;
56: fnd_message.set_name('PER','PER_INV_ADD_NO_ADDRESS');
57: CP_reason := fnd_message.get();
58: end if;
59:
60:
53: CP_missing_end := input_end_date;
54: end if;
55: CP_missing_flag := 1;
56: fnd_message.set_name('PER','PER_INV_ADD_NO_ADDRESS');
57: CP_reason := fnd_message.get();
58: end if;
59:
60:
61: if CS_no_of_addr = 1 then
71: if (date_from - 1) > input_end_date then
72: CP_missing_end := input_end_date;
73: end if;
74: CP_missing_flag := 1;
75: fnd_message.set_name('PER','PER_INV_ADD_NO_WHOLE_PERIOD');
76: CP_reason := fnd_message.get();
77:
78: end if;
79:
72: CP_missing_end := input_end_date;
73: end if;
74: CP_missing_flag := 1;
75: fnd_message.set_name('PER','PER_INV_ADD_NO_WHOLE_PERIOD');
76: CP_reason := fnd_message.get();
77:
78: end if;
79:
80:
89: if effective_end_date > input_end_date then
90: CP_missing_end1 := input_end_date;
91: end if;
92: CP_missing_flag := 1;
93: fnd_message.set_name('PER','PER_INV_ADD_NO_WHOLE_PERIOD');
94: CP_reason1 := fnd_message.get();
95: end if;
96: end if;
97:
90: CP_missing_end1 := input_end_date;
91: end if;
92: CP_missing_flag := 1;
93: fnd_message.set_name('PER','PER_INV_ADD_NO_WHOLE_PERIOD');
94: CP_reason1 := fnd_message.get();
95: end if;
96: end if;
97:
98:
109: if (date_from - 1) > input_end_date then
110: CP_missing_end := input_end_date;
111: end if;
112: CP_missing_flag := 1;
113: fnd_message.set_name('PER','PER_INV_ADD_NO_WHOLE_PERIOD');
114: CP_reason := fnd_message.get();
115: end if;
116:
117: if additional_verification = 'MMREF' then
110: CP_missing_end := input_end_date;
111: end if;
112: CP_missing_flag := 1;
113: fnd_message.set_name('PER','PER_INV_ADD_NO_WHOLE_PERIOD');
114: CP_reason := fnd_message.get();
115: end if;
116:
117: if additional_verification = 'MMREF' then
118: if (length(address_line1) > 22 OR
128: CP_missing_end := input_end_date;
129: else
130: CP_missing_end := add_date_to;
131: end if;
132: fnd_message.set_name('PER','PER_INV_ADD_NON_MMREF');
133: CP_reason := fnd_message.get();
134: else
135: if input_start_date > date_from then
136: CP_missing_st1 := input_start_date;
129: else
130: CP_missing_end := add_date_to;
131: end if;
132: fnd_message.set_name('PER','PER_INV_ADD_NON_MMREF');
133: CP_reason := fnd_message.get();
134: else
135: if input_start_date > date_from then
136: CP_missing_st1 := input_start_date;
137: else
141: CP_missing_end1 := input_end_date;
142: else
143: CP_missing_end1 := add_date_to;
144: end if;
145: fnd_message.set_name('PER','PER_INV_ADD_NON_MMREF');
146: CP_reason1 := fnd_message.get();
147: end if;
148: CP_missing_flag := 1;
149: end if;
142: else
143: CP_missing_end1 := add_date_to;
144: end if;
145: fnd_message.set_name('PER','PER_INV_ADD_NON_MMREF');
146: CP_reason1 := fnd_message.get();
147: end if;
148: CP_missing_flag := 1;
149: end if;
150: end if;
165: else
166: CP_missing_end := add_date_to;
167: end if;
168: CP_missing_flag := 1;
169: fnd_message.set_name('PER','PER_INV_ADD_TOO_LONG');
170: CP_reason := fnd_message.get();
171: end if;
172: end if;
173:
166: CP_missing_end := add_date_to;
167: end if;
168: CP_missing_flag := 1;
169: fnd_message.set_name('PER','PER_INV_ADD_TOO_LONG');
170: CP_reason := fnd_message.get();
171: end if;
172: end if;
173:
174:
184: if CP_prev_date_to > input_end_date then
185: CP_missing_end := input_end_date;
186: end if;
187: CP_missing_flag := 1;
188: fnd_message.set_name('PER','PER_INV_ADD_OVERLAP');
189: CP_reason := fnd_message.get();
190: else
191:
192: if (CP_prev_date_to < date_from - 1) then
185: CP_missing_end := input_end_date;
186: end if;
187: CP_missing_flag := 1;
188: fnd_message.set_name('PER','PER_INV_ADD_OVERLAP');
189: CP_reason := fnd_message.get();
190: else
191:
192: if (CP_prev_date_to < date_from - 1) then
193: CP_missing_st := CP_prev_date_to + 1;
198: if (date_from - 1) > input_end_date then
199: CP_missing_end := input_end_date;
200: end if;
201: CP_missing_flag := 1;
202: fnd_message.set_name('PER','PER_INV_ADD_GAP_EXIST');
203: CP_reason := fnd_message.get();
204: end if;
205: end if;
206:
199: CP_missing_end := input_end_date;
200: end if;
201: CP_missing_flag := 1;
202: fnd_message.set_name('PER','PER_INV_ADD_GAP_EXIST');
203: CP_reason := fnd_message.get();
204: end if;
205: end if;
206:
207: if (CP_keep_count = CS_no_of_addr) and
215: if effective_end_date > input_end_date then
216: CP_missing_end1 := input_end_date;
217: end if;
218: CP_missing_flag := 1;
219: fnd_message.set_name('PER','PER_INV_ADD_NO_WHOLE_PERIOD');
220: CP_reason1 := fnd_message.get();
221: end if;
222: end if;
223:
216: CP_missing_end1 := input_end_date;
217: end if;
218: CP_missing_flag := 1;
219: fnd_message.set_name('PER','PER_INV_ADD_NO_WHOLE_PERIOD');
220: CP_reason1 := fnd_message.get();
221: end if;
222: end if;
223:
224: end if;
240: else
241: CP_missing_end := add_date_to;
242: end if;
243: CP_missing_flag := 1;
244: fnd_message.set_name('PER','PER_INV_ADD_NON_MMREF');
245: CP_reason := fnd_message.get();
246: end if;
247: end if;
248: end if;
241: CP_missing_end := add_date_to;
242: end if;
243: CP_missing_flag := 1;
244: fnd_message.set_name('PER','PER_INV_ADD_NON_MMREF');
245: CP_reason := fnd_message.get();
246: end if;
247: end if;
248: end if;
249:
265: else
266: CP_missing_end := add_date_to;
267: end if;
268: CP_missing_flag := 1;
269: fnd_message.set_name('PER','PER_INV_ADD_TOO_LONG');
270: CP_reason := fnd_message.get();
271: end if;
272: end if;
273: end if;
266: CP_missing_end := add_date_to;
267: end if;
268: CP_missing_flag := 1;
269: fnd_message.set_name('PER','PER_INV_ADD_TOO_LONG');
270: CP_reason := fnd_message.get();
271: end if;
272: end if;
273: end if;
274: