18: --
19: if total_order(40).number_of_orders > 0 and
20: total_order(50).number_of_orders > 0 then
21: hr_utility.set_location(g_package||'validation - FAILED', 15);
22: fnd_message.set_name('PAY', 'PAY_74893_CO_P4S_P5S');
23: return fnd_message.get;
24: else
25: hr_utility.set_location(g_package||'valid - PASSED', 20);
26: return null;
19: if total_order(40).number_of_orders > 0 and
20: total_order(50).number_of_orders > 0 then
21: hr_utility.set_location(g_package||'validation - FAILED', 15);
22: fnd_message.set_name('PAY', 'PAY_74893_CO_P4S_P5S');
23: return fnd_message.get;
24: else
25: hr_utility.set_location(g_package||'valid - PASSED', 20);
26: return null;
27: end if;
131: end if;
132: --
133: if l_payment < l_value then
134: if p_payment > 0 then
135: fnd_message.set_name('PAY', 'PAY_74889_CO_SHORTFALL');
136: fnd_message.set_token('ELEMENT', p_element_name);
137: fnd_message.set_token('REFERENCE', p_payment_reference);
138: fnd_message.set_token('PAYMENT', l_payment);
139: fnd_message.set_token('OWED', l_value);
132: --
133: if l_payment < l_value then
134: if p_payment > 0 then
135: fnd_message.set_name('PAY', 'PAY_74889_CO_SHORTFALL');
136: fnd_message.set_token('ELEMENT', p_element_name);
137: fnd_message.set_token('REFERENCE', p_payment_reference);
138: fnd_message.set_token('PAYMENT', l_payment);
139: fnd_message.set_token('OWED', l_value);
140: fnd_message.set_token('SHORTFALL', to_char(l_value - l_payment));
133: if l_payment < l_value then
134: if p_payment > 0 then
135: fnd_message.set_name('PAY', 'PAY_74889_CO_SHORTFALL');
136: fnd_message.set_token('ELEMENT', p_element_name);
137: fnd_message.set_token('REFERENCE', p_payment_reference);
138: fnd_message.set_token('PAYMENT', l_payment);
139: fnd_message.set_token('OWED', l_value);
140: fnd_message.set_token('SHORTFALL', to_char(l_value - l_payment));
141: p_message_text := fnd_message.get;
134: if p_payment > 0 then
135: fnd_message.set_name('PAY', 'PAY_74889_CO_SHORTFALL');
136: fnd_message.set_token('ELEMENT', p_element_name);
137: fnd_message.set_token('REFERENCE', p_payment_reference);
138: fnd_message.set_token('PAYMENT', l_payment);
139: fnd_message.set_token('OWED', l_value);
140: fnd_message.set_token('SHORTFALL', to_char(l_value - l_payment));
141: p_message_text := fnd_message.get;
142: else
135: fnd_message.set_name('PAY', 'PAY_74889_CO_SHORTFALL');
136: fnd_message.set_token('ELEMENT', p_element_name);
137: fnd_message.set_token('REFERENCE', p_payment_reference);
138: fnd_message.set_token('PAYMENT', l_payment);
139: fnd_message.set_token('OWED', l_value);
140: fnd_message.set_token('SHORTFALL', to_char(l_value - l_payment));
141: p_message_text := fnd_message.get;
142: else
143: fnd_message.set_name('PAY', 'PAY_74890_CO_NO_PAYMENT');
136: fnd_message.set_token('ELEMENT', p_element_name);
137: fnd_message.set_token('REFERENCE', p_payment_reference);
138: fnd_message.set_token('PAYMENT', l_payment);
139: fnd_message.set_token('OWED', l_value);
140: fnd_message.set_token('SHORTFALL', to_char(l_value - l_payment));
141: p_message_text := fnd_message.get;
142: else
143: fnd_message.set_name('PAY', 'PAY_74890_CO_NO_PAYMENT');
144: fnd_message.set_token('ELEMENT', p_element_name);
137: fnd_message.set_token('REFERENCE', p_payment_reference);
138: fnd_message.set_token('PAYMENT', l_payment);
139: fnd_message.set_token('OWED', l_value);
140: fnd_message.set_token('SHORTFALL', to_char(l_value - l_payment));
141: p_message_text := fnd_message.get;
142: else
143: fnd_message.set_name('PAY', 'PAY_74890_CO_NO_PAYMENT');
144: fnd_message.set_token('ELEMENT', p_element_name);
145: fnd_message.set_token('REFERENCE', p_payment_reference);
139: fnd_message.set_token('OWED', l_value);
140: fnd_message.set_token('SHORTFALL', to_char(l_value - l_payment));
141: p_message_text := fnd_message.get;
142: else
143: fnd_message.set_name('PAY', 'PAY_74890_CO_NO_PAYMENT');
144: fnd_message.set_token('ELEMENT', p_element_name);
145: fnd_message.set_token('REFERENCE', p_payment_reference);
146: p_message_text := fnd_message.get;
147: end if;
140: fnd_message.set_token('SHORTFALL', to_char(l_value - l_payment));
141: p_message_text := fnd_message.get;
142: else
143: fnd_message.set_name('PAY', 'PAY_74890_CO_NO_PAYMENT');
144: fnd_message.set_token('ELEMENT', p_element_name);
145: fnd_message.set_token('REFERENCE', p_payment_reference);
146: p_message_text := fnd_message.get;
147: end if;
148: else
141: p_message_text := fnd_message.get;
142: else
143: fnd_message.set_name('PAY', 'PAY_74890_CO_NO_PAYMENT');
144: fnd_message.set_token('ELEMENT', p_element_name);
145: fnd_message.set_token('REFERENCE', p_payment_reference);
146: p_message_text := fnd_message.get;
147: end if;
148: else
149: if l_payment >= p_outstanding_balance then
142: else
143: fnd_message.set_name('PAY', 'PAY_74890_CO_NO_PAYMENT');
144: fnd_message.set_token('ELEMENT', p_element_name);
145: fnd_message.set_token('REFERENCE', p_payment_reference);
146: p_message_text := fnd_message.get;
147: end if;
148: else
149: if l_payment >= p_outstanding_balance then
150: fnd_message.set_name('PAY', 'PAY_74891_CO_PAID_OFF');
146: p_message_text := fnd_message.get;
147: end if;
148: else
149: if l_payment >= p_outstanding_balance then
150: fnd_message.set_name('PAY', 'PAY_74891_CO_PAID_OFF');
151: fnd_message.set_token('ELEMENT', p_element_name);
152: fnd_message.set_token('REFERENCE', p_payment_reference);
153: p_message_text := fnd_message.get;
154: p_stop := 'Y';
147: end if;
148: else
149: if l_payment >= p_outstanding_balance then
150: fnd_message.set_name('PAY', 'PAY_74891_CO_PAID_OFF');
151: fnd_message.set_token('ELEMENT', p_element_name);
152: fnd_message.set_token('REFERENCE', p_payment_reference);
153: p_message_text := fnd_message.get;
154: p_stop := 'Y';
155: end if;
148: else
149: if l_payment >= p_outstanding_balance then
150: fnd_message.set_name('PAY', 'PAY_74891_CO_PAID_OFF');
151: fnd_message.set_token('ELEMENT', p_element_name);
152: fnd_message.set_token('REFERENCE', p_payment_reference);
153: p_message_text := fnd_message.get;
154: p_stop := 'Y';
155: end if;
156: end if;
149: if l_payment >= p_outstanding_balance then
150: fnd_message.set_name('PAY', 'PAY_74891_CO_PAID_OFF');
151: fnd_message.set_token('ELEMENT', p_element_name);
152: fnd_message.set_token('REFERENCE', p_payment_reference);
153: p_message_text := fnd_message.get;
154: p_stop := 'Y';
155: end if;
156: end if;
157: --
166: --
167: if not court_order.exists(p_source_id) then
168: hr_utility.set_location('Element Source Id: '||substr(p_source_id,1,25)||' Not processed', 15);
169: p_message := 'Y';
170: fnd_message.set_name('PAY', 'PAY_74892_CO_NOT_PROCESSED');
171: fnd_message.set_token('ELEMENT', p_element_name);
172: fnd_message.set_token('REFERENCE', p_payment_reference);
173: p_message_text := fnd_message.get;
174: return 0;
167: if not court_order.exists(p_source_id) then
168: hr_utility.set_location('Element Source Id: '||substr(p_source_id,1,25)||' Not processed', 15);
169: p_message := 'Y';
170: fnd_message.set_name('PAY', 'PAY_74892_CO_NOT_PROCESSED');
171: fnd_message.set_token('ELEMENT', p_element_name);
172: fnd_message.set_token('REFERENCE', p_payment_reference);
173: p_message_text := fnd_message.get;
174: return 0;
175: end if;
168: hr_utility.set_location('Element Source Id: '||substr(p_source_id,1,25)||' Not processed', 15);
169: p_message := 'Y';
170: fnd_message.set_name('PAY', 'PAY_74892_CO_NOT_PROCESSED');
171: fnd_message.set_token('ELEMENT', p_element_name);
172: fnd_message.set_token('REFERENCE', p_payment_reference);
173: p_message_text := fnd_message.get;
174: return 0;
175: end if;
176: --
169: p_message := 'Y';
170: fnd_message.set_name('PAY', 'PAY_74892_CO_NOT_PROCESSED');
171: fnd_message.set_token('ELEMENT', p_element_name);
172: fnd_message.set_token('REFERENCE', p_payment_reference);
173: p_message_text := fnd_message.get;
174: return 0;
175: end if;
176: --
177: p_message_text := ' ';