APPS.HZ_ORGANIZATION_INFO_V2PVT dependencies on FND_API

Line 25: x_financial_report_rec.financial_report_id := FND_API.G_MISS_NUM;

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:

Line 26: ELSIF p_financial_report_rec.financial_report_id <> FND_API.G_MISS_NUM THEN

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

Line 31: x_financial_report_rec.party_id := FND_API.G_MISS_NUM;

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:

Line 32: ELSIF p_financial_report_rec.party_id <> FND_API.G_MISS_NUM THEN

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

Line 37: x_financial_report_rec.type_of_financial_report := FND_API.G_MISS_CHAR;

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:

Line 38: ELSIF p_financial_report_rec.type_of_financial_report <> FND_API.G_MISS_CHAR THEN

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

Line 43: x_financial_report_rec.document_reference := FND_API.G_MISS_CHAR;

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:

Line 44: ELSIF p_financial_report_rec.document_reference <> FND_API.G_MISS_CHAR THEN

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

Line 49: x_financial_report_rec.date_report_issued := FND_API.G_MISS_DATE;

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:

Line 50: ELSIF p_financial_report_rec.date_report_issued <> FND_API.G_MISS_DATE THEN

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

Line 55: x_financial_report_rec.issued_period := FND_API.G_MISS_CHAR;

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:

Line 56: ELSIF p_financial_report_rec.issued_period <> FND_API.G_MISS_CHAR THEN

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

Line 61: x_financial_report_rec.report_start_date := FND_API.G_MISS_DATE;

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:

Line 62: ELSIF p_financial_report_rec.report_start_date <> FND_API.G_MISS_DATE THEN

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

Line 67: x_financial_report_rec.report_end_date := FND_API.G_MISS_DATE;

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:

Line 68: ELSIF p_financial_report_rec.report_end_date <> FND_API.G_MISS_DATE THEN

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

Line 73: x_financial_report_rec.actual_content_source := FND_API.G_MISS_CHAR;

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:

Line 74: ELSIF p_financial_report_rec.actual_content_source <> FND_API.G_MISS_CHAR THEN

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

Line 79: x_financial_report_rec.requiring_authority := FND_API.G_MISS_CHAR;

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:

Line 80: ELSIF p_financial_report_rec.requiring_authority <> FND_API.G_MISS_CHAR THEN

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

Line 85: x_financial_report_rec.audit_ind := FND_API.G_MISS_CHAR;

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:

Line 86: ELSIF p_financial_report_rec.audit_ind <> FND_API.G_MISS_CHAR THEN

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

Line 91: x_financial_report_rec.consolidated_ind := FND_API.G_MISS_CHAR;

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:

Line 92: ELSIF p_financial_report_rec.consolidated_ind <> FND_API.G_MISS_CHAR THEN

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

Line 97: x_financial_report_rec.estimated_ind := FND_API.G_MISS_CHAR;

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:

Line 98: ELSIF p_financial_report_rec.estimated_ind <> FND_API.G_MISS_CHAR THEN

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

Line 103: x_financial_report_rec.fiscal_ind := FND_API.G_MISS_CHAR;

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:

Line 104: ELSIF p_financial_report_rec.fiscal_ind <> FND_API.G_MISS_CHAR THEN

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

Line 111: x_financial_report_rec.final_ind := FND_API.G_MISS_CHAR;

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:

Line 112: ELSIF p_financial_report_rec.final_ind <> FND_API.G_MISS_CHAR THEN

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

Line 117: x_financial_report_rec.forecast_ind := FND_API.G_MISS_CHAR;

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:

Line 118: ELSIF p_financial_report_rec.forecast_ind <> FND_API.G_MISS_CHAR THEN

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

Line 123: x_financial_report_rec.opening_ind := FND_API.G_MISS_CHAR;

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:

Line 124: ELSIF p_financial_report_rec.opening_ind <> FND_API.G_MISS_CHAR THEN

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

Line 129: x_financial_report_rec.proforma_ind := FND_API.G_MISS_CHAR;

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:

Line 130: ELSIF p_financial_report_rec.proforma_ind <> FND_API.G_MISS_CHAR THEN

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

Line 135: x_financial_report_rec.qualified_ind := FND_API.G_MISS_CHAR;

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:

Line 136: ELSIF p_financial_report_rec.qualified_ind <> FND_API.G_MISS_CHAR THEN

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

Line 141: x_financial_report_rec.restated_ind := FND_API.G_MISS_CHAR;

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:

Line 142: ELSIF p_financial_report_rec.restated_ind <> FND_API.G_MISS_CHAR THEN

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

Line 147: x_financial_report_rec.signed_by_principals_ind := FND_API.G_MISS_CHAR;

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:

Line 148: ELSIF p_financial_report_rec.signed_by_principals_ind <> FND_API.G_MISS_CHAR THEN

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

Line 153: x_financial_report_rec.trial_balance_ind := FND_API.G_MISS_CHAR;

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:

Line 154: ELSIF p_financial_report_rec.trial_balance_ind <> FND_API.G_MISS_CHAR THEN

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

Line 159: x_financial_report_rec.unbalanced_ind := FND_API.G_MISS_CHAR;

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:

Line 160: ELSIF p_financial_report_rec.unbalanced_ind <> FND_API.G_MISS_CHAR THEN

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

Line 165: x_financial_report_rec.status := FND_API.G_MISS_CHAR;

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:

Line 166: ELSIF p_financial_report_rec.status <> FND_API.G_MISS_CHAR THEN

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

Line 222: p_last_update_date = FND_API.G_MISS_DATE

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;

Line 227: RAISE FND_API.G_EXC_ERROR;

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

Line 243: RAISE FND_API.G_EXC_ERROR;

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' );

Line 252: RAISE FND_API.G_EXC_ERROR;

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 (

Line 281: x_financial_number_rec.financial_number_id := FND_API.G_MISS_NUM;

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:

Line 282: ELSIF p_financial_number_rec.financial_number_id <> FND_API.G_MISS_NUM THEN

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

Line 287: x_financial_number_rec.financial_report_id := FND_API.G_MISS_NUM;

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:

Line 288: ELSIF p_financial_number_rec.financial_report_id <> FND_API.G_MISS_NUM THEN

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

Line 293: x_financial_number_rec.financial_number := FND_API.G_MISS_NUM;

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:

Line 294: ELSIF p_financial_number_rec.financial_number <> FND_API.G_MISS_NUM THEN

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

Line 299: x_financial_number_rec.financial_number_name := FND_API.G_MISS_CHAR;

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:

Line 300: ELSIF p_financial_number_rec.financial_number_name <> FND_API.G_MISS_CHAR THEN

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

Line 305: x_financial_number_rec.financial_units_applied := FND_API.G_MISS_NUM;

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:

Line 306: ELSIF p_financial_number_rec.financial_units_applied <> FND_API.G_MISS_NUM THEN

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

Line 311: x_financial_number_rec.financial_number_currency := FND_API.G_MISS_CHAR;

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:

Line 312: ELSIF p_financial_number_rec.financial_number_currency <> FND_API.G_MISS_CHAR THEN

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

Line 317: x_financial_number_rec.projected_actual_flag := FND_API.G_MISS_CHAR;

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:

Line 318: ELSIF p_financial_number_rec.projected_actual_flag <> FND_API.G_MISS_CHAR THEN

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

Line 323: x_financial_number_rec.content_source_type := FND_API.G_MISS_CHAR;

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:

Line 324: ELSIF p_financial_number_rec.content_source_type <> FND_API.G_MISS_CHAR THEN

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

Line 329: x_financial_number_rec.status := FND_API.G_MISS_CHAR;

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:

Line 330: ELSIF p_financial_number_rec.status <> FND_API.G_MISS_CHAR THEN

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

Line 386: p_last_update_date = FND_API.G_MISS_DATE

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;

Line 391: RAISE FND_API.G_EXC_ERROR;

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

Line 407: RAISE FND_API.G_EXC_ERROR;

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' );

Line 416: RAISE FND_API.G_EXC_ERROR;

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 (