21:
22: BEGIN
23:
24: IF p_financial_report_rec.financial_report_id IS NULL THEN
25: x_financial_report_rec.financial_report_id := FND_API.G_MISS_NUM;
26: ELSIF p_financial_report_rec.financial_report_id <> FND_API.G_MISS_NUM THEN
27: x_financial_report_rec.financial_report_id := p_financial_report_rec.financial_report_id;
28: END IF;
29:
22: BEGIN
23:
24: IF p_financial_report_rec.financial_report_id IS NULL THEN
25: x_financial_report_rec.financial_report_id := FND_API.G_MISS_NUM;
26: ELSIF p_financial_report_rec.financial_report_id <> FND_API.G_MISS_NUM THEN
27: x_financial_report_rec.financial_report_id := p_financial_report_rec.financial_report_id;
28: END IF;
29:
30: IF p_financial_report_rec.party_id IS NULL THEN
27: x_financial_report_rec.financial_report_id := p_financial_report_rec.financial_report_id;
28: END IF;
29:
30: IF p_financial_report_rec.party_id IS NULL THEN
31: x_financial_report_rec.party_id := FND_API.G_MISS_NUM;
32: ELSIF p_financial_report_rec.party_id <> FND_API.G_MISS_NUM THEN
33: x_financial_report_rec.party_id := p_financial_report_rec.party_id;
34: END IF;
35:
28: END IF;
29:
30: IF p_financial_report_rec.party_id IS NULL THEN
31: x_financial_report_rec.party_id := FND_API.G_MISS_NUM;
32: ELSIF p_financial_report_rec.party_id <> FND_API.G_MISS_NUM THEN
33: x_financial_report_rec.party_id := p_financial_report_rec.party_id;
34: END IF;
35:
36: IF p_financial_report_rec.type_of_financial_report IS NULL THEN
33: x_financial_report_rec.party_id := p_financial_report_rec.party_id;
34: END IF;
35:
36: IF p_financial_report_rec.type_of_financial_report IS NULL THEN
37: x_financial_report_rec.type_of_financial_report := FND_API.G_MISS_CHAR;
38: ELSIF p_financial_report_rec.type_of_financial_report <> FND_API.G_MISS_CHAR THEN
39: x_financial_report_rec.type_of_financial_report := p_financial_report_rec.type_of_financial_report;
40: END IF;
41:
34: END IF;
35:
36: IF p_financial_report_rec.type_of_financial_report IS NULL THEN
37: x_financial_report_rec.type_of_financial_report := FND_API.G_MISS_CHAR;
38: ELSIF p_financial_report_rec.type_of_financial_report <> FND_API.G_MISS_CHAR THEN
39: x_financial_report_rec.type_of_financial_report := p_financial_report_rec.type_of_financial_report;
40: END IF;
41:
42: IF p_financial_report_rec.document_reference IS NULL THEN
39: x_financial_report_rec.type_of_financial_report := p_financial_report_rec.type_of_financial_report;
40: END IF;
41:
42: IF p_financial_report_rec.document_reference IS NULL THEN
43: x_financial_report_rec.document_reference := FND_API.G_MISS_CHAR;
44: ELSIF p_financial_report_rec.document_reference <> FND_API.G_MISS_CHAR THEN
45: x_financial_report_rec.document_reference := p_financial_report_rec.document_reference;
46: END IF;
47:
40: END IF;
41:
42: IF p_financial_report_rec.document_reference IS NULL THEN
43: x_financial_report_rec.document_reference := FND_API.G_MISS_CHAR;
44: ELSIF p_financial_report_rec.document_reference <> FND_API.G_MISS_CHAR THEN
45: x_financial_report_rec.document_reference := p_financial_report_rec.document_reference;
46: END IF;
47:
48: IF p_financial_report_rec.date_report_issued IS NULL THEN
45: x_financial_report_rec.document_reference := p_financial_report_rec.document_reference;
46: END IF;
47:
48: IF p_financial_report_rec.date_report_issued IS NULL THEN
49: x_financial_report_rec.date_report_issued := FND_API.G_MISS_DATE;
50: ELSIF p_financial_report_rec.date_report_issued <> FND_API.G_MISS_DATE THEN
51: x_financial_report_rec.date_report_issued := p_financial_report_rec.date_report_issued;
52: END IF;
53:
46: END IF;
47:
48: IF p_financial_report_rec.date_report_issued IS NULL THEN
49: x_financial_report_rec.date_report_issued := FND_API.G_MISS_DATE;
50: ELSIF p_financial_report_rec.date_report_issued <> FND_API.G_MISS_DATE THEN
51: x_financial_report_rec.date_report_issued := p_financial_report_rec.date_report_issued;
52: END IF;
53:
54: IF p_financial_report_rec.issued_period IS NULL THEN
51: x_financial_report_rec.date_report_issued := p_financial_report_rec.date_report_issued;
52: END IF;
53:
54: IF p_financial_report_rec.issued_period IS NULL THEN
55: x_financial_report_rec.issued_period := FND_API.G_MISS_CHAR;
56: ELSIF p_financial_report_rec.issued_period <> FND_API.G_MISS_CHAR THEN
57: x_financial_report_rec.issued_period := p_financial_report_rec.issued_period;
58: END IF;
59:
52: END IF;
53:
54: IF p_financial_report_rec.issued_period IS NULL THEN
55: x_financial_report_rec.issued_period := FND_API.G_MISS_CHAR;
56: ELSIF p_financial_report_rec.issued_period <> FND_API.G_MISS_CHAR THEN
57: x_financial_report_rec.issued_period := p_financial_report_rec.issued_period;
58: END IF;
59:
60: IF p_financial_report_rec.report_start_date IS NULL THEN
57: x_financial_report_rec.issued_period := p_financial_report_rec.issued_period;
58: END IF;
59:
60: IF p_financial_report_rec.report_start_date IS NULL THEN
61: x_financial_report_rec.report_start_date := FND_API.G_MISS_DATE;
62: ELSIF p_financial_report_rec.report_start_date <> FND_API.G_MISS_DATE THEN
63: x_financial_report_rec.report_start_date := p_financial_report_rec.report_start_date;
64: END IF;
65:
58: END IF;
59:
60: IF p_financial_report_rec.report_start_date IS NULL THEN
61: x_financial_report_rec.report_start_date := FND_API.G_MISS_DATE;
62: ELSIF p_financial_report_rec.report_start_date <> FND_API.G_MISS_DATE THEN
63: x_financial_report_rec.report_start_date := p_financial_report_rec.report_start_date;
64: END IF;
65:
66: IF p_financial_report_rec.report_end_date IS NULL THEN
63: x_financial_report_rec.report_start_date := p_financial_report_rec.report_start_date;
64: END IF;
65:
66: IF p_financial_report_rec.report_end_date IS NULL THEN
67: x_financial_report_rec.report_end_date := FND_API.G_MISS_DATE;
68: ELSIF p_financial_report_rec.report_end_date <> FND_API.G_MISS_DATE THEN
69: x_financial_report_rec.report_end_date := p_financial_report_rec.report_end_date;
70: END IF;
71:
64: END IF;
65:
66: IF p_financial_report_rec.report_end_date IS NULL THEN
67: x_financial_report_rec.report_end_date := FND_API.G_MISS_DATE;
68: ELSIF p_financial_report_rec.report_end_date <> FND_API.G_MISS_DATE THEN
69: x_financial_report_rec.report_end_date := p_financial_report_rec.report_end_date;
70: END IF;
71:
72: IF p_financial_report_rec.actual_content_source IS NULL THEN
69: x_financial_report_rec.report_end_date := p_financial_report_rec.report_end_date;
70: END IF;
71:
72: IF p_financial_report_rec.actual_content_source IS NULL THEN
73: x_financial_report_rec.actual_content_source := FND_API.G_MISS_CHAR;
74: ELSIF p_financial_report_rec.actual_content_source <> FND_API.G_MISS_CHAR THEN
75: x_financial_report_rec.actual_content_source := p_financial_report_rec.actual_content_source;
76: END IF;
77:
70: END IF;
71:
72: IF p_financial_report_rec.actual_content_source IS NULL THEN
73: x_financial_report_rec.actual_content_source := FND_API.G_MISS_CHAR;
74: ELSIF p_financial_report_rec.actual_content_source <> FND_API.G_MISS_CHAR THEN
75: x_financial_report_rec.actual_content_source := p_financial_report_rec.actual_content_source;
76: END IF;
77:
78: IF p_financial_report_rec.requiring_authority IS NULL THEN
75: x_financial_report_rec.actual_content_source := p_financial_report_rec.actual_content_source;
76: END IF;
77:
78: IF p_financial_report_rec.requiring_authority IS NULL THEN
79: x_financial_report_rec.requiring_authority := FND_API.G_MISS_CHAR;
80: ELSIF p_financial_report_rec.requiring_authority <> FND_API.G_MISS_CHAR THEN
81: x_financial_report_rec.requiring_authority := p_financial_report_rec.requiring_authority;
82: END IF;
83:
76: END IF;
77:
78: IF p_financial_report_rec.requiring_authority IS NULL THEN
79: x_financial_report_rec.requiring_authority := FND_API.G_MISS_CHAR;
80: ELSIF p_financial_report_rec.requiring_authority <> FND_API.G_MISS_CHAR THEN
81: x_financial_report_rec.requiring_authority := p_financial_report_rec.requiring_authority;
82: END IF;
83:
84: IF p_financial_report_rec.audit_ind IS NULL THEN
81: x_financial_report_rec.requiring_authority := p_financial_report_rec.requiring_authority;
82: END IF;
83:
84: IF p_financial_report_rec.audit_ind IS NULL THEN
85: x_financial_report_rec.audit_ind := FND_API.G_MISS_CHAR;
86: ELSIF p_financial_report_rec.audit_ind <> FND_API.G_MISS_CHAR THEN
87: x_financial_report_rec.audit_ind := p_financial_report_rec.audit_ind;
88: END IF;
89:
82: END IF;
83:
84: IF p_financial_report_rec.audit_ind IS NULL THEN
85: x_financial_report_rec.audit_ind := FND_API.G_MISS_CHAR;
86: ELSIF p_financial_report_rec.audit_ind <> FND_API.G_MISS_CHAR THEN
87: x_financial_report_rec.audit_ind := p_financial_report_rec.audit_ind;
88: END IF;
89:
90: IF p_financial_report_rec.consolidated_ind IS NULL THEN
87: x_financial_report_rec.audit_ind := p_financial_report_rec.audit_ind;
88: END IF;
89:
90: IF p_financial_report_rec.consolidated_ind IS NULL THEN
91: x_financial_report_rec.consolidated_ind := FND_API.G_MISS_CHAR;
92: ELSIF p_financial_report_rec.consolidated_ind <> FND_API.G_MISS_CHAR THEN
93: x_financial_report_rec.consolidated_ind := p_financial_report_rec.consolidated_ind;
94: END IF;
95:
88: END IF;
89:
90: IF p_financial_report_rec.consolidated_ind IS NULL THEN
91: x_financial_report_rec.consolidated_ind := FND_API.G_MISS_CHAR;
92: ELSIF p_financial_report_rec.consolidated_ind <> FND_API.G_MISS_CHAR THEN
93: x_financial_report_rec.consolidated_ind := p_financial_report_rec.consolidated_ind;
94: END IF;
95:
96: IF p_financial_report_rec.estimated_ind IS NULL THEN
93: x_financial_report_rec.consolidated_ind := p_financial_report_rec.consolidated_ind;
94: END IF;
95:
96: IF p_financial_report_rec.estimated_ind IS NULL THEN
97: x_financial_report_rec.estimated_ind := FND_API.G_MISS_CHAR;
98: ELSIF p_financial_report_rec.estimated_ind <> FND_API.G_MISS_CHAR THEN
99: x_financial_report_rec.estimated_ind := p_financial_report_rec.estimated_ind;
100: END IF;
101:
94: END IF;
95:
96: IF p_financial_report_rec.estimated_ind IS NULL THEN
97: x_financial_report_rec.estimated_ind := FND_API.G_MISS_CHAR;
98: ELSIF p_financial_report_rec.estimated_ind <> FND_API.G_MISS_CHAR THEN
99: x_financial_report_rec.estimated_ind := p_financial_report_rec.estimated_ind;
100: END IF;
101:
102: IF p_financial_report_rec.fiscal_ind IS NULL THEN
99: x_financial_report_rec.estimated_ind := p_financial_report_rec.estimated_ind;
100: END IF;
101:
102: IF p_financial_report_rec.fiscal_ind IS NULL THEN
103: x_financial_report_rec.fiscal_ind := FND_API.G_MISS_CHAR;
104: ELSIF p_financial_report_rec.fiscal_ind <> FND_API.G_MISS_CHAR THEN
105: x_financial_report_rec.fiscal_ind := p_financial_report_rec.fiscal_ind;
106: END IF;
107:
100: END IF;
101:
102: IF p_financial_report_rec.fiscal_ind IS NULL THEN
103: x_financial_report_rec.fiscal_ind := FND_API.G_MISS_CHAR;
104: ELSIF p_financial_report_rec.fiscal_ind <> FND_API.G_MISS_CHAR THEN
105: x_financial_report_rec.fiscal_ind := p_financial_report_rec.fiscal_ind;
106: END IF;
107:
108: --Bug 2940399: Added FINAL_IND column in financial_report_rec_type. Hence added code
107:
108: --Bug 2940399: Added FINAL_IND column in financial_report_rec_type. Hence added code
109: --to copy from v1 record.
110: IF p_financial_report_rec.final_ind IS NULL THEN
111: x_financial_report_rec.final_ind := FND_API.G_MISS_CHAR;
112: ELSIF p_financial_report_rec.final_ind <> FND_API.G_MISS_CHAR THEN
113: x_financial_report_rec.final_ind := p_financial_report_rec.final_ind;
114: END IF;
115:
108: --Bug 2940399: Added FINAL_IND column in financial_report_rec_type. Hence added code
109: --to copy from v1 record.
110: IF p_financial_report_rec.final_ind IS NULL THEN
111: x_financial_report_rec.final_ind := FND_API.G_MISS_CHAR;
112: ELSIF p_financial_report_rec.final_ind <> FND_API.G_MISS_CHAR THEN
113: x_financial_report_rec.final_ind := p_financial_report_rec.final_ind;
114: END IF;
115:
116: IF p_financial_report_rec.forecast_ind IS NULL THEN
113: x_financial_report_rec.final_ind := p_financial_report_rec.final_ind;
114: END IF;
115:
116: IF p_financial_report_rec.forecast_ind IS NULL THEN
117: x_financial_report_rec.forecast_ind := FND_API.G_MISS_CHAR;
118: ELSIF p_financial_report_rec.forecast_ind <> FND_API.G_MISS_CHAR THEN
119: x_financial_report_rec.forecast_ind := p_financial_report_rec.forecast_ind;
120: END IF;
121:
114: END IF;
115:
116: IF p_financial_report_rec.forecast_ind IS NULL THEN
117: x_financial_report_rec.forecast_ind := FND_API.G_MISS_CHAR;
118: ELSIF p_financial_report_rec.forecast_ind <> FND_API.G_MISS_CHAR THEN
119: x_financial_report_rec.forecast_ind := p_financial_report_rec.forecast_ind;
120: END IF;
121:
122: IF p_financial_report_rec.opening_ind IS NULL THEN
119: x_financial_report_rec.forecast_ind := p_financial_report_rec.forecast_ind;
120: END IF;
121:
122: IF p_financial_report_rec.opening_ind IS NULL THEN
123: x_financial_report_rec.opening_ind := FND_API.G_MISS_CHAR;
124: ELSIF p_financial_report_rec.opening_ind <> FND_API.G_MISS_CHAR THEN
125: x_financial_report_rec.opening_ind := p_financial_report_rec.opening_ind;
126: END IF;
127:
120: END IF;
121:
122: IF p_financial_report_rec.opening_ind IS NULL THEN
123: x_financial_report_rec.opening_ind := FND_API.G_MISS_CHAR;
124: ELSIF p_financial_report_rec.opening_ind <> FND_API.G_MISS_CHAR THEN
125: x_financial_report_rec.opening_ind := p_financial_report_rec.opening_ind;
126: END IF;
127:
128: IF p_financial_report_rec.proforma_ind IS NULL THEN
125: x_financial_report_rec.opening_ind := p_financial_report_rec.opening_ind;
126: END IF;
127:
128: IF p_financial_report_rec.proforma_ind IS NULL THEN
129: x_financial_report_rec.proforma_ind := FND_API.G_MISS_CHAR;
130: ELSIF p_financial_report_rec.proforma_ind <> FND_API.G_MISS_CHAR THEN
131: x_financial_report_rec.proforma_ind := p_financial_report_rec.proforma_ind;
132: END IF;
133:
126: END IF;
127:
128: IF p_financial_report_rec.proforma_ind IS NULL THEN
129: x_financial_report_rec.proforma_ind := FND_API.G_MISS_CHAR;
130: ELSIF p_financial_report_rec.proforma_ind <> FND_API.G_MISS_CHAR THEN
131: x_financial_report_rec.proforma_ind := p_financial_report_rec.proforma_ind;
132: END IF;
133:
134: IF p_financial_report_rec.qualified_ind IS NULL THEN
131: x_financial_report_rec.proforma_ind := p_financial_report_rec.proforma_ind;
132: END IF;
133:
134: IF p_financial_report_rec.qualified_ind IS NULL THEN
135: x_financial_report_rec.qualified_ind := FND_API.G_MISS_CHAR;
136: ELSIF p_financial_report_rec.qualified_ind <> FND_API.G_MISS_CHAR THEN
137: x_financial_report_rec.qualified_ind := p_financial_report_rec.qualified_ind;
138: END IF;
139:
132: END IF;
133:
134: IF p_financial_report_rec.qualified_ind IS NULL THEN
135: x_financial_report_rec.qualified_ind := FND_API.G_MISS_CHAR;
136: ELSIF p_financial_report_rec.qualified_ind <> FND_API.G_MISS_CHAR THEN
137: x_financial_report_rec.qualified_ind := p_financial_report_rec.qualified_ind;
138: END IF;
139:
140: IF p_financial_report_rec.restated_ind IS NULL THEN
137: x_financial_report_rec.qualified_ind := p_financial_report_rec.qualified_ind;
138: END IF;
139:
140: IF p_financial_report_rec.restated_ind IS NULL THEN
141: x_financial_report_rec.restated_ind := FND_API.G_MISS_CHAR;
142: ELSIF p_financial_report_rec.restated_ind <> FND_API.G_MISS_CHAR THEN
143: x_financial_report_rec.restated_ind := p_financial_report_rec.restated_ind;
144: END IF;
145:
138: END IF;
139:
140: IF p_financial_report_rec.restated_ind IS NULL THEN
141: x_financial_report_rec.restated_ind := FND_API.G_MISS_CHAR;
142: ELSIF p_financial_report_rec.restated_ind <> FND_API.G_MISS_CHAR THEN
143: x_financial_report_rec.restated_ind := p_financial_report_rec.restated_ind;
144: END IF;
145:
146: IF p_financial_report_rec.signed_by_principals_ind IS NULL THEN
143: x_financial_report_rec.restated_ind := p_financial_report_rec.restated_ind;
144: END IF;
145:
146: IF p_financial_report_rec.signed_by_principals_ind IS NULL THEN
147: x_financial_report_rec.signed_by_principals_ind := FND_API.G_MISS_CHAR;
148: ELSIF p_financial_report_rec.signed_by_principals_ind <> FND_API.G_MISS_CHAR THEN
149: x_financial_report_rec.signed_by_principals_ind := p_financial_report_rec.signed_by_principals_ind;
150: END IF;
151:
144: END IF;
145:
146: IF p_financial_report_rec.signed_by_principals_ind IS NULL THEN
147: x_financial_report_rec.signed_by_principals_ind := FND_API.G_MISS_CHAR;
148: ELSIF p_financial_report_rec.signed_by_principals_ind <> FND_API.G_MISS_CHAR THEN
149: x_financial_report_rec.signed_by_principals_ind := p_financial_report_rec.signed_by_principals_ind;
150: END IF;
151:
152: IF p_financial_report_rec.trial_balance_ind IS NULL THEN
149: x_financial_report_rec.signed_by_principals_ind := p_financial_report_rec.signed_by_principals_ind;
150: END IF;
151:
152: IF p_financial_report_rec.trial_balance_ind IS NULL THEN
153: x_financial_report_rec.trial_balance_ind := FND_API.G_MISS_CHAR;
154: ELSIF p_financial_report_rec.trial_balance_ind <> FND_API.G_MISS_CHAR THEN
155: x_financial_report_rec.trial_balance_ind := p_financial_report_rec.trial_balance_ind;
156: END IF;
157:
150: END IF;
151:
152: IF p_financial_report_rec.trial_balance_ind IS NULL THEN
153: x_financial_report_rec.trial_balance_ind := FND_API.G_MISS_CHAR;
154: ELSIF p_financial_report_rec.trial_balance_ind <> FND_API.G_MISS_CHAR THEN
155: x_financial_report_rec.trial_balance_ind := p_financial_report_rec.trial_balance_ind;
156: END IF;
157:
158: IF p_financial_report_rec.unbalanced_ind IS NULL THEN
155: x_financial_report_rec.trial_balance_ind := p_financial_report_rec.trial_balance_ind;
156: END IF;
157:
158: IF p_financial_report_rec.unbalanced_ind IS NULL THEN
159: x_financial_report_rec.unbalanced_ind := FND_API.G_MISS_CHAR;
160: ELSIF p_financial_report_rec.unbalanced_ind <> FND_API.G_MISS_CHAR THEN
161: x_financial_report_rec.unbalanced_ind := p_financial_report_rec.unbalanced_ind;
162: END IF;
163:
156: END IF;
157:
158: IF p_financial_report_rec.unbalanced_ind IS NULL THEN
159: x_financial_report_rec.unbalanced_ind := FND_API.G_MISS_CHAR;
160: ELSIF p_financial_report_rec.unbalanced_ind <> FND_API.G_MISS_CHAR THEN
161: x_financial_report_rec.unbalanced_ind := p_financial_report_rec.unbalanced_ind;
162: END IF;
163:
164: IF p_financial_report_rec.status IS NULL THEN
161: x_financial_report_rec.unbalanced_ind := p_financial_report_rec.unbalanced_ind;
162: END IF;
163:
164: IF p_financial_report_rec.status IS NULL THEN
165: x_financial_report_rec.status := FND_API.G_MISS_CHAR;
166: ELSIF p_financial_report_rec.status <> FND_API.G_MISS_CHAR THEN
167: x_financial_report_rec.status := p_financial_report_rec.status;
168: END IF;
169:
162: END IF;
163:
164: IF p_financial_report_rec.status IS NULL THEN
165: x_financial_report_rec.status := FND_API.G_MISS_CHAR;
166: ELSIF p_financial_report_rec.status <> FND_API.G_MISS_CHAR THEN
167: x_financial_report_rec.status := p_financial_report_rec.status;
168: END IF;
169:
170: IF p_create_update_flag = 'C' THEN
218: BEGIN
219:
220: -- check required fields:
221: IF p_last_update_date IS NULL OR
222: p_last_update_date = FND_API.G_MISS_DATE
223: THEN
224: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
225: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
226: FND_MSG_PUB.ADD;
223: THEN
224: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
225: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
226: FND_MSG_PUB.ADD;
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229:
230: -- get object_version_number
231: BEGIN
239: THEN
240: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
241: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_financial_reports' );
242: FND_MSG_PUB.ADD;
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: EXCEPTION
246: WHEN NO_DATA_FOUND THEN
247: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
248: FND_MESSAGE.SET_TOKEN( 'RECORD', 'financial reports' );
249: FND_MESSAGE.SET_TOKEN( 'VALUE',
250: NVL( TO_CHAR( p_financial_report_rec.financial_report_id ), 'null' ) );
251: FND_MSG_PUB.ADD;
252: RAISE FND_API.G_EXC_ERROR;
253: END;
254:
255: -- pre-process v1 and v2 record.
256: v2_financial_report_pre (
277:
278: BEGIN
279:
280: IF p_financial_number_rec.financial_number_id IS NULL THEN
281: x_financial_number_rec.financial_number_id := FND_API.G_MISS_NUM;
282: ELSIF p_financial_number_rec.financial_number_id <> FND_API.G_MISS_NUM THEN
283: x_financial_number_rec.financial_number_id := p_financial_number_rec.financial_number_id;
284: END IF;
285:
278: BEGIN
279:
280: IF p_financial_number_rec.financial_number_id IS NULL THEN
281: x_financial_number_rec.financial_number_id := FND_API.G_MISS_NUM;
282: ELSIF p_financial_number_rec.financial_number_id <> FND_API.G_MISS_NUM THEN
283: x_financial_number_rec.financial_number_id := p_financial_number_rec.financial_number_id;
284: END IF;
285:
286: IF p_financial_number_rec.financial_report_id IS NULL THEN
283: x_financial_number_rec.financial_number_id := p_financial_number_rec.financial_number_id;
284: END IF;
285:
286: IF p_financial_number_rec.financial_report_id IS NULL THEN
287: x_financial_number_rec.financial_report_id := FND_API.G_MISS_NUM;
288: ELSIF p_financial_number_rec.financial_report_id <> FND_API.G_MISS_NUM THEN
289: x_financial_number_rec.financial_report_id := p_financial_number_rec.financial_report_id;
290: END IF;
291:
284: END IF;
285:
286: IF p_financial_number_rec.financial_report_id IS NULL THEN
287: x_financial_number_rec.financial_report_id := FND_API.G_MISS_NUM;
288: ELSIF p_financial_number_rec.financial_report_id <> FND_API.G_MISS_NUM THEN
289: x_financial_number_rec.financial_report_id := p_financial_number_rec.financial_report_id;
290: END IF;
291:
292: IF p_financial_number_rec.financial_number IS NULL THEN
289: x_financial_number_rec.financial_report_id := p_financial_number_rec.financial_report_id;
290: END IF;
291:
292: IF p_financial_number_rec.financial_number IS NULL THEN
293: x_financial_number_rec.financial_number := FND_API.G_MISS_NUM;
294: ELSIF p_financial_number_rec.financial_number <> FND_API.G_MISS_NUM THEN
295: x_financial_number_rec.financial_number := p_financial_number_rec.financial_number;
296: END IF;
297:
290: END IF;
291:
292: IF p_financial_number_rec.financial_number IS NULL THEN
293: x_financial_number_rec.financial_number := FND_API.G_MISS_NUM;
294: ELSIF p_financial_number_rec.financial_number <> FND_API.G_MISS_NUM THEN
295: x_financial_number_rec.financial_number := p_financial_number_rec.financial_number;
296: END IF;
297:
298: IF p_financial_number_rec.financial_number_name IS NULL THEN
295: x_financial_number_rec.financial_number := p_financial_number_rec.financial_number;
296: END IF;
297:
298: IF p_financial_number_rec.financial_number_name IS NULL THEN
299: x_financial_number_rec.financial_number_name := FND_API.G_MISS_CHAR;
300: ELSIF p_financial_number_rec.financial_number_name <> FND_API.G_MISS_CHAR THEN
301: x_financial_number_rec.financial_number_name := p_financial_number_rec.financial_number_name;
302: END IF;
303:
296: END IF;
297:
298: IF p_financial_number_rec.financial_number_name IS NULL THEN
299: x_financial_number_rec.financial_number_name := FND_API.G_MISS_CHAR;
300: ELSIF p_financial_number_rec.financial_number_name <> FND_API.G_MISS_CHAR THEN
301: x_financial_number_rec.financial_number_name := p_financial_number_rec.financial_number_name;
302: END IF;
303:
304: IF p_financial_number_rec.financial_units_applied IS NULL THEN
301: x_financial_number_rec.financial_number_name := p_financial_number_rec.financial_number_name;
302: END IF;
303:
304: IF p_financial_number_rec.financial_units_applied IS NULL THEN
305: x_financial_number_rec.financial_units_applied := FND_API.G_MISS_NUM;
306: ELSIF p_financial_number_rec.financial_units_applied <> FND_API.G_MISS_NUM THEN
307: x_financial_number_rec.financial_units_applied := p_financial_number_rec.financial_units_applied;
308: END IF;
309:
302: END IF;
303:
304: IF p_financial_number_rec.financial_units_applied IS NULL THEN
305: x_financial_number_rec.financial_units_applied := FND_API.G_MISS_NUM;
306: ELSIF p_financial_number_rec.financial_units_applied <> FND_API.G_MISS_NUM THEN
307: x_financial_number_rec.financial_units_applied := p_financial_number_rec.financial_units_applied;
308: END IF;
309:
310: IF p_financial_number_rec.financial_number_currency IS NULL THEN
307: x_financial_number_rec.financial_units_applied := p_financial_number_rec.financial_units_applied;
308: END IF;
309:
310: IF p_financial_number_rec.financial_number_currency IS NULL THEN
311: x_financial_number_rec.financial_number_currency := FND_API.G_MISS_CHAR;
312: ELSIF p_financial_number_rec.financial_number_currency <> FND_API.G_MISS_CHAR THEN
313: x_financial_number_rec.financial_number_currency := p_financial_number_rec.financial_number_currency;
314: END IF;
315:
308: END IF;
309:
310: IF p_financial_number_rec.financial_number_currency IS NULL THEN
311: x_financial_number_rec.financial_number_currency := FND_API.G_MISS_CHAR;
312: ELSIF p_financial_number_rec.financial_number_currency <> FND_API.G_MISS_CHAR THEN
313: x_financial_number_rec.financial_number_currency := p_financial_number_rec.financial_number_currency;
314: END IF;
315:
316: IF p_financial_number_rec.projected_actual_flag IS NULL THEN
313: x_financial_number_rec.financial_number_currency := p_financial_number_rec.financial_number_currency;
314: END IF;
315:
316: IF p_financial_number_rec.projected_actual_flag IS NULL THEN
317: x_financial_number_rec.projected_actual_flag := FND_API.G_MISS_CHAR;
318: ELSIF p_financial_number_rec.projected_actual_flag <> FND_API.G_MISS_CHAR THEN
319: x_financial_number_rec.projected_actual_flag := p_financial_number_rec.projected_actual_flag;
320: END IF;
321:
314: END IF;
315:
316: IF p_financial_number_rec.projected_actual_flag IS NULL THEN
317: x_financial_number_rec.projected_actual_flag := FND_API.G_MISS_CHAR;
318: ELSIF p_financial_number_rec.projected_actual_flag <> FND_API.G_MISS_CHAR THEN
319: x_financial_number_rec.projected_actual_flag := p_financial_number_rec.projected_actual_flag;
320: END IF;
321:
322: IF p_financial_number_rec.content_source_type IS NULL THEN
319: x_financial_number_rec.projected_actual_flag := p_financial_number_rec.projected_actual_flag;
320: END IF;
321:
322: IF p_financial_number_rec.content_source_type IS NULL THEN
323: x_financial_number_rec.content_source_type := FND_API.G_MISS_CHAR;
324: ELSIF p_financial_number_rec.content_source_type <> FND_API.G_MISS_CHAR THEN
325: x_financial_number_rec.content_source_type := p_financial_number_rec.content_source_type;
326: END IF;
327:
320: END IF;
321:
322: IF p_financial_number_rec.content_source_type IS NULL THEN
323: x_financial_number_rec.content_source_type := FND_API.G_MISS_CHAR;
324: ELSIF p_financial_number_rec.content_source_type <> FND_API.G_MISS_CHAR THEN
325: x_financial_number_rec.content_source_type := p_financial_number_rec.content_source_type;
326: END IF;
327:
328: IF p_financial_number_rec.status IS NULL THEN
325: x_financial_number_rec.content_source_type := p_financial_number_rec.content_source_type;
326: END IF;
327:
328: IF p_financial_number_rec.status IS NULL THEN
329: x_financial_number_rec.status := FND_API.G_MISS_CHAR;
330: ELSIF p_financial_number_rec.status <> FND_API.G_MISS_CHAR THEN
331: x_financial_number_rec.status := p_financial_number_rec.status;
332: END IF;
333:
326: END IF;
327:
328: IF p_financial_number_rec.status IS NULL THEN
329: x_financial_number_rec.status := FND_API.G_MISS_CHAR;
330: ELSIF p_financial_number_rec.status <> FND_API.G_MISS_CHAR THEN
331: x_financial_number_rec.status := p_financial_number_rec.status;
332: END IF;
333:
334: IF p_create_update_flag = 'C' THEN
382: BEGIN
383:
384: -- check required fields:
385: IF p_last_update_date IS NULL OR
386: p_last_update_date = FND_API.G_MISS_DATE
387: THEN
388: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
389: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
390: FND_MSG_PUB.ADD;
387: THEN
388: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
389: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
390: FND_MSG_PUB.ADD;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- get object_version_number
395: BEGIN
403: THEN
404: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
405: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_financial_numbers' );
406: FND_MSG_PUB.ADD;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409: EXCEPTION
410: WHEN NO_DATA_FOUND THEN
411: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
412: FND_MESSAGE.SET_TOKEN( 'RECORD', 'financial numbers' );
413: FND_MESSAGE.SET_TOKEN( 'VALUE',
414: NVL( TO_CHAR( p_financial_number_rec.financial_number_id ), 'null' ) );
415: FND_MSG_PUB.ADD;
416: RAISE FND_API.G_EXC_ERROR;
417: END;
418:
419: -- pre-process v1 and v2 record.
420: v2_financial_number_pre (