APPS.PA_ADVERTISEMENTS_PUB dependencies on PA_UTILS

Line 209: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

205:
206: -- CHECK 1: if there is no such action line, returns error
207: IF l_undeleted_action_code_tbl.COUNT=0 THEN
208:
209: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
210: ,p_msg_name => 'PA_NO_ACTION_LINE');
211:
212: -- CHECK 2: if Escalate to Next Level is the only action line, returns error
213: ELSIF l_action_code_tbl.COUNT = 1 AND

Line 216: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

212: -- CHECK 2: if Escalate to Next Level is the only action line, returns error
213: ELSIF l_action_code_tbl.COUNT = 1 AND
214: l_action_code_tbl(1)='ADVERTISEMENT_ESC_TO_NEXT_LVL' THEN
215:
216: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
217: ,p_msg_name => 'PA_ADV_ESC_NEXT_LVL_ERR');
218:
219: -- CHECK 3: if there are more than 1 action lines,
220: -- further validation is needed

Line 251: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

247: CLOSE check_pub_to_org_exists;
248:
249: IF l_pub_to_org_line_id IS NULL THEN
250:
251: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
252: ,p_msg_name => 'PA_ADV_ESC_NEXT_LVL_ERR');
253: END IF;
254:
255: -- CHECK 6: if this is template action set,

Line 283: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

279: -- CHECK 6.1: If these lines use different condition code,
280: -- returns error
281: IF l_condition_code_tbl(i) <> l_condition_code_tbl(i-1) THEN
282:
283: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
284: ,p_msg_name => 'PA_ADV_DIFF_COND_ERR');
285: EXIT; -- exit the loop
286: END IF;
287:

Line 294: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

290: -- then returns error
291: IF l_condition_code_tbl(i) = 'ADVERTISEMENT_DAYS_OPN_REMAIN' AND
292: to_number(l_condition_attribute2_tbl(i)) > to_number(l_condition_attribute2_tbl(i-1)) THEN
293:
294: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
295: ,p_msg_name => 'PA_ADV_COND_ATT_ERR');
296: EXIT; -- exit the loop
297:
298: END IF;

Line 310: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

306: CLOSE check_pub_to_org_in_template;
307:
308: IF l_pub_to_org_line_id IS NULL THEN
309:
310: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
311: ,p_msg_name => 'PA_ADV_ESC_NEXT_LVL_ERR');
312: END IF;
313:
314: END IF; -- if it is requirement and advertisement has been started