DBA Data[Home] [Help]

APPS.CN_PAYGROUP_PVT dependencies on CN_API

Line 101: IF ( (cn_api.chk_miss_char_para

97:
98:
99: -- Check for missing and null parameters.
100:
101: IF ( (cn_api.chk_miss_char_para
102: (p_char_para => p_PayGroup_rec.name,
103: p_para_name =>
104: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
105: p_loading_status => x_loading_status,

Line 104: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),

100:
101: IF ( (cn_api.chk_miss_char_para
102: (p_char_para => p_PayGroup_rec.name,
103: p_para_name =>
104: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
105: p_loading_status => x_loading_status,
106: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
107: THEN
108: RAISE FND_API.G_EXC_ERROR ;

Line 111: IF ( (cn_api.chk_null_char_para

107: THEN
108: RAISE FND_API.G_EXC_ERROR ;
109: END IF;
110:
111: IF ( (cn_api.chk_null_char_para
112: (p_char_para => p_PayGroup_rec.name,
113: p_obj_name =>
114: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
115: p_loading_status => x_loading_status,

Line 114: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),

110:
111: IF ( (cn_api.chk_null_char_para
112: (p_char_para => p_PayGroup_rec.name,
113: p_obj_name =>
114: cn_api.get_lkup_meaning('PAY_GROUP_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
115: p_loading_status => x_loading_status,
116: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
117: THEN
118: RAISE FND_API.G_EXC_ERROR ;

Line 122: IF ( (cn_api.chk_miss_date_para

118: RAISE FND_API.G_EXC_ERROR ;
119: END IF;
120:
121:
122: IF ( (cn_api.chk_miss_date_para
123: (p_date_para => p_PayGroup_rec.start_date,
124: p_para_name =>
125: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
126: p_loading_status => x_loading_status,

Line 125: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),

121:
122: IF ( (cn_api.chk_miss_date_para
123: (p_date_para => p_PayGroup_rec.start_date,
124: p_para_name =>
125: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
126: p_loading_status => x_loading_status,
127: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
128: THEN
129: RAISE FND_API.G_EXC_ERROR ;

Line 132: IF ( (cn_api.chk_null_date_para

128: THEN
129: RAISE FND_API.G_EXC_ERROR ;
130: END IF;
131:
132: IF ( (cn_api.chk_null_date_para
133: (p_date_para => p_PayGroup_rec.start_date,
134: p_obj_name =>
135: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
136: p_loading_status => x_loading_status,

Line 135: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),

131:
132: IF ( (cn_api.chk_null_date_para
133: (p_date_para => p_PayGroup_rec.start_date,
134: p_obj_name =>
135: cn_api.get_lkup_meaning('START_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
136: p_loading_status => x_loading_status,
137: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
138: THEN
139: RAISE FND_API.G_EXC_ERROR ;

Line 142: IF ( (cn_api.chk_miss_date_para

138: THEN
139: RAISE FND_API.G_EXC_ERROR ;
140: END IF;
141:
142: IF ( (cn_api.chk_miss_date_para
143: (p_date_para => p_PayGroup_rec.end_date,
144: p_para_name =>
145: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
146: p_loading_status => x_loading_status,

Line 145: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),

141:
142: IF ( (cn_api.chk_miss_date_para
143: (p_date_para => p_PayGroup_rec.end_date,
144: p_para_name =>
145: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
146: p_loading_status => x_loading_status,
147: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
148: THEN
149: RAISE FND_API.G_EXC_ERROR ;

Line 152: IF ( (cn_api.chk_null_date_para

148: THEN
149: RAISE FND_API.G_EXC_ERROR ;
150: END IF;
151:
152: IF ( (cn_api.chk_null_date_para
153: (p_date_para => p_PayGroup_rec.end_date,
154: p_obj_name =>
155: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
156: p_loading_status => x_loading_status,

Line 155: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),

151:
152: IF ( (cn_api.chk_null_date_para
153: (p_date_para => p_PayGroup_rec.end_date,
154: p_obj_name =>
155: cn_api.get_lkup_meaning('END_DATE', 'PAY_GROUP_VALIDATION_TYPE'),
156: p_loading_status => x_loading_status,
157: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
158: THEN
159: RAISE FND_API.G_EXC_ERROR ;

Line 162: IF ( (cn_api.chk_miss_num_para

158: THEN
159: RAISE FND_API.G_EXC_ERROR ;
160: END IF;
161:
162: IF ( (cn_api.chk_miss_num_para
163: (p_num_para => p_PayGroup_rec.org_id,
164: p_para_name =>
165: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),
166: p_loading_status => x_loading_status,

Line 165: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),

161:
162: IF ( (cn_api.chk_miss_num_para
163: (p_num_para => p_PayGroup_rec.org_id,
164: p_para_name =>
165: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),
166: p_loading_status => x_loading_status,
167: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
168: THEN
169: RAISE FND_API.G_EXC_ERROR ;

Line 172: IF ( (cn_api.chk_null_num_para

168: THEN
169: RAISE FND_API.G_EXC_ERROR ;
170: END IF;
171:
172: IF ( (cn_api.chk_null_num_para
173: (p_num_para => p_PayGroup_rec.org_id,
174: p_obj_name =>
175: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),
176: p_loading_status => x_loading_status,

Line 175: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),

171:
172: IF ( (cn_api.chk_null_num_para
173: (p_num_para => p_PayGroup_rec.org_id,
174: p_obj_name =>
175: cn_api.get_lkup_meaning('ORG_ID', 'PAY_GROUP_VALIDATION_TYPE'),
176: p_loading_status => x_loading_status,
177: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
178: THEN
179: RAISE FND_API.G_EXC_ERROR ;

Line 182: IF ( (cn_api.chk_miss_char_para

178: THEN
179: RAISE FND_API.G_EXC_ERROR ;
180: END IF;
181:
182: IF ( (cn_api.chk_miss_char_para
183: (p_char_para => p_PayGroup_rec.period_set_name,
184: p_para_name =>
185: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
186: p_loading_status => x_loading_status,

Line 185: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),

181:
182: IF ( (cn_api.chk_miss_char_para
183: (p_char_para => p_PayGroup_rec.period_set_name,
184: p_para_name =>
185: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
186: p_loading_status => x_loading_status,
187: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
188: THEN
189: RAISE FND_API.G_EXC_ERROR ;

Line 192: IF ( (cn_api.chk_null_char_para

188: THEN
189: RAISE FND_API.G_EXC_ERROR ;
190: END IF;
191:
192: IF ( (cn_api.chk_null_char_para
193: (p_char_para => p_PayGroup_rec.period_set_name,
194: p_obj_name =>
195: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
196: p_loading_status => x_loading_status,

Line 195: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),

191:
192: IF ( (cn_api.chk_null_char_para
193: (p_char_para => p_PayGroup_rec.period_set_name,
194: p_obj_name =>
195: cn_api.get_lkup_meaning('PERIOD_SET_NAME', 'PAY_GROUP_VALIDATION_TYPE'),
196: p_loading_status => x_loading_status,
197: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
198: THEN
199: RAISE FND_API.G_EXC_ERROR ;

Line 202: IF ( (cn_api.chk_miss_char_para

198: THEN
199: RAISE FND_API.G_EXC_ERROR ;
200: END IF;
201:
202: IF ( (cn_api.chk_miss_char_para
203: (p_char_para => p_PayGroup_rec.period_type,
204: p_para_name =>
205: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),
206: p_loading_status => x_loading_status,

Line 205: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),

201:
202: IF ( (cn_api.chk_miss_char_para
203: (p_char_para => p_PayGroup_rec.period_type,
204: p_para_name =>
205: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),
206: p_loading_status => x_loading_status,
207: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
208: THEN
209: RAISE FND_API.G_EXC_ERROR ;

Line 212: IF ( (cn_api.chk_null_char_para

208: THEN
209: RAISE FND_API.G_EXC_ERROR ;
210: END IF;
211:
212: IF ( (cn_api.chk_null_char_para
213: (p_char_para => p_PayGroup_rec.period_type,
214: p_obj_name =>
215: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),
216: p_loading_status => x_loading_status,

Line 215: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),

211:
212: IF ( (cn_api.chk_null_char_para
213: (p_char_para => p_PayGroup_rec.period_type,
214: p_obj_name =>
215: cn_api.get_lkup_meaning('PERIOD_TYPE', 'PAY_GROUP_VALIDATION_TYPE'),
216: p_loading_status => x_loading_status,
217: x_loading_status => x_loading_status)) = FND_API.G_TRUE )
218: THEN
219: RAISE FND_API.G_EXC_ERROR ;

Line 1012: l_period_set_id := cn_api.g_miss_id;

1008:
1009:
1010: CLOSE get_period_set_id;
1011: ELSE
1012: l_period_set_id := cn_api.g_miss_id;
1013: END IF;
1014:
1015: --Check if period_type is valid
1016: IF p_paygroup_rec.period_type IS NOT NULL

Line 1036: l_period_type_id := cn_api.g_miss_id;

1032: END IF;
1033:
1034: CLOSE get_period_type_id;
1035: ELSE
1036: l_period_type_id := cn_api.g_miss_id;
1037: END IF;
1038:
1039: select 1 into l_valid_data from dual where exists
1040: (select count(cp.pay_date) from