268: -- API body
269:
270: --Check for null and missing parameters in the p_rule_rec parameter
271:
272: /* IF (cn_api.chk_null_num_para
273: ( p_rule_rec.ruleset_id,
274: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
275: x_loading_status,
276: x_loading_status) = FND_API.G_TRUE )
270: --Check for null and missing parameters in the p_rule_rec parameter
271:
272: /* IF (cn_api.chk_null_num_para
273: ( p_rule_rec.ruleset_id,
274: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
275: x_loading_status,
276: x_loading_status) = FND_API.G_TRUE )
277: THEN
278: RAISE fnd_api.g_exc_error;
277: THEN
278: RAISE fnd_api.g_exc_error;
279: END IF;
280:
281: IF (cn_api.chk_null_num_para
282: ( p_rule_rec.rule_id,
283: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
284: x_loading_status,
285: x_loading_status) = FND_API.G_TRUE )
279: END IF;
280:
281: IF (cn_api.chk_null_num_para
282: ( p_rule_rec.rule_id,
283: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
284: x_loading_status,
285: x_loading_status) = FND_API.G_TRUE )
286: THEN
287: RAISE fnd_api.g_exc_error;
288: END IF;
289:
290: */
291:
292: IF (cn_api.chk_null_char_para
293: ( p_rule_rec.rule_name,
294: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
295: x_loading_status,
296: x_loading_status) = FND_API.G_TRUE )
290: */
291:
292: IF (cn_api.chk_null_char_para
293: ( p_rule_rec.rule_name,
294: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
295: x_loading_status,
296: x_loading_status) = FND_API.G_TRUE )
297: THEN
298: RAISE fnd_api.g_exc_error;
296: x_loading_status) = FND_API.G_TRUE )
297: THEN
298: RAISE fnd_api.g_exc_error;
299: END IF;
300: IF (cn_api.chk_null_num_para
301: ( p_rule_rec.parent_rule_id,
302: cn_api.get_lkup_meaning('PARENT_RULE_ID', 'RULESET_TYPE'),
303: x_loading_status,
304: x_loading_status) = FND_API.G_TRUE )
298: RAISE fnd_api.g_exc_error;
299: END IF;
300: IF (cn_api.chk_null_num_para
301: ( p_rule_rec.parent_rule_id,
302: cn_api.get_lkup_meaning('PARENT_RULE_ID', 'RULESET_TYPE'),
303: x_loading_status,
304: x_loading_status) = FND_API.G_TRUE )
305: THEN
306: RAISE fnd_api.g_exc_error;
305: THEN
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: /* IF (cn_api.chk_null_num_para
310: ( p_rule_rec.parent_rule_id,
311: cn_api.get_lkup_meaning('SEQUENCE_NUMBER', 'RULESET_TYPE'),
312: x_loading_status,
313: x_loading_status) = FND_API.G_TRUE )
307: END IF;
308:
309: /* IF (cn_api.chk_null_num_para
310: ( p_rule_rec.parent_rule_id,
311: cn_api.get_lkup_meaning('SEQUENCE_NUMBER', 'RULESET_TYPE'),
312: x_loading_status,
313: x_loading_status) = FND_API.G_TRUE )
314: THEN
315: RAISE fnd_api.g_exc_error;
553:
554:
555: --Check for missing parameters in the p_rule_rec parameter
556:
557: IF (cn_api.chk_null_num_para
558: ( p_old_rule_rec.ruleset_id,
559: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
560: x_loading_status,
561: x_loading_status) = FND_API.G_TRUE )
555: --Check for missing parameters in the p_rule_rec parameter
556:
557: IF (cn_api.chk_null_num_para
558: ( p_old_rule_rec.ruleset_id,
559: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
560: x_loading_status,
561: x_loading_status) = FND_API.G_TRUE )
562: THEN
563: RAISE fnd_api.g_exc_error;
561: x_loading_status) = FND_API.G_TRUE )
562: THEN
563: RAISE fnd_api.g_exc_error;
564: END IF;
565: IF (cn_api.chk_null_num_para
566: ( p_old_rule_rec.rule_id,
567: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
568: x_loading_status,
569: x_loading_status) = FND_API.G_TRUE )
563: RAISE fnd_api.g_exc_error;
564: END IF;
565: IF (cn_api.chk_null_num_para
566: ( p_old_rule_rec.rule_id,
567: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
568: x_loading_status,
569: x_loading_status) = FND_API.G_TRUE )
570: THEN
571: RAISE fnd_api.g_exc_error;
569: x_loading_status) = FND_API.G_TRUE )
570: THEN
571: RAISE fnd_api.g_exc_error;
572: END IF;
573: IF (cn_api.chk_null_char_para
574: ( p_old_rule_rec.rule_name,
575: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
576: x_loading_status,
577: x_loading_status) = FND_API.G_TRUE )
571: RAISE fnd_api.g_exc_error;
572: END IF;
573: IF (cn_api.chk_null_char_para
574: ( p_old_rule_rec.rule_name,
575: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
576: x_loading_status,
577: x_loading_status) = FND_API.G_TRUE )
578: THEN
579: RAISE fnd_api.g_exc_error;
577: x_loading_status) = FND_API.G_TRUE )
578: THEN
579: RAISE fnd_api.g_exc_error;
580: END IF;
581: IF (cn_api.chk_null_num_para
582: ( p_old_rule_rec.parent_rule_id,
583: cn_api.get_lkup_meaning('PARENT_RULE_ID', 'RULESET_TYPE'),
584: x_loading_status,
585: x_loading_status) = FND_API.G_TRUE )
579: RAISE fnd_api.g_exc_error;
580: END IF;
581: IF (cn_api.chk_null_num_para
582: ( p_old_rule_rec.parent_rule_id,
583: cn_api.get_lkup_meaning('PARENT_RULE_ID', 'RULESET_TYPE'),
584: x_loading_status,
585: x_loading_status) = FND_API.G_TRUE )
586: THEN
587: RAISE fnd_api.g_exc_error;
585: x_loading_status) = FND_API.G_TRUE )
586: THEN
587: RAISE fnd_api.g_exc_error;
588: END IF;
589: IF (cn_api.chk_null_num_para
590: ( p_old_rule_rec.parent_rule_id,
591: cn_api.get_lkup_meaning('SEQUENCE_NUMBER', 'RULESET_TYPE'),
592: x_loading_status,
593: x_loading_status) = FND_API.G_TRUE )
587: RAISE fnd_api.g_exc_error;
588: END IF;
589: IF (cn_api.chk_null_num_para
590: ( p_old_rule_rec.parent_rule_id,
591: cn_api.get_lkup_meaning('SEQUENCE_NUMBER', 'RULESET_TYPE'),
592: x_loading_status,
593: x_loading_status) = FND_API.G_TRUE )
594: THEN
595: RAISE fnd_api.g_exc_error;
596: END IF;
597:
598:
599:
600: IF (cn_api.chk_null_num_para
601: ( p_rule_rec.ruleset_id,
602: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
603: x_loading_status,
604: x_loading_status) = FND_API.G_TRUE )
598:
599:
600: IF (cn_api.chk_null_num_para
601: ( p_rule_rec.ruleset_id,
602: cn_api.get_lkup_meaning('RULESET_ID', 'RULESET_TYPE'),
603: x_loading_status,
604: x_loading_status) = FND_API.G_TRUE )
605: THEN
606: RAISE fnd_api.g_exc_error;
604: x_loading_status) = FND_API.G_TRUE )
605: THEN
606: RAISE fnd_api.g_exc_error;
607: END IF;
608: IF (cn_api.chk_null_num_para
609: ( p_rule_rec.rule_id,
610: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
611: x_loading_status,
612: x_loading_status) = FND_API.G_TRUE )
606: RAISE fnd_api.g_exc_error;
607: END IF;
608: IF (cn_api.chk_null_num_para
609: ( p_rule_rec.rule_id,
610: cn_api.get_lkup_meaning('RULE_ID', 'RULESET_TYPE'),
611: x_loading_status,
612: x_loading_status) = FND_API.G_TRUE )
613: THEN
614: RAISE fnd_api.g_exc_error;
612: x_loading_status) = FND_API.G_TRUE )
613: THEN
614: RAISE fnd_api.g_exc_error;
615: END IF;
616: IF (cn_api.chk_null_char_para
617: ( p_rule_rec.rule_name,
618: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
619: x_loading_status,
620: x_loading_status) = FND_API.G_TRUE )
614: RAISE fnd_api.g_exc_error;
615: END IF;
616: IF (cn_api.chk_null_char_para
617: ( p_rule_rec.rule_name,
618: cn_api.get_lkup_meaning('RULE_NAME', 'RULESET_TYPE'),
619: x_loading_status,
620: x_loading_status) = FND_API.G_TRUE )
621: THEN
622: RAISE fnd_api.g_exc_error;
620: x_loading_status) = FND_API.G_TRUE )
621: THEN
622: RAISE fnd_api.g_exc_error;
623: END IF;
624: IF (cn_api.chk_null_num_para
625: ( p_rule_rec.parent_rule_id,
626: cn_api.get_lkup_meaning('PARENT_RULE_ID', 'RULESET_TYPE'),
627: x_loading_status,
628: x_loading_status) = FND_API.G_TRUE )
622: RAISE fnd_api.g_exc_error;
623: END IF;
624: IF (cn_api.chk_null_num_para
625: ( p_rule_rec.parent_rule_id,
626: cn_api.get_lkup_meaning('PARENT_RULE_ID', 'RULESET_TYPE'),
627: x_loading_status,
628: x_loading_status) = FND_API.G_TRUE )
629: THEN
630: RAISE fnd_api.g_exc_error;
628: x_loading_status) = FND_API.G_TRUE )
629: THEN
630: RAISE fnd_api.g_exc_error;
631: END IF;
632: IF (cn_api.chk_null_num_para
633: ( p_rule_rec.parent_rule_id,
634: cn_api.get_lkup_meaning('SEQUENCE_NUMBER', 'RULESET_TYPE'),
635: x_loading_status,
636: x_loading_status) = FND_API.G_TRUE )
630: RAISE fnd_api.g_exc_error;
631: END IF;
632: IF (cn_api.chk_null_num_para
633: ( p_rule_rec.parent_rule_id,
634: cn_api.get_lkup_meaning('SEQUENCE_NUMBER', 'RULESET_TYPE'),
635: x_loading_status,
636: x_loading_status) = FND_API.G_TRUE )
637: THEN
638: RAISE fnd_api.g_exc_error;
1134: end if;
1135:
1136: if l_liability_ccid IS NOT NULL
1137: then
1138: cn_api.get_ccid_disp(l_liability_ccid,
1139: l_liability_ccid_disp,
1140: l_org_id);
1141:
1142: end if;
1142: end if;
1143:
1144: if l_expense_ccid IS NOT NULL
1145: then
1146: cn_api.get_ccid_disp(l_expense_ccid,
1147: l_expense_ccid_disp,
1148: l_org_id);
1149: end if;
1150:
1252:
1253: BEGIN
1254:
1255: --get all the lookup meanings
1256: l_bet := cn_api.get_lkup_meaning('BET','Expression Messages');
1257: l_is := cn_api.get_lkup_meaning('IS','Expression Messages');
1258: l_not := cn_api.get_lkup_meaning('NOT','Expression Messages');
1259: l_is_bet := l_is || ' ' || l_bet;
1260: l_is_not_bet := l_is || ' ' || l_not || ' ' || l_bet;
1253: BEGIN
1254:
1255: --get all the lookup meanings
1256: l_bet := cn_api.get_lkup_meaning('BET','Expression Messages');
1257: l_is := cn_api.get_lkup_meaning('IS','Expression Messages');
1258: l_not := cn_api.get_lkup_meaning('NOT','Expression Messages');
1259: l_is_bet := l_is || ' ' || l_bet;
1260: l_is_not_bet := l_is || ' ' || l_not || ' ' || l_bet;
1261: l_and := cn_api.get_lkup_meaning('AND','Expression Messages');
1254:
1255: --get all the lookup meanings
1256: l_bet := cn_api.get_lkup_meaning('BET','Expression Messages');
1257: l_is := cn_api.get_lkup_meaning('IS','Expression Messages');
1258: l_not := cn_api.get_lkup_meaning('NOT','Expression Messages');
1259: l_is_bet := l_is || ' ' || l_bet;
1260: l_is_not_bet := l_is || ' ' || l_not || ' ' || l_bet;
1261: l_and := cn_api.get_lkup_meaning('AND','Expression Messages');
1262: l_desc := cn_api.get_lkup_meaning('DESCENDANT','Expression Messages');
1257: l_is := cn_api.get_lkup_meaning('IS','Expression Messages');
1258: l_not := cn_api.get_lkup_meaning('NOT','Expression Messages');
1259: l_is_bet := l_is || ' ' || l_bet;
1260: l_is_not_bet := l_is || ' ' || l_not || ' ' || l_bet;
1261: l_and := cn_api.get_lkup_meaning('AND','Expression Messages');
1262: l_desc := cn_api.get_lkup_meaning('DESCENDANT','Expression Messages');
1263: l_hier := cn_api.get_lkup_meaning('IIH','Expression Messages');
1264: l_not_desc := l_is || ' ' || l_not || ' ' || l_desc;
1265: l_desc := l_is || ' ' || l_desc;
1258: l_not := cn_api.get_lkup_meaning('NOT','Expression Messages');
1259: l_is_bet := l_is || ' ' || l_bet;
1260: l_is_not_bet := l_is || ' ' || l_not || ' ' || l_bet;
1261: l_and := cn_api.get_lkup_meaning('AND','Expression Messages');
1262: l_desc := cn_api.get_lkup_meaning('DESCENDANT','Expression Messages');
1263: l_hier := cn_api.get_lkup_meaning('IIH','Expression Messages');
1264: l_not_desc := l_is || ' ' || l_not || ' ' || l_desc;
1265: l_desc := l_is || ' ' || l_desc;
1266:
1259: l_is_bet := l_is || ' ' || l_bet;
1260: l_is_not_bet := l_is || ' ' || l_not || ' ' || l_bet;
1261: l_and := cn_api.get_lkup_meaning('AND','Expression Messages');
1262: l_desc := cn_api.get_lkup_meaning('DESCENDANT','Expression Messages');
1263: l_hier := cn_api.get_lkup_meaning('IIH','Expression Messages');
1264: l_not_desc := l_is || ' ' || l_not || ' ' || l_desc;
1265: l_desc := l_is || ' ' || l_desc;
1266:
1267: