APPS.ICX_API_REGION dependencies on HTP

Line 58: htp.p(SQLERRM);

54: raise;
55:
56: when DUP_VAL_ON_INDEX then
57: rollback;
58: htp.p(SQLERRM);
59:
60: when OTHERS then
61: rollback;
62: htp.p(SQLERRM);

Line 62: htp.p(SQLERRM);

58: htp.p(SQLERRM);
59:
60: when OTHERS then
61: rollback;
62: htp.p(SQLERRM);
63:
64: end create_main_region;
65:
66:

Line 372: htp.p(SQLERRM);

368: exception
369: when REGION_VALIDATION_EXCEPTION then
370: raise;
371: when NO_DATA_FOUND then
372: htp.p(SQLERRM);
373: raise;
374: when DUP_VAL_ON_INDEX then
375: rollback;
376: htp.p(SQLERRM);

Line 376: htp.p(SQLERRM);

372: htp.p(SQLERRM);
373: raise;
374: when DUP_VAL_ON_INDEX then
375: rollback;
376: htp.p(SQLERRM);
377: raise;
378:
379: when OTHERS then
380: rollback;

Line 381: htp.p(SQLERRM);

377: raise;
378:
379: when OTHERS then
380: rollback;
381: htp.p(SQLERRM);
382: raise;
383:
384: end split_region;
385:

Line 494: htp.p(SQLERRM);

490: when REGION_VALIDATION_EXCEPTION then
491: raise;
492:
493: when NO_DATA_FOUND then
494: htp.p(SQLERRM);
495: raise;
496:
497: when OTHERS then
498: rollback;

Line 499: htp.p(SQLERRM);

495: raise;
496:
497: when OTHERS then
498: rollback;
499: htp.p(SQLERRM);
500: raise;
501:
502: end delete_region;
503:

Line 616: htp.p(SQLERRM);

612:
613: exception
614: when DUP_VAL_ON_INDEX then
615: rollback;
616: htp.p(SQLERRM);
617: raise;
618:
619: when OTHERS then
620: rollback;

Line 621: htp.p(SQLERRM);

617: raise;
618:
619: when OTHERS then
620: rollback;
621: htp.p(SQLERRM);
622: raise;
623:
624: end add_region;
625:

Line 697: htp.p(SQLERRM);

693:
694: exception
695:
696: when OTHERS then
697: htp.p(SQLERRM);
698: raise;
699:
700: end get_child_region_list;
701:

Line 806: htp.p(SQLERRM);

802: end loop;
803:
804: exception
805: when others then
806: htp.p(SQLERRM);
807: end;
808:
809:
810: procedure copy_child_regions (

Line 886: htp.p(SQLERRM);

882: when REGION_VALIDATION_EXCEPTION then
883: raise;
884:
885: when NO_DATA_FOUND then
886: htp.p(SQLERRM);
887: raise;
888:
889: when DUP_VAL_ON_INDEX then
890: rollback;

Line 891: htp.p(SQLERRM);

887: raise;
888:
889: when DUP_VAL_ON_INDEX then
890: rollback;
891: htp.p(SQLERRM);
892: raise;
893:
894: when OTHERS then
895: rollback;

Line 896: htp.p(SQLERRM);

892: raise;
893:
894: when OTHERS then
895: rollback;
896: htp.p(SQLERRM);
897: raise;
898:
899: end copy_child_regions;
900:

Line 945: htp.p(SQLERRM);

941: return l_region;
942:
943: exception
944: when others then
945: htp.p(SQLERRM);
946: end get_main_region_record;
947:
948:
949: end ICX_API_REGION;